Author Archives: dougaj4

Tanh-Sinh Quadrature v. 5.03

Posted on 22/11/2021 by dougaj4

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 , , , | 5 Comments

Some new old songs

Posted on 14/11/2021 by dougaj4

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

Posted on 04/11/2021 by dougaj4

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 , , , , , , | 1 Comment

… is so meta, even this acronym …

Posted on 29/10/2021 by dougaj4

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

Installing PyPardiso

Posted on 24/10/2021 by dougaj4

Update 5th June 2022: The PyPardiso package may now be installed simply with pip (see Installing PyPardiso and speed of Scipy spsolve): Install the MKL library: pip install mkl Install PyPardiso: pip install pypardiso The PyPardiso package provides an interface to … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | 1 Comment