ROB'S BICYCLE LOGS

Year
(click to view)
Total
Mileage
Number
Rides
Average
Milage
File
Size
 
Comments
Summary by Year    14k+Mileage Totals by Year
Summary by Month    63k+Mileage Totals by Month/Year
2008 ---00k+current year
2007 2630.658331.69143k+New Trek Fuel 80 mountain bike
2006 2659.788132.84133k+25,000 miles attained
2005 3040.979631.68149k581 miles with trailer bike, split rides between TREK and KLEIN
2004 3012.6810129.83155kNew Klein road bike, split rides between TREK and KLEIN
2003 3079.189233.47145kGITAP Ride Illinois
2002 1723.376327.36112k 
2001 2535.697533.81119kTOGIR Ride Iowa
2000 1137.354525.2774kAll rides with Kerry
1999 1222.452942.1560kFew rides, but long rides
1998 1166.593335.3555kKerry born
1997 1328.815623.7379k 
1996 1027.193727.7639k 
1995 1612.325429.8644kKatie born, Biking Across Kansas
1994 1013.234721.5637kTour of Door County WI

I keep a log of all my bicycle rides for grins and for reference. Each log represents a year's worth of bicycle rides. The logs are kept in Micro$oft Excel and webpages generated through Excel. The comments usually indicate what route I took and note anything interesting that might have happened along the way.

The Excel spreadsheet calculates the average speed based upon the distance traveled and the elapsed time of the ride. I have found this result to be more accurate than trusting the average speed calculated by a bicycle computer. I have found that many Bicycle computers have a tendency to round on their average speed calculations which can result in errors greater than 1/10 of a mile per hour.


back to: Top of this Page | Bicycle Page | Rob's Index Page


Contact the Author
Copyright © 1996-2008 Robert P. Anderson