## An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#1

This is the first part of a tutorial (self, 2, 3) describing the creation of an animated Pseudo Random Number Generator model as a Fibonacci type Linear Feedback Shift Register in MS Excel 2003.Continue Reading

## Two Lissajous Models – a video preview

This is a video preview for two older models included in this blog, a static model and a dynamic model. [sociallocker][/sociallocker] [sociallocker][/sociallocker]Continue Reading

## An RLC Parallel Resonant Circuit – video preview

This is a video preview to the previously published RLC parallel model. [sociallocker][/sociallocker]Continue Reading

## A Phase Locked Loop (PLL) Model – video preview

This is a video preview of an Excel animated PLL model. There is an error in the sound track: it’s Voltage Control Oscillator not Variable Control Oscillator. You can download the Excel Model or check out the series of tutorials about how to code this model from scratch here: 1, 2, 3a, 3, 4. [sociallocker][/sociallocker]Continue Reading

## A Basic Fourier Transform Calculator in Excel – video preview

This is a video preview of the Fourier transform model presented on this blog before. A tutorial explaining the creation of such a model was posted here too. [sociallocker][/sociallocker]Continue Reading

## Spectral Analysis – a Fourier transform tutorial – part #5

This part of the tutorial demonstrates the Fourier transform operation in a few cases of periodic and non-periodic signals, such as an AM signal, an FM signal, a rectangular non repetitive signal and a cardinal sine signal. The last slide contains an application to the scaling property of the Fourier transform on a non-repetitive time signal. It actually shows thatContinue Reading

## Spectral Analysis – a Fourier transform tutorial – part #4

The previous sections explains the creation of a discrete Fourier transform model in Excel. This section and the following one will use the model to calculate and chart the Fourier transform in several cases of periodic and non-periodic signals. [sociallocker][/sociallocker] A Fourier Transform Model in Excel, part #4 by George Lungu – This is a tutorial about the implementation ofContinue Reading

## Spectral Analysis – a Fourier transform tutorial – part #3

The previous sections of the tutorial handled the basic formulas behind building a Fourier model and creating a set of input functions. This section deals with formula implementation on the spreadsheet, the brief VBA code and the charting of the Fourier transform components. [sociallocker][/sociallocker] A Fourier Transform Model in Excel #3 by George Lungu – This is a tutorial aboutContinue Reading

## Spectral Analysis – a Fourier transform tutorial – part #2

In this tutorial the Excel implementation of a Fourier transform is discussed. Seven input signals are created among which sinusoidal, rectangular and combinations of them. A Dirac impulse, an amplitude modulated (AM) signal and a frequency modulated (FM) signal are also added among the input signal options. [sociallocker][/sociallocker] A Fourier Transform Model in Excel #2 by George Lungu – This isContinue Reading

## Spectral Analysis – a Fourier transform tutorial – part #1

This is a basic tutorial about implementation of a standard Fourier transform model in Excel. It is not an introduction to Fourier analysis. You could choose to familiarize yourself with the subject before proceeding with this tutorial. Solving a few Fourier transform excersises would be of help too. Essentially, this part shows you how to adapt the general Fourier formula for a continuous realContinue Reading

## 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 previousContinue Reading

## 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 waveformsContinue Reading

## 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 inContinue Reading

## 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) inContinue Reading

## 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.Continue Reading

## 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 visualizeContinue Reading