### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Deflections and Moments in Rectangular Plates
- Latex Maths Text in Excel
- Downloads by category
- Using conditional formatting with array formulas
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- P-Y Curve function

### Recent Comments

# Tag Archives: iterative solution

## Solving the Lagrangian Point equation for the Moon

This post was prompted by a recent question at Fitting high order polynomials, asking for Excel methods to solve the equations for the radius of the Moon’s Lagrangian Point 1. All the methods described in this post have been added to … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, iterative solution, Lagrangian point, Newton, polynomial solution, UDFs, VBA
3 Comments

## Brent’s Method; Update and Examples

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 Brents method, Excel, inverse quadratic, iterative solution, Maths, UDF, VBA
4 Comments

## The Inverse Quadratic Method 3 – Brent’s Method

The previous post in this series presented iterative methods to solve polynomial equations using direct or inverse quadratic interpolation. These methods have two disadvantages: In some circumstances the function may converge very slowly, or not at all. The name of … Continue reading

Posted in Excel, Maths, UDFs, VBA
Tagged Excel, inverse quadratic, iterative solution, Maths, UDF, VBA
12 Comments