EnergyUseAssessmentTool v1 0 Example by 3R72K6vb

VIEWS: 5 PAGES: 1350

									              EPA Energy Use Assessment Tool
              Version 1.0                                                                            Begin Assessment



Note: You may need to decrease your computer’s security level to allow the macros within this spreadsheet to function properly. Consult the Macro Instructions for Microsoft Excel
2007 and 2010 that are posted on EPA’s Determining Energy Usage website or email EnergyUseTool@epa.gov if you are experiencing macro related problems.


PURPOSE: This spreadsheet-based energy use assessment tool has been designed to allow small and medium sized water and wastewater utilities to self-assess their baseline energy consumption and
costs and to identify areas for improved energy efficiency and operational savings. While the tool is not equivalent to a full-scale, comprehensive energy audit, it provides the first step in establishing a
baseline of energy consumption and use by collecting energy utility data and conducting a utility bill analysis. The tool includes five (5) elements to take you through the steps to create this baseline:
Instructions, General Information, Building Data, Drinking Water (Water Treatment Plant - WTP) / Wastewater (WastewaterTreatment Plant - WWTP) Energy Usage Data, and the Summary Report.

USE: The energy use assessment tool contains several separate worksheets that take you through the process to establish your energy baseline. These worksheets can be accessed using the different
colored tabs located at the bottom of the screen. Descriptions of each tab are provided within the worksheet.

THE FOLLOWING KEY APPLIES THROUGHOUT:                                           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.

                                                                                White boxes with an arrow are dropdown lists. Click the arrow and select an option from the pre-populated list.

REQUIRED INFORMATION: We recommend that you compile the following required information before using the energy use assessment tool. 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, Water, and/or Other Utilities
 • List of Lighting Fixtures (by type and size) and HVAC equipment nameplate data (horsepower, efficiency rating, full load amp rating) and average motor operating amperage (for each
   building and room)
 • Drinking Water Treatment Plant Information, including monthly treatment/discharge volumes, pump and motor nameplate data (horsepower, efficiency rating, full load amp rating) and
   average motor operating amperage
 • Wastewater Treatment Plant Information, including monthly treatment/discharge volumes, pump and motor nameplate data (horsepower, efficiency rating, full load amp rating) and average
   motor operating amperage


USER INSTRUCTIONS:
   1. Save a new workbook under a different name. (In the Menu, click "File", then select "Save As"). If you experience difficulties opening the Excel libraries or any other macro related issues, consult the
   Macro Instructions for Microsoft Excel 2007 and 2010 that are posted on EPA’s Determining Energy Use website or email EnergyUseTool@epa.gov. You can save this file at any time, and then later
   resume editing or changing the entered data.
   2. To get started, click the "Begin Assessment" button above or click the "General Information" tab below. Begin by entering data in the "General Information" tab, including the background data and
   utility data (information from electric and gas bills). For information on how to enter data, see the Key above.
   3. To switch between data entry for Drinking Water Systems or Wastewater Systems, use the "Select/Switch Template" button at the top of the General Information tab. You can use the tool to enter
   data for either Drinking Water Systems or Wastewater Systems, but not both at the same time. However, if the data entered on the General Information tab are applicable to both plants, you can switch
   in-between templates to enter data and view the report for the selected system type. If the facility information is different, you will need to save a separate copy of the tool for each type.

   4. To continue, click the "Building Data" button at the top of the General Information tab. To allow entry for up to ten buildings, specify the number of buildings on-site and click the "Set # of Buildings"
   button. Note that the number of buildings that you select generates additional building tabs (the tabs in red) at the bottom of the tool. For information on how to enter data, see the Key above.

   5. Enter known data for all buildings on-site that need to be analyzed. When you are finished with the data entry on the first building tab, click the "Save and Continue" button. That takes you either
   back to the General Information tab or to the next building tab (if you have more than one) to enter additional building data. To reset all the data for a specific tab, click on the "Reset Data" button.


 6. To enter plant energy data, click the "Plant Energy Usage" button at the top of the General Information tab. When you are finished, click the "Save and Continue" button to view the
 summary report. To return to the General Information tab, click the "Return to General Info" button at the top of the WTP or WWTP Energy Usage tab.
   7. You can enter non-process energy information in the Equipment Electrical Energy Inventory table on the WTP or WWTP Energy Usage tab. A summary of the HVAC and lighting information input in
   the building data tabs is displayed at the top of the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie charts and summary
   report, you must enter the values into the Equipment Electrical Energy Inventory table with System Type as “Non Process HVAC ” and the Equipment Type as “Other kW Load. ”
   8. When you have entered and saved all the data, you can view your energy performance report by clicking the Summary Report tab. To print the report, click the Print Summary Report button at the
   top.
o function properly. Consult the Macro Instructions for Microsoft Excel
v if you are experiencing macro related problems.


er and wastewater utilities to self-assess their baseline energy consumption and
-scale, comprehensive energy audit, it provides the first step in establishing a
udes five (5) elements to take you through the steps to create this baseline:
 reatment Plant - WWTP) Energy Usage Data, and the Summary Report.

h your energy baseline. These worksheets can be accessed using the different




ulated using the input data. (They are read only.)




s. Click the arrow and select an option from the pre-populated list.

y use assessment tool. This will allow you to use the tool with ease and to its full


