Transmissions and Drivetrain Need help with your trans? Problems with your axle?

Easy MPH in gear at RPM calculator google sheet.

Thread Tools
 
Search this Thread
 
Old 12-03-2019, 10:57 AM
  #1  
Supreme Member

Thread Starter
iTrader: (5)
 
Thirdgen89GTA's Avatar
 
Join Date: Sep 2004
Location: Chicagoland Suburbs
Posts: 5,847
Received 213 Likes on 160 Posts
Car: 1989 Trans Am GTA
Engine: LT1, AFR 195cc, 231/239 LE cam.
Transmission: M28 T56
Axle/Gears: 3.23 10bolt waiting to explode.
Easy MPH in gear at RPM calculator google sheet.

I was bored last night and put this together for myself as I wanted a lookup table for my GTA for the MPH in any gear, at any RPM. Then like I do when I get bored, I add some things to make it more useful.

What I ended up with is a simple Google sheet that has drop down selectable menus for various Transmissions found in F-bodies with their common gear ratios, a drop down for Axle ratios, and a place to put your tire information.

When all of it is combined, you can select a transmission, axle, and it will calculate the MPH of any gear in 100rpm increments.

I tried to add all of the known common F-body transmissions that come OEM equipped, or commonly swap in aftermarket. Its easy to add new transmission sets.

I've set it as Shared and viewable by anyone, but if you want to make changes (aka, use the drop down menus) you'll need to either make a copy of the Google sheet in your own google drive, or download it in Excel or another format.

Either way, I made it for myself, but figured I'd share it with everyone else too. Currently its set to the combo specific to my car, but you can easily change it to a factory thirdgen with a 700r4 and 3.27's...etc.

https://docs.google.com/spreadsheets...it?usp=sharing
Old 12-03-2019, 07:54 PM
  #2  
Supreme Member

iTrader: (5)
 
punkmaster98's Avatar
 
Join Date: Aug 2011
Location: Jackson NJ
Posts: 1,180
Received 159 Likes on 103 Posts
Car: 1984 T/A
Engine: LQ4
Transmission: T56
Axle/Gears: Ford 8.8 4.10 gears
Re: Easy MPH in gear at RPM calculator google sheet.

def saving this. Thanks so much!
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Ronny
DIY PROM
6
07-23-2021 05:18 PM
Al Byno
Transmissions and Drivetrain
1
12-10-2007 05:14 AM
bigchief
Transmissions and Drivetrain
16
06-29-2007 07:57 AM
Praetorian27
Transmissions and Drivetrain
15
03-12-2007 08:11 AM
JBANKO
Transmissions and Drivetrain
3
10-25-2001 08:49 PM



Quick Reply: Easy MPH in gear at RPM calculator google sheet.



All times are GMT -5. The time now is 01:40 AM.