Weight and Balance Formula, Can one calculate the envelope

Hello, I put together a quick Excel spreadsheet that calculates total
weight and total moment for a Cessna 172. However, to check the CG, I
still have to take these calculated values and place them onto the
diagram called "Center of Gravity Moment Envelope". Does anyone know
if this lookup can be performed via a calculation? Knowing this
would be very helpful.
Thank you.

See ours he

http://www.baldeagleflyingclub.org/m...ghtBalance.xls

This sheet checks the max gross and aft CG limits. With some
experimentation, I determined that there is no way to get our individual
plane into the area where the max gross drops off. The math to do this is
fairly straightforward but I just didn't bother. 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.

Feel free to modify or adapt this for your own use with no liability or
responsibility by me or our club for the results.

--

Roger Long



"Joe Wasik" wrote in message
om...
Hello, I put together a quick Excel spreadsheet that calculates total
weight and total moment for a Cessna 172. However, to check the CG, I
still have to take these calculated values and place them onto the
diagram called "Center of Gravity Moment Envelope". Does anyone know
if this lookup can be performed via a calculation? Knowing this
would be very helpful.
Thank you.

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

However, to check the CG, I
still have to take these calculated values and place them onto the
diagram called "Center of Gravity Moment Envelope". Does anyone know
if this lookup can be performed via a calculation?


You can describe the envelope as a series of lines; your point will be on one
side or the other of each of those lines. So, apply a test ( p1 +? ax+b ) for
each of those lines, and if it passes all the tests, it's in the envelope.

Jose

--
(for Email, make the obvious changes in my address)

http://www.primetab.com/flying/MyNavLog.xls

The sheet marked W&B has what you need. The sheet is for a Piper Warrior, but
you can adjust it for the Cessna numbers. You will need to unprotect the sheet
before making changes, Tools/Protection/Unprotect Sheet. Input the Cessna
numbers for Basic Empty Weight, all the Arms, Unused gallons, and GPH.
Everything else is calculated. Adjust the chart.

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

Send me your correct e-mail address and I will send you the spreadsheet
I developed for my C-172F. It even has the graphic and a "*" to show you
where you are in the envelop. I do not have access to post is anywhere
and I cannot attach to this message. I tried to reply to the address in
your post and it bounced back.

Joe Wasik wrote:

Hello, I put together a quick Excel spreadsheet that calculates total
weight and total moment for a Cessna 172. However, to check the CG, I
still have to take these calculated values and place them onto the
diagram called "Center of Gravity Moment Envelope". Does anyone know
if this lookup can be performed via a calculation? Knowing this
would be very helpful.
Thank you.


Ross
N7905U
180hp

You will need a bunch of "if-then" statements to define the acceptable
envelope(s). Look it up on Excel Help. Lotsa luck though as the same
guys must write the help as write the original software package.

Note that you can nest "if-then" statements (I recall up to 7 in my
Excel) so that in one long statement you could establish a valid
envelope with up to 7 separate boundaries.

An interesting challenge! Good luck.

wrote in message
om...
You will need a bunch of "if-then" statements to define the acceptable
envelope(s). Look it up on Excel Help. Lotsa luck though as the same
guys must write the help as write the original software package.


I have an Excel worksheet with NO if-then statements anywhere.
I used the data from the pilot's handbook to determine the corners
of a graph that represents the W&B envelope. Then I built a table
duplicating the W&B factors from the handbook along with the calcs for the
moment arms. Down at the bottom where the weights and moment arms are
totaled, I transfer them to the graph using an asterisk symbol to represent
the single data point.
Would you please give me an example of a couple if-thens you used,
please?

"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