g all Electric, Natural Gas, Fuel Oil No. 2, Water, and/or Other Utilities
 amp rating) and average motor operating amperage (for each

te data (horsepower, efficiency rating, full load amp rating) and

ata (horsepower, efficiency rating, full load amp rating) and average




culties opening the Excel libraries or any other macro related issues, consult the
il EnergyUseTool@epa.gov. You can save this file at any time, and then later


tering data in the "General Information" tab, including the background data and

button at the top of the General Information tab. You can use the tool to enter
red on the General Information tab are applicable to both plants, you can switch
t, you will need to save a separate copy of the tool for each type.

ildings, specify the number of buildings on-site and click the "Set # of Buildings"
om of the tool. For information on how to enter data, see the Key above.

irst building tab, click the "Save and Continue" button. That takes you either
ata. To reset all the data for a specific tab, click on the "Reset Data" button.


are finished, click the "Save and Continue" button to view the
 or WWTP Energy Usage tab.
 TP Energy Usage tab. A summary of the HVAC and lighting information input in
d in the total energy use and to be displayed in the pie charts and summary
 ss HVAC ” and the Equipment Type as “Other kW Load. ”
y Report tab. To print the report, click the Print Summary Report button at the
                     EPA Energy Use Assessment Tool for Drinking Water Systems                                                                                                        Select/Switch Template
                                                                                                                                                                                                                                                                             Drinking Water Systems
                                                                                                                        General Information Energy Usage
                                                                                                                           Building Data  Plant                                      Reset Data              Save




                                   To switch between data entry for Drinking Water Systems or Wastewater Systems, click the "Select/Switch Template" button above. You can use the tool to enter data for either Drinking Water Systems or
                                   Wastewater Systems but not both at the same time. However, if the data entered on the General Information tab is applicable to both plants, you can switch between templates to enter data and view the report for
                                   the selected system type. If the facility information is different, you will need to save a separate copy of the tool for each type.

                                   To analyze costs associated with your facility building(s), click the "Building Data" button above or the "Building Data" tab below.

                                   To analyze total plant energy costs, click the "Plant Energy Usage" button above or the "WTP or WWTP Energy Usage" tab below.

                                   Enter the following general information about the plant.


                BACKGROUND INFORMATION


          Project                                            Example Water and Wastewater Treatment Plants                                                   Project Reference                     P123

     Facility Name                                           Sample Water and Wastewater Treatment Plants

     Site Address                                            123 Ross Road                                                                             Treatment Operation                         8500                 Hrs/Yr

                                                             Fairfax

            State                                            VA

              ZIP                                            22030                                                                                      Date of Assessment                         7/12/2011


    Plant Contact                                            John Smith                                                                           Assessment Performed by                          Jen Denwood

Contact Telephone                                            762-882-8811                                                                                      Assessor Phone                      481-553-2217

    Contact Email                                            john.smith@gmail.com                                                                              Assessor Email                      jden@gmail.com




                UTILITY BILL INFORMATION

                                   Enter the plant's monthly utility use and cost information in the cells below.

                                   This information is provided in the utility bills, use the total bill amount including any surcharges or fees.
                                   If the meter readings do not start and end on the first and last day of the month respectively, that is okay. If possible, enter the data consistently. The annual information is the most important.
                                   If the site has multiple accounts for the same utility (such as two electric accounts), enter the combined values for each month’s use and costs.

                                   Enter the most recent year's monthly data first, followed by the next most recent year's monthly data.

                                   You can enter up to 5 years worth of data. The spreadsheet calculates the site's total utility cost per treatment volumes, electrical energy use and average utility rate per individual utility. Graphs of the information
                                   are generated and shown on the "Summary Report" tab.

                                   The Estimated Annual Electric Energy Use and Cost are calculated for the latest 12 months of data entered. (For example, if data for January to July of 2010 were the latest entered, the totals would be taken from
                                   August 2009 to July 2010)



                                                                                                     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 (kW h/MGAL)      2011                  1,747.74
                                                                                                                  Electrical Energy Utilization (kW h/MGAL)      2010                  1,687.25
                                                                                                                  Electrical Energy Utilization (kW h/MGAL)      2009                  1,588.91
                                                                                                                  Electrical Energy Utilization (kW h/MGAL)      2008                  1,487.68
                                                                                                                  Electrical Energy Utilization (kW h/MGAL)      2007                  1,506.90

                                                                     Estimated Annual Electrical Energy Use (kW h)                                                                    2,248,000
                                                                       Estimated Annual Electrical Energy Cost ($)                                                                    $227,497
                                                                           Average Electrical Energy Rate ($/kW h)                                                                      $0.1012


                                                                                                                MGAL
                           Specify Units for Treatment Volume                                                          MGAL
            Specify Units for Alternative Energy Consumption                                                    CCF
                               Specify Other Utility Type (if any)                                              Propane
          Specify Units for Other Energy Consumption (if any)                                                   GAL

                2011
                                         Electric ($/kW h)              $0.1018                         Natural Gas ($/CCF)          $1.1504            No 2 Fuel Oil ($/CCF)           $1.0618                    W ater/Sewer ($/GAL)      $0.0056           Alt. Energy: ($/CCF)           $0.0042                 Other Utility: Propane ($/GAL)    $0.0011

               2011
               2011                                                  January              February                 March            April            May                 June           July           August              September        October      November       December      TOTAL (Yr)          Average                  % of Costs
               Electricity Cost ($) 2011                          $18,184.32              $19,492.46              $19,247.76      $19,704.16      $20,930.40        $19,997.44                                                                                                             $117,556.54               $19,592.76                 38.3%
                 Consumption (kW h) 2011                             196,800               189,800                 187,600         192,800         204,000              183,800                                                                                                            1,154,800.00              192,466.67
               Natural Gas Cost ($) 2011                             $6,146.54            $5,556.68               $5,015.30       $3,292.82       $1,525.44         $1,428.90                                                                                                               $22,965.68                $3,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                        $16,231.03              $11,166.71              $8,587.05       $5,077.59        $534.92              $43.09                                                                                                              $41,640.39                $6,940.07                 13.6%
                 Consumption (CCF) 2011                               14,260                10,279                  8,478           5,237            562                 400                                                                                                                 39,216.00                 6,536.00
               W ater & Sewer Cost ($) 2011                       $12,320.06              $12,320.06              $11,741.82      $11,741.82      $11,741.82        $16,794.47                                                                                                              $76,660.05               $12,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 ($) 2011                      $1,914.90            $2,035.80               $2,571.40       $2,394.60       $2,012.40         $25,071.20                                                                                                              $36,000.30                $6,000.05                 11.7%
                 Consumption (CCF) 2011                              1,473,000            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                         $1,070.30            $1,535.60               $2,324.30       $3,180.10       $2,017.40         $1,923.90                                                                                                               $12,051.60                $2,008.60                 3.9%
                 Consumption (GAL) 2011                              973,000              1,396,000               2,113,000       2,891,000       1,834,000         1,749,000                                                                                                             10,956,000.00             1,826,000.00
               Total Utility Cost 2011                                $55,867.15                $52,107.31        $49,487.63       $45,391.09     $38,762.38            $65,259.00                                                                                                    $    306,874.56     $          25,572.88               100.0%
               Treatment Volume (MGAL) 2011                          112.240               107.500                 116.700         118.400         111.200              94.700                                                                                                                 660.740                  110.123
               Utility Cost/Treatment Volume ($/MGAL) 2011              $497.75                      $484.72           $424.06        $383.37       $348.58               $689.11                                                                                                            2,827.591                  $471.27
               Electric Utilization (kW h/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



                2010
                                         Electric ($/kW h)              $0.1020                         Natural Gas ($/CCF)          $1.0894            No 2 Fuel Oil ($/CCF)           $1.0610                    W ater/Sewer ($/GAL)      $0.0056           Alt. Energy: ($/CCF)           $0.0011                 Other Utility: Propane ($/GAL)    $0.0011

               2010
               2010                                                  January              February                 March            April            May                 June           July           August              September        October      November       December      TOTAL (Yr)          Average                  % of Costs
               Electricity Cost ($) 2010                          $16,711.68              $17,684.94              $15,451.56      $15,268.68      $16,374.96        $18,996.48       $19,939.92       $18,041.58           $17,689.84       $18,057.60   $17,876.28     $18,335.72         $210,429.24               $17,535.77                 42.2%
                 Consumption (kW h) 2010                             163,200               172,200                 150,600         149,400         159,600              174,600       182,600             177,400            173,600         182,400      186,600         190,600          2,062,800.00              171,900.00
               Natural Gas Cost ($) 2010                             $5,571.01            $5,059.70               $6,072.54       $3,619.31       $1,307.83         $1,207.72        $1,188.00            $888.13           $1,018.35       $1,324.23    $2,209.15       $6,538.90          $36,004.87                $3,000.41                 7.2%
                 Consumption (CCF) 2010                               4,918                 4,659                   5,769           3,601           1,276                1,108         1,080               875                   930          1,193        1,955           5,686             33,050.00                 2,754.17
               No 2 Fuel Oil Cost ($) 2010                        $16,231.03              $11,166.71              $8,587.05       $5,077.59        $534.92              $43.09        $35.61              $55.64             $35.59         $2,825.52    $4,018.93       $5,018.93          $53,630.61                $4,469.22                 10.8%
                 Consumption (CCF) 2010                               14,260                10,279                  8,478           5,237            562                 400            30                  50                   30           2,630        3,795           4,795             50,546.00                 4,212.17
               W ater & Sewer Cost ($) 2010                       $11,981.43              $11,981.43              $11,591.70      $11,591.70      $11,591.70        $14,760.90       $14,760.90       $14,760.90           $12,821.85       $12,821.85   $12,821.85     $12,320.06         $153,806.27               $12,817.19                 30.9%
                 Consumption (GAL) 2010                              2,205,501            2,205,501               2,080,327       2,080,327       2,080,327         2,648,845        2,648,845        2,648,845             2,301,002       2,301,002    2,301,002       2,210,986        27,712,510.00             2,309,375.83
               Alternative Energy Cost ($) 2010                      $1,070.30            $1,535.60               $2,324.30       $3,180.10       $2,017.40         $1,923.90        $1,561.30        $1,420.90             $1,081.60       $3,180.10    $2,017.40       $1,923.90          $23,236.80                $1,936.40                 4.7%
                 Consumption (CCF) 2010                              973,000              1,396,000               2,113,000       2,891,000       1,834,000         1,749,000        1,201,000        1,093,000              832,000        2,891,000    1,834,000       1,749,000        20,556,000.00             1,713,000.00
               Other - Propane Cost ($) 2010                         $1,070.30            $1,535.60               $2,324.30       $3,180.10       $2,017.40         $1,923.90        $2,017.40        $1,923.90             $1,561.30       $1,420.90    $1,081.60       $1,238.90          $21,295.60                $1,774.63                 4.3%
                 Consumption (GAL) 2010                              973,000              1,396,000               2,113,000       2,891,000       1,834,000         1,749,000        1,834,000        1,749,000             1,201,000       1,093,000     832,000         953,000         18,618,000.00             1,551,500.00
               Total Utility Cost 2010                                $52,635.75                $48,963.98        $46,351.45       $41,917.48     $33,844.21            $38,855.99    $39,503.13       $37,091.05            $34,208.53     $39,630.20    $40,025.21     $45,376.41        $498,403.39               $41,533.62              100.0%
               Treatment Volume (MGAL) 2010                           80.290                75.600                 131.440         106.500         159.650              92.820        90.540              89.600             91.630          98.340        99.750         106.420            1,222.580                  101.882
               Utility Cost/Treatment Volume ($/MGAL) 2010              $655.57                      $647.67           $352.64        $393.59       $211.99               $418.62        $436.31            $413.96              $373.33      $402.99       $401.26         $426.39          $5,134.32                  $427.86
               Electric Utilization (kW h/MGAL) 2010                    2,032.63                     2,277.78       1,145.77         1,402.82         999.69              1,881.06      2,016.79           1,979.91              1,894.58     1,854.79      1,870.68       1,791.02          21,147.50                 1,762.29




                2009
                                         Electric ($/kW h)              $0.0927                         Natural Gas ($/CCF)          $1.9271            No 2 Fuel Oil ($/CCF)                                      W ater/Sewer ($/GAL)      $0.0051           Alt. Energy: ($/CCF)                                   Other Utility: Propane ($/GAL)

               2009
               2009                                                  January              February                 March            April            May                 June           July           August              September        October      November       December      TOTAL (Yr)          Average                  % of Costs
               Electricity Cost ($) 2009                          $14,414.40              $14,016.24              $14,667.84      $15,102.36      $14,001.12        $15,200.64       $16,216.80       $15,066.96           $15,607.20       $14,628.06   $14,525.28     $14,588.64         $178,035.54               $14,836.30                 44.5%
                 Consumption (kW h) 2009                             156,000               151,200                 158,400         163,800         151,200              163,800       174,000             160,800            168,000         157,800      157,200         158,400          1,920,600.00              160,050.00
               Natural Gas Cost ($) 2009                          $10,020.11              $8,990.54               $6,016.02       $39,510.20      $1,445.01         $1,189.38        $1,657.95        $1,003.10             $1,002.98       $1,663.18    $2,132.23       $4,557.24          $79,187.94                $6,599.00                 19.8%
                 Consumption (CCF) 2009                               8,686                 8,262                   5,938           4,074           1,528                1,258         1,644               994                   993          1,546        2,011           4,157             41,091.00                 3,424.25
               No 2 Fuel Oil Cost ($) 2009
                 Consumption (CCF) 2009
               W ater & Sewer Cost ($) 2009                       $10,858.82              $10,858.82              $10,307.09      $10,307.09      $10,307.09        $14,063.62       $14,063.62       $14,063.62           $12,072.55       $12,072.55   $12,072.55     $11,981.43         $143,028.85               $11,919.07                 35.7%
                 Consumption (GAL) 2009                              2,292,025            2,292,025               2,163,361       2,163,361       2,163,361         2,609,198        2,609,198        2,609,198             2,225,449       2,225,449    2,225,449       2,205,501        27,783,575.00             2,315,297.92
               Alternative Energy Cost ($) 2009
                 Consumption (CCF) 2009
               Other - Propane Cost ($) 2009
                 Consumption (GAL) 2009
               Total Utility Cost 2009                                $35,293.33                $33,865.60        $30,990.95       $64,919.65     $25,753.22            $30,453.64    $31,938.37       $30,133.68            $28,682.73     $28,363.79    $28,730.06     $31,127.31        $400,252.33               $33,354.36              100.0%
               Treatment Volume (MGAL) 2009                           68.200                92.120                 149.420         160.500         118.420              98.400        98.890              106.020            55.800          93.310        66.300         101.370            1,208.750                  100.729
               Utility Cost/Treatment Volume ($/MGAL) 2009              $517.50                      $367.62           $207.41        $404.48       $217.47               $309.49        $322.97            $284.23              $514.03      $303.97       $433.33         $307.07          $4,189.57                  $349.13
               Electric Utilization (kW h/MGAL) 2009                    2,287.39                     1,641.34       1,060.10         1,020.56       1,276.81              1,664.63      1,759.53           1,516.69              3,010.75     1,691.14      2,371.04       1,562.59          20,862.58                 1,738.55



                2008
                                         Electric ($/kW h)              $0.0867                         Natural Gas ($/CCF)          $1.2049            No 2 Fuel Oil ($/CCF)                                      W ater/Sewer ($/GAL)      $0.0044           Alt. Energy: ($/CCF)                                   Other Utility: Propane ($/GAL)

               2008
               2008                                                  January              February                 March            April            May                 June           July           August              September        October      November       December      TOTAL (Yr)          Average                  % of Costs
               Electricity Cost ($) 2008                          $12,112.80              $13,546.26              $13,777.68      $13,365.72      $12,092.64        $14,438.88       $13,808.16       $13,644.96           $13,840.14       $13,540.80   $13,990.80     $14,877.00         $163,035.84               $13,586.32                 46.2%
                 Consumption (kW h) 2008                             147,000               163,800                 166,800         162,600         146,400              162,600       154,800             148,800            150,600         148,800      157,200         171,000          1,880,400.00              156,700.00
               Natural Gas Cost ($) 2008                             $9,387.02            $9,435.17               $8,385.05       $3,180.12       $2,393.45         $2,209.78        $2,361.52        $1,831.41             $3,186.77       $3,198.96    $4,058.70       $9,111.10          $58,739.05                $4,894.92                 16.6%
                 Consumption (CCF) 2008                               8,380                 8,423                   7,485           2,494           1,876                1,565         1,584               1,230              2,143           2,190        3,505           7,874             48,749.00                 4,062.42
               No 2 Fuel Oil Cost ($) 2008
                 Consumption (CCF) 2008
               W ater & Sewer Cost ($) 2008                          $8,521.84            $8,521.84               $9,367.29       $9,367.29       $9,367.29         $13,942.72       $13,942.72       $13,942.72           $11,179.32       $11,179.32   $11,179.32     $10,858.82         $131,370.49               $10,947.54                 37.2%
                 Consumption (GAL) 2008                              2,261,355            2,261,355               2,407,973       2,407,973       2,407,973         2,963,026        2,963,026        2,963,026             2,362,342       2,362,342    2,362,342       2,292,025        30,014,758.00             2,501,229.83
               Alternative Energy Cost ($) 2008
                 Consumption (CCF) 2008
               Other - Propane Cost ($) 2008
                 Consumption (GAL) 2008
               Total Utility Cost 2008                                $30,021.66                $31,503.27        $31,530.02       $25,913.13     $23,853.38            $30,591.38    $30,112.40       $29,419.09            $28,206.23     $27,919.08    $29,228.82     $34,846.92        $353,145.38               $29,428.78              100.0%
               Treatment Volume (MGAL) 2008                          114.390               126.150                 175.770         126.300          97.960              98.700        94.860              78.120             93.300          80.910        77.700         99.820             1,263.980                  105.332
               Utility Cost/Treatment Volume ($/MGAL) 2008              $262.45                      $249.73           $179.38        $205.17       $243.50               $309.94        $317.44            $376.59              $302.32      $345.06       $376.18         $349.10          $3,516.86                  $293.07
               Electric Utilization (kW h/MGAL) 2008                    1,285.08                     1,298.45           948.97       1,287.41       1,494.49              1,647.42      1,631.88           1,904.76              1,614.15     1,839.08      2,023.17       1,713.08          18,687.93                 1,557.33



                2007
                                         Electric ($/kW h)              $0.0766                         Natural Gas ($/CCF)          $1.0826            No 2 Fuel Oil ($/CCF)                                      W ater/Sewer ($/GAL)      $0.0034           Alt. Energy: ($/CCF)                                   Other Utility: Propane ($/GAL)

               2007
               2007                                                  January              February                 March            April            May                 June           July           August              September        October      November       December      TOTAL (Yr)          Average                  % of Costs
               Electricity Cost ($) 2007                          $10,482.54              $11,025.00              $11,762.52      $10,951.92      $10,960.68        $11,049.72       $11,888.64       $10,931.52           $12,308.40       $12,402.72   $12,991.74     $12,247.20         $139,002.60               $11,583.55                 48.3%
                 Consumption (kW h) 2007                             143,400               150,000                 159,600         147,600         144,600              145,200       154,800             141,600            157,800         156,600      162,600         151,200          1,815,000.00              151,250.00
               Natural Gas Cost ($) 2007                             $9,215.95            $8,989.92               $6,731.37       $2,957.76       $1,755.60         $1,518.98        $1,697.06        $1,230.08             $1,102.10       $2,272.60    $4,638.79       $7,602.39          $49,712.60                $4,142.72                 17.3%
                 Consumption (CCF) 2007                               8,455                 8,324                   6,291           2,844           1,672                1,433         1,601               1,155              1,030           2,066        4,198           6,849             45,918.00                 3,826.50
               No 2 Fuel Oil Cost ($) 2007
                 Consumption (CCF) 2007
               W ater & Sewer Cost ($) 2007                          $6,876.88            $6,876.88               $7,542.09       $7,542.09       $7,542.09         $10,130.40       $10,130.40       $10,130.40            $7,996.91       $7,996.91    $7,996.91       $8,521.84          $99,283.80                $8,273.65                 34.5%
                 Consumption (GAL) 2007                              2,351,121            2,351,121               2,559,827       2,559,827       2,559,827         2,706,445        2,706,445        2,706,445             2,134,935       2,134,935    2,134,935       2,261,355        29,167,218.00             2,430,601.50
               Alternative Energy Cost ($) 2007
                 Consumption (CCF) 2007
               Other - Propane Cost ($) 2007
                 Consumption (GAL) 2007
               Total Utility Cost 2007                                $26,575.37                $26,891.80        $26,035.98       $21,451.77     $20,258.37            $22,699.10    $23,716.10       $22,292.00            $21,407.41     $22,672.23    $25,627.44     $28,371.43        $287,999.00               $23,999.92              100.0%
               Treatment Volume (MGAL) 2007                           99.920               101.980                 162.390         138.630         102.580              96.440        92.030              74.890             76.280          84.520        86.340         88.460             1,204.460                  100.372
               Utility Cost/Treatment Volume ($/MGAL) 2007              $265.97                      $263.70           $160.33        $154.74       $197.49               $235.37        $257.70            $297.66              $280.64      $268.25       $296.82         $320.73          $2,999.39                  $249.95
               Electric Utilization (kW h/MGAL) 2007                    1,435.15                     1,470.88           982.82       1,064.70       1,409.63              1,505.60      1,682.06           1,890.77              2,068.69     1,852.82      1,883.25       1,709.25          18,955.62                 1,579.64
                                  EPA Energy Use Assessment Tool for Drinking Water Systems
                                                       Site Structural Buildings - Major Non-Process Energy Users Data
                                                                                                Save and Continue Reset                                                                Return to General Info




                  In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on
                  how to enter that information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without
                  detailing this information here, proceed to the WTP or WWTP Energy Usage tab.

                  If you skip this tab, you can come back later to fill in this detail.



                  Enter the following information once for the entire plant.

                  Select the Total Number of Buildings on-site and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

                  After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the
                  General Information tab. You can also click the other Building Data tabs at the bottom.



Total Plant Building Area                    10,780       Ft 2                            Total Plant Building Electric Load             70.30        kW                  Total Plant Building Electric Use                 176,343.38        kW h/Yr


Does the site have buildings?                                                                                                       10               Set # of Buildings         ! Reducing the number of buildings will delete
                                                                                        Total Number of Buildings On-site           10                                              any data entered on the additional tabs



                  Enter the following information for each building at the plant.

                  To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the " Set # of rooms " button. It is important to know and set the number of rooms upfront,
                  before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



                        BUILDING 1

                                              NameAdministration                                      Operating Hours per Year           2,496        Hrs/Yr              Approximate Building Age (If known)                                                          Yrs
                                                               2                                                                    8
                                               Area
                                             3,600        Ft                                          Operating Hours per Day       8                 Hrs/Day
                            4        Set # of Rooms     ! Changing the number of rooms                                              6
                                              No. of Rooms                                             Operating Days per W eek     6                 Days/W k            Average Building Lighting Power Density (LPD)                                 7.36           W /ft 2
                                                        will reset all lighting data entered.

     Estimated Electric Load:                                                                         Estimated Annual Energy Use:                                                           Estimated Annual Energy Cost:
     Total Building 1 Lighting                                                                        Total Building 1 Lighting                                                              Total Building 1 Lighting
                                                                        27         kW                                                                        66,164       kW h/Yr                                                              $         6,695.79      $/Yr
     Total Building 1 HVAC
                                                                                                      Total Building 1 HVAC                                                                  Total Building 1 HVAC
                                                                        5          kW                                                                        18,286       kW h/Yr                                                              $         1,850.51      $/Yr
     Total Building 1 Combined                                                                        Total Building 1 Combined                                                              Total Building 1 Combined
                                                                        32         kW                                                                        84,450       kW h/Yr                                                              $         8,546.30      $/Yr


                        LIGHTING

                  To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

                  Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
                  energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

                  If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

                  The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
                  Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
                  You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




                                                 Conference
                                              Room 1 Name Room                       Area                 600 Ft 2                                                                                                Room 2 Name         Offices                       Area             2,000             Ft 2
                                              Room 1 Lighting ( Main Lighting only - Do not include task lights)                                                                                                  Room 2 Lighting ( Main Lighting only - Do not include task lights)
                                              Select up to 6 Light Fixture Types
                      Four F40T12 4' 40W Fluorescent Lam
                                                                                                      Fixture Qty                   Total Room W attage (W )                                                      Select up to 6 Light Fixture Types
                                                                                                                                                                                                                Three F40T12 4' 40W Fluorescent L                                        Fixture Qty            Total Room W attage (W )

                      Select Light Fixture
                                              Light Type 1                         175 Watts                16                                       2,800                W                                       Light Type 1
                                                                                                                                                                                                                Select Light Fixture                                   135 Watts              60                         8,100        W

                      Select Light Fixture
                                              Light Type 2                         T otal Watts                                                                                                                   Light Type 2
                                                                                                                                                                                                                Select Light Fixture                                   T otal Watts

                      Select Light Fixture
                                              Light Type 3                         T otal Watts                                     Room Lighting Power Density (LPD)                                             Light Type 3
                                                                                                                                                                                                                Select Light Fixture                                   T otal Watts                               Room Lighting Power Density (LPD)

                      Select Light Fixture
                                              Light Type 4                         T otal Watts                                          4.67         W /ft 2                                                     Light Type 4
                                                                                                                                                                                                                Select Light Fixture                                   T otal Watts                                       4.05        W /ft 2
                                              Light Type 5                         T otal Watts                                                                                                                   Light Type 5                                         T otal Watts
                                              Other Type : Name                    T otal Watts                                                                                                                   Other Type : Name                                    T otal Watts
                                                          : W atts                                                                                                                                                             : W atts



                                                                                                                        2                                                                                                                                                                                   2
                                                      Name
                                              Room 3 Hallways                        Area              1,000 Ft                                                                                                   Room 4 Name All Outside Lighting                  Area                           0   Ft
                                              Room 3 Lighting ( Main Lighting only - Do not include task lights)                                                                                                  Room 4 Lighting ( Main Lighting only - Do not include task lights)
                                              Select up to 6 Light Fixture Types                                                    Total Room W attage (W )                                                      Select up to 6 Light Fixture Types                                                            Total Room W attage (W )
                      Four F40T12 4' 40W Fluorescent La                                                                                                                                                         One 175W Mercury Vapor Lamp, Ma
                                              Light Type 1                         175 Watts                12                                       2,100                W                                       Light Type 1                                         205 Watts              45                         13,508       W
                      Select Light Fixture                                                                                                                                                                      One 250W High Pressure Sodium La
                                              Light Type 2                         T otal Watts                                                                                                                   Light Type 2                                         295 Watts              13
                      Select Light Fixture                                                                                                                                                                      One 50W High Pressure Sodium Lam
                                              Light Type 3                         T otal Watts                                     Room Lighting Power Density (LPD)                                             Light Type 3                                         64 Watts               7                   Room Lighting Power Density (LPD)
                      Select Light Fixture                                                                                                                                                                      Select Light Fixture
                                              Light Type 4                         T otal Watts                                          2.10         W /ft 2                                                     Light Type 4                                         T otal Watts                                     #DIV/0!       W /ft 2
                      Select Light Fixture                                                                                                                                                                      Select Light Fixture
                                              Light Type 5                         T otal Watts                                                                                                                   Light Type 5                                         T otal Watts

                                              Other Type : Name                    T otal Watts                                                                                                                   Other Type : Name                                    T otal Watts

                                                          : W atts                                                                                                                                                             : W atts



                                               HVAC/Non-Process Energy

                  To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
                  table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

                  Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
                  Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

                  For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

                  Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
                  If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
                  calculations.

                  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 at the plant change, you can adjust these values.

                  A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie
                  charts and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                     Average                                                                                                                             Estimated
                                                                                                                       Motor Full                        Motor
                                                                                                                                      Motor                               Average Load                                 Estimated Annual       Estimated Annual           Percent of
                                                                   Equipment        Motor Size           Motor           Load                          Operating                               Average HVAC
           System Type              Equipment Type                                                                                  Operating                                Factor                                       Energy Use          Operating Costs           Site Electric
                                                                   Description        (hp)              Efficiency     Amperage                          Hours                               Electric Load (kW )
                                                                                                                                     Current                                   (% )                                        (kW h/yr)               ($/Year)             Use & Cost
                                                                                                                        (FLA)                         (Hours/Year)
                                  Compressor
                                                                                                                                     (Amps)                                                                                                                                 (% )
        Non Process HVAC                Compressor        Air Conditioner                         3              88%            4           3.5                 2,500               87.50%                      2.23              5,563.21                $563.00                0.25%
                                  Fan
        Non Process HVAC                     Fan          HVAC                                    5              86%            6                4              4,400               66.67%                      2.89             12,722.48              $1,287.51                0.57%
                                  Select Equipment
        Non Process HVAC            Select Equipment                                                                                                                                0.00%                       0.00                   0.00                    $0.00             0.00%
                                  Select Equipment
        Non Process HVAC            Select Equipment                                                                                                                                0.00%                       0.00                   0.00                    $0.00             0.00%
                                  Select Equipment
        Non Process HVAC            Select Equipment                                                                                                                                0.00%                       0.00                   0.00                    $0.00             0.00%
                                  Select Equipment
        Non Process HVAC            Select Equipment                                                                                                                                0.00%                       0.00                   0.00                    $0.00             0.00%

                                                                                                                                          Total Building HVAC
                                                                                                                                                                                                                5.12             18,285.69              $1,850.51                0.81%
2
       EPA Energy Use Assessment Tool for Drinking Water Systems
              Site Structural Buildings - Major Non-Process Energy UsersSave and Continue                                                                    Reset Data          Return to General Info




      In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on how to enter that
      information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without detailing this information here, proceed to
      the WTP or WWTP Energy Usage tab.

      If you skip this tab, you can come back later to fill in this detail.



      The following information is entered once for the entire plant.

      To change the Total Number of Buildings on-site, go to the "Building 1 Data" tab and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

      After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the General
      Information tab. You can also click the other Building Data tabs at the bottom.


Total Plant Building Area                10,780           Ft2                     Total Plant Building Electric Load                        70.30        kW                                                          176,343.38      kWh/Yr
                                                                                                                                                                          Total Plant Building Electric Use

Does the site have
buildings?                                Yes                                     Total Number of Buildings On-site:                         10


      Enter the following information for each building at the plant.

      To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the "Set # of rooms" button. It is important to know and set the number of rooms upfront,
      before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



       BUILDING 2
       Name                                       Grit & Screen                                       Operating Hours per Year              2,912        Hrs/Yr           Approximate Building Age (If known)                                                  Yrs
       Area                               600             Ft2                                         Operating Hours per Day          88                Hrs/Day
                                                          ! Changing the number of rooms
       No. of Rooms             4        Set # of Rooms
                                                          will reset all lighting data entered.       Operating Days per Week          77                Days/Wk          Average Building Lighting Power Density (LPD)                       2.79             W/ft2

       Estimated Electric Load:                                                                       Estimated Annual Energy Use:                                                      Estimated Annual Energy Cost:
       Total Building 2 Lighting                                     2            kW                  Total Building 2 Lighting                               4,878       kWh/Yr        Total Building 2 Lighting                          $493.61             $/Yr
       Total Building 2 HVAC                                         3            kW                  Total Building 2 HVAC                                   6,552       kWh/Yr        Total Building 2 HVAC                              $663.11             $/Yr
       Total Building 2 Combined                                     4            kW                  Total Building 2 Combined                              11,430       kWh/Yr        Total Building 2 Combined                         $1,156.72            $/Yr


       LIGHTING


      To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

      Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
      energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

      If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

      The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
      Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
      You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




       Room 1 Name                              1st Floor                              Area                    600 Ft2                                                                   Room 2 Name                                                                  Area      Ft2
       Room 1 Lighting ( Main Lighting only - Do not include task lights )                                                                                                               Room 2 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                              Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                           Total Room Wattage (W)
                        Four F40T12 4' 40W Fluorescent La                                                                                                                                                   Select Light Fixture
       Light Type 1                                                               175 Watts                5                                        1,675                 W              Light Type 1                                                          Total Watts                       0             W
                        Select Light Fixture                                                                                                                                                                Select Light Fixture
       Light Type 2                                                               Total Watts                                                                                            Light Type 2                                                          Total Watts
                        Select Light Fixture                                                                                                                                                                Select Light Fixture
       Light Type 3                                                               Total Watts                                          Room Lighting Power Density (LPD)                 Light Type 3                                                          Total Watts            Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                Select Light Fixture
       Light Type 4                                                               Total Watts                                               2.79         W/ft2                           Light Type 4                                                          Total Watts                       W/ft2
                        Select Light Fixture                                                                                                                                                                Select Light Fixture
       Light Type 5                                                               Total Watts                                                                                            Light Type 5                                                          Total Watts
       Other Type : Name        100 W Incandescents                               100 Watts                8                                                                             Other Type : Name                                                     Total Watts
                      : Watts             100                                                                                                                                                             : Watts



       Room 3 Name                                                                     Area                          Ft2                                                                 Room 4 Name                                                                  Area      Ft2
       Room 3 Lighting ( Main Lighting only - Do not include task lights )                                                                                                               Room 4 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                              Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                           Total Room Wattage (W)
                        Select Light Fixture                                                                                                                                                                Select Light Fixture
       Light Type 1                                                               Total Watts                                                            0                W              Light Type 1                                                          Total Watts                       0             W
                        Select Light Fixture                                                                                                                                                                Select Light Fixture
       Light Type 2                                                               Total Watts                                                                                            Light Type 2                                                          Total Watts
                        Select Light Fixture                                                                                                                                                                Select Light Fixture
       Light Type 3                                                               Total Watts                                          Room Lighting Power Density (LPD)                 Light Type 3                                                          Total Watts            Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                Select Light Fixture
       Light Type 4                                                               Total Watts                                                            W/ft2                           Light Type 4                                                          Total Watts                       W/ft2
                        Select Light Fixture                                                                                                                                                                Select Light Fixture
       Light Type 5                                                               Total Watts                                                                                            Light Type 5                                                          Total Watts
       Other Type : Name                                                          Total Watts                                                                                            Other Type : Name                                                     Total Watts
                      : Watts                                                                                                                                                                             : Watts



              HVAC/Non-Process Energy


      To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
      table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

      Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
      Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

      For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

      Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
      If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
      calculations.

      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 at the plant change, you can adjust these values.

      A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie charts
      and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                         Average                                                                                                                 Estimated
                                                                                                                                                            Motor
                                                                                                                                          Motor                         Average                                       Estimated        Estimated Annual          Percent of
                                                                Equipment           Motor Size           Motor       Motor Full Load                      Operating                         Average HVAC
           System Type              Equipment Type                                                                                      Operating                     Load Factor                                   Annual Energy      Operating Costs          Site Electric
                                                                Description           (hp)             Efficiency    Amperage (FLA)                         Hours                         Electric Load (kW)
                                                                                                                                         Current                          (%)                                        Use (kWh/yr)           ($/Year)            Use & Cost
                                                                                                                                                         (Hours/Year)
                                                                                                                                         (Amps)                                                                                                                      (%)
                                 Fan
         Non Process HVAC                 Fan             Unit Heater Fan                     0.75             85%                1                0.9           2,500         90.00%                      0.59           1,481.03                   $149.88            0.07%
                                 Fan
         Non Process HVAC                 Fan             Unit Heater Fan                     0.75             85%                1                0.9           2,500         90.00%                      0.59           1,481.03                   $149.88            0.07%
                                 Fan
         Non Process HVAC                 Fan             Exhaust Fan                             2            85%              2.2                1.8           2,500         81.82%                      1.44           3,590.37                   $363.35            0.16%
                                 Select Equipment
         Non Process HVAC           Select Equipment                                                                                                                            0.00%                      0.00               0.00                     $0.00            0.00%
                                 Select Equipment
         Non Process HVAC           Select Equipment                                                                                                                            0.00%                      0.00               0.00                     $0.00            0.00%
                                 Select Equipment
         Non Process HVAC           Select Equipment                                                                                                                            0.00%                      0.00               0.00                     $0.00            0.00%


                                                                                                                                        Total Building HVAC                                                2.62           6,552.43                   $663.11            0.29%
       EPA Energy Use Assessment Tool for Drinking Water Systems
              Site Structural Buildings - Major Non-Process Energy Users Save and Continue                                                                     Reset Data           Return to General Info




      In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on how to enter that
      information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without detailing this information here, proceed
      to the WTP or WWTP Energy Usage tab.

      If you skip this tab, you can come back later to fill in this detail.




      The following information is entered once for the entire plant.

      To change the Total Number of Buildings on-site, go to the "Building 1 Data" tab and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

      After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the General
      Information tab. You can also click the other Building Data tabs at the bottom.


Total Plant Building Area                   10,780            Ft2                     Total Plant Building Electric Load                      70.30        kW                Total Plant Building Electric              176,343.38        kWh/Yr
                                                                                                                                                                             Use
Does the site have
buildings?                                      Yes                                   Total Number of Buildings On-site:                       10


      Enter the following information for each building at the plant.

      To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the "Set # of rooms" button. It is important to know and set the number of rooms upfront,
      before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



       BUILDING 3
       Name                                           Roughing Tower                                    Operating Hours per Year              2,912        Hrs/Yr            Approximate Building Age (If known)                                                      Yrs
       Area                                     80            Ft2                                       Operating Hours per Day          88                Hrs/Day
                                                              ! Changing the number of rooms                                                                                                                                                                                2
       No. of Rooms                4        Set # of Rooms
                                                              will reset all lighting data entered.     Operating Days per Week          77                Days/Wk           Average Building Lighting Power Density (LPD)                          2.20              W/ft

       Estimated Electric Load:                                                                         Estimated Annual Energy Use:                                                       Estimated Annual Energy Cost:
       Total Building 3 Lighting                                         0            kW                Total Building 3 Lighting                                 513        kWh/Yr        Total Building 3 Lighting                               $51.87             $/Yr
       Total Building 3 HVAC                                             1            kW                Total Building 3 HVAC                                   1,481        kWh/Yr        Total Building 3 HVAC                                $149.88               $/Yr
       Total Building 3 Combined                                         1            kW                Total Building 3 Combined                               1,994        kWh/Yr        Total Building 3 Combined                            $201.75               $/Yr


       LIGHTING


      To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

      Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
      energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

      If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

      The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
      Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
      You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




       Room 1 Name                   Roughing Tower Control Room                           Area                   80 Ft2                                                                   Room 2 Name                                                                       Area       Ft2
       Room 1 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                 Room 2 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                                 Total Room Wattage (W)
                         Two F40T12 4' 40W Fluorescent Lamps, M                                                                                                                                                  Select Light Fixture
       Light Type 1                                                                   88 Watts               2                                         176                   W             Light Type 1                                                               Total Watts                        0             W
                         Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 2                                                                   Total Watts                                                                                          Light Type 2                                                               Total Watts
                         Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 3                                                                   Total Watts                                        Room Lighting Power Density (LPD)                 Light Type 3                                                               Total Watts             Room Lighting Power Density (LPD)
                         Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 4                                                                   Total Watts                                             2.20         W/ft2                           Light Type 4                                                               Total Watts                        W/ft2
                         Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 5                                                                   Total Watts                                                                                          Light Type 5                                                               Total Watts
       Other Type : Name                                                              Total Watts                                                                                          Other Type : Name                                                          Total Watts
                      : Watts                                                                                                                                                                                : Watts



       Room 3 Name                                                                         Area                        Ft2                                                                 Room 4 Name                                                                       Area       Ft2
       Room 3 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                 Room 4 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                                 Total Room Wattage (W)
                         Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 1                                                                   Total Watts                                                          0                 W             Light Type 1                                                               Total Watts                        0             W
                         Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 2                                                                   Total Watts                                                                                          Light Type 2                                                               Total Watts
                         Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 3                                                                   Total Watts                                        Room Lighting Power Density (LPD)                 Light Type 3                                                               Total Watts             Room Lighting Power Density (LPD)
                         Select Light Fixture                                                                                                                    2                                               Select Light Fixture
       Light Type 4                                                                   Total Watts                                                          W/ft                            Light Type 4                                                               Total Watts                        W/ft2
                         Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 5                                                                   Total Watts                                                                                          Light Type 5                                                               Total Watts

       Other Type : Name                                                              Total Watts                                                                                          Other Type : Name                                                          Total Watts
                      : Watts                                                                                                                                                                                : Watts



              HVAC/Non-Process Energy


      To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
      table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

      Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
      Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

      For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

      Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
      If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
      calculations.

      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 at the plant change, you can adjust these values.

      A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie
      charts and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                           Average                                                                                                                      Estimated
                                                                                                                                                              Motor
                                                                                                                                            Motor                         Average                                    Estimated Annual       Estimated Annual            Percent of
                                                                    Equipment           Motor Size         Motor       Motor Full Load                      Operating                         Average HVAC
           System Type                 Equipment Type                                                                                     Operating                     Load Factor                                     Energy Use          Operating Costs            Site Electric
                                                                    Description           (hp)           Efficiency    Amperage (FLA)                         Hours                         Electric Load (kW)
                                                                                                                                           Current                          (%)                                          (kWh/yr)                ($/Year)              Use & Cost
                                                                                                                                                           (Hours/Year)
                                                                                                                                           (Amps)                                                                                                                           (%)
                                   Fan
         Non Process HVAC                       Fan           Unit Heater Fan                    0.75            85%                1                0.9             2,500        90.00%                      0.59            1,481.03                      $149.88             0.07%
                                   Select Equipment
         Non Process HVAC              Select Equipment                                                                                                                            0.00%                      0.00                 0.00                       $0.00             0.00%
                                   Select Equipment
         Non Process HVAC              Select Equipment                                                                                                                            0.00%                      0.00                 0.00                       $0.00             0.00%
                                   Select Equipment
         Non Process HVAC              Select Equipment                                                                                                                            0.00%                      0.00                 0.00                       $0.00             0.00%
                                   Select Equipment
         Non Process HVAC              Select Equipment                                                                                                                            0.00%                      0.00                 0.00                       $0.00             0.00%
                                   Select Equipment
         Non Process HVAC              Select Equipment                                                                                                                            0.00%                      0.00                 0.00                       $0.00             0.00%


                                                                                                                                          Total Building HVAC                                                 0.59            1,481.03                      $149.88             0.07%
       EPA Energy Use Assessment Tool for Drinking Water Systems
              Site Structural Buildings - Major Non-Process Energy Users Save and Continue                                                                       Reset Data          Return to General Info




      In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on how to enter that
      information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without detailing this information here, proceed
      to the WTP or WWTP Energy Usage tab.

      If you skip this tab, you can come back later to fill in this detail.



      The following information is entered once for the entire plant.

      To change the Total Number of Buildings on-site, go to the "Building 1 Data" tab and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

      After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the General
      Information tab. You can also click the other Building Data tabs at the bottom.


Total Plant Building Area                  10,780             Ft2                     Total Plant Building Electric Load                        70.30        kW               Total Plant Building Electric              176,343.38        kWh/Yr
                                                                                                                                                                              Use
Does the site have
buildings?                                     Yes                                    Total Number of Buildings On-site:                         10


      Enter the following information for each building at the plant.

      To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the "Set # of rooms" button. It is important to know and set the number of rooms upfront,
      before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



       BUILDING 4

       Name                                          Primary Splitter                                     Operating Hours per Year              2,912        Hrs/Yr           Approximate Building Age (If known)                                                    Yrs
       Area                                    200           Ft2                                          Operating Hours per Day          88                Hrs/Day
                                                              ! Changing the number of rooms
       No. of Rooms               4        Set # of Rooms
                                                              will reset all lighting data entered.       Operating Days per Week          77                Days/Wk          Average Building Lighting Power Density (LPD)                         3.50             W/ft2

       Estimated Electric Load:                                                                           Estimated Annual Energy Use:                                                      Estimated Annual Energy Cost:
       Total Building 4 Lighting                                         1            kW                  Total Building 4 Lighting                               2,038       kWh/Yr        Total Building 4 Lighting                              $206.29           $/Yr
       Total Building 4 HVAC                                             3            kW                  Total Building 4 HVAC                                   6,552       kWh/Yr        Total Building 4 HVAC                                  $663.11           $/Yr
       Total Building 4 Combined                                         3            kW                  Total Building 4 Combined                               8,591       kWh/Yr        Total Building 4 Combined                              $869.39           $/Yr


       LIGHTING


      To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

      Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
      energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

      If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

      The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
      Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
      You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




       Room 1 Name                             Main Floor                                  Area                    200 Ft2                                                                  Room 2 Name                                                                     Area      Ft2
       Room 1 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                  Room 2 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                  Total Room Wattage (W)                           Select up to 6 Light Fixture Types                                                              Total Room Wattage (W)
                        Four F40T12 4' 40W Fluorescent Lamps, M                                                                                                                                                   Select Light Fixture
       Light Type 1                                                                   175 Watts                4                                         700                  W             Light Type 1                                   Total                     Total Watts                       0             W
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 2                                                                   Total Watts                                                                                           Light Type 2                                   Total                     Total Watts
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 3                                                                   Total Watts                                          Room Lighting Power Density (LPD)                Light Type 3                                   Total                     Total Watts            Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 4                                                                   Total Watts                                               3.50         W/ft2                          Light Type 4                                   Total                     Total Watts                       W/ft2
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 5                                                                   Total Watts                                                                                           Light Type 5                                   Total                     Total Watts
       Other Type : Name                                                              Total Watts                                                                                           Other Type : Name                              Total                     Total Watts
                      : Watts                                                                                                                                                                                 : Watts



                                                                                                                          2                                                                                                                                                             2
       Room 3 Name                                                                         Area                          Ft                                                                 Room 4 Name                                                                     Area      Ft
       Room 3 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                  Room 4 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                  Total Room Wattage (W)                           Select up to 6 Light Fixture Types                                                              Total Room Wattage (W)
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 1                                                                   Total Watts                                                            0                W             Light Type 1                                   Total                     Total Watts                       0             W
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 2                                                                   Total Watts                                                                                           Light Type 2                                   Total                     Total Watts
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 3                                                                   Total Watts                                          Room Lighting Power Density (LPD)                Light Type 3                                   Total                     Total Watts            Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 4                                                                   Total Watts                                                            W/ft2                          Light Type 4                                   Total                     Total Watts                       W/ft2
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 5                                                                   Total Watts                                                                                           Light Type 5                                   Total                     Total Watts
       Other Type : Name                                                              Total Watts                                                                                           Other Type : Name                              Total                     Total Watts
                      : Watts                                                                                                                                                                                 : Watts



              HVAC/Non-Process Energy


      To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
      table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

      Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
      Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

      For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

      Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
      If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
      calculations.

      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 at the plant change, you can adjust these values.

      A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie
      charts and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                             Average                                                                                                                   Estimated
                                                                                                                                                                Motor
                                                                                                                                              Motor                         Average                                       Estimated          Estimated Annual          Percent of
                                                                    Equipment           Motor Size           Motor       Motor Full Load                      Operating                        Average HVAC
           System Type                Equipment Type                                                                                        Operating                     Load Factor                                   Annual Energy        Operating Costs          Site Electric
                                                                    Description           (hp)             Efficiency    Amperage (FLA)                         Hours                        Electric Load (kW)
                                                                                                                                             Current                          (%)                                        Use (kWh/yr)             ($/Year)            Use & Cost
                                                                                                                                                             (Hours/Year)
                                                                                                                                             (Amps)                                                                                                                        (%)
                                  Fan
         Non Process HVAC                      Fan            Unit Heater Fan                     0.75             85%                1                0.9           2,500         90.00%                      0.59            1,481.03                    $149.88            0.07%
                                  Fan
         Non Process HVAC                      Fan            Unit Heater Fan                     0.75             85%                1                0.9           2,500         90.00%                      0.59            1,481.03                    $149.88            0.07%
                                  Fan
         Non Process HVAC                      Fan            Exhaust Fan                             2            85%              2.2                1.8           2,500         81.82%                      1.44            3,590.37                    $363.35            0.16%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%


                                                                                                                                            Total Building HVAC                                                2.62            6,552.43                    $663.11            0.29%
       EPA Energy Use Assessment Tool for Drinking Water Systems
              Site Structural Buildings - Major Non-Process Energy UsersSave and Continue                                                                     Reset Data           Return to General Info




      In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on how to enter that
      information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without detailing this information here, proceed
      to the WTP or WWTP Energy Usage tab.

      If you skip this tab, you can come back later to fill in this detail.



      The following information is entered once for the entire plant.

      To change the Total Number of Buildings on-site, go to the "Building 1 Data" tab and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

      After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the General
      Information tab. You can also click the other Building Data tabs at the bottom.


Total Plant Building Area                  10,780           Ft2                     Total Plant Building Electric Load                       70.30        kW                Total Plant Building Electric            176,343.38         kWh/Yr
                                                                                                                                                                            Use
Does the site have
buildings?                                     Yes                                  Total Number of Buildings On-site:                        10


      Enter the following information for each building at the plant.

      To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the "Set # of rooms" button. It is important to know and set the number of rooms upfront,
      before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



       BUILDING 5
       Name                                            Digesters                                        Operating Hours per Year             2,912        Hrs/Yr            Approximate Building Age (If known)                                                   Yrs
       Area                                    1,200         Ft2                                        Operating Hours per Day         88                Hrs/Day
                                                            ! Changing the number of rooms                                                                                                                                                                              2
       No. of Rooms               4        Set # of Rooms
                                                            will reset all lighting data entered.       Operating Days per Week         77                Days/Wk           Average Building Lighting Power Density (LPD)                        2.05             W/ft

       Estimated Electric Load:                                                                         Estimated Annual Energy Use:                                                      Estimated Annual Energy Cost:
       Total Building 5 Lighting                                        2           kW                  Total Building 5 Lighting                              7,152        kWh/Yr        Total Building 5 Lighting                           $723.77             $/Yr
       Total Building 5 HVAC                                            1           kW                  Total Building 5 HVAC                                  3,590        kWh/Yr        Total Building 5 HVAC                               $363.35             $/Yr
       Total Building 5 Combined                                        4           kW                  Total Building 5 Combined                             10,742        kWh/Yr        Total Building 5 Combined                          $1,087.11            $/Yr


       LIGHTING


      To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

      Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
      energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

      If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

      The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
      Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
      You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




       Room 1 Name                             Main Floor                                Area                 1,200 Ft2                                                                   Room 2 Name                                                                    Area       Ft2
       Room 1 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                Room 2 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                               Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                              Total Room Wattage (W)
                        Two F40T12 4' 40W Fluorescent Lamps, M                                                                                                                                                 Select Light Fixture
       Light Type 1                                                                 88 Watts                 12                                      2,456                  W             Light Type 1                                                            Total Watts                        0             W
                        Select Light Fixture                                                                                                                                                                   Select Light Fixture
       Light Type 2                                                                 Total Watts                                                                                           Light Type 2                                                            Total Watts
                        Select Light Fixture                                                                                                                                                                   Select Light Fixture
       Light Type 3                                                                 Total Watts                                         Room Lighting Power Density (LPD)                 Light Type 3                                                            Total Watts             Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                    2                                              Select Light Fixture                                                                      2
       Light Type 4                                                                 Total Watts                                              2.05         W/ft                            Light Type 4                                                            Total Watts                        W/ft
                        Select Light Fixture                                                                                                                                                                   Select Light Fixture
       Light Type 5                                                                 Total Watts                                                                                           Light Type 5                                                            Total Watts
       Other Type : Name                Incandescents                               100 Watts                14                                                                           Other Type : Name                                                       Total Watts
                      : Watts                  100                                                                                                                                                       : Watts



                                                                                                                       2                                                                                                                                                              2
       Room 3 Name                                                                       Area                         Ft                                                                  Room 4 Name                                                                    Area       Ft
       Room 3 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                Room 4 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                               Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                              Total Room Wattage (W)
                        Select Light Fixture                                                                                                                                                                   Select Light Fixture
       Light Type 1                                                                 Total Watts                                                           0                 W             Light Type 1                                                            Total Watts                        0             W
                        Select Light Fixture                                                                                                                                                                   Select Light Fixture
       Light Type 2                                                                 Total Watts                                                                                           Light Type 2                                                            Total Watts
                        Select Light Fixture                                                                                                                                                                   Select Light Fixture
       Light Type 3                                                                 Total Watts                                         Room Lighting Power Density (LPD)                 Light Type 3                                                            Total Watts             Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                   Select Light Fixture
       Light Type 4                                                                 Total Watts                                                           W/ft2                           Light Type 4                                                            Total Watts                        W/ft2
                        Select Light Fixture                                                                                                                                                                   Select Light Fixture
       Light Type 5                                                                 Total Watts                                                                                           Light Type 5                                                            Total Watts

       Other Type : Name                                                            Total Watts                                                                                           Other Type : Name                                                       Total Watts
                      : Watts                                                                                                                                                                            : Watts



              HVAC/Non-Process Energy


      To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
      table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

      Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
      Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

      For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

      Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
      If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
      calculations.

      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 at the plant change, you can adjust these values.

      A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie
      charts and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                          Average                                                                                                                   Estimated
                                                                                                                                                             Motor
                                                                                                                                           Motor                         Average                                   Estimated Annual       Estimated Annual          Percent of
                                                                   Equipment          Motor Size           Motor      Motor Full Load                      Operating                         Average HVAC
           System Type                Equipment Type                                                                                     Operating                     Load Factor                                    Energy Use          Operating Costs          Site Electric
                                                                   Description          (hp)             Efficiency   Amperage (FLA)                         Hours                         Electric Load (kW)
                                                                                                                                          Current                          (%)                                         (kWh/yr)                ($/Year)            Use & Cost
                                                                                                                                                          (Hours/Year)
                                                                                                                                          (Amps)                                                                                                                        (%)
                                  Fan
         Non Process HVAC                      Fan          Exhaust Fan                             2          85%               2.2                1.8             2,500        81.82%                     1.44            3,590.37                    $363.35             0.16%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                     0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                     0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                     0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                     0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                     0.00                 0.00                     $0.00             0.00%


                                                                                                                                         Total Building HVAC                                                1.44            3,590.37                    $363.35             0.16%
       EPA Energy Use Assessment Tool for Drinking Water Systems
              Site Structural Buildings - Major Non-Process Energy UsersSave and Continue                                                                     Reset Data           Return to General Info




      In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on how to enter that
      information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without detailing this information here, proceed
      to the WTP or WWTP Energy Usage tab.

      If you skip this tab, you can come back later to fill in this detail.



      The following information is entered once for the entire plant.

      To change the Total Number of Buildings on-site, go to the "Building 1 Data" tab and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

      After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the General
      Information tab. You can also click the other Building Data tabs at the bottom.


Total Plant Building Area                  10,780           Ft2                     Total Plant Building Electric Load                       70.30        kW                Total Plant Building Electric               176,343.38       kWh/Yr
                                                                                                                                                                            Use
Does the site have
buildings?                                     Yes                                  Total Number of Buildings On-site:                        10


      Enter the following information for each building at the plant.

      To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the "Set # of rooms" button. It is important to know and set the number of rooms upfront,
      before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



       BUILDING 6
       Name                                      Secondary Pumping                                     Operating Hours per Year              2,912        Hrs/Yr            Approximate Building Age (If known)                                                    Yrs
       Area                                    500         Ft2                                         Operating Hours per Day          88                Hrs/Day
                                                            ! Changing the number of rooms                                                                                                                                                                               2
       No. of Rooms               4        Set # of Rooms
                                                            will reset all lighting data entered.      Operating Days per Week          77                Days/Wk           Average Building Lighting Power Density (LPD)                         3.34             W/ft

       Estimated Electric Load:                                                                        Estimated Annual Energy Use:                                                       Estimated Annual Energy Cost:
       Total Building 6 Lighting                                       2            kW                 Total Building 6 Lighting                               4,869        kWh/Yr        Total Building 6 Lighting                            $492.73             $/Yr
       Total Building 6 HVAC                                           1            kW                 Total Building 6 HVAC                                   1,481        kWh/Yr        Total Building 6 HVAC                                $149.88             $/Yr
       Total Building 6 Combined                                       2            kW                 Total Building 6 Combined                               6,350        kWh/Yr        Total Building 6 Combined                            $642.61             $/Yr


       LIGHTING


      To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

      Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
      energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

      If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

      The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
      Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
      You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




       Room 1 Name                             Main Floor                                Area                   500 Ft2                                                                   Room 2 Name                                                                     Area       Ft2
       Room 1 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                Room 2 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                               Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                               Total Room Wattage (W)
                        Two F96T12 HO 8' 95W ES Fluorescent L                                                                                                                                                   Select Light Fixture
       Light Type 1                                                                 209 Watts               8                                        1,672                  W             Light Type 1                                                             Total Watts                        0             W
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 2                                                                 Total Watts                                                                                           Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 3                                                                 Total Watts                                         Room Lighting Power Density (LPD)                 Light Type 3                                                             Total Watts             Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                    2                                               Select Light Fixture                                                                      2
       Light Type 4                                                                 Total Watts                                              3.34         W/ft                            Light Type 4                                                             Total Watts                        W/ft
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 5                                                                 Total Watts                                                                                           Light Type 5                                                             Total Watts
       Other Type : Name                                                            Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                               : Watts



                                                                                                                       2                                                                                                                                                               2
       Room 3 Name                                                                       Area                         Ft                                                                  Room 4 Name                                                                     Area       Ft
       Room 3 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                Room 4 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                               Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                               Total Room Wattage (W)
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 1                                                                 Total Watts                                                           0                 W             Light Type 1                                                             Total Watts                        0             W
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 2                                                                 Total Watts                                                                                           Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 3                                                                 Total Watts                                         Room Lighting Power Density (LPD)                 Light Type 3                                                             Total Watts             Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 4                                                                 Total Watts                                                           W/ft2                           Light Type 4                                                             Total Watts                        W/ft2
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 5                                                                 Total Watts                                                                                           Light Type 5                                                             Total Watts

       Other Type : Name                                                            Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                               : Watts



              HVAC/Non-Process Energy


      To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
      table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

      Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
      Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

      For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

      Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
      If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
      calculations.

      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 at the plant change, you can adjust these values.

      A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie
      charts and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                          Average                                                                                                                    Estimated
                                                                                                                                                             Motor
                                                                                                                                           Motor                         Average                                      Estimated Annual     Estimated Annual          Percent of
                                                                  Equipment           Motor Size          Motor       Motor Full Load                      Operating                         Average HVAC
           System Type                Equipment Type                                                                                     Operating                     Load Factor                                       Energy Use        Operating Costs          Site Electric
                                                                  Description           (hp)            Efficiency    Amperage (FLA)                         Hours                         Electric Load (kW)
                                                                                                                                          Current                          (%)                                            (kWh/yr)              ($/Year)            Use & Cost
                                                                                                                                                          (Hours/Year)
                                                                                                                                          (Amps)                                                                                                                         (%)
                                  Fan
         Non Process HVAC                      Fan          Unit Heater Fan                     0.75            85%                1                0.9             2,500        90.00%                      0.59             1,481.03                   $149.88             0.07%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                      0.00                 0.00                     $0.00             0.00%


                                                                                                                                         Total Building HVAC                                                 0.59             1,481.03                   $149.88             0.07%
       EPA Energy Use Assessment Tool for Drinking Water Systems
              Site Structural Buildings - Major Non-Process Energy UsersSave and Continue                                                                        Reset Data           Return to General Info




      In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on how to enter that
      information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without detailing this information here, proceed
      to the WTP or WWTP Energy Usage tab.

      If you skip this tab, you can come back later to fill in this detail.



      The following information is entered once for the entire plant.

      To change the Total Number of Buildings on-site, go to the "Building 1 Data" tab and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

      After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the General
      Information tab. You can also click the other Building Data tabs at the bottom.


Total Plant Building Area                  10,780              Ft2                     Total Plant Building Electric Load                       70.30        kW                Total Plant Building Electric               176,343.38       kWh/Yr
                                                                                                                                                                               Use
Does the site have
buildings?                                     Yes                                     Total Number of Buildings On-site:                        10


      Enter the following information for each building at the plant.

      To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the "Set # of rooms" button. It is important to know and set the number of rooms upfront,
      before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



       BUILDING 7
       Name                                            Blower Building                                     Operating Hours per Year             2,912        Hrs/Yr            Approximate Building Age (If known)                                                    Yrs
       Area                                    1,200           Ft2                                         Operating Hours per Day         88                Hrs/Day
                                                               ! Changing the number of rooms                                                                                                                                                                               2
       No. of Rooms               4       Set # of Rooms
                                                               will reset all lighting data entered.       Operating Days per Week         77                Days/Wk           Average Building Lighting Power Density (LPD)                         1.34             W/ft

       Estimated Electric Load:                                                                            Estimated Annual Energy Use:                                                      Estimated Annual Energy Cost:
       Total Building 7 Lighting                                          2            kW                  Total Building 7 Lighting                              4,694        kWh/Yr        Total Building 7 Lighting                            $475.05             $/Yr
       Total Building 7 HVAC                                              3            kW                  Total Building 7 HVAC                                  7,181        kWh/Yr        Total Building 7 HVAC                                $726.69             $/Yr
       Total Building 7 Combined                                          4            kW                  Total Building 7 Combined                              11,875       kWh/Yr        Total Building 7 Combined                           $1,201.74            $/Yr


       LIGHTING


      To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

      Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
      energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

      If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

      The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
      Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
      You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




       Room 1 Name                   Blower Room Floors 1 and 2                             Area                 1,200 Ft2                                                                   Room 2 Name                                                                     Area       Ft2
       Room 1 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                   Room 2 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                  Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                               Total Room Wattage (W)
                        Two F32T8 4' 32W Fluorescent Lamps, El                                                                                                                                                     Select Light Fixture
       Light Type 1                                                                    62 Watts                 26                                      1,612                  W             Light Type 1                                                             Total Watts                        0             W
                        Select Light Fixture                                                                                                                                                                       Select Light Fixture
       Light Type 2                                                                    Total Watts                                                                                           Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                       Select Light Fixture
       Light Type 3                                                                    Total Watts                                         Room Lighting Power Density (LPD)                 Light Type 3                                                             Total Watts             Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                       2                                               Select Light Fixture
       Light Type 4                                                                    Total Watts                                              1.34         W/ft                            Light Type 4                                                             Total Watts                        W/ft2
                        Select Light Fixture                                                                                                                                                                       Select Light Fixture
       Light Type 5                                                                    Total Watts                                                                                           Light Type 5                                                             Total Watts
       Other Type : Name                                                               Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                                  : Watts



                                                                                                                          2
       Room 3 Name                                                                          Area                         Ft                                                                  Room 4 Name                                                                     Area       Ft2
       Room 3 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                   Room 4 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                  Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                               Total Room Wattage (W)
                        Select Light Fixture                                                                                                                                                                       Select Light Fixture
       Light Type 1                                                                    Total Watts                                                           0                 W             Light Type 1                                                             Total Watts                        0             W
                        Select Light Fixture                                                                                                                                                                       Select Light Fixture
       Light Type 2                                                                    Total Watts                                                                                           Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                       Select Light Fixture
       Light Type 3                                                                    Total Watts                                         Room Lighting Power Density (LPD)                 Light Type 3                                                             Total Watts             Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                       2                                               Select Light Fixture                                                                      2
       Light Type 4                                                                    Total Watts                                                           W/ft                            Light Type 4                                                             Total Watts                        W/ft
                        Select Light Fixture                                                                                                                                                                       Select Light Fixture
       Light Type 5                                                                    Total Watts                                                                                           Light Type 5                                                             Total Watts
       Other Type : Name                                                               Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                                  : Watts



              HVAC/Non-Process Energy


      To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
      table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

      Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
      Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

      For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

      Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
      If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
      calculations.

      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 at the plant change, you can adjust these values.

      A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie
      charts and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                             Average                                                                                                                    Estimated
                                                                                                                                                                Motor
                                                                                                                                              Motor                         Average                                      Estimated Annual     Estimated Annual          Percent of
                                                                     Equipment           Motor Size           Motor      Motor Full Load                      Operating                         Average HVAC
           System Type                Equipment Type                                                                                        Operating                     Load Factor                                       Energy Use        Operating Costs          Site Electric
                                                                     Description           (hp)             Efficiency   Amperage (FLA)                         Hours                         Electric Load (kW)
                                                                                                                                             Current                          (%)                                            (kWh/yr)              ($/Year)            Use & Cost
                                                                                                                                                             (Hours/Year)
                                                                                                                                             (Amps)                                                                                                                         (%)
                                  Fan
         Non Process HVAC                      Fan             Exhaust Fan                             2          85%               2.2                1.8             2,500        81.82%                      1.44             3,590.37                   $363.35             0.16%
                                  Fan
         Non Process HVAC                      Fan             Exhaust Fan                             2          85%               2.2                1.8             2,500        81.82%                      1.44             3,590.37                   $363.35             0.16%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                               0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                               0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                               0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                               0.00%                      0.00                 0.00                     $0.00             0.00%


                                                                                                                                            Total Building HVAC                                                 2.87             7,180.75                   $726.69             0.32%
       EPA Energy Use Assessment Tool for Drinking Water Systems
              Site Structural Buildings - Major Non-Process Energy UsersSave and Continue                                                                      Reset Data          Return to General Info




      In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on how to enter that
      information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without detailing this information here, proceed
      to the WTP or WWTP Energy Usage tab.

      If you skip this tab, you can come back later to fill in this detail.



      The following information is entered once for the entire plant.

      To change the Total Number of Buildings on-site, go to the "Building 1 Data" tab and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

      After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the General
      Information tab. You can also click the other Building Data tabs at the bottom.


Total Plant Building Area                  10,780           Ft2                     Total Plant Building Electric Load                        70.30        kW               Total Plant Building Electric               176,343.38       kWh/Yr
                                                                                                                                                                            Use
Does the site have
buildings?                                     Yes                                  Total Number of Buildings On-site:                         10


      Enter the following information for each building at the plant.

      To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the "Set # of rooms" button. It is important to know and set the number of rooms upfront,
      before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



       BUILDING 8
       Name                                       Equipment Garage                                      Operating Hours per Year              2,080        Hrs/Yr           Approximate Building Age (If known)                                                    Yrs
       Area                                    800         Ft2                                          Operating Hours per Day          88                Hrs/Day
                                                            ! Changing the number of rooms                                                                                                                                                                               2
       No. of Rooms               4        Set # of Rooms
                                                            will reset all lighting data entered.       Operating Days per Week          55                Days/Wk          Average Building Lighting Power Density (LPD)                         3.72             W/ft

       Estimated Electric Load:                                                                         Estimated Annual Energy Use:                                                      Estimated Annual Energy Cost:
       Total Building 8 Lighting                                       3            kW                  Total Building 8 Lighting                               6,190       kWh/Yr        Total Building 8 Lighting                            $626.44             $/Yr
       Total Building 8 HVAC                                           3            kW                  Total Building 8 HVAC                                   6,031       kWh/Yr        Total Building 8 HVAC                                $610.35             $/Yr
       Total Building 8 Combined                                       6            kW                  Total Building 8 Combined                              12,221       kWh/Yr        Total Building 8 Combined                           $1,236.79            $/Yr


       LIGHTING


      To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

      Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
      energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

      If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

      The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
      Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
      You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




       Room 1 Name                             Main Floor                                Area                    800 Ft2                                                                  Room 2 Name                                                                     Area       Ft2
       Room 1 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                Room 2 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                Total Room Wattage (W)                           Select up to 6 Light Fixture Types                                                               Total Room Wattage (W)
                        Two F96T12 8' 75W Slim Fluorescent Lam                                                                                                                                                  Select Light Fixture
       Light Type 1                                                                 142 Watts                8                                        2,976                 W             Light Type 1                                                             Total Watts                        0             W
                        One 400W Metal Halide Lamp, Electronic                                                                                                                                                  Select Light Fixture
       Light Type 2                                                                 460 Watts                4                                                                            Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 3                                                                 Total Watts                                          Room Lighting Power Density (LPD)                Light Type 3                                                             Total Watts             Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 4                                                                 Total Watts                                               3.72         W/ft2                          Light Type 4                                                             Total Watts                        W/ft2
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 5                                                                 Total Watts                                                                                           Light Type 5                                                             Total Watts
       Other Type : Name                                                            Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                               : Watts



                                                                                                                        2                                                                                                                                                              2
       Room 3 Name                                                                       Area                          Ft                                                                 Room 4 Name                                                                     Area       Ft
       Room 3 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                Room 4 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                Total Room Wattage (W)                           Select up to 6 Light Fixture Types                                                               Total Room Wattage (W)
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 1                                                                 Total Watts                                                            0                W             Light Type 1                                                             Total Watts                        0             W
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 2                                                                 Total Watts                                                                                           Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 3                                                                 Total Watts                                          Room Lighting Power Density (LPD)                Light Type 3                                                             Total Watts             Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 4                                                                 Total Watts                                                            W/ft2                          Light Type 4                                                             Total Watts                        W/ft2
                        Select Light Fixture                                                                                                                                                                    Select Light Fixture
       Light Type 5                                                                 Total Watts                                                                                           Light Type 5                                                             Total Watts
       Other Type : Name                                                            Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                               : Watts



              HVAC/Non-Process Energy


      To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
      table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

      Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
      Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

      For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

      Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
      If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
      calculations.

      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 at the plant change, you can adjust these values.

      A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie
      charts and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                           Average                                                                                                                   Estimated
                                                                                                                                                              Motor
                                                                                                                                            Motor                         Average                                     Estimated Annual     Estimated Annual          Percent of
                                                                  Equipment           Motor Size           Motor       Motor Full Load                      Operating                        Average HVAC
           System Type                Equipment Type                                                                                      Operating                     Load Factor                                      Energy Use        Operating Costs          Site Electric
                                                                  Description           (hp)             Efficiency    Amperage (FLA)                         Hours                        Electric Load (kW)
                                                                                                                                           Current                          (%)                                           (kWh/yr)              ($/Year)            Use & Cost
                                                                                                                                                           (Hours/Year)
                                                                                                                                           (Amps)                                                                                                                        (%)
                                  Fan
         Non Process HVAC                      Fan          HVAC Unit Fan                           3            85%              3.4                2.8           2,500         82.35%                      2.17             5,420.76                   $548.58             0.24%
                                  Compressor
         Non Process HVAC               Compressor          AC Unit                                 1            85%              1.1               0.85             900         77.27%                      0.68               610.36                    $61.77             0.03%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                      0.00                 0.00                     $0.00             0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                            0.00%                      0.00                 0.00                     $0.00             0.00%


                                                                                                                                          Total Building HVAC                                                2.85             6,031.12                   $610.35             0.27%
       EPA Energy Use Assessment Tool for Drinking Water Systems
              Site Structural Buildings - Major Non-Process Energy UsersSave and Continue                                                                       Reset Data           Return to General Info




      In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on how to enter that
      information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without detailing this information here, proceed
      to the WTP or WWTP Energy Usage tab.

      If you skip this tab, you can come back later to fill in this detail.



      The following information is entered once for the entire plant.

      To change the Total Number of Buildings on-site, go to the "Building 1 Data" tab and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

      After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the General
      Information tab. You can also click the other Building Data tabs at the bottom.


Total Plant Building Area                  10,780             Ft2                     Total Plant Building Electric Load                       70.30        kW                Total Plant Building Electric               176,343.38       kWh/Yr
                                                                                                                                                                              Use
Does the site have
buildings?                                     Yes                                    Total Number of Buildings On-site:                        10


      Enter the following information for each building at the plant.

      To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the "Set # of rooms" button. It is important to know and set the number of rooms upfront,
      before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



       BUILDING 9
       Name                                        Maintenance Facility                                   Operating Hours per Year             2,080        Hrs/Yr            Approximate Building Age (If known)                                                    Yrs
       Area                                    2,000         Ft2                                          Operating Hours per Day         88                Hrs/Day
                                                              ! Changing the number of rooms
       No. of Rooms               4        Set # of Rooms
                                                              will reset all lighting data entered.       Operating Days per Week         55                Days/Wk           Average Building Lighting Power Density (LPD)                         3.29             W/ft2

       Estimated Electric Load:                                                                           Estimated Annual Energy Use:                                                      Estimated Annual Energy Cost:
       Total Building 9 Lighting                                          7           kW                  Total Building 9 Lighting                             13,674        kWh/Yr        Total Building 9 Lighting                           $1,383.80            $/Yr
       Total Building 9 HVAC                                              2           kW                  Total Building 9 HVAC                                  5,540        kWh/Yr        Total Building 9 HVAC                                $560.64             $/Yr
       Total Building 9 Combined                                          9           kW                  Total Building 9 Combined                             19,214        kWh/Yr        Total Building 9 Combined                           $1,944.44            $/Yr


       LIGHTING


      To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

      Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
      energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

      If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

      The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
      Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
      You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




                                                                                                                          2                                                                                                                                                             2
       Room 1 Name                             Main Floor                                  Area                 2,000 Ft                                                                    Room 2 Name                                                                     Area      Ft
       Room 1 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                  Room 2 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                 Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                              Total Room Wattage (W)
                        Two F96T12 8' 75W Slim Fluorescent Lam                                                                                                                                                    Select Light Fixture
       Light Type 1                                                                   142 Watts                37                                      6,574                  W             Light Type 1                                                             Total Watts                       0             W
                        Two F40T12 4' 40W Fluorescent Lamps, M                                                                                                                                                    Select Light Fixture
       Light Type 2                                                                   88 Watts                 15                                                                           Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 3                                                                   Total Watts                                         Room Lighting Power Density (LPD)                 Light Type 3                                                             Total Watts            Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                      2                                               Select Light Fixture                                                                     2
       Light Type 4                                                                   Total Watts                                              3.29         W/ft                            Light Type 4                                                             Total Watts                       W/ft
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 5                                                                   Total Watts                                                                                           Light Type 5                                                             Total Watts
       Other Type : Name                                                              Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                                 : Watts



       Room 3 Name                                                                         Area                         Ft2                                                                 Room 4 Name                                                                     Area      Ft2
       Room 3 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                  Room 4 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                 Total Room Wattage (W)                            Select up to 6 Light Fixture Types                                                              Total Room Wattage (W)
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 1                                                                   Total Watts                                                           0                 W             Light Type 1                                                             Total Watts                       0             W
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 2                                                                   Total Watts                                                                                           Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 3                                                                   Total Watts                                         Room Lighting Power Density (LPD)                 Light Type 3                                                             Total Watts            Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 4                                                                   Total Watts                                                           W/ft2                           Light Type 4                                                             Total Watts                       W/ft2
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 5                                                                   Total Watts                                                                                           Light Type 5                                                             Total Watts

       Other Type : Name                                                              Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                                 : Watts



              HVAC/Non-Process Energy


      To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
      table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

      Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
      Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

      For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

      Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
      If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
      calculations.

      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 at the plant change, you can adjust these values.

      A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie
      charts and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                            Average                                                                                                                    Estimated
                                                                                                                                                               Motor
                                                                                                                                             Motor                         Average                                      Estimated Annual     Estimated Annual          Percent of
                                                                    Equipment           Motor Size           Motor      Motor Full Load                      Operating                         Average HVAC
           System Type                Equipment Type                                                                                       Operating                     Load Factor                                       Energy Use        Operating Costs          Site Electric
                                                                    Description           (hp)             Efficiency   Amperage (FLA)                         Hours                         Electric Load (kW)
                                                                                                                                            Current                          (%)                                            (kWh/yr)              ($/Year)            Use & Cost
                                                                                                                                                            (Hours/Year)
                                                                                                                                            (Amps)                                                                                                                         (%)
                                  Fan
         Non Process HVAC                      Fan            HVAC Unit                               3          85%               3.4                2.4             2,500        70.59%                      1.86             4,646.37                   $470.21            0.21%
                                  Compressor
         Non Process HVAC               Compressor            AC                                      1          85%               1.1                0.8             1,400        72.73%                      0.64              893.60                     $90.43            0.04%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%


                                                                                                                                           Total Building HVAC
                                                                                                                                                                                                               2.50             5,539.97                   $560.64            0.25%
       EPA Energy Use Assessment Tool for Drinking Water Systems
              Site Structural Buildings - Major Non-Process Energy UsersSave and Continue                                                                        Reset Data          Return to General Info




      In the Building Data tabs, the tool totals each building’s Lighting and HVAC information. You should use the totals for entry on the WTP or WWTP Energy Use tabs. For instructions on how to enter that
      information, see the WTP or WWTP Energy Usage tabs. If you have already identified the site's Lighting and HVAC loads or would just like to estimate them without detailing this information here, proceed
      to the WTP or WWTP Energy Usage tab.

      If you skip this tab, you can come back later to fill in this detail.



      The following information is entered once for the entire plant.

      To change the Total Number of Buildings on-site, go to the "Building 1 Data" tab and click the "Set # of Buildings" button. This lets you enter information for the specified number of buildings.

      After entering data in a building tab, click the "Save and Continue" button at the top. That allows you to enter data for the next building or if building data entry is complete, to return to the General
      Information tab. You can also click the other Building Data tabs at the bottom.


Total Plant Building Area                  10,780             Ft2                     Total Plant Building Electric Load                        70.30        kW               Total Plant Building Electric              176,343.38        kWh/Yr
                                                                                                                                                                              Use
Does the site have
buildings?                                     Yes                                    Total Number of Buildings On-site:                         10


      Enter the following information for each building at the plant.

      To begin, select the number of rooms in the "No. of Rooms" dropdown list below and click the "Set # of rooms" button. It is important to know and set the number of rooms upfront,
      before any lighting data is entered. If the number of rooms is later changed, all the data that had been entered will be lost.



       BUILDING 10
       Name                                          Chemical Storage                                     Operating Hours per Year              1,040        Hrs/Yr           Approximate Building Age (If known)                                                    Yrs
       Area                                    600            Ft2                                         Operating Hours per Day          44                Hrs/Day
                                                              ! Changing the number of rooms
       No. of Rooms               4        Set # of Rooms
                                                              will reset all lighting data entered.       Operating Days per Week          55                Days/Wk          Average Building Lighting Power Density (LPD)                         2.75             W/ft2

       Estimated Electric Load:                                                                           Estimated Annual Energy Use:                                                      Estimated Annual Energy Cost:
       Total Building 10 Lighting                                        2            kW                  Total Building 10 Lighting                              1,717       kWh/Yr        Total Building 10 Lighting                           $173.76             $/Yr
       Total Building 10 HVAC                                            3            kW                  Total Building 10 HVAC                                  7,760       kWh/Yr        Total Building 10 HVAC                               $785.33             $/Yr
       Total Building 10 Combined                                        5            kW                  Total Building 10 Combined                              9,477       kWh/Yr        Total Building 10 Combined                           $959.09             $/Yr


       LIGHTING


      To determine the site’s lighting loads and energy use, select each of the room’s lighting fixture types and quantity (Qty) using the dropdown lists below.

      Select a light type from the dropdown list for each size and kind of fixture in a room. Then enter the quantity for each type. The tool provides the fixture’s electrical
      energy load in watts. Do not include task lights (directional lights used to illuminate an area of work) when entering the room's lighting fixtures.

      If a type of fixture is not available in the dropdown list, use the "Other Type" input field to enter the fixture and its total wattage.

      The table automatically totals the room's lighting loads, each building's lighting energy use and the site's total lighting energy use per year for use in other areas of the tool.
      Enter the area of each room and the tool calculates the Lighting Power Density (LPD) in watts per square foot.
      You can now take an important next step and compare LPD’s from room to room and building to building to determine where excess energy might be in use.




       Room 1 Name                             Main Floor                                  Area                    600 Ft2                                                                  Room 2 Name                                                                     Area      Ft2
       Room 1 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                  Room 2 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                  Total Room Wattage (W)                           Select up to 6 Light Fixture Types                                                              Total Room Wattage (W)
                        Two F40T12 4' 40W Fluorescent Lamps, M                                                                                                                                                    Select Light Fixture
       Light Type 1                                                                   88 Watts                 2                                        1,651                 W             Light Type 1                                                             Total Watts                       0             W
                        One 250W Metal Halide Lamp, Magnetic                                                                                                                                                      Select Light Fixture
       Light Type 2                                                                   295 Watts                5                                                                            Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 3                                                                   Total Watts                                          Room Lighting Power Density (LPD)                Light Type 3                                                             Total Watts            Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 4                                                                   Total Watts                                               2.75         W/ft2                          Light Type 4                                                             Total Watts                       W/ft2
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 5                                                                   Total Watts                                                                                           Light Type 5                                                             Total Watts
       Other Type : Name                                                              Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                                 : Watts



                                                                                                                          2
       Room 3 Name                                                                         Area                          Ft                                                                 Room 4 Name                                                                     Area      Ft2
       Room 3 Lighting ( Main Lighting only - Do not include task lights )                                                                                                                  Room 4 Lighting ( Main Lighting only - Do not include task lights )
       Select up to 6 Light Fixture Types                                                                                                  Total Room Wattage (W)                           Select up to 6 Light Fixture Types                                                              Total Room Wattage (W)
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 1                                                                   Total Watts                                                            0                W             Light Type 1                                                             Total Watts                       0             W
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 2                                                                   Total Watts                                                                                           Light Type 2                                                             Total Watts
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 3                                                                   Total Watts                                          Room Lighting Power Density (LPD)                Light Type 3                                                             Total Watts            Room Lighting Power Density (LPD)
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 4                                                                   Total Watts                                                            W/ft2                          Light Type 4                                                             Total Watts                       W/ft2
                        Select Light Fixture                                                                                                                                                                      Select Light Fixture
       Light Type 5                                                                   Total Watts                                                                                           Light Type 5                                                             Total Watts
       Other Type : Name                                                              Total Watts                                                                                           Other Type : Name                                                        Total Watts
                      : Watts                                                                                                                                                                                 : Watts



              HVAC/Non-Process Energy


      To determine the site's Non-Process Heating, Ventilating, and Air Conditioning (HVAC) loads and energy use, describe each building's HVAC electrical using units by entering them below. If multiple of a unit exists, either add them into the
      table as separate units or enter Motor Size as the motor's size (in hp) multiplied by the quantity.

      Non-Process HVAC is meant to include all equipment not tied to specific process operations such as general ventilation heaters, office air conditioners, restroom exhaust fans, etc.
      Do not provide process-related ventilation equipment such as odor control fans here. You can enter process equipment information on the "WTP or WWTP Energy Usage" tab.

      For each Non-Process HVAC unit select the equipment type from the dropdown list and enter an “Equipment Description.”

      Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. This information can be gathered from the equipment's nameplate or specification datasheet.
      If the site has authorized personnel capable of taking electrical measurements, enter the motors average operating current. Otherwise leave the "Average Motor Operating Current" blank and the tool will use an 80% Load Factor in its
      calculations.

      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 at the plant change, you can adjust these values.

      A summary of the HVAC and lighting information entered on the building data tabs is displayed on the top on the WTP and WWTP Energy Usage tabs. For those values to be included in the total energy use and to be displayed in the pie
      charts and summary report, you must enter the values in the Equipment Electrical Energy Inventory table (on the WTP or WWTP Energy Usage tab) as Non Process HVAC. See the instructions on that tab on how to enter this information.




                                                                                                                                             Average                                                                                                                   Estimated
                                                                                                                                                                Motor
                                                                                                                                              Motor                         Average                                   Estimated Annual       Estimated Annual          Percent of
                                                                    Equipment           Motor Size           Motor       Motor Full Load                      Operating                        Average HVAC
           System Type                Equipment Type                                                                                        Operating                     Load Factor                                    Energy Use          Operating Costs          Site Electric
                                                                    Description           (hp)             Efficiency    Amperage (FLA)                         Hours                        Electric Load (kW)
                                                                                                                                             Current                          (%)                                         (kWh/yr)                ($/Year)            Use & Cost
                                                                                                                                                             (Hours/Year)
                                                                                                                                             (Amps)                                                                                                                        (%)
                                  Fan
         Non Process HVAC                      Fan            Exhaust Fan                             2            85%              2.2                1.9           2,500         86.36%                      1.52            3,789.84                    $383.53            0.17%
                                  Fan
         Non Process HVAC                      Fan            Heater Fan                              2            85%              2.1                1.9           2,500         90.48%                      1.59            3,970.31                    $401.79            0.18%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%
                                  Select Equipment
         Non Process HVAC             Select Equipment                                                                                                                              0.00%                      0.00                 0.00                     $0.00            0.00%


                                                                                                                                            Total Building HVAC
                                                                                                                                                                                                               3.10            7,760.15                    $785.33            0.35%
EPA Energy Use Assessment Tool for Drinking Water System
 Drinking Water Systems Energy Usage

 To determine the site's electrical energy breakdown and baseline, you must describe each major piece of equipm
 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
 • 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 kilo-watts (kW) and the unit's annual op

 At each stage of data entry, the tool estimates the plant's electrical energy breakdown.
 At the bottom of the table below, the "Percent of Site Electrical Energy Identified” provides the estimate of what
 gauge how much data is left to be collected. It is ideal to have 90% or greater accounted for.

 The tool automatically generates a list of the Top 5 Electrical Energy Use Systems at the plant. That breakdown i
 Those smaller systems not in the Top 5 are combined and shown as the "Balance of Plant Identified." The electr
 is shown as "Balance of Plant Unidentified."
 As the “Percent of Site Electrical Energy Identified” gets closer to 100%, the "Balance of Plant Unidentified" decr



      Source Water                               Treatment




 If the plant's Building Lighting and HVAC (Non-Process) energy loads were entered on the Building Data tabs, th
 summarized below.
 Enter this summarized data into the Equipment Electrical Energy Inventory Table with System Type as either "No
 Load" and Equipment Type as "Other kW Load". For further instructions, see below.


Estimated Average Building Electric Loads:                                        Estimated Building Annual Energ

Total Plant Building(s) Lighting                         12.77         kW         Total Plant Building(s) Lighting
Total Plant Building(s) HVAC                              7.36         kW         Total Plant Building(s) HVAC
Total Plant Building(s) Combined                         20.13         kW         Total Plant Building(s) Combined



 Table Entry Instructions:
 1. For each piece of equipment recognized at the plant, identify and select the “System Type” and “Equipment T
 system types not listed in the list and use the "Equipment Description" field to describe the system.
 2. Enter a unique “Equipment Description” to keep track of each piece of equipment. This can be the site's ident
 3. Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. That information is u
 4. If the site has authorized personnel capable of taking electrical measurements, collect and enter the motor's a
 current, leave this measurement blank and the tool uses 75% for the unit's "Average Load Factor."
 5. Enter the unit's annual operating hours. If this information is not tracked for the unit, estimate the value. You
 6. If the piece of equipment is not motor based or if a total system load has already been identified such as for th
 "Equipment Type" dropdown list. The tool populates"N/A" in these cells: Motor Size, Motor Full Load Amperage,
 operating hours into the respective cell and electrical energy load (in kW) into the column titled “Average Electri

 Entry Results:
 3. Collect and enter each unit’s motor size, efficiency and full load amperage (FLA) ratings. That information is u
 4. If the site has authorized personnel capable of taking electrical measurements, collect and enter the motor's a
 current, leave this measurement blank and the tool uses 75% for the unit's "Average Load Factor."
 5. Enter the unit's annual operating hours. If this information is not tracked for the unit, estimate the value. You
 6. If the piece of equipment is not motor based or if a total system load has already been identified such as for th
 "Equipment Type" dropdown list. The tool populates"N/A" in these cells: Motor Size, Motor Full Load Amperage,
 operating hours into the respective cell and electrical energy load (in kW) into the column titled “Average Electri

 Entry Results:
 The tool calculates the site's Annual Electrical Energy by total Average Electric Load (kW), Estimated Annual Ene
 The tool also provides the total Estimated Percent of Site Electric Use & Cost (%) identified as compared to the s
 Any difference between what electrical energy has been identified and what has been billed is also indicated. If t
 estimated and it might be necessary to readjust the equipment loads or operating hours.
 The tool generates a pie chart of the site's top electrical energy use systems.
 If conditions at the plant change, you can adjust the entry values.
 A summary of the Electrical Energy Use Breakdown is provided on "Summary Report" tab under Equipment Inve

 Once this baseline tool is completed to reasonable accuracy, determine where the majority of energy is being us
 • Prioritizing further investigation of opportunities to reduce the energy use. Look at large demand equipment or
 equipment could save large amounts of money. Then work down to smaller items. Lighting and HVAC can be eas
 • Determining operational improvements to reduce energy use.
 • Comparing and contrasting impacts (reductions or increases) of contemplated equipment upgrades or technolo
 immediately see how much money can be saved per year.
 • Updating the table to confirm energy impacts (reductions or increases) as operational or equipment modificatio
 equipment changes.


EQUIPMENT ELECTRICAL ENERGY INVENTORY

                                                                                      Motor
                                                                         Motor Size
       System Type           Equipment Type      Equipment Description              Efficiency
                                                                           (hp)
                                                                                        (%)

Chemical Mix and Feed
 Chemical Mix and Feed     Blower Blower
                                                 Blower 1                        7     65.0 %
Chemical Mix and Feed
 Chemical Mix and Feed     BlowerBlower          Blower 2                        7     65.0 %
Decarbonation
    Decarbonation          Mixer Mixer           Decarb Mixer 1                  8     88.0 %
Low Service Pumping
 Low Service Pumping       Pump Pump             Pump1                           7     65.0 %
Low Service Pumping
 Low Service Pumping       Pump Pump             Pump2                           8     88.0 %
Clarification
        Clarification      Mixer Mixer           Rapid Mixer                     8     78.0 %
Clarification
        Clarification      Mixer Mixer           Tk Mixers Summer               7.5     9.6 %
Distribution Pumping
  Distribution Pumping     Pump Pump             HSPS                            2      1.0 %
Distribution Pumping
  Distribution Pumping     Pump Pump             HSPS                            2      1.0 %
FiltrationFiltration       Pump Pump             Backwash Pump                  75      0.9 %
FiltrationFiltration       Pump Pump             Backwash Blower                75      0.9 %
Non Process HVAC
  Non Process HVAC           Other kW Load
                           Other kW Load         Lighting                      N/A        N/A
Lighting Lighting            Other kW Load
                           Other kW Load         Building HVAC                 N/A        N/A


       Add Row
Top Energy Use Systems:

#1 DISTRIBUTION PUMPING         32.53%

#2 FILTRATION                   23.01%

#3 CLARIFICATION                13.80%

#4 NON PROCESS HVAC             4.98%

#5 LOW SERVICE PUMPING          4.72%

Balance of Plant Identified     4.57%

Balance of Plant Unidentified   16.39%
king Water Systems
                         Save and Continue            Reset Data        Return to General Info




scribe each major piece of equipment at the plant by entering information in the table below.
ating and annual operating hours.

u should start with gathering data for the following motors sizes:
 d:
 :


atts (kW) and the unit's annual operating hours.

kdown.
d” provides the estimate of what portion of the site's electrical energy use has been captured. Use that percent value to help
ccounted for.

 ms at the plant. That breakdown is listed by major system type.
nce of Plant Identified." The electrical energy that has not yet been identified

 alance of Plant Unidentified" decreases.



            Disinfection                                 Distribution




ered on the Building Data tabs, the site's Total Building Non-Process loads are

 le with System Type as either "Non-Process HVAC", "Lighting" or "Other Non Process
below.


 Estimated Building Annual Energy Use:                                   Estimated Building Annual Energy Cost:

 Total Plant Building(s) Lighting        111,888         kWh/yr          Total Plant Building(s) Lighting
 Total Plant Building(s) HVAC                64,455      kWh/yr          Total Plant Building(s) HVAC
 Total Plant Building(s) Combined        176,343         kWh/yr          Total Plant Building(s) Combined




“System Type” and “Equipment Type” from the dropdown lists. Select "Other" in the "System Type" dropdown to enter
 describe the system.
 ment. This can be the site's identification name or number.
 LA) ratings. That information is usually on the equipment's nameplate or specification datasheet.
ts, collect and enter the motor's average operating current. If the site is unable to measure the motor's typical operating
erage Load Factor."
 the unit, estimate the value. You can readjust this value later.
 ady been identified such as for the Building Lighting and HVAC systems, select “Other kW Load” in the
  Size, Motor Full Load Amperage, Average Motor Operating Current, and Load Factor. You can then enter the annual
 he column titled “Average Electric Load (kW)."
 LA) ratings. That information is usually on the equipment's nameplate or specification datasheet.
ts, collect and enter the motor's average operating current. If the site is unable to measure the motor's typical operating
erage Load Factor."
 the unit, estimate the value. You can readjust this value later.
 ady been identified such as for the Building Lighting and HVAC systems, select “Other kW Load” in the
  Size, Motor Full Load Amperage, Average Motor Operating Current, and Load Factor. You can then enter the annual
he column titled “Average Electric Load (kW)."


 Load (kW), Estimated Annual Energy Use (kWh/yr) and Estimated Annual Operating Costs ($/Yr).
%) identified as compared to the site's Annual Electrical Energy Billed.
s been billed is also indicated. If this value is positive, the site's electrical energy loads have been over
ng hours.


Report" tab under Equipment Inventory.

the majority of energy is being used. Your next steps might be as follows:
ok at large demand equipment or equipment that runs for long periods and see if a schedule reduction or more efficient
ms. Lighting and HVAC can be easy and cheap savings.

d equipment upgrades or technology changes. Enter in a higher efficiency motor or a more efficient light fixture and

erational or equipment modifications or replacements are completed. Keep the tool up to date as you make schedule or




                             Average
             Motor Full                                                                            Estimated
                              Motor      Operating                    Average        Estimated
               Load                                   Average Load                                   Annual
                            Operating      Hours                      Electric     Annual Energy
             Amperage                                  Factor (%)                                Operating Costs
                             Current      (Hrs/Yr)                   Load (kW)      Use (kWh/yr)
              (FLA)                                                                                   ($/Yr)
                             (Amps)

                    660           600           880         90.91%          7.30           6,427           $650

                    660           600           880         90.91%          7.30           6,427           $650

                    775           550         5,270         70.97%          4.81          25,364          $2,567

                    660           600         8,760         90.91%          7.30          63,979          $6,475

                    775           550         8,760         70.97%          4.81          42,161          $4,267

                    775           550         8,760         70.97%          5.43          47,566          $4,814

                    10.3           5.3        8,760         51.46%         29.99         262,707         $26,586

                    230         102.13        8,760         44.40%         69.01         604,543         $61,180

                    230          156.4        1,200         68.00%        105.68         126,820         $12,834

                      98          84.7           91         86.43%      5,199.65         473,169         $47,885

                      88          54.2           12         61.59%      3,665.97          43,992          $4,452

                    N/A           N/A         8,760        100.00%         12.77         111,865         $11,321

                    N/A           N/A         8,760        100.00%          7.36          64,474          $6,525


                     Estimated Annual WTP Electric Use & Cost           9,127.40       1,879,493        $190,205
                           Actual Annual WTP Electric Use & Cost                       2,248,000        $227,497
                          Difference Between Billed and Identified                      -368,507        -$37,293
