I decided the best way to do this would be to share the excel sheet I created. I don't know of any forum supported document hosting per users, so I have uploaded the file to my Google Drive. You can view and download the document at this link below. You will need to download it in order to use it. I have protected the sheet in order to prevent accidental deletion of any equations. Boxes in green are where user input is required. I should note that the RPM after the shift and the percentage after the shift is information about shifting from the previous gear. So for second gear, the RPM after the shift is the RPM in second gear after shifting from first to second.
Gear CalculatorI have a few things to share and say about this excel sheet...
1.
USE AT YOUR OWN RISK. While the math is accurate, I am not liable for any decisions you make involving my gear calculator. It's a tool to help you make decisions but it will not tell you the exact gear ratios you should use.
2. The higher the vehicle's max speed in a particular gear, the slower the car will accelerate in that gear. You'll need to factor this into your choices if you are using this calculator to help you determine a gear ratio or set of gears. What is your application, road coarse, drag strip or street?
3. The lower the vehicle's max speed in a particular gear, the faster the car will accelerate in that gear. You'll need to factor this into your choices if you are using this calculator to help you determine a gear ratio or set of gears. What is your application, road coarse, drag strip or street?
4. Having covered points 2 and 3, selecting gear ratios is a trade off between acceleration and top speed. If you didn't know this before hand, now you do. This is the reason why continuously variable transmissions are engineering wonders, theoretically you can have your cake and eat it too as long as you don't want to be able to shift the gears yourself. But where is the fun in that?
5. At higher speeds, aerodynamics will come into play and may prevent you from further accelerating. As long as the gears say you can go faster, just add more horsepower. Horsepower is how fast you hit the wall, torque is how far you take the wall with you.
Enjoy and always remember to keep the shiny side up.