Author Archives: dougaj4

The String Family

Posted on 23/04/2020 by dougaj4

According to their web site, The String family are: A family of classically trained string players who launched their musical career by hitting the road full time from 2016 through 2018, bringing music to people around Australia. Featuring 2 cellos, … Continue reading →

Posted in Bach | Tagged , | Leave a comment

Getting near matches from a list with Python

Posted on 19/04/2020 by dougaj4

To return a list of near matches from a long list of strings would be quite difficult in VBA (unless I’m missing something), but in Python it is very simple.  Here is the code for this operation, using pyxll to … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , | Leave a comment

Dancing Pendulums Revisited

Posted on 12/04/2020 by dougaj4

I have previously posted on Dynamically Defined Dancing Pendulums, using the Strand7 FEA program to generate the motion of a series of pendulums of varying length.  I have now updated that video using the latest Beta version of the program (Rel … Continue reading →

Posted in Animation, Finite Element Analysis, Frame Analysis, Newton, Strand7 | Tagged , , , , , | Leave a comment

Stepping through Python code called from Excel

Posted on 31/03/2020 by dougaj4

Setting up your editor to allow Python code debugging for functions called from Excel can be tricky, depending on the details of your editor and linking software, but using the Visual Studio Code Editor and Pyxll, this works for me: … Continue reading →

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , | 4 Comments

More Python Traps

Posted on 30/03/2020 by dougaj4

I recently posted on some Python Traps, focussing on code where changes in the values of sub-routine arguments were not reflected in the calling routines.  The reverse can also be a problem: if an array, a, is passed to a … Continue reading →

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | Leave a comment