Simple Spring-Mass-Damper System
2010-09-28
This is the model of a simple spring-mass-damper system in excel. [sociallocker][/sociallocker]Continue Reading
Phase Lock Loop (PLL)
2010-09-28
This is an Excel workbook containing a dynamic model of a Phase Lock Loop. [sociallocker][/sociallocker]Continue Reading
Basic Planetary Simulator
2010-09-27
This is an Excel workbook containing a dynamic model of a basic binary planetary system. [sociallocker][/sociallocker]Continue Reading
Basic 3D-2D (Perspective) Visualization
2010-09-27
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 perspective calculations are done. The cube can be zoomed and it can also be rotated inContinue Reading
Fourier Transform
2010-09-24
This is an Excel workbook calculating the Fourier transform of a signal. [sociallocker][/sociallocker]Continue Reading
Animated Roller Coaster in Excel
2010-09-20
A roller coaster in Excel 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]Continue Reading
Pendulum
2010-09-20
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 pendulumContinue Reading