## Tuesday, October 16, 2018

### Beam Analysis Calculations Spreadsheet (Free Excel-Sheet)

Introductions :-
The "BeamAnal" calculates Shear Force, Bending Moment and Deflection at 31 positions along the member length. Member Lengths can be a single span simply supported or a 2, 3 or 4 span continuous over middle supports. The analysis results are produced in a tabular form and are also plotted in 3 graphs for rapid comprehension.

BeamAnal is supplied as an Excel 97 Template, having .XLT as its filename extension.
To load BeamAnal on to your computer, copy this file into Microsoft Office folder for its Templates. Generally the path to this folder in Excel 97 is:
C:\Program Files\Microsoft Office\Templates

If you are using Excel 2000, the path to this folder is:
C:\Windows\Application Data\Microsoft\Templates

To load and use the Template in Excel 97 or Excel 2000, choose:
File, New and the select the file BeamAnal001112-

If you receive an Excel Warning about running Macros and are prompted for whether to load them, answer YES to Load and Enable Macros. BeamAnal incorporates VB Macros and to allow your computer to use them is vital for its operation.

Using BeamAnalysis :-
After describing Job Information in the heading part, describe data in 4 parts. Shaded cells in each part indicate locations for the user input. In part 1, describe member properties. In part 2, define loads by giving their magnitude, position and load factors. In part 3, describe the number and position of middle supports. In part 4, choose whether the results are to be factored or un-factored.

Method of Analysis :-
The program uses usual equations for Shear Force, Bending Moment and Deflection equations along the member span. When middle supports are specified, simultaneous equations are set up and solved to calculate the middle support reactions.

Origin :-
The origin or reference point for defining position of loads and locations for analysis is the left supports. This is so even when there are middle supports to make the member length a continuous beam of more than one span.