dont use my stuff and expect any type of accuracy greater than 90%. The fidelity just isn't there and I don't want people running around using those numbers as bible. Now if something is like 50% off of what it calculates or something, then mabye something is up. If we could predict airplane performance with an excel spreadsheet i wouldnt have to school for four years to concentrate in one discipline of aerospace engineering.
as for dwarf, the other two are correct. Ps translates directly to either climb or acceleration, they are interchangable. thats why Ps vs mach number and altitude is such a valuable plot, since it shows both climb rates at any gives speed, maximum speed versus altitude, and aircraft ceiling. Its basically everything you would want to know about flight at a single level of g.
As for why the f6f climbs better, I don't know. Mabye something about the airplane? The propeller or the cowl flaps? Dunno.
Just to reiterate please don't use that excel spreadsheet as a tool and expect accurate results. The prop efficiency stuff is purely fictional, as are all of the other curves I have seen here. To say that they can be aoppplied to any ww2 airplane is kind of silly.
Plus there are all sorts of factors that this type of analysis dooesnt consider. The fact that the wings are blown by the propellers, stuff like cowl flaps opening and closing based on throttle setting, variations in lift/drag due to camber, thickness, twist, airfoil selection, and planform. The list goes on and on.
Basically I just made up that sheet for fun, and to see if HTCs numbers were in the ballpark. They are.