Plate Load Test Report Xls Work «Free»

A Plate Load Test (PLT) report in Excel format (.xls or .xlsx) is an essential tool for geotechnical engineers to calculate soil bearing capacity and foundation settlement. These workbooks typically automate the translation of field dial gauge readings into "Load vs. Settlement" curves to determine the Safe Bearing Capacity (SBC). Core Components of a PLT Excel Report

Standard Excel templates for plate load tests generally include the following structured sections: Plate Load Tests - Uses, Plate Size and Interpretation

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)

Where to Find a Good Plate Load Test Report XLS

You have three options:

  1. Build it yourself (1-2 hours): Use the logic above. Requires intermediate Excel skills (VLOOKUP, INDEX-MATCH, basic VBA for buttons).
  2. Download a free template (10 minutes): Search for "IS 1888 Plate Load Test Excel Sheet" (Indian standard) or "ASTM D1194 Excel Template". Be careful—free versions often have broken formulas.
  3. Buy a professional template ($15–$30): Sites like EngineeringBooksPdf or specific geotech portals sell locked but reliable XLS workbooks with ISO/BS compliance.

Error #3: Using Linear Interpolation for a Non-Linear Curve

The load-settlement curve is rarely linear. Using FORECAST.LINEAR for large extrapolations is dangerous. Instead, use power trendline coefficients:

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 | | ... | ... | ... | ... | ... | ... |

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

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

What "XLS Work" Entails

It is not just about typing numbers into cells. Professional "XLS work" for PLT includes:

  1. Data Entry Sheets mimicking field data logger format.
  2. Automated Averaging of three dial gauge readings.
  3. Net Settlement Calculation (subtracting seating settlement).
  4. Dynamic Graphs that update automatically.
  5. Embedded Code (VBA) to handle iterative calculations for bearing capacity.
  6. Print-Ready Dashboard merging charts, tables, and conclusions.

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:

The General Information Sheet

Before you touch the numbers, your XLS file should have a cover or header sheet containing: A Plate Load Test (PLT) report in Excel format (