Author Archives: dougaj4

Concrete 2023

Posted on 15/08/2023 by dougaj4

The Concrete Institute of Australia’s biennial conference is almost upon us. This year it is being held in Sydney from 10-13 September. CONCRETE 2023 Look below at what’s in store at Concrete 2023.   Keynote and Invited Speakers We have … Continue reading →

Posted in Concrete, Newton | Tagged , , | Leave a comment

Bert Jansch, Sounds of the 70’s

Posted on 06/08/2023 by dougaj4

There have been quite a few new old Bert Jansch recordings posted to YouTube over the past year, including: Bert Jansch: A Man and his Songs, pt 1From a Danish TV film broadcast in 1976. 0:00 Lost And Gone (from … Continue reading →

Posted in Bach | Tagged , , | Leave a comment

Dynamic charts

Posted on 23/07/2023 by dougaj4

A frequently asked question is how to get Excel charts to automatically update when new data is added outside the original selected ranges. The most frequent recommendation (such as here) is to convert the data to a table, then insert … Continue reading →

Posted in Charts, Charts, Concrete, Excel, UDFs | Tagged , , , , , | Leave a comment

Simplified bi-axial bending

Posted on 13/07/2023 by dougaj4

This post summarises my responses to a question at Eng-Tips. The UK concrete standard in use before Eurocode 2 (BS 8110) has a simple procedure for designing columns subject to bending about both principal axes: This allows the column to … Continue reading →

Posted in Excel | Leave a comment

3DFrame-py

Posted on 05/07/2023 by dougaj4

My 3DFrame spreadsheet has now been converted to Python code and can be downloaded from: 3DFrame-py.zip The frame analysis uses the Scipy linear algebra functions called from pyLinalgfuncs3, which must be available on the Python path: pyLinAlgfuncs3.zip The 3DFrame-py download … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, VBA | Tagged , , , , , , , | 3 Comments