jus2shy wrote:
All I was doing was showing that the two different engine types have a different delivery of horsepower
Yes, of course. And FWIW, I think your last post was most excellent, and I agree with most all of it.
jus2shy wrote:
In the case of Ford Superduties, the Diesel and Gas engines use the same exact transmission....
Although true, this does not mean those transmissions need to be operating in the same gear at any given road speed in side-by-side trucks.
jus2shy wrote:
So you get different behaviors out of these two trucks.
Yes! Unfortunately, your spreadsheet doesn't capture that.
jus2shy wrote:
As to the spreadsheet, it's easy to add another modifier line to it and chart out available power for given tire size, axle and transmission gear ratios. In the end, the transmission and differential are going to be multiplying the output from those base horsepower charts on the spreadsheet.
Yes, but the multipliers being applied at any given time won't be the same, and that's what's missing. Dynamically on the road, it would go something like this:
10 mph - Both trucks in 1st gear, diesel clearly producing more power.
20 mph - Diesel upshifts to 2nd, loses power, loses torque advantage of 1st gear. Gasser increasing power, maintains torque advantage of 1st gear.
30 mph - Gasser upshifts to 2nd.
40 mph - Diesel upshifts to 3rd.
60 mph - Diesel upshifts to 4th.
70 mph - Gasser upshifts to 3rd.
Now I don't know the exact speeds where those shifts would occur, but in this example, at 60mph the gasser will be in 2nd gear while the diesel is in 4th. They will
not be spinning the same RPMs, so comparing them at the same RPM is meaningless.
If we could amend the spreadsheet to have columns for road speed, then populate that column with the maximum power available at each road speed, we'd get a much more useful comparison. Then we could draw a graph and very easily see which
vehicle, not
engine, provides more power across the entire speed range. But to get this we'd have to know all the other variables you mentioned, and we'd have to calculate which gear provides the most power for each vehicle at each road speed (they won't be the same). Any comparison that fails to account for that gear difference is of very limited real-world value. Unfortunately, those are the only comparisons we ever see.
-- Rob