Author Archives: dougaj4

Indexing NumPy arrays with floats …

Posted on 01/04/2017 by dougaj4

… now you can’t. I recently updated to the latest version of NumPy (1.12.1), and today I discovered that some of my spreadsheets using NumPy arrays (via xlwings) were returning errors like: IndexError: only integers, slices (`:`), ellipsis (`…`), numpy.newaxis … Continue reading →

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

Formatting Text from VBA

Posted on 30/03/2017 by dougaj4

In a recent Eng-Tips thread someone wanted a VBA routine to combine a value with different + and – tolerance values, formatted as superscript and subscript.  Eng-Tips (and Tek-Tips) regular, Skip Vought, came up with a macro to do the job, … Continue reading →

Posted in Excel, VBA | Tagged , , , | Leave a comment

Birdland – Kerinne Jenkins

Posted on 24/03/2017 by dougaj4

Birdland Films was created by Kerinne Jenkins in 2017, as a home for her own work across a number of platforms, but more importantly as a starting point. To establish a place where other like minded filmmakers, creatives and artists … Continue reading →

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

Birdland – Patti Smith

Posted on 21/03/2017 by dougaj4

Horses is the debut album by American musician Patti Smith, released in 1975 on Arista Records. The record was a key factor and major influence on the New York punk rock scene. At the time she recorded Horses, Patti Smith … Continue reading →

Posted in Bach | Tagged , , , | 1 Comment

Extracting numbers from text – update

Posted on 11/03/2017 by dougaj4

I have previously posted a spreadsheet with user defined functions (UDFs) using regular expressions to extract numbers from a text string (see Extracting numbers from text and regular expressions). I have now modified the Extractnums function to optionally return the numbers … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , | 2 Comments