Wednesday, 26 March 2014

Endura Trek Lionheart 2014 results as spreadsheet

Here is a link to an Excel spreadsheet (.xlsx) of the results from the 2014 edition of the Endura Trek Lionheart ride, which took place on March 23. I made this mainly because I wanted to see the times in order of the hill climb up King Alfred's Tower, so I could figure out that I was 479th fastest (!) and I make the sheet available for others who may want to play with the data in a way that the racetimingsystems site doesn't cater for.

All I did was cut and paste the data from the pages on their web site and reformat it. Not difficult, but saves you some time. The column 'E/B' is the ratio of the time the rider started the King Alfred's Tower climb to their total time for the ride. In principle this number lets you filter out those riders on 100 mile or km route independently of what route they entered (column 'Entered'), e.g. < 0.4 = 100 miles, > 0.4 = 100 km. Dirty, but should work in most cases.

The link:

While you're here, you may want to consider donating money to the NHS, who saved my life and rebuilt my left leg after I was left for dead on a road in 2010. Read the condensed version on the page The Accident & My Leg. Donate by clicking on the justgiving link to the right.

No comments:

Post a Comment