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 compatable 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