{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Details","Project Plan","Projects Summary","Data Sheet","Advanced Project Plan Template"],"not_rendered":{"charts":2,"images":3,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Details","index":0,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[[22,1,22,7],[0,1,0,8],[1,1,1,8],[23,1,23,7],[23,8,23,10],[3,1,4,1],[7,1,9,1],[7,2,9,11],[11,5,19,11],[11,2,19,4],[11,1,19,1],[3,2,4,6],[3,7,4,11]]}
[null,"ANALYSISTAB MULTIPLE PROJECTS - GANTT TEMPLATE"]
[null,"Works on Excel 2007 and Above"]
[]
[null,"Info","Project Plan and Gant Chart Template helps you to plan a project timelines and resource. You can change the default data and formula to meet your needs.  ",null,null,null,null,"Please Note: We have protected the worksheets to avoid the mistakes by chance. You can use the password 'PNRao' to unprotect the Worksheets"]
[]
[]
[]
[null,"Usage","We start plannign our projects after initial meetings and agreement. We plan our resource and timelines based on the requirements, deliverables and avaialble team and bandwidth. Project plan template helps to track all the tasks and its progress and status of each task. You can daily update the templates and share with your teams and customer/stakeholders to update the project status and progress. This is the must have tool for every project."]
[]
[]
[]
[null,"Please\nShare","Project Tracking/ Project Plan / Gant. Chart Template is a Free and lite version of ANALYSISTABS' Project Management Templates. \n\nPlease feel free to use, modify and share with your coleagues.",null,null,"Please check our Premium Templates Bundle, all you need for effective project planning, management and presentations. Our premium templates are professional, powerfull, easy to customize and unique in style.  Please visit analysistabs.com and grab our powerfull templates for nominal cost."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please Let us know your feedback",null,null,null,null,null,null,"info@analysistabs.com"]
[null,"Templates By ANALYSISTABS.For more templates and tools, please visit us:",null,null,null,null,null,null,"htps://analysistabs.com"]

{"sheet":"Project Plan","index":1,"n_rows":29,"n_cols":34,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,2,3,3],[4,2,4,3],[5,2,5,3],[7,2,7,3],[8,2,8,3],[0,2,0,6],[28,2,30,7],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[27,2,27,3],[27,5,27,6],[11,2,11,3],[10,2,10,3],[15,2,15,3],[1,3,1,5],[9,2,9,3]]}
[null,null,"Please Select a Project to View Related Tasks & Gantt.",null,null,null,null,4,null,null,"PJ04750 Talent Review Tool",{"$f":"VLOOKUP(K1,'Projects Summary'!B3:C14,2,FALSE) &\" Tasks Found\"","v":"87 Tasks Found"},null,null,null,null,null,null,null,"Date Interval:",7,"Day(s)"]
[null,null,null,"Project Plan",null,null,null,"Tasks Scrool","Task ID","WBS#","TaskS","Responsible","Start Date","End Date","Days Req.","Status","Days Comp.","Project",{"$f":"E8","v":"2019-12-12"},{"$f":"S2+$U$1","v":"2019-12-19"},{"$f":"T2+$U$1","v":"2019-12-26"},"2020-01-02","2020-01-09","2020-01-16","2020-01-23","2020-01-30","2020-02-06","2020-02-13","2020-02-20","2020-02-27","2020-03-05","2020-03-12","2020-03-19","2020-03-26"]
[null,null,null,null,null,null,null,100,{"$f":"IFERROR(IF(K1='Projects Summary'!B3,0,MATCH(K1,'Data Sheet'!A:A,0)-2)+H3,D18)","v":137},-1,0,1,2,4,3,5,null,-2]
[null,null,"Project Name",null,{"$f":"VLOOKUP('Project Plan'!K1,'Projects Summary'!B2:J14,1,FALSE)","v":"PJ04750 Talent Review Tool"},null,null,null,{"$f":"I3+1","v":138},{"$f":"IF(K4=0,\"\",INDEX(Table1[],I4,2))","v":9},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I4,2))-LEN(SUBSTITUTE(INDEX(Table1[],I4,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I4,'Project Plan'!K$3)","v":"Integrations"},{"$f":"IF(K4=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I4,'Project Plan'!L$3))","v":"ITSPS"},{"$f":"IF(K4=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I4,'Project Plan'!M$3))","v":"2020-04-01"},{"$f":"IF(K4=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I4,'Project Plan'!O$3))","v":"2020-05-14"},{"$f":"IF(K4=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I4,'Project Plan'!N$3))","v":0},{"$f":"IF(K4=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I4,'Project Plan'!P$3))","v":0},{"$f":"IF(K4=0,\"\",O4*P4)","v":0},{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I4,'Project Plan'!R$3)","v":"Mobility Preference"}]
[null,null,"Customer Name",null,{"$f":"VLOOKUP('Project Plan'!K1,'Projects Summary'!B2:J14,8,FALSE)","v":"HRDCM - Careers and Mobility"},null,null,null,{"$f":"I4+1","v":139},{"$f":"IF(K5=0,\"\",INDEX(Table1[],I5,2))","v":9.1},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I5,2))-LEN(SUBSTITUTE(INDEX(Table1[],I5,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I5,'Project Plan'!K$3)","v":"   Integration to IDR"},{"$f":"IF(K5=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I5,'Project Plan'!L$3))","v":"ITSPS"},{"$f":"IF(K5=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I5,'Project Plan'!M$3))","v":"2020-04-30"},{"$f":"IF(K5=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I5,'Project Plan'!O$3))","v":"2020-05-14"},{"$f":"IF(K5=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I5,'Project Plan'!N$3))","v":10},{"$f":"IF(K5=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I5,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I5,'Project Plan'!R$3)","v":"Mobility Preference"}]
[null,null,"Project Manager",null,{"$f":"VLOOKUP('Project Plan'!K1,'Projects Summary'!B2:J14,9,FALSE)","v":"Cathy"},null,null,null,{"$f":"I5+1","v":140},{"$f":"IF(K6=0,\"\",INDEX(Table1[],I6,2))","v":9.1999999999999993},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I6,2))-LEN(SUBSTITUTE(INDEX(Table1[],I6,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I6,'Project Plan'!K$3)","v":"   Integration to Pilat"},{"$f":"IF(K6=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I6,'Project Plan'!L$3))","v":"ITSPS"},{"$f":"IF(K6=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I6,'Project Plan'!M$3))","v":"2020-04-01"},{"$f":"IF(K6=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I6,'Project Plan'!O$3))","v":"2020-04-15"},{"$f":"IF(K6=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I6,'Project Plan'!N$3))","v":10},{"$f":"IF(K6=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I6,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I6,'Project Plan'!R$3)","v":"Mobility Preference"}]
[null,null,null,null,null,null,null,null,141,{"$f":"IF(K7=0,\"\",INDEX(Table1[],I7,2))","v":10},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I7,2))-LEN(SUBSTITUTE(INDEX(Table1[],I7,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I7,'Project Plan'!K$3)","v":"Stabilization"},{"$f":"IF(K7=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I7,'Project Plan'!L$3))","v":"ITSPS"},{"$f":"IF(K7=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I7,'Project Plan'!M$3))","v":"2020-04-01"},{"$f":"IF(K7=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I7,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K7=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I7,'Project Plan'!N$3))","v":60},{"$f":"IF(K7=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I7,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I7,'Project Plan'!R$3)","v":"Mobility Preference"}]
[null,null,"Start Date",null,{"$f":"VLOOKUP('Project Plan'!K1,'Projects Summary'!B2:G14,3,FALSE)","v":"2019-12-12"},null,null,null,142,{"$f":"IF(K8=0,\"\",INDEX(Table1[],I8,2))","v":1},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I8,2))-LEN(SUBSTITUTE(INDEX(Table1[],I8,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I8,'Project Plan'!K$3)","v":"SPO QA Site Preparation"},{"$f":"IF(K8=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I8,'Project Plan'!L$3))","v":"New Person"},{"$f":"IF(K8=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I8,'Project Plan'!M$3))","v":"2020-01-31"},{"$f":"IF(K8=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I8,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K8=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I8,'Project Plan'!N$3))","v":0.5},{"$f":"IF(K8=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I8,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I8,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,"End Date",null,{"$f":"VLOOKUP('Project Plan'!K1,'Projects Summary'!B2:G14,4,FALSE)","v":"2020-03-30"},null,null,null,143,{"$f":"IF(K9=0,\"\",INDEX(Table1[],I9,2))","v":2},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I9,2))-LEN(SUBSTITUTE(INDEX(Table1[],I9,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I9,'Project Plan'!K$3)","v":"Content Migration"},{"$f":"IF(K9=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I9,'Project Plan'!L$3))","v":"New Person"},{"$f":"IF(K9=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I9,'Project Plan'!M$3))","v":"2020-02-03"},{"$f":"IF(K9=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I9,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K9=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I9,'Project Plan'!N$3))","v":5},{"$f":"IF(K9=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I9,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I9,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,"Overall Progress",null,{"$f":"IFERROR(VLOOKUP('Project Plan'!K1,'Projects Summary'!B2:G14,6,FALSE),\"\")","v":7.0909090909090908E-2},null,null,null,144,{"$f":"IF(K10=0,\"\",INDEX(Table1[],I10,2))","v":3},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I10,2))-LEN(SUBSTITUTE(INDEX(Table1[],I10,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I10,'Project Plan'!K$3)","v":"UI Migration"},{"$f":"IF(K10=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I10,'Project Plan'!L$3))","v":"New Person"},{"$f":"IF(K10=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I10,'Project Plan'!M$3))","v":"2020-02-10"},{"$f":"IF(K10=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I10,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K10=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I10,'Project Plan'!N$3))","v":1},{"$f":"IF(K10=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I10,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I10,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,null,null,{"$f":"1-E10","v":0.92909090909090908},null,null,null,145,{"$f":"IF(K11=0,\"\",INDEX(Table1[],I11,2))","v":4},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I11,2))-LEN(SUBSTITUTE(INDEX(Table1[],I11,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I11,'Project Plan'!K$3)","v":"Site Branding"},{"$f":"IF(K11=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I11,'Project Plan'!L$3))","v":"New Person"},{"$f":"IF(K11=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I11,'Project Plan'!M$3))","v":"2020-02-11"},{"$f":"IF(K11=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I11,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K11=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I11,'Project Plan'!N$3))","v":1},{"$f":"IF(K11=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I11,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I11,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,"Days Required 6",null,null,null,null,null,146,{"$f":"IF(K12=0,\"\",INDEX(Table1[],I12,2))","v":5},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I12,2))-LEN(SUBSTITUTE(INDEX(Table1[],I12,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I12,'Project Plan'!K$3)","v":"Out of Box WebPart migration"},{"$f":"IF(K12=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I12,'Project Plan'!L$3))","v":"New Person"},{"$f":"IF(K12=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I12,'Project Plan'!M$3))","v":"2020-02-12"},{"$f":"IF(K12=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I12,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K12=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I12,'Project Plan'!N$3))","v":20},{"$f":"IF(K12=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I12,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I12,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,{"$f":"E9-E8 &\" Day Project\"","v":"109 Day Project"},null,null,null,null,null,147,{"$f":"IF(K13=0,\"\",INDEX(Table1[],I13,2))","v":6},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I13,2))-LEN(SUBSTITUTE(INDEX(Table1[],I13,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I13,'Project Plan'!K$3)","v":"Custom Solutions migration"},{"$f":"IF(K13=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I13,'Project Plan'!L$3))","v":"Kalaivani"},{"$f":"IF(K13=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I13,'Project Plan'!M$3))","v":"2020-02-12"},{"$f":"IF(K13=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I13,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K13=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I13,'Project Plan'!N$3))","v":55},{"$f":"IF(K13=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I13,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I13,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,{"$f":"VLOOKUP('Project Plan'!K1,'Projects Summary'!B2:G14,5,FALSE) &\" Man Days\"","v":"302.5 Man Days"},null,null,null,null,null,148,{"$f":"IF(K14=0,\"\",INDEX(Table1[],I14,2))","v":7},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I14,2))-LEN(SUBSTITUTE(INDEX(Table1[],I14,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I14,'Project Plan'!K$3)","v":"Unit Testing"},{"$f":"IF(K14=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I14,'Project Plan'!L$3))","v":"New Person + Kalaivani"},{"$f":"IF(K14=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I14,'Project Plan'!M$3))","v":"2020-04-23"},{"$f":"IF(K14=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I14,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K14=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I14,'Project Plan'!N$3))","v":5},{"$f":"IF(K14=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I14,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I14,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,null,null,null,null,null,null,149,{"$f":"IF(K15=0,\"\",INDEX(Table1[],I15,2))","v":8},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I15,2))-LEN(SUBSTITUTE(INDEX(Table1[],I15,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I15,'Project Plan'!K$3)","v":"System Testing"},{"$f":"IF(K15=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I15,'Project Plan'!L$3))","v":"New Person + Kalaivani"},{"$f":"IF(K15=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I15,'Project Plan'!M$3))","v":"2020-05-01"},{"$f":"IF(K15=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I15,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K15=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I15,'Project Plan'!N$3))","v":5},{"$f":"IF(K15=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I15,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I15,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,"Gantt. Scroll",null,null,null,null,null,150,{"$f":"IF(K16=0,\"\",INDEX(Table1[],I16,2))","v":9},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I16,2))-LEN(SUBSTITUTE(INDEX(Table1[],I16,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I16,'Project Plan'!K$3)","v":"UAT"},{"$f":"IF(K16=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I16,'Project Plan'!L$3))","v":"Business"},{"$f":"IF(K16=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I16,'Project Plan'!M$3))","v":"2020-05-11"},{"$f":"IF(K16=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I16,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K16=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I16,'Project Plan'!N$3))","v":5},{"$f":"IF(K16=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I16,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I16,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,null,null,null,null,null,null,151,{"$f":"IF(K17=0,\"\",INDEX(Table1[],I17,2))","v":10},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I17,2))-LEN(SUBSTITUTE(INDEX(Table1[],I17,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I17,'Project Plan'!K$3)","v":"Production Preparation"},{"$f":"IF(K17=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I17,'Project Plan'!L$3))","v":"Dev Team"},{"$f":"IF(K17=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I17,'Project Plan'!M$3))","v":"2020-05-04"},{"$f":"IF(K17=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I17,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K17=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I17,'Project Plan'!N$3))","v":5},{"$f":"IF(K17=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I17,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I17,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,"Total Tasks",{"$f":"IF(K1=\"All Projects\",COUNTA(Table1[Project]),COUNTIF(Table1[Project],K1))","v":87},"Remarks",null,null,null,152,{"$f":"IF(K18=0,\"\",INDEX(Table1[],I18,2))","v":11},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I18,2))-LEN(SUBSTITUTE(INDEX(Table1[],I18,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I18,'Project Plan'!K$3)","v":"Production Deployment"},{"$f":"IF(K18=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I18,'Project Plan'!L$3))","v":"Dev Team"},{"$f":"IF(K18=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I18,'Project Plan'!M$3))","v":"2020-05-11"},{"$f":"IF(K18=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I18,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K18=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I18,'Project Plan'!N$3))","v":10},{"$f":"IF(K18=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I18,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I18,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,"Completed(100%)",{"$f":"IF(K1=\"All Projects\",COUNTIFS(Table1[Progress],\"=1\"),COUNTIFS(Table1[Project],K1,Table1[Progress],\"=1\"))","v":0},null,null,null,null,153,{"$f":"IF(K19=0,\"\",INDEX(Table1[],I19,2))","v":12},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I19,2))-LEN(SUBSTITUTE(INDEX(Table1[],I19,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I19,'Project Plan'!K$3)","v":"Go Live"},{"$f":"IF(K19=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I19,'Project Plan'!L$3))","v":"NA"},{"$f":"IF(K19=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I19,'Project Plan'!M$3))","v":"2020-05-25"},{"$f":"IF(K19=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I19,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K19=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I19,'Project Plan'!N$3))","v":0},{"$f":"IF(K19=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I19,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I19,'Project Plan'!R$3)","v":"Language Tracking"}]
[null,null,"Inprogress(1-99%)",{"$f":"IF(K1=\"All Projects\",COUNTIFS(Table1[Progress],\">0\",Table1[Progress],\"<1\"),COUNTIFS(Table1[Progress],\">0\",Table1[Progress],\"<1\",Table1[Project],K1))","v":7},null,null,null,null,154,{"$f":"IF(K20=0,\"\",INDEX(Table1[],I20,2))","v":1},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I20,2))-LEN(SUBSTITUTE(INDEX(Table1[],I20,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I20,'Project Plan'!K$3)","v":"SPO QA Site Preparation"},{"$f":"IF(K20=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I20,'Project Plan'!L$3))","v":"Kalaivani"},{"$f":"IF(K20=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I20,'Project Plan'!M$3))","v":"2019-11-25"},{"$f":"IF(K20=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I20,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K20=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I20,'Project Plan'!N$3))","v":0.5},{"$f":"IF(K20=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I20,'Project Plan'!P$3))","v":1},null,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I20,'Project Plan'!R$3)","v":"Coaching"}]
[null,null,"1-25%",{"$f":"IF(K1=\"All Projects\",COUNTIFS(Table1[Progress],\">0\",Table1[Progress],\"<=.25\"),COUNTIFS(Table1[Progress],\">0\",Table1[Progress],\"<=.25\",Table1[Project],K1))","v":4},null,null,null,null,155,{"$f":"IF(K21=0,\"\",INDEX(Table1[],I21,2))","v":2},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I21,2))-LEN(SUBSTITUTE(INDEX(Table1[],I21,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I21,'Project Plan'!K$3)","v":"Content Migration"},{"$f":"IF(K21=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I21,'Project Plan'!L$3))","v":"Kalaivani"},{"$f":"IF(K21=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I21,'Project Plan'!M$3))","v":"2019-11-25"},{"$f":"IF(K21=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I21,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K21=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I21,'Project Plan'!N$3))","v":5},{"$f":"IF(K21=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I21,'Project Plan'!P$3))","v":1},5,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I21,'Project Plan'!R$3)","v":"Coaching"}]
[null,null,"26-50%",{"$f":"IF(K1=\"All Projects\",COUNTIFS(Table1[Progress],\">.25\",Table1[Progress],\"<=.5\"),COUNTIFS(Table1[Progress],\">.25\",Table1[Progress],\"<=.5\",Table1[Project],K1))","v":1},null,null,null,null,156,{"$f":"IF(K22=0,\"\",INDEX(Table1[],I22,2))","v":3},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I22,2))-LEN(SUBSTITUTE(INDEX(Table1[],I22,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I22,'Project Plan'!K$3)","v":"UI Migration"},{"$f":"IF(K22=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I22,'Project Plan'!L$3))","v":"Arul"},{"$f":"IF(K22=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I22,'Project Plan'!M$3))","v":"2019-12-02"},{"$f":"IF(K22=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I22,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K22=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I22,'Project Plan'!N$3))","v":1},{"$f":"IF(K22=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I22,'Project Plan'!P$3))","v":1},1,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I22,'Project Plan'!R$3)","v":"Coaching"}]
[null,null,"51-75%",{"$f":"IF(K1=\"All Projects\",COUNTIFS(Table1[Progress],\">.5\",Table1[Progress],\"<=.75\"),COUNTIFS(Table1[Progress],\">.5\",Table1[Progress],\"<=.75\",Table1[Project],K1))","v":1},null,null,null,null,157,{"$f":"IF(K23=0,\"\",INDEX(Table1[],I23,2))","v":4},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I23,2))-LEN(SUBSTITUTE(INDEX(Table1[],I23,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I23,'Project Plan'!K$3)","v":"Site Branding"},{"$f":"IF(K23=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I23,'Project Plan'!L$3))","v":"Arul"},{"$f":"IF(K23=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I23,'Project Plan'!M$3))","v":"2019-12-03"},{"$f":"IF(K23=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I23,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K23=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I23,'Project Plan'!N$3))","v":1},{"$f":"IF(K23=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I23,'Project Plan'!P$3))","v":1},1,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I23,'Project Plan'!R$3)","v":"Coaching"}]
[null,null,"76-99%",{"$f":"IF(K1=\"All Projects\",COUNTIFS(Table1[Progress],\">.75\",Table1[Progress],\"<1\"),COUNTIFS(Table1[Progress],\">.75\",Table1[Progress],\"<1\",Table1[Project],K1))","v":1},null,null,null,null,158,{"$f":"IF(K24=0,\"\",INDEX(Table1[],I24,2))","v":5},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I24,2))-LEN(SUBSTITUTE(INDEX(Table1[],I24,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I24,'Project Plan'!K$3)","v":"Out of Box WebPart migration"},{"$f":"IF(K24=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I24,'Project Plan'!L$3))","v":"Arul"},{"$f":"IF(K24=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I24,'Project Plan'!M$3))","v":"2019-12-04"},{"$f":"IF(K24=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I24,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K24=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I24,'Project Plan'!N$3))","v":20},{"$f":"IF(K24=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I24,'Project Plan'!P$3))","v":1},20,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I24,'Project Plan'!R$3)","v":"Coaching"}]
[null,null,"Not Started (0%)",{"$f":"IF(K1=\"All Projects\",COUNTIFS(Table1[Progress],0),COUNTIFS(Table1[Project],K1,Table1[Progress],0))","v":73},null,null,null,null,159,{"$f":"IF(K25=0,\"\",INDEX(Table1[],I25,2))","v":6},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I25,2))-LEN(SUBSTITUTE(INDEX(Table1[],I25,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I25,'Project Plan'!K$3)","v":"Custom Solutions migration"},{"$f":"IF(K25=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I25,'Project Plan'!L$3))","v":"Kalaivani"},{"$f":"IF(K25=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I25,'Project Plan'!M$3))","v":"2019-12-02"},{"$f":"IF(K25=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I25,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K25=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I25,'Project Plan'!N$3))","v":45},{"$f":"IF(K25=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I25,'Project Plan'!P$3))","v":0.75},{"$f":"IF(K25=0,\"\",O25*P25)","v":33.75},{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I25,'Project Plan'!R$3)","v":"Coaching"}]
[null,null,null,null,null,null,null,null,160,{"$f":"IF(K26=0,\"\",INDEX(Table1[],I26,2))","v":7},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I26,2))-LEN(SUBSTITUTE(INDEX(Table1[],I26,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I26,'Project Plan'!K$3)","v":"Unit Testing"},{"$f":"IF(K26=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I26,'Project Plan'!L$3))","v":"New Person + Kalaivani"},{"$f":"IF(K26=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I26,'Project Plan'!M$3))","v":"2020-02-10"},{"$f":"IF(K26=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I26,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K26=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I26,'Project Plan'!N$3))","v":5},{"$f":"IF(K26=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I26,'Project Plan'!P$3))","v":0},{"$f":"IF(K26=0,\"\",O26*P26)","v":0},{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I26,'Project Plan'!R$3)","v":"Coaching"}]
[null,null,null,null,null,null,null,null,161,{"$f":"IF(K27=0,\"\",INDEX(Table1[],I27,2))","v":8},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I27,2))-LEN(SUBSTITUTE(INDEX(Table1[],I27,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I27,'Project Plan'!K$3)","v":"System Testing"},{"$f":"IF(K27=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I27,'Project Plan'!L$3))","v":"New Person + Kalaivani"},{"$f":"IF(K27=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I27,'Project Plan'!M$3))","v":"2020-02-17"},{"$f":"IF(K27=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I27,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K27=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I27,'Project Plan'!N$3))","v":5},{"$f":"IF(K27=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I27,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I27,'Project Plan'!R$3)","v":"Coaching"}]
[null,null,"Project Gantt. Template By:",null,"https://analysistabs.com","PNRao",null,null,162,{"$f":"IF(K28=0,\"\",INDEX(Table1[],I28,2))","v":9},{"$f":"REPT(\"   \",(LEN(INDEX(Table1[],I28,2))-LEN(SUBSTITUTE(INDEX(Table1[],I28,2),\".\",\"\"))))&OFFSET('Data Sheet'!$C$1,'Project Plan'!$I28,'Project Plan'!K$3)","v":"UAT"},{"$f":"IF(K28=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I28,'Project Plan'!L$3))","v":"Business"},{"$f":"IF(K28=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I28,'Project Plan'!M$3))","v":"2020-02-24"},{"$f":"IF(K28=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I28,'Project Plan'!O$3))","v":"2020-12-30"},{"$f":"IF(K28=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I28,'Project Plan'!N$3))","v":5},{"$f":"IF(K28=0,\"\",OFFSET('Data Sheet'!$C$1,'Project Plan'!$I28,'Project Plan'!P$3))","v":0},0,{"$f":"OFFSET('Data Sheet'!$C$1,'Project Plan'!$I28,'Project Plan'!R$3)","v":"Coaching"}]
[null,null,"Please let us know your feedback | Email: info@analysistabs.com"]

