ConBeamU 4.13

The continuous beam analysis spreadsheet, ConBeamU, is now up to version 4.13 with some minor bug-fixes, and the addition of a non-linear option for the BeamAct functions.

See ConBeamU for more details of the functions available in the spreadsheet.

Download the latest version from

The BeamAct2D and BeamAct3D user defined functions (UDFs) return beam actions and deflections for any beam subject to specified loads and end deflections.  The beam may have any number of segments with different section properties, and may be specified in either global or local coordinate systems.  The new non-linear option allows non-linear geometric effects to be taken into account.

Most of the function input is unchanged from previous versions:


The optional non-linear arguments specify if a non-linear analysis is required, the target relative error in maximum deflection, and the maximum number of iterations.  The support stiffness (translational and rotational) may also be supplied.  The default is fixed at both ends for both translation and rotation:


The output is before, with output at any number of specified locations:


Results are shown below for a 3D analysis of a 10 m long beam under combined axial and transverse load.  The blue and green lines are the results ignoring geometric non-linear effects, and the grey and red are the output from both the spreadsheet and a non-linear analysis in Strand7, with the beam divided into 16 segments:


Due to differing approximations in the two programs there are small differences in the shear results:


Bending moments are in good agreement.


The 2D function gives similar results:

conbeamu6-8Note that these functions are still under development.  All results must be independently verified using other software.

This entry was posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

5 Responses to ConBeamU 4.13

  1. ivanStructEng says:

    Hi, Could you please tell me how to create more output stations for calculation at “ConbeamU1”.?

    Thank you very much.


    • dougaj4 says:

      The example is currently set up to return a specified number of points per span, as listed in Column I (Sections/Span). To change the number of spans or points and the output display:
      – Enter the details of support locations and number of sections/span
      – Go to the top-left cell of the output range (J22)
      – Press Ctrl-Shift-S
      -Reformat the extended output range as required
      If your output range is very long you might want to move or delete the results starting at cell K122

      There are other options, but I will do a new post in a few days with more details.


  2. Pingback: Setting up UDF Applications | Newton Excel Bach, not (just) an Excel Blog

  3. metrox says:

    Is it possible to output result for only one interested point and interested value.
    Lets say output only Shear force at distance 5.3m etc. ?


    • dougaj4 says:

      Sure, assuming you are using ConbeamU (or another “unit aware” function):
      Enter m (or distance unit) and 5.3 in two cells in a column
      Select those two cells as the OutPoints argument
      Set the ListOutPoints argument to True
      Press ctrl-shift-enter

      That will display all the results at X = 5.3
      To display just the shear result, wrap it in the Index function:

      Finally to display just the one result (rather than multiple copies of it), press Ctrl-Shift-S

      Note that the OutUnits range should not be changed, it still needs units for all the available output values, even though you are only displaying one.

      Using the example in the download file it becomes:


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.