TECHNICAL NOTES
Nov 1, 2007

Planning for Water Allocation and Water Quality Using a Spreadsheet-Based Model

Publication: Journal of Water Resources Planning and Management
Volume 133, Issue 6

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 that new reclaimed water resources will be available in the future. To evaluate the impact of current and potential future uses on basin stakeholders, a spreadsheet-based model was developed to predict water quantity and quality at several key locations. 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. The use of a spreadsheet model allowed engineers and scientists within the Ministry of Water and Irrigation, and members of the consulting team who had limited modeling experience to be involved in the planning activity.

Get full access to this article

View all available purchase options and get full access to this article.

Acknowledgments

The Water Authority of Jordan (WAJ), the Royal Scientific Society (RSS), and JVA provided data streamflow, water quality, and diversion data.

References

Boyle Engineering Corporation. (1994). BESTSM, Boyle engineering stream simulation model, documentation and user’s manual, version 4.0, Lakewood, Colo.
Chapra, S. C. (1997). Surface water quality modeling, McGraw-Hill, New York.
Grattan, S. R. (2000). “Impact of increasing supplies of reclaimed water on crops, soils and irrigation management in the Jordan Valley.” Technical Rep., Water Reuse Component, Water Policy Support, Ministry of Water and Irrigation, Amman, Jordan.
Labadie, J. (1995). River basin network model for water rights planning, MODSIM: Technical manual, Dept. of Civil Engineering, Colorado State Univ., Fort Collins, Colo.
Loucks, P. (1995). “Developing and implementing decision support systems: A critique and a challenge.” Water Resour. Bull., 31(4), 571–582.
McCornick, P. G., Hijazi, A., and Sheikh, B. (2004). “From wastewater reuse to water reclamation: progression of water reuse standards in Jordan.” Wastewater use in irrigated agriculture: Confronting the livelihood and environmental realities, C. Scott, N. Faruqui, and L. Raschid-Sally, eds., CABI Publishing, Wallingford Oxfordshire, U.K., 153–162.
McCornick, P. G., Taha, S., and Al Nasser, H. (2002). “Planning for reclaimed water in the Amman-Zarqa Basin and Jordan Valley.” Proc., 2002 Environmental and Water Resources Institute Conf. on Water Resources Planning and Management and Symposium on Managing the Extremes—Floods and Droughts, Roanoke, Va.
Salas, J. D. (1980). “Analysis and modeling of hydrologic time series.” Handbook of hydrology, D. R. Maidment, ed., Chap. 19, McGraw-Hill, New York.
SAS. (1998). SAS/STAT user’s guide, version 8, SAS Publishing, Cary, N.C.
U.S. Geological Survey (USGS). (1998). “Overview of Middle East water resources: Water resources of Palestinian, Jordanian, and Israeli interest.” Prepared for the Executive Action Team, Middle East Water Data Banks Project, http://exact-me.org/overview/index.htm (last accessed August 4, 2007).
Wurbs, R. A., Dunn, D. D., and Walls, W. B. (1993). “Water Rights Analysis Program (TAMUWRAP), model description and user’s manual.” Technical Rep. No. 165, Texas Water Resources Institute, College Station, Tex.

Information & Authors

Information

Published In

Go to Journal of Water Resources Planning and Management
Journal of Water Resources Planning and Management
Volume 133Issue 6November 2007
Pages: 560 - 564

History

Received: Jun 7, 2005
Accepted: Sep 27, 2006
Published online: Nov 1, 2007
Published in print: Nov 2007

Permissions

Request permissions for this article.

Authors

Affiliations

Garry L. Grabow
P.E.
Assistant Professor, Dept. of Biological and Agricultural Engineering, North Carolina State Univ., Campus Box 7625, Raleigh, NC 27695. E-mail: [email protected]
Peter G. McCornick, M.ASCE
P.E.
Director for Asia and Principal Researcher, International Water Management Institute, PO Box 2075, Colombo, Sri Lanka. E-mail: [email protected]

Metrics & Citations

Metrics

Citations

Download citation

If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.

Cited by

View Options

Get Access

Access content

Please select your options to get access

Log in/Register Log in via your institution (Shibboleth)
ASCE Members: Please log in to see member pricing

Purchase

Save for later Information on ASCE Library Cards
ASCE Library Cards let you download journal articles, proceedings papers, and available book chapters across the entire ASCE Library platform. ASCE Library Cards remain active for 24 months or until all downloads are used. Note: This content will be debited as one download at time of checkout.

Terms of Use: ASCE Library Cards are for individual, personal use only. Reselling, republishing, or forwarding the materials to libraries or reading rooms is prohibited.
ASCE Library Card (5 downloads)
$105.00
Add to cart
ASCE Library Card (20 downloads)
$280.00
Add to cart
Buy Single Article
$35.00
Add to cart

Get Access

Access content

Please select your options to get access

Log in/Register Log in via your institution (Shibboleth)
ASCE Members: Please log in to see member pricing

Purchase

Save for later Information on ASCE Library Cards
ASCE Library Cards let you download journal articles, proceedings papers, and available book chapters across the entire ASCE Library platform. ASCE Library Cards remain active for 24 months or until all downloads are used. Note: This content will be debited as one download at time of checkout.

Terms of Use: ASCE Library Cards are for individual, personal use only. Reselling, republishing, or forwarding the materials to libraries or reading rooms is prohibited.
ASCE Library Card (5 downloads)
$105.00
Add to cart
ASCE Library Card (20 downloads)
$280.00
Add to cart
Buy Single Article
$35.00
Add to cart

Media

Figures

Other

Tables

Share

Share

Copy the content Link

Share with email

Email a colleague

Share