bore pile design bs 8004

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
Design of Footings
ACI 318-08