MICROSOFT EXCEL WEIGHT AND BALANCE SPREADSHEET FOR
TAILWHEEL AIRCRAFT WITH THE DATUM FORWARD OF THE MAIN WHEELS.


All you need to do is download this booger, load it in Microsoft Excel and punch in the necessary numbers in the RED spaces. It will do all the rest and give you the data you need in the BLUE spaces. WHAT A DEAL!!! (This works on Microsoft Excel versions 97 SR-1. However, I offer no guarantees!! I don't know if it's compatible with other spreadsheets or not. If you have a different number crunching program, and this works on it, please let me know and I'll update the page to say so. Thanks!)


 

WEIGHT AND BALANCE FOR AIRCRAFT WITH

THE DATUM FORWARD OF THE MAIN WHEELS

ENTER DATA IN THE RED CELLS AS NEEDED

COMPUTED RESULTS IN THE BLUE CELLS.

ALL WEIGHTS IN LBS, DISTANCES IN INCHES
PART ONE
(EMPTY WEIGHT DATA)

IF YOU DON'T KNOW, GO TO PART TWO

ENTER EMPTY AIRCRAFT WEIGHT HERE =

LBS

ENTER AIRCRAFT EMPTY CG HERE =

IN.

ENTER EMPTY MOMENT HERE =

0

INCH/LBS

CALCULATED EMPTY AIRCRAFT MOMENT =

0

INCH/LBS

PART TWO
CALCULATING EMPTY WEIGHT DATA
MAIN GEAR DATA

MAIN WHEELS DATA

WEIGHTS

RIGHT MAIN WHEEL WEIGHT =

LBS

LEFT MAIN WHEEL WEIGHT =

LBS

MAIN WHEEL DISTANCE FROM DATUM =

IN.

MAIN WHEEL MOMENT IF KNOWN =

0

INCH/LBS

CALCULATED MAIN WHEEL MOMENT =

0

INCH/LBS

TAIL WHEEL/NOSE WHEEL DATA

TAIL/NOSE WHEEL WEIGHT =

LBS

TAIL/NOSE WHEEL DISTANCE FROM DATUM=

IN.

TAIL/NOSE MOMENT IF KNOWN =

INCH/LBS

CALCULATED TAIL/NOSE MOMENT =

0

INCH/LBS

TOTAL WEIGHT =

0

LBS

CG

MOMENT

EMPTY WEIGHT CENTER OF GRAVITY DATA

IN

INCH/LBS

FIGURE FINAL CG BELOW
ENTER THE FOLLOWING AS NEEDED

SUBJECT

WEIGHT

X

ARM

X

MOMENT

AIRCRAFT EMPTY WEIGHT =

X

X

INCH/LBS

PILOT WEIGHT =

X

X

0

INCH/LBS

PASSENGER WEIGHT =

X

X

0

INCH/LBS

FUEL WEIGHT (6 LBS/GAL) =

X

X

0

INCH/LBS

OIL WEIGHT (1.9LBS/QT) =

X

X

0

INCH/LBS

BAGGAGE WEIGHT =

X

X

0

INCH/LBS

EXTRA WEIGHT #1 =

X

X

0

INCH/LBS

EXTRA WEIGHT #2 =

X

X

0

INCH/LBS

EXTRA WEIGHT#3 =

X

X

0

INCH/LBS

TOTALS

0

LBS

INCH/LBS

AIRCRAFT CENTER OF GRAVITY =

INCHES FROM DATUM


Now, to download this thing, Right click on the link below, then select "Save Link As" or "Save Target As"(depending on your browser). Then tell your puter where you want to save it.

Download 

If the download doesn't work, email me and I'll send it to you as an attachment.