{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ПФЕП","Выборка","Шаблон","ШаблонУпаковочный","На печать","Шаблон(АдресПоставки)","АдресПоставки"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":257,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ПФЕП","index":0,"n_rows":4,"n_cols":19,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Артикул УПП","название","количество в ЕУ","Количество в ЕМ","Тип тары","Номер тары ","Цвет, характеристика","Вес нетто ЕУ (кг) ","Вес брутто ЕУ (кг)","Вес нетто ЕМ (кг) ","Вес брутто ЕМ (кг)","Номер детали поставщика","Документ отгрузки","Номер партии","Тарное место","Дата"," Код поставщика","Название адрес поставщика","Получатель "]
["316300827564700","ОБОЛОЧКА ТЯГИ ПРИВОДА ЗАМКА КАПОТА С ПОВОДКОМ И ТЯГОЙ",2160,22160,"KLT3215-GK01",1245638,"099200004100107","20","21","100","110","W57S99KM8B18A35","L-1495608",180011,3,"2018-11-20",2523654,"LLC WERTOGEN Otomobil Fabrika A.S., \nHongkong, 150-3 CHILKOI-DONG, PYUNGTAEK-SI, KYUNGKIG-DO","компания"]
["316300827564700","ОБОЛОЧКА ТЯГИ ПРИВОДА ЗАМКА КАПОТА С ПОВОДКОМ И ТЯГОЙ","56","10000","KLT3215-GK01",1245638,"099200004100107","32","34","150","160","W57S99KM8B18A35","L-1495608",180011,3,"2018-11-20",2523654,"LLC WERTOGEN Otomobil Fabrika A.S., \nHongkong, 150-3 CHILKOI-DONG, PYUNGTAEK-SI, KYUNGKIG-DO","компания"]
["316300827564700","ОБОЛОЧКА ТЯГИ ПРИВОДА ЗАМКА КАПОТА С ПОВОДКОМ И ТЯГОЙ","435","34342","KLT3215-GK01",1245638,"099200004100107","78","56","200","220","W57S99KM8B18A35","L-1495608",180011,3,"2018-11-20",2523654,"LLC WERTOGEN Otomobil Fabrika A.S., \nHongkong, 150-3 CHILKOI-DONG, PYUNGTAEK-SI, KYUNGKIG-DO","компания"]

