You might ask: Why not use dedicated geotechnical software like gINT or Plaxis?
Answer: Cost and flexibility. An Excel (XLS) workflow is:
| Column A | Column B | Column C | |----------|----------|----------| | Pressure (kN/m² = kPa) | Settlement (mm) | Settlement (mm) - corrected | plate load test report xls work
Formula for pressure:
Pressure = Load / (π × (Plate Dia/2)²)
Example: Plate diameter = 300 mm (0.3 m), area = 0.0707 m²
In B2: =Load / 0.0707
Typical table:
| Pressure (kPa) | Settlement (mm) | Corrected Settlement | |----------------|----------------|----------------------| | 0 | 0.00 | 0.00 | | 70.7 | 0.11 | 0.11 | | 141.4 | 0.27 | 0.27 | | 282.8 | 0.63 | 0.63 | | 565.7 | 1.38 | 1.38 | | 848.5 | 2.50 | 2.50 | | 1131.4 | 4.00 | 4.00 | | 1414.2 | 5.80 | 5.80 |
[e.g., Silty Sand, Dense Gravel, or Highly Compressible Clay] Test Depth: [Insert Depth in meters below ground level] Standard Followed: [e.g., ASTM D1194, BS 5930, or IS 1888:1982] Section 2: Equipment Specifications PLATE LOAD TEST REPORT - JICA Report PDF You might ask: Why not use dedicated geotechnical
This guide provides a detailed walkthrough on how to create, structure, and automate a Plate Load Test Report using Microsoft Excel.
The Plate Load Test (PLT) is used to determine the bearing capacity of soil and the settlement characteristics under a given load. Excel is the industry standard for this because it handles the repetitive calculations and graphical plotting required for the report. A report without a graph is just a spreadsheet
A report without a graph is just a spreadsheet. Your XLS should automatically generate two plots: