Plate Load Test Report Xls Work 【BEST】

Here, bring data from the Input tab using simple cell references.

3.1 Average Settlement per Load =AVERAGE(Input!D2:F2) – This averages the three dial gauges.

3.2 Net Settlement The first load often settles due to seating. Subtract the settlement at the first load from all subsequent settlements: =AvgSettlement - AvgSettlement_at_FirstLoad

3.3 Safe Bearing Capacity (As per IS 1888:1982) For a plate load test, the safe bearing capacity for a given allowable settlement (Sa) is: SBC = (Pressure at Sa) / Factor of Safety (usually 3)

In Excel, use FORECAST.LINEAR to interpolate pressure for a given settlement. Example: If allowable settlement is 40mm: =FORECAST.LINEAR(40, Pressure_Range, Settlement_Range)/3 plate load test report xls work

3.4 Modulus of Subgrade Reaction (Ks) Ks = (Pressure at 1.25mm settlement) / 1.25 (Unit: kN/m³) In Excel: =INDEX(Pressure_Range, MATCH(1.25, Settlement_Range, 1))/1.25

Manually plotting these curves and calculating the SBC using methods like the Proposed Settlement Criteria (IS 1888 or ASTM D1194) is tedious. A single decimal typo can lead to a foundation failure. This is why xls work is critical.

This determines the Ultimate Bearing Capacity.

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

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

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

Answer: Cost and flexibility. An Excel (XLS) workflow is: Here, bring data from the Input tab using

A text-only report is useless. You need curves.

Chart 1: Load vs. Settlement (Log-Log or Linear)

Chart 2: Settlement vs. Square Root of Time (for consolidation)

How to make it dynamic: Use OFFSET and COUNTA functions so your charts automatically expand when you add more load increments. This determines the Ultimate Bearing Capacity

Example dynamic named range for settlement: =OFFSET(Calculations!$A$2,0,0,COUNTA(Calculations!$A:$A)-1,1)

Your Excel sheet needs a "Results" section that automatically calculates the Safe Bearing Capacity (SBC). This is where the magic of XLS saves you hours of manual math.