{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Lists","HR","Staff","Calcs","Chart","Summary"],"not_rendered":{"charts":11,"images":20,"macros":1,"external_links":0,"defined_names":33,"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":"Lists","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["List of Areas","Actual","Months","Menu"]
["Group","Budget","Jan","IT"]
["England","Forecast 1","Feb","Finance"]
["Scotland","Forecast 2","Mar","HR"]
["Wales","Forecast 3","Apr","Strategy"]
["Northern Ireland",null,"May"]
[null,null,"Jun"]
[null,null,"Jul"]
[null,null,"Aug"]
[null,null,"Sep"]
[null,null,"Oct"]
[null,null,"Nov"]
[null,null,"Dec"]

{"sheet":"HR","index":1,"n_rows":17,"n_cols":45,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Region","City","FTEs","Overtime Hrs","Avg Svs Length","Avg Salary","Avg Bonus","Avg Overtime","AvgLeave Balance","Spend Per Hire","Survey Q1","Survey Q2","Survey Q3","Survey Q4"," Train Q1"," Train Q2"," Train Q3"," Train Q4","Gender FM % Q1","Gender FM % Q2","Gender FM % Q3","Gender FM % Q4","Rating Q1","Rating Q2","Rating Q3","Rating Q4","FTE/Contractor Q1","FTE/Contractor Q2","FTE/Contractor Q3","FTE/Contractor Q4","Overtime Hrs Q1","Overtime Hrs Q2","Overtime Hrs Q3","Overtime Hrs Q4","FTE Q1","FTE Q2","FTE Q3","FTE Q4","Open Positions","Avg Perf Score","19-25","26-35","36-45","46-55","55+"]
["England","IT",108,976,3.5,65455,{"$f":"F2*10.5%","v":6872.7749999999996},3272.75,22,8692.44,25,45,55,76,40,{"$f":"ROUNDUP(L2*1.1,0)","v":50},{"$f":"ROUNDUP(M2*1.1,0)","v":61},84,10,15,20,18,3.3,3.5,3.5,3.7,40,30,24,27,976,642.22222222222229,625.4545454545455,552.63157894736855,108,144,150,156,17,4.5,21.6,32.4,32.4,10.8,10.8]
["England","Finance",55,433,2.4,48978,{"$f":"F3*10.5%","v":5142.6899999999996},979.56000000000006,32,3144.85,27,39,55,78,44,47,{"$f":"ROUNDUP(M3*1.1,0)","v":61},{"$f":"ROUNDUP(N3*1.1,0)","v":86},50,50,42,45,4,4,4.0999999999999996,4.2,53,56,67,63,433,399.76923076923077,383.4727272727273,370.39743589743591,55,53,45,48,12,4.3,13.75,6.6,11,12.1,11.549999999999997]
["England","HR",33,200,4.8,46550,4887.75,931,15,6547.41,35,{"$f":"K4+10","v":45},{"$f":"L4+10","v":55},{"$f":"M4+10","v":65},{"$f":"ROUNDUP(K4*1.1,0)","v":39},{"$f":"ROUNDUP(L4*1.1,0)","v":50},61,72,80,72,77,70,4.2,4,3.8,3.7,91,92,95,99,200,255.55555555555557,309.09090909090912,361.53846153846155,33,30,32,31,7,4.2,2.64,6.6000000000000005,6.2700000000000005,4.62,12.869999999999997]
["England","Strategy",43,187,5.3,49864,5235.72,2493.2000000000003,6,5604.52,18,{"$f":"K5+10","v":28},38,48,20,31,42,53,55,60,65,60,4.8,4.5,4.3,4.5,80,77,72,78,187,220.21428571428572,262.26315789473688,307.625,43,45,45,42,4,4.0999999999999996,14.190000000000001,12.469999999999999,3.0100000000000002,3.8699999999999997,9.4600000000000044]
["Scotland","IT",33,198,6.8,41234,4329.57,2886.38,17,7680,30,{"$f":"K6+10","v":40},50,60,33,44,55,66,20,25,28,30,4.2,4,4.0999999999999996,4.4000000000000004,35,31,28,27,198,248.5,298.8,349,33,38,35,30,6,4,8.91,3.3000000000000003,4.95,2.64,13.200000000000001]
["Scotland","Finance",23,133,5.9,37886,3978.0299999999997,5682.9,28,4678,45,{"$f":"K7+10","v":55},65,75,50,61,72,83,45,30,35,30,3.7,3.6,3.4,3.2,45,71,62,72,133,208.81818181818181,276.69230769230768,339.79999999999995,23,15,18,16,5,3.4,4.1399999999999997,2.99,5.52,7.5900000000000007,2.7599999999999971]
["Scotland","HR",13,87,3.8,35985,3778.4249999999997,719.7,15,3790,70,77,88,{"$f":"M8+10","v":98},77,85,97,108,67,67,70,72,4.3,4,4.2,4.0999999999999996,85,88,85,83,87,179.09090909090909,256.7045454545455,330.51020408163265,13,13,14,13,4,3.8,2.4700000000000002,2.21,1.43,1.3,5.5900000000000007]
["Scotland","Strategy",12,90,2.9,33459,3513.1949999999997,1672.95,28,5789,33,{"$f":"K9+10","v":43},77,86,37,48,85,95,54,54,57,59,4,3.8,4,4.2,80,83,79,77,90,169.06976744186045,194.41558441558442,274.06976744186045,12,12,13,13,3,3.6,0.96,2.52,3.5999999999999996,3.5999999999999996,1.3200000000000012]
["Wales","IT",58,236,1.8,28567,2999.5349999999999,285.67,21,6787,35,{"$f":"K10+10","v":45},60,{"$f":"M10+10","v":70},39,50,66,77,42,42,40,40,2.8,3,3.5,3.3,43,46,49,49,236,283.55555555555554,312.66666666666663,367.99999999999994,58,55,52,52,6,3.9,17.399999999999999,4.6399999999999997,6.38,6.38,23.200000000000003]
["Wales","Finance",35,177,4.9000000000000004,29889,3138.3449999999998,2092.23,12,4567,25,{"$f":"K11+10","v":35},66,70,28,39,73,77,45,45,50,53,3.7,3.9,3.4,3.2,53,56,51,49,177,226.42857142857144,220.07575757575756,307.5,35,34,28,29,5,4.3,10.85,9.1,4.2,7.7,3.149999999999999]
["Wales","HR",16,88,3,31009,3255.9449999999997,2170.63,18,3896,25,50,73,{"$f":"M12+10","v":83},28,55,81,92,21,21,25,29,4,3,3.5,3.9,93,96,82,72,88,144,198.63013698630135,274.69879518072287,16,16,18,21,3,3.7,4.8,1.76,4.4800000000000004,2.88,2.0800000000000018]
["Wales","Strategy",9,34,2,27056,2840.88,270.56,23,2978,25,60,{"$f":"L13+10","v":70},88,28,66,77,97,59,61,63,60,4.2,4.8,4.0999999999999996,4.4000000000000004,88,89,87,92,34,114.16666666666667,197.85714285714286,257.38636363636363,9,8,9,7,2,4.5,1.53,2.34,1.89,1.98,1.2600000000000002]
["Northern Ireland","IT",44,184,3.9,36789,3862.8449999999998,1839.45,19,3890,18,40,50,80,{"$f":"ROUNDUP(K14*1.3,0)","v":24},{"$f":"ROUNDUP(L14*1.3,0)","v":52},{"$f":"ROUNDUP(M14*1.3,0)","v":65},88,8,12,15,18,3,3.5,3.6,3.4,50,37,31,27,184,182.8,246.24,253.9,44,45,44,40,4,4,8,15,14,6,1.2]
["Northern Ireland","Finance",21,104,6.7,29889,3138.3449999999998,2690.0099999999998,9,4671,50,70,80,99,65,91,94,98,45,45,50,45,3.7,3.5,3.9,3.7,60,63,57,63,104,174.28571428571428,252.5,304.04040404040404,21,20,23,21,1,3.1,5.8800000000000008,1.89,2.31,4.83,6.0900000000000007]
["Northern Ireland","HR",8,65,4.5999999999999996,32029,3363.0450000000001,4804.3499999999995,12,5467,25,50,66,{"$f":"M16+10","v":76},33,65,86,{"$f":"ROUNDUP(N16*1.3,0)","v":99},67,70,65,63,3.8,4,4,4.0999999999999996,100,99,100,100,65,132.5,200.37878787878788,274.01315789473688,8,9,9,9,1,3,2,2,3,1,0]
["Northern Ireland","Strategy",7,54,5,27998,2939.79,1959.8600000000001,15,4925,10,{"$f":"K17+10","v":20},30,60,{"$f":"ROUNDUP(K17*1.3,0)","v":13},{"$f":"ROUNDUP(L17*1.3,0)","v":26},39,78,59,59,67,67,3,3.2,3.4,3.6,95,98,87,87,54,127,184.66666666666666,192.33333333333331,7,7,8,8,2,3.1,0.84,1.9600000000000002,1.26,2.4499999999999997,0.48999999999999966]

{"sheet":"Staff","index":2,"n_rows":121,"n_cols":7,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
["Region","Month","Consultants","Open Positions","Casual Staff","Termination","New Hires"]
["England","2012-01-01",87,33,27,-3,2]
["England","2012-02-01",93,34,28,-4,1]
["England","2012-03-01",80,34,24,-2,4]
["England","2012-04-01",74,31,23,-1,2]
["England","2012-05-01",70,27,21,-3,2]
["England","2012-06-01",100,42,30,-2,4]
["England","2012-07-01",79,32,24,-1,2]
["England","2012-08-01",98,40,30,-4,8]
["England","2012-09-01",98,36,30,-6,4]
["England","2012-10-01",64,26,20,-5,10]
["England","2012-11-01",82,28,25,0,0]
["England","2012-12-01",97,38,30,0,1]
["England","2013-01-01",58,21,18,-2,7]
["England","2013-02-01",80,31,24,-3,4]
["England","2013-03-01",74,31,23,0,2]
["England","2013-04-01",70,27,21,-3,3]
["England","2013-05-01",87,33,27,-3,3]
["England","2013-06-01",93,34,28,-3,2]
["England","2013-07-01",100,42,30,-3,2]
["England","2013-08-01",58,21,18,-2,4]
["England","2013-09-01",67,26,21,-3,1]
["England","2013-10-01",84,34,26,-3,4]
["England","2013-11-01",75,29,23,-3,1]
["England","2013-12-01",87,35,27,-3,2]
["Scotland","2012-01-01",44,17,14,-2,4]
["Scotland","2012-02-01",47,17,15,-2,1]
["Scotland","2012-03-01",40,17,12,-2,4]
["Scotland","2012-04-01",37,16,12,-2,4]
["Scotland","2012-05-01",27,10,9,-1,2]
["Scotland","2012-06-01",25,10,8,-1,2]
["Scotland","2012-07-01",21,7,7,-1,2]
["Scotland","2012-08-01",13,5,4,-4,8]
["Scotland","2012-09-01",41,15,13,-5,7]
["Scotland","2012-10-01",47,18,15,-2,4]
["Scotland","2012-11-01",59,24,18,-6,9]
["Scotland","2012-12-01",53,20,16,-2,4]
["Scotland","2013-01-01",61,24,19,-2,4]
["Scotland","2013-02-01",69,26,21,-2,4]
["Scotland","2013-03-01",45,18,14,-2,4]
["Scotland","2013-04-01",57,20,18,-5,8]
["Scotland","2013-05-01",68,27,21,-3,2]
["Scotland","2013-06-01",41,15,13,-1,2]
["Scotland","2013-07-01",56,22,17,-1,1]
["Scotland","2013-08-01",44,17,14,-2,4]
["Scotland","2013-09-01",47,17,15,-2,4]
["Scotland","2013-10-01",40,17,12,-2,4]
["Scotland","2013-11-01",37,16,12,-2,4]
["Scotland","2013-12-01",27,10,9,-2,4]
["Wales","2012-01-01",22,9,7,-1,2]
["Wales","2012-02-01",24,9,8,-1,2]
["Wales","2012-03-01",20,9,6,-2,3]
["Wales","2012-04-01",19,8,6,-1,2]
["Wales","2012-05-01",4,3,2,-1,2]
["Wales","2012-06-01",3,1,1,-1,2]
["Wales","2012-07-01",22,10,7,-1,2]
["Wales","2012-08-01",18,7,6,-1,2]
["Wales","2012-09-01",31,12,10,-1,2]
["Wales","2012-10-01",33,12,10,-1,2]
["Wales","2012-11-01",28,12,9,-1,2]
["Wales","2012-12-01",26,11,8,-1,2]
["Wales","2013-01-01",19,7,6,-1,2]
["Wales","2013-02-01",29,11,9,-1,2]
["Wales","2013-03-01",33,13,10,-1,2]
["Wales","2013-04-01",42,17,13,-2,4]
["Wales","2013-05-01",37,14,12,-2,4]
["Wales","2013-06-01",43,17,13,-2,4]
["Wales","2013-07-01",48,18,15,-2,4]
["Wales","2013-08-01",22,9,7,-1,2]
["Wales","2013-09-01",24,9,8,-1,0]
["Wales","2013-10-01",20,9,6,-1,2]
["Wales","2013-11-01",19,8,6,-1,2]
["Wales","2013-12-01",4,3,2,-1,0]
["Northern Ireland","2012-01-01",11,5,4,-1,2]
["Northern Ireland","2012-02-01",12,5,4,-1,2]
["Northern Ireland","2012-03-01",10,5,3,-1,0]
["Northern Ireland","2012-04-01",10,4,3,-1,3]
["Northern Ireland","2012-05-01",17,9,6,-1,2]
["Northern Ireland","2012-06-01",9,6,3,-1,2]
["Northern Ireland","2012-07-01",26,11,8,-1,3]
["Northern Ireland","2012-08-01",23,9,7,-1,2]
["Northern Ireland","2012-09-01",16,6,5,-1,3]
["Northern Ireland","2012-10-01",17,6,6,-1,2]
["Northern Ireland","2012-11-01",14,6,5,-1,1]
["Northern Ireland","2012-12-01",13,6,4,-1,1]
["Northern Ireland","2013-01-01",13,7,4,-1,2]
["Northern Ireland","2013-02-01",8,24,3,-1,2]
["Northern Ireland","2013-03-01",14,9,5,-1,2]
["Northern Ireland","2013-04-01",14,7,5,-1,2]
["Northern Ireland","2013-05-01",12,7,4,-1,3]
["Northern Ireland","2013-06-01",14,5,5,-1,2]
["Northern Ireland","2013-07-01",20,8,6,-1,2]
["Northern Ireland","2013-08-01",11,5,4,-1,2]
["Northern Ireland","2013-09-01",12,5,4,-1,2]
["Northern Ireland","2013-10-01",10,5,3,-1,1]
["Northern Ireland","2013-11-01",10,4,3,-1,2]
["Northern Ireland","2013-12-01",17,9,6,-1,2]
["Group","2012-01-01",null,62,0,0,0]
["Group","2012-02-01",null,64,0,0,0]
["Group","2012-03-01",null,63,0,0,0]
["Group","2012-04-01",null,57,0,0,0]
["Group","2012-05-01",null,46,0,0,0]
["Group","2012-06-01",null,57,0,0,0]
["Group","2012-07-01",null,59,0,0,0]
["Group","2012-08-01",null,59,0,0,0]
["Group","2012-09-01",null,68,0,0,0]
["Group","2012-10-01",null,61,0,0,0]
["Group","2012-11-01",null,69,0,0,0]
["Group","2012-12-01",null,74,0,0,0]
["Group","2013-01-01",null,58,0,0,0]
["Group","2013-02-01",null,89,0,0,0]
["Group","2013-03-01",null,69,0,0,0]
["Group","2013-04-01",null,69,0,0,0]
["Group","2013-05-01",null,80,0,0,0]
["Group","2013-06-01",null,70,0,0,0]
["Group","2013-07-01",null,88,0,0,0]
["Group","2013-08-01",null,50,0,0,0]
["Group","2013-09-01",null,55,0,0,0]
["Group","2013-10-01",null,63,0,0,0]
["Group","2013-11-01",null,55,0,0,0]
["Group","2013-12-01",null,54,0,0,0]

{"sheet":"Calcs","index":3,"n_rows":86,"n_cols":19,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Group",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"INDEX(Lists!$A$3:$A$6,R1,1)","v":"England"}]
["Region","Dept","Category","Survey Q1","Survey Q2","Survey Q3","Survey Q4","Total"]
[{"$f":"Summary!$B$7","v":"England"},{"$f":"Summary!$D$6","v":"Strategy"},"Satisfaction",{"$f":"SUMIFS(HR!K$2:K$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":18},{"$f":"SUMIFS(HR!L$2:L$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":28},{"$f":"SUMIFS(HR!M$2:M$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":38},{"$f":"SUMIFS(HR!N$2:N$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":48},{"$f":"SUM(D3:G3)","v":132}]
[{"$f":"Summary!$B$7","v":"England"},{"$f":"Summary!$D$6","v":"Strategy"},"Training",{"$f":"SUMIFS(HR!O$2:O$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":20},{"$f":"SUMIFS(HR!P$2:P$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":31},{"$f":"SUMIFS(HR!Q$2:Q$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":42},{"$f":"SUMIFS(HR!R$2:R$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":53},{"$f":"SUM(D4:G4)","v":146}]
[{"$f":"Summary!$B$7","v":"England"},{"$f":"Summary!$D$6","v":"Strategy"},"Gender",{"$f":"SUMIFS(HR!S$2:S$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":55},{"$f":"SUMIFS(HR!T$2:T$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":60},{"$f":"SUMIFS(HR!U$2:U$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":65},{"$f":"SUMIFS(HR!V$2:V$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":60},240]
[{"$f":"Summary!$B$7","v":"England"},{"$f":"Summary!$D$6","v":"Strategy"},"Rating",{"$f":"SUMIFS(HR!W$2:W$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":4.8},{"$f":"SUMIFS(HR!X$2:X$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":4.5},{"$f":"SUMIFS(HR!Y$2:Y$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":4.3},{"$f":"SUMIFS(HR!Z$2:Z$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":4.5},18.100000000000001]
[{"$f":"Summary!$B$7","v":"England"},{"$f":"Summary!$D$6","v":"Strategy"},"FTE/Contractor",{"$f":"SUMIFS(HR!AA$2:AA$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":80},{"$f":"SUMIFS(HR!AB$2:AB$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":77},{"$f":"SUMIFS(HR!AC$2:AC$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":72},{"$f":"SUMIFS(HR!AD$2:AD$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":78},307]
[{"$f":"Summary!$B$7","v":"England"},{"$f":"Summary!$D$6","v":"Strategy"},"Overtime",{"$f":"SUMIFS(HR!AE$2:AE$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":187},{"$f":"SUMIFS(HR!AF$2:AF$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":220.21428571428572},{"$f":"SUMIFS(HR!AG$2:AG$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":262.26315789473688},{"$f":"SUMIFS(HR!AH$2:AH$17,HR!$A$2:$A$17,$A$3,HR!$B$2:$B$17,$B$3)","v":307.625},977.10244360902266]
[{"$f":"Summary!$B$7","v":"England"},"IT","FTE",{"$f":"SUMIFS(HR!AI$2:AI$17,HR!$A$2:$A$17,$A9,HR!$B$2:$B$17,$B9)","v":108},{"$f":"SUMIFS(HR!AJ$2:AJ$17,HR!$A$2:$A$17,$A9,HR!$B$2:$B$17,$B9)","v":144},{"$f":"SUMIFS(HR!AK$2:AK$17,HR!$A$2:$A$17,$A9,HR!$B$2:$B$17,$B9)","v":150},{"$f":"SUMIFS(HR!AL$2:AL$17,HR!$A$2:$A$17,$A9,HR!$B$2:$B$17,$B9)","v":156},558]
[{"$f":"Summary!$B$7","v":"England"},"Finance","FTE",{"$f":"SUMIFS(HR!AI$2:AI$17,HR!$A$2:$A$17,$A10,HR!$B$2:$B$17,$B10)","v":55},{"$f":"SUMIFS(HR!AJ$2:AJ$17,HR!$A$2:$A$17,$A10,HR!$B$2:$B$17,$B10)","v":53},{"$f":"SUMIFS(HR!AK$2:AK$17,HR!$A$2:$A$17,$A10,HR!$B$2:$B$17,$B10)","v":45},{"$f":"SUMIFS(HR!AL$2:AL$17,HR!$A$2:$A$17,$A10,HR!$B$2:$B$17,$B10)","v":48},201]
[{"$f":"Summary!$B$7","v":"England"},"HR","FTE",{"$f":"SUMIFS(HR!AI$2:AI$17,HR!$A$2:$A$17,$A11,HR!$B$2:$B$17,$B11)","v":33},{"$f":"SUMIFS(HR!AJ$2:AJ$17,HR!$A$2:$A$17,$A11,HR!$B$2:$B$17,$B11)","v":30},{"$f":"SUMIFS(HR!AK$2:AK$17,HR!$A$2:$A$17,$A11,HR!$B$2:$B$17,$B11)","v":32},{"$f":"SUMIFS(HR!AL$2:AL$17,HR!$A$2:$A$17,$A11,HR!$B$2:$B$17,$B11)","v":31},126]
[{"$f":"Summary!$B$7","v":"England"},"Strategy","FTE",{"$f":"SUMIFS(HR!AI$2:AI$17,HR!$A$2:$A$17,$A12,HR!$B$2:$B$17,$B12)","v":43},{"$f":"SUMIFS(HR!AJ$2:AJ$17,HR!$A$2:$A$17,$A12,HR!$B$2:$B$17,$B12)","v":45},{"$f":"SUMIFS(HR!AK$2:AK$17,HR!$A$2:$A$17,$A12,HR!$B$2:$B$17,$B12)","v":45},{"$f":"SUMIFS(HR!AL$2:AL$17,HR!$A$2:$A$17,$A12,HR!$B$2:$B$17,$B12)","v":42},175]
[]
[]
["Region","Dept","Spend per Hire","Open Positions"]
[{"$f":"Summary!$B$7","v":"England"},"IT",{"$f":"SUMIFS(HR!$J$2:$J$17,HR!$A$2:$A$17,$A16,HR!$B$2:$B$17,$B16)/1000","v":8.6924400000000013},{"$f":"SUMIFS(HR!$AM$2:$AM$17,HR!$A$2:$A$17,$A16,HR!$B$2:$B$17,$B16)","v":17}]
[{"$f":"Summary!$B$7","v":"England"},"Finance",{"$f":"SUMIFS(HR!$J$2:$J$17,HR!$A$2:$A$17,$A17,HR!$B$2:$B$17,$B17)/1000","v":3.1448499999999999},{"$f":"SUMIFS(HR!$AM$2:$AM$17,HR!$A$2:$A$17,$A17,HR!$B$2:$B$17,$B17)","v":12}]
[{"$f":"Summary!$B$7","v":"England"},"HR",{"$f":"SUMIFS(HR!$J$2:$J$17,HR!$A$2:$A$17,$A18,HR!$B$2:$B$17,$B18)/1000","v":6.5474100000000002},{"$f":"SUMIFS(HR!$AM$2:$AM$17,HR!$A$2:$A$17,$A18,HR!$B$2:$B$17,$B18)","v":7}]
[{"$f":"Summary!$B$7","v":"England"},"Strategy",{"$f":"SUMIFS(HR!$J$2:$J$17,HR!$A$2:$A$17,$A19,HR!$B$2:$B$17,$B19)/1000","v":5.6045200000000008},{"$f":"SUMIFS(HR!$AM$2:$AM$17,HR!$A$2:$A$17,$A19,HR!$B$2:$B$17,$B19)","v":4}]
[null,"Total",{"$f":"AVERAGE(C16:C19)","v":5.9973050000000008},{"$f":"SUM(D16:D19)","v":40}]
[]
[]
["Region","Dept","Consultants","Open Positions","Part Time"]
[{"$f":"Summary!$B$7","v":"England"},"2013-01-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A24,Staff!$B$2:$B$121,$B24),NA())","v":58},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A24,Staff!$B$2:$B$121,$B24),NA())","v":21},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A24,Staff!$B$2:$B$121,$B24),NA())","v":18}]
[{"$f":"Summary!$B$7","v":"England"},"2013-02-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A25,Staff!$B$2:$B$121,$B25),NA())","v":80},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A25,Staff!$B$2:$B$121,$B25),NA())","v":31},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A25,Staff!$B$2:$B$121,$B25),NA())","v":24}]
[{"$f":"Summary!$B$7","v":"England"},"2013-03-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A26,Staff!$B$2:$B$121,$B26),NA())","v":74},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A26,Staff!$B$2:$B$121,$B26),NA())","v":31},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A26,Staff!$B$2:$B$121,$B26),NA())","v":23}]
[{"$f":"Summary!$B$7","v":"England"},"2013-04-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A27,Staff!$B$2:$B$121,$B27),NA())","v":70},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A27,Staff!$B$2:$B$121,$B27),NA())","v":27},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A27,Staff!$B$2:$B$121,$B27),NA())","v":21}]
[{"$f":"Summary!$B$7","v":"England"},"2013-05-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A28,Staff!$B$2:$B$121,$B28),NA())","v":87},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A28,Staff!$B$2:$B$121,$B28),NA())","v":33},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A28,Staff!$B$2:$B$121,$B28),NA())","v":27}]
[{"$f":"Summary!$B$7","v":"England"},"2013-06-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A29,Staff!$B$2:$B$121,$B29),NA())","v":93},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A29,Staff!$B$2:$B$121,$B29),NA())","v":34},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A29,Staff!$B$2:$B$121,$B29),NA())","v":28}]
[{"$f":"Summary!$B$7","v":"England"},"2013-07-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A30,Staff!$B$2:$B$121,$B30),NA())","v":100},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A30,Staff!$B$2:$B$121,$B30),NA())","v":42},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A30,Staff!$B$2:$B$121,$B30),NA())","v":30}]
[{"$f":"Summary!$B$7","v":"England"},"2013-08-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A31,Staff!$B$2:$B$121,$B31),NA())","v":58},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A31,Staff!$B$2:$B$121,$B31),NA())","v":21},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A31,Staff!$B$2:$B$121,$B31),NA())","v":18}]
[{"$f":"Summary!$B$7","v":"England"},"2013-09-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A32,Staff!$B$2:$B$121,$B32),NA())","v":67},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A32,Staff!$B$2:$B$121,$B32),NA())","v":26},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A32,Staff!$B$2:$B$121,$B32),NA())","v":21}]
[{"$f":"Summary!$B$7","v":"England"},"2013-10-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A33,Staff!$B$2:$B$121,$B33),NA())","v":84},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A33,Staff!$B$2:$B$121,$B33),NA())","v":34},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A33,Staff!$B$2:$B$121,$B33),NA())","v":26}]
[{"$f":"Summary!$B$7","v":"England"},"2013-11-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A34,Staff!$B$2:$B$121,$B34),NA())","v":75},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A34,Staff!$B$2:$B$121,$B34),NA())","v":29},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A34,Staff!$B$2:$B$121,$B34),NA())","v":23}]
[{"$f":"Summary!$B$7","v":"England"},"2013-12-01",{"$f":"IF(C$39,SUMIFS(Staff!C$2:C$121,Staff!$A$2:$A$121,$A35,Staff!$B$2:$B$121,$B35),NA())","v":87},{"$f":"IF(D$39,SUMIFS(Staff!D$2:D$121,Staff!$A$2:$A$121,$A35,Staff!$B$2:$B$121,$B35),NA())","v":35},{"$f":"IF(E$39,SUMIFS(Staff!E$2:E$121,Staff!$A$2:$A$121,$A35,Staff!$B$2:$B$121,$B35),NA())","v":27}]
[]
[null,"Toal",{"$f":"SUM(C24:C36)","v":933},364,{"$f":"SUM(E24:E36)","v":286}]
[]
[null,"Selection",true,true,true]
[]
[]
["Region","Dept","Avg Salary","Avg Bonus","Avg Overtime"]
[{"$f":"Summary!$B$7","v":"England"},"IT",{"$f":"SUMIFS(HR!F$2:F$17,HR!$A$2:$A$17,$A43,HR!$B$2:$B$17,$B43)","v":65455},{"$f":"SUMIFS(HR!G$2:G$17,HR!$A$2:$A$17,$A43,HR!$B$2:$B$17,$B43)","v":6872.7749999999996},{"$f":"SUMIFS(HR!H$2:H$17,HR!$A$2:$A$17,$A43,HR!$B$2:$B$17,$B43)","v":3272.75}]
[{"$f":"Summary!$B$7","v":"England"},"Finance",{"$f":"SUMIFS(HR!F$2:F$17,HR!$A$2:$A$17,$A44,HR!$B$2:$B$17,$B44)","v":48978},{"$f":"SUMIFS(HR!G$2:G$17,HR!$A$2:$A$17,$A44,HR!$B$2:$B$17,$B44)","v":5142.6899999999996},{"$f":"SUMIFS(HR!H$2:H$17,HR!$A$2:$A$17,$A44,HR!$B$2:$B$17,$B44)","v":979.56000000000006}]
[{"$f":"Summary!$B$7","v":"England"},"HR",{"$f":"SUMIFS(HR!F$2:F$17,HR!$A$2:$A$17,$A45,HR!$B$2:$B$17,$B45)","v":46550},{"$f":"SUMIFS(HR!G$2:G$17,HR!$A$2:$A$17,$A45,HR!$B$2:$B$17,$B45)","v":4887.75},{"$f":"SUMIFS(HR!H$2:H$17,HR!$A$2:$A$17,$A45,HR!$B$2:$B$17,$B45)","v":931}]
[{"$f":"Summary!$B$7","v":"England"},"Strategy",{"$f":"SUMIFS(HR!F$2:F$17,HR!$A$2:$A$17,$A46,HR!$B$2:$B$17,$B46)","v":49864},{"$f":"SUMIFS(HR!G$2:G$17,HR!$A$2:$A$17,$A46,HR!$B$2:$B$17,$B46)","v":5235.72},{"$f":"SUMIFS(HR!H$2:H$17,HR!$A$2:$A$17,$A46,HR!$B$2:$B$17,$B46)","v":2493.2000000000003}]
[null,"Avg",{"$f":"AVERAGE(C43:C46)","v":52711.75},{"$f":"AVERAGE(D43:D46)","v":5534.7337500000003},{"$f":"AVERAGE(E43:E46)","v":1919.1275000000001}]
[]
[]
["Region","Dept","AvgLeave Balance","Perf Score"]
[{"$f":"Summary!$B$7","v":"England"},"IT",{"$f":"SUMIFS(HR!I$2:I$17,HR!$A$2:$A$17,$A51,HR!$B$2:$B$17,$B51)","v":22},{"$f":"SUMIFS(HR!AN2:AN17,HR!$A$2:$A$17,$A51,HR!$B$2:$B$17,$B51)","v":4.5}]
[{"$f":"Summary!$B$7","v":"England"},"Finance",{"$f":"SUMIFS(HR!I$2:I$17,HR!$A$2:$A$17,$A52,HR!$B$2:$B$17,$B52)","v":32},{"$f":"SUMIFS(HR!AN3:AN18,HR!$A$2:$A$17,$A52,HR!$B$2:$B$17,$B52)","v":4.2}]
[{"$f":"Summary!$B$7","v":"England"},"HR",{"$f":"SUMIFS(HR!I$2:I$17,HR!$A$2:$A$17,$A53,HR!$B$2:$B$17,$B53)","v":15},{"$f":"SUMIFS(HR!AN4:AN19,HR!$A$2:$A$17,$A53,HR!$B$2:$B$17,$B53)","v":4}]
[{"$f":"Summary!$B$7","v":"England"},"Strategy",{"$f":"SUMIFS(HR!I$2:I$17,HR!$A$2:$A$17,$A54,HR!$B$2:$B$17,$B54)","v":6},{"$f":"SUMIFS(HR!AN5:AN20,HR!$A$2:$A$17,$A54,HR!$B$2:$B$17,$B54)","v":3.8}]
[null,"Avg",{"$f":"AVERAGE(C51:C54)","v":18.75},{"$f":"AVERAGE(D51:D54)","v":4.125}]
[]
[]
["Region","Month","Termination","New Hires","New Hires"]
[{"$f":"Summary!$B$7","v":"England"},"2013-01-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A59,Staff!$B$2:$B$121,$B59)","v":-2},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A59,Staff!$B$2:$B$121,$B59)","v":7}]
[{"$f":"Summary!$B$7","v":"England"},"2013-02-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A60,Staff!$B$2:$B$121,$B60)","v":-3},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A60,Staff!$B$2:$B$121,$B60)","v":4}]
[{"$f":"Summary!$B$7","v":"England"},"2013-03-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A61,Staff!$B$2:$B$121,$B61)","v":0},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A61,Staff!$B$2:$B$121,$B61)","v":2}]
[{"$f":"Summary!$B$7","v":"England"},"2013-04-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A62,Staff!$B$2:$B$121,$B62)","v":-3},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A62,Staff!$B$2:$B$121,$B62)","v":3}]
[{"$f":"Summary!$B$7","v":"England"},"2013-05-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A63,Staff!$B$2:$B$121,$B63)","v":-3},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A63,Staff!$B$2:$B$121,$B63)","v":3}]
[{"$f":"Summary!$B$7","v":"England"},"2013-06-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A64,Staff!$B$2:$B$121,$B64)","v":-3},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A64,Staff!$B$2:$B$121,$B64)","v":2}]
[{"$f":"Summary!$B$7","v":"England"},"2013-07-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A65,Staff!$B$2:$B$121,$B65)","v":-3},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A65,Staff!$B$2:$B$121,$B65)","v":2}]
[{"$f":"Summary!$B$7","v":"England"},"2013-08-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A66,Staff!$B$2:$B$121,$B66)","v":-2},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A66,Staff!$B$2:$B$121,$B66)","v":4}]
[{"$f":"Summary!$B$7","v":"England"},"2013-09-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A67,Staff!$B$2:$B$121,$B67)","v":-3},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A67,Staff!$B$2:$B$121,$B67)","v":1}]
[{"$f":"Summary!$B$7","v":"England"},"2013-10-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A68,Staff!$B$2:$B$121,$B68)","v":-3},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A68,Staff!$B$2:$B$121,$B68)","v":4}]
[{"$f":"Summary!$B$7","v":"England"},"2013-11-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A69,Staff!$B$2:$B$121,$B69)","v":-3},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A69,Staff!$B$2:$B$121,$B69)","v":1}]
[{"$f":"Summary!$B$7","v":"England"},"2013-12-01",{"$f":"SUMIFS(Staff!F$2:F$121,Staff!$A$2:$A$121,$A70,Staff!$B$2:$B$121,$B70)","v":-3},{"$f":"SUMIFS(Staff!G$2:G$121,Staff!$A$2:$A$121,$A70,Staff!$B$2:$B$121,$B70)","v":2}]
[null,"Total",{"$f":"SUM(C59:C70)","v":-31},35]
[]
[]
["Region","Dept","19-25","26-35","36-45","46-55","55+"]
[{"$f":"Summary!$B$7","v":"England"},"IT",{"$f":"SUMIFS(HR!AO$2:AO$17,HR!$A$2:$A$17,$A75,HR!$B$2:$B$17,$B75)","v":21.6},{"$f":"SUMIFS(HR!AP$2:AP$17,HR!$A$2:$A$17,$A75,HR!$B$2:$B$17,$B75)","v":32.4},{"$f":"SUMIFS(HR!AQ$2:AQ$17,HR!$A$2:$A$17,$A75,HR!$B$2:$B$17,$B75)","v":32.4},{"$f":"SUMIFS(HR!AR$2:AR$17,HR!$A$2:$A$17,$A75,HR!$B$2:$B$17,$B75)","v":10.8},{"$f":"SUMIFS(HR!AS$2:AS$17,HR!$A$2:$A$17,$A75,HR!$B$2:$B$17,$B75)","v":10.8}]
[{"$f":"Summary!$B$7","v":"England"},"Finance",{"$f":"SUMIFS(HR!AO$2:AO$17,HR!$A$2:$A$17,$A76,HR!$B$2:$B$17,$B76)","v":13.75},{"$f":"SUMIFS(HR!AP$2:AP$17,HR!$A$2:$A$17,$A76,HR!$B$2:$B$17,$B76)","v":6.6},{"$f":"SUMIFS(HR!AQ$2:AQ$17,HR!$A$2:$A$17,$A76,HR!$B$2:$B$17,$B76)","v":11},{"$f":"SUMIFS(HR!AR$2:AR$17,HR!$A$2:$A$17,$A76,HR!$B$2:$B$17,$B76)","v":12.1},{"$f":"SUMIFS(HR!AS$2:AS$17,HR!$A$2:$A$17,$A76,HR!$B$2:$B$17,$B76)","v":11.549999999999997}]
[{"$f":"Summary!$B$7","v":"England"},"HR",{"$f":"SUMIFS(HR!AO$2:AO$17,HR!$A$2:$A$17,$A77,HR!$B$2:$B$17,$B77)","v":2.64},{"$f":"SUMIFS(HR!AP$2:AP$17,HR!$A$2:$A$17,$A77,HR!$B$2:$B$17,$B77)","v":6.6000000000000005},{"$f":"SUMIFS(HR!AQ$2:AQ$17,HR!$A$2:$A$17,$A77,HR!$B$2:$B$17,$B77)","v":6.2700000000000005},{"$f":"SUMIFS(HR!AR$2:AR$17,HR!$A$2:$A$17,$A77,HR!$B$2:$B$17,$B77)","v":4.62},{"$f":"SUMIFS(HR!AS$2:AS$17,HR!$A$2:$A$17,$A77,HR!$B$2:$B$17,$B77)","v":12.869999999999997}]
[{"$f":"Summary!$B$7","v":"England"},"Strategy",{"$f":"SUMIFS(HR!AO$2:AO$17,HR!$A$2:$A$17,$A78,HR!$B$2:$B$17,$B78)","v":14.190000000000001},{"$f":"SUMIFS(HR!AP$2:AP$17,HR!$A$2:$A$17,$A78,HR!$B$2:$B$17,$B78)","v":12.469999999999999},{"$f":"SUMIFS(HR!AQ$2:AQ$17,HR!$A$2:$A$17,$A78,HR!$B$2:$B$17,$B78)","v":3.0100000000000002},{"$f":"SUMIFS(HR!AR$2:AR$17,HR!$A$2:$A$17,$A78,HR!$B$2:$B$17,$B78)","v":3.8699999999999997},{"$f":"SUMIFS(HR!AS$2:AS$17,HR!$A$2:$A$17,$A78,HR!$B$2:$B$17,$B78)","v":9.4600000000000044}]
[]
["Region","Speed to Hire","Promo Rate","Cust Satisfaction"]
["England",27,0.09,0.88]
["Scotland",28,7.0000000000000007E-2,0.84]
["Wales",29,0.08,0.82]
["Northern Ireland",30,0.1,0.91]
[]
[{"$f":"Summary!$B$7","v":"England"},{"$f":"SUMIFS(B81:B84,$A$81:$A$84,$A$86)","v":27},{"$f":"SUMIFS(C81:C84,$A$81:$A$84,$A$86)","v":0.09},0.88]

