Applications of Spreadsheets in Water Resourcesby Thomas K. Jewell, Union Coll, Dep of Civil, Engineering, Schenectady, NY, USA,
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