Recent Comments
Author Archives: dougaj4
Python matrix functions in Excel, using Pyxll
Following my previous Python post I have now successfully created a number of matrix arithmetic User Defined Functions (UDFs), using Python, SciPy and the PyXll add-in: The spreadsheet and associated Python modules may be downloaded from Matrixpyxll.zip See the previous post … Continue reading
Posted in Excel
2 Comments
Martin Simpson and Danny Thompson (1/47 from Graham Bell’s Danny Thompson collection)
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 Danny Thompson, Little Musgrave, Lyrics, Martin Simpson, Matty Groves
4 Comments
Installing Python, Scipy and Pyxll
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 Anaconda, link Excel to Python, Python, PyXLL, SciPy
15 Comments
Arrays vs Collections vs Dictionary Objects (and Dictionary help)
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 Collection, Excel, performance, Scripting dictionary, VBA
7 Comments
Running VBA routines from a new workbook
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
