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 in Excel and it can be used almost without any…


Introduction to Numerical Methods – Basic Filters #1


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]


Creating Shapes on a 2D Scatter Chart


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…