{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Home","Dashboard","Project Details","Project Plans","Risks & Issues","Settings","Sorting","Calculations","Gantt View","Help"],"not_rendered":{"charts":9,"images":18,"macros":1,"external_links":0,"defined_names":36,"comments":1,"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":"Home","index":0,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Welcome to Project Portfolio Dashboard. Follow these instructions to use the dashboard."]
[]
[null,1,"Enter high level project details in Project Details tab",null,null,null,null,null,{"$f":"Calculations!C4&\" projects specified\"","v":"8 projects specified"}]
[null,2,"Enter Individual project plan details in Project Plans page",null,null,null,null,null,{"$f":"COUNTA('Project Plans'!2:2)&\" plans specified\"","v":"10 plans specified"}]
[null,3,"Enter Risks & Issues ",null,null,null,null,null,{"$f":"COUNTA(tblRisks[ID])&\" risks and \"&COUNTA(tblIssues[ID])&\" issues defined\"","v":"25 risks and 25 issues defined"}]
[null,4,"Specify holidays and dashboard settings",null,null,null,null,null,{"$f":"COUNTA(tblHolidays[Date])&\" holidays added\"","v":"6 holidays added"}]
[null,5,"Define names for any new projects you have added"]
[null,6,"Check out the dashboard"]
[]
[null,"Quick Links:"]

{"sheet":"Dashboard","index":1,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,6,8,6],[10,6,13,6],[15,6,18,6],[20,6,23,6],[25,6,28,6]]}
[]
[]
[]
[]
[]
[null,null,{"$f":"Calculations!C9","v":"Riggs-A-lot decomissioning"}]
[null,null,{"$f":"Calculations!G9","v":0.5},{"$f":"C7","v":0.5},{"$f":"Calculations!I9","v":"$ 377k"},{"$f":"Calculations!H9","v":"3 months"}]
[]
[]
[]
[null,null,{"$f":"Calculations!C10","v":"Six Sigma Assessment"}]
[null,null,{"$f":"Calculations!G10","v":0.86},{"$f":"C12","v":0.86},{"$f":"Calculations!I10","v":"$ 445k"},{"$f":"Calculations!H10","v":"4 months"}]
[]
[]
[]
[null,null,{"$f":"Calculations!C11","v":"HRM Rollout"}]
[null,null,{"$f":"Calculations!G11","v":0.81},{"$f":"C17","v":0.81},{"$f":"Calculations!I11","v":"$ 322k"},{"$f":"Calculations!H11","v":"8 months"}]
[]
[]
[]
[null,null,{"$f":"Calculations!C12","v":"CBM Development"}]
[null,null,{"$f":"Calculations!G12","v":1},{"$f":"C22","v":1},{"$f":"Calculations!I12","v":"$ 302k"},{"$f":"Calculations!H12","v":"10 months"}]
[]
[null,null,null,null,null,null,null,null,"Critical Issues",null,null,"Risks",null,null,"Tasks",null,"People",null,"Comments"]
[]
[null,null,{"$f":"Calculations!C13","v":"12th Annual Customer Convention"}]
[null,null,{"$f":"Calculations!G13","v":0.79},{"$f":"C27","v":0.79},{"$f":"Calculations!I13","v":"$ 490k"},{"$f":"Calculations!H13","v":"11 months"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"mailto:\"&Settings!$I$6,\"@\")","v":"@"}]

