Author Archives: dougaj4

More Lowlands

Posted on 21/05/2018 by dougaj4

Sometimes YouTube suggestions are hopeless, and sometimes they are spot on.  Here is one of the latter: It seems that Ali Darragh is yet to be deemed Wiki-worthy, but there is a good article about her here. That link led … Continue reading →

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

Office Insiders and Power Pivot

Posted on 20/05/2018 by dougaj4

I recently discovered another benefit of the Office Insiders program through the ExcelUnplugged blog, which has a feature on the new linked data types in Excel.  More on those another day, but in addition to JavaScript UDFs, the added feature that I found to … Continue reading →

Posted in Computing - general, Excel, Javascript | Tagged , , , | Leave a comment

Sorting with Python and Numpy

Posted on 19/05/2018 by dougaj4

Following the previous post, lets look at sorting functions in the Numpy library. The spreadsheet xlwNumpy links to a variety of Numpy functions, including the sorting functions described below.  The spreadsheet and associated Python code can be downloaded from: xlNumpy.zip … Continue reading →

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | 1 Comment

Sorting with VBA and Python

Posted on 16/05/2018 by dougaj4

This subject was last covered in March 2014.  I have now updated the Python code to work with xlwings, and the new version (including open source VBA and Python code) can be downloaded from: Sortfunc.zip. The previous version, linking to … Continue reading →

Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings | Tagged , , , , , | 1 Comment

Okenyo

Posted on 13/05/2018 by dougaj4

Zindzi Okenyo is an Australian actor and singer. Here is her latest video, directed by my daughter:

Posted in Bach | Tagged , , , | 1 Comment