Category Archives: Excel

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

Downloading with Chrome

Posted on 11/06/2021 by dougaj4

I recently discovered (via a helpful comment) that clicking on any download link on this blog, when using Chrome, raised a message saying: The site ahead contains harmful programs I have now managed to get Google to agree that there … Continue reading →

Posted in Computing - general, Excel | Tagged , | Leave a comment

Using Numba with Excel and pyxll …

Posted on 30/05/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

ULS Design Functions update

Posted on 23/05/2021 by dougaj4

The ULS Design Functions spreadsheet has been updated with further changes related to the new Australian Standard for concrete structures; AS 3600-2018, and with some other fixes.  The new version can be downloaded from: ULS Design Functions.zip The changes in … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 13 Comments