A Comprehensive Guide to Plate Load Test Report XLS Work
Introduction
The plate load test is a widely used field test to determine the bearing capacity of soil and settlement of structures under various loads. The test involves applying a load to a steel plate placed on the soil surface and measuring the resulting settlement. The data collected from the test is then used to create a plate load test report, which is often prepared in Excel format (XLS). In this guide, we will walk you through the process of creating a plate load test report in XLS format.
Understanding the Plate Load Test
Before we dive into the report preparation, it's essential to understand the plate load test procedure:
Preparing the Plate Load Test Report in XLS
Here's a step-by-step guide to creating a plate load test report in XLS format:
The bearing capacity from a small plate is not the same as for a large foundation. In your XLS, add a correction factor:
Corrected_SBC = SBC_Plate * (Foundation_Width / Plate_Width)
Only applicable for sandy soils.
A text-only report is useless. You need curves.
Chart 1: Load vs. Settlement (Log-Log or Linear)
Chart 2: Settlement vs. Square Root of Time (for consolidation)
SQRT(Time) on X-axis.How to make it dynamic: Use OFFSET and COUNTA functions so your charts automatically expand when you add more load increments.
Example dynamic named range for settlement:
=OFFSET(Calculations!$A$2,0,0,COUNTA(Calculations!$A:$A)-1,1)
Your first sheet should mirror your field data sheet. Include columns for:
The phrase "plate load test report xls work" is more than a keyword—it is a methodology. It represents the shift from messy handwritten logbooks to structured, auditable, and professional digital reporting.
By mastering Excel for PLT analysis, you achieve three critical outcomes:
Whether you are a field technician logging data or a senior engineer approving foundation designs, your XLS template is your most powerful tool. Start with the basic structure above, add VBA macros as you get comfortable, and never let manual calculation slow you down again.
Call to Action: Download our free starter template below (link placeholder) or share your own PLT Excel hacks in the comments. Let’s build safer foundations, one spreadsheet at a time.
About the Author: [Your Name] is a geotechnical engineer with 12 years of experience in foundation testing and data analysis. Specializes in bridging field testing with digital workflows. plate load test report xls work
A Plate Load Test (PLT) is a critical field test used to determine the Ultimate Bearing Capacity of soil and its probable settlement under a specific load. To "work" a report in Excel (XLS), you must document the incremental application of load and the corresponding settlement over time. Typical Plate Load Test Report Structure (XLS)
A standard report spreadsheet usually includes the following data sections:
Plate Load Test for Soil Bearing Capacity | PDF | Column - Scribd
The fluorescent lights of the site trailer hummed with a headache-inducing frequency, a perfect harmony to the rhythmic clicking of Elias’s keyboard. On the dual monitors, a spreadsheet sat open—the Plate Load Test Report.xls—its grid of cells as rigid and unyielding as the clay beneath the proposed foundation.
To an outsider, it was just data: Settlement (mm), Load (kN/m²), Time (min). But Elias didn't see numbers. He saw the invisible weight of a twenty-story skyscraper pressing down on a patch of earth that, according to the last three increments, was beginning to groan.
He clicked into cell D42. 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.
Elias looked out the trailer window. Rain was beginning to slick the red Georgia clay. He thought about the modular homes he’d seen in the valley, the families moving in next spring, and the massive concrete pedestal that needed to hold their world upright. His finger hovered over the backspace key.
In the quiet of the trailer, the spreadsheet felt like a confession. A 0.5mm difference in cell E18 was the gap between a safe structure and a catastrophe buried twenty years in the future. He looked at the "Summary of Results" tab. It was currently a sea of red "FAIL" flags.
He closed his eyes and saw the settlement curve—the way it dipped sharply, like a heart monitor flatlining. "Drafting," he whispered to the empty room.
He didn't change the numbers. Instead, he began to type in the Observations column, his prose turning clinical yet urgent. He described the "anomalous yielding of the subgrade," the "saturation of the silty lens," and the "unavoidable necessity for deep piling."
He wasn't just filling out a report; he was writing a warning to the future. He hit Ctrl+S. The file saved. The truth was locked in the grid, a digital blueprint of integrity against the crushing pressure of a deadline.
The header of your spreadsheet should capture the context of the test: Project Details: Project name, location, and client.
Test Identification: Test number (e.g., PLT-01), date, and weather conditions. Equipment Specs: Plate diameter (commonly , , or
), plate shape (circular or square), and hydraulic jack capacity. 2. Observation Table (Data Entry)
This is the core of your XLS sheet where field data is recorded. Use columns for each loading stage:
Load Increment: Sequence of pressure applied (usually in increments of or similar). Time (min): Recorded at intervals (e.g., minutes).
Gauge Readings: Readings from at least two dial gauges to capture settlement at opposite sides of the plate.
Average Settlement (mm): The mean value of the dial gauge readings for each stage. 3. Automated Calculations A Comprehensive Guide to Plate Load Test Report
In Excel, you can use formulas to automate the derivation of soil properties. Load Intensity ( ):
q=Applied Load (kN)Area of Plate (m2)q equals the fraction with numerator Applied Load (kN) and denominator Area of Plate (m squared ) end-fraction
Ultimate Bearing Capacity (UBC): Identified as the point where the load-settlement curve breaks or settlement increases rapidly. Safe Bearing Capacity (SBC):
SBC=UBCFactor of Safety (FOS)SBC equals the fraction with numerator UBC and denominator Factor of Safety (FOS) end-fraction Note: FOS typically ranges from to . 4. Load-Settlement Curve (Excel Graphing)
To visualize the soil's behavior, plot a Load-Settlement Curve using a "Scatter with Smooth Lines" chart in Excel: X-axis: Load Intensity ( kN/m2kN/m squared or kg/cm2kg/cm squared ). Y-axis: Average Settlement ( ).
Analysis: The point where the curve becomes vertical (or near-vertical) indicates the ultimate failure point. 5. Final Reporting & Conclusions
The report should conclude with the determined values for the site:
Allowable Bearing Capacity: Based on permissible settlement (often for foundations). Modulus of Subgrade Reaction (
): Calculated as Pressure / Settlement for a specific settlement value (usually or ). Summary Checklist for XLS Setup
A report or "paper" on the Plate Load Test (PLT) 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
A comprehensive report usually includes the following technical data:
Standard Compliance: Tests are often performed according to standards like BS 1377 Part 9: 1990 or ASTM D1194.
Plate Specifications: A steel plate with a diameter of 300 mm to 750 mm and a minimum thickness of 25 mm is used.
Load Increments: Loads are applied in equal steps (e.g., 0.08 MN/m²) at set intervals until maximum load or rapid settlement occurs.
Settlement Measurements: Measured using three dial gauges (sensitivity ~0.02 mm) placed 120° apart to ensure average settlement accuracy. Excel (.xls) Calculation Workflow
In a typical .xls template, the following calculations are automated: Ultimate Bearing Capacity (
): The total load at failure divided by the area of the plate. Safe Bearing Capacity (SBC): Calculated as divided by a Factor of Safety (typically 3). Modulus of Subgrade Reaction (
): Determined by dividing the load intensity by the corresponding settlement (often at 1.25 mm). A steel plate is placed on the soil
Plate Size Corrections: If a plate smaller than 75 cm is used, a correction factor is applied to the value to simulate full-scale foundation behavior. Resource Links
Reference Templates: Users often search for Plate Load Test Report XLS to find pre-formatted Google Sheets or Excel files for data entry.
Detailed Procedure: Technical guides from Douglas Partners or Tensar U.K. provide the theory behind the interpretation of these reports.
Plate Load Test: Uses, Method, Plate Size and Interpretation - Tensar U.K
Finding high-quality Plate Load Test (PLT) report resources in Excel (.xls or .xlsx) format typically involves finding calculation templates and reporting forms used by geotechnical engineers. Excel Spreadsheet Resources & Templates
Several platforms offer specialized spreadsheets that automate the calculation of bearing capacity and settlement from raw field data.
CivilWeb Spreadsheets: Offers a dedicated Bearing Capacity from Plate Load Test Spreadsheet which estimates soil settlement and allowable bearing capacity using procedures outlined in BS 8004.
Scribd: A major repository for professional templates. Useful files include:
Load vs Settlement 12-xlsx Group for documenting multiple test points.
Plate Load Test DIN 18134 Ev1Ev2 Lab Form specifically for subgrade modulus and deformation testing.
Plate Load Test Sample Form for logging applied load, pressure, and dial gauge readings.
Community Groups: The Structural Engineers Facebook Group occasionally shares geotechnical design suites that include PLT calculation modules. Critical Report Data Points
A standard Excel-based PLT report should include these automated calculation fields:
Ultimate Bearing Capacity: Calculated by dividing the failure load by the plate area.
Safe Bearing Capacity (SBC): Derived by dividing the ultimate capacity by a Factor of Safety (typically 3). Modulus of Subgrade Reaction ( value): Often measured at 1.25 mm settlement (
Settlement Corrections: Corrections for plate size (if plate is <75is less than 75 cm) and bending based on standards like IS 9214. Key Field Testing Standards
Excel templates often follow specific regional or international standards: Modulus of sub-grade reaction K value Test
You can copy this layout directly into Excel. The workbook should contain at least 3 sheets:
It is not just about typing numbers into cells. Professional "XLS work" for PLT includes: