Plate Load Test Report Xls Work File

You can copy this layout directly into Excel. The workbook should contain at least 3 sheets:

  1. Test Data (field readings)
  2. Calculation & Settlement (bearing pressure vs settlement)
  3. Summary & Result (final bearing capacity & modulus)

Phase 3: Plotting the Graphs

The core of the XLS report is the visual representation. You need two specific charts.

Why Excel (XLS) is Still King for Plate Load Tests

While there are expensive software packages out there, an Excel-based (.xls) reporting system offers three unbeatable advantages:

  1. Transparency: You see every formula. No "black box" calculations.
  2. Speed: Pre-built templates turn an hour of number-crunching into a 5-minute data entry job.
  3. Standardization: Every report looks the same, which auditors love.

Step 2: Structuring the Calculation Sheet

This is the heart of your XLS work. Create a tab named "Calculations" and structure your columns as follows:

| Col A | Col B | Col C | Col D | Col E | | :--- | :--- | :--- | :--- | :--- | | Load Step | Pressure (kPa) | Total Load (kN) | Dial Gauge Reading (mm) | Settlement (mm) | | 1 | 0 | 0 | 0.00 | 0.00 | | 2 | 25 | (Formula) | (Input) | (Formula) | | 3 | 50 | (Formula) | (Input) | (Formula) |

Error #4: Formatting Nightmares

When you send an XLS file, the recipient might see #### or broken charts. Always save a final copy as PDF. Use File > Export > Create PDF directly from your Summary tab.

Method B: Using Settlement Criteria (Double Tangent Method)

If clear failure did not occur (test stopped at max load):

  1. Draw two tangents on the Load-Settlement curve:
    • Tangent 1: Along the initial straight portion.
    • Tangent 2: Along the steep curving portion.
  2. The intersection is considered the yield point.

Excel Formula for Safe Bearing Capacity (Settlement Based): Often, you calculate the allowable pressure for a specific settlement (e.g., 12mm or 25mm).

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

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 plate load test report xls work

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

Introduction

The plate load test is a widely used field test to determine the bearing capacity of soil and settlement of structures under 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 calculate the bearing capacity of the soil and design foundations.

Plate Load Test Report XLS Work

A plate load test report typically includes detailed information about the test setup, procedure, and results. The report is often prepared in an Excel spreadsheet (.xls) format for easy data analysis and presentation. Here's an overview of the typical contents of a plate load test report xls:

  1. Test Location and Date: Description of the test location, including coordinates, elevation, and soil type. The date of the test is also recorded.
  2. Test Setup: Details of the test setup, including:
    • Plate size and thickness
    • Loading device (e.g., hydraulic jack, weights)
    • Settlement measurement devices (e.g., dial gauges, LVDTs)
  3. Soil Properties: Relevant soil properties, such as:
    • Soil type and classification
    • Moisture content
    • Dry density
    • Soil strength parameters (e.g., cohesion, friction angle)
  4. Loading Procedure: Description of the loading procedure, including:
    • Load increments and duration
    • Number of cycles (if applicable)
  5. Settlement Measurements: Record of settlement measurements at each load increment, including:
    • Dial gauge or LVDT readings
    • Time-settlement data
  6. Load-Settlement Curve: A graphical representation of the load-settlement data, typically plotted as load (kN) vs. settlement (mm).
  7. Bearing Capacity Calculations: Calculations to determine the bearing capacity of the soil, including:
    • Ultimate bearing capacity (qu)
    • Allowable bearing capacity (qa)
    • Safety factor (FS)

XLS Template for Plate Load Test Report

Here's a basic outline of an XLS template for a plate load test report:

| Sheet 1: Test Location and Date | | | | --- | --- | --- | | Test Location | | | | Coordinates | | | | Elevation | | | | Soil Type | | | | Date | | |

| Sheet 2: Test Setup | | | | --- | --- | --- | | Plate Size (mm) | | | | Plate Thickness (mm) | | | | Loading Device | | | | Settlement Measurement Device | | |

