Plate Load Test Report Xls Work

Do you have a specific plate load test spreadsheet that you have developed? Share your experiences or questions in the comments below!

Before entering test data, fill in the plate diameter (e.g., ) and the calibration factors of your instruments.

ASTM D1194 (Static Load), ASTM D1195/D1196 (Repetitive Pavement Tests).

Load increments, gauge readings (settlement), and time intervals. plate load test report xls work

A professional PLT Excel template ( .xls or .xlsx ) is built on three interconnected sheets designed for maximum efficiency. Each sheet serves a distinct purpose, and they work together to transform raw data into a polished report. The ideal workflow progresses logically from data entry to analysis, and finally to the final client-ready document.

To get the most out of your Excel system, follow these practical tips:

He clicked into cell . The dial gauge readings were trending toward a "plunging failure." If he logged the truth, the project stalled. The $400-million-dollar development would freeze, and the foreman, a man whose neck was the color of a sunset and whose temper was just as volatile, would have Elias’s head. Do you have a specific plate load test

The most critical output of a Plate Load Test report is the . Visualizing this properly requires specific chart configurations. Plotting the Load-Settlement Curve

| Load (kN) | Avg Settlement (mm) | |-----------|---------------------| | 0 | 0.00 | | 10 | 0.85 | | 20 | 2.10 | | 40 | 4.50 | | 60 | 7.80 | | 80 | 12.50 | | 100 | 20.00 | | 120 | 34.00 (stopped) |

A standard PLT report must include:

The stress distributed to the soil is the applied force divided by the area of the testing plate:

Test pit number, coordinates, reduced level (RL), and depth of the test stratum. Equipment Specifications: Diameter of the bearing plate (

The plate load test involves placing a rigid steel plate (typically 300 mm to 600 mm in size) at the foundation level and applying incremental loads using a hydraulic jack. The corresponding settlement of the plate is measured using three dial gauges placed symmetrically. The load is increased until either the plate settles excessively (a rapid rate of settlement defines failure) or a pre‑determined settlement limit (e.g. 25 mm) is reached. Each sheet serves a distinct purpose, and they

: Loads are applied in equal steps (e.g., 0.08 MN/m²) at set intervals until maximum load or rapid settlement occurs.