{"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":139,"n_cols":8,"rows_kept":139,"cut":false,"hidden":false,"merged":[[135,7,135,9],[134,0,134,1],[131,7,131,9],[132,7,132,9],[133,7,133,9],[134,7,134,9],[130,7,130,9],[131,0,131,1],[130,0,130,1],[132,0,132,1],[133,0,133,1],[138,0,143,9],[135,0,135,1],[124,0,124,1],[125,0,125,1],[126,0,126,1],[127,0,127,1],[128,0,128,1],[129,0,129,1],[136,7,136,9],[136,0,136,1],[124,7,124,9],[125,7,125,9],[126,7,126,9],[127,7,127,9],[128,7,128,9],[129,7,129,9],[123,0,123,1],[0,0,0,8],[1,0,1,9],[41,0,41,9],[66,0,66,9],[93,0,93,9],[120,0,120,9],[122,0,122,1],[122,7,122,9],[123,7,123,9]]}
["ПАНЕЛЬ МОНИТОРИНГА ПОРТФЕЛЯ ПРОЕКТОВ"]
["РАСПИСАНИЕ ВЫПОЛЕНИЯ И РЕСУРСЫ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["БЮДЖЕТ ПРОЕКТА"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["АНАЛИЗ РИСКОВ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ОТКРЫТЫЕ И НЕВЫПОЛНЕННЫЕ ДЕЙСТВИЯ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ОТЧЁТ ПО ПРОЕКТУ"]
[]
["НАЗВАНИЕ ПРОЕКТА",null,"РАСПИСАНИЕ","БЮДЖЕТ","РЕСУРСЫ","РИСКИ","ПРОБЛЕМЫ","КОММЕНТАРИИ"]
["Проект 1"]
["Проект 2"]
["Проект 3"]
["Проект 4"]
["Проект 5"]
["Проект 6"]
["Проект 7"]
["Проект 8"]
["Проект 9"]
["Проект 10"]
["Проект 11"]
["Проект 12"]
["Проект 13"]
["Проект 14"]
[]
["Узнайте больше о панелях управления Smartsheet"]

{"sheet":"Данные портфеля","index":1,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,14,2,14],[0,0,0,9],[1,6,1,8],[1,0,2,0],[1,1,1,4],[1,5,2,5],[1,9,1,11]]}
["ДАННЫЕ ПОРТФЕЛЯ ПРОЕКТОВ"]
["НАЗВАНИЕ ПРОЕКТА","РАСПИСАНИЕ",null,null,null,"КОЛИЧЕСТВО ЧЛЕНОВ КОМАНДЫ","БЮДЖЕТ",null,null,"РИСКИ",null,null,"ОТКРЫТЫЕ ЗАДАЧИ",null,"НЕВЫПОЛНЕННЫЕ ДЕЙСТВИЯ"]
[null,"КАЛЕНДАРНЫЙ ГОД","НАЧАЛО","ОКОНЧАНИЕ","№ ДНЕЙ",null,"ЗАПЛАНИРОВАННЫЙ","ДЕЙСТВИТЕЛЬНЫЙ","ОСТАТОК","ВЫСОКИЙ","СРЕДНИЙ","НИЗКИЙ","ПРОБЛЕМЫ","ИСПРАВЛЕНИЯ"]
["Проект 1","2016-05-01","2016-05-05","2016-07-01",{"$f":"D4-C4","v":57},10,1000000,880000,{"$f":"(G4-H4)","v":120000},1,0,4,2,0,4]
["Проект 2","2016-06-01","2016-05-10","2016-08-10",{"$f":"D5-C5","v":92},5,900000,920000,{"$f":"(G5-H5)","v":-20000},2,3,5,1,2,3]
["Проект 3","2016-07-01","2016-06-10","2017-03-01",264,10,860000,850000,10000,3,4,3,2,1,2]
["Проект 4","2016-08-01","2016-06-22","2016-08-04",43,5,1000000,998050,1950,5,8,1,1,0,0]
["Проект 5","2016-09-01","2016-07-14","2016-11-01",110,10,294000,280000,14000,8,6,4,0,3,1]
["Проект 6","2016-10-01","2016-07-14","2017-01-20",190,5,123400,125000,-1600,5,0,0,2,0,2]
["Проект 7","2016-11-01","2016-08-01","2016-10-01",61,10,250500,246000,4500,6,4,0,1,2,3]
["Проект 8","2016-12-01","2016-08-14","2016-08-30",16,5,127200,126000,1200,7,3,3,0,1,4]
["Проект 9","2017-01-01","2016-09-01","2016-12-10",100,10,80000,79900,100,0,2,4,1,3,2]
["Проект 10","2017-02-01","2016-10-01","2016-11-15",45,5,77000,77000,0,4,4,5,2,0,0]
["Проект 11","2017-03-01","2016-10-01","2016-12-01",61,10,65000,65000,0,3,6,4,3,2,0]
["Проект 12","2017-04-01","2016-11-01","2016-12-01",30,5,550000,551000,-1000,2,3,6,0,1,1]
["Проект 13","2017-05-01","2016-11-10","2016-12-10",30,10,45000,42000,3000,1,1,7,1,0,2]
["Проект 14","2017-06-01","2016-12-01","2017-02-10",71,5,32500,33000,-500,5,0,2,2,1,3]
[null,null,null,null,null,null,{"$f":"SUM(G4:G17)","v":5404600},5272950,{"$f":"SUM(I4:I17)","v":131650},52,44,48,18,16,27]