Advertise on Bikeforums.net



User Tag List

Results 1 to 6 of 6
  1. #1
    部門ニ/自転車オタク NomadVW's Avatar
    Join Date
    Dec 2005
    Location
    Yuma, AZ
    My Bikes
    2005 Specialized Roubaix Elite, 2005 Specialized FSR XC Comp, 2008 Blue T16, 2009 Blue RC8, Fetish Cycles Road Bike
    Posts
    3,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Envision, Energize, Enable

  2. #2
    dpr
    dpr is offline
    Insect magnet. dpr's Avatar
    Join Date
    Feb 2007
    Location
    Devon UK
    My Bikes
    Trek 2008 Madone 5.5 Pro, Bianchi 2008 Axis
    Posts
    465
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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!

  3. #3
    部門ニ/自転車オタク NomadVW's Avatar
    Join Date
    Dec 2005
    Location
    Yuma, AZ
    My Bikes
    2005 Specialized Roubaix Elite, 2005 Specialized FSR XC Comp, 2008 Blue T16, 2009 Blue RC8, Fetish Cycles Road Bike
    Posts
    3,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    2003
    Envision, Energize, Enable

  4. #4
    Yep
    Yep is offline
    no cat contains Yep's Avatar
    Join Date
    Oct 2006
    Location
    wintery and elevated
    Posts
    560
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Very cool. Is the nose-to-bars measurement to the center of the bars?
    Quote Originally Posted by Ryanf
    its a start: 1. measure thighs 2. get on bike 3. win
    cat 2 - 1/30

  5. #5
    部門ニ/自転車オタク NomadVW's Avatar
    Join Date
    Dec 2005
    Location
    Yuma, AZ
    My Bikes
    2005 Specialized Roubaix Elite, 2005 Specialized FSR XC Comp, 2008 Blue T16, 2009 Blue RC8, Fetish Cycles Road Bike
    Posts
    3,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yah, nose to center on top is how I measure.
    Envision, Energize, Enable

  6. #6
    部門ニ/自転車オタク NomadVW's Avatar
    Join Date
    Dec 2005
    Location
    Yuma, AZ
    My Bikes
    2005 Specialized Roubaix Elite, 2005 Specialized FSR XC Comp, 2008 Blue T16, 2009 Blue RC8, Fetish Cycles Road Bike
    Posts
    3,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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
    Envision, Energize, Enable

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •