Last year
Vince convinced me that it would be a great idea to keep track of my training hours for this season and provided me with a great link to the google doc spreadsheet he uses to track his own hours / distances. At first I thought it would be arduous to keep up and I would eventually fall of the logging wagon, however being able to compare hours and distances with my fellow triathletes is a great motivator. Therefore as the end of 2010 rolls around I find myself cleaning up and updating my 2010 log making it ready for the 2011 season. I thought therefore this would be a good time to offer up a copy to any of those who would like to start logging in the current season, or who are still stuck in the dark ages of Excel logging. The color scheme can of course be change for those who loath the one I have selected, I do recommend differentiating the colours in the separate Swim / Run / Bike columns to easily see where your missing out in your training.
Excerpt from my 2010 "Workout Data" tab
The interface is fairly simple, simply log your distance and hours in the appropriate format in the main "Workouts Data" tab and that information is referenced through to the: Overall, Swim, Bike, and Run tabs. Information presented in these tabs such as the distance / time per week is a great way to chart your continuing progress. Having a lazy week? A low bar on a graph has more than once inspired me to hit that late night Sunday swim slot.
Excerpt from 2010 "Swim Graphs" Tab
The "PB's" or
Personal Best's tab is a good way to track race and personal goal improvement over a single discipline. Similarly the "Races" tab allows you to analyze your races over the season without having to comb back through Champion Timing data. Gear information I really have yet to find a use for, but I hope to next year go through my gear and figure something out... Finally the "Current Totals" Tab was created to link to a blog as explained in
this post.
Excerpt from 2010 "Overall" tab
So what are you waiting for? Make yourself a copy of the
"Training Log 2011" and start logging in the new year!
Sweet looking spreadsheet. I might have to copy that. Anyway to link it to your garmin upload?
ReplyDeleteThanks, I link my Garmin uploads to the hypertext links [ S B R ] ie.
ReplyDelete=HYPERLINK("http://connect.garmin.com/activity/44561212","S")
Where the link directs to the activity, haven't gone to the effort of scouring Garmin connect or having multiple bikes in a day though