Competitions Lock and Load Comp - III (2020)

Tails

Leadership Group
Joined
8 Oct 2018
Messages
4,617
Likes
10,150
AFL Club
Port Adelaide
Can I ask what PF score refers to/how it is calculated please?

Liking that this comp is seemingly unaffected by the bye!
Also keep in mind that only the top 16 player scores for each team count so the "averages" could be a bit misleading ...

- Ie. what I'm seeing at the moment is total player involvement scores but that is not how it actually works .... well I think so ... plenty of time to fine tune though !!
 
Joined
30 Jun 2012
Messages
3,197
Likes
2,280
AFL Club
Brisbane
Can I ask what PF score refers to/how it is calculated please?
Liking that this comp is seemingly unaffected by the bye!
Cheers!

Have fixed the missing TBrown data - had accidentally hidden a line - will update soon.

PF stands for Points Final as apposed to points for H2H. Remember it was supposed to look like this (NOT APPLICABLE TO THIS SEASON):

1592727109263.png

Also keep in mind that only the best 16 player scores count so the "averages" could be a bit misleading ...
Tails, yes, it is a misleading bit of data - will give a final average out of 30. Once all 30 players have played and is pinned to the players played column. I think I can tinker with it to only give the amount played... but maybe not tonight.
 
Joined
30 Jun 2012
Messages
3,197
Likes
2,280
AFL Club
Brisbane
Also keep in mind that only the top 16 player scores for each team count so the "averages" could be a bit misleading ...

- Ie. what I'm seeing at the moment is total player involvement scores but that is not how it actually works .... well I think so ... plenty of time to fine tune though !!
Still, it makes for a pretty amusing stat... highest average ... lowest score. ha ha

1592730844307.png
 

Tails

Leadership Group
Joined
8 Oct 2018
Messages
4,617
Likes
10,150
AFL Club
Port Adelaide
Still, it makes for a pretty amusing stat... highest average ... lowest score. ha ha

View attachment 18005
lol ... for now ... but I've planned further ahead than one round :) .... well I think I have ...

- will probably hit the second year blues though looking at some of the other sides :)
 
Joined
30 Jun 2012
Messages
3,197
Likes
2,280
AFL Club
Brisbane
OK - When the Essendon v Melbourne game goes ahead (no matter when) results for week 3 will be updated. Until then though, this is the never ending round. Well done doc ron for claiming poll spot. I reckon even with the Melbourne and Essendon players, you'd be on top here.


1592751562825.png


Also, I think starting next week, I will keep the W3 played stat, but change the 'Week 3 ave' so it only averages the top 16 and Captain.

EDIT: Rowell scoresd at 147 changed to 141. As we all own him, it doesn't matter so much this week when we all have him in our best 16. THanks Beg2Differ for the spot. I should have an extra column for bonus points when people spot data entry errors etc.
 
Last edited:
Joined
15 Mar 2019
Messages
2,767
Likes
8,703
AFL Club
Hawthorn
OK - When the Essendon v Melbourne game goes ahead (no matter when) results for week 3 will be updated. Until then though, this is the never ending round. Well done doc ron for claiming poll spot. I reckon even with the Melbourne and Essendon players, you'd be on top here.


View attachment 18010


Also, I think starting next week, I will keep the W3 played stat, but change the 'Week 3 ave' so it only averages the top 16 and Captain.
Are these numbers right? I just checked the top two, but it looks like Doc Ron only has 3 MEL/ESS players, I have 5. Looks like the "played" column isn't adding up right?
 
Joined
30 Jun 2012
Messages
3,197
Likes
2,280
AFL Club
Brisbane
Are these numbers right? I just checked the top two, but it looks like Doc Ron only has 3 MEL/ESS players, I have 5. Looks like the "played" column isn't adding up right?
Quite possible there are some errors in this first week with the new excel file. I'll take a squiz now

ok - Numbers are correct, but they are also not. The thing is, I have it so the spreadsheet only counts numbers other than 0 and so doesn't distinguish between a non-selected player and the melbourne/Essendon crew at this stage.

You can see what it looks like here:
1592745717600.png

Great team by the way!

Cheers
 
Last edited:
Joined
22 Oct 2014
Messages
1,791
Likes
4,974
AFL Club
North Melb.
I have calculated my score as 1855 rather than 1861 as follows. From above I can see you have Matt Rowell has 147 whereas I think it should be 141.

1592750420147.png

If you want to post or PM me all the teams as text (rather than as picture) then I will check them all if you want.
 
Joined
30 Jun 2012
Messages
3,197
Likes
2,280
AFL Club
Brisbane
I have calculated my score as 1855 rather than 1861 as follows. From above I can see you have Matt Rowell has 147 whereas I think it should be 141.


If you want to post or PM me all the teams as text (rather than as picture) then I will check them all if you want.
Absolutely will take up that offer.

I'm finding the waiting for final scores bit the annoying part and am certain that I am/will be popping in prematurely finalised scores. Will correct then send you the team data now

Thanks!
 
Last edited:
Top