Competitions Lock and Load Comp - III (2020)

Joined
15 Mar 2019
Messages
4,069
Likes
13,587
AFL Club
Hawthorn
The following team would have scored the maximum score that could have been achieved in the Lock & Load comp this year. That score was 36,712 (avg 2040) and compares to @Beijing_Sting's winning score of 28,762 (avg 1598).

View attachment 22015
This comp started in Rd 3. Does the best possible team change based on that?
 
Joined
22 Oct 2014
Messages
2,384
Likes
8,086
AFL Club
North Melb.
This is the corrected maximum score now based on a round 3 start which I forgot about when I posted the first team. The max score is now 32,903 which came at an average of 2,056. Interesting that now every player has had their score used at least once.

1601305051479.png
 
Joined
30 Jun 2012
Messages
3,453
Likes
3,566
AFL Club
Brisbane
This is the corrected maximum score now based on a round 3 start which I forgot about when I posted the first team. The max score is now 32,903 which came at an average of 2,056. Interesting that now every player has had their score used at least once.

View attachment 22020
Oh wow! this is so awesome!

I am so interested in this... I have another request though!!! I really wonder what the highest-scoring team looked like after 2 rounds? How did they end up going... Hard to know I suppose, as I guess the full data impossible to uncover - the rookies would have to be hit and miss as not included in the top team stats... but if we just add in the most popular rookies (and any others) that would give a good indication as to what this team might have looked like and how it would have gone in the long run. Good data for next year ... Love this highest-scoring spreadsheet voodoo that you do!
 
Last edited:
Joined
22 Oct 2014
Messages
2,384
Likes
8,086
AFL Club
North Melb.
Oh wow! this is so awesome!

I am so interested in this... I have another request though!!! I really wonder what the highest-scoring team looked like after 2 rounds? How did they end up going... Hard to know I suppose, as I guess the full data impossible to uncover - the rookies would have to be hit and miss as not included in the top team stats... but if we just add in the most popular rookies (and any others) that would give a good indication as to what this team might have looked like and how it would have gone in the long run. Good data for next year ... Love this highest-scoring spreadsheet voodoo that you do!
I can work this out but don‘t quite follow why highest after 2 rounds is that significant. I assume you mean after 2 rounds of this comp so therefore after round 4.
 
Joined
15 Mar 2019
Messages
4,069
Likes
13,587
AFL Club
Hawthorn
I can work this out but don‘t quite follow why highest after 2 rounds is that significant. I assume you mean after 2 rounds of this comp so therefore after round 4.
I know that I chose a lot of players who were good in Rd 1 and 2 (i.e Rozee) who then dropped off in form. I think he is after a team which had the best players from the first two rounds (who a lot of us would have selected in our own teams) to compare this to the best possible team for the rest of the season.
 
Joined
22 Oct 2014
Messages
2,384
Likes
8,086
AFL Club
North Melb.
I know that I chose a lot of players who were good in Rd 1 and 2 (i.e Rozee) who then dropped off in form. I think he is after a team which had the best players from the first two rounds (who a lot of us would have selected in our own teams) to compare this to the best possible team for the rest of the season.
Ok I get it now. The follows shows that outcome however selecting the best team after just 2 rounds leaves you with a lot of low priced doughnuts which compromises that team significantly as the season goes on.

For this to be of a little more value I think I would need to add a constraint to reduce or eliminate the non-scoring players in round 1 and 2.

1601363655092.png
 
Joined
22 Oct 2014
Messages
2,384
Likes
8,086
AFL Club
North Melb.
This scenario works out the team that would have scored the highest after round 2 considering only players that played in both rounds. It then works out what that team would have scored for the Lock & Load comp. Interestingly the score of 27,013 would have only been good enough to finish 13th (which is ironically where I finished :rolleyes:)

1601364934120.png
 
Top