This is the first section of a tutorial about the creation of a Tetris game in Excel using mainly spreadsheet formulas and very little VBA.
This is a video demo of an older game of Tetris model in Excel. The model is designed for Excel 2003 or earlier versions and it’s too loaded with graphics to work well in Excel 2007 or 2010. You can however try opening it in the newer versions of Excel. I wasn’t personally able to run it satisfactory in 2007.
This is a video preview of an older game of Tetris model in Excel. The model is designed for Excel 2003 or earlier versions and it’s too loaded with graphics to work well in Excel 2007 or 2010. You can however try opening it in the newer versions of Excel. I wasn’t personally able to run it in 2007.
This is a video preview for two older models included in this blog, a static model and a dynamic model.
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.
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.
This is a video preview of an older PLL model. There is an error in the sound track: it’s Voltage Control Oscillator not Variable Control Oscillator.
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.
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.
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.
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…
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.
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…
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…
This section updates an angle formula so that the virtual glider can now perform both backward and forward loops, as well as inverted flight.