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"
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 easy to understand, try to go through the proof regardless of your background. [sociallocker][/sociallocker] Basic Filters – Part 1 (1-Pole Low Pass Filter) – Numerical Solutions to Differential Equations (Finite Difference… Read More... "Introduction to Numerical Methods – Basic Filters #1"
3-Body Planetary System with Options
Here is a 3-body system with 3D graphics. This model works at about 30 frames/second in Excel 2003 on a modern PC. In Excel 2007 it will run 10-15 times slower. I know 2010 is a lot faster than 2007. I need to add few more features. I am also thinking of adding a 3D gravitational surface map later (like… Read More... "3-Body Planetary System with Options"
Drafting an RC Flying Wing in Excel
Hello everyone, I’ve been into flying wings since 2000 when I bought a Zagi online. As piloting style I can compare a flying wing to a snowboard ->> COOL. After abusing it greatly, I ended up mounting a couple of small Russian Norvel glow engines on it and eventually I had to bury it, since it became a pack of crumpled styrofoam. In 2005 I built another wing out of packaging tape… Read More... "Drafting an RC Flying Wing in Excel"
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… Read More... "Creating Shapes on a 2D Scatter Chart"
Dynamic Lissajous Emulator
This is a dynamic Lissajous emulator in the sense that the waveform is obtained by combining 2 time varying sinusoidal waves with different frequencies. [sociallocker][/sociallocker] Read More... "Dynamic Lissajous Emulator"
Static Lissajous Emulators (2D and 3D)
This is a static Lissajous emulator in the sense that the waveform is obtained by combining 2 static sinusoidal waves with different frequencies. As a parenthesis, I will be preparing a dynamic version which will look just like the wave shape seen on a real oscilloscope. The file presented here has two different worksheets, the first one contains a classic 2D… Read More... "Static Lissajous Emulators (2D and 3D)"
Triple Spring-Mass-Damper System
This is the model of a triple spring-mass-damper system in excel. [sociallocker][/sociallocker] Read More... "Triple Spring-Mass-Damper System"
Double Spring-Mass-Damper System
This is an animated model of a double spring-mass-damper system in excel. [sociallocker][/sociallocker] Read More... "Double Spring-Mass-Damper System"
Simple Spring-Mass-Damper System
This is the model of a simple spring-mass-damper system in excel. [sociallocker][/sociallocker] Read More... "Simple Spring-Mass-Damper System"
Phase Lock Loop (PLL)
This is an Excel workbook containing a dynamic model of a Phase Lock Loop. [sociallocker][/sociallocker] Read More... "Phase Lock Loop (PLL)"
Basic Planetary Simulator
This is an Excel workbook containing a dynamic model of a basic binary planetary system. [sociallocker][/sociallocker] Read More... "Basic Planetary Simulator"