{"sheet":"Project Details","index":2,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Project Names & Contact details",null,null,"Team Details"]
[]
[null,"ID","Project Name","Project Owner","Email","Phone","Budget ($)","Spent ($)","Deadline","% Done","Team Size","Comments"]
[null,1,"ABC Integration","Adam Albert","alberta@project.com","758-072-8357",484000,392910,"2014-04-12",0.84,20,"We need to focus on this project. It is going to be superb failure."]
[null,2,"Morlott Highway","Benny Brown","brownb@project.com","663-179-7666",382000,304893,"2014-07-13",0.91,15,"We need to be clam on this project. It is going to be massive story."]
[null,3,"Riggs-A-lot decomissioning","Cathernie Crown","crownc@project.com","396-233-5326",377000,222122,"2013-03-14",0.5,35,"We need to be clam on this project. It is going to be superb success."]
[null,4,"12th Annual Customer Convention","Daniel Darwin","darwind@project.com","667-789-3470",490000,445395,"2013-10-20",0.79,35,"We need to be wise on this project. It is going to be different failure."]
[null,5,"Six Sigma Assessment","Egan Ebert","eberte@project.com","334-903-8877",445000,323965,"2013-03-24",0.86,35,"We need to be wise on this project. It is going to be superb story."]
[null,6,"CBM Development","Frank Fraiser","fraiserf@project.com","261-543-6686",302000,188391,"2013-10-13",1,30,"We need to stay alert on this project. It is going to be superb failure."]
[null,7,"ASSOC Maintenance","Giri Gopalakrishnan","gopalakrishnang@project.com","873-031-7089",405000,360511,"2014-03-28",0.91,35,"We need to stay alert on this project. It is going to be superb failure."]
[null,8,"HRM Rollout","Hart Hankenson","hankensonh@project.com","426-687-7283",322000,171426,"2013-08-12",0.81,20,"We need to be clam on this project. It is going to be different success."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Team Details"]
[]
[null,"ID","Name","Email Address","Phone"]
[null,1,"Person Name1","person.name1@project.com","289-750-2196"]
[null,2,"Person Name2","person.name2@project.com","233-059-6909"]
[null,3,"Person Name3","person.name3@project.com","485-595-2759"]
[null,4,"Person Name4","person.name4@project.com","245-489-3050"]
[null,5,"Person Name5","person.name5@project.com","768-996-3793"]
[null,6,"Person Name6","person.name6@project.com","392-527-5968"]
[null,7,"Person Name7","person.name7@project.com","658-911-9822"]
[null,8,"Person Name8","person.name8@project.com","512-650-6887"]
[null,9,"Person Name9","person.name9@project.com","972-072-1316"]
[null,10,"Person Name10","person.name10@project.com","460-032-1593"]
[null,11,"Person Name11","person.name11@project.com","393-446-0326"]
[null,12,"Person Name12","person.name12@project.com","852-827-6157"]
[null,13,"Person Name13","person.name13@project.com","354-270-8237"]
[null,14,"Person Name14","person.name14@project.com","865-365-6838"]
[null,15,"Person Name15","person.name15@project.com","267-925-7168"]
[null,16,"Person Name16","person.name16@project.com","661-614-4173"]

{"sheet":"Project Plans","index":3,"n_rows":45,"n_cols":79,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Project 1",null,null,null,null,null,null,null,"Project 2",null,null,null,null,null,null,null,"Project 3",null,null,null,null,null,null,null,"Project 4",null,null,null,null,null,null,null,"Project 5",null,null,null,null,null,null,null,"Project 6",null,null,null,null,null,null,null,"Project 7",null,null,null,null,null,null,null,"Project 8",null,null,null,null,null,null,null,"Project 9",null,null,null,null,null,null,null,"Project 10"]
[null,{"$f":"INDEX(lstProjects,1)","v":"ABC Integration"},null,null,null,null,null,null,null,{"$f":"INDEX(lstProjects,2)","v":"Morlott Highway"},null,null,null,null,null,null,null,{"$f":"INDEX(lstProjects,3)","v":"Riggs-A-lot decomissioning"},null,null,null,null,null,null,null,{"$f":"INDEX(lstProjects,4)","v":"12th Annual Customer Convention"},null,null,null,null,null,null,null,{"$f":"INDEX(lstProjects,5)","v":"Six Sigma Assessment"},null,null,null,null,null,null,null,{"$f":"INDEX(lstProjects,6)","v":"CBM Development"},null,null,null,null,null,null,null,{"$f":"INDEX(lstProjects,7)","v":"ASSOC Maintenance"},null,null,null,null,null,null,null,{"$f":"INDEX(lstProjects,8)","v":"HRM Rollout"},null,null,null,null,null,null,null,{"$f":"INDEX(lstProjects,9)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,{"$f":"INDEX(lstProjects,10)","v":{"$error":"#REF!"}}]
[]
[null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)",null,null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)",null,null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)",null,null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)",null,null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)",null,null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)",null,null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)",null,null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)",null,null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)",null,null,"Activity","Start Date","Duration","% done","Budget ($)","Actual ($)"]
[null,"Activity 1","2011-08-27",14,0.77,5000,3176,null,null,"Activity 1","2011-09-26",14,0.89,4000,3234,null,null,"Activity 1","2011-08-27",14,0.89,5000,4298,null,null,"Activity 1","2011-08-27",21,0.83,5000,2210,null,null,"Activity 1","2011-08-27",14,0.83,3000,2338,null,null,"Activity 1","2011-08-27",21,0.8,3000,159,null,null,"Activity 1","2011-08-27",14,0.77,2000,1243,null,null,"Activity 1","2011-08-27",21,0.83,1000,291,null,null,"Activity 1","2011-09-26",14,0.89,1000,343,null,null,"Activity 1","2011-08-27",21,0.76,5000,1965]
[null,"Activity 2","2011-09-15",21,0.17,1000,119,null,null,"Activity 2","2011-10-13",7,0.14000000000000001,4000,227,null,null,"Activity 2","2011-09-12",7,0,1000,0,null,null,"Activity 2","2011-09-09",21,0,1000,0,null,null,"Activity 2","2011-09-07",14,0.19,1000,139,null,null,"Activity 2","2011-09-07",7,0.38,2000,46,null,null,"Activity 2","2011-09-14",21,0.3,4000,521,null,null,"Activity 2","2011-09-14",7,0,1000,0,null,null,"Activity 2","2011-10-12",14,0.47,3000,458,null,null,"Activity 2","2011-09-06",7,0.26,5000,96]
[null,"Activity 3","2011-10-04",14,0.51,4000,262,null,null,"Activity 3","2011-10-31",14,0.3,4000,914,null,null,"Activity 3","2011-09-26",7,0,5000,0,null,null,"Activity 3","2011-09-20",14,0,2000,0,null,null,"Activity 3","2011-09-26",7,0,2000,0,null,null,"Activity 3","2011-09-26",7,0.56000000000000005,1000,293,null,null,"Activity 3","2011-09-27",14,0,1000,0,null,null,"Activity 3","2011-09-23",14,0,5000,0,null,null,"Activity 3","2011-11-01",7,0.14000000000000001,3000,43,null,null,"Activity 3","2011-09-21",14,0.37,1000,227]
[null,"Activity 4","2011-10-17",14,0,3000,0,null,null,"Activity 4","2011-11-16",7,0.51,1000,0,null,null,"Activity 4","2011-10-10",21,0.01,1000,5,null,null,"Activity 4","2011-10-06",7,0.56000000000000005,4000,266,null,null,"Activity 4","2011-10-10",7,0.66,5000,3591,null,null,"Activity 4","2011-10-12",7,0.63,2000,272,null,null,"Activity 4","2011-10-07",14,0,3000,0,null,null,"Activity 4","2011-10-06",7,0,4000,0,null,null,"Activity 4","2011-11-11",21,0.55000000000000004,3000,1763,null,null,"Activity 4","2011-10-03",7,0.13,1000,11]
[null,"Activity 5","2011-10-27",14,0.68,3000,1798,null,null,"Activity 5","2011-11-30",14,0,3000,0,null,null,"Activity 5","2011-10-19",21,0.46,2000,1003,null,null,"Activity 5","2011-10-26",7,0.12,5000,399,null,null,"Activity 5","2011-10-25",21,0.69,2000,1223,null,null,"Activity 5","2011-10-21",7,0,5000,0,null,null,"Activity 5","2011-10-27",21,0,5000,0,null,null,"Activity 5","2011-10-18",7,0.41,2000,218,null,null,"Activity 5","2011-11-25",14,0.69,3000,1549,null,null,"Activity 5","2011-10-19",7,0,1000,0]
[null,"Activity 6","2011-11-08",14,0,2000,0,null,null,"Activity 6","2011-12-13",7,0,5000,0,null,null,"Activity 6","2011-11-03",21,0.28000000000000003,4000,705,null,null,"Activity 6","2011-11-07",21,0,3000,0,null,null,"Activity 6","2011-11-07",7,0,2000,0,null,null,"Activity 6","2011-11-08",21,0,1000,0,null,null,"Activity 6","2011-11-10",7,0.45,1000,145,null,null,"Activity 6","2011-10-28",14,0.53,5000,259,null,null,"Activity 6","2011-12-08",7,0,3000,0,null,null,"Activity 6","2011-10-31",7,0.39,3000,96]
[null,"Activity 7","2011-11-23",14,0,3000,0,null,null,"Activity 7","2011-12-27",7,0,1000,0,null,null,"Activity 7","2011-11-16",21,0,2000,0,null,null,"Activity 7","2011-11-24",21,0,3000,0,null,null,"Activity 7","2011-11-22",14,0,4000,0,null,null,"Activity 7","2011-11-28",21,0,4000,0,null,null,"Activity 7","2011-11-28",21,0.32,1000,208,null,null,"Activity 7","2011-11-14",14,0.67,2000,1390,null,null,"Activity 7","2011-12-23",7,0,1000,0,null,null,"Activity 7","2011-11-18",21,0.09,2000,157]
[null,"Activity 8","2011-12-06",7,0.03,2000,54,null,null,"Activity 8","2012-01-06",7,0.12,5000,581,null,null,"Activity 8","2011-11-25",21,0.13,3000,7,null,null,"Activity 8","2011-12-13",7,0,4000,0,null,null,"Activity 8","2011-12-05",21,0.33,4000,1125,null,null,"Activity 8","2011-12-08",14,0.13,4000,366,null,null,"Activity 8","2011-12-14",14,0.24,5000,895,null,null,"Activity 8","2011-12-02",14,0,2000,0,null,null,"Activity 8","2012-01-04",7,0,1000,0,null,null,"Activity 8","2011-12-06",14,0,3000,0]
[null,"Activity 9","2011-12-20",21,0.41,4000,864,null,null,"Activity 9","2012-01-25",14,0.33,5000,1500,null,null,"Activity 9","2011-12-06",21,0.38,5000,682,null,null,"Activity 9","2011-12-27",21,0.27,5000,1344,null,null,"Activity 9","2011-12-15",21,0,3000,0,null,null,"Activity 9","2011-12-22",14,0.65,5000,2374,null,null,"Activity 9","2011-12-30",7,0,3000,0,null,null,"Activity 9","2011-12-14",7,0.14000000000000001,4000,514,null,null,"Activity 9","2012-01-20",21,0,1000,0,null,null,"Activity 9","2011-12-21",7,0.28999999999999998,3000,452]
[null,"Activity 10","2012-01-03",7,0.4,3000,51,null,null,"Activity 10","2012-02-03",7,0.38,1000,274,null,null,"Activity 10","2011-12-22",14,0,5000,0,null,null,"Activity 10","2012-01-06",14,0.2,3000,222,null,null,"Activity 10","2012-01-03",21,0,5000,0,null,null,"Activity 10","2012-01-02",7,0,5000,0,null,null,"Activity 10","2012-01-18",7,0.68,4000,993,null,null,"Activity 10","2011-12-27",14,0.36,5000,1043,null,null,"Activity 10","2012-02-06",14,0.6,4000,85,null,null,"Activity 10","2012-01-10",7,0,2000,0]
[null,"Activity 11","2012-01-12",14,0.59,5000,1588,null,null,"Activity 11","2012-02-14",14,0.27,4000,874,null,null,"Activity 11","2012-01-10",7,0,1000,0,null,null,"Activity 11","2012-01-25",21,0,1000,0,null,null,"Activity 11","2012-01-12",21,0.17,1000,22,null,null,"Activity 11","2012-01-13",14,0,2000,0,null,null,"Activity 11","2012-02-03",14,0,2000,0,null,null,"Activity 11","2012-01-09",14,0,2000,0,null,null,"Activity 11","2012-02-22",7,0.41,2000,668,null,null,"Activity 11","2012-01-24",7,0.28999999999999998,5000,380]
[null,"Activity 12","2012-01-30",7,0,1000,0,null,null,"Activity 12","2012-03-01",14,0,4000,0,null,null,"Activity 12","2012-01-19",21,0,4000,0,null,null,"Activity 12","2012-02-13",21,0.59,1000,184,null,null,"Activity 12","2012-01-24",7,0.09,1000,46,null,null,"Activity 12","2012-01-26",21,0.12,2000,67,null,null,"Activity 12","2012-02-20",7,0.55000000000000004,1000,605,null,null,"Activity 12","2012-01-20",14,0.34,3000,61,null,null,"Activity 12","2012-03-06",14,0,4000,0,null,null,"Activity 12","2012-02-10",7,0.24,2000,307]
[null,"Activity 13","2012-02-13",21,0.47,2000,363,null,null,"Activity 13","2012-03-16",14,0,5000,0,null,null,"Activity 13","2012-02-03",7,0.19,3000,489,null,null,"Activity 13","2012-02-23",21,0.41,1000,405,null,null,"Activity 13","2012-02-07",7,0,5000,0,null,null,"Activity 13","2012-02-06",7,0.44,5000,856,null,null,"Activity 13","2012-02-29",14,0.67,2000,747,null,null,"Activity 13","2012-02-08",7,0,3000,0,null,null,"Activity 13","2012-03-16",14,0.27,4000,697,null,null,"Activity 13","2012-02-24",7,0,1000,0]
[null,"Activity 14","2012-02-29",14,0,1000,0,null,null,"Activity 14","2012-03-27",21,0.61,3000,143,null,null,"Activity 14","2012-02-16",14,0,3000,0,null,null,"Activity 14","2012-03-12",7,0.49,3000,552,null,null,"Activity 14","2012-02-21",21,0.16,3000,406,null,null,"Activity 14","2012-02-23",21,0,2000,0,null,null,"Activity 14","2012-03-13",14,0,5000,0,null,null,"Activity 14","2012-02-27",21,0.36,5000,898,null,null,"Activity 14","2012-04-03",14,0,3000,0,null,null,"Activity 14","2012-03-15",7,0,5000,0]
[null,"Activity 15","2012-03-15",7,0,2000,0,null,null,"Activity 15","2012-04-09",7,0.31,3000,129,null,null,"Activity 15","2012-03-01",21,0,3000,0,null,null,"Activity 15","2012-03-21",14,0.41,3000,898,null,null,"Activity 15","2012-03-07",7,0.28000000000000003,4000,398,null,null,"Activity 15","2012-03-13",14,0.09,5000,120,null,null,"Activity 15","2012-03-27",21,0,2000,0,null,null,"Activity 15","2012-03-09",14,0,2000,0,null,null,"Activity 15","2012-04-17",14,0.44,1000,290,null,null,"Activity 15","2012-03-27",21,0.41,2000,114]
[null,"Activity 16","2012-04-02",7,0,1000,0,null,null,"Activity 16","2012-04-19",21,0,1000,0,null,null,"Activity 16","2012-03-20",21,0.42,3000,412,null,null,"Activity 16","2012-04-03",14,0.62,1000,467,null,null,"Activity 16","2012-03-21",14,0.12,2000,85,null,null,"Activity 16","2012-03-26",7,0,1000,0,null,null,"Activity 16","2012-04-13",7,0.7,1000,403,null,null,"Activity 16","2012-03-20",21,0,5000,0,null,null,"Activity 16","2012-04-30",7,0.02,3000,17,null,null,"Activity 16","2012-04-09",21,0.66,5000,1281]
[null,"Activity 17","2012-04-12",14,0.16,2000,49,null,null,"Activity 17","2012-05-03",7,0.64,1000,306,null,null,"Activity 17","2012-04-09",7,0,5000,0,null,null,"Activity 17","2012-04-20",21,0.15,4000,188,null,null,"Activity 17","2012-04-10",14,0.19,1000,30,null,null,"Activity 17","2012-04-13",21,0.45,4000,1705,null,null,"Activity 17","2012-04-30",7,0,1000,0,null,null,"Activity 17","2012-03-30",7,0.69,5000,1067,null,null,"Activity 17","2012-05-18",7,0.14000000000000001,4000,527,null,null,"Activity 17","2012-04-24",7,0,4000,0]
[null,"Activity 18","2012-04-26",14,0.47,4000,896,null,null,"Activity 18","2012-05-16",21,0.7,2000,1013,null,null,"Activity 18","2012-04-23",7,0.17,2000,123,null,null,"Activity 18","2012-05-07",21,0,1000,0,null,null,"Activity 18","2012-04-27",14,0.56999999999999995,2000,604,null,null,"Activity 18","2012-05-03",21,0.11,4000,98,null,null,"Activity 18","2012-05-11",14,0.04,3000,129,null,null,"Activity 18","2012-04-18",21,0.06,1000,43,null,null,"Activity 18","2012-05-31",14,0,4000,0,null,null,"Activity 18","2012-05-09",14,0.45,1000,45]
[null,"Activity 19","2012-05-09",14,0.04,2000,54,null,null,"Activity 19","2012-05-29",7,0,4000,0,null,null,"Activity 19","2012-05-04",7,0,1000,0,null,null,"Activity 19","2012-05-22",7,0.2,5000,541,null,null,"Activity 19","2012-05-09",14,0,2000,0,null,null,"Activity 19","2012-05-22",14,0,3000,0,null,null,"Activity 19","2012-05-23",7,0.3,2000,561,null,null,"Activity 19","2012-05-07",14,0,2000,0,null,null,"Activity 19","2012-06-13",14,0,1000,0,null,null,"Activity 19","2012-05-25",7,0.04,1000,14]
[null,"Activity 20","2012-05-29",21,0.1,3000,155,null,null,"Activity 20","2012-06-18",7,0.61,1000,637,null,null,"Activity 20","2012-05-15",21,0.51,2000,40,null,null,"Activity 20","2012-06-11",21,0,5000,0,null,null,"Activity 20","2012-05-18",21,0,2000,0,null,null,"Activity 20","2012-06-01",7,0,4000,0,null,null,"Activity 20","2012-06-05",14,0.34,2000,259,null,null,"Activity 20","2012-05-16",7,0.37,4000,7,null,null,"Activity 20","2012-06-25",14,0,3000,0,null,null,"Activity 20","2012-06-12",14,0,5000,0]
[null,"Activity 21","2012-06-13",21,0.35,3000,77,null,null,"Activity 21","2012-06-28",7,0,4000,0,null,null,"Activity 21","2012-05-31",21,0.53,2000,278,null,null,"Activity 21","2012-06-22",21,0.26,5000,210,null,null,"Activity 21","2012-05-31",21,0.24,1000,104,null,null,"Activity 21","2012-06-12",7,0,2000,0,null,null,"Activity 21","2012-06-22",21,0,2000,0,null,null,"Activity 21","2012-05-30",7,0,1000,0,null,null,"Activity 21","2012-07-12",7,0.7,2000,1225,null,null,"Activity 21","2012-06-21",7,0.15,5000,806]
[null,"Activity 22","2012-06-27",7,0.11,3000,140,null,null,"Activity 22","2012-07-16",14,0.38,2000,456,null,null,"Activity 22","2012-06-19",7,0,1000,0,null,null,"Activity 22","2012-07-04",7,0.68,4000,1997,null,null,"Activity 22","2012-06-18",14,0,2000,0,null,null,"Activity 22","2012-06-29",7,0,1000,0,null,null,"Activity 22","2012-07-09",7,0.64,5000,1792,null,null,"Activity 22","2012-06-12",14,0.32,4000,990,null,null,"Activity 22","2012-07-30",14,0.55000000000000004,1000,540,null,null,"Activity 22","2012-07-02",14,0.25,4000,866]
[null,"Activity 23","2012-07-10",7,0.54,4000,1058,null,null,"Activity 23","2012-07-25",21,0,2000,0,null,null,"Activity 23","2012-07-04",21,0,2000,0,null,null,"Activity 23","2012-07-18",7,7.0000000000000007E-2,1000,29,null,null,"Activity 23","2012-07-03",21,0,5000,0,null,null,"Activity 23","2012-07-13",14,0,3000,0,null,null,"Activity 23","2012-07-24",21,0,4000,0,null,null,"Activity 23","2012-06-25",7,0.02,4000,46,null,null,"Activity 23","2012-08-15",14,0,3000,0,null,null,"Activity 23","2012-07-11",7,0,1000,0]
[null,"Activity 24","2012-07-27",7,0,2000,0,null,null,"Activity 24","2012-08-07",14,0.21,4000,317,null,null,"Activity 24","2012-07-24",7,0.47,5000,1731,null,null,"Activity 24","2012-08-03",21,0,5000,0,null,null,"Activity 24","2012-07-19",7,0.25,5000,876,null,null,"Activity 24","2012-07-31",21,0.08,1000,33,null,null,"Activity 24","2012-08-10",14,0.31,2000,654,null,null,"Activity 24","2012-07-12",14,0.18,3000,290,null,null,"Activity 24","2012-08-31",14,0,4000,0,null,null,"Activity 24","2012-07-20",7,0,1000,0]
[null,"Activity 25","2012-08-08",7,0,5000,0,null,null,"Activity 25","2012-08-27",14,0,3000,0,null,null,"Activity 25","2012-08-03",14,0,5000,0,null,null,"Activity 25","2012-08-23",7,0,2000,0,null,null,"Activity 25","2012-08-03",7,0,5000,0,null,null,"Activity 25","2012-08-13",14,0.46,4000,769,null,null,"Activity 25","2012-08-27",14,0.57999999999999996,1000,617,null,null,"Activity 25","2012-08-01",14,0,4000,0,null,null,"Activity 25","2012-09-18",14,0,1000,0,null,null,"Activity 25","2012-08-03",7,0,2000,0]
[null,"Activity 26","2012-08-20",21,0,3000,0,null,null,"Activity 26","2012-09-11",21,0.36,3000,855,null,null,null,null,null,null,null,null,null,null,"Activity 26","2012-09-12",14,0.69,5000,2520,null,null,"Activity 26","2012-08-17",14,0,1000,0,null,null,"Activity 26","2012-08-31",7,0.49,4000,1199,null,null,"Activity 26","2012-09-06",7,0,5000,0,null,null,"Activity 26","2012-08-10",14,0,1000,0,null,null,"Activity 26","2012-09-27",21,0,4000,0,null,null,"Activity 26","2012-08-17",21,0,1000,0]
[null,"Activity 27","2012-09-06",21,0.37,1000,69,null,null,"Activity 27","2012-09-25",7,0,4000,0,null,null,null,null,null,null,null,null,null,null,"Activity 27","2012-09-25",7,0.7,2000,1283,null,null,"Activity 27","2012-09-04",21,0.69,2000,900,null,null,"Activity 27","2012-09-17",21,0,5000,0,null,null,"Activity 27","2012-09-18",21,0,2000,0,null,null,"Activity 27","2012-08-24",14,0.55000000000000004,4000,2172,null,null,"Activity 27","2012-10-16",14,0.39,1000,150,null,null,"Activity 27","2012-09-06",7,0,3000,0]
[null,"Activity 28","2012-09-20",21,0,2000,0,null,null,"Activity 28","2012-10-08",14,0,5000,0,null,null,null,null,null,null,null,null,null,null,"Activity 28","2012-10-04",21,0.66,1000,538,null,null,"Activity 28","2012-09-13",21,0.18,3000,548,null,null,"Activity 28","2012-10-04",7,0,3000,0,null,null,"Activity 28","2012-10-01",7,0.52,5000,512,null,null,"Activity 28","2012-09-07",21,0,4000,0,null,null,"Activity 28","2012-10-25",7,0.16,4000,166,null,null,"Activity 28","2012-09-20",14,0,2000,0]
[null,"Activity 29","2012-10-03",7,0,4000,0,null,null,"Activity 29","2012-10-25",21,0.01,2000,6,null,null,null,null,null,null,null,null,null,null,"Activity 29","2012-10-23",7,0,3000,0,null,null,"Activity 29","2012-10-02",14,0,4000,0,null,null,"Activity 29","2012-10-17",7,0.28999999999999998,2000,12,null,null,"Activity 29","2012-10-15",7,0.46,5000,922,null,null,"Activity 29","2012-09-24",7,0,5000,0,null,null,"Activity 29","2012-11-13",14,0.11,1000,102,null,null,"Activity 29","2012-10-02",14,0,4000,0]
[null,"Activity 30","2012-10-23",7,0.38,3000,169,null,null,"Activity 30","2012-11-12",14,0,3000,0,null,null,null,null,null,null,null,null,null,null,"Activity 30","2012-11-09",14,0.14000000000000001,2000,196,null,null,"Activity 30","2012-10-11",7,0,4000,0,null,null,"Activity 30","2012-11-02",14,0.6,5000,1446,null,null,"Activity 30","2012-10-29",7,0.12,4000,438,null,null,"Activity 30","2012-10-12",7,0,4000,0,null,null,"Activity 30","2012-11-22",21,0.4,4000,1335,null,null,"Activity 30","2012-10-19",21,0.35,4000,94]
[null,"Activity 31","2012-11-06",14,0,2000,0,null,null,"Activity 31","2012-11-22",7,0.38,5000,25,null,null,null,null,null,null,null,null,null,null,"Activity 31","2012-11-23",14,0.57999999999999996,1000,454,null,null,"Activity 31","2012-10-31",21,0.17,5000,525,null,null,"Activity 31","2012-11-15",14,0.33,3000,253,null,null,"Activity 31","2012-11-13",7,0.28000000000000003,1000,53,null,null,"Activity 31","2012-11-01",7,0.19,1000,87,null,null,"Activity 31","2012-12-03",14,0,2000,0,null,null,"Activity 31","2012-11-01",21,0,4000,0]
[null,"Activity 32","2012-11-22",7,0.26,2000,492,null,null,"Activity 32","2012-12-12",21,0.27,4000,666,null,null,null,null,null,null,null,null,null,null,"Activity 32","2012-12-10",21,0.48,4000,1725,null,null,"Activity 32","2012-11-16",7,0,1000,0,null,null,"Activity 32","2012-11-30",14,0.69,3000,1270,null,null,"Activity 32","2012-11-22",21,0.28000000000000003,5000,938,null,null,"Activity 32","2012-11-19",7,0.47,4000,1222,null,null,"Activity 32","2012-12-20",21,0,3000,0,null,null,"Activity 32","2012-11-13",7,0.05,2000,79]
[null,"Activity 33","2012-12-03",14,0,5000,0,null,null,"Activity 33","2012-12-31",14,0,5000,0,null,null,null,null,null,null,null,null,null,null,"Activity 33","2012-12-20",7,0,3000,0,null,null,"Activity 33","2012-12-03",14,0.52,5000,204,null,null,"Activity 33","2012-12-12",21,0,3000,0,null,null,"Activity 33","2012-12-10",21,0,1000,0,null,null,"Activity 33","2012-12-05",7,0.56999999999999995,5000,1533,null,null,"Activity 33","2013-01-04",21,0,2000,0,null,null,"Activity 33","2012-12-03",7,0,1000,0]
[null,"Activity 34","2012-12-17",14,0,3000,0,null,null,"Activity 34","2013-01-18",7,0,1000,0,null,null,null,null,null,null,null,null,null,null,"Activity 34","2013-01-07",14,0.7,5000,3207,null,null,"Activity 34","2012-12-21",21,0.66,2000,29,null,null,"Activity 34","2012-12-26",21,0,2000,0,null,null,"Activity 34","2012-12-20",14,0.41,5000,1617,null,null,"Activity 34","2012-12-18",14,0,4000,0,null,null,"Activity 34","2013-01-16",21,0,3000,0,null,null,"Activity 34","2012-12-12",14,0,1000,0]
[null,"Activity 35","2012-12-31",14,0.16,2000,204,null,null,"Activity 35","2013-02-07",7,0,4000,0,null,null,null,null,null,null,null,null,null,null,"Activity 35","2013-01-23",7,0,1000,0,null,null,"Activity 35","2013-01-08",14,0.39,1000,419,null,null,"Activity 35","2013-01-15",21,0.03,1000,23,null,null,"Activity 35","2013-01-04",14,0.02,2000,21,null,null,"Activity 35","2013-01-07",21,0.61,4000,2432,null,null,"Activity 35","2013-01-25",21,0,5000,0,null,null,"Activity 35","2013-01-01",21,0.55000000000000004,2000,765]
[null,"Activity 36","2013-01-09",7,0,3000,0,null,null,"Activity 36","2013-02-21",14,0.21,5000,559,null,null,null,null,null,null,null,null,null,null,"Activity 36","2013-02-11",14,0.41,5000,912,null,null,"Activity 36","2013-01-23",7,0.3,5000,681,null,null,"Activity 36","2013-01-25",14,0.15,2000,82,null,null,"Activity 36","2013-01-15",14,0.64,3000,1149,null,null,"Activity 36","2013-01-16",14,0,3000,0,null,null,"Activity 36","2013-02-13",7,0,5000,0,null,null,"Activity 36","2013-01-14",14,0.19,3000,81]
[null,"Activity 37","2013-01-25",14,0,4000,0,null,null,"Activity 37","2013-03-11",7,0,4000,0,null,null,null,null,null,null,null,null,null,null,"Activity 37","2013-03-01",14,0,4000,0,null,null,"Activity 37","2013-02-04",21,0.39,3000,986,null,null,"Activity 37","2013-02-12",7,0,3000,0,null,null,"Activity 37","2013-02-04",7,0.19,2000,220,null,null,"Activity 37","2013-01-25",14,0,1000,0,null,null,"Activity 37","2013-03-01",14,0,5000,0,null,null,"Activity 37","2013-01-28",7,0,1000,0]
[null,"Activity 38","2013-02-05",14,0,1000,0,null,null,"Activity 38","2013-03-26",21,0.24,4000,261,null,null,null,null,null,null,null,null,null,null,"Activity 38","2013-03-13",14,0.5,3000,1027,null,null,"Activity 38","2013-02-22",14,0.01,1000,11,null,null,"Activity 38","2013-02-28",7,0.34,4000,153,null,null,"Activity 38","2013-02-19",21,0,4000,0,null,null,"Activity 38","2013-02-08",21,0.59,1000,511,null,null,"Activity 38","2013-03-14",21,0.42,2000,125,null,null,"Activity 38","2013-02-08",7,0.42,2000,205]
[null,"Activity 39","2013-02-20",21,0.02,3000,7,null,null,"Activity 39","2013-04-12",14,0.17,1000,109,null,null,null,null,null,null,null,null,null,null,"Activity 39","2013-04-01",7,0.66,3000,1450,null,null,"Activity 39","2013-03-13",7,0,3000,0,null,null,"Activity 39","2013-03-12",7,0.44,4000,1839,null,null,"Activity 39","2013-03-11",21,0,1000,0,null,null,"Activity 39","2013-02-22",14,0.62,2000,1138,null,null,"Activity 39","2013-03-26",7,0,1000,0,null,null,"Activity 39","2013-02-21",7,0,2000,0]
[null,"Activity 40","2013-03-06",21,0.42,2000,172,null,null,"Activity 40","2013-05-02",14,0,4000,0,null,null,null,null,null,null,null,null,null,null,"Activity 40","2013-04-16",7,0,5000,0,null,null,"Activity 40","2013-03-22",7,0,1000,0,null,null,"Activity 40","2013-03-29",21,0,5000,0,null,null,"Activity 40","2013-03-29",14,0.33,3000,8,null,null,"Activity 40","2013-03-07",7,0.33,4000,1297,null,null,"Activity 40","2013-04-10",7,0,3000,0,null,null,"Activity 40","2013-03-07",14,0.15,4000,451]

{"sheet":"Risks & Issues","index":4,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Risks",null,null,null,"(1 to 5)",null,null,"Issues",null,null,null,"(1 to 5)"]
[null,"ID","In Project","Risk Description","Mitigation Plan","Severity",null,null,"ID","In Project","Description","Assigned to","Criticality","Due date","Closed?"]
[null,1,"CBM Development","Some complicated risk","",1,null,null,1,"Riggs-A-lot decomissioning","Some very simple issue","Person Name13",2,"",""]
[null,2,"Riggs-A-lot decomissioning","Some very complicated risk","",1,null,null,2,"ABC Integration","Some very simple issue","Person Name13",3,"2012-12-05",""]
[null,3,"ASSOC Maintenance","Some very unforeseen risk","Our plan",4,null,null,3,"12th Annual Customer Convention","Some simple issue","Person Name3",3,"2012-11-30",""]
[null,4,"HRM Rollout","Some very simple risk","",5,null,null,4,"Riggs-A-lot decomissioning","Some very unforeseen issue","Person Name12",2,"2012-12-04",""]
[null,5,"12th Annual Customer Convention","Some very simple risk","",5,null,null,5,"12th Annual Customer Convention","Some very simple issue","Person Name3",5,"2012-12-06",""]
[null,6,"HRM Rollout","Some very simple risk","Our plan",3,null,null,6,"ASSOC Maintenance","Some simple issue","Person Name12",5,"2012-12-04","Yes"]
[null,7,"Six Sigma Assessment","Some very simple risk","",1,null,null,7,"Six Sigma Assessment","Some complicated issue","Person Name11",2,"",""]
[null,8,"ABC Integration","Some complicated risk","",3,null,null,8,"Riggs-A-lot decomissioning","Some very complicated issue","Person Name12",3,"2012-11-30",""]
[null,9,"CBM Development","Some very simple risk","",5,null,null,9,"ASSOC Maintenance","Some very unforeseen issue","Person Name12",5,"2012-11-30",""]
[null,10,"CBM Development","Some very simple risk","",3,null,null,10,"12th Annual Customer Convention","Some very simple issue","Person Name15",4,"",""]
[null,11,"CBM Development","Some very simple risk","",3,null,null,11,"Riggs-A-lot decomissioning","Some very complicated issue","Person Name1",4,"2012-12-03",""]
[null,12,"Six Sigma Assessment","Some unforeseen risk","",2,null,null,12,"Six Sigma Assessment","Some very complicated issue","Person Name10",5,"2012-11-29",""]
[null,13,"HRM Rollout","Some very simple risk","",2,null,null,13,"ABC Integration","Some very unforeseen issue","Person Name5",4,"2012-12-03",""]
[null,14,"ASSOC Maintenance","Some very unforeseen risk","",5,null,null,14,"Six Sigma Assessment","Some very complicated issue","Person Name13",1,"",""]
[null,15,"CBM Development","Some very simple risk","",5,null,null,15,"ABC Integration","Some very simple issue","Person Name14",3,"2012-12-03",""]
[null,16,"ABC Integration","Some very unforeseen risk","",1,null,null,16,"ABC Integration","Some very simple issue","Person Name7",3,"2012-12-05",""]
[null,17,"HRM Rollout","Some complicated risk","",2,null,null,17,"12th Annual Customer Convention","Some very simple issue","Person Name8",1,"",""]
[null,18,"CBM Development","Some simple risk","Our plan",1,null,null,18,"Morlott Highway","Some very complicated issue","Person Name13",4,"2012-12-06",""]
[null,19,"HRM Rollout","Some very complicated risk","",3,null,null,19,"ABC Integration","Some very simple issue","Person Name10",3,"2012-12-07",""]
[null,20,"Riggs-A-lot decomissioning","Some very complicated risk","",5,null,null,20,"CBM Development","Some very unforeseen issue","Person Name8",4,"2012-12-03",""]
[null,21,"Morlott Highway","Some very complicated risk","",3,null,null,21,"Six Sigma Assessment","Some very complicated issue","Person Name16",3,"2012-12-03","Yes"]
[null,22,"12th Annual Customer Convention","Some very unforeseen risk","",2,null,null,22,"ASSOC Maintenance","Some complicated issue","Person Name2",3,"2012-11-28",""]
[null,23,"12th Annual Customer Convention","Some very simple risk","",3,null,null,23,"ABC Integration","Some very simple issue","Person Name7",4,"",""]
[null,24,"ASSOC Maintenance","Some complicated risk","",1,null,null,24,"HRM Rollout","Some simple issue","Person Name14",1,"",""]
[null,25,"CBM Development","Some very unforeseen risk","",2,null,null,25,"ASSOC Maintenance","Some very unforeseen issue","Person Name14",2,"2012-12-06",""]

{"sheet":"Settings","index":5,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,4,3,5],[3,7,3,8]]}
[]
[]
[]
[null,"List of Holidays",null,null,"Project Progress Traffic Light thresholds",null,null,"Prepared by"]
[null,"Date","Reason",null,"Green",0.75,null,"Name","John Doe"]
[null,"2012-01-01","New years eve",null,"Amber",0.4,null,"Email","john.doe@mail.com"]
[null,"2012-12-25","Christmas",null,null,null,null,"Date",{"$f":"TODAY()","v":"2012-11-19"}]
[null,"2013-01-01","New years eve"]
[null,"2013-12-25","Christmas"]
[null,"2014-01-01","New years eve"]
[null,"2014-12-25","Christmas"]

