Hi! Here is an improved (faster and cleaner) version of the harmonograph. The worksheet has three different areas, the physical machine (a photo of the machine build out of wood by Karl Sims), the virtual machine (which is a 2D chart with a top view of a model showing the three pendulum ends, the drawing table, and the linkage mechanism which connects pendulum #1, pendulum #2 and the pencil) and the detailed curve area.
Feel free to navigate between the three areas while the model is running. Cell M14 prints a warning if the strokes (amplitudes) of the pendulums are too large and the length of the linkage cannot accommodate the movement. In this case just reduce Amplitude #1, Amplitude #2 or both. There are a total of 100 different configurations out of which the first sixteen are created by myself and the rest of 84 are empty.
To upload a configuration, dial in the address of the configuration in “Setup #”, hit “Upload” and then click “Reset” and “Start-Pause” to run the drawing. If you want to save a configuration you’ve just created, you can change the “Setup #”, then hit “Save”.
Play with the damping time and simulation time too. Choose a small simulation time if you want to see the “virtual machine” animation well. The photos below show how the drawings for each configuration look like. Because of speed reasons, I recommend that you use versions of Excel previous to year 2007 with this particular model. Your feedback is appreciated.