Custom acceleration graph generator
 

I can't attach a .xlsm file. Here's a link to download it from my google drive. https://drive.google.com/open?id=0Bx...l84MnJYbEpEUVU

First off - I'm 90% sure these graphs are accurate, not counting drag, but want feedback. Is this shit all wrong? Idk, I was an English major.

My setup has been 4.1, 5 speed, N/A ~150whp for a while now. I recently grabbed 4.77 kia gears from local yard and swapped them in, along with poly bushing to replace my 150k mile OEM rubbers. The car is silly fun, and I can't wait to get it on track in a few weeks.

Before doing it though, I wanted a better visual of what the gear changes would do to shift points and acceleration and since the internet was failing me, I built my own road force/acceleration graph generator. Every Miata diff ratio combined with both transmissions, and simple macros to hide columns, turning different options on or off in the chart. Import your comp weight and torque numbers every 100rpm from 4000rpm to redline, and you can use it too. The main issue with this chart is it's setup for my redline, 7300. If yours is lower or higher, you need to adjust the tables a bit. (I can explain more if needed.)

Output acceleration is in g's. Converting everything to metric made life way easier. For me, the visuals are what matter. I can see my shift points and what combo is better at specific speeds. At Pocono this summer, I wasn't getting much over 125mph (gps), and the 4.77 allows me to be in torque peak pulling out of T5 at NJMP Thunderbolt and a few other key places, so 4.77 was a no brainer.

For those making a lot more power than me at different RPMs, hopefully this can help?

If anyone knows of a better way to change redline and have all the charts follow suit pretty easily, I'd really like to add that automatic functionality.

Part of the sheet with every combo turned on
Attachment 231036

Original intention, 4.1 VS 4.77, both with 5 speed
Attachment 231037

4.77 vs 4.77, 6sp, showing the clear advantage of the 6 speed past 75mph
Attachment 231038

3.636 5sp vs 4.77 6sp
Attachment 231039

Cool plots!

Are you considering running 4.77 + 6-speed like in the plot? That curve looks busy but maybe really fun.

I have one sitting in the garage, but I don't think it's worth the points in NASA TTD. Maybe someday with a different built.

How is this different than this, other than graph overlays?:
https://www.flyinmiata.com/tech/gearing.php

where do you compensate for tire size?

The FM gearing calc doesn't show acceleration plots, just top speed in each gear. My graph allows you to see the increases and decreases in torque at the wheels at any given speed.

The wheel size is in the formula at 23.1" diameter, a standard Miata size (205/50-15 and 225/45-15 both equal about this size on paper). I can easily change it so you can enter your wheel size in a cell so it adjusts the plots.

This is why I'd like someone to verify that these graphs are accurate.

I inputted 949's 143whp TTE car, with nearly flat hp from 5k to 8k. This one (found in the TTE thread).
Attachment 231032

Here's the torque graph. Red line is running each gear out to redline. Blue line is shifting at 7400 each time. The torque drops so precipitously, that from 3rd gear on, there is a small advantage to the short shift.
Attachment 231033

I had a dyno of my car when we ran in uncorrected once, making nearly the same peak hp as Emilio's, 141 peak. Here's that dyno.
Attachment 231034

And here's the overlay. You can see the huge advantage of the torque monster 949 car in 1st 2nd and 3rd gears. Interestingly, the advantage wanes to the point that its nearly gone in 5th gear. Granted, the extra chug the 949 motor has at the beginning of 3rd and 4th could be a huge deal pulling out of turns, or even dragging it out, if that scenario were to arise.
Attachment 231035