#### A 2D Animated Excel Roller Coaster – video preview

This is a video preview for the 3D animated roller coaster previously presented on this blog. A tutorial on this topic will be posted later.

Skip to content
# Excel Unusual

## Science, Engineering, Games in Excel

#
simulation

#### A 2D Animated Excel Roller Coaster – video preview

This is a video preview for the 3D animated roller coaster previously presented on this blog. A tutorial on this topic will be posted later.

Read More >>
#### Casual Introduction to Numerical Methods – spring-mass-damper system model – part#5

Read More >>
#### Casual Introduction to Numerical Methods – spring-mass-damper system model – part#4

Read More >>
#### Casual Introduction to Numerical Methods – a spring-mass-damper system model – part#3

Read More >>
#### Casual Introduction to Numerical Methods – a spring-mass-damper system model – part#2

Read More >>
#### Casual Introduction to Numerical Methods – a spring-mass-damper system model – part#1

Read More >>
#### Dynamic Macros #1

Read More >>
#### Triple Spring-Mass-Damper System

Read More >>
#### Roller Coaster

Read More >>

In this tutorial, most of the calculations for the numerical simulation a SMD (spring-mas-damper) system will be consolidated into a single formula, the coordinate formula. In this case, in order to calculate the coordinate at the end of a any time step, we will need just the coordinates from the previous two time steps and of course the input parameters (constants). These input parameters are: mass, damping ratio, spring constant and time…

This tutorial explains the principles to generating animation for the spring-mass-damper system analyzed in the previous presentations.

Here is the third part of a tutorial in both elementary dynamics and numerical methods. It is written at a basic level and it shows you how to set up a dynamic model for numerical solving of simple differential equations. The dynamic model makes use of an infinite loop, which make the calculations advance in time. Instead of a large table with formulas, this time we have a small number of…

Here is the second part of a tutorial in both elementary dynamics and numerical methods. It is written at a basic level and it shows you how to solve a system of difference equations in an Excel table. It also starts to explain how to animate the model.

Here is the first part of a casual tutorial in both elementary dynamics and numerical methods. It is written at a very basic level and it shows you how to solve a system of difference equations with a pencil and a paper and perhaps a pocket calculator to speed things up.

Hi everybody, Today we’ll talk about dynamic macros very useful in engineering modeling, scientific modeling, games etc. Dynamic macros are created using two different type of loops: “For” and “Do”. – Two different but equivalent conditional “Do” loops are explored. – It is shown that macros can be assigned to drawing shapes, pictures, graph, etc. – A highly valuable Run/Pause macro is described and implemented. The reader must pay close attention…

This is the model of a triple spring-mass-damper system in excel. Recommending this site to your friends would be highly appreciated. Thanks for your support!

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.