Plate Load Test Report Xls Work Access

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

| 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 | Introduction The plate load test is a widely

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.

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.

Step 2: The Calculation Table

Set up columns for the raw data processing. Start around Row 10.

Column Headers:

  • Col A: Load Step / Time
  • Col B: Pressure Gauge Reading (psi/bar) OR Proving Ring Div.
  • Col C: Applied Load (kg or kN)
  • Col D: Pressure / Intensity of Loading (kN/m² or t/m²)
  • Col E: Dial Gauge 1 (mm)
  • Col F: Dial Gauge 2 (mm)
  • Col G: Average Settlement (mm)
  • Col H: Cumulative Settlement (mm)

Key Formulas:

  1. Applied Load (Col C):
    • If using Pressure Gauge: = (Pressure_PSI * Jack_Area) or use a conversion factor.
    • If using Proving Ring: = (Reading * Ring_Constant)
  2. Pressure/Intensity (Col D):
    • = Applied_Load / Plate_Area
    • Tip: Ensure units match (convert kg to kN if necessary: divide by 101.97).
  3. Average Settlement (Col G):
    • = (E11 + F11) / 2 (Average of two dial gauges).
    • Note: If gauges move in opposite directions or start at non-zero, subtract the initial reading first.
  4. Cumulative Settlement (Col H):
    • For the first reading: = G11.
    • For subsequent readings: = H11 + G12 (Previous cumulative + Current increment).

Error #1: Ignoring Plate Size Correction

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.

Part 1: Understanding the Plate Load Test (Quick Refresher)

Before we dive into Excel workflows, let’s align on the core principles. Test Location and Date : Description of the

The 5 Critical Steps to Building (or Using) a Plate Load Test XLS Workflow

Whether you download a template or build your own, your XLS workbook must handle the following five tasks seamlessly:

Step 3: Calculating Key Parameters

  • Calculate the following key parameters:
    • Bearing capacity of the soil (in kPa or psf)
    • Settlement of the structure (in mm or in)
    • Load-settlement curve