{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Revision History","Cover","Control_Panel","Data for submission ","Validation and Data Checks","Backsheet"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":39,"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":"Revision History","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Revision History "]
[null,null,"WRES2"]
[null,"Version","Date","Change "]
[null,1,"2019-04-03","Changed dates - Owen Chinembiri"]
[null,2,"2019-06-06","Updated Template - MM"]
[null,3,"2019-06-12","Backsheet Added - AB"]
[null,3.1,"2019-06-13","Sheets locked down and upversioned for SharePoint and SDCS - RL"]
[null,4,"2019-06-14","Upversioned and error message made visible - RL"]
[null,5,"2019-06-17","Autocalculation formulae added back in from Mo's template - RL"]
[null,5.0999999999999996,"2019-07-01","Edited validation formula on Control Panel to check for right amount of cells - RL"]
[null,6,"2019-07-10","Updated Cells"]

{"sheet":"Cover","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[15,3,15,5],[7,5,7,6],[8,2,8,3],[8,4,8,5],[12,3,12,4],[14,3,14,5],[5,2,5,3],[5,4,6,4],[5,5,6,6],[1,1,2,12],[3,1,3,12]]}
[]
[null,"Workforce Race Equality \nStandards annual collection "]
[]
[null," as at March-2019"]
[]
[]
[]
[]
[null,null,"Period:",null,"April 2016-17"]

{"sheet":"Control_Panel","index":2,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,9,7],[10,1,10,7],[1,1,1,7],[3,1,3,7],[4,1,6,7],[8,1,8,7]]}
[null,null,null,null,null,null,null,null,null,null,"Backsheet check"]
[null,"Workforce Race Equality Standards",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(IF(ISERROR(INDIRECT(\"Backsheet!\" &L2)),1,0))=0,0,1)","v":0},"A2:ZZ500"]
[]
[null,"Validations"]
[null,"Please correct all issues listed within the table below. If the issues are not corrected then the pro forma will fail the validation stage in SDCS. "]
[]
[]
[]
[null,"Trust - Frontsheet"]
[null,{"$f":"IF(COUNTA(answer_cells)<>550,\"Please complete all yellow answer cells on the 'Data for submission' tab. The 'Validation and Data Checks' tab can be used to identify which cells still need to be answered.\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"B10","v":""}]
[null,{"$f":"IF(SUM(COUNTIF(INDIRECT({\"'Data for submission '!$G$73\",\"'Data for submission '!$G$69:$G$70\",\"'Data for submission '!$I$69:$I$70\",\"'Data for submission '!$I$73\",\"'Data for submission '!$K$73\",\"'Data for submission '!$K$69:$K$70\",\"'Data for submission '!$M$69:$M$70\",\"'Data for submission '!$M$73\",\"'Data for submission '!$O$69:$O$70\",\"'Data for submission '!$O$73\",\"'Data for submission '!$Q$69:$Q$70\",\"'Data for submission '!$Q$73\",\"'Data for submission '!$Q$62\",\"'Data for submission '!$O$62\",\"'Data for submission '!$M$62\",\"'Data for submission '!$Q$58\",\"'Data for submission '!$O$58\",\"'Data for submission '!$M$58\",\"'Data for submission '!$G$48:$G$52\",\"'Data for submission '!$I$48:$I$54\",\"'Data for submission '!$K$48:$K$54\",\"'Data for submission '!$M$48:$M$54\",\"'Data for submission '!$O$48:$O$54\",\"'Data for submission '!$Q$48:$Q$54\",\"'Data for submission '!$Q$38:$Q$46\",\"'Data for submission '!$O$33:$O$46\",\"'Data for submission '!$Q$33:$Q$37\",\"'Data for submission '!$M$33:$M$46\",\"'Data for submission '!$K$33:$K$46\",\"'Data for submission '!$I$33:$I$46\",\"'Data for submission '!$G$33:$G$46\",\"'Data for submission '!$G$17:$G$30\",\"'Data for submission '!$I$17:$I$30\",\"'Data for submission '!$K$17:$K$29\",\"'Data for submission '!$K$30\",\"'Data for submission '!$M$17:$M$30\",\"'Data for submission '!$O$17:$O$30\",\"'Data for submission '!$Q$17:$Q$30\"}),\"*\"))>0,\"Answer cells cannot contain text.\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"B11","v":""}]

{"sheet":"Data for submission ","index":3,"n_rows":82,"n_cols":24,"rows_kept":82,"cut":false,"hidden":false,"merged":[[68,0,81,0],[13,0,14,1],[13,4,14,4],[60,0,63,0],[68,1,81,1],[13,17,14,17],[52,0,55,0],[15,0,51,0],[56,0,59,0],[13,15,14,16],[13,13,14,14],[13,7,14,8],[13,5,14,6],[13,9,14,10],[13,2,14,2],[30,17,31,17],[46,11,46,16],[46,3,46,4],[8,2,8,4],[12,5,12,10],[13,11,14,12],[60,1,63,1],[56,1,59,1],[52,1,55,1],[15,1,51,1],[30,2,31,2],[30,3,31,4],[13,3,14,3],[30,5,31,10],[46,5,46,10],[30,11,31,16],[12,11,12,16]]}
[]
[]
[null,"SubmissionTemplate"]
[]
[null,"Workforce Race Equality Standards 2018/19 template"]
[]
[]
[]
[null,null,null,null,null,null,"Answer Required"]
[null,null,null,null,null,null,"Auto Populated"]
[null,null,null,null,null,null,"N/A"]
[]
[null,null,null,null,null,"31st MARCH 2018",null,null,null,null,null,"31st MARCH 2019"]
["INDICATOR",null,"DATA ITEM",null,"MEASURE","WHITE",null,"BME",null,"ETHNICITY UNKNOWN/NULL",null,"WHITE",null,"BME",null,"ETHNICITY UNKNOWN/NULL",null,"Notes"]
[]
[1,"Percentage of staff in each of the AfC Bands 1-9 OR Medical and Dental subgroups and VSM (including executive Board members) compared with the percentage of staff in the overall workforce",null,"1a) Non Clinical workforce",null,"ESR figures","Verified figures ","ESR figures","Verified figures ","ESR figures","Verified figures ","ESR figures","Verified figures ","ESR figures","Verified figures ","ESR figures","Verified figures "]
[null,null,1,"Under Band 1","Headcount",6,6,32,31,0,0,7,7,31,31,1,1,null,"< Band 1 (i.e. Apprentices)","Non Clinical",null,"White"]
[null,null,2,"Band 1","Headcount",0,0,0,0,0,0,0,0,0,0,0,0,null,"Band 1","Non Clinical",null,"BME"]
[null,null,3,"Band 2","Headcount",2,2,5,5,0,0,29,29,5,5,0,0,null,"Band 2","Non Clinical",null,"Unknown/Null"]
[null,null,4,"Band 3","Headcount",65,64,98,98,2,2,94,94,116,116,4,4,null,"Band 3","Non Clinical"]
[null,null,5,"Band 4","Headcount",134,134,196,194,12,12,137,137,187,187,16,16,null,"Band 4","Non Clinical"]
[null,null,6,"Band 5","Headcount",81,81,91,90,5,5,91,91,110,110,8,8,null,"Band 5","Non Clinical"]
[null,null,7,"Band 6","Headcount",58,57,64,64,3,3,69,69,65,65,7,7,null,"Band 6","Non Clinical"]
[null,null,8,"Band 7","Headcount",48,49,31,30,0,0,47,47,30,30,3,3,null,"Band 7","Non Clinical"]
[null,null,9,"Band 8A","Headcount",53,51,28,29,1,1,51,51,40,40,4,4,null,"Band 8a","Non Clinical"]
[null,null,10,"Band 8B","Headcount",31,31,5,5,0,0,23,23,8,8,0,0,null,"Band 8b","Non Clinical"]
[null,null,11,"Band 8C","Headcount",19,19,6,6,0,0,23,23,6,6,0,0,null,"Band 8c","Non Clinical"]
[null,null,12,"Band 8D","Headcount",15,16,0,0,0,0,22,22,2,2,0,0,null,"Band 8d","Non Clinical"]
[null,null,13,"Band 9","Headcount",4,6,0,2,0,0,7,7,2,2,0,0,null,"Band 9","Non Clinical"]
[null,null,14,"VSM","Headcount",7,5,5,4,0,0,3,3,4,4,0,0,null,"VSM","Non Clinical"]
[null,null,null,"1b) Clinical workforce\nof which Non Medical"]
[]
[null,null,15,"Under Band 1","Headcount",5,4,12,12,0,1,7,7,8,8,0,0,null,"< Band 1 (i.e. Apprentices)","Clinical"]
[null,null,16,"Band 1","Headcount",0,0,0,0,0,0,0,0,0,0,0,0,null,"Band 1","Clinical"]
[null,null,17,"Band 2","Headcount",0,0,5,3,0,0,18,18,1,1,0,0,null,"Band 2","Clinical"]
[null,null,18,"Band 3","Headcount",207,191,489,469,13,13,211,211,462,462,32,32,null,"Band 3","Clinical"]
[null,null,19,"Band 4","Headcount",129,130,155,156,2,2,164,164,204,204,13,13,null,"Band 4","Clinical"]
[null,null,20,"Band 5","Headcount",200,197,392,393,14,14,277,277,393,393,12,12,null,"Band 5","Clinical"]
[null,null,21,"Band 6","Headcount",345,343,472,472,8,8,408,408,510,510,22,22,null,"Band 6","Clinical"]
[null,null,22,"Band 7","Headcount",388,384,253,254,10,10,487,487,287,287,23,23,null,"Band 7","Clinical"]
[null,null,23,"Band 8A","Headcount",225,230,90,91,9,9,232,232,95,95,13,13,null,"Band 8a","Clinical"]
[null,null,24,"Band 8B","Headcount",67,67,17,17,1,1,85,85,26,26,4,4,null,"Band 8b","Clinical"]
[null,null,25,"Band 8C","Headcount",35,35,10,9,0,0,41,41,10,10,0,0,null,"Band 8c","Clinical"]
[null,null,26,"Band 8D","Headcount",9,9,2,2,1,1,10,10,1,1,2,2,null,"Band 8d","Clinical"]
[null,null,27,"Band 9","Headcount",2,4,1,1,0,0,3,3,1,1,0,0,null,"Band 9","Clinical"]
[null,null,28,"VSM","Headcount",5,0,0,0,0,0,1,1,2,2,0,0,null,"VSM","Clinical"]
[null,null,null,"Of which Medical & Dental"]
[null,null,29,"Consultants","Headcount",148,132,92,75,6,3,125,125,71,71,11,11,null,"Medical & Dental Consultant","Clinical"]
[null,null,30,"  of which Senior medical manager","Headcount",null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,31,"Non-consultant career grade","Headcount",19,19,39,38,4,4,24,24,39,39,4,4,null,"Medical & Dental Non-consultant career grade","Clinical"]
[null,null,32,"Trainee grades","Headcount",10,57,10,56,0,6,49,49,65,65,9,9,null,"Medical & Dental Trainee grades","Clinical"]
[null,null,33,"Other","Headcount",28,27,28,27,4,0,5,5,3,3,0,0,null,"Medical & Dental Other","Clinical"]
[2,"Relative likelihood of staff being appointed from shortlisting across all posts\n",34,"Number of shortlisted applicants","Headcount",null,2174,null,3123,null,39,null,1627,null,3737,null,199,null,null,null,null,null,2.5522925244872678,0.55591665613817298]
[null,null,35,"Number appointed from shortlisting","Headcount",null,414,null,455,null,0,null,410,null,674,null,37]
[null,null,36,"Relative likelihood of appointment from shortlisting","Auto calculated",null,{"$f":"IFERROR(G54/G53,\"\")","v":0.19043238270469182},null,{"$f":"IFERROR(I54/I53,\"\")","v":0.1456932436759526},null,{"$f":"IFERROR(K54/K53,\"\")","v":0},null,{"$f":"IFERROR(M54/M53,\"\")","v":0.25199754148740011},null,{"$f":"IFERROR(O54/O53,\"\")","v":0.18035857639818037},null,{"$f":"IFERROR(Q54/Q53,\"\")","v":0.18592964824120603}]
[null,null,37,"Relative likelihood of White staff being appointed from shortlisting compared to BME staff","Auto calculated",null,{"$f":"IFERROR(G55/I55,\"\")","v":1.3070776509598958},null,null,null,null,null,{"$f":"IFERROR(M55/O55,\"\")","v":1.3972029859620387}]
[3,"Relative likelihood of staff entering the formal disciplinary process, as measured by entry into a formal disciplinary investigation\n\nNote: This indicator will be based on data from a two year rolling average of the current year and the previous year",38,"Number of staff in workforce","Auto calculated",null,{"$f":"IF(SUM(G17:G30)+SUM(G33:G46)+G48+SUM(G50:G52)=0,\"\",SUM(G17:G30)+SUM(G33:G46)+G48+SUM(G50:G52))","v":2350},null,{"$f":"IF(SUM(I17:I30)+SUM(I33:I46)+I48+SUM(I50:I52)=0,\"\",SUM(I17:I30)+SUM(I33:I46)+I48+SUM(I50:I52))","v":2633},null,{"$f":"IF(SUM(K17:K30)+SUM(K33:K46)+K48+SUM(K50:K52)=0,\"\",SUM(K17:K30)+SUM(K33:K46)+K48+SUM(K50:K52))","v":95},null,{"$f":"IF(SUM(M17:M30)+SUM(M33:M46)+M48+SUM(M50:M52)=0,\"\",SUM(M17:M30)+SUM(M33:M46)+M48+SUM(M50:M52))","v":2750},null,2784,null,188,null,null,null,null,null,4.3158680043516524,0]
[null,null,39,"Number of staff entering the formal disciplinary process","Headcount",null,18,null,56,null,0,null,15,null,37,null,0]
[null,null,40,"Likelihood of staff entering the formal disciplinary process","Auto calculated",null,{"$f":"IFERROR(G58/G57,\"\")","v":7.659574468085106E-3},null,{"$f":"IFERROR(I58/I57,\"\")","v":2.1268515001898976E-2},null,{"$f":"IFERROR(K58/K57,\"\")","v":0},null,{"$f":"IFERROR(M58/M57,\"\")","v":5.454545454545455E-3},null,{"$f":"IFERROR(O58/O57,\"\")","v":1.3290229885057471E-2},null,{"$f":"IFERROR(Q58/Q57,\"\")","v":0}]
[null,null,41,"Relative likelihood of BME staff entering the formal disciplinary process compared to White staff","Auto calculated",null,null,null,{"$f":"IFERROR(I59/G59,\"\")","v":2.7767227919145885},null,null,null,null,null,{"$f":"IFERROR(O59/M59,\"\")","v":2.4365421455938696}]
[4,"Relative likelihood of staff accessing non-mandatory training and CPD",42,"Number of staff in workforce","Auto calculated",null,{"$f":"G57","v":2350},null,{"$f":"I57","v":2633},null,{"$f":"K57","v":95},null,{"$f":"M57","v":2750},null,{"$f":"O57","v":2784},null,{"$f":"Q57","v":188},null,null,null,null,null,2.0521583133406875,0.10298981852318034]
[null,null,43,"Number of staff accessing non-mandatory training and CPD:","Headcount",null,1036,null,1122,null,33,null,1469,null,1714,null,74,"The following are sources that were used in the collection of this data:\nAll doctors due to their weekly CPD;\nHealth roster study days for activities that were non-stat and non-man training;\nEmails from executives, service delivery board members, DMT's and HR BPs confirming their CPD activity and that of their teams;\nOLM (for all centrally booked non-mandatory training programmes, including nursing development);\nCoaching, mentoring, 360 degree feedback as well as other individual diagnostic and develpment/psychometric tools;\nInformation recieved from directorate education committees and development provider to community teams.\n"]
[null,null,44,"Likelihood of staff accessing non-mandatory training and CPD","Auto calculated",null,{"$f":"IFERROR(G62/G61,\"\")","v":0.44085106382978723},null,{"$f":"IFERROR(I62/I61,\"\")","v":0.42612988985947586},null,{"$f":"IFERROR(K62/K61,\"\")","v":0.3473684210526316},null,{"$f":"IFERROR(M62/M61,\"\")","v":0.5341818181818182},null,{"$f":"IFERROR(O62/O61,\"\")","v":0.61566091954022983},null,{"$f":"IFERROR(Q62/Q61,\"\")","v":0.39361702127659576}]
[null,null,45,"Relative likelihood of White staff accessing non-mandatory training and CPD compared to BME staff","Auto calculated",null,{"$f":"IFERROR(G63/I63,\"\")","v":1.034546213069367},null,null,null,null,null,{"$f":"IFERROR(M63/O63,\"\")","v":0.86765588204094635}]
[5,"Percentage of staff experiencing harassment, bullying or abuse from patients, relatives  or the public in last 12 months ",46,"% of  staff experiencing harassment, bullying or abuse from patients, relatives  or the public in last 12 months ","Percentage",null,0.28910000000000002,null,0.32619999999999999,null,null,null,0.317,null,0.35599999999999998,null,null,"Please refer to the Picker staff survey RWK_East London NHS Foundation NNS18 RAG_Table _ Not experienced harassment, bullying or abuse from patients/service users, their relatives or members of the public. As this question is captured differently to the one on the WRES capture template - we have transposed the %"]
[6,"Percentage of staff experiencing harassment, bullying or abuse from staff in last 12 months ",47,"% of  staff experiencing harassment, bullying or abuse from staff in last 12 months ","Percentage",null,0.2324,null,0.22570000000000001,null,null,null,0.16200000000000001,null,0.18,null,null,"Please refer to the Picker staff survey RWK_East London NHS Foundation NNS18 RAG_Table _ Not experienced harassment, bullying or abuse from other colleagues. As this question is captured differently to the one on the WRES capture template - we have transposed the %"]
[7,"Percentage believing that trust provides equal opportunities for career progression or promotion",48,"%  staff believing that trust provides equal opportunities for career \nprogression or promotion","Percentage",null,0.83809999999999996,null,0.72570000000000001,null,null,null,0.84699999999999998,null,0.71799999999999997]
[8,"In the last 12 months have you personally experienced discrimination at work from any of the following?\nb) Manager/team leader or other colleagues",49,"%  staff personally experienced discrimination at work from Manager/team leader or other colleague","Percentage",null,9.0899999999999995E-2,null,0.13020000000000001,null,null,null,8.4000000000000005E-2,null,0.14399999999999999,null,null,"Please refer to the Picker staff survey RWK_East London NHS Foundation NNS18 RAG_Table _ Not experienced discrimination from manager/team leader or other colleagues. As this question is captured differently to the one on the WRES capture template - we have transposed the %"]
[9,"Percentage difference between the organisations’ Board voting membership and its overall workforce\n\nNote: Only voting members of the Board should be included when considering this indicator",50,"Total Board members","Headcount",null,10,null,8,null,0,null,9,null,9,null,0]
[null,null,51," of which: Voting Board members","Headcount",null,8,null,7,null,0,null,8,null,7,null,0]
[null,null,52,"                 : Non Voting Board members","Auto calculated",null,{"$f":"IFERROR(G69-G70,\"Error\")","v":2},null,{"$f":"IFERROR(I69-I70,\"Error\")","v":1},null,{"$f":"IFERROR(K69-K70,\"Error\")","v":0},null,{"$f":"IFERROR(M69-M70,\"Error\")","v":1},null,{"$f":"IFERROR(O69-O70,\"Error\")","v":2},null,{"$f":"IFERROR(Q69-Q70,\"Error\")","v":0}]
[null,null,53,"Total Board members","Auto calculated",null,{"$f":"G69","v":10},null,{"$f":"I69","v":8},null,{"$f":"K69","v":0},null,{"$f":"M69","v":9},null,{"$f":"O69","v":9},null,{"$f":"Q69","v":0}]
[null,null,54," of which: Exec Board members","Headcount",null,5,null,5,null,0,null,4,null,6,null,0]
[null,null,55,"                 : Non Executive Board members","Auto calculated",null,{"$f":"IFERROR(G72-G73,\"Error\")","v":5},null,{"$f":"IFERROR(I72-I73,\"Error\")","v":3},null,{"$f":"IFERROR(K72-K73,\"Error\")","v":0},null,{"$f":"IFERROR(M72-M73,\"Error\")","v":5},null,{"$f":"IFERROR(O72-O73,\"Error\")","v":3},null,{"$f":"IFERROR(Q72-Q73,\"Error\")","v":0}]
[null,null,56,"Number of staff in overall workforce","Auto calculated",null,{"$f":"IFERROR(SUM(G17:G30)+SUM(G33:G46)+G48+G50+G51+G52,\"\")","v":2350},null,{"$f":"IFERROR(SUM(I17:I30)+SUM(I33:I46)+I48+I50+I51+I52,\"\")","v":2633},null,{"$f":"IFERROR(SUM(K17:K30)+SUM(K33:K46)+K48+K50+K51+K52,\"\")","v":95},null,{"$f":"M57","v":2750},null,{"$f":"O57","v":2784},null,{"$f":"Q57","v":188}]
[null,null,57,"Total Board members - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G69/($G$69+$I$69+$K$69),\"\")","v":0.55555555555555558},null,{"$f":"IFERROR(I69/($G$69+$I$69+$K$69),\"\")","v":0.44444444444444442},null,{"$f":"IFERROR(K69/($G$69+$I$69+$K$69),\"\")","v":0},null,{"$f":"IFERROR(M69/(M69+O69+Q69),\"\")","v":0.5},null,{"$f":"IFERROR(O69/(M69+O69+Q69),\"\")","v":0.5},null,{"$f":"IFERROR(Q69/(M69+O69+Q69),\"\")","v":0}]
[null,null,58,"Voting Board Member - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G70/($G$70+$I$70+$K$70),\"\")","v":0.53333333333333333},null,{"$f":"IFERROR(I70/($G$70+$I$70+$K$70),\"\")","v":0.46666666666666667},null,{"$f":"IFERROR(K70/($G$70+$I$70+$K$70),\"\")","v":0},null,{"$f":"IFERROR(M70/(M70+O70+Q70),\"\")","v":0.53333333333333333},null,{"$f":"IFERROR(O70/(M70+O70+Q70),\"\")","v":0.46666666666666667},null,{"$f":"IFERROR(Q70/(M70+O70+Q70),\"\")","v":0}]
[null,null,59,"Non Voting Board Member - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G71/($G$71+$I$71+$K$71),\"\")","v":0.66666666666666663},null,{"$f":"IFERROR(I71/($G$71+$I$71+$K$71),\"\")","v":0.33333333333333331},null,{"$f":"IFERROR(K71/($G$71+$I$71+$K$71),\"\")","v":0},null,{"$f":"IFERROR(M71/(M71+O71+Q71),\"\")","v":0.33333333333333331},null,{"$f":"IFERROR(O71/(M71+O71+Q71),\"\")","v":0.66666666666666663},null,{"$f":"IFERROR(Q71/(M71+O71+Q71),\"\")","v":0}]
[null,null,60,"Executive Board Member - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G73/($G$73+$I$73+$K$73),\"\")","v":0.5},null,{"$f":"IFERROR(I73/($G$73+$I$73+$K$73),\"\")","v":0.5},null,{"$f":"IFERROR(K73/($G$73+$I$73+$K$73),\"\")","v":0},null,{"$f":"IFERROR(M73/(M73+O73+Q73),\"\")","v":0.4},null,{"$f":"IFERROR(O73/(M73+O73+Q73),\"\")","v":0.6},null,{"$f":"IFERROR(Q73/(M73+O73+Q73),\"\")","v":0}]
[null,null,61,"Non Executive Board Member - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G74/($G$74+$I$74+$K$74),\"\")","v":0.625},null,{"$f":"IFERROR(I74/($G$74+$I$74+$K$74),\"\")","v":0.375},null,{"$f":"IFERROR(K74/($G$74+$I$74+$K$74),\"\")","v":0},null,{"$f":"IFERROR(M74/(M74+O74+Q74),\"\")","v":0.625},null,{"$f":"IFERROR(O74/(M74+O74+Q74),\"\")","v":0.375},null,{"$f":"IFERROR(Q74/(M74+O74+Q74),\"\")","v":0}]
[null,null,62,"Overall workforce - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G75/($G$75+$I$75+$K$75),\"\")","v":0.46278062229224104},null,0.51851122489168966,null,1.8708152816069318E-2,null,{"$f":"IFERROR(M75/($M$75+$O$75+$Q$75),\"\")","v":0.48060118839566585},null,{"$f":"IFERROR(O75/($M$75+$O$75+$Q$75),\"\")","v":0.48654316672492137},null,{"$f":"IFERROR(Q75/($M$75+$O$75+$Q$75),\"\")","v":3.2855644879412796E-2}]
[null,null,63,"Difference (Total Board -Overall workforce )","Auto calculated",null,{"$f":"IFERROR(G76-G81,\"\")","v":9.2774933263314541E-2},null,{"$f":"IFERROR(I76-I81,\"\")","v":-7.406678044724524E-2},null,{"$f":"IFERROR(K76-K81,\"\")","v":-1.8708152816069318E-2},null,{"$f":"IFERROR(M76-M81,\"\")","v":1.9398811604334154E-2},null,{"$f":"IFERROR(O76-O81,\"\")","v":1.3456833275078628E-2},null,{"$f":"IFERROR(Q76-Q81,\"\")","v":-3.2855644879412796E-2}]

{"sheet":"Validation and Data Checks","index":4,"n_rows":83,"n_cols":24,"rows_kept":83,"cut":false,"hidden":false,"merged":[[69,0,82,0],[13,13,14,14],[53,0,56,0],[53,1,56,1],[57,0,60,0],[57,1,60,1],[61,0,64,0],[61,1,64,1],[13,11,14,12],[16,0,52,0],[16,1,52,1],[13,0,14,1],[13,4,14,4],[13,5,14,6],[8,2,8,3],[12,5,12,10],[12,11,12,16],[13,15,14,16],[13,17,14,17],[13,7,14,8],[13,9,14,10]]}
[]
[]
[null,"SubmissionTemplate"]
[]
[null,"Workforce Race Equality Standards 2018/19 template"]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(G8>0,\"There are errors. Please ensure all questions are answered\",\"\")","v":""}]
[]
[]
[null,null,null,null,null,"31st MARCH 2018",null,null,null,null,null,"31st MARCH 2019"]
["INDICATOR",null,null,null,"MEASURE","WHITE",null,"BME",null,"ETHNICITY UNKNOWN/NULL",null,"WHITE",null,"BME",null,"ETHNICITY UNKNOWN/NULL",null,"Notes"]
[null,null,"DATA ITEM"]
[]
[1,"Percentage of staff in each of the AfC Bands 1-9 OR Medical and Dental subgroups and VSM (including executive Board members) compared with the percentage of staff in the overall workforce",null,"1a) Non Clinical workforce",null,"ESR figures","Verified figures ","ESR figures","Verified figures ","ESR figures","Verified figures ","ESR figures","Verified figures ","ESR figures","Verified figures ","ESR figures","Verified figures "]
[null,null,1,"Under Band 1","Headcount",{"$f":"IF('Data for submission '!F17=\"\",\"No Data\",IF('Data for submission '!F17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G17=\"\",\"No Data\",IF('Data for submission '!G17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H17=\"\",\"No Data\",IF('Data for submission '!H17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I17=\"\",\"No Data\",IF('Data for submission '!I17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J17=\"\",\"No Data\",IF('Data for submission '!J17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K17=\"\",\"No Data\",IF('Data for submission '!K17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L17=\"\",\"No Data\",IF('Data for submission '!L17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M17=\"\",\"No Data\",IF('Data for submission '!M17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N17=\"\",\"No Data\",IF('Data for submission '!N17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O17=\"\",\"No Data\",IF('Data for submission '!O17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P17=\"\",\"No Data\",IF('Data for submission '!P17<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q17=\"\",\"No Data\",IF('Data for submission '!Q17<0,\"Error\",\"OK\"))","v":"OK"},null,"< Band 1 (i.e. Apprentices)","Non Clinical",null,"White"]
[null,null,2,"Band 1","Headcount",{"$f":"IF('Data for submission '!F18=\"\",\"No Data\",IF('Data for submission '!F18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G18=\"\",\"No Data\",IF('Data for submission '!G18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H18=\"\",\"No Data\",IF('Data for submission '!H18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I18=\"\",\"No Data\",IF('Data for submission '!I18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J18=\"\",\"No Data\",IF('Data for submission '!J18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K18=\"\",\"No Data\",IF('Data for submission '!K18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L18=\"\",\"No Data\",IF('Data for submission '!L18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M18=\"\",\"No Data\",IF('Data for submission '!M18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N18=\"\",\"No Data\",IF('Data for submission '!N18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O18=\"\",\"No Data\",IF('Data for submission '!O18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P18=\"\",\"No Data\",IF('Data for submission '!P18<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q18=\"\",\"No Data\",IF('Data for submission '!Q18<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 1","Non Clinical",null,"BME"]
[null,null,3,"Band 2","Headcount",{"$f":"IF('Data for submission '!F19=\"\",\"No Data\",IF('Data for submission '!F19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G19=\"\",\"No Data\",IF('Data for submission '!G19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H19=\"\",\"No Data\",IF('Data for submission '!H19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I19=\"\",\"No Data\",IF('Data for submission '!I19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J19=\"\",\"No Data\",IF('Data for submission '!J19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K19=\"\",\"No Data\",IF('Data for submission '!K19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L19=\"\",\"No Data\",IF('Data for submission '!L19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M19=\"\",\"No Data\",IF('Data for submission '!M19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N19=\"\",\"No Data\",IF('Data for submission '!N19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O19=\"\",\"No Data\",IF('Data for submission '!O19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P19=\"\",\"No Data\",IF('Data for submission '!P19<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q19=\"\",\"No Data\",IF('Data for submission '!Q19<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 2","Non Clinical",null,"Unknown/Null"]
[null,null,4,"Band 3","Headcount",{"$f":"IF('Data for submission '!F20=\"\",\"No Data\",IF('Data for submission '!F20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G20=\"\",\"No Data\",IF('Data for submission '!G20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H20=\"\",\"No Data\",IF('Data for submission '!H20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I20=\"\",\"No Data\",IF('Data for submission '!I20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J20=\"\",\"No Data\",IF('Data for submission '!J20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K20=\"\",\"No Data\",IF('Data for submission '!K20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L20=\"\",\"No Data\",IF('Data for submission '!L20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M20=\"\",\"No Data\",IF('Data for submission '!M20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N20=\"\",\"No Data\",IF('Data for submission '!N20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O20=\"\",\"No Data\",IF('Data for submission '!O20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P20=\"\",\"No Data\",IF('Data for submission '!P20<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q20=\"\",\"No Data\",IF('Data for submission '!Q20<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 3","Non Clinical"]
[null,null,5,"Band 4","Headcount",{"$f":"IF('Data for submission '!F21=\"\",\"No Data\",IF('Data for submission '!F21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G21=\"\",\"No Data\",IF('Data for submission '!G21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H21=\"\",\"No Data\",IF('Data for submission '!H21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I21=\"\",\"No Data\",IF('Data for submission '!I21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J21=\"\",\"No Data\",IF('Data for submission '!J21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K21=\"\",\"No Data\",IF('Data for submission '!K21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L21=\"\",\"No Data\",IF('Data for submission '!L21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M21=\"\",\"No Data\",IF('Data for submission '!M21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N21=\"\",\"No Data\",IF('Data for submission '!N21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O21=\"\",\"No Data\",IF('Data for submission '!O21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P21=\"\",\"No Data\",IF('Data for submission '!P21<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q21=\"\",\"No Data\",IF('Data for submission '!Q21<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 4","Non Clinical"]
[null,null,6,"Band 5","Headcount",{"$f":"IF('Data for submission '!F22=\"\",\"No Data\",IF('Data for submission '!F22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G22=\"\",\"No Data\",IF('Data for submission '!G22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H22=\"\",\"No Data\",IF('Data for submission '!H22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I22=\"\",\"No Data\",IF('Data for submission '!I22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J22=\"\",\"No Data\",IF('Data for submission '!J22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K22=\"\",\"No Data\",IF('Data for submission '!K22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L22=\"\",\"No Data\",IF('Data for submission '!L22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M22=\"\",\"No Data\",IF('Data for submission '!M22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N22=\"\",\"No Data\",IF('Data for submission '!N22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O22=\"\",\"No Data\",IF('Data for submission '!O22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P22=\"\",\"No Data\",IF('Data for submission '!P22<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q22=\"\",\"No Data\",IF('Data for submission '!Q22<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 5","Non Clinical"]
[null,null,7,"Band 6","Headcount",{"$f":"IF('Data for submission '!F23=\"\",\"No Data\",IF('Data for submission '!F23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G23=\"\",\"No Data\",IF('Data for submission '!G23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H23=\"\",\"No Data\",IF('Data for submission '!H23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I23=\"\",\"No Data\",IF('Data for submission '!I23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J23=\"\",\"No Data\",IF('Data for submission '!J23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K23=\"\",\"No Data\",IF('Data for submission '!K23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L23=\"\",\"No Data\",IF('Data for submission '!L23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M23=\"\",\"No Data\",IF('Data for submission '!M23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N23=\"\",\"No Data\",IF('Data for submission '!N23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O23=\"\",\"No Data\",IF('Data for submission '!O23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P23=\"\",\"No Data\",IF('Data for submission '!P23<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q23=\"\",\"No Data\",IF('Data for submission '!Q23<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 6","Non Clinical"]
[null,null,8,"Band 7","Headcount",{"$f":"IF('Data for submission '!F24=\"\",\"No Data\",IF('Data for submission '!F24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G24=\"\",\"No Data\",IF('Data for submission '!G24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H24=\"\",\"No Data\",IF('Data for submission '!H24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I24=\"\",\"No Data\",IF('Data for submission '!I24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J24=\"\",\"No Data\",IF('Data for submission '!J24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K24=\"\",\"No Data\",IF('Data for submission '!K24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L24=\"\",\"No Data\",IF('Data for submission '!L24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M24=\"\",\"No Data\",IF('Data for submission '!M24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N24=\"\",\"No Data\",IF('Data for submission '!N24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O24=\"\",\"No Data\",IF('Data for submission '!O24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P24=\"\",\"No Data\",IF('Data for submission '!P24<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q24=\"\",\"No Data\",IF('Data for submission '!Q24<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 7","Non Clinical"]
[null,null,9,"Band 8A","Headcount",{"$f":"IF('Data for submission '!F25=\"\",\"No Data\",IF('Data for submission '!F25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G25=\"\",\"No Data\",IF('Data for submission '!G25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H25=\"\",\"No Data\",IF('Data for submission '!H25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I25=\"\",\"No Data\",IF('Data for submission '!I25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J25=\"\",\"No Data\",IF('Data for submission '!J25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K25=\"\",\"No Data\",IF('Data for submission '!K25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L25=\"\",\"No Data\",IF('Data for submission '!L25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M25=\"\",\"No Data\",IF('Data for submission '!M25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N25=\"\",\"No Data\",IF('Data for submission '!N25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O25=\"\",\"No Data\",IF('Data for submission '!O25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P25=\"\",\"No Data\",IF('Data for submission '!P25<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q25=\"\",\"No Data\",IF('Data for submission '!Q25<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 8a","Non Clinical"]
[null,null,10,"Band 8B","Headcount",{"$f":"IF('Data for submission '!F26=\"\",\"No Data\",IF('Data for submission '!F26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G26=\"\",\"No Data\",IF('Data for submission '!G26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H26=\"\",\"No Data\",IF('Data for submission '!H26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I26=\"\",\"No Data\",IF('Data for submission '!I26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J26=\"\",\"No Data\",IF('Data for submission '!J26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K26=\"\",\"No Data\",IF('Data for submission '!K26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L26=\"\",\"No Data\",IF('Data for submission '!L26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M26=\"\",\"No Data\",IF('Data for submission '!M26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N26=\"\",\"No Data\",IF('Data for submission '!N26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O26=\"\",\"No Data\",IF('Data for submission '!O26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P26=\"\",\"No Data\",IF('Data for submission '!P26<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q26=\"\",\"No Data\",IF('Data for submission '!Q26<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 8b","Non Clinical"]
[null,null,11,"Band 8C","Headcount",{"$f":"IF('Data for submission '!F27=\"\",\"No Data\",IF('Data for submission '!F27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G27=\"\",\"No Data\",IF('Data for submission '!G27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H27=\"\",\"No Data\",IF('Data for submission '!H27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I27=\"\",\"No Data\",IF('Data for submission '!I27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J27=\"\",\"No Data\",IF('Data for submission '!J27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K27=\"\",\"No Data\",IF('Data for submission '!K27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L27=\"\",\"No Data\",IF('Data for submission '!L27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M27=\"\",\"No Data\",IF('Data for submission '!M27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N27=\"\",\"No Data\",IF('Data for submission '!N27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O27=\"\",\"No Data\",IF('Data for submission '!O27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P27=\"\",\"No Data\",IF('Data for submission '!P27<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q27=\"\",\"No Data\",IF('Data for submission '!Q27<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 8c","Non Clinical"]
[null,null,12,"Band 8D","Headcount",{"$f":"IF('Data for submission '!F28=\"\",\"No Data\",IF('Data for submission '!F28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G28=\"\",\"No Data\",IF('Data for submission '!G28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H28=\"\",\"No Data\",IF('Data for submission '!H28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I28=\"\",\"No Data\",IF('Data for submission '!I28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J28=\"\",\"No Data\",IF('Data for submission '!J28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K28=\"\",\"No Data\",IF('Data for submission '!K28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L28=\"\",\"No Data\",IF('Data for submission '!L28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M28=\"\",\"No Data\",IF('Data for submission '!M28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N28=\"\",\"No Data\",IF('Data for submission '!N28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O28=\"\",\"No Data\",IF('Data for submission '!O28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P28=\"\",\"No Data\",IF('Data for submission '!P28<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q28=\"\",\"No Data\",IF('Data for submission '!Q28<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 8d","Non Clinical"]
[null,null,13,"Band 9","Headcount",{"$f":"IF('Data for submission '!F29=\"\",\"No Data\",IF('Data for submission '!F29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G29=\"\",\"No Data\",IF('Data for submission '!G29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H29=\"\",\"No Data\",IF('Data for submission '!H29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I29=\"\",\"No Data\",IF('Data for submission '!I29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J29=\"\",\"No Data\",IF('Data for submission '!J29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K29=\"\",\"No Data\",IF('Data for submission '!K29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L29=\"\",\"No Data\",IF('Data for submission '!L29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M29=\"\",\"No Data\",IF('Data for submission '!M29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N29=\"\",\"No Data\",IF('Data for submission '!N29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O29=\"\",\"No Data\",IF('Data for submission '!O29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P29=\"\",\"No Data\",IF('Data for submission '!P29<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q29=\"\",\"No Data\",IF('Data for submission '!Q29<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 9","Non Clinical"]
[null,null,14,"VSM","Headcount",{"$f":"IF('Data for submission '!F30=\"\",\"No Data\",IF('Data for submission '!F30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G30=\"\",\"No Data\",IF('Data for submission '!G30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H30=\"\",\"No Data\",IF('Data for submission '!H30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I30=\"\",\"No Data\",IF('Data for submission '!I30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J30=\"\",\"No Data\",IF('Data for submission '!J30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K30=\"\",\"No Data\",IF('Data for submission '!K30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L30=\"\",\"No Data\",IF('Data for submission '!L30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M30=\"\",\"No Data\",IF('Data for submission '!M30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N30=\"\",\"No Data\",IF('Data for submission '!N30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O30=\"\",\"No Data\",IF('Data for submission '!O30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P30=\"\",\"No Data\",IF('Data for submission '!P30<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q30=\"\",\"No Data\",IF('Data for submission '!Q30<0,\"Error\",\"OK\"))","v":"OK"},null,"VSM","Non Clinical"]
[null,null,null,"1b) Clinical workforce"]
[null,null,null,"of which Non Medical"]
[null,null,15,"Under Band 1","Headcount",{"$f":"IF('Data for submission '!F33=\"\",\"No Data\",IF('Data for submission '!F33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G33=\"\",\"No Data\",IF('Data for submission '!G33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H33=\"\",\"No Data\",IF('Data for submission '!H33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I33=\"\",\"No Data\",IF('Data for submission '!I33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J33=\"\",\"No Data\",IF('Data for submission '!J33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K33=\"\",\"No Data\",IF('Data for submission '!K33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L33=\"\",\"No Data\",IF('Data for submission '!L33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M33=\"\",\"No Data\",IF('Data for submission '!M33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N33=\"\",\"No Data\",IF('Data for submission '!N33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O33=\"\",\"No Data\",IF('Data for submission '!O33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P33=\"\",\"No Data\",IF('Data for submission '!P33<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q33=\"\",\"No Data\",IF('Data for submission '!Q33<0,\"Error\",\"OK\"))","v":"OK"},null,"< Band 1 (i.e. Apprentices)","Clinical"]
[null,null,16,"Band 1","Headcount",{"$f":"IF('Data for submission '!F34=\"\",\"No Data\",IF('Data for submission '!F34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G34=\"\",\"No Data\",IF('Data for submission '!G34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H34=\"\",\"No Data\",IF('Data for submission '!H34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I34=\"\",\"No Data\",IF('Data for submission '!I34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J34=\"\",\"No Data\",IF('Data for submission '!J34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K34=\"\",\"No Data\",IF('Data for submission '!K34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L34=\"\",\"No Data\",IF('Data for submission '!L34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M34=\"\",\"No Data\",IF('Data for submission '!M34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N34=\"\",\"No Data\",IF('Data for submission '!N34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O34=\"\",\"No Data\",IF('Data for submission '!O34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P34=\"\",\"No Data\",IF('Data for submission '!P34<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q34=\"\",\"No Data\",IF('Data for submission '!Q34<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 1","Clinical"]
[null,null,17,"Band 2","Headcount",{"$f":"IF('Data for submission '!F35=\"\",\"No Data\",IF('Data for submission '!F35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G35=\"\",\"No Data\",IF('Data for submission '!G35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H35=\"\",\"No Data\",IF('Data for submission '!H35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I35=\"\",\"No Data\",IF('Data for submission '!I35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J35=\"\",\"No Data\",IF('Data for submission '!J35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K35=\"\",\"No Data\",IF('Data for submission '!K35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L35=\"\",\"No Data\",IF('Data for submission '!L35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M35=\"\",\"No Data\",IF('Data for submission '!M35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N35=\"\",\"No Data\",IF('Data for submission '!N35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O35=\"\",\"No Data\",IF('Data for submission '!O35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P35=\"\",\"No Data\",IF('Data for submission '!P35<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q35=\"\",\"No Data\",IF('Data for submission '!Q35<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 2","Clinical"]
[null,null,18,"Band 3","Headcount",{"$f":"IF('Data for submission '!F36=\"\",\"No Data\",IF('Data for submission '!F36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G36=\"\",\"No Data\",IF('Data for submission '!G36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H36=\"\",\"No Data\",IF('Data for submission '!H36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I36=\"\",\"No Data\",IF('Data for submission '!I36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J36=\"\",\"No Data\",IF('Data for submission '!J36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K36=\"\",\"No Data\",IF('Data for submission '!K36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L36=\"\",\"No Data\",IF('Data for submission '!L36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M36=\"\",\"No Data\",IF('Data for submission '!M36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N36=\"\",\"No Data\",IF('Data for submission '!N36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O36=\"\",\"No Data\",IF('Data for submission '!O36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P36=\"\",\"No Data\",IF('Data for submission '!P36<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q36=\"\",\"No Data\",IF('Data for submission '!Q36<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 3","Clinical"]
[null,null,19,"Band 4","Headcount",{"$f":"IF('Data for submission '!F37=\"\",\"No Data\",IF('Data for submission '!F37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G37=\"\",\"No Data\",IF('Data for submission '!G37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H37=\"\",\"No Data\",IF('Data for submission '!H37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I37=\"\",\"No Data\",IF('Data for submission '!I37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J37=\"\",\"No Data\",IF('Data for submission '!J37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K37=\"\",\"No Data\",IF('Data for submission '!K37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L37=\"\",\"No Data\",IF('Data for submission '!L37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M37=\"\",\"No Data\",IF('Data for submission '!M37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N37=\"\",\"No Data\",IF('Data for submission '!N37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O37=\"\",\"No Data\",IF('Data for submission '!O37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P37=\"\",\"No Data\",IF('Data for submission '!P37<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q37=\"\",\"No Data\",IF('Data for submission '!Q37<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 4","Clinical"]
[null,null,20,"Band 5","Headcount",{"$f":"IF('Data for submission '!F38=\"\",\"No Data\",IF('Data for submission '!F38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G38=\"\",\"No Data\",IF('Data for submission '!G38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H38=\"\",\"No Data\",IF('Data for submission '!H38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I38=\"\",\"No Data\",IF('Data for submission '!I38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J38=\"\",\"No Data\",IF('Data for submission '!J38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K38=\"\",\"No Data\",IF('Data for submission '!K38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L38=\"\",\"No Data\",IF('Data for submission '!L38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M38=\"\",\"No Data\",IF('Data for submission '!M38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N38=\"\",\"No Data\",IF('Data for submission '!N38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O38=\"\",\"No Data\",IF('Data for submission '!O38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P38=\"\",\"No Data\",IF('Data for submission '!P38<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q38=\"\",\"No Data\",IF('Data for submission '!Q38<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 5","Clinical"]
[null,null,21,"Band 6","Headcount",{"$f":"IF('Data for submission '!F39=\"\",\"No Data\",IF('Data for submission '!F39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G39=\"\",\"No Data\",IF('Data for submission '!G39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H39=\"\",\"No Data\",IF('Data for submission '!H39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I39=\"\",\"No Data\",IF('Data for submission '!I39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J39=\"\",\"No Data\",IF('Data for submission '!J39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K39=\"\",\"No Data\",IF('Data for submission '!K39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L39=\"\",\"No Data\",IF('Data for submission '!L39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M39=\"\",\"No Data\",IF('Data for submission '!M39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N39=\"\",\"No Data\",IF('Data for submission '!N39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O39=\"\",\"No Data\",IF('Data for submission '!O39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P39=\"\",\"No Data\",IF('Data for submission '!P39<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q39=\"\",\"No Data\",IF('Data for submission '!Q39<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 6","Clinical"]
[null,null,22,"Band 7","Headcount",{"$f":"IF('Data for submission '!F40=\"\",\"No Data\",IF('Data for submission '!F40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G40=\"\",\"No Data\",IF('Data for submission '!G40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H40=\"\",\"No Data\",IF('Data for submission '!H40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I40=\"\",\"No Data\",IF('Data for submission '!I40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J40=\"\",\"No Data\",IF('Data for submission '!J40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K40=\"\",\"No Data\",IF('Data for submission '!K40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L40=\"\",\"No Data\",IF('Data for submission '!L40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M40=\"\",\"No Data\",IF('Data for submission '!M40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N40=\"\",\"No Data\",IF('Data for submission '!N40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O40=\"\",\"No Data\",IF('Data for submission '!O40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P40=\"\",\"No Data\",IF('Data for submission '!P40<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q40=\"\",\"No Data\",IF('Data for submission '!Q40<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 7","Clinical"]
[null,null,23,"Band 8A","Headcount",{"$f":"IF('Data for submission '!F41=\"\",\"No Data\",IF('Data for submission '!F41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G41=\"\",\"No Data\",IF('Data for submission '!G41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H41=\"\",\"No Data\",IF('Data for submission '!H41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I41=\"\",\"No Data\",IF('Data for submission '!I41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J41=\"\",\"No Data\",IF('Data for submission '!J41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K41=\"\",\"No Data\",IF('Data for submission '!K41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L41=\"\",\"No Data\",IF('Data for submission '!L41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M41=\"\",\"No Data\",IF('Data for submission '!M41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N41=\"\",\"No Data\",IF('Data for submission '!N41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O41=\"\",\"No Data\",IF('Data for submission '!O41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P41=\"\",\"No Data\",IF('Data for submission '!P41<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q41=\"\",\"No Data\",IF('Data for submission '!Q41<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 8a","Clinical"]
[null,null,24,"Band 8B","Headcount",{"$f":"IF('Data for submission '!F42=\"\",\"No Data\",IF('Data for submission '!F42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G42=\"\",\"No Data\",IF('Data for submission '!G42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H42=\"\",\"No Data\",IF('Data for submission '!H42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I42=\"\",\"No Data\",IF('Data for submission '!I42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J42=\"\",\"No Data\",IF('Data for submission '!J42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K42=\"\",\"No Data\",IF('Data for submission '!K42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L42=\"\",\"No Data\",IF('Data for submission '!L42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M42=\"\",\"No Data\",IF('Data for submission '!M42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N42=\"\",\"No Data\",IF('Data for submission '!N42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O42=\"\",\"No Data\",IF('Data for submission '!O42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P42=\"\",\"No Data\",IF('Data for submission '!P42<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q42=\"\",\"No Data\",IF('Data for submission '!Q42<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 8b","Clinical"]
[null,null,25,"Band 8C","Headcount",{"$f":"IF('Data for submission '!F43=\"\",\"No Data\",IF('Data for submission '!F43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G43=\"\",\"No Data\",IF('Data for submission '!G43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H43=\"\",\"No Data\",IF('Data for submission '!H43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I43=\"\",\"No Data\",IF('Data for submission '!I43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J43=\"\",\"No Data\",IF('Data for submission '!J43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K43=\"\",\"No Data\",IF('Data for submission '!K43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L43=\"\",\"No Data\",IF('Data for submission '!L43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M43=\"\",\"No Data\",IF('Data for submission '!M43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N43=\"\",\"No Data\",IF('Data for submission '!N43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O43=\"\",\"No Data\",IF('Data for submission '!O43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P43=\"\",\"No Data\",IF('Data for submission '!P43<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q43=\"\",\"No Data\",IF('Data for submission '!Q43<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 8c","Clinical"]
[null,null,26,"Band 8D","Headcount",{"$f":"IF('Data for submission '!F44=\"\",\"No Data\",IF('Data for submission '!F44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G44=\"\",\"No Data\",IF('Data for submission '!G44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H44=\"\",\"No Data\",IF('Data for submission '!H44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I44=\"\",\"No Data\",IF('Data for submission '!I44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J44=\"\",\"No Data\",IF('Data for submission '!J44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K44=\"\",\"No Data\",IF('Data for submission '!K44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L44=\"\",\"No Data\",IF('Data for submission '!L44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M44=\"\",\"No Data\",IF('Data for submission '!M44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N44=\"\",\"No Data\",IF('Data for submission '!N44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O44=\"\",\"No Data\",IF('Data for submission '!O44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P44=\"\",\"No Data\",IF('Data for submission '!P44<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q44=\"\",\"No Data\",IF('Data for submission '!Q44<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 8d","Clinical"]
[null,null,27,"Band 9","Headcount",{"$f":"IF('Data for submission '!F45=\"\",\"No Data\",IF('Data for submission '!F45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G45=\"\",\"No Data\",IF('Data for submission '!G45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H45=\"\",\"No Data\",IF('Data for submission '!H45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I45=\"\",\"No Data\",IF('Data for submission '!I45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J45=\"\",\"No Data\",IF('Data for submission '!J45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K45=\"\",\"No Data\",IF('Data for submission '!K45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L45=\"\",\"No Data\",IF('Data for submission '!L45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M45=\"\",\"No Data\",IF('Data for submission '!M45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N45=\"\",\"No Data\",IF('Data for submission '!N45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O45=\"\",\"No Data\",IF('Data for submission '!O45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P45=\"\",\"No Data\",IF('Data for submission '!P45<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q45=\"\",\"No Data\",IF('Data for submission '!Q45<0,\"Error\",\"OK\"))","v":"OK"},null,"Band 9","Clinical"]
[null,null,28,"VSM","Headcount",{"$f":"IF('Data for submission '!F46=\"\",\"No Data\",IF('Data for submission '!F46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G46=\"\",\"No Data\",IF('Data for submission '!G46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H46=\"\",\"No Data\",IF('Data for submission '!H46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I46=\"\",\"No Data\",IF('Data for submission '!I46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J46=\"\",\"No Data\",IF('Data for submission '!J46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K46=\"\",\"No Data\",IF('Data for submission '!K46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L46=\"\",\"No Data\",IF('Data for submission '!L46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M46=\"\",\"No Data\",IF('Data for submission '!M46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N46=\"\",\"No Data\",IF('Data for submission '!N46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O46=\"\",\"No Data\",IF('Data for submission '!O46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P46=\"\",\"No Data\",IF('Data for submission '!P46<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q46=\"\",\"No Data\",IF('Data for submission '!Q46<0,\"Error\",\"OK\"))","v":"OK"},null,"VSM","Clinical"]
[null,null,null,"Of which Medical & Dental"]
[null,null,29,"Consultants","Headcount",{"$f":"IF('Data for submission '!F48=\"\",\"No Data\",IF('Data for submission '!F48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G48=\"\",\"No Data\",IF('Data for submission '!G48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H48=\"\",\"No Data\",IF('Data for submission '!H48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I48=\"\",\"No Data\",IF('Data for submission '!I48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J48=\"\",\"No Data\",IF('Data for submission '!J48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K48=\"\",\"No Data\",IF('Data for submission '!K48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L48=\"\",\"No Data\",IF('Data for submission '!L48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M48=\"\",\"No Data\",IF('Data for submission '!M48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N48=\"\",\"No Data\",IF('Data for submission '!N48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O48=\"\",\"No Data\",IF('Data for submission '!O48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P48=\"\",\"No Data\",IF('Data for submission '!P48<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q48=\"\",\"No Data\",IF('Data for submission '!Q48<0,\"Error\",\"OK\"))","v":"OK"},null,"Medical & Dental Consultant","Clinical"]
[null,null,30,"  of which Senior medical manager","Headcount"]
[null,null,31,"Non-consultant career grade","Headcount",{"$f":"IF('Data for submission '!F50=\"\",\"No Data\",IF('Data for submission '!F50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G50=\"\",\"No Data\",IF('Data for submission '!G50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H50=\"\",\"No Data\",IF('Data for submission '!H50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I50=\"\",\"No Data\",IF('Data for submission '!I50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J50=\"\",\"No Data\",IF('Data for submission '!J50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K50=\"\",\"No Data\",IF('Data for submission '!K50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L50=\"\",\"No Data\",IF('Data for submission '!L50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M50=\"\",\"No Data\",IF('Data for submission '!M50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N50=\"\",\"No Data\",IF('Data for submission '!N50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O50=\"\",\"No Data\",IF('Data for submission '!O50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P50=\"\",\"No Data\",IF('Data for submission '!P50<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q50=\"\",\"No Data\",IF('Data for submission '!Q50<0,\"Error\",\"OK\"))","v":"OK"},null,"Medical & Dental Non-consultant career grade","Clinical"]
[null,null,32,"Trainee grades","Headcount",{"$f":"IF('Data for submission '!F51=\"\",\"No Data\",IF('Data for submission '!F51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G51=\"\",\"No Data\",IF('Data for submission '!G51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H51=\"\",\"No Data\",IF('Data for submission '!H51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I51=\"\",\"No Data\",IF('Data for submission '!I51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J51=\"\",\"No Data\",IF('Data for submission '!J51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K51=\"\",\"No Data\",IF('Data for submission '!K51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L51=\"\",\"No Data\",IF('Data for submission '!L51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M51=\"\",\"No Data\",IF('Data for submission '!M51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N51=\"\",\"No Data\",IF('Data for submission '!N51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O51=\"\",\"No Data\",IF('Data for submission '!O51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P51=\"\",\"No Data\",IF('Data for submission '!P51<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q51=\"\",\"No Data\",IF('Data for submission '!Q51<0,\"Error\",\"OK\"))","v":"OK"},null,"Medical & Dental Trainee grades","Clinical"]
[null,null,33,"Other","Headcount",{"$f":"IF('Data for submission '!F52=\"\",\"No Data\",IF('Data for submission '!F52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!G52=\"\",\"No Data\",IF('Data for submission '!G52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!H52=\"\",\"No Data\",IF('Data for submission '!H52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!I52=\"\",\"No Data\",IF('Data for submission '!I52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!J52=\"\",\"No Data\",IF('Data for submission '!J52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!K52=\"\",\"No Data\",IF('Data for submission '!K52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!L52=\"\",\"No Data\",IF('Data for submission '!L52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!M52=\"\",\"No Data\",IF('Data for submission '!M52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!N52=\"\",\"No Data\",IF('Data for submission '!N52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!O52=\"\",\"No Data\",IF('Data for submission '!O52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!P52=\"\",\"No Data\",IF('Data for submission '!P52<0,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF('Data for submission '!Q52=\"\",\"No Data\",IF('Data for submission '!Q52<0,\"Error\",\"OK\"))","v":"OK"},null,"Medical & Dental Other","Clinical"]
[2,"Relative likelihood of staff being appointed from shortlisting across all posts\n",34,"Number of shortlisted applicants:","Headcount",null,{"$f":"IF('Data for submission '!G53=\"\",\"No Data\",IF('Data for submission '!G53<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I53=\"\",\"No Data\",IF('Data for submission '!I53<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!K53=\"\",\"No Data\",IF('Data for submission '!K53<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!M53=\"\",\"No Data\",IF('Data for submission '!M53<'Data for submission '!M54,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O53=\"\",\"No Data\",IF('Data for submission '!O53<'Data for submission '!O54,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!Q53=\"\",\"No Data\",IF('Data for submission '!Q53<0,\"Error\",\"OK\"))","v":"OK"},null,null,null,null,null,2.5522925244872678,0.55591665613817309]
[null,null,35,"Number appointed from shortlisting:","Headcount",null,{"$f":"IF('Data for submission '!G54=\"\",\"No Data\",IF('Data for submission '!G54<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I54=\"\",\"No Data\",IF('Data for submission '!I54<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!K54=\"\",\"No Data\",IF('Data for submission '!K54<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!M54=\"\",\"No data\",IF('Data for submission '!M54>'Data for submission '!M53,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O54=\"\",\"No data\",IF('Data for submission '!O54>'Data for submission '!O53,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!Q54=\"\",\"No Data\",IF('Data for submission '!Q54<0,\"Error\",\"OK\"))","v":"OK"}]
[null,null,36,"Relative likelihood of shortlisting/appointed:","Auto calculated",null,{"$f":"IFERROR(G55/G54,\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(M55/M54,\"\")","v":""},null,{"$f":"IFERROR(O55/O54,\"\")","v":""}]
[null,null,37,"Relative likelihood of White staff being appointed from shortlisting compared to BME staff:","Auto calculated",null,null,null,null,null,null,null,{"$f":"IFERROR(M56/O56,\"\")","v":""}]
[3,"Relative likelihood of staff entering the formal disciplinary process, as measured by entry into a formal disciplinary investigation\nNote: This indicator will be based on data from a two year rolling average of the current year and the previous year",38,"Number of staff in workforce:","Headcount",null,{"$f":"IF('Data for submission '!G57=\"\",\"No Data\",IF('Data for submission '!G57<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I57=\"\",\"No Data\",IF('Data for submission '!I57<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!K57=\"\",\"No Data\",IF('Data for submission '!K57<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!M57=\"\",\"No data\",IF('Data for submission '!M57<'Data for submission '!M58,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O57=\"\",\"No data\",IF('Data for submission '!O57<'Data for submission '!O58,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!Q57=\"\",\"No data\",IF('Data for submission '!Q57<'Data for submission '!Q58,\"Error\",\"OK\"))","v":"OK"},null,null,null,null,null,4.3158680043516524,0]
[null,null,39,"Number of staff entering the formal disciplinary process:","Headcount",null,{"$f":"IF('Data for submission '!G58=\"\",\"No Data\",IF('Data for submission '!G58<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I58=\"\",\"No Data\",IF('Data for submission '!I58<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!K58=\"\",\"No Data\",IF('Data for submission '!K58<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!M58=\"\",\"No Data\",IF('Data for submission '!M58>'Data for submission '!M57,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O58=\"\",\"No Data\",IF('Data for submission '!O58>'Data for submission '!O57,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!Q58=\"\",\"No Data\",IF('Data for submission '!Q58>'Data for submission '!Q57,\"Error\",\"OK\"))","v":"OK"}]
[null,null,40,"Likelihood of staff entering the formal disciplinary process:","Auto calculated"]
[null,null,41,"Relative likelihood of BME staff entering the formal disciplinary process compared to White staff:","Auto calculated",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(O60/M60,\"\")","v":""}]
[4,"Relative likelihood of staff accessing non-mandatory training and CPD",42,"Number of staff in workforce:","Headcount",null,{"$f":"IF('Data for submission '!G61=\"\",\"No Data\",IF('Data for submission '!G61<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I61=\"\",\"No Data\",IF('Data for submission '!I61<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!K61=\"\",\"No Data\",IF('Data for submission '!K61<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!M61=\"\",\"No Data\",IF('Data for submission '!M61<'Data for submission '!M62,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O61=\"\",\"No Data\",IF('Data for submission '!O61<'Data for submission '!O62,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!Q61=\"\",\"No Data\",IF('Data for submission '!Q61<'Data for submission '!Q62,\"Error\",\"OK\"))","v":"OK"},null,null,null,null,null,2.0521583133406875,0.10298981852318034]
[null,null,43,"Number of staff accessing non-mandatory training and CPD: ","Headcount",null,{"$f":"IF('Data for submission '!G62=\"\",\"No Data\",IF('Data for submission '!G62<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I62=\"\",\"No Data\",IF('Data for submission '!I62<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!K62=\"\",\"No Data\",IF('Data for submission '!K62<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!M62=\"\",\"No Data\",IF('Data for submission '!M62>'Data for submission '!M61,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O62=\"\",\"No Data\",IF('Data for submission '!O62>'Data for submission '!O61,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!Q62=\"\",\"No Data\",IF('Data for submission '!Q62>'Data for submission '!Q61,\"Error\",\"OK\"))","v":"OK"}]
[null,null,44,"Likelihood of staff accessing non-mandatory training and CPD:","Auto calculated"]
[null,null,45,"Relative likelihood of White staff accessing non-mandatory training and CPD compared to BME staff:","Auto calculated"]
[5,"Percentage of staff experiencing harassment, bullying or abuse from patients, relatives\n or the public in last 12 months ",46,"% of  staff experiencing harassment, bullying or abuse from patients, relatives  or the public in last 12 months ","Percentage",null,{"$f":"IF('Data for submission '!G65=\"\",\"No Data\",IF('Data for submission '!G65<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I65=\"\",\"No Data\",IF('Data for submission '!I65<0,\"Error\",\"OK\"))","v":"OK"},null,null,{"$f":"IF('Data for submission '!M65=\"\",\"No Data\",IF('Data for submission '!M65<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O65=\"\",\"No Data\",IF('Data for submission '!O65<0,\"Error\",\"OK\"))","v":"OK"}]
[6,"Percentage of staff experiencing harassment, bullying or abuse from \nstaff in last 12 months ",47,"% of  staff experiencing harassment, bullying or abuse from staff in last 12 months ","Percentage",null,{"$f":"IF('Data for submission '!G66=\"\",\"No Data\",IF('Data for submission '!G66<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I66=\"\",\"No Data\",IF('Data for submission '!I66<0,\"Error\",\"OK\"))","v":"OK"},null,null,{"$f":"IF('Data for submission '!M66=\"\",\"No Data\",IF('Data for submission '!M66<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O66=\"\",\"No Data\",IF('Data for submission '!O66<0,\"Error\",\"OK\"))","v":"OK"}]
[7,"Percentage believing that trust provides equal opportunities for career \nprogression or promotion",48,"%  staff believing that trust provides equal opportunities for career \nprogression or promotion","Percentage",null,{"$f":"IF('Data for submission '!G67=\"\",\"No Data\",IF('Data for submission '!G67<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I67=\"\",\"No Data\",IF('Data for submission '!I67<0,\"Error\",\"OK\"))","v":"OK"},null,null,{"$f":"IF('Data for submission '!M67=\"\",\"No Data\",IF('Data for submission '!M67<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O67=\"\",\"No Data\",IF('Data for submission '!O67<0,\"Error\",\"OK\"))","v":"OK"}]
[8,"In the last 12 months have you personally experienced discrimination at work from any of the following?\n b) Manager/team leader or other colleagues",49,"%  staff personally experienced discrimination at work from Manager/team leader or other colleague","Percentage",null,{"$f":"IF('Data for submission '!G68=\"\",\"No Data\",IF('Data for submission '!G68<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I68=\"\",\"No Data\",IF('Data for submission '!I68<0,\"Error\",\"OK\"))","v":"OK"},null,null,{"$f":"IF('Data for submission '!M68=\"\",\"No Data\",IF('Data for submission '!M68<0,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O68=\"\",\"No Data\",IF('Data for submission '!O68<0,\"Error\",\"OK\"))","v":"OK"}]
[9,"Percentage difference between the organisations’ Board voting membership and its overall workforce\nNote: Only voting members of the Board should be included when considering this indicator",50,"Total Board members","Headcount",null,{"$f":"IF('Data for submission '!G69=\"\",\"No Data\",IF('Data for submission '!G69<'Data for submission '!G70,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I69=\"\",\"No Data\",IF('Data for submission '!I69<'Data for submission '!I70,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!K69=\"\",\"No Data\",IF('Data for submission '!K69<'Data for submission '!K70,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!M69=\"\",\"No Data\",IF('Data for submission '!M69<'Data for submission '!M70,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O69=\"\",\"No Data\",IF('Data for submission '!O69<'Data for submission '!O70,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!Q69=\"\",\"No Data\",IF('Data for submission '!Q69<'Data for submission '!Q70,\"Error\",\"OK\"))","v":"OK"}]
[null,null,51," of which: Voting Board members","Headcount",null,{"$f":"IF('Data for submission '!G70=\"\",\"No Data\",IF('Data for submission '!G70>'Data for submission '!G69,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I70=\"\",\"No Data\",IF('Data for submission '!I70>'Data for submission '!I69,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!K70=\"\",\"No Data\",IF('Data for submission '!K70>'Data for submission '!K69,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!M70=\"\",\"No Data\",IF('Data for submission '!M70>'Data for submission '!M69,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O70=\"\",\"No Data\",IF('Data for submission '!O70>'Data for submission '!O69,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!Q70=\"\",\"No Data\",IF('Data for submission '!Q70>'Data for submission '!Q69,\"Error\",\"OK\"))","v":"OK"}]
[null,null,52,"                 : Non Voting Board members","Autocalculated",null,{"$f":"IF('Data for submission '!G71=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!I71=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!K71=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!M71=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!O71=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!Q71=\"Error\",\"Error\",\"\")","v":""}]
[null,null,53,"Total Board members","Headcount",null,{"$f":"G70","v":"OK"},null,{"$f":"I70","v":"OK"},null,{"$f":"K70","v":"OK"},null,{"$f":"M70","v":"OK"},null,{"$f":"O70","v":"OK"},null,{"$f":"Q70","v":"OK"}]
[null,null,54," of which: Exec Board members","Headcount",null,{"$f":"IF('Data for submission '!G73=\"\",\"No Data\",IF('Data for submission '!G73>'Data for submission '!G72,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!I73=\"\",\"No Data\",IF('Data for submission '!I73>'Data for submission '!I72,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!K73=\"\",\"No Data\",IF('Data for submission '!K73>'Data for submission '!K72,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!M73=\"\",\"No Data\",IF('Data for submission '!M73>'Data for submission '!M72,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!O73=\"\",\"No Data\",IF('Data for submission '!O73>'Data for submission '!O72,\"Error\",\"OK\"))","v":"OK"},null,{"$f":"IF('Data for submission '!Q73=\"\",\"No Data\",IF('Data for submission '!Q73>'Data for submission '!Q72,\"Error\",\"OK\"))","v":"OK"}]
[null,null,55,"                 : Non Executive Board members","Autocalculated",null,{"$f":"IF('Data for submission '!G74=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!I74=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!K74=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!M74=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!O74=\"Error\",\"Error\",\"\")","v":""},null,{"$f":"IF('Data for submission '!Q74=\"Error\",\"Error\",\"\")","v":""}]
[null,null,56,"Number of staff in overall workforce","Headcount",null,{"$f":"G58","v":"OK"},null,{"$f":"I58","v":"OK"},null,{"$f":"K58","v":"OK"},null,{"$f":"M58","v":"OK"},null,{"$f":"O58","v":"OK"},null,{"$f":"Q58","v":"OK"}]
[null,null,57,"Total Board members - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G70/($G$70+$I$70+$K$70),\"\")","v":""},null,{"$f":"IFERROR(I70/($G$70+$I$70+$K$70),\"\")","v":""},null,{"$f":"IFERROR(K70/($G$70+$I$70+$K$70),\"\")","v":""},null,{"$f":"IFERROR(M70/(M70+O70+Q70),\"\")","v":""},null,{"$f":"IFERROR(O70/(M70+O70+Q70),\"\")","v":""},null,{"$f":"IFERROR(Q70/(M70+O70+Q70),\"\")","v":""}]
[null,null,58,"Voting Board Member - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G71/($G$71+$I$71+$K$71),\"\")","v":""},null,{"$f":"IFERROR(I71/($G$71+$I$71+$K$71),\"\")","v":""},null,{"$f":"IFERROR(K71/($G$71+$I$71+$K$71),\"\")","v":""},null,{"$f":"IFERROR(M71/(M71+O71+Q71),\"\")","v":""},null,{"$f":"IFERROR(O71/(M71+O71+Q71),\"\")","v":""},null,{"$f":"IFERROR(Q71/(M71+O71+Q71),\"\")","v":""}]
[null,null,59,"Non Voting Board Member - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G72/($G$72+$I$72+$K$72),\"\")","v":""},null,{"$f":"IFERROR(I72/($G$72+$I$72+$K$72),\"\")","v":""},null,{"$f":"IFERROR(K72/($G$72+$I$72+$K$72),\"\")","v":""},null,{"$f":"IFERROR(M72/(M72+O72+Q72),\"\")","v":""},null,{"$f":"IFERROR(O72/(M72+O72+Q72),\"\")","v":""},null,{"$f":"IFERROR(Q72/(M72+O72+Q72),\"\")","v":""}]
[null,null,60,"Executive Board Member - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G74/($G$74+$I$74+$K$74),\"\")","v":""},null,{"$f":"IFERROR(I74/($G$74+$I$74+$K$74),\"\")","v":""},null,{"$f":"IFERROR(K74/($G$74+$I$74+$K$74),\"\")","v":""},null,{"$f":"IFERROR(M74/(M74+O74+Q74),\"\")","v":""},null,{"$f":"IFERROR(O74/(M74+O74+Q74),\"\")","v":""},null,{"$f":"IFERROR(Q74/(M74+O74+Q74),\"\")","v":""}]
[null,null,61,"Non Executive Board Member - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G75/($G$75+$I$75+$K$75),\"\")","v":""},null,{"$f":"IFERROR(I75/($G$75+$I$75+$K$75),\"\")","v":""},null,{"$f":"IFERROR(K75/($G$75+$I$75+$K$75),\"\")","v":""},null,{"$f":"IFERROR(M75/(M75+O75+Q75),\"\")","v":""},null,{"$f":"IFERROR(O75/(M75+O75+Q75),\"\")","v":""},null,{"$f":"IFERROR(Q75/(M75+O75+Q75),\"\")","v":""}]
[null,null,62,"Overall workforce - % by Ethnicity","Auto calculated",null,{"$f":"IFERROR(G76/($G$76+$I$76+$K$76),\"\")","v":""},null,{"$f":"IFERROR(I76/($G$76+$I$76+$K$76),\"\")","v":""},null,{"$f":"IFERROR(K76/($G$76+$I$76+$K$76),\"\")","v":""},null,{"$f":"IFERROR(M76/($M$76+$O$76+$Q$76),\"\")","v":""},null,{"$f":"IFERROR(O76/($M$76+$O$76+$Q$76),\"\")","v":""},null,{"$f":"IFERROR(Q76/($M$76+$O$76+$Q$76),\"\")","v":""}]
[null,null,63,"Difference (Total Board -Overall workforce )","Auto calculated",null,{"$f":"IFERROR(G77-G82,\"\")","v":""},null,{"$f":"IFERROR(I77-I82,\"\")","v":""},null,{"$f":"IFERROR(K77-K82,\"\")","v":""},null,{"$f":"IFERROR(M77-M82,\"\")","v":""},null,{"$f":"IFERROR(O77-O82,\"\")","v":""},null,{"$f":"IFERROR(Q77-Q82,\"\")","v":""}]

{"sheet":"Backsheet","index":5,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Data Item:N","LOOKUP_REF","ESRFiguresWhitePreviousYear:N","VerifiedFiguresWhitePreviousYear:N","ESRFiguresBMEPreviousYear:N","VerifiedFiguresBMEPreviousYear:N","ESRFiguresUnknownPreviousYear:N","VerifiedFiguresUnknownPreviousYear:N","ESRFiguresWhiteCurrentYear:N","VerifiedFiguresWhiteCurrentYear:N","ESRFiguresBMECurrentYear:N","VerifiedFiguresBMECurrentYear:N","ESRFiguresUnknownCurrentYear:N","VerifiedFiguresUnknownCurrentYear:N","WrcComments"]
[1,"Ind1_NC_Under Band 1",{"$f":"IF('Data for submission '!F17=\"\",0,'Data for submission '!F17)","v":6},{"$f":"IF('Data for submission '!G17=\"\",0,'Data for submission '!G17)","v":6},{"$f":"IF('Data for submission '!H17=\"\",0,'Data for submission '!H17)","v":32},{"$f":"IF('Data for submission '!I17=\"\",0,'Data for submission '!I17)","v":31},{"$f":"IF('Data for submission '!J17=\"\",0,'Data for submission '!J17)","v":0},{"$f":"IF('Data for submission '!K17=\"\",0,'Data for submission '!K17)","v":0},{"$f":"IF('Data for submission '!L17=\"\",0,'Data for submission '!L17)","v":7},{"$f":"IF('Data for submission '!M17=\"\",0,'Data for submission '!M17)","v":7},{"$f":"IF('Data for submission '!N17=\"\",0,'Data for submission '!N17)","v":31},{"$f":"IF('Data for submission '!O17=\"\",0,'Data for submission '!O17)","v":31},{"$f":"IF('Data for submission '!P17=\"\",0,'Data for submission '!P17)","v":1},{"$f":"IF('Data for submission '!Q17=\"\",0,'Data for submission '!Q17)","v":1},{"$f":"IF(ISBLANK('Data for submission '!R17),\"\",'Data for submission '!R17)","v":""}]
[2,"Ind1_NC_Band 1",{"$f":"IF('Data for submission '!F18=\"\",0,'Data for submission '!F18)","v":0},{"$f":"IF('Data for submission '!G18=\"\",0,'Data for submission '!G18)","v":0},{"$f":"IF('Data for submission '!H18=\"\",0,'Data for submission '!H18)","v":0},{"$f":"IF('Data for submission '!I18=\"\",0,'Data for submission '!I18)","v":0},{"$f":"IF('Data for submission '!J18=\"\",0,'Data for submission '!J18)","v":0},{"$f":"IF('Data for submission '!K18=\"\",0,'Data for submission '!K18)","v":0},{"$f":"IF('Data for submission '!L18=\"\",0,'Data for submission '!L18)","v":0},{"$f":"IF('Data for submission '!M18=\"\",0,'Data for submission '!M18)","v":0},{"$f":"IF('Data for submission '!N18=\"\",0,'Data for submission '!N18)","v":0},{"$f":"IF('Data for submission '!O18=\"\",0,'Data for submission '!O18)","v":0},{"$f":"IF('Data for submission '!P18=\"\",0,'Data for submission '!P18)","v":0},{"$f":"IF('Data for submission '!Q18=\"\",0,'Data for submission '!Q18)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R18),\"\",'Data for submission '!R18)","v":""}]
[3,"Ind1_NC_Band 2",{"$f":"IF('Data for submission '!F19=\"\",0,'Data for submission '!F19)","v":2},{"$f":"IF('Data for submission '!G19=\"\",0,'Data for submission '!G19)","v":2},{"$f":"IF('Data for submission '!H19=\"\",0,'Data for submission '!H19)","v":5},{"$f":"IF('Data for submission '!I19=\"\",0,'Data for submission '!I19)","v":5},{"$f":"IF('Data for submission '!J19=\"\",0,'Data for submission '!J19)","v":0},{"$f":"IF('Data for submission '!K19=\"\",0,'Data for submission '!K19)","v":0},{"$f":"IF('Data for submission '!L19=\"\",0,'Data for submission '!L19)","v":29},{"$f":"IF('Data for submission '!M19=\"\",0,'Data for submission '!M19)","v":29},{"$f":"IF('Data for submission '!N19=\"\",0,'Data for submission '!N19)","v":5},{"$f":"IF('Data for submission '!O19=\"\",0,'Data for submission '!O19)","v":5},{"$f":"IF('Data for submission '!P19=\"\",0,'Data for submission '!P19)","v":0},{"$f":"IF('Data for submission '!Q19=\"\",0,'Data for submission '!Q19)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R19),\"\",'Data for submission '!R19)","v":""}]
[4,"Ind1_NC_Band 3",{"$f":"IF('Data for submission '!F20=\"\",0,'Data for submission '!F20)","v":65},{"$f":"IF('Data for submission '!G20=\"\",0,'Data for submission '!G20)","v":64},{"$f":"IF('Data for submission '!H20=\"\",0,'Data for submission '!H20)","v":98},{"$f":"IF('Data for submission '!I20=\"\",0,'Data for submission '!I20)","v":98},{"$f":"IF('Data for submission '!J20=\"\",0,'Data for submission '!J20)","v":2},{"$f":"IF('Data for submission '!K20=\"\",0,'Data for submission '!K20)","v":2},{"$f":"IF('Data for submission '!L20=\"\",0,'Data for submission '!L20)","v":94},{"$f":"IF('Data for submission '!M20=\"\",0,'Data for submission '!M20)","v":94},{"$f":"IF('Data for submission '!N20=\"\",0,'Data for submission '!N20)","v":116},{"$f":"IF('Data for submission '!O20=\"\",0,'Data for submission '!O20)","v":116},{"$f":"IF('Data for submission '!P20=\"\",0,'Data for submission '!P20)","v":4},{"$f":"IF('Data for submission '!Q20=\"\",0,'Data for submission '!Q20)","v":4},{"$f":"IF(ISBLANK('Data for submission '!R20),\"\",'Data for submission '!R20)","v":""}]
[5,"Ind1_NC_Band 4",{"$f":"IF('Data for submission '!F21=\"\",0,'Data for submission '!F21)","v":134},{"$f":"IF('Data for submission '!G21=\"\",0,'Data for submission '!G21)","v":134},{"$f":"IF('Data for submission '!H21=\"\",0,'Data for submission '!H21)","v":196},{"$f":"IF('Data for submission '!I21=\"\",0,'Data for submission '!I21)","v":194},{"$f":"IF('Data for submission '!J21=\"\",0,'Data for submission '!J21)","v":12},{"$f":"IF('Data for submission '!K21=\"\",0,'Data for submission '!K21)","v":12},{"$f":"IF('Data for submission '!L21=\"\",0,'Data for submission '!L21)","v":137},{"$f":"IF('Data for submission '!M21=\"\",0,'Data for submission '!M21)","v":137},{"$f":"IF('Data for submission '!N21=\"\",0,'Data for submission '!N21)","v":187},{"$f":"IF('Data for submission '!O21=\"\",0,'Data for submission '!O21)","v":187},{"$f":"IF('Data for submission '!P21=\"\",0,'Data for submission '!P21)","v":16},{"$f":"IF('Data for submission '!Q21=\"\",0,'Data for submission '!Q21)","v":16},{"$f":"IF(ISBLANK('Data for submission '!R21),\"\",'Data for submission '!R21)","v":""}]
[6,"Ind1_NC_Band 5",{"$f":"IF('Data for submission '!F22=\"\",0,'Data for submission '!F22)","v":81},{"$f":"IF('Data for submission '!G22=\"\",0,'Data for submission '!G22)","v":81},{"$f":"IF('Data for submission '!H22=\"\",0,'Data for submission '!H22)","v":91},{"$f":"IF('Data for submission '!I22=\"\",0,'Data for submission '!I22)","v":90},{"$f":"IF('Data for submission '!J22=\"\",0,'Data for submission '!J22)","v":5},{"$f":"IF('Data for submission '!K22=\"\",0,'Data for submission '!K22)","v":5},{"$f":"IF('Data for submission '!L22=\"\",0,'Data for submission '!L22)","v":91},{"$f":"IF('Data for submission '!M22=\"\",0,'Data for submission '!M22)","v":91},{"$f":"IF('Data for submission '!N22=\"\",0,'Data for submission '!N22)","v":110},{"$f":"IF('Data for submission '!O22=\"\",0,'Data for submission '!O22)","v":110},{"$f":"IF('Data for submission '!P22=\"\",0,'Data for submission '!P22)","v":8},{"$f":"IF('Data for submission '!Q22=\"\",0,'Data for submission '!Q22)","v":8},{"$f":"IF(ISBLANK('Data for submission '!R22),\"\",'Data for submission '!R22)","v":""}]
[7,"Ind1_NC_Band 6",{"$f":"IF('Data for submission '!F23=\"\",0,'Data for submission '!F23)","v":58},{"$f":"IF('Data for submission '!G23=\"\",0,'Data for submission '!G23)","v":57},{"$f":"IF('Data for submission '!H23=\"\",0,'Data for submission '!H23)","v":64},{"$f":"IF('Data for submission '!I23=\"\",0,'Data for submission '!I23)","v":64},{"$f":"IF('Data for submission '!J23=\"\",0,'Data for submission '!J23)","v":3},{"$f":"IF('Data for submission '!K23=\"\",0,'Data for submission '!K23)","v":3},{"$f":"IF('Data for submission '!L23=\"\",0,'Data for submission '!L23)","v":69},{"$f":"IF('Data for submission '!M23=\"\",0,'Data for submission '!M23)","v":69},{"$f":"IF('Data for submission '!N23=\"\",0,'Data for submission '!N23)","v":65},{"$f":"IF('Data for submission '!O23=\"\",0,'Data for submission '!O23)","v":65},{"$f":"IF('Data for submission '!P23=\"\",0,'Data for submission '!P23)","v":7},{"$f":"IF('Data for submission '!Q23=\"\",0,'Data for submission '!Q23)","v":7},{"$f":"IF(ISBLANK('Data for submission '!R23),\"\",'Data for submission '!R23)","v":""}]
[8,"Ind1_NC_Band 7",{"$f":"IF('Data for submission '!F24=\"\",0,'Data for submission '!F24)","v":48},{"$f":"IF('Data for submission '!G24=\"\",0,'Data for submission '!G24)","v":49},{"$f":"IF('Data for submission '!H24=\"\",0,'Data for submission '!H24)","v":31},{"$f":"IF('Data for submission '!I24=\"\",0,'Data for submission '!I24)","v":30},{"$f":"IF('Data for submission '!J24=\"\",0,'Data for submission '!J24)","v":0},{"$f":"IF('Data for submission '!K24=\"\",0,'Data for submission '!K24)","v":0},{"$f":"IF('Data for submission '!L24=\"\",0,'Data for submission '!L24)","v":47},{"$f":"IF('Data for submission '!M24=\"\",0,'Data for submission '!M24)","v":47},{"$f":"IF('Data for submission '!N24=\"\",0,'Data for submission '!N24)","v":30},{"$f":"IF('Data for submission '!O24=\"\",0,'Data for submission '!O24)","v":30},{"$f":"IF('Data for submission '!P24=\"\",0,'Data for submission '!P24)","v":3},{"$f":"IF('Data for submission '!Q24=\"\",0,'Data for submission '!Q24)","v":3},{"$f":"IF(ISBLANK('Data for submission '!R24),\"\",'Data for submission '!R24)","v":""}]
[9,"Ind1_NC_Band 8A",{"$f":"IF('Data for submission '!F25=\"\",0,'Data for submission '!F25)","v":53},{"$f":"IF('Data for submission '!G25=\"\",0,'Data for submission '!G25)","v":51},{"$f":"IF('Data for submission '!H25=\"\",0,'Data for submission '!H25)","v":28},{"$f":"IF('Data for submission '!I25=\"\",0,'Data for submission '!I25)","v":29},{"$f":"IF('Data for submission '!J25=\"\",0,'Data for submission '!J25)","v":1},{"$f":"IF('Data for submission '!K25=\"\",0,'Data for submission '!K25)","v":1},{"$f":"IF('Data for submission '!L25=\"\",0,'Data for submission '!L25)","v":51},{"$f":"IF('Data for submission '!M25=\"\",0,'Data for submission '!M25)","v":51},{"$f":"IF('Data for submission '!N25=\"\",0,'Data for submission '!N25)","v":40},{"$f":"IF('Data for submission '!O25=\"\",0,'Data for submission '!O25)","v":40},{"$f":"IF('Data for submission '!P25=\"\",0,'Data for submission '!P25)","v":4},{"$f":"IF('Data for submission '!Q25=\"\",0,'Data for submission '!Q25)","v":4},{"$f":"IF(ISBLANK('Data for submission '!R25),\"\",'Data for submission '!R25)","v":""}]
[10,"Ind1_NC_Band 8B",{"$f":"IF('Data for submission '!F26=\"\",0,'Data for submission '!F26)","v":31},{"$f":"IF('Data for submission '!G26=\"\",0,'Data for submission '!G26)","v":31},{"$f":"IF('Data for submission '!H26=\"\",0,'Data for submission '!H26)","v":5},{"$f":"IF('Data for submission '!I26=\"\",0,'Data for submission '!I26)","v":5},{"$f":"IF('Data for submission '!J26=\"\",0,'Data for submission '!J26)","v":0},{"$f":"IF('Data for submission '!K26=\"\",0,'Data for submission '!K26)","v":0},{"$f":"IF('Data for submission '!L26=\"\",0,'Data for submission '!L26)","v":23},{"$f":"IF('Data for submission '!M26=\"\",0,'Data for submission '!M26)","v":23},{"$f":"IF('Data for submission '!N26=\"\",0,'Data for submission '!N26)","v":8},{"$f":"IF('Data for submission '!O26=\"\",0,'Data for submission '!O26)","v":8},{"$f":"IF('Data for submission '!P26=\"\",0,'Data for submission '!P26)","v":0},{"$f":"IF('Data for submission '!Q26=\"\",0,'Data for submission '!Q26)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R26),\"\",'Data for submission '!R26)","v":""}]
[11,"Ind1_NC_Band 8C",{"$f":"IF('Data for submission '!F27=\"\",0,'Data for submission '!F27)","v":19},{"$f":"IF('Data for submission '!G27=\"\",0,'Data for submission '!G27)","v":19},{"$f":"IF('Data for submission '!H27=\"\",0,'Data for submission '!H27)","v":6},{"$f":"IF('Data for submission '!I27=\"\",0,'Data for submission '!I27)","v":6},{"$f":"IF('Data for submission '!J27=\"\",0,'Data for submission '!J27)","v":0},{"$f":"IF('Data for submission '!K27=\"\",0,'Data for submission '!K27)","v":0},{"$f":"IF('Data for submission '!L27=\"\",0,'Data for submission '!L27)","v":23},{"$f":"IF('Data for submission '!M27=\"\",0,'Data for submission '!M27)","v":23},{"$f":"IF('Data for submission '!N27=\"\",0,'Data for submission '!N27)","v":6},{"$f":"IF('Data for submission '!O27=\"\",0,'Data for submission '!O27)","v":6},{"$f":"IF('Data for submission '!P27=\"\",0,'Data for submission '!P27)","v":0},{"$f":"IF('Data for submission '!Q27=\"\",0,'Data for submission '!Q27)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R27),\"\",'Data for submission '!R27)","v":""}]
[12,"Ind1_NC_Band 8D",{"$f":"IF('Data for submission '!F28=\"\",0,'Data for submission '!F28)","v":15},{"$f":"IF('Data for submission '!G28=\"\",0,'Data for submission '!G28)","v":16},{"$f":"IF('Data for submission '!H28=\"\",0,'Data for submission '!H28)","v":0},{"$f":"IF('Data for submission '!I28=\"\",0,'Data for submission '!I28)","v":0},{"$f":"IF('Data for submission '!J28=\"\",0,'Data for submission '!J28)","v":0},{"$f":"IF('Data for submission '!K28=\"\",0,'Data for submission '!K28)","v":0},{"$f":"IF('Data for submission '!L28=\"\",0,'Data for submission '!L28)","v":22},{"$f":"IF('Data for submission '!M28=\"\",0,'Data for submission '!M28)","v":22},{"$f":"IF('Data for submission '!N28=\"\",0,'Data for submission '!N28)","v":2},{"$f":"IF('Data for submission '!O28=\"\",0,'Data for submission '!O28)","v":2},{"$f":"IF('Data for submission '!P28=\"\",0,'Data for submission '!P28)","v":0},{"$f":"IF('Data for submission '!Q28=\"\",0,'Data for submission '!Q28)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R28),\"\",'Data for submission '!R28)","v":""}]
[13,"Ind1_NC_Band 9",{"$f":"IF('Data for submission '!F29=\"\",0,'Data for submission '!F29)","v":4},{"$f":"IF('Data for submission '!G29=\"\",0,'Data for submission '!G29)","v":6},{"$f":"IF('Data for submission '!H29=\"\",0,'Data for submission '!H29)","v":0},{"$f":"IF('Data for submission '!I29=\"\",0,'Data for submission '!I29)","v":2},{"$f":"IF('Data for submission '!J29=\"\",0,'Data for submission '!J29)","v":0},{"$f":"IF('Data for submission '!K29=\"\",0,'Data for submission '!K29)","v":0},{"$f":"IF('Data for submission '!L29=\"\",0,'Data for submission '!L29)","v":7},{"$f":"IF('Data for submission '!M29=\"\",0,'Data for submission '!M29)","v":7},{"$f":"IF('Data for submission '!N29=\"\",0,'Data for submission '!N29)","v":2},{"$f":"IF('Data for submission '!O29=\"\",0,'Data for submission '!O29)","v":2},{"$f":"IF('Data for submission '!P29=\"\",0,'Data for submission '!P29)","v":0},{"$f":"IF('Data for submission '!Q29=\"\",0,'Data for submission '!Q29)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R29),\"\",'Data for submission '!R29)","v":""}]
[14,"Ind1_NC_VSM",{"$f":"IF('Data for submission '!F30=\"\",0,'Data for submission '!F30)","v":7},{"$f":"IF('Data for submission '!G30=\"\",0,'Data for submission '!G30)","v":5},{"$f":"IF('Data for submission '!H30=\"\",0,'Data for submission '!H30)","v":5},{"$f":"IF('Data for submission '!I30=\"\",0,'Data for submission '!I30)","v":4},{"$f":"IF('Data for submission '!J30=\"\",0,'Data for submission '!J30)","v":0},{"$f":"IF('Data for submission '!K30=\"\",0,'Data for submission '!K30)","v":0},{"$f":"IF('Data for submission '!L30=\"\",0,'Data for submission '!L30)","v":3},{"$f":"IF('Data for submission '!M30=\"\",0,'Data for submission '!M30)","v":3},{"$f":"IF('Data for submission '!N30=\"\",0,'Data for submission '!N30)","v":4},{"$f":"IF('Data for submission '!O30=\"\",0,'Data for submission '!O30)","v":4},{"$f":"IF('Data for submission '!P30=\"\",0,'Data for submission '!P30)","v":0},{"$f":"IF('Data for submission '!Q30=\"\",0,'Data for submission '!Q30)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R30),\"\",'Data for submission '!R30)","v":""}]
[15,"Ind1_Clin_NMUnder Band 1",{"$f":"IF('Data for submission '!F33=\"\",0,'Data for submission '!F33)","v":5},{"$f":"IF('Data for submission '!G33=\"\",0,'Data for submission '!G33)","v":4},{"$f":"IF('Data for submission '!H33=\"\",0,'Data for submission '!H33)","v":12},{"$f":"IF('Data for submission '!I33=\"\",0,'Data for submission '!I33)","v":12},{"$f":"IF('Data for submission '!J33=\"\",0,'Data for submission '!J33)","v":0},{"$f":"IF('Data for submission '!K33=\"\",0,'Data for submission '!K33)","v":1},{"$f":"IF('Data for submission '!L33=\"\",0,'Data for submission '!L33)","v":7},{"$f":"IF('Data for submission '!M33=\"\",0,'Data for submission '!M33)","v":7},{"$f":"IF('Data for submission '!N33=\"\",0,'Data for submission '!N33)","v":8},{"$f":"IF('Data for submission '!O33=\"\",0,'Data for submission '!O33)","v":8},{"$f":"IF('Data for submission '!P33=\"\",0,'Data for submission '!P33)","v":0},{"$f":"IF('Data for submission '!Q33=\"\",0,'Data for submission '!Q33)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R33),\"\",'Data for submission '!R33)","v":""}]
[16,"Ind1_Clin_NMBand 1",{"$f":"IF('Data for submission '!F34=\"\",0,'Data for submission '!F34)","v":0},{"$f":"IF('Data for submission '!G34=\"\",0,'Data for submission '!G34)","v":0},{"$f":"IF('Data for submission '!H34=\"\",0,'Data for submission '!H34)","v":0},{"$f":"IF('Data for submission '!I34=\"\",0,'Data for submission '!I34)","v":0},{"$f":"IF('Data for submission '!J34=\"\",0,'Data for submission '!J34)","v":0},{"$f":"IF('Data for submission '!K34=\"\",0,'Data for submission '!K34)","v":0},{"$f":"IF('Data for submission '!L34=\"\",0,'Data for submission '!L34)","v":0},{"$f":"IF('Data for submission '!M34=\"\",0,'Data for submission '!M34)","v":0},{"$f":"IF('Data for submission '!N34=\"\",0,'Data for submission '!N34)","v":0},{"$f":"IF('Data for submission '!O34=\"\",0,'Data for submission '!O34)","v":0},{"$f":"IF('Data for submission '!P34=\"\",0,'Data for submission '!P34)","v":0},{"$f":"IF('Data for submission '!Q34=\"\",0,'Data for submission '!Q34)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R34),\"\",'Data for submission '!R34)","v":""}]
[17,"Ind1_Clin_NMBand 2",{"$f":"IF('Data for submission '!F35=\"\",0,'Data for submission '!F35)","v":0},{"$f":"IF('Data for submission '!G35=\"\",0,'Data for submission '!G35)","v":0},{"$f":"IF('Data for submission '!H35=\"\",0,'Data for submission '!H35)","v":5},{"$f":"IF('Data for submission '!I35=\"\",0,'Data for submission '!I35)","v":3},{"$f":"IF('Data for submission '!J35=\"\",0,'Data for submission '!J35)","v":0},{"$f":"IF('Data for submission '!K35=\"\",0,'Data for submission '!K35)","v":0},{"$f":"IF('Data for submission '!L35=\"\",0,'Data for submission '!L35)","v":18},{"$f":"IF('Data for submission '!M35=\"\",0,'Data for submission '!M35)","v":18},{"$f":"IF('Data for submission '!N35=\"\",0,'Data for submission '!N35)","v":1},{"$f":"IF('Data for submission '!O35=\"\",0,'Data for submission '!O35)","v":1},{"$f":"IF('Data for submission '!P35=\"\",0,'Data for submission '!P35)","v":0},{"$f":"IF('Data for submission '!Q35=\"\",0,'Data for submission '!Q35)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R35),\"\",'Data for submission '!R35)","v":""}]
[18,"Ind1_Clin_NMBand 3",{"$f":"IF('Data for submission '!F36=\"\",0,'Data for submission '!F36)","v":207},{"$f":"IF('Data for submission '!G36=\"\",0,'Data for submission '!G36)","v":191},{"$f":"IF('Data for submission '!H36=\"\",0,'Data for submission '!H36)","v":489},{"$f":"IF('Data for submission '!I36=\"\",0,'Data for submission '!I36)","v":469},{"$f":"IF('Data for submission '!J36=\"\",0,'Data for submission '!J36)","v":13},{"$f":"IF('Data for submission '!K36=\"\",0,'Data for submission '!K36)","v":13},{"$f":"IF('Data for submission '!L36=\"\",0,'Data for submission '!L36)","v":211},{"$f":"IF('Data for submission '!M36=\"\",0,'Data for submission '!M36)","v":211},{"$f":"IF('Data for submission '!N36=\"\",0,'Data for submission '!N36)","v":462},{"$f":"IF('Data for submission '!O36=\"\",0,'Data for submission '!O36)","v":462},{"$f":"IF('Data for submission '!P36=\"\",0,'Data for submission '!P36)","v":32},{"$f":"IF('Data for submission '!Q36=\"\",0,'Data for submission '!Q36)","v":32},{"$f":"IF(ISBLANK('Data for submission '!R36),\"\",'Data for submission '!R36)","v":""}]
[19,"Ind1_Clin_NMBand 4",{"$f":"IF('Data for submission '!F37=\"\",0,'Data for submission '!F37)","v":129},{"$f":"IF('Data for submission '!G37=\"\",0,'Data for submission '!G37)","v":130},{"$f":"IF('Data for submission '!H37=\"\",0,'Data for submission '!H37)","v":155},{"$f":"IF('Data for submission '!I37=\"\",0,'Data for submission '!I37)","v":156},{"$f":"IF('Data for submission '!J37=\"\",0,'Data for submission '!J37)","v":2},{"$f":"IF('Data for submission '!K37=\"\",0,'Data for submission '!K37)","v":2},{"$f":"IF('Data for submission '!L37=\"\",0,'Data for submission '!L37)","v":164},{"$f":"IF('Data for submission '!M37=\"\",0,'Data for submission '!M37)","v":164},{"$f":"IF('Data for submission '!N37=\"\",0,'Data for submission '!N37)","v":204},{"$f":"IF('Data for submission '!O37=\"\",0,'Data for submission '!O37)","v":204},{"$f":"IF('Data for submission '!P37=\"\",0,'Data for submission '!P37)","v":13},{"$f":"IF('Data for submission '!Q37=\"\",0,'Data for submission '!Q37)","v":13},{"$f":"IF(ISBLANK('Data for submission '!R37),\"\",'Data for submission '!R37)","v":""}]
[20,"Ind1_Clin_NMBand 5",{"$f":"IF('Data for submission '!F38=\"\",0,'Data for submission '!F38)","v":200},{"$f":"IF('Data for submission '!G38=\"\",0,'Data for submission '!G38)","v":197},{"$f":"IF('Data for submission '!H38=\"\",0,'Data for submission '!H38)","v":392},{"$f":"IF('Data for submission '!I38=\"\",0,'Data for submission '!I38)","v":393},{"$f":"IF('Data for submission '!J38=\"\",0,'Data for submission '!J38)","v":14},{"$f":"IF('Data for submission '!K38=\"\",0,'Data for submission '!K38)","v":14},{"$f":"IF('Data for submission '!L38=\"\",0,'Data for submission '!L38)","v":277},{"$f":"IF('Data for submission '!M38=\"\",0,'Data for submission '!M38)","v":277},{"$f":"IF('Data for submission '!N38=\"\",0,'Data for submission '!N38)","v":393},{"$f":"IF('Data for submission '!O38=\"\",0,'Data for submission '!O38)","v":393},{"$f":"IF('Data for submission '!P38=\"\",0,'Data for submission '!P38)","v":12},{"$f":"IF('Data for submission '!Q38=\"\",0,'Data for submission '!Q38)","v":12},{"$f":"IF(ISBLANK('Data for submission '!R38),\"\",'Data for submission '!R38)","v":""}]
[21,"Ind1_Clin_NMBand 6",{"$f":"IF('Data for submission '!F39=\"\",0,'Data for submission '!F39)","v":345},{"$f":"IF('Data for submission '!G39=\"\",0,'Data for submission '!G39)","v":343},{"$f":"IF('Data for submission '!H39=\"\",0,'Data for submission '!H39)","v":472},{"$f":"IF('Data for submission '!I39=\"\",0,'Data for submission '!I39)","v":472},{"$f":"IF('Data for submission '!J39=\"\",0,'Data for submission '!J39)","v":8},{"$f":"IF('Data for submission '!K39=\"\",0,'Data for submission '!K39)","v":8},{"$f":"IF('Data for submission '!L39=\"\",0,'Data for submission '!L39)","v":408},{"$f":"IF('Data for submission '!M39=\"\",0,'Data for submission '!M39)","v":408},{"$f":"IF('Data for submission '!N39=\"\",0,'Data for submission '!N39)","v":510},{"$f":"IF('Data for submission '!O39=\"\",0,'Data for submission '!O39)","v":510},{"$f":"IF('Data for submission '!P39=\"\",0,'Data for submission '!P39)","v":22},{"$f":"IF('Data for submission '!Q39=\"\",0,'Data for submission '!Q39)","v":22},{"$f":"IF(ISBLANK('Data for submission '!R39),\"\",'Data for submission '!R39)","v":""}]
[22,"Ind1_Clin_NMBand 7",{"$f":"IF('Data for submission '!F40=\"\",0,'Data for submission '!F40)","v":388},{"$f":"IF('Data for submission '!G40=\"\",0,'Data for submission '!G40)","v":384},{"$f":"IF('Data for submission '!H40=\"\",0,'Data for submission '!H40)","v":253},{"$f":"IF('Data for submission '!I40=\"\",0,'Data for submission '!I40)","v":254},{"$f":"IF('Data for submission '!J40=\"\",0,'Data for submission '!J40)","v":10},{"$f":"IF('Data for submission '!K40=\"\",0,'Data for submission '!K40)","v":10},{"$f":"IF('Data for submission '!L40=\"\",0,'Data for submission '!L40)","v":487},{"$f":"IF('Data for submission '!M40=\"\",0,'Data for submission '!M40)","v":487},{"$f":"IF('Data for submission '!N40=\"\",0,'Data for submission '!N40)","v":287},{"$f":"IF('Data for submission '!O40=\"\",0,'Data for submission '!O40)","v":287},{"$f":"IF('Data for submission '!P40=\"\",0,'Data for submission '!P40)","v":23},{"$f":"IF('Data for submission '!Q40=\"\",0,'Data for submission '!Q40)","v":23},{"$f":"IF(ISBLANK('Data for submission '!R40),\"\",'Data for submission '!R40)","v":""}]
[23,"Ind1_Clin_NMBand 8A",{"$f":"IF('Data for submission '!F41=\"\",0,'Data for submission '!F41)","v":225},{"$f":"IF('Data for submission '!G41=\"\",0,'Data for submission '!G41)","v":230},{"$f":"IF('Data for submission '!H41=\"\",0,'Data for submission '!H41)","v":90},{"$f":"IF('Data for submission '!I41=\"\",0,'Data for submission '!I41)","v":91},{"$f":"IF('Data for submission '!J41=\"\",0,'Data for submission '!J41)","v":9},{"$f":"IF('Data for submission '!K41=\"\",0,'Data for submission '!K41)","v":9},{"$f":"IF('Data for submission '!L41=\"\",0,'Data for submission '!L41)","v":232},{"$f":"IF('Data for submission '!M41=\"\",0,'Data for submission '!M41)","v":232},{"$f":"IF('Data for submission '!N41=\"\",0,'Data for submission '!N41)","v":95},{"$f":"IF('Data for submission '!O41=\"\",0,'Data for submission '!O41)","v":95},{"$f":"IF('Data for submission '!P41=\"\",0,'Data for submission '!P41)","v":13},{"$f":"IF('Data for submission '!Q41=\"\",0,'Data for submission '!Q41)","v":13},{"$f":"IF(ISBLANK('Data for submission '!R41),\"\",'Data for submission '!R41)","v":""}]
[24,"Ind1_Clin_NMBand 8B",{"$f":"IF('Data for submission '!F42=\"\",0,'Data for submission '!F42)","v":67},{"$f":"IF('Data for submission '!G42=\"\",0,'Data for submission '!G42)","v":67},{"$f":"IF('Data for submission '!H42=\"\",0,'Data for submission '!H42)","v":17},{"$f":"IF('Data for submission '!I42=\"\",0,'Data for submission '!I42)","v":17},{"$f":"IF('Data for submission '!J42=\"\",0,'Data for submission '!J42)","v":1},{"$f":"IF('Data for submission '!K42=\"\",0,'Data for submission '!K42)","v":1},{"$f":"IF('Data for submission '!L42=\"\",0,'Data for submission '!L42)","v":85},{"$f":"IF('Data for submission '!M42=\"\",0,'Data for submission '!M42)","v":85},{"$f":"IF('Data for submission '!N42=\"\",0,'Data for submission '!N42)","v":26},{"$f":"IF('Data for submission '!O42=\"\",0,'Data for submission '!O42)","v":26},{"$f":"IF('Data for submission '!P42=\"\",0,'Data for submission '!P42)","v":4},{"$f":"IF('Data for submission '!Q42=\"\",0,'Data for submission '!Q42)","v":4},{"$f":"IF(ISBLANK('Data for submission '!R42),\"\",'Data for submission '!R42)","v":""}]
[25,"Ind1_Clin_NMBand 8C",{"$f":"IF('Data for submission '!F43=\"\",0,'Data for submission '!F43)","v":35},{"$f":"IF('Data for submission '!G43=\"\",0,'Data for submission '!G43)","v":35},{"$f":"IF('Data for submission '!H43=\"\",0,'Data for submission '!H43)","v":10},{"$f":"IF('Data for submission '!I43=\"\",0,'Data for submission '!I43)","v":9},{"$f":"IF('Data for submission '!J43=\"\",0,'Data for submission '!J43)","v":0},{"$f":"IF('Data for submission '!K43=\"\",0,'Data for submission '!K43)","v":0},{"$f":"IF('Data for submission '!L43=\"\",0,'Data for submission '!L43)","v":41},{"$f":"IF('Data for submission '!M43=\"\",0,'Data for submission '!M43)","v":41},{"$f":"IF('Data for submission '!N43=\"\",0,'Data for submission '!N43)","v":10},{"$f":"IF('Data for submission '!O43=\"\",0,'Data for submission '!O43)","v":10},{"$f":"IF('Data for submission '!P43=\"\",0,'Data for submission '!P43)","v":0},{"$f":"IF('Data for submission '!Q43=\"\",0,'Data for submission '!Q43)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R43),\"\",'Data for submission '!R43)","v":""}]
[26,"Ind1_Clin_NMBand 8D",{"$f":"IF('Data for submission '!F44=\"\",0,'Data for submission '!F44)","v":9},{"$f":"IF('Data for submission '!G44=\"\",0,'Data for submission '!G44)","v":9},{"$f":"IF('Data for submission '!H44=\"\",0,'Data for submission '!H44)","v":2},{"$f":"IF('Data for submission '!I44=\"\",0,'Data for submission '!I44)","v":2},{"$f":"IF('Data for submission '!J44=\"\",0,'Data for submission '!J44)","v":1},{"$f":"IF('Data for submission '!K44=\"\",0,'Data for submission '!K44)","v":1},{"$f":"IF('Data for submission '!L44=\"\",0,'Data for submission '!L44)","v":10},{"$f":"IF('Data for submission '!M44=\"\",0,'Data for submission '!M44)","v":10},{"$f":"IF('Data for submission '!N44=\"\",0,'Data for submission '!N44)","v":1},{"$f":"IF('Data for submission '!O44=\"\",0,'Data for submission '!O44)","v":1},{"$f":"IF('Data for submission '!P44=\"\",0,'Data for submission '!P44)","v":2},{"$f":"IF('Data for submission '!Q44=\"\",0,'Data for submission '!Q44)","v":2},{"$f":"IF(ISBLANK('Data for submission '!R44),\"\",'Data for submission '!R44)","v":""}]
[27,"Ind1_Clin_NMBand 9",{"$f":"IF('Data for submission '!F45=\"\",0,'Data for submission '!F45)","v":2},{"$f":"IF('Data for submission '!G45=\"\",0,'Data for submission '!G45)","v":4},{"$f":"IF('Data for submission '!H45=\"\",0,'Data for submission '!H45)","v":1},{"$f":"IF('Data for submission '!I45=\"\",0,'Data for submission '!I45)","v":1},{"$f":"IF('Data for submission '!J45=\"\",0,'Data for submission '!J45)","v":0},{"$f":"IF('Data for submission '!K45=\"\",0,'Data for submission '!K45)","v":0},{"$f":"IF('Data for submission '!L45=\"\",0,'Data for submission '!L45)","v":3},{"$f":"IF('Data for submission '!M45=\"\",0,'Data for submission '!M45)","v":3},{"$f":"IF('Data for submission '!N45=\"\",0,'Data for submission '!N45)","v":1},{"$f":"IF('Data for submission '!O45=\"\",0,'Data for submission '!O45)","v":1},{"$f":"IF('Data for submission '!P45=\"\",0,'Data for submission '!P45)","v":0},{"$f":"IF('Data for submission '!Q45=\"\",0,'Data for submission '!Q45)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R45),\"\",'Data for submission '!R45)","v":""}]
[28,"Ind1_Clin_NMVSM",{"$f":"IF('Data for submission '!F46=\"\",0,'Data for submission '!F46)","v":5},{"$f":"IF('Data for submission '!G46=\"\",0,'Data for submission '!G46)","v":0},{"$f":"IF('Data for submission '!H46=\"\",0,'Data for submission '!H46)","v":0},{"$f":"IF('Data for submission '!I46=\"\",0,'Data for submission '!I46)","v":0},{"$f":"IF('Data for submission '!J46=\"\",0,'Data for submission '!J46)","v":0},{"$f":"IF('Data for submission '!K46=\"\",0,'Data for submission '!K46)","v":0},{"$f":"IF('Data for submission '!L46=\"\",0,'Data for submission '!L46)","v":1},{"$f":"IF('Data for submission '!M46=\"\",0,'Data for submission '!M46)","v":1},{"$f":"IF('Data for submission '!N46=\"\",0,'Data for submission '!N46)","v":2},{"$f":"IF('Data for submission '!O46=\"\",0,'Data for submission '!O46)","v":2},{"$f":"IF('Data for submission '!P46=\"\",0,'Data for submission '!P46)","v":0},{"$f":"IF('Data for submission '!Q46=\"\",0,'Data for submission '!Q46)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R46),\"\",'Data for submission '!R46)","v":""}]
[29,"Ind1_Clin_MDConsultants",{"$f":"IF('Data for submission '!F48=\"\",0,'Data for submission '!F48)","v":148},{"$f":"IF('Data for submission '!G48=\"\",0,'Data for submission '!G48)","v":132},{"$f":"IF('Data for submission '!H48=\"\",0,'Data for submission '!H48)","v":92},{"$f":"IF('Data for submission '!I48=\"\",0,'Data for submission '!I48)","v":75},{"$f":"IF('Data for submission '!J48=\"\",0,'Data for submission '!J48)","v":6},{"$f":"IF('Data for submission '!K48=\"\",0,'Data for submission '!K48)","v":3},{"$f":"IF('Data for submission '!L48=\"\",0,'Data for submission '!L48)","v":125},{"$f":"IF('Data for submission '!M48=\"\",0,'Data for submission '!M48)","v":125},{"$f":"IF('Data for submission '!N48=\"\",0,'Data for submission '!N48)","v":71},{"$f":"IF('Data for submission '!O48=\"\",0,'Data for submission '!O48)","v":71},{"$f":"IF('Data for submission '!P48=\"\",0,'Data for submission '!P48)","v":11},{"$f":"IF('Data for submission '!Q48=\"\",0,'Data for submission '!Q48)","v":11},{"$f":"IF(ISBLANK('Data for submission '!R48),\"\",'Data for submission '!R48)","v":""}]
[30,"Ind1_Clin_MD  of which Senior medical manager",{"$f":"IF('Data for submission '!F49=\"\",0,'Data for submission '!F49)","v":0},{"$f":"IF('Data for submission '!G49=\"\",0,'Data for submission '!G49)","v":0},{"$f":"IF('Data for submission '!H49=\"\",0,'Data for submission '!H49)","v":0},{"$f":"IF('Data for submission '!I49=\"\",0,'Data for submission '!I49)","v":0},{"$f":"IF('Data for submission '!J49=\"\",0,'Data for submission '!J49)","v":0},{"$f":"IF('Data for submission '!K49=\"\",0,'Data for submission '!K49)","v":0},{"$f":"IF('Data for submission '!L49=\"\",0,'Data for submission '!L49)","v":0},{"$f":"IF('Data for submission '!M49=\"\",0,'Data for submission '!M49)","v":0},{"$f":"IF('Data for submission '!N49=\"\",0,'Data for submission '!N49)","v":0},{"$f":"IF('Data for submission '!O49=\"\",0,'Data for submission '!O49)","v":0},{"$f":"IF('Data for submission '!P49=\"\",0,'Data for submission '!P49)","v":0},{"$f":"IF('Data for submission '!Q49=\"\",0,'Data for submission '!Q49)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R49),\"\",'Data for submission '!R49)","v":""}]
[31,"Ind1_Clin_MDNon-consultant career grade",{"$f":"IF('Data for submission '!F50=\"\",0,'Data for submission '!F50)","v":19},{"$f":"IF('Data for submission '!G50=\"\",0,'Data for submission '!G50)","v":19},{"$f":"IF('Data for submission '!H50=\"\",0,'Data for submission '!H50)","v":39},{"$f":"IF('Data for submission '!I50=\"\",0,'Data for submission '!I50)","v":38},{"$f":"IF('Data for submission '!J50=\"\",0,'Data for submission '!J50)","v":4},{"$f":"IF('Data for submission '!K50=\"\",0,'Data for submission '!K50)","v":4},{"$f":"IF('Data for submission '!L50=\"\",0,'Data for submission '!L50)","v":24},{"$f":"IF('Data for submission '!M50=\"\",0,'Data for submission '!M50)","v":24},{"$f":"IF('Data for submission '!N50=\"\",0,'Data for submission '!N50)","v":39},{"$f":"IF('Data for submission '!O50=\"\",0,'Data for submission '!O50)","v":39},{"$f":"IF('Data for submission '!P50=\"\",0,'Data for submission '!P50)","v":4},{"$f":"IF('Data for submission '!Q50=\"\",0,'Data for submission '!Q50)","v":4},{"$f":"IF(ISBLANK('Data for submission '!R50),\"\",'Data for submission '!R50)","v":""}]
[32,"Ind1_Clin_MDTrainee grades",{"$f":"IF('Data for submission '!F51=\"\",0,'Data for submission '!F51)","v":10},{"$f":"IF('Data for submission '!G51=\"\",0,'Data for submission '!G51)","v":57},{"$f":"IF('Data for submission '!H51=\"\",0,'Data for submission '!H51)","v":10},{"$f":"IF('Data for submission '!I51=\"\",0,'Data for submission '!I51)","v":56},{"$f":"IF('Data for submission '!J51=\"\",0,'Data for submission '!J51)","v":0},{"$f":"IF('Data for submission '!K51=\"\",0,'Data for submission '!K51)","v":6},{"$f":"IF('Data for submission '!L51=\"\",0,'Data for submission '!L51)","v":49},{"$f":"IF('Data for submission '!M51=\"\",0,'Data for submission '!M51)","v":49},{"$f":"IF('Data for submission '!N51=\"\",0,'Data for submission '!N51)","v":65},{"$f":"IF('Data for submission '!O51=\"\",0,'Data for submission '!O51)","v":65},{"$f":"IF('Data for submission '!P51=\"\",0,'Data for submission '!P51)","v":9},{"$f":"IF('Data for submission '!Q51=\"\",0,'Data for submission '!Q51)","v":9},{"$f":"IF(ISBLANK('Data for submission '!R51),\"\",'Data for submission '!R51)","v":""}]
[33,"Ind1_Clin_MDOther",{"$f":"IF('Data for submission '!F52=\"\",0,'Data for submission '!F52)","v":28},{"$f":"IF('Data for submission '!G52=\"\",0,'Data for submission '!G52)","v":27},{"$f":"IF('Data for submission '!H52=\"\",0,'Data for submission '!H52)","v":28},{"$f":"IF('Data for submission '!I52=\"\",0,'Data for submission '!I52)","v":27},{"$f":"IF('Data for submission '!J52=\"\",0,'Data for submission '!J52)","v":4},{"$f":"IF('Data for submission '!K52=\"\",0,'Data for submission '!K52)","v":0},{"$f":"IF('Data for submission '!L52=\"\",0,'Data for submission '!L52)","v":5},{"$f":"IF('Data for submission '!M52=\"\",0,'Data for submission '!M52)","v":5},{"$f":"IF('Data for submission '!N52=\"\",0,'Data for submission '!N52)","v":3},{"$f":"IF('Data for submission '!O52=\"\",0,'Data for submission '!O52)","v":3},{"$f":"IF('Data for submission '!P52=\"\",0,'Data for submission '!P52)","v":0},{"$f":"IF('Data for submission '!Q52=\"\",0,'Data for submission '!Q52)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R52),\"\",'Data for submission '!R52)","v":""}]
[34,"Ind2_Number of shortlisted applicants:",{"$f":"IF('Data for submission '!F53=\"\",0,'Data for submission '!F53)","v":0},{"$f":"IF('Data for submission '!G53=\"\",0,'Data for submission '!G53)","v":2174},{"$f":"IF('Data for submission '!H53=\"\",0,'Data for submission '!H53)","v":0},{"$f":"IF('Data for submission '!I53=\"\",0,'Data for submission '!I53)","v":3123},{"$f":"IF('Data for submission '!J53=\"\",0,'Data for submission '!J53)","v":0},{"$f":"IF('Data for submission '!K53=\"\",0,'Data for submission '!K53)","v":39},{"$f":"IF('Data for submission '!L53=\"\",0,'Data for submission '!L53)","v":0},{"$f":"IF('Data for submission '!M53=\"\",0,'Data for submission '!M53)","v":1627},{"$f":"IF('Data for submission '!N53=\"\",0,'Data for submission '!N53)","v":0},{"$f":"IF('Data for submission '!O53=\"\",0,'Data for submission '!O53)","v":3737},{"$f":"IF('Data for submission '!P53=\"\",0,'Data for submission '!P53)","v":0},{"$f":"IF('Data for submission '!Q53=\"\",0,'Data for submission '!Q53)","v":199},{"$f":"IF(ISBLANK('Data for submission '!R53),\"\",'Data for submission '!R53)","v":""}]
[35,"Ind2_Number appointed from shortlisting:",{"$f":"IF('Data for submission '!F54=\"\",0,'Data for submission '!F54)","v":0},{"$f":"IF('Data for submission '!G54=\"\",0,'Data for submission '!G54)","v":414},{"$f":"IF('Data for submission '!H54=\"\",0,'Data for submission '!H54)","v":0},{"$f":"IF('Data for submission '!I54=\"\",0,'Data for submission '!I54)","v":455},{"$f":"IF('Data for submission '!J54=\"\",0,'Data for submission '!J54)","v":0},{"$f":"IF('Data for submission '!K54=\"\",0,'Data for submission '!K54)","v":0},{"$f":"IF('Data for submission '!L54=\"\",0,'Data for submission '!L54)","v":0},{"$f":"IF('Data for submission '!M54=\"\",0,'Data for submission '!M54)","v":410},{"$f":"IF('Data for submission '!N54=\"\",0,'Data for submission '!N54)","v":0},{"$f":"IF('Data for submission '!O54=\"\",0,'Data for submission '!O54)","v":674},{"$f":"IF('Data for submission '!P54=\"\",0,'Data for submission '!P54)","v":0},{"$f":"IF('Data for submission '!Q54=\"\",0,'Data for submission '!Q54)","v":37},{"$f":"IF(ISBLANK('Data for submission '!R54),\"\",'Data for submission '!R54)","v":""}]
[36,"Ind2_Relative likelihood of shortlisting/appointed:",{"$f":"IF('Data for submission '!F55=\"\",0,'Data for submission '!F55)","v":0},{"$f":"IF('Data for submission '!G55=\"\",0,'Data for submission '!G55)","v":0.19043238270469182},{"$f":"IF('Data for submission '!H55=\"\",0,'Data for submission '!H55)","v":0},{"$f":"IF('Data for submission '!I55=\"\",0,'Data for submission '!I55)","v":0.1456932436759526},{"$f":"IF('Data for submission '!J55=\"\",0,'Data for submission '!J55)","v":0},{"$f":"IF('Data for submission '!K55=\"\",0,'Data for submission '!K55)","v":0},{"$f":"IF('Data for submission '!L55=\"\",0,'Data for submission '!L55)","v":0},{"$f":"IF('Data for submission '!M55=\"\",0,'Data for submission '!M55)","v":0.25199754148740011},{"$f":"IF('Data for submission '!N55=\"\",0,'Data for submission '!N55)","v":0},{"$f":"IF('Data for submission '!O55=\"\",0,'Data for submission '!O55)","v":0.18035857639818037},{"$f":"IF('Data for submission '!P55=\"\",0,'Data for submission '!P55)","v":0},{"$f":"IF('Data for submission '!Q55=\"\",0,'Data for submission '!Q55)","v":0.18592964824120603},{"$f":"IF(ISBLANK('Data for submission '!R55),\"\",'Data for submission '!R55)","v":""}]
[37,"Ind2_Relative likelihood of White staff being appointed from shortlisting compared to BME staff:",{"$f":"IF('Data for submission '!F56=\"\",0,'Data for submission '!F56)","v":0},{"$f":"IF('Data for submission '!G56=\"\",0,'Data for submission '!G56)","v":1.3070776509598958},{"$f":"IF('Data for submission '!H56=\"\",0,'Data for submission '!H56)","v":0},{"$f":"IF('Data for submission '!I56=\"\",0,'Data for submission '!I56)","v":0},{"$f":"IF('Data for submission '!J56=\"\",0,'Data for submission '!J56)","v":0},{"$f":"IF('Data for submission '!K56=\"\",0,'Data for submission '!K56)","v":0},{"$f":"IF('Data for submission '!L56=\"\",0,'Data for submission '!L56)","v":0},{"$f":"IF('Data for submission '!M56=\"\",0,'Data for submission '!M56)","v":1.3972029859620387},{"$f":"IF('Data for submission '!N56=\"\",0,'Data for submission '!N56)","v":0},{"$f":"IF('Data for submission '!O56=\"\",0,'Data for submission '!O56)","v":0},{"$f":"IF('Data for submission '!P56=\"\",0,'Data for submission '!P56)","v":0},{"$f":"IF('Data for submission '!Q56=\"\",0,'Data for submission '!Q56)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R56),\"\",'Data for submission '!R56)","v":""}]
[38,"Ind3_Number of staff in workforce:",{"$f":"IF('Data for submission '!F57=\"\",0,'Data for submission '!F57)","v":0},{"$f":"IF('Data for submission '!G57=\"\",0,'Data for submission '!G57)","v":2350},{"$f":"IF('Data for submission '!H57=\"\",0,'Data for submission '!H57)","v":0},{"$f":"IF('Data for submission '!I57=\"\",0,'Data for submission '!I57)","v":2633},{"$f":"IF('Data for submission '!J57=\"\",0,'Data for submission '!J57)","v":0},{"$f":"IF('Data for submission '!K57=\"\",0,'Data for submission '!K57)","v":95},{"$f":"IF('Data for submission '!L57=\"\",0,'Data for submission '!L57)","v":0},{"$f":"IF('Data for submission '!M57=\"\",0,'Data for submission '!M57)","v":2750},{"$f":"IF('Data for submission '!N57=\"\",0,'Data for submission '!N57)","v":0},{"$f":"IF('Data for submission '!O57=\"\",0,'Data for submission '!O57)","v":2784},{"$f":"IF('Data for submission '!P57=\"\",0,'Data for submission '!P57)","v":0},{"$f":"IF('Data for submission '!Q57=\"\",0,'Data for submission '!Q57)","v":188},{"$f":"IF(ISBLANK('Data for submission '!R57),\"\",'Data for submission '!R57)","v":""}]
[39,"Ind3_Number of staff entering the formal disciplinary process:",{"$f":"IF('Data for submission '!F58=\"\",0,'Data for submission '!F58)","v":0},{"$f":"IF('Data for submission '!G58=\"\",0,'Data for submission '!G58)","v":18},{"$f":"IF('Data for submission '!H58=\"\",0,'Data for submission '!H58)","v":0},{"$f":"IF('Data for submission '!I58=\"\",0,'Data for submission '!I58)","v":56},{"$f":"IF('Data for submission '!J58=\"\",0,'Data for submission '!J58)","v":0},{"$f":"IF('Data for submission '!K58=\"\",0,'Data for submission '!K58)","v":0},{"$f":"IF('Data for submission '!L58=\"\",0,'Data for submission '!L58)","v":0},{"$f":"IF('Data for submission '!M58=\"\",0,'Data for submission '!M58)","v":15},{"$f":"IF('Data for submission '!N58=\"\",0,'Data for submission '!N58)","v":0},{"$f":"IF('Data for submission '!O58=\"\",0,'Data for submission '!O58)","v":37},{"$f":"IF('Data for submission '!P58=\"\",0,'Data for submission '!P58)","v":0},{"$f":"IF('Data for submission '!Q58=\"\",0,'Data for submission '!Q58)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R58),\"\",'Data for submission '!R58)","v":""}]
[40,"Ind3_Likelihood of staff entering the formal disciplinary process:",{"$f":"IF('Data for submission '!F59=\"\",0,'Data for submission '!F59)","v":0},{"$f":"IF('Data for submission '!G59=\"\",0,'Data for submission '!G59)","v":7.659574468085106E-3},{"$f":"IF('Data for submission '!H59=\"\",0,'Data for submission '!H59)","v":0},{"$f":"IF('Data for submission '!I59=\"\",0,'Data for submission '!I59)","v":2.1268515001898976E-2},{"$f":"IF('Data for submission '!J59=\"\",0,'Data for submission '!J59)","v":0},{"$f":"IF('Data for submission '!K59=\"\",0,'Data for submission '!K59)","v":0},{"$f":"IF('Data for submission '!L59=\"\",0,'Data for submission '!L59)","v":0},{"$f":"IF('Data for submission '!M59=\"\",0,'Data for submission '!M59)","v":5.454545454545455E-3},{"$f":"IF('Data for submission '!N59=\"\",0,'Data for submission '!N59)","v":0},{"$f":"IF('Data for submission '!O59=\"\",0,'Data for submission '!O59)","v":1.3290229885057471E-2},{"$f":"IF('Data for submission '!P59=\"\",0,'Data for submission '!P59)","v":0},{"$f":"IF('Data for submission '!Q59=\"\",0,'Data for submission '!Q59)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R59),\"\",'Data for submission '!R59)","v":""}]
[41,"Ind3_Relative likelihood of BME staff entering the formal disciplinary process compared to White staff:",{"$f":"IF('Data for submission '!F60=\"\",0,'Data for submission '!F60)","v":0},{"$f":"IF('Data for submission '!G60=\"\",0,'Data for submission '!G60)","v":0},{"$f":"IF('Data for submission '!H60=\"\",0,'Data for submission '!H60)","v":0},{"$f":"IF('Data for submission '!I60=\"\",0,'Data for submission '!I60)","v":2.7767227919145885},{"$f":"IF('Data for submission '!J60=\"\",0,'Data for submission '!J60)","v":0},{"$f":"IF('Data for submission '!K60=\"\",0,'Data for submission '!K60)","v":0},{"$f":"IF('Data for submission '!L60=\"\",0,'Data for submission '!L60)","v":0},{"$f":"IF('Data for submission '!M60=\"\",0,'Data for submission '!M60)","v":0},{"$f":"IF('Data for submission '!N60=\"\",0,'Data for submission '!N60)","v":0},{"$f":"IF('Data for submission '!O60=\"\",0,'Data for submission '!O60)","v":2.4365421455938696},{"$f":"IF('Data for submission '!P60=\"\",0,'Data for submission '!P60)","v":0},{"$f":"IF('Data for submission '!Q60=\"\",0,'Data for submission '!Q60)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R60),\"\",'Data for submission '!R60)","v":""}]
[42,"Ind4_Number of staff in workforce ",{"$f":"IF('Data for submission '!F61=\"\",0,'Data for submission '!F61)","v":0},{"$f":"IF('Data for submission '!G61=\"\",0,'Data for submission '!G61)","v":2350},{"$f":"IF('Data for submission '!H61=\"\",0,'Data for submission '!H61)","v":0},{"$f":"IF('Data for submission '!I61=\"\",0,'Data for submission '!I61)","v":2633},{"$f":"IF('Data for submission '!J61=\"\",0,'Data for submission '!J61)","v":0},{"$f":"IF('Data for submission '!K61=\"\",0,'Data for submission '!K61)","v":95},{"$f":"IF('Data for submission '!L61=\"\",0,'Data for submission '!L61)","v":0},{"$f":"IF('Data for submission '!M61=\"\",0,'Data for submission '!M61)","v":2750},{"$f":"IF('Data for submission '!N61=\"\",0,'Data for submission '!N61)","v":0},{"$f":"IF('Data for submission '!O61=\"\",0,'Data for submission '!O61)","v":2784},{"$f":"IF('Data for submission '!P61=\"\",0,'Data for submission '!P61)","v":0},{"$f":"IF('Data for submission '!Q61=\"\",0,'Data for submission '!Q61)","v":188},{"$f":"IF(ISBLANK('Data for submission '!R61),\"\",'Data for submission '!R61)","v":""}]
[43,"Ind4_Number of staff accessing non-mandatory training and CPD ",{"$f":"IF('Data for submission '!F62=\"\",0,'Data for submission '!F62)","v":0},{"$f":"IF('Data for submission '!G62=\"\",0,'Data for submission '!G62)","v":1036},{"$f":"IF('Data for submission '!H62=\"\",0,'Data for submission '!H62)","v":0},{"$f":"IF('Data for submission '!I62=\"\",0,'Data for submission '!I62)","v":1122},{"$f":"IF('Data for submission '!J62=\"\",0,'Data for submission '!J62)","v":0},{"$f":"IF('Data for submission '!K62=\"\",0,'Data for submission '!K62)","v":33},{"$f":"IF('Data for submission '!L62=\"\",0,'Data for submission '!L62)","v":0},{"$f":"IF('Data for submission '!M62=\"\",0,'Data for submission '!M62)","v":1469},{"$f":"IF('Data for submission '!N62=\"\",0,'Data for submission '!N62)","v":0},{"$f":"IF('Data for submission '!O62=\"\",0,'Data for submission '!O62)","v":1714},{"$f":"IF('Data for submission '!P62=\"\",0,'Data for submission '!P62)","v":0},{"$f":"IF('Data for submission '!Q62=\"\",0,'Data for submission '!Q62)","v":74},{"$f":"IF(ISBLANK('Data for submission '!R62),\"\",'Data for submission '!R62)","v":"The following are sources that were used in the collection of this data:\nAll doctors due to their weekly CPD;\nHealth roster study days for activities that were non-stat and non-man training;\nEmails from executives, service delivery board members, DMT's and HR BPs confirming their CPD activity and that of their teams;\nOLM (for all centrally booked non-mandatory training programmes, including nursing development);\nCoaching, mentoring, 360 degree feedback as well as other individual diagnostic and develpment/psychometric tools;\nInformation recieved from directorate education committees and development provider to community teams.\n"}]
[44,"Ind4_Likelihood of staff accessing non-mandatory training and CPD:",{"$f":"IF('Data for submission '!F63=\"\",0,'Data for submission '!F63)","v":0},{"$f":"IF('Data for submission '!G63=\"\",0,'Data for submission '!G63)","v":0.44085106382978723},{"$f":"IF('Data for submission '!H63=\"\",0,'Data for submission '!H63)","v":0},{"$f":"IF('Data for submission '!I63=\"\",0,'Data for submission '!I63)","v":0.42612988985947586},{"$f":"IF('Data for submission '!J63=\"\",0,'Data for submission '!J63)","v":0},{"$f":"IF('Data for submission '!K63=\"\",0,'Data for submission '!K63)","v":0.3473684210526316},{"$f":"IF('Data for submission '!L63=\"\",0,'Data for submission '!L63)","v":0},{"$f":"IF('Data for submission '!M63=\"\",0,'Data for submission '!M63)","v":0.5341818181818182},{"$f":"IF('Data for submission '!N63=\"\",0,'Data for submission '!N63)","v":0},{"$f":"IF('Data for submission '!O63=\"\",0,'Data for submission '!O63)","v":0.61566091954022983},{"$f":"IF('Data for submission '!P63=\"\",0,'Data for submission '!P63)","v":0},{"$f":"IF('Data for submission '!Q63=\"\",0,'Data for submission '!Q63)","v":0.39361702127659576},{"$f":"IF(ISBLANK('Data for submission '!R63),\"\",'Data for submission '!R63)","v":""}]
[45,"Ind4_Relative likelihood of White staff accessing non-mandatory training and CPD compared to BME staff:",{"$f":"IF('Data for submission '!F64=\"\",0,'Data for submission '!F64)","v":0},{"$f":"IF('Data for submission '!G64=\"\",0,'Data for submission '!G64)","v":1.034546213069367},{"$f":"IF('Data for submission '!H64=\"\",0,'Data for submission '!H64)","v":0},{"$f":"IF('Data for submission '!I64=\"\",0,'Data for submission '!I64)","v":0},{"$f":"IF('Data for submission '!J64=\"\",0,'Data for submission '!J64)","v":0},{"$f":"IF('Data for submission '!K64=\"\",0,'Data for submission '!K64)","v":0},{"$f":"IF('Data for submission '!L64=\"\",0,'Data for submission '!L64)","v":0},{"$f":"IF('Data for submission '!M64=\"\",0,'Data for submission '!M64)","v":0.86765588204094635},{"$f":"IF('Data for submission '!N64=\"\",0,'Data for submission '!N64)","v":0},{"$f":"IF('Data for submission '!O64=\"\",0,'Data for submission '!O64)","v":0},{"$f":"IF('Data for submission '!P64=\"\",0,'Data for submission '!P64)","v":0},{"$f":"IF('Data for submission '!Q64=\"\",0,'Data for submission '!Q64)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R64),\"\",'Data for submission '!R64)","v":""}]
[46,"Ind_5% of  staff experiencing harassment, bullying or abuse from patients, relatives  or the public in last 12 months ",{"$f":"IF('Data for submission '!F65=\"\",0,'Data for submission '!F65)","v":0},{"$f":"IF('Data for submission '!G65=\"\",0,'Data for submission '!G65)","v":0.28910000000000002},{"$f":"IF('Data for submission '!H65=\"\",0,'Data for submission '!H65)","v":0},{"$f":"IF('Data for submission '!I65=\"\",0,'Data for submission '!I65)","v":0.32619999999999999},{"$f":"IF('Data for submission '!J65=\"\",0,'Data for submission '!J65)","v":0},{"$f":"IF('Data for submission '!K65=\"\",0,'Data for submission '!K65)","v":0},{"$f":"IF('Data for submission '!L65=\"\",0,'Data for submission '!L65)","v":0},{"$f":"IF('Data for submission '!M65=\"\",0,'Data for submission '!M65)","v":0.317},{"$f":"IF('Data for submission '!N65=\"\",0,'Data for submission '!N65)","v":0},{"$f":"IF('Data for submission '!O65=\"\",0,'Data for submission '!O65)","v":0.35599999999999998},{"$f":"IF('Data for submission '!P65=\"\",0,'Data for submission '!P65)","v":0},{"$f":"IF('Data for submission '!Q65=\"\",0,'Data for submission '!Q65)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R65),\"\",'Data for submission '!R65)","v":"Please refer to the Picker staff survey RWK_East London NHS Foundation NNS18 RAG_Table _ Not experienced harassment, bullying or abuse from patients/service users, their relatives or members of the public. As this question is captured differently to the one on the WRES capture template - we have transposed the %"}]
[47,"Ind6_% of  staff experiencing harassment, bullying or abuse from staff in last 12 months ",{"$f":"IF('Data for submission '!F66=\"\",0,'Data for submission '!F66)","v":0},{"$f":"IF('Data for submission '!G66=\"\",0,'Data for submission '!G66)","v":0.2324},{"$f":"IF('Data for submission '!H66=\"\",0,'Data for submission '!H66)","v":0},{"$f":"IF('Data for submission '!I66=\"\",0,'Data for submission '!I66)","v":0.22570000000000001},{"$f":"IF('Data for submission '!J66=\"\",0,'Data for submission '!J66)","v":0},{"$f":"IF('Data for submission '!K66=\"\",0,'Data for submission '!K66)","v":0},{"$f":"IF('Data for submission '!L66=\"\",0,'Data for submission '!L66)","v":0},{"$f":"IF('Data for submission '!M66=\"\",0,'Data for submission '!M66)","v":0.16200000000000001},{"$f":"IF('Data for submission '!N66=\"\",0,'Data for submission '!N66)","v":0},{"$f":"IF('Data for submission '!O66=\"\",0,'Data for submission '!O66)","v":0.18},{"$f":"IF('Data for submission '!P66=\"\",0,'Data for submission '!P66)","v":0},{"$f":"IF('Data for submission '!Q66=\"\",0,'Data for submission '!Q66)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R66),\"\",'Data for submission '!R66)","v":"Please refer to the Picker staff survey RWK_East London NHS Foundation NNS18 RAG_Table _ Not experienced harassment, bullying or abuse from other colleagues. As this question is captured differently to the one on the WRES capture template - we have transposed the %"}]
[48,"Ind7_%  staff believing that trust provides equal opportunities for career progression or promotion",{"$f":"IF('Data for submission '!F67=\"\",0,'Data for submission '!F67)","v":0},{"$f":"IF('Data for submission '!G67=\"\",0,'Data for submission '!G67)","v":0.83809999999999996},{"$f":"IF('Data for submission '!H67=\"\",0,'Data for submission '!H67)","v":0},{"$f":"IF('Data for submission '!I67=\"\",0,'Data for submission '!I67)","v":0.72570000000000001},{"$f":"IF('Data for submission '!J67=\"\",0,'Data for submission '!J67)","v":0},{"$f":"IF('Data for submission '!K67=\"\",0,'Data for submission '!K67)","v":0},{"$f":"IF('Data for submission '!L67=\"\",0,'Data for submission '!L67)","v":0},{"$f":"IF('Data for submission '!M67=\"\",0,'Data for submission '!M67)","v":0.84699999999999998},{"$f":"IF('Data for submission '!N67=\"\",0,'Data for submission '!N67)","v":0},{"$f":"IF('Data for submission '!O67=\"\",0,'Data for submission '!O67)","v":0.71799999999999997},{"$f":"IF('Data for submission '!P67=\"\",0,'Data for submission '!P67)","v":0},{"$f":"IF('Data for submission '!Q67=\"\",0,'Data for submission '!Q67)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R67),\"\",'Data for submission '!R67)","v":""}]
[49,"Ind8_%  staff personally experienced discrimination at work from Manager/team leader or other colleague",{"$f":"IF('Data for submission '!F68=\"\",0,'Data for submission '!F68)","v":0},{"$f":"IF('Data for submission '!G68=\"\",0,'Data for submission '!G68)","v":9.0899999999999995E-2},{"$f":"IF('Data for submission '!H68=\"\",0,'Data for submission '!H68)","v":0},{"$f":"IF('Data for submission '!I68=\"\",0,'Data for submission '!I68)","v":0.13020000000000001},{"$f":"IF('Data for submission '!J68=\"\",0,'Data for submission '!J68)","v":0},{"$f":"IF('Data for submission '!K68=\"\",0,'Data for submission '!K68)","v":0},{"$f":"IF('Data for submission '!L68=\"\",0,'Data for submission '!L68)","v":0},{"$f":"IF('Data for submission '!M68=\"\",0,'Data for submission '!M68)","v":8.4000000000000005E-2},{"$f":"IF('Data for submission '!N68=\"\",0,'Data for submission '!N68)","v":0},{"$f":"IF('Data for submission '!O68=\"\",0,'Data for submission '!O68)","v":0.14399999999999999},{"$f":"IF('Data for submission '!P68=\"\",0,'Data for submission '!P68)","v":0},{"$f":"IF('Data for submission '!Q68=\"\",0,'Data for submission '!Q68)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R68),\"\",'Data for submission '!R68)","v":"Please refer to the Picker staff survey RWK_East London NHS Foundation NNS18 RAG_Table _ Not experienced discrimination from manager/team leader or other colleagues. As this question is captured differently to the one on the WRES capture template - we have transposed the %"}]
[50,"Ind9_Total Board members",{"$f":"IF('Data for submission '!F69=\"\",0,'Data for submission '!F69)","v":0},{"$f":"IF('Data for submission '!G69=\"\",0,'Data for submission '!G69)","v":10},{"$f":"IF('Data for submission '!H69=\"\",0,'Data for submission '!H69)","v":0},{"$f":"IF('Data for submission '!I69=\"\",0,'Data for submission '!I69)","v":8},{"$f":"IF('Data for submission '!J69=\"\",0,'Data for submission '!J69)","v":0},{"$f":"IF('Data for submission '!K69=\"\",0,'Data for submission '!K69)","v":0},{"$f":"IF('Data for submission '!L69=\"\",0,'Data for submission '!L69)","v":0},{"$f":"IF('Data for submission '!M69=\"\",0,'Data for submission '!M69)","v":9},{"$f":"IF('Data for submission '!N69=\"\",0,'Data for submission '!N69)","v":0},{"$f":"IF('Data for submission '!O69=\"\",0,'Data for submission '!O69)","v":9},{"$f":"IF('Data for submission '!P69=\"\",0,'Data for submission '!P69)","v":0},{"$f":"IF('Data for submission '!Q69=\"\",0,'Data for submission '!Q69)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R69),\"\",'Data for submission '!R69)","v":""}]
[51,"Ind9_ of which: Voting Board members",{"$f":"IF('Data for submission '!F70=\"\",0,'Data for submission '!F70)","v":0},{"$f":"IF('Data for submission '!G70=\"\",0,'Data for submission '!G70)","v":8},{"$f":"IF('Data for submission '!H70=\"\",0,'Data for submission '!H70)","v":0},{"$f":"IF('Data for submission '!I70=\"\",0,'Data for submission '!I70)","v":7},{"$f":"IF('Data for submission '!J70=\"\",0,'Data for submission '!J70)","v":0},{"$f":"IF('Data for submission '!K70=\"\",0,'Data for submission '!K70)","v":0},{"$f":"IF('Data for submission '!L70=\"\",0,'Data for submission '!L70)","v":0},{"$f":"IF('Data for submission '!M70=\"\",0,'Data for submission '!M70)","v":8},{"$f":"IF('Data for submission '!N70=\"\",0,'Data for submission '!N70)","v":0},{"$f":"IF('Data for submission '!O70=\"\",0,'Data for submission '!O70)","v":7},{"$f":"IF('Data for submission '!P70=\"\",0,'Data for submission '!P70)","v":0},{"$f":"IF('Data for submission '!Q70=\"\",0,'Data for submission '!Q70)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R70),\"\",'Data for submission '!R70)","v":""}]
[52,"Ind9_                 : Non Voting Board members",{"$f":"IF('Data for submission '!F71=\"\",0,'Data for submission '!F71)","v":0},{"$f":"IF('Data for submission '!G71=\"\",0,'Data for submission '!G71)","v":2},{"$f":"IF('Data for submission '!H71=\"\",0,'Data for submission '!H71)","v":0},{"$f":"IF('Data for submission '!I71=\"\",0,'Data for submission '!I71)","v":1},{"$f":"IF('Data for submission '!J71=\"\",0,'Data for submission '!J71)","v":0},{"$f":"IF('Data for submission '!K71=\"\",0,'Data for submission '!K71)","v":0},{"$f":"IF('Data for submission '!L71=\"\",0,'Data for submission '!L71)","v":0},{"$f":"IF('Data for submission '!M71=\"\",0,'Data for submission '!M71)","v":1},{"$f":"IF('Data for submission '!N71=\"\",0,'Data for submission '!N71)","v":0},{"$f":"IF('Data for submission '!O71=\"\",0,'Data for submission '!O71)","v":2},{"$f":"IF('Data for submission '!P71=\"\",0,'Data for submission '!P71)","v":0},{"$f":"IF('Data for submission '!Q71=\"\",0,'Data for submission '!Q71)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R71),\"\",'Data for submission '!R71)","v":""}]
[53,"Ind9_Total Board members",{"$f":"IF('Data for submission '!F72=\"\",0,'Data for submission '!F72)","v":0},{"$f":"IF('Data for submission '!G72=\"\",0,'Data for submission '!G72)","v":10},{"$f":"IF('Data for submission '!H72=\"\",0,'Data for submission '!H72)","v":0},{"$f":"IF('Data for submission '!I72=\"\",0,'Data for submission '!I72)","v":8},{"$f":"IF('Data for submission '!J72=\"\",0,'Data for submission '!J72)","v":0},{"$f":"IF('Data for submission '!K72=\"\",0,'Data for submission '!K72)","v":0},{"$f":"IF('Data for submission '!L72=\"\",0,'Data for submission '!L72)","v":0},{"$f":"IF('Data for submission '!M72=\"\",0,'Data for submission '!M72)","v":9},{"$f":"IF('Data for submission '!N72=\"\",0,'Data for submission '!N72)","v":0},{"$f":"IF('Data for submission '!O72=\"\",0,'Data for submission '!O72)","v":9},{"$f":"IF('Data for submission '!P72=\"\",0,'Data for submission '!P72)","v":0},{"$f":"IF('Data for submission '!Q72=\"\",0,'Data for submission '!Q72)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R72),\"\",'Data for submission '!R72)","v":""}]
[54,"Ind9_ of which: Exec Board members",{"$f":"IF('Data for submission '!F73=\"\",0,'Data for submission '!F73)","v":0},{"$f":"IF('Data for submission '!G73=\"\",0,'Data for submission '!G73)","v":5},{"$f":"IF('Data for submission '!H73=\"\",0,'Data for submission '!H73)","v":0},{"$f":"IF('Data for submission '!I73=\"\",0,'Data for submission '!I73)","v":5},{"$f":"IF('Data for submission '!J73=\"\",0,'Data for submission '!J73)","v":0},{"$f":"IF('Data for submission '!K73=\"\",0,'Data for submission '!K73)","v":0},{"$f":"IF('Data for submission '!L73=\"\",0,'Data for submission '!L73)","v":0},{"$f":"IF('Data for submission '!M73=\"\",0,'Data for submission '!M73)","v":4},{"$f":"IF('Data for submission '!N73=\"\",0,'Data for submission '!N73)","v":0},{"$f":"IF('Data for submission '!O73=\"\",0,'Data for submission '!O73)","v":6},{"$f":"IF('Data for submission '!P73=\"\",0,'Data for submission '!P73)","v":0},{"$f":"IF('Data for submission '!Q73=\"\",0,'Data for submission '!Q73)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R73),\"\",'Data for submission '!R73)","v":""}]
[55,"Ind9_                 : Non Executive Board members",{"$f":"IF('Data for submission '!F74=\"\",0,'Data for submission '!F74)","v":0},{"$f":"IF('Data for submission '!G74=\"\",0,'Data for submission '!G74)","v":5},{"$f":"IF('Data for submission '!H74=\"\",0,'Data for submission '!H74)","v":0},{"$f":"IF('Data for submission '!I74=\"\",0,'Data for submission '!I74)","v":3},{"$f":"IF('Data for submission '!J74=\"\",0,'Data for submission '!J74)","v":0},{"$f":"IF('Data for submission '!K74=\"\",0,'Data for submission '!K74)","v":0},{"$f":"IF('Data for submission '!L74=\"\",0,'Data for submission '!L74)","v":0},{"$f":"IF('Data for submission '!M74=\"\",0,'Data for submission '!M74)","v":5},{"$f":"IF('Data for submission '!N74=\"\",0,'Data for submission '!N74)","v":0},{"$f":"IF('Data for submission '!O74=\"\",0,'Data for submission '!O74)","v":3},{"$f":"IF('Data for submission '!P74=\"\",0,'Data for submission '!P74)","v":0},{"$f":"IF('Data for submission '!Q74=\"\",0,'Data for submission '!Q74)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R74),\"\",'Data for submission '!R74)","v":""}]
[56,"Ind9_Number of staff in overall workforce",{"$f":"IF('Data for submission '!F75=\"\",0,'Data for submission '!F75)","v":0},{"$f":"IF('Data for submission '!G75=\"\",0,'Data for submission '!G75)","v":2350},{"$f":"IF('Data for submission '!H75=\"\",0,'Data for submission '!H75)","v":0},{"$f":"IF('Data for submission '!I75=\"\",0,'Data for submission '!I75)","v":2633},{"$f":"IF('Data for submission '!J75=\"\",0,'Data for submission '!J75)","v":0},{"$f":"IF('Data for submission '!K75=\"\",0,'Data for submission '!K75)","v":95},{"$f":"IF('Data for submission '!L75=\"\",0,'Data for submission '!L75)","v":0},{"$f":"IF('Data for submission '!M75=\"\",0,'Data for submission '!M75)","v":2750},{"$f":"IF('Data for submission '!N75=\"\",0,'Data for submission '!N75)","v":0},{"$f":"IF('Data for submission '!O75=\"\",0,'Data for submission '!O75)","v":2784},{"$f":"IF('Data for submission '!P75=\"\",0,'Data for submission '!P75)","v":0},{"$f":"IF('Data for submission '!Q75=\"\",0,'Data for submission '!Q75)","v":188},{"$f":"IF(ISBLANK('Data for submission '!R75),\"\",'Data for submission '!R75)","v":""}]
[57,"Ind9_Total Board members - % by Ethnicity",{"$f":"IF('Data for submission '!F76=\"\",0,'Data for submission '!F76)","v":0},{"$f":"IF('Data for submission '!G76=\"\",0,'Data for submission '!G76)","v":0.55555555555555558},{"$f":"IF('Data for submission '!H76=\"\",0,'Data for submission '!H76)","v":0},{"$f":"IF('Data for submission '!I76=\"\",0,'Data for submission '!I76)","v":0.44444444444444442},{"$f":"IF('Data for submission '!J76=\"\",0,'Data for submission '!J76)","v":0},{"$f":"IF('Data for submission '!K76=\"\",0,'Data for submission '!K76)","v":0},{"$f":"IF('Data for submission '!L76=\"\",0,'Data for submission '!L76)","v":0},{"$f":"IF('Data for submission '!M76=\"\",0,'Data for submission '!M76)","v":0.5},{"$f":"IF('Data for submission '!N76=\"\",0,'Data for submission '!N76)","v":0},{"$f":"IF('Data for submission '!O76=\"\",0,'Data for submission '!O76)","v":0.5},{"$f":"IF('Data for submission '!P76=\"\",0,'Data for submission '!P76)","v":0},{"$f":"IF('Data for submission '!Q76=\"\",0,'Data for submission '!Q76)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R76),\"\",'Data for submission '!R76)","v":""}]
[58,"Ind9_Voting Board Member - % by Ethnicity",{"$f":"IF('Data for submission '!F77=\"\",0,'Data for submission '!F77)","v":0},{"$f":"IF('Data for submission '!G77=\"\",0,'Data for submission '!G77)","v":0.53333333333333333},{"$f":"IF('Data for submission '!H77=\"\",0,'Data for submission '!H77)","v":0},{"$f":"IF('Data for submission '!I77=\"\",0,'Data for submission '!I77)","v":0.46666666666666667},{"$f":"IF('Data for submission '!J77=\"\",0,'Data for submission '!J77)","v":0},{"$f":"IF('Data for submission '!K77=\"\",0,'Data for submission '!K77)","v":0},{"$f":"IF('Data for submission '!L77=\"\",0,'Data for submission '!L77)","v":0},{"$f":"IF('Data for submission '!M77=\"\",0,'Data for submission '!M77)","v":0.53333333333333333},{"$f":"IF('Data for submission '!N77=\"\",0,'Data for submission '!N77)","v":0},{"$f":"IF('Data for submission '!O77=\"\",0,'Data for submission '!O77)","v":0.46666666666666667},{"$f":"IF('Data for submission '!P77=\"\",0,'Data for submission '!P77)","v":0},{"$f":"IF('Data for submission '!Q77=\"\",0,'Data for submission '!Q77)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R77),\"\",'Data for submission '!R77)","v":""}]
[59,"Ind9_Non Voting Board Member - % by Ethnicity",{"$f":"IF('Data for submission '!F78=\"\",0,'Data for submission '!F78)","v":0},{"$f":"IF('Data for submission '!G78=\"\",0,'Data for submission '!G78)","v":0.66666666666666663},{"$f":"IF('Data for submission '!H78=\"\",0,'Data for submission '!H78)","v":0},{"$f":"IF('Data for submission '!I78=\"\",0,'Data for submission '!I78)","v":0.33333333333333331},{"$f":"IF('Data for submission '!J78=\"\",0,'Data for submission '!J78)","v":0},{"$f":"IF('Data for submission '!K78=\"\",0,'Data for submission '!K78)","v":0},{"$f":"IF('Data for submission '!L78=\"\",0,'Data for submission '!L78)","v":0},{"$f":"IF('Data for submission '!M78=\"\",0,'Data for submission '!M78)","v":0.33333333333333331},{"$f":"IF('Data for submission '!N78=\"\",0,'Data for submission '!N78)","v":0},{"$f":"IF('Data for submission '!O78=\"\",0,'Data for submission '!O78)","v":0.66666666666666663},{"$f":"IF('Data for submission '!P78=\"\",0,'Data for submission '!P78)","v":0},{"$f":"IF('Data for submission '!Q78=\"\",0,'Data for submission '!Q78)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R78),\"\",'Data for submission '!R78)","v":""}]
[60,"Ind9_Executive Board Member - % by Ethnicity",{"$f":"IF('Data for submission '!F79=\"\",0,'Data for submission '!F79)","v":0},{"$f":"IF('Data for submission '!G79=\"\",0,'Data for submission '!G79)","v":0.5},{"$f":"IF('Data for submission '!H79=\"\",0,'Data for submission '!H79)","v":0},{"$f":"IF('Data for submission '!I79=\"\",0,'Data for submission '!I79)","v":0.5},{"$f":"IF('Data for submission '!J79=\"\",0,'Data for submission '!J79)","v":0},{"$f":"IF('Data for submission '!K79=\"\",0,'Data for submission '!K79)","v":0},{"$f":"IF('Data for submission '!L79=\"\",0,'Data for submission '!L79)","v":0},{"$f":"IF('Data for submission '!M79=\"\",0,'Data for submission '!M79)","v":0.4},{"$f":"IF('Data for submission '!N79=\"\",0,'Data for submission '!N79)","v":0},{"$f":"IF('Data for submission '!O79=\"\",0,'Data for submission '!O79)","v":0.6},{"$f":"IF('Data for submission '!P79=\"\",0,'Data for submission '!P79)","v":0},{"$f":"IF('Data for submission '!Q79=\"\",0,'Data for submission '!Q79)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R79),\"\",'Data for submission '!R79)","v":""}]
[61,"Ind9_Non Executive Board Member - % by Ethnicity",{"$f":"IF('Data for submission '!F80=\"\",0,'Data for submission '!F80)","v":0},{"$f":"IF('Data for submission '!G80=\"\",0,'Data for submission '!G80)","v":0.625},{"$f":"IF('Data for submission '!H80=\"\",0,'Data for submission '!H80)","v":0},{"$f":"IF('Data for submission '!I80=\"\",0,'Data for submission '!I80)","v":0.375},{"$f":"IF('Data for submission '!J80=\"\",0,'Data for submission '!J80)","v":0},{"$f":"IF('Data for submission '!K80=\"\",0,'Data for submission '!K80)","v":0},{"$f":"IF('Data for submission '!L80=\"\",0,'Data for submission '!L80)","v":0},{"$f":"IF('Data for submission '!M80=\"\",0,'Data for submission '!M80)","v":0.625},{"$f":"IF('Data for submission '!N80=\"\",0,'Data for submission '!N80)","v":0},{"$f":"IF('Data for submission '!O80=\"\",0,'Data for submission '!O80)","v":0.375},{"$f":"IF('Data for submission '!P80=\"\",0,'Data for submission '!P80)","v":0},{"$f":"IF('Data for submission '!Q80=\"\",0,'Data for submission '!Q80)","v":0},{"$f":"IF(ISBLANK('Data for submission '!R80),\"\",'Data for submission '!R80)","v":""}]
[62,"Ind9_Overall workforce - % by Ethnicity",{"$f":"IF('Data for submission '!F81=\"\",0,'Data for submission '!F81)","v":0},{"$f":"IF('Data for submission '!G81=\"\",0,'Data for submission '!G81)","v":0.46278062229224104},{"$f":"IF('Data for submission '!H81=\"\",0,'Data for submission '!H81)","v":0},{"$f":"IF('Data for submission '!I81=\"\",0,'Data for submission '!I81)","v":0.51851122489168966},{"$f":"IF('Data for submission '!J81=\"\",0,'Data for submission '!J81)","v":0},{"$f":"IF('Data for submission '!K81=\"\",0,'Data for submission '!K81)","v":1.8708152816069318E-2},{"$f":"IF('Data for submission '!L81=\"\",0,'Data for submission '!L81)","v":0},{"$f":"IF('Data for submission '!M81=\"\",0,'Data for submission '!M81)","v":0.48060118839566585},{"$f":"IF('Data for submission '!N81=\"\",0,'Data for submission '!N81)","v":0},{"$f":"IF('Data for submission '!O81=\"\",0,'Data for submission '!O81)","v":0.48654316672492137},{"$f":"IF('Data for submission '!P81=\"\",0,'Data for submission '!P81)","v":0},{"$f":"IF('Data for submission '!Q81=\"\",0,'Data for submission '!Q81)","v":3.2855644879412796E-2},{"$f":"IF(ISBLANK('Data for submission '!R81),\"\",'Data for submission '!R81)","v":""}]
[63,"Ind9_Difference (Total Board -Overall workforce )",{"$f":"IF('Data for submission '!F82=\"\",0,'Data for submission '!F82)","v":0},{"$f":"IF('Data for submission '!G82=\"\",0,'Data for submission '!G82)","v":9.2774933263314541E-2},{"$f":"IF('Data for submission '!H82=\"\",0,'Data for submission '!H82)","v":0},{"$f":"IF('Data for submission '!I82=\"\",0,'Data for submission '!I82)","v":-7.406678044724524E-2},{"$f":"IF('Data for submission '!J82=\"\",0,'Data for submission '!J82)","v":0},{"$f":"IF('Data for submission '!K82=\"\",0,'Data for submission '!K82)","v":-1.8708152816069318E-2},{"$f":"IF('Data for submission '!L82=\"\",0,'Data for submission '!L82)","v":0},{"$f":"IF('Data for submission '!M82=\"\",0,'Data for submission '!M82)","v":1.9398811604334154E-2},{"$f":"IF('Data for submission '!N82=\"\",0,'Data for submission '!N82)","v":0},{"$f":"IF('Data for submission '!O82=\"\",0,'Data for submission '!O82)","v":1.3456833275078628E-2},{"$f":"IF('Data for submission '!P82=\"\",0,'Data for submission '!P82)","v":0},{"$f":"IF('Data for submission '!Q82=\"\",0,'Data for submission '!Q82)","v":-3.2855644879412796E-2},{"$f":"IF(ISBLANK('Data for submission '!R82),\"\",'Data for submission '!R82)","v":""}]