 Water Use Efficiency
Data Collection Tool
The WUE Data Collection Tool
(Excel file) will help you collect all of your monthly water use for
each type of customer and water pumped from your source. Use this data
to make your annual reporting easier. The two orange boxes
in the last column for each reporting year can
be copied into the online annual report.
The tool will also give you more accurate information by eliminating
data calculation errors. It automatically calculates your monthly data
into yearly totals. From there, the data is used to populate a
year-to-year chart that compares water pumped, consumed and lost in the
system. The charts are automatically generated based on the data you
input from each reporting year. There are a total of 13 years of monthly
data (2007-2020) that you could fill in, so if you have information from
previous reporting years, fill it in and measure the progress you've
made!
The tool is for your own data collection needs. It's not required
that you use it, nor should it be submitted to DOH.
How to use the tool:
Please follow ALL of the directions below or the
file won't work for you.
-
Click to download it to your
computer (Excel file).
-
Save it to your computer.
-
Because this Excel Tool uses macros to help you move between
pages, when you first open the tool,
you may see this warning: "cannot run the macro..."
Go towards the top of the page and
select the "Options" tab in the warning box. Click "Enable this content."
Then click OK.
(See sample Security Alert box below.)
-
Click on a reporting year and enter your data in the
blue boxes. Don't enter data
or delete the formulas in gray boxes, as they contain
important information that makes the Excel file work correctly.
-
From any page, use the button on the top left corner titled
"Return Main Menu" to view other reporting years and see yearly
comparison charts.
Questions? Contact Mike Dexel at (360) 236-3154.
|
