This is the second post on Excel speed. The first part benchmarked the calculation speed of Excel 2003 versus Excel 2007 for various size arrays of formulas.

This post considers several aspects about improving the speed of spreadsheets in both MS Excel 2003 and 2007.

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.

Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#3

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.

Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#2

This is the second part of a tutorial targeted at modeling logic gates in MS Excel 2003.

Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#1

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.

An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#3

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.

An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#2

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.

An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#1

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.

Building a game of Tetris #1– the generation and the rotation of the “tetrominoes”

This is the first section of a tutorial about the creation of a Tetris game in Excel using mainly spreadsheet formulas and very little VBA.

A Basic Planetary System – video preview

Since not everybody has Excel and more and more people are on the dumbed down new versions (2007 and 2010) I am presenting these previews to give the readers a feel of the real speed and feel of some of the models in older Excel versions (in this case 2003). This preview refers to an older model.

Longitudinal Aircraft Dynamics #11 – full 360 degree operation – aerobatics, inverted flight and loops – FINAL

This section updates an angle formula so that the virtual glider can now perform both backward and forward loops, as well as inverted flight.

Longitudinal Aircraft Dynamics #10 – implementing the numerical method

This section of the turorial finalizes the main dynamics calculations and implements the numerical method for approximating the glider trajectory. At this point, the model is already functional but with a crude interface.

Longitudinal Aircraft Dynamics #9 – more about forces and momenta – preliminary validation and testing

This tutorial finalizes the implementation of the forces and momenta acting on the plane. It also initiates some hand testing and validation of the overall dynamics of the plane.

Longitudinal Aircraft Dynamics #8 – worksheet implementation of the dynamics equations (c)

This section continues the worksheet implementation of the dynamics formulas for aerodynamic forces and momenta.