### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Gaussian Quadrature
- Cubic Splines
- Fitting high order polynomials
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Newton's Cradle

### Recent Comments

dougaj4 on 3D plots with the latest … 3D plots with the la… on 3D Matplotlib Plots in Ex… Suelio Josileissu on 3D plots with the latest … Installing Python an… on SectionProperties update 3 Dan & naD | Newt… on The Daily Mail Song dougaj4 on ULS Design Functions 2.13 Alvin on ULS Design Functions 2.13 Larry Schuster on Microsoft blocking VBA in down… dougaj4 on Downloads Sunny on Downloads dougaj4 on Section Properties with MeshPY… Alex on Section Properties with MeshPY… Alex on Section Properties with MeshPY… Installing PyPardiso… on Installing PyPardiso and speed… Installing PyPardiso… on Making Finite Element Analysis…

# Tag Archives: Quadratic

## Solving Quadratic, Cubic, Quartic and higher order equations; examples

A previous post presented a spreadsheet with functions for solving cubic and quartic equations, and this has been extended with another function solving higher order polynomials. The functions are actually very easy to use, but the documentation in the spreadsheets is quite brief, … Continue reading

Posted in Arrays, Excel, Link to Python, Maths, Newton, UDFs, VBA
Tagged Cubic, Excel, Higher order polynomials, Jenkins-Traub, Python, Quadratic, Quartic, solving polynomials, UDF, VBA
12 Comments

## 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

## Daily Download 19: Solving polynomials

Today’s download provides analytic solutions to polynomial equations up to fourth order (that is quadratic, cubic and quartic equations) and an iterative method to solve equations of higher order. All these functions are found in the download file: http://interactiveds.com.au/software/Polynomial.zip The … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Evaluate polynomial, Excel, Jenkins-Traub, Quadratic, Quartic, Solve polynomial, UDF, VBA
1 Comment

## Solving cubic and quartic equations with Excel

Although in earlier posts (such as this one) I have referred to some User Defined Functions (UDFs) for solving cubic and quartic equations, I just realised recently that I haven’t actually talked about them here, and since they are in … Continue reading

## Linking Excel to Fortran – 2

In this post the procedures described for C++ here will be replicated for Fortran: The spreadsheet, fortran source code, and compiled dll described in this code may be downloaded from Cubic.zip As always, it is better to use the downloaded code, … Continue reading

Posted in Excel, Fortran, Link to dll, Maths, UDFs, Uncategorized, VBA
Tagged Cubic, Excel, Fortran, Quadratic, UDF, VBA
23 Comments