Competitions Lock and Load Comp - III (2020)

[Beijing_Sting]

 

[Beijing_Sting]

Have added Melbourne and Essendon as zeros - will enter scores if/when they play this missing round,

 

[Herbie66]

View attachment 17982

quite happy to finish the comp now ?

 

[Ironhawk]

The way things are going I expect my L&L team to challenge my main SC team most week, and it has 4 less scores counting.

Good average score so far.

 

[Beijing_Sting]

Will this be the neverending round?



EDIT: UPDATED MISSING T.BROWN

 

[Beijing_Sting]

Edit to include Tyler BROWN

 

[Darkie]

Will this be the neverending round?

View attachment 17998

Can I ask what PF score refers to/how it is calculated please?

Liking that this comp is seemingly unaffected by the bye!

 

[Beijing_Sting]

Keep your eyes out for mistakes - just found one - No TBrown data, will update after the final match

 

[Tails]

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 !!

 

[Beijing_Sting]

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):

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.

 

[Beijing_Sting]

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

 

[Tails]

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

 

[doc ron]

End it now.

 

[Beijing_Sting]

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.





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.

 

[Beijing_Sting]

And... the unfinished friendlies ;-)



Possible this bunch may be punctuated at some stage.

EDIT: ROWELL scored at 147 - Corrected to 141.

 

[Ironhawk]

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?

 

[Beijing_Sting]

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:


Great team by the way!

Cheers

 

[Beg2Differ]

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.

 

[Beijing_Sting]

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!

 

[doc ron]

Finally I get something right.