{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Perdido","Perdido CAP","Klondike","Camp V","Saufley","Beulah","Beulah RAP","Totals","Perdido ECUA Permit"],"read":"whole","date_system":"1900"}

{"sheet":"Perdido","index":0,"n_rows":46,"n_cols":19,"rows_kept":46,"merged":[[39,1,39,4],[39,5,39,16],[40,1,40,8],[41,3,41,4],[41,5,41,7],[42,3,42,4],[42,5,42,7],[43,3,43,4],[43,5,43,7],[44,3,44,4],[44,5,44,7],[45,3,45,4],[45,5,45,7],[46,7,46,8]]}
["Well","Designation","App II* F2018/Appx I S2019","Arsenic","Benzene","Iron","Vinyl Chloride","Boron","Strontium","Manganese","Sodium","Chloride","TDS","Total Ammonia","Nitrate","Cobalt","Barium","Lead","Mercury"]
["ŦMW-1AR","C",null,"*","*","*","*","*","*","*","*","*","*"]
["ŦMW-1ADR","D",null,"*","*","*","*","*","*","*","*","*","*"]
["MW-37","D",null,"*","*","*","*","*","*","*","*","*","*","*",null,"*"]
["MW-38","D",null,"*","*","*","*","*","*","*","*","*","*","*"]
["MW-39","D",null,"*","*","*","*","*","*","*","*","*","*","*"]
["MW-40","D",null,"*","*","*","*","*","*","*","*","*","*","*"]
["ŦMW-41R","D",null,"*","*","*","*","*","*","*","*","*","*",null,null,"*"]
["ŦMW-42R","D",null,"*","*","*","*","*","*","*","*","*","*"]
["ŦMW-43R","D",null,"*","*","*","*","*","*","*","*","*","*"]
["ŦMW-44R","D",null,"*","*","*","*","*","*","*","*","*","*"]
["MW-45R","C",null,"*","*","*","*","*","*","*","*","*","*"]
["MW-46R","C",null,"*","*","*","*","*","*","*","*","*","*"]
["MW-5","C",null,"*","*","*","*","*","*","*","*","*","*"]
["MW-50","D",null,"*","*","*","*","*","*","*","*","*","*","*"]
["MW-51","D",null,"*","*","*","*","*","*","*","*","*","*",null,null,"*"]
["MW-54","C",null,"*","*","*","*","*","*","*","*","*","*"]
["MW-55","B",{"$nulls":10},"*","*",null,"*","*","*"]
["MW-56","B",null,"*","*","*","*","*","*","*","*","*","*","*",null,"*","*","*"]
["ŦMW-57R","D",null,"*","*","*","*","*","*","*","*","*","*"]
["MW-58","D",null,"*","*","*","*","*","*","*","*","*","*","*",null,null,"*"]
["MW-66","D",null,"*","*","*","*","*","*","*","*","*","*"]
["MW-67","D",{"$nulls":11},"*"]
["ŦMW-69","D","*",null,null,"*",null,"*","*","*","*","*","*","*","*",{"$nulls":3},"*"]
["BZ-3","WL"]
["ŦBZ-3R","D","*",null,null,"*",null,"*","*","*","*","*","*","*","*",{"$nulls":3},"*"]
["MW-19","WL"]
["MW-27","WL"]
["MW-32","WL"]
["MW-36","WL"]
["MW-48","WL"]
["MW-49","WL"]
["MW-52R","WL"]
["MW-53","WL"]
[null,"Total Wells",{"$f":"COUNTIF(C2:C34, \"*\")","v":2},{"$f":"COUNTIF(D2:D34, \"*\")","v":20},{"$f":"COUNTIF(E2:E34, \"*\")","v":20},22,20,22,22,22,22,22,23,11,2,5,3,2,2]
[null,"* Mercury not on the list because it is included in App II.  App I is not listed because it is a subset of App II."]
[null,"MW-69 and BZ-3R will get an initial characterization Fall 2018.  Follow permit guidelines for Spring 2019.",{"$nulls":13},"26 wells sampled"]
[null,"Ŧ = new wells for Fall 2018",null,null,"* Appx II run for initial characterization, Appx I after that."]
[null,"App I = Metals: Sb, As, Ba, Be, Cd, Cr, Co, Cu, Pb, Ni, Se, Ag, Tl, V, Zn, VOC's, EDB"]
[null,"At permit renewal (Spring 2021)",{"$nulls":3},"GW = Total Ammonia, Boron, Iron, Manganese, Mercury, Sodium, Strontium, TDS, Chloride, Nitrate, App 1"]
[null,"Surface Water"]
[null,"SW-5N","D-SE-1","BOD",null,"TDS",null,null,"TN"]
[null,"SW-6","D-SE-2","COD",null,"TOC",null,null,"TSS"]
[null,"SW-11","D-SW-2","Iron",null,"Unionized Ammonia",null,null,"App 1"]
[null,"SW-13","D-WT-3","LL Mecury",null,"Hardness"]
[null,"SW-14","D-NE-4","Nitrate",null,"TP"]

{"sheet":"Perdido CAP","index":1,"n_rows":22,"n_cols":8,"rows_kept":22}
[null,"Designation","Benzene","Iron","Manganese","Tetrachloroethene","Trichloroethene","Vinyl Chloride"]
["MW-25","CAP","*","*","*","*","*","*"]
["MW-19D","CAP","*","*","*","*","*","*"]
["MW-20D","CAP","*","*","*","*","*","*"]
["MW-30","CAP","*","*","*","*","*","*"]
["MW-29","CAP",null,"*","*"]
["MW-31","CAP",null,"*","*"]
["MEX-4S","CAP",null,"*","*"]
["MEX-4D","CAP",null,"*","*"]
["PEX-2S","CAP",null,"*","*"]
["PEX-2D","CAP",null,"*","*"]
["RW-2","CAP","*","*","*",null,null,"*"]
["Sand Filter","CAP","*","*","*",null,null,"*"]
["Influent","CAP","*","*","*",null,null,"*"]
["MW-37","CAP/Permit","*","*","*",null,null,"*"]
["MW-38","CAP/Permit","*","*","*",null,null,"*"]
["MW-50","CAP/Permit","*","*","*",null,null,"*"]
["MW-51","CAP/Permit","*","*","*",null,null,"*"]
["MW-56","CAP/Permit","*","*","*",null,null,"*"]
["MW-54","CAP/Permit","WL only"]
["MW-58","CAP/Permit","WL only"]
["Total Wells",null,12,{"$f":"COUNTIF(D2:D21,\"*\")","v":18},18,4,4,12]

{"sheet":"Klondike","index":2,"n_rows":31,"n_cols":10,"rows_kept":31,"merged":[[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2]]}
[null,"Designation","Total Ammonia","Chlorides","Iron","Mercury","Nitrate","Sodium","TDS","App I"]
["PIW-2","B","*","*","*","*","*","*","*","*"]
["PIW-3","B","*","*","*","*","*","*","*","*"]
["DW-4S","C","*","*","*","*","*","*","*","*"]
["DW-5S","C","*","*","*","*","*","*","*","*"]
["DW-6S","C","*","*","*","*","*","*","*","*"]
["MW-5","C","*","*","*","*","*","*","*","*"]
["DW-2I","B","*","*","*","*","*","*","*","*"]
["MW-3","C","*","*","*","*","*","*","*","*"]
["MW-3AR","C","*","*","*","*","*","*","*","*"]
["MW-6","C","*","*","*","*","*","*","*","*"]
["MW-7AR","C","*","*","*","*","*","*","*","*"]
["DW-5I","C","*","*","*","*","*","*","*","*"]
["DW-6I","C","*","*","*","*","*","*","*","*"]
["DW-6D","C","*","*","*","*","*","*","*","*"]
[null,"Total Wells",{"$f":"COUNTIF(C2:C15, \"*\")","v":14},{"$f":"COUNTIF(D2:D15, \"*\")","v":14},14,14,14,14,14,14]
["Surface Water"]
["SW-1","Unionized Ammonia"]
["SW-2","Hardness"]
[null,"Copper"]
[null,"LL Mercury"]
[null,"Iron"]
[null,"Nitrate"]
[null,"Zinc"]
[null,"TDS"]
[null,"TOC"]
[null,"TP"]
[null,"Total Nitrogen"]
[null,"COD"]
[null,"TSS"]
[null,"App I"]

{"sheet":"Camp V","index":3,"n_rows":11,"n_cols":5,"rows_kept":11}
[null,"Designation","Arsenic","Iron","Total Ammonia"]
["MW-8","B","*","*","*"]
["MW-9","C","*","*","*"]
["MW-10","C","*","*","*"]
["MW-11","C","*","*","*"]
["MW-5","WL"]
["MW-3","WL"]
["MW-2","WL"]
["MW-1","WL"]
["MW-6","WL"]
[null,"Total Wells",{"$f":"COUNTIF(C2:C10, \"*\")","v":4},{"$f":"COUNTIF(D2:D10, \"*\")","v":4},{"$f":"COUNTIF(E2:E10, \"*\")","v":4}]

{"sheet":"Saufley","index":4,"n_rows":18,"n_cols":4,"rows_kept":18}
[null,"Designation",null,"Parameters for all"]
["MW-1","C",null,"Aluminum"]
["MW-2","WL",null,"Chlorides"]
["MW-3","Destroyed",null,"Nitrate"]
["MW-4","C",null,"Sulfate"]
["MW-5","WL",null,"TDS"]
["MW-6","B",null,"Iron "]
[{"$nulls":3},"Sodium"]
[{"$nulls":3},"Arsenic"]
[{"$nulls":3},"Cadmium"]
[{"$nulls":3},"Chromium"]
[{"$nulls":3},"Lead"]
[{"$nulls":3},"Mercury"]
[{"$nulls":3},"Total Ammonia"]
[{"$nulls":3},"Xylenes"]
[{"$nulls":3},"EPA Methods 601 & 602 Parameter List"]
[]
["Sampled for parameter list"]

{"sheet":"Beulah","index":5,"n_rows":32,"n_cols":23,"rows_kept":32,"merged":[[24,1,24,2],[24,3,24,4],[24,5,24,6],[24,9,24,20],[25,1,25,2],[25,3,25,4],[25,5,25,6],[25,9,25,22],[26,1,26,2],[26,3,26,4],[26,5,26,6],[27,1,27,2],[27,3,27,4],[27,5,27,6],[27,9,28,18],[28,1,28,2],[28,3,28,4],[28,5,28,6],[29,1,29,2],[29,3,29,4]]}
[null,"Designation","Appx II PAHs","Aluminum","Iron","Manganese","Sodium","Chloride","TDS","Ammonia as N","Arsenic","Lead","Mercury","Tetra-chloroethene","Vinyl Chloride","Benzene","Penta-chlorophenol","Tolune","Xylene","Appx I Metals","Appx I VOC's","EDB/DBCP","Nitrate"]
["MW-4","B","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*"]
["MW-10R","B","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*"]
["MW-7","D","*","*","*","*","*","*","*","*","*"]
["MW-8","D","*","*","*","*","*","*","*",null,"*"]
["MW-9","D","*","*","*","*","*","*","*","*",{"$nulls":5},"*"]
["BMW-1R","D","*","*","*","*","*","*","*","*",null,null,"*","*","*","*"]
["BMW-3R","D","*","*","*","*","*","*","*",null,null,"*"]
["MW-6","C","*","*","*","*","*","*","*","*",{"$nulls":6},"*","*","*"]
["*MW-11","C"]
["BMW-2","C","*","*","*","*","*","*","*",null,null,"*"]
["BMW-7","C","*","*","*","*","*","*","*"]
["MW-6R","WL"]
["MW-12","WL"]
["MW-13","WL"]
["MW-13D","WL"]
["MW-14","WL"]
["MW-15","WL"]
["MW-16","WL"]
["MW-17","WL"]
["MW-18","WL"]
["MW-19","WL"]
[null,"Total Wells ",{"$f":"COUNTIF(C2:C22, \"*\")","v":10},{"$f":"COUNTIF(D2:D22, \"*\")","v":10},10,10,10,10,10,6,4,4,3,3,3,4,3,3,3,0,0,0,0]
["Surface Water"]
["SW-3","BOD",null,"TDS",null,"Unionized Ammonia",{"$nulls":3},"*MW-11 sampled at permit renewal or every 5 years, whichever is less. Spring 2019"]
["SW-7","COD",null,"Hardness",null,"Zinc",{"$nulls":3},"*All wells analyzed for full list (below) at permit renewal or every 5 years, whichever is less. Spring 2019"]
["SW-8","Copper",null,"Total Nitrogen",null,"Appx I VOCs & Metals"]
["SW-10","Iron",null,"TOC",null,"Pentachlorophenol",{"$nulls":3},"Full list = App 1 parameters, App 2 PAHs, Aluminum, Ammonia as Nitrogen, Iron, Manganese, Mercury, Sodium, Pentachlorophenol, TDS, Chloride, Nitrate"]
[null,"Mercury",null,"TP",null,"Appx II PAHs"]
[null,"Nitrate",null,"TSS",{"$nulls":5},"App I = Metals: Sb, As, Ba, Be, Cd, Cr, Co, Cu, Pb, Ni, Se, Ag, Tl, V, Zn, VOC's, EDB"]
[{"$nulls":9},"Last time MW-11 was sampled and full list = Spring 2014… next time should be SPRING 2019"]
[{"$nulls":9},"These parameters are included in Appx I and should be run on all non-WL only wells for S19"]

{"sheet":"Beulah RAP","index":6,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[24,1,24,3],[24,4,24,5],[25,1,25,3],[25,4,25,5],[26,1,26,3],[26,4,26,5],[27,1,27,3],[27,4,27,5],[28,1,28,3],[28,4,28,5],[29,1,29,3],[29,4,29,5],[30,1,30,3],[30,4,30,5],[31,1,31,3],[31,4,31,5],[32,1,32,3],[32,4,32,5],[33,1,33,3],[33,4,33,5]]}
[null,"Designation","PAHs","Aluminum","Iron","Manganese","Sodium","Chloride","TDS","Ammonia as N","Benzene","Pentachlorophenol","Tolune","Xylene"]
["MW-4","WL"]
["MW-10R","WL"]
["MW-7","WL"]
["MW-8","WL"]
["MW-9","WL"]
["BMW-1R","WL"]
["BMW-3R","WL"]
["MW-6","C","*","*","*","*","*","*","*","*","*","*","*","*"]
["MW-11","WL"]
["BMW-2","WL"]
["BMW-7","WL"]
["MW-6R","C (now WL Only)","NA",null,"NA",{"$nulls":5},"NA"]
["MW-12","WL"]
["MW-13","WL"]
["MW-13D","WL"]
["MW-14","WL"]
["MW-15","WL"]
["MW-16","WL"]
["MW-17","C","*",null,"*",{"$nulls":5},"*"]
["MW-18","C","*",null,"*",{"$nulls":5},"*"]
["MW-19","C","*",null,"*",{"$nulls":5},"*"]
[null,"Total Wells",4,{"$f":"COUNTIF(D2:D22, \"*\")","v":1},4,1,1,1,1,1,4,1,1,1]
["Surface Water"]
["SW-3","App I",null,null,"TP"]
["SW-7","Pentachlorophenol (permit only)",null,null,"TN"]
["SW-8","Unionized Ammonia",null,null,"COD",null,null,"* Only the highlighted parameters are reported in RAP report for MW-6"]
["SW-10","Hardness",null,null,"TSS"]
[null,"Copper",null,null,"PAHs"]
[null,"LL Mercury",null,null,"Iron"]
[null,"Nitrate",null,null,"BOD"]
[null,"Zinc"]
[null,"TDS"]
[null,"TOC"]

