Road Cycling - Gear and Cadence Table

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.




View Full Version : Gear and Cadence Table


jmlee
04-16-02, 03:12 AM
For those who have not been following the Cadence???? thread, I thought I would announce the posting of my Gear-Cadence table.

This is a table in which you may enter your gearing and desired cadences. It will then produce for you a chart of gearratios, gear-inches, and for each cadence, the speed at which you are travelling (in km/h or mph). With this information, you can create a small table which you tape to your handlebar stem. Then, when you know your speed (from your cyclometer), you'll know your cadence.

It is presently set up for two chainrings. I'll see what I can do to create a three chainring version in the next few days.

It is an Excel worksheet, so you have to have Excel to use it.

There are instructions at the bottom of the table. Please read them, or you may end up corrupting the calculations.

To download go to: http://www.uni-bonn.de/~jmlee/

Have fun with it!
Cheers,
Jamie


RonH
04-16-02, 03:40 PM
jamie,
You have 2 bad links to the Excel spreadsheets.
Your links are
http://www.uni-bonn.de/~jmlee/Gear-Cadence Table_2.xls
and
http://www.uni-bonn.de/~jmlee/Gear-Cadence Table_3.xls

They should be
http://www.uni-bonn.de/~jmlee/Gear-CadenceTable_2.xls
and
http://www.uni-bonn.de/~jmlee/Gear-CadenceTable_3.xls

No space between Cadence and Table.
But thanks for the charts. :)

jmlee
04-16-02, 03:53 PM
Thanks, Ron. I have now changed the filenames to read Gear-Cadence_Table_2.xls, etc. The space was in fact correct, but it is a bad Macintosh habit. The new file names should make it work more reliably.

Cheers,
Jamie


OctoberBlue
04-16-02, 08:36 PM
It works great now, jmlee. Thanks for fixing the links!

Joe Gardner
04-16-02, 08:40 PM
For thoes that do not own Excel, you can download Excel viewer for free from the microsoft.com website here: http://office.microsoft.com/downloads/2000/xlviewer.aspx

aerobat
04-16-02, 10:20 PM
Thanks, Joe, that helps.:D

jmlee
04-17-02, 05:19 AM
Update:

Just to let everyone know, I have posted new and updated versions of the Gear Cadence Tables at: www.uni-bonn.de/~jmlee.

There are now tables for 2 and 3 chainrings and for 7, 8, 9, & 10 cogs. This should save most users the trouble of deleting the extra rows.

Also, thanks for letting everyone know about the free Excel viewer. Alas, however, the viewer will not permit changing the values needed to customize the table to an individual set-up. Someday, perhaps, I may do a stand-alone version.

Cheers,
Jamie

joeprim
04-17-02, 06:05 AM
Thanks
This is the one that worked for me
http://www.uni-bonn.de/~jmlee/
Joe
:beer: