Category Archives: PyXLL

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

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

py_Conbeam – 5

Posted on 28/08/2024 by dougaj4

… or perhaps one more. Following the previous post I have modified the py_BeamAct3D function to fix some problems with the non-linear analysis. The latest version, together with an additional spreadsheet comparing results with Strand7, can be downloaded from: py_ConBeamU.zip … Continue reading →

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