{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["2019 Summary","2019 Data by Employee Type","2019 Data By Pay Band","Year on Year Comparison","A Graph Data","D Graph Data","E Graph Data","G Graph Data","RB Graph Data","RS Graph Data","SO Graph Data","RB Graph Data ET","RS Graph Data ET ","A Graph Data ET ","D Graph Data ET","E Graph Data ET ","SO Graph Data ET ","G Graph Data ET ","RS Graph Data YY","A Graph Data YY","D Graph Data YY","E Graph Data YY","G Graph Data YY","SO Graph Data YY","RB Graph Data YY","Colours"],"not_rendered":{"charts":28,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2019 Summary","index":0,"n_rows":46,"n_cols":26,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Workforce Demographics Overview - 2019"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Age Band","Headcount","%"]
[null,null,null,null,null,null,null,null,null,null,"16-25",672,{"$f":"L6/SUM($L$6:$L$11)","v":0.1022675391873383},null,null,null,null,null,null,null,null,null,null,"Disability","Headcount","%"]
[null,null,null,null,null,null,null,null,null,null,"26-35",1706,0.25962562775833209,null,null,null,null,null,null,null,null,null,null,"Yes",210,{"$f":"Y7/SUM($Y$7:$Y$10)","v":3.1958605996043221E-2}]
[null,null,null,null,null,null,null,null,null,null,"36-45",1412,0.21488357936387156,null,null,null,null,null,null,null,null,null,null,"No",5035,{"$f":"Y8/SUM($Y$7:$Y$10)","v":0.76624562471465529}]
[null,null,null,null,null,null,null,null,null,null,"46-55",1584,0.24105919951301172,null,null,null,null,null,null,null,null,null,null,"Not Declared",92,{"$f":"Y9/SUM($Y$7:$Y$10)","v":1.4000913103028458E-2}]
[null,null,null,null,null,null,null,null,null,null,"56-65",1041,0.15842337543752855,null,null,null,null,null,null,null,null,null,null,"Not Recorded",1234,{"$f":"Y10/SUM($Y$7:$Y$10)","v":0.18779485618627301}]
[null,null,null,null,null,null,null,null,null,null,"66 and Over",156,2.3740678739917819E-2]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Ethnicity","Headcount","%",null,null,null,null,null,null,null,null,null,null,"Gender","Headcount","%"]
[null,null,null,null,null,null,null,null,null,null,"White - British",5032,{"$f":"L17/SUM($L$17:$L$20)","v":0.76578907320042611},null,null,null,null,null,null,null,null,null,null,"Female",5062,{"$f":"Y17/SUM($Y$17:$Y$18)","v":0.77035458834271797}]
[null,null,null,null,null,null,null,null,null,null,"White - Other",635,{"$f":"L18/SUM($L$17:$L$20)","v":9.6636737178511636E-2},null,null,null,null,null,null,null,null,null,null,"Male",1509,{"$f":"Y18/SUM($Y$17:$Y$18)","v":0.229645411657282}]
[null,null,null,null,null,null,null,null,null,null,"BME",823,{"$f":"L19/SUM($L$17:$L$20)","v":0.12524729873687415}]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",81,{"$f":"L20/SUM($L$17:$L$20)","v":1.23268908841881E-2}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Relationship Status","Headcount","%",null,null,null,null,null,null,null,null,null,null,"Religious Belief","Headcount","%"]
[null,null,null,null,null,null,null,null,null,null,"Single",2548,{"$f":"L28/SUM($L$28:$L$34)","v":0.38776441941865775},null,null,null,null,null,null,null,null,null,null,"Atheism",1124,{"$f":"Y28/SUM($Y$28:$Y$37)","v":0.17105463399786944}]
[null,null,null,null,null,null,null,null,null,null,"Married",3277,0.49870643737635062,null,null,null,null,null,null,null,null,null,null,"Buddhism",32,4.8698828184446808E-3]
[null,null,null,null,null,null,null,null,null,null,"Civil Partnership",77,1.1718155531882515E-2,null,null,null,null,null,null,null,null,null,null,"Christianity",2932,0.4462030132399939]
[null,null,null,null,null,null,null,null,null,null,"Divorced",345,5.2503424136356718E-2,null,null,null,null,null,null,null,null,null,null,"Hinduism",49,7.4570080657434179E-3]
[null,null,null,null,null,null,null,null,null,null,"Legally Separated",55,8.3701110942017952E-3,null,null,null,null,null,null,null,null,null,null,"Islam",54,8.2179272561254003E-3]
[null,null,null,null,null,null,null,null,null,null,"Widowed",46,7.0004565515142288E-3,null,null,null,null,null,null,null,null,null,null,"Judaism",6,9.1310302845837776E-4]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",223,3.3936995891036374E-2,null,null,null,null,null,null,null,null,null,null,"Sikhism",9,1.3696545426875666E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",548,8.3396743265865159E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Declared",1001,0.15233602191447268]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Recorded",816,0.12418201187033936]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Ethnicity","Headcount","%"]
[null,null,null,null,null,null,null,null,null,null,"Heterosexual",5018,{"$f":"L41/SUM($L$41:$L$46)","v":0.76365849946735653}]
[null,null,null,null,null,null,null,null,null,null,"LGB",121,{"$f":"L42/SUM($L$41:$L$46)","v":1.841424440724395E-2}]
[null,null,null,null,null,null,null,null,null,null,"Other",1,1.5218383807639628E-4]
[null,null,null,null,null,null,null,null,null,null,"Undecided",6,9.1310302845837776E-4]
[null,null,null,null,null,null,null,null,null,null,"Not Declared",584,8.8875361436615438E-2]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",841,0.12798660782224927]

