This is an Excel animation and an engineering model of a Buck voltage switching regulator. Excel 2003 was used. Besides real time control of common parameters such as switch ON resistance, load current, load capacitance, output voltage (vout), input voltage (vbat) etc, the user can also run very specialized tests in which the output current and “vbat” can be modulated
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). This Excel animation is pretty much the same as in the first model, a virtual joystick controls the number of stages in the ring by horizontal movement and it can also control the RC delay
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 in Excel. It is controlled by a virtual joystick which is generated using a chart with a macro assigned to it. To start the model click the red dot within the joystick chart.
This is the fourth part of tutorial about making an interactive animated Excel model of a gated ring oscillator in MS Excel 2003. This section adds a joystick to the model which smoothly adjusts the RC delay constant (vertical movement) and the number of delay stages within the ring (horizontal movement). An additional function of the joystick is to control the gating
This is the third part of tutorial about making an interactive animated Excel model of a gated ring oscillator in MS Excel 2003. This section deals with upgrading the model from a static table based one (with only 800 time steps) to a hybrid static-dynamic which is reasonably fast, yet it can run for an indefinite number of time
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]
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
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
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
A Phase-Locked Loop is a type of electronic circuit. It generates an oscillation with the same frequency as a reference oscillation and a relatively constant phase difference with respect to the same reference. The applications spectrum of such a circuit are extremely wide. Signal modulation, demodulation, detection and filtering, frequency conversion and synthesis are just a fraction of what this circuit can do.
Hi there, this is a tutorial explaining the construction of a very basic Lissajous emulator in Excel. It’s supposed to be very easy to understand at the high school level. Good luck, George [sociallocker][/sociallocker] A Lissajous emulator in Excel by George Lungu Introduction: Jules A. Lissajous was a French mathematician from the 19th century – He wanted to visualize
This is a static Lissajous emulator in the sense that the waveform is obtained by combining 2 static sinusoidal waves with different frequencies. As a parenthesis, I will be preparing a dynamic version which will look just like the wave shape seen on a real oscilloscope. The file presented here has two different worksheets, the first one contains a classic 2D