{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["NextSeq","MiSeq-SampleSheet","Password_ForSheet","BarcodeKey"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"NextSeq","index":0,"n_rows":276,"n_cols":16,"rows_kept":276,"cut":false,"hidden":false,"merged":[]}
["[Header]"]
["IEMFileVersion",5]
["Experiment Name","NextSeqEnter"]
["Date",{"$f":"TEXT(TODAY(), \"yyyy-mm-dd\")","v":"2023-07-28"}]
["Workflow","GenerateFASTQ"]
["Application","NextSeq FASTQ Only"]
["Instrument Type","NextSeq/MiniSeq"]
["Assay","TruSeq Amplicon"]
["Description","EnterNameHere"]
["Chemistry","Amplicon"]
[]
["[Reads]"]
[151]
[151]
[]
["[Settings]"]
["ReverseComplement",0]
[null,null,null,null,null,null,"MISEQ P501","TATAGCCT"]
["[Data]"]
["Sample_ID","Sample_Name","Sample_Plate","Sample_Well","i7_Index_ID","index","i5_Index_ID","index2","Sample_Project","Description","Check Sample_ID uniqueness","Check_index_uniqueness"]
[null,{"$f":"IF(A21=\"\",\"\",A21)","v":""},null,null,null,{"$f":"IF(E21=\"\", \"\",VLOOKUP(E21, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G21=\"\", \"\", VLOOKUP(G21,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,{"$f":"IF(AND(A21=\"\",E21=\"\",G21=\"\"), \"\", IF(AND(A21=\"\", OR(E21<>\"\", G21<>\"\")), \"EnterSmpl_ID\",COUNTIF(A$20:A$104877,A21)))","v":""},{"$f":"IF(OR(ISERROR(F21)=TRUE, ISERROR(H21)= TRUE), \"Error\", IF(AND(F21=\"\",H21=\"\", A21=\"\"), \"\", IF(OR(F21=\"\", H21=\"\"), \"inComplete\", COUNTIFS(F:F,F21, H:H,H21))))","v":""}]
[null,{"$f":"IF(A22=\"\",\"\",A22)","v":""},null,null,null,{"$f":"IF(E22=\"\", \"\",VLOOKUP(E22, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G22=\"\", \"\", VLOOKUP(G22,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",{"$f":"IF(OR(ISERROR(F22)=TRUE, ISERROR(H22)= TRUE), \"Error\", IF(AND(F22=\"\",H22=\"\", A22=\"\"), \"\", IF(OR(F22=\"\", H22=\"\"), \"inComplete\", COUNTIFS(F:F,F22, H:H,H22))))","v":""}]
[null,"",null,null,null,{"$f":"IF(E23=\"\", \"\",VLOOKUP(E23, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G23=\"\", \"\", VLOOKUP(G23,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E24=\"\", \"\",VLOOKUP(E24, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G24=\"\", \"\", VLOOKUP(G24,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E25=\"\", \"\",VLOOKUP(E25, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G25=\"\", \"\", VLOOKUP(G25,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E26=\"\", \"\",VLOOKUP(E26, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G26=\"\", \"\", VLOOKUP(G26,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E27=\"\", \"\",VLOOKUP(E27, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G27=\"\", \"\", VLOOKUP(G27,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,"Instruction: "]
[null,"",null,null,null,{"$f":"IF(E28=\"\", \"\",VLOOKUP(E28, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G28=\"\", \"\", VLOOKUP(G28,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,null," - Shaded cells: user input"]
[null,"",null,null,null,{"$f":"IF(E29=\"\", \"\",VLOOKUP(E29, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G29=\"\", \"\", VLOOKUP(G29,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,null," - Run \"Check Sample_ID\" : any  Sample_IDs with illegal characters will be highlighted in RED"]
[null,"",null,null,null,{"$f":"IF(E30=\"\", \"\",VLOOKUP(E30, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G30=\"\", \"\", VLOOKUP(G30,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,null," - Remove the illegal characters from the RED Sample_IDs"]
[null,"",null,null,null,{"$f":"IF(E31=\"\", \"\",VLOOKUP(E31, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G31=\"\", \"\", VLOOKUP(G31,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,null," - Run \"ReSet Sample_ID Color\"  to reset the red Sample_IDs to black font"]
[null,"",null,null,null,{"$f":"IF(E32=\"\", \"\",VLOOKUP(E32, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G32=\"\", \"\", VLOOKUP(G32,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,null," - Re-run \"Check Sample_ID\" to confirm that the illegal characters are removed: All green"]
[null,"",null,null,null,{"$f":"IF(E33=\"\", \"\",VLOOKUP(E33, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G33=\"\", \"\", VLOOKUP(G33,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,null,"When no Red in any field:"]
[null,"",null,null,null,{"$f":"IF(E34=\"\", \"\",VLOOKUP(E34, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G34=\"\", \"\", VLOOKUP(G34,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,null,"  - Click \"Export\" to export the .CSV file for sample sheet"]
[null,"",null,null,null,{"$f":"IF(E35=\"\", \"\",VLOOKUP(E35, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G35=\"\", \"\", VLOOKUP(G35,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E36=\"\", \"\",VLOOKUP(E36, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G36=\"\", \"\", VLOOKUP(G36,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,"Characters allowed in the sample_ID:"]
[null,"",null,null,null,{"$f":"IF(E37=\"\", \"\",VLOOKUP(E37, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G37=\"\", \"\", VLOOKUP(G37,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,null," - Alphanumeric characters"]
[null,"",null,null,null,{"$f":"IF(E38=\"\", \"\",VLOOKUP(E38, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G38=\"\", \"\", VLOOKUP(G38,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"","",null,null,null," - Dash (-) and underscore (_)"]
[null,"",null,null,null,{"$f":"IF(E39=\"\", \"\",VLOOKUP(E39, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G39=\"\", \"\", VLOOKUP(G39,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E40=\"\", \"\",VLOOKUP(E40, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G40=\"\", \"\", VLOOKUP(G40,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E41=\"\", \"\",VLOOKUP(E41, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G41=\"\", \"\", VLOOKUP(G41,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E42=\"\", \"\",VLOOKUP(E42, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G42=\"\", \"\", VLOOKUP(G42,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E43=\"\", \"\",VLOOKUP(E43, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G43=\"\", \"\", VLOOKUP(G43,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E44=\"\", \"\",VLOOKUP(E44, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G44=\"\", \"\", VLOOKUP(G44,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E45=\"\", \"\",VLOOKUP(E45, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G45=\"\", \"\", VLOOKUP(G45,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E46=\"\", \"\",VLOOKUP(E46, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G46=\"\", \"\", VLOOKUP(G46,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E47=\"\", \"\",VLOOKUP(E47, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G47=\"\", \"\", VLOOKUP(G47,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E48=\"\", \"\",VLOOKUP(E48, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G48=\"\", \"\", VLOOKUP(G48,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E49=\"\", \"\",VLOOKUP(E49, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G49=\"\", \"\", VLOOKUP(G49,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E50=\"\", \"\",VLOOKUP(E50, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G50=\"\", \"\", VLOOKUP(G50,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E51=\"\", \"\",VLOOKUP(E51, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G51=\"\", \"\", VLOOKUP(G51,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E52=\"\", \"\",VLOOKUP(E52, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G52=\"\", \"\", VLOOKUP(G52,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E53=\"\", \"\",VLOOKUP(E53, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G53=\"\", \"\", VLOOKUP(G53,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E54=\"\", \"\",VLOOKUP(E54, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G54=\"\", \"\", VLOOKUP(G54,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E55=\"\", \"\",VLOOKUP(E55, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G55=\"\", \"\", VLOOKUP(G55,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E56=\"\", \"\",VLOOKUP(E56, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G56=\"\", \"\", VLOOKUP(G56,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E57=\"\", \"\",VLOOKUP(E57, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G57=\"\", \"\", VLOOKUP(G57,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E58=\"\", \"\",VLOOKUP(E58, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G58=\"\", \"\", VLOOKUP(G58,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E59=\"\", \"\",VLOOKUP(E59, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G59=\"\", \"\", VLOOKUP(G59,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E60=\"\", \"\",VLOOKUP(E60, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G60=\"\", \"\", VLOOKUP(G60,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E61=\"\", \"\",VLOOKUP(E61, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G61=\"\", \"\", VLOOKUP(G61,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E62=\"\", \"\",VLOOKUP(E62, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G62=\"\", \"\", VLOOKUP(G62,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E63=\"\", \"\",VLOOKUP(E63, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G63=\"\", \"\", VLOOKUP(G63,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E64=\"\", \"\",VLOOKUP(E64, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G64=\"\", \"\", VLOOKUP(G64,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E65=\"\", \"\",VLOOKUP(E65, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G65=\"\", \"\", VLOOKUP(G65,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E66=\"\", \"\",VLOOKUP(E66, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G66=\"\", \"\", VLOOKUP(G66,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E67=\"\", \"\",VLOOKUP(E67, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G67=\"\", \"\", VLOOKUP(G67,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E68=\"\", \"\",VLOOKUP(E68, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G68=\"\", \"\", VLOOKUP(G68,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E69=\"\", \"\",VLOOKUP(E69, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G69=\"\", \"\", VLOOKUP(G69,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E70=\"\", \"\",VLOOKUP(E70, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G70=\"\", \"\", VLOOKUP(G70,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E71=\"\", \"\",VLOOKUP(E71, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G71=\"\", \"\", VLOOKUP(G71,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E72=\"\", \"\",VLOOKUP(E72, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G72=\"\", \"\", VLOOKUP(G72,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E73=\"\", \"\",VLOOKUP(E73, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G73=\"\", \"\", VLOOKUP(G73,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E74=\"\", \"\",VLOOKUP(E74, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G74=\"\", \"\", VLOOKUP(G74,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E75=\"\", \"\",VLOOKUP(E75, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G75=\"\", \"\", VLOOKUP(G75,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E76=\"\", \"\",VLOOKUP(E76, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G76=\"\", \"\", VLOOKUP(G76,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E77=\"\", \"\",VLOOKUP(E77, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G77=\"\", \"\", VLOOKUP(G77,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E78=\"\", \"\",VLOOKUP(E78, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G78=\"\", \"\", VLOOKUP(G78,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E79=\"\", \"\",VLOOKUP(E79, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G79=\"\", \"\", VLOOKUP(G79,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E80=\"\", \"\",VLOOKUP(E80, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G80=\"\", \"\", VLOOKUP(G80,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E81=\"\", \"\",VLOOKUP(E81, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G81=\"\", \"\", VLOOKUP(G81,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E82=\"\", \"\",VLOOKUP(E82, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G82=\"\", \"\", VLOOKUP(G82,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E83=\"\", \"\",VLOOKUP(E83, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G83=\"\", \"\", VLOOKUP(G83,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E84=\"\", \"\",VLOOKUP(E84, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G84=\"\", \"\", VLOOKUP(G84,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E85=\"\", \"\",VLOOKUP(E85, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G85=\"\", \"\", VLOOKUP(G85,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,{"$f":"IF(AND(A85=\"\",E85=\"\",G85=\"\"), \"\", IF(AND(A85=\"\", OR(E85<>\"\", G85<>\"\")), \"EnterSmpl_ID\",COUNTIF(A$20:A$104877,A85)))","v":""},""]
[null,{"$f":"IF(A86=\"\",\"\",A86)","v":""},null,null,null,{"$f":"IF(E86=\"\", \"\",VLOOKUP(E86, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G86=\"\", \"\", VLOOKUP(G86,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",{"$f":"IF(OR(ISERROR(F86)=TRUE, ISERROR(H86)= TRUE), \"Error\", IF(AND(F86=\"\",H86=\"\", A86=\"\"), \"\", IF(OR(F86=\"\", H86=\"\"), \"inComplete\", COUNTIFS(F:F,F86, H:H,H86))))","v":""}]
[null,"",null,null,null,{"$f":"IF(E87=\"\", \"\",VLOOKUP(E87, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G87=\"\", \"\", VLOOKUP(G87,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E88=\"\", \"\",VLOOKUP(E88, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G88=\"\", \"\", VLOOKUP(G88,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E89=\"\", \"\",VLOOKUP(E89, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G89=\"\", \"\", VLOOKUP(G89,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E90=\"\", \"\",VLOOKUP(E90, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G90=\"\", \"\", VLOOKUP(G90,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E91=\"\", \"\",VLOOKUP(E91, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G91=\"\", \"\", VLOOKUP(G91,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E92=\"\", \"\",VLOOKUP(E92, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G92=\"\", \"\", VLOOKUP(G92,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E93=\"\", \"\",VLOOKUP(E93, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G93=\"\", \"\", VLOOKUP(G93,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E94=\"\", \"\",VLOOKUP(E94, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G94=\"\", \"\", VLOOKUP(G94,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E95=\"\", \"\",VLOOKUP(E95, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G95=\"\", \"\", VLOOKUP(G95,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E96=\"\", \"\",VLOOKUP(E96, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G96=\"\", \"\", VLOOKUP(G96,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E97=\"\", \"\",VLOOKUP(E97, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G97=\"\", \"\", VLOOKUP(G97,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E98=\"\", \"\",VLOOKUP(E98, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G98=\"\", \"\", VLOOKUP(G98,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E99=\"\", \"\",VLOOKUP(E99, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G99=\"\", \"\", VLOOKUP(G99,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E100=\"\", \"\",VLOOKUP(E100, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G100=\"\", \"\", VLOOKUP(G100,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E101=\"\", \"\",VLOOKUP(E101, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G101=\"\", \"\", VLOOKUP(G101,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E102=\"\", \"\",VLOOKUP(E102, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G102=\"\", \"\", VLOOKUP(G102,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E103=\"\", \"\",VLOOKUP(E103, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G103=\"\", \"\", VLOOKUP(G103,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E104=\"\", \"\",VLOOKUP(E104, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G104=\"\", \"\", VLOOKUP(G104,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E105=\"\", \"\",VLOOKUP(E105, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G105=\"\", \"\", VLOOKUP(G105,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E106=\"\", \"\",VLOOKUP(E106, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G106=\"\", \"\", VLOOKUP(G106,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E107=\"\", \"\",VLOOKUP(E107, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G107=\"\", \"\", VLOOKUP(G107,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E108=\"\", \"\",VLOOKUP(E108, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G108=\"\", \"\", VLOOKUP(G108,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E109=\"\", \"\",VLOOKUP(E109, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G109=\"\", \"\", VLOOKUP(G109,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E110=\"\", \"\",VLOOKUP(E110, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G110=\"\", \"\", VLOOKUP(G110,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E111=\"\", \"\",VLOOKUP(E111, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G111=\"\", \"\", VLOOKUP(G111,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E112=\"\", \"\",VLOOKUP(E112, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G112=\"\", \"\", VLOOKUP(G112,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E113=\"\", \"\",VLOOKUP(E113, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G113=\"\", \"\", VLOOKUP(G113,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E114=\"\", \"\",VLOOKUP(E114, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G114=\"\", \"\", VLOOKUP(G114,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E115=\"\", \"\",VLOOKUP(E115, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G115=\"\", \"\", VLOOKUP(G115,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E116=\"\", \"\",VLOOKUP(E116, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G116=\"\", \"\", VLOOKUP(G116,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E117=\"\", \"\",VLOOKUP(E117, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G117=\"\", \"\", VLOOKUP(G117,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E118=\"\", \"\",VLOOKUP(E118, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G118=\"\", \"\", VLOOKUP(G118,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E119=\"\", \"\",VLOOKUP(E119, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G119=\"\", \"\", VLOOKUP(G119,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E120=\"\", \"\",VLOOKUP(E120, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G120=\"\", \"\", VLOOKUP(G120,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E121=\"\", \"\",VLOOKUP(E121, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G121=\"\", \"\", VLOOKUP(G121,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E122=\"\", \"\",VLOOKUP(E122, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G122=\"\", \"\", VLOOKUP(G122,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E123=\"\", \"\",VLOOKUP(E123, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G123=\"\", \"\", VLOOKUP(G123,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E124=\"\", \"\",VLOOKUP(E124, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G124=\"\", \"\", VLOOKUP(G124,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E125=\"\", \"\",VLOOKUP(E125, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G125=\"\", \"\", VLOOKUP(G125,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E126=\"\", \"\",VLOOKUP(E126, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G126=\"\", \"\", VLOOKUP(G126,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E127=\"\", \"\",VLOOKUP(E127, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G127=\"\", \"\", VLOOKUP(G127,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E128=\"\", \"\",VLOOKUP(E128, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G128=\"\", \"\", VLOOKUP(G128,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E129=\"\", \"\",VLOOKUP(E129, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G129=\"\", \"\", VLOOKUP(G129,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E130=\"\", \"\",VLOOKUP(E130, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G130=\"\", \"\", VLOOKUP(G130,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E131=\"\", \"\",VLOOKUP(E131, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G131=\"\", \"\", VLOOKUP(G131,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E132=\"\", \"\",VLOOKUP(E132, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G132=\"\", \"\", VLOOKUP(G132,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E133=\"\", \"\",VLOOKUP(E133, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G133=\"\", \"\", VLOOKUP(G133,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E134=\"\", \"\",VLOOKUP(E134, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G134=\"\", \"\", VLOOKUP(G134,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E135=\"\", \"\",VLOOKUP(E135, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G135=\"\", \"\", VLOOKUP(G135,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E136=\"\", \"\",VLOOKUP(E136, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G136=\"\", \"\", VLOOKUP(G136,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E137=\"\", \"\",VLOOKUP(E137, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G137=\"\", \"\", VLOOKUP(G137,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E138=\"\", \"\",VLOOKUP(E138, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G138=\"\", \"\", VLOOKUP(G138,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E139=\"\", \"\",VLOOKUP(E139, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G139=\"\", \"\", VLOOKUP(G139,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E140=\"\", \"\",VLOOKUP(E140, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G140=\"\", \"\", VLOOKUP(G140,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E141=\"\", \"\",VLOOKUP(E141, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G141=\"\", \"\", VLOOKUP(G141,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E142=\"\", \"\",VLOOKUP(E142, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G142=\"\", \"\", VLOOKUP(G142,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E143=\"\", \"\",VLOOKUP(E143, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G143=\"\", \"\", VLOOKUP(G143,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E144=\"\", \"\",VLOOKUP(E144, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G144=\"\", \"\", VLOOKUP(G144,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E145=\"\", \"\",VLOOKUP(E145, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G145=\"\", \"\", VLOOKUP(G145,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E146=\"\", \"\",VLOOKUP(E146, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G146=\"\", \"\", VLOOKUP(G146,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E147=\"\", \"\",VLOOKUP(E147, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G147=\"\", \"\", VLOOKUP(G147,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E148=\"\", \"\",VLOOKUP(E148, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G148=\"\", \"\", VLOOKUP(G148,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E149=\"\", \"\",VLOOKUP(E149, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G149=\"\", \"\", VLOOKUP(G149,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,{"$f":"IF(AND(A149=\"\",E149=\"\",G149=\"\"), \"\", IF(AND(A149=\"\", OR(E149<>\"\", G149<>\"\")), \"EnterSmpl_ID\",COUNTIF(A$20:A$104877,A149)))","v":""},""]
[null,{"$f":"IF(A150=\"\",\"\",A150)","v":""},null,null,null,{"$f":"IF(E150=\"\", \"\",VLOOKUP(E150, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G150=\"\", \"\", VLOOKUP(G150,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",{"$f":"IF(OR(ISERROR(F150)=TRUE, ISERROR(H150)= TRUE), \"Error\", IF(AND(F150=\"\",H150=\"\", A150=\"\"), \"\", IF(OR(F150=\"\", H150=\"\"), \"inComplete\", COUNTIFS(F:F,F150, H:H,H150))))","v":""}]
[null,"",null,null,null,{"$f":"IF(E151=\"\", \"\",VLOOKUP(E151, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G151=\"\", \"\", VLOOKUP(G151,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E152=\"\", \"\",VLOOKUP(E152, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G152=\"\", \"\", VLOOKUP(G152,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E153=\"\", \"\",VLOOKUP(E153, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G153=\"\", \"\", VLOOKUP(G153,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E154=\"\", \"\",VLOOKUP(E154, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G154=\"\", \"\", VLOOKUP(G154,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E155=\"\", \"\",VLOOKUP(E155, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G155=\"\", \"\", VLOOKUP(G155,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E156=\"\", \"\",VLOOKUP(E156, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G156=\"\", \"\", VLOOKUP(G156,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E157=\"\", \"\",VLOOKUP(E157, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G157=\"\", \"\", VLOOKUP(G157,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E158=\"\", \"\",VLOOKUP(E158, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G158=\"\", \"\", VLOOKUP(G158,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E159=\"\", \"\",VLOOKUP(E159, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G159=\"\", \"\", VLOOKUP(G159,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E160=\"\", \"\",VLOOKUP(E160, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G160=\"\", \"\", VLOOKUP(G160,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E161=\"\", \"\",VLOOKUP(E161, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G161=\"\", \"\", VLOOKUP(G161,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E162=\"\", \"\",VLOOKUP(E162, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G162=\"\", \"\", VLOOKUP(G162,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E163=\"\", \"\",VLOOKUP(E163, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G163=\"\", \"\", VLOOKUP(G163,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E164=\"\", \"\",VLOOKUP(E164, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G164=\"\", \"\", VLOOKUP(G164,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E165=\"\", \"\",VLOOKUP(E165, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G165=\"\", \"\", VLOOKUP(G165,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E166=\"\", \"\",VLOOKUP(E166, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G166=\"\", \"\", VLOOKUP(G166,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E167=\"\", \"\",VLOOKUP(E167, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G167=\"\", \"\", VLOOKUP(G167,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E168=\"\", \"\",VLOOKUP(E168, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G168=\"\", \"\", VLOOKUP(G168,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E169=\"\", \"\",VLOOKUP(E169, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G169=\"\", \"\", VLOOKUP(G169,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E170=\"\", \"\",VLOOKUP(E170, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G170=\"\", \"\", VLOOKUP(G170,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E171=\"\", \"\",VLOOKUP(E171, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G171=\"\", \"\", VLOOKUP(G171,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E172=\"\", \"\",VLOOKUP(E172, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G172=\"\", \"\", VLOOKUP(G172,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E173=\"\", \"\",VLOOKUP(E173, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G173=\"\", \"\", VLOOKUP(G173,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E174=\"\", \"\",VLOOKUP(E174, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G174=\"\", \"\", VLOOKUP(G174,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E175=\"\", \"\",VLOOKUP(E175, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G175=\"\", \"\", VLOOKUP(G175,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E176=\"\", \"\",VLOOKUP(E176, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G176=\"\", \"\", VLOOKUP(G176,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E177=\"\", \"\",VLOOKUP(E177, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G177=\"\", \"\", VLOOKUP(G177,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E178=\"\", \"\",VLOOKUP(E178, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G178=\"\", \"\", VLOOKUP(G178,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E179=\"\", \"\",VLOOKUP(E179, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G179=\"\", \"\", VLOOKUP(G179,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E180=\"\", \"\",VLOOKUP(E180, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G180=\"\", \"\", VLOOKUP(G180,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E181=\"\", \"\",VLOOKUP(E181, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G181=\"\", \"\", VLOOKUP(G181,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E182=\"\", \"\",VLOOKUP(E182, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G182=\"\", \"\", VLOOKUP(G182,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E183=\"\", \"\",VLOOKUP(E183, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G183=\"\", \"\", VLOOKUP(G183,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E184=\"\", \"\",VLOOKUP(E184, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G184=\"\", \"\", VLOOKUP(G184,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E185=\"\", \"\",VLOOKUP(E185, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G185=\"\", \"\", VLOOKUP(G185,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E186=\"\", \"\",VLOOKUP(E186, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G186=\"\", \"\", VLOOKUP(G186,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E187=\"\", \"\",VLOOKUP(E187, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G187=\"\", \"\", VLOOKUP(G187,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E188=\"\", \"\",VLOOKUP(E188, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G188=\"\", \"\", VLOOKUP(G188,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E189=\"\", \"\",VLOOKUP(E189, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G189=\"\", \"\", VLOOKUP(G189,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E190=\"\", \"\",VLOOKUP(E190, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G190=\"\", \"\", VLOOKUP(G190,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E191=\"\", \"\",VLOOKUP(E191, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G191=\"\", \"\", VLOOKUP(G191,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E192=\"\", \"\",VLOOKUP(E192, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G192=\"\", \"\", VLOOKUP(G192,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E193=\"\", \"\",VLOOKUP(E193, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G193=\"\", \"\", VLOOKUP(G193,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E194=\"\", \"\",VLOOKUP(E194, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G194=\"\", \"\", VLOOKUP(G194,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E195=\"\", \"\",VLOOKUP(E195, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G195=\"\", \"\", VLOOKUP(G195,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E196=\"\", \"\",VLOOKUP(E196, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G196=\"\", \"\", VLOOKUP(G196,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E197=\"\", \"\",VLOOKUP(E197, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G197=\"\", \"\", VLOOKUP(G197,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E198=\"\", \"\",VLOOKUP(E198, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G198=\"\", \"\", VLOOKUP(G198,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E199=\"\", \"\",VLOOKUP(E199, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G199=\"\", \"\", VLOOKUP(G199,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E200=\"\", \"\",VLOOKUP(E200, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G200=\"\", \"\", VLOOKUP(G200,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E201=\"\", \"\",VLOOKUP(E201, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G201=\"\", \"\", VLOOKUP(G201,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E202=\"\", \"\",VLOOKUP(E202, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G202=\"\", \"\", VLOOKUP(G202,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E203=\"\", \"\",VLOOKUP(E203, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G203=\"\", \"\", VLOOKUP(G203,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E204=\"\", \"\",VLOOKUP(E204, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G204=\"\", \"\", VLOOKUP(G204,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E205=\"\", \"\",VLOOKUP(E205, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G205=\"\", \"\", VLOOKUP(G205,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E206=\"\", \"\",VLOOKUP(E206, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G206=\"\", \"\", VLOOKUP(G206,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E207=\"\", \"\",VLOOKUP(E207, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G207=\"\", \"\", VLOOKUP(G207,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E208=\"\", \"\",VLOOKUP(E208, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G208=\"\", \"\", VLOOKUP(G208,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E209=\"\", \"\",VLOOKUP(E209, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G209=\"\", \"\", VLOOKUP(G209,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E210=\"\", \"\",VLOOKUP(E210, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G210=\"\", \"\", VLOOKUP(G210,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E211=\"\", \"\",VLOOKUP(E211, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G211=\"\", \"\", VLOOKUP(G211,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E212=\"\", \"\",VLOOKUP(E212, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G212=\"\", \"\", VLOOKUP(G212,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E213=\"\", \"\",VLOOKUP(E213, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G213=\"\", \"\", VLOOKUP(G213,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,{"$f":"IF(AND(A213=\"\",E213=\"\",G213=\"\"), \"\", IF(AND(A213=\"\", OR(E213<>\"\", G213<>\"\")), \"EnterSmpl_ID\",COUNTIF(A$20:A$104877,A213)))","v":""},""]
[null,{"$f":"IF(A214=\"\",\"\",A214)","v":""},null,null,null,{"$f":"IF(E214=\"\", \"\",VLOOKUP(E214, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G214=\"\", \"\", VLOOKUP(G214,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",{"$f":"IF(OR(ISERROR(F214)=TRUE, ISERROR(H214)= TRUE), \"Error\", IF(AND(F214=\"\",H214=\"\", A214=\"\"), \"\", IF(OR(F214=\"\", H214=\"\"), \"inComplete\", COUNTIFS(F:F,F214, H:H,H214))))","v":""}]
[null,"",null,null,null,{"$f":"IF(E215=\"\", \"\",VLOOKUP(E215, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G215=\"\", \"\", VLOOKUP(G215,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E216=\"\", \"\",VLOOKUP(E216, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G216=\"\", \"\", VLOOKUP(G216,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E217=\"\", \"\",VLOOKUP(E217, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G217=\"\", \"\", VLOOKUP(G217,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E218=\"\", \"\",VLOOKUP(E218, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G218=\"\", \"\", VLOOKUP(G218,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E219=\"\", \"\",VLOOKUP(E219, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G219=\"\", \"\", VLOOKUP(G219,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E220=\"\", \"\",VLOOKUP(E220, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G220=\"\", \"\", VLOOKUP(G220,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E221=\"\", \"\",VLOOKUP(E221, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G221=\"\", \"\", VLOOKUP(G221,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E222=\"\", \"\",VLOOKUP(E222, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G222=\"\", \"\", VLOOKUP(G222,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E223=\"\", \"\",VLOOKUP(E223, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G223=\"\", \"\", VLOOKUP(G223,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E224=\"\", \"\",VLOOKUP(E224, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G224=\"\", \"\", VLOOKUP(G224,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E225=\"\", \"\",VLOOKUP(E225, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G225=\"\", \"\", VLOOKUP(G225,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E226=\"\", \"\",VLOOKUP(E226, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G226=\"\", \"\", VLOOKUP(G226,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E227=\"\", \"\",VLOOKUP(E227, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G227=\"\", \"\", VLOOKUP(G227,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E228=\"\", \"\",VLOOKUP(E228, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G228=\"\", \"\", VLOOKUP(G228,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E229=\"\", \"\",VLOOKUP(E229, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G229=\"\", \"\", VLOOKUP(G229,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E230=\"\", \"\",VLOOKUP(E230, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G230=\"\", \"\", VLOOKUP(G230,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E231=\"\", \"\",VLOOKUP(E231, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G231=\"\", \"\", VLOOKUP(G231,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E232=\"\", \"\",VLOOKUP(E232, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G232=\"\", \"\", VLOOKUP(G232,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E233=\"\", \"\",VLOOKUP(E233, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G233=\"\", \"\", VLOOKUP(G233,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E234=\"\", \"\",VLOOKUP(E234, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G234=\"\", \"\", VLOOKUP(G234,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E235=\"\", \"\",VLOOKUP(E235, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G235=\"\", \"\", VLOOKUP(G235,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E236=\"\", \"\",VLOOKUP(E236, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G236=\"\", \"\", VLOOKUP(G236,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E237=\"\", \"\",VLOOKUP(E237, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G237=\"\", \"\", VLOOKUP(G237,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E238=\"\", \"\",VLOOKUP(E238, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G238=\"\", \"\", VLOOKUP(G238,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E239=\"\", \"\",VLOOKUP(E239, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G239=\"\", \"\", VLOOKUP(G239,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E240=\"\", \"\",VLOOKUP(E240, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G240=\"\", \"\", VLOOKUP(G240,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E241=\"\", \"\",VLOOKUP(E241, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G241=\"\", \"\", VLOOKUP(G241,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E242=\"\", \"\",VLOOKUP(E242, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G242=\"\", \"\", VLOOKUP(G242,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E243=\"\", \"\",VLOOKUP(E243, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G243=\"\", \"\", VLOOKUP(G243,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E244=\"\", \"\",VLOOKUP(E244, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G244=\"\", \"\", VLOOKUP(G244,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E245=\"\", \"\",VLOOKUP(E245, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G245=\"\", \"\", VLOOKUP(G245,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E246=\"\", \"\",VLOOKUP(E246, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G246=\"\", \"\", VLOOKUP(G246,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E247=\"\", \"\",VLOOKUP(E247, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G247=\"\", \"\", VLOOKUP(G247,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E248=\"\", \"\",VLOOKUP(E248, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G248=\"\", \"\", VLOOKUP(G248,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E249=\"\", \"\",VLOOKUP(E249, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G249=\"\", \"\", VLOOKUP(G249,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E250=\"\", \"\",VLOOKUP(E250, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G250=\"\", \"\", VLOOKUP(G250,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E251=\"\", \"\",VLOOKUP(E251, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G251=\"\", \"\", VLOOKUP(G251,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E252=\"\", \"\",VLOOKUP(E252, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G252=\"\", \"\", VLOOKUP(G252,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E253=\"\", \"\",VLOOKUP(E253, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G253=\"\", \"\", VLOOKUP(G253,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E254=\"\", \"\",VLOOKUP(E254, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G254=\"\", \"\", VLOOKUP(G254,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E255=\"\", \"\",VLOOKUP(E255, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G255=\"\", \"\", VLOOKUP(G255,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E256=\"\", \"\",VLOOKUP(E256, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G256=\"\", \"\", VLOOKUP(G256,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E257=\"\", \"\",VLOOKUP(E257, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G257=\"\", \"\", VLOOKUP(G257,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E258=\"\", \"\",VLOOKUP(E258, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G258=\"\", \"\", VLOOKUP(G258,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E259=\"\", \"\",VLOOKUP(E259, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G259=\"\", \"\", VLOOKUP(G259,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E260=\"\", \"\",VLOOKUP(E260, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G260=\"\", \"\", VLOOKUP(G260,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E261=\"\", \"\",VLOOKUP(E261, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G261=\"\", \"\", VLOOKUP(G261,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E262=\"\", \"\",VLOOKUP(E262, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G262=\"\", \"\", VLOOKUP(G262,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E263=\"\", \"\",VLOOKUP(E263, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G263=\"\", \"\", VLOOKUP(G263,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E264=\"\", \"\",VLOOKUP(E264, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G264=\"\", \"\", VLOOKUP(G264,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E265=\"\", \"\",VLOOKUP(E265, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G265=\"\", \"\", VLOOKUP(G265,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E266=\"\", \"\",VLOOKUP(E266, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G266=\"\", \"\", VLOOKUP(G266,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E267=\"\", \"\",VLOOKUP(E267, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G267=\"\", \"\", VLOOKUP(G267,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E268=\"\", \"\",VLOOKUP(E268, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G268=\"\", \"\", VLOOKUP(G268,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E269=\"\", \"\",VLOOKUP(E269, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G269=\"\", \"\", VLOOKUP(G269,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E270=\"\", \"\",VLOOKUP(E270, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G270=\"\", \"\", VLOOKUP(G270,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E271=\"\", \"\",VLOOKUP(E271, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G271=\"\", \"\", VLOOKUP(G271,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E272=\"\", \"\",VLOOKUP(E272, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G272=\"\", \"\", VLOOKUP(G272,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E273=\"\", \"\",VLOOKUP(E273, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G273=\"\", \"\", VLOOKUP(G273,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E274=\"\", \"\",VLOOKUP(E274, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G274=\"\", \"\", VLOOKUP(G274,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E275=\"\", \"\",VLOOKUP(E275, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G275=\"\", \"\", VLOOKUP(G275,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E276=\"\", \"\",VLOOKUP(E276, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G276=\"\", \"\", VLOOKUP(G276,BarcodeKey!H:J, 3, FALSE))","v":""},null,null,"",""]

{"sheet":"MiSeq-SampleSheet","index":1,"n_rows":276,"n_cols":16,"rows_kept":276,"cut":false,"hidden":false,"merged":[]}
["[Header]"]
["IEMFileVersion",4]
["Investigator Name"]
["Experiment Name"]
["Date",{"$f":"TEXT(TODAY(), \"yyyy-mm-dd\")","v":"2023-07-28"}]
["Workflow","GenerateFASTQ"]
["Application","FASTQ Only"]
["Assay","TruSeq Amplicon"]
["Description","EnterNameHere"]
["Chemistry","Amplicon"]
[]
["[Reads]"]
[151]
[151]
[]
["[Settings]"]
["ReverseComplement",0]
[]
["[Data]"]
["Sample_ID","Sample_Name","Sample_Plate","Sample_Well","i7_Index_ID","index","i5_Index_ID","index2","Sample_Project","Description","Check Sample_ID uniqueness","Check_index_uniqueness"]
[null,{"$f":"IF(A21=\"\",\"\",A21)","v":""},null,null,null,{"$f":"IF(E21=\"\", \"\",VLOOKUP(E21, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G21=\"\", \"\", VLOOKUP(G21,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,{"$f":"IF(AND(A21=\"\",E21=\"\",G21=\"\"), \"\", IF(AND(A21=\"\", OR(E21<>\"\", G21<>\"\")), \"EnterSmpl_ID\",COUNTIF(A$20:A$104877,A21)))","v":""},{"$f":"IF(OR(ISERROR(F21)=TRUE, ISERROR(H21)= TRUE), \"Error\", IF(AND(F21=\"\",H21=\"\", A21=\"\"), \"\", IF(OR(F21=\"\", H21=\"\"), \"inComplete\", COUNTIFS(F:F,F21, H:H,H21))))","v":""}]
[null,{"$f":"IF(A22=\"\",\"\",A22)","v":""},null,null,null,{"$f":"IF(E22=\"\", \"\",VLOOKUP(E22, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G22=\"\", \"\", VLOOKUP(G22,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",{"$f":"IF(OR(ISERROR(F22)=TRUE, ISERROR(H22)= TRUE), \"Error\", IF(AND(F22=\"\",H22=\"\", A22=\"\"), \"\", IF(OR(F22=\"\", H22=\"\"), \"inComplete\", COUNTIFS(F:F,F22, H:H,H22))))","v":""}]
[null,"",null,null,null,{"$f":"IF(E23=\"\", \"\",VLOOKUP(E23, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G23=\"\", \"\", VLOOKUP(G23,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E24=\"\", \"\",VLOOKUP(E24, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G24=\"\", \"\", VLOOKUP(G24,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E25=\"\", \"\",VLOOKUP(E25, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G25=\"\", \"\", VLOOKUP(G25,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E26=\"\", \"\",VLOOKUP(E26, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G26=\"\", \"\", VLOOKUP(G26,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E27=\"\", \"\",VLOOKUP(E27, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G27=\"\", \"\", VLOOKUP(G27,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,"Instruction: "]
[null,"",null,null,null,{"$f":"IF(E28=\"\", \"\",VLOOKUP(E28, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G28=\"\", \"\", VLOOKUP(G28,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,null," - Shaded cells: user input"]
[null,"",null,null,null,{"$f":"IF(E29=\"\", \"\",VLOOKUP(E29, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G29=\"\", \"\", VLOOKUP(G29,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,null," - Run \"Check Sample_ID\" : any  Sample_IDs with illegal characters will be highlighted in RED"]
[null,"",null,null,null,{"$f":"IF(E30=\"\", \"\",VLOOKUP(E30, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G30=\"\", \"\", VLOOKUP(G30,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,null," - Remove the illegal characters from the RED Sample_IDs"]
[null,"",null,null,null,{"$f":"IF(E31=\"\", \"\",VLOOKUP(E31, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G31=\"\", \"\", VLOOKUP(G31,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,null," - Run \"ReSet Sample_ID Color\"  to reset the red Sample_IDs to black font"]
[null,"",null,null,null,{"$f":"IF(E32=\"\", \"\",VLOOKUP(E32, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G32=\"\", \"\", VLOOKUP(G32,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,null," - Re-run \"Check Sample_ID\" to confirm that the illegal characters are removed: All green"]
[null,"",null,null,null,{"$f":"IF(E33=\"\", \"\",VLOOKUP(E33, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G33=\"\", \"\", VLOOKUP(G33,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,null,"When no Red in any field:"]
[null,"",null,null,null,{"$f":"IF(E34=\"\", \"\",VLOOKUP(E34, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G34=\"\", \"\", VLOOKUP(G34,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,null,"  - Click \"Export\" to export the .CSV file for sample sheet"]
[null,"",null,null,null,{"$f":"IF(E35=\"\", \"\",VLOOKUP(E35, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G35=\"\", \"\", VLOOKUP(G35,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E36=\"\", \"\",VLOOKUP(E36, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G36=\"\", \"\", VLOOKUP(G36,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,"Characters allowed in the sample_ID:"]
[null,"",null,null,null,{"$f":"IF(E37=\"\", \"\",VLOOKUP(E37, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G37=\"\", \"\", VLOOKUP(G37,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,null," - Alphanumeric characters"]
[null,"",null,null,null,{"$f":"IF(E38=\"\", \"\",VLOOKUP(E38, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G38=\"\", \"\", VLOOKUP(G38,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"","",null,null,null," - Dash (-) and underscore (_)"]
[null,"",null,null,null,{"$f":"IF(E39=\"\", \"\",VLOOKUP(E39, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G39=\"\", \"\", VLOOKUP(G39,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E40=\"\", \"\",VLOOKUP(E40, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G40=\"\", \"\", VLOOKUP(G40,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E41=\"\", \"\",VLOOKUP(E41, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G41=\"\", \"\", VLOOKUP(G41,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E42=\"\", \"\",VLOOKUP(E42, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G42=\"\", \"\", VLOOKUP(G42,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E43=\"\", \"\",VLOOKUP(E43, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G43=\"\", \"\", VLOOKUP(G43,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E44=\"\", \"\",VLOOKUP(E44, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G44=\"\", \"\", VLOOKUP(G44,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E45=\"\", \"\",VLOOKUP(E45, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G45=\"\", \"\", VLOOKUP(G45,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E46=\"\", \"\",VLOOKUP(E46, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G46=\"\", \"\", VLOOKUP(G46,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E47=\"\", \"\",VLOOKUP(E47, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G47=\"\", \"\", VLOOKUP(G47,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E48=\"\", \"\",VLOOKUP(E48, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G48=\"\", \"\", VLOOKUP(G48,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E49=\"\", \"\",VLOOKUP(E49, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G49=\"\", \"\", VLOOKUP(G49,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E50=\"\", \"\",VLOOKUP(E50, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G50=\"\", \"\", VLOOKUP(G50,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E51=\"\", \"\",VLOOKUP(E51, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G51=\"\", \"\", VLOOKUP(G51,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E52=\"\", \"\",VLOOKUP(E52, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G52=\"\", \"\", VLOOKUP(G52,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E53=\"\", \"\",VLOOKUP(E53, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G53=\"\", \"\", VLOOKUP(G53,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E54=\"\", \"\",VLOOKUP(E54, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G54=\"\", \"\", VLOOKUP(G54,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E55=\"\", \"\",VLOOKUP(E55, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G55=\"\", \"\", VLOOKUP(G55,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E56=\"\", \"\",VLOOKUP(E56, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G56=\"\", \"\", VLOOKUP(G56,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E57=\"\", \"\",VLOOKUP(E57, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G57=\"\", \"\", VLOOKUP(G57,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E58=\"\", \"\",VLOOKUP(E58, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G58=\"\", \"\", VLOOKUP(G58,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E59=\"\", \"\",VLOOKUP(E59, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G59=\"\", \"\", VLOOKUP(G59,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E60=\"\", \"\",VLOOKUP(E60, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G60=\"\", \"\", VLOOKUP(G60,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E61=\"\", \"\",VLOOKUP(E61, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G61=\"\", \"\", VLOOKUP(G61,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E62=\"\", \"\",VLOOKUP(E62, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G62=\"\", \"\", VLOOKUP(G62,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E63=\"\", \"\",VLOOKUP(E63, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G63=\"\", \"\", VLOOKUP(G63,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E64=\"\", \"\",VLOOKUP(E64, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G64=\"\", \"\", VLOOKUP(G64,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E65=\"\", \"\",VLOOKUP(E65, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G65=\"\", \"\", VLOOKUP(G65,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E66=\"\", \"\",VLOOKUP(E66, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G66=\"\", \"\", VLOOKUP(G66,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E67=\"\", \"\",VLOOKUP(E67, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G67=\"\", \"\", VLOOKUP(G67,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E68=\"\", \"\",VLOOKUP(E68, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G68=\"\", \"\", VLOOKUP(G68,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E69=\"\", \"\",VLOOKUP(E69, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G69=\"\", \"\", VLOOKUP(G69,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E70=\"\", \"\",VLOOKUP(E70, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G70=\"\", \"\", VLOOKUP(G70,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E71=\"\", \"\",VLOOKUP(E71, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G71=\"\", \"\", VLOOKUP(G71,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E72=\"\", \"\",VLOOKUP(E72, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G72=\"\", \"\", VLOOKUP(G72,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E73=\"\", \"\",VLOOKUP(E73, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G73=\"\", \"\", VLOOKUP(G73,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E74=\"\", \"\",VLOOKUP(E74, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G74=\"\", \"\", VLOOKUP(G74,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E75=\"\", \"\",VLOOKUP(E75, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G75=\"\", \"\", VLOOKUP(G75,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E76=\"\", \"\",VLOOKUP(E76, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G76=\"\", \"\", VLOOKUP(G76,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E77=\"\", \"\",VLOOKUP(E77, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G77=\"\", \"\", VLOOKUP(G77,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E78=\"\", \"\",VLOOKUP(E78, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G78=\"\", \"\", VLOOKUP(G78,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E79=\"\", \"\",VLOOKUP(E79, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G79=\"\", \"\", VLOOKUP(G79,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E80=\"\", \"\",VLOOKUP(E80, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G80=\"\", \"\", VLOOKUP(G80,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E81=\"\", \"\",VLOOKUP(E81, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G81=\"\", \"\", VLOOKUP(G81,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E82=\"\", \"\",VLOOKUP(E82, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G82=\"\", \"\", VLOOKUP(G82,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E83=\"\", \"\",VLOOKUP(E83, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G83=\"\", \"\", VLOOKUP(G83,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E84=\"\", \"\",VLOOKUP(E84, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G84=\"\", \"\", VLOOKUP(G84,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E85=\"\", \"\",VLOOKUP(E85, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G85=\"\", \"\", VLOOKUP(G85,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,{"$f":"IF(AND(A85=\"\",E85=\"\",G85=\"\"), \"\", IF(AND(A85=\"\", OR(E85<>\"\", G85<>\"\")), \"EnterSmpl_ID\",COUNTIF(A$20:A$104877,A85)))","v":""},""]
[null,{"$f":"IF(A86=\"\",\"\",A86)","v":""},null,null,null,{"$f":"IF(E86=\"\", \"\",VLOOKUP(E86, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G86=\"\", \"\", VLOOKUP(G86,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",{"$f":"IF(OR(ISERROR(F86)=TRUE, ISERROR(H86)= TRUE), \"Error\", IF(AND(F86=\"\",H86=\"\", A86=\"\"), \"\", IF(OR(F86=\"\", H86=\"\"), \"inComplete\", COUNTIFS(F:F,F86, H:H,H86))))","v":""}]
[null,"",null,null,null,{"$f":"IF(E87=\"\", \"\",VLOOKUP(E87, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G87=\"\", \"\", VLOOKUP(G87,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E88=\"\", \"\",VLOOKUP(E88, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G88=\"\", \"\", VLOOKUP(G88,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E89=\"\", \"\",VLOOKUP(E89, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G89=\"\", \"\", VLOOKUP(G89,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E90=\"\", \"\",VLOOKUP(E90, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G90=\"\", \"\", VLOOKUP(G90,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E91=\"\", \"\",VLOOKUP(E91, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G91=\"\", \"\", VLOOKUP(G91,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E92=\"\", \"\",VLOOKUP(E92, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G92=\"\", \"\", VLOOKUP(G92,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E93=\"\", \"\",VLOOKUP(E93, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G93=\"\", \"\", VLOOKUP(G93,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E94=\"\", \"\",VLOOKUP(E94, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G94=\"\", \"\", VLOOKUP(G94,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E95=\"\", \"\",VLOOKUP(E95, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G95=\"\", \"\", VLOOKUP(G95,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E96=\"\", \"\",VLOOKUP(E96, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G96=\"\", \"\", VLOOKUP(G96,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E97=\"\", \"\",VLOOKUP(E97, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G97=\"\", \"\", VLOOKUP(G97,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E98=\"\", \"\",VLOOKUP(E98, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G98=\"\", \"\", VLOOKUP(G98,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E99=\"\", \"\",VLOOKUP(E99, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G99=\"\", \"\", VLOOKUP(G99,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E100=\"\", \"\",VLOOKUP(E100, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G100=\"\", \"\", VLOOKUP(G100,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E101=\"\", \"\",VLOOKUP(E101, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G101=\"\", \"\", VLOOKUP(G101,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E102=\"\", \"\",VLOOKUP(E102, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G102=\"\", \"\", VLOOKUP(G102,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E103=\"\", \"\",VLOOKUP(E103, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G103=\"\", \"\", VLOOKUP(G103,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E104=\"\", \"\",VLOOKUP(E104, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G104=\"\", \"\", VLOOKUP(G104,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E105=\"\", \"\",VLOOKUP(E105, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G105=\"\", \"\", VLOOKUP(G105,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E106=\"\", \"\",VLOOKUP(E106, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G106=\"\", \"\", VLOOKUP(G106,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E107=\"\", \"\",VLOOKUP(E107, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G107=\"\", \"\", VLOOKUP(G107,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E108=\"\", \"\",VLOOKUP(E108, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G108=\"\", \"\", VLOOKUP(G108,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E109=\"\", \"\",VLOOKUP(E109, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G109=\"\", \"\", VLOOKUP(G109,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E110=\"\", \"\",VLOOKUP(E110, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G110=\"\", \"\", VLOOKUP(G110,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E111=\"\", \"\",VLOOKUP(E111, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G111=\"\", \"\", VLOOKUP(G111,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E112=\"\", \"\",VLOOKUP(E112, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G112=\"\", \"\", VLOOKUP(G112,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E113=\"\", \"\",VLOOKUP(E113, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G113=\"\", \"\", VLOOKUP(G113,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E114=\"\", \"\",VLOOKUP(E114, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G114=\"\", \"\", VLOOKUP(G114,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E115=\"\", \"\",VLOOKUP(E115, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G115=\"\", \"\", VLOOKUP(G115,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E116=\"\", \"\",VLOOKUP(E116, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G116=\"\", \"\", VLOOKUP(G116,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E117=\"\", \"\",VLOOKUP(E117, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G117=\"\", \"\", VLOOKUP(G117,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E118=\"\", \"\",VLOOKUP(E118, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G118=\"\", \"\", VLOOKUP(G118,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E119=\"\", \"\",VLOOKUP(E119, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G119=\"\", \"\", VLOOKUP(G119,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E120=\"\", \"\",VLOOKUP(E120, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G120=\"\", \"\", VLOOKUP(G120,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E121=\"\", \"\",VLOOKUP(E121, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G121=\"\", \"\", VLOOKUP(G121,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E122=\"\", \"\",VLOOKUP(E122, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G122=\"\", \"\", VLOOKUP(G122,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E123=\"\", \"\",VLOOKUP(E123, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G123=\"\", \"\", VLOOKUP(G123,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E124=\"\", \"\",VLOOKUP(E124, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G124=\"\", \"\", VLOOKUP(G124,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E125=\"\", \"\",VLOOKUP(E125, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G125=\"\", \"\", VLOOKUP(G125,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E126=\"\", \"\",VLOOKUP(E126, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G126=\"\", \"\", VLOOKUP(G126,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E127=\"\", \"\",VLOOKUP(E127, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G127=\"\", \"\", VLOOKUP(G127,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E128=\"\", \"\",VLOOKUP(E128, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G128=\"\", \"\", VLOOKUP(G128,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E129=\"\", \"\",VLOOKUP(E129, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G129=\"\", \"\", VLOOKUP(G129,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E130=\"\", \"\",VLOOKUP(E130, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G130=\"\", \"\", VLOOKUP(G130,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E131=\"\", \"\",VLOOKUP(E131, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G131=\"\", \"\", VLOOKUP(G131,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E132=\"\", \"\",VLOOKUP(E132, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G132=\"\", \"\", VLOOKUP(G132,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E133=\"\", \"\",VLOOKUP(E133, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G133=\"\", \"\", VLOOKUP(G133,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E134=\"\", \"\",VLOOKUP(E134, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G134=\"\", \"\", VLOOKUP(G134,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E135=\"\", \"\",VLOOKUP(E135, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G135=\"\", \"\", VLOOKUP(G135,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E136=\"\", \"\",VLOOKUP(E136, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G136=\"\", \"\", VLOOKUP(G136,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E137=\"\", \"\",VLOOKUP(E137, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G137=\"\", \"\", VLOOKUP(G137,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E138=\"\", \"\",VLOOKUP(E138, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G138=\"\", \"\", VLOOKUP(G138,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E139=\"\", \"\",VLOOKUP(E139, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G139=\"\", \"\", VLOOKUP(G139,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E140=\"\", \"\",VLOOKUP(E140, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G140=\"\", \"\", VLOOKUP(G140,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E141=\"\", \"\",VLOOKUP(E141, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G141=\"\", \"\", VLOOKUP(G141,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E142=\"\", \"\",VLOOKUP(E142, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G142=\"\", \"\", VLOOKUP(G142,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E143=\"\", \"\",VLOOKUP(E143, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G143=\"\", \"\", VLOOKUP(G143,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E144=\"\", \"\",VLOOKUP(E144, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G144=\"\", \"\", VLOOKUP(G144,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E145=\"\", \"\",VLOOKUP(E145, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G145=\"\", \"\", VLOOKUP(G145,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E146=\"\", \"\",VLOOKUP(E146, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G146=\"\", \"\", VLOOKUP(G146,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E147=\"\", \"\",VLOOKUP(E147, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G147=\"\", \"\", VLOOKUP(G147,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E148=\"\", \"\",VLOOKUP(E148, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G148=\"\", \"\", VLOOKUP(G148,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E149=\"\", \"\",VLOOKUP(E149, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G149=\"\", \"\", VLOOKUP(G149,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,{"$f":"IF(AND(A149=\"\",E149=\"\",G149=\"\"), \"\", IF(AND(A149=\"\", OR(E149<>\"\", G149<>\"\")), \"EnterSmpl_ID\",COUNTIF(A$20:A$104877,A149)))","v":""},""]
[null,{"$f":"IF(A150=\"\",\"\",A150)","v":""},null,null,null,{"$f":"IF(E150=\"\", \"\",VLOOKUP(E150, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G150=\"\", \"\", VLOOKUP(G150,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",{"$f":"IF(OR(ISERROR(F150)=TRUE, ISERROR(H150)= TRUE), \"Error\", IF(AND(F150=\"\",H150=\"\", A150=\"\"), \"\", IF(OR(F150=\"\", H150=\"\"), \"inComplete\", COUNTIFS(F:F,F150, H:H,H150))))","v":""}]
[null,"",null,null,null,{"$f":"IF(E151=\"\", \"\",VLOOKUP(E151, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G151=\"\", \"\", VLOOKUP(G151,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E152=\"\", \"\",VLOOKUP(E152, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G152=\"\", \"\", VLOOKUP(G152,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E153=\"\", \"\",VLOOKUP(E153, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G153=\"\", \"\", VLOOKUP(G153,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E154=\"\", \"\",VLOOKUP(E154, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G154=\"\", \"\", VLOOKUP(G154,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E155=\"\", \"\",VLOOKUP(E155, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G155=\"\", \"\", VLOOKUP(G155,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E156=\"\", \"\",VLOOKUP(E156, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G156=\"\", \"\", VLOOKUP(G156,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E157=\"\", \"\",VLOOKUP(E157, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G157=\"\", \"\", VLOOKUP(G157,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E158=\"\", \"\",VLOOKUP(E158, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G158=\"\", \"\", VLOOKUP(G158,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E159=\"\", \"\",VLOOKUP(E159, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G159=\"\", \"\", VLOOKUP(G159,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E160=\"\", \"\",VLOOKUP(E160, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G160=\"\", \"\", VLOOKUP(G160,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E161=\"\", \"\",VLOOKUP(E161, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G161=\"\", \"\", VLOOKUP(G161,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E162=\"\", \"\",VLOOKUP(E162, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G162=\"\", \"\", VLOOKUP(G162,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E163=\"\", \"\",VLOOKUP(E163, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G163=\"\", \"\", VLOOKUP(G163,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E164=\"\", \"\",VLOOKUP(E164, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G164=\"\", \"\", VLOOKUP(G164,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E165=\"\", \"\",VLOOKUP(E165, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G165=\"\", \"\", VLOOKUP(G165,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E166=\"\", \"\",VLOOKUP(E166, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G166=\"\", \"\", VLOOKUP(G166,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E167=\"\", \"\",VLOOKUP(E167, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G167=\"\", \"\", VLOOKUP(G167,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E168=\"\", \"\",VLOOKUP(E168, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G168=\"\", \"\", VLOOKUP(G168,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E169=\"\", \"\",VLOOKUP(E169, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G169=\"\", \"\", VLOOKUP(G169,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E170=\"\", \"\",VLOOKUP(E170, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G170=\"\", \"\", VLOOKUP(G170,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E171=\"\", \"\",VLOOKUP(E171, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G171=\"\", \"\", VLOOKUP(G171,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E172=\"\", \"\",VLOOKUP(E172, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G172=\"\", \"\", VLOOKUP(G172,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E173=\"\", \"\",VLOOKUP(E173, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G173=\"\", \"\", VLOOKUP(G173,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E174=\"\", \"\",VLOOKUP(E174, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G174=\"\", \"\", VLOOKUP(G174,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E175=\"\", \"\",VLOOKUP(E175, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G175=\"\", \"\", VLOOKUP(G175,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E176=\"\", \"\",VLOOKUP(E176, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G176=\"\", \"\", VLOOKUP(G176,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E177=\"\", \"\",VLOOKUP(E177, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G177=\"\", \"\", VLOOKUP(G177,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E178=\"\", \"\",VLOOKUP(E178, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G178=\"\", \"\", VLOOKUP(G178,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E179=\"\", \"\",VLOOKUP(E179, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G179=\"\", \"\", VLOOKUP(G179,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E180=\"\", \"\",VLOOKUP(E180, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G180=\"\", \"\", VLOOKUP(G180,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E181=\"\", \"\",VLOOKUP(E181, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G181=\"\", \"\", VLOOKUP(G181,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E182=\"\", \"\",VLOOKUP(E182, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G182=\"\", \"\", VLOOKUP(G182,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E183=\"\", \"\",VLOOKUP(E183, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G183=\"\", \"\", VLOOKUP(G183,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E184=\"\", \"\",VLOOKUP(E184, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G184=\"\", \"\", VLOOKUP(G184,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E185=\"\", \"\",VLOOKUP(E185, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G185=\"\", \"\", VLOOKUP(G185,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E186=\"\", \"\",VLOOKUP(E186, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G186=\"\", \"\", VLOOKUP(G186,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E187=\"\", \"\",VLOOKUP(E187, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G187=\"\", \"\", VLOOKUP(G187,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E188=\"\", \"\",VLOOKUP(E188, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G188=\"\", \"\", VLOOKUP(G188,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E189=\"\", \"\",VLOOKUP(E189, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G189=\"\", \"\", VLOOKUP(G189,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E190=\"\", \"\",VLOOKUP(E190, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G190=\"\", \"\", VLOOKUP(G190,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E191=\"\", \"\",VLOOKUP(E191, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G191=\"\", \"\", VLOOKUP(G191,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E192=\"\", \"\",VLOOKUP(E192, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G192=\"\", \"\", VLOOKUP(G192,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E193=\"\", \"\",VLOOKUP(E193, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G193=\"\", \"\", VLOOKUP(G193,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E194=\"\", \"\",VLOOKUP(E194, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G194=\"\", \"\", VLOOKUP(G194,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E195=\"\", \"\",VLOOKUP(E195, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G195=\"\", \"\", VLOOKUP(G195,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E196=\"\", \"\",VLOOKUP(E196, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G196=\"\", \"\", VLOOKUP(G196,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E197=\"\", \"\",VLOOKUP(E197, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G197=\"\", \"\", VLOOKUP(G197,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E198=\"\", \"\",VLOOKUP(E198, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G198=\"\", \"\", VLOOKUP(G198,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E199=\"\", \"\",VLOOKUP(E199, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G199=\"\", \"\", VLOOKUP(G199,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E200=\"\", \"\",VLOOKUP(E200, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G200=\"\", \"\", VLOOKUP(G200,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E201=\"\", \"\",VLOOKUP(E201, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G201=\"\", \"\", VLOOKUP(G201,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E202=\"\", \"\",VLOOKUP(E202, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G202=\"\", \"\", VLOOKUP(G202,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E203=\"\", \"\",VLOOKUP(E203, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G203=\"\", \"\", VLOOKUP(G203,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E204=\"\", \"\",VLOOKUP(E204, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G204=\"\", \"\", VLOOKUP(G204,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E205=\"\", \"\",VLOOKUP(E205, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G205=\"\", \"\", VLOOKUP(G205,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E206=\"\", \"\",VLOOKUP(E206, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G206=\"\", \"\", VLOOKUP(G206,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E207=\"\", \"\",VLOOKUP(E207, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G207=\"\", \"\", VLOOKUP(G207,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E208=\"\", \"\",VLOOKUP(E208, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G208=\"\", \"\", VLOOKUP(G208,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E209=\"\", \"\",VLOOKUP(E209, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G209=\"\", \"\", VLOOKUP(G209,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E210=\"\", \"\",VLOOKUP(E210, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G210=\"\", \"\", VLOOKUP(G210,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E211=\"\", \"\",VLOOKUP(E211, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G211=\"\", \"\", VLOOKUP(G211,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E212=\"\", \"\",VLOOKUP(E212, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G212=\"\", \"\", VLOOKUP(G212,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E213=\"\", \"\",VLOOKUP(E213, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G213=\"\", \"\", VLOOKUP(G213,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,{"$f":"IF(AND(A213=\"\",E213=\"\",G213=\"\"), \"\", IF(AND(A213=\"\", OR(E213<>\"\", G213<>\"\")), \"EnterSmpl_ID\",COUNTIF(A$20:A$104877,A213)))","v":""},""]
[null,{"$f":"IF(A214=\"\",\"\",A214)","v":""},null,null,null,{"$f":"IF(E214=\"\", \"\",VLOOKUP(E214, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G214=\"\", \"\", VLOOKUP(G214,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",{"$f":"IF(OR(ISERROR(F214)=TRUE, ISERROR(H214)= TRUE), \"Error\", IF(AND(F214=\"\",H214=\"\", A214=\"\"), \"\", IF(OR(F214=\"\", H214=\"\"), \"inComplete\", COUNTIFS(F:F,F214, H:H,H214))))","v":""}]
[null,"",null,null,null,{"$f":"IF(E215=\"\", \"\",VLOOKUP(E215, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G215=\"\", \"\", VLOOKUP(G215,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E216=\"\", \"\",VLOOKUP(E216, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G216=\"\", \"\", VLOOKUP(G216,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E217=\"\", \"\",VLOOKUP(E217, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G217=\"\", \"\", VLOOKUP(G217,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E218=\"\", \"\",VLOOKUP(E218, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G218=\"\", \"\", VLOOKUP(G218,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E219=\"\", \"\",VLOOKUP(E219, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G219=\"\", \"\", VLOOKUP(G219,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E220=\"\", \"\",VLOOKUP(E220, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G220=\"\", \"\", VLOOKUP(G220,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E221=\"\", \"\",VLOOKUP(E221, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G221=\"\", \"\", VLOOKUP(G221,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E222=\"\", \"\",VLOOKUP(E222, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G222=\"\", \"\", VLOOKUP(G222,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E223=\"\", \"\",VLOOKUP(E223, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G223=\"\", \"\", VLOOKUP(G223,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E224=\"\", \"\",VLOOKUP(E224, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G224=\"\", \"\", VLOOKUP(G224,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E225=\"\", \"\",VLOOKUP(E225, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G225=\"\", \"\", VLOOKUP(G225,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E226=\"\", \"\",VLOOKUP(E226, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G226=\"\", \"\", VLOOKUP(G226,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E227=\"\", \"\",VLOOKUP(E227, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G227=\"\", \"\", VLOOKUP(G227,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E228=\"\", \"\",VLOOKUP(E228, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G228=\"\", \"\", VLOOKUP(G228,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E229=\"\", \"\",VLOOKUP(E229, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G229=\"\", \"\", VLOOKUP(G229,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E230=\"\", \"\",VLOOKUP(E230, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G230=\"\", \"\", VLOOKUP(G230,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E231=\"\", \"\",VLOOKUP(E231, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G231=\"\", \"\", VLOOKUP(G231,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E232=\"\", \"\",VLOOKUP(E232, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G232=\"\", \"\", VLOOKUP(G232,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E233=\"\", \"\",VLOOKUP(E233, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G233=\"\", \"\", VLOOKUP(G233,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E234=\"\", \"\",VLOOKUP(E234, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G234=\"\", \"\", VLOOKUP(G234,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E235=\"\", \"\",VLOOKUP(E235, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G235=\"\", \"\", VLOOKUP(G235,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E236=\"\", \"\",VLOOKUP(E236, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G236=\"\", \"\", VLOOKUP(G236,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E237=\"\", \"\",VLOOKUP(E237, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G237=\"\", \"\", VLOOKUP(G237,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E238=\"\", \"\",VLOOKUP(E238, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G238=\"\", \"\", VLOOKUP(G238,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E239=\"\", \"\",VLOOKUP(E239, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G239=\"\", \"\", VLOOKUP(G239,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E240=\"\", \"\",VLOOKUP(E240, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G240=\"\", \"\", VLOOKUP(G240,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E241=\"\", \"\",VLOOKUP(E241, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G241=\"\", \"\", VLOOKUP(G241,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E242=\"\", \"\",VLOOKUP(E242, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G242=\"\", \"\", VLOOKUP(G242,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E243=\"\", \"\",VLOOKUP(E243, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G243=\"\", \"\", VLOOKUP(G243,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E244=\"\", \"\",VLOOKUP(E244, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G244=\"\", \"\", VLOOKUP(G244,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E245=\"\", \"\",VLOOKUP(E245, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G245=\"\", \"\", VLOOKUP(G245,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E246=\"\", \"\",VLOOKUP(E246, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G246=\"\", \"\", VLOOKUP(G246,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E247=\"\", \"\",VLOOKUP(E247, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G247=\"\", \"\", VLOOKUP(G247,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E248=\"\", \"\",VLOOKUP(E248, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G248=\"\", \"\", VLOOKUP(G248,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E249=\"\", \"\",VLOOKUP(E249, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G249=\"\", \"\", VLOOKUP(G249,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E250=\"\", \"\",VLOOKUP(E250, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G250=\"\", \"\", VLOOKUP(G250,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E251=\"\", \"\",VLOOKUP(E251, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G251=\"\", \"\", VLOOKUP(G251,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E252=\"\", \"\",VLOOKUP(E252, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G252=\"\", \"\", VLOOKUP(G252,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E253=\"\", \"\",VLOOKUP(E253, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G253=\"\", \"\", VLOOKUP(G253,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E254=\"\", \"\",VLOOKUP(E254, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G254=\"\", \"\", VLOOKUP(G254,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E255=\"\", \"\",VLOOKUP(E255, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G255=\"\", \"\", VLOOKUP(G255,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E256=\"\", \"\",VLOOKUP(E256, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G256=\"\", \"\", VLOOKUP(G256,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E257=\"\", \"\",VLOOKUP(E257, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G257=\"\", \"\", VLOOKUP(G257,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E258=\"\", \"\",VLOOKUP(E258, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G258=\"\", \"\", VLOOKUP(G258,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E259=\"\", \"\",VLOOKUP(E259, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G259=\"\", \"\", VLOOKUP(G259,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E260=\"\", \"\",VLOOKUP(E260, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G260=\"\", \"\", VLOOKUP(G260,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E261=\"\", \"\",VLOOKUP(E261, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G261=\"\", \"\", VLOOKUP(G261,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E262=\"\", \"\",VLOOKUP(E262, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G262=\"\", \"\", VLOOKUP(G262,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E263=\"\", \"\",VLOOKUP(E263, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G263=\"\", \"\", VLOOKUP(G263,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E264=\"\", \"\",VLOOKUP(E264, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G264=\"\", \"\", VLOOKUP(G264,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E265=\"\", \"\",VLOOKUP(E265, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G265=\"\", \"\", VLOOKUP(G265,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E266=\"\", \"\",VLOOKUP(E266, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G266=\"\", \"\", VLOOKUP(G266,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E267=\"\", \"\",VLOOKUP(E267, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G267=\"\", \"\", VLOOKUP(G267,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E268=\"\", \"\",VLOOKUP(E268, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G268=\"\", \"\", VLOOKUP(G268,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E269=\"\", \"\",VLOOKUP(E269, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G269=\"\", \"\", VLOOKUP(G269,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E270=\"\", \"\",VLOOKUP(E270, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G270=\"\", \"\", VLOOKUP(G270,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E271=\"\", \"\",VLOOKUP(E271, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G271=\"\", \"\", VLOOKUP(G271,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E272=\"\", \"\",VLOOKUP(E272, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G272=\"\", \"\", VLOOKUP(G272,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E273=\"\", \"\",VLOOKUP(E273, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G273=\"\", \"\", VLOOKUP(G273,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E274=\"\", \"\",VLOOKUP(E274, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G274=\"\", \"\", VLOOKUP(G274,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E275=\"\", \"\",VLOOKUP(E275, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G275=\"\", \"\", VLOOKUP(G275,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]
[null,"",null,null,null,{"$f":"IF(E276=\"\", \"\",VLOOKUP(E276, BarcodeKey!B:C, 2, FALSE))","v":""},null,{"$f":"IF(G276=\"\", \"\", VLOOKUP(G276,BarcodeKey!H:J, 2, FALSE))","v":""},null,null,"",""]

{"sheet":"Password_ForSheet","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Unprotect the sheets:"]
[null,null,"SampleSheet"]

{"sheet":"BarcodeKey","index":3,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Name","Correct","Name",null,null,"TSCA-Name","Name","i5ForMiSeq","for NextSeq","Name"]
[]
["Pillar","Pi701","ATTACTCG","Pi701",null,null,"Pillar","Pi501","TATAGCCT","AGGCTATA","Pi501"]
["Pillar","Pi702","TCCGGAGA","Pi702",null,null,"Pillar","Pi502","ATAGAGGC","GCCTCTAT","Pi502"]
["Pillar","Pi703","CGCTCATT","Pi703",null,null,"Pillar","Pi503","CCTATCCT","AGGATAGG","Pi503"]
["Pillar","Pi704","GAGATTCC","Pi704",null,null,"Pillar","Pi504","GGCTCTGA","TCAGAGCC","Pi504"]
["Pillar","Pi705","ATTCAGAA","Pi705",null,null,"Pillar","Pi505","AGGCGAAG","CTTCGCCT","Pi505"]
["Pillar","Pi706","GAATTCGT","Pi706",null,null,"Pillar","Pi506","TAATCTTA","TAAGATTA","Pi506"]
["Pillar","Pi707","CTGAAGCT","Pi707",null,null,"Pillar","Pi507","CAGGACGT","ACGTCCTG","Pi507"]
["Pillar","Pi708","TAATGCGC","Pi708",null,null,"Pillar","Pi508","GTACTGAC","GTCAGTAC","Pi508"]
["A701","Pi709","ATCACGAC","Pi709",null,null,"A501","Pi509","TGAACCTT","AAGGTTCA","Pi509"]
["A702","Pi710","ACAGTGGT","Pi710",null,null,"A502","Pi510","TGCTAAGT","ACTTAGCA","Pi510"]
["A703","Pi711","CAGATCCA","Pi711",null,null,"A503","Pi511","TGTTCTCT","AGAGAACA","Pi511"]
["A704","Pi712","ACAAACGG","Pi712",null,null,"A504","Pi512","TAAGACAC","GTGTCTTA","Pi512"]
["A709","Pi713","GAAACCCA","Pi713",null,null,"A505","Pi513","CTAATCGA","TCGATTAG","Pi513"]
["A710","Pi714","TGTGACCA","Pi714",null,null,"A506","Pi514","CTAGAACA","TGTTCTAG","Pi514"]
["A711","Pi715","AGGGTCAA","Pi715",null,null,"A507","Pi515","TAAGTTCC","GGAACTTA","Pi515"]
["A712","Pi716","AGGAGTGG","Pi716",null,null,"A508","Pi516","TAGACCTA","TAGGTCTA","Pi516"]
["TSCA","A701","ATCACGAC",null,null,null,"TSCA","A501","TGAACCTT","AAGGTTCA"]
["TSCA","A702","ACAGTGGT",null,null,null,"TSCA","A502","TGCTAAGT","ACTTAGCA"]
["TSCA","A703","CAGATCCA",null,null,null,"TSCA","A503","TGTTCTCT","AGAGAACA"]
["TSCA","A704","ACAAACGG",null,null,null,"TSCA","A504","TAAGACAC","GTGTCTTA"]
["TSCA","A705","ACCCAGCA",null,null,null,"TSCA","A505","CTAATCGA","TCGATTAG"]
["TSCA","A706","AACCCCTC",null,null,null,"TSCA","A506","CTAGAACA","TGTTCTAG"]
["TSCA","A707","CCCAACCT",null,null,null,"TSCA","A507","TAAGTTCC","GGAACTTA"]
["TSCA","A708","CACCACAC",null,null,null,"TSCA","A508","TAGACCTA","TAGGTCTA"]
["TSCA","A709","GAAACCCA"]
["TSCA","A710","TGTGACCA"]
["TSCA","A711","AGGGTCAA"]
["TSCA","A712","AGGAGTGG"]