Plate Load Test Report Xls Work !!better!! Now

$$Settlement (mm) = 0.05 \times Load (kN) + 0.2$$

Here's a step-by-step guide to creating a plate load test report in XLS format: plate load test report xls work

Safe bearing capacity: Use settlement corresponding to 5 mm or 1/3 of failure load, whichever is smaller. $$Settlement (mm) = 0

A standard Excel-based PLT report should include these automated calculation fields: plate load test report xls work

Total time: 10 minutes. Total errors: Zero.

In Excel, use FORECAST.LINEAR to interpolate pressure for a given settlement. Example: If allowable settlement is 40mm: =FORECAST.LINEAR(40, Pressure_Range, Settlement_Range)/3

The following steps are typically involved in creating a plate load test report xls work: