- Gear Inches
- Distance Traveled
- Wheel Turns
With this latest version, you can:
- Enter your wheel circumference in millimeters and directly see what the wheel diameter is, in inches. This is handy if you have already got the circumference written down somewhere or entered into a bike computer, because doing it this way means no measuring at all needs to be done, just put the millimeters value into the calc and it tells you the wheel diameter in inches, that can then be entered into the main "Wheel Diameter" box.
- Enter the circumference in any units to get the diameter. This doesn't relate to millimeters or inches and is simply a direct calculation of circumference value to diameter value.
- See what your inches diameter works out to in feet (for this, you need to have entered it in inches in the main Wheel Diameter box).
- See what the circumference is. This doesn't relate to millimeters or inches and is simply a direct calculation of whatever wheel diameter you entered in the main box, to a circumference value.
- See what the inches diameter works out to in meters. This only works if you have entered inches for the Wheel Diameter and it's here so you can then type this figure into the diameter box to see "Meters Development" in the middle chart.
- See the circumference in millimeters, assuming you entered your Wheel Diameter in inches in the main box. It's not likely anyone would measure the diameter first (hub gets in the way of taking an accurate measurement!) but this is also included here anyway.
If you want your units in meters, it's easy - you can just put your wheel diameter in meters and that's it done. This would then translate to "Meters Development" in the middle chart where distance traveled is displayed.
With the colour coding this also has, you can quickly see where gear combinations are overlapping.
Inspired by the Sheldon Brown calculator, this gear calculator covers up to 12-speed and also includes the difference between each sprocket, for any given chainring and sprocket combination, in the grey boxes between the main coloured boxes.
Here's the full blurb from the info in the spreadsheet:
Code: Select all
These charts can show you the gear inches (or feet, or meters) your
chainring and sprocket combinations are going to end up giving you.
It can cover a single, double or triple chainset, up to 12 sprockets.
Firstly, type your wheel diameter in the box under "Wheel Diameter".
This wheel diameter can be any unit of measurement you want, E.G.
inches, meters, feet, etc. Whatever units you choose for the wheel
diameter will also be the units that come out on the charts.
YOU ONLY NEED TO ENTER YOUR CHAINRING AND SPROCKET TEETH ON THE FIRST
CHART, THE OTHER TWO CHARTS WILL AUTOMATICALLY UPDATE THEMSELVES.
In the blue box to the right of the "LOW" box, type in the number of teeth on
your cassettes low (biggest) sprocket and carry on filling in the blue boxes going
down that column, until you end up at your high (smallest) sprocket.
Do not delete anything from any of the boxes. If you are not running a 12-speed
cassette and don't need to use the spare blue boxes for sprockets you do not have,
just put a 0 in those boxes, all the figures will still be accurate for the sprockets
you do enter. All the numbers you type in the sprocket (and chainring) blue
boxes have a "t" after the number, meaning "teeth".
The purple boxes between sprockets and between chainrings show you the % gear
jump between each sprocket and chainring. You should start with the low (biggest)
sprocket and work your way to the high (smallest) sprocket because then, the
percentage jump between each sprocket will be correct.
Type in the chainring teeth in the blue boxes under "Chain Rings". This should have
the smallest chainring first, again so the percentage jump in between is displayed
accurately. The results in the grey boxes are the difference between each gear jump.
When you have filled in your wheel diameter, chainring teeth and cassette teeth, you
will end up with the lowest gear at the top left and highest gear at the bottom right.
The figures are coloured, with the lowest gear in green, middle gears in yellow and
high gears in red.
Code: Select all
The spreadsheet is protected so you can only edit the cells you need to edit, this stops any accidental deleting of anything, but if you want to unprotect it, the password is "password".
Screenshot of the chart...