Match fishing results and league tables

Hi All

I would like to create a excel document that automatically updates a league table after entering data.

I wish to create a table for individual fishing matches which I can manually enter the weights of fish caught by each angler (in pounds and ounces). From this, i want the highest weight caught to then automatically gain 10 points (in a separate column), with second place gaining 9 points, third 8 and so on until the tenth person... following this all other members just gain 1 point for attending a match. For the individual match table, i would like the table to auto sort itself so that the winning angler (with the highest weight of fish) is top etc etc.

From the above table, i would like to create a league table which updates automatically following the entering of the weights of fish caught on each match. I would like the leauge table to autmatically add the points for the latest matches, and also the over all total weights of fish caught by each angler. Again, i would like this table to auto sort the rows so that the person with the highest number of points is ranked top of the league etc etc.

I have included a layout that im currently using, but it has no formulas in... I literally manually enter all the data and carry out the maths etc. It looks neat for posting up but is a nightmare to do and very time consuming! If anyone can help then please get in touch. All this may not even be possible for all i know!

Any help with either of the elements would be greatly appreciated! Even more so if someone has a template that is similar!

Many thanks!

Thanks for taking the time to help out Glen!

Il have a look and get back to you!

Glen

That is absolutely spot on mate! I only wish i knew how you've done it haha

All i ask is how to add new members... i tried it on a match but it didn't seem to appear in summary (league table) page...

Being really picky here but im gobsmacked that you've pretty much got it sussed!

Thanks a lot for your time and effort!

Paul

Good work!

But as an angler myself I do wonder should there no be a column dedicated to the one's that got away?

I may not be sure of their weight in oz/grams but I do know their weight in pounds/ kilos when I tell it to my friends.

Alf

Glen

One other thing (picky i know)...

In the league table, is it possible to have the ranks to automatically sort in ascending order... so rank1 is top... If two members or more have the same number of total points, their total weight should decide they're overall rank.. Sort of like a goal difference in football league tables.... sounds complicated but im sure you have the expertise to resolve this!

Thanks. Paul

Excellent work again Glenn!

Ive had a play but cant seem to find any obvious bugs. All seems to do what i need anyway! At one point it did seem to duplicate a member and their results in the league table (but not in any event pages), but i cant seem to reproduce it again! Which is good i guess...

As for the information you need to finish up....

1) A maximum of 40 members will be more than enough to future proof the template!

2) Its a seasonal thing (winter / summer leagues) with approx 15 matches per season. However, again to future proof it then it may be beneficial to extend that to twice as many, 30. *Please note, it did seem to work ok copying the match result table into a new sheet, so i could always add additional ones as and when required??

Please let me know your thoughts! And... when your ready, try to explain how the hell you've done it all! Even though i have a feeling il struggle to understand it all lol

Thanks again mate!

Hi Glenn

Apologies for the late reply. Been very busy! Well as far as i can see the problem is solved. Ive had a play about and cant seem to find any faults! So thank you very much for helping me out with this one. I dont think it would have been possible for me to have done this completely on my own!

If anything ever crops up il get in touch!

Thanks again!

Paul

Hi Glenn

I am are using this spreadsheet for the matches on my caravan site matches

is there any way you can add members who attend the matches but Did Not Weight (DNW) in will get one point

regards
John

Hi new to the sits I am trying to keep a running total of peoples weight so one week they get 4lbs 6oz next week 3lb 3oz an then 2lb 8oz andso on so my running total would be 7lb 9oz then as I add next it would be 10lb 1oz can it be sone on excel. Thanks.

Morning All,
I am also a keen Match Angler and belong to a small local club.
I found this site when I googled, to try to solve an issue to the league table, that I have been creating.
When I Saw this site, I decided to join this forum, in the hope of sharing what I have learned so far and also hoping that You can help me, with my last dilemma with my competition/league tables?
Our club is very similar, in running Spring/Winter Leagues at various away-day venues. Plus We have two stretches of rivers, from which we run a bunch of cup matches through the Summer and another River Winter League, through the Autumn/Winter.
My main reason for creating this workbook is because all of the Club match Points/Weight go towards our Main Cup (The Club Cup)
So my aim was to have a program, which collates all the points and weights together and has running Tables, which update from each match that is run.
Blimey, sounds complicated just typing it up.. lol
I think I have cracked everything now, except allowing for those Anglers who have equal points, to sort via total weight countback??
That is causing me a bit of a headache..
However, you will note that the program deals with lbs/ozs really well, which I'm quite proud of!
This might help the Gentleman who started the thread.
Hope maybe you can help on this one?
Cheers

Could you let me know how you have got the multiple dates to add up in Excel, as we have tried to do this for a two day event and it just does not do this