Plate Load Test Report Xls Work ⇒ [ TRENDING ]

= Target_Stress_Cell / Settlement_Cell (Evaluated at the specified settlement limit, typically 1.25mm or 2.5mm according to regional standards like ASTM D1194 or IS 1888) . 3. Step-by-Step Data Entry and Workflow in Excel

Adjustments made for any initial seating errors or equipment flexing. 4. Graphic Visualization (The Stress-Settlement Curve)

A graphical representation is mandatory for any credible plate load test report. Excel can automatically update the chart when field data is entered. plate load test report xls work

Test number (e.g., PLT-01), date, and weather conditions. Equipment Specs: Plate diameter (commonly , , or

According to IS: 1888-1982 and BS 8004, the key objectives of the test are to determine: Test number (e

) at any load increment is the arithmetic mean of all gauge readings:

An automated XLS template should use the following formulas to save time: To visualize the soil's behavior

Average of all dial gauge readings for a specific load. Bearing Pressure:

Highlight the calculated column and the Average Settlement column.

To visualize the soil's behavior, plot a using a "Scatter with Smooth Lines" chart in Excel: X-axis: Load Intensity ( kN/m2kN/m squared or kg/cm2kg/cm squared ). Y-axis: Average Settlement ( ).

The K-value is calculated as the pressure (p) divided by the settlement (s) for a given load.