** Mitco's Acceleration and Gearing Spreadsheet

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.

__________________
2007 Chevy Duramax - EFILive Tuned By Me
2010 40th W/ Nav - Boosted Performance - UpRev Tuned By Me
The Mrs. Ride -2012 335XI N55 BMW - Cobb Tuned By Me, Built by her
My Build --> http://www.the370z.com/members-370z-...39s-build.html

Mitco39

Also here are some charts showing how changing the Final Drive can affect your gearing.

Here are the Auto Charts






And the Standards






These can all be found in that spreadsheet

__________________
2007 Chevy Duramax - EFILive Tuned By Me
2010 40th W/ Nav - Boosted Performance - UpRev Tuned By Me
The Mrs. Ride -2012 335XI N55 BMW - Cobb Tuned By Me, Built by her
My Build --> http://www.the370z.com/members-370z-...39s-build.html

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.

__________________
Current Mods: Vorpal Weapon +5.

kenchan

cool stuff, mitco.

Mitco39

hmmm, hard part about trying to go through it now is I forget what I did, since it was 7 or so months ago, ill try and go through it when I have time and see what's wrong. But you're right something is wrong there.

__________________
2007 Chevy Duramax - EFILive Tuned By Me
2010 40th W/ Nav - Boosted Performance - UpRev Tuned By Me
The Mrs. Ride -2012 335XI N55 BMW - Cobb Tuned By Me, Built by her
My Build --> http://www.the370z.com/members-370z-...39s-build.html