Suppose we conducted a plate load test on a clay soil with a plate size of 300 mm x 300 mm. The test setup, soil properties, loading procedure, and settlement measurements are as follows:
It is not just about typing numbers into cells. Professional "XLS work" for PLT includes: plate load test report xls work
Let's build a master template. Open a new Excel workbook and follow along. Suppose we conducted a plate load test on
Use OFFSET and COUNTA functions so your charts automatically expand when you add more load increments. Open a new Excel workbook and follow along
A is a critical field test used to determine the Ultimate Bearing Capacity of soil and its probable settlement under a specific load. To "work" a report in Excel (XLS), you must document the incremental application of load and the corresponding settlement over time. Typical Plate Load Test Report Structure (XLS)
Always verify the units! Mixing up kN (KiloNewtons) with kg (Kilograms) or meters with millimeters is the most common error in Excel-based engineering reports.