{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["2021 Summary","2021 Data by Employee Type","2021 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":"2021 Summary","index":0,"n_rows":47,"n_cols":26,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Workforce Demographics Overview - 2021"]
[null,"Figures exclude Sulis, WEAHSN, Mass Vaccination Centre & Non-Paid & Recharge"]
[null,"Position as at 31 December"]
[]
[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",823,{"$f":"L7/SUM($L$7:$L$12)","v":0.11322052551932865},null,null,null,null,null,null,null,null,null,null,"Disability","Headcount","%"]
[null,null,null,null,null,null,null,null,null,null,"26-35",2019,0.27775484936029715,null,null,null,null,null,null,null,null,null,null,"Yes",233,{"$f":"Y8/SUM($Y$8:$Y$11)","v":3.2053927637914433E-2}]
[null,null,null,null,null,null,null,null,null,null,"36-45",1586,0.21818682074563214,null,null,null,null,null,null,null,null,null,null,"No",5800,{"$f":"Y9/SUM($Y$8:$Y$11)","v":0.79790892832576699}]
[null,null,null,null,null,null,null,null,null,null,"46-55",1568,0.2157105516577246,null,null,null,null,null,null,null,null,null,null,"Not Declared",123,{"$f":"Y10/SUM($Y$8:$Y$11)","v":1.6921172100701608E-2}]
[null,null,null,null,null,null,null,null,null,null,"56-65",1110,0.15270326042096574,null,null,null,null,null,null,null,null,null,null,"Not Recorded",1113,{"$f":"Y11/SUM($Y$8:$Y$11)","v":0.15311597193561699}]
[null,null,null,null,null,null,null,null,null,null,"66 and Over",163,2.2423992296051725E-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",5411,{"$f":"L18/SUM($L$18:$L$21)","v":0.74439400192598704},null,null,null,null,null,null,null,null,null,null,"Female",5486,{"$f":"Y18/SUM($Y$18:$Y$19)","v":0.75471178979226849}]
[null,null,null,null,null,null,null,null,null,null,"White - Other",603,{"$f":"L19/SUM($L$18:$L$21)","v":8.2955014444903011E-2},null,null,null,null,null,null,null,null,null,null,"Male",1783,{"$f":"Y19/SUM($Y$18:$Y$19)","v":0.24528821020773145}]
[null,null,null,null,null,null,null,null,null,null,"Ethnic Minority (Exlcuding White Minorities)",1091,{"$f":"L20/SUM($L$18:$L$21)","v":0.15008942082817445}]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",164,{"$f":"L21/SUM($L$18:$L$21)","v":2.2561562800935478E-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",3022,{"$f":"L29/SUM($L$29:$L$35)","v":0.41573806575870131},null,null,null,null,null,null,null,null,null,null,"Atheism",1462,{"$f":"Y29/SUM($Y$29:$Y$38)","v":0.20112807814004677}]
[null,null,null,null,null,null,null,null,null,null,"Married",3393,0.46677672307057366,null,null,null,null,null,null,null,null,null,null,"Buddhism",42,5.7779612051176224E-3]
[null,null,null,null,null,null,null,null,null,null,"Civil Partnership",94,1.2931627459072774E-2,null,null,null,null,null,null,null,null,null,null,"Christianity",3224,0.44352730774521942]
[null,null,null,null,null,null,null,null,null,null,"Divorced",373,5.1313798321639841E-2,null,null,null,null,null,null,null,null,null,null,"Hinduism",61,8.3918007979089278E-3]
[null,null,null,null,null,null,null,null,null,null,"Legally Separated",48,6.6033842344201408E-3,null,null,null,null,null,null,null,null,null,null,"Islam",76,1.0455358371165221E-2]
[null,null,null,null,null,null,null,null,null,null,"Widowed",44,6.0531022148851282E-3,null,null,null,null,null,null,null,null,null,null,"Judaism",8,1.1005640390700233E-3]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",295,4.0583298940707113E-2,null,null,null,null,null,null,null,null,null,null,"Sikhism",10,1.3757050488375291E-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",614,8.4468289998624296E-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",1079,0.1484385747695694]
[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",693,9.533635988444078E-2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Sexual Orientation","Headcount","%"]
[null,null,null,null,null,null,null,null,null,null,"Heterosexual",5723,{"$f":"L42/SUM($L$42:$L$47)","v":0.78731599944971797}]
[null,null,null,null,null,null,null,null,null,null,"LGB",205,{"$f":"L43/SUM($L$42:$L$47)","v":2.8201953501169351E-2}]
[null,null,null,null,null,null,null,null,null,null,"Other",2,2.7514100976750583E-4]
[null,null,null,null,null,null,null,null,null,null,"Undecided",13,1.7884165634887881E-3]
[null,null,null,null,null,null,null,null,null,null,"Not Declared",616,8.4743431008391795E-2]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",710,9.7675058467464576E-2]

{"sheet":"2021 Data by Employee Type","index":1,"n_rows":211,"n_cols":13,"rows_kept":211,"cut":false,"hidden":false,"merged":[[84,7,84,9],[85,7,85,9],[86,7,86,9],[87,7,87,9],[88,7,88,9]]}
[]
[null,"Workforce Demographics by Staff Type - 2021"]
[null,"N.B. Staff holding multiple assignments that combined have an FTE of 1 or more have been treated as full time"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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",382,76,365]
[null,null,null,null,null,null,null,null,null,"26-35",1098,488,433]
[null,null,null,null,null,null,null,null,null,"36-45",663,638,285]
[null,null,null,null,null,null,null,null,null,"46-55",765,597,206]
[null,null,null,null,null,null,null,null,null,"56-65",408,516,186]
[null,null,null,null,null,null,null,null,null,"66 and Over",13,88,62]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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",109,76,48]
[null,null,null,null,null,null,null,null,null,"No",2699,1811,1290]
[null,null,null,null,null,null,null,null,null,"Not Declared",34,47,42]
[null,null,null,null,null,null,null,null,null,"Not Recorded",487,469,157]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Ethnicity",null,null,"Substantive - Full Time","Substantive - Part Time","Bank"]
[null,null,null,null,null,null,null,"White British",null,null,2294,2004,1113]
[null,null,null,null,null,null,null,"White Other",null,null,290,173,140]
[null,null,null,null,null,null,null,"Ethnic Minority (Exlcuding White Minorities)",null,null,694,193,204]
[null,null,null,null,null,null,null,"Not Recorded",null,null,51,33,80]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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",2223,2154,1109]
[null,null,null,null,null,null,null,null,null,"Male",1106,249,428]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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",1627,614,781]
[null,null,null,null,null,null,null,null,null,"Married",1347,1489,557]
[null,null,null,null,null,null,null,null,null,"Civil Partnership",45,29,20]
[null,null,null,null,null,null,null,null,null,"Divorced",164,147,62]
[null,null,null,null,null,null,null,null,null,"Legally Separated",24,20,4]
[null,null,null,null,null,null,null,null,null,"Widowed",12,25,7]
[null,null,null,null,null,null,null,null,null,"Not Recorded",110,79,106]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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",734,372,356]
[null,null,null,null,null,null,null,null,null,"Buddhism",21,10,11]
[null,null,null,null,null,null,null,null,null,"Christianity",1503,1098,623]
[null,null,null,null,null,null,null,null,null,"Hinduism",40,9,12]
[null,null,null,null,null,null,null,null,null,"Islam",47,8,21]
[null,null,null,null,null,null,null,null,null,"Judaism",3,3,2]
[null,null,null,null,null,null,null,null,null,"Sikhism",6,2,2]
[null,null,null,null,null,null,null,null,null,"Other",256,201,157]
[null,null,null,null,null,null,null,null,null,"Not Declared",428,390,261]
[null,null,null,null,null,null,null,null,null,"Not Recorded",291,310,92]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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",2662,1827,1234]
[null,null,null,null,null,null,null,null,null,"LGB",118,37,50]
[null,null,null,null,null,null,null,null,null,"Other",0,0,2]
[null,null,null,null,null,null,null,null,null,"Undecided",2,3,8]
[null,null,null,null,null,null,null,null,null,"Not Declared",243,218,155]
[null,null,null,null,null,null,null,null,null,"Not Recorded",304,318,88]

{"sheet":"2021 Data By Pay Band","index":2,"n_rows":211,"n_cols":19,"rows_kept":211,"cut":false,"hidden":false,"merged":[[83,4,83,6],[84,4,84,6],[85,4,85,6],[86,4,86,6],[87,4,87,6]]}
[]
[null,"Workforce Demographics by Pay Band - 2021"]
[null,"Based on Primary Assignment Pay Band"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Age Band","Band 1/2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8A/B","Band 8C-9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"16-25",466,71,38,144,61,6,0,0,35,0,0,2]
[null,null,null,null,null,null,"26-35",403,149,119,489,313,126,36,3,364,1,8,8]
[null,null,null,null,null,null,"36-45",363,138,67,280,250,160,67,15,87,10,140,9]
[null,null,null,null,null,null,"46-55",382,162,74,239,243,205,86,17,17,23,102,18]
[null,null,null,null,null,null,"56-65",348,167,67,169,131,82,46,8,4,16,55,17]
[null,null,null,null,null,null,"66 and Over",71,33,6,20,10,7,0,0,2,2,6,6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Disability Status","Band 1/2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8A/B","Band 8C-9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Yes",81,36,13,45,29,14,3,2,6,0,2,2]
[null,null,null,null,null,null,"No",1639,564,289,1093,807,423,175,32,477,19,236,46]
[null,null,null,null,null,null,"Not Declared",31,13,5,26,21,10,2,1,13,1,0,0]
[null,null,null,null,null,null,"Not Recorded",282,107,64,177,151,139,55,8,13,32,73,12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Ethnicity",null,null,"Band 1/2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8A/B","Band 8C-9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,"White British",null,null,1444,613,300,821,808,494,212,37,364,31,241,46]
[null,null,null,null,"White Other",null,null,244,46,15,99,76,39,14,1,40,6,17,6]
[null,null,null,null,"Ethnic Minority (Exlcuding White Minorities)",null,null,297,47,51,389,106,43,5,4,81,15,49,4]
[null,null,null,null,"Not Recorded",null,null,48,14,5,32,18,10,4,1,24,0,4,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Gender","Band 1/2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8A/B","Band 8C-9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Female",1432,591,305,1126,866,478,183,22,286,31,126,40]
[null,null,null,null,null,null,"Male",601,129,66,215,142,108,52,21,223,21,185,20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Relationship Status","Band 1/2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8A/B","Band 8C-9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Single",975,241,156,634,379,170,62,9,322,10,50,14]
[null,null,null,null,null,null,"Married",776,353,168,578,533,346,149,28,151,38,243,30]
[null,null,null,null,null,null,"Civil Partnership",37,15,6,12,8,9,0,0,4,0,2,1]
[null,null,null,null,null,null,"Divorced",125,67,21,55,39,30,19,5,2,1,6,3]
[null,null,null,null,null,null,"Legally Separated",17,11,3,5,4,5,1,0,0,1,0,1]
[null,null,null,null,null,null,"Widowed",18,5,1,8,5,3,0,0,0,0,2,2]
[null,null,null,null,null,null,"Not Recorded",85,28,16,49,40,23,4,1,30,2,8,9]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Religious Belief","Band 1/2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8A/B","Band 8C-9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Atheism",378,124,85,258,201,103,43,8,191,2,57,12]
[null,null,null,null,null,null,"Buddhism",17,2,0,7,6,1,0,0,6,0,2,1]
[null,null,null,null,null,null,"Christianity",919,335,153,684,477,246,99,19,152,11,107,22]
[null,null,null,null,null,null,"Hinduism",10,1,1,12,6,7,1,1,12,2,7,1]
[null,null,null,null,null,null,"Islam",23,4,3,12,6,2,0,1,15,2,8,0]
[null,null,null,null,null,null,"Judaism",2,1,0,0,1,1,0,0,1,0,2,0]
[null,null,null,null,null,null,"Sikhism",2,0,0,1,1,1,1,0,2,0,2,0]
[null,null,null,null,null,null,"Other",201,90,40,95,77,44,21,1,25,2,13,5]
[null,null,null,null,null,null,"Not Declared",297,102,53,166,151,103,40,8,97,6,47,9]
[null,null,null,null,null,null,"Not Recorded",184,61,36,106,82,78,30,5,8,27,66,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Sexual Orientation","Band 1/2","Band 3","Band 4","Band 5","Band 6","Band 7","Band 8A/B","Band 8C-9","Trainee Grade","Career Grade","Consultant","Other"]
[null,null,null,null,null,null,"Heterosexual",1606,580,297,1087,817,432,182,31,417,19,215,40]
[null,null,null,null,null,null,"LGB",58,20,13,39,21,23,3,2,17,1,4,4]
[null,null,null,null,null,null,"Other",2,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Undecided",9,0,0,2,0,0,1,0,1,0,0,0]
[null,null,null,null,null,null,"Not Declared",170,59,25,106,80,51,19,5,67,4,24,6]
[null,null,null,null,null,null,"Not Recorded",188,61,36,107,90,80,30,5,7,28,68,10]

{"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",2021,2020,2019,2018,2017]
[null,null,null,null,null,null,null,null,null,null,"16-25",{"$f":"'2021 Summary'!M7","v":0.11322052551932865},0.10589332918675168,0.1022675391873383,0.10823051694518195,0.10685548760862568]
[null,null,null,null,null,null,null,null,null,null,"26-35",{"$f":"'2021 Summary'!M8","v":0.27775484936029715},0.26092365106515314,0.25962562775833209,0.25113228174293301,0.25185065980045057]
[null,null,null,null,null,null,null,null,null,null,"36-45",{"$f":"'2021 Summary'!M9","v":0.21818682074563214},0.21551858186907169,0.21488357936387156,0.22036545369358113,0.22095268747988414]
[null,null,null,null,null,null,null,null,null,null,"46-55",{"$f":"'2021 Summary'!M10","v":0.2157105516577246},0.2358886642823822,0.24105919951301172,0.24269873496798375,0.24396523978113938]
[null,null,null,null,null,null,null,null,null,null,"56-65",{"$f":"'2021 Summary'!M11","v":0.15270326042096574},0.16296065930648421,0.15842337543752855,0.15367796345463064,0.15159317669777922]
[null,null,null,null,null,null,null,null,null,null,"66 and Over",{"$f":"'2021 Summary'!M12","v":2.2423992296051725E-2},1.8815114290157052E-2,2.3740678739917819E-2,2.3895049195689522E-2,2.4782748632121016E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Disability",2021,2020,2019,2018,2017]
[null,null,null,null,null,null,null,null,null,null,"Yes",{"$f":"'2021 Summary'!Z8","v":3.2053927637914433E-2},3.3431814647799721E-2,3.1958605996043221E-2,3.2953303139153518E-2,3.3311876408110716E-2]
[null,null,null,null,null,null,null,null,null,null,"No",{"$f":"'2021 Summary'!Z9","v":0.79790892832576699},0.78137148188462136,0.76624562471465529,0.73918475714508824,0.70308979723205667]
[null,null,null,null,null,null,null,null,null,null,"Not Declared",{"$f":"'2021 Summary'!Z10","v":1.6921172100701608E-2},1.5549681231534754E-2,1.4000913103028458E-2,1.1557082617523036E-2,8.6900547151593181E-3]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2021 Summary'!Z11","v":0.15311597193561699},0.16964702223604416,0.18779485618627301,0.21630485709823521,0.25490827164467333]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Ethnicity",2021,2020,2019,2018,2017]
[null,null,null,null,null,null,null,null,null,null,"White British",{"$f":"'2021 Summary'!M18","v":0.74439400192598704},0.76488881977919454,0.76578907320042611,0.77682336404810248,0.77792082394592854]
[null,null,null,null,null,null,null,null,null,null,"White Other",{"$f":"'2021 Summary'!M19","v":8.2955014444903011E-2},9.2365106515316431E-2,9.6636737178511636E-2,0.10198344526003436,0.10959124557450917]
[null,null,null,null,null,null,null,null,null,null,"BME",{"$f":"'2021 Summary'!M20","v":0.15008942082817445},0.12890685740942312,0.12524729873687415,0.11416523504607215,0.10621177985194721]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2021 Summary'!M21","v":2.2561562800935478E-2},1.383921629606593E-2,1.23268908841881E-2,7.027955645791035E-3,6.2761506276150627E-3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Gender",2021,2020,2019,2018,2017]
[null,null,null,null,null,null,null,null,null,null,"Female",{"$f":"'2021 Summary'!Z18","v":0.75471178979226849},0.76240087078214902,0.77035458834271797,0.77822895517726065,0.77261023495333114]
[null,null,null,null,null,null,null,null,null,null,"Male",{"$f":"'2021 Summary'!Z19","v":0.24528821020773145},0.23759912921785104,0.229645411657282,0.22177104482273935,0.2273897650466688]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Relationship Status",2021,2020,2019,2018,2017]
[null,null,null,null,null,null,null,null,null,null,"Single",{"$f":"'2021 Summary'!M29","v":0.41573806575870131},0.39822733633960505,0.38776441941865775,0.39387786974855538,0.39346636626971354]
[null,null,null,null,null,null,null,null,null,null,"Married",{"$f":"'2021 Summary'!M30","v":0.46677672307057366},0.48779350023324519,0.49870643737635062,0.49742308292987664,0.50128741551335698]
[null,null,null,null,null,null,null,null,null,null,"Civil Partnership",{"$f":"'2021 Summary'!M31","v":1.2931627459072774E-2},1.1662260923651064E-2,1.1718155531882515E-2,1.0932375449008278E-2,7.402639201802382E-3]
[null,null,null,null,null,null,null,null,null,null,"Divorced",{"$f":"'2021 Summary'!M32","v":5.1313798321639841E-2},5.2713419374902815E-2,5.2503424136356718E-2,4.8727159144151176E-2,5.2301255230125514E-2]
[null,null,null,null,null,null,null,null,null,null,"Legally Separated",{"$f":"'2021 Summary'!M33","v":6.6033842344201408E-3},9.0188151142901567E-3,8.3701110942017952E-3,9.2144307355926901E-3,1.0299324106855488E-2]
[null,null,null,null,null,null,null,null,null,null,"Widowed",{"$f":"'2021 Summary'!M34","v":6.0531022148851282E-3},7.463846991136682E-3,7.0004565515142288E-3,6.559425269404966E-3,6.115223688445446E-3]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2021 Summary'!M35","v":4.0583298940707113E-2},3.3120821023169024E-2,3.3936995891036374E-2,3.3265656723410898E-2,2.9127775989700674E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Religious Belief",2021,2020,2019,2018,2017]
[null,null,null,null,null,null,null,null,null,null,"Atheism",{"$f":"'2021 Summary'!Z29","v":0.20112807814004677},{"$f":"'2021 Summary'!AA29","v":0},0.17105463399786944,0.16414180852725285,0.14837463791438688]
[null,null,null,null,null,null,null,null,null,null,"Buddhism",{"$f":"'2021 Summary'!Z30","v":5.7779612051176224E-3},{"$f":"'2021 Summary'!AA30","v":0},4.8698828184446808E-3,4.84148055598938E-3,4.0231734792404248E-3]
[null,null,null,null,null,null,null,null,null,null,"Christianity",{"$f":"'2021 Summary'!Z31","v":0.44352730774521942},{"$f":"'2021 Summary'!AA31","v":0},0.4462030132399939,0.43979384663439014,0.43418088187962667]
[null,null,null,null,null,null,null,null,null,null,"Hinduism",{"$f":"'2021 Summary'!Z32","v":8.3918007979089278E-3},{"$f":"'2021 Summary'!AA32","v":0},7.4570080657434179E-3,7.3403092300484149E-3,6.2761506276150627E-3]
[null,null,null,null,null,null,null,null,null,null,"Islam",{"$f":"'2021 Summary'!Z33","v":1.0455358371165221E-2},{"$f":"'2021 Summary'!AA33","v":0},8.2179272561254003E-3,7.652662814305794E-3,6.2761506276150627E-3]
[null,null,null,null,null,null,null,null,null,null,"Judaism",{"$f":"'2021 Summary'!Z34","v":1.1005640390700233E-3},{"$f":"'2021 Summary'!AA34","v":0},9.1310302845837776E-4,7.8088396064344837E-4,6.4370775667846802E-4]
[null,null,null,null,null,null,null,null,null,null,"Sikhism",{"$f":"'2021 Summary'!Z35","v":1.3757050488375291E-3},{"$f":"'2021 Summary'!AA35","v":0},1.3696545426875666E-3,1.405591129158207E-3,1.287415513356936E-3]
[null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"'2021 Summary'!Z36","v":8.4468289998624296E-2},{"$f":"'2021 Summary'!AA36","v":0},8.3396743265865159E-2,7.7932219272216149E-2,7.627936916639845E-2]
[null,null,null,null,null,null,null,null,null,null,"Not Declared",{"$f":"'2021 Summary'!Z37","v":0.1484385747695694},{"$f":"'2021 Summary'!AA37","v":0},0.15233602191447268,0.1511791347805716,0.17090440939813326]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2021 Summary'!Z38","v":9.533635988444078E-2},{"$f":"'2021 Summary'!AA38","v":0},0.12418201187033936,0.14493206309542403,0.15175410363694883]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Sexual Orientation",2021,2020,2019,2018,2017]
[null,null,null,null,null,null,null,null,null,null,"Heterosexual",{"$f":"'2021 Summary'!M42","v":0.78731599944971797},0.78168247550925207,0.76365849946735653,0.74215211619553334,0.59912812736921905]
[null,null,null,null,null,null,null,null,null,null,"LGB",{"$f":"'2021 Summary'!M43","v":2.8201953501169351E-2},2.2547037785725393E-2,1.841424440724395E-2,1.7647977510541934E-2,1.1751326762699014E-2]
[null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"'2021 Summary'!M44","v":2.7514100976750583E-4},1.5549681231534753E-4,1.5218383807639628E-4,"-","-"]
[null,null,null,null,null,null,null,null,null,null,"Undecided",{"$f":"'2021 Summary'!M45","v":1.7884165634887881E-3},1.2439744985227803E-3,9.1310302845837776E-4,"-","-"]
[null,null,null,null,null,null,null,null,null,null,"Not Declared",{"$f":"'2021 Summary'!M46","v":8.4743431008391795E-2},8.2413310527134187E-2,8.8875361436615438E-2,9.1363423395283458E-2,9.9507202426080368E-2]
[null,null,null,null,null,null,null,null,null,null,"Not Recorded",{"$f":"'2021 Summary'!M47","v":9.7675058467464576E-2},0.11195770486705023,0.12798660782224927,0.14883648289864126,0.28961334344200151]

{"sheet":"A Graph Data","index":4,"n_rows":74,"n_cols":10,"rows_kept":74,"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/2","16-25",null,{"$f":"'2021 Data By Pay Band'!H27","v":466},null,{"$f":"D3/SUM($D$3:$D$8)","v":0.2292179045745204},null,null,"X","Y"]
[null,"26-35",null,{"$f":"'2021 Data By Pay Band'!H28","v":403},null,0.19822921790457451,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"36-45",null,{"$f":"'2021 Data By Pay Band'!H29","v":363},null,0.17855386128873585,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"46-55",null,{"$f":"'2021 Data By Pay Band'!H30","v":382},null,0.18789965568125921,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"56-65",null,{"$f":"'2021 Data By Pay Band'!H31","v":348},null,0.17117560255779635,null,4,24.5,0]
[null,">65",null,{"$f":"'2021 Data By Pay Band'!H32","v":71},null,3.4923757993113626E-2,null,5,30.5,0]
["Band 3","16-25",{"$f":"'2021 Data By Pay Band'!I27","v":71},null,{"$f":"C9/SUM($C$9:$C$14)","v":9.8611111111111108E-2},null,null,6,36.5,0]
[null,"26-35",{"$f":"'2021 Data By Pay Band'!I28","v":149},null,0.20694444444444443,null,null,7,42.5,0]
[null,"36-45",{"$f":"'2021 Data By Pay Band'!I29","v":138},null,0.19166666666666668,null,null,8,48.5,0]
[null,"46-55",{"$f":"'2021 Data By Pay Band'!I30","v":162},null,0.22500000000000001,null,null,9,54.5,0]
[null,"56-65",{"$f":"'2021 Data By Pay Band'!I31","v":167},null,0.23194444444444445,null,null,10,60.5,0]
[null,">65",{"$f":"'2021 Data By Pay Band'!I32","v":33},null,4.583333333333333E-2,null,null,11,66.5,0]
["Band 4","16-25",null,{"$f":"'2021 Data By Pay Band'!J27","v":38},null,{"$f":"D15/SUM($D$15:$D$20)","v":0.10242587601078167},null,12,72.5,0]
[null,"26-35",null,{"$f":"'2021 Data By Pay Band'!J28","v":119},null,0.32075471698113206]
[null,"36-45",null,{"$f":"'2021 Data By Pay Band'!J29","v":67},null,0.18059299191374664]
[null,"46-55",null,{"$f":"'2021 Data By Pay Band'!J30","v":74},null,0.19946091644204852]
[null,"56-65",null,{"$f":"'2021 Data By Pay Band'!J31","v":67},null,0.18059299191374664]
[null,">65",null,{"$f":"'2021 Data By Pay Band'!J32","v":6},null,1.6172506738544475E-2]
["Band 5","16-25",{"$f":"'2021 Data By Pay Band'!K27","v":144},null,{"$f":"C21/SUM($C$21:$C$26)","v":0.10738255033557047}]
[null,"26-35",{"$f":"'2021 Data By Pay Band'!K28","v":489},null,0.36465324384787473]
[null,"36-45",{"$f":"'2021 Data By Pay Band'!K29","v":280},null,0.20879940343027592]
[null,"46-55",{"$f":"'2021 Data By Pay Band'!K30","v":239},null,0.17822520507084266]
[null,"56-65",{"$f":"'2021 Data By Pay Band'!K31","v":169},null,0.12602535421327368]
[null,">65",{"$f":"'2021 Data By Pay Band'!K32","v":20},null,1.4914243102162566E-2]
["Band 6","16-25",null,{"$f":"'2021 Data By Pay Band'!L27","v":61},null,{"$f":"D27/SUM($D$27:$D$32)","v":6.0515873015873016E-2}]
[null,"26-35",null,{"$f":"'2021 Data By Pay Band'!L28","v":313},null,0.31051587301587302]
[null,"36-45",null,{"$f":"'2021 Data By Pay Band'!L29","v":250},null,0.24801587301587302]
[null,"46-55",null,{"$f":"'2021 Data By Pay Band'!L30","v":243},null,0.24107142857142858]
[null,"56-65",null,{"$f":"'2021 Data By Pay Band'!L31","v":131},null,0.12996031746031747]
[null,">65",null,{"$f":"'2021 Data By Pay Band'!L32","v":10},null,9.9206349206349201E-3]
["Band 7","16-25",{"$f":"'2021 Data By Pay Band'!M27","v":6},null,{"$f":"C33/SUM($C$33:$C$38)","v":1.0238907849829351E-2}]
[null,"26-35",{"$f":"'2021 Data By Pay Band'!M28","v":126},null,0.21501706484641639]
[null,"36-45",{"$f":"'2021 Data By Pay Band'!M29","v":160},null,0.27303754266211605]
[null,"46-55",{"$f":"'2021 Data By Pay Band'!M30","v":205},null,0.34982935153583616]
[null,"56-65",{"$f":"'2021 Data By Pay Band'!M31","v":82},null,0.13993174061433447]
[null,">65",{"$f":"'2021 Data By Pay Band'!M32","v":7},null,1.1945392491467578E-2]
["Band 8A/B","16-25",null,{"$f":"'2021 Data By Pay Band'!N27","v":0},null,{"$f":"D39/SUM($D$39:$D$44)","v":0}]
[null,"26-35",null,{"$f":"'2021 Data By Pay Band'!N28","v":36},null,0.15319148936170213]
[null,"36-45",null,{"$f":"'2021 Data By Pay Band'!N29","v":67},null,0.28510638297872343]
[null,"46-55",null,{"$f":"'2021 Data By Pay Band'!N30","v":86},null,0.36595744680851061]
[null,"56-65",null,{"$f":"'2021 Data By Pay Band'!N31","v":46},null,0.19574468085106383]
[null,">65",null,{"$f":"'2021 Data By Pay Band'!N32","v":0},null,0]
["Band 8C-9","16-25",{"$f":"'2021 Data By Pay Band'!O27","v":0},null,{"$f":"C45/SUM($C$45:$C$50)","v":0}]
[null,"26-35",{"$f":"'2021 Data By Pay Band'!O28","v":3},null,6.9767441860465115E-2]
[null,"36-45",{"$f":"'2021 Data By Pay Band'!O29","v":15},null,0.34883720930232559]
[null,"46-55",{"$f":"'2021 Data By Pay Band'!O30","v":17},null,0.39534883720930231]
[null,"56-65",{"$f":"'2021 Data By Pay Band'!O31","v":8},null,0.18604651162790697]
[null,">65",{"$f":"'2021 Data By Pay Band'!O32","v":0},null,0]
["Trainee Grade Doctor","16-25",null,{"$f":"'2021 Data By Pay Band'!P27","v":35},null,{"$f":"D51/SUM($D$51:$D$56)","v":6.8762278978389005E-2}]
[null,"26-35",null,{"$f":"'2021 Data By Pay Band'!P28","v":364},null,0.71512770137524562]
[null,"36-45",null,{"$f":"'2021 Data By Pay Band'!P29","v":87},null,0.17092337917485265]
[null,"46-55",null,{"$f":"'2021 Data By Pay Band'!P30","v":17},null,3.3398821218074658E-2]
[null,"56-65",null,{"$f":"'2021 Data By Pay Band'!P31","v":4},null,7.8585461689587421E-3]
[null,">65",null,{"$f":"'2021 Data By Pay Band'!P32","v":2},null,3.929273084479371E-3]
["Career Grade Doctor","16-25",{"$f":"'2021 Data By Pay Band'!Q27","v":0},null,{"$f":"C57/SUM($C$57:$C$62)","v":0}]
[null,"26-35",{"$f":"'2021 Data By Pay Band'!Q28","v":1},null,1.9230769230769232E-2]
[null,"36-45",{"$f":"'2021 Data By Pay Band'!Q29","v":10},null,0.19230769230769232]
[null,"46-55",{"$f":"'2021 Data By Pay Band'!Q30","v":23},null,0.44230769230769229]
[null,"56-65",{"$f":"'2021 Data By Pay Band'!Q31","v":16},null,0.30769230769230771]
[null,">65",{"$f":"'2021 Data By Pay Band'!Q32","v":2},null,3.8461538461538464E-2]
["Consultant","16-25",null,{"$f":"'2021 Data By Pay Band'!R27","v":0},null,{"$f":"D63/SUM($D$63:$D$68)","v":0}]
[null,"26-35",null,{"$f":"'2021 Data By Pay Band'!R28","v":8},null,{"$f":"D64/SUM($D$39:$D$44)","v":3.4042553191489362E-2}]
[null,"36-45",null,{"$f":"'2021 Data By Pay Band'!R29","v":140},null,{"$f":"D65/SUM($D$39:$D$44)","v":0.5957446808510638}]
[null,"46-55",null,{"$f":"'2021 Data By Pay Band'!R30","v":102},null,{"$f":"D66/SUM($D$39:$D$44)","v":0.43404255319148938}]
[null,"56-65",null,{"$f":"'2021 Data By Pay Band'!R31","v":55},null,{"$f":"D67/SUM($D$39:$D$44)","v":0.23404255319148937}]
[null,">65",null,{"$f":"'2021 Data By Pay Band'!R32","v":6},null,{"$f":"D68/SUM($D$39:$D$44)","v":2.553191489361702E-2}]
["Other","16-25",{"$f":"'2021 Data By Pay Band'!S27","v":2},null,{"$f":"C69/SUM($C$69:$C$74)","v":3.3333333333333333E-2}]
[null,"26-35",{"$f":"'2021 Data By Pay Band'!S28","v":8},null,0.13333333333333333]
[null,"36-45",{"$f":"'2021 Data By Pay Band'!S29","v":9},null,0.15]
[null,"46-55",{"$f":"'2021 Data By Pay Band'!S30","v":18},null,0.3]
[null,"56-65",{"$f":"'2021 Data By Pay Band'!S31","v":17},null,0.28333333333333333]
[null,">65",{"$f":"'2021 Data By Pay Band'!S32","v":6},null,0.1]

{"sheet":"D Graph Data","index":5,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Disability","Value",null,"Percentage",null,null,"Dividers",4]
["Band 1/2","Y",null,{"$f":"'2021 Data By Pay Band'!H57","v":81},null,{"$f":"D3/SUM($D$3:$D$6)","v":3.9842597147073291E-2},null,null,"X","Y"]
[null,"N",null,{"$f":"'2021 Data By Pay Band'!H58","v":1639},null,{"$f":"D4/SUM($D$3:$D$6)","v":0.80619773733398914},null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!H59","v":31},null,{"$f":"D5/SUM($D$3:$D$6)","v":1.5248401377274963E-2},null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!H60","v":282},null,{"$f":"D6/SUM($D$3:$D$6)","v":0.13871126414166257},null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Band 3","Y",{"$f":"'2021 Data By Pay Band'!I57","v":36},null,{"$f":"C7/SUM($C$7:$C$10)","v":0.05},null,null,4,16.5,0]
[null,"N",{"$f":"'2021 Data By Pay Band'!I58","v":564},null,{"$f":"C8/SUM($C$7:$C$10)","v":0.78333333333333333},null,null,5,20.5,0]
[null,"ND",{"$f":"'2021 Data By Pay Band'!I59","v":13},null,{"$f":"C9/SUM($C$7:$C$10)","v":1.8055555555555554E-2},null,null,6,24.5,0]
[null,"NR",{"$f":"'2021 Data By Pay Band'!I60","v":107},null,{"$f":"C10/SUM($C$7:$C$10)","v":0.14861111111111111},null,null,7,28.5,0]
["Band 4","Y",null,{"$f":"'2021 Data By Pay Band'!J57","v":13},null,{"$f":"D11/SUM($D$11:$D$14)","v":3.5040431266846361E-2},null,8,32.5,0]
[null,"N",null,{"$f":"'2021 Data By Pay Band'!J58","v":289},null,{"$f":"D12/SUM($D$11:$D$14)","v":0.77897574123989222},null,9,36.5,0]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!J59","v":5},null,{"$f":"D13/SUM($D$11:$D$14)","v":1.3477088948787063E-2},null,10,40.5,0]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!J60","v":64},null,{"$f":"D14/SUM($D$11:$D$14)","v":0.1725067385444744},null,11,44.5,0]
["Band 5","Y",{"$f":"'2021 Data By Pay Band'!K57","v":45},null,{"$f":"C15/SUM($C$15:$C$18)","v":3.3557046979865772E-2},null,null,12,48.5,0]
[null,"N",{"$f":"'2021 Data By Pay Band'!K58","v":1093},null,{"$f":"C16/SUM($C$15:$C$18)","v":0.81506338553318414}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!K59","v":26},null,{"$f":"C17/SUM($C$15:$C$18)","v":1.9388516032811335E-2}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!K60","v":177},null,{"$f":"C18/SUM($C$15:$C$18)","v":0.1319910514541387}]
["Band 6","Y",null,{"$f":"'2021 Data By Pay Band'!L57","v":29},null,{"$f":"D19/SUM($D$19:$D$22)","v":2.8769841269841268E-2}]
[null,"N",null,{"$f":"'2021 Data By Pay Band'!L58","v":807},null,{"$f":"D20/SUM($D$19:$D$22)","v":0.80059523809523814}]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!L59","v":21},null,{"$f":"D21/SUM($D$19:$D$22)","v":2.0833333333333332E-2}]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!L60","v":151},null,{"$f":"D22/SUM($D$19:$D$22)","v":0.1498015873015873}]
["Band 7","Y",{"$f":"'2021 Data By Pay Band'!M57","v":14},null,{"$f":"C23/SUM($C$23:$C$26)","v":2.3890784982935155E-2}]
[null,"N",{"$f":"'2021 Data By Pay Band'!M58","v":423},null,{"$f":"C24/SUM($C$23:$C$26)","v":0.72184300341296925}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!M59","v":10},null,{"$f":"C25/SUM($C$23:$C$26)","v":1.7064846416382253E-2}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!M60","v":139},null,{"$f":"C26/SUM($C$23:$C$26)","v":0.23720136518771331}]
["Band 8A/B","Y",null,{"$f":"'2021 Data By Pay Band'!N57","v":3},null,{"$f":"D27/SUM($D$27:$D$30)","v":1.276595744680851E-2}]
[null,"N",null,{"$f":"'2021 Data By Pay Band'!N58","v":175},null,{"$f":"D28/SUM($D$27:$D$30)","v":0.74468085106382975}]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!N59","v":2},null,{"$f":"D29/SUM($D$27:$D$30)","v":8.5106382978723406E-3}]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!N60","v":55},null,{"$f":"D30/SUM($D$27:$D$30)","v":0.23404255319148937}]
["Band 8C- 9","Y",{"$f":"'2021 Data By Pay Band'!O57","v":2},null,{"$f":"C31/SUM($C$31:$C$34)","v":4.6511627906976744E-2}]
[null,"N",{"$f":"'2021 Data By Pay Band'!O58","v":32},null,{"$f":"C32/SUM($C$31:$C$34)","v":0.7441860465116279}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!O59","v":1},null,{"$f":"C33/SUM($C$31:$C$34)","v":2.3255813953488372E-2}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!O60","v":8},null,{"$f":"C34/SUM($C$31:$C$34)","v":0.18604651162790697}]
["Trainee Grade Doctor","Y",null,{"$f":"'2021 Data By Pay Band'!P57","v":6},null,{"$f":"D35/SUM($D$35:$D$38)","v":1.1787819253438114E-2}]
[null,"N",null,{"$f":"'2021 Data By Pay Band'!P58","v":477},null,{"$f":"D36/SUM($D$35:$D$38)","v":0.93713163064833005}]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!P59","v":13},null,{"$f":"D37/SUM($D$35:$D$38)","v":2.5540275049115914E-2}]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!P60","v":13},null,{"$f":"D38/SUM($D$35:$D$38)","v":2.5540275049115914E-2}]
["Career Grade Doctor","Y",{"$f":"'2021 Data By Pay Band'!Q57","v":0},null,{"$f":"C39/SUM($C$39:$C$42)","v":0}]
[null,"N",{"$f":"'2021 Data By Pay Band'!Q58","v":19},null,{"$f":"C40/SUM($C$39:$C$42)","v":0.36538461538461536}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!Q59","v":1},null,{"$f":"C41/SUM($C$39:$C$42)","v":1.9230769230769232E-2}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!Q60","v":32},null,{"$f":"C42/SUM($C$39:$C$42)","v":0.61538461538461542}]
["Consultant","Y",null,{"$f":"'2021 Data By Pay Band'!R57","v":2},null,{"$f":"D43/SUM($D$43:$D$46)","v":6.4308681672025723E-3}]
[null,"N",null,{"$f":"'2021 Data By Pay Band'!R58","v":236},null,{"$f":"D44/SUM($D$27:$D$30)","v":1.0042553191489361}]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!R59","v":0},null,{"$f":"D45/SUM($D$27:$D$30)","v":0}]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!R60","v":73},null,{"$f":"D46/SUM($D$27:$D$30)","v":0.31063829787234043}]
["Other","Y",{"$f":"'2021 Data By Pay Band'!S57","v":2},null,{"$f":"C47/SUM($C$47:$C$50)","v":3.3333333333333333E-2}]
[null,"N",{"$f":"'2021 Data By Pay Band'!S58","v":46},null,{"$f":"C48/SUM($C$47:$C$50)","v":0.76666666666666672}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!S59","v":0},null,{"$f":"C49/SUM($C$47:$C$50)","v":0}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!S60","v":12},null,{"$f":"C50/SUM($C$47:$C$50)","v":0.2}]

