Go Back  Bike Forums > Bike Forums > Road Cycling
Reload this Page >

Spreadsheet of Measurements

Search
Notices
Road Cycling “It is by riding a bicycle that you learn the contours of a country best, since you have to sweat up the hills and coast down them. Thus you remember them as they actually are, while in a motor car only a high hill impresses you, and you have no such accurate remembrance of country you have driven through as you gain by riding a bicycle.” -- Ernest Hemingway

Spreadsheet of Measurements

Thread Tools
 
Search this Thread
 
Old 03-12-11, 08:09 PM
  #1  
In Real Life
Thread Starter
 
Machka's Avatar
 
Join Date: Jan 2003
Location: Down under down under
Posts: 52,152

Bikes: Lots

Mentioned: 141 Post(s)
Tagged: 0 Thread(s)
Quoted: 3203 Post(s)
Liked 596 Times in 329 Posts
Spreadsheet of Measurements

First, have you measured all your bicycles and put the measurements into a spreadsheet or similar document?

Second, what measurements have you done?

~~~~~~~~~~~~~~~~~~~~~
I had a spreadsheet with the measurements for all my bicycles at one point, but then my hard drive crashed and took that with it. So I recreated it a number of years ago, but so far only have 2 of my bicycles on it. One day soon, I'll have to do the rest.

This spreadsheet was invaluable to me when Machak, my Marinoni Ciclo was stolen. He was a customised custom-built bicycle and was very comfortable. Having my spreadsheet of measurements meant that Rowan and I could select a frame to build up, and know that the frame would work for me.

We sat in the shop with the frame, my spreadsheet, and a measuring tape, and checked everything ... and then bought the frame because it was a very close match. If I had a complaint about Machak, it was that his top tube was a little bit too long ... and the new Hasa titanium frame has a slightly shorter top tube.

So, I measure the following things ...
  • Seat Tube (Center of Bottom Bracket to Top of Seat Tube)
  • Notional Seat Tube (Centre of Bottom Bracket to Level from Centre of Front of Top Tube)
  • Top Tube (Center of Head Tube to Center of Seat Tube)
  • Down Tube
  • Seat Stay
  • Chain Stay
  • Nose of Saddle to Center of Handlebar
  • Center of Seatpost (at top) to Center of Handlebar
  • Handlebar Width (Center to Center)
  • Crankarm
  • Bottom Bracket to Top of Saddle at angle of Seat Tube


What do you measure? I'm wondering if there should be other things I need to add to my spreadsheet.
Machka is offline  
Old 03-12-11, 08:18 PM
  #2  
Senior Member
 
Join Date: Jul 2009
Posts: 1,159
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
um ok
darb85 is offline  
Old 03-12-11, 08:23 PM
  #3  
In Real Life
Thread Starter
 
Machka's Avatar
 
Join Date: Jan 2003
Location: Down under down under
Posts: 52,152

Bikes: Lots

Mentioned: 141 Post(s)
Tagged: 0 Thread(s)
Quoted: 3203 Post(s)
Liked 596 Times in 329 Posts
Originally Posted by darb85
um ok
Don't you measure your bicycles?
Machka is offline  
Old 03-12-11, 08:25 PM
  #4  
Senior Member
 
Join Date: Jul 2009
Posts: 1,159
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
i Fit my self to the bike. Everything else doesnt matter. ive got bikes with different seat and head tube angles that throw off measurements. Measurements only mean something if you measure from the exact same spot everytime. SPecialized XY tool works for me and then I still go through a fit.
darb85 is offline  
Old 03-12-11, 08:35 PM
  #5  
cowboy, steel horse, etc
 
LesterOfPuppets's Avatar
 
Join Date: Sep 2008
Location: The hot spot.
Posts: 44,837

Bikes: everywhere

Mentioned: 71 Post(s)
Tagged: 1 Thread(s)
Quoted: 12768 Post(s)
Liked 7,684 Times in 4,078 Posts
I don't bother with seatstay length, bar width, crank length really. Well maybe bar width when I get a used bike and wonder what size they are. All the cranks I've had have the size stamped on them.

I also measure BB drop thusly : Loosen QRs, run string along top of axles, measure distance from center of crank bolt to string, subtract 5mm (assuming 10mm axles).

Last edited by LesterOfPuppets; 03-12-11 at 08:47 PM. Reason: add, subtract, what's the difference?
LesterOfPuppets is offline  
Old 03-12-11, 08:44 PM
  #6  
In Real Life
Thread Starter
 
Machka's Avatar
 
Join Date: Jan 2003
Location: Down under down under
Posts: 52,152

Bikes: Lots

Mentioned: 141 Post(s)
Tagged: 0 Thread(s)
Quoted: 3203 Post(s)
Liked 596 Times in 329 Posts
Originally Posted by darb85
Measurements only mean something if you measure from the exact same spot everytime.
Yes. And you can do that with levels.


I figure if I'm going to spend a lot of money, time and effort to get a bicycle that fits, I want to know the measurements of that bicycle so that the next time I spend money on a bicycle, I am confident I am getting one that will work for me.
Machka is offline  
Old 03-12-11, 09:22 PM
  #7  
Senior Member
 
Join Date: Mar 2010
Posts: 1,204

Bikes: Colnago C59 Italia Di2

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time in 1 Post
I note my fit and record all measuements i need to recreate that fit if the bike is destroyed or stolen.

I have a spreadsheet which I use to compare frames. For example my specialized has a 17 mm longer horizontal top tube than my colnago but that doesnt mean the reach is 17 mm longer because angles and HT length are different. the reach is actually 8.8mm longer

Therefore my spreadsheet allows me to enter horizontal top tube length, seat tube length and angle, head tube length and angle, stem length and angle and bar reach, number of spacers and headset size, bar drop.

This allows me calculate very easily for a given frame, what bar and stem and spacers i will need to acheive the same front end position as my "known" good fitting bike in terms of reach and height. Thats reach, not distance to saddle which will depend on the saddle.

A lot of people think that a 17mm shorter top tube will result in you needing a 17mm longer stem to get the same fit but if you work it out that is not correct. I was able to walk in to the shop and tell them the frame size i wanted the stem length and number of spacers for a frame I had never ridden and know that it was right. When I got home and measured it in real life, it was exactly the same as my other bike.

It was a very useful tool when buying a bike. I was also able to show that no trek will fit me as good a my colnago as their TT are longer and the result is I end up with more spacers and a short stem with too much drop or just a very short stem. I proved this with a test ride of the closest fitting frame. It was fine but I wanted a 90mm stem as predicted
lazerzxr is offline  
Old 03-13-11, 06:56 AM
  #8  
Senior Member
 
JaceK's Avatar
 
Join Date: Jul 2009
Location: Saratoga, NY
Posts: 613

Bikes: 2007 Trek Madone 5.9 (Shimano DA), 2008 Kuota Khan (SRAM Red), 2009 Giant OCR2 ( Shimano 105 ), Lynsky R340 ( SRAM Rival )

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
weird... here I thought those specs published by manufacturers were the measurements.
JaceK is offline  
Old 03-13-11, 07:10 AM
  #9  
Senior Member
 
BentLink's Avatar
 
Join Date: Jan 2010
Location: Pennsyl-tuckey
Posts: 684

Bikes: '86 Cannondale SR400, '86 Pugeot PX10, '92 Bianchi Axis, '95 Bianchi Campione d'Italia, '00 Fondriest X-Status, '08 Specialized Roubaix, '13 Cannondale CAADX

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 2 Times in 2 Posts
Park Tool has a bike position measurement method and recording form available. It has instruction, pictures, and things you need to document a bike that fits so you can transfer this to another bike or get it back when replacing components. I just started using it with my acquisition of a Peugeot this January, so I only used it a little.
BentLink is offline  
Old 03-13-11, 07:30 AM
  #10  
In Real Life
Thread Starter
 
Machka's Avatar
 
Join Date: Jan 2003
Location: Down under down under
Posts: 52,152

Bikes: Lots

Mentioned: 141 Post(s)
Tagged: 0 Thread(s)
Quoted: 3203 Post(s)
Liked 596 Times in 329 Posts
Originally Posted by JaceK
weird... here I thought those specs published by manufacturers were the measurements.
Do you just purchase common "off the shelf" bicycles? And what about fit ... like stem length, height of saddle etc.?
Machka is offline  
Old 03-13-11, 07:33 AM
  #11  
In Real Life
Thread Starter
 
Machka's Avatar
 
Join Date: Jan 2003
Location: Down under down under
Posts: 52,152

Bikes: Lots

