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

- 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

- 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, 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:

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

### Like this:

Like Loading...

*Related*

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

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.

LikeLike

Thanks metroxx, I’ll fix the problem then post more details about how to use it.

LikeLike

Updated version now available at:

http://interactiveds.com.au/software/ConBeamU.zip

I’ll post more details later

LikeLike

Hello,

Where mistake? Please take a look into example:

https://www.dropbox.com/s/snu9za6eopr87rk/ConBeamU.xlsb

LikeLike

Just delete the X values greater than the beam length in cells J35:J52.

Another thing to make friendlier in the next version.

LikeLike

Thank you, its clear.

One more suggestion.

Is it possible to make that blank cells will be with formula? (=””). Its needed if you want to link data from other place.

Please see example:

https://www.dropbox.com/s/snu9za6eopr87rk/ConBeamU.xlsb

LikeLike

Version 3.02 now uploaded.

Now X values greater than the beam length are ignored (Function returns N/A for those rows), and a formula linking to a blank cell is allowed in any input range.

LikeLike

Works good.

Thank you 😉

LikeLike

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

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

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

LikeLike

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.

LikeLike

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

LikeLike

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.

LikeLike

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

LikeLike

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.

LikeLike