Plate Load Test Report Xls Work |work| ★ Safe

Below is a comprehensive guide to designing, building, and using a plate load test reporting system in Excel—whether you are a geotechnical engineer, a civil contractor, or a student.

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

= AVERAGE(gauge1, gauge2, gauge3)

| Parameter | Value | Unit | Formula / Note | |-----------|-------|------|----------------| | | BH-01 | - | Input | | Plate diameter | 300 | mm | Input | | Plate area | 0.0707 | m² | =PI()*(0.3/2)^2 | | Max load applied | 100.0 | kN | Input | | Max pressure | 1414.2 | kPa | =Max Load / Area | | Settlement at max load | 5.80 | mm | From Sheet 2 | | Safe bearing capacity (SBC) | 282.8 | kPa | At 5 mm settlement (or 1/3 of failure) | | Modulus of subgrade reaction (K) | 48.8 | kN/m³ | =Pressure / Settlement (in meters) | | Modulus of elasticity (E_plate) | 15.2 | MPa | From initial linear slope | | Remarks | Soil: Sandy Silt, dry | - | - | plate load test report xls work

Explain how to for different soil types

diameter), Hydraulic Jack Calibration Factor, Dial Gauge Calibration. B. Raw Data Input (Data Collection)

Set up columns as follows:

Ensure dial gauges are placed on the diagonal opposite corners of the plate to calculate an average, mitigating uneven settlement. 5. Summary

Create columns for Date/Time, Time Elapsed, Applied Load Gauge Reading, Dial Gauge 1, Dial Gauge 2, and Average Settlement. Automate Calculations: Use formulas to calculate pressure ( ) and cumulative settlement.

): 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 ( Below is a comprehensive guide to designing, building,

A steel plate (usually 300mm to 750mm in diameter) is placed on the soil surface at the foundation level. A hydraulic jack applies incremental loads, and dial gauges measure the resulting settlement. The test is performed until either:

Create a dedicated cell block for your test constants. For example: Cell B5 : Plate Diameter (m) →right arrow 0.30 Cell B6 : Plate Area ( m2m squared →right arrow =(PI()*(B5^2))/4 Step 2: Set Up the Data Table

This is the core working area where field engineers input raw measurements during the test increments. The table columns generally feature: Raw Data Input (Data Collection) Set up columns

Protect calculation cells with a password, leaving only the raw load, time, and gauge columns unlocked for technicians. This preserves workbook integrity across multiple field deployments. If you need help building this template, tell me: Which testing standard you are following ( ASTM , BS , etc.) The diameter of the plate used in your field testing If you need specific VBA macros for automated charting

The end goal of the report is to recommend a safe bearing capacity for the actual foundation, which is often larger than the test plate. The Terzaghi and Peck method (outlined in BS 8004) is used to scale the results.