Author Archives: dougaj4

Which was Douglas Adams’ single best line of writing?

Posted on 05/01/2023 by dougaj4

is a question from Quora, from which my favourite of the many responses was: For many more see: https://www.quora.com/Which-was-Douglas-Adams-single-best-line-of-writing

Posted in Newton | Tagged , | Leave a comment

Downloads from the 60’s

Posted on 29/12/2022 by dougaj4

Two new download sites with some of my favourite music from the 1960’s: Bert at the BBC from bandcamp: https://bertjansch.bandcamp.com/album/bert-at-the-bbc … and for something completely different, assorted recordings from Tom Lehrer:

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

py_UMom spreadsheet and OptShearCap3600 function

Posted on 20/12/2022 by dougaj4

I have now transferred the Ultimate Limit State design functions from the VBA RC Design Functions spreadsheet to Python format. The new spreadsheet and Python code can be downloaded from: py_UMom.zip The code also includes the OptShearCap3600 function, described in … Continue reading →

Posted in Excel | 1 Comment

More on combined shear and bending design to AS 3600

Posted on 15/12/2022 by dougaj4

Further to the last post on this subject I have been looking at procedures to speed up design for shear to AS 3600 when the “refined” analysis procedure is used. The issues that need to be addressed are: I have … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 4 Comments

Latex Maths Text in Excel

Posted on 27/11/2022 by dougaj4

There have been many posts here looking at alternative ways of working with functions entered as text on a spreadsheet, and working with units, most recently here. One drawback with this approach is that text in an Excel cell must … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , | Leave a comment