Purpose of calculation Calculate reaction forces, moment and deflection in cantilever beams.     Calculation Reference Steel Designer's Manual 5th Edition Calculation Validation All cell formulas checked with XLC equations against calculation reference. 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 Cantilever

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 Cantilever

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 Cantilever

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 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).