Percent of Site Electrical Energy Identified                                 83.61%




Top Electrical Energy Use Systems
                                               #1 DISTRIBUTION PUMPING


       16%                                     #2 FILTRATION


                       32%                     #3 CLARIFICATION
 5%
5%                                             #4 NON PROCESS HVAC

5%
                                               #5 LOW SERVICE PUMPING

     14%                                       Balance of Plant Identified
                 23%
                                               Balance of Plant Unidentified
Use that percent value to help




rgy Cost:

                  $11,323        $/yr
                  $6,523         $/yr
                  $17,846        $/yr




ype" dropdown to enter


et.
motor's typical operating


d” in the
hen enter the annual
et.
motor's typical operating


d” in the
hen enter the annual




r).

en over




duction or more efficient


ient light fixture and

s you make schedule or




            Estimated Percent of
             Site Electric Use &
                  Cost (%)


                            0.29%

                            0.29%

                            1.13%

                            2.85%

                            1.88%

                            2.12%

                            11.69%

                            26.89%

                            5.64%

                            21.05%

                            1.96%

                            4.98%

                            2.87%



                            83.61%
                                                          STATEMENT OF ENERGY PERFORMANCE
                                                                                   UTILITY SUMMARY REPORT
                                                                                                                                                                   Print Summary Report                            Refresh Summary Report
                                                                                                  June 28, 2012

                                                             This document was generated using EPA’s Energy Use Assessment Tool. All information shown is from data provided by the system auditor.
                                                             Depending on the use of this report, facility owners might consider having a professional engineer verify that the underlying data are accurate.


                                     Note! If the summary looks inaccurate, click the "Refresh Summary Report" button above to refresh the tab. If the tables/graphs still do not
                                                      reflect the data entered, check your macros settings. Macros should be enabled for the report to refresh.
  UTILITY INFORMATION

                 Utility Name:     Sample Water and Wastewater Treatment Plants
                 Address:          123 Ross Road
                                   Fairfax
                                   VA - 22030
                 Plant Contact: John Smith
                 Phone Number: 762-882-8811
                 Email:            john.smith@gmail.com


                 Assessor:         Jen Denwood
                 Phone Number: 481-553-2217
                 Email:            jden@gmail.com
                 Assessment Date
                               7/12/2011


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            Site Utility Costs              % of Costs
                                                                                    (Common Units)

                                   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 ($/MGAL)                                   $438.72


