Go Back   Great Lakes 4x4. The largest offroad forum in the Midwest > 4x4 Talk > General Tech > General Tech FAQ
GL4x4 Live! GL4x4 Casino







Search
Reply
 
Thread Tools
Old February 3rd, 2006, 08:51 PM   #1
Haggar
Covered in mud...
 
Haggar's Avatar
 
Join Date: 11-06-05
Location: Oxford, MI
Posts: 17,381
iTrader: (52)
A nice gear chart calculator I made...

Its in Excel format.

I have created tabs with many of the common transmissions and transfer case gear ratios, and tire sizes (you need to enter tires as revs/mile)

Sure, there are online calculators. I like this because I can copy them and make a tab for each vehicle, or possible vehicle configuration.

Just type in your specifics in the white boxes and its all set.

Enjoy!


http://www.lordsofevolution.com/hagg.../gearchart.xls
Haggar is offline   Reply With Quote
Old February 19th, 2006, 02:35 PM   #2
Roadhouse
DrivewayJeeper
 
Roadhouse's Avatar
 
Join Date: 11-05-05
Location: Sanford
Posts: 10,953
iTrader: (5)
Jason, Nice spread sheet thanks for posting.
Roadhouse is offline   Reply With Quote
Old February 22nd, 2006, 02:08 PM   #3
noodles
give 'er sh*t ay?
 
noodles's Avatar
 
Join Date: 11-07-05
Location: holland Mi
Posts: 1,029
iTrader: (0)
Send a message via AIM to noodles Send a message via MSN to noodles Send a message via Yahoo to noodles
how do you figure out revs/mile?
noodles is offline   Reply With Quote
Old February 22nd, 2006, 04:55 PM   #4
Roadhouse
DrivewayJeeper
 
Roadhouse's Avatar
 
Join Date: 11-05-05
Location: Sanford
Posts: 10,953
iTrader: (5)
Quote:
Originally Posted by noodles
how do you figure out revs/mile?
Jason has most tires sizes on that spread sheet already 30" up to 44". Click on the bottom tab that says Tire Sizes.
Roadhouse is offline   Reply With Quote
Old February 22nd, 2006, 09:58 PM   #5
Haggar
Covered in mud...
 
Haggar's Avatar
 
Join Date: 11-06-05
Location: Oxford, MI
Posts: 17,381
iTrader: (52)
Its always tough to find them for big sizes. Up to 35" I have taken them from manufacturers like BF Goodrich, etc, who publish the sizes.

Above that, the sizes really start getting somewhat different from the sidewalls anyway, so those are pretty close approximations.


If you want to calculate a tire's revs per mile its this:

5280 feet
-----------------
Tire Circumference

Although, tire circumference isn't exactly the right term, since the tire bulges and has a lower effective rolling radius. So you calculate the circumference using the rolling radius.

Example:

If you have a 31" x 10.5" BFG AT on an 8" rim, it has a true rolling radius of 1.245 feet (14.94 inches). So the radius is 1.245 x 2 x 3.14159 = 7.82 feet.

Every rotation, therefore, will drive you forward 7.82 feet.

5280 / 7.82 = 675 rotations per mile.

So, if you went out and measured, say, a 49" IROCK, and it had a loaded radius of 23.5", then it would have a circumference of 12.30 feet. And would have approx 429 revolutions per mile.


Haggar is offline   Reply With Quote
Old April 4th, 2006, 09:06 AM   #6
FrankNBrew
Me balls are huge
 
FrankNBrew's Avatar
 
Join Date: 11-05-05
Location: Warren
Posts: 2,543
iTrader: (13)
Here's the formula for using excel to calculate revs per mile:

=20852*((C2/2+((A2/25.4)*B2/100))*2)^(-1.0003)

Copy and paste the above formula into cell D2. Then enter tire width into cell A2, aspect ratio into cell B2, and wheel diameter in cell C2.

In case your real dumb:

Example LT305/70/R16

305 is the tire width in millimeters
70 is the aspect ration (sidewall height is 70% of tire width)
16 is the wheel diameter in inches

