Category Archives: Finite Element Analysis

py_xlCBA – Supports with defined deflections

Posted on 29/01/2026 by dougaj4

As stated in the previous post, this post will cover the calculation of beam actions and displacements when one or more supports have a defined vertical displacement, using the pyCBA beam analysis package. The Python code has been updated since … Continue reading →

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

py_xlCBA update

Posted on 18/01/2026 by dougaj4

Following the previous post the py_xlCBA spreadsheet and associated code have been updated. The updated files, including open-source code, can be downloaded from: py_xlCBA.zip Note that the link in the previous post was downloading the wrong file, and has just … Continue reading →

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

3DFrame-py rel. 0.50

Posted on 14/07/2025 by dougaj4

Following the recent post on the Python lru_cache function (Python functools and the Fibonacci Sequence) I have had a look at using lru_cache in the 3DFrame-py spreadsheet. So far using lru_cache in this code has provided little to no speed improvement, … Continue reading →

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

3DFrame-NLGeom

Posted on 13/02/2025 by dougaj4

The VBA version of the 3DFrame spreadsheet has now been updated to allow geometric non-linear effects to be included. The new version can be downloaded from: 3DFrame.zip For more details of the VBA 3DFrame see 3DFrame update, and for the … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA | Tagged , , , , , | 3 Comments

3DFrame-py-comb

Posted on 01/02/2025 by dougaj4

The 3DFrame-py spreadsheet has now been updated with provisions for saving multiple load cases and the associated results, and analysis with factored combinations of multiple load cases. The new files can be downloaded from: 3DFrame-py.zip See Installing 3DFrame-py for installation details, and … Continue reading →

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