{"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":48,"n_cols":19,"rows_kept":48,"merged":[[39,0,39,4],[39,5,39,18],[40,0,40,18],[41,0,41,18],[42,1,42,8],[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,3,46,4],[46,5,46,7],[47,3,47,4],[47,5,47,7],[48,7,48,8]]}
["Well","Designation","Appx I F2020","Arsenic","Benzene","Iron","Vinyl Chloride","Boron","Strontium","Manganese","Sodium","Chloride","TDS","Total Ammonia","Nitrate","Cobalt","Barium","Lead","Mercury"]
["ŦMW-1AR","C","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["ŦMW-1ADR","D","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["MW-37","D","P","*","*","*","*","*","*","*","*","*","*","*","P","*","P","P","P"]
["MW-38","D","P","*","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P"]
["MW-39","D","P","*","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P"]
["MW-40","D","P","*","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P"]
["ŦMW-41R","D","P","*","*","*","*","*","*","*","*","*","*","P","P","*","P","P","P"]
["ŦMW-42R","D","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["ŦMW-43R","D","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["ŦMW-44R","D","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["MW-45R","C","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["MW-46R","C","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["MW-5","C","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["MW-50","D","P","*","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P"]
["MW-51","D","P","*","*","*","*","*","*","*","*","*","*","P","P","*","P","P","P"]
["MW-54","C","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["MW-55","B","P","P","P","P","P","P","P","P","P","P","*","*","P","*","*","*","P"]
["MW-56","B","P","*","*","*","*","*","*","*","*","*","*","*","P","*","*","*","P"]
["ŦMW-57R","D","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["MW-58","D","P","*","*","*","*","*","*","*","*","*","*","*","P","P","*","P","P"]
["MW-66","D","P","*","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P"]
["MW-67","D","P","P","P","P","P","P","P","P","P","P","P","*","P","P","P","P","P"]
["ŦMW-69","D","*","P","P","*","P","*","*","*","*","*","*","*","*","P","P","P","*"]
["BZ-3","WL"]
["ŦBZ-3R","D","*","P","P","*","P","*","*","*","*","*","*","*","*","P","P","P","*"]
["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":24},{"$f":"COUNTIF(D2:D34, \"*\")","v":24},{"$f":"COUNTIF(E2:E34, \"*\")","v":24},24,24,24,24,24,24,24,24,24,24,24,24,24]
[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"]
["\"P\" At permit renewal (Spring 2021)",{"$nulls":4},"GW = Total Ammonia, Boron, Iron, Manganese, Mercury, Sodium, Strontium, TDS, Chloride, Nitrate, App 1"]
["Included in Appendix I, so already covered for permit renewal cycle"]
["* Parameter tested for in normal cycle and permit renewal cycle"]
[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,"Appx I"]
[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":13,"n_cols":5,"rows_kept":13}
[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}]
[]
["Camp V is closed and no longer sampled"]

{"sheet":"Saufley","index":4,"n_rows":16,"n_cols":4,"rows_kept":16}
[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"]

{"sheet":"Beulah","index":5,"n_rows":33,"n_cols":23,"rows_kept":33,"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,22],[28,1,28,2],[28,3,28,4],[28,5,28,6],[29,1,29,2],[29,3,29,4],[29,9,29,22],[30,9,30,22],[31,9,31,22],[32,9,32,22]]}
[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","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","P","P","P","P"]
["MW-10R","B","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","*","P","P","P","P"]
["MW-7","D","*","*","*","*","*","*","*","*","*","P","P","P","P","P","P","P","P","P","P","P","P"]
["MW-8","D","*","*","*","*","*","*","*","P","*","P","P","P","P","P","P","P","P","P","P","P","P"]
["MW-9","D","*","*","*","*","*","*","*","*","P","P","P","P","P","*","P","P","P","P","P","P","P"]
["BMW-1R","D","*","*","*","*","*","*","*","*","P","P","*","*","*","*","P","P","P","P","P","P","P"]
["BMW-3R","D","*","*","*","*","*","*","*","P","P","*","P","P","P","P","P","P","P","P","P","P","P"]
["MW-6","C","*","*","*","*","*","*","*","*","P","P","P","P","P","P","*","*","*","P","P","P","P"]
["*MW-11","C","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P"]
["BMW-2","C","*","*","*","*","*","*","*","P","P","*","P","P","P","P","P","P","P","P","P","P","P"]
["BMW-7","C","*","*","*","*","*","*","*","P","P","P","P","P","P","P","P","P","P","P","P","P","P"]
["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":11},{"$f":"COUNTIF(D2:D22, \"*\")","v":11},11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11]
["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. Fall 2020"]
["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. Fall 2020"]
["SW-8","Copper",null,"Total Nitrogen",null,"Appx I VOCs & Metals"]
["SW-10","Iron",null,"TOC",null,"Pentachlorophenol",{"$nulls":3},"\"P\" 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 2019… next time should be FALL 2020"]
[{"$nulls":9},"These parameters are included in Appx I and should be run on all non-WL only wells for F2020"]
[{"$nulls":9},"* Parameter tested for in normal cycle and permit renewal cycle"]

{"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":15,"n_cols":12,"rows_kept":15}
["Column1","Nutrients","TN","NO2","NO3","NOX","TP","Unionized Ammonia","Ammonia as N","Total"]
["GW","Perdido",null,null,24,{"$nulls":3},24,{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":48}]
["SW","Perdido",10,null,10,null,10,10,null,{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":40}]
["GW","Perdido CAP",{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":0}]
["GW","Klondike",null,null,14,{"$nulls":3},14,{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":28}]
["SW","Klondike",2,null,2,null,2,2,null,{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":8}]
["GW","Camp V",{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":0}]
["GW","Saufley",null,null,3,{"$nulls":3},3,{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":6}]
["GW","Beulah",null,null,11,{"$nulls":3},11,{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":22}]
["SW","Beulah",4,null,4,null,4,4,null,{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":16}]
["GW","Beulah RAP",{"$nulls":6},1,{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":1}]
["SW","Beulah RAP",{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[TN]:[Ammonia as N]])","v":0},null,"Beulah SW parameters are shared with RAP SW parameters except for Pentachlorophenol"]
["Total",null,{"$f":"SUM(Table1[TN])","v":16},{"$f":"SUM(Table1[NO2])","v":0},{"$f":"SUM(Table1[NO3])","v":68},{"$f":"SUM(Table1[NOX])","v":0},{"$f":"SUM(Table1[TP])","v":16},{"$f":"SUM(Table1[Unionized Ammonia])","v":16},{"$f":"SUM(Table1[Ammonia as N])","v":53},{"$f":"SUM(Table1[Total])","v":169}]
[]
["Fall Event only"]

{"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"]