## How to Model a Basic 2-body Planetary System

Here is a tutorial explaining how to model a two dimensional  2-body planetary system in Excel. It uses the Euler method of integration. The tutorial starts with explaining the simple Newtonian laws acting on the two planets. There are essentially just two forces acting on each body at any time: the inertia and the gravitational attraction. During each small time step,Continue Reading

## Tutorial – a Static Lissajous Emulator

Hi there, this is a tutorial explaining the construction of a very basic Lissajous emulator in Excel. It’s supposed to be very easy to understand at the high school level. Good luck, George [sociallocker][/sociallocker] A Lissajous emulator in Excel by George Lungu   Introduction: Jules A. Lissajous was a French mathematician from the 19th century – He wanted to visualizeContinue Reading

## RLC-Parallel

This RLC parallel circuit model has several sound effects so it must be dearchived in the same subdirectory. [sociallocker][/sociallocker]Continue Reading

## 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 EquationsContinue Reading

## 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 DifferenceContinue Reading

## 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 (likeContinue Reading

## 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]Continue Reading

## 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 2DContinue Reading

## Triple Spring-Mass-Damper System

This is the model of a triple spring-mass-damper system in excel. [sociallocker][/sociallocker]Continue Reading

## Double Spring-Mass-Damper System

This is an animated model of a double spring-mass-damper system in excel. [sociallocker][/sociallocker]Continue Reading

## Simple Spring-Mass-Damper System

This is the model of a simple spring-mass-damper system in excel. [sociallocker][/sociallocker]Continue Reading

## Basic Planetary Simulator

This is an Excel workbook containing a dynamic model of a basic binary planetary system. [sociallocker][/sociallocker]Continue Reading

## Fourier Transform

This is an Excel workbook calculating the Fourier transform of a signal. [sociallocker][/sociallocker]Continue Reading

## Pendulum

This is a basic pendulum model in Excel. Enjoy! [sociallocker][/sociallocker] This is an animated Excel model of a pendulum that you can download here. For fast modeling speed, please use older versions of excel (1997-2003). In the following section, background information about pendulums in general will be presented: Pendulum meaning, a simple pendulum definition, what is a pendulum? A pendulumContinue Reading