Instructables

Pendulum Art on a Spread sheet.

Picture of Pendulum Art on a Spread sheet.
What is normally done using mechanical pendulums can also be done on a spread sheet. If the spread sheet also provides the slider function, this can provide much greater controls over the various pendulum parameters.

 
Remove these adsRemove these ads by Signing Up

Step 1:

Picture of
The spreadsheet in OpenOffice does provide a working slider control which can set the value of a given cell.

Step 2:

Picture of
The slider can also be stepped by smaller units for some precision adjustments.

Step 3:

Picture of
This is a simplified mechanical pendulum simulation which graphs the X/Y points
versus time.

Step 4:

Picture of
In this case the X values has frequency, magnitude, decay, and phase parameters which follows this equation.

X = Magnitude*Exp(-time/decay_rate)*sin(2pi*frequency*time + PhaseShift*time)

Step 5:

Picture of
Of course the equations need not be limited to this simple example.

Step 6:

Picture of
The slider controls provide instance feedback as to what each parameter is doing.

Step 7:

Picture of
Both the OpenOffice and Excel version are included. The Excel version unfortunately appears to have problems getting its slider controls to work properly, at least on a MacBookPro. If you download the Openoffice version, the file's extension my need to be changed to something like "FWVEAA8FR123iEH.ods".
Light_Lab3 years ago
I built a real pendulum harmonogram when I was a kid and I tried many years ago to do the patterns in Excel. I could never get enough data sets in Excel though to make smooth lines. Nowadays In the lab we are always running out of data space with Excel so we use Origin.---- You have used a nice trick via the smooth lines function so you don't need as much data. The only problem is the curves are NQR when you get into some patterns. I one day I might try this in Origin.
dsauer (author)  Light_Lab3 years ago
You might want to check out an open source program called SCILAB. I have a cheat sheet on how to use it here. http://www.idea2ic.com/PlayWithFink/scilab_Picture/SCILAB%20Templates.html This cheat sheet includes 25 lines of cut and paste text that will do a 3D plot. So the harmonogram can be done in 3D. I have long list of things I plan to do in 3D.
Thanks for the lead seems like SCILAB is similar to MatLAB which I can get a company license for but takes some money from my budget. Looks like SCILAB is free I will definitely follow that up. Yes 3D harmonograms would be cool but don't over look the fact that you can mathematically model the vector sum of any number of pendulums in 2D or 3D; and use other functions than simple sines. Many things you cannot do with a mechanical harmonogram. BTW I once tried putting a loosely strung rubber band on one of the pendulums made a cool variation.
dsauer (author)  Light_Lab3 years ago
The mechanical harmonogram looks like it would be fun to build. Its just that the internet puts us all in touch with a lot of fun things to do. Not enough time to do them all. But it is fun to see someone else doing them as an instructable.
spiderfurby4 years ago
very clever - do you have more examples?
dsauer (author)  spiderfurby4 years ago
For some reason I can't cut and paste here. My email is  dsauersanjose@aol.com. I can always send you an email.
Paste into Windows Paint (under accessories); save as a BMP and then just use the Instructables image manager. Then you can add them to your article or emails.
32.bmp