There are a lot of websites out there with wonderful calculator tools and the charts that are floating around are also very handy. This is more of an accentuation of those existing tools. I figured someone else might find it useful for planning their build.
I tested it today against my build and it was nearly spot on, but the discrepancy was a little less than 1mph at 3000RPM in 4th. Obviously, the lower the revs, the more accurate it is. lol Just need to finesse the sidewall sag adjustment number.
This will allow you to instantly see how a gear change or tire change will effect your ride in both High and Low range. As near as I can tell, no other tool will do this as easily.
The Excel workbook includes all three US JK transmissions, 4 and 5 speed auto, and 6 speed manual. Keep the tab you need, delete the others. If you want to make a "future build" tab to test changes, just copy the tab you need and rename the new one. The scripting will be attached to the new tab.
Due to Microsoft's Infinite Wisdom, I think these aren't cross compatible, so . Let me know if there are issues.
For Excel 2010+
For Pre-2010 Excel
Worst case, Google Docs, or Open Office should be able to open one of them.
Example:
I tested it today against my build and it was nearly spot on, but the discrepancy was a little less than 1mph at 3000RPM in 4th. Obviously, the lower the revs, the more accurate it is. lol Just need to finesse the sidewall sag adjustment number.
This will allow you to instantly see how a gear change or tire change will effect your ride in both High and Low range. As near as I can tell, no other tool will do this as easily.
The Excel workbook includes all three US JK transmissions, 4 and 5 speed auto, and 6 speed manual. Keep the tab you need, delete the others. If you want to make a "future build" tab to test changes, just copy the tab you need and rename the new one. The scripting will be attached to the new tab.
Due to Microsoft's Infinite Wisdom, I think these aren't cross compatible, so . Let me know if there are issues.
For Excel 2010+
For Pre-2010 Excel
Worst case, Google Docs, or Open Office should be able to open one of them.
Example: