snips..

Hi Paul,

I took your current formula and updated the spreadsheet.  I've also
rearranged it and separated all of intermediate calculations.

I ran into a problem when I got to the induced drag calculation.  I get
a value of .0045.  If I do an estimate based on your formula, I get:

AspectRat = 3 / AvgCord
            =3 / .34  is approximately 9
(My Avg Cord agrees with yours)

Now,
InducedDrag = (CsubL ^ 2 / (3.1416 * AspectRat)) / 2
              = (.5 * .5 / (3 * 9)) / 2
              = (.25 / 27) / 2  is approximately .005

Yet your program calculated 4.24, and I cannot see what I'm doing
differently.  Once that is fixed, the total torque and HP will agree.

Outside of that, this version should be easier to update and modify.

Bob W.

Hi Paul,

I modified the formula to pick up the coefficients from the columns
instead of using the constants.  Deleted the induced drag formula for
now, and added Mach columns.  I wasn't sure if you need tangential
velocity or cord velocity, so I added both.  Delete the column that
isn't needed.  Mach is calculated at sea level so would need to be
adjusted for altitude.  I added SpdSnd so that it will be easy to
adjust.

Bob W.