Category Archives: NumPy and SciPy

Contour plots with Excel and Matplotlib

Posted on 28/12/2021 by dougaj4

Contour plots are widely used for a great variety of purposes, but facilities for producing them in Excel are very limited, and those that are provided are very well hidden. In this post I will look at some simple examples … Continue reading →

Posted in Arrays, Charts, Charts, Excel, Finite Element Analysis, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs | Tagged , , , , , | 1 Comment

Plotting Mandelbrot in Excel with Matplotlib

Posted on 17/12/2021 by dougaj4

The functions used in the previous post generate an array of integers, the number of iterations for the function return value to exceed 2. This post looks in more detail at how this data can be plotted in Excel using … Continue reading →

Posted in Charts, Charts, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | 1 Comment

Computing and plotting the Mandelbrot set in Excel …

Posted on 07/12/2021 by dougaj4

… with Python, Numba and pyxll. As promised in the previous post, this post will look at alternative procedures for calculating and plotting the Mandelbrot set with Python based code. The spreadsheet presented here and the associated Python code may … Continue reading →

Posted in Charts, Charts, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | 1 Comment

Installing PyPardiso

Posted on 24/10/2021 by dougaj4

Update 5th June 2022: The PyPardiso package may now be installed simply with pip (see Installing PyPardiso and speed of Scipy spsolve): Install the MKL library: pip install mkl Install PyPardiso: pip install pypardiso The PyPardiso package provides an interface to … Continue reading →

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

Making Finite Element Analysis go faster – Update and PyPardiso

Posted on 17/10/2021 by dougaj4

The previous post on this topic looked at the performance of alternative Scipy sparse equation solvers. This post updates those results with the current Scipy version (1.7.1), with very different results. It also compares the Scipy solver performance with the … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL | Tagged , , , , , , | 5 Comments