Training Logs

I’ve used a lot of training logs over the past two years. I’m kinda a training records nut-case. I want to know what I did, when I did it, and I want to be able to follow trends (which as a side note are tough because of temperature variables over the course of a year). About two years ago I started using an Excel spreadsheet I found on a web site. It wasn’t visually fancy, but it did do the trick, plus it had lots of nifty calculations and graphs on it.

The reason I bring this up is after last week’s post on schedules, a bunch of ya e-mailed me asking what logs I use

Which…brings me to one minor detail. I use three different logs. Really…it happened by accident. I used to use exclusively my Excel log. But then I started using Sport Tracks to import/analyze all my data. Because that’s how I get my data off the Garmin. So for a while it was Sports Tracks and my little Excel log as the two authoritative sources. And then in May came along the coach – which uses Training Peaks (TP). So I had to enter the data in TP as well for him. So before I knew it I was tracking in three different things. So for the most part, I don’t use the log portions of the Excel sheet anymore.

Excel, that little Excel sheet I mentioned – I kinda heavily customized it. I added all sorts of random pages. Stuff like pace calculators, calendars, etc.. So I still use those.

At any rate, here’s a few screenshots of the Excel Sheet:

image

The above is from last year’s log, you’ll note the drop-off in Nov/December, that’s when I hurt my knee. :( I like how it tracks my shoes though – which I generally use to about 500 miles. Below is the ‘Plan’ page, which allows you to specify what you plan – kinda a way to hold you accountable.

image

I’ve added this bike and swim section. It’s occasionally clunky, but it works.

image

It also includes a weight tracking chart – which I found really useful. There are two lines, the day by day weight, and then a 7 day moving average – which is more accurate (the below graph is from 2007 – I haven’t really lost or gained anything this year)

image

And lots of other pretty graphs as well:

image

Oh, and here’s a little pace calculator page I added, that allows me to keep track on various ‘PR’s’ within random distances. I use colors to define goals, and current training/race ‘records’. I forget to update a lot of the more obscure distances. Some of the random distances are based on specific routes I run/bike.

image

Buuuuutttt….as I said before – I’ve mostly converted to Sports Tracks and TP now (with the exception of stuff like the pace charts above). It does all the pretty graphing and recording keeping, as well as adding in the satellite views of my workouts.

image

image

And finally, here’s what it looks like in Training Peaks:

image

image

So, with that – here’s the downloadable workbook I use:

  1. Default non-modified version: (All Excel versions) – Original Source Location
  2. My modified and slightly confusing version: (Excel 2003) (Excel 2007) – Note I haven’t double-checked every cell that the 2003 version is all-happy after I down-converted it, but it seems to work fine.

I didn’t spend a ton of time cleaning up my version – because…well…it’s like a a rat’s nest that only I understand. I emptied out all of my data for the most part though, except a few things (examples) so you can make sense of it.

(Note, if for some reason you can’t get to the above files, please e-mail me or leave me a comment, and I’ll fix it)

32 Comments

  1. My brian just blew a fuse.

    Reply
  2. Badass. I'm going to look at your excel doc. Thanks

    Reply
  3. SLB

    Oh very cool, thanks for putting it up as a download

    I luurrvvee Excel

    Poor Kelly's Brian he just blew a fuse!

    Reply
  4. SLB

    HOLY CRAP it's awesome!

    Reply
  5. This is pretty much the same Excel program I got online a few years back. It looks like they just modified it.
    Nice to see the cycling and swimming logs in there.

    Thanks!

    Reply
  6. Pretty High Tech... huh?

    Reply
  7. Ha, I'm just the opposite. I'm very old school and like doing things sans gadgets.

    However, next year I may be forced to change ...

    Reply
  8. i've said it before, i'll say it again...

    i want to be like you when i'm 26.

    Reply
  9. I love it! I'm gonna modify it a bit for me but i love it!

    Reply
  10. Its official in my mind...
    You should be Barack's minister of records!!!

    Reply
  11. I think the phrase "information overload" was created for posts like this. My head is spinning.

    Reply
  12. janmac

    I'm getting my 1st Garmin (based on your reviews!) and will need to decide where to upload my data (running, triathlon & nutrition). Any chance you'll be updating this post? Please?

    Reply
  13. great info, got a 305 on the way as a training aid, just need to figger out the best sofware for the Mac now

    Reply
  14. John

    Would it be possible to get the password to unprotect the sheet in excel. I ran into a problem attempting to change some of the examples, i.e. the weight. Thank you not only for this post but your whole blog. It has been a great resource for a green triathlete.

    Reply
  15. The default password that David Hayes set is: dead

    Enjoy!

    Reply
  16. I've just realized that I can transfer .TCX files from Garmin Connect to Training Peaks on my Mac computer. Is there a way I can do a mass file transfer instead of uploading each individual workout?
    Thanks a lot for all the great information on this site!

    Reply
  17. You could use the Training Peaks device agent to upload the files, by just selecting a big pile of them when you go to upload a single activity. That's what I do when I have to upload brick workouts, etc...

    The Device Agent is Mac Compatible as well.

    Reply
  18. Thank you, Ray!

    Reply
  19. URGuilty

    Ray,

    would love to see an update to this article, especially given the new garmin connect site.

    how are you logging now? and what reports do you rely on most? TSS?

    Reply
  20. I primarily use Training Peaks these days, mostly because my coach uses it - and it all ties together seamlessly. I also occasionally use Sport Tracks when I need to do something around better split analysis, or with a product that TP doesn't support. And finally, I use Garmin Connect as a backup repository for everything else (since the ANT+ Agent automatically sends a copy there).

    Reply
  21. Dan

    Surely I am missing something here, but why can I not edit certain cells?

    I freely admit, I am an Excel idiot.

    Reply
    • Rainmaker replied

      You need to unlock the worksheet (for cells not designed to be modified). I believe the password is on the last page - 'dead' (without quotes) - which is what the original author set it to (not me).

      Reply
  22. Chris

    This sheet looks amazing...but when I try to enter data into the log for example:

    I tried to enter 5 miles or 5.0 into the distance and it changes it to Thursday. Also changes my time to ####. Any suggestions. I unlocked the pages with the password. I'm not too Excel savie but can usually get stuff done. Have any suggestions to solve this problem.

    Reply
    • Chris replied

      Never mind...I was on the wrong row apparently. Everything works fine once I move down one row.

      Reply
  23. Have a look for a professional logbook - Open Source.

    Lot of import sources and native Forerunner-Support:
    *.tcx (Garmin Training Data w. complete data set of Forerunner)
    *.gpx (without heart rate)
    *.slf (xml-Format from Sigma)
    *.fitlog (Export from SportTracks incl. HR)
    *.csv (Excel/CSV-Format)
    *.logbook (SportTracks-Logbuch: without HR/GPS datas)
    *.hrm + *.gpx via polar2tcx.runalyze.de

    The Google+-Community: link to goo.gl

    Regards, Marko

    Reply
    • mwozniak00 replied

      Yes runalyzer is very good but only i deuche language :(

      Reply
  24. David

    Great spreadsheet! What is the password so that I can change the dates and make other modifications for my use? Thanks...

    Reply
  25. Frederic

    Have you or do you use Goldencheetah at all ?

    Reply
    • Rainmaker replied

      I have and do from time to time. This post is fairly old and really predates the rise of GC. I mostly use it today for post-processing of power meter files for power mere comparisons.

      Reply
    • Frederic replied

      Thanks for your answer. Though my question didn't really belong here (GC popularity rise being more recent than this post), I wanted to post my question in the closest related article possible.
      Anyway, I was just wandering if you used it for running but my understanding is that it's more for cycling right ? I was wondering if it could replace SportTracks

      Reply
    • Rainmaker replied

      I've only used it sparingly for running, I don't think it's really the best substitute for runners for ST.

      Reply

Post a Comment

Your email address will not be published. Required fields are marked.
If you would like a profile picture, simply register at Gravatar, which works here on DCR and across the web.

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>