Author Archives: dougaj4

Transferring large arrays with Pyxll

Posted on 05/01/2019 by dougaj4

Pyxll is a commercial Excel add-in linking Excel and Python.  The latest version  offers greatly improved performance in transferring data between Excel and Python as Numpy arrays, amongst many other new features and improvements. To check what this means in practice, … Continue reading →

Posted in Arrays, Excel, Frame Analysis, Link to Python, PyXLL, UDFs, VBA | Tagged , , , , , , | Leave a comment

Scarborough Fair

Posted on 31/12/2018 by dougaj4

Scarborough Fair is a very old song, according to Wikipedia dating back at least to 1670, and probably much earlier.  Here are three versions from the mid-sixties. The first from Martin Carthy was released in 1965, on his first album: The … Continue reading →

Posted in Bach | Tagged , , , | 2 Comments

More updates to ArcSpline and IP2

Posted on 27/12/2018 by dougaj4

I have uploaded version 2.18 of the IP2 spreadsheet to: IP2.zip The new version includes updates to the IP, IP_4, and ArcSpline functions, as described below.  The download is free and includes full open-source code. The IP and IP_4 functions find … Continue reading →

Posted in Arrays, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 2 Comments

More SciPy Solvers

Posted on 19/12/2018 by dougaj4

The xlwings Scipy spreadsheet has been updated with a new example of the xl_SolveF function, that uses the Scipy Optimize root function.  The new spreadsheet can be downloaded from: xlScipy3.zip The new example uses a python function ic_calc (included in the … Continue reading →

Posted in Excel, Link to Python, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | Leave a comment

Solid Air – Norma Waterson

Posted on 13/12/2018 by dougaj4

I don’t know how I missed this, but I just discovered yesterday: More about the album: The Very Thought of You On her second solo album the Grande Dame of British folk is presenting us with a surprising, inspired selection … Continue reading →

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