Recent Comments
Author Archives: dougaj4
The Concrete Institute of Australia – Golden Jubilee
The Concrete Institute of Australia will celebrate 50 years in 2020. The Institute was originally formed when members of the Australia Prestressed Concrete Group proposed a change in 1968 where it was resolved to adopt the name Concrete Institute of … Continue reading
The String Family
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
Getting near matches from a list with Python
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 close matches, Excel, Python, PyXLL, UDFs, using Excel function wizard
Leave a comment
Dancing Pendulums Revisited
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 avi, dynamic analysis, mp4, Pendulum animation, Snagit, Strand7
Leave a comment
Stepping through Python code called from Excel
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 Debugging, Excel, Python, PyXLL, Visual studio code
4 Comments
