jus2shy wrote:
I made a new sheet ... the cool thing is seeing how smooth the HEMI and the Ecodiesel put out power because of the 8-speed transmission. you don't get as much interruption of power and the engine can stay in its power band more easily.
Exactly. These graphs really illustrate the importance of the transmission's role in delivering power to the ground. So many people miss this critically important consideration because they insist on making comparisons at like RPMs rather than like speeds. In doing so, they essentially hold the gear constant, but in the real world, shifting gears is a crucial part of maximizing torque at the wheels.
jus2shy wrote:
Here's the spreadsheet: Spreadsheet link
Great work! But although the general story is what I'd expect, some of the data points seem incorrect. For example, the EcoDiesel is in 1st gear at 0mph and 15mph. HP is rising, which is right, but torque-at-the-wheels is dropping, which isn't. There's also strange behavior with the (theoretical) EcoBoost at 40mph, but you don't have any source data for that one. I'd suggest just removing it. Would you mind double-checking the other calculations? There's tremendous value in these graphs, and I think it'd be worthwhile to make sure they're correct.
-- Rob