Skip to main content
Add Me To Your Mailing List
 
HomeLogging Miles

Logging those miles is pretty useful for those in training and for those who are mileage junkies. Some of you are probably just too casual to be bothered. Still you might like to look at some of the tools available for keeping a training log. A simple google search will turn up more websites and software tools for keeping track of your mileage both for running and cycling than you'll care to work through. You can even find these tools for you smart phone. 


Former TRC treasurer, Steve Largent, provides his training log at the end of the year. He offers it in Excel as well as in his preferred Quattro Pro format.In 2014 the Quattro Pro format saw 49 downloads. But the Excel version won with 134 downloads. If you appreciate his work, send him an email.


Steve's training log for 2017

  

Instructions:

New for 2017: Steve has added a column for elevation gain.

In the January tab type the name of your bike or its model name  and your beginning mileage for the year over the author's bike's model and beginning mileage.  If you have fewer than 6 bikes, just blank out the January field with the unwanted name in it.  The spreadsheet will automatically fill out the rest of the year with this starting mileage for each of your listed bikes.  If you buy a buy a new bike mid year,  enter it's name or model in Jan, and the 0 mileage will automatically copy to every other month.  At each month end you should update that month's ending odometer reading in the unprotected "ending mileage"  field for each bike.  

Steve says these are self-explanatorythough you might want to name your different bikes instead of calling them Bike1, 2 . . .


Here's Steve's take on keeping a log:

    I log daily distance, time, and route. I use the comments column to note increased opportunities (Cycle Oregon 503 miles) or excuses (20 days of Red Air Alerts this month reduced my monthly cycling). The log gives average daily distances, but I’m not too concerned with that; occasional mountain biking really messes with meaning of average speed and distance. I often compare this year’s totals to last or the year before to see how spring training is going, and I like looking up prior “Bite the Bullet” (Old Winchester Grade) results just prior to that ride so I will have accurate comparisons instead of vague memories confused with I Made the Grade and The Whitebird climb. The log often gives the answer to two questions: 1) why am I enjoying this ride so and feeling so strong or 2) why is this ride so miserable and slow? We often unconsciously lie to ourselves about how much we’ve been exercising, and the log doesn't lie unless you consciously lie in your log which is then meaningless.