{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Главная","Задачи","Справочник"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":69,"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":24,"n_cols":41,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,32,4,39],[4,40,4,47],[7,32,7,39],[7,40,7,47],[12,32,12,39],[12,40,12,47],[6,32,6,39],[6,40,6,47],[10,32,10,39],[10,40,10,47],[8,40,8,47],[9,40,9,47],[8,32,8,39],[9,32,9,39],[20,8,20,15],[21,8,21,15],[22,8,22,15],[23,8,23,15],[12,24,12,31],[19,8,19,15],[1,2,1,3],[17,8,17,15],[18,8,18,15],[4,24,4,31],[6,24,6,31],[7,24,7,31],[8,24,8,31],[9,24,9,31],[1,14,1,19],[1,11,1,13],[1,4,1,9],[10,8,10,15],[12,8,12,15],[6,8,6,15],[8,8,8,15],[10,24,10,31]]}
[]
[null,null,"Дата:",null,"2016-12-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,"Итого",null,null,null,null,null,null,null,"Начислено",null,null,null,null,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(ГлавнаяДата>=TODAY(),VLOOKUP(ГлавнаяУчастник,УчастникиТаблица,5,0),SUM(AG7:AV7))","v":0},null,null,null,null,null,null,null,{"$f":"SUMIFS(ЗадачиРезультатыБаллыФакт,ЗадачиУчастникиОтветственныйИмена,ГлавнаяУчастник,ЗадачиВыполнениеСтатусДатыСтатуса,\"<=\"&ГлавнаяДата,ЗадачиВыполнениеСтатусыОсновные,\"=\"&\"Завершена\",ЗадачиРезультатыБаллыФакт,\">\"&0)","v":0},null,null,null,null,null,null,null,{"$f":"SUMIFS(ЗадачиРезультатыБаллыФакт,ЗадачиУчастникиОтветственныйИмена,ГлавнаяУчастник,ЗадачиВыполнениеСтатусДатыСтатуса,\"<=\"&ГлавнаяДата,ЗадачиВыполнениеСтатусыОсновные,\"=\"&\"Завершена\",ЗадачиРезультатыБаллыФакт,\"<\"&0)","v":0}]
[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(ГлавнаяДата>=TODAY(),VLOOKUP(ГлавнаяУчастник,УчастникиТаблица,6,0),SUM(AG8:AV8))","v":0},null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,"-"]
[null,null,"Роль",null,null,null,null,null,{"$f":"VLOOKUP(ГлавнаяУчастник,УчастникиТаблица,2,0)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,"Нормы",null,null,null,null,null,{"$f":"IF(ГлавнаяДата>=TODAY(),VLOOKUP(ГлавнаяУчастник,УчастникиТаблица,7,0),SUM(AG9:AV9))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,{"$f":"SUMIFS(ЗначенияБаллы,ЗначенияУчастникИмена,ГлавнаяУчастник,ЗначенияДаты,\"<=\"&ГлавнаяДата,ЗначенияБаллы,\">\"&0)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,{"$f":"SUMIFS(ЗначенияБаллы,ЗначенияУчастникИмена,ГлавнаяУчастник,ЗначенияДаты,\"<=\"&ГлавнаяДата,ЗначенияБаллы,\"<\"&0)","v":{"$error":"#NAME?"}}]
[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(ГлавнаяДата>=TODAY(),VLOOKUP(ГлавнаяУчастник,УчастникиТаблица,8,0),SUM(AG10:AV10))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,{"$f":"SUMIFS(РейтингиБаллыФакт,РейтингиУчастникИмена,ГлавнаяУчастник,РейтингиДатаКонец,\"<=\"&ГлавнаяДата,РейтингиБаллыФакт,\">\"&0)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,{"$f":"SUMIFS(РейтингиБаллыФакт,РейтингиУчастникИмена,ГлавнаяУчастник,РейтингиДатаКонец,\"<=\"&ГлавнаяДата,РейтингиБаллыФакт,\"<\"&0)","v":{"$error":"#NAME?"}}]
[null,null,"Уровень",null,null,null,null,null,{"$f":"VLOOKUP(ГлавнаяУчастник,УчастникиТаблица,3,0)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,"Бонусы",null,null,null,null,null,{"$f":"IF(ГлавнаяДата>=TODAY(),VLOOKUP(ГлавнаяУчастник,УчастникиТаблица,9,0),SUM(AG11:AV11))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,{"$f":"SUMIFS(НачисленияБаллы,НачисленияУчастникиИмена,ГлавнаяУчастник,НачисленияДаты,\"<=\"&ГлавнаяДата,НачисленияБаллы,\">\"&0)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,{"$f":"SUMIFS(НачисленияБаллы,НачисленияУчастникиИмена,ГлавнаяУчастник,НачисленияДаты,\"<=\"&ГлавнаяДата,НачисленияБаллы,\"<\"&0)","v":{"$error":"#NAME?"}}]
[]
[null,null,"Рейтинг",null,null,null,null,null,{"$f":"SUMIFS(РейтингиРейтинги,РейтингиУчастникИмена,ГлавнаяУчастник,РейтингиДатаНачало,\"<=\"&ГлавнаяДата,РейтингиДатаКонец,\">=\"&ГлавнаяДата)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,"Итого",null,null,null,null,null,{"$f":"IF(AND(ГлавнаяДата>=TODAY(),SUM(Y7:AF11)<>SUM(AG13:AV13)),\"ОШИБКА!\",SUM(Y7:AF11))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,{"$f":"SUM(AG7:AN11)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,{"$f":"SUM(AO7:AV11)","v":{"$error":"#NAME?"}}]
[]
[]
[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":"COUNTIFS(ЗадачиУчастникиОтветственныйИмена,ГлавнаяУчастник,ЗадачиВыполнениеСтатусДатыСтатуса,\"<=\"&ГлавнаяДата,ЗадачиВыполнениеСтатусыОсновные,\"<>\"&\"\")","v":0}]
[null,null,"Подготовленные",null,null,null,null,null,{"$f":"COUNTIFS(ЗадачиУчастникиОтветственныйИмена,ГлавнаяУчастник,ЗадачиВыполнениеСтатусДатыСтатуса,\"<=\"&ГлавнаяДата,ЗадачиВыполнениеСтатусыОсновные,\"=\"&\"Подготовлена\")","v":0}]
[null,null,"Выполняются",null,null,null,null,null,{"$f":"COUNTIFS(ЗадачиУчастникиОтветственныйИмена,ГлавнаяУчастник,ЗадачиВыполнениеСтатусДатыСтатуса,\"<=\"&ГлавнаяДата,ЗадачиВыполнениеСтатусыОсновные,\"=\"&\"Выполняется\")","v":0}]
[null,null,"Просроченные",null,null,null,null,null,{"$f":"COUNTIFS(ЗадачиУчастникиОтветственныйИмена,ГлавнаяУчастник,ЗадачиВыполнениеСтатусДатыСтатуса,\"<=\"&ГлавнаяДата,ЗадачиВыполнениеСтатусыОсновные,\"<>\"&\"Завершена\",ЗадачиВыполнениеОтклонениеСтатусыСрока,\"=\"&\"Просрочена\")","v":0}]
[null,null,"Отложенные",null,null,null,null,null,{"$f":"COUNTIFS(ЗадачиУчастникиОтветственныйИмена,ГлавнаяУчастник,ЗадачиВыполнениеСтатусДатыСтатуса,\"<=\"&ГлавнаяДата,ЗадачиВыполнениеСтатусыОсновные,\"=\"&\"Отложена\")","v":0}]
[null,null,"Выполненные",null,null,null,null,null,{"$f":"COUNTIFS(ЗадачиУчастникиОтветственныйИмена,ГлавнаяУчастник,ЗадачиВыполнениеСтатусДатыСтатуса,\"<=\"&ГлавнаяДата,ЗадачиВыполнениеСтатусыПодчиненные,\"=\"&\"Выполнена\")","v":0}]
[null,null,"Завершенные",null,null,null,null,null,{"$f":"COUNTIFS(ЗадачиУчастникиОтветственныйИмена,ГлавнаяУчастник,ЗадачиВыполнениеСтатусДатыСтатуса,\"<=\"&ГлавнаяДата,ЗадачиВыполнениеСтатусыОсновные,\"=\"&\"Завершена\")","v":0}]

{"sheet":"Задачи","index":1,"n_rows":33,"n_cols":59,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,53,0,58],[1,56,1,58],[1,55,3,55],[2,47,3,47],[1,47,1,52],[2,48,2,52],[2,57,3,57],[2,58,3,58],[0,20,0,52],[2,56,3,56],[1,53,3,53],[2,20,3,20],[2,22,3,22],[2,23,2,29],[1,34,1,38],[2,44,2,46],[1,54,3,54],[2,40,3,40],[2,41,3,41],[1,33,3,33],[2,39,3,39],[1,39,1,41],[2,42,2,43],[1,42,1,46],[2,36,2,38],[0,0,4,0],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,8,3,8],[0,1,4,1],[2,2,3,2],[2,3,3,3],[0,2,0,5],[1,6,3,6],[2,4,3,4],[0,6,0,19],[1,2,1,3],[1,4,1,5],[2,5,3,5],[1,20,1,32],[2,34,2,35],[2,30,2,32],[2,21,3,21],[2,12,3,12],[1,16,3,16],[1,19,3,19],[1,15,3,15],[1,17,1,18],[2,17,3,17],[2,18,3,18],[1,7,1,12],[2,7,3,7],[1,13,3,13],[1,14,3,14]]}
["№","Ур","Участники",null,null,null,"Планирование",null,null,null,null,null,null,null,null,null,null,null,null,null,"Выполнение",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Результаты"]
[null,null,"Постановщик",null,"Ответственный",null,"Категория (Ценности)","Цель",null,null,null,null,null,"Комментарий","Приложение","Кайрос","Теги","Горизонт",null,"Приоритет","Повторение",null,null,null,null,null,null,null,null,null,null,null,null,"Дата создания","План",null,null,null,null,"Статус",null,null,"Факт",null,null,null,null,"Отклонение",null,null,null,null,null,"Тип задачи","Уровень сложности","Оценка","Баллы"]
[null,null,"Имя","Роль","Имя","Роль",null,1,2,3,4,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Пн","Вт","Ср","Чт","Пт","Сб","Вс","Начало","Интервал","Конец",null,"Начало","Конец","Дни","Часы","Трудозатраты",null,null,null,"Начало","Конец","Дни","Часы","Трудозатраты",null,"Дни","Часы","Дни","Часы","Трудозатраты"]
[]
["ЗадачиНомер","ЗадачиУровни","УчастникиПостановщикИмя","УчастникиПостановщикРоль","УчастникиОтветственныйИмя","УчастникиОтветственныйРоль","ПланированиеКатегория","ПланированиеЗадачи1","ПланированиеЗадачи2","ПланированиеЗадачи3","ПланированиеЗадачи4","ПланированиеЗадачи5","ПланированиеЗадачиЧекЛист","ПланированиеКомментарий","ПланированиеПриложение","ПланированиеКайрос","ПланированиеТеги","ПланированиеГоризонтНачало","ПланированиеГоризонтКонец","ПланированиеПриоритет","ВыполнениеПовторениеПериод","ВыполнениеПовторениеИнтервал","ВыполнениеПовторениеЧастота","ВыполнениеПовторениеДниНеделиПн","ВыполнениеПовторениеДниНеделиВт","ВыполнениеПовторениеДниНеделиСр","ВыполнениеПовторениеДниНеделиЧт","ВыполнениеПовторениеДниНеделиПт","ВыполнениеПовторениеДниНеделиСб","ВыполнениеПовторениеДниНеделиВс","ВыполнениеПовторениеДатаНачало",null,"ВыполнениеПовторениеДатаСоздания","ВыполнениеДатаСоздания","ВыполнениеПланДатаНачало","ВыполнениеПланДатаКонец","ВыполнениеПланДлительностьДни","ВыполнениеПланДлительностьЧасы","ВыполнениеПланДлительностьТрудозатраты","ВыполнениеСтатусОсновной","ВыполнениеСтатусПодчиненный","ВыполнениеСтатусДатаСтатуса","ВыполнениеФактДатаНачало","ВыполнениеФактДатаКонец","ВыполнениеФактДлительностьДни","ВыполнениеФактДлительностьЧасы","ВыполнениеФактДлительностьТрудозатраты","ВыполнениеОтклонениеСтатусСрока","ВыполнениеОтклонениеДлительностьДни","ВыполнениеОтклонениеДлительностьЧасы","ВыполнениеОтклонениеДлительностьДниОстаток","ВыполнениеОтклонениеДлительностьЧасыОстаток","ВыполнениеОтклонениеДлительностьТрудозатратыОстаток","РезультатыТипЗадачи","РезультатыУровеньСложности","РезультатыОценка","РезультатыБаллыЭталон","РезультатыБаллыФакт","РезультатыБаллыОтклонение"]
[1,{"$f":"IF($H7<>\"\",$H$3,IF($I7<>\"\",$I$3,IF($J7<>\"\",$J$3,IF($K7<>\"\",$K$3,IF($L7<>\"\",$L$3,\"\")))))","v":1},"ФИ3",null,"ФИ3",null,"Здоровье","Физическая форма",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AI7=\"\",AQ7=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AQ7=\"\",AI7,AQ7)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AQ7=\"\",AI7,AQ7)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":"День"},{"$f":"IF(AND(AJ7=\"\",AR7=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AR7=\"\",AJ7,AR7)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AR7=\"\",AJ7,AR7)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":"День"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U7=\"\",\"\",DATE(YEAR(AI7),MONTH(AI7)+(SUMIF(Справочник!$J$5:$J$8,U7,Справочник!$K$5:$K$8)*V7),DAY(AI7)+(SUMIF(Справочник!$J$2:$J$4,U7,Справочник!$K$2:$K$4)*V7))+TIME(HOUR(AI7),MINUTE(AI7),SECOND(AI7)))","v":""},{"$f":"IF(OR(U7=\"\",W7=\"\"),\"\",DATE(YEAR(AE7),MONTH(AE7)+(SUMIF(Справочник!$J$5:$J$8,U7,Справочник!$K$5:$K$8)*V7*W7),DAY(AE7)+(SUMIF(Справочник!$J$2:$J$4,U7,Справочник!$K$2:$K$4)*V7*W7)))","v":""},"2015-11-15","2015-11-15T01:00:00","2016-12-31T09:00:00",{"$f":"IF(OR(AI7=\"\",AJ7=\"\"),\"\",(AJ7-AI7)-MOD(AJ7-AI7,1))","v":412},{"$f":"IF(OR(AI7=\"\",AJ7=\"\"),\"\",HOUR(MOD(AJ7-AI7,1)))","v":8},null,"Выполняется","Принята","2015-11-15","2015-11-15T03:00:00","2017-02-02T22:00:00",{"$f":"IF(AQ7=\"\",\"\",IF(AR7=\"\",(NOW()-AQ7)-MOD(NOW()-AQ7,1),(AR7-AQ7)-MOD(AR7-AQ7,1)))","v":445},{"$f":"IF(AQ7=\"\",\"\",IF(AR7=\"\",HOUR(MOD(NOW()-AQ7,1)),HOUR(MOD(AR7-AQ7,1))))","v":19},null,{"$f":"IF(AN7=\"\",\"\",IF(AN7=\"Подготовлена\",\"Не определен\",IF(AJ7<>\"\",IF(OR(IF(AR7=\"\",NOW()>AJ7,AR7>$AJ7),IF(AND(AU7<>\"\",AM7<>\"\"),AU7>AM7)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Просрочена"},{"$f":"IF(AI7=\"\",\"\",IF(AR7=\"\",(NOW()-AI7)-MOD(NOW()-AI7,1),(AR7-AI7)-MOD(AR7-AI7,1)))","v":445},{"$f":"IF(AI7=\"\",\"\",IF(AR7=\"\",HOUR(MOD(NOW()-AI7,1)),HOUR(MOD(AR7-AI7,1))))","v":21},{"$f":"IF(OR(AK7=\"\",AW7=\"\"),\"\",AK7-AW7)","v":-33},{"$f":"IF(OR(AL7=\"\",AX7=\"\"),\"\",AL7-AX7)","v":-13},{"$f":"IF(OR(AM7=\"\",AU7=\"\"),\"\",(AU7-AM7)*IF(AU7>=AM7,1,-1))","v":""},"Проект","Высокий","Нет оценки"]
[2,{"$f":"IF($H8<>\"\",$H$3,IF($I8<>\"\",$I$3,IF($J8<>\"\",$J$3,IF($K8<>\"\",$K$3,IF($L8<>\"\",$L$3,\"\")))))","v":2},"ФИ3",null,"ФИ3",null,"Здоровье",null,"АА",null,null,null,null,null,null,null,null,{"$f":"IF(AND(AI8=\"\",AQ8=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AQ8=\"\",AI8,AQ8)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AQ8=\"\",AI8,AQ8)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":"День"},{"$f":"IF(AND(AJ8=\"\",AR8=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AR8=\"\",AJ8,AR8)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AR8=\"\",AJ8,AR8)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":"День"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",DATE(YEAR(AI8),MONTH(AI8)+(SUMIF(Справочник!$J$5:$J$8,U8,Справочник!$K$5:$K$8)*V8),DAY(AI8)+(SUMIF(Справочник!$J$2:$J$4,U8,Справочник!$K$2:$K$4)*V8))+TIME(HOUR(AI8),MINUTE(AI8),SECOND(AI8)))","v":""},{"$f":"IF(OR(U8=\"\",W8=\"\"),\"\",DATE(YEAR(AE8),MONTH(AE8)+(SUMIF(Справочник!$J$5:$J$8,U8,Справочник!$K$5:$K$8)*V8*W8),DAY(AE8)+(SUMIF(Справочник!$J$2:$J$4,U8,Справочник!$K$2:$K$4)*V8*W8)))","v":""},"2015-11-15","2015-11-15T01:00:00","2016-12-31T09:00:00",{"$f":"IF(OR(AI8=\"\",AJ8=\"\"),\"\",(AJ8-AI8)-MOD(AJ8-AI8,1))","v":412},{"$f":"IF(OR(AI8=\"\",AJ8=\"\"),\"\",HOUR(MOD(AJ8-AI8,1)))","v":8},null,"Выполняется","Принята","2015-11-15","2015-11-15T03:00:00","2017-02-02T22:00:00",{"$f":"IF(AQ8=\"\",\"\",IF(AR8=\"\",(NOW()-AQ8)-MOD(NOW()-AQ8,1),(AR8-AQ8)-MOD(AR8-AQ8,1)))","v":445},{"$f":"IF(AQ8=\"\",\"\",IF(AR8=\"\",HOUR(MOD(NOW()-AQ8,1)),HOUR(MOD(AR8-AQ8,1))))","v":19},null,{"$f":"IF(AN8=\"\",\"\",IF(AN8=\"Подготовлена\",\"Не определен\",IF(AJ8<>\"\",IF(OR(IF(AR8=\"\",NOW()>AJ8,AR8>$AJ8),IF(AND(AU8<>\"\",AM8<>\"\"),AU8>AM8)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Просрочена"},{"$f":"IF(AI8=\"\",\"\",IF(AR8=\"\",(NOW()-AI8)-MOD(NOW()-AI8,1),(AR8-AI8)-MOD(AR8-AI8,1)))","v":445},{"$f":"IF(AI8=\"\",\"\",IF(AR8=\"\",HOUR(MOD(NOW()-AI8,1)),HOUR(MOD(AR8-AI8,1))))","v":21},{"$f":"IF(OR(AK8=\"\",AW8=\"\"),\"\",AK8-AW8)","v":-33},{"$f":"IF(OR(AL8=\"\",AX8=\"\"),\"\",AL8-AX8)","v":-13},{"$f":"IF(OR(AM8=\"\",AU8=\"\"),\"\",(AU8-AM8)*IF(AU8>=AM8,1,-1))","v":""},"Проект","Высокий","Нет оценки"]
[3,3,"ФИ3",null,"ФИ3",null,"Здоровье",null,null,"ААА",null,null,null,"Согласно составленной программе","Тренировки.xlsx",null,null,{"$f":"IF(AND(AI9=\"\",AQ9=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AQ9=\"\",AI9,AQ9)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AQ9=\"\",AI9,AQ9)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":"День"},{"$f":"IF(AND(AJ9=\"\",AR9=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AR9=\"\",AJ9,AR9)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AR9=\"\",AJ9,AR9)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":""},null,"День",1,null,null,null,null,null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",DATE(YEAR(AI9),MONTH(AI9)+(SUMIF(Справочник!$J$5:$J$8,U9,Справочник!$K$5:$K$8)*V9),DAY(AI9)+(SUMIF(Справочник!$J$2:$J$4,U9,Справочник!$K$2:$K$4)*V9))+TIME(HOUR(AI9),MINUTE(AI9),SECOND(AI9)))","v":"2016-07-02"},{"$f":"IF(OR(U9=\"\",W9=\"\"),\"\",DATE(YEAR(AE9),MONTH(AE9)+(SUMIF(Справочник!$J$5:$J$8,U9,Справочник!$K$5:$K$8)*V9*W9),DAY(AE9)+(SUMIF(Справочник!$J$2:$J$4,U9,Справочник!$K$2:$K$4)*V9*W9)))","v":""},"2016-07-01","2016-07-01",null,{"$f":"IF(OR(AI9=\"\",AJ9=\"\"),\"\",(AJ9-AI9)-MOD(AJ9-AI9,1))","v":""},{"$f":"IF(OR(AI9=\"\",AJ9=\"\"),\"\",HOUR(MOD(AJ9-AI9,1)))","v":""},1.0416666666666666E-2,"Выполняется","Принята","2016-07-01","2016-07-01",null,{"$f":"IF(AQ9=\"\",\"\",IF(AR9=\"\",(NOW()-AQ9)-MOD(NOW()-AQ9,1),(AR9-AQ9)-MOD(AR9-AQ9,1)))","v":260},{"$f":"IF(AQ9=\"\",\"\",IF(AR9=\"\",HOUR(MOD(NOW()-AQ9,1)),HOUR(MOD(AR9-AQ9,1))))","v":10},1.0416666666666666E-2,{"$f":"IF(AN9=\"\",\"\",IF(AN9=\"Подготовлена\",\"Не определен\",IF(AJ9<>\"\",IF(OR(IF(AR9=\"\",NOW()>AJ9,AR9>$AJ9),IF(AND(AU9<>\"\",AM9<>\"\"),AU9>AM9)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI9=\"\",\"\",IF(AR9=\"\",(NOW()-AI9)-MOD(NOW()-AI9,1),(AR9-AI9)-MOD(AR9-AI9,1)))","v":260},{"$f":"IF(AI9=\"\",\"\",IF(AR9=\"\",HOUR(MOD(NOW()-AI9,1)),HOUR(MOD(AR9-AI9,1))))","v":10},{"$f":"IF(OR(AK9=\"\",AW9=\"\"),\"\",AK9-AW9)","v":""},{"$f":"IF(OR(AL9=\"\",AX9=\"\"),\"\",AL9-AX9)","v":""},{"$f":"IF(OR(AM9=\"\",AU9=\"\"),\"\",(AU9-AM9)*IF(AU9>=AM9,1,-1))","v":0},"Проект","Низкий"]
[4,4,"ФИ3",null,"ФИ3",null,"Здоровье",null,null,null,"АААА",null,null,null,null,"Дом",null,"День","День",null,"День",1,null,null,null,null,null,null,null,null,"2016-07-20T06:00:00",{"$f":"IF(U10=\"\",\"\",DATE(YEAR(AI10),MONTH(AI10)+(SUMIF(Справочник!$J$5:$J$8,U10,Справочник!$K$5:$K$8)*V10),DAY(AI10)+(SUMIF(Справочник!$J$2:$J$4,U10,Справочник!$K$2:$K$4)*V10))+TIME(HOUR(AI10),MINUTE(AI10),SECOND(AI10)))","v":"2016-07-21T06:00:00"},{"$f":"IF(OR(U10=\"\",W10=\"\"),\"\",DATE(YEAR(AE10),MONTH(AE10)+(SUMIF(Справочник!$J$5:$J$8,U10,Справочник!$K$5:$K$8)*V10*W10),DAY(AE10)+(SUMIF(Справочник!$J$2:$J$4,U10,Справочник!$K$2:$K$4)*V10*W10)))","v":""},"2016-07-20","2016-07-20T06:00:00","2016-07-20T07:00:00",0,1,1.0416666666666666E-2,"Завершена","Выполнена","2016-07-20T07:00:00","2016-07-20T06:00:00","2016-07-20T07:00:00",0,1,1.0416666666666666E-2,{"$f":"IF(AN10=\"\",\"\",IF(AN10=\"Подготовлена\",\"Не определен\",IF(AJ10<>\"\",IF(OR(IF(AR10=\"\",NOW()>AJ10,AR10>$AJ10),IF(AND(AU10<>\"\",AM10<>\"\"),AU10>AM10)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI10=\"\",\"\",IF(AR10=\"\",(NOW()-AI10)-MOD(NOW()-AI10,1),(AR10-AI10)-MOD(AR10-AI10,1)))","v":0},{"$f":"IF(AI10=\"\",\"\",IF(AR10=\"\",HOUR(MOD(NOW()-AI10,1)),HOUR(MOD(AR10-AI10,1))))","v":1},{"$f":"IF(OR(AK10=\"\",AW10=\"\"),\"\",AK10-AW10)","v":0},{"$f":"IF(OR(AL10=\"\",AX10=\"\"),\"\",AL10-AX10)","v":0},{"$f":"IF(OR(AM10=\"\",AU10=\"\"),\"\",(AU10-AM10)*IF(AU10>=AM10,1,-1))","v":0},"Задача","Низкий","Положительная"]
[5,4,"ФИ3",null,"ФИ3",null,"Здоровье",null,null,null,"АААБ",null,null,null,null,"Дом",null,"День","День",null,"День",1,null,null,null,null,null,null,null,null,"2016-07-21T06:00:00",{"$f":"IF(U11=\"\",\"\",DATE(YEAR(AI11),MONTH(AI11)+(SUMIF(Справочник!$J$5:$J$8,U11,Справочник!$K$5:$K$8)*V11),DAY(AI11)+(SUMIF(Справочник!$J$2:$J$4,U11,Справочник!$K$2:$K$4)*V11))+TIME(HOUR(AI11),MINUTE(AI11),SECOND(AI11)))","v":"2016-07-22T06:00:00"},{"$f":"IF(OR(U11=\"\",W11=\"\"),\"\",DATE(YEAR(AE11),MONTH(AE11)+(SUMIF(Справочник!$J$5:$J$8,U11,Справочник!$K$5:$K$8)*V11*W11),DAY(AE11)+(SUMIF(Справочник!$J$2:$J$4,U11,Справочник!$K$2:$K$4)*V11*W11)))","v":""},"2016-07-20",{"$f":"AE11","v":"2016-07-21T06:00:00"},"2016-07-22",0,18,1.0416666666666666E-2,"Завершена","Не выполнена","2016-07-21","2016-07-21T07:00:00","2016-07-22T05:00:00",{"$f":"IF(AQ11=\"\",\"\",IF(AR11=\"\",(NOW()-AQ11)-MOD(NOW()-AQ11,1),(AR11-AQ11)-MOD(AR11-AQ11,1)))","v":0},{"$f":"IF(AQ11=\"\",\"\",IF(AR11=\"\",HOUR(MOD(NOW()-AQ11,1)),HOUR(MOD(AR11-AQ11,1))))","v":22},1.0416666666666666E-2,{"$f":"IF(AN11=\"\",\"\",IF(AN11=\"Подготовлена\",\"Не определен\",IF(AJ11<>\"\",IF(OR(IF(AR11=\"\",NOW()>AJ11,AR11>$AJ11),IF(AND(AU11<>\"\",AM11<>\"\"),AU11>AM11)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Просрочена"},{"$f":"IF(AI11=\"\",\"\",IF(AR11=\"\",(NOW()-AI11)-MOD(NOW()-AI11,1),(AR11-AI11)-MOD(AR11-AI11,1)))","v":0},{"$f":"IF(AI11=\"\",\"\",IF(AR11=\"\",HOUR(MOD(NOW()-AI11,1)),HOUR(MOD(AR11-AI11,1))))","v":23},{"$f":"IF(OR(AK11=\"\",AW11=\"\"),\"\",AK11-AW11)","v":0},{"$f":"IF(OR(AL11=\"\",AX11=\"\"),\"\",AL11-AX11)","v":-5},{"$f":"IF(OR(AM11=\"\",AU11=\"\"),\"\",(AU11-AM11)*IF(AU11>=AM11,1,-1))","v":0},"Задача","Низкий"]
[6,3,"ФИ3",null,"ФИ3",null,"Здоровье",null,null,"ААБ",null,null,null,"Согласно составленной программе","Тренировки.xlsx",null,null,"День","День",null,"День",1,null,null,null,null,null,null,null,null,"2016-07-20T06:00:00",{"$f":"IF(U12=\"\",\"\",DATE(YEAR(AI12),MONTH(AI12)+(SUMIF(Справочник!$J$5:$J$8,U12,Справочник!$K$5:$K$8)*V12),DAY(AI12)+(SUMIF(Справочник!$J$2:$J$4,U12,Справочник!$K$2:$K$4)*V12))+TIME(HOUR(AI12),MINUTE(AI12),SECOND(AI12)))","v":"2016-07-21T06:00:00"},{"$f":"IF(OR(U12=\"\",W12=\"\"),\"\",DATE(YEAR(AE12),MONTH(AE12)+(SUMIF(Справочник!$J$5:$J$8,U12,Справочник!$K$5:$K$8)*V12*W12),DAY(AE12)+(SUMIF(Справочник!$J$2:$J$4,U12,Справочник!$K$2:$K$4)*V12*W12)))","v":""},"2016-07-20","2016-07-20T06:00:00",null,"","",1.0416666666666666E-2,"Выполняется","Принята","2016-07-20T07:00:00","2016-07-20T06:00:00","2016-07-20T07:00:00",0,1,1.0416666666666666E-2,"Не просрочена",{"$f":"IF(AI12=\"\",\"\",IF(AR12=\"\",(NOW()-AI12)-MOD(NOW()-AI12,1),(AR12-AI12)-MOD(AR12-AI12,1)))","v":0},{"$f":"IF(AI12=\"\",\"\",IF(AR12=\"\",HOUR(MOD(NOW()-AI12,1)),HOUR(MOD(AR12-AI12,1))))","v":1},"",{"$f":"IF(OR(AL12=\"\",AX12=\"\"),\"\",AL12-AX12)","v":""},0,"Проект","Низкий","Положительная"]
[7,4,"ФИ3",null,"ФИ3",null,"Здоровье",null,null,null,"ААБА",null,null,"Программа 1",null,null,null,"День","День",null,"День",1,null,null,null,null,null,null,null,null,"2016-07-20T06:00:00",{"$f":"IF(U13=\"\",\"\",DATE(YEAR(AI13),MONTH(AI13)+(SUMIF(Справочник!$J$5:$J$8,U13,Справочник!$K$5:$K$8)*V13),DAY(AI13)+(SUMIF(Справочник!$J$2:$J$4,U13,Справочник!$K$2:$K$4)*V13))+TIME(HOUR(AI13),MINUTE(AI13),SECOND(AI13)))","v":"2016-07-21T06:00:00"},{"$f":"IF(OR(U13=\"\",W13=\"\"),\"\",DATE(YEAR(AE13),MONTH(AE13)+(SUMIF(Справочник!$J$5:$J$8,U13,Справочник!$K$5:$K$8)*V13*W13),DAY(AE13)+(SUMIF(Справочник!$J$2:$J$4,U13,Справочник!$K$2:$K$4)*V13*W13)))","v":""},"2016-07-20","2016-07-20T06:00:00","2016-07-20T07:00:00",0,1,1.0416666666666666E-2,"Завершена","Выполнена","2016-07-20T07:00:00","2016-07-20T06:00:00","2016-07-20T07:00:00",0,1,1.0416666666666666E-2,"Не просрочена",0,1,0,0,0,"Задача","Низкий","Положительная"]
[8,2,"ФИ3",null,"ФИ3",null,"Здоровье",null,"АБ",null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",DATE(YEAR(AI14),MONTH(AI14)+(SUMIF(Справочник!$J$5:$J$8,U14,Справочник!$K$5:$K$8)*V14),DAY(AI14)+(SUMIF(Справочник!$J$2:$J$4,U14,Справочник!$K$2:$K$4)*V14))+TIME(HOUR(AI14),MINUTE(AI14),SECOND(AI14)))","v":""},{"$f":"IF(OR(U14=\"\",W14=\"\"),\"\",DATE(YEAR(AE14),MONTH(AE14)+(SUMIF(Справочник!$J$5:$J$8,U14,Справочник!$K$5:$K$8)*V14*W14),DAY(AE14)+(SUMIF(Справочник!$J$2:$J$4,U14,Справочник!$K$2:$K$4)*V14*W14)))","v":""},null,null,null,{"$f":"IF(OR(AI14=\"\",AJ14=\"\"),\"\",(AJ14-AI14)-MOD(AJ14-AI14,1))","v":""},{"$f":"IF(OR(AI14=\"\",AJ14=\"\"),\"\",HOUR(MOD(AJ14-AI14,1)))","v":""},null,"Ждет выполнения",null,null,null,null,{"$f":"IF(AQ14=\"\",\"\",IF(AR14=\"\",(NOW()-AQ14)-MOD(NOW()-AQ14,1),(AR14-AQ14)-MOD(AR14-AQ14,1)))","v":""},{"$f":"IF(AQ14=\"\",\"\",IF(AR14=\"\",HOUR(MOD(NOW()-AQ14,1)),HOUR(MOD(AR14-AQ14,1))))","v":""},null,{"$f":"IF(AN14=\"\",\"\",IF(AN14=\"Подготовлена\",\"Не определен\",IF(AJ14<>\"\",IF(OR(IF(AR14=\"\",NOW()>AJ14,AR14>$AJ14),IF(AND(AU14<>\"\",AM14<>\"\"),AU14>AM14)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},"","","","","","Проект"]
[9,3,"ФИ3",null,"ФИ3",null,"Здоровье",null,null,"АБА",null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",DATE(YEAR(AI15),MONTH(AI15)+(SUMIF(Справочник!$J$5:$J$8,U15,Справочник!$K$5:$K$8)*V15),DAY(AI15)+(SUMIF(Справочник!$J$2:$J$4,U15,Справочник!$K$2:$K$4)*V15))+TIME(HOUR(AI15),MINUTE(AI15),SECOND(AI15)))","v":""},{"$f":"IF(OR(U15=\"\",W15=\"\"),\"\",DATE(YEAR(AE15),MONTH(AE15)+(SUMIF(Справочник!$J$5:$J$8,U15,Справочник!$K$5:$K$8)*V15*W15),DAY(AE15)+(SUMIF(Справочник!$J$2:$J$4,U15,Справочник!$K$2:$K$4)*V15*W15)))","v":""},null,null,null,"","",null,"Ждет выполнения",null,null,null,null,"","",null,"Не просрочена","","","","","","Задача"]
[10,3,"ФИ3",null,"ФИ3",null,"Здоровье",null,null,"АББ",null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",DATE(YEAR(AI16),MONTH(AI16)+(SUMIF(Справочник!$J$5:$J$8,U16,Справочник!$K$5:$K$8)*V16),DAY(AI16)+(SUMIF(Справочник!$J$2:$J$4,U16,Справочник!$K$2:$K$4)*V16))+TIME(HOUR(AI16),MINUTE(AI16),SECOND(AI16)))","v":""},{"$f":"IF(OR(U16=\"\",W16=\"\"),\"\",DATE(YEAR(AE16),MONTH(AE16)+(SUMIF(Справочник!$J$5:$J$8,U16,Справочник!$K$5:$K$8)*V16*W16),DAY(AE16)+(SUMIF(Справочник!$J$2:$J$4,U16,Справочник!$K$2:$K$4)*V16*W16)))","v":""},null,null,null,{"$f":"IF(OR(AI16=\"\",AJ16=\"\"),\"\",(AJ16-AI16)-MOD(AJ16-AI16,1))","v":""},{"$f":"IF(OR(AI16=\"\",AJ16=\"\"),\"\",HOUR(MOD(AJ16-AI16,1)))","v":""},null,"Ждет выполнения",null,null,null,null,{"$f":"IF(AQ16=\"\",\"\",IF(AR16=\"\",(NOW()-AQ16)-MOD(NOW()-AQ16,1),(AR16-AQ16)-MOD(AR16-AQ16,1)))","v":""},{"$f":"IF(AQ16=\"\",\"\",IF(AR16=\"\",HOUR(MOD(NOW()-AQ16,1)),HOUR(MOD(AR16-AQ16,1))))","v":""},null,{"$f":"IF(AN16=\"\",\"\",IF(AN16=\"Подготовлена\",\"Не определен\",IF(AJ16<>\"\",IF(OR(IF(AR16=\"\",NOW()>AJ16,AR16>$AJ16),IF(AND(AU16<>\"\",AM16<>\"\"),AU16>AM16)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI16=\"\",\"\",IF(AR16=\"\",(NOW()-AI16)-MOD(NOW()-AI16,1),(AR16-AI16)-MOD(AR16-AI16,1)))","v":""},{"$f":"IF(AI16=\"\",\"\",IF(AR16=\"\",HOUR(MOD(NOW()-AI16,1)),HOUR(MOD(AR16-AI16,1))))","v":""},{"$f":"IF(OR(AK16=\"\",AW16=\"\"),\"\",AK16-AW16)","v":""},{"$f":"IF(OR(AL16=\"\",AX16=\"\"),\"\",AL16-AX16)","v":""},{"$f":"IF(OR(AM16=\"\",AU16=\"\"),\"\",(AU16-AM16)*IF(AU16>=AM16,1,-1))","v":""},"Задача"]
[11,2,"ФИ3",null,"ФИ3",null,"Здоровье",null,"АВ",null,null,null,null,null,null,null,null,"","",null,"Месяц",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",DATE(YEAR(AI17),MONTH(AI17)+(SUMIF(Справочник!$J$5:$J$8,U17,Справочник!$K$5:$K$8)*V17),DAY(AI17)+(SUMIF(Справочник!$J$2:$J$4,U17,Справочник!$K$2:$K$4)*V17))+TIME(HOUR(AI17),MINUTE(AI17),SECOND(AI17)))","v":"00:00:00"},{"$f":"IF(OR(U17=\"\",W17=\"\"),\"\",DATE(YEAR(AE17),MONTH(AE17)+(SUMIF(Справочник!$J$5:$J$8,U17,Справочник!$K$5:$K$8)*V17*W17),DAY(AE17)+(SUMIF(Справочник!$J$2:$J$4,U17,Справочник!$K$2:$K$4)*V17*W17)))","v":""},null,null,null,{"$f":"IF(OR(AI17=\"\",AJ17=\"\"),\"\",(AJ17-AI17)-MOD(AJ17-AI17,1))","v":""},{"$f":"IF(OR(AI17=\"\",AJ17=\"\"),\"\",HOUR(MOD(AJ17-AI17,1)))","v":""},null,"Ждет выполнения",null,null,null,null,{"$f":"IF(AQ17=\"\",\"\",IF(AR17=\"\",(NOW()-AQ17)-MOD(NOW()-AQ17,1),(AR17-AQ17)-MOD(AR17-AQ17,1)))","v":""},{"$f":"IF(AQ17=\"\",\"\",IF(AR17=\"\",HOUR(MOD(NOW()-AQ17,1)),HOUR(MOD(AR17-AQ17,1))))","v":""},null,{"$f":"IF(AN17=\"\",\"\",IF(AN17=\"Подготовлена\",\"Не определен\",IF(AJ17<>\"\",IF(OR(IF(AR17=\"\",NOW()>AJ17,AR17>$AJ17),IF(AND(AU17<>\"\",AM17<>\"\"),AU17>AM17)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},"","","","","","Задача"]
[12,1,"ФИ3",null,"ФИ3",null,"Благосостояние","Жилье",null,null,null,null,null,null,null,null,null,"День","День",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",DATE(YEAR(AI18),MONTH(AI18)+(SUMIF(Справочник!$J$5:$J$8,U18,Справочник!$K$5:$K$8)*V18),DAY(AI18)+(SUMIF(Справочник!$J$2:$J$4,U18,Справочник!$K$2:$K$4)*V18))+TIME(HOUR(AI18),MINUTE(AI18),SECOND(AI18)))","v":""},{"$f":"IF(OR(U18=\"\",W18=\"\"),\"\",DATE(YEAR(AE18),MONTH(AE18)+(SUMIF(Справочник!$J$5:$J$8,U18,Справочник!$K$5:$K$8)*V18*W18),DAY(AE18)+(SUMIF(Справочник!$J$2:$J$4,U18,Справочник!$K$2:$K$4)*V18*W18)))","v":""},null,"2016-08-01","2016-12-31",152,0,null,"Выполняется","Принята","2016-08-01","2016-08-01",null,229,{"$f":"IF(AQ18=\"\",\"\",IF(AR18=\"\",HOUR(MOD(NOW()-AQ18,1)),HOUR(MOD(AR18-AQ18,1))))","v":10},null,"Просрочена",229,{"$f":"IF(AI18=\"\",\"\",IF(AR18=\"\",HOUR(MOD(NOW()-AI18,1)),HOUR(MOD(AR18-AI18,1))))","v":10},-77,-10,"","Проект"]
[13,2,"ФИ3",null,"ФИ3",null,"Благосостояние",null,"БА",null,null,null,null,null,null,null,null,{"$f":"IF(AND(AI19=\"\",AQ19=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AQ19=\"\",AI19,AQ19)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AQ19=\"\",AI19,AQ19)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":"День"},{"$f":"IF(AND(AJ19=\"\",AR19=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AR19=\"\",AJ19,AR19)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AR19=\"\",AJ19,AR19)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":"День"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",DATE(YEAR(AI19),MONTH(AI19)+(SUMIF(Справочник!$J$5:$J$8,U19,Справочник!$K$5:$K$8)*V19),DAY(AI19)+(SUMIF(Справочник!$J$2:$J$4,U19,Справочник!$K$2:$K$4)*V19))+TIME(HOUR(AI19),MINUTE(AI19),SECOND(AI19)))","v":""},{"$f":"IF(OR(U19=\"\",W19=\"\"),\"\",DATE(YEAR(AE19),MONTH(AE19)+(SUMIF(Справочник!$J$5:$J$8,U19,Справочник!$K$5:$K$8)*V19*W19),DAY(AE19)+(SUMIF(Справочник!$J$2:$J$4,U19,Справочник!$K$2:$K$4)*V19*W19)))","v":""},null,"2016-08-01","2016-12-31",{"$f":"IF(OR(AI19=\"\",AJ19=\"\"),\"\",(AJ19-AI19)-MOD(AJ19-AI19,1))","v":152},{"$f":"IF(OR(AI19=\"\",AJ19=\"\"),\"\",HOUR(MOD(AJ19-AI19,1)))","v":0},null,"Выполняется","Принята","2016-08-01","2016-08-01",null,{"$f":"IF(AQ19=\"\",\"\",IF(AR19=\"\",(NOW()-AQ19)-MOD(NOW()-AQ19,1),(AR19-AQ19)-MOD(AR19-AQ19,1)))","v":229},{"$f":"IF(AQ19=\"\",\"\",IF(AR19=\"\",HOUR(MOD(NOW()-AQ19,1)),HOUR(MOD(AR19-AQ19,1))))","v":10},null,{"$f":"IF(AN19=\"\",\"\",IF(AN19=\"Подготовлена\",\"Не определен\",IF(AJ19<>\"\",IF(OR(IF(AR19=\"\",NOW()>AJ19,AR19>$AJ19),IF(AND(AU19<>\"\",AM19<>\"\"),AU19>AM19)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Просрочена"},{"$f":"IF(AI19=\"\",\"\",IF(AR19=\"\",(NOW()-AI19)-MOD(NOW()-AI19,1),(AR19-AI19)-MOD(AR19-AI19,1)))","v":229},{"$f":"IF(AI19=\"\",\"\",IF(AR19=\"\",HOUR(MOD(NOW()-AI19,1)),HOUR(MOD(AR19-AI19,1))))","v":10},{"$f":"IF(OR(AK19=\"\",AW19=\"\"),\"\",AK19-AW19)","v":-77},{"$f":"IF(OR(AL19=\"\",AX19=\"\"),\"\",AL19-AX19)","v":-10},{"$f":"IF(OR(AM19=\"\",AU19=\"\"),\"\",(AU19-AM19)*IF(AU19>=AM19,1,-1))","v":""},"Проект"]
[14,3,"ФИ3",null,"ФИ3",null,"Благосостояние",null,null,"БАА",null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",DATE(YEAR(AI20),MONTH(AI20)+(SUMIF(Справочник!$J$5:$J$8,U20,Справочник!$K$5:$K$8)*V20),DAY(AI20)+(SUMIF(Справочник!$J$2:$J$4,U20,Справочник!$K$2:$K$4)*V20))+TIME(HOUR(AI20),MINUTE(AI20),SECOND(AI20)))","v":""},{"$f":"IF(OR(U20=\"\",W20=\"\"),\"\",DATE(YEAR(AE20),MONTH(AE20)+(SUMIF(Справочник!$J$5:$J$8,U20,Справочник!$K$5:$K$8)*V20*W20),DAY(AE20)+(SUMIF(Справочник!$J$2:$J$4,U20,Справочник!$K$2:$K$4)*V20*W20)))","v":""},null,null,null,"","",null,"Выполняется",null,null,null,null,"","",null,"Не просрочена","","","","","","Задача"]
[15,3,"ФИ3",null,"ФИ3",null,"Благосостояние",null,null,"БАБ",null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",DATE(YEAR(AI21),MONTH(AI21)+(SUMIF(Справочник!$J$5:$J$8,U21,Справочник!$K$5:$K$8)*V21),DAY(AI21)+(SUMIF(Справочник!$J$2:$J$4,U21,Справочник!$K$2:$K$4)*V21))+TIME(HOUR(AI21),MINUTE(AI21),SECOND(AI21)))","v":""},{"$f":"IF(OR(U21=\"\",W21=\"\"),\"\",DATE(YEAR(AE21),MONTH(AE21)+(SUMIF(Справочник!$J$5:$J$8,U21,Справочник!$K$5:$K$8)*V21*W21),DAY(AE21)+(SUMIF(Справочник!$J$2:$J$4,U21,Справочник!$K$2:$K$4)*V21*W21)))","v":""},null,null,null,"","",null,"Ждет выполнения",null,null,null,null,"","",null,"Не просрочена","","","","","","Задача"]
[16,3,"ФИ3",null,"ФИ3",null,"Благосостояние",null,null,"БАВ",null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",DATE(YEAR(AI22),MONTH(AI22)+(SUMIF(Справочник!$J$5:$J$8,U22,Справочник!$K$5:$K$8)*V22),DAY(AI22)+(SUMIF(Справочник!$J$2:$J$4,U22,Справочник!$K$2:$K$4)*V22))+TIME(HOUR(AI22),MINUTE(AI22),SECOND(AI22)))","v":""},{"$f":"IF(OR(U22=\"\",W22=\"\"),\"\",DATE(YEAR(AE22),MONTH(AE22)+(SUMIF(Справочник!$J$5:$J$8,U22,Справочник!$K$5:$K$8)*V22*W22),DAY(AE22)+(SUMIF(Справочник!$J$2:$J$4,U22,Справочник!$K$2:$K$4)*V22*W22)))","v":""},null,null,null,{"$f":"IF(OR(AI22=\"\",AJ22=\"\"),\"\",(AJ22-AI22)-MOD(AJ22-AI22,1))","v":""},{"$f":"IF(OR(AI22=\"\",AJ22=\"\"),\"\",HOUR(MOD(AJ22-AI22,1)))","v":""},null,"Ждет выполнения",null,null,null,null,{"$f":"IF(AQ22=\"\",\"\",IF(AR22=\"\",(NOW()-AQ22)-MOD(NOW()-AQ22,1),(AR22-AQ22)-MOD(AR22-AQ22,1)))","v":""},{"$f":"IF(AQ22=\"\",\"\",IF(AR22=\"\",HOUR(MOD(NOW()-AQ22,1)),HOUR(MOD(AR22-AQ22,1))))","v":""},null,{"$f":"IF(AN22=\"\",\"\",IF(AN22=\"Подготовлена\",\"Не определен\",IF(AJ22<>\"\",IF(OR(IF(AR22=\"\",NOW()>AJ22,AR22>$AJ22),IF(AND(AU22<>\"\",AM22<>\"\"),AU22>AM22)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI22=\"\",\"\",IF(AR22=\"\",(NOW()-AI22)-MOD(NOW()-AI22,1),(AR22-AI22)-MOD(AR22-AI22,1)))","v":""},{"$f":"IF(AI22=\"\",\"\",IF(AR22=\"\",HOUR(MOD(NOW()-AI22,1)),HOUR(MOD(AR22-AI22,1))))","v":""},{"$f":"IF(OR(AK22=\"\",AW22=\"\"),\"\",AK22-AW22)","v":""},{"$f":"IF(OR(AL22=\"\",AX22=\"\"),\"\",AL22-AX22)","v":""},{"$f":"IF(OR(AM22=\"\",AU22=\"\"),\"\",(AU22-AM22)*IF(AU22>=AM22,1,-1))","v":""},"Задача"]
[17,1,"ФИ3",null,"ФИ3",null,"Благосостояние","Транспорт",null,null,null,null,null,null,null,null,null,"День","День",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",DATE(YEAR(AI23),MONTH(AI23)+(SUMIF(Справочник!$J$5:$J$8,U23,Справочник!$K$5:$K$8)*V23),DAY(AI23)+(SUMIF(Справочник!$J$2:$J$4,U23,Справочник!$K$2:$K$4)*V23))+TIME(HOUR(AI23),MINUTE(AI23),SECOND(AI23)))","v":""},{"$f":"IF(OR(U23=\"\",W23=\"\"),\"\",DATE(YEAR(AE23),MONTH(AE23)+(SUMIF(Справочник!$J$5:$J$8,U23,Справочник!$K$5:$K$8)*V23*W23),DAY(AE23)+(SUMIF(Справочник!$J$2:$J$4,U23,Справочник!$K$2:$K$4)*V23*W23)))","v":""},null,"2016-07-01","2016-08-30",{"$f":"IF(OR(AI23=\"\",AJ23=\"\"),\"\",(AJ23-AI23)-MOD(AJ23-AI23,1))","v":60},{"$f":"IF(OR(AI23=\"\",AJ23=\"\"),\"\",HOUR(MOD(AJ23-AI23,1)))","v":0},null,"Завершена","Выполнена","2016-07-30","2016-07-26","2016-07-30",{"$f":"IF(AQ23=\"\",\"\",IF(AR23=\"\",(NOW()-AQ23)-MOD(NOW()-AQ23,1),(AR23-AQ23)-MOD(AR23-AQ23,1)))","v":4},{"$f":"IF(AQ23=\"\",\"\",IF(AR23=\"\",HOUR(MOD(NOW()-AQ23,1)),HOUR(MOD(AR23-AQ23,1))))","v":0},null,{"$f":"IF(AN23=\"\",\"\",IF(AN23=\"Подготовлена\",\"Не определен\",IF(AJ23<>\"\",IF(OR(IF(AR23=\"\",NOW()>AJ23,AR23>$AJ23),IF(AND(AU23<>\"\",AM23<>\"\"),AU23>AM23)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI23=\"\",\"\",IF(AR23=\"\",(NOW()-AI23)-MOD(NOW()-AI23,1),(AR23-AI23)-MOD(AR23-AI23,1)))","v":29},{"$f":"IF(AI23=\"\",\"\",IF(AR23=\"\",HOUR(MOD(NOW()-AI23,1)),HOUR(MOD(AR23-AI23,1))))","v":0},{"$f":"IF(OR(AK23=\"\",AW23=\"\"),\"\",AK23-AW23)","v":31},{"$f":"IF(OR(AL23=\"\",AX23=\"\"),\"\",AL23-AX23)","v":0},{"$f":"IF(OR(AM23=\"\",AU23=\"\"),\"\",(AU23-AM23)*IF(AU23>=AM23,1,-1))","v":""},"Проект","Средний","Положительная"]
[18,2,"ФИ3",null,"ФИ3",null,"Благосостояние",null,"ВА",null,null,null,null,null,null,null,null,{"$f":"IF(AND(AI24=\"\",AQ24=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AQ24=\"\",AI24,AQ24)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AQ24=\"\",AI24,AQ24)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":"День"},{"$f":"IF(AND(AJ24=\"\",AR24=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AR24=\"\",AJ24,AR24)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AR24=\"\",AJ24,AR24)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":"День"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",DATE(YEAR(AI24),MONTH(AI24)+(SUMIF(Справочник!$J$5:$J$8,U24,Справочник!$K$5:$K$8)*V24),DAY(AI24)+(SUMIF(Справочник!$J$2:$J$4,U24,Справочник!$K$2:$K$4)*V24))+TIME(HOUR(AI24),MINUTE(AI24),SECOND(AI24)))","v":""},{"$f":"IF(OR(U24=\"\",W24=\"\"),\"\",DATE(YEAR(AE24),MONTH(AE24)+(SUMIF(Справочник!$J$5:$J$8,U24,Справочник!$K$5:$K$8)*V24*W24),DAY(AE24)+(SUMIF(Справочник!$J$2:$J$4,U24,Справочник!$K$2:$K$4)*V24*W24)))","v":""},null,"2016-07-01","2016-08-30",{"$f":"IF(OR(AI24=\"\",AJ24=\"\"),\"\",(AJ24-AI24)-MOD(AJ24-AI24,1))","v":60},{"$f":"IF(OR(AI24=\"\",AJ24=\"\"),\"\",HOUR(MOD(AJ24-AI24,1)))","v":0},null,"Завершена","Выполнена","2016-07-30","2016-07-26","2016-07-30",{"$f":"IF(AQ24=\"\",\"\",IF(AR24=\"\",(NOW()-AQ24)-MOD(NOW()-AQ24,1),(AR24-AQ24)-MOD(AR24-AQ24,1)))","v":4},{"$f":"IF(AQ24=\"\",\"\",IF(AR24=\"\",HOUR(MOD(NOW()-AQ24,1)),HOUR(MOD(AR24-AQ24,1))))","v":0},null,{"$f":"IF(AN24=\"\",\"\",IF(AN24=\"Подготовлена\",\"Не определен\",IF(AJ24<>\"\",IF(OR(IF(AR24=\"\",NOW()>AJ24,AR24>$AJ24),IF(AND(AU24<>\"\",AM24<>\"\"),AU24>AM24)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI24=\"\",\"\",IF(AR24=\"\",(NOW()-AI24)-MOD(NOW()-AI24,1),(AR24-AI24)-MOD(AR24-AI24,1)))","v":29},{"$f":"IF(AI24=\"\",\"\",IF(AR24=\"\",HOUR(MOD(NOW()-AI24,1)),HOUR(MOD(AR24-AI24,1))))","v":0},{"$f":"IF(OR(AK24=\"\",AW24=\"\"),\"\",AK24-AW24)","v":31},{"$f":"IF(OR(AL24=\"\",AX24=\"\"),\"\",AL24-AX24)","v":0},{"$f":"IF(OR(AM24=\"\",AU24=\"\"),\"\",(AU24-AM24)*IF(AU24>=AM24,1,-1))","v":""},"Проект","Средний","Положительная"]
[19,1,"ФИ3",null,"ФИ3",null,"Семья","Образование детям",null,null,null,null,null,null,null,null,"ID/Кайрос/Повторение/Тип/Сложность","","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",DATE(YEAR(AI25),MONTH(AI25)+(SUMIF(Справочник!$J$5:$J$8,U25,Справочник!$K$5:$K$8)*V25),DAY(AI25)+(SUMIF(Справочник!$J$2:$J$4,U25,Справочник!$K$2:$K$4)*V25))+TIME(HOUR(AI25),MINUTE(AI25),SECOND(AI25)))","v":""},{"$f":"IF(OR(U25=\"\",W25=\"\"),\"\",DATE(YEAR(AE25),MONTH(AE25)+(SUMIF(Справочник!$J$5:$J$8,U25,Справочник!$K$5:$K$8)*V25*W25),DAY(AE25)+(SUMIF(Справочник!$J$2:$J$4,U25,Справочник!$K$2:$K$4)*V25*W25)))","v":""},null,null,null,{"$f":"IF(OR(AI25=\"\",AJ25=\"\"),\"\",(AJ25-AI25)-MOD(AJ25-AI25,1))","v":""},{"$f":"IF(OR(AI25=\"\",AJ25=\"\"),\"\",HOUR(MOD(AJ25-AI25,1)))","v":""},null,"Выполняется",null,null,null,null,{"$f":"IF(AQ25=\"\",\"\",IF(AR25=\"\",(NOW()-AQ25)-MOD(NOW()-AQ25,1),(AR25-AQ25)-MOD(AR25-AQ25,1)))","v":""},{"$f":"IF(AQ25=\"\",\"\",IF(AR25=\"\",HOUR(MOD(NOW()-AQ25,1)),HOUR(MOD(AR25-AQ25,1))))","v":""},null,{"$f":"IF(AN25=\"\",\"\",IF(AN25=\"Подготовлена\",\"Не определен\",IF(AJ25<>\"\",IF(OR(IF(AR25=\"\",NOW()>AJ25,AR25>$AJ25),IF(AND(AU25<>\"\",AM25<>\"\"),AU25>AM25)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI25=\"\",\"\",IF(AR25=\"\",(NOW()-AI25)-MOD(NOW()-AI25,1),(AR25-AI25)-MOD(AR25-AI25,1)))","v":""},{"$f":"IF(AI25=\"\",\"\",IF(AR25=\"\",HOUR(MOD(NOW()-AI25,1)),HOUR(MOD(AR25-AI25,1))))","v":""},{"$f":"IF(OR(AK25=\"\",AW25=\"\"),\"\",AK25-AW25)","v":""},{"$f":"IF(OR(AL25=\"\",AX25=\"\"),\"\",AL25-AX25)","v":""},{"$f":"IF(OR(AM25=\"\",AU25=\"\"),\"\",(AU25-AM25)*IF(AU25>=AM25,1,-1))","v":""},"Проект"]
[20,2,"ФИ3",null,"ФИ3",null,"Семья",null,"ГА",null,null,null,null,null,null,null,"ID/Кайрос/Повторение/Тип/Сложность",{"$f":"IF(AND(AI26=\"\",AQ26=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AQ26=\"\",AI26,AQ26)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AQ26=\"\",AI26,AQ26)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":""},{"$f":"IF(AND(AJ26=\"\",AR26=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AR26=\"\",AJ26,AR26)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AR26=\"\",AJ26,AR26)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",DATE(YEAR(AI26),MONTH(AI26)+(SUMIF(Справочник!$J$5:$J$8,U26,Справочник!$K$5:$K$8)*V26),DAY(AI26)+(SUMIF(Справочник!$J$2:$J$4,U26,Справочник!$K$2:$K$4)*V26))+TIME(HOUR(AI26),MINUTE(AI26),SECOND(AI26)))","v":""},{"$f":"IF(OR(U26=\"\",W26=\"\"),\"\",DATE(YEAR(AE26),MONTH(AE26)+(SUMIF(Справочник!$J$5:$J$8,U26,Справочник!$K$5:$K$8)*V26*W26),DAY(AE26)+(SUMIF(Справочник!$J$2:$J$4,U26,Справочник!$K$2:$K$4)*V26*W26)))","v":""},null,null,null,{"$f":"IF(OR(AI26=\"\",AJ26=\"\"),\"\",(AJ26-AI26)-MOD(AJ26-AI26,1))","v":""},{"$f":"IF(OR(AI26=\"\",AJ26=\"\"),\"\",HOUR(MOD(AJ26-AI26,1)))","v":""},null,"Выполняется",null,null,null,null,{"$f":"IF(AQ26=\"\",\"\",IF(AR26=\"\",(NOW()-AQ26)-MOD(NOW()-AQ26,1),(AR26-AQ26)-MOD(AR26-AQ26,1)))","v":""},{"$f":"IF(AQ26=\"\",\"\",IF(AR26=\"\",HOUR(MOD(NOW()-AQ26,1)),HOUR(MOD(AR26-AQ26,1))))","v":""},null,{"$f":"IF(AN26=\"\",\"\",IF(AN26=\"Подготовлена\",\"Не определен\",IF(AJ26<>\"\",IF(OR(IF(AR26=\"\",NOW()>AJ26,AR26>$AJ26),IF(AND(AU26<>\"\",AM26<>\"\"),AU26>AM26)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI26=\"\",\"\",IF(AR26=\"\",(NOW()-AI26)-MOD(NOW()-AI26,1),(AR26-AI26)-MOD(AR26-AI26,1)))","v":""},{"$f":"IF(AI26=\"\",\"\",IF(AR26=\"\",HOUR(MOD(NOW()-AI26,1)),HOUR(MOD(AR26-AI26,1))))","v":""},{"$f":"IF(OR(AK26=\"\",AW26=\"\"),\"\",AK26-AW26)","v":""},{"$f":"IF(OR(AL26=\"\",AX26=\"\"),\"\",AL26-AX26)","v":""},{"$f":"IF(OR(AM26=\"\",AU26=\"\"),\"\",(AU26-AM26)*IF(AU26>=AM26,1,-1))","v":""},"Проект"]
[21,1,"ФИ3",null,"ФИ3",null,"Семья","ТМ",null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U27=\"\",\"\",DATE(YEAR(AI27),MONTH(AI27)+(SUMIF(Справочник!$J$5:$J$8,U27,Справочник!$K$5:$K$8)*V27),DAY(AI27)+(SUMIF(Справочник!$J$2:$J$4,U27,Справочник!$K$2:$K$4)*V27))+TIME(HOUR(AI27),MINUTE(AI27),SECOND(AI27)))","v":""},{"$f":"IF(OR(U27=\"\",W27=\"\"),\"\",DATE(YEAR(AE27),MONTH(AE27)+(SUMIF(Справочник!$J$5:$J$8,U27,Справочник!$K$5:$K$8)*V27*W27),DAY(AE27)+(SUMIF(Справочник!$J$2:$J$4,U27,Справочник!$K$2:$K$4)*V27*W27)))","v":""},null,null,null,{"$f":"IF(OR(AI27=\"\",AJ27=\"\"),\"\",(AJ27-AI27)-MOD(AJ27-AI27,1))","v":""},{"$f":"IF(OR(AI27=\"\",AJ27=\"\"),\"\",HOUR(MOD(AJ27-AI27,1)))","v":""},null,"Ждет выполнения",null,null,null,null,{"$f":"IF(AQ27=\"\",\"\",IF(AR27=\"\",(NOW()-AQ27)-MOD(NOW()-AQ27,1),(AR27-AQ27)-MOD(AR27-AQ27,1)))","v":""},{"$f":"IF(AQ27=\"\",\"\",IF(AR27=\"\",HOUR(MOD(NOW()-AQ27,1)),HOUR(MOD(AR27-AQ27,1))))","v":""},null,{"$f":"IF(AN27=\"\",\"\",IF(AN27=\"Подготовлена\",\"Не определен\",IF(AJ27<>\"\",IF(OR(IF(AR27=\"\",NOW()>AJ27,AR27>$AJ27),IF(AND(AU27<>\"\",AM27<>\"\"),AU27>AM27)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI27=\"\",\"\",IF(AR27=\"\",(NOW()-AI27)-MOD(NOW()-AI27,1),(AR27-AI27)-MOD(AR27-AI27,1)))","v":""},{"$f":"IF(AI27=\"\",\"\",IF(AR27=\"\",HOUR(MOD(NOW()-AI27,1)),HOUR(MOD(AR27-AI27,1))))","v":""},{"$f":"IF(OR(AK27=\"\",AW27=\"\"),\"\",AK27-AW27)","v":""},{"$f":"IF(OR(AL27=\"\",AX27=\"\"),\"\",AL27-AX27)","v":""},{"$f":"IF(OR(AM27=\"\",AU27=\"\"),\"\",(AU27-AM27)*IF(AU27>=AM27,1,-1))","v":""},"Задача"]
[22,2,"ФИ3",null,"ФИ3",null,"Семья",null,"ДА",null,null,null,null,null,null,null,null,{"$f":"IF(AND(AI28=\"\",AQ28=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AQ28=\"\",AI28,AQ28)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AQ28=\"\",AI28,AQ28)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":""},{"$f":"IF(AND(AJ28=\"\",AR28=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AR28=\"\",AJ28,AR28)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AR28=\"\",AJ28,AR28)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U28=\"\",\"\",DATE(YEAR(AI28),MONTH(AI28)+(SUMIF(Справочник!$J$5:$J$8,U28,Справочник!$K$5:$K$8)*V28),DAY(AI28)+(SUMIF(Справочник!$J$2:$J$4,U28,Справочник!$K$2:$K$4)*V28))+TIME(HOUR(AI28),MINUTE(AI28),SECOND(AI28)))","v":""},{"$f":"IF(OR(U28=\"\",W28=\"\"),\"\",DATE(YEAR(AE28),MONTH(AE28)+(SUMIF(Справочник!$J$5:$J$8,U28,Справочник!$K$5:$K$8)*V28*W28),DAY(AE28)+(SUMIF(Справочник!$J$2:$J$4,U28,Справочник!$K$2:$K$4)*V28*W28)))","v":""},null,null,null,{"$f":"IF(OR(AI28=\"\",AJ28=\"\"),\"\",(AJ28-AI28)-MOD(AJ28-AI28,1))","v":""},{"$f":"IF(OR(AI28=\"\",AJ28=\"\"),\"\",HOUR(MOD(AJ28-AI28,1)))","v":""},null,"Ждет выполнения",null,null,null,null,{"$f":"IF(AQ28=\"\",\"\",IF(AR28=\"\",(NOW()-AQ28)-MOD(NOW()-AQ28,1),(AR28-AQ28)-MOD(AR28-AQ28,1)))","v":""},{"$f":"IF(AQ28=\"\",\"\",IF(AR28=\"\",HOUR(MOD(NOW()-AQ28,1)),HOUR(MOD(AR28-AQ28,1))))","v":""},null,{"$f":"IF(AN28=\"\",\"\",IF(AN28=\"Подготовлена\",\"Не определен\",IF(AJ28<>\"\",IF(OR(IF(AR28=\"\",NOW()>AJ28,AR28>$AJ28),IF(AND(AU28<>\"\",AM28<>\"\"),AU28>AM28)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI28=\"\",\"\",IF(AR28=\"\",(NOW()-AI28)-MOD(NOW()-AI28,1),(AR28-AI28)-MOD(AR28-AI28,1)))","v":""},{"$f":"IF(AI28=\"\",\"\",IF(AR28=\"\",HOUR(MOD(NOW()-AI28,1)),HOUR(MOD(AR28-AI28,1))))","v":""},{"$f":"IF(OR(AK28=\"\",AW28=\"\"),\"\",AK28-AW28)","v":""},{"$f":"IF(OR(AL28=\"\",AX28=\"\"),\"\",AL28-AX28)","v":""},{"$f":"IF(OR(AM28=\"\",AU28=\"\"),\"\",(AU28-AM28)*IF(AU28>=AM28,1,-1))","v":""},"Задача"]
[23,1,"ФИ3",null,"ФИ3",null,"Семья","Внимание семье",null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U29=\"\",\"\",DATE(YEAR(AI29),MONTH(AI29)+(SUMIF(Справочник!$J$5:$J$8,U29,Справочник!$K$5:$K$8)*V29),DAY(AI29)+(SUMIF(Справочник!$J$2:$J$4,U29,Справочник!$K$2:$K$4)*V29))+TIME(HOUR(AI29),MINUTE(AI29),SECOND(AI29)))","v":""},{"$f":"IF(OR(U29=\"\",W29=\"\"),\"\",DATE(YEAR(AE29),MONTH(AE29)+(SUMIF(Справочник!$J$5:$J$8,U29,Справочник!$K$5:$K$8)*V29*W29),DAY(AE29)+(SUMIF(Справочник!$J$2:$J$4,U29,Справочник!$K$2:$K$4)*V29*W29)))","v":""},null,null,null,"","",null,"Ждет выполнения",null,null,null,null,"","",null,"Не просрочена","","","","",""]
[24,1,"ФИ3",null,"ФИ3",null,"Развитие","Иностранные языки",null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U30=\"\",\"\",DATE(YEAR(AI30),MONTH(AI30)+(SUMIF(Справочник!$J$5:$J$8,U30,Справочник!$K$5:$K$8)*V30),DAY(AI30)+(SUMIF(Справочник!$J$2:$J$4,U30,Справочник!$K$2:$K$4)*V30))+TIME(HOUR(AI30),MINUTE(AI30),SECOND(AI30)))","v":""},{"$f":"IF(OR(U30=\"\",W30=\"\"),\"\",DATE(YEAR(AE30),MONTH(AE30)+(SUMIF(Справочник!$J$5:$J$8,U30,Справочник!$K$5:$K$8)*V30*W30),DAY(AE30)+(SUMIF(Справочник!$J$2:$J$4,U30,Справочник!$K$2:$K$4)*V30*W30)))","v":""},null,null,null,{"$f":"IF(OR(AI30=\"\",AJ30=\"\"),\"\",(AJ30-AI30)-MOD(AJ30-AI30,1))","v":""},{"$f":"IF(OR(AI30=\"\",AJ30=\"\"),\"\",HOUR(MOD(AJ30-AI30,1)))","v":""},null,"Ждет выполнения",null,null,null,null,{"$f":"IF(AQ30=\"\",\"\",IF(AR30=\"\",(NOW()-AQ30)-MOD(NOW()-AQ30,1),(AR30-AQ30)-MOD(AR30-AQ30,1)))","v":""},{"$f":"IF(AQ30=\"\",\"\",IF(AR30=\"\",HOUR(MOD(NOW()-AQ30,1)),HOUR(MOD(AR30-AQ30,1))))","v":""},null,{"$f":"IF(AN30=\"\",\"\",IF(AN30=\"Подготовлена\",\"Не определен\",IF(AJ30<>\"\",IF(OR(IF(AR30=\"\",NOW()>AJ30,AR30>$AJ30),IF(AND(AU30<>\"\",AM30<>\"\"),AU30>AM30)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI30=\"\",\"\",IF(AR30=\"\",(NOW()-AI30)-MOD(NOW()-AI30,1),(AR30-AI30)-MOD(AR30-AI30,1)))","v":""},{"$f":"IF(AI30=\"\",\"\",IF(AR30=\"\",HOUR(MOD(NOW()-AI30,1)),HOUR(MOD(AR30-AI30,1))))","v":""},{"$f":"IF(OR(AK30=\"\",AW30=\"\"),\"\",AK30-AW30)","v":""},{"$f":"IF(OR(AL30=\"\",AX30=\"\"),\"\",AL30-AX30)","v":""},{"$f":"IF(OR(AM30=\"\",AU30=\"\"),\"\",(AU30-AM30)*IF(AU30>=AM30,1,-1))","v":""},"Проект"]
[25,2,"ФИ3",null,"ФИ3",null,"Развитие",null,"ЗА",null,null,null,null,null,null,null,null,{"$f":"IF(AND(AI31=\"\",AQ31=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AQ31=\"\",AI31,AQ31)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AQ31=\"\",AI31,AQ31)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":""},{"$f":"IF(AND(AJ31=\"\",AR31=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AR31=\"\",AJ31,AR31)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AR31=\"\",AJ31,AR31)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U31=\"\",\"\",DATE(YEAR(AI31),MONTH(AI31)+(SUMIF(Справочник!$J$5:$J$8,U31,Справочник!$K$5:$K$8)*V31),DAY(AI31)+(SUMIF(Справочник!$J$2:$J$4,U31,Справочник!$K$2:$K$4)*V31))+TIME(HOUR(AI31),MINUTE(AI31),SECOND(AI31)))","v":""},{"$f":"IF(OR(U31=\"\",W31=\"\"),\"\",DATE(YEAR(AE31),MONTH(AE31)+(SUMIF(Справочник!$J$5:$J$8,U31,Справочник!$K$5:$K$8)*V31*W31),DAY(AE31)+(SUMIF(Справочник!$J$2:$J$4,U31,Справочник!$K$2:$K$4)*V31*W31)))","v":""},null,null,null,{"$f":"IF(OR(AI31=\"\",AJ31=\"\"),\"\",(AJ31-AI31)-MOD(AJ31-AI31,1))","v":""},{"$f":"IF(OR(AI31=\"\",AJ31=\"\"),\"\",HOUR(MOD(AJ31-AI31,1)))","v":""},null,"Ждет выполнения",null,null,null,null,{"$f":"IF(AQ31=\"\",\"\",IF(AR31=\"\",(NOW()-AQ31)-MOD(NOW()-AQ31,1),(AR31-AQ31)-MOD(AR31-AQ31,1)))","v":""},{"$f":"IF(AQ31=\"\",\"\",IF(AR31=\"\",HOUR(MOD(NOW()-AQ31,1)),HOUR(MOD(AR31-AQ31,1))))","v":""},null,{"$f":"IF(AN31=\"\",\"\",IF(AN31=\"Подготовлена\",\"Не определен\",IF(AJ31<>\"\",IF(OR(IF(AR31=\"\",NOW()>AJ31,AR31>$AJ31),IF(AND(AU31<>\"\",AM31<>\"\"),AU31>AM31)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI31=\"\",\"\",IF(AR31=\"\",(NOW()-AI31)-MOD(NOW()-AI31,1),(AR31-AI31)-MOD(AR31-AI31,1)))","v":""},{"$f":"IF(AI31=\"\",\"\",IF(AR31=\"\",HOUR(MOD(NOW()-AI31,1)),HOUR(MOD(AR31-AI31,1))))","v":""},{"$f":"IF(OR(AK31=\"\",AW31=\"\"),\"\",AK31-AW31)","v":""},{"$f":"IF(OR(AL31=\"\",AX31=\"\"),\"\",AL31-AX31)","v":""},{"$f":"IF(OR(AM31=\"\",AU31=\"\"),\"\",(AU31-AM31)*IF(AU31>=AM31,1,-1))","v":""},"Проект"]
[26,1,"ФИ3",null,"ФИ3",null,"Работа","Бизнес",null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U32=\"\",\"\",DATE(YEAR(AI32),MONTH(AI32)+(SUMIF(Справочник!$J$5:$J$8,U32,Справочник!$K$5:$K$8)*V32),DAY(AI32)+(SUMIF(Справочник!$J$2:$J$4,U32,Справочник!$K$2:$K$4)*V32))+TIME(HOUR(AI32),MINUTE(AI32),SECOND(AI32)))","v":""},{"$f":"IF(OR(U32=\"\",W32=\"\"),\"\",DATE(YEAR(AE32),MONTH(AE32)+(SUMIF(Справочник!$J$5:$J$8,U32,Справочник!$K$5:$K$8)*V32*W32),DAY(AE32)+(SUMIF(Справочник!$J$2:$J$4,U32,Справочник!$K$2:$K$4)*V32*W32)))","v":""},null,null,null,"","",null,"Выполняется",null,null,null,null,"","",null,"Не просрочена","","","","","","Проект"]
[27,2,"ФИ3",null,"ФИ3",null,"Работа",null,"ИА",null,null,null,null,null,null,null,null,{"$f":"IF(AND(AI33=\"\",AQ33=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AQ33=\"\",AI33,AQ33)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AQ33=\"\",AI33,AQ33)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":""},{"$f":"IF(AND(AJ33=\"\",AR33=\"\"),\"\",VLOOKUP(SUMIFS(ОбщееСрочностиЗадачиКоды,ОбщееСрочностиЗадачиНижниеГраницы,\"<=\"&IF(AR33=\"\",AJ33,AR33)-TODAY(),ОбщееСрочностиЗадачиВерхниеГраницы,\">=\"&IF(AR33=\"\",AJ33,AR33)-TODAY()),ОбщееСрочностиЗадачиТаблица,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U33=\"\",\"\",DATE(YEAR(AI33),MONTH(AI33)+(SUMIF(Справочник!$J$5:$J$8,U33,Справочник!$K$5:$K$8)*V33),DAY(AI33)+(SUMIF(Справочник!$J$2:$J$4,U33,Справочник!$K$2:$K$4)*V33))+TIME(HOUR(AI33),MINUTE(AI33),SECOND(AI33)))","v":""},{"$f":"IF(OR(U33=\"\",W33=\"\"),\"\",DATE(YEAR(AE33),MONTH(AE33)+(SUMIF(Справочник!$J$5:$J$8,U33,Справочник!$K$5:$K$8)*V33*W33),DAY(AE33)+(SUMIF(Справочник!$J$2:$J$4,U33,Справочник!$K$2:$K$4)*V33*W33)))","v":""},null,null,null,{"$f":"IF(OR(AI33=\"\",AJ33=\"\"),\"\",(AJ33-AI33)-MOD(AJ33-AI33,1))","v":""},{"$f":"IF(OR(AI33=\"\",AJ33=\"\"),\"\",HOUR(MOD(AJ33-AI33,1)))","v":""},null,"Выполняется",null,null,null,null,{"$f":"IF(AQ33=\"\",\"\",IF(AR33=\"\",(NOW()-AQ33)-MOD(NOW()-AQ33,1),(AR33-AQ33)-MOD(AR33-AQ33,1)))","v":""},{"$f":"IF(AQ33=\"\",\"\",IF(AR33=\"\",HOUR(MOD(NOW()-AQ33,1)),HOUR(MOD(AR33-AQ33,1))))","v":""},null,{"$f":"IF(AN33=\"\",\"\",IF(AN33=\"Подготовлена\",\"Не определен\",IF(AJ33<>\"\",IF(OR(IF(AR33=\"\",NOW()>AJ33,AR33>$AJ33),IF(AND(AU33<>\"\",AM33<>\"\"),AU33>AM33)),\"Просрочена\",\"Не просрочена\"),\"Не просрочена\")))","v":"Не просрочена"},{"$f":"IF(AI33=\"\",\"\",IF(AR33=\"\",(NOW()-AI33)-MOD(NOW()-AI33,1),(AR33-AI33)-MOD(AR33-AI33,1)))","v":""},{"$f":"IF(AI33=\"\",\"\",IF(AR33=\"\",HOUR(MOD(NOW()-AI33,1)),HOUR(MOD(AR33-AI33,1))))","v":""},{"$f":"IF(OR(AK33=\"\",AW33=\"\"),\"\",AK33-AW33)","v":""},{"$f":"IF(OR(AL33=\"\",AX33=\"\"),\"\",AL33-AX33)","v":""},{"$f":"IF(OR(AM33=\"\",AU33=\"\"),\"\",(AU33-AM33)*IF(AU33>=AM33,1,-1))","v":""},"Проект"]