Mentioned: 141 Post(s)
Tagged: 0 Thread(s)
Quoted: 3203 Post(s)
Liked 596 Times in 329 Posts
Originally Posted by BentLink
Park Tool has a bike position measurement method and recording form available. It has instruction, pictures, and things you need to document a bike that fits so you can transfer this to another bike or get it back when replacing components. I just started using it with my acquisition of a Peugeot this January, so I only used it a little.
I like that ... I'll have to print that form.
Machka is offline  
Old 03-13-11, 08:17 AM
  #12  
Sua Ku
 
rollin's Avatar
 
Join Date: Aug 2006
Location: Hot as hell, Singapore
Posts: 5,705

Bikes: Trek 5200, BMC SLC01, BMC SSX, Specialized FSR, Holdsworth Criterium

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 1 Time in 1 Post
Originally Posted by BentLink
Park Tool has a bike position measurement method and recording form available. It has instruction, pictures, and things you need to document a bike that fits so you can transfer this to another bike or get it back when replacing components. I just started using it with my acquisition of a Peugeot this January, so I only used it a little.
That's a great resource, thanks.

I have some scrawls on a note which is in my travel case.
rollin is offline  
Old 03-13-11, 09:39 AM
  #13  
Senior Member
 
8Lives's Avatar
 
Join Date: Jan 2007
Location: Berkeley, CA
Posts: 461

Bikes: Lemond Zurich

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I came at this a little differently. My LBS has a couple of different measurement tools, but for my new Parlee we used the size cycle. Basically that gives you the two critical XY measurements - position of feet, hips, hands. Once you have your coordinates "in space" you should be able to fit from there.
8Lives is offline  
Old 03-13-11, 11:03 AM
  #14  
Senior Member
 
snowman40's Avatar
 
Join Date: Feb 2009
Location: Orange County, CA
Posts: 1,173

Bikes: Fuji

Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 8 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by Machka
Do you just purchase common "off the shelf" bicycles? And what about fit ... like stem length, height of saddle etc.?
Test rides, bike fitting and communicating with the sales guy about what I like and dislike about my current bike. When I got my Felt, I told the salesman I didn't like the stretched out feeling I have on my Fuji (a tourer and it feels to big, even though it is the "right size") and the numb cornering feeling. A few test rides later, I got my Felt F75 and it fits like an old broken in pair of shoes, when it was assembled, the salesman (also the mechainic) put a shorter stem than normal. I spent more time at the fitting getting used to clipping in and out, adjusting the cleats, and doing other fine tuning adjustments (handlebar angle, really minute stuff). We A-B-A-C a lot, almost always ended up back at A.

It fits so perfect, is comfortable, and really really fast!
snowman40 is offline  
Old 03-13-11, 01:16 PM
  #15  
Senior Member
 
Join Date: Mar 2009
Location: San Diego, CA
Posts: 2,606
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Just goes to show you, no matter how retentive you are there's always someone else more so. Yeah, I measure all kinds of stuff especially when I was deciding which TT frameset to get. I compared the P3, Siice and 8 different Chinese models side-by-side. For my bikes I record in a notebook I keep on my bike stand all the fit measurements. Great park document and it's "cute" how they use a board to get a straight line. I use two laser levels mounted on tri-pods. GL
kleinboogie is offline  
Old 03-13-11, 05:50 PM
  #16  
In Real Life
Thread Starter
 
Machka's Avatar
 
Join Date: Jan 2003
Location: Down under down under
Posts: 52,152

Bikes: Lots

Mentioned: 141 Post(s)
Tagged: 0 Thread(s)
Quoted: 3203 Post(s)
Liked 596 Times in 329 Posts
Originally Posted by lazerzxr
I note my fit and record all measuements i need to recreate that fit if the bike is destroyed or stolen.

I have a spreadsheet which I use to compare frames. For example my specialized has a 17 mm longer horizontal top tube than my colnago but that doesnt mean the reach is 17 mm longer because angles and HT length are different. the reach is actually 8.8mm longer

Therefore my spreadsheet allows me to enter horizontal top tube length, seat tube length and angle, head tube length and angle, stem length and angle and bar reach, number of spacers and headset size, bar drop.

This allows me calculate very easily for a given frame, what bar and stem and spacers i will need to acheive the same front end position as my "known" good fitting bike in terms of reach and height. Thats reach, not distance to saddle which will depend on the saddle.

