Plate Load Test Report Xls Work | Working

The plate load test remains one of the most widely used in-situ field tests for determining the ultimate bearing capacity of soil and predicting settlement beneath an imposed load. However, processing the raw test data into a professional, submission-ready report can be a repetitive and error-prone task if done manually. This is where Excel proves its worth. A well-structured Excel workbook not only saves hours of calculation time but also ensures consistency, reduces human error, and delivers a polished output that meets regulatory standards.

The plate load test involves placing a rigid steel plate (typically 300 mm to 600 mm in size) at the foundation level and applying incremental loads using a hydraulic jack. The corresponding settlement of the plate is measured using three dial gauges placed symmetrically. The load is increased until either the plate settles excessively (a rapid rate of settlement defines failure) or a pre‑determined settlement limit (e.g. 25 mm) is reached.

Create a section at the top of your sheet for static data. This feeds your calculations.

Safe bearing capacity: Use settlement corresponding to 5 mm or 1/3 of failure load, whichever is smaller. plate load test report xls work

Document any anomalies – a sudden jump in settlement, a dial gauge that needed resetting, or rain during the test. Good notes improve the report’s credibility.

sf=sp⋅(BfBp)s sub f equals s sub p center dot open paren the fraction with numerator cap B sub f and denominator cap B sub p end-fraction close paren For Cohesionless Soils (Sand):

If no clear break point exists, the ultimate capacity is often defined as the pressure corresponding to a settlement equal to 10% of the plate diameter. Use Excel's INDEX and MATCH formulas to find or interpolate this value. Safe Bearing Capacity ( qsafeq sub s a f e end-sub The plate load test remains one of the

σ=PA=Pπ⋅D24sigma equals the fraction with numerator cap P and denominator cap A end-fraction equals the fraction with numerator cap P and denominator the fraction with numerator pi center dot cap D squared and denominator 4 end-fraction end-fraction = Applied load (expressed in = Cross-sectional area of the plate ( m2m squared = Diameter of the circular plate ( Settlement Averaging

A Plate Load Test (PLT) is a critical in-situ geotechnical test used to determine the bearing capacity and settlement characteristics of soil. Engineers, project managers, and lab technicians frequently rely on Excel spreadsheet formulas to process raw field data into actionable design parameters. Understanding the Plate Load Test Core Metrics

Highlight your calculated Applied Pressure column and the Cumulative Settlement column. Insert Chart: Choose an XY Scatter Chart with Smooth Lines . Format Axes: Place Pressure (kPa) on the X-axis (top or bottom). Place Settlement (mm) on the Y-axis. A well-structured Excel workbook not only saves hours

Use Excel's Data Validation tools on the raw reading columns to prevent field engineers from entering negative numbers or text errors.

Average Settlement (savg)=G1+G2+G33Average Settlement open paren s sub a v g end-sub close paren equals the fraction with numerator cap G sub 1 plus cap G sub 2 plus cap G sub 3 and denominator 3 end-fraction In Excel: =AVERAGE(G1_Cell, G2_Cell, G3_Cell) Step 4: Determine the Modulus of Subgrade Reaction (

This sheet contains the raw data recorded during the field test. The load applied (kN). Time Interval: Time of reading.

To determine the bearing capacity and modulus of subgrade reaction (

Since multiple dial gauges are used to account for eccentric loading or tilting of the plate, the true settlement (