The total downward movement at the end of each loading stage. 2. Essential Formulas for the Excel Workflow
The predetermined engineering stress intervals (in Gauge Pressure: The actual hydraulic jack gauge reading (in Applied Load: The calculated force exerted on the plate (in
Right-click the Y-axis, select Format Axis , and check the box for "Values in reverse order" . Geotechnical custom dictates that settlement plots downward. 4. Determining Bearing Capacity via Excel Data
Protect worksheets so that field technicians can only modify the metadata inputs and raw dial gauge cells. This preserves the core equations ( SUM , AVERAGE , PI() ) from accidental deletion. plate load test report xls work
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.
The curve keeps sinking without a distinct break; in this case, the bearing capacity is taken at 10% settlement of the plate width. Pro Tip for Excel Users:
He clicked into cell . The dial gauge readings were trending toward a "plunging failure." If he logged the truth, the project stalled. The $400-million-dollar development would freeze, and the foreman, a man whose neck was the color of a sunset and whose temper was just as volatile, would have Elias’s head. The total downward movement at the end of each loading stage
Identified as the point where the load-settlement curve breaks or settlement increases rapidly. Safe Bearing Capacity (SBC):
The point where the curve becomes vertical (or near-vertical) indicates the ultimate failure point. 5. Final Reporting & Conclusions
= (PI() * (Plate_Diameter_mm / 1000)^2) / 4 (Outputs area in m²) Applied Stress / Intensity ( Geotechnical custom dictates that settlement plots downward
If you are conducting these tests regularly, having a customized Excel template that includes built-in formulas and automatic charting will significantly improve the accuracy and speed of your analysis.
I can write out the specific or macro code for your workbook. Share public link