Spreadsheet for lysimeter data analysis, Bushland, Texas

A spreadsheet was designed for weighing lysimeter raw relative water storage data analysis and reduction to values of evapotranspiration, dew and frost accumulation, precipitation, irrigation, and drainage tank emptying. Algorithms in the spreadsheet automatically identify precipitation, and dew and frost accumulations in the 5-minute data, and places flags appropriately (“P” or “DW”) in a column that is referenced by formulae that separately calculate values for these. Noise can, however, cause false identification of precipitation or frost and dew accumulations, so another column is made available in which the user can enter flags to either nullify (“NO”) false automatic identification, or conversely, identify precipitation or dew and frost accumulations (“P” or “DW”) not automatically identified. This column also serves for entry of flags identifying irrigation, drainage tank emptying, counterweight adjustments, etc. Algorithms in other columns act upon these flags to correct the original raw relative storage values so that the adjusted relative storage reflects only evapotranspiration, while simultaneously computing 5-min values for precipitation, irrigation, dew and frost accumulation, and drainage tank emptying.