Area (m2)=π×D24Area open paren m squared close paren equals the fraction with numerator pi cross cap D squared and denominator 4 end-fraction
To create an effective PLT XLS work file, follow these steps:
The final section of your Excel workflow should summarize critical verification checks automatically using logical functions. ✅ Automated Geotechnical Evaluation
| | | | --- | --- | | Loading Sequence | 10 kN, 20 kN, 30 kN, ... | | Equipment Used | Hydraulic jack | plate load test report xls work
Instead of maintaining separate individual workbooks for every test, use a :
: Technical guides from Douglas Partners or Tensar U.K. provide the theory behind the interpretation of these reports.
The Plate Load Test involves applying a known load to a steel plate placed at the foundation level and measuring the resulting settlement. The data collected allows engineers to determine: Area (m2)=π×D24Area open paren m squared close paren
sf=spâ‹…(BfBp)s sub f equals s sub p center dot open paren the fraction with numerator cap B sub f and denominator cap B sub p end-fraction close paren For Cohesionless Soils (Sand):
The is a cornerstone of geotechnical site investigations . It provides a direct measurement of the soil’s bearing capacity and settlement characteristics, which are critical for designing shallow foundations. However, the true value of the test lies in the accuracy of the plate load test report .
Plate diameter and shape (typically circular, 300mm to 760mm). provide the theory behind the interpretation of these
IS 1888 provides an alternative expression that also includes a constant (0.30 m) to account for the influence depth. Both can be implemented as simple cell formulas.
Below is a comprehensive guide on how to structure, calculate, and automate a plate load test report using an Excel spreadsheet ( .xls or .xlsx ). 1. Structure of a Plate Load Test Excel Template
This article provides a comprehensive guide to understanding, creating, and utilizing a format.