Ensure that for each load increment, settlement readings are taken at the intervals specified by your project guidelines (e.g., 1, 2, 4, 8, 15, 30, and 60 minutes) until the rate of settlement slows to less than 0.02 mm/min. Input the final stabilized values into your main computation table.
A well-organized Excel sheet should systematically capture the following raw and calculated parameters during the test:
Use data validation to restrict time entries (e.g., 0, 1, 2.5, 5, 10, 15, 30 min intervals). Add a cell for Plate Area (A) and Plate Diameter (B) so pressure auto-calculates: =Load/(PI()*(B/2000)^2) (adjust units as needed).
Equipment specifications (diameter of the bearing plate, hydraulic jack capacity, and dial gauge calibration factors). Raw Data Entry Matrix plate load test report xls work
| Load (kN) | Settlement (mm) | Time (min) | | --- | --- | --- | | 0 | 0 | 0 | | 50 | 1.2 | 5 | | 100 | 2.5 | 10 | | 150 | 4.1 | 15 |
| | | | --- | --- | | Bearing Capacity | 150 kPa | | Settlement | 2.5 mm |
higher or lower than the other three, program the cell to turn red. This alerts the engineer to potential plate tilt or instrument malfunction. Ensure that for each load increment, settlement readings
Step-by-Step Guide to Creating the Excel Calculation Workflow
In geotechnical engineering, determining the bearing capacity of soil is paramount for the stability of structures. The (PLT) is a field test performed to evaluate the ultimate bearing capacity of ground and the probable settlement under a given load, following standards such as ASTM D1194 or ASTM D1195 .
Choose an XY Scatter Chart with Smooth Lines and Markers . Add a cell for Plate Area (A) and
To map the hydraulic pressure reading to actual force applied to the bearing plate, use the cross-sectional area of the hydraulic jack ram:
Here's a step-by-step guide to creating a plate load test report in XLS format:
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.