{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Worksheet","January","February","March","April","May","June","July","August","September","October","November","December","Summary","EFC Table","DWR_LWSP_Data_Systems"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"Worksheet","index":0,"n_rows":176,"n_cols":9,"rows_kept":176,"cut":false,"hidden":false,"merged":[[4,3,4,5],[2,1,2,5]]}
["Local Water Supply Plan Completion Assistance Tool v6.0"]
[]
["Water System Name:",{"$f":"IF(B4<>0,VLOOKUP(B4,DWR_LWSP_Data_Systems!A2:B702,2,FALSE),\"No Data\")","v":"No Data"}]
["PWSID#:"]
["Reporting Year:",null,null,"Full instructions for the LWSP can be found here:",null,null,"LWSP Instructions"]
[{"$f":"IF(B5<>0,IF(OR(MOD(B5,400)=0,AND(MOD(B5,4)=0,MOD(B5,100)<>0)),\"Leap Year\", \"Not a Leap Year\"),\"No Data\")","v":"No Data"},{"$f":"IF(B5<>0,365+IF(MOD(B5,4)=0,IF(MOD(B5,100)=0,IF(MOD(B5,400)=0,1,0),1),0),\"No Data\")","v":"No Data"}]
["Water Use by Type",null,null,{"$f":"D9+D10+D11+D12+D13","v":0},null,null,{"$f":"G9+G10+G11+G12","v":0}]
["Type of Use","Metered Connections","Gallons","Metered Average Use (MGD)","Non-Metered Connections","Estimated Gallons","Non-Metered Estimated Use (MGD)"]
["Residential",null,null,{"$f":"IF(C9>0,C9/1000000/$B$6,0)","v":0},null,null,{"$f":"IF(F9>0,F9/1000000/$B$6,0)","v":0}]
["Commercial",null,null,{"$f":"IF(C10>0,C10/1000000/$B$6,0)","v":0},null,null,{"$f":"IF(F10>0,F10/1000000/$B$6,0)","v":0}]
["Industrial",null,null,{"$f":"IF(C11>0,C11/1000000/$B$6,0)","v":0},null,null,0]
["Institutional",null,null,{"$f":"IF(C12>0,C12/1000000/$B$6,0)","v":0},null,null,0]
["System Process",null,null,{"$f":"IF(C13>0,C13/1000000/$B$6,0)","v":0}]
[]
[]
[]
[]
[]
["Water Sales",null,null,{"$f":"(IF(C21>0,D21*E21,0)+IF(C22>0,D22*E22,0)+IF(C23>0,D23*E23,0)+IF(C24>0,D24*E24,0)+IF(C25>0,D25*E25,0)+IF(C26>0,D26*E26,0)+IF(C27>0,D27*E27,0)+IF(C28>0,D28*E28,0)+IF(C29>0,D29*E29,0)+IF(C30>0,D30*E30,0)+IF(C31>0,D31*E31))/IF(A6=\"Leap Year\",366,365)","v":0}]
["Purchaser","PWSID","Gallons Sold","Average Daily Sold (MGD)","Days Sold"]
[null,null,null,{"$f":"IF(E21=0,0,IF(C21>0,C21/1000000/E21,0))","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[]
[]
[]
[]
[]
["Monthly Withdrawals & Purchases",null,null,"         Click instructions button before completing table",null,null,null,null,{"$f":"(SUM(C39:C42)+SUM(F39:F42)+SUM(I39:I42))/12","v":0}]
[null,"Gallons","Average Daily Use (MGD)",null,"Gallons","Average Daily Use (MGD)",null,"Gallons","Average Daily Use (MGD)"]
["January",null,{"$f":"IF(B39>0,IF(D45=\"N\",B39/1000000/DAY(DATE(B5,1+1,1)-1)+D118,B39/1000000/DAY(DATE(B5,1+1,1)-1)),D118)","v":0},"May",null,{"$f":"IF(E39>0,IF(D45=\"N\",E39/1000000/DAY(DATE(B5,5+1,1)-1)+D118,E39/1000000/DAY(DATE(B5,5+1,1)-1)),D118)","v":0},"September",null,{"$f":"IF(H39>0,IF(D45=\"N\",H39/1000000/DAY(DATE(B5,9+1,1)-1)+D118,H39/1000000/DAY(DATE(B5,9+1,1)-1)),D118)","v":0}]
["February",null,{"$f":"IF(B40>0,IF(D45=\"N\",B40/1000000/DAY(DATE(B5,2+1,1)-1)+D118,B40/1000000/DAY(DATE(B5,2+1,1)-1)),D118)","v":0},"June",null,{"$f":"IF(E40>0,IF(D45=\"N\",E40/1000000/DAY(DATE(B5,6+1,1)-1)+D118,E40/1000000/DAY(DATE(B5,6+1,1)-1)),D118)","v":0},"October",null,{"$f":"IF(H40>0,IF(D45=\"N\",H40/1000000/DAY(DATE(B5,10+1,1)-1)+D118,H40/1000000/DAY(DATE(B5,10+1,1)-1)),D118)","v":0}]
["March",null,{"$f":"IF(B41>0,IF(D45=\"N\",B41/1000000/DAY(DATE(B5,3+1,1)-1)+D118,B41/1000000/DAY(DATE(B5,3+1,1)-1)),D118)","v":0},"July",null,{"$f":"IF(E41>0,IF(D45=\"N\",E41/1000000/DAY(DATE(B5,7+1,1)-1)+D118,E41/1000000/DAY(DATE(B5,7+1,1)-1)),D118)","v":0},"November",null,{"$f":"IF(H41>0,IF(D45=\"N\",H41/1000000/DAY(DATE(B5,11+1,1)-1)+D118,H41/1000000/DAY(DATE(B5,11+1,1)-1)),D118)","v":0}]
["April",null,{"$f":"IF(B42>0,IF(D45=\"N\",B42/1000000/DAY(DATE(B5,4+1,1)-1)+D118,B42/1000000/DAY(DATE(B5,4+1,1)-1)),D118)","v":0},"August",null,{"$f":"IF(E42>0,IF(D45=\"N\",E42/1000000/DAY(DATE(B5,8+1,1)-1)+D118,E42/1000000/DAY(DATE(B5,8+1,1)-1)),D118)","v":0},"December",null,{"$f":"IF(H42>0,IF(D45=\"N\",H42/1000000/DAY(DATE(B5,12+1,1)-1)+D118,H42/1000000/DAY(DATE(B5,12+1,1)-1)),D118)","v":0}]
["Monthly withdrawals & purchases is calculated using the annual average purchase water, if any, which may be different from the monthly amount of water purchased."]
[]
["Does your system purchase source water ONLY?"]
[]
[]
["Ground Water Sources",null,{"$f":"(IF(B50>0,C50*D50,0)+IF(B51>0,C51*D51,0)+IF(B52>0,C52*D52,0)+IF(B53>0,C53*D53,0)+IF(B54>0,C54*D54,0)+IF(B55>0,C55*D55,0)+IF(B56>0,C56*D56,0)+IF(B57>0,C57*D57,0)+IF(B58>0,C58*D58,0)+IF(B59>0,C59*D59,0)+IF(B60>0,C60*D60)+IF(B61>0,C61*D61,0)+IF(B62>0,C62*D62,0)+IF(B63>0,C63*D63,0)+IF(B64>0,C64*D64,0)+IF(B65>0,C65*D65,0)+IF(B66>0,C66*D66,0)+IF(B67>0,C67*D67,0)+IF(B68>0,C68*D68,0)+IF(B69>0,C69*D69,0)+IF(B70>0,C70*D70,0)+IF(B71>0,C71*D71,0)+IF(B72>0,C72*D72,0)+IF(B73>0,C73*D73,0)+IF(B74>0,C74*D74,0)+IF(B75>0,C75*D75,0)+IF(B76>0,C76*D76,0)+IF(B77>0,C77*D77,0)+IF(B78>0,C78*D78,0)+IF(B79>0,C79*D79,0)+IF(B80>0,C80*D80,0)+IF(B81>0,C81*D81,0)+IF(B82>0,C82*D82,0)+IF(B83>0,C83*D83,0)+IF(B84>0,C84*D84,0)+IF(B85>0,C85*D85,0)+IF(B86>0,C86*D86,0)+IF(B87>0,C87*D87,0)+IF(B88>0,C88*D88,0)+IF(B89>0,C89*D89,0)+IF(B90>0,C90*D90,0)+IF(B91>0,C91*D91,0)+IF(B92>0,C92*D92,0)+IF(B93>0,C93*D93,0)+IF(B94>0,C94*D94,0)+IF(B95>0,C95*D95,0)+IF(B96>0,C96*D96,0)+IF(B97>0,C97*D97,0)+IF(B98>0,C98*D98,0)+IF(B99>0,C99*D99,0)+IF(B100>0,C100*D100,0))/IF(A6=\"Leap Year\",366,365)","v":0}]
["Name or Number","Gallons Pumped","Average Daily Withdrawal (MGD)","Days Used"]
[null,null,{"$f":"IF(D50=0,0,IF(B50>0,B50/1000000/D50,0))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF(D82=0,0,IF(B82>0,B82/1000000/D82,0))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[]
[]
[]
[]
[]
["Surface Water Sources",null,null,{"$f":"(IF(C108>0,D108*E108,0)+IF(C109>0,D109*E109,0)+IF(C110>0,D110*E110,0)+IF(C111>0,D111*E111,0)+IF(C112>0,D112*E112,0))/IF(A6=\"Leap Year\",366,365)","v":0}]
["Stream","Reservoir","Gallons Withdrawn","Average Daily Withdrawal      (MGD)","Days Used"]
[null,null,null,{"$f":"IF(E108=0,0,IF(C108>0,C108/1000000/E108,0))","v":0}]
[null,null,null,{"$f":"IF(E109=0,0,IF(C109>0,C109/1000000/E109,0))","v":0}]
[null,null,null,{"$f":"IF(E110=0,0,IF(C110>0,C110/1000000/E110,0))","v":0}]
[null,null,null,{"$f":"IF(E111=0,0,IF(C111>0,C111/1000000/E111,0))","v":0}]
[null,null,null,{"$f":"IF(E112=0,0,IF(C112>0,C112/1000000/E112,0))","v":0}]
[]
[]
[]
[]
[]
["Water Purchases From Other Systems",null,null,{"$f":"(IF(C120>0,D120*E120,0)+IF(C121>0,D121*E121,0)+IF(C122>0,D122*E122,0)+IF(C123>0,D123*E123,0)+IF(C124>0,D124*E124,0))/IF(A6=\"Leap Year\",366,365)","v":0}]
["Seller","    PWSID","Gallons Purchased","Average Daily Purchased         (MGD)","Days Used"]
[null,null,null,{"$f":"IF(E120=0,0,IF(C120>0,C120/1000000/E120,0))","v":0}]
[null,null,null,{"$f":"IF(E121=0,0,IF(C121>0,C121/1000000/E121,0))","v":0}]
[null,null,null,{"$f":"IF(E122=0,0,IF(C122>0,C122/1000000/E122,0))","v":0}]
[null,null,null,{"$f":"IF(E123=0,0,IF(C123>0,C123/1000000/E123,0))","v":0}]
[null,null,null,{"$f":"IF(E124=0,0,IF(C124>0,C124/1000000/E124,0))","v":0}]
[]
[]
[]
[]
[]
["Monthly Discharges",null,"          Click instructions button before completing table",null,null,null,null,null,{"$f":"(SUM(C132:C135)+SUM(F132:F135)+SUM(I132:I135))/12","v":0}]
[null,"Gallons","Average Daily Use (MGD)",null,"Gallons","Average Daily Use (MGD)",null,"Gallons","Average Daily Use (MGD)"]
["January",null,{"$f":"IF(B132>0,IF(E138=\"N\",B132/1000000/DAY(DATE(B5,1+1,1)-1)+D141,B132/1000000/DAY(DATE(B5,1+1,1)-1)),D141)","v":0},"May",null,{"$f":"IF(E132>0,IF(E138=\"N\",E132/1000000/DAY(DATE(B5,5+1,1)-1)+D141,E132/1000000/DAY(DATE(B5,5+1,1)-1)),D141)","v":0},"September",null,{"$f":"IF(H132>0,IF(E138=\"N\",H132/1000000/DAY(DATE(B5,9+1,1)-1)+D141,H132/1000000/DAY(DATE(B5,9+1,1)-1)),D141)","v":0}]
["February",null,{"$f":"IF(B133>0,IF(E138=\"N\",B133/1000000/DAY(DATE(B5,2+1,1)-1)+D141,B133/1000000/DAY(DATE(B5,2+1,1)-1)),D141)","v":0},"June",null,{"$f":"IF(E133>0,IF(E138=\"N\",E133/1000000/DAY(DATE(B5,6+1,1)-1)+D141,E133/1000000/DAY(DATE(B5,6+1,1)-1)),D141)","v":0},"October",null,{"$f":"IF(H133>0,IF(E138=\"N\",H133/1000000/DAY(DATE(B5,10+1,1)-1)+D141,H133/1000000/DAY(DATE(B5,10+1,1)-1)),D141)","v":0}]
["March",null,{"$f":"IF(B134>0,IF(E138=\"N\",B134/1000000/DAY(DATE(B5,3+1,1)-1)+D141,B134/1000000/DAY(DATE(B5,3+1,1)-1)),D141)","v":0},"July",null,{"$f":"IF(E134>0,IF(E138=\"N\",E134/1000000/DAY(DATE(B5,7+1,1)-1)+D141,E134/1000000/DAY(DATE(B5,7+1,1)-1)),D141)","v":0},"November",null,{"$f":"IF(H134>0,IF(E138=\"N\",H134/1000000/DAY(DATE(B5,11+1,1)-1)+D141,H134/1000000/DAY(DATE(B5,11+1,1)-1)),D141)","v":0}]
["April",null,{"$f":"IF(B135>0,IF(E138=\"N\",B135/1000000/DAY(DATE(B5,4+1,1)-1)+D141,B135/1000000/DAY(DATE(B5,4+1,1)-1)),D141)","v":0},"August",null,{"$f":"IF(E135>0,IF(E138=\"N\",E135/1000000/DAY(DATE(B5,8+1,1)-1)+D141,E135/1000000/DAY(DATE(B5,8+1,1)-1)),D141)","v":0},"December",null,{"$f":"IF(H135>0,IF(E138=\"N\",H135/1000000/DAY(DATE(B5,12+1,1)-1)+D141,H135/1000000/DAY(DATE(B5,12+1,1)-1)),D141)","v":0}]
["Monthly average daily discharge is calculated using the annual average interconnection discharge, if any, which may be different from the monthly interconnection discharge."]
[]
["Does your system discharge wastewater via an interconnection ONLY?"]
[]
[]
["Wastewater Interconnections",null,null,{"$f":"(IF(F143<>\"R\",D143*E143,0)+IF(F144<>\"R\",D144*E144,0)+IF(F145<>\"R\",D145*E145,0)+IF(F146<>\"R\",D146*E146,0)+IF(F147<>\"R\",D147*E147,0)+IF(F148<>\"R\",D148*E148,0)+IF(F149<>\"R\",D149*E149,0)+IF(F150<>\"R\",D150*E150,0))/IF(A6=\"Leap Year\",366,365)","v":0}]
["Water System","PWSID","Gallons","Average Daily Amount            (MGD)","Days Used","Type (D or R)"]
[null,null,null,{"$f":"IF(E143=0,0,IF(C143>0,C143/1000000/E143,0))","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[]
[null,"MGD"]
["Average Annual Withdrawals and Purchases",{"$f":"ROUND(C48+D106+D118,5)","v":0},"Discrepancy"]
[null,"MGD",{"$f":"IF(B153>0,ABS(B153-B155)/((B153+B155)/2),0)","v":0},"If the discrepancy is greater than 5%, check withdrawals and purchases."]
["Average Monthly Withdrawals and Purchases",{"$f":"I37","v":0}]
[]
[null,"MGD"]
["Average Annual Accounted-for Water Use",{"$f":"IF(D7=0,IF(G7=0,\"No Data\",D19+D7+G7),D19+D7+G7)","v":"No Data"}]
[]
[null,"MGD","Percent"]
["Unaccounted-for Water",{"$f":"IF(D7=0,IF(G7=0,0,B153-B158),B153-B158)","v":0},{"$f":"IF(B161>0,B161/(D118+D106+C48),IF(B161=0,0,\"Error\"))","v":0}," If the unaccounted-for water is negative, check water used and source water. Unaccounted-for water can not be negative."]
[]
[]
[]
[" Unaccounted-for Water is lost revenue for your water system. See below for an"]
[" estimate of lost revenue based on your system operations."]
[" Although this workbook is designed to give you a snapshot of water related revenue"]
[" loss, it should not be viewed as a substitute for conducting a complete water audit."]
[" To access the small system water audit or AWWA water audit, click on the State Seal."]
[]
["Inside Residential Water Rate (for first 5,000 gallons used)1:",null,null,{"$f":"IF(B3<>\"\",IFERROR(VLOOKUP(B3,DWR_LWSP_Data_Systems!B1:H701,7),\"Water system name match not found.\"),\"No Data\")","v":"Water system name match not found."}]
["Estimated Revenue loss for the Reporting Year2,3:",null,null,{"$f":"IF(B3<>\"\",IFERROR(B161*B6*1000000*D171/5000,\"Water system name match not found.\"),0)","v":"Water system name match not found."}]
[]
["1: Data taken from the Tables of Rate Structures and Computed Bills published by the UNC Environmental Finance Center and NC League of Municipalities as of January 2023. All water systems may not be represented and rates may vary. Assumptions made where needed."]
["2: All revenue loss is not recoverable, and includes losses from infrastructure leaks, meter errors, billing errors, theft, and other uses not accounted for in the local water supply plan."]
["3: Based on residential rates and unaccounted-for water which includes water that was delivered but not sold, and water lost in the distribution system. All water systems may not be represented. A water audit is recommended for a more detailed revenue loss estimate."]

{"sheet":"January","index":1,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type","W1","W2","W3","P1","P2","S","Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"February","index":2,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"March","index":3,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"April","index":4,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"May","index":5,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"June","index":6,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"July","index":7,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"August","index":8,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"September","index":9,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"October","index":10,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"November","index":11,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"December","index":12,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Day)"]
["Date","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal","Thousand Gal"]
[1,null,null,null,null,null,null,{"$f":"SUM(B4:G4)*1000","v":0}]
[{"$f":"A4+1","v":2},null,null,null,null,null,null,{"$f":"SUM(B5:G5)*1000","v":0}]
[{"$f":"A5+1","v":3},null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
["Total Gal (Month)",{"$f":"SUM(B4:B34)*1000","v":0},{"$f":"SUM(C4:C34)*1000","v":0},0,0,0,0,{"$f":"SUM(H4:H34)","v":0}]

{"sheet":"Summary","index":13,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Monthly Withdrawals & Purchases"]
["Source Type",{"$f":"January!B2","v":"W1"},{"$f":"January!C2","v":"W2"},{"$f":"January!D2","v":"W3"},{"$f":"January!E2","v":"P1"},{"$f":"January!F2","v":"P2"},{"$f":"January!G2","v":"S"},"Total Gal (Month)"]
["Month ","Total Gal","Total Gal","Total Gal","Total Gal","Total Gal","Total Gal"]
["January",{"$f":"January!B35","v":0},{"$f":"January!C35","v":0},{"$f":"January!D35","v":0},{"$f":"January!E35","v":0},{"$f":"January!F35","v":0},{"$f":"January!G35","v":0},{"$f":"SUM(B4:G4)","v":0}]
["February",{"$f":"February!B35","v":0},{"$f":"February!C35","v":0},{"$f":"February!D35","v":0},{"$f":"February!E35","v":0},{"$f":"February!F35","v":0},{"$f":"February!G35","v":0},{"$f":"SUM(B5:G5)","v":0}]
["March",{"$f":"March!B35","v":0},{"$f":"March!C35","v":0},{"$f":"March!D35","v":0},{"$f":"March!E35","v":0},{"$f":"March!F35","v":0},{"$f":"March!G35","v":0},0]
["April",{"$f":"April!B35","v":0},{"$f":"April!C35","v":0},{"$f":"April!D35","v":0},{"$f":"April!E35","v":0},{"$f":"April!F35","v":0},{"$f":"April!G35","v":0},0]
["May",{"$f":"May!B35","v":0},{"$f":"May!C35","v":0},{"$f":"May!D35","v":0},{"$f":"May!E35","v":0},{"$f":"May!F35","v":0},{"$f":"May!G35","v":0},0]
["June",{"$f":"June!B35","v":0},{"$f":"June!C35","v":0},{"$f":"June!D35","v":0},{"$f":"June!E35","v":0},{"$f":"June!F35","v":0},{"$f":"June!G35","v":0},0]
["July",{"$f":"July!B35","v":0},{"$f":"July!C35","v":0},{"$f":"July!D35","v":0},{"$f":"July!E35","v":0},{"$f":"July!F35","v":0},{"$f":"July!G35","v":0},0]
["August",{"$f":"August!B35","v":0},{"$f":"August!C35","v":0},{"$f":"August!D35","v":0},{"$f":"August!E35","v":0},{"$f":"August!F35","v":0},{"$f":"August!G35","v":0},0]
["September",{"$f":"September!B35","v":0},{"$f":"September!C35","v":0},{"$f":"September!D35","v":0},{"$f":"September!E35","v":0},{"$f":"September!F35","v":0},{"$f":"September!G35","v":0},0]
["October",{"$f":"October!B35","v":0},{"$f":"October!C35","v":0},{"$f":"October!D35","v":0},{"$f":"October!E35","v":0},{"$f":"October!F35","v":0},{"$f":"October!G35","v":0},0]
["November",{"$f":"November!B35","v":0},{"$f":"November!C35","v":0},{"$f":"November!D35","v":0},{"$f":"November!E35","v":0},{"$f":"November!F35","v":0},{"$f":"November!G35","v":0},0]
["December",{"$f":"December!B35","v":0},{"$f":"December!C35","v":0},{"$f":"December!D35","v":0},{"$f":"December!E35","v":0},{"$f":"December!F35","v":0},{"$f":"December!G35","v":0},0]
["Total Gal (Year)",{"$f":"SUM(B4:B15)","v":0},{"$f":"SUM(C4:C15)","v":0},0,0,0,0,{"$f":"SUM(H4:H15)","v":0}]

{"sheet":"EFC Table","index":14,"n_rows":504,"n_cols":9,"rows_kept":504,"cut":false,"hidden":true,"merged":[]}
[null,"EFC Data Tables Link","Sanchez, Melanie Nicole <msanchez@sog.unc.edu>"]
["Helper Column (system+water+inside)","System Name","Service Type ","Inside/ Outside","Operating Ratio (incl. Depreciation)","Estimated Service Pop","Residential Bills at Various Consumption Levels","Price (V Monthly Bill)"]
[{"$f":"B3&C3&D3","v":"AberdeenWaterInside"},"Aberdeen","Water","Inside",1.03,12241,"5,000 gallons (668 cf)",24.55]
[{"$f":"B4&C4&D4","v":"AhoskieWaterInside"},"Ahoskie","Water","Inside",1.1100000000000001,5479,"5,000 gallons (668 cf)",40.58]
["AlamanceWaterInside","Alamance","Water","Inside",0.75,1100,"5,000 gallons (668 cf)",37.85]
["AlbemarleWaterInside","Albemarle","Water","Inside",1.1200000000000001,17368,"5,000 gallons (668 cf)",27.46]
["AndrewsWaterInside","Andrews","Water","Inside",0.83,3284,"5,000 gallons (668 cf)",43]
["AngierWaterInside","Angier","Water","Inside",1.22,8468,"5,000 gallons (668 cf)",31.77]
["Anson CoWaterInside","Anson Co","Water","Inside",null,13771,"5,000 gallons (668 cf)",26.96]
["AnsonvilleWaterInside","Ansonville","Water","Inside",0.99,1262,"5,000 gallons (668 cf)",31.04]
["ApexWaterInside","Apex","Water","Inside",0.85,70272,"5,000 gallons (668 cf)",27.25]
["Aqua North CarolinaWaterInside","Aqua North Carolina","Water","Inside",null,187787,"5,000 gallons (668 cf)",52.6]
["Aqua North Carolina - Brookwood and LaGrangeWaterInside","Aqua North Carolina - Brookwood and LaGrange","Water","Inside",null,18022,"5,000 gallons (668 cf)",38.86]
["Aqua North Carolina - Fairways and Beau RivageWaterInside","Aqua North Carolina - Fairways and Beau Rivage","Water","Inside",null,115976,"5,000 gallons (668 cf)",16.309999999999999]
["ArchdaleWaterInside","Archdale","Water","Inside",1.24,12700,"5,000 gallons (668 cf)",32.35]
["AsheboroWaterInside","Asheboro","Water","Inside",0.89,27191,"5,000 gallons (668 cf)",31.5]
["AshevilleWaterInside","Asheville","Water","Inside",1.31,156720,"5,000 gallons (668 cf)",37.43]
["AtkinsonWaterInside","Atkinson","Water","Inside",null,301,"5,000 gallons (668 cf)",59]
["Atlantic BeachWaterInside","Atlantic Beach","Water","Inside",1.37,6380,"5,000 gallons (668 cf)",29.65]
["AulanderWaterInside","Aulander","Water","Inside",0.78,1438,"5,000 gallons (668 cf)",38.5]
["AuroraWaterInside","Aurora","Water","Inside",0.9,805,"5,000 gallons (668 cf)",43.36]
["AutryvilleWaterInside","Autryville","Water","Inside",1.1200000000000001,472,"5,000 gallons (668 cf)",54.36]
["AydenWaterInside","Ayden","Water","Inside",0.87,6366,"5,000 gallons (668 cf)",53]
["BaileyWaterInside","Bailey","Water","Inside",1.1200000000000001,569,"5,000 gallons (668 cf)",40.549999999999997]
["BakersvilleWaterInside","Bakersville","Water","Inside",0.64,725,"5,000 gallons (668 cf)",25]
["Bald Head Island UtilitiesWaterInside","Bald Head Island Utilities","Water","Inside",1.19,3291,"5,000 gallons (668 cf)",61.49]
["Banner ElkWaterInside","Banner Elk","Water","Inside",1.36,1407,"5,000 gallons (668 cf)",39.799999999999997]
["BathWaterInside","Bath","Water","Inside",0.87,290,"5,000 gallons (668 cf)",63.5]
["Baton Water CorporationWaterInside","Baton Water Corporation","Water","Inside",null,7112,"5,000 gallons (668 cf)",32]
["BeaufortWaterInside","Beaufort","Water","Inside",1.26,4787,"5,000 gallons (668 cf)",35.72]
["Beaufort Co (NorthSide)WaterInside","Beaufort Co (NorthSide)","Water","Inside",1.29,13000,"5,000 gallons (668 cf)",58.8]
["Beaufort Co (SouthSide)WaterInside","Beaufort Co (SouthSide)","Water","Inside",1.29,9263,"5,000 gallons (668 cf)",58.8]
["Beaufort County - District IIIWaterInside","Beaufort County - District III","Water","Inside",1.29,22467,"5,000 gallons (668 cf)",58.8]
["Beaufort County - District IVWaterInside","Beaufort County - District IV","Water","Inside",1.29,290,"5,000 gallons (668 cf)",58.8]
["Beaufort County - District VWaterInside","Beaufort County - District V","Water","Inside",1.29,22467,"5,000 gallons (668 cf)",58.8]
["Beaufort Co WD VIWaterInside","Beaufort Co WD VI","Water","Inside",1.29,2565,"5,000 gallons (668 cf)",58.8]
["Beech MountainWaterInside","Beech Mountain","Water","Inside",1.34,2468,"5,000 gallons (668 cf)",54.96]
["BelhavenWaterInside","Belhaven","Water","Inside",1.0900000000000001,1960,"5,000 gallons (668 cf)",65.34]
["Bell Arthur WCWaterInside","Bell Arthur WC","Water","Inside",null,10635,"5,000 gallons (668 cf)",51.47]
["BelmontWaterInside","Belmont","Water","Inside",0.94,15010,"5,000 gallons (668 cf)",37.08]
["BensonWaterInside","Benson","Water","Inside",0.9,4259,"5,000 gallons (668 cf)",39.1]
["Bertie County RWSWaterInside","Bertie County RWS","Water","Inside",1.28,12893,"5,000 gallons (668 cf)",44]
["Bessemer CityWaterInside","Bessemer City","Water","Inside",0.83,5500,"5,000 gallons (668 cf)",32.15]
["BeulavilleWaterInside","Beulaville","Water","Inside",1.02,1326,"5,000 gallons (668 cf)",37.75]
["Biltmore ForestWaterInside","Biltmore Forest","Water","Inside",0.84,1356,"5,000 gallons (668 cf)",49.68]
["BiscoeWaterInside","Biscoe","Water","Inside",0.96,2319,"5,000 gallons (668 cf)",28.5]
["Black CreekWaterInside","Black Creek","Water","Inside",null,1795,"5,000 gallons (668 cf)",30.55]
["Bladen CountyWaterInside","Bladen County","Water","Inside",0.97,15903,"5,000 gallons (668 cf)",34]
["BladenboroWaterInside","Bladenboro","Water","Inside",0.96,1648,"5,000 gallons (668 cf)",27.52]
["Blowing RockWaterInside","Blowing Rock","Water","Inside",1.1200000000000001,1637,"5,000 gallons (668 cf)",52.53]
["BoardmanWaterInside","Boardman","Water","Inside",0.39,165,"5,000 gallons (668 cf)",30]
["Bogue Banks Water CorpWaterInside","Bogue Banks Water Corp","Water","Inside",null,4995,"5,000 gallons (668 cf)",32.020000000000003]
["Boiling SpringsWaterInside","Boiling Springs","Water","Inside",1.05,4769,"5,000 gallons (668 cf)",37.409999999999997]
["BoltonWaterInside","Bolton","Water","Inside",0.51,681,"5,000 gallons (668 cf)",28.8]
["BooneWaterInside","Boone","Water","Inside",1.1299999999999999,19667,"5,000 gallons (668 cf)",37.950000000000003]
["BoonvilleWaterInside","Boonville","Water","Inside",1.08,1798,"5,000 gallons (668 cf)",47.7]
["BosticWaterInside","Bostic","Water","Inside",1.6,850,"5,000 gallons (668 cf)",44]
["Brentwood Water CorporationWaterInside","Brentwood Water Corporation","Water","Inside",null,10489,"5,000 gallons (668 cf)",37.43]
["BrevardWaterInside","Brevard","Water","Inside",1.1299999999999999,10686,"5,000 gallons (668 cf)",57.5]
["Broad River Water AuthorityWaterInside","Broad River Water Authority","Water","Inside",1.39,17093,"5,000 gallons (668 cf)",51.2]
["BroadwayWaterInside","Broadway","Water","Inside",0.83,1783,"5,000 gallons (668 cf)",24.7]
["Broadway Water Association. Inc.WaterInside","Broadway Water Association. Inc.","Water","Inside",null,3556,"5,000 gallons (668 cf)",28.35]
["Brunswick CountyWaterInside","Brunswick County","Water","Inside",1.78,113410,"5,000 gallons (668 cf)",36.75]
["Brunswick Regional WSDWaterInside","Brunswick Regional WSD","Water","Inside",1.64,36142,"5,000 gallons (668 cf)",30.5]
["Bryson CityWaterInside","Bryson City","Water","Inside",1.01,4222,"5,000 gallons (668 cf)",31.05]
["BunnWaterInside","Bunn","Water","Inside",0.98,915,"5,000 gallons (668 cf)",45]
["BurgawWaterInside","Burgaw","Water","Inside",0.73,4250,"5,000 gallons (668 cf)",26.25]
[{"$f":"B68&C68&D68","v":"Burke CountyWaterInside"},"Burke County","Water","Inside",0.89,7001,"5,000 gallons (668 cf)",55]
["BurlingtonWaterInside","Burlington","Water","Inside",1.2,56691,"5,000 gallons (668 cf)",22.7]
["BurnsvilleWaterInside","Burnsville","Water","Inside",0.96,4069,"5,000 gallons (668 cf)",39.200000000000003]
["Caldwell CountyWaterInside","Caldwell County","Water","Inside",1.22,24074,"5,000 gallons (668 cf)",34.71]
["CalypsoWaterInside","Calypso","Water","Inside",1.1399999999999999,660,"5,000 gallons (668 cf)",37.5]
["CameronWaterInside","Cameron","Water","Inside",0.73,490,"5,000 gallons (668 cf)",43]
["CandorWaterInside","Candor","Water","Inside",1.06,875,"5,000 gallons (668 cf)",44.75]
["CantonWaterInside","Canton","Water","Inside",1.1599999999999999,7799,"5,000 gallons (668 cf)",22.76]
["Cape Fear Public Utility Authority - WilmingtonWaterInside","Cape Fear Public Utility Authority - Wilmington","Water","Inside",1.1200000000000001,190501,"5,000 gallons (668 cf)",39.909999999999997]
["Carolina BeachWaterInside","Carolina Beach","Water","Inside",1.37,12294,"5,000 gallons (668 cf)",34.619999999999997]
["Carolina Water ServiceWaterInside","Carolina Water Service","Water","Inside",null,58130,"5,000 gallons (668 cf)",83.08]
["Carteret CountyWaterInside","Carteret County","Water","Inside",1.0900000000000001,3021,"5,000 gallons (668 cf)",80.650000000000006]
["Carteret County - Merrimon SystemWaterInside","Carteret County - Merrimon System","Water","Inside",1.0900000000000001,71,"5,000 gallons (668 cf)",63.8]
["CarthageWaterInside","Carthage","Water","Inside",0.9,3609,"5,000 gallons (668 cf)",43]
["CaryWaterInside","Cary","Water","Inside",1.21,212000,"5,000 gallons (668 cf)",28.57]
["Catawba CountyWaterInside","Catawba County","Water","Inside",null,3089,"5,000 gallons (668 cf)",54.22]
["Cerro GordoWaterInside","Cerro Gordo","Water","Inside",0.47,231,"5,000 gallons (668 cf)",24]
["ChadbournWaterInside","Chadbourn","Water","Inside",0.88,2370,"5,000 gallons (668 cf)",42.88]
["Charlotte WaterWaterInside","Charlotte Water","Water","Inside",1.1599999999999999,1122573,"5,000 gallons (668 cf)",19.89]
["Chatham CountyWaterInside","Chatham County","Water","Inside",1.53,26680,"5,000 gallons (668 cf)",50]
["CherryvilleWaterInside","Cherryville","Water","Inside",1.04,6353,"5,000 gallons (668 cf)",43]
["Chimney Rock Water WorksWaterInside","Chimney Rock Water Works","Water","Inside",0.62,366,"5,000 gallons (668 cf)",31.25]
["Chinquapin Water AssociationWaterInside","Chinquapin Water Association","Water","Inside",null,4686,"5,000 gallons (668 cf)",31.25]
["ChocowinityWaterInside","Chocowinity","Water","Inside",0.88,2565,"5,000 gallons (668 cf)",43.5]
["Chowan CountyWaterInside","Chowan County","Water","Inside",0.98,10762,"5,000 gallons (668 cf)",35]
["ClaremontWaterInside","Claremont","Water","Inside",1.19,2525,"5,000 gallons (668 cf)",33.590000000000003]
["ClarktonWaterInside","Clarkton","Water","Inside",1.02,1500,"5,000 gallons (668 cf)",28.75]
["Clay County Water and Sewer DistrictWaterInside","Clay County Water and Sewer District","Water","Inside",0.74,1870,"5,000 gallons (668 cf)",24.35]
["ClaytonWaterInside","Clayton","Water","Inside",1.0900000000000001,29967,"5,000 gallons (668 cf)",45.5]
["ClevelandWaterInside","Cleveland","Water","Inside",1.0900000000000001,872,"5,000 gallons (668 cf)",32.380000000000003]
["Cleveland County WaterWaterInside","Cleveland County Water","Water","Inside",1.03,54978,"5,000 gallons (668 cf)",31.76]
["ClintonWaterInside","Clinton","Water","Inside",1.03,12459,"5,000 gallons (668 cf)",22.75]
["ClydeWaterInside","Clyde","Water","Inside",1,3264,"5,000 gallons (668 cf)",40.82]
["CoatsWaterInside","Coats","Water","Inside",1.1299999999999999,2831,"5,000 gallons (668 cf)",32.75]
["ColumbiaWaterInside","Columbia","Water","Inside",0.59,891,"5,000 gallons (668 cf)",36.22]
["ColumbusWaterInside","Columbus","Water","Inside",1.2,2436,"5,000 gallons (668 cf)",31.05]
["Columbus CountyWaterInside","Columbus County","Water","Inside",1.21,14576,"5,000 gallons (668 cf)",49.05]
["ConcordWaterInside","Concord","Water","Inside",1.17,116845,"5,000 gallons (668 cf)",31.39]
["Concord Community Water SystemWaterInside","Concord Community Water System","Water","Inside",null,1867,"5,000 gallons (668 cf)",39]
["Conetoe Community Water AssociationWaterInside","Conetoe Community Water Association","Water","Inside",null,990,"5,000 gallons (668 cf)",31]
["ConoverWaterInside","Conover","Water","Inside",1.23,15230,"5,000 gallons (668 cf)",26.54]
["ConwayWaterInside","Conway","Water","Inside",0.94,887,"5,000 gallons (668 cf)",20.75]
["Cove CityWaterInside","Cove City","Water","Inside",null,440,"5,000 gallons (668 cf)",61]
["Craven CountyWaterInside","Craven County","Water","Inside",1.04,36830,"5,000 gallons (668 cf)",21]
["CreswellWaterInside","Creswell","Water","Inside",0.77,482,"5,000 gallons (668 cf)",79.099999999999994]
["CrossnoreWaterInside","Crossnore","Water","Inside",0.8,195,"5,000 gallons (668 cf)",24]
["Cumberland County - Kelly Hills DistrictWaterInside","Cumberland County - Kelly Hills District","Water","Inside",0.84,109,"5,000 gallons (668 cf)",66.58]
["Cumberland County - SouthpointWaterInside","Cumberland County - Southpoint","Water","Inside",0.84,124,"5,000 gallons (668 cf)",60.44]
["Currituck County - Mainland Water DepartmentWaterInside","Currituck County - Mainland Water Department","Water","Inside",1.3,17430,"5,000 gallons (668 cf)",43.3]
["Currituck County - Ocean Sands Water-Sewer DistrictWaterInside","Currituck County - Ocean Sands Water-Sewer District","Water","Inside",1.3,2600,"5,000 gallons (668 cf)",44.1]
["Currituck County - Southern Outer BanksWaterInside","Currituck County - Southern Outer Banks","Water","Inside",1.3,8209,"5,000 gallons (668 cf)",44.1]
["DallasWaterInside","Dallas","Water","Inside",1.1000000000000001,7864,"5,000 gallons (668 cf)",38.450000000000003]
["Dan River Water Inc.WaterInside","Dan River Water Inc.","Water","Inside",null,11890,"5,000 gallons (668 cf)",46.55]
["Dare CountyWaterInside","Dare County","Water","Inside",1.1200000000000001,25135,"5,000 gallons (668 cf)",34.340000000000003]
["Davie County - MocksvilleWaterInside","Davie County - Mocksville","Water","Inside",1.25,29947,"5,000 gallons (668 cf)",153.38999999999999]
["Deep Run Water CorpWaterInside","Deep Run Water Corp","Water","Inside",null,13332,"5,000 gallons (668 cf)",40]
["DentonWaterInside","Denton","Water","Inside",1.1000000000000001,3080,"5,000 gallons (668 cf)",58.29]
["DobsonWaterInside","Dobson","Water","Inside",0.87,2615,"5,000 gallons (668 cf)",43.75]
["DoverWaterInside","Dover","Water","Inside",0.48,425,"5,000 gallons (668 cf)",33.75]
["DrexelWaterInside","Drexel","Water","Inside",1.08,2990,"5,000 gallons (668 cf)",46.9]
["DublinWaterInside","Dublin","Water","Inside",0.91,447,"5,000 gallons (668 cf)",39.380000000000003]
["DunnWaterInside","Dunn","Water","Inside",1.06,12189,"5,000 gallons (668 cf)",32.700000000000003]
["Duplin CoWaterInside","Duplin Co","Water","Inside",1.27,18542,"5,000 gallons (668 cf)",33.75]
["DurhamWaterInside","Durham","Water","Inside",1.22,309355,"5,000 gallons (668 cf)",28.84]
[{"$f":"B132&C132&D132","v":"East ArcadiaWaterInside"},"East Arcadia","Water","Inside",0.95,609,"5,000 gallons (668 cf)",24]
["East BendWaterInside","East Bend","Water","Inside",1.1000000000000001,1466,"5,000 gallons (668 cf)",90.64]
["East SpencerWaterInside","East Spencer","Water","Inside",1.05,1550,"5,000 gallons (668 cf)",58.15]
["Eastern Pines Water CorporationWaterInside","Eastern Pines Water Corporation","Water","Inside",null,22230,"5,000 gallons (668 cf)",42.5]
["Eastover Sanitary DistrictWaterInside","Eastover Sanitary District","Water","Inside",null,7571,"5,000 gallons (668 cf)",51.8]
["EdenWaterInside","Eden","Water","Inside",0.91,15023,"5,000 gallons (668 cf)",40.799999999999997]
["EdentonWaterInside","Edenton","Water","Inside",1.05,5500,"5,000 gallons (668 cf)",50.61]
["Edgecombe Co WSDWaterInside","Edgecombe Co WSD","Water","Inside",1.07,12845,"5,000 gallons (668 cf)",65.25]
["Elizabeth CityWaterInside","Elizabeth City","Water","Inside",1.08,19723,"5,000 gallons (668 cf)",50.95]
["ElizabethtownWaterInside","Elizabethtown","Water","Inside",0.85,5311,"5,000 gallons (668 cf)",25.28]
["Elk ParkWaterInside","Elk Park","Water","Inside",0.75,495,"5,000 gallons (668 cf)",24.5]
["ElkinWaterInside","Elkin","Water","Inside",1.51,4120,"5,000 gallons (668 cf)",37.5]
["EllenboroWaterInside","Ellenboro","Water","Inside",1.04,2258,"5,000 gallons (668 cf)",38.75]
["EllerbeWaterInside","Ellerbe","Water","Inside",0.76,1640,"5,000 gallons (668 cf)",23.68]
["Elm CityWaterInside","Elm City","Water","Inside",0.9,1720,"5,000 gallons (668 cf)",40.24]
["ElonWaterInside","Elon","Water","Inside",1.33,12752,"5,000 gallons (668 cf)",35.64]
["Energy United WaterWaterInside","Energy United Water","Water","Inside",null,13445,"5,000 gallons (668 cf)",38]
["Enfield Water SystemWaterInside","Enfield Water System","Water","Inside",1.02,2206,"5,000 gallons (668 cf)",58]
["EverettsWaterInside","Everetts","Water","Inside",0.56999999999999995,419,"5,000 gallons (668 cf)",84]
["Fair BluffWaterInside","Fair Bluff","Water","Inside",0.83,930,"5,000 gallons (668 cf)",22.5]
["FairmontWaterInside","Fairmont","Water","Inside",0.84,2837,"5,000 gallons (668 cf)",66.56]
["FaisonWaterInside","Faison","Water","Inside",0.72,1410,"5,000 gallons (668 cf)",32.5]
["FalconWaterInside","Falcon","Water","Inside",0.87,714,"5,000 gallons (668 cf)",30.14]
["Fallston Water SystemWaterInside","Fallston Water System","Water","Inside",0.74,589,"5,000 gallons (668 cf)",29.4]
["FarmvilleWaterInside","Farmville","Water","Inside",1.1100000000000001,8458,"5,000 gallons (668 cf)",56.49]
["FayettevilleWaterInside","Fayetteville","Water","Inside",1.32,213253,"5,000 gallons (668 cf)",31.75]
["First Craven Sanitary DistrictWaterInside","First Craven Sanitary District","Water","Inside",1.22,6325,"5,000 gallons (668 cf)",36]
["Fontana DamWaterInside","Fontana Dam","Water","Inside",0.37,950,"5,000 gallons (668 cf)",20]
["Forest CityWaterInside","Forest City","Water","Inside",1.01,21366,"5,000 gallons (668 cf)",22.37]
["Fork Township SDWaterInside","Fork Township SD","Water","Inside",1.1299999999999999,11864,"5,000 gallons (668 cf)",40.4]
["FountainWaterInside","Fountain","Water","Inside",0.88,427,"5,000 gallons (668 cf)",54.48]
["Four OaksWaterInside","Four Oaks","Water","Inside",1.1499999999999999,2776,"5,000 gallons (668 cf)",32.67]
["Foxfire VillageWaterInside","Foxfire Village","Water","Inside",1.59,1782,"5,000 gallons (668 cf)",31.76]
["FranklinWaterInside","Franklin","Water","Inside",1.37,9650,"5,000 gallons (668 cf)",34.950000000000003]
["Franklin County Public UtilitiesWaterInside","Franklin County Public Utilities","Water","Inside",1.45,17689,"5,000 gallons (668 cf)",65.11]
["FranklinvilleWaterInside","Franklinville","Water","Inside",0.79,1400,"5,000 gallons (668 cf)",57.5]
["FremontWaterInside","Fremont","Water","Inside",1.1100000000000001,1463,"5,000 gallons (668 cf)",52.77]
["Fuquay-VarinaWaterInside","Fuquay-Varina","Water","Inside",1.67,39115,"5,000 gallons (668 cf)",39.64]
["GarlandWaterInside","Garland","Water","Inside",1.08,625,"5,000 gallons (668 cf)",30.5]
["Gates CoWaterInside","Gates Co","Water","Inside",0.86,11621,"5,000 gallons (668 cf)",25.5]
["Gibson (Scotland Co - South WSD)WaterInside","Gibson (Scotland Co - South WSD)","Water","Inside",0.56000000000000005,589,"5,000 gallons (668 cf)",28.63]
["GibsonvilleWaterInside","Gibsonville","Water","Inside",1.22,7129,"5,000 gallons (668 cf)",24.8]
["GodwinWaterInside","Godwin","Water","Inside",1.36,275,"5,000 gallons (668 cf)",53]
["GoldsboroWaterInside","Goldsboro","Water","Inside",1.1599999999999999,34959,"5,000 gallons (668 cf)",37.31]
["Goldston Gulf SDWaterInside","Goldston Gulf SD","Water","Inside",0.89,1285,"5,000 gallons (668 cf)",55]
["GrahamWaterInside","Graham","Water","Inside",1.1000000000000001,17158,"5,000 gallons (668 cf)",23.33]
["Granite FallsWaterInside","Granite Falls","Water","Inside",0.89,7318,"5,000 gallons (668 cf)",37.64]
["Green LevelWaterInside","Green Level","Water","Inside",1.1499999999999999,2450,"5,000 gallons (668 cf)",41.67]
["Greene County RWSWaterInside","Greene County RWS","Water","Inside",0.85,10183,"5,000 gallons (668 cf)",30.49]
["GreeneversWaterInside","Greenevers","Water","Inside",1.0900000000000001,1390,"5,000 gallons (668 cf)",28.85]
["GreensboroWaterInside","Greensboro","Water","Inside",1.29,318057,"5,000 gallons (668 cf)",23]
["Greenville Utilities CommissionWaterInside","Greenville Utilities Commission","Water","Inside",1.1399999999999999,103140,"5,000 gallons (668 cf)",32.840000000000003]
["GriftonWaterInside","Grifton","Water","Inside",0.91,2982,"5,000 gallons (668 cf)",42.9]
["GrimeslandWaterInside","Grimesland","Water","Inside",0.65,610,"5,000 gallons (668 cf)",42.15]
["GroverWaterInside","Grover","Water","Inside",0.75,690,"5,000 gallons (668 cf)",34.08]
["HalifaxWaterInside","Halifax","Water","Inside",null,20250,"5,000 gallons (668 cf)",63.5]
["Halifax CountyWaterInside","Halifax County","Water","Inside",1.02,20250,"5,000 gallons (668 cf)",47.25]
["HamiltonWaterInside","Hamilton","Water","Inside",0.67,408,"5,000 gallons (668 cf)",55.15]
["Hamlet Water SystemWaterInside","Hamlet Water System","Water","Inside",0.87,10289,"5,000 gallons (668 cf)",30.5]
["Handy Sanitary DistrictWaterInside","Handy Sanitary District","Water","Inside",1.2,7899,"5,000 gallons (668 cf)",41]
["Harkers Island WSDWaterInside","Harkers Island WSD","Water","Inside",1.17,2358,"5,000 gallons (668 cf)",40.25]
["Harnett  Regional Water SystemWaterInside","Harnett  Regional Water System","Water","Inside",1.28,107373,"5,000 gallons (668 cf)",36.5]
["Harrells Water CorporationWaterInside","Harrells Water Corporation","Water","Inside",null,1633,"5,000 gallons (668 cf)",28]
["HarrellsvilleWaterInside","Harrellsville","Water","Inside",1.06,843,"5,000 gallons (668 cf)",35]
[{"$f":"B196&C196&D196","v":"HarrisburgWaterInside"},"Harrisburg","Water","Inside",1.21,18115,"5,000 gallons (668 cf)",33.89]
["HavelockWaterInside","Havelock","Water","Inside",1.1100000000000001,14550,"5,000 gallons (668 cf)",28.96]
["Haw RiverWaterInside","Haw River","Water","Inside",0.87,2450,"5,000 gallons (668 cf)",39.270000000000003]
["HendersonWaterInside","Henderson","Water","Inside",1.22,14998,"5,000 gallons (668 cf)",16.600000000000001]
["HendersonvilleWaterInside","Hendersonville","Water","Inside",0.98,78298,"5,000 gallons (668 cf)",30.72]
["HertfordWaterInside","Hertford","Water","Inside",1.05,2145,"5,000 gallons (668 cf)",67.459999999999994]
["Hertford County Rural WaterWaterInside","Hertford County Rural Water","Water","Inside",1.19,7970,"5,000 gallons (668 cf)",37]
["HickoryWaterInside","Hickory","Water","Inside",1.25,66256,"5,000 gallons (668 cf)",27.11]
["High PointWaterInside","High Point","Water","Inside",1.32,116065,"5,000 gallons (668 cf)",32.020000000000003]
["High ShoalsWaterInside","High Shoals","Water","Inside",0.71,729,"5,000 gallons (668 cf)",42]
["HighlandsWaterInside","Highlands","Water","Inside",0.85,6614,"5,000 gallons (668 cf)",36]
["HillsboroughWaterInside","Hillsborough","Water","Inside",1.26,15238,"5,000 gallons (668 cf)",50.6]
["HobgoodWaterInside","Hobgood","Water","Inside",0.59,665,"5,000 gallons (668 cf)",41]
["Hoke County Regional Water SystemWaterInside","Hoke County Regional Water System","Water","Inside",1,30819,"5,000 gallons (668 cf)",29]
["Holden BeachWaterInside","Holden Beach","Water","Inside",1.1200000000000001,6358,"5,000 gallons (668 cf)",39.1]
["Holly SpringsWaterInside","Holly Springs","Water","Inside",1.04,45058,"5,000 gallons (668 cf)",35.92]
["Hot SpringsWaterInside","Hot Springs","Water","Inside",0.91,887,"5,000 gallons (668 cf)",21.25]
["Hyde CountyWaterInside","Hyde County","Water","Inside",0.88,5256,"5,000 gallons (668 cf)",58]
["Icard Township WCWaterInside","Icard Township WC","Water","Inside",null,7821,"5,000 gallons (668 cf)",34.36]
["Iredell Water CorporationWaterInside","Iredell Water Corporation","Water","Inside",null,24733,"5,000 gallons (668 cf)",35.5]
["JacksonWaterInside","Jackson","Water","Inside",0.94,500,"5,000 gallons (668 cf)",30.5]
["JacksonvilleWaterInside","Jacksonville","Water","Inside",1.17,41156,"5,000 gallons (668 cf)",28.34]
["JamestownWaterInside","Jamestown","Water","Inside",1.1000000000000001,6543,"5,000 gallons (668 cf)",21.72]
["JamesvilleWaterInside","Jamesville","Water","Inside",1.56,440,"5,000 gallons (668 cf)",52.48]
["Jason Water CorporationWaterInside","Jason Water Corporation","Water","Inside",null,331,"5,000 gallons (668 cf)",50]
["JeffersonWaterInside","Jefferson","Water","Inside",0.89,1620,"5,000 gallons (668 cf)",40.81]
["Johnston CountyWaterInside","Johnston County","Water","Inside",1.33,110635,"5,000 gallons (668 cf)",43]
["Jones County Regional Water SystemWaterInside","Jones County Regional Water System","Water","Inside",1.0900000000000001,8999,"5,000 gallons (668 cf)",38.35]
["JonesvilleWaterInside","Jonesville","Water","Inside",1.03,2250,"5,000 gallons (668 cf)",53.45]
["Junaluska SDWaterInside","Junaluska SD","Water","Inside",0.92,4613,"5,000 gallons (668 cf)",50.6]
["KannapolisWaterInside","Kannapolis","Water","Inside",1.19,51995,"5,000 gallons (668 cf)",40.950000000000003]
["KenansvilleWaterInside","Kenansville","Water","Inside",0.78,876,"5,000 gallons (668 cf)",40.049999999999997]
["KenlyWaterInside","Kenly","Water","Inside",0.91,1400,"5,000 gallons (668 cf)",38.6]
["Kill Devil HillsWaterInside","Kill Devil Hills","Water","Inside",null,7200,"5,000 gallons (668 cf)",52.5]
["KingWaterInside","King","Water","Inside",1.0900000000000001,23198,"5,000 gallons (668 cf)",24.53]
["Kings MountainWaterInside","Kings Mountain","Water","Inside",0.88,13484,"5,000 gallons (668 cf)",21.37]
["KinstonWaterInside","Kinston","Water","Inside",1.17,27475,"5,000 gallons (668 cf)",41.86]
["Kure BeachWaterInside","Kure Beach","Water","Inside",1.22,5110,"5,000 gallons (668 cf)",29.84]
["La GrangeWaterInside","La Grange","Water","Inside",1.01,3167,"5,000 gallons (668 cf)",30.85]
["Lake LureWaterInside","Lake Lure","Water","Inside",1.4,1275,"5,000 gallons (668 cf)",64]
["Lake SanteetlahWaterInside","Lake Santeetlah","Water","Inside",1.48,498,"5,000 gallons (668 cf)",64.17]
["Lake WaccamawWaterInside","Lake Waccamaw","Water","Inside",1.45,2469,"5,000 gallons (668 cf)",31.5]
["LandisWaterInside","Landis","Water","Inside",null,3200,"5,000 gallons (668 cf)",56.75]
["LansingWaterInside","Lansing","Water","Inside",0.6,228,"5,000 gallons (668 cf)",25.55]
["LattimoreWaterInside","Lattimore","Water","Inside",null,618,"5,000 gallons (668 cf)",37.409999999999997]
["LaurinburgWaterInside","Laurinburg","Water","Inside",0.94,18288,"5,000 gallons (668 cf)",20.02]
["LawndaleWaterInside","Lawndale","Water","Inside",0.46,636,"5,000 gallons (668 cf)",53.1]
["Lea Acres Water CompanyWaterInside","Lea Acres Water Company","Water","Inside",null,120,"5,000 gallons (668 cf)",42]
["LenoirWaterInside","Lenoir","Water","Inside",1.23,23192,"5,000 gallons (668 cf)",25.57]
["LexingtonWaterInside","Lexington","Water","Inside",1.02,19632,"5,000 gallons (668 cf)",35.19]
["LibertyWaterInside","Liberty","Water","Inside",0.76,2655,"5,000 gallons (668 cf)",23.44]
["LilesvilleWaterInside","Lilesville","Water","Inside",0.73,900,"5,000 gallons (668 cf)",52.64]
["LillingtonWaterInside","Lillington","Water","Inside",1.02,3883,"5,000 gallons (668 cf)",33.76]
["Lincoln CountyWaterInside","Lincoln County","Water","Inside",1.5,45192,"5,000 gallons (668 cf)",37.14]
["LincolntonWaterInside","Lincolnton","Water","Inside",1.19,13135,"5,000 gallons (668 cf)",29.99]
["LindenWaterInside","Linden","Water","Inside",1.26,2077,"5,000 gallons (668 cf)",48.5]
["LittletonWaterInside","Littleton","Water","Inside",0.59,1540,"5,000 gallons (668 cf)",92]
["LongviewWaterInside","Longview","Water","Inside",0.96,4717,"5,000 gallons (668 cf)",27.47]
["LouisburgWaterInside","Louisburg","Water","Inside",1.03,3312,"5,000 gallons (668 cf)",40.01]
["LowellWaterInside","Lowell","Water","Inside",1.04,3725,"5,000 gallons (668 cf)",43.03]
["LucamaWaterInside","Lucama","Water","Inside",0.82,881,"5,000 gallons (668 cf)",59.5]
["LumbertonWaterInside","Lumberton","Water","Inside",1.1499999999999999,23129,"5,000 gallons (668 cf)",24.38]
["MacclesfieldWaterInside","Macclesfield","Water","Inside",0.6,494,"5,000 gallons (668 cf)",62.21]
["MadisonWaterInside","Madison","Water","Inside",0.88,2116,"5,000 gallons (668 cf)",40.270000000000003]
[{"$f":"B260&C260&D260","v":"Maggie Valley Sanitary District - gravity fedWaterInside"},"Maggie Valley Sanitary District - gravity fed","Water","Inside",1.06,9913,"5,000 gallons (668 cf)",42]
["Maggie Valley Sanitary District - pumped 1xWaterInside","Maggie Valley Sanitary District - pumped 1x","Water","Inside",1.06,9527,"5,000 gallons (668 cf)",43]
["Maggie Valley Sanitary District - pumped 2xWaterInside","Maggie Valley Sanitary District - pumped 2x","Water","Inside",1.06,9527,"5,000 gallons (668 cf)",45]
["Maggie Valley Sanitary District - pumped 3xWaterInside","Maggie Valley Sanitary District - pumped 3x","Water","Inside",1.06,9527,"5,000 gallons (668 cf)",47,{"$f":"MEDIAN(H260:H263)","v":44}]
["MagnoliaWaterInside","Magnolia","Water","Inside",0.56999999999999995,980,"5,000 gallons (668 cf)",46.96]
["MaidenWaterInside","Maiden","Water","Inside",0.88,5275,"5,000 gallons (668 cf)",23.66]
["ManteoWaterInside","Manteo","Water","Inside",1,2638,"5,000 gallons (668 cf)",33.49]
["MarionWaterInside","Marion","Water","Inside",0.9,9362,"5,000 gallons (668 cf)",27.74]
["Mars HillWaterInside","Mars Hill","Water","Inside",1.1000000000000001,3150,"5,000 gallons (668 cf)",37.06]
["MarshallWaterInside","Marshall","Water","Inside",0.97,1402,"5,000 gallons (668 cf)",47.16]
["MarshvilleWaterInside","Marshville","Water","Inside",0.99,3163,"5,000 gallons (668 cf)",37.75]
["Martin CountyWaterInside","Martin County","Water","Inside",1.17,4902,"5,000 gallons (668 cf)",74]
["Maury Sanitary Land DistrictWaterInside","Maury Sanitary Land District","Water","Inside",1.05,468,"5,000 gallons (668 cf)",55]
["MaxtonWaterInside","Maxton","Water","Inside",0.73,2353,"5,000 gallons (668 cf)",21.8]
["MayodanWaterInside","Mayodan","Water","Inside",1.48,2418,"5,000 gallons (668 cf)",45.57]
["MaysvilleWaterInside","Maysville","Water","Inside",0.79,1100,"5,000 gallons (668 cf)",49.56]
["McDowell CountyWaterInside","McDowell County","Water","Inside",0.68,902,"5,000 gallons (668 cf)",46.1]
["MebaneWaterInside","Mebane","Water","Inside",1.3,18579,"5,000 gallons (668 cf)",35.65]
["Micro (County Line)WaterInside","Micro (County Line)","Water","Inside",1.02,484,"5,000 gallons (668 cf)",32.619999999999997]
["MiddlesexWaterInside","Middlesex","Water","Inside",0.73,975,"5,000 gallons (668 cf)",33]
["Millennium Water AssociationWaterInside","Millennium Water Association","Water","Inside",null,711,"5,000 gallons (668 cf)",31.5]
["MiltonWaterInside","Milton","Water","Inside",0.67,212,"5,000 gallons (668 cf)",86.5]
["MocksvilleWaterInside","Mocksville","Water","Inside",1.34,5472,"5,000 gallons (668 cf)",37.299999999999997]
["MonroeWaterInside","Monroe","Water","Inside",2.52,31438,"5,000 gallons (668 cf)",28.07]
["Montgomery CoWaterInside","Montgomery Co","Water","Inside",1.27,14599,"5,000 gallons (668 cf)",41]
["MontreatWaterInside","Montreat","Water","Inside",1.07,798,"5,000 gallons (668 cf)",39.1]
["Moore CountyWaterInside","Moore County","Water","Inside",1.1599999999999999,39380,"5,000 gallons (668 cf)",31.46]
["Moore County - East Moore Water DistrictWaterInside","Moore County - East Moore Water District","Water","Inside",1.1599999999999999,7990,"5,000 gallons (668 cf)",48.29]
["MooresvilleWaterInside","Mooresville","Water","Inside",1.4,49552,"5,000 gallons (668 cf)",27.81]
["Moravian Falls Water WorksWaterInside","Moravian Falls Water Works","Water","Inside",null,2951,"5,000 gallons (668 cf)",36.5]
["Morehead CityWaterInside","Morehead City","Water","Inside",1.07,9420,"5,000 gallons (668 cf)",44.54]
["MorgantonWaterInside","Morganton","Water","Inside",1.28,26576,"5,000 gallons (668 cf)",15.5]
["MorvenWaterInside","Morven","Water","Inside",0.67,512,"5,000 gallons (668 cf)",38.67]
["Mount AiryWaterInside","Mount Airy","Water","Inside",1.1100000000000001,10193,"5,000 gallons (668 cf)",25.53]
["Mount Airy - Flat Rock/BannertownWaterInside","Mount Airy - Flat Rock/Bannertown","Water","Inside",1.1100000000000001,71,"5,000 gallons (668 cf)",68.94]
["Mount GileadWaterInside","Mount Gilead","Water","Inside",0.93,1463,"5,000 gallons (668 cf)",40.299999999999997]
["Mount HollyWaterInside","Mount Holly","Water","Inside",1.51,17780,"5,000 gallons (668 cf)",25.56]
["Mount Holly - StanleyWaterInside","Mount Holly - Stanley","Water","Inside",1.51,5453,"5,000 gallons (668 cf)",206.74]
["Mount OliveWaterInside","Mount Olive","Water","Inside",1.33,4190,"5,000 gallons (668 cf)",24.66]
["Mt. PleasantWaterInside","Mt. Pleasant","Water","Inside",1.21,1967,"5,000 gallons (668 cf)",39.42]
["Mulberry Fairplains WAWaterInside","Mulberry Fairplains WA","Water","Inside",null,8150,"5,000 gallons (668 cf)",27.67]
["MurfreesboroWaterInside","Murfreesboro","Water","Inside",1.39,3645,"5,000 gallons (668 cf)",35]
["MurphyWaterInside","Murphy","Water","Inside",0.77,4498,"5,000 gallons (668 cf)",33.700000000000003]
["Nags HeadWaterInside","Nags Head","Water","Inside",1.1200000000000001,3125,"5,000 gallons (668 cf)",42.05]
["Nash County Area IIWaterInside","Nash County Area II","Water","Inside",1.1200000000000001,6571,"5,000 gallons (668 cf)",65]
["NashvilleWaterInside","Nashville","Water","Inside",0.75,8800,"5,000 gallons (668 cf)",37]
["New BernWaterInside","New Bern","Water","Inside",1.21,30070,"5,000 gallons (668 cf)",36.770000000000003]
["NewlandWaterInside","Newland","Water","Inside",null,999,"5,000 gallons (668 cf)",32.1]
["NewportWaterInside","Newport","Water","Inside",1.24,4829,"5,000 gallons (668 cf)",46.19]
["NewtonWaterInside","Newton","Water","Inside",1.1100000000000001,17094,"5,000 gallons (668 cf)",68.040000000000006]
["Newton GroveWaterInside","Newton Grove","Water","Inside",0.87,913,"5,000 gallons (668 cf)",32.25]
["NorlinaWaterInside","Norlina","Water","Inside",0.97,1108,"5,000 gallons (668 cf)",52.75]
["North Lenoir Water Corp.WaterInside","North Lenoir Water Corp.","Water","Inside",null,15215,"5,000 gallons (668 cf)",63]
["North WilkesboroWaterInside","North Wilkesboro","Water","Inside",1.1200000000000001,4245,"5,000 gallons (668 cf)",30.74]
["Northampton CountyWaterInside","Northampton County","Water","Inside",0.97,12759,"5,000 gallons (668 cf)",64.5]
["Northwest Onslow Water AssociationWaterInside","Northwest Onslow Water Association","Water","Inside",null,2052,"5,000 gallons (668 cf)",35.32]
["Northwest Water SupplyWaterInside","Northwest Water Supply","Water","Inside",null,1105,"5,000 gallons (668 cf)",21.5]
["NorwoodWaterInside","Norwood","Water","Inside",1.1000000000000001,4318,"5,000 gallons (668 cf)",50.8]
["Oak IslandWaterInside","Oak Island","Water","Inside",1.31,23896,"5,000 gallons (668 cf)",37.380000000000003]
["OakboroWaterInside","Oakboro","Water","Inside",0.91,3173,"5,000 gallons (668 cf)",36.380000000000003]
["Ocean Isle BeachWaterInside","Ocean Isle Beach","Water","Inside",1.26,7216,"5,000 gallons (668 cf)",46.85]
["Ocracoke Sanitary District - Step AWaterInside","Ocracoke Sanitary District - Step A","Water","Inside",0.98,900,"5,000 gallons (668 cf)",53.54]
["Ocracoke Sanitary District - Step BWaterInside","Ocracoke Sanitary District - Step B","Water","Inside",0.98,900,"5,000 gallons (668 cf)",53.54]
["Ocracoke Sanitary District - Step CWaterInside","Ocracoke Sanitary District - Step C","Water","Inside",0.98,900,"5,000 gallons (668 cf)",117.74,{"$f":"MEDIAN(H321:H323)","v":53.54}]
[{"$f":"B324&C324&D324","v":"Old FortWaterInside"},"Old Fort","Water","Inside",0.93,1700,"5,000 gallons (668 cf)",31.7]
["Old North State Water Company - Asheboro Country Club EstatesWaterInside","Old North State Water Company - Asheboro Country Club Estates","Water","Inside",null,26,"5,000 gallons (668 cf)",52.86]
["Old North State Water Company - Bingham Woods Mobile Home ParkWaterInside","Old North State Water Company - Bingham Woods Mobile Home Park","Water","Inside",null,190,"5,000 gallons (668 cf)",61.96]
["Old North State Water Company - Blawell SubdivisionWaterInside","Old North State Water Company - Blawell Subdivision","Water","Inside",null,96,"5,000 gallons (668 cf)",39.159999999999997]
["Old North State Water Company - Dogwood Acres SubdivisionWaterInside","Old North State Water Company - Dogwood Acres Subdivision","Water","Inside",null,88,"5,000 gallons (668 cf)",61.96]
["Old North State Water Company - Stateside SubdivisionWaterInside","Old North State Water Company - Stateside Subdivision","Water","Inside",null,26729,"5,000 gallons (668 cf)",45]
["Old North State Water Company - Twin Lake FarmWaterInside","Old North State Water Company - Twin Lake Farm","Water","Inside",null,208,"5,000 gallons (668 cf)",61.96]
["ONWASAWaterInside","ONWASA","Water","Inside",1.21,144155,"5,000 gallons (668 cf)",35.32]
["Orange-AlamanceWaterInside","Orange-Alamance","Water","Inside",null,8892,"5,000 gallons (668 cf)",46.4]
["OrientalWaterInside","Oriental","Water","Inside",0.96,1136,"5,000 gallons (668 cf)",35.950000000000003]
["Ossipee SDWaterInside","Ossipee SD","Water","Inside",0.79,2390,"5,000 gallons (668 cf)",58.15]
["Orange Water and Sewer AuthorityWaterInside","Orange Water and Sewer Authority","Water","Inside",1.1100000000000001,86300,"5,000 gallons (668 cf)",51.02]
["OxfordWaterInside","Oxford","Water","Inside",2.06,8721,"5,000 gallons (668 cf)",42.91]
["Pamlico County Water SystemWaterInside","Pamlico County Water System","Water","Inside",0.94,19665,"5,000 gallons (668 cf)",41.75]
["ParktonWaterInside","Parkton","Water","Inside",0.77,487,"5,000 gallons (668 cf)",44.6]
["ParmeleWaterInside","Parmele","Water","Inside",0.56000000000000005,262,"5,000 gallons (668 cf)",38]
["PeachlandWaterInside","Peachland","Water","Inside",0.79,423,"5,000 gallons (668 cf)",52.7]
["PembrokeWaterInside","Pembroke","Water","Inside",0.91,3204,"5,000 gallons (668 cf)",21.47]
["Pender County - Central Pender Water and Sewer District, Moore's Creek Water and Sewer DistrictWaterInside","Pender County - Central Pender Water and Sewer District, Moore's Creek Water and Sewer District","Water","Inside",1.27,25481,"5,000 gallons (668 cf)",65]
["Pender County - Maple Hill Water DistrictWaterInside","Pender County - Maple Hill Water District","Water","Inside",1.27,968,"5,000 gallons (668 cf)",49.5]
["Pender County - Rocky Point-Topsail Water and Sewer DistrictWaterInside","Pender County - Rocky Point-Topsail Water and Sewer District","Water","Inside",1.27,25481,"5,000 gallons (668 cf)",60]
["Pender County - Scott's Hill Water and Sewer DistrictWaterInside","Pender County - Scott's Hill Water and Sewer District","Water","Inside",1.27,25481,"5,000 gallons (668 cf)",60,{"$f":"MEDIAN(H342:H345)","v":60}]
["Perquimans CountyWaterInside","Perquimans County","Water","Inside",1.08,11314,"5,000 gallons (668 cf)",53.5]
["Pfeiffer-North Stanly WAWaterInside","Pfeiffer-North Stanly WA","Water","Inside",null,4199,"5,000 gallons (668 cf)",46.53]
["PikevilleWaterInside","Pikeville","Water","Inside",1,896,"5,000 gallons (668 cf)",68.599999999999994]
["Pilot MountainWaterInside","Pilot Mountain","Water","Inside",0.87,1976,"5,000 gallons (668 cf)",52.68]
["Pine Knoll ShoresWaterInside","Pine Knoll Shores","Water","Inside",1.19,4472,"5,000 gallons (668 cf)",35.299999999999997]
["Pine LevelWaterInside","Pine Level","Water","Inside",1.19,2651,"5,000 gallons (668 cf)",33.96]
["PinebluffWaterInside","Pinebluff","Water","Inside",1.26,2219,"5,000 gallons (668 cf)",32.799999999999997]
["PinetopsWaterInside","Pinetops","Water","Inside",1.1000000000000001,1312,"5,000 gallons (668 cf)",35.71]
["Pink HillWaterInside","Pink Hill","Water","Inside",0.73,950,"5,000 gallons (668 cf)",51.5]
["PittsboroWaterInside","Pittsboro","Water","Inside",1.46,4590,"5,000 gallons (668 cf)",69.87]
["PlymouthWaterInside","Plymouth","Water","Inside",0.88,3243,"5,000 gallons (668 cf)",63]
["PolktonWaterInside","Polkton","Water","Inside",1.1100000000000001,838,"5,000 gallons (668 cf)",48.79]
["PolkvilleWaterInside","Polkville","Water","Inside",null,516,"5,000 gallons (668 cf)",63]
["PollocksvilleWaterInside","Pollocksville","Water","Inside",0.77,858,"5,000 gallons (668 cf)",56.75]
["PowellsvilleWaterInside","Powellsville","Water","Inside",0.64,482,"5,000 gallons (668 cf)",40]
["PrincetonWaterInside","Princeton","Water","Inside",1.19,1326,"5,000 gallons (668 cf)",54.61]
["RaefordWaterInside","Raeford","Water","Inside",0.98,7119,"5,000 gallons (668 cf)",25.04]
["RaleighWaterInside","Raleigh","Water","Inside",1.75,620000,"5,000 gallons (668 cf)",30.57]
["RamseurWaterInside","Ramseur","Water","Inside",1.04,2893,"5,000 gallons (668 cf)",36.299999999999997]
["City of RandlemanWaterInside","City of Randleman","Water","Inside",1.22,6767,"5,000 gallons (668 cf)",38.65]
["RanloWaterInside","Ranlo","Water","Inside",1.21,4511,"5,000 gallons (668 cf)",47.95]
["Red SpringsWaterInside","Red Springs","Water","Inside",0.85,4493,"5,000 gallons (668 cf)",30]
["ReidsvilleWaterInside","Reidsville","Water","Inside",1.02,14087,"5,000 gallons (668 cf)",19.399999999999999]
["RhodhissWaterInside","Rhodhiss","Water","Inside",0.81,937,"5,000 gallons (668 cf)",50.66]
["Rich SquareWaterInside","Rich Square","Water","Inside",null,1067,"5,000 gallons (668 cf)",27.8]
["River BendWaterInside","River Bend","Water","Inside",1.24,2846,"5,000 gallons (668 cf)",36.619999999999997]
["Roanoke Rapids SDWaterInside","Roanoke Rapids SD","Water","Inside",1.1299999999999999,16615,"5,000 gallons (668 cf)",22.65]
["Robbins Water SystemWaterInside","Robbins Water System","Water","Inside",0.86,1579,"5,000 gallons (668 cf)",51.89]
["RobbinsvilleWaterInside","Robbinsville","Water","Inside",0.81,2916,"5,000 gallons (668 cf)",51.38]
["RobersonvilleWaterInside","Robersonville","Water","Inside",null,1445,"5,000 gallons (668 cf)",46.5]
["Robeson CoWaterInside","Robeson Co","Water","Inside",0.95,65303,"5,000 gallons (668 cf)",37.5]
["RockinghamWaterInside","Rockingham","Water","Inside",0.97,12204,"5,000 gallons (668 cf)",16.5]
["Rockingham CoWaterInside","Rockingham Co","Water","Inside",0.72,1111,"5,000 gallons (668 cf)",70]
["Rockingham CountyWaterInside","Rockingham County","Water","Inside",0.97,1111,"5,000 gallons (668 cf)",70]
["Rocky MountWaterInside","Rocky Mount","Water","Inside",0.91,54886,"5,000 gallons (668 cf)",21.57]
["RondaWaterInside","Ronda","Water","Inside",null,938,"5,000 gallons (668 cf)",38.58]
["RoperWaterInside","Roper","Water","Inside",0.68,546,"5,000 gallons (668 cf)",61]
["Rose HillWaterInside","Rose Hill","Water","Inside",0.8,1867,"5,000 gallons (668 cf)",36.380000000000003]
["RoseboroWaterInside","Roseboro","Water","Inside",1.01,1278,"5,000 gallons (668 cf)",33.1]
["RosmanWaterInside","Rosman","Water","Inside",1.0900000000000001,650,"5,000 gallons (668 cf)",39.29]
["RowlandWaterInside","Rowland","Water","Inside",0.77,1341,"5,000 gallons (668 cf)",33.950000000000003]
["RoxboroWaterInside","Roxboro","Water","Inside",0.88,10832,"5,000 gallons (668 cf)",30.42]
[{"$f":"B388&C388&D388","v":"Rutherford CollegeWaterInside"},"Rutherford College","Water","Inside",1.05,2083,"5,000 gallons (668 cf)",29.9]
["SalemburgWaterInside","Salemburg","Water","Inside",0.91,850,"5,000 gallons (668 cf)",31.75]
["SalisburyWaterInside","Salisbury","Water","Inside",1.37,48145,"5,000 gallons (668 cf)",32.79]
["SaludaWaterInside","Saluda","Water","Inside",1.33,1590,"5,000 gallons (668 cf)",66.25]
["Sampson CountyWaterInside","Sampson County","Water","Inside",1.1100000000000001,11992,"5,000 gallons (668 cf)",43.65]
["SandyfieldWaterInside","Sandyfield","Water","Inside",0.8,422,"5,000 gallons (668 cf)",25]
["SanfordWaterInside","Sanford","Water","Inside",1.01,47302,"5,000 gallons (668 cf)",39.729999999999997]
["SaratogaWaterInside","Saratoga","Water","Inside",0.83,426,"5,000 gallons (668 cf)",59.6]
["SawmillsWaterInside","Sawmills","Water","Inside",1.22,5524,"5,000 gallons (668 cf)",41.57]
["Scotland County - District I and IIWaterInside","Scotland County - District I and II","Water","Inside",1.23,1879,"5,000 gallons (668 cf)",42.09]
["Scotland NeckWaterInside","Scotland Neck","Water","Inside",1,2761,"5,000 gallons (668 cf)",64.849999999999994]
["SeaboardWaterInside","Seaboard","Water","Inside",1.34,495,"5,000 gallons (668 cf)",48.5]
["SelmaWaterInside","Selma","Water","Inside",1.26,6832,"5,000 gallons (668 cf)",46.2]
["Seven DevilsWaterInside","Seven Devils","Water","Inside",1.48,400,"5,000 gallons (668 cf)",50]
["SevernWaterInside","Severn","Water","Inside",0.92,325,"5,000 gallons (668 cf)",30]
["ShallotteWaterInside","Shallotte","Water","Inside",1.72,5862,"5,000 gallons (668 cf)",16.02]
["SharpsburgWaterInside","Sharpsburg","Water","Inside",0.94,1945,"5,000 gallons (668 cf)",52.25]
["ShelbyWaterInside","Shelby","Water","Inside",1.38,21824,"5,000 gallons (668 cf)",27.6]
["Siler CityWaterInside","Siler City","Water","Inside",null,8469,"5,000 gallons (668 cf)",41]
["SimsWaterInside","Sims","Water","Inside",1.32,440,"5,000 gallons (668 cf)",38]
["SmithfieldWaterInside","Smithfield","Water","Inside",1.44,13525,"5,000 gallons (668 cf)",33.11]
["Snow HillWaterInside","Snow Hill","Water","Inside",0.8,2657,"5,000 gallons (668 cf)",48]
["South Camden Water and Sewer DistrictWaterInside","South Camden Water and Sewer District","Water","Inside",0.92,5717,"5,000 gallons (668 cf)",41.5]
["South Granville Water and Sewer AuthorityWaterInside","South Granville Water and Sewer Authority","Water","Inside",1.51,19216,"5,000 gallons (668 cf)",53.35]
["South Greene WCWaterInside","South Greene WC","Water","Inside",null,2634,"5,000 gallons (668 cf)",30.49]
["South MillsWaterInside","South Mills","Water","Inside",null,3621,"5,000 gallons (668 cf)",97.13]
["Southern PinesWaterInside","Southern Pines","Water","Inside",1.1499999999999999,23690,"5,000 gallons (668 cf)",32.15]
["Southern Wayne SDWaterInside","Southern Wayne SD","Water","Inside",1.24,7793,"5,000 gallons (668 cf)",36.5]
["SouthportWaterInside","Southport","Water","Inside",1.32,6447,"5,000 gallons (668 cf)",37.85]
["SpartaWaterInside","Sparta","Water","Inside",1.03,1900,"5,000 gallons (668 cf)",40.450000000000003]
["Spring HopeWaterInside","Spring Hope","Water","Inside",0.65,1307,"5,000 gallons (668 cf)",59.43]
["Spring LakeWaterInside","Spring Lake","Water","Inside",0.85,11725,"5,000 gallons (668 cf)",39.26]
["Spruce PineWaterInside","Spruce Pine","Water","Inside",0.85,5661,"5,000 gallons (668 cf)",26]
["St PaulsWaterInside","St Pauls","Water","Inside",1.07,2862,"5,000 gallons (668 cf)",30.5]
["Polk Ford/Renee FordWaterInside","Polk Ford/Renee Ford","Water","Inside",1.25,934,"5,000 gallons (668 cf)",57.2]
["StanleyWaterInside","Stanley","Water","Inside",1.08,5453,"5,000 gallons (668 cf)",34.1]
["Stanly CountyWaterInside","Stanly County","Water","Inside",0.91,16684,"5,000 gallons (668 cf)",68.069999999999993]
["Stanly County - Greater Badin Water and Sewer DistrictWaterInside","Stanly County - Greater Badin Water and Sewer District","Water","Inside",0.91,127,"5,000 gallons (668 cf)",68.040000000000006]
["Stanly County - StanfieldWaterInside","Stanly County - Stanfield","Water","Inside",0.91,62148,"5,000 gallons (668 cf)",68.040000000000006]
["Stanly Water and Sewer AuthorityWaterInside","Stanly Water and Sewer Authority","Water","Inside",1.67,62148,"5,000 gallons (668 cf)",63.19]
["StantonsburgWaterInside","Stantonsburg","Water","Inside",1.07,1275,"5,000 gallons (668 cf)",42.75]
["StarWaterInside","Star","Water","Inside",1.07,933,"5,000 gallons (668 cf)",39.08]
["StatesvilleWaterInside","Statesville","Water","Inside",1.32,28419,"5,000 gallons (668 cf)",29.81]
["StedmanWaterInside","Stedman","Water","Inside",0.67,1506,"5,000 gallons (668 cf)",34.5]
["Stokes County Water and Sewer AuthorityWaterInside","Stokes County Water and Sewer Authority","Water","Inside",1.1599999999999999,420,"5,000 gallons (668 cf)",70]
["Stokes County Water and Sewer Authority - DanburyWaterInside","Stokes County Water and Sewer Authority - Danbury","Water","Inside",1.1599999999999999,250,"5,000 gallons (668 cf)",42.5,{"$f":"MEDIAN(H432:H433)","v":56.25}]
["Stokes Regional Water CorporationWaterInside","Stokes Regional Water Corporation","Water","Inside",null,3327,"5,000 gallons (668 cf)",52.5]
["StokesdaleWaterInside","Stokesdale","Water","Inside",1.21,1143,"5,000 gallons (668 cf)",59]
["StonevilleWaterInside","Stoneville","Water","Inside",0.81,1473,"5,000 gallons (668 cf)",50.38]
["StovallWaterInside","Stovall","Water","Inside",0.84,450,"5,000 gallons (668 cf)",67.8]
["Surf CityWaterInside","Surf City","Water","Inside",2.09,5606,"5,000 gallons (668 cf)",40.94]
["Surry County - Flat Rock/Bannertown Water and Sewer DistrictWaterInside","Surry County - Flat Rock/Bannertown Water and Sewer District","Water","Inside",0.61,71439,"5,000 gallons (668 cf)",67.400000000000006]
["Surry County - Gentry Road DistrictWaterInside","Surry County - Gentry Road District","Water","Inside",0.61,71439,"5,000 gallons (668 cf)",65.33]
["SwepsonvilleWaterInside","Swepsonville","Water","Inside",1.84,2145,"5,000 gallons (668 cf)",51.5]
["TarboroWaterInside","Tarboro","Water","Inside",0.81,10844,"5,000 gallons (668 cf)",19.829999999999998]
["TaylorsvilleWaterInside","Taylorsville","Water","Inside",0.8,3265,"5,000 gallons (668 cf)",37.5]
["TaylortownWaterInside","Taylortown","Water","Inside",1.05,904,"5,000 gallons (668 cf)",41.6]
["TeacheyWaterInside","Teachey","Water","Inside",1.1000000000000001,663,"5,000 gallons (668 cf)",54.5]
["testncWaterInside","testnc","Water","Inside",null,113410,"5,000 gallons (668 cf)",19]
["ThomasvilleWaterInside","Thomasville","Water","Inside",1.1200000000000001,27485,"5,000 gallons (668 cf)",36.909999999999997]
["Topsail BeachWaterInside","Topsail Beach","Water","Inside",1.17,3198,"5,000 gallons (668 cf)",62.5]
["TroutmanWaterInside","Troutman","Water","Inside",1.27,7223,"5,000 gallons (668 cf)",46.3]
["TroyWaterInside","Troy","Water","Inside",0.94,3591,"5,000 gallons (668 cf)",30.93]
["TryonWaterInside","Tryon","Water","Inside",0.77,5476,"5,000 gallons (668 cf)",39.93]
[{"$f":"B452&C452&D452","v":"Tuckaseigee WS AuthorityWaterInside"},"Tuckaseigee WS Authority","Water","Inside",1.1100000000000001,7503,"5,000 gallons (668 cf)",33.869999999999997]
["TurkeyWaterInside","Turkey","Water","Inside",1.05,300,"5,000 gallons (668 cf)",37.82]
["Two Rivers Utilities/GastoniaWaterInside","Two Rivers Utilities/Gastonia","Water","Inside",1.08,91491,"5,000 gallons (668 cf)",26.8]
["Tyrrell County Water DepartmentWaterInside","Tyrrell County Water Department","Water","Inside",0.99,3177,"5,000 gallons (668 cf)",73.55]
["Union CountyWaterInside","Union County","Water","Inside",1.41,145019,"5,000 gallons (668 cf)",42.36]
["Union Utilities Inc.WaterInside","Union Utilities Inc.","Water","Inside",null,353,"5,000 gallons (668 cf)",40]
["ValdeseWaterInside","Valdese","Water","Inside",1,13571,"5,000 gallons (668 cf)",44.05]
["Vance County Water DistrictWaterInside","Vance County Water District","Water","Inside",1.1599999999999999,3510,"5,000 gallons (668 cf)",81.650000000000006]
["VanceboroWaterInside","Vanceboro","Water","Inside",1.02,1864,"5,000 gallons (668 cf)",35.6]
["WadeWaterInside","Wade","Water","Inside",0.91,835,"5,000 gallons (668 cf)",39]
["WagramWaterInside","Wagram","Water","Inside",0.81,965,"5,000 gallons (668 cf)",30.5]
["WallaceWaterInside","Wallace","Water","Inside",1.26,5825,"5,000 gallons (668 cf)",30.7]
["Walnut CoveWaterInside","Walnut Cove","Water","Inside",0.79,2210,"5,000 gallons (668 cf)",28.57]
["Walnut CreekWaterInside","Walnut Creek","Water","Inside",1.2,900,"5,000 gallons (668 cf)",53.42]
["WalstonburgWaterInside","Walstonburg","Water","Inside",0.76,240,"5,000 gallons (668 cf)",91.5]
["Warren CountyWaterInside","Warren County","Water","Inside",1.07,9654,"5,000 gallons (668 cf)",50]
["WarrentonWaterInside","Warrenton","Water","Inside",0.87,2250,"5,000 gallons (668 cf)",64.8]
["WarsawWaterInside","Warsaw","Water","Inside",0.96,3151,"5,000 gallons (668 cf)",27.18]
["WashingtonWaterInside","Washington","Water","Inside",1.01,13000,"5,000 gallons (668 cf)",30.23]
["Washington County Water SystemWaterInside","Washington County Water System","Water","Inside",1.39,6413,"5,000 gallons (668 cf)",63]
["Wayne Water DistrictsWaterInside","Wayne Water Districts","Water","Inside",1.29,32425,"5,000 gallons (668 cf)",41.68]
["WaynesvilleWaterInside","Waynesville","Water","Inside",1.1299999999999999,19758,"5,000 gallons (668 cf)",23.82]
["WeavervilleWaterInside","Weaverville","Water","Inside",1.36,7882,"5,000 gallons (668 cf)",49.46]
["WeldonWaterInside","Weldon","Water","Inside",0.97,1402,"5,000 gallons (668 cf)",31.52]
["West Carteret Water CorporationWaterInside","West Carteret Water Corporation","Water","Inside",null,19512,"5,000 gallons (668 cf)",62]
["West Iredell Water CompanyWaterInside","West Iredell Water Company","Water","Inside",null,5926,"5,000 gallons (668 cf)",45]
["West JeffersonWaterInside","West Jefferson","Water","Inside",0.99,1305,"5,000 gallons (668 cf)",43.3]
["West Wilkes Water AssociationWaterInside","West Wilkes Water Association","Water","Inside",null,12202,"5,000 gallons (668 cf)",35.049999999999997]
["WhitakersWaterInside","Whitakers","Water","Inside",0.82,869,"5,000 gallons (668 cf)",65.150000000000006]
["WhitevilleWaterInside","Whiteville","Water","Inside",1.07,5426,"5,000 gallons (668 cf)",24.5]
["WhitsettWaterInside","Whitsett","Water","Inside",0.66,91,"5,000 gallons (668 cf)",72.5]
["Whittier Sanitary DistrictWaterInside","Whittier Sanitary District","Water","Inside",1.0900000000000001,252,"5,000 gallons (668 cf)",17.5]
["WilkesboroWaterInside","Wilkesboro","Water","Inside",1.1499999999999999,3705,"5,000 gallons (668 cf)",12.35]
["WilliamstonWaterInside","Williamston","Water","Inside",1.01,7650,"5,000 gallons (668 cf)",66.150000000000006]
["WilsonWaterInside","Wilson","Water","Inside",1.32,50001,"5,000 gallons (668 cf)",45.48]
["Wilson CountyWaterInside","Wilson County","Water","Inside",1.44,8936,"5,000 gallons (668 cf)",61]
["WindsorWaterInside","Windsor","Water","Inside",1.07,2433,"5,000 gallons (668 cf)",26.5]
["WingateWaterInside","Wingate","Water","Inside",1.1599999999999999,4201,"5,000 gallons (668 cf)",39.58]
["City of Winston-SalemWaterInside","City of Winston-Salem","Water","Inside",1.58,374403,"5,000 gallons (668 cf)",27.85]
["Winston-Salem - ClemmonsWaterInside","Winston-Salem - Clemmons","Water","Inside",1.58,374403,"5,000 gallons (668 cf)",27.83]
["Winston-Salem - KernersvilleWaterInside","Winston-Salem - Kernersville","Water","Inside",1.58,26376,"5,000 gallons (668 cf)",30.63]
["Winston-Salem - Rural HallWaterInside","Winston-Salem - Rural Hall","Water","Inside",1.58,374403,"5,000 gallons (668 cf)",27.85]
["Winston-Salem - WalkertownWaterInside","Winston-Salem - Walkertown","Water","Inside",1.58,5626,"5,000 gallons (668 cf)",27.85]
["Winterville, Town ofWaterInside","Winterville, Town of","Water","Inside",1.1100000000000001,10462,"5,000 gallons (668 cf)",29.02]
["WintonWaterInside","Winton","Water","Inside",0.82,756,"5,000 gallons (668 cf)",35.5]
["WoodlandWaterInside","Woodland","Water","Inside",0.86,767,"5,000 gallons (668 cf)",30.5]
["Wrightsville BeachWaterInside","Wrightsville Beach","Water","Inside",1.57,5300,"5,000 gallons (668 cf)",33.700000000000003]
["Yadkin County - JonesvilleWaterInside","Yadkin County - Jonesville","Water","Inside",0.53,277,"5,000 gallons (668 cf)",53.45]
["Yadkin County - YadkinvilleWaterInside","Yadkin County - Yadkinville","Water","Inside",0.53,37198,"5,000 gallons (668 cf)",39.76]
["YadkinvilleWaterInside","Yadkinville","Water","Inside",0.89,4196,"5,000 gallons (668 cf)",19.86]
["YanceyvilleWaterInside","Yanceyville","Water","Inside",1.02,1937,"5,000 gallons (668 cf)",35.69]
[]
[null,"Manual Change based on name in LWSP"]

{"sheet":"DWR_LWSP_Data_Systems","index":15,"n_rows":704,"n_cols":8,"rows_kept":704,"cut":false,"hidden":true,"merged":[]}
["PWSID","name","county","basin","active","ibt",null,"Inside Water Rate first 5k Gal."]
["98-76-543","AAA-1 Water Authority (test)","Alamance","Albemarle Sound (12-1)",null,"No",null,{"$f":"VLOOKUP(B2&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-63-020","Aberdeen","Moore","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B3&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24.55}]
["04-46-010","Ahoskie","Hertford","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B4&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.58}]
["02-01-035","Alamance","Alamance","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B5&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.85}]
["01-84-010","Albemarle","Stanly","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B6&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.46}]
["04-31-080","ALBERTSON WSD","Duplin","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B7&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-02-020","Alexander County WD","Alexander","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B8&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-20-020","Andrews","Cherokee","Hiwassee River (06-1)","Yes","No",null,{"$f":"VLOOKUP(B9&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43}]
["03-43-015","Angier","Harnett","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B10&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.77}]
["03-04-010","Anson Co","Anson","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B11&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":26.96}]
["03-04-012","Ansonville","Anson","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B12&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.04}]
["03-92-045","Apex","Wake","Haw River (02-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B13&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.25}]
["01-95-101","Appalachian State University","Watauga","New River (11-1)","Yes","No",null,{"$f":"VLOOKUP(B14&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-65-226","APPLE VALLEY","New Hanover","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B15&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-76-030","Archdale","Randolph","Deep River (02-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B16&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.35}]
["02-99-030","ARLINGTON","Yadkin","Yadkin River (18-1)","No","No",null,{"$f":"VLOOKUP(B17&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-76-010","Asheboro","Randolph","Deep River (02-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B18&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.5}]
["01-11-010","Asheville","Buncombe","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B19&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.43}]
["04-16-035","Atlantic Beach","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B20&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":29.65}]
["04-08-015","Aulander","Bertie","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B21&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38.5}]
["04-07-020","Aurora","Beaufort","Pamlico River & Sound (15-3)","Yes","No",null,{"$f":"VLOOKUP(B22&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43.36}]
["03-82-045","Autryville","Sampson","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B23&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":54.36}]
["04-74-025","Ayden","Pitt","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B24&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":53}]
["03-62-120","Badin Shores Resort","Montgomery","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B25&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-64-035","Bailey","Nash","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B26&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.549999999999997}]
["01-61-015","Bakersville","Mitchell","Nolichucky River (05-1)","Yes","No",null,{"$f":"VLOOKUP(B27&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":25}]
["04-10-130","Bald Head Island Utilities","Brunswick","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B28&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":61.49}]
["01-06-015","Banner Elk","Avery","Watauga River (16-1)","Yes","No",null,{"$f":"VLOOKUP(B29&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.799999999999997}]
["04-07-030","Bath","Beaufort","Pamlico River & Sound (15-3)","Yes","No",null,{"$f":"VLOOKUP(B30&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":63.5}]
["01-14-025","Baton Water Corporation","Caldwell","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B31&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32}]
["03-92-373","Bayleaf Master","Wake","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B32&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-59-035","Bear Grass","Martin","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B33&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-16-010","Beaufort","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B34&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.72}]
["04-07-035","Beaufort Co (Northside)","Beaufort","Pamlico River & Sound (15-3)","Yes","No",null,{"$f":"VLOOKUP(B35&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":58.8}]
["04-07-040","Beaufort Co (Southside)","Beaufort","Pamlico River & Sound (15-3)","Yes","No",null,{"$f":"VLOOKUP(B36&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":58.8}]
["04-07-612","Beaufort Co WD VI","Beaufort","Pamlico River & Sound (15-3)","No","No",null,{"$f":"VLOOKUP(B37&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":58.8}]
["04-07-999","BEAUFORT CO WD VI","Beaufort","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B38&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":58.8}]
["01-95-104","Beech Mountain","Watauga","Watauga River (16-1)","Yes","No",null,{"$f":"VLOOKUP(B39&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":54.96}]
["04-07-015","Belhaven","Beaufort","Pamlico River & Sound (15-3)","Yes","No",null,{"$f":"VLOOKUP(B40&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":65.34}]
["04-74-045","Bell Arthur WC","Pitt","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B41&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":51.47}]
["01-36-015","Belmont","Gaston","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B42&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.08}]
["04-71-111","Belvedere","Pender","New River (02-6)","Yes","No",null,{"$f":"VLOOKUP(B43&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-51-025","Benson","Johnston","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B44&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.1}]
["04-08-085","Bertie County RWS","Bertie","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B45&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":44}]
["01-36-025","Bessemer City","Gaston","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B46&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.15}]
["04-74-030","Bethel","Pitt","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B47&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-02-035","Bethlehem WD","Alexander","Catawba River (03-1)","No","No",null,{"$f":"VLOOKUP(B48&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-31-020","Beulaville","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B49&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.75}]
["20-84-006","Big Lick Road","Stanly","Rocky River (18-4)","Yes","No",null,{"$f":"VLOOKUP(B50&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-11-030","Biltmore Forest","Buncombe","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B51&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":49.68}]
["03-62-035","Biscoe","Montgomery","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B52&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.5}]
["04-98-035","Black Creek","Wilson","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B53&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.55}]
["01-11-020","Black Mountain","Buncombe","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B54&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["50-09-012","Bladen Bluffs - LCFWSA","Bladen","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B55&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-09-060","Bladen Co WD (East Bladen)","Bladen","Cape Fear River (02-3)","Yes","No",null,34]
["03-09-055","Bladen Co WD (West Bladen)","Bladen","Cape Fear River (02-3)","Yes","No",null,34]
["03-09-065","BLADEN CO WD - EAST ARCADIA","Bladen","Waccamaw River (09-3)","No","No",null,34]
["03-09-035","BLADEN CO WD - WHITE OAK","Bladen","Cape Fear River (02-3)","No","No",null,34]
["03-09-040","Bladen County Water District (Tar Heel)","Bladen","Cape Fear River (02-3)","No","No",null,34]
["03-09-015","Bladenboro","Bladen","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B61&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.52}]
["01-95-020","Blowing Rock","Watauga","New River (11-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B62&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.53}]
["01-97-030","Blue Ridge WA","Wilkes","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B63&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-24-075","Boardman","Columbus","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B64&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30}]
["04-16-028","Bogue Banks Water Corp","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B65&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.020000000000003}]
["04-10-998","Boiling Spring Lakes","Brunswick","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B66&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["70-10-048","Boiling Spring Lakes","Brunswick","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B67&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-23-025","Boiling Springs","Cleveland","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B68&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.409999999999997}]
["04-24-050","Bolton","Columbus","Waccamaw River (09-3)","Yes","No",null,{"$f":"VLOOKUP(B69&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.8}]
["01-95-010","Boone","Watauga","New River (11-1)","Yes","No",null,{"$f":"VLOOKUP(B70&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.950000000000003}]
["02-99-020","Boonville","Yadkin","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B71&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":47.7}]
["01-81-040","Bostic","Rutherford","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B72&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":44}]
["01-60-264","Bradfield Farms S/D","Mecklenburg","Rocky River (18-4)","Yes","No",null,{"$f":"VLOOKUP(B73&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["50-43-001","Bragg Communities","Harnett","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B74&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-16-163","Brandywine Bay","Carteret","White Oak River (17-1)","No","No",null,{"$f":"VLOOKUP(B75&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-12-103","Brentwood-Highway 64","Burke","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B76&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-12-104","Brentwood-Jamestown Road","Burke","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B77&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-88-010","Brevard","Transylvania","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B78&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":57.5}]
["04-65-192","BRICKSTONE - MARSH OAKS","New Hanover","New River (02-6)","No","No",null,{"$f":"VLOOKUP(B79&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-81-035","Broad River Water Authority","Rutherford","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B80&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":51.2}]
["03-53-015","Broadway","Lee","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B81&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24.7}]
["01-97-035","Broadway Water Association. Inc.","Wilkes","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B82&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.35}]
["01-18-050","BROOKFORD","Catawba","Catawba River (03-1)","No","No",null,{"$f":"VLOOKUP(B83&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-26-127","Brookwood Community","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B84&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-24-040","Brunswick","Columbus","Waccamaw River (09-3)","Yes","No",null,{"$f":"VLOOKUP(B85&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-10-045","Brunswick County","Brunswick","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B86&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.75}]
["04-10-070","Brunswick Regional WSD","Brunswick","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B87&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.5}]
["01-87-010","Bryson City","Swain","Tuskasegee River (07-2)","Yes","No",null,{"$f":"VLOOKUP(B88&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.05}]
["02-35-025","Bunn","Franklin","Tar River (15-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B89&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":45}]
["04-71-010","Burgaw","Pender","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B90&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":26.25}]
["01-12-065","Burke County","Burke","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B91&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":55}]
["02-01-010","Burlington","Alamance","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B92&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":22.7}]
["01-00-010","Burnsville","Yancey","Nolichucky River (05-1)","Yes","No",null,{"$f":"VLOOKUP(B93&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.200000000000003}]
["01-13-106","Cabarrus Woods","Cabarrus","Yadkin River (18-1)","No","No",null,{"$f":"VLOOKUP(B94&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["10-14-001","Caldwell Co (Addison Lane)","Caldwell","Catawba River (03-1)","Yes","No",null,34.71]
["01-14-048","Caldwell Co (North)","Caldwell","Yadkin River (18-1)","Yes","< 0.100 MGD",null,34.71]
["01-14-047","Caldwell Co (Southeast)","Caldwell","Catawba River (03-1)","Yes","< 0.100 MGD",null,34.71]
["01-14-045","Caldwell Co (West)","Caldwell","Catawba River (03-1)","Yes","No",null,34.71]
["01-14-046","Caldwell County (South)","Caldwell","Catawba River (03-1)","No","No",null,34.71]
["04-31-045","Calypso","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B100&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.5}]
["03-63-040","Cameron","Moore","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B101&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43}]
["04-67-047","Camp Lejeune (Courthouse Bay)","Onslow","New River (02-6)","No","No",null,{"$f":"VLOOKUP(B102&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-67-041","Camp Lejeune (Hadnot Point)","Onslow","New River (02-6)","Yes","No",null,{"$f":"VLOOKUP(B103&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-67-043","Camp Lejeune (Holcomb Blvd)","Onslow","New River (02-6)","Yes","No",null,{"$f":"VLOOKUP(B104&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-67-042","Camp Lejeune (New River Air Station)","Onslow","New River (02-6)","Yes","No",null,{"$f":"VLOOKUP(B105&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-67-048","Camp Lejeune (Onslow Beach)","Onslow","New River (02-6)","No","No",null,{"$f":"VLOOKUP(B106&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-67-046","Camp Lejeune (Rifle Range)","Onslow","New River (02-6)","Yes","No",null,{"$f":"VLOOKUP(B107&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-43-030","Campbell University","Harnett","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B108&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-62-030","Candor","Montgomery","Deep River (02-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B109&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":44.75}]
["04-45-999","Cane Creek Water - Sewer District","Henderson","French Broad River (05-2)","No","No",null,{"$f":"VLOOKUP(B110&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-44-015","Canton","Haywood","Pigeon River (05-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B111&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":22.76}]
["04-65-010","Cape Fear Public Utility Authority - Wilmington","New Hanover","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B112&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.909999999999997}]
["04-65-015","Carolina Beach","New Hanover","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B113&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":34.619999999999997}]
["04-10-121","Carolina Shores SD","Brunswick","Shallotte River (09-4)","No","No",null,{"$f":"VLOOKUP(B114&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-53-101","Carolina Trace WS","Lee","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B115&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-63-025","Carthage","Moore","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B116&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43}]
["03-92-020","Cary","Wake","Neuse River (10-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B117&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.57}]
["04-64-055","Castalia","Nash","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B118&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-10-055","Caswell Beach","Brunswick","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B119&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["40-64-005","Central Nash WSD","Nash","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B120&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-24-055","Cerro Gordo","Columbus","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B121&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24}]
["04-24-020","Chadbourn","Columbus","Waccamaw River (09-3)","Yes","No",null,{"$f":"VLOOKUP(B122&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":42.88}]
["01-60-010","Charlotte Water","Mecklenburg","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B123&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":19.89}]
["03-19-045","Chatham Co (East)","Chatham","Cape Fear River (02-3)","No","< 0.100 MGD",null,50]
["40-19-010","Chatham County Asbury Water System","Chatham","Deep River (02-2)","Yes","No",null,50]
["03-19-126","Chatham County North Water System","Chatham","Haw River (02-1)","Yes","No",null,50]
["03-19-050","Chatham County Southwest Water System","Chatham","Deep River (02-2)","Yes","No",null,50]
["04-25-035","Cherry Point MCAS","Craven","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B128&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-36-030","Cherryville","Gaston","South Fork Catawba River (03-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B129&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43}]
["01-81-107","Chimney Rock Water Works","Rutherford","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B130&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.25}]
["01-80-040","China Grove","Rowan","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B131&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-31-050","Chinquapin Water Association","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B132&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.25}]
["04-07-025","Chocowinity","Beaufort","Pamlico River & Sound (15-3)","Yes","No",null,{"$f":"VLOOKUP(B133&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43.5}]
["04-21-015","Chowan County","Chowan","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B134&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35}]
["02-76-015","City of Randleman","Randolph","Deep River (02-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B135&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38.65}]
["02-34-010","City of Winston-Salem","Forsyth","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B136&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.85}]
["01-18-035","Claremont","Catawba","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B137&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.590000000000003}]
["03-09-020","Clarkton","Bladen","Waccamaw River (09-3)","Yes","No",null,{"$f":"VLOOKUP(B138&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.75}]
["01-22-010","Clay Co WSD","Clay","Hiwassee River (06-1)","Yes","No",null,{"$f":"VLOOKUP(B139&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-51-020","Clayton","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B140&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":45.5}]
["40-51-019","Clayton North","Johnston","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B141&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-80-050","Cleveland","Rowan","South Yadkin River (18-2)","Yes","No",null,{"$f":"VLOOKUP(B142&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.380000000000003}]
["01-23-055","Cleveland County Water","Cleveland","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B143&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.76}]
["03-26-332","Cliffdale West","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B144&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-82-010","Clinton","Sampson","South River (02-4)","Yes","No",null,{"$f":"VLOOKUP(B145&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":22.75}]
["01-44-025","Clyde","Haywood","Pigeon River (05-3)","Yes","No",null,{"$f":"VLOOKUP(B146&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.82}]
["03-43-020","Coats","Harnett","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B147&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.75}]
["04-46-030","Cofield","Hertford","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B148&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-89-010","Columbia","Tyrrell","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B149&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.22}]
["01-75-015","Columbus","Polk","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B150&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.05}]
["04-24-060","Columbus Co WSD I","Columbus","Lumber River (09-1)","Yes","No",null,49.05]
["70-24-007","Columbus Co WSD II","Columbus","Waccamaw River (09-3)","Yes","No",null,49.05]
["70-24-012","Columbus Co WSD III","Columbus","Waccamaw River (09-3)","Yes","No",null,49.05]
["70-24-013","Columbus Co WSD IV","Columbus","Lumber River (09-1)","Yes","No",null,49.05]
["01-13-010","Concord","Cabarrus","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B155&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.39}]
["01-81-050","Concord Community WS","Rutherford","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B156&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-88-104","Connestee Falls","Transylvania","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B157&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-18-020","Conover","Catawba","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B158&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":26.54}]
["04-66-025","Conway","Northampton","Meherrin River (04-2)","Yes","No",null,{"$f":"VLOOKUP(B159&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":20.75}]
["04-25-045","Cove City","Craven","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B160&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":61}]
["02-39-030","Cozart Water SD","Granville","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B161&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-36-040","Cramerton","Gaston","South Fork Catawba River (03-2)","No","< 0.100 MGD",null,{"$f":"VLOOKUP(B162&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-25-055","Craven County","Craven","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B163&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":21}]
["02-39-015","Creedmoor","Granville","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B164&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-94-020","Creswell","Washington","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B165&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":79.099999999999994}]
["01-06-010","Crossnore","Avery","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B166&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24}]
["04-27-010","Currituck Co - Mainland","Currituck","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B167&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-36-065","Dallas","Gaston","South Fork Catawba River (03-2)","Yes","No",null,{"$f":"VLOOKUP(B168&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38.450000000000003}]
["02-79-040","Dan River Water Inc.","Rockingham","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B169&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.55}]
["02-85-020","Danbury","Stokes","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B170&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-28-030","Dare Co Regional","Dare","Albemarle Sound (12-1)","Yes","No",null,34.340000000000003]
["04-28-035","Dare Co Rodanthe-Waves-Salvo","Dare","Albemarle Sound (12-1)","Yes","No",null,34.340000000000003]
["04-28-025","Dare Co. Cape Hatteras","Dare","Albemarle Sound (12-1)","Yes","No",null,34.340000000000003]
["04-28-999","DARE CO. Stumpy Point WSD","Dare","Albemarle Sound (12-1)","No","No",null,{"$f":"VLOOKUP(B174&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-29-025","Davidson Water","Davidson","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B175&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-30-015","Davie Co","Davie","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B176&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-54-030","Deep Run Water Corp","Lenoir","Trent River (10-3)","Yes","No",null,{"$f":"VLOOKUP(B177&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40}]
["02-29-030","Denton","Davidson","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B178&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":58.29}]
["02-86-030","Dobson","Surry","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B179&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43.75}]
["04-64-060","Dortches","Nash","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B180&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-25-025","Dover","Craven","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B181&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.75}]
["01-12-045","Drexel","Burke","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B182&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.9}]
["03-09-025","Dublin","Bladen","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B183&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.380000000000003}]
["03-43-010","Dunn","Harnett","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B184&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.700000000000003}]
["04-31-085","Duplin Co","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B185&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.75}]
["04-31-994","DUPLIN CO","Duplin","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B186&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.75}]
["04-31-090","DUPLIN CO WD D","Duplin","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B187&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-31-075","DUPLIN CO WD E","Duplin","South River (02-4)","No","No",null,{"$f":"VLOOKUP(B188&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-31-998","DUPLIN CO WD F","Duplin","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B189&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-31-065","DUPLIN CO WD G","Duplin","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B190&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-32-010","Durham","Durham","Neuse River (10-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B191&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.84}]
["40-32-018","Durham County (Rougemont)","Durham","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B192&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-09-050","East Arcadia","Bladen","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B193&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24}]
["02-99-025","East Bend","Yadkin","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B194&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":90.64}]
["50-63-011","East Moore Water District","Moore","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B195&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-80-060","East Spencer","Rowan","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B196&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":58.15}]
["04-74-015","Eastern Pines Water Corporation","Pitt","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B197&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":42.5}]
["50-26-027","Eastover Sanitary District","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B198&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":51.8}]
["03-26-999","Eastover SD","Cumberland","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B199&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-79-010","Eden","Rockingham","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B200&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.799999999999997}]
["04-21-010","Edenton","Chowan","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B201&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":50.61}]
["04-33-050","Edgecombe Co WSD","Edgecombe","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B202&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":65.25}]
["04-33-999","EDGECOMBE CO WSD 1","Edgecombe","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B203&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-33-998","EDGECOMBE CO WSD 2","Edgecombe","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B204&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["40-33-002","Edgecombe Co WSD 2","Edgecombe","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B205&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-33-997","Edgecombe Co WSD 3","Edgecombe","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B206&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-33-035","Edgecombe Co WSD 5","Edgecombe","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B207&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-70-010","Elizabeth City","Pasquotank","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B208&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":50.95}]
["03-09-010","Elizabethtown","Bladen","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B209&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":25.28}]
["01-06-025","Elk Park","Avery","Watauga River (16-1)","Yes","No",null,{"$f":"VLOOKUP(B210&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24.5}]
["02-86-020","Elkin","Surry","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B211&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.5}]
["01-81-038","Ellenboro","Rutherford","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B212&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38.75}]
["03-77-020","Ellerbe","Richmond","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B213&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":23.68}]
["04-98-020","Elm City","Wilson","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B214&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.24}]
["02-01-025","Elon","Alamance","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B215&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.64}]
["01-02-015","Energy United Water","Alexander","South Yadkin River (18-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B216&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38}]
["04-42-025","Enfield Water System","Halifax","Fishing Creek (15-2)","Yes","No",null,{"$f":"VLOOKUP(B217&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":58}]
["03-43-035","Erwin","Harnett","Cape Fear River (02-3)","No","< 0.100 MGD",null,{"$f":"VLOOKUP(B218&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-59-114","Everetts","Martin","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B219&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":84}]
["04-24-030","Fair Bluff","Columbus","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B220&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":22.5}]
["04-25-132","Fairfield Harbour","Craven","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B221&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-50-113","Fairfield Sapphire","Jackson","Savannah River (08-1)","Yes","No",null,{"$f":"VLOOKUP(B222&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-78-025","Fairmont","Robeson","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B223&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":66.56}]
["04-31-040","Faison","Duplin","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B224&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.5}]
["01-80-055","Faith","Rowan","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B225&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-26-035","Falcon","Cumberland","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B226&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.14}]
["01-23-035","Fallston Water System","Cleveland","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B227&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":29.4}]
["04-74-020","Farmville","Pitt","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B228&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":56.49}]
["03-26-010","Fayetteville","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B229&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.75}]
["04-65-119","FIGURE EIGHT ISLAND","New Hanover","New River (02-6)","No","No",null,{"$f":"VLOOKUP(B230&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-25-040","First Craven Sanitary District","Craven","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B231&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36}]
["03-51-195","Flowers Plantation","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B232&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-38-101","Fontana Dam","Graham","Little Tennessee River (07-1)","Yes","No",null,{"$f":"VLOOKUP(B233&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":20}]
["01-81-010","Forest City","Rutherford","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B234&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":22.37}]
["04-96-060","Fork Township SD","Wayne","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B235&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.4}]
["60-96-002","Fork Township SD Purchase System","Wayne","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B236&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-26-344","Fort Bragg","Cumberland","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B237&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-74-050","Fountain","Pitt","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B238&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":54.48}]
["03-51-035","Four Oaks","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B239&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.67}]
["03-63-479","Foxfire Village","Moore","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B240&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.76}]
["01-57-010","Franklin","Macon","Little Tennessee River (07-1)","Yes","No",null,{"$f":"VLOOKUP(B241&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":34.950000000000003}]
["02-35-030","Franklin County Public Utilities","Franklin","Tar River (15-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B242&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":65.11}]
["02-35-010","Franklinton","Franklin","Tar River (15-1)","No","< 0.100 MGD",null,{"$f":"VLOOKUP(B243&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-76-035","Franklinville","Randolph","Deep River (02-2)","Yes","No",null,{"$f":"VLOOKUP(B244&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":57.5}]
["04-96-025","Fremont","Wayne","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B245&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.77}]
["03-92-055","Fuquay-Varina","Wake","Neuse River (10-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B246&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.64}]
["03-82-020","Garland","Sampson","South River (02-4)","Yes","No",null,{"$f":"VLOOKUP(B247&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.5}]
["03-92-025","GARNER","Wake","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B248&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-36-999","GASTON COUNTY WATER and SD","Gaston","Catawba River (03-1)","No","No",null,{"$f":"VLOOKUP(B249&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-37-020","Gates Co","Gates","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B250&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":25.5}]
["04-37-010","Gatesville","Gates","Chowan River (04-1)","No","No",null,{"$f":"VLOOKUP(B251&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["30-86-058","Gentry Road","Surry","Yadkin River (18-1)","No","No",null,{"$f":"VLOOKUP(B252&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-83-015","Gibson (Scotland Co - South WSD)","Scotland","Big Shoe Heel Creek (09-2)","Yes","No",null,{"$f":"VLOOKUP(B253&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.63}]
["02-41-025","Gibsonville","Guilford","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B254&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24.8}]
["03-26-050","Godwin","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B255&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":53}]
["04-96-010","Goldsboro","Wayne","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B256&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.31}]
["03-19-025","Goldston Gulf SD","Chatham","Deep River (02-2)","Yes","No",null,{"$f":"VLOOKUP(B257&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":55}]
["02-01-015","Graham","Alamance","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B258&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":23.33}]
["01-14-030","Granite Falls","Caldwell","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B259&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.64}]
["02-01-030","Green Level","Alamance","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B260&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41.67}]
["04-40-106","Greene County RWS","Greene","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B261&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.49}]
["04-31-060","Greenevers","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B262&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.85}]
["02-41-010","Greensboro","Guilford","Haw River (02-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B263&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":23}]
["04-74-010","Greenville Utilities Commission","Pitt","Tar River (15-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B264&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.840000000000003}]
["04-74-035","Grifton","Pitt","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B265&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":42.9}]
["04-74-055","Grimesland","Pitt","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B266&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":42.15}]
["01-23-030","Grover","Cleveland","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B267&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":34.08}]
["02-41-583","Guilford County Prison Farm","Guilford","Haw River (02-1)","No","No",null,{"$f":"VLOOKUP(B268&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-42-030","Halifax","Halifax","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B269&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":63.5}]
["04-42-040","Halifax County","Halifax","Roanoke River (14-1)","Yes","0.100 - 1.0 MGD",null,{"$f":"VLOOKUP(B270&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":47.25}]
["04-59-025","Hamilton","Martin","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B271&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":55.15}]
["03-77-010","Hamlet Water System","Richmond","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B272&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.5}]
["02-29-035","Handy Sanitary District","Davidson","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B273&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41}]
["04-16-025","Harkers Island WSD","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B274&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.25}]
["03-43-045","Harnett  Regional Water System","Harnett","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B275&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.5}]
["03-82-030","Harrells WC","Sampson","South River (02-4)","No","No",null,{"$f":"VLOOKUP(B276&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-46-040","Harrellsville","Hertford","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B277&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35}]
["01-13-025","Harrisburg","Cabarrus","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B278&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.89}]
["04-25-015","Havelock","Craven","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B279&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.96}]
["02-01-020","Haw River","Alamance","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B280&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.270000000000003}]
["01-44-999","Haywood Co","Haywood","Pigeon River (05-3)","No","No",null,{"$f":"VLOOKUP(B281&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-45-010","Hendersonville","Henderson","French Broad River (05-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B282&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.72}]
["04-72-010","Hertford","Perquimans","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B283&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":67.459999999999994}]
["04-46-045","Hertford County Rural Water","Hertford","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B284&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37}]
["01-22-126","Hiawassee - North Carolina System","Clay","Hiwassee River (06-1)","No","No",null,{"$f":"VLOOKUP(B285&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-18-010","Hickory","Catawba","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B286&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.11}]
["01-18-040","Hickory Catawba System","Catawba","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B287&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-41-020","High Point","Guilford","Deep River (02-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B288&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.020000000000003}]
["01-36-075","High Shoals","Gaston","South Fork Catawba River (03-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B289&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":42}]
["01-57-015","Highlands","Macon","Little Tennessee River (07-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B290&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36}]
["03-68-015","Hillsborough","Orange","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B291&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":50.6}]
["04-42-035","Hobgood","Halifax","Fishing Creek (15-2)","Yes","No",null,{"$f":"VLOOKUP(B292&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41}]
["03-47-025","Hoke County Regional Water System","Hoke","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B293&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":29}]
["03-47-030","Hoke County Rockfish Water System","Hoke","Lumber River (09-1)","No","No",null,{"$f":"VLOOKUP(B294&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-10-060","Holden Beach","Brunswick","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B295&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.1}]
["03-92-050","Holly Springs","Wake","Neuse River (10-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B296&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.92}]
["04-40-020","Hookerton","Greene","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B297&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-26-025","HOPE MILLS","Cumberland","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B298&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-58-020","Hot Springs","Madison","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B299&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":21.25}]
["01-14-020","HUDSON","Caldwell","Catawba River (03-1)","No","No",null,{"$f":"VLOOKUP(B300&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-48-010","Hyde County","Hyde","Pamlico River & Sound (15-3)","Yes","No",null,{"$f":"VLOOKUP(B301&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":58}]
["01-12-060","Icard Township WC","Burke","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B302&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":34.36}]
["01-49-025","Iredell Water Corporation","Iredell","South Yadkin River (18-2)","Yes","No",null,{"$f":"VLOOKUP(B303&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.5}]
["04-66-010","Jackson","Northampton","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B304&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.5}]
["04-67-010","Jacksonville","Onslow","New River (02-6)","Yes","No",null,{"$f":"VLOOKUP(B305&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.34}]
["02-41-030","Jamestown","Guilford","Deep River (02-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B306&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":21.72}]
["04-59-030","Jamesville","Martin","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B307&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.48}]
["04-40-022","Jason-Shine Water Corporation","Greene","Contentnea Creek (10-2)","No","No",null,{"$f":"VLOOKUP(B308&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-05-015","Jefferson","Ashe","New River (11-1)","Yes","No",null,{"$f":"VLOOKUP(B309&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.81}]
["03-51-065","JOHNSTON CO","Johnston","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B310&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-51-070","Johnston County","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B311&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43}]
["04-52-020","Jones County Regional Water System","Jones","Trent River (10-3)","Yes","No",null,{"$f":"VLOOKUP(B312&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38.35}]
["02-99-010","Jonesville","Yadkin","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B313&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":53.45}]
["01-44-035","Junaluska SD","Haywood","Pigeon River (05-3)","Yes","No",null,{"$f":"VLOOKUP(B314&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":50.6}]
["01-80-065","Kannapolis","Rowan","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B315&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.950000000000003}]
["04-08-025","Kelford","Bertie","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B316&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-31-030","Kenansville","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B317&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.049999999999997}]
["03-51-030","Kenly","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B318&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38.6}]
["02-91-010","Kerr Lake Regional Water","Vance","Roanoke River (14-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B319&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-91-999","Kerr Lake RWS","Vance","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B320&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-28-015","Kill Devil Hills","Dare","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B321&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.5}]
["02-85-010","King","Stokes","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B322&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24.53}]
["04-65-129","Kings Grant","New Hanover","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B323&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-23-020","Kings Mountain","Cleveland","Broad River (01-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B324&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":21.37}]
["04-54-010","Kinston","Lenoir","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B325&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41.86}]
["02-91-015","Kittrell WA","Vance","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B326&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-92-066","Knightdale","Wake","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B327&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-65-025","Kure Beach","New Hanover","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B328&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":29.84}]
["04-54-015","La Grange","Lenoir","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B329&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.85}]
["01-44-107","Lake Junaluska Assembly","Haywood","Pigeon River (05-3)","No","No",null,{"$f":"VLOOKUP(B330&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-81-020","Lake Lure","Rutherford","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B331&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":64}]
["02-35-108","Lake Royale","Franklin","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B332&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-38-105","Lake Santeetlah","Graham","Little Tennessee River (07-1)","Yes","No",null,{"$f":"VLOOKUP(B333&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":64.17}]
["04-24-045","Lake Waccamaw","Columbus","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B334&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.5}]
["01-60-156","Lamplighter South/Danby","Mecklenburg","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B335&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-80-038","Landis","Rowan","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B336&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":56.75}]
["01-05-020","Lansing","Ashe","New River (11-1)","Yes","No",null,{"$f":"VLOOKUP(B337&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":25.55}]
["01-45-030","Laurel Park","Henderson","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B338&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-83-010","Laurinburg","Scotland","Big Shoe Heel Creek (09-2)","Yes","No",null,{"$f":"VLOOKUP(B339&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":20.02}]
["03-83-107","Laurinburg-Maxton Airport","Scotland","Lumber River (09-1)","No","No",null,{"$f":"VLOOKUP(B340&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-23-045","Lawndale","Cleveland","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B341&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":53.1}]
["50-09-013","LCFWSA - Kings Bluff","Bladen","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B342&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-53-130","Lee Co Cumnock Golden Poultry","Lee","Deep River (02-2)","No","No",null,{"$f":"VLOOKUP(B343&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-53-111","Lee Co WSD 1","Lee","Cape Fear River (02-3)","No","< 0.100 MGD",null,{"$f":"VLOOKUP(B344&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-92-291","Leesville Master","Wake","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B345&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["70-10-058","Leland","Brunswick","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B346&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-14-010","Lenoir","Caldwell","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B347&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":25.57}]
["04-08-020","Lewiston-Woodville","Bertie","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B348&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-29-010","Lexington","Davidson","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B349&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.19}]
["02-76-025","Liberty","Randolph","Deep River (02-2)","Yes","No",null,{"$f":"VLOOKUP(B350&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":23.44}]
["03-04-025","Lilesville","Anson","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B351&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.64}]
["03-43-025","Lillington","Harnett","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B352&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.76}]
["01-55-035","Lincoln County","Lincoln","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B353&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.14}]
["01-55-010","Lincolnton","Lincoln","South Fork Catawba River (03-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B354&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":29.99}]
["03-26-045","Linden","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B355&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":48.5}]
["01-06-104","Linville Land Harbor","Avery","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B356&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-42-028","Littleton","Halifax","Fishing Creek (15-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B357&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":92}]
["04-10-015","LONG BEACH WATER","Brunswick","Shallotte River (09-4)","No","No",null,{"$f":"VLOOKUP(B358&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-18-025","Longview","Catawba","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B359&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.47}]
["02-35-015","Louisburg","Franklin","Tar River (15-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B360&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.01}]
["01-49-035","Love Valley","Iredell","South Yadkin River (18-2)","No","No",null,{"$f":"VLOOKUP(B361&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-36-060","Lowell","Gaston","South Fork Catawba River (03-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B362&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43.03}]
["04-65-999","Lower Cape Fear WSA","New Hanover","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B363&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-98-030","Lucama","Wilson","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B364&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":59.5}]
["03-78-010","Lumberton","Robeson","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B365&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24.38}]
["02-39-020","Lyon Station SD","Granville","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B366&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-33-020","Macclesfield","Edgecombe","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B367&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":62.21}]
["02-79-030","Madison","Rockingham","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B368&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.270000000000003}]
["01-44-040","Maggie Valley SD","Haywood","Pigeon River (05-3)","Yes","No",null,44]
["04-31-035","Magnolia","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B370&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.96}]
["01-18-030","Maiden","Catawba","South Fork Catawba River (03-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B371&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":23.66}]
["04-28-020","Manteo","Dare","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B372&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.49}]
["01-20-025","Marble CWS","Cherokee","Hiwassee River (06-1)","No","No",null,{"$f":"VLOOKUP(B373&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-56-010","Marion","McDowell","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B374&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.74}]
["01-58-010","Mars Hill","Madison","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B375&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.06}]
["01-58-015","Marshall","Madison","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B376&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":47.16}]
["01-90-015","Marshville","Union","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B377&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.75}]
["04-59-999","MARTIN CO WSD 1","Martin","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B378&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-59-998","Martin Co WSD 2","Martin","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B379&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-59-997","Martin Co WSD 3","Martin","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B380&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["60-59-015","Martin County Regional WASA","Martin","Roanoke River (14-1)","Yes","No",null,74]
["60-59-018","Martin County Regional WASA Well","Martin","Roanoke River (14-1)","Yes","No",null,74]
["60-59-003","Martin County WD I","Martin","Roanoke River (14-1)","Yes","No",null,74]
["60-59-009","Martin County WD II","Martin","Roanoke River (14-1)","Yes","No",null,74]
["04-40-015","Maury Sanitary Land District","Greene","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B385&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":55}]
["03-78-035","Maxton","Robeson","Big Shoe Heel Creek (09-2)","Yes","No",null,{"$f":"VLOOKUP(B386&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":21.8}]
["00-00-008","Mayberry WSD2","Orange","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B387&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-79-025","Mayodan","Rockingham","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B388&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":45.57}]
["04-52-010","Maysville","Jones","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B389&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":49.56}]
["01-36-045","McAdenville","Gaston","South Fork Catawba River (03-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B390&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["10-56-032","McDowell County","McDowell","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B391&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.1}]
["03-04-036","McFarlan","Anson","Yadkin River (18-1)","No","No",null,{"$f":"VLOOKUP(B392&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-01-018","Mebane","Alamance","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B393&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.65}]
["04-16-198","Merrimon","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B394&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-51-045","Micro","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B395&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["40-51-008","Micro (County Line)","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B396&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.619999999999997}]
["04-64-050","Middlesex","Nash","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B397&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33}]
["01-95-115","Mill Ridge POA","Watauga","Watauga River (16-1)","No","No",null,{"$f":"VLOOKUP(B398&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-17-015","Milton","Caswell","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B399&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":86.5}]
["00-00-001","Milton 2015","Caswell","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B400&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-30-010","Mocksville","Davie","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B401&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.299999999999997}]
["01-90-010","Monroe","Union","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B402&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.07}]
["04-65-137","Monterey Heights Water Supply","New Hanover","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B403&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-62-010","Montgomery Co","Montgomery","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B404&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41}]
["01-11-484","Montreat","Buncombe","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B405&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.1}]
["03-63-153","Moore County Public Utilities-Addor","Moore","Lumber River (09-1)","Yes","< 0.100 MGD",null,31.46]
["50-63-021","Moore County Public Utilities-High Falls","Moore","Deep River (02-2)","Yes","No",null,31.46]
["03-63-103","Moore County Public Utilities-Hyland Hills","Moore","Cape Fear River (02-3)","Yes","No",null,31.46]
["03-63-108","Moore County Public Utilities-Pinehurst","Moore","Lumber River (09-1)","Yes","< 0.100 MGD",null,31.46]
["03-63-155","Moore County Public Utilities-Robbins","Moore","Deep River (02-2)","Yes","< 0.100 MGD",null,31.46]
["03-63-117","Moore County Public Utilities-Seven Lakes","Moore","Deep River (02-2)","Yes","< 0.100 MGD",null,31.46]
["03-63-152","Moore County Public Utilities-The Carolina","Moore","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,31.46]
["03-63-045","Moore County Public Utilities-Vass","Moore","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,31.46]
["01-49-015","Mooresville","Iredell","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B414&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.81}]
["01-97-040","Moravian Falls Water Works","Wilkes","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B415&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.5}]
["04-16-015","Morehead City","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B416&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":44.54}]
["01-12-015","Morganton","Burke","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B417&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":15.5}]
["03-92-075","Morrisville","Wake","Neuse River (10-1)","No","< 0.100 MGD",null,{"$f":"VLOOKUP(B418&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-04-040","Morven","Anson","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B419&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38.67}]
["02-86-010","Mount Airy","Surry","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B420&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":25.53}]
["03-62-015","Mount Gilead","Montgomery","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B421&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.299999999999997}]
["01-36-020","Mount Holly","Gaston","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B422&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":25.56}]
["04-96-015","Mount Olive","Wayne","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B423&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24.66}]
["01-13-020","Mt. Pleasant","Cabarrus","Rocky River (18-4)","Yes","No",null,{"$f":"VLOOKUP(B424&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.42}]
["01-97-015","Mulberry Fairplains WA","Wilkes","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B425&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.67}]
["04-46-015","Murfreesboro","Hertford","Meherrin River (04-2)","Yes","No",null,{"$f":"VLOOKUP(B426&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35}]
["01-20-010","Murphy","Cherokee","Hiwassee River (06-1)","Yes","No",null,{"$f":"VLOOKUP(B427&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.700000000000003}]
["04-28-010","Nags Head","Dare","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B428&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":42.05}]
["04-64-999","NASH CO","Nash","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B429&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["40-64-010","Nash County Area II","Nash","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B430&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":65}]
["40-64-025","Nash County Area III","Nash","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B431&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-64-020","Nashville","Nash","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B432&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37}]
["04-10-065","Navassa","Brunswick","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B433&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["60-54-001","Neuse Regional Water and Sewer Authority","Lenoir","Neuse River (10-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B434&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-25-010","New Bern","Craven","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B435&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.770000000000003}]
["04-65-191","New Hanover Co (421)","New Hanover","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B436&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-65-232","New Hanover County","New Hanover","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B437&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-06-020","Newland","Avery","Nolichucky River (05-1)","Yes","No",null,{"$f":"VLOOKUP(B438&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.1}]
["04-16-020","Newport","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B439&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.19}]
["01-18-015","Newton","Catawba","South Fork Catawba River (03-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B440&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":68.040000000000006}]
["03-82-035","Newton Grove","Sampson","South River (02-4)","Yes","No",null,{"$f":"VLOOKUP(B441&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.25}]
["04-65-510","NHC Airport Water Supply","New Hanover","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B442&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-93-020","Norlina","Warren","Roanoke River (14-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B443&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.75}]
["04-54-025","North Lenoir Water Corp.","Lenoir","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B444&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":63}]
["04-16-197","North River/ Mill Creek Water System","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B445&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-97-010","North Wilkesboro","Wilkes","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B446&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.74}]
["04-66-113","Northampton Co - Gaston","Northampton","Roanoke River (14-1)","Yes","< 0.100 MGD",null,64.5]
["04-66-060","Northampton Co - Jackson","Northampton","Meherrin River (04-2)","No","No",null,{"$f":"VLOOKUP(B448&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-66-110","Northampton Co - Lake Gaston","Northampton","Roanoke River (14-1)","Yes","No",null,64.5]
["04-66-108","Northampton Co - Milwaukee","Northampton","Meherrin River (04-2)","Yes","No",null,64.5]
["40-66-001","Northampton Co - North Gaston","Northampton","Chowan River (04-1)","Yes","No",null,64.5]
["04-66-111","Northampton Co - North Woodland","Northampton","Meherrin River (04-2)","No","No",null,{"$f":"VLOOKUP(B452&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-66-112","Northampton Co - Pendleton","Northampton","Meherrin River (04-2)","No","No",null,{"$f":"VLOOKUP(B453&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-66-045","Northampton Co - Progressive","Northampton","Roanoke River (14-1)","Yes","No",null,64.5]
["04-66-055","Northampton Co - Rich Square","Northampton","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B455&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["40-66-002","Northampton Co - West Jackson","Northampton","Roanoke River (14-1)","Yes","No",null,64.5]
["40-64-035","Northern Nash County","Nash","Tar River (15-1)","Yes","No",null,65]
["70-10-045","Northwest","Brunswick","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B458&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-47-015","Northwest Water Supply Inc.","Hoke","Lumber River (09-1)","No","No",null,{"$f":"VLOOKUP(B459&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-84-015","Norwood","Stanly","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B460&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":50.8}]
["04-67-030","NW Onslow Water","Onslow","New River (02-6)","No","No",null,{"$f":"VLOOKUP(B461&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-59-020","OAK CITY","Martin","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B462&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-10-020","Oak Island","Brunswick","Shallotte River (09-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B463&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.380000000000003}]
["01-84-020","Oakboro","Stanly","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B464&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.380000000000003}]
["04-10-035","Ocean Isle Beach","Brunswick","Shallotte River (09-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B465&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.85}]
["04-48-020","Ocracoke Sanitary District","Hyde","Pamlico River & Sound (15-3)","Yes","No",null,53.54]
["01-56-025","Old Fort","McDowell","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B467&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.7}]
["50-26-019","Old North Utility Services, Inc.","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B468&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-67-035","ONWASA","Onslow","New River (02-6)","Yes","No",null,{"$f":"VLOOKUP(B469&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.32}]
["03-68-010","Orange Water and Sewer Authority","Orange","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B470&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":51.02}]
["03-68-020","Orange-Alamance","Orange","Haw River (02-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B471&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.4}]
["04-69-020","Oriental","Pamlico","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B472&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.950000000000003}]
["02-01-123","Ossipee SD","Alamance","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B473&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":58.15}]
["02-39-010","Oxford","Granville","Tar River (15-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B474&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":42.91}]
["04-69-025","Pamlico County Water System","Pamlico","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B475&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41.75}]
["03-78-045","Parkton","Robeson","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B476&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":44.6}]
["04-59-113","Parmele","Martin","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B477&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38}]
["04-70-015","Pasquotank County","Pasquotank","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B478&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["60-70-000","Pasquotank County - RO","Pasquotank","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B479&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-04-034","Peachland","Anson","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B480&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.7}]
["03-78-020","Pembroke","Robeson","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B481&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":21.47}]
["70-71-011","Pender County Utilities","Pender","Northeast Cape Fear River (02-5)","Yes","No",null,60]
["04-72-025","Perquimans County","Perquimans","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B483&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":53.5}]
["01-84-025","Pfeiffer-North Stanly WA","Stanly","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B484&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.53}]
["30-76-010","Piedmont Triad Regional Water Authority","Guilford","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B485&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-96-030","Pikeville","Wayne","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B486&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":68.599999999999994}]
["02-86-025","Pilot Mountain","Surry","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B487&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.68}]
["04-16-031","Pine Knoll Shores","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B488&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.299999999999997}]
["03-51-040","Pine Level","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B489&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.96}]
["01-13-181","Pine Ridge MHP","Cabarrus","Rocky River (18-4)","No","No",null,{"$f":"VLOOKUP(B490&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-13-190","Pine Ridge MHP II","Cabarrus","Yadkin River (18-1)","No","No",null,{"$f":"VLOOKUP(B491&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-63-030","Pinebluff","Moore","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B492&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.799999999999997}]
["04-33-015","Pinetops","Edgecombe","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B493&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.71}]
["04-54-020","Pink Hill","Lenoir","Trent River (10-3)","Yes","No",null,{"$f":"VLOOKUP(B494&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":51.5}]
["03-19-015","Pittsboro","Chatham","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B495&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":69.87}]
["04-94-010","Plymouth","Washington","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B496&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":63}]
["10-75-004","Polk County Water Department","Polk","Broad River (01-1)","No","No",null,{"$f":"VLOOKUP(B497&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["10-75-010","Polk County Water System","Polk","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B498&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["20-84-008","Polk Ford/Renee Ford","Stanly","Rocky River (18-4)","Yes","No",null,{"$f":"VLOOKUP(B499&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":57.2}]
["03-04-030","Polkton","Anson","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B500&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":48.79}]
["04-52-015","Pollocksville","Jones","Trent River (10-3)","Yes","No",null,{"$f":"VLOOKUP(B501&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":56.75}]
["04-08-040","Powellsville","Bertie","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B502&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40}]
["04-65-188","PRINCE GEORGE","New Hanover","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B503&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-51-050","Princeton","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B504&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":54.61}]
["04-33-045","Princeville","Edgecombe","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B505&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-47-010","Raeford","Hoke","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B506&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":25.04}]
["03-92-010","Raleigh","Wake","Neuse River (10-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B507&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.57}]
["02-76-020","Ramseur","Randolph","Deep River (02-2)","Yes","No",null,{"$f":"VLOOKUP(B508&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.299999999999997}]
["01-36-034","Ranlo","Gaston","South Fork Catawba River (03-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B509&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":47.95}]
["03-78-015","Red Springs","Robeson","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B510&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30}]
["02-79-020","Reidsville","Rockingham","Haw River (02-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B511&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":19.399999999999999}]
["01-14-035","Rhodhiss","Caldwell","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B512&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":50.66}]
["04-66-020","Rich Square","Northampton","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B513&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.8}]
["04-67-015","Richlands","Onslow","New River (02-6)","No","No",null,{"$f":"VLOOKUP(B514&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-77-109","Richmond County","Richmond","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B515&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-24-035","Riegelwood SD","Columbus","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B516&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-25-113","River Bend","Craven","Trent River (10-3)","Yes","No",null,{"$f":"VLOOKUP(B517&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.619999999999997}]
["04-42-010","Roanoke Rapids SD","Halifax","Roanoke River (14-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B518&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":22.65}]
["03-63-015","Robbins Water System","Moore","Deep River (02-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B519&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":51.89}]
["01-38-010","Robbinsville","Graham","Little Tennessee River (07-1)","Yes","No",null,{"$f":"VLOOKUP(B520&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":51.38}]
["04-59-015","Robersonville","Martin","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B521&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.5}]
["03-78-055","Robeson Co","Robeson","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B522&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.5}]
["03-77-015","Rockingham","Richmond","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B523&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":16.5}]
["02-79-050","Rockingham Co","Rockingham","Haw River (02-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B524&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":70}]
["04-64-010","Rocky Mount","Nash","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B525&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":21.57}]
["04-71-999","ROCKY POINT-TOPSAIL WSD","Pender","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B526&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-92-070","ROLESVILLE","Wake","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B527&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-97-050","Ronda","Wilkes","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B528&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38.58}]
["04-94-015","Roper","Washington","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B529&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":61}]
["04-31-025","Rose Hill","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B530&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.380000000000003}]
["03-82-015","Roseboro","Sampson","South River (02-4)","Yes","No",null,{"$f":"VLOOKUP(B531&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.1}]
["01-88-115","Rosman","Transylvania","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B532&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.29}]
["01-80-753","Rowan Co","Rowan","Yadkin River (18-1)","No","< 0.100 MGD",null,{"$f":"VLOOKUP(B533&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-78-040","Rowland","Robeson","Big Shoe Heel Creek (09-2)","Yes","No",null,{"$f":"VLOOKUP(B534&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.950000000000003}]
["02-73-010","Roxboro","Person","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B535&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.42}]
["04-08-050","Roxobel","Bertie","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B536&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-65-190","RUNNYMEADE","New Hanover","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B537&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-12-055","Rutherford College","Burke","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B538&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":29.9}]
["03-82-025","Salemburg","Sampson","South River (02-4)","Yes","No",null,{"$f":"VLOOKUP(B539&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.75}]
["01-80-010","Salisbury","Rowan","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B540&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.79}]
["01-75-020","Saluda","Polk","Broad River (01-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B541&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":66.25}]
["03-82-999","Sampson Co WSD 1","Sampson","South River (02-4)","No","No",null,{"$f":"VLOOKUP(B542&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-82-050","Sampson County WD I - Clinton","Sampson","South River (02-4)","Yes","No",null,43.65]
["03-82-055","Sampson County WD I - Roseboro","Sampson","South River (02-4)","No","No",null,{"$f":"VLOOKUP(B544&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-82-060","Sampson County WD I - Turkey","Sampson","South River (02-4)","No","No",null,{"$f":"VLOOKUP(B545&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-82-070","Sampson County WD II - Dunn","Sampson","South River (02-4)","Yes","No",null,43.65]
["50-82-022","Sampson County WD II - Plainview","Sampson","South River (02-4)","Yes","< 0.100 MGD",null,43.65]
["03-82-998","Sampson County WSD 2","Sampson","South River (02-4)","No","No",null,{"$f":"VLOOKUP(B548&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["70-10-057","Sandy Creek","Brunswick","Cape Fear River (02-3)","No","No",null,{"$f":"VLOOKUP(B549&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["70-24-024","Sandyfield","Columbus","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B550&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":25}]
["03-53-010","Sanford","Lee","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B551&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.729999999999997}]
["04-98-040","Saratoga","Wilson","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B552&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":59.6}]
["01-14-040","Sawmills","Caldwell","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B553&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41.57}]
["03-83-030","Scotland Co (North)","Scotland","Lumber River (09-1)","No","No",null,{"$f":"VLOOKUP(B554&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-83-035","Scotland Co (South)","Scotland","Lumber River (09-1)","No","No",null,{"$f":"VLOOKUP(B555&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["50-83-003","Scotland County Water (Barnes Bridge)","Scotland","Lumber River (09-1)","Yes","No",null,42.09]
["50-83-005","Scotland County Water (Gillis Hill)","Scotland","Lumber River (09-1)","Yes","No",null,42.09]
["50-83-004","Scotland County Water (Malloy Rd)","Scotland","Lumber River (09-1)","Yes","No",null,42.09]
["50-83-030","Scotland County Water (North)","Scotland","Lumber River (09-1)","Yes","No",null,42.09]
["50-83-035","Scotland County Water (South)","Scotland","Lumber River (09-1)","Yes","No",null,42.09]
["04-42-015","Scotland Neck","Halifax","Roanoke River (14-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B561&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":64.849999999999994}]
["04-66-035","Seaboard","Northampton","Meherrin River (04-2)","Yes","No",null,{"$f":"VLOOKUP(B562&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":48.5}]
["02-76-040","Seagrove-Ulah Metro Water District","Randolph","Deep River (02-2)","Yes","No",null,{"$f":"VLOOKUP(B563&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-51-015","Selma","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B564&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.2}]
["40-51-009","Selma - County Line","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B565&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-95-118","Seven Devils","Watauga","Watauga River (16-1)","Yes","No",null,{"$f":"VLOOKUP(B566&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":50}]
["04-66-015","Severn","Northampton","Meherrin River (04-2)","Yes","No",null,{"$f":"VLOOKUP(B567&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30}]
["04-96-055","Seymour Johnson AFB","Wayne","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B568&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-10-025","Shallotte","Brunswick","Shallotte River (09-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B569&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":16.02}]
["01-18-151","Shamrock Park Subdivision - City of Claremont","Catawba","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B570&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-64-040","Sharpsburg","Nash","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B571&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.25}]
["01-23-010","Shelby","Cleveland","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B572&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.6}]
["20-13-022","Shiloh Church Road S/D","Cabarrus","Rocky River (18-4)","No","No",null,{"$f":"VLOOKUP(B573&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-19-010","Siler City","Chatham","Deep River (02-2)","Yes","No",null,{"$f":"VLOOKUP(B574&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41}]
["04-98-045","Sims","Wilson","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B575&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":38}]
["03-51-010","Smithfield","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B576&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.11}]
["40-51-007","Smithfield South","Johnston","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B577&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-40-010","Snow Hill","Greene","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B578&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":48}]
["03-09-045","SOUTH BLADEN WA","Bladen","Waccamaw River (09-3)","No","No",null,{"$f":"VLOOKUP(B579&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-15-015","South Camden Water and Sewer District","Camden","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B580&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41.5}]
["02-39-107","South Granville Water and Sewer Authority","Granville","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B581&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":53.35}]
["04-40-105","South Greene WC","Greene","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B582&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.49}]
["04-15-010","South Mills","Camden","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B583&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":97.13}]
["60-15-004","South Mills Purchase","Camden","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B584&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["20-18-004","Southeastern Catawba Co WD","Catawba","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B585&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["60-27-001","Southern Outer Banks Water","Currituck","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B586&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-63-010","Southern Pines","Moore","Lumber River (09-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B587&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":32.15}]
["04-96-045","Southern Wayne SD","Wayne","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B588&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.5}]
["04-10-010","Southport","Brunswick","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B589&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.85}]
["01-03-010","Sparta","Alleghany","New River (11-1)","Yes","No",null,{"$f":"VLOOKUP(B590&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.450000000000003}]
["04-33-025","Speed Community WA","Edgecombe","Fishing Creek (15-2)","No","No",null,{"$f":"VLOOKUP(B591&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-80-030","SPENCER","Rowan","Yadkin River (18-1)","No","No",null,{"$f":"VLOOKUP(B592&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-64-025","Spring Hope","Nash","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B593&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":59.43}]
["03-26-020","Spring Lake","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B594&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.26}]
["01-61-010","Spruce Pine","Mitchell","Nolichucky River (05-1)","Yes","No",null,{"$f":"VLOOKUP(B595&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":26}]
["03-78-030","St Pauls","Robeson","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B596&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.5}]
["01-36-035","Stanley","Gaston","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B597&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":34.1}]
["01-84-035","Stanly Co","Stanly","Rocky River (18-4)","Yes","< 0.100 MGD",null,68]
["04-98-025","Stantonsburg","Wilson","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B599&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":42.75}]
["03-62-025","Star","Montgomery","Yadkin River (18-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B600&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.08}]
["01-49-010","Statesville","Iredell","Catawba River (03-1)","Yes","> 1.0 MGD",null,{"$f":"VLOOKUP(B601&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":29.81}]
["03-26-030","Stedman","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B602&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":34.5}]
["02-39-999","Stem","Granville","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B603&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["40-39-003","Stem","Granville","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B604&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-85-025","Stokes County WASA","Stokes","Roanoke River (14-1)","Yes","No",null,56.25]
["04-74-060","Stokes Regional Water Corporation","Pitt","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B606&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":52.5}]
["02-41-035","Stokesdale","Guilford","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B607&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":59}]
["02-79-035","Stoneville","Rockingham","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B608&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":50.38}]
["02-39-018","Stovall","Granville","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B609&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":67.8}]
["60-28-002","Stumpy Point WSD","Dare","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B610&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-06-107","Sugar Mountain","Avery","Watauga River (16-1)","Yes","No",null,{"$f":"VLOOKUP(B611&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-02-130","SUGARLOAF WD","Alexander","South Yadkin River (18-2)","No","No",null,{"$f":"VLOOKUP(B612&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-10-050","Sunset Beach","Brunswick","Shallotte River (09-4)","No","< 0.100 MGD",null,{"$f":"VLOOKUP(B613&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-71-015","Surf City","Pender","New River (02-6)","Yes","No",null,{"$f":"VLOOKUP(B614&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40.94}]
["04-67-020","Swansboro","Onslow","White Oak River (17-1)","No","No",null,{"$f":"VLOOKUP(B615&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["30-01-005","Swepsonville","Alamance","Haw River (02-1)","Yes","No",null,{"$f":"VLOOKUP(B616&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":51.5}]
["04-24-015","Tabor City","Columbus","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B617&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-33-010","Tarboro","Edgecombe","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B618&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":19.829999999999998}]
["01-02-010","Taylorsville","Alexander","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B619&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.5}]
["03-63-035","Taylortown","Moore","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B620&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41.6}]
["04-31-044","Teachey","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B621&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":54.5}]
["04-65-199","The Cape Master","New Hanover","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B622&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-49-185","The Harbour / The Point","Iredell","Catawba River (03-1)","Yes","No",null,{"$f":"VLOOKUP(B623&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-29-020","Thomasville","Davidson","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B624&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":36.909999999999997}]
["30-86-057","Tobe Hudson / IWSD","Surry","Yadkin River (18-1)","No","No",null,{"$f":"VLOOKUP(B625&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-71-020","Topsail Beach","Pender","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B626&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":62.5}]
["01-12-040","Triple Community WC","Burke","Catawba River (03-1)","No","No",null,{"$f":"VLOOKUP(B627&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-49-030","Troutman","Iredell","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B628&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":46.3}]
["03-62-020","Troy","Montgomery","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B629&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.93}]
["01-75-010","Tryon","Polk","Broad River (01-1)","Yes","No",null,{"$f":"VLOOKUP(B630&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.93}]
["01-50-035","Tuckaseigee WS Authority","Jackson","Tuskasegee River (07-2)","Yes","No",null,{"$f":"VLOOKUP(B631&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.869999999999997}]
["03-82-040","Turkey","Sampson","South River (02-4)","Yes","No",null,{"$f":"VLOOKUP(B632&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":37.82}]
["01-36-010","Two Rivers Utilities/Gastonia","Gaston","South Fork Catawba River (03-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B633&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":26.8}]
["04-89-015","Tyrrell County Water Department","Tyrrell","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B634&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":73.55}]
["01-90-413","Union County","Union","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B635&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":42.36}]
["04-46-106","Union Utilities Inc.","Hertford","Meherrin River (04-2)","Yes","No",null,{"$f":"VLOOKUP(B636&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":40}]
["01-12-010","Valdese","Burke","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B637&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":44.05}]
["40-91-008","Vance County Water District","Vance","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B638&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":81.650000000000006}]
["04-25-020","Vanceboro","Craven","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B639&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.6}]
["03-26-040","Wade","Cumberland","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B640&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39}]
["03-04-020","Wadesboro","Anson","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B641&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-83-020","Wagram","Scotland","Lumber River (09-1)","Yes","No",null,{"$f":"VLOOKUP(B642&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.5}]
["03-92-999","Wake Co (RTP South)","Wake","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B643&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-92-030","Wake Forest","Wake","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B644&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-34-025","Walkertown","Forsyth","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B645&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-31-010","Wallace","Duplin","Northeast Cape Fear River (02-5)","Yes","No",null,{"$f":"VLOOKUP(B646&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.7}]
["02-85-015","Walnut Cove","Stokes","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B647&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":28.57}]
["04-96-155","Walnut Creek","Wayne","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B648&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":53.42}]
["04-65-154","WALNUT HILLS","New Hanover","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B649&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-40-030","Walstonburg","Greene","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B650&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":91.5}]
["02-93-015","Warren County","Warren","Fishing Creek (15-2)","Yes","No",null,{"$f":"VLOOKUP(B651&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":50}]
["40-93-006","Warren County - Halifax","Warren","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B652&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["40-93-005","Warren County - Northampton","Warren","Roanoke River (14-1)","No","No",null,{"$f":"VLOOKUP(B653&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-93-010","Warrenton","Warren","Fishing Creek (15-2)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B654&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":64.8}]
["04-31-015","Warsaw","Duplin","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B655&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":27.18}]
["04-07-010","Washington","Beaufort","Pamlico River & Sound (15-3)","Yes","No",null,{"$f":"VLOOKUP(B656&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.23}]
["04-94-025","Washington County Water System","Washington","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B657&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":63}]
["01-13-999","Water and Sewer Authority of Cabarrus","Cabarrus","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B658&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["60-96-001","Wayne Water District Purchase","Wayne","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B659&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-96-065","Wayne Water Districts","Wayne","Neuse River (10-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B660&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":41.68}]
["01-44-010","Waynesville","Haywood","Pigeon River (05-3)","Yes","No",null,{"$f":"VLOOKUP(B661&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":23.82}]
["01-11-025","Weaverville","Buncombe","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B662&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":49.46}]
["04-42-020","Weldon","Halifax","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B663&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":31.52}]
["03-92-035","Wendell","Wake","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B664&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-16-040","West Carteret Water Corporation","Carteret","White Oak River (17-1)","Yes","No",null,{"$f":"VLOOKUP(B665&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":62}]
["01-49-158","West Iredell Water Company","Iredell","Catawba River (03-1)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B666&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":45}]
["01-05-010","West Jefferson","Ashe","New River (11-1)","Yes","No",null,{"$f":"VLOOKUP(B667&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":43.3}]
["04-96-050","WEST MOUNT OLIVE","Wayne","Northeast Cape Fear River (02-5)","No","No",null,{"$f":"VLOOKUP(B668&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-97-020","West Wilkes Water Association","Wilkes","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B669&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.049999999999997}]
["04-65-229","WESTBAY","New Hanover","New River (02-6)","No","No",null,{"$f":"VLOOKUP(B670&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-50-116","Western Carolina University","Jackson","Tuskasegee River (07-2)","Yes","No",null,{"$f":"VLOOKUP(B671&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-63-112","Whispering Pines","Moore","Cape Fear River (02-3)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B672&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-33-040","Whitakers","Edgecombe","Tar River (15-1)","Yes","No",null,{"$f":"VLOOKUP(B673&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":65.150000000000006}]
["03-09-030","White Lake","Bladen","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B674&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-24-010","Whiteville","Columbus","Waccamaw River (09-3)","Yes","No",null,{"$f":"VLOOKUP(B675&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":24.5}]
["30-41-089","Whitsett",null,null,"No","No",null,{"$f":"VLOOKUP(B676&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":72.5}]
["01-87-020","Whittier SD","Swain","Tuskasegee River (07-2)","Yes","No",null,{"$f":"VLOOKUP(B677&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-97-025","Wilkesboro","Wilkes","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B678&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":12.35}]
["04-59-010","Williamston","Martin","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B679&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":66.150000000000006}]
["04-98-010","Wilson","Wilson","Contentnea Creek (10-2)","Yes","No",null,{"$f":"VLOOKUP(B680&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":45.48}]
["04-98-999","WILSON CO SE","Wilson","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B681&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-98-998","WILSON CO SW","Wilson","Neuse River (10-1)","No","No",null,{"$f":"VLOOKUP(B682&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["40-98-014","Wilson County SEWD","Wilson","Contentnea Creek (10-2)","Yes","< 0.100 MGD",null,61]
["40-98-012","Wilson County SWWD","Wilson","Contentnea Creek (10-2)","Yes","< 0.100 MGD",null,61]
["04-98-997","WILSON COUNTY WS","Wilson","Contentnea Creek (10-2)","No","No",null,{"$f":"VLOOKUP(B685&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["40-39-004","Wilton Water and Sewer","Granville","Tar River (15-1)","No","No",null,{"$f":"VLOOKUP(B686&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-08-010","Windsor","Bertie","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B687&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":26.5}]
["04-72-015","Winfall","Perquimans","Albemarle Sound (12-1)","No","No",null,{"$f":"VLOOKUP(B688&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["01-90-030","Wingate","Union","Rocky River (18-4)","Yes","< 0.100 MGD",null,{"$f":"VLOOKUP(B689&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":39.58}]
["04-74-040","Winterville, Town of","Pitt","Neuse River (10-1)","Yes","No",null,{"$f":"VLOOKUP(B690&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":29.02}]
["04-46-020","Winton","Hertford","Chowan River (04-1)","Yes","No",null,{"$f":"VLOOKUP(B691&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.5}]
["01-11-015","Woodfin Sanitary Water and Sewer District","Buncombe","French Broad River (05-2)","Yes","No",null,{"$f":"VLOOKUP(B692&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["04-66-040","Woodland","Northampton","Meherrin River (04-2)","Yes","No",null,{"$f":"VLOOKUP(B693&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":30.5}]
["04-65-020","Wrightsville Beach","New Hanover","Cape Fear River (02-3)","Yes","No",null,{"$f":"VLOOKUP(B694&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":33.700000000000003}]
["30-99-023","Yadkin County","Yadkin","Yadkin River (18-1)","No","No",null,{"$f":"VLOOKUP(B695&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["30-99-034","Yadkin County - East Bend","Yadkin","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B696&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["30-99-029","Yadkin County - Hwy 21","Yadkin","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B697&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["02-99-015","Yadkinville","Yadkin","Yadkin River (18-1)","Yes","No",null,{"$f":"VLOOKUP(B698&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":19.86}]
["02-17-010","Yanceyville","Caswell","Roanoke River (14-1)","Yes","No",null,{"$f":"VLOOKUP(B699&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":35.69}]
["02-35-020","Youngsville","Franklin","Neuse River (10-1)","No","< 0.100 MGD",null,{"$f":"VLOOKUP(B700&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["00-00-007","Z Mayberry (test)","Alexander","Albemarle Sound (12-1)","Yes","No",null,{"$f":"VLOOKUP(B701&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
["03-92-040","Zebulon","Wake","Neuse River (10-1)","No","< 0.100 MGD",null,{"$f":"VLOOKUP(B702&\"Water\"&\"Inside\",'EFC Table'!$A$3:$H$502,8,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,"Manual Entry"]