![]() |
![]() |
Abstract
Calculating the Wing Lift Distribution with the Diederich Method In Microsoft Excel
Aim of this project is to provide the Diederich Method for calculating the lift distribution of a wing in a Microsoft Excel spreadsheet based on didactic considerations. The Diederich Method is described based on primary and secondary literature. Diagrams are digitized so that the method can run automatically. To optimize the lift distribution of the wing, the elliptical and triangular lift distribution as well as Mason's lift distribution are offered for comparison. A method for calculating the maximum lift coefficient of the wing is integrated into the Diederich Method. To do this, the maximum lift coefficients of the airfoils at the wing root and at the wing tip must be entered in the program. The calculation assumes a trapezoidal wing. Both wing sweep and linear wing twist can be taken into account. The aspect ratio must not assume values that are too small. Subsonic flow and unseparated flow are assumed. Since only the wing is described, all other influences such as from the fuselage or from the engines are not taken into account. The Excel workbook was created for teaching in aircraft preliminary design. At the moment, the Diederich Method is apparently nowhere offered as a spreadsheet. With this work, this gap can be closed.
Download full text: |
![]() |
Date: | 2021-03-30 |
Type of work: | Projekt |
Advisor / Examiner: | Dieter Scholz |
Published by: | Aircraft Design and Systems Group (AERO), Department of Automotive and Aeronautical Engineering, Hamburg University of Applied Sciences |
This work is part of:![]() |
Digital Library - Projects & Theses - Prof. Dr. Scholz ---
http://library.ProfScholz.de
![]() |
PERSISTENT IDENTIFIER: | |
URN: | https://nbn-resolving.org/urn:nbn:de:gbv:18302-aero2021-03-30.017 (to reach this page) |
DOI: | https://doi.org/10.15488/11556 |
ARK: | https://n2t.net/ark:/13960/s2dm83bk1d4 |
Associated research data: | https://doi.org/10.7910/DVN/UK2SIV (Program) |
URLs registered with URN: | Show all links associated with this text! |
CATALOG ENTRY: | |
DNB: | Check inclusion of this title in German National Library! |
WorldCat: | Check inclusion of this title in WorldCat! |
DataCite: | Check inclusion of this title in DataCite! |
Google Scholar: | Check inclusion of this title in Google Scholar! |
Semantic Scholar: | Check inclusion of this title in Semantic Scholar! |
OpenAIRE: | Check inclusion of this title in OpenAIRE! |
BASE: | Check inclusion of this title in BASE! |
CORE: | Check inclusion of this title in CORE! |
Google: | Check inclusion of this title in Google! |
Keywords, German (GND): | Luftfahrt, Luftfahrzeug, Flugzeugentwurf, Aerodynamik |
Keywords, English (LCSH): | Aeronautics, Airplanes, Aerodynamics, Design |
Keywords, free: | Flugzeug, Tragflügel, Auftrieb, Profil, Strömung, Rumpf, Triebwerk, Machzahl, Reynoldszahl, Pfeilung, Zuspitzung, Atmosphere, Lift, Airplanes--Wings, Wing, Taper, Mass, Stall, Subsonic, Distribution, ISA, Diederich, Mason |
DDC: | 629.13, 629.1323, 629.13432, 629.1341 |
RVK: | ZO 7230 |
© This work is protected by copyright
The work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License
CC BY-NC-SA
https://creativecommons.org/licenses/by-nc-sa/4.0
Any further request may be directed to:
Prof. Dr.-Ing. Dieter Scholz, MSME
E-Mail see: http://www.ProfScholz.de
VISIBILITY: (more)
Quote this text:
ISO 690: SCHNOOR, Max, 2021. Die Diederich-Methode zur Berechnung der Auftriebsverteilung am Tragflügel in Microsoft Excel. Projekt. Hamburg University of Applied Sciences, Aircraft Design and Systems Group (AERO). Available from: https://nbn-resolving.org/urn:nbn:de:gbv:18302-aero2021-03-30.017 [viewed YYYY-MM-DD]. |
Major results / graphical abstract:
Prof. Dr. Scholz
Aircraft Design and Systems Group (AERO)
Aeronautical Engineering
Department of Automotive and Aeronautical Engineering
Faculty of Engineering and Computer Science
Hamburg University of Applied Sciences