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:

Applications in the spreadsheet include:

Conbeam and ConbeamU; continuous beam analysis with any number of supports and beam segments.  Supports may have specified translation or rotation stiffness or specified displacements.  ConbeamU (and other functions ending in U) are unit aware, allowing input and output in a wide variety of different units:

There are also similar functions for single spans (SSSpanU) and cantilevers (CantileverU).

MovLoadU does moving load analysis on a continuous beam, with vehicles with any number of axles:


FEAU and REAU find fixed end moments or restrained end moments for a single span with fixed ends or spring restrained ends.  The beam may have any number of segments with different section properties.


Any number of loads may be applied, which may be point forces or moments, of uniform or trapezoidal distributed loads:


The BeamAct3D function returns beam actions and deflections along the beam, for a beam with any number of segments and specified end conditions and applied loads.


The React3D function returns fixed or restrained actions for a beam with any number of segments, subject to 3D loading:


Download the spreadsheet for more details of each function, and information on using array functions.

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

10 Responses to ConbeamU 4.10

  1. garethhayter says:

    Hi Doug. Are you still using FormulaDesk to create your math equations?


    • dougaj4 says:

      Hi Gareth. I’m not really using it at the moment. I’m still interested, but I’ve just got too many other things I’m working on at the moment. The equations in this post are just scanned images from books.


  2. 44steps says:

    If I had export full functionally function conbeam (not conbeamU), wich modul could I get?


  3. 44steps says:

    In “Continuous Beam Analysis by Macaulay’s Method” the field “Section/Span” what does it do?


    • dougaj4 says:

      The simplest thing to do is to save the spreadsheet with a new name, and just delete the sheets you don’t want.
      If you don’t want to use the units functions you could open a blank workbook, save as xlsb or xlsm, and copy across the VBA modules. You can drag and drop in the VB Editor. Conbeam and ConbeamU are both in the same module. You won’t need the Units module if you don’t want to use ConbeamU, but the safest thing is to just copy all of them.
      If you do want to use the units at any time, the units data is in a worksheet and uses named ranges, so you need to use a copy of the original file.


    • dougaj4 says:

      It returns results at however many sections you specify for each span. You can enter a single number, and get the same number of sections in each span, or enter a number for each span. The alternative is to list the position of each section where you want results, then set the ListOutPoints argument to True or 1. See the ConBeam Check sheet for an example where the output point positions are listed, and the ConBeamU sheet for the number of sections in each span, with ListOutPoints omitted.


  4. Dan Ashby says:

    Wow. I just stumbled across this while researching to develop a similar spreadsheet myself. I’m so glad too, as I am looking for functionality to accommodate a variable number of spans, support displacements, and shear deformations – all features that would have taken a long time to implement robustly. Thanks Doug; you just saved me a ton of time and heartache!
    I’ll dig in to it properly when I have time, and will let you know if I think of anything that might be worth incorporating, though it looks like over the years you’ve grown this in to a very powerful tool with most of the bells and whistles that I had been dreaming of. Great work. Thanks for sharing!


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s