{"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":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,0,5,2],[4,3,5,4],[4,5,5,8],[8,11,8,12],[8,9,8,10],[8,7,8,8],[6,0,7,12],[8,0,8,6],[0,0,1,2],[2,0,3,2],[0,3,1,4],[2,3,3,4],[0,5,1,8],[2,5,3,8],[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],[9,0,9,6],[10,0,10,6],[11,0,11,6],[15,0,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[12,0,13,12],[16,0,16,6],[16,7,16,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],[4,15,5,16],[0,17,1,20],[2,17,3,20],[4,17,5,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,15,1,16],[2,15,3,16],[4,21,5,22],[0,23,1,25],[2,23,3,25],[4,23,5,25],[0,26,1,27],[2,26,3,27],[4,26,5,27],[2,21,3,22],[0,21,1,22]]}
["Total Sent:",null,null,2257,null,"Left process at stage 1:",null,null,null,1080,null,"Left process at stage 2:",null,null,null,79,null,"Exited process:",null,null,null,543,null,"Settled:",null,null,334]
[]
["Δ from last month:",null,null,-80,null,"Δ from last month:",null,null,null,68,null,"Δ from last month:",null,null,null,-14,null,"Δ from last month:",null,null,null,35,null,"Δ from last month:",null,null,-49]
[]
["Rolling 12 months:",null,null,29653,null,"Rolling 12 months:",null,null,null,12599,null,"Rolling 12 months:",null,null,null,967,null,"Rolling 12 months:",null,null,null,7147,null,"Rolling 12 months:",null,null,4447]
[]
["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,909,null,841,null,68]
["Other",null,null,null,null,null,null,171,null,171,null,0]
["Total",null,null,null,null,null,null,1080,null,1012,null,68]
["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,36,null,52,null,-16]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,42,null,40,null,2]
["Total",null,null,null,null,null,null,79,null,93,null,-14]

{"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,339273,164375,5003,74874,4987,55137,437334.81813399994]
[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",206,5,0,13,0,1,1500,null,"2013-08-01",null,null,null,null,null,null,null,"2013-08-01",207,5,0,13,0,1,1500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01",919,53,0,54,0,2,2051,null,"2013-09-01",null,null,null,null,null,null,null,"2013-09-01",922,53,0,54,0,2,2051]
["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",1874,321,0,134,0,16,1721.875,null,"2013-10-01",null,null,null,null,null,null,null,"2013-10-01",1876,321,0,134,0,16,1721.875]
["2021-08-01",29424,null,null,"2021-08-01",4881.4964239999999,null,null,909,171,1,0,36,42,null,null,null,"2013-11-01",2246,633,1,159,0,29,2277.0844820000002,null,"2013-11-01",null,null,null,null,null,null,null,"2013-11-01",2258,633,1,159,0,29,2277.0844820000002]
["2021-09-01",29197,null,null,"2021-09-01",4801.2036280000002,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01",1983,822,6,166,0,47,2127.1344680000002,null,"2013-12-01",null,null,null,null,null,null,null,"2013-12-01",1997,822,6,166,0,47,2127.1344680000002]
["2021-10-01",29405,null,null,"2021-10-01",4721.5458639999997,null,null,"CNF Sent Monthly Volumes Chart Data",null,null,null,null,null,null,null,null,"2014-01-01",3182,1113,5,264,0,110,2256.937727,null,"2014-01-01",null,null,null,null,null,null,null,"2014-01-01",3201,1113,5,264,0,110,2256.937727]
["2021-11-01",29542,null,null,"2021-11-01",5030.5750580000004,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01",3160,1061,10,304,2,145,2444.0285509999999,null,"2014-02-01",null,null,null,null,null,null,null,"2014-02-01",3185,1061,10,304,2,145,2444.0285509999999]
["2021-12-01",29674,null,null,"2021-12-01",5112.0429620000004,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2014-03-01",3560,1491,16,336,1,178,2542.0238760000002,null,"2014-03-01",null,null,null,null,null,null,null,"2014-03-01",3588,1491,16,336,1,178,2542.0238760000002]
["2022-01-01",29746,null,null,"2022-01-01",4867.4547670000002,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total",null,null,null,"2014-04-01",3530,1598,23,434,8,213,2705.4804220000001,null,"2014-04-01",null,null,null,null,null,null,null,"2014-04-01",3555,1598,23,434,8,213,2705.4804220000001]
["2022-02-01",29853,null,null,"2022-02-01",4875.2269560000004,null,null,"2021-08-01",11505,3283,318,2481,17587,null,null,null,"2014-05-01",3643,1642,27,440,5,291,2969.232027,null,"2014-05-01",null,null,null,null,null,null,null,"2014-05-01",3660,1642,27,440,5,291,2969.232027]
["2022-03-01",29880,null,null,"2022-03-01",4734.9004850000001,null,null,"2021-09-01",11300,3623,343,2730,17996,null,null,null,"2014-06-01",3926,1838,36,532,5,380,2919.2788679999999,null,"2014-06-01",null,null,null,null,null,null,null,"2014-06-01",3953,1838,36,532,5,380,2919.2788679999999]
["2022-04-01",29634,null,null,"2022-04-01",4986.0442130000001,null,null,"2021-10-01",10043,3479,357,2566,16445,null,null,null,"2014-07-01",4620,2008,39,645,10,440,3054.5619999999999,null,"2014-07-01",32849,12585,163,3481,31,1852,null,"2014-07-01",4655,2008,39,645,10,440,3054.5619999999999]
["2022-05-01",29946,null,null,"2022-05-01",5118.0826100000004,null,null,"2021-11-01",9821,3500,427,2681,16429,null,null,null,"2014-08-01",4010,1903,35,619,9,407,3105.700147,null,"2014-08-01",36653,14483,198,4087,40,2258,null,"2014-08-01",4045,1903,35,619,9,407,3105.700147]
["2022-06-01",29908,null,null,"2022-06-01",5258.2505739999997,null,null,"2021-12-01",7687,2480,273,2035,12475,null,null,null,"2014-09-01",4550,2145,54,705,9,481,3220.6174839999999,null,"2014-09-01",40284,16575,252,4738,49,2737,null,"2014-09-01",4584,2145,54,705,9,481,3220.6174839999999]
["2022-07-01",29653,null,null,"2022-07-01",4974.6811369999996,null,null,"2022-01-01",8745,3131,378,2473,14727,null,null,null,"2014-10-01",5060,2268,60,804,15,548,3327.2815139999998,null,"2014-10-01",43470,18522,312,5408,64,3269,null,"2014-10-01",5108,2268,60,804,15,548,3327.2815139999998]
[null,null,null,null,"Grand Total",59361.504677999998,null,null,"2022-02-01",7871,3195,317,2477,13860,null,null,null,"2014-11-01",4293,2101,44,730,22,566,3242.3573139999999,null,"2014-11-01",45517,19990,355,5979,86,3806,null,"2014-11-01",4333,2101,44,730,22,566,3242.3573139999999]
[null,null,null,null,null,null,null,null,"2022-03-01",8218,3465,445,2820,14948,null,null,null,"2014-12-01",3669,2202,62,806,10,565,3324.7293450000002,null,"2014-12-01",47203,21370,411,6619,96,4324,null,"2014-12-01",3714,2202,62,806,10,565,3324.7293450000002]
[null,null,null,null,null,null,null,null,"2022-04-01",7247,2783,357,2201,12588,null,null,null,"2015-01-01",4484,2034,48,778,22,606,3382.2266989999998,null,"2015-01-01",48505,22291,454,7133,118,4820,null,"2015-01-01",4526,2034,48,778,22,606,3382.2266989999998]
[null,81011,null,null,"CNF Sent Monthly Volumes",null,null,null,"2022-05-01",7876,3127,459,2528,13990,null,null,null,"2015-02-01",4689,1712,41,793,20,670,3301.2692229999998,null,"2015-02-01",50034,22942,485,7622,136,5345,null,"2015-02-01",4741,1712,41,793,20,670,3301.2692229999998]
["Exit Process Reason","Total",null,null,null,null,null,null,"2022-06-01",7289,2904,485,2404,13082,null,null,null,"2015-03-01",4985,2420,56,920,25,792,3425.002739,null,"2015-03-01",51459,23871,525,8206,160,5959,null,"2015-03-01",5059,2420,56,920,25,792,3425.002739]
["Other",34664,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2022-07-01",7438,2981,427,2257,13103,null,null,null,"2015-04-01",4220,2089,52,881,22,704,3453.6639060000002,null,"2015-04-01",52149,24362,554,8653,174,6450,null,"2015-04-01",4283,2089,52,881,22,704,3453.6639060000002]
["Claim requires further investigation",31042,null,null,"2021-05-01","RTA",26904,null,"Grand Total",105040,37951,4586,29653,177230,null,null,null,"2015-05-01",4155,2031,58,809,25,614,3457.9096570000002,null,"2015-05-01",52661,24751,585,9022,194,6773,null,"2015-05-01",4222,2031,58,809,25,614,3457.9096570000002]
["Duplicated claim",6162,null,null,"2021-06-01","RTA",26133,null,null,null,null,null,null,null,null,null,null,"2015-06-01",4622,2297,72,982,43,781,3544.529884,null,"2015-06-01",53357,25210,621,9472,232,7174,null,"2015-06-01",4697,2297,72,982,43,781,3544.529884]
["Value of claim exceeds the upper limit",4206,null,null,"2021-07-01","RTA",14787,null,null,null,null,null,null,null,null,null,null,"2015-07-01",4955,2396,61,961,37,770,3533.7322199999999,null,"2015-07-01",53692,25598,643,9788,259,7504,null,"2015-07-01",5042,2396,61,961,37,770,3533.7322199999999]
["Incomplete information provided on CNF",1783,null,null,"2021-08-01","RTA",11505,null,null,null,null,null,null,null,null,null,null,"2015-08-01",4228,2113,65,938,30,720,3599.9857499999998,null,"2015-08-01",53910,25808,673,10107,280,7817,null,"2015-08-01",4289,2113,65,938,30,720,3599.9857499999998]
["Withdrawal of claim",1726,null,null,"2021-09-01","RTA",11300,null,null,null,null,null,null,null,null,null,null,"2015-09-01",4489,2356,65,964,22,718,3670.9074230000001,null,"2015-09-01",53849,26019,684,10366,293,8054,null,"2015-09-01",4607,2356,65,964,22,718,3670.9074230000001]
["Claim is too complex for process",847,null,null,"2021-10-01","RTA",10043,null,null,null,null,null,null,null,null,null,null,"2015-10-01",4408,2220,66,859,27,714,3798.0564420000001,null,"2015-10-01",53197,25971,690,10421,305,8220,null,"2015-10-01",4508,2220,66,859,27,714,3798.0564420000001]
["Value of claim below ú1,000",339,null,null,"2021-11-01","RTA",9821,null,null,null,null,null,null,null,null,null,null,"2015-11-01",4278,2175,73,936,34,782,3849.7272889999999,null,"2015-11-01",53182,26045,719,10627,317,8436,null,"2015-11-01",4373,2175,73,936,34,782,3849.7272889999999]
["Withdrawal of offer",209,null,null,"2021-12-01","RTA",7687,null,null,null,null,null,null,null,null,null,null,"2015-12-01",3343,2128,80,912,48,715,3735.6251600000001,null,"2015-12-01",52856,25971,737,10733,355,8586,null,"2015-12-01",3437,2128,80,912,48,715,3735.6251600000001]
["Interim payment for child claimant",33,null,null,"2022-01-01","RTA",8745,null,null,null,null,null,null,null,null,null,null,"2016-01-01",3879,1969,76,892,34,632,3785.1946670000002,null,"2016-01-01",52251,25906,765,10847,367,8612,null,"2016-01-01",4002,1969,76,892,34,632,3785.1946670000002]
[null,null,null,null,"2022-02-01","RTA",7871,null,null,null,null,null,null,null,null,null,null,"2016-02-01",4150,1715,70,819,37,697,3956.9560110000002,null,"2016-02-01",51712,25909,794,10873,384,8639,null,"2016-02-01",4287,1715,70,819,37,697,3956.9560110000002]
[null,null,null,null,"2022-03-01","RTA",8218,null,null,null,null,null,null,null,null,null,null,"2016-03-01",4288,2180,74,900,35,775,3939.0959870000002,null,"2016-03-01",51015,25669,812,10853,394,8622,null,"2016-03-01",4445,2180,74,900,35,775,3939.0959870000002]
[null,null,null,null,"2022-04-01","RTA",7247,null,null,null,null,null,null,null,null,null,null,"2016-04-01",4142,2093,93,998,39,778,3994.2077370000002,null,"2016-04-01",50937,25673,853,10970,411,8696,null,"2016-04-01",4292,2093,93,998,39,778,3994.2077370000002]
[null,null,null,null,"2022-05-01","RTA",7876,null,null,null,null,null,null,null,null,null,null,"2016-05-01",3960,2022,70,868,36,706,3829.4240930000001,null,"2016-05-01",50742,25664,865,11029,422,8788,null,"2016-05-01",4115,2022,70,868,36,706,3829.4240930000001]
[null,null,null,null,"2022-06-01","RTA",7289,null,null,null,null,null,null,null,null,null,null,"2016-06-01",3323,2071,104,1019,57,700,4012.5146,null,"2016-06-01",49443,25438,897,11066,436,8707,null,"2016-06-01",3492,2071,104,1019,57,700,4012.5146]
[null,null,null,null,"2022-07-01","RTA",7438,null,null,null,null,null,null,null,null,null,null,"2016-07-01",3260,1663,86,805,51,661,3978.0093339999999,null,"2016-07-01",47748,24705,922,10910,450,8598,null,"2016-07-01",3412,1663,86,805,51,661,3978.0093339999999]
[null,null,null,null,"2021-05-01","EL",1711,null,null,null,null,null,null,null,null,null,null,"2016-08-01",4108,1290,54,595,28,525,4361.6228380000002,null,"2016-08-01",47628,23882,911,10567,448,8403,null,"2016-08-01",4289,1290,54,595,28,525,4361.6228380000002]
[null,null,null,null,"2021-06-01","EL",2442,null,null,null,null,null,null,null,null,null,null,"2016-09-01",4216,2104,98,1002,64,637,4278.0727939999997,null,"2016-09-01",47355,23630,944,10605,490,8322,null,"2016-09-01",4403,2104,98,1002,64,641,4287.550733]
[null,null,null,null,"2021-07-01","EL",2512,null,null,null,null,null,null,null,null,null,null,"2016-10-01",3785,1984,56,973,57,651,3820.7528870000001,null,"2016-10-01",46732,23394,934,10719,520,8259,null,"2016-10-01",4014,1984,56,973,57,652,3817.9603219999999]
[null,null,null,null,"2021-08-01","EL",2481,null,null,null,null,null,null,null,null,null,null,"2016-11-01",3882,2112,75,936,72,667,4062.9838679999998,null,"2016-11-01",46336,23331,936,10719,558,8144,null,"2016-11-01",4247,2112,75,936,72,675,4087.7506960000001]
[null,null,null,null,"2021-09-01","EL",2730,null,null,null,null,null,null,null,null,null,null,"2016-12-01",2857,1858,71,784,61,560,3897.5422669999998,null,"2016-12-01",45850,23061,927,10591,571,7989,null,"2016-12-01",3176,1858,71,784,61,574,3893.9097029999998]
[null,null,null,null,"2021-10-01","EL",2566,null,null,null,null,null,null,null,null,null,null,"2017-01-01",3561,1800,64,915,57,649,4093.7307700000001,null,"2017-01-01",45532,22892,915,10614,594,8006,null,"2017-01-01",3993,1800,64,915,57,666,4096.5334380000004]
[null,null,null,null,"2021-11-01","EL",2681,null,null,null,null,null,null,null,null,null,null,"2017-02-01",3694,1537,72,760,63,635,4075.356362,null,"2017-02-01",45076,22714,917,10555,620,7944,null,"2017-02-01",4102,1537,72,760,63,659,4069.9781330000001]
[null,null,null,null,"2021-12-01","EL",2035,null,null,null,null,null,null,null,null,null,null,"2017-03-01",4102,2134,48,1057,69,735,4036.743469,null,"2017-03-01",44890,22668,891,10712,654,7904,null,"2017-03-01",4546,2134,48,1057,69,763,4015.2108119999998]
[null,null,null,null,"2022-01-01","EL",2473,null,null,null,null,null,null,null,null,null,null,"2017-04-01",3041,1640,60,723,54,594,4026.9603189999998,null,"2017-04-01",43789,22215,858,10437,669,7720,null,"2017-04-01",3367,1640,60,723,54,617,4083.9455910000001]
[null,null,null,null,"2022-02-01","EL",2477,null,null,null,null,null,null,null,null,null,null,"2017-05-01",3716,1903,57,921,63,611,4087.6201139999998,null,"2017-05-01",43545,22096,845,10490,696,7625,null,"2017-05-01",4078,1903,57,921,63,627,4107.9435080000003]
[null,null,null,null,"2022-03-01","EL",2820,null,null,null,null,null,null,null,null,null,null,"2017-06-01",3598,1934,63,950,90,612,4227.0669280000002,null,"2017-06-01",43820,21959,804,10421,729,7537,null,"2017-06-01",3973,1934,63,950,90,628,4217.261082]
[null,null,null,null,"2022-04-01","EL",2201,null,null,null,null,null,null,null,null,null,null,"2017-07-01",3199,1813,52,818,47,597,4145.1694630000002,null,"2017-07-01",43759,22109,770,10434,725,7473,null,"2017-07-01",3518,1813,52,818,47,618,4173.3238339999998]
[null,null,null,null,"2022-05-01","EL",2528,null,null,null,null,null,null,null,null,null,null,"2017-08-01",3561,1707,60,870,79,642,3989.100015,null,"2017-08-01",43212,22526,776,10709,776,7590,null,"2017-08-01",3963,1707,60,870,79,661,4001.1070800000002]
[null,null,null,null,"2022-06-01","EL",2404,null,null,null,null,null,null,null,null,null,null,"2017-09-01",3273,1662,57,842,95,578,4148.2500339999997,null,"2017-09-01",42269,22084,735,10549,807,7531,null,"2017-09-01",3646,1662,57,842,95,591,4158.863824]
[null,null,null,null,"2022-07-01","EL",2257,null,null,null,null,null,null,null,null,null,null,"2017-10-01",3765,1787,71,949,81,672,4132.3168450000003,null,"2017-10-01",42249,21887,750,10525,831,7552,null,"2017-10-01",4163,1787,71,949,81,690,4120.1839419999997]
[null,null,null,null,"2021-05-01","ELD",174,null,null,null,null,null,null,null,null,null,null,"2017-11-01",3714,1907,63,919,81,657,4371.4041699999998,null,"2017-11-01",42081,21682,738,10508,840,7542,null,"2017-11-01",4149,1907,63,919,81,674,4381.1367060000002]
[null,null,null,null,"2021-06-01","ELD",280,null,null,null,null,null,null,null,null,null,null,"2017-12-01",2507,1680,48,749,70,465,4270.6846880000003,null,"2017-12-01",41731,21504,715,10473,849,7447,null,"2017-12-01",2747,1680,48,749,70,475,4322.5657259999998]
[null,null,null,null,"2021-07-01","ELD",422,null,null,null,null,null,null,null,null,null,null,"2018-01-01",3801,1872,38,817,86,628,4307.6641079999999,null,"2018-01-01",41971,21576,689,10375,878,7426,null,"2018-01-01",4234,1872,38,817,86,641,4332.0016530000003]
[null,null,null,null,"2021-08-01","ELD",318,null,null,null,null,null,null,null,null,null,null,"2018-02-01",3551,1484,34,732,79,540,4220.8112220000003,null,"2018-02-01",41828,21523,651,10347,894,7331,null,"2018-02-01",3938,1484,34,732,79,548,4215.5804010000002]
[null,null,null,null,"2021-09-01","ELD",343,null,null,null,null,null,null,null,null,null,null,"2018-03-01",3552,1918,54,888,80,608,4122.6842429999997,null,"2018-03-01",41278,21307,657,10178,905,7204,null,"2018-03-01",3929,1918,54,888,80,630,4155.2111420000001]
[null,null,null,null,"2021-10-01","ELD",357,null,null,null,null,null,null,null,null,null,null,"2018-04-01",3514,1769,66,818,77,611,4136.0825359999999,null,"2018-04-01",41751,21436,663,10273,928,7221,null,"2018-04-01",3923,1769,66,818,77,621,4176.2120450000002]
[null,null,null,null,"2021-11-01","ELD",427,null,null,null,null,null,null,null,null,null,null,"2018-05-01",3455,1825,61,892,64,633,4077.707488,null,"2018-05-01",41490,21358,667,10244,929,7243,null,"2018-05-01",3859,1825,61,892,64,650,4069.7289839999999]
[null,null,null,null,"2021-12-01","ELD",273,null,null,null,null,null,null,null,null,null,null,"2018-06-01",3381,1902,43,887,104,674,4334.9801029999999,null,"2018-06-01",41273,21326,647,10181,943,7305,null,"2018-06-01",3761,1902,43,887,104,692,4359.973395]
[null,null,null,null,"2022-01-01","ELD",378,null,null,null,null,null,null,null,null,null,null,"2018-07-01",3561,1790,60,902,76,645,4345.1382169999997,null,"2018-07-01",41635,21303,655,10265,972,7353,null,"2018-07-01",3951,1790,60,902,76,661,4312.5024960000001]
[null,null,null,null,"2022-02-01","ELD",317,null,null,null,null,null,null,null,null,null,null,"2018-08-01",3456,1805,53,922,90,610,4209.8686879999996,null,"2018-08-01",41530,21401,648,10317,983,7321,null,"2018-08-01",3851,1805,53,922,90,623,4206.6214120000004]
[null,null,null,null,"2022-03-01","ELD",445,null,null,null,null,null,null,null,null,null,null,"2018-09-01",3416,1661,48,873,65,604,4259.8999830000002,null,"2018-09-01",41673,21400,639,10348,953,7347,null,"2018-09-01",3786,1661,48,873,65,624,4280.4160089999996]
[null,null,null,null,"2022-04-01","ELD",357,null,null,null,null,null,null,null,null,null,null,"2018-10-01",3703,1885,68,1006,78,638,4332.3587770000004,null,"2018-10-01",41611,21498,636,10405,950,7313,null,"2018-10-01",4134,1885,68,1006,78,659,4340.508194]
[null,null,null,null,"2022-05-01","ELD",459,null,null,null,null,null,null,null,null,null,null,"2018-11-01",3545,1841,57,880,73,669,4077.5747679999999,null,"2018-11-01",41442,21432,630,10366,942,7325,null,"2018-11-01",3949,1841,57,880,73,684,4075.4228800000001]
[null,null,null,null,"2022-06-01","ELD",485,null,null,null,null,null,null,null,null,null,null,"2018-12-01",2495,1635,62,746,73,522,4202.0800950000003,null,"2018-12-01",41430,21387,644,10363,945,7382,null,"2018-12-01",2771,1635,62,746,73,537,4212.3785470000003]
[null,null,null,null,"2022-07-01","ELD",427,null,null,null,null,null,null,null,null,null,null,"2019-01-01",3351,1790,57,857,93,693,4176.5880800000004,null,"2019-01-01",40980,21305,663,10403,952,7447,null,"2019-01-01",3782,1790,57,857,93,705,4196.3482830000003]
[null,null,null,null,"2021-05-01","PL",2038,null,null,null,null,null,null,null,null,null,null,"2019-02-01",3294,1346,63,658,75,588,4297.3759010000003,null,"2019-02-01",40723,21167,692,10329,948,7495,null,"2019-02-01",3699,1346,63,658,75,606,4299.0872600000002]
[null,null,null,null,"2021-06-01","PL",3252,null,null,null,null,null,null,null,null,null,null,"2019-03-01",3466,1814,49,796,70,706,4453.7949289999997,null,"2019-03-01",40637,21063,687,10237,938,7593,null,"2019-03-01",3887,1814,49,796,70,728,4496.9377329999998]
[null,null,null,null,"2021-07-01","PL",3274,null,null,null,null,null,null,null,null,null,null,"2019-04-01",3332,1793,45,805,67,678,4448.1273449999999,null,"2019-04-01",40455,21087,666,10224,928,7660,null,"2019-04-01",3776,1793,45,805,67,696,4499.8703159999995]
[null,null,null,null,"2021-08-01","PL",3283,null,null,null,null,null,null,null,null,null,null,"2019-05-01",3313,1900,48,916,79,676,4404.3989490000004,null,"2019-05-01",40313,21162,653,10248,943,7703,null,"2019-05-01",3724,1900,48,916,79,697,4442.9177760000002]
[null,null,null,null,"2021-09-01","PL",3623,null,null,null,null,null,null,null,null,null,null,"2019-06-01",3075,1674,48,883,72,581,4466.9445089999999,null,"2019-06-01",40007,20934,658,10244,911,7610,null,"2019-06-01",3444,1674,48,883,72,593,4511.205328]
[null,null,null,null,"2021-10-01","PL",3479,null,null,null,null,null,null,null,null,null,null,"2019-07-01",3594,1880,46,967,87,670,4403.9587160000001,null,"2019-07-01",40040,21024,644,10309,922,7635,null,"2019-07-01",4031,1880,46,968,87,692,4416.6319940000003]
[null,null,null,null,"2021-11-01","PL",3500,null,null,null,null,null,null,null,null,null,null,"2019-08-01",2948,1693,62,908,76,622,4287.6730219999999,null,"2019-08-01",39532,20912,653,10295,908,7647,null,"2019-08-01",3573,1693,62,908,76,643,4298.788646]
[null,null,null,null,"2021-12-01","PL",2480,null,null,null,null,null,null,null,null,null,null,"2019-09-01",2358,1776,42,851,95,618,4288.6034460000001,null,"2019-09-01",38474,21027,647,10273,938,7661,null,"2019-09-01",3421,1776,42,860,97,635,4307.3684880000001]
[null,null,null,null,"2022-01-01","PL",3131,null,null,null,null,null,null,null,null,null,null,"2019-10-01",2657,1199,37,710,59,631,4349.2818850000003,null,"2019-10-01",37428,20341,616,9977,919,7654,null,"2019-10-01",4027,1499,55,945,96,710,4367.018]
[null,null,null,null,"2022-02-01","PL",3195,null,null,null,null,null,null,null,null,null,null,"2019-11-01",2518,1170,38,609,57,622,4601.1253049999996,null,"2019-11-01",36401,19670,597,9706,903,7607,null,"2019-11-01",3796,1554,52,895,87,703,4512.4282499999999]
[null,null,null,null,"2022-03-01","PL",3465,null,null,null,null,null,null,null,null,null,null,"2019-12-01",1810,1186,39,529,46,453,4266.6174170000004,null,"2019-12-01",35716,19221,574,9489,876,7538,null,"2019-12-01",2719,1520,59,790,74,542,4269.6721580000003]
[null,null,null,null,"2022-04-01","PL",2783,null,null,null,null,null,null,null,null,null,null,"2020-01-01",2442,1238,39,619,63,513,4420.069434,null,"2020-01-01",34807,18669,556,9251,846,7358,null,"2020-01-01",3673,1611,54,948,106,616,4432.8075319999998]
[null,null,null,null,"2022-05-01","PL",3127,null,null,null,null,null,null,null,null,null,null,"2020-02-01",2383,908,24,482,49,536,4447.9414919999999,null,"2020-02-01",33896,18231,517,9075,820,7306,null,"2020-02-01",3658,1148,41,688,75,616,4438.7770119999996]
[null,null,null,null,"2022-06-01","PL",2904,null,null,null,null,null,null,null,null,null,null,"2020-03-01",2198,1270,41,543,51,550,4557.4318359999997,null,"2020-03-01",32628,17687,509,8822,801,7150,null,"2020-03-01",3424,1662,61,866,90,650,4519.3539689999998]
[null,null,null,null,"2022-07-01","PL",2981,null,null,null,null,null,null,null,null,null,null,"2020-04-01",1472,1131,34,554,52,471,4458.8145640000002,null,"2020-04-01",30768,17025,498,8571,786,6943,null,"2020-04-01",2207,1490,50,853,83,563,4459.2569439999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-01",1128,815,20,363,33,360,4867.035194,null,"2020-05-01",28583,15940,470,8018,740,6627,null,"2020-05-01",1650,1065,39,549,54,448,4698.7195529999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-01",1363,678,23,342,36,386,4846.4485489999997,null,"2020-06-01",26871,14944,445,7477,704,6432,null,"2020-06-01",1976,846,36,524,72,468,4892.8720940000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-01",1571,673,32,391,37,330,4833.2336660000001,null,"2020-07-01",24848,13737,431,6901,654,6092,null,"2020-07-01",2293,819,41,535,57,374,4706.51901]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-01",1460,694,21,320,28,234,4522.4515380000003,null,"2020-08-01",23360,12738,390,6313,606,5704,null,"2020-08-01",1846,798,30,427,44,254,4394.581338]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-09-01",1901,752,26,378,44,329,5004.8456530000003,null,"2020-09-01",22903,11714,374,5840,555,5415,null,"2020-09-01",2625,982,33,536,63,401,4991.5419949999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-10-01",1844,909,15,433,21,336,4948.8969939999997,null,"2020-10-01",22090,11424,352,5563,517,5120,null,"2020-10-01",2670,1134,26,659,40,417,4906.4452030000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-01",1595,872,19,434,21,354,4816.0112710000003,null,"2020-11-01",21167,11126,333,5388,481,4852,null,"2020-11-01",2230,1112,28,638,44,406,4773.7204179999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-01",1340,785,22,355,23,283,4542.3533559999996,null,"2020-12-01",20697,10725,316,5214,458,4682,null,"2020-12-01",1977,980,37,531,45,364,4694.4902739999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01",2035,786,19,388,30,319,4622.3392469999999,null,"2021-01-01",20290,10273,296,4983,425,4488,null,"2021-01-01",2223,992,26,584,44,383,4551.4091900000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-01",2430,676,25,392,28,358,4704.7649719999999,null,"2021-02-01",20337,10041,297,4893,404,4310,null,"2021-02-01",1502,614,23,380,25,343,4719.332332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-01",2833,1176,37,637,63,451,4852.8321059999998,null,"2021-03-01",20972,9947,293,4987,416,4211,null,"2021-03-01",2276,1164,37,637,63,451,4852.8321059999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01",2373,1028,45,597,57,413,4852.8830260000004,null,"2021-04-01",21873,9844,304,5030,421,4153,null,"2021-04-01",2315,993,45,597,57,414,4846.5958689999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01",2284,963,26,577,40,346,4777.0687859999998,null,"2021-05-01",23029,9992,310,5244,428,4139,null,"2021-05-01",2199,928,26,577,40,347,4774.8293940000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-01",2442,1044,35,561,46,383,4801.6840199999997,null,"2021-06-01",24108,10358,322,5463,438,4136,null,"2021-06-01",2288,1016,35,561,46,384,4795.169218]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01",2512,1030,37,567,54,377,4962.1281429999999,null,"2021-07-01",25049,10715,327,5639,455,4183,null,"2021-07-01",2442,992,37,567,54,378,4960.9055820000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-01",2481,1018,31,595,40,358,4881.4964239999999,null,"2021-08-01",26070,11039,337,5914,467,4307,null,"2021-08-01",2419,994,31,595,40,359,4906.8961550000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01",2730,1082,35,629,39,361,4801.2036280000002,null,"2021-09-01",26899,11369,346,6165,462,4339,null,"2021-09-01",2617,1055,35,629,39,361,4801.2036280000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-01",2566,1049,36,640,38,370,4721.5458639999997,null,"2021-10-01",27621,11509,367,6372,479,4373,null,"2021-10-01",2456,1019,36,640,38,371,4718.2532879999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01",2681,1150,43,713,45,425,5030.5750580000004,null,"2021-11-01",28707,11787,391,6651,503,4444,null,"2021-11-01",2609,1126,43,713,45,426,5028.1605630000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-01",2035,1065,38,577,35,351,5112.0429620000004,null,"2021-12-01",29402,12067,407,6873,515,4512,null,"2021-12-01",1952,1039,38,577,35,351,5112.0429620000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01",2473,1029,24,539,39,365,4867.4547670000002,null,"2022-01-01",29840,12310,412,7024,524,4558,null,"2022-01-01",2383,1000,24,539,39,365,4867.4547670000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-01",2477,817,32,521,43,345,4875.2269560000004,null,"2022-02-01",29887,12451,419,7153,539,4545,null,"2022-02-01",2396,801,32,521,43,346,4871.2523119999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-01",2820,1236,45,717,60,412,4734.9004850000001,null,"2022-03-01",29874,12511,427,7233,536,4506,null,"2022-03-01",2699,1208,45,717,60,412,4734.9004850000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",2201,975,42,561,47,337,4986.0442130000001,null,"2022-04-01",29702,12458,424,7197,526,4430,null,"2022-04-01",2101,948,42,561,47,336,4962.1931539999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",2528,1066,32,604,51,406,5118.0826100000004,null,"2022-05-01",29946,12561,430,7224,537,4490,null,"2022-05-01",2418,1044,32,604,51,406,5118.0826100000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01",2404,1032,53,508,40,383,5258.2505739999997,null,"2022-06-01",29908,12549,448,7171,531,4490,null,"2022-06-01",2337,1012,53,508,40,383,5258.2505739999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",2257,1080,37,543,42,334,4974.6811369999996,null,"2022-07-01",29653,12599,448,7147,519,4447]

{"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":32849},{"$f":"SUM('Backing Sheet Data'!T4:T15)","v":12585},{"$f":"SUM('Backing Sheet Data'!U4:U15)","v":163},{"$f":"SUM('Backing Sheet Data'!V4:V15)","v":3481},{"$f":"SUM('Backing Sheet Data'!W4:W15)","v":31},{"$f":"SUM('Backing Sheet Data'!X4:X15)","v":1852}]
["2014-15",{"$f":"SUM('Backing Sheet Data'!S16:S27)","v":53692},{"$f":"SUM('Backing Sheet Data'!T16:T27)","v":25598},{"$f":"SUM('Backing Sheet Data'!U16:U27)","v":643},{"$f":"SUM('Backing Sheet Data'!V16:V27)","v":9788},{"$f":"SUM('Backing Sheet Data'!W16:W27)","v":259},{"$f":"SUM('Backing Sheet Data'!X16:X27)","v":7504}]
["2015-16",{"$f":"SUM('Backing Sheet Data'!S28:S39)","v":47748},{"$f":"SUM('Backing Sheet Data'!T28:T39)","v":24705},{"$f":"SUM('Backing Sheet Data'!U28:U39)","v":922},{"$f":"SUM('Backing Sheet Data'!V28:V39)","v":10910},{"$f":"SUM('Backing Sheet Data'!W28:W39)","v":450},{"$f":"SUM('Backing Sheet Data'!X28:X39)","v":8598}]
["2016-17",{"$f":"SUM('Backing Sheet Data'!S40:S51)","v":43759},{"$f":"SUM('Backing Sheet Data'!T40:T51)","v":22109},{"$f":"SUM('Backing Sheet Data'!U40:U51)","v":770},{"$f":"SUM('Backing Sheet Data'!V40:V51)","v":10434},{"$f":"SUM('Backing Sheet Data'!W40:W51)","v":725},{"$f":"SUM('Backing Sheet Data'!X40:X51)","v":7473}]
["2017-18",{"$f":"SUM('Backing Sheet Data'!S52:S63)","v":41635},{"$f":"SUM('Backing Sheet Data'!T52:T63)","v":21303},{"$f":"SUM('Backing Sheet Data'!U52:U63)","v":655},{"$f":"SUM('Backing Sheet Data'!V52:V63)","v":10265},{"$f":"SUM('Backing Sheet Data'!W52:W63)","v":972},{"$f":"SUM('Backing Sheet Data'!X52:X63)","v":7353}]
["2018-19",{"$f":"SUM('Backing Sheet Data'!S64:S75)","v":40040},{"$f":"SUM('Backing Sheet Data'!T64:T75)","v":21024},{"$f":"SUM('Backing Sheet Data'!U64:U75)","v":644},{"$f":"SUM('Backing Sheet Data'!V64:V75)","v":10309},{"$f":"SUM('Backing Sheet Data'!W64:W75)","v":922},{"$f":"SUM('Backing Sheet Data'!X64:X75)","v":7635}]
["2019-20",{"$f":"SUM('Backing Sheet Data'!S76:S87)","v":24848},{"$f":"SUM('Backing Sheet Data'!T76:T87)","v":13737},{"$f":"SUM('Backing Sheet Data'!U76:U87)","v":431},{"$f":"SUM('Backing Sheet Data'!V76:V87)","v":6901},{"$f":"SUM('Backing Sheet Data'!W76:W87)","v":654},{"$f":"SUM('Backing Sheet Data'!X76:X87)","v":6092}]
["2020-21",{"$f":"SUM('Backing Sheet Data'!S88:S116)","v":54702},{"$f":"SUM('Backing Sheet Data'!T88:T116)","v":23314},{"$f":"SUM('Backing Sheet Data'!U88:U116)","v":775},{"$f":"SUM('Backing Sheet Data'!V88:V116)","v":12786},{"$f":"SUM('Backing Sheet Data'!W88:W116)","v":974},{"$f":"SUM('Backing Sheet Data'!X88:X116)","v":8630}]