Hi all,
You can go here (
http://www.savefile.com/files/181071) and download an Excel file I'm creating called Muscle Car Modeler, and of course all data pertains to my 74 Barracuda, but I welcome you to input data for yours, run the program, and see how well (or poorly) it models your car. It uses VBA and (numerous) inputs about your car to do many general calculations.
To run the program, go to the Muscle Car Modeler worksheet. Input any value in column A that is required (noted in column B). If your head isn't hurting after figuring out all the inputs, scroll to the bottom and click the Calculate button. Make sure your Excel is set up to allow VBA to run. If not, go to Tools, Macros, Security, and Low Security (which will allow VBA to run automatically).
These calculations cannot give you exact, final outputs of your car, of course, but hopefully the math is good enough to get you close. In fact, the math is available for all to inspect. To see exactly how it calculates things, go to View, Toolbars, Visual Basic. When the toolbar pops up (assuming that it isn't already), click on the button that says Visual Basic Editor when you hover over it. In the left window, double click the Muscle Car Modeler worksheet, and all VB code associated with that worksheet (the whole program) will appear in the right window.
If you aren't familar with VB code, don't worry, it should be obvious what it's doing (VB is the simplest language I've ever seen), with a couple of pointers. First, variables are declared (such as Dim Torque as Double), don't worry about this. Second, variables are entered into VBA, such as Torque = Range("A65"), meaning only that it reads the value from cell A65 of that worksheet. From there, calculations are made, and finally, variables are output back on the worksheet.
If you inspect the math, you will find many familiar calculations, and many that I have adjusted. When I have adjusted them, I have noted the changes (notes appear in green as comments).
Please let me know how well or poorly it models your car. Most importantly, if you have any suggestions or corrections, I'm very curious, and will probably put them in the code, provided it doesn't become a nightmare to program. I have continuosly added more variables and figured this was a good stopping point to see what you think. This isn't a serious project, but just for fun and curiosity.
