The Aeroscope – an upgraded version controlled by virtual joystick


This is an upgraded version of the aeroscope. Besides improving of certain aspects of the old version, this version has both the main wing and the horizontal stabilizer controlled by a virtual joystick (presented on this blog before and used extensively). The horizontal movement of the joystick controlls the angle of attack of the main wing and the vertical movement controlls the angle of attack of the horizontal stabilizer. I…


Introduction to Anaglyph Stereoscopy in Excel – part #5: adding a joystick to control the yaw and pitch rates of the 3D cube


In this section, a joystick is added to the model which controlls the  yaw rate and the pitch rate (not the angles!) of the stereoscopic cube. This joystick was used before in a dedicated tutorial and in the flight simulator tutorial. Its importance in future models can not be underestimated, hence I decided to cover this virtual device again. Use your 3D glasses while running the mkodel.


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.