Plate Load Test Report Xls Work !!hot!!
Formula for pressure: Pressure = Load / (π × (Plate Dia/2)²) Example: Plate diameter = 300 mm (0.3 m), area = 0.0707 m² In B2: =Load / 0.0707
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. plate load test report xls work
To build a robust Excel sheet, you first need to structure your raw data. A standard PLT report requires the following inputs: Formula for pressure: Pressure = Load / (π
Based on the settlement criteria (e.g., 10% of plate diameter or 5mm), your XLS should automatically: Modulus of Subgrade Reaction ( Why Use XLS for PLT Reports