Taking your Metrics Beyond the Log

Print Friendly

In a previous post, I extolled the virtues of being a metrics-driven runner.  Obviously, implicit in using metrics to monitor and improve your running performance is the use of a log, whether paper, digital, or online (and I use a combination of Garmin Connect and Dailymile for such purposes).  However, if you really want to get granular and see how your training is progressing, you really can’t beat a good old 1980’s style spreadsheet.

This reminder came to me courtesy of Joe Maruchella of Joe (Still) Runs for Dom.  He has posted updates of his own repeat tracking sheets for the hill training he has done this past summer (and his progress is impressive).  And, even more importantly, the progress is laid out right there for him to see and feel, helping him know that he is making big strides towards reaching his 40-minute 10K and marathon race goals.

Inspired by this, I went back through my Akron Marathon training and took the same approach, looking at hill intervals and 800/1600 flat (relatively) intervals.  This was a bit more complex, as I took a different approach than Joe by increasing the length of my intervals over the training period. I’m not stating that this method is necessarily better; I chose to do it due to the lengthy hills on the back end of Akron, and having experimented and failed miserably at starting with 800m hill intervals back before my formal marathon training began.  So it is a little tough to compare 800m intervals with 400m intervals, but I still think some valuable lessons can be drawn.  Here are the results.

What did I learn?

  • Let myself slack a little bit on some of the 600m hill repeats – I think I got scared when I nearly bailed on my first attempt at the longer distance, and was too conservative thereafter.  I certainly could blast through the 800m hills at a better pace (though improved weather conditions may have helped too).
  • Wow, did I shift too far in favor of 800m intervals vs. the 1600m’s (even though I have a strongly stated preference for 1600m intervals).  Need to rebalance that the next time around.
  • I saw only slight improvements, if any, in average interval time – but should consider it a victory that I could hold pace while increasing the quantity of intervals.  That, after all, really is the ultimate goal; one shouldn’t count on improving both pace and distance/quantity at the same time.
  • I still need to get better at going progressive on my interval work – tend to do the early ones too fast and the latter ones too slow.  This improved a little bit through the cycle (except for the last 1600 on the maybe-excessive 6 x 1600 workout I like to throw in).
  • Finally, I only put this together after the fact – too late to make adjustments.  Next time I’ll keep it up to date and try to learn and correct as the training proceeds.

Obviously, you could track times/paces on long runs this way too, looking at how your splits lay out as well as the total time.  There are a lot of other “input variable” like weather, hills, and fatigue that can affect your results, so you do need to be careful not to jump to hasty conclusions.  I also find plotting performance handy for learning pacing lessons from past marathons, and will share more on that in the near future. Has anyone else found good success using spreadsheets to track their runs?

Be Sociable, Share!

You may also find these interesting:

Tags: , , , , , ,

  • Pingback: The Merits of the Metrics | Predawn Runner

  • http://www.strengthrunning.com Fitz

    This is really interesting Greg. I’d love to do something like this but for me, I think I’d have to do entirely track work to notice the progression of fitness. I don’t use a Garmin when I run, so I base my tempo’s and hill intervals on time or distance (but who knows how long the distance really is).

    My favorite workout is doing 3 reps of a random loop in Rock Creek Park in DC. Looking back, it takes me anywhere from 22:13 to 22:56 to run 3 loops, but the humidity here fluctuates widely so it’s hard to pinpoint if the speed/slowness can be attributed to my fitness or the weather.

    You’re not a running nerd unless you have a few spreadsheets (or Google Docs).

  • Bill

    good stuff. i haven’t taken it to the point of developing a spreadsheet yet, but i definitely do a lot of analysis on the garmin connect after runs (especially track workouts) to make sure that i’m hitting my target paces.

  • http://gregstrosaker.com Greg Strosaker

    Thanks for the comment Fitz, I agree that there are a lot of other variables that impact your split times so one shouldn’t jump to hasty conclusions (for one, it is hard to find perfectly flat street surfaces to run on, even in my reasonably flat area). Statistically speaking, in the presence of a lot of noise in the data, you need a larger sample size to find correlations, and this goes against the idea of having variety in your workouts. So you may well reach a point where signals would not show up in the data because the improvements you are capable of are, in fact, pretty small. But until that point, I think the use of spreadsheets makes sense.

  • http://gregstrosaker.com Greg Strosaker

    That was what I was doing as well Bill, but found using the spreadsheets better for going back not just over one training period but to similar points in previous training cycles to help set better expectations for upcoming races. Thanks for your comment!

  • http://paulpowered.com/ phxwebguy

    Nice follow-up to your Merit’s of Metrics post. My “disappointing” tempo run yesterday was slower than I needed to be per my training plan. After parsing some XML and dropping it into a spreadsheet, I realized that it was actually my fastest four consecutive miles with one of my top three splits and a top five run at that distance overall… even with the warmup and cooldown. Like you, I favor DM and the Garmin Training Center and Connect but if readers (especially newer runners) are looking for another source of motivation, I would go so far as to recommend doing a more granular level of tracking metrics such as you have been writing about.After the tempo run, I was bummed out, reviewed the numbers and now I know I can be where I need to be for the next scheduled tempo run.Thanks Greg. I’m new here… Great stuff! Keep it coming.

  • http://gregstrosaker.com Greg Strosaker

    Thanks for your comment and welcome! You raise a good point in that
    sometimes looking at things through a spreadsheet in a more granular manner
    can paint a very different picture than simply looking at the total run pace
    or going by gut feel. Of course, it can work the other way some times, but
    getting the true picture is important whatever lesson it teaches us.