Category Archives: PyXLL

3DFrame-py; with non-linear analysis

Posted on 03/11/2024 by dougaj4

Exactly a year since the previous update I have revised the 3DFrame-py spreadsheet with the addition of non-linear analysis options. The new files can be downloaded from: 3DFrame-py.zip Details of file installation, and required software are at: 3DFrame-py Minor revisions … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7, UDFs | Tagged , , , , , , , , , , , | Leave a comment

Scipy Linalg functions stopped working

Posted on 27/10/2024 by dougaj4

I recently noticed that the iterative linear algebra solvers in my pyLinAlgfuncs3.xlsb spreadsheet had stopped working. It turned out that the optional tolerance argument had been renamed ‘rtol’. Changing all the occurrences of the name in the Python code fixed … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , , | Leave a comment

Beam geometric non-linear effects – end loads

Posted on 18/10/2024 by dougaj4

Following the previous post, I found some errors in the Python code: These problems have now been fixed, and updated code and a revised spreadsheet have been added to the download file at: py_GeomK.zip The screenshots below show results with … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

Beam geometric non-linear effects – Python version

Posted on 12/10/2024 by dougaj4

In 2018 I posted Beam geometric non-linear effects with a VBA based spreadsheet to calculate beam actions and deflections under combined transverse and axial load, allowing for geometric non-linear effects. I have now converted the code to Python, linking to Excel … Continue reading →

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

Continuous beam analysis from first principles

Posted on 22/09/2024 by dougaj4

This post was prompted by an Eng-Tips question: Statically Indeterminant Beam Problem, asking for reactions due to a triangular distributed load on the middle span of a continuous beam with 3 equal simply supported spans. This could be simply solved … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA | Tagged , , , | 3 Comments