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

 

def saving this. Thanks so much!