Bicycle Component Log – And Other Things I Track

May 16, 2011 9:20 am
Bicycle Component Log - And Other Things I Track
Update Note:  For 2012 I have greatly simplified this process.  See the new post for more information.

Although many people keep track of the miles on their car and know when to take it in for an oil change, they often neglect keeping track of components on their bicycle, or they rely on a local bike shop to check it out.

For years I have kept a detailed log of all my training.  Even after writing an article about online training logs, I still keep up my Excel spreadsheet.   Today I upload my GPS data a couple of websites (Strava and Garmin Connect) and to a local computer based program (Ascent).  One might think that a website like should be more than enough, and might be for most people, for me personally I want to do more, including:

  • Chart cycling and running miles separately
  • Track how I am doing compared with prior years at this same time
  • Track for both my wife and I together since mostly bike and run together
  • Track details on mileage on various bike components on various bikes
  • Track which club or non-club miles I cycle.

So I take the time to enter into my Excel based training log, which is setup so it also keeps track of which bikes were ridden by myself and my wife.  Using formulas in Excel, as I enter a daily workout rather quickly, it then computes a lot of data

Bike Component Wear

Using data from when I have had to replace components in the past, I can estimate the percent wear on each item.  This is what it looks like.

I check this periodically and noted I had better check the chain wear on my wife’s Trek Madone 5.1.  Sure enough the chain checker tool showed wear to 0.75, which I use as a time to replace, so as soon as I finish this blog entry, I will go do that.

For the tear wear, I keep track of how many miles the tire has been on the front and on the rear so I can estimate wear.  I use a factor of 2X for rear wear compared with wear while on the front.

Who I Bike Wtih

It all might seem a big complicated, but after creating the training log, it is very easy to enter the daily workouts.  Selecting a single drop down will allow me to choose that it was something my wife and I did together, only I did or only she did, and all the other numbers are automatically calculated from that.

One other feature I added for this year was tracking which group I bike with, one of the 3 bike clubs I belong to, solo, or with someone in my family.  This is what it looks like so far this year.  Note that if my wife and I join a club ride together, that is where I count the miles so the “Family” category is just with someone in the family.


Our time in Utah is more during the summer so that will change.  Biking with ACTC is not so common as it once was.

These two examples are the type of information you can get if you keep your own training log.  In my case it is really a training log for both myself and my wife and since most of our workouts are together, that makes things easy to track and also makes life a lot of fun.

How is My Training Going

I can easily see how my running and cycling are doing compared with prior years. This shows how I did in 2010 compared with the prior years.

I have friends who don’t even use a cyclometer to cycle with and have no idea how many miles they have ridden.  But I also notice these same guys are always having some issue with cassette wear because they didn’t change their chain until it was too late.  It might be the engineer in me that loves to see the data so I know how I am doing and how my bikes are doing.




One Response to “Bicycle Component Log – And Other Things I Track”

[…] 1988, I have used Excel to keep track of my training.  Initially it was just running and I would track how many miles I ran each date and the pace.  […]

Care to comment?