{"sheet":"Выборка","index":1,"n_rows":7,"n_cols":69,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["316300827564700","ОБОЛОЧКА ТЯГИ ПРИВОДА ЗАМКА КАПОТА С ПОВОДКОМ И ТЯГОЙ",2160,22160,"KLT3215-GK01",1245638,"099200004100107","20","21","100","110","W57S99KM8B18A35","L-1495608",180011,3,"2018-11-20",2523654,"LLC WERTOGEN Otomobil Fabrika A.S., \nHongkong, 150-3 CHILKOI-DONG, PYUNGTAEK-SI, KYUNGKIG-DO","компания",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,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
["316300827564700","ОБОЛОЧКА ТЯГИ ПРИВОДА ЗАМКА КАПОТА С ПОВОДКОМ И ТЯГОЙ","56","10000","KLT3215-GK01",1245638,"099200004100107","32","34","150","160","W57S99KM8B18A35","L-1495608",180011,3,"2018-11-20",2523654,"LLC WERTOGEN Otomobil Fabrika A.S., \nHongkong, 150-3 CHILKOI-DONG, PYUNGTAEK-SI, KYUNGKIG-DO","компания"]

{"sheet":"Шаблон","index":2,"n_rows":1500,"n_cols":14,"rows_kept":1500,"cut":false,"hidden":false,"merged":[[9,0,11,7],[3,13,3,15],[4,13,5,15],[0,7,0,12],[0,13,0,15],[1,0,1,6],[1,7,2,12],[1,13,1,15],[2,0,2,6],[2,13,2,15],[0,0,0,6],[3,4,4,5],[3,6,4,7],[3,0,3,3],[4,0,4,3],[5,4,5,5],[5,6,5,7],[6,0,6,2],[7,0,8,2],[6,3,8,7],[5,0,5,3],[3,8,3,12],[4,8,4,12],[5,8,5,12],[6,8,6,11],[7,8,11,11],[6,12,6,15],[7,12,8,15],[9,12,11,15]]}
["Номер детали",null,null,null,null,null,null,"Наименование детали",null,null,null,null,null,"Количество"]
[{"$f":"Выборка!A1","v":"316300827564700"},null,null,null,null,null,null,{"$f":"Выборка!B1","v":"ОБОЛОЧКА ТЯГИ ПРИВОДА ЗАМКА КАПОТА С ПОВОДКОМ И ТЯГОЙ"},null,null,null,null,null,{"$f":"Выборка!C1","v":2160}]
[{"$f":"\"*\"&A2&\"*\"","v":"*316300827564700*"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"*\"&N2&\"*\"","v":"*2160*"}]
["тип тары",null,null,null,"Вес нетто (кг)",null,"Вес брутто (кг)",null,"Цвет, хар-ка (код)",null,null,null,null,"Дата"]
["*000001245638*",null,null,null,null,null,null,null,{"$f":"Выборка!G1","v":"099200004100107"},null,null,null,null,"2018-11-20"]
[{"$f":"Выборка!E1","v":"KLT3215-GK01"},null,null,null,{"$f":"Выборка!H1","v":"20"},null,{"$f":"Выборка!I1","v":"21"},null,{"$f":"I5","v":"099200004100107"}]
["Поставщик",null,null,{"$f":"\"*\"&A8&\"*\"","v":"*00002523654*"},null,null,null,null,"Получатель",null,null,null,"Номер детали поставщика"]
[{"$f":"TEXT(Выборка!Q1,\"00000000000\")","v":"00002523654"},null,null,null,null,null,null,null,"ООО \"Компания\"",null,null,null,{"$f":"Выборка!L1","v":"W57S99KM8B18A35"}]
[]
[{"$f":"Выборка!R1","v":"LLC WERTOGEN Otomobil Fabrika A.S., \nHongkong, 150-3 CHILKOI-DONG, PYUNGTAEK-SI, KYUNGKIG-DO"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"*\"&M8&\"*\"","v":"*W57S99KM8B18A35*"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"5"]

{"sheet":"ШаблонУпаковочный","index":3,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,8],[1,9,1,12],[2,0,2,8],[2,9,2,12],[3,0,3,8],[3,9,3,12],[7,9,7,12],[8,4,8,6],[8,9,8,12],[9,4,9,5],[9,6,9,9],[4,0,4,8],[4,9,5,12],[5,0,5,3],[5,4,5,8],[6,2,6,3],[6,4,6,6],[6,7,6,8],[6,9,6,12],[9,0,9,3],[6,0,6,1],[7,0,8,1],[7,2,8,3],[7,4,7,6],[7,7,8,8],[14,0,14,3],[14,4,15,5],[14,6,14,9],[14,10,15,10],[14,11,15,11],[15,0,15,3],[15,6,15,9],[10,11,11,11],[11,6,11,9],[12,4,13,5],[12,6,12,9],[12,10,13,10],[12,11,13,11],[13,6,13,9],[11,0,11,3],[12,0,12,3],[10,4,11,5],[10,6,10,9],[10,10,11,10],[13,0,13,3],[10,0,10,3],[18,0,18,3],[18,4,19,5],[18,6,18,9],[18,10,19,10],[18,11,19,11],[19,0,19,3],[19,6,19,9],[16,0,16,3],[16,4,17,5],[16,6,16,9],[16,10,17,10],[16,11,17,11],[17,0,17,3],[17,6,17,9],[22,0,22,3],[22,4,23,5],[22,6,22,9],[22,10,23,10],[22,11,23,11],[23,0,23,3],[23,6,23,9],[20,0,20,3],[20,4,21,5],[20,6,20,9],[20,10,21,10],[20,11,21,11],[21,0,21,3],[21,6,21,9],[26,0,26,3],[26,4,27,5],[26,6,26,9],[26,10,27,10],[26,11,27,11],[27,0,27,3],[27,6,27,9],[24,0,24,3],[24,4,25,5],[24,6,24,9],[24,10,25,10],[24,11,25,11],[25,0,25,3],[25,6,25,9],[30,0,30,3],[30,4,31,5],[30,6,30,9],[30,10,31,10],[30,11,31,11],[31,0,31,3],[31,6,31,9],[28,0,28,3],[28,4,29,5],[28,6,28,9],[28,10,29,10],[28,11,29,11],[29,0,29,3],[29,6,29,9],[34,0,34,3],[34,4,35,5],[34,6,34,9],[34,10,35,10],[34,11,35,11],[35,0,35,3],[35,6,35,9],[32,0,32,3],[32,4,33,5],[32,6,32,9],[32,10,33,10],[32,11,33,11],[33,0,33,3],[33,6,33,9],[38,0,38,3],[38,4,39,5],[38,6,38,9],[38,10,39,10],[38,11,39,11],[39,0,39,3],[39,6,39,9],[36,0,36,3],[36,4,37,5],[36,6,36,9],[36,10,37,10],[36,11,37,11],[37,0,37,3],[37,6,37,9]]}
["Упаковочный лист 003"]
["Поставщик",null,null,null,null,null,null,null,null,"Получатель"]
["ИНН 0000000000",null,null,null,null,null,null,null,null,"ИНН 0000000000"]
["ПО \"ПРТд\" ",null,null,null,null,null,null,null,null,"ООО \"Компания\""]
["Россия, Г.Санкт-Петербург Пр Римского-Корсакова ",null,null,null,null,null,null,null,null,"Россия, Саратов"]
["00002523653",null,null,null,{"$f":"\"*\"&A6&\"*\"","v":"*00002523653*"}]
["Номер партии",null,"Тарное место",null,"Документ отгрузки",null,null,"Дата",null,"Номер контейнера"]
[{"$f":"ПФЕП!N2","v":180011},null,3,null,"149560A8",null,null,43424,null,{"$f":"CONCATENATE($E$8,$A$8,C8)","v":"149560A81800113"}]
[null,null,null,null,{"$f":"\"*\"&E8&\"*\"","v":"*149560A8*"},null,null,null,null,{"$f":"\"*\"&J8&\"*\"","v":"*149560A81800113*"}]
["Номер детали",null,null,null,"Наименование",null,"Цвет, хар-ка (код)",null,null,null,"Вес нетто \n(кг)","Вес брутто (кг)","Кол-во \n(шт)"]
[{"$f":"Выборка!A1","v":"316300827564700"},null,null,null,{"$f":"Выборка!B1","v":"ОБОЛОЧКА ТЯГИ ПРИВОДА ЗАМКА КАПОТА С ПОВОДКОМ И ТЯГОЙ"},null,{"$f":"Выборка!G1","v":"099200004100107"},null,null,null,{"$f":"Выборка!J1","v":"100"},{"$f":"Выборка!K1","v":"110"},{"$f":"Выборка!D1","v":22160}]
[{"$f":"\"*\"&A11&\"*\"","v":"*316300827564700*"},null,null,null,null,null,{"$f":"\"*\"&G11&\"*\"","v":"*099200004100107*"},null,null,null,null,null,{"$f":"\"*\"&M11&\"*\"","v":"*22160*"}]
[{"$f":"Выборка!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"Выборка!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Выборка!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"Выборка!J31","v":0},{"$f":"Выборка!K31","v":0},{"$f":"Выборка!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"*\"&A13&\"*\"","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"\"*\"&G13&\"*\"","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"\"*\"&M13&\"*\"","v":{"$error":"#REF!"}}]
[{"$f":"Выборка!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"Выборка!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Выборка!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"Выборка!J32","v":0},{"$f":"Выборка!K32","v":0},{"$f":"Выборка!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"*\"&A15&\"*\"","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"\"*\"&G15&\"*\"","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"\"*\"&M15&\"*\"","v":{"$error":"#REF!"}}]
[{"$f":"Выборка!A31","v":0},null,null,null,{"$f":"Выборка!B31","v":0},null,{"$f":"Выборка!G32","v":0},null,null,null,{"$f":"Выборка!J33","v":0},{"$f":"Выборка!K33","v":0},{"$f":"Выборка!D31","v":0}]
[{"$f":"\"*\"&A17&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G17&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M17&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A32","v":0},null,null,null,{"$f":"Выборка!B32","v":0},null,{"$f":"Выборка!G33","v":0},null,null,null,{"$f":"Выборка!J34","v":0},{"$f":"Выборка!K34","v":0},{"$f":"Выборка!D32","v":0}]
[{"$f":"\"*\"&A19&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G19&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M19&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A33","v":0},null,null,null,{"$f":"Выборка!B33","v":0},null,{"$f":"Выборка!G34","v":0},null,null,null,{"$f":"Выборка!J35","v":0},{"$f":"Выборка!K35","v":0},{"$f":"Выборка!D33","v":0}]
[{"$f":"\"*\"&A21&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G21&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M21&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A34","v":0},null,null,null,{"$f":"Выборка!B34","v":0},null,{"$f":"Выборка!G35","v":0},null,null,null,{"$f":"Выборка!J36","v":0},{"$f":"Выборка!K36","v":0},{"$f":"Выборка!D34","v":0}]
[{"$f":"\"*\"&A23&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G23&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M23&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A35","v":0},null,null,null,{"$f":"Выборка!B35","v":0},null,{"$f":"Выборка!G36","v":0},null,null,null,{"$f":"Выборка!J37","v":0},{"$f":"Выборка!K37","v":0},{"$f":"Выборка!D35","v":0}]
[{"$f":"\"*\"&A25&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G25&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M25&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A36","v":0},null,null,null,{"$f":"Выборка!B36","v":0},null,{"$f":"Выборка!G37","v":0},null,null,null,{"$f":"Выборка!J38","v":0},{"$f":"Выборка!K38","v":0},{"$f":"Выборка!D36","v":0}]
[{"$f":"\"*\"&A27&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G27&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M27&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A37","v":0},null,null,null,{"$f":"Выборка!B37","v":0},null,{"$f":"Выборка!G38","v":0},null,null,null,{"$f":"Выборка!J39","v":0},{"$f":"Выборка!K39","v":0},{"$f":"Выборка!D37","v":0}]
[{"$f":"\"*\"&A29&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G29&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M29&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A38","v":0},null,null,null,{"$f":"Выборка!B38","v":0},null,{"$f":"Выборка!G39","v":0},null,null,null,{"$f":"Выборка!J40","v":0},{"$f":"Выборка!K40","v":0},{"$f":"Выборка!D38","v":0}]
[{"$f":"\"*\"&A31&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G31&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M31&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A39","v":0},null,null,null,{"$f":"Выборка!B39","v":0},null,{"$f":"Выборка!G40","v":0},null,null,null,{"$f":"Выборка!J41","v":0},{"$f":"Выборка!K41","v":0},{"$f":"Выборка!D39","v":0}]
[{"$f":"\"*\"&A33&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G33&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M33&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A40","v":0},null,null,null,{"$f":"Выборка!B40","v":0},null,{"$f":"Выборка!G41","v":0},null,null,null,{"$f":"Выборка!J42","v":0},{"$f":"Выборка!K42","v":0},{"$f":"Выборка!D40","v":0}]
[{"$f":"\"*\"&A35&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G35&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M35&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A41","v":0},null,null,null,{"$f":"Выборка!B41","v":0},null,{"$f":"Выборка!G42","v":0},null,null,null,{"$f":"Выборка!J43","v":0},{"$f":"Выборка!K43","v":0},{"$f":"Выборка!D41","v":0}]
[{"$f":"\"*\"&A37&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G37&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M37&\"*\"","v":"*0*"}]
[{"$f":"Выборка!A42","v":0},null,null,null,{"$f":"Выборка!B42","v":0},null,{"$f":"Выборка!G43","v":0},null,null,null,{"$f":"Выборка!J44","v":0},{"$f":"Выборка!K44","v":0},{"$f":"Выборка!D42","v":0}]
[{"$f":"\"*\"&A39&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&G39&\"*\"","v":"*0*"},null,null,null,null,null,{"$f":"\"*\"&M39&\"*\"","v":"*0*"}]

{"sheet":"На печать","index":4,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[14,0,14,6],[13,0,13,6],[3,0,3,3],[9,12,11,15],[0,0,0,6],[5,6,5,7],[12,0,12,6],[12,7,12,12],[0,7,0,12],[0,13,0,15],[1,0,1,6],[1,7,2,12],[1,13,1,15],[2,0,2,6],[2,13,2,15],[3,4,4,5],[3,6,4,7],[3,8,3,12],[3,13,3,15],[4,0,4,3],[4,8,4,12],[4,13,5,15],[5,0,5,3],[5,4,5,5],[5,8,5,12],[6,0,6,2],[6,3,8,7],[6,8,6,11],[6,12,6,15],[7,0,8,2],[7,8,11,11],[7,12,8,15],[9,0,11,7],[12,13,12,15],[13,7,14,12],[13,13,13,15],[14,13,14,15],[15,0,15,3],[15,4,16,5],[15,6,16,7],[15,8,15,12],[15,13,15,15],[16,0,16,3],[16,8,16,12],[16,13,17,15],[17,0,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,12],[18,12,18,15],[19,0,20,2],[19,8,23,11],[19,12,20,15],[21,0,23,7],[21,12,23,15],[18,0,18,2],[18,3,20,7],[18,8,18,11]]}
["Номер детали",null,null,null,null,null,null,"Наименование детали",null,null,null,null,null,"Количество"]
[{"$f":"Выборка!A1","v":"316300827564700"},null,null,null,null,null,null,{"$f":"Выборка!B1","v":"ОБОЛОЧКА ТЯГИ ПРИВОДА ЗАМКА КАПОТА С ПОВОДКОМ И ТЯГОЙ"},null,null,null,null,null,{"$f":"Выборка!C1","v":2160}]
[{"$f":"\"*\"&A2&\"*\"","v":"*316300827564700*"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"*\"&N2&\"*\"","v":"*2160*"}]
["тип тары",null,null,null,"Вес нетто (кг)",null,"Вес брутто (кг)",null,"Цвет, хар-ка (код)",null,null,null,null,"Дата"]
["*000001245638*",null,null,null,null,null,null,null,{"$f":"Выборка!G1","v":"099200004100107"},null,null,null,null,"2018-11-20"]
[{"$f":"Выборка!E1","v":"KLT3215-GK01"},null,null,null,{"$f":"Выборка!H1","v":"20"},null,{"$f":"Выборка!I1","v":"21"},null,{"$f":"I5","v":"099200004100107"}]
["Поставщик",null,null,{"$f":"\"*\"&A8&\"*\"","v":"*00002523654*"},null,null,null,null,"Получатель",null,null,null,"Номер детали поставщика"]
[{"$f":"TEXT(Выборка!Q1,\"00000000000\")","v":"00002523654"},null,null,null,null,null,null,null,"ООО \"Компания\"",null,null,null,{"$f":"Выборка!L1","v":"W57S99KM8B18A35"}]
[]
[{"$f":"Выборка!R1","v":"LLC WERTOGEN Otomobil Fabrika A.S., \nHongkong, 150-3 CHILKOI-DONG, PYUNGTAEK-SI, KYUNGKIG-DO"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"*\"&M8&\"*\"","v":"*W57S99KM8B18A35*"}]
[]
[]
["Номер детали",null,null,null,null,null,null,"Наименование детали",null,null,null,null,null,"Количество"]
[{"$f":"Выборка!A13","v":0},null,null,null,null,null,null,{"$f":"Выборка!B13","v":0},null,null,null,null,null,{"$f":"Выборка!C13","v":0}]
[{"$f":"\"*\"&A14&\"*\"","v":"*0*"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"*\"&N14&\"*\"","v":"*0*"}]
["тип тары",null,null,null,"Вес нетто (кг)",null,"Вес брутто (кг)",null,"Цвет, хар-ка (код)",null,null,null,null,"Дата"]
["*000001245638*",null,null,null,null,null,null,null,{"$f":"Выборка!G13","v":0},null,null,null,null,"2018-11-20"]
[{"$f":"Выборка!E13","v":0},null,null,null,{"$f":"Выборка!H13","v":0},null,{"$f":"Выборка!I13","v":0},null,{"$f":"I17","v":0}]
["Поставщик",null,null,{"$f":"\"*\"&A20&\"*\"","v":"*00000000000*"},null,null,null,null,"Получатель",null,null,null,"Номер детали поставщика"]
[{"$f":"TEXT(Выборка!Q13,\"00000000000\")","v":"00000000000"},null,null,null,null,null,null,null,"ООО \"Компания\"",null,null,null,{"$f":"Выборка!L13","v":0}]
[]
[{"$f":"Выборка!R13","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"*\"&M20&\"*\"","v":"*0*"}]

