The most critical output. Use Excel’s . X-Axis: Settlement (mm). Y-Axis: Load/Pressure (
An automated XLS template should use the following formulas to save time: plate load test report xls work
Design this for mobile or tablet use in the field. Use "Data Validation" in Excel to create dropdowns for plate sizes and soil types. Include a section for "Visual Soil Classification" (e.g., Silty Sand, Stiff Clay). Tab 2: The Load-Settlement Curve The most critical output
Standardized templates prevent manual calculation errors across different project teams. Y-Axis: Load/Pressure ( An automated XLS template should
The "break point" on this curve identifies the ultimate bearing capacity. Tab 3: Summary of Results A clean, printable page that summarizes the final findings: Net Safe Bearing Capacity. Estimated Settlement for the actual foundation size. Modulus of Subgrade Reaction ( Why Use XLS for PLT Reports? Automation: Automatically calculate the value as soon as the load-settlement data is entered.
Average of all dial gauge readings for a specific load. Bearing Pressure: