View Full Version : Gear/tire calculator
Dipstick
03-03-2007, 01:29 AM
Threw this excel spreadsheet together today. It calculates tire size from P-metric dimensions and uses that with tranny gears and final gear to calculate speed and it graphs it. I made it to compare different gears and tires sizes and visually be able to see it to find the best combination.
Enjoy!
www.ludicrouslouis.com/wp-content/uploads/2007/03/gearcalculator.xls (http://www.ludicrouslouis.com/wp-content/uploads/2007/03/gearcalculator.xls)
let me know if you see anything wrong or anywhere it could be improved.
Grant Rogers
www.ludicrouslouis.com (http://www.ludicrouslouis.com/)
andrewb70
03-03-2007, 05:27 AM
Looks good. I would highlight the cells that are used for input. I also noted that while the calculated radius is correct for a given tire size, the actual diameters of tires for a given size are slightly different. Maybe there is a way to change it so if particular size tire has a known diameter it can be used instead of the derived diameter calculation. Just an idea. Nice work.
Andrew
Nice job. Cool Graphs!
I've also noticed that the actual radius of a given size varies from one tire manufacturer to the next. I wrote a spreadsheet calculator that I use for myself, but it relies on you knowing the advertised revs/mile of the particular brand and size tire in question.
Admittedly, my spreadsheet is not as nice as yours, but I've found it useful. Now that I've see yours I may try to incorporate a graph into mine as well. I don't have it hosted anywhere, but if anybody would like to have it, I'll gladly e-mail it.
Dipstick
03-04-2007, 11:52 AM
Thanks. Anyone know how to have multiple inputs point to a cell? It would definitely be nice to input what you know about the tire like, P-metric, rev/mile or diameter.
Hoot, could you email your spreadsheet to me? That would be nice to incorpoarte into mine aswell. We can make the most complete one and maybe they can sticky it on this thread for people to use
Grant
Dipstick
03-05-2007, 12:13 AM
I just posted a revised version. added a few things from Hoot's (thanks) so now you can select P=metric, Diameter, or Revs/mile to input.
www.ludicrouslouis.com/wp-content/uploads/2007/03/gearcalculator.xls (http://www.ludicrouslouis.com/wp-content/uploads/2007/03/gearcalculator.xls)
Grant Rogers
www.ludicrouslouis.com (http://www.ludicrouslouis.com/wp-content/uploads/2007/03/gearcalculator.xls)
Powered by vBulletin®