#### Aerodynamics Naive #1 – deriving the Ping-Pong airfoil polar diagrams

05/17/2011

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, symmetric airfoil. The model of course cannot possibly calculate anything related…

#### How Do They Fly? – an intuitive look into lift generation and flight stability

05/16/2011

Have you ever wondered why the flight attendants of a half empty airliner talk people into moving to the front half of the plane? Have you ever wondered why a flying wing can fly without a tail or why the stability of some of these flying wing can be controlled only by computer? Or why a 12 pack stored in at the back of a Cessna can make the plane unstable……

#### Flight Simulator Tutorial #7 – upgrading the joystick chart, adding a reset button and a throttle scroll bar

04/22/2011

This section displays the landscape on a 2D scatter chart and also upgrades the joystick chart by adding a dial behind the joystick image. This technique of using a stack of a back chart to display dial sprites and a front chart with transparent background to display various control devices, indicator needles and text will extensivly be used in this and future models. [sociallocker][/sociallocker]

#### Flight Simulator Tutorial #6 – macro review, scene derivation and integration, mapping of the 2D u-v data into a chartable 1D array, rejecting image artifacts

04/21/2011

This section finishes the macro analysis and continues with the conversion of the u-v 2D formula array into a chartable 1D array. It also adds two columns to the chartable array, a masking condition for each triangle and masked u-coordinate which will throw out of the visible portion of the chart any shape which has a minimum of one vertex behind the virtual pilot. The section also explains the phenomenon…

#### Flight Simulator Tutorial #5 – the worksheet implementation of the perspective handling formulas and VBA the macros

04/20/2011

This section explains the spreadsheet  implementation of the perspective rotation and translation formulas within the Present array and also the implementation of the 3D-2D conversion formulas within the Past array, then it goes on to presenting the VBA macros used (the Reset and JoyStick macros). The PDF and XLF files were updated -04/22/2011, 5:20 pm MST. [sociallocker][/sociallocker]

#### Flight Simulator Tutorial #4 – matrix allocation and input parameter formulas (roll rate, pitch rate, throttle)

04/19/2011

This section explains the top level functionality of the model, it also allocates the data and formula arrays needed for manipulating the scene image. The roll rate, pitch rate and throttle formulas are implemented in the worksheet. [sociallocker][/sociallocker]

#### A First Flight Simulator Model in Excel

04/18/2011

This is the first version of a 3D flight simulator in Excel. Start by adjusting the zoom on your file to fit the screen, so you can see the whole chart and the buttons underneath, then click “Reset” and then click the red dot in the center of the joystick. After that, the joystick handle will “stick” to your mouse pointer so your mouse becomes the airplane control. Back and forth mouse…

#### Flight Simulator Tutorial #3 – scene rotations and translation

04/14/2011

This section deals with a simple method of creating the appearance of scene movement during the flight. Beside reviewing standandard rotation and translation formulas described before on this blog, the presentation begins to explain how to apply numerical-like methods to create a live and interactive model.

#### Flight Simulator Tutorial #2 – basic airplane positioning, control surfaces and turn dynamics

04/12/2011

This is the second part of a tutorial explaining the creation of an “in-cockpit” flight simulator (versus the remote control simulator) model in Excel 2003. This section introduces some basic piloting background and nomenclature.

#### Flight Simulator Tutorial #1 – the joystick and a ground mesh

04/09/2011

This is the first section of a tutorial explaining how to build a 3D flight simulator in Excel. This part deals with creating a joystick and a triangular ground mesh. The joystick model was explained in a previous post from January 2011 and the ground mesh was already used in the 3D roller-coaster. Please be aware that both the PDF and Excel files for this section have been updated on 4/13/2011 at 7:15 pm. …