Excel Tetris – a video demonstration

June 29, 2011

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.

Read More >>

A Game of Tetris in Excel – video preview

June 28, 2011

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.

Read More >>

How to Model a Phase-Locked Loop (PLL) in Excel – part#3

March 13, 2011

This is a continuation of the PLL series of tutorials and it takes the recursive numerical formulas derived in the previous section, implementing a dynamic spreadsheet  model with help from a copy-paste loop type of macro. This macro emulates the behavior of the phase locked loop model in time. At this point, the model is functional. Charting options for the waveforms will be discussed in the following section.

Read More >>

Playing Sounds in Excel Using VBA – part #2

March 3, 2011

This section explains how to create a compound sound effect from elementary sounds. In the first example (two macros), the sound is played in a loop which is a native internal loop within the “PlaySound” function (using the flag option: SND_LOOP = &H8). A second function (the “Beep” function) creates a tone generator with adjustable frequency and play time. The Beep function is also used in a fourth macro, creating a sound which goes…

Read More >>

How to make a game of PONG in Excel – part #6

March 1, 2011

In the previous section a special ball return formula was implemented. Bat #1 was assigned the y-coordinate of the ball and in this way a very simple opponent algorithm was implemented. The problem with this algorithm is that by having Bat #1 perfectly tracking the ball, the opponent was unbeatable. This section shows how to add adjustable skill levels to the virtual pong opponent.

Read More >>

Easy Zoom – Chart Axis Scaling Using VBA

February 15, 2011

In certain models we need to be able to change the scale of the chart axes function of the result of a simulation. Excel charts do have auto-scaling as a default option but sometimes the scaling values we get are not what we need. Another reason against using auto-scaling is that during the time the model runs, the scale self-adjusts and it gives an ever changing, distorted view of the results….

Read More >>