The file

pyLinAlgfuncs3.zip

has open source Python code allowing the Scipy linear algebra functions to be called from Excel using the pyxll add-in. It also includes all the Python code to perform LU decomposition, as discussed in the previous post., and a spreadsheet with examples of all the available functions.

The spreadsheet has 64 functions, listed on the first sheet:

The solver functions are demonstrated solving a stiffness matrix representing a small structural frame:

The first 10 rows of the solution to the matrix for the example loading are presented for a wide range of different functions:

The problem presented in the previous post is also included, with the associated python code:

Future post will look at the use of the different solver functions in more detail.