Plate Load Test Report Xls Work -

Crucial for raft foundation and pavement design, the modulus of subgrade reaction is computed from the initial straight-line portion of the load-settlement curve:

In the world of geotechnical engineering, the is non-negotiable. It is the field test that directly measures the bearing capacity and settlement characteristics of soil and rock. Without it, designing a safe foundation is guesswork.

This simple formula, repeated for every load level, automatically builds a table of predicted prototype settlements without any manual arithmetic. plate load test report xls work

For cohesive soils, this is the pressure at which the settlement continues rapidly without any further increase in load. In loose or sandy soils where a clear failure point is missing, engineers use the Excel data to find the pressure corresponding to a specific settlement limit (e.g., 25mm). Modulus of Subgrade Reaction (

While laboratory tests give us soil parameters, the is the gold standard for determining the ultimate bearing capacity and settlement characteristics of soil in situ. Crucial for raft foundation and pavement design, the

Before we dive into the report preparation, it's essential to understand the plate load test procedure:

– 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. This simple formula, repeated for every load level,

Chainage, borehole reference number, and reduced level (RL) of the test strata.

The header of your spreadsheet should capture the context of the test: Project name, location, and client.

: Site location, test date, plate size (commonly 300mm to 750mm), and foundation details. Equipment Details

Before you touch the numbers, your XLS file should have a cover or header sheet containing: