{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ДАННЫЕ","График-сут","График-4ч","График-мес","Классификатор"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"БАЗА ДАННЫХ",null,null,"Фильтр:"]
[null,{"$f":"\"Всего в базе сейчас \"&MAX(Данные[№])&\" заказов и \"&COUNTA(Данные[№])&\" заявок\"","v":"Всего в базе сейчас 18 заказов и 42 заявок"}]
["Ключевое Поле","№","Бригада","Мест.","Заявка","Начало","Завершение","Статус","ФИО","Причина","Выполнено","Количество переносов","Отменено","Активные"]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},1,54,"1020 Знаменское","ВП + 3ц.ж.","2016-02-03T08:00:00","2016-02-04T12:00:00","Перенос","ФИО1","Причина1",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":2},1,54,"1020 Знаменское","ГИС т.з.","2016-02-04T12:00:00",null,"Выполнено","ФИО2","Причина2",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},2,50,"255 Манчаровское","ГИС АКЦ","2016-02-01T05:00:00","2016-02-01T17:00:00","Перенос","ФИО3","Причина3",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},2,50,"255 Манчаровское","ГИС АКЦ","2016-02-01T17:00:00","2016-02-02","Перенос","ФИО4","Причина4",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":2},2,50,"255 Манчаровское","ГИС АКЦ","2016-02-02",null,"Выполнено","ФИО5","Причина5",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},3,52,"1020 Знаменское",null,"2016-02-03T20:00:00","2016-02-07T20:30:00","Перенос","ФИО6","Причина6",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},3,52,"1020 Знаменское",null,"2016-02-07T20:30:00","2016-02-22T12:12:00","Перенос","ФИО7","Причина7",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":2},3,52,"1020 Знаменское",null,"2016-02-22T12:12:00",null,"Выполнено","ФИО8","Причина8",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},4,50,"255 Манчаровское",null,"2016-02-02T21:03:00","2016-02-03T02:00:00","Перенос","ФИО9","Причина9",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":3},5,56,"255 Манчаровское",null,"2016-02-03T23:50:00",null,"Отмена","ФИО10","Причина10",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":1},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},6,55,"1020 Знаменское","рлордол","2016-02-04T05:06:00","2016-02-05T05:06:00","Перенос","ФИО11","Причина11",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":2},6,55,"1020 Знаменское",null,"2016-02-05T05:06:00",null,"Выполнено","ФИО12","Причина12",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},7,53,"255 Манчаровское","ub","2016-02-05T05:30:00","2016-02-21T01:00:00","Перенос","ФИО13","Причина13",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":1},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},7,53,"255 Манчаровское","ub","2016-02-21T01:00:00","2016-02-23","Перенос","ФИО14","Причина14",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":1},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":3},7,53,"255 Манчаровское","ub","2016-02-23",null,"Отмена","ФИО15","Причина15",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":1},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},4,50,"255 Манчаровское",null,"2016-02-03T02:00:00","2016-02-03T03:00:00","Перенос","ФИО16","Причина16",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},8,60,"255 Манчаровское","ВП + 3ц.ж.","2016-02-03T08:00:00","2016-02-04T12:00:00","Перенос","ФИО17","Причина17",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":2},8,60,"1020 Знаменское","ГИС т.з.","2016-02-04T12:00:00",null,"Выполнено","ФИО18","Причина18",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},9,59,"255 Манчаровское","ГИС АКЦ","2016-02-01T05:00:00","2016-02-01T17:00:00","Перенос","ФИО19","Причина19",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},9,59,"255 Манчаровское","ГИС АКЦ","2016-02-01T17:00:00","2016-04-02T05:00:00","Перенос","ФИО20","Причина20",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":2},9,59,"255 Манчаровское","ГИС АКЦ","2016-02-02T05:00:00",null,"Выполнено","ФИО21","Причина21",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},10,58,"1020 Знаменское",null,"2016-02-03T20:00:00","2016-02-07T20:30:00","Перенос","ФИО22","Причина22",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},10,58,"1020 Знаменское",null,"2016-02-07T20:30:00","2016-02-22T12:12:00","Перенос","ФИО23","Причина23",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":0.5},10,58,"1020 Знаменское",null,"2016-02-22T12:12:00",null,null,"ФИО24","Причина24",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":2},11,62,"255 Манчаровское",null,"2016-02-02T21:03:00","2016-02-03T04:00:00","Выполнено","ФИО25","Причина25",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":3},12,63,"255 Манчаровское",null,"2016-02-03T23:50:00",null,"Отмена","ФИО26","Причина26",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":1},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},13,62,"1020 Знаменское","рлордол","2016-02-04T05:06:00","2016-02-05T05:06:00","Перенос","ФИО27","Причина27",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":2},13,62,"1020 Знаменское",null,"2016-02-05T05:06:00",null,"Выполнено","ФИО28","Причина28",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},14,69,"255 Манчаровское","ub","2016-02-05T05:30:00","2016-02-21T02:00:00","Перенос","ФИО29","Причина29",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},14,69,"255 Манчаровское","ub","2016-02-21T02:00:00","2016-02-23T01:00:00","Перенос","ФИО30","Причина30",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":0.5},14,69,"255 Манчаровское","ub","2016-02-23T01:00:00",null,null,"ФИО31","Причина31",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":2},15,57,"255 Манчаровское",null,"2016-02-03T08:00:00",null,"Выполнено","ФИО32","Причина32",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":1}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},16,51,"255 Манчаровское","ошлл","2016-02-24T16:00:00","2016-02-29T16:30:00","Перенос","ФИО33","Причина33",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":3},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},16,51,"255 Манчаровское","ошлл","2016-02-29T16:30:00","2016-02-29T20:00:00","Перенос","ФИО34","Причина34",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":3},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},16,51,"255 Манчаровское","ошлл","2016-02-29T20:00:00","2016-03-02T03:00:00","Перенос","ФИО35","Причина35",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":3},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":0.5},16,51,"255 Манчаровское","ошлл","2016-03-02T03:00:00",null,null,"ФИО36","Причина36",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":3},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},17,53,"1020 Знаменское","gfg","2016-02-29","2016-02-29T04:00:00","Перенос","ФИО38","Причина38",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":0.5},17,53,"1020 Знаменское","gfg","2016-02-29T04:00:00",null,null,"ФИО39","Причина39",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":1},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":0.5},4,50,"255 Манчаровское",null,"2016-02-03T03:00:00",null,null,"аіавіа","аііваіва",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},18,60,"ffff","rrrrr","2016-02-03T01:00:00","2016-02-03T01:30:00","Перенос","апа","рпрп",{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":1},18,60,"ffff","rrrrr","2016-02-03T01:30:00","2016-02-03T01:50:00","Перенос",null,null,{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]
[{"$f":"IF(Данные[[#This Row],[Статус]]=\"\",0.5,IF(Данные[[#This Row],[Статус]]=\"Перенос\",1,IF(Данные[[#This Row],[Статус]]=\"Выполнено\",2,3)))","v":0.5},18,60,"ffff","rrrrr","2016-02-03T01:50:00",null,null,null,null,{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Выполнено\")","v":0},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Перенос\")","v":2},{"$f":"COUNTIFS(Данные[№],Данные[[#This Row],[№]],Данные[Статус],\"Отмена\")","v":0},{"$f":"Данные[[#This Row],[Выполнено]]+Данные[[#This Row],[Отменено]]","v":0}]

