Author Archives: dougaj4

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

Tanh-Sinh Quadrature v. 5.03

Following some recent comments Graeme Dennes has released the latest version the Tanh-Sinh Quadrature spreadsheet with some corrections to the test function documentation. The new file is located (as before) at: Tanh-Sinh Quadrature For more information on the last major release … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , | 4 Comments

Some new old songs

Every so often I check YouTube to see what new old music has been posted, and today I found: Haitian Fight Song, here played by Danny Thompson in Norway in 1968 and Bert Jansch and Danny Thompson playing Thames Lighterman … Continue reading

Posted in Bach | Tagged , , , | Leave a comment

Using Matplotlib from Excel with pyxll

The pyxll documentation has many examples of plotting in Excel using Matplotlib and other packages, but I find the multiple options confusing and hard to follow, so this post works through the examples in the Matplotlib Users Guide tutorial. The … Continue reading

Posted in Charts, Charts, Drawing, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

… is so meta, even this acronym …

Today it was announced that Facebook, the meta company that owns Facebook, was going to be renamed “Meta”, which reminded me of an xkcd episode from 10 years ago:

Posted in Bach, Newton | Tagged , , , , | Leave a comment