Dynamic Macros #1

November 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…

Read More >>

RLC-Parallel

November 28, 2010

This RLC parallel circuit model has several sound effects so it must be dearchived in the same subdirectory. Recommending this site to your friends would be highly appreciated.   Thanks for your support!

Read More >>

Resizing, Translating and Rotating Shapes in Excel

November 15, 2010

Five different shape alterations are presented: 1. Resizing – which can be done independently on each axis by multiplying the coordinates by a certain factor while the shape is centered in the origin. 2. Translation – which can be done independently on each axis by adding or subtracting a term to each coordinate. 3. Simple rotation – formulas were derived for rotation of a shape centered in origin by a…

Read More >>

Introduction to Numerical Methods – Basic Filters #2

November 9, 2010

This post shows the steps for building a first model of a single pole RC high pass filter (HPF) in Excel based on numerical solution using the finite difference method. It is quite elemetary to undersand, try to go through the proof regardless of your background. Recommending this site to your friends would be highly appreciated.   Thanks for your support!

Read More >>

Static VBA Macros

November 2, 2010

Most parameters used in animations or physical models are changed by buttons called “spin buttons”. Excel is a spreadsheet but behind the table there is a engine used to automate certain spreadsheet functions. This engine can be programmed in a language with a very easy syntax called Visual Basic for Applications, in short VBA. VBA is a very convenient feature in Excel and it can be used almost without any…

Read More >>