{"sheet":"2019 Data by Employee Type","index":1,"n_rows":211,"n_cols":13,"rows_kept":211,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Workforce Demographics by Staff Type - 2019"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Age Band","Substantive - Full Time","Substantive - Part Time","Bank"]
[null,null,null,null,null,null,null,null,null,"16-25",371,93,208]
[null,null,null,null,null,null,null,null,null,"26-35",911,456,339]
[null,null,null,null,null,null,null,null,null,"36-45",583,624,205]
[null,null,null,null,null,null,null,null,null,"46-55",772,649,163]
[null,null,null,null,null,null,null,null,null,"56-65",382,511,148]
[null,null,null,null,null,null,null,null,null,"66 and Over",10,96,50]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Disability","Substantive - Full Time","Substantive - Part Time","Bank"]
[null,null,null,null,null,null,null,null,null,"Yes",115,71,24]
[null,null,null,null,null,null,null,null,null,"No",2343,1739,953]
[null,null,null,null,null,null,null,null,null,"Not Declared",31,45,16]
[null,null,null,null,null,null,null,null,null,"Not Recorded",540,574,120]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Ethnicity","Substantive - Full Time","Substantive - Part Time","Bank"]
[null,null,null,null,null,null,null,null,null,"White British",2183,2053,796]
[null,null,null,null,null,null,null,null,null,"White Other",324,190,121]
[null,null,null,null,null,null,null,null,null,"BME",495,169,159]
[null,null,null,null,null,null,null,null,null,"Not Recorded",27,17,37]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Gender","Substantive - Full Time","Substantive - Part Time","Bank"]
[null,null,null,null,null,null,null,null,null,"Female",2015,2182,865]
[null,null,null,null,null,null,null,null,null,"Male",1014,247,248]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Relationship Status","Substantive - Full Time","Substantive - Part Time","Bank"]
[null,null,null,null,null,null,null,null,null,"Single",1408,612,528]
[null,null,null,null,null,null,null,null,null,"Married",1305,1534,438]
[null,null,null,null,null,null,null,null,null,"Civil Partnership",33,29,15]
[null,null,null,null,null,null,null,null,null,"Divorced",155,137,53]
[null,null,null,null,null,null,null,null,null,"Legally Separated",24,24,7]
[null,null,null,null,null,null,null,null,null,"Widowed",14,24,8]
[null,null,null,null,null,null,null,null,null,"Not Recorded",90,69,64]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Religious Belief","Substantive - Full Time","Substantive - Part Time","Bank"]
[null,null,null,null,null,null,null,null,null,"Atheism",604,290,230]
[null,null,null,null,null,null,null,null,null,"Buddhism",15,9,8]
[null,null,null,null,null,null,null,null,null,"Christianity",1324,1135,473]
[null,null,null,null,null,null,null,null,null,"Hinduism",33,7,9]
[null,null,null,null,null,null,null,null,null,"Islam",36,7,11]
[null,null,null,null,null,null,null,null,null,"Judaism",3,3,0]
[null,null,null,null,null,null,null,null,null,"Sikhism",8,0,1]
[null,null,null,null,null,null,null,null,null,"Other",255,191,102]
[null,null,null,null,null,null,null,null,null,"Not Declared",419,404,178]
[null,null,null,null,null,null,null,null,null,"Not Recorded",332,383,101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Sexual Orientation","Substantive - Full Time","Substantive - Part Time","Bank"]
[null,null,null,null,null,null,null,null,null,"Heterosexual",2362,1777,879]
[null,null,null,null,null,null,null,null,null,"LGB",77,20,24]
[null,null,null,null,null,null,null,null,null,"Other",1,0,0]
[null,null,null,null,null,null,null,null,null,"Undecided",2,1,3]
[null,null,null,null,null,null,null,null,null,"Not Declared",244,232,108]
[null,null,null,null,null,null,null,null,null,"Not Recorded",343,399,99]

{"sheet":"2019 Data By Pay Band","index":2,"n_rows":211,"n_cols":20,"rows_kept":211,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Workforce Demographics by Pay Band - 2019"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Age Band","Band 1","Band 2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8","Band 9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"16-25",4,333,54,38,157,37,2,0,0,47,0,0,0]
[null,null,null,null,null,null,"26-35",9,349,142,117,393,266,98,30,0,278,5,17,2]
[null,null,null,null,null,null,"36-45",7,329,117,68,257,229,134,78,2,60,15,112,4]
[null,null,null,null,null,null,"46-55",6,400,156,85,257,218,210,94,4,17,25,98,14]
[null,null,null,null,null,null,"56-65",6,329,173,60,146,129,74,44,2,4,18,44,12]
[null,null,null,null,null,null,"66 and Over",3,76,25,7,17,9,3,3,0,2,1,4,6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Disability Status","Band 1","Band 2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8","Band 9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Yes",5,80,27,15,33,26,16,4,0,3,0,0,1]
[null,null,null,null,null,null,"No",21,1412,504,286,977,686,341,182,6,387,28,182,23]
[null,null,null,null,null,null,"Not Declared",0,13,10,7,17,24,6,0,0,13,1,0,1]
[null,null,null,null,null,null,"Not Recorded",9,311,126,67,200,152,158,63,2,5,35,93,13]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Ethnicity","Band 1","Band 2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8","Band 9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"White British",15,1327,582,301,842,732,447,217,6,282,37,214,30]
[null,null,null,null,null,null,"White Other",11,206,43,23,123,84,38,20,2,54,7,22,2]
[null,null,null,null,null,null,"BME",9,261,34,48,247,65,30,10,0,62,20,37,0]
[null,null,null,null,null,null,"Not Recorded",0,22,8,3,15,7,6,2,0,10,0,2,6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Gender","Band 1","Band 2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8","Band 9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Female",18,1354,560,306,1053,768,427,177,5,237,35,101,21]
[null,null,null,null,null,null,"Male",17,462,107,69,174,120,94,72,3,171,29,174,17]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Relationship Status","Band 1","Band 2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8","Band 9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Single",14,821,205,159,532,292,141,67,0,250,12,52,3]
[null,null,null,null,null,null,"Married",21,754,346,165,573,521,326,160,8,127,48,207,21]
[null,null,null,null,null,null,"Civil Partnership",0,27,16,6,11,6,6,1,0,2,0,2,0]
[null,null,null,null,null,null,"Divorced",0,118,60,29,55,33,24,16,0,3,2,4,1]
[null,null,null,null,null,null,"Legally Separated",0,23,11,4,5,3,4,3,0,0,1,0,1]
[null,null,null,null,null,null,"Widowed",0,22,7,2,7,2,3,0,0,1,0,1,1]
[null,null,null,null,null,null,"Not Recorded",0,51,22,10,44,31,17,2,0,25,1,9,11]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Religious Belief","Band 1","Band 2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8","Band 9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Atheism",0,288,117,75,214,139,82,37,0,129,2,39,2]
[null,null,null,null,null,null,"Buddhism",0,17,2,0,6,2,1,0,0,2,0,2,0]
[null,null,null,null,null,null,"Christianity",21,824,301,177,588,439,215,118,3,123,18,91,14]
[null,null,null,null,null,null,"Hinduism",0,11,0,1,8,4,3,2,0,13,3,4,0]
[null,null,null,null,null,null,"Islam",1,16,4,1,8,4,0,1,0,8,3,8,0]
[null,null,null,null,null,null,"Judaism",0,0,0,1,2,1,1,0,0,0,0,1,0]
[null,null,null,null,null,null,"Sikhism",0,1,0,0,1,1,0,1,0,2,1,2,0]
[null,null,null,null,null,null,"Other",0,190,73,36,96,65,33,12,1,34,3,3,2]
[null,null,null,null,null,null,"Not Declared",6,246,100,44,168,154,95,41,3,93,4,42,5]
[null,null,null,null,null,null,"Not Recorded",7,223,70,40,136,79,91,37,1,4,30,83,15]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Sexual Orientation","Band 1","Band 2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8","Band 9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Heterosexual",22,1398,532,307,960,709,363,189,7,321,29,164,17]
[null,null,null,null,null,null,"LGB",0,32,13,7,29,11,13,2,0,13,0,1,0]
[null,null,null,null,null,null,"Other",5,155,50,22,95,84,50,20,0,69,5,23,6]
[null,null,null,null,null,null,"Undecided",0,0,0,0,0,1,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Not Declared",0,3,0,0,1,0,0,1,0,1,0,0,0]
[null,null,null,null,null,null,"Not Recorded",8,228,72,39,142,83,95,37,1,4,30,87,15]

{"sheet":"Year on Year Comparison","index":3,"n_rows":209,"n_cols":16,"rows_kept":209,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Workforce Demographics Year on Year Comparison"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Age Band",2019,2018,2017,2016,2015]
[null,null,null,null,null,null,null,null,null,null,"16-25",{"$f":"'2019 Summary'!M6","v":0.1022675391873383},0.10823051694518195,0.10685548760862568,8.1099423142178481E-2,0.10008658008658008]
[null,null,null,null,null,null,null,null,null,null,"26-35",{"$f":"'2019 Summary'!M7","v":0.25962562775833209},0.25113228174293301,0.25185065980045057,0.24516457414319645,0.24311688311688312]
[null,null,null,null,null,null,null,null,null,null,"36-45",{"$f":"'2019 Summary'!M8","v":0.21488357936387156},0.22036545369358113,0.22095268747988414,0.22633186291143537,0.22805194805194806]
[null,null,null,null,null,null,null,null,null,null,"46-55",{"$f":"'2019 Summary'!M9","v":0.24105919951301172},0.24269873496798375,0.24396523978113938,0.2495758398371225,0.25471861471861473]
[null,null,null,null,null,null,null,null,null,null,"56-65",{"$f":"'2019 Summary'!M10","v":0.15842337543752855},0.15367796345463064,0.15159317669777922,0.16813708856464202,0.1503030303030303]
[null,null,null,null,null,null,null,null,null,null,"66 and Over",{"$f":"'2019 Summary'!M11","v":2.3740678739917819E-2},2.3895049195689522E-2,2.4782748632121016E-2,2.9691211401425176E-2,2.3722943722943722E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Disability",2019,2018,2017,2016,2015]
[null,null,null,null,null,null,null,null,null,null,"Yes",{"$f":"'2019 Summary'!Z7","v":3.1958605996043221E-2},3.2953303139153518E-2,3.3311876408110716E-2,3.1557516118086187E-2,2.9437229437229439E-2]
[null,null,null,null,null,null,null,null,null,null,"No",{"$f":"'2019 Summary'!Z8","v":0.76624562471465529},0.73918475714508824,0.70308979723205667,0.66457414319647101,0.59809523809523812]
[null,null,null,null,null,null,null,null,null,null,"Not Declared",{"$f":"'2019 Summary'!Z9","v":1.4000913103028458E-2},1.1557082617523036E-2,8.6900547151593181E-3,1.001017984390906E-2,5.0216450216450216E-3]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2019 Summary'!Z10","v":0.18779485618627301},0.21630485709823521,0.25490827164467333,0.29385816084153377,0.36744588744588746]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Ethnicity",2019,2018,2017,2016,2015]
[null,null,null,null,null,null,null,null,null,null,"White British",{"$f":"'2019 Summary'!M17","v":0.76578907320042611},0.77682336404810248,0.77792082394592854,0.77926705123854778,0.78008658008658005]
[null,null,null,null,null,null,null,null,null,null,"White Other",{"$f":"'2019 Summary'!M18","v":9.6636737178511636E-2},0.10198344526003436,0.10959124557450917,0.11350525958601969,0.11272727272727273]
[null,null,null,null,null,null,null,null,null,null,"BME",{"$f":"'2019 Summary'!M19","v":0.12524729873687415},0.11416523504607215,0.10621177985194721,0.10434340006786563,0.10181818181818184]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2019 Summary'!M20","v":1.23268908841881E-2},7.027955645791035E-3,6.2761506276150627E-3,2.8842891075670173E-3,5.367965367965368E-3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Gender",2019,2018,2017,2016,2015]
[null,null,null,null,null,null,null,null,null,null,"Female",{"$f":"'2019 Summary'!Z17","v":0.77035458834271797},0.77822895517726065,0.77261023495333114,0.77400746521886665,0.77541125541125544]
[null,null,null,null,null,null,null,null,null,null,"Male",{"$f":"'2019 Summary'!Z18","v":0.229645411657282},0.22177104482273935,0.2273897650466688,0.22599253478113335,0.22458874458874459]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Relationship Status",2019,2018,2017,2016,2015]
[null,null,null,null,null,null,null,null,null,null,"Single",{"$f":"'2019 Summary'!M28","v":0.38776441941865775},0.39387786974855538,0.39346636626971354,0.38683406854428237,0.3882251082251082]
[null,null,null,null,null,null,null,null,null,null,"Married",{"$f":"'2019 Summary'!M29","v":0.49870643737635062},0.49742308292987664,0.50128741551335698,0.51408211740753307,0.51411255411255408]
[null,null,null,null,null,null,null,null,null,null,"Civil Partnership",{"$f":"'2019 Summary'!M30","v":1.1718155531882515E-2},1.0932375449008278E-2,7.402639201802382E-3,5.5989141499830338E-3,2.597402597402597E-3]
[null,null,null,null,null,null,null,null,null,null,"Divorced",{"$f":"'2019 Summary'!M31","v":5.2503424136356718E-2},4.8727159144151176E-2,5.2301255230125514E-2,5.3274516457414316E-2,5.74891774891775E-2]
[null,null,null,null,null,null,null,null,null,null,"Legally Separated",{"$f":"'2019 Summary'!M32","v":8.3701110942017952E-3},9.2144307355926901E-3,1.0299324106855488E-2,8.8225313878520523E-3,9.870129870129871E-3]
[null,null,null,null,null,null,null,null,null,null,"Widowed",{"$f":"'2019 Summary'!M33","v":7.0004565515142288E-3},6.559425269404966E-3,6.115223688445446E-3,7.2955548014930439E-3,7.2727272727272727E-3]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2019 Summary'!M34","v":3.3936995891036374E-2},3.3265656723410898E-2,2.9127775989700674E-2,2.4092297251442144E-2,2.0432900432900435E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Religious Belief",2019,2018,2017,2016,2015]
[null,null,null,null,null,null,null,null,null,null,"Atheism",{"$f":"'2019 Summary'!Z28","v":0.17105463399786944},0.16414180852725285,0.14837463791438688,0.13657957244655583,0.11844155844155844]
[null,null,null,null,null,null,null,null,null,null,"Buddhism",{"$f":"'2019 Summary'!Z29","v":4.8698828184446808E-3},4.84148055598938E-3,4.0231734792404248E-3,3.7326094333220224E-3,4.1558441558441558E-3]
[null,null,null,null,null,null,null,null,null,null,"Christianity",{"$f":"'2019 Summary'!Z30","v":0.4462030132399939},0.43979384663439014,0.43418088187962667,0.43281303020020362,0.41818181818181815]
[null,null,null,null,null,null,null,null,null,null,"Hinduism",{"$f":"'2019 Summary'!Z31","v":7.4570080657434179E-3},7.3403092300484149E-3,6.2761506276150627E-3,6.4472344757380388E-3,4.8484848484848485E-3]
[null,null,null,null,null,null,null,null,null,null,"Islam",{"$f":"'2019 Summary'!Z32","v":8.2179272561254003E-3},7.652662814305794E-3,6.2761506276150627E-3,7.2955548014930439E-3,6.7532467532467532E-3]
[null,null,null,null,null,null,null,null,null,null,"Judaism",{"$f":"'2019 Summary'!Z33","v":9.1310302845837776E-4},7.8088396064344837E-4,6.4370775667846802E-4,8.4832032575500507E-4,1.2121212121212121E-3]
[null,null,null,null,null,null,null,null,null,null,"Sikhism",{"$f":"'2019 Summary'!Z34","v":1.3696545426875666E-3},1.405591129158207E-3,1.287415513356936E-3,8.4832032575500507E-4,1.038961038961039E-3]
[null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"'2019 Summary'!Z35","v":8.3396743265865159E-2},7.7932219272216149E-2,7.627936916639845E-2,7.3464540210383442E-2,6.7186147186147183E-2]
[null,null,null,null,null,null,null,null,null,null,"Not Declared",{"$f":"'2019 Summary'!Z36","v":0.15233602191447268},0.1511791347805716,0.17090440939813326,0.18951476077366813,0.22978354978354978]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2019 Summary'!Z37","v":0.12418201187033936},0.14493206309542403,0.15175410363694883,0.14845605700712589,0.14822510822510823]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Sexual Orientation",2019,2018,2017,2016,2015]
[null,null,null,null,null,null,null,null,null,null,"Heterosexual",{"$f":"'2019 Summary'!M41","v":0.76365849946735653},0.74215211619553334,0.59912812736921905,0.6564502164502164,0.69697997964031222]
[null,null,null,null,null,null,null,null,null,null,"LGB",{"$f":"'2019 Summary'!M42","v":1.841424440724395E-2},1.7647977510541934E-2,1.1751326762699014E-2,1.3160173160173158E-2,1.4591109602986086E-2]
[null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"'2019 Summary'!M43","v":1.5218383807639628E-4},"-","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,"Undecided",{"$f":"'2019 Summary'!M44","v":9.1310302845837776E-4},"-","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,"Not Declared",{"$f":"'2019 Summary'!M45","v":8.8875361436615438E-2},9.1363423395283458E-2,9.9507202426080368E-2,9.4718614718614716E-2,9.4163556158805561E-2]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2019 Summary'!M46","v":0.12798660782224927},0.14883648289864126,0.28961334344200151,0.23567099567099567,0.19426535459789618]

{"sheet":"A Graph Data","index":4,"n_rows":80,"n_cols":10,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Age Band","Value",null,"Percentage",null,null,"Dividers",6]
["Band 1","16-25",{"$f":"'2019 Data By Pay Band'!H27","v":4},null,{"$f":"C3/SUM($C$3:$C$8)","v":0.11428571428571428},null,null,null,"X","Y"]
[null,"26-35",{"$f":"'2019 Data By Pay Band'!H28","v":9},null,0.25714285714285712,null,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"36-45",{"$f":"'2019 Data By Pay Band'!H29","v":7},null,0.2,null,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"46-55",{"$f":"'2019 Data By Pay Band'!H30","v":6},null,0.17142857142857143,null,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"56-65",{"$f":"'2019 Data By Pay Band'!H31","v":6},null,0.17142857142857143,null,null,4,24.5,0]
[null,">65",{"$f":"'2019 Data By Pay Band'!H32","v":3},null,8.5714285714285715E-2,null,null,5,30.5,0]
["Band 2","16-25",null,{"$f":"'2019 Data By Pay Band'!I27","v":333},null,{"$f":"D9/SUM($D$9:$D$14)","v":0.18337004405286345},null,6,36.5,0]
[null,"26-35",null,{"$f":"'2019 Data By Pay Band'!I28","v":349},null,0.1921806167400881,null,7,42.5,0]
[null,"36-45",null,{"$f":"'2019 Data By Pay Band'!I29","v":329},null,0.18116740088105726,null,8,48.5,0]
[null,"46-55",null,{"$f":"'2019 Data By Pay Band'!I30","v":400},null,0.22026431718061673,null,9,54.5,0]
[null,"56-65",null,{"$f":"'2019 Data By Pay Band'!I31","v":329},null,0.18116740088105726,null,10,60.5,0]
[null,">65",null,{"$f":"'2019 Data By Pay Band'!I32","v":76},null,4.185022026431718E-2,null,11,66.5,0]
["Band 3","16-25",{"$f":"'2019 Data By Pay Band'!J27","v":54},null,{"$f":"C15/SUM($C$15:$C$20)","v":8.0959520239880053E-2},null,null,12,72.5,0]
[null,"26-35",{"$f":"'2019 Data By Pay Band'!J28","v":142},null,0.21289355322338829]
[null,"36-45",{"$f":"'2019 Data By Pay Band'!J29","v":117},null,0.17541229385307347]
[null,"46-55",{"$f":"'2019 Data By Pay Band'!J30","v":156},null,0.23388305847076463]
[null,"56-65",{"$f":"'2019 Data By Pay Band'!J31","v":173},null,0.25937031484257872]
[null,">65",{"$f":"'2019 Data By Pay Band'!J32","v":25},null,3.7481259370314844E-2]
["Band 4","16-25",null,{"$f":"'2019 Data By Pay Band'!K27","v":38},null,{"$f":"D21/SUM($D$21:$D$26)","v":0.10133333333333333}]
[null,"26-35",null,{"$f":"'2019 Data By Pay Band'!K28","v":117},null,0.312]
[null,"36-45",null,{"$f":"'2019 Data By Pay Band'!K29","v":68},null,0.18133333333333335]
[null,"46-55",null,{"$f":"'2019 Data By Pay Band'!K30","v":85},null,0.22666666666666666]
[null,"56-65",null,{"$f":"'2019 Data By Pay Band'!K31","v":60},null,0.16]
[null,">65",null,{"$f":"'2019 Data By Pay Band'!K32","v":7},null,1.8666666666666668E-2]
["Band 5","16-25",{"$f":"'2019 Data By Pay Band'!L27","v":157},null,{"$f":"C27/SUM($C$27:$C$32)","v":0.12795436022819887}]
[null,"26-35",{"$f":"'2019 Data By Pay Band'!L28","v":393},null,0.32029339853300731]
[null,"36-45",{"$f":"'2019 Data By Pay Band'!L29","v":257},null,0.20945395273023634]
[null,"46-55",{"$f":"'2019 Data By Pay Band'!L30","v":257},null,0.20945395273023634]
[null,"56-65",{"$f":"'2019 Data By Pay Band'!L31","v":146},null,0.11898940505297473]
[null,">65",{"$f":"'2019 Data By Pay Band'!L32","v":17},null,1.3854930725346373E-2]
["Band 6","16-25",null,{"$f":"'2019 Data By Pay Band'!M27","v":37},null,{"$f":"D33/SUM($D$33:$D$38)","v":4.1666666666666664E-2}]
[null,"26-35",null,{"$f":"'2019 Data By Pay Band'!M28","v":266},null,0.29954954954954954]
[null,"36-45",null,{"$f":"'2019 Data By Pay Band'!M29","v":229},null,0.25788288288288286]
[null,"46-55",null,{"$f":"'2019 Data By Pay Band'!M30","v":218},null,0.24549549549549549]
[null,"56-65",null,{"$f":"'2019 Data By Pay Band'!M31","v":129},null,0.14527027027027026]
[null,">65",null,{"$f":"'2019 Data By Pay Band'!M32","v":9},null,1.0135135135135136E-2]
["Band 7","16-25",{"$f":"'2019 Data By Pay Band'!N27","v":2},null,{"$f":"C39/SUM($C$39:$C$44)","v":3.838771593090211E-3}]
[null,"26-35",{"$f":"'2019 Data By Pay Band'!N28","v":98},null,0.18809980806142035]
[null,"36-45",{"$f":"'2019 Data By Pay Band'!N29","v":134},null,0.25719769673704412]
[null,"46-55",{"$f":"'2019 Data By Pay Band'!N30","v":210},null,0.40307101727447214]
[null,"56-65",{"$f":"'2019 Data By Pay Band'!N31","v":74},null,0.14203454894433781]
[null,">65",{"$f":"'2019 Data By Pay Band'!N32","v":3},null,5.7581573896353169E-3]
["Band 8","16-25",null,{"$f":"'2019 Data By Pay Band'!O27","v":0},null,{"$f":"D45/SUM($D$45:$D$50)","v":0}]
[null,"26-35",null,{"$f":"'2019 Data By Pay Band'!O28","v":30},null,0.12048192771084337]
[null,"36-45",null,{"$f":"'2019 Data By Pay Band'!O29","v":78},null,0.31325301204819278]
[null,"46-55",null,{"$f":"'2019 Data By Pay Band'!O30","v":94},null,0.37751004016064255]
[null,"56-65",null,{"$f":"'2019 Data By Pay Band'!O31","v":44},null,0.17670682730923695]
[null,">65",null,{"$f":"'2019 Data By Pay Band'!O32","v":3},null,1.2048192771084338E-2]
["Band 9","16-25",{"$f":"'2019 Data By Pay Band'!P27","v":0},null,{"$f":"C51/SUM($C$51:$C$56)","v":0}]
[null,"26-35",{"$f":"'2019 Data By Pay Band'!P28","v":0},null,0]
[null,"36-45",{"$f":"'2019 Data By Pay Band'!P29","v":2},null,0.25]
[null,"46-55",{"$f":"'2019 Data By Pay Band'!P30","v":4},null,0.5]
[null,"56-65",{"$f":"'2019 Data By Pay Band'!P31","v":2},null,0.25]
[null,">65",{"$f":"'2019 Data By Pay Band'!P32","v":0},null,0]
["Trainee Grade Doctor","16-25",null,{"$f":"'2019 Data By Pay Band'!Q27","v":47},null,{"$f":"D57/SUM($D$57:$D$62)","v":0.11519607843137254}]
[null,"26-35",null,{"$f":"'2019 Data By Pay Band'!Q28","v":278},null,0.68137254901960786]
[null,"36-45",null,{"$f":"'2019 Data By Pay Band'!Q29","v":60},null,0.14705882352941177]
[null,"46-55",null,{"$f":"'2019 Data By Pay Band'!Q30","v":17},null,4.1666666666666664E-2]
[null,"56-65",null,{"$f":"'2019 Data By Pay Band'!Q31","v":4},null,9.8039215686274508E-3]
[null,">65",null,{"$f":"'2019 Data By Pay Band'!Q32","v":2},null,4.9019607843137254E-3]
["Career Grade Doctor","16-25",{"$f":"'2019 Data By Pay Band'!R27","v":0},null,{"$f":"C63/SUM($C$63:$C$68)","v":0}]
[null,"26-35",{"$f":"'2019 Data By Pay Band'!R28","v":5},null,7.8125E-2]
[null,"36-45",{"$f":"'2019 Data By Pay Band'!R29","v":15},null,0.234375]
[null,"46-55",{"$f":"'2019 Data By Pay Band'!R30","v":25},null,0.390625]
[null,"56-65",{"$f":"'2019 Data By Pay Band'!R31","v":18},null,0.28125]
[null,">65",{"$f":"'2019 Data By Pay Band'!R32","v":1},null,1.5625E-2]
["Consultant","16-25",null,{"$f":"'2019 Data By Pay Band'!S27","v":0},null,{"$f":"D69/SUM($D$69:$D$74)","v":0}]
[null,"26-35",null,{"$f":"'2019 Data By Pay Band'!S28","v":17},null,{"$f":"D70/SUM($D$45:$D$50)","v":6.8273092369477914E-2}]
[null,"36-45",null,{"$f":"'2019 Data By Pay Band'!S29","v":112},null,{"$f":"D71/SUM($D$45:$D$50)","v":0.44979919678714858}]
[null,"46-55",null,{"$f":"'2019 Data By Pay Band'!S30","v":98},null,{"$f":"D72/SUM($D$45:$D$50)","v":0.39357429718875503}]
[null,"56-65",null,{"$f":"'2019 Data By Pay Band'!S31","v":44},null,{"$f":"D73/SUM($D$45:$D$50)","v":0.17670682730923695}]
[null,">65",null,{"$f":"'2019 Data By Pay Band'!S32","v":4},null,{"$f":"D74/SUM($D$45:$D$50)","v":1.6064257028112448E-2}]
["Other","16-25",{"$f":"'2019 Data By Pay Band'!T27","v":0},null,{"$f":"C75/SUM($C$75:$C$80)","v":0}]
[null,"26-35",{"$f":"'2019 Data By Pay Band'!T28","v":2},null,5.2631578947368418E-2]
[null,"36-45",{"$f":"'2019 Data By Pay Band'!T29","v":4},null,0.10526315789473684]
[null,"46-55",{"$f":"'2019 Data By Pay Band'!T30","v":14},null,0.36842105263157893]
[null,"56-65",{"$f":"'2019 Data By Pay Band'!T31","v":12},null,0.31578947368421051]
[null,">65",{"$f":"'2019 Data By Pay Band'!T32","v":6},null,0.15789473684210525]

{"sheet":"D Graph Data","index":5,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Disability","Value",null,"Percentage",null,null,"Dividers",4]
["Band 1","Y",{"$f":"'2019 Data By Pay Band'!H57","v":5},null,{"$f":"C3/SUM($C$3:$C$6)","v":0.14285714285714285},null,null,null,"X","Y"]
[null,"N",{"$f":"'2019 Data By Pay Band'!H58","v":21},null,{"$f":"C4/SUM($C$3:$C$6)","v":0.6},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"ND",{"$f":"'2019 Data By Pay Band'!H59","v":0},null,{"$f":"C5/SUM($C$3:$C$6)","v":0},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'2019 Data By Pay Band'!H60","v":9},null,{"$f":"C6/SUM($C$3:$C$6)","v":0.25714285714285712},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Band 2","Y",null,{"$f":"'2019 Data By Pay Band'!I57","v":80},null,{"$f":"D7/SUM($D$7:$D$10)","v":4.405286343612335E-2},null,4,16.5,0]
[null,"N",null,{"$f":"'2019 Data By Pay Band'!I58","v":1412},null,{"$f":"D8/SUM($D$7:$D$10)","v":0.77753303964757714},null,5,20.5,0]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!I59","v":13},null,{"$f":"D9/SUM($D$7:$D$10)","v":7.1585903083700442E-3},null,6,24.5,0]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!I60","v":311},null,{"$f":"D10/SUM($D$7:$D$10)","v":0.17125550660792951},null,7,28.5,0]
["Band 3","Y",{"$f":"'2019 Data By Pay Band'!J57","v":27},null,{"$f":"C11/SUM($C$11:$C$14)","v":4.0479760119940027E-2},null,null,8,32.5,0]
[null,"N",{"$f":"'2019 Data By Pay Band'!J58","v":504},null,{"$f":"C12/SUM($C$11:$C$14)","v":0.75562218890554722},null,null,9,36.5,0]
[null,"ND",{"$f":"'2019 Data By Pay Band'!J59","v":10},null,{"$f":"C13/SUM($C$11:$C$14)","v":1.4992503748125937E-2},null,null,10,40.5,0]
[null,"NR",{"$f":"'2019 Data By Pay Band'!J60","v":126},null,{"$f":"C14/SUM($C$11:$C$14)","v":0.18890554722638681},null,null,11,44.5,0]
["Band 4","Y",null,{"$f":"'2019 Data By Pay Band'!K57","v":15},null,{"$f":"D15/SUM($D$15:$D$18)","v":0.04},null,12,48.5,0]
[null,"N",null,{"$f":"'2019 Data By Pay Band'!K58","v":286},null,{"$f":"D16/SUM($D$15:$D$18)","v":0.76266666666666671}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!K59","v":7},null,{"$f":"D17/SUM($D$15:$D$18)","v":1.8666666666666668E-2}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!K60","v":67},null,{"$f":"D18/SUM($D$15:$D$18)","v":0.17866666666666667}]
["Band 5","Y",{"$f":"'2019 Data By Pay Band'!L57","v":33},null,{"$f":"C19/SUM($C$19:$C$22)","v":2.6894865525672371E-2}]
[null,"N",{"$f":"'2019 Data By Pay Band'!L58","v":977},null,{"$f":"C20/SUM($C$19:$C$22)","v":0.79625101874490622}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!L59","v":17},null,{"$f":"C21/SUM($C$19:$C$22)","v":1.3854930725346373E-2}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!L60","v":200},null,{"$f":"C22/SUM($C$19:$C$22)","v":0.16299918500407498}]
["Band 6","Y",null,{"$f":"'2019 Data By Pay Band'!M57","v":26},null,{"$f":"D23/SUM($D$23:$D$26)","v":2.9279279279279279E-2}]
[null,"N",null,{"$f":"'2019 Data By Pay Band'!M58","v":686},null,{"$f":"D24/SUM($D$23:$D$26)","v":0.77252252252252251}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!M59","v":24},null,{"$f":"D25/SUM($D$23:$D$26)","v":2.7027027027027029E-2}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!M60","v":152},null,{"$f":"D26/SUM($D$23:$D$26)","v":0.17117117117117117}]
["Band 7","Y",{"$f":"'2019 Data By Pay Band'!N57","v":16},null,{"$f":"C27/SUM($C$27:$C$30)","v":3.0710172744721688E-2}]
[null,"N",{"$f":"'2019 Data By Pay Band'!N58","v":341},null,{"$f":"C28/SUM($C$27:$C$30)","v":0.65451055662188096}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!N59","v":6},null,{"$f":"C29/SUM($C$27:$C$30)","v":1.1516314779270634E-2}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!N60","v":158},null,{"$f":"C30/SUM($C$27:$C$30)","v":0.30326295585412666}]
["Band 8","Y",null,{"$f":"'2019 Data By Pay Band'!O57","v":4},null,{"$f":"D31/SUM($D$31:$D$34)","v":1.6064257028112448E-2}]
[null,"N",null,{"$f":"'2019 Data By Pay Band'!O58","v":182},null,{"$f":"D32/SUM($D$31:$D$34)","v":0.73092369477911645}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!O59","v":0},null,{"$f":"D33/SUM($D$31:$D$34)","v":0}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!O60","v":63},null,{"$f":"D34/SUM($D$31:$D$34)","v":0.25301204819277107}]
["Band 9","Y",{"$f":"'2019 Data By Pay Band'!P57","v":0},null,{"$f":"C35/SUM($C$35:$C$38)","v":0}]
[null,"N",{"$f":"'2019 Data By Pay Band'!P58","v":6},null,{"$f":"C36/SUM($C$35:$C$38)","v":0.75}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!P59","v":0},null,{"$f":"C37/SUM($C$35:$C$38)","v":0}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!P60","v":2},null,{"$f":"C38/SUM($C$35:$C$38)","v":0.25}]
["Trainee Grade Doctor","Y",null,{"$f":"'2019 Data By Pay Band'!Q57","v":3},null,{"$f":"D39/SUM($D$39:$D$42)","v":7.3529411764705881E-3}]
[null,"N",null,{"$f":"'2019 Data By Pay Band'!Q58","v":387},null,{"$f":"D40/SUM($D$39:$D$42)","v":0.94852941176470584}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!Q59","v":13},null,{"$f":"D41/SUM($D$39:$D$42)","v":3.1862745098039214E-2}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!Q60","v":5},null,{"$f":"D42/SUM($D$39:$D$42)","v":1.2254901960784314E-2}]
["Career Grade Doctor","Y",{"$f":"'2019 Data By Pay Band'!R57","v":0},null,{"$f":"C43/SUM($C$43:$C$46)","v":0}]
[null,"N",{"$f":"'2019 Data By Pay Band'!R58","v":28},null,{"$f":"C44/SUM($C$43:$C$46)","v":0.4375}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!R59","v":1},null,{"$f":"C45/SUM($C$43:$C$46)","v":1.5625E-2}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!R60","v":35},null,{"$f":"C46/SUM($C$43:$C$46)","v":0.546875}]
["Consultant","Y",null,{"$f":"'2019 Data By Pay Band'!S57","v":0},null,{"$f":"D47/SUM($D$47:$D$50)","v":0}]
[null,"N",null,{"$f":"'2019 Data By Pay Band'!S58","v":182},null,{"$f":"D48/SUM($D$31:$D$34)","v":0.73092369477911645}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!S59","v":0},null,{"$f":"D49/SUM($D$31:$D$34)","v":0}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!S60","v":93},null,{"$f":"D50/SUM($D$31:$D$34)","v":0.37349397590361444}]
["Other","Y",{"$f":"'2019 Data By Pay Band'!T57","v":1},null,{"$f":"C51/SUM($C$51:$C$54)","v":2.6315789473684209E-2}]
[null,"N",{"$f":"'2019 Data By Pay Band'!T58","v":23},null,{"$f":"C52/SUM($C$51:$C$54)","v":0.60526315789473684}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!T59","v":1},null,{"$f":"C53/SUM($C$51:$C$54)","v":2.6315789473684209E-2}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!T60","v":13},null,{"$f":"C54/SUM($C$51:$C$54)","v":0.34210526315789475}]

