{"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":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[27,3,30,8],[10,0,11,8],[12,0,17,8]]}
[4]
["Selecting an Authority and its Standard Comparator Authorities"]
["PLEASE REMEMBER TO 'ENABLE MACROS' - ",null,null,null,"Please select a Local Authority:"]
["THEY MAY HAVE BEEN DISABLED."]
["Last updated: 24/09/2020"]
[]
["Instructions on how to use this workbook available at:-"]
["LA Level Statistics - Children Looked After - User Instructions"]
["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",null,"Note: Caution should be exercised when making comparisons with comparator authority averages if there are a number of authorities that are not extremely or very close."]
[{"$f":"OFFSET('REF CAS2'!$C$1,'Select an authority'!$A$1,0)","v":"South Ayrshire"},{"$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":"Dumfries and Galloway"},{"$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":"Scottish Borders"},{"$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":"Highland"},{"$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":"Angus"},{"$f":"OFFSET('REF CAS2'!$L$1,'Select an authority'!$A$1,0)","v":"****"}]

{"sheet":"CLA total number","index":1,"n_rows":47,"n_cols":26,"rows_kept":47,"cut":false,"hidden":false,"merged":[[15,1,17,6],[11,1,12,6],[13,1,14,6]]}
[{"$f":"'DATA CLA'!A1","v":"Children Looked After: Number Looked After at 31 July 2013 to 2019"}]
[null,null,"select comparators:"]
[null,{"$f":"J3","v":28},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":28}]
[null,{"$f":"J4","v":7},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":7}]
[null,{"$f":"J5","v":26},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":26}]
[null,{"$f":"J6","v":16},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":16}]
[null,{"$f":"J7","v":3},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":3}]
[]
[]
[]
[]
[null,{"$f":"IF(W22=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(V22=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(W22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(V22=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The number of children looked after in \"&B22&\" in \"&W20&\" was \"&ROUND(W22,0)&\" (\"&V44&ROUND((SQRT((V22*100)^2)),1)&\"% from \"&ROUND(S22,0)&\" in \"&S20&\")\"))))","v":"*  The number of children looked after in Argyll & Bute in 2019 was 150 (an increase of 0.7% from 149 in 2018)"}]
[]
[null,{"$f":"IF(V31=\"\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  The comparator authorities show \"&V46&ROUND(SQRT((V31*100)^2),1)&\"%, while the Scotland figures show \"&V47&ROUND(SQRT((100*V33)^2),1)&\"%\")","v":"*  The comparator authorities show a decrease of 6.2%, while the Scotland figures show a decrease of 2%"}]
[]
[null,{"$f":"IF(W22=\"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(W22=\"\",\"[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 rate (per 1,000 pop 0-17) is \"&ROUND(Y22,1)&\".  This is \"&Z40&\" the comparator average rate of \"&ROUND(Y31,1)&\", and \"&Z41&\" the Scotland average rate of \"&ROUND(Y33,1)))))","v":"*  The rate (per 1,000 pop 0-17) is 10.3.  This is less than the comparator average rate of 12.5, and less than the Scotland average rate of 13.9"}]
[]
[]
[]
[null,null,{"$f":"'DATA CLA'!C5","v":2014},null,null,null,{"$f":"'DATA CLA'!D5","v":2015},null,null,null,{"$f":"'DATA CLA'!E5","v":2016},null,null,null,{"$f":"'DATA CLA'!F5","v":2017},null,null,null,{"$f":"'DATA CLA'!G5","v":2018},null,null,null,{"$f":"'DATA CLA'!H5","v":2019}]
[null,null,"number","population 0-17","rate","% change","number","population 0-17","rate","% change","number","population 0-17","rate","% change","number","population 0-17","rate","% change","number","population 0-17","rate","% change","number","population 0-17","rate"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Argyll & Bute"},{"$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":175},{"$f":"VLOOKUP($B$22,'DATA CLA'!$A$6:$P$37,11,FALSE)","v":15932},{"$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":10.984182776801406},{"$f":"IF(C22=\"N/A\",\"N/A\",IF(G22=\"N/A\",\"N/A\",IF(C22=0,\"\",G22/C22-1)))","v":-4.5714285714285707E-2},{"$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":167},{"$f":"VLOOKUP($B$22,'DATA CLA'!$A$6:$P$37,12,FALSE)","v":15639},{"$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":10.678432124816165},{"$f":"IF(G22=\"N/A\",\"N/A\",IF(K22=\"N/A\",\"N/A\",IF(G22=0,\"\",K22/G22-1)))","v":-2.39520958083832E-2},{"$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":163},{"$f":"VLOOKUP($B$22,'DATA CLA'!$A$6:$P$37,13,FALSE)","v":15323},{"$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":10.637603602427722},{"$f":"IF(K22=\"N/A\", \"N/A\",IF(O22=\"N/A\", \"N/A\", IF(K22=0,\"\",O22/K22-1)))","v":7.361963190184051E-2},{"$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":175},{"$f":"VLOOKUP($B$22,'DATA CLA'!$A$6:$P$37,14,FALSE)","v":15141},{"$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":11.55802126675913},{"$f":"IF(O22=\"N/A\",\"N/A\",IF(S22=\"N/A\", \"N/A\",IF(O22=0,\"\",S22/O22-1)))","v":-0.14857142857142858},{"$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":149},{"$f":"VLOOKUP($B$22,'DATA CLA'!$A$6:$P$37,15,FALSE)","v":14742},{"$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":10.10717677384344},{"$f":"IF(S22=\"N/A\",\"N/A\", IF(W22=\"N/A\", \"N/A\",IF(S22=0,\"\",W22/S22-1)))","v":6.7114093959732557E-3},{"$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":150},{"$f":"VLOOKUP($B$22,'DATA CLA'!$A$6:$P$37,16,FALSE)","v":14566},{"$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":10.297954139777564}]
[]
["Comparator Authorities:"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2, B3,0)","v":"South Ayrshire"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,B3,0)=\"\",\"N/A\", IF(B3<33,OFFSET('DATA CLA'!$C$5,B3,0),\"\"))","v":343},{"$f":"OFFSET('DATA CLA'!$K$5,B3,0)","v":20677},{"$f":"IF(C25=\"N/A\",\"N/A\", IF(C25=0,0,IF(B3<33,C25*1000/D25,\"\")))","v":16.5884799535716},{"$f":"IF(C25=\"N/A\",\"N/A\",IF(G25=\"N/A\", \"N/A\", IF($B3=33,\"\",IF(C25=0,\"\",G25/C25-1))))","v":-3.790087463556846E-2},{"$f":"IF(OFFSET('DATA CLA'!$D$5,B3,0)=\"\",\"N/A\", IF(B3<33,OFFSET('DATA CLA'!$D$5,B3,0),\"\"))","v":330},{"$f":"OFFSET('DATA CLA'!$L$5,B3,0)","v":20480},{"$f":"IF(G25=\"N/A\",\"N/A\", IF(G25=0,0,IF(B3<33,G25*1000/H25,\"\")))","v":16.11328125},{"$f":"IF(G25=\"N/A\",\"N/A\", IF(K25=\"N/A\", \"N/A\",IF($B3=33,\"\",IF(G25=0,\"\",K25/G25-1))))","v":0.16363636363636358},{"$f":"IF(OFFSET('DATA CLA'!$E$5,B3,0)=\"\",\"N/A\", IF(B3<33,OFFSET('DATA CLA'!$E$5,B3,0),\"\"))","v":384},{"$f":"OFFSET('DATA CLA'!$M$5,B3,0)","v":20357},{"$f":"IF(K25=\"N/A\",\"N/A\", IF(K25=0,0,IF(B3<33,K25*1000/L25,\"\")))","v":18.86329026870364},{"$f":"IF(K25=\"N/A\",\"N/A\", IF(O25=\"N/A\", \"N/A\",IF($B3=33,\"\",IF(K25=0,\"\",O25/K25-1))))","v":-3.645833333333337E-2},{"$f":"IF(OFFSET('DATA CLA'!$F$5,B3,0)=\"\",\"N/A\", IF(B3<33,OFFSET('DATA CLA'!$F$5,B3,0),\"\"))","v":370},{"$f":"OFFSET('DATA CLA'!$N$5,B3,0)","v":20196},{"$f":"IF(O25=\"N/A\",\"N/A\", IF(O25=0,0,IF(B3<33,O25*1000/P25,\"\")))","v":18.320459496930084},{"$f":"IF(O25=\"N/A\",\"N/A\", IF(S25=\"N/A\", \"N/A\",IF($B3=33,\"\",IF(O25=0,\"\",S25/O25-1))))","v":-4.0540540540540571E-2},{"$f":"IF(OFFSET('DATA CLA'!$G$5,B3,0)=\"\",\"N/A\", IF(B3<33,OFFSET('DATA CLA'!$G$5,B3,0),\"\"))","v":355},{"$f":"OFFSET('DATA CLA'!$O$5,B3,0)","v":19881},{"$f":"IF(S25=\"N/A\",\"N/A\", IF(S25=0,0,IF(B3<33,S25*1000/T25,\"\")))","v":17.856244655701424},{"$f":"IF(S25=\"N/A\",\"N/A\", IF(W25=\"N/A\", \"N/A\",IF($B3=33,\"\",IF(S25=0,\"\",W25/S25-1))))","v":-2.8169014084507005E-2},{"$f":"IF(OFFSET('DATA CLA'!$H$5,B3,0)=\"\",\"N/A\", IF(B3<33,OFFSET('DATA CLA'!$H$5,B3,0),\"\"))","v":345},{"$f":"OFFSET('DATA CLA'!$P$5,B3,0)","v":19796},{"$f":"IF(W25=\"N/A\",\"N/A\", IF(W25=0,0,IF(B3<33,W25*1000/X25,\"\")))","v":17.427763184481712}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B4,0)","v":"Dumfries and Galloway"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,B4,0)=\"\",\"N/A\", IF(B4<33,OFFSET('DATA CLA'!$C$5,B4,0),\"\"))","v":387},{"$f":"OFFSET('DATA CLA'!$K$5,B4,0)","v":27802},{"$f":"IF(C26=\"N/A\",\"N/A\", IF(C26=0,0,IF(B4<33,C26*1000/D26,\"\")))","v":13.919861880440257},{"$f":"IF(C26=\"N/A\",\"N/A\", IF(G26=\"N/A\", \"N/A\",IF($B4=33,\"\",IF(C26=0,\"\",G26/C26-1))))","v":5.6847545219638196E-2},{"$f":"IF(OFFSET('DATA CLA'!$D$5,B4,0)=\"\",\"N/A\", IF(B4<33,OFFSET('DATA CLA'!$D$5,B4,0),\"\"))","v":409},{"$f":"OFFSET('DATA CLA'!$L$5,B4,0)","v":27399},{"$f":"IF(G26=\"N/A\",\"N/A\", IF(G26=0,0,IF(B4<33,G26*1000/H26,\"\")))","v":14.927552100441622},{"$f":"IF(G26=\"N/A\",\"N/A\", IF(K26=\"N/A\", \"N/A\",IF($B4=33,\"\",IF(G26=0,\"\",K26/G26-1))))","v":-3.9119804400977953E-2},{"$f":"IF(OFFSET('DATA CLA'!$E$5,B4,0)=\"\",\"N/A\", IF(B4<33,OFFSET('DATA CLA'!$E$5,B4,0),\"\"))","v":393},{"$f":"OFFSET('DATA CLA'!$M$5,B4,0)","v":27034},{"$f":"IF(K26=\"N/A\",\"N/A\", IF(K26=0,0,IF(B4<33,K26*1000/L26,\"\")))","v":14.537249389657468},{"$f":"IF(K26=\"N/A\",\"N/A\",IF(O26=\"N/A\", \"N/A\", IF($B4=33,\"\",IF(K26=0,\"\",O26/K26-1))))","v":-2.7989821882951627E-2},{"$f":"IF(OFFSET('DATA CLA'!$F$5,B4,0)=\"\",\"N/A\", IF(B4<33,OFFSET('DATA CLA'!$F$5,B4,0),\"\"))","v":382},{"$f":"OFFSET('DATA CLA'!$N$5,B4,0)","v":26707},{"$f":"IF(O26=\"N/A\",\"N/A\", IF(O26=0,0,IF(B4<33,O26*1000/P26,\"\")))","v":14.303366158684989},{"$f":"IF(O26=\"N/A\",\"N/A\",IF(S26=\"N/A\", \"N/A\", IF($B4=33,\"\",IF(O26=0,\"\",S26/O26-1))))","v":0.14921465968586389},{"$f":"IF(OFFSET('DATA CLA'!$G$5,B4,0)=\"\",\"N/A\", IF(B4<33,OFFSET('DATA CLA'!$G$5,B4,0),\"\"))","v":439},{"$f":"OFFSET('DATA CLA'!$O$5,B4,0)","v":26328},{"$f":"IF(S26=\"N/A\",\"N/A\", IF(S26=0,0,IF(B4<33,S26*1000/T26,\"\")))","v":16.674263141902156},{"$f":"IF(S26=\"N/A\",\"N/A\",IF(W26=\"N/A\", \"N/A\", IF($B4=33,\"\",IF(S26=0,\"\",W26/S26-1))))","v":-0.10022779043280183},{"$f":"IF(OFFSET('DATA CLA'!$H$5,B4,0)=\"\",\"N/A\", IF(B4<33,OFFSET('DATA CLA'!$H$5,B4,0),\"\"))","v":395},{"$f":"OFFSET('DATA CLA'!$P$5,B4,0)","v":26168},{"$f":"IF(W26=\"N/A\",\"N/A\", IF(W26=0,0,IF(B4<33,W26*1000/X26,\"\")))","v":15.094772240904922}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B5,0)","v":"Scottish Borders"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,B5,0)=\"\",\"N/A\", IF(B5<33,OFFSET('DATA CLA'!$C$5,B5,0),\"\"))","v":179},{"$f":"OFFSET('DATA CLA'!$K$5,B5,0)","v":21728},{"$f":"IF(C27=\"N/A\",\"N/A\", IF(C27=0,0,IF(B5<33,C27*1000/D27,\"\")))","v":8.2382179675994109},{"$f":"IF(C27=\"N/A\",\"N/A\", IF(G27=\"N/A\", \"N/A\",IF($B5=33,\"\",IF(C27=0,\"\",G27/C27-1))))","v":0.12290502793296088},{"$f":"IF(OFFSET('DATA CLA'!$D$5,B5,0)=\"\",\"N/A\", IF(B5<33,OFFSET('DATA CLA'!$D$5,B5,0),\"\"))","v":201},{"$f":"OFFSET('DATA CLA'!$L$5,B5,0)","v":21671},{"$f":"IF(G27=\"N/A\",\"N/A\", IF(G27=0,0,IF(B5<33,G27*1000/H27,\"\")))","v":9.2750680633104157},{"$f":"IF(G27=\"N/A\",\"N/A\", IF(K27=\"N/A\", \"N/A\",IF($B5=33,\"\",IF(G27=0,\"\",K27/G27-1))))","v":8.4577114427860645E-2},{"$f":"IF(OFFSET('DATA CLA'!$E$5,B5,0)=\"\",\"N/A\", IF(B5<33,OFFSET('DATA CLA'!$E$5,B5,0),\"\"))","v":218},{"$f":"OFFSET('DATA CLA'!$M$5,B5,0)","v":21487},{"$f":"IF(K27=\"N/A\",\"N/A\", IF(K27=0,0,IF(B5<33,K27*1000/L27,\"\")))","v":10.145669474566017},{"$f":"IF(K27=\"N/A\",\"N/A\", IF(O27=\"N/A\", \"N/A\",IF($B5=33,\"\",IF(K27=0,\"\",O27/K27-1))))","v":4.587155963302747E-2},{"$f":"IF(OFFSET('DATA CLA'!$F$5,B5,0)=\"\",\"N/A\",IF(B5<33,OFFSET('DATA CLA'!$F$5,B5,0),\"\"))","v":228},{"$f":"OFFSET('DATA CLA'!$N$5,B5,0)","v":21507},{"$f":"IF(O27=\"N/A\",\"N/A\", IF(O27=0,0,IF(B5<33,O27*1000/P27,\"\")))","v":10.601199609429488},{"$f":"IF(O27=\"N/A\",\"N/A\",IF(S27=\"N/A\", \"N/A\", IF($B5=33,\"\",IF(O27=0,\"\",S27/O27-1))))","v":-0.10087719298245612},{"$f":"IF(OFFSET('DATA CLA'!$G$5,B5,0)=\"\",\"N/A\", IF(B5<33,OFFSET('DATA CLA'!$G$5,B5,0),\"\"))","v":205},{"$f":"OFFSET('DATA CLA'!$O$5,B5,0)","v":21434},{"$f":"IF(S27=\"N/A\",\"N/A\", IF(S27=0,0,IF(B5<33,S27*1000/T27,\"\")))","v":9.5642437249230188},{"$f":"IF(S27=\"N/A\",\"N/A\",IF(W27=\"N/A\", \"N/A\", IF($B5=33,\"\",IF(S27=0,\"\",W27/S27-1))))","v":-4.8780487804878092E-2},{"$f":"IF(OFFSET('DATA CLA'!$H$5,B5,0)=\"\",\"N/A\", IF(B5<33,OFFSET('DATA CLA'!$H$5,B5,0),\"\"))","v":195},{"$f":"OFFSET('DATA CLA'!$P$5,B5,0)","v":21349},{"$f":"IF(W27=\"N/A\",\"N/A\", IF(W27=0,0,IF(B5<33,W27*1000/X27,\"\")))","v":9.1339172794978687}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B6,0)","v":"Highland"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,B6,0)=\"\",\"N/A\", IF(B6<33,OFFSET('DATA CLA'!$C$5,B6,0),\"\"))","v":447},{"$f":"OFFSET('DATA CLA'!$K$5,B6,0)","v":46070},{"$f":"IF(C28=\"N/A\",\"N/A\", IF(C28=0,0,IF(B6<33,C28*1000/D28,\"\")))","v":9.7026264380290854},{"$f":"IF(C28=\"N/A\",\"N/A\", IF(G28=\"N/A\", \"N/A\",IF($B6=33,\"\",IF(C28=0,\"\",G28/C28-1))))","v":-2.2371364653243853E-2},{"$f":"IF(OFFSET('DATA CLA'!$D$5,B6,0)=\"\",\"N/A\", IF(B6<33,OFFSET('DATA CLA'!$D$5,B6,0),\"\"))","v":437},{"$f":"OFFSET('DATA CLA'!$L$5,B6,0)","v":45603},{"$f":"IF(G28=\"N/A\",\"N/A\", IF(G28=0,0,IF(B6<33,G28*1000/H28,\"\")))","v":9.5827028923535735},{"$f":"IF(G28=\"N/A\",\"N/A\", IF(K28=\"N/A\", \"N/A\",IF($B6=33,\"\",IF(G28=0,\"\",K28/G28-1))))","v":6.8649885583524917E-3},{"$f":"IF(OFFSET('DATA CLA'!$E$5,B6,0)=\"\",\"N/A\", IF(B6<33,OFFSET('DATA CLA'!$E$5,B6,0),\"\"))","v":440},{"$f":"OFFSET('DATA CLA'!$M$5,B6,0)","v":45470},{"$f":"IF(K28=\"N/A\",\"N/A\", IF(K28=0,0,IF(B6<33,K28*1000/L28,\"\")))","v":9.6767099186276671},{"$f":"IF(K28=\"N/A\",\"N/A\", IF(O28=\"N/A\", \"N/A\",IF($B6=33,\"\",IF(K28=0,\"\",O28/K28-1))))","v":0.10681818181818192},{"$f":"IF(OFFSET('DATA CLA'!$F$5,B6,0)=\"\",\"N/A\", IF(B6<33,OFFSET('DATA CLA'!$F$5,B6,0),\"\"))","v":487},{"$f":"OFFSET('DATA CLA'!$N$5,B6,0)","v":45284},{"$f":"IF(O28=\"N/A\",\"N/A\", IF(O28=0,0,IF(B6<33,O28*1000/P28,\"\")))","v":10.754350322409682},{"$f":"IF(O28=\"N/A\",\"N/A\",IF(S28=\"N/A\", \"N/A\", IF($B6=33,\"\",IF(O28=0,\"\",S28/O28-1))))","v":6.9815195071868619E-2},{"$f":"IF(OFFSET('DATA CLA'!$G$5,B6,0)=\"\",\"N/A\", IF(B6<33,OFFSET('DATA CLA'!$G$5,B6,0),\"\"))","v":521},{"$f":"OFFSET('DATA CLA'!$O$5,B6,0)","v":44427},{"$f":"IF(S28=\"N/A\",\"N/A\", IF(S28=0,0,IF(B6<33,S28*1000/T28,\"\")))","v":11.727102887883495},{"$f":"IF(S28=\"N/A\",\"N/A\", IF(W28=\"N/A\", \"N/A\",IF($B6=33,\"\",IF(S28=0,\"\",W28/S28-1))))","v":-7.2936660268714038E-2},{"$f":"IF(OFFSET('DATA CLA'!$H$5,B6,0)=\"\",\"N/A\", IF(B6<33,OFFSET('DATA CLA'!$H$5,B6,0),\"\"))","v":483},{"$f":"OFFSET('DATA CLA'!$P$5,B6,0)","v":44039},{"$f":"IF(W28=\"N/A\",\"N/A\", IF(W28=0,0,IF(B6<33,W28*1000/X28,\"\")))","v":10.967551488453417}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B7,0)","v":"Angus"},{"$f":"IF(OFFSET('DATA CLA'!$C$5,B7,0)=\"\",\"N/A\", IF(B7<33,OFFSET('DATA CLA'!$C$5,B7,0),\"\"))","v":272},{"$f":"OFFSET('DATA CLA'!$K$5,B7,0)","v":22608},{"$f":"IF(C29=\"N/A\",\"N/A\", IF(C29=0,0,IF(B7<33,C29*1000/D29,\"\")))","v":12.031139419674451},{"$f":"IF(C29=\"N/A\",\"N/A\", IF(G29=\"N/A\", \"N/A\",IF($B7=33,\"\",IF(C29=0,\"\",G29/C29-1))))","v":-4.0441176470588203E-2},{"$f":"IF(OFFSET('DATA CLA'!$D$5,B7,0)=\"\",\"N/A\", IF(B7<33,OFFSET('DATA CLA'!$D$5,B7,0),\"\"))","v":261},{"$f":"OFFSET('DATA CLA'!$L$5,B7,0)","v":22523},{"$f":"IF(G29=\"N/A\",\"N/A\", IF(G29=0,0,IF(B7<33,G29*1000/H29,\"\")))","v":11.58815433112818},{"$f":"IF(G29=\"N/A\",\"N/A\", IF(K29=\"N/A\", \"N/A\",IF($B7=33,\"\",IF(G29=0,\"\",K29/G29-1))))","v":-8.8122605363984641E-2},{"$f":"IF(OFFSET('DATA CLA'!$E$5,B7,0)=\"\",\"N/A\", IF(B7<33,OFFSET('DATA CLA'!$E$5,B7,0),\"\"))","v":238},{"$f":"OFFSET('DATA CLA'!$M$5,B7,0)","v":22339},{"$f":"IF(K29=\"N/A\",\"N/A\", IF(K29=0,0,IF(B7<33,K29*1000/L29,\"\")))","v":10.654013160839787},{"$f":"IF(K29=\"N/A\",\"N/A\",IF(O29=\"N/A\", \"N/A\", IF($B7=33,\"\",IF(K29=0,\"\",O29/K29-1))))","v":7.1428571428571397E-2},{"$f":"IF(OFFSET('DATA CLA'!$F$5,B7,0)=\"\",\"N/A\", IF(B7<33,OFFSET('DATA CLA'!$F$5,B7,0),\"\"))","v":255},{"$f":"OFFSET('DATA CLA'!$N$5,B7,0)","v":22034},{"$f":"IF(O29=\"N/A\",\"N/A\", IF(O29=0,0,IF(B7<33,O29*1000/P29,\"\")))","v":11.573023509122265},{"$f":"IF(O29=\"N/A\",\"N/A\",IF(S29=\"N/A\", \"N/A\", IF($B7=33,\"\",IF(O29=0,\"\",S29/O29-1))))","v":-1.5686274509803977E-2},{"$f":"IF(OFFSET('DATA CLA'!$G$5,B7,0)=\"\",\"N/A\", IF(B7<33,OFFSET('DATA CLA'!$G$5,B7,0),\"\"))","v":251},{"$f":"OFFSET('DATA CLA'!$O$5,B7,0)","v":21759},{"$f":"IF(S29=\"N/A\",\"N/A\", IF(S29=0,0,IF(B7<33,S29*1000/T29,\"\")))","v":11.535456592674295},{"$f":"IF(S29=\"N/A\", \"N/A\",IF(W29=\"N/A\",\"N/A\", IF($B7=33,\"\",IF(S29=0,\"\",W29/S29-1))))","v":-2.7888446215139417E-2},{"$f":"IF(OFFSET('DATA CLA'!$H$5,B7,0)=\"\",\"N/A\", IF(B7<33,OFFSET('DATA CLA'!$H$5,B7,0),\"\"))","v":244},{"$f":"OFFSET('DATA CLA'!$P$5,B7,0)","v":21588},{"$f":"IF(W29=\"N/A\",\"N/A\", IF(W29=0,0,IF(B7<33,W29*1000/X29,\"\")))","v":11.302575504910136}]
[]
[null,"Comparator authorities",{"$f":"SUM(C25:C29)","v":1628},{"$f":"SUM(D25:D29)","v":138885},{"$f":"SUM(C25:C29)/SUM(D25:D29)*1000","v":11.721928213989992},{"$f":"IF(C31=0,\"\",SUM(G25:G29)/SUM(C25:C29)-1)","v":6.1425061425062211E-3},{"$f":"SUM(G25:G29)","v":1638},{"$f":"SUM(H25:H29)","v":137676},{"$f":"SUM(G25:G29)/SUM(H25:H29)*1000","v":11.897498474679683},{"$f":"IF(G31=0,\"\",SUM(K25:K29)/SUM(G25:G29)-1)","v":2.1367521367521292E-2},{"$f":"SUM(K25:K29)","v":1673},{"$f":"SUM(L25:L29)","v":136687},{"$f":"SUM(K25:K29)/SUM(L25:L29)*1000","v":12.239642394668111},{"$f":"IF(K31=0,\"\",SUM(O25:O29)/SUM(K25:K29)-1)","v":2.9288702928870203E-2},{"$f":"SUM(O25:O29)","v":1722},{"$f":"SUM(P25:P29)","v":135728},{"$f":"SUM(O25:O29)/SUM(P25:P29)*1000","v":12.687138983850053},{"$f":"IF(O31=0,\"\",SUM(S25:S29)/SUM(O25:O29)-1)","v":2.8455284552845628E-2},{"$f":"SUM(S25:S29)","v":1771},{"$f":"SUM(T25:T29)","v":133829},{"$f":"SUM(S25:S29)/SUM(T25:T29)*1000","v":13.233305187963744},{"$f":"IF(S31=0,\"\",SUM(W25:W29)/SUM(S25:S29)-1)","v":-6.1547148503670268E-2},{"$f":"SUM(W25:W29)","v":1662},{"$f":"SUM(X25:X29)","v":132940},{"$f":"SUM(W25:W29)/SUM(X25:X29)*1000","v":12.501880547615466}]
[]
[null,"Scotland",{"$f":"'DATA CLA'!C38","v":15600},{"$f":"'DATA CLA'!K38","v":1034923},{"$f":"C33*1000/D33","v":15.073585184598274},{"$f":"IF(C33=0,\"\",G33/C33-1)","v":-1.2820512820512775E-2},{"$f":"'DATA CLA'!D38","v":15400},{"$f":"'DATA CLA'!L38","v":1032698},{"$f":"G33*1000/H33","v":14.912394523858863},{"$f":"IF(G33=0,\"\",K33/G33-1)","v":-5.3896103896103886E-3},{"$f":"'DATA CLA'!E38","v":15317},{"$f":"'DATA CLA'!M38","v":1031096},{"$f":"K33*1000/L33","v":14.855066841496814},{"$f":"IF(K33=0,\"\",O33/K33-1)","v":-2.7420513155317572E-2},{"$f":"'DATA CLA'!F38","v":14897},{"$f":"'DATA CLA'!$N$38","v":1031761},{"$f":"O33*1000/P33","v":14.438421301057124},{"$f":"IF(O33=0,\"\",S33/O33-1)","v":-2.302477008793713E-2},{"$f":"'DATA CLA'!G38","v":14554},{"$f":"'DATA CLA'!$O$38","v":1028798},{"$f":"S33*1000/T33","v":14.146606039280792},{"$f":"IF(S33=0,\"\",W33/S33-1)","v":-2.006321286244328E-2},{"$f":"'DATA CLA'!H38","v":14262},{"$f":"'DATA CLA'!$P$38","v":1029162},{"$f":"W33*1000/X33","v":13.857876602517388}]
[]
["Notes"]
[{"$f":"IF('DATA CLA'!A40=\"\",\"\",'DATA CLA'!A40)","v":"Population figures source: NRS mid-year population estimates for 2013-2019."}]
[{"$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,{"$f":"V22-V31","v":6.8258557899643524E-2},null,null,{"$f":"Y22-Y31","v":-2.2039264078379013},{"$f":"IF(Y40<-0.5,\"less than\",IF(Y40>0.5,\"greater than\",\"similar to\"))","v":"less than"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V22-V33","v":2.6774622258416536E-2},null,null,{"$f":"Y22-Y33","v":-3.5599224627398236},{"$f":"IF(Y41<-0.5,\"less than\",IF(Y41>0.5,\"greater than\",\"similar to\"))","v":"less than"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W22-S22","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V43<0,\"a decrease of \",IF(V43>=0,\"an increase of \"))","v":"an increase of "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V31<0,\"a decrease of \",IF(V31>=0,\"an increase of \"))","v":"a decrease of "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V33<0,\"a decrease of \",IF(V33>=0,\"an increase of \"))","v":"a decrease of "}]

{"sheet":"CLA Accommodation","index":2,"n_rows":70,"n_cols":33,"rows_kept":70,"cut":false,"hidden":false,"merged":[[43,0,44,16],[25,23,25,24],[25,31,25,32],[11,1,13,4],[14,1,16,4],[17,1,22,4],[25,7,25,8],[25,15,25,16]]}
[{"$f":"'DATA CLA Acc'!A1","v":"Children Looked After: Type of Accommodation at 31 July 2016 to 2019"}]
[null,null,"select comparators:"]
[null,{"$f":"J3","v":28},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":28}]
[null,15,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":7}]
[null,{"$f":"J5","v":26},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":26}]
[null,9,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":16}]
[null,17,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":3}]
[]
[]
[]
[]
[null,{"$f":"IF(AA28=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(AA28>0,\"*  In \"&AA26&\", \"&ROUND(100*AA28,0)&\"% of looked after children in \"&B28&\" were living at home with parents, \"&AA52&ROUND(SQRT((100*AA48)^2),1)&\"%-points over the previous year.\",\"\"))","v":"*  In In the community, 31% of looked after children in Argyll & Bute were living at home with parents, an increase of 3.8%-points over the previous year."}]
[]
[]
[null,{"$f":"IF(AA28>0,\"*  This compares with \"&AA53&ROUND(SQRT((100*AA49)^2),1)&\"%-points for comparator authorities, and \"&AA54&ROUND(SQRT((100*AA50)^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 1.5%-points for Scotland as a whole."}]
[]
[]
[null,{"$f":"IF(AA28=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(AA28>0,\"*  The percentage of children living at home with parents (\"&ROUND(100*AA28,0)&\"%) is \"&AA67&\" the comparator average (\"&ROUND(100*AA37,0)&\"%), and \"&AA70&\" the Scotland average (\"&ROUND(100*AA39,0)&\"%).\",\"\"))","v":"*  The percentage of children living at home with parents (31%) is greater than the comparator average (20%), and greater than the Scotland average (25%)."}]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'DATA CLA Acc'!B3","v":2016},null,null,null,null,null,null,null,{"$f":"'DATA CLA Acc'!K3","v":2017},null,null,null,null,null,null,null,{"$f":"'DATA CLA Acc'!T3","v":2018},null,null,null,null,null,null,null,{"$f":"'DATA CLA Acc'!AC3","v":2019}]
[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,null,"In the community",null,null,null,null,"In residential accommodation"]
[null,null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community1","In local authority home/ Voluntary Home ","In other residential care2",null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community1","In local authority home/ Voluntary Home ","In other residential care2",null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community1","In local authority home/ Voluntary Home ","In other residential care2",null,"At home with parents","With friends / relatives","With foster carers provided by LA","With foster carers purchased by LA","In other community1","In local authority home/ Voluntary Home ","In other residential care2"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Argyll & Bute"},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.29447852760736198},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.26993865030674846},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.2822085889570552},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":6.1349693251533742E-2},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":6.1349693251533742E-2},null,{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.29714285714285715},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.33142857142857141},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.21142857142857144},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":7.4285714285714288E-2},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":5.1428571428571428E-2},null,{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.26845637583892618},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.30201342281879195},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.22818791946308725},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.12080536912751678},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":6.0402684563758392E-2},null,{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.30666666666666664},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.28000000000000003},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.21333333333333335},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.1},{"$f":"IFERROR(VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$51,FALSE)/VLOOKUP($B28,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":6.6666666666666666E-2}]
[]
["Comparator Authorities:"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2, B3,0)","v":"South Ayrshire"},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.32291666666666669},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.20052083333333334},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.25260416666666669},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.125},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":3.90625E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":1.8229166666666668E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.1666666666666664E-2},null,{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.34594594594594597},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.25135135135135134},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.21621621621621623},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":9.7297297297297303E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":3.2432432432432434E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":2.1621621621621623E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":3.5135135135135137E-2},null,{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.27323943661971833},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.25070422535211268},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.24507042253521127},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.11267605633802817},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":2.2535211267605635E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":1.9718309859154931E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":7.605633802816901E-2},null,{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.20579710144927535},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.2608695652173913},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.32463768115942027},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":7.8260869565217397E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":2.8985507246376812E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":3.4782608695652174E-2},{"$f":"IFERROR(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$51,FALSE)/VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":6.6666666666666666E-2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B4,0)","v":"Glasgow City"},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.16514875531268974},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.4116575591985428},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.23588342440801457},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":9.8057073466909533E-2},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":2.1250758955676987E-3},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.4019429265330902E-2},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.3108682452944747E-2},null,{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.17368234877962505},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.40749911567032188},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.23523169437566324},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.10010611956137248},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":4.740007074637425E-2},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":"*"},null,{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.17466918714555765},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.42419659735349718},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.22306238185255198},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":9.2627599243856329E-2},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":5.6332703213610585E-2},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":2.9111531190926274E-2},null,{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.15814506539833531},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.46095917558462146},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.21799445105033691},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":8.4819659135949271E-2},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":5.3904082441537854E-2},{"$f":"IFERROR(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$51,FALSE)/VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":2.3384859294490686E-2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B5,0)","v":"Scottish Borders"},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.12385321100917432},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.26605504587155965},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.3577981651376147},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":8.7155963302752298E-2},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.1284403669724773E-2},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":2.2935779816513763E-2},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.10091743119266056},null,{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.20614035087719298},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.25},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.34210526315789475},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":6.5789473684210523E-2},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":9.6491228070175433E-2},null,{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.2780487804878049},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.23414634146341465},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.3073170731707317},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":3.9024390243902439E-2},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.11219512195121951},null,{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.28205128205128205},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.25641025641025639},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.29230769230769232},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":3.5897435897435895E-2},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$51,FALSE)/VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.10256410256410256}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B6,0)","v":"East Ayrshire"},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.27645788336933047},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.28725701943844495},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.24190064794816415},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":8.6393088552915762E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":2.591792656587473E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":3.4557235421166309E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.7516198704103674E-2},null,{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.29533678756476683},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.25388601036269431},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.23834196891191708},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":9.8445595854922283E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":1.8134715025906734E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":3.8860103626943004E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":5.6994818652849742E-2},null,{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.30922693266832918},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.25187032418952621},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.23940149625935161},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":6.4837905236907731E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":4.488778054862843E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":3.7406483790523692E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":5.2369077306733167E-2},null,{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.30399999999999999},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.24},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.27733333333333332},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":6.6666666666666666E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":2.6666666666666668E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.5333333333333337E-2},{"$f":"IFERROR(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$51,FALSE)/VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.04}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B7,0)","v":"Inverclyde"},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.38164251207729466},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.2560386473429952},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.15458937198067632},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":3.3816425120772944E-2},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":2.4154589371980676E-2},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.10628019323671498},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.3478260869565216E-2},null,{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.39449541284403672},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.27522935779816515},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.16513761467889909},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":9.1743119266055051E-2},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":3.2110091743119268E-2},null,{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.43216080402010049},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.23115577889447236},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":0.15075376884422109},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":2.5125628140703519E-2},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":2.5125628140703519E-2},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":8.5427135678391955E-2},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":5.0251256281407038E-2},null,{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.47804878048780486},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.21951219512195122},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.12195121951219512},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":2.4390243902439025E-2},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":"*"},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":9.2682926829268292E-2},{"$f":"IFERROR(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$51,FALSE)/VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.3902439024390241E-2}]
[]
[null,"Comparator authorities3",{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!B$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":0.19754708716600963},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!C$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":0.36727989487516427},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!D$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":0.24003504161191414},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!E$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":9.5707402540516864E-2},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!F$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":1.0512483574244415E-2},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!G$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":4.2706964520367936E-2},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!H$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE))","v":4.6211125711782743E-2},null,{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!K$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":0.21494167287168031},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!L$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":0.36237279722015386},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!M$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":0.23603871928518244},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!N$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":9.2330603127326882E-2},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!O$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":4.7158103747828245E-3},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!P$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":4.3931496649292627E-2},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Q$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE))","v":1.5884834946636884E-2},null,{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!T$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":0.21708278580814719},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!U$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":0.36951379763469122},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!V$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":0.22759526938239158},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!W$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":8.5151116951379766E-2},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!X$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":8.1471747700394212E-3},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Y$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":4.9408672798948755E-2},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!Z$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE))","v":4.1524310118265441E-2},null,{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AC$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":0.20230579192972825},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AD$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":0.39472961844633542},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AE$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":0.23277518528685148},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AF$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":7.6310732912434801E-2},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AG$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":5.4899807850672519E-3},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AH$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":5.0507823222618722E-2},{"$f":"SUM(IF(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)=\"*\",0,VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)),IF(VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)=\"*\",0,VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)),IF(VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)=\"*\",0,VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)),IF(VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)=\"*\",0,VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)),IF(VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)=\"*\",0,VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$38,'DATA CLA Acc'!AI$51,FALSE)))/SUM(VLOOKUP($B31,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B32,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B33,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B34,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),VLOOKUP($B35,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE))","v":3.4586878945923688E-2}]
[]
[null,"Scotland",{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!B$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.25266044264542664},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!C$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.27936279950381926},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!D$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.24978781745772671},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!E$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":0.10223934190768427},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!F$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":1.9520793889142782E-2},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!G$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.6810733172292222E-2},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!H$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,9,FALSE),\"*\")","v":4.9618071423908075E-2},null,{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!K$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.25280257770020809},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!L$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.27777404846613413},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!M$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.23555078203665167},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!N$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":0.11700342350808887},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!O$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":1.5573605423910855E-2},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!P$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":5.0077196751023699E-2},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Q$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,18,FALSE),\"*\")","v":5.1218366113982679E-2},null,{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!T$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.26567101388304587},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!U$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.28558406955546206},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!V$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.24211190576356753},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!W$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.1045435422801851},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!X$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":1.6547468798205019E-2},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Y$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":5.0553919506380593E-2},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!Z$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,27,FALSE),\"*\")","v":5.4349319774632407E-2},null,{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AC$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.25024540737624457},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AD$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.29273594166316086},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AE$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.23383817136446503},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AF$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":0.10258028327022858},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AG$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":1.9071658953863414E-2},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AH$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":4.9642406394615063E-2},{"$f":"IFERROR(VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,'DATA CLA Acc'!AI$51,FALSE)/VLOOKUP($B39,'DATA CLA Acc'!$A$7:$AJ$39,36,FALSE),\"*\")","v":5.188613097742252E-2}]
[]
["Notes"]
["In other community includes with prospective adopters."]
["Other Residential Care includes crisis care, secure accommodation and residential school."]
["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.",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('DATA CLA Acc'!A44=\"\",\"\",'DATA CLA Acc'!A44)","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,{"$f":"T28-L28","v":-2.9415148609779451E-2},{"$f":"U28-M28","v":1.6759348034515814E-2},{"$f":"V28-N28","v":{"$error":"#VALUE!"}},{"$f":"W28-O28","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"AA28-S28","v":3.8210290827740467E-2},{"$f":"AB28-T28","v":-2.2013422818791928E-2},{"$f":"AC28-U28","v":-1.4854586129753905E-2},{"$f":"AD28-V28","v":{"$error":"#VALUE!"}},{"$f":"AE28-W28","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T37-L37","v":7.1410004145373573E-3},{"$f":"U37-M37","v":-8.4434499027908616E-3},{"$f":"V37-N37","v":-7.1794861759471168E-3},{"$f":"W37-O37","v":3.4313643952565967E-3},null,null,null,{"$f":"AA37-S37","v":-1.4776993878418937E-2},{"$f":"AB37-T37","v":2.5215820811644196E-2},{"$f":"AC37-U37","v":5.179915904459903E-3},{"$f":"AD37-V37","v":-8.8403840389449651E-3},{"$f":"AE37-W37","v":-2.6571939849721693E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T39-L39","v":7.8100210893279343E-3},{"$f":"U39-M39","v":6.5611237269158629E-3},{"$f":"V39-N39","v":-1.2459881227903771E-2},{"$f":"W39-O39","v":9.7386337429416353E-4},null,null,null,{"$f":"AA39-S39","v":-1.5425606506801304E-2},{"$f":"AB39-T39","v":7.1518721076987979E-3},{"$f":"AC39-U39","v":-8.2737343991025059E-3},{"$f":"AD39-V39","v":-1.9632590099565167E-3},{"$f":"AE39-W39","v":2.524190155658395E-3}]
[null,"Comparator authorities"]
[null,"Scotland",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T48<0,\"a decrease of \",IF(T48>=0,\"an increase of \"))","v":"a decrease of "},"an increase of ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,{"$f":"IF(AA48<0,\"a decrease of \",IF(AA48>=0,\"an increase of \"))","v":"an increase of "},{"$f":"IF(AB48<0,\"a decrease of \",IF(AB48>=0,\"An increase of \"))","v":"a decrease of "},{"$f":"IF(AC48<0,\"a decrease of \",IF(AC48>=0,\"an increase of \"))","v":"a decrease of "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"an increase of ","a decrease of ","a decrease of ","an increase of ",null,null,null,{"$f":"IF(AA49<0,\"a decrease of \",IF(AA49>=0,\"an increase of \"))","v":"a decrease of "},"an increase of ","an increase of ","a decrease of ","a decrease of "]
[null,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 ","an increase of ",null,null,null,{"$f":"IF(AA50<0,\"a decrease of \",IF(AA50>=0,\"an increase of \"))","v":"a decrease of "},"an increase of ","a decrease of ","a decrease of ","an increase of "]
[]
[null,null,null,{"$f":"IF(D31=\"*\",\"\",D31*$C31)","v":6.4751519097222224E-2},{"$f":"IF(E31=\"*\",\"\",E31*$C31)","v":8.1570095486111119E-2},{"$f":"IF(F31=\"*\",\"\",F31*$C31)","v":4.0364583333333336E-2},{"$f":"IF(G31=\"*\",\"\",G31*$C31)","v":1.2613932291666668E-2},null,null,null,null,{"$f":"IF(L31=\"*\",\"\",L31*$K31)","v":8.6953981008035058E-2},{"$f":"IF(M31=\"*\",\"\",M31*$K31)","v":7.4799123447772106E-2},{"$f":"IF(N31=\"*\",\"\",N31*$K31)","v":3.3659605551497447E-2},{"$f":"IF(O31=\"*\",\"\",O31*$K31)","v":1.1219868517165816E-2},null,null,null,null,{"$f":"IF(T31=\"*\",\"\",T31*$S31)","v":6.8502281293394168E-2},{"$f":"IF(U31=\"*\",\"\",U31*$S31)","v":6.6962904185677449E-2},{"$f":"IF(V31=\"*\",\"\",V31*$S31)","v":3.0787542154334459E-2},{"$f":"IF(W31=\"*\",\"\",W31*$S31)","v":6.1575084308668924E-3},null,null,null,{"$f":"IF(AA31=\"*\",\"\",AA31*$AA31)","v":4.2352446964923331E-2},{"$f":"IF(AB31=\"*\",\"\",AB31*$AA31)","v":5.3686200378071827E-2},{"$f":"IF(AC31=\"*\",\"\",AC31*$AA31)","v":6.6809493803822714E-2},{"$f":"IF(AD31=\"*\",\"\",AD31*$AA31)","v":1.610586011342155E-2},{"$f":"IF(AE31=\"*\",\"\",AE31*$AA31)","v":5.9651333753413145E-3}]
[null,null,null,{"$f":"IF(D32=\"*\",\"\",D32*$C32)","v":6.7984733516699244E-2},{"$f":"IF(E32=\"*\",\"\",E32*$C32)","v":3.8955853939878549E-2},1.6194003632665085E-2,3.5095363909800492E-4,null,null,null,null,{"$f":"IF(L32=\"*\",\"\",L32*$K32)","v":7.0775403535241616E-2},4.0855593186576104E-2,1.738666597263314E-2,"",null,null,null,null,{"$f":"IF(T32=\"*\",\"\",T32*$S32)","v":7.4094074849646765E-2},3.8962124920937244E-2,1.6179187467168857E-2,"",null,null,null,{"$f":"IF(AA32=\"*\",\"\",AA32*$AA32)","v":2.5009861709843751E-2},{"$f":"IF(AB32=\"*\",\"\",AB32*$AA32)","v":7.2898418968792691E-2},3.4474746717829734E-2,1.3413810541119207E-2,""]
[null,null,null,{"$f":"IF(D33=\"*\",\"\",D33*$C33)","v":3.2951771736385832E-2},4.4314451645484393E-2,1.0794545913643634E-2,5.1132059590943526E-3,null,null,null,null,5.1535087719298246E-2,7.0521698984302869E-2,1.3561865189289011E-2,"",null,null,null,null,6.5104104699583595E-2,8.5449137418203452E-2,1.0850684116597264E-2,"",null,null,null,{"$f":"IF(AA33=\"*\",\"\",AA33*$AA33)","v":7.955292570677186E-2},7.2320841551610782E-2,8.2445759368836302E-2,1.0124917817225508E-2,""]
[null,null,null,{"$f":"IF(D34=\"*\",\"\",D34*$C34)","v":7.9414467576935113E-2},6.6875341117419038E-2,2.3884050399078226E-2,7.1652151197234681E-3,null,null,null,null,7.4981878708153246E-2,7.0391151440307123E-2,2.9074606029692071E-2,5.3558484791538024E-3,null,null,null,null,7.7885087779304862E-2,7.4029390364487788E-2,2.0049626557048776E-2,1.3880510693341459E-2,null,null,null,{"$f":"IF(AA34=\"*\",\"\",AA34*$AA34)","v":9.2415999999999998E-2},7.2959999999999997E-2,8.4309333333333333E-2,2.0266666666666665E-2,8.1066666666666665E-3]
[null,null,null,{"$f":"IF(D35=\"*\",\"\",D35*$C35)","v":9.7715232560853238E-2},5.8997876263156661E-2,1.2905785432565519E-2,9.2184181661182276E-3,null,null,null,null,0.10857671913138627,6.5146031478831759E-2,"","",null,null,null,null,9.9896467260927754E-2,6.5149869952778966E-2,1.0858311658796495E-2,1.0858311658796495E-2,null,null,null,{"$f":"IF(AA35=\"*\",\"\",AA35*$AA35)","v":0.22853063652587743},0.10493753718024985,5.829863176680547E-2,1.1659726353361094E-2,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T28-T37","v":-6.7500374815899267E-2},{"$f":"U28-U37","v":5.9265008069567249E-4},{"$f":"V28-V37","v":{"$error":"#VALUE!"}},{"$f":"W28-W37","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"AA28-AA37","v":0.10436087473693839},{"$f":"AB28-AB37","v":-0.11472961844633539},{"$f":"AC28-AC37","v":-1.9441851953518136E-2},{"$f":"AD28-AD37","v":{"$error":"#VALUE!"}},{"$f":"AE28-AE37","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T28-T39","v":1.6429353263329893E-2},{"$f":"U28-U39","v":-1.3923986300480279E-2},{"$f":"V28-V39","v":{"$error":"#VALUE!"}},{"$f":"W28-W39","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"AA28-AA39","v":5.6421259290422077E-2},{"$f":"AB28-AB39","v":-1.2735941663160832E-2},{"$f":"AC28-AC39","v":-2.0504838031131678E-2},{"$f":"AD28-AD39","v":{"$error":"#VALUE!"}},{"$f":"AE28-AE39","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T63<-0.02,\"less than\",IF(T63>0.02,\"greater than\",\"similar to\"))","v":"less than"},null,null,null,null,null,null,{"$f":"IF(AA63<-0.02,\"less than\",IF(AA63>0.02,\"greater than\",\"similar to\"))","v":"greater than"},{"$f":"IF(AB63<-0.02,\"less than\",IF(AB63>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,null,{"$f":"IF(T65<-0.02,\"less than\",IF(T65>0.02,\"greater than\",\"similar to\"))","v":"similar to"},null,null,null,null,null,null,{"$f":"IF(AA65<-0.02,\"less than\",IF(AA65>0.02,\"greater than\",\"similar to\"))","v":"greater than"},{"$f":"IF(AB65<-0.02,\"less than\",IF(AB65>0.02,\"greater than\",\"similar to\"))","v":"similar to"}]

{"sheet":"CLA Disability","index":3,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[11,1,13,4],[14,1,16,4],[17,1,19,4]]}
[{"$f":"'DATA CLA DIS'!A1","v":"Children Looked After: by disability status at 31 July 2016 to 2019"}]
[null,null,"select comparators:"]
[null,{"$f":"J3","v":28},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":28}]
[null,{"$f":"J4","v":7},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":7}]
[null,{"$f":"J5","v":26},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":26}]
[null,{"$f":"J6","v":16},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":16}]
[null,{"$f":"J7","v":3},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":3}]
[]
[]
[]
[]
[null,{"$f":"IF(L24=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(P24=\"N/A\",\"[text statement not available due to due to data being unavailable]\",IF(L24=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(P24=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  In \"&O22&\", the percentage of looked after children with a disability in \"&B24&\" was \"&ROUND(100*Q24,0)&\"%, \"&N46&ROUND(SQRT((100*N40)^2),1)&\"%-points over the previous year.\"))))","v":"*  In 2019, the percentage of looked after children with a disability in Argyll & Bute was 23%, an increase of 3.2%-points over the previous year."}]
[]
[]
[null,{"$f":"IF(L33=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(P33=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(L33=0,\"[text statement not available due to suppression of data for confidentiality]\",IF(P33=0,\"[text statement not available due to suppression of data for confidentiality]\",\"*  This compares with \"&N47&ROUND(SQRT((100*N41)^2),1)&\"%-points for comparator authorities, and \"&N48&ROUND(SQRT((100*N42)^2),1)&\"%-points for Scotland as a whole.\"))))","v":"*  This compares with a decrease of 2.6%-points for comparator authorities, and an increase of 0.3%-points for Scotland as a whole."}]
[]
[]
[null,{"$f":"IF(P24=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(P33=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(P24=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(P33=0,\"[text statement not available due to suppression of data for confidentiality]\",\"*  The percentage looked after children with a disability (\"&ROUND(100*Q24,0)&\"%) is \"&Q45&\" the comparator average (\"&ROUND(100*Q33,0)&\"%), and \"&Q49&\" the Scotland average (\"&ROUND(100*Q35,0)&\"%).\"))))","v":"*  The percentage looked after children with a disability (23%) is greater than the comparator average (10%), and greater than the Scotland average (11%)."}]
[]
[]
[]
[null,null,{"$f":"'DATA CLA DIS'!B4","v":2016},null,null,null,{"$f":"'DATA CLA DIS'!E4","v":2017},null,null,null,{"$f":"'DATA CLA DIS'!H4","v":2018},null,null,null,{"$f":"'DATA CLA DIS'!K4","v":2019}]
[null,null,{"$f":"'DATA CLA DIS'!B5","v":"No. of children looked after "},{"$f":"'DATA CLA DIS'!C5","v":"No. of children looked after with  known additional support needs"},{"$f":"'DATA CLA DIS'!D5","v":"% of children looked after with known additional support needs"},null,{"$f":"'DATA CLA DIS'!E5","v":"No. of children looked after "},{"$f":"'DATA CLA DIS'!F5","v":"No. of children looked after with a disability"},{"$f":"'DATA CLA DIS'!G5","v":"% of children looked after with a disability"},null,{"$f":"'DATA CLA DIS'!H5","v":"No. of children looked after "},{"$f":"'DATA CLA DIS'!I5","v":"No. of children looked after with a disability"},{"$f":"'DATA CLA DIS'!J5","v":"% of children looked after with a disability"},null,{"$f":"'DATA CLA DIS'!K5","v":"No. of children looked after "},{"$f":"'DATA CLA DIS'!L5","v":"No. of children looked after with a disability"},{"$f":"'DATA CLA DIS'!M5","v":"% of children looked after with a disability"}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Argyll & Bute"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA DIS'!$B$5,'Select an authority'!$A$1,0))","v":163},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA DIS'!$C$5,'Select an authority'!$A$1,0)<5,\"*\",OFFSET('DATA CLA DIS'!$C$5,'Select an authority'!$A$1,0)))","v":36},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(D24=\"*\",\"\",OFFSET('DATA CLA DIS'!$D$5,'Select an authority'!$A$1,0)))","v":0.22},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA DIS'!$E$5,'Select an authority'!$A$1,0))","v":175},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA DIS'!$F$5,'Select an authority'!$A$1,0)<5,\"*\",OFFSET('DATA CLA DIS'!$F$5,'Select an authority'!$A$1,0)))","v":36},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(H24=\"*\",\"\",OFFSET('DATA CLA DIS'!$G$5,'Select an authority'!$A$1,0)))","v":0.20571428571428571},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",OFFSET('DATA CLA DIS'!$H$5,'Select an authority'!$A$1,0))","v":149},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA DIS'!$I$5,'Select an authority'!$A$1,0)<5,\"*\",OFFSET('DATA CLA DIS'!$I$5,'Select an authority'!$A$1,0)))","v":29},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(L24=\"*\",\"\",OFFSET('DATA CLA DIS'!$J$5,'Select an authority'!$A$1,0)))","v":0.19463087248322147},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",(OFFSET('DATA CLA DIS'!$K$5,'Select an authority'!$A$1,0)))","v":150},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(OFFSET('DATA CLA DIS'!$L$5,'Select an authority'!$A$1,0)<5,\"*\",OFFSET('DATA CLA DIS'!$L$5,'Select an authority'!$A$1,0)))","v":34},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$5,'Select an authority'!$A$1,0)=\"\",\"N/A\",IF(P24=\"*\",\"\",OFFSET('DATA CLA DIS'!$M$5,'Select an authority'!$A$1,0)))","v":0.22666666666666666}]
[]
["Comparator Authorities:"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2, B3,0)","v":"South Ayrshire"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$5,$B3,0)=\"\",\"N/A\",IF($B3<33,OFFSET('DATA CLA DIS'!$B$5,$B3,0),\"\"))","v":384},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",OFFSET('DATA CLA DIS'!$C$5,$B3,0)))","v":84},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",OFFSET('DATA CLA DIS'!$D$5,$B3,0)))","v":0.22},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$5,$B3,0)=\"\",\"N/A\",IF($B3<33,OFFSET('DATA CLA DIS'!$E$5,$B3,0),\"\"))","v":370},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",OFFSET('DATA CLA DIS'!$F$5,$B3,0)))","v":73},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",OFFSET('DATA CLA DIS'!$G$5,$B3,0)))","v":0.19729729729729731},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$5,$B3,0)=\"\",\"N/A\",IF($B3<33,OFFSET('DATA CLA DIS'!$H$5,$B3,0),\"\"))","v":355},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",OFFSET('DATA CLA DIS'!$I$5,$B3,0)))","v":68},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",OFFSET('DATA CLA DIS'!$J$5,$B3,0)))","v":0.19154929577464788},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$5,$B3,0)=\"\",\"N/A\",IF($B3<33,OFFSET('DATA CLA DIS'!$K$5,$B3,0),\"\"))","v":345},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",OFFSET('DATA CLA DIS'!$L$5,$B3,0)))","v":58},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",OFFSET('DATA CLA DIS'!$M$5,$B3,0)))","v":0.1681159420289855}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B4,0)","v":"Dumfries and Galloway"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$5,$B4,0)=\"\",\"N/A\",IF($B4<33,OFFSET('DATA CLA DIS'!$B$5,$B4,0),\"\"))","v":393},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",OFFSET('DATA CLA DIS'!$C$5,$B4,0)))","v":23},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",OFFSET('DATA CLA DIS'!$D$5,$B4,0)))","v":0.06},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$5,$B4,0)=\"\",\"N/A\",IF($B4<33,OFFSET('DATA CLA DIS'!$E$5,$B4,0),\"\"))","v":382},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",OFFSET('DATA CLA DIS'!$F$5,$B4,0)))","v":11},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",OFFSET('DATA CLA DIS'!$G$5,$B4,0)))","v":2.8795811518324606E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$5,$B4,0)=\"\",\"N/A\",IF($B4<33,OFFSET('DATA CLA DIS'!$H$5,$B4,0),\"\"))","v":439},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",OFFSET('DATA CLA DIS'!$I$5,$B4,0)))","v":13},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",OFFSET('DATA CLA DIS'!$J$5,$B4,0)))","v":2.9612756264236904E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$5,$B4,0)=\"\",\"N/A\",IF($B4<33,OFFSET('DATA CLA DIS'!$K$5,$B4,0),\"\"))","v":395},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",OFFSET('DATA CLA DIS'!$L$5,$B4,0)))","v":11},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",OFFSET('DATA CLA DIS'!$M$5,$B4,0)))","v":2.7848101265822784E-2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B5,0)","v":"Scottish Borders"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$5,$B5,0)=\"\",\"N/A\",IF($B5<33,OFFSET('DATA CLA DIS'!$B$5,$B5,0),\"\"))","v":218},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",OFFSET('DATA CLA DIS'!$C$5,$B5,0)))","v":17},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",OFFSET('DATA CLA DIS'!$D$5,$B5,0)))","v":0.08},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$5,$B5,0)=\"\",\"N/A\",IF($B5<33,OFFSET('DATA CLA DIS'!$E$5,$B5,0),\"\"))","v":228},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",OFFSET('DATA CLA DIS'!$F$5,$B5,0)))","v":14},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",OFFSET('DATA CLA DIS'!$G$5,$B5,0)))","v":6.1403508771929821E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$5,$B5,0)=\"\",\"N/A\",IF($B5<33,OFFSET('DATA CLA DIS'!$H$5,$B5,0),\"\"))","v":205},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",OFFSET('DATA CLA DIS'!$I$5,$B5,0)))","v":14},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",OFFSET('DATA CLA DIS'!$J$5,$B5,0)))","v":6.8292682926829273E-2},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$5,$B5,0)=\"\",\"N/A\",IF($B5<33,OFFSET('DATA CLA DIS'!$K$5,$B5,0),\"\"))","v":195},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",OFFSET('DATA CLA DIS'!$L$5,$B5,0)))","v":15},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",OFFSET('DATA CLA DIS'!$M$5,$B5,0)))","v":7.6923076923076927E-2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B6,0)","v":"Highland"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$5,$B6,0)=\"\",\"N/A\",IF($B6<33,OFFSET('DATA CLA DIS'!$B$5,$B6,0),\"\"))","v":440},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",OFFSET('DATA CLA DIS'!$C$5,$B6,0)))","v":83},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",OFFSET('DATA CLA DIS'!$D$5,$B6,0)))","v":0.19},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$5,$B6,0)=\"\",\"N/A\",IF($B6<33,OFFSET('DATA CLA DIS'!$E$5,$B6,0),\"\"))","v":487},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",OFFSET('DATA CLA DIS'!$F$5,$B6,0)))","v":58},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",OFFSET('DATA CLA DIS'!$G$5,$B6,0)))","v":0.11909650924024641},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$5,$B6,0)=\"\",\"N/A\",IF($B6<33,OFFSET('DATA CLA DIS'!$H$5,$B6,0),\"\"))","v":521},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",OFFSET('DATA CLA DIS'!$I$5,$B6,0)))","v":71},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",OFFSET('DATA CLA DIS'!$J$5,$B6,0)))","v":0.1362763915547025},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$5,$B6,0)=\"\",\"N/A\",IF($B6<33,OFFSET('DATA CLA DIS'!$K$5,$B6,0),\"\"))","v":483},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",OFFSET('DATA CLA DIS'!$L$5,$B6,0)))","v":37},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",OFFSET('DATA CLA DIS'!$M$5,$B6,0)))","v":7.6604554865424432E-2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B7,0)","v":"Angus"},{"$f":"IF(OFFSET('DATA CLA DIS'!$B$5,$B7,0)=\"\",\"N/A\",IF($B7<33,OFFSET('DATA CLA DIS'!$B$5,$B7,0),\"\"))","v":238},{"$f":"IF(OFFSET('DATA CLA DIS'!$C$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",OFFSET('DATA CLA DIS'!$C$5,$B7,0)))","v":46},{"$f":"IF(OFFSET('DATA CLA DIS'!$D$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",OFFSET('DATA CLA DIS'!$D$5,$B7,0)))","v":0.19},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$E$5,$B7,0)=\"\",\"N/A\",IF($B7<33,OFFSET('DATA CLA DIS'!$E$5,$B7,0),\"\"))","v":255},{"$f":"IF(OFFSET('DATA CLA DIS'!$F$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",OFFSET('DATA CLA DIS'!$F$5,$B7,0)))","v":64},{"$f":"IF(OFFSET('DATA CLA DIS'!$G$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",OFFSET('DATA CLA DIS'!$G$5,$B7,0)))","v":0.25098039215686274},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$H$5,$B7,0)=\"\",\"N/A\",IF($B7<33,OFFSET('DATA CLA DIS'!$H$5,$B7,0),\"\"))","v":251},{"$f":"IF(OFFSET('DATA CLA DIS'!$I$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",OFFSET('DATA CLA DIS'!$I$5,$B7,0)))","v":58},{"$f":"IF(OFFSET('DATA CLA DIS'!$J$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",OFFSET('DATA CLA DIS'!$J$5,$B7,0)))","v":0.23107569721115537},null,{"$f":"IF(OFFSET('DATA CLA DIS'!$K$5,$B7,0)=\"\",\"N/A\",IF($B7<33,OFFSET('DATA CLA DIS'!$K$5,$B7,0),\"\"))","v":244},{"$f":"IF(OFFSET('DATA CLA DIS'!$L$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",OFFSET('DATA CLA DIS'!$L$5,$B7,0)))","v":46},{"$f":"IF(OFFSET('DATA CLA DIS'!$M$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",OFFSET('DATA CLA DIS'!$M$5,$B7,0)))","v":0.18852459016393441}]
[]
[null,"Comparator authorities",{"$f":"SUM(C27:C31)","v":1673},{"$f":"SUM(D27:D31)","v":253},{"$f":"IF(D33=0,0,D33/(SUMIF(D27,\">0\",C27)+SUMIF(D28,\">0\",C28)+SUMIF(D29,\">0\",C29)+SUMIF(D30,\">0\",C30)+SUMIF(D31,\">0\",C31)))","v":0.15122534369396293},null,{"$f":"SUM(G27:G31)","v":1722},{"$f":"SUM(H27:H31)","v":220},{"$f":"IF(H33=0,0,H33/(SUMIF(H27,\">0\",G27)+SUMIF(H28,\">0\",G28)+SUMIF(H29,\">0\",G29)+SUMIF(H30,\">0\",G30)+SUMIF(H31,\">0\",G31)))","v":0.12775842044134728},null,{"$f":"SUM(K27:K31)","v":1771},{"$f":"SUM(L27:L31)","v":224},{"$f":"IF(L33=0,0,L33/(SUMIF(L27,\">0\",K27)+SUMIF(L28,\">0\",K28)+SUMIF(L29,\">0\",K29)+SUMIF(L30,\">0\",K30)+SUMIF(L31,\">0\",K31)))","v":0.12648221343873517},null,{"$f":"SUM(O27:O31)","v":1662},{"$f":"SUM(P27:P31)","v":167},{"$f":"IF(P33=0,0,P33/(SUMIF(P27,\">0\",O27)+SUMIF(P28,\">0\",O28)+SUMIF(P29,\">0\",O29)+SUMIF(P30,\">0\",O30)+SUMIF(P31,\">0\",O31)))","v":0.10048134777376655}]
[]
[null,"Scotland",{"$f":"'DATA CLA DIS'!B38","v":15317},{"$f":"'DATA CLA DIS'!C38","v":1797},{"$f":"'DATA CLA DIS'!D38","v":0.12},null,{"$f":"'DATA CLA DIS'!E38","v":14897},{"$f":"'DATA CLA DIS'!F38","v":1636},{"$f":"'DATA CLA DIS'!G38","v":0.10982076928240585},null,{"$f":"'DATA CLA DIS'!H38","v":14554},{"$f":"'DATA CLA DIS'!I38","v":1523},{"$f":"'DATA CLA DIS'!J38","v":0.10464477119692181},null,{"$f":"'DATA CLA DIS'!K38","v":14262},{"$f":"'DATA CLA DIS'!L38","v":1535},{"$f":"'DATA CLA DIS'!M38","v":0.10762866358154537}]
[]
["Notes"]
[{"$f":"IF('DATA CLA Acc'!A41=\"\",\"\",'DATA CLA Acc'!A41)","v":"Cells containing * represent numbers that are supressed to maintain confidentiality."}]
[{"$f":"IF('DATA CLA Acc'!A42=\"\",\"\",'DATA CLA Acc'!A42)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M24-I24","v":-1.1083413231064237E-2},{"$f":"Q24-M24","v":3.2035794183445182E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M33-I33","v":-1.2762070026121064E-3},{"$f":"Q33-M33","v":-2.600086566496862E-2},null,{"$f":"M24-M33","v":6.8148659044486304E-2},{"$f":"Q24-Q33","v":0.12618531889290011}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M35-I35","v":-5.1759980854840376E-3},{"$f":"Q35-M35","v":2.9838923846235571E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M24-M35","v":8.9986101286299663E-2},{"$f":"Q24-Q35","v":0.11903800308512129}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P41<-0.02,\"less than\",IF(P41>0.02,\"greater than\",\"similar to\"))","v":"greater than"},{"$f":"IF(Q41<-0.02,\"less than\",IF(Q41>0.02,\"greater than\",\"similar to\"))","v":"greater than"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M40<0,\"a decrease of \",IF(M40>=0,\"an increase of \"))","v":"a decrease of "},"an increase of "]
[null,null,null,null,null,null,null,null,null,null,null,null,"a decrease of ","a decrease of "]
[null,null,null,null,null,null,null,null,null,null,null,null,"a decrease of ","an increase of "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P43<-0.02,\"less than\",IF(P43>0.02,\"greater than\",\"similar to\"))","v":"greater than"},{"$f":"IF(Q43<-0.02,\"less than\",IF(Q43>0.02,\"greater than\",\"similar to\"))","v":"greater than"}]

