Divide the ultimate bearing capacity obtained from the curve by a Factor of Safety (typically 2.5 to 3.0).
To get the most out of your Excel system, follow these practical tips:
From the test, engineers obtain two critical design parameters:
A plate load test (PLT) is a critical in-situ test used to determine the ultimate bearing capacity of soil and its probable settlement under a given load. For geotechnical engineers, project managers, and quality control technicians, processing this field data efficiently is vital. Utilizing a standardized Excel (XLS) workflow transforms raw field measurements into professional, audit-ready engineering reports. 1. Core Objectives of a Plate Load Test Report plate load test report xls work
Plate Load Test DIN 18134 Ev1Ev2 Lab Form specifically for subgrade modulus and deformation testing.
To make your Excel sheet functional, you must program specific cell formulas. Below are the primary equations required: Area of the Bearing Plate ( For a standard circular plate:
If you’ve ever been on a heavy civil or foundation project, you know the drill. The Plate Load Test is the gold standard for determining the bearing capacity and settlement characteristics of soil. But once the hydraulic jack is removed and the settlement dials are packed away, the real work begins: Divide the ultimate bearing capacity obtained from the
A master template ensures every project report follows ASTM D1194 or BS 1377 standards consistently.
Based on permissible settlement (often for foundations). Modulus of Subgrade Reaction (
Ensure that load increments are held for standard intervals (e.g., 15, 30, 60 minutes) or until settlement rates drop below 0.02 mm/min. Use conditional formatting ( =G2 ) to highlight premature readings. Utilizing a standardized Excel (XLS) workflow transforms raw
Excel Formula Example: = (PI() * (Power(Plate_Diameter, 2))) / 4 Applied Stress / Intensity of Pressure (
Save the workbook as Plate_Load_Test_Template.xltx . For each new project, open this template and “Save As” a new file, preserving the original formulas and layout.
Description of soil type at foundation level. B. Input Data (Raw Data Sheet) This section collects data during the test: