&EPA EPA's Energy Use Assessment Tool
United States
Environmental Protection USd* S GlHCfe
Version 2.0

-------
oEPA
United States
Environmental Protection
Agency
Office of Water (4606M)
December 2012
www. e pa.gov/ safe wate r

-------
Contents
1	Introduction	1
1.1	Overview of EPA's Energy Use Assessment Tool	1
1.2	Benefits of Using EU AT	1
1.3	Data Requirement for EUAT	2
1.4	About This Guide	2
1.5	Points of Contact	3
2	Setup Instructions	4
2.1	Saving a Copy of the Tool	4
2.1.1	Saving the .xls EUAT	4
2.1.1.1	'Save As'in Excel 2003	4
2.1.1.2	'Save As' inExcel 2007 (Compatibility Mode)	5
2.1.2	Saving the .xlsm EUAT	7
2.1.2.1	'Save As'inExcel 2007	7
2.1.2.2	'Save As'inExcel 2010	9
2.2	Enabling Macros	11
2.3	Changing Security Levels	12
2.3.1	Changing Security Levels inExcel 2003 	 12
2.3.2	Changing Security Levels in Excel 2007 & 2010	14
3	Getting Started on the Instructions Tab	17
3.1 Instructions Tab	17
4	General Information Tab	19
4.1	Navigation Buttons	19
4.1.1	Select/Switch Template	19
4.1.2	Building Data	19
4.1.3	Plant Energy Usage	20
4.1.4	Reset Data	20
4.1.5	Save	20
4.2	Entering Background Information	20
4.3	Entering Utility Bill Information	21
4.3.1	Use and Cost Data	21
4.3.2	Entering Alternative and Other Utility Types	22
4.3.3	Utility Rates	23
4.3.4	Treatment Volume	23
4.3.5	Entering Cogeneration Data	24
5	Building Data Tab	25
5.1 Navigation Buttons	25
Energy Use Assessment Tool User's Guide
iii

-------
5.1.1	Save and Continue	
5.1.2	Reset Data	
5.1.3	Return to General Info	
5.1.4	Set # of Buildings	
5.1.5	Set# of Rooms	
5.2	Total Plant Building Information	
5.3	Building Information	
5.4	Lighting Fixtures	
5.5	HV AC/Non-Process Units	
6	WTP/WWTP Energy Usage Tab	
6.1	HVAC and Lighting Totals	
6.2	Plant Equipment Electrical Energy Inventory	
6.2.1	Table Entry Instructions	
6.2.2	Entry Results	
6.2.3	Top Electrical Energy Use Systems	
6.2.4	Next Steps	
7	Summary Report Tab	
7.1	Action Buttons	
7.1.1	Print Summary Report	
7.1.2	Refresh Summary Report	
7.2	Overview of Baseline Energy Use	
7.3	Graphical Summaries for the Latest 12 Months	
7.3.1	The Utility Cost Summary Graph	
7.3.2	The Electric Use vs. Water Treated Graph	
7.3.3	The Electric Use vs. Cost Graph	
7.3.4	The Electric Utilization vs. Water Treated Graph	
7.4	Distribution of Electrical Energy Use and Cost by Major Process
7.5	Equipment Inventory	
7.6	Energy Trends for Over the Last 5 years	
7.6.1	Electric Use vs. Water Treated Graph	
7.6.2	Electric Use vs. Cost Graph	
7.6.3	Natural Gas Use vs. Cost Graph	
7.6.4	Utility Cost Summary Graph	
Appendix A. Calculations	
General Information Tab	
Building Data Tab	
WTP/WWTP Energy Usage Tab	
Summary Report Tab	
Appendix B. Unit Definitions and Conversions	
Appendix C. Acronyms and Abbreviations	
Appendix D. Troubleshooting Guide	
Appendix E. Cheat Sheet	
Energy Use Assessment Tool User's Guide
25
25
25
26
27
27
27
28
30
32
32
32
33
35
35
37
39
39
39
39
39
41
41
43
44
45
46
46
48
48
49
50
51
53
53
53
55
55
56
57
58
61

-------
Figures
Figure 2.2.1. Security warning medium	11
Figure 2.2.2. Security warning high	12
Figure 2.3. la. Select security option in Excel 2003	 13
Figure 2.3.2a. Select security option in Excel 2007	 15
Figure 3.1.1. Keys used throughout the tool	17
Figure 3.1.2. The 'Begin Assessment' button on the Instructions tab	18
Figure 3.1.3. Tabs at the bottom of the tool	18
Figure 3.1.4. Select the template type	18
Figure 4.1. General Information tab buttons	19
Figure 4.2. Background information	21
Figure 4.3.1. Utility bill data	22
Figure 4.3.4a. Electrical energy utilization summary	23
Figure 4.3.4b. Treatment Volume Unit dropdown list	24
Figure 5.1. Building Data tab buttons	25
Figure 6.1. HVAC and lighting totals	32
Figure 6.2. la. Plant equipment inventory	34
Figure 6.2. lb. Plant system type dropdown list.
Figure 6.2. lc. Plant equipment type dropdown list	35
Figure 6.2.3. Top 5 electrical energy use systems	36
Figure 7.1. Summary Report heading	39
Figure 7.2. Overview of baseline energy use	40
Energy Use Assessment Tool User's Guide	v

-------
11ntroduction
1.1	Overview of EPA's Energy Use Assessment Tool
The U.S. Environmental Protection Agency (EPA) developed an energy use assessment tool to allow small and medium sized water and wastewater
systems to self-assess their baseline energy consumption and costs, and to identify areas for improved energy efficiency and operational savings. The
tool provides the first step in establishing a baseline of energy consumption and use by collecting energy utility data and conducting a utility bill
analysis.
EPA's Energy Use Assessment Tool (EUAT) is free software that makes energy auditing more feasible for small to medium drinking water and
wastewater systems. It is an Excel worksheet so no Internet connection is needed and the software requirements are minimal. The tool was designed
and developed with input and suggestions from experts in energy auditing.
The tool comprises five tabs:
•	Instructions
•	General Information
•	Building Data
•	WTP (Water Treatment Plant) / WWTP (Wastewater Treatment Plant) Energy Usage Data
•	Summary Report.
1.2	Benefits of Using EUAT
EUAT can be a key step in reducing the energy usage at a small or medium sized system. The tool creates a baseline which shows the user an
organized overall look at their facility's energy usage. The tool creates a summary report that shows the energy trends as compared to the amount of
water treated. This can reveal potential energy waste or inefficiencies. The tool allows entry of up to five years of data. It is recommended to look at
more than just 12 months of data to develop more reliable trends. The tool organizes the last five years of utility bills, giving a clear look at how use
and costs are trending. Use trends can show performance of existing or new equipment. The tool also details lighting and HVAC in each building.
Comparison of lighting density may highlight areas of energy inefficiency. Compiling the data of motor sizes, efficiencies and operating schedules into
one place gives systems the ability to quickly assess their energy management of each area of the plant and determine whether it is most appropriate to
replace equipment with newer technology or change specific operational features of particular equipment.
Summary Report results can provide the following benefits:
Energy Use Assessment Tool User's Guide
1

-------
•	Focused snapshot of the past and current energy utilization at the plant
•	Trends can be used to compare and contrast energy use and costs from month to month, season to season, and year to year
•	Tracking site energy information can show use and cost impacts from operational and equipment improvements identify quickly when use
and/or costs have increased, and to show where there may be system limitations at the plant
•	Site energy information can be shared with plant operations personnel for identification of operational and technology changes needed to
reduce consumption each month
1.3 Data Requirement for EUAT
It is recommended that you compile the following required information before using EUAT. This will allow you to use the tool with ease and to its
full capability.
•	All Plant Utility Data (use and cost information) by month (minimum of 12 months) for up to 5 years of analysis, including all Electric,
Natural Gas, Fuel Oil No. 2 (Diesel Fuel), Water and/or Other Utilities
•	List of Lighting Fixtures (by type and quantity) and HVAC equipment nameplate data (horsepower, efficiency rating, full load amp rating) and
average motor operating amperage (for each building and room) and room size
•	Drinking Water Treatment Plant Information including monthly treatment/discharge volumes, motor nameplate data (horsepower, efficiency
rating, full load amp rating) and average motor operating amperage
•	Wastewater Treatment Plant Information including monthly treatment/discharge volumes, motor nameplate data (horsepower, efficiency
rating, full load amp rating) and average motor operating amperage
1.4 About This Guide
This Energy Use Assessment Tool User's Guide contains all the essential information for the user to make full use of the tool. It includes a description
of the functions and capabilities of the tool and step-by-step instructions for using the application to evaluate your system's energy consumption. It
provides information on how to enter data, what to expect as the output and how to use that information to improve energy consumption in your
facility.
This guide has a chapter for each of the five tabs. An extra chapter describes the setup instructions. Each chapter gives instructions and helpful tips
specific to a tab within EUAT. The appendices provide additional information including a glossary of terms used in the tool, unit conversions, a
troubleshooting guide and a cheat sheet page. Topics are cross-referenced within the document to provide a comprehensive understanding of how the
various tabs are integrated.
Energy Use Assessment Tool User's Guide
2

-------
1.5 Points of Contact
For additional help with the Energy Use Assessment Tool, send an email to EnergvUseTool(5)epa.gov or visit Determining Energy Usage at
http://water.epa.gov/infrastructure/sustain/energy use.cfm
Energy Use Assessment Tool User's Guide
3

-------
2Setup Instructions
The following instructions guide you on how to set the needed security levels to enable macros to run in the tool. The instructions assume that you
already have a copy of the EUAT saved to your computer.
2.1 Saving a Copy of the Tool
EUAT has been developed in two formats: an .xls format for Excel 2003 and an .xlsm format for Excel 2007/2010. The .xls format has been fully
tested only on Excel 2003 and the .xlsm format has been fully tested only on Excel 2010. You can however open and use both formats of the tool in
Excel 2007 (compatibility mode for the .xls version). If you need to save a copy of the .xls tool you must save it as an Excel 2003 workbook with
extension .xls. The .xls tool will not work if you save it as an Excel 2007 workbook (.xlsx or .xlsm file). You would need to use the .xlsm tool if you
have Excel 2007 or 2010 on your machine. The .xlsm tool cannot be opened in Excel 2003 or earlier versions.
Note! The .xls version of the tool must be saved in .xls format (Excel 97-2003 workbook). The .xlsm tool cannot be used in Excel 2003 or earlier
versions.
2.1.1 Saving the .xls EUAT
2.1.1.1 'Save As' in Excel 2003
If you are using the tool in Excel 2003, from the File menu, select Save As and enter the new file name as shown in figures 2.1.1.1 and 2.1.1.3.
Energy Use Assessment Tool User's Guide
4

-------
;^1 Microsoft Excel - EnergyUseAssessmentTool_vl.Cl.xls
[Read-Only]'1
IS]
File
Edit View Insert Format Tools Data Window
i J
J
New...
Ctrl+N


Open...
Ctrl+O

A
Save
Ctrl+S

Save As... k
1

Permission
~


Page Setup...

2

Print Area
~

d
Print...
Ctrl+P


Send To
~
3

1 En ergy U seAssessm entT o ol_vl .0 .xl s



2 \Users\sunith.,.\EnergyllseAssessmentTool_vl.0.xls


3 \User..,\En ergyU seAssessm entTo o l_V4_Exa m p 1 e.xl s


4 \Users\...'\EnergyUseAssessmentTool_V4_BLANK.xls
A



Figure 2.1.1.1 Performing a 'Save As' in Excel 2003.
2.1.1.2 'Save As' in Excel 2007 (Compatibility Mode)
If you are using the tool in Excel 2007 (compatibility mode), click the Office button at the top left of the spreadsheet, click Save As, and click the
Excel 97-2003 Workbook option as shown in Figures 2.1.2 and 2.1.3.
Energy Use Assessment Tool User's Guide
5

-------
D *

