### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Column buckling under multiple loads
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Fitting high order polynomials

### Recent Comments

Column buckling unde… on Using Frame4Buckle with the Al… Column buckling unde… on Buckling of columns with varyi… dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho… dougaj4 on P-Y Curve function Zhitong Zhang on P-Y Curve function Matt Cornell on Newton’s Cradle Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin… Roulior Halder on Excel to Alglib via xlwin…

# Tag Archives: Brents method

## More iterative solvers

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 Brents method, depth of neutral axis, Excel, Python, Reinforced Concrete, SciPy, UDFs, VBA, xlwings
Leave a comment

## Iterative solvers and arrays

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 Brents method, Excel, Python, SciPy, UDFs, VBA, xlwings, xlwSciPy3
2 Comments

## Brent’s Method; Update and Examples

Has the free software at this site saved you time and/or money? If so, please contribute to the Raw Impact charity group providing practical help to poor communities in Cambodia: Everydayhero – Cambodia 2018 All contributions gratefully accepted. Contributions are … Continue reading

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Excel, inverse quadratic, iterative solution, Maths, UDF, VBA
1 Comment

## 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
Tagged Brents method, Excel, moment curvature, Newton's Method, non-linear equations, two or more unknowns, UDF, 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
Tagged biaxial bending, Brents method, Combined bending and axial load, Excel, Prestressed concrete, Reinforced Concrete, UDF, ultimate moment capacity, VBA
1 Comment

## Daily Download 21: Assorted Solvers

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