{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Role Organization Template","Career Path Template","IDP Template","Talent Profile","Formulas"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":22,"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":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Role Organization Template","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,9,3],[7,2,7,3],[0,0,0,5],[13,2,13,3],[26,2,26,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[31,2,31,3],[27,2,27,3]]}
["Role Organization Template"]
[]
[]
[]
[]
[null,"Career Path Design Information"]
[]
[null,"Aspired Future Role (>9 years timeline)","Sample Aspired Future Role (Long-term)"]
[]
[null,"Entry-Level / Current Role ","Sample Entry-Level (Current Role)"]
[]
[null,"Connecting Role Organization Template"]
[]
[null,"Connecting Roles\n(1-3 years timeline each role)","Brief Description of Connecting Roles",null,"Skills/Experiences Required to Gain"]
[null,"Sample Connecting Role 1","Sample Connecting Role 1 Description",null,"Sample Connecting Role 1 Skills and Experiences Required to Gain"]
[null,"Sample Connecting Role 2","Sample Connecting Role 2 Description",null,"Sample Connecting Role 2 Skills and Experiences Required to Gain"]
[null,"Sample Connecting Role 3","Sample Connecting Role 3 Description",null,"Sample Connecting Role 3 Skills and Experiences Required to Gain"]
[null,"Sample Connecting Role 4","Sample Connecting Role 4 Description",null,"Sample Connecting Role 4 Skills and Experiences Required to Gain"]