{"sheet":"E Graph Data","index":6,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Ethnicity","Value",null,"Percentage",null,null,"Dividers",4]
["Band 1","WB",{"$f":"'2019 Data By Pay Band'!H85","v":15},null,{"$f":"C3/SUM($C$3:$C$6)","v":0.42857142857142855},null,null,null,"X","Y"]
[null,"WO",{"$f":"'2019 Data By Pay Band'!H86","v":11},null,{"$f":"C4/SUM($C$3:$C$6)","v":0.31428571428571428},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"BME",{"$f":"'2019 Data By Pay Band'!H87","v":9},null,{"$f":"C5/SUM($C$3:$C$6)","v":0.25714285714285712},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'2019 Data By Pay Band'!H88","v":0},null,{"$f":"C6/SUM($C$3:$C$6)","v":0},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Band 2","WB",null,{"$f":"'2019 Data By Pay Band'!I85","v":1327},null,{"$f":"D7/SUM($D$7:$D$10)","v":0.73072687224669608},null,4,16.5,0]
[null,"WO",null,{"$f":"'2019 Data By Pay Band'!I86","v":206},null,{"$f":"D8/SUM($D$7:$D$10)","v":0.11343612334801761},null,5,20.5,0]
[null,"BME",null,{"$f":"'2019 Data By Pay Band'!I87","v":261},null,{"$f":"D9/SUM($D$7:$D$10)","v":0.14372246696035243},null,6,24.5,0]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!I88","v":22},null,{"$f":"D10/SUM($D$7:$D$10)","v":1.2114537444933921E-2},null,7,28.5,0]
["Band 3","WB",{"$f":"'2019 Data By Pay Band'!J85","v":582},null,{"$f":"C11/SUM($C$11:$C$14)","v":0.87256371814092959},null,null,8,32.5,0]
[null,"WO",{"$f":"'2019 Data By Pay Band'!J86","v":43},null,{"$f":"C12/SUM($C$11:$C$14)","v":6.4467766116941536E-2},null,null,9,36.5,0]
[null,"BME",{"$f":"'2019 Data By Pay Band'!J87","v":34},null,{"$f":"C13/SUM($C$11:$C$14)","v":5.0974512743628186E-2},null,null,10,40.5,0]
[null,"NR",{"$f":"'2019 Data By Pay Band'!J88","v":8},null,{"$f":"C14/SUM($C$11:$C$14)","v":1.1994002998500749E-2},null,null,11,44.5,0]
["Band 4","WB",null,{"$f":"'2019 Data By Pay Band'!K85","v":301},null,{"$f":"D15/SUM($D$15:$D$18)","v":0.80266666666666664},null,12,48.5,0]
[null,"WO",null,{"$f":"'2019 Data By Pay Band'!K86","v":23},null,{"$f":"D16/SUM($D$15:$D$18)","v":6.133333333333333E-2}]
[null,"BME",null,{"$f":"'2019 Data By Pay Band'!K87","v":48},null,{"$f":"D17/SUM($D$15:$D$18)","v":0.128}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!K88","v":3},null,{"$f":"D18/SUM($D$15:$D$18)","v":8.0000000000000002E-3}]
["Band 5","WB",{"$f":"'2019 Data By Pay Band'!L85","v":842},null,{"$f":"C19/SUM($C$19:$C$22)","v":0.68622656886715572}]
[null,"WO",{"$f":"'2019 Data By Pay Band'!L86","v":123},null,{"$f":"C20/SUM($C$19:$C$22)","v":0.10024449877750612}]
[null,"BME",{"$f":"'2019 Data By Pay Band'!L87","v":247},null,{"$f":"C21/SUM($C$19:$C$22)","v":0.20130399348003261}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!L88","v":15},null,{"$f":"C22/SUM($C$19:$C$22)","v":1.2224938875305624E-2}]
["Band 6","WB",null,{"$f":"'2019 Data By Pay Band'!M85","v":732},null,{"$f":"D23/SUM($D$23:$D$26)","v":0.82432432432432434}]
[null,"WO",null,{"$f":"'2019 Data By Pay Band'!M86","v":84},null,{"$f":"D24/SUM($D$23:$D$26)","v":9.45945945945946E-2}]
[null,"BME",null,{"$f":"'2019 Data By Pay Band'!M87","v":65},null,{"$f":"D25/SUM($D$23:$D$26)","v":7.31981981981982E-2}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!M88","v":7},null,{"$f":"D26/SUM($D$23:$D$26)","v":7.8828828828828822E-3}]
["Band 7","WB",{"$f":"'2019 Data By Pay Band'!N85","v":447},null,{"$f":"C27/SUM($C$27:$C$30)","v":0.85796545105566224}]
[null,"WO",{"$f":"'2019 Data By Pay Band'!N86","v":38},null,{"$f":"C28/SUM($C$27:$C$30)","v":7.293666026871401E-2}]
[null,"BME",{"$f":"'2019 Data By Pay Band'!N87","v":30},null,{"$f":"C29/SUM($C$27:$C$30)","v":5.7581573896353169E-2}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!N88","v":6},null,{"$f":"C30/SUM($C$27:$C$30)","v":1.1516314779270634E-2}]
["Band 8","WB",null,{"$f":"'2019 Data By Pay Band'!O85","v":217},null,{"$f":"D31/SUM($D$31:$D$34)","v":0.87148594377510036}]
[null,"WO",null,{"$f":"'2019 Data By Pay Band'!O86","v":20},null,{"$f":"D32/SUM($D$31:$D$34)","v":8.0321285140562249E-2}]
[null,"BME",null,{"$f":"'2019 Data By Pay Band'!O87","v":10},null,{"$f":"D33/SUM($D$31:$D$34)","v":4.0160642570281124E-2}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!O88","v":2},null,{"$f":"D34/SUM($D$31:$D$34)","v":8.0321285140562242E-3}]
["Band 9","WB",{"$f":"'2019 Data By Pay Band'!P85","v":6},null,{"$f":"C35/SUM($C$35:$C$38)","v":0.75}]
[null,"WO",{"$f":"'2019 Data By Pay Band'!P86","v":2},null,{"$f":"C36/SUM($C$35:$C$38)","v":0.25}]
[null,"BME",{"$f":"'2019 Data By Pay Band'!P87","v":0},null,{"$f":"C37/SUM($C$35:$C$38)","v":0}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!P88","v":0},null,{"$f":"C38/SUM($C$35:$C$38)","v":0}]
["Trainee Grade Doctor","WB",null,{"$f":"'2019 Data By Pay Band'!Q85","v":282},null,{"$f":"D39/SUM($D$39:$D$42)","v":0.69117647058823528}]
[null,"WO",null,{"$f":"'2019 Data By Pay Band'!Q86","v":54},null,{"$f":"D40/SUM($D$39:$D$42)","v":0.13235294117647059}]
[null,"BME",null,{"$f":"'2019 Data By Pay Band'!Q87","v":62},null,{"$f":"D41/SUM($D$39:$D$42)","v":0.15196078431372548}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!Q88","v":10},null,{"$f":"D42/SUM($D$39:$D$42)","v":2.4509803921568627E-2}]
["Career Grade Doctor","WB",{"$f":"'2019 Data By Pay Band'!R85","v":37},null,{"$f":"C43/SUM($C$43:$C$46)","v":0.578125}]
[null,"WO",{"$f":"'2019 Data By Pay Band'!R86","v":7},null,{"$f":"C44/SUM($C$43:$C$46)","v":0.109375}]
[null,"BME",{"$f":"'2019 Data By Pay Band'!R87","v":20},null,{"$f":"C45/SUM($C$43:$C$46)","v":0.3125}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!R88","v":0},null,{"$f":"C46/SUM($C$43:$C$46)","v":0}]
["Consultant","WB",null,{"$f":"'2019 Data By Pay Band'!S85","v":214},null,{"$f":"D47/SUM($D$47:$D$50)","v":0.7781818181818182}]
[null,"WO",null,{"$f":"'2019 Data By Pay Band'!S86","v":22},null,{"$f":"D48/SUM($D$31:$D$34)","v":8.8353413654618476E-2}]
[null,"BME",null,{"$f":"'2019 Data By Pay Band'!S87","v":37},null,{"$f":"D49/SUM($D$31:$D$34)","v":0.14859437751004015}]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!S88","v":2},null,{"$f":"D50/SUM($D$31:$D$34)","v":8.0321285140562242E-3}]
["Other","WB",{"$f":"'2019 Data By Pay Band'!T85","v":30},null,{"$f":"C51/SUM($C$51:$C$54)","v":0.78947368421052633}]
[null,"WO",{"$f":"'2019 Data By Pay Band'!T86","v":2},null,{"$f":"C52/SUM($C$51:$C$54)","v":5.2631578947368418E-2}]
[null,"BME",{"$f":"'2019 Data By Pay Band'!T87","v":0},null,{"$f":"C53/SUM($C$51:$C$54)","v":0}]
[null,"NR",{"$f":"'2019 Data By Pay Band'!T88","v":6},null,{"$f":"C54/SUM($C$51:$C$54)","v":0.15789473684210525}]

{"sheet":"G Graph Data","index":7,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Gender","Value",null,"Percentage",null,null,"Dividers",2]
["Band 1","F",{"$f":"'2019 Data By Pay Band'!H113","v":18},null,{"$f":"C3/SUM($C$3:$C$4)","v":0.51428571428571423},null,null,null,"X","Y"]
[null,"M",{"$f":"'2019 Data By Pay Band'!H114","v":17},null,{"$f":"C4/SUM($C$3:$C$4)","v":0.48571428571428571},null,null,1,{"$f":"$I$2*H4+0.5","v":2.5},0]
["Band 2","F",null,{"$f":"'2019 Data By Pay Band'!I113","v":1354},null,{"$f":"D5/SUM($D$5:$D$6)","v":0.74559471365638763},null,2,{"$f":"$I$2*H5+0.5","v":4.5},0]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!I114","v":462},null,{"$f":"D6/SUM($D$5:$D$6)","v":0.25440528634361231},null,3,{"$f":"$I$2*H6+0.5","v":6.5},0]
["Band 3","F",{"$f":"'2019 Data By Pay Band'!J113","v":560},null,{"$f":"C7/SUM($C$7:$C$8)","v":0.83958020989505244},null,null,4,8.5,0]
[null,"M",{"$f":"'2019 Data By Pay Band'!J114","v":107},null,{"$f":"C8/SUM($C$7:$C$8)","v":0.16041979010494753},null,null,5,10.5,0]
["Band 4","F",null,{"$f":"'2019 Data By Pay Band'!K113","v":306},null,{"$f":"D9/SUM($D$9:$D$10)","v":0.81599999999999995},null,6,12.5,0]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!K114","v":69},null,{"$f":"D10/SUM($D$9:$D$10)","v":0.184},null,7,14.5,0]
["Band 5","F",{"$f":"'2019 Data By Pay Band'!L113","v":1053},null,{"$f":"C11/SUM($C$11:$C$12)","v":0.85819070904645478},null,null,8,16.5,0]
[null,"M",{"$f":"'2019 Data By Pay Band'!L114","v":174},null,{"$f":"C12/SUM($C$11:$C$12)","v":0.14180929095354522},null,null,9,18.5,0]
["Band 6","F",null,{"$f":"'2019 Data By Pay Band'!M113","v":768},null,{"$f":"D13/SUM($D$13:$D$14)","v":0.86486486486486491},null,10,20.5,0]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!M114","v":120},null,{"$f":"D14/SUM($D$13:$D$14)","v":0.13513513513513514},null,11,22.5,0]
["Band 7","F",{"$f":"'2019 Data By Pay Band'!N113","v":427},null,{"$f":"C15/SUM($C$15:$C$16)","v":0.81957773512476007},null,null,12,24.5,0]
[null,"M",{"$f":"'2019 Data By Pay Band'!N114","v":94},null,{"$f":"C16/SUM($C$15:$C$16)","v":0.18042226487523993}]
["Band 8","F",null,{"$f":"'2019 Data By Pay Band'!O113","v":177},null,{"$f":"D17/SUM($D$17:$D$18)","v":0.71084337349397586}]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!O114","v":72},null,{"$f":"D18/SUM($D$17:$D$18)","v":0.28915662650602408}]
["Band 9","F",{"$f":"'2019 Data By Pay Band'!P113","v":5},null,{"$f":"C19/SUM($C$19:$C$20)","v":0.625}]
[null,"M",{"$f":"'2019 Data By Pay Band'!P114","v":3},null,{"$f":"C20/SUM($C$19:$C$20)","v":0.375}]
["Trainee Grade Doctor","F",null,{"$f":"'2019 Data By Pay Band'!Q113","v":237},null,{"$f":"D21/SUM($D$21:$D$22)","v":0.58088235294117652}]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!Q114","v":171},null,{"$f":"D22/SUM($D$21:$D$22)","v":0.41911764705882354}]
["Career Grade Doctor","F",{"$f":"'2019 Data By Pay Band'!R113","v":35},null,{"$f":"C23/SUM($C$23:$C$24)","v":0.546875}]
[null,"M",{"$f":"'2019 Data By Pay Band'!R114","v":29},null,{"$f":"C24/SUM($C$23:$C$24)","v":0.453125}]
["Consultant","F",null,{"$f":"'2019 Data By Pay Band'!S113","v":101},null,{"$f":"D25/SUM($D$25:$D$26)","v":0.36727272727272725}]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!S114","v":174},null,{"$f":"D26/SUM($D$17:$D$18)","v":0.6987951807228916}]
["Other","F",{"$f":"'2019 Data By Pay Band'!T113","v":21},null,{"$f":"C27/SUM($C$27:$C$28)","v":0.55263157894736847}]
[null,"M",{"$f":"'2019 Data By Pay Band'!T114","v":17},null,{"$f":"C28/SUM($C$27:$C$28)","v":0.44736842105263158}]

{"sheet":"RB Graph Data","index":8,"n_rows":132,"n_cols":10,"rows_kept":132,"cut":false,"hidden":true,"merged":[[1,4,1,5],[1,2,1,3]]}
[]
[null,"Religious Belief ","Value",null,"Percentage",null,null,"Dividers",10]
["Band 1","A",{"$f":"'2019 Data By Pay Band'!H172","v":0},null,{"$f":"C3/SUM($C$3:$C$12)","v":0},null,null,null,"X","Y"]
[null,"B",{"$f":"'2019 Data By Pay Band'!H173","v":0},null,{"$f":"C4/SUM($C$3:$C$12)","v":0},null,null,1,{"$f":"$I$2*H4+0.5","v":10.5},0]
[null,"C",{"$f":"'2019 Data By Pay Band'!H174","v":21},null,0.6,null,null,2,{"$f":"$I$2*H5+0.5","v":20.5},0]
[null,"H",{"$f":"'2019 Data By Pay Band'!H175","v":0},null,0,null,null,3,{"$f":"$I$2*H6+0.5","v":30.5},0]
[null,"I",{"$f":"'2019 Data By Pay Band'!H176","v":1},null,2.8571428571428571E-2,null,null,4,40.5,0]
[null,"J",{"$f":"'2019 Data By Pay Band'!H177","v":0},null,0,null,null,5,50.5,0]
[null,"S",{"$f":"'2019 Data By Pay Band'!H178","v":0},null,0,null,null,6,60.5,0]
[null,"O",{"$f":"'2019 Data By Pay Band'!H179","v":0},null,0,null,null,7,70.5,0]
[null,"ND",{"$f":"'2019 Data By Pay Band'!H180","v":6},null,0.17142857142857143,null,null,8,80.5,0]
[null,"NR",{"$f":"'2019 Data By Pay Band'!H181","v":7},null,0.2,null,null,9,90.5,0]
["Band 2","A",null,{"$f":"'2019 Data By Pay Band'!I172","v":288},null,{"$f":"D13/SUM($D$13:$D$22)","v":0.15859030837004406},null,10,100.5,0]
[null,"B",null,{"$f":"'2019 Data By Pay Band'!I173","v":17},null,9.3612334801762113E-3,null,11,110.5,0]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!I174","v":824},null,0.45374449339207046,null,12,120.5,0]
[null,"H",null,{"$f":"'2019 Data By Pay Band'!I175","v":11},null,6.0572687224669606E-3]
[null,"I",null,{"$f":"'2019 Data By Pay Band'!I176","v":16},null,8.8105726872246704E-3]
[null,"J",null,{"$f":"'2019 Data By Pay Band'!I177","v":0},null,0]
[null,"S",null,{"$f":"'2019 Data By Pay Band'!I178","v":1},null,5.506607929515419E-4]
[null,"O",null,{"$f":"'2019 Data By Pay Band'!I179","v":190},null,0.10462555066079295]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!I180","v":246},null,0.13546255506607929]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!I181","v":223},null,0.12279735682819383]
["Band 3","A",{"$f":"'2019 Data By Pay Band'!J172","v":117},null,{"$f":"C23/SUM($C$23:$C$32)","v":0.17541229385307347}]
[null,"B",{"$f":"'2019 Data By Pay Band'!J173","v":2},null,{"$f":"C24/SUM($C$23:$C$32)","v":2.9985007496251873E-3}]
[null,"C",{"$f":"'2019 Data By Pay Band'!J174","v":301},null,0.45127436281859068]
[null,"H",{"$f":"'2019 Data By Pay Band'!J175","v":0},null,0]
[null,"I",{"$f":"'2019 Data By Pay Band'!J176","v":4},null,5.9970014992503746E-3]
[null,"J",{"$f":"'2019 Data By Pay Band'!J177","v":0},null,0]
[null,"S",{"$f":"'2019 Data By Pay Band'!J178","v":0},null,0]
[null,"O",{"$f":"'2019 Data By Pay Band'!J179","v":73},null,0.10944527736131934]
[null,"ND",{"$f":"'2019 Data By Pay Band'!J180","v":100},null,0.14992503748125938]
[null,"NR",{"$f":"'2019 Data By Pay Band'!J181","v":70},null,0.10494752623688156]
["Band 4","A",null,{"$f":"'2019 Data By Pay Band'!K172","v":75},null,{"$f":"D33/SUM($D$33:$D$42)","v":0.2}]
[null,"B",null,{"$f":"'2019 Data By Pay Band'!K173","v":0},null,0]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!K174","v":177},null,0.47199999999999998]
[null,"H",null,{"$f":"'2019 Data By Pay Band'!K175","v":1},null,2.6666666666666666E-3]
[null,"I",null,{"$f":"'2019 Data By Pay Band'!K176","v":1},null,2.6666666666666666E-3]
[null,"J",null,{"$f":"'2019 Data By Pay Band'!K177","v":1},null,2.6666666666666666E-3]
[null,"S",null,{"$f":"'2019 Data By Pay Band'!K178","v":0},null,0]
[null,"O",null,{"$f":"'2019 Data By Pay Band'!K179","v":36},null,9.6000000000000002E-2]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!K180","v":44},null,0.11733333333333333]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!K181","v":40},null,0.10666666666666667]
["Band 5","A",{"$f":"'2019 Data By Pay Band'!L172","v":214},null,{"$f":"C43/SUM($C$43:$C$52)","v":0.17440912795436023}]
[null,"B",{"$f":"'2019 Data By Pay Band'!L173","v":6},null,{"$f":"C44/SUM($C$43:$C$52)","v":4.8899755501222494E-3}]
[null,"C",{"$f":"'2019 Data By Pay Band'!L174","v":588},null,0.47921760391198043]
[null,"H",{"$f":"'2019 Data By Pay Band'!L175","v":8},null,6.5199674001629989E-3]
[null,"I",{"$f":"'2019 Data By Pay Band'!L176","v":8},null,6.5199674001629989E-3]
[null,"J",{"$f":"'2019 Data By Pay Band'!L177","v":2},null,1.6299918500407497E-3]
[null,"S",{"$f":"'2019 Data By Pay Band'!L178","v":1},null,8.1499592502037486E-4]
[null,"O",{"$f":"'2019 Data By Pay Band'!L179","v":96},null,7.823960880195599E-2]
[null,"ND",{"$f":"'2019 Data By Pay Band'!L180","v":168},null,0.13691931540342298]
[null,"NR",{"$f":"'2019 Data By Pay Band'!L181","v":136},null,0.11083944580277098]
["Band 6","A",null,{"$f":"'2019 Data By Pay Band'!M172","v":139},null,{"$f":"D53/SUM($D$53:$D$62)","v":0.15653153153153154}]
[null,"B",null,{"$f":"'2019 Data By Pay Band'!M173","v":2},null,2.2522522522522522E-3]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!M174","v":439},null,0.49436936936936937]
[null,"H",null,{"$f":"'2019 Data By Pay Band'!M175","v":4},null,4.5045045045045045E-3]
[null,"I",null,{"$f":"'2019 Data By Pay Band'!M176","v":4},null,4.5045045045045045E-3]
[null,"J",null,{"$f":"'2019 Data By Pay Band'!M177","v":1},null,1.1261261261261261E-3]
[null,"S",null,{"$f":"'2019 Data By Pay Band'!M178","v":1},null,1.1261261261261261E-3]
[null,"O",null,{"$f":"'2019 Data By Pay Band'!M179","v":65},null,7.31981981981982E-2]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!M180","v":154},null,0.17342342342342343]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!M181","v":79},null,8.8963963963963957E-2]
["Band 7","A",{"$f":"'2019 Data By Pay Band'!N172","v":82},null,{"$f":"C63/SUM($C$63:$C$72)","v":0.15738963531669867}]
[null,"B",{"$f":"'2019 Data By Pay Band'!N173","v":1},null,{"$f":"C64/SUM($C$63:$C$72)","v":1.9193857965451055E-3}]
[null,"C",{"$f":"'2019 Data By Pay Band'!N174","v":215},null,0.41266794625719772]
[null,"H",{"$f":"'2019 Data By Pay Band'!N175","v":3},null,5.7581573896353169E-3]
[null,"I",{"$f":"'2019 Data By Pay Band'!N176","v":0},null,0]
[null,"J",{"$f":"'2019 Data By Pay Band'!N177","v":1},null,1.9193857965451055E-3]
[null,"S",{"$f":"'2019 Data By Pay Band'!N178","v":0},null,0]
[null,"O",{"$f":"'2019 Data By Pay Band'!N179","v":33},null,6.3339731285988479E-2]
[null,"ND",{"$f":"'2019 Data By Pay Band'!N180","v":95},null,0.18234165067178504]
[null,"NR",{"$f":"'2019 Data By Pay Band'!N181","v":91},null,0.1746641074856046]
["Band 8","A",null,{"$f":"'2019 Data By Pay Band'!O172","v":37},null,{"$f":"D73/SUM($D$73:$D$82)","v":0.14859437751004015}]
[null,"B",null,{"$f":"'2019 Data By Pay Band'!O173","v":0},null,0]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!O174","v":118},null,0.47389558232931728]
[null,"H",null,{"$f":"'2019 Data By Pay Band'!O175","v":2},null,8.0321285140562242E-3]
[null,"I",null,{"$f":"'2019 Data By Pay Band'!O176","v":1},null,4.0160642570281121E-3]
[null,"J",null,{"$f":"'2019 Data By Pay Band'!O177","v":0},null,0]
[null,"S",null,{"$f":"'2019 Data By Pay Band'!O178","v":1},null,4.0160642570281121E-3]
[null,"O",null,{"$f":"'2019 Data By Pay Band'!O179","v":12},null,4.8192771084337352E-2]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!O180","v":41},null,0.1646586345381526]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!O181","v":37},null,0.14859437751004015]
["Band 9","A",{"$f":"'2019 Data By Pay Band'!P172","v":0},null,{"$f":"C83/SUM($C$83:$C$92)","v":0}]
[null,"B",{"$f":"'2019 Data By Pay Band'!P173","v":0},null,{"$f":"C84/SUM($C$83:$C$92)","v":0}]
[null,"C",{"$f":"'2019 Data By Pay Band'!P174","v":3},null,0.375]
[null,"H",{"$f":"'2019 Data By Pay Band'!P175","v":0},null,0]
[null,"I",{"$f":"'2019 Data By Pay Band'!P176","v":0},null,0]
[null,"J",{"$f":"'2019 Data By Pay Band'!P177","v":0},null,0]
[null,"S",{"$f":"'2019 Data By Pay Band'!P178","v":0},null,0]
[null,"O",{"$f":"'2019 Data By Pay Band'!P179","v":1},null,0.125]
[null,"ND",{"$f":"'2019 Data By Pay Band'!P180","v":3},null,0.375]
[null,"NR",{"$f":"'2019 Data By Pay Band'!P181","v":1},null,0.125]
["Trainee Grade Doctor","A",null,{"$f":"'2019 Data By Pay Band'!Q172","v":129},null,{"$f":"D93/SUM($D$93:$D$102)","v":0.31617647058823528}]
[null,"B",null,{"$f":"'2019 Data By Pay Band'!Q173","v":2},null,{"$f":"D94/SUM($D$93:$D$102)","v":4.9019607843137254E-3}]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!Q174","v":123},null,0.3014705882352941]
[null,"H",null,{"$f":"'2019 Data By Pay Band'!Q175","v":13},null,3.1862745098039214E-2]
[null,"I",null,{"$f":"'2019 Data By Pay Band'!Q176","v":8},null,1.9607843137254902E-2]
[null,"J",null,{"$f":"'2019 Data By Pay Band'!Q177","v":0},null,0]
[null,"S",null,{"$f":"'2019 Data By Pay Band'!Q178","v":2},null,4.9019607843137254E-3]
[null,"O",null,{"$f":"'2019 Data By Pay Band'!Q179","v":34},null,8.3333333333333329E-2]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!Q180","v":93},null,0.22794117647058823]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!Q181","v":4},null,9.8039215686274508E-3]
["Career Grade Doctor","A",{"$f":"'2019 Data By Pay Band'!R172","v":2},null,{"$f":"C103/SUM($C$103:$C$112)","v":3.125E-2}]
[null,"B",{"$f":"'2019 Data By Pay Band'!R173","v":0},null,{"$f":"C104/SUM($C$103:$C$112)","v":0}]
[null,"C",{"$f":"'2019 Data By Pay Band'!R174","v":18},null,0.28125]
[null,"H",{"$f":"'2019 Data By Pay Band'!R175","v":3},null,4.6875E-2]
[null,"I",{"$f":"'2019 Data By Pay Band'!R176","v":3},null,4.6875E-2]
[null,"J",{"$f":"'2019 Data By Pay Band'!R177","v":0},null,0]
[null,"S",{"$f":"'2019 Data By Pay Band'!R178","v":1},null,1.5625E-2]
[null,"O",{"$f":"'2019 Data By Pay Band'!R179","v":3},null,4.6875E-2]
[null,"ND",{"$f":"'2019 Data By Pay Band'!R180","v":4},null,6.25E-2]
[null,"NR",{"$f":"'2019 Data By Pay Band'!R181","v":30},null,0.46875]
["Consultant","A",null,{"$f":"'2019 Data By Pay Band'!S172","v":39},null,{"$f":"D113/SUM($D$113:$D$122)","v":0.14181818181818182}]
[null,"B",null,{"$f":"'2019 Data By Pay Band'!S173","v":2},null,{"$f":"D114/SUM($D$73:$D$82)","v":8.0321285140562242E-3}]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!S174","v":91},null,0.36546184738955823]
[null,"H",null,{"$f":"'2019 Data By Pay Band'!S175","v":4},null,1.6064257028112448E-2]
[null,"I",null,{"$f":"'2019 Data By Pay Band'!S176","v":8},null,3.2128514056224897E-2]
[null,"J",null,{"$f":"'2019 Data By Pay Band'!S177","v":1},null,4.0160642570281121E-3]
[null,"S",null,{"$f":"'2019 Data By Pay Band'!S178","v":2},null,8.0321285140562242E-3]
[null,"O",null,{"$f":"'2019 Data By Pay Band'!S179","v":3},null,1.2048192771084338E-2]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!S180","v":42},null,0.16867469879518071]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!S181","v":83},null,0.33333333333333331]
["Other","A",{"$f":"'2019 Data By Pay Band'!T172","v":2},null,{"$f":"C123/SUM($C$123:$C$132)","v":5.2631578947368418E-2}]
[null,"B",{"$f":"'2019 Data By Pay Band'!T173","v":0},null,{"$f":"C124/SUM($C$123:$C$132)","v":0}]
[null,"C",{"$f":"'2019 Data By Pay Band'!T174","v":14},null,0.36842105263157893]
[null,"H",{"$f":"'2019 Data By Pay Band'!T175","v":0},null,0]
[null,"I",{"$f":"'2019 Data By Pay Band'!T176","v":0},null,0]
[null,"J",{"$f":"'2019 Data By Pay Band'!T177","v":0},null,0]
[null,"S",{"$f":"'2019 Data By Pay Band'!T178","v":0},null,0]
[null,"O",{"$f":"'2019 Data By Pay Band'!T179","v":2},null,5.2631578947368418E-2]
[null,"ND",{"$f":"'2019 Data By Pay Band'!T180","v":5},null,0.13157894736842105]
[null,"NR",{"$f":"'2019 Data By Pay Band'!T181","v":15},null,0.39473684210526316]

