{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Select an authority","CLA total number","CLA Accommodation","CLA Disability","CLA 3placements","DATA CLA","DATA CLA Acc","DATA CLA DIS","DATA CLA 3P","REF EA Name","REF CAS2","REF CAs"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[1]
["Selecting an Authority and its Standard Comparator Authorities"]
["PLEASE REMEMBER TO 'ENABLE MACROS' - ",null,null,null,"Please select a Local Authority:"]
["THEY MAY HAVE BEEN DISABLED."]
["Last updated: 23/05/2023"]
[]
["Children Looked After publications can be found at:-"]
["Children's Social Work Statistics"]
[]
[]
["To help comparisons between local authorities, we have used the comparators as calculated by HMIE in 2003.  "]
["These were determined by comparing a number of statistical measures between education authorities, such as unemployment rates, looked after children rates, % owner-occupied properties etc.  In order to determine the weight that can be given to comparisons between the local authority and its group, a star rating was introduced which indicates the ‘closeness’ of a particular authority to each member; five stars indicating extremely close and one star indicating not close:"]
["*****","Extremely Close"]
[" ****","Very Close"]
["  ***","Close"]
["   **","Somewhat Close"]
["    *","Not close"]
[]
[{"$f":"OFFSET('REF EA Name'!B35,'Select an authority'!A1,0)","v":0}]
[]
["Comparators","Rating"]
[{"$f":"OFFSET('REF CAS2'!$C$1,'Select an authority'!$A$1,0)","v":"City of Edinburgh"},{"$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":"Dundee City"},{"$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":"South Ayrshire"},{"$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":"Argyll and Bute"},{"$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":"***"}]
["Note: Caution should be exercised when making comparisons with comparator authority averages if there are a number of authorities that are not extremely or very close."]

{"sheet":"CLA total number","index":1,"n_rows":47,"n_cols":30,"rows_kept":47,"cut":false,"hidden":false,"merged":[[11,0,11,7],[12,0,12,7],[13,0,13,7]]}
[{"$f":"'DATA CLA'!A1","v":"Looked after children on 31 July, 2016 to 2022"}]
[null,"select comparators:"]
[{"$f":"J3","v":5},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":5}]
[{"$f":"J4","v":8},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":8}]
[{"$f":"J5","v":28},null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":28}]
[27,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":4}]
[31,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":25}]
[]
[]
[]
[]
[{"$f":"IF(AA22=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(Y22=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(AA22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Y22=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The number of children looked after in \"&A22&\" in \"&AA20&\" was \"&ROUND(AA22,0)&\" (\"&Y44&ROUND((SQRT((Y22*100)^2)),1)&\"% from \"&ROUND(V22,0)&\" in \"&V20&\")\"))))","v":"*  The number of children looked after in Aberdeen City in 2022 was 480 (a decrease of 7% from 516 in 2021)"}]
[{"$f":"IF(Y31=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&Y46&ROUND(SQRT((Y31*100)^2),1)&\"%, while the Scotland figures show \"&Y47&ROUND(SQRT((100*Y33)^2),1)&\"%\")","v":"*  The comparator authorities show a decrease of 3.7%, while the Scotland figures show a decrease of 4.6%"}]
[{"$f":"IF(AA22=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(AC22=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(AA22=\"\",\"[text statement not available due to suppression of data for confidentiality]\",IF(AC22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The rate (per 1,000 pop 0-17) is \"&ROUND(AC22,1)&\".  This is \"&AD40&\" the comparator average rate of \"&ROUND(AC31,1)&\", and \"&AD41&\" the Scotland average rate of \"&ROUND(AC33,1)))))","v":"*  The rate (per 1,000 pop 0-17) is 12.1.  This is less than the comparator average rate of 13.6, and similar to the Scotland average rate of 12.3"}]
[]
[]
[]
[]
[]
[null,{"$f":"'DATA CLA'!C5","v":2017},2017,2017,2017,null,{"$f":"'DATA CLA'!D5","v":2018},2018,2018,2018,null,{"$f":"'DATA CLA'!E5","v":2019},2019,2019,2019,null,{"$f":"'DATA CLA'!F5","v":2020},2020,2020,2020,null,{"$f":"'DATA CLA'!G5","v":2021},2021,2021,2021,null,{"$f":"'DATA CLA'!H5","v":2022},2022,2022]
[null,"Number","Population 0-17","Rate","Percentage change",null,"Number","Population 0-17","Rate","Percentage change",null,"Number","Population 0-17","Rate","Percentage change",null,"Number","Population 0-17","Rate","Percentage change",null,"Number","Population 0-17","Rate","Percentage change",null,"Number","Population 0-17","Rate"]
[{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Aberdeen City"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$C$5,'Select an authority'!$A$1,0))","v":590},{"$f":"VLOOKUP($A$22,'DATA CLA'!$A$6:$P$37,11,FALSE)","v":38221},{"$f":"IF(OFFSET('DATA CLA'!$T$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$T$5,'Select an authority'!$A$1,0))","v":15.436540121922503},{"$f":"IF(B22=\"N/A\",\"N/A\",IF(G22=\"N/A\",\"N/A\",IF(B22=0,\"\",G22/B22-1)))","v":-6.9491525423728828E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$D$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$D$5,'Select an authority'!$A$1,0))","v":549},{"$f":"VLOOKUP($A$22,'DATA CLA'!$A$6:$P$37,12,FALSE)","v":38418},{"$f":"IF(OFFSET('DATA CLA'!$U$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$U$5,'Select an authority'!$A$1,0))","v":14.290176479775106},{"$f":"IF(G22=\"N/A\",\"N/A\",IF(L22=\"N/A\",\"N/A\",IF(G22=0,\"\",L22/G22-1)))","v":-1.2750455373406244E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$E$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$E$5,'Select an authority'!$A$1,0))","v":542},{"$f":"VLOOKUP($A$22,'DATA CLA'!$A$6:$P$37,13,FALSE)","v":38966},{"$f":"IF(OFFSET('DATA CLA'!$V$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$V$5,'Select an authority'!$A$1,0))","v":13.909562182415439},{"$f":"IF(L22=\"N/A\", \"N/A\",IF(Q22=\"N/A\", \"N/A\", IF(L22=0,\"\",Q22/L22-1)))","v":4.4280442804428111E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$F$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$F$5,'Select an authority'!$A$1,0))","v":566},{"$f":"VLOOKUP($A$22,'DATA CLA'!$A$6:$P$37,14,FALSE)","v":39401},{"$f":"IF(OFFSET('DATA CLA'!$W$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$W$5,'Select an authority'!$A$1,0))","v":14.365117636608208},{"$f":"IF(Q22=\"N/A\",\"N/A\",IF(V22=\"N/A\", \"N/A\",IF(Q22=0,\"\",V22/Q22-1)))","v":-8.8339222614840951E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$G$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$G$5,'Select an authority'!$A$1,0))","v":516},{"$f":"VLOOKUP($A$22,'DATA CLA'!$A$6:$P$37,15,FALSE)","v":39663},{"$f":"IF(OFFSET('DATA CLA'!$X$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$X$5,'Select an authority'!$A$1,0))","v":13.009605929959912},{"$f":"IF(V22=\"N/A\",\"N/A\", IF(AA22=\"N/A\", \"N/A\",IF(V22=0,\"\",AA22/V22-1)))","v":-6.9767441860465129E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$H$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$H$5,'Select an authority'!$A$1,0))","v":480},{"$f":"VLOOKUP($A$22,'DATA CLA'!$A$6:$P$37,16,FALSE)","v":39663},{"$f":"IF(OFFSET('DATA CLA'!$Y$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA'!$Y$5,'Select an authority'!$A$1,0))","v":12.101959004613873}]
[]
["Comparator Authorities:"]
[{"$f":"OFFSET('REF EA Name'!$B$2, A3,0)","v":"City of Edinburgh"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,A3,0)=\"\",\"N/A\", IF(A3<33,OFFSET('DATA CLA'!$C$5,A3,0),\"\"))","v":1349},{"$f":"OFFSET('DATA CLA'!$K$5,A3,0)","v":86478},{"$f":"IF(B25=\"N/A\",\"N/A\", IF(B25=0,0,IF(A3<33,B25*1000/C25,\"\")))","v":15.599343185550081},{"$f":"IF(B25=\"N/A\",\"N/A\",IF(G25=\"N/A\", \"N/A\", IF($A3=33,\"\",IF(B25=0,\"\",G25/B25-1))))","v":-2.9651593773165286E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$D$5,A3,0)=\"\",\"N/A\", IF(A3<33,OFFSET('DATA CLA'!$D$5,A3,0),\"\"))","v":1309},{"$f":"OFFSET('DATA CLA'!$L$5,A3,0)","v":86866},{"$f":"IF(G25=\"N/A\",\"N/A\", IF(G25=0,0,IF(A3<33,G25*1000/H25,\"\")))","v":15.069187023691663},{"$f":"IF(G25=\"N/A\",\"N/A\", IF(L25=\"N/A\", \"N/A\",IF($A3=33,\"\",IF(G25=0,\"\",L25/G25-1))))","v":-5.7295645530939687E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$E$5,A3,0)=\"\",\"N/A\", IF(A3<33,OFFSET('DATA CLA'!$E$5,A3,0),\"\"))","v":1234},{"$f":"OFFSET('DATA CLA'!$M$5,A3,0)","v":87481},{"$f":"IF(L25=\"N/A\",\"N/A\", IF(L25=0,0,IF(A3<33,L25*1000/M25,\"\")))","v":14.105920142659549},{"$f":"IF(L25=\"N/A\",\"N/A\", IF(Q25=\"N/A\", \"N/A\",IF($A3=33,\"\",IF(L25=0,\"\",Q25/L25-1))))","v":-4.3760129659643487E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$F$5,A3,0)=\"\",\"N/A\", IF(A3<33,OFFSET('DATA CLA'!$F$5,A3,0),\"\"))","v":1180},{"$f":"OFFSET('DATA CLA'!$N$5,A3,0)","v":87556},{"$f":"IF(Q25=\"N/A\",\"N/A\", IF(Q25=0,0,IF(A3<33,Q25*1000/R25,\"\")))","v":13.477088948787062},{"$f":"IF(Q25=\"N/A\",\"N/A\", IF(V25=\"N/A\", \"N/A\",IF($A3=33,\"\",IF(Q25=0,\"\",V25/Q25-1))))","v":-0.11440677966101698},null,{"$f":"IF(OFFSET('DATA CLA'!$G$5,A3,0)=\"\",\"N/A\", IF(A3<33,OFFSET('DATA CLA'!$G$5,A3,0),\"\"))","v":1045},{"$f":"OFFSET('DATA CLA'!$O$5,A3,0)","v":87551},{"$f":"IF(V25=\"N/A\",\"N/A\", IF(V25=0,0,IF(A3<33,V25*1000/W25,\"\")))","v":11.93590021815856},{"$f":"IF(V25=\"N/A\",\"N/A\", IF(AA25=\"N/A\", \"N/A\",IF($A3=33,\"\",IF(V25=0,\"\",AA25/V25-1))))","v":-2.8708133971291905E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$H$5,A3,0)=\"\",\"N/A\", IF(A3<33,OFFSET('DATA CLA'!$H$5,A3,0),\"\"))","v":1015},{"$f":"OFFSET('DATA CLA'!$P$5,A3,0)","v":87551},{"$f":"IF(AA25=\"N/A\",\"N/A\", IF(AA25=0,0,IF(A3<33,AA25*1000/AB25,\"\")))","v":11.593242795627692}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A4,0)","v":"Dundee City"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,A4,0)=\"\",\"N/A\", IF(A4<33,OFFSET('DATA CLA'!$C$5,A4,0),\"\"))","v":555},{"$f":"OFFSET('DATA CLA'!$K$5,A4,0)","v":26803},{"$f":"IF(B26=\"N/A\",\"N/A\", IF(B26=0,0,IF(A4<33,B26*1000/C26,\"\")))","v":20.706637316718279},{"$f":"IF(B26=\"N/A\",\"N/A\", IF(G26=\"N/A\", \"N/A\",IF($A4=33,\"\",IF(B26=0,\"\",G26/B26-1))))","v":-6.4864864864864868E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$D$5,A4,0)=\"\",\"N/A\", IF(A4<33,OFFSET('DATA CLA'!$D$5,A4,0),\"\"))","v":519},{"$f":"OFFSET('DATA CLA'!$L$5,A4,0)","v":26743},{"$f":"IF(G26=\"N/A\",\"N/A\", IF(G26=0,0,IF(A4<33,G26*1000/H26,\"\")))","v":19.406947612459334},{"$f":"IF(G26=\"N/A\",\"N/A\", IF(L26=\"N/A\", \"N/A\",IF($A4=33,\"\",IF(G26=0,\"\",L26/G26-1))))","v":-0.10789980732177262},null,{"$f":"IF(OFFSET('DATA CLA'!$E$5,A4,0)=\"\",\"N/A\", IF(A4<33,OFFSET('DATA CLA'!$E$5,A4,0),\"\"))","v":463},{"$f":"OFFSET('DATA CLA'!$M$5,A4,0)","v":26763},{"$f":"IF(L26=\"N/A\",\"N/A\", IF(L26=0,0,IF(A4<33,L26*1000/M26,\"\")))","v":17.300003736501885},{"$f":"IF(L26=\"N/A\",\"N/A\",IF(Q26=\"N/A\", \"N/A\", IF($A4=33,\"\",IF(L26=0,\"\",Q26/L26-1))))","v":6.4794816414686762E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$F$5,A4,0)=\"\",\"N/A\", IF(A4<33,OFFSET('DATA CLA'!$F$5,A4,0),\"\"))","v":493},{"$f":"OFFSET('DATA CLA'!$N$5,A4,0)","v":26678},{"$f":"IF(Q26=\"N/A\",\"N/A\", IF(Q26=0,0,IF(A4<33,Q26*1000/R26,\"\")))","v":18.479646150386085},{"$f":"IF(Q26=\"N/A\",\"N/A\",IF(V26=\"N/A\", \"N/A\", IF($A4=33,\"\",IF(Q26=0,\"\",V26/Q26-1))))","v":-0.11359026369168357},null,{"$f":"IF(OFFSET('DATA CLA'!$G$5,A4,0)=\"\",\"N/A\", IF(A4<33,OFFSET('DATA CLA'!$G$5,A4,0),\"\"))","v":437},{"$f":"OFFSET('DATA CLA'!$O$5,A4,0)","v":26530},{"$f":"IF(V26=\"N/A\",\"N/A\", IF(V26=0,0,IF(A4<33,V26*1000/W26,\"\")))","v":16.471918582736524},{"$f":"IF(V26=\"N/A\",\"N/A\",IF(AA26=\"N/A\", \"N/A\", IF($A4=33,\"\",IF(V26=0,\"\",AA26/V26-1))))","v":-4.5766590389015871E-3},null,{"$f":"IF(OFFSET('DATA CLA'!$H$5,A4,0)=\"\",\"N/A\", IF(A4<33,OFFSET('DATA CLA'!$H$5,A4,0),\"\"))","v":435},{"$f":"OFFSET('DATA CLA'!$P$5,A4,0)","v":26530},{"$f":"IF(AA26=\"N/A\",\"N/A\", IF(AA26=0,0,IF(A4<33,AA26*1000/AB26,\"\")))","v":16.396532227666793}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A5,0)","v":"South Ayrshire"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,A5,0)=\"\",\"N/A\", IF(A5<33,OFFSET('DATA CLA'!$C$5,A5,0),\"\"))","v":370},{"$f":"OFFSET('DATA CLA'!$K$5,A5,0)","v":20082},{"$f":"IF(B27=\"N/A\",\"N/A\", IF(B27=0,0,IF(A5<33,B27*1000/C27,\"\")))","v":18.424459715167814},{"$f":"IF(B27=\"N/A\",\"N/A\", IF(G27=\"N/A\", \"N/A\",IF($A5=33,\"\",IF(B27=0,\"\",G27/B27-1))))","v":-4.0540540540540571E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$D$5,A5,0)=\"\",\"N/A\", IF(A5<33,OFFSET('DATA CLA'!$D$5,A5,0),\"\"))","v":355},{"$f":"OFFSET('DATA CLA'!$L$5,A5,0)","v":19881},{"$f":"IF(G27=\"N/A\",\"N/A\", IF(G27=0,0,IF(A5<33,G27*1000/H27,\"\")))","v":17.856244655701424},{"$f":"IF(G27=\"N/A\",\"N/A\", IF(L27=\"N/A\", \"N/A\",IF($A5=33,\"\",IF(G27=0,\"\",L27/G27-1))))","v":-2.8169014084507005E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$E$5,A5,0)=\"\",\"N/A\", IF(A5<33,OFFSET('DATA CLA'!$E$5,A5,0),\"\"))","v":345},{"$f":"OFFSET('DATA CLA'!$M$5,A5,0)","v":19796},{"$f":"IF(L27=\"N/A\",\"N/A\", IF(L27=0,0,IF(A5<33,L27*1000/M27,\"\")))","v":17.427763184481712},{"$f":"IF(L27=\"N/A\",\"N/A\", IF(Q27=\"N/A\", \"N/A\",IF($A5=33,\"\",IF(L27=0,\"\",Q27/L27-1))))","v":-0.13043478260869568},null,{"$f":"IF(OFFSET('DATA CLA'!$F$5,A5,0)=\"\",\"N/A\",IF(A5<33,OFFSET('DATA CLA'!$F$5,A5,0),\"\"))","v":300},{"$f":"OFFSET('DATA CLA'!$N$5,A5,0)","v":19656},{"$f":"IF(Q27=\"N/A\",\"N/A\", IF(Q27=0,0,IF(A5<33,Q27*1000/R27,\"\")))","v":15.262515262515263},{"$f":"IF(Q27=\"N/A\",\"N/A\",IF(V27=\"N/A\", \"N/A\", IF($A5=33,\"\",IF(Q27=0,\"\",V27/Q27-1))))","v":-0.23666666666666669},null,{"$f":"IF(OFFSET('DATA CLA'!$G$5,A5,0)=\"\",\"N/A\", IF(A5<33,OFFSET('DATA CLA'!$G$5,A5,0),\"\"))","v":229},{"$f":"OFFSET('DATA CLA'!$O$5,A5,0)","v":19575},{"$f":"IF(V27=\"N/A\",\"N/A\", IF(V27=0,0,IF(A5<33,V27*1000/W27,\"\")))","v":11.698595146871009},{"$f":"IF(V27=\"N/A\",\"N/A\",IF(AA27=\"N/A\", \"N/A\", IF($A5=33,\"\",IF(V27=0,\"\",AA27/V27-1))))","v":-0.20524017467248912},null,{"$f":"IF(OFFSET('DATA CLA'!$H$5,A5,0)=\"\",\"N/A\", IF(A5<33,OFFSET('DATA CLA'!$H$5,A5,0),\"\"))","v":182},{"$f":"OFFSET('DATA CLA'!$P$5,A5,0)","v":19575},{"$f":"IF(AA27=\"N/A\",\"N/A\", IF(AA27=0,0,IF(A5<33,AA27*1000/AB27,\"\")))","v":9.2975734355044697}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A6,0)","v":"Shetland Islands"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,A6,0)=\"\",\"N/A\", IF(A6<33,OFFSET('DATA CLA'!$C$5,A6,0),\"\"))","v":32},{"$f":"OFFSET('DATA CLA'!$K$5,A6,0)","v":4771},{"$f":"IF(B28=\"N/A\",\"N/A\", IF(B28=0,0,IF(A6<33,B28*1000/C28,\"\")))","v":6.7071892684971708},{"$f":"IF(B28=\"N/A\",\"N/A\", IF(G28=\"N/A\", \"N/A\",IF($A6=33,\"\",IF(B28=0,\"\",G28/B28-1))))","v":-9.375E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$D$5,A6,0)=\"\",\"N/A\", IF(A6<33,OFFSET('DATA CLA'!$D$5,A6,0),\"\"))","v":29},{"$f":"OFFSET('DATA CLA'!$L$5,A6,0)","v":4689},{"$f":"IF(G28=\"N/A\",\"N/A\", IF(G28=0,0,IF(A6<33,G28*1000/H28,\"\")))","v":6.1846875666453398},{"$f":"IF(G28=\"N/A\",\"N/A\", IF(L28=\"N/A\", \"N/A\",IF($A6=33,\"\",IF(G28=0,\"\",L28/G28-1))))","v":0.17241379310344818},null,{"$f":"IF(OFFSET('DATA CLA'!$E$5,A6,0)=\"\",\"N/A\", IF(A6<33,OFFSET('DATA CLA'!$E$5,A6,0),\"\"))","v":34},{"$f":"OFFSET('DATA CLA'!$M$5,A6,0)","v":4691},{"$f":"IF(L28=\"N/A\",\"N/A\", IF(L28=0,0,IF(A6<33,L28*1000/M28,\"\")))","v":7.2479215519079085},{"$f":"IF(L28=\"N/A\",\"N/A\", IF(Q28=\"N/A\", \"N/A\",IF($A6=33,\"\",IF(L28=0,\"\",Q28/L28-1))))","v":-0.17647058823529416},null,{"$f":"IF(OFFSET('DATA CLA'!$F$5,A6,0)=\"\",\"N/A\", IF(A6<33,OFFSET('DATA CLA'!$F$5,A6,0),\"\"))","v":28},{"$f":"OFFSET('DATA CLA'!$N$5,A6,0)","v":4674},{"$f":"IF(Q28=\"N/A\",\"N/A\", IF(Q28=0,0,IF(A6<33,Q28*1000/R28,\"\")))","v":5.9905862216516903},{"$f":"IF(Q28=\"N/A\",\"N/A\",IF(V28=\"N/A\", \"N/A\", IF($A6=33,\"\",IF(Q28=0,\"\",V28/Q28-1))))","v":-7.1428571428571397E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$G$5,A6,0)=\"\",\"N/A\", IF(A6<33,OFFSET('DATA CLA'!$G$5,A6,0),\"\"))","v":26},{"$f":"OFFSET('DATA CLA'!$O$5,A6,0)","v":4624},{"$f":"IF(V28=\"N/A\",\"N/A\", IF(V28=0,0,IF(A6<33,V28*1000/W28,\"\")))","v":5.6228373702422143},{"$f":"IF(V28=\"N/A\",\"N/A\", IF(AA28=\"N/A\", \"N/A\",IF($A6=33,\"\",IF(V28=0,\"\",AA28/V28-1))))","v":3.8461538461538547E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$H$5,A6,0)=\"\",\"N/A\", IF(A6<33,OFFSET('DATA CLA'!$H$5,A6,0),\"\"))","v":27},{"$f":"OFFSET('DATA CLA'!$P$5,A6,0)","v":4624},{"$f":"IF(AA28=\"N/A\",\"N/A\", IF(AA28=0,0,IF(A6<33,AA28*1000/AB28,\"\")))","v":5.8391003460207616}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A7,0)","v":"West Dunbartonshire"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,A7,0)=\"\",\"N/A\", IF(A7<33,OFFSET('DATA CLA'!$C$5,A7,0),\"\"))","v":429},{"$f":"OFFSET('DATA CLA'!$K$5,A7,0)","v":17656},{"$f":"IF(B29=\"N/A\",\"N/A\", IF(B29=0,0,IF(A7<33,B29*1000/C29,\"\")))","v":24.297689170820117},{"$f":"IF(B29=\"N/A\",\"N/A\", IF(G29=\"N/A\", \"N/A\",IF($A7=33,\"\",IF(B29=0,\"\",G29/B29-1))))","v":3.7296037296037365E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$D$5,A7,0)=\"\",\"N/A\", IF(A7<33,OFFSET('DATA CLA'!$D$5,A7,0),\"\"))","v":445},{"$f":"OFFSET('DATA CLA'!$L$5,A7,0)","v":17500},{"$f":"IF(G29=\"N/A\",\"N/A\", IF(G29=0,0,IF(A7<33,G29*1000/H29,\"\")))","v":25.428571428571427},{"$f":"IF(G29=\"N/A\",\"N/A\", IF(L29=\"N/A\", \"N/A\",IF($A7=33,\"\",IF(G29=0,\"\",L29/G29-1))))","v":0.13483146067415741},null,{"$f":"IF(OFFSET('DATA CLA'!$E$5,A7,0)=\"\",\"N/A\", IF(A7<33,OFFSET('DATA CLA'!$E$5,A7,0),\"\"))","v":505},{"$f":"OFFSET('DATA CLA'!$M$5,A7,0)","v":17457},{"$f":"IF(L29=\"N/A\",\"N/A\", IF(L29=0,0,IF(A7<33,L29*1000/M29,\"\")))","v":28.928223635217964},{"$f":"IF(L29=\"N/A\",\"N/A\",IF(Q29=\"N/A\", \"N/A\", IF($A7=33,\"\",IF(L29=0,\"\",Q29/L29-1))))","v":1.980198019801982E-3},null,{"$f":"IF(OFFSET('DATA CLA'!$F$5,A7,0)=\"\",\"N/A\", IF(A7<33,OFFSET('DATA CLA'!$F$5,A7,0),\"\"))","v":506},{"$f":"OFFSET('DATA CLA'!$N$5,A7,0)","v":17331},{"$f":"IF(Q29=\"N/A\",\"N/A\", IF(Q29=0,0,IF(A7<33,Q29*1000/R29,\"\")))","v":29.196237955109343},{"$f":"IF(Q29=\"N/A\",\"N/A\",IF(V29=\"N/A\", \"N/A\", IF($A7=33,\"\",IF(Q29=0,\"\",V29/Q29-1))))","v":-7.9051383399209474E-2},null,{"$f":"IF(OFFSET('DATA CLA'!$G$5,A7,0)=\"\",\"N/A\", IF(A7<33,OFFSET('DATA CLA'!$G$5,A7,0),\"\"))","v":466},{"$f":"OFFSET('DATA CLA'!$O$5,A7,0)","v":17169},{"$f":"IF(V29=\"N/A\",\"N/A\", IF(V29=0,0,IF(A7<33,V29*1000/W29,\"\")))","v":27.141941871978567},{"$f":"IF(V29=\"N/A\", \"N/A\",IF(AA29=\"N/A\",\"N/A\", IF($A7=33,\"\",IF(V29=0,\"\",AA29/V29-1))))","v":-8.5836909871244149E-3},null,{"$f":"IF(OFFSET('DATA CLA'!$H$5,A7,0)=\"\",\"N/A\", IF(A7<33,OFFSET('DATA CLA'!$H$5,A7,0),\"\"))","v":462},{"$f":"OFFSET('DATA CLA'!$P$5,A7,0)","v":17169},{"$f":"IF(AA29=\"N/A\",\"N/A\", IF(AA29=0,0,IF(A7<33,AA29*1000/AB29,\"\")))","v":26.908963830159006}]
[]
["Comparator authorities",{"$f":"SUM(B25:B29)","v":2735},{"$f":"SUM(C25:C29)","v":155790},{"$f":"SUM(B25:B29)/SUM(C25:C29)*1000","v":17.555683933500223},{"$f":"IF(B31=0,\"\",SUM(G25:G29)/SUM(B25:B29)-1)","v":-2.8519195612431436E-2},null,{"$f":"SUM(G25:G29)","v":2657},{"$f":"SUM(H25:H29)","v":155679},{"$f":"SUM(G25:G29)/SUM(H25:H29)*1000","v":17.067170267023812},{"$f":"IF(G31=0,\"\",SUM(L25:L29)/SUM(G25:G29)-1)","v":-2.8603688370342439E-2},null,{"$f":"SUM(L25:L29)","v":2581},{"$f":"SUM(M25:M29)","v":156188},{"$f":"SUM(L25:L29)/SUM(M25:M29)*1000","v":16.524957102978462},{"$f":"IF(L31=0,\"\",SUM(Q25:Q29)/SUM(L25:L29)-1)","v":-2.8671057729562133E-2},null,{"$f":"SUM(Q25:Q29)","v":2507},{"$f":"SUM(R25:R29)","v":155895},{"$f":"SUM(Q25:Q29)/SUM(R25:R29)*1000","v":16.081336797203246},{"$f":"IF(Q31=0,\"\",SUM(V25:V29)/SUM(Q25:Q29)-1)","v":-0.12126047068209012},null,{"$f":"SUM(V25:V29)","v":2203},{"$f":"SUM(W25:W29)","v":155449},{"$f":"SUM(V25:V29)/SUM(W25:W29)*1000","v":14.171850574786585},{"$f":"IF(V31=0,\"\",SUM(AA25:AA29)/SUM(V25:V29)-1)","v":-3.7221970040853369E-2},null,{"$f":"SUM(AA25:AA29)","v":2121},{"$f":"SUM(AB25:AB29)","v":155449},{"$f":"SUM(AA25:AA29)/SUM(AB25:AB29)*1000","v":13.644346377268429}]
[]
["Scotland",{"$f":"'DATA CLA'!C38","v":14897},{"$f":"'DATA CLA'!K38","v":1030055},{"$f":"B33*1000/C33","v":14.462334535534509},{"$f":"IF(B33=0,\"\",G33/B33-1)","v":-2.302477008793713E-2},null,{"$f":"'DATA CLA'!D38","v":14554},{"$f":"'DATA CLA'!L38","v":1028798},{"$f":"G33*1000/H33","v":14.146606039280792},{"$f":"IF(G33=0,\"\",L33/G33-1)","v":-2.006321286244328E-2},null,{"$f":"'DATA CLA'!E38","v":14262},{"$f":"'DATA CLA'!M38","v":1029162},{"$f":"L33*1000/M33","v":13.857876602517388},{"$f":"IF(L33=0,\"\",Q33/L33-1)","v":1.3742813069695714E-2},null,{"$f":"'DATA CLA'!F38","v":14458},{"$f":"'DATA CLA'!$N$38","v":1026922},{"$f":"Q33*1000/R33","v":14.078966075320229},{"$f":"IF(Q33=0,\"\",V33/Q33-1)","v":-8.701065154239862E-2},null,{"$f":"'DATA CLA'!G38","v":13200},{"$f":"'DATA CLA'!$O$38","v":1024981},{"$f":"V33*1000/W33","v":12.878287499963413},{"$f":"IF(V33=0,\"\",AA33/V33-1)","v":-4.5757575757575775E-2},null,{"$f":"'DATA CLA'!H38","v":12596},{"$f":"'DATA CLA'!$P$38","v":1024981},{"$f":"AA33*1000/AB33","v":12.289008284055997}]
[]
["Notes"]
["[Note 1]",{"$f":"IF('DATA CLA'!A40=\"\",\"\",'DATA CLA'!A40)","v":"Population figures source: NRS mid-year population estimates for 2016-2022"}]
["[Note 2]",{"$f":"IF('DATA CLA'!A41=\"\",\"\",'DATA CLA'!A41)","v":"Source: Scottish Government CLAS Returns"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y22-Y31","v":-3.254547181961176E-2},null,null,null,{"$f":"AC22-AC31","v":-1.5423873726545558},{"$f":"IF(AC40<-0.5,\"less than\",IF(AC40>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,null,null,null,{"$f":"Y22-Y33","v":-2.4009866102889355E-2},null,null,null,{"$f":"AC22-AC33","v":-0.18704927944212457},{"$f":"IF(AC41<-0.5,\"less than\",IF(AC41>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,null,null,null,{"$f":"AA22-V22","v":-36}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y43<0,\"a decrease of \",IF(Y43>=0,\"an increase of \"))","v":"a decrease of "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y31<0,\"a decrease of \",IF(Y31>=0,\"an increase of \"))","v":"a decrease of "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y33<0,\"a decrease of \",IF(Y33>=0,\"an increase of \"))","v":"a decrease of "}]

{"sheet":"CLA Accommodation","index":2,"n_rows":59,"n_cols":32,"rows_kept":59,"cut":false,"hidden":false,"merged":[[11,0,11,5],[12,0,12,5],[13,0,13,5]]}
[{"$f":"'DATA CLA Acc'!A1","v":"Looked after children by accommodation type on 31 July, 2019 to 2022"}]
[null,"select comparators:"]
[31,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":5}]
[15,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":8}]
[{"$f":"I5","v":28},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":28}]
[9,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":4}]
[17,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":25}]
[]
[]
[]
[]
[{"$f":"IF(Z18=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(Z18>0,\"*  In \"&Z16&\", \"&ROUND(100*Z18,0)&\"% of looked after children in \"&A18&\" were living at home with parents, \"&Z41&ROUND(SQRT((100*Z37)^2),1)&\"%-points over the previous year.\",\"\"))","v":"*  In In the community, 18% of looked after children in Aberdeen City were living at home with parents, a decrease of 0.5%-points over the previous year."}]
[{"$f":"IF(Z18>0,\"*  This compares with \"&Z42&ROUND(SQRT((100*Z38)^2),1)&\"%-points for comparator authorities, and \"&Z43&ROUND(SQRT((100*Z39)^2),1)&\"%-points for Scotland as a whole.\",\"\")","v":"*  This compares with a decrease of 0.8%-points for comparator authorities, and a decrease of 1.7%-points for Scotland as a whole."}]
[{"$f":"IF(Z18=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(Z18>0,\"*  The percentage of children living at home with parents (\"&ROUND(100*Z18,0)&\"%) is \"&Z56&\" the comparator average (\"&ROUND(100*Z27,0)&\"%), and \"&Z59&\" the Scotland average (\"&ROUND(100*Z29,0)&\"%).\",\"\"))","v":"*  The percentage of children living at home with parents (18%) is similar to the comparator average (18%), and less than the Scotland average (21%)."}]
[null,{"$f":"'DATA CLA Acc'!B3","v":2019},2019,2019,2019,2019,2019,2019,null,2020,2020,2020,2020,2020,2020,2020,null,{"$f":"'DATA CLA Acc'!T3","v":2021},2021,2021,2021,2021,2021,2021,null,{"$f":"'DATA CLA Acc'!AC3","v":2022},2022,2022,2022,2022,2022,2022]
[null,"In the community",null,null,null,null,"In residential accommodation",null,null,"In the community",null,null,null,null,"In residential accommodation",null,null,"In the community",null,null,null,null,"In residential accommodation",null,null,"In the community",null,null,null,null,"In residential accommodation"]
[null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community [Note 1]","In local authority home/ Voluntary Home ","In other residential care [Note 2]",null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community [Note 1]","In local authority home/ Voluntary Home ","In other residential care [Note 2]",null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community [Note 1]","In local authority home/ Voluntary Home ","In other residential care [Note 2]",null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community [Note 1]","In local authority home/ Voluntary Home ","In other residential care [Note 2]"]
[{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Aberdeen City"},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.17896678966789667},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.18081180811808117},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.14944649446494465},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.35608856088560886},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.0590405904059039E-2},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":2.9520295202952029E-2},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":6.4575645756457564E-2},null,{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.21201413427561838},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.18551236749116609},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.13604240282685512},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.32685512367491165},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":3.1802120141342753E-2},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":3.0035335689045935E-2},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":7.7738515901060068E-2},null,{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.18410852713178294},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.20542635658914729},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.15116279069767441},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.31782945736434109},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":3.1007751937984496E-2},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":3.4883720930232558E-2},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":7.5581395348837205E-2},null,{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.17916666666666667},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.20624999999999999},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.15208333333333332},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.30416666666666664},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.3749999999999997E-2},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":3.5416666666666666E-2},{"$f":"IFERROR(VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$48,FALSE)/VLOOKUP($A18,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":7.9166666666666663E-2}]
[]
["Comparator Authorities:"]
[{"$f":"OFFSET('REF EA Name'!$B$2, A3,0)","v":"West Dunbartonshire"},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.2198019801980198},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.43366336633663366},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.12277227722772277},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.10891089108910891},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":1.9801980198019802E-2},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.1584158415841586E-2},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":5.3465346534653464E-2},null,{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.22332015810276679},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.4189723320158103},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.11067193675889328},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.11462450592885376},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.3478260869565216E-2},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.5454545454545456E-2},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.3478260869565216E-2},null,{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.17811158798283261},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.46137339055793991},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":9.8712446351931327E-2},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.12446351931330472},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":1.9313304721030045E-2},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":4.5064377682403435E-2},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":7.2961373390557943E-2},null,{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.1774891774891775},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.45454545454545453},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.10173160173160173},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.12121212121212122},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.1125541125541128E-2},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.1125541125541128E-2},{"$f":"IFERROR(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$48,FALSE)/VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":6.2770562770562768E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A4,0)","v":"Glasgow City"},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.15814506539833531},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.46095917558462146},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.21799445105033691},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":8.4819659135949271E-2},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":7.9270709472849786E-4},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":5.3904082441537854E-2},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":2.3384859294490686E-2},null,{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.18514150943396226},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.45361635220125784},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.1988993710691824},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":7.4685534591194966E-2},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":1.5723270440251573E-3},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.9921383647798745E-2},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":3.6163522012578615E-2},null,{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.16365979381443299},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.49570446735395191},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.20360824742268041},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":6.5292096219931275E-2},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":3.8659793814432991E-3},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":5.1116838487972507E-2},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":1.6752577319587628E-2},null,{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.15004659832246039},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.50745573159366264},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.19944082013047532},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":6.8033550792171479E-2},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":5.1258154706430572E-3},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":5.778191985088537E-2},{"$f":"IFERROR(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$48,FALSE)/VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":1.2115563839701771E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A5,0)","v":"South Ayrshire"},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.20579710144927535},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.2608695652173913},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.32463768115942027},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":7.8260869565217397E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":2.8985507246376812E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":3.4782608695652174E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":6.6666666666666666E-2},null,{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.24666666666666667},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.33666666666666667},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.08},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.04},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.3333333333333335E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":5.3333333333333337E-2},null,{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.18340611353711792},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.20960698689956331},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.37117903930131002},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":8.296943231441048E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":4.3668122270742356E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":4.3668122270742356E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":6.5502183406113537E-2},null,{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.18131868131868131},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.21428571428571427},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.40659340659340659},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":7.1428571428571425E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":1.098901098901099E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":6.043956043956044E-2},{"$f":"IFERROR(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$48,FALSE)/VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":5.4945054945054944E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A6,0)","v":"East Ayrshire"},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.30399999999999999},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.24},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.27733333333333332},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":6.6666666666666666E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":2.6666666666666668E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.5333333333333337E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.04},null,{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.22774869109947643},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.2879581151832461},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.28010471204188481},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":7.8534031413612565E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":2.8795811518324606E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.712041884816754E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.9738219895287955E-2},null,{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.2537313432835821},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.16666666666666666},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.40049751243781095},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":7.7114427860696513E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":4.9751243781094526E-3},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":4.7263681592039801E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":4.975124378109453E-2},null,{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.26614987080103358},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.27906976744186046},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.27648578811369506},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":7.4935400516795869E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":2.5839793281653748E-3},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":5.1679586563307491E-2},{"$f":"IFERROR(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$48,FALSE)/VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.909560723514212E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A7,0)","v":"Inverclyde"},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.47804878048780486},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.21951219512195122},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.12195121951219512},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":2.4390243902439025E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":1.9512195121951219E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":9.2682926829268292E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.3902439024390241E-2},null,{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.46188340807174888},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.22869955156950672},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.14349775784753363},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":2.6905829596412557E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.4843049327354259E-3},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":8.9686098654708515E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.4843049327354258E-2},null,{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.38349514563106796},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.25728155339805825},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.16019417475728157},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":3.8834951456310676E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":4.8543689320388349E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.11165048543689321},null,{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.36787564766839376},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.26424870466321243},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.14507772020725387},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.145077720207254E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.6632124352331605E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":1.0362694300518135E-2},{"$f":"IFERROR(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$48,FALSE)/VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.12435233160621761}]
[]
["Comparator authorities",{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":0.20060713382241335},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":0.4065266885909436},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":0.21578547938274728},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":8.2469010877814317E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":9.1070073362003543E-3},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":5.1859347331140906E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":3.3645332658740194E-2},null,{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":0.21087231352718078},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":0.4048040455120101},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":0.20278128950695323},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":7.7876106194690264E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":1.2642225031605562E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":5.0821744627054362E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":4.0202275600505689E-2},null,{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":0.18920407601211786},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":0.4232993665656844},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":0.22004957312035253},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":7.3808868080418616E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":8.2621867254199944E-3},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":4.9297714128339304E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":3.607821536766731E-2},null,{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":0.18130563798219584},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":0.44421364985163203},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":0.20296735905044511},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":7.4777448071216612E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":1.2462908011869436E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":5.2225519287833831E-2},{"$f":"SUM(IF(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)=\"*\",0,VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)),IF(VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)=\"*\",0,VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)),IF(VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)=\"*\",0,VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)),IF(VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)=\"*\",0,VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)),IF(VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)=\"*\",0,VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$48,FALSE)))/SUM(VLOOKUP($A21,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A22,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A23,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A24,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($A25,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":3.2047477744807124E-2}]
[]
["Scotland",{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.25024540737624457},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.29273594166316086},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.23383817136446503},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.10258028327022858},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":1.9071658953863414E-2},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.9642406394615063E-2},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":5.188613097742252E-2},null,{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.24643795822382072},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.3082030709641721},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.22928482501037487},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":9.8838013556508508E-2},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":1.7913957670493846E-2},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.7447779775902615E-2},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":5.1874394798727345E-2},null,{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.22650047634169579},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.35011114639568119},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.25015878056525881},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.10281041600508098},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":1.7783423308986981E-2},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.8428072403937761E-2},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":4.9772727272727274E-2},null,{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.20935217529374406},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.3373293108923468},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.2279295014290251},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.10193712289615751},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":2.1514766592569068E-2},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":5.0968561448078757E-2},{"$f":"IFERROR(VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$48,FALSE)/VLOOKUP($A29,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":5.0968561448078757E-2}]
[]
["Notes"]
["[Note 1]","In other community includes with prospective adopters."]
["[Note 2]","Other Residential Care includes crisis care, secure accommodation and residential school."]
["[Note 3]","Where data has been suppressed for an authority, for the purposes of aggregating to the group of comparator authorities it has been assumed to be 0. Therefore, the percentages for the aggregated comparator authorities category may be slightly lower than the true figure for placement types where data has been suppressed for one of the individual comparator authorities."]
["[Note 4]","Source: Scottish Government CLAS Returns"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S18-K18","v":1.99139890979812E-2},{"$f":"T18-L18","v":1.5120387870819291E-2},{"$f":"U18-M18","v":-9.025666310570557E-3},{"$f":"V18-N18","v":-7.9436820335825747E-4},null,null,null,{"$f":"Z18-R18","v":-4.9418604651162712E-3},{"$f":"AA18-S18","v":8.2364341085269799E-4},{"$f":"AB18-T18","v":9.2054263565891081E-4},{"$f":"AC18-U18","v":-1.3662790697674454E-2},{"$f":"AD18-V18","v":1.2742248062015502E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S27-K27","v":1.8495321053674296E-2},{"$f":"T27-L27","v":1.7268283613399299E-2},{"$f":"U27-M27","v":-4.0672381142716485E-3},{"$f":"V27-N27","v":-4.3800383061855675E-3},null,null,null,{"$f":"Z27-R27","v":-7.8984380299220169E-3},{"$f":"AA27-S27","v":2.0914283285947632E-2},{"$f":"AB27-T27","v":-1.7082214069907425E-2},{"$f":"AC27-U27","v":9.6857999079799639E-4},{"$f":"AD27-V27","v":4.2007212864494416E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S29-K29","v":4.1908075431509095E-2},{"$f":"T29-L29","v":2.0873955554883944E-2},{"$f":"U29-M29","v":3.9724024485724707E-3},{"$f":"V29-N29","v":-1.3053436150686423E-4},null,null,null,{"$f":"Z29-R29","v":-1.7148301047951731E-2},{"$f":"AA29-S29","v":-1.2781835503334393E-2},{"$f":"AB29-T29","v":-2.2229279136233709E-2},{"$f":"AC29-U29","v":-8.7329310892346468E-4},{"$f":"AD29-V29","v":3.7313432835820864E-3}]
["Comparator authorities"]
["Scotland",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S37<0,\"a decrease of \",IF(S37>=0,\"an increase of \"))","v":"an increase of "},"an increase of ","a decrease of ","a decrease of ",null,null,null,{"$f":"IF(Z37<0,\"a decrease of \",IF(Z37>=0,\"an increase of \"))","v":"a decrease of "},{"$f":"IF(AA37<0,\"a decrease of \",IF(AA37>=0,\"An increase of \"))","v":"An increase of "},{"$f":"IF(AB37<0,\"a decrease of \",IF(AB37>=0,\"an increase of \"))","v":"an increase of "},"a decrease of ","an increase of "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"an increase of ","an increase of ","a decrease of ","a decrease of ",null,null,null,{"$f":"IF(Z38<0,\"a decrease of \",IF(Z38>=0,\"an increase of \"))","v":"a decrease of "},"an increase of ","a decrease of ","an increase of ","an increase of "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"an increase of ","an increase of ","an increase of ","a decrease of ",null,null,null,{"$f":"IF(Z39<0,\"a decrease of \",IF(Z39>=0,\"an increase of \"))","v":"a decrease of "},"a decrease of ","a decrease of ","a decrease of ","an increase of "]
[]
[null,null,{"$f":"IF(C21=\"*\",\"\",C21*$B21)","v":9.5320066660131361E-2},{"$f":"IF(D21=\"*\",\"\",D21*$B21)","v":2.6985589648073717E-2},{"$f":"IF(E21=\"*\",\"\",E21*$B21)","v":2.3938829526517009E-2},{"$f":"IF(F21=\"*\",\"\",F21*$B21)","v":4.3525144593667287E-3},null,null,null,null,{"$f":"IF(K21=\"*\",\"\",K21*$J21)","v":9.3564967426455661E-2},{"$f":"IF(L21=\"*\",\"\",L21*$J21)","v":2.4715274414535453E-2},{"$f":"IF(M21=\"*\",\"\",M21*$J21)","v":2.5597962786483151E-2},{"$f":"IF(N21=\"*\",\"\",N21*$J21)","v":9.7095720914246418E-3},null,null,null,null,{"$f":"IF(S21=\"*\",\"\",S21*$R21)","v":8.2175947245298309E-2},{"$f":"IF(T21=\"*\",\"\",T21*$R21)","v":1.7581830573412661E-2},{"$f":"IF(U21=\"*\",\"\",U21*$R21)","v":2.2168395070824659E-2},{"$f":"IF(V21=\"*\",\"\",V21*$R21)","v":3.4399233730589992E-3},null,null,null,{"$f":"IF(Z21=\"*\",\"\",Z21*$Z21)","v":3.1502408125784753E-2},{"$f":"IF(AA21=\"*\",\"\",AA21*$Z21)","v":8.0676898858717039E-2},{"$f":"IF(AB21=\"*\",\"\",AB21*$Z21)","v":1.8056258315998577E-2},{"$f":"IF(AC21=\"*\",\"\",AC21*$Z21)","v":2.1513839695657878E-2},{"$f":"IF(AD21=\"*\",\"\",AD21*$Z21)","v":7.2993384681696383E-3}]
[null,null,{"$f":"IF(C22=\"*\",\"\",C22*$B22)","v":7.2898418968792691E-2},{"$f":"IF(D22=\"*\",\"\",D22*$B22)","v":3.4474746717829734E-2},1.3413810541119207E-2,1.2536271533756269E-4,null,null,null,null,{"$f":"IF(K22=\"*\",\"\",K22*$J22)","v":8.3983216150468734E-2},3.6824529785214194E-2,1.3827392607096237E-2,2.9110300225465769E-4,null,null,null,null,{"$f":"IF(S22=\"*\",\"\",S22*$R22)","v":8.1126890920041092E-2},3.3322483792113937E-2,1.0685691005066071E-2,6.3270538845785953E-4,null,null,null,{"$f":"IF(Z22=\"*\",\"\",Z22*$Z22)","v":2.2513981668141773E-2},{"$f":"IF(AA22=\"*\",\"\",AA22*$Z22)","v":7.6142006324864578E-2},2.9925416627219502E-2,1.020820286816366E-2,7.6911117499863207E-4]
[null,null,{"$f":"IF(C23=\"*\",\"\",C23*$B23)","v":5.3686200378071827E-2},6.6809493803822714E-2,1.610586011342155E-2,5.9651333753413145E-3,null,null,null,null,4.933333333333334E-2,6.7333333333333342E-2,1.6E-2,8.0000000000000002E-3,null,null,null,null,3.8443202837474495E-2,6.8076505024694423E-2,1.5217101123166989E-2,8.0090005911405207E-3,null,null,null,{"$f":"IF(Z23=\"*\",\"\",Z23*$Z23)","v":3.2876464195145512E-2},3.8854003139717423E-2,7.372298031638691E-2,1.2951334379905807E-2,1.9925129815239707E-3]
[null,null,{"$f":"IF(C24=\"*\",\"\",C24*$B24)","v":7.2959999999999997E-2},8.4309333333333333E-2,2.0266666666666665E-2,8.1066666666666665E-3,null,null,null,null,6.5582083824456572E-2,6.3793481538335015E-2,1.7886022861215427E-2,6.5582083824456561E-3,null,null,null,null,4.228855721393035E-2,0.1016187718125789,1.9566347367639413E-2,1.2623449914606075E-3,null,null,null,{"$f":"IF(Z24=\"*\",\"\",Z24*$Z24)","v":7.0835753727406872E-2},7.4274382549125648E-2,7.3586656784781893E-2,1.9944047165968926E-2,6.8772576434375607E-4]
[null,null,{"$f":"IF(C25=\"*\",\"\",C25*$B25)","v":0.10493753718024985},5.829863176680547E-2,1.1659726353361094E-2,9.3277810826888751E-3,null,null,null,null,0.10563252830340444,6.6279233445273381E-2,1.242735627098876E-2,2.0712260451647931E-3,null,null,null,null,9.8666226788575742E-2,6.1433688377792443E-2,1.4893015364313318E-2,0,null,null,null,{"$f":"IF(Z25=\"*\",\"\",Z25*$Z25)","v":0.13533249214744017},9.7210663373513376E-2,5.3370560283497535E-2,1.5248731509570726E-2,1.7154822948267066E-2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S18-S27","v":-0.21787300997653711},{"$f":"T18-T27","v":-6.8886782422678122E-2},{"$f":"U18-U27","v":0.24402058928392248},{"$f":"V18-V27","v":2.2745565212564503E-2},null,null,null,{"$f":"Z18-Z27","v":-2.1389713155291756E-3},{"$f":"AA18-AA27","v":-0.23796364985163204},{"$f":"AB18-AB27","v":-5.0884025717111786E-2},{"$f":"AC18-AC27","v":0.22938921859545003},{"$f":"AD18-AD27","v":3.128709198813056E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S18-S29","v":-0.1446847898065339},{"$f":"T18-T29","v":-9.89959898675844E-2},{"$f":"U18-U29","v":0.21501904135926012},{"$f":"V18-V29","v":1.3224328628997514E-2},null,null,null,{"$f":"Z18-Z29","v":-3.018550862707739E-2},{"$f":"AA18-AA29","v":-0.13107931089234681},{"$f":"AB18-AB29","v":-7.5846168095691779E-2},{"$f":"AC18-AC29","v":0.20222954377050911},{"$f":"AD18-AD29","v":2.2235233407430929E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S52<-0.02,\"less than\",IF(S52>0.02,\"greater than\",\"similar to\"))","v":"less than"},null,null,null,null,null,null,{"$f":"IF(Z52<-0.02,\"less than\",IF(Z52>0.02,\"greater than\",\"similar to\"))","v":"similar to"},{"$f":"IF(AA52<-0.02,\"less than\",IF(AA52>0.02,\"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,{"$f":"IF(S54<-0.02,\"less than\",IF(S54>0.02,\"greater than\",\"similar to\"))","v":"less than"},null,null,null,null,null,null,{"$f":"IF(Z54<-0.02,\"less than\",IF(Z54>0.02,\"greater than\",\"similar to\"))","v":"less than"},{"$f":"IF(AA54<-0.02,\"less than\",IF(AA54>0.02,\"greater than\",\"similar to\"))","v":"less than"}]

{"sheet":"CLA Disability","index":3,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[11,0,11,5],[12,0,12,5],[13,0,13,5]]}
[{"$f":"'DATA CLA DIS'!A1","v":"Looked after children by disability status on 31 July, 2019 to 2022"}]
[null,"select comparators:"]
[32,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":5}]
[26,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":8}]
[14,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":28}]
[{"$f":"I6","v":4},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":4}]
[30,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":25}]
[]
[]
[]
[]
[{"$f":"IF(K18=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(O18=\"N/A\",\"[text statement not available due to due to data being unavailable]\",IF(K18=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(O18=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  In \"&N16&\", the percentage of looked after children with a disability in \"&A18&\" was \"&ROUND(100*P18,0)&\"%, \"&M37&ROUND(SQRT((100*M31)^2),1)&\"%-points over the previous year.\"))))","v":"*  In 2022, the percentage of looked after children with a disability in Aberdeen City was 25%, an increase of 0.4%-points over the previous year."}]
[{"$f":"IF(K27=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(O27=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(K27=0,\"[text statement not available due to suppression of data for confidentiality]\",IF(O27=0,\"[text statement not available due to suppression of data for confidentiality]\",\"*  This compares with \"&M38&ROUND(SQRT((100*M32)^2),1)&\"%-points for comparator authorities, and \"&M39&ROUND(SQRT((100*M33)^2),1)&\"%-points for Scotland as a whole.\"))))","v":"*  This compares with a decrease of 1.5%-points for comparator authorities, and a decrease of 0%-points for Scotland as a whole."}]
[{"$f":"IF(O18=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(O27=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(O18=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(O27=0,\"[text statement not available due to suppression of data for confidentiality]\",\"*  The percentage looked after children with a disability (\"&ROUND(100*P18,0)&\"%) is \"&P36&\" the comparator average (\"&ROUND(100*P27,0)&\"%), and \"&P40&\" the Scotland average (\"&ROUND(100*P29,0)&\"%).\"))))","v":"*  The percentage looked after children with a disability (25%) is greater than the comparator average (9%), and greater than the Scotland average (10%)."}]
[]
[null,{"$f":"'DATA CLA DIS'!B3","v":2019},2019,2019,null,{"$f":"'DATA CLA DIS'!E3","v":2020},2020,2020,null,{"$f":"'DATA CLA DIS'!H3","v":2021},2021,2021,null,{"$f":"'DATA CLA DIS'!K3","v":2022},2022,2022]
[null,{"$f":"'DATA CLA DIS'!B4","v":"Number of children looked after "},{"$f":"'DATA CLA DIS'!C4","v":"Number of children looked after with a disability"},{"$f":"'DATA CLA DIS'!D4","v":"Percentage of children looked after with a disability"},null,{"$f":"'DATA CLA DIS'!E4","v":"Number of children looked after "},{"$f":"'DATA CLA DIS'!F4","v":"Number of children looked after with a disability"},{"$f":"'DATA CLA DIS'!G4","v":"Percentage of children looked after with a disability"},null,{"$f":"'DATA CLA DIS'!H4","v":"Number of children looked after "},{"$f":"'DATA CLA DIS'!I4","v":"Number of children looked after with a disability"},{"$f":"'DATA CLA DIS'!J4","v":"Percentage of children looked after with a disability"},null,{"$f":"'DATA CLA DIS'!K4","v":"Number of children looked after "},{"$f":"'DATA CLA DIS'!L4","v":"Number of children looked after with a disability"},{"$f":"'DATA CLA DIS'!M4","v":"Percentage of children looked after with a disability"}]
[{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Aberdeen City"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA DIS'!$B$4,'Select an authority'!$A$1,0))","v":542},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA DIS'!$C$4,'Select an authority'!$A$1,0)<5,\"*\",OFFSET('DATA CLA DIS'!$C$4,'Select an authority'!$A$1,0)))","v":142},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(C18=\"*\",\"\",OFFSET('DATA CLA DIS'!$D$4,'Select an authority'!$A$1,0)))","v":0.26199261992619927},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA DIS'!$E$4,'Select an authority'!$A$1,0))","v":549},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA DIS'!$F$4,'Select an authority'!$A$1,0)<5,\"*\",OFFSET('DATA CLA DIS'!$F$4,'Select an authority'!$A$1,0)))","v":130},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(G18=\"*\",\"\",OFFSET('DATA CLA DIS'!$G$4,'Select an authority'!$A$1,0)))","v":0.22968197879858657},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA DIS'!$H$4,'Select an authority'!$A$1,0))","v":516},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA DIS'!$I$4,'Select an authority'!$A$1,0)<5,\"*\",OFFSET('DATA CLA DIS'!$I$4,'Select an authority'!$A$1,0)))","v":129},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(K18=\"*\",\"\",OFFSET('DATA CLA DIS'!$J$4,'Select an authority'!$A$1,0)))","v":0.25},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",(OFFSET('DATA CLA DIS'!$K$4,'Select an authority'!$A$1,0)))","v":480},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA DIS'!$L$4,'Select an authority'!$A$1,0)<5,\"*\",OFFSET('DATA CLA DIS'!$L$4,'Select an authority'!$A$1,0)))","v":122},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$4,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(O18=\"*\",\"\",OFFSET('DATA CLA DIS'!$M$4,'Select an authority'!$A$1,0)))","v":0.25416666666666665}]
[]
["Comparator Authorities:"]
[{"$f":"OFFSET('REF EA Name'!$B$2, A3,0)","v":"West Lothian"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$4,$A3,0)=\"\",\"N/A\",IF($A3<33,OFFSET('DATA CLA DIS'!$B$4,$A3,0),\"\"))","v":427},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$4,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",OFFSET('DATA CLA DIS'!$C$4,$A3,0)))","v":46},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$4,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",OFFSET('DATA CLA DIS'!$D$4,$A3,0)))","v":0.10772833723653395},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$4,$A3,0)=\"\",\"N/A\",IF($A3<33,OFFSET('DATA CLA DIS'!$E$4,$A3,0),\"\"))","v":443},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$4,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",OFFSET('DATA CLA DIS'!$F$4,$A3,0)))","v":31},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$4,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",OFFSET('DATA CLA DIS'!$G$4,$A3,0)))","v":7.045454545454545E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$4,$A3,0)=\"\",\"N/A\",IF($A3<33,OFFSET('DATA CLA DIS'!$H$4,$A3,0),\"\"))","v":379},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$4,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",OFFSET('DATA CLA DIS'!$I$4,$A3,0)))","v":21},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$4,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",OFFSET('DATA CLA DIS'!$J$4,$A3,0)))","v":5.5408970976253295E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$4,$A3,0)=\"\",\"N/A\",IF($A3<33,OFFSET('DATA CLA DIS'!$K$4,$A3,0),\"\"))","v":373},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$4,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",OFFSET('DATA CLA DIS'!$L$4,$A3,0)))","v":17},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$4,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",OFFSET('DATA CLA DIS'!$M$4,$A3,0)))","v":4.5576407506702415E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A4,0)","v":"Scottish Borders"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$4,$A4,0)=\"\",\"N/A\",IF($A4<33,OFFSET('DATA CLA DIS'!$B$4,$A4,0),\"\"))","v":195},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$4,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",OFFSET('DATA CLA DIS'!$C$4,$A4,0)))","v":15},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$4,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",OFFSET('DATA CLA DIS'!$D$4,$A4,0)))","v":7.6923076923076927E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$4,$A4,0)=\"\",\"N/A\",IF($A4<33,OFFSET('DATA CLA DIS'!$E$4,$A4,0),\"\"))","v":205},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$4,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",OFFSET('DATA CLA DIS'!$F$4,$A4,0)))","v":13},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$4,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",OFFSET('DATA CLA DIS'!$G$4,$A4,0)))","v":6.9518716577540107E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$4,$A4,0)=\"\",\"N/A\",IF($A4<33,OFFSET('DATA CLA DIS'!$H$4,$A4,0),\"\"))","v":174},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$4,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",OFFSET('DATA CLA DIS'!$I$4,$A4,0)))","v":12},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$4,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",OFFSET('DATA CLA DIS'!$J$4,$A4,0)))","v":6.8965517241379309E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$4,$A4,0)=\"\",\"N/A\",IF($A4<33,OFFSET('DATA CLA DIS'!$K$4,$A4,0),\"\"))","v":183},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$4,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",OFFSET('DATA CLA DIS'!$L$4,$A4,0)))","v":8},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$4,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",OFFSET('DATA CLA DIS'!$M$4,$A4,0)))","v":4.3715846994535519E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A5,0)","v":"Fife"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$4,$A5,0)=\"\",\"N/A\",IF($A5<33,OFFSET('DATA CLA DIS'!$B$4,$A5,0),\"\"))","v":935},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$4,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",OFFSET('DATA CLA DIS'!$C$4,$A5,0)))","v":0},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$4,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",OFFSET('DATA CLA DIS'!$D$4,$A5,0)))","v":0},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$4,$A5,0)=\"\",\"N/A\",IF($A5<33,OFFSET('DATA CLA DIS'!$E$4,$A5,0),\"\"))","v":941},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$4,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",OFFSET('DATA CLA DIS'!$F$4,$A5,0)))","v":0},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$4,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",OFFSET('DATA CLA DIS'!$G$4,$A5,0)))","v":0},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$4,$A5,0)=\"\",\"N/A\",IF($A5<33,OFFSET('DATA CLA DIS'!$H$4,$A5,0),\"\"))","v":810},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$4,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",OFFSET('DATA CLA DIS'!$I$4,$A5,0)))","v":0},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$4,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",OFFSET('DATA CLA DIS'!$J$4,$A5,0)))","v":0},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$4,$A5,0)=\"\",\"N/A\",IF($A5<33,OFFSET('DATA CLA DIS'!$K$4,$A5,0),\"\"))","v":748},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$4,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",OFFSET('DATA CLA DIS'!$L$4,$A5,0)))","v":0},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$4,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",OFFSET('DATA CLA DIS'!$M$4,$A5,0)))","v":0}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A6,0)","v":"Argyll & Bute"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$4,$A6,0)=\"\",\"N/A\",IF($A6<33,OFFSET('DATA CLA DIS'!$B$4,$A6,0),\"\"))","v":150},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$4,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",OFFSET('DATA CLA DIS'!$C$4,$A6,0)))","v":34},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$4,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",OFFSET('DATA CLA DIS'!$D$4,$A6,0)))","v":0.22666666666666666},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$4,$A6,0)=\"\",\"N/A\",IF($A6<33,OFFSET('DATA CLA DIS'!$E$4,$A6,0),\"\"))","v":149},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$4,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",OFFSET('DATA CLA DIS'!$F$4,$A6,0)))","v":39},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$4,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",OFFSET('DATA CLA DIS'!$G$4,$A6,0)))","v":0.24074074074074073},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$4,$A6,0)=\"\",\"N/A\",IF($A6<33,OFFSET('DATA CLA DIS'!$H$4,$A6,0),\"\"))","v":151},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$4,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",OFFSET('DATA CLA DIS'!$I$4,$A6,0)))","v":45},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$4,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",OFFSET('DATA CLA DIS'!$J$4,$A6,0)))","v":0.29801324503311261},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$4,$A6,0)=\"\",\"N/A\",IF($A6<33,OFFSET('DATA CLA DIS'!$K$4,$A6,0),\"\"))","v":144},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$4,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",OFFSET('DATA CLA DIS'!$L$4,$A6,0)))","v":37},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$4,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",OFFSET('DATA CLA DIS'!$M$4,$A6,0)))","v":0.25694444444444442}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A7,0)","v":"Stirling"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$4,$A7,0)=\"\",\"N/A\",IF($A7<33,OFFSET('DATA CLA DIS'!$B$4,$A7,0),\"\"))","v":238},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$4,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",OFFSET('DATA CLA DIS'!$C$4,$A7,0)))","v":25},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$4,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",OFFSET('DATA CLA DIS'!$D$4,$A7,0)))","v":0.10504201680672269},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$4,$A7,0)=\"\",\"N/A\",IF($A7<33,OFFSET('DATA CLA DIS'!$E$4,$A7,0),\"\"))","v":236},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$4,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",OFFSET('DATA CLA DIS'!$F$4,$A7,0)))","v":23},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$4,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",OFFSET('DATA CLA DIS'!$G$4,$A7,0)))","v":9.3495934959349589E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$4,$A7,0)=\"\",\"N/A\",IF($A7<33,OFFSET('DATA CLA DIS'!$H$4,$A7,0),\"\"))","v":230},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$4,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",OFFSET('DATA CLA DIS'!$I$4,$A7,0)))","v":21},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$4,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",OFFSET('DATA CLA DIS'!$J$4,$A7,0)))","v":9.1304347826086957E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$4,$A7,0)=\"\",\"N/A\",IF($A7<33,OFFSET('DATA CLA DIS'!$K$4,$A7,0),\"\"))","v":210},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$4,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",OFFSET('DATA CLA DIS'!$L$4,$A7,0)))","v":21},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$4,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",OFFSET('DATA CLA DIS'!$M$4,$A7,0)))","v":0.1}]
[]
["Comparator authorities",{"$f":"SUM(B21:B25)","v":1945},{"$f":"SUM(C21:C25)","v":120},{"$f":"IF(C27=0,0,C27/(SUMIF(C21,\">0\",B21)+SUMIF(C22,\">0\",B22)+SUMIF(C23,\">0\",B23)+SUMIF(C24,\">0\",B24)+SUMIF(C25,\">0\",B25)))","v":0.11881188118811881},null,{"$f":"SUM(F21:F25)","v":1974},{"$f":"SUM(G21:G25)","v":106},{"$f":"IF(G27=0,0,G27/(SUMIF(G21,\">0\",F21)+SUMIF(G22,\">0\",F22)+SUMIF(G23,\">0\",F23)+SUMIF(G24,\">0\",F24)+SUMIF(G25,\">0\",F25)))","v":0.10261374636979671},null,{"$f":"SUM(J21:J25)","v":1744},{"$f":"SUM(K21:K25)","v":99},{"$f":"IF(K27=0,0,K27/(SUMIF(K21,\">0\",J21)+SUMIF(K22,\">0\",J22)+SUMIF(K23,\">0\",J23)+SUMIF(K24,\">0\",J24)+SUMIF(K25,\">0\",J25)))","v":0.10599571734475374},null,{"$f":"SUM(N21:N25)","v":1658},{"$f":"SUM(O21:O25)","v":83},{"$f":"IF(O27=0,0,O27/(SUMIF(O21,\">0\",N21)+SUMIF(O22,\">0\",N22)+SUMIF(O23,\">0\",N23)+SUMIF(O24,\">0\",N24)+SUMIF(O25,\">0\",N25)))","v":9.1208791208791204E-2}]
[]
["Scotland",{"$f":"'DATA CLA DIS'!B37","v":14262},{"$f":"'DATA CLA DIS'!C37","v":1535},{"$f":"'DATA CLA DIS'!D37","v":0.10762866358154537},null,{"$f":"'DATA CLA DIS'!E37","v":14554},{"$f":"'DATA CLA DIS'!F37","v":1381},{"$f":"'DATA CLA DIS'!G37","v":9.5524659334578405E-2},null,{"$f":"'DATA CLA DIS'!H37","v":13200},{"$f":"'DATA CLA DIS'!I37","v":1280},{"$f":"'DATA CLA DIS'!J37","v":9.696969696969697E-2},null,{"$f":"'DATA CLA DIS'!K37","v":12596},{"$f":"'DATA CLA DIS'!L37","v":1216},{"$f":"'DATA CLA DIS'!M37","v":9.6538583677357889E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L18-H18","v":2.0318021201413433E-2},{"$f":"P18-L18","v":4.1666666666666519E-3}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L27-H27","v":3.3819709749570298E-3},{"$f":"P27-L27","v":-1.4786926135962539E-2},null,{"$f":"L18-L27","v":0.14400428265524626},{"$f":"P18-P27","v":0.16295787545787543}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L29-H29","v":1.4450376351185651E-3},{"$f":"P29-L29","v":-4.3111329233908036E-4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L18-L29","v":0.15303030303030302},{"$f":"P18-P29","v":0.15762808298930875}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O32<-0.02,\"less than\",IF(O32>0.02,\"greater than\",\"similar to\"))","v":"greater than"},{"$f":"IF(P32<-0.02,\"less than\",IF(P32>0.02,\"greater than\",\"similar to\"))","v":"greater than"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L31<0,\"a decrease of \",IF(L31>=0,\"an increase of \"))","v":"an increase of "},"an increase of "]
[null,null,null,null,null,null,null,null,null,null,null,"an increase of ","a decrease of "]
[null,null,null,null,null,null,null,null,null,null,null,"an increase of ","a decrease of "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O34<-0.02,\"less than\",IF(O34>0.02,\"greater than\",\"similar to\"))","v":"greater than"},{"$f":"IF(P34<-0.02,\"less than\",IF(P34>0.02,\"greater than\",\"similar to\"))","v":"greater than"}]

