Here's a basic outline of an XLS template for a plate load test report:
You must record the unloading cycle to see the elastic rebound. plate load test report xls work
A plate load test is a field test used to determine the bearing capacity of soil and settlement of structures under loads. The test involves applying a load to a steel plate placed on the soil surface and measuring the resulting settlement. The data collected from the test is used to estimate the bearing capacity of the soil and to design foundations. Here's a basic outline of an XLS template
A report without a graph is just a spreadsheet. Your XLS should automatically generate two plots: plate load test report xls work
Typical table:
Example dynamic named range for settlement: =OFFSET(Calculations!$A$2,0,0,COUNTA(Calculations!$A:$A)-1,1)