Plate Load Test Report Xls Work
Set up columns for the raw data processing. Start around Row 10.
Column Headers:
Key Formulas:
Formulas to include:
Validation: Add data validation for plate diameter, load increments, and gauge readings.
Conditional formatting: Highlight settlement > 5 mm or > 10 mm.
If you want me to generate an actual .xls file you can download, just let me know. I can provide a link or embed an HTML table you can copy-paste into Excel.
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). plate load test report xls work
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
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 Set up columns for the raw data processing
A plate load test (PLT) report in Excel ( ) is a critical geotechnical engineering document used to determine the ultimate bearing capacity and settlement characteristics of soil. By automating calculations in Excel, engineers can quickly translate field measurements into actionable design parameters for foundations. 1. Essential Report Components
A professional plate load test report typically includes the following structured sheets or sections: Project Information
: Site location, test date, plate size (commonly 300mm to 750mm), and foundation details. Equipment Details
: Specifications for the hydraulic jack, pressure gauge resolution, and dial gauge accuracy (typically 0.01mm). Raw Data Table
: Columns for cumulative load (kN), time intervals, and readings from at least two dial gauges. Load-Settlement Analysis
: Graphical representation of load increments versus average settlement. 2. Excel Calculation Logic
Excel spreadsheets automate the transformation of raw gauge readings into soil properties. Bearing Capacity Calculations
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.
Set up columns as follows:
| Load Increment | Load (kN) | Pressure (kN/m²) | Dial Gauge 1 (mm) | Gauge 2 (mm) | Gauge 3 (mm) | Time Elapsed (min) | |----------------|-----------|------------------|-------------------|--------------|--------------|---------------------| Key Formulas:
Pro Tip: Use data validation to restrict time entries (e.g., 0, 1, 2.5, 5, 10, 15, 30 min intervals). Add a cell for Plate Area (A) and Plate Diameter (B) so pressure auto-calculates: =Load/(PI()*(B/2000)^2) (adjust units as needed).
Your first sheet should mirror your field data sheet. Include columns for:
Scenario: You are at a site in Mumbai. The soil is medium sand. You performed a PLT with a 300mm plate. Field readings:
| Load (kN) | Avg Settlement (mm) | |-----------|---------------------| | 0 | 0.00 | | 10 | 0.85 | | 20 | 2.10 | | 40 | 4.50 | | 60 | 7.80 | | 80 | 12.50 | | 100 | 20.00 | | 120 | 34.00 (stopped) |
Using your XLS template:
Total time: 10 minutes. Total errors: Zero.
If you are looking to create a template for repeated use, organize your workbook with these four tabs:
In the realm of geotechnical engineering, theory often meets reality at the bottom of a pit. Before a massive foundation is poured or a heavy pavement is laid, we need to know one thing with certainty: Can the soil take the load?
While laboratory tests give us soil parameters, the Plate Load Test (PLT) is the gold standard for determining the ultimate bearing capacity and settlement characteristics of soil in situ.
But once the jack is released and the dial gauges are packed away, the real work begins: Data Analysis.
In this guide, we will walk through the process of analyzing Plate Load Test data and generating a comprehensive, professional report using Microsoft Excel (XLS).