Results 1 to 6 of 6
Thread: Gear/tire calculator
-
03-03-2007 #1
New to Pro-Touring
- Join Date
- Feb 2007
- Posts
- 22
Gear/tire calculator
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
let me know if you see anything wrong or anywhere it could be improved.
Grant Rogers
www.ludicrouslouis.com
-
03-03-2007 #2
-Moderator/Sponsor-
- Join Date
- Apr 2001
- Location
- The City of Fountains
- Posts
- 16,117
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.
Andrew1970 GTO Version 3.0
1967 Cougar build
GM High-Tech Performance feature
My YouTube Channel Please Subscribe!
Instagram @dr__efi
I deliver what EFI promises.
Remote Holley EFI tuning.
Please get in touch if I can be of service.
"You were the gun, your voice was the trigger, your bravery was the barrel, your eyes were the bullets." ~ Her
03-03-2007 #3
Registered User
- Join Date
- Dec 2006
- Posts
- 11
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.
03-04-2007 #4
New to Pro-Touring
- Join Date
- Feb 2007
- Posts
- 22
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
03-04-2007 #5
Registered User
- Join Date
- Dec 2006
- Posts
- 11
e-mail sent
03-05-2007 #6
New to Pro-Touring
- Join Date
- Feb 2007
- Posts
- 22
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
Grant Rogers
www.ludicrouslouis.com
Reply With Quote
