Category Archives: UDFs

More on Numba

Posted on August 15, 2021 by dougaj4

Following my recent post Making Finite Element Analysis go faster … I have been having a closer look at the options in the Numba just-in-time compiler for improving the performance of Python code. The Numba docs include a series of short … Continue reading →

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

A Numpy trap – correction

Posted on July 20, 2021 by dougaj4

In my post of 30th May this year (here) I said that: As a check that the functions were working correctly, the Python functions were modified to return the sum of the largest array in the first row, revealing that … Continue reading →

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

On long and short formulas and VBA

Posted on July 17, 2021 by dougaj4

A recent thread at Eng-Tips asked the following apparently simple question: Starting with a string consisting of numbers with a single central group of letters, how can this string be truncated at the end of the letters, so that for … Continue reading →

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

ULS Design Functions 2.13

Posted on July 11, 2021 by dougaj4

I have uploaded another update to the ULS Design Functions spreadsheet with some new features and fixes.  The new version can be downloaded from: ULS Design Functions.zip The changes in the new version are: Stress block type 3 will now … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | Leave a comment

Using Numba with Excel and pyxll …

Posted on May 30, 2021 by dougaj4

… and a Numpy trap. I last looked at using the just-in-time compiler Numba with Python some time ago (Two Timers), but I was prompted to take another look by an article in Medium that claimed Python Can Be Faster … Continue reading →

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