GRAPHICAL UTILITY COST SUMMARY FOR 7/2010 - 6/2011



                                                                             UTILITY COST SUMMARY (MAJOR UTILITIES)


                                 25,000                                                                                                                                         140

                                                                                                                                                                                120
                                                                                                                                                                                            Water Treated (MGAL)




                                 20,000
                                                                                                                                                                                100
                      Cost ($)




                                 15,000                                                                                                                                         80

                                                                                                                                                                                60
                                 10,000
                                                                                                                                                                                40
                                  5,000
                                                                                                                                                                                20

                                     0                                                                                                                                          0



                                                                                                    Months
                                                                               Electric Cost            Natural Gas Cost               Water Treated
                                                                                                  UTILITY COST SUMMARY (ALL UTILITIES)
                                                    30,000                                                                                                                                                   140


                                                    25,000                                                                                                                                                   120




                                                                                                                                                                                                                           Water Treated (MGAL)
                                                                                                                                                                                                             100
                                                    20,000
                                                                                                                                                                                                             80
                       Cost ($)



                                                    15,000
                                                                                                                                                                                                             60
                                                    10,000
                                                                                                                                                                                                             40

                                                     5,000                                                                                                                                                   20

                                                          0                                                                                                                                                  0




                                                                                                                      Months
                                                                      Electric Cost                      Natural Gas Cost                        Alt. Energy Cost                        Water and Sewer Cost
                                                                      No. 2 Fuel Cost                    Other Cost                              Water Treated




