Since my initial run i have sliced 6mins 40secs off my time and now regularly finish within the top 25 runners to do this i have had to train (something i did not initially think i would need to do) and run about 6 - 12 miles extra each week. I have also started to enter official races to see how i compete against club runners with my next race being the Great South Run, so all in all parkrun has been a great experience for me.
Once i had the running under control and was making progress i thought that i needed to keep an eye on my stats. Now Parkrun provide some data on their site, so you get a graph of your age grade results which looks a little like this:
With almost everything else in table format, on the website. This got me thinking about Google Docs or Excel and the fact you can import HTML into spreadsheets!
So without further ado i will run you through my Google Docs Spreadsheet.
First things first, my spreadsheet has a config page this is basically to make it easy for other parkrun runners to make a copy and plugin in some data and everything else will work. Secondly i am by no means a spreadsheet guru, i am very happy with how far i have taken my document and may add more in future. If you do use it, make improvements or spot mistakes let me know in the comments (also spread the word to other parkrun fans!!).
Link to the Google Doc parkrun Spreadsheet
So why would you want to use a spreadsheet?Perhaps you want a fancy graph of your age grade stats:
You might want to know how you are doing in the points table:
- If parkrun change the format of the website the spreadsheet will stop working!
- Some of the tables need to be manually updated each week to account for changes (i think excel would work better for this using a data table as that would update).
- volunteered on the points sheet
- PB on the weekly results.
- I like to make a copy of the weekly results into a separate worksheet each week to preserve the data in case i want to check something