Analysis of a Cantilever Beam

Title: Analysis of a Cantilever Beam

Contributor: Mark Rossow, Ph.D., P.E. , Former Chairperson of Civil Engineering, Southern Illinois University Edwardsville

Published Date: April/2015

Content Type: Spreadsheet


Complicated polynomial equations describe the deflection and internal shear and moment distributions in a cantilever beam and are cumbersome to use in hand calculations. This Excel workbook employs these equations to automatically calculate maximum values, plots and tables of beam deflections, shear, and moments. The external reactions acting on the beam are also calculated. The user specifies beam length, load (concentrated forces, distributed forces, and concentrated moments) values and positions, and elastic modulus, and results appear in clearly labeled output cells, tables, and plots.