Weight and Balance Formula, Can one calculate the envelope

Roger Long wrote:

There is a note telling
members to check the graph by hand if they are doing something like flying
with lead or gold bars stacked around the rudder pedals.

Our club has spreadsheets for our aircraft that actually create the graphic.
Since I didn't write them, I don't feel comfortable posting them. But it
doesn't appear too complex a task to achieve this. A set of fixed cell
pairs define the fixed shape of the "envelope", and then a final cell pair
- computed, of course - defines the point (hopefully) within the envelope.
A line graphic is drawn from these cell pairs.

- Andrew

Way too cool! I've got to figure out how to do that.

If you see the right person, please ask if I could see their spreadsheet.

--

Roger Long



"Andrew Gideon" wrote in message
gonline.com...
Roger Long wrote:

There is a note telling
members to check the graph by hand if they are doing something like
flying
with lead or gold bars stacked around the rudder pedals.

Our club has spreadsheets for our aircraft that actually create the
graphic.
Since I didn't write them, I don't feel comfortable posting them. But it
doesn't appear too complex a task to achieve this. A set of fixed cell
pairs define the fixed shape of the "envelope", and then a final cell pair
- computed, of course - defines the point (hopefully) within the envelope.
A line graphic is drawn from these cell pairs.

- Andrew

"Roger Long" wrote in message
...
Way too cool! I've got to figure out how to do that.

If you see the right person, please ask if I could see their spreadsheet.

It's not terribly difficult.

I've copied the weight & balance spreadsheet I use for my airplane he
http://www.nwlink.com/~peted/Weight%20and%20Balance.xls

It is for a specific aircraft (Lake Renegade), and would have to be
significantly modified for a different make/model. If used with the same
make/model, pretty much all that would need to be changed is the empty
weight, of course.

The spreadsheet includes a chart that plots the CG for the entered load, and
shows the envelope for both takeoff and landing W&B limits. Passenger and
baggage loads are entered in pounds, fuel loads are entered in gallons.

It should be simple enough to look at the spreadsheet to learn the basic
techniques for putting it together. Then you can apply those techniques for
the make/model you're interested in.

Pete