Plate Load Test Report Xls Work Jun 2026

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

Columns for at least two (ideally three or four) dial gauges placed at opposite edges of the plate to measure settlement uniformly.

Use the chart to visually determine the Yield Point (where the curve steepens sharply, indicating shear failure) or extract the stress corresponding to permissible structural settlement bounds. plate load test report xls work

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.

While building your own is educational, many engineers need a turnkey solution. Several reputable geotechnical websites offer free and paid templates. Look for features like: Several professional Plate Load Test (PLT) report templates

in mm), hydraulic jack capacity, gauge calibration factors, and reaction load type. Raw Data Input Table

ks=Stress (q)Settlement (δ)k sub s equals the fraction with numerator Stress open paren q close paren and denominator Settlement open paren delta close paren end-fraction Use conditional formatting ( =G2 ) to highlight

The is a critical geotechnical field investigation method used to determine the ultimate bearing capacity of soil and its probable settlement under a given load . Geotechnical engineers, civil technicians, and project managers heavily rely on Plate Load Test Report XLS work to automate calculations, plot stress-strain curves, and generate client-ready reports directly within Microsoft Excel.

): Calculated based on the elastic settlement formula for a rigid plate on an elastic half-space. 2. Mathematical Formulas for Excel Automation