Plate Load Test Report Xls Work |link|

In geotechnical engineering, determining the bearing capacity of soil is paramount for the stability of structures. The (PLT) is a field test performed to evaluate the ultimate bearing capacity of ground and the probable settlement under a given load, following standards such as ASTM D1194 or ASTM D1195 .

A standard report spreadsheet usually includes the following data sections:

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

$$Settlement (mm) = 0.05 \times Load (kN) + 0.2$$

If you are developing a field testing sheet or optimizing a geotechnical report template, I can assist you with structuring the automation. plate load test report xls work

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

| | | | --- | --- | | Test Number | 1 | | Location | Site A | | Date | 2022-01-01 |

By implementing these steps and best practices, you'll turn a simple spreadsheet into a powerful, indispensable tool for your geotechnical engineering work. This system empowers you to deliver accurate, consistent, and highly professional reports with speed and confidence.

Several platforms offer specialized spreadsheets that automate the calculation of bearing capacity and settlement from raw field data. This link or copies made by others cannot be deleted

The safe load considering a factor of safety. Modulus of Subgrade Reaction (

The test involves applying a known, incremental compressive load to a thick steel plate placed at the foundation level. Settlement is measured using high-precision dial gauges or digital displacement transducers positioned at opposite edges of the plate to monitor tilting. Key Geotechnical Formulae Ultimate Bearing Capacity ( ) for Clayey Soils

Set the print area to fit on a single landscape A4 sheet for clean PDF exports and field submissions. Try again later

Converts the total applied load force into bearing pressure.

Here's a step-by-step guide to creating a plate load test report in XLS format:

In your Excel sheet, you must calculate the for the actual footing.

If you need to compare measured bearing capacity with empirical formulas (e.g., Terzaghi’s equation), add a separate sheet that pulls data from the calculation engine and runs comparative analyses.

| | | | --- | --- | | Loading Sequence | 10 kN, 20 kN, 30 kN, ... | | Equipment Used | Hydraulic jack |