Friday, December 29, 2006

I'm an Excel Spreadsheet Geek

Edit 3/27/09
I admit it. I'm also so anal I keep three running logs. I keep a good old fashioned paper log based on the old log Runner's World gives away. I made my own version in MicrosSoft Word and print out enough pages to fold over and staple together for about a year and a half. Here's an example. My current log has a laminated page of the McMillan Running Calculator as a cover.

I keep two Excel spreadsheet logs. The first one I started almost ten years ago and tracks mileage. My other Excel spreadsheet log is one published by David Hays. It keeps track of mileage, times, race performances, etc. It's formatted for one year, so I start a new one each year (the reason behind this post). I modify it to include more Pfitz-like training run descriptions, more shoes, and a few other things. I learned quite a bit about Excel by changing this log. The official David Hays website seems to be down now:
David Hays Log Page
Here's a Blank Copy of My Version
Here's a sample of the spreadsheet with some recent data.

Here's a calendar-based spreadsheet log (month-at-a-glance): Blank Monthly Log
I haven't used this log, but I like all of the information that's displayed on a one month sheet. This spreadsheet was created by "fat pumpkin", a very talented marathoner from Louisiana.

Here's what the log looks like with the fat pumpkin's data: Monthly Log Example


I just started using the on-line log at RunningAHEAD. I really like the way this site integrates data from a GPS. Here's one of the charts from a recent 4x800/400 interval workout:
Powered by RunningAHEAD.com

Edit 2008: I'm not sure if all of these links are still active. Here's a 2008 training log post.

I admit it. I'm also so anal I keep three running logs. I keep a good old fashioned paper log based on the old log Runner's World gives away. I made my own version in Word and print out enough pages to fold over and staple together for about a year and a half. My current log has a laminated page of the McMillan Running Calculator as a cover.

I keep two Excel spreadsheet logs. The first one I started almost ten years ago and tracks mileage. My other Excel spreadsheet log is one published by David Hays. It keeps track of mileage, times, race performances, etc. It's formatted for one year, so I start a new one each year (the reason behind this post). I modify it to include more Pfitz-like training run descriptions, more shoes, and a few other things. I learned quite a bit about Excel by changing this log. Here it is:
David Hays Log Page

Here's a calendar-based spreadsheet log (month-at-a-glance): Blank Monthly Log
I haven't used this log, but I like all of the information that's displayed on a one month sheet. This spreadsheet was created by "fat pumpkin", a very talented marathoner from Louisiana.

Here's what the log looks like with the fat pumpkin's data: Monthly Log Example

7 comments:

Ed H. said...

Have you had trouble with the D&T Chart in Excel 2007? I cannot get the average pace series to display correctly.

Nuke Runner said...

I'm not sure what you mean by the D&T chart. The power plant (and my home PC) are both only on Excel 2003.

Anonymous said...

I am a power plant control room operator in Oklahoma and also like to run.

Sorry to hear that you are an engineer, I have worked with four so far and all four have been dumb as a box of rocks, but I am sure that there are some exceptions.

I like to screw with excel myself and have made a few spreadsheet that you might enjoy looking over. I will check back in a few days and see if you are still blogging here and if you want to share Ideas

Jack

Anonymous said...

Thank you for posting the spreadsheets! The site where the original template was located is now defunct, so this is great resource you've provided.

Nuke Runner said...

I hadn't realized the David Hays site isn't working anymore. I hope it comes back soon.

farmer said...

Nuke Runner,

I'm pretty new to running and made the committment to start logging. sounds like the David Hays spreadsheet is one of best out there. As you noted, the URL is a dead one. Would you mind sending me a copy of it? If so, reply to this post and we'll figure out a way to get in touch.

Thanks, Jeff

Nuke Runner said...

The link just below the David Hays link will take you to a copy of the spreadsheet. I modified it to add another pair of shoes and to change the run types to be consistent with Pfitzinger training. I still have a copy of the original and can post a link to it if you prefer ghat one.