{"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":13,"n_cols":4,"rows_kept":13,"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"]
[null,7,"2020-07-02","Updated backsheet/Cells/formulas. Work captured in DM-6438"]

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

{"sheet":"Control_Panel","index":2,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,1,14,7],[1,1,1,7],[3,1,3,7],[4,1,6,7],[8,1,8,7],[13,1,13,7],[12,1,12,7],[11,1,11,7],[9,1,9,7],[10,1,10,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)<>342,\"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 '!$f$69\",\"'Data for submission '!$f$65:$f$66\",\"'Data for submission '!$g$65:$g$66\",\"'Data for submission '!$g$69\",\"'Data for submission '!$h$69\",\"'Data for submission '!$h$65:$h$66\",\"'Data for submission '!$i$65:$i$66\",\"'Data for submission '!$i$69\",\"'Data for submission '!$j$65:$j$66\",\"'Data for submission '!$j$69\",\"'Data for submission '!$k$65:$k$66\",\"'Data for submission '!$k$69\",\"'Data for submission '!$k$62\",\"'Data for submission '!$j$62\",\"'Data for submission '!$i$62\",\"'Data for submission '!$k$58\",\"'Data for submission '!$j$58\",\"'Data for submission '!$i$58\",\"'Data for submission '!$f$48:$f$52\",\"'Data for submission '!$g$48:$g$54\",\"'Data for submission '!$h$48:$h$54\",\"'Data for submission '!$i$48:$i$54\",\"'Data for submission '!$j$48:$j$54\",\"'Data for submission '!$k$48:$k$54\",\"'Data for submission '!$k$38:$k$46\",\"'Data for submission '!$j$33:$j$46\",\"'Data for submission '!$i$33:$i$46\",\"'Data for submission '!$h$33:$h$46\",\"'Data for submission '!$g$33:$g$46\",\"'Data for submission '!$f$33:$f$46\",\"'Data for submission '!$f$17:$f$30\",\"'Data for submission '!$g$17:$g$30\",\"'Data for submission '!$h$17:$h$30\",\"'Data for submission '!$i$17:$i$30\",\"'Data for submission '!$j$17:$j$30\",\"'Data for submission '!$k$17:$k$30\"}),\"*\"))>0,\"Please refer to the Validation and Data Checks Sheet.\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"B11","v":""}]
[null,{"$f":"IF(COUNTIF('Validation and Data Checks'!F18:K31,\"Error\")>0,\"Please refer to Validation and Data Checks Tab\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"B12","v":""}]
[null,{"$f":"IF(SUMPRODUCT(N(LEN('Data for submission '!L17:L78)>255)),\"You can only enter 255 characters in the notes field per cell, please can you review and amend\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"B13","v":""}]
[null,{"$f":"IF(K2=0,\"\",\"Cut and Paste is not permitted. This Template is broken. Please download a new template\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(K2=0,\"\",\"Cut and Paste is not permitted. This Template is broken. Please download a new template\")","v":""}]
[null,{"$f":"IF(COUNTIF('Validation and Data Checks'!F17:K31,\"Error you have exceeded the character limit\")>0,\"Error you have exceeded the character limit. Please refer to Validation and Data Checks Tab\",\"\")","v":""}]

{"sheet":"Data for submission ","index":3,"n_rows":78,"n_cols":18,"rows_kept":78,"cut":false,"hidden":false,"merged":[[12,8,12,10],[13,5,14,5],[13,6,14,6],[8,2,8,4],[12,5,12,7],[30,11,31,11],[46,8,46,10],[46,3,46,4],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,10,14,10],[30,8,31,10],[30,3,31,4],[13,3,14,3],[30,5,31,7],[46,5,46,7],[13,11,14,11],[64,0,77,0],[13,0,14,1],[13,4,14,4],[60,0,63,0],[64,1,77,1],[52,0,55,0],[15,0,51,0],[56,0,59,0],[13,2,14,2],[60,1,63,1],[56,1,59,1],[52,1,55,1],[15,1,51,1],[30,2,31,2]]}
[]
[]
[null,"SubmissionTemplate"]
[]
[null,"Workforce Race Equality Standards 2019/20 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,2019,null,null,2020]
["INDICATOR",null,"DATA ITEM",null,"MEASURE","WHITE","BME","ETHNICITY UNKNOWN/NULL","WHITE","BME","ETHNICITY UNKNOWN/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,"Verified figures ","Verified figures ","Verified figures ","Verified figures ","Verified figures ","Verified figures "]
[null,null,1,"Under Band 1","Headcount",16,1,3,14,1,0,null,"< Band 1 (i.e. Apprentices)","Non Clinical",null,"White"]
[null,null,2,"Band 1","Headcount",495,11,21,167,2,10,null,"Band 1","Non Clinical",null,"BME"]
[null,null,3,"Band 2","Headcount",364,12,9,795,23,16,null,"Band 2","Non Clinical",null,"Unknown/Null"]
[null,null,4,"Band 3","Headcount",362,3,8,365,3,7,null,"Band 3","Non Clinical"]
[null,null,5,"Band 4","Headcount",139,3,4,153,3,5,null,"Band 4","Non Clinical"]
[null,null,6,"Band 5","Headcount",53,0,1,49,0,0,null,"Band 5","Non Clinical"]
[null,null,7,"Band 6","Headcount",65,2,2,70,1,2,null,"Band 6","Non Clinical"]
[null,null,8,"Band 7","Headcount",44,3,2,48,4,2,null,"Band 7","Non Clinical"]
[null,null,9,"Band 8A","Headcount",42,0,0,44,1,0,null,"Band 8a","Non Clinical"]
[null,null,10,"Band 8B","Headcount",17,0,0,18,0,0,null,"Band 8b","Non Clinical"]
[null,null,11,"Band 8C","Headcount",14,0,0,19,0,0,null,"Band 8c","Non Clinical"]
[null,null,12,"Band 8D","Headcount",9,0,0,8,0,0,null,"Band 8d","Non Clinical"]
[null,null,13,"Band 9","Headcount",0,0,0,0,0,0,null,"Band 9","Non Clinical"]
[null,null,14,"VSM","Headcount",8,0,0,7,0,0,null,"VSM","Non Clinical"]
[null,null,null,"1b) Clinical workforce\nof which Non Medical"]
[]
[null,null,15,"Under Band 1","Headcount",3,0,0,2,0,0,null,"< Band 1 (i.e. Apprentices)","Clinical"]
[null,null,16,"Band 1","Headcount",50,0,3,18,0,0,null,"Band 1","Clinical"]
[null,null,17,"Band 2","Headcount",1135,32,34,1089,33,32,null,"Band 2","Clinical"]
[null,null,18,"Band 3","Headcount",285,3,6,331,16,6,null,"Band 3","Clinical"]
[null,null,19,"Band 4","Headcount",90,1,5,94,2,4,null,"Band 4","Clinical"]
[null,null,20,"Band 5","Headcount",1055,121,34,1004,134,32,null,"Band 5","Clinical"]
[null,null,21,"Band 6","Headcount",772,28,26,797,34,26,null,"Band 6","Clinical"]
[null,null,22,"Band 7","Headcount",377,9,8,406,9,8,null,"Band 7","Clinical"]
[null,null,23,"Band 8A","Headcount",74,7,2,79,7,1,null,"Band 8a","Clinical"]
[null,null,24,"Band 8B","Headcount",12,2,0,12,2,0,null,"Band 8b","Clinical"]
[null,null,25,"Band 8C","Headcount",13,0,0,13,0,0,null,"Band 8c","Clinical"]
[null,null,26,"Band 8D","Headcount",3,0,0,3,0,0,null,"Band 8d","Clinical"]
[null,null,27,"Band 9","Headcount",1,1,1,1,1,1,null,"Band 9","Clinical"]
[null,null,28,"VSM","Headcount",7,2,1,7,1,0,null,"VSM","Clinical"]
[null,null,null,"Of which Medical & Dental"]
[null,null,29,"Consultants","Headcount",105,149,335,105,156,300,null,"Medical & Dental Consultant","Clinical"]
[null,null,30,"  of which Senior medical manager","Headcount",0,0,0,0,0,0]
[null,null,31,"Non-consultant career grade","Headcount",22,66,2,24,68,2,null,"Medical & Dental Non-consultant career grade","Clinical"]
[null,null,32,"Trainee grades","Headcount",100,119,15,96,140,18,null,"Medical & Dental Trainee grades","Clinical"]
[null,null,33,"Other","Headcount",0,0,0,0,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",533,70,6,1145,142,61,null,null,null,null,null,2.5522925244872678,0.55591665613817298]
[null,null,35,"Number appointed from shortlisting","Headcount",266,18,0,403,39,30]
[null,null,36,"Relative likelihood of appointment from shortlisting","Auto calculated",{"$f":"IFERROR(F54/F53,\"\")","v":0.49906191369606001},0.25714285714285712,0,0.35196506550218343,0.27464788732394368,0.49180327868852458]
[null,null,37,"Relative likelihood of White staff being appointed from shortlisting compared to BME staff","Auto calculated",{"$f":"IFERROR(F55/G55,\"\")","v":1.9407963310402336},null,null,{"$f":"IFERROR(I55/J55,\"\")","v":1.2815138282387191}]
[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",{"$f":"IF(SUM(F17:F30)+SUM(F33:F46)+F48+SUM(F50:F52)=0,\"\",SUM(F17:F30)+SUM(F33:F46)+F48+SUM(F50:F52))","v":5732},{"$f":"IF(SUM(G17:G30)+SUM(G33:G46)+G48+SUM(G50:G52)=0,\"\",SUM(G17:G30)+SUM(G33:G46)+G48+SUM(G50:G52))","v":575},{"$f":"IF(SUM(H17:H30)+SUM(H33:H46)+H48+SUM(H50:H52)=0,\"\",SUM(H17:H30)+SUM(H33:H46)+H48+SUM(H50:H52))","v":522},{"$f":"IF(SUM(I17:I30)+SUM(I33:I46)+I48+SUM(I50:I52)=0,\"\",SUM(I17:I30)+SUM(I33:I46)+I48+SUM(I50:I52))","v":5838},{"$f":"IF(SUM(J17:J30)+SUM(J33:J46)+J48+SUM(J50:J52)=0,\"\",SUM(J17:J30)+SUM(J33:J46)+J48+SUM(J50:J52))","v":641},{"$f":"IF(SUM(K17:K30)+SUM(K33:K46)+K48+SUM(K50:K52)=0,\"\",SUM(K17:K30)+SUM(K33:K46)+K48+SUM(K50:K52))","v":472},null,null,null,null,null,4.3158680043516524,0]
[null,null,39,"Number of staff entering the formal disciplinary process","Headcount",55,4,1,56,4,2]
[null,null,40,"Likelihood of staff entering the formal disciplinary process","Auto calculated",{"$f":"IFERROR(F58/F57,\"\")","v":9.5952547103977676E-3},6.956521739130435E-3,1.9157088122605363E-3,9.5923261390887284E-3,6.2402496099843996E-3,4.2372881355932203E-3]
[null,null,41,"Relative likelihood of BME staff entering the formal disciplinary process compared to White staff","Auto calculated",null,{"$f":"IFERROR(G59/F59,\"\")","v":0.72499604743083002},null,null,{"$f":"IFERROR(J59/I59,\"\")","v":0.65054602184087373}]
[4,"Relative likelihood of staff accessing non-mandatory training and CPD",42,"Number of staff in workforce","Auto calculated",{"$f":"F57","v":5732},575,522,5838,641,472,null,null,null,null,null,2.0521583133406875,0.10298981852318034]
[null,null,43,"Number of staff accessing non-mandatory training and CPD:","Headcount",5534,509,208,5565,566,203]
[null,null,44,"Likelihood of staff accessing non-mandatory training and CPD","Auto calculated",{"$f":"IFERROR(F62/F61,\"\")","v":0.96545708304256805},0.88521739130434784,0.39846743295019155,0.9532374100719424,0.88299531981279256,0.43008474576271188]
[null,null,45,"Relative likelihood of White staff accessing non-mandatory training and CPD compared to BME staff","Auto calculated",{"$f":"IFERROR(F63/G63,\"\")","v":1.0906440525529992},null,null,{"$f":"IFERROR(I63/J63,\"\")","v":1.079549787731652}]
[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",46,"Total Board members","Headcount",12,2,0,12,1,0]
[null,null,47," of which: Voting Board members","Headcount",11,2,0,11,1,0]
[null,null,48,"                 : Non Voting Board members","Auto calculated",{"$f":"IFERROR(F65-F66,\"Error\")","v":1},0,0,1,0,0]
[null,null,49,"Total Board members","Auto calculated",{"$f":"F65","v":12},2,0,12,1,0]
[null,null,50," of which: Exec Board members","Headcount",6,1,0,6,1,0]
[null,null,51,"                 : Non Executive Board members","Auto calculated",{"$f":"IFERROR(F68-F69,\"Error\")","v":6},1,0,6,0,0]
[null,null,52,"Number of staff in overall workforce","Auto calculated",{"$f":"F57","v":5732},{"$f":"G57","v":575},522,{"$f":"I57","v":5838},{"$f":"J57","v":641},{"$f":"K57","v":472}]
[null,null,53,"Total Board members - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F65/($F$65+$G$65+$H$65),\"\")","v":0.8571428571428571},{"$f":"IFERROR(G65/($F$65+$G$65+$H$65),\"\")","v":0.14285714285714285},{"$f":"IFERROR(H65/($F$65+$G$65+$H$65),\"\")","v":0},{"$f":"IFERROR(I65/(I65+J65+K65),\"\")","v":0.92307692307692313},{"$f":"IFERROR(J65/(I65+J65+K65),\"\")","v":7.6923076923076927E-2},{"$f":"IFERROR(K65/(I65+J65+K65),\"\")","v":0}]
[null,null,54,"Voting Board Member - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F66/($F$66+$G$66+$H$66),\"\")","v":0.84615384615384615},{"$f":"IFERROR(G66/($F$66+$G$66+$H$66),\"\")","v":0.15384615384615385},{"$f":"IFERROR(H66/($F$66+$G$66+$H$66),\"\")","v":0},{"$f":"IFERROR(I66/(I66+J66+K66),\"\")","v":0.91666666666666663},{"$f":"IFERROR(J66/(I66+J66+K66),\"\")","v":8.3333333333333329E-2},{"$f":"IFERROR(K66/(I66+J66+K66),\"\")","v":0}]
[null,null,55,"Non Voting Board Member - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F67/($F$67+$G$67+$H$67),\"\")","v":1},{"$f":"IFERROR(G67/($F$67+$G$67+$H$67),\"\")","v":0},{"$f":"IFERROR(H67/($F$67+$G$67+$H$67),\"\")","v":0},{"$f":"IFERROR(I67/(I67+J67+K67),\"\")","v":1},{"$f":"IFERROR(J67/(I67+J67+K67),\"\")","v":0},{"$f":"IFERROR(K67/(I67+J67+K67),\"\")","v":0}]
[null,null,56,"Executive Board Member - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F69/($F$69+$G$69+$H$69),\"\")","v":0.8571428571428571},{"$f":"IFERROR(G69/($F$69+$G$69+$H$69),\"\")","v":0.14285714285714285},{"$f":"IFERROR(H69/($F$69+$G$69+$H$69),\"\")","v":0},{"$f":"IFERROR(I69/(I69+J69+K69),\"\")","v":0.8571428571428571},{"$f":"IFERROR(J69/(I69+J69+K69),\"\")","v":0.14285714285714285},{"$f":"IFERROR(K69/(I69+J69+K69),\"\")","v":0}]
[null,null,57,"Non Executive Board Member - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F70/($F$70+$G$70+$H$70),\"\")","v":0.8571428571428571},{"$f":"IFERROR(G70/($F$70+$G$70+$H$70),\"\")","v":0.14285714285714285},{"$f":"IFERROR(H70/($F$70+$G$70+$H$70),\"\")","v":0},{"$f":"IFERROR(I70/(I70+J70+K70),\"\")","v":1},{"$f":"IFERROR(J70/(I70+J70+K70),\"\")","v":0},{"$f":"IFERROR(K70/(I70+J70+K70),\"\")","v":0}]
[null,null,58,"Overall workforce - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F71/($F$71+$G$71+$H$71),\"\")","v":0.83936154634646365},{"$f":"IFERROR(G71/($F$71+$G$71+$H$71),\"\")","v":8.4199736418216431E-2},{"$f":"IFERROR(H71/($F$71+$G$71+$H$71),\"\")","v":7.6438717235319961E-2},{"$f":"IFERROR(I71/($I$71+$J$71+$K$71),\"\")","v":0.83987915407854985},{"$f":"IFERROR(J71/($I$71+$J$71+$K$71),\"\")","v":9.2216947201841468E-2},{"$f":"IFERROR(K71/($I$71+$J$71+$K$71),\"\")","v":6.7903898719608696E-2}]
[null,null,59,"Difference (Total Board -Overall workforce )","Auto calculated",{"$f":"IFERROR(F72-F77,\"\")","v":1.7781310796393446E-2},5.8657406438926418E-2,-7.6438717235319961E-2,8.3197768998373278E-2,-1.529387027876454E-2,-6.7903898719608696E-2]

{"sheet":"Validation and Data Checks","index":4,"n_rows":79,"n_cols":18,"rows_kept":79,"cut":false,"hidden":false,"merged":[[8,2,8,3],[12,8,12,10],[13,10,14,10],[13,11,14,11],[12,5,12,7],[13,5,14,5],[13,6,14,6],[13,7,14,7],[65,0,78,0],[13,9,14,9],[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,8,14,8],[16,0,52,0],[16,1,52,1],[13,0,14,1],[13,4,14,4]]}
[]
[]
[null,"SubmissionTemplate"]
[]
[null,"Workforce Race Equality Standards 2019/20 template"]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(F8>0,\"There are errors. Please ensure all questions are answered\",\"\")","v":""}]
[]
[]
[null,null,null,null,null,2019,null,null,2020]
["INDICATOR",null,null,null,"MEASURE","WHITE","BME","ETHNICITY UNKNOWN/NULL","WHITE","BME","ETHNICITY UNKNOWN/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,"Verified figures ","Verified figures ","Verified figures ","Verified figures ","Verified figures ","Verified figures "]
[null,null,1,"Under Band 1","Headcount",{"$f":"IF('Data for submission '!F17=\"\",\"No Data\",IF(LEN('Data for submission '!F17)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F17)=TRUE,\"Error\",IF(INT('Data for submission '!F17)<>'Data for submission '!F17,\"Error\",IF('Data for submission '!F17<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G17=\"\",\"No Data\",IF(LEN('Data for submission '!G17)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G17)=TRUE,\"Error\",IF(INT('Data for submission '!G17)<>'Data for submission '!G17,\"Error\",IF('Data for submission '!G17<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H17=\"\",\"No Data\",IF(LEN('Data for submission '!H17)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H17)=TRUE,\"Error\",IF(INT('Data for submission '!H17)<>'Data for submission '!H17,\"Error\",IF('Data for submission '!H17<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I17=\"\",\"No Data\",IF(LEN('Data for submission '!I17)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I17)=TRUE,\"Error\",IF(INT('Data for submission '!I17)<>'Data for submission '!I17,\"Error\",IF('Data for submission '!I17<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J17=\"\",\"No Data\",IF(LEN('Data for submission '!J17)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J17)=TRUE,\"Error\",IF(INT('Data for submission '!J17)<>'Data for submission '!J17,\"Error\",IF('Data for submission '!J17<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K17=\"\",\"No Data\",IF(LEN('Data for submission '!K17)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K17)=TRUE,\"Error\",IF(INT('Data for submission '!K17)<>'Data for submission '!K17,\"Error\",IF('Data for submission '!K17<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L17=\"\",\"\",IF(LEN('Data for submission '!L17)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"< Band 1 (i.e. Apprentices)","Non Clinical",null,"White"]
[null,null,2,"Band 1","Headcount",{"$f":"IF('Data for submission '!F18=\"\",\"No Data\",IF(LEN('Data for submission '!F18)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F18)=TRUE,\"Error\",IF(INT('Data for submission '!F18)<>'Data for submission '!F18,\"Error\",IF('Data for submission '!F18<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G18=\"\",\"No Data\",IF(LEN('Data for submission '!G18)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G18)=TRUE,\"Error\",IF(INT('Data for submission '!G18)<>'Data for submission '!G18,\"Error\",IF('Data for submission '!G18<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H18=\"\",\"No Data\",IF(LEN('Data for submission '!H18)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H18)=TRUE,\"Error\",IF(INT('Data for submission '!H18)<>'Data for submission '!H18,\"Error\",IF('Data for submission '!H18<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I18=\"\",\"No Data\",IF(LEN('Data for submission '!I18)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I18)=TRUE,\"Error\",IF(INT('Data for submission '!I18)<>'Data for submission '!I18,\"Error\",IF('Data for submission '!I18<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J18=\"\",\"No Data\",IF(LEN('Data for submission '!J18)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J18)=TRUE,\"Error\",IF(INT('Data for submission '!J18)<>'Data for submission '!J18,\"Error\",IF('Data for submission '!J18<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K18=\"\",\"No Data\",IF(LEN('Data for submission '!K18)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K18)=TRUE,\"Error\",IF(INT('Data for submission '!K18)<>'Data for submission '!K18,\"Error\",IF('Data for submission '!K18<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L18=\"\",\"\",IF(LEN('Data for submission '!L18)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 1","Non Clinical",null,"BME"]
[null,null,3,"Band 2","Headcount",{"$f":"IF('Data for submission '!F19=\"\",\"No Data\",IF(LEN('Data for submission '!F19)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F19)=TRUE,\"Error\",IF(INT('Data for submission '!F19)<>'Data for submission '!F19,\"Error\",IF('Data for submission '!F19<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G19=\"\",\"No Data\",IF(LEN('Data for submission '!G19)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G19)=TRUE,\"Error\",IF(INT('Data for submission '!G19)<>'Data for submission '!G19,\"Error\",IF('Data for submission '!G19<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H19=\"\",\"No Data\",IF(LEN('Data for submission '!H19)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H19)=TRUE,\"Error\",IF(INT('Data for submission '!H19)<>'Data for submission '!H19,\"Error\",IF('Data for submission '!H19<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I19=\"\",\"No Data\",IF(LEN('Data for submission '!I19)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I19)=TRUE,\"Error\",IF(INT('Data for submission '!I19)<>'Data for submission '!I19,\"Error\",IF('Data for submission '!I19<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J19=\"\",\"No Data\",IF(LEN('Data for submission '!J19)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J19)=TRUE,\"Error\",IF(INT('Data for submission '!J19)<>'Data for submission '!J19,\"Error\",IF('Data for submission '!J19<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K19=\"\",\"No Data\",IF(LEN('Data for submission '!K19)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K19)=TRUE,\"Error\",IF(INT('Data for submission '!K19)<>'Data for submission '!K19,\"Error\",IF('Data for submission '!K19<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L19=\"\",\"\",IF(LEN('Data for submission '!L19)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 2","Non Clinical",null,"Unknown/Null"]
[null,null,4,"Band 3","Headcount",{"$f":"IF('Data for submission '!F20=\"\",\"No Data\",IF(LEN('Data for submission '!F20)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F20)=TRUE,\"Error\",IF(INT('Data for submission '!F20)<>'Data for submission '!F20,\"Error\",IF('Data for submission '!F20<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G20=\"\",\"No Data\",IF(LEN('Data for submission '!G20)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G20)=TRUE,\"Error\",IF(INT('Data for submission '!G20)<>'Data for submission '!G20,\"Error\",IF('Data for submission '!G20<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H20=\"\",\"No Data\",IF(LEN('Data for submission '!H20)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H20)=TRUE,\"Error\",IF(INT('Data for submission '!H20)<>'Data for submission '!H20,\"Error\",IF('Data for submission '!H20<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I20=\"\",\"No Data\",IF(LEN('Data for submission '!I20)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I20)=TRUE,\"Error\",IF(INT('Data for submission '!I20)<>'Data for submission '!I20,\"Error\",IF('Data for submission '!I20<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J20=\"\",\"No Data\",IF(LEN('Data for submission '!J20)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J20)=TRUE,\"Error\",IF(INT('Data for submission '!J20)<>'Data for submission '!J20,\"Error\",IF('Data for submission '!J20<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K20=\"\",\"No Data\",IF(LEN('Data for submission '!K20)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K20)=TRUE,\"Error\",IF(INT('Data for submission '!K20)<>'Data for submission '!K20,\"Error\",IF('Data for submission '!K20<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L20=\"\",\"\",IF(LEN('Data for submission '!L20)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 3","Non Clinical"]
[null,null,5,"Band 4","Headcount",{"$f":"IF('Data for submission '!F21=\"\",\"No Data\",IF(LEN('Data for submission '!F21)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F21)=TRUE,\"Error\",IF(INT('Data for submission '!F21)<>'Data for submission '!F21,\"Error\",IF('Data for submission '!F21<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G21=\"\",\"No Data\",IF(LEN('Data for submission '!G21)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G21)=TRUE,\"Error\",IF(INT('Data for submission '!G21)<>'Data for submission '!G21,\"Error\",IF('Data for submission '!G21<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H21=\"\",\"No Data\",IF(LEN('Data for submission '!H21)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H21)=TRUE,\"Error\",IF(INT('Data for submission '!H21)<>'Data for submission '!H21,\"Error\",IF('Data for submission '!H21<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I21=\"\",\"No Data\",IF(LEN('Data for submission '!I21)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I21)=TRUE,\"Error\",IF(INT('Data for submission '!I21)<>'Data for submission '!I21,\"Error\",IF('Data for submission '!I21<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J21=\"\",\"No Data\",IF(LEN('Data for submission '!J21)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J21)=TRUE,\"Error\",IF(INT('Data for submission '!J21)<>'Data for submission '!J21,\"Error\",IF('Data for submission '!J21<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K21=\"\",\"No Data\",IF(LEN('Data for submission '!K21)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K21)=TRUE,\"Error\",IF(INT('Data for submission '!K21)<>'Data for submission '!K21,\"Error\",IF('Data for submission '!K21<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L21=\"\",\"\",IF(LEN('Data for submission '!L21)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 4","Non Clinical"]
[null,null,6,"Band 5","Headcount",{"$f":"IF('Data for submission '!F22=\"\",\"No Data\",IF(LEN('Data for submission '!F22)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F22)=TRUE,\"Error\",IF(INT('Data for submission '!F22)<>'Data for submission '!F22,\"Error\",IF('Data for submission '!F22<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G22=\"\",\"No Data\",IF(LEN('Data for submission '!G22)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G22)=TRUE,\"Error\",IF(INT('Data for submission '!G22)<>'Data for submission '!G22,\"Error\",IF('Data for submission '!G22<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H22=\"\",\"No Data\",IF(LEN('Data for submission '!H22)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H22)=TRUE,\"Error\",IF(INT('Data for submission '!H22)<>'Data for submission '!H22,\"Error\",IF('Data for submission '!H22<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I22=\"\",\"No Data\",IF(LEN('Data for submission '!I22)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I22)=TRUE,\"Error\",IF(INT('Data for submission '!I22)<>'Data for submission '!I22,\"Error\",IF('Data for submission '!I22<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J22=\"\",\"No Data\",IF(LEN('Data for submission '!J22)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J22)=TRUE,\"Error\",IF(INT('Data for submission '!J22)<>'Data for submission '!J22,\"Error\",IF('Data for submission '!J22<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K22=\"\",\"No Data\",IF(LEN('Data for submission '!K22)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K22)=TRUE,\"Error\",IF(INT('Data for submission '!K22)<>'Data for submission '!K22,\"Error\",IF('Data for submission '!K22<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L22=\"\",\"\",IF(LEN('Data for submission '!L22)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 5","Non Clinical"]
[null,null,7,"Band 6","Headcount",{"$f":"IF('Data for submission '!F23=\"\",\"No Data\",IF(LEN('Data for submission '!F23)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F23)=TRUE,\"Error\",IF(INT('Data for submission '!F23)<>'Data for submission '!F23,\"Error\",IF('Data for submission '!F23<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G23=\"\",\"No Data\",IF(LEN('Data for submission '!G23)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G23)=TRUE,\"Error\",IF(INT('Data for submission '!G23)<>'Data for submission '!G23,\"Error\",IF('Data for submission '!G23<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H23=\"\",\"No Data\",IF(LEN('Data for submission '!H23)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H23)=TRUE,\"Error\",IF(INT('Data for submission '!H23)<>'Data for submission '!H23,\"Error\",IF('Data for submission '!H23<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I23=\"\",\"No Data\",IF(LEN('Data for submission '!I23)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I23)=TRUE,\"Error\",IF(INT('Data for submission '!I23)<>'Data for submission '!I23,\"Error\",IF('Data for submission '!I23<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J23=\"\",\"No Data\",IF(LEN('Data for submission '!J23)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J23)=TRUE,\"Error\",IF(INT('Data for submission '!J23)<>'Data for submission '!J23,\"Error\",IF('Data for submission '!J23<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K23=\"\",\"No Data\",IF(LEN('Data for submission '!K23)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K23)=TRUE,\"Error\",IF(INT('Data for submission '!K23)<>'Data for submission '!K23,\"Error\",IF('Data for submission '!K23<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L23=\"\",\"\",IF(LEN('Data for submission '!L23)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 6","Non Clinical"]
[null,null,8,"Band 7","Headcount",{"$f":"IF('Data for submission '!F24=\"\",\"No Data\",IF(LEN('Data for submission '!F24)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F24)=TRUE,\"Error\",IF(INT('Data for submission '!F24)<>'Data for submission '!F24,\"Error\",IF('Data for submission '!F24<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G24=\"\",\"No Data\",IF(LEN('Data for submission '!G24)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G24)=TRUE,\"Error\",IF(INT('Data for submission '!G24)<>'Data for submission '!G24,\"Error\",IF('Data for submission '!G24<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H24=\"\",\"No Data\",IF(LEN('Data for submission '!H24)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H24)=TRUE,\"Error\",IF(INT('Data for submission '!H24)<>'Data for submission '!H24,\"Error\",IF('Data for submission '!H24<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I24=\"\",\"No Data\",IF(LEN('Data for submission '!I24)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I24)=TRUE,\"Error\",IF(INT('Data for submission '!I24)<>'Data for submission '!I24,\"Error\",IF('Data for submission '!I24<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J24=\"\",\"No Data\",IF(LEN('Data for submission '!J24)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J24)=TRUE,\"Error\",IF(INT('Data for submission '!J24)<>'Data for submission '!J24,\"Error\",IF('Data for submission '!J24<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K24=\"\",\"No Data\",IF(LEN('Data for submission '!K24)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K24)=TRUE,\"Error\",IF(INT('Data for submission '!K24)<>'Data for submission '!K24,\"Error\",IF('Data for submission '!K24<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L24=\"\",\"\",IF(LEN('Data for submission '!L24)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 7","Non Clinical"]
[null,null,9,"Band 8A","Headcount",{"$f":"IF('Data for submission '!F25=\"\",\"No Data\",IF(LEN('Data for submission '!F25)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F25)=TRUE,\"Error\",IF(INT('Data for submission '!F25)<>'Data for submission '!F25,\"Error\",IF('Data for submission '!F25<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G25=\"\",\"No Data\",IF(LEN('Data for submission '!G25)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G25)=TRUE,\"Error\",IF(INT('Data for submission '!G25)<>'Data for submission '!G25,\"Error\",IF('Data for submission '!G25<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H25=\"\",\"No Data\",IF(LEN('Data for submission '!H25)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H25)=TRUE,\"Error\",IF(INT('Data for submission '!H25)<>'Data for submission '!H25,\"Error\",IF('Data for submission '!H25<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I25=\"\",\"No Data\",IF(LEN('Data for submission '!I25)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I25)=TRUE,\"Error\",IF(INT('Data for submission '!I25)<>'Data for submission '!I25,\"Error\",IF('Data for submission '!I25<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J25=\"\",\"No Data\",IF(LEN('Data for submission '!J25)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J25)=TRUE,\"Error\",IF(INT('Data for submission '!J25)<>'Data for submission '!J25,\"Error\",IF('Data for submission '!J25<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K25=\"\",\"No Data\",IF(LEN('Data for submission '!K25)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K25)=TRUE,\"Error\",IF(INT('Data for submission '!K25)<>'Data for submission '!K25,\"Error\",IF('Data for submission '!K25<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L25=\"\",\"\",IF(LEN('Data for submission '!L25)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 8a","Non Clinical"]
[null,null,10,"Band 8B","Headcount",{"$f":"IF('Data for submission '!F26=\"\",\"No Data\",IF(LEN('Data for submission '!F26)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F26)=TRUE,\"Error\",IF(INT('Data for submission '!F26)<>'Data for submission '!F26,\"Error\",IF('Data for submission '!F26<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G26=\"\",\"No Data\",IF(LEN('Data for submission '!G26)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G26)=TRUE,\"Error\",IF(INT('Data for submission '!G26)<>'Data for submission '!G26,\"Error\",IF('Data for submission '!G26<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H26=\"\",\"No Data\",IF(LEN('Data for submission '!H26)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H26)=TRUE,\"Error\",IF(INT('Data for submission '!H26)<>'Data for submission '!H26,\"Error\",IF('Data for submission '!H26<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I26=\"\",\"No Data\",IF(LEN('Data for submission '!I26)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I26)=TRUE,\"Error\",IF(INT('Data for submission '!I26)<>'Data for submission '!I26,\"Error\",IF('Data for submission '!I26<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J26=\"\",\"No Data\",IF(LEN('Data for submission '!J26)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J26)=TRUE,\"Error\",IF(INT('Data for submission '!J26)<>'Data for submission '!J26,\"Error\",IF('Data for submission '!J26<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K26=\"\",\"No Data\",IF(LEN('Data for submission '!K26)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K26)=TRUE,\"Error\",IF(INT('Data for submission '!K26)<>'Data for submission '!K26,\"Error\",IF('Data for submission '!K26<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L26=\"\",\"\",IF(LEN('Data for submission '!L26)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 8b","Non Clinical"]
[null,null,11,"Band 8C","Headcount",{"$f":"IF('Data for submission '!F27=\"\",\"No Data\",IF(LEN('Data for submission '!F27)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F27)=TRUE,\"Error\",IF(INT('Data for submission '!F27)<>'Data for submission '!F27,\"Error\",IF('Data for submission '!F27<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G27=\"\",\"No Data\",IF(LEN('Data for submission '!G27)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G27)=TRUE,\"Error\",IF(INT('Data for submission '!G27)<>'Data for submission '!G27,\"Error\",IF('Data for submission '!G27<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H27=\"\",\"No Data\",IF(LEN('Data for submission '!H27)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H27)=TRUE,\"Error\",IF(INT('Data for submission '!H27)<>'Data for submission '!H27,\"Error\",IF('Data for submission '!H27<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I27=\"\",\"No Data\",IF(LEN('Data for submission '!I27)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I27)=TRUE,\"Error\",IF(INT('Data for submission '!I27)<>'Data for submission '!I27,\"Error\",IF('Data for submission '!I27<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J27=\"\",\"No Data\",IF(LEN('Data for submission '!J27)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J27)=TRUE,\"Error\",IF(INT('Data for submission '!J27)<>'Data for submission '!J27,\"Error\",IF('Data for submission '!J27<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K27=\"\",\"No Data\",IF(LEN('Data for submission '!K27)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K27)=TRUE,\"Error\",IF(INT('Data for submission '!K27)<>'Data for submission '!K27,\"Error\",IF('Data for submission '!K27<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L27=\"\",\"\",IF(LEN('Data for submission '!L27)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 8c","Non Clinical"]
[null,null,12,"Band 8D","Headcount",{"$f":"IF('Data for submission '!F28=\"\",\"No Data\",IF(LEN('Data for submission '!F28)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F28)=TRUE,\"Error\",IF(INT('Data for submission '!F28)<>'Data for submission '!F28,\"Error\",IF('Data for submission '!F28<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G28=\"\",\"No Data\",IF(LEN('Data for submission '!G28)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G28)=TRUE,\"Error\",IF(INT('Data for submission '!G28)<>'Data for submission '!G28,\"Error\",IF('Data for submission '!G28<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H28=\"\",\"No Data\",IF(LEN('Data for submission '!H28)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H28)=TRUE,\"Error\",IF(INT('Data for submission '!H28)<>'Data for submission '!H28,\"Error\",IF('Data for submission '!H28<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I28=\"\",\"No Data\",IF(LEN('Data for submission '!I28)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I28)=TRUE,\"Error\",IF(INT('Data for submission '!I28)<>'Data for submission '!I28,\"Error\",IF('Data for submission '!I28<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J28=\"\",\"No Data\",IF(LEN('Data for submission '!J28)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J28)=TRUE,\"Error\",IF(INT('Data for submission '!J28)<>'Data for submission '!J28,\"Error\",IF('Data for submission '!J28<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K28=\"\",\"No Data\",IF(LEN('Data for submission '!K28)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K28)=TRUE,\"Error\",IF(INT('Data for submission '!K28)<>'Data for submission '!K28,\"Error\",IF('Data for submission '!K28<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L28=\"\",\"\",IF(LEN('Data for submission '!L28)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 8d","Non Clinical"]
[null,null,13,"Band 9","Headcount",{"$f":"IF('Data for submission '!F29=\"\",\"No Data\",IF(LEN('Data for submission '!F29)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F29)=TRUE,\"Error\",IF(INT('Data for submission '!F29)<>'Data for submission '!F29,\"Error\",IF('Data for submission '!F29<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G29=\"\",\"No Data\",IF(LEN('Data for submission '!G29)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G29)=TRUE,\"Error\",IF(INT('Data for submission '!G29)<>'Data for submission '!G29,\"Error\",IF('Data for submission '!G29<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H29=\"\",\"No Data\",IF(LEN('Data for submission '!H29)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H29)=TRUE,\"Error\",IF(INT('Data for submission '!H29)<>'Data for submission '!H29,\"Error\",IF('Data for submission '!H29<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I29=\"\",\"No Data\",IF(LEN('Data for submission '!I29)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I29)=TRUE,\"Error\",IF(INT('Data for submission '!I29)<>'Data for submission '!I29,\"Error\",IF('Data for submission '!I29<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J29=\"\",\"No Data\",IF(LEN('Data for submission '!J29)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J29)=TRUE,\"Error\",IF(INT('Data for submission '!J29)<>'Data for submission '!J29,\"Error\",IF('Data for submission '!J29<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K29=\"\",\"No Data\",IF(LEN('Data for submission '!K29)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K29)=TRUE,\"Error\",IF(INT('Data for submission '!K29)<>'Data for submission '!K29,\"Error\",IF('Data for submission '!K29<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L29=\"\",\"\",IF(LEN('Data for submission '!L29)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 9","Non Clinical"]
[null,null,14,"VSM","Headcount",{"$f":"IF('Data for submission '!F30=\"\",\"No Data\",IF(LEN('Data for submission '!F30)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F30)=TRUE,\"Error\",IF(INT('Data for submission '!F30)<>'Data for submission '!F30,\"Error\",IF('Data for submission '!F30<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G30=\"\",\"No Data\",IF(LEN('Data for submission '!G30)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G30)=TRUE,\"Error\",IF(INT('Data for submission '!G30)<>'Data for submission '!G30,\"Error\",IF('Data for submission '!G30<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H30=\"\",\"No Data\",IF(LEN('Data for submission '!H30)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H30)=TRUE,\"Error\",IF(INT('Data for submission '!H30)<>'Data for submission '!H30,\"Error\",IF('Data for submission '!H30<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I30=\"\",\"No Data\",IF(LEN('Data for submission '!I30)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I30)=TRUE,\"Error\",IF(INT('Data for submission '!I30)<>'Data for submission '!I30,\"Error\",IF('Data for submission '!I30<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J30=\"\",\"No Data\",IF(LEN('Data for submission '!J30)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J30)=TRUE,\"Error\",IF(INT('Data for submission '!J30)<>'Data for submission '!J30,\"Error\",IF('Data for submission '!J30<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K30=\"\",\"No Data\",IF(LEN('Data for submission '!K30)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K30)=TRUE,\"Error\",IF(INT('Data for submission '!K30)<>'Data for submission '!K30,\"Error\",IF('Data for submission '!K30<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L30=\"\",\"\",IF(LEN('Data for submission '!L30)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"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(LEN('Data for submission '!F33)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F33)=TRUE,\"Error\",IF(INT('Data for submission '!F33)<>'Data for submission '!F33,\"Error\",IF('Data for submission '!F33<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G33=\"\",\"No Data\",IF(LEN('Data for submission '!G33)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G33)=TRUE,\"Error\",IF(INT('Data for submission '!G33)<>'Data for submission '!G33,\"Error\",IF('Data for submission '!G33<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H33=\"\",\"No Data\",IF(LEN('Data for submission '!H33)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H33)=TRUE,\"Error\",IF(INT('Data for submission '!H33)<>'Data for submission '!H33,\"Error\",IF('Data for submission '!H33<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I33=\"\",\"No Data\",IF(LEN('Data for submission '!I33)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I33)=TRUE,\"Error\",IF(INT('Data for submission '!I33)<>'Data for submission '!I33,\"Error\",IF('Data for submission '!I33<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J33=\"\",\"No Data\",IF(LEN('Data for submission '!J33)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J33)=TRUE,\"Error\",IF(INT('Data for submission '!J33)<>'Data for submission '!J33,\"Error\",IF('Data for submission '!J33<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K33=\"\",\"No Data\",IF(LEN('Data for submission '!K33)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K33)=TRUE,\"Error\",IF(INT('Data for submission '!K33)<>'Data for submission '!K33,\"Error\",IF('Data for submission '!K33<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L33=\"\",\"\",IF(LEN('Data for submission '!L33)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"< Band 1 (i.e. Apprentices)","Clinical"]
[null,null,16,"Band 1","Headcount",{"$f":"IF('Data for submission '!F34=\"\",\"No Data\",IF(LEN('Data for submission '!F34)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F34)=TRUE,\"Error\",IF(INT('Data for submission '!F34)<>'Data for submission '!F34,\"Error\",IF('Data for submission '!F34<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G34=\"\",\"No Data\",IF(LEN('Data for submission '!G34)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G34)=TRUE,\"Error\",IF(INT('Data for submission '!G34)<>'Data for submission '!G34,\"Error\",IF('Data for submission '!G34<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H34=\"\",\"No Data\",IF(LEN('Data for submission '!H34)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H34)=TRUE,\"Error\",IF(INT('Data for submission '!H34)<>'Data for submission '!H34,\"Error\",IF('Data for submission '!H34<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I34=\"\",\"No Data\",IF(LEN('Data for submission '!I34)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I34)=TRUE,\"Error\",IF(INT('Data for submission '!I34)<>'Data for submission '!I34,\"Error\",IF('Data for submission '!I34<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J34=\"\",\"No Data\",IF(LEN('Data for submission '!J34)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J34)=TRUE,\"Error\",IF(INT('Data for submission '!J34)<>'Data for submission '!J34,\"Error\",IF('Data for submission '!J34<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K34=\"\",\"No Data\",IF(LEN('Data for submission '!K34)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K34)=TRUE,\"Error\",IF(INT('Data for submission '!K34)<>'Data for submission '!K34,\"Error\",IF('Data for submission '!K34<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L34=\"\",\"\",IF(LEN('Data for submission '!L34)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 1","Clinical"]
[null,null,17,"Band 2","Headcount",{"$f":"IF('Data for submission '!F35=\"\",\"No Data\",IF(LEN('Data for submission '!F35)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F35)=TRUE,\"Error\",IF(INT('Data for submission '!F35)<>'Data for submission '!F35,\"Error\",IF('Data for submission '!F35<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G35=\"\",\"No Data\",IF(LEN('Data for submission '!G35)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G35)=TRUE,\"Error\",IF(INT('Data for submission '!G35)<>'Data for submission '!G35,\"Error\",IF('Data for submission '!G35<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H35=\"\",\"No Data\",IF(LEN('Data for submission '!H35)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H35)=TRUE,\"Error\",IF(INT('Data for submission '!H35)<>'Data for submission '!H35,\"Error\",IF('Data for submission '!H35<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I35=\"\",\"No Data\",IF(LEN('Data for submission '!I35)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I35)=TRUE,\"Error\",IF(INT('Data for submission '!I35)<>'Data for submission '!I35,\"Error\",IF('Data for submission '!I35<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J35=\"\",\"No Data\",IF(LEN('Data for submission '!J35)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J35)=TRUE,\"Error\",IF(INT('Data for submission '!J35)<>'Data for submission '!J35,\"Error\",IF('Data for submission '!J35<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K35=\"\",\"No Data\",IF(LEN('Data for submission '!K35)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K35)=TRUE,\"Error\",IF(INT('Data for submission '!K35)<>'Data for submission '!K35,\"Error\",IF('Data for submission '!K35<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L35=\"\",\"\",IF(LEN('Data for submission '!L35)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 2","Clinical"]
[null,null,18,"Band 3","Headcount",{"$f":"IF('Data for submission '!F36=\"\",\"No Data\",IF(LEN('Data for submission '!F36)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F36)=TRUE,\"Error\",IF(INT('Data for submission '!F36)<>'Data for submission '!F36,\"Error\",IF('Data for submission '!F36<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G36=\"\",\"No Data\",IF(LEN('Data for submission '!G36)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G36)=TRUE,\"Error\",IF(INT('Data for submission '!G36)<>'Data for submission '!G36,\"Error\",IF('Data for submission '!G36<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H36=\"\",\"No Data\",IF(LEN('Data for submission '!H36)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H36)=TRUE,\"Error\",IF(INT('Data for submission '!H36)<>'Data for submission '!H36,\"Error\",IF('Data for submission '!H36<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I36=\"\",\"No Data\",IF(LEN('Data for submission '!I36)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I36)=TRUE,\"Error\",IF(INT('Data for submission '!I36)<>'Data for submission '!I36,\"Error\",IF('Data for submission '!I36<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J36=\"\",\"No Data\",IF(LEN('Data for submission '!J36)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J36)=TRUE,\"Error\",IF(INT('Data for submission '!J36)<>'Data for submission '!J36,\"Error\",IF('Data for submission '!J36<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K36=\"\",\"No Data\",IF(LEN('Data for submission '!K36)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K36)=TRUE,\"Error\",IF(INT('Data for submission '!K36)<>'Data for submission '!K36,\"Error\",IF('Data for submission '!K36<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L36=\"\",\"\",IF(LEN('Data for submission '!L36)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 3","Clinical"]
[null,null,19,"Band 4","Headcount",{"$f":"IF('Data for submission '!F37=\"\",\"No Data\",IF(LEN('Data for submission '!F37)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F37)=TRUE,\"Error\",IF(INT('Data for submission '!F37)<>'Data for submission '!F37,\"Error\",IF('Data for submission '!F37<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G37=\"\",\"No Data\",IF(LEN('Data for submission '!G37)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G37)=TRUE,\"Error\",IF(INT('Data for submission '!G37)<>'Data for submission '!G37,\"Error\",IF('Data for submission '!G37<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H37=\"\",\"No Data\",IF(LEN('Data for submission '!H37)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H37)=TRUE,\"Error\",IF(INT('Data for submission '!H37)<>'Data for submission '!H37,\"Error\",IF('Data for submission '!H37<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I37=\"\",\"No Data\",IF(LEN('Data for submission '!I37)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I37)=TRUE,\"Error\",IF(INT('Data for submission '!I37)<>'Data for submission '!I37,\"Error\",IF('Data for submission '!I37<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J37=\"\",\"No Data\",IF(LEN('Data for submission '!J37)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J37)=TRUE,\"Error\",IF(INT('Data for submission '!J37)<>'Data for submission '!J37,\"Error\",IF('Data for submission '!J37<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K37=\"\",\"No Data\",IF(LEN('Data for submission '!K37)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K37)=TRUE,\"Error\",IF(INT('Data for submission '!K37)<>'Data for submission '!K37,\"Error\",IF('Data for submission '!K37<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L37=\"\",\"\",IF(LEN('Data for submission '!L37)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 4","Clinical"]
[null,null,20,"Band 5","Headcount",{"$f":"IF('Data for submission '!F38=\"\",\"No Data\",IF(LEN('Data for submission '!F38)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F38)=TRUE,\"Error\",IF(INT('Data for submission '!F38)<>'Data for submission '!F38,\"Error\",IF('Data for submission '!F38<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G38=\"\",\"No Data\",IF(LEN('Data for submission '!G38)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G38)=TRUE,\"Error\",IF(INT('Data for submission '!G38)<>'Data for submission '!G38,\"Error\",IF('Data for submission '!G38<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H38=\"\",\"No Data\",IF(LEN('Data for submission '!H38)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H38)=TRUE,\"Error\",IF(INT('Data for submission '!H38)<>'Data for submission '!H38,\"Error\",IF('Data for submission '!H38<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I38=\"\",\"No Data\",IF(LEN('Data for submission '!I38)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I38)=TRUE,\"Error\",IF(INT('Data for submission '!I38)<>'Data for submission '!I38,\"Error\",IF('Data for submission '!I38<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J38=\"\",\"No Data\",IF(LEN('Data for submission '!J38)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J38)=TRUE,\"Error\",IF(INT('Data for submission '!J38)<>'Data for submission '!J38,\"Error\",IF('Data for submission '!J38<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K38=\"\",\"No Data\",IF(LEN('Data for submission '!K38)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K38)=TRUE,\"Error\",IF(INT('Data for submission '!K38)<>'Data for submission '!K38,\"Error\",IF('Data for submission '!K38<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L38=\"\",\"\",IF(LEN('Data for submission '!L38)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 5","Clinical"]
[null,null,21,"Band 6","Headcount",{"$f":"IF('Data for submission '!F39=\"\",\"No Data\",IF(LEN('Data for submission '!F39)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F39)=TRUE,\"Error\",IF(INT('Data for submission '!F39)<>'Data for submission '!F39,\"Error\",IF('Data for submission '!F39<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G39=\"\",\"No Data\",IF(LEN('Data for submission '!G39)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G39)=TRUE,\"Error\",IF(INT('Data for submission '!G39)<>'Data for submission '!G39,\"Error\",IF('Data for submission '!G39<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H39=\"\",\"No Data\",IF(LEN('Data for submission '!H39)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H39)=TRUE,\"Error\",IF(INT('Data for submission '!H39)<>'Data for submission '!H39,\"Error\",IF('Data for submission '!H39<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I39=\"\",\"No Data\",IF(LEN('Data for submission '!I39)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I39)=TRUE,\"Error\",IF(INT('Data for submission '!I39)<>'Data for submission '!I39,\"Error\",IF('Data for submission '!I39<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J39=\"\",\"No Data\",IF(LEN('Data for submission '!J39)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J39)=TRUE,\"Error\",IF(INT('Data for submission '!J39)<>'Data for submission '!J39,\"Error\",IF('Data for submission '!J39<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K39=\"\",\"No Data\",IF(LEN('Data for submission '!K39)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K39)=TRUE,\"Error\",IF(INT('Data for submission '!K39)<>'Data for submission '!K39,\"Error\",IF('Data for submission '!K39<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L39=\"\",\"\",IF(LEN('Data for submission '!L39)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 6","Clinical"]
[null,null,22,"Band 7","Headcount",{"$f":"IF('Data for submission '!F40=\"\",\"No Data\",IF(LEN('Data for submission '!F40)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F40)=TRUE,\"Error\",IF(INT('Data for submission '!F40)<>'Data for submission '!F40,\"Error\",IF('Data for submission '!F40<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G40=\"\",\"No Data\",IF(LEN('Data for submission '!G40)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G40)=TRUE,\"Error\",IF(INT('Data for submission '!G40)<>'Data for submission '!G40,\"Error\",IF('Data for submission '!G40<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H40=\"\",\"No Data\",IF(LEN('Data for submission '!H40)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H40)=TRUE,\"Error\",IF(INT('Data for submission '!H40)<>'Data for submission '!H40,\"Error\",IF('Data for submission '!H40<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I40=\"\",\"No Data\",IF(LEN('Data for submission '!I40)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I40)=TRUE,\"Error\",IF(INT('Data for submission '!I40)<>'Data for submission '!I40,\"Error\",IF('Data for submission '!I40<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J40=\"\",\"No Data\",IF(LEN('Data for submission '!J40)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J40)=TRUE,\"Error\",IF(INT('Data for submission '!J40)<>'Data for submission '!J40,\"Error\",IF('Data for submission '!J40<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K40=\"\",\"No Data\",IF(LEN('Data for submission '!K40)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K40)=TRUE,\"Error\",IF(INT('Data for submission '!K40)<>'Data for submission '!K40,\"Error\",IF('Data for submission '!K40<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L40=\"\",\"\",IF(LEN('Data for submission '!L40)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 7","Clinical"]
[null,null,23,"Band 8A","Headcount",{"$f":"IF('Data for submission '!F41=\"\",\"No Data\",IF(LEN('Data for submission '!F41)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F41)=TRUE,\"Error\",IF(INT('Data for submission '!F41)<>'Data for submission '!F41,\"Error\",IF('Data for submission '!F41<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G41=\"\",\"No Data\",IF(LEN('Data for submission '!G41)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G41)=TRUE,\"Error\",IF(INT('Data for submission '!G41)<>'Data for submission '!G41,\"Error\",IF('Data for submission '!G41<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H41=\"\",\"No Data\",IF(LEN('Data for submission '!H41)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H41)=TRUE,\"Error\",IF(INT('Data for submission '!H41)<>'Data for submission '!H41,\"Error\",IF('Data for submission '!H41<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I41=\"\",\"No Data\",IF(LEN('Data for submission '!I41)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I41)=TRUE,\"Error\",IF(INT('Data for submission '!I41)<>'Data for submission '!I41,\"Error\",IF('Data for submission '!I41<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J41=\"\",\"No Data\",IF(LEN('Data for submission '!J41)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J41)=TRUE,\"Error\",IF(INT('Data for submission '!J41)<>'Data for submission '!J41,\"Error\",IF('Data for submission '!J41<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K41=\"\",\"No Data\",IF(LEN('Data for submission '!K41)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K41)=TRUE,\"Error\",IF(INT('Data for submission '!K41)<>'Data for submission '!K41,\"Error\",IF('Data for submission '!K41<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L41=\"\",\"\",IF(LEN('Data for submission '!L41)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 8a","Clinical"]
[null,null,24,"Band 8B","Headcount",{"$f":"IF('Data for submission '!F42=\"\",\"No Data\",IF(LEN('Data for submission '!F42)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F42)=TRUE,\"Error\",IF(INT('Data for submission '!F42)<>'Data for submission '!F42,\"Error\",IF('Data for submission '!F42<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G42=\"\",\"No Data\",IF(LEN('Data for submission '!G42)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G42)=TRUE,\"Error\",IF(INT('Data for submission '!G42)<>'Data for submission '!G42,\"Error\",IF('Data for submission '!G42<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H42=\"\",\"No Data\",IF(LEN('Data for submission '!H42)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H42)=TRUE,\"Error\",IF(INT('Data for submission '!H42)<>'Data for submission '!H42,\"Error\",IF('Data for submission '!H42<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I42=\"\",\"No Data\",IF(LEN('Data for submission '!I42)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I42)=TRUE,\"Error\",IF(INT('Data for submission '!I42)<>'Data for submission '!I42,\"Error\",IF('Data for submission '!I42<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J42=\"\",\"No Data\",IF(LEN('Data for submission '!J42)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J42)=TRUE,\"Error\",IF(INT('Data for submission '!J42)<>'Data for submission '!J42,\"Error\",IF('Data for submission '!J42<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K42=\"\",\"No Data\",IF(LEN('Data for submission '!K42)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K42)=TRUE,\"Error\",IF(INT('Data for submission '!K42)<>'Data for submission '!K42,\"Error\",IF('Data for submission '!K42<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L42=\"\",\"\",IF(LEN('Data for submission '!L42)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 8b","Clinical"]
[null,null,25,"Band 8C","Headcount",{"$f":"IF('Data for submission '!F43=\"\",\"No Data\",IF(LEN('Data for submission '!F43)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F43)=TRUE,\"Error\",IF(INT('Data for submission '!F43)<>'Data for submission '!F43,\"Error\",IF('Data for submission '!F43<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G43=\"\",\"No Data\",IF(LEN('Data for submission '!G43)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G43)=TRUE,\"Error\",IF(INT('Data for submission '!G43)<>'Data for submission '!G43,\"Error\",IF('Data for submission '!G43<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H43=\"\",\"No Data\",IF(LEN('Data for submission '!H43)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H43)=TRUE,\"Error\",IF(INT('Data for submission '!H43)<>'Data for submission '!H43,\"Error\",IF('Data for submission '!H43<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I43=\"\",\"No Data\",IF(LEN('Data for submission '!I43)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I43)=TRUE,\"Error\",IF(INT('Data for submission '!I43)<>'Data for submission '!I43,\"Error\",IF('Data for submission '!I43<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J43=\"\",\"No Data\",IF(LEN('Data for submission '!J43)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J43)=TRUE,\"Error\",IF(INT('Data for submission '!J43)<>'Data for submission '!J43,\"Error\",IF('Data for submission '!J43<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K43=\"\",\"No Data\",IF(LEN('Data for submission '!K43)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K43)=TRUE,\"Error\",IF(INT('Data for submission '!K43)<>'Data for submission '!K43,\"Error\",IF('Data for submission '!K43<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L43=\"\",\"\",IF(LEN('Data for submission '!L43)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 8c","Clinical"]
[null,null,26,"Band 8D","Headcount",{"$f":"IF('Data for submission '!F44=\"\",\"No Data\",IF(LEN('Data for submission '!F44)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F44)=TRUE,\"Error\",IF(INT('Data for submission '!F44)<>'Data for submission '!F44,\"Error\",IF('Data for submission '!F44<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G44=\"\",\"No Data\",IF(LEN('Data for submission '!G44)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G44)=TRUE,\"Error\",IF(INT('Data for submission '!G44)<>'Data for submission '!G44,\"Error\",IF('Data for submission '!G44<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H44=\"\",\"No Data\",IF(LEN('Data for submission '!H44)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H44)=TRUE,\"Error\",IF(INT('Data for submission '!H44)<>'Data for submission '!H44,\"Error\",IF('Data for submission '!H44<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I44=\"\",\"No Data\",IF(LEN('Data for submission '!I44)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I44)=TRUE,\"Error\",IF(INT('Data for submission '!I44)<>'Data for submission '!I44,\"Error\",IF('Data for submission '!I44<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J44=\"\",\"No Data\",IF(LEN('Data for submission '!J44)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J44)=TRUE,\"Error\",IF(INT('Data for submission '!J44)<>'Data for submission '!J44,\"Error\",IF('Data for submission '!J44<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K44=\"\",\"No Data\",IF(LEN('Data for submission '!K44)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K44)=TRUE,\"Error\",IF(INT('Data for submission '!K44)<>'Data for submission '!K44,\"Error\",IF('Data for submission '!K44<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L44=\"\",\"\",IF(LEN('Data for submission '!L44)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 8d","Clinical"]
[null,null,27,"Band 9","Headcount",{"$f":"IF('Data for submission '!F45=\"\",\"No Data\",IF(LEN('Data for submission '!F45)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F45)=TRUE,\"Error\",IF(INT('Data for submission '!F45)<>'Data for submission '!F45,\"Error\",IF('Data for submission '!F45<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G45=\"\",\"No Data\",IF(LEN('Data for submission '!G45)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G45)=TRUE,\"Error\",IF(INT('Data for submission '!G45)<>'Data for submission '!G45,\"Error\",IF('Data for submission '!G45<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H45=\"\",\"No Data\",IF(LEN('Data for submission '!H45)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H45)=TRUE,\"Error\",IF(INT('Data for submission '!H45)<>'Data for submission '!H45,\"Error\",IF('Data for submission '!H45<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I45=\"\",\"No Data\",IF(LEN('Data for submission '!I45)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I45)=TRUE,\"Error\",IF(INT('Data for submission '!I45)<>'Data for submission '!I45,\"Error\",IF('Data for submission '!I45<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J45=\"\",\"No Data\",IF(LEN('Data for submission '!J45)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J45)=TRUE,\"Error\",IF(INT('Data for submission '!J45)<>'Data for submission '!J45,\"Error\",IF('Data for submission '!J45<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K45=\"\",\"No Data\",IF(LEN('Data for submission '!K45)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K45)=TRUE,\"Error\",IF(INT('Data for submission '!K45)<>'Data for submission '!K45,\"Error\",IF('Data for submission '!K45<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L45=\"\",\"\",IF(LEN('Data for submission '!L45)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Band 9","Clinical"]
[null,null,28,"VSM","Headcount",{"$f":"IF('Data for submission '!F46=\"\",\"No Data\",IF(LEN('Data for submission '!F46)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F46)=TRUE,\"Error\",IF(INT('Data for submission '!F46)<>'Data for submission '!F46,\"Error\",IF('Data for submission '!F46<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G46=\"\",\"No Data\",IF(LEN('Data for submission '!G46)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G46)=TRUE,\"Error\",IF(INT('Data for submission '!G46)<>'Data for submission '!G46,\"Error\",IF('Data for submission '!G46<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H46=\"\",\"No Data\",IF(LEN('Data for submission '!H46)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H46)=TRUE,\"Error\",IF(INT('Data for submission '!H46)<>'Data for submission '!H46,\"Error\",IF('Data for submission '!H46<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I46=\"\",\"No Data\",IF(LEN('Data for submission '!I46)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I46)=TRUE,\"Error\",IF(INT('Data for submission '!I46)<>'Data for submission '!I46,\"Error\",IF('Data for submission '!I46<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J46=\"\",\"No Data\",IF(LEN('Data for submission '!J46)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J46)=TRUE,\"Error\",IF(INT('Data for submission '!J46)<>'Data for submission '!J46,\"Error\",IF('Data for submission '!J46<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K46=\"\",\"No Data\",IF(LEN('Data for submission '!K46)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K46)=TRUE,\"Error\",IF(INT('Data for submission '!K46)<>'Data for submission '!K46,\"Error\",IF('Data for submission '!K46<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L46=\"\",\"\",IF(LEN('Data for submission '!L46)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"VSM","Clinical"]
[null,null,null,"Of which Medical & Dental"]
[null,null,29,"Consultants","Headcount",{"$f":"IF('Data for submission '!F48=\"\",\"No Data\",IF(LEN('Data for submission '!F48)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F48)=TRUE,\"Error\",IF(INT('Data for submission '!F48)<>'Data for submission '!F48,\"Error\",IF('Data for submission '!F48<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G48=\"\",\"No Data\",IF(LEN('Data for submission '!G48)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G48)=TRUE,\"Error\",IF(INT('Data for submission '!G48)<>'Data for submission '!G48,\"Error\",IF('Data for submission '!G48<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H48=\"\",\"No Data\",IF(LEN('Data for submission '!H48)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H48)=TRUE,\"Error\",IF(INT('Data for submission '!H48)<>'Data for submission '!H48,\"Error\",IF('Data for submission '!H48<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I48=\"\",\"No Data\",IF(LEN('Data for submission '!I48)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I48)=TRUE,\"Error\",IF(INT('Data for submission '!I48)<>'Data for submission '!I48,\"Error\",IF('Data for submission '!I48<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J48=\"\",\"No Data\",IF(LEN('Data for submission '!J48)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J48)=TRUE,\"Error\",IF(INT('Data for submission '!J48)<>'Data for submission '!J48,\"Error\",IF('Data for submission '!J48<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K48=\"\",\"No Data\",IF(LEN('Data for submission '!K48)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K48)=TRUE,\"Error\",IF(INT('Data for submission '!K48)<>'Data for submission '!K48,\"Error\",IF('Data for submission '!K48<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L48=\"\",\"\",IF(LEN('Data for submission '!L48)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Medical & Dental Consultant","Clinical"]
[null,null,30,"  of which Senior medical manager","Headcount",null,null,null,null,null,null,{"$f":"IF('Data for submission '!L49=\"\",\"\",IF(LEN('Data for submission '!L49)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[null,null,31,"Non-consultant career grade","Headcount",{"$f":"IF('Data for submission '!F50=\"\",\"No Data\",IF(LEN('Data for submission '!F50)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F50)=TRUE,\"Error\",IF(INT('Data for submission '!F50)<>'Data for submission '!F50,\"Error\",IF('Data for submission '!F50<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G50=\"\",\"No Data\",IF(LEN('Data for submission '!G50)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G50)=TRUE,\"Error\",IF(INT('Data for submission '!G50)<>'Data for submission '!G50,\"Error\",IF('Data for submission '!G50<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H50=\"\",\"No Data\",IF(LEN('Data for submission '!H50)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H50)=TRUE,\"Error\",IF(INT('Data for submission '!H50)<>'Data for submission '!H50,\"Error\",IF('Data for submission '!H50<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I50=\"\",\"No Data\",IF(LEN('Data for submission '!I50)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I50)=TRUE,\"Error\",IF(INT('Data for submission '!I50)<>'Data for submission '!I50,\"Error\",IF('Data for submission '!I50<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J50=\"\",\"No Data\",IF(LEN('Data for submission '!J50)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J50)=TRUE,\"Error\",IF(INT('Data for submission '!J50)<>'Data for submission '!J50,\"Error\",IF('Data for submission '!J50<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K50=\"\",\"No Data\",IF(LEN('Data for submission '!K50)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K50)=TRUE,\"Error\",IF(INT('Data for submission '!K50)<>'Data for submission '!K50,\"Error\",IF('Data for submission '!K50<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L50=\"\",\"\",IF(LEN('Data for submission '!L50)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Medical & Dental Non-consultant career grade","Clinical"]
[null,null,32,"Trainee grades","Headcount",{"$f":"IF('Data for submission '!F51=\"\",\"No Data\",IF(LEN('Data for submission '!F51)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F51)=TRUE,\"Error\",IF(INT('Data for submission '!F51)<>'Data for submission '!F51,\"Error\",IF('Data for submission '!F51<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G51=\"\",\"No Data\",IF(LEN('Data for submission '!G51)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G51)=TRUE,\"Error\",IF(INT('Data for submission '!G51)<>'Data for submission '!G51,\"Error\",IF('Data for submission '!G51<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H51=\"\",\"No Data\",IF(LEN('Data for submission '!H51)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H51)=TRUE,\"Error\",IF(INT('Data for submission '!H51)<>'Data for submission '!H51,\"Error\",IF('Data for submission '!H51<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I51=\"\",\"No Data\",IF(LEN('Data for submission '!I51)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I51)=TRUE,\"Error\",IF(INT('Data for submission '!I51)<>'Data for submission '!I51,\"Error\",IF('Data for submission '!I51<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J51=\"\",\"No Data\",IF(LEN('Data for submission '!J51)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J51)=TRUE,\"Error\",IF(INT('Data for submission '!J51)<>'Data for submission '!J51,\"Error\",IF('Data for submission '!J51<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K51=\"\",\"No Data\",IF(LEN('Data for submission '!K51)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K51)=TRUE,\"Error\",IF(INT('Data for submission '!K51)<>'Data for submission '!K51,\"Error\",IF('Data for submission '!K51<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L51=\"\",\"\",IF(LEN('Data for submission '!L51)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Medical & Dental Trainee grades","Clinical"]
[null,null,33,"Other","Headcount",{"$f":"IF('Data for submission '!F52=\"\",\"No Data\",IF(LEN('Data for submission '!F52)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!F52)=TRUE,\"Error\",IF(INT('Data for submission '!F52)<>'Data for submission '!F52,\"Error\",IF('Data for submission '!F52<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G52=\"\",\"No Data\",IF(LEN('Data for submission '!G52)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!G52)=TRUE,\"Error\",IF(INT('Data for submission '!G52)<>'Data for submission '!G52,\"Error\",IF('Data for submission '!G52<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H52=\"\",\"No Data\",IF(LEN('Data for submission '!H52)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!H52)=TRUE,\"Error\",IF(INT('Data for submission '!H52)<>'Data for submission '!H52,\"Error\",IF('Data for submission '!H52<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I52=\"\",\"No Data\",IF(LEN('Data for submission '!I52)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!I52)=TRUE,\"Error\",IF(INT('Data for submission '!I52)<>'Data for submission '!I52,\"Error\",IF('Data for submission '!I52<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J52=\"\",\"No Data\",IF(LEN('Data for submission '!J52)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!J52)=TRUE,\"Error\",IF(INT('Data for submission '!J52)<>'Data for submission '!J52,\"Error\",IF('Data for submission '!J52<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K52=\"\",\"No Data\",IF(LEN('Data for submission '!K52)>255,\"Error you have exceeded the character limit\",IF(ISTEXT('Data for submission '!K52)=TRUE,\"Error\",IF(INT('Data for submission '!K52)<>'Data for submission '!K52,\"Error\",IF('Data for submission '!K52<0,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L52=\"\",\"\",IF(LEN('Data for submission '!L52)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},"Medical & Dental Other","Clinical"]
[2,"Relative likelihood of staff being appointed from shortlisting across all posts\n",34,"Number of shortlisted applicants:","Headcount",{"$f":"IF('Data for submission '!F53=\"\",\"No Data\",IF(INT('Data for submission '!F53)<>'Data for submission '!F53,\"Error\",IF('Data for submission '!F53<'Data for submission '!F54,\"Error\",IF('Data for submission '!F53<0,\"Error\",IF(ISTEXT('Data for submission '!F53)=TRUE,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G53=\"\",\"No Data\",IF(LEN('Data for submission '!G53)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!G53)<>'Data for submission '!G53,\"Error\",IF('Data for submission '!G53<'Data for submission '!G54,\"Error\",IF('Data for submission '!G53<0,\"Error\",IF(ISTEXT('Data for submission '!G53)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!H53=\"\",\"No Data\",IF(LEN('Data for submission '!H53)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!H53)<>'Data for submission '!H53,\"Error\",IF('Data for submission '!H53<'Data for submission '!H54,\"Error\",IF('Data for submission '!H53<0,\"Error\",IF(ISTEXT('Data for submission '!H53)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!I53=\"\",\"No Data\",IF(LEN('Data for submission '!I53)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!I53)<>'Data for submission '!I53,\"Error\",IF('Data for submission '!I53<'Data for submission '!I54,\"Error\",IF('Data for submission '!I53<0,\"Error\",IF(ISTEXT('Data for submission '!I53)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!J53=\"\",\"No Data\",IF(LEN('Data for submission '!J53)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!J53)<>'Data for submission '!J53,\"Error\",IF('Data for submission '!J53<'Data for submission '!J54,\"Error\",IF('Data for submission '!J53<0,\"Error\",IF(ISTEXT('Data for submission '!J53)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!K53=\"\",\"No Data\",IF(LEN('Data for submission '!K53)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!K53)<>'Data for submission '!K53,\"Error\",IF('Data for submission '!K53<'Data for submission '!K54,\"Error\",IF('Data for submission '!K53<0,\"Error\",IF(ISTEXT('Data for submission '!K53)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!L53=\"\",\"\",IF(LEN('Data for submission '!L53)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},null,null,null,null,2.5522925244872678,0.55591665613817309]
[null,null,35,"Number appointed from shortlisting:","Headcount",{"$f":"IF('Data for submission '!F54=\"\",\"No Data\",IF(INT('Data for submission '!F54)<>'Data for submission '!F54,\"Error\",IF('Data for submission '!F54>'Data for submission '!F53,\"Error\",IF('Data for submission '!F54<0,\"Error\",IF(ISTEXT('Data for submission '!F54)=TRUE,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G54=\"\",\"No Data\",IF(LEN('Data for submission '!G54)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!G54)<>'Data for submission '!G54,\"Error\",IF('Data for submission '!G54>'Data for submission '!G53,\"Error\",IF('Data for submission '!G54<0,\"Error\",IF(ISTEXT('Data for submission '!G54)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!H54=\"\",\"No Data\",IF(LEN('Data for submission '!H54)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!H54)<>'Data for submission '!H54,\"Error\",IF('Data for submission '!H54>'Data for submission '!H53,\"Error\",IF('Data for submission '!H54<0,\"Error\",IF(ISTEXT('Data for submission '!H54)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!I54=\"\",\"No Data\",IF(LEN('Data for submission '!I54)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!I54)<>'Data for submission '!I54,\"Error\",IF('Data for submission '!I54>'Data for submission '!I53,\"Error\",IF('Data for submission '!I54<0,\"Error\",IF(ISTEXT('Data for submission '!I54)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!J54=\"\",\"No Data\",IF(LEN('Data for submission '!J54)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!J54)<>'Data for submission '!J54,\"Error\",IF('Data for submission '!J54>'Data for submission '!J53,\"Error\",IF('Data for submission '!J54<0,\"Error\",IF(ISTEXT('Data for submission '!J54)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!K54=\"\",\"No Data\",IF(LEN('Data for submission '!K54)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!K54)<>'Data for submission '!K54,\"Error\",IF('Data for submission '!K54>'Data for submission '!K53,\"Error\",IF('Data for submission '!K54<0,\"Error\",IF(ISTEXT('Data for submission '!K54)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!L54=\"\",\"\",IF(LEN('Data for submission '!L54)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[null,null,36,"Relative likelihood of shortlisting/appointed:","Auto calculated",{"$f":"IFERROR(F55/F54,\"\")","v":""},null,null,{"$f":"IFERROR(I55/I54,\"\")","v":""},{"$f":"IFERROR(J55/J54,\"\")","v":""}]
[null,null,37,"Relative likelihood of White staff being appointed from shortlisting compared to BME staff:","Auto calculated",null,null,null,{"$f":"IFERROR(I56/J56,\"\")","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",{"$f":"IF('Data for submission '!F57=\"\",\"No Data\",IF(LEN('Data for submission '!F57)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!F57)<>'Data for submission '!F57,\"Error\",IF('Data for submission '!F57<'Data for submission '!F58,\"Error\",IF('Data for submission '!F57<0,\"Error\",IF(ISTEXT('Data for submission '!F57)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!G57=\"\",\"No Data\",IF(LEN('Data for submission '!G57)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!G57)<>'Data for submission '!G57,\"Error\",IF('Data for submission '!G57<'Data for submission '!G58,\"Error\",IF('Data for submission '!G57<0,\"Error\",IF(ISTEXT('Data for submission '!G57)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!H57=\"\",\"No Data\",IF(LEN('Data for submission '!H57)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!H57)<>'Data for submission '!H57,\"Error\",IF('Data for submission '!H57<'Data for submission '!H58,\"Error\",IF('Data for submission '!H57<0,\"Error\",IF(ISTEXT('Data for submission '!H57)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!I57=\"\",\"No Data\",IF(LEN('Data for submission '!I57)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!I57)<>'Data for submission '!I57,\"Error\",IF('Data for submission '!I57<'Data for submission '!I58,\"Error\",IF('Data for submission '!I57<0,\"Error\",IF(ISTEXT('Data for submission '!I57)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!J57=\"\",\"No Data\",IF(LEN('Data for submission '!J57)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!J57)<>'Data for submission '!J57,\"Error\",IF('Data for submission '!J57<'Data for submission '!J58,\"Error\",IF('Data for submission '!J57<0,\"Error\",IF(ISTEXT('Data for submission '!J57)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!K57=\"\",\"No Data\",IF(LEN('Data for submission '!K57)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!K57)<>'Data for submission '!K57,\"Error\",IF('Data for submission '!K57<'Data for submission '!K58,\"Error\",IF('Data for submission '!K57<0,\"Error\",IF(ISTEXT('Data for submission '!K57)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!L57=\"\",\"\",IF(LEN('Data for submission '!L57)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},null,null,null,null,4.3158680043516524,0]
[null,null,39,"Number of staff entering the formal disciplinary process:","Headcount",{"$f":"IF('Data for submission '!F58=\"\",\"No Data\",IF(LEN('Data for submission '!F58)>255,\"Error you have exceeded the character limit\",IF('Data for submission '!F58>'Data for submission '!F57,\"Error\",IF('Data for submission '!F58<0,\"Error\",IF(ISTEXT('Data for submission '!F58)=TRUE,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!G58=\"\",\"No Data\",IF(LEN('Data for submission '!G58)>255,\"Error you have exceeded the character limit\",IF('Data for submission '!G58>'Data for submission '!G57,\"Error\",IF('Data for submission '!G58<0,\"Error\",IF(ISTEXT('Data for submission '!G58)=TRUE,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!H58=\"\",\"No Data\",IF(LEN('Data for submission '!H58)>255,\"Error you have exceeded the character limit\",IF('Data for submission '!H58>'Data for submission '!H57,\"Error\",IF('Data for submission '!H58<0,\"Error\",IF(ISTEXT('Data for submission '!H58)=TRUE,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!I58=\"\",\"No Data\",IF(LEN('Data for submission '!I58)>255,\"Error you have exceeded the character limit\",IF('Data for submission '!I58>'Data for submission '!I57,\"Error\",IF('Data for submission '!I58<0,\"Error\",IF(ISTEXT('Data for submission '!I58)=TRUE,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!J58=\"\",\"No Data\",IF(LEN('Data for submission '!J58)>255,\"Error you have exceeded the character limit\",IF('Data for submission '!J58>'Data for submission '!J57,\"Error\",IF('Data for submission '!J58<0,\"Error\",IF(ISTEXT('Data for submission '!J58)=TRUE,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!K58=\"\",\"No Data\",IF(LEN('Data for submission '!K58)>255,\"Error you have exceeded the character limit\",IF('Data for submission '!K58>'Data for submission '!K57,\"Error\",IF('Data for submission '!K58<0,\"Error\",IF(ISTEXT('Data for submission '!K58)=TRUE,\"Error\",\"OK\")))))","v":"OK"},{"$f":"IF('Data for submission '!L58=\"\",\"\",IF(LEN('Data for submission '!L58)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[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,{"$f":"IFERROR(J60/I60,\"\")","v":""}]
[4,"Relative likelihood of staff accessing non-mandatory training and CPD",42,"Number of staff in workforce:","Headcount",{"$f":"IF('Data for submission '!F61=\"\",\"No Data\",IF(LEN('Data for submission '!F61)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!F61)<>'Data for submission '!F61,\"Error\",IF('Data for submission '!F61<'Data for submission '!F62,\"Error\",IF('Data for submission '!F61<0,\"Error\",IF(ISTEXT('Data for submission '!F61)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!G61=\"\",\"No Data\",IF(LEN('Data for submission '!G61)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!G61)<>'Data for submission '!G61,\"Error\",IF('Data for submission '!G61<'Data for submission '!G62,\"Error\",IF('Data for submission '!G61<0,\"Error\",IF(ISTEXT('Data for submission '!G61)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!H61=\"\",\"No Data\",IF(LEN('Data for submission '!H61)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!H61)<>'Data for submission '!H61,\"Error\",IF('Data for submission '!H61<'Data for submission '!H62,\"Error\",IF('Data for submission '!H61<0,\"Error\",IF(ISTEXT('Data for submission '!H61)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!I61=\"\",\"No Data\",IF(LEN('Data for submission '!I61)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!I61)<>'Data for submission '!I61,\"Error\",IF('Data for submission '!I61<'Data for submission '!I62,\"Error\",IF('Data for submission '!I61<0,\"Error\",IF(ISTEXT('Data for submission '!I61)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!J61=\"\",\"No Data\",IF(LEN('Data for submission '!J61)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!J61)<>'Data for submission '!J61,\"Error\",IF('Data for submission '!J61<'Data for submission '!J62,\"Error\",IF('Data for submission '!J61<0,\"Error\",IF(ISTEXT('Data for submission '!J61)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!K61=\"\",\"No Data\",IF(LEN('Data for submission '!K61)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!K61)<>'Data for submission '!K61,\"Error\",IF('Data for submission '!K61<'Data for submission '!K62,\"Error\",IF('Data for submission '!K61<0,\"Error\",IF(ISTEXT('Data for submission '!K61)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!L61=\"\",\"\",IF(LEN('Data for submission '!L61)>255,\"Error you have exceeded the character limit\",\"\"))","v":""},null,null,null,null,2.0521583133406875,0.10298981852318034]
[null,null,43,"Number of staff accessing non-mandatory training and CPD: ","Headcount",{"$f":"IF('Data for submission '!F62=\"\",\"No Data\",IF(LEN('Data for submission '!F62)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!F62)<>'Data for submission '!F62,\"Error\",IF('Data for submission '!F62>'Data for submission '!F61,\"Error\",IF('Data for submission '!F62<0,\"Error\",IF(ISTEXT('Data for submission '!F62)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!G62=\"\",\"No Data\",IF(LEN('Data for submission '!G62)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!G62)<>'Data for submission '!G62,\"Error\",IF('Data for submission '!G62>'Data for submission '!G61,\"Error\",IF('Data for submission '!G62<0,\"Error\",IF(ISTEXT('Data for submission '!G62)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!H62=\"\",\"No Data\",IF(LEN('Data for submission '!H62)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!H62)<>'Data for submission '!H62,\"Error\",IF('Data for submission '!H62>'Data for submission '!H61,\"Error\",IF('Data for submission '!H62<0,\"Error\",IF(ISTEXT('Data for submission '!H62)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!I62=\"\",\"No Data\",IF(LEN('Data for submission '!I62)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!I62)<>'Data for submission '!I62,\"Error\",IF('Data for submission '!I62>'Data for submission '!I61,\"Error\",IF('Data for submission '!I62<0,\"Error\",IF(ISTEXT('Data for submission '!I62)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!J62=\"\",\"No Data\",IF(LEN('Data for submission '!J62)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!J62)<>'Data for submission '!J62,\"Error\",IF('Data for submission '!J62>'Data for submission '!J61,\"Error\",IF('Data for submission '!J62<0,\"Error\",IF(ISTEXT('Data for submission '!J62)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!K62=\"\",\"No Data\",IF(LEN('Data for submission '!K62)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!K62)<>'Data for submission '!K62,\"Error\",IF('Data for submission '!K62>'Data for submission '!K61,\"Error\",IF('Data for submission '!K62<0,\"Error\",IF(ISTEXT('Data for submission '!K62)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!L62=\"\",\"\",IF(LEN('Data for submission '!L62)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[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"]
[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",46,"Total Board members","Headcount",{"$f":"IF('Data for submission '!F65=\"\",\"No Data\",IF(LEN('Data for submission '!F65)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!F65)<>'Data for submission '!F65,\"Error\",IF('Data for submission '!F65<'Data for submission '!F66,\"Error\",IF('Data for submission '!F65<0,\"Error\",IF(ISTEXT('Data for submission '!F65)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!G65=\"\",\"No Data\",IF(LEN('Data for submission '!G65)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!G65)<>'Data for submission '!G65,\"Error\",IF('Data for submission '!G65<'Data for submission '!G66,\"Error\",IF('Data for submission '!G65<0,\"Error\",IF(ISTEXT('Data for submission '!G65)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!H65=\"\",\"No Data\",IF(LEN('Data for submission '!H65)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!H65)<>'Data for submission '!H65,\"Error\",IF('Data for submission '!H65<'Data for submission '!H66,\"Error\",IF('Data for submission '!H65<0,\"Error\",IF(ISTEXT('Data for submission '!H65)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!I65=\"\",\"No Data\",IF(LEN('Data for submission '!I65)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!I65)<>'Data for submission '!I65,\"Error\",IF('Data for submission '!I65<'Data for submission '!I66,\"Error\",IF('Data for submission '!I65<0,\"Error\",IF(ISTEXT('Data for submission '!I65)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!J65=\"\",\"No Data\",IF(LEN('Data for submission '!J65)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!J65)<>'Data for submission '!J65,\"Error\",IF('Data for submission '!J65<'Data for submission '!J66,\"Error\",IF('Data for submission '!J65<0,\"Error\",IF(ISTEXT('Data for submission '!J65)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!K65=\"\",\"No Data\",IF(LEN('Data for submission '!K65)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!K65)<>'Data for submission '!K65,\"Error\",IF('Data for submission '!K65<'Data for submission '!K66,\"Error\",IF('Data for submission '!K65<0,\"Error\",IF(ISTEXT('Data for submission '!K65)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!L65=\"\",\"\",IF(LEN('Data for submission '!L65)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[null,null,47," of which: Voting Board members","Headcount",{"$f":"IF('Data for submission '!F66=\"\",\"No Data\",IF(LEN('Data for submission '!F66)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!F66)<>'Data for submission '!F66,\"Error\",IF('Data for submission '!F66>'Data for submission '!F65,\"Error\",IF('Data for submission '!F66<0,\"Error\",IF(ISTEXT('Data for submission '!F66)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!G66=\"\",\"No Data\",IF(LEN('Data for submission '!G66)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!G66)<>'Data for submission '!G66,\"Error\",IF('Data for submission '!G66>'Data for submission '!G65,\"Error\",IF('Data for submission '!G66<0,\"Error\",IF(ISTEXT('Data for submission '!G66)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!H66=\"\",\"No Data\",IF(LEN('Data for submission '!H66)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!H66)<>'Data for submission '!H66,\"Error\",IF('Data for submission '!H66>'Data for submission '!H65,\"Error\",IF('Data for submission '!H66<0,\"Error\",IF(ISTEXT('Data for submission '!H66)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!I66=\"\",\"No Data\",IF(LEN('Data for submission '!I66)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!I66)<>'Data for submission '!I66,\"Error\",IF('Data for submission '!I66>'Data for submission '!I65,\"Error\",IF('Data for submission '!I66<0,\"Error\",IF(ISTEXT('Data for submission '!I66)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!J66=\"\",\"No Data\",IF(LEN('Data for submission '!J66)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!J66)<>'Data for submission '!J66,\"Error\",IF('Data for submission '!J66>'Data for submission '!J65,\"Error\",IF('Data for submission '!J66<0,\"Error\",IF(ISTEXT('Data for submission '!J66)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!K66=\"\",\"No Data\",IF(LEN('Data for submission '!K66)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!K66)<>'Data for submission '!K66,\"Error\",IF('Data for submission '!K66>'Data for submission '!K65,\"Error\",IF('Data for submission '!K66<0,\"Error\",IF(ISTEXT('Data for submission '!K66)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!L66=\"\",\"\",IF(LEN('Data for submission '!L66)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[null,null,48,"                 : Non Voting Board members","Autocalculated",{"$f":"IF('Data for submission '!F67=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!G67=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!H67=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!I67=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!J67=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!K67=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!L67=\"\",\"\",IF(LEN('Data for submission '!L67)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[null,null,49,"Total Board members","Headcount",{"$f":"IF('Data for submission '!F68=\"\",\"No Data\",IF('Data for submission '!F68<'Data for submission '!F69,\"Error\",IF('Data for submission '!F68<0,\"Error\",IF(ISTEXT('Data for submission '!F68)=TRUE,\"Error\",\"OK\"))))","v":"OK"},{"$f":"IF('Data for submission '!G68=\"\",\"No Data\",IF('Data for submission '!G68<'Data for submission '!G69,\"Error\",IF('Data for submission '!G68<0,\"Error\",IF(ISTEXT('Data for submission '!G68)=TRUE,\"Error\",\"OK\"))))","v":"OK"},{"$f":"IF('Data for submission '!H68=\"\",\"No Data\",IF('Data for submission '!H68<'Data for submission '!H69,\"Error\",IF('Data for submission '!H68<0,\"Error\",IF(ISTEXT('Data for submission '!H68)=TRUE,\"Error\",\"OK\"))))","v":"OK"},{"$f":"IF('Data for submission '!I68=\"\",\"No Data\",IF('Data for submission '!I68<'Data for submission '!I69,\"Error\",IF('Data for submission '!I68<0,\"Error\",IF(ISTEXT('Data for submission '!I68)=TRUE,\"Error\",\"OK\"))))","v":"OK"},{"$f":"IF('Data for submission '!J68=\"\",\"No Data\",IF('Data for submission '!J68<'Data for submission '!J69,\"Error\",IF('Data for submission '!J68<0,\"Error\",IF(ISTEXT('Data for submission '!J68)=TRUE,\"Error\",\"OK\"))))","v":"OK"},{"$f":"IF('Data for submission '!K68=\"\",\"No Data\",IF('Data for submission '!K68<'Data for submission '!K69,\"Error\",IF('Data for submission '!K68<0,\"Error\",IF(ISTEXT('Data for submission '!K68)=TRUE,\"Error\",\"OK\"))))","v":"OK"},{"$f":"IF('Data for submission '!L68=\"\",\"\",IF(LEN('Data for submission '!L68)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[null,null,50," of which: Exec Board members","Headcount",{"$f":"IF('Data for submission '!F69=\"\",\"No Data\",IF(LEN('Data for submission '!F69)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!F69)<>'Data for submission '!F69,\"Error\",IF('Data for submission '!F69<'Data for submission '!F70,\"Error\",IF('Data for submission '!F69<0,\"Error\",IF(ISTEXT('Data for submission '!F69)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!G69=\"\",\"No Data\",IF(LEN('Data for submission '!G69)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!G69)<>'Data for submission '!G69,\"Error\",IF('Data for submission '!G69<'Data for submission '!G70,\"Error\",IF('Data for submission '!G69<0,\"Error\",IF(ISTEXT('Data for submission '!G69)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!H69=\"\",\"No Data\",IF(LEN('Data for submission '!H69)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!H69)<>'Data for submission '!H69,\"Error\",IF('Data for submission '!H69<'Data for submission '!H70,\"Error\",IF('Data for submission '!H69<0,\"Error\",IF(ISTEXT('Data for submission '!H69)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!I69=\"\",\"No Data\",IF(LEN('Data for submission '!I69)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!I69)<>'Data for submission '!I69,\"Error\",IF('Data for submission '!I69<'Data for submission '!I70,\"Error\",IF('Data for submission '!I69<0,\"Error\",IF(ISTEXT('Data for submission '!I69)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!J69=\"\",\"No Data\",IF(LEN('Data for submission '!J69)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!J69)<>'Data for submission '!J69,\"Error\",IF('Data for submission '!J69<'Data for submission '!J70,\"Error\",IF('Data for submission '!J69<0,\"Error\",IF(ISTEXT('Data for submission '!J69)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!K69=\"\",\"No Data\",IF(LEN('Data for submission '!K69)>255,\"Error you have exceeded the character limit\",IF(INT('Data for submission '!K69)<>'Data for submission '!K69,\"Error\",IF('Data for submission '!K69<'Data for submission '!K70,\"Error\",IF('Data for submission '!K69<0,\"Error\",IF(ISTEXT('Data for submission '!K69)=TRUE,\"Error\",\"OK\"))))))","v":"OK"},{"$f":"IF('Data for submission '!L69=\"\",\"\",IF(LEN('Data for submission '!L69)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[null,null,51,"                 : Non Executive Board members","Autocalculated",{"$f":"IF('Data for submission '!F70=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!G70=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!H70=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!I70=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!J70=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!K70=\"Error\",\"Error\",\"\")","v":""},{"$f":"IF('Data for submission '!L70=\"\",\"\",IF(LEN('Data for submission '!L70)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[null,null,52,"Number of staff in overall workforce","Headcount",{"$f":"F58","v":"OK"},{"$f":"G58","v":"OK"},"OK","OK","OK","OK",{"$f":"IF('Data for submission '!L71=\"\",\"\",IF(LEN('Data for submission '!L71)>255,\"Error you have exceeded the character limit\",\"\"))","v":""}]
[null,null,53,"Total Board members - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F66/($F$66+$G$66+$H$66),\"\")","v":""},{"$f":"IFERROR(G66/($F$66+$G$66+$H$66),\"\")","v":""},{"$f":"IFERROR(H66/($F$66+$G$66+$H$66),\"\")","v":""},{"$f":"IFERROR(I66/(I66+J66+K66),\"\")","v":""},{"$f":"IFERROR(J66/(I66+J66+K66),\"\")","v":""},{"$f":"IFERROR(K66/(I66+J66+K66),\"\")","v":""}]
[null,null,54,"Voting Board Member - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F67/($F$67+$G$67+$H$67),\"\")","v":""},{"$f":"IFERROR(G67/($F$67+$G$67+$H$67),\"\")","v":""},{"$f":"IFERROR(H67/($F$67+$G$67+$H$67),\"\")","v":""},{"$f":"IFERROR(I67/(I67+J67+K67),\"\")","v":""},{"$f":"IFERROR(J67/(I67+J67+K67),\"\")","v":""},{"$f":"IFERROR(K67/(I67+J67+K67),\"\")","v":""}]
[null,null,55,"Non Voting Board Member - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F68/($F$68+$G$68+$H$68),\"\")","v":""},{"$f":"IFERROR(G68/($F$68+$G$68+$H$68),\"\")","v":""},{"$f":"IFERROR(H68/($F$68+$G$68+$H$68),\"\")","v":""},{"$f":"IFERROR(I68/(I68+J68+K68),\"\")","v":""},{"$f":"IFERROR(J68/(I68+J68+K68),\"\")","v":""},{"$f":"IFERROR(K68/(I68+J68+K68),\"\")","v":""}]
[null,null,56,"Executive Board Member - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F70/($F$70+$G$70+$H$70),\"\")","v":""},{"$f":"IFERROR(G70/($F$70+$G$70+$H$70),\"\")","v":""},{"$f":"IFERROR(H70/($F$70+$G$70+$H$70),\"\")","v":""},{"$f":"IFERROR(I70/(I70+J70+K70),\"\")","v":""},{"$f":"IFERROR(J70/(I70+J70+K70),\"\")","v":""},{"$f":"IFERROR(K70/(I70+J70+K70),\"\")","v":""}]
[null,null,57,"Non Executive Board Member - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F71/($F$71+$G$71+$H$71),\"\")","v":""},{"$f":"IFERROR(G71/($F$71+$G$71+$H$71),\"\")","v":""},{"$f":"IFERROR(H71/($F$71+$G$71+$H$71),\"\")","v":""},{"$f":"IFERROR(I71/(I71+J71+K71),\"\")","v":""},{"$f":"IFERROR(J71/(I71+J71+K71),\"\")","v":""},{"$f":"IFERROR(K71/(I71+J71+K71),\"\")","v":""}]
[null,null,58,"Overall workforce - % by Ethnicity","Auto calculated",{"$f":"IFERROR(F72/($F$72+$G$72+$H$72),\"\")","v":""},{"$f":"IFERROR(G72/($F$72+$G$72+$H$72),\"\")","v":""},{"$f":"IFERROR(H72/($F$72+$G$72+$H$72),\"\")","v":""},{"$f":"IFERROR(I72/($I$72+$J$72+$K$72),\"\")","v":""},{"$f":"IFERROR(J72/($I$72+$J$72+$K$72),\"\")","v":""},{"$f":"IFERROR(K72/($I$72+$J$72+$K$72),\"\")","v":""}]
[null,null,59,"Difference (Total Board -Overall workforce )","Auto calculated",{"$f":"IFERROR(F73-F78,\"\")","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",0,{"$f":"IF('Data for submission '!F17=\"\",0,'Data for submission '!F17)","v":16},0,{"$f":"IF('Data for submission '!G17=\"\",0,'Data for submission '!G17)","v":1},0,{"$f":"IF('Data for submission '!H17=\"\",0,'Data for submission '!H17)","v":3},0,{"$f":"IF('Data for submission '!I17=\"\",0,'Data for submission '!I17)","v":14},0,{"$f":"IF('Data for submission '!J17=\"\",0,'Data for submission '!J17)","v":1},0,{"$f":"IF('Data for submission '!K17=\"\",0,'Data for submission '!K17)","v":0},{"$f":"IF(ISBLANK('Data for submission '!H17),\"\",'Data for submission '!H17)","v":3}]
[2,"Ind1_NC_Band 1",0,{"$f":"IF('Data for submission '!F18=\"\",0,'Data for submission '!F18)","v":495},0,{"$f":"IF('Data for submission '!G18=\"\",0,'Data for submission '!G18)","v":11},0,{"$f":"IF('Data for submission '!H18=\"\",0,'Data for submission '!H18)","v":21},0,{"$f":"IF('Data for submission '!I18=\"\",0,'Data for submission '!I18)","v":167},0,{"$f":"IF('Data for submission '!J18=\"\",0,'Data for submission '!J18)","v":2},0,{"$f":"IF('Data for submission '!K18=\"\",0,'Data for submission '!K18)","v":10},{"$f":"IF(ISBLANK('Data for submission '!L18),\"\",'Data for submission '!L18)","v":""}]
[3,"Ind1_NC_Band 2",0,{"$f":"IF('Data for submission '!F19=\"\",0,'Data for submission '!F19)","v":364},0,{"$f":"IF('Data for submission '!G19=\"\",0,'Data for submission '!G19)","v":12},0,{"$f":"IF('Data for submission '!H19=\"\",0,'Data for submission '!H19)","v":9},0,{"$f":"IF('Data for submission '!I19=\"\",0,'Data for submission '!I19)","v":795},0,{"$f":"IF('Data for submission '!J19=\"\",0,'Data for submission '!J19)","v":23},0,{"$f":"IF('Data for submission '!K19=\"\",0,'Data for submission '!K19)","v":16},{"$f":"IF(ISBLANK('Data for submission '!L19),\"\",'Data for submission '!L19)","v":""}]
[4,"Ind1_NC_Band 3",0,{"$f":"IF('Data for submission '!F20=\"\",0,'Data for submission '!F20)","v":362},0,{"$f":"IF('Data for submission '!G20=\"\",0,'Data for submission '!G20)","v":3},0,{"$f":"IF('Data for submission '!H20=\"\",0,'Data for submission '!H20)","v":8},0,{"$f":"IF('Data for submission '!I20=\"\",0,'Data for submission '!I20)","v":365},0,{"$f":"IF('Data for submission '!J20=\"\",0,'Data for submission '!J20)","v":3},0,{"$f":"IF('Data for submission '!K20=\"\",0,'Data for submission '!K20)","v":7},{"$f":"IF(ISBLANK('Data for submission '!L20),\"\",'Data for submission '!L20)","v":""}]
[5,"Ind1_NC_Band 4",0,{"$f":"IF('Data for submission '!F21=\"\",0,'Data for submission '!F21)","v":139},0,{"$f":"IF('Data for submission '!G21=\"\",0,'Data for submission '!G21)","v":3},0,{"$f":"IF('Data for submission '!H21=\"\",0,'Data for submission '!H21)","v":4},0,{"$f":"IF('Data for submission '!I21=\"\",0,'Data for submission '!I21)","v":153},0,{"$f":"IF('Data for submission '!J21=\"\",0,'Data for submission '!J21)","v":3},0,{"$f":"IF('Data for submission '!K21=\"\",0,'Data for submission '!K21)","v":5},{"$f":"IF(ISBLANK('Data for submission '!L21),\"\",'Data for submission '!L21)","v":""}]
[6,"Ind1_NC_Band 5",0,{"$f":"IF('Data for submission '!F22=\"\",0,'Data for submission '!F22)","v":53},0,{"$f":"IF('Data for submission '!G22=\"\",0,'Data for submission '!G22)","v":0},0,{"$f":"IF('Data for submission '!H22=\"\",0,'Data for submission '!H22)","v":1},0,{"$f":"IF('Data for submission '!I22=\"\",0,'Data for submission '!I22)","v":49},0,{"$f":"IF('Data for submission '!J22=\"\",0,'Data for submission '!J22)","v":0},0,{"$f":"IF('Data for submission '!K22=\"\",0,'Data for submission '!K22)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L22),\"\",'Data for submission '!L22)","v":""}]
[7,"Ind1_NC_Band 6",0,{"$f":"IF('Data for submission '!F23=\"\",0,'Data for submission '!F23)","v":65},0,{"$f":"IF('Data for submission '!G23=\"\",0,'Data for submission '!G23)","v":2},0,{"$f":"IF('Data for submission '!H23=\"\",0,'Data for submission '!H23)","v":2},0,{"$f":"IF('Data for submission '!I23=\"\",0,'Data for submission '!I23)","v":70},0,{"$f":"IF('Data for submission '!J23=\"\",0,'Data for submission '!J23)","v":1},0,{"$f":"IF('Data for submission '!K23=\"\",0,'Data for submission '!K23)","v":2},{"$f":"IF(ISBLANK('Data for submission '!L23),\"\",'Data for submission '!L23)","v":""}]
[8,"Ind1_NC_Band 7",0,{"$f":"IF('Data for submission '!F24=\"\",0,'Data for submission '!F24)","v":44},0,{"$f":"IF('Data for submission '!G24=\"\",0,'Data for submission '!G24)","v":3},0,{"$f":"IF('Data for submission '!H24=\"\",0,'Data for submission '!H24)","v":2},0,{"$f":"IF('Data for submission '!I24=\"\",0,'Data for submission '!I24)","v":48},0,{"$f":"IF('Data for submission '!J24=\"\",0,'Data for submission '!J24)","v":4},0,{"$f":"IF('Data for submission '!K24=\"\",0,'Data for submission '!K24)","v":2},{"$f":"IF(ISBLANK('Data for submission '!L24),\"\",'Data for submission '!L24)","v":""}]
[9,"Ind1_NC_Band 8A",0,{"$f":"IF('Data for submission '!F25=\"\",0,'Data for submission '!F25)","v":42},0,{"$f":"IF('Data for submission '!G25=\"\",0,'Data for submission '!G25)","v":0},0,{"$f":"IF('Data for submission '!H25=\"\",0,'Data for submission '!H25)","v":0},0,{"$f":"IF('Data for submission '!I25=\"\",0,'Data for submission '!I25)","v":44},0,{"$f":"IF('Data for submission '!J25=\"\",0,'Data for submission '!J25)","v":1},0,{"$f":"IF('Data for submission '!K25=\"\",0,'Data for submission '!K25)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L25),\"\",'Data for submission '!L25)","v":""}]
[10,"Ind1_NC_Band 8B",0,{"$f":"IF('Data for submission '!F26=\"\",0,'Data for submission '!F26)","v":17},0,{"$f":"IF('Data for submission '!G26=\"\",0,'Data for submission '!G26)","v":0},0,{"$f":"IF('Data for submission '!H26=\"\",0,'Data for submission '!H26)","v":0},0,{"$f":"IF('Data for submission '!I26=\"\",0,'Data for submission '!I26)","v":18},0,{"$f":"IF('Data for submission '!J26=\"\",0,'Data for submission '!J26)","v":0},0,{"$f":"IF('Data for submission '!K26=\"\",0,'Data for submission '!K26)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L26),\"\",'Data for submission '!L26)","v":""}]
[11,"Ind1_NC_Band 8C",0,{"$f":"IF('Data for submission '!F27=\"\",0,'Data for submission '!F27)","v":14},0,{"$f":"IF('Data for submission '!G27=\"\",0,'Data for submission '!G27)","v":0},0,{"$f":"IF('Data for submission '!H27=\"\",0,'Data for submission '!H27)","v":0},0,{"$f":"IF('Data for submission '!I27=\"\",0,'Data for submission '!I27)","v":19},0,{"$f":"IF('Data for submission '!J27=\"\",0,'Data for submission '!J27)","v":0},0,{"$f":"IF('Data for submission '!K27=\"\",0,'Data for submission '!K27)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L27),\"\",'Data for submission '!L27)","v":""}]
[12,"Ind1_NC_Band 8D",0,{"$f":"IF('Data for submission '!F28=\"\",0,'Data for submission '!F28)","v":9},0,{"$f":"IF('Data for submission '!G28=\"\",0,'Data for submission '!G28)","v":0},0,{"$f":"IF('Data for submission '!H28=\"\",0,'Data for submission '!H28)","v":0},0,{"$f":"IF('Data for submission '!I28=\"\",0,'Data for submission '!I28)","v":8},0,{"$f":"IF('Data for submission '!J28=\"\",0,'Data for submission '!J28)","v":0},0,{"$f":"IF('Data for submission '!K28=\"\",0,'Data for submission '!K28)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L28),\"\",'Data for submission '!L28)","v":""}]
[13,"Ind1_NC_Band 9",0,{"$f":"IF('Data for submission '!F29=\"\",0,'Data for submission '!F29)","v":0},0,{"$f":"IF('Data for submission '!G29=\"\",0,'Data for submission '!G29)","v":0},0,{"$f":"IF('Data for submission '!H29=\"\",0,'Data for submission '!H29)","v":0},0,{"$f":"IF('Data for submission '!I29=\"\",0,'Data for submission '!I29)","v":0},0,{"$f":"IF('Data for submission '!J29=\"\",0,'Data for submission '!J29)","v":0},0,{"$f":"IF('Data for submission '!K29=\"\",0,'Data for submission '!K29)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L29),\"\",'Data for submission '!L29)","v":""}]
[14,"Ind1_NC_VSM",0,{"$f":"IF('Data for submission '!F30=\"\",0,'Data for submission '!F30)","v":8},0,{"$f":"IF('Data for submission '!G30=\"\",0,'Data for submission '!G30)","v":0},0,{"$f":"IF('Data for submission '!H30=\"\",0,'Data for submission '!H30)","v":0},0,{"$f":"IF('Data for submission '!I30=\"\",0,'Data for submission '!I30)","v":7},0,{"$f":"IF('Data for submission '!J30=\"\",0,'Data for submission '!J30)","v":0},0,{"$f":"IF('Data for submission '!K30=\"\",0,'Data for submission '!K30)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L30),\"\",'Data for submission '!L30)","v":""}]
[15,"Ind1_Clin_NMUnder Band 1",0,{"$f":"IF('Data for submission '!F33=\"\",0,'Data for submission '!F33)","v":3},0,{"$f":"IF('Data for submission '!G33=\"\",0,'Data for submission '!G33)","v":0},0,{"$f":"IF('Data for submission '!H33=\"\",0,'Data for submission '!H33)","v":0},0,{"$f":"IF('Data for submission '!I33=\"\",0,'Data for submission '!I33)","v":2},0,{"$f":"IF('Data for submission '!J33=\"\",0,'Data for submission '!J33)","v":0},0,{"$f":"IF('Data for submission '!K33=\"\",0,'Data for submission '!K33)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L33),\"\",'Data for submission '!L33)","v":""}]
[16,"Ind1_Clin_NMBand 1",0,{"$f":"IF('Data for submission '!F34=\"\",0,'Data for submission '!F34)","v":50},0,{"$f":"IF('Data for submission '!G34=\"\",0,'Data for submission '!G34)","v":0},0,{"$f":"IF('Data for submission '!H34=\"\",0,'Data for submission '!H34)","v":3},0,{"$f":"IF('Data for submission '!I34=\"\",0,'Data for submission '!I34)","v":18},0,{"$f":"IF('Data for submission '!J34=\"\",0,'Data for submission '!J34)","v":0},0,{"$f":"IF('Data for submission '!K34=\"\",0,'Data for submission '!K34)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L34),\"\",'Data for submission '!L34)","v":""}]
[17,"Ind1_Clin_NMBand 2",0,{"$f":"IF('Data for submission '!F35=\"\",0,'Data for submission '!F35)","v":1135},0,{"$f":"IF('Data for submission '!G35=\"\",0,'Data for submission '!G35)","v":32},0,{"$f":"IF('Data for submission '!H35=\"\",0,'Data for submission '!H35)","v":34},0,{"$f":"IF('Data for submission '!I35=\"\",0,'Data for submission '!I35)","v":1089},0,{"$f":"IF('Data for submission '!J35=\"\",0,'Data for submission '!J35)","v":33},0,{"$f":"IF('Data for submission '!K35=\"\",0,'Data for submission '!K35)","v":32},{"$f":"IF(ISBLANK('Data for submission '!L35),\"\",'Data for submission '!L35)","v":""}]
[18,"Ind1_Clin_NMBand 3",0,{"$f":"IF('Data for submission '!F36=\"\",0,'Data for submission '!F36)","v":285},0,{"$f":"IF('Data for submission '!G36=\"\",0,'Data for submission '!G36)","v":3},0,{"$f":"IF('Data for submission '!H36=\"\",0,'Data for submission '!H36)","v":6},0,{"$f":"IF('Data for submission '!I36=\"\",0,'Data for submission '!I36)","v":331},0,{"$f":"IF('Data for submission '!J36=\"\",0,'Data for submission '!J36)","v":16},0,{"$f":"IF('Data for submission '!K36=\"\",0,'Data for submission '!K36)","v":6},{"$f":"IF(ISBLANK('Data for submission '!L36),\"\",'Data for submission '!L36)","v":""}]
[19,"Ind1_Clin_NMBand 4",0,{"$f":"IF('Data for submission '!F37=\"\",0,'Data for submission '!F37)","v":90},0,{"$f":"IF('Data for submission '!G37=\"\",0,'Data for submission '!G37)","v":1},0,{"$f":"IF('Data for submission '!H37=\"\",0,'Data for submission '!H37)","v":5},0,{"$f":"IF('Data for submission '!I37=\"\",0,'Data for submission '!I37)","v":94},0,{"$f":"IF('Data for submission '!J37=\"\",0,'Data for submission '!J37)","v":2},0,{"$f":"IF('Data for submission '!K37=\"\",0,'Data for submission '!K37)","v":4},{"$f":"IF(ISBLANK('Data for submission '!L37),\"\",'Data for submission '!L37)","v":""}]
[20,"Ind1_Clin_NMBand 5",0,{"$f":"IF('Data for submission '!F38=\"\",0,'Data for submission '!F38)","v":1055},0,{"$f":"IF('Data for submission '!G38=\"\",0,'Data for submission '!G38)","v":121},0,{"$f":"IF('Data for submission '!H38=\"\",0,'Data for submission '!H38)","v":34},0,{"$f":"IF('Data for submission '!I38=\"\",0,'Data for submission '!I38)","v":1004},0,{"$f":"IF('Data for submission '!J38=\"\",0,'Data for submission '!J38)","v":134},0,{"$f":"IF('Data for submission '!K38=\"\",0,'Data for submission '!K38)","v":32},{"$f":"IF(ISBLANK('Data for submission '!L38),\"\",'Data for submission '!L38)","v":""}]
[21,"Ind1_Clin_NMBand 6",0,{"$f":"IF('Data for submission '!F39=\"\",0,'Data for submission '!F39)","v":772},0,{"$f":"IF('Data for submission '!G39=\"\",0,'Data for submission '!G39)","v":28},0,{"$f":"IF('Data for submission '!H39=\"\",0,'Data for submission '!H39)","v":26},0,{"$f":"IF('Data for submission '!I39=\"\",0,'Data for submission '!I39)","v":797},0,{"$f":"IF('Data for submission '!J39=\"\",0,'Data for submission '!J39)","v":34},0,{"$f":"IF('Data for submission '!K39=\"\",0,'Data for submission '!K39)","v":26},{"$f":"IF(ISBLANK('Data for submission '!L39),\"\",'Data for submission '!L39)","v":""}]
[22,"Ind1_Clin_NMBand 7",0,{"$f":"IF('Data for submission '!F40=\"\",0,'Data for submission '!F40)","v":377},0,{"$f":"IF('Data for submission '!G40=\"\",0,'Data for submission '!G40)","v":9},0,{"$f":"IF('Data for submission '!H40=\"\",0,'Data for submission '!H40)","v":8},0,{"$f":"IF('Data for submission '!I40=\"\",0,'Data for submission '!I40)","v":406},0,{"$f":"IF('Data for submission '!J40=\"\",0,'Data for submission '!J40)","v":9},0,{"$f":"IF('Data for submission '!K40=\"\",0,'Data for submission '!K40)","v":8},{"$f":"IF(ISBLANK('Data for submission '!L40),\"\",'Data for submission '!L40)","v":""}]
[23,"Ind1_Clin_NMBand 8A",0,{"$f":"IF('Data for submission '!F41=\"\",0,'Data for submission '!F41)","v":74},0,{"$f":"IF('Data for submission '!G41=\"\",0,'Data for submission '!G41)","v":7},0,{"$f":"IF('Data for submission '!H41=\"\",0,'Data for submission '!H41)","v":2},0,{"$f":"IF('Data for submission '!I41=\"\",0,'Data for submission '!I41)","v":79},0,{"$f":"IF('Data for submission '!J41=\"\",0,'Data for submission '!J41)","v":7},0,{"$f":"IF('Data for submission '!K41=\"\",0,'Data for submission '!K41)","v":1},{"$f":"IF(ISBLANK('Data for submission '!L41),\"\",'Data for submission '!L41)","v":""}]
[24,"Ind1_Clin_NMBand 8B",0,{"$f":"IF('Data for submission '!F42=\"\",0,'Data for submission '!F42)","v":12},0,{"$f":"IF('Data for submission '!G42=\"\",0,'Data for submission '!G42)","v":2},0,{"$f":"IF('Data for submission '!H42=\"\",0,'Data for submission '!H42)","v":0},0,{"$f":"IF('Data for submission '!I42=\"\",0,'Data for submission '!I42)","v":12},0,{"$f":"IF('Data for submission '!J42=\"\",0,'Data for submission '!J42)","v":2},0,{"$f":"IF('Data for submission '!K42=\"\",0,'Data for submission '!K42)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L42),\"\",'Data for submission '!L42)","v":""}]
[25,"Ind1_Clin_NMBand 8C",0,{"$f":"IF('Data for submission '!F43=\"\",0,'Data for submission '!F43)","v":13},0,{"$f":"IF('Data for submission '!G43=\"\",0,'Data for submission '!G43)","v":0},0,{"$f":"IF('Data for submission '!H43=\"\",0,'Data for submission '!H43)","v":0},0,{"$f":"IF('Data for submission '!I43=\"\",0,'Data for submission '!I43)","v":13},0,{"$f":"IF('Data for submission '!J43=\"\",0,'Data for submission '!J43)","v":0},0,{"$f":"IF('Data for submission '!K43=\"\",0,'Data for submission '!K43)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L43),\"\",'Data for submission '!L43)","v":""}]
[26,"Ind1_Clin_NMBand 8D",0,{"$f":"IF('Data for submission '!F44=\"\",0,'Data for submission '!F44)","v":3},0,{"$f":"IF('Data for submission '!G44=\"\",0,'Data for submission '!G44)","v":0},0,{"$f":"IF('Data for submission '!H44=\"\",0,'Data for submission '!H44)","v":0},0,{"$f":"IF('Data for submission '!I44=\"\",0,'Data for submission '!I44)","v":3},0,{"$f":"IF('Data for submission '!J44=\"\",0,'Data for submission '!J44)","v":0},0,{"$f":"IF('Data for submission '!K44=\"\",0,'Data for submission '!K44)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L44),\"\",'Data for submission '!L44)","v":""}]
[27,"Ind1_Clin_NMBand 9",0,{"$f":"IF('Data for submission '!F45=\"\",0,'Data for submission '!F45)","v":1},0,{"$f":"IF('Data for submission '!G45=\"\",0,'Data for submission '!G45)","v":1},0,{"$f":"IF('Data for submission '!H45=\"\",0,'Data for submission '!H45)","v":1},0,{"$f":"IF('Data for submission '!I45=\"\",0,'Data for submission '!I45)","v":1},0,{"$f":"IF('Data for submission '!J45=\"\",0,'Data for submission '!J45)","v":1},0,{"$f":"IF('Data for submission '!K45=\"\",0,'Data for submission '!K45)","v":1},{"$f":"IF(ISBLANK('Data for submission '!L45),\"\",'Data for submission '!L45)","v":""}]
[28,"Ind1_Clin_NMVSM",0,{"$f":"IF('Data for submission '!F46=\"\",0,'Data for submission '!F46)","v":7},0,{"$f":"IF('Data for submission '!G46=\"\",0,'Data for submission '!G46)","v":2},0,{"$f":"IF('Data for submission '!H46=\"\",0,'Data for submission '!H46)","v":1},0,{"$f":"IF('Data for submission '!I46=\"\",0,'Data for submission '!I46)","v":7},0,{"$f":"IF('Data for submission '!J46=\"\",0,'Data for submission '!J46)","v":1},0,{"$f":"IF('Data for submission '!K46=\"\",0,'Data for submission '!K46)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L46),\"\",'Data for submission '!L46)","v":""}]
[29,"Ind1_Clin_MDConsultants",0,{"$f":"IF('Data for submission '!F48=\"\",0,'Data for submission '!F48)","v":105},0,{"$f":"IF('Data for submission '!G48=\"\",0,'Data for submission '!G48)","v":149},0,{"$f":"IF('Data for submission '!H48=\"\",0,'Data for submission '!H48)","v":335},0,{"$f":"IF('Data for submission '!I48=\"\",0,'Data for submission '!I48)","v":105},0,{"$f":"IF('Data for submission '!J48=\"\",0,'Data for submission '!J48)","v":156},0,{"$f":"IF('Data for submission '!K48=\"\",0,'Data for submission '!K48)","v":300},{"$f":"IF(ISBLANK('Data for submission '!L48),\"\",'Data for submission '!L48)","v":""}]
[30,"Ind1_Clin_MD  of which Senior medical manager",0,{"$f":"IF('Data for submission '!F49=\"\",0,'Data for submission '!F49)","v":0},0,{"$f":"IF('Data for submission '!G49=\"\",0,'Data for submission '!G49)","v":0},0,{"$f":"IF('Data for submission '!H49=\"\",0,'Data for submission '!H49)","v":0},0,{"$f":"IF('Data for submission '!I49=\"\",0,'Data for submission '!I49)","v":0},0,{"$f":"IF('Data for submission '!J49=\"\",0,'Data for submission '!J49)","v":0},0,{"$f":"IF('Data for submission '!K49=\"\",0,'Data for submission '!K49)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L49),\"\",'Data for submission '!L49)","v":""}]
[31,"Ind1_Clin_MDNon-consultant career grade",0,{"$f":"IF('Data for submission '!F50=\"\",0,'Data for submission '!F50)","v":22},0,{"$f":"IF('Data for submission '!G50=\"\",0,'Data for submission '!G50)","v":66},0,{"$f":"IF('Data for submission '!H50=\"\",0,'Data for submission '!H50)","v":2},0,{"$f":"IF('Data for submission '!I50=\"\",0,'Data for submission '!I50)","v":24},0,{"$f":"IF('Data for submission '!J50=\"\",0,'Data for submission '!J50)","v":68},0,{"$f":"IF('Data for submission '!K50=\"\",0,'Data for submission '!K50)","v":2},{"$f":"IF(ISBLANK('Data for submission '!L50),\"\",'Data for submission '!L50)","v":""}]
[32,"Ind1_Clin_MDTrainee grades",0,{"$f":"IF('Data for submission '!F51=\"\",0,'Data for submission '!F51)","v":100},0,{"$f":"IF('Data for submission '!G51=\"\",0,'Data for submission '!G51)","v":119},0,{"$f":"IF('Data for submission '!H51=\"\",0,'Data for submission '!H51)","v":15},0,{"$f":"IF('Data for submission '!I51=\"\",0,'Data for submission '!I51)","v":96},0,{"$f":"IF('Data for submission '!J51=\"\",0,'Data for submission '!J51)","v":140},0,{"$f":"IF('Data for submission '!K51=\"\",0,'Data for submission '!K51)","v":18},{"$f":"IF(ISBLANK('Data for submission '!L51),\"\",'Data for submission '!L51)","v":""}]
[33,"Ind1_Clin_MDOther",0,{"$f":"IF('Data for submission '!F52=\"\",0,'Data for submission '!F52)","v":0},0,{"$f":"IF('Data for submission '!G52=\"\",0,'Data for submission '!G52)","v":0},0,{"$f":"IF('Data for submission '!H52=\"\",0,'Data for submission '!H52)","v":0},0,{"$f":"IF('Data for submission '!I52=\"\",0,'Data for submission '!I52)","v":0},0,{"$f":"IF('Data for submission '!J52=\"\",0,'Data for submission '!J52)","v":0},0,{"$f":"IF('Data for submission '!K52=\"\",0,'Data for submission '!K52)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L52),\"\",'Data for submission '!L52)","v":""}]
[34,"Ind2_Number of shortlisted applicants:",0,{"$f":"IF('Data for submission '!F53=\"\",0,'Data for submission '!F53)","v":533},0,{"$f":"IF('Data for submission '!G53=\"\",0,'Data for submission '!G53)","v":70},0,{"$f":"IF('Data for submission '!H53=\"\",0,'Data for submission '!H53)","v":6},0,{"$f":"IF('Data for submission '!I53=\"\",0,'Data for submission '!I53)","v":1145},0,{"$f":"IF('Data for submission '!J53=\"\",0,'Data for submission '!J53)","v":142},0,{"$f":"IF('Data for submission '!K53=\"\",0,'Data for submission '!K53)","v":61},{"$f":"IF(ISBLANK('Data for submission '!L53),\"\",'Data for submission '!L53)","v":""}]
[35,"Ind2_Number appointed from shortlisting:",0,{"$f":"IF('Data for submission '!F54=\"\",0,'Data for submission '!F54)","v":266},0,{"$f":"IF('Data for submission '!G54=\"\",0,'Data for submission '!G54)","v":18},0,{"$f":"IF('Data for submission '!H54=\"\",0,'Data for submission '!H54)","v":0},0,{"$f":"IF('Data for submission '!I54=\"\",0,'Data for submission '!I54)","v":403},0,{"$f":"IF('Data for submission '!J54=\"\",0,'Data for submission '!J54)","v":39},0,{"$f":"IF('Data for submission '!K54=\"\",0,'Data for submission '!K54)","v":30},{"$f":"IF(ISBLANK('Data for submission '!L54),\"\",'Data for submission '!L54)","v":""}]
[36,"Ind2_Relative likelihood of shortlisting/appointed:",0,{"$f":"IF('Data for submission '!F55=\"\",0,'Data for submission '!F55)","v":0.49906191369606001},0,{"$f":"IF('Data for submission '!G55=\"\",0,'Data for submission '!G55)","v":0.25714285714285712},0,{"$f":"IF('Data for submission '!H55=\"\",0,'Data for submission '!H55)","v":0},0,{"$f":"IF('Data for submission '!I55=\"\",0,'Data for submission '!I55)","v":0.35196506550218343},0,{"$f":"IF('Data for submission '!J55=\"\",0,'Data for submission '!J55)","v":0.27464788732394368},0,{"$f":"IF('Data for submission '!K55=\"\",0,'Data for submission '!K55)","v":0.49180327868852458},{"$f":"IF(ISBLANK('Data for submission '!L55),\"\",'Data for submission '!L55)","v":""}]
[37,"Ind2_Relative likelihood of White staff being appointed from shortlisting compared to BME staff:",0,{"$f":"IF('Data for submission '!F56=\"\",0,'Data for submission '!F56)","v":1.9407963310402336},0,{"$f":"IF('Data for submission '!G56=\"\",0,'Data for submission '!G56)","v":0},0,{"$f":"IF('Data for submission '!H56=\"\",0,'Data for submission '!H56)","v":0},0,{"$f":"IF('Data for submission '!I56=\"\",0,'Data for submission '!I56)","v":1.2815138282387191},0,{"$f":"IF('Data for submission '!J56=\"\",0,'Data for submission '!J56)","v":0},0,{"$f":"IF('Data for submission '!K56=\"\",0,'Data for submission '!K56)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L56),\"\",'Data for submission '!L56)","v":""}]
[38,"Ind3_Number of staff in workforce:",0,{"$f":"IF('Data for submission '!F57=\"\",0,'Data for submission '!F57)","v":5732},0,{"$f":"IF('Data for submission '!G57=\"\",0,'Data for submission '!G57)","v":575},0,{"$f":"IF('Data for submission '!H57=\"\",0,'Data for submission '!H57)","v":522},0,{"$f":"IF('Data for submission '!I57=\"\",0,'Data for submission '!I57)","v":5838},0,{"$f":"IF('Data for submission '!J57=\"\",0,'Data for submission '!J57)","v":641},0,{"$f":"IF('Data for submission '!K57=\"\",0,'Data for submission '!K57)","v":472},{"$f":"IF(ISBLANK('Data for submission '!L57),\"\",'Data for submission '!L57)","v":""}]
[39,"Ind3_Number of staff entering the formal disciplinary process:",0,{"$f":"IF('Data for submission '!F58=\"\",0,'Data for submission '!F58)","v":55},0,{"$f":"IF('Data for submission '!G58=\"\",0,'Data for submission '!G58)","v":4},0,{"$f":"IF('Data for submission '!H58=\"\",0,'Data for submission '!H58)","v":1},0,{"$f":"IF('Data for submission '!I58=\"\",0,'Data for submission '!I58)","v":56},0,{"$f":"IF('Data for submission '!J58=\"\",0,'Data for submission '!J58)","v":4},0,{"$f":"IF('Data for submission '!K58=\"\",0,'Data for submission '!K58)","v":2},{"$f":"IF(ISBLANK('Data for submission '!L58),\"\",'Data for submission '!L58)","v":""}]
[40,"Ind3_Likelihood of staff entering the formal disciplinary process:",0,{"$f":"IF('Data for submission '!F59=\"\",0,'Data for submission '!F59)","v":9.5952547103977676E-3},0,{"$f":"IF('Data for submission '!G59=\"\",0,'Data for submission '!G59)","v":6.956521739130435E-3},0,{"$f":"IF('Data for submission '!H59=\"\",0,'Data for submission '!H59)","v":1.9157088122605363E-3},0,{"$f":"IF('Data for submission '!I59=\"\",0,'Data for submission '!I59)","v":9.5923261390887284E-3},0,{"$f":"IF('Data for submission '!J59=\"\",0,'Data for submission '!J59)","v":6.2402496099843996E-3},0,{"$f":"IF('Data for submission '!K59=\"\",0,'Data for submission '!K59)","v":4.2372881355932203E-3},{"$f":"IF(ISBLANK('Data for submission '!L59),\"\",'Data for submission '!L59)","v":""}]
[41,"Ind3_Relative likelihood of BME staff entering the formal disciplinary process compared to White staff:",0,{"$f":"IF('Data for submission '!F60=\"\",0,'Data for submission '!F60)","v":0},0,{"$f":"IF('Data for submission '!G60=\"\",0,'Data for submission '!G60)","v":0.72499604743083002},0,{"$f":"IF('Data for submission '!H60=\"\",0,'Data for submission '!H60)","v":0},0,{"$f":"IF('Data for submission '!I60=\"\",0,'Data for submission '!I60)","v":0},0,{"$f":"IF('Data for submission '!J60=\"\",0,'Data for submission '!J60)","v":0.65054602184087373},0,{"$f":"IF('Data for submission '!K60=\"\",0,'Data for submission '!K60)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L60),\"\",'Data for submission '!L60)","v":""}]
[42,"Ind4_Number of staff in workforce ",0,{"$f":"IF('Data for submission '!F61=\"\",0,'Data for submission '!F61)","v":5732},0,{"$f":"IF('Data for submission '!G61=\"\",0,'Data for submission '!G61)","v":575},0,{"$f":"IF('Data for submission '!H61=\"\",0,'Data for submission '!H61)","v":522},0,{"$f":"IF('Data for submission '!I61=\"\",0,'Data for submission '!I61)","v":5838},0,{"$f":"IF('Data for submission '!J61=\"\",0,'Data for submission '!J61)","v":641},0,{"$f":"IF('Data for submission '!K61=\"\",0,'Data for submission '!K61)","v":472},{"$f":"IF(ISBLANK('Data for submission '!L61),\"\",'Data for submission '!L61)","v":""}]
[43,"Ind4_Number of staff accessing non-mandatory training and CPD ",0,{"$f":"IF('Data for submission '!F62=\"\",0,'Data for submission '!F62)","v":5534},0,{"$f":"IF('Data for submission '!G62=\"\",0,'Data for submission '!G62)","v":509},0,{"$f":"IF('Data for submission '!H62=\"\",0,'Data for submission '!H62)","v":208},0,{"$f":"IF('Data for submission '!I62=\"\",0,'Data for submission '!I62)","v":5565},0,{"$f":"IF('Data for submission '!J62=\"\",0,'Data for submission '!J62)","v":566},0,{"$f":"IF('Data for submission '!K62=\"\",0,'Data for submission '!K62)","v":203},{"$f":"IF(ISBLANK('Data for submission '!L62),\"\",'Data for submission '!L62)","v":""}]
[44,"Ind4_Likelihood of staff accessing non-mandatory training and CPD:",0,{"$f":"IF('Data for submission '!F63=\"\",0,'Data for submission '!F63)","v":0.96545708304256805},0,{"$f":"IF('Data for submission '!G63=\"\",0,'Data for submission '!G63)","v":0.88521739130434784},0,{"$f":"IF('Data for submission '!H63=\"\",0,'Data for submission '!H63)","v":0.39846743295019155},0,{"$f":"IF('Data for submission '!I63=\"\",0,'Data for submission '!I63)","v":0.9532374100719424},0,{"$f":"IF('Data for submission '!J63=\"\",0,'Data for submission '!J63)","v":0.88299531981279256},0,{"$f":"IF('Data for submission '!K63=\"\",0,'Data for submission '!K63)","v":0.43008474576271188},{"$f":"IF(ISBLANK('Data for submission '!L63),\"\",'Data for submission '!L63)","v":""}]
[45,"Ind4_Relative likelihood of White staff accessing non-mandatory training and CPD compared to BME staff:",0,{"$f":"IF('Data for submission '!F64=\"\",0,'Data for submission '!F64)","v":1.0906440525529992},0,{"$f":"IF('Data for submission '!G64=\"\",0,'Data for submission '!G64)","v":0},0,{"$f":"IF('Data for submission '!H64=\"\",0,'Data for submission '!H64)","v":0},0,{"$f":"IF('Data for submission '!I64=\"\",0,'Data for submission '!I64)","v":1.079549787731652},0,{"$f":"IF('Data for submission '!J64=\"\",0,'Data for submission '!J64)","v":0},0,{"$f":"IF('Data for submission '!K64=\"\",0,'Data for submission '!K64)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L64),\"\",'Data for submission '!L64)","v":""}]
[46,"Ind_5% of  staff experiencing harassment, bullying or abuse from patients, relatives  or the public in last 12 months ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[47,"Ind6_% of  staff experiencing harassment, bullying or abuse from staff in last 12 months ",0,0,0,0,0,0,0,0,0,0,0,0,0]
[48,"Ind7_%  staff believing that trust provides equal opportunities for career progression or promotion",0,0,0,0,0,0,0,0,0,0,0,0,0]
[49,"Ind8_%  staff personally experienced discrimination at work from Manager/team leader or other colleague",0,0,0,0,0,0,0,0,0,0,0,0,0]
[50,"Ind9_Total Board members",0,{"$f":"IF('Data for submission '!F65=\"\",0,'Data for submission '!F65)","v":12},0,{"$f":"IF('Data for submission '!G65=\"\",0,'Data for submission '!G65)","v":2},0,{"$f":"IF('Data for submission '!H65=\"\",0,'Data for submission '!H65)","v":0},0,{"$f":"IF('Data for submission '!I65=\"\",0,'Data for submission '!I65)","v":12},0,{"$f":"IF('Data for submission '!J65=\"\",0,'Data for submission '!J65)","v":1},0,{"$f":"IF('Data for submission '!K65=\"\",0,'Data for submission '!K65)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L65),\"\",'Data for submission '!L65)","v":""}]
[51,"Ind9_ of which: Voting Board members",0,{"$f":"IF('Data for submission '!F66=\"\",0,'Data for submission '!F66)","v":11},0,{"$f":"IF('Data for submission '!G66=\"\",0,'Data for submission '!G66)","v":2},0,{"$f":"IF('Data for submission '!H66=\"\",0,'Data for submission '!H66)","v":0},0,{"$f":"IF('Data for submission '!I66=\"\",0,'Data for submission '!I66)","v":11},0,{"$f":"IF('Data for submission '!J66=\"\",0,'Data for submission '!J66)","v":1},0,{"$f":"IF('Data for submission '!K66=\"\",0,'Data for submission '!K66)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L66),\"\",'Data for submission '!L66)","v":""}]
[52,"Ind9_                 : Non Voting Board members",0,{"$f":"IF('Data for submission '!F67=\"\",0,'Data for submission '!F67)","v":1},0,{"$f":"IF('Data for submission '!G67=\"\",0,'Data for submission '!G67)","v":0},0,{"$f":"IF('Data for submission '!H67=\"\",0,'Data for submission '!H67)","v":0},0,{"$f":"IF('Data for submission '!I67=\"\",0,'Data for submission '!I67)","v":1},0,{"$f":"IF('Data for submission '!J67=\"\",0,'Data for submission '!J67)","v":0},0,{"$f":"IF('Data for submission '!K67=\"\",0,'Data for submission '!K67)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L67),\"\",'Data for submission '!L67)","v":""}]
[53,"Ind9_Total Board members",0,{"$f":"IF('Data for submission '!F68=\"\",0,'Data for submission '!F68)","v":12},0,{"$f":"IF('Data for submission '!G68=\"\",0,'Data for submission '!G68)","v":2},0,{"$f":"IF('Data for submission '!H68=\"\",0,'Data for submission '!H68)","v":0},0,{"$f":"IF('Data for submission '!I68=\"\",0,'Data for submission '!I68)","v":12},0,{"$f":"IF('Data for submission '!J68=\"\",0,'Data for submission '!J68)","v":1},0,{"$f":"IF('Data for submission '!K68=\"\",0,'Data for submission '!K68)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L68),\"\",'Data for submission '!L68)","v":""}]
[54,"Ind9_ of which: Exec Board members",0,{"$f":"IF('Data for submission '!F69=\"\",0,'Data for submission '!F69)","v":6},0,{"$f":"IF('Data for submission '!G69=\"\",0,'Data for submission '!G69)","v":1},0,{"$f":"IF('Data for submission '!H69=\"\",0,'Data for submission '!H69)","v":0},0,{"$f":"IF('Data for submission '!I69=\"\",0,'Data for submission '!I69)","v":6},0,{"$f":"IF('Data for submission '!J69=\"\",0,'Data for submission '!J69)","v":1},0,{"$f":"IF('Data for submission '!K69=\"\",0,'Data for submission '!K69)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L69),\"\",'Data for submission '!L69)","v":""}]
[55,"Ind9_                 : Non Executive Board members",0,{"$f":"IF('Data for submission '!F70=\"\",0,'Data for submission '!F70)","v":6},0,{"$f":"IF('Data for submission '!G70=\"\",0,'Data for submission '!G70)","v":1},0,{"$f":"IF('Data for submission '!H70=\"\",0,'Data for submission '!H70)","v":0},0,{"$f":"IF('Data for submission '!I70=\"\",0,'Data for submission '!I70)","v":6},0,{"$f":"IF('Data for submission '!J70=\"\",0,'Data for submission '!J70)","v":0},0,{"$f":"IF('Data for submission '!K70=\"\",0,'Data for submission '!K70)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L70),\"\",'Data for submission '!L70)","v":""}]
[56,"Ind9_Number of staff in overall workforce",0,{"$f":"IF('Data for submission '!F71=\"\",0,'Data for submission '!F71)","v":5732},0,{"$f":"IF('Data for submission '!G71=\"\",0,'Data for submission '!G71)","v":575},0,{"$f":"IF('Data for submission '!H71=\"\",0,'Data for submission '!H71)","v":522},0,{"$f":"IF('Data for submission '!I71=\"\",0,'Data for submission '!I71)","v":5838},0,{"$f":"IF('Data for submission '!J71=\"\",0,'Data for submission '!J71)","v":641},0,{"$f":"IF('Data for submission '!K71=\"\",0,'Data for submission '!K71)","v":472},{"$f":"IF(ISBLANK('Data for submission '!L71),\"\",'Data for submission '!L71)","v":""}]
[57,"Ind9_Total Board members - % by Ethnicity",0,{"$f":"IF('Data for submission '!F72=\"\",0,'Data for submission '!F72)","v":0.8571428571428571},0,{"$f":"IF('Data for submission '!G72=\"\",0,'Data for submission '!G72)","v":0.14285714285714285},0,{"$f":"IF('Data for submission '!H72=\"\",0,'Data for submission '!H72)","v":0},0,{"$f":"IF('Data for submission '!I72=\"\",0,'Data for submission '!I72)","v":0.92307692307692313},0,{"$f":"IF('Data for submission '!J72=\"\",0,'Data for submission '!J72)","v":7.6923076923076927E-2},0,{"$f":"IF('Data for submission '!K72=\"\",0,'Data for submission '!K72)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L72),\"\",'Data for submission '!L72)","v":""}]
[58,"Ind9_Voting Board Member - % by Ethnicity",0,{"$f":"IF('Data for submission '!F73=\"\",0,'Data for submission '!F73)","v":0.84615384615384615},0,{"$f":"IF('Data for submission '!G73=\"\",0,'Data for submission '!G73)","v":0.15384615384615385},0,{"$f":"IF('Data for submission '!H73=\"\",0,'Data for submission '!H73)","v":0},0,{"$f":"IF('Data for submission '!I73=\"\",0,'Data for submission '!I73)","v":0.91666666666666663},0,{"$f":"IF('Data for submission '!J73=\"\",0,'Data for submission '!J73)","v":8.3333333333333329E-2},0,{"$f":"IF('Data for submission '!K73=\"\",0,'Data for submission '!K73)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L73),\"\",'Data for submission '!L73)","v":""}]
[59,"Ind9_Non Voting Board Member - % by Ethnicity",0,{"$f":"IF('Data for submission '!F74=\"\",0,'Data for submission '!F74)","v":1},0,{"$f":"IF('Data for submission '!G74=\"\",0,'Data for submission '!G74)","v":0},0,{"$f":"IF('Data for submission '!H74=\"\",0,'Data for submission '!H74)","v":0},0,{"$f":"IF('Data for submission '!I74=\"\",0,'Data for submission '!I74)","v":1},0,{"$f":"IF('Data for submission '!J74=\"\",0,'Data for submission '!J74)","v":0},0,{"$f":"IF('Data for submission '!K74=\"\",0,'Data for submission '!K74)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L74),\"\",'Data for submission '!L74)","v":""}]
[60,"Ind9_Executive Board Member - % by Ethnicity",0,{"$f":"IF('Data for submission '!F75=\"\",0,'Data for submission '!F75)","v":0.8571428571428571},0,{"$f":"IF('Data for submission '!G75=\"\",0,'Data for submission '!G75)","v":0.14285714285714285},0,{"$f":"IF('Data for submission '!H75=\"\",0,'Data for submission '!H75)","v":0},0,{"$f":"IF('Data for submission '!I75=\"\",0,'Data for submission '!I75)","v":0.8571428571428571},0,{"$f":"IF('Data for submission '!J75=\"\",0,'Data for submission '!J75)","v":0.14285714285714285},0,{"$f":"IF('Data for submission '!K75=\"\",0,'Data for submission '!K75)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L75),\"\",'Data for submission '!L75)","v":""}]
[61,"Ind9_Non Executive Board Member - % by Ethnicity",0,{"$f":"IF('Data for submission '!F76=\"\",0,'Data for submission '!F76)","v":0.8571428571428571},0,{"$f":"IF('Data for submission '!G76=\"\",0,'Data for submission '!G76)","v":0.14285714285714285},0,{"$f":"IF('Data for submission '!H76=\"\",0,'Data for submission '!H76)","v":0},0,{"$f":"IF('Data for submission '!I76=\"\",0,'Data for submission '!I76)","v":1},0,{"$f":"IF('Data for submission '!J76=\"\",0,'Data for submission '!J76)","v":0},0,{"$f":"IF('Data for submission '!K76=\"\",0,'Data for submission '!K76)","v":0},{"$f":"IF(ISBLANK('Data for submission '!L76),\"\",'Data for submission '!L76)","v":""}]
[62,"Ind9_Overall workforce - % by Ethnicity",0,{"$f":"IF('Data for submission '!F77=\"\",0,'Data for submission '!F77)","v":0.83936154634646365},0,{"$f":"IF('Data for submission '!G77=\"\",0,'Data for submission '!G77)","v":8.4199736418216431E-2},0,{"$f":"IF('Data for submission '!H77=\"\",0,'Data for submission '!H77)","v":7.6438717235319961E-2},0,{"$f":"IF('Data for submission '!I77=\"\",0,'Data for submission '!I77)","v":0.83987915407854985},0,{"$f":"IF('Data for submission '!J77=\"\",0,'Data for submission '!J77)","v":9.2216947201841468E-2},0,{"$f":"IF('Data for submission '!K77=\"\",0,'Data for submission '!K77)","v":6.7903898719608696E-2},{"$f":"IF(ISBLANK('Data for submission '!L77),\"\",'Data for submission '!L77)","v":""}]
[63,"Ind9_Difference (Total Board -Overall workforce )",0,{"$f":"IF('Data for submission '!F78=\"\",0,'Data for submission '!F78)","v":1.7781310796393446E-2},0,{"$f":"IF('Data for submission '!G78=\"\",0,'Data for submission '!G78)","v":5.8657406438926418E-2},0,{"$f":"IF('Data for submission '!H78=\"\",0,'Data for submission '!H78)","v":-7.6438717235319961E-2},0,{"$f":"IF('Data for submission '!I78=\"\",0,'Data for submission '!I78)","v":8.3197768998373278E-2},0,{"$f":"IF('Data for submission '!J78=\"\",0,'Data for submission '!J78)","v":-1.529387027876454E-2},0,{"$f":"IF('Data for submission '!K78=\"\",0,'Data for submission '!K78)","v":-6.7903898719608696E-2},{"$f":"IF(ISBLANK('Data for submission '!L78),\"\",'Data for submission '!L78)","v":""}]