Bored Piles For The Analysis of Layered Soil.xlsx



Pile Details
  • Dimensions
  • Concrete
  • Steel

  • 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
File Version:
File Author:
Turan Babacan

Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 14
khaldoun 4 months ago
Dear Author,
would you please clarify what the (n & Cm) means in your excel sheet
geotekdemir 1 year ago
Thanks for sharing.
awdwas 1 year ago
me too
ahmedelmaghaoury 2 years ago
i wa this sheet
bm212 8 years ago
Very good Spreadsheet
It would be nice though if the spreadsheet could switch between Metric and English units
BABACAN 8 years ago
Pile Analysis&Design 1.5
- Pile head beams accounts and details
- report
- Some improvements
added ...
hades3 9 years ago
Excellent work!
maly 9 years ago
do you have it in US units please?
BABACAN 10 years ago
VERSION 1.4 Kh control, visual corrections
BABACAN 11 years ago
Turan sent through an update to his calculation.
BABACAN 11 years ago
rdivito Thank you. problem is corrected.
ver 1.2
rdivito 11 years ago
Program yields zero response when all extra cap loads are removed but lateral earth and surcharge pressure remains.
BABACAN 11 years ago
visual menu has changed some of the actions
JohnDoyle[Admin] 11 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.