Plate Load Test Report Xls Work Jun 2026

Plate Load Test for Soil Bearing Capacity | PDF | Column - Scribd

Ks = (Pressure at 1.25mm settlement) / 1.25 (Unit: kN/m³) In Excel: =INDEX(Pressure_Range, MATCH(1.25, Settlement_Range, 1))/1.25

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) plate load test report xls work

SBC=UBCFactor of Safety (FOS)SBC equals the fraction with numerator UBC and denominator Factor of Safety (FOS) end-fraction Note: FOS typically ranges from to . 4. Load-Settlement Curve (Excel Graphing)

If a plate smaller than 75 cm is used, a correction factor is applied to the value to simulate full-scale foundation behavior. Resource Links Plate Load Test for Soil Bearing Capacity |

Use OFFSET and COUNTA functions so your charts automatically expand when you add more load increments.

Typical table:

| | | | --- | --- | --- | | Load (kN) | Displacement (mm) | Settlement (mm) | | 10 | 0.5 | 0.2 | | 20 | 1.2 | 0.5 | | 30 | 2.5 | 1.1 |