Applications of Spreadsheets in Water Resources
by Thomas K. Jewell, Union Coll, Dep of Civil, Engineering, Schenectady, NY, USA,Document Type: Proceeding Paper
Part of: Computer Applications in Water Resources
Abstract:
This paper describes two applications of the spreadsheet MULTIPLAN to water resources problems. Applications include statistical analysis of water resources data and design of a stormwater detention pond using dynamic reservoir routing. Spreadsheets are developed for each application. The ease of performing sensitivity analyses and analyzing altenative solutions through recalculation of the spreadsheet, are demonstrated for the applications. Generalization of the spreadsheet models to form templates for the entry and solution of similar problems is discussed.
Subject Headings: Water resources | Spreadsheets | Stormwater management | Sensitivity analysis | Statistics | Reservoirs | Regression analysis
Services: Buy this book/Buy this article
Return to search