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 c-channel bending stress and torsional stress spreadsheet performs all the necessary calculations for C-shaped members subject to the common load case of a uniformly distributed load. It should be a very useful tool for those who design structures with light-gage steel products. The required input is minimal. Three possibilities are considered.
The ends of the member are assumed to be pinned for torsional stresses, but may be simply supported or be continuous with end moments for bending stresses.
The results provide the rotational displacements, combined stresses and reduction factors at a number of points along the span of the beam. From this the designer can choose an appropriate bracing arrangement and calculate the safe moment capacity for this condition.
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.
U.S. units version of the workbook described above
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 firstname.lastname@example.org, and I'll email the individual spreadsheets to you.
U.S. units version of the continuous beam analysis spreadsheet workbook described above
The design of a beam requires the calculation of the shears and moments along the length of the beam. This can be a tedious task, especially if many and/or unusual loads are present. This spreadsheet calculates the shears and moments at any designated point along the length of an individual beam. Loads can be concentrated or distributed and can be arranged and combined to create a wide variety of loadings. If the beam is one of a continuous series of beams, it is statically indeterminate. In this case, the reactions and moments cannot be solved by statics alone. The moments at the ends of the beam under the applied loads must first be established by an indeterminate beam analysis. Two companion spreadsheets, designated as #2 and #3 are available to provide this analysis.
This spreadsheet package contains two spreadsheets, designated as #2 and #3. Spreadsheet #2 performs an analysis of continuous beams using an approach known as "moment distribution." This spreadsheet requires, as input, the fixed end moments for each span under its applied loading. The moment distribution process then calculates the final moments at the ends of each beam span. Formulas for fixed-end moments are available from a number of references or may be calculated by the companion spreadsheet included in this package, designated as #3.
This spreadsheet package includes Spreadsheet #1, Spreadsheet #2, and Spreadsheet #3 as described above.
This Excel Spreadsheet for steel beams uses inputs of inertia, height, Cw, plastic and residual moments to generate the compactness of the flange and web, nominal moment, and shear for any steel beam. Calculations use U.S. units.