Author Archives: dougaj4

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

More new old recordings

Posted on 29/06/2023 by dougaj4

There have been quite a few old Pentangle and Bert Jansch recordings posted on YouTube in recent months. BBC The Genius of Bert Jansch Folk Blues and Beyond, from 2014. Interviews and archive footage weave together performances from a concert … Continue reading →

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