MS Excel Gear Ratio Spreadsheet
Thread Starter
Drifting
Joined: Nov 2005
Posts: 1,745
Likes: 35
From: Turlock CA
MS Excel Gear Ratio Spreadsheet
I am posting the spreadsheet I use to calculate speeds in gears. You will need the Microsoft Excel program to use this chart.
You can change tire size, rear end ratio, individual gear ratio, and rpm limits. There are individual sheets for each transmission on the new C6. It's still a work in progress so feedback is appreciated and time allowing updates will get made.
You can also find Java based calulators online to perform the same calulations -- but they're not as pretty.
The spreadsheet is here.
--Dan
You can change tire size, rear end ratio, individual gear ratio, and rpm limits. There are individual sheets for each transmission on the new C6. It's still a work in progress so feedback is appreciated and time allowing updates will get made.
You can also find Java based calulators online to perform the same calulations -- but they're not as pretty.
The spreadsheet is here.
--Dan
Race Director
Joined: Sep 1999
Posts: 12,437
Likes: 919
From: CONCORD NC
Le Mans Master
Joined: Feb 2006
Posts: 5,762
Likes: 4
From: Chandler Arizona
I did a similar spreadsheet and I got the same numbers that you did for the A6. However, I forgot about the converter slippage for the automatic. I don't know a good number, but when you are at full throttle, the converter won't lock up. So you'll probably need to multiply the top speed in each gear by .90 (I found 10% slippage at one of the websites, but I don't know if this is a good number or not?)
Thanks,
Glenn
Thanks,
Glenn
Race Director
Joined: Sep 1999
Posts: 12,437
Likes: 919
From: CONCORD NC
I would be nice to have a "log" from someone with an auto, and then you could easily slow slippage in each gear. It likely varies by load and rpm in each gear, but should be relatively constant.
Safety Car
Joined: Jun 2004
Posts: 4,921
Likes: 1
From: Minburn Ia
Originally Posted by davidfarmer
This is the one to save to Favorites .....
Easy to use and has many of vette settings already calculated & ready for printouts.
Burning Brakes
Joined: May 2004
Posts: 996
Likes: 13
From: Dallas TX
Originally Posted by glennhl
I did a similar spreadsheet and I got the same numbers that you did for the A6. However, I forgot about the converter slippage for the automatic. I don't know a good number, but when you are at full throttle, the converter won't lock up. So you'll probably need to multiply the top speed in each gear by .90 (I found 10% slippage at one of the websites, but I don't know if this is a good number or not?)
Thanks,
Glenn
Thanks,
Glenn
Burning Brakes
Joined: May 2004
Posts: 996
Likes: 13
From: Dallas TX
Originally Posted by dbratten
I am posting the spreadsheet I use to calculate speeds in gears. You will need the Microsoft Excel program to use this chart.
You can change tire size, rear end ratio, individual gear ratio, and rpm limits. There are individual sheets for each transmission on the new C6. It's still a work in progress so feedback is appreciated and time allowing updates will get made.
You can also find Java based calulators online to perform the same calulations -- but they're not as pretty.
The spreadsheet is here.
--Dan
You can change tire size, rear end ratio, individual gear ratio, and rpm limits. There are individual sheets for each transmission on the new C6. It's still a work in progress so feedback is appreciated and time allowing updates will get made.
You can also find Java based calulators online to perform the same calulations -- but they're not as pretty.
The spreadsheet is here.
--Dan
Corvette Stories
The Best of Corvette for Corvette Enthusiasts
How Much Horsepower Every Corvette Engine "LOST" in 1972
Joe Kucinski
Top 10 DOs and DON'Ts for Protecting Your Convertible Top!
Michael S. Palmer
Top 10 Most Explosive Corvettes Ever Made: Power-to-Weight Ratio Ranked!
Joe Kucinski
150 hp to 1,250 hp: Every Corvette Generation Compared by the Specs That Matter
Joe Kucinski
8 Coolest Corvette Pace Cars (and Replicas) of All Time
Verdad Gallardo
Top 10 Corvette Engines RANKED by Peak Torque (70+ Years of Muscle!)
Joe Kucinski
Corvette ZR1X Will Be Pacing the Indy 500, And Could Probably Race, Too!
Verdad Gallardo
Top 10 Corvettes Coming to Mecum Indy 2026!
Brett Foote
Top 10 C9 Corvette MUST-HAVES to Fix These C8 Generation Flaws!
Michael S. PalmerGuest
Posts: n/a
Here is another one that has metric / inch tire conversion, speedo, crawl, etc.. http://www.4lo.com/4LoCalc.htm
