Planning for water allocation and water quality using a spreadsheet-based model

Abstract

An integrated planning activity was undertaken for the Amman-Zarqa Basin in Jordan to account for present and future uses of water resources including reclaimed water. Upgrades to existing wastewater treatment plants mean new reclaimed water resources will be available in the future. To evaluate the impact of current and potential future uses, a spreadsheet-based model was developed to predict water quantity and quality at several key locations within the basin. The model consists of a flow component and a water quality component. The model was used to screen various water-use scenarios and to formulate feasible alternatives including the sequencing of future water demands.