Tag Archives: iterative solution

Solving the Lagrangian Point equation for the Moon

Posted on June 23, 2019 by

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 , , , , , , | 3 Comments

Brent’s Method; Update and Examples

Posted on December 6, 2017 by

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 , , , , , , | 1 Comment

The Inverse Quadratic Method 3 – Brent’s Method

Posted on April 13, 2010 by

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 , , , , , | 12 Comments