Plate Load Test Report Xls Work ((free)) May 2026

| Load (kN) | Avg Settlement (mm) | |-----------|---------------------| | 0 | 0.00 | | 10 | 0.85 | | 20 | 2.10 | | 40 | 4.50 | | 60 | 7.80 | | 80 | 12.50 | | 100 | 20.00 | | 120 | 34.00 (stopped) |

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

'Copy latest data wsInput.Range("A2:F20").Copy wsSummary.Range("B5").PasteSpecial Paste:=xlPasteValues | Load (kN) | Avg Settlement (mm) |

Example dynamic named range for settlement: =OFFSET(Calculations!$A$2,0,0,COUNTA(Calculations!$A:$A)-1,1) This is what your client or site engineer will print. Design it like a dashboard. Use data validation to restrict time entries (e

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). Step 3: The Calculations Tab – Automating Key Metrics Here, bring data from the Input tab using simple cell references.

MsgBox "Report generated successfully. Safe Bearing Capacity = " & SBC & " kPa" End Sub