{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Многоуровневая группировка","Состояние"],"not_rendered":{"charts":0,"images":1,"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":37,"n_cols":61,"rows_kept":37,"cut":false,"hidden":false,"merged":[[26,53,26,54],[2,55,2,56],[2,57,2,58],[0,23,0,24],[0,19,0,20],[0,21,0,22],[2,53,2,54],[20,53,20,54]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"сдано",null,"Прош. Опрерац",null,"В работе",null,null,"На корректировку ",null,"В работе",null,"Снято",null,"СДАНО","Обязательная номенклатура"]
["№ П\\П","Наименование","Индекс СТО","Наименование1","Индекс1","Наименование2","индекс2","Наименование3","индекс3","Кол-во","Состояние","05","Д1","010","Д2","015","Д3","020","Д4","025","Д5","030","Д6","035","Д7","040","Д8","Цех-заказчик","Изделие","Наряд","№ДСЕ","Чертежи выданы на участок с заготовками","КД поступило                 в Тех Бюро","КД выдано из                Тех Бюро в ПРБ","Дата открытия заказа","ТБ","Заготовки","исх. ОГТ","Дата исх ОГТ","Трудо ёмкость,н/час","Срок исполнения","№ накладной","Дата сдачи","Причина\nневыполнения","Примечание",null,null,null,null,"Проверка структуры"]
[1,"Заглушка","7094-4414",null,null,null,null,null,null,1,"РАБ","сварка",null,"сл",null,"отк",null,null,null,null,null,null,null,null,null,null,null,"230","15В245","0792",null,"2016-02-08","+",null,"вып","вып","вып",1379,"2016-02-10",3.8,null,null,null,null,"1-51-ц.210 гибка, срок - 20.02","     ",{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Да"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Да"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false},null,"На корректировку ",null,"В работе",null,"Снято",null,"СДАНО","Обязательная номенклатура"]
[null,null,null,"стол","СБ-1",null,null,null,null,2,"РАБ","сварка",null,"сл",null,"отк"]
[null,null,null,null,null,"Угольник","СБ-1-1",null,null,3,"КОР","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Винтик","1-1-51",4,"СН","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Гайка","1-1-52",5,"СД","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Валик","1-1-53",6,"РАБ","сварка",null,"сл",null,"отк"]
[null,null,null,null,null,"Угольник","СБ-1-2",null,null,7,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Винтик","1-2-51",8,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Гайка","1-2-52",9,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Валик","1-2-53",10,"РАБ","сварка",null,"сл",null,"отк"]
[null,null,null,"Угольник","СБ-2",null,null,null,null,11,"РАБ","сварка",null,"сл",null,"отк"]
[null,null,null,null,null,"Угольник","СБ-2-1",null,null,12,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Винтик","2-1-51",13,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Гайка","2-1-52",14,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Валик","2-1-53",15,"РАБ","сварка",null,"сл",null,"отк"]
[null,null,null,null,null,"Угольник","СБ-2-2",null,null,16,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Винтик","2-1-51",17,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,"Гайка","2-1-52",18,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[2,"Кондуктор","7347-1294",null,null,null,null,null,null,19,"РАБ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"220","15В245","0792",null,"2015-04-25","+",null,"вып","вып","вып. ",2007,"2014-04-16","70,62",null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false},null,"В работе"]
[null,null,null,"Угольник","СБ-2-2",null,null,null,null,20,"РАБ","сварка",null,"сл",null,"отк",null,null,null,"отк"]
[null,null,null,null,null,"Винтик","2-1-51",null,null,21,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,"Гайка","2-1-52",null,null,22,"РАБ","ток","2016-02-29","т/о","2016-03-01","шл","2016-03-03","адж",null,"отк"]
[null,null,null,null,null,null,null,null,null,null,"КОР"]
[null,null,null,null,null,null,null,null,null,null,"КОР"]
[3,"Приспособление","7462-1855",null,null,null,null,null,null,"1","КОР",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"220","15В245","0792",null,"2016-01-22","+",null,"вып","вып","вып.",2161,"2014-04-28",158.9,null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false},null,"Снято"]
[4,"Штамп","1200-7123",null,null,null,null,null,null,1,"КОР",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"210","15В287","0792",null,"2016-02-18","+",null,"вып","вып","вып",1227,"2016-02-03",82.3,null,null,null,null,"пруж.д.54-отд.107 Срок?",{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false},null,"СДАНО"]
[5,"Детали     ","7873-5396",null,null,null,null,null,null,1,"КОР",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,230,"15В287","0792",null,"2016-02-17","+",null,"вып","вып","вып",793,"2016-01-15",28.05,null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false},null,"Обязательная номенклатура"]
[6,"Шаблон","8385-6169",null,null,null,null,null,null,null,"КОР",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15В287","0792",null,"2015-09-23","+",null,"вып","вып","вып","требуется СМЗ для ввода в Альфу",null,null,null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false}]
[7,"нижник","0525-5925",null,null,null,null,null,null,1,"КОР",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"15У196","0998",null,"2016-02-15","+",null,"вып","вып","вып","требуется СМЗ для ввода в Альфу",null,9.1,null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false}]
[8,"нижник","0525-5930",null,null,null,null,null,null,1,"КОР",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"15У196","0998",null,null,"+",null,"2016-02-19","2016-02-19","нет отр из ТБ",1205," 02.02.2016",null,null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false}]
[9,"нижник","0525-5931",null,null,null,null,null,null,1,"КОР",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"15У196","0998",null,null,"+",null,"2016-02-19","2016-02-19","нет отр из ТБ",1207," 02.02.2016",null,null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false}]
[10,"приспособление","0870-5486",null,null,null,null,null,null,1,"КОР",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"15У196","0998",null,null,"+",null,"2016-02-19","2016-02-19","вып.",1295,"2016-02-05",null,null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false}]
[11,"Штамп","1200-7369",null,null,null,null,null,null,1,"СН",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"15У196","0998",null,"2015-11-19","+",null,"вып","вып","вып","требуется СМЗ для ввода в Альфу",null,29.9,null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false}]
[12,"Ползун","1760-1631",null,null,null,null,null,null,1,"СН",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,230,"15У196","0998",null,null,"+",null,"26/01-16","2016-02-20","нет отр из ТБ",1600,"2016-02-16",null,null,null,null,null,null,{"$f":"IF(C:C=\"\",\"Да\",\"Нет\")","v":"Нет"},{"$f":"IF(AT:AT=\"Нет\",\"Нет\",IF(E:E=\"\",\"Да\",\"Нет\"))","v":"Нет"},{"$f":"IF(AU:AU=\"Нет\",\"Нет\",IF(G:G=\"\",\"Да\",\"Нет\"))","v":"Нет"},null,{"$f":"ISBLANK(C:C)","v":false},{"$f":"IF(ISBLANK(C:C),(ISBLANK(E:E)))","v":false},{"$f":"IF(ISBLANK(C:C),IF(ISBLANK(E:E),ISBLANK(G:G)))","v":false}]
[null,"Конец",null,null,null,null,null,null,null,null,"КОР"]

{"sheet":"Состояние","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1]]}
["На корректировку ",null,"КОР"]
["В работе",null,"РАБ"]
["Снято",null,"СН"]
["СДАНО",null,"СД"]
["Обязательная номенклатура",null,"ОН"]