W&B excel

Upload or Download weight & balance sheets
User avatar
CyclicH145
1st Dan
1st Dan
Posts: 214
Joined: Dec 2017

W&B excel

Postby CyclicH145 » Tue Jan 23 2024, 12:14

Hi

Hoping someone has a B206B-3 W&B excel available.
Gunga Din
Silver Wings
Silver Wings
Posts: 88
Joined: Jan 2021

Re: W&B excel

Postby Gunga Din » Wed Jan 24 2024, 02:07

PM sent.

GD
Arm, arm, I Gunga Din, the door slockt.
Gunga Din
Silver Wings
Silver Wings
Posts: 88
Joined: Jan 2021

Re: W&B excel

Postby Gunga Din » Wed Jan 24 2024, 06:37

It's also easy enough to make your own:
In 1st column put these:
ITEM
1. Plt
2. Coplt
3. Pax1
4. Pax2
5. Pax3
6. Cargo
7. Empty Wt
8. Fuel
9. TOW
10. C of G

Next column:
NAME (If you want a pax manifest as well)

Next Column:
WEIGHT
and next to Empty Wt you put Sum (1:6)
next to fuel, put in weight of fuel
Next to TOW put in Sum (7:8)

Next column:
ARM and put in the arm of each seat/ cargo spot / fuel tank

Next Column:
MOMENT and it is Weight x Arm
On the 9th line TOW, put Sum (1:8)
On 10th line C of G, put the above sum divided by the TOW, and you have your first CG point.
If, like the B206 and 206L, the arm of the fuel changes in flight, you will need another calculation with unuseable fuel weight added to Empty weight, and the moment for that unuseable fuel.

A genius like me (or what I used to be before senility set in) then draws up a chart with the CG boundaries on it, plotting the TOW point and the Unuseable fuel point with a line between the two. The line must not touch or cross the boundaries.

PM me with your email if you want a copy of 4 different B206 W&B sheets, done in a simple style. I used to have a 206L chart with the different seating and fuel limitations. I also have a B412 chart, not done by me, with far more intensive calculations for role equipment and other stuff.
Arm, arm, I Gunga Din, the door slockt.
User avatar
CyclicH145
1st Dan
1st Dan
Posts: 214
Joined: Dec 2017

Re: W&B excel

Postby CyclicH145 » Wed Jan 24 2024, 08:38

Gunga Din wrote:It's also easy enough to make your own:
In 1st column put these:
ITEM
1. Plt
2. Coplt
3. Pax1
4. Pax2
5. Pax3
6. Cargo
7. Empty Wt
8. Fuel
9. TOW
10. C of G

Next column:
NAME (If you want a pax manifest as well)

Next Column:
WEIGHT
and next to Empty Wt you put Sum (1:6)
next to fuel, put in weight of fuel
Next to TOW put in Sum (7:8)

Next column:
ARM and put in the arm of each seat/ cargo spot / fuel tank

Next Column:
MOMENT and it is Weight x Arm
On the 9th line TOW, put Sum (1:8)
On 10th line C of G, put the above sum divided by the TOW, and you have your first CG point.
If, like the B206 and 206L, the arm of the fuel changes in flight, you will need another calculation with unuseable fuel weight added to Empty weight, and the moment for that unuseable fuel.

A genius like me (or what I used to be before senility set in) then draws up a chart with the CG boundaries on it, plotting the TOW point and the Unuseable fuel point with a line between the two. The line must not touch or cross the boundaries.

PM me with your email if you want a copy of 4 different B206 W&B sheets, done in a simple style. I used to have a 206L chart with the different seating and fuel limitations. I also have a B412 chart, not done by me, with far more intensive calculations for role equipment and other stuff.


Thanks mate, just replied

Return to “Flight Planning”

Who is online

Users browsing this forum: No registered users and 1 guest