Input the field data systematically. The test typically applies load in cumulative increments (e.g., 20%, 40%, 60%, 80%, 100%, and up to 150% or 200% of the proposed design load).
ks=qδk sub s equals the fraction with numerator q and denominator delta end-fraction
Average Settlement (Δ)=DG1+DG2+DG3+DG44Average Settlement open paren cap delta close paren equals the fraction with numerator DG sub 1 plus DG sub 2 plus DG sub 3 plus DG sub 4 and denominator 4 end-fraction plate load test report xls work
Keep a clean master file named PLATE_LOAD_TEST_TEMPLATE_REV0.xltx . Save individual testing files separately under specific project identifiers (e.g., PLT-REPORT-PIT03-JOB2026.xlsx ) to prevent corruption of your core reporting framework.
The curve will show a clear break or peak point where settlement rapidly increases without additional load. The stress at this break point is your ultimate bearing capacity. Input the field data systematically
| Ultimate Bearing Capacity (kPa) | Allowable Bearing Capacity (kPa) | Safety Factor | | --- | --- | --- | | 250 | 125 | 2 |
This macro reduces a 30-minute manual reporting task to 3 seconds. | Ultimate Bearing Capacity (kPa) | Allowable Bearing
Recorded in tons, kilonewtons, or bar.
| Column A | Column B | Column C | |----------|----------|----------| | | Settlement (mm) | Settlement (mm) - corrected |
Managing this data efficiently requires structured . Excel spreadsheets enable rapid calculation of settlement, bearing capacity, and plotting of load-settlement curves, crucial for geotechnical reporting. 1. Understanding the Plate Load Test Method
Lock all formula cells, area calculations, and chart references. Leave only the metadata fields and the raw dial gauge columns unlocked for data entry.