Competitions Lock and Load Comp - III (2020)

[Ironhawk]

Isn’t 16 the magic number? You are one of those too, so all good!

You're right, been a long day. Was thinking regular SC, forgot only top 16 count. Zzz.

 

[Beijing_Sting]

Hmmm. On the bottom, I see. Ha.

ok - Keep finding errors please, as the more I find now the easier nd smoother it will be to run. Is a shame there is no head to head this year though. I had themed colours all the way through...

Cheers.

 

[Tails]

Hmmm. On the bottom, I see. Ha.

ok - Keep finding errors please, as the more I find now the easier nd smoother it will be to run. Is a shame there is no head to head this year though. I had themed colours all the way through...

Cheers.


View attachment 17939

Really like this view and update ....

Just need to clean up the following and all looks good to go ...



- totally understand how errors creep in .... not as easy to put together and self check as people realise ...

 

[Beijing_Sting]

Really like this view and update ....

Just need to clean up the following and all looks good to go ...

View attachment 17940

- totally understand how errors creep in .... not as easy to put together and self check as people realise ...

he he ... It is not easy, but I am finding this quite enjoyable. Thank you!

 

[Darkie]

Pretty pleased with some of my PODs! Oliver, Dusty (this week not so much) Hill et al.

Haven't checked out others' PODs though

 

[Beijing_Sting]

Friday night update - I'm in last place? I need to check the excel file I reckon.

 

[Darkie]

Friday night update - I'm in last place? I need to check the excel file I reckon.

View attachment 17948

I might be misunderstanding, but my captain seems to have scored less than my average player, so there might be a tweak needed to the C calc.

 

[Diabolical]

I might be misunderstanding, but my captain seems to have scored less than my average player, so there might be a tweak needed to the C calc.

I think the average includes captain.
I have Picket (2x50) + Whitfield (8) = 108
My average shows as 108 / 2 players = 54

 

[Beijing_Sting]

I might be misunderstanding, but my captain seems to have scored less than my average player, so there might be a tweak needed to the C calc.

Lucky you!

Yeah - I wasn't sure if I should average the players without captain, or average with the captain included. Went with the later. Thoughts?

 

[Darkie]

Lucky you!

Yeah - I wasn't sure if I should average the players without captain, or average with the captain included. Went with the later. Thoughts?

Aha, in that case - I agree with you.

Personally I think things would be easier if people just treated the captain as two players, and we all thought about it as 23 scores contributing each week.

No need for the “+C” in my view - just add 1!

 

[Diabolical]

Aha, in that case - I agree with you.

Personally I think things would be easier if people just treated the captain as two players, and we all thought about it as 23 scores contributing each week.

No need for the “+C” in my view - just add 1!

You are as bad as @Ironhawk

Only 16 scores count!

 

[Darkie]

You are as bad as @Ironhawk

Only 16 scores count!

Haha - I was meaning even in the In Game Discussion thread ... but I must admit I had forgotten it was just 16 (or 17!) ?

 

[Beijing_Sting]

I know - no H2H... However, it just so happens that the excel file I have (thanks to @KLo30), does have this still ready to roll out. So... Perhaps a little friendly or two?

Apologies to @tyrae1 though ... as they were the first to enter (in March), They're listed as the 19th team and so not involved in the H2H formulas. Hmmmmm. Maybe I can fix something up though if you're still tuning in.

Friday night Friendly update - Cool colours, hey?

 

[IDIG]

Amazing bloody work BS and Tails!

Looks like I was one of the lucky three who started Parfitt so that’s worked out well.

 

[Beijing_Sting]

Sobering news today

Melbourne 9 Players and 69 (the most) selections
Essendon 8 Players and 41 selections

ok - update

 

[Beijing_Sting]

And the Friendly:

 

[Herbie66]

I know - no H2H... However, it just so happens that the excel file I have (thanks to @KLo30), does have this still ready to roll out. So... Perhaps a little friendly or two?

Apologies to @tyrae1 though ... as they were the first to enter (in March), They're listed as the 19th team and so not involved in the H2H formulas. Hmmmmm. Maybe I can fix something up though if you're still tuning in.

Friday night Friendly update - Cool colours, hey?

View attachment 17954

Without upsetting the already set up friendly schedule can you just Tyrae1 in against a randomly drawn opponent each week as a additional game ?

 

[Beijing_Sting]

Without upsetting the already set up friendly schedule can you just Tyrae1 in against a randomly drawn opponent each week as a additional game ?

Can look into it. Just a friendly - maybe lop off the last place team each time I run it, hey? Also, let's see if tyrae pops back to the forum.


Give us a shout out @tyrae1 once you're back. Cheers.

 

[Herbie66]

Can look into it. Just a friendly - maybe lop off the last place team each time I run it, hey? Also, let's see if tyrae pops back to the forum.

View attachment 17968
Give us a shout out @tyrae1 once you're back. Cheers.

Just a thought I had , not sure how much extra work it involves or just leave it like it is now.

All good

 

[Ironhawk]

If it was a regular poster that missed, I would just suggest dropping the lowest scorer in a round for future rounds.

Best average after 3 matches, nice.