Anyone have a good bicycle maintenance spreadsheet?

I’ve got 3 bikes (commuter, cross-country and downhill), and I normally maintain my parent’s and brother’s bikes too. A few weeks ago I replaced the shifter cable on my commuter, tuned up my parents bikes, and noticed that my brother’s rear wheel needs truing.

Unfortunately I’m unlikely to keep all that straight for long without help. I couldn’t find a spreadsheet or program or anything for bicycles (though there are a few for motorbikes out there). Something with a breakout for shock types would be ideal, but I could work with anything more basic.

I have 6 bikes, and it’s pretty much just seat of the pants. Not too many parts on a bike and you just sort of know what needs attention. A quick 2 minute ride on the bike tells you all you need to know. If you want something more, just keep a log or spreadsheet for each bike and develop your own schedule.

Actually, I can just pick up a bike and figure out a lot. Loose headsets and wheel bearings are obvious when you pick up a bike. A quick spin of the wheels (or more likely a squeeze of spoke pairs) tells you a lot about the wheels.

However, a clean and lubed chains (and chainrings, cogs, and derailleurs) is heaven on a bike. I’d make that an every month or so maintenance item.

Seriously, it’s much more ‘as needed’ than ‘as scheduled’.
Edit: I have 5 bikes. Got rid of three, not two. Bought a new one last year. I can barely keep track these days

Has anyone got any advice on how I can stop the disk-brakes on the wheels from rubbing on the disc-brake squeezers?

The bike is new (Claud Butler Cape-wrath). I took it to a bike shop for a post assembly inspection after the chain snapped and I got thrown. I specifically mentioned the brake thing to the shop-guy but when I got it out the shop I noticed the disc thing was still there. Sounds like the Tardis when I start pedalling.

You need to shim the caliper (the squeezer). By adding or removing thin washers (shims) on the bolts that connect the caliper to the frame (or fork), you can adjust it’s position relative to the disk. Just move it around a wee bit until you get the right spot. Depending on the type of caliper, some mounts have wide bolt holes that permit the caliper to be adjusted laterally prior to tightening it down.

Another reason for a rubbing disk is that the disk itself if warped, and not running true. This would be unusual for a new bike - you can check by eye by rotating the wheel. If you did have a warped disk this would always rub, pretty much, and would either have to be straightened or replaced. Unlikely to be this though.

Brilliant. Thanks.

For a new bike, I wouldn’t think you’d have to adjust the calipers… if it was working fine when you got it, then the rotor is probably slightly bent (this happens occasionally), and needs to be (gently!) bent back. There are special rotor wrenches with slots of various depth to accomplish this, though I always end up using my hands.

I just don’t want to end up having the time to go biking, but find out my ride needs work. For example, I like to replace the rear shifter cable every two seasons to prevent it parting mid-ride (again), but how long am I going to remember that I just did that on my commuter, but not on my cross-country?

Precisely! And with a bunch of them not even being mine, I’d like a decent spreadsheet with columns for various parts, and maybe a notes field so I can recall that removing the cable housing on my Mom’s bike was a PITA so don’t bother next year. :stuck_out_tongue:
(Might even improve the resale to be able to show you’ve been regular and liberal with the lube)

umm…may I make the kind of suggestion that shows what an old fart I am?

I have this really, really handy speadsheet I use for all kinds of maintenance stuff. It’s got all the columns I need, and plenty of room for a notes field too.

It’s… (as if you haven’t guessed yet…) a plain old piece of paper. Or 2 or 3 , actually.

Now, I know you little whippersnappers won’t believe it…but,…yes, IT WORKS!!!

Why complicate your life so much?
It’s a bicycle, not a jet plane
Chain lube, wheel truing, brake cable , gear cable …

Take a sheet of paper for each bike, draw a half dozen columns , and voila!–it really is that easy.
Oh yeah…leave some space for a “notes field”. It’s the blank line right under the one you’re writing your info in. You see, amazingly enough, the notes field has expandable memory.

now get off my lawn!

Exactly. If you want a spreadsheet, make a spreadsheet.