#### Two Lissajous Models – a video preview

06/27/2011

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

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

06/21/2011

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

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

04/08/2011

This part of the tutorial demonstrates the Fourier transform operation in a few cases of periodic and aperiodic signals, such as an AM signal, an FM signal, a rectangular nonrepetitive signal and a cardinal sinus signal. The last slide contains an application to the scaling property of the Fourier transform on a nonrepetitive time signal. It actually shows that spreading a signal in the time domain shrinks its spectrum and…

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

04/07/2011

The previous sections explaind 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 aperiodic signals. [sociallocker][/sociallocker]

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

03/30/2011

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

#### How to Model a Phase-Locked Loop (PLL) in Excel – part#1

03/09/2011

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. Though very simple, it is often not enough understood in industry by…

#### Tutorial – a Static Lissajous Emulator

12/11/2010

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]

#### Dynamic Lissajous Emulator

10/01/2010

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]

#### Static Lissajous Emulators (2D and 3D)

09/29/2010

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 paranthesis, 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 Lissajous figure and the second one has a 3D Lissajous pattern obtained from three different…

#### Phase Lock Loop (PLL)

09/28/2010

This is an Excel workbook containing a dynamic model of a Phase Lock Loop. [sociallocker][/sociallocker]