well, i already have sheets for figuring vehicle speed versus engine speed, and also for modifying those results for different combinations of gears. i'm thinking about making another excel sheet to take a dyno graph and plot the shifts/engine speeds and then integrate to find an average WHP figure over a given gear or such. basically it would be able to tell you with given inputs being this dyno sheet, and these gear ratios and this shift RPM, here is how much average WHP you'll be making from zero mph to any given mph. from there i guess i could make another that would calculate the perfect RPM to shift in each gear, as many engine/gear combos would probably benefit from shifting slightly lower than redline, especially with stock cams.

so, anybody think this would be cool? i'll do it in a little bit and see what kind of interesting information this computer can crank out.

 

okay after a little fiddling around and comparing a few dyno sheets, i'm finding that my LS w/ cams and almost no tuning, stock gears but with 4.40 FD works out to almost exactly the same average WHP in each gear as a stock GSR. this isn't totally accurate, since 1) i'm using a very crude integral, and 2) i'm actually dividing the integral by the delta-X.

what i should be doing is compiling an integral for each car shifting through gears at its own respective redline and find out which one has a larger integral from, say, 0-100mph. or break it up into 20mph segments. so instead of getting results like i am now where in each gear, each car may have similar WHP outputs, but going with an overall integral with X-axis being vehicle speed would be much more indicative of which car will actually go faster. given equal launches, equal chassis and equal shift times this should more or less say the one with the bigger integral at 40mph will be ahead at 40mph. the integral would be in WHP*mph.

somebody check me on this and make sure i'm doing this right please.