{"sheet":"Projects Summary","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Projects","Tasks","Start","End","Days","%Progress","Remaining","Client","PM"]
[null,"All Projects",{"$f":"COUNTA(Table1[Project])","v":246},{"$f":"MIN(Table1[Start Date])","v":"2019-11-25"},{"$f":"MAX(Table1[Start Date])+MAX(Table1[Days Req.])","v":"2020-11-30"},{"$f":"SUM(Table1[Days Req.])","v":1402.5},{"$f":"IFERROR(Table1[[#This Row],[Days Complete]]/Table1[[#This Row],[Days Req.]],0)","v":0.1},{"$f":"IFERROR(1-G3,\"\")","v":0.9},"HRD","Mak"]
[null,"PJ04757-PR Tool",{"$f":"COUNTIF(Table1[Project],B4)","v":36},{"$f":"MIN(IF(Table1[Project]=B4,Table1[Start Date]))","v":"2019-12-01"},{"$f":"MAX(IF(Table1[Project]=B4,Table1[End Date]))","v":"2020-06-15"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B4,Table1[Days Req.])","v":204},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B4,Table1[Days Complete])/F4,0)","v":7.1568627450980402E-2},{"$f":"IFERROR(1-G4,\"\")","v":0.92843137254901964},"HRDPL - Planning and Performance","Cathy"]
[null,"PJ04750 Talent Review Tool",{"$f":"COUNTIF(Table1[Project],B5)","v":87},{"$f":"MIN(IF(Table1[Project]=B5,Table1[Start Date]))","v":"2019-12-12"},{"$f":"MAX(IF(Table1[Project]=B5,Table1[End Date]))","v":"2020-03-30"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B5,Table1[Days Req.])","v":302.5},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B5,Table1[Days Complete])/F5,0)","v":7.0909090909090908E-2},{"$f":"IFERROR(1-G5,\"\")","v":0.92909090909090908},"HRDCM - Careers and Mobility","Cathy"]
[null,"Mobility Preference",{"$f":"COUNTIF(Table1[Project],B6)","v":17},{"$f":"MIN(IF(Table1[Project]=B6,Table1[Start Date]))","v":"2020-01-02"},{"$f":"MAX(IF(Table1[Project]=B6,Table1[End Date]))","v":"2020-12-30"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B6,Table1[Days Req.])","v":174},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B6,Table1[Days Complete])/F6,0)","v":1.7241379310344827E-2},0.98275862068965514,"HRDCM - Careers and Mobility","Cathy"]
[null,"Workforce Planning",{"$f":"COUNTIF(Table1[Project],B7)","v":14},{"$f":"MIN(IF(Table1[Project]=B7,Table1[Start Date]))","v":"2020-01-01"},{"$f":"MAX(IF(Table1[Project]=B7,Table1[End Date]))","v":"2020-01-31"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B7,Table1[Days Req.])","v":24},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B7,Table1[Days Complete])/F7,0)","v":0.32916666666666666},0.67083333333333339,"HRDPL - Planning and Performance","Julie"]
[null,"Onboarding",{"$f":"COUNTIF(Table1[Project],B8)","v":1},{"$f":"MIN(IF(Table1[Project]=B8,Table1[Start Date]))","v":"2020-01-01"},{"$f":"MAX(IF(Table1[Project]=B8,Table1[End Date]))","v":"2020-03-30"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B8,Table1[Days Req.])","v":90},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B8,Table1[Days Complete])/F8,0)","v":0},1,"Client Services","Pamela"]
[null,"Language Tracking",{"$f":"COUNTIF(Table1[Project],B9)","v":12},{"$f":"MIN(IF(Table1[Project]=B9,Table1[Start Date]))","v":"2020-01-31"},{"$f":"MAX(IF(Table1[Project]=B9,Table1[End Date]))","v":"2020-12-30"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B9,Table1[Days Req.])","v":112.5},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B9,Table1[Days Complete])/F9,0)","v":0},1,"HRDCL - Career, Performance and Learning","Cathy"]
[null,"Coaching",{"$f":"COUNTIF(Table1[Project],B10)","v":12},{"$f":"MIN(IF(Table1[Project]=B10,Table1[Start Date]))","v":"2019-11-25"},{"$f":"MAX(IF(Table1[Project]=B10,Table1[End Date]))","v":"2020-12-30"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B10,Table1[Days Req.])","v":102.5},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B10,Table1[Days Complete])/F10,0)","v":0.59756097560975607},0.40243902439024393,"HRDCL - Career, Performance and Learning","Cathy"]
[null,"HireVue",{"$f":"COUNTIF(Table1[Project],B11)","v":48},{"$f":"MIN(IF(Table1[Project]=B11,Table1[Start Date]))","v":"2020-01-15"},{"$f":"MAX(IF(Table1[Project]=B11,Table1[End Date]))","v":"2020-03-31"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B11,Table1[Days Req.])","v":119},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B11,Table1[Days Complete])/F11,0)","v":0},1,"Client Services","Pamela"]
[null,"ePerformance",{"$f":"COUNTIF(Table1[Project],B12)","v":19},{"$f":"MIN(IF(Table1[Project]=B12,Table1[Start Date]))","v":"2019-12-15"},{"$f":"MAX(IF(Table1[Project]=B12,Table1[End Date]))","v":"2020-12-30"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B12,Table1[Days Req.])","v":264},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B12,Table1[Days Complete])/F12,0)","v":0.33560606060606057},0.66439393939393943,"HRDPL - Planning and Performance","Julie"]
[null,null,{"$f":"COUNTIF(Table1[Project],B13)","v":0},{"$f":"MIN(IF(Table1[Project]=B13,Table1[Start Date]))","v":"2020-01-08"},{"$f":"MAX(IF(Table1[Project]=B13,Table1[End Date]))","v":"2020-01-31"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B13,Table1[Days Req.])","v":0},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B13,Table1[Days Complete])/F13,0)","v":0},1]
[null,null,{"$f":"COUNTIF(Table1[Project],B14)","v":0},{"$f":"MIN(IF(Table1[Project]=B14,Table1[Start Date]))","v":"2020-01-08"},{"$f":"MAX(IF(Table1[Project]=B14,Table1[End Date]))","v":"2020-01-31"},{"$f":"SUMIF(Table1[Project],'Projects Summary'!B14,Table1[Days Req.])","v":0},{"$f":"IFERROR(SUMIF(Table1[Project],'Projects Summary'!B14,Table1[Days Complete])/F14,0)","v":0},1]

