.................Return To Mine & Other Bonneville Car Construction Pages
................................-- Land Speed Racing Spreadsheets --
..................................................-- That Might Help You --
......................................(Check Back for New Ones)
My math skills are not real strong, so if anyone finds errors in these spreadsheets please contact me. Also the formulas I have used have come from different sources and I would not take these spreadsheets as gospel, so please verify the results in a manner that will make you feel comfortable.
Thanks, Sum
......................--- Asking For Your Support ---
If you are interested in helping to keep this site on the Internet......(CLICK HERE) If you feel the informaion on this site is worth a buck....................... (CLICK HERE) If you are interested in Bonneville Pictures....................................... (CLICK HERE) If you have a Land Speed Car, Hot Rod, etc., that you have construction pictures of ....................................................................... (CLICK HERE) .................................-- LSR Spreadsheet Index --
General Spreadsheets:
Air Inlet ("scoop") Size Calculator -- This will help you to figure your air inlet size, but first I would read what is on this page ( HERE ).
Average HP/Torque -- Input HP and Torque at different RPM's for up to two motors for comparisons and averages over different RPM ranges.
Drag Force-HP-Thrust-Weight -- This spreadsheet will figure the Drag Force on a vehicle, the HP needed to ...................
Horsepower Needed -- Figure HP to run a new speed based on another speed.
Pressure Conversions -- If you need to convert between Kilopascals, mm HG and inches of HG then this spreadsheet might help.
Car Transmission Gear/RPM -- Input tire size, transmission gear ratios and the rear gear and you will see the rpm at different speeds in each gear and the rpm drop on shifts.RPM in gears for 3 Speed Car Transmission
RPM in gears for 4 Speed Car Transmission
RPM in gears for 5 Speed Car Transmission
RPM in gears for 6 Speed Car Transmission
Motorcycle Transmission Gear/RPM -- Input tire size, primary gear ration, transmission gear ratios and sprocket sizes and you will see the rpm at different speeds in each gear and the rpm drop on shifts.RPM in gears for 4 Speed Motorcycle Transmission
RPM in gears for 5 Speed Motorcycle Transmission
RPM in gears for 6 Speed Motorcycle Transmission
Note: You should check the version date on the files you have downloaded and make sure they are current as I will make changes as needed.
Air Inlet ("scoop") Size Calculator -- This will help you to figure your air inlet size, but first I would read what is on this page ( HERE ).( Air Inlet Size - Works Spreadsheet Format ) Version: 01-29-07
( Air Inlet Size - Excel Spreadsheet Format ) Version: 01-29-07
Average HP/Torque -- This spreadsheet will allow you to input HP and Torque at different RPM's for up to two motors and will compare the two motors against each other and will also give you average HP/Torque over different rpm ranges.( Average HP/Torque - Works Spreadsheet Format ) Version: 09-27-06
( Average HP/Torque - Excel Spreadsheet Format ) Version: 09-27-06
Drag Force --HP to run a Speed -- Thrust -- Weight Needed on Drive Wheels -- This spreadsheet will figure the Drag Force on a vehicle, the HP needed to run a certain speed for that vehicle, the thrust and the weight needed on the drive wheels for a given thrust and speed.( Drag Force-HP-Thrust-Weight - Works Spreadsheet Format ) Version: 09-28-06
( Drag Force-HP-Thrust-Weight - Excel Spreadsheet Format ) Version: 09-28-06
Horse Power Needed -- This spreadsheet uses the formula that it takes 8 times the HP to go twice as fast. If you know (or guess) the HP needed to go a certain speed you can plug in a new speed and it will tell you how much HP is needed to go that speed.( HP Needed - Works Spreadsheet Format ) Version: 09-28-06
( HP Needed - Excel Spreadsheet Format ) Version: 09-28-06
Pressure Conversions -- If you need to convert between Kilopascals, mm HG and inches of HG then this spreadsheet might help.( Pressure Conversions - Works Spreadsheet Format ) Version: 09-28-06
( Pressure conversions - Excel Spreadsheet Format ) Version: 09-28-06
Three Speed Car --RPM in gears for 3 Speed Car Transmission -- This spreadsheet lets you input the gear ratios for a 3 speed transmission along with the rear gear and tire size. It then tells you the rpm in each gear along with the rpm drop on gear changes.Note: We use what is suppose to be a 28 inch tire on Hooley's Stude. To get the rpms to match the speed on the course (5 mile exit speed) I had to increase the tire dia. to 28.3. This then made the spreadsheet correct. So 28.3 might be what our tires grew to or our tach is off, or who knows, but the numbers on the spread sheet where within a percent or two.
( RPM's for 3 Speed - Works Spreadsheet Format ) Version: 01-01-07
( RPM's for 3 Speed - Excel Spreadsheet Format ) Version: 01-01-07
( Note: For some reason I can't freeze the titles when I save these in Excel Format )
Four Speed Car --RPM in gears for 4 Speed Car Transmission -- This spreadsheet lets you input the gear ratios for a 4 speed transmission along with the rear gear and tire size. It then tells you the rpm in each gear along with the rpm drop on gear changes. Note: 4th can be either 1:1 or overdriven (such as a .90 overdrive).( RPM's for 4 Speed - Works Spreadsheet Format ) Version: 01-01-07
( RPM's for 4 Speed - Excel Spreadsheet Format ) Version: 01-01-07
( Note: For some reason I can't freeze the titles when I save these in Excel Format )
Five Speed Car --RPM in gears for 5 Speed Car Transmission -- You can use this for a 5 speed car type transmission with a rear gear. Note: 4th or 5th can be either 1:1 or overdriven (such as a .90 overdrive).( RPM's for 5 Speed - Works Spreadsheet Format ) Version: 01-01-07
( RPM's for 5 Speed - Excel Spreadsheet Format ) Version: 01-01-07
( Note: For some reason I can't freeze the titles when I save these in Excel Format )
Six Speed Car --RPM in gears for 6 Speed Car Transmission -- You can use this for a 6 speed car type Transmission with a rear gear. Note: 4th, 5th or 6th can be either 1:1 or overdriven (such as a .90 overdrive).( RPM's for 6 Speed - Works Spreadsheet Format ) Version: 09-27-06
( RPM's for 6 Speed - Excel Spreadsheet Format ) Version: 09-27-06
( Note: For some reason I can't freeze the titles when I save these in Excel Format )
Four Speed Motorcycle --RPM in gears for 4 Speed Motorcycle Transmission -- This is for motorcycles and lets you put in the front and rear sprocket teeth counts.( RPM's for 4 Speed - Works Spreadsheet Format ) Version: 09-27-06
( RPM's for 4 Speed - Excel Spreadsheet Format ) Version: 09-27-06
Five Speed Motorcycle --RPM in gears for 5 Speed Motorcycle Transmission -- This is for motorcycles and lets you put in the front and rear sprocket teeth counts.( RPM's for 5 Speed - Works Spreadsheet Format ) Version: 09-27-06
( RPM's for 5 Speed - Excel Spreadsheet Format ) Version: 09-27-06
Six Speed Motorcycle --RPM in gears for 6 Speed Motorcycle Transmission -- This is for motorcycles and lets you put in the front and rear sprocket teeth counts.( RPM's for 6 Speed - Works Spreadsheet Format ) Version: 09-27-06
( RPM's for 6 Speed - Excel Spreadsheet Format ) Version: 09-27-06
.....Return To Mine & Other Bonneville Car Construction Pages