Create columns for Date/Time, Time Elapsed, Applied Load Gauge Reading, Dial Gauge 1, Dial Gauge 2, and Average Settlement. Automate Calculations: Use formulas to calculate pressure ( ) and cumulative settlement.
Client, Site Location, Date of Test, Soil Description. Equipment Details: Plate Size (e.g.,
A high-quality report template is a powerful tool, but designing one from scratch can be complex. For professionals seeking a reliable, pre-built solution, the offers an excellent, ready-to-use template. This spreadsheet is designed to convert plate-bearing test results directly into an allowable bearing capacity that satisfies BS 8004.
To build or operate a PLT Excel template successfully, specific mathematical relationships must be programmed into the worksheet cells. Step 1: Calculate Plate Surface Area The area ( ) depends on the plate diameter ( ). Common diameters are 300 mm, 450 mm, 600 mm, and 750 mm.
The most critical output of a Plate Load Test report is the . Visualizing this properly requires specific chart configurations. Plotting the Load-Settlement Curve plate load test report xls work
| Parameter | Value | Unit | Formula / Note | |-----------|-------|------|----------------| | | BH-01 | - | Input | | Plate diameter | 300 | mm | Input | | Plate area | 0.0707 | m² | =PI()*(0.3/2)^2 | | Max load applied | 100.0 | kN | Input | | Max pressure | 1414.2 | kPa | =Max Load / Area | | Settlement at max load | 5.80 | mm | From Sheet 2 | | Safe bearing capacity (SBC) | 282.8 | kPa | At 5 mm settlement (or 1/3 of failure) | | Modulus of subgrade reaction (K) | 48.8 | kN/m³ | =Pressure / Settlement (in meters) | | Modulus of elasticity (E_plate) | 15.2 | MPa | From initial linear slope | | Remarks | Soil: Sandy Silt, dry | - | - |
When you look at your Excel chart, you will see one of two behaviors:
): The ultimate capacity divided by an appropriate factor of safety ( FScap F cap S , usually between 2.5 and 3.0). The ratio of pressure ( ) to the corresponding settlement ( ), expressed as: ks=qsk sub s equals q over s end-fraction Modulus of Elasticity ( Escap E sub s
A graphical representation is mandatory for any credible plate load test report. Excel can automatically update the chart when field data is entered. Create columns for Date/Time, Time Elapsed, Applied Load
Instead of maintaining separate individual workbooks for every test, use a :
Stress (q)=Total Force (kN)Area (A)Stress open paren q close paren equals the fraction with numerator Total Force (kN) and denominator Area open paren cap A close paren end-fraction Step 3: Compute Average Settlement For a setup with three dial gauges (
A comprehensive Excel workbook for PLT should contain the following sheets: A. Project Information & Setup
Here's a basic outline of an XLS template for a plate load test report: Equipment Details: Plate Size (e
: This is the most common method for granular soils.
Comprehensive Guide to Creating a Plate Load Test Report in Excel
| Sheet 4: Loading Procedure | | | | --- | --- | --- | | Load Increment (kN) | | | | Duration (min) | | | | Number of Cycles | | |
A structured grid where field technicians input observations directly from the data sheets.