Author Archives: dougaj4

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

3D Frame Update

Posted on 29/04/2021 by dougaj4

Following a comment here I have updated the code for the 3DFrame spreadsheet to calculate shear deflections correctly for sections with a different shear area for each transverse principal axis. The updated files can be downloaded from: 3DFrame.zip A note … Continue reading →

Posted in Excel, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | 2 Comments

Elastic Biaxial Bending

Posted on 11/04/2021 by dougaj4

Spreadsheets performing Ultimate Limit State analysis with biaxial moments have been presented previously, most recently here: Biaxial bending update I have now modified the Beam Design Functions spreadsheet to carry out a biaxial moment analysis with linear elastic material properties. … Continue reading →

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

Floating Point Precision Problems

Posted on 05/04/2021 by dougaj4

A question on Quora : prompted me to look at how these numbers are handled in Excel, in VBA called from Excel, and in Python called from Excel via pyxll. The results are shown in the screenshot below: Column A … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , | 1 Comment

Raining on the Rock

Posted on 25/03/2021 by dougaj4

Raining on the Rock is the name of a song by John Williamson; released in 1987, it was recently re-released with a new video: It is also what happened at Uluru this week:

Posted in Bach | Tagged , , | Leave a comment