Design & analysis · lab & pile workbooks
Lab tests & pile workbooks
Sixteen live calculators for soil, rock and concrete tests and foundation and slope design, each with a matching Excel workbook that shows every formula. Change any blue value and the results update. Example values are illustrative, not from a real site. For learning and preliminary checks only; final design follows AS 2159 and needs a qualified engineer's review.
Single pile capacity: static method
α method in clay, β method in sand, end bearing at the toe. Shaft resistance is shown layer by layer.
| Top m | Bottom m | Soil | γ kN/m³ | cu kPa | β | Nq | fs kPa | Qs kN |
|---|
Static load test: Davisson offset limit
Enter or paste load–settlement readings. The limit load is where the curve crosses s = 4 mm + D/120 + PL/AE.
| Load kN | Settlement mm | Line mm |
|---|
CPT soil behaviour type: Robertson Ic
Paste a sounding (depth m, qc MPa, fs kPa, u2 kPa). Each depth is classified by the soil behaviour type index Ic.
Lab & design workbooks
Excel workbooks for common soil, rock and concrete tests and foundation design checks. Each has a Read me sheet with the method and standard, blue input cells, worked example data and checks.
Method notes & references
- Pile capacity: fs = α·cu in clay with α = 0.5ψ−0.5 (ψ ≤ 1) or 0.5ψ−0.25 (ψ > 1), ψ = cu/σ'v, α ≤ 1; fs = β·σ'v in sand with a limit; qb = 9cu in clay, Nq·σ'v in sand with a limit. API RP 2GEO; Tomlinson & Woodward, Pile Design and Construction Practice.
- Load test: Davisson, M.T. (1972) High capacity piles; ASTM D1143; AS 2159-2009 Section 8.
- CPT: Robertson, P.K. (1990) Soil classification using the cone penetration test, Can. Geotech. J. 27(1); Robertson (2009) Can. Geotech. J. 46(11). Qt uses stress exponent n = 1.