{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DataOrder","ForCheck","DataSupport","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DataOrder","index":0,"n_rows":12,"n_cols":23,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,6,0,8],[0,9,0,11],[0,3,0,5]]}
[]
["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","ФИО","Ячейка подбора","         Round"]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MJ-M171PWTQ","Соковыжималка",10,0,10,303,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",1,0,"5025232543991",null,null,"UFMCK8STIK","Сергей Тихонов","A 304 0024 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MK-MG1510WTQ","Мясорубка",2,0,2,303,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",1,0,"5025232791552",null,null,"UFMCK8STIK","Сергей Тихонов","A 303 0020 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","ES-ST25KS820","Электробритва (аккумуляторная)",1,0,5,303,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232732111",null,null,"UFMCK8STIK","Сергей Тихонов","M 313 0020 32",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","WES9177Y1361","Сменная сетка для электробритвы",5,0,100,303,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",20,0,"5025232864607",null,null,"UFMCK8STIK","Сергей Тихонов","M 315 0025 20",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131538","Пик","ОТГ","ES-LT2N-S820","Электробритва (аккумуляторная)",0,1,1,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232817887",null,null,"UFMCK8YGAV","Юрий Гавришов","A 305 0009 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131538","Пик","ОТГ","ES-ST25KS820","Электробритва (аккумуляторная)",0,2,2,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232732111",null,null,"UFMCK8YGAV","Юрий Гавришов","M 311 0007 32",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131539","Деп","ОТГ","ES-CV51-S820","Электрическая компактная бритва (акк.)",12,0,60,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232864515",null,null,"UFMCK8SSER","Сероглазов Сергей","A 303 0031 03",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131540","Деп","ОТГ","ES-LT2N-S820","Электробритва (аккумуляторная)",3,0,15,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232817887",null,null,"UFMCK8SSER","Сероглазов Сергей","A 305 0008 03",15113]
["0420410078","Optima - Bikovo 2017","00066879","00131541","Деп","ОТГ","MK-MG1510WTQ","Мясорубка",28,0,28,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",1,0,"5025232791552",null,null,"UFMCK8SSER","Сероглазов Сергей","A 314 0007 03",15112]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,I3:I11)","v":61},{"$f":"SUBTOTAL(109,J3:J11)","v":3},{"$f":"SUBTOTAL(109,K3:K11)","v":223}]

