Plate Load Test Report Xls Work //top\\ 〈Firefox〉

A report or "paper" on the focuses on determining the ultimate bearing capacity and settlement behavior of soil for foundation design. For professionals working with Excel ( .xls ) files for calculations, the workflow typically includes recording load-settlement data in the field and processing it to find the Safe Bearing Capacity (SBC) . Core Components of a Plate Load Test Report

$$SBC = \frac\textLoad at Permissible Settlement\textFactor of Safety (usually 2 or 2.5)$$ plate load test report xls work

| Pressure (kPa) | Settlement (mm) | Corrected Settlement | |----------------|----------------|----------------------| | 0 | 0.00 | 0.00 | | 70.7 | 0.11 | 0.11 | | 141.4 | 0.27 | 0.27 | | 282.8 | 0.63 | 0.63 | | 565.7 | 1.38 | 1.38 | | 848.5 | 2.50 | 2.50 | | 1131.4 | 4.00 | 4.00 | | 1414.2 | 5.80 | 5.80 | A report or "paper" on the focuses on

If you used a smaller plate (e.g., 300mm) but the actual footing is larger (e.g., 1.5m), you must correct the settlement. Excel should include a cell for "Proposed Footing Size" and apply the correction formula (typically used in IS 1888): Excel should include a cell for "Proposed Footing

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.

Several professional Plate Load Test (PLT) report templates and Excel-based calculation sheets are available to help automate soil bearing capacity analysis based on standards like ASTM D1194 Excel Templates & Workbooks