Tag Archives: ConBeamU

Setting up UDF Applications

Following a recent comment, this post looks at setting up a user defined function (UDF) on a blank worksheet, using the ConBeamU function as an example. To use a UDF, the VBA code for the function must either be included … Continue reading

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , | 2 Comments

ConbeamU 4.10

The ConbeamU spreadsheet has been updated to Version 4.10, to fix a problem with incorrect default parameters being used if the support stiffness columns had empty cells.  The revised spreadsheet (including open-source code) can be downloaded from: ConbeamU.zip Applications in the … Continue reading

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

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 , , , , , , | Leave a 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

ConbeamU Update Update

Following some comments from 4Step on the last ConbeamU update, and a thorough check of results against Strand7 results, I have posted a new version that fixes a number of issues with the previous one.  The new version number is … Continue reading

Posted in Beam Bending, Excel, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | 4 Comments