{"sheet":"Totals","index":7,"n_rows":14,"n_cols":12,"rows_kept":14}
["Column1","Nutrients","Total Ammonia","TN","NO2","NO3","NOX","TP","Unionized Ammonia","Ammonia as N","Column2","Batches"]
["GW","Perdido",{"$f":"Perdido!N35","v":11},{"$nulls":8},2]
["SW","Perdido",null,10,null,10,null,10,10,null,null,5]
["GW","Perdido CAP"]
["GW","Klondike",14,null,null,14,{"$nulls":5},3]
["SW","Klondike",null,2,null,2,null,2,2,null,null,5]
["GW","Camp V",4,{"$nulls":8},1]
["GW","Saufley",3,null,null,3,{"$nulls":5},3]
["GW","Beulah",{"$nulls":7},6,null,1]
["SW","Beulah",null,6,null,6,null,6,6,null,null,5]
["GW","Beulah RAP",{"$nulls":7},1,null,1]
["SW","Beulah RAP",null,4,null,4,null,4,4,null,null,5]
["Total",null,{"$f":"SUBTOTAL(109,Table1[Total Ammonia])","v":32},{"$f":"(SUBTOTAL(109,Table1[TN]))*2","v":44},{"$f":"SUBTOTAL(109,Table1[NO2])","v":0},{"$f":"(SUBTOTAL(109,Table1[NO3]))*2","v":78},{"$f":"SUBTOTAL(109,Table1[NOX])","v":0},{"$f":"SUBTOTAL(109,Table1[TP])","v":22},{"$f":"SUBTOTAL(109,Table1[Unionized Ammonia])","v":22},{"$f":"SUBTOTAL(109,Table1[Ammonia as N])","v":7},{"$f":"SUM(Table1[[#Totals],[Total Ammonia]:[Ammonia as N]])","v":205},{"$f":"SUM(Table1[Batches])","v":31}]
[{"$nulls":10},{"$f":"(Table1[[#Totals],[Column2]]*2)+(20*12)","v":650}]

