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.