Category Archives: Animation

Animations from VBA

A convenient way to create an animation in Excel is to create on-sheet formulas or user defined functions to generate the required data, then use VBA to iterate through the range of input values so that the chart or image … Continue reading

Posted in Animation, Excel, Link to Python, Maths, Newton, PyXLL, UDFs, VBA | Tagged , , , , , | Leave a comment

Building dances to an earthquake’s beat

Adam Pascale from the Seismology Research Centre recently shared this animation (click on controls bottom right for High Quality and Full Screen views): … it’s from a building in the Philippines about 130km (hypocentral distance) from a magnitude 6.1 earthquake … Continue reading

Posted in Animation, Computing - general, Newton | Tagged , | Leave a comment

Dancing Pendulums Revisited

I have previously posted on Dynamically Defined Dancing Pendulums, using the Strand7 FEA program to generate the motion of a series of pendulums of varying length.  I have now updated that video using the latest Beta version of the program (Rel … Continue reading

Posted in Animation, Finite Element Analysis, Frame Analysis, Newton, Strand7 | Tagged , , , , , | Leave a comment

Arcs and arc-splines

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single  arc, or a series of arcs connected (if necessary) by straight lines.  The new version may be downloaded from: As an example … Continue reading

Posted in Animation, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 1 Comment

A Loopy Link (and three more)

For some reason Doug Glancy’s Excel Blog has escaped my attention up till now, but having a browse today, I discovered this loopy animation: which would not have been out of place in Douglas Hofstadter’s “I am a Strange Loop” I really … Continue reading

Posted in Animation, Computing - general, Excel, Maths, Newton, VBA | Tagged , , , , , | 2 Comments