{"sheet":"Perdido ECUA Permit","index":8,"n_rows":39,"n_cols":4,"rows_kept":39}
[null,"Transfer Station and Leachate",null,"L-O (Fall only)"]
[null,"Cadmium",null,"TDS"]
[null,"Copper",null,"BOD"]
[null,"Lead",null,"COD"]
[null,"Nickel",null,"Total Ammonia"]
[null,"Silver",null,"Nitrate"]
[null,"Zinc",null,"Nitrite"]
[null,"Mercury",null,"Nitrate + Nitrite"]
[{"$nulls":3},"Total Nitrogen"]
[{"$nulls":3},"Total Nitrogen"]
[{"$nulls":3},"Chlorides"]
[{"$nulls":3},"Bicarbonate"]
[{"$nulls":3},"Cyanide"]
[{"$nulls":3},"Sulfide"]
[{"$nulls":3},"Antimony (all Appx II metals by 6010/6020)"]
[{"$nulls":3},"Arsenic"]
[{"$nulls":3},"Barium"]
[{"$nulls":3},"Beryllium"]
[{"$nulls":3},"Boron"]
[{"$nulls":3},"Cadmium"]
[{"$nulls":3},"Chromium"]
[{"$nulls":3},"Cobalt"]
[{"$nulls":3},"Copper"]
[{"$nulls":3},"Iron"]
[{"$nulls":3},"Lead"]
[{"$nulls":3},"Nickel"]
[{"$nulls":3},"Selenium"]
[{"$nulls":3},"Silver"]
[{"$nulls":3},"Sodium"]
[{"$nulls":3},"Thallium"]
[{"$nulls":3},"Tin"]
[{"$nulls":3},"Vanadium"]
[{"$nulls":3},"Zinc"]
[{"$nulls":3},"Mercury (7470/7471)"]
[{"$nulls":3},"8260 Volatiles (Appx II)"]
[{"$nulls":3},"8270 Semi-volatiles (Appx II + TIC List)"]
[{"$nulls":3},"8081/8082 Pesticides/PCBs (Appx II)"]
[{"$nulls":3},"8151 Herbicides (Appx II)"]
[{"$nulls":3},"8011 EDB/DBCP"]