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

#### An RLC Parallel Resonant Circuit – video preview

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

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

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]

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

#### 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 analyis. 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 real signal to a sampled signal having a limited number of samples.

#### 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 Out_LF In R -This is the continuation of part #2 of X the PLL tutorial. The previous part described the implementation of the…

#### 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 will be discussed in the following section. [sociallocker][/sociallocker]