Introduction: 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.

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_Lab (author)2010-08-22

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_Lab2010-08-22

You might want to check out an open source program called SCILAB. I have a cheat sheet on how to use it here. 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.

Light_Lab (author)dsauer2010-08-26

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_Lab2010-08-26

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.

spiderfurby (author)2010-02-08

very clever - do you have more examples?

dsauer (author)spiderfurby2010-02-10

For some reason I can't cut and paste here. My email is I can always send you an email.

Light_Lab (author)dsauer2010-08-22

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.

jordanqvo (author)2010-05-14

Cool! Help for my math class :)

rachel (author)2009-02-15

This is a really cool idea but I don't understand how you made it. Can you explain more about what kinds of numbers go where on the spreadsheet, and how to get it to display the rendering?

___ (author)rachel2009-02-20

yes it it confusing

dsauer (author)rachel2009-02-16

Step 4 shows the equation of cell G3. The "F3" term corresponds to time which is increasing such that cell G4 will have a "F4" term in its place. Anything which has a "$" term like ”$B$4" will remain constant for every cell in the "G" column. There are some really easy ways to set up relationships like this on a spreadsheet. I can make an instructable on how to do this if you like.

wobblestar (author)2009-02-16

Very clever!

About This Instructable




Bio: Have 30+ years of experiences as a Mixed Signal IC Design Engineer.
More by dsauer:Arduino BiCMOS Curve Tracer3D-tizing PhotosHandling LapTop Waveforms
Add instructable to: