Plate Load Test Report Xls Work -

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

Column Headers:

Key Formulas:

Pressure/Intensity (Col D):

Average Settlement (Col G):

Cumulative Settlement (Col H):

Your first dial gauge reading is initial reading, not zero settlement. Always calculate Settlement = Current_Reading - Initial_Reading. Your XLS formula should be: =D2-$D$2 (absolute reference to first reading).

The biggest mistake engineers make is forgetting to normalize settlement for a standard plate size (usually 762mm or 300mm). Your XLS must include a correction factor: Corrected Settlement = (Observed Settlement) x (Standard Plate Dia / Actual Plate Dia) Build this logic into your sheet so you don’t have to recalc later. plate load test report xls work

| 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. Set up columns for the raw data processing

You might ask: Why not use dedicated geotechnical software like gINT or Plaxis?

Answer: Cost and flexibility. An Excel (XLS) workflow is:

A plate load test generates too much data to trust to manual calculations. Whether you are following IS 1888, ASTM D1194, or BS 1377, a well-structured Plate Load Test Report XLS eliminates human error, enforces your local code standard, and makes you look like a hero in the morning site meeting.

Stop wrestling with numbers. Start using smart spreadsheets. Key Formulas:

Do you use a standard XLS template for your PLT reports, or do you build each one from scratch? Let me know in the comments below!

Before we dive into Excel workflows, let’s align on the core principles.

For repetitive work (e.g., testing 20 locations on a project), manual copy-paste is slow. Here is a simple VBA macro to generate a report from raw data.

Sub GeneratePLTReport()
    Dim wsInput As Worksheet
    Dim wsSummary As Worksheet
    Set wsInput = ThisWorkbook.Sheets("Input")
    Set wsSummary = ThisWorkbook.Sheets("Summary")
'Clear previous summary
wsSummary.Range("B5:G20").ClearContents
'Copy latest data
wsInput.Range("A2:F20").Copy
wsSummary.Range("B5").PasteSpecial Paste:=xlPasteValues
'Calculate SBC
Dim lastRow As Long
lastRow = wsInput.Cells(Rows.Count, 1).End(xlUp).Row
Dim settlementRange As Range
Dim pressureRange As Range
Set settlementRange = wsInput.Range("G2:G" & lastRow) 'Assume net settlement col
Set pressureRange = wsInput.Range("C2:C" & lastRow)
Dim SBC As Double
SBC = Application.WorksheetFunction.Forecast_LINEAR(40, pressureRange, settlementRange) / 3
wsSummary.Range("H10").Value = SBC
MsgBox "Report generated successfully. Safe Bearing Capacity = " & SBC & " kPa"

End Sub

This macro reduces a 30-minute manual reporting task to 3 seconds.