Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- AS 3600 public comment draft and py_RC Design
- Buckling of columns with varying cross section
- The history of the theory of beam bending - Part 1
- Reinforced concrete elastic analysis; Circular section
- Downloads
- Biaxial bending update
- Reinforced Concrete Section Analysis - 5; Ultimate Limit State
- Reinforced Concrete Section Analysis - 1
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Reinforced Concrete Section Analysis - with prestress
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