Category Archives: Excel

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

ULS Design Functions 2.13

Posted on 11/07/2021 by dougaj4

Update 17 May 2022: Following discussion on 10-11 May 22 the download file has been updated to version 2.15, fixing problems with the interaction diagram with a rectangular stress block under high axial loads. I have uploaded another update to … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 25 Comments

Making Finite Element Analysis go faster …

Posted on 27/06/2021 by dougaj4

… with Numba and Scipy sparse matrix functions. As promised in the previous post in this series, I will be looking at speeding up the formation and solving of matrix functions for the analysis of structural frames, using Excel and … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, NumPy and SciPy, PyXLL | Tagged , , , , , , , , | 4 Comments