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. 

 

  

Download Beams Analysis and Design Spreadsheet Free  

Link

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  

Link

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  

Link

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.

 

  

Download Plain Concrete Footing Design Based on ACI Free  

Link

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

 

  

Download Rectangular Columns Design Excel Sheet Free  

Link

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

 

  

Download RCC Design Of Cable Trench Excel Sheet Free  

Link

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.

 

  

Download Seismic Analysis Excel Sheet Free  

Link