{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Шаблон"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":217,"n_cols":35,"rows_kept":217,"cut":false,"hidden":false,"merged":[[47,13,47,15],[30,13,30,16],[48,14,49,14],[48,13,49,13],[48,15,49,15],[7,18,7,34],[1,4,1,6],[2,4,2,6],[1,7,1,9],[2,7,2,9],[3,0,3,1],[4,0,4,1],[5,0,5,1],[0,0,0,2],[3,13,3,17],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17],[0,13,0,16],[0,4,0,9],[1,0,1,1],[2,0,2,1],[12,13,12,16],[13,13,14,13],[13,14,14,14],[13,15,14,15],[13,16,14,16]]}
["Количество текущих горячих задач у сотрудника",null,null,null,"Панель распределения задач",null,null,null,null,null,null,null,null,"Отчет о загрузке персонала по выполнению горячх задач"]
["Сотрудник 1",null,{"$f":"COUNTIFS($B$9:$B$217,A2,$H$9:$H$217,\"\")","v":0},null,"Задача",null,null,"Формирование спецификации",null,null,null,null,null,{"$f":"TODAY()","v":"2013-11-25"}]
["Сотрудник 2",null,{"$f":"COUNTIFS($B$9:$B$217,A3,$H$9:$H$217,\"\")","v":0},null,"Сотрудник",null,null,"Сотрудник 2"]
["Сотрудник 3",null,{"$f":"COUNTIFS($B$9:$B$217,A4,$H$9:$H$217,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,"Отчет о выполненных задачах за день (по сотрудникам)"]
["Сотрудник 4",null,{"$f":"COUNTIFS($B$9:$B$217,A5,$H$9:$H$217,\"\")","v":0},null,null,null,null,null,null,null,null,null,null,"Сотрудник","Количество задач","Время выполнения","Количество отклонений от норматива продажника","Невыполненных операций"]
["Сотрудник 5",null,{"$f":"COUNTIFS($B$9:$B$217,A6,$H$9:$H$217,\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A2","v":"Сотрудник 1"},{"$f":"COUNTIF(B$9:$B$217,$N7)","v":0},{"$f":"SUMIF($B$9:$B$217,N7,$I$9:$I$217)","v":"00:00:00"},{"$f":"COUNTIFS(K:K,\"нет\",B:B,N7)","v":0},{"$f":"COUNTIFS(G:G,$Y$18,B:B,N7)","v":0}]
["№","Сотрудник","Тип задачи","Поступление заявки","Сотрудник приступил","Время начала","Результат операции","Время конца","Продолжительность","Выполнение норматива сотрудника","Выполнение норматива продажника","Причина ошибки",null,{"$f":"A3","v":"Сотрудник 2"},{"$f":"COUNTIF(B$9:$B$217,$N8)","v":0},{"$f":"SUMIF($B$9:$B$217,N8,$I$9:$I$217)","v":"00:00:00"},{"$f":"COUNTIFS(J:J,\"нет\",B:B,N8)","v":0},{"$f":"COUNTIFS(G:G,$Y$18,B:B,N8)","v":0},"Административные ячейки"]
[{"$f":"IF(B9=\"\",\"\",X9)","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(H9=\"\",G9=\"Не выполнено\"),\"\",H9-D9)","v":""},{"$f":"IF(OR(AI9=\"\",G9=\"Не выполнено\"),\"\",Z9)","v":""},{"$f":"IF(OR(AF9=\"\",G9=\"Не выполнено\"),\"\",AB9)","v":""},{"$f":"IF(G9=\"Выполнено\",\"Нет ошибки\",\"\")","v":""},null,{"$f":"A4","v":"Сотрудник 3"},{"$f":"COUNTIF(B$9:$B$217,$N9)","v":0},{"$f":"SUMIF($B$9:$B$217,N9,$I$9:$I$217)","v":"00:00:00"},{"$f":"COUNTIFS(J:J,\"нет\",B:B,N9)","v":0},{"$f":"COUNTIFS(G:G,$Y$18,B:B,N9)","v":0},null,null,null,null,null,1,null,{"$f":"IF(I9=0,\"\",AA9)","v":"да"},{"$f":"IF(AG9<0.95,\"нет\",\"да\")","v":"да"},{"$f":"IF(I9=0,\"\",AC9)","v":"да"},{"$f":"IF(AD9<0.97,\"нет\",\"да\")","v":"да"},{"$f":"IF(AND(D9>0,H9>0),AF9/AE9,\"\")","v":""},{"$f":"IF(AND(D9>0,H9>0),I9*24*60,\"\")","v":""},{"$f":"IF(AND(D9>0,H9>0),VLOOKUP(C9,Q$51:R$62,2,0),\"\")","v":""},{"$f":"IF(AND(D9>0,H9>0),AI9/AH9,\"\")","v":""},{"$f":"IF(AND(D9>0,H9>0),I9*24*60,\"\")","v":""},{"$f":"IF(AND(D9>0,H9>0),VLOOKUP(C9,N$51:O$62,2,0),\"\")","v":""}]
[{"$f":"IF(B10=\"\",\"\",X10)","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(H10=\"\",G10=\"Не выполнено\"),\"\",H10-D10)","v":""},{"$f":"IF(OR(AI10=\"\",G10=\"Не выполнено\"),\"\",Z10)","v":""},{"$f":"IF(OR(AF10=\"\",G10=\"Не выполнено\"),\"\",AB10)","v":""},{"$f":"IF(G10=\"Выполнено\",\"Нет ошибки\",\"\")","v":""},null,{"$f":"A5","v":"Сотрудник 4"},{"$f":"COUNTIF(B$9:$B$217,$N10)","v":0},{"$f":"SUMIF($B$9:$B$217,N10,$I$9:$I$217)","v":"00:00:00"},{"$f":"COUNTIFS(J:J,\"нет\",B:B,N10)","v":0},{"$f":"COUNTIFS(G:G,$Y$18,B:B,N10)","v":0},null,null,null,null,null,2,null,{"$f":"IF(I10=0,\"\",AA10)","v":"да"},{"$f":"IF(AG10<0.95,\"нет\",\"да\")","v":"да"},{"$f":"IF(I10=0,\"\",AC10)","v":"да"},{"$f":"IF(AD10<0.97,\"нет\",\"да\")","v":"да"},{"$f":"IF(AND(D10>0,H10>0),AF10/AE10,\"\")","v":""},{"$f":"IF(AND(D10>0,H10>0),I10*24*60,\"\")","v":""},{"$f":"IF(AND(D10>0,H10>0),VLOOKUP(C10,Q$51:R$62,2,0),\"\")","v":""},{"$f":"IF(AND(D10>0,H10>0),AI10/AH10,\"\")","v":""},{"$f":"IF(AND(D10>0,H10>0),I10*24*60,\"\")","v":""},{"$f":"IF(AND(D10>0,H10>0),VLOOKUP(C10,N$51:O$62,2,0),\"\")","v":""}]
["",null,null,null,null,null,null,null,"","","","",null,{"$f":"A6","v":"Сотрудник 5"},{"$f":"COUNTIF(B$9:$B$217,$N11)","v":0},{"$f":"SUMIF($B$9:$B$217,N11,$I$9:$I$217)","v":"00:00:00"},{"$f":"COUNTIFS(J:J,\"нет\",B:B,N11)","v":0},{"$f":"COUNTIFS(G:G,$Y$18,B:B,N11)","v":0},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,4,"да","да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Отчет о выполненых задачах за день (по задачам)",null,null,null,null,null,null,null,null,null,5,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,7,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,{"$f":"N51","v":"Выставление счета на продажу"},{"$f":"COUNTIF(C$9:$C$217,$N16)","v":0},{"$f":"SUMIF($C$9:$C$217,N16,$I$9:$I$217)","v":"00:00:00"},{"$f":"IF(OR(S16=\"нет\",S16=\"да\"),S16,\"\")","v":""},null,{"$f":"IF(V16=0,0,T16)","v":0},{"$f":"IF(U16<0.95,\"нет\",\"да\")","v":{"$error":"#DIV/0!"}},{"$f":"(O16*V51)/V16","v":{"$error":"#DIV/0!"}},{"$f":"P16*24*60","v":0},null,8,"Резульаты операций","да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Формирование договора и спецификации",{"$f":"COUNTIF(C$9:$C$217,$N17)","v":0},"00:00:00",{"$f":"IF(OR(S17=\"нет\",S17=\"да\"),S17,\"\")","v":""},null,{"$f":"IF(V17=0,0,T17)","v":0},{"$f":"IF(U17<0.95,\"нет\",\"да\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P17*24*60","v":0},null,9,"Выполнено","да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Формирование спецификации",{"$f":"COUNTIF(C$9:$C$217,$N18)","v":0},"00:00:00","",null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,10,"Не выполнено","да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Выставление счета на ремонт",{"$f":"COUNTIF(C$9:$C$217,$N19)","v":0},"00:00:00","",null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,11,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Формирование договора на ремонт",{"$f":"COUNTIF(C$9:$C$217,$N20)","v":0},"00:00:00","",null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,12,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Внесение нового клиента",{"$f":"COUNTIF(C$9:$C$217,$N21)","v":0},"00:00:00","",null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,13,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Исправление информации о клиенте",{"$f":"COUNTIF(C$9:$C$217,$N22)","v":0},"00:00:00","",null,{"$f":"IF(V22=0,0,T22)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,14,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Урегулирование протокола разногласий",{"$f":"COUNTIF(C$9:$C$217,$N23)","v":0},"00:00:00","",null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,15,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Редактирование счета",{"$f":"COUNTIF(C$9:$C$217,$N24)","v":0},"00:00:00","",null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,16,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Аннулирование счета",{"$f":"COUNTIF(C$9:$C$217,$N25)","v":0},"00:00:00","",null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,17,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Подготовка документов на самовывоз",{"$f":"COUNTIF(C$9:$C$217,$N26)","v":0},"00:00:00","",null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,18,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Выполнение заявки в произвольной форме",{"$f":"COUNTIF(C$9:$C$217,$N27)","v":0},"00:00:00","",null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,null,19,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,20,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Отчет принял:",null,null,null,null,null,null,null,null,null,21,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,22,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Руководитель отдела____________________      Подпись___________________________",null,null,null,null,null,null,null,null,null,23,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,24,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,25,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,26,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,27,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,28,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,29,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,30,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,31,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,32,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,33,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,34,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,35,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,36,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,37,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,38,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,39,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Таблица норматив на выполнение задач",null,null,null,null,null,null,null,null,null,40,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Задачи","Норматив для сотрудника (мин)","Норматив для продажника (мин)",null,null,null,null,null,null,null,41,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,"Выставление счета на продажу",3,10,{"$f":"N51","v":"Выставление счета на продажу"},{"$f":"P51","v":10},null,null,null,{"$f":"P51","v":10},null,43,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Формирование договора и спецификации",10,20,"Формирование договора и спецификации",{"$f":"P52","v":20},null,null,null,{"$f":"P52","v":20},null,44,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Формирование спецификации",3,10,"Формирование спецификации",10,null,null,null,10,null,45,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Выставление счета на ремонт",3,10,"Выставление счета на ремонт",10,null,null,null,10,null,46,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Формирование договора на ремонт",10,20,"Формирование договора на ремонт",20,null,null,null,20,null,47,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Внесение нового клиента",3,10,"Внесение нового клиента",10,null,null,null,10,null,48,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Исправление информации о клиенте",3,10,"Исправление информации о клиенте",10,null,null,null,10,null,49,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Урегулирование протокола разногласий",20,30,"Урегулирование протокола разногласий",30,null,null,null,30,null,50,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Редактирование счета",4,10,"Редактирование счета",10,null,null,null,10,null,51,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Аннулирование счета",4,10,"Аннулирование счета",10,null,null,null,10,null,52,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Подготовка документов на самовывоз",4,10,"Подготовка документов на самовывоз",10,null,null,null,10,null,53,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,"Выполнение заявки в произвольной форме","-",10,"Выполнение заявки в произвольной форме",10,null,null,null,10,null,54,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,55,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,56,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,57,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,58,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,59,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,60,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,61,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,62,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,63,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,64,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,65,null,"да","да","да","да","","","","","",""]
[{"$f":"IF(B74=\"\",\"\",X74)","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(H74=\"\",G74=\"Не выполнено\"),\"\",H74-D74)","v":""},{"$f":"IF(OR(AI74=\"\",G74=\"Не выполнено\"),\"\",Z74)","v":""},{"$f":"IF(OR(AF74=\"\",G74=\"Не выполнено\"),\"\",AB74)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,66,null,{"$f":"IF(I74=0,\"\",AA74)","v":"да"},{"$f":"IF(AG74<0.95,\"нет\",\"да\")","v":"да"},{"$f":"IF(I74=0,\"\",AC74)","v":"да"},{"$f":"IF(AD74<0.97,\"нет\",\"да\")","v":"да"},{"$f":"IF(AND(D74>0,H74>0),AF74/AE74,\"\")","v":""},{"$f":"IF(AND(D74>0,H74>0),I74*24*60,\"\")","v":""},{"$f":"IF(AND(D74>0,H74>0),VLOOKUP(C74,Q$51:R$62,2,0),\"\")","v":""},{"$f":"IF(AND(D74>0,H74>0),AI74/AH74,\"\")","v":""},{"$f":"IF(AND(D74>0,H74>0),I74*24*60,\"\")","v":""},{"$f":"IF(AND(D74>0,H74>0),VLOOKUP(C74,N$51:O$62,2,0),\"\")","v":""}]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,67,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,68,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,69,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",{"$f":"IF(G78=\"Выполнено\",\"Нет ошибки\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,70,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,71,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,72,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,73,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,74,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,75,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,76,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,77,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,78,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,79,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,80,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,81,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,82,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,83,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,84,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,85,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,86,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,87,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,88,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,89,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,90,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,91,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,92,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,93,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,94,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,95,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,96,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,97,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,98,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,99,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,100,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,101,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,102,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,103,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,104,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,105,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,106,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,107,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,108,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,109,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,110,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,111,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,112,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,113,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,114,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,115,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,116,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,117,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,118,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,119,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,120,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,121,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,122,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,123,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,124,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,125,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,126,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,127,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,128,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,129,null,"да","да","да","да","","","","","",""]
[{"$f":"IF(B138=\"\",\"\",X138)","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(H138=\"\",G138=\"Не выполнено\"),\"\",H138-D138)","v":""},{"$f":"IF(OR(AI138=\"\",G138=\"Не выполнено\"),\"\",Z138)","v":""},{"$f":"IF(OR(AF138=\"\",G138=\"Не выполнено\"),\"\",AB138)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,130,null,{"$f":"IF(I138=0,\"\",AA138)","v":"да"},{"$f":"IF(AG138<0.95,\"нет\",\"да\")","v":"да"},{"$f":"IF(I138=0,\"\",AC138)","v":"да"},{"$f":"IF(AD138<0.97,\"нет\",\"да\")","v":"да"},{"$f":"IF(AND(D138>0,H138>0),AF138/AE138,\"\")","v":""},{"$f":"IF(AND(D138>0,H138>0),I138*24*60,\"\")","v":""},{"$f":"IF(AND(D138>0,H138>0),VLOOKUP(C138,Q$51:R$62,2,0),\"\")","v":""},{"$f":"IF(AND(D138>0,H138>0),AI138/AH138,\"\")","v":""},{"$f":"IF(AND(D138>0,H138>0),I138*24*60,\"\")","v":""},{"$f":"IF(AND(D138>0,H138>0),VLOOKUP(C138,N$51:O$62,2,0),\"\")","v":""}]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,131,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,132,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,133,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",{"$f":"IF(G142=\"Выполнено\",\"Нет ошибки\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,134,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,135,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,136,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,137,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,138,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,139,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,140,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,141,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,142,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,143,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,144,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,145,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,146,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,147,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,148,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,149,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,150,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,151,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,152,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,153,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,154,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,155,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,156,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,157,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,158,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,159,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,160,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,161,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,162,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,163,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,164,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,165,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,166,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,167,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,168,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,169,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,170,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,171,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,172,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,173,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,174,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,175,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,176,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,177,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,178,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,179,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,180,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,181,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,182,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,183,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,184,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,185,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,186,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,187,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,188,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,189,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,190,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,191,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,192,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,193,null,"да","да","да","да","","","","","",""]
[{"$f":"IF(B202=\"\",\"\",X202)","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(H202=\"\",G202=\"Не выполнено\"),\"\",H202-D202)","v":""},{"$f":"IF(OR(AI202=\"\",G202=\"Не выполнено\"),\"\",Z202)","v":""},{"$f":"IF(OR(AF202=\"\",G202=\"Не выполнено\"),\"\",AB202)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,194,null,{"$f":"IF(I202=0,\"\",AA202)","v":"да"},{"$f":"IF(AG202<0.95,\"нет\",\"да\")","v":"да"},{"$f":"IF(I202=0,\"\",AC202)","v":"да"},{"$f":"IF(AD202<0.97,\"нет\",\"да\")","v":"да"},{"$f":"IF(AND(D202>0,H202>0),AF202/AE202,\"\")","v":""},{"$f":"IF(AND(D202>0,H202>0),I202*24*60,\"\")","v":""},{"$f":"IF(AND(D202>0,H202>0),VLOOKUP(C202,Q$51:R$62,2,0),\"\")","v":""},{"$f":"IF(AND(D202>0,H202>0),AI202/AH202,\"\")","v":""},{"$f":"IF(AND(D202>0,H202>0),I202*24*60,\"\")","v":""},{"$f":"IF(AND(D202>0,H202>0),VLOOKUP(C202,N$51:O$62,2,0),\"\")","v":""}]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,195,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,196,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,197,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","",{"$f":"IF(G206=\"Выполнено\",\"Нет ошибки\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,198,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,199,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,200,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,201,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,202,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,203,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,204,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,205,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,206,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,207,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,208,null,"да","да","да","да","","","","","",""]
["",null,null,null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,209,null,"да","да","да","да","","","","","",""]