### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Gaussian Quadrature
- Cubic Splines
- Fitting high order polynomials
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Newton's Cradle

### Recent Comments

dougaj4 on 3D plots with the latest … 3D plots with the la… on 3D Matplotlib Plots in Ex… Suelio Josileissu on 3D plots with the latest … Installing Python an… on SectionProperties update 3 Dan & naD | Newt… on The Daily Mail Song dougaj4 on ULS Design Functions 2.13 Alvin on ULS Design Functions 2.13 Larry Schuster on Microsoft blocking VBA in down… dougaj4 on Downloads Sunny on Downloads dougaj4 on Section Properties with MeshPY… Alex on Section Properties with MeshPY… Alex on Section Properties with MeshPY… Installing PyPardiso… on Installing PyPardiso and speed… Installing PyPardiso… on Making Finite Element Analysis…

# Tag Archives: polynomial 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

## Linest, NPV, IRR and solving polynomials

In a comment on Using LINEST for non-linear curve fitting Lori Miller posted a formula that found the coefficients fitting a cubic polynomial curve to a set of data, then solved the resulting equation to find the X value for a given … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, IRR, Jenkins-Traub, NPV, polynomial solution, UDF, VBA
3 Comments