Author Archives: dougaj4

Concrete 2021

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 conference format not only provides greatly reduced travel and accommodation costs, but also all … Continue reading

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

Copying charts to a new workbook

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

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

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

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