{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"9","index":0,"n_rows":12,"n_cols":190,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,7,6,10]]}
[null,null,null,null,null,null,"Done",{"$f":"HOUR(NOW())","v":16},{"$f":"MINUTE(NOW())","v":56},"Сб","Вс"]
[null,{"$f":"CONCATENATE(H1,\":\",I1)","v":"16:56"},{"$f":"'[1]Статус 2016'!J15","v":"ТЕСТ СТАТУСА"}]
[null,{"$f":"TODAY()","v":"2017-07-04"},{"$f":"'[1]Статус 2016'!I15","v":9}]
[]
[null,null,{"$f":"IF(SUM('9'!$H$8:$H9937)=0,\"По данному проекту на сегодня нет задач.\",\"Есть задачи на сегодня!\")","v":"По данному проекту на сегодня нет задач."},null,"Задач на сегодня:",{"$f":"SUMIF('9'!$J$8:$J$9962,1)","v":0}]
[null,null,{"$f":"IF(SUM('9'!$K$8:$K$9937)>0,CONCATENATE(\"Просроченных задач: \",SUMIF(K8:K9937,1)),\"нет\")","v":"нет"},null,"Всего задач:",{"$f":"SUMIF('9'!$I$8:$I$9958,1)","v":4},null,null,null,null,null,null,"НЕ ТРОГАТЬ БЛОК ТАЙМИНГА"]
[null,"ДОКУМЕНТООБОРОТ",null,"УКАЗАТЬ СРОКИ",null,null,null,"не удалять столбцы!",null,null,null,"2017-01-09","2017-06-27",{"$f":"M7+1","v":"2017-06-28"},"2017-06-29","2017-06-30","2017-07-01","2017-07-02","2017-07-03","2017-07-04","2017-07-05","2017-07-06","2017-07-07","2017-07-08","2017-07-09","2017-07-10","2017-07-11","2017-07-12","2017-07-13","2017-07-14","2017-07-15","2017-07-16","2017-07-17","2017-07-18","2017-07-19","2017-07-20","2017-07-21","2017-07-22","2017-07-23","2017-07-24","2017-07-25","2017-07-26","2017-07-27","2017-07-28","2017-07-29","2017-07-30","2017-07-31","2017-08-01","2017-08-02","2017-08-03","2017-08-04","2017-08-05","2017-08-06","2017-08-07","2017-08-08","2017-08-09","2017-08-10","2017-08-11","2017-08-12","2017-08-13","2017-08-14","2017-08-15","2017-08-16","2017-08-17","2017-08-18","2017-08-19","2017-08-20","2017-08-21","2017-08-22","2017-08-23","2017-08-24","2017-08-25","2017-08-26","2017-08-27","2017-08-28","2017-08-29","2017-08-30",{"$f":"BY7+1","v":"2017-08-31"},"2017-09-01","2017-09-02","2017-09-03","2017-09-04","2017-09-05","2017-09-06","2017-09-07","2017-09-08","2017-09-09","2017-09-10","2017-09-11","2017-09-12","2017-09-13","2017-09-14","2017-09-15","2017-09-16","2017-09-17","2017-09-18","2017-09-19","2017-09-20","2017-09-21","2017-09-22","2017-09-23","2017-09-24","2017-09-25","2017-09-26","2017-09-27","2017-09-28","2017-09-29","2017-09-30","2017-10-01","2017-10-02","2017-10-03","2017-10-04","2017-10-05","2017-10-06","2017-10-07","2017-10-08","2017-10-09","2017-10-10","2017-10-11","2017-10-12","2017-10-13","2017-10-14","2017-10-15","2017-10-16","2017-10-17","2017-10-18","2017-10-19","2017-10-20","2017-10-21","2017-10-22","2017-10-23","2017-10-24","2017-10-25","2017-10-26","2017-10-27","2017-10-28","2017-10-29","2017-10-30","2017-10-31","2017-11-01","2017-11-02",{"$f":"EK7+1","v":"2017-11-03"},"2017-11-04","2017-11-05","2017-11-06","2017-11-07","2017-11-08","2017-11-09","2017-11-10","2017-11-11","2017-11-12","2017-11-13","2017-11-14","2017-11-15","2017-11-16","2017-11-17","2017-11-18","2017-11-19","2017-11-20","2017-11-21","2017-11-22","2017-11-23","2017-11-24","2017-11-25","2017-11-26","2017-11-27","2017-11-28","2017-11-29","2017-11-30","2017-12-01","2017-12-02","2017-12-03","2017-12-04","2017-12-05","2017-12-06","2017-12-07","2017-12-08","2017-12-09","2017-12-10","2017-12-11","2017-12-12","2017-12-13","2017-12-14","2017-12-15","2017-12-16","2017-12-17","2017-12-18","2017-12-19","2017-12-20","2017-12-21"]
[null,"Задача","Комментарий","Начало","DL","Ответственный","Статус","Р1","Р2","Р3","Р4",{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}},{"$f":"TEXT(WEEKDAY(#REF!,1),\"ДДД\")","v":{"$error":"#REF!"}}]
[null,"Согласовать договор",null,"2017-06-30","2017-07-06",null,null,{"$f":"IF(AND(E9<=$B$3,G9=0,B9<>\"Новая задача\",E9<>\"\"),1,0)","v":0},{"$f":"IF('9'!$G9=$G$1,0,1)","v":1},{"$f":"IF(AND('9'!$E9=$B$3,'9'!$G9<>$G$1),1,0)","v":0},{"$f":"IF(AND('9'!$E9<$B$3,'9'!$G9<>$G$1,B9<>\"Новая задача\",E9<>\"\"),1,0)","v":0},{"$f":"IF($D9<=L$7,IF($E9>=L$7,IF($E9=L$7,2,1),0),0)","v":0},0,0,0,1,1,1,1,1,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Отправить заявку на приложение",null,null,null,null,null,{"$f":"IF(AND(E10<=$B$3,G10=0,B10<>\"Новая задача\",E10<>\"\"),1,0)","v":0},{"$f":"IF('9'!$G10=$G$1,0,1)","v":1},{"$f":"IF(AND('9'!$E10=$B$3,'9'!$G10<>$G$1),1,0)","v":0},{"$f":"IF(AND('9'!$E10<$B$3,'9'!$G10<>$G$1,B10<>\"Новая задача\",E10<>\"\"),1,0)","v":0},{"$f":"IF($D10<=L$7,IF($E10>=L$7,IF($E10=L$7,2,1),0),0)","v":0},{"$f":"IF($D10<=M$7,IF($E10>=M$7,IF($E10=M$7,2,1),0),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($D10<=W$7,IF($E10>=W$7,IF($E10=W$7,2,1),0),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($D10<=AG$7,IF($E10>=AG$7,IF($E10=AG$7,2,1),0),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($D10<=AQ$7,IF($E10>=AQ$7,IF($E10=AQ$7,2,1),0),0)","v":0},0,0,0,0,0]
[null,"Согласовать приложение",null,null,null,null,null,{"$f":"IF(AND(E11<=$B$3,G11=0,B11<>\"Новая задача\",E11<>\"\"),1,0)","v":0},{"$f":"IF('9'!$G11=$G$1,0,1)","v":1},{"$f":"IF(AND('9'!$E11=$B$3,'9'!$G11<>$G$1),1,0)","v":0},{"$f":"IF(AND('9'!$E11<$B$3,'9'!$G11<>$G$1,B11<>\"Новая задача\",E11<>\"\"),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Согласовать приложение",null,null,null,null,null,{"$f":"IF(AND(E12<=$B$3,G12=0,B12<>\"Новая задача\",E12<>\"\"),1,0)","v":0},{"$f":"IF('9'!$G12=$G$1,0,1)","v":1},{"$f":"IF(AND('9'!$E12=$B$3,'9'!$G12<>$G$1),1,0)","v":0},{"$f":"IF(AND('9'!$E12<$B$3,'9'!$G12<>$G$1,B12<>\"Новая задача\",E12<>\"\"),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]