{"sheet":"ForCheck","index":1,"n_rows":34,"n_cols":28,"rows_kept":34,"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","ФИО","Ячейка подбора","         Round","#X","FactST","#Дата-время контроля","#Контролер_фио","#Comp"]
["0420404577","Yug-Rozetka","00066655","00131329","Пикинг","Отгружен","90114200-RU","MULTI-LET Колодка 2гн земл., белая",1,0,30,304,"годный","01TR",30,0,"8681224658561",null,"8681224663565","UFMCK8STIK","Сергей Тихонов","A 302 0001 01",15094]
["0420404577","Yug-Rozetka","00066655","00131329","Пикинг","Отгружен","90118300-RU","MULTI-LET Колодка 3гн земл. выкл., белая",1,0,25,304,"годный","01TR",25,0,"8681224659216",null,"8681224664210","UFMCK8STIK","Сергей Тихонов","A 302 0002 01",15094]
["0420404577","Yug-Rozetka","00066655","00131329","Пикинг","Отгружен","90118600-RU","MULTI-LET Колодка 6гн земл. выкл., белая",1,0,30,304,"годный","01TR",30,0,"8681224659360","8681224664364","8681224669369","UFMCK8STIK","Сергей Тихонов","A 301 0003 01",15094]
["0420404577","Yug-Rozetka","00066655","00131329","Пикинг","Отгружен","90561019-RU","CARMEN Выключатель с подсветкой, белый",3,0,360,304,"годный","01TR",120,12,"8681224674295","8681224679290","8681224684294","UFMCK8STIK","Сергей Тихонов","A 302 0010 01",15094]
["0420404577","Yug-Rozetka","00066655","00131329","Пикинг","Отгружен","90562056-RU","CARMEN Розетка 2ная заземл., кремовая",5,0,300,304,"годный","01TR",60,10,"8681224675056","8681224680050","8681224685055","UFMCK8STIK","Сергей Тихонов","A 301 0012 01",15094]
["0420404577","Yug-Rozetka","00066655","00131329","Пикинг","Отгружен","90912008-RU","Щит встраиваемый с двер. 1ряд/8мод IP40",1,0,20,304,"годный","01TR",20,0,"8681224732001",null,"8681224732421","UFMCK8STIK","Сергей Тихонов","A 301 0013 01",15094]
["0420404577","Yug-Rozetka","00066655","00131329","Пикинг","Отгружен","90912106-RU","Щит навесной с дверцей 1ряд/6мод IP40",1,0,30,304,"годный","01TR",30,0,"8681224732087",null,"8681224732506","UFMCK8STIK","Сергей Тихонов","A 301 0014 01",15094]
["0420404577","Yug-Rozetka","00066655","00131329","Пикинг","Отгружен","90912116-RU","Щит навесной с дверцей 2ряд/16мод IP40",3,0,30,304,"годный","01TR",10,0,"8681224732117",null,"8681224732537","UFMCK8STIK","Сергей Тихонов","A 301 0015 01",15094]
["0420408174","StayNo Novovladykinsky pr","00066877","00131522","Пикинг","Собран","EW1611W520","Оральный ирригатор (аккумуляторный)",10,0,50,902,"годный","01CN",5,0,"5025232885626",null,null,"UFMCK8YGAV","Юрий Гавришов","A 303 0009 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131522","Пикинг","Собран","EW-DJ10-A520","Оральный ирригатор",3,0,30,902,"годный","01CN",10,0,"5025232525164",null,null,"UFMCK8YGAV","Юрий Гавришов","A 304 0002 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131522","Пикинг","Собран","EW-DJ40-W520","Оральный ирригатор",13,0,65,902,"годный","01CN",5,0,"5025232538508",null,null,"UFMCK8YGAV","Юрий Гавришов","A 305 0005 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131522","Пикинг","Собран","EW1611W520","Оральный ирригатор (аккумуляторный)",10,0,50,902,"годный","01CN",5,0,"5025232885626",null,null,"UFMCK8YGAV","Юрий Гавришов","A 303 0009 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131522","Пикинг","Собран","EW-DJ10-A520","Оральный ирригатор",3,0,30,902,"годный","01CN",10,0,"5025232525164",null,null,"UFMCK8YGAV","Юрий Гавришов","A 304 0002 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131522","Пикинг","Собран","EW-DJ40-W520","Оральный ирригатор",13,0,65,902,"годный","01CN",5,0,"5025232538508",null,null,"UFMCK8YGAV","Юрий Гавришов","A 305 0005 01",15110]
["0420410078","Optima - Bikovo 2017","00066879","00131538","Пикинг","Отгружен","ES-LT2N-S820","Электробритва (аккумуляторная)",0,1,1,903,"годный","01JP",5,0,"5025232817887",null,null,"UFMCK8YGAV","Юрий Гавришов","A 305 0009 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131538","Пикинг","Отгружен","ES-LT2N-S820","Электробритва (аккумуляторная)",0,1,1,903,"годный","01JP",5,0,"5025232817887",null,null,"UFMCK8YGAV","Юрий Гавришов","A 305 0009 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MJ-M171PWTQ","Соковыжималка",10,0,10,303,"годный","01MY",1,0,"5025232543991",null,null,"UFMCK8STIK","Сергей Тихонов","A 304 0024 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MK-MG1510WTQ","Мясорубка",2,0,2,303,"годный","01MY",1,0,"5025232791552",null,null,"UFMCK8STIK","Сергей Тихонов","A 303 0020 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","ES-ST25KS820","Электробритва (аккумуляторная)",1,0,5,303,"годный","01JP",5,0,"5025232732111",null,null,"UFMCK8STIK","Сергей Тихонов","M 313 0020 32",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MJ-M171PWTQ","Соковыжималка",10,0,10,303,"годный","01MY",1,0,"5025232543991",null,null,"UFMCK8STIK","Сергей Тихонов","A 304 0024 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MK-MG1510WTQ","Мясорубка",2,0,2,303,"годный","01MY",1,0,"5025232791552",null,null,"UFMCK8STIK","Сергей Тихонов","A 303 0020 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","ES-ST25KS820","Электробритва (аккумуляторная)",1,0,5,303,"годный","01JP",5,0,"5025232732111",null,null,"UFMCK8STIK","Сергей Тихонов","M 313 0020 32",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131538","Пик","ОТГ","ES-LT2N-S820","Электробритва (аккумуляторная)",0,1,1,903,"годный","01JP",5,0,"5025232817887",null,null,"UFMCK8YGAV","Юрий Гавришов","A 305 0009 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MJ-M171PWTQ","Соковыжималка",10,0,10,303,"годный","01MY",1,0,"5025232543991",null,null,"UFMCK8STIK","Сергей Тихонов","A 304 0024 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MK-MG1510WTQ","Мясорубка",2,0,2,303,"годный","01MY",1,0,"5025232791552",null,null,"UFMCK8STIK","Сергей Тихонов","A 303 0020 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","ES-ST25KS820","Электробритва (аккумуляторная)",1,0,5,303,"годный","01JP",5,0,"5025232732111",null,null,"UFMCK8STIK","Сергей Тихонов","M 313 0020 32",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MJ-M171PWTQ","Соковыжималка",10,0,10,303,"годный","01MY",1,0,"5025232543991",null,null,"UFMCK8STIK","Сергей Тихонов","A 304 0024 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MK-MG1510WTQ","Мясорубка",2,0,2,303,"годный","01MY",1,0,"5025232791552",null,null,"UFMCK8STIK","Сергей Тихонов","A 303 0020 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","ES-ST25KS820","Электробритва (аккумуляторная)",1,0,5,303,"годный","01JP",5,0,"5025232732111",null,null,"UFMCK8STIK","Сергей Тихонов","M 313 0020 32",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MJ-M171PWTQ","Соковыжималка",10,0,10,303,"годный","01MY",1,0,"5025232543991",null,null,"UFMCK8STIK","Сергей Тихонов","A 304 0024 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MK-MG1510WTQ","Мясорубка",2,0,2,303,"годный","01MY",1,0,"5025232791552",null,null,"UFMCK8STIK","Сергей Тихонов","A 303 0020 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","ES-ST25KS820","Электробритва (аккумуляторная)",1,0,5,303,"годный","01JP",5,0,"5025232732111",null,null,"UFMCK8STIK","Сергей Тихонов","M 313 0020 32",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","WES9177Y1361","Сменная сетка для электробритвы",5,0,100,303,"годный","01JP",20,0,"5025232864607",null,null,"UFMCK8STIK","Сергей Тихонов","M 315 0025 20",15111]

{"sheet":"DataSupport","index":2,"n_rows":12,"n_cols":23,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,3,0,5],[0,6,0,8],[0,9,0,11]]}
[]
["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","ФИО","Ячейка подбора","         Round"]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MJ-M171PWTQ","Соковыжималка",10,0,10,303,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",1,0,"5025232543991",null,null,"UFMCK8STIK","Сергей Тихонов","A 304 0024 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","MK-MG1510WTQ","Мясорубка",2,0,2,303,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",1,0,"5025232791552",null,null,"UFMCK8STIK","Сергей Тихонов","A 303 0020 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","ES-ST25KS820","Электробритва (аккумуляторная)",1,0,5,303,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232732111",null,null,"UFMCK8STIK","Сергей Тихонов","M 313 0020 32",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131537","Пик","ОТГ","WES9177Y1361","Сменная сетка для электробритвы",5,0,100,303,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",20,0,"5025232864607",null,null,"UFMCK8STIK","Сергей Тихонов","M 315 0025 20",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131538","Пик","ОТГ","ES-LT2N-S820","Электробритва (аккумуляторная)",0,1,1,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232817887",null,null,"UFMCK8YGAV","Юрий Гавришов","A 305 0009 01",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131538","Пик","ОТГ","ES-ST25KS820","Электробритва (аккумуляторная)",0,2,2,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232732111",null,null,"UFMCK8YGAV","Юрий Гавришов","M 311 0007 32",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131539","Деп","ОТГ","ES-CV51-S820","Электрическая компактная бритва (акк.)",12,0,60,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232864515",null,null,"UFMCK8SSER","Сероглазов Сергей","A 303 0031 03",15111]
["0420410078","Optima - Bikovo 2017","00066879","00131540","Деп","ОТГ","ES-LT2N-S820","Электробритва (аккумуляторная)",3,0,15,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01JP",5,0,"5025232817887",null,null,"UFMCK8SSER","Сероглазов Сергей","A 305 0008 03",15113]
["0420410078","Optima - Bikovo 2017","00066879","00131541","Деп","ОТГ","MK-MG1510WTQ","Мясорубка",28,0,28,903,{"$f":"IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"0\",\"годный\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"2\",\"ремонт\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"3\",\"брак\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"4\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"5\",\"утиль\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"9\",\"сэмпл\",IF(LEFT(tFromInfOrder[[#This Row],[LOT]],1)=\"6\",\"блок\",\"\")))))))","v":"годный"},"01MY",1,0,"5025232791552",null,null,"UFMCK8SSER","Сероглазов Сергей","A 314 0007 03",15112]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,I3:I11)","v":61},{"$f":"SUBTOTAL(109,J3:J11)","v":3},{"$f":"SUBTOTAL(109,K3:K11)","v":223}]

{"sheet":"Лист1","index":3,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["CODMOP","LIBMOP"]
["DN","Сборка для ДНС"]
["EXP","Экспорт (BY,AM,KG)"]
["STD","Стандартная обработка"]
["010","Сборка брака для продажи"]
["995","Сборка брака"]
["IM","Интернет магазин"]
["MV","Сборка для МВидео"]
["EL","Сборка для Эльдорадо"]
["MM","Сборка для МГЛ (МедиаМаркт)"]
["AV","Сборка для Адванс"]
["KZH","Экспорт (Казахстан)"]
["MVU","Сборка для МВидео Штучная рез"]
["99L","Вывод недостач"]
["IM2","Интернет магазин - 2 (30 кор)"]
["BAT","Подбор батареек"]
["GDS","GOODS"]
["PIC","PICK POINT"]
["BTR","Батарейки без системы"]
["KIT","KIT"]
["RZT","Rozetki"]