Plate Load Test Report Xls Work ((install)) -

You can copy this layout directly into Excel. The workbook should contain at least 3 sheets:

q=Applied Load (kN)Area of Plate (m2)q equals the fraction with numerator Applied Load (kN) and denominator Area of Plate (m squared ) end-fraction plate load test report xls work

| 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 | - | - | You can copy this layout directly into Excel

This macro reduces a 30-minute manual reporting task to 3 seconds. plate load test report xls work

While laboratory tests give us soil parameters, the is the gold standard for determining the ultimate bearing capacity and settlement characteristics of soil in situ.