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 (ET), dew and frost accumulation, precipitation, irrigation, and drainage tank emptying. A new version of the spreadsheet uploaded in April 2025 includes more facilities for visualization, error checking, and validation of ET values. 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.
Resources
2 resources available
-
NE_SE_5-min storage 2018_365_DEW (08-30-2024).xlsx
XLSX -
NE_SE_5-min storage 2018_365_DEW (04-02-2025) - #9.xlsx
XLSX
Find Related Datasets
Search by Tags
Click any tag below to search for similar datasets
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| bureauCode |
[
"005:18"
]
|
| contactPoint |
{
"fn": "Evett, Steven R.",
"hasEmail": "mailto:steve.evett@usda.gov"
}
|
| description | <p dir="ltr">A spreadsheet was designed for weighing lysimeter raw relative water storage data analysis and reduction to values of evapotranspiration (ET), dew and frost accumulation, precipitation, irrigation, and drainage tank emptying. A new version of the spreadsheet uploaded in April 2025 includes more facilities for visualization, error checking, and validation of ET values. 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.</p> |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "NE_SE_5-min storage 2018_365_DEW (08-30-2024).xlsx",
"format": "xlsx",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"downloadURL": "https://ndownloader.figshare.com/files/48939502"
},
{
"@type": "dcat:Distribution",
"title": "NE_SE_5-min storage 2018_365_DEW (04-02-2025) - #9.xlsx",
"format": "xlsx",
"mediaType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"downloadURL": "https://ndownloader.figshare.com/files/53469194"
}
]
|
| identifier | 10.15482/USDA.ADC/26898151.v2 |
| keyword |
[
"ARS",
"Evapotranspiration components",
"NP211",
"Ogallala aquifer",
"data.gov",
"dew",
"frost",
"irrigation",
"precipitation"
]
|
| license | https://creativecommons.org/licenses/by/4.0/ |
| modified | 2026-03-25 |
| programCode |
[
"005:040"
]
|
| publisher |
{
"name": "Agricultural Research Service",
"@type": "org:Organization"
}
|
| spatial |
"{"type": "Polygon", "coordinates": [[[-102.09906463948, 35.191719970106], [-102.07671433134, 35.19121493622], [-102.07678299485, 35.1865853205], [-102.07609634934, 35.177044674547], [-102.09913330298, 35.177072738625], [-102.09906463948, 35.191719970106]]]}"
|
| temporal | 1989-01-01/1989-01-01 |
| title | Spreadsheet for lysimeter data analysis, Bushland, Texas |
