Author Archives: dougaj4

Avoid si Aibohphobia is di ova …

Posted on 10/05/2015 by dougaj4

… which loosely translated means, if you have inherited the rare but debilitating condition known as aibohphobia, or fear of palindromes, then read no further, and don’t even think about clicking on the Vimeo video below. Since today (for those of … Continue reading →

Posted in Bach | Tagged , , | 2 Comments

xlSciPy 1.01

Posted on 05/05/2015 by dougaj4

The xlSciPy spreadsheet, introduced here, has been updated with many new functions.  The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy.  It … Continue reading →

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

Time to Lookup

Posted on 27/04/2015 by dougaj4

At Daily Dose of Excel Jeff Weir has been looking at alternative methods of applying the VLookup function and ways of getting precise timing of the different formulations. Based on his posts there I have written two Lookup User Defined … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , , | 5 Comments

John Renbourn; 1944 – 2015

Posted on 23/04/2015 by dougaj4

John Renbourn John Renbourn, who has died aged 70, was one half of the powerful guitar duo of Pentangle, the innovative jazz-folk band of the 1960s and 70s. While his fellow guitarist, Bert Jansch, brought great emotion and inventiveness to … Continue reading →

Posted in Bach | Tagged , | Leave a comment

Re-sizing Array Functions

Posted on 14/04/2015 by dougaj4

The recent updates to the ConBeamU spreadsheet contained two new functions for entering and re-sizing array functions, and since they will be useful on any spreadsheet containing array functions (which here means almost all of them) I thought they deserved … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , , | 4 Comments