Tag Archives: Brents method

More on combined shear and bending design to AS 3600

Posted on December 15, 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

Newton-Raphson and Brent’s Method – Solver examples

Posted on November 8, 2020 by dougaj4

I recently discovered the Computing Skillset site (via open-struct-engineer), which has good information on the basis and use of the Newton-Raphson method: The Newton Raphson method explained, details, pictures, python code Highly instructive examples for the Newton Raphson method I … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

More iterative solvers

Posted on October 28, 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

Iterative solvers and arrays

Posted on October 21, 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

Brent’s Method; Update and Examples

Posted on December 6, 2017 by dougaj4

Brent’s Method is a refinement of Newton’s Method for the numerical solution of any equation with one variable.  The User Defined Function (UDF) QuadBrent was described in:  The Inverse Quadratic Method 3 – Brent’s Method Following a recent question, I have … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 4 Comments