Spectral Analysis – a Fourier transform tutorial – part #5

April 8, 2011

This part of the tutorial demonstrates the Fourier transform operation in a few cases of periodic and aperiodic signals, such as an AM signal, an FM signal, a rectangular nonrepetitive signal and a cardinal sinus signal. The last slide contains an application to the scaling property of the Fourier transform on a nonrepetitive time signal. It actually shows that spreading a signal in the time domain shrinks its spectrum and…

Read More >>

A basic 3-body Planetary System

December 24, 2010

Hi folks, as a continuation to the previous tutorial here is a 3-body planetary model where the solution to the equations is contained in a static form, as a lookup table (I previously called it a “pure spreadsheet solution”). The model is static in the sense that after any parameter is changed, the solution data remains unchanged in a table until a new parameter is updated by the user. The display is dynamic however since an “Offset()” function…

Read More >>

How to Model a Basic 2-body Planetary System

December 23, 2010

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 newtonial 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, from the distance between bodies we can calculate the gravitational…

Read More >>

Tutorial – a Static Lissajous Emulator

December 11, 2010

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 Recommending this site to your friends would be highly appreciated.   Thanks for your support!

Read More >>

Dynamic Lissajous Emulator

October 1, 2010

This is a dynamic Lissajous emulator in the sense that the waveform is obtained by combining 2 time varying sinusoidal waves with different frequencies. Recommending this site to your friends would be highly appreciated.   Thanks for your support!

Read More >>

Static Lissajous Emulators (2D and 3D)

September 29, 2010

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 paranthesis, 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 Lissajous figure and the second one has a 3D Lissajous pattern obtained from three different…

Read More >>