{"sheet":"Career Path Template","index":2,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[[16,9,16,11],[16,5,16,7],[18,5,18,7],[16,1,16,3],[11,1,11,3],[11,5,11,7],[11,9,11,11],[12,1,12,3],[12,5,12,7],[12,9,12,11],[15,9,15,11],[15,5,15,7],[15,1,15,3],[14,9,14,11],[14,5,14,7],[14,1,14,3],[8,5,8,7],[10,1,10,3],[10,5,10,7],[10,9,10,11],[0,0,0,14],[2,1,2,11]]}
["Career Path Template"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IFERROR(('Role Organization Template'!C8),\" \")","v":"Sample Aspired Future Role (Long-term)"}]
[]
[null," -- Select Connecting Role --",null,null,null," -- Select Connecting Role --",null,null,null," -- Select Connecting Role Dropdown --"]
[null,{"$f":"IFERROR(VLOOKUP(B11,B52:D69,2,FALSE),\" \")","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(F11,B52:D69,2,FALSE),\" \")","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(J11,B52:D69,2,FALSE),\" \")","v":" "}]
[null,{"$f":"IFERROR(VLOOKUP(B11,B52:D69,3,FALSE),\" \")","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(F11,B52:D69,3,FALSE),\" \")","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(J11,B52:D69,3,FALSE),\" \")","v":" "}]
[]
[null," -- Select Connecting Role Dropdown --",null,null,null,"Sample Connecting Role 5",null,null,null," -- Select Connecting Role Dropdown --"]
[null,{"$f":"IFERROR(VLOOKUP(B15,B52:D69,2,FALSE),\" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(F15,B52:D69,2,FALSE),\" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(J15,B52:D69,2,FALSE),\" \")","v":" "}]
[null,{"$f":"IFERROR(VLOOKUP(B15,B52:D69,3,FALSE),\" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(F15,B52:D69,3,FALSE),\" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(J15,B52:D69,3,FALSE),\" \")","v":" "}]
[]
[null,null,null,null,null,{"$f":"IFERROR(('Role Organization Template'!C10),\" \")","v":"Sample Entry-Level (Current Role)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Skills/Experiences Gained During this Position Required for Destination Role","Skills/Experiences Gained During this Position Required for Destination Role","Brief Description of Connecting Role",null,"IRList"]
[{"$f":"IF(B52=0,\"\",MAX($A$51:A51)+1)","v":1}," -- Select Connecting Role --",null,null,null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":" -- Select Connecting Role --"}]
[{"$f":"IF(B53=0,\"\",MAX($A$51:A52)+1)","v":2},{"$f":"'Role Organization Template'!B15","v":"Sample Connecting Role 1"},{"$f":"'Role Organization Template'!E15","v":"Sample Connecting Role 1 Skills and Experiences Required to Gain"},{"$f":"IFERROR(('Role Organization Template'!C15),\" \")","v":"Sample Connecting Role 1 Description"},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":"Sample Connecting Role 1"}]
[{"$f":"IF(B54=0,\"\",MAX($A$51:A53)+1)","v":3},{"$f":"'Role Organization Template'!B16","v":"Sample Connecting Role 2"},{"$f":"'Role Organization Template'!E16","v":"Sample Connecting Role 2 Skills and Experiences Required to Gain"},{"$f":"IFERROR(('Role Organization Template'!C16),\" \")","v":"Sample Connecting Role 2 Description"},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":"Sample Connecting Role 2"}]
[{"$f":"IF(B55=0,\"\",MAX($A$51:A54)+1)","v":4},{"$f":"'Role Organization Template'!B17","v":"Sample Connecting Role 3"},{"$f":"'Role Organization Template'!E17","v":"Sample Connecting Role 3 Skills and Experiences Required to Gain"},{"$f":"IFERROR(('Role Organization Template'!C17),\" \")","v":"Sample Connecting Role 3 Description"},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":"Sample Connecting Role 3"}]
[{"$f":"IF(B56=0,\"\",MAX($A$51:A55)+1)","v":5},{"$f":"'Role Organization Template'!B18","v":"Sample Connecting Role 4"},{"$f":"'Role Organization Template'!E18","v":"Sample Connecting Role 4 Skills and Experiences Required to Gain"},{"$f":"IFERROR(('Role Organization Template'!C18),\" \")","v":"Sample Connecting Role 4 Description"},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":"Sample Connecting Role 4"}]
[{"$f":"IF(B57=0,\"\",MAX($A$51:A56)+1)","v":""},{"$f":"'Role Organization Template'!B19","v":0},{"$f":"'Role Organization Template'!E19","v":0},{"$f":"IFERROR(('Role Organization Template'!C19),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B58=0,\"\",MAX($A$51:A57)+1)","v":""},{"$f":"'Role Organization Template'!B20","v":0},{"$f":"'Role Organization Template'!E20","v":0},{"$f":"IFERROR(('Role Organization Template'!C20),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B59=0,\"\",MAX($A$51:A58)+1)","v":""},{"$f":"'Role Organization Template'!B21","v":0},{"$f":"'Role Organization Template'!E21","v":0},{"$f":"IFERROR(('Role Organization Template'!C21),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B60=0,\"\",MAX($A$51:A59)+1)","v":""},{"$f":"'Role Organization Template'!B22","v":0},{"$f":"'Role Organization Template'!E22","v":0},{"$f":"IFERROR(('Role Organization Template'!C22),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B61=0,\"\",MAX($A$51:A60)+1)","v":""},{"$f":"'Role Organization Template'!B23","v":0},{"$f":"'Role Organization Template'!E23","v":0},{"$f":"IFERROR(('Role Organization Template'!C23),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B62=0,\"\",MAX($A$51:A61)+1)","v":""},{"$f":"'Role Organization Template'!B24","v":0},{"$f":"'Role Organization Template'!E24","v":0},{"$f":"IFERROR(('Role Organization Template'!C24),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B63=0,\"\",MAX($A$51:A62)+1)","v":""},{"$f":"'Role Organization Template'!B25","v":0},{"$f":"'Role Organization Template'!E25","v":0},{"$f":"IFERROR(('Role Organization Template'!C25),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B64=0,\"\",MAX($A$51:A63)+1)","v":""},{"$f":"'Role Organization Template'!B26","v":0},{"$f":"'Role Organization Template'!E26","v":0},{"$f":"IFERROR(('Role Organization Template'!C26),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B65=0,\"\",MAX($A$51:A64)+1)","v":""},{"$f":"'Role Organization Template'!B27","v":0},{"$f":"'Role Organization Template'!E27","v":0},{"$f":"IFERROR(('Role Organization Template'!C27),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B66=0,\"\",MAX($A$51:A65)+1)","v":""},{"$f":"'Role Organization Template'!B28","v":0},{"$f":"'Role Organization Template'!E28","v":0},{"$f":"IFERROR(('Role Organization Template'!C28),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B67=0,\"\",MAX($A$51:A66)+1)","v":""},{"$f":"'Role Organization Template'!B29","v":0},{"$f":"'Role Organization Template'!E29","v":0},{"$f":"IFERROR(('Role Organization Template'!C29),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B68=0,\"\",MAX($A$51:A67)+1)","v":""},{"$f":"'Role Organization Template'!B30","v":0},{"$f":"'Role Organization Template'!E30","v":0},{"$f":"IFERROR(('Role Organization Template'!C30),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]
[{"$f":"IF(B69=0,\"\",MAX($A$51:A68)+1)","v":""},{"$f":"'Role Organization Template'!B32","v":0},{"$f":"'Role Organization Template'!E32","v":0},{"$f":"IFERROR(('Role Organization Template'!C32),\" \")","v":0},null,{"$f":"IFERROR(INDEX(B52:B69,MATCH(ROW()-ROW(F51),A52:A69,0)),\"\")","v":""}]

{"sheet":"IDP Template","index":3,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[14,2,14,3],[15,2,15,3],[7,7,7,8],[9,7,9,8],[26,0,26,8],[0,0,0,8],[23,0,23,8],[24,0,24,8],[25,0,25,8],[16,2,16,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[7,2,7,3],[9,2,9,3],[13,2,13,3]]}
["Individual Development Plan Template"]
[]
[]
[]
[]
[null,"Career Goals"]
[]
[null,"Aspired Future Role \n(>9 years timeline)","Sample Aspired Future Role (Long-term)",null,null,null,"Name of Mentor ","(If none, indicate name of proposed mentor)"]
[]
[null,"Current Role ","Sample Entry-Level / Current Role ",null,null,null,"Mentor's Company, Department, \nand Position","Mentor's Company, Department, \nand Position"]
[]
[null,"Development Plan for Current Role (1-3 years)"]
[]
[null,"Development Area/s","Development Objectives",null,"Development Type",null,"Development Details/ Action Items / Milestones","Target Completion Date","Status"]
[null,"Sample Current Role Development Area 1","Sample Current Role Development Objectives - 1",null,"70% Experience (OJT/ Immersion/ Projects/ Secondment)",null,null,null,"Not Started"]
[null,"Sample Current Role Development Area 2","Sample Current Role Development Objectives - 2",null,"20% Exposure (Coaching/ Mentoring/ Networking/ Conferences)",null,null,null,"Not Started"]
[null,"Sample Current Role Development Area 3","Sample Current Role Development Objectives - 3",null,"10% Education (Training Courses/ Workshops/ Books)",null,null,null,"Not Started"]
[null,"Development Plan for Aspired Future Role - Long-Term (3 - 9 years)"]
[null,"Sample Future Role Development Area 1","Sample Future Role Development Objectives -1",null,"70% Experience (OJT/ Immersion/ Projects/ Secondment)",null,null,null,"Not Started"]
[null,"Sample Future Role Development Area 2","Sample Future Role Development Objectives -2",null,"20% Exposure (Coaching/ Mentoring/ Networking/ Conferences)",null,null,null,"Not Started"]
[null,"Sample Future Role Development Area 3","Sample Future Role Development Objectives -3",null,"10% Education (Training Courses/ Workshops/ Books)",null,null,null,"Not Started"]
[]
["Development Results (To be discussed during annual Performance Management End Cycle)"]
["1. Were the development objectives achieved this year?"]
["2. How was it applied on the job?\n"]
["3. How did it contribute to personal/ team/ organizational goals?\n"]
["Overall Feedback:"]
[null,"Agreed by / between:"]
[]
[null,"Name of Team Member ","Date",null,"Name of Immediate Supervisor",null,"Date"]

{"sheet":"Talent Profile","index":4,"n_rows":61,"n_cols":46,"rows_kept":61,"cut":false,"hidden":false,"merged":[[43,2,43,20],[43,21,43,33],[43,34,43,42],[43,43,43,51],[44,2,44,20],[44,21,44,33],[44,34,44,42],[44,43,44,51],[52,2,52,51],[56,2,56,51],[45,2,45,20],[45,21,45,33],[45,34,45,42],[45,43,45,51],[46,2,46,20],[46,21,46,33],[46,34,46,42],[46,43,46,51],[50,2,50,51],[59,2,59,51],[40,2,40,20],[40,21,40,33],[40,34,40,42],[40,43,40,51],[42,2,42,20],[42,21,42,33],[42,34,42,42],[42,43,42,51],[41,2,41,20],[41,21,41,33],[41,34,41,42],[41,43,41,51],[38,2,38,20],[38,21,38,33],[38,34,38,42],[38,43,38,51],[39,2,39,20],[39,21,39,33],[39,34,39,42],[39,43,39,51],[36,2,36,20],[36,21,36,33],[36,34,36,42],[36,43,36,51],[37,2,37,20],[37,21,37,33],[37,34,37,42],[37,43,37,51],[35,2,35,20],[35,21,35,33],[35,34,35,42],[35,43,35,51],[27,17,27,26],[27,42,27,50],[28,17,28,24],[28,42,28,51],[29,17,29,24],[29,42,29,51],[32,2,32,51],[33,2,33,20],[33,21,33,33],[33,34,33,42],[33,43,33,51],[23,2,23,17],[23,18,23,33],[23,34,23,44],[23,45,23,51],[26,17,26,26],[26,42,26,51],[8,3,10,35],[8,38,16,49],[12,17,12,35],[14,17,14,35],[16,17,16,35],[55,2,55,51],[20,2,20,17],[20,18,20,33],[20,34,20,44],[20,45,20,51],[21,2,21,17],[21,18,21,33],[21,34,21,44],[21,45,21,51],[22,2,22,17],[22,18,22,33],[22,34,22,44],[22,45,22,51]]}
[]
[]
[]
[]
[]
[]
[null,null,"Profile XXX-XXXXX"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert your Corporate Picture 2x2"]
[]
[]
[]
[null,null,null,"Current Position:"]
[]
[null,null,null,"Level :"]
[]
[null,null,null,"Area of Assignment :"]
[]
[]
[null,null,"Educational Attainment"]
[null,null,"Qualification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Institution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year Graduated",null,null,null,null,null,null,null,null,null,null,"Awards"]
[]
[]
[]
[]
[null,null,"Job Information"]
[null,null,"AG Joining Date",null,null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Age",null,null,null,":"]
[null,null,"Total AG Tenure",null,null,null,null,null,null,null,null,null,null,null,null,null,":",null,null,null,null,null,null,null,null,null,null,"Years until Retirement"]
[null,null,null,null,"Current AG Company",null,null,null,null,null,null,null,null,null,null,null,":",null,null,null,null,null,null,null,null,null,null,null,null,"Regular Retirement",null,null,null,null,null,null,null,null,null,null,null,":"]
[null,null,null,null,"Other AG Companies",null,null,null,null,null,null,null,null,null,null,null,":",null,null,null,null,null,null,null,null,null,null,null,null,"Special Program",null,null,null,null,null,null,null,null,null,null,null,":"]
[]
[]
[null,null,"Employment / Promotion History"]
[null,null,"Position Title ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company",null,null,null,null,null,null,null,null,null,null,null,null,"Start Date",null,null,null,null,null,null,null,null,"End Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Performance Evaluation"]
[null,null,"Career Achievements"]
[]
[null,null,"Strengths / Skills"]
[]
[null,null,"Career Goals"]
[null,null,"Indicate specific targets and development plans for any options below:"]
[null,null,"Short-Term Career Goal (1 - 3 years)"]
[null,null,"Long-Term Career Goal (4 - 9 years)"]
[null,null,"Developmental Plans"]
[null,null,"Development Area and Plan for Current Role (in the next 1-3 years)"]
[]
[null,null,"Development Area and Plan for Aspired Future Role (in the next 4 - 9 years)"]

{"sheet":"Formulas","index":5,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Emp #"]
[null,"Name"]
[null,"Position"]
[null,"Band Level"]
[null,"AO Assignment"]
[]
[null,"Personal Information"]
[null,"Birthday","12/23/1981","<--Input Here"]
[null,"Age",{"$f":"DATEDIF(C10,C17,\"y\") & \" years \" & DATEDIF(C10,C17,\"ym\") & \" mo(s)\"","v":{"$error":"#VALUE!"}}]
[null,"Years Before Retirement",{"$f":"YEAR(C18)-YEAR(C17)","v":{"$error":"#VALUE!"}}]
[null,"Rule of 80",{"$f":"((DATEDIF(C10,C17,\"y\"))+(DATEDIF(C15,C17,\"y\")))","v":{"$error":"#VALUE!"}}]
[null,"Years Before Rule of 80",{"$f":"(80-C13)/2","v":{"$error":"#VALUE!"}}]
[null,"Start Date","2009-01-01","<--Input Here"]
[null,"Total Tenure in AG",{"$f":"DATEDIF(C15,C17,\"y\") & \" yrs \" & DATEDIF(C15,C17,\"ym\") & \" mo(s)\"","v":"14 yrs 4 mo(s)"}]
[null,"Cut-Off Date","2023-05-10","<--Input Here"]
[null,"Retirement Date",{"$f":"DATE(YEAR(C10)+60,MONTH(C10),DAY(C10))","v":{"$error":"#VALUE!"}}]