{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ПЛАН","Стол1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Отм.","Наименование изделия","Обозначения изделия","Наименование детали","Обозначение детали","Количество","Время обработки","Станок","Примечания"]
[null,"Сборка","10-00",null,null,100]
[null,null,null,"Деталь 2","10-00-01",{"$f":"F6+F20","v":600},1,"Стол1"]
[null,null,null,"Деталь 1","10-00-02",{"$f":"F6","v":100},2,"Стол2"]
[null,"Сборка","11-00",null,null,200]
[null,null,null,"Деталь 4","11-00-01",{"$f":"F9+F22","v":200},2.5,"Стол1"]
[null,null,null,"Деталь 12","11-00-02",{"$f":"F9","v":200},1.5,"Стол1"]
[null,"Сборка","12-00",null,null,300]
[null,null,null,"Деталь 14","12-00-01",{"$f":"F12","v":300},2,"Стол2"]
[null,null,null,"Деталь 6","12-00-02",{"$f":"F12","v":300},3,"Стол2"]
[null,"Сборка","13-00",null,null,400]
[null,null,null,"Деталь 10","13-00-01",{"$f":"F15","v":400},4,"Стол1"]
[null,null,null,"Деталь 11","13-00-02",{"$f":"F15","v":400},2,"Стол1"]
[null,null,null,"Деталь 9","13-00-03",{"$f":"F15","v":400},1,"Стол2"]
[null,null,null,"Деталь 7","13-00-04",{"$f":"F15","v":400},3]
[null,"Сборка","14-00",null,null,500]
[null,null,null,"Деталь 1","10-00-01"]
[null,null,null,"Деталь 3","11-00-01"]
[null,null,null,"Деталь 8","14-00-01",{"$f":"F20","v":500},5,"Стол1"]

{"sheet":"Стол1","index":1,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,9,3,9],[2,10,3,10],[1,0,1,1],[1,2,1,8],[1,9,1,10],[2,0,2,1],[2,2,2,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
[]
["Завод",null,"Загрузка оборудования",null,null,null,null,null,null,"                                                                                          На октябрь 2021 г. "]
["Оборудование (группа)",null,"Деталь",null,"Трудоемк. на 100 дет. в нормо-час.","Количество деталей на программу    (в шт.)","Трудоемк.                                                                                                                                                 на                                                                                                                                                           программу                                                                                                                                                    в нормо-час.","Загрузка оборудован. по действую-щим нормам в нормо-час. ","Фонд времени работы одного станка ","Тшт, мин.","Количество деталей в смену                                   (в шт.)"]
["Инв. номер","Наименование","Наименование","Обозначение"]
[1,2,3,4,5,6,7,8,9,10,11]
[null,"Стол1",null,null,null,null,null,"В 2смены",{"$f":"176*2","v":352}]
[]
[null,null,{"$f":"IFERROR(INDEX(ПЛАН!$D$6:$D$94,MATCH(SMALL((ПЛАН!$H$6:$H$94=\"Стол1\")*COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),COUNTIF(ПЛАН!$H$6:$H$94,\"<>Стол1\")+ROW(D1)),COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),0)),\"0\")","v":"Деталь 10"},{"$f":"IFERROR(INDEX(ПЛАН!E:E,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(E1))),\"0\")","v":"10-00-01"},{"$f":"J8/60*100","v":1.6666666666666667},{"$f":"IFERROR(INDEX(ПЛАН!F:F,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(F1))),\"0\")","v":600},{"$f":"E8*F8/100","v":10},null,null,{"$f":"IFERROR(INDEX(ПЛАН!G:G,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(G1))),\"0\")","v":1},{"$f":"8*60/J8","v":480}]
[null,null,{"$f":"IFERROR(INDEX(ПЛАН!$D$6:$D$94,MATCH(SMALL((ПЛАН!$H$6:$H$94=\"Стол1\")*COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),COUNTIF(ПЛАН!$H$6:$H$94,\"<>Стол1\")+ROW(D2)),COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),0)),\"0\")","v":"Деталь 11"},{"$f":"IFERROR(INDEX(ПЛАН!E:E,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(E2))),\"0\")","v":"11-00-01"},{"$f":"J9/60*100","v":4.1666666666666661},{"$f":"IFERROR(INDEX(ПЛАН!F:F,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(F2))),\"0\")","v":200},{"$f":"E9*F9/100","v":8.3333333333333321},null,null,{"$f":"IFERROR(INDEX(ПЛАН!G:G,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(G2))),\"0\")","v":2.5},{"$f":"8*60/J9","v":192}]
[null,null,{"$f":"IFERROR(INDEX(ПЛАН!$D$6:$D$94,MATCH(SMALL((ПЛАН!$H$6:$H$94=\"Стол1\")*COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),COUNTIF(ПЛАН!$H$6:$H$94,\"<>Стол1\")+ROW(D3)),COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),0)),\"0\")","v":"Деталь 12"},{"$f":"IFERROR(INDEX(ПЛАН!E:E,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(E3))),\"0\")","v":"11-00-02"},{"$f":"J10/60*100","v":2.5},{"$f":"IFERROR(INDEX(ПЛАН!F:F,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(F3))),\"0\")","v":200},{"$f":"E10*F10/100","v":5},null,null,{"$f":"IFERROR(INDEX(ПЛАН!G:G,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(G3))),\"0\")","v":1.5},{"$f":"8*60/J10","v":320}]
[null,null,{"$f":"IFERROR(INDEX(ПЛАН!$D$6:$D$94,MATCH(SMALL((ПЛАН!$H$6:$H$94=\"Стол1\")*COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),COUNTIF(ПЛАН!$H$6:$H$94,\"<>Стол1\")+ROW(D4)),COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),0)),\"0\")","v":"Деталь 2"},{"$f":"IFERROR(INDEX(ПЛАН!E:E,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(E4))),\"0\")","v":"13-00-01"},{"$f":"J11/60*100","v":6.666666666666667},{"$f":"IFERROR(INDEX(ПЛАН!F:F,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(F4))),\"0\")","v":400},{"$f":"E11*F11/100","v":26.666666666666671},null,null,{"$f":"IFERROR(INDEX(ПЛАН!G:G,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(G4))),\"0\")","v":4},{"$f":"8*60/J11","v":120}]
[null,null,{"$f":"IFERROR(INDEX(ПЛАН!$D$6:$D$94,MATCH(SMALL((ПЛАН!$H$6:$H$94=\"Стол1\")*COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),COUNTIF(ПЛАН!$H$6:$H$94,\"<>Стол1\")+ROW(D5)),COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),0)),\"0\")","v":"Деталь 4"},{"$f":"IFERROR(INDEX(ПЛАН!E:E,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(E5))),\"0\")","v":"13-00-02"},{"$f":"J12/60*100","v":3.3333333333333335},{"$f":"IFERROR(INDEX(ПЛАН!F:F,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(F5))),\"0\")","v":400},{"$f":"E12*F12/100","v":13.333333333333336},null,null,{"$f":"IFERROR(INDEX(ПЛАН!G:G,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(G5))),\"0\")","v":2},{"$f":"8*60/J12","v":240}]
[null,null,{"$f":"IFERROR(INDEX(ПЛАН!$D$6:$D$94,MATCH(SMALL((ПЛАН!$H$6:$H$94=\"Стол1\")*COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),COUNTIF(ПЛАН!$H$6:$H$94,\"<>Стол1\")+ROW(D6)),COUNTIF(ПЛАН!$D$6:$D$94,\"<=\"&ПЛАН!$D$6:$D$94),0)),\"0\")","v":"Деталь 8"},{"$f":"IFERROR(INDEX(ПЛАН!E:E,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(E6))),\"0\")","v":"14-00-01"},{"$f":"J13/60*100","v":8.3333333333333321},{"$f":"IFERROR(INDEX(ПЛАН!F:F,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(F6))),\"0\")","v":500},{"$f":"E13*F13/100","v":41.666666666666657},null,null,{"$f":"IFERROR(INDEX(ПЛАН!G:G,SMALL(IF(ПЛАН!$H$6:$H$94=\"Стол1\",ROW(ПЛАН!$H$6:$H$94)),ROW(G6))),\"0\")","v":5},{"$f":"8*60/J13","v":96}]
[]
[null,null,null,null,null,null,{"$f":"SUM(G8:G13)","v":105},{"$f":"G15/(I6*1)","v":0.29829545454545453}]