Bored Piles For The Analysis of Layered Soil.xlsx

Rating:
41

Description


Pile Details
  • Dimensions
  • Concrete
  • Steel

Loads
  • Exta loads
  • Soil loads

Soil Details
  • Layer 1
  • Layer 2
  • Layer 3
  • Layer 4

Forces Diagrams
  • Moment
  • Shear
  • Soil pressure
  • Axial

Deflections Diagrams
  • Horizontal
  • Vertical
  • Slope

Pile Lateral Capacity
  • Ultimate horizontal load capacity
  • Ultimate Moment capacity
  • Maximum pile head displacement

Pile Axial Capacity
  • Bearing Capacity Factors
  • Base Resistance
  • Shaft Resistance

Checks and Design
  • Shear Capacity
  • Mechanical reinforcement ratio
  • (m-n) interaction diagram


Solved using finite element methods

Related calculation for single layer.

Calculation Reference
Design of Concrete Piles
Reinforced Concrete Design
Civil Engineering Handbook

Calculation Preview

Submitted On:
15 Aug 2014
File Size:
420.29 Kb
Downloads:
824
File Version:
1.5
File Author:
Turan Babacan
Rating:
41

 
This download is for Registered Users Only.
Perhaps you need to login or register.
Comments: 11
ahmedelmaghaoury 25 days ago
i wa this sheet
bm212 6 years ago
Babacan
Very good Spreadsheet
It would be nice though if the spreadsheet could switch between Metric and English units
BABACAN 7 years ago
Pile Analysis&Design 1.5
- Pile head beams accounts and details
- report
- Some improvements
added ...
hades3 7 years ago
Excellent work!
maly 8 years ago
do you have it in US units please?
BABACAN 9 years ago
VERSION 1.4 Kh control, visual corrections
BABACAN 10 years ago
Turan sent through an update to his calculation.
BABACAN 10 years ago
rdivito Thank you. problem is corrected.
ver 1.2
rdivito 10 years ago
Program yields zero response when all extra cap loads are removed but lateral earth and surcharge pressure remains.
BABACAN 10 years ago
visual menu has changed some of the actions
JohnDoyle[Admin] 10 years ago
Another Turkish delight from Turan! This calculation extends the functionality of a previous calculation to allow for 4 separate soil layers. Be aware that this file only works in Excel 2010 due to limitations of matrix functions in Excel 2003.