Pile Capacity from SI Data

This spreadsheet allows the user to estimate the ultimate load capacity of a pile using data obtained from an onsite test, either a Standard Penetration Test (SPT) or a Cone Penetration Test (CPT). These tests are often undertaken during site investigation works in advance of a piling design. They are also sometimes done as part of more general site investigation works, so suitable information may be available at the preliminary stages of a pile design project.

The spreadsheet includes a total of 9 different methodologies including those specified in the British Standard BS 8004. The full list of spreadsheets is given below;

  • CPT – BS Method
  • CPT – European Method – Cohesionless
  • CPT – European Method – Cohesive
  • CPT – Schmertmann – Cohesionless
  • CPT – Schmertmann – Cohesive
  • SPT – BS Method
  • SPT – (Meyerhof Method – Cohesionless)
  • SPT – (O’Neill & Reese Method – Cohesionless Soils)
  • SPT – Pressure Injected Footing (Cohesionless)

Pile Capacity from SI Data


License Type








Enter your email address below for a free trial version of this spreadsheet.


Pile Driving Formulas

Pile Design from SI Info

Pile Design from Geotechnical Info

Laterally Loaded Pile Design

Pile Settlement Analysis

Pile Group Analysis

Negative Skin Friction Analysis

Ice Jacking Force

Out of Plumb Pile Loadings