ROB'S BICYCLE LOGS

Year
(click to view)
Total
Mileage
Number
Rides
Average
Milage
File
Size
 
Comments
Summary by Year ---34k+Mileage Totals by Year
Summary by Month ---79k+Mileage Totals by Month/Year
2017 0.0000.0010k+current year
2016 5522.7213142.16254k+20 Centuries, first full year of retirement
2015 5177.8814535.71261k+14 Centuries, hernia surgery
2014 5006.2616630.16274k+13 Centuries, hip issues, 50,000 miles
2013 3671.6115324.00239k+Shin splints
2012 3402.5411429.85223k+Hernia surgery recovery
2011 3173.1812425.59225k+Shoulder surgery, 40,000 miles, 2,000 commuter miles
2010 3652.5011930.69178k+double century
2009 3023.519830.85147kNew Tandem bike, century both days of MS 150
2008 2345.497431.70130kHaleakala, MS150, Ride the Rivers Century, 30,000 miles
2007 2630.658331.69144kNew Trek Fuel 80 mountain bike
2006 2659.788132.84133k25,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-2017 Robert P. Anderson