This is an upgrade from the first part in the sense that it can be adjusted to have more delay based inverters in the feedback (14). This Excel animation is pretty much the same as in the first model, a virtual joystick controls the number of stages in the ring by horizontal movement and it can also control the RC delay… Read More... "A Gated Ring Oscillator Demo – Part#2"
An interactive animated demo of the gated ring oscillator in Excel 2003 based on the previous tutorial. This model stands out because of the real time schematic animation in Excel. It is controlled by a virtual joystick which is generated using a chart with a macro assigned to it. To start the model click the red dot within the joystick chart.… Read More... "A Gated Ring Oscillator Demo – Part#1"
This is the fourth part of tutorial about making an interactive animated Excel model of a gated ring oscillator in MS Excel 2003. This section adds a joystick to the model which smoothly adjusts the RC delay constant (vertical movement) and the number of delay stages within the ring (horizontal movement). An additional function of the joystick is to control the gating… Read More... "An Interactive Gated Ring Oscillator Tutorial – part #4"
This is a preview to the 3D flight simulator model previously published on this blog. You can download the Excel Model or check out how to build this animation from scratch here: 1, 2, 3, 4, 5, 6, 7. Read More... "A 3D Flight Simulator – video preview"
In this version, the vertical joystick movement controls the incidence of both the main wing and the horizontal stabilizer (opposite variation) and the horizontal movement of the joystick controls the position of the center of mass. [sociallocker][/sociallocker] Read More... "The Aeroscope – center of mass position control by 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 controls the angle of attack of the main wing and the vertical movement… Read More... "The Aeroscope – an upgraded version controlled by virtual joystick"
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… Read More... "Introduction to Anaglyph Stereoscopy in Excel – part #5: adding a joystick to control the yaw and pitch rates of the 3D cube"
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 extensively be used in this… Read More... "Flight Simulator Tutorial #7 – upgrading the joystick chart, adding a reset button and a throttle scroll bar"
This section finishes the macro analysis and continues with the conversion of the u-v 2D formula array into a chart-able 1D array. It also adds two columns to the chart-able 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… Read More... "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 explains the spreadsheet implementation of the perspective rotation and translation formulas within the Present array. It also shows 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). [sociallocker][/sociallocker] A Basic Flight Simulator in Excel #5 – the worksheet implementation of the… Read More... "Flight Simulator Tutorial #5 – the worksheet implementation of the perspective handling formulas and VBA the macros"
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 Basic Flight Simulator in Excel #4 – creating the initial, current and previous landscape matrices by George Lungu – This section starts… Read More... "Flight Simulator Tutorial #4 – matrix allocation and input parameter formulas (roll rate, pitch rate, throttle)"
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… Read More... "A First Flight Simulator Model in Excel"
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. A Basic Flight Simulator in Excel #3 – calculating the scene rotation and translation as a result… Read More... "Flight Simulator Tutorial #3 – scene rotations and translation"
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. A Basic Flight Simulator in Excel #2 – airplane positioning, control surfaces and turn dynamics by George Lungu – This tutorial explains the basics of airplane… Read More... "Flight Simulator Tutorial #2 – basic airplane positioning, control surfaces and turn dynamics"