{"sheet":"Data Sheet","index":3,"n_rows":255,"n_cols":14,"rows_kept":255,"cut":false,"hidden":false,"merged":[]}
["Project","WBS","Task","Responsible","Start Date","End Date","Days Req.","Progress","Days Complete"]
["PJ04757-PR Tool",1,"Technicial Design Document","Hari","2019-12-12","2020-02-28",5,0.02,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0.1}]
["PJ04757-PR Tool",2,"Unit Test Case","Hari/Cindy/Cathy/Frances","2019-12-12","2020-02-28",8,0.1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0.8}]
["PJ04757-PR Tool",3,"Data Mapping Roster","Hari/Cindy/Frances","2019-12-01","2020-01-17",10,0.75,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":7.5}]
["PJ04757-PR Tool",4,"Master Screen","Hari/Cindy/Frances","2020-01-21","2020-02-04"]
["PJ04757-PR Tool",4.0999999999999996,"Master Screen: Define Annual PR Cycle","Hari","2020-01-21","2020-02-04",7,0.6,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":4.2}]
["PJ04757-PR Tool",4.2,"Master Screen: Criteria/Sorting Options Screen","Hari","2020-01-21","2020-02-04",8,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",4.3,"Master Screen: Add More Field - Screen","Hari","2020-01-21","2020-02-04",8,0.25,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":2}]
["PJ04757-PR Tool",5,"Transaction","Hari","2020-02-04","2020-02-28"]
["PJ04757-PR Tool",5.0999999999999996,"Transaction:.Data Entry screen",null,"2020-02-04","2020-02-18",10,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",5.2,"Transaction:.Data Refresh/Resynch","Hari","2020-02-04","2020-02-18",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool","5.2.1","Transaction:.PR Cycle population inclusion / exclusion","Hari","2020-02-04","2020-02-18",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool","5.2.2","Transaction:.Security setup (Read only/editable fields) we will be using PS Security Rowsecclass)","Hari","2020-02-04","2020-02-17",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",5.3,"Transaction:.Automatic assignment of exclusion codes","Hari","2020-02-17","2020-02-28",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",5.4,"Transaction:.Prompts for Final PR","Hari","2020-02-17","2020-02-28",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",5.5,"Transaction:.Audit trail functionality for any changes made","Hari","2020-02-17","2020-02-28",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",5.6,"Transaction:.User Roles Set-up","Sec Admin/Hari/Frances","2020-02-10","2020-02-28",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",6,"Reports ","Sujana/Contractor 1","2020-02-10","2020-03-07"]
["PJ04757-PR Tool",6.1,"Reports: Pre-defined PR curve Report (should include different filters)","Sujana/Contractor 1","2020-02-10","2020-02-24",15,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",6.2,"Reports: Data Export (Excel, PDF if possible)","Sujana/Contractor 1","2020-02-10","2020-02-24",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",6.3,"Reports: Summary Report for WBG","Sujana/Contractor 1","2020-02-27","2020-03-07",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",6.4,"Reports: Status Report - completion of PR per VPU etc.","Sujana/Contractor 1","2020-02-27","2020-03-07",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",7," Interface","Cindy/Hari","2020-01-08","2020-02-28"]
[null,null," Interface: PeopleSoft to PR Tool (Population)","Cindy/Hari","2020-01-08","2020-01-31",10,0.2,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":2}]
["PJ04757-PR Tool",7.1," Interface: eTalent to PR Tool (Prelim PR ,Talent Indicator, Promotion Readiness)","Cindy/Hari/Sujana","2020-02-17","2020-02-28",10,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",7.2," Interface: To API- modify existing program","Cindy/Hari","2020-02-03","2020-02-14",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool","7.2.1"," Interface: Tool to e-Talent ( Final Rating)","Cindy/Hari","2020-02-17","2020-02-28",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",8,"User Acceptance Testing",null,"2020-03-09","2020-06-03"]
["PJ04757-PR Tool",8.1,"Indentify Test Cases","PM Team","2020-03-09","2020-03-13",4,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",8.1999999999999993,"Identify Testers","PM Team","2020-03-16","2020-03-20",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",8.3000000000000007,"Produce Test Case Documents","PM Team","2020-03-23","2020-03-27",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",8.4,"Approval of UAT Test Cases","PM Team","2020-03-30","2020-03-30",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",8.5,"User Guide Creation","PM Team","2020-03-30","2020-04-03",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",8.6,"Approval of User Guide","PM Team","2020-04-06","2020-04-06",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",8.6999999999999993,"User Brown Bag Session","PM Team","2020-04-06","2020-04-10",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",8.8000000000000007,"Perform Test Cases","PM Team","2020-04-13","2020-05-29",35,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",8.9,"UAT Sign Off/ Go or No Go","PM Team","2020-01-05","2020-01-05",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04757-PR Tool",9,"System Go-Live","ITS","2020-06-15","2020-06-15",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","1","Contract"," ","2019-12-12","2020-01-13"," "," "," "]
["PJ04750 Talent Review Tool","1.1","Review Cycle","Celena","2019-12-12","2020-01-10",9,0.8,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":7.2}]
["PJ04750 Talent Review Tool","1.2","Approval","ITSPS/Pilat","2020-01-13","2020-01-13",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","2","Functional Specification",null,"2020-01-03","2020-02-05",null,null," "]
["PJ04750 Talent Review Tool","2.1","MSS review","HRDCM","2020-01-03","2020-01-03",12,0.75,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":9}]
["PJ04750 Talent Review Tool","2.2","MSS approved","HRDCM","2020-01-03","2020-01-03",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","2.3","Data import review","HRDCM","2020-01-10","2020-01-10",5,0.1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0.5}]
["PJ04750 Talent Review Tool","2.4","Data import approved","HRDCM","2020-01-10","2020-01-10",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","2.5","Talent Meeting review","HRDCM","2020-01-10","2020-01-10",5,0.1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0.5}]
["PJ04750 Talent Review Tool","2.6","Talent Meeting approved","HRDCM","2020-01-10","2020-01-10",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","2.7","Talent Pool review","HRDCM","2020-01-17","2020-01-17",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","2.8","Talent Pool approved","HRDCM","2020-01-27","2020-01-27",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","2.9","Reporting/ Analytics review","HRDCM","2020-01-17","2020-01-17",5,0.05,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0.25}]
["PJ04750 Talent Review Tool","2.10","Analytics approved","HRDCM","2020-01-28","2020-01-28",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","2.11","Admin phase 1 review","HRDCM","2020-01-29","2020-01-29",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","2.12","Admin approved","HRDCM","2020-02-05","2020-02-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3","Phase 1 Configuration"," ","2019-12-30","2020-01-30"," "," "," "]
["PJ04750 Talent Review Tool","3.1","Set up Pulse 10 base","Pilat","2019-12-30","2020-01-14",10,0.1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":1}]
["PJ04750 Talent Review Tool","3.2","Set up test site","Pilat","2020-01-15","2020-01-16",2,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.3","Set up production","Pilat","2020-01-17","2020-01-21",2,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.3.1","Single Sign-On",null,"2020-01-13","2020-01-28"," "," "," "]
["PJ04750 Talent Review Tool","3.3.1.1","SSO configuration engagement with ICAM team","Srikanth (ITS ICAM Team)","2020-01-13","2020-01-15",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.3.1.2","SSO credential agreement","Pilat / ITSPS","2020-01-15","2020-01-22",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.3.1.3","SSO setup","Pilat / ITSPS","2020-01-23","2020-01-27",3,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.3.1.4","SSO test","Pilat / ITSPS","2020-01-28","2020-01-28",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.3.1.5","SSO complete","Pilat / ITSPS","2020-01-28","2020-01-28",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.4","Import","Pilat / ITSPS","2020-01-13","2020-02-10"," "," "," "]
["PJ04750 Talent Review Tool","3.4.1","Oracle export build","ITSPS","2020-01-13","2020-01-27",4,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.4.2","Oracle export build","ITSPS","2020-01-13","2020-01-27",4,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.4.3","Pulse 10 WBG import","ITSPS","2020-01-13","2020-01-27",4,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.4.4","Pulse 10 IFC import","ITSPS","2020-01-13","2020-01-27",4,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.4.5","Exchange agreement","ITSPS/Pilat","2020-01-13","2020-01-17",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.4.6","Provide keys","ITSPS/Pilat","2020-01-13","2020-01-17",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.4.7","Test Import","ITSPS","2020-01-28","2020-02-10",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.4.8","Mobility Preferences Integration","Pilat/ITSPS","2020-01-28","2020-02-10",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.4.9","Import Completed","HRDCM","2020-02-10","2020-02-10",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.5","Pen Test Planning with WBG OIS","ITSPS/Pilat","2020-01-28","2020-01-30",2,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.6","Configuration and Build","Pilat / ITSPS/HRDCM","2020-01-15","2020-03-05"," "," "," "]
["PJ04750 Talent Review Tool","3.6.1","MSS","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",19,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.6.2","Capture Preliminary Performance Ratings and Calibration feature","Pilat","2020-01-15","2020-03-05",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.6.3","Configure","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",10,0.3,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":3}]
["PJ04750 Talent Review Tool","3.6.4","Internal test","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",4,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.6.5","MSS completed","Pilat / HRDCM / ITSPS","2020-03-05","2020-03-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.7","User Security Roles (Testing) – Access control","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",35,0,0]
["PJ04750 Talent Review Tool",3.7,"Talent Mtg Build","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.7.1","Configure","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",19,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.7.2","Internal test","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.7.3","Talent Mtg completed","Pilat / HRDCM / ITSPS","2020-03-05","2020-03-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool",3.8,"Talent Pools","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.8.1","Configure","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",13,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.8.2","Internal test","Pilat / HRDCM / ITSPS","2020-01-15","2020-03-05",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.8.3","Talent Mtg completed","Pilat / HRDCM / ITSPS","2020-03-05","2020-03-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool",3.9,"Analytic & Reporting v1","Pilat / HRDCM / ITSPS","2020-02-13","2020-03-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.9.1","Configure","Pilat / HRDCM / ITSPS","2020-02-13","2020-03-05",13,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.9.2","Internal test","Pilat / HRDCM / ITSPS","2020-02-13","2020-03-05",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.9.3","Analytics completed","Pilat / HRDCM / ITSPS","2020-03-05","2020-03-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool",3.1,"Admisistration v1","Pilat / HRDCM / ITSPS","2020-02-13","2020-02-28",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.10.1","Configure","Pilat / HRDCM / ITSPS","2020-02-13","2020-02-28",12,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.10.2","Internal test","Pilat / HRDCM / ITSPS","2020-02-13","2020-02-28",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.10.3","Admin v1 completed","Pilat / HRDCM / ITSPS","2020-03-05","2020-03-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool",3.11,"Phase 1 Config completed","Pilat / HRDCM / ITSPS","2020-03-05","2020-03-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool",3.12,"Questionsand Feedback"," ","2020-01-15","2020-03-05",2,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool",3.13,"Walkthroughs","HRDCM","2020-02-13","2020-02-27",3,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.13.1","Walkthrough 1","HRDCM","2020-02-13","2020-02-12T12:00:00",0.5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.13.2","Walkthrough 2","HRDCM","2020-02-20","2020-02-20",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.13.3","Walkthrough 3","HRDCM","2020-02-27","2020-02-27",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool",3.14,"Pen Test","PeddiRaju","2020-02-28","2020-03-05",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool",3.15,"User Acceptance Testing","HRDCM","2020-03-06","2020-03-23",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.15.1","Cycle 1","HRDCM","2020-03-06","2020-03-12",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.15.2","Remediation","Pilat","2020-03-13","2020-03-13",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.15.3","Cycle 2","HRDCM","2020-03-16","2020-03-19",4,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.15.4","Remediation","Pilat","2020-03-20","2020-03-23",2,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","3.15.5","UAT completed","HRDCM","2020-03-23","2020-03-23",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4","Move to Production",null,"2020-02-20","2020-03-30",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.1","[Pre-Deployment Phase","HRDCM","2020-02-20","2020-03-30",13,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.1.1","Develop Communication Strategy","HRDCM","2020-02-20","2020-02-28",7,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.1.2","KM documents","Pilat","2020-03-26","2020-03-30",3,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.1.3","User Training Manual ","Pilat","2020-03-26","2020-03-30",3,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.2","Move Test to Production","Pilat","2020-03-24","2020-03-30",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.3","Clear test data","Pilat","2020-03-24","2020-03-30",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.4","Enable SSO","Pilat","2020-03-25","2020-03-25",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.5","Enable import","Pilat","2020-03-25","2020-03-25",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.6","Supply fresh data files","ITSPS","2020-03-25","2020-03-25",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.7","Run import","Pilat","2020-03-26","2020-03-26",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.8","System Test ","ITSPS/Pilat","2020-03-26","2020-03-26",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.9","User Test ","HRDCM","2020-03-26","2020-03-26",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["PJ04750 Talent Review Tool","4.10","Open eTalent v10","HRDCM","2020-03-30","2020-03-30",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",1,"BRD Completion and Sign off","HRDCM","2020-01-02","2020-01-30",20,0.1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":2}]
["Mobility Preference",1.1000000000000001,"Finalize the questionnaire from WB and IFC",null,"2020-01-02","2020-01-30",10,0.1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":1}]
["Mobility Preference",1.2,"BRD Sign Off",null,"2020-01-30","2020-01-30",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",2,"Master Screen Creation","ITSPS","2020-01-21","2020-02-13",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",2.1,"Master Screen: Capture Staff's Mobility Preferences","ITSPS","2020-01-21","2020-02-13",17,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0},null,null,"2020-01-21",17,{"$f":"WORKDAY(L130,M130)","v":"2020-02-13"}]
["Mobility Preference",3,"Reports","ITSPS","2020-02-03","2020-12-30",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0},null,null,"2020-04-30",10,{"$f":"WORKDAY(L131,M131)","v":"2020-05-14"}]
["Mobility Preference",3.1,"Excel Report Dump","ITSPS","2020-02-03","2020-02-06",3,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0},null,null,"2020-04-01",10,"2020-04-15"]
["Mobility Preference",3.2,"PDF Report Extract","ITSPS","2020-02-06","2020-02-11",3,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",4,"Functional Unit/System Testing","ITSPS","2020-02-11","2020-02-17",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",5,"User Acceptance Testing","HRDCM","2020-02-20","2020-03-05",10,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",6,"Pre-Deployment Phase","ITSPS","2020-03-05","2020-03-12",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",7,"Production Launch","ITSPS","2020-03-31","2020-03-31",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",8,"myHRSS - mobile","ITSPS","2020-04-01","2020-04-28",20,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",9,"Integrations","ITSPS","2020-04-01","2020-05-14",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",9.1,"Integration to IDR","ITSPS","2020-04-30","2020-05-14",10,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",9.1999999999999993,"Integration to Pilat","ITSPS","2020-04-01","2020-04-15",10,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Mobility Preference",10,"Stabilization","ITSPS","2020-04-01","2020-12-30",60,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",1,"SPO QA Site Preparation","New Person","2020-01-31","2020-12-30",0.5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",2,"Content Migration","New Person","2020-02-03","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",3,"UI Migration","New Person","2020-02-10","2020-12-30",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",4,"Site Branding","New Person","2020-02-11","2020-12-30",1,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",5,"Out of Box WebPart migration","New Person","2020-02-12","2020-12-30",20,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",6,"Custom Solutions migration","Kalaivani","2020-02-12","2020-12-30",55,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",7,"Unit Testing","New Person + Kalaivani","2020-04-23","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",8,"System Testing","New Person + Kalaivani","2020-05-01","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",9,"UAT","Business","2020-05-11","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",10,"Production Preparation","Dev Team","2020-05-04","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",11,"Production Deployment","Dev Team","2020-05-11","2020-12-30",10,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Language Tracking",12,"Go Live","NA","2020-05-25","2020-12-30",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Coaching",1,"SPO QA Site Preparation","Kalaivani","2019-11-25","2020-12-30",0.5,1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0.5}]
["Coaching",2,"Content Migration","Kalaivani","2019-11-25","2020-12-30",5,1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":5}]
["Coaching",3,"UI Migration","Arul","2019-12-02","2020-12-30",1,1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":1}]
["Coaching",4,"Site Branding","Arul","2019-12-03","2020-12-30",1,1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":1}]
["Coaching",5,"Out of Box WebPart migration","Arul","2019-12-04","2020-12-30",20,1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":20}]
["Coaching",6,"Custom Solutions migration","Kalaivani","2019-12-02","2020-12-30",45,0.75,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":33.75}]
["Coaching",7,"Unit Testing","New Person + Kalaivani","2020-02-10","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Coaching",8,"System Testing","New Person + Kalaivani","2020-02-17","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Coaching",9,"UAT","Business","2020-02-24","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Coaching",10,"Production Preparation","Dev Team","2020-02-10","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Coaching",11,"Production Deployment","Dev Team","2020-02-17","2020-12-30",10,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Coaching",12,"Go Live","Dev Team","2020-03-03","2020-12-30",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",1,"Project Kickoff / Initial Workshops",null,"2020-01-15","2020-02-12",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",1.1000000000000001,"Project Initiation",null,"2020-01-15","2020-02-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.1.1","Project Kickoff",null,"2020-01-15","2020-01-29",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.1.1.1","Review scope, expectations, schedule, and communication plan",null,"2020-01-15","2020-01-17",3,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.1.2","Remote workshops",null,"2020-01-21","2020-02-05",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.1.2.1","Review baseline metrics",null,"2020-01-21","2020-01-22",2,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.1.2.2","Review current and to-be business process",null,"2020-01-23","2020-01-27",3,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.1.2.3","Discuss recommendations for process improvements",null,"2020-01-28","2020-01-30",3,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.1.2.4","Initial discussion of desired outcomes, success criteria, and metrics",null,"2020-01-31","2020-02-03",2,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.1.2.5","Stakeholder analysis focused on Recruiter, Hiring Manager, and Candidate experience",null,"2020-02-04","2020-02-05",2,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.1.3","Other follow-up workshops as needed to refine outcomes and success criteria",null,"2020-01-21","2020-02-05",0,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",1.2,"Project Management",null,"2020-02-06","2020-02-10",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.2.1","Plan weekly one hour project status meetings to review schedule, scope, issues, risks, and actions",null,"2020-02-06","2020-02-06",1,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.2.2","Plan management of schedule, issues and risk log",null,"2020-02-07","2020-02-07",1,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.2.3","Plan status reporting as needed as agreed between HireVue and Buyer Project Managers",null,"2020-02-10","2020-02-10",1,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",1.3,"Communication and Adoption Support",null,"2020-02-11","2020-02-12",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.3.1","Define best practices on candidate and user communication",null,"2020-02-11","2020-02-11",1,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.3.2","Provide sample templates for candidate, recruiter, and hiring manager communication materials",null,"2020-02-12","2020-02-12",1,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",1.4,"Pre- and Post- Go Live Support",null,"2020-02-12","2020-02-12",0,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","1.4.1","Define formal transition to Customer Support",null,"2020-02-12","2020-02-12",0,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue"," ","1. Milestones",null,"2020-01-15","2020-02-12",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",null,"Issues and risk lists",null,"2020-01-15","2020-02-12",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",null,"Project Plan ",null,"2020-01-15","2020-02-12",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",2,"HireVue Video Interviewing and Base Configuration",null,"2020-02-13","2020-03-31",33,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",2.1,"Development of one (1) standard theme (logo, image, and page colors are configurable)",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",2.2000000000000002,"Account Setup ",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",2.2999999999999998,"2. Milestones"," ","2020-03-27","2020-03-27"," "," "]
["HireVue","2.3.1","Initial configured system in one (1) production environment with branding, users and roles",null,"2020-03-27","2020-03-27"]
["HireVue",3,"HireVue Assessments",null,"2020-02-13","2020-03-31",33,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",3.1,"Job Analysis",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",3.2,"Confirm Pre-Built Assessments",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",3.3,"Implement",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",3.4,"Monitor and Optimization of Model",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",3.5,"3. Milestones",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","3.5.1","Job Analysis report (MS Word)",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","3.5.2","Assessment configuration",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",4,"Integrations",null,"2020-02-13","2020-03-31",33,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",4.0999999999999996,"ATS integration",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","4.1.1","Integration Process Mapping and Design",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","4.1.2","Configuration",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","4.1.3","Launch",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",4.2,"4.1 Milestones",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","4.2.1","Integration Activation Guide as provided through CSOD",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","4.2.2","Integration process maps",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","4.2.3","Configuration of integration in a Production instance of HireVue",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",4.3,"Single Sign On",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue",4.4000000000000004,"Milestones",null,"2020-02-13","2020-03-31",null,null,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["HireVue","4.4.1","HireVue SSO metadata",null,"2020-02-13","2020-03-31",null,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["ePerformance",1,"Dashboard for 2020 opening","Func Team/ITSPS","2019-12-15","2020-12-30",24,0.7,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":16.799999999999997}]
["ePerformance",2,"Cumulative Report for Ongoing Feedback","Julie / Shyam","2019-12-30","2020-12-30",15,0.3,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":4.5}]
["ePerformance",3,"IFC Mid Year utilizing checkins","Julie / Shyam","2019-12-15","2020-12-30",15,0.7,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":10.5}]
["ePerformance",4,"IFC Mid-Year Check-in Validation objectives before mid-year check-in submitted","Julie / Shyam","2019-12-15","2020-12-30",15,0.7,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":10.5}]
["ePerformance",5,"Manage list of Exempt staff","Julie / Shyam","2019-12-15","2020-12-30",15,0.7,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":10.5}]
["ePerformance",6,"Reporting (Completion Report for Ongoing Feedback and Checkin)","Naresh/Shyam/Julie","2019-12-15","2020-12-30",15,0.4,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":6}]
["ePerformance",7,"Roster based on Hierarchy of EndYear Documents","Julie / Shyam","2019-12-15","2020-12-30",15,0.7,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":10.5}]
["ePerformance",8,"IFC Mid Year Status Report","Naresh/Shyam/Julie","2019-12-15","2020-12-30",15,0.4,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":6}]
["ePerformance",9,"Access to Historical Documents (supervisors/co-supervisors)","Julie / Shyam","2019-12-15","2020-12-30",15,0.7,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":10.5}]
["ePerformance",10,"Sentiment analysis Cumulative Report","Inovation Lab/Julie","2019-12-15","2020-12-30",10,0.05,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0.5}]
["ePerformance",11,"New Security Role for Business Partners","Julie / Shyam/ SecAdmin","2019-12-15","2020-12-30",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["ePerformance",12,"IFC EndYear cannot begin without midyear","Julie / Shyam","2019-12-15","2020-12-30",10,0.03,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0.3}]
["ePerformance",13,"IFC MRF vs ongoing feedback tool (decision needed","Julie / Shyam","2020-02-28","2020-12-30",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["ePerformance",14,"Cumulative Report of CheckIns (PDF)","Julie / Shyam","2019-12-30","2020-12-30",5,0.4,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":2}]
["ePerformance",15,"New Dashboard","Julie / Shyam/UXM","2020-04-01","2020-12-30",30,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["ePerformance",16,"RO Bypass","Julie / Shyam","2020-04-01","2020-12-30",15,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["ePerformance",17,"Co-Supervisor automatic release of feedback request","Julie / Shyam","2020-04-01","2020-12-30",15,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["ePerformance",18,"Version control for objectives","Julie / Shyam","2020-06-01","2020-12-30",15,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["ePerformance",19,"Checkin filing in SRM","Julie / Shyam","2020-09-01","2020-12-30",15,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",1,"Locking update access separately for IBRD/IFC","Julie","2020-01-01","2020-01-11",1,1,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":1}]
["Workforce Planning",2,"Meet with Coordinators","Julie","2020-01-02","2020-01-04",5,0.2,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":1}]
["Workforce Planning",3,"Test functionality","Julie","2020-01-17","2020-01-10",3,0.3,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0.89999999999999991}]
["Workforce Planning",4,"File upload of Snapshot Data","Julie","2020-01-10","2020-01-28",0,0.4,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",5,"test with sample set","Julie","2020-01-10","2020-01-28",0,0.5,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",6,"IFC prepares data acording to template","Julie","2020-01-02","2020-01-08",0,0.6,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",7,"load into QA environment","Julie","2020-01-10","2020-01-28",0,0.7,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",8,"IFC verifies data","Julie","2020-01-10","2020-01-28",0,0.8,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",9,"load into production environment","Julie","2020-01-01","2020-01-09",0,0.9,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",10,"IFC verifies data","Julie","2020-02-03","2020-01-28",5,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",11,"WFP/Position Alignment in Implementation Module","Julie","2020-01-10","2020-01-28",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",12,"Initial meeting with IFC for requirements","Julie","2020-01-10","2020-01-28",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Workforce Planning",13,"Off line planning","Julie","2020-01-01","2020-01-31",10,0.5,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":5}]
["Workforce Planning",14,"Requires extensive (80%) changes due to SQL server change to 2017  - at least 8 weeks of development","Julie","2020-01-10","2020-01-28",0,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Onboarding",1,"Planning Activities","Pamela","2020-01-01","2020-03-30",90,0,{"$f":"Table1[[#This Row],[Days Req.]]*Table1[[#This Row],[Progress]]","v":0}]
["Total",null,null,null,null,null,{"$f":"SUBTOTAL(109,Table1[Days Req.])","v":1402.5},null,{"$f":"SUBTOTAL(109,Table1[Days Complete])","v":198.8}]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"Advanced Project Plan Template","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}