Since 1995, I’ve been tracking every mile I rode on the bike in an Excel spreadsheet. This has proven to be an excellent training tool and helped me notice trends and (sometimes) avoid over training. Five years ago I set out to find an automated way to compute my average speed and embarrassingly, I couldn’t figure out how to do this in Excel so I wrote my first JavaScript application and published it over at : http://www.raincitystory.com/mph.htm. Since that time, I’ve averaged almost 10,000 hits per month on that page (the other pages on my entire site get less than 1,000 hits per month COMBINED) and I often get e-mails from people asking for more help to automate the aggregation of their training data.
Since I started 12 years ago, the log has gone through some serious evolution and I now think it’s ready from prime time. Here are some major features:
1) All days including leap years for 2008 through 2012 are accounted for
2) Average speed automatically calculated and summed on a daily, monthly and annual basis
3) Space to record and average body weight, average heart rate, maximum heart rate, calories burned, temperature, elevation gain, cadence and time of day
4) Automatic monthly summary of number of rides, time spent on the bike, distance, and average speed
5) GRAPHS!
6) Much, much more
License: GPL v2 (improvements appreciated!)
Available Formats:
Microsoft Excel 2000/2003/2007
Open Office Calc
Google Docs (recommended so you don’t have to worry about backing up! * Be sure to copy to your own Google account)
I’ve put a sample entry in the first row so please be sure to delete that when using. Any columns and rows can be deleted so enjoy!