Route Card – Excel
Route card in editable Excel format. Key in the start time and the distance, height gained and rest times on each leg and it will calculate and fill in the estimated time taken and the totals.
Please let us know if you have any suggestions for improvements to this route card.
This excel file has protected cells that the user cannot edit without keying in a password to prevent accidental deletion of formulas. If you would like to know the password so you can edit it further then please ask.
Credit is due to Thomas Gaffney who has made it easier to add more rows and made the formula for the time allowed for height gained much more elegant. And Andrew Preston who has made it look much nicer buy hiding all the zero’s of unused rows.
Download
Route Card – Excel
Version 3.5 – Last updated March 2023
Route Card – PDF
Same route card as above but in PDF format (not editable).
Download
Route Card – PDF
Route Card – Google Sheet
This is the same route card as above in ‘Google sheet’ format. I am not a Google Guru but here goes. You will need to have a Google accout to really use this to its full potential. You can make a copy of this sheet which will save it to your Google Drive. Then give the participants access to it by sharing a link with them. They can then update the sheet on any suitable device attached to the internet. By doing it this way you can keep track of how they are getting on.
Before printing or exporting to PDF you may want to delete any unused rows or simply shrink them a bit to make it fit on one page.
Route Card – Google Sheet