Category Archives: Strand7

Calling PyCBA from Excel

Posted on 04/01/2026 by dougaj4

PyCBA is a Python based continuous beam analysis program. From the on-line docs: I have set up a spreadsheet based on py_Conbeam that converts the py_Conbeam input to PyCBA format, then runs the PyCBA analysis and returns the results to … Continue reading →

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

py_ConBeamU and Strand7 check updates-2

Posted on 30/12/2025 by dougaj4

Recent work with the py_ConBeamU spreadsheet found that it was returning incorrect results when the last support had a rotation spring restraint. In spite of the checks against Strand7 having 90 different support conditions, none of them included this one, … Continue reading →

Posted in Beam Bending, Excel, Link to Python, Newton, PyXLL, Strand7, UDFs | Tagged , , , , , , , | Leave a 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