The current is a preview of a sprite based Excel speedometer model and a series of speedometer creation series of tutorials (#1 and #2)
This is a video preview of the digital clock series which include a model for Excel 2003 a second model for Excel 2007 or 2010 a tutorial #1 and a tutorial #2.
This is a video preview of the analog clock series which include a model section and a tutorial section.
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 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…
This tutorial is an introduction to VBA sound playing macros in Excel. The sound effects can be used in various scientific and engineering models or in games. It first shows the general syntax of a sound playing macro and few sources of downloading free .wav sound files. The first demo macro plays a short sound a single time and the second macro plays a series of three sounds. In order…
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.
In this part of the tutorial, the analysis of the ball movement is continued. The effects of the collision events are introduced in the equations of movement.