Author Archives: dougaj4

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

Calculating and plotting rotations

Posted on 19/06/2023 by dougaj4

This post was prompted by a recent post at Eng-Tips. The original problem seemed simple enough: Im trying to wirte a formula where I imput vessel heading and datum bore heading and it tells me FWD, STBD, AFT or PORT … Continue reading →

Posted in Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA | Tagged , , , , , , | Leave a comment