Plate Load Test Report Xls Work [verified] Jun 2026

: Tests are often performed according to standards like BS 1377 Part 9: 1990 or ASTM D1194 .

Average of all dial gauge readings for a specific load. Bearing Pressure:

| | | | --- | --- | --- | | Load (kN) | Displacement (mm) | Settlement (mm) | | 10 | 0.5 | 0.2 | | 20 | 1.2 | 0.5 | | 30 | 2.5 | 1.1 | plate load test report xls work

While actual images cannot be displayed here, a typical working screen would show:

Excel Formula Example: = (PI() * (Power(Plate_Diameter, 2))) / 4 Applied Stress / Intensity of Pressure ( : Tests are often performed according to standards

Individual columns for Dial Gauge 1, 2, 3, and 4 (positioned at 90∘90 raised to the composed with power intervals around the plate) measuring displacement in mm.

Set the print area to fit on a single landscape A4 sheet for clean PDF exports and field submissions. Set the print area to fit on a

Use the chart to visually determine the Yield Point (where the curve steepens sharply, indicating shear failure) or extract the stress corresponding to permissible structural settlement bounds.

Using Excel formulas effectively is crucial for a . 1. Calculate Applied Pressure (

A is a critical field test used to determine the Ultimate Bearing Capacity of soil and its probable settlement under a specific load. To "work" a report in Excel (XLS), you must document the incremental application of load and the corresponding settlement over time. Typical Plate Load Test Report Structure (XLS)