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