Plate Load Test Report Xls Work
Several professional Plate Load Test (PLT) report templates and Excel-based calculation sheets are available to help automate soil bearing capacity analysis based on standards like ASTM D1194 Excel Templates & Workbooks
- Load vs. Settlement Curve (Primary graph)
- Settlement vs. Time Curve (For consolidation behavior)
- Safe Bearing Capacity (SBC) – Calculated using the settlement criteria (e.g., 40mm or 1/10th of plate width)
- Modulus of Subgrade Reaction (Ks) – For rigid pavement design
- Modulus of Deformation (E) – From the initial linear portion of the curve
- Input – Raw field data.
- Calculations – Processed data, corrections, SBC.
- Charts – Embedded graphs.
- Summary – Final report formatted for printing.
- Standards – Reference values (e.g., IS 6403 or AASHTO factors).
Mastering the Plate Load Test: How to Create a Professional Report in Excel (XLS)
In the realm of geotechnical engineering, theory often meets reality at the bottom of a pit. Before a massive foundation is poured or a heavy pavement is laid, we need to know one thing with certainty: Can the soil take the load? plate load test report xls work
Formula in F2: =AVERAGE(D2:E2) and drag down. Several professional Plate Load Test (PLT) report templates
Plate Load Test Report XLS Work
The Ultimate Guide to Plate Load Test Report XLS Work: A Comprehensive Overview Load vs
Sample rows:
- Ultimate Bearing Capacity ($q_u$) = Failure pressure read from the graph.
- Safe Bearing Capacity ($q_s$) = $q_u$ / Factor of Safety (FOS usually 2.0 or 2.5).