Premium
DETERMINATION OF UNGAGED TRIBUTARY FLOWS AND INTERSEGMENTAL RESERVOIR FLOWS USING SPREADSHEET SOFTWARE 1
Author(s) -
Dymond R. L.,
McDonnell A. J.
Publication year - 1988
Publication title -
jawra journal of the american water resources association
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.957
H-Index - 105
eISSN - 1752-1688
pISSN - 1093-474X
DOI - 10.1111/j.1752-1688.1988.tb03023.x
Subject(s) - hydrology (agriculture) , tributary , environmental science , watershed , scale (ratio) , hydrological modelling , streamflow , flood myth , software , routing (electronic design automation) , hydraulics , computer science , drainage basin , geology , geotechnical engineering , climatology , engineering , geography , computer network , cartography , machine learning , aerospace engineering , archaeology , programming language
Spreadsheet software was utilized on two related large scale trial and error problems. Gaged streamflow data and known reservoir volumes were used to construct a daily continuity balance in order to estimate the daily mean flows from ungaged portions of a study watershed over one year. Watershed yield coefficients were determined for two diverse types of watersheds with and without significant ground water contribution. Subsequently, a spreadsheet template was devised to ensure than an EPA supported water quality model, WASP, would successfully model the actual segmental volumes of a flood control reservoir. Inlet, outlet, and intersegmental advective flows were determined on a two week average basis using a continuity balance, segmental routing, and known segmental volumes. The protocols described relate the use of microcomputers to the resolution of hydraulic and hydrologic problems requiring iterative solutions.