{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ввод данных для менеджеров","ввод данных для производства","справочник","бланк для печати","сырье","рецептура"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":207,"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":24,"n_cols":25,"rows_kept":24,"cut":false,"hidden":false,"merged":[[9,18,9,19],[9,2,9,3],[6,6,6,7],[6,8,6,9],[9,20,9,21],[10,2,10,3],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,17],[10,18,10,19],[10,20,10,21],[9,12,9,13],[9,14,9,15],[9,16,9,17],[8,2,8,3],[8,8,8,9],[8,10,8,11],[8,12,8,13],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[7,12,7,13],[7,14,7,15],[7,16,7,17],[7,18,7,19],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[16,2,16,21],[14,2,14,21],[15,2,15,21],[12,2,12,21],[1,2,1,21],[2,2,2,21],[3,2,3,21],[4,2,4,21],[7,20,7,21],[11,2,11,21],[6,2,6,3],[6,4,6,5],[6,10,6,11],[6,12,6,13],[6,14,6,15],[6,16,6,17],[13,2,13,21],[0,0,0,21],[6,20,6,21],[6,18,6,19],[8,14,8,15],[8,16,8,17],[8,18,8,19],[7,2,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[8,4,8,5],[8,6,8,7],[8,20,8,21],[5,2,5,3],[22,3,22,21],[23,3,23,21],[17,3,17,21],[18,3,18,21],[19,3,19,21],[20,3,20,21],[21,3,21,21]]}
["ООО \"РТК-Пласт\""]
[1,"Бланк заказа №",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Не заполняем"]
[2,"Дата:"]
[{"$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,"Диаметр:"]
[7,"Толщина стенки:"]
[8,"Колличество:"]
[9,"Метраж:"]
[10,"Цвет трубы:"]
[11,"Маркировка:","без РТК-Пласт ГОСТ18599-2001"]
[12,"Формат упаковки:","Скотч+Стрейч"]
[13,"Бирки согласно спецификации:","Без РТК-Пласт ГОСТ18599-2001"]
[14,"Особые требования:"]
[15,"Срок изготовления:"]
[16,"Перечень сопроводительных документов. \nНужное выделить и подчеркнуть:","чтобы выбрать набор документов, в ячейке выделенной красным цветом поставить знак \"-\""]
[null,null,null,"паспорт качества; "]
[null,null,null,"сертификат соответствия; "]
[null,null,null,"протокол испытаний, на основании которого выдан сертификат; "]
[null,null,null,"свидетельство о государственной регистрации (СГР); "]
[null,null,null,"экспертное заключение на основании которого выдано СГР; "]
[null,null,null,"протокол испытаний на основании которого выдано экспертное заключение СГР; "]
[null,null,null,"без документов.  "]

{"sheet":"ввод данных для производства","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[23,0,23,1],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,1],[22,2,22,4],[18,0,18,2],[0,0,0,4],[17,0,17,2],[1,0,14,0],[1,1,1,4],[15,0,15,2],[16,0,16,2],[15,3,15,4],[16,3,16,4],[17,3,17,4]]}
["ООО \"РТК-Пласт\""]
["рецептура",1,null,null,null,"-","номер рецептуры"]
[null,"наименование ","процент",null,"Вес, кг"]
[null,{"$f":"INDEX(рецептура!F:F,MATCH(B2,рецептура!A:A,0),1):INDEX(рецептура!F:F,MATCH(B2,рецептура!A:A,0)+10,1)","v":"сырье 1"},{"$f":"IF($E$15=0,0,E4*100/$E$15/100)","v":0.25},null,{"$f":"INDEX(рецептура!H:H,MATCH($B$2,рецептура!A:A,0),1):INDEX(рецептура!H:H,MATCH($B$2,рецептура!A:A,0)+10,1)","v":1},null,null,"Не заполняем"]
[null,"сырье 2",{"$f":"IF($E$15=0,0,E5*100/$E$15/100)","v":0},null,0]
[null,"сырье 2",0.75,null,3,null,null,"Заполняем от руки"]
[null,0,0,null,0]
[null,0,0,null,0,null,null,"Выбираем из списка"]
[null,0,0,null,0]
[null,0,0,null,0]
[null,0,0,null,0]
[null,0,0,null,0]
[null,0,0,null,0]
[null,0,0,null,0]
[null,"ИТОГО",{"$f":"SUM(C4:C14)","v":1},null,{"$f":"SUM(E4:E14)","v":4}]
["Выделить заказ:",null,null,"Красный скотч"]
["Размер стабилизатора:"]
["Размер рулонов, кг:"]
["Оборудования для экструзии:",null,null,"ЛТ-2"]
["Отклонение по весу пакета:"]
["Количество групповых упаковок на поддоне:"]
["Количество поддонов:"]
["Упаковка:"]

{"sheet":"справочник","index":2,"n_rows":40,"n_cols":33,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Вид изделия",null,"Материал изделия",null,"да/нет",null,"Бирка",null,"Цвет трубы",null,"сопроводительные документы",null,"Толщина стенки",null,"Раппотр",null,"Размер стабилизатора",null,"Тип печати",null,"Метраж",null,"Диаметр трубы",null,"Фотометки",null,"Оборудование экструзии",null,"Оборудование для пакетов",null,"Вид пакета",null,"Вид сварного шва"]
["пакет",null,"ПНД",null,"Лента+Стрейч",null,"ГОСТ18599-2001",null,"Черная",null,"Без документов",null,1.2,null,"НЕТ",null,"100х55",null,"ПЭ100",null,10,null,16,null,"НЕТ",null,"ЛТ-1",null,"ТПЛ1",null,"Полная ГОСТ18599-2001",null,"НЕТ"]
["пакет-майка",null,"ПВД",null,"Лента",null,"Без бирок",null,"Синяя",null,"полный пакет документов",null,2,null,400,null,"100х65",null,"ПЭ80",null,15,null,20,null,"L1",null,"ЛТ-2",null,"ТПЛ3",null,"без РТК-Пласт ГОСТ18599-2001",null,"Желтый скотч"]
[null,null,null,null,"Скотч",null,"Без РТК-Пласт ГОСТ18599-2001",null,"Серая",null,"паспорт+сертификат",null,2.2999999999999998,null,450,null,"120х60",null,"ПЭ32",null,25,null,25,null,"L2",null,null,null,"ТПЛ4",null,"Метраж    Ø+толщина       дата",null,"Красный скотч"]
[null,null,null,null,"Скотч+Стрейч",null,null,null,"Зеленая",null,"паспорт",null,2.4,null,500,null,"50х30",null,"--",null,50,null,32,null,"R1",null,null,null,"ТПЛ5"]
[null,null,null,null,null,null,null,null,"Другой",null,null,null,2.5,null,550,null,"80х47",null,null,null,100,null,40,null,"R2",null,null,null,"МС1"]
[null,null,null,null,null,null,null,null,null,null,null,null,2.7,null,565,null,"85х65",null,null,null,150,null,50,null,"LR1",null,null,null,"МС2"]
[null,null,null,null,null,null,null,null,null,null,null,null,2.8,null,600,null,null,null,null,null,200,null,63,null,"LR2"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,null,620,null,null,null,null,null,250,null,75]
[null,null,null,null,null,null,null,null,null,null,null,null,3.4,null,650,null,null,null,null,null,300,null,80]
[null,null,null,null,null,null,null,null,null,null,null,null,3.6,null,700,null,null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,null,null,null,3.7,null,750,null,null,null,null,null,null,null,110]
[null,null,null,null,null,null,null,null,null,null,null,null,3.8,null,800]
[null,null,null,null,null,null,null,null,null,null,null,null,4.2,null,900]
[null,null,null,null,null,null,null,null,null,null,null,null,4.3,null,1075]
[null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,null,null,null,null,null,null,null,null,null,null,null,4.5999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,4.7]
[null,null,null,null,null,null,null,null,null,null,null,null,5.3]
[null,null,null,null,null,null,null,null,null,null,null,null,5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,5.8]
[null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,6.6]
[null,null,null,null,null,null,null,null,null,null,null,null,6.7]
[null,null,null,null,null,null,null,null,null,null,null,null,6.8]
[null,null,null,null,null,null,null,null,null,null,null,null,7.1]
[null,null,null,null,null,null,null,null,null,null,null,null,7.7]
[null,null,null,null,null,null,null,null,null,null,null,null,8.1]
[null,null,null,null,null,null,null,null,null,null,null,null,8.1999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,8.3000000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,8.4]
[null,null,null,null,null,null,null,null,null,null,null,null,9.1999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,10.1]
[null,null,null,null,null,null,null,null,null,null,null,null,10.3]
[null,null,null,null,null,null,null,null,null,null,null,null,10.5]
[null,null,null,null,null,null,null,null,null,null,null,null,11.8]
[null,null,null,null,null,null,null,null,null,null,null,null,12.3]
[null,null,null,null,null,null,null,null,null,null,null,null,12.5]

{"sheet":"бланк для печати","index":3,"n_rows":52,"n_cols":46,"rows_kept":52,"cut":false,"hidden":false,"merged":[[16,1,16,12],[17,13,17,44],[7,35,7,39],[8,35,8,39],[9,35,9,39],[10,35,10,39],[11,35,11,39],[12,35,12,39],[13,35,13,39],[14,35,14,39],[14,40,14,44],[14,20,14,22],[14,18,14,19],[14,13,14,15],[14,16,14,17],[8,16,8,17],[9,13,9,15],[9,16,9,17],[10,13,10,15],[10,16,10,17],[14,23,14,34],[15,13,15,44],[11,16,11,17],[12,13,12,15],[12,16,12,17],[13,13,13,15],[13,16,13,17],[7,16,7,17],[7,1,7,12],[5,40,5,44],[6,40,6,44],[7,40,7,44],[8,40,8,44],[9,40,9,44],[10,40,10,44],[11,40,11,44],[12,40,12,44],[13,40,13,44],[8,1,8,12],[9,1,9,12],[18,1,18,12],[18,13,18,22],[18,23,18,34],[4,23,4,34],[5,23,5,34],[5,16,5,17],[5,13,5,15],[6,16,6,17],[5,18,5,19],[6,23,6,34],[7,23,7,34],[8,23,8,34],[9,23,9,34],[10,23,10,34],[11,23,11,34],[12,23,12,34],[13,23,13,34],[8,13,8,15],[6,1,6,12],[6,20,6,22],[7,20,7,22],[8,20,8,22],[9,20,9,22],[10,20,10,22],[4,35,4,39],[4,40,4,44],[5,35,5,39],[6,35,6,39],[10,1,10,12],[11,1,11,12],[14,1,14,12],[12,1,12,12],[13,1,13,12],[6,13,6,15],[7,13,7,15],[11,13,11,15],[4,13,4,22],[11,20,11,22],[12,20,12,22],[13,20,13,22],[6,18,6,19],[7,18,7,19],[8,18,8,19],[9,18,9,19],[10,18,10,19],[11,18,11,19],[12,18,12,19],[13,18,13,19],[0,0,0,44],[1,35,1,44],[2,13,2,44],[26,1,26,4],[28,5,28,8],[26,5,26,44],[28,1,28,4],[29,41,29,44],[1,0,19,0],[1,13,1,22],[1,23,1,34],[5,20,5,22],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,1,5,12],[3,13,3,44],[4,1,4,12],[20,1,20,4],[17,1,17,12],[18,35,18,44],[16,13,16,44],[15,1,15,12],[20,0,30,0],[29,17,29,20],[29,21,29,24],[29,25,29,28],[29,29,29,32],[28,9,28,12],[28,13,28,16],[28,17,28,20],[28,21,28,24],[28,25,28,28],[28,29,28,32],[32,0,39,0],[32,1,35,44],[36,1,39,44],[41,0,51,0],[41,1,41,4],[50,1,50,4],[49,1,49,4],[49,5,49,8],[49,9,49,12],[49,13,49,16],[49,17,49,20],[49,21,49,24],[51,1,51,24],[51,25,51,44],[49,25,49,28],[49,29,49,32],[49,33,49,36],[49,37,49,40],[49,41,49,44],[50,5,50,8],[50,9,50,12],[44,1,44,4],[50,13,50,16],[50,17,50,20],[50,21,50,24],[50,25,50,28],[50,29,50,32],[50,33,50,36],[50,37,50,40],[50,41,50,44],[19,1,19,12],[47,5,47,44],[48,1,48,44],[47,1,47,4],[30,1,30,24],[30,25,30,44],[27,1,27,44],[29,33,29,36],[28,33,28,36],[28,37,28,40],[28,41,28,44],[29,37,29,40],[19,13,19,44],[23,1,23,4],[29,1,29,4],[29,5,29,8],[29,9,29,12],[29,13,29,16]]}
["ООО \"РТК-Пласт\""]
["Коммерческий отдел","Бланк заказа№",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!$C$2","v":0},null,null,null,null,null,null,null,null,null,"Дата выдачи заказа на пр-во:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C3","v":"00:00:00"}]
[null,"Фирма-заказчик:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!$C$4","v":0}]
[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,null,"Колличество",null,null,null,null,null,null,null,null,null,null,null,"Метраж",null,null,null,null,"Цвет"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!C7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!C8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!C9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!C11","v":0},null,null,null,null,"С"]
[null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!E6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!E7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!E8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!E9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!E10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!E11","v":0},null,null,null,null,"E"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!G6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!G7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!G8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!G9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!G10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!G11","v":0},null,null,null,null,"G"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!I6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!I7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!I8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!I9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!I10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!I11","v":0},null,null,null,null,"I"]
[null,5,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!K6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!K7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!K8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!K9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!K10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!K11","v":0},null,null,null,null,"K"]
[null,6,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!M6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!M7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!M8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!M9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!M10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!M11","v":0},null,null,null,null,"M"]
[null,7,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!O6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!O7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!O8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!O9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!O10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!O11","v":0},null,null,null,null,"O"]
[null,8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!Q6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!Q7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!Q8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!Q9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!Q10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!Q11","v":0},null,null,null,null,"Q"]
[null,9,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!S6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!S7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!S8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!S9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!S10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!S11","v":0},null,null,null,null,"S"]
[null,10,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!U6","v":0},null,null,{"$f":"'ввод данных для менеджеров'!U7","v":0},null,"х",null,{"$f":"'ввод данных для менеджеров'!U8","v":0},null,null,{"$f":"'ввод данных для менеджеров'!U9","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!U10","v":0},null,null,null,null,{"$f":"'ввод данных для менеджеров'!U11","v":0},null,null,null,null,"U"]
[null,{"$f":"'ввод данных для менеджеров'!B14","v":"Бирки согласно спецификации:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C14","v":"Без РТК-Пласт ГОСТ18599-2001"}]
[null,"Перечень сопроводительных документов :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF('ввод данных для менеджеров'!C18=0,\"\",'ввод данных для менеджеров'!D18&\", \"),IF('ввод данных для менеджеров'!C19=0,\"\",'ввод данных для менеджеров'!D19&\", \"),IF('ввод данных для менеджеров'!C20=0,\"\",'ввод данных для менеджеров'!D20&\", \"),IF('ввод данных для менеджеров'!C21=0,\"\",'ввод данных для менеджеров'!D21&\", \"),IF('ввод данных для менеджеров'!C22=0,\"\",'ввод данных для менеджеров'!D22&\", \"),IF('ввод данных для менеджеров'!C23=0,\"\",'ввод данных для менеджеров'!D23&\"\"),IF('ввод данных для менеджеров'!C24=0,\"\",'ввод данных для менеджеров'!D24&\"  \"))","v":""}]
[null,"Отметка заказа цветом:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для производства'!D16","v":"Красный скотч"}]
[null,"Формат упаковки:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C13","v":"Скотч+Стрейч"},null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!B16","v":"Срок изготовления:"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C16","v":"00:00:00"}]
[null,"Маркировка:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'ввод данных для менеджеров'!C12","v":"без РТК-Пласт ГОСТ18599-2001"}]
["Производство","Делать:"]
[]
[]
[null,"Упаковка:"]
[]
[]
[null,"Особые \nтребования:",null,null,null,{"$f":"'ввод данных для производства'!C23","v":0}]
[null,"Рецептура:"]
[null,{"$f":"'ввод данных для производства'!B4","v":"сырье 1"},null,null,null,{"$f":"'ввод данных для производства'!B5","v":"сырье 2"},null,null,null,{"$f":"'ввод данных для производства'!B6","v":"сырье 2"},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":"'ввод данных для производства'!E4","v":1},null,null,null,{"$f":"'ввод данных для производства'!E5","v":0},null,null,null,{"$f":"'ввод данных для производства'!E6","v":3},null,null,null,{"$f":"'ввод данных для производства'!E7","v":0},null,null,null,{"$f":"'ввод данных для производства'!E8","v":0},null,null,null,{"$f":"'ввод данных для производства'!E9","v":0},null,null,null,{"$f":"'ввод данных для производства'!E10","v":0},null,null,null,{"$f":"'ввод данных для производства'!E11","v":0},null,null,null,{"$f":"'ввод данных для производства'!E12","v":0},null,null,null,{"$f":"'ввод данных для производства'!E13","v":0},null,null,null,{"$f":"'ввод данных для производства'!E14","v":0}]
[null,{"$f":"SUM(B30:AS30)","v":4},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":1}]
[]
["ОТК","Рекомендации ОТК:"]
[]
[]
[]
[null,"Отгружено:"]
[]
[]
[]
[]
["Производство","Делать:"]
[]
[]
[null,"Упаковка:"]
[]
[]
[null,"Особые\nтребования:",null,null,null,{"$f":"'ввод данных для производства'!C23","v":0}]
[null,"Рецептура:"]
[null,{"$f":"B29","v":"сырье 1"},null,null,null,{"$f":"F29","v":"сырье 2"},null,null,null,{"$f":"J29","v":"сырье 2"},null,null,null,{"$f":"N29","v":0},null,null,null,{"$f":"R29","v":0},null,null,null,{"$f":"V29","v":0},null,null,null,{"$f":"Z29","v":0},null,null,null,{"$f":"AD29","v":0},null,null,null,{"$f":"AH29","v":0},null,null,null,{"$f":"AL29","v":0},null,null,null,{"$f":"AP29","v":0}]
[null,{"$f":"B30","v":1},null,null,null,{"$f":"F30","v":0},null,null,null,{"$f":"J30","v":3},null,null,null,{"$f":"N30","v":0},null,null,null,{"$f":"R30","v":0},null,null,null,{"$f":"V30","v":0},null,null,null,{"$f":"Z30","v":0},null,null,null,{"$f":"AD30","v":0},null,null,null,{"$f":"AH30","v":0},null,null,null,{"$f":"AL30","v":0},null,null,null,{"$f":"AP30","v":0}]
[null,{"$f":"B31","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z31","v":1}]

{"sheet":"сырье","index":4,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,2],[1,4,1,6],[1,8,1,10]]}
["Сырье на пленку"]
["Первичка",null,null,null,"Вторичка",null,null,null,"Концентраты"]
["№","Наименование","цена, за 1кг",null,"№","Наименование","цена, за 1кг",null,"№","Наименование","цена, за 1кг"]
[null,0,0,null,null,0,0,null,null,0,0]
[1,"ПВД 153",97.57,null,1,"гр.ПВД в/с Липецк",58.87,null,1,"ск.бел.  50%",197.28]
[2,"ЛПВД5118",95,null,2,"мел R80PE-1 Европолимер",37.200000000000003,null,2,"ск бел 60%",239.54]
[3,"ПВД 177",96.6,null,3,"гр. ПВД свет. Грандпласт",59.98,null,3,"ск син 5402",216.92]
[4,"ПВД 158",96,null,4,"гр. ПВД цвет. Грандпласт",45,null,4,"ск голубой 5304",251.09]
[5,"ПВД 108",86.62,null,5,"стрейч Липецк",67,null,5,"ск желтый 32002",296.72000000000003]
[6,"LP 118H",102,null,6,"гр. ПВД в/с Агропромупак",85,null,6,"ск оранж ПФ1210/09ПЭ",355]
[7,"ПЭ2НТ 15-11",94,null,7,"мел Alen 282",41.67,null,7,"ск зелен. 4363",345.84]
[8,"LP 0209А",96,null,8,"гр белая Изовол",78.66,null,8,"ск красн. 024385",327.91]
[9,"FL 7000",105.97,null,9,"гр ПВДбелая ",81.150000000000006,null,9,"Скольз. добавка ПФ0012/01",208]
[10,"Ставролен 68",106.95,null,10,"гр 158 скольз",100.05,null,10,"Светостабилизатор УФ",298.11]
[11,"ПНД 293",107,null,11,"гранула синяя ПВД Липецк",50,null,11,"экструден 0026/01",287.58999999999997]
[12,"гр153",98.77,null,12,"гранула вторичная",57.2,null,12,"антистат ПОА 323",213.26]
[13,"гр108",93.88,null,13,"Композит втор. П8200",73,null,13,"ск черный",104.67]
[14,"ПНД прозр",97.27,null,14,"ПНД  Липецк экструзия",72,null,14,"пластификатор",150]
[15,"FA2004",93,null,15,"гр ПСД фиолетовая",86.68,null,15,"ск фиол 6514",352.34]
[16,"гранула ПНД белая",99.31,null,16,"стрейч РЭП",69,null,16,"антислип ДАС-7",187]
[17,"гранула ПНД синяя",91.18,null,17,"гр серая Изовол",40,null,17,"Модификатор 101",128]
[18,"ЛПВД5122",93.6,null,null,null,null,null,18,"ск черный 9400S",206.12]
[19,"PE181",96.02,null,null,null,null,null,19,"СК топл.молоко 1313",284]
[20,"гр ПСД",97.72]
[21,"LD03210 FE",101.5]
[22,"привозное тест",75]

{"sheet":"рецептура","index":5,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,5,0,6],[62,5,62,6],[63,5,63,6],[64,5,64,6],[65,5,65,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[55,5,55,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[39,5,39,6],[50,5,50,6],[66,5,66,6],[56,0,66,0],[56,2,66,2],[56,3,66,3],[56,4,66,4],[56,5,56,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[34,0,44,0],[34,2,44,2],[34,3,44,3],[34,4,44,4],[45,0,55,0],[45,2,55,2],[45,3,55,3],[45,4,55,4],[5,5,5,6],[6,5,6,6],[7,5,7,6],[23,0,33,0],[23,2,33,2],[23,3,33,3],[23,4,33,4],[37,5,37,6],[38,5,38,6],[35,5,35,6],[36,5,36,6],[34,5,34,6],[32,5,32,6],[33,5,33,6],[30,5,30,6],[31,5,31,6],[28,5,28,6],[29,5,29,6],[26,5,26,6],[27,5,27,6],[24,5,24,6],[25,5,25,6],[23,5,23,6],[2,5,2,6],[8,5,8,6],[1,0,11,0],[1,5,1,6],[15,5,15,6],[1,2,11,2],[1,3,11,3],[1,4,11,4],[13,5,13,6],[14,5,14,6],[11,5,11,6],[12,5,12,6],[9,5,9,6],[10,5,10,6],[3,5,3,6],[4,5,4,6],[16,5,16,6],[12,0,22,0],[12,2,22,2],[12,3,22,3],[12,4,22,4],[21,5,21,6],[22,5,22,6],[19,5,19,6],[20,5,20,6],[17,5,17,6],[18,5,18,6]]}
["номер рецептуры",null,"оборудование","вид",null,"сырье",null,"вес"]
[1,null,"ЛТ-1","ПНД",null,"сырье 1",null,1]
[null,null,null,null,null,"сырье 2"]
[null,null,null,null,null,"сырье 2",null,3]
[]
[]
[]
[]
[]
[]
[]
[]
[2,null,"ЛТ-1","ПВД"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,null,"ЛТ-1","ПНД/90"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,null,"ЛТ-2","ПНД"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[5,null,"ЛТ-2","ПВД"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[6,null,"ЛТ-2","ПНД/110"]