## Modeling atomic diffusion and polymerization – coding an Excel animated model

part#1 part#2 part#3 part#4Continue Reading

Science, Engineering, Games in Excel & VBA

Primary Navigation Menu

2017-01-07

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

2012-03-22

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

2011-06-18

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

2011-02-22

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

2011-02-21

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

2011-02-05

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

2011-02-04

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

2011-02-03

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

2010-11-30

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

2010-09-28

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

2010-09-28

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

2010-09-28

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

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