{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Project Portfolio Dashboard","Portfolio Data"],"not_rendered":{"charts":8,"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Project Portfolio Dashboard","index":0,"n_rows":146,"n_cols":8,"rows_kept":146,"merged":[[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,0,130,1],[130,7,130,9],[131,0,131,1],[131,7,131,9],[132,0,132,1],[132,7,132,9],[133,0,133,1],[133,7,133,9],[134,0,134,1],[134,7,134,9],[135,0,135,1],[135,7,135,9],[136,0,136,1],[136,7,136,9],[137,0,137,1],[137,7,137,9],[138,0,138,1],[138,7,138,9],[139,0,139,1],[139,7,139,9],[140,0,140,1],[140,7,140,9],[141,0,141,1],[141,7,141,9],[142,0,142,1],[142,7,142,9],[143,0,143,1],[143,7,143,9],[145,0,150,9]]}
["PROJECT PORTFOLIO DASHBOARD"]
["DELIVERY TIMELINE & RESOURCES"]
{"$rows_empty":39}
["PROJECT FINANCIALS"]
{"$rows_empty":31}
["RISK ANALYSIS"]
{"$rows_empty":26}
["OPEN & PENDING ACTIONS"]
{"$rows_empty":26}
["PROJECT REPORT"]
[]
["PROJECT NAME",null,"SCHEDULE","BUDGET","RESOURCES","RISKS","ISSUES","COMMENTS"]
["Project A"]
["Project B"]
["Project C"]
["Project D"]
["Project E"]
["Project F"]
["Project G"]
["Project H"]
["Project J"]
["Project K"]
["Project L"]
["Project M"]
["Project N"]
["Project P"]
[]
["Learn More About Dashboards in Smartsheet"]

{"sheet":"Portfolio Data","index":1,"n_rows":18,"n_cols":15,"rows_kept":18,"merged":[[0,0,0,9],[1,0,2,0],[1,1,1,4],[1,5,2,5],[1,6,1,8],[1,9,1,11],[1,12,1,13],[1,14,2,14]]}
["PROJECT PORTFOLIO DATA"]
["PROJECT NAME","TIMELINE",{"$nulls":3},"NUMBER OF TEAM MEMBERS","BUDGET",null,null,"RISKS",null,null,"OPEN",null,"PENDING ACTIONS"]
[null,"CALENDAR","BEGIN","FINISH","# of DAYS",null,"PROJECTED","ACTUAL","REMAINDER","HIGH","MEDIUM","LOW","ISSUES","REVISIONS"]
["Project A","2016-05-01","2016-05-05","2016-07-01",{"$f":"D4-C4","v":57},10,{"v":1000000,"d":"$1,000,000"},{"v":880000,"d":"$880,000"},{"$f":"(G4-H4)","v":{"v":120000,"d":"$120,000"}},1,0,4,2,0,4]
["Project B","2016-06-01","2016-05-10","2016-08-10",{"$f":"D5-C5","v":92},5,{"v":900000,"d":"$900,000"},{"v":920000,"d":"$920,000"},{"$f":"(G5-H5)","v":{"v":-20000,"d":"-$20,000"}},2,3,5,1,2,3]
["Project C","2016-07-01","2016-06-10","2017-03-01",264,10,{"v":860000,"d":"$860,000"},{"v":850000,"d":"$850,000"},{"v":10000,"d":"$10,000"},3,4,3,2,1,2]
["Project D","2016-08-01","2016-06-22","2016-08-04",43,5,{"v":1000000,"d":"$1,000,000"},{"v":998050,"d":"$998,050"},{"v":1950,"d":"$1,950"},5,8,1,1,0,0]
["Project E","2016-09-01","2016-07-14","2016-11-01",110,10,{"v":294000,"d":"$294,000"},{"v":280000,"d":"$280,000"},{"v":14000,"d":"$14,000"},8,6,4,0,3,1]
["Project F","2016-10-01","2016-07-14","2017-01-20",190,5,{"v":123400,"d":"$123,400"},{"v":125000,"d":"$125,000"},{"v":-1600,"d":"-$1,600"},5,0,0,2,0,2]
["Project G","2016-11-01","2016-08-01","2016-10-01",61,10,{"v":250500,"d":"$250,500"},{"v":246000,"d":"$246,000"},{"v":4500,"d":"$4,500"},6,4,0,1,2,3]
["Project H","2016-12-01","2016-08-14","2016-08-30",16,5,{"v":127200,"d":"$127,200"},{"v":126000,"d":"$126,000"},{"v":1200,"d":"$1,200"},7,3,3,0,1,4]
["Project J","2017-01-01","2016-09-01","2016-12-10",100,10,{"v":80000,"d":"$80,000"},{"v":79900,"d":"$79,900"},{"v":100,"d":"$100"},0,2,4,1,3,2]
["Project K","2017-02-01","2016-10-01","2016-11-15",45,5,{"v":77000,"d":"$77,000"},{"v":77000,"d":"$77,000"},{"v":0,"d":"$0"},4,4,5,2,0,0]
["Project L","2017-03-01","2016-10-01","2016-12-01",61,10,{"v":65000,"d":"$65,000"},{"v":65000,"d":"$65,000"},{"v":0,"d":"$0"},3,6,4,3,2,0]
["Project M","2017-04-01","2016-11-01","2016-12-01",30,5,{"v":550000,"d":"$550,000"},{"v":551000,"d":"$551,000"},{"v":-1000,"d":"-$1,000"},2,3,6,0,1,1]
["Project N","2017-05-01","2016-11-10","2016-12-10",30,10,{"v":45000,"d":"$45,000"},{"v":42000,"d":"$42,000"},{"v":3000,"d":"$3,000"},1,1,7,1,0,2]
["Project P","2017-06-01","2016-12-01","2017-02-10",71,5,{"v":32500,"d":"$32,500"},{"v":33000,"d":"$33,000"},{"v":-500,"d":"-$500"},5,0,2,2,1,3]
[{"$nulls":6},{"$f":"SUM(G4:G17)","v":{"v":5404600,"d":"$5,404,600"}},{"v":5272950,"d":"$5,272,950"},{"$f":"SUM(I4:I17)","v":{"v":131650,"d":"$131,650"}},52,44,48,18,16,27]