Pile Capacity Calculation



    Soil Details
        Unit weight of soil (gamma)
        For undrained soils use phi' = 0
        Angle of friction (phi')
        Adhesion Factor
        Angle of friction between pile and soil
        Depth to Water Table
    Pile Details
        ■=Square, ●=Circular
        Diameter of pile
        Depth to base of pile
        Applied load - includes weight of pile
Pile Capacity
    Bearing Capacity Factors
    Overburden stress
    Base Bearing Capacity
    Shaft skin friction
    Vertical Load
    Base Resistance
    Shaft Resistance
    Total ultimate resistance
    Allowable Load
    Overall factor of safety

Calculation Reference
Pile design
Pile Design and Construction Practice

Calculation Preview

Submitted On:
16 Dec 2011
File Size:
21.86 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: 8
Maycel George 2 years ago
I'm sorry.. I'm new here... want to ask.. how to download this file... Thank u
JohnDoyle[Admin] 5 years ago
I don't have an answer to your first question but we do offer some advice regarding Units.
hendrikjs 5 years ago
I am new to this site. I am looking for help in applying the skin friction on a pile to resist wind uplift. I also work in the US so nin-metric would be prefered.
muhamadyusa 6 years ago
many thanks
hades3 9 years ago
BABACAN 11 years ago
You're right. I fixed it and uploaded a corrected file.
JohnDoyle[Admin] 11 years ago
I just noticed that cell BH4 says 'Not a valid pile type'. Looking at the formula it seems an easy one to fix.
JohnDoyle[Admin] 11 years ago
Once again a very cleverly executed spreadsheet Turan. I particularly like how your hyperlinked cells are formated to make then look like buttons.