Click on “Download PDF” for the PDF version or on the title for the HTML version.

If you are not an ASABE member or if your employer has not arranged for access to the full-text, Click here for options.

Procedures for development of a Watershed Analysis and Treatment Evaluation Routine Spreadsheet (WATERS) are presented as a potential tool for TMDL allocation. The spreadsheet watershed model, applied on a subwatershed basis to characterize spatial inputs, is divided into four worksheets: hydrology, subwatershed load, transport, and watershed load. The annual flows are calculated using available methods in the hydrology worksheet. Various options of calculating subwatershed load using literature and measured data, regressions, and modeling are used in the second worksheet. The third worksheet calculates the pollutant delivery ratios (DR) using the first order kinetics of pollutant decay as a function of travel time and decay rate. Both of these parameters are based on litera-ture. Pollutant delivered at the watershed outlet is calculated as a product of DR and subwatershed load. Annual watershed load, calculated as the sum of all subwatershed loads, may have uncertainty associated with various input parameters. Uncertain model parameters then can be input as a probabilistic distribution in WATERS when embedded in @RISK decision analysis tool (Palisade Corporation), which can run several Monte Carlo simulations using these input distributions. The output of watershed pollutant load can then be described using a probability distribution that can be used further for confidence limits on load estimates, exceedence loads or standard violations in TMDL analysis. The spreadsheet model in @RISK is also capable of conducting sensitivity analyses of input parameters and what-if scenarios for management decis ions. The model, which is flexible and easy to apply, uses an adaptive approach to alter equations as more accurate method becomes available. The spreadsheet model, with a potential for linking with GIS tools, is being tested on the coastal plain watersheds in eastern North Carolina.