{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ввод данных для менеджеров","ввод данных для производства","справочник","макет пакетов","бланк для печати"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"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":"ввод данных для менеджеров","index":0,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[33,2,33,22],[31,2,31,22],[23,2,23,22],[26,2,26,22],[0,0,0,22],[29,2,29,22],[5,2,5,22],[12,2,12,22],[18,2,18,22],[8,2,8,22],[9,2,9,22],[19,2,19,22],[37,2,37,22],[30,2,30,22],[13,2,13,22],[27,2,27,22],[34,2,34,22],[35,2,35,22],[36,2,36,22],[14,2,14,22],[15,2,15,22],[16,2,16,22],[17,2,17,22],[22,2,22,22],[32,2,32,22],[28,2,28,22],[20,2,20,22],[21,2,21,22],[24,2,24,22],[25,2,25,22],[1,2,1,22],[2,2,2,22],[3,2,3,22],[4,2,4,22],[11,2,11,22],[10,2,10,22],[6,6,6,8],[7,6,7,8],[6,2,6,5],[7,2,7,5],[6,9,6,12],[7,9,7,12],[6,16,6,22],[7,16,7,22],[6,13,6,15],[7,13,7,15]]}
["ООО \"РТК-Пласт\""]
[1,"Бланк заказа №",340,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Не заполняем"]
[2,"Дата:","2019-03-11"]
[{"$f":"A3+1","v":3},"Фирма-заказчик:","Авида ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заполняем от руки"]
[{"$f":"A4+1","v":4},"Вид изделия:","пакет-майка"]
[5,"Материал изделия:","ПВД",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Выбираем из списка"]
[6,"Размер для клиента:",700,null,null,null,"х",null,null,800,null,null,null,"х",null,null,0.08]
[7,"Размер для производства:",700,null,null,null,"х",null,null,800,null,null,null,"х",null,null,7.0000000000000007E-2]
[8,"Контрольный вес пакета, гр:",{"$f":"C8*J8*2*Q8*Y28/1000","v":72.284800000000018}]
[9,"Размер вырубного ножа:","НЕТ"]
[10,"Вид пакета:","НЕТ"]
[11,"Вид сварного шва:","НЕТ"]
[12,"Цвет:","Голубой"]
[13,"Количество по заказу, шт:",5000]
[14,"Фактическое количество, шт:",5000]
[15,"max допуст. отклон. по кол-ву, %:",0.1]
[16,"Тиснение:","НЕТ"]
[17,"Высота донной складки, мм:"]
[18,"Цвет печати:"]
[19,"Тип печати:","прямая"]
[20,"Направление печати:","А1"]
[21,"Фотометки:","L1"]
[22,"Количество цветов печати:","1+0"]
[23,"Раппорт печати:",400]
[24,"Название макета:"]
[25,"Ручка:","НЕТ"]
[26,"Расстояние от верха пакета до вырубного края ручки,мм:"]
[27,"Количество пакетов в индивидуальной упаковке, шт:",200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6=\"ПНД\",0.95,0.922)","v":0.92200000000000004},"Плотность пленки"]
[28,"Количество пачек в групповой упаковке, пачки:"]
[29,"Подложка гофра:","ДА"]
[30,"Вес групповой упаковки, кг:",{"$f":"C28*C9/1000","v":14.456960000000002}]
[31,"Информация на упаковке (размер):"]
[32,"Цена за изготовления 1000шт, руб.:",50]
[33,"Бирки согласно спецификации:","ГОСТ 12302-2013"]
[34,"Особые требования:"]
[35,"Срок изготовления:"]
[36,"Условное название заказа:"]
[37,"Перечень сопроводительных документов:","полный пакет документов"]

{"sheet":"ввод данных для производства","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[16,0,16,2],[23,0,23,2],[24,0,24,2],[25,0,25,1],[25,2,25,3],[20,0,20,2],[30,0,30,1],[31,0,31,1],[32,0,32,1],[0,0,0,3],[19,0,19,2],[21,0,21,2],[28,0,28,1],[1,0,14,0],[1,1,1,3],[29,0,29,1],[27,0,27,1],[15,0,15,2],[17,0,17,2],[18,0,18,2],[26,0,26,1],[22,0,22,2]]}
["ООО \"РТК-Пласт\""]
["рецептура"]
[null,"наименование ","процент","Вес, кг"]
[null,null,{"$f":"IF($D$15=0,0,D4*100/$D$15/100)","v":0},null,null,null,"Не заполняем"]
[null,null,{"$f":"IF($D$15=0,0,D5*100/$D$15/100)","v":0}]
[null,null,0,null,null,null,"Заполняем от руки"]
[null,null,0]
[null,null,0,null,null,null,"Выбираем из списка"]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,"ИТОГО",{"$f":"SUM(C4:C14)","v":0},{"$f":"SUM(D4:D14)","v":0}]
["Остаток п/ф:"]
["Остаток пакетов:"]
["Особые требования:"]
["Размер стабилизатора:"]
["Размер рулонов, кг:"]
["Оборудования для экструзии:",null,null,"ЛРП2"]
["Оборудование для пакетов:",null,null,"ТПЛ4"]
["Отклонение по весу пакета:"]
["Количество групповых упаковок на поддоне:"]
["Количество поддонов:"]
["Упаковка:"]
["Вес групповой упаковки:",null,{"$f":"'ввод данных для менеджеров'!C31","v":14.456960000000002}]
["Цена за изготовления 1000шт пакетов, руб.:",null,{"$f":"'ввод данных для менеджеров'!C33","v":50}]
["Напраление печати:",null,{"$f":"'ввод данных для менеджеров'!C21","v":"А1"},"А1"]
["Фотометки:",null,{"$f":"'ввод данных для менеджеров'!C22","v":"L1"},"НЕТ"]
["Фактически делать, кг.:",null,{"$f":"C32/1000*'ввод данных для менеджеров'!C15","v":361.42400000000009},{"$f":"C31+C31*2%","v":368.65248000000008},"+2%"]
["Контрольный вес, гр.:",null,{"$f":"'ввод данных для менеджеров'!C9:W9","v":72.284800000000018}]
["Вид изделия",null,"рукав"]

{"sheet":"справочник","index":2,"n_rows":17,"n_cols":35,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Вид изделия",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,"100х55",null,"НЕТ",null,"НЕТ",null,"НЕТ",null,"НЕТ",null,"ЛРП1",null,"ТПЛ1",null,"НЕТ",null,"НЕТ"]
["пакет-майка",null,"ПВД",null,"НЕТ",null,"Вырубная усиленная ручка",null,"ГОСТ 12302-2013",null,"полный пакет документов",null,100,null,400,null,"100х65",null,"прямая",null,"1+0",null,"А1",null,"L1",null,"ЛРП2",null,"ТПЛ3",null,"Одношовный",null,"Однорядный",null,"рукав"]
[null,null,null,null,null,null,"Вырубная неусиленная ручка",null,"ГОСТ 19360-74",null,"паспорт+сертификат",null,120,null,450,null,"120х60",null,"обратная",null,"1+1",null,"А2",null,"L2",null,"ЛРП3",null,"ТПЛ4",null,"Двухшовный",null,"Двухрядный",null,"п/рукав"]
[null,null,null,null,null,null,null,null,null,null,"паспорт",null,140,null,500,null,"50х30",null,null,null,"2+0",null,"В1",null,"R1",null,"ЛРП4",null,"ТПЛ5",null,null,null,"Трехрядный",null,"полотно"]
[null,null,null,null,null,null,null,null,null,null,null,null,150,null,550,null,"80х47",null,null,null,"2+1",null,"В2",null,"R2",null,"ЛРП5",null,"МС1",null,null,null,null,null,"дв.полотно"]
[null,null,null,null,null,null,null,null,null,null,null,null,160,null,565,null,"85х65",null,null,null,"2+2",null,"С1",null,"LR1",null,"ЛРП6",null,"МС2"]
[null,null,null,null,null,null,null,null,null,null,null,null,170,null,600,null,null,null,null,null,"3+0",null,"С2",null,"LR2"]
[null,null,null,null,null,null,null,null,null,null,null,null,180,null,620,null,null,null,null,null,"3+1",null,"D1"]
[null,null,null,null,null,null,null,null,null,null,null,null,190,null,650,null,null,null,null,null,null,null,"D2"]
[null,null,null,null,null,null,null,null,null,null,null,null,210,null,700,null,null,null,null,null,null,null,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,220,null,750,null,null,null,null,null,null,null,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,240,null,800,null,null,null,null,null,null,null,"F1"]
[null,null,null,null,null,null,null,null,null,null,null,null,260,null,900,null,null,null,null,null,null,null,"F2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"80х20",null,1075]
[null,null,null,null,null,null,null,null,null,null,null,null,"88х20"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Круг диаметром 70"]

{"sheet":"макет пакетов","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"бланк для печати","index":4,"n_rows":74,"n_cols":43,"rows_kept":74,"cut":false,"hidden":false,"merged":[[34,40,34,44],[35,1,35,9],[34,11,34,13],[34,17,34,19],[34,24,34,26],[34,28,34,30],[34,1,34,4],[25,37,25,40],[27,9,27,12],[26,10,26,14],[25,17,25,27],[20,29,20,32],[21,30,21,34],[22,39,22,44],[20,22,20,25],[20,26,20,27],[26,1,26,9],[26,15,26,21],[27,1,27,8],[27,24,27,28],[27,29,27,31],[20,1,20,4],[22,1,22,8],[25,1,25,11],[25,12,25,15],[25,32,25,36],[21,24,21,28],[20,41,20,44],[20,33,20,39],[24,24,24,31],[24,33,24,36],[19,35,19,44],[18,13,18,44],[15,1,15,12],[15,13,15,22],[15,23,15,34],[15,35,15,44],[16,1,16,12],[16,13,16,22],[16,23,16,34],[16,35,16,44],[17,1,17,12],[17,13,17,22],[17,23,17,34],[17,35,17,44],[18,1,18,12],[19,1,19,12],[8,35,8,44],[19,13,19,22],[19,23,19,34],[12,35,12,44],[10,13,10,44],[13,1,13,12],[13,13,13,22],[13,23,13,34],[13,35,13,44],[10,1,10,12],[11,13,11,22],[12,1,12,12],[12,13,12,22],[12,23,12,34],[9,1,9,12],[9,13,9,22],[9,23,9,34],[9,35,9,44],[8,1,8,12],[8,23,8,34],[8,13,8,22],[5,13,5,22],[1,23,1,34],[4,14,4,16],[4,20,4,22],[4,27,4,29],[1,1,1,12],[2,1,2,12],[3,1,3,12],[6,1,6,12],[4,1,4,12],[5,1,5,12],[4,31,4,33],[0,0,0,44],[1,0,19,0],[7,1,7,12],[7,13,7,22],[5,23,5,34],[5,35,5,44],[7,23,7,34],[7,35,7,44],[14,1,14,12],[14,13,14,22],[14,23,14,34],[14,35,14,44],[11,1,11,12],[11,35,11,44],[11,23,11,34],[1,35,1,44],[2,13,2,44],[3,23,3,34],[6,23,6,34],[3,35,3,44],[6,35,6,44],[1,13,1,22],[3,13,3,22],[6,13,6,22],[21,1,21,10],[21,11,21,14],[21,15,21,16],[21,18,21,23],[37,1,37,4],[39,5,39,8],[24,1,24,4],[23,1,23,8],[23,9,23,12],[37,5,37,44],[39,1,39,4],[34,5,34,9],[35,11,35,16],[35,17,35,19],[35,34,35,38],[35,39,35,41],[35,42,35,44],[36,1,36,5],[22,34,22,38],[23,13,23,14],[23,21,23,24],[23,15,23,20],[22,9,22,23],[22,24,22,33],[56,1,56,4],[40,41,40,44],[41,1,41,24],[41,25,41,44],[38,1,38,44],[20,0,41,0],[40,1,40,4],[40,5,40,8],[40,9,40,12],[40,13,40,16],[40,17,40,20],[40,21,40,24],[40,25,40,28],[40,29,40,32],[40,33,40,36],[39,9,39,12],[39,13,39,16],[39,17,39,20],[39,21,39,24],[39,25,39,28],[39,29,39,32],[39,33,39,36],[39,37,39,40],[39,41,39,44],[40,37,40,40],[53,24,53,28],[53,30,53,34],[54,1,54,8],[54,9,54,23],[54,24,54,33],[54,34,54,38],[54,39,54,44],[55,1,55,8],[55,9,55,12],[55,13,55,14],[55,15,55,20],[55,21,55,24],[67,32,67,33],[67,34,67,38],[67,39,67,41],[67,42,67,44],[57,37,57,40],[58,1,58,9],[58,10,58,14],[58,15,58,21],[59,1,59,8],[59,9,59,12],[59,24,59,28],[59,29,59,31],[71,9,71,12],[71,13,71,16],[71,17,71,20],[71,21,71,24],[69,5,69,44],[70,1,70,44],[69,1,69,4],[66,1,66,4],[66,5,66,9],[66,11,66,13],[66,17,66,19],[66,24,66,26],[66,28,66,30],[66,31,66,39],[68,1,68,5],[68,6,68,9],[68,11,68,17],[68,18,68,21],[66,40,66,44],[67,1,67,9],[67,11,67,16],[67,17,67,19],[67,20,67,28],[67,29,67,31],[57,12,57,15],[57,17,57,27],[57,28,57,31],[57,32,57,36],[56,5,56,10],[56,11,56,14],[56,16,56,19],[43,0,50,0],[43,1,46,44],[47,1,50,44],[52,0,73,0],[52,1,52,4],[52,22,52,25],[52,26,52,27],[52,29,52,32],[52,33,52,39],[52,41,52,44],[53,1,53,10],[53,11,53,14],[53,15,53,16],[53,18,53,23],[72,1,72,4],[71,1,71,4],[71,5,71,8],[20,5,20,10],[20,11,20,14],[20,16,20,19],[20,20,20,21],[73,1,73,24],[73,25,73,44],[71,25,71,28],[71,29,71,32],[71,33,71,36],[71,37,71,40],[71,41,71,44],[72,5,72,8],[72,9,72,12],[72,13,72,16],[72,17,72,20],[72,21,72,24],[72,25,72,28],[72,29,72,32],[72,33,72,36],[72,37,72,40],[72,41,72,44],[56,24,56,31],[56,33,56,36],[57,1,57,11],[56,20,56,21],[24,5,24,10],[24,11,24,14],[24,16,24,19],[35,20,35,33],[52,5,52,10],[52,11,52,14],[52,16,52,19],[52,20,52,21],[25,28,25,31],[36,6,36,9],[36,11,36,17],[36,18,36,21],[34,31,34,39]]}
["ООО \"РТК-Пласт\""]
["Коммерческий отдел","Бланк заказа№",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!$C$2","v":340},null,null,null,null,null,null,null,null,null,"Дата выдачи заказа на пр-во:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C3","v":"2019-03-11"}]
[null,"Фирма-заказчик:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!$C$4","v":"Авида "}]
[null,"Вид изделия:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!$C$5","v":"пакет-майка"},null,null,null,null,null,null,null,null,null,"Материал изделия",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C6","v":"ПВД"}]
[null,"Размер:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C8","v":700},null,null,{"$f":"'ввод данных для менеджеров'!G8","v":"х"},{"$f":"'ввод данных для менеджеров'!H8","v":0},{"$f":"'ввод данных для менеджеров'!I8","v":0},{"$f":"'ввод данных для менеджеров'!J8","v":800},null,null,{"$f":"'ввод данных для менеджеров'!M8","v":0},{"$f":"'ввод данных для менеджеров'!N8","v":"х"},{"$f":"'ввод данных для менеджеров'!O8","v":0},{"$f":"'ввод данных для менеджеров'!P8","v":0},{"$f":"'ввод данных для менеджеров'!Q8","v":7.0000000000000007E-2},null,null,{"$f":"'ввод данных для менеджеров'!T8","v":0},{"$f":"'ввод данных для менеджеров'!U7","v":0}]
[null,{"$f":"'ввод данных для менеджеров'!B15","v":"Фактическое количество, шт:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!$C$15","v":5000},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B16","v":"max допуст. отклон. по кол-ву, %:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C16","v":0.1}]
[null,"Цвет:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!$C$13","v":"Голубой"},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B9","v":"Контрольный вес пакета, гр:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C9","v":72.284800000000018}]
[null,"Тиснение:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!$C$17","v":"НЕТ"}]
[null,{"$f":"'ввод данных для менеджеров'!B25","v":"Название макета:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C25","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B20","v":"Тип печати:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C20","v":"прямая"}]
[null,{"$f":"'ввод данных для менеджеров'!B23","v":"Количество цветов печати:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C23","v":"1+0"},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B24","v":"Раппорт печати:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C24","v":400}]
[null,{"$f":"'ввод данных для менеджеров'!B19","v":"Цвет печати:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C19","v":0}]
[null,{"$f":"'ввод данных для менеджеров'!B21","v":"Направление печати:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для производства'!D29","v":"А1"},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B22","v":"Фотометки:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для производства'!D30","v":"НЕТ"}]
[null,{"$f":"'ввод данных для менеджеров'!B10","v":"Размер вырубного ножа:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C10","v":"НЕТ"},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B18","v":"Высота донной складки, мм:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C18","v":0}]
[null,{"$f":"'ввод данных для менеджеров'!B26","v":"Ручка:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C26","v":"НЕТ"},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B27","v":"Расстояние от верха пакета до вырубного края ручки,мм:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C27","v":0}]
[null,{"$f":"'ввод данных для менеджеров'!B27","v":"Расстояние от верха пакета до вырубного края ручки,мм:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C27","v":0}]
[null,{"$f":"'ввод данных для менеджеров'!B28","v":"Количество пакетов в индивидуальной упаковке, шт:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C28","v":200},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B29","v":"Количество пачек в групповой упаковке, пачки:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C29","v":0}]
[null,{"$f":"'ввод данных для менеджеров'!B32","v":"Информация на упаковке (размер):"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C32","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для производства'!A28","v":"Цена за изготовления 1000шт пакетов, руб.:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для производства'!D28","v":0}]
[null,{"$f":"'ввод данных для менеджеров'!B34","v":"Бирки согласно спецификации:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C34","v":"ГОСТ 12302-2013"},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B38","v":"Перечень сопроводительных документов:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C38","v":"полный пакет документов"}]
[null,{"$f":"'ввод данных для менеджеров'!B35","v":"Особые требования:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!$C$35","v":0}]
[null,{"$f":"'ввод данных для менеджеров'!B37","v":"Условное название заказа:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C37","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B36","v":"Срок изготовления:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C36","v":"00:00:00"}]
["Производство","Делать:",null,null,null,{"$f":"'ввод данных для производства'!C33","v":"рукав"},null,null,null,null,null,{"$f":"O5","v":700},null,null,null,"х",{"$f":"AB5","v":7.0000000000000007E-2},null,null,null,"мкм",null,"(толщина:",null,null,null,{"$f":"ROUNDDOWN(($Q$21*1000)-($Q$21*1000)*5%,0)","v":66},null,"-",{"$f":"ROUNDUP(($Q$21*1000)+($Q$21*1000)*5%,0)","v":74},null,null,null,{"$f":"N7","v":"Голубой"},null,null,null,null,null,null,"-",{"$f":"'ввод данных для производства'!D31","v":368.65248000000008}]
[null,"в индивидуальную упаковку; ",null,null,null,null,null,null,null,null,null,{"$f":"B8","v":"Тиснение:"},null,null,null,{"$f":"N8","v":"НЕТ"},null,";","контрольный вес :",null,null,null,null,null,{"$f":"U5","v":800},null,null,null,null,"=",{"$f":"'ввод данных для производства'!C32","v":72.284800000000018},null,null,null,null,";"]
[null,"рулоны подписывать:",null,null,null,null,null,null,null,{"$f":"N9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"размер рулона:",null,null,null,null,null,{"$f":"'ввод данных для производства'!$D$20","v":0}]
[null,"Печать:",null,null,null,{"$f":"F21","v":"рукав"},null,null,null,null,null,{"$f":"L21","v":700},null,null,null,"х",{"$f":"Q21","v":7.0000000000000007E-2},null,null,null,null,null,null,null,{"$f":"AH21","v":"Голубой"},null,null,null,null,null,null,null,"-",{"$f":"AP21","v":368.65248000000008}]
[null,"максимальное число оттисков:",null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C15*1.1+500","v":6000},null,null,null,";",{"$f":"IF(AJ10=\"нет\",0,AJ10)","v":400},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N10=\"нет\",0,N10)","v":"1+0"},null,null,null,{"$f":"X9","v":"Тип печати:"},null,null,null,null,{"$f":"IF(AJ9=\"НЕТ\",0,AJ9)","v":"прямая"}]
[null,"согласно макета заказа:",null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C2","v":340},null,null,null,null,{"$f":"'бланк для печати'!N9","v":0}]
[null,{"$f":"B12","v":"Направление печати:"},null,null,null,null,null,null,null,{"$f":"IF(N12=\"НЕТ\",0,N12)","v":"А1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X12","v":"Фотометки:"},null,null,null,null,{"$f":"IF(AJ12=\"НЕТ\",0,AJ12)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'ввод данных для производства'!D22","v":"ТПЛ4"},null,null,null,{"$f":"N4","v":"пакет-майка"},null,null,null,null,{"$f":"N5","v":0},{"$f":"O5","v":700},null,null,"х",0,0,800,null,null,0,"х",0,0,{"$f":"'ввод данных для менеджеров'!Q7","v":0.08},null,null,0,{"$f":"AF5","v":0},null,null,"( согласно макета заказа",null,null,null,null,null,null,null,null,{"$f":"N2","v":340}]
[null,{"$f":"N9","v":0},null,null,null,null,null,null,null,null,")",{"$f":"N6","v":5000},null,null,null,null,null,{"$f":"$AJ$6","v":0.1},null,null,"Контрольный вес:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C5","v":"пакет-майка"},null,null,null,null,{"$f":"$AJ$7","v":72.284800000000018},null,null,{"$f":"'ввод данных для производства'!D23","v":0}]
[null,{"$f":"'ввод данных для производства'!A16","v":"Остаток п/ф:"},null,null,null,null,{"$f":"'ввод данных для производства'!D16","v":0},null,null,null,";",{"$f":"'ввод данных для производства'!A17","v":"Остаток пакетов:"},null,null,null,null,null,null,{"$f":"'ввод данных для производства'!D17","v":0},null,null,null,"."]
[null,"Упаковка:",null,null,null,{"$f":"'ввод данных для производства'!C26","v":0}]
[null,"Рецептура:"]
[null,{"$f":"'ввод данных для производства'!B4","v":0},null,null,null,{"$f":"'ввод данных для производства'!B5","v":0},null,null,null,{"$f":"'ввод данных для производства'!B6","v":0},null,null,null,{"$f":"'ввод данных для производства'!B7","v":0},null,null,null,{"$f":"'ввод данных для производства'!B8","v":0},null,null,null,{"$f":"'ввод данных для производства'!B9","v":0},null,null,null,{"$f":"'ввод данных для производства'!B10","v":0},null,null,null,{"$f":"'ввод данных для производства'!B11","v":0},null,null,null,{"$f":"'ввод данных для производства'!B12","v":0},null,null,null,{"$f":"'ввод данных для производства'!B13","v":0},null,null,null,{"$f":"'ввод данных для производства'!B14","v":0}]
[null,{"$f":"'ввод данных для производства'!D4","v":0},null,null,null,{"$f":"'ввод данных для производства'!D5","v":0},null,null,null,{"$f":"'ввод данных для производства'!D6","v":0},null,null,null,{"$f":"'ввод данных для производства'!D7","v":0},null,null,null,{"$f":"'ввод данных для производства'!D8","v":0},null,null,null,{"$f":"'ввод данных для производства'!D9","v":0},null,null,null,{"$f":"'ввод данных для производства'!D10","v":0},null,null,null,{"$f":"'ввод данных для производства'!D11","v":0},null,null,null,{"$f":"'ввод данных для производства'!D12","v":0},null,null,null,{"$f":"'ввод данных для производства'!D13","v":0},null,null,null,{"$f":"'ввод данных для производства'!D14","v":0}]
[null,{"$f":"SUM(B41:AS41)","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,{"$f":"'ввод данных для производства'!C15","v":0}]
[]
["ОТК","Рекомендации ОТК:"]
[]
[]
[]
[null,"Отгружено:"]
[]
[]
[]
[]
["Производство","Делать:",null,null,null,{"$f":"'ввод данных для производства'!C33","v":"рукав"},null,null,null,null,null,{"$f":"O5","v":700},null,null,null,"х",{"$f":"AB5","v":7.0000000000000007E-2},null,null,null,"мкм",null,"(толщина:",null,null,null,{"$f":"ROUNDDOWN(($Q$21*1000)-($Q$21*1000)*5%,0)","v":66},null,"-",{"$f":"ROUNDUP(($Q$21*1000)+($Q$21*1000)*5%,0)","v":74},null,null,null,{"$f":"N7","v":"Голубой"},null,null,null,null,null,null,"-",{"$f":"'ввод данных для производства'!D31","v":368.65248000000008}]
[null,"в индивидуальную упаковку; ",null,null,null,null,null,null,null,null,null,{"$f":"B8","v":"Тиснение:"},null,null,null,{"$f":"N8","v":"НЕТ"},null,";","контрольный вес :",null,null,null,null,null,{"$f":"U5","v":800},null,null,null,null,"=",{"$f":"'ввод данных для производства'!C32","v":72.284800000000018},null,null,null,null,";"]
[null,"рулоны подписывать:",null,null,null,null,null,null,null,{"$f":"N9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"размер рулона:",null,null,null,null,null,{"$f":"'ввод данных для производства'!$D$20","v":0}]
[null,"Печать:",null,null,null,{"$f":"F53","v":"рукав"},null,null,null,null,null,{"$f":"L53","v":700},null,null,null,"х",{"$f":"Q53","v":7.0000000000000007E-2},null,null,null,"мкм",null,null,null,{"$f":"AH53","v":"Голубой"},null,null,null,null,null,null,null,"-",{"$f":"AP53","v":368.65248000000008}]
[null,"максимальное число оттисков:",null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C15*1.1+500","v":6000},null,null,null,";",{"$f":"IF(AJ10=\"нет\",0,AJ10)","v":400},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N10=\"нет\",0,N10)","v":"1+0"},null,null,null,{"$f":"X9","v":"Тип печати:"},null,null,null,null,{"$f":"IF(AJ9=\"НЕТ\",0,AJ9)","v":"прямая"}]
[null,"согласно макета заказа:",null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C2","v":340},null,null,null,null,{"$f":"'бланк для печати'!N9","v":0}]
[null,{"$f":"B12","v":"Направление печати:"},null,null,null,null,null,null,null,{"$f":"IF(N12=\"НЕТ\",0,N12)","v":"А1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X12","v":"Фотометки:"},null,null,null,null,{"$f":"IF(AJ44=\"НЕТ\",0,AJ44)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'ввод данных для производства'!D22","v":"ТПЛ4"},null,null,null,{"$f":"N4","v":"пакет-майка"},null,null,null,null,{"$f":"N5","v":0},{"$f":"O5","v":700},null,null,{"$f":"R5","v":"х"},{"$f":"S5","v":0},{"$f":"T5","v":0},{"$f":"U5","v":800},null,null,{"$f":"X5","v":0},{"$f":"Y5","v":"х"},{"$f":"Z5","v":0},{"$f":"AA5","v":0},{"$f":"'ввод данных для менеджеров'!Q7","v":0.08},null,null,{"$f":"AE5","v":0},{"$f":"AF5","v":0},null,null,"( согласно макета заказа",null,null,null,null,null,null,null,null,{"$f":"N2","v":340}]
[null,{"$f":"N9","v":0},null,null,null,null,null,null,null,null,")",{"$f":"N6","v":5000},null,null,null,null,null,{"$f":"$AJ$6","v":0.1},null,null,{"$f":"'ввод данных для менеджеров'!B10","v":"Размер вырубного ножа:"},null,null,null,null,null,null,null,null,{"$f":"IF('ввод данных для менеджеров'!$C$10=\"нет\",0,'ввод данных для менеджеров'!$C$10)","v":0},null,null,"вес:",null,{"$f":"N4","v":"пакет-майка"},null,null,null,null,{"$f":"$AJ$7","v":72.284800000000018},null,null,{"$f":"'ввод данных для производства'!D23","v":0}]
[null,{"$f":"'ввод данных для производства'!A16","v":"Остаток п/ф:"},null,null,null,null,{"$f":"'ввод данных для производства'!D16","v":0},null,null,null,";",{"$f":"'ввод данных для производства'!A16","v":"Остаток п/ф:"},null,null,null,null,null,null,{"$f":"'ввод данных для производства'!D17","v":0},null,null,null,"."]
[null,"Упаковка:",null,null,null,{"$f":"'ввод данных для производства'!C26","v":0}]
[null,"Рецептура:"]
[null,{"$f":"B40","v":0},null,null,null,{"$f":"F40","v":0},null,null,null,{"$f":"J40","v":0},null,null,null,{"$f":"N40","v":0},null,null,null,{"$f":"R40","v":0},null,null,null,{"$f":"V40","v":0},null,null,null,{"$f":"Z40","v":0},null,null,null,{"$f":"AD40","v":0},null,null,null,{"$f":"AH40","v":0},null,null,null,{"$f":"AL40","v":0},null,null,null,{"$f":"AP40","v":0}]
[null,{"$f":"B41","v":0},null,null,null,{"$f":"F41","v":0},null,null,null,{"$f":"J41","v":0},null,null,null,{"$f":"N41","v":0},null,null,null,{"$f":"R41","v":0},null,null,null,{"$f":"V41","v":0},null,null,null,{"$f":"Z41","v":0},null,null,null,{"$f":"AD41","v":0},null,null,null,{"$f":"AH41","v":0},null,null,null,{"$f":"AL41","v":0},null,null,null,{"$f":"AP41","v":0}]
[null,{"$f":"B42","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,{"$f":"Z42","v":0}]