{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Список дел","Параметры и вычисления"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Список дел","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,6]]}
[{"$nulls":7}," "]
[null,"Список дел для проекта"]
[]
[null,"Исполнитель:",null,null,"Крайний срок:",null,"Выделенные действия"]
[null,"Марта Артемьева",null,null,{"$f":"TODAY()+95","v":"2024-07-16"},null,"Нет выделенных действий"]
[null,"Проект 1"]
[null,"Действие","Срок выполнения","Бюджет","Готово","Ход выполнения","Заметки"," "]
[null,"Планирование",{"$f":"TODAY()-90","v":"2024-01-13"},{"v":476,"d":"476.00 ₽"},null,{"v":0.25,"d":"25%"}]
[null,"Подготовка",{"$f":"TODAY()-2","v":"2024-04-10"},{"v":301,"d":"301.00 ₽"},null,{"v":0.1,"d":"10%"}]
[null,"Задача А",{"$f":"TODAY()-7","v":"2024-04-05"},{"v":429,"d":"429.00 ₽"},null,{"v":0,"d":"0%"}]
[null,"Задача Б",{"$f":"TODAY()+20","v":"2024-05-02"},{"v":332,"d":"332.00 ₽"},null,{"v":0.7,"d":"70%"}]
[null,"Задача В",{"$f":"TODAY()+40","v":"2024-05-22"},{"v":471,"d":"471.00 ₽"},null,{"v":0.1,"d":"10%"}]
[null,"Задача Г",{"$f":"TODAY()+45","v":"2024-05-27"},{"v":418,"d":"418.00 ₽"},"ДА",{"v":1,"d":"100%"}]
[null,"Оформление документов",{"$f":"TODAY()+55","v":"2024-06-06"},{"v":150,"d":"150.00 ₽"},null,{"v":0,"d":"0%"},"Начать после завершения задачи Б"]
[null,"Передача проекта",{"$f":"TODAY()+70","v":"2024-06-21"},{"v":330,"d":"330.00 ₽"},null,{"v":0.25,"d":"25%"}]
[null,"Завершение",{"$f":"TODAY()+90","v":"2024-07-11"},{"v":353,"d":"353.00 ₽"},null,{"v":0.5,"d":"50%"}]

{"sheet":"Параметры и вычисления","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[1,1,1,4],[3,1,3,4]]}
[{"$nulls":5}," "]
[null,"Параметры выделения"]
[]
[null,"Таблицы, приведенные ниже, содержат параметры и расчеты для раскрывающегося списка выделенных действий.\nИзменения могут привести к ошибкам или потере функциональности."]
[null,"Нет выделенных действий",null,null,{"$f":"B5","v":"Нет выделенных действий"}]
[null,"Интервал:","Начало:","Конец:","Срок выполнения:"]
[null,"Эта неделя",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2024-04-08"},{"$f":"C7+6","v":"2024-04-14"},{"$f":"B7&\" [\"&TEXT(C7,\"Д МММ\")&\" - \"&TEXT(D7,\"Д МММ\")&\"]\"","v":"Эта неделя [8 апр - 14 апр]"}]
[null,"Этот месяц",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2024-04-01"},{"$f":"EDATE(C8,1)-1","v":"2024-04-30"},{"$f":"B8&\" [\"&TEXT(C8,\"Д\")&\" - \"&TEXT(D8,\"Д, МММ\")&\"]\"","v":"Этот месяц [1 - 30, апр]"}]
[null,"Этот квартал",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2024-02-01"},{"$f":"EDATE(C9,4)-1","v":"2024-05-31"},{"$f":"B9&\" [\"&TEXT(C9,\"Д МММ\")&\" - \"&TEXT(D9,\"Д МММ\")&\"]\"","v":"Этот квартал [1 фев - 31 май]"}]
[null,"Этот год",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2024-01-01"},{"$f":"EDATE(C10,12)-1","v":"2024-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"ГГГГ\")&\"]\"","v":"Этот год [2024]"}]
[null,"Интервал:",null,null,{"$f":"B11","v":"Интервал:"}]
[null,"Прошлая неделя",{"$f":"C7-7","v":"2024-04-01"},{"$f":"C12+6","v":"2024-04-07"},{"$f":"B12&\" [\"&TEXT(C12,\"Д МММ\")&\" - \"&TEXT(D12,\"Д МММ\")&\"]\"","v":"Прошлая неделя [1 апр - 7 апр]"}]
[null,"Прошлый месяц",{"$f":"EDATE(C8,-1)","v":"2024-03-01"},{"$f":"EDATE(C13,1)-1","v":"2024-03-31"},{"$f":"B13&\" [\"&TEXT(C13,\"Д\")&\" - \"&TEXT(D13,\"Д, МММ\")&\"]\"","v":"Прошлый месяц [1 - 31, мар]"}]
[null,"Прошлый квартал",{"$f":"EDATE(C9,-3)","v":"2023-11-01"},{"$f":"EDATE(C14,3)-1","v":"2024-01-31"},{"$f":"B14&\" [\"&TEXT(C14,\"Д МММ\")&\" - \"&TEXT(D14,\"Д МММ\")&\"]\"","v":"Прошлый квартал [1 ноя - 31 янв]"}]
[null,"Прошлый год",{"$f":"EDATE(C10,-12)","v":"2023-01-01"},{"$f":"EDATE(C15,12)-1","v":"2023-12-31"},{"$f":"B15","v":"Прошлый год"}]
[null,"Выделения:",{"$f":"IFERROR(MATCH(HighlightActivities,lstToDoHighlights,0),\"\")","v":1},{"$f":"HighlightActivities","v":"Нет выделенных действий"},{"$f":"ISNUMBER(INDEX($C$5:$C$15,C16))","v":false}]
[null,"Выделенное начало",{"$f":"IFERROR(IF(C16=1,\"\",IF(E16,INDEX($C$5:$C$15,$C$16),\"\")),\"\")","v":""}]
[null,"Выделенный конец",{"$f":"IFERROR(IF(C16=1,\"\",IF(E16,INDEX($D$5:$D$15,$C$16),\"\")),\"\")","v":""}]