Plate Load Test Report Xls Work !!top!! (SIMPLE - Review)

Highlight the calculated column and the Average Settlement column.

Find the clear break point where settlement increases rapidly with little to no added load.

| Sheet 4: Loading Procedure | | | | --- | --- | --- | | Load Increment (kN) | | | | Duration (min) | | | | Number of Cycles | | |

A standard workbook is generally organized into these key sections: Plate Load Test - Insitutek

In geotechnical engineering, settlement is plotted downward. Right-click the Y-axis -> Format Axis -> Check the box for "Values in reverse order" . plate load test report xls work

Formula in F2: =AVERAGE(D2:E2) and drag down.

A professional-grade engineering report in Excel should be clean, logical, and highly organized. It is best practice to separate the workbook into three or four distinct tabs or clearly demarcated sections: 1. General Project Information (Header Block)

Built-in charting tools automatically plot the essential Load vs. Settlement curve as data is entered.

Use data validation to restrict time entries (e.g., 0, 1, 2.5, 5, 10, 15, 30 min intervals). Add a cell for Plate Area (A) and Plate Diameter (B) so pressure auto-calculates: =Load/(PI()*(B/2000)^2) (adjust units as needed). Highlight the calculated column and the Average Settlement

Select the calculated (Column C) and Average Settlement (Column F). Insert an XY Scatter Chart with smooth lines.

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 (

Set up page breaks and print layouts so the report fits perfectly onto standard A4 or Letter sizes without clipping the chart.

): The mathematical mean of all functioning dial gauge readings for a specific load step. Applied Stress ( Right-click the Y-axis -> Format Axis -> Check

σ=PA=Pπ⋅D24sigma equals the fraction with numerator cap P and denominator cap A end-fraction equals the fraction with numerator cap P and denominator the fraction with numerator pi center dot cap D squared and denominator 4 end-fraction end-fraction = Applied load (expressed in = Cross-sectional area of the plate ( m2m squared = Diameter of the circular plate ( Settlement Averaging

This is the core working area where field engineers input raw measurements during the test increments. The table columns generally feature:

SBC=UBCFactor of Safety (FOS)SBC equals the fraction with numerator UBC and denominator Factor of Safety (FOS) end-fraction Note: FOS typically ranges from to . 4. Load-Settlement Curve (Excel Graphing)

By standardizing your with precise formulas, strict standard adherence, inverted plotting methods, and clear separation of raw inputs from processing engines, you drastically reduce calculation errors, accelerate project turnarounds, and ensure structural safety on-site.