Excel Sheet to Design all Types of Footings

Reinforced concrete foundations, or footings, transmit loads from a structure to the supporting soil.

Footings are designed based on the nature of the loading, the properties of the footing and the

properties of the soil.

Design of a footing typically consists of the following steps:

1. Determine the requirements for the footing, including the loading and the nature of the supported

structure.

2. Select options for the footing and determine the necessary soils parameters. This step is often

completed by consulting with a Geotechnical Engineer.

3. The geometry of the foundation is selected so that any minimum requirements based on soils

parameters are met.

 

  

Download Excel Sheet to Design all Types of Footings Free  

Link

Design of Rectangular Tank Excel Sheet

Design of Rectangular Water Tank Excel Sheet

Storage tanks are built for storing water, liquid petroleum, petroleum products and

similar liquids. Analysis and design of such tanks are independent of chemical nature

of product. They are designed as crack free structures to eliminate any leakage.

Adequate cover to reinforcement is necessary to prevent corrosion. In order to avoid

leakage and to provide higher strength concrete of grade M20 and above is

recommended for liquid retaining structures.

 

  

Download Design of Rectangular Water Tank Excel Sheet Free  

Link

Design Of Spread Footing Excel Sheet

Spread footings are usually designed to use 3 ksi < f'c < 4 ksi, whereas modern structural

members frequently use concrete between the range of 4 ksi < f'c < 8 ksi. A higher concrete

strength helps reduction the member’s size. However, the footing’s design is govern by the

bearing capacity and settlement. That means that the strength of the soil might be limiting

factor, and a higher concrete strength would not be relevant.

 

  

Download Design Of Spread Footing Excel Sheet Free  

Link

Bolts Connection Design Spreadsheet

A bolt is a metal pin with a head formed at one end and shank threaded at the other in order to

receive a nut. On the basis of load transfer in the connection bolts are classified as:

 (a) Bearing Type

 (b) Friction Grip Type

 There are two types of bearing type bolts, namely,

 (i) Unfinished or Black Bolts.

 (ii) Finished or Turned Bolts.

 The shanks of black bolts are unfinished, i.e., rough as obtained at the time of rolling, while

turned bolts are obtained by turning hexagonal shank to circular shape. The bolt hole diameter is

only 1.5 mm larger than that of the shank in case of turned bolt. These bolts are used in special jobs

like connecting machine parts subject to dynamic loadings. For black bolts, diameter of bolt hole is

larger and are used in most of the work

 

  

Download Bolts Connection Design Spreadsheet Free  

Link

Design of Retaining Wall Under Earth Pressure & Other Loads

Retaining Wall is an Excel spreadsheet for the analysis of Retaining Walls subjected to lateral and vertical loads.  Using its analysis results, the wall stem and its base can be sized to have adequate stability and strength for resisting applied loads. Retaining Wall helps save design time by avoiding cumbersome hand calculations. It does not aim to predict the real behaviour which may differ from that generally assumed in routine calculations.  Retaining Wall is therefore a tool to complement the design steps for sizing and detailing such structures.

 

  

Download Design of Retaining Wall Under Earth Pressure & Other Loads Free  

Link

Flat Slab Analysis & Design Spreadsheet

Reinforced  concrete  slabs  are  the  most  important structural component in the construction industry and the most common practice  to design any reinforced concrete slab is to start with the selection of slab type (one  way  slabs,    two  way  slabs,  waffle  slabs,  flat slabs or pre-cast or pre-stressed slabs). The most common  type  of  slabs  used  in  the  construction industry is the flat slab due to the dominancy of slab–column  connection in  the  general  behaviour of  flat slab.  Flat slab  is  also an  ease  for the  contractor  to construct  in shorter  duration.  The flat  slab sections with  regular  column  layout  are  the  most  common type of RC structures in the construction industry and it’s also  the choice for the  contractor  to  construct the building  with  regular  column  layouts.

 

  

Download Flat Slab Analysis & Design Spreadsheet Free  

Link

Design of Combined Foundation With Piles

The first problem facing the designer of a foundation is to determine whether or not the site conditions are such that piles must be used. Piles are used where upper soil strata are compressible or weak; where footings cannot transmit inclined, horizontal, or uplift forces; where scour is likely to occur; where future excavation may be adjacent to the structure; and where expansive or collapsible soils extend for a considerable depth.

 

  

Download Design of Combined Foundation With Piles Free  

Link

Amazing Excel Sheet to Design all Structural Element

Structural design is a key element of all degree and

diploma courses in civil and structural engineering.

It involves the study of principles and procedures

contained in the latest codes of practice for structural design for a range of materials, including concrete, steel, masonry and timber.

 

  

