Plate Load Test Report Xls Work -

A plate load test (PLT) report in Excel ( ) is a critical geotechnical engineering document used to determine the ultimate bearing capacity and settlement characteristics of soil. By automating calculations in Excel, engineers can quickly translate field measurements into actionable design parameters for foundations. 1. Essential Report Components

1. Select Data: Highlight Pressure/Intensity (Col D) and Cumulative Settlement (Col H).
2. Insert Chart: Go to Insert > Scatter > Scatter with Smooth Lines and Markers.
3. Axis Setup:
   • Plot chart → Add trendline → Power → Display equation.
   • Then manually compute: Pressure = a * Settlement^b. Use =a * (40^b) to find pressure at 40mm.

   | Results | | | --- | --- | | Bearing Capacity | 150 kPa | | Settlement | 2.5 mm | plate load test report xls work

   Step 3: Calculating Key Parameters

   • Calculate the following key parameters:

     Call to Action: 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. A plate load test (PLT) report in Excel

     Load-Settlement Curve