An automated XLS template should use the following formulas to save time:
A professional Plate Load Test Excel report should contain the following sheets or sections: A. Project Information & Setup Detailed site description. Test Pit ID/Location: Specific location of the test. plate load test report xls work
| Sheet 2: Test Setup | | | | --- | --- | --- | | Plate Size (mm) | | | | Plate Thickness (mm) | | | | Loading Device | | | | Settlement Measurement Device | | | An automated XLS template should use the following
This sheet is where field observations are entered. Organise it as a clean table with the following columns: | Sheet 2: Test Setup | | |
An embedded, automated X-Y Scatter plot displaying the Load vs. Settlement Curve . 2. Essential Geotechnical Formulas for Excel Automation
| 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] |
A comprehensive report usually includes the following technical data: