| Abstract: | ABSTRACT: 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. |