{"sheet":"Chart","index":4,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Speed to Hire",2016]
["Good",15]
["OK",30]
["Actual",{"$f":"Calcs!B86","v":27}]
["Target",32]
[]
[]
["Target Val",{"$f":"B5","v":32}]
["Target Cat",2]
[]
["Desc","Actual","Poor","OK"]
["Grad",0,{"$f":"B2","v":15},{"$f":"MAX(B3-C12,0)","v":15}]
["Actual",{"$f":"B4","v":27},{"$f":"MAX($B$2-MAX(0,$B$4),0)","v":0},{"$f":"MAX(MIN($B3-$B2,$B3-$B4),0)","v":3}]
["Gradation2",{"$f":"B12","v":0},{"$f":"C12","v":15},{"$f":"D12","v":15}]
[]
[]
["Promo Rate",2016]
["Good",0.05]
["OK",7.0000000000000007E-2]
["Actual",{"$f":"Calcs!C86","v":0.09}]
["Target",0.08]
[]
[]
["Target Val",{"$f":"B21","v":0.08}]
["Target Cat",2]
[]
["Desc","Actual","Poor","OK"]
["Grad",0,{"$f":"B18","v":0.05},{"$f":"MAX(B19-C28,0)","v":2.0000000000000004E-2}]
["Actual",{"$f":"B20","v":0.09},{"$f":"MAX($B$2-MAX(0,$B$4),0)","v":0},{"$f":"MAX(MIN($B19-$B18,$B19-$B20),0)","v":0}]
["Gradation2",{"$f":"B28","v":0},{"$f":"C28","v":0.05},{"$f":"D28","v":2.0000000000000004E-2}]
[]
[]
["Cust Satisfaction",2016]
["Poor",0.5]
["OK",0.75]
["Actual",{"$f":"Calcs!D86","v":0.88}]
["Target",0.85]
[]
[]
["Target Val",{"$f":"B37","v":0.85}]
["Target Cat",2]
[]
["Desc","Actual","Poor","OK"]
["Grad",0,{"$f":"B34","v":0.5},{"$f":"MAX(B35-C44,0)","v":0.25}]
["Actual",{"$f":"B36","v":0.88},{"$f":"MAX($B$2-MAX(0,$B$4),0)","v":0},{"$f":"MAX(MIN($B35-$B34,$B35-$B36),0)","v":0}]
["Gradation2",{"$f":"B44","v":0},{"$f":"C44","v":0.5},{"$f":"D44","v":0.25}]

{"sheet":"Summary","index":5,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region"]
[null,null,"Department >>","Strategy"]
[null,"England",null,null,null,{"$f":"B7&\" \"&D6&\" Metrics\"","v":"England Strategy Metrics"}]
[null,"Department","FTE","Qtly Trend",null,"Q1","Q2","Q3","Q4","Total","Trend"]
[null,"IT",{"$f":"SUMIFS(HR!AI$2:AI$17,HR!$A$2:$A$17,$B$7,HR!$B$2:$B$17,$B$9)","v":108},null,null,"Employee Satisfaction %"]
[null,null,null,null,null,{"$f":"Calcs!D3","v":18},{"$f":"Calcs!E3","v":28},{"$f":"Calcs!F3","v":38},{"$f":"Calcs!G3","v":48},{"$f":"SUM(F10:I10)/4","v":33}]
[null,"Finance",{"$f":"SUMIFS(HR!AI$2:AI$17,HR!$A$2:$A$17,$B$7,HR!$B$2:$B$17,$B11)","v":55}]
[null,null,null,null,null,"Employees Trained "]
[null,"HR",{"$f":"SUMIFS(HR!AI$2:AI$17,HR!$A$2:$A$17,$B$7,HR!$B$2:$B$17,$B13)","v":33},null,null,{"$f":"Calcs!D4","v":20},{"$f":"Calcs!E4","v":31},{"$f":"Calcs!F4","v":42},{"$f":"Calcs!G4","v":53},{"$f":"SUM(F13:I13)/4","v":36.5}]
[]
[null,"Strategy",{"$f":"SUMIFS(HR!AI$2:AI$17,HR!$A$2:$A$17,$B$7,HR!$B$2:$B$17,$B15)","v":43},null,null,"Gender Diversity % M/F"]
[null,null,null,null,null,{"$f":"Calcs!D5","v":55},{"$f":"Calcs!E5","v":60},{"$f":"Calcs!F5","v":65},{"$f":"Calcs!G5","v":60},{"$f":"Calcs!H9","v":558}]
[null,{"$f":"B7&\" Average Spend Per Hire\"","v":"England Average Spend Per Hire"}]
[null,null,null,null,null,"Avg Staff Rating (0-5)"]
[null,null,null,null,null,{"$f":"Calcs!D6","v":4.8},{"$f":"Calcs!E6","v":4.5},{"$f":"Calcs!F6","v":4.3},{"$f":"Calcs!G6","v":4.5},{"$f":"SUM(F19:I19)/4","v":4.5250000000000004}]
[]
[null,null,null,null,null,"FTE/Contractor %"]
[null,null,null,null,null,{"$f":"Calcs!D7","v":80},{"$f":"Calcs!E7","v":77},{"$f":"Calcs!F7","v":72},{"$f":"Calcs!G7","v":78},{"$f":"SUM(F22:I22)/4","v":76.75}]
[]
[null,null,null,null,null,"Overtime Hrs"]
[null,null,null,null,null,{"$f":"Calcs!D8","v":187},{"$f":"Calcs!E8","v":220.21428571428572},{"$f":"Calcs!F8","v":262.26315789473688},{"$f":"Calcs!G8","v":307.625},{"$f":"AVERAGE(F25:I25)","v":244.27561090225566}]