Download Amazing Excel Sheet to Design all Structural Element Free  

Link

Tube / Pipe Column Design Spreadsheet

Further innovations in the flat tube /pipe column method are now being utilized. On-site precast slabs, apartment size or slightly smaller, are being lifted to form the apartment floors. The slabs for another three - s tory, twelve - unit building are supported on bearing walls. The change from the bearing wall to the pipe column type of s u p p o rt will be made on two projects now in the design stage 

  

Download Tube / Pipe Column Design Spreadsheet Free  

Link

Cantilever Retaining Wall Analysis and Design

Purpose of calculation: The details of a cantilever retaining wall are shown below, is the design of the wall satisfactory? Calculation Reference: Craig Soil Mechanics. R.F. Craig Calculation Validation: Check against a worked example in the reference above. 

  

Download Cantilever Retaining Wall Analysis and Design Excel Sheet Free  

Link

Shear Wall Design Based on ACI

shear  wall  is  a structural  system  composed  of  braced  panels  (also known  as  shear  panels)  to  counter  the  effects  of lateral  load  acting  on  a  structure.  Wind  and seismic loads are the most common loads that shear walls  are  designed  to  carry.  Vibrations,  which  are caused  under  the  earth’s  surface,  generate  waves, which  disturb  the  earth’s  surface,  termed  as earthquakes. 

  

Download Shear Wall Design Based on ACI Excel Sheet Free  

Link

Design Of Anchorage For Underground Storage Tanks

Design Of Anchorage For Underground Storage Tanks excel sheet is for the analysis and design of anchorage for underground storage tanks, obviously addressing the concerns of buoyancy. I've had this excel sheet in a partially finished state for quite a while, and I just recently decided to complete it. This is not a subject that we encounter on a regular basis, but if and when you need it, hopefully it will prove to be helpful. 

  

Download Design Of Anchorage For Underground Storage Tanks Excel Sheet Free  

Link

Basement Wall Design Excel Sheet

"Basement walls are structures designed to bound soils between two different elevations. A basement wall is then mainly exposed to lateral pressures from the retained soil plus any other surcharge. Many retaining walls are cantilever-type, but it’s also common to find in practice walls that are laterally restrained at the top, such as in the case of a basement retaining wall supported laterally by an elevated floor slab. This excel sheet provides engineering background for the design of either concrete or masonry top restrained retaining walls. 

  

Download Basement Retaining Wall Design Excel Sheet Free  

Link

Reinforced Concrete Staircases Analysis and Design

"Staircases constitute a very important part of a structure, both architecturally and aesthetically, as well as structurally. They appear in different shape and forms, each requiring

its own method of analysis. Regarding their structural configuration stairs usually fall in ne of the following categories: 

a) Stairs with cantilever steps that are supported on a shear wall

along the stair. 

b) Stairs whose steps are supported on a slab. In this case, the slab with its two landings constitutes one structure with one or three branches. 

c) Stairs whose steps

are supported on two girders, like simply supported beams. 

d) Stairs with free standing landings, with branches perpendicular or parallel to each other (in plan view) .

e) Helical stairs which are supported on the slabs of the upper and lower floors, without intermediate support 

  

Download Reinforced Concrete Staircases Analysis and Design Spreadsheet  

Link

Design of Water Tank Spreadsheet

 Storage reservoirs and overhead tanks are used to store water, liquid petroleum, petroleum products, and similar liquids. The force analysis of the reservoirs or tanks is about the same irrespective of the chemical nature of the product. All tanks are designed as crack-free structures to eliminate any leakage. Water or raw petroleum retaining slabs and walls can be reinforced concrete with adequate cover to the reinforcement. Water and petroleum and react with concrete and, therefore, no special treatment to the surface is required.  

Download Design of Water Tank Spreadsheet Spreadsheet  

Link

Pole Foundation Analysis and Design

"Pole Foundation Analysis and Design spreadsheet is a program written in MS-Excel for the purpose of analysis of a pole foundation

assuming the use of a rigid round pier which is assumed free (unrestrained) at the top and subjected to lateral

and vertical loads.  Specifically, the required embedment depth, the maximum moment and shear, the plain

concrete stresses, and the soil bearing pressures are calculated.

  

Download Pole Foundation Analysis and Design Spreadsheet  

Link

Calculation Of Section Properties Spreadsheet

  Calculation Of Section Properties Spreadsheet is a useful suite of tools for any designer involved in steelwork design or the analysis of existing structures. This unique suite of spreadsheets allows the designer to input a custom section of any shape or size. The spreadsheet then analyses the input custom section and calculates the critical design properties which the designer can then use to analyse the section. This is critical for the design or analysis of altered or fabricated steelwork sections which do not fit with any standard section sizes. 

