NABC.XLS

(3/13)

Description

Net Allowable Bearing Capacity of Shallow Foundations on Granular Soil

Estimates the net allowable bearing pressure of a shallow foundation on sand or gravel from the SPT blow count, allowing for the position of the water table. It checks shear failure and settlement, on a calculation sheet with a cover page and a sketch of the water levels.

Method

  • Shear (factor of safety 3): q = 0.105N²BRw′ + 0.314(100 + N²)DRw for square or circular footings, and q = 0.157N²BRw′ + 0.262(100 + N²)DRw for strip footings
  • Settlement of 25 mm, Meyerhof’s equation as modified by Teng: q = 34.5(N − 3)[(B + 0.305)/2B]²kdRw′, with depth factor kd = 1 + D/B ≤ 2
  • Water-table reduction factors Rw = 1 − 0.5da/D and Rw′ = 0.5(1 + db/B)

Inputs

  • Foundation width B, length L and depth D (m)
  • Water level above the foundation base da and below it db (m)
  • SPT N (blows/300 mm)

Outputs

  • Reduction factors, and net pressures from shear (square and strip) and settlement, with working
  • Net allowable bearing capacity (kN/m²), with the governing case flagged

The stored example (B = L = 5 m, D = 1.5 m, N = 17, water 1.85 m below the base) gives 287.2 kN/m² (square, shear), 308.3 kN/m² (strip, shear) and 121.0 kN/m² (settlement): settlement governs at 121.0 kN/m².

Please note

  • The result is the least of all three values, whatever the actual footing shape. Length L is not used.
  • Rw′ is not capped at 1, so enter db no greater than B. Enter da = 0 when the water is below the base, and db = 0 when it is above.
  • The printed working for Rw and Rw′ shows the factor as 0.05; the calculation correctly uses 0.5.
  • SI units. No macros.
  • Reference given by the author: 2006 International Building Code.

Calculation Preview

MIR ABDULALI (ALIMA)
29 Jan 2008
File Size 53.50Kb
Downloads: 805
File Version: 1.1
File Rating (3/13)

 
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: 1
Hello,
Thank you for your allowable bearing capacity calculation. An independent check of your example gave the same square-footing shear value (287.15) and settlement value (121.05) as Page2.
While rewriting the description we found these points on Page2:
- J70 takes the least of the square-footing shear, strip-footing shear and settlement values. The square and strip results are alternative footing shapes, so only the one matching the actual footing should be compared. Because the nested IFs use a strict "