ELECTRIC USE vs. WATER TREATED FOR 7/2010 - 6/2011



                                                                                                      Electric Use vs. Water Treated

                                                       210,000                                                                                                                                               140
                                                       205,000
                                                                                                                                                                                                             120
                                                       200,000




                                                                                                                                                                                                                                 Water Treated (MGAL)
                              Electric Use (kWh)




                                                       195,000                                                                                                                                               100
                                                       190,000
                                                       185,000                                                                                                                                               80

                                                       180,000                                                                                                                                               60
                                                       175,000
                                                       170,000                                                                                                                                               40
                                                       165,000
                                                                                                                                                                                                             20
                                                       160,000
                                                       155,000                                                                                                                                               0
                                                                      7/2010     8/2010    9/2010    10/2010   11/2010    12/2010     1/2011      2/2011     3/2011      4/2011      5/2011      6/2011
                                                     Electric Use     182,600    177,400   173,600   182,400   186,600    190,600     196,800    189,800     187,600     192,800     204,000     183,800
                                                     Water Treated       91           90     92        98       100         106        112         108        117         118         111          95



                                                                                                                          Months




ELECTRIC USE vs. COST FOR 7/2010 - 6/2011




                                                                                                               Electric Use vs. Cost

                                                       210,000                                                                                                                                                    22,000
                                                       205,000
                                                       200,000                                                                                                                                                    21,000
                                                       195,000
                               Electric Use (kWh)




                                                                                                                                                                                                                  20,000
                                                       190,000
                                                                                                                                                                                                                                            Cost ($)




                                                       185,000
                                                                                                                                                                                                                  19,000
                                                       180,000
                                                       175,000
                                                                                                                                                                                                                  18,000
                                                       170,000
                                                       165,000                                                                                                                                                    17,000
                                                       160,000
                                                       155,000                                                                                                                                                    16,000
                                                                       7/2010     8/2010    9/2010   10/2010    11/2010     12/2010     1/2011      2/2011     3/2011      4/2011       5/2011      6/2011
                                                      Electric Use    182,600    177,400   173,600   182,400    186,600     190,600    196,800     189,800     187,600     192,800     204,000     183,800
                                                      Electric Cost    19,940     18,042    17,690    18,058    17,876      18,336      18,184      19,492     19,248      19,704       20,930      19,997


                                                                                                                               Months
