animated electronics models in excel
This is not a tutorial but a download post for a purely animated Pseudo Random Number Generator model as a Fibonacci type Linear Feedback Shift Register in MS Excel 2003. Read More... "An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#4"
This is the third part of a tutorial (1, 2, self) describing the creation of an animated Pseudo Random Number Generator model as a Fibonacci type Linear Feedback Shift Register in MS Excel 2003. Read More... "An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#3"
This is the second part of a tutorial (1, self, 3) describing the creation of an animated Pseudo Random Number Generator model as a Fibonacci type Linear Feedback Shift Register in MS Excel 2003. This part creates a very simple table type model based on combinatorial logic rather than a sequential type based on registers. Despite of the fact that this… Read More... "An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#2"
This is the first part of a tutorial (self, 2, 3) describing the creation of an animated Pseudo Random Number Generator model as a Fibonacci type Linear Feedback Shift Register in MS Excel 2003. Read More... "An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#1"
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... "Two Lissajous Models – a video preview"
This is a video preview to the previously published RLC parallel model. [sociallocker][/sociallocker] Read More... "An RLC Parallel Resonant Circuit – video preview"
This is a video preview of an Excel animated PLL model. There is an error in the sound track: it’s Voltage Control Oscillator not Variable Control Oscillator. You can download the Excel Model or check out the series of tutorials about how to code this model from scratch here: 1, 2, 3a, 3, 4. [sociallocker][/sociallocker] Read More... "A Phase Locked Loop (PLL) Model – video preview"
This is a video preview of the Fourier transform model presented on this blog before. A tutorial explaining the creation of such a model was posted here too. [sociallocker][/sociallocker] Read More... "A Basic Fourier Transform Calculator in Excel – video preview"
This part of the tutorial demonstrates the Fourier transform operation in a few cases of periodic and non-periodic signals, such as an AM signal, an FM signal, a rectangular non repetitive signal and a cardinal sine signal. The last slide contains an application to the scaling property of the Fourier transform on a non-repetitive time signal. It actually shows that… Read More... "Spectral Analysis – a Fourier transform tutorial – part #5"
The previous sections explains 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 non-periodic signals. [sociallocker][/sociallocker] A Fourier Transform Model in Excel, part #4 by George Lungu – This is a tutorial about the implementation of… Read More... "Spectral Analysis – a Fourier transform tutorial – part #4"
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] A Fourier Transform Model in Excel #3 by George Lungu – This is a tutorial about… Read More... "Spectral Analysis – a Fourier transform tutorial – part #3"
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] A Fourier Transform Model in Excel #2 by George Lungu – This is… Read More... "Spectral Analysis – a Fourier transform tutorial – part #2"
This is a basic tutorial about implementation of a standard Fourier transform model in Excel. It is not an introduction to Fourier analysis. 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… Read More... "Spectral Analysis – a Fourier transform tutorial – part #1"
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 -This is the continuation of part #2 of the PLL tutorial. The previous… Read More... "How to Model a Phase-Locked Loop (PLL) in Excel – part#4"