Author Archives: dougaj4

AS 3600 and RC Design Functions 8.01

Posted on 13/11/2018 by dougaj4

The updated RC Design Functions spreadsheet (presented here) included an updated UMom function to find the ultimate strength of a rectangular section under combined bending and axial load; but I omitted to include the revisions to the alpha2 and Gamma … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Falling feathers and hammers

Posted on 09/11/2018 by dougaj4

It is well known that at the end of the Apollo 15 Moon landing, Commander David Scott dropped a hammer and a feather to demonstrate that they would accelerate at the  same rate, and land on the ground together: What is … Continue reading →

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

More iterative solvers

Posted on 28/10/2018 by dougaj4

Following the recent post on using Brent’s Method solvers on an array (Iterative solvers and arrays), here is another example with an engineering related problem.  The example is included in the xlScipy3 spreadsheet, which can be downloaded from: xlScipy3.zip The depth … Continue reading →

Posted in Arrays, Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , , | Leave a comment

Quite Good

Posted on 26/10/2018 by dougaj4

This song has actually appeared here before, but it was a bit buried, so here it is again; Robin Williamson with a quite good interpretation of Like a Rolling Stone:    

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

Iterative solvers and arrays

Posted on 21/10/2018 by dougaj4

A recent thread at Eng-Tips was looking for a solution to the problem described  below: The solutions to this problem described below can be downloaded from: ItSolve.zip and xlScipy3.zip The ItSolve.xlsb spreadsheet contains a user defined function (UDF) to solve iterative … Continue reading →

Posted in Arrays, Charts, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | 2 Comments