{"sheet":"CLA 3placements","index":4,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[11,0,11,3],[12,0,12,3],[13,0,13,3]]}
[{"$f":"'DATA CLA 3P'!A1","v":"Looked after children with 3 or more placements during the year for those looked on 31 July, 2019 to 2022"}]
[null,"select comparators:"]
[{"$f":"H3","v":5},null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":5}]
[30,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":8}]
[{"$f":"H5","v":28},null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":28}]
[{"$f":"H6","v":4},null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":4}]
[31,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":25}]
[]
[]
[]
[]
[{"$f":"IF($M$19=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(Q19=\"N/A\",\"[text statement not available due to data being unavailable]\",IF($M$19=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Q19=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  In \"&$O$17&\", \"&ROUND(100*$Q$19,0)&\"% of children looked after in \"&$A$19&\" have had 3 or more placements during the past year, \"&P37&ROUND(SQRT((100*O37)^2),1)&\" %-points over the previous year.\"))))","v":"*  In 2022, 4% of children looked after in Aberdeen City have had 3 or more placements during the past year, a decrease of 2.2 %-points over the previous year."}]
[{"$f":"IF($Q$28=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(Q30=\"N/A\",\"[text statement not available due to data being unavailable]\",IF($Q$28=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(Q30=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  This compares with \"&$P$38&\" of \"&ROUND(SQRT((100*$O$38)^2),1)&\"%-points for comparator authorities, and \"&$P$39&\" of \"&ROUND(SQRT((100*O39)^2),1)&\"%-points for Scotland as a whole.\"))))","v":"*  This compares with a decrease of 0.4%-points for comparator authorities, and a decrease of 0%-points for Scotland as a whole."}]
[{"$f":"IF(Q19=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(Q19=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*   The percentage of children who have had 3 or more placements during the past year (\"&ROUND(100*Q19,0)&\"%) is \"&P34&\" the comparator average of \"&ROUND(100*Q28,0)&\"% and \"&P35&\" the Scotland average of \"&ROUND(100*Q30,0)&\"%\"))","v":"*   The percentage of children who have had 3 or more placements during the past year (4%) is similar to the comparator average of 4% and similar to the Scotland average of 4%"}]
[]
[]
[null,null,{"$f":"'DATA CLA 3P'!C3","v":2019},2019,2019,null,{"$f":"'DATA CLA 3P'!G3","v":2020},2020,2020,null,{"$f":"'DATA CLA 3P'!K3","v":2021},2021,2021,null,{"$f":"'DATA CLA 3P'!O3","v":2022},2022,2022]
[null,null,{"$f":"'DATA CLA 3P'!C4","v":"Number of children looked after "},{"$f":"'DATA CLA 3P'!D4","v":"Number with 3 or more placements"},{"$f":"'DATA CLA 3P'!E4","v":"Percentage with 3 or more placements"},null,{"$f":"'DATA CLA 3P'!G4","v":"Number of children looked after "},{"$f":"'DATA CLA 3P'!H4","v":"Number with 3 or more placements"},{"$f":"'DATA CLA 3P'!I4","v":"Percentage with 3 or more placements"},null,{"$f":"'DATA CLA 3P'!K4","v":"Number of children looked after "},{"$f":"'DATA CLA 3P'!L4","v":"Number with 3 or more placements"},{"$f":"'DATA CLA 3P'!M4","v":"Percentage with 3 or more placements"},null,{"$f":"'DATA CLA 3P'!O4","v":"Number of children looked after "},{"$f":"'DATA CLA 3P'!P4","v":"Number with 3 or more placements"},{"$f":"'DATA CLA 3P'!Q4","v":"Percentage with 3 or more placements"}]
[{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Aberdeen City"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$C5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C5,'Select an authority'!$A$1,0)))","v":542},{"$f":"IF(OFFSET('DATA CLA 3P'!$D5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$D5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D5,'Select an authority'!$A$1,0)))","v":29},{"$f":"IF(OFFSET('DATA CLA 3P'!$E5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$E5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E5,'Select an authority'!$A$1,0)))","v":5.350553505535055E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$G5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G5,'Select an authority'!$A$1,0)))","v":566},{"$f":"IF(OFFSET('DATA CLA 3P'!$H5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$H5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H5,'Select an authority'!$A$1,0)))","v":29},{"$f":"IF(OFFSET('DATA CLA 3P'!$I5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$I5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I5,'Select an authority'!$A$1,0)))","v":5.1236749116607777E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$K5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K5,'Select an authority'!$A$1,0)))","v":516},{"$f":"IF(OFFSET('DATA CLA 3P'!$L5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$L5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L5,'Select an authority'!$A$1,0)))","v":34},{"$f":"IF(OFFSET('DATA CLA 3P'!$M5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$M5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M5,'Select an authority'!$A$1,0)))","v":6.589147286821706E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$O$5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,'Select an authority'!$A$1,0)))","v":480},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$P$5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,'Select an authority'!$A$1,0)))","v":21},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA 3P'!$Q5,'Select an authority'!$A$1,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q5,'Select an authority'!$A$1,0)))","v":4.3749999999999997E-2}]
[]
["Comparator Authorities:"]
[{"$f":"OFFSET('REF EA Name'!$B$2, A3,0)","v":"City of Edinburgh"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$A3,0))))","v":1234},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$A3,0))))","v":91},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$A3,0))))","v":7.3743922204213941E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$A3,0))))","v":1180},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$A3,0))))","v":67},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$A3,0))))","v":5.6779661016949153E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$A3,0))))","v":1045},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$A3,0))))","v":47},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$A3,0))))","v":4.4976076555023926E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$A3,0))))","v":1015},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$A3,0))))","v":56},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$A3,0)=\"\",\"N/A\",IF($A3=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$A3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$A3,0))))","v":5.5172413793103448E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A4,0)","v":"Stirling"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$A4,0))))","v":238},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$A4,0))))","v":11},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$A4,0))))","v":4.6218487394957986E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$A4,0))))","v":246},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$A4,0))))","v":11},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$A4,0))))","v":4.4715447154471545E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$A4,0))))","v":230},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$A4,0))))","v":7},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$A4,0))))","v":3.0434782608695653E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$A4,0))))","v":210},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$A4,0))))","v":8},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$A4,0)=\"\",\"N/A\",IF($A4=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$A4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$A4,0))))","v":3.8095238095238099E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A5,0)","v":"South Ayrshire"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$A5,0))))","v":345},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$A5,0))))","v":16},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$A5,0))))","v":4.6376811594202899E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$A5,0))))","v":300},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$A5,0))))","v":16},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$A5,0))))","v":5.3333333333333337E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$A5,0))))","v":229},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$A5,0))))","v":14},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$A5,0))))","v":6.1135371179039298E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$A5,0))))","v":182},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$A5,0))))","v":4},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$A5,0)=\"\",\"N/A\",IF($A5=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$A5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$A5,0))))","v":2.197802197802198E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A6,0)","v":"Argyll & Bute"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$A6,0))))","v":150},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$A6,0))))","v":9},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$A6,0))))","v":0.06},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$A6,0))))","v":162},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$A6,0))))","v":2},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$A6,0))))","v":1.2345679012345678E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$A6,0))))","v":151},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$A6,0))))","v":8},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$A6,0))))","v":5.2980132450331126E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$A6,0))))","v":144},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$A6,0))))","v":6},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$A6,0)=\"\",\"N/A\",IF($A6=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$A6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$A6,0))))","v":4.1666666666666664E-2}]
[{"$f":"OFFSET('REF EA Name'!$B$2,A7,0)","v":"West Dunbartonshire"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$A7,0))))","v":505},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$A7,0))))","v":27},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$A7,0))))","v":5.3465346534653464E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$A7,0))))","v":506},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$A7,0))))","v":19},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$A7,0))))","v":3.7549407114624504E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$A7,0))))","v":466},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$A7,0))))","v":15},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$A7,0))))","v":3.2188841201716736E-2},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$A7,0))))","v":462},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$A7,0))))","v":4},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$A7,0)=\"\",\"N/A\",IF($A7=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$A7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$A7,0))))","v":8.658008658008658E-3}]
[]
["Comparator authorities",null,{"$f":"SUM(C22:C26)","v":2472},{"$f":"SUM(D22:D26)","v":154},{"$f":"IF(D28=0,0,D28/(SUMIF(D22,\">0\",$C22)+SUMIF(D23,\">0\",$C23)+SUMIF(D24,\">0\",$C24)+SUMIF(D25,\">0\",$C25)+SUMIF(D26,\">0\",$C26)))","v":6.2297734627831718E-2},null,{"$f":"SUM(G22:G26)","v":2394},{"$f":"SUM(H22:H26)","v":115},{"$f":"IF(H28=0,0,H28/(SUMIF(H22,\">0\",$G22)+SUMIF(H23,\">0\",$G23)+SUMIF(H24,\">0\",$G24)+SUMIF(H25,\">0\",$G25)+SUMIF(H26,\">0\",$G26)))","v":4.803675856307435E-2},null,{"$f":"SUM(K22:K26)","v":2121},{"$f":"SUM(L22:L26)","v":91},{"$f":"IF(L28=0,0,L28/(SUMIF(L22,\">0\",$K22)+SUMIF(L23,\">0\",$K23)+SUMIF(L24,\">0\",$K24)+SUMIF(L25,\">0\",$K25)+SUMIF(L26,\">0\",$K26)))","v":4.2904290429042903E-2},null,{"$f":"SUM(O22:O26)","v":2013},{"$f":"SUM(P22:P26)","v":78},{"$f":"IF(P28=0,0,P28/(SUMIF(P22,\">0\",$O22)+SUMIF(P23,\">0\",$O23)+SUMIF(P24,\">0\",$O24)+SUMIF(P25,\">0\",$O25)+SUMIF(P26,\">0\",$O26)))","v":3.8748137108792845E-2}]
[]
["Scotland",null,{"$f":"'DATA CLA 3P'!C$38","v":14262},{"$f":"'DATA CLA 3P'!D$38","v":742},{"$f":"'DATA CLA 3P'!E$38","v":5.2026363763847991E-2},null,{"$f":"'DATA CLA 3P'!G$38","v":14458},{"$f":"'DATA CLA 3P'!H$38","v":572},{"$f":"'DATA CLA 3P'!I$38","v":3.9562871766496061E-2},null,{"$f":"'DATA CLA 3P'!K$38","v":13200},{"$f":"'DATA CLA 3P'!L$38","v":502},{"$f":"'DATA CLA 3P'!M$38","v":3.8030303030303032E-2},null,{"$f":"'DATA CLA 3P'!$O$38","v":12596},{"$f":"'DATA CLA 3P'!$P$38","v":479},{"$f":"'DATA CLA 3P'!$Q$38","v":3.8027945379485548E-2}]
[]
["Notes"]
["[Note 1]",{"$f":"IF('DATA CLA 3P'!A40=\"\",\"\",'DATA CLA 3P'!A40)","v":"The figures refer to the number of placements a child has between the 1st August and 31st July of each year."},null,null,null,null,null,null,null,null,null,{"$f":"I19-E19","v":-2.2687859387427733E-3},{"$f":"IF(L33<0,\"a decrease of \",IF(L33>=0,\"an increase of \"))","v":"a decrease of "}]
["[Note 2]",{"$f":"IF('DATA CLA 3P'!A42=\"\",\"\",'DATA CLA 3P'!A42)","v":"Source: Scottish Government CLAS Returns"},null,null,{"$f":"E19-E28","v":-8.7921995724811672E-3},{"$f":"IF(E34<-0.05,\"less than\",IF(E34>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,{"$f":"I19-I28","v":3.1999905535334272E-3},{"$f":"IF(I34<-0.05,\"less than\",IF(I34>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,{"$f":"I28-E28","v":-1.4260976064757368E-2},{"$f":"IF(L34<0,\"a decrease of \",IF(L34>=0,\"an increase of \"))","v":"a decrease of "},null,{"$f":"Q19-Q28","v":5.0018628912071525E-3},{"$f":"IF(O34<-0.05,\"less than\",IF(O34>0.05,\"greater than\",\"similar to\"))","v":"similar to"}]
[null,null,null,null,{"$f":"E19-E30","v":1.4791712915025595E-3},{"$f":"IF(E35<-0.05,\"less than\",IF(E35>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,{"$f":"I19-I30","v":1.1673877350111717E-2},{"$f":"IF(I35<-0.05,\"less than\",IF(I35>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,null,null,{"$f":"Q19-Q30","v":5.7220546205144496E-3},{"$f":"IF(O35<-0.05,\"less than\",IF(O35>0.05,\"greater than\",\"similar to\"))","v":"similar to"}]
[null,null,null,null,null,null,null,null,{"$f":"M19-M28","v":2.2987182439174157E-2},{"$f":"IF(I36<-0.05,\"less than\",IF(I36>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,{"$f":"I30-E30","v":-1.246349199735193E-2},{"$f":"IF(L36<0,\"a decrease of \",IF(L36>=0,\"an increase of \"))","v":"a decrease of "}]
[null,null,null,null,null,null,null,null,{"$f":"M19-M30","v":2.7861169837914028E-2},{"$f":"IF(I37<-0.05,\"less than\",IF(I37>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,null,null,{"$f":"Q19-M19","v":-2.2141472868217063E-2},{"$f":"IF(O37<0,\"a decrease of \",IF(O37>=0,\"an increase of \"))","v":"a decrease of "}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M19-I19","v":1.4654723751609283E-2},{"$f":"IF(L38<0,\"a decrease of \",IF(L38>=0,\"an increase of \"))","v":"an increase of "},null,{"$f":"Q28-M28","v":-4.1561533202500583E-3},{"$f":"IF(O38<0,\"a decrease\",IF(O38>=0,\"an increase\"))","v":"a decrease"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M28-I28","v":-5.1324681340314468E-3},{"$f":"IF(L39<0,\"a decrease of \",IF(L39>=0,\"an increase of \"))","v":"a decrease of "},null,{"$f":"Q30-M30","v":-2.35765081748468E-6},{"$f":"IF(O39<0,\"a decrease\",IF(O39>=0,\"an increase\"))","v":"a decrease"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M30-I30","v":-1.5325687361930282E-3},{"$f":"IF(L40<0,\"a decrease of \",IF(L40>=0,\"an increase of \"))","v":"a decrease of "}]

{"sheet":"DATA CLA","index":5,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":true,"merged":[[2,9,2,13]]}
["Looked after children on 31 July, 2016 to 2022"]
[]
["Total number of looked after children on 31 July 2016-2022",null,null,null,null,null,null,null,null,"Population Aged 0-17",null,null,null,null,null,null,null,"Total number of children looked after at 31 July 2016-2022- rate per 1000, 0-17 population"]
[]
["Council",2016,2017,2018,2019,2020,2021,2022,null,2016,2017,2018,2019,2020,2021,2022,null,"Council",2016,2017,2018,2019,2020,2021,2022]
["Aberdeen City",553,590,549,542,566,516,480,null,38001,38221,38418,38966,39401,39663,39663,null,"Aberdeen City",{"$f":"IFERROR(B6*1000/J6,\"*\")","v":14.552248625036183},{"$f":"IFERROR(C6*1000/K6,\"*\")","v":15.436540121922503},{"$f":"IFERROR(D6*1000/L6,\"*\")","v":14.290176479775106},{"$f":"IFERROR(E6*1000/M6,\"*\")","v":13.909562182415439},{"$f":"IFERROR(F6*1000/N6,\"*\")","v":14.365117636608208},{"$f":"IFERROR(G6*1000/O6,\"*\")","v":13.009605929959912},{"$f":"IFERROR(H6*1000/P6,\"*\")","v":12.101959004613873}]
["Aberdeenshire",411,395,409,403,404,386,378,null,54908,54677,54594,54634,54387,54422,54422,null,"Aberdeenshire",7.4852480512857875,7.2242441977431096,7.4916657508151081,7.3763590438188675,7.428245720484675,7.0927198559406124,6.9457204806879567]
["Angus",238,255,251,244,265,252,211,null,22034,21907,21759,21588,21420,21172,21172,null,"Angus",10.801488608514115,11.640115031725019,11.535456592674295,11.302575504910136,12.371615312791784,11.902512752692235,9.9659928207065942]
["Argyll & Bute",163,175,149,150,162,151,144,null,15141,14906,14742,14566,14304,14202,14202,null,"Argyll & Bute",10.765471237038504,11.740238830001342,10.10717677384344,10.297954139777564,11.325503355704697,10.632305309111393,10.139416983523448]
["City of Edinburgh",1368,1349,1309,1234,1180,1045,1015,null,86107,86478,86866,87481,87556,87551,87551,null,"City of Edinburgh",15.887210099062793,15.599343185550081,15.069187023691663,14.105920142659549,13.477088948787062,11.93590021815856,11.593242795627692]
["Clackmannanshire",233,213,211,185,248,261,263,null,10258,10222,10126,10027,10010,10010,10010,null,"Clackmannanshire",22.713979333203355,20.837409508902368,20.837448153268813,18.450184501845019,24.775224775224775,26.073926073926074,26.273726273726275]
["Dumfries and Galloway",393,382,439,395,365,311,303,null,26707,26480,26328,26168,26038,25967,25967,null,"Dumfries and Galloway",14.715243194668064,14.425981873111782,16.674263141902156,15.094772240904922,14.017973730701282,11.976739708091038,11.668656371548504]
["Dundee City",592,555,519,463,493,437,435,null,26729,26803,26743,26763,26678,26530,26530,null,"Dundee City",22.148228515844213,20.706637316718279,19.406947612459334,17.300003736501885,18.479646150386085,16.471918582736524,16.396532227666793]
["East Ayrshire",463,386,401,375,382,402,387,null,23930,23767,23671,23559,23423,23427,23427,null,"East Ayrshire",19.348098620977851,16.241006437497369,16.940560179122134,15.91748376416656,16.308756350595569,17.159687540017927,16.519400691509798]
["East Dunbartonshire",164,162,140,149,155,165,157,null,21353,21543,21627,21718,21895,22022,22022,null,"East Dunbartonshire",7.6804196131691098,7.519844032864504,6.4733897443011053,6.8606685698498939,7.0792418360356244,7.4925074925074924,7.1292344019616749]
["East Lothian",229,242,245,246,260,223,207,null,21329,21365,21590,21828,21935,22189,22189,null,"East Lothian",10.736555862909654,11.326936578516264,11.347846225104215,11.269928532160527,11.853202644175974,10.05002478705665,9.3289467754292659]
["East Renfrewshire",130,117,110,102,117,90,96,null,21099,21422,21655,21828,22055,22263,22263,null,"East Renfrewshire",6.1614294516327792,5.4616749136401834,5.0796582775340564,4.6728971962616823,5.3049195193833594,4.0425818622827112,4.3120873197682252]
["Falkirk",373,381,368,344,369,378,390,null,31846,31745,31519,31432,31291,31062,31062,null,"Falkirk",11.712616969164102,12.001890061426996,11.675497319077381,10.944260626113515,11.792528202997667,12.16920996716245,12.555534093104114]
["Fife",981,942,941,935,919,810,748,null,72326,72081,72088,72048,71956,71746,71746,null,"Fife",13.56358709177889,13.068631123319598,13.053490178670513,12.977459471463469,12.771693812885653,11.289828004348674,10.42566832994174]
["Glasgow City",3294,2827,2645,2523,2544,2328,2146,null,110239,110863,111161,111598,111512,111037,111037,null,"Glasgow City",29.880532298007058,25.499941369077149,23.794316351957971,22.607932041792864,22.813688212927758,20.965984311535795,19.326891036321225]
["Highland",440,487,521,483,495,467,402,null,45284,44684,44427,44039,43515,43268,43268,null,"Highland",9.716456143450225,10.898755706740667,11.727102887883495,10.967551488453417,11.375387797311271,10.793195895349912,9.2909309420356845]
["Inverclyde",207,218,199,205,223,206,193,null,14638,14389,14192,14126,14051,13889,13889,null,"Inverclyde",14.141276130618937,15.150462158593371,14.021984216459977,14.512246920571995,15.870756529784357,14.83188134494924,13.895888832889337]
["Midlothian",250,259,233,218,214,172,172,null,18958,19254,19500,19834,20036,20305,20305,null,"Midlothian",13.18704504694588,13.45175028565493,11.948717948717949,10.991227185640819,10.680774605709722,8.4708199950751055,8.4708199950751055]
["Moray",213,215,222,210,188,174,165,null,18840,18568,18312,18293,18204,18093,18093,null,"Moray",11.305732484076433,11.579060749676863,12.123197903014416,11.479801016782377,10.327400571303011,9.6169789421323166,9.1195489968496108]
["Na h-Eileanan Siar",37,47,41,39,50,39,44,null,4878,4892,4842,4792,4719,4625,4625,null,"Na h-Eileanan Siar",7.5850758507585079,9.6075224856909234,8.4675753820735231,8.1385642737896493,10.595465140919686,8.4324324324324316,9.513513513513514]
["North Ayrshire",603,585,563,550,575,489,447,null,26157,25894,25682,25314,25178,24804,24804,null,"North Ayrshire",23.053102420002293,22.592106279446977,21.921968694026944,21.727107529430356,22.837397728175389,19.714562167392355,18.021286889211417]
["North Lanarkshire",765,773,754,850,832,734,692,null,71393,70766,70636,70519,70219,69751,69751,null,"North Lanarkshire",10.715336237446248,10.923324760478195,10.674443626479416,12.05348913058892,11.848644953645024,10.523146621553813,9.9210047167782545]
["Orkney Islands",28,38,31,37,31,38,34,null,3984,3972,3988,4024,4002,4004,4004,null,"Orkney Islands",7.0281124497991971,9.5669687814702922,7.7733199598796388,9.1948310139165006,7.7461269365317342,9.4905094905094902,8.4915084915084922]
["Perth and Kinross",286,281,280,282,285,288,284,null,28082,27954,27747,27656,27533,27561,27561,null,"Perth and Kinross",10.184459796310804,10.052228661372254,10.091181028579665,10.196702343072028,10.351214905749464,10.44954827473604,10.30441565980915]
["Renfrewshire",681,659,656,629,642,587,592,null,33865,33893,33904,33889,33858,33624,33624,null,"Renfrewshire",20.109257345341799,19.443542914466114,19.348749410099103,18.560594883295465,18.96154527733475,17.45776826076612,17.60647156792767]
["Scottish Borders",218,228,205,195,187,174,183,null,21507,21479,21434,21349,21192,21207,21207,null,"Scottish Borders",10.136234714279071,10.615019321197449,9.5642437249230188,9.1339172794978687,8.8240845602114,8.204838025180365,8.6292261988965908]
["Shetland Islands",29,32,29,34,28,26,27,null,4801,4771,4689,4691,4674,4624,4624,null,"Shetland Islands",6.0404082482816079,6.7071892684971708,6.1846875666453398,7.2479215519079085,5.9905862216516903,5.6228373702422143,5.8391003460207616]
["South Ayrshire",384,370,355,345,300,229,182,null,20196,20082,19881,19796,19656,19575,19575,null,"South Ayrshire",19.013666072489602,18.424459715167814,17.856244655701424,17.427763184481712,15.262515262515263,11.698595146871009,9.2975734355044697]
["South Lanarkshire",563,549,655,725,786,747,774,null,62097,62114,61941,62118,62112,62492,62492,null,"South Lanarkshire",9.0664605375460976,8.838587114016164,10.574579034888039,11.671335200746965,12.654559505409583,11.953530051846636,12.38558535492543]
["Stirling",216,245,236,238,246,230,210,null,17784,17593,17551,17450,17292,17130,17130,null,"Stirling",12.145748987854251,13.925993292786904,13.446527263403794,13.638968481375358,14.226231783483692,13.426736719206071,12.259194395796847]
["West Dunbartonshire",363,429,445,505,506,466,462,null,17716,17656,17500,17457,17331,17169,17169,null,"West Dunbartonshire",20.489952585233688,24.297689170820117,25.428571428571427,28.928223635217964,29.196237955109343,27.141941871978567,26.908963830159006]
["West Lothian",449,511,443,427,441,379,373,null,39574,39614,39685,39611,39489,39597,39597,null,"West Lothian",11.345833122757366,12.899479981824607,11.162907899710218,10.779833884527026,11.167666945225253,9.5714321792054946,9.4199055484001306]
["SCOTLAND",15317,14897,14554,14262,14458,13200,12596,null,1031761,1030055,1028798,1029162,1026922,1024981,1024981,null,"SCOTLAND",14.84549231847298,14.462334535534509,14.146606039280792,13.857876602517388,14.078966075320229,12.878287499963413,12.289008284055997]
["Notes:"]
["Population figures source: NRS mid-year population estimates for 2016-2022"]
["Source: Scottish Government CLAS Returns"]

{"sheet":"DATA CLA Acc","index":6,"n_rows":48,"n_cols":36,"rows_kept":48,"cut":false,"hidden":true,"merged":[[3,33,3,34],[3,24,3,25]]}
["Looked after children by accommodation type on 31 July, 2019 to 2022"]
[]
[null,2019,null,null,null,null,null,null,null,null,2020,null,null,null,null,null,null,null,null,2021,null,null,null,null,null,null,null,null,2022]
[null,"In the community",null,null,null,null,"In residential accommodation",null,null,null,"In the community",null,null,null,null,"In residential accommodation",null,null,null,"In the community",null,null,null,null,"In residential accommodation",null,null,null,"In the community",null,null,null,null,"In residential accommodation"]
[null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community(1)","In local authority home/ Voluntary Home ","In other residential care(2)","Total",null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community(1)","In local authority home/ Voluntary Home ","In other residential care(2)","Total",null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community(1)","In local authority home/ Voluntary Home ","In other residential care(2)","Total",null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community(1)","In local authority home/ Voluntary Home ","In other residential care(2)","Total"]
["Council"]
["Aberdeen City",97,98,81,193,22,16,35,542,null,120,105,77,185,18,17,44,566,null,95,106,78,164,16,18,39,516,null,86,99,73,146,21,17,38,480]
["Aberdeenshire",68,75,139,36,14,31,40,403,null,71,81,140,34,7,35,36,404,null,61,79,124,42,12,35,33,386,null,68,65,114,43,15,43,30,378]
["Angus",61,65,80,7,6,8,17,244,null,78,57,84,11,8,6,21,265,null,58,66,84,17,4,4,19,252,null,33,49,66,23,3,9,28,211]
["Argyll & Bute",46,42,32,3,2,15,10,150,null,48,51,33,5,1,14,10,162,null,38,55,29,3,0,15,11,151,null,41,47,27,2,1,16,10,144]
["City of Edinburgh",337,225,349,174,43,59,47,1234,null,288,211,358,161,44,68,50,1180,null,225,198,314,144,62,57,45,1045,null,205,238,281,144,38,81,28,1015]
["Clackmannanshire",43,59,24,41,5,3,10,185,null,46,97,29,56,3,4,13,248,null,50,116,23,55,0,5,12,261,null,49,113,22,62,4,4,9,263]
["Dumfries and Galloway",139,120,105,5,3,4,19,395,null,125,108,100,4,4,6,18,365,null,93,80,96,12,6,5,19,311,null,101,70,93,12,5,5,17,303]
["Dundee City",87,97,139,73,13,32,22,463,null,83,136,140,67,14,25,28,493,null,64,113,138,67,5,30,20,437,null,53,104,108,97,16,32,25,435]
["East Ayrshire",114,90,104,25,10,17,15,375,null,87,110,107,30,11,18,19,382,null,102,67,161,31,2,19,20,402,null,103,108,107,29,1,20,19,387]
["East Dunbartonshire",39,44,21,23,0,17,5,149,null,48,44,16,24,1,17,5,155,null,49,50,17,23,1,18,7,165,null,38,45,17,26,4,16,11,157]
["East Lothian",62,50,77,11,3,12,31,246,null,70,52,79,19,0,10,30,260,null,58,57,58,15,0,10,25,223,null,56,42,56,12,3,11,27,207]
["East Renfrewshire",50,24,17,6,3,0,2,102,null,62,26,14,8,1,0,6,117,null,35,21,19,6,1,0,8,90,null,45,20,14,8,2,0,7,96]
["Falkirk",113,49,76,38,7,9,52,344,null,114,62,83,39,4,8,59,369,null,104,81,79,44,5,10,55,378,null,122,83,68,55,9,5,48,390]
["Fife",165,182,207,247,0,64,70,935,null,166,227,216,216,2,75,17,919,null,138,222,228,169,2,44,7,810,null,163,193,214,141,0,32,5,748]
["Glasgow City",399,1163,550,214,2,136,59,2523,null,471,1154,506,190,4,127,92,2544,null,381,1154,474,152,9,119,39,2328,null,322,1089,428,146,11,124,26,2146]
["Highland",126,96,117,43,20,32,49,483,null,141,98,105,47,20,29,55,495,null,111,109,108,49,22,28,40,467,null,82,73,105,51,26,29,36,402]
["Inverclyde",98,45,25,5,4,19,9,205,null,103,51,32,6,1,20,10,223,null,79,53,33,8,0,10,23,206,null,71,51,28,8,9,2,24,193]
["Midlothian",62,67,48,15,5,12,9,218,null,56,70,52,11,6,11,8,214,null,35,59,48,11,6,9,4,172,null,27,61,50,12,9,7,6,172]
["Moray",44,47,54,13,8,21,23,210,null,40,48,48,12,5,17,18,188,null,33,56,42,10,2,17,14,174,null,36,42,44,8,3,16,16,165]
["Na h-Eileanan Siar",18,5,7,0,2,4,3,39,null,24,14,5,0,1,3,3,50,null,17,11,3,0,1,3,4,39,null,27,10,3,0,0,2,2,44]
["North Ayrshire",178,135,152,12,8,30,35,550,null,181,136,182,12,8,31,25,575,null,144,115,159,10,11,30,20,489,null,141,91,142,11,10,22,30,447]
["North Lanarkshire",325,304,128,49,5,30,9,850,null,286,326,124,59,2,24,11,832,null,214,321,118,55,0,18,8,734,null,177,315,106,55,0,31,8,692]
["Orkney Islands",12,7,12,0,1,3,2,37,null,8,6,10,0,0,3,4,31,null,8,10,10,1,0,4,5,38,null,5,8,10,1,0,4,6,34]
["Perth and Kinross",69,76,79,24,23,4,7,282,null,60,90,85,27,11,0,12,285,null,62,91,90,22,11,4,8,288,null,50,102,77,21,16,9,9,284]
["Renfrewshire",190,190,127,61,13,36,12,629,null,197,212,125,60,12,23,13,642,null,158,220,110,48,7,16,28,587,null,146,230,111,45,9,17,34,592]
["Scottish Borders",55,50,57,7,4,2,20,195,null,47,53,53,3,2,3,26,187,null,35,60,49,2,2,3,23,174,null,38,46,54,6,6,6,27,183]
["Shetland Islands",4,4,19,0,0,4,3,34,null,5,2,13,0,4,4,0,28,null,4,4,10,0,2,6,0,26,null,5,4,12,0,0,5,1,27]
["South Ayrshire",71,90,112,27,10,12,23,345,null,60,74,101,24,12,13,16,300,null,42,48,85,19,10,10,15,229,null,33,39,74,13,2,11,10,182]
["South Lanarkshire",179,259,164,35,15,38,35,725,null,193,294,159,43,22,41,34,786,null,136,329,163,39,10,33,37,747,null,126,366,162,34,12,31,43,774]
["Stirling",97,69,55,1,2,1,13,238,null,76,99,48,1,4,2,16,246,null,64,113,33,1,2,4,13,230,null,46,108,31,1,11,5,8,210]
["West Dunbartonshire",111,219,62,55,10,21,27,505,null,113,212,56,58,22,23,22,506,null,83,215,46,58,9,21,34,466,null,82,210,47,56,19,19,29,462]
["West Lothian",110,129,116,20,9,16,27,427,null,96,150,135,17,5,9,29,441,null,77,131,122,18,4,5,22,379,null,60,128,127,16,6,11,25,373]
["Scotland",3569,4175,3335,1463,272,708,740,14262,null,3563,4456,3315,1429,259,686,750,14458,null,2853,4410,3151,1295,224,610,657,13200,null,2637,4249,2871,1284,271,642,642,12596]
["Notes:"]
["Source: Scottish Government CLAS Returns"]
[]
[]
[]
[]
[]
[]
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]

{"sheet":"DATA CLA DIS","index":7,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Looked after children by disability status on 31 July, 2019 to 2022"]
[]
[null,2019,null,null,2020,null,null,2021,null,null,2022]
["Council","Number of children looked after ","Number of children looked after with a disability","Percentage of children looked after with a disability","Number of children looked after ","Number of children looked after with a disability","Percentage of children looked after with a disability","Number of children looked after ","Number of children looked after with a disability","Percentage of children looked after with a disability","Number of children looked after ","Number of children looked after with a disability","Percentage of children looked after with a disability"]
["Aberdeen City",542,142,0.26199261992619927,549,130,0.22968197879858657,516,129,{"$f":"I5/H5","v":0.25},480,122,{"$f":"L5/K5","v":0.25416666666666665}]
["Aberdeenshire",403,80,0.19851116625310175,409,77,0.1905940594059406,386,71,{"$f":"I6/H6","v":0.18393782383419688},378,65,{"$f":"L6/K6","v":0.17195767195767195}]
["Angus",244,46,0.18852459016393441,251,20,7.5471698113207544E-2,252,31,0.12301587301587301,211,18,8.5308056872037921E-2]
["Argyll & Bute",150,34,0.22666666666666666,149,39,0.24074074074074073,151,45,0.29801324503311261,144,37,0.25694444444444442]
["City of Edinburgh",1234,57,4.6191247974068074E-2,1309,55,4.6610169491525424E-2,1045,52,4.9760765550239235E-2,1015,49,4.8275862068965517E-2]
["Clackmannanshire",185,13,7.0270270270270274E-2,211,14,5.6451612903225805E-2,261,14,5.3639846743295021E-2,263,12,4.5627376425855515E-2]
["Dumfries & Galloway",395,11,2.7848101265822784E-2,439,58,0.15890410958904111,311,14,4.5016077170418008E-2,303,21,6.9306930693069313E-2]
["Dundee City",463,79,0.17062634989200864,519,86,0.17444219066937119,437,77,0.17620137299771166,435,68,0.15632183908045977]
["East Ayrshire",375,9,2.4E-2,401,18,4.712041884816754E-2,402,17,4.228855721393035E-2,387,16,4.1343669250645997E-2]
["East Dunbartonshire",149,22,0.1476510067114094,140,28,0.18064516129032257,165,29,0.17575757575757575,157,27,0.17197452229299362]
["East Lothian",246,22,8.943089430894309E-2,245,17,6.5384615384615388E-2,223,13,5.829596412556054E-2,207,29,0.14009661835748793]
["East Renfrewshire",102,5,4.9019607843137254E-2,110,19,0.1623931623931624,90,26,0.28888888888888886,96,28,0.29166666666666669]
["Falkirk",344,7,2.0348837209302327E-2,368,8,2.1680216802168022E-2,378,7,1.8518518518518517E-2,390,"*","*"]
["Fife",935,0,0,941,0,0,810,0,0,748,0,0]
["Glasgow City",2523,326,0.12921125644074513,2645,293,0.11517295597484277,2328,236,0.1013745704467354,2146,197,9.179869524697111E-2]
["Highland",483,37,7.6604554865424432E-2,521,47,9.494949494949495E-2,467,71,0.15203426124197003,402,74,0.18407960199004975]
["Inverclyde",205,31,0.15121951219512195,199,9,4.0358744394618833E-2,206,12,5.8252427184466021E-2,193,10,5.181347150259067E-2]
["Midlothian",218,150,0.68807339449541283,233,20,9.3457943925233641E-2,172,11,6.3953488372093026E-2,172,10,5.8139534883720929E-2]
["Moray",210,29,0.1380952380952381,222,33,0.17553191489361702,174,28,0.16091954022988506,165,29,0.17575757575757575]
["Na h-Eileanan Siar",39,"*","*",41,"*","*",39,"*","*",44,7,0.15909090909090909]
["North Ayrshire",550,55,0.1,563,55,9.5652173913043481E-2,489,75,0.15337423312883436,447,72,0.16107382550335569]
["North Lanarkshire",850,39,4.5882352941176471E-2,754,35,4.2067307692307696E-2,734,30,4.0871934604904632E-2,692,31,4.4797687861271675E-2]
["Orkney Islands",37,"*","*",31,"*","*",38,"*","*",34,0,0]
["Perth & Kinross",282,19,6.7375886524822695E-2,280,19,6.6666666666666666E-2,288,16,5.5555555555555552E-2,284,15,5.2816901408450703E-2]
["Renfrewshire",629,31,4.9284578696343402E-2,656,27,4.2056074766355138E-2,587,35,5.9625212947189095E-2,592,45,7.6013513513513514E-2]
["Scottish Borders",195,15,7.6923076923076927E-2,205,13,6.9518716577540107E-2,174,12,6.8965517241379309E-2,183,8,4.3715846994535519E-2]
["Shetland Islands",34,"*","*",29,"*","*",26,"*","*",27,"*","*"]
["South Ayrshire",345,58,0.1681159420289855,355,51,0.17,229,36,0.15720524017467249,182,28,0.15384615384615385]
["South Lanarkshire",725,84,0.11586206896551725,655,99,0.12595419847328243,747,91,0.12182061579651941,774,102,0.13178294573643412]
["Stirling",238,25,0.10504201680672269,236,23,9.3495934959349589E-2,230,21,9.1304347826086957E-2,210,21,0.1]
["West Dunbartonshire",505,56,0.11089108910891089,445,51,0.1007905138339921,466,53,0.11373390557939914,462,47,0.10173160173160173]
["West Lothian",427,46,0.10772833723653395,443,31,7.045454545454545E-2,379,21,5.5408970976253295E-2,373,17,4.5576407506702415E-2]
["SCOTLAND",14262,1535,0.10762866358154537,14554,1381,9.5524659334578405E-2,13200,1280,9.696969696969697E-2,12596,1216,9.6538583677357889E-2]
["Notes:"]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Source: Scottish Government CLAS Returns"]

{"sheet":"DATA CLA 3P","index":8,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Looked after children with 3 or more placements during the year for those looked on 31 July, 2019 to 2022"]
[]
[null,null,2019,null,null,null,2020,null,null,null,2021,null,null,null,2022]
[null,null,"Number of children looked after ","Number with 3 or more placements","Percentage with 3 or more placements",null,"Number of children looked after ","Number with 3 or more placements","Percentage with 3 or more placements",null,"Number of children looked after ","Number with 3 or more placements","Percentage with 3 or more placements",null,"Number of children looked after ","Number with 3 or more placements","Percentage with 3 or more placements"]
["Council"]
["Aberdeen City",null,542,29,5.350553505535055E-2,null,566,29,5.1236749116607777E-2,null,516,34,6.589147286821706E-2,null,480,21,4.3749999999999997E-2]
["Aberdeenshire",null,403,29,7.1960297766749379E-2,null,404,15,3.7128712871287127E-2,null,386,19,4.9222797927461141E-2,null,378,13,3.439153439153439E-2]
["Angus",null,244,18,7.3770491803278687E-2,null,265,31,0.1169811320754717,null,252,35,0.1388888888888889,null,211,22,0.10426540284360189]
["Argyll & Bute",null,150,9,0.06,null,162,2,1.2345679012345678E-2,null,151,8,5.2980132450331126E-2,null,144,6,4.1666666666666664E-2]
["City of Edinburgh",null,1234,91,7.3743922204213941E-2,null,1180,67,5.6779661016949153E-2,null,1045,47,4.4976076555023926E-2,null,1015,56,5.5172413793103448E-2]
["Clackmannanshire",null,185,11,5.9459459459459463E-2,null,248,16,6.4516129032258063E-2,null,261,13,4.9808429118773943E-2,null,263,11,4.1825095057034217E-2]
["Dumfries and Galloway",null,395,19,4.810126582278481E-2,null,365,18,4.9315068493150684E-2,null,311,17,5.4662379421221867E-2,null,303,19,6.2706270627062702E-2]
["Dundee City",null,463,39,8.4233261339092869E-2,null,493,23,4.665314401622718E-2,null,437,17,3.8901601830663615E-2,null,435,28,6.4367816091954022E-2]
["East Ayrshire",null,375,15,0.04,null,382,3,7.8534031413612562E-3,null,402,9,2.2388059701492536E-2,null,387,3,7.7519379844961239E-3]
["East Dunbartonshire",null,149,4,2.6845637583892617E-2,null,155,6,3.870967741935484E-2,null,165,2,1.2121212121212121E-2,null,157,7,4.4585987261146494E-2]
["East Lothian",null,246,15,6.097560975609756E-2,null,260,7,2.6923076923076925E-2,null,223,3,1.3452914798206279E-2,null,207,2,9.6618357487922701E-3]
["East Renfrewshire",null,102,7,6.8627450980392163E-2,null,117,3,2.564102564102564E-2,null,90,4,4.4444444444444446E-2,null,96,4,4.1666666666666664E-2]
["Falkirk",null,344,34,9.8837209302325577E-2,null,369,30,8.1300813008130079E-2,null,378,16,4.2328042328042326E-2,null,390,12,3.0769230769230771E-2]
["Fife",null,935,50,5.3475935828877004E-2,null,919,51,5.5495103373231776E-2,null,810,40,4.9382716049382713E-2,null,748,35,4.6791443850267379E-2]
["Glasgow City",null,2523,59,2.3384859294490686E-2,null,2544,60,2.358490566037736E-2,null,2328,57,2.4484536082474227E-2,null,2146,39,1.8173345759552657E-2]
["Highland",null,483,46,9.5238095238095233E-2,null,495,31,6.2626262626262627E-2,null,467,17,3.6402569593147749E-2,null,402,41,0.10199004975124377]
["Inverclyde",null,205,6,2.9268292682926831E-2,null,223,5,2.2421524663677129E-2,null,206,5,2.4271844660194174E-2,null,193,1,5.1813471502590676E-3]
["Midlothian",null,218,8,3.669724770642202E-2,null,214,11,5.1401869158878503E-2,null,172,9,5.232558139534884E-2,null,172,11,6.3953488372093026E-2]
["Moray",null,210,22,0.10476190476190476,null,188,12,6.3829787234042548E-2,null,174,6,3.4482758620689655E-2,null,165,7,4.2424242424242427E-2]
["Na h-Eileanan Siar",null,39,11,0.28205128205128205,null,50,1,0.02,null,39,2,5.128205128205128E-2,null,44,3,6.8181818181818177E-2]
["North Ayrshire",null,550,37,6.7272727272727276E-2,null,575,28,4.8695652173913043E-2,null,489,26,5.3169734151329244E-2,null,447,32,7.1588366890380312E-2]
["North Lanarkshire",null,850,12,1.411764705882353E-2,null,832,3,3.605769230769231E-3,null,734,5,6.8119891008174387E-3,null,692,5,7.2254335260115606E-3]
["Orkney Islands",null,37,6,0.16216216216216217,null,31,5,0.16129032258064516,null,38,1,2.6315789473684209E-2,null,34,5,0.14705882352941177]
["Perth and Kinross",null,282,31,0.1099290780141844,null,285,12,4.2105263157894736E-2,null,288,24,8.3333333333333329E-2,null,284,15,5.2816901408450703E-2]
["Renfrewshire",null,629,35,5.5643879173290937E-2,null,642,14,2.1806853582554516E-2,null,587,25,4.2589437819420782E-2,null,592,18,3.0405405405405407E-2]
["Scottish Borders",null,195,5,2.564102564102564E-2,null,187,4,2.1390374331550801E-2,null,174,3,1.7241379310344827E-2,null,183,8,4.3715846994535519E-2]
["Shetland Islands",null,34,2,5.8823529411764705E-2,null,28,1,3.5714285714285712E-2,null,26,0,0,null,27,1,3.7037037037037035E-2]
["South Ayrshire",null,345,16,4.6376811594202899E-2,null,300,16,5.3333333333333337E-2,null,229,14,6.1135371179039298E-2,null,182,4,2.197802197802198E-2]
["South Lanarkshire",null,725,16,2.2068965517241378E-2,null,786,18,2.2900763358778626E-2,null,747,13,1.7402945113788489E-2,null,774,19,2.454780361757106E-2]
["Stirling",null,238,11,4.6218487394957986E-2,null,246,11,4.4715447154471545E-2,null,230,7,3.0434782608695653E-2,null,210,8,3.8095238095238099E-2]
["West Dunbartonshire",null,505,27,5.3465346534653464E-2,null,506,19,3.7549407114624504E-2,null,466,15,3.2188841201716736E-2,null,462,4,8.658008658008658E-3]
["West Lothian",null,427,22,5.1522248243559721E-2,null,441,20,4.5351473922902494E-2,null,379,9,2.3746701846965697E-2,null,373,19,5.0938337801608578E-2]
["SCOTLAND",null,14262,742,5.2026363763847991E-2,null,14458,572,3.9562871766496061E-2,null,13200,502,3.8030303030303032E-2,null,12596,479,3.8027945379485548E-2]
["Notes:"]
["The figures refer to the number of placements a child has between the 1st August and 31st July of each year."]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Source: Scottish Government CLAS 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 and 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 and 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},8,28,4,25,null,null,"Aberdeen City","Aberdeen City",1]
[2,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,{"$f":"INDEX($J$1:$K$32,MATCH(C49,$J$1:$J$32,0),2)","v":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,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,{"$f":"INDEX($J$1:$K$32,MATCH(C59,$J$1:$J$32,0),2)","v":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,{"$f":"INDEX($J$1:$K$32,MATCH(C69,$J$1:$J$32,0),2)","v":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"]