Category Archives: PyXLL

Solving cubic equations – background and timing

Posted on October 25, 2022 by dougaj4

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 , , , , , , , , , | Leave a comment

Working with Python polynomials from Excel

Posted on October 22, 2022 by dougaj4

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 , , , , , , , , , | Leave a comment

3D plots with the latest Matplotlib

Posted on September 30, 2022 by dougaj4

Installing Python on a new computer, I found I had to downgrade Matplotlib to release 3.5.2 to get my 3D plotting functions to work. Further investigation found that the problem was the Axes3D function. Changing:     ax = axes3d.Axes3D(fig)to: … Continue reading →

Posted in Animation, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | 2 Comments

Installing Python and pyxll from scratch

Posted on September 26, 2022 by dougaj4

Updated 28th September 2022. Matplotlib latest version OK. I recently installed Python and pyxll (plus the required additional libraries) on a new computer, which raised a few problems with incompatible versions, so here is a summary of what worked (as … Continue reading →

Posted in Animation, Arrays, Charts, Coordinate Geometry, Differential Equations, Excel, Finite Element Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, PyXLL, UDFs | Tagged , , , , , , , , , , , , , , | Leave a comment

Installing PyPardiso and speed of Scipy spsolve

Posted on June 12, 2022 by dougaj4

I recently upgraded to Python 3.10, and because of some problems with my previous installation I decided to do a complete new installation using pip, which required installation of all the libraries needed for my various programs. For my linear … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | 1 Comment