U
New
Open
Convert
Save
Save As
Print
Prepare
Send
it
Publish
~ A
Close
Save a copy of the document
K
Excel Workbook
[am Save the file as an Excel Workbook.
Excel Macro-Enabled Workbook
Save the workbook in the XML-based and
macro-enabled file format,
Excel Binary Workbook
lm»n| Save the workbook in a binary file format
optimized forfast loading and saving.
Excel 97-2003 Workbook
13551 Save a copy of the workbook that is fully
compatible with Excel 97-2003.
Open Document Spreadsheet
Save the workbook in the Open Document
Format.
PDF or XPS
Publish a copy of the workbook as a PDF or
XPS file.
Other Formats
Open the Save As dialog box to select from
all possible file types.
0
^ Excel Options X Exit Excel
Figure 2.1.1.2. The 'Save As' menu in Excel 2007.
Energy Use Assessment Tool User's Guide
¦
-
6

-------
Save As
? S3
Save in:
My Recent
Documents
Desktop
it
My Documents
ilk:
My Computer
%
My Network
Places
Energy Use Assessment Tool
Name
Date modified
^ I €!t X
Type	Size
This folder is empty,
|jjj| 'Tools '
File name:
EnergyUse Assessmen tT ool_v 1.0. xls
Save as type: Microsoft Office Excel Workbook {'xls)
Save
Cancel
Figure 2.1.1.3. Save as enter filename.
2.1.2 Saving the .xlsm EUAT
2.1.2.1 'Save As' in Excel 2007
To save a copy of the .xlsm tool in Excel 2007, click the Office button at the top left of the spreadsheet, click Save As, and click the Excel Macro-
Enabled Workbook option as shown in Figures 2.1.2.1 and 2.1.2.3.
Energy Use Assessment Tool User's Guide
7

-------
D
	/
w
£iew
OpenDj1
Save
Save As
Print
Prepare
Send
-,r ¦ Publish
J filoie
Save a copy of the document
^ i Excel Workbook
jd Save the file as an Excel Workbook.
Excel M^ro-Enabled Workbook
Save the workbook In the XML-based and
macro-enabled file format.
Excel Binary Workbook
Save the workbook in a binary file format
optimized for fast loading and saving.
Excel 97-2003 Workbook
Save a copy of the workbook that is fully
compatilUfc with Excel 97-2003,
OpenDocument Spreadsheet
Save the workbook in the Open Document
Format.
PDF or XPS
Publish a copy of the workbook as a PDF or
XPS file.
Other Formats
Open the Save As dialog box to select from
all possible file types.
fiPl
1
fa
Excel Options X Exit Excel
Figure 2.1.2.1. The 'Save As' menu in Excel 2007.
Energy Use Assessment Tool User's Guide

-------
2.1.2.2 'Save As' in Excel 2010
To save a copy of the .xlsm format in Excel 2010, click the File menu at the top left of the spreadsheet and click Save As. Make sure that Save as Type
is the Excel Macro-Enabled Workbook (*.xlsm) option. See figures 2.1.2.2 and 2.1.2.3.
Home
Insert
Page Layout
Formulas
Data
Review
View
Developer
J Save
Save As
Open
i j' Close
¦t?
Information about EnergyUseAssessmentTool
C:\En ergy U seAssessm en tTo o l_v2,0_Exa m p I e.xl sm
Read-Only Workbook
This workbook has been opened in read-only mode. Changs
the original workbook. To save changes, create a new copy t
Save As
Recent
New
Print
Save & Send
Help
[|J Options
(y) Exit
Figure 2.1.2.2. The 'Save As' menu in Excel 2010.
Protect
Workbook
Permissions
#2) One or more sheets in this workbook have been locked
changes to the data.
General Information
Building 1 Data
Building 2 Data
Building 3 Data
Building 4 Data
Building 5 Data
Building 6 Data
Energy Use Assessment Tool User's Guide
9

-------
|%1 Save As
;vl « Default (C:) ~ Energy Use Assessment Tool
*\tf\ | Search Energy Use Assessment... p
Organize ~
Name
New folder
Date modified	Type
No items match your search.
Authors: sboylston
Save Thumbnail
-*¦ Hide Folders
Tags: Add a tag
Tools »
SEE
Siie
Save
File name:
En ergy U seAssessm entT oo l_v2.0_Exa m p le.xlsm

Save as type:
Excel Macro-Enabled Workbook (*.xlsrrO
T
Cancel
Figure 2.1.2.3. Save as enter filename.
Note! The .xls EUAT was developed and tested to work in Microsoft Excel 2003. Some functionality might not work as designed if used in Excel
2007. However, if you choose to run it in Excel 2007, you should retain the .xls file extension which enables it to run in compatibility mode.
The macros within this spreadsheet cannot be run in Excel 2010. The new .xlsm EUAT was developed for use on systems with Excel 2007 or
Excel 2010. You should close all other Excel workbooks while working in the EUAT.
Energy Use Assessment Tool User's Guide
10

-------
2.2 Enabling Macros
If the security level in Excel is set to Medium, when you open EUAT, a warning message appears (see Figure 2.2.1). To enable the macros needed for
EUAT to function properly, click the Enable Macros button. If you do not enable the macros, the tool will not work as designed.
Security Warning
TC: \EnergyUseAssessmentTool_v 1.0. xlsr contains macros.
Macros may contain viruses. It is usually safe to disable macros, but if the
macros are legitimate, you might lose some functionality.
Figure 2.2.1. Security warning medium.
If the security level is set to High or Very High the security warning shown in Figure 2.2.2 appears. Click OK, and then follow the instructions in
section 2.3 to change the security level to Medium.
Disable Macros
ibl^Macros
More Info
J
Energy Use Assessment Tool User's Guide
11

-------
Microsoft Excel

"rai
Macros are disabled because the security level is set to High and a digitally signed Trusted Certificate is not attached to the macros. To run the macros, change the security level to a lower setting [not
; recommended), or request the macros be signed by the author using a certificate issued by a Certificate Authority.
Hide Help «
Open in Help Window
You may encounter thi^apr for the following reasons:
1, Macro security is set to:
¦ Very High and the application encounters a signed macro, but the macro was automatically disabled, Use the following procedure to enable the macro:
1.	Select the Tools menu option and then select Macro and Security, In the resulting Security dialog, set the security level to High by clicking the High radio button,
2.	Close the file and any other instances of the application currently running on the computer (dose all applications that also use the application you are currently running),
3.	Open the file again and examine the certificate of trust details and set the Always trust macros from this publisher box if you trust the certificate issued by the publisher,
4.	Click the Enable button to allow tine macro to run.
• High and the application encounters a signed macro, but you selected Disable when prompted by the macro warning dialog when opening the file, Use the following procedure to enable the
macro:
1.	Close the file and any other instances of the application currently running on the computer (dose all applications that also use the application you are currently running).
2.	Open the file again and examine the certificate of trust details and set the Always trust macros from this publisher box if you trust the certificate issued by the publisher,
OK
:
Figure 2.2.2. Security warning high.
2.3 Changing Security Levels
2.3.1 Changing Security Levels in Excel 2003
From the main toolbar click the Tools menu, go to Macro, and click Security (see Figure 2.3.1a). Select Medium from the security level popup as
shown in figure 2.3.1b. To avoid having to enable the macros each time you open the tool you can set the security level as Low. Select that option only
if you know that the files you will be working with are safe.
Energy Use Assessment Tool User's Guide
12

-------
i3t| Microsoft Excel - EnergyUseAssessmentTool_vLO.xls
File Edit View Insert Format
Tools Data Window
Help
IJ \3 A a* I JI -I m fi
MEG.' 1
Spelling... F7


Protection ~
; A* ibl I LJ —' ! E
11 fx
Macro ~
O
Macros... Alt+F8
Record New Macro...

A

Options...
1
2
EPA Energy
General Information
Security... K
a"
m\
	Ltf	
Visual Basic Editor Alt+Fll
Microsoft Script Editor Alt+Shift+Fll
i
Figure 2.3.1a. Select security option in Excel 2003.
Energy Use Assessment Tool User's Guide
13

-------
Security	ESI
Security Level
Trusted Publishers
O Very High, Only macros installed in trusted locations will be allowed
to run, All other signed and unsigned macros are disabled,
O High, Only signed macros from trusted sources '.'.ill be allowed to
run, Unsigned macros are automatically disabled,
® Medium. You can choose whether or not to run potentially unsafe
macros.
O Low (not recommended). You are not protected from potentially
unsafe macros, Use this setting only if you have virus scanning
software installed, or you have checked the safety of all documents
you open,
Cancel
Figure 2.3.1b. Security levels.
2.3.2 Changing Security Levels in Excel 2007 & 2010
In Excel 2007 & 2010, you can change macro security settings in the Trust Center, unless a system administrator in your organization has changed the
default settings to prevent you from changing the settings.
From the main toolbar, select the Developer tab and click the Macro Security button (see Figure 2.3.2a). Select Enable Macros from the security
level popup as shown in figure 2.3.2b.
Hint: If the Developer tab is not displayed, click the Microsoft Office Button then click the Excel Options button on the bottom of the popup,
hi the Excel Option popup, select the Popular category (if not already selected). Under Top options for working with Excel, click Show Developer
tab in the Ribbon (Figure 2.3 .2c)
Energy Use Assessment Tool User's Guide
14

-------
On d	EnergyUseAssessmentTool_vl.0.xls [Read-Only] [Compatibility Mode] - Micr
r-w r **=» n	,		<
IfcjMjT
—s Home Insert Page Layout
Formulas Data Review View Developer
< | l3 Record Macro
^ ' I—HQ jg use Relative References
Visual Macros
Basic i Ji Macro Security i
Code
\M h/ ^properties
r	 §3 view Code
Insert Design
Mode a Run Dialog
Controls
a- bp Propeit Import
-H ' ¦:'#>
qj Expansion Packs Export
Source ,
*| Refresh Data
I XML
Figure 2.3.2a. Select security option in Excel 2007 & 2010.
Trua Center
Trusted Publish**?
Trusted Locations
Trujted Documents
Add-int
AcfwtX Settings
Mien«ed; potentially dangerous code <*n run)
Oevrtopet Macro Settings
~ Tiuit access to the j£BA fwojert objert model
OK
Cancel
Figure 2.3.2b. Select security option in Excel 2007 &2010.
Energy Use Assessment Tool User's Guide
15

-------
'	
Excel Options
Formulas
Proofing
Save
Advanced
Customize
Add-Ins
Trust Center
Resources
Change the most popular options in Excel.
Top options for working with Excel
m Show Mini Toolbar on selection >
171 Enable Live Preview 1
l"71 Show Developertab in the Ribbon
Color scheme
ScreenTip style;
Blue
T

Showfeature descriptions in ScreenTips
T
Create lists for use in sorts and fill sequences:
When creating new workbooks
Edit Custom Lists.,.
Use this font:
Body Font
~
Font size:
nQ




Default view for new sheets:
Normal View
W


Include this many sheets:





Personalize your copy of Microsoft Office
User name: George,. Sunitha
Choose the languages you want to use with Microsoft Office: Language Settings...
OK
Cancel
Figure 2.3.2c. Enable Developer tab in Excel 2007.
Energy Use Assessment Tool User's Guide
16

-------
3Getting Started on the Instructions Tab
To use the tool to its full capacity you will need to collect the following information. For ease of use, you should gather it before using EUAT and
entering your data.
•	All Plant Utility Data (use and cost information) by month (minimum of 12 months) for up to 5 years of analysis, including all Electric,
Natural Gas, Fuel Oil No. 2 (Diesel Fuel), Water, and/or Other Utilities
•	List of Lighting Fixtures (by type and quantity) and HVAC equipment nameplate data (horsepower, efficiency rating, full load amp rating) and
average motor operating amperage (for each building and room) and room size
•	Drinking Water Treatment Plant Information, including monthly treatment/discharge volumes, motor nameplate data (horsepower, efficiency
rating, full load amp rating) and average motor operating amperage
•	Wastewater Treatment Plant Information, including monthly treatment/discharge volumes and average motor operating amperage
To get started, save a new workbook under a different name (detailed Save As instructions are in section 2.11).
It is OK to start with the data you have available and enter any remaining data at a later time. However, the more data you enter the more complete
and accurate the audit will be.
3.1 Instructions Tab
The Instructions tab is the default starting point of the tool. On it are brief directions on how to use the tool, how to enter data, and how to navigate
through the tool. If this is your first time using the tool read the instructions first. Also note the color-coded keys used all through the tool (Figure
3.1.1).
Yellow boxes indicate that data can be entered by the user
Light blue boxes indicate that values are calculated using the input data. (They are read only.)
Text in Blue Blue text consists of instructions for that section of the tool.
3 White boxes with an arrow are dropdown lists. Click the arrow and select an option from the pre-populated list.
Figure 3.1.1. Keys used throughout the tool.
Energy Use Assessment Tool User's Guide
17

-------
When you are ready to start entering data, click the Begin Assessment button at the top (Figure 3.1.2) and you will be automatically taken to the
General Information tab or click the General Information tab at the bottom (Figure 3.1.3).
EPA Energy Use Assessment Tool
Version 1.0
Figure 3.1.2. The 'Begin Assessment' button on the Instructions taf

~i \ Instructions / General Information Ml
W I P bneiqy UbdueP Summary Report f
Ready
/

Figure 3.1.3. Tabs at the bottom of the tool.
If you are starting with a blank template, the tool prompts you to select the type of template needed (Figure 3.1.4). If you are entering data for a
drinking water facility, select the Drinking Water Systems template or for a wastewater facility select the Wastewater Systems template.
5"?
Select Drinking Water/Wastewater Template
Select whether the tool will be used for a Drinking Water Plant or a Wastewater Plant.
Template for Tool:
-
_lJ
Drinking Water Systems
J
Figure 3.1.4. Select the template type.
You can now begin entering data in the General Information tab, (see the Chapter 4, General Information Tab).
Energy Use Assessment Tool User's Guide
18

-------
4 General Information Tab
4.1 Navigation Buttons
The buttons at the top of the General Information tab are shown in Figure 4.1. The function of each is explained below.
astewater Systems
Building Data
Plant Biergy Usage
• 2
• 3
Select Switch Template
Reset Data
Figure 4.1. General Information tab buttons.
4.1.1 Select/Switch Template
To switch between data entry for Drinking Water Systems or Wastewater Systems use the Select/Switch Template button at the top of the tab (Figure
4.1 - #1). You should select the template type before you begin data entry.
You can use the tool to enter data for either a drinking water system or a wastewater system. However, if your system is both a drinking water and a
wastewater system that share the same facility information you can enter data for both plants within the same spreadsheet. You would not need to have
a separate copy of the tool for each plant. Enter the facility information common to both plants, then enter the energy usage data for the first plant.
After data entry of the first plant is complete, use the Select/Switch Template button to switch template and enter the energy usage data for the second
plant. The summary report will reflect the data only for the currently active template/plant. You can switch between templates as often as needed to
view the reports of each plant or to edit the data. If the facility information is different you will need to save a separate copy of the tool for each plant.
4.1.2 Building Data
Once you have completed entering general information, the next step is to enter your building information for all the buildings in the facility. You will
be able to enter data for the lighting fixtures and HVAC/Non-Process Energy users for each building and for up to 10 buildings in the facility. To start
the building information, click the Building Data button (Figure 4.1- #2) or click the Building 1 Data tab at the bottom (Figure 3.1.3).
Energy Use Assessment Tool User's Guide
19

-------
4.1.3 Plant Energy Usage
The Plant Energy Usage button (Figure 4.1 - #3) takes you to the WTP/WWTP Energy Usage tab to enter in the plant system information. Depending
on the type of template selected, clicking the button takes you to either the WTP Energy Usage tab or the WWTP Energy Usage tab. Once you have
entered your general information, you can enter the plant information then go to the building data tab to enter the building data. You do not need to
complete the building data to start this tab.
Note! It is recommended that you enter all utility information on the General Information tab before you start entering the building or plant
information.
4.1.4	Reset Data
The Reset Data button can be used to clear all the information entered on the General Information tab. The Reset Data button is on each tab. It resets
the data specific to that tab or worksheet only (not the entire workbook).
4.1.5	Save
The Save button is used to save all the data entered in the tool. The Save button saves the entire spreadsheet along with all the changes made to any of
the tabs. The button is not specific to the General Information tab. You can also save your data by pressing CTRL + S on the keyboard.
4.2 Entering Background Information
Use the Background Information form (Figure 4.2) on the General Information tab to enter the general site information including facility name,
address, contact person, email, telephone, date of the audit, auditor information, etc. The information is displayed in the final summary report.
Energy Use Assessment Tool User's Guide
20

-------
BACKGROUND INFORMATION
Site Address
State
ZIP
Plant Contact
Contact Telephone
Project Example Water and Wastewater Treatment Plants
Facility Name
Project Reference P123
Sample Water and Wastewater Treatment Plants
123 Ross Roai
Treatment Operation 8500
Hrs/Yr
Fairfax
VA
22030
Date of Assessment 7/12/2011
John Smith
762-882-8811
Assessment Performed by
Assessor Phone
Jen Denwood
481-553-2217
Contact Email ohn.smithf5iQmail.com
Assessor Email iden@Qm3il.com
Figure 4.2. Background information.
4.3 Entering Utility Bill Information
Enter the plant's monthly utility use and cost information in the section shown in figure 4.3.1.
4.3.1 Use and Cost Data
The plants typical monthly energy use and cost data would fall into the different categories shown in #1 in the figure 4.3.1. These include the
electricity, natural gas, water and sewer, oil/fuel, and so on, usage and costs. If the site does not collect that information already, the plant's utility bill
will provide that information. It is okay if the meter readings do not start and end on the first and last day of the month. If possible, you should enter
the billing entry consistently. The total annual information is the most important.
If your facility uses Alternative Energy, use the related fields shown in figure 4.3.1 - #5 to enter data and specify the units for it in the top section
(Figure 4.3.1-#2)
If you have additional utility categories you can use the Other fields shown in figure 4.3.1 - #5 to enter that information. Use the section shown in #2
in figure 4.3.1 to enter the type of the utility category and units to be used for the Other fields.
If the site has multiple accounts for the same utility (such as two electric accounts), combine the values and enter the total for use and costs for each
month under this circumstance.
Energy Use Assessment Tool User's Guide
21

-------
Specify Units forTreatment Volume
Specify Units for Alternative Energy Consumption
Specify Other Utility Type (if any)
Specify Units for Other Energy Consumption (if any)
] M GAL
A
CCF

Propane

GAL

}
2
Electric ($j'kWh]
$0.1018
~
Natural Gas (t/CCF)
$1.1504
	*	
Nc>7FURlOi!($.a:n ?'Vatei Sewer (S'GAI) y P All, tneiyy: [?/CCM	Otllgi l;t:lity: Pushup [S/GAI; t
2011


January
February
March
April
May
June
July
August
September
October
November
December TOTAL (Yr)
Average
% of Costs
Electricity Cost (S) 2011

$18,184.32
519,492.46
519,247.76
519,704.16
520,930.40
519,997.44






5117,556.54
519,592.76
38.3%
Consumption (kWh) 2011
196,800
189,800
187,600
192,800
204,000
183,800







1,154,800.00
192,466.67

Natural Gas Cost ($) 2011
56,146.54
55,556.68
55,015.30
53,292.82
51,525.44
51,428.90







522,965.68
53,827.61
7.5%
Consumption (CCF) 2011
5,276
4,782
4,331
2,914
1,362
1,299







19,964.00
3,327.33

No 2 Fuel Oil Cost ($) 2011
516,231.03
511,166.71
58,587.05
55,077.59
5534.92
543.09







541,640.39
56,940.07
13.6%
Consumption (CCF) 2011
14,260
10,279
8,478
5,237
562
400






Li,
1 39,216.00
6,536.00

Waters Sewer Cost ($) 2011
512,320.06
512,320.06
511,741.82
511,741.82
511,741.82
516,794.47






r\1
J S76.660.05
S12,776.68
25.0%
Consumption (GAL) 2011
2,210,986
2,210,986
2,107,257
2,107,257
2,107,257
3,013,644







13,757,387.00
2,292,897.83

Alternative Energy Cost (S) 2011

51,914.90
52,035.80
52,571.40
52,39460
52,012.40
525,071.20







536,000.30
56,000.05
11.7%
Consumption (CCF) 2011


m°°
1,566,000
1,978,000
1,842,000
1,548,000
229,400







8,636,400.00
1,439,400.00

Other - Propane Cost ($) 2011
M

[30
51,535.60
52,324.30
53,180.10
52,017.40
51,923.90







512,051.60
52,008.60
3.9%
Consumption (GAL) 2011


973,000
1,396,000
2,113,000
2,891,000
1,834,000
1,749,000




1

10,956,000.00
1,826,000 00

Total Utility Cost 2011
555,867.15
552,107.31
549,487.63
545,391.09
538,762.38
565,259.00






5 306,874.56
S 25,572.88
100.0%
Treatment Volume (MGAL) 2011
112.240
107.500
116.700
118.400
111.200
94.700—






—4
110.123

Utility CostrTreatment Volume (S/MGAI
5497.75
5484.72
5424.06
5383.37
5348.58
5689.11






2,J_
5471.27

Electric Utilization (kWh/MGAL) 2011

1,753.39
1,765.58
1,607.54
1,628.38
1,834.53
1,940.87






10,530.28
1,755.05

Figure 4.3.1. Utility bill data.
The tool allows for analysis of up to 5 years of data. Enter the most recent year's monthly data first followed by the next most recent year's monthly
data. The Estimated Annual Electric Energy Use and Cost are calculated for the latest 12 months of data entered. (For example, if data for January
through July for 2011 are the latest entered, the annual totals would be taken from August 2010 to July 2011.)
Note! The summary report and charts are refreshed automatically only when data has been changed. Only the edits made on the yellow input fields are
considered as a change. Selecting a year from the dropdown list does not trigger the refresh action. To force a refresh (from this tab), double-click any
of the yellow cells and navigate to another cell, or use the Refresh Summary Report button on the Summary Report tab.
4.3.2 Entering Alternative and Other Utility Types
If your facility uses Alternative Energy, use the related fields shown in the figure 4.3.1 - #5 to enter data. Specify the units for it in #2 shown in figure
4.3.1.
Energy Use Assessment Tool User's Guide
22

-------
If you have additional categories use the 'Other' fields to enter that information (figure 4.3.1 - #5). Use the section shown in figure 4.3.1 #2 to enter
the type of the category and the units to be used for 'Other".
4.3.3	Utility Rates
The billing rates for each type of energy consumption are automatically calculated for each year using the data entered for that year and are displayed
in the section shown in #3 of figure 4.3.1. The Average Electrical Energy Rate will be calculated as an average of the electric rate over the latest 12
months of data entered. (For example, if data for January through July for 2011 are the latest entered, the totals would be taken from August 2010 to
July 2011.) That average is displayed towards the top of the tab (figure 4.3.4) and will be used in calculations throughout the tool. The averages shown
in figure 4.3.4 are calculated based on the yearly data and will be auto populated/refreshed as data is entered.
4.3.4	Treatment Volume
Enter the volume of water treated in the area shown as #4 in figure 4.3.1. The unit for treatment volume can be set to either MGAL or TGAL using the
input dropdown field found in the section shown in #2 in figure 4.3.1 (or figure 4.3.4b). The spreadsheet calculates the sites total utility cost per
treatment volumes, electrical energy use, and average utility rate per individual utility, and displays a summary for each year of data entered (figure
4.3.4a). Graphs of the information are generated and are on the Summary Report tab.


Total Utility Cost Per Million Gallons Treated ($/MGAL) 2011
$464.44

Total Utility Cost Per Million Gallons Treated ($/MGAL> 2010
$407.67

Total Utility Cost Per Million Gallons Treated ($/MGAL) 2009
$331.13

Total Utility Cost Per Million Gallons Treated ($/MGAL) 2008
$279.39

Total Utility Cost Per Million Gallons Treated ($/MGAL) 2007
$239.11



Electrical Energy Utilization (kWh/MGAL) 2011
1,747.74

Electrical Energy Utilization (kWh/MGAL) 2010
1,687.25

Electrical Energy Utilization (kWh/MGAL) 2009
1,588.91

Electrical Energy Utilization (kWh/MGAL) 2008
1,487.68

Electrical Energy Utilization (kWh/MGAL) 2007
1,506.90



Estimated Annual Electrical Energy Use (kWh)
2,248,000

Estimated Annual Electrical Energy Cost ($)
$227,497

Average Electrical Energy Rate ($/kWh)
$0.1012



Figure 4.3.4a. Electrical energy utilization summary.
Energy Use Assessment Tool User's Guide
23

-------
Specify Units for Treatment Volume
Specify Units for Alternative Energy Consumption
Specify Other Utility Type (if any}
Specify Units for Other Energy Consumption (if any}
MGAL

TGAL
II MGAL IHI
riu|Jdiit!

GAL

Figure 4.3.5b. Treatment Volume Unit dropdown list.
Note! The fields in light blue
are data entry fields that you enter.
are display only and contain values automatically calculated by the tool. The yellow
fields
4.3.5 Entering Cogeneration Data
EUAT is not designed to automatically handle cogeneration (co-gen) usage and costs. However, you can manipulate the information in the General
Information tab to accurately reflect the effect that co-gen energy has on the facility's use and costs.
The utility bill entries in the General Information tab can be manipulated to account for the electricity savings from the co-gen process and the
additional cost from natural gas used to keep the co-gen process online. For the following manipulations, it is assumed that co-gen electrical
production and natural gas consumption are metered.
•	Add the electrical energy production from the co-gen process to the electricity purchased from your utility in the Electricity Consumption
cells.
•	The co-gen electrical energy costs can be added by including the co-gen direct purchased natural gas costs in the Electrical Cost cells.
•	Co-gen natural gas that is a separately metered and that is billed separately from plant-wide natural gas can have the total bill added to the
Electricity Cost cells.
•	To account for co-gen natural gas that is sub-metered after the main natural gas meter, which is used for billing, subtract the usage and
proportional cost from the Natural Gas Cost and Natural Gas Consumption cells.
•	Add the portion of natural gas cost that went to the co-gen process to the Electricity Cost cells.
•	Add the portion of natural gas use that went to the co-gen process to the Electricity Consumption cells.
After manipulating the energy usage and costs use the tool normally and it now accurately represents the site's true costs for energy.
Energy Use Assessment Tool User's Guide
24

-------
5 Building Data Tab
The tool allows you to enter data for up to 10 buildings. The building data tabs are numbered from 1 to 10 and all 10 tabs follow the same format. The
below instructions are common to all 10 tabs except if specified.
5.1 Navigation Buttons
B	C	D	G	H	I	J	K	L	M	N
EPA Energy Use Assessment Tool for Wastewater Systems
Site Structural Buildings - Major Non-Process Energy Users
Figure 5.1. Building Data tab buttons.
5.1.1 Save and Continue
Use the Save and Continue button at the top of the page to save the data that has been entered for Building 1 and enter data for the next building or
return to the General Information tab if building data entry is complete. Once the number of buildings has been selected you can also move to the other
Building Data tabs by clicking them at the bottom of the tool.
5.1.2 Reset Data
Use the Reset Data button to clear all the information entered on the current Building Data tab. A Reset Data button is on each tab. It resets the data
that has been entered on that tab (not all tabs).
5.1.3 Return to General Info
To return to the General Information tab, click the Return to General Info button. You do not have to complete data entry on the building tab. You
can return later when you have time to fill in the detail.
Energy Use Assessment Tool User's Guide
25

-------
5.1.4 Set # of Buildings
Use the Set # of Buildings button to set the desired number of rooms on-site. The Set # of Buildings button (figure 5.2) appears only on the Building
1 Data tab. If your facility has more than one building you will need to create the tabs before you can enter your building data. To do this, select the
desired number of buildings from the dropdown list and click Set # of Buildings to allow entry for that many buildings. Enter data for the first
building on the Building 1 Data tab, then click Save and Continue to go to the second building data tab. Enter data for the second building and
continue process until you have entered the data for all buildings. If you do not have time to complete all buildings, you can skip it and come back
later. If your site has outdoor lighting then you may want to use a separate building to capture this information within the EUAT.
Total Number of Buildings On-site
1
Set# of Buildings
! Reducing the number of buildings will delete
any data entered on the additional tabs
Figure 5.1.4. Set the number of buildings.
At any time you can increase the number of buildings available for data entry. Select the total number of buildings needed from the dropdown list and
click the Set # of Buildings button. Increasing the number of buildings will not reset/delete any of the data entered on the other building data tabs.
(E.g. suppose you initially selected 5 buildings and entered data for these tabs and later realize you had 6 buildings. You would have to select 6 from
the dropdown list and click the button. This would however create only 1 new tab and would retain the first 5 that were already created. You would
therefore not lose any of the data that was already entered).
To remove extra or unused building tabs, select the required number of buildings and click the Set # of Buildings button. Doing so deletes the
buildings tabs in decreasing order starting with the highest numbered tab, irrespective of which tabs contain data (i.e., if you originally set the number
of buildings to 3 and then change the number of buildings to 1, tabs 3 and 2 will be deleted, along with any data entered on them but building 1 and all
the data entered for it will remain.). It is assumed that the user will enter the buildings in increasing numerical order i.e., enter data for building 1 then
building 2 and so on.
Note! Reducing the number of buildings will delete any data entered on the tabs being removed. It is assumed that the user will enter data in the
building tabs in increasing order hence the highest numbered tab(s) would be the unused one(s).
Increasing the number of buildings will only add on to the existing tabs hence data will not be erased.
Energy Use Assessment Tool User's Guide
26

-------
5.1.5 Set # of Rooms
For each building, you must select the number of rooms for which you want to enter data. Select the number of rooms in the No. of Rooms dropdown
list and click the Set # of Rooms button (figure 5.1.5).
Ho. of Rooms

Set # of Rooms
Changing the number of rooms
will reset all lighting data entered.
Figure 5.1.5. Setting the number of rooms
Note! You must set the number of rooms in a building before entering any lighting data. Changing the number of rooms afterward entering data will
reset/delete ALL the lighting data entered.
5.2 Total Plant Building Information
Figure 5.2 shows the top section of all building tabs. This area displays a summary of the information entered on all the building tabs. If you entered
data for buildings 1, 2, and 3, the section appears the same on all the building tabs and displays the sum of the building areas/electric loads/electric use
on all three tabs.
However, the Does the site have buildings and Set # of Buildings fields are clickable only on the building 1 tab. On all other tabs, those fields are
display only. Use the Set # of Buildings to allow data entry for the selected number of buildings (for more details, see section 5.1.4).
Total Plant Building Area
0
P(2 Total Plant Building Electric Load q gg kW
0.00
Does the site have buildings? * Yes
I No
Total Number of Buildings On-site
Set# of Buildings
Total Plant Buildinq Electric
Use
! Reducing the number of buildings will delete
any data entered on the additional tabs
kWh/Yr
Figure 5.2. Total plant building information.
5.3 Building Information
Enter general information about each building in the section shown in figure 5.3. This includes the name of the building, number of rooms, operating
hours and so on. Set the number of rooms in the building before entering any lighting data (for more details, see section 5.1.5). The area of the building
is calculated as a sum of the area of the rooms entered. The Operating Hours per Year are calculated using the values selected for operating hours per
day and operating hours per week. The Average Building Lighting Power Density is calculated on the basis of the area of the building and the values
entered for wattage in the rooms.
Energy Use Assessment Tool User's Guide	27

-------
The section shown in figure 5.3, #1 displays the totals of the information entered on the rooms and for the HVAC/Non-process units. Those totals
across all the buildings are displayed on the Plant Energy Usage tab. You can then use them for entry on the WTP/WWTP Energy Usage tab.
If your system's lighting and HVAC loads have already been identified or you would just like to estimate them without detailing that information here
you can proceed to the WTP/WWTP Energy Use tab.
BUILDING 1
Name
Area
r
No. of Rooms 4 _*] Set# of Rooms
Ft2
! Changing the number
of rooms will reset all
lighting data entered.
Operating Hours per Year
Operating Hours per Day
Operating Days per Week
Hrs/Yr
Hrs/Day
Days/Wk
Approximate Building Age (If known)
Average Building Lighting Power Density (LPD)
Estimated Electric Load:
Total Building 1 Lighting
Total Building 1 HVAC
Total Building 1 Combine
kW
kW
kW
Total Building 1 Lighting
0
0
Total Building 1 HVAC
Total Building 1 Combiner
0
kWh/Yr
kWh/Yr
kWh/Yr
Estimated Annual Energy Cost:
Total Building 1 Lighting
Total Building 1 HVAC
Total Building 1 Combined
$/Yr
$/Yr
$/Yr
Figure 5.3. Building information.

5.4 Lighting Fixtures
To determine the site's lighting loads and energy use, describe each room's lighting fixture types and counts by using the selectable input fields as
shown in figure 5.4a and 5.4b. You can enter data for up to 10 rooms per building. If your system has more than 10 rooms you can combine the
remaining rooms and enter the summed up values into the last room section.
Select from the dropdown list a light fixture for each type of fixture in each room. The tool provides the fixture's electrical energy load in watts. Enter
the quantity and the tool updates the total room wattage. If a type of fixture is not available in the dropdown use the Other Type input field to enter
the fixture and its total (lamp and ballast) wattage.
Enter the area for each room and the tool provides the Lighting Power Density (LPD) in watts per square foot for each room.
Energy Use Assessment Tool User's Guide
28

-------
Four F40T12 4 4DW Fluorescent La -i-
Select Light Fixture
Select Light Fixture
Select Light Fixture
Select Light Fixture
Other Type: Name
: Watts
Exit Sign
15
Room 1 Name	Conference Room
Room 1 Lighting (Main Lighting only- Do not include task lights)
Select up to 6 Light Fixture Types
Light Type 1
Light Type 2
Light Type 3
Light Type 4
Light Type 5
Area
600 Ft2
Fixture
175 Watts
16
Total Watts

Total Watts

Total Watts

Total Watts

15 Watts
2
Total Room Wattage (W)
2,830	W
Room Lighting Power Density (LPD)
4.72 W/ft2
Figure 5.4a. Lighting data.
Room 1 Name Conference Room Area
Room 1 Lighting (Main Lighting only - Do not include task lights)
Select up to 6 Light Fixture Types

Light Type 1
Four F40T12 4' 40W Fluorescent Lai T j 175 Watts
Light Type 2
Select Light Fixture
One F4QT12 4 40W Fluorescent Lamp, Electronic Ballast
One F4QT12 4 4DW Fluorescent Lamp, Magnetic Ballast
Vatts
Light Type 3
Vatts
Light Type 4
Two F40T12 4 4QW Fluorescent Lamps, Electronic Ballast
Two F4QT12 4 40W Fluorescent Lamps, Magnetic Ballast
Vatts
Light Type 5
Three F4DT12 4 40W Fluorescent Lamps, Electronic Ballast
Three F40T12 4 40W Fluorescent Lamps, Magnetic Ballast
Four F40T124 40W Fluorescent Lamps, Electronic Ballast
Four F40T12 4 40W Fluorescent Lamps, Magnetic Ballast
One F4ST12 HQ 4 SOW Fluorescent Lamp, ES Magnetic Ballast
Vatts
Other Type:I
•atts

Two F4ST12 HO 4 60vV Fluorescent Lamps, Electronic Ballast H


Two F48T12 HO 4 SOW Fluorescent Lamps, ES Magnetic Ballast
Three F4BT12 H-O 4' SOW Fluorescent Lamps, ES Magnetic Balls-.
Four F4ST12 HO 4 SOW Fluorescent Lamps, ES Magnetic Ballast
Two F4ST12 HO 4 SOW Fluorescent Lamps, ES Magnetic Ballast T

Room 3 Nar
re a
Figure 5.4b. Lighting fixture dropdown list.
Energy Use Assessment Tool User's Guide
29

-------
The tool totals the rooms" lighting loads, each building's lighting energy use, and the site's total lighting energy use per year for use in other areas of
this tool. You can then compare LPD's from room to room and building to building to help determine where excess energy might be in use.
5.5 HVAC/Non-Process Units
Non-Process HVAC is meant to include all equipment not tied to specific process operations, such as office air conditioners, restroom exhaust fans,
and so on. Do not provide process-related ventilation equipment such as odor control fans here. You can include process equipment on the WTP or
WWTP Energy Use tabs.
To determine the site's non-process heating, ventilating, and air conditioning (HVAC) loads and energy use, describe each building's HVAC electrical
users and counts by entering them in the table as shown in figure 5.5.
For each Non-Process HVAC unit you can select the equipment type from a dropdown list (figure 5.5b). You can provide an Equipment Description
for each piece. Collect and enter each unit's motor size, efficiency and full load amperage ratings. That information is on the equipment's nameplate or
specification datasheet.
If the site has authorized personnel capable of taking electrical measurements enter the motor's average operating current. Once the equipment's
typical operating hours are entered the tool calculates the estimated annual energy use and operating cost for the unit.
If conditions change in the plant you can adjust the equipment size, current reading, operating hours and number of equipment in use values. The
formulas used for the calculations can be found in Appendix A: Calculations (see section Building Data tab -HVAC/Non-process).

System Type
Equipment Type
Equipment
Description
Motor Size
(hp)
Motor
Efficiency
Motor Full
Load
Amperage
(FLA)
Average
Motor
Operating
Current
(Amps}
Motor
Operating
Hours
(Hours/Year}
Average Load
Factor
Average HVAC
Electric Load (kW(
Estimated Annual
Energy Use
(kWh/yr)
Estimated Annual
Operating Costs
($/Year)
Estimated
Percent of Site
Electric Use &
Cost (S)
Non Process HVAC
Select Equipment







0.00%
0.00
0.00
$0.00
0.00%
Non Process HVAC
Select Equipment







0.00%
0.00
0.00
$0.00
0.00%
Non Process HVAC
Select Equipment







0.00%
0.00
0.00
$0.00
0.00%
Non Process HVAC
Select Equipment







0.00%
0.00
0.00
$0.00
0.00%
Non Process HVAC
Select Equipment







0.00%
0.00
0.00
$0.00
0.00%
Non Process HVAC
Select Equipment







0.00%
0.00
0.00
$0.00
0.00%




















Total Building HVAC
0.00
0.00
$0.00
0.00%
Figure 5.5a. HVAC information.
Energy Use Assessment Tool User's Guide
30

-------

System Type
Equipment Type
Equipment
Description
Non Process HVAC
Compressor T
Uir Conditioner
Non Process HVAC
Select Equipment
Blowef
AC
Non Process HVAC
Compressor

Non Process HVAC
Diive
Fan

Figure 5.5b. HVAC Equipment Type dropdown list.
Energy Use Assessment Tool User's Guide
31

-------
6 WTP/WWTP Energy Usage Tab
6.1 HVAC and Lighting Totals
The lighting and HVAC loads, use, and cost for all the buildings entered for the facility on the Building Data tabs are totaled and displayed in the
section on the WTP/WWTP Energy Usage tab shown in figure 6.1. Use that information (i.e., the values shown in Figure 6.1 #1 & #2) to enter the
HVAC and lighting into the equipment inventory table. You could enter the lighting and HVAC as separate entries or as a single entry using the
combined value shown in figure 6.1 #3. To enter this data from the System Type dropdown list select the Lighting or Non-Process HVAC and from
the Equipment Type dropdown list select the Other kW Load. For more details see the table entry instructions in section 6.2.1.
Estimated Electric Load:
—
Estimated Annual Enerqy Use:


Estimated Annual Enerqy Cost:


Total Building 1 Lighting
18 —K#
i
Total Building 1 Lighting
44,092
kWh/Yr
Total Building 1 Lighting
J 4,462.09
$/Yr
Total Building 1 HVAC
£
Tf
2
Total Building 1 HVAC
18,286
kWh/Yr
Total Building 1 HVAC
$ 1,850.51
$/Yr
Total Building 1 Combined
23 —k%
~
Total Building 1 Combined
62,378
kWh/Yr
Total Building 1 Combined
It 6,312.60
S/Yr







Figure 6.1. HVAC and lighting totals.
6.2 Plant Equipment Electrical Energy Inventory
Collect each motor's size (hp), efficiency rating (%), full load amperage (FLA) rating and annual operating hours. If you do not have time to collect
information for all equipment at the plant you should start with gathering data for the following motors sizes:
•	10 hp and greater - After entering this data, gather data next for all motors sized
•	5 hp and greater - After entering this data, gather data next for all motors sized
•	1 hp and greater
If a piece of equipment is not motor based identify the operating load in kilowatts (kW) and the unit's annual operating hours. To enter that data from
the System Type dropdown list select the appropriate system type and from the Equipment Type dropdown list and select the Other kW Load. For
more details see the table entry instructions in section 6.2.1.
With each row of data entry the tool estimates the plant's electrical energy breakdown.
Energy Use Assessment Tool User's Guide
32

-------
6.2.1 Table Entry Instructions
You will need to identify the equipment used in your plant and enter data for each one into the equipment inventory table as shown in figure 6.2. la. To
enter data follow the steps below:
1.	Identify and select the System Type and Equipment Type from the dropdown menus (figures 6.2.1b and 6.2. lc) for each piece of equipment
recognized at the plant. To enter system types not listed in the list from the System Type dropdown list select 'Other".
2.	Enter a unique Equipment Description to keep track of each piece of equipment. That can be the system's identification name or number.
3.	Collect and enter the motor size, efficiency and full load amperage ratings. That information is on the equipment's nameplate or specification
datasheet.
4.	If the site has authorized personnel capable of taking electrical measurements collect and enter the motor's average operating current. If you are
unable to measure the motor's typical operating current the tool provides 75% as the default value for the unit's Average Load Factor.
5.	Enter the annual operating hours. If that information is not tracked for the unit estimate the value. You can readj ust the value later.
6.	If the piece of equipment is not motor based or if a total system load has already been identified such as for the Building Lighting and HVAC
systems in the System Type dropdown list select the appropriate system type and from the Equipment Type dropdown list select Other kW
Load. The tool then ignores the cells for Motor Size, Motor Full Load Amperage, Average Motor Operating Current and Load Factor by placing
an N/A in those cells. (Figure 6.2.1 - # 1) You can then enter the annual operating hours into the respective cell and electrical energy load in kW
into the column titled Average Electric Load (kW). To put in the lighting and HVAC values entered on the building data tabs use the totals
shown in the blue boxes at the top of this tab (Figure 6.1). For the Average Electric Load (kW) use the values shown in figure 6.1 (#1 and #2 or
combined as #3). You can enter 100% for the Average Load Factor and use the high of 8760 for the Operating Hours (Hrs/Yr) since these may
vary for each building.
7.	If you need to add more equipment than the table allows click the Add Row button (Figure 6.2.1 - #2) (it adds a new row for data entry). You may
add as many rows as you wish.
Energy Use Assessment Tool User's Guide
33

-------
EQUIPMENT ELECTRICAL ENERGY INVENTORY
System Type
Equipment Type
Equipment
Description
Motor Size
(hp)
Motor
Efficiency
(%>
Motor Full
Load
Amperage
(FLA)
Average
Motor
Operating
Current
(Amps)
Operating
Hours
(Hrs/Yr)
Average
Load Factor
<%>
Average
Electric
Load u
1UU.UU%
vi.n
rn,bb5

4,yy%
Non Process HVAC

Other kW Load
3]
All Site HVAC
N/A
N/A
N/A
N/A
8,760
100.00%
7.36
64,474
$6,525
2.87%
Influent Pumping

Pump
3]
infl Pump Station
25
88 0 %
20
17
4.700
85.00%
18.01
84,667
$8,568
3.77%
Primary Treatment
I
Blower
d
Grit Blowers
7.5
89 0 %
8
5.5
8.760
68.75%
4.32
37,861
$3,831
1.68%
Primary Treatment
I
Blower
d
Channel Blower
10
88.0 %
10.5
6.8
8,760
64.76%
5.49
48,093
$4,867
2.14%
Secondary Treatment
d
Blower
d
Secondy Blowers
200
91.0 %
225
185
8,760
82.22%
134.81
1,180,921
$119,509
52.53%
SecondaryTreatment
d
Blower
d
Secondy Blowers
200
91.0 %
225
185
450
82.22%
134.81
60,664
$6,139
2.70%
Secondary Treatment

Pump
d
WAS Pumps
7.5
86 0 %
8
4
1,460
50.00%
3.25
4,749
$481
0.21%
Fixed Film Treatment
1
Pump
3]
RTower Pumps
60
91 0 %
65
36
8.760
55.38%
27.24
238,639
$24,150
10.62%
Anaerobic Digestion
J
Pump
3
Sludge Recir Pump
5
85 0 %
6
5
8,760
83.33%
3.66
32,034
$3,242
1.43%
Anaerobic Digestion
I
Mixer
3
Gas Mixer
10
88 0 %
12
9
8,760
75.00%
6.36
55,696
$5,636
2.48%
Anaerobic Digestion
I
Other kW Load
3
Mixer Heater
N/A
N/A
N/A
N/A
2,500
100.00%
7.20
18,000
$1,822
0.80%
Effluent Pumping/Storag

Pump
d
Effluent Pumps
7.5
91.0 %
8
6
4.416
75.00%
4.61
20,363
$2,061
0.91%
Internal PlantPumping
d
| Other kW Load
3

N/A
N/A
N/A
N/A
4,380
75.00%
5.00
21,900
$2,216
0.97%
Add Row #-j

Figure 6.2.1a. Plant equipment inventory.
Estimated Annual WWTP Electric Use & Cost
374.89
1,979,925
$200,368
88.07%
Actual Annual WWTP Electric Use & Cost

2,248,000
$227,497

Difference Between Billed and Identified

-268,075


Percent of Site Electrical Energy Identified

88.0"^-

	•
~
m
Energy Use Assessment Tool User's Guide
34

-------
System Type
Equipment Type
Equipment
Description
Lighting

Other kW Load
-
All Site Lighting
Non Process HVAC
~
Other kW Load

All Site HVAC
Select System Type
Aerobic Digestion
Anaerobic Digestion
Chemicai Mixing
Chlorine Disinfection
A
Pump
-
Infl Pump Station
	
Blower
-
Grit Blowers

Blower
E
Channel Blower
City Water Pumping
Compressed Air

Blower

Secondy Blowers
Dissolved Air Flotation
4
Blower

Secondy Blowers
Figure 6.3.1b. Plant system ty pe dropdown list.
System Type
Equipment Type
Equipment
Description
Lighting
-
Other kW Load
All Site Lighting
Non Process HVAC

Other kW Load *
All Site HVAC
Influent Pumping
-¦
Select Equipment
Blower
Compressor
Infl PunC^ Station
Primary Treatment

Grit Blowers
Primary Treatment

Drive
Dryer
Fan -J
Grinder
Mixer T
Channel Blower
Secondary Treatment
-
Secondy Blowers
Secondary Treatment

Secondy Blowers
Figure 6.4.1c. Plant equipment type dropdown list.
6.2.2 Entry Results
EUAT calculates each equipment's electrical energy values for Average Electric Load (kW), Estimated Annual Energy Use (kWh/yr) and Estimated
Annual Operating Costs ($/yr).
The tool also provides the Estimated Percent of Site Electric Use & Cost (%) identified as compared to the plant's Actual Annual Electric Use and
Cost (actual energy billed).
Any difference between what electrical energy has been identified and what has been billed is also indicated. If that value is positive the site's
electrical energy use and/or loads have been overestimated and readjustment of the equipment loads or operating hours might be necessary. If that
value is negative, the site's electrical energy use and/or loads have not been fully identified, and additional equipment loads or operating hours might
be necessary (Figure 6.2 - #3).
The cell labeled Percent of Site Electrical Energy Identified (Figure 6.2 - #4) provides the site with an estimate of what portion of the site's electrical
energy use has been captured. Use that percent value to help gauge the data quantity yet to be collected and entered.
6.2.3 Top Electrical Energy Use Systems
EUAT generates a list of the Top 5 Electrical Energy Use Systems at the plant (Figure 6.2.3). The breakdown is listed by major system type. Those
smaller components not in the Top 5 will be combined and shown as the Balance of Plant Identified. The electrical energy that has not yet been
identified will be shown as Balance of Plant Unidentified. As you enter data the percent of site electrical energy identified moves closer to 100% and
the Balance of Plant Unidentified decreases.
Energy Use Assessment Tool User's Guide
35

-------
Top Energy Use Systems:
#1 SECONDARY TREATMENT
55.44%
#2 FIXED FILM TREATMENT
10.62%
#3 ANAEROBIC DIGESTION
4.70%
#4 LIGHTING
4.93%
#5 P Rl MARY TREATM E NT
3.32%
Balance of Plant Identified
8.51%
Balance of Plant Unidentified
11.93%

Top Electrical Energy Use Systems


¦ #1 SECONDARY TREATMENT
12%

¦ #2 FIXED FILM TREATMENT
8%

¦ #3 ANAEROBIC DIGESTION
4%
5%
5%
55%
¦	#4 LIGHTING
¦	PRIMARY TREATMEIVTT
11%

¦ Balance of Plant Identified
Balanceof Plant Unidentified
Figure 6.2.5. Top 5 electrical energy use systems.
System energy use comparisons between systems of varying voltages and phases are not a problem. The kW consumption is determined by converting
motor horsepower to kW and adding it to direct kW consumptions from other equipment. Amperage is used only to determine the percent load factor
of the motor power	
(% load factor) = (Average Amp Load)/(Full Amp Load)	
The load factor multiplied by the motor total power results in the average power and, thus, energy consumption. Voltage is not used in any
calculations.
The tool also generates a pie chart with the site's top electrical energy use systems identified.
If conditions change at the plant you can adjust the values entered for the systems. Any change in the data would automatically refresh all calculations,
charts and summaries.
A summary of the electrical energy use breakdown is provided on the Summary Report tab under Equipment Inventory.
The kW and kWhs are calculated on the basis of hp to kW conversion including the Amp/FLA as a multiplying load factor. Therefore, the voltage
does not affect the current calculation. If you have real-time Amp, Volt, kW, and operating hour readings of your equipment, use the Equipment Type
dropdown and select Other kW Load, then enter the kW and operating hours and the table will be even more precise.
Energy Use Assessment Tool User's Guide	36

-------
6.2.4 Next Steps
Once you have entered your information to a reasonable accuracy to create your energy usage baseline you can determine where the majority of
energy is being used. Your next steps might include the following activities:
1.	Prioritize further investigation of opportunities to reduce your energy use -
o At first, focus on discovering opportunities for energy savings on the assets with the largest energy consumption; that is where your
biggest savings can be made.
o As time permits, work down to progressively smaller assets until you have the "Balance of Plant Unidentified" down to as low of a
value as possible. Look at those assets that run for long hours. Sometimes simple operation or technological changes can greatly
reduce run time and cut large portions of energy consumption.
o Do not ignore lighting and HVAC because those areas have had great technological improvements in recent history and even one-for-
one replacement can provide great energy savings, sometimes at very low cost. Also compare room LPDs as a first step to potentially
identify where areas of the plant may be over lit.
o Lighting and HVAC can often be oversized for the plant however it is important to consult an engineer who is an expert in regulations
and safety before making fixture, lamp, ballast or quantity changes.
2.	Determine operational improvements to reduce energy use -
o Time is money when it comes to energy consumption. Changing operational procedures and schedules could reduce overall costs.
o Leaving process equipment on during non-processing time or leaving lights and heat on when a building is vacant can cost the system
money.
o Reducing consumption during low or non-processing periods and building vacancy can provide easy opportunities for saving energy
at no cost. Peak demand charges can be up to half of the plant's total electric bill. That means the more electric load the system
consumes at one time the larger the fee. Such peak demand is often carried over for months or years after it occurs. Therefore,
staggering equipment startup (when energy spikes occur) can reduce the system's peak demand and greatly reduce electrical fees.
Also, staggering cyclical equipment is an opportunity to reduce peak demand. Consult your utility rate schedule and/or utility
representative to determine your plant's demand interval (e.g. 15 minutes, 30 minutes) to be sure you're making adjustments within
the necessary time periods required by your rate schedule.
3.	Compare and contrast impacts (reductions or increases) of contemplated equipment upgrades or technology changes -
o Save another copy of EUAT to alter for hypothetical site changes. Change the baseline equipment listed in the tool with different
lighting types, more efficient equipment or different operating schedules to see the possible yearly savings instantly. They are
estimates and there will always be differences in the actual utility savings.
Energy Use Assessment Tool User's Guide
37

-------
4.	Update the tables to confirm energy impacts (reductions or increases) as operational or equipment modifications or replacements are
completed -
o Keep EUAT up-to-date as changes are made to the system and see the impact to utility consumption and provide a baseline for further
work.
5.	Seek detailed engineering insight -
o Process opportunities might exist beyond improving motor efficiencies and one-for-one upgrades. Seeking a detailed engineering
analysis of the system's largest energy consuming processes could reveal new technologies or alterations to the original design that
can reduce energy consumption.
6.	Utilize the Summary Report to -
o Provide a focused snapshot of the past and current energy utilization at the plant each month.
o Review trends to compare and contrast energy use and costs from month to month, season to season and year to year.
7.	Track site energy information to confirm use and cost impacts from operational and equipment improvements (and make sure these savings
are captured each month too), identify quickly when use and/or costs have increased and to show where there may be system limitations at the
plant requiring further analysis (e.g. where equipment is oversized and doesn't allow the plant to right size energy use as treatment volumes
increase and decrease).
Energy Use Assessment Tool User's Guide
38

-------
7 Summary Report Tab
The Summary Report tab contains a summary of all the information entered on the General Information, Building and WTP/WWTP Energy Usage
tabs. The data have been summarized into tables and charts for easy interpretation and comparison of data.
7.1 Action Buttons
The buttons available on the Summary Report tab are shown in figure 7.1.
Figure 7.1. Summary Report heading
STATEMENT OF ENERGY PERFORMANCE
UTILITY SUMMARY REPORT
September 16, 2011
7.1.1 Print Summary Report
Use the Print Summary Report button (figure 7.1- #1) to print the summary report. To change the print area, use the default print options in Excel.
7.1.2 Refresh Summary Report
Use the Refresh Summary Report button (figure 7.1- #2) to refresh the tables and charts on the tab. The tables and charts on the summary report should
automatically reflect any changes made on the other tabs. However only data entered on the yellow data entry fields would trigger a refresh. If the
summary report does not reflect the data entered, click the button to force a refresh. If that still does not refresh the report check the macros settings. If
the macros are not running properly you might need to save and then close and reopen the tool. For more details, see Appendix D (Troubleshooting
guide).
7.2 Overview of Baseline Energy Use
The Baseline Energy Use (figure 7.2) summarizes each utility's consumption and cost for the last 12 months entered on the General Information tab
and the amount of water treated during that period. It calculates the percentage of the total plant utility cost that each utility is generating during the 12
Energy Use Assessment Tool User's Guide
39

-------
months. At the end it provides an average utility cost per amount of water treated. Figure 7.2 shows an example summary of the energy use, costs and
water treatment flows for the latest 12 months of data entered.
OVERVIEW OF CURRENT/BASELINE ENERGY USE & COST FOR 2011
TABULATED UTILITY USE, COST AND WATER TREATMENT FLOW SUMMARY FOR 2011
(7/2010 - 6/2011)
Utility
Site Utility Use
(Common Units)
Site Utility Costs
% of Costs
Electricity
2,248,000 kWh
$227,497
42%
Natural Gas*
31,683 CCF
$36,132
7%
No 2 Fuel Oil*
50,546 CCF
$53,631
10%
Water & Sewer*
28,169,069 GAL
$156,967
29%
Alternative Energy*
18,236,400 CCF
$47,186
9%
Other - Propane*
18,618,000 GAL
$21,296
4%
Total
$542,709
100%
* The values displayed for this category may be using data from previous months other than the above specified date ranges.
Plant Annual Water Treatment Flow (MGAL/Year)
1,237
Plant Average Water Treatment Flow (MGAL/Month)
103
Plant Average Energy Cost Per Million Gallons Water Treated ($/MQAL)
$438.72
Figure 7.2. Overview of baseline energy use
Energy Use Assessment Tool User's Guide
40

-------
7.3 Graphical Summaries for the Latest 12 Months
EUAT takes the latest 12 months of utility data entered to produce graphs which help to analyze the energy trends for the past 1 year. The description
of each graph can be found below.
7.3.1 The Utility Cost Summary Graph
The Utility Cost Summary graph (figure 7.3.1) shows monthly trends in the Cost for your system in bar graph form and compares that to the amount of
Water Treated in line graph form.
GRAPHICAL UTILITY COST SUMMARY FOR 7/2010 - 6/2011
UTILITY COST SUMMARY (MAJOR UTILITIES)
v>
o
O
25.000
20.000
15:000
10.000 --
5.000 --
n i i i H
140
-- 120
100
-- 80
-- 60
-- 40
-- 20
0
^ ^ ^ ^ ^
v<&	.$> r$	S
4? 4V	^	4- 4*
Months
¦ Electric Cost
~Natural Gas Cost
-Water Treated
<
Figure 7.3.1a. Utility Cost Summary (Major Utilities) Graph
Energy Use Assessment Tool User's Guide	41

-------
UTILITY COST SUMMARY (ALL UTILITIES)
30.000 -r
140
120
25 000 --
100
20.000
-- 80
15;000 --
- 60
10.000 -¦
- 40
5:000 --
A


Months
^¦i Electric Cost
i	iNaturalGas Cost
i^^Alt. Energy Cost
l	1Water and Sewer Cost
1	INo.2 huel Cost
l	1 Other Cost ^
—~—Water Treated

Figure 7,3.1b. Utility Cost Summary (All Utilities) Graph
Energy Use Assessment Tool User's Guide
42

-------
7.3.2 The Electric Use vs. Water Treated Graph
The Electric Use vs. Water Treated graph (figure 7.3.2) compares Electric Use (electric energy consumption) in bar graph form with Water Treated
volumes in line graph form. As treatment amounts increase so should electric consumption and vice versa. If that relationship is weak there might be
opportunities for energy savings in equipment schedules and in process procedures.
ELECTRIC USE vs. WATER TREATED FOR 7/2010 - 6/2011
Electric Use vs. Water Treated
ts
Hi
210.000
205,000 H
200:000
195r 000
190,000
185,000
180,000
175,000
170,000
165,000
160,000
155,000
¦Electric Use
7/2010 B/2010 9/2010 10/2010 11/2010 12/2010 1/2011 2/2011 3/2011 4/2011 5/2011 6/2011
182,600 177.400 173,600 182.400 186,600 190,600 195.800 189,800 1 87,600 192,800 204,000 1 83,800
<
O
-Water Treated
91
90
92
98
100
106
112
108
117
118
111
95
Months
Figure 7.3.2. Electric Use vs. Water Treated Graph
Energy Use Assessment Tool User's Guide
43

-------
7.3.3 The Electric Use vs. Cost Graph
The Electric Use vs. Cost graph (figure 7.3.3) shows the Electric Use in bar graph form as compared to Cost in line graph form. That allows the plant
to see how energy costs are trending. Reducing peak demand charges can reduce the overall cost without decreasing the consumption.
ELECTRIC USE vs. COST FOR 7/2010 - 6/2011
Electric Use vs. Cost
a
"B
—
LLI
210 000
205.000 +
200,000
195:000 --
190;000 --
185,000
180.000
175,000
170,000 +
165,000
160,000
155.000
7/2010 3/2010 9/2010 10/2010 11/2010 12/2010 1/2011 2/2011 3/2011 4/2011 5/2011 6/2011
¦ Electric Use 102,500 177,400 173,500 102,400 105,500 190,500 195,000 109,000 107,500 192,000 204,ODO 103,000
-Electric Cost 19,940 13,042 17,690 13,050 17,876 13,336 13,184 19,402 19,248 19,704 20,930 19,997
22.000
21.000
nO
¦M
-- 20.000
I 19.000
-- 18.000
a>
5
(J
17,000
16.000
Months

Figure 7,3.3. Electric Use vs. Cost Graph
Energy Use Assessment Tool User's Guide
44

-------
7.3.4 The Electric Utilization vs. Water Treated Graph
The Electric Utilization vs. Water Treated graph shows the Electric Energy Utilization (energy consumption per amount of water treated) in bar graph
form compared to the amount of Water Treated in line graph form. If electric utilization increases sharply as the amount of water treated decreases
there might be opportunities to reduce energy consumption in the non-process, building systems or the treatment process is not designed to efficiently
handle varying flows.
ELECTRIC ENERGY UTILIZATION vs. WATER TREATED FOR 7/2010 - 6/2011
Electric Utilization vs. Water Treated
<
o

LU
u
2.500
2.000
1500
1.000
500
7/2010 8/2010 9/2010
¦Electric Energy Utilization 2,017 1,950 1,595
10/201 11/201
0	0
1,555
1,871
1,791
1/2011 2/2011 3/2011 4/2011 5/2011 6/2011
1.753 1.766 1,605 1.625 1,835 1.941
-Water Treated
91	90	92	98 100 106 112
Months
108
117
118
111
95
<
O
Figure 7.3.4. Electric Utilization vs. Water Treated Graph
Energy Use Assessment Tool User's Guide
45

-------
7.4 Distribution of Electrical Energy Use and Cost by Major Process
The summary report generates a list of the Top 5 Electrical Energy Use Systems at the plant (Figure 7.4). That breakdown is listed by major system
type. Those smaller systems not in the Top 5 will be combined and shown as the Balance of Plant Identified. The electrical energy that has not yet
been identified will be shown as Balance of Plant Unidentified. As you enter additional site data the percent of site electrical energy identified moves
closer to 100%, and the Balance of Plant Unidentified decreases.
DISTRIBUTION OF ELECTRICAL ENERGY USE & COST BY MAJOR PROCESS FOR 7/2010 - 6/2011
Major Process/Top Energy Use Electric Energy Use Electrk: Energy Use Electric Energy
Systems	(%)	(kWh)	Cost ($}
#1 SECONDARY TREATMENT
55.44%
1,246,334
$126,129
#2 FIXED FILM TREATMENT
10.62%
238,639
$24,150
#3 ANAEROBIC DIGESTION
4.70%
105,730
$10,700
#4 LIGHTING
4.98%
111,865
$11,321
#5 PRIMARY TREATMENT
3.82%
85,953
$8,698
Balance of Plant Identified
8.51%
191,404
$19,370
Balance of Plant Unidentified
11.93%
268,075
$27,129
Total
100.00%
2,248,000
$227,497
Figure 7.4. Distribution of Electrical Energy Use and Cost by Major Process
7.5 Equipment Inventory
A breakdown of the electrical energy use for all the equipment entered is shown in the summary report under the Equipment Inventory section (figure
7.5). The table groups the equipment by system type and provides an efficiency rating for each of the systems. The ratings are color coded to make the
systems easy to identify. For the rating index, see Appendix A.
Top 5 Energy Use Systems
¦	#1 SECONDARY TREATMENT
¦	#2 FIXED FILM TREATMENT
¦	#3 ANAEROBIC DIGESTION
¦	#4 LIGHTING
¦	#5 PRIMARY TREATMENT
Balance of Plant Identified
Balance of Plant Unidentified
Energy Use Assessment Tool User's Guide
46

-------
EQUIPMENT INVENTORY: BREAKDOWN OF ELECTRICAL ENERGY USE FOR MAJOR/ENERGY INTENSIVE EQUIPMENT
Major Process/Top Energy Use
Motor Efficiency
Efficiency Rating
Electric Energy Use
Electric Energy
Electric Energy
Systems


(%}
Use (kWh)
Cost ($}
Anaerobic Digestion





Mixer - Gas Mixer
SS
Medium
2.48%
55,696
$5,636,40
Other kW Load - Mixer Heater
N/A
N/A
0.80%
18,000
$1,821.60
Pump - Sludge Recir Pump
85
Medium
1.43%
32,034
$3,241.85
Effluent Pumping/Storage



Pump - Effluent Pumps
91
High
0.91%
20,363
$2,060.77
Fixed Film Treatment



Pump - R.Tower Pumps
91
High
10.62%
238,639
$24,150.28
influent Pumping



Pump - Infi Pump Station
SS
Medium
3.77%
84,667
$8,568.27
Internal Plant Pumping



Other kW Load -
N/A
N/A
0.9 7% I
21,900
$2,216.28
Lighting



Other kW Load - All Site Lighting
N/A
N/A
4.98%
111,865
$11,320.75
Non Process HVAC



Other kW Load - All Site HVAC
N/A
N/A
2.87%
64,474
$6,524.72
Primary Treatment



Blower - Channel Blower
88
Medium
2.14%
48,093
$4,866.99
Blower - Grit Blowers
89
Medium
1.68%
37,861
$3,831.49
Secondary Treatment



Blower - Secondy Blowers
91
High
52.53%
1,180,921
$119,509.12
Blower - Secondy Blowers
91
High
2.70%
60,664
$6,139.17
Pump - WAS Pumps
86
Medium
0.21%
4,749
$480.62
Estimated Annual Electric Use & Cost
1,979,925
$200,368
Actual Annual Electric Use & Cast
2,248,000
$227,497
Difference Between Billed and Identified
-268,075
-$27,129
Percent of Site Electrical Energy Identified

88.07%
Figure 7,5. Equipment Inventory
Energy Use Assessment Tool User's Guide
47

-------
7.6 Energy Trends for Over the Last 5 years
The energy trend graphs on the summary report show a comparison of year over year energy use versus water treated, energy use versus cost, and cost
versus water treated over the past 5 years.
7.6.1 Electric Use vs. Water Treated Graph
The 5 Year Electric Use vs. Water Treated graph (figure 7.6.1) shows the annual Electric Use in bar graph form compared to the amount of Water
Treated in line graph form. That allows the plant to compare how electric use and water treated is trending from year to year. Contrasts in these
comparisons may show opportunity for reductions in equipment in operation or equipment right sizing.
ELECTRIC USE vs. WATER TREATED FOR 2007 - 2011
Electric Use vs. Water Treated
2,500.000
2,000,000
1,500,000
1.000,000
500.000 +
0
0
2007	2008	2009	2010	2010 - 2011
i Electric Use 1,815,000 1,880.400	1,920.600 2.062.800 2,248.000
1,270
1,260
1,250
1,240
1,230
1,220
1,210
1,200
1,190
1,180
1.170
<
o
¦Water Treated
1.204
1.2S4
1.209
1.223
1.237
Year
Figure 7.6.1. Equipment Inventory
Energy Use Assessment Tool User's Guide
48

-------
7.6.2 Electric Use vs. Cost Graph
The 5 Year Electric Use vs. Cost graph (figure 7.6.2) shows the annual Electric Use in bar graph form as compared to Cost in line graph form. That
allows the plant to see how energy use as compared to energy costs is trending. As utility rates increase costs may increase even as electric
consumption decreases. Significant changes in site energy use and demands may allow a plant to change rate schedules which may provide for a better
overall electric rate. Signing up for available riders may also be another way to combat increases in utility rates.
ELECTRIC USE vs. COST FOR 2007 - 2011
Electric Use vs. Electric Cost
2.500 000
$250,000
_o
LU
500; 000
-- $50,000
0 -1	——
2007
1=1 Electric Use 1,815,000
2008
1,880,400
2009	2010	2010 - 2011
1,920,600 2,062,800 2,248,000
$0
~ Electric Cost $139,003
$163,036
$178,036 $210,429 $227,497
Year
Figure 7.6.2. Electric Use vs. Cost Graph
Energy Use Assessment Tool User's Guide
49

-------
7.6.3 Natural Gas Use vs. Cost Graph
The 5 Year Natural Gas Use vs. Cost graph (figure 7.6.3) shows the annual Natural Gas Use in bar graph form as compared to Cost in line graph form.
That allows the plant to see how energy use as compared to energy costs is trending. In northern climates where building heating may be a significant
portion of a sites natural gas use changes in weather may contribute significantly to changes in annual use. As these heating systems are upgraded with
more efficient units and controls the site will have more control over this use and costs. Also, separated metering for process and building natural gas
use will allow a site to focus on each systems natural gas needs separately.
NATURAL GAS USE vs. COST FOR 2007 - 2011
Natural Gas Use vs. Natural Gas Cost
60 [inn
SO.000
40.000 --
30.000 --
20.000
10.000 --
¦ atLira Gas Use
45.918
2008
48.749
2009
41.091
2010
33:050
2010 - 2011
31,683
S90,000
580,000
S70,000
-- S60,000
-- $50,000
$4-0,000
$30,000
-- $20,000
-- $10,000
$0
o
O
-Natural Gas Cost
$49,713
$58,739
$79,188
$36,005
$36,132
b Year
Figure 7.6.3 Natural Gas Use vs. Cost Graph
Energy Use Assessment Tool User's Guide
50

-------
7.6.4 Utility Cost Summary Graph
The Utility Cost Summary graph (figure 7.6.4) shows annual trends in the Cost for your system in bar graph form and compares that to the amount of
Water Treated in line graph form. As a plant implements upgrades to combat utility use significant impacts can also affect the plant's bottom line
costs. Utilities are one of the few manageable potions of a site budget.
UTILITY COST SUMMARY FOR 2007 ¦ 2011

-------
Utility Costs vs. Water Treated (All Utilities}
U)
o
O
$250,000
$2 00 000
_ $150,000
$100,000
$50,000 -
$0
1

2007
2008
2009
2010
2010 - 2011
i	1 Electric uost
$139,003
$163,036
$178,036
$210,429
$227,497
i	1 Natural uas uost
$49,713
$58,739
$79,188
$36,005
$36,132
Alt. Energy Cost
$0
$0
$0
$23,237
$47,186
i	iVvater and bewer uost
$99,284
$131,370
$143,029
$153,806
$156,967
i	1 No. 2 Fuel uost
$0
$0
$0
$53,631
$53,631
Other Cost
$0
$0
$0
$21,296
$21,296
—~—Water Treated
1,204
1,264
1,209
1,223
1,237
1,270
1,260
1,250
1,240
1,230
1,220
1,210
1,200
1,190
1,180
1.170
<
o
*
O
Year
Figure 7.6.4b. Utility Costs vs. Water Treated(All Utilities)
Energy Use Assessment Tool User's Guide
52

-------
Appendix A. Calculations
General Information Tab
Total Utility Cost per Tgal (or Mgal) Treated ($/Tgal (or Mgals)) per year = Total Annual Utility Cost in $ / Total Annual Treatment Volume
in Tgal (or Mgal)
Electrical Energy Utilization (kWh/Tgal (or Mgal)) = Total Annual Electrical Energy Consumption in kWh / Total Annual Treatment Volume
in Tgal (or Mgal)
Estimated Annual Electrical Energy Use (kWh) = Sum of the electrical energy consumption for the latest 12 months of electrical energy data
entered in kWh
Average Electrical Energy Rate ($/kWh) = Sum of the electrical costs for the latest 12 months of electrical cost data entered in $ / Sum of the
electrical energy consumption for the latest 12 months of electrical energy data entered in kWh
Electric Rate ($/kWh) = Total Annual Electricity Cost in $ / Total Annual Electrical Energy Consumption in kWh
Natural Gas ($/ccf) = Total Annual Natural Gas Cost in $ / Total Annual Natural Gas Consumption in ccf
No 2 Fuel Oil ($/ccf) = Total Annual No. 2 Fuel Oil Cost in $ / Total Annual No. 2 Fuel Oil Consumption in ccf
Water/Sewer ($/gal) = Total Annual Water/Sewer Cost in $ / Total Annual Water/Sewer Consumption in Gal
Alt. Energy ($/	) = Total Annual Alternative Energy Cost in $ / Total Annual Alternative Energy Consumption in	(the user must specify the
units).
Other Utility ($/	) = Total Annual Other Utility Cost in $ / Total Annual Other Utility Consumption in	(the user must specify the units).
Building Data Tab
Total Plant Building Area (Ft2) = Sum of building areas for all buildings entered in square foot
Total Plant Building Electric Load (kW) = Sum of building electric loads for all buildings entered in kW. The building electric load for a
building is the total of the lighting and HVAC loads for that building. The total per building is in the section, Estimated Electric Load: Total
Building [1] Combined in kW.
Total Plant Building Electric Use (kWh/Yr) = Sum of building electric use for all buildings entered in kWh. The building electric use for a
building is the total of the lighting and HVAC use for that building. The total per building is in the section, Estimated Annual Energy Use: Total
Building [1] Combined in kWh/Yr.
Energy Use Assessment Tool User's Guide
53

-------
Estimated Electric Load
o Total Building [1] Lighting (kW) = Sum of Total Room Wattage in W / 1,000
o Total Building [1] HVAC (kW) = Sum of Average HVAC Electric Load in kW
o Total Building [1] Combined (kW) = Total Building [1] Lighting Load in kW + Total Building [1] HVAC Load in kW
Estimated Annual Energy Use
o Total Building [1] Lighting (kWh/Yr) = (Sum of Total Room Wattage in W / 1,000 ) x Operating Hours per Year
o Total Building [1] HVAC (kWh/Yr) = Sum of Estimated Annual Energy Use in kWh/Yr
o Total Building [1] Combined (kWh/Yr) = Total Building [1] Lighting use in kWh/Year + Total Building [1] HVAC Use in kWh/Year
Estimated Annual Energy Cost
o Total Building [1] Lighting ($/Yr) = Total Building [1] Lighting use in kWh/Year x Average Electrical Energy Rate in $/kWh /from the
General Information tab]
o Total Building [1] HVAC ($/Yr) = Sum of Estimated Annual Operating Costs in $/Year
o Total Building [1] Combined ($/Yr) = Total Building [1] Lighting Cost in $/Year + Total Building [1] HVAC Cost in $/Year
Area (Ft2) = Total area of all the rooms entered for the building (sum of Room Area in square foot for all rooms entered)
Operating Hours per Year (Hrs/Yr) = Operating Hours per Day x Operating Hours per Week x 52
Average Building Lighting Power Density (LPD) (W/Ft2) = Sum of Room Lighting Power Density (LPD) in W/Ft2/ Total Building Area (Sum
of Room Area) in square foot
Total Room Wattage (W) = Sum of (Lighting Fixture Watts x Fixture Quantity) for all fixtures in a room
Room Lighting Power Density (LPD) (W/Ft2) = Total Room Wattage (W) in W / Room Area in square feet
HVAC/ Non-Process:
o Average Load Factor (%) = Average Motor Operating Current (Amps) / Motor Full Load Amperage (FLA)
o Average HVAC Electric Load (kW) = Motor Size (hp) * 0.746 x Average Load Factor / Motor Efficiency
o Estimated Annual Energy Use (kWh/Yr) = Average HVAC Electric Load (kW) x Motor Operating Hours (Hours/Year)
o Estimated Annual Operating Costs ($/Year) = Estimated Annual Energy Use (kWh/Yr) x Average Electrical Energy Rate ($/kWh)
[from the General Information tab]
o Estimated Percent of Site Electric Use & Cost (%) = Estimated Annual Operating Costs ($/Year) / Estimated Annual Electrical Energy
Use (kWh) [from the General Information tab]
Energy Use Assessment Tool User's Guide
54

-------
WTP/WWTP Energy Usage Tab
•	Average Load Factor (%) = Average Motor Operating Current (Amps) / Motor FLA [Not Applicable for 'Other KW Loads' Equipment Type]
•	Average Electric Load (kW) = Motor Size (hp) x 0.746 x Average Load Factor / (Motor Efficiency / 100) [Not Applicable for Other KW Loads
Equipment Type]
Estimated Annual Energy Use (kWh/Yr) = Average Electric Load (kW) x Operating Hours (Hrs/Yr)
Estimated Annual Operating Costs ($/Yr) = Estimated Annual Energy Use (kWh/Yr) x Average Electrical Energy Rate ($/kWh) [from the
General Information tab]
Estimated Percent of Site Electric Use & Cost (%) = Estimated Annual Energy Use (kWh/Yr) / Estimated Annual Electrical Energy Use (kWh)
[from the General Information tab]
Estimated Annual WTP Electric Use & Cost Fields (%) = For each column the sum of values in the rows above for all equipment entered in the
table
Actual Annual WTP Electric Use (kWh) Estimated Annual Electrical Energy Use (kWh) [from the General Information tab]
Actual Annual WTP Electric Cost ($) = Estimated Annual Electrical Energy Use (kWh) [from the General Information tab] x Average Electrical
Energy Rate ($/kWh) [from the General Information tab]
Difference Between Billed and Identified Electric Use (kWh) = Estimated Annual WTP Electric Use - Actual Annual WTP Electric Use
Difference Between Billed and Identified Electric Cost ($) = Estimated Annual WTP Electric Cost - Actual Annual WTP Electric Cost
Percent of Site Electrical Energy Identified (%) = Estimated Annual WTP Electric Use / Actual Annual WTP Electric Use
Top Energy Use Systems = Top 5 Energy Consumption Systems. All the equipment entered is grouped by System Type and then sorted by the
highest energy consumption category. The top 5 categories are displayed, and the remaining are grouped into Balance of Plant Identified.
Summary Report Tab
•	Efficiency Rating: The table below shows the rating criteria used to rate the equipment displayed on the Equipment Inventory of electrical
energy use for major/energy intensive equipment table.
Rating
Motor Efficiency %
High
>90
Medium
85-90%
Low
<85%
Energy Use Assessment Tool User's Guide
55

-------
Appendix B. Unit Definitions and Conversions
Unit
Definition
W
Watt
kW
Kilowatt
kWh
Kilowatt hour
Tgal
Thousand gallons
Mgal
Million gallons
cf
Cubic foot or Cubic feet
ccf
Hundred cubic feet
kef
Thousand cubic feet
Mcf
Million cubic feet
therm
Therm
Btu
British thermal unit
kBtu
Thousand Btu
MBtu
Million Btu
Ft"
Square foot or Square feet

Unit
Equivalent Units
1 kW
1,000 watts
1 Tgal
1,000 gallons
1 Mgal
1,000,000 gallons or 1,000 Tgal
lef
7.48052 gallons
1 ccf
100 cubic feet
1 kef
1,000 cubic feet or 10 ccf
1 Mcf
1,000,000 cubic feet or 10,000 ccf or 1,000 kef
1 therm
100,000 Btu or 100 kBtu or 0. IMBtu
1 kBtu
1,000 Btu
1 MBtu
1,000,000 Btu or 1,000 kBtu or 10 therms
Energy Use Assessment Tool User's Guide
56

-------
Appendix C. Acronyms and Abbreviations
Acronym or Abbreviation
Definition
Amp
Amperage
Btu
British thermal unit
cf
Cubic foot or Cubic feet
ccf
Hundred cubic feet
EUAT
Energy Use Assessment Tool
EPA
Enviromnental Protection Agency
FLA
Full load amperage
Ft"
Square foot or Square feet
Hp
Horsepower
HVAC
Heating, ventilation, and air conditioning
kBtu
Thousand Btu
kef
Thousand cubic feet
kW
Kilowatt
kWh
Kilowatt hour
kWh/Mgal
Kilowatt hour per million gallons
LPD
Lighting power density
MBtu
Million Btu
Mcf
Million cubic feet
Mgal
Million gallons
Tgal
Thousand gallons
therm
Therm
WTP
Water Treatment Plant
WWTP
Wastewater Treatment Plant
Energy Use Assessment Tool User's Guide
57

-------
Appendix D. Troubleshooting Guide
1.	Summary Report Does Not Get Refreshed: If the Summary report is not being refreshed with the data entered on any of the tabs check Excels
macro settings (Section 2.1). Macros need to be enabled for the charts to get generated and for the buttons to work properly.
2.	Summary Report Does Not Get Refreshed with General Information data: If the Summary report is not being refreshed with the data entered
on the General Information tab
a.	Check the Excel macro setting.
b.	Trigger the refresh action by clicking the Refresh Summary Report button on the Summary Report tab. Note that the summary report and
charts are automatically refreshed when data has been changed on the General Information tab. However, only the edits made on the yellow
input fields are considered as a change. Selecting a year from the dropdown list does not trigger the refresh action. If your summary
report does not look accurate click the Refresh Summary Report.
3.	Run-time Error: If the pop up message appears as shown in figure D.l click the End button to end the error. Then exit the tool and reopen it to
ensure that the macros run properly.
Microsoft Visual Basic
Run-time error' 1004':

Method 'Range' of object ^Worksheet failed

End Debug
Help

Figure D.l. Run-time error.
Energy Use Assessment Tool User's Guide
58

-------
4. Compile Error: Cannot find project or library.
If you see the error message, "Compile error: cannot find project or library," it indicates that Excel does not automatically include all the libraries
needed for the tool to run. You can add the required libraries by following the steps below:
a.	For Excel 2003, Press CTRL + F11 to open the VBA editor. For Excel 2007 & 2010, click on the Visual Basic editor button that is shown in
the Developer Tab (see figure 2.3.2a).
b.	From the VBA editor, click the Tools menu, click References, shown in figure D.2
c.	Check if the libraries that are shown in figure D.3 are selected. If not, scroll down through the list and select the three libraries shown in the
figure.
d.	Click OK and save the tool.
e.	Close and open the tool again to refresh.
S Microsoft Visual Basic - Energy Audit Tool_v1_EXAMPLE.xls
: File
Edit View Insert Format Debug
Run
Tools Add-Ins Window Help
HI
' y & -Ji ^ v ~
Oil 1A
1^5, References... k
L
Project -
VBAProject X

Additional Controls,..
>
m 33


Macros...

EVBAProject (Beta-test Feedback sheet
El jVBAProject (Energy Audit Tooi_vl_EX/
Options...
VBAProject Properties...
Digital Signature...

3 Microsoft Excel Objects
itf] Sheet 1 (Calculations)
jT] Sheet 10 (Energy Usage Reports)
BT] Sheetll (WWTP Energy Usage)
ST] Sheet 12 (V.TP Energy Usage)
B] Sheet 15 (Linked Cells [hidden))
if] Sheet 19 (Building 1 Data)



Figure D.2. Fixing the compile error.
Energy Use Assessment Tool User's Guide
59

-------
References - VBAProject
Available References:
§
0 Visual Basic For Applications
B Microsoft Excel 12,0 Object Library
@ Microsoft Forms 2.0 Object Library
~	VBAProject
~	IAS Helper COM Component 1.0 Type Library
~	IAS RADIUS Protocol 1,0 Type Library
~	ACPIR 1.0T ype Library
~	Acrobat
~	Acrobat Access 3,0 Type Library
~	Acrobat Distiller
~	Acrobat WebCapture 1.0 Type Library
~	Acrobat WebCapture IE Toolbar/Favorites 1.0 Type I
~	AcroIEHelper 1.0 Type Library	r -i
I artinns 1.0 Tvnp I ihrarv _ L5LI
<	I	0
ActiveReports PDF Export Filter
_tJ
Priority
±1
Location: C: 'Program Files\ArcGIS\bin\PdfExpt.c
Language: Standard
OK
Cancel
Browse.
Help
Figure D.3. The three references that are needed.
The above list of issues is not complete. If you encounter an issue not listed, please email us the details at EnergvUseTool@epa.gov . The issue may
later be added into the user's guide if relevant to all users.
Energy Use Assessment Tool User's Guide
60

-------
Appendix E. Cheat Sheet
1.	How do I change the tool template?
Use the Select/Switch Template button on the General Information tab to switch or select between a Wastewater template and a Drinking Water
template for the tool.
2.	How to enter data for both a drinking water plant and a wastewater system?
2.1.	For plants under same facility
You can enter data for both drinking water and wastewater facilities on the same spreadsheet only if both plants share the same general
information. Enter the general information first. Select the type of facility using the Select/Switch Template button (see section 4.1.1). Enter data
for the selected facility and view/print report. Use the Select/Switch Template button to switch to the other facility type. Enter data for the second
facility and view/print report. Note that you can view the report for only one of the facilities at a time, although information for both facilities has
been stored. You can switch between templates as frequently as needed to view/edit data.
2.2.	Two completely separate facilities
You will not be able to use a single spreadsheet to gather information for systems under different facilities. You will need to create a copy of the
tool (see section 2.3) and use one copy for each plant/facility. If you need to do that, you should finish the analysis of one facility before you start
the second one. Having two copies of the tool open at the same time can cause errors.
3.	How do I add lighting loads into the pie charts and reports?
A summary of the lighting information gathered on the building data tabs is displayed at the top of the WTP/WWTP Energy Usage tabs. For the
information to be included in the total energy use and displayed in the pie charts and summary report, enter the values as lighting or non-process
equipment into the Equipment Electrical Energy Inventory table. To enter the data, select the System Type of Lighting or Other Non Process
Load and the Equipment Type of Other kW Load.
4.	How do I add HVAC loads into the pie charts and reports?
A summary of the non-process HVAC information entered on the building data tabs is displayed at the top of the WTP/WWTP Energy Usage tabs.
For the information to be included in the total energy use and displayed in the pie charts and summary report, enter the values as non-process
equipment into the Equipment Electrical Energy Inventory table. To enter data, select the System Type of Non Process HVAC or Other Non
Process Load and the Equipment Type of Other kW Load.
5.	How do I enter equipment with a system type that is not in the given System Type list?
To enter system types that are not in the list select Other in that list and use the Equipment Description field to describe the system.
Energy Use Assessment Tool User's Guide
61

-------
6.	How do I enter cogeneration (co-gen) data?
Co-gen data must be integrated into the existing fields in the General Information tab. In the Electricity Consumption cells, add the electrical
production to the electricity amount billed. The amount and cost of natural gas used to keep the co-gen online should be subtracted from the
overall natural gas cells and the cost of that gas should be added to the Electricity Cost cells. There must be separate co-gen metering for this to
work.
7.	Is there a problem if my equipment voltages and phases are not all the same?
The kW and kWh are calculated on the basis of hp to kW conversion using only the Avg. Amp/FLA as a multiplying load factor. Therefore, the
voltage does not affect the tool's calculations. If you have real-time Amp, Volt, kW, and operating hour readings of your equipment use the
Equipment Type dropdown and select Other kW Load, then enter the kW and operating hours, and the table will be even more precise.
8.	How do I enter values if energy is billed on multiple accounts?
If the site has multiple accounts for the same utility (such as two electric accounts), combine the values and enter the total for use and costs for
each month under this circumstance.
9.	Will it matter if my meter readings do not start and end on the first day of the month?
It is okay if the meter readings do not start and end on the first and last day of the month respectively. Try to be as consistent in your entry as
possible. The total annual information is the most important.
10.	How do I enter energy cost and consumption for energy types that are not given in the table?
Use the Other field to enter this information. In the section on top just above the energy cost consumption data entry tables (Rows 50 and 51 on
the General Information tab), enter the type of the energy to be used as Other and specify the units for the Other type. That information is reflected
in the tables for each year.
11.	Where do I specify the units for Treatment Volume?
On the General Information tab, the section just above the cost and consumption data entry tables (Row 48 on the General Information tab), select
the units for Treatment Volume as either Tgal or Mgal here.
12.	Where do I specify the units for Alternative Energy?
On the General Information tab, the section just above the cost and consumption data entry tables (Row 49 on the General Information tab), enter
the units for Alternative Energy here.
13.	What is the right method to follow when entering my system's energy data?
To save time in identifying the assets of high energy use, start with gathering data for all motors of 10 hp and larger. If you have time gather data
next for all motors of 5 hp and greater. If you have more time gather data next for all motors sized lhp and greater.
If a piece of equipment is not motor based identify the operating load in kW along with the unit's annual operating hours.
Energy Use Assessment Tool User's Guide
62

-------
At the bottom of the data entry table (WTP/WWTP Plant Energy Usage tab), the cell labeled Percent of Site Electrical Energy Identified provides
an estimate of what portion of the system's electrical energy use has been captured. Use that percent value to help gauge the data quantity yet to be
collected and entered.
14.	How do I enter data for more than one building?
The default number of buildings on the tool is set to 1. If the site has more than one building go to the Building 1 Data tab and specify the desired
number of buildings in the dropdown list (10 maximum), then click the Set # of Buildings button. For more details, see section 5.1.4.
15.	How do I enter more lighting data for more than 4 rooms?
The default number of rooms per building is set to 4. If a building has more than four rooms, before you begin data entry for any of your rooms go
to the selected Building (X) Data tab and specify the desired number of rooms in the dropdown list (10 maximum), then click the Set # of Rooms
button. For more details, see section 5.1.5.
16.	Where can I find the size, efficiency and full load amperage ratings of a motor?
That information is on the equipment's nameplate or specification datasheet. See example nameplate below.
Motor Name and Type Typically Here
4* ft*
ENCL. DDP
I-KaMLNU. L4jI
7*8*9*
112*3»
MAX. AM B. 40 °C
SE RVICE_EACIQEil3-
HF LX-

BRG.
NO.
D.E. 6205ZZ
LOW VOLTS
RPlfl	T720
K^ACOPE	L	
O.D.E. 6205ZZ

INS. E
.fciEMA F.L. EFF. 77^>
ftTMfl rr^rri b
HZ 60
DATE uuUb UJ96
SER# 001657TO—
J T J
Motor Rated Amperage
Motor Horsepower
Motor Efficiency
Motor Company Name Typically Here
17. What are my next steps once I have generated my summary report?
See section 6.2.4 for more details of the below recommended next steps:
1.	Prioritize further investigation of opportunities to reduce your energy use
2.	Determine operational improvements to reduce energy use
3.	Compare and contrast impacts (reductions or increases) of contemplated equipment upgrades or technology changes
4.	Update the tables to confirm energy impacts (reductions or increases) as operational or equipment modifications or replacements are
completed
Energy Use Assessment Tool User's Guide
63

-------
5.	Seek detailed engineering insight
6.	Utilize the Summary Report to:
a.	Provide a focused snapshot of the past and current energy utilization at the plant each month
b.	Review trends to compare and contrast energy use and costs from month to month, season to season, and year to year
c.	Track site energy information to confirm use and cost impacts from operational and equipment improvements, identify quickly
when use and/or costs have increased, and to show where there may be system limitations at the plant requiring further analysis.
Energy Use Assessment Tool User's Guide
64

-------