Ensure only numerical values are entered in load and dial gauge columns. Automatic Calculations: Use formulas for
An embedded, automated X-Y Scatter plot displaying the Load vs. Settlement Curve . 2. Essential Geotechnical Formulas for Excel Automation
Standard intervals (e.g., 1, 2, 4, 8, 15, 30, 60 mins) to track settlement stability. plate load test report xls work
In the quiet of the trailer, the spreadsheet felt like a confession. A 0.5mm difference in cell was the gap between a safe structure and a catastrophe buried twenty years in the future. He looked at the "Summary of Results" tab. It was currently a sea of red "FAIL" flags.
qa=quFOSq sub a equals the fraction with numerator q sub u and denominator cap F cap O cap S end-fraction Ensure only numerical values are entered in load
Jack capacity, dial gauge calibration factors, plate diameter ( ), and plate weight. Sheet 2: Data Entry & Calculations Matrix
The stress distributed to the soil is the applied force divided by the area of the testing plate: dial gauge calibration factors
Your first dial gauge reading is initial reading , not zero settlement. Always calculate Settlement = Current_Reading - Initial_Reading . Your XLS formula should be: =D2-$D$2 (absolute reference to first reading).