The Hierarchy of my Web-Pages logo

Calculating the Wing Lift Distribution with the Diederich Method in Microsoft Excel

Reach this page with


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 Project Report: PDF TextArslan.pdf englisch    Size:  2.9M

PDF TextSchnoor.pdf deutsch    Size:  2.8M

Associated research data:    (Excel File and User Guide)
Download User Guide: PDF User_Guide_Diederich_Method.pdf english    Size:  1.3M
Download Excel File: XLS Diederich_Method_2023.xlsm english    Size:  764K     !!! How to open Excel files with Macros & Solver? deutsch / english !!!

View of Diederich Main Window
Screen shot of major view of Diederich Excel file (click to enlarge)

View of Diederich Main Window further below
Screen shot of major view of Diederich Excel file (further below, click to enlarge)

LAST MODIFIED:  05 November 2023
AUTHOR:  Prof. Dr. Scholz

home  Prof. Dr. Scholz
home  Aircraft Design and Systems Group (AERO)
home  Aeronautical Engineering
home  Department of Automotive and Aeronautical Engineering
home  Faculty of Engineering and Computer Science
home  Hamburg University of Applied Sciences