Plate Load Test Report Xls Work __hot__

This is what your client or site engineer will print. Design it like a dashboard.

), plate shape (circular or square), and hydraulic jack capacity. 2. Observation Table (Data Entry)

Applied Stress (q)=Applied Force (kN)Area of Bearing Plate (m2)Applied Stress open paren q close paren equals the fraction with numerator Applied Force (kN) and denominator Area of Bearing Plate open paren m squared close paren end-fraction

(e.g., Initial, Loading Stage 1–8, Unloading Stage 1–4). plate load test report xls work

A plate load test is a field test used to determine the bearing capacity of soil and settlement of structures under loads. The test involves applying a load to a steel plate placed on the soil surface and measuring the resulting settlement. The data collected from the test is used to estimate the bearing capacity of the soil and to design foundations.

Deflection measurements from at least two (preferably three or four) dial gauges placed at opposite edges of the plate to monitor tilting. Calculated Data Output Table

Find the clear break point where settlement increases rapidly with little to no added load. This is what your client or site engineer will print

You might ask: Why not use dedicated geotechnical software like gINT or Plaxis?

You need to calculate the . This usually involves two methods defined in standards like IS:1888 or ASTM D1194.

Plate Load Test - Equipment, Procedure, Calculation - Scribd The test involves applying a load to a

However, for those who wish to build their own custom tool or want a detailed understanding of the mechanics inside a professional sheet, the following guide breaks down how to construct a robust PLT report using the core functions of Microsoft Excel.

Select the pressure and settlement columns to insert a scatter chart with lines, ensuring the graph is clear and labeled properly.