| Sheet 3: Soil Properties | | | | --- | --- | --- | | Soil Type | | | | Moisture Content (%) | | | | Dry Density (kg/m³) | | | | Cohesion (kPa) | | | | Friction Angle (°) | | |

| Sheet 4: Loading Procedure | | | | --- | --- | --- | | Load Increment (kN) | | | | Duration (min) | | | | Number of Cycles | | |

| Sheet 5: Settlement Measurements | | | | --- | --- | --- | | Load (kN) | Settlement (mm) | Time (min) | | | | |

| Sheet 6: Load-Settlement Curve | | | | --- | --- | --- | | Load (kN) | Settlement (mm) | | | | | |

| Sheet 7: Bearing Capacity Calculations | | | | --- | --- | --- | | Ultimate Bearing Capacity (kPa) | | | | Allowable Bearing Capacity (kPa) | | | | Safety Factor | | |

Example of Plate Load Test Report XLS Work

Suppose we conducted a plate load test on a clay soil with a plate size of 300 mm x 300 mm. The test setup, soil properties, loading procedure, and settlement measurements are as follows:

Test Location and Date

| Test Location | Coordinates | Elevation | Soil Type | Date | | --- | --- | --- | --- | --- | | Site A | 10.1234, 20.5678 | 50 m | Clay | 2023-02-20 |

Test Setup

| Plate Size (mm) | Plate Thickness (mm) | Loading Device | Settlement Measurement Device | | --- | --- | --- | --- | | 300 x 300 | 20 | Hydraulic Jack | Dial Gauge |

Soil Properties

| Soil Type | Moisture Content (%) | Dry Density (kg/m³) | Cohesion (kPa) | Friction Angle (°) | | --- | --- | --- | --- | --- | | Clay | 25 | 1200 | 30 | 20 |

Loading Procedure

| Load Increment (kN) | Duration (min) | Number of Cycles | | --- | --- | --- | | 50 | 10 | 3 |

Settlement Measurements

| Load (kN) | Settlement (mm) | Time (min) | | --- | --- | --- | | 0 | 0 | 0 | | 50 | 1.2 | 5 | | 100 | 2.5 | 10 | | 150 | 4.1 | 15 |

Load-Settlement Curve

| Load (kN) | Settlement (mm) | | --- | --- | | 0 | 0 | | 50 | 1.2 | | 100 | 2.5 | | 150 | 4.1 |

Bearing Capacity Calculations

| Ultimate Bearing Capacity (kPa) | Allowable Bearing Capacity (kPa) | Safety Factor | | --- | --- | --- | | 250 | 125 | 2 |

The plate load test report xls work would then involve creating a comprehensive report that presents the test results, load-settlement curve, and bearing capacity calculations. This report would be used to inform foundation design and ensure that the soil can support the intended structure.

Sheet 1: Test Data (Field Readings)

| Column A | Column B | Column C | Column D | Column E | Column F | |----------|----------|----------|----------|----------|----------| | Time (min) | Load (kN) | Proving Ring Reading (div) | Dial Gauge 1 (mm) | Dial Gauge 2 (mm) | Avg Settlement (mm) |

Sample rows:

| Time | Load | Proving Ring | DG1 | DG2 | Avg Settlement | |------|------|--------------|-----|-----|----------------| | 0 | 0 | 0 | 0.00| 0.00| 0.00 | | 1 | 5.0 | 25 | 0.12| 0.10| 0.11 | | 2 | 10.0 | 50 | 0.28| 0.26| 0.27 | | 5 | 20.0 | 100 | 0.65| 0.61| 0.63 | | 10 | 40.0 | 200 | 1.40| 1.36| 1.38 | | ... | ... | ... | ... | ... | ... | You can copy this layout directly into Excel

Formula in F2: =AVERAGE(D2:E2) and drag down.