Bike Forums

Bike Forums (http://www.bikeforums.net/forum.php)
-   General Cycling Discussion (http://www.bikeforums.net/general-cycling-discussion/)
-   -   Gear ratios & Cadence Calculator: freebie (http://www.bikeforums.net/general-cycling-discussion/49400-gear-ratios-cadence-calculator-freebie.html)

Don Cook 04-08-04 11:49 AM

Gear ratios & Cadence Calculator: freebie
 
I've norticed 2 or 3 threads in the last week that were focused on either how to figure out either your gear ratios or your cadence. I'm attaching a spreadsheet that answers all those questions and more.
It will automaically calculate you gear ratios based on whatever chain ring and rear cog combinations you enter. And if you enter you wheel circumference and any given cadence, it will calculate your exact speed for each gear combination. The second worksheet looks at cadence. If you enter your chain ring and cassette information, then your wheel circumference, for any given speed it will calculate the exact cadence.

The spreadsheet is attached to this post.

Don Cook 04-08-04 11:53 AM

1 Attachment(s)
Quote:

Originally Posted by Don Cook
I've norticed 2 or 3 threads in the last week that were focused on either how to figure out either your gear ratios or your cadence. I'm attaching a spreadsheet that answers all those questions and more.
It will automaically calculate you gear ratios based on whatever chain ring and rear cog combinations you enter. And if you enter you wheel circumference and any given cadence, it will calculate your exact speed for each gear combination. The second worksheet looks at cadence. If you enter your chain ring and cassette information, then your wheel circumference, for any given speed it will calculate the exact cadence.

The spreadsheet is attached to this post.

I thought it was attached, but I guess not. Let's try it again in a "winzip" format.

Stubacca 04-08-04 12:17 PM

Thanks Don. Very handy.

madpogue 04-08-04 12:59 PM

Cool. Now I need a way to download it to the no-cadence computer on my tandem :) .


All times are GMT -6. The time now is 06:11 AM.