# Tag Archives: Brents method

## Brent’s Method and a daft engineer’s blog

Browsing links on Brent’s Method I found: Daft Engineer – Numerical Methods and Excel* which is well worth a look (plenty of stuff on statistics and Python, with the odd dash of Excel).  The link has VBA code for a … Continue reading

## Solving non-linear equations with two or more unknowns – 1

Newton’s Method is a well known iterative solution for non-linear equations with one unknown.  That is, if some value Y depends on a variable X, then we can use Newton’s Method to find X for any given value of Y.  … Continue reading

Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA | | 2 Comments

## Faster Biaxial Bending

The spreadsheet to calculate ultimate moment capacity of a reinforced or prestressed concrete section under combined axial load and biaxial bending, last presented here, has been updated to use the QuadBrent solver, rather than the Excel Goal Seek function, for … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | | 1 Comment

Today’s download starts with some simple linear interpolation methods used to solve polynomial equations, leading on to more sophisticated methods using quadratic or inverse quadratic interpolation. Also included is a solver for differential equations using the Cash-Karp Method, which is … Continue reading

Today’s downloads provide a spreadsheet providing Ultimate Limit State (ULS) analysis of reinforced or prestressed concrete sections, and an iterative method for finding the depth of the Neutral Axis in a circular reinforced concrete section.  The ULS analysis spreadsheet is described at: … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | | 21 Comments