Category Archives: Frame Analysis

PlateStress Update

The functions from the PlateStress spreadsheet (details here) will be incorporated in the FEA spreadsheets currently being presented. In the process of using these functions I made a couple of improvements: The required sequence of the Gauss Points numbers was clarified: … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 1 Comment

RC Design Functions update

Following a comment here I have updated my RC Design Functions spreadsheet, which is available for free download (including full open-source code) from: RC Design Functions7.zip The main new features in the latest version are: The existing optional “depth” argument has … Continue reading

Posted in Arrays, Beam Bending, Concrete, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment

ConBeamU 4.08

The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point.  The new version (4.08) can be downloaded from: ConbeamU.zip … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 1 Comment

ConBeamU 4.05 and ConBeampy 1.02

The latest update of the two continuous beam spreadsheets can be downloaded from: ConBeamU.zip ConBeampy.zip The main changes are: A problem with point loads applied exactly at a support position has been corrected A function has been added to evaluate … Continue reading

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

Conbeam – Python version

I have converted the continuous beam analysis spreadsheet (last presented here) to Python code, linked to Excel VBA User Defined Functions (UDFs) with ExcelPython.  To run the Python version you will need an installed copy of Python, including Numpy and … Continue reading

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