Author Archives: dougaj4

Working with dynamic arrays in Excel

Posted on 23/05/2019 by dougaj4

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 11/05/2019 by dougaj4

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 , , , , | 1 Comment

How Reinforced Earth works

Posted on 08/05/2019 by dougaj4

“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 30/04/2019 by dougaj4

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 , , , , , , , | 11 Comments

The Largest Early World Map …

Posted on 25/04/2019 by dougaj4

… is unveiled for the first time: Click image for link to map with pan and zoom: On July 25, 01585, near the end of a century of unprecedented change, four Japanese boys stopped in Milan on their way back … Continue reading →

Posted in Newton | Tagged , | 2 Comments