Skip to main content

An Excel-Based Decision Support Tool for Water Use Efficiency Optimization

Buy Article:

$9.50 plus tax (Refund Policy)

Or sign up for a free trial

A new Microsoft Excel-based Water Use Efficiency Optimizer Tool has been developed by Malcolm Pirnie to assess various water use efficiency measures for developing water conservation strategy and priorities and for comparisons with economics of other water resource options. The Decision-Supporting Optimizer Tool assists in water resources planning decision making at both regional and individual utility levels. The Water Use Efficiency Optimizer assesses a mix of water resources planning options for managing demands and supplies within the primary constraints of minimizing costs while meeting specific water supply and water conservation goals. The tool uses Excel's “Solver” feature (which is an “add-in”) as a platform. The solver tool uses concepts of linear programming to provide an optimal mix of water resource options that can achieve goals within different types of constraints, including resource capital and operational costs, available budget, water savings, available minimum and maximum opportunities to implement options, resource option characteristics, and others. The tool enables users to model different water resources planning options to determine the most optimal scenario in consideration of prescribed user constraints and utility/regional service area characteristics. This paper describes the concepts and components of the tool, input data needs, assumptions and constraints, areas of applicability, and specific case studies for individual utility and regional water use efficiency planning.
No Reference information available - sign in for access.
No Citation information available - sign in for access.
No Supplementary Data.
No Article Media
No Metrics

Keywords: BMPs; Excel; Optimization; conservation; decision tool; reuse

Document Type: Research Article

Publication date: 2010-01-01

More about this publication?
  • Proceedings of the Water Environment Federation is an archive of papers published in the proceedings of the annual Water Environment Federation® Technical Exhibition and Conference (WEFTEC® ) and specialty conferences held since the year 2000. These proceedings are not peer reviewed.

    A subscription to the Proceedings of the Water Environment Federation includes access to most papers presented at the annual WEF Technical Exhibition and Conference (WEFTEC) and other conferences held since 2000. Subscription access begins 12 months after the event and is valid for 12 months from month of purchase. A subscription to the Proceedings of the Water Environment Federation is included in Water Environment Federation (WEF) membership.

    WEF Members: Sign in (right panel) with your IngentaConnect user name and password to receive complimentary access. Access begins 12 months after the conference or event
  • Subscribe to this Title
  • Membership Information
  • About WEF Proceedings
  • WEFTEC Conference Information
  • Learn about the many other WEF member benefits and join today
  • Ingenta Connect is not responsible for the content or availability of external websites
  • Access Key
  • Free content
  • Partial Free content
  • New content
  • Open access content
  • Partial Open access content
  • Subscribed content
  • Partial Subscribed content
  • Free trial content
Cookie Policy
Cookie Policy
Ingenta Connect website makes use of cookies so as to keep track of data that you have filled in. I am Happy with this Find out more