Download Calculation Of Section Properties Spreadsheet Spreadsheet  

Link

Desilting Basin Design And Calculation Spreadsheet

 This sheet is about the estimation of trap efficiency of desilting basins using a numerical model

program named as SSIIM. SIIM is an acronym for Sediment Simulation in Intakes with

Multiblock Option. It is developed by Dr. Nils Reider B. Olsen, Professor at NTNU, Norway

and complete software is freely available over the net with a user manual. The program is a

stepping stone in the field of Computational Fluid Dynamics (CFD).   

Download Desilting Basin Design And Calculation Spreadsheet Spreadsheet  

Link

Elastic Analysis of Reinforced and Prestressed Sections

 The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis:

For a cross section with any applied axial load at eccentricity e, measured from the compression face, and depth of the neutral axis X below the compression face:

INA = QNA(X + e)

Where QNA and INA are the first and second moments of area about the neutral axis.

To illustrate this relationship the value of INA has been plotted for a range of neutral axis positions for a typical precast bridge beam, shown below, and compared with the value QNA(X + e) for 5 different values of e.

  

Download Elastic Analysis of Reinforced and Prestressed Sections Spreadsheet  

Link

Bridge Abutment Design Solved Example

 Design the fixed and free end cantilever abutments to the 20m span deck shown to carry HA and 45 units of

HB loading. Analyse the abutments using a unit strip method. The bridge site is located south east of Oxford

(to establish the range of shade air temperatures).  

Download Bridge Abutment Design Solved Example Spreadsheet  

Link

Swimming Pool Design Spreadsheet

 The design of the swimming pool is the first step for pool construction. Choose a design suitable for the given land or choose a land area to accommodate a design already planned. The design of the swimming pool mainly involves the shape, depth, area of the pool, the filtration system, and overall size.  

Download Swimming Pool Design Spreadsheet  

Link

Bridge Design for Prestressed Concrete Box Section Spreadsheet

Bridge Design for Prestressed Concrete Box Section

 Bridges are defined as structures which are provided a passage over a gap without closing way

beneath. They may be needed for a passage of railway, roadway, footpath and even for carriage of

fluid, bridge site should be so chosen that it gives maximum commercial and social benefits,

efficiency, effectiveness and equality. Bridges are nation's lifelines and backbones in the event of

war. Bridges symbolize ideals and aspirations of humanity. They span barriers that divide, bring

people, communities and nations into closer proximity. They shorten distances, speed transportation

and facilitate commerce. Bridges are symbols of humanity's heroic struggle towards mastery of forces

of nature and these are silent monuments of mankind's indomitable will to attain it.  

Download Bridge Design for Prestressed Concrete Box Section Spreadsheet  

Link

Elastic Strip Foundation Analysis using Finite Element Method

 The Design Criteria of elastic strip foundation

1. The strip foundation can be reinforced concrete, plain concrete, masonry, steel, or even wood grade beam. But it is assumed elastic 

soil–structure interaction.

2. The soil boundary springs are compression only without tension capacity. But this strip is inadequate for overturning controlled foundation.

3. To check soil capacity, the uniform load, w, should be input net value at the foundation bottom face. But to design strip, the w has to be total gravity value.  

Download Elastic Strip Foundation Analysis using Finite Element Method Spreadsheet  

Link

Calculation Of Live Load Reaction For Abutments Bridges

Calculation Of Live Load Reaction  For Abutments For Bridges

The equivalent heights of soil for vehicular loading on abutments perpendicular to traffic are

as presented in LRFD [Table 3.11.6.4-1] and in Table 12.8-3. Values are presented for various

abutment heights. The abutment height, as used in Table 12.8-3, is taken as the distance

between the top surface of the backfill at the back face of the abutment and the bottom of the  

Download Free Calculation Of Live Load Reaction For Abutments Bridges Spreadsheet  

Link

Hydraulic Ram Design Spreadsheet

A hydraulic ram is a cyclic water pump powered by hydro-power. It takes in water at one "hydraulic head" and

delivers the water at a higher hydraulic head and lower flow rate. The device uses the water hammer effect to develop pressure

that allows a portion of the input water that powers the pump to be lifted to a point higher than where the water is originally

present. The hydraulic ram is used in remote areas especially hilly areas and in the villages which are located at the greater

heights from altitude, where there is both a source of low-head water and a need for pumping water to a destination higher in

elevation than the source. 

Download Free Hydraulic Ram Design Spreadsheet  

Link