Hi All, my first post so sorry if its in the wrong place!
Im looking to make a spreadsheet for a local club which im involved with that will track their points throughout a season and show who is the winner at the end.
Basically its a horse riding club and they have around five events a year and around 10 classes each event. i need to be able to track which member has won each class on each show and display these as a points based system.
the winner of each class receives 6 points, 2nd you will receive 5 points, 3rd 4 points all the way to 6th and 1 point for each event
i imagine there will be losts of data to input (over several sheets) to set up initially but want it to calculate a cumulative total of each 'member' for each class on each event with a running total shown which will also update as the winner changes (i.e another member earns more points as they enter more events). now each member may not enter all 10 classes and cannot enter the same class more than once at each event
sorry for the detail but hopefully someone could show me where to start and which formulas i need to look at to start to set this up
if ive not explained very well or more details are needed ill provide what i can explain
not sure how to attach things but when i figure it out i can attach what ive got so far
Im looking to make a spreadsheet for a local club which im involved with that will track their points throughout a season and show who is the winner at the end.
Basically its a horse riding club and they have around five events a year and around 10 classes each event. i need to be able to track which member has won each class on each show and display these as a points based system.
the winner of each class receives 6 points, 2nd you will receive 5 points, 3rd 4 points all the way to 6th and 1 point for each event
i imagine there will be losts of data to input (over several sheets) to set up initially but want it to calculate a cumulative total of each 'member' for each class on each event with a running total shown which will also update as the winner changes (i.e another member earns more points as they enter more events). now each member may not enter all 10 classes and cannot enter the same class more than once at each event
sorry for the detail but hopefully someone could show me where to start and which formulas i need to look at to start to set this up
if ive not explained very well or more details are needed ill provide what i can explain
not sure how to attach things but when i figure it out i can attach what ive got so far