ELECTRIC ENERGY UTILIZATION vs. WATER TREATED FOR 7/2010 - 6/2011



                                                                                                                   Electric Utilization vs. Water Treated
                                                                                   2,500                                                                                                                                         140
                         Electric Energy Utilization (kWh/MGAL)
                                                                                                                                                                                                                                 120
                                                                                   2,000
                                                                                                                                                                                                                                 100




                                                                                                                                                                                                                                                   Water Treated (MGAL)
                                                                                   1,500
                                                                                                                                                                                                                                 80

                                                                                                                                                                                                                                 60
                                                                                   1,000

                                                                                                                                                                                                                                 40
                                                                                      500
                                                                                                                                                                                                                                 20

                                                                                         0                                                                                                                                       0
                                                                                                                              10/201      11/201        12/201
                                                                                                7/2010   8/2010   9/2010                                          1/2011   2/2011    3/2011      4/2011    5/2011     6/2011
                                                                                                                                0           0             0
                                                                  Electric Energy Utilization   2,017    1,980    1,895       1,855        1,871        1,791     1,753     1,766    1,608       1,628     1,835       1,941
                                                                  Water Treated                    91     90       92           98            100        106       112       108      117         118       111         95


                                                                                                                                                      Months




DISTRIBUTION OF ELECTRICAL ENERGY USE & COST BY MAJOR PROCESS FOR 7/2010 - 6/2011

                                                                        Top 5 Energy Use Systems                                                                                                                             Electric Energy Use Electric Energy Use                  Electric Energy
                                                                                                                                                                           Major Process/Top Energy Use Systems
                                                                                                                                                                                                                                      (%)               (kWh)                             Cost ($)
                         16%                                                                                       #1 DISTRIBUTION PUMPING                                                                                               32.53%                            731,363            $74,014
                                                                                                                                                                             #1 DISTRIBUTION PUMPING
                                                                                                                   #2 FILTRATION                                                                                                         23.01%                            517,160            $52,337
                                                                                             32%                                                                             #2 FILTRATION
                   5%                                                                                                                                                                                                                    13.80%                            310,273            $31,400
                                                                                                                   #3 CLARIFICATION
                                                                                                                                                                             #3 CLARIFICATION
                  5%                                                                                                                                                                                                                      4.98%                            111,865            $11,321
                                                                                                                   #4 NON PROCESS HVAC                                       #4 NON PROCESS HVAC
                  5%                                                                                                                                                                                                                      4.72%                            106,140            $10,741
                                                                                                                   #5 LOW SERVICE PUMPING                                    #5 LOW SERVICE PUMPING
                                                                                                                                                                                                                                          4.57%                            102,692            $10,392
                                                                                                                   Balance of Plant Identified                               Balance of Plant Identified
                                                                                                                                                                                                                                         16.39%                            368,507            $37,293
                       14%                                                                                         Balance of Plant Unidentified
                                                                                                                                                                             Balance of Plant Unidentified
                                                                                                                                                                                                                                        100.00%                           2,248,000          $227,497
                                                                                  23%                                                                                        Total




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 Use         Electric Energy
                                                                     Systems                                           (%)                                                          (%)                   (kWh)                    Cost ($)


                                                                     Anaerobic Digestion
                                                                                                                                        88                       Medium                  2.48%                      55,696             $5,636.40
                                                                          Mixer - Gas Mixer
                                                                                                                                       N/A                          N/A                  0.80%                      18,000             $1,821.60
                                                                          Other kW Load - Mixer Heater
                                                                                                                                        85                       Medium                  0.56%                      12,581             $1,273.16
                                                                          Pump - Ht Wtr Pumps
                                                                                                                                        85                       Medium                  0.62%                      13,979             $1,414.63
                                                                          Pump - Sludge Ht Wtr Pumps
                                                                                                                                        85                       Medium                  1.43%                      32,034             $3,241.85
                                                                          Pump - Sludge Recir Pump
                                                                     Effluent Pumping/Storage
                                                                                                                                        91                         High                  0.91%                      20,363             $2,060.77
                                                                          Pump - Effluent Pumps
                                                                     Fixed Film Treatment
                                                                                                                                        91                         High                 10.62%                    238,639             $24,150.28
                                                                          Pump - R.Tower Pumps
                                                                     Influent Pumping
                                                                                                                                        88                       Medium                  3.77%                      84,667             $8,568.27
                                                                          Pump - Infl Pump Station
                                                                     Internal Plant Pumping
                                                                                                                                       N/A                          N/A                  0.97%                      21,900             $2,216.28
                                                                          Other kW Load -
                                                                     Lighting
                                                                                                                                       N/A                          N/A                  4.98%                    111,865             $11,320.75
                                                                          Other kW Load - All Site Lighting
                                                                     Non Process HVAC
                                                                                                                                       N/A                          N/A                  2.87%                      64,474             $6,524.72
                                                                          Other kW Load - All Site HVAC
                                                                     Primary Treatment
                                                                                                                                        88                       Medium                  2.14%                      48,093             $4,866.99
                                                                          Blower - Channel Blower
                                                                                                                                        89                       Medium                  1.68%                      37,861             $3,831.49
                                                                          Blower - Grit Blowers
                                                                                                                                        83                          Low                  0.72%                      16,197             $1,639.12
                                                                          Pump - Sample Pump
                                                                                                                                       87.5                      Medium                  0.35%                       7,780              $787.31
                                                                          Pump - Sludge Pump
                                                                     Secondary Treatment
                                                                                                                                        91                         High                 52.53%                1,180,921              $119,509.12
                                                                          Blower - Secondy Blowers
                                                                                                                                        91                         High                  2.70%                      60,664             $6,139.17
                                                                          Blower - Secondy Blowers
                                                                                                                                        88                       Medium                  5.03%                    113,159             $11,451.73
                                                                          Pump - RAS Pumps 1-4
                                                                                                                                        86                       Medium                  4.12%                      92,610             $9,372.15
                                                                          Pump - RAS Pumps 5-7
                                                                                                                               86                  Medium              0.21%              4,749                  $480.62
                                    Pump - WAS Pumps


                                                                                                                                      Estimated Annual Electric Use & Cost            1,879,493              $190,205

                                                                                                                                          Actual Annual Electric Use & Cost           2,248,000              $227,497

                                                                                                                                    Difference Between Billed and Identified           -368,507                 -$37,293

                                                                                                                               Percent of Site Electrical Energy Identified                                      83.61%




