.................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 feel the informaion on this site is worth a buck....................... |
|
|
If you are interested in Bonneville Pictures....................................... |
|
|
If you have a Land Speed Car, Hot Rod, etc., that you have construction pictures of ....................................................................... |
.................................-- LSR Spreadsheet Index --
NOTE: If you can't input data into the spreadsheet you download then save it and re-open it to use it.
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 ).
Intercooler Ice Needed Calculator -- Use this to get some idea of the amount of ice needed for an intercooler. This is untested and assumes 100% effeciency.
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 ...................
HP needed for A Lakester or Car to Run a Certain MPH -- Need to know how much HP you need to run a certain speed this spreadsheet uses the formula from the spreadsheet above this one to figure total HP needed based on one frontal area/Cd for the body and another frontal area/Cd for the tires/wheels. For a car or streamliner don't fill in the tire inputs.
Horsepower Needed -- Figure HP to run a new speed based on a known speed and HP or a new speed based on a new HP level.
Pressure Conversions -- If you need to convert between Kilopascals, mm HG and inches of HG then this spreadsheet might help.
NOTE: If you can't input data into the spreadsheet you download then save it and re-open it to use it.
Speed at any RPM in any Gear for Different Car/Motorcycle Transmissions with RPM drop on Shifts -- 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
RPM in gears for G-Force/Tex 101 type Transmission or any transmission where you can change the Input Drive/Cluster gears or gears 1-3
NOTE: If you can't input data into the spreadsheet you download then save it and re-open it to use it.
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
RPM in gears for 4 - 5 - 6 Speed MC Transmission with added Jackshaft
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.
NOTE: If you can't input data into the spreadsheet you download then save it and re-open it to use it.
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 - Excel Spreadsheet Format Version: 11-28-13
Intercooler Ice Needed Calculator -- This might help you figure out how much ice you will need to cool a water to air intercooler.
NOTE: Be very careful using this calculator as it is untested in the real world and assumes 100% effeciency which isn't going to happen. It also asumes that you have the intercooler sized correctly.
I would like anyone who has real world experienc using ice and knows their HP and run times and such tell me how close this calculator is to what they have experienced on the salt.
(To use the spreadsheet load it from the following link and then resave it and retreive that to get it out of the "read-only" mode.)
( Intercooler Ice Needed Calculator- Excel Spreadsheet Format ) Version: 01-30-13
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
NOTE: If you can't input data into the spreadsheet you download then save it and re-open it to use it.
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
NOTE: If you can't input data into the spreadsheet you download then save it and re-open it to use it.
Horse Power Needed For A Lakester or a Car to Run a Certain MPH -- Need to know how much HP you need to run a certain speed? This spreadsheet uses the formula from the spreadsheet above this one to figure total HP needed based on the frontal area/Cd for the body independent of the tires used and another frontal area/Cd for the tires/wheels. It combines the HP needed to drive both to the given speed.
I've found Cd's for tires that have the width/diameter ratio similar to Goodyear Land Speed tires with Cd's of between .18 to .58. So take your pick. I'd use numbers between .45 and .60 myself as that way you will be erring on the conservative side.
The Spreadsheet will also give you figures for the weight needed on the drive wheels for different salt conditions in order to get the HP/Thrust to the ground since you don't have the same traction as pavement.
"One point-- the "weight" required on the rear wheels doesn't have to be just ballast weight, rather it is the total of the weight plus the aerodynamic downforce. This can be really significant at high speed." Regards, Neil
NOTE: For a car or streamliner don't fill in the tire inputs.
( HP Needed For A Lakester- Excel Spreadsheet Format ) Version: 10-13-13
NOTE: If you can't input data into the spreadsheet you download then save it and re-open it to use it.
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 or if you know what your new HP will be it will give you the speed for that HP based on known HP for a certain speed.
( HP Needed - Excel Spreadsheet Format ) Version: 02-20-13
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 - Excel Spreadsheet Format ) Version: 11-28-13
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 - Excel Spreadsheet Format Version: 01-16-14
RPM in gears for G-Force/Tex 101 type Transmission or any transmission where you can change the Input Drive/Cluster gears or gears 1-3 Version: 01-16-14
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 - Excel Spreadsheet Format Version: 05-10-14
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 - Excel Spreadsheet Format Version: 11-28-13
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
4 -- 5 -- 6 Speed Motorcycle with a Jackshaft --RPM in gears for 4-5-6 Speed Motorcycle Transmission -- This is for motorcycles and lets you put in the front and rear sprocket teeth counts and you are running a separate jackshaft such as might be used in a streamliner.
( RPM's for 6 Speed - Works Spreadsheet Format ) Version: 09-27-06
Below are a couple of screen shots of the spreadsheets from above.
Above is the car 4-speed spreadsheet. 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 spreadsheet 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.
This 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.
.....Return To Mine & Other Bonneville Car Construction Pages
