supergokougt Posted October 16, 2017 Report Share Posted October 16, 2017 Does anyone have one of those handy w and b spreadsheets for the cabri? 1 Quote Link to comment Share on other sites More sharing options...
RotaryRish Posted October 18, 2017 Report Share Posted October 18, 2017 Can you not just modify one already built for 22 or 44? Quote Link to comment Share on other sites More sharing options...
supergokougt Posted October 18, 2017 Author Report Share Posted October 18, 2017 Maybe. But I do not know how to do that. I can sum formula and sort. About my length of skill in excel. Quote Link to comment Share on other sites More sharing options...
Eric Hunt Posted October 19, 2017 Report Share Posted October 19, 2017 Column 1: ItemColumn 2: WeightCol 3: ArmCol 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. 1 Quote Link to comment Share on other sites More sharing options...
supergokougt Posted October 19, 2017 Author Report Share Posted October 19, 2017 Can't wait to see what you come up with. Quote Link to comment Share on other sites More sharing options...
Eric Hunt Posted October 19, 2017 Report Share Posted October 19, 2017 Can't wait to see what you come up with. Actually, I gave YOU the formula, to see what YOU would come up with. It is also fairly simple to include a chart with the CG envelope displayed, and the aircraft cg moving from takeoff weight to empty weight. 1 Quote Link to comment Share on other sites More sharing options...
takefootoff Posted October 19, 2017 Report Share Posted October 19, 2017 Doesn't seem that simple. 1 Quote Link to comment Share on other sites More sharing options...
Eric Hunt Posted October 20, 2017 Report Share Posted October 20, 2017 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. Quote Link to comment Share on other sites More sharing options...
supergokougt Posted October 20, 2017 Author Report Share Posted October 20, 2017 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! Quote Link to comment Share on other sites More sharing options...
Wally Posted October 20, 2017 Report Share Posted October 20, 2017 (edited) 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.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... Your weight, arm and moment next. 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. 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. Fuel, each tank; passengers, each seat; cargo areas- each, weight times the arm. The sum of weights is your present weight, the total moments divided by present weight is your cg. 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...Least weight and forward (or aft) limit ARM and moments, blocks arranged and calculated as above. Maximum weight, forward arm / moment at that point, as above. Subtract minimum weight of weight and balance entered above from max Subtract cg moment limit at minimum from max moment (you're gonna do this for the forward limits and the aft limits) divide the total moment difference by the total weight limits, this is a rate of change with weight change. 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 October 20, 2017 by Wally Quote Link to comment Share on other sites More sharing options...
cherminator Posted October 21, 2017 Report Share Posted October 21, 2017 Gyronimo has a weight and balance app for the Cabri G2:https://itunes.apple.com/us/app/cabri-g2/id924252097?ls=1&mt=8 1 Quote Link to comment Share on other sites More sharing options...
supergokougt Posted October 21, 2017 Author Report Share Posted October 21, 2017 (edited) 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 October 22, 2017 by supergokougt Quote Link to comment Share on other sites More sharing options...
r22butters Posted October 21, 2017 Report Share Posted October 21, 2017 So tell me Mr. Cabri, how heavy can the pilot plus passenger be before they hit the forward CG line with no gas? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.