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"
animated electronics models in excel
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"
Tutorial – a Static Lissajous Emulator
Hi there, this is a tutorial explaining the construction of a very basic Lissajous emulator in Excel. It’s supposed to be very easy to understand at the high school level. Good luck, George [sociallocker][/sociallocker] A Lissajous emulator in Excel by George Lungu Introduction: Jules A. Lissajous was a French mathematician from the 19th century – He wanted to visualize… Read More... "Tutorial – a Static Lissajous Emulator"
RLC-Parallel
This RLC parallel circuit model has several sound effects so it must be dearchived in the same subdirectory. [sociallocker][/sociallocker] Read More... "RLC-Parallel"
Dynamic Lissajous Emulator
This is a dynamic Lissajous emulator in the sense that the waveform is obtained by combining 2 time varying sinusoidal waves with different frequencies. [sociallocker][/sociallocker] Read More... "Dynamic Lissajous Emulator"
Static Lissajous Emulators (2D and 3D)
This is a static Lissajous emulator in the sense that the waveform is obtained by combining 2 static sinusoidal waves with different frequencies. As a parenthesis, I will be preparing a dynamic version which will look just like the wave shape seen on a real oscilloscope. The file presented here has two different worksheets, the first one contains a classic 2D… Read More... "Static Lissajous Emulators (2D and 3D)"
Phase Lock Loop (PLL)
This is an Excel workbook containing a dynamic model of a Phase Lock Loop. [sociallocker][/sociallocker] Read More... "Phase Lock Loop (PLL)"
Fourier Transform
This is an Excel workbook calculating the Fourier transform of a signal. [sociallocker][/sociallocker] Read More... "Fourier Transform"