Beam with stress.xls

Rating:
26

Description

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

Submitted On:
16 Feb 2009
File Size:
604.50 Kb
Downloads:
709
File Version:
1.0
File Author:
NewMechEngr
Rating:
26

 
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@ 7 months ago
is there a Metric version?
Aaron Biedenbach 10 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 13 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 13 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.