{"sheet":"RS Graph Data","index":9,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Relationship Status","Value",null,"Percentage",null,null,"Dividers",7]
["Band 1","S",{"$f":"'2019 Data By Pay Band'!H141","v":14},null,{"$f":"C3/SUM($C$3:$C$9)","v":0.4},null,null,null,"X","Y"]
[null,"M",{"$f":"'2019 Data By Pay Band'!H142","v":21},null,0.6,null,null,1,{"$f":"$I$2*H4+0.5","v":7.5},0]
[null,"C",{"$f":"'2019 Data By Pay Band'!H143","v":0},null,0,null,null,2,{"$f":"$I$2*H5+0.5","v":14.5},0]
[null,"D",{"$f":"'2019 Data By Pay Band'!H144","v":0},null,0,null,null,3,{"$f":"$I$2*H6+0.5","v":21.5},0]
[null,"LS",{"$f":"'2019 Data By Pay Band'!H145","v":0},null,0,null,null,4,28.5,0]
[null,"W",{"$f":"'2019 Data By Pay Band'!H146","v":0},null,0,null,null,5,35.5,0]
[null,"NR",{"$f":"'2019 Data By Pay Band'!H147","v":0},null,0,null,null,6,42.5,0]
["Band 2","S",null,{"$f":"'2019 Data By Pay Band'!I141","v":821},null,{"$f":"D10/SUM($D$10:$D$16)","v":0.45209251101321585},null,7,49.5,0]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!I142","v":754},null,0.41519823788546256,null,8,56.5,0]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!I143","v":27},null,1.4867841409691629E-2,null,9,63.5,0]
[null,"D",null,{"$f":"'2019 Data By Pay Band'!I144","v":118},null,6.4977973568281944E-2,null,10,70.5,0]
[null,"LS",null,{"$f":"'2019 Data By Pay Band'!I145","v":23},null,1.2665198237885462E-2,null,11,77.5,0]
[null,"W",null,{"$f":"'2019 Data By Pay Band'!I146","v":22},null,1.2114537444933921E-2,null,12,84.5,0]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!I147","v":51},null,2.8083700440528634E-2]
["Band 3","S",{"$f":"'2019 Data By Pay Band'!J141","v":205},null,{"$f":"C17/SUM($C$17:$C$23)","v":0.3073463268365817}]
[null,"M",{"$f":"'2019 Data By Pay Band'!J142","v":346},null,0.51874062968515744]
[null,"C",{"$f":"'2019 Data By Pay Band'!J143","v":16},null,2.3988005997001498E-2]
[null,"D",{"$f":"'2019 Data By Pay Band'!J144","v":60},null,8.9955022488755629E-2]
[null,"LS",{"$f":"'2019 Data By Pay Band'!J145","v":11},null,1.6491754122938532E-2]
[null,"W",{"$f":"'2019 Data By Pay Band'!J146","v":7},null,1.0494752623688156E-2]
[null,"NR",{"$f":"'2019 Data By Pay Band'!J147","v":22},null,3.2983508245877063E-2]
["Band 4","S",null,{"$f":"'2019 Data By Pay Band'!K141","v":159},null,{"$f":"D24/SUM($D$24:$D$30)","v":0.42399999999999999}]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!K142","v":165},null,0.44]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!K143","v":6},null,1.6E-2]
[null,"D",null,{"$f":"'2019 Data By Pay Band'!K144","v":29},null,7.7333333333333337E-2]
[null,"LS",null,{"$f":"'2019 Data By Pay Band'!K145","v":4},null,1.0666666666666666E-2]
[null,"W",null,{"$f":"'2019 Data By Pay Band'!K146","v":2},null,5.3333333333333332E-3]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!K147","v":10},null,2.6666666666666668E-2]
["Band 5","S",{"$f":"'2019 Data By Pay Band'!L141","v":532},null,{"$f":"C31/SUM($C$31:$C$37)","v":0.43357783211083945}]
[null,"M",{"$f":"'2019 Data By Pay Band'!L142","v":573},null,0.4669926650366748]
[null,"C",{"$f":"'2019 Data By Pay Band'!L143","v":11},null,8.9649551752241236E-3]
[null,"D",{"$f":"'2019 Data By Pay Band'!L144","v":55},null,4.4824775876120618E-2]
[null,"LS",{"$f":"'2019 Data By Pay Band'!L145","v":5},null,4.0749796251018742E-3]
[null,"W",{"$f":"'2019 Data By Pay Band'!L146","v":7},null,5.7049714751426246E-3]
[null,"NR",{"$f":"'2019 Data By Pay Band'!L147","v":44},null,3.5859820700896494E-2]
["Band 6","S",null,{"$f":"'2019 Data By Pay Band'!M141","v":292},null,{"$f":"D38/SUM($D$38:$D$44)","v":0.32882882882882886}]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!M142","v":521},null,0.58671171171171166]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!M143","v":6},null,6.7567567567567571E-3]
[null,"D",null,{"$f":"'2019 Data By Pay Band'!M144","v":33},null,3.7162162162162164E-2]
[null,"LS",null,{"$f":"'2019 Data By Pay Band'!M145","v":3},null,3.3783783783783786E-3]
[null,"W",null,{"$f":"'2019 Data By Pay Band'!M146","v":2},null,2.2522522522522522E-3]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!M147","v":31},null,3.4909909909909907E-2]
["Band 7","S",{"$f":"'2019 Data By Pay Band'!N141","v":141},null,{"$f":"C45/SUM($C$45:$C$51)","v":0.2706333973128599}]
[null,"M",{"$f":"'2019 Data By Pay Band'!N142","v":326},null,0.62571976967370446]
[null,"C",{"$f":"'2019 Data By Pay Band'!N143","v":6},null,1.1516314779270634E-2]
[null,"D",{"$f":"'2019 Data By Pay Band'!N144","v":24},null,4.6065259117082535E-2]
[null,"LS",{"$f":"'2019 Data By Pay Band'!N145","v":4},null,7.677543186180422E-3]
[null,"W",{"$f":"'2019 Data By Pay Band'!N146","v":3},null,5.7581573896353169E-3]
[null,"NR",{"$f":"'2019 Data By Pay Band'!N147","v":17},null,3.2629558541266791E-2]
["Band 8","S",null,{"$f":"'2019 Data By Pay Band'!O141","v":67},null,{"$f":"D52/SUM($D$52:$D$58)","v":0.26907630522088355}]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!O142","v":160},null,0.64257028112449799]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!O143","v":1},null,4.0160642570281121E-3]
[null,"D",null,{"$f":"'2019 Data By Pay Band'!O144","v":16},null,6.4257028112449793E-2]
[null,"LS",null,{"$f":"'2019 Data By Pay Band'!O145","v":3},null,1.2048192771084338E-2]
[null,"W",null,{"$f":"'2019 Data By Pay Band'!O146","v":0},null,0]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!O147","v":2},null,8.0321285140562242E-3]
["Band 9","S",{"$f":"'2019 Data By Pay Band'!P141","v":0},null,{"$f":"C59/SUM($C$59:$C$65)","v":0}]
[null,"M",{"$f":"'2019 Data By Pay Band'!P142","v":8},null,1]
[null,"C",{"$f":"'2019 Data By Pay Band'!P143","v":0},null,0]
[null,"D",{"$f":"'2019 Data By Pay Band'!P144","v":0},null,0]
[null,"LS",{"$f":"'2019 Data By Pay Band'!P145","v":0},null,0]
[null,"W",{"$f":"'2019 Data By Pay Band'!P146","v":0},null,0]
[null,"NR",{"$f":"'2019 Data By Pay Band'!P147","v":0},null,0]
["Trainee Grade Doctor","S",null,{"$f":"'2019 Data By Pay Band'!Q141","v":250},null,{"$f":"D66/SUM($D$66:$D$72)","v":0.61274509803921573}]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!Q142","v":127},null,0.31127450980392157]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!Q143","v":2},null,4.9019607843137254E-3]
[null,"D",null,{"$f":"'2019 Data By Pay Band'!Q144","v":3},null,7.3529411764705881E-3]
[null,"LS",null,{"$f":"'2019 Data By Pay Band'!Q145","v":0},null,0]
[null,"W",null,{"$f":"'2019 Data By Pay Band'!Q146","v":1},null,2.4509803921568627E-3]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!Q147","v":25},null,6.1274509803921566E-2]
["Career Grade Doctor","S",{"$f":"'2019 Data By Pay Band'!R141","v":12},null,{"$f":"C73/SUM($C$73:$C$79)","v":0.1875}]
[null,"M",{"$f":"'2019 Data By Pay Band'!R142","v":48},null,0.75]
[null,"C",{"$f":"'2019 Data By Pay Band'!R143","v":0},null,0]
[null,"D",{"$f":"'2019 Data By Pay Band'!R144","v":2},null,3.125E-2]
[null,"LS",{"$f":"'2019 Data By Pay Band'!R145","v":1},null,1.5625E-2]
[null,"W",{"$f":"'2019 Data By Pay Band'!R146","v":0},null,0]
[null,"NR",{"$f":"'2019 Data By Pay Band'!R147","v":1},null,1.5625E-2]
["Consultant","S",null,{"$f":"'2019 Data By Pay Band'!S141","v":52},null,{"$f":"D80/SUM($D$80:$D$86)","v":0.18909090909090909}]
[null,"M",null,{"$f":"'2019 Data By Pay Band'!S142","v":207},null,{"$f":"D81/SUM($D$52:$D$58)","v":0.83132530120481929}]
[null,"C",null,{"$f":"'2019 Data By Pay Band'!S143","v":2},null,8.0321285140562242E-3]
[null,"D",null,{"$f":"'2019 Data By Pay Band'!S144","v":4},null,1.6064257028112448E-2]
[null,"LS",null,{"$f":"'2019 Data By Pay Band'!S145","v":0},null,0]
[null,"W",null,{"$f":"'2019 Data By Pay Band'!S146","v":1},null,4.0160642570281121E-3]
[null,"NR",null,{"$f":"'2019 Data By Pay Band'!S147","v":9},null,3.614457831325301E-2]
["Other","S",{"$f":"'2019 Data By Pay Band'!T141","v":3},null,{"$f":"C87/SUM($C$87:$C$93)","v":7.8947368421052627E-2}]
[null,"M",{"$f":"'2019 Data By Pay Band'!T142","v":21},null,{"$f":"C88/SUM($C$87:$C$93)","v":0.55263157894736847}]
[null,"C",{"$f":"'2019 Data By Pay Band'!T143","v":0},null,0]
[null,"D",{"$f":"'2019 Data By Pay Band'!T144","v":1},null,2.6315789473684209E-2]
[null,"LS",{"$f":"'2019 Data By Pay Band'!T145","v":1},null,2.6315789473684209E-2]
[null,"W",{"$f":"'2019 Data By Pay Band'!T146","v":1},null,2.6315789473684209E-2]
[null,"NR",{"$f":"'2019 Data By Pay Band'!T147","v":11},null,0.28947368421052633]

