Aircraft Design Tutorial: Aircraft Performance Analysis using Microsoft Excel

The video shows how to create a performance analysis spreadsheet for a simple Light Sport Aircraft using Microsoft Excel and methods from my book "General Aviation Aircraft Design: Applied Methods and Procedures."

NOTE 1:
THIS SPREADSHEET WILL NOT BE PROVIDED TO VIEWERS. PLEASE DON'T ASK. The purpose of this effort is to help YOU write your OWN spreadsheet. Giving it away will spoil that fun.

NOTE 2:
Comments are welcome but are censored to prevent viewer chats from spinning into arguments and name calling. If approved, your comments may take a day or two to show up.

HELPFUL POINTERS:
0:33 Introduction
1:26 Helpful formatting tips for my students
2:35 Initial preparation of spreadsheet
2:50 Use of VBA
4:28 Data entry begins
5:55 Atmospherics
8:50 Aerodynamic coefficients - tetup
10:43 Powerplant
12:32 Start formulating table - Airspeeds
15:09 Aero coefficients - tabulation
18:56 Initial plotting of aero coefficients
20:49 Engine performance - tabulation
28:43 Descent and climb performance - tabulation
31:07 Endurance and range performance - tabulation
32:08 Determine optimum airspeeds
35:45 Comparing to existing aircraft

The video uses excerpts from Dr. Gudmundsson's textbook, "General Aviation Aircraft Design - Applied Methods and Procedures," published by Elsevier in 2013 (Edition 1) and 2021 (Edition 2).

The book is available from multiple outlets. Among those are:

https://www.amazon.com/General-Aviati...

and

https://www.elsevier.com/books/genera...