Beam with stress.xls



This is a modification to an Alex Tomanovich spreadsheet (Thanks Alex) for bending in a single-span beam. I added a few additional beam shapes and the option to input user defined moment of inertia and section modulus. I also added an input for allowable stress, calculations for bending stress in the beam, and the stress ratio.
 P.S. As was the case with the original sheet by Alex, the sheet is protected, but there is no password.

Calculation Reference
Beam calculation
Structural analysis

13 Feb 2009
Last Modified
16 Feb 2009
File Size:
604.50 Kb
File Version:
File Author:

Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 4
norsam1966@ 2 years ago
is there a Metric version?
Aaron Biedenbach 11 years ago
Has anyone modified the spreadsheet to allow the location of RL and RR to be located at other points along the beam?
NewMechEngr 14 years ago
Sorry, I didn't realize that, but as I mentioned in the original notes, the sheet is protedcted, but there is no password, so simply unlock it and define those blocks as user editable.
bobmo 14 years ago
very easy to use! And Thanks for the dual units! Only negative is the job, date, etc block at the top is locked, so I cant make any note until after I print.