=AVERAGE(Input!D2:F2) – This averages the three dial gauges.
The Plate Load Test (PLT) is used to determine the bearing capacity of soil and the settlement characteristics under a given load. Excel is the industry standard for this because it handles the repetitive calculations and graphical plotting required for the report. plate load test report xls work