{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BLANK","DATA","LISTS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"BLANK","index":0,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[17,1,17,10],[20,4,20,5],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[1,4,1,5],[2,4,2,5],[3,4,3,5],[11,1,11,3],[13,1,13,3],[10,4,10,5],[11,4,11,5],[13,4,13,5],[1,13,1,15],[6,1,6,3],[8,1,8,3],[8,4,8,5],[10,1,10,3],[6,4,6,5],[32,4,32,5],[36,1,51,10],[15,1,15,2],[15,4,15,5],[25,4,25,5],[26,8,26,9],[27,8,27,9],[28,8,28,9],[25,8,25,9],[19,4,19,5],[30,6,30,9],[21,4,21,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[30,4,30,5]]}
[]
[null,"Дата:",null,null,"2015-01-20"]
[null,"Руководитель смены:",null,null,1]
[null,"Старший оператор:",null,null,2]
[null,"Номер карты:",null,null,"RB",3,21,null,null,null,null,null,null,{"$f":"CONCATENATE(E5,F5,G5)","v":"RB321"}]
[]
[null,"Кол-во рулонов по карте:",null,null,4]
[]
[null,"Марка стали",null,null,5]
[]
[null,"Толщина, мм",null,null,6,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(E11,\"x\",E12,\"x\",E14)","v":"6x7x8"}]
[null,"Ширина, мм",null,null,"7"]
[]
[null,"Длинна, мм",null,null,"8"]
[]
[null,"Тип изделия:",null,null,"9",null,{"$f":"VLOOKUP(E16,LISTS!H3:I8,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,"Рулоны"]
[]
[null,null,null,null,"Вес, т"]
[null,"Вес согласно документов",null,null,10,null,null,null,null,null,null,null,null,{"$f":"E21=E22","v":false}]
[null,"Фактический вес",null,null,11]
[]
[null,"Продукция"]
[]
[null,null,null,null,"Вес, т",null,"% Факт","%, Норма","Отклонение",null,null,null,null,{"$f":"MIN(I27:J29)","v":{"$error":"#N/A"}}]
[null,"Годная продукция\n",null,null,12,null,{"$f":"E27/(E22-E31)","v":-3},{"$f":"VLOOKUP($E$16,LISTS!$H$3:$L$8,3,FALSE)-E33","v":{"$error":"#N/A"}},{"$f":"G27-H27","v":{"$error":"#N/A"}}]
[null,"Некондиция",null,null,13,null,{"$f":"E28/(E22-E31)","v":-3.25},{"$f":"VLOOKUP($E$16,LISTS!$H$3:$L$8,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"H28-G28","v":{"$error":"#N/A"}}]
[null,"Металлолом",null,null,14,null,{"$f":"E29/(E22-E31)","v":-3.5},{"$f":"VLOOKUP($E$16,LISTS!$H$3:$L$8,5,FALSE)+E33","v":{"$error":"#N/A"}},{"$f":"H29-G29","v":{"$error":"#N/A"}}]
[]
[null,"Отмотка",null,null,15,null,{"$f":"IF(E22=E27+E28+E29+E31,,\"Ошибка при заполнении данных\")","v":"Ошибка при заполнении данных"}]
[]
[null,"Запланированный отход",null,null,0.16]
[]
[null,"Примечания"]
[]
[null,"ESDSDGDFHGFJHGK"]

{"sheet":"DATA","index":1,"n_rows":2,"n_cols":30,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Дата","Руководитель смены","Старший оператор ","Номер карты","Количество рулонов по карте","Толщина, мм","Ширина, мм","Длинна, мм","Полный размер, мм","Марка стали","Переработка ранее отбракованного материала","Тип изделия","Вес рулонов по инвойсу","Вес рулонов фактический до порезки","Продукция согласно технической спецификации клиента\n","Некондиция","Металлолом","Вес рулона или отмотки возвращенного на склад","Запланированный отход в кромку","Выход годного относительно веса по инвойсу","Выход годного относительно фактического веса","\"Second choice\" относительно веса по инвойсу","\"Second choice\" относительно фактического веса","Металлолома относительно веса рулона по инвойсу","Норма металлолома","Металлолом относительно  фактического веса","Отход в кромку относительно веса рулона по инвойсу","Отход в кромку относительно фактического веса рулонов","Примечания"]

{"sheet":"LISTS","index":2,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,7,1,11]]}
[]
[null,"Руководитель смены","Старший оператор ","Количество рулонов по карте: шт.","Толщина, мм","Марка стали","Карта","Тип продукта"]
[null,"А.Панченко ","В.Трефилов",1,"0.40","DC01",null,"S","Стандартный лист"]
[null,"В.Власихин","К.Кузнецов",2,"0.45","DC02","A","SP","Стандартный лист со спец. требованиями"]
[null,"Е.Бэйтан","П.Авласин",3,"0.50","DC03","B","B","Бланк"]
[null,"И.Синицин","И.Антонеков ",4,"0.55","DC04","C","BT","Бланк со спец. требованиями"]
[null,null,"А.Шакель",5,"0.60","DC05","D","BX","Бланк по согласованию с менеджером"]
[null,null,null,6,"0.65","DC06","BR","M","Смешаная карта"]
[null,null,null,7,"0.70","08Ю","TEH"]
[null,null,null,8,"0.75","DD11 (pickl)","BR+TEH"]
[null,null,null,9,"0.80","S235JR (pickl)"]
[null,null,null,10,"0.85","S355MC (pickl)"]
[null,null,null,11,"0.90","DX51D+Z100 MAC"]
[null,null,null,12,"0.95","DX51D+Z140 MAC"]
[null,null,null,13,"1.00","DX51D+Z200 MAC"]
[null,null,null,14,"1.10","DX51D+Z275 MAC"]
[null,null,null,15,"1.20"]
[null,null,null,16,"1.25"]
[null,null,null,17,"1.30"]
[null,null,null,18,"1.40"]
[null,null,null,19,"1.45"]
[null,null,null,20,"1.50"]
[null,null,null,null,"1.80"]
[null,null,null,null,"1.90"]
[null,null,null,null,"1.95"]
[null,null,null,null,"2.00"]
[null,null,null,null,"2.45"]
[null,null,null,null,"2.50"]
[null,null,null,null,"2.95"]
[null,null,null,null,"3.00"]