Expedition Route Card System (Auto-Calculating)

Anyone who has ever working with DofE group knows the pain of getting participants to create quality route cards, after 15 years of working with School and Youth Groups, I decided to create a tool to simplify the process.

The spreadsheet looks near enough identical to the standard DofE Route Cards, your participants need to fill in some basic info like Speed, and Start time, and then add the start point and finish point for the first leg. The sheet will then copy the information from the finish point of the previous leg to the start point of the next leg - so no messing around writing everything twice.

Participants will need to add distance, height climbed, and planned breaks for each leg, and the sheet will calculate the timings element for you - which can be a real pain in the bum when working with decimals etc. You can also amend start time and speed to update the timings. Which is useful as a teaching tool.

This is a good partner for an electronic mapping systems, since many cannot produce good quality route cards, but do make the job of measuring distances much easier.

There is instructions on the first page, and detailed instructions with each cell that requires user input, any cells not requiring user input are locked.

Enjoy!