Author Archives: dougaj4

ExcelPython2, Alglib and Spline-Matrix update

The ExcelPython add-in, offering easy access to Python code from Excel VBA, has had a major update to Release 2.  The new version provides new features and simpler installation, but has some incompatibilities with code written for the previous  version, so the … Continue reading

Posted in AlgLib, Excel, Link to Python, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 4 Comments

More from June Tabor and Eric Bogle

No Man’s Land: Well how do you do, young Willie McBride,Do you mind if I sit here down by your graveside And rest for a while ‘neath the warm summer sun I’ve been working all day and I’m nearly done. … Continue reading

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

Extending complex UDFs with simple VBA

One of the advantages of writing spreadsheet applications in the form of User Defined Functions (UDFs) is that the UDF may be used on the spreadsheet in the same way as a built-in function, allowing applications to be modified and extended … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA | 3 Comments

John Howard, an Apology, and Long Lost

John Howard is a well known Australian actor.  There is also an Australian ex-Prime Minister by the name of John Howard, but we are not concerned with that one here. In 2000 John Howard (playing the part of an actor … Continue reading

Posted in Bach, Films | Leave a comment

The Band Played Waltzing Matilda – June Tabor

Folk singer June Tabor is as far as I’m aware the first artist to record Eric Bogle’s The Band Played Waltzing Matilda. This is in my opinion the definitive version. We are supposed to learn from our mistakes but never … Continue reading

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