{"sheet":"E Graph Data","index":6,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Ethnicity","Value",null,"Percentage",null,null,"Dividers",4]
["Band 1/2","WB",null,{"$f":"'2021 Data By Pay Band'!H85","v":1444},null,{"$f":"D3/SUM($D$3:$D$6)","v":0.71028037383177567},null,null,"X","Y"]
[null,"WO",null,{"$f":"'2021 Data By Pay Band'!H86","v":244},null,{"$f":"D4/SUM($D$3:$D$6)","v":0.12001967535661584},null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"EM(OWM)",null,{"$f":"'2021 Data By Pay Band'!H87","v":297},null,{"$f":"D5/SUM($D$3:$D$6)","v":0.14608952287260207},null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!H88","v":48},null,{"$f":"D6/SUM($D$3:$D$6)","v":2.3610427939006393E-2},null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Band 3","WB",{"$f":"'2021 Data By Pay Band'!I85","v":613},null,{"$f":"C7/SUM($C$7:$C$10)","v":0.85138888888888886},null,null,4,16.5,0]
[null,"WO",{"$f":"'2021 Data By Pay Band'!I86","v":46},null,{"$f":"C8/SUM($C$7:$C$10)","v":6.3888888888888884E-2},null,null,5,20.5,0]
[null,"EM(OWM)",{"$f":"'2021 Data By Pay Band'!I87","v":47},null,{"$f":"C9/SUM($C$7:$C$10)","v":6.5277777777777782E-2},null,null,6,24.5,0]
[null,"NR",{"$f":"'2021 Data By Pay Band'!I88","v":14},null,{"$f":"C10/SUM($C$7:$C$10)","v":1.9444444444444445E-2},null,null,7,28.5,0]
["Band 4","WB",null,{"$f":"'2021 Data By Pay Band'!J85","v":300},null,{"$f":"D11/SUM($D$11:$D$14)","v":0.80862533692722371},null,8,32.5,0]
[null,"WO",null,{"$f":"'2021 Data By Pay Band'!J86","v":15},null,{"$f":"D12/SUM($D$11:$D$14)","v":4.0431266846361183E-2},null,9,36.5,0]
[null,"EM(OWM)",null,{"$f":"'2021 Data By Pay Band'!J87","v":51},null,{"$f":"D13/SUM($D$11:$D$14)","v":0.13746630727762804},null,10,40.5,0]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!J88","v":5},null,{"$f":"D14/SUM($D$11:$D$14)","v":1.3477088948787063E-2},null,11,44.5,0]
["Band 5","WB",{"$f":"'2021 Data By Pay Band'!K85","v":821},null,{"$f":"C15/SUM($C$15:$C$18)","v":0.61222967934377326},null,null,12,48.5,0]
[null,"WO",{"$f":"'2021 Data By Pay Band'!K86","v":99},null,{"$f":"C16/SUM($C$15:$C$18)","v":7.3825503355704702E-2}]
[null,"EM(OWM)",{"$f":"'2021 Data By Pay Band'!K87","v":389},null,{"$f":"C17/SUM($C$15:$C$18)","v":0.29008202833706187}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!K88","v":32},null,{"$f":"C18/SUM($C$15:$C$18)","v":2.3862788963460103E-2}]
["Band 6","WB",null,{"$f":"'2021 Data By Pay Band'!L85","v":808},null,{"$f":"D19/SUM($D$19:$D$22)","v":0.80158730158730163}]
[null,"WO",null,{"$f":"'2021 Data By Pay Band'!L86","v":76},null,{"$f":"D20/SUM($D$19:$D$22)","v":7.5396825396825393E-2}]
[null,"EM(OWM)",null,{"$f":"'2021 Data By Pay Band'!L87","v":106},null,{"$f":"D21/SUM($D$19:$D$22)","v":0.10515873015873016}]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!L88","v":18},null,{"$f":"D22/SUM($D$19:$D$22)","v":1.7857142857142856E-2}]
["Band 7","WB",{"$f":"'2021 Data By Pay Band'!M85","v":494},null,{"$f":"C23/SUM($C$23:$C$26)","v":0.84300341296928327}]
[null,"WO",{"$f":"'2021 Data By Pay Band'!M86","v":39},null,{"$f":"C24/SUM($C$23:$C$26)","v":6.655290102389079E-2}]
[null,"EM(OWM)",{"$f":"'2021 Data By Pay Band'!M87","v":43},null,{"$f":"C25/SUM($C$23:$C$26)","v":7.3378839590443681E-2}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!M88","v":10},null,{"$f":"C26/SUM($C$23:$C$26)","v":1.7064846416382253E-2}]
["Band 8A/B","WB",null,{"$f":"'2021 Data By Pay Band'!N85","v":212},null,{"$f":"D27/SUM($D$27:$D$30)","v":0.90212765957446805}]
[null,"WO",null,{"$f":"'2021 Data By Pay Band'!N86","v":14},null,{"$f":"D28/SUM($D$27:$D$30)","v":5.9574468085106386E-2}]
[null,"EM(OWM)",null,{"$f":"'2021 Data By Pay Band'!N87","v":5},null,{"$f":"D29/SUM($D$27:$D$30)","v":2.1276595744680851E-2}]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!N88","v":4},null,{"$f":"D30/SUM($D$27:$D$30)","v":1.7021276595744681E-2}]
["Band *c -9","WB",{"$f":"'2021 Data By Pay Band'!O85","v":37},null,{"$f":"C31/SUM($C$31:$C$34)","v":0.86046511627906974}]
[null,"WO",{"$f":"'2021 Data By Pay Band'!O86","v":1},null,{"$f":"C32/SUM($C$31:$C$34)","v":2.3255813953488372E-2}]
[null,"EM(OWM)",{"$f":"'2021 Data By Pay Band'!O87","v":4},null,{"$f":"C33/SUM($C$31:$C$34)","v":9.3023255813953487E-2}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!O88","v":1},null,{"$f":"C34/SUM($C$31:$C$34)","v":2.3255813953488372E-2}]
["Trainee Grade Doctor","WB",null,{"$f":"'2021 Data By Pay Band'!P85","v":364},null,{"$f":"D35/SUM($D$35:$D$38)","v":0.71512770137524562}]
[null,"WO",null,{"$f":"'2021 Data By Pay Band'!P86","v":40},null,{"$f":"D36/SUM($D$35:$D$38)","v":7.8585461689587424E-2}]
[null,"EM(OWM)",null,{"$f":"'2021 Data By Pay Band'!P87","v":81},null,{"$f":"D37/SUM($D$35:$D$38)","v":0.15913555992141454}]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!P88","v":24},null,{"$f":"D38/SUM($D$35:$D$38)","v":4.7151277013752456E-2}]
["Career Grade Doctor","WB",{"$f":"'2021 Data By Pay Band'!Q85","v":31},null,{"$f":"C39/SUM($C$39:$C$42)","v":0.59615384615384615}]
[null,"WO",{"$f":"'2021 Data By Pay Band'!Q86","v":6},null,{"$f":"C40/SUM($C$39:$C$42)","v":0.11538461538461539}]
[null,"EM(OWM)",{"$f":"'2021 Data By Pay Band'!Q87","v":15},null,{"$f":"C41/SUM($C$39:$C$42)","v":0.28846153846153844}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!Q88","v":0},null,{"$f":"C42/SUM($C$39:$C$42)","v":0}]
["Consultant","WB",null,{"$f":"'2021 Data By Pay Band'!R85","v":241},null,{"$f":"D43/SUM($D$43:$D$46)","v":0.77491961414791}]
[null,"WO",null,{"$f":"'2021 Data By Pay Band'!R86","v":17},null,{"$f":"D44/SUM($D$27:$D$30)","v":7.2340425531914887E-2}]
[null,"EM(OWM)",null,{"$f":"'2021 Data By Pay Band'!R87","v":49},null,{"$f":"D45/SUM($D$27:$D$30)","v":0.20851063829787234}]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!R88","v":4},null,{"$f":"D46/SUM($D$27:$D$30)","v":1.7021276595744681E-2}]
["Other","WB",{"$f":"'2021 Data By Pay Band'!S85","v":46},null,{"$f":"C47/SUM($C$47:$C$50)","v":0.76666666666666672}]
[null,"WO",{"$f":"'2021 Data By Pay Band'!S86","v":6},null,{"$f":"C48/SUM($C$47:$C$50)","v":0.1}]
[null,"EM(OWM)",{"$f":"'2021 Data By Pay Band'!S87","v":4},null,{"$f":"C49/SUM($C$47:$C$50)","v":6.6666666666666666E-2}]
[null,"NR",{"$f":"'2021 Data By Pay Band'!S88","v":4},null,{"$f":"C50/SUM($C$47:$C$50)","v":6.6666666666666666E-2}]

{"sheet":"G Graph Data","index":7,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Gender","Value",null,"Percentage",null,null,"Dividers",2]
["Band 1/2","F",null,{"$f":"'2021 Data By Pay Band'!H113","v":1432},null,{"$f":"D3/SUM($D$3:$D$4)","v":0.70437776684702413},null,null,"X","Y"]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!H114","v":601},null,{"$f":"D4/SUM($D$3:$D$4)","v":0.29562223315297592},null,1,{"$f":"$I$2*H4+0.5","v":2.5},0]
["Band 3","F",{"$f":"'2021 Data By Pay Band'!I113","v":591},null,{"$f":"C5/SUM($C$5:$C$6)","v":0.8208333333333333},null,null,2,{"$f":"$I$2*H5+0.5","v":4.5},0]
[null,"M",{"$f":"'2021 Data By Pay Band'!I114","v":129},null,{"$f":"C6/SUM($C$5:$C$6)","v":0.17916666666666667},null,null,3,{"$f":"$I$2*H6+0.5","v":6.5},0]
["Band 4","F",null,{"$f":"'2021 Data By Pay Band'!J113","v":305},null,{"$f":"D7/SUM($D$7:$D$8)","v":0.82210242587601079},null,4,8.5,0]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!J114","v":66},null,{"$f":"D8/SUM($D$7:$D$8)","v":0.17789757412398921},null,5,10.5,0]
["Band 5","F",{"$f":"'2021 Data By Pay Band'!K113","v":1126},null,{"$f":"C9/SUM($C$9:$C$10)","v":0.83967188665175241},null,null,6,12.5,0]
[null,"M",{"$f":"'2021 Data By Pay Band'!K114","v":215},null,{"$f":"C10/SUM($C$9:$C$10)","v":0.16032811334824756},null,null,7,14.5,0]
["Band 6","F",null,{"$f":"'2021 Data By Pay Band'!L113","v":866},null,{"$f":"D11/SUM($D$11:$D$12)","v":0.85912698412698407},null,8,16.5,0]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!L114","v":142},null,{"$f":"D12/SUM($D$11:$D$12)","v":0.14087301587301587},null,9,18.5,0]
["Band 7","F",{"$f":"'2021 Data By Pay Band'!M113","v":478},null,{"$f":"C13/SUM($C$13:$C$14)","v":0.81569965870307171},null,null,10,20.5,0]
[null,"M",{"$f":"'2021 Data By Pay Band'!M114","v":108},null,{"$f":"C14/SUM($C$13:$C$14)","v":0.18430034129692832},null,null,11,22.5,0]
["Band 8A/B","F",null,{"$f":"'2021 Data By Pay Band'!N113","v":183},null,{"$f":"D15/SUM($D$15:$D$16)","v":0.77872340425531916},null,12,24.5,0]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!N114","v":52},null,{"$f":"D16/SUM($D$15:$D$16)","v":0.22127659574468084}]
["Band 8C-9","F",{"$f":"'2021 Data By Pay Band'!O113","v":22},null,{"$f":"C17/SUM($C$17:$C$18)","v":0.51162790697674421}]
[null,"M",{"$f":"'2021 Data By Pay Band'!O114","v":21},null,{"$f":"C18/SUM($C$17:$C$18)","v":0.48837209302325579}]
["Trainee Grade Doctor","F",null,{"$f":"'2021 Data By Pay Band'!P113","v":286},null,{"$f":"D19/SUM($D$19:$D$20)","v":0.56188605108055012}]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!P114","v":223},null,{"$f":"D20/SUM($D$19:$D$20)","v":0.43811394891944988}]
["Career Grade Doctor","F",{"$f":"'2021 Data By Pay Band'!Q113","v":31},null,{"$f":"C21/SUM($C$21:$C$22)","v":0.59615384615384615}]
[null,"M",{"$f":"'2021 Data By Pay Band'!Q114","v":21},null,{"$f":"C22/SUM($C$21:$C$22)","v":0.40384615384615385}]
["Consultant","F",null,{"$f":"'2021 Data By Pay Band'!R113","v":126},null,{"$f":"D23/SUM($D$23:$D$24)","v":0.40514469453376206}]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!R114","v":185},null,{"$f":"D24/SUM($D$15:$D$16)","v":0.78723404255319152}]
["Other","F",{"$f":"'2021 Data By Pay Band'!S113","v":40},null,{"$f":"C25/SUM($C$25:$C$26)","v":0.66666666666666663}]
[null,"M",{"$f":"'2021 Data By Pay Band'!S114","v":20},null,{"$f":"C26/SUM($C$25:$C$26)","v":0.33333333333333331}]

{"sheet":"RB Graph Data","index":8,"n_rows":122,"n_cols":10,"rows_kept":122,"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/2","A",null,{"$f":"'2021 Data By Pay Band'!H172","v":378},null,{"$f":"D3/SUM($D$3:$D$12)","v":0.18593212001967535},null,null,"X","Y"]
[null,"B",null,{"$f":"'2021 Data By Pay Band'!H173","v":17},null,8.362026561731432E-3,null,1,{"$f":"$I$2*H4+0.5","v":10.5},0]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!H174","v":919},null,0.45204131824889326,null,2,{"$f":"$I$2*H5+0.5","v":20.5},0]
[null,"H",null,{"$f":"'2021 Data By Pay Band'!H175","v":10},null,4.9188391539596657E-3,null,3,{"$f":"$I$2*H6+0.5","v":30.5},0]
[null,"I",null,{"$f":"'2021 Data By Pay Band'!H176","v":23},null,1.1313330054107231E-2,null,4,40.5,0]
[null,"J",null,{"$f":"'2021 Data By Pay Band'!H177","v":2},null,9.8376783079193305E-4,null,5,50.5,0]
[null,"S",null,{"$f":"'2021 Data By Pay Band'!H178","v":2},null,9.8376783079193305E-4,null,6,60.5,0]
[null,"O",null,{"$f":"'2021 Data By Pay Band'!H179","v":201},null,9.886866699458928E-2,null,7,70.5,0]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!H180","v":297},null,0.14608952287260207,null,8,80.5,0]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!H181","v":184},null,9.0506640432857846E-2,null,9,90.5,0]
["Band 3","A",{"$f":"'2021 Data By Pay Band'!I172","v":124},null,{"$f":"C13/SUM($C$13:$C$22)","v":0.17222222222222222},null,null,10,100.5,0]
[null,"B",{"$f":"'2021 Data By Pay Band'!I173","v":2},null,{"$f":"C14/SUM($C$13:$C$22)","v":2.7777777777777779E-3},null,null,11,110.5,0]
[null,"C",{"$f":"'2021 Data By Pay Band'!I174","v":335},null,0.46527777777777779,null,null,12,120.5,0]
[null,"H",{"$f":"'2021 Data By Pay Band'!I175","v":1},null,1.3888888888888889E-3]
[null,"I",{"$f":"'2021 Data By Pay Band'!I176","v":4},null,5.5555555555555558E-3]
[null,"J",{"$f":"'2021 Data By Pay Band'!I177","v":1},null,1.3888888888888889E-3]
[null,"S",{"$f":"'2021 Data By Pay Band'!I178","v":0},null,0]
[null,"O",{"$f":"'2021 Data By Pay Band'!I179","v":90},null,0.125]
[null,"ND",{"$f":"'2021 Data By Pay Band'!I180","v":102},null,0.14166666666666666]
[null,"NR",{"$f":"'2021 Data By Pay Band'!I181","v":61},null,8.4722222222222227E-2]
["Band 4","A",null,{"$f":"'2021 Data By Pay Band'!J172","v":85},null,{"$f":"D23/SUM($D$23:$D$32)","v":0.22911051212938005}]
[null,"B",null,{"$f":"'2021 Data By Pay Band'!J173","v":0},null,0]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!J174","v":153},null,0.41239892183288412]
[null,"H",null,{"$f":"'2021 Data By Pay Band'!J175","v":1},null,2.6954177897574125E-3]
[null,"I",null,{"$f":"'2021 Data By Pay Band'!J176","v":3},null,8.0862533692722376E-3]
[null,"J",null,{"$f":"'2021 Data By Pay Band'!J177","v":0},null,0]
[null,"S",null,{"$f":"'2021 Data By Pay Band'!J178","v":0},null,0]
[null,"O",null,{"$f":"'2021 Data By Pay Band'!J179","v":40},null,0.1078167115902965]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!J180","v":53},null,0.14285714285714285]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!J181","v":36},null,9.7035040431266845E-2]
["Band 5","A",{"$f":"'2021 Data By Pay Band'!K172","v":258},null,{"$f":"C33/SUM($C$33:$C$42)","v":0.19239373601789708}]
[null,"B",{"$f":"'2021 Data By Pay Band'!K173","v":7},null,{"$f":"C34/SUM($C$33:$C$42)","v":5.219985085756898E-3}]
[null,"C",{"$f":"'2021 Data By Pay Band'!K174","v":684},null,0.51006711409395977]
[null,"H",{"$f":"'2021 Data By Pay Band'!K175","v":12},null,8.948545861297539E-3]
[null,"I",{"$f":"'2021 Data By Pay Band'!K176","v":12},null,8.948545861297539E-3]
[null,"J",{"$f":"'2021 Data By Pay Band'!K177","v":0},null,0]
[null,"S",{"$f":"'2021 Data By Pay Band'!K178","v":1},null,7.4571215510812821E-4]
[null,"O",{"$f":"'2021 Data By Pay Band'!K179","v":95},null,7.0842654735272181E-2]
[null,"ND",{"$f":"'2021 Data By Pay Band'!K180","v":166},null,0.12378821774794929]
[null,"NR",{"$f":"'2021 Data By Pay Band'!K181","v":106},null,7.90454884414616E-2]
["Band 6","A",null,{"$f":"'2021 Data By Pay Band'!L172","v":201},null,{"$f":"D43/SUM($D$43:$D$52)","v":0.19940476190476192}]
[null,"B",null,{"$f":"'2021 Data By Pay Band'!L173","v":6},null,5.9523809523809521E-3]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!L174","v":477},null,0.4732142857142857]
[null,"H",null,{"$f":"'2021 Data By Pay Band'!L175","v":6},null,5.9523809523809521E-3]
[null,"I",null,{"$f":"'2021 Data By Pay Band'!L176","v":6},null,5.9523809523809521E-3]
[null,"J",null,{"$f":"'2021 Data By Pay Band'!L177","v":1},null,9.9206349206349201E-4]
[null,"S",null,{"$f":"'2021 Data By Pay Band'!L178","v":1},null,9.9206349206349201E-4]
[null,"O",null,{"$f":"'2021 Data By Pay Band'!L179","v":77},null,7.6388888888888895E-2]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!L180","v":151},null,0.1498015873015873]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!L181","v":82},null,8.1349206349206352E-2]
["Band 7","A",{"$f":"'2021 Data By Pay Band'!M172","v":103},null,{"$f":"C53/SUM($C$53:$C$62)","v":0.17576791808873721}]
[null,"B",{"$f":"'2021 Data By Pay Band'!M173","v":1},null,{"$f":"C54/SUM($C$53:$C$62)","v":1.7064846416382253E-3}]
[null,"C",{"$f":"'2021 Data By Pay Band'!M174","v":246},null,0.41979522184300339]
[null,"H",{"$f":"'2021 Data By Pay Band'!M175","v":7},null,1.1945392491467578E-2]
[null,"I",{"$f":"'2021 Data By Pay Band'!M176","v":2},null,3.4129692832764505E-3]
[null,"J",{"$f":"'2021 Data By Pay Band'!M177","v":1},null,1.7064846416382253E-3]
[null,"S",{"$f":"'2021 Data By Pay Band'!M178","v":1},null,1.7064846416382253E-3]
[null,"O",{"$f":"'2021 Data By Pay Band'!M179","v":44},null,7.5085324232081918E-2]
[null,"ND",{"$f":"'2021 Data By Pay Band'!M180","v":103},null,0.17576791808873721]
[null,"NR",{"$f":"'2021 Data By Pay Band'!M181","v":78},null,0.13310580204778158]
["Band 8A/B","A",null,{"$f":"'2021 Data By Pay Band'!N172","v":43},null,{"$f":"D63/SUM($D$63:$D$72)","v":0.18297872340425531}]
[null,"B",null,{"$f":"'2021 Data By Pay Band'!N173","v":0},null,0]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!N174","v":99},null,0.42127659574468085]
[null,"H",null,{"$f":"'2021 Data By Pay Band'!N175","v":1},null,4.2553191489361703E-3]
[null,"I",null,{"$f":"'2021 Data By Pay Band'!N176","v":0},null,0]
[null,"J",null,{"$f":"'2021 Data By Pay Band'!N177","v":0},null,0]
[null,"S",null,{"$f":"'2021 Data By Pay Band'!N178","v":1},null,4.2553191489361703E-3]
[null,"O",null,{"$f":"'2021 Data By Pay Band'!N179","v":21},null,8.9361702127659579E-2]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!N180","v":40},null,0.1702127659574468]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!N181","v":30},null,0.1276595744680851]
["Band 8C-9","A",{"$f":"'2021 Data By Pay Band'!O172","v":8},null,{"$f":"C73/SUM($C$73:$C$82)","v":0.18604651162790697}]
[null,"B",{"$f":"'2021 Data By Pay Band'!O173","v":0},null,{"$f":"C74/SUM($C$73:$C$82)","v":0}]
[null,"C",{"$f":"'2021 Data By Pay Band'!O174","v":19},null,0.44186046511627908]
[null,"H",{"$f":"'2021 Data By Pay Band'!O175","v":1},null,2.3255813953488372E-2]
[null,"I",{"$f":"'2021 Data By Pay Band'!O176","v":1},null,2.3255813953488372E-2]
[null,"J",{"$f":"'2021 Data By Pay Band'!O177","v":0},null,0]
[null,"S",{"$f":"'2021 Data By Pay Band'!O178","v":0},null,0]
[null,"O",{"$f":"'2021 Data By Pay Band'!O179","v":1},null,2.3255813953488372E-2]
[null,"ND",{"$f":"'2021 Data By Pay Band'!O180","v":8},null,0.18604651162790697]
[null,"NR",{"$f":"'2021 Data By Pay Band'!O181","v":5},null,0.11627906976744186]
["Trainee Grade Doctor","A",null,{"$f":"'2021 Data By Pay Band'!P172","v":191},null,{"$f":"D83/SUM($D$83:$D$92)","v":0.37524557956777999}]
[null,"B",null,{"$f":"'2021 Data By Pay Band'!P173","v":6},null,{"$f":"D84/SUM($D$83:$D$92)","v":1.1787819253438114E-2}]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!P174","v":152},null,0.29862475442043224]
[null,"H",null,{"$f":"'2021 Data By Pay Band'!P175","v":12},null,2.3575638506876228E-2]
[null,"I",null,{"$f":"'2021 Data By Pay Band'!P176","v":15},null,2.9469548133595286E-2]
[null,"J",null,{"$f":"'2021 Data By Pay Band'!P177","v":1},null,1.9646365422396855E-3]
[null,"S",null,{"$f":"'2021 Data By Pay Band'!P178","v":2},null,3.929273084479371E-3]
[null,"O",null,{"$f":"'2021 Data By Pay Band'!P179","v":25},null,4.9115913555992138E-2]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!P180","v":97},null,0.19056974459724951]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!P181","v":8},null,1.5717092337917484E-2]
["Career Grade Doctor","A",{"$f":"'2021 Data By Pay Band'!Q172","v":2},null,{"$f":"C93/SUM($C$93:$C$102)","v":3.8461538461538464E-2}]
[null,"B",{"$f":"'2021 Data By Pay Band'!Q173","v":0},null,{"$f":"C94/SUM($C$93:$C$102)","v":0}]
[null,"C",{"$f":"'2021 Data By Pay Band'!Q174","v":11},null,0.21153846153846154]
[null,"H",{"$f":"'2021 Data By Pay Band'!Q175","v":2},null,3.8461538461538464E-2]
[null,"I",{"$f":"'2021 Data By Pay Band'!Q176","v":2},null,3.8461538461538464E-2]
[null,"J",{"$f":"'2021 Data By Pay Band'!Q177","v":0},null,0]
[null,"S",{"$f":"'2021 Data By Pay Band'!Q178","v":0},null,0]
[null,"O",{"$f":"'2021 Data By Pay Band'!Q179","v":2},null,3.8461538461538464E-2]
[null,"ND",{"$f":"'2021 Data By Pay Band'!Q180","v":6},null,0.11538461538461539]
[null,"NR",{"$f":"'2021 Data By Pay Band'!Q181","v":27},null,0.51923076923076927]
["Consultant","A",null,{"$f":"'2021 Data By Pay Band'!R172","v":57},null,{"$f":"D103/SUM($D$103:$D$112)","v":0.18327974276527331}]
[null,"B",null,{"$f":"'2021 Data By Pay Band'!R173","v":2},null,{"$f":"D104/SUM($D$63:$D$72)","v":8.5106382978723406E-3}]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!R174","v":107},null,0.4553191489361702]
[null,"H",null,{"$f":"'2021 Data By Pay Band'!R175","v":7},null,2.9787234042553193E-2]
[null,"I",null,{"$f":"'2021 Data By Pay Band'!R176","v":8},null,3.4042553191489362E-2]
[null,"J",null,{"$f":"'2021 Data By Pay Band'!R177","v":2},null,8.5106382978723406E-3]
[null,"S",null,{"$f":"'2021 Data By Pay Band'!R178","v":2},null,8.5106382978723406E-3]
[null,"O",null,{"$f":"'2021 Data By Pay Band'!R179","v":13},null,5.5319148936170209E-2]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!R180","v":47},null,0.2]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!R181","v":66},null,0.28085106382978725]
["Other","A",{"$f":"'2021 Data By Pay Band'!S172","v":12},null,{"$f":"C113/SUM($C$113:$C$122)","v":0.2}]
[null,"B",{"$f":"'2021 Data By Pay Band'!S173","v":1},null,{"$f":"C114/SUM($C$113:$C$122)","v":1.6666666666666666E-2}]
[null,"C",{"$f":"'2021 Data By Pay Band'!S174","v":22},null,0.36666666666666664]
[null,"H",{"$f":"'2021 Data By Pay Band'!S175","v":1},null,1.6666666666666666E-2]
[null,"I",{"$f":"'2021 Data By Pay Band'!S176","v":0},null,0]
[null,"J",{"$f":"'2021 Data By Pay Band'!S177","v":0},null,0]
[null,"S",{"$f":"'2021 Data By Pay Band'!S178","v":0},null,0]
[null,"O",{"$f":"'2021 Data By Pay Band'!S179","v":5},null,8.3333333333333329E-2]
[null,"ND",{"$f":"'2021 Data By Pay Band'!S180","v":9},null,0.15]
[null,"NR",{"$f":"'2021 Data By Pay Band'!S181","v":10},null,0.16666666666666666]

{"sheet":"RS Graph Data","index":9,"n_rows":86,"n_cols":10,"rows_kept":86,"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/2","S",null,{"$f":"'2021 Data By Pay Band'!H141","v":975},null,{"$f":"D3/SUM($D$3:$D$9)","v":0.47958681751106741},null,null,"X","Y"]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!H142","v":776},null,0.38170191834727002,null,1,{"$f":"$I$2*H4+0.5","v":7.5},0]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!H143","v":37},null,1.8199704869650762E-2,null,2,{"$f":"$I$2*H5+0.5","v":14.5},0]
[null,"D",null,{"$f":"'2021 Data By Pay Band'!H144","v":125},null,6.1485489424495818E-2,null,3,{"$f":"$I$2*H6+0.5","v":21.5},0]
[null,"LS",null,{"$f":"'2021 Data By Pay Band'!H145","v":17},null,8.362026561731432E-3,null,4,28.5,0]
[null,"W",null,{"$f":"'2021 Data By Pay Band'!H146","v":18},null,8.8539104771273979E-3,null,5,35.5,0]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!H147","v":85},null,4.1810132808657155E-2,null,6,42.5,0]
["Band 3","S",{"$f":"'2021 Data By Pay Band'!I141","v":241},null,{"$f":"C10/SUM($C$10:$C$16)","v":0.3347222222222222},null,null,7,49.5,0]
[null,"M",{"$f":"'2021 Data By Pay Band'!I142","v":353},null,0.49027777777777776,null,null,8,56.5,0]
[null,"C",{"$f":"'2021 Data By Pay Band'!I143","v":15},null,2.0833333333333332E-2,null,null,9,63.5,0]
[null,"D",{"$f":"'2021 Data By Pay Band'!I144","v":67},null,9.3055555555555558E-2,null,null,10,70.5,0]
[null,"LS",{"$f":"'2021 Data By Pay Band'!I145","v":11},null,1.5277777777777777E-2,null,null,11,77.5,0]
[null,"W",{"$f":"'2021 Data By Pay Band'!I146","v":5},null,6.9444444444444441E-3,null,null,12,84.5,0]
[null,"NR",{"$f":"'2021 Data By Pay Band'!I147","v":28},null,3.888888888888889E-2]
["Band 4","S",null,{"$f":"'2021 Data By Pay Band'!J141","v":156},null,{"$f":"D17/SUM($D$17:$D$23)","v":0.42048517520215634}]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!J142","v":168},null,0.45283018867924529]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!J143","v":6},null,1.6172506738544475E-2]
[null,"D",null,{"$f":"'2021 Data By Pay Band'!J144","v":21},null,5.6603773584905662E-2]
[null,"LS",null,{"$f":"'2021 Data By Pay Band'!J145","v":3},null,8.0862533692722376E-3]
[null,"W",null,{"$f":"'2021 Data By Pay Band'!J146","v":1},null,2.6954177897574125E-3]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!J147","v":16},null,4.3126684636118601E-2]
["Band 5","S",{"$f":"'2021 Data By Pay Band'!K141","v":634},null,{"$f":"C24/SUM($C$24:$C$30)","v":0.47278150633855331}]
[null,"M",{"$f":"'2021 Data By Pay Band'!K142","v":578},null,0.43102162565249813]
[null,"C",{"$f":"'2021 Data By Pay Band'!K143","v":12},null,8.948545861297539E-3]
[null,"D",{"$f":"'2021 Data By Pay Band'!K144","v":55},null,4.1014168530947054E-2]
[null,"LS",{"$f":"'2021 Data By Pay Band'!K145","v":5},null,3.7285607755406414E-3]
[null,"W",{"$f":"'2021 Data By Pay Band'!K146","v":8},null,5.9656972408650257E-3]
[null,"NR",{"$f":"'2021 Data By Pay Band'!K147","v":49},null,3.6539895600298286E-2]
["Band 6","S",null,{"$f":"'2021 Data By Pay Band'!L141","v":379},null,{"$f":"D31/SUM($D$31:$D$37)","v":0.37599206349206349}]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!L142","v":533},null,0.52876984126984128]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!L143","v":8},null,7.9365079365079361E-3]
[null,"D",null,{"$f":"'2021 Data By Pay Band'!L144","v":39},null,3.8690476190476192E-2]
[null,"LS",null,{"$f":"'2021 Data By Pay Band'!L145","v":4},null,3.968253968253968E-3]
[null,"W",null,{"$f":"'2021 Data By Pay Band'!L146","v":5},null,4.96031746031746E-3]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!L147","v":40},null,3.968253968253968E-2]
["Band 7","S",{"$f":"'2021 Data By Pay Band'!M141","v":170},null,{"$f":"C38/SUM($C$38:$C$44)","v":0.29010238907849828}]
[null,"M",{"$f":"'2021 Data By Pay Band'!M142","v":346},null,0.59044368600682595]
[null,"C",{"$f":"'2021 Data By Pay Band'!M143","v":9},null,1.5358361774744027E-2]
[null,"D",{"$f":"'2021 Data By Pay Band'!M144","v":30},null,5.1194539249146756E-2]
[null,"LS",{"$f":"'2021 Data By Pay Band'!M145","v":5},null,8.5324232081911266E-3]
[null,"W",{"$f":"'2021 Data By Pay Band'!M146","v":3},null,5.1194539249146756E-3]
[null,"NR",{"$f":"'2021 Data By Pay Band'!M147","v":23},null,3.9249146757679182E-2]
["Band 8A/B","S",null,{"$f":"'2021 Data By Pay Band'!N141","v":62},null,{"$f":"D45/SUM($D$45:$D$51)","v":0.26382978723404255}]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!N142","v":149},null,0.63404255319148939]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!N143","v":0},null,0]
[null,"D",null,{"$f":"'2021 Data By Pay Band'!N144","v":19},null,8.085106382978724E-2]
[null,"LS",null,{"$f":"'2021 Data By Pay Band'!N145","v":1},null,4.2553191489361703E-3]
[null,"W",null,{"$f":"'2021 Data By Pay Band'!N146","v":0},null,0]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!N147","v":4},null,1.7021276595744681E-2]
["Band 8C-9","S",{"$f":"'2021 Data By Pay Band'!O141","v":9},null,{"$f":"C52/SUM($C$52:$C$58)","v":0.20930232558139536}]
[null,"M",{"$f":"'2021 Data By Pay Band'!O142","v":28},null,0.65116279069767447]
[null,"C",{"$f":"'2021 Data By Pay Band'!O143","v":0},null,0]
[null,"D",{"$f":"'2021 Data By Pay Band'!O144","v":5},null,0.11627906976744186]
[null,"LS",{"$f":"'2021 Data By Pay Band'!O145","v":0},null,0]
[null,"W",{"$f":"'2021 Data By Pay Band'!O146","v":0},null,0]
[null,"NR",{"$f":"'2021 Data By Pay Band'!O147","v":1},null,2.3255813953488372E-2]
["Trainee Grade Doctor","S",null,{"$f":"'2021 Data By Pay Band'!P141","v":322},null,{"$f":"D59/SUM($D$59:$D$65)","v":0.63261296660117883}]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!P142","v":151},null,0.29666011787819252]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!P143","v":4},null,7.8585461689587421E-3]
[null,"D",null,{"$f":"'2021 Data By Pay Band'!P144","v":2},null,3.929273084479371E-3]
[null,"LS",null,{"$f":"'2021 Data By Pay Band'!P145","v":0},null,0]
[null,"W",null,{"$f":"'2021 Data By Pay Band'!P146","v":0},null,0]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!P147","v":30},null,5.8939096267190572E-2]
["Career Grade Doctor","S",{"$f":"'2021 Data By Pay Band'!Q141","v":10},null,{"$f":"C66/SUM($C$66:$C$72)","v":0.19230769230769232}]
[null,"M",{"$f":"'2021 Data By Pay Band'!Q142","v":38},null,0.73076923076923073]
[null,"C",{"$f":"'2021 Data By Pay Band'!Q143","v":0},null,0]
[null,"D",{"$f":"'2021 Data By Pay Band'!Q144","v":1},null,1.9230769230769232E-2]
[null,"LS",{"$f":"'2021 Data By Pay Band'!Q145","v":1},null,1.9230769230769232E-2]
[null,"W",{"$f":"'2021 Data By Pay Band'!Q146","v":0},null,0]
[null,"NR",{"$f":"'2021 Data By Pay Band'!Q147","v":2},null,3.8461538461538464E-2]
["Consultant","S",null,{"$f":"'2021 Data By Pay Band'!R141","v":50},null,{"$f":"D73/SUM($D$73:$D$79)","v":0.16077170418006431}]
[null,"M",null,{"$f":"'2021 Data By Pay Band'!R142","v":243},null,{"$f":"D74/SUM($D$45:$D$51)","v":1.0340425531914894}]
[null,"C",null,{"$f":"'2021 Data By Pay Band'!R143","v":2},null,8.5106382978723406E-3]
[null,"D",null,{"$f":"'2021 Data By Pay Band'!R144","v":6},null,2.553191489361702E-2]
[null,"LS",null,{"$f":"'2021 Data By Pay Band'!R145","v":0},null,0]
[null,"W",null,{"$f":"'2021 Data By Pay Band'!R146","v":2},null,8.5106382978723406E-3]
[null,"NR",null,{"$f":"'2021 Data By Pay Band'!R147","v":8},null,3.4042553191489362E-2]
["Other","S",{"$f":"'2021 Data By Pay Band'!S141","v":14},null,{"$f":"C80/SUM($C$80:$C$86)","v":0.23333333333333334}]
[null,"M",{"$f":"'2021 Data By Pay Band'!S142","v":30},null,{"$f":"C81/SUM($C$80:$C$86)","v":0.5}]
[null,"C",{"$f":"'2021 Data By Pay Band'!S143","v":1},null,1.6666666666666666E-2]
[null,"D",{"$f":"'2021 Data By Pay Band'!S144","v":3},null,0.05]
[null,"LS",{"$f":"'2021 Data By Pay Band'!S145","v":1},null,1.6666666666666666E-2]
[null,"W",{"$f":"'2021 Data By Pay Band'!S146","v":2},null,3.3333333333333333E-2]
[null,"NR",{"$f":"'2021 Data By Pay Band'!S147","v":9},null,0.15]