ENERGY TRENDS FOR 2007 - 2011


ELECTRIC USE vs. WATER TREATED FOR 2007 - 2011



                                                                                                                   Electric Use vs. Water Treated

                                                                                                2,500,000                                                                                               1,270
                                                                                                                                                                                                        1,260




                                                                                                                                                                                                                          Water Treated (MGAL/Yr)
                                        Electric Use (kWh)




                                                                                                2,000,000                                                                                               1,250
                                                                                                                                                                                                        1,240
                                                                                                1,500,000                                                                                               1,230
                                                                                                                                                                                                        1,220
                                                                                                1,000,000                                                                                               1,210
                                                                                                                                                                                                        1,200
                                                                                                  500,000                                                                                               1,190
                                                                                                                                                                                                        1,180
                                                                                                         0                                                                                              1,170
                                                                                                                 2007            2008                2009             2010          2010 - 2011
                                                                                              Electric Use     1,815,000      1,880,400            1,920,600        2,062,800        2,248,000
                                                                                              Water Treated      1,204          1,264                1,209            1,223            1,237


                                                                                                                                            Year




ELECTRIC USE vs. COST FOR 2007 - 2011


                                                                                                                     Electric Use vs. Electric Cost

                                                                                               2,500,000                                                                                          $250,000


                                                                                               2,000,000                                                                                          $200,000
                                                 Electric Use (kWh)




                                                                                                                                                                                                                     Cost ($)
                                                                                               1,500,000                                                                                          $150,000


                                                                                               1,000,000                                                                                          $100,000


                                                                                                 500,000                                                                                          $50,000


                                                                                                        0                                                                                         $0
                                                                                                                2007           2008                2009           2010          2010 - 2011
                                                                                              Electric Use    1,815,000      1,880,400           1,920,600      2,062,800        2,248,000
                                                                                              Electric Cost   $139,003       $163,036            $178,036       $210,429         $227,497

                                                                                                                                          Year



NATURAL GAS USE vs. COST FOR 2007 - 2011


                                                                                                                Natural Gas Use vs. Natural Gas Cost

                                                                                                  60,000                                                                                               $90,000
                                                                                                                                                                                                       $80,000
                                                                                                  50,000
                                                                      Natural Gas Use (CCF)




                                                                                                                                                                                                       $70,000
                                                                                                  40,000                                                                                               $60,000
                                                                                                                                                                                                                          Cost ($)




                                                                                                                                                                                                       $50,000
                                                                                                  30,000
                                                                                                                                                                                                       $40,000
                                                                                                  20,000                                                                                               $30,000
                                                                                                                                                                                                       $20,000
                                                                                                  10,000
                                                                                                                                                                                                       $10,000
                                                                                                        0                                                                                              $0
                                                                                                                2007           2008                  2009           2010          2010 - 2011
                                                                                   Natural Gas Use             45,918         48,749                41,091         33,050           31,683
                                                                                   Natural Gas Cost           $49,713         $58,739              $79,188         $36,005          $36,132


                                                                                                                                               Year




UTILITY COST SUMMARY FOR 2007 - 2011
                                      Utility Costs vs. Water Treated (Major Utilities)
                $250,000                                                                                       1,270
                                                                                                               1,260
                $200,000                                                                                       1,250




                                                                                                                         Water Treated (MGAL)
                                                                                                               1,240




 Cost ($)
                $150,000                                                                                       1,230
                                                                                                               1,220
                $100,000                                                                                       1,210
                                                                                                               1,200
                 $50,000                                                                                       1,190
                                                                                                               1,180
                     $0                                                                                        1,170
                                  2007            2008             2009             2010       2010 - 2011
   Electric Cost                $139,003        $163,036         $178,036         $210,429      $227,497
   Natural Gas Cost              $49,713        $58,739          $79,188           $36,005       $36,132
   Water Treated                  1,204          1,264            1,209             1,223         1,237

                                                                Year




                                       Utility Costs vs. Water Treated (All Utilities)

                   $250,000                                                                                      1,270
                                                                                                                 1,260
                   $200,000                                                                                      1,250




                                                                                                                                   Water Treated (MGAL)
                                                                                                                 1,240
                   $150,000                                                                                      1,230
     Cost ($)




                                                                                                                 1,220
                   $100,000                                                                                      1,210
                                                                                                                 1,200
                    $50,000                                                                                      1,190
                                                                                                                 1,180
                           $0                                                                                    1,170
                                     2007            2008             2009            2010       2010 - 2011
Electric Cost                      $139,003        $163,036         $178,036        $210,429      $227,497
Natural Gas Cost                   $49,713          $58,739          $79,188         $36,005       $36,132
Alt. Energy Cost                      $0               $0               $0           $23,237       $47,186
Water and Sewer Cost               $99,284         $131,370         $143,029        $153,806      $156,967
No. 2 Fuel Cost                       $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

                                                                Year

								
To top