Features of the Smart Soil Texture Excel Add-in
The Smart Soil Texture Excel Add-in is an innovative tool from Smartstat that provides Excel functions or formulas to determine soil texture classes. It utilizes the percentages of sand, silt, and clay content in a soil sample to categorize soil texture according to the USDA classification system.
By entering input data such as the percentages of sand, silt, and clay, users can easily determine which of the 12 soil texture classes best matches their sample. This is an invaluable tool for professionals in the fields of agriculture, geology, and ecology, as well as for anyone looking to gain a deeper understanding of the physical properties of soil.
In addition, this add-in provides results in both Indonesian and English, making it easier for users from different language backgrounds to understand.
With the Smart Soil Texture Add-in, soil texture analysis becomes easier, faster, and more accurate, helping you to make the right decisions based on concrete data.
Download: Smart Soil Texture by Smartstat
Example of Using the Smart Soil Texture Function:
Explanation of the Smart Soil Texture Function:
Formula | =Texture(Sand, Silt, Clay, [Language]) |
Arguments: | Value |
Sand: | Percentage of sand content |
| Silt: | Percentage of silt content |
| Clay: | Percentage of clay content |
Language | "EN" or "ID" (Default "EN") |
Note:
Arguments are separated by a separator (, or ;)
Indonesian Regional Setting: Arguments are separated by a ;
Example: =Texture(A5;B5;C5;"ID")
English Regional Setting: Arguments are separated by a ,
Example: =Texture(A5,B5,C5,"ID")
[Language] is optional, can be filled or left blank. The default language is English
Example: =Texture(A5,B5,C5) (If the language argument is not filled, the spelling will be in English)
Usage Examples:
English
Sand | Silt | Clay | Texture | Formula |
12 | 40 | 48 | Silty Clay | =Texture(A5,B5,C5) |
6 | 21 | 73 | Clay | =Texture(A6,B6,C6, "EN") |
16 | 39 | 45 | Clay | =Texture(A7,B7,C7) |
19 | 63 | 18 | Silt Loam | =Texture(A8,B8,C8) |
Indonesian
Sand | Silt | Clay | Texture | Formula |
12 | 40 | 48 | Silty Clay | =Texture(A5,B5,C5,"ID") |
6 | 21 | 73 | Clay | =Texture(A6,B6,C6,"ID") |
16 | 39 | 45 | Clay | =Texture(A7,B7,C7,"ID") |
19 | 63 | 18 | Silt Loam | =Texture(A8,B8,C8,"ID") |
