{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Select an authority","CP conferences","CP registrations","CP de-registrations","CP on register","DATA CP CON","DATA CP REG","DATA CP DEREG","DATA CP ON REG","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":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[27,3,30,8],[10,0,11,8],[12,0,17,8]]}
[15]
["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: 24/09/2020"]
[]
["Instructions on how to use this workbook available at:-"]
["LA Level Statistics - Child Protection - User Instructions"]
["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",null,"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."]
[{"$f":"OFFSET('REF CAS2'!$C$1,'Select an authority'!$A$1,0)","v":"Dundee City"},{"$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":"West Dunbartonshire"},{"$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":"Inverclyde"},{"$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":"Aberdeen City"},{"$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":"Renfrewshire"},{"$f":"OFFSET('REF CAS2'!$L$1,'Select an authority'!$A$1,0)","v":"***"}]

{"sheet":"CP conferences","index":1,"n_rows":50,"n_cols":30,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,1,12,6],[13,1,14,6],[15,1,17,6]]}
[{"$f":"'DATA CP CON'!A1","v":"Child Protection: Conferences: 31 July 2013-2019"}]
[null,null,"select comparators:"]
[null,{"$f":"J3","v":8},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":8}]
[null,{"$f":"J4","v":31},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":31}]
[null,{"$f":"J5","v":17},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":17}]
[null,1,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":1}]
[null,25,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":25}]
[null,0]
[]
[]
[]
[null,{"$f":"IF(AA22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Z22=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The number of referrals resulted in a case conference in \"&B22&\" in \"&AA20&\" was \"&ROUND(AA22,0)&\" (\"&Z47&ROUND((SQRT((Z22*100)^2)),1)&\"% from \"&ROUND(W22,0)&\" in \"&W20&\")\"))","v":"*  The number of referrals resulted in a case conference in Glasgow City in 2019 was 708 (an increase of 6% from 668 in 2018)"}]
[]
[null,{"$f":"IF(Z31=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&Z49&ROUND(SQRT((Z31*100)^2),1)&\"%, while the Scotland figures show \"&Z50&ROUND(SQRT((100*Z33)^2),1)&\"%\")","v":"*  The comparator authorities show an increase of 6.6%, while the Scotland figures show a decrease of 2.3%"}]
[]
[null,{"$f":"IF(AC22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(AC31=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The rate (per 1,000 pop 0-15) is \"&ROUND(AC22,1)&\".  This is \"&AD43&\" the comparator average rate of \"&ROUND(AC31,1)&\", and \"&AD44&\" the Scotland average rate of \"&ROUND(AC33,1)))","v":"*  The rate (per 1,000 pop 0-15) is 7.  This is less than the comparator average rate of 7.6, and greater than the Scotland average rate of 6"}]
[]
[]
[]
[null,null,{"$f":"'DATA CP CON'!B5","v":2013},null,null,null,{"$f":"'DATA CP CON'!C5","v":2014},null,null,null,{"$f":"'DATA CP CON'!D5","v":2015},null,null,null,{"$f":"'DATA CP CON'!E5","v":2016},null,null,null,{"$f":"'DATA CP CON'!F5","v":2017},null,null,null,{"$f":"'DATA CP CON'!G5","v":2018},null,null,null,{"$f":"'DATA CP CON'!H5","v":2019}]
[null,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"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Glasgow City"},{"$f":"OFFSET('DATA CP CON'!$B$5,'Select an authority'!$A$1,0)","v":878},null,{"$f":"IF(C22=\"*\",\"*\",OFFSET('DATA CP CON'!$S$5,'Select an authority'!$A$1,0))","v":9.1034454156168678},{"$f":"IF(C22=0,\"\",IF(C22=\"*\",\"\",IF(G22=\"*\",\"\",G22/C22-1)))","v":-0.11389521640091116},{"$f":"OFFSET('DATA CP CON'!$C$5,'Select an authority'!$A$1,0)","v":778},null,{"$f":"IF(G22=\"*\",\"\",OFFSET('DATA CP CON'!$T$5,'Select an authority'!$A$1,0))","v":8.0447528151464702},{"$f":"IF(G22=0,\"\",IF(G22=\"*\",\"\",IF(K22=\"*\",\"\",K22/G22-1)))","v":0.5102827763496145},{"$f":"OFFSET('DATA CP CON'!$D$5,'Select an authority'!$A$1,0)","v":1175},null,{"$f":"IF(K22=\"*\",\"\",OFFSET('DATA CP CON'!$U$5,'Select an authority'!$A$1,0))","v":12.047328056432761},{"$f":"IF(K22=0,\"\",IF(K22=\"*\",\"\",IF(O22=\"*\",\"\",O22/K22-1)))","v":-0.17361702127659573},{"$f":"OFFSET('DATA CP CON'!$E$5,'Select an authority'!$A$1,0)","v":971},null,{"$f":"IF(O22=\"*\",\"\",OFFSET('DATA CP CON'!$V$5,'Select an authority'!$A$1,0))","v":9.8591692304568124},{"$f":"IF(O22=0,\"\",IF(O22=\"*\",\"\",IF(S22=\"*\",\"\",S22/O22-1)))","v":-0.20803295571575697},{"$f":"OFFSET('DATA CP CON'!$F$5,'Select an authority'!$A$1,0)","v":769},null,{"$f":"IF(S22=\"*\",\"\",OFFSET('DATA CP CON'!$W$5,'Select an authority'!$A$1,0))","v":7.7569424130244009},{"$f":"IF(S22=0,\"\",IF(S22=\"*\",\"\",IF(W22=\"*\",\"\",W22/S22-1)))","v":-0.13133940182054615},{"$f":"OFFSET('DATA CP CON'!$G$5,'Select an authority'!$A$1,0)","v":668},null,{"$f":"IF(W22=\"*\",\"\",OFFSET('DATA CP CON'!$X$5,'Select an authority'!$A$1,0))","v":6.6841441693850188},{"$f":"IF(W22=0,\"\",IF(W22=\"*\",\"\",IF(AA22=\"*\",\"\",AA22/W22-1)))","v":5.9880239520958112E-2},{"$f":"OFFSET('DATA CP CON'!$H$5,'Select an authority'!$A$1,0)","v":708},null,{"$f":"IF(AA22=\"*\",\"\",OFFSET('DATA CP CON'!$Y$5,'Select an authority'!$A$1,0))","v":7.0331591599944367},{"$f":"IF(RANK(AC22,'DATA CP CON'!$Y$6:$Y$37)<9,1,IF(RANK(AC22,'DATA CP CON'!$Y$6:$Y$37)<17,2,IF(RANK(AC22,'DATA CP CON'!$Y$6:$Y$37)<25,3,4)))","v":2}]
[]
["Comparator Authorities:"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2, B3,0)","v":"Dundee City"},{"$f":"IF(B3<33,OFFSET('DATA CP CON'!$B$5,B3,0),\"\")","v":160},{"$f":"OFFSET('DATA CP CON'!$J$5,B3,0)","v":23753},{"$f":"IF($B3=33,\"\",IF(C25=\"*\",\"\",C25*1000/D25))","v":6.7359912432113838},{"$f":"IF($B3=33,\"\",IF(C25=\"*\",\"\",IF(G25=\"*\",\"\",G25/C25-1)))","v":-5.0000000000000044E-2},{"$f":"IF(B3<33,OFFSET('DATA CP CON'!$C$5,B3,0),\"\")","v":152},{"$f":"OFFSET('DATA CP CON'!$K$5,B3,0)","v":23716},{"$f":"IF($B3=33,\"\",IF(G25=\"*\",\"\",G25*1000/H25))","v":6.4091752403440712},{"$f":"IF($B3=33,\"\",IF(G25=\"*\",\"\",IF(K25=\"*\",\"\",K25/G25-1)))","v":6.578947368421062E-2},{"$f":"IF(B3<33,OFFSET('DATA CP CON'!$D$5,B3,0),\"\")","v":162},{"$f":"OFFSET('DATA CP CON'!$L$5,B3,0)","v":23798},{"$f":"IF($B3=33,\"\",IF(K25=\"*\",\"\",K25*1000/L25))","v":6.8072947306496348},{"$f":"IF($B3=33,\"\",IF(K25=\"*\",\"\",IF(O25=\"*\",\"\",O25/K25-1)))","v":7.4074074074074181E-2},{"$f":"IF(B3<33,OFFSET('DATA CP CON'!$E$5,B3,0),\"\")","v":174},{"$f":"OFFSET('DATA CP CON'!$M$5,B3,0)","v":23849},{"$f":"IF($B3=33,\"\",IF(O25=\"*\",\"\",O25*1000/P25))","v":7.2959033921757728},{"$f":"IF($B3=33,\"\",IF(O25=\"*\",\"\",IF(S25=\"*\",\"\",S25/O25-1)))","v":-0.12643678160919536},{"$f":"IF(B3<33,OFFSET('DATA CP CON'!$F$5,B3,0),\"\")","v":152},{"$f":"OFFSET('DATA CP CON'!$N$5,B3,0)","v":23998},{"$f":"IF($B3=33,\"\",IF(S25=\"*\",\"\",S25*1000/T25))","v":6.3338611550962582},{"$f":"IF($B3=33,\"\",IF(S25=\"*\",\"\",IF(W25=\"*\",\"\",W25/S25-1)))","v":3.289473684210531E-2},{"$f":"IF(B3<33,OFFSET('DATA CP CON'!$G$5,B3,0),\"\")","v":157},{"$f":"OFFSET('DATA CP CON'!$O$5,B3,0)","v":24016},{"$f":"IF($B3=33,\"\",IF(W25=\"*\",\"\",W25*1000/X25))","v":6.5373084610259831},{"$f":"IF($B3=33,\"\",IF(W25=\"*\",\"\",IF(AA25=\"*\",\"\",AA25/W25-1)))","v":0.14649681528662417},{"$f":"IF(B3<33,OFFSET('DATA CP CON'!$H$5,B3,0),\"\")","v":180},{"$f":"OFFSET('DATA CP CON'!$P$5,B3,0)","v":24044},{"$f":"IF($B3=33,\"\",IF(AA25=\"*\",\"\",AA25*1000/AB25))","v":7.4862751622026282},{"$f":"IF(B3<33,IF(RANK(AC25,'DATA CP CON'!$Y$6:$Y$37)<9,1,IF(RANK(AC25,'DATA CP CON'!$Y$6:$Y$37)<17,2,IF(RANK(AC25,'DATA CP CON'!$Y$6:$Y$37)<25,3,4))),\"\")","v":1}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B4,0)","v":"West Dunbartonshire"},{"$f":"IF(B4<33,OFFSET('DATA CP CON'!$B$5,B4,0),\"\")","v":129},{"$f":"OFFSET('DATA CP CON'!$J$5,B4,0)","v":15782},{"$f":"IF($B4=33,\"\",IF(C26=\"*\",\"\",C26*1000/D26))","v":8.1738689646432636},{"$f":"IF($B4=33,\"\",IF(C26=\"*\",\"\",IF(G26=\"*\",\"\",G26/C26-1)))","v":4.6511627906976827E-2},{"$f":"IF(B4<33,OFFSET('DATA CP CON'!$C$5,B4,0),\"\")","v":135},{"$f":"OFFSET('DATA CP CON'!$K$5,B4,0)","v":15698},{"$f":"IF($B4=33,\"\",IF(G26=\"*\",\"\",G26*1000/H26))","v":8.5998216333290873},{"$f":"IF($B4=33,\"\",IF(G26=\"*\",\"\",IF(K26=\"*\",\"\",K26/G26-1)))","v":2.9629629629629672E-2},{"$f":"IF(B4<33,OFFSET('DATA CP CON'!$D$5,B4,0),\"\")","v":139},{"$f":"OFFSET('DATA CP CON'!$L$5,B4,0)","v":15709},{"$f":"IF($B4=33,\"\",IF(K26=\"*\",\"\",K26*1000/L26))","v":8.848430835826596},{"$f":"IF($B4=33,\"\",IF(K26=\"*\",\"\",IF(O26=\"*\",\"\",O26/K26-1)))","v":0.14388489208633093},{"$f":"IF(B4<33,OFFSET('DATA CP CON'!$E$5,B4,0),\"\")","v":159},{"$f":"OFFSET('DATA CP CON'!$M$5,B4,0)","v":15764},{"$f":"IF($B4=33,\"\",IF(O26=\"*\",\"\",O26*1000/P26))","v":10.08627251966506},{"$f":"IF($B4=33,\"\",IF(O26=\"*\",\"\",IF(S26=\"*\",\"\",S26/O26-1)))","v":0.57861635220125796},{"$f":"IF(B4<33,OFFSET('DATA CP CON'!$F$5,B4,0),\"\")","v":251},{"$f":"OFFSET('DATA CP CON'!$N$5,B4,0)","v":15790},{"$f":"IF($B4=33,\"\",IF(S26=\"*\",\"\",S26*1000/T26))","v":15.896136795440151},{"$f":"IF($B4=33,\"\",IF(S26=\"*\",\"\",IF(W26=\"*\",\"\",W26/S26-1)))","v":-0.11952191235059761},{"$f":"IF(B4<33,OFFSET('DATA CP CON'!$G$5,B4,0),\"\")","v":221},{"$f":"OFFSET('DATA CP CON'!$O$5,B4,0)","v":15705},{"$f":"IF($B4=33,\"\",IF(W26=\"*\",\"\",W26*1000/X26))","v":14.071951607768227},{"$f":"IF($B4=33,\"\",IF(W26=\"*\",\"\",IF(AA26=\"*\",\"\",AA26/W26-1)))","v":-0.26244343891402711},{"$f":"IF(B4<33,OFFSET('DATA CP CON'!$H$5,B4,0),\"\")","v":163},{"$f":"OFFSET('DATA CP CON'!$P$5,B4,0)","v":15647},{"$f":"IF($B4=33,\"\",IF(AA26=\"*\",\"\",AA26*1000/AB26))","v":10.417332395986451},{"$f":"IF(B4<33,IF(RANK(AC26,'DATA CP CON'!$Y$6:$Y$37)<9,1,IF(RANK(AC26,'DATA CP CON'!$Y$6:$Y$37)<17,2,IF(RANK(AC26,'DATA CP CON'!$Y$6:$Y$37)<25,3,4))),\"\")","v":1}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B5,0)","v":"Inverclyde"},{"$f":"IF(B5<33,OFFSET('DATA CP CON'!$B$5,B5,0),\"\")","v":70},{"$f":"OFFSET('DATA CP CON'!$J$5,B5,0)","v":13241},{"$f":"IF($B5=33,\"\",IF(C27=\"*\",\"\",C27*1000/D27))","v":5.2866097726757797},{"$f":"IF($B5=33,\"\",IF(C27=\"*\",\"\",IF(G27=\"*\",\"\",G27/C27-1)))","v":0.44285714285714284},{"$f":"IF(B5<33,OFFSET('DATA CP CON'!$C$5,B5,0),\"\")","v":101},{"$f":"OFFSET('DATA CP CON'!$K$5,B5,0)","v":13143},{"$f":"IF($B5=33,\"\",IF(G27=\"*\",\"\",G27*1000/H27))","v":7.6846990793578334},{"$f":"IF($B5=33,\"\",IF(G27=\"*\",\"\",IF(K27=\"*\",\"\",K27/G27-1)))","v":8.9108910891089188E-2},{"$f":"IF(B5<33,OFFSET('DATA CP CON'!$D$5,B5,0),\"\")","v":110},{"$f":"OFFSET('DATA CP CON'!$L$5,B5,0)","v":12966},{"$f":"IF($B5=33,\"\",IF(K27=\"*\",\"\",K27*1000/L27))","v":8.4837266697516576},{"$f":"IF($B5=33,\"\",IF(K27=\"*\",\"\",IF(O27=\"*\",\"\",O27/K27-1)))","v":-3.6363636363636376E-2},{"$f":"IF(B5<33,OFFSET('DATA CP CON'!$E$5,B5,0),\"\")","v":106},{"$f":"OFFSET('DATA CP CON'!$M$5,B5,0)","v":12851},{"$f":"IF($B5=33,\"\",IF(O27=\"*\",\"\",O27*1000/P27))","v":8.248385339662283},{"$f":"IF($B5=33,\"\",IF(O27=\"*\",\"\",IF(S27=\"*\",\"\",S27/O27-1)))","v":-0.10377358490566035},{"$f":"IF(B5<33,OFFSET('DATA CP CON'!$F$5,B5,0),\"\")","v":95},{"$f":"OFFSET('DATA CP CON'!$N$5,B5,0)","v":12701},{"$f":"IF($B5=33,\"\",IF(S27=\"*\",\"\",S27*1000/T27))","v":7.4797260058263131},{"$f":"IF($B5=33,\"\",IF(S27=\"*\",\"\",IF(W27=\"*\",\"\",W27/S27-1)))","v":-0.26315789473684215},{"$f":"IF(B5<33,OFFSET('DATA CP CON'!$G$5,B5,0),\"\")","v":70},{"$f":"OFFSET('DATA CP CON'!$O$5,B5,0)","v":12628},{"$f":"IF($B5=33,\"\",IF(W27=\"*\",\"\",W27*1000/X27))","v":5.5432372505543235},{"$f":"IF($B5=33,\"\",IF(W27=\"*\",\"\",IF(AA27=\"*\",\"\",AA27/W27-1)))","v":0.31428571428571428},{"$f":"IF(B5<33,OFFSET('DATA CP CON'!$H$5,B5,0),\"\")","v":92},{"$f":"OFFSET('DATA CP CON'!$P$5,B5,0)","v":12603},{"$f":"IF($B5=33,\"\",IF(AA27=\"*\",\"\",AA27*1000/AB27))","v":7.2998492422439103},{"$f":"IF(B5<33,IF(RANK(AC27,'DATA CP CON'!$Y$6:$Y$37)<9,1,IF(RANK(AC27,'DATA CP CON'!$Y$6:$Y$37)<17,2,IF(RANK(AC27,'DATA CP CON'!$Y$6:$Y$37)<25,3,4))),\"\")","v":2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B6,0)","v":"Aberdeen City"},{"$f":"IF(B6<33,OFFSET('DATA CP CON'!$B$5,B6,0),\"\")","v":212},{"$f":"OFFSET('DATA CP CON'!$J$5,B6,0)","v":33131},{"$f":"IF($B6=33,\"\",IF(C28=\"*\",\"\",C28*1000/D28))","v":6.3988409646554585},{"$f":"IF($B6=33,\"\",IF(C28=\"*\",\"\",IF(G28=\"*\",\"\",G28/C28-1)))","v":6.1320754716981174E-2},{"$f":"IF(B6<33,OFFSET('DATA CP CON'!$C$5,B6,0),\"\")","v":225},{"$f":"OFFSET('DATA CP CON'!$K$5,B6,0)","v":33511},{"$f":"IF($B6=33,\"\",IF(G28=\"*\",\"\",G28*1000/H28))","v":6.7142132434126109},{"$f":"IF($B6=33,\"\",IF(G28=\"*\",\"\",IF(K28=\"*\",\"\",K28/G28-1)))","v":-8.8888888888888906E-2},{"$f":"IF(B6<33,OFFSET('DATA CP CON'!$D$5,B6,0),\"\")","v":205},{"$f":"OFFSET('DATA CP CON'!$L$5,B6,0)","v":33851},{"$f":"IF($B6=33,\"\",IF(K28=\"*\",\"\",K28*1000/L28))","v":6.0559510797317655},{"$f":"IF($B6=33,\"\",IF(K28=\"*\",\"\",IF(O28=\"*\",\"\",O28/K28-1)))","v":-4.3902439024390283E-2},{"$f":"IF(B6<33,OFFSET('DATA CP CON'!$E$5,B6,0),\"\")","v":196},{"$f":"OFFSET('DATA CP CON'!$M$5,B6,0)","v":34187},{"$f":"IF($B6=33,\"\",IF(O28=\"*\",\"\",O28*1000/P28))","v":5.7331734284962117},{"$f":"IF($B6=33,\"\",IF(O28=\"*\",\"\",IF(S28=\"*\",\"\",S28/O28-1)))","v":4.5918367346938771E-2},{"$f":"IF(B6<33,OFFSET('DATA CP CON'!$F$5,B6,0),\"\")","v":205},{"$f":"OFFSET('DATA CP CON'!$N$5,B6,0)","v":34495},{"$f":"IF($B6=33,\"\",IF(S28=\"*\",\"\",S28*1000/T28))","v":5.9428902739527469},{"$f":"IF($B6=33,\"\",IF(S28=\"*\",\"\",IF(W28=\"*\",\"\",W28/S28-1)))","v":-0.14146341463414636},{"$f":"IF(B6<33,OFFSET('DATA CP CON'!$G$5,B6,0),\"\")","v":176},{"$f":"OFFSET('DATA CP CON'!$O$5,B6,0)","v":34833},{"$f":"IF($B6=33,\"\",IF(W28=\"*\",\"\",W28*1000/X28))","v":5.0526799299514824},{"$f":"IF($B6=33,\"\",IF(W28=\"*\",\"\",IF(AA28=\"*\",\"\",AA28/W28-1)))","v":0.18181818181818188},{"$f":"IF(B6<33,OFFSET('DATA CP CON'!$H$5,B6,0),\"\")","v":208},{"$f":"OFFSET('DATA CP CON'!$P$5,B6,0)","v":35423},{"$f":"IF($B6=33,\"\",IF(AA28=\"*\",\"\",AA28*1000/AB28))","v":5.8718911441718653},{"$f":"IF(B6<33,IF(RANK(AC28,'DATA CP CON'!$Y$6:$Y$37)<9,1,IF(RANK(AC28,'DATA CP CON'!$Y$6:$Y$37)<17,2,IF(RANK(AC28,'DATA CP CON'!$Y$6:$Y$37)<25,3,4))),\"\")","v":2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B7,0)","v":"Renfrewshire"},{"$f":"IF(B7<33,OFFSET('DATA CP CON'!$B$5,B7,0),\"\")","v":289},{"$f":"OFFSET('DATA CP CON'!$J$5,B7,0)","v":30113},{"$f":"IF($B7=33,\"\",IF(C29=\"*\",\"\",C29*1000/D29))","v":9.5971839404908188},{"$f":"IF($B7=33,\"\",IF(C29=\"*\",\"\",IF(G29=\"*\",\"\",G29/C29-1)))","v":-3.8062283737024249E-2},{"$f":"IF(B7<33,OFFSET('DATA CP CON'!$C$5,B7,0),\"\")","v":278},{"$f":"OFFSET('DATA CP CON'!$K$5,B7,0)","v":29973},{"$f":"IF($B7=33,\"\",IF(G29=\"*\",\"\",G29*1000/H29))","v":9.2750141794281529},{"$f":"IF($B7=33,\"\",IF(G29=\"*\",\"\",IF(K29=\"*\",\"\",K29/G29-1)))","v":-7.5539568345323715E-2},{"$f":"IF(B7<33,OFFSET('DATA CP CON'!$D$5,B7,0),\"\")","v":257},{"$f":"OFFSET('DATA CP CON'!$L$5,B7,0)","v":29831},{"$f":"IF($B7=33,\"\",IF(K29=\"*\",\"\",K29*1000/L29))","v":8.6151989541081431},{"$f":"IF($B7=33,\"\",IF(K29=\"*\",\"\",IF(O29=\"*\",\"\",O29/K29-1)))","v":-0.1400778210116731},{"$f":"IF(B7<33,OFFSET('DATA CP CON'!$E$5,B7,0),\"\")","v":221},{"$f":"OFFSET('DATA CP CON'!$M$5,B7,0)","v":29954},{"$f":"IF($B7=33,\"\",IF(O29=\"*\",\"\",O29*1000/P29))","v":7.3779795686719636},{"$f":"IF($B7=33,\"\",IF(O29=\"*\",\"\",IF(S29=\"*\",\"\",S29/O29-1)))","v":0.22171945701357476},{"$f":"IF(B7<33,OFFSET('DATA CP CON'!$F$5,B7,0),\"\")","v":270},{"$f":"OFFSET('DATA CP CON'!$N$5,B7,0)","v":30039},{"$f":"IF($B7=33,\"\",IF(S29=\"*\",\"\",S29*1000/T29))","v":8.9883151902526723},{"$f":"IF($B7=33,\"\",IF(S29=\"*\",\"\",IF(W29=\"*\",\"\",W29/S29-1)))","v":-0.21111111111111114},{"$f":"IF(B7<33,OFFSET('DATA CP CON'!$G$5,B7,0),\"\")","v":213},{"$f":"OFFSET('DATA CP CON'!$O$5,B7,0)","v":30171},{"$f":"IF($B7=33,\"\",IF(W29=\"*\",\"\",W29*1000/X29))","v":7.0597593715819826},{"$f":"IF($B7=33,\"\",IF(W29=\"*\",\"\",IF(AA29=\"*\",\"\",AA29/W29-1)))","v":0.16901408450704225},{"$f":"IF(B7<33,OFFSET('DATA CP CON'!$H$5,B7,0),\"\")","v":249},{"$f":"OFFSET('DATA CP CON'!$P$5,B7,0)","v":30267},{"$f":"IF($B7=33,\"\",IF(AA29=\"*\",\"\",AA29*1000/AB29))","v":8.2267816433739718},{"$f":"IF(B7<33,IF(RANK(AC29,'DATA CP CON'!$Y$6:$Y$37)<9,1,IF(RANK(AC29,'DATA CP CON'!$Y$6:$Y$37)<17,2,IF(RANK(AC29,'DATA CP CON'!$Y$6:$Y$37)<25,3,4))),\"\")","v":1}]
[]
[null,"Comparator authorities",{"$f":"SUM(C25:C29)","v":860},{"$f":"SUM(D25:D29)","v":116020},{"$f":"C31*1000/D31","v":7.4125150836062748},{"$f":"IF(C31=0,\"\",SUM(G25:G29)/SUM(C25:C29)-1)","v":3.6046511627906952E-2},{"$f":"SUM(G25:G29)","v":891},{"$f":"SUM(H25:H29)","v":116041},{"$f":"SUM(G25:G29)/SUM(H25:H29)*1000","v":7.6783205935833019},{"$f":"IF(G31=0,\"\",SUM(K25:K29)/SUM(G25:G29)-1)","v":-2.0202020202020221E-2},{"$f":"SUM(K25:K29)","v":873},{"$f":"SUM(L25:L29)","v":116155},{"$f":"SUM(K25:K29)/SUM(L25:L29)*1000","v":7.5158193792776888},{"$f":"IF(K31=0,\"\",SUM(O25:O29)/SUM(K25:K29)-1)","v":-1.9473081328751474E-2},{"$f":"SUM(O25:O29)","v":856},{"$f":"SUM(P25:P29)","v":116605},{"$f":"SUM(O25:O29)/SUM(P25:P29)*1000","v":7.3410231122164573},{"$f":"IF(O31=0,\"\",SUM(S25:S29)/SUM(O25:O29)-1)","v":0.13668224299065423},{"$f":"SUM(S25:S29)","v":973},{"$f":"SUM(T25:T29)","v":117023},{"$f":"SUM(S25:S29)/SUM(T25:T29)*1000","v":8.3146048212744503},{"$f":"IF(S31=0,\"\",SUM(W25:W29)/SUM(S25:S29)-1)","v":-0.13977389516957861},{"$f":"SUM(W25:W29)","v":837},{"$f":"SUM(X25:X29)","v":117353},{"$f":"SUM(W25:W29)/SUM(X25:X29)*1000","v":7.1323272519662897},{"$f":"IF(W31=0,\"\",SUM(AA25:AA29)/SUM(W25:W29)-1)","v":6.5710872162485057E-2},{"$f":"SUM(AA25:AA29)","v":892},{"$f":"SUM(AB25:AB29)","v":117984},{"$f":"SUM(AA25:AA29)/SUM(AB25:AB29)*1000","v":7.5603471657173857}]
[]
[null,"Scotland(1,2)",{"$f":"'DATA CP CON'!B38","v":5601},{"$f":"'DATA CP CON'!J38","v":911579},{"$f":"C33*1000/D33","v":6.144283709914335},{"$f":"IF(C33=0,\"\",G33/C33-1)","v":5.0169612569184174E-2},{"$f":"'DATA CP CON'!C38","v":5882},{"$f":"'DATA CP CON'!K38","v":911041},{"$f":"G33*1000/H33","v":6.4563504825798184},{"$f":"IF(G33=0,\"\",K33/G33-1)","v":3.0431825909554622E-2},{"$f":"'DATA CP CON'!D38","v":6061},{"$f":"'DATA CP CON'!L38","v":912262},{"$f":"K33*1000/L33","v":6.6439246619940322},{"$f":"IF(K33=0,\"\",O33/K33-1)","v":-5.8406203596766182E-2},{"$f":"'DATA CP CON'!E38","v":5707},{"$f":"'DATA CP CON'!$M$38","v":915917},{"$f":"O33*1000/P33","v":6.2309139365248161},{"$f":"IF(O33=0,\"\",S33/O33-1)","v":-1.0162957771158276E-2},{"$f":"'DATA CP CON'!F38","v":5649},{"$f":"'DATA CP CON'!$N$38","v":917442},{"$f":"S33*1000/T33","v":6.1573374665646439},{"$f":"IF(S33=0,\"\",W33/S33-1)","v":1.0621348911312722E-3},{"$f":"'DATA CP CON'!G38","v":5655},{"$f":"'DATA CP CON'!$O$38","v":919502},{"$f":"W33*1000/X33","v":6.1500681890849611},{"$f":"IF(W33=0,\"\",AA33/W33-1)","v":-2.2988505747126409E-2},{"$f":"'DATA CP CON'!H38","v":5525},{"$f":"'DATA CP CON'!P38","v":921397},{"$f":"AA33*1000/AB33","v":5.9963294866382242}]
[]
["Notes"]
[{"$f":"IF('DATA CP CON'!A40=\"\",\"\",'DATA CP CON'!A40)","v":"Figures for 2019 are provisional and may be revised with the publication of 2020 statistics."}]
[{"$f":"IF('DATA CP CON'!A41=\"\",\"\",'DATA CP CON'!A41)","v":"Cells containing * represent numbers that are supressed to maintain confidentiality."}]
[{"$f":"IF('DATA CP CON'!A42=\"\",\"\",'DATA CP CON'!A42)","v":"Population figures source: NRS mid-year population estimates for 2013-2019."}]
[{"$f":"IF('DATA CP CON'!A43=\"\",\"\",'DATA CP CON'!A43)","v":"Source: Scottish Government CP Returns"}]
[{"$f":"IF('DATA CP CON'!A44=\"\",\"\",'DATA CP CON'!A44)","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V22-V31","v":8.434493349032457E-3},null,null,{"$f":"Y22-Y31","v":-0.44818308258127093},{"$f":"Z22-Z31","v":-5.8306326415269449E-3},null,null,{"$f":"AC22-AC31","v":-0.52718800572294899},{"$f":"IF(AC43<-0.5,\"less than\",IF(AC43>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,null,{"$f":"V22-V33","v":-0.13240153671167743},null,null,{"$f":"Y22-Y33","v":0.53407598030005765},{"$f":"Z23-Z33","v":2.2988505747126409E-2},null,null,{"$f":"AC22-AC33","v":1.0368296733562126},{"$f":"IF(AC44<-0.5,\"less than\",IF(AC44>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,null,null,null,null,null,{"$f":"W22-S22","v":-101},null,null,null,{"$f":"AA22-W22","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V46<0,\"a decrease of \",IF(V46>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z46<0,\"a decrease of \",IF(Z46>=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,null,{"$f":"IF(V31<0,\"a decrease of \",IF(V31>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z31<0,\"a decrease of \",IF(Z31>=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,null,{"$f":"IF(V33<0,\"a decrease of \",IF(V33>=0,\"an increase of \"))","v":"an increase of "},null,null,null,{"$f":"IF(Z33<0,\"a decrease of \",IF(Z33>=0,\"an increase of \"))","v":"a decrease of "}]

{"sheet":"CP registrations","index":2,"n_rows":50,"n_cols":30,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,1,12,6],[13,1,14,6],[15,1,17,6]]}
[{"$f":"'DATA CP REG'!A1","v":"Child Protection: Registrations: 31 July 2013-2019"}]
[null,null,"select comparators:"]
[null,{"$f":"J3","v":8},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":8}]
[null,{"$f":"J4","v":31},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":31}]
[null,{"$f":"J5","v":17},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":17}]
[null,{"$f":"J6","v":1},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":1}]
[null,{"$f":"J7","v":25},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":25}]
[]
[]
[]
[]
[null,{"$f":"IF(AA22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Z22=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The number of registrations following a case conference in \"&B22&\" in \"&AA20&\" was \"&ROUND(AA22,0)&\" (\"&Z47&ROUND((SQRT((Z22*100)^2)),1)&\"% from \"&ROUND(W22,0)&\" in \"&W20&\")\"))","v":"*  The number of registrations following a case conference in Glasgow City in 2019 was 533 (an increase of 29.7% from 411 in 2018)"}]
[]
[null,{"$f":"IF(Z31=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&Z49&ROUND(SQRT((Z31*100)^2),1)&\"%, while the Scotland figures show \"&Z50&ROUND(SQRT((100*Z33)^2),1)&\"%\")","v":"*  The comparator authorities show an increase of 10.6%, while the Scotland figures show an increase of 1.1%"}]
[]
[null,{"$f":"IF(AC22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(AC31=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The rate (per 1,000 pop 0-15) is \"&ROUND(AC22,1)&\".  This is \"&AD43&\" the comparator average rate of \"&ROUND(AC31,1)&\", and \"&AD44&\" the Scotland average rate of \"&ROUND(AC33,1)))","v":"*  The rate (per 1,000 pop 0-15) is 5.3.  This is similar to the comparator average rate of 5.3, and greater than the Scotland average rate of 4.7"}]
[]
[]
[]
[null,null,{"$f":"'DATA CP REG'!B5","v":2013},null,null,null,{"$f":"'DATA CP REG'!C5","v":2014},null,null,null,{"$f":"'DATA CP REG'!D5","v":2015},null,null,null,{"$f":"'DATA CP REG'!E5","v":2016},null,null,null,{"$f":"'DATA CP REG'!F5","v":2017},null,null,null,{"$f":"'DATA CP REG'!G5","v":2018},null,null,null,{"$f":"'DATA CP REG'!H5","v":2019}]
[null,null,{"$f":"'DATA CP REG'!B4","v":0},{"$f":"'DATA CP REG'!J4","v":0},"rate","% change",{"$f":"'DATA CP REG'!C4","v":0},{"$f":"'DATA CP REG'!K4","v":0},"rate","% change",{"$f":"'DATA CP REG'!D4","v":0},{"$f":"'DATA CP REG'!L4","v":0},"rate","% change",{"$f":"'DATA CP REG'!E4","v":0},{"$f":"'DATA CP REG'!M4","v":0},"rate","% change",{"$f":"'DATA CP REG'!F4","v":0},{"$f":"'DATA CP REG'!N4","v":0},"rate","% change",{"$f":"'DATA CP REG'!G4","v":0},{"$f":"'DATA CP REG'!O4","v":0},"rate","% change",{"$f":"'DATA CP REG'!H4","v":0},{"$f":"'DATA CP REG'!P4","v":0},"rate","quartile"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Glasgow City"},{"$f":"OFFSET('DATA CP REG'!$B$5,'Select an authority'!$A$1,0)","v":633},null,{"$f":"OFFSET('DATA CP REG'!$S$5,'Select an authority'!$A$1,0)","v":6.5631901458832314},{"$f":"IF(C22=0,\"\",G22/C22-1)","v":0.11848341232227488},{"$f":"OFFSET('DATA CP REG'!$C$5,'Select an authority'!$A$1,0)","v":708},null,{"$f":"OFFSET('DATA CP REG'!$T$5,'Select an authority'!$A$1,0)","v":7.3209318677682536},{"$f":"IF(G22=0,\"\",K22/G22-1)","v":3.2485875706214751E-2},{"$f":"OFFSET('DATA CP REG'!$D$5,'Select an authority'!$A$1,0)","v":731},null,{"$f":"OFFSET('DATA CP REG'!$U$5,'Select an authority'!$A$1,0)","v":7.4949760078743388},{"$f":"IF(K22=0,\"\",O22/K22-1)","v":-0.18057455540355682},{"$f":"OFFSET('DATA CP REG'!$E$5,'Select an authority'!$A$1,0)","v":599},null,{"$f":"OFFSET('DATA CP REG'!$V$5,'Select an authority'!$A$1,0)","v":6.0820209773878782},{"$f":"IF(O22=0,\"\",S22/O22-1)","v":-0.18530884808013359},{"$f":"OFFSET('DATA CP REG'!$F$5,'Select an authority'!$A$1,0)","v":488},null,{"$f":"OFFSET('DATA CP REG'!$W$5,'Select an authority'!$A$1,0)","v":4.9224810111260178},{"$f":"IF(S22=0,\"\",W22/S22-1)","v":-0.15778688524590168},{"$f":"OFFSET('DATA CP REG'!$G$5,'Select an authority'!$A$1,0)","v":411},null,{"$f":"OFFSET('DATA CP REG'!$X$5,'Select an authority'!$A$1,0)","v":4.1125497808641356},{"$f":"IF(W22=0,\"\",AA22/W22-1)","v":0.29683698296836991},{"$f":"OFFSET('DATA CP REG'!$H$5,'Select an authority'!$A$1,0)","v":533},null,{"$f":"OFFSET('DATA CP REG'!$Y$5,'Select an authority'!$A$1,0)","v":5.2947370512387497},{"$f":"IF(AC22=\"*\",\"\",IF(RANK(AC22,'DATA CP REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC22,'DATA CP REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC22,'DATA CP REG'!$Y$6:$Y$37)<25,3,4))))","v":2}]
[]
["Comparator Authorities:"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2, B3,0)","v":"Dundee City"},{"$f":"IF(B3<33,OFFSET('DATA CP REG'!$B$5,$B3,0),\" \")","v":122},{"$f":"OFFSET('DATA CP REG'!$J$5,$B3,0)","v":23753},{"$f":"IF($B3=33,\"\",C25*1000/D25)","v":5.1361933229486798},{"$f":"IF($B3=33,\"\",IF(C25=0,\"\",G25/C25-1))","v":8.1967213114754189E-2},{"$f":"IF(B3<33,OFFSET('DATA CP REG'!$C$5,$B3,0),\"\")","v":132},{"$f":"OFFSET('DATA CP REG'!$K$5,$B3,0)","v":23716},{"$f":"IF($B3=33,\"\",G25*1000/H25)","v":5.5658627087198518},{"$f":"IF($B3=33,\"\",IF(G25=0,\"\",K25/G25-1))","v":-4.5454545454545414E-2},{"$f":"IF(B3<33,OFFSET('DATA CP REG'!$D$5,$B3,0),\"\")","v":126},{"$f":"OFFSET('DATA CP REG'!$L$5,$B3,0)","v":23798},{"$f":"IF($B3=33,\"\",K25*1000/L25)","v":5.2945625682830491},{"$f":"IF($B3=33,\"\",IF(K25=0,\"\",O25/K25-1))","v":0.19841269841269837},{"$f":"IF(B3<33,OFFSET('DATA CP REG'!$E$5,$B3,0),\"\")","v":151},{"$f":"OFFSET('DATA CP REG'!$M$5,$B3,0)","v":23849},{"$f":"IF($B3=33,\"\",O25*1000/P25)","v":6.3315023690720782},{"$f":"IF($B3=33,\"\",IF(O25=0,\"\",S25/O25-1))","v":-5.2980132450331174E-2},{"$f":"IF(B3<33,OFFSET('DATA CP REG'!$F$5,$B3,0),\"\")","v":143},{"$f":"OFFSET('DATA CP REG'!$N$5,$B3,0)","v":23998},{"$f":"IF($B3=33,\"\",S25*1000/T25)","v":5.9588299024918747},{"$f":"IF($B3=33,\"\",IF(S25=0,\"\",W25/S25-1))","v":-6.9930069930069783E-3},{"$f":"IF(B3<33,OFFSET('DATA CP REG'!$G$5,$B3,0),\"\")","v":142},{"$f":"OFFSET('DATA CP REG'!$O$5,$B3,0)","v":24016},{"$f":"IF($B3=33,\"\",W25*1000/X25)","v":5.9127248500999334},{"$f":"IF($B3=33,\"\",IF(W25=0,\"\",AA25/W25-1))","v":0.18309859154929575},{"$f":"IF(B3<33,OFFSET('DATA CP REG'!$H$5,$B3,0),\"\")","v":168},{"$f":"OFFSET('DATA CP REG'!$P$5,$B3,0)","v":24044},{"$f":"IF($B3=33,\"\",AA25*1000/AB25)","v":6.9871901513891199},{"$f":"IF(AC25=\"*\",\"\",IF(B3<33,IF(RANK(AC25,'DATA CP REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC25,'DATA CP REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC25,'DATA CP REG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":1}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B4,0)","v":"West Dunbartonshire"},{"$f":"IF(B4<33,OFFSET('DATA CP REG'!$B$5,$B4,0),\"\")","v":62},{"$f":"OFFSET('DATA CP REG'!$J$5,$B4,0)","v":15782},{"$f":"IF($B4=33,\"\",C26*1000/D26)","v":3.9285261690533519},{"$f":"IF($B4=33,\"\",IF(C26=0,\"\",G26/C26-1))","v":4.8387096774193505E-2},{"$f":"IF(B4<33,OFFSET('DATA CP REG'!$C$5,$B4,0),\"\")","v":65},{"$f":"OFFSET('DATA CP REG'!$K$5,$B4,0)","v":15698},{"$f":"IF($B4=33,\"\",G26*1000/H26)","v":4.1406548604917823},{"$f":"IF($B4=33,\"\",IF(G26=0,\"\",K26/G26-1))","v":-0.10769230769230764},{"$f":"IF(B4<33,OFFSET('DATA CP REG'!$D$5,$B4,0),\"\")","v":58},{"$f":"OFFSET('DATA CP REG'!$L$5,$B4,0)","v":15709},{"$f":"IF($B4=33,\"\",K26*1000/L26)","v":3.6921509962441914},{"$f":"IF($B4=33,\"\",IF(K26=0,\"\",O26/K26-1))","v":0.32758620689655182},{"$f":"IF(B4<33,OFFSET('DATA CP REG'!$E$5,$B4,0),\"\")","v":77},{"$f":"OFFSET('DATA CP REG'!$M$5,$B4,0)","v":15764},{"$f":"IF($B4=33,\"\",O26*1000/P26)","v":4.8845470692717585},{"$f":"IF($B4=33,\"\",IF(O26=0,\"\",S26/O26-1))","v":0.66233766233766245},{"$f":"IF(B4<33,OFFSET('DATA CP REG'!$F$5,$B4,0),\"\")","v":128},{"$f":"OFFSET('DATA CP REG'!$N$5,$B4,0)","v":15790},{"$f":"IF($B4=33,\"\",S26*1000/T26)","v":8.106396453451552},{"$f":"IF($B4=33,\"\",IF(S26=0,\"\",W26/S26-1))","v":-0.2578125},{"$f":"IF(B4<33,OFFSET('DATA CP REG'!$G$5,$B4,0),\"\")","v":95},{"$f":"OFFSET('DATA CP REG'!$O$5,$B4,0)","v":15705},{"$f":"IF($B4=33,\"\",W26*1000/X26)","v":6.0490289716650745},{"$f":"IF($B4=33,\"\",IF(W26=0,\"\",AA26/W26-1))","v":-0.25263157894736843},{"$f":"IF(B4<33,OFFSET('DATA CP REG'!$H$5,$B4,0),\"\")","v":71},{"$f":"OFFSET('DATA CP REG'!$P$5,$B4,0)","v":15647},{"$f":"IF($B4=33,\"\",AA26*1000/AB26)","v":4.5376110436505401},{"$f":"IF(AC26=\"*\",\"\",IF(B4<33,IF(RANK(AC26,'DATA CP REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC26,'DATA CP REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC26,'DATA CP REG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":3}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B5,0)","v":"Inverclyde"},{"$f":"IF(B5<33,OFFSET('DATA CP REG'!$B$5,$B5,0),\"\")","v":48},{"$f":"OFFSET('DATA CP REG'!$J$5,$B5,0)","v":13241},{"$f":"IF($B5=33,\"\",C27*1000/D27)","v":3.6251038441205345},{"$f":"IF($B5=33,\"\",IF(C27=0,\"\",G27/C27-1))","v":0.41666666666666674},{"$f":"IF(B5<33,OFFSET('DATA CP REG'!$C$5,$B5,0),\"\")","v":68},{"$f":"OFFSET('DATA CP REG'!$K$5,$B5,0)","v":13143},{"$f":"IF($B5=33,\"\",G27*1000/H27)","v":5.1738568059042835},{"$f":"IF($B5=33,\"\",IF(G27=0,\"\",K27/G27-1))","v":-0.13235294117647056},{"$f":"IF(B5<33,OFFSET('DATA CP REG'!$D$5,$B5,0),\"\")","v":59},{"$f":"OFFSET('DATA CP REG'!$L$5,$B5,0)","v":12966},{"$f":"IF($B5=33,\"\",K27*1000/L27)","v":4.550362486503162},{"$f":"IF($B5=33,\"\",IF(K27=0,\"\",O27/K27-1))","v":-3.3898305084745783E-2},{"$f":"IF(B5<33,OFFSET('DATA CP REG'!$E$5,$B5,0),\"\")","v":57},{"$f":"OFFSET('DATA CP REG'!$M$5,$B5,0)","v":12851},{"$f":"IF($B5=33,\"\",O27*1000/P27)","v":4.4354524939693407},{"$f":"IF($B5=33,\"\",IF(O27=0,\"\",S27/O27-1))","v":-0.17543859649122806},{"$f":"IF(B5<33,OFFSET('DATA CP REG'!$F$5,$B5,0),\"\")","v":47},{"$f":"OFFSET('DATA CP REG'!$N$5,$B5,0)","v":12701},{"$f":"IF($B5=33,\"\",S27*1000/T27)","v":3.700496023935123},{"$f":"IF($B5=33,\"\",IF(S27=0,\"\",W27/S27-1))","v":6.3829787234042534E-2},{"$f":"IF(B5<33,OFFSET('DATA CP REG'!$G$5,$B5,0),\"\")","v":50},{"$f":"OFFSET('DATA CP REG'!$O$5,$B5,0)","v":12628},{"$f":"IF($B5=33,\"\",W27*1000/X27)","v":3.959455178967374},{"$f":"IF($B5=33,\"\",IF(W27=0,\"\",AA27/W27-1))","v":0.28000000000000003},{"$f":"IF(B5<33,OFFSET('DATA CP REG'!$H$5,$B5,0),\"\")","v":64},{"$f":"OFFSET('DATA CP REG'!$P$5,$B5,0)","v":12603},{"$f":"IF($B5=33,\"\",AA27*1000/AB27)","v":5.078155994604459},{"$f":"IF(AC27=\"*\",\"\",IF(B5<33,IF(RANK(AC27,'DATA CP REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC27,'DATA CP REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC27,'DATA CP REG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B6,0)","v":"Aberdeen City"},{"$f":"IF(B6<33,OFFSET('DATA CP REG'!$B$5,$B6,0),\"\")","v":170},{"$f":"OFFSET('DATA CP REG'!$J$5,$B6,0)","v":33131},{"$f":"IF($B6=33,\"\",C28*1000/D28)","v":5.1311460565633391},{"$f":"IF($B6=33,\"\",IF(C28=0,\"\",G28/C28-1))","v":-1.764705882352946E-2},{"$f":"IF(B6<33,OFFSET('DATA CP REG'!$C$5,$B6,0),\"\")","v":167},{"$f":"OFFSET('DATA CP REG'!$K$5,$B6,0)","v":33511},{"$f":"IF($B6=33,\"\",G28*1000/H28)","v":4.9834382739995826},{"$f":"IF($B6=33,\"\",IF(G28=0,\"\",K28/G28-1))","v":-4.7904191616766512E-2},{"$f":"IF(B6<33,OFFSET('DATA CP REG'!$D$5,$B6,0),\"\")","v":159},{"$f":"OFFSET('DATA CP REG'!$L$5,$B6,0)","v":33851},{"$f":"IF($B6=33,\"\",K28*1000/L28)","v":4.6970547398895155},{"$f":"IF($B6=33,\"\",IF(K28=0,\"\",O28/K28-1))","v":-1.8867924528301883E-2},{"$f":"IF(B6<33,OFFSET('DATA CP REG'!$E$5,$B6,0),\"\")","v":156},{"$f":"OFFSET('DATA CP REG'!$M$5,$B6,0)","v":34187},{"$f":"IF($B6=33,\"\",O28*1000/P28)","v":4.5631380349255561},{"$f":"IF($B6=33,\"\",IF(O28=0,\"\",S28/O28-1))","v":5.1282051282051322E-2},{"$f":"IF(B6<33,OFFSET('DATA CP REG'!$F$5,$B6,0),\"\")","v":164},{"$f":"OFFSET('DATA CP REG'!$N$5,$B6,0)","v":34495},{"$f":"IF($B6=33,\"\",S28*1000/T28)","v":4.7543122191621974},{"$f":"IF($B6=33,\"\",IF(S28=0,\"\",W28/S28-1))","v":-8.536585365853655E-2},{"$f":"IF(B6<33,OFFSET('DATA CP REG'!$G$5,$B6,0),\"\")","v":150},{"$f":"OFFSET('DATA CP REG'!$O$5,$B6,0)","v":34833},{"$f":"IF($B6=33,\"\",W28*1000/X28)","v":4.3062613039359228},{"$f":"IF($B6=33,\"\",IF(W28=0,\"\",AA28/W28-1))","v":8.0000000000000071E-2},{"$f":"IF(B6<33,OFFSET('DATA CP REG'!$H$5,$B6,0),\"\")","v":162},{"$f":"OFFSET('DATA CP REG'!$P$5,$B6,0)","v":35423},{"$f":"IF($B6=33,\"\",AA28*1000/AB28)","v":4.5732998334415491},{"$f":"IF(AC28=\"*\",\"\",IF(B6<33,IF(RANK(AC28,'DATA CP REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC28,'DATA CP REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC28,'DATA CP REG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B7,0)","v":"Renfrewshire"},{"$f":"IF(B7<33,OFFSET('DATA CP REG'!$B$5,$B7,0),\"\")","v":191},{"$f":"OFFSET('DATA CP REG'!$J$5,$B7,0)","v":30113},{"$f":"IF($B7=33,\"\",C29*1000/D29)","v":6.3427755454454884},{"$f":"IF($B7=33,\"\",IF(C29=0,\"\",G29/C29-1))","v":-0.2827225130890052},{"$f":"IF(B7<33,OFFSET('DATA CP REG'!$C$5,$B7,0),\"\")","v":137},{"$f":"OFFSET('DATA CP REG'!$K$5,$B7,0)","v":29973},{"$f":"IF($B7=33,\"\",G29*1000/H29)","v":4.5707803689987658},{"$f":"IF($B7=33,\"\",IF(G29=0,\"\",K29/G29-1))","v":1.4598540145985384E-2},{"$f":"IF(B7<33,OFFSET('DATA CP REG'!$D$5,$B7,0),\"\")","v":139},{"$f":"OFFSET('DATA CP REG'!$L$5,$B7,0)","v":29831},{"$f":"IF($B7=33,\"\",K29*1000/L29)","v":4.659582313700513},{"$f":"IF($B7=33,\"\",IF(K29=0,\"\",O29/K29-1))","v":-4.3165467625899234E-2},{"$f":"IF(B7<33,OFFSET('DATA CP REG'!$E$5,$B7,0),\"\")","v":133},{"$f":"OFFSET('DATA CP REG'!$M$5,$B7,0)","v":29954},{"$f":"IF($B7=33,\"\",O29*1000/P29)","v":4.4401415503772448},{"$f":"IF($B7=33,\"\",IF(O29=0,\"\",S29/O29-1))","v":0.45864661654135341},{"$f":"IF(B7<33,OFFSET('DATA CP REG'!$F$5,$B7,0),\"\")","v":194},{"$f":"OFFSET('DATA CP REG'!$N$5,$B7,0)","v":30039},{"$f":"IF($B7=33,\"\",S29*1000/T29)","v":6.4582709144778452},{"$f":"IF($B7=33,\"\",IF(S29=0,\"\",W29/S29-1))","v":-0.34020618556701032},{"$f":"IF(B7<33,OFFSET('DATA CP REG'!$G$5,$B7,0),\"\")","v":128},{"$f":"OFFSET('DATA CP REG'!$O$5,$B7,0)","v":30171},{"$f":"IF($B7=33,\"\",W29*1000/X29)","v":4.2424845049882336},{"$f":"IF($B7=33,\"\",IF(W29=0,\"\",AA29/W29-1))","v":0.25},{"$f":"IF(B7<33,OFFSET('DATA CP REG'!$H$5,$B7,0),\"\")","v":160},{"$f":"OFFSET('DATA CP REG'!$P$5,$B7,0)","v":30267},{"$f":"IF($B7=33,\"\",AA29*1000/AB29)","v":5.2862853933326726},{"$f":"IF(AC29=\"*\",\"\",IF(B7<33,IF(RANK(AC29,'DATA CP REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC29,'DATA CP REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC29,'DATA CP REG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":2}]
[]
[null,"Comparator authorities",{"$f":"SUM(C25:C29)","v":593},{"$f":"SUM(D25:D29)","v":116020},{"$f":"1000*C31/(SUMIF(C25,\">0\",D25)+SUMIF(C26,\">0\",D26)+SUMIF(C27,\">0\",D27)+SUMIF(C28,\">0\",D28)+SUMIF(C29,\">0\",D29))","v":5.1111877262540943},{"$f":"IF(C31=0,\"\",SUM(G25:G29)/SUM(C25:C29)-1)","v":-4.04721753794266E-2},{"$f":"SUM(G25:G29)","v":569},{"$f":"SUM(H25:H29)","v":116041},{"$f":"1000*G31/(SUMIF(G25,\">0\",H25)+SUMIF(G26,\">0\",H26)+SUMIF(G27,\">0\",H27)+SUMIF(G28,\">0\",H28)+SUMIF(G29,\">0\",H29))","v":4.9034393016261495},{"$f":"IF(G31=0,\"\",SUM(K25:K29)/SUM(G25:G29)-1)","v":-4.9209138840070277E-2},{"$f":"SUM(K25:K29)","v":541},{"$f":"SUM(L25:L29)","v":116155},{"$f":"1000*K31/(SUMIF(K25,\">0\",L25)+SUMIF(K26,\">0\",L26)+SUMIF(K27,\">0\",L27)+SUMIF(K28,\">0\",L28)+SUMIF(K29,\">0\",L29))","v":4.657569626791787},{"$f":"IF(K31=0,\"\",SUM(O25:O29)/SUM(K25:K29)-1)","v":6.0998151571164616E-2},{"$f":"SUM(O25:O29)","v":574},{"$f":"SUM(P25:P29)","v":116605},{"$f":"1000*O31/(SUMIF(O25,\">0\",P25)+SUMIF(O26,\">0\",P26)+SUMIF(O27,\">0\",P27)+SUMIF(O28,\">0\",P28)+SUMIF(O29,\">0\",P29))","v":4.9226019467432787},{"$f":"IF(O31=0,\"\",SUM(S25:S29)/SUM(O25:O29)-1)","v":0.17770034843205584},{"$f":"SUM(S25:S29)","v":676},{"$f":"SUM(T25:T29)","v":117023},{"$f":"1000*S31/(SUMIF(S25,\">0\",T25)+SUMIF(S26,\">0\",T26)+SUMIF(S27,\">0\",T27)+SUMIF(S28,\">0\",T28)+SUMIF(S29,\">0\",T29))","v":5.7766421985421665},{"$f":"IF(S31=0,\"\",SUM(W25:W29)/SUM(S25:S29)-1)","v":-0.16420118343195267},{"$f":"SUM(W25:W29)","v":565},{"$f":"SUM(X25:X29)","v":117353},{"$f":"1000*W31/(SUMIF(W25,\">0\",X25)+SUMIF(W26,\">0\",X26)+SUMIF(W27,\">0\",X27)+SUMIF(W28,\">0\",X28)+SUMIF(W29,\">0\",X29))","v":4.8145339275519161},{"$f":"IF(W31=0,\"\",SUM(AA25:AA29)/SUM(W25:W29)-1)","v":0.10619469026548667},{"$f":"SUM(AA25:AA29)","v":625},{"$f":"SUM(AB25:AB29)","v":117984},{"$f":"1000*AA31/(SUMIF(AA25,\">0\",AB25)+SUMIF(AA26,\">0\",AB26)+SUMIF(AA27,\">0\",AB27)+SUMIF(AA28,\">0\",AB28)+SUMIF(AA29,\">0\",AB29))","v":5.2973284513154324}]
[]
[null,"Scotland(1,2)",{"$f":"'DATA CP REG'!$B$38","v":4251},{"$f":"'DATA CP REG'!$J$38","v":911579},{"$f":"C33*1000/D33","v":4.6633369132022571},{"$f":"IF(C33=0,\"\",G33/C33-1)","v":8.727358268642682E-2},{"$f":"'DATA CP REG'!$C$38","v":4622},{"$f":"'DATA CP REG'!$K$38","v":911041},{"$f":"G33*1000/H33","v":5.0733172272158988},{"$f":"IF(G33=0,\"\",K33/G33-1)","v":-4.7814798788403334E-2},{"$f":"'DATA CP REG'!$D$38","v":4401},{"$f":"'DATA CP REG'!$L$38","v":912262},{"$f":"K33*1000/L33","v":4.8242719744985543},{"$f":"IF(K33=0,\"\",O33/K33-1)","v":-2.9084299022949289E-2},{"$f":"'DATA CP REG'!$E$38","v":4273},{"$f":"'DATA CP REG'!$M$38","v":915917},{"$f":"O33*1000/P33","v":4.665269887992034},{"$f":"IF(O33=0,\"\",S33/O33-1)","v":3.2763866136205078E-3},{"$f":"'DATA CP REG'!$F$38","v":4287},{"$f":"'DATA CP REG'!$N$38","v":917442},{"$f":"S33*1000/T33","v":4.6727749547110333},{"$f":"IF(S33=0,\"\",W33/S33-1)","v":-9.5637975274084353E-3},{"$f":"'DATA CP REG'!$G$38","v":4246},{"$f":"'DATA CP REG'!$O$38","v":919502},{"$f":"W33*1000/X33","v":4.6177169815835093},{"$f":"IF(W33=0,\"\",AA33/W33-1)","v":1.1069241639189764E-2},{"$f":"'DATA CP REG'!$H$38","v":4293},{"$f":"'DATA CP REG'!$P$38","v":921397},{"$f":"AA33*1000/AB33","v":4.6592294092557278}]
[]
["Notes"]
[{"$f":"IF('DATA CP REG'!A40=\"\",\"\",'DATA CP REG'!A40)","v":"Figures for 2019 are provisional and may be revised with the publication of 2020 statistics."}]
[{"$f":"IF('DATA CP REG'!A41=\"\",\"\",'DATA CP REG'!A41)","v":"Cells containing * represent numbers that are supressed to maintain confidentiality."}]
[{"$f":"IF('DATA CP REG'!A42=\"\",\"\",'DATA CP REG'!A42)","v":"Population figures source: NRS mid-year population estimates for 2013-2019."}]
[{"$f":"IF('DATA CP REG'!A43=\"\",\"\",'DATA CP REG'!A43)","v":"Source: Scottish Government CP Returns"}]
[{"$f":"IF('DATA CP REG'!A44=\"\",\"\",'DATA CP REG'!A44)","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V22-V31","v":6.4142981860509929E-3},null,null,{"$f":"Y22-Y31","v":-0.70198414668778053},{"$f":"Z22-Z31","v":0.19064229270288324},null,null,{"$f":"AC22-AC31","v":-2.5914000766826817E-3},{"$f":"IF(AC43<-0.5,\"less than\",IF(AC43>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,null,{"$f":"V22-V33","v":-0.14822308771849324},null,null,{"$f":"Y22-Y33","v":-0.50516720071937371},{"$f":"Z22-Z33","v":0.28576774132918015},null,null,{"$f":"AC22-AC33","v":0.6355076419830219},{"$f":"IF(AC44<-0.5,\"less than\",IF(AC44>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,null,null,null,null,null,{"$f":"W22-S22","v":-77},null,null,null,{"$f":"AA22-W22","v":122}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V46<0,\"a decrease of \",IF(V46>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z46<0,\"a decrease of \",IF(Z46>=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,null,{"$f":"IF(V31<0,\"a decrease of \",IF(V31>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z31<0,\"a decrease of \",IF(Z31>=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,null,{"$f":"IF(V33<0,\"a decrease of \",IF(V33>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z33<0,\"a decrease of \",IF(Z33>=0,\"an increase of \"))","v":"an increase of "}]

{"sheet":"CP de-registrations","index":3,"n_rows":50,"n_cols":30,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,1,12,6],[13,1,14,6],[15,1,17,6]]}
[{"$f":"'DATA CP DEREG'!A1","v":"Child Protection: De-registrations: 31 July 2013-2019"}]
[]
[null,{"$f":"J3","v":8},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":8},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":8}]
[null,{"$f":"J4","v":31},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":31},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":31}]
[null,{"$f":"J5","v":17},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":17},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":17}]
[null,{"$f":"J6","v":1},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":1},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":1}]
[null,{"$f":"J7","v":25},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":25},null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":25}]
[]
[]
[]
[]
[null,{"$f":"IF(AA22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Z22=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The number of de-registrations in \"&B22&\" in \"&AA20&\" is \"&ROUND(AA22,0)&\" (\"&Z47&ROUND((SQRT((Z22*100)^2)),1)&\"% from \"&ROUND(W22,0)&\" in \"&W20&\")\"))","v":"*  The number of de-registrations in Glasgow City in 2019 is 427 (a decrease of 15.9% from 508 in 2018)"}]
[]
[null,{"$f":"IF(Z31=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&Z49&ROUND(SQRT((Z31*100)^2),1)&\"%, while the estimated Scotland figures show \"&Z50&ROUND(SQRT((100*Z33)^2),1)&\"%\")","v":"*  The comparator authorities show a decrease of 3.9%, while the estimated Scotland figures show a decrease of 2.1%"}]
[]
[null,{"$f":"IF(AC22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(AC31=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The rate (per 1,000 pop 0-15) is \"&ROUND(AC22,1)&\".  This is \"&AD43&\" the comparator average rate of \"&ROUND(AC31,1)&\", and \"&AD44&\" the estimated AJ7Scotland average rate of \"&ROUND(AC33,1)))","v":"*  The rate (per 1,000 pop 0-15) is 4.2.  This is less than the comparator average rate of 4.8, and similar to the estimated AJ7Scotland average rate of 4.6"}]
[]
[]
[]
[null,null,{"$f":"'DATA CP DEREG'!B5","v":2013},null,null,null,{"$f":"'DATA CP DEREG'!C5","v":2014},null,null,null,{"$f":"'DATA CP DEREG'!D5","v":2015},null,null,null,{"$f":"'DATA CP DEREG'!E5","v":2016},null,null,null,{"$f":"'DATA CP DEREG'!F5","v":2017},null,null,null,{"$f":"'DATA CP DEREG'!G5","v":2018},null,null,null,{"$f":"'DATA CP DEREG'!H5","v":2019}]
[null,null,"Number",{"$f":"'DATA CP DEREG'!J4","v":0},"rate","% change",{"$f":"C21","v":"Number"},{"$f":"'DATA CP DEREG'!K4","v":0},"rate","% change",{"$f":"G21","v":"Number"},{"$f":"'DATA CP DEREG'!L4","v":0},"rate","% change",{"$f":"K21","v":"Number"},{"$f":"'DATA CP DEREG'!M4","v":0},"rate","% change",{"$f":"O21","v":"Number"},{"$f":"'DATA CP DEREG'!N4","v":0},"rate","% change",{"$f":"S21","v":"Number"},{"$f":"'DATA CP DEREG'!O4","v":0},"rate","% change",{"$f":"W21","v":"Number"},{"$f":"X21","v":0},{"$f":"Y21","v":"rate"},"quartile"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Glasgow City"},{"$f":"OFFSET('DATA CP DEREG'!B5,'Select an authority'!$A$1,0)","v":639},null,{"$f":"OFFSET('DATA CP DEREG'!$S$5,'Select an authority'!$A$1,0)","v":6.6254004790195653},{"$f":"IF(C22=0,\"\",G22/C22-1)","v":2.8169014084507005E-2},{"$f":"OFFSET('DATA CP DEREG'!C5,'Select an authority'!$A$1,0)","v":657},null,{"$f":"OFFSET('DATA CP DEREG'!$T$5,'Select an authority'!$A$1,0)","v":6.7935766061069804},{"$f":"IF(G22=0,\"\",K22/G22-1)","v":7.9147640791476404E-2},{"$f":"OFFSET('DATA CP DEREG'!D5,'Select an authority'!$A$1,0)","v":709},null,{"$f":"OFFSET('DATA CP DEREG'!$U$5,'Select an authority'!$A$1,0)","v":7.2694090144772998},{"$f":"IF(K22=0,\"\",O22/K22-1)","v":-0.16502115655853311},{"$f":"OFFSET('DATA CP DEREG'!E5,'Select an authority'!$A$1,0)","v":592},null,{"$f":"OFFSET('DATA CP DEREG'!$V$5,'Select an authority'!$A$1,0)","v":6.0109456070344311},{"$f":"IF(O22=0,\"\",S22/O22-1)","v":3.3783783783782884E-3},{"$f":"OFFSET('DATA CP DEREG'!F5,'Select an authority'!$A$1,0)","v":594},null,{"$f":"OFFSET('DATA CP DEREG'!$W$5,'Select an authority'!$A$1,0)","v":5.9917084438706034},{"$f":"IF(S22=0,\"\",W22/S22-1)","v":-0.14478114478114479},{"$f":"OFFSET('DATA CP DEREG'!G5,'Select an authority'!$A$1,0)","v":508},null,{"$f":"OFFSET('DATA CP DEREG'!$X$5,'Select an authority'!$A$1,0)","v":5.0831515539634573},{"$f":"IF(W22=0,\"\",AA22/W22-1)","v":-0.15944881889763785},{"$f":"OFFSET('DATA CP DEREG'!H5,'Select an authority'!$A$1,0)","v":427},null,{"$f":"OFFSET('DATA CP DEREG'!$Y$5,'Select an authority'!$A$1,0)","v":4.2417499453638765},{"$f":"IF(AC22=\"*\",\"\",IF(RANK(AC22,'DATA CP DEREG'!$Y$6:$Y$37)<9,1,IF(RANK(AC22,'DATA CP DEREG'!$Y$6:$Y$37)<17,2,IF(RANK(AC22,'DATA CP DEREG'!$Y$6:$Y$37)<25,3,4))))","v":3}]
[]
["Comparator Authorities:"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2, B3,0)","v":"Dundee City"},{"$f":"IF($B3=33,\"\",OFFSET('DATA CP DEREG'!$B$5,$B3,0))","v":158},{"$f":"OFFSET('DATA CP DEREG'!$J$5,$B3,0)","v":23753},{"$f":"IF($B3=33,\"\",C25*1000/D25)","v":6.6517913526712418},{"$f":"IF($B3=33,\"\",IF(C25=0,\"\",G25/C25-1))","v":-0.29746835443037978},{"$f":"IF($B3=33,\"\",OFFSET('DATA CP DEREG'!$C$5,$B3,0))","v":111},{"$f":"OFFSET('DATA CP DEREG'!$K$5,$B3,0)","v":23716},{"$f":"IF($B3=33,\"\",G25*1000/H25)","v":4.6803845505144208},{"$f":"IF($B3=33,\"\",IF(G25=0,\"\",K25/G25-1))","v":9.9099099099099197E-2},{"$f":"IF($B3=33,\"\",OFFSET('DATA CP DEREG'!$D$5,$B3,0))","v":122},{"$f":"OFFSET('DATA CP DEREG'!$L$5,$B3,0)","v":23798},{"$f":"IF($B3=33,\"\",K25*1000/L25)","v":5.1264812169089842},{"$f":"IF($B3=33,\"\",IF(K25=0,\"\",O25/K25-1))","v":0.17213114754098369},{"$f":"IF($B3=33,\"\",OFFSET('DATA CP DEREG'!$E$5,$B3,0))","v":143},{"$f":"OFFSET('DATA CP DEREG'!$M$5,$B3,0)","v":23849},{"$f":"IF($B3=33,\"\",O25*1000/P25)","v":5.9960585349490545},{"$f":"IF($B3=33,\"\",IF(O25=0,\"\",S25/O25-1))","v":6.2937062937062915E-2},{"$f":"IF($B3=33,\"\",OFFSET('DATA CP DEREG'!$F$5,$B3,0))","v":152},{"$f":"OFFSET('DATA CP DEREG'!$N$5,$B3,0)","v":23998},{"$f":"IF($B3=33,\"\",S25*1000/T25)","v":6.3338611550962582},{"$f":"IF($B3=33,\"\",W25/S25-1)","v":-0.10526315789473684},{"$f":"IF($B3=33,\"\",OFFSET('DATA CP DEREG'!$G$5,$B3,0))","v":136},{"$f":"OFFSET('DATA CP DEREG'!$O$5,$B3,0)","v":24016},{"$f":"IF($B3=33,\"\",W25*1000/X25)","v":5.6628914057295132},{"$f":"IF($B3=33,\"\",IF(W25=0,\"\",AA25/W25-1))","v":0.11764705882352944},{"$f":"IF($B3=33,\"\",OFFSET('DATA CP DEREG'!$H$5,$B3,0))","v":152},{"$f":"OFFSET('DATA CP DEREG'!$P$5,$B3,0)","v":24044},{"$f":"IF($B3=33,\"\",AA25*1000/AB25)","v":6.3217434703044422},{"$f":"IF(AC25=\"*\",\"\",IF(B3<33,IF(RANK(AC25,'DATA CP DEREG'!$Y$6:$Y$37)<9,1,IF(RANK(AC25,'DATA CP DEREG'!$Y$6:$Y$37)<17,2,IF(RANK(AC25,'DATA CP DEREG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":1}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B4,0)","v":"West Dunbartonshire"},{"$f":"IF($B4=33,\"\",OFFSET('DATA CP DEREG'!$B$5,$B4,0))","v":61},{"$f":"OFFSET('DATA CP DEREG'!$J$5,$B4,0)","v":15782},{"$f":"IF($B4=33,\"\",C26*1000/D26)","v":3.8651628437460399},{"$f":"IF($B4=33,\"\",IF(C26=0,\"\",G26/C26-1))","v":-8.1967213114754078E-2},{"$f":"IF($B4=33,\"\",OFFSET('DATA CP DEREG'!$C$5,$B4,0))","v":56},{"$f":"OFFSET('DATA CP DEREG'!$K$5,$B4,0)","v":15698},{"$f":"IF($B4=33,\"\",G26*1000/H26)","v":3.5673334182698433},{"$f":"IF($B4=33,\"\",IF(G26=0,\"\",K26/G26-1))","v":0.48214285714285721},{"$f":"IF($B4=33,\"\",OFFSET('DATA CP DEREG'!$D$5,$B4,0))","v":83},{"$f":"OFFSET('DATA CP DEREG'!$L$5,$B4,0)","v":15709},{"$f":"IF($B4=33,\"\",K26*1000/L26)","v":5.2835953911770321},{"$f":"IF($B4=33,\"\",IF(K26=0,\"\",O26/K26-1))","v":-0.45783132530120485},{"$f":"IF($B4=33,\"\",OFFSET('DATA CP DEREG'!$E$5,$B4,0))","v":45},{"$f":"OFFSET('DATA CP DEREG'!$M$5,$B4,0)","v":15764},{"$f":"IF($B4=33,\"\",O26*1000/P26)","v":2.8546054300938848},{"$f":"IF($B4=33,\"\",IF(O26=0,\"\",S26/O26-1))","v":1.3333333333333335},{"$f":"IF($B4=33,\"\",OFFSET('DATA CP DEREG'!$F$5,$B4,0))","v":105},{"$f":"OFFSET('DATA CP DEREG'!$N$5,$B4,0)","v":15790},{"$f":"IF($B4=33,\"\",S26*1000/T26)","v":6.6497783407219764},{"$f":"IF($B4=33,\"\",W26/S26-1)","v":6.6666666666666652E-2},{"$f":"IF($B4=33,\"\",OFFSET('DATA CP DEREG'!$G$5,$B4,0))","v":112},{"$f":"OFFSET('DATA CP DEREG'!$O$5,$B4,0)","v":15705},{"$f":"IF($B4=33,\"\",W26*1000/X26)","v":7.1314867876472459},{"$f":"IF($B4=33,\"\",IF(W26=0,\"\",AA26/W26-1))","v":-0.2767857142857143},{"$f":"IF($B4=33,\"\",OFFSET('DATA CP DEREG'!$H$5,$B4,0))","v":81},{"$f":"OFFSET('DATA CP DEREG'!$P$5,$B4,0)","v":15647},{"$f":"IF($B4=33,\"\",AA26*1000/AB26)","v":5.1767111906435739},{"$f":"IF(AC26=\"*\",\"\",IF(B4<33,IF(RANK(AC26,'DATA CP DEREG'!$Y$6:$Y$37)<9,1,IF(RANK(AC26,'DATA CP DEREG'!$Y$6:$Y$37)<17,2,IF(RANK(AC26,'DATA CP DEREG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B5,0)","v":"Inverclyde"},{"$f":"IF($B5=33,\"\",OFFSET('DATA CP DEREG'!$B$5,$B5,0))","v":54},{"$f":"OFFSET('DATA CP DEREG'!$J$5,$B5,0)","v":13241},{"$f":"IF($B5=33,\"\",C27*1000/D27)","v":4.0782418246356018},{"$f":"IF($B5=33,\"\",IF(C27=0,\"\",G27/C27-1))","v":0.22222222222222232},{"$f":"IF($B5=33,\"\",OFFSET('DATA CP DEREG'!$C$5,$B5,0))","v":66},{"$f":"OFFSET('DATA CP DEREG'!$K$5,$B5,0)","v":13143},{"$f":"IF($B5=33,\"\",G27*1000/H27)","v":5.0216845469070988},{"$f":"IF($B5=33,\"\",IF(G27=0,\"\",K27/G27-1))","v":-0.34848484848484851},{"$f":"IF($B5=33,\"\",OFFSET('DATA CP DEREG'!$D$5,$B5,0))","v":43},{"$f":"OFFSET('DATA CP DEREG'!$L$5,$B5,0)","v":12966},{"$f":"IF($B5=33,\"\",K27*1000/L27)","v":3.31636587999383},{"$f":"IF($B5=33,\"\",IF(K27=0,\"\",O27/K27-1))","v":0.37209302325581395},{"$f":"IF($B5=33,\"\",OFFSET('DATA CP DEREG'!$E$5,$B5,0))","v":59},{"$f":"OFFSET('DATA CP DEREG'!$M$5,$B5,0)","v":12851},{"$f":"IF($B5=33,\"\",O27*1000/P27)","v":4.5910824060384403},{"$f":"IF($B5=33,\"\",IF(O27=0,\"\",S27/O27-1))","v":-0.13559322033898302},{"$f":"IF($B5=33,\"\",OFFSET('DATA CP DEREG'!$F$5,$B5,0))","v":51},{"$f":"OFFSET('DATA CP DEREG'!$N$5,$B5,0)","v":12701},{"$f":"IF($B5=33,\"\",S27*1000/T27)","v":4.0154318557593891},{"$f":"IF($B5=33,\"\",W27/S27-1)","v":1.9607843137254832E-2},{"$f":"IF($B5=33,\"\",OFFSET('DATA CP DEREG'!$G$5,$B5,0))","v":52},{"$f":"OFFSET('DATA CP DEREG'!$O$5,$B5,0)","v":12628},{"$f":"IF($B5=33,\"\",W27*1000/X27)","v":4.117833386126069},{"$f":"IF($B5=33,\"\",IF(W27=0,\"\",AA27/W27-1))","v":-9.6153846153846145E-2},{"$f":"IF($B5=33,\"\",OFFSET('DATA CP DEREG'!$H$5,$B5,0))","v":47},{"$f":"OFFSET('DATA CP DEREG'!$P$5,$B5,0)","v":12603},{"$f":"IF($B5=33,\"\",AA27*1000/AB27)","v":3.7292708085376498},{"$f":"IF(AC27=\"*\",\"\",IF(B5<33,IF(RANK(AC27,'DATA CP DEREG'!$Y$6:$Y$37)<9,1,IF(RANK(AC27,'DATA CP DEREG'!$Y$6:$Y$37)<17,2,IF(RANK(AC27,'DATA CP DEREG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":3}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B6,0)","v":"Aberdeen City"},{"$f":"IF($B6=33,\"\",OFFSET('DATA CP DEREG'!$B$5,$B6,0))","v":154},{"$f":"OFFSET('DATA CP DEREG'!$J$5,$B6,0)","v":33131},{"$f":"IF($B6=33,\"\",C28*1000/D28)","v":4.6482146630044365},{"$f":"IF($B6=33,\"\",IF(C28=0,\"\",G28/C28-1))","v":0.20779220779220786},{"$f":"IF($B6=33,\"\",OFFSET('DATA CP DEREG'!$C$5,$B6,0))","v":186},{"$f":"OFFSET('DATA CP DEREG'!$K$5,$B6,0)","v":33511},{"$f":"IF($B6=33,\"\",G28*1000/H28)","v":5.550416281221092},{"$f":"IF($B6=33,\"\",IF(G28=0,\"\",K28/G28-1))","v":-0.27956989247311825},{"$f":"IF($B6=33,\"\",OFFSET('DATA CP DEREG'!$D$5,$B6,0))","v":134},{"$f":"OFFSET('DATA CP DEREG'!$L$5,$B6,0)","v":33851},{"$f":"IF($B6=33,\"\",K28*1000/L28)","v":3.9585241204100323},{"$f":"IF($B6=33,\"\",IF(K28=0,\"\",O28/K28-1))","v":1.4925373134328401E-2},{"$f":"IF($B6=33,\"\",OFFSET('DATA CP DEREG'!$E$5,$B6,0))","v":136},{"$f":"OFFSET('DATA CP DEREG'!$M$5,$B6,0)","v":34187},{"$f":"IF($B6=33,\"\",O28*1000/P28)","v":3.9781203381402288},{"$f":"IF($B6=33,\"\",IF(O28=0,\"\",S28/O28-1))","v":0.47794117647058831},{"$f":"IF($B6=33,\"\",OFFSET('DATA CP DEREG'!$F$5,$B6,0))","v":201},{"$f":"OFFSET('DATA CP DEREG'!$N$5,$B6,0)","v":34495},{"$f":"IF($B6=33,\"\",S28*1000/T28)","v":5.8269314393390346},{"$f":"IF($B6=33,\"\",W28/S28-1)","v":-0.19402985074626866},{"$f":"IF($B6=33,\"\",OFFSET('DATA CP DEREG'!$G$5,$B6,0))","v":162},{"$f":"OFFSET('DATA CP DEREG'!$O$5,$B6,0)","v":34833},{"$f":"IF($B6=33,\"\",W28*1000/X28)","v":4.6507622082507964},{"$f":"IF($B6=33,\"\",IF(W28=0,\"\",AA28/W28-1))","v":-0.31481481481481477},{"$f":"IF($B6=33,\"\",OFFSET('DATA CP DEREG'!$H$5,$B6,0))","v":111},{"$f":"OFFSET('DATA CP DEREG'!$P$5,$B6,0)","v":35423},{"$f":"IF($B6=33,\"\",AA28*1000/AB28)","v":3.1335572932840243},{"$f":"IF(AC28=\"*\",\"\",IF(B6<33,IF(RANK(AC28,'DATA CP DEREG'!$Y$6:$Y$37)<9,1,IF(RANK(AC28,'DATA CP DEREG'!$Y$6:$Y$37)<17,2,IF(RANK(AC28,'DATA CP DEREG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":4}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B7,0)","v":"Renfrewshire"},{"$f":"IF($B7=33,\"\",OFFSET('DATA CP DEREG'!$B$5,$B7,0))","v":168},{"$f":"OFFSET('DATA CP DEREG'!$J$5,$B7,0)","v":30113},{"$f":"IF($B7=33,\"\",C29*1000/D29)","v":5.5789858200777074},{"$f":"IF($B7=33,\"\",IF(C29=0,\"\",G29/C29-1))","v":0},{"$f":"IF($B7=33,\"\",OFFSET('DATA CP DEREG'!$C$5,$B7,0))","v":168},{"$f":"OFFSET('DATA CP DEREG'!$K$5,$B7,0)","v":29973},{"$f":"IF($B7=33,\"\",G29*1000/H29)","v":5.6050445400860776},{"$f":"IF($B7=33,\"\",IF(G29=0,\"\",K29/G29-1))","v":-0.2142857142857143},{"$f":"IF($B7=33,\"\",OFFSET('DATA CP DEREG'!$D$5,$B7,0))","v":132},{"$f":"OFFSET('DATA CP DEREG'!$L$5,$B7,0)","v":29831},{"$f":"IF($B7=33,\"\",K29*1000/L29)","v":4.424927089269552},{"$f":"IF($B7=33,\"\",IF(K29=0,\"\",O29/K29-1))","v":0.10606060606060597},{"$f":"IF($B7=33,\"\",OFFSET('DATA CP DEREG'!$E$5,$B7,0))","v":146},{"$f":"OFFSET('DATA CP DEREG'!$M$5,$B7,0)","v":29954},{"$f":"IF($B7=33,\"\",O29*1000/P29)","v":4.8741403485344197},{"$f":"IF($B7=33,\"\",IF(O29=0,\"\",S29/O29-1))","v":8.9041095890410871E-2},{"$f":"IF($B7=33,\"\",OFFSET('DATA CP DEREG'!$F$5,$B7,0))","v":159},{"$f":"OFFSET('DATA CP DEREG'!$N$5,$B7,0)","v":30039},{"$f":"IF($B7=33,\"\",S29*1000/T29)","v":5.2931189453710177},{"$f":"IF($B7=33,\"\",W29/S29-1)","v":-0.16981132075471694},{"$f":"IF($B7=33,\"\",OFFSET('DATA CP DEREG'!$G$5,$B7,0))","v":132},{"$f":"OFFSET('DATA CP DEREG'!$O$5,$B7,0)","v":30171},{"$f":"IF($B7=33,\"\",W29*1000/X29)","v":4.3750621457691157},{"$f":"IF($B7=33,\"\",IF(W29=0,\"\",AA29/W29-1))","v":0.36363636363636354},{"$f":"IF($B7=33,\"\",OFFSET('DATA CP DEREG'!$H$5,$B7,0))","v":180},{"$f":"OFFSET('DATA CP DEREG'!$P$5,$B7,0)","v":30267},{"$f":"IF($B7=33,\"\",AA29*1000/AB29)","v":5.9470710674992562},{"$f":"IF(AC29=\"*\",\"\",IF(B7<33,IF(RANK(AC29,'DATA CP DEREG'!$Y$6:$Y$37)<9,1,IF(RANK(AC29,'DATA CP DEREG'!$Y$6:$Y$37)<17,2,IF(RANK(AC29,'DATA CP DEREG'!$Y$6:$Y$37)<25,3,4))),\"\"))","v":2}]
[]
[null,"Comparator authorities",{"$f":"SUM(C25:C29)","v":595},{"$f":"SUM(D25:D29)","v":116020},{"$f":"1000*C31/(SUMIF(C25,\">0\",D25)+SUMIF(C26,\">0\",D26)+SUMIF(C27,\">0\",D27)+SUMIF(C28,\">0\",D28)+SUMIF(C29,\">0\",D29))","v":5.1284261334252719},{"$f":"IF(C31=0,\"\",SUM(G25:G29)/SUM(C25:C29)-1)","v":-1.3445378151260456E-2},{"$f":"SUM(G25:G29)","v":587},{"$f":"SUM(H25:H29)","v":116041},{"$f":"1000*G31/(SUMIF(G25,\">0\",H25)+SUMIF(G26,\">0\",H26)+SUMIF(G27,\">0\",H27)+SUMIF(G28,\">0\",H28)+SUMIF(G29,\">0\",H29))","v":5.058556889375307},{"$f":"IF(G31=0,\"\",SUM(K25:K29)/SUM(G25:G29)-1)","v":-0.12436115843270867},{"$f":"SUM(K25:K29)","v":514},{"$f":"SUM(L25:L29)","v":116155},{"$f":"1000*K31/(SUMIF(K25,\">0\",L25)+SUMIF(K26,\">0\",L26)+SUMIF(K27,\">0\",L27)+SUMIF(K28,\">0\",L28)+SUMIF(K29,\">0\",L29))","v":4.4251216047522703},{"$f":"IF(K31=0,\"\",SUM(O25:O29)/SUM(K25:K29)-1)","v":2.9182879377431803E-2},{"$f":"SUM(O25:O29)","v":529},{"$f":"SUM(P25:P29)","v":116605},{"$f":"1000*O31/(SUMIF(O25,\">0\",P25)+SUMIF(O26,\">0\",P26)+SUMIF(O27,\">0\",P27)+SUMIF(O28,\">0\",P28)+SUMIF(O29,\">0\",P29))","v":4.5366836756571329},{"$f":"IF(O31=0,\"\",SUM(S25:S29)/SUM(O25:O29)-1)","v":0.26275992438563334},{"$f":"SUM(S25:S29)","v":668},{"$f":"SUM(T25:T29)","v":117023},{"$f":"1000*S31/(SUMIF(S25,\">0\",T25)+SUMIF(S26,\">0\",T26)+SUMIF(S27,\">0\",T27)+SUMIF(S28,\">0\",T28)+SUMIF(S29,\">0\",T29))","v":5.7082795689736203},{"$f":"IF(S31=0,\"\",SUM(W25:W29)/SUM(S25:S29)-1)","v":-0.1107784431137725},{"$f":"SUM(W25:W29)","v":594},{"$f":"SUM(X25:X29)","v":117353},{"$f":"1000*W31/(SUMIF(W25,\">0\",X25)+SUMIF(W26,\">0\",X26)+SUMIF(W27,\">0\",X27)+SUMIF(W28,\">0\",X28)+SUMIF(W29,\">0\",X29))","v":5.0616515981696253},{"$f":"IF(W31=0,\"\",SUM(AA25:AA29)/SUM(W25:W29)-1)","v":-3.8720538720538711E-2},{"$f":"SUM(AA25:AA29)","v":571},{"$f":"SUM(AB25:AB29)","v":117984},{"$f":"1000*AA31/(SUMIF(AA25,\">0\",AB25)+SUMIF(AA26,\">0\",AB26)+SUMIF(AA27,\">0\",AB27)+SUMIF(AA28,\">0\",AB28)+SUMIF(AA29,\">0\",AB29))","v":4.8396392731217794}]
[]
[null,"Scotland(1,2)",{"$f":"'DATA CP DEREG'!$B$38","v":4228},{"$f":"'DATA CP DEREG'!$J$38","v":911579},{"$f":"C33*1000/D33","v":4.6381059677767915},{"$f":"IF(C33=0,\"\",G33/C33-1)","v":3.9262062440870382E-2},{"$f":"'DATA CP DEREG'!$C$38","v":4394},{"$f":"'DATA CP DEREG'!$K$38","v":911041},{"$f":"G33*1000/H33","v":4.8230540667214754},{"$f":"IF(G33=0,\"\",K33/G33-1)","v":3.3227127901684028E-2},{"$f":"'DATA CP DEREG'!$D$38","v":4540},{"$f":"'DATA CP DEREG'!$L$38","v":912262},{"$f":"K33*1000/L33","v":4.9766404826683566},{"$f":"IF(K33=0,\"\",O33/K33-1)","v":-5.3083700440528681E-2},{"$f":"'DATA CP DEREG'!$E$38","v":4299},{"$f":"'DATA CP DEREG'!$M$38","v":915917},{"$f":"O33*1000/P33","v":4.6936567396390725},{"$f":"IF(O33=0,\"\",S33/O33-1)","v":1.6748080949057886E-2},{"$f":"'DATA CP DEREG'!$F$38","v":4371},{"$f":"'DATA CP DEREG'!$N$38","v":917442},{"$f":"S33*1000/T33","v":4.7643338761469387},{"$f":"IF(S33=0,\"\",W33/S33-1)","v":-1.258293296728441E-2},{"$f":"'DATA CP DEREG'!$G$38","v":4316},{"$f":"'DATA CP DEREG'!$O$38","v":919502},{"$f":"W33*1000/X33","v":4.6938451466119702},{"$f":"IF(W33=0,\"\",AA33/W33-1)","v":-2.1316033364226161E-2},{"$f":"'DATA CP DEREG'!$H$38","v":4224},{"$f":"'DATA CP DEREG'!$P$38","v":921397},{"$f":"AA33*1000/AB33","v":4.584343122454273}]
[]
["Notes"]
[{"$f":"IF('DATA CP DEREG'!A40=\"\",\"\",'DATA CP DEREG'!A40)","v":"Figures for 2019 are provisional and may be revised with the publication of 2020 statistics."}]
[{"$f":"IF('DATA CP DEREG'!A41=\"\",\"\",'DATA CP DEREG'!A41)","v":"Cells containing * represent numbers that are supressed to maintain confidentiality."}]
[{"$f":"IF('DATA CP DEREG'!A42=\"\",\"\",'DATA CP DEREG'!A42)","v":"Population figures source: NRS mid-year population estimates for 2013-2019."}]
[{"$f":"IF('DATA CP DEREG'!A43=\"\",\"\",'DATA CP DEREG'!A43)","v":"Source: Scottish Government CP Returns"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R22-R31","v":-0.25938154600725505},null,null,{"$f":"U22-U31","v":0.2834288748969831},{"$f":"V22-V31","v":-3.4002701667372293E-2},null,null,{"$f":"Y22-Y31","v":2.1499955793832015E-2},{"$f":"Z22-Z31","v":-0.12072828017709913},null,null,{"$f":"AC22-AC31","v":-0.59788932775790293},{"$f":"IF(AC43<-0.5,\"less than\",IF(AC43>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,{"$f":"R22-R33","v":-1.3369702570679598E-2},null,null,{"$f":"U22-U33","v":1.2273745677236647},{"$f":"V22-V33","v":-0.13219821181386038},null,null,{"$f":"Y22-Y33","v":0.38930640735148714},{"$f":"Z22-Z33","v":-0.13813278553341168},null,null,{"$f":"AC22-AC33","v":-0.34259317709039649},{"$f":"IF(AC44<-0.5,\"less than\",IF(AC44>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,{"$f":"S22-O22","v":2},null,null,null,{"$f":"W22-S22","v":-86},null,null,null,{"$f":"AA22-W22","v":-81}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R46<0,\"a decrease of \",IF(R46>=0,\"an increase of \"))","v":"an increase of "},null,null,null,{"$f":"IF(V46<0,\"a decrease of \",IF(V46>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z46<0,\"a decrease of \",IF(Z46>=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,{"$f":"IF(R31<0,\"a decrease of \",IF(R31>=0,\"an increase of \"))","v":"an increase of "},null,null,null,{"$f":"IF(V31<0,\"a decrease of \",IF(V31>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z31<0,\"a decrease of \",IF(Z31>=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,{"$f":"IF(R33<0,\"a decrease of \",IF(R33>=0,\"an increase of \"))","v":"an increase of "},null,null,null,{"$f":"IF(V33<0,\"a decrease of \",IF(V33>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z33<0,\"a decrease of \",IF(Z33>=0,\"an increase of \"))","v":"a decrease of "}]

{"sheet":"CP on register","index":4,"n_rows":51,"n_cols":30,"rows_kept":51,"cut":false,"hidden":false,"merged":[[11,1,13,6],[14,1,15,6],[16,1,18,6]]}
[{"$f":"'DATA CP ON REG'!A1","v":"Child Protection: On Child Protection Registers:  as at 31 July 2012-2018"}]
[null,null,"select comparators:"]
[null,{"$f":"J3","v":8},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":8}]
[null,{"$f":"J4","v":31},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":31}]
[null,{"$f":"J5","v":17},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":17}]
[null,{"$f":"J6","v":1},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":1}]
[null,{"$f":"J7","v":25},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":25}]
[]
[]
[]
[]
[null,{"$f":"IF(AA23=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Z23=\"\",\"\",\"*  The number of child protection referrals in \"&B23&\" in \"&AA21&\" was \"&ROUND(AA23,0)&\" (\"&Z48&ROUND((SQRT((Z23*100)^2)),1)&\"% from \"&ROUND(W23,0)&\" in \"&W21&\")\"))","v":"*  The number of child protection referrals in Glasgow City in 2019 was 414 (an increase of 34.4% from 308 in 2018)"}]
[]
[]
[null,{"$f":"IF(Z32=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&Z50&ROUND(SQRT((Z32*100)^2),1)&\"%, while the Scotland figures show \"&Z51&ROUND(SQRT((100*Z34)^2),1)&\"%\")","v":"*  The comparator authorities show an increase of 16.3%, while the Scotland figures show an increase of 2.7%"}]
[]
[null,{"$f":"IF(AC23=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(AC32=\"*\",\"\",\"*  The rate (per 1,000 pop 0-15) is \"&ROUND(AC23,1)&\".  This is \"&AD44&\" the comparator average rate of \"&ROUND(AC32,1)&\", and \"&AD45&\" the Scotland average rate of \"&ROUND(AC34,1)))","v":"*  The rate (per 1,000 pop 0-15) is 4.1.  This is greater than the comparator average rate of 3.3, and greater than the Scotland average rate of 2.8"}]
[]
[]
[]
[null,null,{"$f":"'DATA CP ON REG'!B5","v":2013},null,null,null,{"$f":"'DATA CP ON REG'!C5","v":2014},null,null,null,{"$f":"'DATA CP ON REG'!D5","v":2015},null,null,null,{"$f":"'DATA CP ON REG'!E5","v":2016},null,null,null,{"$f":"'DATA CP ON REG'!F5","v":2017},null,null,null,{"$f":"'DATA CP ON REG'!G5","v":2018},null,null,null,{"$f":"'DATA CP ON REG'!H5","v":2019}]
[null,null,"number","population 0-15","rate","% change","number","population 0-15","rate","% change","number","population 0-15","rate","% change","number","population 0-15","rate","% change","number","population 0-15","rate","% change","number","population 0-15","rate","% change","number","population 0-15","rate","quartile"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Glasgow City"},{"$f":"OFFSET('DATA CP ON REG'!$B$5,'Select an authority'!$A$1,0)","v":431},null,{"$f":"OFFSET('DATA CP ON REG'!$S$5,'Select an authority'!$A$1,0)","v":4.4687755969599881},{"$f":"IF(C23=0,\"\",G23/C23-1)","v":0.11832946635730868},{"$f":"OFFSET('DATA CP ON REG'!$C$5,'Select an authority'!$A$1,0)","v":482},null,{"$f":"OFFSET('DATA CP ON REG'!$T$5,'Select an authority'!$A$1,0)","v":4.9840242376614379},{"$f":"IF(G23=0,\"\",K23/G23-1)","v":4.5643153526971014E-2},{"$f":"OFFSET('DATA CP ON REG'!$D$5,'Select an authority'!$A$1,0)","v":504},null,{"$f":"OFFSET('DATA CP ON REG'!$U$5,'Select an authority'!$A$1,0)","v":5.1675347578230735},{"$f":"IF(K23=0,\"\",O23/K23-1)","v":1.388888888888884E-2},{"$f":"OFFSET('DATA CP ON REG'!$E$5,'Select an authority'!$A$1,0)","v":511},null,{"$f":"OFFSET('DATA CP ON REG'!$V$5,'Select an authority'!$A$1,0)","v":5.1885020358016796},{"$f":"IF(O23=0,\"\",S23/O23-1)","v":-0.20743639921722112},{"$f":"OFFSET('DATA CP ON REG'!$F$5,'Select an authority'!$A$1,0)","v":405},null,{"$f":"OFFSET('DATA CP ON REG'!$W$5,'Select an authority'!$A$1,0)","v":4.0852557571845018},{"$f":"IF(S23=0,\"\",W23/S23-1)","v":-0.23950617283950615},{"$f":"OFFSET('DATA CP ON REG'!$G$5,'Select an authority'!$A$1,0)","v":308},null,{"$f":"OFFSET('DATA CP ON REG'!$X$5,'Select an authority'!$A$1,0)","v":3.0819107846865057},{"$f":"IF(W23=0,\"\",AA23/W23-1)","v":0.3441558441558441},{"$f":"OFFSET('DATA CP ON REG'!$H$5,'Select an authority'!$A$1,0)","v":414},null,{"$f":"OFFSET('DATA CP ON REG'!$Y$5,'Select an authority'!$A$1,0)","v":4.112610017284883},{"$f":"IF(RANK(AC23,'DATA CP ON REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC23,'DATA CP ON REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC23,'DATA CP ON REG'!$Y$6:$Y$37)<25,3,4)))","v":1}]
[]
["Comparator Authorities:"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2, B3,0)","v":"Dundee City"},{"$f":"IF(B3<33,OFFSET('DATA CP ON REG'!$B$5,B3,0),\"\")","v":46},{"$f":"OFFSET('DATA CP ON REG'!$J$5,B3,0)","v":23753},{"$f":"IF(B3<33,C26*1000/D26,\"\")","v":1.9365974824232728},{"$f":"IF($B3=33,\"\",IF(C26=0,\"\",G26/C26-1))","v":0.45652173913043481},{"$f":"IF(B3<33,OFFSET('DATA CP ON REG'!$C$5,B3,0),\"\")","v":67},{"$f":"OFFSET('DATA CP ON REG'!$K$5,B3,0)","v":23716},{"$f":"IF(B3<33,G26*1000/H26,\"\")","v":2.8250969809411366},{"$f":"IF($B3=33,\"\",IF(G26=0,\"\",K26/G26-1))","v":5.9701492537313383E-2},{"$f":"IF(B3<33,OFFSET('DATA CP ON REG'!$D$5,B3,0),\"\")","v":71},{"$f":"OFFSET('DATA CP ON REG'!$L$5,B3,0)","v":23798},{"$f":"IF(B3<33,K26*1000/L26,\"\")","v":2.9834439868896547},{"$f":"IF($B3=33,\"\",IF(K26=0,\"\",O26/K26-1))","v":0.11267605633802824},{"$f":"IF(B3<33,OFFSET('DATA CP ON REG'!$E$5,B3,0),\"\")","v":79},{"$f":"OFFSET('DATA CP ON REG'!$M$5,B3,0)","v":23849},{"$f":"IF(B3<33,O26*1000/P26,\"\")","v":3.3125078619648622},{"$f":"IF($B3=33,\"\",IF(O26=0,\"\",S26/O26-1))","v":-0.12658227848101267},{"$f":"IF(B3<33,OFFSET('DATA CP ON REG'!$F$5,B3,0),\"\")","v":69},{"$f":"OFFSET('DATA CP ON REG'!$N$5,B3,0)","v":23998},{"$f":"IF(B3<33,S26*1000/T26,\"\")","v":2.8752396033002752},{"$f":"IF($B3=33,\"\",IF(S26=0,\"\",W26/S26-1))","v":8.6956521739130377E-2},{"$f":"IF(B3<33,OFFSET('DATA CP ON REG'!$G$5,B3,0),\"\")","v":75},{"$f":"OFFSET('DATA CP ON REG'!$O$5,B3,0)","v":24016},{"$f":"IF(B3<33,W26*1000/X26,\"\")","v":3.1229180546302464},{"$f":"IF($B3=33,\"\",IF(W26=0,\"\",AA26/W26-1))","v":0.21333333333333337},{"$f":"IF(B3<33,OFFSET('DATA CP ON REG'!$H$5,B3,0),\"\")","v":91},{"$f":"OFFSET('DATA CP ON REG'!$P$5,B3,0)","v":24044},{"$f":"IF(B3<33,AA26*1000/AB26,\"\")","v":3.7847279986691067},{"$f":"IF(B3<33,IF(RANK(AC26,'DATA CP ON REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC26,'DATA CP ON REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC26,'DATA CP ON REG'!$Y$6:$Y$37)<25,3,4))),\"\")","v":1}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B4,0)","v":"West Dunbartonshire"},{"$f":"IF(B4<33,OFFSET('DATA CP ON REG'!$B$5,B4,0),\"\")","v":32},{"$f":"OFFSET('DATA CP ON REG'!$J$5,B4,0)","v":15782},{"$f":"IF(B4<33,C27*1000/D27,\"\")","v":2.0276264098339882},{"$f":"IF($B4=33,\"\",IF(C27=0,\"\",G27/C27-1))","v":0.28125},{"$f":"IF(B4<33,OFFSET('DATA CP ON REG'!$C$5,B4,0),\"\")","v":41},{"$f":"OFFSET('DATA CP ON REG'!$K$5,B4,0)","v":15698},{"$f":"IF(B4<33,G27*1000/H27,\"\")","v":2.6117976812332779},{"$f":"IF($B4=33,\"\",IF(G27=0,\"\",K27/G27-1))","v":-0.6097560975609756},{"$f":"IF(B4<33,OFFSET('DATA CP ON REG'!$D$5,B4,0),\"\")","v":16},{"$f":"OFFSET('DATA CP ON REG'!$L$5,B4,0)","v":15709},{"$f":"IF(B4<33,K27*1000/L27,\"\")","v":1.0185244127570183},{"$f":"IF($B4=33,\"\",IF(K27=0,\"\",O27/K27-1))","v":2},{"$f":"IF(B4<33,OFFSET('DATA CP ON REG'!$E$5,B4,0),\"\")","v":48},{"$f":"OFFSET('DATA CP ON REG'!$M$5,B4,0)","v":15764},{"$f":"IF(B4<33,O27*1000/P27,\"\")","v":3.0449124587668104},{"$f":"IF($B4=33,\"\",IF(O27=0,\"\",S27/O27-1))","v":0.47916666666666674},{"$f":"IF(B4<33,OFFSET('DATA CP ON REG'!$F$5,B4,0),\"\")","v":71},{"$f":"OFFSET('DATA CP ON REG'!$N$5,B4,0)","v":15790},{"$f":"IF(B4<33,S27*1000/T27,\"\")","v":4.4965167827739077},{"$f":"IF($B4=33,\"\",IF(S27=0,\"\",W27/S27-1))","v":-0.23943661971830987},{"$f":"IF(B4<33,OFFSET('DATA CP ON REG'!$G$5,B4,0),\"\")","v":54},{"$f":"OFFSET('DATA CP ON REG'!$O$5,B4,0)","v":15705},{"$f":"IF(B4<33,W27*1000/X27,\"\")","v":3.4383954154727792},{"$f":"IF($B4=33,\"\",IF(W27=0,\"\",AA27/W27-1))","v":-0.18518518518518523},{"$f":"IF(B4<33,OFFSET('DATA CP ON REG'!$H$5,B4,0),\"\")","v":44},{"$f":"OFFSET('DATA CP ON REG'!$P$5,B4,0)","v":15647},{"$f":"IF(B4<33,AA27*1000/AB27,\"\")","v":2.8120406467693488},{"$f":"IF(B4<33,IF(RANK(AC27,'DATA CP ON REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC27,'DATA CP ON REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC27,'DATA CP ON REG'!$Y$6:$Y$37)<25,3,4))),\"\")","v":2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B5,0)","v":"Inverclyde"},{"$f":"IF(B5<33,OFFSET('DATA CP ON REG'!$B$5,B5,0),\"\")","v":24},{"$f":"OFFSET('DATA CP ON REG'!$J$5,B5,0)","v":13241},{"$f":"IF(B5<33,C28*1000/D28,\"\")","v":1.8125519220602673},{"$f":"IF($B5=33,\"\",IF(C28=0,\"\",G28/C28-1))","v":8.3333333333333259E-2},{"$f":"IF(B5<33,OFFSET('DATA CP ON REG'!$C$5,B5,0),\"\")","v":26},{"$f":"OFFSET('DATA CP ON REG'!$K$5,B5,0)","v":13143},{"$f":"IF(B5<33,G28*1000/H28,\"\")","v":1.9782393669634026},{"$f":"IF($B5=33,\"\",IF(G28=0,\"\",K28/G28-1))","v":0.61538461538461542},{"$f":"IF(B5<33,OFFSET('DATA CP ON REG'!$D$5,B5,0),\"\")","v":42},{"$f":"OFFSET('DATA CP ON REG'!$L$5,B5,0)","v":12966},{"$f":"IF(B5<33,K28*1000/L28,\"\")","v":3.239241092086997},{"$f":"IF($B5=33,\"\",IF(K28=0,\"\",O28/K28-1))","v":-4.7619047619047672E-2},{"$f":"IF(B5<33,OFFSET('DATA CP ON REG'!$E$5,B5,0),\"\")","v":40},{"$f":"OFFSET('DATA CP ON REG'!$M$5,B5,0)","v":12851},{"$f":"IF(B5<33,O28*1000/P28,\"\")","v":3.1125982413819937},{"$f":"IF($B5=33,\"\",IF(O28=0,\"\",S28/O28-1))","v":-0.17500000000000004},{"$f":"IF(B5<33,OFFSET('DATA CP ON REG'!$F$5,B5,0),\"\")","v":33},{"$f":"OFFSET('DATA CP ON REG'!$N$5,B5,0)","v":12701},{"$f":"IF(B5<33,S28*1000/T28,\"\")","v":2.5982206125501928},{"$f":"IF($B5=33,\"\",IF(S28=0,\"\",W28/S28-1))","v":-6.0606060606060552E-2},{"$f":"IF(B5<33,OFFSET('DATA CP ON REG'!$G$5,B5,0),\"\")","v":31},{"$f":"OFFSET('DATA CP ON REG'!$O$5,B5,0)","v":12628},{"$f":"IF(B5<33,W28*1000/X28,\"\")","v":2.4548622109597718},{"$f":"IF($B5=33,\"\",IF(W28=0,\"\",AA28/W28-1))","v":0.54838709677419351},{"$f":"IF(B5<33,OFFSET('DATA CP ON REG'!$H$5,B5,0),\"\")","v":48},{"$f":"OFFSET('DATA CP ON REG'!$P$5,B5,0)","v":12603},{"$f":"IF(B5<33,AA28*1000/AB28,\"\")","v":3.8086169959533445},{"$f":"IF(B5<33,IF(RANK(AC28,'DATA CP ON REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC28,'DATA CP ON REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC28,'DATA CP ON REG'!$Y$6:$Y$37)<25,3,4))),\"\")","v":1}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B6,0)","v":"Aberdeen City"},{"$f":"IF(B6<33,OFFSET('DATA CP ON REG'!$B$5,B6,0),\"\")","v":92},{"$f":"OFFSET('DATA CP ON REG'!$J$5,B6,0)","v":33131},{"$f":"IF(B6<33,C29*1000/D29,\"\")","v":2.7768555129636896},{"$f":"IF($B6=33,\"\",IF(C29=0,\"\",G29/C29-1))","v":-0.20652173913043481},{"$f":"IF(B6<33,OFFSET('DATA CP ON REG'!$C$5,B6,0),\"\")","v":73},{"$f":"OFFSET('DATA CP ON REG'!$K$5,B6,0)","v":33511},{"$f":"IF(B6<33,G29*1000/H29,\"\")","v":2.178389185640536},{"$f":"IF($B6=33,\"\",IF(G29=0,\"\",K29/G29-1))","v":0.34246575342465757},{"$f":"IF(B6<33,OFFSET('DATA CP ON REG'!$D$5,B6,0),\"\")","v":98},{"$f":"OFFSET('DATA CP ON REG'!$L$5,B6,0)","v":33851},{"$f":"IF(B6<33,K29*1000/L29,\"\")","v":2.8950400283595759},{"$f":"IF($B6=33,\"\",IF(K29=0,\"\",O29/K29-1))","v":0.20408163265306123},{"$f":"IF(B6<33,OFFSET('DATA CP ON REG'!$E$5,B6,0),\"\")","v":118},{"$f":"OFFSET('DATA CP ON REG'!$M$5,B6,0)","v":34187},{"$f":"IF(B6<33,O29*1000/P29,\"\")","v":3.4516044110334336},{"$f":"IF($B6=33,\"\",IF(O29=0,\"\",S29/O29-1))","v":-0.32203389830508478},{"$f":"IF(B6<33,OFFSET('DATA CP ON REG'!$F$5,B6,0),\"\")","v":80},{"$f":"OFFSET('DATA CP ON REG'!$N$5,B6,0)","v":34495},{"$f":"IF(B6<33,S29*1000/T29,\"\")","v":2.3191766922742425},{"$f":"IF($B6=33,\"\",IF(S29=0,\"\",W29/S29-1))","v":-0.15000000000000002},{"$f":"IF(B6<33,OFFSET('DATA CP ON REG'!$G$5,B6,0),\"\")","v":68},{"$f":"OFFSET('DATA CP ON REG'!$O$5,B6,0)","v":34833},{"$f":"IF(B6<33,W29*1000/X29,\"\")","v":1.9521717911176184},{"$f":"IF($B6=33,\"\",IF(W29=0,\"\",AA29/W29-1))","v":0.75},{"$f":"IF(B6<33,OFFSET('DATA CP ON REG'!$H$5,B6,0),\"\")","v":119},{"$f":"OFFSET('DATA CP ON REG'!$P$5,B6,0)","v":35423},{"$f":"IF(B6<33,AA29*1000/AB29,\"\")","v":3.359399260367558},{"$f":"IF(B6<33,IF(RANK(AC29,'DATA CP ON REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC29,'DATA CP ON REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC29,'DATA CP ON REG'!$Y$6:$Y$37)<25,3,4))),\"\")","v":1}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B7,0)","v":"Renfrewshire"},{"$f":"IF(B7<33,OFFSET('DATA CP ON REG'!$B$5,B7,0),\"\")","v":109},{"$f":"OFFSET('DATA CP ON REG'!$J$5,B7,0)","v":30113},{"$f":"IF(B7<33,C30*1000/D30,\"\")","v":3.6196991332647031},{"$f":"IF($B7=33,\"\",IF(C30=0,\"\",G30/C30-1))","v":-0.2844036697247706},{"$f":"IF(B7<33,OFFSET('DATA CP ON REG'!$C$5,B7,0),\"\")","v":78},{"$f":"OFFSET('DATA CP ON REG'!$K$5,B7,0)","v":29973},{"$f":"IF(B7<33,G30*1000/H30,\"\")","v":2.6023421078971074},{"$f":"IF($B7=33,\"\",IF(G30=0,\"\",K30/G30-1))","v":8.9743589743589647E-2},{"$f":"IF(B7<33,OFFSET('DATA CP ON REG'!$D$5,B7,0),\"\")","v":85},{"$f":"OFFSET('DATA CP ON REG'!$L$5,B7,0)","v":29831},{"$f":"IF(B7<33,K30*1000/L30,\"\")","v":2.8493848680902416},{"$f":"IF($B7=33,\"\",IF(K30=0,\"\",O30/K30-1))","v":-0.15294117647058825},{"$f":"IF(B7<33,OFFSET('DATA CP ON REG'!$E$5,B7,0),\"\")","v":72},{"$f":"OFFSET('DATA CP ON REG'!$M$5,B7,0)","v":29954},{"$f":"IF(B7<33,O30*1000/P30,\"\")","v":2.4036856513320424},{"$f":"IF($B7=33,\"\",IF(O30=0,\"\",S30/O30-1))","v":0.48611111111111116},{"$f":"IF(B7<33,OFFSET('DATA CP ON REG'!$F$5,B7,0),\"\")","v":107},{"$f":"OFFSET('DATA CP ON REG'!$N$5,B7,0)","v":30039},{"$f":"IF(B7<33,S30*1000/T30,\"\")","v":3.5620360198408734},{"$f":"IF($B7=33,\"\",IF(S30=0,\"\",W30/S30-1))","v":-3.7383177570093462E-2},{"$f":"IF(B7<33,OFFSET('DATA CP ON REG'!$G$5,B7,0),\"\")","v":103},{"$f":"OFFSET('DATA CP ON REG'!$O$5,B7,0)","v":30171},{"$f":"IF(B7<33,W30*1000/X30,\"\")","v":3.4138742501077193},{"$f":"IF($B7=33,\"\",IF(W30=0,\"\",AA30/W30-1))","v":-0.19417475728155342},{"$f":"IF(B7<33,OFFSET('DATA CP ON REG'!$H$5,B7,0),\"\")","v":83},{"$f":"OFFSET('DATA CP ON REG'!$P$5,B7,0)","v":30267},{"$f":"IF(B7<33,AA30*1000/AB30,\"\")","v":2.7422605477913238},{"$f":"IF(B7<33,IF(RANK(AC30,'DATA CP ON REG'!$Y$6:$Y$37)<9,1,IF(RANK(AC30,'DATA CP ON REG'!$Y$6:$Y$37)<17,2,IF(RANK(AC30,'DATA CP ON REG'!$Y$6:$Y$37)<25,3,4))),\"\")","v":3}]
[]
[null,"Comparator authorities",{"$f":"SUM(C26:C30)","v":303},{"$f":"SUM(D26:D30)","v":116020},{"$f":"C32*1000/D32","v":2.6116186864333737},{"$f":"IF(C32=0,\"\",SUM(G26:G30)/SUM(C26:C30)-1)","v":-5.9405940594059459E-2},{"$f":"SUM(G26:G30)","v":285},{"$f":"SUM(H26:H30)","v":116041},{"$f":"SUM(G26:G30)/SUM(H26:H30)*1000","v":2.4560284726949959},{"$f":"IF(G32=0,\"\",SUM(K26:K30)/SUM(G26:G30)-1)","v":9.473684210526323E-2},{"$f":"SUM(K26:K30)","v":312},{"$f":"SUM(L26:L30)","v":116155},{"$f":"SUM(K26:K30)/SUM(L26:L30)*1000","v":2.686066032456631},{"$f":"IF(K32=0,\"\",SUM(O26:O30)/SUM(K26:K30)-1)","v":0.14423076923076916},{"$f":"SUM(O26:O30)","v":357},{"$f":"SUM(P26:P30)","v":116605},{"$f":"SUM(O26:O30)/SUM(P26:P30)*1000","v":3.0616182839500876},{"$f":"IF(O32=0,\"\",SUM(S26:S30)/SUM(O26:O30)-1)","v":8.4033613445377853E-3},{"$f":"SUM(S26:S30)","v":360},{"$f":"SUM(T26:T30)","v":117023},{"$f":"SUM(S26:S30)/SUM(T26:T30)*1000","v":3.076318330584586},{"$f":"IF(S32=0,\"\",SUM(W26:W30)/SUM(S26:S30)-1)","v":-8.0555555555555602E-2},{"$f":"SUM(W26:W30)","v":331},{"$f":"SUM(X26:X30)","v":117353},{"$f":"SUM(W26:W30)/SUM(X26:X30)*1000","v":2.820549964636609},{"$f":"IF(W32=0,\"\",SUM(AA26:AA30)/SUM(W26:W30)-1)","v":0.1631419939577039},{"$f":"SUM(AA26:AA30)","v":385},{"$f":"SUM(AB26:AB30)","v":117984},{"$f":"SUM(AA26:AA30)/SUM(AB26:AB30)*1000","v":3.2631543260103064}]
[]
[null,"Scotland(1,2)",{"$f":"'DATA CP ON REG'!B38","v":2645},{"$f":"'DATA CP ON REG'!J38","v":911579},{"$f":"C34*1000/D34","v":2.9015587239284804},{"$f":"IF(C34=0,\"\",G34/C34-1)","v":8.7712665406427304E-2},{"$f":"'DATA CP ON REG'!C38","v":2877},{"$f":"'DATA CP ON REG'!K38","v":911041},{"$f":"G34*1000/H34","v":3.1579259330809482},{"$f":"IF(G34=0,\"\",K34/G34-1)","v":-4.7271463329857544E-2},{"$f":"'DATA CP ON REG'!D38","v":2741},{"$f":"'DATA CP ON REG'!L38","v":912262},{"$f":"K34*1000/L34","v":3.0046192870030759},{"$f":"IF(K34=0,\"\",O34/K34-1)","v":-9.4855892010214937E-3},{"$f":"'DATA CP ON REG'!E38","v":2715},{"$f":"'DATA CP ON REG'!$M$38","v":915917},{"$f":"O34*1000/P34","v":2.9642423931426101},{"$f":"IF(O34=0,\"\",S34/O34-1)","v":-4.2357274401473299E-2},{"$f":"'DATA CP ON REG'!F38","v":2600},{"$f":"'DATA CP ON REG'!$N$38","v":917442},{"$f":"S34*1000/T34","v":2.833966615873265},{"$f":"IF(S34=0,\"\",W34/S34-1)","v":-2.6923076923076938E-2},{"$f":"'DATA CP ON REG'!G38","v":2530},{"$f":"'DATA CP ON REG'!$O$38","v":919502},{"$f":"W34*1000/X34","v":2.751489393171521},{"$f":"IF(W34=0,\"\",AA34/W34-1)","v":2.7272727272727337E-2},{"$f":"'DATA CP ON REG'!H38","v":2599},{"$f":"'DATA CP ON REG'!$P$38","v":921397},{"$f":"AA34*1000/AB34","v":2.8207168028547955}]
[]
["Notes"]
[{"$f":"IF('DATA CP ON REG'!A40=\"\",\"\",'DATA CP ON REG'!A40)","v":"Figures for 2019 are provisional and may be revised with the publication of 2020 statistics."}]
[{"$f":"IF('DATA CP ON REG'!A41=\"\",\"\",'DATA CP ON REG'!A41)","v":"Cells containing * represent numbers that are supressed to maintain confidentiality."}]
[{"$f":"IF('DATA CP ON REG'!A42=\"\",\"\",'DATA CP ON REG'!A42)","v":"Population figures source: NRS mid-year population estimates for 2013-2019."}]
[{"$f":"IF('DATA CP ON REG'!A43=\"\",\"\",'DATA CP ON REG'!A43)","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,null,{"$f":"V23-V32","v":-0.15895061728395055},null,null,{"$f":"Y23-Y32","v":0.26136082004989669},{"$f":"Z23-Z32","v":0.1810138501981402},null,null,{"$f":"AC23-AC32","v":0.84945569127457654},{"$f":"IF(AC44<-0.5,\"less than\",IF(AC44>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,null,null,null,null,null,{"$f":"V23-V34","v":-0.21258309591642921},null,null,{"$f":"Y23-Y34","v":0.33042139151498473},{"$f":"Z23-Z34","v":0.31688311688311677},null,null,{"$f":"AC23-AC34","v":1.2918932144300874},{"$f":"IF(AC45<-0.5,\"less than\",IF(AC45>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,null,null,null,null,null,{"$f":"W23-S23","v":-97},null,null,null,{"$f":"AA23-W23","v":106}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V47<0,\"a decrease of \",IF(V47>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z47<0,\"a decrease of \",IF(Z47>=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,null,{"$f":"IF(V32<0,\"a decrease of \",IF(V32>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z32<0,\"a decrease of \",IF(Z32>=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,null,{"$f":"IF(V34<0,\"a decrease of \",IF(V34>=0,\"an increase of \"))","v":"a decrease of "},null,null,null,{"$f":"IF(Z34<0,\"a decrease of \",IF(Z34>=0,\"an increase of \"))","v":"an increase of "}]

{"sheet":"DATA CP CON","index":5,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,0,2,7],[2,17,2,24],[2,9,2,15],[3,9,3,15]]}
["Child Protection: Conferences: 31 July 2013-2019"]
[]
["Number of child protection referrals that resulted in a case conference: 31 July 2013-2019",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 2013-2019"]
[]
["Council",2013,2014,2015,2016,2017,2018,2019,null,2013,2014,2015,2016,2017,2018,2019,null,"Council",2013,2014,2015,2016,2017,2018,2019]
["Aberdeen City",212,225,205,196,205,176,208,null,33131,33511,33851,34187,34495,34833,35423,null,"Aberdeen City",{"$f":"IFERROR(B6*1000/J6,\"*\")","v":6.3988409646554585},{"$f":"IFERROR(C6*1000/K6,\"*\")","v":6.7142132434126109},6.0559510797317655,5.7331734284962117,5.9428902739527469,5.0526799299514824,5.8718911441718653]
["Aberdeenshire",80,97,126,117,134,127,154,null,48112,48669,48856,48871,48888,49033,49016,null,"Aberdeenshire",{"$f":"IFERROR(B7*1000/J7,\"*\")","v":1.6627868307283007},1.9930551274938872,2.5790076960864581,2.3940578257044054,2.7409589265259369,2.5900923867599372,3.141831238779174]
["Angus",160,216,193,181,171,202,143,null,19757,19676,19653,19445,19288,19253,19145,null,"Angus",8.0983955053904939,10.977841024598495,9.8203836564392208,9.3083054769863711,8.8656159270012438,10.491871396665454,7.4693131365891876]
["Argyll & Bute",76,63,67,73,92,80,68,null,13814,13575,13292,13238,13163,13024,12906,null,"Argyll & Bute",5.5016649775589981,4.6408839779005522,5.0406259404152873,5.5144281613536785,6.9892881561953963,6.1425061425061429,5.268867193553386]
["City of Edinburgh",498,522,476,482,368,312,201,null,74440,75329,76108,77364,78052,78501,79067,null,"City of Edinburgh",6.6899516389038149,6.9296021452561432,6.2542702475429657,6.2302879892456442,4.7148055142725367,3.9744716627813657,2.5421477987023664]
["Clackmannanshire",66,80,97,26,59,76,70,null,9180,9087,9029,9024,9020,8980,8946,null,"Clackmannanshire",7.1895424836601309,8.8037856278199627,10.743160925905416,2.8812056737588652,6.541019955654102,8.4632516703786198,7.8247261345852896]
["Dumfries and Galloway",160,205,211,149,225,284,209,null,24265,23927,23676,23614,23487,23424,23243,null,"Dumfries and Galloway",6.5938594683700806,8.5677268357922021,8.9119783747254608,6.3098162107224525,9.579767530974582,12.12431693989071,8.9919545669663989]
["Dundee City",160,152,162,174,152,157,180,null,23753,23716,23798,23849,23998,24016,24044,null,"Dundee City",6.7359912432113838,6.4091752403440712,6.8072947306496348,7.2959033921757728,6.3338611550962582,6.5373084610259831,7.4862751622026282]
["East Ayrshire",134,124,169,196,230,289,255,null,21380,21169,21191,21259,21164,21119,21053,null,"East Ayrshire",6.267539756782039,5.857621994425811,7.9750837619744228,9.2196246295686528,10.867510867510868,13.684360054926843,12.112288034959388]
["East Dunbartonshire",110,84,119,91,88,116,103,null,18326,18384,18544,18810,19061,19224,19398,null,"East Dunbartonshire",6.0024009603841533,4.5691906005221936,6.417169974115617,4.8378522062732587,4.6167567283983004,6.0341240116521018,5.3098257552324979]
["East Lothian",100,108,52,79,85,85,93,null,18729,18807,18915,18989,19051,19350,19700,null,"East Lothian",5.3393133643013506,5.7425426702823419,2.7491408934707904,4.1603033335088737,4.4617080468216894,4.3927648578811374,4.7208121827411169]
["East Renfrewshire",59,43,65,38,50,26,54,null,18015,18206,18381,18662,19029,19322,19525,null,"East Renfrewshire",3.2750485706355814,2.3618587278919039,3.5362602687557803,2.0362233415496731,2.6275684481580743,1.3456163958182383,2.765685019206146]
["Falkirk",119,127,115,137,150,107,132,null,28309,28288,28318,28359,28329,28230,28112,null,"Falkirk",4.2036101593132926,4.4895361990950224,4.061021258563458,4.8309178743961354,5.2949274594938052,3.7902940134608571,4.6955036994877632]
["Fife",373,520,440,347,340,379,349,null,64186,64070,64081,64372,64333,64473,64552,null,"Fife",5.8112360950986197,8.1161229904791643,6.8663098266256766,5.3905424718821848,5.2850014766915887,5.8784297302746884,5.4064939893419259]
["Glasgow City",878,778,1175,971,769,668,708,null,96447,96709,97532,98487,99137,99938,100666,null,"Glasgow City",9.1034454156168678,8.0447528151464702,12.047328056432761,9.8591692304568124,7.7569424130244009,6.6841441693850188,7.0331591599944367]
["Highland",192,244,179,194,163,175,177,null,40530,40126,39956,39972,39555,39335,39036,null,"Highland",4.7372316802368619,6.0808453371878581,4.4799279207127842,4.8533973781647157,4.1208443938819368,4.4489640269480111,4.5342760528742696]
["Inverclyde",70,101,110,106,95,70,92,null,13241,13143,12966,12851,12701,12628,12603,null,"Inverclyde",5.2866097726757797,{"$f":"IFERROR(C22*1000/K22,\"*\")","v":7.6846990793578334},{"$f":"IFERROR(D22*1000/L22,\"*\")","v":8.4837266697516576},{"$f":"IFERROR(E22*1000/M22,\"*\")","v":8.248385339662283},{"$f":"IFERROR(F22*1000/N22,\"*\")","v":7.4797260058263131},{"$f":"IFERROR(G22*1000/O22,\"*\")","v":5.5432372505543235},{"$f":"IFERROR(H22*1000/P22,\"*\")","v":7.2998492422439103}]
["Midlothian",166,192,87,126,155,131,135,null,16061,16365,16624,16884,17229,17590,17953,null,"Midlothian",10.33559554199614,11.732355637030247,5.23339749759384,7.4626865671641793,8.9964594578907651,7.447413303013076,7.5196346014593658]
["Moray",110,102,74,97,113,91,113,null,16611,16591,16502,16527,16362,16173,16145,null,"Moray",6.6221178736981514,6.1479115182930508,4.4843049327354256,5.8691837599080294,6.9062461801735733,5.6266617201508691,6.9990709197894088]
["Na h-Eileanan Siar",21,11,"*",9,10,26,19,null,4460,4431,4348,4307,4367,4328,4254,null,"Na h-Eileanan Siar",4.7085201793721971,2.4825095915143307,"*",2.0896215463199441,2.2899015342340281,6.0073937153419594,4.4663845792195582]
["North Ayrshire",232,209,202,175,154,300,285,null,23675,23369,23196,23128,22901,22780,22468,null,"North Ayrshire",9.7993664202745521,8.9434721211861863,8.7083979996551122,7.566585956416465,6.7245971791624823,13.169446883230904,12.684707139042194]
["North Lanarkshire",255,311,236,323,331,286,361,null,63940,63555,63131,63299,63011,62955,62836,null,"North Lanarkshire",3.9881138567406942,4.8933994178270792,3.738258541762367,5.1027662364334354,5.2530510545777718,4.542927487888174,5.7451142657075565]
["Orkney Islands",16,14,"*",16,17,18,17,null,3526,3508,3489,3516,3545,3544,3582,null,"Orkney Islands",4.5377197958026088,3.9908779931584948,"*",4.5506257110352673,4.795486600846262,5.0790067720090297,4.7459519821328868]
["Perth and Kinross",92,129,132,123,111,118,162,null,24640,24462,24619,24514,24453,24425,24421,null,"Perth and Kinross",3.7337662337662336,5.2734854059357374,5.3617124984767859,5.0175409969813165,4.5393203287940134,4.8311156601842375,6.6336349862822983]
["Renfrewshire",289,278,257,221,270,213,249,null,30113,29973,29831,29954,30039,30171,30267,null,"Renfrewshire",9.5971839404908188,9.2750141794281529,8.6151989541081431,7.3779795686719636,8.9883151902526723,7.0597593715819826,8.2267816433739718]
["Scottish Borders",52,40,63,91,59,88,68,null,19030,19069,18975,19002,19026,19046,19023,null,"Scottish Borders",2.7325275880189177,2.0976453930463057,3.3201581027667983,4.7889695821492477,3.1010196573110482,4.6203927333823378,3.5746201966041107]
["Shetland Islands",9,26,39,28,17,15,24,null,4357,4307,4254,4233,4233,4205,4198,null,"Shetland Islands",2.0656414964425065,6.0366844671465056,9.16784203102962,6.6146940703992438,4.0160642570281126,3.56718192627824,5.7170080990948069]
["South Ayrshire",160,117,136,130,147,109,128,null,18074,17833,17798,17760,17716,17638,17608,null,"South Ayrshire",8.852495297111874,6.5608702966410588,7.6413080121361947,7.3198198198198199,8.2975841047640557,6.1798389840117931,7.2694229895502041]
["South Lanarkshire",372,382,412,419,384,440,322,null,55046,54888,55027,54876,55151,55260,55649,null,"South Lanarkshire",6.757984231370127,6.959626876548608,7.487233539898595,7.6353961659013043,6.9627023988685606,7.9623597538906985,5.7862674980682494]
["Stirling",100,83,76,73,61,100,63,null,15639,15527,15510,15493,15425,15514,15417,null,"Stirling",6.3942707334228528,5.3455271462613512,4.9000644745325594,4.7118053314400052,3.9546191247974067,6.445790898543251,4.0863981319322829]
["West Dunbartonshire",129,135,139,159,251,221,163,null,15782,15698,15709,15764,15790,15705,15647,null,"West Dunbartonshire",8.1738689646432636,8.5998216333290873,8.848430835826596,10.08627251966506,15.896136795440151,14.071951607768227,10.417332395986451]
["West Lothian",151,164,223,160,193,170,220,null,35010,35073,35102,35307,35443,35485,35494,null,"West Lothian",4.3130534133104828,4.6759615658768849,6.3529143638539116,4.5316792703996374,5.4453629771746188,4.7907566577427083,6.1982306868766548]
["Scotland",5601,5882,6061,5707,5649,5655,5525,null,911579,911041,912262,915917,917442,919502,{"$f":"SUM(P6:P37)","v":921397},null,"Scotland",6.144283709914335,6.4563504825798184,6.6439246619940322,6.2309139365248161,6.1573374665646439,6.1500681890849611,5.9963294866382242]
["Notes"]
["Figures for 2019 are provisional and may be revised with the publication of 2020 statistics."]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Population figures source: NRS mid-year population estimates for 2013-2019."]
["Source: Scottish Government CP Returns"]

{"sheet":"DATA CP REG","index":6,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,0,2,7],[2,17,2,24],[3,9,3,15],[2,9,2,15]]}
["Child Protection: Registrations: 31 July 2013-2019"]
[]
["Number of registrations following a case conference: 31 July 2013-2019",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 2013-2019"]
[]
["Council",2013,2014,2015,2016,2017,2018,2019,null,{"$f":"'DATA CP CON'!J5","v":2013},{"$f":"'DATA CP CON'!K5","v":2014},{"$f":"'DATA CP CON'!L5","v":2015},{"$f":"'DATA CP CON'!M5","v":2016},{"$f":"'DATA CP CON'!N5","v":2017},{"$f":"'DATA CP CON'!O5","v":2018},{"$f":"'DATA CP CON'!P5","v":2019},null,"Council",2013,2014,2015,2016,2017,2018,2019]
["Aberdeen City",170,167,159,156,164,150,162,null,{"$f":"'DATA CP CON'!J6","v":33131},{"$f":"'DATA CP CON'!K6","v":33511},{"$f":"'DATA CP CON'!L6","v":33851},{"$f":"'DATA CP CON'!M6","v":34187},{"$f":"'DATA CP CON'!N6","v":34495},{"$f":"'DATA CP CON'!O6","v":34833},{"$f":"'DATA CP CON'!P6","v":35423},null,"Aberdeen City",{"$f":"IFERROR(B6*1000/J6,\"*\")","v":5.1311460565633391},{"$f":"IFERROR(C6*1000/K6,\"*\")","v":4.9834382739995826},4.6970547398895155,4.5631380349255561,4.7543122191621974,4.3062613039359228,4.5732998334415491]
["Aberdeenshire",67,95,113,109,124,116,142,null,{"$f":"'DATA CP CON'!J7","v":48112},{"$f":"'DATA CP CON'!K7","v":48669},{"$f":"'DATA CP CON'!L7","v":48856},{"$f":"'DATA CP CON'!M7","v":48871},{"$f":"'DATA CP CON'!N7","v":48888},{"$f":"'DATA CP CON'!O7","v":49033},{"$f":"'DATA CP CON'!P7","v":49016},null,"Aberdeenshire",{"$f":"IFERROR(B7*1000/J7,\"*\")","v":1.3925839707349519},1.9519612073393742,2.3129196004584904,2.2303615641177794,2.5364097529045981,2.3657536760956908,2.8970132201730046]
["Angus",132,176,145,151,126,154,98,null,{"$f":"'DATA CP CON'!J8","v":19757},{"$f":"'DATA CP CON'!K8","v":19676},{"$f":"'DATA CP CON'!L8","v":19653},{"$f":"'DATA CP CON'!M8","v":19445},{"$f":"'DATA CP CON'!N8","v":19288},{"$f":"'DATA CP CON'!O8","v":19253},{"$f":"'DATA CP CON'!P8","v":19145},null,"Angus",6.6811762919471578,8.9449075015246997,7.378008446547601,7.7654924145024431,6.5325591041061797,7.9987534410221786,5.1188299817184646]
["Argyll & Bute",49,47,48,64,73,57,56,null,{"$f":"'DATA CP CON'!J9","v":13814},{"$f":"'DATA CP CON'!K9","v":13575},{"$f":"'DATA CP CON'!L9","v":13292},{"$f":"'DATA CP CON'!M9","v":13238},{"$f":"'DATA CP CON'!N9","v":13163},{"$f":"'DATA CP CON'!O9","v":13024},{"$f":"'DATA CP CON'!P9","v":12906},null,"Argyll & Bute",3.5471261039525119,3.4622467771639043,3.6111947035811016,4.8345671551593901,5.5458482108941727,4.3765356265356266,4.3390671005733763]
["City of Edinburgh",425,451,384,411,302,285,180,null,{"$f":"'DATA CP CON'!J10","v":74440},{"$f":"'DATA CP CON'!K10","v":75329},{"$f":"'DATA CP CON'!L10","v":76108},{"$f":"'DATA CP CON'!M10","v":77364},{"$f":"'DATA CP CON'!N10","v":78052},{"$f":"'DATA CP CON'!O10","v":78501},{"$f":"'DATA CP CON'!P10","v":79067},null,"City of Edinburgh",5.7092960773777541,5.9870700527021468,5.0454617123035685,5.3125484721575926,3.8692153948649617,3.6305269996560554,2.2765502674946565]
["Clackmannanshire",57,69,87,25,46,58,57,null,{"$f":"'DATA CP CON'!J11","v":9180},{"$f":"'DATA CP CON'!K11","v":9087},{"$f":"'DATA CP CON'!L11","v":9029},{"$f":"'DATA CP CON'!M11","v":9024},{"$f":"'DATA CP CON'!N11","v":9020},{"$f":"'DATA CP CON'!O11","v":8980},{"$f":"'DATA CP CON'!P11","v":8946},null,"Clackmannanshire",6.2091503267973858,7.5932651039947174,9.6356185624100128,2.770390070921986,5.0997782705099777,6.4587973273942092,6.3715627095908784]
["Dumfries and Galloway",121,159,168,109,154,191,142,null,{"$f":"'DATA CP CON'!J12","v":24265},{"$f":"'DATA CP CON'!K12","v":23927},{"$f":"'DATA CP CON'!L12","v":23676},{"$f":"'DATA CP CON'!M12","v":23614},{"$f":"'DATA CP CON'!N12","v":23487},{"$f":"'DATA CP CON'!O12","v":23424},{"$f":"'DATA CP CON'!P12","v":23243},null,"Dumfries and Galloway",4.9866062229548733,6.6452125214193174,7.0957932083122151,4.6159058185821973,6.5568186656448244,8.1540300546448083,6.1093662608097059]
["Dundee City",122,132,126,151,143,142,168,null,{"$f":"'DATA CP CON'!J13","v":23753},{"$f":"'DATA CP CON'!K13","v":23716},{"$f":"'DATA CP CON'!L13","v":23798},{"$f":"'DATA CP CON'!M13","v":23849},{"$f":"'DATA CP CON'!N13","v":23998},{"$f":"'DATA CP CON'!O13","v":24016},{"$f":"'DATA CP CON'!P13","v":24044},null,"Dundee City",5.1361933229486798,5.5658627087198518,5.2945625682830491,6.3315023690720782,5.9588299024918747,5.9127248500999334,6.9871901513891199]
["East Ayrshire",112,88,130,140,177,158,189,null,{"$f":"'DATA CP CON'!J14","v":21380},{"$f":"'DATA CP CON'!K14","v":21169},{"$f":"'DATA CP CON'!L14","v":21191},{"$f":"'DATA CP CON'!M14","v":21259},{"$f":"'DATA CP CON'!N14","v":21164},{"$f":"'DATA CP CON'!O14","v":21119},{"$f":"'DATA CP CON'!P14","v":21053},null,"East Ayrshire",5.238540692235734,4.1570220605602533,6.134679816903402,6.5854461639776094,8.3632583632583639,7.4814148397177895,8.9773428964993105]
["East Dunbartonshire",62,75,78,78,77,101,82,null,{"$f":"'DATA CP CON'!J15","v":18326},{"$f":"'DATA CP CON'!K15","v":18384},{"$f":"'DATA CP CON'!L15","v":18544},{"$f":"'DATA CP CON'!M15","v":18810},{"$f":"'DATA CP CON'!N15","v":19061},{"$f":"'DATA CP CON'!O15","v":19224},{"$f":"'DATA CP CON'!P15","v":19398},null,"East Dunbartonshire",3.3831714503983412,4.0796344647519582,4.206212251941329,4.1467304625199359,4.0396621373485129,5.2538493549729504,4.2272399216414067]
["East Lothian",75,83,38,66,62,72,84,null,{"$f":"'DATA CP CON'!J16","v":18729},{"$f":"'DATA CP CON'!K16","v":18807},{"$f":"'DATA CP CON'!L16","v":18915},{"$f":"'DATA CP CON'!M16","v":18989},{"$f":"'DATA CP CON'!N16","v":19051},{"$f":"'DATA CP CON'!O16","v":19350},{"$f":"'DATA CP CON'!P16","v":19700},null,"East Lothian",4.004485023226013,4.4132503854947629,2.0089875759978852,3.4756964558428565,3.2544223400346439,3.7209302325581395,4.2639593908629445]
["East Renfrewshire",51,43,57,29,35,11,26,null,{"$f":"'DATA CP CON'!J17","v":18015},{"$f":"'DATA CP CON'!K17","v":18206},{"$f":"'DATA CP CON'!L17","v":18381},{"$f":"'DATA CP CON'!M17","v":18662},{"$f":"'DATA CP CON'!N17","v":19029},{"$f":"'DATA CP CON'!O17","v":19322},{"$f":"'DATA CP CON'!P17","v":19525},null,"East Renfrewshire",2.8309741881765196,2.3618587278919039,3.1010282356781458,1.5539599185510664,1.8392979137106522,0.5692992443846393,1.3316261203585147]
["Falkirk",93,115,102,116,127,99,128,null,{"$f":"'DATA CP CON'!J18","v":28309},{"$f":"'DATA CP CON'!K18","v":28288},{"$f":"'DATA CP CON'!L18","v":28318},{"$f":"'DATA CP CON'!M18","v":28359},{"$f":"'DATA CP CON'!N18","v":28329},{"$f":"'DATA CP CON'!O18","v":28230},{"$f":"'DATA CP CON'!P18","v":28112},null,"Falkirk",3.2851743261860187,4.065328054298643,3.6019492902041104,4.0904122148171655,4.4830385823714218,3.5069075451647183,4.5532157085941947]
["Fife",318,433,348,294,314,325,318,null,{"$f":"'DATA CP CON'!J19","v":64186},{"$f":"'DATA CP CON'!K19","v":64070},{"$f":"'DATA CP CON'!L19","v":64081},{"$f":"'DATA CP CON'!M19","v":64372},{"$f":"'DATA CP CON'!N19","v":64333},{"$f":"'DATA CP CON'!O19","v":64473},{"$f":"'DATA CP CON'!P19","v":64552},null,"Fife",4.954351416196678,6.7582331824566877,5.4306268628766716,4.5672031317964334,4.8808543049445854,5.0408698214756562,4.9262609988846204]
["Glasgow City",633,708,731,599,488,411,533,null,{"$f":"'DATA CP CON'!J20","v":96447},{"$f":"'DATA CP CON'!K20","v":96709},{"$f":"'DATA CP CON'!L20","v":97532},{"$f":"'DATA CP CON'!M20","v":98487},{"$f":"'DATA CP CON'!N20","v":99137},{"$f":"'DATA CP CON'!O20","v":99938},{"$f":"'DATA CP CON'!P20","v":100666},null,"Glasgow City",6.5631901458832314,7.3209318677682536,7.4949760078743388,6.0820209773878782,4.9224810111260178,4.1125497808641356,5.2947370512387497]
["Highland",150,195,131,168,138,147,151,null,{"$f":"'DATA CP CON'!J21","v":40530},{"$f":"'DATA CP CON'!K21","v":40126},{"$f":"'DATA CP CON'!L21","v":39956},{"$f":"'DATA CP CON'!M21","v":39972},{"$f":"'DATA CP CON'!N21","v":39555},{"$f":"'DATA CP CON'!O21","v":39335},{"$f":"'DATA CP CON'!P21","v":39036},null,"Highland",3.7009622501850483,4.859691970293575,3.2786064671138253,4.2029420594416091,3.4888130451270385,3.737129782636329,3.8682242032995182]
["Inverclyde",48,68,59,57,47,50,64,null,{"$f":"'DATA CP CON'!J22","v":13241},{"$f":"'DATA CP CON'!K22","v":13143},{"$f":"'DATA CP CON'!L22","v":12966},{"$f":"'DATA CP CON'!M22","v":12851},{"$f":"'DATA CP CON'!N22","v":12701},{"$f":"'DATA CP CON'!O22","v":12628},{"$f":"'DATA CP CON'!P22","v":12603},null,"Inverclyde",3.6251038441205345,5.1738568059042835,4.550362486503162,4.4354524939693407,3.700496023935123,3.959455178967374,5.078155994604459]
["Midlothian",129,134,64,99,129,100,112,null,{"$f":"'DATA CP CON'!J23","v":16061},{"$f":"'DATA CP CON'!K23","v":16365},{"$f":"'DATA CP CON'!L23","v":16624},{"$f":"'DATA CP CON'!M23","v":16884},{"$f":"'DATA CP CON'!N23","v":17229},{"$f":"'DATA CP CON'!O23","v":17590},{"$f":"'DATA CP CON'!P23","v":17953},null,"Midlothian",8.0318784633584457,8.1882065383440263,3.8498556304138596,5.863539445628998,7.4873759359219916,5.6850483229107445,6.2385116693588811]
["Moray",94,73,66,87,97,86,95,null,{"$f":"'DATA CP CON'!J24","v":16611},{"$f":"'DATA CP CON'!K24","v":16591},{"$f":"'DATA CP CON'!L24","v":16502},{"$f":"'DATA CP CON'!M24","v":16527},{"$f":"'DATA CP CON'!N24","v":16362},{"$f":"'DATA CP CON'!O24","v":16173},{"$f":"'DATA CP CON'!P24","v":16145},null,"Moray",5.6589007284329664,4.3999758905430655,3.9995152102775422,5.2641132691958612,5.9283706148392614,5.3175044827799418,5.8841746670795914]
["Na h-Eileanan Siar",16,9,"*",5,6,12,6,null,{"$f":"'DATA CP CON'!J25","v":4460},{"$f":"'DATA CP CON'!K25","v":4431},{"$f":"'DATA CP CON'!L25","v":4348},{"$f":"'DATA CP CON'!M25","v":4307},{"$f":"'DATA CP CON'!N25","v":4367},{"$f":"'DATA CP CON'!O25","v":4328},{"$f":"'DATA CP CON'!P25","v":4254},null,"Na h-Eileanan Siar",3.5874439461883409,2.0311442112389981,"*",1.1609008590666356,1.3739409205404167,2.7726432532347505,1.4104372355430184]
["North Ayrshire",200,180,163,150,139,272,237,null,{"$f":"'DATA CP CON'!J26","v":23675},{"$f":"'DATA CP CON'!K26","v":23369},{"$f":"'DATA CP CON'!L26","v":23196},{"$f":"'DATA CP CON'!M26","v":23128},{"$f":"'DATA CP CON'!N26","v":22901},{"$f":"'DATA CP CON'!O26","v":22780},{"$f":"'DATA CP CON'!P26","v":22468},null,"North Ayrshire",8.4477296726504747,7.7025118747058068,7.0270736333850667,6.4856451054998274,6.0696039474258763,11.940298507462687,10.548335410361403]
["North Lanarkshire",188,185,195,240,270,219,282,null,{"$f":"'DATA CP CON'!J27","v":63940},{"$f":"'DATA CP CON'!K27","v":63555},{"$f":"'DATA CP CON'!L27","v":63131},{"$f":"'DATA CP CON'!M27","v":63299},{"$f":"'DATA CP CON'!N27","v":63011},{"$f":"'DATA CP CON'!O27","v":62955},{"$f":"'DATA CP CON'!P27","v":62836},null,"North Lanarkshire",2.9402564904598059,2.9108646054598379,3.0888153205239899,3.7915290920867628,4.284966117027186,3.4786752442220634,4.4878731937106116]
["Orkney Islands",13,12,"*",5,16,10,7,null,{"$f":"'DATA CP CON'!J28","v":3526},{"$f":"'DATA CP CON'!K28","v":3508},{"$f":"'DATA CP CON'!L28","v":3489},{"$f":"'DATA CP CON'!M28","v":3516},{"$f":"'DATA CP CON'!N28","v":3545},{"$f":"'DATA CP CON'!O28","v":3544},{"$f":"'DATA CP CON'!P28","v":3582},null,"Orkney Islands",3.6868973340896201,3.420752565564424,"*",1.422070534698521,4.5133991537376588,2.8216704288939054,1.9542155220547179]
["Perth and Kinross",74,89,111,100,103,109,142,null,{"$f":"'DATA CP CON'!J29","v":24640},{"$f":"'DATA CP CON'!K29","v":24462},{"$f":"'DATA CP CON'!L29","v":24619},{"$f":"'DATA CP CON'!M29","v":24514},{"$f":"'DATA CP CON'!N29","v":24453},{"$f":"'DATA CP CON'!O29","v":24425},{"$f":"'DATA CP CON'!P29","v":24421},null,"Perth and Kinross",3.0032467532467533,3.6382961327773691,4.5087127828100249,4.0793016235620465,4.2121621068989494,4.4626407369498464,5.8146677040252239]
["Renfrewshire",191,137,139,133,194,128,160,null,{"$f":"'DATA CP CON'!J30","v":30113},{"$f":"'DATA CP CON'!K30","v":29973},{"$f":"'DATA CP CON'!L30","v":29831},{"$f":"'DATA CP CON'!M30","v":29954},{"$f":"'DATA CP CON'!N30","v":30039},{"$f":"'DATA CP CON'!O30","v":30171},{"$f":"'DATA CP CON'!P30","v":30267},null,"Renfrewshire",6.3427755454454884,4.5707803689987658,4.659582313700513,4.4401415503772448,6.4582709144778452,4.2424845049882336,5.2862853933326726]
["Scottish Borders",47,36,55,83,51,75,60,null,{"$f":"'DATA CP CON'!J31","v":19030},{"$f":"'DATA CP CON'!K31","v":19069},{"$f":"'DATA CP CON'!L31","v":18975},{"$f":"'DATA CP CON'!M31","v":19002},{"$f":"'DATA CP CON'!N31","v":19026},{"$f":"'DATA CP CON'!O31","v":19046},{"$f":"'DATA CP CON'!P31","v":19023},null,"Scottish Borders",2.4697845507094063,1.8878808537416749,2.8985507246376812,4.3679612672350281,2.6805424156417534,3.937834715950856,3.1540766440624508]
["Shetland Islands",4,26,31,26,13,13,22,null,{"$f":"'DATA CP CON'!J32","v":4357},{"$f":"'DATA CP CON'!K32","v":4307},{"$f":"'DATA CP CON'!L32","v":4254},{"$f":"'DATA CP CON'!M32","v":4233},{"$f":"'DATA CP CON'!N32","v":4233},{"$f":"'DATA CP CON'!O32","v":4205},{"$f":"'DATA CP CON'!P32","v":4198},null,"Shetland Islands",0.91806288730778063,6.0366844671465056,7.287259050305595,6.1422159225135839,3.071107961256792,3.0915576694411415,5.2405907575035728]
["South Ayrshire",77,83,82,81,99,78,77,null,{"$f":"'DATA CP CON'!J33","v":18074},{"$f":"'DATA CP CON'!K33","v":17833},{"$f":"'DATA CP CON'!L33","v":17798},{"$f":"'DATA CP CON'!M33","v":17760},{"$f":"'DATA CP CON'!N33","v":17716},{"$f":"'DATA CP CON'!O33","v":17638},{"$f":"'DATA CP CON'!P33","v":17608},null,"South Ayrshire",4.2602633617350891,4.6542926036000676,4.6072592426115291,4.5608108108108105,5.588168886881915,4.4222700986506407,4.373012267151295]
["South Lanarkshire",249,265,272,273,253,295,220,null,{"$f":"'DATA CP CON'!J34","v":55046},{"$f":"'DATA CP CON'!K34","v":54888},{"$f":"'DATA CP CON'!L34","v":55027},{"$f":"'DATA CP CON'!M34","v":54876},{"$f":"'DATA CP CON'!N34","v":55151},{"$f":"'DATA CP CON'!O34","v":55260},{"$f":"'DATA CP CON'!P34","v":55649},null,"South Lanarkshire",4.5234894451912941,4.8280134091240345,4.9430279680883933,4.9748523944893943,4.5874054867545464,5.3384002895403544,3.9533504645186794]
["Stirling",91,71,66,71,55,88,58,null,{"$f":"'DATA CP CON'!J35","v":15639},{"$f":"'DATA CP CON'!K35","v":15527},{"$f":"'DATA CP CON'!L35","v":15510},{"$f":"'DATA CP CON'!M35","v":15493},{"$f":"'DATA CP CON'!N35","v":15425},{"$f":"'DATA CP CON'!O35","v":15514},{"$f":"'DATA CP CON'!P35","v":15417},null,"Stirling",5.8187863674147966,4.5726798480066977,4.2553191489361701,4.582714774414252,3.5656401944894651,5.6722959907180615,3.7620808198741651]
["West Dunbartonshire",62,65,58,77,128,95,71,null,{"$f":"'DATA CP CON'!J36","v":15782},{"$f":"'DATA CP CON'!K36","v":15698},{"$f":"'DATA CP CON'!L36","v":15709},{"$f":"'DATA CP CON'!M36","v":15764},{"$f":"'DATA CP CON'!N36","v":15790},{"$f":"'DATA CP CON'!O36","v":15705},{"$f":"'DATA CP CON'!P36","v":15647},null,"West Dunbartonshire",3.9285261690533519,4.1406548604917823,3.6921509962441914,4.8845470692717585,8.106396453451552,6.0490289716650745,4.5376110436505401]
["West Lothian",131,153,176,120,137,139,164,null,{"$f":"'DATA CP CON'!J37","v":35010},{"$f":"'DATA CP CON'!K37","v":35073},{"$f":"'DATA CP CON'!L37","v":35102},{"$f":"'DATA CP CON'!M37","v":35307},{"$f":"'DATA CP CON'!N37","v":35443},{"$f":"'DATA CP CON'!O37","v":35485},{"$f":"'DATA CP CON'!P37","v":35494},null,"West Lothian",3.7417880605541276,4.3623299974339238,5.0139593185573474,3.398759452799728,3.8653612843156617,3.9171480907425673,4.6204992393080522]
["Scotland",4251,4622,4401,4273,4287,4246,4293,null,{"$f":"'DATA CP CON'!J38","v":911579},{"$f":"'DATA CP CON'!K38","v":911041},{"$f":"'DATA CP CON'!L38","v":912262},{"$f":"'DATA CP CON'!M38","v":915917},{"$f":"'DATA CP CON'!N38","v":917442},{"$f":"'DATA CP CON'!O38","v":919502},{"$f":"'DATA CP CON'!P38","v":921397},null,"Scotland",4.6633369132022571,5.0733172272158988,4.8242719744985543,4.665269887992034,4.6727749547110333,4.6177169815835093,4.6592294092557278]
["Notes"]
["Figures for 2019 are provisional and may be revised with the publication of 2020 statistics."]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Population figures source: NRS mid-year population estimates for 2013-2019."]
["Source: Scottish Government CP Returns"]

{"sheet":"DATA CP DEREG","index":7,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,9,3,15],[2,9,2,15]]}
["Child Protection: De-registrations: 31 July 2013-2019"]
[]
["Number of de-registrations: 31 July 2013-2019",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 2013-2019"]
[]
["Council",2013,2014,2015,2016,2017,2018,2019,null,{"$f":"'DATA CP CON'!J5","v":2013},{"$f":"'DATA CP CON'!K5","v":2014},{"$f":"'DATA CP CON'!L5","v":2015},{"$f":"'DATA CP CON'!M5","v":2016},{"$f":"'DATA CP CON'!N5","v":2017},{"$f":"'DATA CP CON'!O5","v":2018},{"$f":"'DATA CP CON'!P5","v":2019},null,"Council",{"$f":"B5","v":2013},{"$f":"C5","v":2014},2015,2016,2017,2018,2018]
["Aberdeen City",154,186,134,136,201,162,111,null,{"$f":"'DATA CP CON'!J6","v":33131},{"$f":"'DATA CP CON'!K6","v":33511},{"$f":"'DATA CP CON'!L6","v":33851},{"$f":"'DATA CP CON'!M6","v":34187},{"$f":"'DATA CP CON'!N6","v":34495},{"$f":"'DATA CP CON'!O6","v":34833},{"$f":"'DATA CP CON'!P6","v":35423},null,"Aberdeen City",{"$f":"IFERROR(B6*1000/J6,\"*\")","v":4.6482146630044365},{"$f":"IFERROR(C6*1000/K6,\"*\")","v":5.550416281221092},3.9585241204100323,3.9781203381402288,5.8269314393390346,4.6507622082507964,3.1335572932840243]
["Aberdeenshire",84,79,91,135,111,116,116,null,{"$f":"'DATA CP CON'!J7","v":48112},{"$f":"'DATA CP CON'!K7","v":48669},{"$f":"'DATA CP CON'!L7","v":48856},{"$f":"'DATA CP CON'!M7","v":48871},{"$f":"'DATA CP CON'!N7","v":48888},{"$f":"'DATA CP CON'!O7","v":49033},{"$f":"'DATA CP CON'!P7","v":49016},null,"Aberdeenshire",{"$f":"IFERROR(B7*1000/J7,\"*\")","v":1.7459261722647157},1.6232098461032691,1.8626166693957753,2.7623744142743138,2.2704958271968581,2.3657536760956908,2.3665741798596378]
["Angus",97,156,172,144,170,141,117,null,{"$f":"'DATA CP CON'!J8","v":19757},{"$f":"'DATA CP CON'!K8","v":19676},{"$f":"'DATA CP CON'!L8","v":19653},{"$f":"'DATA CP CON'!M8","v":19445},{"$f":"'DATA CP CON'!N8","v":19288},{"$f":"'DATA CP CON'!O8","v":19253},{"$f":"'DATA CP CON'!P8","v":19145},null,"Angus",4.909652275142987,7.9284407399878027,8.7518445021116378,7.4055026999228595,8.8137702198257983,7.3235339947021245,6.1112562026638813]
["Argyll & Bute",81,42,36,57,82,57,59,null,{"$f":"'DATA CP CON'!J9","v":13814},{"$f":"'DATA CP CON'!K9","v":13575},{"$f":"'DATA CP CON'!L9","v":13292},{"$f":"'DATA CP CON'!M9","v":13238},{"$f":"'DATA CP CON'!N9","v":13163},{"$f":"'DATA CP CON'!O9","v":13024},{"$f":"'DATA CP CON'!P9","v":12906},null,"Argyll & Bute",5.8636166208194584,3.0939226519337018,2.7083960276858261,4.3057863725638317,6.2295829218263314,4.3765356265356266,4.5715171238183787]
["City of Edinburgh",386,400,442,379,353,331,247,null,{"$f":"'DATA CP CON'!J10","v":74440},{"$f":"'DATA CP CON'!K10","v":75329},{"$f":"'DATA CP CON'!L10","v":76108},{"$f":"'DATA CP CON'!M10","v":77364},{"$f":"'DATA CP CON'!N10","v":78052},{"$f":"'DATA CP CON'!O10","v":78501},{"$f":"'DATA CP CON'!P10","v":79067},null,"City of Edinburgh",5.185384202041913,5.3100399580506847,5.8075366584327535,4.8989193940334008,4.5226259416799053,4.2165067960917693,3.1239328670621118]
["Clackmannanshire",39,58,77,64,37,47,69,null,{"$f":"'DATA CP CON'!J11","v":9180},{"$f":"'DATA CP CON'!K11","v":9087},{"$f":"'DATA CP CON'!L11","v":9029},{"$f":"'DATA CP CON'!M11","v":9024},{"$f":"'DATA CP CON'!N11","v":9020},{"$f":"'DATA CP CON'!O11","v":8980},{"$f":"'DATA CP CON'!P11","v":8946},null,"Clackmannanshire",4.2483660130718954,6.3827445801694731,8.5280761989146079,7.0921985815602833,4.1019955654101992,5.2338530066815148,7.7129443326626426]
["Dumfries and Galloway",137,125,192,136,136,176,210,null,{"$f":"'DATA CP CON'!J12","v":24265},{"$f":"'DATA CP CON'!K12","v":23927},{"$f":"'DATA CP CON'!L12","v":23676},{"$f":"'DATA CP CON'!M12","v":23614},{"$f":"'DATA CP CON'!N12","v":23487},{"$f":"'DATA CP CON'!O12","v":23424},{"$f":"'DATA CP CON'!P12","v":23243},null,"Dumfries and Galloway",5.6459921697918816,5.2242236803610984,8.1094779523568175,5.7592953332768699,5.7904372631668579,7.5136612021857925,9.0349782730284378]
["Dundee City",158,111,122,143,152,136,152,null,{"$f":"'DATA CP CON'!J13","v":23753},{"$f":"'DATA CP CON'!K13","v":23716},{"$f":"'DATA CP CON'!L13","v":23798},{"$f":"'DATA CP CON'!M13","v":23849},{"$f":"'DATA CP CON'!N13","v":23998},{"$f":"'DATA CP CON'!O13","v":24016},{"$f":"'DATA CP CON'!P13","v":24044},null,"Dundee City",6.6517913526712418,4.6803845505144208,5.1264812169089842,5.9960585349490545,6.3338611550962582,5.6628914057295132,6.3217434703044422]
["East Ayrshire",125,100,120,160,116,147,198,null,{"$f":"'DATA CP CON'!J14","v":21380},{"$f":"'DATA CP CON'!K14","v":21169},{"$f":"'DATA CP CON'!L14","v":21191},{"$f":"'DATA CP CON'!M14","v":21259},{"$f":"'DATA CP CON'!N14","v":21164},{"$f":"'DATA CP CON'!O14","v":21119},{"$f":"'DATA CP CON'!P14","v":21053},null,"East Ayrshire",5.8465855940130966,4.7238887051821061,5.6627813694492941,7.526224187402982,5.4810054810054814,6.9605568445475638,9.40483541538023]
["East Dunbartonshire",42,75,70,91,73,86,84,null,{"$f":"'DATA CP CON'!J15","v":18326},{"$f":"'DATA CP CON'!K15","v":18384},{"$f":"'DATA CP CON'!L15","v":18544},{"$f":"'DATA CP CON'!M15","v":18810},{"$f":"'DATA CP CON'!N15","v":19061},{"$f":"'DATA CP CON'!O15","v":19224},{"$f":"'DATA CP CON'!P15","v":19398},null,"East Dunbartonshire",2.2918258212375862,4.0796344647519582,3.7748058671268336,4.8378522062732587,3.8298095587849534,4.4735746982937998,4.3303433343643674]
["East Lothian",87,65,80,45,61,88,58,null,{"$f":"'DATA CP CON'!J16","v":18729},{"$f":"'DATA CP CON'!K16","v":18807},{"$f":"'DATA CP CON'!L16","v":18915},{"$f":"'DATA CP CON'!M16","v":18989},{"$f":"'DATA CP CON'!N16","v":19051},{"$f":"'DATA CP CON'!O16","v":19350},{"$f":"'DATA CP CON'!P16","v":19700},null,"East Lothian",4.6452026269421749,3.4561599404477055,4.2294475284166007,2.369793038074675,3.2019316571308591,4.5478036175710592,2.9441624365482233]
["East Renfrewshire",66,33,60,50,26,22,20,null,{"$f":"'DATA CP CON'!J17","v":18015},{"$f":"'DATA CP CON'!K17","v":18206},{"$f":"'DATA CP CON'!L17","v":18381},{"$f":"'DATA CP CON'!M17","v":18662},{"$f":"'DATA CP CON'!N17","v":19029},{"$f":"'DATA CP CON'!O17","v":19322},{"$f":"'DATA CP CON'!P17","v":19525},null,"East Renfrewshire",3.6636136552872607,1.8125892562891355,3.2642402480822588,2.6792412388811488,1.3663355930421988,1.1385984887692786,1.0243277848911652]
["Falkirk",96,100,112,109,129,91,91,null,{"$f":"'DATA CP CON'!J18","v":28309},{"$f":"'DATA CP CON'!K18","v":28288},{"$f":"'DATA CP CON'!L18","v":28318},{"$f":"'DATA CP CON'!M18","v":28359},{"$f":"'DATA CP CON'!N18","v":28329},{"$f":"'DATA CP CON'!O18","v":28230},{"$f":"'DATA CP CON'!P18","v":28112},null,"Falkirk",3.3911476915468577,3.5350678733031673,3.9550815735574547,3.8435769949575089,4.5536376151646722,3.2235210768685794,3.237051792828685]
["Fife",298,416,398,319,296,327,279,null,{"$f":"'DATA CP CON'!J19","v":64186},{"$f":"'DATA CP CON'!K19","v":64070},{"$f":"'DATA CP CON'!L19","v":64081},{"$f":"'DATA CP CON'!M19","v":64372},{"$f":"'DATA CP CON'!N19","v":64333},{"$f":"'DATA CP CON'!O19","v":64473},{"$f":"'DATA CP CON'!P19","v":64552},null,"Fife",4.6427569875050638,6.4928983923833306,6.2108893431750438,4.9555707450444295,4.6010601091197367,5.0718905588385832,4.3220969141157513]
["Glasgow City",639,657,709,592,594,508,427,null,{"$f":"'DATA CP CON'!J20","v":96447},{"$f":"'DATA CP CON'!K20","v":96709},{"$f":"'DATA CP CON'!L20","v":97532},{"$f":"'DATA CP CON'!M20","v":98487},{"$f":"'DATA CP CON'!N20","v":99137},{"$f":"'DATA CP CON'!O20","v":99938},{"$f":"'DATA CP CON'!P20","v":100666},null,"Glasgow City",6.6254004790195653,6.7935766061069804,7.2694090144772998,6.0109456070344311,5.9917084438706034,5.0831515539634573,4.2417499453638765]
["Highland",176,169,158,143,140,168,141,null,{"$f":"'DATA CP CON'!J21","v":40530},{"$f":"'DATA CP CON'!K21","v":40126},{"$f":"'DATA CP CON'!L21","v":39956},{"$f":"'DATA CP CON'!M21","v":39972},{"$f":"'DATA CP CON'!N21","v":39555},{"$f":"'DATA CP CON'!O21","v":39335},{"$f":"'DATA CP CON'!P21","v":39036},null,"Highland",4.3424623735504566,4.2117330409210982,3.9543497847632394,3.577504252977084,3.5393755530274302,4.2710054658700907,3.6120504150015371]
["Inverclyde",54,66,43,59,51,52,47,null,{"$f":"'DATA CP CON'!J22","v":13241},{"$f":"'DATA CP CON'!K22","v":13143},{"$f":"'DATA CP CON'!L22","v":12966},{"$f":"'DATA CP CON'!M22","v":12851},{"$f":"'DATA CP CON'!N22","v":12701},{"$f":"'DATA CP CON'!O22","v":12628},{"$f":"'DATA CP CON'!P22","v":12603},null,"Inverclyde",4.0782418246356018,5.0216845469070988,3.31636587999383,4.5910824060384403,4.0154318557593891,4.117833386126069,3.7292708085376498]
["Midlothian",187,139,89,77,116,119,108,null,{"$f":"'DATA CP CON'!J23","v":16061},{"$f":"'DATA CP CON'!K23","v":16365},{"$f":"'DATA CP CON'!L23","v":16624},{"$f":"'DATA CP CON'!M23","v":16884},{"$f":"'DATA CP CON'!N23","v":17229},{"$f":"'DATA CP CON'!O23","v":17590},{"$f":"'DATA CP CON'!P23","v":17953},null,"Midlothian",11.643110640682398,8.4937366330583561,5.353705486044273,4.5605306799336649,6.7328341749376053,6.7652075042637865,6.015707681167493]
["Moray",74,92,66,68,82,103,110,null,{"$f":"'DATA CP CON'!J24","v":16611},{"$f":"'DATA CP CON'!K24","v":16591},{"$f":"'DATA CP CON'!L24","v":16502},{"$f":"'DATA CP CON'!M24","v":16527},{"$f":"'DATA CP CON'!N24","v":16362},{"$f":"'DATA CP CON'!O24","v":16173},{"$f":"'DATA CP CON'!P24","v":16145},null,"Moray",4.4548792968514839,5.545175094930987,3.9995152102775422,4.1144793368427424,5.0116122723383452,6.3686390898410936,6.8132548776711053]
["Na h-Eileanan Siar",10,16,6,"*",6,11,6,null,{"$f":"'DATA CP CON'!J25","v":4460},{"$f":"'DATA CP CON'!K25","v":4431},{"$f":"'DATA CP CON'!L25","v":4348},{"$f":"'DATA CP CON'!M25","v":4307},{"$f":"'DATA CP CON'!N25","v":4367},{"$f":"'DATA CP CON'!O25","v":4328},{"$f":"'DATA CP CON'!P25","v":4254},null,"Na h-Eileanan Siar",2.2421524663677128,3.6109230422026632,1.3799448022079117,"*",1.3739409205404167,2.5415896487985212,1.4104372355430184]
["North Ayrshire",182,165,180,172,147,178,287,null,{"$f":"'DATA CP CON'!J26","v":23675},{"$f":"'DATA CP CON'!K26","v":23369},{"$f":"'DATA CP CON'!L26","v":23196},{"$f":"'DATA CP CON'!M26","v":23128},{"$f":"'DATA CP CON'!N26","v":22901},{"$f":"'DATA CP CON'!O26","v":22780},{"$f":"'DATA CP CON'!P26","v":22468},null,"North Ayrshire",7.6874340021119325,7.0606358851469899,7.759958613554061,7.4368730543064681,6.418933671018733,7.8138718173836699,12.773722627737227]
["North Lanarkshire",178,202,175,224,254,255,215,null,{"$f":"'DATA CP CON'!J27","v":63940},{"$f":"'DATA CP CON'!K27","v":63555},{"$f":"'DATA CP CON'!L27","v":63131},{"$f":"'DATA CP CON'!M27","v":63299},{"$f":"'DATA CP CON'!N27","v":63011},{"$f":"'DATA CP CON'!O27","v":62955},{"$f":"'DATA CP CON'!P27","v":62836},null,"North Lanarkshire",2.7838598686268377,3.1783494610966878,2.7720137491881958,3.5387604859476451,4.0310421989811305,4.0505122706695262,3.4216054491056083]
["Orkney Islands",6,16,17,"*",14,8,9,null,{"$f":"'DATA CP CON'!J28","v":3526},{"$f":"'DATA CP CON'!K28","v":3508},{"$f":"'DATA CP CON'!L28","v":3489},{"$f":"'DATA CP CON'!M28","v":3516},{"$f":"'DATA CP CON'!N28","v":3545},{"$f":"'DATA CP CON'!O28","v":3544},{"$f":"'DATA CP CON'!P28","v":3582},null,"Orkney Islands",1.7016449234259785,4.5610034207525656,4.8724562912009173,"*",3.9492242595204514,2.2573363431151243,2.512562814070352]
["Perth and Kinross",63,77,90,109,91,115,139,null,{"$f":"'DATA CP CON'!J29","v":24640},{"$f":"'DATA CP CON'!K29","v":24462},{"$f":"'DATA CP CON'!L29","v":24619},{"$f":"'DATA CP CON'!M29","v":24514},{"$f":"'DATA CP CON'!N29","v":24453},{"$f":"'DATA CP CON'!O29","v":24425},{"$f":"'DATA CP CON'!P29","v":24421},null,"Perth and Kinross",2.5568181818181817,3.1477393508298586,3.6557130671432634,4.4464387696826302,3.7214247740563531,4.7082906857727735,5.6918226116866633]
["Renfrewshire",168,168,132,146,159,132,180,null,{"$f":"'DATA CP CON'!J30","v":30113},{"$f":"'DATA CP CON'!K30","v":29973},{"$f":"'DATA CP CON'!L30","v":29831},{"$f":"'DATA CP CON'!M30","v":29954},{"$f":"'DATA CP CON'!N30","v":30039},{"$f":"'DATA CP CON'!O30","v":30171},{"$f":"'DATA CP CON'!P30","v":30267},null,"Renfrewshire",5.5789858200777074,5.6050445400860776,4.424927089269552,4.8741403485344197,5.2931189453710177,4.3750621457691157,5.9470710674992562]
["Scottish Borders",59,45,47,40,77,64,64,null,{"$f":"'DATA CP CON'!J31","v":19030},{"$f":"'DATA CP CON'!K31","v":19069},{"$f":"'DATA CP CON'!L31","v":18975},{"$f":"'DATA CP CON'!M31","v":19002},{"$f":"'DATA CP CON'!N31","v":19026},{"$f":"'DATA CP CON'!O31","v":19046},{"$f":"'DATA CP CON'!P31","v":19023},null,"Scottish Borders",3.1003678402522334,2.3598510671770936,2.476943346508564,2.1050415745710978,4.0470934510669609,3.3602856242780637,3.3643484203332807]
["Shetland Islands",8,10,37,22,27,8,18,null,{"$f":"'DATA CP CON'!J32","v":4357},{"$f":"'DATA CP CON'!K32","v":4307},{"$f":"'DATA CP CON'!L32","v":4254},{"$f":"'DATA CP CON'!M32","v":4233},{"$f":"'DATA CP CON'!N32","v":4233},{"$f":"'DATA CP CON'!O32","v":4205},{"$f":"'DATA CP CON'!P32","v":4198},null,"Shetland Islands",1.8361257746155613,2.3218017181332713,8.6976962858486129,5.1972596267422633,6.3784549964564139,1.9024970273483948,4.2877560743211056]
["South Ayrshire",92,41,112,72,109,94,84,null,{"$f":"'DATA CP CON'!J33","v":18074},{"$f":"'DATA CP CON'!K33","v":17833},{"$f":"'DATA CP CON'!L33","v":17798},{"$f":"'DATA CP CON'!M33","v":17760},{"$f":"'DATA CP CON'!N33","v":17716},{"$f":"'DATA CP CON'!O33","v":17638},{"$f":"'DATA CP CON'!P33","v":17608},null,"South Ayrshire",5.0901847958393276,2.2991083945494308,6.2928418923474547,4.0540540540540544,6.1526303906073609,5.3294024265789774,4.770558836892322]
["South Lanarkshire",216,287,260,298,271,255,284,null,{"$f":"'DATA CP CON'!J34","v":55046},{"$f":"'DATA CP CON'!K34","v":54888},{"$f":"'DATA CP CON'!L34","v":55027},{"$f":"'DATA CP CON'!M34","v":54876},{"$f":"'DATA CP CON'!N34","v":55151},{"$f":"'DATA CP CON'!O34","v":55260},{"$f":"'DATA CP CON'!P34","v":55649},null,"South Lanarkshire",3.9239908440213638,5.2288296166739539,4.7249532047903759,5.4304249580873245,4.9137821617015103,4.6145494028230187,5.103416054196841]
["Stirling",75,66,85,70,51,80,71,null,{"$f":"'DATA CP CON'!J35","v":15639},{"$f":"'DATA CP CON'!K35","v":15527},{"$f":"'DATA CP CON'!L35","v":15510},{"$f":"'DATA CP CON'!M35","v":15493},{"$f":"'DATA CP CON'!N35","v":15425},{"$f":"'DATA CP CON'!O35","v":15514},{"$f":"'DATA CP CON'!P35","v":15417},null,"Stirling",4.7957030500671403,4.2506601404005924,5.48033526756931,4.5181694959013745,3.3063209076175042,5.1566327188346008,4.6053058312252704]
["West Dunbartonshire",61,56,83,45,105,112,81,null,{"$f":"'DATA CP CON'!J36","v":15782},{"$f":"'DATA CP CON'!K36","v":15698},{"$f":"'DATA CP CON'!L36","v":15709},{"$f":"'DATA CP CON'!M36","v":15764},{"$f":"'DATA CP CON'!N36","v":15790},{"$f":"'DATA CP CON'!O36","v":15705},{"$f":"'DATA CP CON'!P36","v":15647},null,"West Dunbartonshire",3.8651628437460399,3.5673334182698433,5.2835953911770321,2.8546054300938848,6.6497783407219764,7.1314867876472459,5.1767111906435739]
["West Lothian",130,176,145,180,134,127,142,null,{"$f":"'DATA CP CON'!J37","v":35010},{"$f":"'DATA CP CON'!K37","v":35073},{"$f":"'DATA CP CON'!L37","v":35102},{"$f":"'DATA CP CON'!M37","v":35307},{"$f":"'DATA CP CON'!N37","v":35443},{"$f":"'DATA CP CON'!O37","v":35485},{"$f":"'DATA CP CON'!P37","v":35494},null,"West Lothian",3.7132247929163098,5.0181050950873889,4.1308187567659962,5.0981391791995918,3.7807183364839321,3.5789770325489645,4.0006761706203866]
["Scotland",4228,4394,4540,4299,4371,4316,4224,null,{"$f":"'DATA CP CON'!J38","v":911579},{"$f":"'DATA CP CON'!K38","v":911041},{"$f":"'DATA CP CON'!L38","v":912262},{"$f":"'DATA CP CON'!M38","v":915917},{"$f":"'DATA CP CON'!N38","v":917442},{"$f":"'DATA CP CON'!O38","v":919502},{"$f":"'DATA CP CON'!P38","v":921397},null,"Scotland",4.6381059677767915,4.8230540667214754,4.9766404826683566,4.6936567396390725,4.7643338761469387,4.6938451466119702,4.584343122454273]
["Notes"]
["Figures for 2019 are provisional and may be revised with the publication of 2020 statistics."]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Population figures source: NRS mid-year population estimates for 2013-2019."]
["Source: Scottish Government CP Returns"]

{"sheet":"DATA CP ON REG","index":8,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,0,2,7],[2,17,2,24],[3,9,3,15],[2,9,2,15],[0,0,0,7]]}
["Child Protection: On Child Protection Registers:  as at 31 July 2012-2018"]
[]
["Number of children on child protection registers: as at 31 July 2013-2019",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 2013-2019"]
[]
["Council",2013,2014,2015,2016,2017,2018,2019,null,{"$f":"'DATA CP CON'!J5","v":2013},{"$f":"'DATA CP CON'!K5","v":2014},{"$f":"'DATA CP CON'!L5","v":2015},{"$f":"'DATA CP CON'!M5","v":2016},{"$f":"'DATA CP CON'!N5","v":2017},{"$f":"'DATA CP CON'!O5","v":2018},{"$f":"'DATA CP CON'!P5","v":2019},null,"Council",{"$f":"B5","v":2013},{"$f":"C5","v":2014},2015,2016,2017,2018,2018]
["Aberdeen City",92,73,98,118,80,68,119,null,{"$f":"'DATA CP CON'!J6","v":33131},{"$f":"'DATA CP CON'!K6","v":33511},{"$f":"'DATA CP CON'!L6","v":33851},{"$f":"'DATA CP CON'!M6","v":34187},{"$f":"'DATA CP CON'!N6","v":34495},{"$f":"'DATA CP CON'!O6","v":34833},{"$f":"'DATA CP CON'!P6","v":35423},null,"Aberdeen City",{"$f":"IFERROR(B6*1000/J6,\"*\")","v":2.7768555129636896},{"$f":"IFERROR(C6*1000/K6,\"*\")","v":2.178389185640536},2.8950400283595759,3.4516044110334336,2.3191766922742425,1.9521717911176184,3.359399260367558]
["Aberdeenshire",52,68,90,64,77,77,103,null,{"$f":"'DATA CP CON'!J7","v":48112},{"$f":"'DATA CP CON'!K7","v":48669},{"$f":"'DATA CP CON'!L7","v":48856},{"$f":"'DATA CP CON'!M7","v":48871},{"$f":"'DATA CP CON'!N7","v":48888},{"$f":"'DATA CP CON'!O7","v":49033},{"$f":"'DATA CP CON'!P7","v":49016},null,"Aberdeenshire",{"$f":"IFERROR(B7*1000/J7,\"*\")","v":1.0808114399733955},1.3971932852534468,1.8421483543474702,1.3095700926930081,1.5750286368843069,1.5703709746497256,2.1013546597029542]
["Angus",94,116,89,96,51,64,45,null,{"$f":"'DATA CP CON'!J8","v":19757},{"$f":"'DATA CP CON'!K8","v":19676},{"$f":"'DATA CP CON'!L8","v":19653},{"$f":"'DATA CP CON'!M8","v":19445},{"$f":"'DATA CP CON'!N8","v":19288},{"$f":"'DATA CP CON'!O8","v":19253},{"$f":"'DATA CP CON'!P8","v":19145},null,"Angus",4.7578073594169155,5.895507216914007,4.5285707016740444,4.9370017999485727,2.6441310659477395,3.3241572741910352,2.3504831548707235]
["Argyll & Bute",16,21,33,40,31,31,28,null,{"$f":"'DATA CP CON'!J9","v":13814},{"$f":"'DATA CP CON'!K9","v":13575},{"$f":"'DATA CP CON'!L9","v":13292},{"$f":"'DATA CP CON'!M9","v":13238},{"$f":"'DATA CP CON'!N9","v":13163},{"$f":"'DATA CP CON'!O9","v":13024},{"$f":"'DATA CP CON'!P9","v":12906},null,"Argyll & Bute",1.1582452584334733,1.5469613259668509,2.482696358712007,3.0216044719746185,2.3550862265441008,2.38022113022113,2.1695335502866882]
["City of Edinburgh",262,313,255,287,235,189,122,null,{"$f":"'DATA CP CON'!J10","v":74440},{"$f":"'DATA CP CON'!K10","v":75329},{"$f":"'DATA CP CON'!L10","v":76108},{"$f":"'DATA CP CON'!M10","v":77364},{"$f":"'DATA CP CON'!N10","v":78052},{"$f":"'DATA CP CON'!O10","v":78501},{"$f":"'DATA CP CON'!P10","v":79067},null,"City of Edinburgh",3.5196131112305213,4.1551062671746601,3.3505019183265885,3.709735794426348,3.0108133039512119,2.4076126418771735,1.5429951813019338]
["Clackmannanshire",32,47,57,18,26,37,25,null,{"$f":"'DATA CP CON'!J11","v":9180},{"$f":"'DATA CP CON'!K11","v":9087},{"$f":"'DATA CP CON'!L11","v":9029},{"$f":"'DATA CP CON'!M11","v":9024},{"$f":"'DATA CP CON'!N11","v":9020},{"$f":"'DATA CP CON'!O11","v":8980},{"$f":"'DATA CP CON'!P11","v":8946},null,"Clackmannanshire",3.4858387799564272,5.1722240563442279,6.3129914719238007,1.9946808510638299,2.8824833702882482,4.1202672605790642,2.7945450480661749]
["Dumfries and Galloway",78,112,88,61,78,93,25,null,{"$f":"'DATA CP CON'!J12","v":24265},{"$f":"'DATA CP CON'!K12","v":23927},{"$f":"'DATA CP CON'!L12","v":23676},{"$f":"'DATA CP CON'!M12","v":23614},{"$f":"'DATA CP CON'!N12","v":23487},{"$f":"'DATA CP CON'!O12","v":23424},{"$f":"'DATA CP CON'!P12","v":23243},null,"Dumfries and Galloway",3.2145064908304142,4.6809044176035437,3.7168440614968743,2.5832133480138899,3.3209860774045215,3.9702868852459017,1.0755926515510046]
["Dundee City",46,67,71,79,69,75,91,null,{"$f":"'DATA CP CON'!J13","v":23753},{"$f":"'DATA CP CON'!K13","v":23716},{"$f":"'DATA CP CON'!L13","v":23798},{"$f":"'DATA CP CON'!M13","v":23849},{"$f":"'DATA CP CON'!N13","v":23998},{"$f":"'DATA CP CON'!O13","v":24016},{"$f":"'DATA CP CON'!P13","v":24044},null,"Dundee City",1.9365974824232728,2.8250969809411366,2.9834439868896547,3.3125078619648622,2.8752396033002752,3.1229180546302464,3.7847279986691067]
["East Ayrshire",61,49,59,39,96,107,98,null,{"$f":"'DATA CP CON'!J14","v":21380},{"$f":"'DATA CP CON'!K14","v":21169},{"$f":"'DATA CP CON'!L14","v":21191},{"$f":"'DATA CP CON'!M14","v":21259},{"$f":"'DATA CP CON'!N14","v":21164},{"$f":"'DATA CP CON'!O14","v":21119},{"$f":"'DATA CP CON'!P14","v":21053},null,"East Ayrshire",2.853133769878391,2.3147054655392321,2.7842008399792366,1.8345171456794769,4.536004536004536,5.0665277712012875,4.6549185389255685]
["East Dunbartonshire",43,43,51,38,42,57,55,null,{"$f":"'DATA CP CON'!J15","v":18326},{"$f":"'DATA CP CON'!K15","v":18384},{"$f":"'DATA CP CON'!L15","v":18544},{"$f":"'DATA CP CON'!M15","v":18810},{"$f":"'DATA CP CON'!N15","v":19061},{"$f":"'DATA CP CON'!O15","v":19224},{"$f":"'DATA CP CON'!P15","v":19398},null,"East Dunbartonshire",2.3463931026956235,2.3389904264577894,2.7502157031924073,2.0202020202020203,2.2034520749173705,2.9650436953807739,2.835343849881431]
["East Lothian",49,67,26,47,45,29,55,null,{"$f":"'DATA CP CON'!J16","v":18729},{"$f":"'DATA CP CON'!K16","v":18807},{"$f":"'DATA CP CON'!L16","v":18915},{"$f":"'DATA CP CON'!M16","v":18989},{"$f":"'DATA CP CON'!N16","v":19051},{"$f":"'DATA CP CON'!O16","v":19350},{"$f":"'DATA CP CON'!P16","v":19700},null,"East Lothian",2.616263548507662,3.5625033232307119,1.3745704467353952,2.475117173100216,2.3620807306703062,1.4987080103359174,2.7918781725888326]
["East Renfrewshire",26,36,33,12,20,9,15,null,{"$f":"'DATA CP CON'!J17","v":18015},{"$f":"'DATA CP CON'!K17","v":18206},{"$f":"'DATA CP CON'!L17","v":18381},{"$f":"'DATA CP CON'!M17","v":18662},{"$f":"'DATA CP CON'!N17","v":19029},{"$f":"'DATA CP CON'!O17","v":19322},{"$f":"'DATA CP CON'!P17","v":19525},null,"East Renfrewshire",1.4432417429919511,1.977370097769966,1.7953321364452424,0.64301789733147574,1.0510273792632299,0.46579029086015938,0.76824583866837393]
["Falkirk",70,85,75,82,80,88,125,null,{"$f":"'DATA CP CON'!J18","v":28309},{"$f":"'DATA CP CON'!K18","v":28288},{"$f":"'DATA CP CON'!L18","v":28318},{"$f":"'DATA CP CON'!M18","v":28359},{"$f":"'DATA CP CON'!N18","v":28329},{"$f":"'DATA CP CON'!O18","v":28230},{"$f":"'DATA CP CON'!P18","v":28112},null,"Falkirk",2.4727118584195837,3.0048076923076925,2.648492125150081,2.8914982897845483,2.8239613117300295,3.1172511512575274,4.446499715424018]
["Fife",213,230,182,157,172,170,209,null,{"$f":"'DATA CP CON'!J19","v":64186},{"$f":"'DATA CP CON'!K19","v":64070},{"$f":"'DATA CP CON'!L19","v":64081},{"$f":"'DATA CP CON'!M19","v":64372},{"$f":"'DATA CP CON'!N19","v":64333},{"$f":"'DATA CP CON'!O19","v":64473},{"$f":"'DATA CP CON'!P19","v":64552},null,"Fife",3.3184806655656995,3.5898236304042452,2.8401554282860753,2.4389486111974152,2.6735889823263332,2.636762675848805,3.2376998388895775]
["Glasgow City",431,482,504,511,405,308,414,null,{"$f":"'DATA CP CON'!J20","v":96447},{"$f":"'DATA CP CON'!K20","v":96709},{"$f":"'DATA CP CON'!L20","v":97532},{"$f":"'DATA CP CON'!M20","v":98487},{"$f":"'DATA CP CON'!N20","v":99137},{"$f":"'DATA CP CON'!O20","v":99938},{"$f":"'DATA CP CON'!P20","v":100666},null,"Glasgow City",4.4687755969599881,4.9840242376614379,5.1675347578230735,5.1885020358016796,4.0852557571845018,3.0819107846865057,4.112610017284883]
["Highland",80,106,79,104,102,81,91,null,{"$f":"'DATA CP CON'!J21","v":40530},{"$f":"'DATA CP CON'!K21","v":40126},{"$f":"'DATA CP CON'!L21","v":39956},{"$f":"'DATA CP CON'!M21","v":39972},{"$f":"'DATA CP CON'!N21","v":39555},{"$f":"'DATA CP CON'!O21","v":39335},{"$f":"'DATA CP CON'!P21","v":39036},null,"Highland",1.9738465334320257,2.6416787120570202,1.9771748923816197,2.6018212748924245,2.578687902919985,2.0592347781873648,2.3311814735116303]
["Inverclyde",24,26,42,40,33,31,48,null,{"$f":"'DATA CP CON'!J22","v":13241},{"$f":"'DATA CP CON'!K22","v":13143},{"$f":"'DATA CP CON'!L22","v":12966},{"$f":"'DATA CP CON'!M22","v":12851},{"$f":"'DATA CP CON'!N22","v":12701},{"$f":"'DATA CP CON'!O22","v":12628},{"$f":"'DATA CP CON'!P22","v":12603},null,"Inverclyde",1.8125519220602673,1.9782393669634026,3.239241092086997,3.1125982413819937,2.5982206125501928,2.4548622109597718,3.8086169959533445]
["Midlothian",59,54,29,51,64,45,49,null,{"$f":"'DATA CP CON'!J23","v":16061},{"$f":"'DATA CP CON'!K23","v":16365},{"$f":"'DATA CP CON'!L23","v":16624},{"$f":"'DATA CP CON'!M23","v":16884},{"$f":"'DATA CP CON'!N23","v":17229},{"$f":"'DATA CP CON'!O23","v":17590},{"$f":"'DATA CP CON'!P23","v":17953},null,"Midlothian",3.673494801070917,3.2997250229147572,1.7444658325312801,3.0206112295664536,3.7146671310000579,2.5582717453098351,2.7293488553445107]
["Moray",64,45,45,64,79,62,47,null,{"$f":"'DATA CP CON'!J24","v":16611},{"$f":"'DATA CP CON'!K24","v":16591},{"$f":"'DATA CP CON'!L24","v":16502},{"$f":"'DATA CP CON'!M24","v":16527},{"$f":"'DATA CP CON'!N24","v":16362},{"$f":"'DATA CP CON'!O24","v":16173},{"$f":"'DATA CP CON'!P24","v":16145},null,"Moray",3.852868581060743,2.7123139051292871,2.7269421888255967,3.872451140557875,4.8282606038381619,3.8335497433994932,2.9111179931867452]
["Na h-Eileanan Siar",14,6,"*","*","*",4,"*",null,{"$f":"'DATA CP CON'!J25","v":4460},{"$f":"'DATA CP CON'!K25","v":4431},{"$f":"'DATA CP CON'!L25","v":4348},{"$f":"'DATA CP CON'!M25","v":4307},{"$f":"'DATA CP CON'!N25","v":4367},{"$f":"'DATA CP CON'!O25","v":4328},{"$f":"'DATA CP CON'!P25","v":4254},null,"Na h-Eileanan Siar",3.1390134529147984,1.3540961408259986,"*","*","*",0.92421441774491686,"*"]
["North Ayrshire",92,107,90,68,60,154,104,null,{"$f":"'DATA CP CON'!J26","v":23675},{"$f":"'DATA CP CON'!K26","v":23369},{"$f":"'DATA CP CON'!L26","v":23196},{"$f":"'DATA CP CON'!M26","v":23128},{"$f":"'DATA CP CON'!N26","v":22901},{"$f":"'DATA CP CON'!O26","v":22780},{"$f":"'DATA CP CON'!P26","v":22468},null,"North Ayrshire",3.8859556494192184,4.57871539218623,3.8799793067770305,2.9401591144932548,2.6199729269464216,6.7603160667251974,4.6288054121417126]
["North Lanarkshire",96,79,99,115,131,95,162,null,{"$f":"'DATA CP CON'!J27","v":63940},{"$f":"'DATA CP CON'!K27","v":63555},{"$f":"'DATA CP CON'!L27","v":63131},{"$f":"'DATA CP CON'!M27","v":63299},{"$f":"'DATA CP CON'!N27","v":63011},{"$f":"'DATA CP CON'!O27","v":62955},{"$f":"'DATA CP CON'!P27","v":62836},null,"North Lanarkshire",1.5014075695964968,1.2430178585477145,1.5681677781121794,1.8167743566249073,2.0790020790020791,1.5090143753474705,2.5781399197912025]
["Orkney Islands","*",6,"*","*","*",5,"*",null,{"$f":"'DATA CP CON'!J28","v":3526},{"$f":"'DATA CP CON'!K28","v":3508},{"$f":"'DATA CP CON'!L28","v":3489},{"$f":"'DATA CP CON'!M28","v":3516},{"$f":"'DATA CP CON'!N28","v":3545},{"$f":"'DATA CP CON'!O28","v":3544},{"$f":"'DATA CP CON'!P28","v":3582},null,"Orkney Islands","*",1.710376282782212,"*","*","*",1.4108352144469527,"*"]
["Perth and Kinross",49,61,82,73,81,75,78,null,{"$f":"'DATA CP CON'!J29","v":24640},{"$f":"'DATA CP CON'!K29","v":24462},{"$f":"'DATA CP CON'!L29","v":24619},{"$f":"'DATA CP CON'!M29","v":24514},{"$f":"'DATA CP CON'!N29","v":24453},{"$f":"'DATA CP CON'!O29","v":24425},{"$f":"'DATA CP CON'!P29","v":24421},null,"Perth and Kinross",1.9886363636363635,2.4936636415665112,3.3307607945083064,2.9778901852002937,3.3124769966875229,3.0706243602865917,3.193972400802588]
["Renfrewshire",109,78,85,72,107,103,83,null,{"$f":"'DATA CP CON'!J30","v":30113},{"$f":"'DATA CP CON'!K30","v":29973},{"$f":"'DATA CP CON'!L30","v":29831},{"$f":"'DATA CP CON'!M30","v":29954},{"$f":"'DATA CP CON'!N30","v":30039},{"$f":"'DATA CP CON'!O30","v":30171},{"$f":"'DATA CP CON'!P30","v":30267},null,"Renfrewshire",3.6196991332647031,2.6023421078971074,2.8493848680902416,2.4036856513320424,3.5620360198408734,3.4138742501077193,2.7422605477913238]
["Scottish Borders",25,16,24,67,39,50,46,null,{"$f":"'DATA CP CON'!J31","v":19030},{"$f":"'DATA CP CON'!K31","v":19069},{"$f":"'DATA CP CON'!L31","v":18975},{"$f":"'DATA CP CON'!M31","v":19002},{"$f":"'DATA CP CON'!N31","v":19026},{"$f":"'DATA CP CON'!O31","v":19046},{"$f":"'DATA CP CON'!P31","v":19023},null,"Scottish Borders",1.3137151865475565,0.83905815721852217,1.2648221343873518,3.5259446374065888,2.0498265531378115,2.6252231439672373,2.4181254271145454]
["Shetland Islands","*",19,13,"*","*",8,12,null,{"$f":"'DATA CP CON'!J32","v":4357},{"$f":"'DATA CP CON'!K32","v":4307},{"$f":"'DATA CP CON'!L32","v":4254},{"$f":"'DATA CP CON'!M32","v":4233},{"$f":"'DATA CP CON'!N32","v":4233},{"$f":"'DATA CP CON'!O32","v":4205},{"$f":"'DATA CP CON'!P32","v":4198},null,"Shetland Islands","*",4.4114232644532159,3.0559473436765399,"*","*",1.9024970273483948,2.8585040495474034]
["South Ayrshire",49,91,61,70,60,44,37,null,{"$f":"'DATA CP CON'!J33","v":18074},{"$f":"'DATA CP CON'!K33","v":17833},{"$f":"'DATA CP CON'!L33","v":17798},{"$f":"'DATA CP CON'!M33","v":17760},{"$f":"'DATA CP CON'!N33","v":17716},{"$f":"'DATA CP CON'!O33","v":17638},{"$f":"'DATA CP CON'!P33","v":17608},null,"South Ayrshire",2.7110766847405112,5.1028991196097122,3.4273513877963815,3.9414414414414414,3.3867690223526754,2.4946139018029254,2.101317582916856]
["South Lanarkshire",198,175,187,162,140,180,116,null,{"$f":"'DATA CP CON'!J34","v":55046},{"$f":"'DATA CP CON'!K34","v":54888},{"$f":"'DATA CP CON'!L34","v":55027},{"$f":"'DATA CP CON'!M34","v":54876},{"$f":"'DATA CP CON'!N34","v":55151},{"$f":"'DATA CP CON'!O34","v":55260},{"$f":"'DATA CP CON'!P34","v":55649},null,"South Lanarkshire",3.5969916070195835,3.1883107418743624,3.3983317280607701,2.9521102121145857,2.5384852495874961,3.2573289902280131,2.0844938812916673]
["Stirling",57,62,43,44,47,55,42,null,{"$f":"'DATA CP CON'!J35","v":15639},{"$f":"'DATA CP CON'!K35","v":15527},{"$f":"'DATA CP CON'!L35","v":15510},{"$f":"'DATA CP CON'!M35","v":15493},{"$f":"'DATA CP CON'!N35","v":15425},{"$f":"'DATA CP CON'!O35","v":15514},{"$f":"'DATA CP CON'!P35","v":15417},null,"Stirling",3.6447343180510261,3.993044374315708,2.7724049000644744,2.8399922545665786,3.0470016207455428,3.5451849941987881,2.7242654212881883]
["West Dunbartonshire",32,41,16,48,71,54,44,null,{"$f":"'DATA CP CON'!J36","v":15782},{"$f":"'DATA CP CON'!K36","v":15698},{"$f":"'DATA CP CON'!L36","v":15709},{"$f":"'DATA CP CON'!M36","v":15764},{"$f":"'DATA CP CON'!N36","v":15790},{"$f":"'DATA CP CON'!O36","v":15705},{"$f":"'DATA CP CON'!P36","v":15647},null,"West Dunbartonshire",2.0276264098339882,2.6117976812332779,1.0185244127570183,3.0449124587668104,4.4965167827739077,3.4383954154727792,2.8120406467693488]
["West Lothian",119,96,127,67,70,82,104,null,{"$f":"'DATA CP CON'!J37","v":35010},{"$f":"'DATA CP CON'!K37","v":35073},{"$f":"'DATA CP CON'!L37","v":35102},{"$f":"'DATA CP CON'!M37","v":35307},{"$f":"'DATA CP CON'!N37","v":35443},{"$f":"'DATA CP CON'!O37","v":35485},{"$f":"'DATA CP CON'!P37","v":35494},null,"West Lothian",3.399028848900314,2.7371482336840303,3.618027462822631,1.8976406944798483,1.9750021160736957,2.3108355643229532,2.9300726883416917]
["Scotland",2645,2877,2741,2715,2600,2530,2599,null,{"$f":"'DATA CP CON'!J38","v":911579},{"$f":"'DATA CP CON'!K38","v":911041},{"$f":"'DATA CP CON'!L38","v":912262},{"$f":"'DATA CP CON'!M38","v":915917},{"$f":"'DATA CP CON'!N38","v":917442},{"$f":"'DATA CP CON'!O38","v":919502},{"$f":"'DATA CP CON'!P38","v":921397},null,"Scotland",2.9015587239284804,3.1579259330809482,3.0046192870030759,2.9642423931426101,2.833966615873265,2.751489393171521,2.8207168028547955]
["Notes"]
["Figures for 2019 are provisional and may be revised with the publication of 2020 statistics."]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Population figures source: NRS mid-year population estimates for 2013-2019."]
["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},28,4,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"]