Not sure if this post should be here, in the tech section or in the GearSplit section. Jon I could not tell if the GearSplit software is still available or not. If not maybe move this there or copy it to there as this post will soon disappear down the page.
==================================================
After our screw up with ordering the wrong gears for Hooley's Stude thinking we had a different Input Drive/Cluster Gear combination than what we really had I modified one of my old "RPM/Speed in Gear" spread sheets. If you have a transmission, such as a Gerico/G-Force/Tex where you can change the Input drive gears and the individual gears this spreadsheet will allow you to enter all of those by their tooth count. It will then show you speeds at any rpm in any gear and also the drop in rpm shifting to the next higher gear. Here is a direct link that will allow you to download the spreadsheet in Excel format....
http://purplesagetradingpost.com/sumner/bvillecar/101%20Transmission-Master.xlsI also have numerous other spreadsheets related to land speed racing that deal with air inlet area design, HP needed to run a certain speed, drag calculations, intercooler ice water tank sizing and some others.
Also more RPM/Speed in different gears for car 3,4,5, and 6 speed transmissions and motorcycles with multiple gears (4-5-6 speeds). These are explained a little better below but all of the spreadsheets can be found here....
http://purplesagetradingpost.com/sumner/bvillecar/bville-spreadsheet-index.htmlBelow are a couple of screen shots of the spread sheets from above, one for a car 4 speed transmission and one for a 5 speed motorcycle.
Above is the car 4-speed spread sheet. You enter the tire size, rear-end gear, and the ratios in each gear. To the right of that is a small table showing speeds at fixed rpm's in each gear.
The main feature of the spread sheet is explained next.
Above we are looking at one section of the spreadsheet. We can pick any rpm shift point in any gear and see the mph there and also the rpm drop between that gear and the next higher gear.
For instance if you were to shift from 1st to 2nd at about 6800 your speed there would be 105 and you would drop to 5100 in 2nd, a drop of 1744 rpm. Likewise if you made the 2-3 shift at 6800 again you would be going 140 and be turning 5300 in 3rd. Again if you made the last shift also at 6800 at 180 you would be turning 5340 in 4th. Since the above is a screen shot of the spreadsheet it doesn't show your final speeds in 4th. You would just scroll down to see them.
The Spreadsheet could be a big help in selecting gears that will work with your motor/cam so that you don't fall out of the power band on shifts.
Next is one of the motorcycle spread sheets. You can input tire diameter, primary gear ratios, ratios in each gear and also different sprockets with different tooth counts.
It will show you speeds at different rpms and rpm drops between gears for the primary sprockets you choose and final gear speeds for other sprocket combinations,
Sum