**NOTE: This tool is not affiliated with CalWEP. This posting is for informational purposes**
Use the DWR Objective Analyzer Tool
From the Department of Water Resources:
DWR developed the DWR Urban Water Use Objective Analyzer tool to, among other things, evaluate alternative water use efficiency standards in relation to the statewide SB X7-7 water use target for 2020. This spreadsheet model utilizes the various data sources to estimate Urban Water Use Objective and Objective Based Total Water Use for the State’s urban retail water supplier. The "Read Me" tab of the spreadsheet provides description of the data sources used in the Objective Analyzer Tool.
To use the model to evaluate different scenarios, users can input varying assumptions in yellow boxes on the "Dashboard" worksheet. This worksheet also summarizes the model's outputs. This is the only worksheet where the user can modify model inputs. The other worksheets store data or perform calculations. All worksheets in the DWR Urban Water Use Objective Analyzer, except for the Dashboard worksheet, are password protected to prevent inadvertent changes to data and formulas. Users are expected to download the excel file to their local computer before entering new values on the Dashboard worksheets.