{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Backing Sheet Data","Year Calculations"],"not_rendered":{"charts":4,"images":1,"macros":0,"external_links":1,"defined_names":3,"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":"Dashboard","index":0,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,26,1,27],[2,26,3,27],[4,26,5,27],[4,21,5,22],[0,21,1,22],[2,21,3,22],[0,15,1,16],[2,15,3,16],[4,15,5,16],[4,17,5,20],[0,23,1,25],[2,23,3,25],[4,23,5,25],[0,17,1,20],[2,17,3,20],[0,9,1,10],[2,9,3,10],[4,9,5,10],[0,11,1,14],[2,11,3,14],[4,11,5,14],[0,3,1,4],[2,3,3,4],[4,3,5,4],[16,0,16,6],[16,7,16,8],[15,0,15,6],[15,7,15,8],[9,0,9,6],[10,0,10,6],[11,0,11,6],[0,0,1,2],[2,0,3,2],[4,0,5,2],[0,5,1,8],[2,5,3,8],[4,5,5,8],[16,9,16,10],[16,11,16,12],[19,0,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[17,0,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[18,0,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[15,9,15,10],[15,11,15,12],[12,0,13,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[14,0,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[9,7,9,8],[10,7,10,8],[11,7,11,8],[9,9,9,10],[10,9,10,10],[11,9,11,10],[8,11,8,12],[8,9,8,10],[8,7,8,8],[6,0,7,12],[8,0,8,6]]}
["Sent this month:",null,null,2981,null,"Left process at stage 1:",null,null,null,1525,null,"Left process at stage 2:",null,null,null,96,null,"Exited process:",null,null,null,526,null,"Settled:",null,null,283]
[]
["Δ from last month:",null,null,130,null,"Δ from last month:",null,null,null,45,null,"Δ from last month:",null,null,null,-7,null,"Δ from last month:",null,null,null,15,null,"Δ from last month:",null,null,-50]
[]
["Rolling 12 months:",null,null,37951,null,"Rolling 12 months:",null,null,null,19361,null,"Rolling 12 months:",null,null,null,1048,null,"Rolling 12 months:",null,null,null,6715,null,"Rolling 12 months:",null,null,3806]
[]
["Left Process Breakdowns - Stage 1:"]
[]
["Reason",null,null,null,null,null,null,"This Month",null,"Last Month",null,"Δ"]
["Liability Decision Timeout",null,null,null,null,null,null,1147,null,1136,null,11]
["Other",null,null,null,null,null,null,378,null,344,null,34]
["Total",null,null,null,null,null,null,1525,null,1480,null,45]
["Left Process Breakdowns - Stage 2:"]
[]
["Reason",null,null,null,null,null,null,"This Month",null,"Last Month",null,"Δ"]
["Interim payment more than £1,000 not agreed:",null,null,null,null,null,null,1,null,1,null,0]
["Settlement pack repudiated:",null,null,null,null,null,null,0,null,0,null,0]
["Settlement pack timeout:",null,null,null,null,null,null,41,null,52,null,-11]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,54,null,50,null,4]
["Total",null,null,null,null,null,null,96,null,103,null,-7]

