PSA - Excel to compare fit of old and new frame

Back by popular demand, the general all-things Road forum!

Moderator: robbosmans

Post Reply
jever98
Posts: 1175
Joined: Wed Feb 18, 2009 12:02 pm
Location: Seattle

by jever98

I have built a tool to calculate the fit of any frame for which you have stack, reach and HTA, compared to your current one, including spacers, stem length and angle. It's a simple geometry calculation, I find it useful if I want to figure out if frame x or y would fit me or not.

To use it, you need:
- Your current frame stack, reach, spacers, stem length and angle
- New frame stack, reach, head tube angle
- You should know whether your current handlebar coordinates are good or not

Can be downloaded here. It contains a bunch of frames that I collected over time, all in my size :).

Hope it's helpful to someone out there.
----
No longer in the industry

by Weenie


Visit starbike.com Online Retailer for HighEnd cycling components
Great Prices ✓    Broad Selection ✓    Worldwide Delivery ✓

www.starbike.com



User avatar
torob
Posts: 76
Joined: Sun Mar 23, 2014 2:28 pm
Location: Toronto, Ontario

by torob

This is really, really nice! Have you thought about putting it online (e.g., Google Spreadsheets) and asking others to contribute? It might take off.
Using Tapatalk


jever98
Posts: 1175
Joined: Wed Feb 18, 2009 12:02 pm
Location: Seattle

by jever98

Thanks! It's actually a google spreadsheet that I have converted to Excel for people to download.

Haven't spent time in coding something that could become a database. Would have to ask some code-friendly friends.
----
No longer in the industry

jever98
Posts: 1175
Joined: Wed Feb 18, 2009 12:02 pm
Location: Seattle

by jever98

@Ergott - it's less about the frame S&R, but to get the handlebar coordinates
----
No longer in the industry

User avatar
ergott
Posts: 2870
Joined: Tue Apr 18, 2006 3:03 am
Location: Islip, NY
Contact:

by ergott

Gotcha. I linked database for people to find S/R for a lot of frames in one place.

I use Bikecad when I'm comparing frames. Nice to have visual representation too.

Image
Last edited by ergott on Thu Sep 28, 2017 6:05 pm, edited 1 time in total.

jever98
Posts: 1175
Joined: Wed Feb 18, 2009 12:02 pm
Location: Seattle

by jever98

Good point :). The Slowtwitch DB has been my goto for TT frames for a while
----
No longer in the industry

by Weenie


Visit starbike.com Online Retailer for HighEnd cycling components
Great Prices ✓    Broad Selection ✓    Worldwide Delivery ✓

www.starbike.com



SilentDrone
Posts: 254
Joined: Fri Sep 22, 2017 5:55 pm

by SilentDrone

Thanks for sharing this. Subscribed!

Post Reply