A 2D Random Walk Animation Tutorial

This tutorial explains how to build two animated random walk models, one where the particle is confined to square grid and one where the particle is free to step in any direction. The first model is adequate for modeling particle movement in solids while the second is more fit for modeling particle diffusion motion in fluids. [sociallocker][/sociallocker]

Read More >>

Animated Heat Transfer Modeling for the Average Joe – part #2

This is a continuation of the first part of the beginner series of tutorials in heat transfer modeling. The first part introduced the reader to the concept of heat capacity (being analogous to the electrical capacity).  This section continues with the concept of heat conductance which is analogous to the electrical conductance.  Ohm’s law applies.  Toward the end, the principle of using both concepts together (heat storage and heat conduction)…

Read More >>

How to Model a Frequency Modulated (FM) Signal – an insight

Both frequency and phase modulation are important not only in electronics but also in science and physics in general. It seems like a trivial chore but when I first tried to model such a signal some time back I hit a hard wall. Our minds easily understand kinematics concepts such as coordinate, speed, acceleration and the relations between them in real life situations, but phase, frequency and angular acceleration are…

Read More >>

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

This section of the tutorial explains how to add sounds to the Pong game created previously. There are four types of sound effects: collision with the walls, collision with the bats, missed ball by the player (crowd laughter) and missed ball by the virtual opponent (crowd applause). [sociallocker][/sociallocker]

Read More >>

Playing Sounds in Excel Using VBA – part #2

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 >>

Playing Sounds in Excel Using VBA – part #1

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…

Read More >>

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

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. [sociallocker][/sociallocker]

Read More >>