{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Summary","Stats","Entries"],"not_rendered":{"charts":6,"images":1,"macros":0,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":6},"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":"Summary","index":0,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,3,2,8],[2,10,2,14]]}
[]
[]
[null,null,null,"Project Portfolio Summary",null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-04-02"}]
[null,"Num","Project","PM","Start_date","Target_Comp_Date","Forecast_Comp_Date","Category","Status","Phase","Internal/External","Priority","Scope","Time","Cost","Quality","Risk","Comments"]
[null,1,"Project 1","CD","2009-01-01","2009-03-01","2009-03-01","Cust A","On-hold",1,"E",1,null,null,null,null,null,"Comment 1"]
[null,2,"Project 2","IJ","2009-01-02","2009-03-02","2009-03-02","Cust B","Active",5,"E",2,null,null,null,null,null,"Comment 2"]
[null,3,"Project 3","GH","2009-01-03","2009-03-03","2009-03-03","IT","Active",2,"I",3,null,null,null,null,null,"Comment 3"]
[null,4,"Project 4","GH","2009-01-04","2009-03-04","2009-03-04","Fac","Active",1,"I",2,null,null,null,null,null,"Comment 4"]
[null,5,"Project 5","CD","2009-01-05","2009-03-05","2009-03-05","Mkting","Active",2,"I",1,null," ",null,null,null,"Comment 5"]
[null,6,"Project 6","IJ","2009-01-06","2009-03-06","2009-03-06","Mkting","Active",3,"I",2,null," ",null,null,null,"Comment 6"]
[null,7,"Project 7","GH","2009-01-07","2009-03-07","2009-03-07","Cust A","Active",4,"E",3,null," ",null,null,null,"Comment 7"]
[null,8,"Project 8","EF","2009-01-08","2009-03-08","2009-03-08","IT","Active",5,"I",2,null," ",null,null,null,"Comment 8"]
[null,9,"Project 9","CD","2009-01-09","2009-03-09","2009-03-09","Other","Active",4,"I",1,null,null,null,null,null,"Comment 9"]
[null,10,"Project 10","IJ","2009-01-10","2009-03-10","2009-03-10","IT","Active",3,"I",3,null," ",null,null,null,"Comment 10"]
[null,11,"Project 11","GH","2009-01-11","2009-03-11","2009-03-11","Cust A","Active",3,"E",2,null,null,null,null,null,"Comment 11"]
[null,12,"Project 12","GH","2009-01-12","2009-03-12","2009-03-12","Cust B","Active",3,"E",1,null,null,null,null," ","Comment 12"]
[null,13,"Project 13","CD","2009-01-13","2009-03-13","2009-03-13","IT","Active",2,"I",1,null,null,null,null,null,"Comment 13"]
[null,14,"Project 14","KL","2009-01-14","2009-03-14","2009-03-14","Fac","Active",1,"I",1,null,null,null,null,null,"Comment 14"]
[null,15,"Project 15","KL","2009-01-15","2009-03-15","2009-03-15","Mkting","Active",1,"I",3,null,null,null,null,null,"Comment 15"]
[null,16,"Project 16","CD","2009-01-16","2009-03-16","2009-03-16","Mkting","On-hold",2,"I",3," ",null,null,null,null,"Comment 16"]
[null,17,"Project 17","CD","2009-01-17","2009-03-17","2009-03-17","Cust A","Active",1,"E",3,null," ",null,null,null,"Comment 17"]
[null,18,"Project 18","CD","2009-01-18","2009-03-18","2009-03-18","IT","Complete",5,"I",2,null,null,null,null,null,"COMPLETE"]
[null,19,"Project 19","CD","2009-01-19","2009-03-19","2009-03-19","Other","On-hold",3,"I",1,null," ",null,null,null,"Comment 19"]

{"sheet":"Stats","index":1,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,15,1,18]]}
[]
[null,"Projects by Category",null,null,null,null,null,"Project Portfolio Analysis",null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-04-02"}]
[]
[null,"Row Labels","Count of Project"]
[null,"Cust A",4]
[null,"Cust B",2]
[null,"Fac",2]
[null,"IT",5]
[null,"Mkting",4]
[null,"Other",2]
[null,"Grand Total",19]
[]
[]
[null,"Projects by Status"]
[]
[null,"Row Labels","Count of Project"]
[null,"Complete",1]
[null,"On-hold",3]
[null,"Active",15]
[null,"Grand Total",19]
[]
[null,"Projects by Priority"]
[]
[null,"Row Labels","Count of Project"]
[null,1,7]
[null,2,6]
[null,3,6]
[null,"Grand Total",19]
[]
[null,"Projects by Project Manager"]
[]
[null,"Row Labels","Count of Project"]
[null,"CD",8]
[null,"GH",5]
[null,"IJ",3]
[null,"KL",2]
[null,"EF",1]
[null,"Grand Total",19]
[]
[null,"Projects by Phase"]
[]
[null,"Row Labels","Count of Project"]
[null,1,5]
[null,2,4]
[null,3,5]
[null,4,2]
[null,5,3]
[null,"Grand Total",19]
[]
[null,"Internal/External Projects"]
[]
[null,"Row Labels","Count of Project"]
[null,"E",6]
[null,"I",13]
[null,"Grand Total",19]

{"sheet":"Entries","index":2,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Project Managers"]
[]
[null,"AB","Albert","Ballard"]
[null,"CD","Clare","Devon"]
[null,"EF","Ellen","Fitzgerald"]
[null,"GH","George","Hampton"]
[null,"IJ","Ilene","Jones"]
[null,"KL","Kristen","Longshore"]
[]
[null,"Phase"]
[]
[null,1,"Feasibility"]
[null,2,"Initiation"]
[null,3,"Design"]
[null,4,"Construction"]
[null,5,"Close-out"]
[]
[null,"Status"]
[]
[null,"Complete"]
[null,"On-hold"]
[null,"Active"]
[]
[null,"Priority"]
[]
[null,1,"High"]
[null,2,"Medium"]
[null,3,"Low"]
[]
[null,"Categories"]
[]
[null,"Cust A","Customer A"]
[null,"Cust B","Customer B"]
[null,"IT","IT"]
[null,"Fac","Facilities"]
[null,"Mkting","Marketing"]
[null,"Sales","Sales"]
[null,"Quality","Quality"]
[null,"Other","Other"]
[null,null,null,null,null,"Project Portfolio Summary Key"]
[]
[null,null,null,null,null,"Time","Project is projected to complete before target completion date","Project may not complete prior to completion date","Project is forecast to complete after target completion date","Project is Complete"]
[null,null,null,null,null,"Scope","Project charter has been written. Scope is understood & under control","Charter has not been written and/or scope may be changing","Project scope is unclear and/or is changing","Project is Complete"]
[null,null,null,null,null,"Cost","Project is forecast to meet cost requirements","Project may not meet cost requirements","Project is not expected to meet cost requirements","Project is Complete"]
[null,null,null,null,null,"Quality","Project is forecast to meet quality expectations","There are challenges to project quality","Original project quality expectations will not be meet","Project is Complete"]
[null,null,null,null,null,"Risk","Risks are understood and planned for","Risks exist that could present a significant challenge to the project and/or a risk analysis has not been completed","Project is being significantly impacted by a negative risk event","Project is Complete"]