# Beams Analysis and Design Spreadsheet

Beams analysis and design spreadsheet program is written in MS-Excel for the purpose of analysis of either single-span or continuous-span beams subjected to virtually any type of loading configuration.  Four (4) types of single-span beams and two (2) through (5) span, continuous-span beams, considered.  Specifically, beam end reactions as well as the maximum moments and deflections are calculated.  Plots of all of the diagrams are produced, as well as a
tabulation of the shear, moment, slope, and deflection for the beam or each individual span.  Also, for structural steel single-span beams an AISC 9th Edition (ASD) Code check can be performed for X-axis bending and shear.

# US Steel Sheet Pile Design - Cantilever Wall Excel Sheet

Computes the depth required, maximum moment, and section modulus required for Sheet Pile Design based on US Steel's Sheet Piling Design Manual. There is a sheet to analyze the effects of Cooper E80 loading per AREMA Specifications. However,  normal traffic or equipment surcharge loads can be used as well. Graphs are provided for Log Spiral Active and Passive coefficients.

Download US Steel Sheet Pile Design - Cantilever Wall Excel Sheet Free

# Analysis and Design of Steel Beams According to BS

This spreadsheet performs an analysis and design of simply supported and cantilever, steel beams bending about their X-X axis and subjected to gravity loads. Beams can be either with full restraint or without full restraint.
Design is in accordance with BS 5950-1:1990. Bending moments, shear forces and deflections are computed at 1/60th positions along the span and the maximums of these values are used for the design. The equations for the analysis have been obtained from the Reinforced Concrete Designer's Handbook by Reynolds and Steedman. Self weight of the steel section is automatically included in the calculations. The moment capacity of the section is calculated taking into account the corresponding shear force and a reduction is made as necessary. A check is made to see if a shear bucking calculation is required and a warning is issued. This spreadsheet also contains a calculation sheet for checking local web bearing and buckling.

Download Analysis and Design of Steel Beams According to BS Sheet Free

# Plain Concrete Footing Design Based on ACI

Plain concrete footing or pedestal is a shallow foundation designed to take small loads from columns without using longitudinal tension steel. These are the most economical forms of shallow foundation. To sustain temperature and shrinkage stresses, the standard codes recommend to provide distribution reinforcement bars for plain concrete footings.

# Rectangular Columns Design Excel Sheet

A rectangular concrete column section under axial load and biaxial bending is selected. It is symmetrically reinforced with two layers of reinforcement he corresponding strain, stress and force diagrams on the section at the ultimate load  whereas, the location of the neutral axis specified in terms of two parameters Î± and Î² is For as pecified position and direction of the neutral axis, the strain diagram can be set with the maximum strain in the concrete of Îµcu = 0.0035

# RCC Design Of Cable Trench Excel Sheet

Cable trenching is a method of laying cables into the ground by digging trenches. The cables are submerged underground via the trench and are then covered by a layer of earth, bitumen or concrete. RCC design of cable trench excel sheet allow to to analysis and design the Trench

# Seismic Analysis Excel Sheet

Seismic is manifested as ground shaking caused by the sudden release of energy in the Earth ’ s
crust. This energy may originate from different sources, such as dislocations of the crust, volcanic
eruptions, or even by man - made explosions or the collapse of underground cavities, such as mines or
karsts. Thus, while earthquakes are defi ned as natural disturbances, different types of earthquake exist:
fault rupture - induced, volcanic, mining - induced and large reservoir - induced. Richter ( 1958 ) has provided
a list of major earth disturbances recorded by seismographs as shown in Figure 1.1 . Tectonic
earthquakes are of particular interest to the structural engineers, and further discussion will therefore
focus on the latter type of ground disturbance.