Author Archives: dougaj4

SectionProperties Release 3

Posted on 21/10/2023 by dougaj4

Robbie van Leeuwen’s SectionProperties program, (last featured here) has recently been updated to Release 3 with some major changes to the code, including: Full documentation can be found at: SectionProperties docs Changes to the code have required updates to my Excel … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Link to Python, Newton, PyXLL, UDFs | Tagged , , , | Leave a comment

Happy Birthday, Sydney Opera House

Posted on 20/10/2023 by dougaj4

The book “Developments in Structural Form” by Rowland Mainstone is a history of the development of structural design over thousands of years. The very first 20th Century building structure appearing in that book is the Sydney Opera House, which was … Continue reading →

Posted in Arch structures, Bach, Concrete, Newton | Tagged , , , | Leave a comment

Longitudinal force due to shear – update

Posted on 09/10/2023 by dougaj4

In the post RC Design Functions 9.03; compression strut angle adjustment I recommended that when finding the longitudinal force due to shear according to AS 5100.5 (Amendment 1), the effect of increased vertical shear reinforcement should be limited in accordance … Continue reading →

Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs, VBA | Tagged , , , , , , , , | 1 Comment

If Not Now

Posted on 30/09/2023 by dougaj4

“This country is my home. This beautiful country, unique in all the world,” Kelly wrote in his statement on why he’s voting Yes earlier this week. “Our First Australians looked after it and shaped it for over 60,000 years and, in doing … Continue reading →

Posted in Bach | Tagged , , | Leave a comment

Counting words in a list and dictionary links

Posted on 26/09/2023 by dougaj4

This post presents two methods for extracting all the different words from a list and counting the number of occurrences of each word. The spreadsheet, including full open-source VBA code, can be downloaded from: CountWords.zip As an example, I have … Continue reading →

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