{"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,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],[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],[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],[15,0,15,6],[15,7,15,8],[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],[9,0,9,6],[10,0,10,6],[11,0,11,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],[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]]}
["Total Sent:",null,null,2419,null,"Left process at stage 1:",null,null,null,994,null,"Left process at stage 2:",null,null,null,71,null,"Exited process:",null,null,null,595,null,"Settled:",null,null,359]
[]
["Δ from last month:",null,null,-23,null,"Δ from last month:",null,null,null,2,null,"Δ from last month:",null,null,null,-20,null,"Δ from last month:",null,null,null,28,null,"Δ from last month:",null,null,-19]
[]
["Rolling 12 months:",null,null,29510,null,"Rolling 12 months:",null,null,null,12314,null,"Rolling 12 months:",null,null,null,972,null,"Rolling 12 months:",null,null,null,7002,null,"Rolling 12 months:",null,null,4727]
[]
["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,799,null,823,null,-24]
["Other",null,null,null,null,null,null,195,null,169,null,26]
["Total",null,null,null,null,null,null,994,null,992,null,2]
["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,0,null,0,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,31,null,37,null,-6]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,40,null,54,null,-14]
["Total",null,null,null,null,null,null,71,null,91,null,-20]

{"sheet":"Backing Sheet Data","index":1,"n_rows":101,"n_cols":42,"rows_kept":101,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2021-08-01"]
["Previous month","2021-07-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,343766,157428,4813,72086,4961,53002,388326.09417000011]
[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",207,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",922,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",1876,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]
["2020-09-01",34605,null,null,"2020-09-01",4976.345397,null,null,799,195,0,0,31,40,null,null,null,"2013-11-01",2258,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]
["2020-10-01",33316,null,null,"2020-10-01",4908.6241579999996,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01",1997,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]
["2020-11-01",31953,null,null,"2020-11-01",4788.2835050000003,null,null,"CNF Sent Monthly Volumes Chart Data",null,null,null,null,null,null,null,null,"2014-01-01",3201,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]
["2020-12-01",31224,null,null,"2020-12-01",4690.3957799999998,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01",3185,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-01-01",15331,null,null,"2021-01-01",4562.1777419999999,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2014-03-01",3588,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]
["2021-02-01",28014,null,null,"2021-02-01",4679.5696180000004,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total",null,null,null,"2014-04-01",3555,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]
["2021-03-01",28072,null,null,"2021-03-01",4852.8321059999998,null,null,"2020-09-01",44477,3916,316,2842,51551,null,null,null,"2014-05-01",3660,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]
["2021-04-01",28249,null,null,"2021-04-01",4846.5958689999998,null,null,"2020-10-01",45280,3909,314,2724,52227,null,null,null,"2014-06-01",3953,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]
["2021-05-01",28860,null,null,"2021-05-01",4774.8293940000003,null,null,"2020-11-01",41913,3407,311,2423,48054,null,null,null,"2014-07-01",4655,2008,39,645,10,440,3054.5619999999999,null,"2014-07-01",33057,12585,163,3481,31,1852,null,"2014-07-01",4655,2008,39,645,10,440,3054.5619999999999]
["2021-06-01",29246,null,null,"2021-06-01",4795.169218,null,null,"2020-12-01",35648,2497,259,2026,40430,null,null,null,"2014-08-01",4045,1903,35,619,9,407,3105.700147,null,"2014-08-01",36895,14483,198,4087,40,2258,null,"2014-08-01",4045,1903,35,619,9,407,3105.700147]
["2021-07-01",29285,null,null,"2021-07-01",4962.1281429999999,null,null,"2021-01-01",37461,3036,325,2262,43084,null,null,null,"2014-09-01",4584,2145,54,705,9,481,3220.6174839999999,null,"2014-09-01",40557,16575,252,4738,49,2737,null,"2014-09-01",4584,2145,54,705,9,481,3220.6174839999999]
["2021-08-01",29510,null,null,"2021-08-01",4906.8961550000004,null,null,"2021-02-01",33122,2914,296,2464,38796,null,null,null,"2014-10-01",5108,2268,60,804,15,548,3327.2815139999998,null,"2014-10-01",43789,18522,312,5408,64,3269,null,"2014-10-01",5108,2268,60,804,15,548,3327.2815139999998]
[null,null,null,null,"Grand Total",57743.847085000001,null,null,"2021-03-01",39295,3344,365,2832,45836,null,null,null,"2014-11-01",4333,2101,44,730,22,566,3242.3573139999999,null,"2014-11-01",45864,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,"2021-04-01",36708,2758,319,2373,42158,null,null,null,"2014-12-01",3714,2202,62,806,10,565,3324.7293450000002,null,"2014-12-01",47581,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,"2021-05-01",37821,2804,259,2289,43173,null,null,null,"2015-01-01",4526,2034,48,778,22,606,3382.2266989999998,null,"2015-01-01",48906,22291,454,7133,118,4820,null,"2015-01-01",4526,2034,48,778,22,606,3382.2266989999998]
[null,74426,null,null,"CNF Sent Monthly Volumes",null,null,null,"2021-06-01",26178,3258,280,2445,32161,null,null,null,"2015-02-01",4741,1712,41,793,20,670,3301.2692229999998,null,"2015-02-01",50462,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,"2021-07-01",14885,3074,393,2411,20763,null,null,null,"2015-03-01",5059,2420,56,920,25,792,3425.002739,null,"2015-03-01",51933,23871,525,8206,160,5959,null,"2015-03-01",5059,2420,56,920,25,792,3425.002739]
["Other",32003,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2021-08-01",11388,3244,310,2419,17361,null,null,null,"2015-04-01",4283,2089,52,881,22,704,3453.6639060000002,null,"2015-04-01",52661,24362,554,8653,174,6450,null,"2015-04-01",4283,2089,52,881,22,704,3453.6639060000002]
["Claim requires further investigation",27903,null,null,"2020-06-01","RTA",25375,null,"Grand Total",404176,38161,3747,29510,475594,null,null,null,"2015-05-01",4222,2031,58,809,25,614,3457.9096570000002,null,"2015-05-01",53223,24751,585,9022,194,6773,null,"2015-05-01",4222,2031,58,809,25,614,3457.9096570000002]
["Duplicated claim",5990,null,null,"2020-07-01","RTA",39882,null,null,null,null,null,null,null,null,null,null,"2015-06-01",4697,2297,72,982,43,781,3544.529884,null,"2015-06-01",53967,25210,621,9472,232,7174,null,"2015-06-01",4697,2297,72,982,43,781,3544.529884]
["Value of claim exceeds the upper limit",3808,null,null,"2020-08-01","RTA",37499,null,null,null,null,null,null,null,null,null,null,"2015-07-01",5042,2396,61,961,37,770,3533.7322199999999,null,"2015-07-01",54354,25598,643,9788,259,7504,null,"2015-07-01",5042,2396,61,961,37,770,3533.7322199999999]
["Withdrawal of claim",1700,null,null,"2020-09-01","RTA",44477,null,null,null,null,null,null,null,null,null,null,"2015-08-01",4289,2113,65,938,30,720,3599.9857499999998,null,"2015-08-01",54598,25808,673,10107,280,7817,null,"2015-08-01",4289,2113,65,938,30,720,3599.9857499999998]
["Incomplete information provided on CNF",1693,null,null,"2020-10-01","RTA",45280,null,null,null,null,null,null,null,null,null,null,"2015-09-01",4607,2356,65,964,22,718,3670.9074230000001,null,"2015-09-01",54621,26019,684,10366,293,8054,null,"2015-09-01",4607,2356,65,964,22,718,3670.9074230000001]
["Claim is too complex for process",771,null,null,"2020-11-01","RTA",41913,null,null,null,null,null,null,null,null,null,null,"2015-10-01",4508,2220,66,859,27,714,3798.0564420000001,null,"2015-10-01",54021,25971,690,10421,305,8220,null,"2015-10-01",4508,2220,66,859,27,714,3798.0564420000001]
["Value of claim below ú1,000",331,null,null,"2020-12-01","RTA",35648,null,null,null,null,null,null,null,null,null,null,"2015-11-01",4373,2175,73,936,34,782,3849.7272889999999,null,"2015-11-01",54061,26045,719,10627,317,8436,null,"2015-11-01",4373,2175,73,936,34,782,3849.7272889999999]
["Withdrawal of offer",195,null,null,"2021-01-01","RTA",37461,null,null,null,null,null,null,null,null,null,null,"2015-12-01",3437,2128,80,912,48,715,3735.6251600000001,null,"2015-12-01",53784,25971,737,10733,355,8586,null,"2015-12-01",3437,2128,80,912,48,715,3735.6251600000001]
["Interim payment for child claimant",32,null,null,"2021-02-01","RTA",33122,null,null,null,null,null,null,null,null,null,null,"2016-01-01",4002,1969,76,892,34,632,3785.1946670000002,null,"2016-01-01",53260,25906,765,10847,367,8612,null,"2016-01-01",4002,1969,76,892,34,632,3785.1946670000002]
[null,null,null,null,"2021-03-01","RTA",39295,null,null,null,null,null,null,null,null,null,null,"2016-02-01",4287,1715,70,819,37,697,3956.9560110000002,null,"2016-02-01",52806,25909,794,10873,384,8639,null,"2016-02-01",4287,1715,70,819,37,697,3956.9560110000002]
[null,null,null,null,"2021-04-01","RTA",36708,null,null,null,null,null,null,null,null,null,null,"2016-03-01",4445,2180,74,900,35,775,3939.0959870000002,null,"2016-03-01",52192,25669,812,10853,394,8622,null,"2016-03-01",4445,2180,74,900,35,775,3939.0959870000002]
[null,null,null,null,"2021-05-01","RTA",37821,null,null,null,null,null,null,null,null,null,null,"2016-04-01",4292,2093,93,998,39,778,3994.2077370000002,null,"2016-04-01",52201,25673,853,10970,411,8696,null,"2016-04-01",4292,2093,93,998,39,778,3994.2077370000002]
[null,null,null,null,"2021-06-01","RTA",26178,null,null,null,null,null,null,null,null,null,null,"2016-05-01",4115,2022,70,868,36,706,3829.4240930000001,null,"2016-05-01",52094,25664,865,11029,422,8788,null,"2016-05-01",4115,2022,70,868,36,706,3829.4240930000001]
[null,null,null,null,"2021-07-01","RTA",14885,null,null,null,null,null,null,null,null,null,null,"2016-06-01",3492,2071,104,1019,57,700,4012.5146,null,"2016-06-01",50889,25438,897,11066,436,8707,null,"2016-06-01",3492,2071,104,1019,57,700,4012.5146]
[null,null,null,null,"2021-08-01","RTA",11388,null,null,null,null,null,null,null,null,null,null,"2016-07-01",3412,1663,86,805,51,661,3978.0093339999999,null,"2016-07-01",49259,24705,922,10910,450,8598,null,"2016-07-01",3412,1663,86,805,51,661,3978.0093339999999]
[null,null,null,null,"2021-09-01","RTA",503,null,null,null,null,null,null,null,null,null,null,"2016-08-01",4289,1290,54,595,28,525,4361.6228380000002,null,"2016-08-01",49259,23882,911,10567,448,8403,null,"2016-08-01",4289,1290,54,595,28,525,4361.6228380000002]
[null,null,null,null,"2020-06-01","EL",1615,null,null,null,null,null,null,null,null,null,null,"2016-09-01",4403,2104,98,1002,64,641,4287.550733,null,"2016-09-01",49055,23630,944,10605,490,8326,null,"2016-09-01",4403,2104,98,1002,64,641,4287.550733]
[null,null,null,null,"2020-07-01","EL",2378,null,null,null,null,null,null,null,null,null,null,"2016-10-01",4014,1984,56,973,57,652,3817.9603219999999,null,"2016-10-01",48561,23394,934,10719,520,8264,null,"2016-10-01",4014,1984,56,973,57,652,3817.9603219999999]
[null,null,null,null,"2020-08-01","EL",2194,null,null,null,null,null,null,null,null,null,null,"2016-11-01",4247,2112,75,936,72,675,4087.7506960000001,null,"2016-11-01",48435,23331,936,10719,558,8157,null,"2016-11-01",4247,2112,75,936,72,675,4087.7506960000001]
[null,null,null,null,"2020-09-01","EL",2842,null,null,null,null,null,null,null,null,null,null,"2016-12-01",3176,1858,71,784,61,574,3893.9097029999998,null,"2016-12-01",48174,23061,927,10591,571,8016,null,"2016-12-01",3176,1858,71,784,61,574,3893.9097029999998]
[null,null,null,null,"2020-10-01","EL",2724,null,null,null,null,null,null,null,null,null,null,"2017-01-01",3993,1800,64,915,57,666,4096.5334380000004,null,"2017-01-01",48165,22892,915,10614,594,8050,null,"2017-01-01",3993,1800,64,915,57,666,4096.5334380000004]
[null,null,null,null,"2020-11-01","EL",2423,null,null,null,null,null,null,null,null,null,null,"2017-02-01",4102,1537,72,760,63,659,4069.9781330000001,null,"2017-02-01",47980,22714,917,10555,620,8012,null,"2017-02-01",4102,1537,72,760,63,659,4069.9781330000001]
[null,null,null,null,"2020-12-01","EL",2026,null,null,null,null,null,null,null,null,null,null,"2017-03-01",4544,2134,48,1057,69,763,4015.2108119999998,null,"2017-03-01",48079,22668,891,10712,654,8000,null,"2017-03-01",4546,2134,48,1057,69,763,4015.2108119999998]
[null,null,null,null,"2021-01-01","EL",2262,null,null,null,null,null,null,null,null,null,null,"2017-04-01",3367,1640,60,723,54,617,4083.9455910000001,null,"2017-04-01",47154,22215,858,10437,669,7839,null,"2017-04-01",3367,1640,60,723,54,617,4083.9455910000001]
[null,null,null,null,"2021-02-01","EL",2464,null,null,null,null,null,null,null,null,null,null,"2017-05-01",4078,1903,57,921,63,627,4107.9435080000003,null,"2017-05-01",47117,22096,845,10490,696,7760,null,"2017-05-01",4078,1903,57,921,63,627,4107.9435080000003]
[null,null,null,null,"2021-03-01","EL",2832,null,null,null,null,null,null,null,null,null,null,"2017-06-01",3973,1934,63,950,90,628,4217.261082,null,"2017-06-01",47598,21959,804,10421,729,7688,null,"2017-06-01",3973,1934,63,950,90,628,4217.261082]
[null,null,null,null,"2021-04-01","EL",2373,null,null,null,null,null,null,null,null,null,null,"2017-07-01",3517,1813,52,818,47,618,4173.3238339999998,null,"2017-07-01",47703,22109,770,10434,725,7645,null,"2017-07-01",3518,1813,52,818,47,618,4173.3238339999998]
[null,null,null,null,"2021-05-01","EL",2289,null,null,null,null,null,null,null,null,null,null,"2017-08-01",3963,1707,60,870,79,661,4001.1070800000002,null,"2017-08-01",47377,22526,776,10709,776,7781,null,"2017-08-01",3963,1707,60,870,79,661,4001.1070800000002]
[null,null,null,null,"2021-06-01","EL",2445,null,null,null,null,null,null,null,null,null,null,"2017-09-01",3645,1662,57,842,95,591,4158.863824,null,"2017-09-01",46619,22084,735,10549,807,7731,null,"2017-09-01",3646,1662,57,842,95,591,4158.863824]
[null,null,null,null,"2021-07-01","EL",2411,null,null,null,null,null,null,null,null,null,null,"2017-10-01",4163,1787,71,949,81,690,4120.1839419999997,null,"2017-10-01",46768,21887,750,10525,831,7769,null,"2017-10-01",4163,1787,71,949,81,690,4120.1839419999997]
[null,null,null,null,"2021-08-01","EL",2419,null,null,null,null,null,null,null,null,null,null,"2017-11-01",4148,1907,63,919,81,674,4381.1367060000002,null,"2017-11-01",46669,21682,738,10508,840,7768,null,"2017-11-01",4149,1907,63,919,81,674,4381.1367060000002]
[null,null,null,null,"2021-09-01","EL",85,null,null,null,null,null,null,null,null,null,null,"2017-12-01",2747,1680,48,749,70,475,4322.5657259999998,null,"2017-12-01",46240,21504,715,10473,849,7669,null,"2017-12-01",2747,1680,48,749,70,475,4322.5657259999998]
[null,null,null,null,"2020-06-01","ELD",218,null,null,null,null,null,null,null,null,null,null,"2018-01-01",4233,1872,38,817,86,641,4332.0016530000003,null,"2018-01-01",46480,21576,689,10375,878,7644,null,"2018-01-01",4234,1872,38,817,86,641,4332.0016530000003]
[null,null,null,null,"2020-07-01","ELD",299,null,null,null,null,null,null,null,null,null,null,"2018-02-01",3937,1484,34,732,79,548,4215.5804010000002,null,"2018-02-01",46315,21523,651,10347,894,7533,null,"2018-02-01",3938,1484,34,732,79,548,4215.5804010000002]
[null,null,null,null,"2020-08-01","ELD",189,null,null,null,null,null,null,null,null,null,null,"2018-03-01",3929,1918,54,888,80,630,4155.2111420000001,null,"2018-03-01",45700,21307,657,10178,905,7400,null,"2018-03-01",3929,1918,54,888,80,630,4155.2111420000001]
[null,null,null,null,"2020-09-01","ELD",316,null,null,null,null,null,null,null,null,null,null,"2018-04-01",3923,1769,66,818,77,621,4176.2120450000002,null,"2018-04-01",46256,21436,663,10273,928,7404,null,"2018-04-01",3923,1769,66,818,77,621,4176.2120450000002]
[null,null,null,null,"2020-10-01","ELD",314,null,null,null,null,null,null,null,null,null,null,"2018-05-01",3858,1825,61,892,64,650,4069.7289839999999,null,"2018-05-01",46036,21358,667,10244,929,7427,null,"2018-05-01",3859,1825,61,892,64,650,4069.7289839999999]
[null,null,null,null,"2020-11-01","ELD",311,null,null,null,null,null,null,null,null,null,null,"2018-06-01",3761,1902,43,887,104,692,4359.973395,null,"2018-06-01",45824,21326,647,10181,943,7491,null,"2018-06-01",3761,1902,43,887,104,692,4359.973395]
[null,null,null,null,"2020-12-01","ELD",259,null,null,null,null,null,null,null,null,null,null,"2018-07-01",3951,1790,60,902,76,661,4312.5024960000001,null,"2018-07-01",46258,21303,655,10265,972,7534,null,"2018-07-01",3951,1790,60,902,76,661,4312.5024960000001]
[null,null,null,null,"2021-01-01","ELD",325,null,null,null,null,null,null,null,null,null,null,"2018-08-01",3849,1805,53,922,90,623,4206.6214120000004,null,"2018-08-01",46144,21401,648,10317,983,7496,null,"2018-08-01",3851,1805,53,922,90,623,4206.6214120000004]
[null,null,null,null,"2021-02-01","ELD",296,null,null,null,null,null,null,null,null,null,null,"2018-09-01",3786,1661,48,873,65,624,4280.4160089999996,null,"2018-09-01",46285,21400,639,10348,953,7529,null,"2018-09-01",3786,1661,48,873,65,624,4280.4160089999996]
[null,null,null,null,"2021-03-01","ELD",365,null,null,null,null,null,null,null,null,null,null,"2018-10-01",4134,1885,68,1006,78,659,4340.508194,null,"2018-10-01",46256,21498,636,10405,950,7498,null,"2018-10-01",4134,1885,68,1006,78,659,4340.508194]
[null,null,null,null,"2021-04-01","ELD",319,null,null,null,null,null,null,null,null,null,null,"2018-11-01",3946,1841,57,880,73,684,4075.4228800000001,null,"2018-11-01",46054,21432,630,10366,942,7508,null,"2018-11-01",3949,1841,57,880,73,684,4075.4228800000001]
[null,null,null,null,"2021-05-01","ELD",259,null,null,null,null,null,null,null,null,null,null,"2018-12-01",2770,1635,62,746,73,537,4212.3785470000003,null,"2018-12-01",46077,21387,644,10363,945,7570,null,"2018-12-01",2771,1635,62,746,73,537,4212.3785470000003]
[null,null,null,null,"2021-06-01","ELD",280,null,null,null,null,null,null,null,null,null,null,"2019-01-01",3781,1790,57,857,93,705,4196.3482830000003,null,"2019-01-01",45625,21305,663,10403,952,7634,null,"2019-01-01",3782,1790,57,857,93,705,4196.3482830000003]
[null,null,null,null,"2021-07-01","ELD",393,null,null,null,null,null,null,null,null,null,null,"2019-02-01",3697,1346,63,658,75,606,4299.0872600000002,null,"2019-02-01",45385,21167,692,10329,948,7692,null,"2019-02-01",3699,1346,63,658,75,606,4299.0872600000002]
[null,null,null,null,"2021-08-01","ELD",310,null,null,null,null,null,null,null,null,null,null,"2019-03-01",3884,1814,49,796,70,728,4496.9377329999998,null,"2019-03-01",45340,21063,687,10237,938,7790,null,"2019-03-01",3887,1814,49,796,70,728,4496.9377329999998]
[null,null,null,null,"2021-09-01","ELD",6,null,null,null,null,null,null,null,null,null,null,"2019-04-01",3775,1793,45,805,67,695,4503.205438,null,"2019-04-01",45192,21087,666,10224,928,7864,null,"2019-04-01",3776,1793,45,805,67,696,4499.8703159999995]
[null,null,null,null,"2020-06-01","PL",2216,null,null,null,null,null,null,null,null,null,null,"2019-05-01",3720,1900,48,916,79,697,4442.9177760000002,null,"2019-05-01",45054,21162,653,10248,943,7911,null,"2019-05-01",3724,1900,48,916,79,697,4442.9177760000002]
[null,null,null,null,"2020-07-01","PL",3332,null,null,null,null,null,null,null,null,null,null,"2019-06-01",3442,1674,48,883,72,593,4511.205328,null,"2019-06-01",44735,20934,658,10244,911,7812,null,"2019-06-01",3444,1674,48,883,72,593,4511.205328]
[null,null,null,null,"2020-08-01","PL",3041,null,null,null,null,null,null,null,null,null,null,"2019-07-01",4028,1880,46,968,87,692,4416.6319940000003,null,"2019-07-01",44812,21024,644,10310,922,7843,null,"2019-07-01",4031,1880,46,968,87,692,4416.6319940000003]
[null,null,null,null,"2020-09-01","PL",3916,null,null,null,null,null,null,null,null,null,null,"2019-08-01",3570,1693,62,908,76,643,4298.788646,null,"2019-08-01",44533,20912,653,10296,908,7863,null,"2019-08-01",3573,1693,62,908,76,643,4298.788646]
[null,null,null,null,"2020-10-01","PL",3909,null,null,null,null,null,null,null,null,null,null,"2019-09-01",3417,1776,42,860,97,635,4307.3684880000001,null,"2019-09-01",44164,21027,647,10283,940,7874,null,"2019-09-01",3421,1776,42,860,97,635,4307.3684880000001]
[null,null,null,null,"2020-11-01","PL",3407,null,null,null,null,null,null,null,null,null,null,"2019-10-01",4016,1503,55,945,96,708,4370.8796320000001,null,"2019-10-01",44046,20645,634,10222,958,7923,null,"2019-10-01",4027,1499,55,945,96,710,4367.018]
[null,null,null,null,"2020-12-01","PL",2497,null,null,null,null,null,null,null,null,null,null,"2019-11-01",3791,1556,52,895,87,702,4516.0072069999997,null,"2019-11-01",43891,20360,629,10237,972,7941,null,"2019-11-01",3796,1554,52,895,87,703,4512.4282499999999]
[null,null,null,null,"2021-01-01","PL",3036,null,null,null,null,null,null,null,null,null,null,"2019-12-01",2717,1535,59,790,74,541,4271.6493710000004,null,"2019-12-01",43838,20260,626,10281,973,7945,null,"2019-12-01",2719,1520,59,790,74,542,4269.6721580000003]
[null,null,null,null,"2021-02-01","PL",2914,null,null,null,null,null,null,null,null,null,null,"2020-01-01",3668,1621,54,948,106,615,4425.3812029999999,null,"2020-01-01",43725,20091,623,10372,986,7855,null,"2020-01-01",3673,1611,54,948,106,616,4432.8075319999998]
[null,null,null,null,"2021-03-01","PL",3344,null,null,null,null,null,null,null,null,null,null,"2020-02-01",3651,1156,41,687,75,616,4438.7770119999996,null,"2020-02-01",43679,19901,601,10401,986,7865,null,"2020-02-01",3658,1148,41,688,75,616,4438.7770119999996]
[null,null,null,null,"2021-04-01","PL",2758,null,null,null,null,null,null,null,null,null,null,"2020-03-01",3414,1673,61,866,90,648,4527.1019749999996,null,"2020-03-01",43209,19760,613,10471,1006,7785,null,"2020-03-01",3424,1662,61,866,90,650,4519.3539689999998]
[null,null,null,null,"2021-05-01","PL",2804,null,null,null,null,null,null,null,null,null,null,"2020-04-01",2200,1504,50,853,83,563,4459.2569439999997,null,"2020-04-01",41634,19471,618,10519,1022,7653,null,"2020-04-01",2207,1490,50,853,83,563,4459.2569439999997]
[null,null,null,null,"2021-06-01","PL",3258,null,null,null,null,null,null,null,null,null,null,"2020-05-01",1679,1079,39,549,54,445,4691.8569879999995,null,"2020-05-01",39593,18650,609,10152,997,7401,null,"2020-05-01",1650,1065,39,549,54,448,4698.7195529999999]
[null,null,null,null,"2021-07-01","PL",3074,null,null,null,null,null,null,null,null,null,null,"2020-06-01",2033,876,36,524,72,467,4899.0666799999999,null,"2020-06-01",38184,17852,597,9793,997,7275,null,"2020-06-01",1976,846,36,524,72,468,4892.8720940000003]
[null,null,null,null,"2021-08-01","PL",3244,null,null,null,null,null,null,null,null,null,null,"2020-07-01",2378,859,41,553,59,392,4706.5768109999999,null,"2020-07-01",36534,16831,592,9378,969,6975,null,"2020-07-01",2293,819,41,535,57,374,4706.51901]
[null,null,null,null,"2021-09-01","PL",98,null,null,null,null,null,null,null,null,null,null,"2020-08-01",2194,873,31,492,49,296,4472.6137159999998,null,"2020-08-01",35158,16011,561,8962,942,6628,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",2842,1015,33,556,65,415,4976.345397,null,"2020-09-01",34583,15250,552,8658,910,6408,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",2724,1169,26,659,40,416,4908.6241579999996,null,"2020-10-01",33291,14916,523,8372,854,6116,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",2423,1145,28,672,46,425,4788.2835050000003,null,"2020-11-01",31923,14505,499,8149,813,5839,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",2026,1023,37,549,46,365,4690.3957799999998,null,"2020-12-01",31232,13993,477,7908,785,5663,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",2262,1018,26,582,44,381,4562.1777419999999,null,"2021-01-01",29826,13390,449,7542,723,5429,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",2464,754,29,450,41,393,4679.5696180000004,null,"2021-02-01",28639,12988,437,7305,689,5206,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",2832,1175,37,637,63,451,4852.8321059999998,null,"2021-03-01",28057,12490,413,7076,662,5009,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,1024,45,597,57,414,4846.5958689999998,null,"2021-04-01",28230,12010,408,6820,636,4860,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",2289,958,26,577,40,347,4774.8293940000003,null,"2021-05-01",28840,11889,395,6848,622,4762,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",2445,1030,35,561,46,384,4795.169218,null,"2021-06-01",29252,12043,394,6885,596,4679,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",2411,1009,37,567,54,377,4962.1281429999999,null,"2021-07-01",29285,12193,390,6899,591,4664,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",2419,994,31,595,40,359,4906.8961550000004,null,"2021-08-01",29510,12314,390,7002,582,4727]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01",85,86,3,26,2,28,5359.8214280000002]

{"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":33057},{"$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":54354},{"$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":49259},{"$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":47703},{"$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":7645}]
["2017-18",{"$f":"SUM('Backing Sheet Data'!S52:S63)","v":46258},{"$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":7534}]
["2018-19",{"$f":"SUM('Backing Sheet Data'!S64:S75)","v":44812},{"$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":10310},{"$f":"SUM('Backing Sheet Data'!W64:W75)","v":922},{"$f":"SUM('Backing Sheet Data'!X64:X75)","v":7843}]
["2019-20",{"$f":"SUM('Backing Sheet Data'!S76:S87)","v":36534},{"$f":"SUM('Backing Sheet Data'!T76:T87)","v":16831},{"$f":"SUM('Backing Sheet Data'!U76:U87)","v":592},{"$f":"SUM('Backing Sheet Data'!V76:V87)","v":9378},{"$f":"SUM('Backing Sheet Data'!W76:W87)","v":969},{"$f":"SUM('Backing Sheet Data'!X76:X87)","v":6975}]
["2020-21",{"$f":"SUM('Backing Sheet Data'!S88:S106)","v":31789},{"$f":"SUM('Backing Sheet Data'!T88:T106)","v":13273},{"$f":"SUM('Backing Sheet Data'!U88:U106)","v":424},{"$f":"SUM('Backing Sheet Data'!V88:V106)","v":7520},{"$f":"SUM('Backing Sheet Data'!W88:W106)","v":633},{"$f":"SUM('Backing Sheet Data'!X88:X106)","v":5051}]