Category Archives: UDFs

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

Scipy-statistics update

Posted on 08/09/2024 by dougaj4

Links to the Scipy statistics functions were last presented here. The functions have since had extensive updates: The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, are included in the download file: py_SciPy.zip Details of the required pyxll … Continue reading →

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