The visual output of the test. Excel creates an XY Scatter Plot representing the . X-Axis: Applied Stress / Bearing Pressure (kPa).
) ensures safety against shear failure, while the Modulus of Subgrade Reaction (
Allows easy sharing between site engineers, laboratory technicians, and clients. Standard Structure of a PLT Excel Report
The arithmetic mean of the dial gauge readings for each increment. plate load test report xls work
: Calculated by dividing the failure load by the plate area.
From the test, engineers obtain two critical design parameters:
A chronological log of load increments, time intervals, and settlement readings. The visual output of the test
Sample rows:
Suppose a plate load test on a cohesionless soil yields a settlement of 10 mm for the 450 mm square test plate. You need to estimate the settlement for a 2 m wide footing under the same pressure. In Excel:
Automatic calculation of settlement as soon as raw data is entered. Accuracy: Reduces manual calculation errors. ) ensures safety against shear failure, while the
By embedding these formulas once, the entire workbook becomes a reusable template.
Such a layout communicates professionalism to clients and regulators alike.
In Excel, you can use formulas to automate the derivation of soil properties.
For purely cohesive soils, the bearing capacity is independent of the plate size:
– 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.