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.

13 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!


  5. Jérémie says:

    Hello Dougaj4,

    This is a very great work! I can obtain the curve of the results but, the diagram showing the load doesn’t work for me :-\ . When I open the ConBeamU.xlsb file I become an error that say :
    Something was deleted here /xl/workbook.bin
    And formula was repaire in /xl/worksheets/sheet8.bin (This sheet8 is empty also vba)
    If I want to continue, exel repair the file. At the start of the sheet I can see value in the Load Graph Data table. And when I launch the calculation I become in all cell #VALUE! . I have try to debug the PlotMom function while launching it with a bouton:
    PlotMom Range(“B6:B16,E6:E16,B21:E53,F21:H53”)
    But I become an error 1004 because the Range method doesn’t work to call all these cells.
    Have you any solution to solve the problem ?

    Thank you a lot 🙂


    • dougaj4 says:

      Thanks for letting me know. I’ll have a look and reply here.

      If you could send your copy of the file to my gmail address (dougaj4), that would be helpful.


    • dougaj4 says:

      Hi Jeremie,

      I have now had a look at my master copy of ConbeamU, and I don’t get the problems you describe. This makes it difficult to find the source of your problems, but I will be happy to look at your copy if you send to GMail (Dougaj4@….).

      Some other things you might try are:
      Download the file again, and make sure you have the latest version (4.10 23-Aug-16, see the “about” sheet).
      If you want to step through the VBA code for PlotMom (or any other VBA function):
      – Go to the VBA code and insert a breakpoint near the start (but not on a Dim statement line).
      – Return to the spreadsheet, select the cell at the top-left corner of the PlotMom output, press F2 (to enter Edit mode), then press Ctrl-Shift-Enter, to re-enter the function. The VBA code should appear, with the break line highlighted. You can then step through the code by pressing F8.
      Note that the input for PlotMom is a single range: =plotmom(F21:H53)

      Hope that helps



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