Spreadsheeting

A few weeks ago, Victoria asked me about “spreadsheeting.” I mentioned that I keep track of my triathlon details in Excel, and she wanted me to tell her about that workbook. Here goes.

Triathlon results spreadsheet

First the basics. Every triathlon I’ve done is in one spreadsheet. As of Ironman Wisconsin it has 16 events. Each event gets its own row. It currently has about 35 columns:

  • Race, year, age group, and distances
  • Times: overall, swim, bike, run, T1, and T2
  • My rank in each leg overall and in my age group
  • The fastest swim, bike, run, and transition times for the day (both overall and in my age group)
  • My swim, bike, and run paces
  • My percentiles for the each discipline and finish time (overall and age group)
  • My time as a percentage of the best time for each leg
  • The number of people in the race
  • Some random notes

I didn’t always keep track of all of these. For example, the percentiles and the ratio of my times to the best splits are recent additions.

Raw triathlon data

Gathering the data isn’t always easy, and it usually involves scraping data from webpages for each event. From there, it’s a bunch of sorting and resorting and copying and pasting . . . and analysis.

What you analyze is up to you. I like to see how my swim, bike, and run are progressing at the same race or distance from one year to the next. I also use it to see where my strengths and weaknesses are compared to my peers.


p.s. — Don’t hate on me because I haven’t yet updated my Mac to El Capitan. I had some driver + Java compatibility concerns early on. I’ll get there soon.

This entry was posted in Fodder for Techno-weenies, Reluctant Triathlete. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

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>