Plate Load Test Report Xls Work Jun 2026
| Load Increment No. | Applied Load (kN) | Dial Gauge 1 (mm) | Gauge 2 (mm) | Gauge 3 (mm) | Time at start (min) | Time at end (min) | |-------------------|------------------|-------------------|--------------|--------------|---------------------|-------------------|
The report should conclude with the determined values for the site:
Maintain a clean, unaltered master template file labeled PLATE_LOAD_TEST_TEMPLATE_V1.0.xltx . Always save project-specific files under unique names to avoid overwriting the base math logic.
A robust PLT Excel workbook should be divided into distinct, organized tabs to separate raw data from final presentation layouts. 1. Project Information Cover Sheet
SBC is often limited by a permissible settlement threshold (e.g., 25 mm). Use extrapolation formulas within Excel to calculate the settlement of the actual foundation size ( ) based on the test plate size ( plate load test report xls work
– Check that the average settlement, pressure, and Kₛ have updated correctly. Look for any obvious outliers (e.g., a dial gauge that was knocked) and decide whether to exclude that reading.
The Plate Load Test involves applying a known load to a steel plate placed at the foundation level and measuring the resulting settlement. The data collected allows engineers to determine:
The test is strictly performed under standards such as ASTM D1194 (withdrawn but still widely referenced), BS 1377-9 , or IS 1888 . Key Engineering Parameters Obtained Ultimate Bearing Capacity (
If the curve is linear (no failure point), we extrapolate. We determine the load corresponding to the allowable settlement (e.g., 12mm). | Load Increment No
The fluorescent lights of the site trailer hummed with a headache-inducing frequency, a perfect harmony to the rhythmic clicking of Elias’s keyboard. On the dual monitors, a spreadsheet sat open—the —its grid of cells as rigid and unyielding as the clay beneath the proposed foundation.
sf=sp⋅(BfBp)s sub f equals s sub p center dot open paren the fraction with numerator cap B sub f and denominator cap B sub p end-fraction close paren For Cohesionless Soils (Sand):
Whether your testing setup utilizes a or a digital load cell .
This is where the becomes your best friend. A robust PLT Excel workbook should be divided
), plate shape (circular or square), and hydraulic jack capacity. 2. Observation Table (Data Entry)
I can provide the exact customized cell equations or macro code snippets needed to finalize your automation script. Share public link
Protect all formula cells, area calculations, and chart ranges. Leave only the metadata header and the raw data input columns unlocked to prevent accidental overwriting of engineering logic.
– Fill in any text fields that are not automated. Add the engineer’s signature and date.