Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- Smart Indenter and Excel 2013
- Buckling of columns with varying cross section
- Converting from global to local coordinates (and vice versa)
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Biaxial bending update
Recent Comments
Tag Archives: IRR
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