Author Archives: dougaj4

An old bridge in Palermo and pointed arches

Posted on 08/10/2014 by dougaj4

The Ponte dell’ Ammiraglio (Admiral’s Bridge) in Palermo, Sicily, built from 1125-1135 (or 1113, according to the Italian Wikipedia), is one of the oldest surviving post-Roman era arch bridges in Europe.  The bridge has been restored and surrounded by a … Continue reading →

Posted in Arch structures, Historic Bridges, Newton | Tagged , , , , | 2 Comments

ExcelPython2, Alglib and Spline-Matrix Rel 2.03

Posted on 06/10/2014 by dougaj4

Following a comment here: ExcelPython2, Alglib and Spline-Matrix update I have updated the VBA and Python code, and added a missing Python module to the download zip file.  See the earlier post for details of installation and use, or download the revised files … Continue reading →

Posted in AlgLib, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | Leave a comment

Waterspout off Taormina

Posted on 04/10/2014 by dougaj4

Staying at the Sicilian resort town of Taormina, I have just observed the waterspout shown below: Read all about waterspouts at Wikipedia.

Posted in Newton | Tagged , | Leave a comment

Bruton Town – A very old story

Posted on 03/10/2014 by dougaj4

Bruton Town is an English Folk song featured on The Pentangle’s first album (the first LP I ever bought).  It tells the story of a young woman whose lover is murdered by her two brothers, because they do not think … Continue reading →

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

Binary functions, combining text, and finding unique columns

Posted on 30/09/2014 by dougaj4

I recently had an e-mail request asking for a method of finding unique columns in an Excel table consisting of either blank cells or an entry of 1.  An easy way to do this would be to convert the columns to … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 1 Comment