{"sheet":"Sorting","index":6,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
[null,"Sorting Projects by Sort order Please do not edit this sheet"]
[null,null,null,null,null,null,null,null,null,20]
[null,"Sort Types",null,null,null,null,null,null,"Value","Disp"]
[null,"% Done (0 -> 100%)",1,null,null,null,null,"Max Risks",{"$f":"INDEX($C$15:$C$64,MATCH(MAX(H15:H64),H15:H64,0))","v":"CBM Development"},{"$f":"\"Most: \"&LEFT(I4,$J$2)&REPT(\"…\",LEN(I4)>$J$2)","v":"Most: CBM Development"}]
[null,"Due Date (Now -> Later)",1,null,null,null,null,"Max Open Issues",{"$f":"INDEX($C$15:$C$64,MATCH(MAX(G15:G64),G15:G64,0))","v":"ABC Integration"},{"$f":"\"Most: \"&LEFT(I5,$J$2)&REPT(\"…\",LEN(I5)>$J$2)","v":"Most: ABC Integration"}]
[null,"% Budget Spent (100 -> 0)",0]
[null,"Open Issues (a lot -> a few)",0,null,null,null,null,{"$f":"\"Showing top \"&IF(Calculations!$C$5=0,\"5\",(Calculations!$C$5+1)&\" to \"&(Calculations!$C$5+5))&\" projects \"&IF(valSortType=6,\"in \",\"by \")&LOWER(INDEX(lstSortTypes,valSortType))","v":"Showing top 5 projects by due date (now -> later)"}]
[null,"Risks (a lot -> a few)",0]
[null,"Original Order",1]
[]
[null,"Sort Type",2,null,"Count",{"$f":"COUNTA(tblProjects[Project Name])","v":8}]
[null,"Sort Type Desc",{"$f":"INDEX(lstSortTypes,$C$11)","v":"Due Date (Now -> Later)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Ascending / Descending:",{"$f":"INDEX($C$4:$C$9,valSortType)","v":1},null,"Sorted"]
[null,"#","Project","% Done","Due Date","% Budget Spent","No. of Issues Pending","No. of Risks Unaddressed","ID",null,"Sort Column","De-dup","Sort Order",null,"ID"]
[null,1,{"$f":"INDEX(tblProjects[Project Name],$B15)","v":"ABC Integration"},{"$f":"INDEX(tblProjects[% Done],$B15)","v":0.84},{"$f":"INDEX(tblProjects[Deadline],$B15)","v":41741},{"$f":"INDEX(tblProjects[Spent ($)],$B15)/INDEX(tblProjects[Budget ($)],$B15)","v":0.81179752066115707},{"$f":"COUNTIFS(tblIssues[In Project],$C15,tblIssues[Closed?],\"<>Yes\")","v":6},{"$f":"COUNTIFS(tblRisks[In Project],$C15,tblRisks[Mitigation Plan],\"\")","v":2},{"$f":"INDEX(tblProjects[ID],B15)","v":1},null,{"$f":"INDEX($D15:$I15,valSortType)","v":41741},{"$f":"K15+(0.00000001)*$B15","v":41741.000000009997},{"$f":"RANK(L15,lstPrjSortItems,$M$13)","v":7},null,{"$f":"INDEX($I$15:$I$64,MATCH($B15,$M$15:$M$64,0))","v":3}]
[null,2,{"$f":"INDEX(tblProjects[Project Name],$B16)","v":"Morlott Highway"},{"$f":"INDEX(tblProjects[% Done],$B16)","v":0.91},{"$f":"INDEX(tblProjects[Deadline],$B16)","v":41833},{"$f":"INDEX(tblProjects[Spent ($)],$B16)/INDEX(tblProjects[Budget ($)],$B16)","v":0.79814921465968591},{"$f":"COUNTIFS(tblIssues[In Project],$C16,tblIssues[Closed?],\"<>Yes\")","v":1},{"$f":"COUNTIFS(tblRisks[In Project],$C16,tblRisks[Mitigation Plan],\"\")","v":1},{"$f":"INDEX(tblProjects[ID],B16)","v":2},null,41833,{"$f":"K16+(0.00000001)*$B16","v":41833.000000020002},{"$f":"RANK(L16,lstPrjSortItems,$M$13)","v":8},null,{"$f":"INDEX($I$15:$I$64,MATCH($B16,$M$15:$M$64,0))","v":5}]
[null,3,{"$f":"INDEX(tblProjects[Project Name],$B17)","v":"Riggs-A-lot decomissioning"},{"$f":"INDEX(tblProjects[% Done],$B17)","v":0.5},{"$f":"INDEX(tblProjects[Deadline],$B17)","v":41347},{"$f":"INDEX(tblProjects[Spent ($)],$B17)/INDEX(tblProjects[Budget ($)],$B17)","v":0.58918302387267907},{"$f":"COUNTIFS(tblIssues[In Project],$C17,tblIssues[Closed?],\"<>Yes\")","v":4},{"$f":"COUNTIFS(tblRisks[In Project],$C17,tblRisks[Mitigation Plan],\"\")","v":2},{"$f":"INDEX(tblProjects[ID],B17)","v":3},null,41347,41347.000000029999,{"$f":"RANK(L17,lstPrjSortItems,$M$13)","v":1},null,8]
[null,4,{"$f":"INDEX(tblProjects[Project Name],$B18)","v":"12th Annual Customer Convention"},{"$f":"INDEX(tblProjects[% Done],$B18)","v":0.79},{"$f":"INDEX(tblProjects[Deadline],$B18)","v":41567},{"$f":"INDEX(tblProjects[Spent ($)],$B18)/INDEX(tblProjects[Budget ($)],$B18)","v":0.90896938775510205},{"$f":"COUNTIFS(tblIssues[In Project],$C18,tblIssues[Closed?],\"<>Yes\")","v":4},{"$f":"COUNTIFS(tblRisks[In Project],$C18,tblRisks[Mitigation Plan],\"\")","v":3},{"$f":"INDEX(tblProjects[ID],B18)","v":4},null,41567,41567.000000040003,{"$f":"RANK(L18,lstPrjSortItems,$M$13)","v":5},null,6]
[null,5,{"$f":"INDEX(tblProjects[Project Name],$B19)","v":"Six Sigma Assessment"},{"$f":"INDEX(tblProjects[% Done],$B19)","v":0.86},{"$f":"INDEX(tblProjects[Deadline],$B19)","v":41357},{"$f":"INDEX(tblProjects[Spent ($)],$B19)/INDEX(tblProjects[Budget ($)],$B19)","v":0.72801123595505624},{"$f":"COUNTIFS(tblIssues[In Project],$C19,tblIssues[Closed?],\"<>Yes\")","v":3},{"$f":"COUNTIFS(tblRisks[In Project],$C19,tblRisks[Mitigation Plan],\"\")","v":2},{"$f":"INDEX(tblProjects[ID],B19)","v":5},null,41357,41357.00000005,{"$f":"RANK(L19,lstPrjSortItems,$M$13)","v":2},null,4]
[null,6,{"$f":"INDEX(tblProjects[Project Name],$B20)","v":"CBM Development"},{"$f":"INDEX(tblProjects[% Done],$B20)","v":1},{"$f":"INDEX(tblProjects[Deadline],$B20)","v":41560},{"$f":"INDEX(tblProjects[Spent ($)],$B20)/INDEX(tblProjects[Budget ($)],$B20)","v":0.62381125827814565},{"$f":"COUNTIFS(tblIssues[In Project],$C20,tblIssues[Closed?],\"<>Yes\")","v":1},{"$f":"COUNTIFS(tblRisks[In Project],$C20,tblRisks[Mitigation Plan],\"\")","v":6},{"$f":"INDEX(tblProjects[ID],B20)","v":6},null,41560,41560.000000059998,{"$f":"RANK(L20,lstPrjSortItems,$M$13)","v":4},null,7]
[null,7,{"$f":"INDEX(tblProjects[Project Name],$B21)","v":"ASSOC Maintenance"},{"$f":"INDEX(tblProjects[% Done],$B21)","v":0.91},{"$f":"INDEX(tblProjects[Deadline],$B21)","v":41726},{"$f":"INDEX(tblProjects[Spent ($)],$B21)/INDEX(tblProjects[Budget ($)],$B21)","v":0.89015061728395062},{"$f":"COUNTIFS(tblIssues[In Project],$C21,tblIssues[Closed?],\"<>Yes\")","v":3},{"$f":"COUNTIFS(tblRisks[In Project],$C21,tblRisks[Mitigation Plan],\"\")","v":2},{"$f":"INDEX(tblProjects[ID],B21)","v":7},null,41726,41726.000000070002,{"$f":"RANK(L21,lstPrjSortItems,$M$13)","v":6},null,1]
[null,8,{"$f":"INDEX(tblProjects[Project Name],$B22)","v":"HRM Rollout"},{"$f":"INDEX(tblProjects[% Done],$B22)","v":0.81},{"$f":"INDEX(tblProjects[Deadline],$B22)","v":41498},{"$f":"INDEX(tblProjects[Spent ($)],$B22)/INDEX(tblProjects[Budget ($)],$B22)","v":0.53237888198757766},{"$f":"COUNTIFS(tblIssues[In Project],$C22,tblIssues[Closed?],\"<>Yes\")","v":1},{"$f":"COUNTIFS(tblRisks[In Project],$C22,tblRisks[Mitigation Plan],\"\")","v":4},{"$f":"INDEX(tblProjects[ID],B22)","v":8},null,41498,41498.000000079999,{"$f":"RANK(L22,lstPrjSortItems,$M$13)","v":3},null,2]
[null,9,{"$f":"INDEX(tblProjects[Project Name],$B23)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B23)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B23)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B23)/INDEX(tblProjects[Budget ($)],$B23)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C23,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C23,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B23)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L23,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,10,{"$f":"INDEX(tblProjects[Project Name],$B24)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B24)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B24)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B24)/INDEX(tblProjects[Budget ($)],$B24)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C24,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C24,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B24)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L24,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,11,{"$f":"INDEX(tblProjects[Project Name],$B25)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B25)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B25)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B25)/INDEX(tblProjects[Budget ($)],$B25)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C25,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C25,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B25)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L25,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,12,{"$f":"INDEX(tblProjects[Project Name],$B26)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B26)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B26)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B26)/INDEX(tblProjects[Budget ($)],$B26)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C26,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C26,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B26)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L26,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,13,{"$f":"INDEX(tblProjects[Project Name],$B27)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B27)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B27)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B27)/INDEX(tblProjects[Budget ($)],$B27)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C27,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C27,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B27)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L27,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,14,{"$f":"INDEX(tblProjects[Project Name],$B28)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B28)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B28)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B28)/INDEX(tblProjects[Budget ($)],$B28)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C28,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C28,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B28)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L28,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,15,{"$f":"INDEX(tblProjects[Project Name],$B29)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B29)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B29)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B29)/INDEX(tblProjects[Budget ($)],$B29)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C29,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C29,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B29)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L29,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,16,{"$f":"INDEX(tblProjects[Project Name],$B30)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B30)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B30)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B30)/INDEX(tblProjects[Budget ($)],$B30)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C30,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C30,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B30)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L30,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,17,{"$f":"INDEX(tblProjects[Project Name],$B31)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B31)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B31)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B31)/INDEX(tblProjects[Budget ($)],$B31)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C31,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C31,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B31)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L31,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,18,{"$f":"INDEX(tblProjects[Project Name],$B32)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B32)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B32)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B32)/INDEX(tblProjects[Budget ($)],$B32)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C32,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C32,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B32)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L32,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,19,{"$f":"INDEX(tblProjects[Project Name],$B33)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B33)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B33)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B33)/INDEX(tblProjects[Budget ($)],$B33)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C33,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C33,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B33)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L33,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,20,{"$f":"INDEX(tblProjects[Project Name],$B34)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B34)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B34)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B34)/INDEX(tblProjects[Budget ($)],$B34)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C34,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C34,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B34)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L34,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,21,{"$f":"INDEX(tblProjects[Project Name],$B35)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B35)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B35)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B35)/INDEX(tblProjects[Budget ($)],$B35)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C35,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C35,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B35)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L35,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,22,{"$f":"INDEX(tblProjects[Project Name],$B36)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B36)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B36)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B36)/INDEX(tblProjects[Budget ($)],$B36)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C36,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C36,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B36)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L36,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,23,{"$f":"INDEX(tblProjects[Project Name],$B37)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B37)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B37)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B37)/INDEX(tblProjects[Budget ($)],$B37)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C37,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C37,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B37)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L37,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,24,{"$f":"INDEX(tblProjects[Project Name],$B38)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B38)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B38)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B38)/INDEX(tblProjects[Budget ($)],$B38)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C38,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C38,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B38)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L38,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,25,{"$f":"INDEX(tblProjects[Project Name],$B39)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B39)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B39)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B39)/INDEX(tblProjects[Budget ($)],$B39)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C39,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C39,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B39)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L39,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,26,{"$f":"INDEX(tblProjects[Project Name],$B40)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B40)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B40)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B40)/INDEX(tblProjects[Budget ($)],$B40)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C40,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C40,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B40)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L40,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,27,{"$f":"INDEX(tblProjects[Project Name],$B41)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B41)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B41)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B41)/INDEX(tblProjects[Budget ($)],$B41)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C41,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C41,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B41)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L41,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,28,{"$f":"INDEX(tblProjects[Project Name],$B42)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B42)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B42)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B42)/INDEX(tblProjects[Budget ($)],$B42)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C42,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C42,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B42)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L42,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,29,{"$f":"INDEX(tblProjects[Project Name],$B43)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B43)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B43)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B43)/INDEX(tblProjects[Budget ($)],$B43)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C43,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C43,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B43)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L43,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,30,{"$f":"INDEX(tblProjects[Project Name],$B44)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B44)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B44)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B44)/INDEX(tblProjects[Budget ($)],$B44)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C44,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C44,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B44)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L44,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,31,{"$f":"INDEX(tblProjects[Project Name],$B45)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B45)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B45)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B45)/INDEX(tblProjects[Budget ($)],$B45)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C45,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C45,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B45)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L45,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,32,{"$f":"INDEX(tblProjects[Project Name],$B46)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B46)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B46)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B46)/INDEX(tblProjects[Budget ($)],$B46)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C46,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C46,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B46)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L46,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,33,{"$f":"INDEX(tblProjects[Project Name],$B47)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B47)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B47)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B47)/INDEX(tblProjects[Budget ($)],$B47)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C47,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C47,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B47)","v":{"$error":"#REF!"}},null,{"$f":"INDEX($D47:$I47,valSortType)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"RANK(L47,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,34,{"$f":"INDEX(tblProjects[Project Name],$B48)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B48)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B48)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B48)/INDEX(tblProjects[Budget ($)],$B48)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C48,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C48,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B48)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L48,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,35,{"$f":"INDEX(tblProjects[Project Name],$B49)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B49)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B49)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B49)/INDEX(tblProjects[Budget ($)],$B49)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C49,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C49,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B49)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L49,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,36,{"$f":"INDEX(tblProjects[Project Name],$B50)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B50)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B50)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B50)/INDEX(tblProjects[Budget ($)],$B50)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C50,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C50,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B50)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L50,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,37,{"$f":"INDEX(tblProjects[Project Name],$B51)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B51)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B51)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B51)/INDEX(tblProjects[Budget ($)],$B51)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C51,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C51,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B51)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L51,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,38,{"$f":"INDEX(tblProjects[Project Name],$B52)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B52)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B52)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B52)/INDEX(tblProjects[Budget ($)],$B52)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C52,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C52,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B52)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L52,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,39,{"$f":"INDEX(tblProjects[Project Name],$B53)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B53)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B53)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B53)/INDEX(tblProjects[Budget ($)],$B53)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C53,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C53,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B53)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L53,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,40,{"$f":"INDEX(tblProjects[Project Name],$B54)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B54)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B54)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B54)/INDEX(tblProjects[Budget ($)],$B54)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C54,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C54,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B54)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L54,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,41,{"$f":"INDEX(tblProjects[Project Name],$B55)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B55)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B55)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B55)/INDEX(tblProjects[Budget ($)],$B55)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C55,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C55,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B55)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L55,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,42,{"$f":"INDEX(tblProjects[Project Name],$B56)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B56)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B56)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B56)/INDEX(tblProjects[Budget ($)],$B56)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C56,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C56,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B56)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L56,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,43,{"$f":"INDEX(tblProjects[Project Name],$B57)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B57)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B57)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B57)/INDEX(tblProjects[Budget ($)],$B57)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C57,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C57,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B57)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L57,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,44,{"$f":"INDEX(tblProjects[Project Name],$B58)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B58)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B58)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B58)/INDEX(tblProjects[Budget ($)],$B58)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C58,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C58,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B58)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L58,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,45,{"$f":"INDEX(tblProjects[Project Name],$B59)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B59)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B59)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B59)/INDEX(tblProjects[Budget ($)],$B59)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C59,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C59,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B59)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L59,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,46,{"$f":"INDEX(tblProjects[Project Name],$B60)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B60)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B60)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B60)/INDEX(tblProjects[Budget ($)],$B60)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C60,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C60,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B60)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L60,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,47,{"$f":"INDEX(tblProjects[Project Name],$B61)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B61)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B61)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B61)/INDEX(tblProjects[Budget ($)],$B61)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C61,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C61,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B61)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L61,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,48,{"$f":"INDEX(tblProjects[Project Name],$B62)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B62)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B62)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B62)/INDEX(tblProjects[Budget ($)],$B62)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C62,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C62,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B62)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L62,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,49,{"$f":"INDEX(tblProjects[Project Name],$B63)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B63)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B63)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B63)/INDEX(tblProjects[Budget ($)],$B63)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C63,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C63,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B63)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L63,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]
[null,50,{"$f":"INDEX(tblProjects[Project Name],$B64)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[% Done],$B64)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Deadline],$B64)","v":{"$error":"#REF!"}},{"$f":"INDEX(tblProjects[Spent ($)],$B64)/INDEX(tblProjects[Budget ($)],$B64)","v":{"$error":"#REF!"}},{"$f":"COUNTIFS(tblIssues[In Project],$C64,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],$C64,tblRisks[Mitigation Plan],\"\")","v":0},{"$f":"INDEX(tblProjects[ID],B64)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"RANK(L64,lstPrjSortItems,$M$13)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"}]

{"sheet":"Calculations","index":7,"n_rows":164,"n_cols":36,"rows_kept":164,"cut":false,"hidden":true,"merged":[[1,34,4,34],[1,35,4,35]]}
[null,"Calculations Plese do not edit",null,null,null,"Program level calculations >>",null,null,null,null,null,null,null,null,null,"Totals",null,null,null,null,null,"Percents"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,4,3,2,1,null,{"$f":"P2","v":5},{"$f":"Q2","v":4},3,2,1,null,null,null,null,20,"In next 6 months",{"$f":"COUNTIFS(F9:F13,\"<=\"&EDATE(TODAY(),6),F9:F13,\">\"&TODAY())","v":2},{"$f":"IF(AG2=1,\" project ends\",\" projects end\")","v":" projects end"},{"$f":"AG2&CHAR(10)&AG3&CHAR(10)&AG4&CHAR(10)&AG5","v":"2\n35\n41\n7"},{"$f":"AH2&CHAR(10)&AH3&CHAR(10)&AH4&CHAR(10)&AH5","v":" projects end\n activities start\n activities end\n issues due"}]
[null,"Selected Project",{"$f":"D3","v":3},3,null,"Total Projects",{"$f":"C4&\" Projects\"","v":"8 Projects"},null,"Total Budgets",{"$f":"SUM(tblProjects[Budget ($)])","v":3207000},{"$f":"TEXT(J3,\"$##,,.0\")&\" mn\"","v":"$3.2 mn"},"Total members",{"$f":"SUM(tblProjects[Team Size])&\" members\"","v":"225 members"},null,"Risks",{"$f":"COUNTIF(tblRisks[Severity],P$2)","v":6},{"$f":"COUNTIF(tblRisks[Severity],Q$2)","v":1},{"$f":"COUNTIF(tblRisks[Severity],R$2)","v":7},{"$f":"COUNTIF(tblRisks[Severity],S$2)","v":5},{"$f":"COUNTIF(tblRisks[Severity],T$2)","v":6},{"$f":"SUM(P3:T3)&\" Risks\"","v":"25 Risks"},{"$f":"P3/SUM($P3:$T3)","v":0.24},{"$f":"Q3/SUM($P3:$T3)","v":0.04},{"$f":"R3/SUM($P3:$T3)","v":0.28000000000000003},{"$f":"S3/SUM($P3:$T3)","v":0.2},{"$f":"T3/SUM($P3:$T3)","v":0.24},null,null,null,"Last project due by",{"$f":"MAX(F9:F13)","v":41567},"Starts",{"$f":"SUM(AF9:AF13)","v":35},{"$f":"IF(AG3=1,\" activity starts\", \" activities start\")","v":" activities start"}]
[null,"Count of Projects",{"$f":"COUNTA(lstProjects)","v":8},null,null,"Progress",{"$f":"SUMPRODUCT(tblProjects[% Done],tblProjects[Budget ($)])/J3","v":0.82439975054568138},null,"Total Spent",{"$f":"SUM(tblProjects[Spent ($)])","v":2409613},{"$f":"TEXT(J4,\"$##,,.0\")&\" mn spent\"","v":"$2.4 mn spent"},null,null,null,"Issues",{"$f":"COUNTIFS(tblIssues[Criticality],P$2,tblIssues[Closed?],\"<>Yes\")","v":3},{"$f":"COUNTIFS(tblIssues[Criticality],Q$2,tblIssues[Closed?],\"<>Yes\")","v":6},{"$f":"COUNTIFS(tblIssues[Criticality],R$2,tblIssues[Closed?],\"<>Yes\")","v":7},{"$f":"COUNTIFS(tblIssues[Criticality],S$2,tblIssues[Closed?],\"<>Yes\")","v":4},{"$f":"COUNTIFS(tblIssues[Criticality],T$2,tblIssues[Closed?],\"<>Yes\")","v":3},{"$f":"SUM(P4:T4)&\" Open\"","v":"23 Open"},{"$f":"P4/SUM($P4:$T4)","v":0.13043478260869565},0.2608695652173913,0.30434782608695654,0.17391304347826086,0.13043478260869565,null,null,null,"Last Project",{"$f":"INDEX($C$9:$C$13,MATCH(AE3,F9:F13,0))","v":"12th Annual Customer Convention"},"Ends",{"$f":"SUM(AG9:AG13)","v":41},{"$f":"IF(AG4=1,\" activity ends\", \" activities end\")","v":" activities end"}]
[null,"Offset ",0,null,null,null,null,null,"%",{"$f":"J4/J3","v":0.75136046149048952},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Display",{"$f":"\"Last: \"&LEFT(AE4,$AE$2)&REPT(\"…\",LEN(AE4)>$AE$2)&\" in \"&TEXT(AE3,\"mmm,yyyy\")","v":"Last: 12th Annual Customer… in Oct,2013"},"Issues",{"$f":"SUM(AH9:AH13)","v":7},{"$f":"IF(AG5=1,\" issue due\", \" issues due\")","v":" issues due"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\u0080",null,null,"a",null,null,"i",null,null,"~",null,"\u0080ia\u0091~"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,">=3",null,"Display"]
["#","ID","Project","Budget","Spent","Due Date","% done","Due in","Budget Disp","Team Size","Table name","# of Tasks","# of issues","# of Risks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget","Spent",null,"Activity Starts","Activity Completion","Issues Due"]
[1,{"$f":"INDEX(lstSortedPrjIDs,A9+$C$5)","v":3},{"$f":"IFERROR(INDEX(lstProjects,B9),\"\")","v":"Riggs-A-lot decomissioning"},{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B9),\"\")","v":377000},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B9),\"\")","v":222122},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B9),\"\")","v":41347},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B9),\"\")","v":0.5},{"$f":"IF(F9=\"\",\"\",IF(TODAY()>=F9,IF(G9=1,\"Done\",\"Over due\"),(DATEDIF(TODAY(),F9,\"m\")&\" months\")))","v":"3 months"},{"$f":"TEXT(D9,\"$ #,\")&\"k\"","v":"$ 377k"},{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B9),\"\")","v":35},{"$f":"IF(C9=\"\",\"\",\"plan\"&B9)","v":"plan3"},{"$f":"IF(K9=\"\",0,COUNTA(INDIRECT(K9&\"[Activity]\")))","v":25},{"$f":"COUNTIFS(tblIssues[In Project],C9,tblIssues[Closed?],\"<>Yes\")","v":4},{"$f":"COUNTIFS(tblRisks[In Project],C9,tblRisks[Severity],$N$7)","v":1},null,{"$f":"$P$6","v":"\u0080"},{"$f":"J9","v":35},null,{"$f":"$S$6","v":"a"},{"$f":"L9","v":25},null,{"$f":"$V$6","v":"i"},{"$f":"M9","v":4},null,{"$f":"$Y$6","v":"~"},{"$f":"N9","v":1},null,null,1,{"$f":"E9/D9","v":0.58918302387267907},null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":0},{"$f":"IFERROR(SUMPRODUCT((lstActEnds<=EDATE(TODAY(),6))*(lstActEnds>TODAY())),0)","v":0},{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C9)","v":3}]
[2,{"$f":"INDEX(lstSortedPrjIDs,A10+$C$5)","v":5},"Six Sigma Assessment",{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B10),\"\")","v":445000},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B10),\"\")","v":323965},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B10),\"\")","v":41357},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B10),\"\")","v":0.86},{"$f":"IF(F10=\"\",\"\",IF(TODAY()>=F10,IF(G10=1,\"Done\",\"Over due\"),(DATEDIF(TODAY(),F10,\"m\")&\" months\")))","v":"4 months"},{"$f":"TEXT(D10,\"$ #,\")&\"k\"","v":"$ 445k"},{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B10),\"\")","v":35},{"$f":"IF(C10=\"\",\"\",\"plan\"&B10)","v":"plan5"},{"$f":"IF(K10=\"\",0,COUNTA(INDIRECT(K10&\"[Activity]\")))","v":40},{"$f":"COUNTIFS(tblIssues[In Project],C10,tblIssues[Closed?],\"<>Yes\")","v":3},{"$f":"COUNTIFS(tblRisks[In Project],C10,tblRisks[Severity],$N$7)","v":0},null,{"$f":"$P$6","v":"\u0080"},{"$f":"J10","v":35},null,{"$f":"$S$6","v":"a"},{"$f":"L10","v":40},null,{"$f":"$V$6","v":"i"},{"$f":"M10","v":3},null,{"$f":"$Y$6","v":"~"},{"$f":"N10","v":0},null,null,1,{"$f":"E10/D10","v":0.72801123595505624},null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":8},10,{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C10)","v":1}]
[3,{"$f":"INDEX(lstSortedPrjIDs,A11+$C$5)","v":8},"HRM Rollout",{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B11),\"\")","v":322000},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B11),\"\")","v":171426},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B11),\"\")","v":41498},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B11),\"\")","v":0.81},"8 months","$ 322k",{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B11),\"\")","v":20},"plan8",40,{"$f":"COUNTIFS(tblIssues[In Project],C11,tblIssues[Closed?],\"<>Yes\")","v":1},{"$f":"COUNTIFS(tblRisks[In Project],C11,tblRisks[Severity],$N$7)","v":3},null,"\u0080",20,null,"a",40,null,"i",1,null,"~",3,null,null,1,0.53237888198757766,null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":8},9,{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C11)","v":0}]
[4,{"$f":"INDEX(lstSortedPrjIDs,A12+$C$5)","v":6},"CBM Development",{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B12),\"\")","v":302000},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B12),\"\")","v":188391},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B12),\"\")","v":41560},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B12),\"\")","v":1},"10 months","$ 302k",{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B12),\"\")","v":30},"plan6",40,{"$f":"COUNTIFS(tblIssues[In Project],C12,tblIssues[Closed?],\"<>Yes\")","v":1},{"$f":"COUNTIFS(tblRisks[In Project],C12,tblRisks[Severity],$N$7)","v":4},null,"\u0080",30,null,"a",40,null,"i",1,null,"~",4,null,null,1,0.62381125827814565,null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":9},11,{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C12)","v":1}]
[5,{"$f":"INDEX(lstSortedPrjIDs,A13+$C$5)","v":4},"12th Annual Customer Convention",{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B13),\"\")","v":490000},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B13),\"\")","v":445395},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B13),\"\")","v":41567},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B13),\"\")","v":0.79},"11 months","$ 490k",{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B13),\"\")","v":35},"plan4",40,{"$f":"COUNTIFS(tblIssues[In Project],C13,tblIssues[Closed?],\"<>Yes\")","v":4},{"$f":"COUNTIFS(tblRisks[In Project],C13,tblRisks[Severity],$N$7)","v":2},null,"\u0080",35,null,"a",40,null,"i",4,null,"~",2,null,null,1,0.90896938775510205,null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":10},11,{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C13)","v":2}]
[6,{"$f":"INDEX(lstSortedPrjIDs,A14+$C$5)","v":7},"ASSOC Maintenance",{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B14),\"\")","v":405000},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B14),\"\")","v":360511},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B14),\"\")","v":41726},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B14),\"\")","v":0.91},"16 months","$ 405k",{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B14),\"\")","v":35},"plan7",40,{"$f":"COUNTIFS(tblIssues[In Project],C14,tblIssues[Closed?],\"<>Yes\")","v":3},{"$f":"COUNTIFS(tblRisks[In Project],C14,tblRisks[Severity],$N$7)","v":2},null,"\u0080",35,null,"a",40,null,"i",3,null,"~",2,null,null,1,0.89015061728395062,null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":9},10,{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C14)","v":3}]
[7,{"$f":"INDEX(lstSortedPrjIDs,A15+$C$5)","v":1},"ABC Integration",{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B15),\"\")","v":484000},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B15),\"\")","v":392910},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B15),\"\")","v":41741},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B15),\"\")","v":0.84},"16 months","$ 484k",{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B15),\"\")","v":20},"plan1",40,{"$f":"COUNTIFS(tblIssues[In Project],C15,tblIssues[Closed?],\"<>Yes\")","v":6},{"$f":"COUNTIFS(tblRisks[In Project],C15,tblRisks[Severity],$N$7)","v":1},null,"\u0080",20,null,"a",40,null,"i",6,null,"~",1,null,null,1,0.81179752066115707,null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":9},10,{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C15)","v":5}]
[8,{"$f":"INDEX(lstSortedPrjIDs,A16+$C$5)","v":2},"Morlott Highway",{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B16),\"\")","v":382000},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B16),\"\")","v":304893},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B16),\"\")","v":41833},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B16),\"\")","v":0.91},"19 months","$ 382k",{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B16),\"\")","v":15},"plan2",40,{"$f":"COUNTIFS(tblIssues[In Project],C16,tblIssues[Closed?],\"<>Yes\")","v":1},{"$f":"COUNTIFS(tblRisks[In Project],C16,tblRisks[Severity],$N$7)","v":1},null,"\u0080",15,null,"a",40,null,"i",1,null,"~",1,null,null,1,0.79814921465968591,null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":10},11,{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C16)","v":1}]
[9,{"$f":"INDEX(lstSortedPrjIDs,A17+$C$5)","v":{"$error":"#REF!"}},"",{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B17),\"\")","v":""},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B17),\"\")","v":""},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B17),\"\")","v":""},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B17),\"\")","v":""},"","k",{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B17),\"\")","v":""},"",0,{"$f":"COUNTIFS(tblIssues[In Project],C17,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],C17,tblRisks[Severity],$N$7)","v":0},null,"\u0080","",null,"a",0,null,"i",0,null,"~",0,null,null,1,{"$error":"#VALUE!"},null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":0},0,{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C17)","v":0}]
[10,{"$f":"INDEX(lstSortedPrjIDs,A18+$C$5)","v":{"$error":"#REF!"}},"",{"$f":"IFERROR(INDEX(tblProjects[Budget ($)],$B18),\"\")","v":""},{"$f":"IFERROR(INDEX(tblProjects[Spent ($)],$B18),\"\")","v":""},{"$f":"IFERROR(INDEX(tblProjects[Deadline],$B18),\"\")","v":""},{"$f":"IFERROR(INDEX(tblProjects[% Done],$B18),\"\")","v":""},"","k",{"$f":"IFERROR(INDEX(tblProjects[Team Size],$B18),\"\")","v":""},"",0,{"$f":"COUNTIFS(tblIssues[In Project],C18,tblIssues[Closed?],\"<>Yes\")","v":0},{"$f":"COUNTIFS(tblRisks[In Project],C18,tblRisks[Severity],$N$7)","v":0},null,"\u0080","",null,"a",0,null,"i",0,null,"~",0,null,null,1,{"$error":"#VALUE!"},null,{"$f":"IFERROR(SUMPRODUCT((lstActStarts<=EDATE(TODAY(),6))*(lstActStarts>TODAY())),0)","v":0},0,{"$f":"COUNTIFS(tblIssues[Due date],\">\"&TODAY(),tblIssues[Due date],\"<=\"&EDATE(TODAY(),6),tblIssues[Closed?],\"\",tblIssues[In Project],C18)","v":0}]
[]
[]
["Plan for Selected Project:",null,null,null,"Plan Width",null,90,null,null,null,null,null,null,null,"LEGEND:",{"$f":"$P$6","v":"\u0080"},"People",null,{"$f":"$S$6","v":"a"},"Activities",null,{"$f":"$V$6","v":"i"},"Issues",null,{"$f":"$Y$6","v":"~"},"Risks"]
[null,"ID",{"$f":"INDEX(lstSortedPrjIDs,valSP+$C$5)","v":8},null,"Min Start date",null,{"$f":"MIN(INDEX(lstPlans,,2,$C$22))","v":"2011-08-27"},{"$f":"WEEKDAY(G22)","v":7},null,null,"Label"]
[null,"Name",{"$f":"INDEX(C9:C13,valSP)","v":"HRM Rollout"},null,"Gantt Start date",null,{"$f":"IF(valGanttType=3,DATE(YEAR(G22),MONTH(G22),1),G22-CHOOSE(H22,6,0,1,2,3,4,5))","v":"2011-08-22"},"Offset",0,"Daily",{"$f":"C23&\" Plan\"","v":"HRM Rollout Plan"}]
[null,"Table name",{"$f":"\"plan\"&C22","v":"plan8"},null,"Total Plan Duration",null,{"$f":"NETWORKDAYS(G22,MAX(INDEX(lstPlans,,2,$C$22)),lstHolidays)","v":397},"Gantt Start + Offset",null,"Weekly"]
[null,"Offset",0,null,"Days, Weeks or Months?",null,1,{"$f":"G23+I23*7","v":"2011-08-22"},null,"Monthly"]
[]
[null,null,"Plan",1,2,3,4,5,6,null,null,"Plan>"]
[null,"#","ID",{"$f":"'Project Plans'!B5","v":"Activity"},{"$f":"'Project Plans'!C5","v":"Start Date"},{"$f":"'Project Plans'!D5","v":"Duration"},{"$f":"'Project Plans'!E5","v":"% done"},{"$f":"'Project Plans'!F5","v":"Budget ($)"},{"$f":"'Project Plans'!G5","v":"Actual ($)"},"End"]
[null,1,{"$f":"B29+$C$25","v":1},{"$f":"IFERROR(INDEX(lstPlans,$C29,D$27,$C$22),\"\")","v":"Activity 1"},"2011-08-27",21,0.83,1000,291,{"$f":"WORKDAY(E29,F29,lstHolidays)","v":"2011-09-26"}]
[null,2,{"$f":"B30+$C$25","v":2},"Activity 2","2011-09-14",7,0,1000,0,"2011-09-23"]
[null,3,3,"Activity 3","2011-09-23",14,0,5000,0,"2011-10-13"]
[null,4,4,"Activity 4","2011-10-06",7,0,4000,0,"2011-10-17"]
[null,5,5,"Activity 5","2011-10-18",7,0.41,2000,218,"2011-10-27"]
[null,6,6,"Activity 6","2011-10-28",14,0.53,5000,259,"2011-11-17"]
[null,7,7,"Activity 7","2011-11-14",14,0.67,2000,1390,"2011-12-02"]
[null,8,8,"Activity 8","2011-12-02",14,0,2000,0,"2011-12-22"]
[null,9,9,"Activity 9","2011-12-14",7,0.14000000000000001,4000,514,"2011-12-23"]
[null,10,10,"Activity 10","2011-12-27",14,0.36,5000,1043,"2012-01-16"]
[null,11,11,{"$f":"IFERROR(INDEX(lstPlans,$C39,D$27,$C$22),\"\")","v":"Activity 11"},"2012-01-09",14,0,2000,0,"2012-01-27"]
[null,12,12,"Activity 12","2012-01-20",14,0.34,3000,61,"2012-02-09"]
[null,13,13,"Activity 13","2012-02-08",7,0,3000,0,"2012-02-17"]
[null,14,14,"Activity 14","2012-02-27",21,0.36,5000,898,"2012-03-27"]
[null,15,15,"Activity 15","2012-03-09",14,0,2000,0,"2012-03-29"]
[null,16,16,"Activity 16","2012-03-20",21,0,5000,0,"2012-04-18"]
[null,17,17,"Activity 17","2012-03-30",7,0.69,5000,1067,"2012-04-10"]
[null,18,18,"Activity 18","2012-04-18",21,0.06,1000,43,"2012-05-17"]
[null,19,19,"Activity 19","2012-05-07",14,0,2000,0,"2012-05-25"]
[null,20,20,"Activity 20","2012-05-16",7,0.37,4000,7,"2012-05-25"]
[]
[]
["Issues for Selected Project"]
[null,{"$f":"B22","v":"ID"},8,null,"Max issue due date",{"$f":"MAX(F57:F76)+1","v":1}]
[null,"Name","HRM Rollout",null,"Min issue due date",{"$f":"MIN(F57:F76)","v":0},null,null,{"$f":"COUNTIF($B$57:$B$76,\">0\")","v":1}]
[]
[null,"All issues in this project",null,null,null,null,null,null,"Sorted by criticality & Due date and open-ness",null,null,null,"Sorted"]
[null,{"$f":"'Risks & Issues'!I3","v":"ID"},{"$f":"'Risks & Issues'!K3","v":"Description"},{"$f":"'Risks & Issues'!L3","v":"Assigned to"},{"$f":"'Risks & Issues'!M3","v":"Criticality"},{"$f":"'Risks & Issues'!N3","v":"Due date"},{"$f":"'Risks & Issues'!O3","v":"Closed?"},null,"Score","Sort Order",null,null,"IDs",{"$f":"C56","v":"Description"},{"$f":"D56","v":"Assigned to"},"Criticality","Due date"]
[1,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A57)","v":24},{"$f":"INDEX(tblIssues[Description],$B57)","v":"Some simple issue"},{"$f":"INDEX(tblIssues[Assigned to],$B57)","v":"Person Name14"},{"$f":"INDEX(tblIssues[Criticality],$B57)","v":1},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B57),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B57)","v":""},null,{"$f":"(G57<>\"Yes\")*(E57)*($F$52-MAX(F57,$F$53))+(0.000001)*B57","v":1.000024},{"$f":"RANK(I57,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":1},null,null,{"$f":"INDEX($B$57:$B$76,MATCH($A57,$J$57:$J$76,0))","v":24},{"$f":"IFERROR(INDEX(tblIssues[Description],$M57),\"\")","v":"Some simple issue"},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M57),\"\")","v":"Person Name14"},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M57),\"\")","v":1},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M57),\"\")","v":""}]
[2,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A58)","v":0},{"$f":"INDEX(tblIssues[Description],$B58)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B58)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B58)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B58),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B58)","v":{"$error":"#VALUE!"}},null,{"$f":"(G58<>\"Yes\")*(E58)*($F$52-MAX(F58,$F$53))+(0.000001)*B58","v":{"$error":"#VALUE!"}},{"$f":"RANK(I58,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX($B$57:$B$76,MATCH($A58,$J$57:$J$76,0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX(tblIssues[Description],$M58),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M58),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M58),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M58),\"\")","v":""}]
[3,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A59)","v":0},{"$f":"INDEX(tblIssues[Description],$B59)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B59)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B59)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B59),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B59)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I59,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M59),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M59),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M59),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M59),\"\")","v":""}]
[4,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A60)","v":0},{"$f":"INDEX(tblIssues[Description],$B60)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B60)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B60)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B60),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B60)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I60,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M60),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M60),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M60),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M60),\"\")","v":""}]
[5,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A61)","v":0},{"$f":"INDEX(tblIssues[Description],$B61)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B61)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B61)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B61),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B61)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I61,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M61),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M61),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M61),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M61),\"\")","v":""}]
[6,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A62)","v":0},{"$f":"INDEX(tblIssues[Description],$B62)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B62)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B62)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B62),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B62)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I62,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M62),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M62),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M62),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M62),\"\")","v":""}]
[7,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A63)","v":0},{"$f":"INDEX(tblIssues[Description],$B63)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B63)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B63)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B63),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B63)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I63,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M63),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M63),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M63),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M63),\"\")","v":""}]
[8,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A64)","v":0},{"$f":"INDEX(tblIssues[Description],$B64)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B64)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B64)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B64),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B64)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I64,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M64),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M64),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M64),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M64),\"\")","v":""}]
[9,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A65)","v":0},{"$f":"INDEX(tblIssues[Description],$B65)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B65)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B65)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B65),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B65)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I65,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M65),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M65),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M65),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M65),\"\")","v":""}]
[10,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A66)","v":0},{"$f":"INDEX(tblIssues[Description],$B66)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B66)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B66)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B66),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B66)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I66,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M66),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M66),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M66),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M66),\"\")","v":""}]
[11,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A67)","v":0},{"$f":"INDEX(tblIssues[Description],$B67)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B67)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B67)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B67),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B67)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I67,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M67),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M67),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M67),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M67),\"\")","v":""}]
[12,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A68)","v":0},{"$f":"INDEX(tblIssues[Description],$B68)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B68)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B68)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B68),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B68)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I68,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M68),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M68),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M68),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M68),\"\")","v":""}]
[13,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A69)","v":0},{"$f":"INDEX(tblIssues[Description],$B69)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B69)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B69)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B69),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B69)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I69,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M69),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M69),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M69),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M69),\"\")","v":""}]
[14,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A70)","v":0},{"$f":"INDEX(tblIssues[Description],$B70)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B70)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B70)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B70),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B70)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I70,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M70),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M70),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M70),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M70),\"\")","v":""}]
[15,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A71)","v":0},{"$f":"INDEX(tblIssues[Description],$B71)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B71)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B71)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B71),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B71)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I71,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M71),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M71),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M71),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M71),\"\")","v":""}]
[16,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A72)","v":0},{"$f":"INDEX(tblIssues[Description],$B72)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B72)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B72)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B72),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B72)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I72,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M72),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M72),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M72),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M72),\"\")","v":""}]
[17,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A73)","v":0},{"$f":"INDEX(tblIssues[Description],$B73)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B73)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B73)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B73),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B73)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I73,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M73),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M73),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M73),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M73),\"\")","v":""}]
[18,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A74)","v":0},{"$f":"INDEX(tblIssues[Description],$B74)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B74)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B74)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B74),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B74)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I74,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M74),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M74),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M74),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M74),\"\")","v":""}]
[19,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A75)","v":0},{"$f":"INDEX(tblIssues[Description],$B75)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B75)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B75)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B75),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B75)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I75,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M75),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M75),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M75),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M75),\"\")","v":""}]
[20,{"$f":"LARGE((tblIssues[ID])*(tblIssues[In Project]=$C$53),$A76)","v":0},{"$f":"INDEX(tblIssues[Description],$B76)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Assigned to],$B76)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblIssues[Criticality],$B76)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX(tblIssues[Due date],$B76),\"\")","v":""},{"$f":"INDEX(tblIssues[Closed?],$B76)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(I76,$I$57:INDEX($I$57:$I$76,$I$53),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"IFERROR(INDEX(tblIssues[Description],$M76),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Assigned to],$M76),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Criticality],$M76),\"\")","v":""},{"$f":"IFERROR(INDEX(tblIssues[Due date],$M76),\"\")","v":""}]
[]
[null,"Top 5 issues",25]
[null,{"$f":"TEXT(Q57,\"\"\"[\"\"dd-mmm-yyyy\"\"]\"\";;;\")","v":""},{"$f":"LEFT(N57,$C$78)&REPT(\"…\",LEN(N57)>$C$78)","v":"Some simple issue"}]
[null,{"$f":"TEXT(Q58,\"\"\"[\"\"dd-mmm-yyyy\"\"]\"\";;;\")","v":""},{"$f":"LEFT(N58,$C$78)&REPT(\"…\",LEN(N58)>$C$78)","v":""}]
[null,"",""]
[null,"",""]
[null,"",""]
[]
[null,{"$f":"B79&CHAR(10)&B80&CHAR(10)&B81&CHAR(10)&B82&CHAR(10)&B83","v":"\n\n\n\n"},{"$f":"C79&CHAR(10)&C80&CHAR(10)&C81&CHAR(10)&C82&CHAR(10)&C83","v":"Some simple issue\n\n\n\n"}]
[]
["Risks for selected Project",null,null,null,null,null,{"$f":"COUNTIF($B$90:$B$109,\">0\")","v":5}]
[null,null,null,null,null,null,"Sort by severity & ID",null,null,null,"Sorted"]
[null,"ID",{"$f":"'Risks & Issues'!D3","v":"Risk Description"},{"$f":"'Risks & Issues'!E3","v":"Mitigation Plan"},{"$f":"'Risks & Issues'!F3","v":"Severity"},null,"Score","Sort Order",null,null,{"$f":"B89","v":"ID"},"Risk Description","Mitigation Plan","Severity"]
[1,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A90)","v":19},{"$f":"INDEX(tblRisks[Risk Description],$B90)","v":"Some very complicated risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$B90)","v":""},{"$f":"INDEX(tblRisks[Severity],$B90)","v":3},null,{"$f":"E90+B90/10000","v":3.0019},{"$f":"RANK(G90,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":2},null,null,{"$f":"INDEX($B$90:$B$109,MATCH($A90,$H$90:$H$109,0))","v":4},{"$f":"INDEX(tblRisks[Risk Description],$K90)","v":"Some very simple risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$K90)","v":""},{"$f":"INDEX(tblRisks[Severity],$K90)","v":5}]
[2,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A91)","v":17},{"$f":"INDEX(tblRisks[Risk Description],$B91)","v":"Some complicated risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$B91)","v":""},{"$f":"INDEX(tblRisks[Severity],$B91)","v":2},null,{"$f":"E91+B91/10000","v":2.0017},{"$f":"RANK(G91,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":4},null,null,{"$f":"INDEX($B$90:$B$109,MATCH($A91,$H$90:$H$109,0))","v":19},{"$f":"INDEX(tblRisks[Risk Description],$K91)","v":"Some very complicated risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$K91)","v":""},{"$f":"INDEX(tblRisks[Severity],$K91)","v":3}]
[3,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A92)","v":13},{"$f":"INDEX(tblRisks[Risk Description],$B92)","v":"Some very simple risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$B92)","v":""},{"$f":"INDEX(tblRisks[Severity],$B92)","v":2},null,2.0013000000000001,{"$f":"RANK(G92,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":5},null,null,6,{"$f":"INDEX(tblRisks[Risk Description],$K92)","v":"Some very simple risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$K92)","v":"Our plan"},{"$f":"INDEX(tblRisks[Severity],$K92)","v":3}]
[4,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A93)","v":6},{"$f":"INDEX(tblRisks[Risk Description],$B93)","v":"Some very simple risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$B93)","v":"Our plan"},{"$f":"INDEX(tblRisks[Severity],$B93)","v":3},null,3.0005999999999999,{"$f":"RANK(G93,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":3},null,null,17,{"$f":"INDEX(tblRisks[Risk Description],$K93)","v":"Some complicated risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$K93)","v":""},{"$f":"INDEX(tblRisks[Severity],$K93)","v":2}]
[5,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A94)","v":4},{"$f":"INDEX(tblRisks[Risk Description],$B94)","v":"Some very simple risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$B94)","v":""},{"$f":"INDEX(tblRisks[Severity],$B94)","v":5},null,5.0004,{"$f":"RANK(G94,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":1},null,null,13,{"$f":"INDEX(tblRisks[Risk Description],$K94)","v":"Some very simple risk"},{"$f":"INDEX(tblRisks[Mitigation Plan],$K94)","v":""},{"$f":"INDEX(tblRisks[Severity],$K94)","v":2}]
[6,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A95)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B95)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B95)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B95)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G95,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K95)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K95)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K95)","v":{"$error":"#N/A"}}]
[7,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A96)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B96)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B96)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B96)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G96,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K96)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K96)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K96)","v":{"$error":"#N/A"}}]
[8,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A97)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B97)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B97)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B97)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G97,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K97)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K97)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K97)","v":{"$error":"#N/A"}}]
[9,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A98)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B98)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B98)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B98)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G98,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K98)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K98)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K98)","v":{"$error":"#N/A"}}]
[10,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A99)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B99)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B99)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B99)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G99,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K99)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K99)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K99)","v":{"$error":"#N/A"}}]
[11,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A100)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B100)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B100)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B100)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G100,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K100)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K100)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K100)","v":{"$error":"#N/A"}}]
[12,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A101)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B101)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B101)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B101)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G101,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K101)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K101)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K101)","v":{"$error":"#N/A"}}]
[13,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A102)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B102)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B102)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B102)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G102,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K102)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K102)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K102)","v":{"$error":"#N/A"}}]
[14,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A103)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B103)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B103)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B103)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G103,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K103)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K103)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K103)","v":{"$error":"#N/A"}}]
[15,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A104)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B104)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B104)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B104)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G104,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K104)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K104)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K104)","v":{"$error":"#N/A"}}]
[16,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A105)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B105)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B105)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B105)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G105,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K105)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K105)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K105)","v":{"$error":"#N/A"}}]
[17,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A106)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B106)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B106)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B106)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G106,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K106)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K106)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K106)","v":{"$error":"#N/A"}}]
[18,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A107)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B107)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B107)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B107)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G107,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K107)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K107)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K107)","v":{"$error":"#N/A"}}]
[19,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A108)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B108)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B108)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B108)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G108,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K108)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K108)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K108)","v":{"$error":"#N/A"}}]
[20,{"$f":"LARGE((tblRisks[ID])*(tblRisks[In Project]=$C$53),$A109)","v":0},{"$f":"INDEX(tblRisks[Risk Description],$B109)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$B109)","v":{"$error":"#VALUE!"}},{"$f":"INDEX(tblRisks[Severity],$B109)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},{"$f":"RANK(G109,$G$90:INDEX($G$90:$G$109,$G$87),0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#N/A"},{"$f":"INDEX(tblRisks[Risk Description],$K109)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Mitigation Plan],$K109)","v":{"$error":"#N/A"}},{"$f":"INDEX(tblRisks[Severity],$K109)","v":{"$error":"#N/A"}}]
[]
[null,25,"~"]
[null,"Top Risks","Severity"]
[null,{"$f":"IFERROR(LEFT(L90,$B$111)&REPT(\"…\",LEN(L90)>$B$111),\"\")","v":"Some very simple risk"},{"$f":"IFERROR(REPT($C$111,N90),\"\")","v":"~~~~~"}]
[null,{"$f":"IFERROR(LEFT(L91,$B$111)&REPT(\"…\",LEN(L91)>$B$111),\"\")","v":"Some very complicated ris…"},{"$f":"IFERROR(REPT($C$111,N91),\"\")","v":"~~~"}]
[null,"Some very simple risk","~~~"]
[null,"Some complicated risk","~~"]
[null,"Some very simple risk","~~"]
[]
[null,{"$f":"B113&CHAR(10)&B114&CHAR(10)&B115&CHAR(10)&B116&CHAR(10)&B117","v":"Some very simple risk\nSome very complicated ris…\nSome very simple risk\nSome complicated risk\nSome very simple risk"},{"$f":"C113&CHAR(10)&C114&CHAR(10)&C115&CHAR(10)&C116&CHAR(10)&C117","v":"~~~~~\n~~~\n~~~\n~~\n~~"}]
[]
[]
["Tasks for the selected project"]
[null,{"$f":"B52","v":"ID"},8]
[null,"Name","HRM Rollout"]
[]
[null,"Total",{"$f":"COUNTA(INDEX(lstPlans,,1,$C$123))","v":40}]
[null,"Completed",{"$f":"COUNTIFS(INDEX(lstPlans,,4,$C$123),\"100%\")","v":0}]
[null,"In Progress",{"$f":"COUNTIFS(INDEX(lstPlans,,4,$C$123),\">0%\")-C127","v":22}]
[null,"Yet to start",{"$f":"COUNTIFS(INDEX(lstPlans,,4,$C$123),\"0%\")","v":18}]
[]
[null,{"$f":"B126&CHAR(10)&B127&CHAR(10)&B128&CHAR(10)&B129","v":"Total\nCompleted\nIn Progress\nYet to start"},{"$f":"C126&CHAR(10)&C127&CHAR(10)&C128&CHAR(10)&C129","v":"40\n0\n22\n18"}]
[]
["People in this project"]
[null,"Project Owner",{"$f":"INDEX(tblProjects[Project Owner],$C$123)","v":"Hart Hankenson"}]
[null,"Email",{"$f":"INDEX(tblProjects[Email],$C$123)","v":"hankensonh@project.com"}]
[null,"Phone",{"$f":"INDEX(tblProjects[Phone],$C$123)","v":"426-687-7283"}]
[null,"Team Size",{"$f":"\"Team size: \"&INDEX(tblProjects[Team Size],$C$123)","v":"Team size: 20"}]
[]
["Comments"]
[null,null,{"$f":"INDEX(tblProjects[Comments],$C$123)","v":"We need to be clam on this project. It is going to be different success."}]
[]
[]
[]
["People Distribution"]
[null,"Min",{"$f":"MIN(tblProjects[Team Size])","v":15}]
[null,"Max",{"$f":"MAX(tblProjects[Team Size])","v":35}]
[null,"Range",{"$f":"C146-C145","v":20}]
[]
[null,"Band","Start","Label","Count"]
[null,1,{"$f":"$C$145","v":15},{"$f":"\"<=\"&C150","v":"<=15"},{"$f":"COUNTIF(tblProjects[Team Size],\"<=\"&C150)","v":1}]
[null,2,{"$f":"C150+$C$147/5","v":19},{"$f":"C151","v":19},{"$f":"COUNTIF(tblProjects[Team Size],\"<=\"&C151)-SUM($E$150:E150)","v":0}]
[null,3,{"$f":"C151+$C$147/5","v":23},{"$f":"C152","v":23},{"$f":"COUNTIF(tblProjects[Team Size],\"<=\"&C152)-SUM($E$150:E151)","v":2}]
[null,4,27,27,{"$f":"COUNTIF(tblProjects[Team Size],\"<=\"&C153)-SUM($E$150:E152)","v":0}]
[null,5,31,31,{"$f":"COUNTIF(tblProjects[Team Size],\"<=\"&C154)-SUM($E$150:E153)","v":1}]
[null,6,35,{"$f":"C155","v":35},{"$f":"COUNTIF(tblProjects[Team Size],\"<=\"&C155)-SUM($E$150:E154)","v":4}]
[]
["Footer"]
[null,{"$f":"\"Prepared by \"&Settings!$I$5&\" on \"&TEXT(Settings!$I$7,\"d, mmm yyyy\")","v":"Prepared by John Doe on 19, Nov 2012"}]
[null,{"$f":"HYPERLINK(\"mailto:\"&Settings!$I$6,\"@\")","v":"@"}]
[]
["DB Sheet name"]
[null,{"$f":"CELL(\"address\",Dashboard!A1)","v":"'[project-portfolio-dashboard-VBA-v1-2010-trial.xlsm]Dashboard'!$A$1"}]
[null,{"$f":"MID(B162,FIND(\"]\",B162)+1,999)","v":"Dashboard'!$A$1"}]
[null,{"$f":"LEFT(B163,FIND(\"'\",B163)-1)","v":"Dashboard"}]

{"sheet":"Gantt View","index":8,"n_rows":29,"n_cols":178,"rows_kept":29,"cut":false,"hidden":true,"merged":[[8,57,8,61],[9,72,9,76],[9,37,9,41],[8,92,8,96],[8,62,8,66],[8,67,8,71],[8,72,8,76],[8,77,8,81],[8,82,8,86],[8,87,8,91],[9,92,9,96],[8,32,8,36],[8,37,8,41],[8,42,8,46],[8,47,8,51],[8,52,8,56],[9,7,9,11],[9,77,9,81],[9,82,9,86],[9,12,9,16],[9,87,9,91],[9,17,9,21],[9,22,9,26],[9,27,9,31],[9,32,9,36],[9,42,9,46],[9,47,9,51],[9,52,9,56],[9,57,9,61],[9,62,9,66],[9,67,9,71],[8,7,8,11],[8,12,8,16],[8,17,8,21],[8,22,8,26],[8,27,8,31]]}
[null,"Gantt Views Please do not edit"]
[null,"Project Name",{"$f":"Calculations!C23","v":"HRM Rollout"}]
[null,"Project ID",{"$f":"Calculations!C22","v":8}]
[null,"Project Table Name",{"$f":"Calculations!C24","v":"plan8"}]
[null,null,null,null,null,null,"Dates ->",{"$f":"valGanttStart","v":40777},{"$f":"WORKDAY(H5,1)","v":40778},{"$f":"WORKDAY(I5,1)","v":40779},40780,40781,40784,40785,40786,40787,40788,40791,40792,40793,40794,40795,40798,40799,40800,40801,40802,40805,40806,40807,40808,40809,40812,40813,40814,40815,40816,40819,40820,40821,40822,40823,40826,40827,40828,40829,40830,40833,40834,40835,40836,40837,40840,40841,40842,40843,40844,40847,40848,40849,40850,40851,40854,40855,40856,40857,40858,40861,40862,40863,40864,40865,40868,{"$f":"WORKDAY(BU5,1)","v":40869},40870,40871,40872,40875,40876,40877,40878,40879,40882,40883,40884,40885,40886,40889,40890,40891,40892,40893,40896,40897,40898,40899,{"$f":"WORKDAY(CR5,1)","v":40900},{"$f":"WORKDAY(CS5,1)","v":40903},null,null,null,null,null,null,null,null,null,{"$f":"valGanttStart","v":"2011-08-22"},{"$f":"DD5+7","v":"2011-08-29"},{"$f":"DE5+7","v":"2011-09-05"},"2011-09-12","2011-09-19","2011-09-26","2011-10-03","2011-10-10","2011-10-17","2011-10-24","2011-10-31","2011-11-07","2011-11-14","2011-11-21","2011-11-28","2011-12-05","2011-12-12","2011-12-19","2011-12-26","2012-01-02","2012-01-09","2012-01-16","2012-01-23","2012-01-30","2012-02-06","2012-02-13","2012-02-20","2012-02-27","2012-03-05","2012-03-12","2012-03-19",null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(valGanttStart),MONTH(valGanttStart),1)","v":"2011-08-01"},{"$f":"EDATE(ES5,1)","v":40787},{"$f":"EDATE(ET5,1)","v":40817},40848,40878,40909,40940,40969,41000,41030,41061,41091,41122,41153,41183,41214,41244,41275,41306,41334,41365,41395,41426,41456,41487,41518,41548,41579,41609,41640]
[null,"View in",1,"Days",{"$f":"INDEX(lstGanttViews,valGanttType)&\" view\"","v":"Daily view"},null,{"$f":"C6","v":1}]
[null,"Daily View"]
[]
[null,null,null,null,null,null,null,{"$f":"IFERROR(H5,\"\")","v":"2011-08-22"},{"$f":"I10","v":"00:00:00"},"00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(M5)<>MONTH(H5),M5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(R5)<>MONTH(M5),R5,\"\"),\"\")","v":"2011-09-05"},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(W5)<>MONTH(R5),W5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(AB5)<>MONTH(W5),AB5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(AG5)<>MONTH(AB5),AG5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(AL5)<>MONTH(AG5),AL5,\"\"),\"\")","v":"2011-10-03"},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(AQ5)<>MONTH(AL5),AQ5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(AV5)<>MONTH(AQ5),AV5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(BA5)<>MONTH(AV5),BA5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(BF5)<>MONTH(BA5),BF5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(BK5)<>MONTH(BF5),BK5,\"\"),\"\")","v":"2011-11-07"},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(BP5)<>MONTH(BK5),BP5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(BU5)<>MONTH(BP5),BU5,\"\"),\"\")","v":""},{"$f":"BV10","v":"00:00:00"},"00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(BZ5)<>MONTH(BU5),BZ5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(CE5)<>MONTH(BZ5),CE5,\"\"),\"\")","v":"2011-12-05"},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(CJ5)<>MONTH(CE5),CJ5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IFERROR(IF(MONTH(CO5)<>MONTH(CJ5),CO5,\"\"),\"\")","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",null,"Weekly View",null,null,null,null,null,null,null,null,{"$f":"IFERROR(TEXT(DD10,\"mmmmm'yy\"),\"\")","v":"A'11"},{"$f":"IFERROR(IF(MONTH(DE10)<>MONTH(DD10),TEXT(DE10,\"mmm\"),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(DF10)<>MONTH(DE10),TEXT(DF10,\"mmm\"),\"\"),\"\")","v":"Sep"},"","","","Oct","","","","","Nov","","","","Dec","","","","Jan","","","","","Feb","","","","Mar","",null,null,"Monthly View",null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR(ES5),\"\")","v":2011},{"$f":"IFERROR(IF(YEAR(ET5)=YEAR(ES5),\"\",YEAR(ET5)),\"\")","v":""},{"$f":"IFERROR(IF(YEAR(EU5)=YEAR(ET5),\"\",YEAR(EU5)),\"\")","v":""},"","",2012,"","","","","","","","","","","",2013,"","","","","","","","","","","",2014]
[null,{"$f":"Calculations!D28","v":"Activity"},{"$f":"Calculations!F28","v":"Duration"},{"$f":"Calculations!G28","v":"% done"},"% Budget","Start","End",{"$f":"IFERROR(H5,\"\")","v":"2011-08-22"},null,null,null,null,{"$f":"IFERROR(M5,\"\")","v":"2011-08-29"},null,null,null,null,{"$f":"IFERROR(R5,\"\")","v":"2011-09-05"},null,null,null,null,{"$f":"IFERROR(W5,\"\")","v":"2011-09-12"},null,null,null,null,{"$f":"IFERROR(AB5,\"\")","v":"2011-09-19"},null,null,null,null,{"$f":"IFERROR(AG5,\"\")","v":"2011-09-26"},null,null,null,null,{"$f":"IFERROR(AL5,\"\")","v":"2011-10-03"},null,null,null,null,{"$f":"IFERROR(AQ5,\"\")","v":"2011-10-10"},null,null,null,null,{"$f":"IFERROR(AV5,\"\")","v":"2011-10-17"},null,null,null,null,{"$f":"IFERROR(BA5,\"\")","v":"2011-10-24"},null,null,null,null,{"$f":"IFERROR(BF5,\"\")","v":"2011-10-31"},null,null,null,null,{"$f":"IFERROR(BK5,\"\")","v":"2011-11-07"},null,null,null,null,{"$f":"IFERROR(BP5,\"\")","v":"2011-11-14"},null,null,null,null,{"$f":"IFERROR(BU5,\"\")","v":"2011-11-21"},null,null,null,null,{"$f":"IFERROR(BZ5,\"\")","v":"2011-11-28"},null,null,null,null,{"$f":"IFERROR(CE5,\"\")","v":"2011-12-05"},null,null,null,null,{"$f":"IFERROR(CJ5,\"\")","v":"2011-12-12"},null,null,null,null,{"$f":"IFERROR(CO5,\"\")","v":"2011-12-19"},null,null,null,null,{"$f":"CT5","v":40903},"Start","Completion",null,{"$f":"B10","v":"Activity"},{"$f":"C10","v":"Duration"},{"$f":"D10","v":"% done"},{"$f":"E10","v":"% Budget"},{"$f":"F10","v":"Start"},"End",{"$f":"IFERROR(DD5,\"\")","v":"2011-08-22"},{"$f":"IFERROR(DE5,\"\")","v":"2011-08-29"},"2011-09-05","2011-09-12","2011-09-19","2011-09-26","2011-10-03","2011-10-10","2011-10-17","2011-10-24","2011-10-31","2011-11-07","2011-11-14","2011-11-21","2011-11-28","2011-12-05","2011-12-12","2011-12-19","2011-12-26","2012-01-02","2012-01-09","2012-01-16","2012-01-23","2012-01-30","2012-02-06","2012-02-13","2012-02-20","2012-02-27","2012-03-05","2012-03-12",null,null,{"$f":"CU10","v":"Start"},{"$f":"CV10","v":"Completion"},null,{"$f":"CX10","v":"Activity"},{"$f":"CY10","v":"Duration"},{"$f":"CZ10","v":"% done"},{"$f":"DA10","v":"% Budget"},{"$f":"DB10","v":"Start"},{"$f":"DC10","v":"End"},{"$f":"IFERROR(ES5,\"\")","v":"2011-08-01"},{"$f":"IFERROR(ET5,\"\")","v":"2011-09-01"},"2011-10-01","2011-11-01","2011-12-01","2012-01-01","2012-02-01","2012-03-01","2012-04-01","2012-05-01","2012-06-01","2012-07-01","2012-08-01","2012-09-01","2012-10-01","2012-11-01","2012-12-01","2013-01-01","2013-02-01","2013-03-01","2013-04-01","2013-05-01","2013-06-01","2013-07-01","2013-08-01","2013-09-01","2013-10-01","2013-11-01","2013-12-01","2014-01-01"]
[null,{"$f":"Calculations!D29","v":"Activity 1"},{"$f":"Calculations!F29","v":21},{"$f":"Calculations!G29","v":0.83},{"$f":"IFERROR(Calculations!I29/Calculations!H29,\"\")","v":0.29099999999999998},{"$f":"Calculations!E29","v":"2011-08-27"},{"$f":"WORKDAY(F11,C11,lstHolidays)","v":"2011-09-26"},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,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,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,null,{"$f":"F11-CHOOSE(WEEKDAY(F11),6,0,1,2,3,4,5)","v":"2011-08-22"},{"$f":"G11+CHOOSE(WEEKDAY(G11),1,0,6,5,4,3,2)","v":"2011-09-26"},null,"Activity 1",21,0.83,0.29099999999999998,"2011-08-27",{"$f":"G11","v":"2011-09-26"},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,null,null,{"$f":"DATE(YEAR(F11),MONTH(F11),1)","v":"2011-08-01"},{"$f":"DATE(YEAR(G11),MONTH(G11),1)","v":"2011-09-01"},null,"Activity 1",21,0.83,0.29099999999999998,"2011-08-27","2011-09-26"]
[null,{"$f":"Calculations!D30","v":"Activity 2"},{"$f":"Calculations!F30","v":7},{"$f":"Calculations!G30","v":0},{"$f":"IFERROR(Calculations!I30/Calculations!H30,\"\")","v":0},{"$f":"Calculations!E30","v":"2011-09-14"},"2011-09-23",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,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,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,null,"2011-09-12","2011-09-26",null,"Activity 2",7,0,0,"2011-09-14","2011-09-23",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,null,null,"2011-09-01","2011-09-01",null,"Activity 2",7,0,0,"2011-09-14","2011-09-23"]
[null,{"$f":"Calculations!D31","v":"Activity 3"},{"$f":"Calculations!F31","v":14},{"$f":"Calculations!G31","v":0},{"$f":"IFERROR(Calculations!I31/Calculations!H31,\"\")","v":0},{"$f":"Calculations!E31","v":"2011-09-23"},"2011-10-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,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,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,null,"2011-09-19","2011-10-17",null,"Activity 3",14,0,0,"2011-09-23","2011-10-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,null,null,"2011-09-01","2011-10-01",null,"Activity 3",14,0,0,"2011-09-23","2011-10-13"]
[null,{"$f":"Calculations!D32","v":"Activity 4"},{"$f":"Calculations!F32","v":7},{"$f":"Calculations!G32","v":0},{"$f":"IFERROR(Calculations!I32/Calculations!H32,\"\")","v":0},{"$f":"Calculations!E32","v":"2011-10-06"},"2011-10-17",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,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,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,null,"2011-10-03","2011-10-17",null,"Activity 4",7,0,0,"2011-10-06","2011-10-17",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,null,null,"2011-10-01","2011-10-01",null,"Activity 4",7,0,0,"2011-10-06","2011-10-17"]
[null,{"$f":"Calculations!D33","v":"Activity 5"},{"$f":"Calculations!F33","v":7},{"$f":"Calculations!G33","v":0.41},{"$f":"IFERROR(Calculations!I33/Calculations!H33,\"\")","v":0.109},{"$f":"Calculations!E33","v":"2011-10-18"},"2011-10-27",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,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,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,null,"2011-10-17","2011-10-31",null,"Activity 5",7,0.41,0.109,"2011-10-18","2011-10-27",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,null,null,"2011-10-01","2011-10-01",null,"Activity 5",7,0.41,0.109,"2011-10-18","2011-10-27"]
[null,{"$f":"Calculations!D34","v":"Activity 6"},{"$f":"Calculations!F34","v":14},{"$f":"Calculations!G34","v":0.53},{"$f":"IFERROR(Calculations!I34/Calculations!H34,\"\")","v":5.1799999999999999E-2},{"$f":"Calculations!E34","v":"2011-10-28"},"2011-11-17",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,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,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,null,"2011-10-24","2011-11-21",null,"Activity 6",14,0.53,5.1799999999999999E-2,"2011-10-28","2011-11-17",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,null,null,"2011-10-01","2011-11-01",null,"Activity 6",14,0.53,5.1799999999999999E-2,"2011-10-28","2011-11-17"]
[null,{"$f":"Calculations!D35","v":"Activity 7"},{"$f":"Calculations!F35","v":14},{"$f":"Calculations!G35","v":0.67},{"$f":"IFERROR(Calculations!I35/Calculations!H35,\"\")","v":0.69499999999999995},{"$f":"Calculations!E35","v":"2011-11-14"},"2011-12-02",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,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,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,null,"2011-11-14","2011-12-05",null,"Activity 7",14,0.67,0.69499999999999995,"2011-11-14","2011-12-02",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,null,null,"2011-11-01","2011-12-01",null,"Activity 7",14,0.67,0.69499999999999995,"2011-11-14","2011-12-02"]
[null,{"$f":"Calculations!D36","v":"Activity 8"},{"$f":"Calculations!F36","v":14},{"$f":"Calculations!G36","v":0},{"$f":"IFERROR(Calculations!I36/Calculations!H36,\"\")","v":0},{"$f":"Calculations!E36","v":"2011-12-02"},"2011-12-22",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,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,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,null,"2011-11-28","2011-12-26",null,"Activity 8",14,0,0,"2011-12-02","2011-12-22",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,null,null,"2011-12-01","2011-12-01",null,"Activity 8",14,0,0,"2011-12-02","2011-12-22"]
[null,{"$f":"Calculations!D37","v":"Activity 9"},{"$f":"Calculations!F37","v":7},{"$f":"Calculations!G37","v":0.14000000000000001},{"$f":"IFERROR(Calculations!I37/Calculations!H37,\"\")","v":0.1285},{"$f":"Calculations!E37","v":"2011-12-14"},"2011-12-23",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,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,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,null,"2011-12-12","2011-12-26",null,"Activity 9",7,0.14000000000000001,0.1285,"2011-12-14","2011-12-23",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,null,null,"2011-12-01","2011-12-01",null,"Activity 9",7,0.14000000000000001,0.1285,"2011-12-14","2011-12-23"]
[null,{"$f":"Calculations!D38","v":"Activity 10"},{"$f":"Calculations!F38","v":14},{"$f":"Calculations!G38","v":0.36},{"$f":"IFERROR(Calculations!I38/Calculations!H38,\"\")","v":0.20860000000000001},{"$f":"Calculations!E38","v":"2011-12-27"},"2012-01-16",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,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,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,null,"2011-12-26","2012-01-16",null,"Activity 10",14,0.36,0.20860000000000001,"2011-12-27","2012-01-16",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,null,null,"2011-12-01","2012-01-01",null,"Activity 10",14,0.36,0.20860000000000001,"2011-12-27","2012-01-16"]
[null,{"$f":"Calculations!D39","v":"Activity 11"},{"$f":"Calculations!F39","v":14},{"$f":"Calculations!G39","v":0},{"$f":"IFERROR(Calculations!I39/Calculations!H39,\"\")","v":0},{"$f":"Calculations!E39","v":"2012-01-09"},"2012-01-27",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,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,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,null,"2012-01-09","2012-01-30",null,"Activity 11",14,0,0,"2012-01-09","2012-01-27",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,null,null,"2012-01-01","2012-01-01",null,"Activity 11",14,0,0,"2012-01-09","2012-01-27"]
[null,{"$f":"Calculations!D40","v":"Activity 12"},{"$f":"Calculations!F40","v":14},{"$f":"Calculations!G40","v":0.34},{"$f":"IFERROR(Calculations!I40/Calculations!H40,\"\")","v":2.0333333333333332E-2},{"$f":"Calculations!E40","v":"2012-01-20"},"2012-02-09",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,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,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,null,"2012-01-16","2012-02-13",null,"Activity 12",14,0.34,2.0333333333333332E-2,"2012-01-20","2012-02-09",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,null,null,"2012-01-01","2012-02-01",null,"Activity 12",14,0.34,2.0333333333333332E-2,"2012-01-20","2012-02-09"]
[null,{"$f":"Calculations!D41","v":"Activity 13"},{"$f":"Calculations!F41","v":7},{"$f":"Calculations!G41","v":0},{"$f":"IFERROR(Calculations!I41/Calculations!H41,\"\")","v":0},{"$f":"Calculations!E41","v":"2012-02-08"},"2012-02-17",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,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,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,null,"2012-02-06","2012-02-20",null,"Activity 13",7,0,0,"2012-02-08","2012-02-17",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,null,null,"2012-02-01","2012-02-01",null,"Activity 13",7,0,0,"2012-02-08","2012-02-17"]
[null,{"$f":"Calculations!D42","v":"Activity 14"},{"$f":"Calculations!F42","v":21},{"$f":"Calculations!G42","v":0.36},{"$f":"IFERROR(Calculations!I42/Calculations!H42,\"\")","v":0.17960000000000001},{"$f":"Calculations!E42","v":"2012-02-27"},"2012-03-27",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,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,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,null,"2012-02-27","2012-04-02",null,"Activity 14",21,0.36,0.17960000000000001,"2012-02-27","2012-03-27",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,null,null,"2012-02-01","2012-03-01",null,"Activity 14",21,0.36,0.17960000000000001,"2012-02-27","2012-03-27"]
[null,{"$f":"Calculations!D43","v":"Activity 15"},{"$f":"Calculations!F43","v":14},{"$f":"Calculations!G43","v":0},{"$f":"IFERROR(Calculations!I43/Calculations!H43,\"\")","v":0},{"$f":"Calculations!E43","v":"2012-03-09"},"2012-03-29",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,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,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,null,"2012-03-05","2012-04-02",null,"Activity 15",14,0,0,"2012-03-09","2012-03-29",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,null,null,"2012-03-01","2012-03-01",null,"Activity 15",14,0,0,"2012-03-09","2012-03-29"]
[null,{"$f":"Calculations!D44","v":"Activity 16"},{"$f":"Calculations!F44","v":21},{"$f":"Calculations!G44","v":0},{"$f":"IFERROR(Calculations!I44/Calculations!H44,\"\")","v":0},{"$f":"Calculations!E44","v":"2012-03-20"},"2012-04-18",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,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,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,null,"2012-03-19","2012-04-23",null,"Activity 16",21,0,0,"2012-03-20","2012-04-18",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,null,null,"2012-03-01","2012-04-01",null,"Activity 16",21,0,0,"2012-03-20","2012-04-18"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"valGanttStart","v":40777},{"$f":"H29+7","v":40784},{"$f":"I29+7","v":40791},40798,40805,40812,40819,40826,40833,40840,40847,40854,40861,40868,40875,40882,40889,40896,40903,40910,40917,40924,40931,40938,40945,40952,40959,40966,40973,40980,40987,40994,41001,41008,41015,41022,41029,41036,41043,41050,41057,41064,41071,41078,41085,41092,41099,41106,41113,41120,41127,41134,41141,41148,41155,41162,41169,41176,41183,41190,41197,41204,41211,41218,41225,41232,{"$f":"BU29+7","v":41239},41246,41253,41260,41267,41274,41281,41288,41295,41302,41309,41316,41323,41330,41337,41344,41351,41358,41365,41372,41379,41386,41393,41400]

{"sheet":"Help","index":9,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[33,3,43,3],[1,1,1,3],[5,3,14,3],[19,3,28,3]]}
[]
[null,"Watch these help videos to get started. You need internet connection to watch them."]
[]
[null,"1. Setting up Project Portfolio Dashboard"]
[]
[null,null,null,"Learn how to set up the project portfolio dashboard. Understand how to use it, how to add data, settings, holidays and more.\n\nVideo - 16 mins"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Using the Project Portfolio Dashboard"]
[]
[null,null,null,"Learn how to use the dashboard, how various aspects of it work and how to customize it.\n\nVideo - 11 mins"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Saving & Printing the dashboard"]
[]
[null,null,null,"Understand how to save & print the dashboard. How to export it as a PDF and more.\n\nVideo - 6 mins"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"More tutorials online"]