{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DataOrder","ForCheck"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"DataOrder","index":0,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
["SO_Number","Client","GCS_Number","Support_N","Type picking","Status","Article","Description","Qty BOX","Qty PCE","Total PCE","Dock","Сток","LOT","шт всего в кор.","шт в 1 груп.","EAN шт","EAN групаж","EAN короб","Login","ФИО","Ячейка подбора"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","NN-ST342MZPE","Микроволновая печь",4,0,4,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",1,0,"5025232690206",null,null,"",null,"A 301 0007 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","TX-43GR300","LED ТВ, 43\"",1,0,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"03BY",1,0,"4814032004563",null,null,"",null,"A 302 0017 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","TX-58GXR700A","4K-ТВ со светодиодной подсветкой, 58\"",1,0,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"03BY",1,0,"5025232893669",null,null,"",null,"A 301 0019 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","RP-HJE190E-K","Наушники",2,0,20,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",10,0,"5025232678136",null,null,"",null,"A 301 0022 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","TX-65GXR700A","4K-ТВ со светодиодной подсветкой, 65\"",1,0,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"03BY",1,0,"5025232893652",null,null,"",null,"A 301 0037 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","SC-HC410EE-S","Микро-система",2,0,2,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",1,0,"5025232886562",null,null,"",null,"A 304 0041 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","ER-GY10CM520","Машинка д/стрижки волос/триммер д/бороды",2,0,20,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",10,0,"5025232632763",null,null,"",null,"A 304 0035 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","ES3042S520","Электробритва",1,0,5,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",5,0,"5025232531424",null,null,"",null,"A 303 0013 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","KX-TG1612RUH","Беспроводной телефон стандарта DECT",2,0,6,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01VN",3,0,"5025232621880",null,null,"",null,"A 303 0012 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131148","Пикинг","Для сбора","KX-TG1611RUW","Беспроводной телефон стандарта DECT",7,0,21,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01VN",3,0,"5025232624669",null,null,"",null,"A 305 0016 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131149","Пикинг","Для сбора","KX-TG2511RUM","Беспроводной телефон стандарта DECT",7,0,21,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",3,0,"5025232544646",null,null,"",null,"A 306 0044 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131149","Пикинг","Для сбора","ER-GN30-K520","Машинка для стрижки волос в носу и ушах",1,0,10,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",10,0,"5025232597291",null,null,"",null,"A 308 0044 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131149","Пикинг","Для сбора","RF-2400DEE-K","Портативный радиоприемник, цифровой, FM",2,0,6,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01ID",3,0,"2019082700003",null,null,"",null,"A 307 0015 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131149","Пикинг","Для сбора","RF-2400DEE-K","Портативный радиоприемник, цифровой, FM",2,0,6,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01ID",3,0,"5025232863433",null,null,"",null,"A 307 0015 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131149","Пикинг","Для сбора","KX-TGB210RUB","Беспроводной телефон стандарта DECT",1,0,3,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01VN",3,0,"5025232764112",null,null,"",null,"A 307 0007 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131149","Пикинг","Для сбора","RP-HJE125E-Z","Наушники",1,0,10,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",10,0,"5025232711987",null,null,"",null,"M 315 0021 20"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","ES3042S520","Электробритва",0,2,2,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",5,0,"5025232531424",null,null,"",null,"A 303 0013 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","ES-SA40-S520","Электробритва",0,3,3,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",5,0,"5025232493975",null,null,"",null,"A 304 0006 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TGB210RUR","Беспроводной телефон стандарта DECT",0,2,2,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01VN",3,0,"5025232786961",null,null,"",null,"A 305 0008 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TG6812RUB","Беспроводной телефон стандарта DECT",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",3,0,"5025232699193",null,null,"",null,"A 305 0020 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","ES-RF31-S520","Электробритва (аккумуляторная)",0,2,2,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",5,0,"5025232574315",null,null,"",null,"A 305 0026 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TG1611RUF","Беспроводной телефон стандарта DECT",0,2,2,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01VN",3,0,"5025232624690",null,null,"",null,"A 305 0042 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TG6811RUB","Беспроводной телефон стандарта DECT",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",3,0,"5025232699582",null,null,"",null,"A 307 0042 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TG1611RUR","Беспроводной телефон стандарта DECT",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01VN",3,0,"5025232624683",null,"KX-TG1611RUR","",null,"A 307 0043 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TS2350RUJ","Проводной телефонный аппарат",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",3,0,"5025232449378",null,null,"",null,"A 308 0038 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TG2512RUN","Беспроводной телефон стандарта DECT",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",3,0,"5025232545247",null,null,"",null,"A 307 0022 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TS2388RUB","Проводной телефон",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",3,0,"5025232545513",null,null,"",null,"A 307 0013 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TG2511RUS","Беспроводной телефон стандарта DECT",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",3,0,"5025232565474",null,null,"",null,"A 308 0011 01"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TG8051RUB","Беспроводной телефон стандарта DECT",0,2,2,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",3,0,"5025232594368",null,null,"",null,"M 310 0044 10"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","RP-HF100GC-W","Наушники открытого типа",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",10,0,"8887549637353",null,null,"",null,"M 312 0026 10"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","RF-P50DEG-S","Портативный радиоприемник, цифровой, FM",0,2,2,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01ID",20,0,"2019082700027",null,null,"",null,"M 311 0006 31"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","RF-P50DEG-S","Портативный радиоприемник, цифровой, FM",0,2,2,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01ID",20,0,"5025232863457",null,null,"",null,"M 311 0006 31"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","EH-HV21-K865","Электрические щипцы для волос",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01TH",10,0,"5025232894550",null,null,"",null,"M 314 0006 32"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","RP-HS35MGC-K","Вкладыши канального типа для спорта",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",10,0,"8887549715464",null,null,"",null,"M 314 0020 32"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","RP-HDE5MGC-S","Внутриканальные Hi-Res наушники ( Серебр",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",5,0,"8887549675706",null,null,"",null,"M 314 0033 20"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","RP-TCM130GEG","Внутриканальные науш. с гарнит.(Зелёный)",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",10,0,"8887549739354",null,null,"",null,"M 315 0036 30"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","KX-TG2511RUS","Беспроводной телефон стандарта DECT",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",3,0,"5025232565474",null,null,"",null,"M 315 0022 32"]
["0420397454","DNS Trade- Obuhovo New","00066405","00131150","Пикинг","Для сбора","RP-BTS35GC-A","Внутриканальные Bluetooth наушники",0,1,1,410,{"$f":"IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT([1]!tFromInfolog[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01CN",5,0,"8887549695858",null,null,"",null,"M 316 0013 30"]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,I3:I40)","v":37},{"$f":"SUBTOTAL(109,J3:J40)","v":31},{"$f":"SUBTOTAL(109,K3:K40)","v":168}]

{"sheet":"ForCheck","index":1,"n_rows":41,"n_cols":23,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["SO_Number","Client","GCS_Number","Support_N","Type picking","Status","Article","Description","Qty BOX","Qty PCE","Total PCE","Dock","Сток","LOT","шт всего в кор.","шт в 1 груп.","EAN шт","EAN групаж","EAN короб","Login","ФИО","Ячейка подбора"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]