By popular demand I am coming back to Excel after a long hiatus. This is an update of an older model previously presented on this blog. > I added a few features to the roller coaster model as follows: 1) Performance log 2) All sorts of colors and color scheme selection 3) Speed control 4) Coaster length adjustment 3) Ground… Read More... "Excel Roller Coaster Update #1"
A Phase Locked Loop (PLL) Model – video preview
This is a video preview of an Excel animated PLL model. There is an error in the sound track: it’s Voltage Control Oscillator not Variable Control Oscillator. You can download the Excel Model or check out the series of tutorials about how to code this model from scratch here: 1, 2, 3a, 3, 4. [sociallocker][/sociallocker] Read More... "A Phase Locked Loop (PLL) Model – video preview"
A 3D Animated Excel Roller Coaster – video preview
This is a video preview for the 3D animated roller coaster previously presented on this blog. A tutorial on this topic will be posted later. [sociallocker]>[/sociallocker] Read More... "A 3D Animated Excel Roller Coaster – video preview"
The Aeroscope – center of mass position control by joystick
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"
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 controls the angle of attack of the main wing and the vertical movement… Read More... "The Aeroscope – an upgraded version controlled by virtual joystick"
The Aeroscope – a preliminary version of a 2D flight simulator based on real physics
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… Read More... "The Aeroscope – a preliminary version of a 2D flight simulator based on real physics"
Phase Lock Loop (PLL)
This is an Excel workbook containing a dynamic model of a Phase Lock Loop. [sociallocker][/sociallocker] Read More... "Phase Lock Loop (PLL)"
Basic 3D-2D (Perspective) Visualization
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 perspective calculations are done. The cube can be zoomed and it can also be rotated in… Read More... "Basic 3D-2D (Perspective) Visualization"
Fourier Transform
This is an Excel workbook calculating the Fourier transform of a signal. [sociallocker][/sociallocker] Read More... "Fourier Transform"
Animated Roller Coaster in Excel
A roller coaster in Excel 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. [sociallocker][/sociallocker] Read More... "Animated Roller Coaster in Excel"