This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Calculation Preview

I am in Aerospace and saw the beamanal.xls spreadsheet.  I made some enhancements to it.  To plot all points where point loads and point moments are, including the +moment and -moment at an applied moment point.  Also enhanced the solution for finding minimum and maximum moments and deflections.  I use Visual Basic to sort the points and to resize the plots so that the right end is at maximum x.

This Excel Workbook is based on the Excel Workbook "BEAMANAL.xls" by Alex Tomanovich, P.E.

Structural analysis of a single-span or continuous-span beam requires determination of the internal loading distribution based on external loads and beam supports. This workbook provides the calculations necessary for determination of the internal loading distribution (shear and moment distribution) along with the slope and deflection distribution. The Workbook by Mr. Tomanovich is mainly for steel structures in the Civil Engineering world.  I am in Aerospace and deal in inches and millimeters rather than feet. Therfore, I have tried to make the calculations unit free. 

Program Description:
This Workbook provides  for the analysis of either single-span or two (2) to five (5) continuous-spans analysis a beam with loadings including point loads, point moments, constant distributed and linearly variable loadings.  Four (4) end constaint cases for the single-span beam, and fixed or simple support at ends of the two (2) through (5) span, continuous-span beam, are considered.  Specifically, beam end reactions as well as the maximum moments and deflections are calculated.  Plots of both the shear and moment diagrams are produced, as well as a tabulation of the shear, moment, slope, and deflection for the beam or each individual span.

This Excel Workbook consists of four (4) Worksheets, described as follows:
Doc - This documentation sheet
Single-Span Beam - Single-span beam analysis for simple, propped, fixed, & cantilever beams
Continuous-Span Beam - Continuous-span beam analysis for 2 through 5 span beams
Reference - Formulas and Methods used in the calculations

Program Assumptions and Limitations:

1.   The following reference was used in the development of this program (see below):
 "Modern Formulas for Statics and Dynamics, A Stress-and-Strain Approach" by Walter D. Pilkey and Pin Yu Chang, McGraw-Hill Book Company (1978), pages 11 to 21.
2.   This Workbook uses the three (3) following assumptions as a basis for analysis:
          a.  Beams must be of constant cross section (E and I are constant for entire span length).
          b.  Deflections must not significantly alter the geometry of the problem.
          c.  Stress must remain within the "elastic" region.
3.   On the beam or each individual span, this Workbook will handle a full length uniform load and up to eight (8) partial uniform, triangular, or trapezoidal loads, up to fifteen (15) point loads, and up to four (4) applied moments.
4.   For single-span beams, this Workbook always only allows a particular orientation for two (2) of the the four (4)
      different types.  Specifically, the fixed end of either a "propped" or "cantilever" beam is always assumed to be on
      the right end of the beam. 
5.   This Workbook will calculate the beam end vertical reactions and moment reactions (if applicable), the maximum positive moment and negative moment (if applicable), and the maximum negative deflection and positive deflection (if applicable).  The calculated values for the end reactions and maximum moments and deflections are determined from dividing the beam into fifty (50) equal segments with fifty-one (51) points, and including all of the point load and applied moment locations as well.  (Note: the actual point of maximum moment occurs where the shear = 0, or passes through zero, while the actual point of maximum deflection is where the slope = 0.)
6.   Calculations for two (2) specific locations from the left end of the beam for the shear, moment, slope, and deflection is available.
7.   The plots of the shear and moment diagrams as well as the displayed tabulation of shear, moment, slope, and deflection are based on the beam (or each individual span) being divided up into fifty (50) equal segments with fifty-one (51) points.
8.   For continuous-span beam of from two (2) through five (5) spans, this program utilizes the "Three-Moment Equation Theory" and solves a system simultaneous equations to determine the support moments.
9.  This Workbook contains numerous “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc.  (Note:  presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell.  Merely move the mouse pointer to the desired cell to view the contents of that particular "comment box".)


System 1 System 2 System 3
Length inches feet millimeters (mm)
Force pounds kips (kilo-pounds) Newtons (N)
Moment inch-pounds ft-kips N-mm
Distributed pounds/inch kips/ft N/mm
E pounds/inch^2 (psi) kips/in^2 (ksi) MegaPascals (MPa)
I inch^4 inch^4 mm^4
R pounds kips N
M inch-pounds ft-kips N-mm
D inches inches/1728 mm

Calculation Reference
Beam Analysis
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Structural Design
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Stiffness Methods
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
03 Apr 2012
Submitted By:
File Date:
03 Apr 2012
File Author:
Eugene McClain
File Version:
File Size:
1,176.23 Kb
File Type:
stars/0.gifTotal Votes:0
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.


#3 AMMamore 2017-10-03 14:13
I tried running a propped beam with just a single uniform load, no other loads. But when i looked at the moment diagram, there was a vertical line near the middle. I believe that is wrong. I expected to see only a smooth 2nd degree curve for that. The shear diagram looked OK. Thanks!
#2 svega 2012-08-13 16:03
Just to report that on Enhanced BEAMANAL.xls,Version 1.2,Continuos Beam Tab, cells Q10 & T10 values for +Mmax, are not compatible with the Moment Diagram.
Thanks for revision.
#1 JohnDoyle 2012-03-17 11:17
Thanks for your contribution Eugene. I have awarded you with a free 3 month XLC Pro subscription by way of thanks. [Admin]

Please sign in or register to add a comment.

We have 20 guests and 38 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Google Analytics Alternative