Author Archives: dougaj4

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

Lift Humour

Posted on 15/08/2013 by dougaj4

I recently received an e-mail link to this comedy sketch set in a voice recognition lift in Scotland: which reminded me of this Woody Allen sketch from nearly 50 years ago: It seems that neither voice recognition technology nor humour … Continue reading →

Posted in Bach | Tagged , , | 1 Comment