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
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Contour plots with Excel and Matplotlib
- Cubic Splines
- Brent's Method; Update and Examples
Recent Comments
mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd… metroxx on Composite Beam Spreadsheet Upd…
Tag Archives: complex numbers
Working with Python polynomials from Excel
Python polynomial functions have several features that require manipulation of data passed from Excel: I have written 3 short Python functions to deal with passing arrays of complex numbers from and to Excel, using pyxll, or within Python code to … Continue reading
Posted in Arrays, Excel, Link to Python, PyXLL, UDFs
Tagged complex numbers, Complex to real, Excel, Numpy, Polynomials, Python, PyXLL, Real to complex, Reversing arrays, UDFs
Leave a comment
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