ANNUAL 2015 To: 2009
Year
ANNUAL - SYSTEM TOTAL GPCD
0
Monthly - Single-Family Residential GPCD
Sector Specific Population
Monthly - Multi-Family Residential GPCD Sector Specific Population
Return to Instructions
NMOSE GPCD Calculator v2.02
Bernalillo
Instructions
2015 TO 2009
TABLE 5.1 TABLE 5.3 TABLE 5.4 TABLE 5.5
ICI WATER CONSUMPTION (Gallons (US))
Year JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
2015 N/A N/A
2014 8,177,650 9,382,550 8,851,170 8,878,770 11,356,590 14,025,330 13,619,130 14,039,950 10,178,710 10,094,880 6,903,610 6,131,600 36.42 121,639,940
2013 4,211,440 5,355,300 7,410,820 7,174,300 15,140,180 15,303,910 7,003,030 11,285,770 9,998,970 6,859,900 7,694,970 6,703,360 31.36 104,141,950
2012 5,950,260 15,651,860 13,945,810 11,040,180 13,059,310 13,441,260 11,833,760 13,125,640 11,718,060 9,290,530 6,044,470 6,379,520 39.80 131,480,660
2011 7,180,040 6,341,541 11,002,731 10,852,780 16,056,410 14,578,000 16,515,020 13,280,420 13,642,220 11,157,400 7,661,450 7,550,160 42.63 135,818,172
2010 6,477,610 8,188,840 6,362,030 8,207,650 11,882,980 15,657,860 11,050,560 10,564,890 13,622,860 10,359,580 6,197,570 7,652,500 38.03 116,224,930
2009 N/A N/A
TABLE 5.2 TABLE 5.6 TABLE 5.7 TABLE 5.8
OTHER METERED (Gallons (US))
Year JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
2015 25,000 #VALUE! 25,000
2014 N/A N/A
2013 N/A N/A
2012 N/A N/A
2011 N/A N/A
2010 N/A N/A
2009 N/A N/A
COMMENTS:
Other includes water use for fire training and fire fighting use and line flushing
ICI ANNUAL CALCULATED
OTHER ANNUAL CALCULATED
ANNUAL DATA 5. INDUSTRIAL, COMMERCIAL & INSTITUTIONAL (ICI) AND OTHER METERED
OTHER ANNUAL CONSUMPTION
OTHER METERED GPCD
MONTHLY DATA
ICI ANNUAL
CONSUMPTION ICI GPCD
DATA INPUT SHEET InstructionsReturn to
Info
NMOSE GPCD Calculator v2.02
9. Annual Reporting Performance
Overall Annual GPCD (based on Total Population)
SFR-SystemTotal MFR-SystemTotal ICI OtherMetered Non-RevenueWater TotalSupplied Non-RevenueVolumeMillionGallons(US) SFR-SystemTotal MFR-SystemTotal ICI OtherMetered Reuse Non-RevenueWater
Year 2015 N/A N/A N/A #VALUE! Not Graphed #VALUE!
On Graph? Yes Yes Yes Yes Yes 2014 61 3 36 N/A Not Graphed 20
2015 N/A N/A N/A ###### #VALUE! #VALUE! (0.03) 2013 58 4 31 N/A Not Graphed 35
2014 60.54 3.07 36.42 N/A 19.85 119.89 66.32 2012 68 5 40 N/A Not Graphed 20
2013 57.74 3.71 31.36 N/A 34.80 127.60 115.56 2011 70 5 43 N/A Not Graphed 26
2012 68.22 4.83 39.80 N/A 20.10 132.95 66.42 2010 71 6 38 N/A Not Graphed 37
2011 70.05 5.23 42.63 N/A 25.85 143.76 82.36 2009 N/A N/A N/A N/A Not Graphed #VALUE!
2010 70.55 5.75 38.03 N/A 37.27 151.59 113.90
2009 N/A N/A N/A N/A #VALUE! #VALUE!
Annual Analysis of GPCD - Viewer (based on Total Population)
SFR - System Total MFR - System Total ICI Other Metered Non-Revenue Water Info
NMOSE GPCD Calculator v2.02
10. Monthly Reporting Performance
2014
Choose Sector Monthly GPCD
Single-FamilyResidential Multi-FamilyResidential ICI OtherMetered Non-Revenue Single-FamilyResidential Multi-FamilyResidential ICI OtherMetered #REF! Non-Revenue
Month GPCD GPCD GPCD GPCD GPCD January 53 Single-Family Residential2015
February 57 Multi-Family Residential2014
JAN 52.98 30.55 28.83 0.00 7.73 31March 60 Yes ICI 2013
FEB 56.83 36.55 36.62 0.00 0.11 28April 70 No Other Metered 2012
MAR 60.31 31.22 31.20 0.00 18.67 31May 80 Reuse 2011
APR 70.15 50.80 32.34 0.00 18.97 30June 99 Non-Revenue 2010
MAY 79.82 53.26 40.03 0.00 12.37 31July 85 2009
JUN 98.88 69.51 51.09 0.00 31.12 30August 81
JUL 84.88 63.41 48.01 0.00 27.25 31September 71
AUG 81.50 39.45 49.49 0.00 14.30 31October 66
SEP 70.82 38.67 37.07 0.00 35.82 30November 56
OCT 65.77 38.72 35.58 0.00 26.04 31December 53
NOV 55.73 30.29 25.15 0.00 25.14 30
DEC 53.48 30.41 21.61 0.00 19.84 31
to
2015 2009
Choose Year for Monthly Analysis
Single-Family Residential
January February March April May June July August September October November December
SectorGPCD
Monthly Analysis of GPCD - Viewer (based on sector-specific population)
Single-Family Residential Multi-Family Residential ICI Other Metered Non-Revenue
Return to Instructions
NMOSE GPCD Calculator v2.02
Item Name
Active Connections
Annual Multi-Family Residential GPCD Calculation
Annual Single Family Residential GPCD Calculation
Billed Water Consumption (Multi-Family Residential)
Billed Water Consumption (Single-Family Residential)
Calculated Growth Rate
Census Data
Converter
Gallons (US) = 0.134 Cubic Feet
Exported Water
GPCD
General Information
Graphing Results
Imported Water
Inactive and Zero Connections
NMOSE GPCD Software: Definitions v2.04©
Description
The MFR GPCD is Annual MF Calculation (4.6) divided by the annual MFR Population (4.9).
This is the total billed consumption for Multi-Family Residential uses only. Provide the amount of water used (gallons) for multi-family residential connections by month in Table 4.1, or by year in Table 4.5. If multi-family residential is not available as a separate category, provide an explanation in the Comments Box and include usage in the Industrial, Commercial and Institutional Table 5.1 or Other Metered Table 5.2 on Sheet 5.
The user may develop a GPCD Analysis based on one of two input unit selections:
1) Gallons (US) 2) Cubic feet
Please select the units from the instructions worksheet. An interactive unit converter is also provided below. Input volume in first box below and select units to be converted.
The SFR GPCD is Annual SFR Calculation (3.7) divided by the annual SFR Population average (3.13).
This is the total billed consumption for Single-Family residential uses only.
The calculated growth rate is a calculation developed to normalize the data to the growth in the utility. The growth is determined by evaluating the percentage change in the number of connections within the utility on an annual basis, provided in Table 3.9 Average Connections Calculated. If there are no more than one years’ data, then this will not be calculated. This Table is for the utilities use in checking the growth percentage calculated against their own estimates. It is also used in Table 4.8 Number of (Multi-Family) Units if only the current number of multi-family units can be provided.
Enter all water imported from other systems. This will include any retail contracts with other drinking water suppliers where this utility purchases water from another utility and is not the permit holder.
The inactive and zero connections are recorded in Table 3.3 so that unused single family residential connections will be removed from the calculation of single family population when Total Units is chosen from the drop down list in Table 3.2.
1
All active Single Family Residential connections within the utility. Connections that are not occupied or show zero activity are not counted in this category.
The Census data is used to standardize the calculation of population by utilizing numbers of people per household. It also records information on the vacancy rate within each city which enables calculation of the number of households actually being used.
There is a link to a pdf document in Definitions showing the user how to find and record the relevant data.
Datasets will automatically be graphed when using the graphing data tools in both the Annual and Monthly Performance worksheets. For example, choosing the year and the use sector from the purple dropdown boxes will allow these variables to be graphed.
Gallons per capita per day (GPCD) is a method utilized internationally to measure water use by drinking water suppliers. It is most commonly used to describe historical and current water uses, providing a baseline of water use that is not as susceptible to changes in population. GPCD is also used for planning purposes, allowing estimates of future demand requirements based on localized population projections. More
sophisticated planning efforts utilize GPCD to determine conservation potential, track the results of program implementation, and calculate projections based on conservation adjusted GPCD.
The white boxes are data entry cells and are used for inputting data. All other cells except dropdown menus (purple boxes) are protected for the user’s benefit to stop any overwriting of formulas and calculated cells. The green boxes are values that have been calculated based on inputs.
Enter all water exported from the system. This will include any pass-through arrangements or wholesale contracts to other drinking water suppliers, where the reporting utility is the water rights permit holder.
Back to Instructions
NMOSE GPCD Calculator v2.02 1
Industrial, Commercial and Institutional (ICI)
Single Family Residential Connections
Single Family Residential Population
Size of Average Household
Total Connections
System Total GPCD
Total Population
Vacant Single-Family Residential Connections
How to find the data required for Census section
This is a calculated field using either i) the average of the monthly vacant SFR connections, if monthly data are available or ii) an estimated value based on the Census data vacancy rate multiplied by the number of Total SFR connections. When Total Connections is chosen in Table 3.2, vacant single family residential connections are subtracted from Total Connections prior to calculating a population (based on household size) and a single family GPCD.
SFR Connection is a stand alone or independently metered housing unit. The number used in the Calculator can be Total Connections or Active Connections only.
All active and inactive Single Family Residential connections within the utility.
The System Total GPCD is calculated by dividing the quantity of Total Water Diverted (plus imports minus exports) by the System Total Population
Single Family Population (3.13) is calculated from number of active connections times size of average household (3.12). It can be calculated monthly or annually depending on the data provided. If Total Connections is chosen (3.2), then inactive connections are subtracted prior to multiplying by size of average household (3.12). If Active Connections is chosen (3.2), then number of connections are multiplied by size of average household (3.12) without any subtractions.
The Total Population estimate is the sum of the single-family population + multi-family population + group quarters population.
This Table is determined from the US Census data in Table 2.1, Sheet 2. This data is used to determine a total single-family population and total multi-family population for both the monthly and annual data (Tables 3.4 and 3.13, Tables 4.3 and 4.9 respectively).
Multi-family population is calculated from number of MFR units in the Annual Unit Calculation (4.8) minus Vacant MFR Connections (4.10). That number is then multiplied by Average Size of Occupied Housing Units from the US Census (2.1).
Reuse, or Recycled water is former wastewater (sewage) that has been treated to remove solids and certain impurities and reused by a water supplier. In most locations, it is only intended to be used for nonpotable uses, such as irrigation, and dust control.
This data is not included in any other calculation. It is provided as a tracking tool for the user.
Includes industrial properties, such as manufacturing, commercial properties such as restaurants, shopping malls, and institutional customers such as schools, universities and prisons.
Non-revenue water is all the water the utility diverts and/or produces, but does not get paid for. Non-revenue water includes apparent losses such as meter inaccuracies, theft, and database errors, real losses such as leaks. It also includes unbilled authorized uses such as fire-fighting, line flushing and disinfection. The Calculator does not provide data entry for unmetered billed water. This might include bulk sales or monthly fees not based on usage. The non-revenue water in the Calculator includes all water that is not metered.
A multifamily unit is living units in an apartment complex, duplexes, triplexes, trailer parks, and condo or town houses that have multiple units serviced by a single connection. They are not counted in the single-family residential category.
All categories of billed metered use that is not otherwise classified in SFR, MFR or ICI. This provides the user the opportunity to track alternative categories. Examples included irrigation only, stand pipes, and fire hydrant/construction meters.
Everything not included in SFR, MFR, ICI or Other will end up in non-revenue water.
Find
NMOSE GPCD Calculator v2.02 2
www.census.gov click on [Census 2000]
Click on [Summary File 1]
Click on [Access to all tables and maps in American FactFinder]
NMOSE GPCD Calculator v2.02 3
Click on [Detailed tables]
Click on the dropdown boxes and Select [Place]
When “Select a State” box appears Select [New Mexico]
Select Geographic area from drop down list that is the closest description of your service area Add this to the base box as shown below
NMOSE GPCD Calculator v2.02 4
Click [Next]
Add boxes P37, H3, and H12 to the base box by highlighting them and then click [Add]
Once all the tables show in the base box click [Show Result]
Transfer results to spreadsheet
END Beginning of
Section Beginning of
Section
NMOSE GPCD Calculator v2.02 5
W:\CCJOBS\746 -Bernalillo Water Conservation Plan\Draft Conservation Plan\Appendices\Appendix D\LWA - Bernalillo - Appendix D - 5-15.docx 1
Appendix D. Summary of Data Results and Analysis for AWWA Water Audit and GPCD Calculator AWWA Water Audit
2.1.1 Performance Indicators a. Financial
b. Operational Efficiency
Performance indicators are summarized in the 2014 AWWA Audit in Appendix A.
2.1.2 Data Validity Score.
The AWWA Audit calculates the Data Validity Score at 65.
2.1.3 Priority Areas for Attention
The AWWA Audit indicates that priority areas for attention are water from own sources, customer metering inaccuracies and variable production cost. However, based upon additional information from the Public Works Director and the Town’s water resources consultant, the primary area of concern are the number of water leaks and breaks in major distribution lines.
GPCD Calculator 2.2.1 Period of Study
The Town converted to a new water billing system in 2009 and was unable to track use in any meaningful way during that year. The GPCD Calculator, which contains data from 2010-2014, is in Appendix C. This calculator was prepared and is maintained by the Town’s water resources consultant, Lee Wilson and Associates, Inc.
2.2.2 Average Size of Household
The U.S. Census estimates that there are 2.65 persons per household in the Town.
2.2.3 Annual Single-Family Residential (SFR) Gallons per Capita per Day (GPCD)
Table 3.14 of the GPCD Calculator contains a summary of SFR GPCD from 2010-2014. In 2014, SFR GPCD was 69.37 GPCD.
2.2.4 Monthly SFR GPCD
Table D.1 contains a breakdown of 2014 SFR GPCD by month.
2.2.5 Estimated SFR Indoor Water Use
SFR water use in January and December of 2014 averaged 13.139 million gallons per month.
Winter use is assumed to represent indoor use. Thus, indoor SFR use in 2014 was 157.670 million gallons or almost 484 AFY.
2.2.6 Estimated SFR Outdoor Water Use
In 2014, total SFR water use was 202.234 million gallons. The difference between total use and indoor use of 157.670 million gallons is 44.564 million gallons or 136.8 AFY.
W:\CCJOBS\746 -Bernalillo Water Conservation Plan\Draft Conservation Plan\Appendices\Appendix D\LWA - Bernalillo - Appendix D - 5-15.docx 2
2.2.7 Annual Multi-Family Residential (MFR) GPCD
Table 4.11 of the GPCD Calculator contains a summary of MFR GPCD from 2010-2014. In 2014, the MFR GPCD was 42.84 GPCD.
2.2.8 Estimated MFR Indoor Water Use
MFR water use in January and December of 2014 averaged 626,320 gallons per month. Winter use is assumed to represent indoor use. Thus, indoor MFR use in 2014 was 7.516 million gallons or 23.1 AFY.
2.2.9 Estimated MFR Outdoor Water Use
In 2014, total MFR use was 10.264 million gallons. The difference between total use and indoor use of 7.516 million gallons is 2.748 million gallons or 8.4 AFY.
2.2.10 Monthly MFR GPCD
Table D.2 contains a breakdown of 2014 MFR GPCD by month.
2.2.11 Industrial, Commercial, Institutional (ICI) and Other Metered
ICI water use includes municipal users. The largest commercial users are the Sandoval County Detention Center and both meters associated with the Wal-Mart Superstore. There are two laundromats and one car wash that use in excess of 200,000 gallons per month, and four hotels that average use of more than 100,000 gallons per month. During peak summer months, five municipal parks and related recreational areas use in excess of 500,000 gallons per month.
2.2.12 Annual System Total GPCD
Tab 9 of the GPCD Calculator contains total GPCD by year. Total per-capita demand has decreased from 151 GPCD in 2010 to 119 GPCD in 2014, as shown in Figure D.1 Yearly System GPCD 2010-2014.
2.2.13 Monthly System Total GPCD
Tab 10 of the GPCD Calculator contains a breakdown of total GPCD by month for 2014. Figure D.2 shows 2014 Water Use by Month, along with a breakdown of use by category. Figure D.3 shows 2014 Water Use by Type and identifies the percentage of total use by each water use sector.
2.2.14 Non-Revenue Water
Tab 9 of the GPCD Calculator contains the amount of non-revenue water by year. It shows that non-revenue water has decreased from 37 GPCD in 2010 to 20 GPCD in 2014. Figure D.4 Non-Revenue Water 2010-2014 shows this decline in graphic form
W:\CCJOBS\746 Bernalillo Water Conservation Plan\charts.xlsx 151
144
133
128
120
0 20 40 60 80 100 120 140 160
2010 2011 2012 2013 2014
SystemGPCD
Year
Yearly System GPCD 2010 2014 Figure D.1.
W:\CCJOBS\746 Bernalillo Water Conservation Plan\charts.xlsx 0
10,000,000 20,000,000 30,000,000 40,000,000 50,000,000 60,000,000
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC