That one awesome? Not for me; it won't do the calculations for my setup because the author hard-coded the entries and didn't include mine.
I updated your spreadsheet once more. Now everything changeable is in pull down menus.
Hey guys, thank you for your work on the gearing Excel/OpenOffice sheet! I'm not trying to stop you. Also, just to clarify, I have no personal interest in that on-line tool. I just think that this is another useful tool to help people with gearing, and shouldn't be discarded too easily.
So with that out of the way, what didn't work well for you in the on-line gearing calculator?
Not much is hard-coded there and it does derailleurs well too. I believe this link below matches the cassette and wheel circumference in RTIII's Excel sheet, with the TSDZ2 standard ring:
http://www.gear-calculator.com/?GR=DERS ... 2.6&UN=MPH
It will also show the exact speed at each gear if you select 'Display: Speed'. You can slide the images of the gears left and right to adjust the tooth count of each sprocket, you can add more gears by dragging extra gears in from the left, and remove them by dragging them away.
Also, just as a bonus, a race
! Just drag in another ring from the left, and voila: a setup with a second 52T ring which I believe RTIII has installed already. And then add ANOTHER setup, Patoruzu's, to compare. I made an assumption on which 9-speed cassette you have and assumed you'd install a 52T ring as you hoped, just like RTIII, plus the 40-622 tires you've been thinking of.
http://www.gear-calculator.com/?GR=DERS ... 2&UF2=2220
Don't forget to click on 'Display: Speed' again. Conclusion: If your TSDZ2's go the same rpm, Patoruzu (at the bottom) will go slightly faster: 35.2 mph vs 34.2 mph
. It's because of his larger diameter tires.