Unified Soil Classification System (USCS) in an Excel spreadsheet
Watch the Related Videos on Our YouTube Channel (in English):
To utilize the Unified Soil Classification System (USCS) in an Excel spreadsheet for soil classification in geotechnical engineering, you can follow a structured approach. First, input your soil test data, such as grain size distribution (sieve analysis) and Atterberg limits (liquid and plastic limits). Create columns for parameters like particle size percentages (gravel, sand, silt, clay), and consistency limits.
Using these data, set up logical conditions and formulas in Excel to classify the soil. For example, if more than 50% of the particles pass through the No. 200 sieve, it would be classified as “fine-grained,” whereas if less than 50% pass, it would be “coarse-grained.” Use additional conditions based on plasticity index (PI) and liquid limit (LL) to further refine the classification into categories like CL (clay with low plasticity), ML (silt with low plasticity), or SM (silty sand). By organizing the data into such formulas, Excel can automatically classify soils according to USCS standards based on the inputted test results, streamlining the soil classification process.
GP-GC is a dual classification in the Unified Soil Classification System (USCS), representing a soil mixture that consists of poorly graded gravel (GP) and clayey gravel (GC). Poorly graded gravel indicates a lack of a wide range of particle sizes, meaning the gravel is uniform in size, while the clayey component suggests the presence of a significant amount of clay, which affects the soil’s cohesiveness and plasticity. This type of soil generally has lower permeability and higher compressibility due to the clay content
✅ Instagram Page Address:
☑ https://www.instagram.com/academy.dr.fahmi
✅ Excel Spreadsheets for Soil Mechanics & Foundation Engineering
✅ Geotechnical Excel Programs & Lectures
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi