Jack capacity, dial gauge calibration factors, plate diameter ( ), and plate weight. Sheet 2: Data Entry & Calculations Matrix
Keep a clean master file named PLATE_LOAD_TEST_TEMPLATE_REV0.xltx . Save individual testing files separately under specific project identifiers (e.g., PLT-REPORT-PIT03-JOB2026.xlsx ) to prevent corruption of your core reporting framework. plate load test report xls work
An institutional-grade Excel workbook for geotechnical reporting should be divided into clean, functional tabs to preserve data integrity and enhance usability. dial gauge calibration factors
In geotechnical engineering, settlement is plotted downward. Right-click the Y-axis -> Format Axis -> Check the box for "Values in reverse order" . plate diameter ( )
Averages the dial gauge readings to account for minor uneven tilting of the plate during loading.