Tag Archives: Python

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

More on Numba

Posted on 15/08/2021 by dougaj4

Following my recent post Making Finite Element Analysis go faster … I have been having a closer look at the options in the Numba just-in-time compiler for improving the performance of Python code. The Numba docs include a series of short … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

A Numpy trap – correction

Posted on 20/07/2021 by dougaj4

In my post of 30th May this year (here) I said that: As a check that the functions were working correctly, the Python functions were modified to return the sum of the largest array in the first row, revealing that … Continue reading →

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | Leave a comment

Making Finite Element Analysis go faster …

Posted on 27/06/2021 by dougaj4

… with Numba and Scipy sparse matrix functions. As promised in the previous post in this series, I will be looking at speeding up the formation and solving of matrix functions for the analysis of structural frames, using Excel and … Continue reading →

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

Using Numba with Excel and pyxll …

Posted on 30/05/2021 by dougaj4

… and a Numpy trap. I last looked at using the just-in-time compiler Numba with Python some time ago (Two Timers), but I was prompted to take another look by an article in Medium that claimed Python Can Be Faster … Continue reading →

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , | 2 Comments