Gearing your transmission right: a worksheet

Hey folks,

I did quite a bit of homework for what transmission to buy for my SLC build. It wasn't so much the "where's the best deal" homework, but rather an exercise in what are the right gear ratios in a transmission to match with the engine I'm planning to run. I put all the various transmissions I could consider into an Excel spreadsheet to compare them against each other on shift points, gear speed ranges, entering RPM on next gear up if shift at redline, top end speed and highway cruising RPMs.

It was pretty enlightening to me and I learned quite a bit about transmission gearing, so I thought I'd share what I put together if it's useful to anyone. I'd also be happy to add more transmissions if you send me the gearing list. So far it's a bunch of Porsche transmissions and the Ricardo just to get a comparison of what a V8 transmission is geared like (I wasn't considering it). I'm planning to run a late-model naturally aspirated Porsche engine that should redline around 7500 and have a power band from about 4000 upwards.

Here are the things you can enter at the top of the sheet for your specific application:
1) Motor RPM (redline)
2) Tire and wheel size (uses SLC stock 325 / 30 / 19 rear)
3) Desired highway cruising (default 75)

In the end I went with a G96/96 partially because I was able to get a good one, but also because it's geared the way it is for a reason: it's mated to a high-revving naturally aspirated engine, not a turbo or a V8.

Anyway, without further ado, grab the Excel sheet from here: http://www.timtt.com/slc/Transmission%20calculations.xlsx

Comments, additions or any other suggested items I could calculate with this data is highly appreciated.

Thanks,

Tim
 
Here's your choices for Riccardo gearing unless you step up and pay stupid dollars to change it: *crickets*

:idea:
 

Ian Anderson

Lifetime Supporter
Tim

Many thanks for your calculator, however perhaps you could check a few formulae. (Sorry as an accountant I eat Excel on a daily basis)

Rows 42 to 50 are picking up cell B35 so everything is being calculated on a 3.44 diff (You appear to have bsoluted a formula and copied it instead of only absoluting the row number and leave the column letter as variable)

the same thing is happening in the Wheel Revs area rows 66 to 71 from column C to Column L

Cheers
Ian
 
Excellent catch - thank you! I just fixed it and upload the new version.

Tim

Many thanks for your calculator, however perhaps you could check a few formulae. (Sorry as an accountant I eat Excel on a daily basis)

Rows 42 to 50 are picking up cell B35 so everything is being calculated on a 3.44 diff (You appear to have bsoluted a formula and copied it instead of only absoluting the row number and leave the column letter as variable)

the same thing is happening in the Wheel Revs area rows 66 to 71 from column C to Column L

Cheers
Ian
 
Very good, if you want to add (on variant of) the Audi 01E:

01E DQS Manufactured 04/01-01/02
01E ELQ Manufactured 04/01-01/02
01E FRF Manufactured 01/02-

Gearbox ratios (DQS/ELQ/FRF all the same)
Final 31:8 = 3.875
1st: 28:8 = 3.5
2nd: 34:18 = 1.889
3rd: 32:26 = 1.231
4th: 27:31 = 0.871
5th: 26:39 = 0.667
6th: 23:41 = 0.561
Rev: 38:11 = 3.455
 
Added. Thanks.

Keep 'em coming...

Very good, if you want to add (on variant of) the Audi 01E:

01E DQS Manufactured 04/01-01/02
01E ELQ Manufactured 04/01-01/02
01E FRF Manufactured 01/02-

Gearbox ratios (DQS/ELQ/FRF all the same)
Final 31:8 = 3.875
1st: 28:8 = 3.5
2nd: 34:18 = 1.889
3rd: 32:26 = 1.231
4th: 27:31 = 0.871
5th: 26:39 = 0.667
6th: 23:41 = 0.561
Rev: 38:11 = 3.455
 
G50/20 G50/21
1995-98 911/993 Carrera 2
Borg Warner
G50/21 has LSD

1st: 3.82
2nd: 2.05 (2.15 G50/21)
3Rd: 1.41 (1.56 G50/21)
4th: 1.12 (1.24 G50/21)
5th: 0.93 (1.02 G50/21)
6th: 0.78 (0.82 G50/21)

Final Drive 3.44/7.5"




 
Also added - thanks!

G50/20 G50/21
1995-98 911/993 Carrera 2
Borg Warner
G50/21 has LSD

1st: 3.82
2nd: 2.05 (2.15 G50/21)
3Rd: 1.41 (1.56 G50/21)
4th: 1.12 (1.24 G50/21)
5th: 0.93 (1.02 G50/21)
6th: 0.78 (0.82 G50/21)

Final Drive 3.44/7.5"




 

Terry Oxandale

Skinny Man
Tim, Great work! I massaged the spreadsheet a little to come up with the following for us 930 users:

930 gearing using 6500 RPM shift point, 315/35R17:

Gear ratios:
1st -- 2.25
2nd -- 1.3
3rd -- 0.89
4th -- 0.63

R & P 4.22 & 4.63 (the OEM is 4.22)

Speed (MPH) in each gear at the above respective R&P gearing:

52.3 & 47.7
90.5 & 82.5
132.2 & 120.5
186.8 & 170.3

Cruise RPM at 75 MPH

2609.8 & 2863.4
 
Last edited:
Back
Top