The actual pressure exerted on the soil, calculated from the gauge force and plate area. 2. Core Geotechnical Calculations & Excel Formulas
In the quiet of the trailer, the spreadsheet felt like a confession. A 0.5mm difference in cell was the gap between a safe structure and a catastrophe buried twenty years in the future. He looked at the "Summary of Results" tab. It was currently a sea of red "FAIL" flags.
If the curve is linear (no failure point), we extrapolate. We determine the load corresponding to the allowable settlement (e.g., 12mm). plate load test report xls work
Manual reduction of geotechnical field data is time-consuming and prone to human error. Developing a standardized Excel template for PLT reports offers several key advantages:
| Col A | Col B | Col C | Col D | Col E | | :--- | :--- | :--- | :--- | :--- | | | 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) | The actual pressure exerted on the soil, calculated
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
| Load (kN) | Settlement (mm) | Time (min) | | --- | --- | --- | | 0 | 0 | 0 | | 50 | 1.2 | 5 | | 100 | 2.5 | 10 | | 150 | 4.1 | 15 | If the curve is linear (no failure point), we extrapolate
He wasn't just filling out a report; he was writing a warning to the future. He hit . The file saved. The truth was locked in the grid, a digital blueprint of integrity against the crushing pressure of a deadline.
A Plate Load Test (PLT) is a crucial in-situ geotechnical test used to determine the ultimate bearing capacity of soil and predict settlement under a given load. Geotechnical engineers, civil site supervisors, and lab technicians frequently require a standardized Excel worksheet ( .xls or .xlsx ) to process raw field data, plot load-settlement curves, and generate professional reports.