You can use the FORECAST or TREND function if the data is roughly linear, or simply interpolate between the two data points bracketing the 12mm mark.
In Excel, use FORECAST.LINEAR to interpolate pressure for a given settlement. Example: If allowable settlement is 40mm: =FORECAST.LINEAR(40, Pressure_Range, Settlement_Range)/3
The plate load test is a widely used field test to determine the bearing capacity of soil and settlement of structures under various loads. The test involves applying a load to a steel plate placed on the soil surface and measuring the resulting settlement. The data collected from the test is then used to create a plate load test report, which is often prepared in Excel format (XLS). In this guide, we will walk you through the process of creating a plate load test report in XLS format.
| 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 Report Xls Work Instant
You can use the FORECAST or TREND function if the data is roughly linear, or simply interpolate between the two data points bracketing the 12mm mark.
In Excel, use FORECAST.LINEAR to interpolate pressure for a given settlement. Example: If allowable settlement is 40mm: =FORECAST.LINEAR(40, Pressure_Range, Settlement_Range)/3
The plate load test is a widely used field test to determine the bearing capacity of soil and settlement of structures under various loads. The test involves applying a load to a steel plate placed on the soil surface and measuring the resulting settlement. The data collected from the test is then used to create a plate load test report, which is often prepared in Excel format (XLS). In this guide, we will walk you through the process of creating a plate load test report in XLS format.
| 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 | - | - |