A lot of people think that a 17mm shorter top tube will result in you needing a 17mm longer stem to get the same fit but if you work it out that is not correct. I was able to walk in to the shop and tell them the frame size i wanted the stem length and number of spacers for a frame I had never ridden and know that it was right. When I got home and measured it in real life, it was exactly the same as my other bike.

It was a very useful tool when buying a bike. I was also able to show that no trek will fit me as good a my colnago as their TT are longer and the result is I end up with more spacers and a short stem with too much drop or just a very short stem. I proved this with a test ride of the closest fitting frame. It was fine but I wanted a 90mm stem as predicted
Very interesting ... you've taken it further than I have with the angles, but I've been tempted to do that too. And very interesting results when you use it to purchase a bicycle. That's one of the most significant things I've used the measurements for ... I can go in and buy a frame and be confident it will work for me.
Machka is offline  
Old 03-13-11, 05:54 PM
  #17  
Senior Member
 
Join Date: Jun 2003
Posts: 16,771
Mentioned: 125 Post(s)
Tagged: 0 Thread(s)
Quoted: 1454 Post(s)
Liked 85 Times in 40 Posts
Originally Posted by JaceK
weird... here I thought those specs published by manufacturers were the measurements.
I suppose only for dudes like you with plenty of cash to buy the latest off-the-shelf bling bikes.

But some of us also are into older bikes for which the manufacturers' measurements have disappeared off the net.

There also is some degree of confusion or disagreement over how frames should be measured, especially with the advent of compact frames. There then needs to be, in our case, a standardised form of measuring the notional top tube and seat tube lengths, especially as the "base data" bikes had or have frames with level or almost level top tubes.

There is a tendency for some published measurements by manufacturers to blur the method of measuring the top and seat tubes.
Rowan is offline  
Old 03-13-11, 11:49 PM
  #18  
Senior Member
 
Join Date: Mar 2010
Posts: 1,204

Bikes: Colnago C59 Italia Di2

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time in 1 Post
Originally Posted by JaceK
weird... here I thought those specs published by manufacturers were the measurements.
They are the measurements but you have to use them correctly to compare two bikes.

As i said 17mm shorter top tube does not mean 17mm less reach. Almost all manufacturers quote horizontal top tube length measured from centre line of seat tube to centre line of the top of the head tube. They also quote head tube length

If you look at the sketch you can see that frame B with shorter top tube also has a shorter head tube. Therefore to calculate the the change in reach you need to take off the 17mm but then add on the reach associated with dropping 20mm at 73 degrees. This can be a significant change in reach particularly if comparing a high end race bike with a tourer for example. Then you need to consider the height of the headset on both bikes and the spacers used which all adjust height and reach sometimes as much as flipping a stem or changing length by a size or two.

Then factor in bar reach, stem angle and reach, and you can compare the fit of your known bike and another (details taken from online tables) without ever even seeing one in the flesh. Of course you need to know your current bike dimensions and this is only half the story as you need to make sure your seat is in the right place too. Bikes come with different set back posts and often the manufacturer is more interested in telling you the post is carbon than telling you it has 20mm set back where last years model had no set back etc.

By the time you get into different frame angles and wondering just how many spacers you need bla bla bla you will find a spreadsheet is very useful. Like I said, I just walked in the shop, told them exactly what i wanted, no questions asked and nailed it firts go with identical fit to my other bike



I am a super geek tho
lazerzxr is offline  
Old 03-14-11, 03:25 AM
  #19  
Sua Ku
 
rollin's Avatar
 
Join Date: Aug 2006
Location: Hot as hell, Singapore
Posts: 5,705

Bikes: Trek 5200, BMC SLC01, BMC SSX, Specialized FSR, Holdsworth Criterium

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 1 Time in 1 Post
Originally Posted by lazerzxr
I am a super geek tho
Correct
rollin is offline  
Old 12-20-14, 04:54 AM
  #20  
In Real Life
Thread Starter
 
Machka's Avatar
 
Join Date: Jan 2003
Location: Down under down under
Posts: 52,152

Bikes: Lots

Mentioned: 141 Post(s)
Tagged: 0 Thread(s)
Quoted: 3203 Post(s)
Liked 596 Times in 329 Posts
A little update on this ...

When we ordered our Bike Fridays, they asked us for measurement details on the bicycles we currently own, and on which we currently feel comfortable, so that they could build us a bicycle that fits.

