Plate Load Test Report Xls Work -

Introduction

Dial Gauge Readings: Usually 2 to 4 gauges are used to account for uneven tilting. 3. Calculations and Formulas plate load test report xls work

Pro Tip: Use data validation to restrict time entries (e.g., 0, 1, 2.5, 5, 10, 15, 30 min intervals). Add a cell for Plate Area (A) and Plate Diameter (B) so pressure auto-calculates: =Load/(PI()*(B/2000)^2) (adjust units as needed). Introduction Dial Gauge Readings: Usually 2 to 4

• X-axis: Settlement (mm) – Note: Engineers often reverse axes; put settlement on X as it is the dependent variable? Actually, always plot Load (Y) vs Settlement (X).
• Y-axis: Pressure (kN/m²) or Load (kN)
• Add a polynomial trendline (order 2 or 3) to smooth the curve.
• Critical: Insert a secondary vertical line at the allowable settlement limit.

Step 3: The Calculations Tab – Automating Key Metrics

Here, bring data from the Input tab using simple cell references. X-axis: Settlement (mm) – Note: Engineers often reverse

Load-Settlement Curve

Step 1: Create the Header (Input Section)

Create a section at the top of your sheet for static data. This feeds your calculations.