The total downward movement at the end of each loading stage. 2. Essential Formulas for the Excel Workflow
ks=qδk sub s equals the fraction with numerator q and denominator delta end-fraction is the pressure and
A typical plate load test report xls work includes the following components: plate load test report xls work
Readings taken at 1, 5, 10, 20, 40, and 60 minutes for each increment.
= Gross_Force / (PI() * (Plate_Diameter_Meters^2) / 4) C. Average Settlement Calculation The total downward movement at the end of each loading stage
Sequence of pressure applied (usually in increments of or similar). Time (min): Recorded at intervals (e.g., minutes).
): The total load at failure divided by the area of the plate. Calculated as divided by a Factor of Safety (typically 3). Modulus of Subgrade Reaction ( = Gross_Force / (PI() * (Plate_Diameter_Meters^2) / 4) C
Total time: 10 minutes. Total errors: Zero.
End Sub