Plate Load Test Report Xls Work -

Set up rules to highlight cells if differential settlement between dial gauges exceeds 20%, which indicates severe plate tilting or uneven ground preparation.

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

– If the load‑settlement curve does not appear, ensure your chart range includes all data rows. Adjust the chart to show settlement increasing downward (right‑click the Y‑axis, choose Format Axis , and tick Values in reverse order ).

An embedded, dynamic XY Scatter plot that automatically maps the Load-Settlement curve as data is entered. This visual representation allows engineers to immediately identify soil yielding points or anomalous readings. 3. Step-by-Step Data Processing and Formulas

Do you have a specific plate load test spreadsheet that you have developed? Share your experiences or questions in the comments below! plate load test report xls work

This guide provides a detailed walkthrough on how to create, structure, and automate a using Microsoft Excel.

By embedding these formulas once, the entire workbook becomes a reusable template.

The load-settlement curve (paste as a linked picture from the Charts tab).

$$Load (kN) = Pressure (kPa) \times Area (m^2)$$ Set up rules to highlight cells if differential

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

Document any anomalies – a sudden jump in settlement, a dial gauge that needed resetting, or rain during the test. Good notes improve the report’s credibility.

=IF(Max_Settlement > Allowable_Settlement, "⚠️ CRITICAL: Exceeds Settlement Limits", "✅ PASS: Settlement Within Safe Parameters") Use code with caution.

Stress (q)=Load (P)Area (A)Stress open paren q close paren equals the fraction with numerator Load open paren cap P close paren and denominator Area open paren cap A close paren end-fraction Adjust the chart to show settlement increasing downward

Pressure applied by the hydraulic jack.

A robust PLT Excel workbook should be divided into distinct, organized tabs to separate raw data from final presentation layouts. 1. Project Information Cover Sheet

=IF(settlement>25, "TEST TERMINATED – 25 mm limit reached", "OK")

Once the Excel work is done, interpret the data for the final report: Ultimate Bearing Capacity (