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"
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"
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"
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"
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"