{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["1. Instructions and Notations","2. Census Data","3. Single-family","4. Multi-family","5. ICI & Other Metered","6. Reuse","7. Total Diverted","8. Reported Data","9. Annual Performance","10. Monthly Performance","11. Definition","Sheet4","Sheet2","Sheet3","Sheet1"],"not_rendered":{"charts":7,"images":8,"macros":1,"external_links":0,"defined_names":9,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Instructions and Notations","index":0,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[62,3,62,12],[46,3,46,12],[32,11,32,12],[32,9,32,10],[60,3,60,12],[58,3,58,12],[56,3,56,12],[54,3,54,12],[37,4,37,5],[48,3,48,12],[52,3,52,12],[50,3,50,12],[1,1,8,13],[44,3,44,12],[42,3,42,12],[40,3,40,12],[15,2,15,12],[10,2,11,12],[27,8,27,11],[32,5,32,8],[18,2,22,2],[12,2,12,12],[27,3,27,5]]}
[]
[null,"Gallons per Capita - v2.07"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This spreadsheet-based GPCD calculator is designed to help quantify and track water uses associated with water distribution systems. The spreadsheet contains several separate worksheets. Sheets can be accessed using the tabs towards the bottom of the screen, or by clicking the buttons on the left below. Descriptions of each sheet are also given below.  "]
[]
[null,null,"It should be noted that all the recorded data should be from actual metered results and should not include any estimates."]
[]
[]
[]
[null,null,null,null,"Value to be entered by user"]
[]
[null,null,"THE FOLLOWING KEY APPLIES THROUGHOUT:",null,"Dropdown box, pick from list",null,null,null,"Look for the following boxes that provide additional information "]
[]
[null,null,null,null,"Value calculated based on input data ",null,null,null,null,"Instructions"]
[]
[null,null,null,null,"No longer available for input"]
[]
[]
[null,null,"Please begin by providing the following information, then proceed through each sheet:"]
[]
[null,null,"   NAME OF CITY OR UTILITY:",null,null,null,null,null,"New Mexico"]
[]
[]
[null,null,"   REPORTING YEARS:","Enter the most recent reporting year: ",null,null,null,"Data can be entered back to: ",{"$f":"IF(E31=\"\",\"\",E31-6)","v":""}]
[]
[null,null,"   NAME OF CONTACT PERSON:",null,"E-MAIL:",null,null,null,null,"TELEPHONE:"]
[null,null,null,null,null,null,null,null,null,null,"Ext."]
[]
[]
[]
[null,null,"   SELECT THE REPORTING UNITS FOR VOLUME DATA:",null,"Choose units...",null,null,null,null,null,"For unit converter click here:"]
[]
[]
[null,null,null,"This sheet"]
[]
[null,null,null,"Census data and the portal to get the data from the Census website"]
[]
[null,null,null,"Single-Family residential gallons and population"]
[]
[null,null,null,"Multi-Family residential gallons and population"]
[]
[null,null,null,"Other data including Commercial, Industrial and Institutional [1.3] and Other metered [1.4] categories"]
[]
[null,null,null,"Data related to water reuse projects"]
[]
[null,null,null,"Total Production and Diverted Water"]
[]
[null,null,null,"The calculated data graphical review of most common performance indicators"]
[]
[null,null,null,"The calculated data graphical review of annual performance indicators"]
[]
[null,null,null,"The calculated data graphical review of monthly performance indicators"]
[]
[null,null,null,"Use this sheet to understand terms used in the audit process"]
[]
[null,null,null,"All parties reserve the right to validate the data recorded in this document. This does not bind the OSE or the Utility to the results. It is a tool used for planning purposes."]
[]
[null,null,null,null,null,null,null,"If you have questions or comments regarding the software please contact us at:","waternm@state.nm.us"]

{"sheet":"2. Census Data","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,3,1,6],[2,3,2,6],[24,0,28,7]]}
["Census Information Data Table 2.1"]
[null,null,null,""]
[]
[null,null,null,{"$f":"'1. Instructions and Notations'!E31","v":0},"TO",{"$f":"'1. Instructions and Notations'!I31","v":""},{"$f":"'1. Instructions and Notations'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"               OR","Use the most recent census data"]
[]
[]
[]
[null,"DATA"]
[null,"US Census Table","Description",null,"INPUT"]
[null,"DP-1","Profile of General Population and Housing Characteristics","Census Year  "]
[null,"Subject"]
[null,"Relationship","In group quarters","Total"]
[null,"Housing Occupancy","Total housing units","Total"]
[null,null,"Occupied housing units"]
[null,null,"Vacant housing units "]
[null,"Households by Type","Average household size","Total"]
[]
[null,null,"Formula: Household Size = Total Population / Total Number of Housing Units"]
[]
[null,null,"Vacancy Rate %",null,{"$f":"IF(OR(E16=\"\",E14=\"\"),\"\",E16/E14)","v":""}]
[]
[]
["COMMENTS:"]

{"sheet":"3. Single-family","index":2,"n_rows":87,"n_cols":34,"rows_kept":87,"cut":false,"hidden":false,"merged":[[64,18,64,19],[2,5,4,11],[24,19,25,19],[23,4,23,5],[10,16,10,20],[10,0,10,14],[13,17,14,17],[1,1,2,2],[24,1,24,3],[70,1,73,13],[35,33,36,33],[13,19,14,19],[20,33,21,33],[24,17,25,17],[46,19,47,19],[46,17,47,17],[35,17,36,17],[35,19,36,19],[59,18,60,19],[65,18,65,19],[66,18,66,19],[67,18,67,19],[61,18,61,19],[62,18,62,19],[63,18,63,19]]}
[]
[null,"DATA INPUT SHEET"]
[null,null,null,null,null,"3. SINGLE-FAMILY RESIDENTIAL (SFR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E24=\"Total Connections\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 = Active Connections"]
[null,null,{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""}]
[null,"Instructions"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 = Total Connections"]
["MONTHLY DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL DATA"]
[]
[null,"TABLE 3.1",null,null,{"$f":"IF('1. Instructions and Notations'!$E$38=\"Choose units...\",\"        First select reporting units for volume data on the instructions worksheet\",\"\")","v":"        First select reporting units for volume data on the instructions worksheet"},null,null,null,null,null,null,{"$f":"'1. Instructions and Notations'!E31","v":0},"TO",{"$f":"'1. Instructions and Notations'!I31","v":""},null,null,null,"TABLE 3.6",null,"TABLE 3.7"]
[null,{"$f":"\"SFR BILLED WATER CONSUMPTION (\"&'1. Instructions and Notations'!E38&\")\"","v":"SFR BILLED WATER CONSUMPTION (Choose units...)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL CONSUMPTION",null,"ANNUAL CALCULATION"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"IF('1. Instructions and Notations'!E31=0,\"\",'1. Instructions and Notations'!E31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W16=1,SUM(C16:N16),IF(R16=0,\"N/A\",R16))","v":"N/A"},null,null,{"$f":"IF(OR(C16=0,D16=0,E16=0,F16=0,G16=0,H16=0,I16=0,J16=0,K16=0,L16=0,M16=0,N16=0),0,1)","v":0}]
[null,{"$f":"IF(B16=\"\",\"\",B16-1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0,null,null,null,null,null,null,null,null,null,null,"CENSUS VACANCY RATE"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('3. Single-family'!$R$38:$R$43)=0,'2. Census Data'!$E$16,('2. Census Data'!$E$16+('2. Census Data'!$E$16*((B38-'2. Census Data'!$E$11)*(AVERAGE('3. Single-family'!$R$38:$R$43))))))","v":0}]
[null,"TABLE 3.2",null,null,"Choose Connections Type….",null,{"$f":"IF(E24=\"Choose Connections Type….\",UPPER(\"    Use Dropdown box to select the connections data you wish to enter\"),\"    You have chosen to enter \"&E24&\", enter the monthly values below,\")","v":"    USE DROPDOWN BOX TO SELECT THE CONNECTIONS DATA YOU WISH TO ENTER"},null,null,null,null,null,null,null,null,null,null,"TABLE 3.8",null,"TABLE 3.9",null,null,{"$f":"IF(E24=\"Choose Connections Type….\",1,IF(E24=\"Total Connections\",2,3))","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('3. Single-family'!$R$38:$R$43)=0,'2. Census Data'!$E$16,('2. Census Data'!$E$16+('2. Census Data'!$E$16*((B39-'2. Census Data'!$E$11)*(AVERAGE('3. Single-family'!$R$38:$R$43))))))","v":0}]
[null,"NUMBER OF SFR CONNECTIONS (Monthly)",null,null,null,null,{"$f":"IF(E24=\"Choose Connections Type….\",\"\",\"     or enter annual values in table 3.8  Check message above Table 3.3 to see if additional data is required.\")","v":""},null,null,null,null,null,null,null,null,null,null,"AVG. ANNUAL CONNECTIONS",null,"AVG CONN. CALCULATION",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('3. Single-family'!$R$38:$R$43)=0,'2. Census Data'!$E$16,('2. Census Data'!$E$16+('2. Census Data'!$E$16*((B40-'2. Census Data'!$E$11)*(AVERAGE('3. Single-family'!$R$38:$R$43))))))","v":0}]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('3. Single-family'!$R$38:$R$43)=0,'2. Census Data'!$E$16,('2. Census Data'!$E$16+('2. Census Data'!$E$16*((B41-'2. Census Data'!$E$11)*(AVERAGE('3. Single-family'!$R$38:$R$43))))))","v":0}]
[null,{"$f":"B16","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($W$24=1,\"N/A\",IF(W27=1,AVERAGE(C27:N27),IF(R27=0,\"N/A\",R27)))","v":"N/A"},null,null,{"$f":"IF(OR(C27=0,D27=0,E27=0,F27=0,G27=0,H27=0,I27=0,J27=0,K27=0,L27=0,M27=0,N27=0),0,1)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('3. Single-family'!$R$38:$R$43)=0,'2. Census Data'!$E$16,('2. Census Data'!$E$16+('2. Census Data'!$E$16*((B42-'2. Census Data'!$E$11)*(AVERAGE('3. Single-family'!$R$38:$R$43))))))","v":0}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($W$24=1,\"N/A\",IF(W28=1,AVERAGE(C28:N28),IF(R28=0,\"N/A\",R28)))","v":"N/A"},null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('3. Single-family'!$R$38:$R$43)=0,'2. Census Data'!$E$16,('2. Census Data'!$E$16+('2. Census Data'!$E$16*((B43-'2. Census Data'!$E$11)*(AVERAGE('3. Single-family'!$R$38:$R$43))))))","v":0}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('3. Single-family'!$R$38:$R$43)=0,'2. Census Data'!$E$16,('2. Census Data'!$E$16+('2. Census Data'!$E$16*((B44-'2. Census Data'!$E$11)*(AVERAGE('3. Single-family'!$R$38:$R$43))))))","v":0}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[]
[null,"TABLE 3.3",null,null,null,{"$f":"IF(W24=2,\"You have entered Total Connections in Table 3.2; enter the number of inactive (zero use) connections below\",IF(W24=3,\"You have entered Active Connections Only in Table 3.2; leave the cells below blank\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,"TABLE 3.10",null,"TABLE 3.11"]
[null,"INACTIVE (ZERO USE) SFR CONNECTIONS (Monthly)",null,null,null,{"$f":"IF(W24=2,\"If values are not entered, an adjustment will be made based on vacancy rates reported in the Census data\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"CALCULATED GROWTH RATE",null,"No. VACANT SFR CONNECTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATED GROWTH RATE"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B27","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(T28=\"N/A\",T27=\"N/A\"),\"N/A\",(T27-T28)/T28)","v":"N/A"},null,{"$f":"IF(T27=\"N/A\",\"N/A\",IF($W$24=3,0,IF(W38=0,T27*'2. Census Data'!$E$21,AVERAGE(C38:N38))))","v":"N/A"},null,null,{"$f":"IF(OR(C38=0,D38=0,E38=0,F38=0,G38=0,H38=0,I38=0,J38=0,K38=0,L38=0,M38=0,N38=0),0,1)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"R38","v":"N/A"}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,{"$f":"IF(T28=\"N/A\",\"N/A\",IF($W$24=3,0,IF(W39=0,T28*'2. Census Data'!$E$21,AVERAGE(C39:N39))))","v":"N/A"},null,null,0,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,{"$f":"IF(T29=\"N/A\",\"N/A\",IF($W$24=3,0,IF(W40=0,T29*'2. Census Data'!$E$21,AVERAGE(C40:N40))))","v":"N/A"},null,null,0,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,{"$f":"IF(T30=\"N/A\",\"N/A\",IF($W$24=3,0,IF(W41=0,T30*'2. Census Data'!$E$21,AVERAGE(C41:N41))))","v":"N/A"},null,null,0,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,{"$f":"IF(T31=\"N/A\",\"N/A\",IF($W$24=3,0,IF(W42=0,T31*'2. Census Data'!$E$21,AVERAGE(C42:N42))))","v":"N/A"},null,null,0,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,{"$f":"IF(T32=\"N/A\",\"N/A\",IF($W$24=3,0,IF(W43=0,T32*'2. Census Data'!$E$21,AVERAGE(C43:N43))))","v":"N/A"},null,null,0,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R38:R43)=0,\"Are you sure growth is zero?\",\"\")","v":"Are you sure growth is zero?"},null,{"$f":"IF(T33=\"N/A\",\"N/A\",IF($W$24=3,0,IF(W44=0,T33*'2. Census Data'!$E$21,AVERAGE(C44:N44))))","v":"N/A"},null,null,0]
[]
[null,"TABLE 3.4",null,null,null,"Formula = (No. of Connections - No. of Zero Use Accounts) * Ave. Household Size",null,null,null,null,null,null,null,null,null,null,null,"TABLE 3.12",null,"TABLE 3.13"]
[null,"SFR POPULATION (Monthly)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIZE OF HOUSEHOLD",null,"SFR POPULATION"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B16","v":""},{"$f":"IF(OR(C16=0,C27=0),\"No Data\",(C27-IF($W$24=2,IF($W38=1,C38,$T38),0))*$R49)","v":"No Data"},{"$f":"IF(OR(D16=0,D27=0),\"No Data\",(D27-IF($W$24=2,IF($W38=1,D38,$T38),0))*$R49)","v":"No Data"},{"$f":"IF(OR(E16=0,E27=0),\"No Data\",(E27-IF($W$24=2,IF($W38=1,E38,$T38),0))*$R49)","v":"No Data"},"No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data",null,null,null,{"$f":"'2. Census Data'!E17","v":0},null,{"$f":"IF(OR(C49=\"No Data\",D49=\"No Data\",E49=\"No Data\",F49=\"No Data\",G49=\"No Data\",H49=\"No Data\",I49=\"No Data\",J49=\"No Data\",K49=\"No Data\",L49=\"No Data\",M49=\"No Data\",N49=\"No Data\"),IF(T27=\"N/A\",\"N/A\",(T27-T38)*R49),AVERAGE(C49:N49))","v":"N/A"}]
[null,"",{"$f":"IF(OR(C17=0,C28=0),\"No Data\",(C28-IF($W$24=2,IF($W39=1,C39,$T39),0))*$R50)","v":"No Data"},"No Data",{"$f":"IF(OR(E17=0,E28=0),\"No Data\",(E28-IF($W$24=2,IF($W39=1,E39,$T39),0))*$R50)","v":"No Data"},"No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data",null,null,null,{"$f":"$R$49","v":0},null,"N/A"]
[null,"","No Data","No Data",{"$f":"IF(OR(E18=0,E29=0),\"No Data\",(E29-IF($W$24=2,IF($W40=1,E40,$T40),0))*$R51)","v":"No Data"},"No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data",null,null,null,0,null,"N/A"]
[null,"","No Data","No Data",{"$f":"IF(OR(E19=0,E30=0),\"No Data\",(E30-IF($W$24=2,IF($W41=1,E41,$T41),0))*$R52)","v":"No Data"},"No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data",null,null,null,0,null,"N/A"]
[null,"","No Data","No Data",{"$f":"IF(OR(E20=0,E31=0),\"No Data\",(E31-IF($W$24=2,IF($W42=1,E42,$T42),0))*$R53)","v":"No Data"},"No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data",null,null,null,0,null,"N/A"]
[null,"","No Data","No Data",{"$f":"IF(OR(E21=0,E32=0),\"No Data\",(E32-IF($W$24=2,IF($W43=1,E43,$T43),0))*$R54)","v":"No Data"},"No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data",null,null,null,0,null,"N/A"]
[null,"","No Data","No Data",{"$f":"IF(OR(E22=0,E33=0),\"No Data\",(E33-IF($W$24=2,IF($W44=1,E44,$T44),0))*$R55)","v":"No Data"},"No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data","No Data",null,null,null,0,null,"N/A"]
[]
[]
[]
[null,"TABLE 3.5",null,null,null,"Formula = Billed Water Consumption (SFR only) / Calculated Population (SFR only)",null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 3.14"]
[null,"SFR GPCD CALCULATION (Monthly)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL SFR GPCD"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC",null,null,null,null,null,null,null,null,"Consump","Conns"]
[null,{"$f":"B49","v":""},{"$f":"IF(OR(C16=0,C27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C16*7.48051945,C16)/31)/C49)","v":"No Data"},{"$f":"IF(OR(D16=0,D27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D16*7.48051945,D16)/28)/D49)","v":"No Data"},{"$f":"IF(OR(E16=0,E27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E16*7.48051945,E16)/31)/E49)","v":"No Data"},{"$f":"IF(OR(F16=0,F27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F16*7.48051945,F16)/30)/F49)","v":"No Data"},{"$f":"IF(OR(G16=0,G27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G16*7.48051945,G16)/31)/G49)","v":"No Data"},{"$f":"IF(OR(H16=0,H27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H16*7.48051945,H16)/30)/H49)","v":"No Data"},{"$f":"IF(OR(I16=0,I27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I16*7.48051945,I16)/31)/I49)","v":"No Data"},{"$f":"IF(OR(J16=0,J27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J16*7.48051945,J16)/31)/J49)","v":"No Data"},{"$f":"IF(OR(K16=0,K27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K16*7.48051945,K16)/30)/K49)","v":"No Data"},{"$f":"IF(OR(L16=0,L27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L16*7.48051945,L16)/31)/L49)","v":"No Data"},{"$f":"IF(OR(M16=0,M27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M16*7.48051945,M16)/30)/M49)","v":"No Data"},{"$f":"IF(OR(N16=0,N27=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N16*7.48051945,N16)/31)/N49)","v":"No Data"},null,null,null,{"$f":"IF(SUM(W62:X62)=1,IF(W62=1,\"Add Connection Data\",\"Add Consumption Data\"),\"\")","v":""},{"$f":"IF(OR(T16=\"N/A\",T49=\"N/A\"),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T16*7.48051945,T16)/(365*T49))","v":"N/A"},null,null,null,{"$f":"IF(OR(W16=1,R16>0),1,0)","v":0},{"$f":"IF(OR(W27=1,AND(T27>0,T27<>\"N/A\")),1,0)","v":0}]
[null,"",{"$f":"IF(OR(C17=0,C28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C17*7.48051945,C17)/31)/C50)","v":"No Data"},{"$f":"IF(OR(D17=0,D28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D17*7.48051945,D17)/28)/D50)","v":"No Data"},{"$f":"IF(OR(E17=0,E28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E17*7.48051945,E17)/31)/E50)","v":"No Data"},{"$f":"IF(OR(F17=0,F28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F17*7.48051945,F17)/30)/F50)","v":"No Data"},{"$f":"IF(OR(G17=0,G28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G17*7.48051945,G17)/31)/G50)","v":"No Data"},{"$f":"IF(OR(H17=0,H28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H17*7.48051945,H17)/30)/H50)","v":"No Data"},{"$f":"IF(OR(I17=0,I28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I17*7.48051945,I17)/31)/I50)","v":"No Data"},{"$f":"IF(OR(J17=0,J28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J17*7.48051945,J17)/31)/J50)","v":"No Data"},{"$f":"IF(OR(K17=0,K28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K17*7.48051945,K17)/30)/K50)","v":"No Data"},{"$f":"IF(OR(L17=0,L28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L17*7.48051945,L17)/31)/L50)","v":"No Data"},{"$f":"IF(OR(M17=0,M28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M17*7.48051945,M17)/30)/M50)","v":"No Data"},{"$f":"IF(OR(N17=0,N28=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N17*7.48051945,N17)/31)/N50)","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T17=\"N/A\",T50=\"N/A\"),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T17*7.48051945,T17)/(365*T50))","v":"N/A"},null,null,null,0,0]
[null,"",{"$f":"IF(OR(C18=0,C29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C18*7.48051945,C18)/31)/C51)","v":"No Data"},{"$f":"IF(OR(D18=0,D29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D18*7.48051945,D18)/28)/D51)","v":"No Data"},{"$f":"IF(OR(E18=0,E29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E18*7.48051945,E18)/31)/E51)","v":"No Data"},{"$f":"IF(OR(F18=0,F29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F18*7.48051945,F18)/30)/F51)","v":"No Data"},{"$f":"IF(OR(G18=0,G29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G18*7.48051945,G18)/31)/G51)","v":"No Data"},{"$f":"IF(OR(H18=0,H29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H18*7.48051945,H18)/30)/H51)","v":"No Data"},{"$f":"IF(OR(I18=0,I29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I18*7.48051945,I18)/31)/I51)","v":"No Data"},{"$f":"IF(OR(J18=0,J29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J18*7.48051945,J18)/31)/J51)","v":"No Data"},{"$f":"IF(OR(K18=0,K29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K18*7.48051945,K18)/30)/K51)","v":"No Data"},{"$f":"IF(OR(L18=0,L29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L18*7.48051945,L18)/31)/L51)","v":"No Data"},{"$f":"IF(OR(M18=0,M29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M18*7.48051945,M18)/30)/M51)","v":"No Data"},{"$f":"IF(OR(N18=0,N29=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N18*7.48051945,N18)/31)/N51)","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T18=\"N/A\",T51=\"N/A\"),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T18*7.48051945,T18)/(365*T51))","v":"N/A"},null,null,null,0,0]
[null,"",{"$f":"IF(OR(C19=0,C30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C19*7.48051945,C19)/31)/C52)","v":"No Data"},{"$f":"IF(OR(D19=0,D30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D19*7.48051945,D19)/28)/D52)","v":"No Data"},{"$f":"IF(OR(E19=0,E30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E19*7.48051945,E19)/31)/E52)","v":"No Data"},{"$f":"IF(OR(F19=0,F30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F19*7.48051945,F19)/30)/F52)","v":"No Data"},{"$f":"IF(OR(G19=0,G30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G19*7.48051945,G19)/31)/G52)","v":"No Data"},{"$f":"IF(OR(H19=0,H30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H19*7.48051945,H19)/30)/H52)","v":"No Data"},{"$f":"IF(OR(I19=0,I30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I19*7.48051945,I19)/31)/I52)","v":"No Data"},{"$f":"IF(OR(J19=0,J30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J19*7.48051945,J19)/31)/J52)","v":"No Data"},{"$f":"IF(OR(K19=0,K30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K19*7.48051945,K19)/30)/K52)","v":"No Data"},{"$f":"IF(OR(L19=0,L30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L19*7.48051945,L19)/31)/L52)","v":"No Data"},{"$f":"IF(OR(M19=0,M30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M19*7.48051945,M19)/30)/M52)","v":"No Data"},{"$f":"IF(OR(N19=0,N30=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N19*7.48051945,N19)/31)/N52)","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T19=\"N/A\",T52=\"N/A\"),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T19*7.48051945,T19)/(365*T52))","v":"N/A"},null,null,null,0,0]
[null,"",{"$f":"IF(OR(C20=0,C31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C20*7.48051945,C20)/31)/C53)","v":"No Data"},{"$f":"IF(OR(D20=0,D31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D20*7.48051945,D20)/28)/D53)","v":"No Data"},{"$f":"IF(OR(E20=0,E31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E20*7.48051945,E20)/31)/E53)","v":"No Data"},{"$f":"IF(OR(F20=0,F31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F20*7.48051945,F20)/30)/F53)","v":"No Data"},{"$f":"IF(OR(G20=0,G31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G20*7.48051945,G20)/31)/G53)","v":"No Data"},{"$f":"IF(OR(H20=0,H31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H20*7.48051945,H20)/30)/H53)","v":"No Data"},{"$f":"IF(OR(I20=0,I31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I20*7.48051945,I20)/31)/I53)","v":"No Data"},{"$f":"IF(OR(J20=0,J31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J20*7.48051945,J20)/31)/J53)","v":"No Data"},{"$f":"IF(OR(K20=0,K31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K20*7.48051945,K20)/30)/K53)","v":"No Data"},{"$f":"IF(OR(L20=0,L31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L20*7.48051945,L20)/31)/L53)","v":"No Data"},{"$f":"IF(OR(M20=0,M31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M20*7.48051945,M20)/30)/M53)","v":"No Data"},{"$f":"IF(OR(N20=0,N31=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N20*7.48051945,N20)/31)/N53)","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T20=\"N/A\",T53=\"N/A\"),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T20*7.48051945,T20)/(365*T53))","v":"N/A"},null,null,null,0,0]
[null,"",{"$f":"IF(OR(C21=0,C32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C21*7.48051945,C21)/31)/C54)","v":"No Data"},{"$f":"IF(OR(D21=0,D32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D21*7.48051945,D21)/28)/D54)","v":"No Data"},{"$f":"IF(OR(E21=0,E32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E21*7.48051945,E21)/31)/E54)","v":"No Data"},{"$f":"IF(OR(F21=0,F32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F21*7.48051945,F21)/30)/F54)","v":"No Data"},{"$f":"IF(OR(G21=0,G32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G21*7.48051945,G21)/31)/G54)","v":"No Data"},{"$f":"IF(OR(H21=0,H32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H21*7.48051945,H21)/30)/H54)","v":"No Data"},{"$f":"IF(OR(I21=0,I32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I21*7.48051945,I21)/31)/I54)","v":"No Data"},{"$f":"IF(OR(J21=0,J32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J21*7.48051945,J21)/31)/J54)","v":"No Data"},{"$f":"IF(OR(K21=0,K32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K21*7.48051945,K21)/30)/K54)","v":"No Data"},{"$f":"IF(OR(L21=0,L32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L21*7.48051945,L21)/31)/L54)","v":"No Data"},{"$f":"IF(OR(M21=0,M32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M21*7.48051945,M21)/30)/M54)","v":"No Data"},{"$f":"IF(OR(N21=0,N32=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N21*7.48051945,N21)/31)/N54)","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T21=\"N/A\",T54=\"N/A\"),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T21*7.48051945,T21)/(365*T54))","v":"N/A"},null,null,null,0,0]
[null,"",{"$f":"IF(OR(C22=0,C33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C22*7.48051945,C22)/31)/C55)","v":"No Data"},{"$f":"IF(OR(D22=0,D33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D22*7.48051945,D22)/28)/D55)","v":"No Data"},{"$f":"IF(OR(E22=0,E33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E22*7.48051945,E22)/31)/E55)","v":"No Data"},{"$f":"IF(OR(F22=0,F33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F22*7.48051945,F22)/30)/F55)","v":"No Data"},{"$f":"IF(OR(G22=0,G33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G22*7.48051945,G22)/31)/G55)","v":"No Data"},{"$f":"IF(OR(H22=0,H33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H22*7.48051945,H22)/30)/H55)","v":"No Data"},{"$f":"IF(OR(I22=0,I33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I22*7.48051945,I22)/31)/I55)","v":"No Data"},{"$f":"IF(OR(J22=0,J33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J22*7.48051945,J22)/31)/J55)","v":"No Data"},{"$f":"IF(OR(K22=0,K33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K22*7.48051945,K22)/30)/K55)","v":"No Data"},{"$f":"IF(OR(L22=0,L33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L22*7.48051945,L22)/31)/L55)","v":"No Data"},{"$f":"IF(OR(M22=0,M33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M22*7.48051945,M22)/30)/M55)","v":"No Data"},{"$f":"IF(OR(N22=0,N33=0),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N22*7.48051945,N22)/31)/N55)","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T22=\"N/A\",T55=\"N/A\"),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T22*7.48051945,T22)/(365*T55))","v":"N/A"},null,null,null,0,{"$f":"IF(OR(W33=1,AND(T33>0,T33<>\"N/A\")),1,0)","v":0}]
[]
[null,"COMMENTS:"]
[]
[]
[]
[]
[]
[]
[]
[null,"RAINFALL (inches)"]
[]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B62","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"4. Multi-family","index":3,"n_rows":58,"n_cols":24,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,5,3,11],[32,17,33,17],[6,16,6,20],[6,0,6,14],[47,18,47,19],[20,19,21,19],[20,17,21,17],[1,1,2,2],[9,1,9,4],[51,18,51,19],[9,17,10,17],[9,19,10,19],[45,18,46,19],[56,1,59,13],[32,19,33,19],[52,18,52,19],[53,18,53,19],[48,18,48,19],[49,18,49,19],[50,18,50,19]]}
[]
[null,"DATA INPUT SHEET",null,null,null,"4. MULTI-FAMILY RESIDENTIAL (MFR)"]
[]
[null,null,{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""}]
[]
[null,"Instructions"]
["MONTHLY DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL DATA"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1. Instructions and Notations'!E31","v":0},"TO",{"$f":"'1. Instructions and Notations'!I31","v":""}]
[null,"TABLE 4.1",null,null,{"$f":"IF('1. Instructions and Notations'!$E$38=\"Choose units...\",\"        First select reporting units for volume data on the instructions worksheet\",\"\")","v":"        First select reporting units for volume data on the instructions worksheet"},null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 4.5",null,"TABLE 4.6"]
[null,{"$f":"\"MFR BILLED WATER CONSUMPTION (Monthly) (\"&'1. Instructions and Notations'!E38&\")\"","v":"MFR BILLED WATER CONSUMPTION (Monthly) (Choose units...)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL CONSUMPTION",null,"ANNUAL CALCULATION"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"'3. Single-family'!B16","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W12=1,SUM(C12:N12),IF(R12=0,\"N/A\",R12))","v":"N/A"},null,null,{"$f":"IF(OR(C12=0,D12=0,E12=0,F12=0,G12=0,H12=0,I12=0,J12=0,K12=0,L12=0,M12=0,N12=0),0,1)","v":0}]
[null,{"$f":"'3. Single-family'!B17","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,{"$f":"'3. Single-family'!B18","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,{"$f":"'3. Single-family'!B19","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,{"$f":"'3. Single-family'!B20","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,{"$f":"'3. Single-family'!B21","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[null,{"$f":"'3. Single-family'!B22","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,0]
[]
[null,"TABLE 4.2",null,null,null,"If only Current Number of Units is Known, put this number in Table 4.7",null,null,null,null,null,null,null,null,null,null,null,"TABLE 4.7",null,"TABLE 4.8"]
[null,"NUMBER OF MFR UNITS (Monthly)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. CURRENT UNITS",null,"ANNUAL UNIT CALCULATION"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B12","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W23=1,AVERAGE(C23:N23),IF(R23=0,\"N/A\",R23))","v":"N/A"},null,null,{"$f":"IF(OR(C23=0,D23=0,E23=0,F23=0,G23=0,H23=0,I23=0,J23=0,K23=0,L23=0,M23=0,N23=0),0,1)","v":0}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W24=1,AVERAGE(C24:N24),IF(R24=0,IF('3. Single-family'!AH38=\"N/A\",\"N/A\",IF($T$23=\"N/A\",\"N/A\",T23/(1+'3. Single-family'!AH38))),R24))","v":"N/A"},{"$f":"IF(AND(W24=0,R24=0,'3. Single-family'!AH38<>\"N/A\"),\"X\",\"\")","v":""},null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W25=1,AVERAGE(C25:N25),IF(R25=0,IF('3. Single-family'!AH39=\"N/A\",\"N/A\",IF($T$23=\"N/A\",\"N/A\",T24/(1+'3. Single-family'!AH39))),R25))","v":"N/A"},{"$f":"IF(AND(W25=0,R25=0,'3. Single-family'!AH39<>\"N/A\"),\"X\",\"\")","v":""},null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W26=1,AVERAGE(C26:N26),IF(R26=0,IF('3. Single-family'!AH40=\"N/A\",\"N/A\",IF($T$23=\"N/A\",\"N/A\",T25/(1+'3. Single-family'!AH40))),R26))","v":"N/A"},{"$f":"IF(AND(W26=0,R26=0,'3. Single-family'!AH40<>\"N/A\"),\"X\",\"\")","v":""},null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W27=1,AVERAGE(C27:N27),IF(R27=0,IF('3. Single-family'!AH41=\"N/A\",\"N/A\",IF($T$23=\"N/A\",\"N/A\",T26/(1+'3. Single-family'!AH41))),R27))","v":"N/A"},{"$f":"IF(AND(W27=0,R27=0,'3. Single-family'!AH41<>\"N/A\"),\"X\",\"\")","v":""},null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W28=1,AVERAGE(C28:N28),IF(R28=0,IF('3. Single-family'!AH42=\"N/A\",\"N/A\",IF($T$23=\"N/A\",\"N/A\",T27/(1+'3. Single-family'!AH42))),R28))","v":"N/A"},{"$f":"IF(AND(W28=0,R28=0,'3. Single-family'!AH42<>\"N/A\"),\"X\",\"\")","v":""},null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W29=1,AVERAGE(C29:N29),IF(R29=0,IF('3. Single-family'!AH43=\"N/A\",\"N/A\",IF($T$23=\"N/A\",\"N/A\",T28/(1+'3. Single-family'!AH43))),R29))","v":"N/A"},{"$f":"IF(AND(W29=0,R29=0,'3. Single-family'!AH43<>\"N/A\"),\"X\",\"\")","v":""},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(U24:U29,\"X\")>0,\"X = calculated from Single-family growth-rate data     \",\"\")","v":""}]
[]
[null,"TABLE 4.3",null,null,null,"Formula = (Number of Units - Vacant MFR Connections) * Ave. Household Size",null,null,null,null,null,null,null,null,null,null,null,"TABLE 4.9",null,"TABLE 4.10"]
[null,"MFR POPULATION (Monthly)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MFR POPULATION",null,"VACANT MFR CONNECTIONS"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B12","v":""},{"$f":"IF(C23=0,\"No Data\",(C23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(D23=0,\"No Data\",(D23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(E23=0,\"No Data\",(E23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(F23=0,\"No Data\",(F23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(G23=0,\"No Data\",(G23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(H23=0,\"No Data\",(H23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(I23=0,\"No Data\",(I23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(J23=0,\"No Data\",(J23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(K23=0,\"No Data\",(K23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(L23=0,\"No Data\",(L23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(M23=0,\"No Data\",(M23-T35)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(N23=0,\"No Data\",(N23-T35)*'2. Census Data'!$E$17)","v":"No Data"},null,null,null,{"$f":"IF(OR(C35=\"No Data\",D35=\"No Data\",E35=\"No Data\",F35=\"No Data\",G35=\"No Data\",H35=\"No Data\",I35=\"No Data\",J35=\"No Data\",K35=\"No Data\",L35=\"No Data\",M35=\"No Data\",N35=\"No Data\"),IF(T23=\"N/A\",\"N/A\",(T23-T35)*'2. Census Data'!E17),AVERAGE(C35:N35))","v":"N/A"},null,{"$f":"IF(OR(T23=\"\",T23=\"N/A\",'2. Census Data'!$E$21=\"\"),\"N/A\",T23*'2. Census Data'!$E$21)","v":"N/A"}]
[null,"",{"$f":"IF(C24=0,\"No Data\",(C24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(D24=0,\"No Data\",(D24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(E24=0,\"No Data\",(E24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(F24=0,\"No Data\",(F24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(G24=0,\"No Data\",(G24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(H24=0,\"No Data\",(H24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(I24=0,\"No Data\",(I24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(J24=0,\"No Data\",(J24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(K24=0,\"No Data\",(K24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(L24=0,\"No Data\",(L24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(M24=0,\"No Data\",(M24-T36)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(N24=0,\"No Data\",(N24-T36)*'2. Census Data'!$E$17)","v":"No Data"},null,null,null,{"$f":"IF(OR(C36=\"No Data\",D36=\"No Data\",E36=\"No Data\",F36=\"No Data\",G36=\"No Data\",H36=\"No Data\",I36=\"No Data\",J36=\"No Data\",K36=\"No Data\",L36=\"No Data\",M36=\"No Data\",N36=\"No Data\"),IF(T24=\"N/A\",\"N/A\",(T24-T36)*'2. Census Data'!E17),AVERAGE(C36:N36))","v":"N/A"},null,{"$f":"IF(OR(T24=\"\",T24=\"N/A\",'2. Census Data'!$E$21=\"\"),\"N/A\",T24*'2. Census Data'!$E$21)","v":"N/A"}]
[null,"",{"$f":"IF(C25=0,\"No Data\",(C25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(D25=0,\"No Data\",(D25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(E25=0,\"No Data\",(E25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(F25=0,\"No Data\",(F25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(G25=0,\"No Data\",(G25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(H25=0,\"No Data\",(H25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(I25=0,\"No Data\",(I25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(J25=0,\"No Data\",(J25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(K25=0,\"No Data\",(K25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(L25=0,\"No Data\",(L25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(M25=0,\"No Data\",(M25-T37)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(N25=0,\"No Data\",(N25-T37)*'2. Census Data'!$E$17)","v":"No Data"},null,null,null,{"$f":"IF(OR(C37=\"No Data\",D37=\"No Data\",E37=\"No Data\",F37=\"No Data\",G37=\"No Data\",H37=\"No Data\",I37=\"No Data\",J37=\"No Data\",K37=\"No Data\",L37=\"No Data\",M37=\"No Data\",N37=\"No Data\"),IF(T25=\"N/A\",\"N/A\",(T25-T37)*'2. Census Data'!E17),AVERAGE(C37:N37))","v":"N/A"},null,{"$f":"IF(OR(T25=\"\",T25=\"N/A\",'2. Census Data'!$E$21=\"\"),\"N/A\",T25*'2. Census Data'!$E$21)","v":"N/A"}]
[null,"",{"$f":"IF(C26=0,\"No Data\",(C26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(D26=0,\"No Data\",(D26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(E26=0,\"No Data\",(E26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(F26=0,\"No Data\",(F26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(G26=0,\"No Data\",(G26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(H26=0,\"No Data\",(H26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(I26=0,\"No Data\",(I26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(J26=0,\"No Data\",(J26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(K26=0,\"No Data\",(K26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(L26=0,\"No Data\",(L26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(M26=0,\"No Data\",(M26-T38)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(N26=0,\"No Data\",(N26-T38)*'2. Census Data'!$E$17)","v":"No Data"},null,null,null,{"$f":"IF(OR(C38=\"No Data\",D38=\"No Data\",E38=\"No Data\",F38=\"No Data\",G38=\"No Data\",H38=\"No Data\",I38=\"No Data\",J38=\"No Data\",K38=\"No Data\",L38=\"No Data\",M38=\"No Data\",N38=\"No Data\"),IF(T26=\"N/A\",\"N/A\",(T26-T38)*'2. Census Data'!E17),AVERAGE(C38:N38))","v":"N/A"},null,{"$f":"IF(OR(T26=\"\",T26=\"N/A\",'2. Census Data'!$E$21=\"\"),\"N/A\",T26*'2. Census Data'!$E$21)","v":"N/A"}]
[null,"",{"$f":"IF(C27=0,\"No Data\",(C27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(D27=0,\"No Data\",(D27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(E27=0,\"No Data\",(E27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(F27=0,\"No Data\",(F27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(G27=0,\"No Data\",(G27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(H27=0,\"No Data\",(H27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(I27=0,\"No Data\",(I27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(J27=0,\"No Data\",(J27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(K27=0,\"No Data\",(K27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(L27=0,\"No Data\",(L27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(M27=0,\"No Data\",(M27-T39)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(N27=0,\"No Data\",(N27-T39)*'2. Census Data'!$E$17)","v":"No Data"},null,null,null,{"$f":"IF(OR(C39=\"No Data\",D39=\"No Data\",E39=\"No Data\",F39=\"No Data\",G39=\"No Data\",H39=\"No Data\",I39=\"No Data\",J39=\"No Data\",K39=\"No Data\",L39=\"No Data\",M39=\"No Data\",N39=\"No Data\"),IF(T27=\"N/A\",\"N/A\",(T27-T39)*'2. Census Data'!E17),AVERAGE(C39:N39))","v":"N/A"},null,{"$f":"IF(OR(T27=\"\",T27=\"N/A\",'2. Census Data'!$E$21=\"\"),\"N/A\",T27*'2. Census Data'!$E$21)","v":"N/A"}]
[null,"",{"$f":"IF(C28=0,\"No Data\",(C28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(D28=0,\"No Data\",(D28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(E28=0,\"No Data\",(E28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(F28=0,\"No Data\",(F28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(G28=0,\"No Data\",(G28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(H28=0,\"No Data\",(H28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(I28=0,\"No Data\",(I28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(J28=0,\"No Data\",(J28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(K28=0,\"No Data\",(K28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(L28=0,\"No Data\",(L28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(M28=0,\"No Data\",(M28-T40)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(N28=0,\"No Data\",(N28-T40)*'2. Census Data'!$E$17)","v":"No Data"},null,null,null,{"$f":"IF(OR(C40=\"No Data\",D40=\"No Data\",E40=\"No Data\",F40=\"No Data\",G40=\"No Data\",H40=\"No Data\",I40=\"No Data\",J40=\"No Data\",K40=\"No Data\",L40=\"No Data\",M40=\"No Data\",N40=\"No Data\"),IF(T28=\"N/A\",\"N/A\",(T28-T40)*'2. Census Data'!E17),AVERAGE(C40:N40))","v":"N/A"},null,{"$f":"IF(OR(T28=\"\",T28=\"N/A\",'2. Census Data'!$E$21=\"\"),\"N/A\",T28*'2. Census Data'!$E$21)","v":"N/A"}]
[null,"",{"$f":"IF(C29=0,\"No Data\",(C29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(D29=0,\"No Data\",(D29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(E29=0,\"No Data\",(E29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(F29=0,\"No Data\",(F29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(G29=0,\"No Data\",(G29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(H29=0,\"No Data\",(H29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(I29=0,\"No Data\",(I29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(J29=0,\"No Data\",(J29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(K29=0,\"No Data\",(K29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(L29=0,\"No Data\",(L29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(M29=0,\"No Data\",(M29-T41)*'2. Census Data'!$E$17)","v":"No Data"},{"$f":"IF(N29=0,\"No Data\",(N29-T41)*'2. Census Data'!$E$17)","v":"No Data"},null,null,null,{"$f":"IF(OR(C41=\"No Data\",D41=\"No Data\",E41=\"No Data\",F41=\"No Data\",G41=\"No Data\",H41=\"No Data\",I41=\"No Data\",J41=\"No Data\",K41=\"No Data\",L41=\"No Data\",M41=\"No Data\",N41=\"No Data\"),IF(T29=\"N/A\",\"N/A\",(T29-T41)*'2. Census Data'!E17),AVERAGE(C41:N41))","v":"N/A"},null,{"$f":"IF(OR(T29=\"\",T29=\"N/A\",'2. Census Data'!$E$21=\"\"),\"N/A\",T29*'2. Census Data'!$E$21)","v":"N/A"}]
[]
[]
[]
[null,"TABLE 4.4",null,null,null,"Formula = MFR Billed Water Consumption (Monthly) / MFR Population (Monthly) ",null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 4.11"]
[null,"MFR GPCD CALCULATION (Monthly)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL MFR GPCD"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC",null,null,null,null,null,null,null,null,"Consump","Conns"]
[null,{"$f":"B35","v":""},{"$f":"IF(AND(ISNUMBER(C12),ISNUMBER(C23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C12*7.48051945,C12)/31)/C35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(D12),ISNUMBER(D23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D12*7.48051945,D12)/28)/D35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(E12),ISNUMBER(E23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E12*7.48051945,E12)/31)/E35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(F12),ISNUMBER(F23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F12*7.48051945,F12)/30)/F35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(G12),ISNUMBER(G23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G12*7.48051945,G12)/31)/G35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(H12),ISNUMBER(H23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H12*7.48051945,H12)/30)/H35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(I12),ISNUMBER(I23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I12*7.48051945,I12)/31)/I35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(J12),ISNUMBER(J23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J12*7.48051945,J12)/31)/J35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(K12),ISNUMBER(K23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K12*7.48051945,K12)/30)/K35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(L12),ISNUMBER(L23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L12*7.48051945,L12)/31)/L35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(M12),ISNUMBER(M23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M12*7.48051945,M12)/30)/M35,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(N12),ISNUMBER(N23)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N12*7.48051945,N12)/31)/N35,\"No Data\")","v":"No Data"},null,null,null,{"$f":"IF(SUM(W48:X48)=1,IF(W48=1,\"Add Connection Data\",\"Add Consumption Data\"),\"\")","v":""},{"$f":"IF(OR(T12=\"N/A\",R35=\"N/A\",R35=0),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T12*7.48051945,T12)/(R35*365))","v":"N/A"},null,null,null,{"$f":"IF(OR(W12=1,R12>0),1,0)","v":0},{"$f":"IF(OR(W23=1,AND(T23>0,T23<>\"N/A\")),1,0)","v":0}]
[null,"",{"$f":"IF(AND(ISNUMBER(C13),ISNUMBER(C24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C13*7.48051945,C13)/31)/C36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(D13),ISNUMBER(D24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D13*7.48051945,D13)/28)/D36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(E13),ISNUMBER(E24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E13*7.48051945,E13)/31)/E36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(F13),ISNUMBER(F24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F13*7.48051945,F13)/30)/F36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(G13),ISNUMBER(G24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G13*7.48051945,G13)/31)/G36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(H13),ISNUMBER(H24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H13*7.48051945,H13)/30)/H36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(I13),ISNUMBER(I24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I13*7.48051945,I13)/31)/I36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(J13),ISNUMBER(J24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J13*7.48051945,J13)/31)/J36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(K13),ISNUMBER(K24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K13*7.48051945,K13)/30)/K36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(L13),ISNUMBER(L24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L13*7.48051945,L13)/31)/L36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(M13),ISNUMBER(M24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M13*7.48051945,M13)/30)/M36,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(N13),ISNUMBER(N24)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N13*7.48051945,N13)/31)/N36,\"No Data\")","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T13=\"N/A\",R36=\"N/A\",R36=0),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T13*7.48051945,T13)/(R36*365))","v":"N/A"},null,null,null,0,{"$f":"IF(OR(W24=1,AND(T24>0,T24<>\"N/A\")),1,0)","v":0}]
[null,"",{"$f":"IF(AND(ISNUMBER(C14),ISNUMBER(C25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C14*7.48051945,C14)/31)/C37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(D14),ISNUMBER(D25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D14*7.48051945,D14)/28)/D37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(E14),ISNUMBER(E25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E14*7.48051945,E14)/31)/E37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(F14),ISNUMBER(F25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F14*7.48051945,F14)/30)/F37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(G14),ISNUMBER(G25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G14*7.48051945,G14)/31)/G37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(H14),ISNUMBER(H25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H14*7.48051945,H14)/30)/H37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(I14),ISNUMBER(I25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I14*7.48051945,I14)/31)/I37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(J14),ISNUMBER(J25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J14*7.48051945,J14)/31)/J37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(K14),ISNUMBER(K25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K14*7.48051945,K14)/30)/K37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(L14),ISNUMBER(L25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L14*7.48051945,L14)/31)/L37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(M14),ISNUMBER(M25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M14*7.48051945,M14)/30)/M37,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(N14),ISNUMBER(N25)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N14*7.48051945,N14)/31)/N37,\"No Data\")","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T14=\"N/A\",R37=\"N/A\",R37=0),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T14*7.48051945,T14)/(R37*365))","v":"N/A"},null,null,null,0,0]
[null,"",{"$f":"IF(AND(ISNUMBER(C15),ISNUMBER(C26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C15*7.48051945,C15)/31)/C38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(D15),ISNUMBER(D26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D15*7.48051945,D15)/28)/D38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(E15),ISNUMBER(E26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E15*7.48051945,E15)/31)/E38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(F15),ISNUMBER(F26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F15*7.48051945,F15)/30)/F38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(G15),ISNUMBER(G26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G15*7.48051945,G15)/31)/G38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(H15),ISNUMBER(H26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H15*7.48051945,H15)/30)/H38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(I15),ISNUMBER(I26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I15*7.48051945,I15)/31)/I38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(J15),ISNUMBER(J26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J15*7.48051945,J15)/31)/J38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(K15),ISNUMBER(K26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K15*7.48051945,K15)/30)/K38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(L15),ISNUMBER(L26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L15*7.48051945,L15)/31)/L38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(M15),ISNUMBER(M26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M15*7.48051945,M15)/30)/M38,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(N15),ISNUMBER(N26)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N15*7.48051945,N15)/31)/N38,\"No Data\")","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T15=\"N/A\",R38=\"N/A\",R38=0),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T15*7.48051945,T15)/(R38*365))","v":"N/A"},null,null,null,0,0]
[null,"",{"$f":"IF(AND(ISNUMBER(C16),ISNUMBER(C27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C16*7.48051945,C16)/31)/C39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(D16),ISNUMBER(D27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D16*7.48051945,D16)/28)/D39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(E16),ISNUMBER(E27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E16*7.48051945,E16)/31)/E39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(F16),ISNUMBER(F27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F16*7.48051945,F16)/30)/F39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(G16),ISNUMBER(G27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G16*7.48051945,G16)/31)/G39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(H16),ISNUMBER(H27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H16*7.48051945,H16)/30)/H39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(I16),ISNUMBER(I27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I16*7.48051945,I16)/31)/I39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(J16),ISNUMBER(J27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J16*7.48051945,J16)/31)/J39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(K16),ISNUMBER(K27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K16*7.48051945,K16)/30)/K39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(L16),ISNUMBER(L27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L16*7.48051945,L16)/31)/L39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(M16),ISNUMBER(M27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M16*7.48051945,M16)/30)/M39,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(N16),ISNUMBER(N27)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N16*7.48051945,N16)/31)/N39,\"No Data\")","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T16=\"N/A\",R39=\"N/A\",R39=0),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T16*7.48051945,T16)/(R39*365))","v":"N/A"},null,null,null,0,0]
[null,"",{"$f":"IF(AND(ISNUMBER(C17),ISNUMBER(C28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C17*7.48051945,C17)/31)/C40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(D17),ISNUMBER(D28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D17*7.48051945,D17)/28)/D40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(E17),ISNUMBER(E28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E17*7.48051945,E17)/31)/E40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(F17),ISNUMBER(F28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F17*7.48051945,F17)/30)/F40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(G17),ISNUMBER(G28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G17*7.48051945,G17)/31)/G40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(H17),ISNUMBER(H28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H17*7.48051945,H17)/30)/H40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(I17),ISNUMBER(I28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I17*7.48051945,I17)/31)/I40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(J17),ISNUMBER(J28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J17*7.48051945,J17)/31)/J40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(K17),ISNUMBER(K28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K17*7.48051945,K17)/30)/K40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(L17),ISNUMBER(L28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L17*7.48051945,L17)/31)/L40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(M17),ISNUMBER(M28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M17*7.48051945,M17)/30)/M40,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(N17),ISNUMBER(N28)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N17*7.48051945,N17)/31)/N40,\"No Data\")","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T17=\"N/A\",R40=\"N/A\",R40=0),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T17*7.48051945,T17)/(R40*365))","v":"N/A"},null,null,null,0,0]
[null,"",{"$f":"IF(AND(ISNUMBER(C18),ISNUMBER(C29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C18*7.48051945,C18)/31)/C41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(D18),ISNUMBER(D29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D18*7.48051945,D18)/28)/D41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(E18),ISNUMBER(E29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E18*7.48051945,E18)/31)/E41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(F18),ISNUMBER(F29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F18*7.48051945,F18)/30)/F41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(G18),ISNUMBER(G29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G18*7.48051945,G18)/31)/G41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(H18),ISNUMBER(H29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H18*7.48051945,H18)/30)/H41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(I18),ISNUMBER(I29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I18*7.48051945,I18)/31)/I41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(J18),ISNUMBER(J29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J18*7.48051945,J18)/31)/J41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(K18),ISNUMBER(K29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K18*7.48051945,K18)/30)/K41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(L18),ISNUMBER(L29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L18*7.48051945,L18)/31)/L41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(M18),ISNUMBER(M29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M18*7.48051945,M18)/30)/M41,\"No Data\")","v":"No Data"},{"$f":"IF(AND(ISNUMBER(N18),ISNUMBER(N29)),(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N18*7.48051945,N18)/31)/N41,\"No Data\")","v":"No Data"},null,null,null,"",{"$f":"IF(OR(T18=\"N/A\",R41=\"N/A\",R41=0),\"N/A\",IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",T18*7.48051945,T18)/(R41*365))","v":"N/A"},null,null,null,0,0]
[]
[null,"COMMENTS:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]

{"sheet":"5. ICI & Other Metered","index":4,"n_rows":42,"n_cols":25,"rows_kept":42,"cut":false,"hidden":false,"merged":[[9,17,10,17],[9,19,10,19],[1,1,2,2],[32,1,35,13],[9,24,10,24],[21,24,22,24],[3,1,3,3],[5,16,5,20],[1,4,3,12],[21,17,22,17],[21,19,22,19],[5,6,6,8]]}
[]
[null,"DATA INPUT SHEET",null,null,"5. INDUSTRIAL, COMMERCIAL & INSTITUTIONAL (ICI) AND OTHER METERED "]
[]
[]
[null,null,{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""}]
[null,null,null,null,null,null,"MONTHLY DATA",null,null,null,null,null,null,null,null,null,"ANNUAL DATA"]
[null,"Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1. Instructions and Notations'!E31","v":0},"TO",{"$f":"'1. Instructions and Notations'!I31","v":""}]
[null,"TABLE 5.1",null,null,{"$f":"IF('1. Instructions and Notations'!$E$38=\"Choose units...\",\"        First select reporting units for volume data on the instructions worksheet\",\"\")","v":"        First select reporting units for volume data on the instructions worksheet"},null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 5.3",null,"TABLE 5.4",null,null,null,null,"TABLE 5.5"]
[null,{"$f":"\"ICI WATER CONSUMPTION (\"&'1. Instructions and Notations'!E38&\")\"","v":"ICI WATER CONSUMPTION (Choose units...)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ICI ANNUAL CONSUMPTION",null,"ICI GPCD ",null,null,null,null,"ICI ANNUAL CALCULATED"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"'3. Single-family'!B16","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W12=0,R12=0),\"N/A\",(IF(W12=1,AVERAGE(C12:N12)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R12*7.48051945,R12)/12)/30.41667/'7. Total Diverted'!T47))","v":"N/A"},null,null,{"$f":"IF(OR(C12=0,D12=0,E12=0,F12=0,G12=0,H12=0,I12=0,J12=0,K12=0,L12=0,M12=0,N12=0),0,1)","v":0},null,{"$f":"IF(W12=1,SUM(C12:N12),IF(R12=0,\"N/A\",R12))","v":"N/A"}]
[null,{"$f":"'3. Single-family'!B17","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W13=0,R13=0),\"N/A\",(IF(W13=1,AVERAGE(C13:N13)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R13*7.48051945,R13)/12)/30.41667/'7. Total Diverted'!T48))","v":"N/A"},null,null,{"$f":"IF(OR(C13=0,D13=0,E13=0,F13=0,G13=0,H13=0,I13=0,J13=0,K13=0,L13=0,M13=0,N13=0),0,1)","v":0},null,{"$f":"IF(W13=1,SUM(C13:N13),IF(R13=0,\"N/A\",R13))","v":"N/A"}]
[null,{"$f":"'3. Single-family'!B18","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W14=0,R14=0),\"N/A\",(IF(W14=1,AVERAGE(C14:N14)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R14*7.48051945,R14)/12)/30.41667/'7. Total Diverted'!T49))","v":"N/A"},null,null,0,null,"N/A"]
[null,{"$f":"'3. Single-family'!B19","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W15=0,R15=0),\"N/A\",(IF(W15=1,AVERAGE(C15:N15)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R15*7.48051945,R15)/12)/30.41667/'7. Total Diverted'!T50))","v":"N/A"},null,null,{"$f":"IF(OR(C15=0,D15=0,E15=0,F15=0,G15=0,H15=0,I15=0,J15=0,K15=0,L15=0,M15=0,N15=0),0,1)","v":0},null,"N/A"]
[null,{"$f":"'3. Single-family'!B20","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W16=0,R16=0),\"N/A\",(IF(W16=1,AVERAGE(C16:N16)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R16*7.48051945,R16)/12)/30.41667/'7. Total Diverted'!T51))","v":"N/A"},null,null,0,null,"N/A"]
[null,{"$f":"'3. Single-family'!B21","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W17=0,R17=0),\"N/A\",(IF(W17=1,AVERAGE(C17:N17)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R17*7.48051945,R17)/12)/30.41667/'7. Total Diverted'!T52))","v":"N/A"},null,null,0,null,"N/A"]
[null,{"$f":"'3. Single-family'!B22","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W18=0,R18=0),\"N/A\",(IF(W18=1,AVERAGE(C18:N18)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R18*7.48051945,R18)/12)/30.41667/'7. Total Diverted'!T53))","v":"N/A"},null,null,0,null,"N/A"]
[]
[]
[null,"TABLE 5.2",null,{"$f":"IF('1. Instructions and Notations'!$E$38=\"Choose units…\",\"        First select reporting units for volume data on the instructions worksheet\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 5.6",null,"TABLE 5.7",null,null,null,null,"TABLE 5.8"]
[null,{"$f":"\"OTHER METERED (\"&'1. Instructions and Notations'!E38&\")\"","v":"OTHER METERED (Choose units...)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER ANNUAL CONSUMPTION",null,"OTHER METERED GPCD ",null,null,null,null,"OTHER ANNUAL CALCULATED"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B12","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W24=0,R24=0),\"N/A\",(IF(W24=1,AVERAGE(C24:N24)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R24*7.48051945,R24)/12)/30.41667/'7. Total Diverted'!T47))","v":"N/A"},null,null,{"$f":"IF(OR(C24=0,D24=0,E24=0,F24=0,G24=0,H24=0,I24=0,J24=0,K24=0,L24=0,M24=0,N24=0),0,1)","v":0},null,{"$f":"IF(W24=1,SUM(C24:N24),IF(R24=0,\"N/A\",R24))","v":"N/A"}]
[null,{"$f":"B13","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W25=0,R25=0),\"N/A\",(IF(W25=1,AVERAGE(C25:N25)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R25*7.48051945,R25)/12)/30.41667/'7. Total Diverted'!T48))","v":"N/A"},null,null,0,null,{"$f":"IF(W25=1,SUM(C25:N25),IF(R25=0,\"N/A\",R25))","v":"N/A"}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W26=0,R26=0),\"N/A\",(IF(W26=1,AVERAGE(C26:N26)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R26*7.48051945,R26)/12)/30.41667/'7. Total Diverted'!T49))","v":"N/A"},null,null,0,null,"N/A"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W27=0,R27=0),\"N/A\",(IF(W27=1,AVERAGE(C27:N27)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R27*7.48051945,R27)/12)/30.41667/'7. Total Diverted'!T50))","v":"N/A"},null,null,0,null,"N/A"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W28=0,R28=0),\"N/A\",(IF(W28=1,AVERAGE(C28:N28)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R28*7.48051945,R28)/12)/30.41667/'7. Total Diverted'!T51))","v":"N/A"},null,null,0,null,"N/A"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W29=0,R29=0),\"N/A\",(IF(W29=1,AVERAGE(C29:N29)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R29*7.48051945,R29)/12)/30.41667/'7. Total Diverted'!T52))","v":"N/A"},null,null,0,null,"N/A"]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W30=0,R30=0),\"N/A\",(IF(W30=1,AVERAGE(C30:N30)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R30*7.48051945,R30)/12)/30.41667/'7. Total Diverted'!T53))","v":"N/A"},null,null,0,null,"N/A"]
[]
[null,"COMMENTS:"]
[]
[]
[]
[]
[]
[null,{"$f":"B15","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C38:N38)=0,\"No Data\",((AVERAGE(C38:N38)/30.41667)/#REF!))","v":"No Data"}]
[null,{"$f":"B16","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C39:N39)=0,\"No Data\",((AVERAGE(C39:N39)/30.41667)/#REF!))","v":"No Data"}]
[null,{"$f":"B17","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C40:N40)=0,\"No Data\",((AVERAGE(C40:N40)/30.41667)/#REF!))","v":"No Data"}]
[null,{"$f":"B18","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C41:N41)=0,\"No Data\",((AVERAGE(C41:N41)/30.41667)/#REF!))","v":"No Data"}]
[null,{"$f":"B19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C42:N42)=0,\"No Data\",((AVERAGE(C42:N42)/30.41667)/#REF!))","v":"No Data"}]

{"sheet":"6. Reuse","index":5,"n_rows":31,"n_cols":25,"rows_kept":31,"cut":false,"hidden":false,"merged":[[31,1,34,13],[9,24,10,24],[3,1,3,3],[5,16,5,20],[1,4,3,12],[5,6,6,8],[9,17,10,17],[9,19,10,19],[1,1,2,2]]}
[]
[null,"DATA INPUT SHEET",null,null,"6. REUSE"]
[]
[]
[null,null,{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""}]
[null,null,null,null,null,null,"MONTHLY DATA",null,null,null,null,null,null,null,null,null,"ANNUAL DATA"]
[null,"Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'1. Instructions and Notations'!E31","v":0},"TO",{"$f":"'1. Instructions and Notations'!I31","v":""}]
[null,"TABLE 6.1",null,null,{"$f":"IF('1. Instructions and Notations'!$E$38=\"Choose units...\",\"        First select reporting units for volume data on the instructions worksheet\",\"\")","v":"        First select reporting units for volume data on the instructions worksheet"},null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 6.2",null,"TABLE 6.3"]
[null,{"$f":"\"REUSE DIVERSIONS (Monthly) (\"&'1. Instructions and Notations'!E38&\")\"","v":"REUSE DIVERSIONS (Monthly) (Choose units...)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REUSE ANNUAL DIVERSIONS",null,"REUSE GPCD ",null,null,null,null,"Annual Reuse"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"'3. Single-family'!B16","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W12=0,R12=0),\"N/A\",(IF(W12=1,AVERAGE(C12:N12)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R12*7.48051945,R12)/12)/30.41667/'7. Total Diverted'!W11))","v":"N/A"},null,null,{"$f":"IF(OR(C12=0,D12=0,E12=0,F12=0,G12=0,H12=0,I12=0,J12=0,K12=0,L12=0,M12=0,N12=0),0,1)","v":0},null,{"$f":"IF(W12=1,SUM(C12:N12),IF(R12=0,\"N/A\",R12))","v":"N/A"}]
[null,{"$f":"'3. Single-family'!B17","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W13=0,R13=0),\"N/A\",(IF(W13=1,AVERAGE(C13:N13)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R13*7.48051945,R13)/12)/30.41667/'7. Total Diverted'!W12))","v":"N/A"},null,null,0,null,"N/A"]
[null,{"$f":"'3. Single-family'!B18","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W14=0,R14=0),\"N/A\",(IF(W14=1,AVERAGE(C14:N14)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R14*7.48051945,R14)/12)/30.41667/'7. Total Diverted'!W13))","v":"N/A"},null,null,0,null,"N/A"]
[null,{"$f":"'3. Single-family'!B19","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W15=0,R15=0),\"N/A\",(IF(W15=1,AVERAGE(C15:N15)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R15*7.48051945,R15)/12)/30.41667/'7. Total Diverted'!W14))","v":"N/A"},null,null,0,null,"N/A"]
[null,{"$f":"'3. Single-family'!B20","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W16=0,R16=0),\"N/A\",(IF(W16=1,AVERAGE(C16:N16)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R16*7.48051945,R16)/12)/30.41667/'7. Total Diverted'!W15))","v":"N/A"},null,null,0,null,"N/A"]
[null,{"$f":"'3. Single-family'!B21","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W17=0,R17=0),\"N/A\",(IF(W17=1,AVERAGE(C17:N17)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R17*7.48051945,R17)/12)/30.41667/'7. Total Diverted'!W16))","v":"N/A"},null,null,0,null,"N/A"]
[null,{"$f":"'3. Single-family'!B22","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W18=0,R18=0),\"N/A\",(IF(W18=1,AVERAGE(C18:N18)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1),IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",R18*7.48051945,R18)/12)/30.41667/'7. Total Diverted'!W17))","v":"N/A"},null,null,0,null,"N/A"]
[]
[null,"REUSE CONSUMPTION"]
[]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC",null,null,null,"ANNUAL REUSE",null,"ANNUAL REUSE",null,null,"TOTAL GPCD W/REUSE"]
[null,{"$f":"B13","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C23:N23)=0,\"No Data\",((AVERAGE(C23:N23)/30.41667)/#REF!))","v":"No Data"}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C24:N24)=0,\"No Data\",((AVERAGE(C24:N24)/30.41667)/#REF!))","v":"No Data"}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C25:N25)=0,\"No Data\",((AVERAGE(C25:N25)/30.41667)/#REF!))","v":"No Data"}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C26:N26)=0,\"No Data\",((AVERAGE(C26:N26)/30.41667)/#REF!))","v":"No Data"}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C27:N27)=0,\"No Data\",((AVERAGE(C27:N27)/30.41667)/#REF!))","v":"No Data"}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C28:N28)=0,\"No Data\",((AVERAGE(C28:N28)/30.41667)/#REF!))","v":"No Data"}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C29:N29)=0,\"No Data\",((AVERAGE(C29:N29)/30.41667)/#REF!))","v":"No Data"}]
[]
[null,"COMMENTS:"]

