This post considers several aspects about improving the speed of spreadsheets in both MS Excel 2003 and 2007. It has significant effects on animations in MS Excel. In this first part, a “stopwatch” macro is described which, when incorporated in any of calculation loop, can measure the frequency your loop is executed. In this first part of the tutorial the… Read More... "About the Speed of Spreadsheets #1"
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… Read More... "A Gated Ring Oscillator Demo – Part#2"
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.… Read More... "A Gated Ring Oscillator Demo – Part#1"
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… Read More... "An Interactive Gated Ring Oscillator Tutorial – part #4"
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… Read More... "An Interactive Gated Ring Oscillator Tutorial – part #3"
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 section is mainly concerned with the generation of the spin buttons, the macros assigned to them and the insertion of the worksheet functions modeling the NAND gate, the inverters and the delayless multiplexer. Towards the end of the… Read More... "An Interactive Gated Ring Oscillator Tutorial – part #2"
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. Like most of the models on this site this model will run fine in newer Excel versions too. A delay based model was used for the logic gates which was previously discussed. An Interactive Ring Oscillator… Read More... "An Interactive Gated Ring Oscillator Tutorial – part #1"
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. The model proves to be fast and reliable and it is actually fairly easy to create. For maintaining good speed no user defined functions have been used here. Modeling Logic Gates with Delay- Part#2 by… Read More... "A Delay Based Animated Excel Model for Single-Stage Logic Gates – part#2"
After learning how to model ideal logic gates in MS Excel 2003 it is time to attemp to create a delay based model. This first model is just a theoretical presentation about delay, how it can be explained and how it can be modeled with a minimum amount of formulas while keeping a reasonable precision. The presentation focuses on the… Read More... "A Delay Based Animated Excel Model for Single-Stage Logic Gates – part#1"
This is the third part of a tutorial about modeling logic gates in MS Excel 2003. This first model includes no delay or loading for the gates. This section creates user defined functions for each gate and uses these functions to upgrade the model. An auxiliary macro is created which measures the speed of the model in iterations/second. The model with… Read More... "Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#3"
This is the second part of a tutorial targeted at modeling logic gates in MS Excel 2003. The first part introduced the basic logic gates,, symbols and associated logic equations. This model includes no delay or loading for the gates. The following type of gates will are described: inverter, AND, NAND, OR, NOR, XOR (exclusive or) and XNOR. The tutorial has several parts… Read More... "Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#2"
This is the first part of a tutorial (self, 2, 3) about modeling logic gates in MS Excel 2003. This first model will include no delay or loading for the gates. The following type of gates will be described: inverter, AND, NAND, OR, NOR, XOR (exclusive or) and XNOR. The tutorial will have several parts and the last part will build up… Read More... "Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#1"
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"