Plate Load Test — Report Xls Work
S=D1+D2+D33cap S equals the fraction with numerator cap D sub 1 plus cap D sub 2 plus cap D sub 3 and denominator 3 end-fraction 3. Modulus of Subgrade Reaction ( value is used for designing foundations on elastic soils:
Several professional Plate Load Test (PLT) report templates and Excel-based calculation sheets are available to help automate soil bearing capacity analysis based on standards like ASTM D1194 Excel Templates & Workbooks
Applied pressure or force reading from the hydraulic pump gauge.
Find the clear break point where settlement increases rapidly with little to no added load. plate load test report xls work
which features load settlement conclusions and Factor of Safety (F.S.) applications. Core Calculation Requirements
In geotechnical engineering, field data must be processed accurately to avoid catastrophic foundation failures. An Excel workbook serves as a powerful calculator and reporting tool for several key reasons:
A Plate Load Test (PLT) is a critical in-situ geotechnical test used to determine the ultimate bearing capacity of soil and its expected settlement under a given load. Geotechnical engineers, civil inspectors, and project managers rely heavily on structured data to interpret these test results accurately. S=D1+D2+D33cap S equals the fraction with numerator cap
), shape of the plate (usually circular or square), plate thickness, and hydraulic jack capacity.
Load increments, gauge readings (settlement), and time intervals.
A report or "paper" on the focuses on determining the ultimate bearing capacity and settlement behavior of soil for foundation design. For professionals working with Excel ( .xls ) files for calculations, the workflow typically includes recording load-settlement data in the field and processing it to find the Safe Bearing Capacity (SBC) . Core Components of a Plate Load Test Report which features load settlement conclusions and Factor of
We will structure the workbook into three main sections: , Calculation Table , and Graphs .
Final settlement for each load stage. Modulus of Subgrade Reaction ( ): D. Graphical Representation
): The average reading from two to four dial gauges placed around the perimeter of the test plate, measured in millimeters (mm). Structure of an Automated Excel Workbook ( .xls / .xlsx )
This is the "Work" part of the XLS file, where formulas process the raw data: Converted from pressure gauge readings. Pressure (kN/m² or kPa):
: Offers a dedicated Bearing Capacity from Plate Load Test Spreadsheet which estimates soil settlement and allowable bearing capacity using procedures outlined in BS 8004 .