{"sheet":"График-сут","index":1,"n_rows":24,"n_cols":34,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MIN(B1:Y1)","v":"2016-02-03"},{"$f":"42400+Z3","v":42403},{"$f":"B2","v":42403.041666666664},42403.083333333328,42403.124999999993,42403.166666666657,42403.208333333321,42403.249999999985,42403.29166666665,42403.333333333314,42403.374999999978,42403.416666666642,42403.458333333307,42403.499999999971,42403.541666666635,42403.583333333299,42403.624999999964,42403.666666666628,42403.708333333292,42403.749999999956,42403.791666666621,42403.833333333285,42403.874999999949,42403.916666666613,42403.958333333278,null,null,1]
[{"$f":"MAX(B2:Y2)","v":"2016-02-04"},{"$f":"B1+1/24","v":42403.041666666664},{"$f":"C1+1/24","v":42403.083333333328},{"$f":"D1+1/24","v":42403.124999999993},42403.166666666657,42403.208333333321,42403.249999999985,42403.29166666665,42403.333333333314,42403.374999999978,42403.416666666642,42403.458333333307,42403.499999999971,42403.541666666635,42403.583333333299,42403.624999999964,42403.666666666628,42403.708333333292,42403.749999999956,42403.791666666621,42403.833333333285,42403.874999999949,42403.916666666613,42403.958333333278,42403.999999999942]
[0,{"$f":"B1","v":"2016-02-03"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-03"]
["БРИГАДА",{"$f":"TEXT(B1,\"чч:мм\")&\"-\"&TEXT(B2,\"чч:мм\")","v":"00:00-01:00"},{"$f":"TEXT(C1,\"чч:мм\")&\"-\"&TEXT(C2,\"чч:мм\")","v":"01:00-02:00"},"02:00-03:00","03:00-04:00","04:00-05:00","05:00-06:00","06:00-07:00","07:00-08:00","08:00-09:00","09:00-10:00","10:00-11:00","11:00-12:00","12:00-13:00","13:00-14:00","14:00-15:00","15:00-16:00","16:00-17:00","17:00-18:00","18:00-19:00","19:00-20:00","20:00-21:00","21:00-22:00","22:00-23:00","23:00-00:00",null,0]
[50,null,null,1,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заказ",{"$f":"IF(AB$1>0,INDEX(Данные[],AB$1,2),\"\")","v":1},{"$f":"IF(AC$1>0,INDEX(Данные[],AC$1,2),\"\")","v":""},{"$f":"IF(AD$1>0,INDEX(Данные[],AD$1,2),\"\")","v":""},{"$f":"IF(AE$1>0,INDEX(Данные[],AE$1,2),\"\")","v":""},{"$f":"IF(AF$1>0,INDEX(Данные[],AF$1,2),\"\")","v":""},{"$f":"IF(AG$1>0,INDEX(Данные[],AG$1,2),\"\")","v":""},{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,2),\"\")","v":""}]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Бригада",{"$f":"IF(AB$1>0,INDEX(Данные[],AB$1,3),\"\")","v":54},{"$f":"IF(AC$1>0,INDEX(Данные[],AC$1,3),\"\")","v":""},{"$f":"IF(AD$1>0,INDEX(Данные[],AD$1,3),\"\")","v":""},{"$f":"IF(AE$1>0,INDEX(Данные[],AE$1,3),\"\")","v":""},{"$f":"IF(AF$1>0,INDEX(Данные[],AF$1,3),\"\")","v":""},{"$f":"IF(AG$1>0,INDEX(Данные[],AG$1,3),\"\")","v":""},{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,3),\"\")","v":""}]
[52,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,"Объект",{"$f":"IF(AB$1>0,INDEX(Данные[],AB$1,4),\"\")","v":"1020 Знаменское"},{"$f":"IF(AC$1>0,INDEX(Данные[],AC$1,4),\"\")","v":""},{"$f":"IF(AD$1>0,INDEX(Данные[],AD$1,4),\"\")","v":""},{"$f":"IF(AE$1>0,INDEX(Данные[],AE$1,4),\"\")","v":""},{"$f":"IF(AF$1>0,INDEX(Данные[],AF$1,4),\"\")","v":""},{"$f":"IF(AG$1>0,INDEX(Данные[],AG$1,4),\"\")","v":""},{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,4),\"\")","v":""}]
[53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Вид работ",{"$f":"IF(AB$1>0,INDEX(Данные[],AB$1,5),\"\")","v":"ВП + 3ц.ж."},{"$f":"IF(AC$1>0,INDEX(Данные[],AC$1,5),\"\")","v":""},{"$f":"IF(AD$1>0,INDEX(Данные[],AD$1,5),\"\")","v":""},{"$f":"IF(AE$1>0,INDEX(Данные[],AE$1,5),\"\")","v":""},{"$f":"IF(AF$1>0,INDEX(Данные[],AF$1,5),\"\")","v":""},{"$f":"IF(AG$1>0,INDEX(Данные[],AG$1,5),\"\")","v":""},{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,5),\"\")","v":""}]
[54,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Начало",{"$f":"IF(AB$1>0,INDEX(Данные[],AB$1,6),\"\")","v":"2016-02-03T08:00:00"},{"$f":"IF(AC$1>0,INDEX(Данные[],AC$1,6),\"\")","v":""},{"$f":"IF(AD$1>0,INDEX(Данные[],AD$1,6),\"\")","v":""},{"$f":"IF(AE$1>0,INDEX(Данные[],AE$1,6),\"\")","v":""},{"$f":"IF(AF$1>0,INDEX(Данные[],AF$1,6),\"\")","v":""},{"$f":"IF(AG$1>0,INDEX(Данные[],AG$1,6),\"\")","v":""},{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,6),\"\")","v":""}]
[55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Завершение",{"$f":"IF(AB$1>0,INDEX(Данные[],AB$1,7),\"\")","v":"2016-02-04T12:00:00"},{"$f":"IF(AC$1>0,INDEX(Данные[],AC$1,7),\"\")","v":""},{"$f":"IF(AD$1>0,INDEX(Данные[],AD$1,7),\"\")","v":""},{"$f":"IF(AE$1>0,INDEX(Данные[],AE$1,7),\"\")","v":""},{"$f":"IF(AF$1>0,INDEX(Данные[],AF$1,7),\"\")","v":""},{"$f":"IF(AG$1>0,INDEX(Данные[],AG$1,7),\"\")","v":""},{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,7),\"\")","v":""}]
[56,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,"Статус",{"$f":"IF(AB$1>0,INDEX(Данные[],AB$1,8),\"\")","v":"Перенос"},{"$f":"IF(AC$1>0,INDEX(Данные[],AC$1,8),\"\")","v":""},{"$f":"IF(AD$1>0,INDEX(Данные[],AD$1,8),\"\")","v":""},{"$f":"IF(AE$1>0,INDEX(Данные[],AE$1,8),\"\")","v":""},{"$f":"IF(AF$1>0,INDEX(Данные[],AF$1,8),\"\")","v":""},{"$f":"IF(AG$1>0,INDEX(Данные[],AG$1,8),\"\")","v":""},{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,8),\"\")","v":""}]
[57,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,"ФИО",{"$f":"IF(AB$1>0,INDEX(Данные[],AB$1,9),\"\")","v":"ФИО1"},{"$f":"IF(AC$1>0,INDEX(Данные[],AC$1,9),\"\")","v":""},{"$f":"IF(AD$1>0,INDEX(Данные[],AD$1,9),\"\")","v":""},{"$f":"IF(AE$1>0,INDEX(Данные[],AE$1,9),\"\")","v":""},{"$f":"IF(AF$1>0,INDEX(Данные[],AF$1,9),\"\")","v":""},{"$f":"IF(AG$1>0,INDEX(Данные[],AG$1,9),\"\")","v":""},{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,9),\"\")","v":""}]
[58,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,"Причина",{"$f":"IF(AB$1>0,INDEX(Данные[],AB$1,10),\"\")","v":"Причина1"},{"$f":"IF(AC$1>0,INDEX(Данные[],AC$1,10),\"\")","v":""},{"$f":"IF(AD$1>0,INDEX(Данные[],AD$1,10),\"\")","v":""},{"$f":"IF(AE$1>0,INDEX(Данные[],AE$1,10),\"\")","v":""},{"$f":"IF(AF$1>0,INDEX(Данные[],AF$1,10),\"\")","v":""},{"$f":"IF(AG$1>0,INDEX(Данные[],AG$1,10),\"\")","v":""},{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,10),\"\")","v":""}]
[59]
[60,null,0.5,null,null,null,null,null,null,1]
[61]
[62]
[63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[64]
[65]
[66]
[67]
[68]
[69]

{"sheet":"График-4ч","index":2,"n_rows":24,"n_cols":40,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MIN(B1:AE1)","v":"2016-02-04"},{"$f":"AF3+42400","v":"2016-02-04"},{"$f":"B2","v":"2016-02-04T04:00:00"},"2016-02-04T08:00:00","2016-02-04T12:00:00","2016-02-04T16:00:00","2016-02-04T20:00:00","2016-02-05","2016-02-05T04:00:00","2016-02-05T08:00:00","2016-02-05T12:00:00","2016-02-05T16:00:00","2016-02-05T20:00:00","2016-02-06","2016-02-06T04:00:00","2016-02-06T08:00:00","2016-02-06T12:00:00","2016-02-06T16:00:00","2016-02-06T20:00:00","2016-02-07","2016-02-07T04:00:00","2016-02-07T08:00:00","2016-02-07T12:00:00","2016-02-07T16:00:00","2016-02-07T20:00:00","2016-02-08","2016-02-08T04:00:00","2016-02-08T08:00:00","2016-02-08T12:00:00","2016-02-08T16:00:00","2016-02-08T20:00:00",null,null,13]
[{"$f":"MAX(B2:AE2)","v":"2016-02-09"},{"$f":"B1+1/6","v":"2016-02-04T04:00:00"},"2016-02-04T08:00:00","2016-02-04T12:00:00","2016-02-04T16:00:00","2016-02-04T20:00:00","2016-02-05","2016-02-05T04:00:00","2016-02-05T08:00:00","2016-02-05T12:00:00","2016-02-05T16:00:00","2016-02-05T20:00:00","2016-02-06","2016-02-06T04:00:00","2016-02-06T08:00:00","2016-02-06T12:00:00","2016-02-06T16:00:00","2016-02-06T20:00:00","2016-02-07","2016-02-07T04:00:00","2016-02-07T08:00:00","2016-02-07T12:00:00","2016-02-07T16:00:00","2016-02-07T20:00:00","2016-02-08","2016-02-08T04:00:00","2016-02-08T08:00:00","2016-02-08T12:00:00","2016-02-08T16:00:00","2016-02-08T20:00:00","2016-02-09"]
[5442404,{"$f":"B1","v":"2016-02-04"},null,null,null,null,null,{"$f":"B3+1","v":"2016-02-05"},null,null,null,null,null,{"$f":"H3+1","v":"2016-02-06"},null,null,null,null,null,{"$f":"N3+1","v":"2016-02-07"},null,null,null,null,null,{"$f":"T3+1","v":"2016-02-08"},null,null,null,null,null,"1900-01-04"]
["БРИГАДА",{"$f":"TEXT(B1,\"чч:мм\")&\"-\"&TEXT(B2,\"чч:мм\")","v":"00:00-04:00"},{"$f":"TEXT(C1,\"чч:мм\")&\"-\"&TEXT(C2,\"чч:мм\")","v":"04:00-08:00"},"08:00-12:00","12:00-16:00","16:00-20:00","20:00-00:00","00:00-04:00","04:00-08:00","08:00-12:00","12:00-16:00","16:00-20:00","20:00-00:00","00:00-04:00","04:00-08:00","08:00-12:00","12:00-16:00","16:00-20:00","20:00-00:00","00:00-04:00","04:00-08:00","08:00-12:00","12:00-16:00","16:00-20:00","20:00-00:00","00:00-04:00","04:00-08:00","08:00-12:00","12:00-16:00","16:00-20:00","20:00-00:00",null,0]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заказ",{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,2),\"\")","v":7},{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,2),\"\")","v":""},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,2),\"\")","v":""},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,2),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,2),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,2),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,2),\"\")","v":""}]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Бригада",{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,3),\"\")","v":53},{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,3),\"\")","v":""},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,3),\"\")","v":""},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,3),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,3),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,3),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,3),\"\")","v":""}]
[52,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,"Объект",{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,4),\"\")","v":"255 Манчаровское"},{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,4),\"\")","v":""},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,4),\"\")","v":""},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,4),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,4),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,4),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,4),\"\")","v":""}]
[53,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Вид работ",{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,5),\"\")","v":"ub"},{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,5),\"\")","v":""},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,5),\"\")","v":""},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,5),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,5),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,5),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,5),\"\")","v":""}]
[54,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,"Начало",{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,6),\"\")","v":"2016-02-05T05:30:00"},{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,6),\"\")","v":""},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,6),\"\")","v":""},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,6),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,6),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,6),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,6),\"\")","v":""}]
[55,null,1,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,"Завершение",{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,7),\"\")","v":"2016-02-21T01:00:00"},{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,7),\"\")","v":""},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,7),\"\")","v":""},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,7),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,7),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,7),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,7),\"\")","v":""}]
[56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Статус",{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,8),\"\")","v":"Перенос"},{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,8),\"\")","v":""},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,8),\"\")","v":""},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,8),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,8),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,8),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,8),\"\")","v":""}]
[57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ФИО",{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,9),\"\")","v":"ФИО13"},{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,9),\"\")","v":""},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,9),\"\")","v":""},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,9),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,9),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,9),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,9),\"\")","v":""}]
[58,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,"Причина",{"$f":"IF(AH$1>0,INDEX(Данные[],AH$1,10),\"\")","v":"Причина13"},{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,10),\"\")","v":""},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,10),\"\")","v":""},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,10),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,10),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,10),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,10),\"\")","v":""}]
[59]
[60,null,null,null,2]
[61]
[62,null,1,null,null,null,null,null,2]
[63]
[64]
[65]
[66]
[67]
[68]
[69,null,null,null,null,null,null,null,1]

