AnnDee4444

Well-Known Member
Joined
Jan 14, 2019
Messages
2,039
Reaction score
1,988
Location
Earth
Vehicle(s)
Jeep
Here's a spreadsheet I built to calculate gear ratio, tire size, speed, etc. The yellow colored cells are how to control the inputs (either drop-down or number fillable), all other cells are un-editable.


Capture.PNG



Update: Added a new tab to easily compare differential ratios in top gear. Also some slight changes to the input methods on the other tabs.

Capture.PNG


11/25/20 Update:
  • Combined the automatic & manual tabs
  • Added an option to input the revolutions/mile
  • When inputting tire diameter, the effective rolling diameter is now calculated at 97.1%.
Capture.PNG


12/1/20 Update: Added ability to compare two scenarios
12/8/20 Update: Added Axle Torque by Gear calculator





Advertisement

 
Last edited:
OP
AnnDee4444

AnnDee4444

Well-Known Member
Joined
Jan 14, 2019
Messages
2,039
Reaction score
1,988
Location
Earth
Vehicle(s)
Jeep
  • Thread starter
  • Thread Starter
  • #2
If you are having trouble using the spreadsheet because another user is currently editing it, you can download your own local copy in Excel format:
Download.png


Edit: Looks like the graphs don't convert to Excel anymore. Right now the only way to keep the graphs functioning is to keep it in Google Sheets and copy to your personal Google account:

Untitled.png
 
Last edited:

Sean L

Well-Known Member
First Name
Sean
Joined
Mar 9, 2018
Messages
26,484
Reaction score
133,182
Location
North Carolina
Vehicle(s)
2018 Jeep Wrangler Sahara, 2017 Honda Accord Sport, 2003 Yamaha V Star 650 Silverado, 2014 Yamaha V Star 1300 Tourer
Occupation
Retired Marine, Construction Estimator
Vehicle Showcase
2
This is pretty cool! Thanks for sharing it with us!
 

alphalife9

Well-Known Member
First Name
David
Joined
Nov 6, 2017
Messages
367
Reaction score
178
Location
Rio Rancho, NM
Vehicle(s)
Z51 C6, Sting Gray JLUR
This is awesome thank you. Fun to see changes and compare with auto vs. manual.
 

Harper

Well-Known Member
First Name
Jason
Joined
Jul 13, 2019
Messages
50
Reaction score
120
Location
Ann Arbor, MI
Website
www.myjeepadventures.com
Vehicle(s)
2020 Wrangler Black and Tan
Dude. This is so good. I was literally going to ask if someone had something like this. Thank you so much!!!! Honestly, seems to explain a lot.

Seriously, thank you for taking the time to do this and to share it!
 

JoeG

Active Member
First Name
Joe
Joined
Mar 27, 2018
Messages
43
Reaction score
27
Location
CA
Vehicle(s)
2018 Jeep Wrangler JL Rubicon
Thank you, much appreciated!
 

lbau317

Active Member
First Name
Larry
Joined
Aug 16, 2018
Messages
38
Reaction score
54
Location
60007
Vehicle(s)
2018 Wrangler JLU Sport
Vehicle Showcase
2
This is awesome, thank you!!
 

MCJA

Well-Known Member
First Name
Matthew
Joined
Oct 12, 2019
Messages
207
Reaction score
306
Location
Olympia, WA
Vehicle(s)
2020 Wrangler Unlimited Rubicon EcoDiesel
I made a similar tire size and gear ratio calculator and comparison a while back. I updated it for the JLs and added some instructions. It's very similar to AnnDee4444's, but shows RPMs at speed (instead of vice versa). It also lets you put in different tire and gear configurations you want to compare.


Note that in the preview mode above, the tables show "#N/A" errors. That's by design to make the charts more readable, but Google Docs doesn't display it properly. I recommend you download your own copy to edit, or open it in your browser in Google Sheets. (You can follow the same process AnnDee4444 posted if you want to download a copy.) There are no macros or VBScript - feel free to virus scan it.

Enjoy!
 
Last edited:

MoquitoVerde

Well-Known Member
First Name
Phil
Joined
Dec 18, 2018
Messages
72
Reaction score
60
Location
Austin, TX
Vehicle(s)
2019 Jeep Wrangler Rubicon 2.0 Turbo
I made a similar tire size and gear ratio calculator and comparison a while back. I updated it for the JLs and added some instructions. It's very similar to AnnDee4444's, but shows RPMs at speed (instead of vice versa). It also lets you put in different tire and gear configurations you want to compare.


Note that in the preview mode above, the tables show "#N/A" errors. That's by design to make the charts more readable, but Google Docs doesn't display it properly. I recommend you download your own copy to edit, or open it in your browser in Google Sheets. (You can follow the same process AnnDee4444 posted if you want to download a copy.) There are no macros or VBScript - feel free to virus scan it.

Enjoy!
I dont see a link or way to open your spreadsheet.
Have you taken delivery of your Ecodiesel Rubicon? What do you think of it so far?
 

Advertisement




ATO4x4
 



Advertisement
Top