{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["COC","Instructions","Data List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"COC","index":0,"n_rows":43,"n_cols":29,"rows_kept":43,"cut":false,"hidden":false,"merged":[[17,28,17,29],[8,24,15,24],[20,28,20,29],[8,27,15,27],[16,28,16,29],[15,28,15,29],[9,0,9,3],[12,4,12,8],[8,9,15,9],[13,4,13,8],[14,0,14,3],[9,4,9,8],[12,0,12,3],[8,0,8,3],[18,0,18,3],[19,28,19,29],[19,0,19,3],[20,0,20,3],[8,20,15,20],[14,4,14,8],[8,14,15,14],[10,4,10,8],[17,0,17,3],[16,0,16,3],[0,28,3,29],[8,26,15,26],[6,19,6,27],[8,21,15,21],[6,28,6,29],[8,19,15,19],[8,25,15,25],[0,4,0,27],[6,9,6,18],[8,10,15,10],[5,4,5,8],[7,4,7,8],[8,4,8,8],[8,23,15,23],[7,19,7,27],[8,18,15,18],[8,17,15,17],[8,22,15,22],[7,9,7,18],[8,11,15,11],[8,16,15,16],[8,12,15,12],[8,13,15,13],[8,15,15,15],[6,0,6,3],[7,0,7,3],[6,4,6,8],[5,0,5,3],[0,0,0,3],[1,0,1,3],[3,0,3,3],[2,0,2,3],[11,4,11,8],[11,0,11,3],[15,0,15,3],[13,0,13,3],[10,0,10,3],[42,0,43,3],[42,28,43,29],[26,28,26,29],[28,0,28,3],[40,28,41,29],[29,28,29,29],[38,28,39,29],[33,0,36,29],[40,0,41,3],[27,0,27,3],[37,4,37,12],[29,0,29,9],[38,0,39,3],[38,4,39,6],[40,21,41,27],[42,21,43,27],[40,7,41,9],[38,10,39,20],[40,10,41,20],[42,10,43,20],[38,21,39,27],[40,4,41,6],[38,7,39,9],[42,7,43,9],[21,28,21,29],[21,0,21,3],[22,28,22,29],[42,4,43,6],[24,0,24,3],[18,28,18,29],[28,28,28,29],[31,0,31,9],[32,10,32,29],[26,0,26,3],[23,28,23,29],[30,10,30,29],[27,28,27,29],[25,28,25,29],[24,28,24,29],[23,0,23,3],[25,0,25,3],[22,0,22,3],[32,0,32,9],[30,0,30,9]]}
["Eurofins",null,null,null,"Chain of Custody Record"]
[{"$f":"VLOOKUP(A1,'Data List'!A2:H110,2,FALSE)","v":0}]
[{"$f":"IF(VLOOKUP(A1,'Data List'!A5:H110,3,FALSE)=\"\",\" \",VLOOKUP(A1,'Data List'!A5:H110,3,FALSE))","v":{"$error":"#N/A"}}]
[{"$f":"VLOOKUP(A1,'Data List'!A5:H110,4,FALSE)&\", \"&VLOOKUP(A1,'Data List'!A5:H110,5,FALSE)&\"  \"&VLOOKUP(A1,'Data List'!A5:H110,6,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"\"phone \"&VLOOKUP(A1,'Data List'!A5:H110,7,FALSE)&\"  fax \"&VLOOKUP(A1,'Data List'!A5:H110,8,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"Regulatory Program:"]
[null,null,null,null,"Project Manager: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COC  No:  "]
["Client Contact",null,null,null,"Email:",null,null,null,null,"Site Contact:",null,null,null,null,null,null,null,null,null,"Date:",null,null,null,null,null,null,null,null,"_______   of ______  COCs"]
["Your Company Name here",null,null,null,"Tel/Fax:",null,null,null,null,"Lab Contact:",null,null,null,null,null,null,null,null,null,"Carrier:",null,null,null,null,null,null,null,null,"TALS Project #:"]
["Address  ",null,null,null,"Analysis Turnaround Time",null,null,null,null,"Filtered Sample ( Y / N )","Perform MS / MSD  ( Y /  N )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sampler:"]
["City/State/Zip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Lab Use Only:"]
["(xxx) xxx-xxxx                              Phone ",null,null,null,"TAT if different from Below  __________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walk-in Client:"]
["(xxx) xxx-xxxx                                FAX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lab Sampling:"]
["Project Name:"]
["Site:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job / SDG No.:"]
["P O # "]
["Sample Identification",null,null,null,"Sample Date","Sample Time","Sample Type\n(C=Comp, G=Grab)","Matrix","# of Cont.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample Specific Notes:"]
[]
[null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Preservation Used:  1= Ice,  2= HCl;  3= H2SO4;  4=HNO3;  5=NaOH; 6= Other _____________"]
["Possible Hazard Identification:",null,null,null,null,null,null,null,null,null,"Sample Disposal ( A fee may be assessed if samples are retained longer than 1 month)"]
["Are any samples from a listed EPA Hazardous Waste?   Please List any EPA Waste Codes for the sample in the Comments Section if the lab is to dispose of the sample."]
[]
["Special Instructions/QC Requirements & Comments:  "]
[]
[]
[]
[null,null,"Custody Seals Intact:  ",null,"Custody Seal No.:",null,null,null,null,null,null,null,null,"Cooler Temp. (oC): Obs'd:_________ Corr'd:__________  Therm ID No.:____________"]
["Relinquished by:  ",null,null,null,"Company: ",null,null,"Date/Time:",null,null,"Received by:",null,null,null,null,null,null,null,null,null,null,"Company:",null,null,null,null,null,null,"Date/Time:"]
[]
["Relinquished by:",null,null,null,"Company: ",null,null,"Date/Time:",null,null,"Received by:",null,null,null,null,null,null,null,null,null,null,"Company:",null,null,null,null,null,null,"Date/Time:"]
[]
["Relinquished by:",null,null,null,"Company: ",null,null,"Date/Time:",null,null,"Received in Laboratory by:",null,null,null,null,null,null,null,null,null,null,"Company:",null,null,null,null,null,null,"Date/Time:"]

{"sheet":"Instructions","index":1,"n_rows":43,"n_cols":1,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
["INSTRUCTIONS"]
[]
[]
[]
["1)  Choose the correct Eurofins Facility from the pull down list by clicking on cell A1"]
[]
["2)  Fill in the appropriate information for your location and phone number"]
[]
["3)  Sampler - Fill in name."]
[]
["4)  Provide information on the Regulatory Program to differentiate between Drinking Water & Compliance"]
["samples."]
[]
["5)  Choose a default TAT or enter a different one if appropriate"]
[]
["6)  Please indicate whether the TAT is Working or Calendar Days"]
[]
["7)  In the veritical columns enter the Method/Analysis being requested"]
[]
["8)  Fill out the Sample Information -- each line represents one sample "]
[]
["9)  Sample Date/Time is required on all samples"]
[]
["10)  In the \"# of Containers\" field enter the total number of bottles for each sample"]
[]
["11)  Check Y or N if the sample was filtered in the field (Filtered Sample)."]
[]
["12) Note 'C' for a Composite sample; or 'G' for a Grab Sample."]
[]
["13)  The Sample name should be the one you wish to see in the final report"]
[]
["14)  In the cell where the Sample Information intersects the method information please "]
["enter the number of containers submitted for the method.  Alternatively simply \"x\" this field"]
[]
["15)  In the last row of the eCOC please choose the code for the right preservative used"]
[]
["16)  Note any Possible Hazards."]
[]
["17)  Use the Special Instructions field to add any special instructions to the lab"]
[]
["18)  If samples are sent across the country, consider indicating the Time Zone where "]
["samples were collected"]

{"sheet":"Data List","index":2,"n_rows":108,"n_cols":14,"rows_kept":108,"cut":false,"hidden":true,"merged":[]}
["Name","Address 1","Address 2","City ","State","Zip","Phone","Fax"]
["CHOOSE A LOCATION","USE DROP DOWN MENU","TO PICK YOUR","LABORATORY / Service Center"]
[]
["Eurofins"]
["Eurofins Albany Service Center","25 Kraft Ave.","","Albany","NY","12205-5464","518.438.8140","518.438.8150","x"]
["Eurofins Air Toxics","180 Blue Ravine Rd",null,"Folsom","CA","95630","800.985.5955",null,"x"]
["Eurofins Albuquerque","4901 Hawkins St.  NE",null,"Albuquerque","NM","87109","505.345.3975",null,"x"]
["Eurofins Analytical Balance","422 West Grove Street",null,"Middleboro","MA","02346","508.946.2225",null,"x"]
["Eurofins Anchorage Service Center","2000 West International Airport Rd","Unit 3","Anchorage","AK","99502","907.308.3017",null,"x"]
["Eurofins Arizona Service Center","15953 North Greenway-Hayden Loop","Suite C","Scottsdale","AZ","85260-1765","480.778.1558",null,"x"]
["Eurofins Arkansas","8600 Kanis Road",null,"Little Rock","AR","72204","501.224.5060",null,"x"]
["Eurofins Atlanta","3080 Presidential Drive",null,"Atlanta","GA","30340","770.457.8177","","x"]
["Eurofins Auburn","155 Center St","Blg","Auburn","ME","04210","207.784.5354",null,"x"]
["Eurofins Ayer","31A Willow Rd",null,"Ayer","MA","01432","978.391.4643",null,"x"]
["Eurofins BAL","259 Brooks St.",null,"Worcester","MA","01606","401.785.0241",null,"x"]
["Eurofins Baltimore Service Center","7526 Connelley Drive","Suite F","Hanover","MD","21076-1670","717.415.7291",null,"x"]
["Eurofins Baton Rouge","6113 Benefit Dr","","Baton Rouge","LA","70809-4247","225.755.8200","225.755.3080","x"]
["Eurofins Bellingham","805 W. Orchard Drive ","Suite 4","Bellingham","WA","98225","360.715.1212",null,"x"]
["Eurofins Bend","20332 Empire Ave","Suite F4","Bend","OR","97703","541.639.8425",null,"x"]
["Eurofins Boise Service Center","3243 S Federal Way Plaza",null,"Boise","ID","83705-5215","986.269.1610",null,"x",null,null,null,"180 Blue Ravine Rd"]
["Eurofins Buffalo","10 Hazelwood Drive","Suite 106","Amherst","NY","14228-2223","716.691.2600","716.691.7991","x"]
["Eurofins Carlsbad Service Center","1089 North Canal St. ",null,"Calsbad","NM","88220-5184","575.988.3199",null,"x"]
["Eurofins Cedar Falls","3019 Venture Way","","Cedar Falls","IA","50613-7444","319.277.2401","319.277.2425","x"]
["Eurofins Charlotte Service Center","2331 Executive St. ","Suite C","Charlotte","NC","28208","980.527.4980","","x"]
["Eurofins Chicago","18410 Crossing Drive","Suite E","Tinley Park","IL",60487,"708.534.5200","708.534.5211","x"]
["Eurofins Cincinnati Service Center","10172 International Blvd.",null,"West Chester","OH","45246-4846","513.733.5700","","x"]
["Eurofins Cleveland","180 S. Van Buren Ave","","Barberton","OH","44203-3543","330.497.9396","330.497.0772","x"]
["Eurofins Columbia","15 Thames Valley Road",null,"Irmo","SC","29063","803.781.4243",null,"x"]
["Eurofins Columbus Service Center","6610 Singletree Dr","","Columbus","OH","43229-1121","248.428.1544","","x"]
["Eurofins Concord (NH)","51 Antrim Ave.","","Concord","NH","03301","603.228.0525",null,"x"]
["Eurofins Concord Service Center (CA)","5063 Commercial Circle","Unit H","Concord","CA","94520-8577","925.786.8597",null,"x"]
["Eurofins Corpus Christi","1733 N. Padre Island Drive","","Corpus Christi","TX","78408-2329","361.289.2673","361.289.2471","x"]
["Eurofins Corvallis","1100 NE Circle Blvd.","Suite 130","Corvallis","OR",97330,"541.753.4946",null,"x"]
["Eurofins Dallas","9701 Harry Hines Blvd","","Dallas","TX","75220","214.902.0300","","x"]
["Eurofins Danvers","4 Bates Street Ct.",null,"Danvers","MA","01923","978.777.4442",null,"x"]
["Eurofins Davenport Service Center","321 8th Street","Unit B","Bettendorf","IA","52722-4711","563.323.7944","","x"]
["Eurofins Delray Beach Service Center","1395 NW 17th Ave","Suite 112A","Delray Beach","FL","33445-2553","561.689.6701",null,"x"]
["Eurofins Denver","4955 Yarrow Street","","Arvada","CO","80002-4517","303.736.0100","303.431.7171","x"]
["Eurofins Derry","22 Manchester Rd.",null,"Derry","NH","03038","603.432.3044",null,"x"]
["Eurofins Des Moines Service Center","11307 Aurora Ave","Building 8","Urbandale","IA","50322-7908","515.781.9781",null,"x"]
["Eurofins Drinking Water Testing- Pomona","941 Corporate Center Drive",null,"Pomona","CA","91768-2642","626.386.1100",null,"x"]
["Eurofins Duluth Service Center","1301 Avenue C",null,"Cloquet","MN",55720,"715.394.3674",null,"x"]
["Eurofins East Rutherford","196 Paterson Ave","1st Floor","East Rutherford","NJ","07073","215.436.4875",null,"x"]
["Eurofins Ecotoxicology","2501 Mayes Rd.","Suite 100","Carrollton","TX","75006","972.242.7750",null,"x"]
["Eurofins Edison","777 New Durham Road","","Edison","NJ","08817-2859","732.549.3900","732.549.3679","x"]
["Eurofins El Paso","200 E. Sunset Rd","Suite E","El Paso","TX","79922","915.585.3443",null,"x"]
["Eurofins Ft. Lauderdale","6340 NW 5th Way",null,"Ft. Lauderdale","FL","33309-6131","954.391.9334",null,"x"]
["Eurofins Grand Rapids Service Center","4595 Broadmoor Ave SE","Suite 195","Grand Rapids","MI","49512-5448","616.871.2026",null,"x"]
["Eurofins Hobbs Service Center","235 E Bender Ave","Suite 200","Hobbs","NM","88240","575.318.2074",null,"x"]
["Eurofins Honolulu Service Center","111 Sand Island Access Road","Unit 10","Honolulu","HI","96819","808.892.2679",null,"x"]
["Eurofins Hopkinton Service Center","106 South St.",null,"Hopkinton","MA","01748","508.435.9244",null,"x"]
["Eurofins Houston","4145 Greenbriar Dr","","Stafford","TX",77477,"281.240.4200",null,"x"]
["Eurofins Huntsville","861 Hwy. 19",null,"Huntsville","TX","77320","936.291.1881",null,"x"]
["Eurofins Jacksonville","8021 Philips Hwy","Suite 6","Jacksonville","FL","32256","904.296.3007",null,"x"]
["Eurofins Kansas City Service Center","806 Pflumm Rd",null,"Lenexa","KS","66215","913.871.2848",null,"x"]
["Eurofins King Of Prussia Service Center","1010 W. Ninth Avenue","Suite 50","King of Prussia","PA","19406-1213","610.337.9992","610.337.9939","x"]
["Eurofins Knoxville","5815 Middlebrook Pike","","Knoxville","TN","37921-5947","865.291.3000","865.584.4315","x"]
["Eurofins Lancaster ","2425 New Holland Pike",null,"Lancaster","PA","17601","717.656.2300",null,"x"]
["Eurofins Las Vegas Service Center","2545 Chandler Ave","Suite 3","Las Vegas","NV",89120,"702.786.5784",null,"x"]
["Eurofins Lubbock","6701 Aberdeen Ave","Suite 9","Lubbock","TX","79424-1515","806.794.1296",null,"x"]
["Eurofins Madison","812 S.W. Harvey Greene Drive",null,"Madison","FL","32340","850.973.6878",null,"x"]
["Eurofins Marathon","3980 Overseas Hwy",null,"Marathon","FL","33050","305.743.8598",null,"x"]
["Eurofins Michigan","38855 Hills Tech Dr","Suite #600","Farmington Hills","MI","48331","810.229.2763",null,"x"]
["Eurofins Midland","1211 W Florida Ave.",null,"Midland","TX","79701","432.704.5440",null,"x"]
["Eurofins Milwaukee Service Center","4125 N. 124th Street","Suite F (rear)","Brookfield","WI","53005-1837","262.202.5955",null,"x"]
["Eurofins Minneapolis Service Center","7600 West 27th St","Unit 209","St. Louis Park","MN","55426-3100","952.922.2777","","x"]
["Eurofins Mobile Service Center","826 Lakeside Drive","Suite D","Mobile","AL","36693-5118","251.895.3668",null,"x"]
["Eurofins North Conway Service Center","2541 White Mountain Hwy","Unit 7A","North Conway","NH","03860","603.447.4826",null,"x"]
["Eurofins Northwest Chicago Service Center","453 N. York Street","","Elmhurst","IL","60126-2003","630.758.0262","","x"]
["Eurofins Northwest Indiana Service Center","1581 East 93rd Avenue","","Merrillville","IN","46410-6483","219.252.7570","","x"]
["Eurofins Omaha Service Center","8410 K Street","Suite 9","Omaha","NE","68127-1634","402.218.1844",null,"x"]
["Eurofins Orlando","481 Newburyport Ave.",null,"Altamonte Springs","FL","32701","407.339.5984",null,"x"]
["Eurofins Pensacola","3355 McLemore St","","Pensacola","FL","32514-7045","850.474.1001","850.474.4789","x"]
["Eurofins Philadelphia","795 Horsham Road",null,"Horsham","PA","19044","215.355.3900",null,"x"]
["Eurofins Phoenix","4625 East Cotton Center Boulevard","Suite 189","Phoenix","AZ","85040-4807","602.437.3340","602.454.9303","x"]
["Eurofins Pittsburgh","301 Alpha Drive","RIDC Park","Pittsburgh","PA","15238-2907","412.963.7058","412.963.2468","x"]
["Eurofins Portland (Maine)","334 Forest Ave","Unit D","Portland","ME","04101","207.846.6569",null,"x"]
["Eurofins Portsmouth","124 Heritage Ave.","#16","Portsmouth","NH","03801","603.436.2001",null,"x"]
["Eurofins Port St. Lucie","571 NW Mercantile Place",null,"Port St. Lucie","FL","34986","772.343.8006",null,"x"]
["Eurofins Raleigh","104 Woodwinds Industrial Court","Suite A ","Cary","NC","27511","919.467.3090",null,"x"]
["Eurofins Rhode Island","646 Camp Avenue","","North Kingston","RI","02852","413.789.9018",null,"x"]
["Eurofins Rochester Service Center","125 White Spruce Blvd.","Suite 500","Rochester","NY","14623-1607","716.329.2570",null,"x"]
["Eurofins Sacramento","880 Riverside Parkway","","West Sacramento","CA","95605-1500","916.373.5600","303.467.7248","x"]
["Eurofins Sacramento Service Center","880 Riverside Parkway","Room 203","West Sacramento","CA","95605-1500","916.374.4316",null,"x"]
["Eurofins Salt Lake City Service Center","2117 South 3600 West ","Suite B","West Valley City","UT","84119","385.460.1622",null,"x"]
["Eurofins San Antonio","1610 S. Laredo St.",null,"San Antonio","TX","78207","210.229.9920","","x"]
["Eurofins Savannah","7001 Chatham Center Dr.","Suite 600","Savannah","GA","31405","912.354.7858",null,"x"]
["Eurofins Seattle","5755 8th Street East","","Tacoma","WA","98424-1317","253.922.2310","253.922.5047","x"]
["Eurofins South Bend","110 S. Hill St.",null,"South Bend","IN","46617","574.233.4777",null,"x"]
["Eurofins South Jersey Service Center","3000 Lincoln Drive East","Suite A","Marlton","NJ","08053-1500","856.334.1030","","x"]
["Eurofins Specialty Metals Testing","5755 8th Street East","","Tacoma","WA","98424-1317","253.922.2310","253.922.5047","x"]
["Eurofins Spokane","11922 E 1st Avenue","","Spokane","WA","99206-5302","509.924.9200","509.924.9290","x"]
["Eurofins State College Service Center","1400 Foxhill Road","Suite 400","State College","PA","16803","717.415.7291",null,"x"]
["Eurofins St. Louis","13715 Rider Trail North","","Earth City","MO","63045-1205","314.298.8566","314.298.8757","x"]
["Eurofins Syracuse Service Center","118 Boss Rd","","Syracuse","NY","13211-2217","315.412.5142","","x"]
["Eurofins Tallahassee Service Center","1519 Capital Circle NE","Suite 11","Tallahassee","FL","32308-6272","850.556.4296",null,"x"]
["Eurofins Tampa","6712 Benjamin Road","Suite 100","Tampa","FL","33634-4403","813.885.7427","813.885.7049","x"]
["Eurofins TestOil","20338 Progress Drive",null,"Strongsville","OH","44149","216.251.2510",null,"x"]
["Eurofins Tustin","2841 Dow Ave.","Suite 100","Tustin","CA","92780-7211","714.895.5494",null,"x",null,"Folsom","CA","95630","800.985.5955"]
["Eurofins VA Beach/Hampton Roads Srvc. Ctr.","1244 Executive Boulevard ","Suite 114-B","Chesapeake","VA","23320-2878","717.415.7291",null,"x"]
["Eurofins Ventura Service Center","4882 McGrath St.","#280","Ventura","CA","93003","657.659.8093",null,"x"]
["Eurofins Vineland","1835 W. Landis Ave",null,"Vineland","NJ","08360","215.375.0603",null,"x"]
["Eurofins Washington","1620 S Walnut St.",null,"Burlington","WA","98233","360.757.1400",null,"x"]
["Eurofins West Springfield Service Center","126 Myron Street","","West Springfield","MA","01089-1420","413.789.9018",null,"x"]
["Eurofins West Virginia Service Center","8000 Jerry Dove Drive","Suite 108","Bridgeport","WV","26330","724.882.2240",null,"x"]
["Eurofins Wilsonville","9725 SW Commerce Circle","Suite A2","Wilsonville","OR",97070,"503.682.7802",null,"x"]
["Eurofins Wind Gap Service Center","501 E. Moorestown Rd.",null,"Wind Gap","PA","18091-9652","717.368.7410",null,"x"]
["Eurofins Yakima Service Center","1008 W Ahtanum Rd.","Suite 9","Yakima","WA","98903-1897","509.490.4382",null,"x"]