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?
While laboratory tests give us soil parameters, the Plate Load Test (PLT) is the gold standard for determining the ultimate bearing capacity and settlement characteristics of soil in situ.
But once the jack is released and the dial gauges are packed away, the real work begins: Data Analysis. plate load test report xls work
In this guide, we will walk through the process of analyzing Plate Load Test data and generating a comprehensive, professional report using Microsoft Excel (XLS).
The core of the XLS report is the visual representation. You need two specific charts. In the realm of geotechnical engineering, theory often
We will structure the workbook into three main sections: Header Info, Calculation Table, and Graphs.
Based on the settlement criteria (e.g., 10% of plate diameter or 5mm), your XLS should automatically: The core of the XLS report is the visual representation
This is the heart of your XLS work. Create a tab named "Calculations" and structure your columns as follows:
| Col A | Col B | Col C | Col D | Col E | | :--- | :--- | :--- | :--- | :--- | | Load Step | Pressure (kPa) | Total Load (kN) | Dial Gauge Reading (mm) | Settlement (mm) | | 1 | 0 | 0 | 0.00 | 0.00 | | 2 | 25 | (Formula) | (Input) | (Formula) | | 3 | 50 | (Formula) | (Input) | (Formula) |
It is not just about typing numbers into cells. Professional "XLS work" for PLT includes: