Bike Forums - Dialing in fit, spreadsheet

Bike Forums (https://www.bikeforums.net/forum.php)

- "The 33"-Road Bike Racing (https://www.bikeforums.net/33-road-bike-racing/)

- - Dialing in fit, spreadsheet (https://www.bikeforums.net/33-road-bike-racing/356577-dialing-fit-spreadsheet.html)

NomadVW

10-24-07 05:36 PM

Dialing in fit, spreadsheet

Ok.. well. Maybe ya'll have a good place to get this done already, but I've been mucking around with stem lengths and angles and - while currently happy with my set up on the new bike, I wanted to know how changes in stem angle/length/spacers would affect my current set up.

That being said, I threw together the trig/formulas to get the right numbers in an excel spreadsheet and figured ya'll would find it useful. The Habenero picture was nice, but I like real numbers.

http://www.cycleiwakuni.com/download...em_changes.xls

dpr	10-24-07 05:53 PM

What version of office did you make it in please? Never mind it does seem to be working. I have only Office 2000 and have in the past met some surprising compatability problems.

Very useful, thanks!

NomadVW

10-24-07 06:04 PM

2003

Yep	10-24-07 10:48 PM

Very cool. Is the nose-to-bars measurement to the center of the bars?

NomadVW

10-25-07 12:20 AM

Yah, nose to center on top is how I measure.

NomadVW

10-25-07 01:26 AM

The file as linked in the OP has been updated to correct some bad math and to work properly with stem measurements as they publish them. A note added for people like me that are just learning how these things work! :)

Quite annoying I might add how people publish stem lengths

All times are GMT -6. The time now is 01:25 AM.