Weight and Balance Formula, Can one calculate the envelope

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.