Spreadsheet WATERSHED modeling for nonpoint-source pollution management in a Wisconsin basin

Water Resources Bulletin
By: , and 

Links

Abstract

Although several sophisticated nonpoint pollution models exist, few are available that are easy to use, cover a variety of conditions, and integrate a wide range of information to allow managers and planners to assess different control strategies. Here, a straightforward pollutant input accounting approach is presented in the form of an existing model (WATERSHED) that has been adapted to run on modern electronic spreadsheets. As an application, WATERSHED is used to assess options to improve the quality of highly eutrophic Delavan Lake in Wisconsin. WATERSHED is flexible in that several techniques, such as the Universal Soil Loss Equation or unit-area loadings, can be used to estimate nonpoint-source inputs. Once the model parameters are determined (and calibrated, if possible), the spreadsheet features can be used to conduct a sensitivity analysis of management options. In the case of Delavan Lake, it was concluded that, although some nonpoint controls were cost-effective, the overall reduction in phosphorus would be insufficient to measurably improve water quality.A straightforward pollutant input accounting approach is presented in the form of an existing model (WATERSHED) that has been adapted to run on modern electronic spreadsheets. As an application, WATERSHED is used to assess options to improve the quality of highly eutrophic Delavan Lake in Wisconsin. WATERSHED is flexible in that several techniques, such as the Universal Soil Loss Equation or unit-area loadings, can be used to estimate nonpoint-source inputs. Once the model parameters are determined (and calibrated, if possible), the spreadsheet features can be used to conduct a sensitivity analysis of management options. In the case of Delavan Lake, it was concluded that, although some nonpoint controls were cost-effective, the overall reduction in phosphorus would be insufficient to measurably improve water quality.
Publication type Article
Publication Subtype Journal Article
Title Spreadsheet WATERSHED modeling for nonpoint-source pollution management in a Wisconsin basin
Series title Water Resources Bulletin
DOI 10.1111/j.1752-1688.1989.tb05674.x
Volume 25
Issue 1
Year Published 1989
Language English
Publisher American Water Resources Association
Larger Work Type Article
Larger Work Subtype Journal Article
Larger Work Title Water Resources Bulletin
First page 139
Last page 147
Google Analytic Metrics Metrics page
Additional publication details