Gear ratios & Cadence Calculator: freebie

Printable View

• 04-08-04, 11:49 AM
Don Cook
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.
• 04-08-04, 11:53 AM
Don Cook
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.
• 04-08-04, 12:17 PM
Stubacca
Thanks Don. Very handy.
• 04-08-04, 12:59 PM
madpogue
Cool. Now I need a way to download it to the no-cadence computer on my tandem :) .