{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Q1),1a),1b)","Q2","Q3","Q4","Q5","Q6, 6b), 6c)","Q7","Q8","Q9","Q10","Q11","Q12"],"read":"whole","date_system":"1900"}

{"sheet":"Q1),1a),1b)","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
["Year","Accounts in Arrears each Year "]
["2013/14",6725]
["2014/15",6693]
["2015/16",6239]
["2016/17",6252]
["2017/18",6783]
["2018/19",8235]
["2019/20",8137]
["2020/21",6899]
["2021/22",7535]

{"sheet":"Q2","index":1,"n_rows":1,"n_cols":1,"rows_kept":1}
["We do not hold this information"]

{"sheet":"Q3","index":2,"n_rows":10,"n_cols":2,"rows_kept":10}
["Year ","Value of Arrears before w/off's in 2022 (as @ 31.03.2023)"]
["2013/14",{"v":248955.5,"d":"£248,955.50"}]
["2014/15",{"v":345282.98,"d":"£345,282.98"}]
["2015/16",{"v":448635.89,"d":"£448,635.89"}]
["2016/17",{"v":640099.33,"d":"£640,099.33"}]
["2017/18",{"v":1006070.56,"d":"£1,006,070.56"}]
["2018/19",{"v":1422195.43,"d":"£1,422,195.43"}]
["2019/20",{"v":1806422.03,"d":"£1,806,422.03"}]
["2020/21",{"v":2098843.75,"d":"£2,098,843.75"}]
["2021/22",{"v":2687940.25,"d":"£2,687,940.25"}]

{"sheet":"Q4","index":3,"n_rows":2,"n_cols":1,"rows_kept":2}
["Value of W/off's done in 2022 for 2021"]
[{"v":22070.98,"d":"£22,070.98"}]

{"sheet":"Q5","index":4,"n_rows":11,"n_cols":2,"rows_kept":11}
["Year","Value of Arrears for Early Years (taken as at Year-End of that F/Year)"]
["2013/14",{"v":2158589.07,"d":"£2,158,589.07"}]
["2014/15",{"v":2223890.23,"d":"£2,223,890.23"}]
["2015/16",{"v":2312915.26,"d":"£2,312,915.26"}]
["2016/17",{"v":2329593.8,"d":"£2,329,593.80"}]
["2017/18",{"v":2858208.87,"d":"£2,858,208.87"}]
["2018/19",{"v":3488096.21,"d":"£3,488,096.21"}]
["2019/20",{"v":3623032.87,"d":"£3,623,032.87"}]
["2020/21",{"v":4062428.19,"d":"£4,062,428.19"}]
["2021/22",{"v":3785971.89,"d":"£3,785,971.89"}]
[null,{"$f":"SUM(B2:B10)","v":{"v":26842726.390000004,"d":"£26,842,726.39"}}]

{"sheet":"Q6, 6b), 6c)","index":5,"n_rows":9,"n_cols":1,"rows_kept":9}
["Total Value of Arrears as @31.03.2023 (Post W/off's)"]
[{"v":10645501.92,"d":"£10,645,501.92"}]
[]
[]
["Total Value of Arrears for 2021 as @31.03.2023 (Post W/off's)"]
[{"v":2665869.27,"d":"£2,665,869.27"}]
[]
["Total Value of Arrears for prev years as @ 31.03.2023 (post W/off's)"]
[{"v":7979632.65,"d":"£7,979,632.65"}]

{"sheet":"Q7","index":6,"n_rows":5,"n_cols":1,"rows_kept":5}
["Total Value of Council Tax Not collected in 2022 as @ 31.03.2023 (all years inc 2022)"]
[{"v":14776812.61,"d":"£14,776,812.61"}]
[]
["Total Value of Council Tax Not collected in 2022 as @ 31.03.2023 (all years exc 2022)"]
[{"v":10645501.92,"d":"£10,645,501.92"}]

{"sheet":"Q8","index":7,"n_rows":2,"n_cols":1,"rows_kept":2}
["Value of W/off's done in 2022 for 2022"]
[{"v":28210.54,"d":"£28,210.54"}]

{"sheet":"Q9","index":8,"n_rows":2,"n_cols":1,"rows_kept":2}
["Value of Arrears for 2022 as @ 31.03.2023"]
[{"v":4131310.69,"d":"£4,131,310.69"}]

{"sheet":"Q10","index":9,"n_rows":2,"n_cols":1,"rows_kept":2}
["Total Value of Arrears as @ 31.03.2023"]
[{"v":14776812.61,"d":"£14,776,812.61"}]

{"sheet":"Q11","index":10,"n_rows":2,"n_cols":1,"rows_kept":2}
["Net Change in Value (done from figures at year-end (2013 - 2021) Q5 less Q10"]
[{"v":12065913.78,"d":"£12,065,913.78"}]

{"sheet":"Q12","index":11,"n_rows":10,"n_cols":2,"rows_kept":10}
["Year","Administration Costs "]
["2013/14",{"v":210863.88,"d":"£210,863.88"}]
["2014/15",{"v":236046.95,"d":"£236,046.95"}]
["2015/16",{"v":224740.03,"d":"£224,740.03"}]
["2016/17",{"v":162714.26,"d":"£162,714.26"}]
["2017/18",{"v":142046.03,"d":"£142,046.03"}]
["2018/19",{"v":164845.38,"d":"£164,845.38"}]
["2019/20",{"v":264489.96,"d":"£264,489.96"}]
["2020/21",{"v":176025,"d":"£176,025.00"}]
["2021/22",{"v":325565,"d":"£325,565.00"}]