{"sheet":"Шаблон(АдресПоставки)","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,2],[2,0,2,2],[4,0,4,3],[1,3,3,3],[1,1,1,2]]}
["Номер детали",null,null,{"$f":"LEFT(Выборка!G1,18)","v":"099200004100107"}]
["Тара",{"$f":"Выборка!AL1","v":0}]
[{"$f":"CONCATENATE(Выборка!M1,\" - \",Выборка!N1)","v":"L-1495608 - 180011"}]
[{"$f":"Выборка!O1","v":3},{"$f":"Выборка!P1","v":43424},{"$f":"Выборка!Q1","v":2523654}]
[{"$f":"Выборка!J1","v":"100"}]

{"sheet":"АдресПоставки","index":6,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":true,"merged":[[18,0,18,2],[19,1,19,2],[19,3,21,3],[20,0,20,2],[12,0,12,2],[13,1,13,2],[13,3,15,3],[14,0,14,2],[16,0,16,3],[6,0,6,2],[7,1,7,2],[7,3,9,3],[8,0,8,2],[10,0,10,3],[0,0,0,2],[1,3,3,3],[4,0,4,3],[1,1,1,2],[2,0,2,2],[28,0,28,3],[30,0,30,2],[31,1,31,2],[31,3,33,3],[32,0,32,2],[22,0,22,3],[24,0,24,2],[25,1,25,2],[25,3,27,3],[26,0,26,2],[46,0,46,3],[34,0,34,3],[36,0,36,2],[37,1,37,2],[37,3,39,3],[38,0,38,2],[40,0,40,3],[42,0,42,2],[43,1,43,2],[43,3,45,3],[44,0,44,2]]}
["Номер детали",null,null,{"$f":"LEFT(Выборка!G1,18)","v":"099200004100107"}]
["Тара",{"$f":"Выборка!AL1","v":0}]
[{"$f":"CONCATENATE(Выборка!M1,\" - \",Выборка!N1)","v":"L-1495608 - 180011"}]
[{"$f":"Выборка!O1","v":3},{"$f":"Выборка!P1","v":43424},{"$f":"Выборка!Q1","v":2523654}]
[{"$f":"Выборка!J1","v":"100"}]
[]
["Номер детали",null,null,{"$f":"LEFT(Выборка!G88,18)","v":""}]
["Тара",{"$f":"Выборка!AL88","v":0}]
[{"$f":"CONCATENATE(Выборка!M88,\" - \",Выборка!N88)","v":" - "}]
[{"$f":"Выборка!O88","v":0},{"$f":"Выборка!P88","v":0},{"$f":"Выборка!Q88","v":0}]
[{"$f":"Выборка!J88","v":0}]
[]
["Номер детали",null,null,{"$f":"LEFT(Выборка!G94,18)","v":""}]
["Тара",{"$f":"Выборка!AL94","v":0}]
[{"$f":"CONCATENATE(Выборка!M94,\" - \",Выборка!N94)","v":" - "}]
[{"$f":"Выборка!O94","v":0},{"$f":"Выборка!P94","v":0},{"$f":"Выборка!Q94","v":0}]
[{"$f":"Выборка!J94","v":0}]
[]
["Номер детали",null,null,{"$f":"LEFT(Выборка!G100,18)","v":""}]
["Тара",{"$f":"Выборка!AL100","v":0}]
[{"$f":"CONCATENATE(Выборка!M100,\" - \",Выборка!N100)","v":" - "}]
[{"$f":"Выборка!O100","v":0},{"$f":"Выборка!P100","v":0},{"$f":"Выборка!Q100","v":0}]
[{"$f":"Выборка!J100","v":0}]
[]
["Номер детали",null,null,{"$f":"LEFT(Выборка!G106,18)","v":""}]
["Тара",{"$f":"Выборка!AL106","v":0}]
[{"$f":"CONCATENATE(Выборка!M106,\" - \",Выборка!N106)","v":" - "}]
[{"$f":"Выборка!O106","v":0},{"$f":"Выборка!P106","v":0},{"$f":"Выборка!Q106","v":0}]
[{"$f":"Выборка!J106","v":0}]
[]
["Номер детали",null,null,{"$f":"LEFT(Выборка!G112,18)","v":""}]
["Тара",{"$f":"Выборка!AL112","v":0}]
[{"$f":"CONCATENATE(Выборка!M112,\" - \",Выборка!N112)","v":" - "}]
[{"$f":"Выборка!O112","v":0},{"$f":"Выборка!P112","v":0},{"$f":"Выборка!Q112","v":0}]
[{"$f":"Выборка!J112","v":0}]
[]
["Номер детали",null,null,{"$f":"LEFT(Выборка!G118,18)","v":""}]
["Тара",{"$f":"Выборка!AL118","v":0}]
[{"$f":"CONCATENATE(Выборка!M118,\" - \",Выборка!N118)","v":" - "}]
[{"$f":"Выборка!O118","v":0},{"$f":"Выборка!P118","v":0},{"$f":"Выборка!Q118","v":0}]
[{"$f":"Выборка!J118","v":0}]
[]
["Номер детали",null,null,{"$f":"LEFT(Выборка!G124,18)","v":""}]
["Тара",{"$f":"Выборка!AL124","v":0}]
[{"$f":"CONCATENATE(Выборка!M124,\" - \",Выборка!N124)","v":" - "}]
[{"$f":"Выборка!O124","v":0},{"$f":"Выборка!P124","v":0},{"$f":"Выборка!Q124","v":0}]
[{"$f":"Выборка!J124","v":0}]