## Simple Continuous Beam analysis spreadsheet (free)

## Simple Continuous Beam analysis spreadsheet (free)

5

missil3 (Aerospace)
(OP)

Hi,

I had created this spreadsheet a few years back for analyzing continuous beams with any number of supports and loads. Thought I would share this and others can use it/modify it as per your requirement. Should be fairly easy to modify the code as I have written sufficient comments to understand it.

Force method is used, Euler-bernoulli equations are used to calculate deflections.

It support any number of supports,point moments , loads , uniform distributed loads. Will output shear , moment diagrams, reaction forces.

Doesn't support axial loads atm.

I had created this spreadsheet a few years back for analyzing continuous beams with any number of supports and loads. Thought I would share this and others can use it/modify it as per your requirement. Should be fairly easy to modify the code as I have written sufficient comments to understand it.

Force method is used, Euler-bernoulli equations are used to calculate deflections.

It support any number of supports,point moments , loads , uniform distributed loads. Will output shear , moment diagrams, reaction forces.

Doesn't support axial loads atm.

## RE: Simple Continuous Beam analysis spreadsheet (free)

## RE: Simple Continuous Beam analysis spreadsheet (free)

I am an aerospace guy and I am not really sure what alternating live loads are. If you can explain how they act I can check if it can be added to the spreadsheet.

## RE: Simple Continuous Beam analysis spreadsheet (free)

In building design (and in a different way in bridge design) the building codes require that any type of continuous framing be analyzed with due regard for possible combinations of loaded spans.

For instance, if you have a six span beam system, it is possible in a floor area to have some of the beams loaded and some not. This creates situations where higher moments and shears occur over that found by loading all the spans together.

The combinations required are comprised of six arrangements:

Odd spans loaded

Even spans loaded

All spans loaded

Adjacent span arrangement 1 (load spans 1, 2, 4, 5)-skip 3 and 6

Adjacent span arrangement 2 (load spans 2, 3, 5, 6)-skip 1 and 4

Adjacent span arrangement 3 (load spans 1, 3, 4, 6)-skip 2 and 5

There are no other combinations possible.

For the odd/even spans you will find maximum positive moments.

For the adjacent spans you will find maximum negative moments.

For some of the adjacent and, I think, the total load you will get maximum shears.

The codes don't directly state whether 100% of the live loads must be alternated like this, presuming the engineer will use judgement as to how much of the live load will be semi-permanent so sometimes engineers will skip 75% of the live load and leave the other 25% in place as a total load (all span) condition.

## RE: Simple Continuous Beam analysis spreadsheet (free)

I think this can be coded as a separate macro to run different load combination as per the requirement. Have a look at what the spreadsheet does, I think this will easier if you just do a small macro to do the live loads instead of altering the base macros.

## RE: Simple Continuous Beam analysis spreadsheet (free)

## RE: Simple Continuous Beam analysis spreadsheet (free)

## RE: Simple Continuous Beam analysis spreadsheet (free)

was there any attachement to the thread? or is the spreadsheet removed?

## RE: Simple Continuous Beam analysis spreadsheet (free)

http://files.engineering.com/download.aspx?folder=...

## RE: Simple Continuous Beam analysis spreadsheet (free)

## RE: Simple Continuous Beam analysis spreadsheet (free)

## RE: Simple Continuous Beam analysis spreadsheet (free)

Its just a beam that has intermediate supports. Usually such beams are statically indeterminate.

@rb1957 : Ya, adding beam deflections as an output should be useful but I don't know if I will get around to doing that. If you know your way around VBA should be an easy thing to do.

## RE: Simple Continuous Beam analysis spreadsheet (free)

Regards.

Analysis and Design of arbitrary cross sectionsReinforcement design to all major codesMoment Curvature analysis

http://www.engissol.com/cross-section-analysis-des...