#### Creating Shapes on a 2D Scatter Chart

10/01/2010

This post shows you how to draw a closed polygon (in this case a triangle for simplicity) on a 2D scatter plot in Excel 2003. 1. For this you need to sketch what you want to draw on a paper or just create a mental visualization. 2. In this sketch you need to define the vertices (corners) of the shape and figure out the approximate coordinates. 3. Create a table…

#### Triple Spring-Mass-Damper System

09/28/2010

This is the model of a triple spring-mass-damper system in excel. [sociallocker][/sociallocker]

#### Double Spring-Mass-Damper System

09/28/2010

This is the model of a double spring-mass-damper system in excel. [sociallocker][/sociallocker]

#### Simple Spring-Mass-Damper System

09/28/2010

This is the model of a simple spring-mass-damper system in excel. [sociallocker][/sociallocker]

#### Phase Lock Loop (PLL)

09/28/2010

This is an Excel workbook containing a dynamic model of a Phase Lock Loop. [sociallocker][/sociallocker]

#### Basic Planetary Simulator

09/27/2010

This is an Excel workbook containing a dynamic model of a basic binary planetary system. [sociallocker][/sociallocker]

#### Basic 3D-2D (Perspective) Visualization

09/27/2010

The first two worksheets of this Excel workbook illustrate the creation and display of a rectangle by using a 2D scatter plot. They also show how to adjust its size, translate and rotate it. In the third worksheet a wire-frame cube is created. 3D-2D persective calculations are done. The cube can be zoomed and it can also be rotated in azimuth and altitude using simple macros. [sociallocker][/sociallocker]

#### Fourier Transform

09/24/2010

This is an Excel workbook calculating the Fourier transform of a signal. [sociallocker][/sociallocker]

#### Roller Coaster

A roller coaster in Exel 2003 in 3-dimension (perspective view). To start de ride after download, click the little sun icon in the NE corner of the chart. Most of the calculations are done in the spreadsheet with very little VBA as a “glue”. The display is created on a plain 2D scatter plot. [sociallocker][/sociallocker]

09/20/2010

#### Pendulum

09/20/2010

This is a basic pendulum model in Excel. Enjoy! [sociallocker][/sociallocker] This is an animated Excel model of a pendulum that you can download here. For fast modeling speed, please use older versions of excel (1997-2003). In the following section, background information about pendulums in general will be presented: Pendulum meaning, a simple pendulum definition, what is a pendulum? A pendulum is an oscillatory device made up of a concentrated weight…