#### About the Speed of Spreadsheets #2

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.

Skip to content
# Excel Unusual

## Science, Engineering, Games in Excel

#
Tutorials

#### About the Speed of Spreadsheets #2

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.

Read More >>
#### About the Speed of Spreadsheets #1

Read More >>
#### An Interactive Gated Ring Oscillator Tutorial – part #4

Read More >>
#### An Interactive Gated Ring Oscillator Tutorial – part #3

Read More >>
#### An Interactive Gated Ring Oscillator Tutorial – part #2

Read More >>
#### An Interactive Gated Ring Oscillator Tutorial – part #1

Read More >>
#### A Delay Based Animated Excel Model for Single-Stage Logic Gates – part#2

Read More >>
#### A Delay Based Animated Excel Model for Single-Stage Logic Gates – part#1

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

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

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

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

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

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

Read More >>
#### A Basic Planetary System – video preview

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

Read More >>
#### Longitudinal Aircraft Dynamics #10 – implementing the numerical method

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

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

Read More >>

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

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 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 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.

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.

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.

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.

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.

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.

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

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.

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.

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