Haggar, you might want to add this to your revs per mile tab.
FrankNBrew is offline   Reply With Quote
Old April 4th, 2006, 09:22 AM   #7
Haggar
Covered in mud...
 
Haggar's Avatar
 
Join Date: 11-06-05
Location: Oxford, MI
Posts: 17,381
iTrader: (52)
Quote:
Originally Posted by FrankNBrew
Here's the formula for using excel to calculate revs per mile:

=20852*((C2/2+((A2/25.4)*B2/100))*2)^(-1.0003)

Copy and paste the above formula into cell D2. Then enter tire width into cell A2, aspect ratio into cell B2, and wheel diameter in cell C2.

In case your real dumb:

Example LT305/70/R16

305 is the tire width in millimeters
70 is the aspect ration (sidewall height is 70% of tire width)
16 is the wheel diameter in inches

Haggar, you might want to add this to your revs per mile tab.
I thought about it, but its better to find the true numbers for your tire. It ends up being dependant on the tire, and the variation from true gets statistically larger as the tire diameter gets larger, and varies brand by brand, which is why I left it that way.

For example, when you look at car tires (I use this for looking at car situations, too, for cruising and racing), they are very very close to accurate, usually about 1%-2% smaller than advertised.

Then smallish truck tires like 31s or 265/75R16s have maybe 3-4% smaller.

Once you get up to big sizes, then its all out the window. A 35" SSR is a full 1.5" taller than a 35" Bogger, so you just need to figure whats best for your tire.

That, plus most people aren't running metric tires.
Haggar is offline   Reply With Quote
Old May 31st, 2006, 07:38 AM   #8
1x1_Speed_Craig
Simplify...
 
1x1_Speed_Craig's Avatar
 
Join Date: 11-09-05
Location: Grand Rapids, MI
Posts: 7,206
iTrader: (119)
Quote:
Originally Posted by Haggar
Its in Excel format.

I have created tabs with many of the common transmissions and transfer case gear ratios, and tire sizes (you need to enter tires as revs/mile)

Sure, there are online calculators. I like this because I can copy them and make a tab for each vehicle, or possible vehicle configuration.

Just type in your specifics in the white boxes and its all set.

Enjoy!


http://www.lordsofevolution.com/hagg.../gearchart.xls
Thanks. At first glance, it looks very useful. I'll look at it in more detail over my lunch hour.

Quote:
Originally Posted by FrankNBrew
Copy and paste the above formula into cell D2. Then enter tire width into cell A2, aspect ratio into cell B2, and wheel diameter in cell C2.

In case your real dumb:
Nice.
1x1_Speed_Craig is offline   Reply With Quote
Old May 31st, 2006, 07:47 AM   #9
Haggar
Covered in mud...
 
Haggar's Avatar
 
Join Date: 11-06-05
Location: Oxford, MI
Posts: 17,381
iTrader: (52)
Thanks!

Feel free to make suggestions/corrections/improvements..


I have some wierdly modified versions for cars where I put in a powerbard, and can see wheel torque output from 5 to 100 mph. More of a carr racing mod, though, and its mostly manually edited..
Haggar is offline   Reply With Quote
Old October 22nd, 2006, 02:45 PM   #10
BMFmike
meh.
 
BMFmike's Avatar
 
Join Date: 11-06-05
Location: Grand Haven
Posts: 7,816
iTrader: (6)
Thanks Jesus ..worked great.
BMFmike is offline   Reply With Quote
Old October 22nd, 2006, 06:08 PM   #11
Wehan
'cause wife's Asian.
 
Wehan's Avatar
 
Join Date: 10-07-06
Location: Charlotte, MI
Posts: 1,997
iTrader: (21)
Awsome! now I know how fast I'm going with my busted speed-o.
__________________
Wehan is online now   Reply With Quote
Reply
Great Lakes 4x4. The largest offroad forum in the Midwest > 4x4 Talk > General Tech > General Tech FAQ
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -5. The time now is 12:42 AM.


Powered by: vBulletin, Copyright 2000 - 2012, Jelsoft Enterprises Ltd.
Copyright 2005 - 2012 Cracker Enterprises - Powered by Linux
vB Ad Management by =RedTyger=
Page generated in 0.14219 seconds with 32 queries