League to date 2019

[keith]

Hi Guys

Covering the first 3 matches and I will update after each match.

Marsh AC 2019.xlsx

(17.37 KiB) Downloaded 126 times

[SiDev]

Great stuff Keith

[Spamwham]

Thanks for this Kieth.
Cant wait for 14 matches to see each person's running average tho!
So a bit of spreadsheet maths for you:
Starting in row 2, in your average weight column AM, replace the formula AJ2/14 with
AJ2/(COUNTIF(B2:AG2;">=0")/2), then copy this down to all the other entries in column AM. This will give you an updated rolling average weight after each match.
You could also adjust all the resulting weights to 1 decimal place to make it look pretty as well

[joshdon]

Thanks Keith - found this very interesting!

Hope you don't mind but I had a play about with this (got bored at work as it's Friday!)
I've stuck some conditional formatting in for '1st', top weight and some charts on the other tabs.. feel free to ignore it all but thought I'd share.

Added the formula in too which was a good shout - will be interesting to see the moving averages!

AJ2/(COUNTIF(B2:AG2;">=0")/2)

Marsh AC 2019.xlsx

Marsh AC + Charts

(47.7 KiB) Downloaded 98 times

[keith]

Josh,Tony, Simon

Many thanks for your input.

All I hope now is that when I fill in a box it appears as I would expect it too. I am not an Excel user, far from it. I drive a Fork Truck for a living.

But I do feel confident that when I populate it, there is a team behind me to double check it.

Cheers Guys

[keith]

Please feel free to check and double check the updated sheet.

Marsh AC 2019 v2.xlsx

(44.8 KiB) Downloaded 100 times

[Tel]

Not sure if I can cope with such giddy heights , but I expect normal service will be resumed later

[Spamwham]

Two things Tel:
1. Enjoy it.
2. What ever it is thats working for you - WRITE IT DOWN NOW SO YOU DONT FORGET!!!!!

.......cos sure as eggs is eggs once its gone you'll wonder what the hell it was you were doing right

[keith]

Updated with the data for Hartleylands. I know nothing about the graphs so can I ask someone to update.

Marsh AC 2019 v2.xlsx

(44.97 KiB) Downloaded 117 times

[joshdon]

Updated for Alders and Orchard.

[joshdon]

Updated for Puddledock

Marsh AC 2019 v3.xlsx

(53.15 KiB) Downloaded 89 times

[joshdon]

Have updated the league post Blind Lane and have added a “Position -ag” which takes in to account losing your worst 2 results.

Chris has hit the 1000lb mark now, with an average of 111lb after 9 matches - well done Chris!

With 5 matches left to go, still a lot to fish for... although it’s looking like Chris is running away with the lead still (story of the season)!

Marsh AC 2019 v3.xlsx

(42.28 KiB) Downloaded 92 times

[Chris T]

Chris has hit the 1000lb mark now, with an average of 111lb after 9 matches - well done Chris!

With 5 matches left to go, still a lot to fish for... although it’s looking like Chris is running away with the lead still (story of the season)!

Marsh AC 2019 v3.xlsx

Cheers Mucka been a great season gutted I missed Monks 1 really fancied smashing the granny out of it!!
Some huge weights taken from it the day after too!

[joshdon]

Updated for Monks and Stepfield

[joshdon]

Regrettably... league updated after Puddledock.

Marsh AC 2019 v4.xlsx

(31.09 KiB) Downloaded 83 times

[joshdon]

Final update of league attached! I’ve added a “members only” tab for those who wanted to see that. Please let me know if I’ve missed anything or inputted any scores or weights wrong

Thanks to all for a great season and letting me tag along for my first ever experience of match fishing!! See you all again next year!

Marsh AC 2019 v4.xlsx

(34.4 KiB) Downloaded 68 times

[SiDev]

Well done Josh, that’s a lot of numbers to deal with! Well done Chris for the league win and Josh a fab first years match fishing, roll on next year !!

[joshdon]

Weights overall should be sorted now... hopefully