New version V8. Biomechanical & sizing & fitting spreadsheet

A light bike doesn't replace good fitness.

Moderator: Moderator Team

Post Reply
User avatar
beatnik
Posts: 1237
Joined: Thu Aug 03, 2006 6:38 pm

by beatnik

NEW VERSION V8




http://www.mediafire.com/file/5xnxnyynzih/Biomechanicalcyclingv8english.zip


New features V8:

Saddle length included for the calculation of setback.
Minor cosmetics issues.
Last edited by beatnik on Thu Jan 14, 2010 4:29 pm, edited 23 times in total.
Biomechanical spreadsheet. Sizing&Fitting.

http://weightweenies.starbike.com/forum ... 8e319d185b

User avatar
Amadeus
Posts: 1461
Joined: Sun Jan 08, 2006 5:53 pm
Location: Leiden, NETHERLANDS

by Amadeus

@Beatnik

Goood idea!

Your spread sheet is a good guide line!

I told you so before!
My bike is Italian so it is Nervosa and of course has Anorexia I like them thin!
GIOS "New" Carbon Ultra 2006 Campa Record+Special parts.
GIOS "New" A90 2008 Campa Record+Special parts. My winter and vacation bike.

by Weenie


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

www.starbike.com



User avatar
kytyree
Posts: 973
Joined: Thu Oct 09, 2008 4:55 am
Location: US

by kytyree

you must have read my mind, I was reading some your posts the other day and was thinking I would like to look at that, thanks

User avatar
beatnik
Posts: 1237
Joined: Thu Aug 03, 2006 6:38 pm

by beatnik

Thx, it´s a good start, but somebody told me he felt better with minor adjustments. Be careful measuring your body lengths, it will helps a lot. Nevertheless i think it´s a very accurate fitting system, i helped a lot of people here in Spain in a famous forum (more than 5000 people) and everybody feels better riding and more powerful indeed. I was riding with this fit for 10 years without pain or injury, and i´ve done more than 100.000 km.

I hope it helps. Regards.
Biomechanical spreadsheet. Sizing&Fitting.

http://weightweenies.starbike.com/forum ... 8e319d185b

Landim
Posts: 9
Joined: Sun Dec 14, 2008 4:57 am

by Landim

Thanks a lot.

Do you give permission to publish it on a Brazilian Forum(with your credits of course)?

Leandro

User avatar
beatnik
Posts: 1237
Joined: Thu Aug 03, 2006 6:38 pm

by beatnik

Landim wrote:Thanks a lot.

Do you give permission to publish it on a Brazilian Forum(with your credits of course)?

Leandro


Sure :lol: and without credits too. :lol:
Biomechanical spreadsheet. Sizing&Fitting.

http://weightweenies.starbike.com/forum ... 8e319d185b

Rezne
Posts: 33
Joined: Mon Jul 07, 2008 3:54 pm
Location: the Netherlands

by Rezne

Question: Is the inseam and elbow-middle finger distance enought data to determine setback, saddle height, drop and saddle-bar distance, or am i forgetting someting..... ?

Thx :)
Let the legs do the talking

User avatar
Tapeworm
Posts: 2585
Joined: Thu May 03, 2007 10:39 am

by Tapeworm

Rezne wrote:Question: Is the inseam and elbow-middle finger distance enought data to determine setback, saddle height, drop and saddle-bar distance, or am i forgetting someting..... ?

Thx :)


No. But it's a good guide. Of course it can never replace a professional fit but it's probably a good place to start off.

User avatar
beatnik
Posts: 1237
Joined: Thu Aug 03, 2006 6:38 pm

by beatnik

It´s enough because there is a fixed proportion with other measures in the top part of the body (trunk). I tried to simplify it the most i could. With 2 measures you can fit your bike very well. I have a more complicated spreadsheet considering trunk length, frame angles and the height of your shoes and pedals, but it´s a matter of few milimiters, so i decided to publish the easiest one.

Just fit your bike according to the s.s. and feel the difference, then you can do minor adjustments (no more than 1 mm everytime), till you feel completely ok.

For example, i calculated "the best stem lenght" as an aproach, for setback or non setback seatpost (mtb-road). It´s not very accurate, because i haven´t considered frame angles, but you will find that your best stem length is exactly what i suggest.

The correct procedure is this one. (if you have the right frameset size or at least not very wrong)

1.- Fit your saddle height
2.- Fit your saddle-b.bracket setback ´
3.- Fit your saddle nose- handlebar axis lenght, and choose your best stem length according to your top tube length.
4.- Fit your saddle - handlebar height.

That´s all. I´m not a newbie and this is not just another internet fake, i´m engineer and cyclist till 1990, give me a chance and your body will thank it to you :lol:
Biomechanical spreadsheet. Sizing&Fitting.

http://weightweenies.starbike.com/forum ... 8e319d185b

User avatar
Tapeworm
Posts: 2585
Joined: Thu May 03, 2007 10:39 am

by Tapeworm

All the above I do not argue however there are things that the spreadsheet cannot cover. Leg length discrepancies, pelvic asymmetry, spinal issues, cleat positioning etc.

I am sure that there are some who will find the fit fine for them.

However human beings are by nature asymmetrical and not perfect and will not always fit to formula.

I still maintain that it is a good guide and the amount of work put into the spreadsheet is evident.

fast700c
Posts: 259
Joined: Sun Nov 19, 2006 2:15 pm
Location: Australia

by fast700c

I'm hopeless with computers, and cant seem to be able to get them to open.
Keep being told that the "CRC integrity test failed. The archive file is corrupted and cannot be opened."
I've tried downloading them twice, same thing.
What am I doing wrong???

User avatar
beatnik
Posts: 1237
Joined: Thu Aug 03, 2006 6:38 pm

by beatnik

I have downloaded right now and it works, try it again. And remember you need winrar ;)


Winrar link was broken, now it works.
Biomechanical spreadsheet. Sizing&Fitting.

http://weightweenies.starbike.com/forum ... 8e319d185b

User avatar
Amadeus
Posts: 1461
Joined: Sun Jan 08, 2006 5:53 pm
Location: Leiden, NETHERLANDS

by Amadeus

I say it again especially for "Tapeworm" ..... this is a very good guide-line to start with!

All systems are guide-lines no fit is exact.
My bike is Italian so it is Nervosa and of course has Anorexia I like them thin!
GIOS "New" Carbon Ultra 2006 Campa Record+Special parts.
GIOS "New" A90 2008 Campa Record+Special parts. My winter and vacation bike.

User avatar
Tapeworm
Posts: 2585
Joined: Thu May 03, 2007 10:39 am

by Tapeworm

Amadeus wrote:I say it again especially for "Tapeworm" ..... this is a very good guide-line to start with!

All systems are guide-lines no fit is exact.


Isn't that what I said?

User avatar
Amadeus
Posts: 1461
Joined: Sun Jan 08, 2006 5:53 pm
Location: Leiden, NETHERLANDS

by Amadeus

Sorry:..... didn't read the end of your last post.
My bike is Italian so it is Nervosa and of course has Anorexia I like them thin!
GIOS "New" Carbon Ultra 2006 Campa Record+Special parts.
GIOS "New" A90 2008 Campa Record+Special parts. My winter and vacation bike.

by Weenie


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

www.starbike.com



Post Reply