Jump to content

Cabri G2 Weight and Balance Spreadsheet


Recommended Posts

Column 1: Item

Column 2: Weight

Col 3: Arm

Col 4: col 2 x col 3 = Moment

 

Each row is a separate item, starting with Right seat, then left seat, fuel, aircraft wt (from wt sheet in flt manual, includes unuseable fuel and full oil), nav bag, portable gps, survival stuff in cargo comptmt, hip flask, bong etc

 

At bottom of Col 2 is total weight, bottom of col 4 is total moment, then Col 4 / Col 2 will give you the cg arm.

 

Simples.

  • Like 1
Link to comment
Share on other sites

it is, even for a hellyklopper pilet.

 

Get it to draw the envelope by feeding in the max AUM as the upper limit, and the empty weight as the bottom line, the most forward cg as the left side, and the most aft as the right side.

 

Then make a line between the takeoff weight/cg and the ZFW/cg, the 2 numbers you extract from the previous table, and you have a nice little box with a line that should stay inside the box at all times. For something more tricky, like a 206L where the fuel cg moves a lot, you also feed in the most forward fuel number into your calcs, and the most aft. Most times you will be on the ground before the most aft.

Link to comment
Share on other sites

Here is one for the 44: https://drive.google.com/open?id=0ByTKLnwLt2OmX0NVSHItSXJFYVE

 

And the 407: https://drive.google.com/open?id=0ByTKLnwLt2OmYzNReUdFWDRQMzg

 

I couldn't find my 206L one so sorry I can not give you that file to edit but I think either of those should work right? The 44 one has a lot going on with it so it may not work.

 

Might have to download and open with excel not the google sheets to edit properly. I really appreciate all the help guys!

Link to comment
Share on other sites

Written (created?), used and shared W&b spreadsheets for years. It's as simple as Eric Hunt posted. I wanted a little more for HEMS in an Astar, as the patient weight limit requires a couple different calculations. But it's not difficult in Excel at all.

  1. Aircraft basic weight, moment and arm will not change during the flight being planned for, so start with an input of those data. Arm is pretty useless at this point, but...
  2. Your weight, arm and moment next.
  3. Thw 'moment blocks for each seat, fuel, and cargo is weight times arm equals.., and you can copy down the column as many times as you'll change configuration.
  4. You will be summing weights and MOMENT inputs, so start creating that column. Simplest to put the summing blocks at the top of the column and "freeze" that row and the row beneath so those b;ocks are always visible.
  5. Fuel, each tank; passengers, each seat; cargo areas- each, weight times the arm.
  6. The sum of weights is your present weight, the total moments divided by present weight is your cg.
  7. If you want quick reference to fore and aft limits, that's easily calculated for the second 'frozen' row at the top of the spreadsheet. The limits are graphed but also specifically stated, especially if it changes at some point.

CG limits are Easy peasey...

  1. Least weight and forward (or aft) limit ARM and moments, blocks arranged and calculated as above.
  2. Maximum weight, forward arm / moment at that point, as above.
  3. Subtract minimum weight of weight and balance entered above from max
  4. Subtract cg moment limit at minimum from max moment (you're gonna do this for the forward limits and the aft limits)
  5. divide the total moment difference by the total weight limits, this is a rate of change with weight change.
  6. Your actual weight less the fore/aft cg limit multiplied by the rate of change, copied to a second row block to refer fore and aft to existing....

If you're smart enough to fly, you're smart enough to do this on Excel. After you block this out, run scenarios longhand to check your calculations for fidelity to the real world. I initially crossed blocks, columns, references, plus/minus, etc. but this 3rd grade math rationally arranged. Checking it will show errors, once those are fixed, I had a spreadsheet I could put on my smartphone. And tinker with, adding calculations I might want sometime...

 

P.S. That rate change for cg limits can also be included for irregular fuel arms, like the Bells.

Edited by Wally
Link to comment
Share on other sites

That's a sharp looking app. I downloaded iBal but my iDisappointment there is error in the calculations. Everything too far forward and over max. Edit: I read the faq of the app and have been able to update the specifics and it is working ok but I need to check math.

 

Don't worry posters I have been trying to build my own using your instructions. I get it. Teach a man to fish blah blah blah. So far 2 hours of work it is getting close.

Edited by supergokougt
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...