## Animated Asynchronous Electric Motor Model in MS Excel

This is an animation of an asynchronous electric motor in Microsoft Excel. You can download the model by clicking on the icon below and trying to run it. What is an electric motor and how does an electric motor work? An electric motor is part of a larger class of devices known as electric machines. In order to define anContinue Reading

## Power Management: An Animated Buck Switching Regulator Model in MS Excel 2003

This is an Excel animation and an engineering model of a Buck voltage switching regulator. Excel 2003 was used. Besides real time control of  common parameters such as switch ON resistance, load current, load capacitance, output voltage (vout), input voltage (vbat) etc, the user can also run very specialized tests in which the output current and “vbat” can be modulatedContinue Reading

## A 3D 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. [sociallocker]>[/sociallocker]Continue Reading

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

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). TheseContinue Reading

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

This tutorial explains the principles to generating animation for the spring-mass-damper system analyzed in the previous presentations. [sociallocker][/sociallocker] A casual approach to numerical modeling – part #4 – a Spring-Mass-Damper-System – creating the animation by George Lungu – We are trying to generate animation for the system sketched above knowing the deviation from the equilibrium function of time. This deviation isContinue Reading

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

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 tableContinue Reading

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

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] A casual approach to numerical modeling – the Spring-Mass-Damper System – part 2.Continue Reading

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

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. A casual approach to numerical modeling – the Spring-Mass-Damper-System –Continue Reading

## Dynamic Macros #1

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 macroContinue Reading

## Triple Spring-Mass-Damper System

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

## Double Spring-Mass-Damper System

This is an animated model of a double spring-mass-damper system in excel. [sociallocker][/sociallocker]Continue Reading

## Simple Spring-Mass-Damper System

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

## Animated Roller Coaster in Excel

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