Highlight your calculated column and Average Settlement (mm) column. Insert an XY Scatter Chart with smooth lines and markers. Place Applied Stress on the horizontal X-axis. Place Settlement on the vertical Y-axis.
A Load-Settlement Curve showing the relationship between applied pressure ( ) and deformation ( 2. Essential Excel (.xls) Workflow for Plate Load Tests
– Check that the average settlement, pressure, and Kₛ have updated correctly. Look for any obvious outliers (e.g., a dial gauge that was knocked) and decide whether to exclude that reading.
Apply your project’s Factor of Safety (FOS), which typically ranges from 2.5 to 3.0: plate load test report xls work
Using an automated Excel spreadsheet ( .xls or .xlsx ) transforms this tedious process into an efficient, error-free workflow. The Role of Excel in Geotechnical Reporting
Data entry took 20 minutes per test. The Excel sheet automatically updated graphs, applied the 750mm plate correction factor, and exported a PDF report. Total time for 6 tests: 3 hours.
The plate load test involves applying a known static load to a steel plate placed at the foundation level and measuring the corresponding settlement. The data collected forms the foundation for designing shallow foundations, pavements, and heavy equipment slabs. Test Mechanics and Standards Highlight your calculated column and Average Settlement (mm)
Settlement is directly proportional to the width/diameter of the loading area:
Multipliers to convert hydraulic pressure gauge readings ( kg/cm2kg/cm squared ) into absolute Force ( Zone B: Raw Field Data Entry Matrix
| | | | --- | --- | | Soil Type | Clay | | Density | 18 kN/m³ | | Moisture Content | 20% | Place Settlement on the vertical Y-axis
If the curve shows a clear peak: $$Ultimate Bearing Capacity (q_u) = \frac\textUltimate Load\textPlate Area$$
Project name, location, and unique test identification numbers. Date of testing and prevailing weather conditions. Depth of the test pit and description of the soil strata.