|
View: |
Part 1: Document Description
|
|
Citation |
|
|---|---|
|
Title: |
Calculating the Wing Lift Distribution With the Diederich Method in Microsoft Excel |
|
Identification Number: |
doi:10.7910/DVN/UK2SIV |
|
Distributor: |
Harvard Dataverse |
|
Date of Distribution: |
2021-12-07 |
|
Version: |
4 |
|
Bibliographic Citation: |
Schnoor, Max; Arslan, Suna, 2021, "Calculating the Wing Lift Distribution With the Diederich Method in Microsoft Excel", https://doi.org/10.7910/DVN/UK2SIV, Harvard Dataverse, V4 |
|
Citation |
|
|
Title: |
Calculating the Wing Lift Distribution With the Diederich Method in Microsoft Excel |
|
Alternative Title: |
Links to all related documents: |
|
Identification Number: |
doi:10.7910/DVN/UK2SIV |
|
Authoring Entity: |
Schnoor, Max (Hamburg University of Applied Science) |
|
Arslan, Suna (Hamburg University of Applied Science) |
|
|
Other identifications and acknowledgements: |
Scholz, Dieter |
|
Date of Production: |
2023-04-13 |
|
Software used in Production: |
Excel |
|
Distributor: |
Harvard Dataverse |
|
Access Authority: |
Scholz, Dieter |
|
Depositor: |
Scholz, Dieter |
|
Date of Deposit: |
2023-04-13 |
|
Series Name: |
Digital Library - Projects and Theses - Prof. Dr. Scholz |
|
Holdings Information: |
https://doi.org/10.7910/DVN/UK2SIV |
|
Study Scope |
|
|
Keywords: |
Engineering, Luftfahrt, Aeronautics |
|
Topic Classification: |
Aerospace |
|
Abstract: |
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. |
|
Kind of Data: |
Program |
|
Notes: |
The Excel file is set up in English. The first project report with background information was written in German. The second project report is written in English. A "User Guide for the Diederich Method Excel-File" was written in English already in 2021. A totally new and extended version (User_Guide_Diederich_Method-1.pdf) has been written in 2023. In 2023 the Excel file was checked in detail, extended, and the GUI adapted to the style of the other tools from Aircraft Design and Systems Group (AERO): Diederich_Method_2023-1.xlsm. |
|
Methodology and Processing |
|
|
Sources Statement |
|
|
Data Access |
|
|
Notes: |
This is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, License Version 3. The software is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details: http://www.gnu.org/licenses/gpl.html |
|
Other Study Description Materials |
|
|
Related Publications |
|
|
Citation |
|
|
Bibliographic Citation: |
Schnoor, Max, 2021. Die Diederich-Methode zur Berechnung der Auftriebsverteilung am Tragflügel in Microsoft Excel. Project. Hamburg University of Applied Sciences, Aircraft Design and Systems Group (AERO). ----- Translation: ----- Arslan, Suna, 2023. Calculating the Wing Lift Distribution With the Diederich Method in Microsoft Excel. Project. Hamburg University of Applied Sciences, Aircraft Design and Systems Group (AERO). Available from: |
|
Label: |
Diederich_Method_2023-1.xlsm |
|
Text: |
Method improved in some details. |
|
Notes: |
application/vnd.ms-excel.sheet.macroEnabled.12 |
|
Label: |
User_Guide_Diederich_Method-1.pdf |
|
Text: |
User Guide written totally new from scratch. |
|
Notes: |
application/pdf |