Author Archives: dougaj4

Malinda sings A Song About Nothing

Posted on June 18, 2019

Malinda Kathleen Reese mostly sings popular songs, after passing the lyrics through Google Translate multiple times. But this is something else:

Posted in Bach | Tagged , , | Leave a comment

ULS design of circular reinforced concrete columns

Posted on June 9, 2019

The RC Design Functions spreadsheet has been updated (to Version 8.04) with the addition of a CircU function for ULS design of circular reinforced concrete sections under combined bending and axial load.  The new version, including full open-source code, may … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , , , , , , | Leave a comment

ULS Design Functions – update for AS 3600

Posted on May 28, 2019

The ULS Design Functions spreadsheet (last posted here) has been updated to the new Australian Standard for concrete structures; AS 3600-2018.  The new version can be downloaded from: ULS Design Functions.zip Note that the biaxial version included in the download … Continue reading →

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

Working with dynamic arrays in Excel

Posted on May 23, 2019

Many of the VBA functions available here return results as arrays, which must be entered by selecting the desired output range, then  pressing Ctrl-Shift-Enter (CSE).  This can be inconvenient (or at least untidy) when the size of the output array varies.  … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | Leave a comment

The Barrow Poets

Posted on May 11, 2019

The Barrow Poets  (according to this site) started out selling poems from barrows in the late 1950s, then moved into performing in pubs.  I saw them performing in London, probably in 1972.  In spite of their undoubted originality and creativity, … Continue reading →

Posted in Bach | Tagged , , , , | Leave a comment

How Reinforced Earth works

Posted on May 8, 2019

“Reinforced Earth” is the name of  a construction system widely used in retaining walls around the World.  Here is a short video demonstrating how the system works, which is both informative and entertaining:

Posted in Newton | Tagged , , , | 1 Comment

RC Design Functions 8_03

Posted on April 30, 2019

The RC Design Functions 8_03 spreadsheet is now available for free download from: RC Design Functions8.zip The main changes are: The NA layer check has been corrected for compression steel in tension The new AS 3600 crack width and curvature … Continue reading →

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