** Mitco's Acceleration and Gearing Spreadsheet

Originally Posted by Mitco39

Hi Guys,

Over the past few hours I threw together a excel spreadsheet that predicts the cars acceleration while taking in wind resistance as well as HP. On the data tab of the spreadsheet you can modify all the values and it will calculate the acceleration times.

Any Data highlighted in yellow you can change and it will change all the charts and data. With the exception of wheel size for the 0-60 times, you can however change the wheel size and manual calculate these values.

You can modify any gear ratio as well as your final drive ratio to see how it affects acceleration and top speed of the car. To find the top speed of the car you just have to look through the Speed Calcs tab which I highlighted in blue to see when the acceleration times reach 0. You will notice that this sometimes is not in the highest gear (stock gear on a AT your top speed in 6th is around 170mph and in 7th the car can only push 164mph).

I have also included an acceleration chart that will help show how acceleration changes from gear change to gear change. You will also see a Gforce chart, its not as smooth as I would like but you can clearly see the shifts and but changing any data (highlighted in yellow) you can see how it affects a full acceleration at any time after starting at 0.

http://dl.dropbox.com/u/98680144/370...alculator.xlsx

Anyways let me know what you think and if you see any mistakes or would like to see more info added.

Originally Posted by GSS138

Nice spreadsheet mitco ty. One little bug in it- when you drop car weight the 0-45 time actually increases. I think it makes it up in the next part, but there is a little bug there.