Plate Load Test Report Xls Work [better] -

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.

A complete reporting system should consist of several dedicated sheets. Below is a logical structure that works for most projects.

Here lies the challenge. Raw data is messy. Calculations are repetitive. And nobody wants to manually compute bearing pressure for 10 load cycles at 4 different test locations.

Typical table:

The actual pressure exerted on the soil, calculated from the gauge force and plate area. 2. Core Geotechnical Calculations & Excel Formulas plate load test report xls work

This is the core working area where field engineers input raw measurements during the test increments. The table columns generally feature:

Because the summary values are formulas that pull from Sheet 2, they update automatically when raw data changes. The chart also updates dynamically if it is based on a named range or Excel Table.

You need to calculate the . This usually involves two methods defined in standards like IS:1888 or ASTM D1194.

Apply conditional formatting rules to highlight stabilization milestones (e.g., alert the user if settlement exceeds 0.25mm per hour, signaling that the load increment is not yet stable). For repetitive work (e

Ultimate load divided by a factor of safety (usually 2.5 or 3). 4. Why Use an Excel Spreadsheet for Plate Load Tests?

Net load, settlement, pressure, and time-dependent settlement.

Instantly plots the Load-Settlement graph to interpret soil behavior.

Highlight the compiled column for "Applied Pressure ( kPak cap P a )" and the corresponding column for "Average Settlement ( Below is a logical structure that works for most projects

Right-click the Y-axis > Format Axis > Check "Values in reverse order".

=AVERAGE(C11, D11) (Assuming Gauges are in Columns C and D).

Once the data is populated and charted, the Excel report helps engineers determine two vital parameters: Ultimate Bearing Capacity (

Excel formulas instantly convert gauge readings (pressure and dial indicators) into applied stress (kN/m² or kPa) and settlement (mm).

Δs=R1+R2+R3+R44delta s equals the fraction with numerator cap R sub 1 plus cap R sub 2 plus cap R sub 3 plus cap R sub 4 and denominator 4 end-fraction