{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CompleteThisTab","Heatmap"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"CompleteThisTab","index":0,"n_rows":40,"n_cols":25,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,21,5,23],[5,2,5,4],[5,5,5,7],[5,10,5,12],[5,13,5,15],[5,18,5,20]]}
[null,null,1,2,3,4,5,6,null,null,1,2,3,4,5,6,null,null,1,2,3,4,5,6]
[]
[null,"Go along each row and click into the cell. You'll see some text and all you have to do is select the cell which is most appropriate to your situation. This will automatically populate your HR Heatmap"]
[]
[]
[null,null,"Offline system",null,null,"Online solution",null,null,null,null,"Offline system",null,null,"Online solution",null,null,null,null,"Offline system",null,null,"Online solution"]
[null,null,"q","u","p","q","u","p",null,null,"q","u","p","q","u","p",null,null,"q","u","p","q","u","p"]
[null,"Recruitment",null,null,null,null,null,null,null,"Person & Organisation",null,null,null,null,null,null,null,"Attendance & Absence"]
[null,"Initiate vacancy",1,null,null,null,null,null,{"$f":"MAX(C9:H9)","v":1},"New starter",null,null,null,null,null,6,{"$f":"MAX(K9:P9)","v":6},"Time recording",null,null,null,null,null,6,{"$f":"MAX(S9:X9)","v":6}]
[null,"Apply",1,null,null,null,null,null,{"$f":"MAX(C10:H10)","v":1},"Assignments",null,null,null,4,null,null,{"$f":"MAX(K10:P10)","v":4},"Planned absence",null,null,null,null,5,null,{"$f":"MAX(S10:X10)","v":5}]
[null,"Screen applicants",1,null,null,null,null,null,1,"Movers",null,null,null,4,null,null,4,"Unplanned absence",null,null,null,null,5,null,5]
[null,"Select candidate",1,null,null,null,null,null,1,"Leavers",null,null,null,null,5,null,5,"Authorise payable time",null,null,null,null,5,null,5]
[null,"Make offer",null,null,null,null,null,6,6,"Structure changes",null,null,null,4,null,null,4,"Manage long term absence",null,null,null,null,null,6,6]
[null,"Hire",1,null,null,null,null,null,1,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,"On-board",1,null,null,null,null,null,1,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,"Training & Development",null,null,null,null,null,null,0,"Employee Relations",null,null,null,null,null,null,0,"Compensation & Benefits",null,null,null,null,null,null,0]
[null,"Design training",null,null,null,null,null,6,6,"Grievance",null,null,null,null,null,6,6,"Reward planning & management",1,null,null,null,null,null,1]
[null,"Plan training",null,null,null,null,null,6,6,"Disciplinary",null,null,null,null,null,6,6,"Salary review",null,2,null,null,null,null,2]
[null,"Enrol on training",null,null,null,4,null,null,4,"Appeals",null,null,null,null,5,null,5,"Manage benefits",null,null,3,null,null,null,3]
[null,"Complete training",null,null,null,4,null,null,4,"Manage tribunals / compromise",null,null,null,null,null,6,6,"Manage bonus incentives",null,null,null,null,null,6,6]
[null,"Manage training records",null,null,null,4,null,null,4,"Employee engagement",null,null,null,null,null,6,6,"Manage pensions",null,null,null,null,5,null,5]
[null,"Manage development programmes",null,null,null,4,null,null,4,"Manage union relationships",null,null,null,null,5,null,5,null,null,null,null,null,null,null,0]
[null,"Complete induction",null,null,null,4,null,null,4,"Incident management",null,null,null,null,null,6,6,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,"Performance Management",null,null,null,null,null,null,0,"Scheduling",null,null,null,null,null,null,0,"Manage Payroll",null,null,null,null,null,null,0]
[null,"Set objectives / PDP",null,null,3,null,null,null,3,"Forecast demand",null,null,null,null,null,6,6,"Manage deductions",1,null,null,null,null,null,1]
[null,"Review performance",null,null,3,null,null,null,3,"Workload modelling",1,null,null,null,null,null,1,"Manage payments",null,2,null,null,null,null,2]
[null,"Manage talent",null,null,3,null,null,null,3,"Maintain availability",null,null,3,null,null,null,3,"Run payroll",null,null,3,null,null,null,3]
[null,"Succession planning",null,null,3,null,null,null,3,"Create schedule",null,null,3,null,null,null,3,"Generate pay",null,null,null,4,null,null,4]
[null,"Promotions",null,null,3,null,null,null,3,"Maintain schedule",null,null,3,null,null,null,3,"Manage HMRC",null,null,null,null,5,null,5]
[null,"Continuous feedback",null,null,3,null,null,null,3,"Execution",1,null,null,null,null,null,1,"Manage expenses",null,null,null,null,null,6,6]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,"Run end of year",1,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,"AI Productivity Assistant"]
[null,null,null,null,null,null,null,null,null,"Content Generation",1,null,null,null,null,null,{"$f":"MAX(K36:P36)","v":1}]
[null,null,null,null,null,null,null,null,null,"Document store / search",null,2,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Employee Assistant",null,null,3,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Manager Assistant",null,null,null,4,null,null,4]
[null,null,null,null,null,null,null,null,null,"HR Admin Assistant",null,null,null,null,5,null,5]

