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 |
||||||
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.
If the download doesn't work, email me and I'll send it to you as an attachment.
Back to the Dawn Patrol's home page.
About
The Dawn Patrol Frequently Asked Questions
Get On The Builder's Chat List
Order Dick Starks' Book
Order Our Video Tapes
The Dawn Patrol's Trailers
2002 Air Show Schedule
Goods FOR SALE Tom Glaeser's Chainsaw Starter
Marvin Story's Tubing Notcher
Dick
Hartzler's Cowlings Our Rib Bending JIgs
Nieuport Engine Mounts
Weight and Balance Information
Book and Video Order Form
Assorted Aviation Links A.F.S. Paint and Covering
Various Suppliers List
Gary's Cool Tools
Smoke System Poster Stands