Plate Load Test Report Xls Work [work] (TRUSTED)

All formulas should be dragged down the table. Use conditional formatting (e.g., highlight cells where settlement exceeds 25 mm) to quickly flag critical points.

Allows easy sharing between site engineers, laboratory technicians, and clients. Standard Structure of a PLT Excel Report

Although dedicated geotechnical software exists, Microsoft Excel remains the most accessible, flexible, and widely accepted tool for the following reasons:

Identified as the point where the load-settlement curve breaks or settlement increases rapidly. Safe Bearing Capacity (SBC): plate load test report xls work

Add rows for each load step (typically 8–12 increments). Leave the calculation columns for other sheets.

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

Convert raw load into pressure based on a 300mm plate ( ). =B2 / 0.07068 All formulas should be dragged down the table

| Parameter | Value | Unit | Formula / Note | |-----------|-------|------|----------------| | | BH-01 | - | Input | | Plate diameter | 300 | mm | Input | | Plate area | 0.0707 | m² | =PI()*(0.3/2)^2 | | Max load applied | 100.0 | kN | Input | | Max pressure | 1414.2 | kPa | =Max Load / Area | | Settlement at max load | 5.80 | mm | From Sheet 2 | | Safe bearing capacity (SBC) | 282.8 | kPa | At 5 mm settlement (or 1/3 of failure) | | Modulus of subgrade reaction (K) | 48.8 | kN/m³ | =Pressure / Settlement (in meters) | | Modulus of elasticity (E_plate) | 15.2 | MPa | From initial linear slope | | Remarks | Soil: Sandy Silt, dry | - | - |

Plate Load Test Sample Form for logging applied load, pressure, and dial gauge readings.

where FOS (factor of safety) is typically taken as 2 to 3, depending on the project. Standard Structure of a PLT Excel Report Although

Because the summary values are formulas that pull from Sheet 2, they update automatically when raw data changes. The chart also updates dynamically if it is based on a named range or Excel Table.

This section uses Excel formulas to process the raw field data. It transforms raw pressure and gauge movements into standardized geotechnical parameters: Average Settlement ( Δcap delta