{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data Entry","PrmMthds_List","List","REVISIONS","CODING Resources"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"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":"Data Entry","index":0,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,1,5],[5,1,5,5],[4,1,4,5],[15,1,15,3],[15,4,15,5],[6,4,6,5],[8,4,8,5],[2,1,2,5],[3,1,3,5],[12,4,12,5],[14,1,14,3],[14,4,14,5],[13,4,13,5],[13,1,13,3]]}
["INSTRUCTIONS"]
[null,"Enter the laboratory's name and select the the appropriate certification request from pull down list (red tinted boxes).  The fee will automatically be calculated once Certification Type provided and the requested test methods have been entered. "]
[null,"FIRST, if requested, click the ENABLE MACROS botton upon opening.  In the table below, please select all methods for which the lab is either 1.) renewing, 2.) adding, or deleting by selecting KEEP, ADD or DELETE from the first column, respectively.  "]
[null,"Continue to select the appropriate method from the pull down list, in the following order,  from (1st) DW Analyte Category column, then the (2nd) Analyte column, then the (3rd) Methods/Tests column.   Note: Multiple test method requests can be made in the same row within the Methods/Tests column."]
[null,"No additional formatting is required for long list of selected test methods.  If the last column is reached, the table will expand to another page by pressing tab and create a new line.  Alterations to any portions of the spreadsheet besides intended cells may produce unwanted consequences to the spreadsheet. "]
[null,"DO NOT SUBMIT an attached EXCEL spreadsheet with the lab application!  Once completed, print relevent pages and submit hard copy or scanned pdf with application.  The spreadsheet can be saved if not able to fully complete in one sitting. "]
[null,null,null,"Laboratory Name:"]
[]
[null,null,null,"Type of Certification Request:"]
[]
[null,null,null,"Lab Certification Fee:",{"$f":"IF(ISBLANK(E9),\"\",IF(OR(E9=List!B2,E9=List!B4),$E$16,IF(E9=List!B3,$E$15,\"N/A\")))","v":""}]
[null,"Hidden Calculations & Definitions"]
[null,null,null,"# of requested analyte methods - ",{"$f":"SUM(tblData[Column1])","v":0}]
[null,"The formula to the left is apart of the table in Column G, which has been hidden….used to calculate the # of requested methods and not count the deleted requests.",null,null,"'IF(OR(tblData[@[Add, Keep or Delete?]]=\"Keep\",tblData[@[Add, Keep or Delete?]]=\"Add\"),LEN(F18)-LEN(SUBSTITUTE(F18,CHAR(10),\"\"))+1,\"\")"]
[null," - Fee calculation for In state renewals only",null,null,{"$f":"(E13*10)+250","v":250}]
[null," - Fixed fee for new labs and all out of state request (new or renewal)",null,null,400]
[]
[]
[null,"Add, Keep or Delete?"," ","DW Analyte Category","Analyte","Methods/Tests","Column1"]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F20)-LEN(SUBSTITUTE($F20,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F21)-LEN(SUBSTITUTE($F21,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F22)-LEN(SUBSTITUTE($F22,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F23)-LEN(SUBSTITUTE($F23,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F24)-LEN(SUBSTITUTE($F24,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F25)-LEN(SUBSTITUTE($F25,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F26)-LEN(SUBSTITUTE($F26,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F27)-LEN(SUBSTITUTE($F27,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F28)-LEN(SUBSTITUTE($F28,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F29)-LEN(SUBSTITUTE($F29,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F30)-LEN(SUBSTITUTE($F30,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F31)-LEN(SUBSTITUTE($F31,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F32)-LEN(SUBSTITUTE($F32,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F33)-LEN(SUBSTITUTE($F33,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F34)-LEN(SUBSTITUTE($F34,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F35)-LEN(SUBSTITUTE($F35,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F36)-LEN(SUBSTITUTE($F36,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F37)-LEN(SUBSTITUTE($F37,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F38)-LEN(SUBSTITUTE($F38,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F39)-LEN(SUBSTITUTE($F39,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F40)-LEN(SUBSTITUTE($F40,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F41)-LEN(SUBSTITUTE($F41,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F42)-LEN(SUBSTITUTE($F42,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F43)-LEN(SUBSTITUTE($F43,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F44)-LEN(SUBSTITUTE($F44,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F45)-LEN(SUBSTITUTE($F45,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F46)-LEN(SUBSTITUTE($F46,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F47)-LEN(SUBSTITUTE($F47,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F48)-LEN(SUBSTITUTE($F48,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F49)-LEN(SUBSTITUTE($F49,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F50)-LEN(SUBSTITUTE($F50,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F51)-LEN(SUBSTITUTE($F51,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F52)-LEN(SUBSTITUTE($F52,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F53)-LEN(SUBSTITUTE($F53,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F54)-LEN(SUBSTITUTE($F54,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F55)-LEN(SUBSTITUTE($F55,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F56)-LEN(SUBSTITUTE($F56,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F57)-LEN(SUBSTITUTE($F57,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F58)-LEN(SUBSTITUTE($F58,CHAR(10),\"\"))+1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(tblData[[#This Row],[Add, Keep or Delete?]]=\"Keep\",tblData[[#This Row],[Add, Keep or Delete?]]=\"Add\"),LEN($F59)-LEN(SUBSTITUTE($F59,CHAR(10),\"\"))+1,\"\")","v":""}]

{"sheet":"PrmMthds_List","index":1,"n_rows":30,"n_cols":118,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["DW Parameter Category","Haloacetic Acids","Herbicides","Inorganics","Metals","Microbiology","PFAS","Pesticides","Radiologicals","Synthetic Organic Compounds","Trihalomethanes","Volatile Organic Compounds","Dibromoacetic Acid","Dichloroacetic Acid","Monobromoacetic Acid","Monochloroacetic Acid","Trichloroacetic Acid","2,4-D","2,4,5-TP (Silvex)","Dalapon","Dinoseb","Pentachlorophenol","Picloram","Asbestos","Chlorite","Cyanide","Fluoride","Nitrate","Nitrate + Nitrite","Nitrite","Antimony","Arsenic","Barium","Beryllium","Cadmium","Chromium","Copper","Lead","Mercury","Selenium","Thallium","E. coli","E. coli Enumeration","Cryptosporidium","Heterotrophic Plate Count","Total  Coliforms","Fecal Coliforms","PFOA","PFOS","PFHxS","PFNA","HFPO-DA (GenX)","PFBS","Alachlor","Aldicarb","Aldicarb Sulfone","Aldicarb Sulfoxide","Atrazine","Carbofuran","Chlordane","Diquat","Endothall","Endrin","Glyphosate","Heptachlor","Heptachlor Epoxide","Hexachlorobenzene","Hexachlorocyclopentadiene","Lindane","Methoxychlor","Oxamyl (Vydate)","PCBs ","Simazine","Toxaphene","Cesium 134","Cesium 137","Cobalt 60","Gross alpha","Gross beta","Iodine 131","Radium 226","Radium 228","Strontium 89","Strontium 90","Tritium","Uranium","2,3,7,8-TCDD (Dioxin)","Benzo(a)pyrene","Di(2-ethylhexyl)adipate","Di(2-ethylhexyl)phthalate","Dibromochloropropane (DBCP)","Ethylene Dibromide (EDB)","Bromodichloromethane","Bromoform","Chlorodibromomethane","Chloroform","Total Trihalomethanes","(total) Xylenes","1,1,1-Trichloroethane","1,1,2-Trichloroethane","1,1-Dichloroethylene","1,2,4-Trichlorobenzene","1,2-Dichlorobenzene","1,2-Dichloroethane","1,2-Dichloropropane","1,4-Dichlorobenzene","Benzene","Carbon Tetrachloride","Chlorobenzene","cis-1,2-Dichloroethene","Dichloromethane","Ethylbenzene","Styrene","Tetrachloroethylene","Toluene","trans-1,2-Dichloroethene","Trichloroethylene","Vinyl Chloride"]
["Haloacetic Acids","Dibromoacetic Acid","2,4-D","Asbestos","Antimony","E. coli","PFOA","Alachlor","Cesium 134","2,3,7,8-TCDD (Dioxin)","Bromodichloromethane","(total) Xylenes","EPA 552.1 - Rev. 1.0","EPA 552.1 - Rev. 1.0","EPA 552.1 - Rev. 1.0","EPA 552.1 - Rev. 1.0","EPA 552.1 - Rev. 1.0","ASTM D5317-93","ASTM D5317-93","EPA 515.1 - Rev. 4.0","EPA 515.1 - Rev. 4.0","ASTM D5317-93","ASTM D5317-93","EPA 100.1","ASTM D6581-00 ","ALPKEM OIA-1677 - DW","ASTM D1179-04 B","ASTM D3867-90 A","ASTM D3867-90 A","ASTM D3867-90 A","ASTM D3697-92","ASTM D2972-97 B","EPA 200.5 - Rev. 4.2","ASTM D3645-03 B","EPA 200.5 - Rev. 4.2","EPA 200.5 - Rev. 4.2","ASTM D1688-95 A","ASTM D3559-03 D","ASTM D3223-02","ASTM D3859-03 A","EPA 200.8 - Rev. 5.4","Chromocult","Colilert - SM 9223 B","EPA 1622","SM 9215 B","Chromocult","SM 9221 E","EPA 533","EPA 533","EPA 533","EPA 533","EPA 533","EPA 533","EPA 505 - Rev. 2.1","EPA 531.1 - Rev. 3.1","EPA 531.1 - Rev. 3.1","EPA 531.1 - Rev. 3.1","EPA 505 - Rev. 2.1","EPA 531.1 - Rev. 3.1","EPA 505 - Rev. 2.1","EPA 549.2 - Rev. 1.0","EPA 548.1 - Rev. 1.0","EPA 505 - Rev. 2.1","EPA 547","EPA 505 - Rev. 2.1","EPA 505 - Rev. 2.1","EPA 505 - Rev. 2.1","EPA 505 - Rev. 2.1","EPA 505 - Rev. 2.1","EPA 505 - Rev. 2.1","EPA 531.1 - Rev. 3.1","EPA 505 - Rev. 2.1","EPA 505 - Rev. 2.1","EPA 505 - Rev. 2.1","ASTM D2459-72","ASTM D2459-72","ASTM D3649-06","ASTM D7283-17","ASTM D7283-17","ASTM D3649-91","ASTM D2460-97","EPA 904.0","DOE Sr-01","DOE Sr-01","ASTM D4107-91","ASTM D2907-97","EPA 1613","EPA 525.2 - Rev. 2.0","EPA 506 - Rev. 1.1","EPA 506 - Rev. 1.1","EPA 504.1 - Rev. 1.1","EPA 504.1 - Rev. 1.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1","EPA 502.2 - Rev. 2.1"]
["Herbicides","Dichloroacetic Acid","2,4,5-TP (Silvex)","Chlorite","Arsenic","E. coli Enumeration","PFOS","Aldicarb","Cesium 137","Benzo(a)pyrene","Bromoform","1,1,1-Trichloroethane","EPA 552.2 - Rev. 1.0","EPA 552.2 - Rev. 1.0","EPA 552.2 - Rev. 1.0","EPA 552.2 - Rev. 1.0","EPA 552.2 - Rev. 1.0","ASTM D5317-98","ASTM D5317-98","EPA 515.3 - Rev. 1.0","EPA 515.2 - Rev. 1.1","ASTM D5317-98","ASTM D5317-98","EPA 100.2","ASTM D6581-08 A","ASTM D2036-06 A","ASTM D1179-10 B","ASTM D3867-90 B","ASTM D3867-90 B","ASTM D3867-90 B","ASTM D3697-02","ASTM D2972-03 B","EPA 200.7 - Rev. 4.4","ASTM D3645-08 B","EPA 200.7 - Rev. 4.4","EPA 200.7 - Rev. 4.4","ASTM D1688-02 A","ASTM D3559-08 D","ASTM D3223-12","ASTM D3859-03 B","EPA 200.9 - Rev. 2.2","Colilert - SM 9223 B","Colilert - SM 9223 B-04","EPA 1623","SM 9215 B-00","Colilert - SM 9223 B","SM 9221 E-06","EPA 537.1 - Ver 2.0","EPA 537.1 - Ver 2.0","EPA 537.1 - Ver 2.0","EPA 537.1 - Ver 2.0","EPA 537.1 - Ver 2.0","EPA 537.1 - Ver 2.0","EPA 507 - Rev. 2.1","EPA 531.2 - Rev. 1.0","EPA 531.2 - Rev. 1.0","EPA 531.2 - Rev. 1.0","EPA 507 - Rev. 2.1","EPA 531.2 - Rev. 1.0","EPA 508 - Rev. 3.1",null,null,"EPA 508 - Rev. 3.1","SM 6651","EPA 508 - Rev. 3.1","EPA 508 - Rev. 3.1","EPA 508 - Rev. 3.1","EPA 508 - Rev. 3.1","EPA 508 - Rev. 3.1","EPA 508 - Rev. 3.1","EPA 531.2 - Rev. 1.0","EPA 508 - Rev. 3.1","EPA 507 - Rev. 2.1","EPA 508 - Rev. 3.1","ASTM D3649-91","ASTM D3649-91","ASTM D3649-91","EPA 00-01","EPA 00-01","ASTM D3649-98a","ASTM D3454-97","EPA Ra-05","DOE Sr-02","DOE Sr-02","ASTM D4107-98","ASTM D3972-02",null,"EPA 525.3","EPA 525.2 - Rev. 2.0","EPA 525.2 - Rev. 2.0","EPA 524.3","EPA 524.3","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 ","EPA 524.2 - Rev. 4.1 "]
["Inorganics","Monobromoacetic Acid","Dalapon","Cyanide","Barium","Cryptosporidium","PFHxS","Aldicarb Sulfone","Cobalt 60","Di(2-ethylhexyl)adipate","Chlorodibromomethane","1,1,2-Trichloroethane","EPA 552.3 - Rev. 1.0","EPA 552.3 - Rev. 1.0","EPA 552.3 - Rev. 1.0","EPA 552.3 - Rev. 1.0","EPA 552.3 - Rev. 1.0","EPA 515.1 - Rev. 4.0","EPA 515.1 - Rev. 4.0","EPA 515.4 - Rev. 1.0","EPA 515.3 - Rev. 1.0","EPA 515.1 - Rev. 4.0","EPA 515.1 - Rev. 4.0",null,"ASTM D6581-08 B","ASTM D2036-06 B","ASTM D1179-16 B","ASTM D4327-03","ASTM D4327-03","ASTM D4327-03","ASTM D3697-07","ASTM D2972-03 C","EPA 200.8 - Rev. 5.4","ASTM D3645-15 B","EPA 200.8 - Rev. 5.4","EPA 200.8 - Rev. 5.4","ASTM D1688-07 A","ASTM D3559-15 D","ASTM D3223-97","ASTM D3859-08 A",null,"Colilert - SM 9223 B-04","Colilert - SM 9223 B-97","EPA 1623.1","SM 9215 B-04","Colilert - SM 9223 B-04","SM 9221 E-99",null,null,null,null,null,null,"EPA 508.1 - Rev. 2.0","AU-269R0","AU-269R0","AU-269R0","EPA 508.1 - Rev. 2.0","SM 6610 B","EPA 508.1 - Rev. 2.0",null,null,"EPA 508.1 - Rev. 2.0","SM 6651 B","EPA 508.1 - Rev. 2.0","EPA 508.1 - Rev. 2.0","EPA 508.1 - Rev. 2.0","EPA 508.1 - Rev. 2.0","EPA 508.1 - Rev. 2.0","EPA 508.1 - Rev. 2.0","SM 6610 B","EPA 508A - Rev. 1.0","EPA 508.1 - Rev. 2.0","EPA 508.1 - Rev. 2.0","ASTM D3649-98a","ASTM D3649-98a","ASTM D3649-98a","EPA 00-02","EPA 900.0 - Rev. 1.0","ASTM D3649-06","ASTM D3454-05","EPA EMSL LV 053917 (page 19)","EPA 905.0","EPA 905.0","ASTM D4107-08","ASTM D3972-09",null,"EPA 550","EPA 525.3","EPA 525.3","EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3","EPA 524.3"]
["Metals","Monochloroacetic Acid","Dinoseb","Fluoride","Beryllium","Heterotrophic Plate Count","PFNA","Aldicarb Sulfoxide","Gross alpha","Di(2-ethylhexyl)phthalate","Chloroform","1,1-Dichloroethylene","EPA 557","EPA 557","EPA 557","EPA 557","EPA 557","EPA 515.2 - Rev. 1.1","EPA 515.2 - Rev. 1.1","EPA 552.1 - Rev. 1.0","EPA 515.4 - Rev. 1.0","EPA 515.2 - Rev. 1.1","EPA 515.2 - Rev. 1.1",null,"ChlordioX Plus","ASTM D2036-98 A","ASTM D1179-93 B","ASTM D4327-11","ASTM D4327-11","ASTM D4327-11","ASTM D3697-12","ASTM D2972-08 B","SM 3111 D","ASTM D3645-97 B","EPA 200.9 - Rev. 2.2","EPA 200.9 - Rev. 2.2","ASTM D1688-12 A","ASTM D3559-96 D","EPA 200.8 - Rev. 5.4","ASTM D3859-08 B",null,"Colilert - SM 9223 B-97","Colilert-18 - SM 9223 B",null,"Simplate","Colilert - SM 9223 B-97","SM 9222 D",null,null,null,null,null,null,"EPA 525.2 - Rev. 2.0","SM 6610","SM 6610","SM 6610","EPA 525.2 - Rev. 2.0","SM 6610 B-04","EPA 525.2 - Rev. 2.0",null,null,"EPA 525.2 - Rev. 2.0","SM 6651 B-00","EPA 525.2 - Rev. 2.0","EPA 525.2 - Rev. 2.0","EPA 525.2 - Rev. 2.0","EPA 525.2 - Rev. 2.0","EPA 525.2 - Rev. 2.0","EPA 525.2 - Rev. 2.0","SM 6610 B-04","EPA 508.1 - Rev. 2.0","EPA 523","EPA 525.2 - Rev. 2.0","ASTM D3649-06","ASTM D3649-06","ASTM D4785-00a","EPA 900.0 - Rev. 1.0","EPA 900.0","ASTM D4785-93","DHS Ra-04","EPA 600/4-75-008 (page 24)","EPA Sr-04","EPA Sr-04","EPA 906.0","ASTM D3972-97",null,"EPA 550.1",null,null,null,null,"EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4","EPA 524.4"]
["Microbiology","Trichloroacetic Acid","Pentachlorophenol","Nitrate","Cadmium","Total  Coliforms","HFPO-DA (GenX)","Atrazine","Gross beta","Dibromochloropropane (DBCP)","Total Trihalomethanes","1,2,4-Trichlorobenzene",null,null,null,null,null,"EPA 515.3 - Rev. 1.0","EPA 515.3 - Rev. 1.0","EPA 552.2 - Rev. 1.0","EPA 555 - Rev. 1.0","EPA 515.3 - Rev. 1.0","EPA 515.3 - Rev. 1.0",null,"EPA 300.0 - Rev. 2.1","ASTM D2036-98 B","ASTM D1179-99 B","ASTM D4327-97","ASTM D4327-97","ASTM D4327-97","EPA 200.5 - Rev. 4.2","ASTM D2972-08 C","SM 3111 D-99","EPA 200.5 - Rev. 4.2","SM 3113 B","SM 3113 B","ASTM D1688-95 C","EPA 200.5 - Rev. 4.2","EPA 245.1 - Rev. 3.0","ASTM D3859-15 A",null,"Colilert-18 - SM 9223 B","Colilert-18 - SM 9223 B-04",null,null,"Colilert-18 - SM 9223 B","SM 9222 D-06",null,null,null,null,null,null,"EPA 525.3",null,null,null,"EPA 525.3",null,"EPA 525.3",null,null,"EPA 525.3","SM 6651 B-05","EPA 525.3","EPA 525.3","EPA 525.3","EPA 525.3","EPA 525.3","EPA 525.3",null,"EPA 525.2 - Rev. 2.0","EPA 525.2 - Rev. 2.0","EPA 525.3","DOE 4.5.2.3","DOE 4.5.2.3","ASTM D4785-08","EPA 900.0","EPA EMSL LV 053917 (page 1)","ASTM D4785-00A","DHS Ra-05","GA","EPA 600/4-75-008 (page 29)","EPA 600/4-75-008 (page 29)","EPA H-02","ASTM D5174-02",null,null,null,null,null,null,"EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0",null,"EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0",null,null,null,null,null,null,null,"EPA 551.1 - Rev. 1.0",null,null,null,null,null,"EPA 551.1 - Rev. 1.0",null,null,"EPA 551.1 - Rev. 1.0"]
["PFAS",null,"Picloram","Nitrate + Nitrite","Chromium","Fecal Coliforms","PFBS","Carbofuran","Iodine 131","Ethylene Dibromide (EDB)",null,"1,2-Dichlorobenzene",null,null,null,null,null,"EPA 515.4 - Rev. 1.0","EPA 515.4 - Rev. 1.0","EPA 552.3 - Rev. 1.0","SM 6640 B","EPA 515.4 - Rev. 1.0","EPA 515.4 - Rev. 1.0",null,"EPA 300.1 - Rev. 1.0","ASTM D6888-04","ASTM D4327-03","ASTM D6508-00","ASTM D6508-00","ASTM D6508-00","EPA 200.8 - Rev. 5.4","ASTM D2972-15 B","SM 3113 B","EPA 200.7 - Rev. 4.4","SM 3113 B-04","SM 3113 B-04","ASTM D1688-02 C","EPA 200.8 - Rev. 5.4","EPA 245.2","ASTM D3859-15 B",null,"Colilert-18 - SM 9223 B-04","Colisure - SM 9223 B",null,null,"Colilert-18 - SM 9223 B-04","SM 9222 D-97",null,null,null,null,null,null,"EPA 551.1 - Rev. 1.0",null,null,null,"EPA 551.1 - Rev. 1.0",null,null,null,null,"EPA 551.1 - Rev. 1.0",null,"EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0","EPA 551.1 - Rev. 1.0",null,"EPA 525.3","EPA 525.3",null,"DOE Ga-01-R","DOE Ga-01-R","ASTM D4785-93","EPA EMSL LV 053917 (page 1)","EPA 600/4-75-008 (page 1)","ASTM D4785-08","EPA 903.0","NJ","EPA EMSL LV 053917 (page 65)","EPA EMSL LV 053917 (page 65)","EPA 600/4-75-008 (page 34)","ASTM D5174-07"]
["Pesticides",null,null,"Nitrite","Copper",null,null,"Chlordane","Radium 226",null,null,"1,2-Dichloroethane",null,null,null,null,null,"EPA 555 - Rev. 1.0","EPA 555 - Rev. 1.0","EPA 557","SM 6640 B-01","EPA 525.2 - Rev. 2.0","EPA 555 - Rev. 1.0",null,"EPA 317 - Rev. 2.0","EPA 335.4 - Rev. 1.0","ASTM D4327-11","ASTM D6508-15","ASTM D6508-15","ASTM D6508-15","EPA 200.9 - Rev. 2.2","ASTM D2972-15 C","SM 3113 B-04","EPA 200.8 - Rev. 5.4","SM 3113 B-10","SM 3113 B-10","ASTM D1688-07 C","EPA 200.9 - Rev. 2.2","SM 3112 B","ASTM D3859-98 A",null,"Colisure - SM 9223 B","Colisure - SM 9223 B-04",null,null,"Colisure - SM 9223 B",null,null,null,null,null,null,null,null,null,null,null,"EPA 536",null,null,null,null,null,null,null,null,null,null,null,null,null,"EPA 551.1 - Rev. 1.0","EPA 536",null,"EPA 901.0","EPA 901.0","DOE 4.5.2.3","EPA 600/4-75-008 (page 1)","SM 302","DOE 4.5.2.3","EPA 903.1","NY","SM 303","SM 303","EPA EMSL LV 053917 (page 87)","ASTM D5174-97"]
["Radiologicals",null,null,null,"Lead",null,null,"Diquat","Radium 228",null,null,"1,2-Dichloropropane",null,null,null,null,null,"SM 6640 B","SM 6640 B","SM 6640 B","SM 6640 B-06","EPA 525.3","SM 6640 B",null,"EPA 326.0 - Rev. 1.0","KELADA-01","ASTM D4327-97","EPA 300.0 - Rev. 2.1","EPA 300.0 - Rev. 2.1","EPA 300.0 - Rev. 2.1","SM 3113 B","ASTM D2972-97 C","SM 3113 B-10","EPA 200.9 - Rev. 2.2","SM 3113 B-99","SM 3113 B-99","ASTM D1688-12 C","HACH 1001 (or Palintest Ltd.)","SM 3112 B-09","ASTM D3859-98 B",null,"Colisure - SM 9223 B-04","Colisure - SM 9223 B-97",null,null,"Colisure - SM 9223 B-04",null,null,null,null,null,null,null,null,null,null,null,"EPA 523",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPA 551.1 - Rev. 1.0",null,"EPA 901.1","EPA 901.1","DOE Ga-01-R","SM 302","SM 7110 B","DOE Ga-01-R","EPA Ra-04","SM 7500-Ra D","SM 7500-Sr B","SM 7500-Sr B","SM 306","ASTM D5673-03"]
["Synthetic Organic Compounds",null,null,null,"Mercury",null,null,"Endothall","Strontium 89",null,null,"1,4-Dichlorobenzene",null,null,null,null,null,"SM 6640 B-01","SM 6640 B-01","SM 6640 B-01",null,"EPA 555 - Rev. 1.0","SM 6640 B-01",null,"EPA 327 - Rev. 1.1","LACHAT QuikChem 10-204-00-1-X - Rev.2.1","B+L 129-71W","EPA 300.1 - Rev. 1.0","EPA 300.1 - Rev. 1.0","EPA 300.1 - Rev. 1.0","SM 3113 B-99","EPA 200.8 - Rev. 5.4","SM 3113 B-99","SM 3113 B",null,"SM 3120 B","EPA 200.5 - Rev. 4.2","SM 3113 B","SM 3112 B-99","EPA 200.5 - Rev. 4.2",null,"Colisure - SM 9223 B-97",null,null,null,"Colisure - SM 9223 B-97",null,null,null,null,null,null,null,null,null,null,null,"Sygenta AG-625",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPA 600/4-75-008 (page 4)","EPA 600/4-75-008 (page 4)","EPA 901.0","SM 7110 B","SM 7110 B-00","EPA 901.1","EPA Ra-05","SM 7500-Ra D-01","SM 7500-Sr B-01","SM 7500-Sr B-01","SM 7500-3H B","ASTM D5673-05"]
["Trihalomethanes",null,null,null,"Selenium",null,null,"Endrin","Strontium 90",null,null,"Benzene",null,null,null,null,null,"SM 6640 B-06","SM 6640 B-06","SM 6640 B-06",null,"SM 6640 B","SM 6640 B-06",null,"SM 4500-ClO2 E","ME355.01","B+L 380-75WE","EPA 353.2 - Rev.2.0","EPA 353.2 - Rev.2.0","EPA 353.2 - Rev.2.0","SM 3113 B-04","EPA 200.9 - Rev. 2.2","SM 3120 B","SM 3113 B-04",null,"SM 3120 B-99","EPA 200.7 - Rev. 4.4","SM 3113 B-04",null,"EPA 200.8 - Rev. 5.4",null,"E*Colite",null,null,null,"E*Colite",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPA EMSL LV 053917 (page 92)","EPA EMSL LV 053917 (page 92)","EPA 901.1","SM 7110 B-00","SM 7110 D-17","EPA 9002.0","EPA 600/4-75-008 (page 13)","SM 7500-Ra E","USGS R-1160-76","USGS R-1160-76","SM 7500-3H B-00","ASTM D5673-10"]
["Volatile Organic Compounds",null,null,null,"Thallium",null,null,"Glyphosate","Tritium",null,null,"Carbon Tetrachloride",null,null,null,null,null,null,null,null,null,"SM 6640 B-01",null,null,"SM 4500-ClO2 E-00","SM 4500-CN¯ C","EPA 300.0 - Rev. 2.1","HACH 10206","HACH 10206","NECi 2016a","SM 3113 B-10","SM 3113 B","SM 3120 B-99","SM 3113 B-10",null,null,"EPA 200.8 - Rev. 5.4","SM 3113 B-10",null,"EPA 200.9 - Rev. 2.2",null,"EPA 1603",null,null,null,"EPA 1604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 7120","SM 7120","EPA 902.0","SM 7110 C","USGS R-1120-76","EPA 600/4-75-008 (page 6)","EPA 600/4-75-008 (page 16)","SM 7500-Ra E-07",null,null,"USGS R-1171-76","ASTM D5673-16"]
[null,null,null,null,null,null,null,"Heptachlor","Uranium",null,null,"Chlorobenzene",null,null,null,null,null,null,null,null,null,"SM 6640 B-06",null,null,null,"SM 4500-CN¯ C-99","EPA 300.1 - Rev. 1.0","NECi 2016a","NECi 2016a","SM 4110 B",null,"SM 3113 B-04",null,"SM 3113 B-99",null,null,"EPA 200.9 - Rev. 2.2","SM 3113 B-99",null,"SM 3113 B",null,"EPA 1604",null,null,null,"m-ColiBlue24 (HACH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 7120-97","SM 7120-97","EPA EMSL LV 053917 (page 92)","SM 7110 C-00",null,"EPA 600/4-75-008 (page 9)","EPA EMSL LV 053917 (page 19)","USGS R-1142-76",null,null,null,"ASTM D6239-09"]
[null,null,null,null,null,null,null,"Heptachlor Epoxide",null,null,null,"cis-1,2-Dichloroethene",null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-CN¯ E","HACH 10225 - Rev. 2.0","Orion 601","Orion 601","SM 4110 B-00",null,"SM 3113 B-10",null,"SM 3120 B",null,null,"HACH 8026 - Rev. 1.2",null,null,"SM 3113 B-04",null,"m-ColiBlue24 (HACH)",null,null,null,"m-ColiBlue24 (SM 9222 J)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 7500-Cs B","SM 7500-Cs B","SM 7120","SM 7110 D-17",null,"EPA EMSL LV 053917 (page 92)","GA",null,null,null,null,"DOE U-02"]
[null,null,null,null,null,null,null,"Hexachlorobenzene",null,null,null,"Dichloromethane",null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-CN¯ E-99","SM 4110 B","SM 4110 B","SM 4110 B","SM 4500-NO2¯ B",null,"SM 3113 B-99",null,"SM 3120 B-99",null,null,"HACH 10272 - Rev. 1.2",null,null,"SM 3113 B-10",null,"Modified Colitag",null,null,null,"Modified Colitag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 7500-Cs B-00","SM 7500-Cs B-00","SM 7120-97","USGS R-1120-76",null,"SM 7120","NY",null,null,null,null,"DOE U-04"]
[null,null,null,null,null,null,null,"Hexachlorocyclopentadiene",null,null,null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-CN¯ F","SM 4110 B-00","SM 4110 B-00","SM 4110 B-00","SM 4500-NO2¯ B-00",null,"SM 3114 B",null,null,null,null,"SM 3111 B",null,null,"SM 3113 B-99",null,"Readycult",null,null,null,"Readycult",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USGS R-1110-76","USGS R-1110-76","SM 7500-Cs B",null,null,"SM 7120-97","SM 304",null,null,null,null,"EPA 200.8 - Rev. 5.4"]
[null,null,null,null,null,null,null,"Lindane",null,null,null,"Styrene",null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-CN¯ F-99","SM 4500-F¯ B","SM 4500-NO3¯ D","SM 4500-NO3¯ D","SM 4500-NO3¯ E",null,"SM 3114 B-09",null,null,null,null,"SM 3111 B-99",null,null,"SM 3114 B",null,"SM 9221 F",null,null,null,"SM 9221 A,B,C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USGS R-1111-76","USGS R-1111-76","SM 7500-Cs B-00",null,null,"SM 7500-I B","SM 305",null,null,null,null,"EMSL-LV  p. 33"]
[null,null,null,null,null,null,null,"Methoxychlor",null,null,null,"Tetrachloroethylene",null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-CN¯ G","SM 4500-F¯ B-97","SM 4500-NO3¯ D-00","SM 4500-NO3¯ D-00","SM 4500-NO3¯ E-00",null,"SM 3114 B-97",null,null,null,null,"SM 3113 B",null,null,"SM 3114 B-09",null,"SM 9221 F-06",null,null,null,"SM 9221 A,B,C-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 7500-I B",null,null,"SM 7500-I B-00","SM 7500-Ra B",null,null,null,null,"EPA 00-07"]
[null,null,null,null,null,null,null,"Oxamyl (Vydate)",null,null,null,"Toluene",null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-CN¯ G-99","SM 4500-F¯ C","SM 4500-NO3¯ E","SM 4500-NO3¯ E","SM 4500-NO3¯ F",null,null,null,null,null,null,"SM 3113 B-04",null,null,"SM 3114 B-97",null,"SM 9222 G.1c(1)",null,null,null,"SM 9221 A,B,C-99",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 7500-I B-00",null,null,"SM 7500-I C","SM 7500-Ra B-01",null,null,null,null,"EPA 908.0"]
[null,null,null,null,null,null,null,"PCBs ",null,null,null,"trans-1,2-Dichloroethene",null,null,null,null,null,null,null,null,null,null,null,null,null,"USGS I-3300-85","SM 4500-F¯ C-97","SM 4500-NO3¯ E-00","SM 4500-NO3¯ E-00","SM 4500-NO3¯ F-00",null,null,null,null,null,null,"SM 3113 B-10",null,null,null,null,"SM 9222 G.1c(2)",null,null,null,"SM 9221 B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USGS R-1110-76",null,null,"SM 7500-I C-00","SM 7500-Ra C",null,null,null,null,"EPA 908.1"]
[null,null,null,null,null,null,null,"Simazine",null,null,null,"Trichloroethylene",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-F¯ D","SM 4500-NO3¯ F","SM 4500-NO3¯ F","Systea Easy (1-Reagent) Nitrate",null,null,null,null,null,null,"SM 3113 B-99",null,null,null,null,"SM 9222 H",null,null,null,"SM 9221 B-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 7500-I D","SM 7500-Ra C-01",null,null,null,null,"SM 3125"]
[null,null,null,null,null,null,null,"Toxaphene",null,null,null,"Vinyl Chloride",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-F¯ D-97","SM 4500-NO3¯ F-00","SM 4500-NO3¯ F-00","Waters B-1011",null,null,null,null,null,null,"SM 3120 B",null,null,null,null,"SM 9222 I",null,null,null,"SM 9221 B-99",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 7500-I D-00","SM 7500-Ra E",null,null,null,null,"SM 7500-U B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-F¯ E","Systea Easy (1-Reagent) Nitrate","Systea Easy (1-Reagent) Nitrate",null,null,null,null,null,null,null,"SM 3120 B-99",null,null,null,null,"SM 9222 J",null,null,null,"SM 9221 D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 7500-Ra E-07",null,null,null,null,"SM 7500-U B-00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 4500-F¯ E-97","Waters B-1011","Waters B-1011",null,null,null,null,null,null,null,null,null,null,null,null,"Tecta EC/TC - v.1.0",null,null,null,"SM 9221 D-99",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USGS R-1140-76",null,null,null,null,"SM 7500-U C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waters D6508 - Rev. 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tecta EC/TC - v.2.0",null,null,null,"SM 9222 A,B,C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USGS R-1141-76",null,null,null,null,"SM 7500-U C-00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 9222 A,B,C-99",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USGS R-1180-76"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 9222 B,C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USGS R-1181-76"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM 9222 B,C-97",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USGS R-1182-76"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tecta EC/TC - v.1.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tecta EC/TC - v.2.0"]

{"sheet":"List","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["AddKeepDelete","Select Type of Request","Fee Explanation:","Certification Fee:"]
["ADD","New Lab Certification","The fixed fee of $400,  regardless the number of analytes and methods requested.",400]
["DELETE","In State Renewal - Private Labs","The fee is calculated by adding $10 per test method to the base fee of $250."]
["KEEP","Out of State Renewal","Exempt from lab certification fees"]
[null,"In State Renewal - Federal, State or Local Government Labs"]

{"sheet":"REVISIONS","index":3,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":true,"merged":[[4,1,4,2],[2,1,2,2],[35,3,39,3],[51,1,51,2],[43,1,43,2]]}
["Revisions List Tracking"]
[]
["DATE","REVISIONS MADE",null,"COMMENTS"]
["2021-10-29","From the \"PrmMthds_List\" tab"]
["by TDG","Added the following four methods for ALDICARB, ALDICARB SULFONE & ALDICARB SULFOXIDE to column's list:",null,"Was missing and didn't match EPA's and MD's certified method for analyte.  "]
[null,null,"EPA 531.1 - Rev. 3.1"]
[null,null,"EPA 531.2 - Rev. 1.0"]
[null,null,"AU-269R0"]
[null,null,"SM 6610"]
[]
[null,"From the \"PrmMthds_List\" tab",null,"Was missing and didn't match EPA's and MD's certified method for analyte.  "]
[null,"Added the following methods for OXAMYL & CARBOFURAN to column's list:"]
[null,null,"EPA 531.2 - Rev. 1.0"]
[]
[null,"From the \"PrmMthds_List\" tab",null,"Was not a certified method for analyte for EPA or MD.  "]
[null,"Removed the following methods for OXAMYL & CARBOFURAN from the column's list:"]
[null,null,"EPA 531.2 - Rev. 3.1"]
[]
[null,"From the \"PrmMthds_List\" tab",null,"Was missing and didn't match EPA's and MD's certified method for analyte.  "]
[null,"Added the following method for CHLORDANE to column's list:"]
[null,null,"EPA 508.1 - Rev. 2.0"]
[]
[]
[]
["2022-04-26","From the \"PrmMthds_List\" tab",null,"Method reference corrected  to match EPA's and MD's certified method for analyte.  "]
["by TDG","Revised the following method for URANIUM to the column list:"]
[null,null,"EPA 200.8 - Rev. 5.4 replaced EPA 208 - Rev. 5.4"]
[]
[]
[null,"From the \"List\" tab"]
[null,"Revised several items in the following \"Select type of Request\" column list:",null,"Changed to eliminate confusion and provide more clarity for gov labs.  "]
[null,null,"In State Renewal - Private Labs replaced In State Renewal"]
[null,null,"In State Renewal - Federal, State or Local Government Labs replaced Federal, State or Local Government Labs"]
[]
[]
[null,null,null,"Was missing and didn't match EPA's and MD's certified method for analytes under the Long Term 2 Enhanced Surface Water Treatment Rule.  "]
["2022-07-19","From the \"PrmMthds_List\" tab"]
["by TDG","Added the following method for E.COLI to the column list:"]
[null,null,"EPA 1603"]
[]
["2024-10-01","From the \"PrmMthds_List\" tab",null,"Added all PFAS Contaminants & Methods, per April 2024 new PFAS rule.  "]
["by TDG","Added the PFAS category to the DW Parameter Category column list"]
[]
[null,"Added the column of PFAS following contaminants, along w/ individual columns for methods:"]
[null,null,"PFOA"]
[null,null,"PFOS"]
[null,null,"PFHxS"]
[null,null,"PFNA"]
[null,null,"HFPO-DA (GenX)"]
[null,null,"PFBS"]
[]
[null,"Added the following list of methods to Each New PFAS Contaminant's (listed above) column:"]
[null,null,"EPA 533"]
[null,null,"EPA 537.1 - Ver 2.0"]

{"sheet":"CODING Resources","index":4,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"www.contextures.com"]
[]
[]
[null,null,"_DW Paramater Category"]
[null,null,"=INDEX(tblVal[DW Parameter Category],1,1):INDEX(tblVal[DW Parameter Category],COUNTA(tblVal[DW Parameter Category]))"]
[]
[null,null,"_MainList"]
[null,null,"=INDEX(tblVal,0,MATCH(INDEX(tblData[@],COLUMN()-COLUMN(tblData)),tblVal[#Headers],0))"]
[]
[null,null,"_UseList"]
[null,null,"=INDEX(_MainList,1,1):INDEX(_MainList,COUNTA(_MainList))"]
[]
[null,null,"Cobalt - Don't see any methods from EPA certified for Cobalt in drinking water"]
[]
[null,null,"Nitrate+Nitrite - Don't see any methods from EPA certified specifically for the two combined in drinking water"]
[]
[null,null,"Aldicarb, Aldicarb Sulfone and Aldicarb Sulfoxide - Don't see any methods from EPA certified specifically for any of the 3 pesticides in drinking water"]