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. …

A Virtual Joystick – How Can You Make That ? – tutorial

01/31/2011

Hello everybody, this is a tutorial in which a virtual  Excel joystick controlled by mouse movements on a scatter chart has been demonstrated . While in operation, a macro updates the coordinates of the pointer in two spreadsheet cells. The two coordinates are then incorporated in formulas which limit the range of motion of the joystick. Just like a real device the stick head movement is confined within a square (with a side…