Author Archives: dougaj4

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

JavaScript UDFs in Excel

Posted on 09/05/2018 by dougaj4

Bleeping Computer report that Microsoft have announced JavaScript UDFs for Excel. See the link for more details. This feature is not yet available in standard Excel, but a preview version is available to those joining the Office Insiders Program.

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