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

{"sheet":"DataOrder","index":0,"n_rows":17,"n_cols":23,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,6,0,8],[0,9,0,11],[0,3,0,5]]}
[null,"15110"]
["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"]
["0420408174","StayNo Novovladykinsky pr","00066877","00131522","Пик","СБН","EW1611W520","Оральный ирригатор (аккумуляторный)",10,0,50,902,{"$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":"годный"},"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,{"$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":"годный"},"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,{"$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":"годный"},"01CN",5,0,"5025232538508",null,null,"UFMCK8YGAV","Юрий Гавришов","A 305 0005 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131522","Пик","СБН","EW1211A321","Оральный ирригатор (аккумуляторный)",1,0,5,902,{"$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":"годный"},"01TH",5,0,"5025232795086",null,null,"UFMCK8YGAV","Юрий Гавришов","A 306 0006 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131523","Пик","СБН","EW1511W520","Оральный ирригатор (аккумуляторный)",12,0,60,902,{"$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":"годный"},"01CN",5,0,"5025232894208",null,null,"UFMCK8YGAV","Юрий Гавришов","A 306 0042 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131523","Пик","СБН","EW1211A321","Оральный ирригатор (аккумуляторный)",23,0,115,902,{"$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":"годный"},"01TH",5,0,"5025232795086",null,null,"UFMCK8YGAV","Юрий Гавришов","A 307 0016 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131523","Пик","СБН","EW-DJ40-W520","Оральный ирригатор",18,0,90,902,{"$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":"годный"},"01CN",5,0,"5025232538508",null,null,"UFMCK8YGAV","Юрий Гавришов","A 308 0003 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131524","Пик","СБН","EW-DJ40-W520","Оральный ирригатор",0,4,4,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":"годный"},"01CN",5,0,"5025232538508",null,null,"UFMCK8STIK","Сергей Тихонов","A 305 0005 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131524","Пик","СБН","EW1211A321","Оральный ирригатор (аккумуляторный)",0,1,1,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":"годный"},"01TH",5,0,"5025232795086",null,null,"UFMCK8STIK","Сергей Тихонов","A 306 0006 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131524","Пик","СБН","EW1211A321","Оральный ирригатор (аккумуляторный)",0,3,3,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":"годный"},"01TH",5,0,"5025232795086",null,null,"UFMCK8STIK","Сергей Тихонов","A 307 0016 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131524","Пик","СБН","EW-DJ40-W520","Оральный ирригатор",0,1,1,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":"годный"},"01CN",5,0,"5025232538508",null,null,"UFMCK8STIK","Сергей Тихонов","A 308 0003 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131525","Деп","СБН","EW-DJ10-A520","Оральный ирригатор",9,0,90,902,{"$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":"годный"},"01CN",10,0,"5025232525164",null,null,"UFMCK8SSER","Сероглазов Сергей","A 308 0004 02",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131547","Пик","СБН","EW1411H321","Оральный ирригатор (аккумуляторный)",24,0,120,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":"годный"},"01TH",5,0,"5025232873197",null,null,"UFMCK8STIK","Сергей Тихонов","A 305 0007 01",15110]
["0420408174","StayNo Novovladykinsky pr","00066877","00131548","Пик","СБН","EW0955W520","Сменная насадка для орального ирригатора",3,0,150,902,{"$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":"годный"},"01CN",50,0,"5025232547425",null,null,"UFMCK8YGAV","Юрий Гавришов","M 316 0016 20",15110]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,I3:I16)","v":116},{"$f":"SUBTOTAL(109,J3:J16)","v":9},{"$f":"SUBTOTAL(109,K3:K16)","v":784}]

{"sheet":"ForCheck","index":1,"n_rows":1,"n_cols":28,"rows_kept":1,"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"]

{"sheet":"DataSupport","index":2,"n_rows":9,"n_cols":27,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,3,0,5],[0,6,0,8],[0,9,0,11]]}
[null,"00131547",null,null,null,null,null,null,null,"*Логин сборщика можно не указывать\n** Количество указывать в штуках\n***\"Ремонт\" - товар с уникальными номерами"]
["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"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,I3:I3)","v":0},{"$f":"SUBTOTAL(109,J3:J3)","v":0},{"$f":"SUBTOTAL(109,K3:K3)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"годный"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ремонт",{"$f":"#N/A","v":{"$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,null,null,null,"брак",{"$f":"#N/A","v":{"$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,null,null,null,"утиль",{"$f":"#N/A","v":{"$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,null,null,null,"сэмпл",{"$f":"#N/A","v":{"$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,null,null,null,"блок",{"$f":"#N/A","v":{"$error":"#N/A"}}]

{"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"]