Category Archives: Link to Python

Mastan2

Posted on 26/08/2023 by dougaj4

Mastan2 is a free frame analysis program based on Matlab. The linked site provides alternative downloads for those with or without Matlab installed. The site also provides a link to the book Matrix Structural Analysis, 2nd Edition, by McGuire, Gallagher, … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7 | Tagged , , , , , , , | 1 Comment

3DFrame-py

Posted on 05/07/2023 by dougaj4

My 3DFrame spreadsheet has now been converted to Python code and can be downloaded from: 3DFrame-py.zip The frame analysis uses the Scipy linear algebra functions called from pyLinalgfuncs3, which must be available on the Python path: pyLinAlgfuncs3.zip The 3DFrame-py download … Continue reading →

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

Speed of Scipy Linear Algebra Solvers

Posted on 14/06/2023 by dougaj4

The files presented in the recent post on Scipy Linear Algebra Solvers include a wide range of different solver types, with in some cases numerous sub-options, allowing the functions to be called from Excel, and greatly extending and speeding up … Continue reading →

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

Scipy linear algebra functions in Excel

Posted on 30/05/2023 by dougaj4

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., … Continue reading →

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

LU Decomposition with Python and Scipy

Posted on 26/05/2023 by dougaj4

This post was prompted by a question at the Eng-Tips forum: LU Decomposition which asked why Mathcad was generating LU matrices different to those calculated from the basic theory. The short answer was that there is more than one way … Continue reading →

Posted in Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | 2 Comments