Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Intersections, interpolations, and rotations
- Linestgap with data in rows
- Frame Analysis with Excel - 3, Continuous beam or frame
- Working with units in Excel - using VBA and Python
- Combining text files
- Installing Python, Scipy and Pyxll
- About Newton Excel Bach
- Using LINEST for non-linear curve fitting
- The angle between two vectors, in 2D or 3D
- ALGLIB linear and polynomial fitting functions
Recent Comments
Tag Archives: solve simultaneous equations
VBA polynomial functions update
Following several comments at an old post I have made updates to the Polynomial spreadsheet. The new files can be downloaded from: Polynomial.zip The changes are: New functions returning real roots only: Updated SolvePoly and SolvePolyR: SolvePoly with an array … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, high order simultaneous equations, Link to Python, Numpy, Polynomial equations, PyXLL, solve simultaneous equations, UDFs
Leave a comment
Solving polynomials – update
The polynomial spreadsheet (details here) provides functions to solve polynomial equations of any order; using an “exact” method for up to quartic, and an iterative procedure for higher orders. The input for the functions requires the equation coefficients to be … Continue reading
Posted in Arrays, Excel, Maths, UDFs, VBA
Tagged Excel, high order simultaneous equations, Polynomial equations, solve simultaneous equations, UDF, VBA
15 Comments