.

Spreadsheets

Span Analysis

Span Analysis is an Excel spreadsheet capable of analytically calculating bending moment and shear force along a single spanning member or part of a multiple spanning beam, loaded by linearly varying load.
All the information required by the sheet to perform the calculations is the value of the sagging moment and the value of the uniformly distributed load at both ends of the member, and the length of the member. Once all parameters are set, an analytical solution of the bending moment and the shear force diagram is plotted, accompanied with information on the critical points for both graphs. In addition, the values of bending moment and shear force can be exported at the exact point of the user's interest.

It can be used on single spanning structures or members of a continuous beam or a moment resisting frame. The reasons for creating this calculation sheet and its major applications are listed below:

  • Identify the analyses action along a single span, once the boundary conditions are calculated using the Moment Redistribution Method (Cross)
  • It can be used as a fast calculator sheet for moment and shear along a member for a preliminary design of beams or slabs.
 
 

This spreadsheet is quite easy to use since all the required data is summarized in five cells. Note that data required cells are colored in sky-blue only.

You may download the latest version here: DOWNLOAD PAGE

 

Continuous Beam

Continuous Beam is composed by a set of independent Excel spreadsheets, each capable to analyse a different beam type.

Continuous Beam can only be used for calculating the bending moment and shear force diagram of a multispanning continuous beam, loaded with universal distributed load. Calculations are carried out automatically using the Moment Redistribution Method. Results are printed in numerical tables and colour graphs.

All the required information can be inputted in the sky-blue cells of the Data sheet. Calculations are carried out in three separate sheets (one for each major type of loading combinations) and exported as a numerical table at the bottom of the sheet.

Note that each span's individual variables includes length, 5 unique loading types, maximum and minimum loading factors for each load, and an additional loading coefficient in case the Marcus method (biaxial load distributions for concrete slabs) is applied.

The solution of all three loading combinations of the model produce an envelope of the bending moments, shear forces and reactions on supports of the beam, assuming all supports are treated us rollers.

 

You may download the latest version here : DOWNOLAD PAGE

Facebook Twitter Google+ LinkedIn Delicious Myspace E-Mail