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.
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).
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.
This is the fourth part of tutorial about making an interactive animated Excel model of a gated ring oscillator in MS Excel 2003.
This is the third part of tutorial about making an interactive animated Excel model of a gated ring oscillator in MS Excel 2003.
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.
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.
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.
After learning how to model ideal logic gates in MS Excel 2003 it is time to attemp to create a delay based model.
This is a video preview for two older models included in this blog, a static model and a dynamic model.
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.
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.
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.
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.
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.
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.