Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching Aircraft Design Tutorial: Aircraft Performance Analysis using Microsoft Excel. and this video is uploaded by Dr. Gudmundsson's Aircraft Design Channel at 2022-01-07T21:10:20-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [yRd2-NSAFaA]
| Name | Aircraft Design Tutorial: Aircraft Performance Analysis using Microsoft Excel |
| Video Uploader | Video From Dr. Gudmundsson's Aircraft Design Channel |
| Upload Date | This Video Uploaded At 08-01-2022 05:10:20 |
| Video Discription | 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-Aviation-Aircraft-Design-Procedures-dp-0128184655/dp/0128184655/ref=mt_other?_encoding=UTF8&me=&qid=1641425169 and https://www.elsevier.com/books/general-aviation-aircraft-design/gudmundsson/978-0-12-818465-3 [yRd2-NSAFaA] |
| Category | Science & Technology |
| Tags | aircraft design | dr gudmundsson | snorri | performance | climb | descent | cruise | range | endurance | stall |
