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

03/01/2012

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”

06/30/2011

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. [sociallocker][/sociallocker]

#### A Basic Planetary System – video preview

06/20/2011

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. [sociallocker][/sociallocker]

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

06/06/2011

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

#### Longitudinal Aircraft Dynamics #10 – implementing the numerical method

06/05/2011

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. [sociallocker][/sociallocker]

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

06/04/2011

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. [sociallocker][/sociallocker]

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

06/03/2011

This section continues the worksheet implementation of the dynamics formulas for aerodynamic forces and momenta. [sociallocker][/sociallocker]

#### Longitudinal Aircraft Dynamics #7 – worksheet implementation of the dynamics equations (b)

06/02/2011

This section continues the  worksheet implementation of the dynamics formulas. [sociallocker][/sociallocker]

#### Longitudinal Aircraft Dynamics #6 – worksheet implementation of the dynamics equations (a)

06/01/2011

In this section, the parameters cl, cd and cm are scaled back to the force of lift, drag and the pitching moment of the aircraft. After that, the numerical  modeling scheme is described together with the macros behind it. At the end, the formulas for the angles of attack of the wing and the horizontal stabilizer are introduced. [sociallocker][/sociallocker]

#### Moment of Force and Torque Calculation

05/31/2011

This is an addition to a previous post, introducing the reader to different ways of calculating the moment of a force and the torque of a couple. This information will be useful in aircraft dynamics models.