Plate Load Test Report Xls Work [upd] < macOS >

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.

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

Ks = (Pressure at 1.25mm settlement) / 1.25 (Unit: kN/m³) In Excel: =INDEX(Pressure_Range, MATCH(1.25, Settlement_Range, 1))/1.25 Step 4: The Charts Tab – Professional Visualization A text-only report is useless. You need curves. Use data validation to restrict time entries (e

Use CELL("filename") to auto-insert the file path and date. Use =TODAY() for dynamic report date. Part 4: Advanced XLS Work – VBA for Automated Reporting 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. 'Calculate SBC Dim lastRow As Long lastRow = wsInput

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

Dim SBC As Double SBC = Application.WorksheetFunction.Forecast_LINEAR(40, pressureRange, settlementRange) / 3 wsSummary.Range("H10").Value = SBC