This section continues the worksheet implementation of the dynamics formulas for aerodynamic forces and momenta. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #8- worksheet implementation of the real dynamics by George Lungu – This section continues with the dynamics formulas governing our 2D plane. Worksheet implementation of the force calculation formulas: – We will calculate these forces in a new area of the worksheet.Continue Reading

This section continues the  worksheet implementation of the dynamics formulas. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #7- worksheet implementation of the real dynamics by George Lungu – This section continues with the dynamics formulas governing our 2D plane and their worksheet implementation. Some Reynolds number corrections: – We introduced one single named cell for the Reynolds number (Re) when in fact thereContinue Reading

This section discusses the layout of the virtual plane and provides for the worksheet implementation of the plane dimensions as input parameters controlled by spin buttons and macros. In the final part a freeform is used to generate raw data for the fuselage. [sociallocker][/sociallocker] Longitudinal Aircraft Dynamics #3- defining the virtual aircraft by George Lungu – This section of the tutorialContinue Reading

In the previous section, the main wing airfoil and the horizontal stabilizer airfoil were simulated using Xflr5. The three coefficients, lift, drag and moment were then interpolated on charts in Excel using 4th and 5th order polynomials. This section shows a few tricks about how to easily introduce those 60 equations as spreadsheet formulas in Excel ranges. It also presents a simple linear interpolation method across the ReynoldsContinue Reading

This is a tutorial about using a free aerodynamic modeling package (Xflr5) to simulate two airfoils in 2D (the main wing and the horizontal stabilizer) for ten different Reynolds numbers, then using Excel to extract the approximate polynomial equations of those curves (cl, cd and cm) and based on them, simulate a 2D aircraft as an animated model. This section deals withContinue Reading

The previous section implemented and charted the ping-pong polar diagrams in a spreadsheet and showed a reasonable similarity, for moderate angles of attack, between these diagrams and the ones modeled using Xflr5, a virtual wind tunnel. This section introduce the  concept Reynolds number and it also contains a very brief introduction to Xflr5, the free virtual wind tunnel software. AerodynamicsContinue Reading

This section of the tutorial implements the lift and drag formulas in a worksheet, creating and charting the polar diagrams for an ultra simplified ping-pong model of an airfoil. Comparing these diagrams with ones obtained by using a virtual wind tunnel (XFLR5) we can see a decent resemblance for moderate angles of attack (smaller than about 8 degrees in absolute value).Continue Reading

This is the ping-pong aerodynamic analogy. The wing is a ping pong bat and the air is a bunch of evenly spaced array of ping pong balls. It is a naive model but, as we will see in a later post, the polar diagrams derived from this analogy (between -12 to +12 degrees of angle of attack) are surprisingly close shape wise to the real diagrams of a thin,Continue Reading