{"sheet":"SO Graph Data","index":10,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":true,"merged":[[1,2,1,3],[1,4,1,5]]}
[]
[null,"Disability","Value",null,"Percentage",null,null,"Dividers",4]
["Band 1/2","H",null,{"$f":"'2021 Data By Pay Band'!H206","v":1606},null,{"$f":"D3/SUM($D$3:$D$6)","v":0.95880597014925373},null,null,"X","Y"]
[null,"LGB",null,{"$f":"'2021 Data By Pay Band'!H207","v":58},null,{"$f":"D4/SUM($D$3:$D$6)","v":3.4626865671641791E-2},null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!H208","v":2},null,{"$f":"D5/SUM($D$3:$D$6)","v":1.1940298507462687E-3},null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR ",null,{"$f":"'2021 Data By Pay Band'!H209","v":9},null,{"$f":"D6/SUM($D$3:$D$6)","v":5.3731343283582086E-3},null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Band 3","H",{"$f":"'2021 Data By Pay Band'!H206","v":1606},null,{"$f":"C7/SUM($C$7:$C$10)","v":0.98769987699876993},null,null,4,16.5,0]
[null,"LGB",{"$f":"'2021 Data By Pay Band'!I207","v":20},null,{"$f":"C8/SUM($C$7:$C$10)","v":1.2300123001230012E-2},null,null,5,20.5,0]
[null,"ND",{"$f":"'2021 Data By Pay Band'!I208","v":0},null,{"$f":"C9/SUM($C$7:$C$10)","v":0},null,null,6,24.5,0]
[null,"NR ",{"$f":"'2021 Data By Pay Band'!I209","v":0},null,{"$f":"C10/SUM($C$7:$C$10)","v":0},null,null,7,28.5,0]
["Band 4","H",null,{"$f":"'2021 Data By Pay Band'!I206","v":580},null,{"$f":"D11/SUM($D$11:$D$14)","v":0.97807757166947729},null,8,32.5,0]
[null,"LGB",null,{"$f":"'2021 Data By Pay Band'!J207","v":13},null,{"$f":"D12/SUM($D$11:$D$14)","v":2.1922428330522766E-2},null,9,36.5,0]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!J208","v":0},null,{"$f":"D13/SUM($D$11:$D$14)","v":0},null,10,40.5,0]
[null,"NR ",null,{"$f":"'2021 Data By Pay Band'!J209","v":0},null,{"$f":"D14/SUM($D$11:$D$14)","v":0},null,11,44.5,0]
["Band 5","H",{"$f":"'2021 Data By Pay Band'!J206","v":297},null,{"$f":"C15/SUM($C$15:$C$18)","v":0.87869822485207105},null,null,12,48.5,0]
[null,"LGB",{"$f":"'2021 Data By Pay Band'!K207","v":39},null,{"$f":"C16/SUM($C$15:$C$18)","v":0.11538461538461539}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!K208","v":0},null,{"$f":"C17/SUM($C$15:$C$18)","v":0}]
[null,"NR ",{"$f":"'2021 Data By Pay Band'!K209","v":2},null,{"$f":"C18/SUM($C$15:$C$18)","v":5.9171597633136093E-3}]
["Band 6","H",null,{"$f":"'2021 Data By Pay Band'!K206","v":1087},null,{"$f":"D19/SUM($D$19:$D$22)","v":0.98104693140794219}]
[null,"LGB",null,{"$f":"'2021 Data By Pay Band'!L207","v":21},null,{"$f":"D20/SUM($D$19:$D$22)","v":1.895306859205776E-2}]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!L208","v":0},null,{"$f":"D21/SUM($D$19:$D$22)","v":0}]
[null,"NR ",null,{"$f":"'2021 Data By Pay Band'!L209","v":0},null,{"$f":"D22/SUM($D$19:$D$22)","v":0}]
["Band 7","H",{"$f":"'2021 Data By Pay Band'!L206","v":817},null,{"$f":"C23/SUM($C$23:$C$26)","v":0.97261904761904761}]
[null,"LGB",{"$f":"'2021 Data By Pay Band'!M207","v":23},null,{"$f":"C24/SUM($C$23:$C$26)","v":2.7380952380952381E-2}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!M208","v":0},null,{"$f":"C25/SUM($C$23:$C$26)","v":0}]
[null,"NR ",{"$f":"'2021 Data By Pay Band'!M209","v":0},null,{"$f":"C26/SUM($C$23:$C$26)","v":0}]
["Band 8A/B","H",null,{"$f":"'2021 Data By Pay Band'!M206","v":432},null,{"$f":"D27/SUM($D$27:$D$30)","v":0.99082568807339455}]
[null,"LGB",null,{"$f":"'2021 Data By Pay Band'!N207","v":3},null,{"$f":"D28/SUM($D$27:$D$30)","v":6.8807339449541288E-3}]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!N208","v":0},null,{"$f":"D29/SUM($D$27:$D$30)","v":0}]
[null,"NR ",null,{"$f":"'2021 Data By Pay Band'!N209","v":1},null,{"$f":"D30/SUM($D$27:$D$30)","v":2.2935779816513763E-3}]
["Band 8C-9","H",{"$f":"'2021 Data By Pay Band'!N206","v":182},null,{"$f":"C31/SUM($C$31:$C$34)","v":0.98913043478260865}]
[null,"LGB",{"$f":"'2021 Data By Pay Band'!O207","v":2},null,{"$f":"C32/SUM($C$31:$C$34)","v":1.0869565217391304E-2}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!O208","v":0},null,{"$f":"C33/SUM($C$31:$C$34)","v":0}]
[null,"NR ",{"$f":"'2021 Data By Pay Band'!O209","v":0},null,{"$f":"C34/SUM($C$31:$C$34)","v":0}]
["Trainee Grade Doctor","H",null,{"$f":"'2021 Data By Pay Band'!O206","v":31},null,{"$f":"D35/SUM($D$35:$D$38)","v":0.63265306122448983}]
[null,"LGB",null,{"$f":"'2021 Data By Pay Band'!P207","v":17},null,{"$f":"D36/SUM($D$35:$D$38)","v":0.34693877551020408}]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!P208","v":0},null,{"$f":"D37/SUM($D$35:$D$38)","v":0}]
[null,"NR ",null,{"$f":"'2021 Data By Pay Band'!P209","v":1},null,{"$f":"D38/SUM($D$35:$D$38)","v":2.0408163265306121E-2}]
["Career Grade Doctor","H",{"$f":"'2021 Data By Pay Band'!P206","v":417},null,{"$f":"C39/SUM($C$39:$C$42)","v":0.99760765550239239}]
[null,"LGB",{"$f":"'2021 Data By Pay Band'!Q207","v":1},null,{"$f":"C40/SUM($C$39:$C$42)","v":2.3923444976076554E-3}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!Q208","v":0},null,{"$f":"C41/SUM($C$39:$C$42)","v":0}]
[null,"NR ",{"$f":"'2021 Data By Pay Band'!Q209","v":0},null,{"$f":"C42/SUM($C$39:$C$42)","v":0}]
["Consultant","H",null,{"$f":"'2021 Data By Pay Band'!Q206","v":19},null,{"$f":"D43/SUM($D$43:$D$46)","v":0.82608695652173914}]
[null,"LGB",null,{"$f":"'2021 Data By Pay Band'!R207","v":4},null,{"$f":"D44/SUM($D$27:$D$30)","v":9.1743119266055051E-3}]
[null,"ND",null,{"$f":"'2021 Data By Pay Band'!R208","v":0},null,{"$f":"D45/SUM($D$27:$D$30)","v":0}]
[null,"NR ",null,{"$f":"'2021 Data By Pay Band'!R209","v":0},null,{"$f":"D46/SUM($D$27:$D$30)","v":0}]
["Other","H",{"$f":"'2021 Data By Pay Band'!R206","v":215},null,{"$f":"C47/SUM($C$47:$C$50)","v":0.9817351598173516}]
[null,"LGB",{"$f":"'2021 Data By Pay Band'!S207","v":4},null,{"$f":"C48/SUM($C$47:$C$50)","v":1.8264840182648401E-2}]
[null,"ND",{"$f":"'2021 Data By Pay Band'!S208","v":0},null,{"$f":"C49/SUM($C$47:$C$50)","v":0}]
[null,"NR ",{"$f":"'2021 Data By Pay Band'!S209","v":0},null,{"$f":"C50/SUM($C$47:$C$50)","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":"'2021 Data by Employee Type'!K172","v":734},null,{"$f":"C3/SUM($C$3:$C$12)","v":0.22048663262240914},null,null,null,"X","Y"]
[null,"B",{"$f":"'2021 Data by Employee Type'!K173","v":21},null,{"$f":"C4/SUM($C$3:$C$12)","v":6.3082006608591165E-3},null,null,1,{"$f":"$I$2*H4+0.5","v":10.5},0]
[null,"C",{"$f":"'2021 Data by Employee Type'!K174","v":1503},null,0.45148693301291681,null,null,2,{"$f":"$I$2*H5+0.5","v":20.5},0]
[null,"H",{"$f":"'2021 Data by Employee Type'!K175","v":40},null,1.2015620306398318E-2,null,null,3,{"$f":"$I$2*H6+0.5","v":30.5},0]
[null,"I",{"$f":"'2021 Data by Employee Type'!K176","v":47},null,1.4118353860018024E-2]
[null,"J",{"$f":"'2021 Data by Employee Type'!K177","v":3},null,9.011715229798738E-4]
[null,"S",{"$f":"'2021 Data by Employee Type'!K178","v":6},null,1.8023430459597476E-3]
[null,"O",{"$f":"'2021 Data by Employee Type'!K179","v":256},null,7.6899969960949235E-2]
[null,"ND",{"$f":"'2021 Data by Employee Type'!K180","v":428},null,0.128567137278462]
[null,"NR",{"$f":"'2021 Data by Employee Type'!K181","v":291},null,8.7413637729047769E-2]
["Substantive - Part Time","A",null,{"$f":"'2021 Data by Employee Type'!L172","v":372},null,{"$f":"D13/SUM($D$13:$D$22)","v":0.15480649188514356}]
[null,"B",null,{"$f":"'2021 Data by Employee Type'!L173","v":10},null,4.1614648356221393E-3]
[null,"C",null,{"$f":"'2021 Data by Employee Type'!L174","v":1098},null,0.45692883895131087]
[null,"H",null,{"$f":"'2021 Data by Employee Type'!L175","v":9},null,3.7453183520599251E-3]
[null,"I",null,{"$f":"'2021 Data by Employee Type'!L176","v":8},null,3.3291718684977114E-3]
[null,"J",null,{"$f":"'2021 Data by Employee Type'!L177","v":3},null,1.2484394506866417E-3]
[null,"S",null,{"$f":"'2021 Data by Employee Type'!L178","v":2},null,8.3229296712442784E-4]
[null,"O",null,{"$f":"'2021 Data by Employee Type'!L179","v":201},null,8.364544319600499E-2]
[null,"ND",null,{"$f":"'2021 Data by Employee Type'!L180","v":390},null,0.16229712858926343]
[null,"NR",null,{"$f":"'2021 Data by Employee Type'!L181","v":310},null,0.1290054099042863]
["Bank","A",{"$f":"'2021 Data by Employee Type'!M172","v":356},null,{"$f":"C23/SUM($C$23:$C$32)","v":0.23162003903708522}]
[null,"B",{"$f":"'2021 Data by Employee Type'!M173","v":11},null,{"$f":"C24/SUM($C$23:$C$32)","v":7.1567989590110605E-3}]
[null,"C",{"$f":"'2021 Data by Employee Type'!M174","v":623},null,0.40533506831489913]
[null,"H",{"$f":"'2021 Data by Employee Type'!M175","v":12},null,7.8074170461938843E-3]
[null,"I",{"$f":"'2021 Data by Employee Type'!M176","v":21},null,1.3662979830839297E-2]
[null,"J",{"$f":"'2021 Data by Employee Type'!M177","v":2},null,1.3012361743656475E-3]
[null,"S",{"$f":"'2021 Data by Employee Type'!M178","v":2},null,1.3012361743656475E-3]
[null,"O",{"$f":"'2021 Data by Employee Type'!M179","v":157},null,0.10214703968770332]
[null,"ND",{"$f":"'2021 Data by Employee Type'!M180","v":261},null,0.16981132075471697]
[null,"NR",{"$f":"'2021 Data by Employee Type'!M181","v":92},null,5.9856864020819779E-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":"'2021 Data by Employee Type'!K141","v":1627},null,{"$f":"C3/SUM($C$3:$C$9)","v":0.48873535596275158},null,null,null,"X","Y"]
[null,"M",{"$f":"'2021 Data by Employee Type'!K142","v":1347},null,0.40462601381796337,null,null,1,{"$f":"$I$2*H4+0.5","v":7.5},0]
[null,"C",{"$f":"'2021 Data by Employee Type'!K143","v":45},null,1.3517572844698107E-2,null,null,2,{"$f":"$I$2*H5+0.5","v":14.5},0]
[null,"D",{"$f":"'2021 Data by Employee Type'!K144","v":164},null,4.9264043256233105E-2,null,null,3,{"$f":"$I$2*H6+0.5","v":21.5},0]
[null,"LS",{"$f":"'2021 Data by Employee Type'!K145","v":24},null,7.2093721838389904E-3]
[null,"W",{"$f":"'2021 Data by Employee Type'!K146","v":12},null,3.6046860919194952E-3]
[null,"NR",{"$f":"'2021 Data by Employee Type'!K147","v":110},null,3.3042955842595374E-2]
["Substantive - Part Time","S",null,{"$f":"'2021 Data by Employee Type'!L141","v":614},null,{"$f":"D10/SUM($D$10:$D$16)","v":0.25551394090719931}]
[null,"M",null,{"$f":"'2021 Data by Employee Type'!L142","v":1489},null,0.61964211402413649]
[null,"C",null,{"$f":"'2021 Data by Employee Type'!L143","v":29},null,1.2068248023304202E-2]
[null,"D",null,{"$f":"'2021 Data by Employee Type'!L144","v":147},null,6.117353308364544E-2]
[null,"LS",null,{"$f":"'2021 Data by Employee Type'!L145","v":20},null,8.3229296712442787E-3]
[null,"W",null,{"$f":"'2021 Data by Employee Type'!L146","v":25},null,1.0403662089055347E-2]
[null,"NR",null,{"$f":"'2021 Data by Employee Type'!L147","v":79},null,3.2875572201414897E-2]
["Bank","S",{"$f":"'2021 Data by Employee Type'!M141","v":781},null,{"$f":"C17/SUM($C$17:$C$23)","v":0.50813272608978532}]
[null,"M",{"$f":"'2021 Data by Employee Type'!M142","v":557},null,0.36239427456083279]
[null,"C",{"$f":"'2021 Data by Employee Type'!M143","v":20},null,1.3012361743656473E-2]
[null,"D",{"$f":"'2021 Data by Employee Type'!M144","v":62},null,4.0338321405335067E-2]
[null,"LS",{"$f":"'2021 Data by Employee Type'!M145","v":4},null,2.6024723487312949E-3]
[null,"W",{"$f":"'2021 Data by Employee Type'!M146","v":7},null,4.554326610279766E-3]
[null,"NR",{"$f":"'2021 Data by Employee Type'!M147","v":106},null,6.8965517241379309E-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":"'2021 Data by Employee Type'!K27","v":382},null,{"$f":"C3/SUM($C$3:$C$8)","v":0.11474917392610394},null,null,null,"X","Y"]
[null,"26-35",{"$f":"'2021 Data by Employee Type'!K28","v":1098},null,0.32982877741063382,null,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"36-45",{"$f":"'2021 Data by Employee Type'!K29","v":663},null,0.19915890657855212,null,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"46-55",{"$f":"'2021 Data by Employee Type'!K30","v":765},null,0.22979873835986783,null,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"56-65",{"$f":"'2021 Data by Employee Type'!K31","v":408},null,0.12255932712526284]
[null,">65",{"$f":"'2021 Data by Employee Type'!K32","v":13},null,3.9050765995794533E-3]
["Substantive - Part Time","16-25",null,{"$f":"'2021 Data by Employee Type'!L27","v":76},null,{"$f":"D9/SUM($D$9:$D$14)","v":3.162713275072826E-2}]
[null,"26-35",null,{"$f":"'2021 Data by Employee Type'!L28","v":488},null,0.20307948397836037]
[null,"36-45",null,{"$f":"'2021 Data by Employee Type'!L29","v":638},null,0.26550145651269247]
[null,"46-55",null,{"$f":"'2021 Data by Employee Type'!L30","v":597},null,0.24843945068664169]
[null,"56-65",null,{"$f":"'2021 Data by Employee Type'!L31","v":516},null,0.21473158551810237]
[null,">65",null,{"$f":"'2021 Data by Employee Type'!L32","v":88},null,3.6620890553474825E-2]
["Bank","16-25",{"$f":"'2021 Data by Employee Type'!M27","v":365},null,{"$f":"C15/SUM($C$15:$C$20)","v":0.23747560182173064}]
[null,"26-35",{"$f":"'2021 Data by Employee Type'!M28","v":433},null,0.28171763175016268]
[null,"36-45",{"$f":"'2021 Data by Employee Type'!M29","v":285},null,0.18542615484710476]
[null,"46-55",{"$f":"'2021 Data by Employee Type'!M30","v":206},null,0.13402732595966169]
[null,"56-65",{"$f":"'2021 Data by Employee Type'!M31","v":186},null,0.1210149642160052]
[null,">65",{"$f":"'2021 Data by Employee Type'!M32","v":62},null,4.0338321405335067E-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":"'2021 Data by Employee Type'!K57","v":109},null,{"$f":"C3/SUM($C$3:$C$6)","v":3.2742565334935414E-2},null,null,null,"X","Y"]
[null,"N",{"$f":"'2021 Data by Employee Type'!K58","v":2699},null,{"$f":"C4/SUM($C$3:$C$6)","v":0.81075398017422651},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"ND",{"$f":"'2021 Data by Employee Type'!K59","v":34},null,{"$f":"C5/SUM($C$3:$C$6)","v":1.021327726043857E-2},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'2021 Data by Employee Type'!K60","v":487},null,{"$f":"C6/SUM($C$3:$C$6)","v":0.14629017723039953},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Substantive - Part Time","Y",null,{"$f":"'2021 Data by Employee Type'!L57","v":76},null,{"$f":"D7/SUM($D$7:$D$10)","v":3.162713275072826E-2}]
[null,"N",null,{"$f":"'2021 Data by Employee Type'!L58","v":1811},null,{"$f":"D8/SUM($D$7:$D$10)","v":0.7536412817311694}]
[null,"ND",null,{"$f":"'2021 Data by Employee Type'!L59","v":47},null,{"$f":"D9/SUM($D$7:$D$10)","v":1.9558884727424054E-2}]
[null,"NR",null,{"$f":"'2021 Data by Employee Type'!L60","v":469},null,{"$f":"D10/SUM($D$7:$D$10)","v":0.19517270079067831}]
["Bank","Y",{"$f":"'2021 Data by Employee Type'!M57","v":48},null,{"$f":"C11/SUM($C$11:$C$14)","v":3.1229668184775537E-2}]
[null,"N",{"$f":"'2021 Data by Employee Type'!M58","v":1290},null,{"$f":"C12/SUM($C$11:$C$14)","v":0.83929733246584259}]
[null,"ND",{"$f":"'2021 Data by Employee Type'!M59","v":42},null,{"$f":"C13/SUM($C$11:$C$14)","v":2.7325959661678594E-2}]
[null,"NR",{"$f":"'2021 Data by Employee Type'!M60","v":157},null,{"$f":"C14/SUM($C$11:$C$14)","v":0.10214703968770332}]

{"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":"'2021 Data by Employee Type'!K86","v":2294},null,{"$f":"C3/SUM($C$3:$C$6)","v":0.68909582457194352},null,null,null,"X","Y"]
[null,"WO",{"$f":"'2021 Data by Employee Type'!K87","v":290},null,{"$f":"C4/SUM($C$3:$C$6)","v":8.7113247221387802E-2},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"EM(OWM)",{"$f":"'2021 Data by Employee Type'!K88","v":694},null,{"$f":"C5/SUM($C$3:$C$6)","v":0.20847101231601081},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'2021 Data by Employee Type'!K89","v":51},null,{"$f":"C6/SUM($C$3:$C$6)","v":1.5319915890657855E-2},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
["Substantive - Part Time","WB",null,{"$f":"'2021 Data by Employee Type'!L86","v":2004},null,{"$f":"D7/SUM($D$7:$D$10)","v":0.83395755305867669}]
[null,"WO",null,{"$f":"'2021 Data by Employee Type'!L87","v":173},null,{"$f":"D8/SUM($D$7:$D$10)","v":7.1993341656263005E-2}]
[null,"EM(OWM)",null,{"$f":"'2021 Data by Employee Type'!L88","v":193},null,{"$f":"D9/SUM($D$7:$D$10)","v":8.031627132750728E-2}]
[null,"NR",null,{"$f":"'2021 Data by Employee Type'!L89","v":33},null,{"$f":"D10/SUM($D$7:$D$10)","v":1.3732833957553059E-2}]
["Bank","WB",{"$f":"'2021 Data by Employee Type'!M86","v":1113},null,{"$f":"C11/SUM($C$11:$C$14)","v":0.72413793103448276}]
[null,"WO",{"$f":"'2021 Data by Employee Type'!M87","v":140},null,{"$f":"C12/SUM($C$11:$C$14)","v":9.1086532205595316E-2}]
[null,"EM(OWM)",{"$f":"'2021 Data by Employee Type'!M88","v":204},null,{"$f":"C13/SUM($C$11:$C$14)","v":0.13272608978529604}]
[null,"NR",{"$f":"'2021 Data by Employee Type'!M89","v":80},null,{"$f":"C14/SUM($C$11:$C$14)","v":5.2049446974625893E-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":"'2021 Data by Employee Type'!K206","v":2662},null,{"$f":"C3/SUM($C$3:$C$8)","v":0.79963953139080801},null,null,null,"X","Y"]
[null,"LGB",{"$f":"'2021 Data by Employee Type'!K207","v":118},null,{"$f":"C4/SUM($C$3:$C$8)","v":3.5446079903875036E-2},null,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"O",{"$f":"'2021 Data by Employee Type'!K208","v":0},null,0,null,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"U",{"$f":"'2021 Data by Employee Type'!K209","v":2},null,6.007810153199159E-4,null,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"ND",{"$f":"'2021 Data by Employee Type'!K210","v":243},null,7.2994893361369786E-2]
[null,"NR",{"$f":"'2021 Data by Employee Type'!K211","v":304},null,9.1318714328627218E-2]
["Substantive - Part Time","H",null,{"$f":"'2021 Data by Employee Type'!L206","v":1827},null,{"$f":"D9/SUM($D$9:$D$14)","v":0.76029962546816476}]
[null,"LGB",null,{"$f":"'2021 Data by Employee Type'!L207","v":37},null,{"$f":"D10/SUM($D$9:$D$14)","v":1.5397419891801914E-2}]
[null,"O",null,{"$f":"'2021 Data by Employee Type'!L208","v":0},null,0]
[null,"U",null,{"$f":"'2021 Data by Employee Type'!L209","v":3},null,1.2484394506866417E-3]
[null,"ND",null,{"$f":"'2021 Data by Employee Type'!L210","v":218},null,9.0719933416562634E-2]
[null,"NR",null,{"$f":"'2021 Data by Employee Type'!L211","v":318},null,0.13233458177278401]
["Bank","H",{"$f":"'2021 Data by Employee Type'!M206","v":1234},null,{"$f":"C15/SUM($C$15:$C$20)","v":0.80286271958360445}]
[null,"LGB",{"$f":"'2021 Data by Employee Type'!M207","v":50},null,{"$f":"C16/SUM($C$15:$C$20)","v":3.2530904359141181E-2}]
[null,"O",{"$f":"'2021 Data by Employee Type'!M208","v":2},null,1.3012361743656475E-3]
[null,"U",{"$f":"'2021 Data by Employee Type'!M209","v":8},null,5.2049446974625898E-3]
[null,"ND",{"$f":"'2021 Data by Employee Type'!M210","v":155},null,0.10084580351333768]
[null,"NR",{"$f":"'2021 Data by Employee Type'!M211","v":88},null,5.7254391672088484E-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":"'2021 Data by Employee Type'!K115","v":2223},null,{"$f":"C3/SUM($C$3:$C$4)","v":0.6677680985280865},null,null,null,"X","Y"]
[null,"M",{"$f":"'2021 Data by Employee Type'!K116","v":1106},null,{"$f":"C4/SUM($C$3:$C$4)","v":0.3322319014719135},null,null,1,{"$f":"$I$2*H4+0.5","v":2.5},0]
["Substantive - Part Time","F",null,{"$f":"'2021 Data by Employee Type'!L115","v":2154},null,{"$f":"D5/SUM($D$5:$D$6)","v":0.89637952559300871},null,2,{"$f":"$I$2*H5+0.5","v":4.5},0]
[null,"M",null,{"$f":"'2021 Data by Employee Type'!L116","v":249},null,{"$f":"D6/SUM($D$5:$D$6)","v":0.10362047440699126},null,3,{"$f":"$I$2*H6+0.5","v":6.5},0]
["Bank","F",{"$f":"'2021 Data by Employee Type'!M115","v":1109},null,{"$f":"C7/SUM($C$7:$C$8)","v":0.72153545868575142}]
[null,"M",{"$f":"'2021 Data by Employee Type'!M116","v":428},null,{"$f":"C8/SUM($C$7:$C$8)","v":0.27846454131424853}]

{"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.41573806575870131},null,{"$f":"C3/SUM($C$3:$C$9)","v":0.41573806575870131},null,null,null,"X","Y"]
[null,"M",{"$f":"'Year on Year Comparison'!L140","v":0.46677672307057366},null,0.46677672307057366,null,null,1,{"$f":"$I$2*H4+0.5","v":7.5},0]
[null,"C",{"$f":"'Year on Year Comparison'!L141","v":1.2931627459072774E-2},null,1.2931627459072774E-2,null,null,2,{"$f":"$I$2*H5+0.5","v":14.5},0]
[null,"D",{"$f":"'Year on Year Comparison'!L142","v":5.1313798321639841E-2},null,5.1313798321639841E-2,null,null,3,{"$f":"$I$2*H6+0.5","v":21.5},0]
[null,"LS",{"$f":"'Year on Year Comparison'!L143","v":6.6033842344201408E-3},null,6.6033842344201408E-3,null,null,4,{"$f":"$I$2*H7+0.5","v":28.5},0]
[null,"W",{"$f":"'Year on Year Comparison'!L144","v":6.0531022148851282E-3},null,6.0531022148851282E-3,null,null,5,{"$f":"$I$2*H8+0.5","v":35.5},0]
[null,"NR",{"$f":"'Year on Year Comparison'!L145","v":4.0583298940707113E-2},null,4.0583298940707113E-2]
[2017,"S",null,{"$f":"'Year on Year Comparison'!M139","v":0.39822733633960505},null,{"$f":"D10/SUM($D$10:$D$16)","v":0.39822733633960505}]
[null,"M",null,{"$f":"'Year on Year Comparison'!M140","v":0.48779350023324519},null,0.48779350023324519]
[null,"C",null,{"$f":"'Year on Year Comparison'!M141","v":1.1662260923651064E-2},null,1.1662260923651064E-2]
[null,"D",null,{"$f":"'Year on Year Comparison'!M142","v":5.2713419374902815E-2},null,5.2713419374902815E-2]
[null,"LS",null,{"$f":"'Year on Year Comparison'!M143","v":9.0188151142901567E-3},null,9.0188151142901567E-3]
[null,"W",null,{"$f":"'Year on Year Comparison'!M144","v":7.463846991136682E-3},null,7.463846991136682E-3]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M145","v":3.3120821023169024E-2},null,3.3120821023169024E-2]
[2016,"S",{"$f":"'Year on Year Comparison'!N139","v":0.38776441941865775},null,{"$f":"C17/SUM($C$17:$C$23)","v":0.38776441941865775}]
[null,"M",{"$f":"'Year on Year Comparison'!N140","v":0.49870643737635062},null,0.49870643737635062]
[null,"C",{"$f":"'Year on Year Comparison'!N141","v":1.1718155531882515E-2},null,1.1718155531882515E-2]
[null,"D",{"$f":"'Year on Year Comparison'!N142","v":5.2503424136356718E-2},null,5.2503424136356718E-2]
[null,"LS",{"$f":"'Year on Year Comparison'!N143","v":8.3701110942017952E-3},null,8.3701110942017952E-3]
[null,"W",{"$f":"'Year on Year Comparison'!N144","v":7.0004565515142288E-3},null,7.0004565515142288E-3]
[null,"NR",{"$f":"'Year on Year Comparison'!N145","v":3.3936995891036374E-2},null,3.3936995891036374E-2]
[2015,"S",null,{"$f":"'Year on Year Comparison'!O139","v":0.39387786974855538},null,{"$f":"D24/SUM($D$24:$D$30)","v":0.39387786974855538}]
[null,"M",null,{"$f":"'Year on Year Comparison'!O140","v":0.49742308292987664},null,0.49742308292987664]
[null,"C",null,{"$f":"'Year on Year Comparison'!O141","v":1.0932375449008278E-2},null,1.0932375449008278E-2]
[null,"D",null,{"$f":"'Year on Year Comparison'!O142","v":4.8727159144151176E-2},null,4.8727159144151176E-2]
[null,"LS",null,{"$f":"'Year on Year Comparison'!O143","v":9.2144307355926901E-3},null,9.2144307355926901E-3]
[null,"W",null,{"$f":"'Year on Year Comparison'!O144","v":6.559425269404966E-3},null,6.559425269404966E-3]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O145","v":3.3265656723410898E-2},null,3.3265656723410898E-2]
[2014,"S",{"$f":"'Year on Year Comparison'!P139","v":0.39346636626971354},null,{"$f":"C31/SUM($C$31:$C$37)","v":0.39346636626971354}]
[null,"M",{"$f":"'Year on Year Comparison'!P140","v":0.50128741551335698},null,0.50128741551335698]
[null,"C",{"$f":"'Year on Year Comparison'!P141","v":7.402639201802382E-3},null,7.402639201802382E-3]
[null,"D",{"$f":"'Year on Year Comparison'!P142","v":5.2301255230125514E-2},null,5.2301255230125514E-2]
[null,"LS",{"$f":"'Year on Year Comparison'!P143","v":1.0299324106855488E-2},null,1.0299324106855488E-2]
[null,"W",{"$f":"'Year on Year Comparison'!P144","v":6.115223688445446E-3},null,6.115223688445446E-3]
[null,"NR",{"$f":"'Year on Year Comparison'!P145","v":2.9127775989700674E-2},null,2.9127775989700674E-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":2021},"16-25",{"$f":"'Year on Year Comparison'!L27","v":0.11322052551932865},null,{"$f":"C3/SUM($C$3:$C$8)","v":0.11322052551932865},null,null,null,"X","Y"]
[null,"26-35",{"$f":"'Year on Year Comparison'!L28","v":0.27775484936029715},null,0.27775484936029715,null,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"36-45",{"$f":"'Year on Year Comparison'!L29","v":0.21818682074563214},null,0.21818682074563214,null,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"46-55",{"$f":"'Year on Year Comparison'!L30","v":0.2157105516577246},null,0.2157105516577246,null,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"56-65",{"$f":"'Year on Year Comparison'!L31","v":0.15270326042096574},null,0.15270326042096574,null,null,4,{"$f":"$I$2*H7+0.5","v":24.5},0]
[null,">65",{"$f":"'Year on Year Comparison'!L32","v":2.2423992296051725E-2},null,2.2423992296051725E-2,null,null,5,{"$f":"$I$2*H8+0.5","v":30.5},0]
[{"$f":"'Year on Year Comparison'!$M$26","v":2020},"16-25",null,{"$f":"'Year on Year Comparison'!M27","v":0.10589332918675168},null,{"$f":"D9/SUM($D$9:$D$14)","v":0.10589332918675169}]
[null,"26-35",null,{"$f":"'Year on Year Comparison'!M28","v":0.26092365106515314},null,0.26092365106515319]
[null,"36-45",null,{"$f":"'Year on Year Comparison'!M29","v":0.21551858186907169},null,0.21551858186907172]
[null,"46-55",null,{"$f":"'Year on Year Comparison'!M30","v":0.2358886642823822},null,0.23588866428238223]
[null,"56-65",null,{"$f":"'Year on Year Comparison'!M31","v":0.16296065930648421},null,0.16296065930648423]
[null,">65",null,{"$f":"'Year on Year Comparison'!M32","v":1.8815114290157052E-2},null,1.8815114290157055E-2]
[{"$f":"'Year on Year Comparison'!$N$26","v":2019},"16-25",{"$f":"'Year on Year Comparison'!N27","v":0.1022675391873383},null,{"$f":"C15/SUM($C$15:$C$20)","v":0.10226753918733827}]
[null,"26-35",{"$f":"'Year on Year Comparison'!N28","v":0.25962562775833209},null,0.25962562775833203]
[null,"36-45",{"$f":"'Year on Year Comparison'!N29","v":0.21488357936387156},null,0.21488357936387151]
[null,"46-55",{"$f":"'Year on Year Comparison'!N30","v":0.24105919951301172},null,0.24105919951301166]
[null,"56-65",{"$f":"'Year on Year Comparison'!N31","v":0.15842337543752855},null,0.15842337543752852]
[null,">65",{"$f":"'Year on Year Comparison'!N32","v":2.3740678739917819E-2},null,2.3740678739917812E-2]
[{"$f":"'Year on Year Comparison'!$O$26","v":2018},"16-25",null,{"$f":"'Year on Year Comparison'!O27","v":0.10823051694518195},null,{"$f":"D21/SUM($D$21:$D$26)","v":0.10823051694518195}]
[null,"26-35",null,{"$f":"'Year on Year Comparison'!O28","v":0.25113228174293301},null,0.25113228174293301]
[null,"36-45",null,{"$f":"'Year on Year Comparison'!O29","v":0.22036545369358113},null,0.22036545369358113]
[null,"46-55",null,{"$f":"'Year on Year Comparison'!O30","v":0.24269873496798375},null,0.24269873496798375]
[null,"56-65",null,{"$f":"'Year on Year Comparison'!O31","v":0.15367796345463064},null,0.15367796345463064]
[null,">65",null,{"$f":"'Year on Year Comparison'!O32","v":2.3895049195689522E-2},null,2.3895049195689522E-2]
[{"$f":"'Year on Year Comparison'!$P$26","v":2017},"16-25",{"$f":"'Year on Year Comparison'!P27","v":0.10685548760862568},null,{"$f":"C27/SUM($C$27:$C$32)","v":0.10685548760862568}]
[null,"26-35",{"$f":"'Year on Year Comparison'!P28","v":0.25185065980045057},null,0.25185065980045057]
[null,"36-45",{"$f":"'Year on Year Comparison'!P29","v":0.22095268747988414},null,0.22095268747988414]
[null,"46-55",{"$f":"'Year on Year Comparison'!P30","v":0.24396523978113938},null,0.24396523978113938]
[null,"56-65",{"$f":"'Year on Year Comparison'!P31","v":0.15159317669777922},null,0.15159317669777922]
[null,">65",{"$f":"'Year on Year Comparison'!P32","v":2.4782748632121016E-2},null,2.4782748632121016E-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":2021},"Y",{"$f":"'Year on Year Comparison'!L57","v":3.2053927637914433E-2},null,{"$f":"C3/SUM($C$3:$C$6)","v":3.2053927637914433E-2},null,null,null,"X","Y"]
[null,"N",{"$f":"'Year on Year Comparison'!L58","v":0.79790892832576699},null,{"$f":"C4/SUM($C$3:$C$6)","v":0.79790892832576699},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"ND",{"$f":"'Year on Year Comparison'!L59","v":1.6921172100701608E-2},null,{"$f":"C5/SUM($C$3:$C$6)","v":1.6921172100701608E-2},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'Year on Year Comparison'!L60","v":0.15311597193561699},null,{"$f":"C6/SUM($C$3:$C$6)","v":0.15311597193561699},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
[{"$f":"'Year on Year Comparison'!$M$56","v":2020},"Y",null,{"$f":"'Year on Year Comparison'!M57","v":3.3431814647799721E-2},null,{"$f":"D7/SUM($D$7:$D$10)","v":3.3431814647799721E-2},null,4,{"$f":"$I$2*H7+0.5","v":16.5},0]
[null,"N",null,{"$f":"'Year on Year Comparison'!M58","v":0.78137148188462136},null,{"$f":"D8/SUM($D$7:$D$10)","v":0.78137148188462136},null,5,{"$f":"$I$2*H8+0.5","v":20.5},0]
[null,"ND",null,{"$f":"'Year on Year Comparison'!M59","v":1.5549681231534754E-2},null,{"$f":"D9/SUM($D$7:$D$10)","v":1.5549681231534754E-2}]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M60","v":0.16964702223604416},null,{"$f":"D10/SUM($D$7:$D$10)","v":0.16964702223604416}]
[{"$f":"'Year on Year Comparison'!$N$56","v":2019},"Y",{"$f":"'Year on Year Comparison'!N57","v":3.1958605996043221E-2},null,{"$f":"C11/SUM($C$11:$C$14)","v":3.1958605996043228E-2}]
[null,"N",{"$f":"'Year on Year Comparison'!N58","v":0.76624562471465529},null,{"$f":"C12/SUM($C$11:$C$14)","v":0.7662456247146554}]
[null,"ND",{"$f":"'Year on Year Comparison'!N59","v":1.4000913103028458E-2},null,{"$f":"C13/SUM($C$11:$C$14)","v":1.4000913103028459E-2}]
[null,"NR",{"$f":"'Year on Year Comparison'!N60","v":0.18779485618627301},null,{"$f":"C14/SUM($C$11:$C$14)","v":0.18779485618627303}]
[{"$f":"'Year on Year Comparison'!$O$56","v":2018},"Y",null,{"$f":"'Year on Year Comparison'!O57","v":3.2953303139153518E-2},null,{"$f":"D15/SUM($D$15:$D$18)","v":3.2953303139153518E-2}]
[null,"N",null,{"$f":"'Year on Year Comparison'!O58","v":0.73918475714508824},null,{"$f":"D16/SUM($D$15:$D$18)","v":0.73918475714508824}]
[null,"ND",null,{"$f":"'Year on Year Comparison'!O59","v":1.1557082617523036E-2},null,{"$f":"D17/SUM($D$15:$D$18)","v":1.1557082617523036E-2}]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O60","v":0.21630485709823521},null,{"$f":"D18/SUM($D$15:$D$18)","v":0.21630485709823521}]
[{"$f":"'Year on Year Comparison'!$P$56","v":2017},"Y",{"$f":"'Year on Year Comparison'!P57","v":3.3311876408110716E-2},null,{"$f":"C19/SUM($C$19:$C$22)","v":3.3311876408110716E-2}]
[null,"N",{"$f":"'Year on Year Comparison'!P58","v":0.70308979723205667},null,{"$f":"C20/SUM($C$19:$C$22)","v":0.70308979723205667}]
[null,"ND",{"$f":"'Year on Year Comparison'!P59","v":8.6900547151593181E-3},null,{"$f":"C21/SUM($C$19:$C$22)","v":8.6900547151593181E-3}]
[null,"NR",{"$f":"'Year on Year Comparison'!P60","v":0.25490827164467333},null,{"$f":"C22/SUM($C$19:$C$22)","v":0.25490827164467333}]

{"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":2021},"WB",{"$f":"'Year on Year Comparison'!L85","v":0.74439400192598704},null,{"$f":"C3/SUM($C$3:$C$6)","v":0.74439400192598704},null,null,null,"X","Y"]
[null,"WO",{"$f":"'Year on Year Comparison'!L86","v":8.2955014444903011E-2},null,{"$f":"C4/SUM($C$3:$C$6)","v":8.2955014444903011E-2},null,null,1,{"$f":"$I$2*H4+0.5","v":4.5},0]
[null,"EM(OWM)",{"$f":"'Year on Year Comparison'!L87","v":0.15008942082817445},null,{"$f":"C5/SUM($C$3:$C$6)","v":0.15008942082817445},null,null,2,{"$f":"$I$2*H5+0.5","v":8.5},0]
[null,"NR",{"$f":"'Year on Year Comparison'!L88","v":2.2561562800935478E-2},null,{"$f":"C6/SUM($C$3:$C$6)","v":2.2561562800935478E-2},null,null,3,{"$f":"$I$2*H6+0.5","v":12.5},0]
[{"$f":"'Year on Year Comparison'!$M$84","v":2020},"WB",null,{"$f":"'Year on Year Comparison'!M85","v":0.76488881977919454},null,{"$f":"D7/SUM($D$7:$D$10)","v":0.76488881977919465},null,4,{"$f":"$I$2*H7+0.5","v":16.5},0]
[null,"WO",null,{"$f":"'Year on Year Comparison'!M86","v":9.2365106515316431E-2},null,{"$f":"D8/SUM($D$7:$D$10)","v":9.2365106515316445E-2},null,5,{"$f":"$I$2*H8+0.5","v":20.5},0]
[null,"EM(OWM)",null,{"$f":"'Year on Year Comparison'!M87","v":0.12890685740942312},null,{"$f":"D9/SUM($D$7:$D$10)","v":0.12890685740942315}]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M88","v":1.383921629606593E-2},null,{"$f":"D10/SUM($D$7:$D$10)","v":1.3839216296065932E-2}]
[{"$f":"'Year on Year Comparison'!$N$84","v":2019},"WB",{"$f":"'Year on Year Comparison'!N85","v":0.76578907320042611},null,{"$f":"C11/SUM($C$11:$C$14)","v":0.76578907320042611}]
[null,"WO",{"$f":"'Year on Year Comparison'!N86","v":9.6636737178511636E-2},null,{"$f":"C12/SUM($C$11:$C$14)","v":9.6636737178511636E-2}]
[null,"EM(OWM)",{"$f":"'Year on Year Comparison'!N87","v":0.12524729873687415},null,{"$f":"C13/SUM($C$11:$C$14)","v":0.12524729873687415}]
[null,"NR",{"$f":"'Year on Year Comparison'!N88","v":1.23268908841881E-2},null,{"$f":"C14/SUM($C$11:$C$14)","v":1.23268908841881E-2}]
[{"$f":"'Year on Year Comparison'!$O$84","v":2018},"WB",null,{"$f":"'Year on Year Comparison'!O85","v":0.77682336404810248},null,{"$f":"D15/SUM($D$15:$D$18)","v":0.77682336404810248}]
[null,"WO",null,{"$f":"'Year on Year Comparison'!O86","v":0.10198344526003436},null,{"$f":"D16/SUM($D$15:$D$18)","v":0.10198344526003436}]
[null,"EM(OWM)",null,{"$f":"'Year on Year Comparison'!O87","v":0.11416523504607215},null,{"$f":"D17/SUM($D$15:$D$18)","v":0.11416523504607215}]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O88","v":7.027955645791035E-3},null,{"$f":"D18/SUM($D$15:$D$18)","v":7.027955645791035E-3}]
[{"$f":"'Year on Year Comparison'!$P$84","v":2017},"WB",{"$f":"'Year on Year Comparison'!P85","v":0.77792082394592854},null,{"$f":"C19/SUM($C$19:$C$22)","v":0.77792082394592854}]
[null,"WO",{"$f":"'Year on Year Comparison'!P86","v":0.10959124557450917},null,{"$f":"C20/SUM($C$19:$C$22)","v":0.10959124557450917}]
[null,"EM(OWM)",{"$f":"'Year on Year Comparison'!P87","v":0.10621177985194721},null,{"$f":"C21/SUM($C$19:$C$22)","v":0.10621177985194721}]
[null,"NR",{"$f":"'Year on Year Comparison'!P88","v":6.2761506276150627E-3},null,{"$f":"C22/SUM($C$19:$C$22)","v":6.2761506276150627E-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":2021},"F",{"$f":"'Year on Year Comparison'!L113","v":0.75471178979226849},null,{"$f":"C3/SUM($C$3:$C$4)","v":0.75471178979226849},null,null,null,"X","Y"]
[null,"M",{"$f":"'Year on Year Comparison'!L114","v":0.24528821020773145},null,{"$f":"C4/SUM($C$3:$C$4)","v":0.24528821020773145},null,null,1,{"$f":"$I$2*H4+0.5","v":2.5},0]
[{"$f":"'Year on Year Comparison'!$M$112","v":2020},"F",null,{"$f":"'Year on Year Comparison'!M113","v":0.76240087078214902},null,{"$f":"D5/SUM($D$5:$D$6)","v":0.76240087078214902},null,2,{"$f":"$I$2*H5+0.5","v":4.5},0]
[null,"M",null,{"$f":"'Year on Year Comparison'!M114","v":0.23759912921785104},null,{"$f":"D6/SUM($D$5:$D$6)","v":0.23759912921785104},null,3,{"$f":"$I$2*H6+0.5","v":6.5},0]
[{"$f":"'Year on Year Comparison'!$N$112","v":2019},"F",{"$f":"'Year on Year Comparison'!N113","v":0.77035458834271797},null,{"$f":"C7/SUM($C$7:$C$8)","v":0.77035458834271797},null,null,4,{"$f":"$I$2*H7+0.5","v":8.5},0]
[null,"M",{"$f":"'Year on Year Comparison'!N114","v":0.229645411657282},null,{"$f":"C8/SUM($C$7:$C$8)","v":0.229645411657282},null,null,5,{"$f":"$I$2*H8+0.5","v":10.5},0]
[{"$f":"'Year on Year Comparison'!$O$112","v":2018},"F",null,{"$f":"'Year on Year Comparison'!O113","v":0.77822895517726065},null,{"$f":"D9/SUM($D$9:$D$10)","v":0.77822895517726065}]
[null,"M",null,{"$f":"'Year on Year Comparison'!O114","v":0.22177104482273935},null,{"$f":"D10/SUM($D$9:$D$10)","v":0.22177104482273935}]
[{"$f":"'Year on Year Comparison'!$P$112","v":2017},"F",{"$f":"'Year on Year Comparison'!P113","v":0.77261023495333114},null,{"$f":"C11/SUM($C$11:$C$12)","v":0.77261023495333114}]
[null,"M",{"$f":"'Year on Year Comparison'!P114","v":0.2273897650466688},null,{"$f":"C12/SUM($C$11:$C$12)","v":0.2273897650466688}]

{"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":2021},"H",{"$f":"'Year on Year Comparison'!L204","v":0.78731599944971797},null,{"$f":"C3/SUM($C$3:$C$8)","v":0.78731599944971797},null,null,null,"X","Y"]
[null,"LGB",{"$f":"'Year on Year Comparison'!L205","v":2.8201953501169351E-2},null,{"$f":"C4/SUM($C$3:$C$8)","v":2.8201953501169351E-2},null,null,1,{"$f":"$I$2*H4+0.5","v":6.5},0]
[null,"O",{"$f":"'Year on Year Comparison'!L206","v":2.7514100976750583E-4},null,2.7514100976750583E-4,null,null,2,{"$f":"$I$2*H5+0.5","v":12.5},0]
[null,"U",{"$f":"'Year on Year Comparison'!L207","v":1.7884165634887881E-3},null,1.7884165634887881E-3,null,null,3,{"$f":"$I$2*H6+0.5","v":18.5},0]
[null,"ND",{"$f":"'Year on Year Comparison'!L208","v":8.4743431008391795E-2},null,8.4743431008391795E-2,null,null,4,{"$f":"$I$2*H7+0.5","v":24.5},0]
[null,"NR",{"$f":"'Year on Year Comparison'!L209","v":9.7675058467464576E-2},null,9.7675058467464576E-2,null,null,5,{"$f":"$I$2*H8+0.5","v":30.5},0]
[{"$f":"'Year on Year Comparison'!$M$138","v":2020},"H",null,{"$f":"'Year on Year Comparison'!M204","v":0.78168247550925207},null,{"$f":"D9/SUM($D$9:$D$14)","v":0.78168247550925207}]
[null,"LGB",null,{"$f":"'Year on Year Comparison'!M205","v":2.2547037785725393E-2},null,{"$f":"D10/SUM($D$9:$D$14)","v":2.2547037785725393E-2}]
[null,"O",null,{"$f":"'Year on Year Comparison'!M206","v":1.5549681231534753E-4},null,1.5549681231534753E-4]
[null,"U",null,{"$f":"'Year on Year Comparison'!M207","v":1.2439744985227803E-3},null,1.2439744985227803E-3]
[null,"ND",null,{"$f":"'Year on Year Comparison'!M208","v":8.2413310527134187E-2},null,8.2413310527134187E-2]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M209","v":0.11195770486705023},null,0.11195770486705023]
[{"$f":"'Year on Year Comparison'!$N$138","v":2019},"H",{"$f":"'Year on Year Comparison'!N204","v":0.76365849946735653},null,{"$f":"C15/SUM($C$15:$C$20)","v":0.76365849946735664}]
[null,"LGB",{"$f":"'Year on Year Comparison'!N205","v":1.841424440724395E-2},null,{"$f":"C16/SUM($C$15:$C$20)","v":1.8414244407243954E-2}]
[null,"O",{"$f":"'Year on Year Comparison'!N206","v":1.5218383807639628E-4},null,1.521838380763963E-4]
[null,"U",{"$f":"'Year on Year Comparison'!N207","v":9.1310302845837776E-4},null,9.1310302845837787E-4]
[null,"ND",{"$f":"'Year on Year Comparison'!N208","v":8.8875361436615438E-2},null,8.8875361436615452E-2]
[null,"NR",{"$f":"'Year on Year Comparison'!N209","v":0.12798660782224927},null,0.1279866078222493]
[{"$f":"'Year on Year Comparison'!$O$138","v":2018},"H",null,{"$f":"'Year on Year Comparison'!O204","v":0.74215211619553334},null,{"$f":"D21/SUM($D$21:$D$26)","v":0.74215211619553334}]
[null,"LGB",null,{"$f":"'Year on Year Comparison'!O205","v":1.7647977510541934E-2},null,{"$f":"D22/SUM($D$21:$D$26)","v":1.7647977510541934E-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.1363423395283458E-2},null,9.1363423395283458E-2]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O209","v":0.14883648289864126},null,0.14883648289864126]
[{"$f":"'Year on Year Comparison'!$P$138","v":2017},"H",{"$f":"'Year on Year Comparison'!P204","v":0.59912812736921905},null,{"$f":"C27/SUM($C$27:$C$32)","v":0.59912812736921917}]
[null,"LGB",{"$f":"'Year on Year Comparison'!P205","v":1.1751326762699014E-2},null,{"$f":"C28/SUM($C$27:$C$32)","v":1.1751326762699016E-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.9507202426080368E-2},null,9.9507202426080382E-2]
[null,"NR",{"$f":"'Year on Year Comparison'!P209","v":0.28961334344200151},null,0.28961334344200157]

{"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":2021},"A",{"$f":"'Year on Year Comparison'!L170","v":0.20112807814004677},null,{"$f":"C3/SUM($C$3:$C$12)","v":0.20112807814004677},null,null,null,"X","Y"]
[null,"B",{"$f":"'Year on Year Comparison'!L171","v":5.7779612051176224E-3},null,{"$f":"C4/SUM($C$3:$C$12)","v":5.7779612051176224E-3},null,null,1,{"$f":"$I$2*H4+0.5","v":10.5},0]
[null,"C",{"$f":"'Year on Year Comparison'!L172","v":0.44352730774521942},null,0.44352730774521942,null,null,2,{"$f":"$I$2*H5+0.5","v":20.5},0]
[null,"H",{"$f":"'Year on Year Comparison'!L173","v":8.3918007979089278E-3},null,8.3918007979089278E-3,null,null,3,{"$f":"$I$2*H6+0.5","v":30.5},0]
[null,"I",{"$f":"'Year on Year Comparison'!L174","v":1.0455358371165221E-2},null,1.0455358371165221E-2,null,null,4,{"$f":"$I$2*H7+0.5","v":40.5},0]
[null,"J",{"$f":"'Year on Year Comparison'!L175","v":1.1005640390700233E-3},null,1.1005640390700233E-3,null,null,5,{"$f":"$I$2*H8+0.5","v":50.5},0]
[null,"S",{"$f":"'Year on Year Comparison'!L176","v":1.3757050488375291E-3},null,1.3757050488375291E-3]
[null,"O",{"$f":"'Year on Year Comparison'!L177","v":8.4468289998624296E-2},null,8.4468289998624296E-2]
[null,"ND",{"$f":"'Year on Year Comparison'!L178","v":0.1484385747695694},null,0.1484385747695694]
[null,"NR",{"$f":"'Year on Year Comparison'!L179","v":9.533635988444078E-2},null,9.533635988444078E-2]
[{"$f":"'Year on Year Comparison'!$M$169","v":2020},"A",null,{"$f":"'Year on Year Comparison'!M170","v":0},null,{"$f":"D13/SUM($D$13:$D$22)","v":{"$error":"#DIV/0!"}}]
[null,"B",null,{"$f":"'Year on Year Comparison'!M171","v":0},null,{"$error":"#DIV/0!"}]
[null,"C",null,{"$f":"'Year on Year Comparison'!M172","v":0},null,{"$error":"#DIV/0!"}]
[null,"H",null,{"$f":"'Year on Year Comparison'!M173","v":0},null,{"$error":"#DIV/0!"}]
[null,"I",null,{"$f":"'Year on Year Comparison'!M174","v":0},null,{"$error":"#DIV/0!"}]
[null,"J",null,{"$f":"'Year on Year Comparison'!M175","v":0},null,{"$error":"#DIV/0!"}]
[null,"S",null,{"$f":"'Year on Year Comparison'!M176","v":0},null,{"$error":"#DIV/0!"}]
[null,"O",null,{"$f":"'Year on Year Comparison'!M177","v":0},null,{"$error":"#DIV/0!"}]
[null,"ND",null,{"$f":"'Year on Year Comparison'!M178","v":0},null,{"$error":"#DIV/0!"}]
[null,"NR",null,{"$f":"'Year on Year Comparison'!M179","v":0},null,{"$error":"#DIV/0!"}]
[{"$f":"'Year on Year Comparison'!$N$169","v":2019},"A",{"$f":"'Year on Year Comparison'!N170","v":0.17105463399786944},null,{"$f":"C23/SUM($C$23:$C$32)","v":0.17105463399786944}]
[null,"B",{"$f":"'Year on Year Comparison'!N171","v":4.8698828184446808E-3},null,{"$f":"C24/SUM($C$23:$C$32)","v":4.8698828184446808E-3}]
[null,"C",{"$f":"'Year on Year Comparison'!N172","v":0.4462030132399939},null,0.4462030132399939]
[null,"H",{"$f":"'Year on Year Comparison'!N173","v":7.4570080657434179E-3},null,7.4570080657434179E-3]
[null,"I",{"$f":"'Year on Year Comparison'!N174","v":8.2179272561254003E-3},null,8.2179272561254003E-3]
[null,"J",{"$f":"'Year on Year Comparison'!N175","v":9.1310302845837776E-4},null,9.1310302845837776E-4]
[null,"S",{"$f":"'Year on Year Comparison'!N176","v":1.3696545426875666E-3},null,1.3696545426875666E-3]
[null,"O",{"$f":"'Year on Year Comparison'!N177","v":8.3396743265865159E-2},null,8.3396743265865159E-2]
[null,"ND",{"$f":"'Year on Year Comparison'!N178","v":0.15233602191447268},null,0.15233602191447268]
[null,"NR",{"$f":"'Year on Year Comparison'!N179","v":0.12418201187033936},null,0.12418201187033936]
[{"$f":"'Year on Year Comparison'!$O$169","v":2018},"A",null,{"$f":"'Year on Year Comparison'!O170","v":0.16414180852725285},null,{"$f":"D33/SUM($D$33:$D$42)","v":0.16414180852725285}]
[null,"B",null,{"$f":"'Year on Year Comparison'!O171","v":4.84148055598938E-3},null,4.84148055598938E-3]
[null,"C",null,{"$f":"'Year on Year Comparison'!O172","v":0.43979384663439014},null,0.43979384663439014]
[null,"H",null,{"$f":"'Year on Year Comparison'!O173","v":7.3403092300484149E-3},null,7.3403092300484149E-3]
[null,"I",null,{"$f":"'Year on Year Comparison'!O174","v":7.652662814305794E-3},null,7.652662814305794E-3]
[null,"J",null,{"$f":"'Year on Year Comparison'!O175","v":7.8088396064344837E-4},null,7.8088396064344837E-4]
[null,"S",null,{"$f":"'Year on Year Comparison'!O176","v":1.405591129158207E-3},null,1.405591129158207E-3]
[null,"O",null,{"$f":"'Year on Year Comparison'!O177","v":7.7932219272216149E-2},null,7.7932219272216149E-2]
[null,"ND",null,{"$f":"'Year on Year Comparison'!O178","v":0.1511791347805716},null,0.1511791347805716]
[null,"NR",null,{"$f":"'Year on Year Comparison'!O179","v":0.14493206309542403},null,0.14493206309542403]
[{"$f":"'Year on Year Comparison'!$P$169","v":2017},"A",{"$f":"'Year on Year Comparison'!P170","v":0.14837463791438688},null,{"$f":"C43/SUM($C$43:$C$52)","v":0.14837463791438688}]
[null,"B",{"$f":"'Year on Year Comparison'!P171","v":4.0231734792404248E-3},null,{"$f":"C44/SUM($C$43:$C$52)","v":4.0231734792404248E-3}]
[null,"C",{"$f":"'Year on Year Comparison'!P172","v":0.43418088187962667},null,0.43418088187962667]
[null,"H",{"$f":"'Year on Year Comparison'!P173","v":6.2761506276150627E-3},null,6.2761506276150627E-3]
[null,"I",{"$f":"'Year on Year Comparison'!P174","v":6.2761506276150627E-3},null,6.2761506276150627E-3]
[null,"J",{"$f":"'Year on Year Comparison'!P175","v":6.4370775667846802E-4},null,6.4370775667846802E-4]
[null,"S",{"$f":"'Year on Year Comparison'!P176","v":1.287415513356936E-3},null,1.287415513356936E-3]
[null,"O",{"$f":"'Year on Year Comparison'!P177","v":7.627936916639845E-2},null,7.627936916639845E-2]
[null,"ND",{"$f":"'Year on Year Comparison'!P178","v":0.17090440939813326},null,0.17090440939813326]
[null,"NR",{"$f":"'Year on Year Comparison'!P179","v":0.15175410363694883},null,0.15175410363694883]

{"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]