### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Beam actions and deflections by Macaulay's Method
- Cubic Splines
- The Conjugate Beam Method
- Using Goal Seek on Multiple Cells
- Frame Analysis with Excel - 4, 2D frame analysis
- Elegant proofs 4 - The optimum shape of an arch
- Two new functions for IP.xls
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- What is VBA good for? ...

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

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