Continuous Beam spreadsheet with moving load

I have added a moving load function to the ConBeamU spreadsheet, allowing maximum load actions and deflections to be determined in a continuous beam  under the influence of a vehicle defined by a number of point loads.  The new version may be downloaded from ConBeamU Download, including full open-source code.

The procedure to use the new function is:

  • Define: Beam Segments, Supports, and fixed Distributed and Point Loads, as for the other beam analysis functions:
Beam segments, supports, and fixed loads

Beam segments, supports, and fixed loads

  • Define the moving vehicle loads (axle loads and axle spacing), load factors and output units:
Vehicle loads and axle spacing, load factors, and output units

Vehicle loads and axle spacing, load factors, and output units

  • Define the output actions or deflections required, and their location along the beam, with a two row range of as many columns as required.
  • Define the vehicle positions to be analysed with a column of positions of Axle 1 of the vehicle.
  • The loads generated for any specified vehicle position may be displayed by entering the vehicle position above the Loads graph:
Fixed load details, Output actions and positions, Vehicle positions, and output results

Fixed load details, Output actions and positions, Vehicle positions, and output results, Click for full size view

Bending moments, shear forces and deflections for a 3 span bridge deck under AS 5100 MS1600 loading are illustrated in the graphs below:

MovLoad4 MovLoad5 MovLoad6

For convenience, the input data areas used in the analysis shown have been shaded grey, but the input may be rearranged as desired, and then the MovLoadU function re-enetered, selecting the new ranges.

A summary of the input and output of this, and all the other functions included in the spreadsheet, may be found on the Functions sheet:

Click for full size view

Click for full size view

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

17 Responses to Continuous Beam spreadsheet with moving load

  1. Pingback: Continuous Beam spreadsheet with moving load | Ceļuprojekts

  2. metroxx says:

    Hello,
    Looks great.
    Can you explain more about OutActions? How it works?
    Also there is a bug. ( I try it in 2 PCs)
    If I delete data (B8:F11) in example, than Excel stop working.

    Like

  3. metroxx says:

    Hello,
    Where mistake? Please take a look into example:
    https://www.dropbox.com/s/snu9za6eopr87rk/ConBeamU.xlsb

    Like

  4. metroxx says:

    Works good.
    Thank you 😉

    Like

  5. Pingback: Moving Load Spreadsheet – update and how to use | Newton Excel Bach, not (just) an Excel Blog

  6. Pingback: Continuous Beams With Cantilevers by Macaulay’s Method | Newton Excel Bach, not (just) an Excel Blog

  7. Annkkuu says:

    Hi..How can I solve a continuous beam problem in spreadsheet if load is applied as overhang? No support is provided after 3 supports.

    Like

    • dougaj4 says:

      Just define the supports at the correct position.
      If you had two 10 metre spans and a 5 metre cantilever than the beam length would be 25 m, and the support positions would be 0, 10, 20.
      For a cantilever at the support positions would be 5, 15, 25.
      For a cantilever at both ends the beam length would be increased to 30 m, with supports at 5, 15, 25.

      Like

  8. SLR says:

    Hi really nice job!.
    Why the X values are only until 30 m?. I need to analyze a 42 m continous beam and I would like to do it with your spreadsheet. Can it be modified?. Thanks

    Like

  9. dougaj4 says:

    Thanks.
    All the areas shaded grey are user input, so you can enter any values you like for the X values.

    Because the calculations are done through user defined functions, you can also adjust the output ranges. For instance, if you want more intermediate points you can increase the length of the output range. See:
    https://newtonexcelbach.wordpress.com/using-array-functions-and-udfs-and-following-links/
    for more details.

    If anything is not clear, please ask.

    Like

  10. enggarena says:

    Dear Sir,
    Can you make the axle numbers in vehicle definition at least up to 16, i tried but goes up to 12 axles.
    Looking forward to your kind reply.
    Thanks

    Like

    • dougaj4 says:

      You can have up to 1048576 axles you just need change the range in the formula:
      Click on the top-left cell of the output range. It should display {=MovLoadu(…
      Press F2
      Drag the range for the Vehicle definition down as far as you want
      Press Ctrl-Shift-Enter

      You can also change the range with the function wizard, or just edit the range address in the formula.

      Like

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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