Work — Plate Load Test Report Xls

Introduction

$$SBC = \frac\textLoad at Permissible Settlement\textFactor of Safety (usually 2 or 2.5)$$

• Pressure vs. Settlement Curve (Main test)
• Rebound Curve (Unloading cycle) Use dynamic named ranges so the graph updates instantly when you paste new data.

Error #1: Ignoring Plate Size Correction

For Shear Failure:

| Load Increment | Load (kN) | Pressure (kN/m²) | Dial Gauge 1 (mm) | Gauge 2 (mm) | Gauge 3 (mm) | Time Elapsed (min) | |----------------|-----------|------------------|-------------------|--------------|--------------|---------------------| plate load test report xls work

Load-Settlement Curve

To visualize the soil's behavior, plot a using a "Scatter with Smooth Lines" chart in Excel: X-axis: Load Intensity ( kN/m2kN/m squared or kg/cm2kg/cm squared ). Y-axis: Average Settlement ( ). Pressure vs