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


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

Services: Buy this book/Buy this article


Return to search