Tag Archives: SciPy

Listing Python modules and getting help docs from Excel

Posted on 12/05/2022 by dougaj4

Python functions include detailed help documentation but to access this you need the full path to the function, including the names of all code modules and submodules. This post looks at how this information can be found using Excel with … Continue reading →

Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | Leave a 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

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 Python optional arguments from Excel with pyxll

Posted on 14/01/2021 by dougaj4

Python functions allow optional arguments to be specified by allocating a default value to each optional argument. The pyxll add-in allows Python functions called from Excel to work in the same way, so any argument with a default value may … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , | 1 Comment