The primary objective of a plate load test is to plot a load-settlement curve. This curve helps determine the ultimate bearing capacity of the soil and the modulus of subgrade reaction ( ), which is vital for foundation and pavement design.
Typical table:
Such a layout communicates professionalism to clients and regulators alike.
The physical reading from the pressure gauge or load cell.
Below is a comprehensive guide to designing, building, and using a plate load test reporting system in Excel—whether you are a geotechnical engineer, a civil contractor, or a student. plate load test report xls work
Streamlining Your Site Investigation: How to Master Plate Load Test Reporting with Excel (XLS)
Do you have a specific plate load test spreadsheet that you have developed? Share your experiences or questions in the comments below!
In this guide, we will walk through the process of analyzing Plate Load Test data and generating a comprehensive, professional report using Microsoft Excel (XLS).
A messy spreadsheet screams "unprofessional." Here is a checklist to polish your XLS file: The primary objective of a plate load test
Save the workbook as Plate_Load_Test_Template.xltx . For each new project, open this template and “Save As” a new file, preserving the original formulas and layout.
Usually 3 or 4 gauges placed 120° or 90° apart for accuracy. Average Settlement: The average of the dial gauges ( C. Analysis & Calculations (The Core of the XLS Work) Applied Pressure ( ): Calculated by dividing Load ( ) by Plate Area ( Settlement ( ): Total or net settlement at each stage. Log Time: For analyzing consolidation. 3. Step-by-Step Excel Calculations for PLT
Jack capacity, reaction load setup, and dial gauge calibration data.
In the realm of civil engineering and construction, ensuring the stability and safety of structures is paramount. One crucial aspect of achieving this is through conducting plate load tests, which provide valuable insights into the bearing capacity of soil and the settlement characteristics of foundations. The results of these tests are often compiled into a plate load test report, a critical document that informs design and construction decisions. In this article, we will explore the intricacies of plate load test report XLS work, providing a detailed guide on how to effectively utilize Excel (XLS) for analyzing and reporting plate load test data. The physical reading from the pressure gauge or load cell
If no clear break point exists, the ultimate capacity is often defined as the pressure corresponding to a settlement equal to 10% of the plate diameter. Use Excel's INDEX and MATCH formulas to find or interpolate this value. Safe Bearing Capacity ( qsafeq sub s a f e end-sub
A well‑designed Excel system acts as both a and a report generator , turning field notes into a compliant document in minutes.
| Column A | Column B | Column C | Column D | Column E | Column F | |----------|----------|----------|----------|----------|----------| | | Load (kN) | Proving Ring Reading (div) | Dial Gauge 1 (mm) | Dial Gauge 2 (mm) | Avg Settlement (mm) |
Go to > Charts > X-Y Scatter (with Smooth Lines and Markers) .