Plate Load Test Report Xls Work [updated] -
Use the feature in Excel to plot the Pressure vs. Average Settlement .
According to IS: 1888-1982 and BS 8004, the key objectives of the test are to determine:
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.
This tab contains the metadata of the project. It sets the context for the entire report and should include: Project name, location, and contract number. Date of testing and weather conditions. Test depth, water table level, and soil description. plate load test report xls work
The curve shows a distinct, sharp break.
If Gauge 1 and Gauge 2 show a variance greater than 20%, it indicates plate tilting due to poor seating. Flag this using an IF statement: =IF(ABS(D2-E2)>0.2*AVERAGE(D2,E2), "Review Seating", "OK") Best Practices for Geotechnical Reporting
To help me provide or build the exact spreadsheet setup you need, could you share a few more details? Please let me know: Your (e.g., 300mm, 450mm, 600mm) The units your field gauges use (e.g., bar, kg/cm², kN) Use the feature in Excel to plot the Pressure vs
Protect formulas using Excel’s sheet protection feature. Leave only the general information and raw data columns unlocked to prevent accidental alterations to the underlying physics and engineering math.
Before opening Excel, you need your raw field data. A standard PLT report requires specific input variables.
ks=ΔσΔSk sub s equals the fraction with numerator cap delta sigma and denominator cap delta cap S end-fraction Best Practices for Managing PLT Excel Files This link or copies made by others cannot be deleted
Settlement is directly proportional to the width/diameter of the loading area:
Instantly plots the Load-Settlement graph to interpret soil behavior.
This section establishes the context of the test for quality assurance and compliance tracking.
A standard calculation workbook must process the following variables: Applied Load (