Purpose of Calculation Calculate reaction forces, moment and deflection in simply supported beams.     Calculation Reference Steel Designer's Manual 5th Edition Calculation Validation All cell formulas checked with XLC equations against calculation reference. Repository Link Download similar worksheets from the ExcelCalcs Repository. Copy HTML code snippet to create a dynamic window to this page from your own website Taken from the ExcelCalcs.com website.
Nomenclature Young's Modulus = E Beam 2nd moment of area = I Applied distributed load = W Applied point load = P Moment = M Reaction force = R   Deflection = δ

### Case 1) Uniformly Distributed Load on Simply Supported Beam

Native Excel:
Click in the text area below and copy.
Paste into cell A1 of a worksheet.

XLC Enhanced Excel:
Use XLC’s ‘Web Paste’ button to paste at any position in worksheet.
Includes mathematical formatting and XLC equations.
Note: Both include SI(mm) & US(in) units (delete as appropriate).

### Case 2) Point Load on Simply Supported Beam

Native Excel:
Click in the text area below and copy.
Paste into cell A1 of a worksheet.

XLC Enhanced Excel:
Use XLC’s ‘Web Paste’ button to paste at any position in worksheet.
Includes mathematical formatting and XLC equations.
Note: Both include SI(mm) & US(in) units (delete as appropriate).

### Case 3) Applied Moment on Simply Supported Beam

Native Excel:
Click in the text area below and copy.
Paste into cell A1 of a worksheet.

XLC Enhanced Excel:
Use XLC’s ‘Web Paste’ button to paste at any position in worksheet.
Includes mathematical formatting and XLC equations.
Note: Both include SI(mm) & US(in) units (delete as appropriate).