Author Archives: dougaj4

Martin Simpson and Danny Thompson (1/47 from Graham Bell’s Danny Thompson collection)

Posted on 09/09/2013 by dougaj4

A variant of the traditional song Matty Groves, Little Musgrave tells the story of a young man paying the price for a brief tryst with a noble woman. This version recorded live at the Oxford Folk Festival of 2008 features … Continue reading →

Posted in Bach | Tagged , , , , | 4 Comments

Installing Python, Scipy and Pyxll

Posted on 09/09/2013 by dougaj4

I have recently been experimenting with Pyxll, which after a few initial hiccoughs is proving to be an easy and efficient way to connect Excel to Python based scientific and maths applications, such as linear algebra routines and ODE solvers.  … Continue reading →

Posted in Excel, Link to dll, Link to Python | Tagged , , , , | 15 Comments

Arrays vs Collections vs Dictionary Objects (and Dictionary help)

Posted on 29/08/2013 by dougaj4

A recent comment by Lori Miller at Daily Dose of Excel suggested that (for the particular application being discussed) the VBA Collection object was quicker than using scripting dictionaries.  Since I hardly ever use collections (other than the built-in ones), and … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , , | 7 Comments

Running VBA routines from a new workbook

Posted on 21/08/2013 by dougaj4

I have had a couple of queries recently which seem to be resulting from trying to run User Defined Functions (UDFs) from a new workbook, so this post will look at the options for using the VBA routines provided here (or … Continue reading →

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

Deletionists vs Inclusionists

Posted on 19/08/2013 by dougaj4

Port Macquarie is a small Australian coastal town just up the road from me (360 km, according to Google), which has a fairly undistinguished Presbyterian Church: This church used to have its own article in Wikipedia, but the Wikipedia deletionists … Continue reading →

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