{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["контроль выполнения графика"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"контроль выполнения графика","index":0,"n_rows":19,"n_cols":183,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,10,1,12],[1,14,1,181],[2,4,2,7]]}
[null,null,null,"- выделены последние изменения"]
[null,null,{"$f":"DATE($M$3,MONTH(1&$L$3),$K$3)","v":"2016-05-16"},null,null,null,null,null,null,null,"Выбираем дату для контроля",null,null,null,"График производства (операции сборки) на май 2016 г."]
[null,null,"не трогать ячейку сверху(красненькая такая)!!!","Выбираем начало месяца","2016-05-01",null,null,null,null,null,16,"Май",2016,"УП"]
[null,"Цех","Обозначение","Наименование","Долг","Май","доп+","доп-","Итого по заказу","Итого по плану","План на дату","Сдано  на дату","Отклонения на дату",null,{"$f":"WORKDAY.INTL($AS$4,-5,1,)","v":"2016-04-25"},"2016-04-25","2016-04-25","2016-04-25","2016-04-25",{"$f":"WORKDAY.INTL($AS$4,-5,1,)","v":"2016-04-25"},{"$f":"WORKDAY.INTL($AS$4,-4,1,)","v":"2016-04-26"},"2016-04-26","2016-04-26","2016-04-26","2016-04-26",{"$f":"WORKDAY.INTL($AS$4,-4,1,)","v":"2016-04-26"},{"$f":"WORKDAY.INTL($AS$4,-3,1,)","v":"2016-04-27"},"2016-04-27","2016-04-27","2016-04-27","2016-04-27",{"$f":"WORKDAY.INTL($AS$4,-3,1,)","v":"2016-04-27"},{"$f":"WORKDAY.INTL($AS$4,-2,1,)","v":"2016-04-28"},"2016-04-28","2016-04-28","2016-04-28","2016-04-28",{"$f":"WORKDAY.INTL($AS$4,-2,1,)","v":"2016-04-28"},{"$f":"WORKDAY.INTL($AS$4,-1,1,)","v":"2016-04-29"},"2016-04-29","2016-04-29","2016-04-29","2016-04-29",{"$f":"WORKDAY.INTL($AS$4,-1,1,)","v":"2016-04-29"},{"$f":"WORKDAY.INTL($E$3,((COLUMN(A1)-1)/6)+1,1,)","v":"2016-05-02"},"2016-05-02","2016-05-02","2016-05-02","2016-05-02","2016-05-02","2016-05-03","2016-05-03","2016-05-03","2016-05-03","2016-05-03","2016-05-03","2016-05-04","2016-05-04","2016-05-04","2016-05-04","2016-05-04","2016-05-04","2016-05-05","2016-05-05","2016-05-05","2016-05-05","2016-05-05","2016-05-05","2016-05-06","2016-05-06","2016-05-06","2016-05-06","2016-05-06","2016-05-06","2016-05-09","2016-05-09","2016-05-09","2016-05-09","2016-05-09","2016-05-09","2016-05-10","2016-05-10","2016-05-10","2016-05-10","2016-05-10","2016-05-10","2016-05-11","2016-05-11","2016-05-11","2016-05-11","2016-05-11","2016-05-11","2016-05-12","2016-05-12","2016-05-12","2016-05-12","2016-05-12","2016-05-12","2016-05-13","2016-05-13","2016-05-13","2016-05-13","2016-05-13","2016-05-13","2016-05-16","2016-05-16","2016-05-16","2016-05-16",{"$f":"WORKDAY.INTL($E$3,((COLUMN(BM1)-1)/6)+1,1,)","v":"2016-05-16"},"2016-05-16","2016-05-17","2016-05-17","2016-05-17","2016-05-17","2016-05-17","2016-05-17","2016-05-18","2016-05-18","2016-05-18","2016-05-18","2016-05-18","2016-05-18","2016-05-19","2016-05-19","2016-05-19","2016-05-19","2016-05-19","2016-05-19","2016-05-20","2016-05-20","2016-05-20","2016-05-20","2016-05-20","2016-05-20","2016-05-23","2016-05-23","2016-05-23","2016-05-23","2016-05-23","2016-05-23","2016-05-24","2016-05-24","2016-05-24","2016-05-24","2016-05-24","2016-05-24","2016-05-25","2016-05-25","2016-05-25","2016-05-25","2016-05-25","2016-05-25","2016-05-26","2016-05-26","2016-05-26","2016-05-26","2016-05-26","2016-05-26","2016-05-27","2016-05-27","2016-05-27","2016-05-27","2016-05-27","2016-05-27","2016-05-30","2016-05-30","2016-05-30","2016-05-30","2016-05-30","2016-05-30","2016-05-31","2016-05-31",{"$f":"WORKDAY.INTL($E$3,((COLUMN(DY1)-1)/6)+1,1,)","v":"2016-05-31"},"2016-05-31","2016-05-31","2016-05-31","2016-06-01","2016-06-01","2016-06-01","2016-06-01","2016-06-01","2016-06-01","Предварительный план июня"]
[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,0]
[null,"м",null,"Вагонокомплекты",null,null,null,null,{"$f":"SUM(E7:H7)","v":0},{"$f":"SUMIF($O$5:$FZ$5,\"УП\",$O7:$FZ7)","v":0}]
[null,20,9999999,"изделие1",null,17,null,null,17,17,15,15,0,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,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,4,null,null,null,null,null,4,null,null,null,null,null,4,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,20,10000000,"изделие2",null,17,null,null,17,0,0,0,0,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,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,4,null,null,null,null,null,4,null,null,null,null,null,4,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,2]
[null,20,10000001,"изделие3",null,17,null,null,17,0,0,0,0,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,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,4,null,null,null,null,null,4,null,null,null,null,null,4,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,2]
[null,20,10000002,"изделие4",null,17,null,null,17,0,0,0,0,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,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,4,null,null,null,null,null,4,null,null,null,null,null,4,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,2]
[null,20,10000003,"изделие5",null,12,null,-1,11,11,6,6,0,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,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,3,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,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,null,null,null,null,null,12]
[null,20,10000004,"изделие6",null,168,null,null,168,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,null,14,null,null,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,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,28]
[null,20,10000005,"изделие7",null,12,null,null,12,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,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,2]
[null,20,10000006,"изделие8",null,24,null,null,24,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,2,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,20,10000007,"изделие9",null,12,null,null,12,0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,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,2]
[null,20,10000008,"изделие10",null,null,null,null,0,0,0,0,0,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,20,10000009,"изделие11",null,null,null,null,{"$f":"SUM(E18:H18)","v":0},{"$f":"SUMIF($O$5:$FZ$5,\"УП\",$O18:$FZ18)","v":0},0,0,0,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,20,10000010,"изделие12",null,null,null,null,0,0,0,0,0,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]