Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Frame Analysis with Excel
- Biaxial bending update
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Strand7 API GetNode functions
- Downloads
- Using LINEST for non-linear curve fitting
- 3DFrame - 3D Frame analysis for Excel
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Using Frame4 for truss analysis
- Frame Analysis with Excel - 4, 2D frame analysis
Recent Comments
Tag Archives: Polynomials
Solving cubic equations – background and timing
For more information on the polynomial functions, including quartic and higher order solvers, see: Solving Quadratic, Cubic, Quartic and higher order equations; examples Re-reading the Wikipedia article on solving cubic equations, I noticed that the trigonometrical solution for finding 3 real … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged cubic equations, Excel, Numba, Numpy, Polynomials, Pyhon, PyXLL, Quartic equations, UDFs, VBA
Leave a comment
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