{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Select an authority","CP conferences","CP registrations","CP on Register","CP de-registrations","DATA CP CON","DATA CP REG","DATA CP ON REG","DATA CP DEREG","REF EA Name","REF CAS2","REF CAs"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Select an authority","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[7]
["Selecting an Authority and its Standard Comparator Authorities"]
["PLEASE REMEMBER TO 'ENABLE MACROS' - ",null,null,null,"Please select a Local Authority:"]
["THEY MAY HAVE BEEN DISABLED."]
["Last updated: 23/05/2023"]
["Child Protection publications can be found at:"]
["Children's Social Work Statistics"]
["To help comparisons between local authorities, we have used the comparators as calculated by HMIE in 2003.  "]
["These were determined by comparing a number of statistical measures between education authorities, such as unemployment rates, looked after children rates, % owner-occupied properties etc.  In order to determine the weight that can be given to comparisons between the local authority and its group, a star rating was introduced which indicates the ‘closeness’ of a particular authority to each member; five stars indicating extremely close and one star indicating not close:"]
["*****","Extremely Close"]
[" ****","Very Close"]
["  ***","Close"]
["   **","Somewhat Close"]
["    *","Not close"]
[]
[{"$f":"OFFSET('REF EA Name'!B35,'Select an authority'!A1,0)","v":0}]
[]
["Comparators","Rating"]
[{"$f":"OFFSET('REF CAS2'!$C$1,'Select an authority'!$A$1,0)","v":"Angus"},{"$f":"OFFSET('REF CAS2'!$D$1,'Select an authority'!$A$1,0)","v":"*****"}]
[{"$f":"OFFSET('REF CAS2'!$E$1,'Select an authority'!$A$1,0)","v":"Highland"},{"$f":"OFFSET('REF CAS2'!$F$1,'Select an authority'!$A$1,0)","v":"****"}]
[{"$f":"OFFSET('REF CAS2'!$G$1,'Select an authority'!$A$1,0)","v":"Argyll and Bute"},{"$f":"OFFSET('REF CAS2'!$H$1,'Select an authority'!$A$1,0)","v":"****"}]
[{"$f":"OFFSET('REF CAS2'!$I$1,'Select an authority'!$A$1,0)","v":"Scottish Borders"},{"$f":"OFFSET('REF CAS2'!$J$1,'Select an authority'!$A$1,0)","v":"****"}]
[{"$f":"OFFSET('REF CAS2'!$K$1,'Select an authority'!$A$1,0)","v":"Moray"},{"$f":"OFFSET('REF CAS2'!$L$1,'Select an authority'!$A$1,0)","v":"****"}]
["Note: Caution should be exercised when making comparisons with comparator authority averages if there are a number of authorities that are not extremely or very close."]

{"sheet":"CP conferences","index":1,"n_rows":47,"n_cols":29,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'DATA CP CON'!A1","v":"Child Protection: Case conferences: 31 July 2016-2022"}]
[null,"select comparators:"]
[{"$f":"M3","v":3},{"$f":"J3","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":3}]
[{"$f":"M4","v":16},33,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":16}]
[{"$f":"M5","v":4},33,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":4}]
[10,33,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":26}]
[{"$f":"M7","v":19},33,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":19}]
[{"$f":"M8","v":0}]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(Z21=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Y21=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The number of referrals resulted in a case conference in \"&A21&\" in \"&Z19&\" was \"&ROUND(Z21,0)&\" (\"&Y44&ROUND((SQRT((Y21*100)^2)),1)&\"% from \"&ROUND(V21,0)&\" in \"&V19&\")\"))","v":"*  The number of referrals resulted in a case conference in Dumfries & Galloway in 2022 was 90 (a decrease of 3.2% from 93 in 2021)"}]
[{"$f":"IF(Y30=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&Y46&ROUND(SQRT((Y30*100)^2),1)&\"%, while the Scotland figures show \"&Y47&ROUND(SQRT((100*Y32)^2),1)&\"%\")","v":"*  The comparator authorities show a decrease of 2.8%, while the Scotland figures show a decrease of 8.8%"}]
[{"$f":"IF(AB21=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(AB30=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The rate (per 1,000 pop 0-15) is \"&ROUND(AB21,1)&\".  This is \"&AC40&\" the comparator average rate of \"&ROUND(AB30,1)&\", and \"&AC41&\" the Scotland average rate of \"&ROUND(AB32,1)))","v":"*  The rate (per 1,000 pop 0-15) is 3.9.  This is similar to the comparator average rate of 4, and less than the Scotland average rate of 4.5"}]
[]
[null,{"$f":"'DATA CP CON'!B3","v":2016},{"$f":"'DATA CP CON'!C3","v":2017},2016,2016,{"$f":"'DATA CP CON'!C3","v":2017},null,2017,2017,{"$f":"'DATA CP CON'!D3","v":2018},null,2018,2018,2019,null,2019,2019,2020,null,2020,2020,2021,null,2021,2021,2022,null,2022,2022]
[null,"Number","population 0-17 (2001)","Rate","% change","Number","population 0-17 (2001)","Rate","% change","Number","population 0-17 (2001)","Rate","% change","Number","population 0-17 (2001)","Rate","% change","Number","population 0-17 (2001)","Rate","% change","Number","population 0-17 (2001)","Rate","% change","Number","population 0-17 (2001)","Rate","Quartile"]
[{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Dumfries & Galloway"},{"$f":"OFFSET('DATA CP CON'!$B$3,'Select an authority'!$A$1,0)","v":149},null,{"$f":"IF(B21=\"*\",\"*\",OFFSET('DATA CP CON'!$S$3,'Select an authority'!$A$1,0))","v":6.3098162107224525},{"$f":"IF(B21=0,\"\",IF(B21=\"*\",\"\",IF(F21=\"*\",\"\",F21/B21-1)))","v":0.52348993288590595},{"$f":"OFFSET('DATA CP CON'!$C$3,'Select an authority'!$A$1,0)","v":227},null,{"$f":"IF(F21=\"*\",\"\",OFFSET('DATA CP CON'!$T$3,'Select an authority'!$A$1,0))","v":9.6649210201388005},{"$f":"IF(F21=0,\"\",IF(F21=\"*\",\"\",IF(J21=\"*\",\"\",J21/F21-1)))","v":0.25110132158590304},{"$f":"OFFSET('DATA CP CON'!$D$3,'Select an authority'!$A$1,0)","v":284},null,{"$f":"IF(J21=\"*\",\"\",OFFSET('DATA CP CON'!$U$3,'Select an authority'!$A$1,0))","v":12.12431693989071},{"$f":"IF(J21=0,\"\",IF(J21=\"*\",\"\",IF(N21=\"*\",\"\",N21/J21-1)))","v":-0.2640845070422535},{"$f":"OFFSET('DATA CP CON'!$E$3,'Select an authority'!$A$1,0)","v":209},null,{"$f":"IF(N21=\"*\",\"\",OFFSET('DATA CP CON'!$V$3,'Select an authority'!$A$1,0))","v":8.9919545669663989},{"$f":"IF(N21=0,\"\",IF(N21=\"*\",\"\",IF(R21=\"*\",\"\",R21/N21-1)))","v":-0.66985645933014348},{"$f":"OFFSET('DATA CP CON'!$F$3,'Select an authority'!$A$1,0)","v":69},null,{"$f":"IF(R21=\"*\",\"\",OFFSET('DATA CP CON'!$W$3,'Select an authority'!$A$1,0))","v":2.9934924078091107},{"$f":"IF(R21=0,\"\",IF(R21=\"*\",\"\",IF(V21=\"*\",\"\",V21/R21-1)))","v":0.34782608695652173},{"$f":"OFFSET('DATA CP CON'!$G$3,'Select an authority'!$A$1,0)","v":93},null,{"$f":"IF(V21=\"*\",\"\",OFFSET('DATA CP CON'!$X$3,'Select an authority'!$A$1,0))","v":4.0643300410803249},{"$f":"IF(V21=0,\"\",IF(V21=\"*\",\"\",IF(Z21=\"*\",\"\",Z21/V21-1)))","v":-3.2258064516129004E-2},{"$f":"OFFSET('DATA CP CON'!$H$3,'Select an authority'!$A$1,0)","v":90},null,{"$f":"IF(Z21=\"*\",\"\",OFFSET('DATA CP CON'!$Y$3,'Select an authority'!$A$1,0))","v":3.9332226204003145},{"$f":"IF(RANK(AB21,'DATA CP CON'!$Y$4:$Y$35)<9,1,IF(RANK(AB21,'DATA CP CON'!$Y$4:$Y$35)<17,2,IF(RANK(AB21,'DATA CP CON'!$Y$4:$Y$35)<25,3,4)))","v":3}]
[]
["Comparator Authorities:"]
[{"$f":"OFFSET('REF EA Name'!$B$2, A3,0)","v":"Angus"},{"$f":"IF(A3<33,OFFSET('DATA CP CON'!$B$3,A3,0),\"\")","v":181},{"$f":"OFFSET('DATA CP CON'!$J$3,A3,0)","v":19445},{"$f":"IF($A3=33,\"\",IF(B24=\"*\",\"\",B24*1000/C24))","v":9.3083054769863711},{"$f":"IF($A3=33,\"\",IF(B24=\"*\",\"\",IF(F24=\"*\",\"\",F24/B24-1)))","v":-5.5248618784530357E-2},{"$f":"IF(A3<33,OFFSET('DATA CP CON'!$C$3,A3,0),\"\")","v":171},{"$f":"OFFSET('DATA CP CON'!$K$3,A3,0)","v":19288},{"$f":"IF($A3=33,\"\",IF(F24=\"*\",\"\",F24*1000/G24))","v":8.8656159270012438},{"$f":"IF($A3=33,\"\",IF(F24=\"*\",\"\",IF(J24=\"*\",\"\",J24/F24-1)))","v":0.18128654970760238},{"$f":"IF(A3<33,OFFSET('DATA CP CON'!$D$3,A3,0),\"\")","v":202},{"$f":"OFFSET('DATA CP CON'!$L$3,A3,0)","v":19253},{"$f":"IF($A3=33,\"\",IF(J24=\"*\",\"\",J24*1000/K24))","v":10.491871396665454},{"$f":"IF($A3=33,\"\",IF(J24=\"*\",\"\",IF(N24=\"*\",\"\",N24/J24-1)))","v":-0.29207920792079212},{"$f":"IF(A3<33,OFFSET('DATA CP CON'!$E$3,A3,0),\"\")","v":143},{"$f":"OFFSET('DATA CP CON'!$M$3,A3,0)","v":19145},{"$f":"IF($A3=33,\"\",IF(N24=\"*\",\"\",N24*1000/O24))","v":7.4693131365891876},{"$f":"IF($A3=33,\"\",IF(N24=\"*\",\"\",IF(R24=\"*\",\"\",R24/N24-1)))","v":-9.0909090909090939E-2},{"$f":"IF(A3<33,OFFSET('DATA CP CON'!$F$3,A3,0),\"\")","v":130},{"$f":"OFFSET('DATA CP CON'!$N$3,A3,0)","v":18908},{"$f":"IF($A3=33,\"\",IF(R24=\"*\",\"\",R24*1000/S24))","v":6.8753966574994712},{"$f":"IF($A3=33,\"\",IF(R24=\"*\",\"\",IF(V24=\"*\",\"\",V24/R24-1)))","v":-0.14615384615384619},{"$f":"IF(A3<33,OFFSET('DATA CP CON'!$G$3,A3,0),\"\")","v":111},{"$f":"OFFSET('DATA CP CON'!$O$3,A3,0)","v":18639},{"$f":"IF($A3=33,\"\",IF(V24=\"*\",\"\",V24*1000/W24))","v":5.955255110252696},{"$f":"IF($A3=33,\"\",IF(V24=\"*\",\"\",IF(Z24=\"*\",\"\",Z24/V24-1)))","v":-0.11711711711711714},{"$f":"IF(A3<33,OFFSET('DATA CP CON'!$H$3,A3,0),\"\")","v":98},{"$f":"OFFSET('DATA CP CON'!$P$3,A3,0)","v":18639},{"$f":"IF($A3=33,\"\",IF(Z24=\"*\",\"\",Z24*1000/AA24))","v":5.257792800042921},{"$f":"IF(A3<33,IF(RANK(AB24,'DATA CP CON'!$Y$4:$Y$35)<9,1,IF(RANK(AB24,'DATA CP CON'!$Y$4:$Y$35)<17,2,IF(RANK(AB24,'DATA CP CON'!$Y$4:$Y$35)<25,3,4))),\"\")","v":2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A4,0)","v":"Highland"},{"$f":"IF(A4<33,OFFSET('DATA CP CON'!$B$3,A4,0),\"\")","v":194},{"$f":"OFFSET('DATA CP CON'!$J$3,A4,0)","v":39972},{"$f":"IF($A4=33,\"\",IF(B25=\"*\",\"\",B25*1000/C25))","v":4.8533973781647157},{"$f":"IF($A4=33,\"\",IF(B25=\"*\",\"\",IF(F25=\"*\",\"\",F25/B25-1)))","v":-0.15979381443298968},{"$f":"IF(A4<33,OFFSET('DATA CP CON'!$C$3,A4,0),\"\")","v":163},{"$f":"OFFSET('DATA CP CON'!$K$3,A4,0)","v":39555},{"$f":"IF($A4=33,\"\",IF(F25=\"*\",\"\",F25*1000/G25))","v":4.1208443938819368},{"$f":"IF($A4=33,\"\",IF(F25=\"*\",\"\",IF(J25=\"*\",\"\",J25/F25-1)))","v":7.361963190184051E-2},{"$f":"IF(A4<33,OFFSET('DATA CP CON'!$D$3,A4,0),\"\")","v":175},{"$f":"OFFSET('DATA CP CON'!$L$3,A4,0)","v":39335},{"$f":"IF($A4=33,\"\",IF(J25=\"*\",\"\",J25*1000/K25))","v":4.4489640269480111},{"$f":"IF($A4=33,\"\",IF(J25=\"*\",\"\",IF(N25=\"*\",\"\",N25/J25-1)))","v":1.1428571428571344E-2},{"$f":"IF(A4<33,OFFSET('DATA CP CON'!$E$3,A4,0),\"\")","v":177},{"$f":"OFFSET('DATA CP CON'!$M$3,A4,0)","v":39036},{"$f":"IF($A4=33,\"\",IF(N25=\"*\",\"\",N25*1000/O25))","v":4.5342760528742696},{"$f":"IF($A4=33,\"\",IF(N25=\"*\",\"\",IF(R25=\"*\",\"\",R25/N25-1)))","v":-1.1299435028248594E-2},{"$f":"IF(A4<33,OFFSET('DATA CP CON'!$F$3,A4,0),\"\")","v":175},{"$f":"OFFSET('DATA CP CON'!$N$3,A4,0)","v":38490},{"$f":"IF($A4=33,\"\",IF(R25=\"*\",\"\",R25*1000/S25))","v":4.5466354897375938},{"$f":"IF($A4=33,\"\",IF(R25=\"*\",\"\",IF(V25=\"*\",\"\",V25/R25-1)))","v":-0.29142857142857148},{"$f":"IF(A4<33,OFFSET('DATA CP CON'!$G$3,A4,0),\"\")","v":124},{"$f":"OFFSET('DATA CP CON'!$O$3,A4,0)","v":38130},{"$f":"IF($A4=33,\"\",IF(V25=\"*\",\"\",V25*1000/W25))","v":3.2520325203252032},{"$f":"IF($A4=33,\"\",IF(V25=\"*\",\"\",IF(Z25=\"*\",\"\",Z25/V25-1)))","v":0.12903225806451624},{"$f":"IF(A4<33,OFFSET('DATA CP CON'!$H$3,A4,0),\"\")","v":140},{"$f":"OFFSET('DATA CP CON'!$P$3,A4,0)","v":38130},{"$f":"IF($A4=33,\"\",IF(Z25=\"*\",\"\",Z25*1000/AA25))","v":3.6716496197220039},{"$f":"IF(A4<33,IF(RANK(AB25,'DATA CP CON'!$Y$4:$Y$35)<9,1,IF(RANK(AB25,'DATA CP CON'!$Y$4:$Y$35)<17,2,IF(RANK(AB25,'DATA CP CON'!$Y$4:$Y$35)<25,3,4))),\"\")","v":4}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A5,0)","v":"Argyll & Bute"},{"$f":"IF(A5<33,OFFSET('DATA CP CON'!$B$3,A5,0),\"\")","v":73},{"$f":"OFFSET('DATA CP CON'!$J$3,A5,0)","v":13238},{"$f":"IF($A5=33,\"\",IF(B26=\"*\",\"\",B26*1000/C26))","v":5.5144281613536785},{"$f":"IF($A5=33,\"\",IF(B26=\"*\",\"\",IF(F26=\"*\",\"\",F26/B26-1)))","v":0.26027397260273966},{"$f":"IF(A5<33,OFFSET('DATA CP CON'!$C$3,A5,0),\"\")","v":92},{"$f":"OFFSET('DATA CP CON'!$K$3,A5,0)","v":13163},{"$f":"IF($A5=33,\"\",IF(F26=\"*\",\"\",F26*1000/G26))","v":6.9892881561953963},{"$f":"IF($A5=33,\"\",IF(F26=\"*\",\"\",IF(J26=\"*\",\"\",J26/F26-1)))","v":-0.13043478260869568},{"$f":"IF(A5<33,OFFSET('DATA CP CON'!$D$3,A5,0),\"\")","v":80},{"$f":"OFFSET('DATA CP CON'!$L$3,A5,0)","v":13024},{"$f":"IF($A5=33,\"\",IF(J26=\"*\",\"\",J26*1000/K26))","v":6.1425061425061429},{"$f":"IF($A5=33,\"\",IF(J26=\"*\",\"\",IF(N26=\"*\",\"\",N26/J26-1)))","v":-0.15000000000000002},{"$f":"IF(A5<33,OFFSET('DATA CP CON'!$E$3,A5,0),\"\")","v":68},{"$f":"OFFSET('DATA CP CON'!$M$3,A5,0)","v":12906},{"$f":"IF($A5=33,\"\",IF(N26=\"*\",\"\",N26*1000/O26))","v":5.268867193553386},{"$f":"IF($A5=33,\"\",IF(N26=\"*\",\"\",IF(R26=\"*\",\"\",R26/N26-1)))","v":0.10294117647058831},{"$f":"IF(A5<33,OFFSET('DATA CP CON'!$F$3,A5,0),\"\")","v":75},{"$f":"OFFSET('DATA CP CON'!$N$3,A5,0)","v":12577},{"$f":"IF($A5=33,\"\",IF(R26=\"*\",\"\",R26*1000/S26))","v":5.9632662797169438},{"$f":"IF($A5=33,\"\",IF(R26=\"*\",\"\",IF(V26=\"*\",\"\",V26/R26-1)))","v":-0.28000000000000003},{"$f":"IF(A5<33,OFFSET('DATA CP CON'!$G$3,A5,0),\"\")","v":54},{"$f":"OFFSET('DATA CP CON'!$O$3,A5,0)","v":12441},{"$f":"IF($A5=33,\"\",IF(V26=\"*\",\"\",V26*1000/W26))","v":4.3404870991077891},{"$f":"IF($A5=33,\"\",IF(V26=\"*\",\"\",IF(Z26=\"*\",\"\",Z26/V26-1)))","v":-0.29629629629629628},{"$f":"IF(A5<33,OFFSET('DATA CP CON'!$H$3,A5,0),\"\")","v":38},{"$f":"OFFSET('DATA CP CON'!$P$3,A5,0)","v":12441},{"$f":"IF($A5=33,\"\",IF(Z26=\"*\",\"\",Z26*1000/AA26))","v":3.054416847520296},{"$f":"IF(A5<33,IF(RANK(AB26,'DATA CP CON'!$Y$4:$Y$35)<9,1,IF(RANK(AB26,'DATA CP CON'!$Y$4:$Y$35)<17,2,IF(RANK(AB26,'DATA CP CON'!$Y$4:$Y$35)<25,3,4))),\"\")","v":4}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A6,0)","v":"East Dunbartonshire"},{"$f":"IF(A6<33,OFFSET('DATA CP CON'!$B$3,A6,0),\"\")","v":91},{"$f":"OFFSET('DATA CP CON'!$J$3,A6,0)","v":18810},{"$f":"IF($A6=33,\"\",IF(B27=\"*\",\"\",B27*1000/C27))","v":4.8378522062732587},{"$f":"IF($A6=33,\"\",IF(B27=\"*\",\"\",IF(F27=\"*\",\"\",F27/B27-1)))","v":-3.2967032967032961E-2},{"$f":"IF(A6<33,OFFSET('DATA CP CON'!$C$3,A6,0),\"\")","v":88},{"$f":"OFFSET('DATA CP CON'!$K$3,A6,0)","v":19061},{"$f":"IF($A6=33,\"\",IF(F27=\"*\",\"\",F27*1000/G27))","v":4.6167567283983004},{"$f":"IF($A6=33,\"\",IF(F27=\"*\",\"\",IF(J27=\"*\",\"\",J27/F27-1)))","v":0.31818181818181812},{"$f":"IF(A6<33,OFFSET('DATA CP CON'!$D$3,A6,0),\"\")","v":116},{"$f":"OFFSET('DATA CP CON'!$L$3,A6,0)","v":19224},{"$f":"IF($A6=33,\"\",IF(J27=\"*\",\"\",J27*1000/K27))","v":6.0341240116521018},{"$f":"IF($A6=33,\"\",IF(J27=\"*\",\"\",IF(N27=\"*\",\"\",N27/J27-1)))","v":-0.11206896551724133},{"$f":"IF(A6<33,OFFSET('DATA CP CON'!$E$3,A6,0),\"\")","v":103},{"$f":"OFFSET('DATA CP CON'!$M$3,A6,0)","v":19398},{"$f":"IF($A6=33,\"\",IF(N27=\"*\",\"\",N27*1000/O27))","v":5.3098257552324979},{"$f":"IF($A6=33,\"\",IF(N27=\"*\",\"\",IF(R27=\"*\",\"\",R27/N27-1)))","v":-0.15533980582524276},{"$f":"IF(A6<33,OFFSET('DATA CP CON'!$F$3,A6,0),\"\")","v":87},{"$f":"OFFSET('DATA CP CON'!$N$3,A6,0)","v":19500},{"$f":"IF($A6=33,\"\",IF(R27=\"*\",\"\",R27*1000/S27))","v":4.4615384615384617},{"$f":"IF($A6=33,\"\",IF(R27=\"*\",\"\",IF(V27=\"*\",\"\",V27/R27-1)))","v":1.1494252873563315E-2},{"$f":"IF(A6<33,OFFSET('DATA CP CON'!$G$3,A6,0),\"\")","v":88},{"$f":"OFFSET('DATA CP CON'!$O$3,A6,0)","v":19528},{"$f":"IF($A6=33,\"\",IF(V27=\"*\",\"\",V27*1000/W27))","v":4.5063498566161408},{"$f":"IF($A6=33,\"\",IF(V27=\"*\",\"\",IF(Z27=\"*\",\"\",Z27/V27-1)))","v":-4.5454545454545414E-2},{"$f":"IF(A6<33,OFFSET('DATA CP CON'!$H$3,A6,0),\"\")","v":84},{"$f":"OFFSET('DATA CP CON'!$P$3,A6,0)","v":19528},{"$f":"IF($A6=33,\"\",IF(Z27=\"*\",\"\",Z27*1000/AA27))","v":4.3015157722244979},{"$f":"IF(A6<33,IF(RANK(AB27,'DATA CP CON'!$Y$4:$Y$35)<9,1,IF(RANK(AB27,'DATA CP CON'!$Y$4:$Y$35)<17,2,IF(RANK(AB27,'DATA CP CON'!$Y$4:$Y$35)<25,3,4))),\"\")","v":3}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A7,0)","v":"Moray"},{"$f":"IF(A7<33,OFFSET('DATA CP CON'!$B$3,A7,0),\"\")","v":97},{"$f":"OFFSET('DATA CP CON'!$J$3,A7,0)","v":16527},{"$f":"IF($A7=33,\"\",IF(B28=\"*\",\"\",B28*1000/C28))","v":5.8691837599080294},{"$f":"IF($A7=33,\"\",IF(B28=\"*\",\"\",IF(F28=\"*\",\"\",F28/B28-1)))","v":0.17525773195876293},{"$f":"IF(A7<33,OFFSET('DATA CP CON'!$C$3,A7,0),\"\")","v":114},{"$f":"OFFSET('DATA CP CON'!$K$3,A7,0)","v":16362},{"$f":"IF($A7=33,\"\",IF(F28=\"*\",\"\",F28*1000/G28))","v":6.9673634030069671},{"$f":"IF($A7=33,\"\",IF(F28=\"*\",\"\",IF(J28=\"*\",\"\",J28/F28-1)))","v":-0.20175438596491224},{"$f":"IF(A7<33,OFFSET('DATA CP CON'!$D$3,A7,0),\"\")","v":91},{"$f":"OFFSET('DATA CP CON'!$L$3,A7,0)","v":16173},{"$f":"IF($A7=33,\"\",IF(J28=\"*\",\"\",J28*1000/K28))","v":5.6266617201508691},{"$f":"IF($A7=33,\"\",IF(J28=\"*\",\"\",IF(N28=\"*\",\"\",N28/J28-1)))","v":0.24175824175824179},{"$f":"IF(A7<33,OFFSET('DATA CP CON'!$E$3,A7,0),\"\")","v":113},{"$f":"OFFSET('DATA CP CON'!$M$3,A7,0)","v":16145},{"$f":"IF($A7=33,\"\",IF(N28=\"*\",\"\",N28*1000/O28))","v":6.9990709197894088},{"$f":"IF($A7=33,\"\",IF(N28=\"*\",\"\",IF(R28=\"*\",\"\",R28/N28-1)))","v":-0.55752212389380529},{"$f":"IF(A7<33,OFFSET('DATA CP CON'!$F$3,A7,0),\"\")","v":50},{"$f":"OFFSET('DATA CP CON'!$N$3,A7,0)","v":16037},{"$f":"IF($A7=33,\"\",IF(R28=\"*\",\"\",R28*1000/S28))","v":3.1177901103697701},{"$f":"IF($A7=33,\"\",IF(R28=\"*\",\"\",IF(V28=\"*\",\"\",V28/R28-1)))","v":0.10000000000000009},{"$f":"IF(A7<33,OFFSET('DATA CP CON'!$G$3,A7,0),\"\")","v":55},{"$f":"OFFSET('DATA CP CON'!$O$3,A7,0)","v":15941},{"$f":"IF($A7=33,\"\",IF(V28=\"*\",\"\",V28*1000/W28))","v":3.4502226961922089},{"$f":"IF($A7=33,\"\",IF(V28=\"*\",\"\",IF(Z28=\"*\",\"\",Z28/V28-1)))","v":9.0909090909090828E-2},{"$f":"IF(A7<33,OFFSET('DATA CP CON'!$H$3,A7,0),\"\")","v":60},{"$f":"OFFSET('DATA CP CON'!$P$3,A7,0)","v":15941},{"$f":"IF($A7=33,\"\",IF(Z28=\"*\",\"\",Z28*1000/AA28))","v":3.763879304936955},{"$f":"IF(A7<33,IF(RANK(AB28,'DATA CP CON'!$Y$4:$Y$35)<9,1,IF(RANK(AB28,'DATA CP CON'!$Y$4:$Y$35)<17,2,IF(RANK(AB28,'DATA CP CON'!$Y$4:$Y$35)<25,3,4))),\"\")","v":3}]
[]
["Comparator authorities",{"$f":"SUM(B24:B28)","v":636},{"$f":"SUM(C24:C28)","v":107992},{"$f":"B30*1000/C30","v":5.8893251351951994},{"$f":"IF(B30=0,\"\",SUM(F24:F28)/SUM(B24:B28)-1)","v":-1.2578616352201255E-2},{"$f":"SUM(F24:F28)","v":628},{"$f":"SUM(G24:G28)","v":107429},{"$f":"SUM(F24:F28)/SUM(G24:G28)*1000","v":5.8457213601541484},{"$f":"IF(F30=0,\"\",SUM(J24:J28)/SUM(F24:F28)-1)","v":5.7324840764331197E-2},{"$f":"SUM(J24:J28)","v":664},{"$f":"SUM(K24:K28)","v":107009},{"$f":"SUM(J24:J28)/SUM(K24:K28)*1000","v":6.2050855535515712},{"$f":"IF(J30=0,\"\",SUM(N24:N28)/SUM(J24:J28)-1)","v":-9.0361445783132543E-2},{"$f":"SUM(N24:N28)","v":604},{"$f":"SUM(O24:O28)","v":106630},{"$f":"SUM(N24:N28)/SUM(O24:O28)*1000","v":5.6644471537090872},{"$f":"IF(N30=0,\"\",SUM(R24:R28)/SUM(N24:N28)-1)","v":-0.14403973509933776},{"$f":"SUM(R24:R28)","v":517},{"$f":"SUM(S24:S28)","v":105512},{"$f":"SUM(R24:R28)/SUM(S24:S28)*1000","v":4.8999165971643039},{"$f":"IF(R30=0,\"\",SUM(V24:V28)/SUM(R24:R28)-1)","v":-0.16441005802707931},{"$f":"SUM(V24:V28)","v":432},{"$f":"SUM(W24:W28)","v":104679},{"$f":"SUM(V24:V28)/SUM(W24:W28)*1000","v":4.1269022440030954},{"$f":"IF(V30=0,\"\",SUM(Z24:Z28)/SUM(V24:V28)-1)","v":-2.777777777777779E-2},{"$f":"SUM(Z24:Z28)","v":420},{"$f":"SUM(AA24:AA28)","v":104679},{"$f":"SUM(Z24:Z28)/SUM(AA24:AA28)*1000","v":4.0122660705585647}]
[]
["Scotland  [Note 1],[Note2]",{"$f":"'DATA CP CON'!B36","v":5707},{"$f":"'DATA CP CON'!J36","v":915917},{"$f":"B32*1000/C32","v":6.2309139365248161},{"$f":"IF(B32=0,\"\",F32/B32-1)","v":-9.4620641317679777E-3},{"$f":"'DATA CP CON'!C36","v":5653},{"$f":"'DATA CP CON'!K36","v":917442},{"$f":"F32*1000/G32","v":6.1616974152044488},{"$f":"IF(F32=0,\"\",J32/F32-1)","v":3.5379444542726901E-4},{"$f":"'DATA CP CON'!D36","v":5655},{"$f":"'DATA CP CON'!L36","v":919502},{"$f":"J32*1000/K32","v":6.1500681890849611},{"$f":"IF(J32=0,\"\",N32/J32-1)","v":-2.2458001768346558E-2},{"$f":"'DATA CP CON'!E36","v":5528},{"$f":"'DATA CP CON'!$M$36","v":921397},{"$f":"N32*1000/O32","v":5.9995854121513315},{"$f":"IF(N32=0,\"\",R32/N32-1)","v":-7.7424023154848087E-2},{"$f":"'DATA CP CON'!F36","v":5100},{"$f":"'DATA CP CON'!$N$36","v":916783},{"$f":"R32*1000/S32","v":5.562930377199403},{"$f":"IF(R32=0,\"\",V32/R32-1)","v":-0.11058823529411765},{"$f":"'DATA CP CON'!G36","v":4536},{"$f":"'DATA CP CON'!$O$36","v":911522},{"$f":"V32*1000/W32","v":4.9762923988669501},{"$f":"IF(V32=0,\"\",Z32/V32-1)","v":-8.8403880070546781E-2},{"$f":"'DATA CP CON'!H36","v":4135},{"$f":"'DATA CP CON'!P36","v":911522},{"$f":"Z32*1000/AA32","v":4.5363688424415427}]
[]
["Notes"]
["[Note 1]",{"$f":"IF('DATA CP CON'!A38=\"\",\"\",'DATA CP CON'!A38)","v":"Figures for 2022 are provisional and may be revised with the publication of 2023 statistics."}]
["[Note 2]",{"$f":"IF('DATA CP CON'!A39=\"\",\"\",'DATA CP CON'!A39)","v":"Population figures source: NRS mid-year population estimates for 2016-2021"}]
["[Note 3]",{"$f":"IF('DATA CP CON'!A40=\"\",\"\",'DATA CP CON'!A40)","v":"Source: Scottish Government CP Returns"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U21-U30","v":0.51223614498360104},null,null,{"$f":"X21-X30","v":-6.2572202922770437E-2},{"$f":"Y21-Y30","v":-4.4802867383512135E-3},null,null,{"$f":"AB21-AB30","v":-7.9043450158250206E-2},{"$f":"IF(AB40<-0.5,\"less than\",IF(AB40>0.5,\"greater than\",\"similar to\"))","v":"similar to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U21-U32","v":0.45841432225063938},null,null,{"$f":"X21-X32","v":-0.91196235778662516},{"$f":"Y22-Y32","v":8.8403880070546781E-2},null,null,{"$f":"AB21-AB32","v":-0.60314622204122825},{"$f":"IF(AB41<-0.5,\"less than\",IF(AB41>0.5,\"greater than\",\"similar to\"))","v":"less than"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V21-R21","v":24},null,null,null,{"$f":"Z21-V21","v":-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U43<0,\"a decrease of \",IF(U43>=0,\"an increase of \"))","v":"an increase of "},null,null,null,{"$f":"IF(Y43<0,\"a decrease of \",IF(Y43>=0,\"an increase of \"))","v":"a decrease of "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U30<0,\"a decrease of \",IF(U30>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Y30<0,\"a decrease of \",IF(Y30>=0,\"an increase of \"))","v":"a decrease of "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U32<0,\"a decrease of \",IF(U32>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Y32<0,\"a decrease of \",IF(Y32>=0,\"an increase of \"))","v":"a decrease of "}]

{"sheet":"CP registrations","index":2,"n_rows":47,"n_cols":29,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'DATA CP REG'!A1","v":"Child Protection: Registrations: 31 July 2016-2022"}]
[null,"select comparators:"]
[{"$f":"J3","v":3},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":3}]
[{"$f":"J4","v":16},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":16}]
[{"$f":"J5","v":4},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":4}]
[{"$f":"J6","v":26},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":26}]
[{"$f":"J7","v":19},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":19}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(Z21=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Y21=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The number of registrations following a case conference in \"&A21&\" in \"&Z19&\" was \"&ROUND(Z21,0)&\" (\"&Y44&ROUND((SQRT((Y21*100)^2)),1)&\"% from \"&ROUND(V21,0)&\" in \"&V19&\")\"))","v":"*  The number of registrations following a case conference in Dumfries & Galloway in 2022 was 79 (an increase of 29.5% from 61 in 2021)"}]
[{"$f":"IF(Y30=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&Y46&ROUND(SQRT((Y30*100)^2),1)&\"%, while the Scotland figures show \"&Y47&ROUND(SQRT((100*Y32)^2),1)&\"%\")","v":"*  The comparator authorities show an increase of 4.8%, while the Scotland figures show a decrease of 5%"}]
[{"$f":"IF(AB21=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(AB30=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The rate (per 1,000 pop 0-15) is \"&ROUND(AB21,1)&\".  This is \"&AC40&\" the comparator average rate of \"&ROUND(AB30,1)&\", and \"&AC41&\" the Scotland average rate of \"&ROUND(AB32,1)))","v":"*  The rate (per 1,000 pop 0-15) is 3.5.  This is similar to the comparator average rate of 3.6, and similar to the Scotland average rate of 3.6"}]
[]
[null,{"$f":"'DATA CP REG'!B3","v":2016},null,2016,2016,{"$f":"'DATA CP REG'!C3","v":2017},null,2017,2017,{"$f":"'DATA CP REG'!D3","v":2018},null,2018,2018,{"$f":"'DATA CP REG'!E3","v":2019},null,2019,2019,{"$f":"'DATA CP REG'!F3","v":2020},null,2020,2020,{"$f":"'DATA CP REG'!G3","v":2021},null,2021,2021,{"$f":"'DATA CP REG'!H3","v":2022},null,2022,2022]
[null,"Number",{"$f":"'DATA CP REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP REG'!#REF!","v":{"$error":"#REF!"}},"Rate","Quartile"]
[{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Dumfries & Galloway"},{"$f":"OFFSET('DATA CP REG'!$B$3,'Select an authority'!$A$1,0)","v":109},null,{"$f":"OFFSET('DATA CP REG'!$S$3,'Select an authority'!$A$1,0)","v":4.6159058185821973},{"$f":"IF(B21=0,\"\",F21/B21-1)","v":0.4311926605504588},{"$f":"OFFSET('DATA CP REG'!$C$3,'Select an authority'!$A$1,0)","v":156},null,{"$f":"OFFSET('DATA CP REG'!$T$3,'Select an authority'!$A$1,0)","v":6.6419721548090429},{"$f":"IF(F21=0,\"\",J21/F21-1)","v":0.22435897435897445},{"$f":"OFFSET('DATA CP REG'!$D$3,'Select an authority'!$A$1,0)","v":191},null,{"$f":"OFFSET('DATA CP REG'!$U$3,'Select an authority'!$A$1,0)","v":8.1540300546448083},{"$f":"IF(J21=0,\"\",N21/J21-1)","v":-0.25654450261780104},{"$f":"OFFSET('DATA CP REG'!$E$3,'Select an authority'!$A$1,0)","v":142},null,{"$f":"OFFSET('DATA CP REG'!$V$3,'Select an authority'!$A$1,0)","v":6.1093662608097059},{"$f":"IF(N21=0,\"\",R21/N21-1)","v":-0.70422535211267601},{"$f":"OFFSET('DATA CP REG'!$F$3,'Select an authority'!$A$1,0)","v":42},null,{"$f":"OFFSET('DATA CP REG'!$W$3,'Select an authority'!$A$1,0)","v":1.8221258134490239},{"$f":"IF(R21=0,\"\",V21/R21-1)","v":0.45238095238095233},{"$f":"OFFSET('DATA CP REG'!$G$3,'Select an authority'!$A$1,0)","v":61},null,{"$f":"OFFSET('DATA CP REG'!$X$3,'Select an authority'!$A$1,0)","v":2.6658508871602131},{"$f":"IF(V21=0,\"\",Z21/V21-1)","v":0.29508196721311486},{"$f":"OFFSET('DATA CP REG'!$H$3,'Select an authority'!$A$1,0)","v":79},null,{"$f":"OFFSET('DATA CP REG'!$Y$3,'Select an authority'!$A$1,0)","v":3.4524954112402764},{"$f":"IF(AB21=\"*\",\"\",IF(RANK(AB21,'DATA CP REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB21,'DATA CP REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB21,'DATA CP REG'!$Y$4:$Y$35)<25,3,4))))","v":3}]
[]
["Comparator Authorities:"]
[{"$f":"OFFSET('REF EA Name'!$B$2, A3,0)","v":"Angus"},{"$f":"IF(A3<33,OFFSET('DATA CP REG'!$B$3,$A3,0),\" \")","v":151},{"$f":"OFFSET('DATA CP REG'!$J$3,$A3,0)","v":19445},{"$f":"IF($A3=33,\"\",B24*1000/C24)","v":7.7654924145024431},{"$f":"IF($A3=33,\"\",IF(B24=0,\"\",F24/B24-1))","v":-0.16556291390728473},{"$f":"IF(A3<33,OFFSET('DATA CP REG'!$C$3,$A3,0),\"\")","v":126},{"$f":"OFFSET('DATA CP REG'!$K$3,$A3,0)","v":19288},{"$f":"IF($A3=33,\"\",F24*1000/G24)","v":6.5325591041061797},{"$f":"IF($A3=33,\"\",IF(F24=0,\"\",J24/F24-1))","v":0.22222222222222232},{"$f":"IF(A3<33,OFFSET('DATA CP REG'!$D$3,$A3,0),\"\")","v":154},{"$f":"OFFSET('DATA CP REG'!$L$3,$A3,0)","v":19253},{"$f":"IF($A3=33,\"\",J24*1000/K24)","v":7.9987534410221786},{"$f":"IF($A3=33,\"\",IF(J24=0,\"\",N24/J24-1))","v":-0.36363636363636365},{"$f":"IF(A3<33,OFFSET('DATA CP REG'!$E$3,$A3,0),\"\")","v":98},{"$f":"OFFSET('DATA CP REG'!$M$3,$A3,0)","v":19145},{"$f":"IF($A3=33,\"\",N24*1000/O24)","v":5.1188299817184646},{"$f":"IF($A3=33,\"\",IF(N24=0,\"\",R24/N24-1))","v":0.1020408163265305},{"$f":"IF(A3<33,OFFSET('DATA CP REG'!$F$3,$A3,0),\"\")","v":108},{"$f":"OFFSET('DATA CP REG'!$N$3,$A3,0)","v":18908},{"$f":"IF($A3=33,\"\",R24*1000/S24)","v":5.7118679923841764},{"$f":"IF($A3=33,\"\",IF(R24=0,\"\",V24/R24-1))","v":-0.12037037037037035},{"$f":"IF(A3<33,OFFSET('DATA CP REG'!$G$3,$A3,0),\"\")","v":95},{"$f":"OFFSET('DATA CP REG'!$O$3,$A3,0)","v":18639},{"$f":"IF($A3=33,\"\",V24*1000/W24)","v":5.0968399592252807},{"$f":"IF($A3=33,\"\",IF(V24=0,\"\",Z24/V24-1))","v":-1.0526315789473717E-2},{"$f":"IF(A3<33,OFFSET('DATA CP REG'!$H$3,$A3,0),\"\")","v":94},{"$f":"OFFSET('DATA CP REG'!$P$3,$A3,0)","v":18639},{"$f":"IF($A3=33,\"\",Z24*1000/AA24)","v":5.0431890122860672},{"$f":"IF(AB24=\"*\",\"\",IF(A3<33,IF(RANK(AB24,'DATA CP REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB24,'DATA CP REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB24,'DATA CP REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":1}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A4,0)","v":"Highland"},{"$f":"IF(A4<33,OFFSET('DATA CP REG'!$B$3,$A4,0),\"\")","v":168},{"$f":"OFFSET('DATA CP REG'!$J$3,$A4,0)","v":39972},{"$f":"IF($A4=33,\"\",B25*1000/C25)","v":4.2029420594416091},{"$f":"IF($A4=33,\"\",IF(B25=0,\"\",F25/B25-1))","v":-0.1785714285714286},{"$f":"IF(A4<33,OFFSET('DATA CP REG'!$C$3,$A4,0),\"\")","v":138},{"$f":"OFFSET('DATA CP REG'!$K$3,$A4,0)","v":39555},{"$f":"IF($A4=33,\"\",F25*1000/G25)","v":3.4888130451270385},{"$f":"IF($A4=33,\"\",IF(F25=0,\"\",J25/F25-1))","v":6.5217391304347894E-2},{"$f":"IF(A4<33,OFFSET('DATA CP REG'!$D$3,$A4,0),\"\")","v":147},{"$f":"OFFSET('DATA CP REG'!$L$3,$A4,0)","v":39335},{"$f":"IF($A4=33,\"\",J25*1000/K25)","v":3.737129782636329},{"$f":"IF($A4=33,\"\",IF(J25=0,\"\",N25/J25-1))","v":2.7210884353741527E-2},{"$f":"IF(A4<33,OFFSET('DATA CP REG'!$E$3,$A4,0),\"\")","v":151},{"$f":"OFFSET('DATA CP REG'!$M$3,$A4,0)","v":39036},{"$f":"IF($A4=33,\"\",N25*1000/O25)","v":3.8682242032995182},{"$f":"IF($A4=33,\"\",IF(N25=0,\"\",R25/N25-1))","v":8.6092715231788075E-2},{"$f":"IF(A4<33,OFFSET('DATA CP REG'!$F$3,$A4,0),\"\")","v":164},{"$f":"OFFSET('DATA CP REG'!$N$3,$A4,0)","v":38490},{"$f":"IF($A4=33,\"\",R25*1000/S25)","v":4.2608469732398024},{"$f":"IF($A4=33,\"\",IF(R25=0,\"\",V25/R25-1))","v":-0.3597560975609756},{"$f":"IF(A4<33,OFFSET('DATA CP REG'!$G$3,$A4,0),\"\")","v":105},{"$f":"OFFSET('DATA CP REG'!$O$3,$A4,0)","v":38130},{"$f":"IF($A4=33,\"\",V25*1000/W25)","v":2.7537372147915029},{"$f":"IF($A4=33,\"\",IF(V25=0,\"\",Z25/V25-1))","v":0.2952380952380953},{"$f":"IF(A4<33,OFFSET('DATA CP REG'!$H$3,$A4,0),\"\")","v":136},{"$f":"OFFSET('DATA CP REG'!$P$3,$A4,0)","v":38130},{"$f":"IF($A4=33,\"\",Z25*1000/AA25)","v":3.5667453448728037},{"$f":"IF(AB25=\"*\",\"\",IF(A4<33,IF(RANK(AB25,'DATA CP REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB25,'DATA CP REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB25,'DATA CP REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":3}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A5,0)","v":"Argyll & Bute"},{"$f":"IF(A5<33,OFFSET('DATA CP REG'!$B$3,$A5,0),\"\")","v":64},{"$f":"OFFSET('DATA CP REG'!$J$3,$A5,0)","v":13238},{"$f":"IF($A5=33,\"\",B26*1000/C26)","v":4.8345671551593901},{"$f":"IF($A5=33,\"\",IF(B26=0,\"\",F26/B26-1))","v":0.140625},{"$f":"IF(A5<33,OFFSET('DATA CP REG'!$C$3,$A5,0),\"\")","v":73},{"$f":"OFFSET('DATA CP REG'!$K$3,$A5,0)","v":13163},{"$f":"IF($A5=33,\"\",F26*1000/G26)","v":5.5458482108941727},{"$f":"IF($A5=33,\"\",IF(F26=0,\"\",J26/F26-1))","v":-0.21917808219178081},{"$f":"IF(A5<33,OFFSET('DATA CP REG'!$D$3,$A5,0),\"\")","v":57},{"$f":"OFFSET('DATA CP REG'!$L$3,$A5,0)","v":13024},{"$f":"IF($A5=33,\"\",J26*1000/K26)","v":4.3765356265356266},{"$f":"IF($A5=33,\"\",IF(J26=0,\"\",N26/J26-1))","v":-1.7543859649122862E-2},{"$f":"IF(A5<33,OFFSET('DATA CP REG'!$E$3,$A5,0),\"\")","v":56},{"$f":"OFFSET('DATA CP REG'!$M$3,$A5,0)","v":12906},{"$f":"IF($A5=33,\"\",N26*1000/O26)","v":4.3390671005733763},{"$f":"IF($A5=33,\"\",IF(N26=0,\"\",R26/N26-1))","v":0.1964285714285714},{"$f":"IF(A5<33,OFFSET('DATA CP REG'!$F$3,$A5,0),\"\")","v":67},{"$f":"OFFSET('DATA CP REG'!$N$3,$A5,0)","v":12577},{"$f":"IF($A5=33,\"\",R26*1000/S26)","v":5.3271845432138027},{"$f":"IF($A5=33,\"\",IF(R26=0,\"\",V26/R26-1))","v":-0.28358208955223885},{"$f":"IF(A5<33,OFFSET('DATA CP REG'!$G$3,$A5,0),\"\")","v":48},{"$f":"OFFSET('DATA CP REG'!$O$3,$A5,0)","v":12441},{"$f":"IF($A5=33,\"\",V26*1000/W26)","v":3.8582107547624789},{"$f":"IF($A5=33,\"\",IF(V26=0,\"\",Z26/V26-1))","v":-0.375},{"$f":"IF(A5<33,OFFSET('DATA CP REG'!$H$3,$A5,0),\"\")","v":30},{"$f":"OFFSET('DATA CP REG'!$P$3,$A5,0)","v":12441},{"$f":"IF($A5=33,\"\",Z26*1000/AA26)","v":2.4113817217265492},{"$f":"IF(AB26=\"*\",\"\",IF(A5<33,IF(RANK(AB26,'DATA CP REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB26,'DATA CP REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB26,'DATA CP REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":4}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A6,0)","v":"Scottish Borders"},{"$f":"IF(A6<33,OFFSET('DATA CP REG'!$B$3,$A6,0),\"\")","v":83},{"$f":"OFFSET('DATA CP REG'!$J$3,$A6,0)","v":19002},{"$f":"IF($A6=33,\"\",B27*1000/C27)","v":4.3679612672350281},{"$f":"IF($A6=33,\"\",IF(B27=0,\"\",F27/B27-1))","v":-0.38554216867469882},{"$f":"IF(A6<33,OFFSET('DATA CP REG'!$C$3,$A6,0),\"\")","v":51},{"$f":"OFFSET('DATA CP REG'!$K$3,$A6,0)","v":19026},{"$f":"IF($A6=33,\"\",F27*1000/G27)","v":2.6805424156417534},{"$f":"IF($A6=33,\"\",IF(F27=0,\"\",J27/F27-1))","v":0.47058823529411775},{"$f":"IF(A6<33,OFFSET('DATA CP REG'!$D$3,$A6,0),\"\")","v":75},{"$f":"OFFSET('DATA CP REG'!$L$3,$A6,0)","v":19046},{"$f":"IF($A6=33,\"\",J27*1000/K27)","v":3.937834715950856},{"$f":"IF($A6=33,\"\",IF(J27=0,\"\",N27/J27-1))","v":-0.19999999999999996},{"$f":"IF(A6<33,OFFSET('DATA CP REG'!$E$3,$A6,0),\"\")","v":60},{"$f":"OFFSET('DATA CP REG'!$M$3,$A6,0)","v":19023},{"$f":"IF($A6=33,\"\",N27*1000/O27)","v":3.1540766440624508},{"$f":"IF($A6=33,\"\",IF(N27=0,\"\",R27/N27-1))","v":-0.3833333333333333},{"$f":"IF(A6<33,OFFSET('DATA CP REG'!$F$3,$A6,0),\"\")","v":37},{"$f":"OFFSET('DATA CP REG'!$N$3,$A6,0)","v":18824},{"$f":"IF($A6=33,\"\",R27*1000/S27)","v":1.965575860603485},{"$f":"IF($A6=33,\"\",IF(R27=0,\"\",V27/R27-1))","v":0.59459459459459452},{"$f":"IF(A6<33,OFFSET('DATA CP REG'!$G$3,$A6,0),\"\")","v":59},{"$f":"OFFSET('DATA CP REG'!$O$3,$A6,0)","v":18723},{"$f":"IF($A6=33,\"\",V27*1000/W27)","v":3.1512044010041125},{"$f":"IF($A6=33,\"\",IF(V27=0,\"\",Z27/V27-1))","v":0},{"$f":"IF(A6<33,OFFSET('DATA CP REG'!$H$3,$A6,0),\"\")","v":59},{"$f":"OFFSET('DATA CP REG'!$P$3,$A6,0)","v":18723},{"$f":"IF($A6=33,\"\",Z27*1000/AA27)","v":3.1512044010041125},{"$f":"IF(AB27=\"*\",\"\",IF(A6<33,IF(RANK(AB27,'DATA CP REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB27,'DATA CP REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB27,'DATA CP REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":4}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A7,0)","v":"Moray"},{"$f":"IF(A7<33,OFFSET('DATA CP REG'!$B$3,$A7,0),\"\")","v":87},{"$f":"OFFSET('DATA CP REG'!$J$3,$A7,0)","v":16527},{"$f":"IF($A7=33,\"\",B28*1000/C28)","v":5.2641132691958612},{"$f":"IF($A7=33,\"\",IF(B28=0,\"\",F28/B28-1))","v":0.12643678160919536},{"$f":"IF(A7<33,OFFSET('DATA CP REG'!$C$3,$A7,0),\"\")","v":98},{"$f":"OFFSET('DATA CP REG'!$K$3,$A7,0)","v":16362},{"$f":"IF($A7=33,\"\",F28*1000/G28)","v":5.9894878376726561},{"$f":"IF($A7=33,\"\",IF(F28=0,\"\",J28/F28-1))","v":-0.12244897959183676},{"$f":"IF(A7<33,OFFSET('DATA CP REG'!$D$3,$A7,0),\"\")","v":86},{"$f":"OFFSET('DATA CP REG'!$L$3,$A7,0)","v":16173},{"$f":"IF($A7=33,\"\",J28*1000/K28)","v":5.3175044827799418},{"$f":"IF($A7=33,\"\",IF(J28=0,\"\",N28/J28-1))","v":0.10465116279069764},{"$f":"IF(A7<33,OFFSET('DATA CP REG'!$E$3,$A7,0),\"\")","v":95},{"$f":"OFFSET('DATA CP REG'!$M$3,$A7,0)","v":16145},{"$f":"IF($A7=33,\"\",N28*1000/O28)","v":5.8841746670795914},{"$f":"IF($A7=33,\"\",IF(N28=0,\"\",R28/N28-1))","v":-0.57894736842105265},{"$f":"IF(A7<33,OFFSET('DATA CP REG'!$F$3,$A7,0),\"\")","v":40},{"$f":"OFFSET('DATA CP REG'!$N$3,$A7,0)","v":16037},{"$f":"IF($A7=33,\"\",R28*1000/S28)","v":2.4942320882958158},{"$f":"IF($A7=33,\"\",IF(R28=0,\"\",V28/R28-1))","v":0.14999999999999991},{"$f":"IF(A7<33,OFFSET('DATA CP REG'!$G$3,$A7,0),\"\")","v":46},{"$f":"OFFSET('DATA CP REG'!$O$3,$A7,0)","v":15941},{"$f":"IF($A7=33,\"\",V28*1000/W28)","v":2.8856408004516654},{"$f":"IF($A7=33,\"\",IF(V28=0,\"\",Z28/V28-1))","v":0.10869565217391308},{"$f":"IF(A7<33,OFFSET('DATA CP REG'!$H$3,$A7,0),\"\")","v":51},{"$f":"OFFSET('DATA CP REG'!$P$3,$A7,0)","v":15941},{"$f":"IF($A7=33,\"\",Z28*1000/AA28)","v":3.1992974091964119},{"$f":"IF(AB28=\"*\",\"\",IF(A7<33,IF(RANK(AB28,'DATA CP REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB28,'DATA CP REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB28,'DATA CP REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":3}]
[]
["Comparator authorities",{"$f":"SUM(B24:B28)","v":553},{"$f":"SUM(C24:C28)","v":108184},{"$f":"1000*B30/(SUMIF(B24,\">0\",C24)+SUMIF(B25,\">0\",C25)+SUMIF(B26,\">0\",C26)+SUMIF(B27,\">0\",C27)+SUMIF(B28,\">0\",C28))","v":5.1116616135472901},{"$f":"IF(B30=0,\"\",SUM(F24:F28)/SUM(B24:B28)-1)","v":-0.12115732368896925},{"$f":"SUM(F24:F28)","v":486},{"$f":"SUM(G24:G28)","v":107394},{"$f":"1000*F30/(SUMIF(F24,\">0\",G24)+SUMIF(F25,\">0\",G25)+SUMIF(F26,\">0\",G26)+SUMIF(F27,\">0\",G27)+SUMIF(F28,\">0\",G28))","v":4.5253924800268175},{"$f":"IF(F30=0,\"\",SUM(J24:J28)/SUM(F24:F28)-1)","v":6.7901234567901314E-2},{"$f":"SUM(J24:J28)","v":519},{"$f":"SUM(K24:K28)","v":106831},{"$f":"1000*J30/(SUMIF(J24,\">0\",K24)+SUMIF(J25,\">0\",K25)+SUMIF(J26,\">0\",K26)+SUMIF(J27,\">0\",K27)+SUMIF(J28,\">0\",K28))","v":4.858140427404031},{"$f":"IF(J30=0,\"\",SUM(N24:N28)/SUM(J24:J28)-1)","v":-0.11368015414258192},{"$f":"SUM(N24:N28)","v":460},{"$f":"SUM(O24:O28)","v":106255},{"$f":"1000*N30/(SUMIF(N24,\">0\",O24)+SUMIF(N25,\">0\",O25)+SUMIF(N26,\">0\",O26)+SUMIF(N27,\">0\",O27)+SUMIF(N28,\">0\",O28))","v":4.3292080372688346},{"$f":"IF(N30=0,\"\",SUM(R24:R28)/SUM(N24:N28)-1)","v":-9.5652173913043481E-2},{"$f":"SUM(R24:R28)","v":416},{"$f":"SUM(S24:S28)","v":104836},{"$f":"1000*R30/(SUMIF(R24,\">0\",S24)+SUMIF(R25,\">0\",S25)+SUMIF(R26,\">0\",S26)+SUMIF(R27,\">0\",S27)+SUMIF(R28,\">0\",S28))","v":3.9681025601892479},{"$f":"IF(R30=0,\"\",SUM(V24:V28)/SUM(R24:R28)-1)","v":-0.15144230769230771},{"$f":"SUM(V24:V28)","v":353},{"$f":"SUM(W24:W28)","v":103874},{"$f":"1000*V30/(SUMIF(V24,\">0\",W24)+SUMIF(V25,\">0\",W25)+SUMIF(V26,\">0\",W26)+SUMIF(V27,\">0\",W27)+SUMIF(V28,\">0\",W28))","v":3.3983479985366887},{"$f":"IF(V30=0,\"\",SUM(Z24:Z28)/SUM(V24:V28)-1)","v":4.8158640226628968E-2},{"$f":"SUM(Z24:Z28)","v":370},{"$f":"SUM(AA24:AA28)","v":103874},{"$f":"1000*Z30/(SUMIF(Z24,\">0\",AA24)+SUMIF(Z25,\">0\",AA25)+SUMIF(Z26,\">0\",AA26)+SUMIF(Z27,\">0\",AA27)+SUMIF(Z28,\">0\",AA28))","v":3.5620078171631016}]
[]
["Scotland [Note 1],[Note 2]",{"$f":"'DATA CP REG'!$B$36","v":4273},{"$f":"'DATA CP REG'!$J$36","v":915917},{"$f":"B32*1000/C32","v":4.665269887992034},{"$f":"IF(B32=0,\"\",F32/B32-1)","v":4.6805523051720588E-3},{"$f":"'DATA CP REG'!$C$36","v":4293},{"$f":"'DATA CP REG'!$K$36","v":917442},{"$f":"F32*1000/G32","v":4.6793148776707412},{"$f":"IF(F32=0,\"\",J32/F32-1)","v":-1.0948054973212162E-2},{"$f":"'DATA CP REG'!$D$36","v":4246},{"$f":"'DATA CP REG'!$L$36","v":919502},{"$f":"J32*1000/K32","v":4.6177169815835093},{"$f":"IF(J32=0,\"\",N32/J32-1)","v":1.1540273198304307E-2},{"$f":"'DATA CP REG'!$E$36","v":4295},{"$f":"'DATA CP REG'!$M$36","v":921397},{"$f":"N32*1000/O32","v":4.6614000262644657},{"$f":"IF(N32=0,\"\",R32/N32-1)","v":-7.6367869615832418E-2},{"$f":"'DATA CP REG'!$F$36","v":3967},{"$f":"'DATA CP REG'!$N$36","v":916783},{"$f":"R32*1000/S32","v":4.3270872169313783},{"$f":"IF(R32=0,\"\",V32/R32-1)","v":-0.1280564658432064},{"$f":"'DATA CP REG'!$G$36","v":3459},{"$f":"'DATA CP REG'!$O$36","v":911522},{"$f":"V32*1000/W32","v":3.7947520740036995},{"$f":"IF(V32=0,\"\",Z32/V32-1)","v":-5.0014455044810613E-2},{"$f":"'DATA CP REG'!$H$36","v":3286},{"$f":"'DATA CP REG'!$P$36","v":911522},{"$f":"Z32*1000/AA32","v":3.6049596169922395}]
[]
["Notes"]
["[Note 1]",{"$f":"IF('DATA CP CON'!A38=\"\",\"\",'DATA CP CON'!A38)","v":"Figures for 2022 are provisional and may be revised with the publication of 2023 statistics."}]
["[Note 2]",{"$f":"IF('DATA CP CON'!A39=\"\",\"\",'DATA CP CON'!A39)","v":"Population figures source: NRS mid-year population estimates for 2016-2021"}]
["[Note 3]",{"$f":"IF('DATA CP CON'!A40=\"\",\"\",'DATA CP CON'!A40)","v":"Source: Scottish Government CP Returns"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U21-U30","v":0.60382326007326004},null,null,{"$f":"X21-X30","v":-0.73249711137647555},{"$f":"Y21-Y30","v":0.24692332698648589},null,null,{"$f":"AB21-AB30","v":-0.10951240592282518},{"$f":"IF(AB40<-0.5,\"less than\",IF(AB40>0.5,\"greater than\",\"similar to\"))","v":"similar to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U21-U32","v":0.58043741822415873},null,null,{"$f":"X21-X32","v":-1.1289011868434864},{"$f":"Y21-Y32","v":0.34509642225792547},null,null,{"$f":"AB21-AB32","v":-0.15246420575196318},{"$f":"IF(AB41<-0.5,\"less than\",IF(AB41>0.5,\"greater than\",\"similar to\"))","v":"similar to"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V21-R21","v":19},null,null,null,{"$f":"Z21-V21","v":18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U43<0,\"a decrease of \",IF(U43>=0,\"an increase of \"))","v":"an increase of "},null,null,null,{"$f":"IF(Y43<0,\"a decrease of \",IF(Y43>=0,\"an increase of \"))","v":"an increase of "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U30<0,\"a decrease of \",IF(U30>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Y30<0,\"a decrease of \",IF(Y30>=0,\"an increase of \"))","v":"an increase of "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U32<0,\"a decrease of \",IF(U32>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Y32<0,\"a decrease of \",IF(Y32>=0,\"an increase of \"))","v":"a decrease of "}]

{"sheet":"CP on Register","index":3,"n_rows":47,"n_cols":29,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'DATA CP ON REG'!A1","v":"Child Protection: On Child Protection Register:  as at 31 July 2016-2022"}]
[null,"select comparators:"]
[{"$f":"N3","v":3},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":3}]
[{"$f":"N4","v":16},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":16}]
[{"$f":"N5","v":4},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":4}]
[{"$f":"N6","v":26},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":26}]
[{"$f":"N7","v":19},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":19}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(Z21=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Y21=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The number of registrations following a case conference in \"&A21&\" in \"&Z19&\" was \"&ROUND(Z21,0)&\" (\"&Y44&ROUND((SQRT((Y21*100)^2)),1)&\"% from \"&ROUND(V21,0)&\" in \"&V19&\")\"))","v":"*  The number of registrations following a case conference in Dumfries & Galloway in 2022 was 41 (an increase of 20.6% from 34 in 2021)"}]
[{"$f":"IF(Y30=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&Y46&ROUND(SQRT((Y30*100)^2),1)&\"%, while the Scotland figures show \"&Y47&ROUND(SQRT((100*Y32)^2),1)&\"%\")","v":"*  The comparator authorities show an increase of 8.3%, while the Scotland figures show a decrease of 4.2%"}]
[{"$f":"IF(AB21=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(AB30=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The rate (per 1,000 pop 0-15) is \"&ROUND(AB21,1)&\".  This is \"&AC40&\" the comparator average rate of \"&ROUND(AB30,1)&\", and \"&AC41&\" the Scotland average rate of \"&ROUND(AB32,1)))","v":"*  The rate (per 1,000 pop 0-15) is 1.8.  This is less than the comparator average rate of 2.5, and similar to the Scotland average rate of 2.2"}]
[]
[null,2016,null,2016,2016,2017,null,2017,2017,2018,null,2018,2018,2019,null,2019,2019,2020,null,2020,2020,2021,null,2021,2021,2022,null,2022,2022]
[null,"Number",{"$f":"'DATA CP ON REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP ON REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP ON REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP ON REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP ON REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP ON REG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP ON REG'!#REF!","v":{"$error":"#REF!"}},"Rate","Quartile"]
[{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Dumfries & Galloway"},{"$f":"OFFSET('DATA CP ON REG'!$B$3,'Select an authority'!$A$1,0)","v":61},null,{"$f":"OFFSET('DATA CP ON REG'!$S$3,'Select an authority'!$A$1,0)","v":2.5832133480138899},{"$f":"IF(B21=0,\"\",F21/B21-1)","v":0.27868852459016402},{"$f":"OFFSET('DATA CP ON REG'!$C$3,'Select an authority'!$A$1,0)","v":78},null,{"$f":"OFFSET('DATA CP ON REG'!$T$3,'Select an authority'!$A$1,0)","v":3.3209860774045215},{"$f":"IF(F21=0,\"\",J21/F21-1)","v":0.19230769230769229},{"$f":"OFFSET('DATA CP ON REG'!$D$3,'Select an authority'!$A$1,0)","v":93},null,{"$f":"OFFSET('DATA CP ON REG'!$U$3,'Select an authority'!$A$1,0)","v":3.9702868852459017},{"$f":"IF(J21=0,\"\",N21/J21-1)","v":-0.80645161290322576},{"$f":"OFFSET('DATA CP ON REG'!$E$3,'Select an authority'!$A$1,0)","v":18},null,{"$f":"OFFSET('DATA CP ON REG'!$V$3,'Select an authority'!$A$1,0)","v":0.77442670911672329},{"$f":"IF(N21=0,\"\",R21/N21-1)","v":0.44444444444444442},{"$f":"OFFSET('DATA CP ON REG'!$F$3,'Select an authority'!$A$1,0)","v":26},null,{"$f":"OFFSET('DATA CP ON REG'!$W$3,'Select an authority'!$A$1,0)","v":1.1279826464208242},{"$f":"IF(R21=0,\"\",V21/R21-1)","v":0.30769230769230771},{"$f":"OFFSET('DATA CP ON REG'!$G$3,'Select an authority'!$A$1,0)","v":34},null,{"$f":"OFFSET('DATA CP ON REG'!$X$3,'Select an authority'!$A$1,0)","v":1.4858841010401189},{"$f":"IF(V21=0,\"\",Z21/V21-1)","v":0.20588235294117641},{"$f":"OFFSET('DATA CP ON REG'!$H$3,'Select an authority'!$A$1,0)","v":41},null,{"$f":"OFFSET('DATA CP ON REG'!$Y$3,'Select an authority'!$A$1,0)","v":1.7918014159601434},{"$f":"IF(AB21=\"*\",\"\",IF(RANK(AB21,'DATA CP ON REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB21,'DATA CP ON REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB21,'DATA CP ON REG'!$Y$4:$Y$35)<25,3,4))))","v":3}]
[]
["Comparator Authorities:"]
[{"$f":"OFFSET('REF EA Name'!$B$2, A3,0)","v":"Angus"},{"$f":"IF(A3<33,OFFSET('DATA CP ON REG'!$B$3,$A3,0),\" \")","v":96},{"$f":"OFFSET('DATA CP ON REG'!$J$3,$A3,0)","v":19445},{"$f":"IF($A3=33,\"\",B24*1000/C24)","v":4.9370017999485727},{"$f":"IF($A3=33,\"\",IF(B24=0,\"\",F24/B24-1))","v":-0.46875},{"$f":"IF(A3<33,OFFSET('DATA CP ON REG'!$C$3,$A3,0),\"\")","v":51},{"$f":"OFFSET('DATA CP ON REG'!$K$3,$A3,0)","v":19288},{"$f":"IF($A3=33,\"\",F24*1000/G24)","v":2.6441310659477395},{"$f":"IF($A3=33,\"\",IF(F24=0,\"\",J24/F24-1))","v":0.25490196078431371},{"$f":"IF(A3<33,OFFSET('DATA CP ON REG'!$D$3,$A3,0),\"\")","v":64},{"$f":"OFFSET('DATA CP ON REG'!$L$3,$A3,0)","v":19253},{"$f":"IF($A3=33,\"\",J24*1000/K24)","v":3.3241572741910352},{"$f":"IF($A3=33,\"\",IF(J24=0,\"\",N24/J24-1))","v":-0.296875},{"$f":"IF(A3<33,OFFSET('DATA CP ON REG'!$E$3,$A3,0),\"\")","v":45},{"$f":"OFFSET('DATA CP ON REG'!$M$3,$A3,0)","v":19145},{"$f":"IF($A3=33,\"\",N24*1000/O24)","v":2.3504831548707235},{"$f":"IF($A3=33,\"\",IF(N24=0,\"\",R24/N24-1))","v":-0.22222222222222221},{"$f":"IF(A3<33,OFFSET('DATA CP ON REG'!$F$3,$A3,0),\"\")","v":35},{"$f":"OFFSET('DATA CP ON REG'!$N$3,$A3,0)","v":18908},{"$f":"IF($A3=33,\"\",R24*1000/S24)","v":1.8510683308652423},{"$f":"IF($A3=33,\"\",IF(R24=0,\"\",V24/R24-1))","v":0.28571428571428581},{"$f":"IF(A3<33,OFFSET('DATA CP ON REG'!$G$3,$A3,0),\"\")","v":45},{"$f":"OFFSET('DATA CP ON REG'!$O$3,$A3,0)","v":18639},{"$f":"IF($A3=33,\"\",V24*1000/W24)","v":2.4142926122646067},{"$f":"IF($A3=33,\"\",IF(V24=0,\"\",Z24/V24-1))","v":0.31111111111111112},{"$f":"IF(A3<33,OFFSET('DATA CP ON REG'!$H$3,$A3,0),\"\")","v":59},{"$f":"OFFSET('DATA CP ON REG'!$P$3,$A3,0)","v":18639},{"$f":"IF($A3=33,\"\",Z24*1000/AA24)","v":3.1654058694135951},{"$f":"IF(AB24=\"*\",\"\",IF(A3<33,IF(RANK(AB24,'DATA CP ON REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB24,'DATA CP ON REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB24,'DATA CP ON REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":1}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A4,0)","v":"Highland"},{"$f":"IF(A4<33,OFFSET('DATA CP ON REG'!$B$3,$A4,0),\"\")","v":104},{"$f":"OFFSET('DATA CP ON REG'!$J$3,$A4,0)","v":39972},{"$f":"IF($A4=33,\"\",B25*1000/C25)","v":2.6018212748924245},{"$f":"IF($A4=33,\"\",IF(B25=0,\"\",F25/B25-1))","v":-1.9230769230769273E-2},{"$f":"IF(A4<33,OFFSET('DATA CP ON REG'!$C$3,$A4,0),\"\")","v":102},{"$f":"OFFSET('DATA CP ON REG'!$K$3,$A4,0)","v":39555},{"$f":"IF($A4=33,\"\",F25*1000/G25)","v":2.578687902919985},{"$f":"IF($A4=33,\"\",IF(F25=0,\"\",J25/F25-1))","v":-0.20588235294117652},{"$f":"IF(A4<33,OFFSET('DATA CP ON REG'!$D$3,$A4,0),\"\")","v":81},{"$f":"OFFSET('DATA CP ON REG'!$L$3,$A4,0)","v":39335},{"$f":"IF($A4=33,\"\",J25*1000/K25)","v":2.0592347781873648},{"$f":"IF($A4=33,\"\",IF(J25=0,\"\",N25/J25-1))","v":0.12345679012345689},{"$f":"IF(A4<33,OFFSET('DATA CP ON REG'!$E$3,$A4,0),\"\")","v":91},{"$f":"OFFSET('DATA CP ON REG'!$M$3,$A4,0)","v":39036},{"$f":"IF($A4=33,\"\",N25*1000/O25)","v":2.3311814735116303},{"$f":"IF($A4=33,\"\",IF(N25=0,\"\",R25/N25-1))","v":0.41758241758241765},{"$f":"IF(A4<33,OFFSET('DATA CP ON REG'!$F$3,$A4,0),\"\")","v":129},{"$f":"OFFSET('DATA CP ON REG'!$N$3,$A4,0)","v":38490},{"$f":"IF($A4=33,\"\",R25*1000/S25)","v":3.3515198752922837},{"$f":"IF($A4=33,\"\",IF(R25=0,\"\",V25/R25-1))","v":-0.2558139534883721},{"$f":"IF(A4<33,OFFSET('DATA CP ON REG'!$G$3,$A4,0),\"\")","v":96},{"$f":"OFFSET('DATA CP ON REG'!$O$3,$A4,0)","v":38130},{"$f":"IF($A4=33,\"\",V25*1000/W25)","v":2.5177025963808024},{"$f":"IF($A4=33,\"\",IF(V25=0,\"\",Z25/V25-1))","v":-3.125E-2},{"$f":"IF(A4<33,OFFSET('DATA CP ON REG'!$H$3,$A4,0),\"\")","v":93},{"$f":"OFFSET('DATA CP ON REG'!$P$3,$A4,0)","v":38130},{"$f":"IF($A4=33,\"\",Z25*1000/AA25)","v":2.4390243902439024},{"$f":"IF(AB25=\"*\",\"\",IF(A4<33,IF(RANK(AB25,'DATA CP ON REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB25,'DATA CP ON REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB25,'DATA CP ON REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A5,0)","v":"Argyll & Bute"},{"$f":"IF(A5<33,OFFSET('DATA CP ON REG'!$B$3,$A5,0),\"\")","v":40},{"$f":"OFFSET('DATA CP ON REG'!$J$3,$A5,0)","v":13238},{"$f":"IF($A5=33,\"\",B26*1000/C26)","v":3.0216044719746185},{"$f":"IF($A5=33,\"\",IF(B26=0,\"\",F26/B26-1))","v":-0.22499999999999998},{"$f":"IF(A5<33,OFFSET('DATA CP ON REG'!$C$3,$A5,0),\"\")","v":31},{"$f":"OFFSET('DATA CP ON REG'!$K$3,$A5,0)","v":13163},{"$f":"IF($A5=33,\"\",F26*1000/G26)","v":2.3550862265441008},{"$f":"IF($A5=33,\"\",IF(F26=0,\"\",J26/F26-1))","v":0},{"$f":"IF(A5<33,OFFSET('DATA CP ON REG'!$D$3,$A5,0),\"\")","v":31},{"$f":"OFFSET('DATA CP ON REG'!$L$3,$A5,0)","v":13024},{"$f":"IF($A5=33,\"\",J26*1000/K26)","v":2.38022113022113},{"$f":"IF($A5=33,\"\",IF(J26=0,\"\",N26/J26-1))","v":-9.6774193548387122E-2},{"$f":"IF(A5<33,OFFSET('DATA CP ON REG'!$E$3,$A5,0),\"\")","v":28},{"$f":"OFFSET('DATA CP ON REG'!$M$3,$A5,0)","v":12906},{"$f":"IF($A5=33,\"\",N26*1000/O26)","v":2.1695335502866882},{"$f":"IF($A5=33,\"\",IF(N26=0,\"\",R26/N26-1))","v":0.75},{"$f":"IF(A5<33,OFFSET('DATA CP ON REG'!$F$3,$A5,0),\"\")","v":49},{"$f":"OFFSET('DATA CP ON REG'!$N$3,$A5,0)","v":12577},{"$f":"IF($A5=33,\"\",R26*1000/S26)","v":3.8960006360817365},{"$f":"IF($A5=33,\"\",IF(R26=0,\"\",V26/R26-1))","v":-0.34693877551020413},{"$f":"IF(A5<33,OFFSET('DATA CP ON REG'!$G$3,$A5,0),\"\")","v":32},{"$f":"OFFSET('DATA CP ON REG'!$O$3,$A5,0)","v":12441},{"$f":"IF($A5=33,\"\",V26*1000/W26)","v":2.5721405031749858},{"$f":"IF($A5=33,\"\",IF(V26=0,\"\",Z26/V26-1))","v":-0.34375},{"$f":"IF(A5<33,OFFSET('DATA CP ON REG'!$H$3,$A5,0),\"\")","v":21},{"$f":"OFFSET('DATA CP ON REG'!$P$3,$A5,0)","v":12441},{"$f":"IF($A5=33,\"\",Z26*1000/AA26)","v":1.6879672052085846},{"$f":"IF(AB26=\"*\",\"\",IF(A5<33,IF(RANK(AB26,'DATA CP ON REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB26,'DATA CP ON REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB26,'DATA CP ON REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":4}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A6,0)","v":"Scottish Borders"},{"$f":"IF(A6<33,OFFSET('DATA CP ON REG'!$B$3,$A6,0),\"\")","v":67},{"$f":"OFFSET('DATA CP ON REG'!$J$3,$A6,0)","v":19002},{"$f":"IF($A6=33,\"\",B27*1000/C27)","v":3.5259446374065888},{"$f":"IF($A6=33,\"\",IF(B27=0,\"\",F27/B27-1))","v":-0.41791044776119401},{"$f":"IF(A6<33,OFFSET('DATA CP ON REG'!$C$3,$A6,0),\"\")","v":39},{"$f":"OFFSET('DATA CP ON REG'!$K$3,$A6,0)","v":19026},{"$f":"IF($A6=33,\"\",F27*1000/G27)","v":2.0498265531378115},{"$f":"IF($A6=33,\"\",IF(F27=0,\"\",J27/F27-1))","v":0.28205128205128216},{"$f":"IF(A6<33,OFFSET('DATA CP ON REG'!$D$3,$A6,0),\"\")","v":50},{"$f":"OFFSET('DATA CP ON REG'!$L$3,$A6,0)","v":19046},{"$f":"IF($A6=33,\"\",J27*1000/K27)","v":2.6252231439672373},{"$f":"IF($A6=33,\"\",IF(J27=0,\"\",N27/J27-1))","v":-7.999999999999996E-2},{"$f":"IF(A6<33,OFFSET('DATA CP ON REG'!$E$3,$A6,0),\"\")","v":46},{"$f":"OFFSET('DATA CP ON REG'!$M$3,$A6,0)","v":19023},{"$f":"IF($A6=33,\"\",N27*1000/O27)","v":2.4181254271145454},{"$f":"IF($A6=33,\"\",IF(N27=0,\"\",R27/N27-1))","v":-0.26086956521739135},{"$f":"IF(A6<33,OFFSET('DATA CP ON REG'!$F$3,$A6,0),\"\")","v":34},{"$f":"OFFSET('DATA CP ON REG'!$N$3,$A6,0)","v":18824},{"$f":"IF($A6=33,\"\",R27*1000/S27)","v":1.8062048448788781},{"$f":"IF($A6=33,\"\",IF(R27=0,\"\",V27/R27-1))","v":0},{"$f":"IF(A6<33,OFFSET('DATA CP ON REG'!$G$3,$A6,0),\"\")","v":34},{"$f":"OFFSET('DATA CP ON REG'!$O$3,$A6,0)","v":18723},{"$f":"IF($A6=33,\"\",V27*1000/W27)","v":1.8159482988837259},{"$f":"IF($A6=33,\"\",IF(V27=0,\"\",Z27/V27-1))","v":0.14705882352941169},{"$f":"IF(A6<33,OFFSET('DATA CP ON REG'!$H$3,$A6,0),\"\")","v":39},{"$f":"OFFSET('DATA CP ON REG'!$P$3,$A6,0)","v":18723},{"$f":"IF($A6=33,\"\",Z27*1000/AA27)","v":2.082999519307803},{"$f":"IF(AB27=\"*\",\"\",IF(A6<33,IF(RANK(AB27,'DATA CP ON REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB27,'DATA CP ON REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB27,'DATA CP ON REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":3}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A7,0)","v":"Moray"},{"$f":"IF(A7<33,OFFSET('DATA CP ON REG'!$B$3,$A7,0),\"\")","v":64},{"$f":"OFFSET('DATA CP ON REG'!$J$3,$A7,0)","v":16527},{"$f":"IF($A7=33,\"\",B28*1000/C28)","v":3.872451140557875},{"$f":"IF($A7=33,\"\",IF(B28=0,\"\",F28/B28-1))","v":0.234375},{"$f":"IF(A7<33,OFFSET('DATA CP ON REG'!$C$3,$A7,0),\"\")","v":79},{"$f":"OFFSET('DATA CP ON REG'!$K$3,$A7,0)","v":16362},{"$f":"IF($A7=33,\"\",F28*1000/G28)","v":4.8282606038381619},{"$f":"IF($A7=33,\"\",IF(F28=0,\"\",J28/F28-1))","v":-0.21518987341772156},{"$f":"IF(A7<33,OFFSET('DATA CP ON REG'!$D$3,$A7,0),\"\")","v":62},{"$f":"OFFSET('DATA CP ON REG'!$L$3,$A7,0)","v":16173},{"$f":"IF($A7=33,\"\",J28*1000/K28)","v":3.8335497433994932},{"$f":"IF($A7=33,\"\",IF(J28=0,\"\",N28/J28-1))","v":-0.24193548387096775},{"$f":"IF(A7<33,OFFSET('DATA CP ON REG'!$E$3,$A7,0),\"\")","v":47},{"$f":"OFFSET('DATA CP ON REG'!$M$3,$A7,0)","v":16145},{"$f":"IF($A7=33,\"\",N28*1000/O28)","v":2.9111179931867452},{"$f":"IF($A7=33,\"\",IF(N28=0,\"\",R28/N28-1))","v":-0.34042553191489366},{"$f":"IF(A7<33,OFFSET('DATA CP ON REG'!$F$3,$A7,0),\"\")","v":31},{"$f":"OFFSET('DATA CP ON REG'!$N$3,$A7,0)","v":16037},{"$f":"IF($A7=33,\"\",R28*1000/S28)","v":1.9330298684292573},{"$f":"IF($A7=33,\"\",IF(R28=0,\"\",V28/R28-1))","v":0.12903225806451624},{"$f":"IF(A7<33,OFFSET('DATA CP ON REG'!$G$3,$A7,0),\"\")","v":35},{"$f":"OFFSET('DATA CP ON REG'!$O$3,$A7,0)","v":15941},{"$f":"IF($A7=33,\"\",V28*1000/W28)","v":2.1955962612132236},{"$f":"IF($A7=33,\"\",IF(V28=0,\"\",Z28/V28-1))","v":0.4285714285714286},{"$f":"IF(A7<33,OFFSET('DATA CP ON REG'!$H$3,$A7,0),\"\")","v":50},{"$f":"OFFSET('DATA CP ON REG'!$P$3,$A7,0)","v":15941},{"$f":"IF($A7=33,\"\",Z28*1000/AA28)","v":3.1365660874474623},{"$f":"IF(AB28=\"*\",\"\",IF(A7<33,IF(RANK(AB28,'DATA CP ON REG'!$Y$4:$Y$35)<9,1,IF(RANK(AB28,'DATA CP ON REG'!$Y$4:$Y$35)<17,2,IF(RANK(AB28,'DATA CP ON REG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":1}]
[]
["Comparator authorities",{"$f":"SUM(B24:B28)","v":371},{"$f":"SUM(C24:C28)","v":108184},{"$f":"1000*B30/(SUMIF(B24,\">0\",C24)+SUMIF(B25,\">0\",C25)+SUMIF(B26,\">0\",C26)+SUMIF(B27,\">0\",C27)+SUMIF(B28,\">0\",C28))","v":3.4293426014937514},{"$f":"IF(B30=0,\"\",SUM(F24:F28)/SUM(B24:B28)-1)","v":-0.18598382749326148},{"$f":"SUM(F24:F28)","v":302},{"$f":"SUM(G24:G28)","v":107394},{"$f":"1000*F30/(SUMIF(F24,\">0\",G24)+SUMIF(F25,\">0\",G25)+SUMIF(F26,\">0\",G26)+SUMIF(F27,\">0\",G27)+SUMIF(F28,\">0\",G28))","v":2.8120751624858},{"$f":"IF(F30=0,\"\",SUM(J24:J28)/SUM(F24:F28)-1)","v":-4.635761589403975E-2},{"$f":"SUM(J24:J28)","v":288},{"$f":"SUM(K24:K28)","v":106831},{"$f":"1000*J30/(SUMIF(J24,\">0\",K24)+SUMIF(J25,\">0\",K25)+SUMIF(J26,\">0\",K26)+SUMIF(J27,\">0\",K27)+SUMIF(J28,\">0\",K28))","v":2.6958467111606184},{"$f":"IF(J30=0,\"\",SUM(N24:N28)/SUM(J24:J28)-1)","v":-0.10763888888888884},{"$f":"SUM(N24:N28)","v":257},{"$f":"SUM(O24:O28)","v":106255},{"$f":"1000*N30/(SUMIF(N24,\">0\",O24)+SUMIF(N25,\">0\",O25)+SUMIF(N26,\">0\",O26)+SUMIF(N27,\">0\",O27)+SUMIF(N28,\">0\",O28))","v":2.4187097077784574},{"$f":"IF(N30=0,\"\",SUM(R24:R28)/SUM(N24:N28)-1)","v":8.171206225680927E-2},{"$f":"SUM(R24:R28)","v":278},{"$f":"SUM(S24:S28)","v":104836},{"$f":"1000*R30/(SUMIF(R24,\">0\",S24)+SUMIF(R25,\">0\",S25)+SUMIF(R26,\">0\",S26)+SUMIF(R27,\">0\",S27)+SUMIF(R28,\">0\",S28))","v":2.6517608455110842},{"$f":"IF(R30=0,\"\",SUM(V24:V28)/SUM(R24:R28)-1)","v":-0.12949640287769781},{"$f":"SUM(V24:V28)","v":242},{"$f":"SUM(W24:W28)","v":103874},{"$f":"1000*V30/(SUMIF(V24,\">0\",W24)+SUMIF(V25,\">0\",W25)+SUMIF(V26,\">0\",W26)+SUMIF(V27,\">0\",W27)+SUMIF(V28,\">0\",W28))","v":2.3297456533877581},{"$f":"IF(V30=0,\"\",SUM(Z24:Z28)/SUM(V24:V28)-1)","v":8.2644628099173501E-2},{"$f":"SUM(Z24:Z28)","v":262},{"$f":"SUM(AA24:AA28)","v":103874},{"$f":"1000*Z30/(SUMIF(Z24,\">0\",AA24)+SUMIF(Z25,\">0\",AA25)+SUMIF(Z26,\">0\",AA26)+SUMIF(Z27,\">0\",AA27)+SUMIF(Z28,\">0\",AA28))","v":2.5222866164776558}]
[]
["Scotland [Note 1],[Note 2]",{"$f":"'DATA CP ON REG'!$B$36","v":2715},{"$f":"'DATA CP ON REG'!$J$36","v":915917},{"$f":"B32*1000/C32","v":2.9642423931426101},{"$f":"IF(B32=0,\"\",F32/B32-1)","v":-4.2357274401473299E-2},{"$f":"'DATA CP ON REG'!$C$36","v":2600},{"$f":"'DATA CP ON REG'!$K$36","v":917442},{"$f":"F32*1000/G32","v":2.833966615873265},{"$f":"IF(F32=0,\"\",J32/F32-1)","v":-2.6923076923076938E-2},{"$f":"'DATA CP ON REG'!$D$36","v":2530},{"$f":"'DATA CP ON REG'!$L$36","v":919502},{"$f":"J32*1000/K32","v":2.751489393171521},{"$f":"IF(J32=0,\"\",N32/J32-1)","v":1.9762845849802479E-2},{"$f":"'DATA CP ON REG'!$E$36","v":2580},{"$f":"'DATA CP ON REG'!$M$36","v":921397},{"$f":"N32*1000/O32","v":2.8000959412717861},{"$f":"IF(N32=0,\"\",R32/N32-1)","v":2.3643410852713265E-2},{"$f":"'DATA CP ON REG'!$F$36","v":2641},{"$f":"'DATA CP ON REG'!$N$36","v":916783},{"$f":"R32*1000/S32","v":2.8807253188595339},{"$f":"IF(R32=0,\"\",V32/R32-1)","v":-0.1976524043922756},{"$f":"'DATA CP ON REG'!$G$36","v":2119},{"$f":"'DATA CP ON REG'!$O$36","v":911522},{"$f":"V32*1000/W32","v":2.3246833318340094},{"$f":"IF(V32=0,\"\",Z32/V32-1)","v":-4.1529023124115105E-2},{"$f":"'DATA CP ON REG'!$H$36","v":2031},{"$f":"'DATA CP ON REG'!$P$36","v":911522},{"$f":"Z32*1000/AA32","v":2.2281415039900301}]
[]
["Notes"]
["[Note 1]",{"$f":"IF('DATA CP CON'!A38=\"\",\"\",'DATA CP CON'!A38)","v":"Figures for 2022 are provisional and may be revised with the publication of 2023 statistics."}]
["[Note 2]",{"$f":"IF('DATA CP CON'!A39=\"\",\"\",'DATA CP CON'!A39)","v":"Population figures source: NRS mid-year population estimates for 2016-2021"}]
["[Note 3]",{"$f":"IF('DATA CP CON'!A40=\"\",\"\",'DATA CP CON'!A40)","v":"Source: Scottish Government CP Returns"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U21-U30","v":0.43718871057000552},null,null,{"$f":"X21-X30","v":-0.84386155234763915},{"$f":"Y21-Y30","v":0.1232377248420029},null,null,{"$f":"AB21-AB30","v":-0.73048520051751242},{"$f":"IF(AB40<-0.5,\"less than\",IF(AB40>0.5,\"greater than\",\"similar to\"))","v":"less than"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U21-U32","v":0.50534471208458331},null,null,{"$f":"X21-X32","v":-0.83879923079389052},{"$f":"Y21-Y32","v":0.24741137606529151},null,null,{"$f":"AB21-AB32","v":-0.43634008802988666},{"$f":"IF(AB41<-0.5,\"less than\",IF(AB41>0.5,\"greater than\",\"similar to\"))","v":"similar to"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V21-R21","v":8},null,null,null,{"$f":"Z21-V21","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U43<0,\"a decrease of \",IF(U43>=0,\"an increase of \"))","v":"an increase of "},null,null,null,{"$f":"IF(Y43<0,\"a decrease of \",IF(Y43>=0,\"an increase of \"))","v":"an increase of "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U30<0,\"a decrease of \",IF(U30>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Y30<0,\"a decrease of \",IF(Y30>=0,\"an increase of \"))","v":"an increase of "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U32<0,\"a decrease of \",IF(U32>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Y32<0,\"a decrease of \",IF(Y32>=0,\"an increase of \"))","v":"a decrease of "}]

{"sheet":"CP de-registrations","index":4,"n_rows":48,"n_cols":29,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'DATA CP DEREG'!A1","v":"Child Protection: De-registrations: 31 July 2016-2022"}]
[]
[11,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":3},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":3}]
[12,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":16},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":16}]
[28,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":4},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":4}]
[7,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":26},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":26}]
[20,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":19},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":19}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(Z21=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Y21=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The number of de-registrations in \"&A21&\" in \"&Z19&\" is \"&ROUND(Z21,0)&\" (\"&Y45&ROUND((SQRT((Y21*100)^2)),1)&\"% from \"&ROUND(V21,0)&\" in \"&V19&\")\"))","v":"*  The number of de-registrations in Dumfries & Galloway in 2022 is 72 (an increase of 35.8% from 53 in 2021)"}]
[{"$f":"IF(Y30=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&Y47&ROUND(SQRT((Y30*100)^2),1)&\"%, while the estimated Scotland figures show \"&Y48&ROUND(SQRT((100*Y32)^2),1)&\"%\")","v":"*  The comparator authorities show an increase of 4.3%, while the estimated Scotland figures show a decrease of 15.4%"}]
[{"$f":"IF(AB21=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(AB30=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The rate (per 1,000 pop 0-15) is \"&ROUND(AB21,1)&\".  This is \"&AC41&\" the comparator average rate of \"&ROUND(AB30,1)&\", and \"&AC42&\" the estimated AJ7Scotland average rate of \"&ROUND(AB32,1)))","v":"*  The rate (per 1,000 pop 0-15) is 3.1.  This is greater than the comparator average rate of 2.3, and less than the estimated AJ7Scotland average rate of 3.7"}]
[]
[null,2016,null,2016,2016,2017,null,2017,2017,2018,null,2018,2018,2019,null,2019,2019,2020,null,2020,2020,2021,null,2021,2021,2022,null,2022,2022]
[null,"Number",{"$f":"'DATA CP DEREG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP DEREG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change","Number",{"$f":"'DATA CP DEREG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change",{"$f":"J20","v":"Number"},{"$f":"'DATA CP DEREG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change",{"$f":"N20","v":"Number"},{"$f":"'DATA CP DEREG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change",{"$f":"R20","v":"Number"},{"$f":"'DATA CP DEREG'!#REF!","v":{"$error":"#REF!"}},"Rate","% change",{"$f":"V20","v":"Number"},{"$f":"W20","v":{"$error":"#REF!"}},{"$f":"X20","v":"Rate"},"Quartile"]
[{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Dumfries & Galloway"},{"$f":"OFFSET('DATA CP DEREG'!B3,'Select an authority'!$A$1,0)","v":136},null,{"$f":"OFFSET('DATA CP DEREG'!$S$3,'Select an authority'!$A$1,0)","v":5.7592953332768699},{"$f":"IF(B21=0,\"\",F21/B21-1)","v":2.2058823529411686E-2},{"$f":"OFFSET('DATA CP DEREG'!C3,'Select an authority'!$A$1,0)","v":139},null,{"$f":"OFFSET('DATA CP DEREG'!$T$3,'Select an authority'!$A$1,0)","v":5.9181674969131857},{"$f":"IF(F21=0,\"\",J21/F21-1)","v":0.26618705035971213},{"$f":"OFFSET('DATA CP DEREG'!D3,'Select an authority'!$A$1,0)","v":176},null,{"$f":"OFFSET('DATA CP DEREG'!$U$3,'Select an authority'!$A$1,0)","v":7.5136612021857925},{"$f":"IF(J21=0,\"\",N21/J21-1)","v":0.23295454545454541},{"$f":"OFFSET('DATA CP DEREG'!E3,'Select an authority'!$A$1,0)","v":217},null,{"$f":"OFFSET('DATA CP DEREG'!$V$3,'Select an authority'!$A$1,0)","v":9.3361442154627206},{"$f":"IF(N21=0,\"\",R21/N21-1)","v":-0.84331797235023043},{"$f":"OFFSET('DATA CP DEREG'!F3,'Select an authority'!$A$1,0)","v":34},null,{"$f":"OFFSET('DATA CP DEREG'!$W$3,'Select an authority'!$A$1,0)","v":1.4750542299349241},{"$f":"IF(R21=0,\"\",V21/R21-1)","v":0.55882352941176472},{"$f":"OFFSET('DATA CP DEREG'!G3,'Select an authority'!$A$1,0)","v":53},null,{"$f":"OFFSET('DATA CP DEREG'!$X$3,'Select an authority'!$A$1,0)","v":2.3162310986801855},{"$f":"IF(V21=0,\"\",Z21/V21-1)","v":0.35849056603773577},{"$f":"OFFSET('DATA CP DEREG'!H3,'Select an authority'!$A$1,0)","v":72},null,{"$f":"OFFSET('DATA CP DEREG'!$Y$3,'Select an authority'!$A$1,0)","v":3.1465780963202516},{"$f":"IF(AB21=\"*\",\"\",IF(RANK(AB21,'DATA CP DEREG'!$Y$4:$Y$35)<9,1,IF(RANK(AB21,'DATA CP DEREG'!$Y$4:$Y$35)<17,2,IF(RANK(AB21,'DATA CP DEREG'!$Y$4:$Y$35)<25,3,4))))","v":3}]
[]
["Comparator Authorities:"]
[{"$f":"OFFSET('REF EA Name'!$B$2, A3,0)","v":"East Lothian"},{"$f":"IF($A3=33,\"\",OFFSET('DATA CP DEREG'!$B$3,$A3,0))","v":45},{"$f":"OFFSET('DATA CP DEREG'!$J$3,$A3,0)","v":18989},{"$f":"IF($A3=33,\"\",B24*1000/C24)","v":2.369793038074675},{"$f":"IF($A3=33,\"\",IF(B24=0,\"\",F24/B24-1))","v":0.42222222222222228},{"$f":"IF($A3=33,\"\",OFFSET('DATA CP DEREG'!$C$3,$A3,0))","v":64},{"$f":"OFFSET('DATA CP DEREG'!$K$3,$A3,0)","v":19051},{"$f":"IF($A3=33,\"\",F24*1000/G24)","v":3.359403705842213},{"$f":"IF($A3=33,\"\",IF(F24=0,\"\",J24/F24-1))","v":0.375},{"$f":"IF($A3=33,\"\",OFFSET('DATA CP DEREG'!$D$3,$A3,0))","v":88},{"$f":"OFFSET('DATA CP DEREG'!$L$3,$A3,0)","v":19350},{"$f":"IF($A3=33,\"\",J24*1000/K24)","v":4.5478036175710592},{"$f":"IF($A3=33,\"\",IF(J24=0,\"\",N24/J24-1))","v":-0.27272727272727271},{"$f":"IF($A3=33,\"\",OFFSET('DATA CP DEREG'!$E$3,$A3,0))","v":64},{"$f":"OFFSET('DATA CP DEREG'!$M$3,$A3,0)","v":19700},{"$f":"IF($A3=33,\"\",N24*1000/O24)","v":3.248730964467005},{"$f":"IF($A3=33,\"\",IF(N24=0,\"\",R24/N24-1))","v":1.5625E-2},{"$f":"IF($A3=33,\"\",OFFSET('DATA CP DEREG'!$F$3,$A3,0))","v":65},{"$f":"OFFSET('DATA CP DEREG'!$N$3,$A3,0)","v":19701},{"$f":"IF($A3=33,\"\",R24*1000/S24)","v":3.2993249073651083},{"$f":"IF($A3=33,\"\",V24/R24-1)","v":1.538461538461533E-2},{"$f":"IF($A3=33,\"\",OFFSET('DATA CP DEREG'!$G$3,$A3,0))","v":66},{"$f":"OFFSET('DATA CP DEREG'!$O$3,$A3,0)","v":19822},{"$f":"IF($A3=33,\"\",V24*1000/W24)","v":3.3296337402885681},{"$f":"IF($A3=33,\"\",IF(V24=0,\"\",Z24/V24-1))","v":-7.5757575757575801E-2},{"$f":"IF($A3=33,\"\",OFFSET('DATA CP DEREG'!$H$3,$A3,0))","v":61},{"$f":"OFFSET('DATA CP DEREG'!$P$3,$A3,0)","v":19822},{"$f":"IF($A3=33,\"\",Z24*1000/AA24)","v":3.0773887599636769},{"$f":"IF(AB24=\"*\",\"\",IF(A3<33,IF(RANK(AB24,'DATA CP DEREG'!$Y$4:$Y$35)<9,1,IF(RANK(AB24,'DATA CP DEREG'!$Y$4:$Y$35)<17,2,IF(RANK(AB24,'DATA CP DEREG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":3}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A4,0)","v":"East Renfrewshire"},{"$f":"IF($A4=33,\"\",OFFSET('DATA CP DEREG'!$B$3,$A4,0))","v":50},{"$f":"OFFSET('DATA CP DEREG'!$J$3,$A4,0)","v":18662},{"$f":"IF($A4=33,\"\",B25*1000/C25)","v":2.6792412388811488},{"$f":"IF($A4=33,\"\",IF(B25=0,\"\",F25/B25-1))","v":-0.48},{"$f":"IF($A4=33,\"\",OFFSET('DATA CP DEREG'!$C$3,$A4,0))","v":26},{"$f":"OFFSET('DATA CP DEREG'!$K$3,$A4,0)","v":19029},{"$f":"IF($A4=33,\"\",F25*1000/G25)","v":1.3663355930421988},{"$f":"IF($A4=33,\"\",IF(F25=0,\"\",J25/F25-1))","v":-0.15384615384615385},{"$f":"IF($A4=33,\"\",OFFSET('DATA CP DEREG'!$D$3,$A4,0))","v":22},{"$f":"OFFSET('DATA CP DEREG'!$L$3,$A4,0)","v":19322},{"$f":"IF($A4=33,\"\",J25*1000/K25)","v":1.1385984887692786},{"$f":"IF($A4=33,\"\",IF(J25=0,\"\",N25/J25-1))","v":-9.0909090909090939E-2},{"$f":"IF($A4=33,\"\",OFFSET('DATA CP DEREG'!$E$3,$A4,0))","v":20},{"$f":"OFFSET('DATA CP DEREG'!$M$3,$A4,0)","v":19525},{"$f":"IF($A4=33,\"\",N25*1000/O25)","v":1.0243277848911652},{"$f":"IF($A4=33,\"\",IF(N25=0,\"\",R25/N25-1))","v":0.25},{"$f":"IF($A4=33,\"\",OFFSET('DATA CP DEREG'!$F$3,$A4,0))","v":25},{"$f":"OFFSET('DATA CP DEREG'!$N$3,$A4,0)","v":19646},{"$f":"IF($A4=33,\"\",R25*1000/S25)","v":1.2725236689402424},{"$f":"IF($A4=33,\"\",V25/R25-1)","v":-0.24},{"$f":"IF($A4=33,\"\",OFFSET('DATA CP DEREG'!$G$3,$A4,0))","v":19},{"$f":"OFFSET('DATA CP DEREG'!$O$3,$A4,0)","v":19701},{"$f":"IF($A4=33,\"\",V25*1000/W25)","v":0.96441804984518553},{"$f":"IF($A4=33,\"\",IF(V25=0,\"\",Z25/V25-1))","v":0.21052631578947367},{"$f":"IF($A4=33,\"\",OFFSET('DATA CP DEREG'!$H$3,$A4,0))","v":23},{"$f":"OFFSET('DATA CP DEREG'!$P$3,$A4,0)","v":19701},{"$f":"IF($A4=33,\"\",Z25*1000/AA25)","v":1.1674534287599614},{"$f":"IF(AB25=\"*\",\"\",IF(A4<33,IF(RANK(AB25,'DATA CP DEREG'!$Y$4:$Y$35)<9,1,IF(RANK(AB25,'DATA CP DEREG'!$Y$4:$Y$35)<17,2,IF(RANK(AB25,'DATA CP DEREG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":4}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A5,0)","v":"South Ayrshire"},{"$f":"IF($A5=33,\"\",OFFSET('DATA CP DEREG'!$B$3,$A5,0))","v":72},{"$f":"OFFSET('DATA CP DEREG'!$J$3,$A5,0)","v":17760},{"$f":"IF($A5=33,\"\",B26*1000/C26)","v":4.0540540540540544},{"$f":"IF($A5=33,\"\",IF(B26=0,\"\",F26/B26-1))","v":0.51388888888888884},{"$f":"IF($A5=33,\"\",OFFSET('DATA CP DEREG'!$C$3,$A5,0))","v":109},{"$f":"OFFSET('DATA CP DEREG'!$K$3,$A5,0)","v":17716},{"$f":"IF($A5=33,\"\",F26*1000/G26)","v":6.1526303906073609},{"$f":"IF($A5=33,\"\",IF(F26=0,\"\",J26/F26-1))","v":-0.13761467889908252},{"$f":"IF($A5=33,\"\",OFFSET('DATA CP DEREG'!$D$3,$A5,0))","v":94},{"$f":"OFFSET('DATA CP DEREG'!$L$3,$A5,0)","v":17638},{"$f":"IF($A5=33,\"\",J26*1000/K26)","v":5.3294024265789774},{"$f":"IF($A5=33,\"\",IF(J26=0,\"\",N26/J26-1))","v":-0.1063829787234043},{"$f":"IF($A5=33,\"\",OFFSET('DATA CP DEREG'!$E$3,$A5,0))","v":84},{"$f":"OFFSET('DATA CP DEREG'!$M$3,$A5,0)","v":17608},{"$f":"IF($A5=33,\"\",N26*1000/O26)","v":4.770558836892322},{"$f":"IF($A5=33,\"\",IF(N26=0,\"\",R26/N26-1))","v":-0.34523809523809523},{"$f":"IF($A5=33,\"\",OFFSET('DATA CP DEREG'!$F$3,$A5,0))","v":55},{"$f":"OFFSET('DATA CP DEREG'!$N$3,$A5,0)","v":17418},{"$f":"IF($A5=33,\"\",R26*1000/S26)","v":3.1576530026409459},{"$f":"IF($A5=33,\"\",V26/R26-1)","v":-0.21818181818181814},{"$f":"IF($A5=33,\"\",OFFSET('DATA CP DEREG'!$G$3,$A5,0))","v":43},{"$f":"OFFSET('DATA CP DEREG'!$O$3,$A5,0)","v":17244},{"$f":"IF($A5=33,\"\",V26*1000/W26)","v":2.493620969612619},{"$f":"IF($A5=33,\"\",IF(V26=0,\"\",Z26/V26-1))","v":-0.27906976744186052},{"$f":"IF($A5=33,\"\",OFFSET('DATA CP DEREG'!$H$3,$A5,0))","v":31},{"$f":"OFFSET('DATA CP DEREG'!$P$3,$A5,0)","v":17244},{"$f":"IF($A5=33,\"\",Z26*1000/AA26)","v":1.7977267455346788},{"$f":"IF(AB26=\"*\",\"\",IF(A5<33,IF(RANK(AB26,'DATA CP DEREG'!$Y$4:$Y$35)<9,1,IF(RANK(AB26,'DATA CP DEREG'!$Y$4:$Y$35)<17,2,IF(RANK(AB26,'DATA CP DEREG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":4}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A6,0)","v":"Dumfries & Galloway"},{"$f":"IF($A6=33,\"\",OFFSET('DATA CP DEREG'!$B$3,$A6,0))","v":136},{"$f":"OFFSET('DATA CP DEREG'!$J$3,$A6,0)","v":23614},{"$f":"IF($A6=33,\"\",B27*1000/C27)","v":5.7592953332768699},{"$f":"IF($A6=33,\"\",IF(B27=0,\"\",F27/B27-1))","v":2.2058823529411686E-2},{"$f":"IF($A6=33,\"\",OFFSET('DATA CP DEREG'!$C$3,$A6,0))","v":139},{"$f":"OFFSET('DATA CP DEREG'!$K$3,$A6,0)","v":23487},{"$f":"IF($A6=33,\"\",F27*1000/G27)","v":5.9181674969131857},{"$f":"IF($A6=33,\"\",IF(F27=0,\"\",J27/F27-1))","v":0.26618705035971213},{"$f":"IF($A6=33,\"\",OFFSET('DATA CP DEREG'!$D$3,$A6,0))","v":176},{"$f":"OFFSET('DATA CP DEREG'!$L$3,$A6,0)","v":23424},{"$f":"IF($A6=33,\"\",J27*1000/K27)","v":7.5136612021857925},{"$f":"IF($A6=33,\"\",IF(J27=0,\"\",N27/J27-1))","v":0.23295454545454541},{"$f":"IF($A6=33,\"\",OFFSET('DATA CP DEREG'!$E$3,$A6,0))","v":217},{"$f":"OFFSET('DATA CP DEREG'!$M$3,$A6,0)","v":23243},{"$f":"IF($A6=33,\"\",N27*1000/O27)","v":9.3361442154627206},{"$f":"IF($A6=33,\"\",IF(N27=0,\"\",R27/N27-1))","v":-0.84331797235023043},{"$f":"IF($A6=33,\"\",OFFSET('DATA CP DEREG'!$F$3,$A6,0))","v":34},{"$f":"OFFSET('DATA CP DEREG'!$N$3,$A6,0)","v":23050},{"$f":"IF($A6=33,\"\",R27*1000/S27)","v":1.4750542299349241},{"$f":"IF($A6=33,\"\",V27/R27-1)","v":0.55882352941176472},{"$f":"IF($A6=33,\"\",OFFSET('DATA CP DEREG'!$G$3,$A6,0))","v":53},{"$f":"OFFSET('DATA CP DEREG'!$O$3,$A6,0)","v":22882},{"$f":"IF($A6=33,\"\",V27*1000/W27)","v":2.3162310986801855},{"$f":"IF($A6=33,\"\",IF(V27=0,\"\",Z27/V27-1))","v":0.35849056603773577},{"$f":"IF($A6=33,\"\",OFFSET('DATA CP DEREG'!$H$3,$A6,0))","v":72},{"$f":"OFFSET('DATA CP DEREG'!$P$3,$A6,0)","v":22882},{"$f":"IF($A6=33,\"\",Z27*1000/AA27)","v":3.1465780963202516},{"$f":"IF(AB27=\"*\",\"\",IF(A6<33,IF(RANK(AB27,'DATA CP DEREG'!$Y$4:$Y$35)<9,1,IF(RANK(AB27,'DATA CP DEREG'!$Y$4:$Y$35)<17,2,IF(RANK(AB27,'DATA CP DEREG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":3}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A7,0)","v":"Na h-Eileanan Siar"},{"$f":"IF($A7=33,\"\",OFFSET('DATA CP DEREG'!$B$3,$A7,0))","v":4},{"$f":"OFFSET('DATA CP DEREG'!$J$3,$A7,0)","v":4307},{"$f":"IF($A7=33,\"\",B28*1000/C28)","v":0.92872068725330859},{"$f":"IF($A7=33,\"\",IF(B28=0,\"\",F28/B28-1))","v":0.5},{"$f":"IF($A7=33,\"\",OFFSET('DATA CP DEREG'!$C$3,$A7,0))","v":6},{"$f":"OFFSET('DATA CP DEREG'!$K$3,$A7,0)","v":4367},{"$f":"IF($A7=33,\"\",F28*1000/G28)","v":1.3739409205404167},{"$f":"IF($A7=33,\"\",IF(F28=0,\"\",J28/F28-1))","v":0.83333333333333326},{"$f":"IF($A7=33,\"\",OFFSET('DATA CP DEREG'!$D$3,$A7,0))","v":11},{"$f":"OFFSET('DATA CP DEREG'!$L$3,$A7,0)","v":4328},{"$f":"IF($A7=33,\"\",J28*1000/K28)","v":2.5415896487985212},{"$f":"IF($A7=33,\"\",IF(J28=0,\"\",N28/J28-1))","v":-0.45454545454545459},{"$f":"IF($A7=33,\"\",OFFSET('DATA CP DEREG'!$E$3,$A7,0))","v":6},{"$f":"OFFSET('DATA CP DEREG'!$M$3,$A7,0)","v":4254},{"$f":"IF($A7=33,\"\",N28*1000/O28)","v":1.4104372355430184},{"$f":"IF($A7=33,\"\",IF(N28=0,\"\",R28/N28-1))","v":0.66666666666666674},{"$f":"IF($A7=33,\"\",OFFSET('DATA CP DEREG'!$F$3,$A7,0))","v":10},{"$f":"OFFSET('DATA CP DEREG'!$N$3,$A7,0)","v":4135},{"$f":"IF($A7=33,\"\",R28*1000/S28)","v":2.418379685610641},{"$f":"IF($A7=33,\"\",V28/R28-1)","v":-0.30000000000000004},{"$f":"IF($A7=33,\"\",OFFSET('DATA CP DEREG'!$G$3,$A7,0))","v":7},{"$f":"OFFSET('DATA CP DEREG'!$O$3,$A7,0)","v":4060},{"$f":"IF($A7=33,\"\",V28*1000/W28)","v":1.7241379310344827},{"$f":"IF($A7=33,\"\",IF(V28=0,\"\",Z28/V28-1))","v":0.28571428571428581},{"$f":"IF($A7=33,\"\",OFFSET('DATA CP DEREG'!$H$3,$A7,0))","v":9},{"$f":"OFFSET('DATA CP DEREG'!$P$3,$A7,0)","v":4060},{"$f":"IF($A7=33,\"\",Z28*1000/AA28)","v":2.2167487684729066},{"$f":"IF(AB28=\"*\",\"\",IF(A7<33,IF(RANK(AB28,'DATA CP DEREG'!$Y$4:$Y$35)<9,1,IF(RANK(AB28,'DATA CP DEREG'!$Y$4:$Y$35)<17,2,IF(RANK(AB28,'DATA CP DEREG'!$Y$4:$Y$35)<25,3,4))),\"\"))","v":4}]
[]
["Comparator authorities",{"$f":"SUM(B24:B28)","v":307},{"$f":"SUM(C24:C28)","v":83332},{"$f":"1000*B30/(SUMIF(B24,\">0\",C24)+SUMIF(B25,\">0\",C25)+SUMIF(B26,\">0\",C26)+SUMIF(B27,\">0\",C27)+SUMIF(B28,\">0\",C28))","v":3.6840589449431191},{"$f":"IF(B30=0,\"\",SUM(F24:F28)/SUM(B24:B28)-1)","v":0.12052117263843654},{"$f":"SUM(F24:F28)","v":344},{"$f":"SUM(G24:G28)","v":83650},{"$f":"1000*F30/(SUMIF(F24,\">0\",G24)+SUMIF(F25,\">0\",G25)+SUMIF(F26,\">0\",G26)+SUMIF(F27,\">0\",G27)+SUMIF(F28,\">0\",G28))","v":4.1123729826658693},{"$f":"IF(F30=0,\"\",SUM(J24:J28)/SUM(F24:F28)-1)","v":0.13662790697674421},{"$f":"SUM(J24:J28)","v":391},{"$f":"SUM(K24:K28)","v":84062},{"$f":"1000*J30/(SUMIF(J24,\">0\",K24)+SUMIF(J25,\">0\",K25)+SUMIF(J26,\">0\",K26)+SUMIF(J27,\">0\",K27)+SUMIF(J28,\">0\",K28))","v":4.6513287811377317},{"$f":"IF(J30=0,\"\",SUM(N24:N28)/SUM(J24:J28)-1)","v":0},{"$f":"SUM(N24:N28)","v":391},{"$f":"SUM(O24:O28)","v":84330},{"$f":"1000*N30/(SUMIF(N24,\">0\",O24)+SUMIF(N25,\">0\",O25)+SUMIF(N26,\">0\",O26)+SUMIF(N27,\">0\",O27)+SUMIF(N28,\">0\",O28))","v":4.6365468990869205},{"$f":"IF(N30=0,\"\",SUM(R24:R28)/SUM(N24:N28)-1)","v":-0.51662404092071612},{"$f":"SUM(R24:R28)","v":189},{"$f":"SUM(S24:S28)","v":83950},{"$f":"1000*R30/(SUMIF(R24,\">0\",S24)+SUMIF(R25,\">0\",S25)+SUMIF(R26,\">0\",S26)+SUMIF(R27,\">0\",S27)+SUMIF(R28,\">0\",S28))","v":2.2513400833829662},{"$f":"IF(R30=0,\"\",SUM(V24:V28)/SUM(R24:R28)-1)","v":-5.2910052910053462E-3},{"$f":"SUM(V24:V28)","v":188},{"$f":"SUM(W24:W28)","v":83709},{"$f":"1000*V30/(SUMIF(V24,\">0\",W24)+SUMIF(V25,\">0\",W25)+SUMIF(V26,\">0\",W26)+SUMIF(V27,\">0\",W27)+SUMIF(V28,\">0\",W28))","v":2.2458755928275336},{"$f":"IF(V30=0,\"\",SUM(Z24:Z28)/SUM(V24:V28)-1)","v":4.2553191489361764E-2},{"$f":"SUM(Z24:Z28)","v":196},{"$f":"SUM(AA24:AA28)","v":83709},{"$f":"1000*Z30/(SUMIF(Z24,\">0\",AA24)+SUMIF(Z25,\">0\",AA25)+SUMIF(Z26,\">0\",AA26)+SUMIF(Z27,\">0\",AA27)+SUMIF(Z28,\">0\",AA28))","v":2.3414447669904073}]
[]
["Scotland [Note 1],[Note 2]",{"$f":"'DATA CP DEREG'!$B$36","v":4299},{"$f":"'DATA CP DEREG'!$J$36","v":915917},{"$f":"B32*1000/C32","v":4.6936567396390725},{"$f":"IF(B32=0,\"\",F32/B32-1)","v":2.4889509188183334E-2},{"$f":"'DATA CP DEREG'!$C$36","v":4406},{"$f":"'DATA CP DEREG'!$K$36","v":917442},{"$f":"F32*1000/G32","v":4.8024834267452325},{"$f":"IF(F32=0,\"\",J32/F32-1)","v":-2.0426690876078069E-2},{"$f":"'DATA CP DEREG'!$D$36","v":4316},{"$f":"'DATA CP DEREG'!$L$36","v":919502},{"$f":"J32*1000/K32","v":4.6938451466119702},{"$f":"IF(J32=0,\"\",N32/J32-1)","v":-1.6450417052826682E-2},{"$f":"'DATA CP DEREG'!$E$36","v":4245},{"$f":"'DATA CP DEREG'!$M$36","v":921397},{"$f":"N32*1000/O32","v":4.6071346010460204},{"$f":"IF(N32=0,\"\",R32/N32-1)","v":-8.08009422850412E-2},{"$f":"'DATA CP DEREG'!$F$36","v":3902},{"$f":"'DATA CP DEREG'!$N$36","v":916783},{"$f":"R32*1000/S32","v":4.2561871238886413},{"$f":"IF(R32=0,\"\",V32/R32-1)","v":1.8708354689902507E-2},{"$f":"'DATA CP DEREG'!$G$36","v":3975},{"$f":"'DATA CP DEREG'!$O$36","v":911522},{"$f":"V32*1000/W32","v":4.3608382463615802},{"$f":"IF(V32=0,\"\",Z32/V32-1)","v":-0.1537106918238994},{"$f":"'DATA CP DEREG'!$H$36","v":3364},{"$f":"'DATA CP DEREG'!$P$36","v":911522},{"$f":"Z32*1000/AA32","v":3.6905307825812215}]
[]
["Notes"]
["[Note 1]",{"$f":"IF('DATA CP CON'!A38=\"\",\"\",'DATA CP CON'!A38)","v":"Figures for 2022 are provisional and may be revised with the publication of 2023 statistics."}]
["[Note 2]",{"$f":"IF('DATA CP CON'!A39=\"\",\"\",'DATA CP CON'!A39)","v":"Population figures source: NRS mid-year population estimates for 2016-2021"}]
["[Note 3]",{"$f":"IF('DATA CP CON'!A40=\"\",\"\",'DATA CP CON'!A40)","v":"Source: Scottish Government CP Returns"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q21-Q30","v":-0.32669393142951431},null,null,{"$f":"T21-T30","v":-0.77628585344804213},{"$f":"U21-U30","v":0.56411453470277007},null,null,{"$f":"X21-X30","v":7.0355505852651934E-2},{"$f":"Y21-Y30","v":0.31593737454837401},null,null,{"$f":"AB21-AB30","v":0.80513332932984438},{"$f":"IF(AB41<-0.5,\"less than\",IF(AB41>0.5,\"greater than\",\"similar to\"))","v":"greater than"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q21-Q32","v":-0.76251703006518923},null,null,{"$f":"T21-T32","v":-2.7811328939537172},{"$f":"U21-U32","v":0.54011517472186221},null,null,{"$f":"X21-X32","v":-2.0446071476813947},{"$f":"Y21-Y32","v":0.51220125786163517},null,null,{"$f":"AB21-AB32","v":-0.54395268626096982},{"$f":"IF(AB42<-0.5,\"less than\",IF(AB42>0.5,\"greater than\",\"similar to\"))","v":"less than"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R21-N21","v":-183},null,null,null,{"$f":"V21-R21","v":19},null,null,null,{"$f":"Z21-V21","v":19}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q44<0,\"a decrease of \",IF(Q44>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(U44<0,\"a decrease of \",IF(U44>=0,\"an increase of \"))","v":"an increase of "},null,null,null,{"$f":"IF(Y44<0,\"a decrease of \",IF(Y44>=0,\"an increase of \"))","v":"an increase of "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q30<0,\"a decrease of \",IF(Q30>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(U30<0,\"a decrease of \",IF(U30>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Y30<0,\"a decrease of \",IF(Y30>=0,\"an increase of \"))","v":"an increase of "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q32<0,\"a decrease of \",IF(Q32>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(U32<0,\"a decrease of \",IF(U32>=0,\"an increase of \"))","v":"an increase of "},null,null,null,{"$f":"IF(Y32<0,\"a decrease of \",IF(Y32>=0,\"an increase of \"))","v":"a decrease of "}]

{"sheet":"DATA CP CON","index":5,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Child Protection: Case conferences: 31 July 2016-2022"]
["Number of child protection case conferences: 31 July 2016-2022",null,null,null,null,null,null,null,null,"Population Aged 0-15",null,null,null,null,null,null,null,"Number of child protection referrals that resulted in a case conference per 1,000 children: year ended 31 July 2016-2022"]
["Council",2016,2017,2018,2019,2020,2021,2022,null,2016,2017,2018,2019,2020,2021,2022,null,"Council",{"$f":"B3","v":2016},{"$f":"C3","v":2017},2018,2019,2020,2021,2022]
["Aberdeen City",196,205,176,208,195,160,175,null,34187,34495,34833,35423,35789,35860,35860,null,"Aberdeen City",{"$f":"IFERROR(B4*1000/J4,\"*\")","v":5.7331734284962117},{"$f":"IFERROR(C4*1000/K4,\"*\")","v":5.9428902739527469},{"$f":"IFERROR(D4*1000/L4,\"*\")","v":5.0526799299514824},{"$f":"IFERROR(E4*1000/M4,\"*\")","v":5.8718911441718653},{"$f":"IFERROR(F4*1000/N4,\"*\")","v":5.448601525608427},{"$f":"IFERROR(G4*1000/O4,\"*\")","v":4.4617958728388176},{"$f":"IFERROR(H4*1000/P4,\"*\")","v":4.880089235917457}]
["Aberdeenshire",117,134,127,154,165,117,126,null,48871,48888,49033,49016,48674,48578,48578,null,"Aberdeenshire",2.3940578257044054,2.7409589265259369,2.5900923867599372,3.141831238779174,3.3899001520318857,2.4084976738441268,2.5937667256782904]
["Angus",181,171,202,143,130,111,98,null,19445,19288,19253,19145,18908,18639,18639,null,"Angus",9.3083054769863711,8.8656159270012438,10.491871396665454,7.4693131365891876,6.8753966574994712,5.955255110252696,5.257792800042921]
["Argyll & Bute",73,92,80,68,75,54,38,null,13238,13163,13024,12906,12577,12441,12441,null,"Argyll & Bute",5.5144281613536785,6.9892881561953963,6.1425061425061429,5.268867193553386,5.9632662797169438,4.3404870991077891,3.054416847520296]
["City of Edinburgh",482,368,312,201,199,200,175,null,77364,78052,78501,79067,79150,78826,78826,null,"City of Edinburgh",6.2302879892456442,4.7148055142725367,3.9744716627813657,2.5421477987023664,2.5142135186355024,2.537233907593941,2.2200796691446985]
["Clackmannanshire",26,59,76,71,111,100,37,null,9024,9020,8980,8946,8897,8877,8877,null,"Clackmannanshire",2.8812056737588652,6.541019955654102,8.4632516703786198,7.9365079365079367,12.476115544565584,11.265067027148811,4.1680748000450603]
["Dumfries and Galloway",149,227,284,209,69,93,90,null,23614,23487,23424,23243,23050,22882,22882,null,"Dumfries and Galloway",6.3098162107224525,9.6649210201388005,12.12431693989071,8.9919545669663989,2.9934924078091107,4.0643300410803249,3.9332226204003145]
["Dundee City",174,153,157,180,157,147,146,null,23849,23998,24016,24044,23958,23704,23704,null,"Dundee City",7.2959033921757728,6.3755312942745226,6.5373084610259831,7.4862751622026282,6.5531346523082057,6.2014849814377317,6.1592980087748908]
["East Ayrshire",196,230,289,257,234,182,134,null,21259,21164,21119,21053,20869,20792,20792,null,"East Ayrshire",9.2196246295686528,10.867510867510868,13.684360054926843,12.207286372488481,11.21280368009967,8.7533666794921121,6.4447864563293571]
["East Dunbartonshire",91,88,116,103,87,88,84,null,18810,19061,19224,19398,19500,19528,19528,null,"East Dunbartonshire",4.8378522062732587,4.6167567283983004,6.0341240116521018,5.3098257552324979,4.4615384615384617,4.5063498566161408,4.3015157722244979]
["East Lothian",79,85,85,92,74,58,77,null,18989,19051,19350,19700,19701,19822,19822,null,"East Lothian",4.1603033335088737,4.4617080468216894,4.3927648578811374,4.6700507614213196,3.7561545099233542,2.9260417717687419,3.8845726970033296]
["East Renfrewshire",38,50,26,54,20,18,25,null,18662,19029,19322,19525,19646,19701,19701,null,"East Renfrewshire",2.0362233415496731,2.6275684481580743,1.3456163958182383,2.765685019206146,1.0180189351521938,0.91365920511649157,1.2689711182173493]
["Falkirk",137,150,107,132,192,157,190,null,28359,28329,28230,28112,27886,27564,27564,null,"Falkirk",4.8309178743961354,5.2949274594938052,3.7902940134608571,4.6955036994877632,6.885175356809869,5.6958351472935718,6.8930489043680163]
["Fife",347,340,379,349,328,292,272,null,64372,64333,64473,64552,64152,63680,63680,null,"Fife",5.3905424718821848,5.2850014766915887,5.8784297302746884,5.4064939893419259,5.1128569647088167,4.5854271356783922,4.2713567839195976]
["Glasgow City",971,769,668,709,669,558,460,null,98487,99137,99938,100666,100478,99881,99881,null,"Glasgow City",9.8591692304568124,7.7569424130244009,6.6841441693850188,7.0430930006158983,6.6581739286211903,5.5866481112523907,4.6054805218209669]
["Highland",194,163,175,177,175,124,140,null,39972,39555,39335,39036,38490,38130,38130,null,"Highland",4.8533973781647157,4.1208443938819368,4.4489640269480111,4.5342760528742696,4.5466354897375938,3.2520325203252032,3.6716496197220039]
["Inverclyde",106,95,70,92,125,116,76,null,12851,12701,12628,12603,12413,12197,12197,null,"Inverclyde",8.248385339662283,7.4797260058263131,5.5432372505543235,7.2998492422439103,10.070087811165713,9.5105353775518573,6.2310404197753542]
["Midlothian",126,155,131,135,114,103,99,null,16884,17229,17590,17953,18089,18281,18281,null,"Midlothian",7.4626865671641793,8.9964594578907651,7.447413303013076,7.5196346014593658,6.3021725910774506,5.6342650839669606,5.415458672939117]
["Moray",97,114,91,113,50,55,60,null,16527,16362,16173,16145,16037,15941,15941,null,"Moray",5.8691837599080294,6.9673634030069671,5.6266617201508691,6.9990709197894088,3.1177901103697701,3.4502226961922089,3.763879304936955]
["Na h-Eileanan Siar",9,10,26,19,26,42,27,null,4307,4367,4328,4254,4135,4060,4060,null,"Na h-Eileanan Siar",2.0896215463199441,2.2899015342340281,6.0073937153419594,4.4663845792195582,6.2877871825876666,10.344827586206897,6.6502463054187189]
["North Ayrshire",175,154,300,285,298,285,220,null,23128,22901,22780,22468,22280,21891,21891,null,"North Ayrshire",7.566585956416465,6.7245971791624823,13.169446883230904,12.684707139042194,13.375224416517055,13.019048924215431,10.049792152025947]
["North Lanarkshire",323,331,286,361,286,273,207,null,63299,63011,62955,62836,62278,61606,61606,null,"North Lanarkshire",5.1027662364334354,5.2530510545777718,4.542927487888174,5.7451142657075565,4.5923118918398149,4.4313865532577994,3.3600623315910787]
["Orkney Islands",16,17,18,17,15,7,18,null,3516,3545,3544,3582,3571,3553,3553,null,"Orkney Islands",4.5506257110352673,4.795486600846262,5.0790067720090297,4.7459519821328868,4.2005040604872583,1.9701660568533634,5.0661412890515054]
["Perth and Kinross",123,111,118,162,130,111,95,null,24514,24453,24425,24421,24244,24218,24218,null,"Perth and Kinross",5.0175409969813165,4.5393203287940134,4.8311156601842375,6.6336349862822983,5.3621514601550899,4.583367743001074,3.9227021223883063]
["Renfrewshire",221,270,213,249,225,181,201,null,29954,30039,30171,30267,30182,29784,29784,null,"Renfrewshire",7.3779795686719636,8.9883151902526723,7.0597593715819826,8.2267816433739718,7.4547743688291037,6.0770883695944127,6.7485898468976631]
["Scottish Borders",91,59,88,68,44,61,64,null,19002,19026,19046,19023,18824,18723,18723,null,"Scottish Borders",4.7889695821492477,3.1010196573110482,4.6203927333823378,3.5746201966041107,2.3374415639609012,3.2580248891737433,3.4182556214281901]
["Shetland Islands",28,17,15,24,15,22,18,null,4233,4233,4205,4198,4158,4104,4104,null,"Shetland Islands",6.6146940703992438,4.0160642570281126,3.56718192627824,5.7170080990948069,3.6075036075036073,5.3606237816764128,4.3859649122807021]
["South Ayrshire",130,147,109,128,64,39,52,null,17760,17716,17638,17608,17418,17244,17244,null,"South Ayrshire",7.3198198198198199,8.2975841047640557,6.1798389840117931,7.2694229895502041,3.6743598576185557,2.2616562282533055,3.015541637671074]
["South Lanarkshire",419,384,440,322,406,351,322,null,54876,55151,55260,55649,55550,55700,55700,null,"South Lanarkshire",7.6353961659013043,6.9627023988685606,7.9623597538906985,5.7862674980682494,7.3087308730873088,6.3016157989228008,5.7809694793536801]
["Stirling",73,61,100,63,60,79,57,null,15493,15425,15514,15417,15153,14948,14948,null,"Stirling",4.7118053314400052,3.9546191247974067,6.445790898543251,4.0863981319322829,3.9596119580281131,5.284987958255285,3.8132191597538134]
["West Dunbartonshire",159,251,221,163,153,162,125,null,15764,15790,15705,15647,15484,15234,15234,null,"West Dunbartonshire",10.08627251966506,15.896136795440151,14.071951607768227,10.417332395986451,9.8811676569361921,10.634107916502559,8.2053301824865432]
["West Lothian",160,193,170,220,209,190,227,null,35307,35443,35485,35494,35242,35133,35133,null,"West Lothian",4.5316792703996374,5.4453629771746188,4.7907566577427083,6.1982306868766548,5.9304239259973892,5.4080209489653601,6.4611618706059826]
["Scotland",5707,5653,5655,5528,5100,4536,4135,null,915917,917442,919502,921397,916783,911522,911522,null,"Scotland",6.2309139365248161,6.1616974152044488,6.1500681890849611,5.9995854121513315,5.562930377199403,4.9762923988669501,4.5363688424415427]
["Notes"]
["Figures for 2022 are provisional and may be revised with the publication of 2023 statistics."]
["Population figures source: NRS mid-year population estimates for 2016-2021"]
["Source: Scottish Government CP Returns"]
["Initial, pre-birth and transfer in case conferences"]

{"sheet":"DATA CP REG","index":6,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Child Protection: Registrations: 31 July 2016-2022"]
["Number of registrations following a case conference: 31 July 2016-2022",null,null,null,null,null,null,null,null,"Population Aged 0-15",null,null,null,null,null,null,null,"Number of registrations following a case conference per 1,000 children: 31 July 2016-2022"]
["Council",2016,2017,2018,2019,2020,2021,2022,null,{"$f":"'DATA CP CON'!J3","v":2016},{"$f":"'DATA CP CON'!K3","v":2017},{"$f":"'DATA CP CON'!L3","v":2018},{"$f":"'DATA CP CON'!M3","v":2019},{"$f":"'DATA CP CON'!N3","v":2020},{"$f":"'DATA CP CON'!O3","v":2021},{"$f":"'DATA CP CON'!P3","v":2022},null,"Council",{"$f":"'DATA CP CON'!S3","v":2016},{"$f":"'DATA CP CON'!T3","v":2017},{"$f":"'DATA CP CON'!U3","v":2018},{"$f":"'DATA CP CON'!V3","v":2019},{"$f":"'DATA CP CON'!W3","v":2020},{"$f":"'DATA CP CON'!X3","v":2021},{"$f":"'DATA CP CON'!Y3","v":2022}]
["Aberdeen City",156,164,150,162,168,141,156,null,{"$f":"'DATA CP CON'!J4","v":34187},{"$f":"'DATA CP CON'!K4","v":34495},{"$f":"'DATA CP CON'!L4","v":34833},{"$f":"'DATA CP CON'!M4","v":35423},{"$f":"'DATA CP CON'!N4","v":35789},{"$f":"'DATA CP CON'!O4","v":35860},{"$f":"'DATA CP CON'!P4","v":35860},null,"Aberdeen City",{"$f":"IFERROR(B4*1000/J4,\"*\")","v":4.5631380349255561},{"$f":"IFERROR(C4*1000/K4,\"*\")","v":4.7543122191621974},{"$f":"IFERROR(D4*1000/L4,\"*\")","v":4.3062613039359228},{"$f":"IFERROR(E4*1000/M4,\"*\")","v":4.5732998334415491},{"$f":"IFERROR(F4*1000/N4,\"*\")","v":4.6941797759087986},{"$f":"IFERROR(G4*1000/O4,\"*\")","v":3.931957612939208},{"$f":"IFERROR(H4*1000/P4,\"*\")","v":4.3502509760178469}]
["Aberdeenshire",109,124,116,142,154,107,120,null,{"$f":"'DATA CP CON'!J5","v":48871},{"$f":"'DATA CP CON'!K5","v":48888},{"$f":"'DATA CP CON'!L5","v":49033},{"$f":"'DATA CP CON'!M5","v":49016},{"$f":"'DATA CP CON'!N5","v":48674},{"$f":"'DATA CP CON'!O5","v":48578},{"$f":"'DATA CP CON'!P5","v":48578},null,"Aberdeenshire",2.2303615641177794,2.5364097529045981,2.3657536760956908,2.8970132201730046,3.1639068085630933,2.2026431718061672,2.4702540244555147]
["Angus",151,126,154,98,108,95,94,null,{"$f":"'DATA CP CON'!J6","v":19445},{"$f":"'DATA CP CON'!K6","v":19288},{"$f":"'DATA CP CON'!L6","v":19253},{"$f":"'DATA CP CON'!M6","v":19145},{"$f":"'DATA CP CON'!N6","v":18908},{"$f":"'DATA CP CON'!O6","v":18639},{"$f":"'DATA CP CON'!P6","v":18639},null,"Angus",7.7654924145024431,6.5325591041061797,7.9987534410221786,5.1188299817184646,5.7118679923841764,5.0968399592252807,5.0431890122860672]
["Argyll & Bute",64,73,57,56,67,48,30,null,{"$f":"'DATA CP CON'!J7","v":13238},{"$f":"'DATA CP CON'!K7","v":13163},{"$f":"'DATA CP CON'!L7","v":13024},{"$f":"'DATA CP CON'!M7","v":12906},{"$f":"'DATA CP CON'!N7","v":12577},{"$f":"'DATA CP CON'!O7","v":12441},{"$f":"'DATA CP CON'!P7","v":12441},null,"Argyll & Bute",4.8345671551593901,5.5458482108941727,4.3765356265356266,4.3390671005733763,5.3271845432138027,3.8582107547624789,2.4113817217265492]
["City of Edinburgh",411,302,285,180,178,166,162,null,{"$f":"'DATA CP CON'!J8","v":77364},{"$f":"'DATA CP CON'!K8","v":78052},{"$f":"'DATA CP CON'!L8","v":78501},{"$f":"'DATA CP CON'!M8","v":79067},{"$f":"'DATA CP CON'!N8","v":79150},{"$f":"'DATA CP CON'!O8","v":78826},{"$f":"'DATA CP CON'!P8","v":78826},null,"City of Edinburgh",5.3125484721575926,3.8692153948649617,3.6305269996560554,2.2765502674946565,2.2488945041061275,2.105904143302971,2.0551594651510925]
["Clackmannanshire",25,46,58,58,73,80,30,null,{"$f":"'DATA CP CON'!J9","v":9024},{"$f":"'DATA CP CON'!K9","v":9020},{"$f":"'DATA CP CON'!L9","v":8980},{"$f":"'DATA CP CON'!M9","v":8946},{"$f":"'DATA CP CON'!N9","v":8897},{"$f":"'DATA CP CON'!O9","v":8877},{"$f":"'DATA CP CON'!P9","v":8877},null,"Clackmannanshire",2.770390070921986,5.0997782705099777,6.4587973273942092,6.4833445115135255,8.2050129257052937,9.0120536217190494,3.3795201081446433]
["Dumfries and Galloway",109,156,191,142,42,61,79,null,{"$f":"'DATA CP CON'!J10","v":23614},{"$f":"'DATA CP CON'!K10","v":23487},{"$f":"'DATA CP CON'!L10","v":23424},{"$f":"'DATA CP CON'!M10","v":23243},{"$f":"'DATA CP CON'!N10","v":23050},{"$f":"'DATA CP CON'!O10","v":22882},{"$f":"'DATA CP CON'!P10","v":22882},null,"Dumfries and Galloway",4.6159058185821973,6.6419721548090429,8.1540300546448083,6.1093662608097059,1.8221258134490239,2.6658508871602131,3.4524954112402764]
["Dundee City",151,144,142,168,156,145,106,null,{"$f":"'DATA CP CON'!J11","v":23849},{"$f":"'DATA CP CON'!K11","v":23998},{"$f":"'DATA CP CON'!L11","v":24016},{"$f":"'DATA CP CON'!M11","v":24044},{"$f":"'DATA CP CON'!N11","v":23958},{"$f":"'DATA CP CON'!O11","v":23704},{"$f":"'DATA CP CON'!P11","v":23704},null,"Dundee City",6.3315023690720782,6.0005000416701391,5.9127248500999334,6.9871901513891199,6.5113949411470076,6.1171110361120489,4.4718191022612217]
["East Ayrshire",140,177,158,191,155,126,96,null,{"$f":"'DATA CP CON'!J12","v":21259},{"$f":"'DATA CP CON'!K12","v":21164},{"$f":"'DATA CP CON'!L12","v":21119},{"$f":"'DATA CP CON'!M12","v":21053},{"$f":"'DATA CP CON'!N12","v":20869},{"$f":"'DATA CP CON'!O12","v":20792},{"$f":"'DATA CP CON'!P12","v":20792},null,"East Ayrshire",6.5854461639776094,8.3632583632583639,7.4814148397177895,9.0723412340284053,7.4272844889549088,6.0600230858022313,4.61716044632551]
["East Dunbartonshire",78,77,101,82,47,64,56,null,{"$f":"'DATA CP CON'!J13","v":18810},{"$f":"'DATA CP CON'!K13","v":19061},{"$f":"'DATA CP CON'!L13","v":19224},{"$f":"'DATA CP CON'!M13","v":19398},{"$f":"'DATA CP CON'!N13","v":19500},{"$f":"'DATA CP CON'!O13","v":19528},{"$f":"'DATA CP CON'!P13","v":19528},null,"East Dunbartonshire",4.1467304625199359,4.0396621373485129,5.2538493549729504,4.2272399216414067,2.4102564102564101,3.2773453502662844,2.8676771814829989]
["East Lothian",66,62,72,83,64,50,73,null,{"$f":"'DATA CP CON'!J14","v":18989},{"$f":"'DATA CP CON'!K14","v":19051},{"$f":"'DATA CP CON'!L14","v":19350},{"$f":"'DATA CP CON'!M14","v":19700},{"$f":"'DATA CP CON'!N14","v":19701},{"$f":"'DATA CP CON'!O14","v":19822},{"$f":"'DATA CP CON'!P14","v":19822},null,"East Lothian",3.4756964558428565,3.2544223400346439,3.7209302325581395,4.2131979695431472,3.2485660626364146,2.5224498032489153,3.6827767127434163]
["East Renfrewshire",29,34,11,26,19,18,25,null,{"$f":"'DATA CP CON'!J15","v":18662},{"$f":"'DATA CP CON'!K15","v":19029},{"$f":"'DATA CP CON'!L15","v":19322},{"$f":"'DATA CP CON'!M15","v":19525},{"$f":"'DATA CP CON'!N15","v":19646},{"$f":"'DATA CP CON'!O15","v":19701},{"$f":"'DATA CP CON'!P15","v":19701},null,"East Renfrewshire",1.5539599185510664,1.7867465447474906,0.5692992443846393,1.3316261203585147,0.96711798839458418,0.91365920511649157,1.2689711182173493]
["Falkirk",116,127,99,127,158,124,142,null,{"$f":"'DATA CP CON'!J16","v":28359},{"$f":"'DATA CP CON'!K16","v":28329},{"$f":"'DATA CP CON'!L16","v":28230},{"$f":"'DATA CP CON'!M16","v":28112},{"$f":"'DATA CP CON'!N16","v":27886},{"$f":"'DATA CP CON'!O16","v":27564},{"$f":"'DATA CP CON'!P16","v":27564},null,"Falkirk",4.0904122148171655,4.4830385823714218,3.5069075451647183,4.5176437108708027,5.6659255540414541,4.4986213902191263,5.1516470758960962]
["Fife",294,314,325,318,292,258,246,null,{"$f":"'DATA CP CON'!J17","v":64372},{"$f":"'DATA CP CON'!K17","v":64333},{"$f":"'DATA CP CON'!L17","v":64473},{"$f":"'DATA CP CON'!M17","v":64552},{"$f":"'DATA CP CON'!N17","v":64152},{"$f":"'DATA CP CON'!O17","v":63680},{"$f":"'DATA CP CON'!P17","v":63680},null,"Fife",4.5672031317964334,4.8808543049445854,5.0408698214756562,4.9262609988846204,4.5516897368749216,4.0515075376884422,3.863065326633166]
["Glasgow City",599,488,411,534,463,355,328,null,{"$f":"'DATA CP CON'!J18","v":98487},{"$f":"'DATA CP CON'!K18","v":99137},{"$f":"'DATA CP CON'!L18","v":99938},{"$f":"'DATA CP CON'!M18","v":100666},{"$f":"'DATA CP CON'!N18","v":100478},{"$f":"'DATA CP CON'!O18","v":99881},{"$f":"'DATA CP CON'!P18","v":99881},null,"Glasgow City",6.0820209773878782,4.9224810111260178,4.1125497808641356,5.3046708918602112,4.6079738848305105,3.5542295331444418,3.2839078503419068]
["Highland",168,138,147,151,164,105,136,null,{"$f":"'DATA CP CON'!J19","v":39972},{"$f":"'DATA CP CON'!K19","v":39555},{"$f":"'DATA CP CON'!L19","v":39335},{"$f":"'DATA CP CON'!M19","v":39036},{"$f":"'DATA CP CON'!N19","v":38490},{"$f":"'DATA CP CON'!O19","v":38130},{"$f":"'DATA CP CON'!P19","v":38130},null,"Highland",4.2029420594416091,3.4888130451270385,3.737129782636329,3.8682242032995182,4.2608469732398024,2.7537372147915029,3.5667453448728037]
["Inverclyde",57,47,50,64,98,61,68,null,{"$f":"'DATA CP CON'!J20","v":12851},{"$f":"'DATA CP CON'!K20","v":12701},{"$f":"'DATA CP CON'!L20","v":12628},{"$f":"'DATA CP CON'!M20","v":12603},{"$f":"'DATA CP CON'!N20","v":12413},{"$f":"'DATA CP CON'!O20","v":12197},{"$f":"'DATA CP CON'!P20","v":12197},null,"Inverclyde",4.4354524939693407,3.700496023935123,3.959455178967374,5.078155994604459,7.8949488439539195,5.0012298106091659,5.5751414282200544]
["Midlothian",99,129,100,112,96,83,58,null,{"$f":"'DATA CP CON'!J21","v":16884},{"$f":"'DATA CP CON'!K21","v":17229},{"$f":"'DATA CP CON'!L21","v":17590},{"$f":"'DATA CP CON'!M21","v":17953},{"$f":"'DATA CP CON'!N21","v":18089},{"$f":"'DATA CP CON'!O21","v":18281},{"$f":"'DATA CP CON'!P21","v":18281},null,"Midlothian",5.863539445628998,7.4873759359219916,5.6850483229107445,6.2385116693588811,5.3070927082757473,4.5402330288277444,3.172692959903725]
["Moray",87,98,86,95,40,46,51,null,{"$f":"'DATA CP CON'!J22","v":16527},{"$f":"'DATA CP CON'!K22","v":16362},{"$f":"'DATA CP CON'!L22","v":16173},{"$f":"'DATA CP CON'!M22","v":16145},{"$f":"'DATA CP CON'!N22","v":16037},{"$f":"'DATA CP CON'!O22","v":15941},{"$f":"'DATA CP CON'!P22","v":15941},null,"Moray",5.2641132691958612,5.9894878376726561,5.3175044827799418,5.8841746670795914,2.4942320882958158,2.8856408004516654,3.1992974091964119]
["Na h-Eileanan Siar",5,6,12,6,9,9,15,null,{"$f":"'DATA CP CON'!J23","v":4307},{"$f":"'DATA CP CON'!K23","v":4367},{"$f":"'DATA CP CON'!L23","v":4328},{"$f":"'DATA CP CON'!M23","v":4254},{"$f":"'DATA CP CON'!N23","v":4135},{"$f":"'DATA CP CON'!O23","v":4060},{"$f":"'DATA CP CON'!P23","v":4060},null,"Na h-Eileanan Siar",1.1609008590666356,1.3739409205404167,2.7726432532347505,1.4104372355430184,2.1765417170495769,2.2167487684729066,3.6945812807881775]
["North Ayrshire",150,139,272,237,246,242,199,null,{"$f":"'DATA CP CON'!J24","v":23128},{"$f":"'DATA CP CON'!K24","v":22901},{"$f":"'DATA CP CON'!L24","v":22780},{"$f":"'DATA CP CON'!M24","v":22468},{"$f":"'DATA CP CON'!N24","v":22280},{"$f":"'DATA CP CON'!O24","v":21891},{"$f":"'DATA CP CON'!P24","v":21891},null,"North Ayrshire",6.4856451054998274,6.0696039474258763,11.940298507462687,10.548335410361403,11.041292639138241,11.054771367228541,9.0904938102416519]
["North Lanarkshire",240,275,219,282,218,207,169,null,{"$f":"'DATA CP CON'!J25","v":63299},{"$f":"'DATA CP CON'!K25","v":63011},{"$f":"'DATA CP CON'!L25","v":62955},{"$f":"'DATA CP CON'!M25","v":62836},{"$f":"'DATA CP CON'!N25","v":62278},{"$f":"'DATA CP CON'!O25","v":61606},{"$f":"'DATA CP CON'!P25","v":61606},null,"North Lanarkshire",3.7915290920867628,4.3643173414165783,3.4786752442220634,4.4878731937106116,3.5004335399338449,3.3600623315910787,2.743239294873876]
["Orkney Islands",5,16,10,7,12,7,17,null,{"$f":"'DATA CP CON'!J26","v":3516},{"$f":"'DATA CP CON'!K26","v":3545},{"$f":"'DATA CP CON'!L26","v":3544},{"$f":"'DATA CP CON'!M26","v":3582},{"$f":"'DATA CP CON'!N26","v":3571},{"$f":"'DATA CP CON'!O26","v":3553},{"$f":"'DATA CP CON'!P26","v":3553},null,"Orkney Islands",1.422070534698521,4.5133991537376588,2.8216704288939054,1.9542155220547179,3.3604032483898068,1.9701660568533634,4.7846889952153111]
["Perth and Kinross",100,103,109,142,119,89,81,null,{"$f":"'DATA CP CON'!J27","v":24514},{"$f":"'DATA CP CON'!K27","v":24453},{"$f":"'DATA CP CON'!L27","v":24425},{"$f":"'DATA CP CON'!M27","v":24421},{"$f":"'DATA CP CON'!N27","v":24244},{"$f":"'DATA CP CON'!O27","v":24218},{"$f":"'DATA CP CON'!P27","v":24218},null,"Perth and Kinross",4.0793016235620465,4.2121621068989494,4.4626407369498464,5.8146677040252239,4.9084309519881204,3.6749525146585182,3.3446197043521346]
["Renfrewshire",133,194,128,160,136,113,121,null,{"$f":"'DATA CP CON'!J28","v":29954},{"$f":"'DATA CP CON'!K28","v":30039},{"$f":"'DATA CP CON'!L28","v":30171},{"$f":"'DATA CP CON'!M28","v":30267},{"$f":"'DATA CP CON'!N28","v":30182},{"$f":"'DATA CP CON'!O28","v":29784},{"$f":"'DATA CP CON'!P28","v":29784},null,"Renfrewshire",4.4401415503772448,6.4582709144778452,4.2424845049882336,5.2862853933326726,4.5059969518255913,3.7939833467633628,4.0625839376846633]
["Scottish Borders",83,51,75,60,37,59,59,null,{"$f":"'DATA CP CON'!J29","v":19002},{"$f":"'DATA CP CON'!K29","v":19026},{"$f":"'DATA CP CON'!L29","v":19046},{"$f":"'DATA CP CON'!M29","v":19023},{"$f":"'DATA CP CON'!N29","v":18824},{"$f":"'DATA CP CON'!O29","v":18723},{"$f":"'DATA CP CON'!P29","v":18723},null,"Scottish Borders",4.3679612672350281,2.6805424156417534,3.937834715950856,3.1540766440624508,1.965575860603485,3.1512044010041125,3.1512044010041125]
["Shetland Islands",26,13,13,22,11,19,18,null,{"$f":"'DATA CP CON'!J30","v":4233},{"$f":"'DATA CP CON'!K30","v":4233},{"$f":"'DATA CP CON'!L30","v":4205},{"$f":"'DATA CP CON'!M30","v":4198},{"$f":"'DATA CP CON'!N30","v":4158},{"$f":"'DATA CP CON'!O30","v":4104},{"$f":"'DATA CP CON'!P30","v":4104},null,"Shetland Islands",6.1422159225135839,3.071107961256792,3.0915576694411415,5.2405907575035728,2.6455026455026456,4.6296296296296298,4.3859649122807021]
["South Ayrshire",81,99,78,77,47,33,34,null,{"$f":"'DATA CP CON'!J31","v":17760},{"$f":"'DATA CP CON'!K31","v":17716},{"$f":"'DATA CP CON'!L31","v":17638},{"$f":"'DATA CP CON'!M31","v":17608},{"$f":"'DATA CP CON'!N31","v":17418},{"$f":"'DATA CP CON'!O31","v":17244},{"$f":"'DATA CP CON'!P31","v":17244},null,"South Ayrshire",4.5608108108108105,5.588168886881915,4.4222700986506407,4.373012267151295,2.6983580204386266,1.9137091162143354,1.9717003015541639]
["South Lanarkshire",273,251,295,220,280,239,225,null,{"$f":"'DATA CP CON'!J32","v":54876},{"$f":"'DATA CP CON'!K32","v":55151},{"$f":"'DATA CP CON'!L32","v":55260},{"$f":"'DATA CP CON'!M32","v":55649},{"$f":"'DATA CP CON'!N32","v":55550},{"$f":"'DATA CP CON'!O32","v":55700},{"$f":"'DATA CP CON'!P32","v":55700},null,"South Lanarkshire",4.9748523944893943,4.5511414117604394,5.3384002895403544,3.9533504645186794,5.0405040504050405,4.290843806104129,4.0394973070017954]
["Stirling",71,55,88,58,58,76,51,null,{"$f":"'DATA CP CON'!J33","v":15493},{"$f":"'DATA CP CON'!K33","v":15425},{"$f":"'DATA CP CON'!L33","v":15514},{"$f":"'DATA CP CON'!M33","v":15417},{"$f":"'DATA CP CON'!N33","v":15153},{"$f":"'DATA CP CON'!O33","v":14948},{"$f":"'DATA CP CON'!P33","v":14948},null,"Stirling",4.582714774414252,3.5656401944894651,5.6722959907180615,3.7620808198741651,3.8276248927605097,5.0842922130050843,3.411827669253412]
["West Dunbartonshire",77,128,95,71,88,80,69,null,{"$f":"'DATA CP CON'!J34","v":15764},{"$f":"'DATA CP CON'!K34","v":15790},{"$f":"'DATA CP CON'!L34","v":15705},{"$f":"'DATA CP CON'!M34","v":15647},{"$f":"'DATA CP CON'!N34","v":15484},{"$f":"'DATA CP CON'!O34","v":15234},{"$f":"'DATA CP CON'!P34","v":15234},null,"West Dunbartonshire",4.8845470692717585,8.106396453451552,6.0490289716650745,4.5376110436505401,5.6832859726168952,5.2514113167913878,4.5293422607325722]
["West Lothian",120,137,139,164,164,153,172,null,{"$f":"'DATA CP CON'!J35","v":35307},{"$f":"'DATA CP CON'!K35","v":35443},{"$f":"'DATA CP CON'!L35","v":35485},{"$f":"'DATA CP CON'!M35","v":35494},{"$f":"'DATA CP CON'!N35","v":35242},{"$f":"'DATA CP CON'!O35","v":35133},{"$f":"'DATA CP CON'!P35","v":35133},null,"West Lothian",3.398759452799728,3.8653612843156617,3.9171480907425673,4.6204992393080522,4.6535383916917317,4.3548800273247377,4.8956821222212739]
["Scotland",4273,4293,4246,4295,3967,3459,3286,null,{"$f":"SUM(J4:J35)","v":915917},{"$f":"SUM(K4:K35)","v":917442},{"$f":"SUM(L4:L35)","v":919502},{"$f":"SUM(M4:M35)","v":921397},{"$f":"SUM(N4:N35)","v":916783},{"$f":"SUM(O4:O35)","v":911522},{"$f":"SUM(P4:P35)","v":911522},null,"Scotland",4.665269887992034,4.6793148776707412,4.6177169815835093,4.6614000262644657,4.3270872169313783,3.7947520740036995,3.6049596169922395]
["Notes"]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Population figures source: NRS mid-year population estimates for 2016-2021."]
["Source: Scottish Government CP Returns"]
["Figures for 2022 are provisional and may be revised with the publication of 2023 statistics."]

{"sheet":"DATA CP ON REG","index":7,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Child Protection: On Child Protection Register:  as at 31 July 2016-2022"]
["Number of children on child protection registers: as at 31 July 2016-2022",null,null,null,null,null,null,null,null,"Population Aged 0-15",null,null,null,null,null,null,null,"Number of children on child protection registers per 1,000 children: as at 31 July 2016-2022"]
["Council",2016,2017,2018,2019,2020,2021,2022,null,{"$f":"'DATA CP CON'!J3","v":2016},{"$f":"'DATA CP CON'!K3","v":2017},{"$f":"'DATA CP CON'!L3","v":2018},{"$f":"'DATA CP CON'!M3","v":2019},{"$f":"'DATA CP CON'!N3","v":2020},{"$f":"'DATA CP CON'!O3","v":2021},{"$f":"'DATA CP CON'!P3","v":2022},null,"Council",2016,2017,2018,2019,2020,2021,2022]
["Aberdeen City",118,80,68,119,142,83,115,null,{"$f":"'DATA CP CON'!J4","v":34187},{"$f":"'DATA CP CON'!K4","v":34495},{"$f":"'DATA CP CON'!L4","v":34833},{"$f":"'DATA CP CON'!M4","v":35423},{"$f":"'DATA CP CON'!N4","v":35789},{"$f":"'DATA CP CON'!O4","v":35860},{"$f":"'DATA CP CON'!P4","v":35860},null,"Aberdeen City",{"$f":"IFERROR(B4*1000/J4,\"*\")","v":3.4516044110334336},{"$f":"IFERROR(C4*1000/K4,\"*\")","v":2.3191766922742425},{"$f":"IFERROR(D4*1000/L4,\"*\")","v":1.9521717911176184},{"$f":"IFERROR(E4*1000/M4,\"*\")","v":3.359399260367558},{"$f":"IFERROR(F4*1000/N4,\"*\")","v":3.9676995724943418},{"$f":"IFERROR(G4*1000/O4,\"*\")","v":2.3145566090351366},{"$f":"IFERROR(H4*1000/P4,\"*\")","v":3.2069157836029003}]
["Aberdeenshire",64,77,77,103,111,73,89,null,{"$f":"'DATA CP CON'!J5","v":48871},{"$f":"'DATA CP CON'!K5","v":48888},{"$f":"'DATA CP CON'!L5","v":49033},{"$f":"'DATA CP CON'!M5","v":49016},{"$f":"'DATA CP CON'!N5","v":48674},{"$f":"'DATA CP CON'!O5","v":48578},{"$f":"'DATA CP CON'!P5","v":48578},null,"Aberdeenshire",1.3095700926930081,1.5750286368843069,1.5703709746497256,2.1013546597029542,2.2804782840941775,1.5027378648771048,1.8321050681378401]
["Angus",96,51,64,45,35,45,59,null,{"$f":"'DATA CP CON'!J6","v":19445},{"$f":"'DATA CP CON'!K6","v":19288},{"$f":"'DATA CP CON'!L6","v":19253},{"$f":"'DATA CP CON'!M6","v":19145},{"$f":"'DATA CP CON'!N6","v":18908},{"$f":"'DATA CP CON'!O6","v":18639},{"$f":"'DATA CP CON'!P6","v":18639},null,"Angus",4.9370017999485727,2.6441310659477395,3.3241572741910352,2.3504831548707235,1.8510683308652423,2.4142926122646067,3.1654058694135951]
["Argyll and Bute",40,31,31,28,49,32,21,null,{"$f":"'DATA CP CON'!J7","v":13238},{"$f":"'DATA CP CON'!K7","v":13163},{"$f":"'DATA CP CON'!L7","v":13024},{"$f":"'DATA CP CON'!M7","v":12906},{"$f":"'DATA CP CON'!N7","v":12577},{"$f":"'DATA CP CON'!O7","v":12441},{"$f":"'DATA CP CON'!P7","v":12441},null,"Argyll & Bute",3.0216044719746185,2.3550862265441008,2.38022113022113,2.1695335502866882,3.8960006360817365,2.5721405031749858,1.6879672052085846]
["City of Edinburgh",287,235,189,122,95,97,104,null,{"$f":"'DATA CP CON'!J8","v":77364},{"$f":"'DATA CP CON'!K8","v":78052},{"$f":"'DATA CP CON'!L8","v":78501},{"$f":"'DATA CP CON'!M8","v":79067},{"$f":"'DATA CP CON'!N8","v":79150},{"$f":"'DATA CP CON'!O8","v":78826},{"$f":"'DATA CP CON'!P8","v":78826},null,"City of Edinburgh",3.709735794426348,3.0108133039512119,2.4076126418771735,1.5429951813019338,1.2002526847757422,1.2305584451830613,1.3193616319488493]
["Clackmannanshire",18,26,37,24,43,41,15,null,{"$f":"'DATA CP CON'!J9","v":9024},{"$f":"'DATA CP CON'!K9","v":9020},{"$f":"'DATA CP CON'!L9","v":8980},{"$f":"'DATA CP CON'!M9","v":8946},{"$f":"'DATA CP CON'!N9","v":8897},{"$f":"'DATA CP CON'!O9","v":8877},{"$f":"'DATA CP CON'!P9","v":8877},null,"Clackmannanshire",1.9946808510638299,2.8824833702882482,4.1202672605790642,2.6827632461435278,4.8330898055524338,4.6186774811310123,1.6897600540723217]
["Dumfries and Galloway",61,78,93,18,26,34,41,null,{"$f":"'DATA CP CON'!J10","v":23614},{"$f":"'DATA CP CON'!K10","v":23487},{"$f":"'DATA CP CON'!L10","v":23424},{"$f":"'DATA CP CON'!M10","v":23243},{"$f":"'DATA CP CON'!N10","v":23050},{"$f":"'DATA CP CON'!O10","v":22882},{"$f":"'DATA CP CON'!P10","v":22882},null,"Dumfries and Galloway",2.5832133480138899,3.3209860774045215,3.9702868852459017,0.77442670911672329,1.1279826464208242,1.4858841010401189,1.7918014159601434]
["Dundee City",79,69,75,90,102,84,61,null,{"$f":"'DATA CP CON'!J11","v":23849},{"$f":"'DATA CP CON'!K11","v":23998},{"$f":"'DATA CP CON'!L11","v":24016},{"$f":"'DATA CP CON'!M11","v":24044},{"$f":"'DATA CP CON'!N11","v":23958},{"$f":"'DATA CP CON'!O11","v":23704},{"$f":"'DATA CP CON'!P11","v":23704},null,"Dundee City",3.3125078619648622,2.8752396033002752,3.1229180546302464,3.7431375811013141,4.2574505384422743,3.5437057036787039,2.5734053324333446]
["East Ayrshire",39,96,107,100,75,69,80,null,{"$f":"'DATA CP CON'!J12","v":21259},{"$f":"'DATA CP CON'!K12","v":21164},{"$f":"'DATA CP CON'!L12","v":21119},{"$f":"'DATA CP CON'!M12","v":21053},{"$f":"'DATA CP CON'!N12","v":20869},{"$f":"'DATA CP CON'!O12","v":20792},{"$f":"'DATA CP CON'!P12","v":20792},null,"East Ayrshire",1.8345171456794769,4.536004536004536,5.0665277712012875,4.7499168764546624,3.5938473333652787,3.3185840707964602,3.8476337052712584]
["East Dunbartonshire",38,42,57,55,37,23,35,null,{"$f":"'DATA CP CON'!J13","v":18810},{"$f":"'DATA CP CON'!K13","v":19061},{"$f":"'DATA CP CON'!L13","v":19224},{"$f":"'DATA CP CON'!M13","v":19398},{"$f":"'DATA CP CON'!N13","v":19500},{"$f":"'DATA CP CON'!O13","v":19528},{"$f":"'DATA CP CON'!P13","v":19528},null,"East Dunbartonshire",2.0202020202020203,2.2034520749173705,2.9650436953807739,2.835343849881431,1.8974358974358974,1.177795985251946,1.7922982384268742]
["East Lothian",47,45,29,48,45,29,41,null,{"$f":"'DATA CP CON'!J14","v":18989},{"$f":"'DATA CP CON'!K14","v":19051},{"$f":"'DATA CP CON'!L14","v":19350},{"$f":"'DATA CP CON'!M14","v":19700},{"$f":"'DATA CP CON'!N14","v":19701},{"$f":"'DATA CP CON'!O14","v":19822},{"$f":"'DATA CP CON'!P14","v":19822},null,"East Lothian",2.475117173100216,2.3620807306703062,1.4987080103359174,2.436548223350254,2.284148012791229,1.463020885884371,2.0684088386641104]
["East Renfrewshire",12,20,9,15,9,8,10,null,{"$f":"'DATA CP CON'!J15","v":18662},{"$f":"'DATA CP CON'!K15","v":19029},{"$f":"'DATA CP CON'!L15","v":19322},{"$f":"'DATA CP CON'!M15","v":19525},{"$f":"'DATA CP CON'!N15","v":19646},{"$f":"'DATA CP CON'!O15","v":19701},{"$f":"'DATA CP CON'!P15","v":19701},null,"East Renfrewshire",0.64301789733147574,1.0510273792632299,0.46579029086015938,0.76824583866837393,0.45810852081848724,0.40607075782955182,0.50758844728693975]
["Falkirk",82,80,88,124,142,101,75,null,{"$f":"'DATA CP CON'!J16","v":28359},{"$f":"'DATA CP CON'!K16","v":28329},{"$f":"'DATA CP CON'!L16","v":28230},{"$f":"'DATA CP CON'!M16","v":28112},{"$f":"'DATA CP CON'!N16","v":27886},{"$f":"'DATA CP CON'!O16","v":27564},{"$f":"'DATA CP CON'!P16","v":27564},null,"Falkirk",2.8914982897845483,2.8239613117300295,3.1172511512575274,4.4109277177006261,5.0921609409739652,3.664199680742998,2.7209403569873749]
["Fife",157,172,170,205,147,152,136,null,{"$f":"'DATA CP CON'!J17","v":64372},{"$f":"'DATA CP CON'!K17","v":64333},{"$f":"'DATA CP CON'!L17","v":64473},{"$f":"'DATA CP CON'!M17","v":64552},{"$f":"'DATA CP CON'!N17","v":64152},{"$f":"'DATA CP CON'!O17","v":63680},{"$f":"'DATA CP CON'!P17","v":63680},null,"Fife",2.4389486111974152,2.6735889823263332,2.636762675848805,3.1757342917337961,2.2914328469884024,2.386934673366834,2.1356783919597988]
["Glasgow City",511,405,308,415,413,280,270,null,{"$f":"'DATA CP CON'!J18","v":98487},{"$f":"'DATA CP CON'!K18","v":99137},{"$f":"'DATA CP CON'!L18","v":99938},{"$f":"'DATA CP CON'!M18","v":100666},{"$f":"'DATA CP CON'!N18","v":100478},{"$f":"'DATA CP CON'!O18","v":99881},{"$f":"'DATA CP CON'!P18","v":99881},null,"Glasgow City",5.1885020358016796,4.0852557571845018,3.0819107846865057,4.1225438579063436,4.1103525149784028,2.803335969804067,2.7032168280253503]
["Highland",104,102,81,91,129,96,93,null,{"$f":"'DATA CP CON'!J19","v":39972},{"$f":"'DATA CP CON'!K19","v":39555},{"$f":"'DATA CP CON'!L19","v":39335},{"$f":"'DATA CP CON'!M19","v":39036},{"$f":"'DATA CP CON'!N19","v":38490},{"$f":"'DATA CP CON'!O19","v":38130},{"$f":"'DATA CP CON'!P19","v":38130},null,"Highland",2.6018212748924245,2.578687902919985,2.0592347781873648,2.3311814735116303,3.3515198752922837,2.5177025963808024,2.4390243902439024]
["Inverclyde",40,33,31,47,61,26,44,null,{"$f":"'DATA CP CON'!J20","v":12851},{"$f":"'DATA CP CON'!K20","v":12701},{"$f":"'DATA CP CON'!L20","v":12628},{"$f":"'DATA CP CON'!M20","v":12603},{"$f":"'DATA CP CON'!N20","v":12413},{"$f":"'DATA CP CON'!O20","v":12197},{"$f":"'DATA CP CON'!P20","v":12197},null,"Inverclyde",3.1125982413819937,2.5982206125501928,2.4548622109597718,3.7292708085376498,4.9142028518488683,2.1316717225547266,3.6074444535541526]
["Midlothian",51,64,45,49,49,38,24,null,{"$f":"'DATA CP CON'!J21","v":16884},{"$f":"'DATA CP CON'!K21","v":17229},{"$f":"'DATA CP CON'!L21","v":17590},{"$f":"'DATA CP CON'!M21","v":17953},{"$f":"'DATA CP CON'!N21","v":18089},{"$f":"'DATA CP CON'!O21","v":18281},{"$f":"'DATA CP CON'!P21","v":18281},null,"Midlothian",3.0206112295664536,3.7146671310000579,2.5582717453098351,2.7293488553445107,2.7088285698490795,2.0786609047645097,1.3128384661670587]
["Moray",64,79,62,47,31,35,50,null,{"$f":"'DATA CP CON'!J22","v":16527},{"$f":"'DATA CP CON'!K22","v":16362},{"$f":"'DATA CP CON'!L22","v":16173},{"$f":"'DATA CP CON'!M22","v":16145},{"$f":"'DATA CP CON'!N22","v":16037},{"$f":"'DATA CP CON'!O22","v":15941},{"$f":"'DATA CP CON'!P22","v":15941},null,"Moray",3.872451140557875,4.8282606038381619,3.8335497433994932,2.9111179931867452,1.9330298684292573,2.1955962612132236,3.1365660874474623]
["Na h-Eileanan Siar",3,3,4,4,3,5,11,null,{"$f":"'DATA CP CON'!J23","v":4307},{"$f":"'DATA CP CON'!K23","v":4367},{"$f":"'DATA CP CON'!L23","v":4328},{"$f":"'DATA CP CON'!M23","v":4254},{"$f":"'DATA CP CON'!N23","v":4135},{"$f":"'DATA CP CON'!O23","v":4060},{"$f":"'DATA CP CON'!P23","v":4060},null,"Na h-Eileanan Siar",0.69654051543998141,0.68697046027020836,0.92421441774491686,0.94029149036201221,0.7255139056831923,1.2315270935960592,2.7093596059113301]
["North Ayrshire",68,60,154,104,136,115,93,null,{"$f":"'DATA CP CON'!J24","v":23128},{"$f":"'DATA CP CON'!K24","v":22901},{"$f":"'DATA CP CON'!L24","v":22780},{"$f":"'DATA CP CON'!M24","v":22468},{"$f":"'DATA CP CON'!N24","v":22280},{"$f":"'DATA CP CON'!O24","v":21891},{"$f":"'DATA CP CON'!P24","v":21891},null,"North Ayrshire",2.9401591144932548,2.6199729269464216,6.7603160667251974,4.6288054121417126,6.1041292639138245,5.2533004431044725,4.2483212279018776]
["North Lanarkshire",115,131,95,162,118,117,84,null,{"$f":"'DATA CP CON'!J25","v":63299},{"$f":"'DATA CP CON'!K25","v":63011},{"$f":"'DATA CP CON'!L25","v":62955},{"$f":"'DATA CP CON'!M25","v":62836},{"$f":"'DATA CP CON'!N25","v":62278},{"$f":"'DATA CP CON'!O25","v":61606},{"$f":"'DATA CP CON'!P25","v":61606},null,"North Lanarkshire",1.8167743566249073,2.0790020790020791,1.5090143753474705,2.5781399197912025,1.894730081248595,1.899165665681914,1.3635035548485537]
["Orkney Islands",1,3,5,3,9,3,2,null,{"$f":"'DATA CP CON'!J26","v":3516},{"$f":"'DATA CP CON'!K26","v":3545},{"$f":"'DATA CP CON'!L26","v":3544},{"$f":"'DATA CP CON'!M26","v":3582},{"$f":"'DATA CP CON'!N26","v":3571},{"$f":"'DATA CP CON'!O26","v":3553},{"$f":"'DATA CP CON'!P26","v":3553},null,"Orkney Islands",0.2844141069397042,0.84626234132581102,1.4108352144469527,0.83752093802345062,2.5203024362923552,0.84435688150858434,0.56290458767238949]
["Perth and Kinross",73,81,75,78,95,66,51,null,{"$f":"'DATA CP CON'!J27","v":24514},{"$f":"'DATA CP CON'!K27","v":24453},{"$f":"'DATA CP CON'!L27","v":24425},{"$f":"'DATA CP CON'!M27","v":24421},{"$f":"'DATA CP CON'!N27","v":24244},{"$f":"'DATA CP CON'!O27","v":24218},{"$f":"'DATA CP CON'!P27","v":24218},null,"Perth and Kinross",2.9778901852002937,3.3124769966875229,3.0706243602865917,3.193972400802588,3.9184952978056424,2.7252456850276654,2.1058716657031962]
["Renfrewshire",72,107,103,83,98,71,78,null,{"$f":"'DATA CP CON'!J28","v":29954},{"$f":"'DATA CP CON'!K28","v":30039},{"$f":"'DATA CP CON'!L28","v":30171},{"$f":"'DATA CP CON'!M28","v":30267},{"$f":"'DATA CP CON'!N28","v":30182},{"$f":"'DATA CP CON'!O28","v":29784},{"$f":"'DATA CP CON'!P28","v":29784},null,"Renfrewshire",2.4036856513320424,3.5620360198408734,3.4138742501077193,2.7422605477913238,3.2469683917566763,2.3838302444265378,2.6188557614826751]
["Scottish Borders",67,39,50,46,34,34,39,null,{"$f":"'DATA CP CON'!J29","v":19002},{"$f":"'DATA CP CON'!K29","v":19026},{"$f":"'DATA CP CON'!L29","v":19046},{"$f":"'DATA CP CON'!M29","v":19023},{"$f":"'DATA CP CON'!N29","v":18824},{"$f":"'DATA CP CON'!O29","v":18723},{"$f":"'DATA CP CON'!P29","v":18723},null,"Scottish Borders",3.5259446374065888,2.0498265531378115,2.6252231439672373,2.4181254271145454,1.8062048448788781,1.8159482988837259,2.082999519307803]
["Shetland Islands",17,3,8,12,9,8,14,null,{"$f":"'DATA CP CON'!J30","v":4233},{"$f":"'DATA CP CON'!K30","v":4233},{"$f":"'DATA CP CON'!L30","v":4205},{"$f":"'DATA CP CON'!M30","v":4198},{"$f":"'DATA CP CON'!N30","v":4158},{"$f":"'DATA CP CON'!O30","v":4104},{"$f":"'DATA CP CON'!P30","v":4104},null,"Shetland Islands",4.0160642570281126,0.7087172218284904,1.9024970273483948,2.8585040495474034,2.1645021645021645,1.9493177387914229,3.4113060428849904]
["South Ayrshire",70,60,44,37,29,19,22,null,{"$f":"'DATA CP CON'!J31","v":17760},{"$f":"'DATA CP CON'!K31","v":17716},{"$f":"'DATA CP CON'!L31","v":17638},{"$f":"'DATA CP CON'!M31","v":17608},{"$f":"'DATA CP CON'!N31","v":17418},{"$f":"'DATA CP CON'!O31","v":17244},{"$f":"'DATA CP CON'!P31","v":17244},null,"South Ayrshire",3.9414414414414414,3.3867690223526754,2.4946139018029254,2.101317582916856,1.6649443104834081,1.1018325214567386,1.2758060774762237]
["South Lanarkshire",162,140,180,116,157,119,106,null,{"$f":"'DATA CP CON'!J32","v":54876},{"$f":"'DATA CP CON'!K32","v":55151},{"$f":"'DATA CP CON'!L32","v":55260},{"$f":"'DATA CP CON'!M32","v":55649},{"$f":"'DATA CP CON'!N32","v":55550},{"$f":"'DATA CP CON'!O32","v":55700},{"$f":"'DATA CP CON'!P32","v":55700},null,"South Lanarkshire",2.9521102121145857,2.5384852495874961,3.2573289902280131,2.0844938812916673,2.8262826282628262,2.1364452423698386,1.9030520646319569]
["Stirling",44,47,55,42,53,55,35,null,{"$f":"'DATA CP CON'!J33","v":15493},{"$f":"'DATA CP CON'!K33","v":15425},{"$f":"'DATA CP CON'!L33","v":15514},{"$f":"'DATA CP CON'!M33","v":15417},{"$f":"'DATA CP CON'!N33","v":15153},{"$f":"'DATA CP CON'!O33","v":14948},{"$f":"'DATA CP CON'!P33","v":14948},null,"Stirling",2.8399922545665786,3.0470016207455428,3.5451849941987881,2.7242654212881883,3.4976572295914998,3.6794219962536796,2.3414503612523414]
["West Dunbartonshire",48,71,54,44,67,58,41,null,{"$f":"'DATA CP CON'!J34","v":15764},{"$f":"'DATA CP CON'!K34","v":15790},{"$f":"'DATA CP CON'!L34","v":15705},{"$f":"'DATA CP CON'!M34","v":15647},{"$f":"'DATA CP CON'!N34","v":15484},{"$f":"'DATA CP CON'!O34","v":15234},{"$f":"'DATA CP CON'!P34","v":15234},null,"West Dunbartonshire",3.0449124587668104,4.4965167827739077,3.4383954154727792,2.8120406467693488,4.3270472746060449,3.8072732046737561,2.6913482998555862]
["West Lothian",67,70,82,104,92,103,92,null,{"$f":"'DATA CP CON'!J35","v":35307},{"$f":"'DATA CP CON'!K35","v":35443},{"$f":"'DATA CP CON'!L35","v":35485},{"$f":"'DATA CP CON'!M35","v":35494},{"$f":"'DATA CP CON'!N35","v":35242},{"$f":"'DATA CP CON'!O35","v":35133},{"$f":"'DATA CP CON'!P35","v":35133},null,"West Lothian",1.8976406944798483,1.9750021160736957,2.3108355643229532,2.9300726883416917,2.6105215368026786,2.9317166197022742,2.6186206700253325]
["Scotland",2715,2600,2530,2580,2641,2119,2031,null,{"$f":"'DATA CP CON'!J36","v":915917},{"$f":"'DATA CP CON'!K36","v":917442},{"$f":"'DATA CP CON'!L36","v":919502},{"$f":"'DATA CP CON'!M36","v":921397},{"$f":"'DATA CP CON'!N36","v":916783},{"$f":"'DATA CP CON'!O36","v":911522},{"$f":"'DATA CP CON'!P36","v":911522},null,"Scotland",2.9642423931426101,2.833966615873265,2.751489393171521,2.8000959412717861,2.8807253188595339,2.3246833318340094,2.2281415039900301]
["Notes"]
["Figures for 2022 are provisional and may be revised with the publication of 2023 statistics."]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Population figures source: NRS mid-year population estimates for 2016-2021"]
["Source: Scottish Government CP Returns"]

{"sheet":"DATA CP DEREG","index":8,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Child Protection: De-registrations: 31 July 2016-2022"]
["Number of de-registrations: 31 July 2016-2022",null,null,null,null,null,null,null,null,"Population Aged 0-15",null,null,null,null,null,null,null,"Number of de-registrations per 1,000 children: 31 July 2016-2022"]
["Council",2016,2017,2018,2019,2020,2021,2022,null,{"$f":"'DATA CP CON'!J3","v":2016},{"$f":"'DATA CP CON'!K3","v":2017},{"$f":"'DATA CP CON'!L3","v":2018},{"$f":"'DATA CP CON'!M3","v":2019},{"$f":"'DATA CP CON'!N3","v":2020},{"$f":"'DATA CP CON'!O3","v":2021},{"$f":"'DATA CP CON'!P3","v":2022},null,"Council",{"$f":"B3","v":2016},2017,2018,2019,2020,2021,2022]
["Aberdeen City",136,202,162,111,145,200,124,null,{"$f":"'DATA CP CON'!J4","v":34187},{"$f":"'DATA CP CON'!K4","v":34495},{"$f":"'DATA CP CON'!L4","v":34833},{"$f":"'DATA CP CON'!M4","v":35423},{"$f":"'DATA CP CON'!N4","v":35789},{"$f":"'DATA CP CON'!O4","v":35860},{"$f":"'DATA CP CON'!P4","v":35860},null,"Aberdeen City",{"$f":"IFERROR(B4*1000/J4,\"*\")","v":3.9781203381402288},{"$f":"IFERROR(C4*1000/K4,\"*\")","v":5.8559211479924631},{"$f":"IFERROR(D4*1000/L4,\"*\")","v":4.6507622082507964},{"$f":"IFERROR(E4*1000/M4,\"*\")","v":3.1335572932840243},{"$f":"IFERROR(F4*1000/N4,\"*\")","v":4.0515242113498564},{"$f":"IFERROR(G4*1000/O4,\"*\")","v":5.5772448410485218},{"$f":"IFERROR(H4*1000/P4,\"*\")","v":3.4578918014500837}]
["Aberdeenshire",135,111,116,116,146,145,104,null,{"$f":"'DATA CP CON'!J5","v":48871},{"$f":"'DATA CP CON'!K5","v":48888},{"$f":"'DATA CP CON'!L5","v":49033},{"$f":"'DATA CP CON'!M5","v":49016},{"$f":"'DATA CP CON'!N5","v":48674},{"$f":"'DATA CP CON'!O5","v":48578},{"$f":"'DATA CP CON'!P5","v":48578},null,"Aberdeenshire",2.7623744142743138,2.2704958271968581,2.3657536760956908,2.3665741798596378,2.9995480133130625,2.984890279550414,2.1408868211947794]
["Angus",144,171,141,117,116,84,80,null,{"$f":"'DATA CP CON'!J6","v":19445},{"$f":"'DATA CP CON'!K6","v":19288},{"$f":"'DATA CP CON'!L6","v":19253},{"$f":"'DATA CP CON'!M6","v":19145},{"$f":"'DATA CP CON'!N6","v":18908},{"$f":"'DATA CP CON'!O6","v":18639},{"$f":"'DATA CP CON'!P6","v":18639},null,"Angus",7.4055026999228595,8.8656159270012438,7.3235339947021245,6.1112562026638813,6.1349693251533743,4.5066795428939317,4.2920757551370778]
["Argyll and Bute",57,82,57,59,46,65,41,null,{"$f":"'DATA CP CON'!J7","v":13238},{"$f":"'DATA CP CON'!K7","v":13163},{"$f":"'DATA CP CON'!L7","v":13024},{"$f":"'DATA CP CON'!M7","v":12906},{"$f":"'DATA CP CON'!N7","v":12577},{"$f":"'DATA CP CON'!O7","v":12441},{"$f":"'DATA CP CON'!P7","v":12441},null,"Argyll & Bute",4.3057863725638317,6.2295829218263314,4.3765356265356266,4.5715171238183787,3.657469984893059,5.2246603970741905,3.2955550196929506]
["City of Edinburgh",379,354,331,247,205,164,155,null,{"$f":"'DATA CP CON'!J8","v":77364},{"$f":"'DATA CP CON'!K8","v":78052},{"$f":"'DATA CP CON'!L8","v":78501},{"$f":"'DATA CP CON'!M8","v":79067},{"$f":"'DATA CP CON'!N8","v":79150},{"$f":"'DATA CP CON'!O8","v":78826},{"$f":"'DATA CP CON'!P8","v":78826},null,"City of Edinburgh",4.8989193940334008,4.5354379131860814,4.2165067960917693,3.1239328670621118,2.5900189513581808,2.0805318042270318,1.9663562783853044]
["Clackmannanshire",64,38,47,71,54,82,56,null,{"$f":"'DATA CP CON'!J9","v":9024},{"$f":"'DATA CP CON'!K9","v":9020},{"$f":"'DATA CP CON'!L9","v":8980},{"$f":"'DATA CP CON'!M9","v":8946},{"$f":"'DATA CP CON'!N9","v":8897},{"$f":"'DATA CP CON'!O9","v":8877},{"$f":"'DATA CP CON'!P9","v":8877},null,"Clackmannanshire",7.0921985815602833,4.2128603104212861,5.2338530066815148,7.9365079365079367,6.0694616162751487,9.2373549622620246,6.3084375352033346]
["Dumfries and Galloway",136,139,176,217,34,53,72,null,{"$f":"'DATA CP CON'!J10","v":23614},{"$f":"'DATA CP CON'!K10","v":23487},{"$f":"'DATA CP CON'!L10","v":23424},{"$f":"'DATA CP CON'!M10","v":23243},{"$f":"'DATA CP CON'!N10","v":23050},{"$f":"'DATA CP CON'!O10","v":22882},{"$f":"'DATA CP CON'!P10","v":22882},null,"Dumfries and Galloway",5.7592953332768699,5.9181674969131857,7.5136612021857925,9.3361442154627206,1.4750542299349241,2.3162310986801855,3.1465780963202516]
["Dundee City",143,154,136,153,144,163,129,null,{"$f":"'DATA CP CON'!J11","v":23849},{"$f":"'DATA CP CON'!K11","v":23998},{"$f":"'DATA CP CON'!L11","v":24016},{"$f":"'DATA CP CON'!M11","v":24044},{"$f":"'DATA CP CON'!N11","v":23958},{"$f":"'DATA CP CON'!O11","v":23704},{"$f":"'DATA CP CON'!P11","v":23704},null,"Dundee City",5.9960585349490545,6.4172014334527878,5.6628914057295132,6.3633338878722343,6.0105184072126221,6.8764765440431992,5.4421194735065814]
["East Ayrshire",160,120,147,198,180,131,81,null,{"$f":"'DATA CP CON'!J12","v":21259},{"$f":"'DATA CP CON'!K12","v":21164},{"$f":"'DATA CP CON'!L12","v":21119},{"$f":"'DATA CP CON'!M12","v":21053},{"$f":"'DATA CP CON'!N12","v":20869},{"$f":"'DATA CP CON'!O12","v":20792},{"$f":"'DATA CP CON'!P12","v":20792},null,"East Ayrshire",7.526224187402982,5.6700056700056702,6.9605568445475638,9.40483541538023,8.6252336000766689,6.3005001923816852,3.895729126587149]
["East Dunbartonshire",91,73,86,84,65,78,44,null,{"$f":"'DATA CP CON'!J13","v":18810},{"$f":"'DATA CP CON'!K13","v":19061},{"$f":"'DATA CP CON'!L13","v":19224},{"$f":"'DATA CP CON'!M13","v":19398},{"$f":"'DATA CP CON'!N13","v":19500},{"$f":"'DATA CP CON'!O13","v":19528},{"$f":"'DATA CP CON'!P13","v":19528},null,"East Dunbartonshire",4.8378522062732587,3.8298095587849534,4.4735746982937998,4.3303433343643674,3.3333333333333335,3.9942646456370339,2.2531749283080704]
["East Lothian",45,64,88,64,65,66,61,null,{"$f":"'DATA CP CON'!J14","v":18989},{"$f":"'DATA CP CON'!K14","v":19051},{"$f":"'DATA CP CON'!L14","v":19350},{"$f":"'DATA CP CON'!M14","v":19700},{"$f":"'DATA CP CON'!N14","v":19701},{"$f":"'DATA CP CON'!O14","v":19822},{"$f":"'DATA CP CON'!P14","v":19822},null,"East Lothian",2.369793038074675,3.359403705842213,4.5478036175710592,3.248730964467005,3.2993249073651083,3.3296337402885681,3.0773887599636769]
["East Renfrewshire",50,26,22,20,25,19,23,null,{"$f":"'DATA CP CON'!J15","v":18662},{"$f":"'DATA CP CON'!K15","v":19029},{"$f":"'DATA CP CON'!L15","v":19322},{"$f":"'DATA CP CON'!M15","v":19525},{"$f":"'DATA CP CON'!N15","v":19646},{"$f":"'DATA CP CON'!O15","v":19701},{"$f":"'DATA CP CON'!P15","v":19701},null,"East Renfrewshire",2.6792412388811488,1.3663355930421988,1.1385984887692786,1.0243277848911652,1.2725236689402424,0.96441804984518553,1.1674534287599614]
["Falkirk",109,129,91,91,140,165,168,null,{"$f":"'DATA CP CON'!J16","v":28359},{"$f":"'DATA CP CON'!K16","v":28329},{"$f":"'DATA CP CON'!L16","v":28230},{"$f":"'DATA CP CON'!M16","v":28112},{"$f":"'DATA CP CON'!N16","v":27886},{"$f":"'DATA CP CON'!O16","v":27564},{"$f":"'DATA CP CON'!P16","v":27564},null,"Falkirk",3.8435769949575089,4.5536376151646722,3.2235210768685794,3.237051792828685,5.0204403643405291,5.9860687853722245,6.0949063996517197]
["Fife",319,299,327,283,350,253,262,null,{"$f":"'DATA CP CON'!J17","v":64372},{"$f":"'DATA CP CON'!K17","v":64333},{"$f":"'DATA CP CON'!L17","v":64473},{"$f":"'DATA CP CON'!M17","v":64552},{"$f":"'DATA CP CON'!N17","v":64152},{"$f":"'DATA CP CON'!O17","v":63680},{"$f":"'DATA CP CON'!P17","v":63680},null,"Fife",4.9555707450444295,4.6476924750905448,5.0718905588385832,4.3840624612715331,5.4557924928295298,3.9729899497487438,4.1143216080402008]
["Glasgow City",592,594,508,427,465,488,{"$error":"#N/A"},null,{"$f":"'DATA CP CON'!J18","v":98487},{"$f":"'DATA CP CON'!K18","v":99137},{"$f":"'DATA CP CON'!L18","v":99938},{"$f":"'DATA CP CON'!M18","v":100666},{"$f":"'DATA CP CON'!N18","v":100478},{"$f":"'DATA CP CON'!O18","v":99881},{"$f":"'DATA CP CON'!P18","v":99881},null,"Glasgow City",6.0109456070344311,5.9917084438706034,5.0831515539634573,4.2417499453638765,4.6278787396245944,4.885814118801374,"*"]
["Highland",143,140,168,141,126,136,137,null,{"$f":"'DATA CP CON'!J19","v":39972},{"$f":"'DATA CP CON'!K19","v":39555},{"$f":"'DATA CP CON'!L19","v":39335},{"$f":"'DATA CP CON'!M19","v":39036},{"$f":"'DATA CP CON'!N19","v":38490},{"$f":"'DATA CP CON'!O19","v":38130},{"$f":"'DATA CP CON'!P19","v":38130},null,"Highland",3.577504252977084,3.5393755530274302,4.2710054658700907,3.6120504150015371,3.273577552611068,3.5667453448728037,3.5929714135851034]
["Inverclyde",59,53,52,48,84,96,47,null,{"$f":"'DATA CP CON'!J20","v":12851},{"$f":"'DATA CP CON'!K20","v":12701},{"$f":"'DATA CP CON'!L20","v":12628},{"$f":"'DATA CP CON'!M20","v":12603},{"$f":"'DATA CP CON'!N20","v":12413},{"$f":"'DATA CP CON'!O20","v":12197},{"$f":"'DATA CP CON'!P20","v":12197},null,"Inverclyde",4.5910824060384403,4.1728997716715215,4.117833386126069,3.8086169959533445,6.7670990091033598,7.8707878986636057,3.8534065753873903]
["Midlothian",77,116,119,108,96,94,72,null,{"$f":"'DATA CP CON'!J21","v":16884},{"$f":"'DATA CP CON'!K21","v":17229},{"$f":"'DATA CP CON'!L21","v":17590},{"$f":"'DATA CP CON'!M21","v":17953},{"$f":"'DATA CP CON'!N21","v":18089},{"$f":"'DATA CP CON'!O21","v":18281},{"$f":"'DATA CP CON'!P21","v":18281},null,"Midlothian",4.5605306799336649,6.7328341749376053,6.7652075042637865,6.015707681167493,5.3070927082757473,5.1419506591543129,3.9385153985011763]
["Moray",68,83,103,110,56,42,36,null,{"$f":"'DATA CP CON'!J22","v":16527},{"$f":"'DATA CP CON'!K22","v":16362},{"$f":"'DATA CP CON'!L22","v":16173},{"$f":"'DATA CP CON'!M22","v":16145},{"$f":"'DATA CP CON'!N22","v":16037},{"$f":"'DATA CP CON'!O22","v":15941},{"$f":"'DATA CP CON'!P22","v":15941},null,"Moray",4.1144793368427424,5.072729495171739,6.3686390898410936,6.8132548776711053,3.4919249236141421,2.6347155134558684,2.2583275829621732]
["Na h-Eileanan Siar",4,6,11,6,10,7,9,null,{"$f":"'DATA CP CON'!J23","v":4307},{"$f":"'DATA CP CON'!K23","v":4367},{"$f":"'DATA CP CON'!L23","v":4328},{"$f":"'DATA CP CON'!M23","v":4254},{"$f":"'DATA CP CON'!N23","v":4135},{"$f":"'DATA CP CON'!O23","v":4060},{"$f":"'DATA CP CON'!P23","v":4060},null,"Na h-Eileanan Siar",0.92872068725330859,1.3739409205404167,2.5415896487985212,1.4104372355430184,2.418379685610641,1.7241379310344827,2.2167487684729066]
["North Ayrshire",172,147,178,287,214,263,221,null,{"$f":"'DATA CP CON'!J24","v":23128},{"$f":"'DATA CP CON'!K24","v":22901},{"$f":"'DATA CP CON'!L24","v":22780},{"$f":"'DATA CP CON'!M24","v":22468},{"$f":"'DATA CP CON'!N24","v":22280},{"$f":"'DATA CP CON'!O24","v":21891},{"$f":"'DATA CP CON'!P24","v":21891},null,"North Ayrshire",7.4368730543064681,6.418933671018733,7.8138718173836699,12.773722627737227,9.6050269299820474,12.014069709012837,10.095473025444246]
["North Lanarkshire",224,258,255,215,262,208,202,null,{"$f":"'DATA CP CON'!J25","v":63299},{"$f":"'DATA CP CON'!K25","v":63011},{"$f":"'DATA CP CON'!L25","v":62955},{"$f":"'DATA CP CON'!M25","v":62836},{"$f":"'DATA CP CON'!N25","v":62278},{"$f":"'DATA CP CON'!O25","v":61606},{"$f":"'DATA CP CON'!P25","v":61606},null,"North Lanarkshire",3.5387604859476451,4.0945231784926444,4.0505122706695262,3.4216054491056083,4.2069430617553554,3.3762945167678473,3.2789014057072361]
["Orkney Islands",10,14,8,9,6,13,16,null,{"$f":"'DATA CP CON'!J26","v":3516},{"$f":"'DATA CP CON'!K26","v":3545},{"$f":"'DATA CP CON'!L26","v":3544},{"$f":"'DATA CP CON'!M26","v":3582},{"$f":"'DATA CP CON'!N26","v":3571},{"$f":"'DATA CP CON'!O26","v":3553},{"$f":"'DATA CP CON'!P26","v":3553},null,"Orkney Islands",2.8441410693970419,3.9492242595204514,2.2573363431151243,2.512562814070352,1.6802016241949034,3.6588798198705321,4.5032367013791159]
["Perth and Kinross",109,95,115,139,102,118,96,null,{"$f":"'DATA CP CON'!J27","v":24514},{"$f":"'DATA CP CON'!K27","v":24453},{"$f":"'DATA CP CON'!L27","v":24425},{"$f":"'DATA CP CON'!M27","v":24421},{"$f":"'DATA CP CON'!N27","v":24244},{"$f":"'DATA CP CON'!O27","v":24218},{"$f":"'DATA CP CON'!P27","v":24218},null,"Perth and Kinross",4.4464387696826302,3.885003885003885,4.7082906857727735,5.6918226116866633,4.2072265302755323,4.8724089520191596,3.9639937236766043]
["Renfrewshire",146,159,132,180,121,140,114,null,{"$f":"'DATA CP CON'!J28","v":29954},{"$f":"'DATA CP CON'!K28","v":30039},{"$f":"'DATA CP CON'!L28","v":30171},{"$f":"'DATA CP CON'!M28","v":30267},{"$f":"'DATA CP CON'!N28","v":30182},{"$f":"'DATA CP CON'!O28","v":29784},{"$f":"'DATA CP CON'!P28","v":29784},null,"Renfrewshire",4.8741403485344197,5.2931189453710177,4.3750621457691157,5.9470710674992562,4.009011993903651,4.7005103411227509,3.8275584206285256]
["Scottish Borders",40,79,64,64,49,59,54,null,{"$f":"'DATA CP CON'!J29","v":19002},{"$f":"'DATA CP CON'!K29","v":19026},{"$f":"'DATA CP CON'!L29","v":19046},{"$f":"'DATA CP CON'!M29","v":19023},{"$f":"'DATA CP CON'!N29","v":18824},{"$f":"'DATA CP CON'!O29","v":18723},{"$f":"'DATA CP CON'!P29","v":18723},null,"Scottish Borders",2.1050415745710978,4.152212761484285,3.3602856242780637,3.3643484203332807,2.6030599235019123,3.1512044010041125,2.8841531805800353]
["Shetland Islands",22,27,8,18,14,20,12,null,{"$f":"'DATA CP CON'!J30","v":4233},{"$f":"'DATA CP CON'!K30","v":4233},{"$f":"'DATA CP CON'!L30","v":4205},{"$f":"'DATA CP CON'!M30","v":4198},{"$f":"'DATA CP CON'!N30","v":4158},{"$f":"'DATA CP CON'!O30","v":4104},{"$f":"'DATA CP CON'!P30","v":4104},null,"Shetland Islands",5.1972596267422633,6.3784549964564139,1.9024970273483948,4.2877560743211056,3.3670033670033672,4.8732943469785575,2.9239766081871346]
["South Ayrshire",72,109,94,84,55,43,31,null,{"$f":"'DATA CP CON'!J31","v":17760},{"$f":"'DATA CP CON'!K31","v":17716},{"$f":"'DATA CP CON'!L31","v":17638},{"$f":"'DATA CP CON'!M31","v":17608},{"$f":"'DATA CP CON'!N31","v":17418},{"$f":"'DATA CP CON'!O31","v":17244},{"$f":"'DATA CP CON'!P31","v":17244},null,"South Ayrshire",4.0540540540540544,6.1526303906073609,5.3294024265789774,4.770558836892322,3.1576530026409459,2.493620969612619,1.7977267455346788]
["South Lanarkshire",298,273,255,284,239,277,238,null,{"$f":"'DATA CP CON'!J32","v":54876},{"$f":"'DATA CP CON'!K32","v":55151},{"$f":"'DATA CP CON'!L32","v":55260},{"$f":"'DATA CP CON'!M32","v":55649},{"$f":"'DATA CP CON'!N32","v":55550},{"$f":"'DATA CP CON'!O32","v":55700},{"$f":"'DATA CP CON'!P32","v":55700},null,"South Lanarkshire",5.4304249580873245,4.9500462366956173,4.6145494028230187,5.103416054196841,4.3024302430243022,4.9730700179533214,4.2728904847396771]
["Stirling",70,52,80,71,47,72,71,null,{"$f":"'DATA CP CON'!J33","v":15493},{"$f":"'DATA CP CON'!K33","v":15425},{"$f":"'DATA CP CON'!L33","v":15514},{"$f":"'DATA CP CON'!M33","v":15417},{"$f":"'DATA CP CON'!N33","v":15153},{"$f":"'DATA CP CON'!O33","v":14948},{"$f":"'DATA CP CON'!P33","v":14948},null,"Stirling",4.5181694959013745,3.3711507293354943,5.1566327188346008,4.6053058312252704,3.1016960337886887,4.8166978860048166,4.7497993042547497]
["West Dunbartonshire",45,105,112,81,65,89,86,null,{"$f":"'DATA CP CON'!J34","v":15764},{"$f":"'DATA CP CON'!K34","v":15790},{"$f":"'DATA CP CON'!L34","v":15705},{"$f":"'DATA CP CON'!M34","v":15647},{"$f":"'DATA CP CON'!N34","v":15484},{"$f":"'DATA CP CON'!O34","v":15234},{"$f":"'DATA CP CON'!P34","v":15234},null,"West Dunbartonshire",2.8546054300938848,6.6497783407219764,7.1314867876472459,5.1767111906435739,4.197881684319297,5.8421950899304189,5.6452671655507416]
["West Lothian",180,134,127,142,176,142,184,null,{"$f":"'DATA CP CON'!J35","v":35307},{"$f":"'DATA CP CON'!K35","v":35443},{"$f":"'DATA CP CON'!L35","v":35485},{"$f":"'DATA CP CON'!M35","v":35494},{"$f":"'DATA CP CON'!N35","v":35242},{"$f":"'DATA CP CON'!O35","v":35133},{"$f":"'DATA CP CON'!P35","v":35133},null,"West Lothian",5.0981391791995918,3.7807183364839321,3.5789770325489645,4.0006761706203866,4.9940412008399067,4.0417840776477956,5.237241340050665]
["Scotland",4299,4406,4316,4245,3902,3975,3364,null,{"$f":"SUM(J4:J35)","v":915917},{"$f":"SUM(K4:K35)","v":917442},{"$f":"SUM(L4:L35)","v":919502},{"$f":"SUM(M4:M35)","v":921397},{"$f":"SUM(N4:N35)","v":916783},{"$f":"SUM(O4:O35)","v":911522},{"$f":"SUM(P4:P35)","v":911522},null,"Scotland",4.6936567396390725,4.8024834267452325,4.6938451466119702,4.6071346010460204,4.2561871238886413,4.3608382463615802,3.6905307825812215]
["Notes"]
["Figures for 2022 are provisional and may be revised with the publication of 2023 statistics."]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Population figures source: NRS mid-year population estimates for 2016-2021"]
["Source: Scottish Government CP Returns"]

{"sheet":"REF EA Name","index":9,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["EA Code","EA Name"]
[]
[100,"Aberdeen City"]
[110,"Aberdeenshire"]
[120,"Angus"]
[130,"Argyll & Bute"]
[230,"City of Edinburgh"]
[150,"Clackmannanshire"]
[170,"Dumfries & Galloway"]
[180,"Dundee City"]
[190,"East Ayrshire"]
[200,"East Dunbartonshire"]
[210,"East Lothian"]
[220,"East Renfrewshire"]
[240,"Falkirk"]
[250,"Fife"]
[260,"Glasgow City"]
[270,"Highland"]
[280,"Inverclyde"]
[290,"Midlothian"]
[300,"Moray"]
[235,"Na h-Eileanan Siar"]
[310,"North Ayrshire"]
[320,"North Lanarkshire"]
[330,"Orkney Islands"]
[340,"Perth & Kinross"]
[350,"Renfrewshire"]
[355,"Scottish Borders"]
[360,"Shetland Islands"]
[370,"South Ayrshire"]
[380,"South Lanarkshire"]
[390,"Stirling"]
[395,"West Dunbartonshire"]
[400,"West Lothian"]
[null,"[no comparator]"]

{"sheet":"REF CAS2","index":10,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[100,"Aberdeen City","City of Edinburgh","****","Dundee City","***","South Ayrshire","***","Argyll and Bute","***","Renfrewshire","***"]
[110,"Aberdeenshire","Stirling","****","Perth and Kinross","****","Highland","****","Scottish Borders","****","South Lanarkshire","****"]
[120,"Angus","Highland","*****","Dumfries and Galloway","*****","Moray","*****","Scottish Borders","****","South Ayrshire","****"]
[130,"Argyll & Bute","South Ayrshire","*****","Dumfries and Galloway","****","Scottish Borders","****","Highland","****","Angus","****"]
[230,"City of Edinburgh","Aberdeen City","****","Dundee City","**","South Ayrshire","**","Argyll and Bute","**","Renfrewshire","**"]
[150,"Clackmannanshire","North Lanarkshire","*****","West Lothian","****","Falkirk","****","South Lanarkshire","****","East Ayrshire","****"]
[170,"Dumfries & Galloway","Angus","*****","Highland","****","Argyll and Bute","****","Scottish Borders","****","Moray","****"]
[180,"Dundee City","Aberdeen City","***","Renfrewshire","***","Dumfries and Galloway","***","Inverclyde","***","South Ayrshire","***"]
[190,"East Ayrshire","North Lanarkshire","*****","Clackmannanshire","****","Falkirk","****","North Ayrshire","****","West Lothian","****"]
[200,"East Dunbartonshire","East Renfrewshire","****","Stirling","****","East Lothian","****","Aberdeenshire","***","Perth and Kinross","***"]
[210,"East Lothian","Stirling","****","Midlothian","****","Fife","****","Aberdeenshire","****","South Lanarkshire","****"]
[220,"East Renfrewshire","East Dunbartonshire","****","East Lothian","****","Stirling","***","Aberdeenshire","***","Midlothian","***"]
[240,"Falkirk","South Lanarkshire","****","Fife","****","Clackmannanshire","****","Moray","****","Angus","****"]
[250,"Fife","South Lanarkshire","*****","Falkirk","****","Clackmannanshire","****","West Lothian","****","Renfrewshire","****"]
[260,"Glasgow City","Dundee City","***","West Dunbartonshire","***","Inverclyde","***","Aberdeen City","***","Renfrewshire","***"]
[270,"Highland","Angus","*****","Scottish Borders","*****","Dumfries and Galloway","****","Moray","****","Argyll and Bute","****"]
[280,"Inverclyde","West Dunbartonshire","****","North Ayrshire","****","North Lanarkshire","****","East Ayrshire","****","Renfrewshire","****"]
[290,"Midlothian","West Lothian","****","Fife","****","Clackmannanshire","****","South Lanarkshire","****","East Lothian","****"]
[300,"Moray","Angus","*****","Highland","****","Dumfries and Galloway","****","Falkirk","****","Scottish Borders","****"]
[235,"Na h-Eileanan Siar","Orkney Islands","****","Dumfries and Galloway","***","Scottish Borders","***","Highland","***","Moray","***"]
[310,"North Ayrshire","North Lanarkshire","****","Inverclyde","****","Clackmannanshire","****","West Dunbartonshire","****","West Lothian","****"]
[320,"North Lanarkshire","Clackmannanshire","*****","East Ayrshire","*****","Falkirk","****","West Lothian","****","North Ayrshire","****"]
[330,"Orkney Islands","Scottish Borders","****","Highland","****","Na h-Eileanan Siar","****","Moray","****","Shetland Islands","****"]
[340,"Perth & Kinross","Scottish Borders","****","Argyll and Bute","****","Aberdeenshire","****","Stirling","****","Highland","****"]
[350,"Renfrewshire","Fife","****","Falkirk","****","Clackmannanshire","****","West Dunbartonshire","****","South Lanarkshire","****"]
[355,"Scottish Borders","Highland","*****","Angus","****","Dumfries and Galloway","****","Argyll and Bute","****","Perth and Kinross","****"]
[360,"Shetland Islands","Orkney Islands","****","Moray","****","Highland","****","Scottish Borders","****","Angus","***"]
[370,"South Ayrshire","Argyll and Bute","*****","Angus","****","Dumfries and Galloway","****","Highland","****","Scottish Borders","****"]
[380,"South Lanarkshire","Fife","*****","Falkirk","****","West Lothian","****","Clackmannanshire","****","North Lanarkshire","****"]
[390,"Stirling","Aberdeenshire","****","Perth and Kinross","****","East Lothian","****","South Ayrshire","****","Fife","****"]
[395,"West Dunbartonshire","Inverclyde","****","Renfrewshire","****","North Ayrshire","****","Clackmannanshire","****","Midlothian","****"]
[400,"West Lothian","Clackmannanshire","****","South Lanarkshire","****","Midlothian","****","North Lanarkshire","****","Fife","****"]

{"sheet":"REF CAs","index":11,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
[1,{"$f":"INDEX($J$1:$K$32,MATCH(C39,$J$1:$J$32,0),2)","v":5},{"$f":"INDEX($J$1:$K$32,MATCH(D39,$J$1:$J$32,0),2)","v":8},{"$f":"INDEX($J$1:$K$32,MATCH(E39,$J$1:$J$32,0),2)","v":28},{"$f":"INDEX($J$1:$K$32,MATCH(F39,$J$1:$J$32,0),2)","v":4},{"$f":"INDEX($J$1:$K$32,MATCH(G39,$J$1:$J$32,0),2)","v":25},null,null,"Aberdeen City","Aberdeen City",1]
[2,{"$f":"INDEX($J$1:$K$32,MATCH(C40,$J$1:$J$32,0),2)","v":30},24,16,26,29,null,null,"Aberdeenshire","Aberdeenshire",2]
[3,16,7,19,26,28,null,null,"Angus","Angus",3]
[4,28,7,26,16,3,null,null,"Argyll and Bute","Argyll and Bute",4]
[5,1,8,28,4,25,null,null,"Clackmannanshire","City of Edinburgh",5]
[6,22,32,13,29,9,null,null,"Dumfries and Galloway","Clackmannanshire",6]
[7,3,16,4,26,19,null,null,"Dundee City","Dumfries and Galloway",7]
[8,1,25,7,17,28,null,null,"East Ayrshire","Dundee City",8]
[9,22,6,13,21,32,null,null,"East Dunbartonshire","East Ayrshire",9]
[10,12,30,11,2,24,null,null,"East Lothian","East Dunbartonshire",10]
[11,30,18,14,2,29,null,null,"East Renfrewshire","East Lothian",11]
[12,10,11,30,2,18,null,null,"Edinburgh","East Renfrewshire",12]
[13,29,14,6,19,3,null,null,"Eilean Siar","Falkirk",13]
[14,29,13,6,32,25,null,null,"Falkirk","Fife",14]
[15,8,31,17,1,25,null,null,"Fife","Glasgow City",15]
[16,3,26,7,19,4,null,null,"Glasgow City","Highland",16]
[17,31,21,22,9,25,null,null,"Highland","Inverclyde",17]
[18,{"$f":"INDEX($J$1:$K$32,MATCH(C56,$J$1:$J$32,0),2)","v":32},14,6,29,11,null,null,"Inverclyde","Midlothian",18]
[19,3,16,7,13,26,null,null,"Midlothian","Moray",19]
[20,23,7,26,16,19,null,null,"Moray","Na h-Eileanan Siar",20]
[21,22,17,6,31,32,null,null,"North Ayrshire","North Ayrshire",21]
[22,6,9,13,32,21,null,null,"North Lanarkshire","North Lanarkshire",22]
[23,26,16,20,19,27,null,null,"Orkney Islands","Orkney Islands",23]
[24,26,4,2,30,16,null,null,"Perth and Kinross","Perth and Kinross",24]
[25,14,13,6,31,29,null,null,"Renfrewshire","Renfrewshire",25]
[26,16,3,7,4,24,null,null,"Scottish Borders","Scottish Borders",26]
[27,23,19,16,26,3,null,null,"Shetland Islands","Shetland Islands",27]
[28,4,3,7,16,26,null,null,"South Ayrshire","South Ayrshire",28]
[29,14,13,32,6,22,null,null,"South Lanarkshire","South Lanarkshire",29]
[30,2,24,11,28,14,null,null,"Stirling","Stirling",30]
[31,17,25,21,6,18,null,null,"West Dunbartonshire","West Dunbartonshire",31]
[32,6,29,18,22,14,null,null,"West Lothian","West Lothian",32]
[]
[]
[]
[]
[]
[]
[1,"Aberdeen City","City of Edinburgh","Dundee City","South Ayrshire","Argyll and Bute","Renfrewshire"]
[2,"Aberdeenshire","Stirling","Perth and Kinross","Highland","Scottish Borders","South Lanarkshire"]
[3,"Angus","Highland","Dumfries and Galloway","Moray","Scottish Borders","South Ayrshire"]
[4,"Argyll & Bute","South Ayrshire","Dumfries and Galloway","Scottish Borders","Highland","Angus"]
[5,"City of Edinburgh","Aberdeen City","Dundee City","South Ayrshire","Argyll and Bute","Renfrewshire"]
[6,"Clackmannanshire","North Lanarkshire","West Lothian","Falkirk","South Lanarkshire","East Ayrshire"]
[7,"Dumfries & Galloway","Angus","Highland","Argyll and Bute","Scottish Borders","Moray"]
[8,"Dundee City","Aberdeen City","Renfrewshire","Dumfries and Galloway","Inverclyde","South Ayrshire"]
[9,"East Ayrshire","North Lanarkshire","Clackmannanshire","Falkirk","North Ayrshire","West Lothian"]
[10,"East Dunbartonshire","East Renfrewshire","Stirling","East Lothian","Aberdeenshire","Perth and Kinross"]
[11,"East Lothian","Stirling","Midlothian","Fife","Aberdeenshire","South Lanarkshire"]
[12,"East Renfrewshire","East Dunbartonshire","East Lothian","Stirling","Aberdeenshire","Midlothian"]
[13,"Falkirk","South Lanarkshire","Fife","Clackmannanshire","Moray","Angus"]
[14,"Fife","South Lanarkshire","Falkirk","Clackmannanshire","West Lothian","Renfrewshire"]
[15,"Glasgow City","Dundee City","West Dunbartonshire","Inverclyde","Aberdeen City","Renfrewshire"]
[16,"Highland","Angus","Scottish Borders","Dumfries and Galloway","Moray","Argyll and Bute"]
[17,"Inverclyde","West Dunbartonshire","North Ayrshire","North Lanarkshire","East Ayrshire","Renfrewshire"]
[18,"Midlothian","West Lothian","Fife","Clackmannanshire","South Lanarkshire","East Lothian"]
[19,"Moray","Angus","Highland","Dumfries and Galloway","Falkirk","Scottish Borders"]
[20,"Na h-Eileanan Siar","Orkney Islands","Dumfries and Galloway","Scottish Borders","Highland","Moray"]
[21,"North Ayrshire","North Lanarkshire","Inverclyde","Clackmannanshire","West Dunbartonshire","West Lothian"]
[22,"North Lanarkshire","Clackmannanshire","East Ayrshire","Falkirk","West Lothian","North Ayrshire"]
[23,"Orkney Islands","Scottish Borders","Highland","Na h-Eileanan Siar","Moray","Shetland Islands"]
[24,"Perth & Kinross","Scottish Borders","Argyll and Bute","Aberdeenshire","Stirling","Highland"]
[25,"Renfrewshire","Fife","Falkirk","Clackmannanshire","West Dunbartonshire","South Lanarkshire"]
[26,"Scottish Borders","Highland","Angus","Dumfries and Galloway","Argyll and Bute","Perth and Kinross"]
[27,"Shetland Islands","Orkney Islands","Moray","Highland","Scottish Borders","Angus"]
[28,"South Ayrshire","Argyll and Bute","Angus","Dumfries and Galloway","Highland","Scottish Borders"]
[29,"South Lanarkshire","Fife","Falkirk","West Lothian","Clackmannanshire","North Lanarkshire"]
[30,"Stirling","Aberdeenshire","Perth and Kinross","East Lothian","South Ayrshire","Fife"]
[31,"West Dunbartonshire","Inverclyde","Renfrewshire","North Ayrshire","Clackmannanshire","Midlothian"]
[32,"West Lothian","Clackmannanshire","South Lanarkshire","Midlothian","North Lanarkshire","Fife"]