So Rowan and I both updated our spreadsheets with the measurements of several of our bicycles, and we added more columns for specific measurements that Bike Friday asked for.

Those spreadsheets have been a useful reference ... for our titanium bicycles, for our touring bicycles and for our Bike Fridays.
Machka is offline  
Old 12-20-14, 07:59 AM
  #21  
~>~
 
Join Date: Mar 2013
Location: TX Hill Country
Posts: 5,931
Mentioned: 87 Post(s)
Tagged: 0 Thread(s)
Quoted: 1112 Post(s)
Liked 180 Times in 119 Posts
Originally Posted by Machka
First, have you measured all your bicycles and put the measurements into a spreadsheet or similar document?
So, I measure the following things ...
  • Seat Tube (Center of Bottom Bracket to Top of Seat Tube)
  • Notional Seat Tube (Centre of Bottom Bracket to Level from Centre of Front of Top Tube)
  • Top Tube (Center of Head Tube to Center of Seat Tube)
  • Down Tube
  • Seat Stay
  • Chain Stay
  • Nose of Saddle to Center of Handlebar
  • Center of Seatpost (at top) to Center of Handlebar
  • Handlebar Width (Center to Center)
  • Crankarm
  • Bottom Bracket to Top of Saddle at angle of Seat Tube

Well done, a proper Old School methodology.
I include BB height, pedal/shoe info, KOPS, reach/drop and bar type as well.
I've logged my build details since the 70's and transferred the data to a spreadsheet w/ serial # and pic for insurance purposes as well as fit.
When I built my last two bikes I used the data to replicate my fit: bang on w/ no guesswork, wasted time or component $.

-Bandera
Bandera is offline  
Old 12-20-14, 08:38 AM
  #22  
Senior Member
 
Join Date: Jun 2008
Location: Northern VA
Posts: 3,247

Bikes: Moots Vamoots, Colnago C60, Santa Cruz Stigmata CC, and too many other bikes I don't ride

Mentioned: 7 Post(s)
Tagged: 0 Thread(s)
Quoted: 152 Post(s)
Likes: 0
Liked 7 Times in 6 Posts
If you are only concerned with fitting all bike the same way, assuming you are going to use the same crank arm length, then you only need to know:

- saddle top to bb offset (verticle)
- saddle tip to bb offset (horizontal)
- bb to hood offset (v)
- bb to hood offset (h)

All other measurement can be either derived from these or doesn't matter in term of fit. There are other measurement contributes to how the bike feels, such as bb height or tube angles.

I normally keep the manufacturers stack and height and other geometry measurement for each bike, and then keep these measurements for fitting. I measure each bike by having the front wheel against the wall, and measure everything by the subtracting the distances measured to wall or ground for the offsets.
dalava is offline  
Old 12-20-14, 08:39 AM
  #23  
Senior Member
 
wphamilton's Avatar
 
Join Date: Apr 2011
Location: Alpharetta, GA
Posts: 15,280

Bikes: Nashbar Road

Mentioned: 71 Post(s)
Tagged: 0 Thread(s)
Quoted: 2934 Post(s)
Liked 341 Times in 228 Posts
I do keep a spreadsheet with the standard measurements, plus stem length and effective top tube. But then those don't uniquely specify my particular fit to the bike, so I also have a saddle to hoods measurement. From the wide part of the saddle center, straight forward to intersect the line between the hoods. Since that's really what the reach is. Then also from the saddle top at the sitbone area to the pedal top with the pedal at the furthest extension. Which you could calculate with your other measurements along with set-back, but it's easier to just measure.
wphamilton is offline  
Old 12-20-14, 10:26 AM
  #24  
bt
Banned
 
Join Date: Mar 2008
Posts: 2,664
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time in 1 Post
stack, reach, seat tube angle, done.
bt is offline  
Old 12-20-14, 12:16 PM
  #25  
Senior Member
 
Join Date: Jun 2008
Location: Northern VA
Posts: 3,247

Bikes: Moots Vamoots, Colnago C60, Santa Cruz Stigmata CC, and too many other bikes I don't ride

Mentioned: 7 Post(s)
Tagged: 0 Thread(s)
Quoted: 152 Post(s)
Likes: 0
Liked 7 Times in 6 Posts
Originally Posted by bt
stack, reach, seat tube angle, done.
Not done.
dalava is offline  


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.