You are reading a single comment by @Hovis and its replies.
Click here to read the full conversation.
-
I've been blindly using this spreadsheet for all my bike indulgences over the last few years. Comes out perfect every time.
http://bb2stem.blogspot.co.uk/2011/10/stack-reach-calculator-v100.html
Hovis-
Thanks, that's a great spreadsheet, which it turns out, on trying to save, that I already had saved!
It does use 1/2 the stem stack + headset + spacers and it transpires the head tube angle makes quite a difference.Confirms the 55cm would need at least 130mm -10/12 stem and ~8cm spacer stack (somewhat ridiculous) whereas the 58 would work nicely with a 120mm -10 stem and minimal spacer stack, time to unwatch the 55cm that is on the bay!
Long arms and legs, with a short torso, seems to necessitate for 'pro' length stems.
sidewinder
Why not (stem stack)? I thought you would use at least half of it?
Quick google spreadsheet (if I've done it right, do I need to factor in headtube angle, was hoping not for quick and dirty calculation?) suggests 55 will require 55mm of spacers with a 100mm 12 degree stem. Flat handlebar so calculation not complicated by bar reach.
Reach Stack Stem Length Angle Stem Stack Spacers HBar Reach HBar Stack
386.5 583.9 100 12 0 55 484.3147499 659.691217
392.8 609.6 100 12 0 30 490.6147499 660.391217
Whereas the 58 will only require 30mm and have also have only 20cm rather than 23cm of exposed seatpost