{"sheet":"График-мес","index":3,"n_rows":24,"n_cols":41,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MIN(B1:AD1)","v":"2016-02-01"},{"$f":"B3","v":"2016-02-01"},{"$f":"IF(MONTH(B2)=MONTH(B1),B2,0)","v":"2016-02-02"},{"$f":"IF(MONTH(C2)=MONTH(C1),C2,0)","v":"2016-02-03"},"2016-02-04","2016-02-05","2016-02-06","2016-02-07","2016-02-08","2016-02-09","2016-02-10","2016-02-11","2016-02-12","2016-02-13","2016-02-14","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-20","2016-02-21","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27","2016-02-28","2016-02-29","00:00:00","00:00:00",null,null,37,38]
[{"$f":"DATE(YEAR(A1),MONTH(A1)+1,1)","v":"2016-03-01"},{"$f":"IF(B1=0,0,B1+1)","v":"2016-02-02"},{"$f":"IF(C1=0,0,C1+1)","v":"2016-02-03"},{"$f":"IF(D1=0,0,D1+1)","v":"2016-02-04"},"2016-02-05","2016-02-06","2016-02-07","2016-02-08","2016-02-09","2016-02-10","2016-02-11","2016-02-12","2016-02-13","2016-02-14","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-20","2016-02-21","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27","2016-02-28","2016-02-29","2016-03-01","00:00:00","00:00:00"]
[5042403,{"$f":"DATE(2016,AG3,1)","v":"2016-02-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,null,"1900-01-02"]
["БРИГАДА",{"$f":"B1","v":"2016-02-01"},{"$f":"C1","v":"2016-02-02"},"2016-02-03","2016-02-04","2016-02-05","2016-02-06","2016-02-07","2016-02-08","2016-02-09","2016-02-10","2016-02-11","2016-02-12","2016-02-13","2016-02-14","2016-02-15","2016-02-16","2016-02-17","2016-02-18","2016-02-19","2016-02-20","2016-02-21","2016-02-22","2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27","2016-02-28","2016-02-29","00:00:00",{"$f":"AF1","v":"00:00:00"},null,0]
[50,1,1,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заказ",{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,2),\"\")","v":17},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,2),\"\")","v":17},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,2),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,2),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,2),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,2),\"\")","v":""},{"$f":"IF(AO$1>0,INDEX(Данные[],AO$1,2),\"\")","v":""}]
[51,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,1,null,null,null,"Бригада",{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,3),\"\")","v":53},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,3),\"\")","v":53},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,3),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,3),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,3),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,3),\"\")","v":""},{"$f":"IF(AO$1>0,INDEX(Данные[],AO$1,3),\"\")","v":""}]
[52,null,null,1,null,null,null,1,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,"Объект",{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,4),\"\")","v":"1020 Знаменское"},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,4),\"\")","v":"1020 Знаменское"},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,4),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,4),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,4),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,4),\"\")","v":""},{"$f":"IF(AO$1>0,INDEX(Данные[],AO$1,4),\"\")","v":""}]
[53,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,3,null,null,null,null,null,0.5,null,null,null,"Вид работ",{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,5),\"\")","v":"gfg"},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,5),\"\")","v":"gfg"},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,5),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,5),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,5),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,5),\"\")","v":""},{"$f":"IF(AO$1>0,INDEX(Данные[],AO$1,5),\"\")","v":""}]
[54,null,null,1,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,"Начало",{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,6),\"\")","v":"2016-02-29"},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,6),\"\")","v":"2016-02-29T04:00:00"},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,6),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,6),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,6),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,6),\"\")","v":""},{"$f":"IF(AO$1>0,INDEX(Данные[],AO$1,6),\"\")","v":""}]
[55,null,null,null,1,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,"Завершение",{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,7),\"\")","v":"2016-02-29T04:00:00"},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,7),\"\")","v":"00:00:00"},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,7),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,7),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,7),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,7),\"\")","v":""},{"$f":"IF(AO$1>0,INDEX(Данные[],AO$1,7),\"\")","v":""}]
[56,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,"Статус",{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,8),\"\")","v":"Перенос"},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,8),\"\")","v":0},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,8),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,8),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,8),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,8),\"\")","v":""},{"$f":"IF(AO$1>0,INDEX(Данные[],AO$1,8),\"\")","v":""}]
[57,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,"ФИО",{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,9),\"\")","v":"ФИО38"},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,9),\"\")","v":"ФИО39"},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,9),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,9),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,9),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,9),\"\")","v":""},{"$f":"IF(AO$1>0,INDEX(Данные[],AO$1,9),\"\")","v":""}]
[58,null,null,1,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,"Причина",{"$f":"IF(AI$1>0,INDEX(Данные[],AI$1,10),\"\")","v":"Причина38"},{"$f":"IF(AJ$1>0,INDEX(Данные[],AJ$1,10),\"\")","v":"Причина39"},{"$f":"IF(AK$1>0,INDEX(Данные[],AK$1,10),\"\")","v":""},{"$f":"IF(AL$1>0,INDEX(Данные[],AL$1,10),\"\")","v":""},{"$f":"IF(AM$1>0,INDEX(Данные[],AM$1,10),\"\")","v":""},{"$f":"IF(AN$1>0,INDEX(Данные[],AN$1,10),\"\")","v":""},{"$f":"IF(AO$1>0,INDEX(Данные[],AO$1,10),\"\")","v":""}]
[59,1,2]
[60,null,null,0.5,2]
[61]
[62,null,2,null,1,2]
[63,null,null,3]
[64]
[65]
[66]
[67]
[68]
[69,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,0.5]

{"sheet":"Классификатор","index":4,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Бригады",null,"Статус"]
[50,null,"Перенос"]
[51,null,"Отмена"]
[52,null,"Выполнено"]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]