Author Archives: dougaj4

Two songs = 2/3 Wikipedia

Posted on 06/06/2018 by dougaj4

It is said that a picture is worth a 1000 words. On the same basis, a poem is worth 1000 pictures, and a song is worth 1000 poems. So two songs are worth 2 billion words, which is about 2/3 … Continue reading →

Posted in Bach | Tagged , , | 3 Comments

New Links – 2018

Posted on 03/06/2018 by dougaj4

Some new links to active Excel related blogs: David Hagar has been active in the Excel community for many years, and has published the Excel For You blog since 2013.  I was led to it by a recent post on a UDF … Continue reading →

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

Returning Arrays From VBA and Python

Posted on 01/06/2018 by dougaj4

Most  of the  user defined functions (UDFs) presented on this blog return a multi-cell array, that must be entered by selecting the output range then pressing Ctrl-shift-enter to display all the results.  This process has several inconveniencies: You need to know … Continue reading →

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

More Numpy with Excel and xlwings

Posted on 24/05/2018 by dougaj4

The spreadsheet presented in the last post on sorting also includes links to many other Numpy functions.  The spreadsheet and associated Python file can be downloaded from: xlNumpy.zip The Numpy functions require xlwings and Numpy to be installed, which are included in … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , , , , | 2 Comments

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