Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- About Newton Excel Bach
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Tag Archives: Polynomial 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