Z28tt Project

First step was to get the gear ratios, shift points, and the following gears starting rpm. That generates the gear drop chart below, and is good for figuring out what speeds are possible in what gears. Next was to get HP in there. I wanted to use a simple calc formula to get "area under the curve", based on my dynochart's polynomial equation, but I couldn't figure out how to make Excel do that, so I had to create a "true/false" matrix, based on whether the rpm is inside the gear's range (start and finish rpm), and only count the true cells in the average. You can overwrite the torque values in blue to get your own dyno curves in there. If you want to use a polynomial function, and just change values A-D, graph the HP as a scatter plot, finish that, and then click on "chart>add trendline" and click on "display formula on chart". You can enter those values into A through D. The worksheet is protected to prevent accidental overtypes.

Later on, I'd like to add a start and finish mph, so you can max out HP for specific straights between corners. This would let you pick rear ratios to optimize specific tracks, since we're not about to change internal gear ratios in the T56. If anyone knows an easier way of doing this, I'm all ears.