Hi, I've had a Google but can't find what I want.
My running club has a Club Championship, which is worked out on an runner's age-graded percentage. Currently the process of working out the % for each race and runner is a manual process, which is time consuming and prone to errors.
I know there are Excel tables and online calculators that work out an individual runner's percentage based on gender, age, race distance and time (the current person who runs the championship uses an online calculator, so has to type the details in for each runner). What I am looking for is a spreadsheet that works out the age graded percentage for a list of runners, automatically for a given race. I would obviously provide the gender, age, race distance and race time for a race for each of the runners in the list, and I want the age grading to be worked out from looking up the details from the tables.
Does anyone know if such a thing exists?