The report is a formal document that translates raw field measurements into actionable engineering data. It confirms whether the ground can safely support structures such as building foundations, crane outriggers, or piling rigs. Core Components of the Report:
Load vs Settlement 12-xlsx Group for documenting multiple test points.
| 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 | - | - |
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. plate load test report xls work
What specific you are tailoring the report to (e.g., ASTM, BS, or IS codes).
Based on the settlement criteria (e.g., 10% of plate diameter or 5mm), your XLS should automatically:
Formula in F2: =AVERAGE(D2:E2) and drag down. The report is a formal document that translates
He clicked into cell . The dial gauge readings were trending toward a "plunging failure." If he logged the truth, the project stalled. The $400-million-dollar development would freeze, and the foreman, a man whose neck was the color of a sunset and whose temper was just as volatile, would have Elias’s head.
You can copy this layout directly into Excel. The workbook should contain at least 3 sheets:
Where plate_area_m² is calculated from the plate dimensions (e.g., = Bp^2 for a square plate of side Bp in meters). | Parameter | Value | Unit | Formula
A plate load test generates too much data to trust to manual calculations. Whether you are following IS 1888, ASTM D1194, or BS 1377, a well-structured eliminates human error, enforces your local code standard, and makes you look like a hero in the morning site meeting.
Using Excel formulas effectively is crucial for a . 1. Calculate Applied Pressure (
From the test, engineers obtain two critical design parameters:
In geotechnical engineering, settlement is plotted downward. Right-click the Y-axis -> Format Axis -> Check the box for "Values in reverse order" .
