Author Archives: dougaj4

More on Numba

Posted on 15/08/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

Concrete 2021

Posted on 29/07/2021 by dougaj4

Edit 12th August: Extended early-bird registrations are now finally closing tomorrow, Friday 13th August! Concrete 2021 (the 30th Biennial Conference of the Concrete Institute of Australia) is just around the corner, and this year will be all on-line: The virtual … Continue reading →

Posted in Concrete, Newton | Tagged , , | Leave a comment

Copying charts to a new workbook

Posted on 25/07/2021 by dougaj4

When an Excel worksheet including a chart(s) is copied to a new workbook the chart still links to the data ranges in the original workbook. Over the years I have spent a fair bit of time editing the chart ranges … Continue reading →

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

A Numpy trap – correction

Posted on 20/07/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 17/07/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