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

Skip to content
# Excel Unusual

## Science, Engineering, Games in Excel

#
Analog Electronics

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

Read More >>
#### An RLC Parallel Resonant Circuit – video preview

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

Read More >>
#### Spectral Analysis – a Fourier transform tutorial – part #5

Read More >>
#### Spectral Analysis – a Fourier transform tutorial – part #4

Read More >>
#### Spectral Analysis – a Fourier transform tutorial – part #3

Read More >>
#### Spectral Analysis – a Fourier transform tutorial – part #2

Read More >>
#### Spectral Analysis – a Fourier transform tutorial – part #1

Read More >>
#### How to Model a Phase-Locked Loop (PLL) in Excel – part#4

Read More >>
#### How to Model a Phase-Locked Loop (PLL) in Excel – part#3

Read More >>

This section is dedicated to modeling electrical and electronic systems in Excel 2003 standard.

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

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]

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…

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]

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]

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]

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.

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]

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]