Structural Analysis and Design of Beams
Scroll down for more details about the excel spreadsheets in this category for i) beam design by allowable stress design; ii) c-channel beam design with both bending stress and torsional stress present; iii) a series of beam analysis spreadsheets for simply supported, cantilever, fixed ends, propped cantilever, and overhang beams; and iv) spreadsheets for calculating shears and moments along a continuous beam and at the supported ends of continuous beams. In each of the beam analysis workbooks described below, t
This Free Sample Excel spreadsheet Illustrates the type of calculations that can be made with the structural analysis spreadsheets that are available through this website.
This workbook has two tabs involving the allowable stress design of beams for a simply supported beam carrying a uniformly distributed load. In the first tab, input consists of span length, elastic modulus, live load, dead load, allowable bending stress, deflection limit for live load, and deflection limit for live plus dead load (serviceability requirements). The workbook then calculates the maximum moment, maximum shear, elastic section modulus, and minimum moments of inertia required to satisfy the constraints on deflection. In the second tab, a check is made of a known design to see if strength and deflection requirements are met. Input is the same as in the first tab, with the addition of the elastic section modulus and moment of inertia. The workbook then determines whether the maximum moment, deflection under live load, and deflection under live plus dead load are less than the corresponding allowables. Both SI and US Customary units are allowed. All formulas are given, and the Excel code can be easily customized to meet specialized requirements of a particular user.
This Excel workbook performs the structural analysis of simply supported beams. Loading consisting of concentrated forces, linearly varying distributed forces, and concentrated moments may be specified. Calculations are in S.I. units.
This simply supported beam analysis spreadsheet is the U.S. units version of the workbook described above
This cantilever beam analysis spreadsheet performs the structural analysis of cantilever beams. Loadings consisting of concentrated forces, linearly varying distributed forces, and concentrated moments may be specified. Calculations are in S.I. units.
U.S. units version of the workbook described above
This Excel workbook performs the structural analysis of beams with both ends fixed. Loadings consisting of concentrated forces, linearly varying distributed forces, and concentrated moments may be specified. Calculations are in S.I. units.
This Excel workbook performs the structural analysis of cantilever beams with one end fixed and the other end supported by a roller. Loadings consisting of concentrated forces, linearly varying distributed forces, and concentrated moments may be specified. Calculations are in S.I. units.
This Excel spreadsheet workbook performs the structural analysis of beams that overhang one support. Loadings consisting of concentrated and linearly varying distributed forces may be specified. Calculations are in S.I. units.
This Excel spreadsheet workbook performs the structural analysis of continuous beams with two spans (equal or unequal in length). Loadings consisting of concentrated or uniformly distributed forces may be specified. Calculations are in S.I. units.
This set of continuous beam analysis spreadsheets includes the six S.I. unit Excel workbooks that are available for $14.95 individually. These spreadsheets can do structural analysis of simply supported, cantilever, fixed end, overhang, continuous two-span, and propped cantilever beams. Beam deflections, shear diagrams and moment diagrams are plotted and also displayed in a table. This spreadsheet package comes as a .zip file. If you have a problem with unzipping the files, send an email message to hnkbengtson@yahoo.com, and I'll email the individual spreadsheets to you.
U.S. units version of the continuous beam analysis spreadsheet workbook described above