Tag: Excel Sheet

RETWALL – Retaining Wall Under Earth Pressure and Other Loads

RETWALL – Retaining Wall Under Earth Pressure and Other Loads

 

RetWall 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.

RetWall 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 routiine calculations.

RetWall is therefore a tool to complement the design steps for sizing and detailing such structures.

 

Download Link

Excel Sheet Culvert Box calculation and drawing

Excel Sheet Culvert Box calculation and drawing

 

A culvert box is an essential component of any roadway infrastructure. It is a type of drainage structure designed to channel water under a roadway or other transportation facility.

Culvert boxes are typically constructed from reinforced concrete and are available in a variety of shapes and sizes, including circular, oval, and rectangular. They are a critical element in maintaining safe and reliable transportation systems, preventing flooding and erosion, and protecting the environment.

 

Download Link

 

Suggested Read:

Reinforced Concrete Box Culvert Calculation Spreadsheet

Standard DWG Autocad Drawing For Box Cell Culvert

Pipe Culvert Wing Wall CAD template DWG

Culvert General Plan and Sections Details CAD Template DWG

Box Culvert Curved Concrete Layout CAD Template DWG

Box Culvert Concrete Reinforcement Details CAD Template DWG

Culvert Concrete Reinforcement Details CAD Template DWG

Box Culvert Design and Calculation Spreadsheet

 

 

Cantilever Retaining Wall Analysis Excel Sheet

Cantilever Retaining Wall Analysis Excel Sheet

 

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.

Calculation Parameters :

 

  • Surcharge Pressure
  • Thickness of the Stem
  • Thickness of the Base
  • Length of Backfill
  • Height of Wall from the Base
  • Width of the Base
  •  Characteristics of Backfill
  • Drained (effective stress) Shear Strength Parameter
  • Unit Weight of the backfill
  • Drained (effective stress) Shear Strength Parameter
  • Characteristics of Concrete
  • Unit Weight of Concrete
  • Angle of friction between the base and the foundation soil is
  • Active earth pressure coefficient
  • Horizontal Forces
  • Sum of Horizontal Forces
  • Vertical Forces
  • Sum of Vertical Forces
  • Lever
  • Moments
  • Lever arm of base resultant
  • FoS against overturning
  • Eccentricity of base reaction
  • Maximum and minimum base pressures
  • FoS against sliding

Calculation Reference
Geotechnics

Download Link

Bore Pile Design BS 8004 Excel Sheet

Bore Pile Design BS 8004 Excel Sheet

 

Spreadsheet to calculate pile bearing capacity of drilled shaft foundation – bore pile according to BS 8004. For preliminary design purposes, BS 8004 gives presumed bearing values which are the pressures which would normally result in an adequate factor of safety against shear failure for particular soil types, but without consideration of settlement.

Category Types of rocks and soils Presumed bearing value
Non-cohesive soils Dense gravel or dense sand and gravel >600 kN/m²
Medium dense gravel,
or medium dense sand and gravel		 <200 to 600 kN/m²
Loose gravel, or loose sand and gravel <200 kN/m²
Compact sand >300 kN/m²
Medium dense sand 100 to 300 kN/m²
Loose sand <100 kN/m² depends on
degree of looseness
Cohesive soils Very stiff bolder clays & hard clays 300 to 600 kN/m²
Stiff clays 150 to 300 kN/m²
Firm clay 75 to 150 kN/m²
Soft clays and silts < 75 kN/m²
Very soft clay Not applicable
Peat Not applicable
Made ground Not applicable

Calculation Reference
Reinforced Concrete Design

Download Link

error: Content is protected !!
Exit mobile version