{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Мониторинг управления проектом","Проектные данные"],"not_rendered":{"charts":8,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Мониторинг управления проектом","index":0,"n_rows":171,"n_cols":10,"rows_kept":171,"cut":false,"hidden":false,"merged":[[159,0,159,2],[164,0,164,2],[165,0,165,2],[166,0,166,2],[167,0,167,2],[0,0,0,8],[1,0,1,13],[46,0,46,13],[72,0,72,13],[152,0,152,13],[112,0,112,13],[154,0,154,2],[155,0,155,2],[156,0,156,2],[157,0,157,2],[158,0,158,2],[154,9,154,13],[170,0,174,13],[160,0,160,2],[161,0,161,2],[162,0,162,2],[163,0,163,2],[168,0,168,2],[160,9,160,13],[161,9,161,13],[162,9,162,13],[163,9,163,13],[164,9,164,13],[165,9,165,13],[166,9,166,13],[167,9,167,13],[168,9,168,13],[155,9,155,13],[156,9,156,13],[157,9,157,13],[158,9,158,13],[159,9,159,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,"Анна"]
[]
["Узнайте больше о панелях мониторинга Smartsheet"]

{"sheet":"Проектные данные","index":1,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,7,1,9],[9,7,10,9],[19,0,19,6],[20,1,20,3],[20,6,21,6],[20,0,21,0],[1,0,1,5],[20,4,21,4],[20,5,21,5]]}
["ДАННЫЕ ДЛЯ УПРАВЛЕНИЯ ПРОЕКТОМ"]
["ТАБЛИЦА ЗАДАЧ И РАСПИСАНИЙ",null,null,null,null,null,null,"ОТСЛЕЖИВАНИЕ СТАТУСА ЗАДАЧ"]
["ЗАДАЧА","ИСПОЛНИТЕЛЬ","НАЧАЛО","ОКОНЧАНИЕ","№ ДНЕЙ","СТАТУС",null,"СТАТУС","КОЛИЧЕСТВО","%"]
["Начало","Анна","2016-05-05","2016-05-06",{"$f":"D4-C4","v":1},"ЗАВЕРШЕНО",null,"ЗАВЕРШЕНО",4,{"$f":"I4/SUM(I4:I7)","v":0.2857142857142857}]
["Определение целей","Кирилл","2016-05-07","2016-05-12",{"$f":"D5-C5","v":5},"ЗАВЕРШЕНО",null,"ПРОСРОЧЕНО",2,{"$f":"I5/SUM(I4:I7)","v":0.14285714285714285}]
["Требования к проекту","Светлана","2016-05-13","2016-05-20",7,"ЗАВЕРШЕНО",null,"ВЫПОЛНЯЕТСЯ",2,{"$f":"I6/SUM(I4:I7)","v":0.14285714285714285}]
["Требования к оборудованию","Иван","2016-05-17","2016-05-22",5,"ЗАВЕРШЕНО",null,"НЕ НАЧАТО",6,{"$f":"I7/SUM(I4:I7)","v":0.42857142857142855}]
["Окончательное утверждение плана ресурсов","Анна","2016-05-23","2016-05-27",4,"ПРОСРОЧЕНО"]
["Презентация инвесторам","Кирилл","2016-06-04","2016-06-05",1,"ПРОСРОЧЕНО"]
["Набор персонала","Светлана","2016-06-01","2016-06-05",4,"ВЫПОЛНЯЕТСЯ",null,"БЮДЖЕТ"]
["Строительство","Иван","2016-06-06","2016-06-27",21,"ВЫПОЛНЯЕТСЯ"]
["Выход альфа-версии","Пётр","2016-06-28","2016-06-29",1,"НЕ НАЧАТО",null,"ЗАПЛАНИРОВАННЫЙ","ДЕЙСТВИТЕЛЬНЫЙ","ОСТАТОК"]
["Тестирование альфа-версии","Николай","2016-06-29","2016-07-15",16,"НЕ НАЧАТО",null,1000000,880000,{"$f":"(H13-I13)","v":120000}]
["Выход бета-версии","Пётр","2016-07-16","2016-07-17",1,"НЕ НАЧАТО"]
["Тестирование бета-версии","Николай","2016-07-17","2016-07-30",13,"НЕ НАЧАТО"]
["Запуск","Пётр","2016-08-01","2016-08-02",1,"НЕ НАЧАТО"]
["Дальнейшее планирование","Анна","2016-08-02","2016-08-04",2,"НЕ НАЧАТО"]
[]
[]
["РИСКИ И НЕВЫПОЛНЕННЫЕ ДЕЙСТВИЯ"]
["ЗАДАЧА","РИСКИ",null,null,"ОТКРЫТЫЕ ПРОБЛЕМЫ","ОТКРЫТЫЕ ИСПРАВЛЕНИЯ","НЕВЫПОЛНЕННЫЕ ДЕЙСТВИЯ"]
[null,"ВЫСОКИЙ","СРЕДНИЙ","НИЗКИЙ"]
["Начало",1,0,4,2,0,4]
["Определение целей",2,3,5,1,2,3]
["Требования проекта",3,4,3,2,1,2]
["Требования к оборудованию",5,8,1,1,0,0]
["Окончательное утверждение плана ресурсов",8,6,4,0,3,1]
["Презентация инвесторам",5,0,0,2,0,2]
["Набор персонала",6,4,0,1,2,3]
["Строительство",7,3,3,0,1,4]
["Выход альфа-версии",0,2,4,1,3,2]
["Тестирование альфа-версии",4,4,5,2,0,0]
["Выход бета-версии",3,6,4,3,2,0]
["Тестирование бета-версии",2,3,6,0,1,1]
["Запуск",1,1,7,1,0,2]
["Дальнейшее планирование",5,0,2,2,1,3]
[null,{"$f":"SUM(B23:B36)","v":52},44,48,18,16,27]