Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Lambda and VBA
- Cubic Splines
- Two New Functions; Let and Lambda
- Daily Download 7: Lateraly loaded pile analysis
- Downloads
Recent Comments
Lambda and VBA | New… on Two New Functions; Let and… dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a…
Tag Archives: Numerical methods
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
XNumbers and Tropical Events
My on-line friend Al Vachris recently sent me a link to the Tropical Events site, which features a detailed analysis of the orbital motion of the Earth and the other bodies of the solar system, all done in Excel, and … Continue reading
Posted in Excel, Maths, Newton, Numerical integration
Tagged Astronomy, Numerical methods, orbital mechanics, XNumbers
16 Comments
Evaluating higher order polynomials …
… and a better solution for quadratics. Having written a better solver for high order polynomials, that raises a few other issues. The error in the roots found by the RPolyJT was checked by simply substituting each root as the … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Excel, Jenkins-Traub, Numerical methods, Polynomial, UDF, VBA
4 Comments
Solving higher order polynomials
The Quartic spreadsheet presented here previously (most recently here) uses algebraic techniques to provide an “exact” solution to polynomial equations of up to fouth order. For polynomials of higher order there is no general algebraic solution, and numerical methods are … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Excel, Jenkins-Traub, Numerical methods, Polynomial, UDF, VBA
12 Comments
Numerical solutions with CSpline
The CSpline function presented in a previous post fits a series of cubic polynomial curves to a specified series of points, returning the Y values for listed intermediate X values. I was recently asked if this could be reversed to … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic spline, Excel, Numerical methods, solve equation, VBA
Leave a comment