Category Archives: Animation

Animations from VBA

Posted on November 28, 2021 by dougaj4

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

Posted on May 28, 2020 by dougaj4

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

Posted on April 12, 2020 by dougaj4

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

Posted on August 17, 2018 by dougaj4

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: IP2.zip 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)

Posted on August 23, 2015 by dougaj4

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