Identified as the point where the load-settlement curve breaks or settlement increases rapidly. Safe Bearing Capacity (SBC):
A standard report spreadsheet usually includes the following data sections: plate load test report xls work
Use OFFSET and COUNTA functions so your charts automatically expand when you add more load increments. Identified as the point where the load-settlement curve
q=Applied Load (kN)Area of Plate (m2)q equals the fraction with numerator Applied Load (kN) and denominator Area of Plate (m squared ) end-fraction Tab 3: Summary of Results A clean, printable
The "break point" on this curve identifies the ultimate bearing capacity. Tab 3: Summary of Results A clean, printable page that summarizes the final findings: Net Safe Bearing Capacity. Estimated Settlement for the actual foundation size. Modulus of Subgrade Reaction ( Why Use XLS for PLT Reports? Automation: Automatically calculate the value as soon as the load-settlement data is entered.
| Load Increment (kN) | Duration (min) | Number of Cycles | | --- | --- | --- | | 50 | 10 | 3 |