Fixed Steel Column Base Design Excel Sheet 

Column base plate connections are the critical interface between the steel and concrete structures or foundations since their behavior greatly influences the performance of steel structures in terms of the distribution of moments, forces, and displacements.

LINK

 Concrete Box Culvert analysis and Design Excel Sheet 

Box culverts are the structures that are used when the path of water in the natural stream crosses roads, railway lines, flyovers, etc. They are normally cheaper than bridges, which make them the natural stream passes through channels.

Concrete Box Culvert analysis and Design Excel Sheet

LINK

 ASCE Beam End Connection Excel Sheet 

"BEAMTAB" is a spreadsheet program written in MS-Excel for the purpose of analysis of steel beam end connections using a beam tab (single plate) field bolted to the beam web and shop welded to either the column flange, column web, or girder web.  The connections may be subjected to end shear reaction and/or axial load. Specifically, all applicable "limit states" for the end connection analysis pertaining to the beam tab (single plate), bolts,  beam web, and either column flange or web, or girder web are checked.

ASCE Beam End Connection Excel Sheet

LINK

 Cylindrical Tank with Domed Roof Calculator Excel Sheet 

The formula for the volume of a cylinder is V=Bh or V=πr2h. Cylindrical tanks constructed with domed or coned roofs, which operate at pressures above 15 psia (1 Bar) but are still relatively close to atmospheric pressure, can be built according to API Standard

Cylindrical Tank with Domed Roof Calculator Excel Sheet

LINK

 Continuous Beam Analysis & Design Spreadsheet According to BS Code 

The method of superposition is used to represent a continuous beam by the appropriate single-span beams (each span by two propped cantilevers and one simply supported beam). Simple expressions are presented to determine the equivalent load on each of the substituent beams.

Continuous Beam Analysis & Design Spreadsheet According to BS Code

LINK

 Elevated Water Tank Design Excel Sheet 

Elevated water tanks are used to store water for fire protection and potable drinking water within a designated area or community. Elevated tanks allow the natural force of gravity to produce consistent water pressure throughout the system.

Download Elevated Water Tank Design Excel Sheet

LINK

 Pressure Tank Calculating Excel Sheet 

Pressure tank size formula is given as follows :

size = ((Drawdown volume/cut-out pressure - cut-in pressure)/ cut-out pressure + 1)

The drawdown is based on pump capacity and the number of start/stops per hour and the amount of water that can be taken from the tank before the pump starts.

Download Pressure Tank Calculating Free Excel Sheet

LINK

 Wall Pier Design Spreadsheet 

A pier, in architecture, is an upright support for a structure or superstructure such as an arch or bridge. Sections of structural walls between openings (bays) can function as piers.

Download Wall Pier Design Free Spreadsheet

LINK

 Composite Collector Beam Design with Seismic Loads Excel Sheet 

DESIGN CRITERIA

1.  When welded shear connectors are used for the transfer of lateral shear loads to drags/collectors, the allowable shear strength maybe 75% of the available strength for both gravity and lateral design (ACI 318-14 Chapter 17), to consider concrete cracked at lateral loads.

2.  The input STUDS SPACING must be based on actual deck ribs spacing perpendicular to the beam. For the following total [15] studs, if ribs

Download Composite Collector Beam Design with Seismic Loads Excel Sheet

LINK