Dancing Pendulums

This animation was produced in response to a video of real pendulums performing similar tricks:

Not having an animation program I thought I’d use the finite element program Strand7.  Modelling the pendulums was easy, just 15 beam elements with a “translational mass” attribute on the end (more on the exact length of each pendulum later).

Strand7 Pendulum Model

Strand7 will perform a dynamic analysis, so I could have given each pendulum a displacement and then carried out the analysis of their movements over 90 seconds, but because I was only interested in generating the patterns in this case I decided to take the easy way out and generate the pendulum movement by inputting the displacements directly.  The procedure was:

  • Set up 30 “freedom cases”, each with the lower end of a different pendulum given a unit deflection in the X or Y direction
  • Set up a series of 1800 increments, corresponding to time steps of 1/20 second, and factor each freedom case to replicate the pendulum motions.
  • Run the analysis
  • Create an animation of the resulting pendulum motions, using an end on view as in the original video

The only remaining problem was how to enter 1800 x 30 factors quickly and accurately.  The solution (naturally) was to set up a table of the X and Y displacements of each pendulum in Excel:

Freedom case factor table

These factors were then transferred into Strand7 using the program’s API (the use of which I will describe in more detail in later posts).

The only remaining detail was to find the correct pendulum lengths to generate the patterns I was after.  After a little experimentation it became clear that each pendulum much have a different integer number of cycles over some fixed period.  I fixed the first pendulum length at 350 mm, which has a period of 1.187 seconds, or 51 cycles over 60.558 seconds.  The other pendulum lengths were then adjusted to have 52 to 65 cycles over the same time period, giving a range from 336.7 mm to 215.5 mm.

This entry was posted in Animation, Excel, Finite Element Analysis, Newton and tagged , , , . Bookmark the permalink.

5 Responses to Dancing Pendulums

  1. Pingback: Automating Repetitive Tasks in Excel | Chandoo.org - Learn Microsoft Excel Online

  2. Pingback: 4 Year Report | Newton Excel Bach, not (just) an Excel Blog

  3. Pingback: Daily Download 9: Animation in Excel | Newton Excel Bach, not (just) an Excel Blog

  4. I am actually delighted to read this web site posts which includes tons of useful
    data, thanks for providing these kinds of statistics.


  5. Pingback: Excel Dancing Pendulums | Excel Hero Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.