You might ask: Why not use dedicated geotechnical software like gINT or Plaxis?
According to IS: 1888-1982 and BS 8004, the key objectives of the test are to determine:
qu,foundation=qu,plate×(BfoundationBplate)q sub u comma foundation end-sub equals q sub u comma plate end-sub cross open paren the fraction with numerator cap B sub foundation end-sub and denominator cap B sub plate end-sub end-fraction close paren Bfoundationcap B sub foundation end-sub = Width of the actual foundation footing Bplatecap B sub plate end-sub = Width of the test plate (typically Settlement Computations ( To extrapolate the settlement of a prototype footing ( Sfcap S sub f ) from the measured plate settlement ( Spcap S sub p
diameter), Hydraulic Jack Calibration Factor, Dial Gauge Calibration. B. Raw Data Input (Data Collection) plate load test report xls work
Use Excel’s "Protect Sheet" feature to lock calculation cells. This prevents site technicians from accidentally deleting critical engineering formulas.
Area (A)=π×d24Area open paren cap A close paren equals the fraction with numerator pi cross d squared and denominator 4 end-fraction In Excel: =Load / ((PI() * (Diameter^2)) / 4) 4. Charting and Curve Analysis
Multipliers to convert hydraulic pressure gauge readings ( kg/cm2kg/cm squared ) into absolute Force ( Zone B: Raw Field Data Entry Matrix You might ask: Why not use dedicated geotechnical
=AVERAGE(E10:H10) (Where E10 through H10 contain the individual dial gauge readings for that step) . D. Modulus of Subgrade Reaction (
=AVERAGE(C11, D11) (Assuming Gauges are in Columns C and D).
is identified from the chart data, calculate the safe bearing capacity by applying an appropriate Factor of Safety ( FOScap F cap O cap S Raw Data Input (Data Collection) Use Excel’s "Protect
Comprehensive Guide to Creating a Plate Load Test Report in Excel
The report should conclude with the determined values for the site:
