Plate Load Test Report Xls Work Jun 2026

s=Δ1+Δ2+Δ3+Δ4Ns equals the fraction with numerator cap delta sub 1 plus cap delta sub 2 plus cap delta sub 3 plus cap delta sub 4 and denominator cap N end-fraction Δncap delta sub n represents the displacement reading from gauge is the total number of dial gauges. Scale Effects and Foundation Prototype Extrapolation

Settlement is usually measured using two or three dial gauges.

Download our free starter template below (link placeholder) or share your own PLT Excel hacks in the comments. Let’s build safer foundations, one spreadsheet at a time.

Formatting Best Practices for Professional Engineering Reports

The hydraulic jack pressure or load cell force must be converted to contact stress ( plate load test report xls work

Specifically, the Load vs. Settlement Curve (Pressure-Settlement Curve).

Plate Load Test for Soil Bearing Capacity | PDF | Column - Scribd

Let's build a master template. Open a new Excel workbook and follow along.

Whether you are checking the subgrade for a highway pavement or the foundation for a high-rise, a well-prepared XLS report is your bridge between raw site data and engineering confidence. Let’s build safer foundations, one spreadsheet at a time

Download as XLSX, PDF, TXT or read online on Scribd. Plate Load Test DIN 18134 Ev1Ev2_LAb Form. Load Test Plate Specifications.

Before diving into the technicalities, let's address the tool. While advanced software like PLAXIS exists, Excel remains the industry standard for Plate Load Test reporting for several reasons:

While building your own is educational, many engineers need a turnkey solution. Several reputable geotechnical websites offer free and paid templates. Look for features like:

A standard report spreadsheet usually includes the following data sections: Plate Load Test for Soil Bearing Capacity |

Inputs from multiple gauges (usually 2 to 4) placed around the plate to capture differential settlement. 3. Automated Calculation Engine Using Excel formulas, this section processes the raw data. Average Settlement ( Savgcap S sub a v g end-sub ): Calculated using =AVERAGE(Gauge1, Gauge2, Gauge3) . Applied Stress ( ): Calculated by dividing the Applied Load ( ) by the cross-sectional area of the plate (

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

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.

If the load is monitored via hydraulic pressure gauge instead of a load cell, input the multiplier factor ( kN/barkN/bar Tab 3: Data Logging and Processing Matrix

Based on permissible settlement (often for foundations). Modulus of Subgrade Reaction (