SPREADSHEET MACRO TO DETERMINE USDA SOIL TEXTURAL SUBCLASSES

Texture is an important soil characteristic that is routinely determined in many soils-related studies. Although many investigators employ spreadsheets to calculate the data needed for texture determinations, a good computer-based method to identify the complete name for the texture has not been reported. In this study, I developed a technique that integrates seamlessly with spreadsheets and determines the names of the USDA soil textural subclasses. The technique uses laboratory particle size analysis data and employs a macro to execute a quantitative key to the textural subclasses. The macro is easy to use because it is incorporated in a spreadsheet file, can be called from a textbox or user defined button, and can be edited by anyone with a basic background in macro languages. The macro was written in Excel for Windows version 4.0 macro language, but opens in more recent versions of Excel for Windows and Mac. The macro has advantages over manual methods because it is much faster and not prone to errors. Advantages over existing computer-based methods are that it returns names for textural subclasses, as opposed to textural classes, requires no installation, and has a flat learning curve.

[1]  T. Christopher,et al.  A computer program to determine the soil textural class in 1–2–3 for windows and excel , 1996 .

[2]  P. Martikainen,et al.  Methane oxidation in soil profiles of Dutch and Finnish coniferous forests with different soil texture and atmospheric nitrogen deposition , 1997 .

[3]  B. Jaffee,et al.  Effect of soil moisture and texture on transmission of the nematophagous fungus Hirsutella rhossiliensis to cyst and root-knot nematodes , 1992 .

[4]  Y. Mori,et al.  Discriminating The Influence Of Soil Texture And Management-induced Changes In Macropore Flow Using Soft X-rays , 1999 .

[5]  S. Koenning,et al.  Impact of Soil Texture on the Reproductive and Damage Potentials of Rotylenchulus reniformis and Meloidogyne incognita on Cotton. , 1996, Journal of nematology.

[6]  S. Nagarajah.  Effects of Soil Texture on the Rooting Patterns of Thompson Seedless Vines on Own Roots and on Ramsey Rootstock in Irrigated Vineyards , 1987, American Journal of Enology and Viticulture.

[7]  M. Gerzabek,et al.  Cesium‐137 in soil texture fractions and its impact on cesium‐137 soil‐to‐plant transfer , 1992 .

[8]  USING SOIL TEXTURE TO ESTIMATE SATURATED HYDRAULIC CONDUCTIVITY AND THE IMPACT ON RAINFALL‐RUNOFF SIMULATIONS , 1992 .

[9]  I. Levin,et al.  Soil texture parameterization of the methane uptake in aerated soils , 1993 .

[10]  G. Ågren,et al.  Theoretical analyses of soil texture effects on organic matter dynamics , 1997 .

[11]  J. Sánchez-Pérez,et al.  Variation in nutrient levels of the groundwater in the Upper Rhine alluvial forests as a consequence of hydrological regime and soil texture , 1997 .

[12]  N. R. Yao,et al.  Available water of a ferrallitic soil along the Kossou Lakeside slope (Ivory Coast) as affected by soil texture , 1994 .

[13]  J. Hassink,et al.  Effects of soil texture and grassland management on soil organic C and N and rates of C and N mineralization , 1994 .

[14]  V. Vallès,et al.  Effet de la texture et du potentiel hydrique des sols sur l'expression du charbon des inflorescences du maïs (Graminées, Poaceae) , 1989 .

[15]  E. Skidmore,et al.  Soil Aggregate and Texture Effects on Suspension Components from Wind Erosion , 1998 .

[16]  Guido D. Salvucci.  Limiting relations between soil moisture and soil texture with implications for measured, modeled and remotely sensed estimates , 1998 .

[17]  H. Madsen,et al.  The Influence of Texture, Soil Depth and Geology on pH in Farmland Soils , 1987 .

[18]  B. Gill,et al.  Evaporation from soil in relation to residue rate, mixing depth, soil texture and evaporativity , 1996 .

[19]  Volker Hennings,et al.  Ermittlung bodenphysikalischer Kennwerte in Abhängigkeit von Bodenart, Lagerungsdichte und Humusgehalt , 1995 .

[20]  A. Bowyer-Beaudoin,et al.  Soiltd: A FORTRAN subroutine to plot soil textural data on a triangular diagram using an X—Y plotter , 1981 .

[21]  Harry Vereecken,et al.  ESTIMATING THE SOIL MOISTURE RETENTION CHARACTERISTIC FROM TEXTURE, BULK DENSITY, AND CARBON CONTENT , 1989 .

[22]  M. Barbercheck,et al.  Effect of Host Condition and Soil Texture on Host Finding by the Entomogenous Nematodes Heterorhabditis bacteriophora (Rhabditida: Heterorhabditidae) and Steinernema carpocapsae (Rhabditida: Steinernematidae) , 1991 .

[23]  E. Pfeiffer,et al.  Methane production in aerated marshland and model soils: effects of microflora and soil texture , 1999 .

[24]  Walter J. Rawls,et al.  USE OF SOIL TEXTURE, BULK DENSITY, AND SLOPE OF THE WATER RETENTION CURVE TO PREDICT SATURATED HYDRAULIC CONDUCTIVITY , 1998 .

[25]  P. Allsopp,et al.  Effect of Soil Moisture and Soil Texture on Oviposition by Japanese Beetle and Rose Chafer (Coleoptera: Scarabaeidae) , 1992 .

[26]  J. Belnap,et al.  Vulnerability of desert biological soil crusts to wind erosion: the influences of crust development, soil texture, and disturbance , 1998 .

[27]  R. Horn,et al.  Bereitstellung von van-Genuchten-Parametern zur Charakterisierung der hydraulischen Bodeneigenschaften† , 1993 .

[28]  J. Arvidsson.  Influence of soil texture and organic matter content on bulk density, air content, compression index and crop yield in field and laboratory compression experiments , 1998 .

[29]  P. M. Rutherford,et al.  Influence of soil texture on protozoa-induced mineralization of bacterial carbon and nitrogen , 1992 .

[30]  A. J. Gijsman,et al.  Root decomposition in tropical grasses and legumes, as affected by soil texture and season , 1997 .