{"sheet":"CLA 3placements","index":4,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[11,1,12,3],[13,1,15,3],[16,1,17,3]]}
[{"$f":"'DATA CLA 3P'!A1","v":"Children Looked After: Number with 3 or more placements during the past year for those looked at 31 July 2016 to 2019"}]
[null,null,"select comparators:"]
[null,{"$f":"J3","v":28},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":28},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,2,0)","v":28}]
[null,{"$f":"J4","v":7},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,3,0)","v":7}]
[null,{"$f":"J5","v":26},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":26},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,4,0)","v":26}]
[null,{"$f":"J6","v":16},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":16},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,5,0)","v":16}]
[null,{"$f":"J7","v":3},null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Select an authority'!$A$1,'REF CAs'!$A$1:$F$32,6,0)","v":3}]
[]
[]
[]
[]
[null,{"$f":"IF($P$22=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(U22=\"N/A\",\"[text statement not available due to data being unavailable]\",IF($P$22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(U22=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  In \"&$S$20&\", \"&ROUND(100*$U$22,0)&\"% of children looked after in \"&$B$22&\" have had 3 or more placements during the past year, \"&T40&ROUND(SQRT((100*S40)^2),1)&\" %-points over the previous year.\"))))","v":"*  In 2019, 6% of children looked after in Argyll & Bute have had 3 or more placements during the past year, an increase of 2 %-points over the previous year."}]
[]
[null,{"$f":"IF($U$31=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(U33=\"N/A\",\"[text statement not available due to data being unavailable]\",IF($U$31=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",IF(U33=\"*\",\"[text statement not available due to suppression of data for confidentiality]\",\"*  This compares with \"&$T$41&\" of \"&ROUND(SQRT((100*$S$41)^2),1)&\"%-points for comparator authorities, and \"&$T$42&\" of \"&ROUND(SQRT((100*S42)^2),1)&\"%-points for Scotland as a whole.\"))))","v":"*  This compares with a decrease of  of 2.1%-points for comparator authorities, and an increase of  of 0.3%-points for Scotland as a whole."}]
[]
[]
[null,{"$f":"IF(U22=\"N/A\",\"[text statement not available due to data being unavailable]\",IF(U22=\"*\",\"[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*U22,0)&\"%) is \"&T37&\" the comparator average of \"&ROUND(100*U31,0)&\"% and \"&T38&\" the  Scotland average of \"&ROUND(100*U33,0)&\"%\"))","v":"*   The percentage of children who have had 3 or more placements during the past year (6%) is similar to the comparator average of 6% and similar to the  Scotland average of 5%"}]
[]
[]
[null,null,null,{"$f":"'DATA CLA 3P'!C3","v":2016},null,null,null,null,{"$f":"'DATA CLA 3P'!G3","v":2017},null,null,null,null,{"$f":"'DATA CLA 3P'!K3","v":2018},null,null,null,null,{"$f":"'DATA CLA 3P'!O3","v":2019}]
[null,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,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,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,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"}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,'Select an authority'!$A$1,0)","v":"Argyll & Bute"},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":163},{"$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":7},{"$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":4.2944785276073622E-2},null,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":175},{"$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":14},{"$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":0.08},null,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":149},{"$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":6},{"$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":4.0268456375838924E-2},null,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":150},{"$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":9},{"$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":0.06}]
[]
["Comparator Authorities:"]
[null,{"$f":"OFFSET('REF EA Name'!$B$2, B3,0)","v":"South Ayrshire"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$B3,0))))","v":384},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$B3,0))))","v":8},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$B3,0))))","v":2.0833333333333332E-2},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$B3,0))))","v":370},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$B3,0))))","v":23},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$B3,0))))","v":6.2162162162162166E-2},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$B3,0))))","v":355},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$B3,0))))","v":24},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$B3,0))))","v":6.7605633802816895E-2},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$B3,0))))","v":345},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$B3,0))))","v":16},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$B3,0)=\"\",\"N/A\",IF($B3=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$B3,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$B3,0))))","v":4.6376811594202899E-2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B4,0)","v":"Dumfries and Galloway"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$B4,0))))","v":393},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$B4,0))))","v":35},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$B4,0))))","v":8.9058524173027995E-2},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$B4,0))))","v":382},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$B4,0))))","v":26},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$B4,0))))","v":6.8062827225130892E-2},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$B4,0))))","v":439},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$B4,0))))","v":27},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$B4,0))))","v":6.1503416856492028E-2},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$B4,0))))","v":395},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$B4,0))))","v":19},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$B4,0)=\"\",\"N/A\",IF($B4=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$B4,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$B4,0))))","v":4.810126582278481E-2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B5,0)","v":"Scottish Borders"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$B5,0))))","v":218},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$B5,0))))","v":"*"},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$B5,0))))","v":"*"},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$B5,0))))","v":228},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$B5,0))))","v":"*"},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$B5,0))))","v":"*"},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$B5,0))))","v":205},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$B5,0))))","v":"*"},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$B5,0))))","v":"*"},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$B5,0))))","v":195},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$B5,0))))","v":5},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$B5,0)=\"\",\"N/A\",IF($B5=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$B5,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$B5,0))))","v":2.564102564102564E-2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B6,0)","v":"Highland"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$B6,0))))","v":440},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$B6,0))))","v":66},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$B6,0))))","v":0.15},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$B6,0))))","v":487},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$B6,0))))","v":67},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$B6,0))))","v":0.1375770020533881},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$B6,0))))","v":521},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$B6,0))))","v":49},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$B6,0))))","v":9.4049904030710174E-2},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$B6,0))))","v":483},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$B6,0))))","v":46},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$B6,0)=\"\",\"N/A\",IF($B6=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$B6,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$B6,0))))","v":9.5238095238095233E-2}]
[null,{"$f":"OFFSET('REF EA Name'!$B$2,B7,0)","v":"Angus"},null,{"$f":"IF(OFFSET('DATA CLA 3P'!$C$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$C$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$C$5,$B7,0))))","v":238},{"$f":"IF(OFFSET('DATA CLA 3P'!$D$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$D$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$D$5,$B7,0))))","v":24},{"$f":"IF(OFFSET('DATA CLA 3P'!$E$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$E$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$E$5,$B7,0))))","v":0.10084033613445378},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$G$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$G$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$G$5,$B7,0))))","v":255},{"$f":"IF(OFFSET('DATA CLA 3P'!$H$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$H$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$H$5,$B7,0))))","v":19},{"$f":"IF(OFFSET('DATA CLA 3P'!$I$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$I$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$I$5,$B7,0))))","v":7.4509803921568626E-2},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$K$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$K$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$K$5,$B7,0))))","v":251},{"$f":"IF(OFFSET('DATA CLA 3P'!$L$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$L$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$L$5,$B7,0))))","v":31},{"$f":"IF(OFFSET('DATA CLA 3P'!$M$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$M$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$M$5,$B7,0))))","v":0.12350597609561753},null,null,{"$f":"IF(OFFSET('DATA CLA 3P'!$O$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$O$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$O$5,$B7,0))))","v":244},{"$f":"IF(OFFSET('DATA CLA 3P'!$P$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$P$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$P$5,$B7,0))))","v":18},{"$f":"IF(OFFSET('DATA CLA 3P'!$Q$5,$B7,0)=\"\",\"N/A\",IF($B7=33,\"\",IF(OFFSET('DATA CLA 3P'!$Q$5,$B7,0)=0,\"0\",OFFSET('DATA CLA 3P'!$Q$5,$B7,0))))","v":7.3770491803278687E-2}]
[]
[null,"Comparator authorities",null,{"$f":"SUM(D25:D29)","v":1673},{"$f":"SUM(E25:E29)","v":133},{"$f":"IF(E31=0,0,E31/(SUMIF(E25,\">0\",$D25)+SUMIF(E26,\">0\",$D26)+SUMIF(E27,\">0\",$D27)+SUMIF(E28,\">0\",$D28)+SUMIF(E29,\">0\",$D29)))","v":9.1408934707903775E-2},null,null,{"$f":"SUM(I25:I29)","v":1722},{"$f":"SUM(J25:J29)","v":135},{"$f":"IF(J31=0,0,J31/(SUMIF(J25,\">0\",$I25)+SUMIF(J26,\">0\",$I26)+SUMIF(J27,\">0\",$I27)+SUMIF(J28,\">0\",$I28)+SUMIF(J29,\">0\",$I29)))","v":9.036144578313253E-2},null,null,{"$f":"SUM(N25:N29)","v":1771},{"$f":"SUM(O25:O29)","v":131},{"$f":"IF(O31=0,0,O31/(SUMIF(O25,\">0\",$N25)+SUMIF(O26,\">0\",$N26)+SUMIF(O27,\">0\",$N27)+SUMIF(O28,\">0\",$N28)+SUMIF(O29,\">0\",$N29)))","v":8.365261813537675E-2},null,null,{"$f":"SUM(S25:S29)","v":1662},{"$f":"SUM(T25:T29)","v":104},{"$f":"IF(T31=0,0,T31/(SUMIF(T25,\">0\",$S25)+SUMIF(T26,\">0\",$S26)+SUMIF(T27,\">0\",$S27)+SUMIF(T28,\">0\",$S28)+SUMIF(T29,\">0\",$S29)))","v":6.2575210589651029E-2}]
[]
[null,"Scotland",null,{"$f":"'DATA CLA 3P'!C$38","v":15317},{"$f":"'DATA CLA 3P'!D$38","v":833},{"$f":"'DATA CLA 3P'!E$38","v":5.4384017758046618E-2},null,null,{"$f":"'DATA CLA 3P'!G$38","v":14897},{"$f":"'DATA CLA 3P'!H$38","v":815},{"$f":"'DATA CLA 3P'!I$38","v":5.4709001812445458E-2},null,null,{"$f":"'DATA CLA 3P'!K$38","v":14554},{"$f":"'DATA CLA 3P'!L$38","v":718},{"$f":"'DATA CLA 3P'!M$38","v":4.9333516559021573E-2},null,null,{"$f":"'DATA CLA 3P'!$O$38","v":14262},{"$f":"'DATA CLA 3P'!$P$38","v":742},{"$f":"'DATA CLA 3P'!$Q$38","v":5.2026363763847991E-2}]
[]
["Notes"]
[{"$f":"IF('DATA CLA 3P'!A41=\"\",\"\",'DATA CLA 3P'!A41)","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,null,null,null,null,{"$f":"K22-F22","v":3.705521472392638E-2},{"$f":"IF(O36<0,\"a decrease of \",IF(O36>=0,\"an increase of \"))","v":"an increase of "}]
[{"$f":"IF('DATA CLA 3P'!A43=\"\",\"\",'DATA CLA 3P'!A43)","v":"Source: Scottish Government CLAS Returns"},null,null,null,null,{"$f":"F22-F31","v":-4.8464149431830153E-2},{"$f":"IF(F37<-0.05,\"less than\",IF(F37>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,null,{"$f":"K22-K31","v":-1.0361445783132528E-2},{"$f":"IF(K37<-0.05,\"less than\",IF(K37>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,{"$f":"K31-F31","v":-1.0474889247712449E-3},{"$f":"IF(O37<0,\"a decrease of \",IF(O37>=0,\"an increase of \"))","v":"a decrease of "},null,null,{"$f":"U22-U31","v":-2.5752105896510308E-3},{"$f":"IF(S37<-0.05,\"less than\",IF(S37>0.05,\"greater than\",\"similar to\"))","v":"similar to"}]
[null,null,null,null,null,{"$f":"F22-F33","v":-1.1439232481972997E-2},{"$f":"IF(F38<-0.05,\"less than\",IF(F38>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,null,{"$f":"K22-K33","v":2.5290998187554543E-2},{"$f":"IF(K38<-0.05,\"less than\",IF(K38>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,null,null,null,null,{"$f":"U22-U33","v":7.9736362361520069E-3},{"$f":"IF(S38<-0.05,\"less than\",IF(S38>0.05,\"greater than\",\"similar to\"))","v":"similar to"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"P22-P31","v":-4.3384161759537826E-2},{"$f":"IF(K39<-0.05,\"less than\",IF(K39>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,{"$f":"K33-F33","v":3.2498405439883998E-4},{"$f":"IF(O39<0,\"a decrease of \",IF(O39>=0,\"an increase of \"))","v":"an increase of "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"P22-P33","v":-9.0650601831826494E-3},{"$f":"IF(K40<-0.05,\"less than\",IF(K40>0.05,\"greater than\",\"similar to\"))","v":"similar to"},null,null,null,null,null,null,{"$f":"U22-P22","v":1.9731543624161074E-2},{"$f":"IF(S40<0,\"a decrease of \",IF(S40>=0,\"an increase of \"))","v":"an increase of "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P22-K22","v":-3.9731543624161078E-2},{"$f":"IF(O41<0,\"a decrease of \",IF(O41>=0,\"an increase of \"))","v":"a decrease of "},null,null,{"$f":"U31-P31","v":-2.1077407545725721E-2},{"$f":"IF(S41<0,\"a decrease of \",IF(S41>=0,\"an increase of \"))","v":"a decrease of "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P31-K31","v":-6.7088276477557801E-3},{"$f":"IF(O42<0,\"a decrease of \",IF(O42>=0,\"an increase of \"))","v":"a decrease of "},null,null,{"$f":"U33-P33","v":2.6928472048264179E-3},{"$f":"IF(S42<0,\"a decrease of \",IF(S42>=0,\"an increase of \"))","v":"an increase of "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P33-K33","v":-5.3754852534238853E-3},{"$f":"IF(O43<0,\"a decrease of \",IF(O43>=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":false,"merged":[[2,9,2,13]]}
["Children Looked After: Number Looked After at 31 July 2013 to 2019"]
[]
["Total number of children looked after at 31 July 2013-2019",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 2013-2019 - rate per 1000, 0-17 population"]
[]
["Council",2013,2014,2015,2016,2017,2018,2019,null,2013,2014,2015,2016,2017,2018,2019,null,"Council",2013,2014,2015,2016,2017,2018,2019]
["Aberdeen City",606,577,549,553,590,549,542,null,37060,37182,37519,37775,38001,38418,38966,null,"Aberdeen City",{"$f":"IFERROR(B6*1000/J6,\"*\")","v":16.351861845655694},{"$f":"IFERROR(C6*1000/K6,\"*\")","v":15.518261524393523},{"$f":"IFERROR(D6*1000/L6,\"*\")","v":14.63258615634745},{"$f":"IFERROR(E6*1000/M6,\"*\")","v":14.639311714096625},{"$f":"IFERROR(F6*1000/N6,\"*\")","v":15.525907212968081},{"$f":"IFERROR(G6*1000/O6,\"*\")","v":14.290176479775106},{"$f":"IFERROR(H6*1000/P6,\"*\")","v":13.909562182415439}]
["Aberdeenshire",425,403,411,411,395,409,403,null,54048,54291,54806,54944,54908,54594,54634,null,"Aberdeenshire",{"$f":"IFERROR(B7*1000/J7,\"*\")","v":7.8633806986382471},7.4229614484905415,7.4991789220158376,7.4803436225975535,7.1938515334741746,7.4916657508151081,7.3763590438188675]
["Angus",253,272,261,238,255,251,244,null,22800,22608,22523,22339,22034,21759,21588,null,"Angus",11.096491228070175,12.031139419674451,11.58815433112818,10.654013160839787,11.573023509122265,11.535456592674295,11.302575504910136]
["Argyll & Bute",200,175,167,163,175,149,150,null,16175,15932,15639,15323,15141,14742,14566,null,"Argyll & Bute",12.364760432766616,10.984182776801406,10.678432124816165,10.637603602427722,11.55802126675913,10.10717677384344,10.297954139777564]
["City of Edinburgh",1402,1415,1419,1368,1349,1309,1234,null,82479,83504,84213,85026,86107,86866,87481,null,"City of Edinburgh",16.99826622534221,16.945296033722936,16.850130027430446,16.089196245854211,15.666554403242477,15.069187023691663,14.105920142659549]
["Clackmannanshire",183,184,198,233,213,211,185,null,10480,10443,10307,10246,10258,10126,10027,null,"Clackmannanshire",17.461832061068701,17.619458010150339,19.210245464247599,22.740581690415773,20.764281536361864,20.837448153268813,18.450184501845019]
["Dumfries and Galloway",375,387,409,393,382,439,395,null,28333,27802,27399,27034,26707,26328,26168,null,"Dumfries and Galloway",13.235449828821515,13.919861880440257,14.927552100441622,14.537249389657468,14.303366158684989,16.674263141902156,15.094772240904922]
["Dundee City",696,617,585,592,555,519,463,null,26918,27074,26992,26872,26729,26743,26763,null,"Dundee City",25.856304331673972,22.789392036640319,21.673088322465915,22.030366180410837,20.76396423360395,19.406947612459334,17.300003736501885]
["East Ayrshire",521,500,461,463,386,401,375,null,24541,24307,24109,24014,23930,23671,23559,null,"East Ayrshire",21.229778737622755,20.570206113465257,19.121489900037332,19.280419755142834,16.130380275804431,16.940560179122134,15.91748376416656]
["East Dunbartonshire",148,154,173,164,162,140,149,null,21280,21025,21066,21220,21353,21627,21718,null,"East Dunbartonshire",6.9548872180451129,7.3246135552913199,8.2122851988986998,7.7285579641847315,7.5867559593499738,6.4733897443011053,6.8606685698498939]
["East Lothian",199,209,210,229,242,245,246,null,21281,21225,21271,21263,21329,21590,21828,null,"East Lothian",9.351064329683755,9.846878680800943,9.8725964928776264,10.769881954568969,11.346054667354306,11.347846225104215,11.269928532160527]
["East Renfrewshire",187,175,146,130,117,110,102,null,20355,20512,20761,20878,21099,21655,21828,null,"East Renfrewshire",9.1869319577499393,8.5315912636505455,7.0324165502625116,6.2266500622665006,5.5452865064695009,5.0796582775340564,4.6728971962616823]
["Falkirk",375,370,364,373,381,368,344,null,32153,31977,31916,31860,31846,31519,31432,null,"Falkirk",11.66298634653065,11.570816524376896,11.404937962150646,11.707470182046453,11.963825912202475,11.675497319077381,10.944260626113515]
["Fife",872,933,1023,981,942,941,935,null,73047,72720,72392,72332,72326,72088,72048,null,"Fife",11.937519679110709,12.830033003300331,14.131395734335285,13.562461980866006,13.024361916876366,13.053490178670513,12.977459471463469]
["Glasgow City",3674,3504,3410,3294,2827,2645,2523,null,108599,108959,109067,109457,110239,111161,111598,null,"Glasgow City",33.830882420648443,32.158885452326103,31.265185619848349,30.094009519720071,25.644281969176063,23.794316351957971,22.607932041792864]
["Highland",462,447,437,440,487,521,483,null,46544,46070,45603,45470,45284,44427,44039,null,"Highland",9.9260914403575118,9.7026264380290854,9.5827028923535735,9.6767099186276671,10.754350322409682,11.727102887883495,10.967551488453417]
["Inverclyde",276,237,209,207,218,199,205,null,15394,15233,14993,14759,14638,14192,14126,null,"Inverclyde",17.929063271404445,15.558327315696186,13.939838591342626,14.025340470221559,14.892744910506901,14.021984216459977,14.512246920571995]
["Midlothian",297,309,255,250,259,233,218,null,17933,18053,18400,18677,18958,19500,19834,null,"Midlothian",16.561646127251436,17.116268764194317,13.858695652173912,13.385447341650158,13.661778668635932,11.948717948717949,10.991227185640819]
["Moray",221,213,209,213,215,222,210,null,19178,19133,19080,18885,18840,18312,18293,null,"Moray",11.523620815517781,11.132598128887263,10.953878406708595,11.278792692613186,11.411889596602972,12.123197903014416,11.479801016782377]
["Na h-Eileanan Siar",61,49,47,37,47,41,39,null,5228,5138,5035,4932,4878,4842,4792,null,"Na h-Eileanan Siar",11.667941851568477,9.5367847411444142,9.3346573982125118,7.5020275750202758,9.6350963509635097,8.4675753820735231,8.1385642737896493]
["North Ayrshire",587,601,639,603,585,563,550,null,27736,27152,26775,26383,26157,25682,25314,null,"North Ayrshire",21.16383040092299,22.134649381261049,23.865546218487395,22.855626729333284,22.364950108957448,21.921968694026944,21.727107529430356]
["North Lanarkshire",747,706,697,765,773,754,850,null,72827,72531,72072,71474,71393,70636,70519,null,"North Lanarkshire",10.257184835294602,9.7337690091133453,9.6708846708846714,10.703192769398662,10.827392041236536,10.674443626479416,12.05348913058892]
["Orkney Islands",27,39,34,28,38,31,37,null,4129,4073,4018,3967,3984,3988,4024,null,"Orkney Islands",6.5391135868248966,9.5752516572550945,8.4619213539074174,7.0582304008066545,9.5381526104417667,7.7733199598796388,9.1948310139165006]
["Perth and Kinross",237,246,255,286,281,280,282,null,28565,28314,28187,28240,28082,27747,27656,null,"Perth and Kinross",8.2968667950288815,8.6882814155541421,9.046723666938659,10.127478753541077,10.006409799871804,10.091181028579665,10.196702343072028]
["Renfrewshire",779,713,682,681,659,656,629,null,34450,34295,34135,33813,33865,33904,33889,null,"Renfrewshire",22.612481857764877,20.790202653448024,19.97949318880914,20.140182769940555,19.459619075741916,19.348749410099103,18.560594883295465]
["Scottish Borders",184,179,201,218,228,205,195,null,21829,21728,21671,21487,21507,21434,21349,null,"Scottish Borders",8.4291538778688899,8.2382179675994109,9.2750680633104157,10.145669474566017,10.601199609429488,9.5642437249230188,9.1339172794978687]
["Shetland Islands",31,31,35,29,32,29,34,null,5020,4947,4884,4826,4801,4689,4691,null,"Shetland Islands",6.1752988047808763,6.2664240954113604,7.1662571662571661,6.0091172813924576,6.6652780670693605,6.1846875666453398,7.2479215519079085]
["South Ayrshire",365,343,330,384,370,355,345,null,20857,20677,20480,20357,20196,19881,19796,null,"South Ayrshire",17.500119863834684,16.5884799535716,16.11328125,18.86329026870364,18.320459496930084,17.856244655701424,17.427763184481712]
["South Lanarkshire",597,595,548,563,549,655,725,null,62812,62539,62204,62212,62097,61941,62118,null,"South Lanarkshire",9.5045532700757818,9.5140632245478827,8.8097228474053111,9.0497010223108081,8.8410068119232808,10.574579034888039,11.671335200746965]
["Stirling",246,233,216,216,245,236,238,null,18259,18036,17916,17850,17784,17551,17450,null,"Stirling",13.472807930335724,12.918607229984476,12.056262558606832,12.100840336134453,13.776428250112462,13.446527263403794,13.638968481375358]
["West Dunbartonshire",354,369,386,363,429,445,505,null,18109,17896,17763,17712,17716,17500,17457,null,"West Dunbartonshire",19.548290905074825,20.619132767098794,21.73056353093509,20.494579945799458,24.215398509821629,25.428571428571427,28.928223635217964]
["West Lothian",445,415,434,449,511,443,427,null,39773,39547,39502,39469,39574,39685,39611,null,"West Lothian",11.188494707464864,10.493842769363036,10.986785479216243,11.376016620638982,12.912518320109163,11.162907899710218,10.779833884527026]
["SCOTLAND",16032,15600,15400,15317,14897,14554,14262,null,1038192,1034923,1032698,1031096,1031761,{"$f":"SUM(O6:O37)","v":1028798},{"$f":"SUM(P6:P37)","v":1029162},null,"SCOTLAND",15.442230338896852,15.073585184598274,14.912394523858863,14.855066841496814,14.438421301057124,14.146606039280792,13.857876602517388]
["Notes:"]
["Population figures source: NRS mid-year population estimates for 2013-2019."]
["Source: Scottish Government CLAS Returns"]

{"sheet":"DATA CLA Acc","index":6,"n_rows":51,"n_cols":36,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,33,3,34],[3,6,3,7],[3,15,3,16],[3,24,3,25]]}
["Children Looked After: Type of Accommodation at 31 July 2016 to 2019"]
[]
[null,2016,null,null,null,null,null,null,null,null,2017,null,null,null,null,null,null,null,null,2018,null,null,null,null,null,null,null,null,2019]
[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",115,119,109,138,6,22,44,553,null,108,112,113,175,14,23,45,590,null,75,115,94,182,21,19,43,549,null,97,98,81,193,22,16,35,542]
["Aberdeenshire",109,63,150,20,10,28,31,411,null,80,66,160,22,12,23,32,395,null,81,76,142,26,19,29,36,409,null,68,75,139,36,14,31,40,403]
["Angus",73,36,92,6,10,7,14,238,null,65,63,95,7,5,6,14,255,null,65,63,82,13,7,5,16,251,null,61,65,80,7,6,8,17,244]
["Argyll & Bute",48,44,46,"*","*",10,10,163,null,52,58,37,"*","*",13,9,175,null,40,45,34,"*","*",18,9,149,null,46,42,32,"*","*",15,10,150]
["City of Edinburgh",350,330,342,224,32,55,35,1368,null,335,301,367,215,22,68,41,1349,null,353,262,347,216,25,63,43,1309,null,337,225,349,174,43,59,47,1234]
["Clackmannanshire",83,37,36,53,"*","*",20,233,null,62,43,25,55,"*","*",19,213,null,72,56,19,41,10,"*",9,211,null,43,59,24,41,5,"*",10,185]
["Dumfries and Galloway",124,116,114,"*","*",8,24,393,null,121,128,107,"*","*","*",18,382,null,168,113,124,"*",5,7,20,439,null,139,120,105,5,"*","*",19,395]
["Dundee City",126,146,159,79,25,33,24,592,null,109,121,82,162,20,34,27,555,null,105,106,161,79,6,38,24,519,null,87,97,139,73,13,32,22,463]
["East Ayrshire",128,133,112,40,12,16,22,463,null,114,98,92,38,7,15,22,386,null,124,101,96,26,18,15,21,401,null,114,90,104,25,10,17,15,375]
["East Dunbartonshire",45,55,11,27,"*",18,"*",164,null,33,55,13,36,0,19,6,162,null,28,42,19,28,"*",16,6,140,null,39,44,21,23,"*",17,5,149]
["East Lothian",73,44,77,7,10,9,9,229,null,69,51,79,16,"*","*",17,242,null,77,43,79,12,"*",12,20,245,null,62,50,77,11,"*",12,31,246]
["East Renfrewshire",65,33,25,0,"*","*",5,130,null,44,33,22,5,"*","*",9,117,null,41,31,22,8,"*","*",7,110,null,50,24,17,6,"*","*","*",102]
["Falkirk",123,45,107,40,10,9,39,373,null,120,50,95,42,14,9,51,381,null,124,49,87,38,7,10,53,368,null,113,49,76,38,7,9,52,344]
["Fife",190,204,260,217,0,66,44,981,null,175,173,234,233,"*",71,"*",942,null,178,167,225,240,"*",65,66,941,null,165,182,207,247,"*",64,70,935]
["Glasgow City",544,1356,777,323,7,145,142,3294,null,491,1152,665,283,"*",134,"*",2827,null,462,1122,590,245,"*",149,77,2645,null,399,1163,550,214,"*",136,59,2523]
["Highland",128,76,134,9,20,19,54,440,null,129,93,119,38,23,23,62,487,null,153,104,123,37,19,23,62,521,null,126,96,117,43,20,32,49,483]
["Inverclyde",79,53,32,7,5,22,9,207,null,86,60,36,"*","*",20,7,218,null,86,46,30,5,5,17,10,199,null,98,45,25,5,"*",19,9,205]
["Midlothian",41,77,66,32,9,9,16,250,null,73,65,62,23,8,11,17,259,null,87,52,50,18,5,8,13,233,null,62,67,48,15,5,12,9,218]
["Moray",42,32,70,29,5,19,16,213,null,38,43,69,21,6,18,20,215,null,47,38,67,15,7,18,30,222,null,44,47,54,13,8,21,23,210]
["Na h-Eileanan Siar",14,7,10,0,"*","*","*",37,null,24,6,"*",10,0,"*","*",47,null,22,5,8,"*","*","*","*",41,null,18,5,7,"*","*","*","*",39]
["North Ayrshire",212,153,148,15,16,34,25,603,null,185,138,164,14,7,49,28,585,null,183,143,152,11,10,32,32,563,null,178,135,152,12,8,30,35,550]
["North Lanarkshire",292,267,125,32,10,29,10,765,null,290,306,35,99,5,31,7,773,null,284,320,63,41,5,32,9,754,null,325,304,128,49,5,30,9,850]
["Orkney Islands","*","*",9,"*","*","*",5,28,null,14,"*","*","*","*","*","*",38,null,12,"*",8,"*","*","*","*",31,null,12,7,12,"*","*","*","*",37]
["Perth and Kinross",59,78,75,43,13,10,8,286,null,67,70,71,34,16,13,10,281,null,70,73,82,24,18,"*",13,280,null,69,76,79,24,23,"*",7,282]
["Renfrewshire",221,183,130,84,21,32,10,681,null,221,178,132,78,9,32,9,659,null,221,190,119,65,12,38,11,656,null,190,190,127,61,13,36,12,629]
["Scottish Borders",27,58,78,19,9,5,22,218,null,47,57,78,15,"*","*",22,228,null,57,48,63,8,"*","*",23,205,null,55,50,57,7,"*","*",20,195]
["Shetland Islands","*","*",10,0,"*","*","*",29,null,8,"*",12,0,"*","*","*",32,null,"*","*",14,"*","*",5,"*",29,null,"*","*",19,"*","*","*","*",34]
["South Ayrshire",124,77,97,48,15,7,16,384,null,128,93,80,36,12,8,13,370,null,97,89,87,40,8,7,27,355,null,71,90,112,27,10,12,23,345]
["South Lanarkshire",160,106,192,19,16,55,15,563,null,157,114,195,19,0,50,14,549,null,178,187,209,"*",5,40,35,655,null,179,259,164,35,15,38,35,725]
["Stirling",65,52,51,7,"*","*",32,216,null,87,63,56,"*","*",6,27,245,null,83,64,60,"*","*","*",21,236,null,97,69,55,"*","*","*",13,238]
["West Dunbartonshire",82,166,45,24,9,21,16,363,null,100,201,42,34,9,24,19,429,null,108,178,59,47,10,24,19,445,null,111,219,62,55,10,21,27,505]
["West Lothian",117,124,137,17,9,13,32,449,null,134,137,162,15,10,18,35,511,null,104,139,138,16,"*",15,27,443,null,110,129,116,20,9,16,27,427]
["Scotland",3870,4279,3826,1566,299,717,760,15317,null,3766,4138,3509,1743,232,746,763,14897,null,3789,4073,3453,1491,236,721,791,14554,null,3569,4175,3335,1463,272,708,740,14262]
["Notes:"]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
[]
[]
["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":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Children Looked After: by disability status at 31 July 2016 to 2019"]
[]
[]
[null,2016,null,null,2017,null,null,2018,null,null,2019]
["Council","No. of children looked after ","No. of children looked after with  known additional support needs","% of children looked after with known additional support needs","No. of children looked after ","No. of children looked after with a disability","% of children looked after with a disability","No. of children looked after ","No. of children looked after with a disability","% of children looked after with a disability","No. of children looked after ","No. of children looked after with a disability","% of children looked after with a disability"]
["Aberdeen City",553,144,0.26,590,147,0.24915254237288137,549,128,{"$f":"I6/H6","v":0.2331511839708561},542,142,{"$f":"L6/K6","v":0.26199261992619927}]
["Aberdeenshire",411,70,0.17,395,74,0.18734177215189873,409,85,0.20782396088019561,403,80,0.19851116625310175]
["Angus",238,46,0.19,255,64,0.25098039215686274,251,58,0.23107569721115537,244,46,0.18852459016393441]
["Argyll & Bute",163,36,0.22,175,36,0.20571428571428571,149,29,0.19463087248322147,150,34,0.22666666666666666]
["City of Edinburgh",1368,72,0.05,1349,73,5.4114158636026685E-2,1309,62,4.7364400305576773E-2,1234,57,4.6191247974068074E-2]
["Clackmannanshire",233,12,0.05,213,11,5.1643192488262914E-2,211,13,6.1611374407582936E-2,185,13,7.0270270270270274E-2]
["Dumfries & Galloway",393,23,0.06,382,11,2.8795811518324606E-2,439,13,2.9612756264236904E-2,395,11,2.7848101265822784E-2]
["Dundee City",592,103,0.17,555,113,0.20360360360360361,519,103,0.19845857418111754,463,79,0.17062634989200864]
["East Ayrshire",463,13,0.03,386,9,2.3316062176165803E-2,401,9,2.2443890274314215E-2,375,9,2.4E-2]
["East Dunbartonshire",164,25,0.15,162,24,0.14814814814814814,140,24,0.17142857142857143,149,22,0.1476510067114094]
["East Lothian",229,31,0.14000000000000001,242,30,0.12396694214876033,245,29,0.11836734693877551,246,22,8.943089430894309E-2]
["East Renfrewshire",130,0,0,117,"*","*",110,"*","*",102,5,4.9019607843137254E-2]
["Falkirk",373,12,0.03,381,9,2.3622047244094488E-2,368,8,{"$f":"I18/H18","v":2.1739130434782608E-2},344,7,2.0348837209302327E-2]
["Fife",981,"-","-",942,"-","-",941,"-","-",935,"-","-"]
["Glasgow City",3294,501,0.15,2827,414,0.14644499469402192,2645,368,0.1391304347826087,2523,326,{"$f":"L20/K20","v":0.12921125644074513}]
["Highland",440,83,0.19,487,58,0.11909650924024641,521,71,0.1362763915547025,483,37,{"$f":"L21/K21","v":7.6604554865424432E-2}]
["Inverclyde",207,47,0.23,218,55,0.25229357798165136,199,48,0.24120603015075376,205,31,{"$f":"L22/K22","v":0.15121951219512195}]
["Midlothian",250,12,0.05,259,14,5.4054054054054057E-2,233,12,5.1502145922746781E-2,218,150,{"$f":"L23/K23","v":0.68807339449541283}]
["Moray",213,26,0.12,215,30,0.13953488372093023,222,32,0.14414414414414414,210,29,{"$f":"L24/K24","v":0.1380952380952381}]
["Na h-Eileanan Siar",37,5,0.14000000000000001,47,"*","*",41,"*","*",39,"*","*"]
["North Ayrshire",603,158,0.26,585,56,9.5726495726495733E-2,563,51,{"$f":"I26/H26","v":9.0586145648312605E-2},550,55,{"$f":"L26/K26","v":0.1}]
["North Lanarkshire",765,56,7.0000000000000007E-2,773,50,6.4683053040103494E-2,754,33,{"$f":"I27/H27","v":4.3766578249336871E-2},850,39,{"$f":"L27/K27","v":4.5882352941176471E-2}]
["Orkney Islands",28,"*","*",38,"*","*",31,"*","*",37,"*","*"]
["Perth & Kinross",286,46,0.16,281,37,0.13167259786476868,280,29,{"$f":"I29/H29","v":0.10357142857142858},282,19,{"$f":"L29/K29","v":6.7375886524822695E-2}]
["Renfrewshire",681,34,0.05,659,41,6.2215477996965099E-2,656,30,4.573170731707317E-2,629,31,{"$f":"L30/K30","v":4.9284578696343402E-2}]
["Scottish Borders",218,17,0.08,228,14,6.1403508771929821E-2,205,14,6.8292682926829273E-2,195,15,{"$f":"L31/K31","v":7.6923076923076927E-2}]
["Shetland Islands",29,"*","*",32,5,0.15625,29,"*","*",34,"*","*"]
["South Ayrshire",384,84,0.22,370,73,0.19729729729729731,355,68,0.19154929577464788,345,58,{"$f":"L33/K33","v":0.1681159420289855}]
["South Lanarkshire",563,43,0.08,549,67,0.122040072859745,655,79,0.12061068702290076,725,84,{"$f":"L34/K34","v":0.11586206896551725}]
["Stirling",216,14,0.06,245,19,7.7551020408163265E-2,236,20,8.4745762711864403E-2,238,25,{"$f":"L35/K35","v":0.10504201680672269}]
["West Dunbartonshire",363,50,0.14000000000000001,429,55,0.12820512820512819,445,50,0.11235955056179775,505,56,{"$f":"L36/K36","v":0.11089108910891089}]
["West Lothian",449,27,0.06,511,40,7.8277886497064575E-2,443,46,0.10383747178329571,427,46,{"$f":"L37/K37","v":0.10772833723653395}]
["SCOTLAND",15317,1797,0.12,14897,1636,0.10982076928240585,14554,1523,0.10464477119692181,14262,1535,{"$f":"L38/K38","v":0.10762866358154537}]
["Notes:"]
["Cells containing * represent numbers that are supressed to maintain confidentiality."]
["Source: Scottish Government CLAS Returns"]

{"sheet":"DATA CLA 3P","index":8,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Children Looked After: Number with 3 or more placements during the past year for those looked at 31 July 2016 to 2019"]
[]
[null,null,2016,null,null,null,2017,null,null,null,2018,null,null,null,2019]
[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,553,31,5.6057866184448461E-2,null,590,49,8.3050847457627114E-2,null,549,31,{"$f":"L6/K6","v":5.6466302367941715E-2},null,542,29,{"$f":"P6/O6","v":5.350553505535055E-2}]
["Aberdeenshire",null,411,16,3.8929440389294405E-2,null,395,21,5.3164556962025315E-2,null,409,20,4.8899755501222497E-2,null,403,29,7.1960297766749379E-2]
["Angus",null,238,24,0.10084033613445378,null,255,19,7.4509803921568626E-2,null,251,31,0.12350597609561753,null,244,18,7.3770491803278687E-2]
["Argyll & Bute",null,163,7,4.2944785276073622E-2,null,175,14,0.08,null,149,6,4.0268456375838924E-2,null,150,9,0.06]
["City of Edinburgh",null,1368,112,8.1871345029239762E-2,null,1349,85,6.3009636767976274E-2,null,1309,94,7.1810542398777696E-2,null,1234,91,7.3743922204213941E-2]
["Clackmannanshire",null,233,11,4.7210300429184553E-2,null,213,7,3.2863849765258218E-2,null,211,9,4.2654028436018961E-2,null,185,11,5.9459459459459463E-2]
["Dumfries and Galloway",null,393,35,8.9058524173027995E-2,null,382,26,6.8062827225130892E-2,null,439,27,6.1503416856492028E-2,null,395,19,4.810126582278481E-2]
["Dundee City",null,592,66,0.11148648648648649,null,555,29,5.2252252252252253E-2,null,519,33,6.358381502890173E-2,null,463,39,8.4233261339092869E-2]
["East Ayrshire",null,463,15,3.2397408207343416E-2,null,386,25,6.4766839378238336E-2,null,401,16,3.9900249376558602E-2,null,375,15,0.04]
["East Dunbartonshire",null,164,5,3.048780487804878E-2,null,162,14,8.6419753086419748E-2,null,140,5,3.5714285714285712E-2,null,149,"*","*"]
["East Lothian",null,229,7,3.0567685589519649E-2,null,242,13,5.3719008264462811E-2,null,245,5,2.0408163265306121E-2,null,246,15,6.097560975609756E-2]
["East Renfrewshire",null,130,7,5.3846153846153849E-2,null,117,5,4.2735042735042736E-2,null,110,"*","*",null,102,7,6.8627450980392163E-2]
["Falkirk",null,373,21,5.6300268096514748E-2,null,381,22,5.774278215223097E-2,null,368,26,7.0652173913043473E-2,null,344,34,9.8837209302325577E-2]
["Fife",null,981,64,6.5239551478083593E-2,null,942,74,7.8556263269639062E-2,null,941,64,6.8012752391073322E-2,null,935,50,5.3475935828877004E-2]
["Glasgow City",null,3294,94,2.853673345476624E-2,null,2827,100,3.5373187124159884E-2,null,2645,62,2.3440453686200378E-2,null,2523,59,2.3384859294490686E-2]
["Highland",null,440,66,0.15,null,487,67,0.1375770020533881,null,521,49,9.4049904030710174E-2,null,483,46,9.5238095238095233E-2]
["Inverclyde",null,207,11,5.3140096618357488E-2,null,218,"*","*",null,199,6,3.015075376884422E-2,null,205,6,2.9268292682926831E-2]
["Midlothian",null,250,"*","*",null,259,19,7.3359073359073365E-2,null,233,13,5.5793991416309016E-2,null,218,8,3.669724770642202E-2]
["Moray",null,213,23,0.107981220657277,null,215,18,8.3720930232558138E-2,null,222,21,9.45945945945946E-2,null,210,22,0.10476190476190476]
["Na h-Eileanan Siar",null,37,20,0.54054054054054057,null,47,17,0.36170212765957449,null,41,16,{"$f":"L25/K25","v":0.3902439024390244},null,39,11,0.28205128205128205]
["North Ayrshire",null,603,25,4.1459369817578771E-2,null,585,27,4.6153846153846156E-2,null,563,18,{"$f":"L26/K26","v":3.1971580817051509E-2},null,550,37,6.7272727272727276E-2]
["North Lanarkshire",null,765,0,0,null,773,8,1.034928848641656E-2,null,754,"*","*",null,850,12,1.411764705882353E-2]
["Orkney Islands",null,28,"*","*",null,38,0,0,null,31,5,0,null,37,6,0.16216216216216217]
["Perth and Kinross",null,286,32,0.11188811188811189,null,281,23,8.1850533807829182E-2,null,280,19,{"$f":"L29/K29","v":6.7857142857142852E-2},null,282,31,0.1099290780141844]
["Renfrewshire",null,681,34,4.9926578560939794E-2,null,659,29,4.4006069802731411E-2,null,656,22,{"$f":"L30/K30","v":3.3536585365853661E-2},null,629,35,5.5643879173290937E-2]
["Scottish Borders",null,218,"*","*",null,228,"*","*",null,205,"*","*",null,195,5,2.564102564102564E-2]
["Shetland Islands",null,29,0,0,null,32,0,0,null,29,"*","*",null,34,"*","*"]
["South Ayrshire",null,384,8,2.0833333333333332E-2,null,370,23,6.2162162162162166E-2,null,355,24,{"$f":"L33/K33","v":6.7605633802816895E-2},null,345,16,4.6376811594202899E-2]
["South Lanarkshire",null,563,24,4.2628774422735348E-2,null,549,23,4.1894353369763208E-2,null,655,37,5.6488549618320609E-2,null,725,16,{"$f":"P34/O34","v":2.2068965517241378E-2}]
["Stirling",null,216,16,7.407407407407407E-2,null,245,11,4.4897959183673466E-2,null,236,12,5.0847457627118647E-2,null,238,11,{"$f":"P35/O35","v":4.6218487394957986E-2}]
["West Dunbartonshire",null,363,21,5.7851239669421489E-2,null,429,14,3.2634032634032632E-2,null,445,22,4.9438202247191011E-2,null,505,27,{"$f":"P36/O36","v":5.3465346534653464E-2}]
["West Lothian",null,449,28,6.2360801781737196E-2,null,511,27,5.2837573385518588E-2,null,443,15,3.3860045146726865E-2,null,427,22,{"$f":"P37/O37","v":5.1522248243559721E-2}]
["SCOTLAND",null,15317,833,5.4384017758046618E-2,null,14897,815,5.4709001812445458E-2,null,14554,718,{"$f":"L38/K38","v":4.9333516559021573E-2},null,14262,742,{"$f":"P38/O38","v":5.2026363763847991E-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},{"$f":"INDEX($J$1:$K$32,MATCH(D39,$J$1:$J$32,0),2)","v":8},28,4,25,null,null,"Aberdeen City","Aberdeen City",1]
[2,{"$f":"INDEX($J$1:$K$32,MATCH(C40,$J$1:$J$32,0),2)","v":30},24,16,26,29,null,null,"Aberdeenshire","Aberdeenshire",2]
[3,{"$f":"INDEX($J$1:$K$32,MATCH(C41,$J$1:$J$32,0),2)","v":16},7,19,26,28,null,null,"Angus","Angus",3]
[4,{"$f":"INDEX($J$1:$K$32,MATCH(C42,$J$1:$J$32,0),2)","v":28},7,26,16,3,null,null,"Argyll and Bute","Argyll and Bute",4]
[5,{"$f":"INDEX($J$1:$K$32,MATCH(C43,$J$1:$J$32,0),2)","v":1},8,28,4,25,null,null,"Clackmannanshire","City of Edinburgh",5]
[6,{"$f":"INDEX($J$1:$K$32,MATCH(C44,$J$1:$J$32,0),2)","v":22},32,13,29,9,null,null,"Dumfries and Galloway","Clackmannanshire",6]
[7,{"$f":"INDEX($J$1:$K$32,MATCH(C45,$J$1:$J$32,0),2)","v":3},16,4,26,19,null,null,"Dundee City","Dumfries and Galloway",7]
[8,{"$f":"INDEX($J$1:$K$32,MATCH(C46,$J$1:$J$32,0),2)","v":1},25,7,17,28,null,null,"East Ayrshire","Dundee City",8]
[9,{"$f":"INDEX($J$1:$K$32,MATCH(C47,$J$1:$J$32,0),2)","v":22},6,13,21,32,null,null,"East Dunbartonshire","East Ayrshire",9]
[10,{"$f":"INDEX($J$1:$K$32,MATCH(C48,$J$1:$J$32,0),2)","v":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,{"$f":"INDEX($J$1:$K$32,MATCH(C50,$J$1:$J$32,0),2)","v":10},11,30,2,18,null,null,"Edinburgh","East Renfrewshire",12]
[13,{"$f":"INDEX($J$1:$K$32,MATCH(C51,$J$1:$J$32,0),2)","v":29},14,6,19,3,null,null,"Eilean Siar","Falkirk",13]
[14,{"$f":"INDEX($J$1:$K$32,MATCH(C52,$J$1:$J$32,0),2)","v":29},13,6,32,25,null,null,"Falkirk","Fife",14]
[15,{"$f":"INDEX($J$1:$K$32,MATCH(C53,$J$1:$J$32,0),2)","v":8},31,17,1,25,null,null,"Fife","Glasgow City",15]
[16,{"$f":"INDEX($J$1:$K$32,MATCH(C54,$J$1:$J$32,0),2)","v":3},26,7,19,4,null,null,"Glasgow City","Highland",16]
[17,{"$f":"INDEX($J$1:$K$32,MATCH(C55,$J$1:$J$32,0),2)","v":31},21,22,9,25,null,null,"Highland","Inverclyde",17]
[18,{"$f":"INDEX($J$1:$K$32,MATCH(C56,$J$1:$J$32,0),2)","v":32},14,6,29,11,null,null,"Inverclyde","Midlothian",18]
[19,{"$f":"INDEX($J$1:$K$32,MATCH(C57,$J$1:$J$32,0),2)","v":3},16,7,13,26,null,null,"Midlothian","Moray",19]
[20,{"$f":"INDEX($J$1:$K$32,MATCH(C58,$J$1:$J$32,0),2)","v":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,{"$f":"INDEX($J$1:$K$32,MATCH(C60,$J$1:$J$32,0),2)","v":6},9,13,32,21,null,null,"North Lanarkshire","North Lanarkshire",22]
[23,{"$f":"INDEX($J$1:$K$32,MATCH(C61,$J$1:$J$32,0),2)","v":26},16,20,19,27,null,null,"Orkney Islands","Orkney Islands",23]
[24,{"$f":"INDEX($J$1:$K$32,MATCH(C62,$J$1:$J$32,0),2)","v":26},4,2,30,16,null,null,"Perth and Kinross","Perth and Kinross",24]
[25,{"$f":"INDEX($J$1:$K$32,MATCH(C63,$J$1:$J$32,0),2)","v":14},13,6,31,29,null,null,"Renfrewshire","Renfrewshire",25]
[26,{"$f":"INDEX($J$1:$K$32,MATCH(C64,$J$1:$J$32,0),2)","v":16},3,7,4,24,null,null,"Scottish Borders","Scottish Borders",26]
[27,{"$f":"INDEX($J$1:$K$32,MATCH(C65,$J$1:$J$32,0),2)","v":23},19,16,26,3,null,null,"Shetland Islands","Shetland Islands",27]
[28,{"$f":"INDEX($J$1:$K$32,MATCH(C66,$J$1:$J$32,0),2)","v":4},3,7,16,26,null,null,"South Ayrshire","South Ayrshire",28]
[29,{"$f":"INDEX($J$1:$K$32,MATCH(C67,$J$1:$J$32,0),2)","v":14},13,32,6,22,null,null,"South Lanarkshire","South Lanarkshire",29]
[30,{"$f":"INDEX($J$1:$K$32,MATCH(C68,$J$1:$J$32,0),2)","v":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,{"$f":"INDEX($J$1:$K$32,MATCH(C70,$J$1:$J$32,0),2)","v":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"]