{"sheet":"7. Total Diverted","index":6,"n_rows":67,"n_cols":24,"rows_kept":67,"cut":false,"hidden":false,"merged":[[8,22,9,22],[20,17,21,17],[32,17,33,17],[56,18,57,18],[67,1,70,13],[56,19,57,19],[8,17,9,17],[44,19,45,19],[56,1,56,2],[20,1,20,3],[44,17,45,17],[20,19,21,19],[32,19,33,19],[32,1,32,3],[1,1,2,2],[8,1,8,3],[5,0,5,14],[1,5,3,11],[5,16,5,20],[8,19,9,19]]}
[]
[null,"DATA INPUT SHEET",null,null,null,"7. TOTAL WATER DIVERTED AND SUPPLIED"]
[]
[]
[null,null,{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""}]
["MONTHLY DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL DATA"]
[]
[null,"TABLE 7.1",null,null,{"$f":"IF('1. Instructions and Notations'!$E$38=\"Choose units...\",\"        First select reporting units for volume data on the instructions worksheet\",\"\")","v":"        First select reporting units for volume data on the instructions worksheet"},null,null,null,null,null,null,{"$f":"'1. Instructions and Notations'!E31","v":0},"TO",{"$f":"'1. Instructions and Notations'!I31","v":""},null,null,null,"TABLE 7.6",null,"TABLE 7.7",null,null,"TABLE 6.6"]
[null,{"$f":"\"TOTAL WATER DIVERTED (Monthly) (\"&'1. Instructions and Notations'!E38&\")\"","v":"TOTAL WATER DIVERTED (Monthly) (Choose units...)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL TOTAL DIVERTED",null,"ANNUAL TOTAL DIVERTED CALC",null,null,"TOTAL POP. EST."]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"'3. Single-family'!B16","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X11=1,SUM(C11:N11),IF(R11=0,\"N/A\",R11))","v":"N/A"},null,null,{"$f":"T47","v":"N/A"},{"$f":"IF(OR(C11=0,D11=0,E11=0,F11=0,G11=0,H11=0,I11=0,J11=0,K11=0,L11=0,M11=0,N11=0),0,1)","v":0}]
[null,{"$f":"'3. Single-family'!B17","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,{"$f":"T48","v":"N/A"},0]
[null,{"$f":"'3. Single-family'!B18","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,"N/A",0]
[null,{"$f":"'3. Single-family'!B19","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,"N/A",0]
[null,{"$f":"'3. Single-family'!B20","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,"N/A",0]
[null,{"$f":"'3. Single-family'!B21","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,"N/A",0]
[null,{"$f":"'3. Single-family'!B22","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,"N/A",0]
[]
[]
[null,"TABLE 7.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 7.8",null,"TABLE 7.9"]
[null,{"$f":"\"IMPORTED WATER (Monthly)(\"&'1. Instructions and Notations'!E38&\")\"","v":"IMPORTED WATER (Monthly)(Choose units...)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL TOTAL IMPORTED",null,"ANNUAL TOTAL IMPORT CALC"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B11","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X23=1,SUM(C23:N23),IF(R23=0,\"N/A\",R23))","v":"N/A"},null,null,null,{"$f":"IF(OR(C23=0,D23=0,E23=0,F23=0,G23=0,H23=0,I23=0,J23=0,K23=0,L23=0,M23=0,N23=0),0,1)","v":0}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[]
[]
[null,"TABLE 7.3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 7.10",null,"TABLE 7.11"]
[null,{"$f":"\"EXPORTED WATER (Monthly) (\"&'1. Instructions and Notations'!E38&\")\"","v":"EXPORTED WATER (Monthly) (Choose units...)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL TOTAL EXPORTED",null,"ANNUAL TOTAL EXPORT CALC"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B11","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X35=1,SUM(C35:N35),IF(R35=0,\"N/A\",R35))","v":"N/A"},null,null,null,{"$f":"IF(OR(C35=0,D35=0,E35=0,F35=0,G35=0,H35=0,I35=0,J35=0,K35=0,L35=0,M35=0,N35=0),0,1)","v":0}]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,0]
[]
[]
[null,"TABLE 7.4",null,null,null,"Formula = Total Water Diverted + Imported water - Exported Water",null,null,null,null,null,null,null,null,null,null,null,"TABLE 7.12",null,"TABLE 7.13"]
[null,{"$f":"\"TOTAL WATER SUPPLY (Monthly) (\"&'1. Instructions and Notations'!E38&\")\"","v":"TOTAL WATER SUPPLY (Monthly) (Choose units...)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL TOTAL WATER SUPPLY",null,{"$f":"W9","v":"TOTAL POP. EST."}]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B11","v":""},{"$f":"C11+C23-C35","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(T11=\"N/A\",0,T11)+IF(T23=\"N/A\",0,T23)-IF(T35=\"N/A\",0,T35)","v":0},null,{"$f":"IF('3. Single-family'!T49=\"N/A\",\"N/A\",'3. Single-family'!T49+IF('4. Multi-family'!R35=\"N/A\",0,'4. Multi-family'!R35)+'2. Census Data'!$E$13)","v":"N/A"},null,null,null,{"$f":"IF(OR(C47=0,D47=0,E47=0,F47=0,G47=0,H47=0,I47=0,J47=0,K47=0,L47=0,M47=0,N47=0),0,1)","v":0}]
[null,{"$f":"B12","v":""},{"$f":"C12+C24-C36","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(T12=\"N/A\",0,T12)+IF(T24=\"N/A\",0,T24)-IF(T36=\"N/A\",0,T36)","v":0},null,{"$f":"IF('3. Single-family'!T50=\"N/A\",\"N/A\",'3. Single-family'!T50+IF('4. Multi-family'!R36=\"N/A\",0,'4. Multi-family'!R36)+'2. Census Data'!$E$13)","v":"N/A"},null,null,null,0]
[null,"",{"$f":"C13+C25-C37","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,null,{"$f":"IF('3. Single-family'!T51=\"N/A\",\"N/A\",'3. Single-family'!T51+IF('4. Multi-family'!R37=\"N/A\",0,'4. Multi-family'!R37)+'2. Census Data'!$E$13)","v":"N/A"},null,null,null,0]
[null,"",{"$f":"C14+C26-C38","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,null,{"$f":"IF('3. Single-family'!T52=\"N/A\",\"N/A\",'3. Single-family'!T52+IF('4. Multi-family'!R38=\"N/A\",0,'4. Multi-family'!R38)+'2. Census Data'!$E$13)","v":"N/A"},null,null,null,0]
[null,"",{"$f":"C15+C27-C39","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,null,{"$f":"IF('3. Single-family'!T53=\"N/A\",\"N/A\",'3. Single-family'!T53+IF('4. Multi-family'!R39=\"N/A\",0,'4. Multi-family'!R39)+'2. Census Data'!$E$13)","v":"N/A"},null,null,null,0]
[null,"",{"$f":"C16+C28-C40","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,null,{"$f":"IF('3. Single-family'!T54=\"N/A\",\"N/A\",'3. Single-family'!T54+IF('4. Multi-family'!R40=\"N/A\",0,'4. Multi-family'!R40)+'2. Census Data'!$E$13)","v":"N/A"},null,null,null,0]
[null,"",{"$f":"C17+C29-C41","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,0,null,{"$f":"IF('3. Single-family'!T55=\"N/A\",\"N/A\",'3. Single-family'!T55+IF('4. Multi-family'!R41=\"N/A\",0,'4. Multi-family'!R41)+'2. Census Data'!$E$13)","v":"N/A"},null,null,null,0]
[]
[]
[null,"Table 7.5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 7.14"]
[null,"SYSTEM TOTAL GPCD (Monthly) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","SYSTEM TOTAL GPCD"]
[null,"Year","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
[null,{"$f":"B11","v":""},{"$f":"IF(OR(C47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C47*7.48051945,C47)/31)/T47)","v":"No Data"},{"$f":"IF(OR(D47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D47*7.48051945,D47)/28)/T47)","v":"No Data"},{"$f":"IF(OR(E47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E47*7.48051945,E47)/31)/T47)","v":"No Data"},{"$f":"IF(OR(F47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F47*7.48051945,F47)/30)/T47)","v":"No Data"},{"$f":"IF(OR(G47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G47*7.48051945,G47)/31)/T47)","v":"No Data"},{"$f":"IF(OR(H47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H47*7.48051945,H47)/30)/T47)","v":"No Data"},{"$f":"IF(OR(I47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I47*7.48051945,I47)/31)/T47)","v":"No Data"},{"$f":"IF(OR(J47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J47*7.48051945,J47)/31)/T47)","v":"No Data"},{"$f":"IF(OR(K47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K47*7.48051945,K47)/30)/T47)","v":"No Data"},{"$f":"IF(OR(L47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L47*7.48051945,L47)/31)/T47)","v":"No Data"},{"$f":"IF(OR(M47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M47*7.48051945,M47)/30)/T47)","v":"No Data"},{"$f":"IF(OR(N47=0,T47=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N47*7.48051945,N47)/31)/T47)","v":"No Data"},null,null,null,null,{"$f":"B47","v":""},{"$f":"IF(AND(X47=0,R47=0),\"NA\",(IF(X47=1,SUM(C47:N47),R47)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1)/(T47*365)))","v":"NA"}]
[null,"",{"$f":"IF(OR(C48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C48*7.48051945,C48)/31)/T48)","v":"No Data"},{"$f":"IF(OR(D48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D48*7.48051945,D48)/28)/T48)","v":"No Data"},{"$f":"IF(OR(E48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E48*7.48051945,E48)/31)/T48)","v":"No Data"},{"$f":"IF(OR(F48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F48*7.48051945,F48)/30)/T48)","v":"No Data"},{"$f":"IF(OR(G48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G48*7.48051945,G48)/31)/T48)","v":"No Data"},{"$f":"IF(OR(H48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H48*7.48051945,H48)/30)/T48)","v":"No Data"},{"$f":"IF(OR(I48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I48*7.48051945,I48)/31)/T48)","v":"No Data"},{"$f":"IF(OR(J48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J48*7.48051945,J48)/31)/T48)","v":"No Data"},{"$f":"IF(OR(K48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K48*7.48051945,K48)/30)/T48)","v":"No Data"},{"$f":"IF(OR(L48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L48*7.48051945,L48)/31)/T48)","v":"No Data"},{"$f":"IF(OR(M48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M48*7.48051945,M48)/30)/T48)","v":"No Data"},{"$f":"IF(OR(N48=0,T48=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N48*7.48051945,N48)/31)/T48)","v":"No Data"},null,null,null,null,{"$f":"B48","v":""},{"$f":"IF(AND(X48=0,R48=0),\"NA\",(IF(X48=1,SUM(C48:N48),R48)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1)/(T48*365)))","v":"NA"}]
[null,"",{"$f":"IF(OR(C49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C49*7.48051945,C49)/31)/T49)","v":"No Data"},{"$f":"IF(OR(D49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D49*7.48051945,D49)/28)/T49)","v":"No Data"},{"$f":"IF(OR(E49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E49*7.48051945,E49)/31)/T49)","v":"No Data"},{"$f":"IF(OR(F49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F49*7.48051945,F49)/30)/T49)","v":"No Data"},{"$f":"IF(OR(G49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G49*7.48051945,G49)/31)/T49)","v":"No Data"},{"$f":"IF(OR(H49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H49*7.48051945,H49)/30)/T49)","v":"No Data"},{"$f":"IF(OR(I49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I49*7.48051945,I49)/31)/T49)","v":"No Data"},{"$f":"IF(OR(J49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J49*7.48051945,J49)/31)/T49)","v":"No Data"},{"$f":"IF(OR(K49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K49*7.48051945,K49)/30)/T49)","v":"No Data"},{"$f":"IF(OR(L49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L49*7.48051945,L49)/31)/T49)","v":"No Data"},{"$f":"IF(OR(M49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M49*7.48051945,M49)/30)/T49)","v":"No Data"},{"$f":"IF(OR(N49=0,T49=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N49*7.48051945,N49)/31)/T49)","v":"No Data"},null,null,null,null,"",{"$f":"IF(AND(X49=0,R49=0),\"NA\",(IF(X49=1,SUM(C49:N49),R49)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1)/(T49*365)))","v":"NA"}]
[null,"",{"$f":"IF(OR(C50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C50*7.48051945,C50)/31)/T50)","v":"No Data"},{"$f":"IF(OR(D50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D50*7.48051945,D50)/28)/T50)","v":"No Data"},{"$f":"IF(OR(E50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E50*7.48051945,E50)/31)/T50)","v":"No Data"},{"$f":"IF(OR(F50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F50*7.48051945,F50)/30)/T50)","v":"No Data"},{"$f":"IF(OR(G50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G50*7.48051945,G50)/31)/T50)","v":"No Data"},{"$f":"IF(OR(H50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H50*7.48051945,H50)/30)/T50)","v":"No Data"},{"$f":"IF(OR(I50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I50*7.48051945,I50)/31)/T50)","v":"No Data"},{"$f":"IF(OR(J50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J50*7.48051945,J50)/31)/T50)","v":"No Data"},{"$f":"IF(OR(K50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K50*7.48051945,K50)/30)/T50)","v":"No Data"},{"$f":"IF(OR(L50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L50*7.48051945,L50)/31)/T50)","v":"No Data"},{"$f":"IF(OR(M50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M50*7.48051945,M50)/30)/T50)","v":"No Data"},{"$f":"IF(OR(N50=0,T50=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N50*7.48051945,N50)/31)/T50)","v":"No Data"},null,null,null,null,"",{"$f":"IF(AND(X50=0,R50=0),\"NA\",(IF(X50=1,SUM(C50:N50),R50)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1)/(T50*365)))","v":"NA"}]
[null,"",{"$f":"IF(OR(C51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C51*7.48051945,C51)/31)/T51)","v":"No Data"},{"$f":"IF(OR(D51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D51*7.48051945,D51)/28)/T51)","v":"No Data"},{"$f":"IF(OR(E51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E51*7.48051945,E51)/31)/T51)","v":"No Data"},{"$f":"IF(OR(F51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F51*7.48051945,F51)/30)/T51)","v":"No Data"},{"$f":"IF(OR(G51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G51*7.48051945,G51)/31)/T51)","v":"No Data"},{"$f":"IF(OR(H51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H51*7.48051945,H51)/30)/T51)","v":"No Data"},{"$f":"IF(OR(I51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I51*7.48051945,I51)/31)/T51)","v":"No Data"},{"$f":"IF(OR(J51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J51*7.48051945,J51)/31)/T51)","v":"No Data"},{"$f":"IF(OR(K51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K51*7.48051945,K51)/30)/T51)","v":"No Data"},{"$f":"IF(OR(L51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L51*7.48051945,L51)/31)/T51)","v":"No Data"},{"$f":"IF(OR(M51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M51*7.48051945,M51)/30)/T51)","v":"No Data"},{"$f":"IF(OR(N51=0,T51=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N51*7.48051945,N51)/31)/T51)","v":"No Data"},null,null,null,null,"",{"$f":"IF(AND(X51=0,R51=0),\"NA\",(IF(X51=1,SUM(C51:N51),R51)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1)/(T51*365)))","v":"NA"}]
[null,"",{"$f":"IF(OR(C52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C52*7.48051945,C52)/31)/T52)","v":"No Data"},{"$f":"IF(OR(D52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D52*7.48051945,D52)/28)/T52)","v":"No Data"},{"$f":"IF(OR(E52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E52*7.48051945,E52)/31)/T52)","v":"No Data"},{"$f":"IF(OR(F52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F52*7.48051945,F52)/30)/T52)","v":"No Data"},{"$f":"IF(OR(G52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G52*7.48051945,G52)/31)/T52)","v":"No Data"},{"$f":"IF(OR(H52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H52*7.48051945,H52)/30)/T52)","v":"No Data"},{"$f":"IF(OR(I52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I52*7.48051945,I52)/31)/T52)","v":"No Data"},{"$f":"IF(OR(J52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J52*7.48051945,J52)/31)/T52)","v":"No Data"},{"$f":"IF(OR(K52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K52*7.48051945,K52)/30)/T52)","v":"No Data"},{"$f":"IF(OR(L52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L52*7.48051945,L52)/31)/T52)","v":"No Data"},{"$f":"IF(OR(M52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M52*7.48051945,M52)/30)/T52)","v":"No Data"},{"$f":"IF(OR(N52=0,T52=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N52*7.48051945,N52)/31)/T52)","v":"No Data"},null,null,null,null,"",{"$f":"IF(AND(X52=0,R52=0),\"NA\",(IF(X52=1,SUM(C52:N52),R52)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1)/(T52*365)))","v":"NA"}]
[null,"",{"$f":"IF(OR(C53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",C53*7.48051945,C53)/31)/T53)","v":"No Data"},{"$f":"IF(OR(D53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",D53*7.48051945,D53)/28)/T53)","v":"No Data"},{"$f":"IF(OR(E53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",E53*7.48051945,E53)/31)/T53)","v":"No Data"},{"$f":"IF(OR(F53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",F53*7.48051945,F53)/30)/T53)","v":"No Data"},{"$f":"IF(OR(G53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",G53*7.48051945,G53)/31)/T53)","v":"No Data"},{"$f":"IF(OR(H53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",H53*7.48051945,H53)/30)/T53)","v":"No Data"},{"$f":"IF(OR(I53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",I53*7.48051945,I53)/31)/T53)","v":"No Data"},{"$f":"IF(OR(J53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",J53*7.48051945,J53)/31)/T53)","v":"No Data"},{"$f":"IF(OR(K53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",K53*7.48051945,K53)/30)/T53)","v":"No Data"},{"$f":"IF(OR(L53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",L53*7.48051945,L53)/31)/T53)","v":"No Data"},{"$f":"IF(OR(M53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",M53*7.48051945,M53)/30)/T53)","v":"No Data"},{"$f":"IF(OR(N53=0,T53=\"NA\"),\"No Data\",(IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",N53*7.48051945,N53)/31)/T53)","v":"No Data"},null,null,null,null,"",{"$f":"IF(AND(X53=0,R53=0),\"NA\",(IF(X53=1,SUM(C53:N53),R53)*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1)/(T53*365)))","v":"NA"}]
[]
[null,"COMMENTS:"]

{"sheet":"8. Reported Data","index":7,"n_rows":83,"n_cols":13,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,10,1,12],[2,10,2,12],[1,1,1,7]]}
[]
[null,"8. SUMMARY GPCD REPORTED DATA",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""},{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""},{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""}]
[]
[null,"ANNUAL",null,null,null,null,null,null,null,null,{"$f":"'1. Instructions and Notations'!E31","v":0},"To:",{"$f":"'1. Instructions and Notations'!I31","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Year","SYSTEM GPCD"]
[null,{"$f":"'3. Single-family'!B16","v":""},{"$f":"'7. Total Diverted'!T59","v":"NA"}]
[null,{"$f":"'3. Single-family'!B17","v":""},{"$f":"'7. Total Diverted'!T60","v":"NA"}]
[null,{"$f":"'3. Single-family'!B18","v":""},{"$f":"'7. Total Diverted'!T61","v":"NA"}]
[null,{"$f":"'3. Single-family'!B19","v":""},{"$f":"'7. Total Diverted'!T62","v":"NA"}]
[null,{"$f":"'3. Single-family'!B20","v":""},{"$f":"'7. Total Diverted'!T63","v":"NA"}]
[null,{"$f":"'3. Single-family'!B21","v":""},{"$f":"'7. Total Diverted'!T64","v":"NA"}]
[null,{"$f":"'3. Single-family'!B22","v":""},{"$f":"'7. Total Diverted'!T65","v":"NA"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"MONTHLY"]
[]
[]
[]
[null,"Month","SFR GPCD"]
[null,"January",{"$f":"'10. Monthly Performance'!E12","v":{"$error":"#N/A"}}]
[null,"February",{"$f":"'10. Monthly Performance'!E13","v":{"$error":"#N/A"}}]
[null,"March",{"$f":"'10. Monthly Performance'!E14","v":{"$error":"#N/A"}}]
[null,"April",{"$f":"'10. Monthly Performance'!E15","v":{"$error":"#N/A"}}]
[null,"May",{"$f":"'10. Monthly Performance'!E16","v":{"$error":"#N/A"}}]
[null,"June",{"$f":"'10. Monthly Performance'!E17","v":{"$error":"#N/A"}}]
[null,"July",{"$f":"'10. Monthly Performance'!E18","v":{"$error":"#N/A"}}]
[null,"August",{"$f":"'10. Monthly Performance'!E19","v":{"$error":"#N/A"}}]
[null,"September",{"$f":"'10. Monthly Performance'!E20","v":{"$error":"#N/A"}}]
[null,"October",{"$f":"'10. Monthly Performance'!E21","v":{"$error":"#N/A"}}]
[null,"November",{"$f":"'10. Monthly Performance'!E22","v":{"$error":"#N/A"}}]
[null,"December",{"$f":"'10. Monthly Performance'!E23","v":{"$error":"#N/A"}}]
[]
[null,"Year",{"$f":"'10. Monthly Performance'!I4","v":0}]
[]
[null,"Peak/Ave",{"$f":"MAX(C43:C54)/AVERAGE(C43:C54)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,"YEAR",null,{"$f":"C56","v":0}]
[]
[]
[]
[]
[null,"Month","MFR GPCD"]
[null,"January",{"$f":"'10. Monthly Performance'!F12","v":{"$error":"#N/A"}}]
[null,"February",{"$f":"'10. Monthly Performance'!F13","v":{"$error":"#N/A"}}]
[null,"March",{"$f":"'10. Monthly Performance'!F14","v":{"$error":"#N/A"}}]
[null,"April",{"$f":"'10. Monthly Performance'!F15","v":{"$error":"#N/A"}}]
[null,"May",{"$f":"'10. Monthly Performance'!F16","v":{"$error":"#N/A"}}]
[null,"June",{"$f":"'10. Monthly Performance'!F17","v":{"$error":"#N/A"}}]
[null,"July",{"$f":"'10. Monthly Performance'!F18","v":{"$error":"#N/A"}}]
[null,"August",{"$f":"'10. Monthly Performance'!F19","v":{"$error":"#N/A"}}]
[null,"September",{"$f":"'10. Monthly Performance'!F20","v":{"$error":"#N/A"}}]
[null,"October",{"$f":"'10. Monthly Performance'!F21","v":{"$error":"#N/A"}}]
[null,"November",{"$f":"'10. Monthly Performance'!F22","v":{"$error":"#N/A"}}]
[null,"December",{"$f":"'10. Monthly Performance'!F23","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Peak/Ave",{"$f":"MAX(C66:C77)/AVERAGE(C66:C77)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,"YEAR",null,{"$f":"C56","v":0}]

{"sheet":"9. Annual Performance","index":8,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,5,19,7],[17,2,17,7],[18,2,18,7],[19,2,19,3]]}
[]
[null,"9. System Total Annual Reporting Performance"]
[]
[null,"Overall Annual GPCD (based on Total Population)"]
[]
[null,null,null,"SFR (System Total)","MFR (System Total)","ICI","Other Metered","Non-Revenue Water",null,"Total Supplied",null,{"$f":"\"Non-Revenue Volume \"&IF('1. Instructions and Notations'!E38=\"Choose units...\",\"\",IF('1. Instructions and Notations'!E38=\"Gallons (US)\",\"Million \",\"Thousand \")&'1. Instructions and Notations'!E38)","v":"Non-Revenue Volume "},null,null,null,null,null,null,{"$f":"D6","v":"SFR (System Total)"},{"$f":"E6","v":"MFR (System Total)"},{"$f":"F6","v":"ICI"},{"$f":"G6","v":"Other Metered"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"H6","v":"Non-Revenue Water"}]
[null,null,"Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C9","v":""},{"$f":"IF($D$8=\"Yes\",D9,\"Not Graphed\")","v":"N/A"},{"$f":"IF($E$8=\"Yes\",E9,\"Not Graphed\")","v":"N/A"},{"$f":"IF($F$8=\"Yes\",F9,\"Not Graphed\")","v":"N/A"},{"$f":"IF(G$8=\"Yes\",G9,\"Not Graphed\")","v":"N/A"},{"$f":"IF(#REF!=\"Yes\",#REF!,\"Not Graphed\")","v":{"$error":"#REF!"}},{"$f":"IF($H$8=\"Yes\",H9,\"Not Graphed\")","v":{"$error":"#VALUE!"}}]
[null,null,"On Graph?","Yes","Yes","Yes","Yes","Yes",null,null,null,null,null,null,null,null,null,"","N/A","N/A","N/A",{"$f":"IF($G$8=\"Yes\",G10,\"Not Graphed\")","v":"N/A"},{"$f":"IF(#REF!=\"Yes\",#REF!,\"Not Graphed\")","v":{"$error":"#REF!"}},{"$error":"#VALUE!"}]
[null,null,{"$f":"'3. Single-family'!B62","v":""},{"$f":"IF(OR('3. Single-family'!T16=\"N/A\",'7. Total Diverted'!W11=\"N/A\"),\"N/A\",'3. Single-family'!T16*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1)/('7. Total Diverted'!W11*365))","v":"N/A"},{"$f":"IF('4. Multi-family'!T12=\"N/A\",\"N/A\",'4. Multi-family'!T12*IF('1. Instructions and Notations'!$E$38=\"Cubic Feet\",7.48051945,1)/('7. Total Diverted'!W11*365))","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T12","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T24","v":"N/A"},{"$f":"IF('7. Total Diverted'!T59=\"N/A\",\"N/A\",'7. Total Diverted'!T59-SUM(D9:G9))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(D9:H9)","v":{"$error":"#VALUE!"}},null,{"$f":"IF('7. Total Diverted'!R47=\"N/A\",\"N/A\",('7. Total Diverted'!R47-IF('6. Reuse'!T12=\"N/A\",0,'6. Reuse'!T12)-IF('5. ICI & Other Metered'!Y12=\"N/A\",0,'5. ICI & Other Metered'!Y12)-IF('5. ICI & Other Metered'!Y24=\"N/A\",0,'5. ICI & Other Metered'!Y24)-IF('4. Multi-family'!T12=\"N/A\",0,'4. Multi-family'!T12)-IF('3. Single-family'!T16=\"N/A\",0,'3. Single-family'!T16))/IF('1. Instructions and Notations'!$E$38=\"Gallons (US)\",1000000,1000))","v":0},null,null,null,null,null,"","N/A","N/A","N/A","N/A",{"$f":"IF(#REF!=\"Yes\",#REF!,\"Not Graphed\")","v":{"$error":"#REF!"}},{"$error":"#VALUE!"}]
[null,null,{"$f":"'3. Single-family'!B63","v":""},{"$f":"IF(OR('3. Single-family'!T17=\"N/A\",'7. Total Diverted'!W12=\"N/A\"),\"N/A\",'3. Single-family'!T17/('7. Total Diverted'!W12*365))","v":"N/A"},{"$f":"IF('4. Multi-family'!T13=\"N/A\",\"N/A\",'4. Multi-family'!T13/('7. Total Diverted'!W12*365))","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T13","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T25","v":"N/A"},{"$f":"IF('7. Total Diverted'!T60=\"N/A\",\"N/A\",'7. Total Diverted'!T60-SUM(D10:G10))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(D10:H10)","v":{"$error":"#VALUE!"}},null,{"$f":"IF('7. Total Diverted'!R48=\"N/A\",\"N/A\",('7. Total Diverted'!R48-IF('6. Reuse'!T13=\"N/A\",0,'6. Reuse'!T13)-IF('5. ICI & Other Metered'!Y13=\"N/A\",0,'5. ICI & Other Metered'!Y13)-IF('5. ICI & Other Metered'!Y25=\"N/A\",0,'5. ICI & Other Metered'!Y25)-IF('4. Multi-family'!T13=\"N/A\",0,'4. Multi-family'!T13)-IF('3. Single-family'!T17=\"N/A\",0,'3. Single-family'!T17))/IF('1. Instructions and Notations'!$E$38=\"Gallons (US)\",1000000,1000))","v":0},null,null,null,null,null,"","N/A","N/A","N/A","N/A",{"$f":"IF(#REF!=\"Yes\",#REF!,\"Not Graphed\")","v":{"$error":"#REF!"}},{"$error":"#VALUE!"}]
[null,null,{"$f":"'3. Single-family'!B64","v":""},{"$f":"IF(OR('3. Single-family'!T18=\"N/A\",'7. Total Diverted'!W13=\"N/A\"),\"N/A\",'3. Single-family'!T18/('7. Total Diverted'!W13*365))","v":"N/A"},{"$f":"IF('4. Multi-family'!T14=\"N/A\",\"N/A\",'4. Multi-family'!T14/('7. Total Diverted'!W13*365))","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T14","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T26","v":"N/A"},{"$f":"IF('7. Total Diverted'!T61=\"N/A\",\"N/A\",'7. Total Diverted'!T61-SUM(D11:G11))","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},null,{"$f":"IF('7. Total Diverted'!R49=\"N/A\",\"N/A\",('7. Total Diverted'!R49-IF('6. Reuse'!T14=\"N/A\",0,'6. Reuse'!T14)-IF('5. ICI & Other Metered'!Y14=\"N/A\",0,'5. ICI & Other Metered'!Y14)-IF('5. ICI & Other Metered'!Y26=\"N/A\",0,'5. ICI & Other Metered'!Y26)-IF('4. Multi-family'!T14=\"N/A\",0,'4. Multi-family'!T14)-IF('3. Single-family'!T18=\"N/A\",0,'3. Single-family'!T18))/IF('1. Instructions and Notations'!$E$38=\"Gallons (US)\",1000000,1000))","v":0},null,null,null,null,null,"","N/A","N/A","N/A","N/A",{"$f":"IF(#REF!=\"Yes\",#REF!,\"Not Graphed\")","v":{"$error":"#REF!"}},{"$error":"#VALUE!"}]
[null,null,{"$f":"'3. Single-family'!B65","v":""},{"$f":"IF(OR('3. Single-family'!T19=\"N/A\",'7. Total Diverted'!W14=\"N/A\"),\"N/A\",'3. Single-family'!T19/('7. Total Diverted'!W14*365))","v":"N/A"},{"$f":"IF('4. Multi-family'!T15=\"N/A\",\"N/A\",'4. Multi-family'!T15/('7. Total Diverted'!W14*365))","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T15","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T27","v":"N/A"},{"$f":"IF('7. Total Diverted'!T62=\"N/A\",\"N/A\",'7. Total Diverted'!T62-SUM(D12:G12))","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},null,{"$f":"IF('7. Total Diverted'!R50=\"N/A\",\"N/A\",('7. Total Diverted'!R50-IF('6. Reuse'!T15=\"N/A\",0,'6. Reuse'!T15)-IF('5. ICI & Other Metered'!Y15=\"N/A\",0,'5. ICI & Other Metered'!Y15)-IF('5. ICI & Other Metered'!Y27=\"N/A\",0,'5. ICI & Other Metered'!Y27)-IF('4. Multi-family'!T15=\"N/A\",0,'4. Multi-family'!T15)-IF('3. Single-family'!T19=\"N/A\",0,'3. Single-family'!T19))/IF('1. Instructions and Notations'!$E$38=\"Gallons (US)\",1000000,1000))","v":0},null,null,null,null,null,"","N/A","N/A","N/A","N/A",{"$f":"IF(#REF!=\"Yes\",#REF!,\"Not Graphed\")","v":{"$error":"#REF!"}},{"$error":"#VALUE!"}]
[null,null,{"$f":"'3. Single-family'!B66","v":""},{"$f":"IF(OR('3. Single-family'!T20=\"N/A\",'7. Total Diverted'!W15=\"N/A\"),\"N/A\",'3. Single-family'!T20/('7. Total Diverted'!W15*365))","v":"N/A"},{"$f":"IF('4. Multi-family'!T16=\"N/A\",\"N/A\",'4. Multi-family'!T16/('7. Total Diverted'!W15*365))","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T16","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T28","v":"N/A"},{"$f":"IF('7. Total Diverted'!T63=\"N/A\",\"N/A\",'7. Total Diverted'!T63-SUM(D13:G13))","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},null,{"$f":"IF('7. Total Diverted'!R51=\"N/A\",\"N/A\",('7. Total Diverted'!R51-IF('6. Reuse'!T16=\"N/A\",0,'6. Reuse'!T16)-IF('5. ICI & Other Metered'!Y16=\"N/A\",0,'5. ICI & Other Metered'!Y16)-IF('5. ICI & Other Metered'!Y28=\"N/A\",0,'5. ICI & Other Metered'!Y28)-IF('4. Multi-family'!T16=\"N/A\",0,'4. Multi-family'!T16)-IF('3. Single-family'!T20=\"N/A\",0,'3. Single-family'!T20))/IF('1. Instructions and Notations'!$E$38=\"Gallons (US)\",1000000,1000))","v":0},null,null,null,null,null,"","N/A","N/A","N/A","N/A",{"$f":"IF(#REF!=\"Yes\",#REF!,\"Not Graphed\")","v":{"$error":"#REF!"}},{"$error":"#VALUE!"}]
[null,null,{"$f":"'3. Single-family'!B67","v":""},{"$f":"IF(OR('3. Single-family'!T21=\"N/A\",'7. Total Diverted'!W16=\"N/A\"),\"N/A\",'3. Single-family'!T21/('7. Total Diverted'!W16*365))","v":"N/A"},{"$f":"IF('4. Multi-family'!T17=\"N/A\",\"N/A\",'4. Multi-family'!T17/('7. Total Diverted'!W16*365))","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T17","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T29","v":"N/A"},{"$f":"IF('7. Total Diverted'!T64=\"N/A\",\"N/A\",'7. Total Diverted'!T64-SUM(D14:G14))","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},null,{"$f":"IF('7. Total Diverted'!R52=\"N/A\",\"N/A\",('7. Total Diverted'!R52-IF('6. Reuse'!T17=\"N/A\",0,'6. Reuse'!T17)-IF('5. ICI & Other Metered'!Y17=\"N/A\",0,'5. ICI & Other Metered'!Y17)-IF('5. ICI & Other Metered'!Y29=\"N/A\",0,'5. ICI & Other Metered'!Y29)-IF('4. Multi-family'!T17=\"N/A\",0,'4. Multi-family'!T17)-IF('3. Single-family'!T21=\"N/A\",0,'3. Single-family'!T21))/IF('1. Instructions and Notations'!$E$38=\"Gallons (US)\",1000000,1000))","v":0}]
[null,null,{"$f":"'3. Single-family'!B68","v":""},{"$f":"IF(OR('3. Single-family'!T22=\"N/A\",'7. Total Diverted'!W17=\"N/A\"),\"N/A\",'3. Single-family'!T22/('7. Total Diverted'!W17*365))","v":"N/A"},{"$f":"IF('4. Multi-family'!T18=\"N/A\",\"N/A\",'4. Multi-family'!T18/('7. Total Diverted'!W17*365))","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T18","v":"N/A"},{"$f":"'5. ICI & Other Metered'!T30","v":"N/A"},{"$f":"IF('7. Total Diverted'!T65=\"N/A\",\"N/A\",'7. Total Diverted'!T65-SUM(D15:G15))","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},null,{"$f":"IF('7. Total Diverted'!R53=\"N/A\",\"N/A\",('7. Total Diverted'!R53-IF('6. Reuse'!T18=\"N/A\",0,'6. Reuse'!T18)-IF('5. ICI & Other Metered'!Y18=\"N/A\",0,'5. ICI & Other Metered'!Y18)-IF('5. ICI & Other Metered'!Y30=\"N/A\",0,'5. ICI & Other Metered'!Y30)-IF('4. Multi-family'!T18=\"N/A\",0,'4. Multi-family'!T18)-IF('3. Single-family'!T22=\"N/A\",0,'3. Single-family'!T22))/IF('1. Instructions and Notations'!$E$38=\"Gallons (US)\",1000000,1000))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""}]
[]
[null,null,{"$f":"'1. Instructions and Notations'!E31","v":0},null,"to",{"$f":"'1. Instructions and Notations'!I31","v":""}]

{"sheet":"10. Monthly Performance","index":9,"n_rows":28,"n_cols":26,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,4,27,5],[27,7,27,8],[3,2,3,6],[5,4,5,8],[25,4,25,8],[26,4,26,8]]}
[]
[null,"10. Monthly Reporting Performance"]
[]
[null,null,"Choose Year for Monthly Analysis",null,null,null,null,null,null,null,null,"↓"]
[]
[null,null,"Choose Sector",null,"Single-Family Residential"]
[null,"Monthly GPCD"]
[]
[null,null,null,null,"Single-Family Residential","Multi-Family Residential","ICI","Other Metered","Non-Revenue",null,null,"Total of Sectors",null,null,{"$f":"E9","v":"Single-Family Residential"},{"$f":"F9","v":"Multi-Family Residential"},{"$f":"G9","v":"ICI"},{"$f":"H9","v":"Other Metered"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I9","v":"Non-Revenue"}]
[null,null,null,"Month","GPCD","GPCD","GPCD","GPCD","GPCD",null,null,null,null,"January",{"$f":"IF($E$6=\"Single-Family Residential\",E12,\"\")","v":{"$error":"#N/A"}},{"$f":"IF($E$6=\"Multi-Family Residential\",F12,\"\")","v":""},{"$f":"IF($E$6=\"ICI\",G12,\"\")","v":""},{"$f":"IF($E$6=\"Other Metered\",H12,\"\")","v":""},{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},{"$f":"IF($E$6=\"Non-Revenue\",I12,\"\")","v":""},null,null,null,null,"Single-Family Residential",{"$f":"'3. Single-family'!B16","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"February",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},"",null,null,null,null,"Multi-Family Residential",{"$f":"'3. Single-family'!B17","v":""}]
[null,null,null,"JAN",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M12/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M12/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M12/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(E12:I12)","v":{"$error":"#N/A"}},31,"March",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},"",null,"Yes",null,null,"ICI",{"$f":"'3. Single-family'!B18","v":""}]
[null,null,null,"FEB",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M13/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M13/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M13/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},28,"April",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},"",null,"No",null,null,"Other Metered",{"$f":"'3. Single-family'!B19","v":""}]
[null,null,null,"MAR",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M14/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M14/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M14/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},31,"May",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},"",null,null,null,null,"Reuse",{"$f":"'3. Single-family'!B20","v":""}]
[null,null,null,"APR",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M15/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M15/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M15/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},30,"June",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},"",null,null,null,null,"Non-Revenue",{"$f":"'3. Single-family'!B21","v":""}]
[null,null,null,"MAY",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M16/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M16/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M16/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},31,"July",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},"",null,null,null,null,null,{"$f":"'3. Single-family'!B22","v":""}]
[null,null,null,"JUN",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M17/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M17/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M17/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},30,"August",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},""]
[null,null,null,"JUL",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M18/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M18/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M18/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},31,"September",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},""]
[null,null,null,"AUG",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M19/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M19/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M19/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},31,"October",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},""]
[null,null,null,"SEP",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M20/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M20/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M20/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},30,"November",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},""]
[null,null,null,"OCT",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M21/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M21/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M21/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},31,"December",{"$error":"#N/A"},"","","",{"$f":"IF($E$6=\"Reuse\",#REF!,\"\")","v":""},""]
[null,null,null,"NOV",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M22/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M22/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M22/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},30]
[null,null,null,"DEC",{"$f":"VLOOKUP($I$4,'3. Single-family'!$B$61:$N$68,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'4. Multi-family'!$B$47:$N$54,ROW()-10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)/M23/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)/M23/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},{"$f":"(VLOOKUP($I$4,'7. Total Diverted'!$B$46:$N$53,ROW()-10,FALSE)-(VLOOKUP($I$4,'3. Single-family'!$B$15:$N$22,ROW()-10,FALSE)+VLOOKUP($I$4,'4. Multi-family'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$11:$N$18,ROW()-10,FALSE)+VLOOKUP($I$4,'5. ICI & Other Metered'!$B$23:$N$30,ROW()-10,FALSE)))/M23/VLOOKUP($I$4,'7. Total Diverted'!$B$10:$W$17,22,FALSE)","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},31]
[]
[]
[null,null,null,null,{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""},{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""},{"$f":"IF(ISBLANK('1. Instructions and Notations'!$D$28),\"\",'1. Instructions and Notations'!$D$28)","v":""}]
[]
[null,null,null,null,{"$f":"'1. Instructions and Notations'!E31","v":0},null,"to",{"$f":"'1. Instructions and Notations'!I31","v":""}]

{"sheet":"11. Definition","index":10,"n_rows":101,"n_cols":10,"rows_kept":101,"cut":false,"hidden":false,"merged":[[96,2,96,9],[59,4,59,11],[20,4,20,5],[5,4,5,11],[17,4,17,11],[29,4,29,11],[25,4,25,11],[27,4,27,11],[31,4,31,11],[33,4,33,11],[39,4,39,11],[43,4,43,11],[35,4,35,11],[41,4,41,11],[37,4,37,11],[23,4,23,11],[57,4,57,11],[45,4,45,11],[51,4,51,11],[53,4,53,11],[47,4,47,11],[55,4,55,11],[49,4,49,11],[21,4,21,11],[20,10,20,11],[1,2,1,8],[3,4,3,11],[7,4,7,11],[11,4,11,11],[19,4,19,11],[9,4,9,11],[13,4,13,11],[15,4,15,11]]}
[]
[null,null," NMOSE GPCD Software: Definitions"]
[]
[null,null,"Item Name",null,"Description"]
[]
[null,null,"Active Connections",null,"All active Single Family Residential connections within the utility.  Connections that are not occupied or show zero activity are not counted in this category.  "]
[]
[null,null,"Annual Multi-Family Residential GPCD Calculation",null,"The MFR  GPCD is Annual MF Calculation (4.6) divided by the annual MFR Population (4.9). "]
[]
[null,null,"Annual Single Family Residential GPCD Calculation",null,"The SFR GPCD is Annual SFR Calculation (3.7) divided by the annual SFR Population average (3.13)."]
[]
[null,null,"Billed Water Consumption (Multi-Family Residential)",null,"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.  "]
[]
[null,null,"Billed Water Consumption (Single-Family Residential)",null,"This is the total billed consumption for Single-Family residential uses only. "]
[]
[null,null,"Calculated Growth Rate",null,"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.  "]
[]
[null,null,"Census Data",null,"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. Appendix A and the Definition within the Calculator (Sheet 11) describe how to find and record the relevant data."]
[]
[null,null,"Converter",null,"The user may develop a GPCD Analysis based on one of two input unit selections: \n1) Gallons (US)\n2) Cubic feet\nPlease 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."]
[null,null,null,null,1,null,"Gallons (US)","=",{"$f":"IF(G21=\"Cubic feet\",E21*7.48051945,E21/7.48051945)","v":0.13368055610095367},{"$f":"IF(G21=\"Gallons (US)\",\"Cubic Feet\",\"Gallons\")","v":"Cubic Feet"}]
[]
[]
[null,null,"Exported Water",null,"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."]
[]
[null,null,"GPCD",null,"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."]
[]
[null,null,"General Information",null,"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. "]
[]
[null,null,"Graphing Results",null,"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. "]
[]
[null,null,"Imported Water",null,"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."]
[]
[null,null,"Inactive and Zero Connections",null,"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.  "]
[]
[null,null,"Industrial, Commercial and Institutional (ICI)",null,"Includes industrial properties, such as manufacturing, commercial properties such as restaurants, shopping malls, and institutional customers such as schools, universities and prisons. "]
[]
[null,null,"Multi-Family Residential Connections",null,"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.  "]
[]
[null,null,"Multi-Family Residential Population",null,"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)."]
[]
[null,null,"Non-Revenue Water",null,"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.  \n"]
[]
[null,null,"Other Metered",null,"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. "]
[]
[null,null,"Reuse",null,"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."]
[]
[null,null,"Single Family Residential Connections",null,"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. "]
[]
[null,null,"Single Family Residential Population",null,"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.  "]
[]
[null,null,"Size of Average Household",null,"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)."]
[]
[null,null,"Total Connections",null,"All active and inactive Single Family Residential connections within the utility. "]
[]
[null,null,"System Total GPCD",null,"The System Total GPCD is calculated by dividing the quantity of Total Water Diverted (plus imports minus exports) by the System Total Population"]
[]
[null,null,"Total Population",null,"The Total Population estimate is the sum of the single-family population + multi-family population + group quarters population."]
[]
[null,null,"Vacant Single-Family Residential Connections",null,"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.  "]
[]
[]
[]
[null,null,"How to find the data required for Census section"]
[null,null,"www.census.gov"]
[null,null,"1. Select American Community Survey (ACS)"]
[]
[]
[]
[null,"2. Select Data"]
[]
[]
[]
[null,null,"3. Select Data Profiles"]
[]
[]
[]
[]
[null,null,"4. Select the Geography Type, state, and place"]
[]
[]
[null,null,"5. Select Housing Characteristics "]
[]
[]
[null,"\n6. Populate the GPCD Calculator with the numbers in Total housing units, Occupied housing units, Vacant housing units. ","\n6. Populate the GPCD Calculator with the numbers in Total housing units, Occupied housing units, Vacant housing units. "]
[]
[]
[]
[null,null,"7.Populate the GPCD Calculator with the number in Average household size"]
[]
[]
[]
[]
[]
[null,null,"Group Quarters "]
[]
[null,null,"In Group Quarters data can be found for the following cities: Alamogordo, Albuqureque, Carlsbad, Clovis, Farmington, Gallup, Hobbs, Las Cruces, Rio Rancho, Roswell, Santa Fe, and South Valley. Follow steps 8-12 to obtain data. \n\nFor all other cities in group quarters data can be obtained by contact the group quarters that you provide service to. \n\nGroup quarters populations includes: Prisons, nursing homes, long term care hospitials, off campus college quarters, military quarters, and emergency and transitional shelters.  "]
[]
[null,null,"Transfer results to spreadsheet"]
[]
[null,null,"END"]

{"sheet":"Sheet4","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet2","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":14,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[null,"$/100 cubic feet (ccf)","$/1000 gallons (US)","$/1000 litres",null,"Conversion table",null,null,null,null,null,null,"FROM:                                        TO:","Million gallons (US)","Megalitres (thousand cubic metres)","Acre-feet"]
["Million gallons (US)",{"$f":"1000000/(F2*100)","v":1336.8055610095364},1000,{"$f":"1000/F5","v":3785.4117999999999},null,7.4805194500000001,"gallons / cubic foot","converting FROM volume unit TO pricing UNITS",null,null,null,null,"Million gallons (US)",1,{"$f":"F4","v":3.7854117999999999},3.068883289737228]
["Megalitres (thousand cubic metres)",{"$f":"1000000/F4/(F2*100)","v":353.14666716301156},{"$f":"1000/F4","v":264.17205124155845},1000,null,43560,"sq feet / acre",null,null,null,null,null,"Megalitres (thousand cubic metres)",{"$f":"1/O2","v":0.26417205124155846},1,0.8107131936708255]
["Acre-feet",{"$f":"F3/100","v":435.6},{"$f":"F3*F2/1000","v":325.851427242},{"$f":"F3*F2*F4/1000","v":1233.4818377287083},null,3.7854117999999999,"litres / gallon",null,null,null,null,null,"Acre-feet",{"$f":"325851.427242/1000000","v":0.325851427242},1.2334818377287082,1]
[null,null,null,null,null,{"$f":"1/F4","v":0.26417205124155846},"gallons / litre"]
[]
["losses",1,"million gallons (US)",{"$f":"MATCH(C7,A2:A4,0)","v":1}]
[null,null,null,null,{"$f":"INDEX($B$2:$D$4,MATCH(C7,A2:A4,0),MATCH(C9,B1:D1,0))","v":1336.8055610095364}]
["cost",10,"$/100 cubic feet (ccf)",{"$f":"MATCH(C9,B1:D1,0)","v":1}]
[]
[null,"cost =",{"$f":"B7*B9*E8","v":13368.055610095364},null,null,null,null,null,"Multiply By…"]
[null,null,null,null,null,null,"million",null,"From",null,null,"To"]
[null,null,null,null,null,null,"m3",1,"Acre-feet","=",{"$f":"H13*INDEX(N2:P4,MATCH(I13,M2:M4,0),MATCH(L13,N1:P1,0))","v":1.2334818377287082},"Megalitres (thousand cubic metres)"]
[]
[null,"customer cost"]
[null,"$/100 cubic feet (ccf)","$/1000 gallons (US)","$/1000 litres"]
["million gallons (US)",{"$f":"1000000/(7.48*100)","v":1336.8983957219252},1000,{"$f":"1000000/CONVERT(1000,\"l\",\"gal\")","v":3785.4117839999994}]
["thousand cubic metres",{"$f":"1000000/CONVERT((7.48*100),\"gal\",\"l\")","v":353.171192992177},{"$f":"1000000/CONVERT(1000,\"gal\",\"l\")","v":264.17205235814845},1000]
["acre-feet",{"$f":"43560/100","v":435.6},{"$f":"43560/(1000/7.48)","v":325.8288},{"$f":"F3/(CONVERT(1000,\"l\",\"gal\")/F2)","v":1233.4818325150852}]
[]
[]
["customer cost",5,"$/1000 gallons (US)",{"$f":"MATCH(C22,B16:D16,0)","v":2}]
[null,null,null,null,{"$f":"INDEX($B$2:$D$4,MATCH(C24,A2:A4,0),MATCH(C22,B1:D1,0))","v":1000}]
["marginal production",5000,"million gallons (US)",{"$f":"MATCH(C24,A17:A19,0)","v":1}]
[]
[null,"cost =",{"$f":"(B22*E23)/B24","v":1}]
[null,null,">1 = higher customer cost"]
[null,null,"<1 = lower customer cost"]
[]
[]
["=IF(ISERROR(1/G60),\"\",(((G24+G25+G40)*G62)+(G37*G61)*INDEX(Sheet1!B2:D4,MATCH(Instructions!G24,Sheet1!A2:A4,0),MATCH('Reporting Worksheet'!I61:J61,Sheet1!B1:D1,0)))/G60)"]
[]
[null,"(reallosses * real loss cost per unit) + (apparent losses * apparent loss cost per unit * unit conversion factor)"]
[]
[]
[]
["=IF(ISBLANK(Instructions!$G$26),\"\",IF(Instructions!$G$26=\"Megalitres (thousand cubic metres)\",IF(AND(G55>25,G50*20+G51>3000),(((18*G50)+(0.8*G51)+(25*(G51*G53/1000)))*G55/1000000)*365,\"Not valid\"),IF(AND(G55>40,G50*32+G51>3000),(((5.41*G50)+(0.15*G51)+(7.5*(G51*G53/5280)))*G55)/1000000*365,\"Not Valid\")))"]
["IF(AND(G55>40,G50*32+G51>3000),(((5.41*G50)+(0.15*G51)+(7.5*(G51*G53/5280)))*G55)/1000000,\"Not Valid\")))"]
["Logic:"]
["If volume unit is blank show nothing"]
[]
["If instructions is tcm Then"]
["     If pressure > 25 AND length of mains * 20 + # connections > 3000 Then"]
["          (((18 * length of mains) + (0.8 * # connections) + (25 * (# service connections * avg len of pipe / 1000))) * pressure)   /1000"]
["     Otherwise not valid"]
[]
["If instructions is gallons Then"]
["     If pressure > 40 AND length of mains * 32 + # connections > 3000 Then"]
["        (((5.41 * length of mains) + (0.15 * # connections) + (7.5 * (# service connections * avg len of pipe / 5280))) * pressure)   /1000000"]
["     Otherwise not valid"]
[]
["If instructions is acre-feet Then"]
["     If pressure > 40 AND length of mains * 32 + # connections > 3000 Then"]
["        (((5.41 * length of mains) + (0.15 * # connections) + (7.5 * (# service connections * avg len of pipe / 5280))) * pressure)   /1000000"]
["     Otherwise not valid"]