Fulltext available Open Access
Publisher URL: https://doi.org/10.7910/DVN/UK2SIV
Title: Calculating the Wing Lift Distribution With the Diederich Method in Microsoft Excel
Language: English
Authors: Schnoor, Max 
Keywords: Luftfahrt; Luftfahrzeug; Flugzeugentwurf; Aerodynamik; Flugzeug; Tragflügel; Auftrieb; Profil; Strömung; Rumpf; Triebwerk; Machzahl; Reynoldszahl; Pfeilung; Zuspitzung; Aeronautics; Airplanes; Aerodynamics; Design; Atmosphere; Lift; Airplanes--Wings; Wing; Taper; Mass; Stall; Subsonic; Distribution; ISA; Diederich; Mason
Issue Date: 30-Mar-2021
Is supplement to: http://hdl.handle.net/20.500.12738/13163
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.
The Excel file is set up in English. The project report with background information is written in German. A "User Guide for the Diederich Method Excel-File" is written in English and is available in this upload and as Appendix C of the project report.
URI: http://hdl.handle.net/20.500.12738/13729
Review status: Unknown / not specified
Rights: https://opensource.org/license/gpl-3-0/
Institute: Forschungsgruppe Flugzeugentwurf und -systeme (AERO) 
Department Fahrzeugtechnik und Flugzeugbau 
Type: Dataset
Appears in Collections:Studentische Datenpublikationen

Files in This Item:
File Description SizeFormat
Diederich_Method.xlsm764.09 kBMicrosoft ExcelView/Open
User_Guide_Diederich_Method.pdf362.33 kBAdobe PDFView/Open
Show full item record

Page view(s)

checked on Sep 26, 2023


checked on Sep 26, 2023

Google ScholarTM


HAW Katalog


Note about this record

Items in REPOSIT are protected by copyright, with all rights reserved, unless otherwise indicated.