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… Read More... "Dynamic Macros #1"
RLC-Parallel
This RLC parallel circuit model has several sound effects so it must be dearchived in the same subdirectory. [sociallocker][/sociallocker] Read More... "RLC-Parallel"
Resizing, Translating and Rotating Shapes in Excel
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… Read More... "Resizing, Translating and Rotating Shapes in Excel"
Introduction to Numerical Methods – Basic Filters #2
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 elementary to understand, try to go through the proof regardless of your background. [sociallocker][/sociallocker] Basic Filters – Part 2 (1-Pole High Pass Filter) Numerical Solutions to Differential Equations… Read More... "Introduction to Numerical Methods – Basic Filters #2"
Static VBA Macros
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… Read More... "Static VBA Macros"