### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Biaxial bending update
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Downloads by category
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials

### Recent Comments

dougaj4 on Excel to Alglib via xlwin… dougaj4 on Biaxial bending update Roulior Halder on Excel to Alglib via xlwin… Bill Harvey on Biaxial bending update Roulior Halder on Excel to Alglib via xlwin… dougaj4 on The answer to Life the Univers… Paul Halsema on The answer to Life the Univers… More powers of 3 | N… on The answer to Life the Univers… Onyia Leonard on Daily Download 4: Continuous B… The age of snakeoil… on They all laughed at Christophe… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi… Indexing pdf files,… on Indexing pdf content

# Tag Archives: complex numbers

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

## Python for VBA users – 4; Python data types

Previous Python Post The basic range of data types in Python is quite simple, but by the time we have added additional types used in the numpy package, and translation of Excel data types into the Python equivalent the picture … Continue reading

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA
Tagged complex numbers, Excel, numpy arrays, Python, Python lists, PyXLL, UDF, VBA
5 Comments

## Daily Download 13: The ALGLIB maths library and Excel

Today we move onto maths related downloads, starting with the ALGLIB maths library, which has featured here quite frequently: Original post with link to site: ALGLIB Installing AlgLib with Excel VBA Download files: http://interactiveds.com.au/software/AL-Matrix-xlsb.zip http://interactiveds.com.au/software/AL-Matrix-xls.zip Linking AlgLib C++ to Excel … Continue reading

Posted in AlgLib, Arrays, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged AlgLib, complex numbers, Cubic splines, Excel, Matrix Functions, statistics, UDF, VBA
7 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
12 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

## AlgLib Complex Number Functions

The AlgLib module ap.bas includes complex number functions which can be called from other VBA routines, but they cannot be used as User Defined Functions (UDFs) because they use the user defined data type “Complex”: To call these functions from the … Continue reading

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, complex numbers, Excel, math functions, UDF, VBA
2 Comments