Animated Asynchronous Electric Motor Model in Excel
This is an animation of an asynchronous electric motor in Microsoft Excel. You can download the model by clicking on the icon below and try to run it.
Mechanical
This section is dedicated to modeling mechanical systems in Excel 2003 standard.
A Virtual Shooting Range in Excel – video preview
This is a video preview to the shooting range model posted in February 2010.
Harmonograph Video Demo
A video demonstration of the virtual harmonograph running through a series of sixteen preset patterns.
A 3-pendulum Animated Harmonograph Model – video preview
A video review of the 3-pendulum animated harmonograph model together with the tutorials (part #1, part #2).
A Legacy Animated Planetary Model – video preview
A preview of a legacy planetary model.
3-Body Planetary System with Options – video preview
A video preview to an older model.
An Animated 2D Spring Oscillator – video preview
This is a video preview of an animated triple spring mass damper system moving in a 2-dimensional space. The model will work in all versions of excel but it will be slow in 2007 and 2010.
Animated 1D Spring Oscillators – video preview
This is a video preview of the Simple Spring-Mass-Damper System model and the Double Spring-Mass-Damper System previously presented on this blog.
A Basic Planetary System – video preview
Since not everybody has Excel and more and more people are on the dumbed down new versions (2007 and 2010) I am presenting these previews to give the readers a feel of the real speed and feel of some of the models in older Excel versions (in this case 2003). This preview refers to an older model.
A Basic Fourier Transform Calculator in Excel – video preview
This is a video preview of the Fourier transform model presented on this blog before. A tutorial explaining the creation of such a model was posted here too.
A Rigid Gravitational Pendulum Model – video preview
Here is a video preview for the gravitational pendulum model previously presented on this blog .
The Aeroscope – video preview #2 and an improved Excel file (#4)
This is an improved version of the Aeroscope – the “Aeroscope_4”. It runs about 50% faster. Also if you start the model by clicking the green “Fly_by_settings” button you can fly hands-free and adjust parameters during the flight. You can at any time click the red dot in the center of the chart and start the joystick macro, which means that now you “pilot” the plane by the stick. Clicking…
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.
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…
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 very low speeds or very large angles of attack (>20…
Longitudinal Aircraft Dynamics #11 – full 360 degree operation – aerobatics, inverted flight and loops – FINAL
This section updates an angle formula so that the virtual glider can now perform both backward and forward loops, as well as inverted flight.
Longitudinal Aircraft Dynamics #10 – implementing the numerical method
This section of the turorial finalizes the main dynamics calculations and implements the numerical method for approximating the glider trajectory. At this point, the model is already functional but with a crude interface.
Longitudinal Aircraft Dynamics #9 – more about forces and momenta – preliminary validation and testing
This tutorial finalizes the implementation of the forces and momenta acting on the plane. It also initiates some hand testing and validation of the overall dynamics of the plane.
