Hi guys, Here is a 1D dynamic model I built today simulating heat transfer in a 21-segment bar. Just click on the orange “Demo” button for a quick demo. Hitting “Reset” sets the 21 segments of the bar to the initial conditions which is a fully customizable initial temperature map. Clicking “Start/Pause” starts the simulation and you can watch the bar temperature profile… Read More... "A One-Dimensional Dynamic Heat Transfer Model – a diffusion model"
How to Model a Phase-Locked Loop (PLL) in Excel – part#4
This last section of introductory PLL modeling shows how to upgrade the model with adjustable scale charts for three voltage signals within the loop. The model also shows how to create a Lissajous based phase display. [sociallocker][/sociallocker] How to Model a Phase-Locked Loop (PLL) in Excel – part #4 -This is the continuation of part #2 of the PLL tutorial. The previous… Read More... "How to Model a Phase-Locked Loop (PLL) in Excel – part#4"
How to Model a Phase-Locked Loop (PLL) in Excel – part#3
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… Read More... "How to Model a Phase-Locked Loop (PLL) in Excel – part#3"
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… Read More... "How to Model a Frequency Modulated (FM) Signal – an insight"
How to Model a Phase-Locked Loop (PLL) in Excel – part#2
This is a continuation of the PLL series of tutorials and it starts by implementing and testing the low pass filter created in the previous section. After that, the block diagram is updated and the presentation begins to show how to build the PLL model in a worksheet using the existing LPF formulas. [sociallocker][/sociallocker] How to Model a Phase-Locked Loop (PLL) in… Read More... "How to Model a Phase-Locked Loop (PLL) in Excel – part#2"
How to Model a Phase-Locked Loop (PLL) in Excel – part#1
A Phase-Locked Loop is a type of electronic circuit. It generates an oscillation with the same frequency as a reference oscillation and a relatively constant phase difference with respect to the same reference. The applications spectrum of such a circuit are extremely wide. Signal modulation, demodulation, detection and filtering, frequency conversion and synthesis are just a fraction of what this circuit can do.… Read More... "How to Model a Phase-Locked Loop (PLL) in Excel – part#1"
How to make a game of PONG in Excel – part #10 – final
The previous section explained the VBA upgrades needed to make the score functional and new-game and end-game sound effects were added. This tutorial shows how fix some previous bugs and create a “demo play” option which means that both bats are automatically run by worksheet logic. This is the final part of the of the Pong tutorial series. [sociallocker][/sociallocker] Excel PONG Tutorial #10 – adding… Read More... "How to make a game of PONG in Excel – part #10 – final"
How to make a game of PONG in Excel – part #9
The previous section explained how to add a game score in the upper part of the pong court. This section (which is a continuation of part#8) will explain the VBA upgrades needed to make the score functional. We will add here new-game and end-game sound effects too. Next tutorial will explain how to create a “demo play” option which means that both bats… Read More... "How to make a game of PONG in Excel – part #9"
How to make a game of PONG in Excel – part #8
This section explains how to add score board logic on the worksheet and how to display the score on the court chart using sprites. [sociallocker][/sociallocker] Excel PONG Tutorial #8 – creating a score display by George Lungu – The previous tutorial showed how to associate sound effects (including crowd applause and laughter) to ball collision events. This section (which is a… Read More... "How to make a game of PONG in Excel – part #8"
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] Excel PONG Tutorial #7 – associating sound effects to ball collision events by George Lungu… Read More... "How to make a game of PONG in Excel – part #7"
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… Read More... "Playing Sounds in Excel Using VBA – part #2"
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… Read More... "Playing Sounds in Excel Using VBA – part #1"
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… Read More... "How to make a game of PONG in Excel – part #6"