The Aeroscope – an upgraded version controlled by virtual joystick

June 12, 2011

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…


The Aeroscope – a preliminary version of a 2D flight simulator based on real physics

June 11, 2011

This is the “Aeroscope”, an oscilloscope style 2D dynamic flight simulator. It uses a the glider model designed in the previous tutorial. The glider is fully adjustable so you can change different parameters during the flight. Just hit “Run_pause” and the model will start. Reset it using the red button whenever you wish or whenever it breaks the convergence. For very low speeds or very large angles of attack (>20…


Phase Lock Loop (PLL)

September 28, 2010

This is an Excel workbook containing a dynamic model of a Phase Lock Loop. Recommending this site to your friends would be highly appreciated.   Thanks for your support!


Basic 3D-2D (Perspective) Visualization

September 27, 2010

The first two worksheets of this Excel workbook illustrate the creation and display of a rectangle by using a 2D scatter plot. They also show how to adjust its size, translate and rotate it. In the third worksheet a wire-frame cube is created. 3D-2D persective calculations are done. The cube can be zoomed and it can also be rotated in azimuth and altitude using simple macros.  


Roller Coaster

September 20, 2010

A roller coaster in Exel 2003 in 3-dimension (perspective view). To start de ride after download, click the little sun icon in the NE corner of the chart. Most of the calculations are done in the spreadsheet with very little VBA as a “glue”. The display is created on a plain 2D scatter plot.