Determine ultimate bearing capacity and allowable bearing pressure. 2. Key Components of a Plate Load Test Excel Template
= AVERAGE(Dial_1_mm, Dial_2_mm, Dial_3_mm, Dial_4_mm) Modulus of Subgrade Reaction (
Stress (q)=Load (P)Area (A)Stress open paren q close paren equals the fraction with numerator Load open paren cap P close paren and denominator Area open paren cap A close paren end-fraction plate load test report xls work
Standardized templates prevent manual calculation errors across different project teams.
Protect formulas using Excel’s sheet protection feature. Leave only the general information and raw data columns unlocked to prevent accidental alterations to the underlying physics and engineering math. Protect formulas using Excel’s sheet protection feature
Δs=R1+R2+R3+R44delta s equals the fraction with numerator cap R sub 1 plus cap R sub 2 plus cap R sub 3 plus cap R sub 4 and denominator 4 end-fraction
By entering the actual footing width (B) into a parameter cell in Excel, the report can instantly predict real-world settlement of the structure for code compliance verification. To make your Excel sheet functional, you must
To make your Excel sheet functional, you must program specific cell formulas. Below are the primary equations required: Area of the Bearing Plate ( For a standard circular plate: