### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Commenting a block of code in VBA
- Downloads by category
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Problems with UCase and LCase in VBA
- The angle between two vectors, Python version
- Drawing in Excel 7 - Creating drawings from coordinates

### Recent Comments

dougaj4 on The Conjugate Beam Method William Harvey on The Conjugate Beam Method dougaj4 on ConbeamU 4.10 dougaj4 on ConbeamU 4.10 Jérémie on ConbeamU 4.10 Francisco Rossier on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Alan Elston on Worksheetfunction.Transpose… Alan on Worksheetfunction.Transpose… Francisco Rossier on Using LINEST for non-linear cu… dougaj4 on Worksheetfunction.Transpose… dougaj4 on Worksheetfunction.Transpose… Francisco Rossier on Using LINEST for non-linear cu… 3D Frame analyses wi… on ConBeamU 4.05 and ConBeampy… 3D Frame analyses wi… on 3DFrame with spring relea…

# Tag Archives: Polynomial

## Python for VBA users – 5; Using built in numpy functions

Previous Python Post In previous posts in this series I have looked at translating VBA functions to solve quadratic and cubic equations, but the Python numpy library has a polyroots function that will solve polynomials of any degree, and will … Continue reading

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged complex numbers, Cubic, Excel, high order polynomials, Jenkins-Traub Method, Polynomial, Python, PyXLL, Quadratic, Quartic, UDF, VBA
5 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
11 Comments

## Complex Numbers and Solving Quartic Polynomial Equations

It was recently pointed out to me that the User Defined Function (UDF) for solving quartic polynomial equations presented in this post returned an error for some input values. In tracking down the source of the error I decided that it … Continue reading

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Cubic, Excel, Polynomial, Quartic, UDF, VBA
2 Comments

## Approximate Solutions of Polynomial Equations

Following on from the previous post, this post presents a number of methods of solving polynomial equations using approximate iterative methods in Excel. Similar methods can be used to find solutions to any other equation that can be evaluated numerically. … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Excel, Newton-Raphson Method, Polynomial, Quartic, UDA, VBA
3 Comments

## Reinforced Concrete Section Analysis – 4

Previous post The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis: For a cross section with any applied axial load at eccentricity e, measured from … Continue reading

Posted in Beam Bending, Excel, Newton, UDFs, Uncategorized
Tagged Polynomial, Reinforced Concrete, Section Analysis, UDF, VBA
1 Comment

## Reinforced Concrete Section Analysis – 3

Previous post -1 Previous post -2 The theory presented in the previous 2 posts in this series has been incorporated into an Excel UDF, allowing concrete and reinforcement stresses and strains to be evaluated quickly and easily for reinforced and … Continue reading

Posted in Beam Bending, Excel, Newton, UDFs
Tagged Cubic, Plot Shapes, Polynomial, Quadratic, Quartic, Reinforced Concrete, Section Analysis, UDF, VBA
8 Comments