论文信息 - Modelización no lineal de secciones aeronaúticas con EXCEL-SOLVER©

Modelización no lineal de secciones aeronaúticas con EXCEL-SOLVER©

The program MICROSOFT-EXCEL © has a great popularity in the professional world of engineering-consulting. The authors are aware of that from own experience. This is the reason that has led us to implement a nonlienar model to predict the ultimate strenght of fuselage and wings structures. The didactic methology has been developed for the subject Aircraft Structural Design in the 4th course of Aeronautical Engineering studies at the Polythecnic University of Valencia. The students show a high level of satisfaction since they learn nonlinear computational methods, valid for real structures; they are capable of the implementation with help of the very visual and handle tool MICROSOFT-EXCEL © (without programming code) and finally they solve nonlinear optimization problems with the numerical analysis complement SOLVER © .

Mario Lázaro | José Luis Pérez Aparicio | J. L. Aparicio | M. Lázaro

[1] M. C. Niu,et al. Airframe Stress Analysis and Sizing , 2011 .

[2] W. Ramberg,et al. Description of Stress-Strain Curves by Three Parameters , 1943 .

[3] E. F. Bruhn,et al. Analysis and Design of Flight Vehicle Structures , 1973 .

[4] T.H.G. Megson,et al. Aircraft structures for engineering students , 1972 .

[5] L. E. Scales,et al. Introduction to Non-Linear Optimization , 1985 .

[6] Stephen P. Boyd,et al. Convex Optimization , 2004, Algorithms and Theory of Computation Handbook.

[7] Michael Chun-Yung Niu,et al. Airframe Structural Design: Practical Design Information and Data on Aircraft Structures , 1988 .

[8] Christopher S. Lynch,et al. Mechanics of Materials and Mechanics of Materials , 1996 .