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