{"sheet":"Backing Sheet Data","index":1,"n_rows":111,"n_cols":42,"rows_kept":111,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2022-07-01"]
["Previous month","2022-06-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,457321,275007,5256,77691,5249,48704,430124.39467699995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages",null,"Period","Rolling 12 CNF Sent","Rolling 12 CNF Left at Stage 1","Rolling 12 Stage 2 Exit","Rolling 12 Exit Process","Rolling 12 Court Pack","Rolling 12 Settled Claims",null,"Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages"]
["Rolling 12 CNFs sent",null,null,null,"Average General Damages chart data",null,null,null,"Left Process Breakdown",null,null,null,null,null,null,null,null,"2013-08-01",370,6,0,27,0,0,null,null,"2013-08-01",null,null,null,null,null,null,null,"2013-08-01",370,6,0,27,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01",1846,208,0,91,0,4,1300,null,"2013-09-01",null,null,null,null,null,null,null,"2013-09-01",1849,208,0,91,0,4,1300]
["Period","Rolling 12 Sent",null,null,"Row Labels","Ave General Damages",null,null,"This Month LDT","This Month Other Liability","This Month Interim Payment Not Agreed","This Month Repudiated","This Month Timeout","This Month Court Proceedings",null,null,null,"2013-10-01",3381,840,1,224,0,8,1281.25,null,"2013-10-01",null,null,null,null,null,null,null,"2013-10-01",3391,840,1,224,0,8,1281.25]
["2021-08-01",38002,null,null,"2021-08-01",5154.3392800000001,null,null,1147,378,1,0,41,54,null,null,null,"2013-11-01",3848,1558,0,271,0,39,1977.948717,null,"2013-11-01",null,null,null,null,null,null,null,"2013-11-01",3851,1558,0,271,0,39,1977.948717]
["2021-09-01",37618,null,null,"2021-09-01",4987.7054790000002,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01",3356,1837,6,293,0,50,2105,null,"2013-12-01",null,null,null,null,null,null,null,"2013-12-01",3361,1837,6,293,0,50,2105]
["2021-10-01",35044,null,null,"2021-10-01",4877.8331520000002,null,null,"CNF Sent Monthly Volumes Chart Data",null,null,null,null,null,null,null,null,"2014-01-01",5229,2352,10,479,2,108,2417.3500920000001,null,"2014-01-01",null,null,null,null,null,null,null,"2014-01-01",5241,2352,10,479,2,108,2417.3500920000001]
["2021-11-01",37581,null,null,"2021-11-01",4926.1740799999998,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01",5092,2165,16,443,4,149,2474.980067,null,"2014-02-01",null,null,null,null,null,null,null,"2014-02-01",5112,2165,16,443,4,149,2474.980067]
["2021-12-01",37238,null,null,"2021-12-01",5018.3607890000003,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2014-03-01",5771,3147,29,581,5,208,2764.1224510000002,null,"2014-03-01",null,null,null,null,null,null,null,"2014-03-01",5783,3147,29,581,5,208,2764.1224510000002]
["2022-01-01",37699,null,null,"2022-01-01",4711.8729679999997,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total",null,null,null,"2014-04-01",5510,3269,26,675,7,245,2658.4375100000002,null,"2014-04-01",null,null,null,null,null,null,null,"2014-04-01",5531,3269,26,675,7,245,2658.4375100000002]
["2022-02-01",38021,null,null,"2022-02-01",4906.1417350000002,null,null,"2021-08-01",11505,3283,318,2481,17587,null,null,null,"2014-05-01",5823,3467,34,730,4,269,2944.2115610000001,null,"2014-05-01",null,null,null,null,null,null,null,"2014-05-01",5843,3467,34,730,4,269,2944.2115610000001]
["2022-03-01",38194,null,null,"2022-03-01",4539.5586620000004,null,null,"2021-09-01",11300,3623,343,2730,17996,null,null,null,"2014-06-01",6194,3535,41,749,22,344,3020.030377,null,"2014-06-01",null,null,null,null,null,null,null,"2014-06-01",6217,3535,41,749,22,344,3020.030377]
["2022-04-01",38176,null,null,"2022-04-01",4829.560853,null,null,"2021-10-01",10043,3479,357,2566,16445,null,null,null,"2014-07-01",7213,3973,53,881,19,446,3146.8208960000002,null,"2014-07-01",53633,26357,216,5444,63,1870,null,"2014-07-01",7252,3973,53,881,19,446,3146.8208960000002]
["2022-05-01",38510,null,null,"2022-05-01",4777.5615299999999,null,null,"2021-11-01",9821,3500,427,2681,16429,null,null,null,"2014-08-01",6132,3643,37,754,13,384,3308.3370570000002,null,"2014-08-01",59395,29994,253,6171,76,2254,null,"2014-08-01",6165,3643,37,754,13,384,3308.3370570000002]
["2022-06-01",38244,null,null,"2022-06-01",4807.4264860000003,null,null,"2021-12-01",7687,2480,273,2035,12475,null,null,null,"2014-09-01",7232,4136,62,1008,22,485,3106.994659,null,"2014-09-01",64781,33922,315,7088,98,2735,null,"2014-09-01",7274,4136,62,1008,22,485,3106.994659]
["2022-07-01",37951,null,null,"2022-07-01",4909.1396809999997,null,null,"2022-01-01",8745,3131,378,2473,14727,null,null,null,"2014-10-01",7637,4310,60,1134,34,616,3176.7030840000002,null,"2014-10-01",69037,37392,374,7998,132,3343,null,"2014-10-01",7688,4310,60,1134,34,616,3176.7030840000002]
[null,null,null,null,"Grand Total",58445.674695000009,null,null,"2022-02-01",7871,3195,317,2477,13860,null,null,null,"2014-11-01",6215,4079,62,971,28,563,3329.6076549999998,null,"2014-11-01",71404,39913,436,8698,160,3867,null,"2014-11-01",6262,4079,62,971,28,563,3329.6076549999998]
[null,null,null,null,null,null,null,null,"2022-03-01",8218,3465,445,2820,14948,null,null,null,"2014-12-01",5220,4091,62,979,37,579,3291.0112079999999,null,"2014-12-01",73268,42167,492,9384,197,4396,null,"2014-12-01",5256,4091,62,979,37,579,3291.0112079999999]
[null,null,null,null,null,null,null,null,"2022-04-01",7247,2783,357,2201,12588,null,null,null,"2015-01-01",6177,3618,55,977,28,633,3313.3723060000002,null,"2015-01-01",74216,43433,537,9882,223,4921,null,"2015-01-01",6220,3618,55,977,28,633,3313.3723060000002]
[null,90121,null,null,"CNF Sent Monthly Volumes",null,null,null,"2022-05-01",7876,3127,459,2528,13990,null,null,null,"2015-02-01",6296,3152,67,833,43,633,3339.5623529999998,null,"2015-02-01",75420,44420,588,10272,262,5405,null,"2015-02-01",6330,3152,67,833,43,633,3339.5623529999998]
["Exit Process Reason","Total",null,null,null,null,null,null,"2022-06-01",7289,2904,485,2404,13082,null,null,null,"2015-03-01",6682,4068,65,1072,38,730,3404.7033419999998,null,"2015-03-01",76331,45341,624,10763,295,5927,null,"2015-03-01",6750,4068,65,1072,38,730,3404.7033419999998]
["Other",39143,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2022-07-01",7438,2981,427,2257,13103,null,null,null,"2015-04-01",5854,3802,79,953,40,661,3577.5724650000002,null,"2015-04-01",76675,45874,677,11041,328,6343,null,"2015-04-01",5915,3802,79,953,40,661,3577.5724650000002]
["Claim requires further investigation",30414,null,null,"2021-05-01","RTA",26904,null,"Grand Total",105040,37951,4586,29653,177230,null,null,null,"2015-05-01",5354,3397,70,949,29,632,3448.4915339999998,null,"2015-05-01",76206,45804,713,11260,353,6706,null,"2015-05-01",5415,3397,70,949,29,632,3448.4915339999998]
["Duplicated claim",7349,null,null,"2021-06-01","RTA",26133,null,null,null,null,null,null,null,null,null,null,"2015-06-01",6298,3939,59,1006,40,729,3627.6689430000001,null,"2015-06-01",76310,46208,731,11517,371,7091,null,"2015-06-01",6378,3939,59,1006,40,729,3627.6689430000001]
["Incomplete information provided on CNF",6090,null,null,"2021-07-01","RTA",14787,null,null,null,null,null,null,null,null,null,null,"2015-07-01",6730,3911,75,1063,44,748,3798.3083550000001,null,"2015-07-01",75827,46146,753,11699,396,7393,null,"2015-07-01",6816,3911,75,1063,44,748,3798.3083550000001]
["Withdrawal of claim",2820,null,null,"2021-08-01","RTA",11505,null,null,null,null,null,null,null,null,null,null,"2015-08-01",5876,3590,60,939,38,626,3750.637843,null,"2015-08-01",75571,46093,776,11884,421,7635,null,"2015-08-01",5962,3590,60,939,38,626,3750.637843]
["Value of claim exceeds the upper limit",2619,null,null,"2021-09-01","RTA",11300,null,null,null,null,null,null,null,null,null,null,"2015-09-01",6096,3947,79,1028,52,675,3700.0653619999998,null,"2015-09-01",74435,45904,793,11904,451,7825,null,"2015-09-01",6183,3947,79,1028,52,675,3700.0653619999998]
["Claim is too complex for process",882,null,null,"2021-10-01","RTA",10043,null,null,null,null,null,null,null,null,null,null,"2015-10-01",6048,3769,68,1020,42,722,3454.2663149999998,null,"2015-10-01",72846,45363,801,11790,459,7931,null,"2015-10-01",6164,3769,68,1020,42,722,3454.2663149999998]
["Value of claim below ú1,000",458,null,null,"2021-11-01","RTA",9821,null,null,null,null,null,null,null,null,null,null,"2015-11-01",5744,3603,85,1008,50,709,3808.7843579999999,null,"2015-11-01",72375,44887,824,11827,481,8077,null,"2015-11-01",5843,3603,85,1008,50,709,3808.7843579999999]
["Withdrawal of offer",284,null,null,"2021-12-01","RTA",7687,null,null,null,null,null,null,null,null,null,null,"2015-12-01",4507,3447,87,881,45,640,3785.0480309999998,null,"2015-12-01",71662,44243,849,11729,489,8138,null,"2015-12-01",4584,3447,87,881,45,640,3785.0480309999998]
["Interim payment for child claimant",62,null,null,"2022-01-01","RTA",8745,null,null,null,null,null,null,null,null,null,null,"2016-01-01",5116,3271,60,933,39,620,3964.2704669999998,null,"2016-01-01",70601,43896,854,11685,500,8125,null,"2016-01-01",5224,3271,60,933,39,620,3964.2704669999998]
[null,null,null,null,"2022-02-01","RTA",7871,null,null,null,null,null,null,null,null,null,null,"2016-02-01",5610,2786,61,859,51,662,3763.3202409999999,null,"2016-02-01",69915,43530,848,11711,508,8154,null,"2016-02-01",5741,2786,61,859,51,662,3763.3202409999999]
[null,null,null,null,"2022-03-01","RTA",8218,null,null,null,null,null,null,null,null,null,null,"2016-03-01",5606,3433,76,1026,50,676,3927.2018629999998,null,"2016-03-01",68839,42895,859,11665,520,8100,null,"2016-03-01",5739,3433,76,1026,50,676,3927.2018629999998]
[null,null,null,null,"2022-04-01","RTA",7247,null,null,null,null,null,null,null,null,null,null,"2016-04-01",5311,3395,80,981,45,661,3835.1196060000002,null,"2016-04-01",68296,42488,860,11693,525,8100,null,"2016-04-01",5467,3395,80,981,45,662,3829.3263740000002]
[null,null,null,null,"2022-05-01","RTA",7876,null,null,null,null,null,null,null,null,null,null,"2016-05-01",4853,3163,71,982,45,568,3940.3162499999999,null,"2016-05-01",67795,42254,861,11726,541,8036,null,"2016-05-01",5008,3163,71,982,45,568,3940.3162499999999]
[null,null,null,null,"2022-06-01","RTA",7289,null,null,null,null,null,null,null,null,null,null,"2016-06-01",4294,3405,87,973,68,627,3940.8149440000002,null,"2016-06-01",65791,41720,889,11693,569,7934,null,"2016-06-01",4436,3405,87,973,68,627,3940.8149440000002]
[null,null,null,null,"2022-07-01","RTA",7438,null,null,null,null,null,null,null,null,null,null,"2016-07-01",4674,2698,91,884,54,526,4052.135988,null,"2016-07-01",63735,40507,905,11514,579,7712,null,"2016-07-01",4825,2698,91,884,54,526,4052.135988]
[null,null,null,null,"2021-05-01","EL",1711,null,null,null,null,null,null,null,null,null,null,"2016-08-01",5198,2216,38,606,35,560,3937.6303750000002,null,"2016-08-01",63057,39133,883,11181,576,7646,null,"2016-08-01",5351,2216,38,606,35,561,3945.6738140000002]
[null,null,null,null,"2021-06-01","EL",2442,null,null,null,null,null,null,null,null,null,null,"2016-09-01",5478,3277,84,954,77,604,3909.7556949999998,null,"2016-09-01",62439,38463,888,11107,601,7575,null,"2016-09-01",5700,3277,84,954,77,604,3909.7556949999998]
[null,null,null,null,"2021-07-01","EL",2512,null,null,null,null,null,null,null,null,null,null,"2016-10-01",4907,3203,87,991,53,606,3812.8383330000001,null,"2016-10-01",61298,37897,907,11078,612,7459,null,"2016-10-01",5182,3203,87,991,53,611,3817.7136329999998]
[null,null,null,null,"2021-08-01","EL",2481,null,null,null,null,null,null,null,null,null,null,"2016-11-01",4815,3320,86,939,61,600,4029.7997500000001,null,"2016-11-01",60369,37614,908,11009,623,7350,null,"2016-11-01",5207,3320,86,939,61,602,4037.5911120000001]
[null,null,null,null,"2021-09-01","EL",2730,null,null,null,null,null,null,null,null,null,null,"2016-12-01",3584,2775,76,784,56,518,4150.8153860000002,null,"2016-12-01",59446,36942,897,10912,634,7228,null,"2016-12-01",3892,2775,76,784,56,537,4184.4410980000002]
[null,null,null,null,"2021-10-01","EL",2566,null,null,null,null,null,null,null,null,null,null,"2017-01-01",4673,2833,74,878,85,549,3828.3515480000001,null,"2017-01-01",59003,36504,911,10857,680,7157,null,"2017-01-01",5119,2833,74,878,85,574,3854.9294249999998]
[null,null,null,null,"2021-11-01","EL",2681,null,null,null,null,null,null,null,null,null,null,"2017-02-01",4483,2374,56,750,64,580,3937.6632239999999,null,"2017-02-01",57876,36092,906,10748,693,7075,null,"2017-02-01",4907,2374,56,750,64,599,3942.1031210000001]
[null,null,null,null,"2021-12-01","EL",2035,null,null,null,null,null,null,null,null,null,null,"2017-03-01",5353,3297,80,944,78,634,4175.6838170000001,null,"2017-03-01",57623,35956,910,10666,721,7033,null,"2017-03-01",5804,3297,80,944,78,650,4167.2315230000004]
[null,null,null,null,"2022-01-01","EL",2473,null,null,null,null,null,null,null,null,null,null,"2017-04-01",3802,2622,66,742,44,555,4283.8405579999999,null,"2017-04-01",56114,35183,896,10427,720,6927,null,"2017-04-01",4124,2622,66,742,44,568,4270.8655099999996]
[null,null,null,null,"2022-02-01","EL",2477,null,null,null,null,null,null,null,null,null,null,"2017-05-01",4656,3139,63,873,77,623,3954.526597,null,"2017-05-01",55917,35159,888,10318,752,6982,null,"2017-05-01",5058,3139,63,873,77,637,4016.5316320000002]
[null,null,null,null,"2022-03-01","EL",2820,null,null,null,null,null,null,null,null,null,null,"2017-06-01",4603,2962,67,891,72,579,4250.5384620000004,null,"2017-06-01",56226,34716,868,10236,756,6934,null,"2017-06-01",4984,2962,67,891,72,599,4289.4138059999996]
[null,null,null,null,"2022-04-01","EL",2201,null,null,null,null,null,null,null,null,null,null,"2017-07-01",4489,2907,64,909,87,557,4291.4689040000003,null,"2017-07-01",56041,34925,841,10261,789,6965,null,"2017-07-01",4865,2907,64,909,87,570,4294.2862800000003]
[null,null,null,null,"2022-05-01","EL",2528,null,null,null,null,null,null,null,null,null,null,"2017-08-01",4778,2924,62,901,72,548,4113.923667,null,"2017-08-01",55621,35633,865,10556,826,6953,null,"2017-08-01",5186,2924,62,901,72,560,4116.7503029999998]
[null,null,null,null,"2022-06-01","EL",2404,null,null,null,null,null,null,null,null,null,null,"2017-09-01",4508,2888,57,823,65,520,3992.4600190000001,null,"2017-09-01",54651,35244,838,10425,814,6869,null,"2017-09-01",4906,2888,57,823,65,537,4020.2592359999999]
[null,null,null,null,"2022-07-01","EL",2257,null,null,null,null,null,null,null,null,null,null,"2017-10-01",4828,3055,64,894,84,542,4054.3269180000002,null,"2017-10-01",54572,35096,815,10328,845,6805,null,"2017-10-01",5256,3055,64,894,84,560,4083.8753390000002]
[null,null,null,null,"2021-05-01","ELD",174,null,null,null,null,null,null,null,null,null,null,"2017-11-01",4785,3115,52,922,89,562,4275.2169569999996,null,"2017-11-01",54542,34891,781,10311,873,6767,null,"2017-11-01",5165,3115,52,922,89,575,4293.3424859999996]
[null,null,null,null,"2021-06-01","ELD",280,null,null,null,null,null,null,null,null,null,null,"2017-12-01",3242,2616,58,766,73,436,4181.0074539999996,null,"2017-12-01",54200,34732,763,10293,890,6685,null,"2017-12-01",3611,2616,58,766,73,447,4242.8048989999998]
[null,null,null,null,"2021-07-01","ELD",422,null,null,null,null,null,null,null,null,null,null,"2018-01-01",4712,2877,47,890,75,505,4094.6545740000001,null,"2018-01-01",54239,34776,736,10305,880,6641,null,"2018-01-01",5161,2877,47,890,75,521,4110.3657579999999]
[null,null,null,null,"2021-08-01","ELD",318,null,null,null,null,null,null,null,null,null,null,"2018-02-01",4545,2271,52,744,61,542,4224.0598330000003,null,"2018-02-01",54301,34673,732,10299,877,6603,null,"2018-02-01",4956,2271,52,744,61,554,4213.6596200000004]
[null,null,null,null,"2021-09-01","ELD",343,null,null,null,null,null,null,null,null,null,null,"2018-03-01",4420,2970,73,893,81,565,4118.3931849999999,null,"2018-03-01",53368,34346,725,10248,880,6534,null,"2018-03-01",4822,2970,73,893,81,576,4151.8092880000004]
[null,null,null,null,"2021-10-01","ELD",357,null,null,null,null,null,null,null,null,null,null,"2018-04-01",4267,2772,69,825,55,525,4323.413485,null,"2018-04-01",53833,34496,728,10331,891,6504,null,"2018-04-01",4664,2772,69,825,55,538,4344.9202230000001]
[null,null,null,null,"2021-11-01","ELD",427,null,null,null,null,null,null,null,null,null,null,"2018-05-01",4347,2887,62,889,73,550,4171.9078719999998,null,"2018-05-01",53524,34244,727,10347,887,6431,null,"2018-05-01",4739,2887,62,889,73,567,4182.4503169999998]
[null,null,null,null,"2021-12-01","ELD",273,null,null,null,null,null,null,null,null,null,null,"2018-06-01",4333,2818,56,819,78,530,3953.9589810000002,null,"2018-06-01",53254,34100,716,10275,893,6382,null,"2018-06-01",4741,2818,56,819,78,544,3965.8975359999999]
[null,null,null,null,"2022-01-01","ELD",378,null,null,null,null,null,null,null,null,null,null,"2018-07-01",4459,2817,51,939,69,485,4291.491051,null,"2018-07-01",53224,34010,703,10305,875,6310,null,"2018-07-01",4848,2817,51,939,69,502,4339.6875689999997]
[null,null,null,null,"2022-02-01","ELD",317,null,null,null,null,null,null,null,null,null,null,"2018-08-01",4500,2911,57,905,76,495,4343.665696,null,"2018-08-01",52946,33997,698,10309,879,6257,null,"2018-08-01",4892,2911,57,905,76,505,4379.1376630000004]
[null,null,null,null,"2022-03-01","ELD",445,null,null,null,null,null,null,null,null,null,null,"2018-09-01",4346,2565,50,848,60,428,4272.0774760000004,null,"2018-09-01",52784,33674,691,10334,874,6165,null,"2018-09-01",4735,2565,50,848,60,443,4282.2780130000001]
[null,null,null,null,"2022-04-01","ELD",357,null,null,null,null,null,null,null,null,null,null,"2018-10-01",4910,3010,48,985,70,544,4282.5679769999997,null,"2018-10-01",52866,33629,675,10425,860,6167,null,"2018-10-01",5369,3010,48,985,70,560,4335.4767499999998]
[null,null,null,null,"2022-05-01","ELD",459,null,null,null,null,null,null,null,null,null,null,"2018-11-01",4770,3053,54,979,59,616,4333.2169800000001,null,"2018-11-01",52851,33567,677,10482,830,6221,null,"2018-11-01",5180,3053,54,979,59,627,4329.4685639999998]
[null,null,null,null,"2022-06-01","ELD",485,null,null,null,null,null,null,null,null,null,null,"2018-12-01",3126,2557,43,742,48,461,3924.0701730000001,null,"2018-12-01",52735,33508,662,10458,805,6246,null,"2018-12-01",3432,2557,43,742,48,471,3918.6642459999998]
[null,null,null,null,"2022-07-01","ELD",427,null,null,null,null,null,null,null,null,null,null,"2019-01-01",4220,3001,60,818,82,516,4202.5022479999998,null,"2019-01-01",52243,33632,675,10386,812,6257,null,"2019-01-01",4652,3001,60,818,82,538,4257.2791070000003]
[null,null,null,null,"2021-05-01","PL",2038,null,null,null,null,null,null,null,null,null,null,"2019-02-01",4183,2096,55,615,66,535,3943.7700559999998,null,"2019-02-01",51881,33457,678,10257,817,6250,null,"2019-02-01",4582,2096,55,615,66,546,3956.2582050000001]
[null,null,null,null,"2021-06-01","PL",3252,null,null,null,null,null,null,null,null,null,null,"2019-03-01",4399,2831,45,773,82,624,4377.1120190000001,null,"2019-03-01",51860,33318,650,10137,818,6309,null,"2019-03-01",4831,2831,45,773,82,643,4356.284447]
[null,null,null,null,"2021-07-01","PL",3274,null,null,null,null,null,null,null,null,null,null,"2019-04-01",3997,2782,50,729,69,502,4226.2633660000001,null,"2019-04-01",51590,33328,631,10041,832,6286,null,"2019-04-01",4401,2782,50,729,69,514,4257.751381]
[null,null,null,null,"2021-08-01","PL",3283,null,null,null,null,null,null,null,null,null,null,"2019-05-01",3991,2882,45,850,72,528,4206.9716660000004,null,"2019-05-01",51234,33323,614,10002,831,6264,null,"2019-05-01",4374,2882,45,850,72,545,4283.9964950000003]
[null,null,null,null,"2021-09-01","PL",3623,null,null,null,null,null,null,null,null,null,null,"2019-06-01",3754,2614,61,729,79,465,4237.3921289999998,null,"2019-06-01",50655,33119,619,9912,832,6199,null,"2019-06-01",4188,2614,61,729,79,476,4252.704495]
[null,null,null,null,"2021-10-01","PL",3479,null,null,null,null,null,null,null,null,null,null,"2019-07-01",4613,2851,52,889,78,551,4510.4612880000004,null,"2019-07-01",50809,33153,620,9862,841,6265,null,"2019-07-01",5078,2851,52,889,78,569,4552.9510890000001]
[null,null,null,null,"2021-11-01","PL",3500,null,null,null,null,null,null,null,null,null,null,"2019-08-01",3807,2607,44,780,82,457,4378.5160169999999,null,"2019-08-01",50116,32849,607,9737,847,6227,null,"2019-08-01",4784,2607,44,780,82,472,4406.4034320000001]
[null,null,null,null,"2021-12-01","PL",2480,null,null,null,null,null,null,null,null,null,null,"2019-09-01",3285,2851,45,785,57,456,4211.2546709999997,null,"2019-09-01",49055,33135,602,9674,844,6255,null,"2019-09-01",4514,2850,45,791,59,480,4234.2869369999999]
[null,null,null,null,"2022-01-01","PL",3131,null,null,null,null,null,null,null,null,null,null,"2019-10-01",3332,2209,48,627,60,463,4477.5553989999999,null,"2019-10-01",47477,32334,602,9316,834,6174,null,"2019-10-01",4860,2554,67,851,89,550,4512.5319449999997]
[null,null,null,null,"2022-02-01","PL",3195,null,null,null,null,null,null,null,null,null,null,"2019-11-01",3040,1857,24,602,52,438,4161.2827619999998,null,"2019-11-01",45747,31138,572,8939,827,5996,null,"2019-11-01",4516,2210,40,806,77,511,4165.4439329999996]
[null,null,null,null,"2022-03-01","PL",3465,null,null,null,null,null,null,null,null,null,null,"2019-12-01",2331,1756,31,493,41,375,4205.7542400000002,null,"2019-12-01",44952,30337,560,8690,820,5910,null,"2019-12-01",3415,2110,43,724,58,430,4213.0240460000005]
[null,null,null,null,"2022-04-01","PL",2783,null,null,null,null,null,null,null,null,null,null,"2020-01-01",3195,1876,23,565,49,453,4324.849072,null,"2020-01-01",43927,29212,523,8437,787,5847,null,"2020-01-01",4668,2270,40,806,62,515,4338.7701550000002]
[null,null,null,null,"2022-05-01","PL",3127,null,null,null,null,null,null,null,null,null,null,"2020-02-01",3106,1461,28,487,56,414,4226.9638880000002,null,"2020-02-01",42850,28577,496,8309,777,5726,null,"2020-02-01",4534,1714,41,689,84,491,4327.5731969999997]
[null,null,null,null,"2022-06-01","PL",2904,null,null,null,null,null,null,null,null,null,null,"2020-03-01",3001,2024,46,595,49,415,4475.336843,null,"2020-03-01",41452,27770,497,8131,744,5517,null,"2020-03-01",4310,2417,70,878,74,497,4435.1404220000004]
[null,null,null,null,"2022-07-01","PL",2981,null,null,null,null,null,null,null,null,null,null,"2020-04-01",1982,1961,34,520,47,404,4497.4975240000003,null,"2020-04-01",39437,26949,481,7922,722,5419,null,"2020-04-01",2857,2362,49,754,67,463,4444.0043409999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-01",1610,1498,24,416,51,319,4405.1642000000002,null,"2020-05-01",37056,25565,460,7488,701,5210,null,"2020-05-01",2284,1801,32,608,72,392,4446.4218870000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-01",2001,1342,27,357,40,302,4546.8443699999998,null,"2020-06-01",35303,24293,426,7116,662,5047,null,"2020-06-01",2713,1512,42,513,56,361,4457.8814949999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-01",2368,1213,25,351,33,259,4829.2821999999996,null,"2020-07-01",33058,22655,399,6578,617,4755,null,"2020-07-01",3147,1378,37,488,47,310,4767.5551290000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-01",2183,1182,23,319,24,213,4922.9423939999997,null,"2020-08-01",31434,21230,378,6117,559,4511,null,"2020-08-01",2544,1217,30,422,35,228,4843.45057]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-09-01",2801,1437,25,400,32,291,4382.6979380000002,null,"2020-09-01",30950,19816,358,5732,534,4346,null,"2020-09-01",3548,1629,35,545,51,325,4378.5079999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-10-01",2789,1584,29,406,32,277,4682.3836819999997,null,"2020-10-01",30407,19191,339,5511,506,4160,null,"2020-10-01",3817,1749,41,623,49,328,4633.476463]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-01",2359,1706,35,451,30,301,4826.3602989999999,null,"2020-11-01",29726,19040,350,5360,484,4023,null,"2020-11-01",3172,1907,48,624,43,343,4743.3511660000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-01",1904,1627,22,360,35,243,4396.211687,null,"2020-12-01",29299,18911,341,5227,478,3891,null,"2020-12-01",2510,1794,29,576,55,306,4367.7515030000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01",2718,1348,17,339,25,297,4460.3716489999997,null,"2021-01-01",28822,18383,335,5001,454,3735,null,"2021-01-01",2953,1521,21,529,43,356,4548.3069660000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-01",2867,1178,24,349,39,315,4674.707555,null,"2021-02-01",28583,18100,331,4863,437,3636,null,"2021-02-01",1671,1046,23,324,34,303,4595.1910230000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-01",3341,1748,44,588,50,408,4982.4639699999998,null,"2021-03-01",28923,17824,329,4856,438,3629,null,"2021-03-01",3276,1716,44,588,50,408,4982.4639699999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01",2758,1535,32,528,59,336,4674.7768450000003,null,"2021-04-01",29699,17398,327,4864,450,3561,null,"2021-04-01",2692,1432,32,528,59,338,4664.8669229999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01",2797,1319,31,474,60,297,5076.2545449999998,null,"2021-05-01",30886,17219,334,4922,459,3539,null,"2021-05-01",2707,1219,31,474,60,297,5076.2545449999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-01",3252,1603,43,547,61,337,4955.3352519999999,null,"2021-06-01",32137,17480,350,5112,480,3574,null,"2021-06-01",3066,1555,43,547,61,338,4990.9703550000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01",3274,1626,32,552,56,313,4951.6493609999998,null,"2021-07-01",33043,17893,357,5313,503,3628,null,"2021-07-01",3155,1538,32,552,56,313,4951.6493609999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-01",3283,1748,29,527,45,292,5154.3392800000001,null,"2021-08-01",34143,18459,363,5521,524,3707,null,"2021-08-01",3244,1660,29,527,45,294,5183.9015980000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01",3623,1695,35,544,43,292,4987.7054790000002,null,"2021-09-01",34965,18717,373,5665,535,3708,null,"2021-09-01",3530,1600,35,544,43,293,4979.2150170000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-01",3479,1662,34,600,61,314,4877.8331520000002,null,"2021-10-01",35655,18795,378,5859,564,3745,null,"2021-10-01",3347,1583,34,600,61,315,4870.601936]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01",3500,1771,36,618,40,321,4926.1740799999998,null,"2021-11-01",36796,18860,379,6026,574,3765,null,"2021-11-01",3381,1680,36,618,40,322,4918.6393779999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-01",2480,1698,29,545,36,304,5018.3607890000003,null,"2021-12-01",37372,18931,386,6211,575,3826,null,"2021-12-01",2388,1611,29,545,36,305,5012.3989499999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01",3131,1579,22,576,49,347,4711.8729679999997,null,"2022-01-01",37785,19162,391,6448,599,3876,null,"2022-01-01",3017,1515,22,576,49,347,4723.2562529999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-01",3195,1196,34,460,48,317,4906.1417350000002,null,"2022-02-01",38113,19180,401,6559,608,3878,null,"2022-02-01",3075,1158,34,460,48,318,4899.5186469999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-01",3465,1881,58,684,55,344,4539.5586620000004,null,"2022-03-01",38237,19313,415,6655,613,3814,null,"2022-03-01",3300,1795,58,684,55,345,4537.9947240000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",2783,1491,43,533,58,293,4829.560853,null,"2022-04-01",38262,19269,426,6660,612,3771,null,"2022-04-01",2624,1425,43,533,58,293,4829.560853]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",3127,1604,47,591,47,366,4777.5615299999999,null,"2022-05-01",38592,19554,442,6777,599,3840,null,"2022-05-01",3003,1533,47,591,47,366,4777.5615299999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01",2904,1511,53,511,50,333,4807.4264860000003,null,"2022-06-01",38244,19462,452,6741,588,3836,null,"2022-06-01",2851,1480,53,511,50,333,4807.4264860000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",2981,1525,42,526,54,283,4909.1396809999997,null,"2022-07-01",37951,19361,462,6715,586,3806]

{"sheet":"Year Calculations","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Period","CNFs sent","CNFs left at stage 1","Stage 2 exit","Exit process","Court pack","Settled claims"]
["2013-14",{"$f":"SUM('Backing Sheet Data'!S4:S15)","v":53633},{"$f":"SUM('Backing Sheet Data'!T4:T15)","v":26357},{"$f":"SUM('Backing Sheet Data'!U4:U15)","v":216},{"$f":"SUM('Backing Sheet Data'!V4:V15)","v":5444},{"$f":"SUM('Backing Sheet Data'!W4:W15)","v":63},{"$f":"SUM('Backing Sheet Data'!X4:X15)","v":1870}]
["2014-15",{"$f":"SUM('Backing Sheet Data'!S16:S27)","v":75827},{"$f":"SUM('Backing Sheet Data'!T16:T27)","v":46146},{"$f":"SUM('Backing Sheet Data'!U16:U27)","v":753},{"$f":"SUM('Backing Sheet Data'!V16:V27)","v":11699},{"$f":"SUM('Backing Sheet Data'!W16:W27)","v":396},{"$f":"SUM('Backing Sheet Data'!X16:X27)","v":7393}]
["2015-16",{"$f":"SUM('Backing Sheet Data'!S28:S39)","v":63735},{"$f":"SUM('Backing Sheet Data'!T28:T39)","v":40507},{"$f":"SUM('Backing Sheet Data'!U28:U39)","v":905},{"$f":"SUM('Backing Sheet Data'!V28:V39)","v":11514},{"$f":"SUM('Backing Sheet Data'!W28:W39)","v":579},{"$f":"SUM('Backing Sheet Data'!X28:X39)","v":7712}]
["2016-17",{"$f":"SUM('Backing Sheet Data'!S40:S51)","v":56041},{"$f":"SUM('Backing Sheet Data'!T40:T51)","v":34925},{"$f":"SUM('Backing Sheet Data'!U40:U51)","v":841},{"$f":"SUM('Backing Sheet Data'!V40:V51)","v":10261},{"$f":"SUM('Backing Sheet Data'!W40:W51)","v":789},{"$f":"SUM('Backing Sheet Data'!X40:X51)","v":6965}]
["2017-18",{"$f":"SUM('Backing Sheet Data'!S52:S63)","v":53224},{"$f":"SUM('Backing Sheet Data'!T52:T63)","v":34010},{"$f":"SUM('Backing Sheet Data'!U52:U63)","v":703},{"$f":"SUM('Backing Sheet Data'!V52:V63)","v":10305},{"$f":"SUM('Backing Sheet Data'!W52:W63)","v":875},{"$f":"SUM('Backing Sheet Data'!X52:X63)","v":6310}]
["2018-19",{"$f":"SUM('Backing Sheet Data'!S64:S75)","v":50809},{"$f":"SUM('Backing Sheet Data'!T64:T75)","v":33153},{"$f":"SUM('Backing Sheet Data'!U64:U75)","v":620},{"$f":"SUM('Backing Sheet Data'!V64:V75)","v":9862},{"$f":"SUM('Backing Sheet Data'!W64:W75)","v":841},{"$f":"SUM('Backing Sheet Data'!X64:X75)","v":6265}]
["2019-20",{"$f":"SUM('Backing Sheet Data'!S76:S87)","v":33058},{"$f":"SUM('Backing Sheet Data'!T76:T87)","v":22655},{"$f":"SUM('Backing Sheet Data'!U76:U87)","v":399},{"$f":"SUM('Backing Sheet Data'!V76:V87)","v":6578},{"$f":"SUM('Backing Sheet Data'!W76:W87)","v":617},{"$f":"SUM('Backing Sheet Data'!X76:X87)","v":4755}]
["2020-21",{"$f":"SUM('Backing Sheet Data'!S88:S118)","v":70994},{"$f":"SUM('Backing Sheet Data'!T88:T118)","v":37254},{"$f":"SUM('Backing Sheet Data'!U88:U118)","v":819},{"$f":"SUM('Backing Sheet Data'!V88:V118)","v":12028},{"$f":"SUM('Backing Sheet Data'!W88:W118)","v":1089},{"$f":"SUM('Backing Sheet Data'!X88:X118)","v":7434}]