Plate Load — Test Report Xls Work |top|

The calculated mean value of all active dial gauges for that specific time/load increment. Tab 3: Summary of Results & Engineering Curves

| Cell | Content (Label) | Content (Value/Input) | | :--- | :--- | :--- | | A1 | | [Type Project Name] | | A2 | Test Location: | [e.g., Borehole 1, 2m depth] | | A3 | Plate Diameter (D): | 300 (mm) | | A4 | Plate Area (A): | =PI()*(B3/2)^2 (Calculates area automatically) | | A5 | Proving Ring Constant: | [e.g., 0.5 kg/div] | | A6 | Jack Capacity: | [e.g., 50 Tons] |

Sf=Sp×(BfoundationBplate)cap S sub f equals cap S sub p cross open paren the fraction with numerator cap B sub foundation end-sub and denominator cap B sub plate end-sub end-fraction close paren

Protect cells containing calculations ( Data Validation or Protect Sheet ) so field technicians or junior engineers cannot accidentally overwrite mathematical formulas with manual data.

The actual reading from the pressure gauge or load cell. plate load test report xls work

The curve will likely be continuous without a distinct failure point. In this scenario, the ultimate bearing capacity is conservatively defined as the stress corresponding to a specific settlement value (e.g., 10% or 20% of the plate diameter, or a fixed threshold like 25 mm). Calculating Safe Bearing Capacity (

This dynamic data matrix logs individual loading increments. Establish a structured ledger with the following column headers: Loading Stage Applied Load ( Calculated Pressure ( kN/m2kN/m squared Dial Gauge 1 ( Dial Gauge 2 ( Dial Gauge 3 ( Average Settlement ( Time Elapsed ( =AVERAGE(D2:F2) Stage 1 =B3/(PI()*(Diameter/2000)^2) =AVERAGE(D3:F3) Stage 2 =B4/(PI()*(Diameter/2000)^2) =AVERAGE(D4:F4) Zone C: Automated Engineering Outputs

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.

Before you touch the numbers, your XLS file should have a cover or header sheet containing: The calculated mean value of all active dial

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

A plate load test (PLT) report in Excel format typically includes raw field observations, load-settlement calculations, and a graphical analysis to determine the soil's ultimate bearing capacity Core Components of a Plate Load Test XLS Work

Utilize Data Validation to restrict input to positive numbers and use Conditional Formatting to highlight if settlement exceeds a certain value (e.g., 25mm).

Use Excel's Data Validation tools on the raw reading columns to prevent field engineers from entering negative numbers or text errors. The curve will likely be continuous without a

A well-organized Excel sheet should systematically capture the following raw and calculated parameters during the test:

Since multiple dial gauges are used to account for eccentric loading or tilting of the plate, the true settlement (

| Column A | Column B | Column C | |----------|----------|----------| | | Settlement (mm) | Settlement (mm) - corrected |

so that if raw data changes, the graph updates automatically.

If no clear break point exists, the ultimate capacity is often defined as the pressure corresponding to a settlement equal to 10% of the plate diameter. Use Excel's INDEX and MATCH formulas to find or interpolate this value. Safe Bearing Capacity ( qsafeq sub s a f e end-sub