 | Empty weight vs TOGW.
This spreadsheet compares different formulae for relating airplane empty
weight to TOGW. It shows that simple linear relationship are adequate
for aircraft sizing at the conceptual design level. |
| Sizing and constraint spreadsheet.
This spreadsheet was originally coded for Lotus 1-2-3. Goalseeker capabilities (as available in ExcelTM) did not exist in
Lotus 1-2-3 at that time, so (using the
terminology in Nicolai) matching empty weight required (from statistical
analysis or empty weight buildup) to empty weight available (based on mission
analysis) had to be performed graphically. Although this spreadsheet is
now somewhat antiquated, it shows many of the procedures for spreadsheet
sizing that students perform in design class. Note the procedure for
finding the value of TOGW that was closest to matching the intersection of the
two empty weight lines. This was crude, but the best that could be done
at the time. |
| Cm vs
alpha. This contains a plot of Cm vs alpha and permits
users to test the parameters of various configurations, such as an uncambered
wing with aft tail, a cambered wing with aft tail, a canard, and a tailless
aircraft. |
| Notch chart. This is a procedure for finding
the horizontal tail volume coefficient based on requirements for 1) Takeoff
rotation, 2) Pitch control on approach with full flaps, 3) Defined
longitudinal static stability margin, and 4) Required cg travel. |
| Drag Polar Plotter.
A spreadsheet for plotting the drag polar of a cambered airfoil based on
planform geometry and assumed zero-lift drag coefficient, and calculating the
value of (L/D)max |
![[Company Logo Image]](_borders/ADAC%20logo.gif)
