So I've been trying to teach myself a few complex subjects (Physics, Fluid Dynamics, Thermodynamics), and I'm looking for some feedback on some initial spreadsheets I've been working on. The overall layout isn't going to be nice, as I just threw them together to get the numbers I was looking for. Later versions will be a bit more clean, or I may end up making a program in C if I get the time.
Mainly I'm looking to see if anyone can take a look and verify that my calculations are correct; if I'm missing any variables; if there are more accurate formulas to use.
First up is a spreadsheet I have on my tablet right now, "Acceleration and Power". I will post my Air Density and Fueling" when I get a chance to get back to my home computer.
Notes:
- Final wheel radius is based on an unloaded tire
- Gross vehicle mass is based on curb weight plus any additional weight in the vehicle
- I think the acceleration and power values, calculated in the section that I pasted a WOT log into, should only be accurate for the gear the log was created using (3rd gear for the log here).
- Torque (lb-ft) values, in the section that I pasted a WOT log into, are only converted from the Torque (nm) values in the same row of the current gear. In a later version, I will be using all the imperial values to correctly calculate these values.
Please post your questions, feedback, and/or corrections here instead of messages. This not only will help me, but it will help anyone that wishes to learn.
(Can't seem to post the file from my laptop correctly right now, hope this link works)
https://docs.google.com/file/d/0B-xI0Z5veB9ESXlqTWQ3eXJmeEU/edit?usp=docslist_api