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?
0 ·
Comments
Age grading involves age, gender and distance. It also has to cover the times in seconds.
That's a lot of variables.
The % score which is restricted to two decimal places for convenience is another clue to why such a thing probably doesn't exist.
🙂
The factors you need are available for men and women in Excel here:
http://www.runscore.com/Alan/AgeGrade.html
Assuming that your race distance is one of those listed, a formula to pick the right table based on gender, then look up the right column for the distance and row for age would be straightforward. Once you've got the age factor you use that to calculate age grading from the race time.
Ric, the data is available to do what I want. I was just wondering if someone has already done it to save a job.
I have run our club champs for the last 12 months via a manual method and really want to speed it up for 2018
So I’m in the same boat you were, I’m prepared to don’t myself but would love it if someone else had already done it and was willing to share their method
It's built on the Grubb tables and periodically you have to adjust the times.
Ideally this should be every year, I do it every 2 or 3, after all the changes are small, and everyone is on the same tables anyway.
The Park Run geeks bitch about their 5k age grading being a bit different (74.12% versus 74.23%) but I file those comments away under "meh"
I've not looked at the tables for a while so will double check how easy it was to implement.
You need athletes and their ages but generally type in a time and it returns the age grading.
I looked into this a few years ago and couldn't find anything so using the howard grubb tables I created something...Its not completely refined but it does automatically calculate age grading for most of the main road distances. If its of interest I can top and tail it and share the spreadsheet. I also to the results for my running club
just trying to achieve the same result for my club.