#### Animated Asynchronous Electric Motor Model in Excel

This is an animation of an asynchronous electric motor in Microsoft Excel. You can download the model by clicking on the icon below and try to run it.

#### Power Management: An Animated Buck Switching Regulator Model in Excel 2003

This is an animated model of a Buck voltage switching regulator in MS Excel 2003.

#### A Gated Ring Oscillator Demo – Part#2

This is an upgrade from the first part in the sense that it can be adjusted to have more delay based inverters in the feedback (14).

#### A Gated Ring Oscillator Demo – Part#1

An interactive animated demo of the gated ring oscillator in Excel 2003 based on the previous tutorial. This model stands out because of the real time schematic animation.

#### An Interactive Gated Ring Oscillator Tutorial – part #4

This is the fourth part of tutorial about making an interactive animated Excel model of a gated ring oscillator in MS Excel 2003.

#### An Interactive Gated Ring Oscillator Tutorial – part #3

This is the third part of tutorial about making an interactive animated Excel model of a gated ring oscillator in MS Excel 2003.

#### An Interactive Gated Ring Oscillator Tutorial – part #2

This is the second part of tutorial walking through the creation of an interactive animated Excel model of a gated ring oscillator in MS Excel 2003.

#### An Interactive Gated Ring Oscillator Tutorial – part #1

This is the first part of tutorial explaining how to make an interactive animated Excel model of a gated ring oscillator in MS Excel 2003.

#### A Delay Based Animated Excel Model for Single-Stage Logic Gates – part#2

This is the second half of the delay based Excel model tutorial. In this part the final formulas are derived and implemented in Excel 2003.

#### A Delay Based Animated Excel Model for Single-Stage Logic Gates – part#1

After learning how to model ideal logic gates in MS Excel 2003 it is time to attemp to create a delay based model.

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

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

This is a video preview to the previously published RLC parallel model.

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

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.

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

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.

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

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

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

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