Competition Diesel.Com -  Bringing The BEST Together

Competition Diesel.Com - Bringing The BEST Together (http://www.competitiondiesel.com/forums/index.php)
-   Sled Pulling (http://www.competitiondiesel.com/forums/forumdisplay.php?f=15)
-   -   Gear selection chart-Microsoft Excel (http://www.competitiondiesel.com/forums/showthread.php?t=76719)

getblown5.9 01-21-2010 09:09 AM

Gear selection chart-Microsoft Excel
 
1 Attachment(s)
here is a gear selection chart I made, its kind of interactive if you want to call it that, you enter your tire size, gear ratio, and desired RPM in the box, and it will give you a chart listing the final drive ratio, and approximate wheel speed based off your input.

maybe this can be made a sticky by the mods, and the more experienced members can help by posting up what some good final drive ratios/mph is for certain HP levels. Maybe this will help to keep some of the Newbie questions to a minimum about what gear to choose.

mech2161 01-21-2010 09:37 AM

Looks good, how about adding the ZF6?

Low 5.79:1
First 3.30:1
Second 2.10:1
Third 1.31:1
Fourth 1.00:1
Overdrive 0.72:1
Reverse 5.23:1

getblown5.9 01-21-2010 09:38 AM

coming right up

getblown5.9 01-21-2010 09:43 AM

1 Attachment(s)
Here you go...

mech2161 01-21-2010 09:49 AM

Sweet! That makes it nice having them all on the same page.

j-rod 01-21-2010 10:01 AM

If the mods do want to make this a sticky, I can add my calculators for street and open driveline trucks also.

01smoker 01-21-2010 10:11 AM

Very helpful thread! Definetly needs to be a sticky. Thanks TJ

GOT-Torque 01-21-2010 10:16 AM

1 Attachment(s)
Here's the one I've been using for wheel speed, it has most of the Dodge transmissions in there.

mech2161 01-21-2010 10:57 AM

The one TJ posted will show wheel speed for any rpm you enter. If you don't have Excel you can down load Open Office, it's free.

mech2161 01-21-2010 11:01 AM

This just frustrates me even more. ZF6 with 3.73's has more wheel speed than the NV4500 with 3.54's. I got to get it to the ground.

94 12valve 01-21-2010 11:17 AM

Thanks for the help TJ

GOT-Torque 01-21-2010 11:22 AM

Quote:

Originally Posted by mech2161 (Post 986010)
The one TJ posted will show wheel speed for any rpm you enter. If you don't have Excel you can down load Open Office, it's free.

I understand, I just like to have it all in front of me instead of re-entering the rpms to tell the difference. After about the 3rd change I make, I forget what the first values were:bang My file originally had two tables for each setup so you could make one change and compare both tables but it didn't meet the file size requirement so I trimmed it down.

sledshaker 01-21-2010 12:15 PM

anyway to do that with an auto for the dodge 47re

tank21pa 01-21-2010 12:18 PM

Quote:

Originally Posted by sledshaker (Post 986094)
anyway to do that with an auto for the dodge 47re

GOT-TORQUE has the auto one if you scroll to the right

getblown5.9 01-21-2010 12:56 PM

1 Attachment(s)
added 47/48re and G56 to mine. the other one is sweet too.

just trying to help people out with the tools they can use to figure this stuff out rather than asking the same question over and over.

ComnRailPwr 01-21-2010 03:01 PM

great thread!

getblown5.9 02-22-2010 10:08 PM

bump

cummins724 02-22-2010 10:13 PM

Quote:

Originally Posted by mech2161 (Post 986018)
This just frustrates me even more. ZF6 with 3.73's has more wheel speed than the NV4500 with 3.54's. I got to get it to the ground.

You should try dropping a gear maybe? I would detune that thing & get it to hook, you'd be better off.

mech2161 02-22-2010 10:21 PM

LOL I so f'in confused I think I should just spectate.

cummins724 02-22-2010 10:25 PM

Quote:

Originally Posted by mech2161 (Post 1022862)
LOL I so f'in confused I think I should just spectate.

:hehe: You get that thing hooked, we are all in trouble.


All times are GMT -5. The time now is 09:58 AM.

Powered by vBulletin
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2006 - 2024, CompetitionDiesel.com
all information found on this site is property of www.competitiondiesel.com