How to determine shear forces bending moments slopes & deflections of any single span beam in excel

This is an exclusive construction video tutorial that guides you efficiently in producing an excel spreadsheet for determining shear forces bending moments slopes and deflections concerning any single span beam.

In the first part of this tutorial, the information is given on how to obtain the numerical integrals of a single span. In this part, you will learn to add various support conditions in the spreadsheet.

The axis of a beam deflects from its preliminary position due to the action of applied forces. Perfect values for the beam deflections are pursued in several practical cases.

The deformation of a beam is generally stated by means of its deflection from its actual unloaded position. The deflection is calculated from the primary neutral surface of the beam to the neutral surface of the deformed beam. The configuration anticipated with the deformed neutral surface is defined as the elastic curve of the beam.

The deflection of a beam can be simply ascertained with either the moment area method or the conjugate beam method.

Single span construction belongs to a beam (or slab) that is simply supported (assumed pinned) at its ends. It is possible to analyze a single span beam, or a single span from a continuous beam.

The consistency of the beam is obtained by indicating the end condition at each end: free, simply supported, fully fixed or an elastic/spring support.

To watch the online demonstration, go through the following video.

Video Courtesy: manos