{"sheet":"Справочник","index":2,"n_rows":21,"n_cols":43,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
["№","Роли","Категории","Дополнительные примеры категории","Порядок импорта задач Битрикс",null,"Типы задачи","Приоритет","Кайросы","Повторения","Периоды в днях","Коды срочности задачи","Срочность задачи","Срочность нижняя граница","Срочность верхняя граница","Типы срочности","Статусы задачи","Статусы задачи основные","Статусы задачи подчиненные","Статусы задачи подчиненные","Статусы срока задачи","Оценки","Статусы срока задачи","Статусы заметки","Уровни сложности задачи","Оценки","Оценка качественных показателей","Оценка качественных показателей баллы","Категории норм","Категории Бонусы","Статус","Типы Бонусы","Значения типов Бонусы","Типы операции","Измерения показателя","Принадлежности показателя","Характеры показателя","Типы данных","Источники","Типы измерителей","Виды измерителей","Виды измерителей сокращенно","Новый список …"]
[{"$f":"ROW()-1","v":1},"Р1","Здоровье","Личная жизнь","Размещение задач","Снизу","Проект","Высокий","Работа","Нет",0,1,"День",-99999,0,"По сроку начала","Подготовлена","Подготовлена",null,"Выполнена","Не просрочена","Положительная","Не просрочена","Новая","Высокий","Положительная","Неприемлемо",20,"Внимательность","Финансы","Действует","Покупка",-1,"Начисление","Количественный","Индивидуальный","Позитивный","Нормы","Задачи","Количественный","Баллы","бал."]
[{"$f":"ROW()-1","v":2},"Р2","Развитие","Процессы","Не загружать со статусом","Завершена","Задача","Средний","Машина","День",1,2,"Неделя",1,7,"По сроку завершения","Ждет выполнения","Ждет выполнения",null,"Выполнена","Не просрочена","Отрицательная","Просрочена","Ждет обработки","Средний","Отрицательная","Слабо",40,"Организованность","Мероприятия","Отложено","Продажа",-1,"Списание","Качественный","Коллективный","Негативный","Показатели","Значения","Количественный","Штука","шт."]
[3,"Р3","Семья","Хобби","Не загружать со статусом","Подготовлена",null,"Низкий","Дом","Неделя",7,3,"Месяц",8,30,null,"Выполняется","Выполняется","Принята","Выполнена","Просрочена","Положительная",null,"Завершена","Низкий","Нет оценки","Посредственно",60,"Вольность","Видеоигры","Не действует","Подарок",0,null,null,null,null,null,"Нет","Количественный","Разы","раз"]
[4,null,"Окружение","Собственность","Не загружать задачи с оценкой",null,null,null,"Фитнес","Месяц",1,4,"Год",31,99999,null,"Ждет проверки","Выполняется","На доработке","Выполнена","Просрочена","Отрицательная",null,null,null,null,"Хорошо",80,"Самостоятельность","Покупки",null,"Получение",0,null,null,null,null,null,null,"Количественный","Человек","чел."]
[5,null,"Работа","Капитал",null,null,null,null,"Улица","Квартал",3,null,null,null,null,null,"Отложена","Ждет проверки",null,"Не выполнена","Просрочено","Отрицательная",null,null,null,null,"Отлично",100,"Дисциплина",null,null,null,null,null,null,null,null,null,null,"Количественный","Килограммы","кг."]
[6,null,"Творчество","Активы",null,null,null,null,null,"Полугодие",6,null,null,null,null,null,"Завершена","Отложена",null," =СЧЁТЕСЛИМН(J2:J6;\"=\"&J2; K2:K6;\"=\"&K2;L2:L6;\"=\"&L2)",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,"Год",12,null,null,null,null,null,null,"Завершена","Выполнена",null,null,null,null,null,null,null,null,null,"Инициативность",null,null,null,null,null,null,null,null,null,null,"Относительный","Проценты","%"]
[8,null,"Финансы","IT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Завершена","Не выполнена",null,null,null,null,null,null,null,null,null,"Самоконтроль",null,null,null,null,null,null,null,null,null,null,"Относительный","Коэффициент","коэф."]
[9,null,"Благосостояние","Люди",null,null,null,null,null,null,null,null,null,null,null,null,null,"Завершена","Отклонена",null,null,null,null,null,null,null,null,null,"Сила воли",null,null,null,null,null,null,null,null,null,null,"Временный","Годы","г./лет"]
[10,null,"Хозяйство","Покупки",null,null,null,null,null,null,null,null,null,null,null,null,null,"Завершена","Отменена",null,null,null,null,null,null,null,null,null,"Привычка",null,null,null,null,null,null,null,null,null,null,"Временный","Месяцы","мес."]
[11,null,null,"Общение",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Временный","Недели","нед."]
[12,null,null,"Благосостояние",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Временный","Дни","дн."]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Временный","Часы","час."]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Временный","Минуты","мин."]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Временный","Секунды","сек."]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Денежный","Рубли","руб."]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Денежный","Доллары США","USD"]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Денежный","Евро","EUR"]
[19]
[20]