Category Archives: Frame Analysis

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

Continuous beam animations with VBA and Python

Posted on 20/12/2025 by dougaj4

Following a lengthy discussion at Eng-Tips I have developed several functions to generate animations of the effects of applied moving loads. The Python code and examples have been added to the py_ConBeamU.zip file which can be downloaded from: py_ConBeamU.zip Starting … Continue reading →

Posted in Animation, Beam Bending, Charts, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA | Tagged , , , , , , , , , , | Leave a comment

py_ConBeamU and Strand7 check updates

Posted on 11/12/2025 by dougaj4

Following the previous post, I have updated the py_ConBeamU spreadsheet, and the associated check against Strand7 results. The new files can be downloaded from: py_ConBeamU.zip The download file now includes: For more details of the spreadsheet and included functions see … Continue reading →

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

ConBeamU and Strand7 check update

Posted on 05/12/2025 by dougaj4

Results of the continuous beam spreadsheet were last checked against Strand7 results 10 years ago. I have now updated this check with the latest version (4.19), which can be downloaded from: ConBeamU.zip The download file now includes: The Strand7 check … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | 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