This guide provides a detailed walkthrough on how to create, structure, and automate a Plate Load Test Report using Microsoft Excel.
The Plate Load Test (PLT) is used to determine the bearing capacity of soil and the settlement characteristics under a given load. Excel is the industry standard for this because it handles the repetitive calculations and graphical plotting required for the report.
The Plate Load Test is a straightforward test, but the interpretation of the data requires attention to detail. By building a structured, formula-driven Excel sheet, you not only speed up your workflow but also minimize the risk of calculation errors.
Whether you are checking the subgrade for a highway pavement or the foundation for a high-rise, a well-prepared XLS report is your bridge between raw site data and engineering confidence.
Pro Tip: Always verify the units! Mixing up kN (KiloNewtons) with kg (Kilograms) or meters with millimeters is the most common error in Excel-based engineering reports.
[e.g., Silty Sand, Dense Gravel, or Highly Compressible Clay] Test Depth: [Insert Depth in meters below ground level] Standard Followed: [e.g., ASTM D1194, BS 5930, or IS 1888:1982] Section 2: Equipment Specifications PLATE LOAD TEST REPORT - JICA Report PDF
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). plate load test report xls work
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. This guide provides a detailed walkthrough on how
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
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:
Example of Plate Load Test Report XLS
Here's an example of what the plate load test report XLS might look like:
| Load (kN) | Settlement (mm) | Time of Reading | | --- | --- | --- | | 10 | 0.5 | 10:00 | | 20 | 1.2 | 10:15 | | 30 | 2.5 | 10:30 | | ... | ... | ... |
Load-Settlement Curve
$$Settlement (mm) = 0.05 \times Load (kN) + 0.2$$
Conclusion
The plate load test report XLS is an essential document that provides valuable insights into the bearing capacity of soil and settlement of structures. By following the steps outlined in this guide, you can create a comprehensive report that meets your needs.
A plate load test (PLT) report in Excel format typically includes raw field observations, load-settlement calculations, and a graphical analysis to determine the soil's ultimate bearing capacity Core Components of a Plate Load Test XLS Work
A standard workbook is generally organized into these key sections: Plate Load Test - Insitutek
Blog Title: Streamlining Your Site Investigation: How to Master Plate Load Test Reporting with Excel (XLS)
Published: April 12, 2026 | Category: Geotechnical Engineering
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: Data processing and reporting.
Here lies the challenge. Raw data is messy. Calculations are repetitive. And nobody wants to manually compute bearing pressure for 10 load cycles at 4 different test locations.
This is where the Plate Load Test Report XLS becomes your best friend.
Your first sheet should mirror your field data sheet. Include columns for:
Set up columns for the raw data processing. Start around Row 10.
Column Headers:
Key Formulas:
= (Pressure_PSI * Jack_Area) or use a conversion factor.= (Reading * Ring_Constant)= Applied_Load / Plate_Area= (E11 + F11) / 2 (Average of two dial gauges).= G11.= H11 + G12 (Previous cumulative + Current increment).