I was just thinking, low long is the tapered section on the fork? Shorter than the head tube I hope 
does anyone have a spreadsheet or something they use for tracking maintanence? I have this sort of big, unwieldy todo list that Iām getting kind of tired of.
I want an easy list / dashboard type thing that breaks down what I did, when I did it, and what maybe needs doing.
this is something I can do on my own, obviously, but Iām lazy and am hoping someone else did it already
EDIT: maybe what I want is a combination of todo list and a log of work done, as two separate things?
seems easy enough. you need meter readings, maxdate by category and some triggers based on time/distance. do you want to keep track of prior maintenance or just stay on top of new maintenance? if the latter, i see a work order form feeding into it
after tomorrow i could take a swing at it if you have a wish list. i like this sort of thing
EDIT: just saw your edit. you want a form feeding into a sheet that your dashboard is based on. lemme know what kinda shit you wanna track and i can play with this
2 Likes
thanks for thinking about it with me, what I want is kinda ill-defined, here are some ideas / stray thoughts:
right now I have a list for each bike with a header with dates for last chain clean, last tire milking, last new chain install, stuff like that. Then, below that I have a running list of tasks that just gets more things added to the bottom and crossed off when done.
But hereās the thing: some stuff needs regular attention, like cleaning the chain every few weeks or re-milking tires every few months, other things need to be replaced, and yet other things need to be messed around with periodically. So what Iām picturing is soemthing that just reminds me about the periodic stuff, lets me note what Iāve most recently done to change my fit / position on the bike, and notes when I may need to do other work based on my manually adding things.
Ideally it would be cool to be able to see all of those things in terms of urgency (like a slightly worn chain can wait a while if I use my hour a week of repair time to replace a cracked handlebar).
My problem in past is that absent an elegant way to represent all this information, I wind up just giving each bike a once-over and fixing whateverās most obviously wrong. This keeps me going down the road, but means that Iām often not doing slightly less important but possibly useful things.
Strava has component mileage tracking, or at least it used to. I remember that it exists every few years.
2 Likes
The 74 year old crusher in my club tracks all mileages and stuff on his half dozen bikes on excel or similar
I commented on his paramount and he said he got it new in 86 or something
Yeah, I wonder if itās still free?
What I want is waaaay more multidimensional, a complex evolving possibility space of bike repair and optimization not constrained by the tiny window our individual cognitive capacity gives us on the world.
That or yeah just like an Excel sheet or whatever
1 Like
You need something to read your gps data if you want it to log mileage and hours. Then just set a series of alerts based on recommended mileage. Not sure of how to do the technical aspects but Iād start poking around how to get those two basic pieces of data from your ride files and then how to dump that to a db of some kind. Canāt be very difficult at all.
nope.
I ride the same mileage weekly throughout the year, so itās nice to have those simple time/distance based reminders, but what I want is to integrate those with two other streams: optional but important adjustments to things like saddle position or type, and the third category, larger repair projects that are intermittent and somewhat unpredictable but important to do when itās time to do them.
Well, thatās a whole lot easier. You can even start with a repeating series of google calendar events? Create a new calendar called ātime to sniff my saddleā. I bet thereās some fancy scheduling app that could get suitably dynamic.
Iām going to wind up signing a million dollar contract to get this built out for me, probably:
you can do a simple script to send emails based on cell values in sheets. ive never done a script but this would be a good excuse to learn. no idea how to best get mileage automatically into the sheet but iām certain you can do it via a google form that youād enter ~weekly or however often.
BUT you say your mileage is consistent so if you wanted, you could have the triggers go off of time since x maintenance. fill out work order form, then it updates the things based on what you actually did
1 Like
Yeah itās almost exactly 100 miles a week, more or less year round. The catch is that Iām not riding all the bikes at the same rate. It turns into a really frustrating math problem really fast just in one stream of information I want to know about.
I mean this is probably one of those situations where itās complicated and low stakes enough that expert judgement works. If I were managing a 100 bike fleet Iād want real insight.
Finally routed the rear brake and cleaned up dyno wiring on Lamar
Also just realized Iām about 5 blocks from squid
14 Likes
when you get over a certain number of bikes itās more about setting your intervals to what you can manage with staffing levels and regular repair workflow. more of a how can we not completely drop the ball kind of thing.
either way iām down to see if i can make a dumb thing
1 Like
Yeah, itās about the people and the problems. Iām happy to keep kicking ideas around with you here, or we can move this to another thread that wasnāt intended for it
Thatās why you start with miles/hours. Not yours but the bikes you ride.
I think youāre missing what Iām trying to do, but it is true that keeping track of this would fit into it
I may very well be completely missing what you are trying to accomplish, but the way I see it, I think youāre creating more problems than it is worth to avoid using miles/hours. This is assuming that you track your rides via gps already. The problem you appear to be running into is that you canāt figure out what data to use to make your solution work. Thatās because the data is miles/hours. The fact that your body consistently pedals 100 miles a week is wholly irrelevant to bike maintenance so far as I can see, unless you mean that it ties into these saddle position checks that I also do not understand.
How can you say āit is timeā without tracking time?
1 Like
as noted above, miles and hours do factor into this.