{"sheet":"SO Graph Data","index":10,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Disability","Value",null,"Percentage",null,null,"Dividers",4]
["Band 1","H",{"$f":"'2019 Data By Pay Band'!H206","v":22},null,{"$f":"C3/SUM($C$3:$C$6)","v":0.81481481481481477},null,null,null,"X","Y"]
[null,"LGB",{"$f":"'2019 Data By Pay Band'!H207","v":0},null,{"$f":"C4/SUM($C$3:$C$6)","v":0},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"ND",{"$f":"'2019 Data By Pay Band'!H208","v":5},null,{"$f":"C5/SUM($C$3:$C$6)","v":0.18518518518518517},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR ",{"$f":"'2019 Data By Pay Band'!H209","v":0},null,{"$f":"C6/SUM($C$3:$C$6)","v":0},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Band 2","H",null,{"$f":"'2019 Data By Pay Band'!H206","v":22},null,{"$f":"D7/SUM($D$7:$D$10)","v":0.10526315789473684},null,4,16.5,0]
[null,"LGB",null,{"$f":"'2019 Data By Pay Band'!I207","v":32},null,{"$f":"D8/SUM($D$7:$D$10)","v":0.15311004784688995},null,5,20.5,0]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!I208","v":155},null,{"$f":"D9/SUM($D$7:$D$10)","v":0.74162679425837319},null,6,24.5,0]
[null,"NR ",null,{"$f":"'2019 Data By Pay Band'!I209","v":0},null,{"$f":"D10/SUM($D$7:$D$10)","v":0},null,7,28.5,0]
["Band 3","H",{"$f":"'2019 Data By Pay Band'!I206","v":1398},null,{"$f":"C11/SUM($C$11:$C$14)","v":0.95687885010266938},null,null,8,32.5,0]
[null,"LGB",{"$f":"'2019 Data By Pay Band'!J207","v":13},null,{"$f":"C12/SUM($C$11:$C$14)","v":8.8980150581793298E-3},null,null,9,36.5,0]
[null,"ND",{"$f":"'2019 Data By Pay Band'!J208","v":50},null,{"$f":"C13/SUM($C$11:$C$14)","v":3.4223134839151265E-2},null,null,10,40.5,0]
[null,"NR ",{"$f":"'2019 Data By Pay Band'!J209","v":0},null,{"$f":"C14/SUM($C$11:$C$14)","v":0},null,null,11,44.5,0]
["Band 4","H",null,{"$f":"'2019 Data By Pay Band'!J206","v":532},null,{"$f":"D15/SUM($D$15:$D$18)","v":0.94830659536541895},null,12,48.5,0]
[null,"LGB",null,{"$f":"'2019 Data By Pay Band'!K207","v":7},null,{"$f":"D16/SUM($D$15:$D$18)","v":1.2477718360071301E-2}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!K208","v":22},null,{"$f":"D17/SUM($D$15:$D$18)","v":3.9215686274509803E-2}]
[null,"NR ",null,{"$f":"'2019 Data By Pay Band'!K209","v":0},null,{"$f":"D18/SUM($D$15:$D$18)","v":0}]
["Band 5","H",{"$f":"'2019 Data By Pay Band'!K206","v":307},null,{"$f":"C19/SUM($C$19:$C$22)","v":0.71229698375870065}]
[null,"LGB",{"$f":"'2019 Data By Pay Band'!L207","v":29},null,{"$f":"C20/SUM($C$19:$C$22)","v":6.7285382830626447E-2}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!L208","v":95},null,{"$f":"C21/SUM($C$19:$C$22)","v":0.22041763341067286}]
[null,"NR ",{"$f":"'2019 Data By Pay Band'!L209","v":0},null,{"$f":"C22/SUM($C$19:$C$22)","v":0}]
["Band 6","H",null,{"$f":"'2019 Data By Pay Band'!L206","v":960},null,{"$f":"D23/SUM($D$23:$D$26)","v":0.90909090909090906}]
[null,"LGB",null,{"$f":"'2019 Data By Pay Band'!M207","v":11},null,{"$f":"D24/SUM($D$23:$D$26)","v":1.0416666666666666E-2}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!M208","v":84},null,{"$f":"D25/SUM($D$23:$D$26)","v":7.9545454545454544E-2}]
[null,"NR ",null,{"$f":"'2019 Data By Pay Band'!M209","v":1},null,{"$f":"D26/SUM($D$23:$D$26)","v":9.46969696969697E-4}]
["Band 7","H",{"$f":"'2019 Data By Pay Band'!M206","v":709},null,{"$f":"C27/SUM($C$27:$C$30)","v":0.91839378238341973}]
[null,"LGB",{"$f":"'2019 Data By Pay Band'!N207","v":13},null,{"$f":"C28/SUM($C$27:$C$30)","v":1.683937823834197E-2}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!N208","v":50},null,{"$f":"C29/SUM($C$27:$C$30)","v":6.4766839378238336E-2}]
[null,"NR ",{"$f":"'2019 Data By Pay Band'!N209","v":0},null,{"$f":"C30/SUM($C$27:$C$30)","v":0}]
["Band 8","H",null,{"$f":"'2019 Data By Pay Band'!N206","v":363},null,{"$f":"D31/SUM($D$31:$D$34)","v":0.94285714285714284}]
[null,"LGB",null,{"$f":"'2019 Data By Pay Band'!O207","v":2},null,{"$f":"D32/SUM($D$31:$D$34)","v":5.1948051948051948E-3}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!O208","v":20},null,{"$f":"D33/SUM($D$31:$D$34)","v":5.1948051948051951E-2}]
[null,"NR ",null,{"$f":"'2019 Data By Pay Band'!O209","v":0},null,{"$f":"D34/SUM($D$31:$D$34)","v":0}]
["Band 9","H",{"$f":"'2019 Data By Pay Band'!O206","v":189},null,{"$f":"C35/SUM($C$35:$C$38)","v":1}]
[null,"LGB",{"$f":"'2019 Data By Pay Band'!P207","v":0},null,{"$f":"C36/SUM($C$35:$C$38)","v":0}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!P208","v":0},null,{"$f":"C37/SUM($C$35:$C$38)","v":0}]
[null,"NR ",{"$f":"'2019 Data By Pay Band'!P209","v":0},null,{"$f":"C38/SUM($C$35:$C$38)","v":0}]
["Trainee Grade Doctor","H",null,{"$f":"'2019 Data By Pay Band'!P206","v":7},null,{"$f":"D39/SUM($D$39:$D$42)","v":7.8651685393258425E-2}]
[null,"LGB",null,{"$f":"'2019 Data By Pay Band'!Q207","v":13},null,{"$f":"D40/SUM($D$39:$D$42)","v":0.14606741573033707}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!Q208","v":69},null,{"$f":"D41/SUM($D$39:$D$42)","v":0.7752808988764045}]
[null,"NR ",null,{"$f":"'2019 Data By Pay Band'!Q209","v":0},null,{"$f":"D42/SUM($D$39:$D$42)","v":0}]
["Career Grade Doctor","H",{"$f":"'2019 Data By Pay Band'!Q206","v":321},null,{"$f":"C43/SUM($C$43:$C$46)","v":0.98466257668711654}]
[null,"LGB",{"$f":"'2019 Data By Pay Band'!R207","v":0},null,{"$f":"C44/SUM($C$43:$C$46)","v":0}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!R208","v":5},null,{"$f":"C45/SUM($C$43:$C$46)","v":1.5337423312883436E-2}]
[null,"NR ",{"$f":"'2019 Data By Pay Band'!R209","v":0},null,{"$f":"C46/SUM($C$43:$C$46)","v":0}]
["Consultant","H",null,{"$f":"'2019 Data By Pay Band'!R206","v":29},null,{"$f":"D47/SUM($D$47:$D$50)","v":0.54716981132075471}]
[null,"LGB",null,{"$f":"'2019 Data By Pay Band'!S207","v":1},null,{"$f":"D48/SUM($D$31:$D$34)","v":2.5974025974025974E-3}]
[null,"ND",null,{"$f":"'2019 Data By Pay Band'!S208","v":23},null,{"$f":"D49/SUM($D$31:$D$34)","v":5.9740259740259739E-2}]
[null,"NR ",null,{"$f":"'2019 Data By Pay Band'!S209","v":0},null,{"$f":"D50/SUM($D$31:$D$34)","v":0}]
["Other","H",{"$f":"'2019 Data By Pay Band'!S206","v":164},null,{"$f":"C51/SUM($C$51:$C$54)","v":0.96470588235294119}]
[null,"LGB",{"$f":"'2019 Data By Pay Band'!T207","v":0},null,{"$f":"C52/SUM($C$51:$C$54)","v":0}]
[null,"ND",{"$f":"'2019 Data By Pay Band'!T208","v":6},null,{"$f":"C53/SUM($C$51:$C$54)","v":3.5294117647058823E-2}]
[null,"NR ",{"$f":"'2019 Data By Pay Band'!T209","v":0},null,{"$f":"C54/SUM($C$51:$C$54)","v":0}]

{"sheet":"RB Graph Data ET","index":11,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Religious Belief ","Value",null,"Percentage",null,null,"Dividers",10]
["Substantive - Full Time","A",{"$f":"'2019 Data by Employee Type'!K172","v":604},null,{"$f":"C3/SUM($C$3:$C$12)","v":0.19940574447012216},null,null,null,"X","Y"]
[null,"B",{"$f":"'2019 Data by Employee Type'!K173","v":15},null,{"$f":"C4/SUM($C$3:$C$12)","v":4.9521294156487285E-3},null,null,1,{"$f":"$I$2*H4+0.5","v":10.5},0]
[null,"C",{"$f":"'2019 Data by Employee Type'!K174","v":1324},null,0.43710795642126116,null,null,2,{"$f":"$I$2*H5+0.5","v":20.5},0]
[null,"H",{"$f":"'2019 Data by Employee Type'!K175","v":33},null,1.0894684714427203E-2,null,null,3,{"$f":"$I$2*H6+0.5","v":30.5},0]
[null,"I",{"$f":"'2019 Data by Employee Type'!K176","v":36},null,1.1885110597556949E-2]
[null,"J",{"$f":"'2019 Data by Employee Type'!K177","v":3},null,9.9042588312974584E-4]
[null,"S",{"$f":"'2019 Data by Employee Type'!K178","v":8},null,2.6411356883459889E-3]
[null,"O",{"$f":"'2019 Data by Employee Type'!K179","v":255},null,8.4186200066028394E-2]
[null,"ND",{"$f":"'2019 Data by Employee Type'!K180","v":419},null,0.13832948167712117]
[null,"NR",{"$f":"'2019 Data by Employee Type'!K181","v":332},null,0.10960713106635854]
["Substantive - Part Time","A",null,{"$f":"'2019 Data by Employee Type'!L172","v":290},null,{"$f":"D13/SUM($D$13:$D$22)","v":0.11939069575957184}]
[null,"B",null,{"$f":"'2019 Data by Employee Type'!L173","v":9},null,3.7052284890901604E-3]
[null,"C",null,{"$f":"'2019 Data by Employee Type'!L174","v":1135},null,0.46727048167970359]
[null,"H",null,{"$f":"'2019 Data by Employee Type'!L175","v":7},null,2.881844380403458E-3]
[null,"I",null,{"$f":"'2019 Data by Employee Type'!L176","v":7},null,2.881844380403458E-3]
[null,"J",null,{"$f":"'2019 Data by Employee Type'!L177","v":3},null,1.2350761630300535E-3]
[null,"S",null,{"$f":"'2019 Data by Employee Type'!L178","v":0},null,0]
[null,"O",null,{"$f":"'2019 Data by Employee Type'!L179","v":191},null,7.8633182379580072E-2]
[null,"ND",null,{"$f":"'2019 Data by Employee Type'!L180","v":404},null,0.16632358995471389]
[null,"NR",null,{"$f":"'2019 Data by Employee Type'!L181","v":383},null,0.1576780568135035]
["Bank","A",{"$f":"'2019 Data by Employee Type'!M172","v":230},null,{"$f":"C23/SUM($C$23:$C$32)","v":0.20664869721473494}]
[null,"B",{"$f":"'2019 Data by Employee Type'!M173","v":8},null,{"$f":"C24/SUM($C$23:$C$32)","v":7.1877807726864335E-3}]
[null,"C",{"$f":"'2019 Data by Employee Type'!M174","v":473},null,0.42497753818508538]
[null,"H",{"$f":"'2019 Data by Employee Type'!M175","v":9},null,8.0862533692722376E-3]
[null,"I",{"$f":"'2019 Data by Employee Type'!M176","v":11},null,9.883198562443846E-3]
[null,"J",{"$f":"'2019 Data by Employee Type'!M177","v":0},null,0]
[null,"S",{"$f":"'2019 Data by Employee Type'!M178","v":1},null,8.9847259658580418E-4]
[null,"O",{"$f":"'2019 Data by Employee Type'!M179","v":102},null,9.1644204851752023E-2]
[null,"ND",{"$f":"'2019 Data by Employee Type'!M180","v":178},null,0.15992812219227315]
[null,"NR",{"$f":"'2019 Data by Employee Type'!M181","v":101},null,9.0745732255166217E-2]

{"sheet":"RS Graph Data ET ","index":12,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Relationship Status","Value",null,"Percentage",null,null,"Dividers",7]
["Substantive - Full Time","S",{"$f":"'2019 Data by Employee Type'!K141","v":1408},null,{"$f":"C3/SUM($C$3:$C$9)","v":0.46483988114889402},null,null,null,"X","Y"]
[null,"M",{"$f":"'2019 Data by Employee Type'!K142","v":1305},null,0.43083525916143944,null,null,1,{"$f":"$I$2*H4+0.5","v":7.5},0]
[null,"C",{"$f":"'2019 Data by Employee Type'!K143","v":33},null,1.0894684714427203E-2,null,null,2,{"$f":"$I$2*H5+0.5","v":14.5},0]
[null,"D",{"$f":"'2019 Data by Employee Type'!K144","v":155},null,5.117200396170353E-2,null,null,3,{"$f":"$I$2*H6+0.5","v":21.5},0]
[null,"LS",{"$f":"'2019 Data by Employee Type'!K145","v":24},null,7.9234070650379667E-3]
[null,"W",{"$f":"'2019 Data by Employee Type'!K146","v":14},null,4.6219874546054801E-3]
[null,"NR",{"$f":"'2019 Data by Employee Type'!K147","v":90},null,2.9712776493892375E-2]
["Substantive - Part Time","S",null,{"$f":"'2019 Data by Employee Type'!L141","v":612},null,{"$f":"D10/SUM($D$10:$D$16)","v":0.25195553725813091}]
[null,"M",null,{"$f":"'2019 Data by Employee Type'!L142","v":1534},null,0.63153561136270076]
[null,"C",null,{"$f":"'2019 Data by Employee Type'!L143","v":29},null,1.1939069575957185E-2]
[null,"D",null,{"$f":"'2019 Data by Employee Type'!L144","v":137},null,5.6401811445039113E-2]
[null,"LS",null,{"$f":"'2019 Data by Employee Type'!L145","v":24},null,9.8806093042404283E-3]
[null,"W",null,{"$f":"'2019 Data by Employee Type'!L146","v":24},null,9.8806093042404283E-3]
[null,"NR",null,{"$f":"'2019 Data by Employee Type'!L147","v":69},null,2.840675174969123E-2]
["Bank","S",{"$f":"'2019 Data by Employee Type'!M141","v":528},null,{"$f":"C17/SUM($C$17:$C$23)","v":0.47439353099730458}]
[null,"M",{"$f":"'2019 Data by Employee Type'!M142","v":438},null,0.39353099730458219]
[null,"C",{"$f":"'2019 Data by Employee Type'!M143","v":15},null,1.3477088948787063E-2]
[null,"D",{"$f":"'2019 Data by Employee Type'!M144","v":53},null,4.7619047619047616E-2]
[null,"LS",{"$f":"'2019 Data by Employee Type'!M145","v":7},null,6.2893081761006293E-3]
[null,"W",{"$f":"'2019 Data by Employee Type'!M146","v":8},null,7.1877807726864335E-3]
[null,"NR",{"$f":"'2019 Data by Employee Type'!M147","v":64},null,5.7502246181491468E-2]

{"sheet":"A Graph Data ET ","index":13,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Age Band","Value",null,"Percentage",null,null,"Dividers",6]
["Substantive - Full Time","16-25",{"$f":"'2019 Data by Employee Type'!K27","v":371},null,{"$f":"C3/SUM($C$3:$C$8)","v":0.12248266754704523},null,null,null,"X","Y"]
[null,"26-35",{"$f":"'2019 Data by Employee Type'!K28","v":911},null,0.30075932651039949,null,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"36-45",{"$f":"'2019 Data by Employee Type'!K29","v":583},null,0.19247276328821394,null,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"46-55",{"$f":"'2019 Data by Employee Type'!K30","v":772},null,0.25486959392538794,null,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"56-65",{"$f":"'2019 Data by Employee Type'!K31","v":382},null,0.12611422911852097]
[null,">65",{"$f":"'2019 Data by Employee Type'!K32","v":10},null,3.3014196104324861E-3]
["Substantive - Part Time","16-25",null,{"$f":"'2019 Data by Employee Type'!L27","v":93},null,{"$f":"D9/SUM($D$9:$D$14)","v":3.8287361053931657E-2}]
[null,"26-35",null,{"$f":"'2019 Data by Employee Type'!L28","v":456},null,0.18773157678056812]
[null,"36-45",null,{"$f":"'2019 Data by Employee Type'!L29","v":624},null,0.25689584191025111]
[null,"46-55",null,{"$f":"'2019 Data by Employee Type'!L30","v":649},null,0.26718814326883489]
[null,"56-65",null,{"$f":"'2019 Data by Employee Type'!L31","v":511},null,0.21037463976945245]
[null,">65",null,{"$f":"'2019 Data by Employee Type'!L32","v":96},null,3.9522437216961713E-2]
["Bank","16-25",{"$f":"'2019 Data by Employee Type'!M27","v":208},null,{"$f":"C15/SUM($C$15:$C$20)","v":0.18688230008984727}]
[null,"26-35",{"$f":"'2019 Data by Employee Type'!M28","v":339},null,0.30458221024258758]
[null,"36-45",{"$f":"'2019 Data by Employee Type'!M29","v":205},null,0.18418688230008984]
[null,"46-55",{"$f":"'2019 Data by Employee Type'!M30","v":163},null,0.14645103324348607]
[null,"56-65",{"$f":"'2019 Data by Employee Type'!M31","v":148},null,0.132973944294699]
[null,">65",{"$f":"'2019 Data by Employee Type'!M32","v":50},null,4.4923629829290206E-2]

{"sheet":"D Graph Data ET","index":14,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Disability","Value",null,"Percentage",null,null,"Dividers",4]
["Substantive - Full Time","Y",{"$f":"'2019 Data by Employee Type'!K57","v":115},null,{"$f":"C3/SUM($C$3:$C$6)","v":3.7966325519973587E-2},null,null,null,"X","Y"]
[null,"N",{"$f":"'2019 Data by Employee Type'!K58","v":2343},null,{"$f":"C4/SUM($C$3:$C$6)","v":0.77352261472433148},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"ND",{"$f":"'2019 Data by Employee Type'!K59","v":31},null,{"$f":"C5/SUM($C$3:$C$6)","v":1.0234400792340706E-2},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'2019 Data by Employee Type'!K60","v":540},null,{"$f":"C6/SUM($C$3:$C$6)","v":0.17827665896335423},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Substantive - Part Time","Y",null,{"$f":"'2019 Data by Employee Type'!L57","v":71},null,{"$f":"D7/SUM($D$7:$D$10)","v":2.9230135858377932E-2}]
[null,"N",null,{"$f":"'2019 Data by Employee Type'!L58","v":1739},null,{"$f":"D8/SUM($D$7:$D$10)","v":0.71593248250308772}]
[null,"ND",null,{"$f":"'2019 Data by Employee Type'!L59","v":45},null,{"$f":"D9/SUM($D$7:$D$10)","v":1.8526142445450804E-2}]
[null,"NR",null,{"$f":"'2019 Data by Employee Type'!L60","v":574},null,{"$f":"D10/SUM($D$7:$D$10)","v":0.23631123919308358}]
["Bank","Y",{"$f":"'2019 Data by Employee Type'!M57","v":24},null,{"$f":"C11/SUM($C$11:$C$14)","v":2.15633423180593E-2}]
[null,"N",{"$f":"'2019 Data by Employee Type'!M58","v":953},null,{"$f":"C12/SUM($C$11:$C$14)","v":0.85624438454627139}]
[null,"ND",{"$f":"'2019 Data by Employee Type'!M59","v":16},null,{"$f":"C13/SUM($C$11:$C$14)","v":1.4375561545372867E-2}]
[null,"NR",{"$f":"'2019 Data by Employee Type'!M60","v":120},null,{"$f":"C14/SUM($C$11:$C$14)","v":0.1078167115902965}]

{"sheet":"E Graph Data ET ","index":15,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Ethnicity","Value",null,"Percentage",null,null,"Dividers",4]
["Substantive - Full Time","WB",{"$f":"'2019 Data by Employee Type'!K86","v":2183},null,{"$f":"C3/SUM($C$3:$C$6)","v":0.72069990095741165},null,null,null,"X","Y"]
[null,"WO",{"$f":"'2019 Data by Employee Type'!K87","v":324},null,{"$f":"C4/SUM($C$3:$C$6)","v":0.10696599537801255},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"BME",{"$f":"'2019 Data by Employee Type'!K88","v":495},null,{"$f":"C5/SUM($C$3:$C$6)","v":0.16342027071640805},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'2019 Data by Employee Type'!K89","v":27},null,{"$f":"C6/SUM($C$3:$C$6)","v":8.9138329481677128E-3},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Substantive - Part Time","WB",null,{"$f":"'2019 Data by Employee Type'!L86","v":2053},null,{"$f":"D7/SUM($D$7:$D$10)","v":0.84520378756689996}]
[null,"WO",null,{"$f":"'2019 Data by Employee Type'!L87","v":190},null,{"$f":"D8/SUM($D$7:$D$10)","v":7.8221490325236717E-2}]
[null,"BME",null,{"$f":"'2019 Data by Employee Type'!L88","v":169},null,{"$f":"D9/SUM($D$7:$D$10)","v":6.9575957184026344E-2}]
[null,"NR",null,{"$f":"'2019 Data by Employee Type'!L89","v":17},null,{"$f":"D10/SUM($D$7:$D$10)","v":6.9987649238369698E-3}]
["Bank","WB",{"$f":"'2019 Data by Employee Type'!M86","v":796},null,{"$f":"C11/SUM($C$11:$C$14)","v":0.71518418688230012}]
[null,"WO",{"$f":"'2019 Data by Employee Type'!M87","v":121},null,{"$f":"C12/SUM($C$11:$C$14)","v":0.10871518418688229}]
[null,"BME",{"$f":"'2019 Data by Employee Type'!M88","v":159},null,{"$f":"C13/SUM($C$11:$C$14)","v":0.14285714285714285}]
[null,"NR",{"$f":"'2019 Data by Employee Type'!M89","v":37},null,{"$f":"C14/SUM($C$11:$C$14)","v":3.324348607367475E-2}]

{"sheet":"SO Graph Data ET ","index":16,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Sexual Orientation","Value",null,"Percentage",null,null,"Dividers",6]
["Substantive - Full Time","H",{"$f":"'2019 Data by Employee Type'!K206","v":2362},null,{"$f":"C3/SUM($C$3:$C$8)","v":0.77979531198415319},null,null,null,"X","Y"]
[null,"LGB",{"$f":"'2019 Data by Employee Type'!K207","v":77},null,{"$f":"C4/SUM($C$3:$C$8)","v":2.5420931000330143E-2},null,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"O",{"$f":"'2019 Data by Employee Type'!K208","v":1},null,3.3014196104324861E-4,null,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"U",{"$f":"'2019 Data by Employee Type'!K209","v":2},null,6.6028392208649722E-4,null,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"ND",{"$f":"'2019 Data by Employee Type'!K210","v":244},null,8.0554638494552661E-2]
[null,"NR",{"$f":"'2019 Data by Employee Type'!K211","v":343},null,0.11323869263783427]
["Substantive - Part Time","H",null,{"$f":"'2019 Data by Employee Type'!L206","v":1777},null,{"$f":"D9/SUM($D$9:$D$14)","v":0.73157678056813502}]
[null,"LGB",null,{"$f":"'2019 Data by Employee Type'!L207","v":20},null,{"$f":"D10/SUM($D$9:$D$14)","v":8.2338410868670227E-3}]
[null,"O",null,{"$f":"'2019 Data by Employee Type'!L208","v":0},null,0]
[null,"U",null,{"$f":"'2019 Data by Employee Type'!L209","v":1},null,4.1169205434335118E-4]
[null,"ND",null,{"$f":"'2019 Data by Employee Type'!L210","v":232},null,9.5512556607657478E-2]
[null,"NR",null,{"$f":"'2019 Data by Employee Type'!L211","v":399},null,0.16426512968299711]
["Bank","H",{"$f":"'2019 Data by Employee Type'!M206","v":879},null,{"$f":"C15/SUM($C$15:$C$20)","v":0.78975741239892183}]
[null,"LGB",{"$f":"'2019 Data by Employee Type'!M207","v":24},null,{"$f":"C16/SUM($C$15:$C$20)","v":2.15633423180593E-2}]
[null,"O",{"$f":"'2019 Data by Employee Type'!M208","v":0},null,0]
[null,"U",{"$f":"'2019 Data by Employee Type'!M209","v":3},null,2.6954177897574125E-3]
[null,"ND",{"$f":"'2019 Data by Employee Type'!M210","v":108},null,9.7035040431266845E-2]
[null,"NR",{"$f":"'2019 Data by Employee Type'!M211","v":99},null,8.8948787061994605E-2]

{"sheet":"G Graph Data ET ","index":17,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Gender","Value",null,"Percentage",null,null,"Dividers",2]
["Substantive - Full Time","F",{"$f":"'2019 Data by Employee Type'!K115","v":2015},null,{"$f":"C3/SUM($C$3:$C$4)","v":0.66523605150214593},null,null,null,"X","Y"]
[null,"M",{"$f":"'2019 Data by Employee Type'!K116","v":1014},null,{"$f":"C4/SUM($C$3:$C$4)","v":0.33476394849785407},null,null,1,{"$f":"$I$2*H4+0.5","v":2.5},0]
["Substantive - Part Time","F",null,{"$f":"'2019 Data by Employee Type'!L115","v":2182},null,{"$f":"D5/SUM($D$5:$D$6)","v":0.89831206257719221},null,2,{"$f":"$I$2*H5+0.5","v":4.5},0]
[null,"M",null,{"$f":"'2019 Data by Employee Type'!L116","v":247},null,{"$f":"D6/SUM($D$5:$D$6)","v":0.10168793742280774},null,3,{"$f":"$I$2*H6+0.5","v":6.5},0]
["Bank","F",{"$f":"'2019 Data by Employee Type'!M115","v":865},null,{"$f":"C7/SUM($C$7:$C$8)","v":0.77717879604672058}]
[null,"M",{"$f":"'2019 Data by Employee Type'!M116","v":248},null,{"$f":"C8/SUM($C$7:$C$8)","v":0.22282120395327942}]

{"sheet":"RS Graph Data YY","index":18,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Relationship Status","Value",null,"Percentage",null,null,"Dividers",7]
[2018,"S",{"$f":"'Year on Year Comparison'!L139","v":0.38776441941865775},null,{"$f":"C3/SUM($C$3:$C$9)","v":0.38776441941865775},null,null,null,"X","Y"]
[null,"M",{"$f":"'Year on Year Comparison'!L140","v":0.49870643737635062},null,0.49870643737635062,null,null,1,{"$f":"$I$2*H4+0.5","v":7.5},0]
[null,"C",{"$f":"'Year on Year Comparison'!L141","v":1.1718155531882515E-2},null,1.1718155531882515E-2,null,null,2,{"$f":"$I$2*H5+0.5","v":14.5},0]
[null,"D",{"$f":"'Year on Year Comparison'!L142","v":5.2503424136356718E-2},null,5.2503424136356718E-2,null,null,3,{"$f":"$I$2*H6+0.5","v":21.5},0]
[null,"LS",{"$f":"'Year on Year Comparison'!L143","v":8.3701110942017952E-3},null,8.3701110942017952E-3,null,null,4,{"$f":"$I$2*H7+0.5","v":28.5},0]
[null,"W",{"$f":"'Year on Year Comparison'!L144","v":7.0004565515142288E-3},null,7.0004565515142288E-3,null,null,5,{"$f":"$I$2*H8+0.5","v":35.5},0]
[null,"NR",{"$f":"'Year on Year Comparison'!L145","v":3.3936995891036374E-2},null,3.3936995891036374E-2]
[2017,"S",null,{"$f":"'Year on Year Comparison'!M139","v":0.39387786974855538},null,{"$f":"D10/SUM($D$10:$D$16)","v":0.39387786974855538}]
[null,"M",null,{"$f":"'Year on Year Comparison'!M140","v":0.49742308292987664},null,0.49742308292987664]
[null,"C",null,{"$f":"'Year on Year Comparison'!M141","v":1.0932375449008278E-2},null,1.0932375449008278E-2]
[null,"D",null,{"$f":"'Year on Year Comparison'!M142","v":4.8727159144151176E-2},null,4.8727159144151176E-2]
[null,"LS",null,{"$f":"'Year on Year Comparison'!M143","v":9.2144307355926901E-3},null,9.2144307355926901E-3]
[null,"W",null,{"$f":"'Year on Year Comparison'!M144","v":6.559425269404966E-3},null,6.559425269404966E-3]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M145","v":3.3265656723410898E-2},null,3.3265656723410898E-2]
[2016,"S",{"$f":"'Year on Year Comparison'!N139","v":0.39346636626971354},null,{"$f":"C17/SUM($C$17:$C$23)","v":0.39346636626971354}]
[null,"M",{"$f":"'Year on Year Comparison'!N140","v":0.50128741551335698},null,0.50128741551335698]
[null,"C",{"$f":"'Year on Year Comparison'!N141","v":7.402639201802382E-3},null,7.402639201802382E-3]
[null,"D",{"$f":"'Year on Year Comparison'!N142","v":5.2301255230125514E-2},null,5.2301255230125514E-2]
[null,"LS",{"$f":"'Year on Year Comparison'!N143","v":1.0299324106855488E-2},null,1.0299324106855488E-2]
[null,"W",{"$f":"'Year on Year Comparison'!N144","v":6.115223688445446E-3},null,6.115223688445446E-3]
[null,"NR",{"$f":"'Year on Year Comparison'!N145","v":2.9127775989700674E-2},null,2.9127775989700674E-2]
[2015,"S",null,{"$f":"'Year on Year Comparison'!O139","v":0.38683406854428237},null,{"$f":"D24/SUM($D$24:$D$30)","v":0.38683406854428237}]
[null,"M",null,{"$f":"'Year on Year Comparison'!O140","v":0.51408211740753307},null,0.51408211740753307]
[null,"C",null,{"$f":"'Year on Year Comparison'!O141","v":5.5989141499830338E-3},null,5.5989141499830338E-3]
[null,"D",null,{"$f":"'Year on Year Comparison'!O142","v":5.3274516457414316E-2},null,5.3274516457414316E-2]
[null,"LS",null,{"$f":"'Year on Year Comparison'!O143","v":8.8225313878520523E-3},null,8.8225313878520523E-3]
[null,"W",null,{"$f":"'Year on Year Comparison'!O144","v":7.2955548014930439E-3},null,7.2955548014930439E-3]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O145","v":2.4092297251442144E-2},null,2.4092297251442144E-2]
[2014,"S",{"$f":"'Year on Year Comparison'!P139","v":0.3882251082251082},null,{"$f":"C31/SUM($C$31:$C$37)","v":0.3882251082251082}]
[null,"M",{"$f":"'Year on Year Comparison'!P140","v":0.51411255411255408},null,0.51411255411255408]
[null,"C",{"$f":"'Year on Year Comparison'!P141","v":2.597402597402597E-3},null,2.597402597402597E-3]
[null,"D",{"$f":"'Year on Year Comparison'!P142","v":5.74891774891775E-2},null,5.74891774891775E-2]
[null,"LS",{"$f":"'Year on Year Comparison'!P143","v":9.870129870129871E-3},null,9.870129870129871E-3]
[null,"W",{"$f":"'Year on Year Comparison'!P144","v":7.2727272727272727E-3},null,7.2727272727272727E-3]
[null,"NR",{"$f":"'Year on Year Comparison'!P145","v":2.0432900432900435E-2},null,2.0432900432900435E-2]

{"sheet":"A Graph Data YY","index":19,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Age Band ","Value",null,"Percentage",null,null,"Dividers",6]
[{"$f":"'Year on Year Comparison'!$L$26","v":2019},"16-25",{"$f":"'Year on Year Comparison'!L27","v":0.1022675391873383},null,{"$f":"C3/SUM($C$3:$C$8)","v":0.10226753918733827},null,null,null,"X","Y"]
[null,"26-35",{"$f":"'Year on Year Comparison'!L28","v":0.25962562775833209},null,0.25962562775833203,null,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"36-45",{"$f":"'Year on Year Comparison'!L29","v":0.21488357936387156},null,0.21488357936387151,null,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"46-55",{"$f":"'Year on Year Comparison'!L30","v":0.24105919951301172},null,0.24105919951301166,null,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"56-65",{"$f":"'Year on Year Comparison'!L31","v":0.15842337543752855},null,0.15842337543752852,null,null,4,{"$f":"$I$2*H7+0.5","v":24.5},0]
[null,">65",{"$f":"'Year on Year Comparison'!L32","v":2.3740678739917819E-2},null,2.3740678739917812E-2,null,null,5,{"$f":"$I$2*H8+0.5","v":30.5},0]
[{"$f":"'Year on Year Comparison'!$M$26","v":2018},"16-25",null,{"$f":"'Year on Year Comparison'!M27","v":0.10823051694518195},null,{"$f":"D9/SUM($D$9:$D$14)","v":0.10823051694518195}]
[null,"26-35",null,{"$f":"'Year on Year Comparison'!M28","v":0.25113228174293301},null,0.25113228174293301]
[null,"36-45",null,{"$f":"'Year on Year Comparison'!M29","v":0.22036545369358113},null,0.22036545369358113]
[null,"46-55",null,{"$f":"'Year on Year Comparison'!M30","v":0.24269873496798375},null,0.24269873496798375]
[null,"56-65",null,{"$f":"'Year on Year Comparison'!M31","v":0.15367796345463064},null,0.15367796345463064]
[null,">65",null,{"$f":"'Year on Year Comparison'!M32","v":2.3895049195689522E-2},null,2.3895049195689522E-2]
[{"$f":"'Year on Year Comparison'!$N$26","v":2017},"16-25",{"$f":"'Year on Year Comparison'!N27","v":0.10685548760862568},null,{"$f":"C15/SUM($C$15:$C$20)","v":0.10685548760862568}]
[null,"26-35",{"$f":"'Year on Year Comparison'!N28","v":0.25185065980045057},null,0.25185065980045057]
[null,"36-45",{"$f":"'Year on Year Comparison'!N29","v":0.22095268747988414},null,0.22095268747988414]
[null,"46-55",{"$f":"'Year on Year Comparison'!N30","v":0.24396523978113938},null,0.24396523978113938]
[null,"56-65",{"$f":"'Year on Year Comparison'!N31","v":0.15159317669777922},null,0.15159317669777922]
[null,">65",{"$f":"'Year on Year Comparison'!N32","v":2.4782748632121016E-2},null,2.4782748632121016E-2]
[{"$f":"'Year on Year Comparison'!$O$26","v":2016},"16-25",null,{"$f":"'Year on Year Comparison'!O27","v":8.1099423142178481E-2},null,{"$f":"D21/SUM($D$21:$D$26)","v":8.1099423142178481E-2}]
[null,"26-35",null,{"$f":"'Year on Year Comparison'!O28","v":0.24516457414319645},null,0.24516457414319645]
[null,"36-45",null,{"$f":"'Year on Year Comparison'!O29","v":0.22633186291143537},null,0.22633186291143537]
[null,"46-55",null,{"$f":"'Year on Year Comparison'!O30","v":0.2495758398371225},null,0.2495758398371225]
[null,"56-65",null,{"$f":"'Year on Year Comparison'!O31","v":0.16813708856464202},null,0.16813708856464202]
[null,">65",null,{"$f":"'Year on Year Comparison'!O32","v":2.9691211401425176E-2},null,2.9691211401425176E-2]
[{"$f":"'Year on Year Comparison'!$P$26","v":2015},"16-25",{"$f":"'Year on Year Comparison'!P27","v":0.10008658008658008},null,{"$f":"C27/SUM($C$27:$C$32)","v":0.10008658008658008}]
[null,"26-35",{"$f":"'Year on Year Comparison'!P28","v":0.24311688311688312},null,0.24311688311688312]
[null,"36-45",{"$f":"'Year on Year Comparison'!P29","v":0.22805194805194806},null,0.22805194805194806]
[null,"46-55",{"$f":"'Year on Year Comparison'!P30","v":0.25471861471861473},null,0.25471861471861473]
[null,"56-65",{"$f":"'Year on Year Comparison'!P31","v":0.1503030303030303},null,0.1503030303030303]
[null,">65",{"$f":"'Year on Year Comparison'!P32","v":2.3722943722943722E-2},null,2.3722943722943722E-2]

{"sheet":"D Graph Data YY","index":20,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Disability","Value",null,"Percentage",null,null,"Dividers",4]
[{"$f":"'Year on Year Comparison'!$L$56","v":2019},"Y",{"$f":"'Year on Year Comparison'!L57","v":3.1958605996043221E-2},null,{"$f":"C3/SUM($C$3:$C$6)","v":3.1958605996043228E-2},null,null,null,"X","Y"]
[null,"N",{"$f":"'Year on Year Comparison'!L58","v":0.76624562471465529},null,{"$f":"C4/SUM($C$3:$C$6)","v":0.7662456247146554},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"ND",{"$f":"'Year on Year Comparison'!L59","v":1.4000913103028458E-2},null,{"$f":"C5/SUM($C$3:$C$6)","v":1.4000913103028459E-2},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'Year on Year Comparison'!L60","v":0.18779485618627301},null,{"$f":"C6/SUM($C$3:$C$6)","v":0.18779485618627303},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
[{"$f":"'Year on Year Comparison'!$M$56","v":2018},"Y",null,{"$f":"'Year on Year Comparison'!M57","v":3.2953303139153518E-2},null,{"$f":"D7/SUM($D$7:$D$10)","v":3.2953303139153518E-2},null,4,{"$f":"$I$2*H7+0.5","v":16.5},0]
[null,"N",null,{"$f":"'Year on Year Comparison'!M58","v":0.73918475714508824},null,{"$f":"D8/SUM($D$7:$D$10)","v":0.73918475714508824},null,5,{"$f":"$I$2*H8+0.5","v":20.5},0]
[null,"ND",null,{"$f":"'Year on Year Comparison'!M59","v":1.1557082617523036E-2},null,{"$f":"D9/SUM($D$7:$D$10)","v":1.1557082617523036E-2}]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M60","v":0.21630485709823521},null,{"$f":"D10/SUM($D$7:$D$10)","v":0.21630485709823521}]
[{"$f":"'Year on Year Comparison'!$N$56","v":2017},"Y",{"$f":"'Year on Year Comparison'!N57","v":3.3311876408110716E-2},null,{"$f":"C11/SUM($C$11:$C$14)","v":3.3311876408110716E-2}]
[null,"N",{"$f":"'Year on Year Comparison'!N58","v":0.70308979723205667},null,{"$f":"C12/SUM($C$11:$C$14)","v":0.70308979723205667}]
[null,"ND",{"$f":"'Year on Year Comparison'!N59","v":8.6900547151593181E-3},null,{"$f":"C13/SUM($C$11:$C$14)","v":8.6900547151593181E-3}]
[null,"NR",{"$f":"'Year on Year Comparison'!N60","v":0.25490827164467333},null,{"$f":"C14/SUM($C$11:$C$14)","v":0.25490827164467333}]
[{"$f":"'Year on Year Comparison'!$O$56","v":2016},"Y",null,{"$f":"'Year on Year Comparison'!O57","v":3.1557516118086187E-2},null,{"$f":"D15/SUM($D$15:$D$18)","v":3.1557516118086187E-2}]
[null,"N",null,{"$f":"'Year on Year Comparison'!O58","v":0.66457414319647101},null,{"$f":"D16/SUM($D$15:$D$18)","v":0.66457414319647101}]
[null,"ND",null,{"$f":"'Year on Year Comparison'!O59","v":1.001017984390906E-2},null,{"$f":"D17/SUM($D$15:$D$18)","v":1.001017984390906E-2}]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O60","v":0.29385816084153377},null,{"$f":"D18/SUM($D$15:$D$18)","v":0.29385816084153377}]
[{"$f":"'Year on Year Comparison'!$P$56","v":2015},"Y",{"$f":"'Year on Year Comparison'!P57","v":2.9437229437229439E-2},null,{"$f":"C19/SUM($C$19:$C$22)","v":2.9437229437229439E-2}]
[null,"N",{"$f":"'Year on Year Comparison'!P58","v":0.59809523809523812},null,{"$f":"C20/SUM($C$19:$C$22)","v":0.59809523809523812}]
[null,"ND",{"$f":"'Year on Year Comparison'!P59","v":5.0216450216450216E-3},null,{"$f":"C21/SUM($C$19:$C$22)","v":5.0216450216450216E-3}]
[null,"NR",{"$f":"'Year on Year Comparison'!P60","v":0.36744588744588746},null,{"$f":"C22/SUM($C$19:$C$22)","v":0.36744588744588746}]

{"sheet":"E Graph Data YY","index":21,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Ethnicity","Value",null,"Percentage",null,null,"Dividers",4]
[{"$f":"'Year on Year Comparison'!$L$84","v":2019},"WB",{"$f":"'Year on Year Comparison'!L85","v":0.76578907320042611},null,{"$f":"C3/SUM($C$3:$C$6)","v":0.76578907320042611},null,null,null,"X","Y"]
[null,"WO",{"$f":"'Year on Year Comparison'!L86","v":9.6636737178511636E-2},null,{"$f":"C4/SUM($C$3:$C$6)","v":9.6636737178511636E-2},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"BME",{"$f":"'Year on Year Comparison'!L87","v":0.12524729873687415},null,{"$f":"C5/SUM($C$3:$C$6)","v":0.12524729873687415},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'Year on Year Comparison'!L88","v":1.23268908841881E-2},null,{"$f":"C6/SUM($C$3:$C$6)","v":1.23268908841881E-2},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
[{"$f":"'Year on Year Comparison'!$M$84","v":2018},"WB",null,{"$f":"'Year on Year Comparison'!M85","v":0.77682336404810248},null,{"$f":"D7/SUM($D$7:$D$10)","v":0.77682336404810248},null,4,{"$f":"$I$2*H7+0.5","v":16.5},0]
[null,"WO",null,{"$f":"'Year on Year Comparison'!M86","v":0.10198344526003436},null,{"$f":"D8/SUM($D$7:$D$10)","v":0.10198344526003436},null,5,{"$f":"$I$2*H8+0.5","v":20.5},0]
[null,"BME",null,{"$f":"'Year on Year Comparison'!M87","v":0.11416523504607215},null,{"$f":"D9/SUM($D$7:$D$10)","v":0.11416523504607215}]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M88","v":7.027955645791035E-3},null,{"$f":"D10/SUM($D$7:$D$10)","v":7.027955645791035E-3}]
[{"$f":"'Year on Year Comparison'!$N$84","v":2017},"WB",{"$f":"'Year on Year Comparison'!N85","v":0.77792082394592854},null,{"$f":"C11/SUM($C$11:$C$14)","v":0.77792082394592854}]
[null,"WO",{"$f":"'Year on Year Comparison'!N86","v":0.10959124557450917},null,{"$f":"C12/SUM($C$11:$C$14)","v":0.10959124557450917}]
[null,"BME",{"$f":"'Year on Year Comparison'!N87","v":0.10621177985194721},null,{"$f":"C13/SUM($C$11:$C$14)","v":0.10621177985194721}]
[null,"NR",{"$f":"'Year on Year Comparison'!N88","v":6.2761506276150627E-3},null,{"$f":"C14/SUM($C$11:$C$14)","v":6.2761506276150627E-3}]
[{"$f":"'Year on Year Comparison'!$O$84","v":2016},"WB",null,{"$f":"'Year on Year Comparison'!O85","v":0.77926705123854778},null,{"$f":"D15/SUM($D$15:$D$18)","v":0.77926705123854756}]
[null,"WO",null,{"$f":"'Year on Year Comparison'!O86","v":0.11350525958601969},null,{"$f":"D16/SUM($D$15:$D$18)","v":0.11350525958601966}]
[null,"BME",null,{"$f":"'Year on Year Comparison'!O87","v":0.10434340006786563},null,{"$f":"D17/SUM($D$15:$D$18)","v":0.1043434000678656}]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O88","v":2.8842891075670173E-3},null,{"$f":"D18/SUM($D$15:$D$18)","v":2.8842891075670169E-3}]
[{"$f":"'Year on Year Comparison'!$P$84","v":2015},"WB",{"$f":"'Year on Year Comparison'!P85","v":0.78008658008658005},null,{"$f":"C19/SUM($C$19:$C$22)","v":0.78008658008658016}]
[null,"WO",{"$f":"'Year on Year Comparison'!P86","v":0.11272727272727273},null,{"$f":"C20/SUM($C$19:$C$22)","v":0.11272727272727275}]
[null,"BME",{"$f":"'Year on Year Comparison'!P87","v":0.10181818181818184},null,{"$f":"C21/SUM($C$19:$C$22)","v":0.10181818181818185}]
[null,"NR",{"$f":"'Year on Year Comparison'!P88","v":5.367965367965368E-3},null,{"$f":"C22/SUM($C$19:$C$22)","v":5.3679653679653688E-3}]

{"sheet":"G Graph Data YY","index":22,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Gender","Value",null,"Percentage",null,null,"Dividers",2]
[{"$f":"'Year on Year Comparison'!$L$112","v":2019},"F",{"$f":"'Year on Year Comparison'!L113","v":0.77035458834271797},null,{"$f":"C3/SUM($C$3:$C$4)","v":0.77035458834271797},null,null,null,"X","Y"]
[null,"M",{"$f":"'Year on Year Comparison'!L114","v":0.229645411657282},null,{"$f":"C4/SUM($C$3:$C$4)","v":0.229645411657282},null,null,1,{"$f":"$I$2*H4+0.5","v":2.5},0]
[{"$f":"'Year on Year Comparison'!$M$112","v":2018},"F",null,{"$f":"'Year on Year Comparison'!M113","v":0.77822895517726065},null,{"$f":"D5/SUM($D$5:$D$6)","v":0.77822895517726065},null,2,{"$f":"$I$2*H5+0.5","v":4.5},0]
[null,"M",null,{"$f":"'Year on Year Comparison'!M114","v":0.22177104482273935},null,{"$f":"D6/SUM($D$5:$D$6)","v":0.22177104482273935},null,3,{"$f":"$I$2*H6+0.5","v":6.5},0]
[{"$f":"'Year on Year Comparison'!$N$112","v":2017},"F",{"$f":"'Year on Year Comparison'!N113","v":0.77261023495333114},null,{"$f":"C7/SUM($C$7:$C$8)","v":0.77261023495333114},null,null,4,{"$f":"$I$2*H7+0.5","v":8.5},0]
[null,"M",{"$f":"'Year on Year Comparison'!N114","v":0.2273897650466688},null,{"$f":"C8/SUM($C$7:$C$8)","v":0.2273897650466688},null,null,5,{"$f":"$I$2*H8+0.5","v":10.5},0]
[{"$f":"'Year on Year Comparison'!$O$112","v":2016},"F",null,{"$f":"'Year on Year Comparison'!O113","v":0.77400746521886665},null,{"$f":"D9/SUM($D$9:$D$10)","v":0.77400746521886665}]
[null,"M",null,{"$f":"'Year on Year Comparison'!O114","v":0.22599253478113335},null,{"$f":"D10/SUM($D$9:$D$10)","v":0.22599253478113335}]
[{"$f":"'Year on Year Comparison'!$P$112","v":2015},"F",{"$f":"'Year on Year Comparison'!P113","v":0.77541125541125544},null,{"$f":"C11/SUM($C$11:$C$12)","v":0.77541125541125544}]
[null,"M",{"$f":"'Year on Year Comparison'!P114","v":0.22458874458874459},null,{"$f":"C12/SUM($C$11:$C$12)","v":0.22458874458874459}]

{"sheet":"SO Graph Data YY","index":23,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Sexual Orientation","Value",null,"Percentage",null,null,"Dividers",6]
[{"$f":"'Year on Year Comparison'!$L$138","v":2019},"H",{"$f":"'Year on Year Comparison'!L204","v":0.76365849946735653},null,{"$f":"C3/SUM($C$3:$C$8)","v":0.76365849946735664},null,null,null,"X","Y"]
[null,"LGB",{"$f":"'Year on Year Comparison'!L205","v":1.841424440724395E-2},null,{"$f":"C4/SUM($C$3:$C$8)","v":1.8414244407243954E-2},null,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"O",{"$f":"'Year on Year Comparison'!L206","v":1.5218383807639628E-4},null,1.521838380763963E-4,null,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"U",{"$f":"'Year on Year Comparison'!L207","v":9.1310302845837776E-4},null,9.1310302845837787E-4,null,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"ND",{"$f":"'Year on Year Comparison'!L208","v":8.8875361436615438E-2},null,8.8875361436615452E-2,null,null,4,{"$f":"$I$2*H7+0.5","v":24.5},0]
[null,"NR",{"$f":"'Year on Year Comparison'!L209","v":0.12798660782224927},null,0.1279866078222493,null,null,5,{"$f":"$I$2*H8+0.5","v":30.5},0]
[{"$f":"'Year on Year Comparison'!$M$138","v":2018},"H",null,{"$f":"'Year on Year Comparison'!M204","v":0.74215211619553334},null,{"$f":"D9/SUM($D$9:$D$14)","v":0.74215211619553334}]
[null,"LGB",null,{"$f":"'Year on Year Comparison'!M205","v":1.7647977510541934E-2},null,{"$f":"D10/SUM($D$9:$D$14)","v":1.7647977510541934E-2}]
[null,"O",null,{"$f":"'Year on Year Comparison'!M206","v":"-"},null,{"$error":"#VALUE!"}]
[null,"U",null,{"$f":"'Year on Year Comparison'!M207","v":"-"},null,{"$error":"#VALUE!"}]
[null,"ND",null,{"$f":"'Year on Year Comparison'!M208","v":9.1363423395283458E-2},null,9.1363423395283458E-2]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M209","v":0.14883648289864126},null,0.14883648289864126]
[{"$f":"'Year on Year Comparison'!$N$138","v":2017},"H",{"$f":"'Year on Year Comparison'!N204","v":0.59912812736921905},null,{"$f":"C15/SUM($C$15:$C$20)","v":0.59912812736921917}]
[null,"LGB",{"$f":"'Year on Year Comparison'!N205","v":1.1751326762699014E-2},null,{"$f":"C16/SUM($C$15:$C$20)","v":1.1751326762699016E-2}]
[null,"O",{"$f":"'Year on Year Comparison'!N206","v":"-"},null,{"$error":"#VALUE!"}]
[null,"U",{"$f":"'Year on Year Comparison'!N207","v":"-"},null,{"$error":"#VALUE!"}]
[null,"ND",{"$f":"'Year on Year Comparison'!N208","v":9.9507202426080368E-2},null,9.9507202426080382E-2]
[null,"NR",{"$f":"'Year on Year Comparison'!N209","v":0.28961334344200151},null,0.28961334344200157]
[{"$f":"'Year on Year Comparison'!$O$138","v":2016},"H",null,{"$f":"'Year on Year Comparison'!O204","v":0.6564502164502164},null,{"$f":"D21/SUM($D$21:$D$26)","v":0.6564502164502164}]
[null,"LGB",null,{"$f":"'Year on Year Comparison'!O205","v":1.3160173160173158E-2},null,{"$f":"D22/SUM($D$21:$D$26)","v":1.3160173160173158E-2}]
[null,"O",null,{"$f":"'Year on Year Comparison'!O206","v":"-"},null,{"$error":"#VALUE!"}]
[null,"U",null,{"$f":"'Year on Year Comparison'!O207","v":"-"},null,{"$error":"#VALUE!"}]
[null,"ND",null,{"$f":"'Year on Year Comparison'!O208","v":9.4718614718614716E-2},null,9.4718614718614716E-2]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O209","v":0.23567099567099567},null,0.23567099567099567]
[{"$f":"'Year on Year Comparison'!$P$138","v":2015},"H",{"$f":"'Year on Year Comparison'!P204","v":0.69697997964031222},null,{"$f":"C27/SUM($C$27:$C$32)","v":0.69697997964031222}]
[null,"LGB",{"$f":"'Year on Year Comparison'!P205","v":1.4591109602986086E-2},null,{"$f":"C28/SUM($C$27:$C$32)","v":1.4591109602986086E-2}]
[null,"O",{"$f":"'Year on Year Comparison'!P206","v":"-"},null,{"$error":"#VALUE!"}]
[null,"U",{"$f":"'Year on Year Comparison'!P207","v":"-"},null,{"$error":"#VALUE!"}]
[null,"ND",{"$f":"'Year on Year Comparison'!P208","v":9.4163556158805561E-2},null,9.4163556158805561E-2]
[null,"NR",{"$f":"'Year on Year Comparison'!P209","v":0.19426535459789618},null,0.19426535459789618]

{"sheet":"RB Graph Data YY","index":24,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Religious Belief ","Value",null,"Percentage",null,null,"Dividers",10]
[{"$f":"'Year on Year Comparison'!$L$169","v":2019},"A",{"$f":"'Year on Year Comparison'!L170","v":0.17105463399786944},null,{"$f":"C3/SUM($C$3:$C$12)","v":0.17105463399786944},null,null,null,"X","Y"]
[null,"B",{"$f":"'Year on Year Comparison'!L171","v":4.8698828184446808E-3},null,{"$f":"C4/SUM($C$3:$C$12)","v":4.8698828184446808E-3},null,null,1,{"$f":"$I$2*H4+0.5","v":10.5},0]
[null,"C",{"$f":"'Year on Year Comparison'!L172","v":0.4462030132399939},null,0.4462030132399939,null,null,2,{"$f":"$I$2*H5+0.5","v":20.5},0]
[null,"H",{"$f":"'Year on Year Comparison'!L173","v":7.4570080657434179E-3},null,7.4570080657434179E-3,null,null,3,{"$f":"$I$2*H6+0.5","v":30.5},0]
[null,"I",{"$f":"'Year on Year Comparison'!L174","v":8.2179272561254003E-3},null,8.2179272561254003E-3,null,null,4,{"$f":"$I$2*H7+0.5","v":40.5},0]
[null,"J",{"$f":"'Year on Year Comparison'!L175","v":9.1310302845837776E-4},null,9.1310302845837776E-4,null,null,5,{"$f":"$I$2*H8+0.5","v":50.5},0]
[null,"S",{"$f":"'Year on Year Comparison'!L176","v":1.3696545426875666E-3},null,1.3696545426875666E-3]
[null,"O",{"$f":"'Year on Year Comparison'!L177","v":8.3396743265865159E-2},null,8.3396743265865159E-2]
[null,"ND",{"$f":"'Year on Year Comparison'!L178","v":0.15233602191447268},null,0.15233602191447268]
[null,"NR",{"$f":"'Year on Year Comparison'!L179","v":0.12418201187033936},null,0.12418201187033936]
[{"$f":"'Year on Year Comparison'!$M$169","v":2018},"A",null,{"$f":"'Year on Year Comparison'!M170","v":0.16414180852725285},null,{"$f":"D13/SUM($D$13:$D$22)","v":0.16414180852725285}]
[null,"B",null,{"$f":"'Year on Year Comparison'!M171","v":4.84148055598938E-3},null,4.84148055598938E-3]
[null,"C",null,{"$f":"'Year on Year Comparison'!M172","v":0.43979384663439014},null,0.43979384663439014]
[null,"H",null,{"$f":"'Year on Year Comparison'!M173","v":7.3403092300484149E-3},null,7.3403092300484149E-3]
[null,"I",null,{"$f":"'Year on Year Comparison'!M174","v":7.652662814305794E-3},null,7.652662814305794E-3]
[null,"J",null,{"$f":"'Year on Year Comparison'!M175","v":7.8088396064344837E-4},null,7.8088396064344837E-4]
[null,"S",null,{"$f":"'Year on Year Comparison'!M176","v":1.405591129158207E-3},null,1.405591129158207E-3]
[null,"O",null,{"$f":"'Year on Year Comparison'!M177","v":7.7932219272216149E-2},null,7.7932219272216149E-2]
[null,"ND",null,{"$f":"'Year on Year Comparison'!M178","v":0.1511791347805716},null,0.1511791347805716]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M179","v":0.14493206309542403},null,0.14493206309542403]
[{"$f":"'Year on Year Comparison'!$N$169","v":2017},"A",{"$f":"'Year on Year Comparison'!N170","v":0.14837463791438688},null,{"$f":"C23/SUM($C$23:$C$32)","v":0.14837463791438688}]
[null,"B",{"$f":"'Year on Year Comparison'!N171","v":4.0231734792404248E-3},null,{"$f":"C24/SUM($C$23:$C$32)","v":4.0231734792404248E-3}]
[null,"C",{"$f":"'Year on Year Comparison'!N172","v":0.43418088187962667},null,0.43418088187962667]
[null,"H",{"$f":"'Year on Year Comparison'!N173","v":6.2761506276150627E-3},null,6.2761506276150627E-3]
[null,"I",{"$f":"'Year on Year Comparison'!N174","v":6.2761506276150627E-3},null,6.2761506276150627E-3]
[null,"J",{"$f":"'Year on Year Comparison'!N175","v":6.4370775667846802E-4},null,6.4370775667846802E-4]
[null,"S",{"$f":"'Year on Year Comparison'!N176","v":1.287415513356936E-3},null,1.287415513356936E-3]
[null,"O",{"$f":"'Year on Year Comparison'!N177","v":7.627936916639845E-2},null,7.627936916639845E-2]
[null,"ND",{"$f":"'Year on Year Comparison'!N178","v":0.17090440939813326},null,0.17090440939813326]
[null,"NR",{"$f":"'Year on Year Comparison'!N179","v":0.15175410363694883},null,0.15175410363694883]
[{"$f":"'Year on Year Comparison'!$O$169","v":2016},"A",null,{"$f":"'Year on Year Comparison'!O170","v":0.13657957244655583},null,{"$f":"D33/SUM($D$33:$D$42)","v":0.13657957244655583}]
[null,"B",null,{"$f":"'Year on Year Comparison'!O171","v":3.7326094333220224E-3},null,3.7326094333220224E-3]
[null,"C",null,{"$f":"'Year on Year Comparison'!O172","v":0.43281303020020362},null,0.43281303020020362]
[null,"H",null,{"$f":"'Year on Year Comparison'!O173","v":6.4472344757380388E-3},null,6.4472344757380388E-3]
[null,"I",null,{"$f":"'Year on Year Comparison'!O174","v":7.2955548014930439E-3},null,7.2955548014930439E-3]
[null,"J",null,{"$f":"'Year on Year Comparison'!O175","v":8.4832032575500507E-4},null,8.4832032575500507E-4]
[null,"S",null,{"$f":"'Year on Year Comparison'!O176","v":8.4832032575500507E-4},null,8.4832032575500507E-4]
[null,"O",null,{"$f":"'Year on Year Comparison'!O177","v":7.3464540210383442E-2},null,7.3464540210383442E-2]
[null,"ND",null,{"$f":"'Year on Year Comparison'!O178","v":0.18951476077366813},null,0.18951476077366813]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O179","v":0.14845605700712589},null,0.14845605700712589]
[{"$f":"'Year on Year Comparison'!$P$169","v":2015},"A",{"$f":"'Year on Year Comparison'!P170","v":0.11844155844155844},null,{"$f":"C43/SUM($C$43:$C$52)","v":0.11846207135434708}]
[null,"B",{"$f":"'Year on Year Comparison'!P171","v":4.1558441558441558E-3},null,{"$f":"C44/SUM($C$43:$C$52)","v":4.1565639071700728E-3}]
[null,"C",{"$f":"'Year on Year Comparison'!P172","v":0.41818181818181815},null,0.41825424315898851]
[null,"H",{"$f":"'Year on Year Comparison'!P173","v":4.8484848484848485E-3},null,4.8493245583650845E-3]
[null,"I",{"$f":"'Year on Year Comparison'!P174","v":6.7532467532467532E-3},null,6.7544163491513685E-3]
[null,"J",{"$f":"'Year on Year Comparison'!P175","v":1.2121212121212121E-3},null,1.2123311395912711E-3]
[null,"S",{"$f":"'Year on Year Comparison'!P176","v":1.038961038961039E-3},null,1.0391409767925182E-3]
[null,"O",{"$f":"'Year on Year Comparison'!P177","v":6.7186147186147183E-2},null,6.7197783165916167E-2]
[null,"ND",{"$f":"'Year on Year Comparison'!P178","v":0.22978354978354978},null,0.22982334603394527]
[null,"NR",{"$f":"'Year on Year Comparison'!P179","v":0.14822510822510823},null,0.14825077935573261]

{"sheet":"Colours","index":25,"n_rows":130,"n_cols":10,"rows_kept":130,"cut":false,"hidden":true,"merged":[]}
[1,0,112,192,null,1,{"$f":"IF(MOD(F1,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2))=0,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2),MOD(F1,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2)))","v":1},{"$f":"INDEX($A$1:$D$10,MATCH(G1,$A$1:$A$10,0),2)","v":0},{"$f":"INDEX($A$1:$D$10,MATCH(G1,$A$1:$A$10,0),3)","v":112},{"$f":"INDEX($A$1:$D$10,MATCH(G1,$A$1:$A$10,0),4)","v":192}]
[2,0,153,255,null,2,{"$f":"IF(MOD(F2,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2))=0,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2),MOD(F2,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2)))","v":2},{"$f":"INDEX($A$1:$D$10,MATCH(G2,$A$1:$A$10,0),2)","v":0},{"$f":"INDEX($A$1:$D$10,MATCH(G2,$A$1:$A$10,0),3)","v":153},{"$f":"INDEX($A$1:$D$10,MATCH(G2,$A$1:$A$10,0),4)","v":255}]
[3,0,176,240,null,3,3,0,176,240]
[4,51,204,255,null,4,4,51,204,255]
[5,155,194,230,null,5,5,155,194,230]
[6,180,198,231,null,6,6,180,198,231]
[7,189,215,238,null,7,7,189,215,238]
[8,217,225,242,null,8,1,0,112,192]
[9,219,219,219,null,9,2,0,153,255]
[10,166,166,166,null,10,3,0,176,240]
[null,"R","G","B",null,11,4,51,204,255]
[null,null,null,null,null,12,5,155,194,230]
[null,null,null,null,null,13,6,180,198,231]
[null,null,null,null,null,14,7,189,215,238]
["Age",6,null,null,null,15,1,0,112,192]
["Disability",4,null,null,null,16,2,0,153,255]
["Ethnicity",4,null,null,null,17,3,0,176,240]
["Gender",2,null,null,null,18,4,51,204,255]
["Relationship",7,null,null,null,19,5,155,194,230]
["Religious",10,null,null,null,20,6,180,198,231]
["Sexual",6,null,null,null,21,7,189,215,238]
[null,null,null,null,null,22,1,0,112,192]
[null,null,null,null,null,23,2,0,153,255]
[null,null,null,null,null,24,3,0,176,240]
["Relationship",null,null,null,null,25,4,51,204,255]
[null,null,null,null,null,26,5,155,194,230]
[null,null,null,null,null,27,6,180,198,231]
[null,null,null,null,null,28,7,189,215,238]
[null,null,null,null,null,29,1,0,112,192]
[null,null,null,null,null,30,2,0,153,255]
[null,null,null,null,null,31,3,0,176,240]
[null,null,null,null,null,32,4,51,204,255]
[null,null,null,null,null,33,5,155,194,230]
[null,null,null,null,null,34,6,180,198,231]
[null,null,null,null,null,35,7,189,215,238]
[null,null,null,null,null,36,1,0,112,192]
[null,null,null,null,null,37,2,0,153,255]
[null,null,null,null,null,38,3,0,176,240]
[null,null,null,null,null,39,4,51,204,255]
[null,null,null,null,null,40,5,155,194,230]
[null,null,null,null,null,41,6,180,198,231]
[null,null,null,null,null,42,7,189,215,238]
[null,null,null,null,null,43,1,0,112,192]
[null,null,null,null,null,44,2,0,153,255]
[null,null,null,null,null,45,3,0,176,240]
[null,null,null,null,null,46,4,51,204,255]
[null,null,null,null,null,47,5,155,194,230]
[null,null,null,null,null,48,6,180,198,231]
[null,null,null,null,null,49,7,189,215,238]
[null,null,null,null,null,50,1,0,112,192]
[null,null,null,null,null,51,2,0,153,255]
[null,null,null,null,null,52,3,0,176,240]
[null,null,null,null,null,53,4,51,204,255]
[null,null,null,null,null,54,5,155,194,230]
[null,null,null,null,null,55,6,180,198,231]
[null,null,null,null,null,56,7,189,215,238]
[null,null,null,null,null,57,1,0,112,192]
[null,null,null,null,null,58,2,0,153,255]
[null,null,null,null,null,59,3,0,176,240]
[null,null,null,null,null,60,4,51,204,255]
[null,null,null,null,null,61,5,155,194,230]
[null,null,null,null,null,62,6,180,198,231]
[null,null,null,null,null,63,7,189,215,238]
[null,null,null,null,null,64,1,0,112,192]
[null,null,null,null,null,65,2,0,153,255]
[null,null,null,null,null,66,{"$f":"IF(MOD(F66,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2))=0,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2),MOD(F66,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2)))","v":3},{"$f":"INDEX($A$1:$D$10,MATCH(G66,$A$1:$A$10,0),2)","v":0},{"$f":"INDEX($A$1:$D$10,MATCH(G66,$A$1:$A$10,0),3)","v":176},{"$f":"INDEX($A$1:$D$10,MATCH(G66,$A$1:$A$10,0),4)","v":240}]
[null,null,null,null,null,67,4,51,204,255]
[null,null,null,null,null,68,5,155,194,230]
[null,null,null,null,null,69,6,180,198,231]
[null,null,null,null,null,70,7,189,215,238]
[null,null,null,null,null,71,1,0,112,192]
[null,null,null,null,null,72,2,0,153,255]
[null,null,null,null,null,73,3,0,176,240]
[null,null,null,null,null,74,4,51,204,255]
[null,null,null,null,null,75,5,155,194,230]
[null,null,null,null,null,76,6,180,198,231]
[null,null,null,null,null,77,7,189,215,238]
[null,null,null,null,null,78,1,0,112,192]
[null,null,null,null,null,79,2,0,{"$f":"INDEX($A$1:$D$10,MATCH(G79,$A$1:$A$10,0),3)","v":153},{"$f":"INDEX($A$1:$D$10,MATCH(G79,$A$1:$A$10,0),4)","v":255}]
[null,null,null,null,null,80,3,0,176,240]
[null,null,null,null,null,81,4,51,204,255]
[null,null,null,null,null,82,5,155,194,230]
[null,null,null,null,null,83,6,180,198,231]
[null,null,null,null,null,84,7,189,215,238]
[null,null,null,null,null,85,1,0,112,192]
[null,null,null,null,null,86,2,0,153,255]
[null,null,null,null,null,87,3,0,176,240]
[null,null,null,null,null,88,4,51,204,255]
[null,null,null,null,null,89,5,155,194,230]
[null,null,null,null,null,90,6,180,198,231]
[null,null,null,null,null,91,7,189,215,238]
[null,null,null,null,null,92,1,0,112,192]
[null,null,null,null,null,93,2,0,153,255]
[null,null,null,null,null,94,3,0,176,240]
[null,null,null,null,null,95,4,51,204,255]
[null,null,null,null,null,96,5,155,194,230]
[null,null,null,null,null,97,6,180,198,231]
[null,null,null,null,null,98,7,189,215,238]
[null,null,null,null,null,99,1,0,112,192]
[null,null,null,null,null,100,2,0,153,255]
[null,null,null,null,null,101,3,0,176,240]
[null,null,null,null,null,102,4,51,204,255]
[null,null,null,null,null,103,5,155,194,230]
[null,null,null,null,null,104,6,180,198,231]
[null,null,null,null,null,105,7,189,215,238]
[null,null,null,null,null,106,1,0,112,192]
[null,null,null,null,null,107,2,0,153,255]
[null,null,null,null,null,108,3,0,176,240]
[null,null,null,null,null,109,4,51,204,255]
[null,null,null,null,null,110,5,155,194,230]
[null,null,null,null,null,111,6,180,198,231]
[null,null,null,null,null,112,7,189,215,238]
[null,null,null,null,null,113,1,0,112,192]
[null,null,null,null,null,114,2,0,153,255]
[null,null,null,null,null,115,3,0,176,240]
[null,null,null,null,null,116,4,51,204,255]
[null,null,null,null,null,117,5,155,194,230]
[null,null,null,null,null,118,6,180,198,231]
[null,null,null,null,null,119,7,189,215,238]
[null,null,null,null,null,120,1,0,112,192]
[null,null,null,null,null,121,2,0,153,255]
[null,null,null,null,null,122,3,0,176,240]
[null,null,null,null,null,123,4,51,204,255]
[null,null,null,null,null,124,5,155,194,230]
[null,null,null,null,null,125,6,180,198,231]
[null,null,null,null,null,126,7,189,215,238]
[null,null,null,null,null,127,1,0,112,192]
[null,null,null,null,null,128,2,0,153,255]
[null,null,null,null,null,129,3,0,176,240]
[null,null,null,null,null,130,{"$f":"IF(MOD(F130,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2))=0,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2),MOD(F130,INDEX($A$15:$B$21,MATCH($A$25,$A$15:$A$21,0),2)))","v":4},{"$f":"INDEX($A$1:$D$10,MATCH(G130,$A$1:$A$10,0),2)","v":51},204,255]