{"sheet":"Heatmap","index":1,"n_rows":13,"n_cols":32,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,19]]}
[]
[null,"HR Heatmap"]
[null,"Recruitment",null,"Training & Development",null,"Performance Management",null,"Person & Organisation",null,"Employee Relations",null,"Scheduling",null,"Attendance & Absence",null,"Compensation & Benefits",null,"Manage Payroll",null,"AI Productivity Assistant"]
[]
[null,{"$f":"W5","v":0.2857142857142857},null,{"$f":"X5","v":0.76190476190476186},null,{"$f":"Y5","v":0.5},null,{"$f":"Z5","v":0.76666666666666672},null,{"$f":"AA5","v":0.95238095238095233},null,{"$f":"AB5","v":0.47222222222222221},null,{"$f":"AC5","v":0.9},null,{"$f":"AD5","v":0.56666666666666665},null,{"$f":"AE5","v":0.52380952380952384},null,{"$f":"AF5","v":0.5},null,null,{"$f":"SUM(W7:W13)/(COUNTIF(W7:W13,\">0\")*6)","v":0.2857142857142857},{"$f":"SUM(X7:X13)/(COUNTIF(X7:X13,\">0\")*6)","v":0.76190476190476186},0.5,0.76666666666666672,0.95238095238095233,0.47222222222222221,0.9,0.56666666666666665,0.52380952380952384,0.5]
[]
[null,"Initiate vacancy",null,"Design training",null,"Set objectives / PDP",null,"New starter",null,"Grievance",null,"Forecast demand",null,"Time recording",null,"Reward planning & management",null,"Manage deductions",null,"Content Generation",null,null,{"$f":"_xlfn.IFNA(VLOOKUP(B7,CompleteThisTab!$B:$I,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(D7,CompleteThisTab!$B:$I,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(F7,CompleteThisTab!$B:$I,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(H7,CompleteThisTab!$J:$Q,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(J7,CompleteThisTab!$J:$Q,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(L7,CompleteThisTab!$J:$Q,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(N7,CompleteThisTab!$R:$Y,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(P7,CompleteThisTab!$R:$Y,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(R7,CompleteThisTab!$R:$Y,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(T7,CompleteThisTab!$J:$Q,8,0),0)","v":1}]
[null,"Apply",null,"Plan training",null,"Review performance",null,"Assignments",null,"Disciplinary",null,"Workload modelling",null,"Planned absence",null,"Salary review",null,"Manage payments",null,"Document store / search",null,null,{"$f":"_xlfn.IFNA(VLOOKUP(B8,CompleteThisTab!$B:$I,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(D8,CompleteThisTab!$B:$I,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(F8,CompleteThisTab!$B:$I,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(H8,CompleteThisTab!$J:$Q,8,0),0)","v":4},{"$f":"_xlfn.IFNA(VLOOKUP(J8,CompleteThisTab!$J:$Q,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(L8,CompleteThisTab!$J:$Q,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(N8,CompleteThisTab!$R:$Y,8,0),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(P8,CompleteThisTab!$R:$Y,8,0),0)","v":2},{"$f":"_xlfn.IFNA(VLOOKUP(R8,CompleteThisTab!$R:$Y,8,0),0)","v":2},{"$f":"_xlfn.IFNA(VLOOKUP(T8,CompleteThisTab!$J:$Q,8,0),0)","v":2}]
[null,"Screen applicants",null,"Enrol on training",null,"Manage talent",null,"Movers",null,"Appeals",null,"Maintain availability",null,"Unplanned absence",null,"Manage benefits",null,"Run payroll",null,"Employee Assistant",null,null,{"$f":"_xlfn.IFNA(VLOOKUP(B9,CompleteThisTab!$B:$I,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(D9,CompleteThisTab!$B:$I,8,0),0)","v":4},{"$f":"_xlfn.IFNA(VLOOKUP(F9,CompleteThisTab!$B:$I,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(H9,CompleteThisTab!$J:$Q,8,0),0)","v":4},{"$f":"_xlfn.IFNA(VLOOKUP(J9,CompleteThisTab!$J:$Q,8,0),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(L9,CompleteThisTab!$J:$Q,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(N9,CompleteThisTab!$R:$Y,8,0),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(P9,CompleteThisTab!$R:$Y,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(R9,CompleteThisTab!$R:$Y,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(T9,CompleteThisTab!$J:$Q,8,0),0)","v":3}]
[null,"Select candidate",null,"Complete training",null,"Succession planning",null,"Leavers",null,"Manage tribunals / compromise",null,"Create schedule",null,"Authorise payable time",null,"Manage bonus incentives",null,"Generate pay",null,"Manager Assistant",null,null,{"$f":"_xlfn.IFNA(VLOOKUP(B10,CompleteThisTab!$B:$I,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(D10,CompleteThisTab!$B:$I,8,0),0)","v":4},{"$f":"_xlfn.IFNA(VLOOKUP(F10,CompleteThisTab!$B:$I,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(H10,CompleteThisTab!$J:$Q,8,0),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(J10,CompleteThisTab!$J:$Q,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(L10,CompleteThisTab!$J:$Q,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(N10,CompleteThisTab!$R:$Y,8,0),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(P10,CompleteThisTab!$R:$Y,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(R10,CompleteThisTab!$R:$Y,8,0),0)","v":4},{"$f":"_xlfn.IFNA(VLOOKUP(T10,CompleteThisTab!$J:$Q,8,0),0)","v":4}]
[null,"Make offer",null,"Manage training records",null,"Promotions",null,"Structure changes",null,"Employee engagement",null,"Maintain schedule",null,"Manage long term absence",null,"Manage pensions",null,"Manage HMRC",null,"HR Admin Assistant",null,null,{"$f":"_xlfn.IFNA(VLOOKUP(B11,CompleteThisTab!$B:$I,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(D11,CompleteThisTab!$B:$I,8,0),0)","v":4},{"$f":"_xlfn.IFNA(VLOOKUP(F11,CompleteThisTab!$B:$I,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(H11,CompleteThisTab!$J:$Q,8,0),0)","v":4},{"$f":"_xlfn.IFNA(VLOOKUP(J11,CompleteThisTab!$J:$Q,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(L11,CompleteThisTab!$J:$Q,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(N11,CompleteThisTab!$R:$Y,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(P11,CompleteThisTab!$R:$Y,8,0),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(R11,CompleteThisTab!$R:$Y,8,0),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(T11,CompleteThisTab!$J:$Q,8,0),0)","v":5}]
[null,"Hire",null,"Manage development programmes",null,"Continuous feedback",null,null,null,"Manage union relationships",null,"Execution",null,null,null,null,null,"Manage expenses",null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(B12,CompleteThisTab!$B:$I,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(D12,CompleteThisTab!$B:$I,8,0),0)","v":4},{"$f":"_xlfn.IFNA(VLOOKUP(F12,CompleteThisTab!$B:$I,8,0),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(H12,CompleteThisTab!$J:$Q,8,0),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(J12,CompleteThisTab!$J:$Q,8,0),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(L12,CompleteThisTab!$J:$Q,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(N12,CompleteThisTab!$R:$Y,8,0),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(P12,CompleteThisTab!$R:$Y,8,0),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(R12,CompleteThisTab!$R:$Y,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(T12,CompleteThisTab!$J:$Q,8,0),0)","v":0}]
[null,"On-board",null,"Complete induction",null,null,null,null,null,"Incident management",null,null,null,null,null,null,null,"Run end of year",null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(B13,CompleteThisTab!$B:$I,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(D13,CompleteThisTab!$B:$I,8,0),0)","v":4},{"$f":"_xlfn.IFNA(VLOOKUP(F13,CompleteThisTab!$B:$I,8,0),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(H13,CompleteThisTab!$J:$Q,8,0),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(J13,CompleteThisTab!$J:$Q,8,0),0)","v":6},{"$f":"_xlfn.IFNA(VLOOKUP(L13,CompleteThisTab!$J:$Q,8,0),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(N13,CompleteThisTab!$R:$Y,8,0),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(P13,CompleteThisTab!$R:$Y,8,0),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(R13,CompleteThisTab!$R:$Y,8,0),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(T13,CompleteThisTab!$J:$Q,8,0),0)","v":0}]