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 | Sensitivity analysis | Regression analysis | Dynamic analysis | Data analysis | Hydrologic data | Stormwater management

Services: Buy this book/Buy this article

 

Return to search