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


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.


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


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


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.


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


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. 


Instant 3D-2D Perspective Mapping – the Navigator Functions – a convenient pair of user defined functions


     This tutorial explains a pair of important user defined functions, the “Navigator_u()” and the “Navigator_v()”. These functions save the user nine columns of formulas by calculating the effects of: 3-dimenssional shift, rotations around the three axes of coordinates and 3D-2D perspective mapping. These user defined functions are also easy to use compared to writing all the perspective mapping equations from scratch. In the previous 3D perspective tutorials we took…


3D-2D Perspective Mapping in Excel – part #2


The first half of this presentation dealt with mapping a 3D scene onto a 2D surface which can be a computer screen, a projection screen or the retina of the eye. By doing so we preserve much of the feel of depth of the scene. Of course when we look at an picture we get only part of the feel of depth because our both eyes see the same image….