Tweet
Here's an attached weight and balance spreadsheet below (.xlxs). You should be able to download it and it's designed work on iMac, iPad or iPhone. It will convert to Excel, but no guarantees there.
It contains a list of equipment and arms so that builders can compare their own measurements for a gross error comparison, and explore the effect of placing different weights at various locations.
It can also be used to calculate an accurate Weight and CG before each flight.
How to use
To begin, overwrite your wheel weights in the magenta boxes. Alternatively you can use the existing wheel weights which are for an IO540 powered Bearhawk, with a 3 bladed composite prop. You could for example use a friends wheel weights, and then start modifying the arm weights.
Yellow boxes = arms in inches (or mm)
Top grey boxes = total weight and CG
Green boxes = click and use slider to add people, cargo, fuel.
Blue boxes = click and use slider to add or subtract weight from that arm location.
Examples
Example 1. If you want to add heavier tires, click the blue box for tires and increase the slider the amount you wish to add. Then look at the top grey boxes to see the resulting empty weight and CG.
Example 2. You want to see the effect of changing from your current 2 bladed prop to a 3 blade prop. Click the blue propeller box and increase by 20lbs. View the resulting empty weight and CG in the top grey boxes.
Example 3. You decide to take out next years STOL comp and add 30 lbs ballast to the aft fuselage grab handles. Click the blue box for ballast at grab handles and move the slider to 30 lbs. Add your own weight to the green front seat box, and some fuel weight. View the resulting weight and CG in the top grey boxes.
Example 4. Aunt Sally weighs 300lbs. You figure she can fit in the back seat. Click the green rear seat box and move the slider to 300 lbs. Add yourself and uncle Bill's weight to the front seats, some fuel, and play around with the cargo weight to see how much you can carry. View the resulting weight and CG in the top grey boxes.
DB77228F-8E2B-4123-88D0-E87A7C7276BC.jpg
AD44C500-7AAD-46CE-BCE7-95943800AAF9.jpg
It contains a list of equipment and arms so that builders can compare their own measurements for a gross error comparison, and explore the effect of placing different weights at various locations.
It can also be used to calculate an accurate Weight and CG before each flight.
How to use
To begin, overwrite your wheel weights in the magenta boxes. Alternatively you can use the existing wheel weights which are for an IO540 powered Bearhawk, with a 3 bladed composite prop. You could for example use a friends wheel weights, and then start modifying the arm weights.
Yellow boxes = arms in inches (or mm)
Top grey boxes = total weight and CG
Green boxes = click and use slider to add people, cargo, fuel.
Blue boxes = click and use slider to add or subtract weight from that arm location.
Examples
Example 1. If you want to add heavier tires, click the blue box for tires and increase the slider the amount you wish to add. Then look at the top grey boxes to see the resulting empty weight and CG.
Example 2. You want to see the effect of changing from your current 2 bladed prop to a 3 blade prop. Click the blue propeller box and increase by 20lbs. View the resulting empty weight and CG in the top grey boxes.
Example 3. You decide to take out next years STOL comp and add 30 lbs ballast to the aft fuselage grab handles. Click the blue box for ballast at grab handles and move the slider to 30 lbs. Add your own weight to the green front seat box, and some fuel weight. View the resulting weight and CG in the top grey boxes.
Example 4. Aunt Sally weighs 300lbs. You figure she can fit in the back seat. Click the green rear seat box and move the slider to 300 lbs. Add yourself and uncle Bill's weight to the front seats, some fuel, and play around with the cargo weight to see how much you can carry. View the resulting weight and CG in the top grey boxes.
DB77228F-8E2B-4123-88D0-E87A7C7276BC.jpg
AD44C500-7AAD-46CE-BCE7-95943800AAF9.jpg
Comment