Xls Work - Plate Load Test Report

Several professional Plate Load Test (PLT) report templates and Excel-based calculation sheets are available to help automate soil bearing capacity analysis based on standards like ASTM D1194 Excel Templates & Workbooks

Average Settlement (mm):

The mean value of the dial gauge readings for each stage. 3. Automated Calculations plate load test report xls work

Step 6: Preparing the Report

Scatter Plot with Smooth Lines

The most critical output. Use Excel’s . X-Axis: Settlement (mm). Y-Axis: Load/Pressure ( Several professional Plate Load Test (PLT) report templates

Allowable Bearing Capacity:

The safe load considering a factor of safety. Modulus of Subgrade Reaction ( Draw two tangents on the Load-Settlement curve:

Phase 4: Analysis & Result Formulas

1. Draw two tangents on the Load-Settlement curve: