PSA - Excel to compare fit of old and new frame

Discuss light weight issues concerning road bikes & parts.
Post Reply
jever98
Posts: 819
Joined: Wed Feb 18, 2009 12:02 pm

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

User avatar
torob
Posts: 53
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

by Weenie



jever98
Posts: 819
Joined: Wed Feb 18, 2009 12:02 pm

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: 819
Joined: Wed Feb 18, 2009 12:02 pm

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: 2770
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: 819
Joined: Wed Feb 18, 2009 12:02 pm

by jever98

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

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

by SilentDrone

Thanks for sharing this. Subscribed!

by Weenie


Post Reply
  • Similar Topics
    Replies
    Views
    Last post