Category Archives: PyXLL

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 , , , , , , , , | 1 Comment

py_Numpy update

Posted on 31/08/2024 by dougaj4

The py_Numpy spreadsheet, and the associated Python module have been updated. The new files are included in: py_SciPy.zip The download contains full open-source Python code and example spreadsheets for a wide range of Scipy functions, as well as the Numpy … Continue reading →

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