Logo image
Back
Spreadsheet macro to determine USDA soil textural subclasses
Journal article   Peer reviewed

Spreadsheet macro to determine USDA soil textural subclasses

Johan Liebens
Communications in soil science and plant analysis, Vol.32(1-2), pp.255-265
02/28/2001
DOI: https://doi.org/10.1081/CSS-100103005
Web of Science ID: WOS:000170043300017

Metrics

134 Record Views
9 Times Cited - Web of Science

Abstract

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.

Details

Logo image