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

06/18/2011

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

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

02/22/2011

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…

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

02/21/2011

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

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

02/05/2011

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…

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

02/04/2011

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

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

02/03/2011

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.

#### Dynamic Macros #1

11/30/2010

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…

#### 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]