{"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":146,"n_cols":8,"rows_kept":146,"cut":false,"hidden":false,"merged":[[142,7,142,9],[141,0,141,1],[138,7,138,9],[139,7,139,9],[140,7,140,9],[141,7,141,9],[137,7,137,9],[138,0,138,1],[137,0,137,1],[139,0,139,1],[140,0,140,1],[145,0,150,9],[142,0,142,1],[131,0,131,1],[132,0,132,1],[133,0,133,1],[134,0,134,1],[135,0,135,1],[136,0,136,1],[143,7,143,9],[143,0,143,1],[131,7,131,9],[132,7,132,9],[133,7,133,9],[134,7,134,9],[135,7,135,9],[136,7,136,9],[130,0,130,1],[0,0,0,8],[1,0,1,9],[41,0,41,9],[73,0,73,9],[100,0,100,9],[127,0,127,9],[129,0,129,1],[129,7,129,9],[130,7,130,9]]}
["プロジェクト ポートフォリオ ダッシュボード"]
["デリバリー タイムライン & リソース"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["プロジェクトの財政状況"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["リスク分析"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["オープン & 保留中のアクション"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["プロジェクト レポート"]
[]
["プロジェクト名",null,"スケジュール","予算","リソース","リスク","問題","コメント"]
["プロジェクト A"]
["プロジェクト B"]
["プロジェクト C"]
["プロジェクト D"]
["プロジェクト E"]
["プロジェクト F"]
["プロジェクト G"]
["プロジェクト H"]
["プロジェクト J"]
["プロジェクト K"]
["プロジェクト L"]
["プロジェクト M"]
["プロジェクト N"]
["プロジェクト P"]
[]
["Smartsheet のダッシュボード機能「Sight」の詳細はこちら"]

{"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,"予測","実績","残高","高","中","低","問題","リビジョン"]
["プロジェクト A","2016-05-01","2016-05-05","2016-07-01",{"$f":"D4-C4","v":57},10,100000000,88000000,{"$f":"(G4-H4)","v":12000000},1,0,4,2,0,4]
["プロジェクト B","2016-06-01","2016-05-10","2016-08-10",{"$f":"D5-C5","v":92},5,90000000,92000000,{"$f":"(G5-H5)","v":-2000000},2,3,5,1,2,3]
["プロジェクト C","2016-07-01","2016-06-10","2017-03-01",264,10,86000000,85000000,1000000,3,4,3,2,1,2]
["プロジェクト D","2016-08-01","2016-06-22","2016-08-04",43,5,100000000,99805000,195000,5,8,1,1,0,0]
["プロジェクト E","2016-09-01","2016-07-14","2016-11-01",110,10,29400000,28000000,1400000,8,6,4,0,3,1]
["プロジェクト F","2016-10-01","2016-07-14","2017-01-20",190,5,12340000,12500000,-160000,5,0,0,2,0,2]
["プロジェクト G","2016-11-01","2016-08-01","2016-10-01",61,10,25050000,24600000,450000,6,4,0,1,2,3]
["プロジェクト H","2016-12-01","2016-08-14","2016-08-30",16,5,12720000,12600000,120000,7,3,3,0,1,4]
["プロジェクト J","2017-01-01","2016-09-01","2016-12-10",100,10,8000000,7990000,10000,0,2,4,1,3,2]
["プロジェクト K","2017-02-01","2016-10-01","2016-11-15",45,5,7700000,7700000,0,4,4,5,2,0,0]
["プロジェクト L","2017-03-01","2016-10-01","2016-12-01",61,10,6500000,6500000,0,3,6,4,3,2,0]
["プロジェクト M","2017-04-01","2016-11-01","2016-12-01",30,5,55000000,55100000,-100000,2,3,6,0,1,1]
["プロジェクト N","2017-05-01","2016-11-10","2016-12-10",30,10,4500000,4200000,300000,1,1,7,1,0,2]
["プロジェクト P","2017-06-01","2016-12-01","2017-02-10",71,5,3250000,3300000,-50000,5,0,2,2,1,3]
[null,null,null,null,null,null,{"$f":"SUM(G4:G17)","v":540460000},527295000,{"$f":"SUM(I4:I17)","v":13165000},52,44,48,18,16,27]