General Cycling Discussion - Gear ratios & Cadence Calculator: freebie

Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.




Don Cook
04-08-04, 11:49 AM
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
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 :) .