Memory Map files

Route Card with Calculation Template

Template file

Route Card with calculations

How to use this template

  1. Make sure you are using Metric distances as that's what the calculations expect.
  2. Select the route required, go to it's Properties, click [Settings...] button and select the new template.
  3. From the route's Properties click [Route Card] button. This will, in v4 but not v5, ask you where to store the results, then will start Notepad (or your text editing program associated with .txt files) and display the generated route card file. Close this as it's unreadable.
  4. Start your spreadsheet program, and close any files it opens automatically.
  5. Import the generated route card file into the spreadsheet. In Excel you do this using the Open option on the File menu, then selecting the file type to Text Files. During the import it will ask if the file contains Delimited or Fixed-width data; select Delimited. When asked what the delimiter is, choose just the semi-colon. (Note, don't put any semi-colons in any comments you've added to waypoints.)
  6. You will now have a spreadsheet with cumulative times and distances.
  7. Before using/printing this I'd suggest hiding columns J and L as they are just working calculations. I'd also make the first and last rows BOLD, and do a few other tweaks to the formatting. You could even save the formatted version as a true spreadsheet file (i.e. .xls).