Static VBA Macros

11/02/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 >>

Introduction to Numerical Methods – Basic Filters #1

10/22/2010

This post shows the steps for building a first model of a single pole RC low pass filter (LPF) 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. [sociallocker][/sociallocker]

Read More >>

Creating Shapes on a 2D Scatter Chart

10/01/2010

This post shows you how to draw a closed polygon (in this case a triangle for simplicity) on a 2D scatter plot in Excel 2003. 1. For this you need to sketch what you want to draw on a paper or just create a mental visualization. 2. In this sketch you need to define the vertices (corners) of the shape and figure out the approximate coordinates. 3. Create a table…

Read More >>