{"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":2},"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,1502,null,"Left process at stage 1:",null,null,null,614,null,"Left process at stage 2:",null,null,null,48,null,"Exited process:",null,null,null,380,null,"Settled:",null,null,343]
[]
["Δ from last month:",null,null,-721,null,"Δ from last month:",null,null,null,-378,null,"Δ from last month:",null,null,null,-22,null,"Δ from last month:",null,null,null,-204,null,"Δ from last month:",null,null,-40]
[]
["Rolling 12 months:",null,null,14860,null,"Rolling 12 months:",null,null,null,9529,null,"Rolling 12 months:",null,null,null,657,null,"Rolling 12 months:",null,null,null,4718,null,"Rolling 12 months:",null,null,4205]
[]
["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,431,null,797,null,-366]
["Other",null,null,null,null,null,null,183,null,195,null,-12]
["Total",null,null,null,null,null,null,614,null,992,null,-378]
["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,1,null,-1]
["Settlement pack repudiated:",null,null,null,null,null,null,0,null,0,null,0]
["Settlement pack timeout:",null,null,null,null,null,null,23,null,25,null,-2]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,25,null,44,null,-19]
["Total",null,null,null,null,null,null,48,null,70,null,-22]

{"sheet":"Backing Sheet Data","index":1,"n_rows":99,"n_cols":42,"rows_kept":99,"cut":false,"hidden":true,"merged":[[3,0,3,1],[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2021-02-01"]
["Previous month",{"$f":"EDATE(B1,-1)","v":"2021-01-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,tblRTABackingData[CNFs Sent])","v":287056},{"$f":"SUBTOTAL(9,tblRTABackingData[CNFs left at Stage 1])","v":145856},{"$f":"SUBTOTAL(9,tblRTABackingData[Stage 2 Exit])","v":4362},{"$f":"SUBTOTAL(9,tblRTABackingData[Exit process])","v":64549},{"$f":"SUBTOTAL(9,tblRTABackingData[Court Pack])","v":4163},{"$f":"SUBTOTAL(9,tblRTABackingData[Settled claims])","v":48587},{"$f":"SUBTOTAL(9,tblRTABackingData[General Damages])","v":353714.92751500005}]
[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",1872,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-03-01",43238,null,null,"2020-03-01",4561.2821869999998,null,null,431,183,0,0,23,25,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]
["2020-04-01",41665,null,null,"2020-04-01",4440.5187850000002,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]
["2020-05-01",39625,null,null,"2020-05-01",4845.8782860000001,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]
["2020-06-01",38215,null,null,"2020-06-01",4815.4210050000002,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]
["2020-07-01",36557,null,null,"2020-07-01",4834.0034249999999,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2014-03-01",3559,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]
["2020-08-01",35178,null,null,"2020-08-01",4532.2669260000002,null,null,"Row Labels","RTA","PL","ELD","EL",null,"Grand Total",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]
["2020-09-01",34605,null,null,"2020-09-01",5023.8640370000003,null,null,"2020-03-01",49232,2586,192,1798,3460,57268,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]
["2020-10-01",33316,null,null,"2020-10-01",4979.4476750000003,null,null,"2020-04-01",24499,1703,262,1215,2241,29920,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]
["2020-11-01",31953,null,null,"2020-11-01",4808.8670229999998,null,null,"2020-05-01",22866,1378,164,902,1818,27128,null,null,"2014-07-01",4619,2008,39,645,10,440,3054.5619999999999,null,"2014-07-01",{"$f":"SUM(S4:S15)","v":32845},{"$f":"SUM(T4:T15)","v":12585},163,3481,31,1852,null,"2014-07-01",4655,2008,39,645,10,440,3054.5619999999999]
["2020-12-01",31224,null,null,"2020-12-01",4543.0488720000003,null,null,"2020-06-01",32354,1658,162,1064,2235,37473,null,null,"2014-08-01",4010,1903,35,619,9,407,3105.700147,null,"2014-08-01",36649,{"$f":"SUM(T5:T16)","v":14483},198,4087,40,2258,null,"2014-08-01",4045,1903,35,619,9,407,3105.700147]
["2021-01-01",15331,null,null,"2021-01-01",4663.6033219999999,null,null,"2020-07-01",39916,1930,199,1188,2679,45912,null,null,"2014-09-01",4550,2145,54,705,9,481,3220.6174839999999,null,"2014-09-01",40280,{"$f":"SUM(T6:T17)","v":16575},252,4738,49,2737,null,"2014-09-01",4584,2145,54,705,9,481,3220.6174839999999]
["2021-02-01",{"$f":"VLOOKUP(A18,tblPrevious12[#All],2,FALSE)","v":14860},null,null,"2021-02-01",4719.332332,null,null,"2020-08-01",37522,1781,119,1094,2425,42941,null,null,"2014-10-01",5060,2268,60,804,15,548,3327.2815139999998,null,"2014-10-01",43468,{"$f":"SUM(T7:T18)","v":18522},312,5408,64,3269,null,"2014-10-01",5108,2268,60,804,15,548,3327.2815139999998]
[null,null,null,null,"Grand Total",56767.533875000001,null,null,"2020-09-01",44540,2225,208,1423,3218,51614,null,null,"2014-11-01",4293,2101,44,730,22,566,3242.3573139999999,null,"2014-11-01",45515,{"$f":"SUM(T8:T19)","v":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,"2020-10-01",45389,2132,188,1299,3335,52343,null,null,"2014-12-01",3669,2202,62,806,10,565,3324.7293450000002,null,"2014-12-01",47201,{"$f":"SUM(T9:T20)","v":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,"2020-11-01",41998,1747,153,1138,3106,48142,null,null,"2015-01-01",4484,2034,48,778,22,606,3382.2266989999998,null,"2015-01-01",48503,{"$f":"SUM(T10:T21)","v":22291},454,7133,118,4820,null,"2015-01-01",4526,2034,48,778,22,606,3382.2266989999998]
[null,{"$f":"SUBTOTAL(9,B24:B33)","v":70627},null,null,"CNF Sent Monthly Volumes",null,null,null,"2020-12-01",35772,1463,139,858,2306,40538,null,null,"2015-02-01",4689,1712,41,793,20,670,3301.2692229999998,null,"2015-02-01",50032,{"$f":"SUM(T11:T22)","v":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-01-01",37685,1075,245,1379,2805,43189,null,null,"2015-03-01",4985,2420,56,920,25,792,3425.002739,null,"2015-03-01",51458,{"$f":"SUM(T12:T23)","v":23871},525,8206,160,5959,null,"2015-03-01",5059,2420,56,920,25,792,3425.002739]
["Other",30548,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2021-02-01",33533,1671,161,1502,1894,38761,null,null,"2015-04-01",4220,2089,52,881,22,704,3453.6639060000002,null,"2015-04-01",52148,{"$f":"SUM(T13:T24)","v":24362},554,8653,174,6450,null,"2015-04-01",4283,2089,52,881,22,704,3453.6639060000002]
["Claim requires further investigation",26131,null,null,"2019-12-01","RTA",39231,null,"Grand Total",445306,21349,2192,14860,31522,515229,null,null,"2015-05-01",4155,2031,58,809,25,614,3457.9096570000002,null,"2015-05-01",52660,{"$f":"SUM(T14:T25)","v":24751},585,9022,194,6773,null,"2015-05-01",4222,2031,58,809,25,614,3457.9096570000002]
["Duplicated claim",5892,null,null,"2020-01-01","RTA",60003,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",53356,{"$f":"SUM(T15:T26)","v":25210},621,9472,232,7174,null,"2015-06-01",4697,2297,72,982,43,781,3544.529884]
["Value of claim exceeds the upper limit",3563,null,null,"2020-02-01","RTA",55459,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,{"$f":"SUM(T16:T27)","v":25598},643,9788,259,7504,null,"2015-07-01",5042,2396,61,961,37,770,3533.7322199999999]
["Withdrawal of claim",1679,null,null,"2020-03-01","RTA",49232,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,{"$f":"SUM(T17:T28)","v":25808},673,10107,280,7817,null,"2015-08-01",4289,2113,65,938,30,720,3599.9857499999998]
["Incomplete information provided on CNF",1631,null,null,"2020-04-01","RTA",24499,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,{"$f":"SUM(T18:T29)","v":26019},684,10366,293,8054,null,"2015-09-01",4607,2356,65,964,22,718,3670.9074230000001]
["Claim is too complex for process",730,null,null,"2020-05-01","RTA",22866,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,{"$f":"SUM(T19:T30)","v":25971},690,10421,305,8220,null,"2015-10-01",4508,2220,66,859,27,714,3798.0564420000001]
["Value of claim below ú1,000",326,null,null,"2020-06-01","RTA",32354,null,null,null,null,null,null,null,null,null,null,"2015-11-01",4277,2175,73,936,34,782,3849.7272889999999,null,"2015-11-01",53181,{"$f":"SUM(T20:T31)","v":26045},719,10627,317,8436,null,"2015-11-01",4373,2175,73,936,34,782,3849.7272889999999]
["Withdrawal of offer",96,null,null,"2020-07-01","RTA",39916,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",52855,{"$f":"SUM(T21:T32)","v":25971},737,10733,355,8586,null,"2015-12-01",3437,2128,80,912,48,715,3735.6251600000001]
["Interim payment for child claimant",31,null,null,"2020-08-01","RTA",37522,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",52250,{"$f":"SUM(T22:T33)","v":25906},765,10847,367,8612,null,"2016-01-01",4002,1969,76,892,34,632,3785.1946670000002]
[null,null,null,null,"2020-09-01","RTA",44540,null,null,null,null,null,null,null,null,null,null,"2016-02-01",4149,1715,70,819,37,697,3956.9560110000002,null,"2016-02-01",51710,{"$f":"SUM(T23:T34)","v":25909},794,10873,384,8639,null,"2016-02-01",4287,1715,70,819,37,697,3956.9560110000002]
[null,null,null,null,"2020-10-01","RTA",45389,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",51013,{"$f":"SUM(T24:T35)","v":25669},812,10853,394,8622,null,"2016-03-01",4445,2180,74,900,35,775,3939.0959870000002]
[null,null,null,null,"2020-11-01","RTA",41998,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",50935,{"$f":"SUM(T25:T36)","v":25673},853,10970,411,8696,null,"2016-04-01",4292,2093,93,998,39,778,3994.2077370000002]
[null,null,null,null,"2020-12-01","RTA",35772,null,null,null,null,null,null,null,null,null,null,"2016-05-01",3957,2022,70,868,36,706,3829.4240930000001,null,"2016-05-01",50737,{"$f":"SUM(T26:T37)","v":25664},865,11029,422,8788,null,"2016-05-01",4115,2022,70,868,36,706,3829.4240930000001]
[null,null,null,null,"2021-01-01","RTA",37685,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",49438,{"$f":"SUM(T27:T38)","v":25438},897,11066,436,8707,null,"2016-06-01",3492,2071,104,1019,57,700,4012.5146]
[null,null,null,null,"2021-02-01","RTA",33533,null,null,null,null,null,null,null,null,null,null,"2016-07-01",3259,1663,86,805,51,661,3978.0093339999999,null,"2016-07-01",47742,{"$f":"SUM(T28:T39)","v":24705},922,10910,450,8598,null,"2016-07-01",3412,1663,86,805,51,661,3978.0093339999999]
[null,null,null,null,"2019-12-01","",1975,null,null,null,null,null,null,null,null,null,null,"2016-08-01",4104,1290,54,595,28,525,4361.6228380000002,null,"2016-08-01",47618,{"$f":"SUM(T29:T40)","v":23882},911,10567,448,8403,null,"2016-08-01",4289,1290,54,595,28,525,4361.6228380000002]
[null,null,null,null,"2020-01-01","",3643,null,null,null,null,null,null,null,null,null,null,"2016-09-01",4211,2104,98,1002,64,637,4278.0727939999997,null,"2016-09-01",47340,{"$f":"SUM(T30:T41)","v":23630},944,10605,490,8322,null,"2016-09-01",4403,2104,98,1002,64,641,4287.550733]
[null,null,null,null,"2020-02-01","",3690,null,null,null,null,null,null,null,null,null,null,"2016-10-01",3776,1984,56,973,57,651,3820.7528870000001,null,"2016-10-01",46708,{"$f":"SUM(T31:T42)","v":23394},934,10719,520,8259,null,"2016-10-01",4014,1984,56,973,57,652,3817.9603219999999]
[null,null,null,null,"2020-03-01","",3460,null,null,null,null,null,null,null,null,null,null,"2016-11-01",3878,2112,75,936,72,667,4062.9838679999998,null,"2016-11-01",46309,{"$f":"SUM(T32:T43)","v":23331},936,10719,558,8144,null,"2016-11-01",4247,2112,75,936,72,675,4087.7506960000001]
[null,null,null,null,"2020-04-01","",2241,null,null,null,null,null,null,null,null,null,null,"2016-12-01",2847,1858,71,784,61,560,3897.5422669999998,null,"2016-12-01",45813,{"$f":"SUM(T33:T44)","v":23061},927,10591,571,7989,null,"2016-12-01",3176,1858,71,784,61,574,3893.9097029999998]
[null,null,null,null,"2020-05-01","",1818,null,null,null,null,null,null,null,null,null,null,"2017-01-01",3543,1800,64,915,57,649,4093.7307700000001,null,"2017-01-01",45477,{"$f":"SUM(T34:T45)","v":22892},915,10614,594,8006,null,"2017-01-01",3993,1800,64,915,57,666,4096.5334380000004]
[null,null,null,null,"2020-06-01","",2235,null,null,null,null,null,null,null,null,null,null,"2017-02-01",3668,1537,72,760,63,635,4075.356362,null,"2017-02-01",44996,{"$f":"SUM(T35:T46)","v":22714},917,10555,620,7944,null,"2017-02-01",4102,1537,72,760,63,659,4069.9781330000001]
[null,null,null,null,"2020-07-01","",2679,null,null,null,null,null,null,null,null,null,null,"2017-03-01",4077,2134,48,1057,69,735,4036.743469,null,"2017-03-01",{"$f":"SUM(S36:S47)","v":44785},{"$f":"SUM(T36:T47)","v":22668},891,10712,654,7904,null,"2017-03-01",4546,2134,48,1057,69,763,4015.2108119999998]
[null,null,null,null,"2020-08-01","",2425,null,null,null,null,null,null,null,null,null,null,"2017-04-01",3018,1640,60,723,54,594,4026.9603189999998,null,"2017-04-01",43661,{"$f":"SUM(T37:T48)","v":22215},858,10437,669,7720,null,"2017-04-01",3367,1640,60,723,54,617,4083.9455910000001]
[null,null,null,null,"2020-09-01","",3218,null,null,null,null,null,null,null,null,null,null,"2017-05-01",3682,1903,57,921,63,611,4087.6201139999998,null,"2017-05-01",43386,{"$f":"SUM(T38:T49)","v":22096},845,10490,696,7625,null,"2017-05-01",4078,1903,57,921,63,627,4107.9435080000003]
[null,null,null,null,"2020-10-01","",3335,null,null,null,null,null,null,null,null,null,null,"2017-06-01",3569,1934,63,950,90,612,4227.0669280000002,null,"2017-06-01",43632,{"$f":"SUM(T39:T50)","v":21959},804,10421,729,7537,null,"2017-06-01",3973,1934,63,950,90,628,4217.261082]
[null,null,null,null,"2020-11-01","",3106,null,null,null,null,null,null,null,null,null,null,"2017-07-01",3172,1813,52,818,47,597,4145.1694630000002,null,"2017-07-01",43545,{"$f":"SUM(T40:T51)","v":22109},770,10434,725,7473,null,"2017-07-01",3518,1813,52,818,47,618,4173.3238339999998]
[null,null,null,null,"2020-12-01","",2306,null,null,null,null,null,null,null,null,null,null,"2017-08-01",3521,1707,60,870,79,642,3989.100015,null,"2017-08-01",42962,{"$f":"SUM(T41:T52)","v":22526},776,10709,776,7590,null,"2017-08-01",3963,1707,60,870,79,661,4001.1070800000002]
[null,null,null,null,"2021-01-01","",2805,null,null,null,null,null,null,null,null,null,null,"2017-09-01",3239,1662,57,842,95,578,4148.2500339999997,null,"2017-09-01",41990,{"$f":"SUM(T42:T53)","v":22084},735,10549,807,7531,null,"2017-09-01",3646,1662,57,842,95,591,4158.863824]
[null,null,null,null,"2021-02-01","",1894,null,null,null,null,null,null,null,null,null,null,"2017-10-01",3717,1787,71,949,81,672,4132.3168450000003,null,"2017-10-01",41931,{"$f":"SUM(T43:T54)","v":21887},750,10525,831,7552,null,"2017-10-01",4163,1787,71,949,81,690,4120.1839419999997]
[null,null,null,null,"2019-12-01","EL",1173,null,null,null,null,null,null,null,null,null,null,"2017-11-01",3674,1907,63,919,81,657,4371.4041699999998,null,"2017-11-01",41727,{"$f":"SUM(T44:T55)","v":21682},738,10508,840,7542,null,"2017-11-01",4149,1907,63,919,81,674,4381.1367060000002]
[null,null,null,null,"2020-01-01","EL",2035,null,null,null,null,null,null,null,null,null,null,"2017-12-01",2474,1680,48,749,70,465,4270.6846880000003,null,"2017-12-01",41354,{"$f":"SUM(T45:T56)","v":21504},715,10473,849,7447,null,"2017-12-01",2747,1680,48,749,70,475,4322.5657259999998]
[null,null,null,null,"2020-02-01","EL",1973,null,null,null,null,null,null,null,null,null,null,"2018-01-01",3758,1872,38,817,86,628,4307.6641079999999,null,"2018-01-01",41569,{"$f":"SUM(T46:T57)","v":21576},689,10375,878,7426,null,"2018-01-01",4234,1872,38,817,86,641,4332.0016530000003]
[null,null,null,null,"2020-03-01","EL",1798,null,null,null,null,null,null,null,null,null,null,"2018-02-01",3508,1484,34,732,79,540,4220.8112220000003,null,"2018-02-01",41409,{"$f":"SUM(T47:T58)","v":21523},651,10347,894,7331,null,"2018-02-01",3938,1484,34,732,79,548,4215.5804010000002]
[null,null,null,null,"2020-04-01","EL",1215,null,null,null,null,null,null,null,null,null,null,"2018-03-01",3505,1918,54,888,80,608,4122.6842429999997,null,"2018-03-01",40837,{"$f":"SUM(T48:T59)","v":21307},657,10178,905,7204,null,"2018-03-01",3929,1918,54,888,80,630,4155.2111420000001]
[null,null,null,null,"2020-05-01","EL",902,null,null,null,null,null,null,null,null,null,null,"2018-04-01",3466,1769,66,818,77,611,4136.0825359999999,null,"2018-04-01",41285,{"$f":"SUM(T49:T60)","v":21436},663,10273,928,7221,null,"2018-04-01",3923,1769,66,818,77,621,4176.2120450000002]
[null,null,null,null,"2020-06-01","EL",1064,null,null,null,null,null,null,null,null,null,null,"2018-05-01",3407,1825,61,892,64,633,4077.707488,null,"2018-05-01",41010,{"$f":"SUM(T50:T61)","v":21358},667,10244,929,7243,null,"2018-05-01",3859,1825,61,892,64,650,4069.7289839999999]
[null,null,null,null,"2020-07-01","EL",1188,null,null,null,null,null,null,null,null,null,null,"2018-06-01",3324,1902,43,887,104,674,4334.9801029999999,null,"2018-06-01",40765,{"$f":"SUM(T51:T62)","v":21326},647,10181,943,7305,null,"2018-06-01",3761,1902,43,887,104,692,4359.973395]
[null,null,null,null,"2020-08-01","EL",1094,null,null,null,null,null,null,null,null,null,null,"2018-07-01",3483,1790,60,902,76,645,4345.1382169999997,null,"2018-07-01",41076,{"$f":"SUM(T52:T63)","v":21303},655,10265,972,7353,null,"2018-07-01",3951,1790,60,902,76,661,4312.5024960000001]
[null,null,null,null,"2020-09-01","EL",1423,null,null,null,null,null,null,null,null,null,null,"2018-08-01",3380,1805,53,922,90,610,4209.8686879999996,null,"2018-08-01",40935,{"$f":"SUM(T53:T64)","v":21401},648,10317,983,7321,null,"2018-08-01",3851,1805,53,922,90,623,4206.6214120000004]
[null,null,null,null,"2020-10-01","EL",1299,null,null,null,null,null,null,null,null,null,null,"2018-09-01",3341,1661,48,873,65,604,4259.8999830000002,null,"2018-09-01",41037,{"$f":"SUM(T54:T65)","v":21400},639,10348,953,7347,null,"2018-09-01",3786,1661,48,873,65,624,4280.4160089999996]
[null,null,null,null,"2020-11-01","EL",1138,null,null,null,null,null,null,null,null,null,null,"2018-10-01",3585,1885,68,1006,78,638,4332.3587770000004,null,"2018-10-01",40905,{"$f":"SUM(T55:T66)","v":21498},636,10405,950,7313,null,"2018-10-01",4134,1885,68,1006,78,659,4340.508194]
[null,null,null,null,"2020-12-01","EL",858,null,null,null,null,null,null,null,null,null,null,"2018-11-01",3450,1841,57,880,73,669,4077.5747679999999,null,"2018-11-01",40681,{"$f":"SUM(T56:T67)","v":21432},630,10366,942,7325,null,"2018-11-01",3949,1841,57,880,73,684,4075.4228800000001]
[null,null,null,null,"2021-01-01","EL",1379,null,null,null,null,null,null,null,null,null,null,"2018-12-01",2398,1635,62,746,73,522,4202.0800950000003,null,"2018-12-01",40605,{"$f":"SUM(T57:T68)","v":21387},644,10363,945,7382,null,"2018-12-01",2771,1635,62,746,73,537,4212.3785470000003]
[null,null,null,null,"2021-02-01","EL",1502,null,null,null,null,null,null,null,null,null,null,"2019-01-01",3209,1790,57,857,93,693,4176.5880800000004,null,"2019-01-01",40056,{"$f":"SUM(T58:T69)","v":21305},663,10403,952,7447,null,"2019-01-01",3782,1790,57,857,93,705,4196.3482830000003]
[null,null,null,null,"2019-12-01","ELD",127,null,null,null,null,null,null,null,null,null,null,"2019-02-01",3138,1346,63,658,75,588,4297.3759010000003,null,"2019-02-01",39686,{"$f":"SUM(T59:T70)","v":21167},692,10329,948,7495,null,"2019-02-01",3699,1346,63,658,75,606,4299.0872600000002]
[null,null,null,null,"2020-01-01","ELD",218,null,null,null,null,null,null,null,null,null,null,"2019-03-01",3295,1814,49,796,70,706,4453.7949289999997,null,"2019-03-01",39476,{"$f":"SUM(T60:T71)","v":21063},687,10237,938,7593,null,"2019-03-01",3887,1814,49,796,70,728,4496.9377329999998]
[null,null,null,null,"2020-02-01","ELD",228,null,null,null,null,null,null,null,null,null,null,"2019-04-01",3208,1793,45,805,67,678,4448.1273449999999,null,"2019-04-01",39218,{"$f":"SUM(T61:T72)","v":21087},666,10224,928,7660,null,"2019-04-01",3776,1793,45,805,67,696,4499.8703159999995]
[null,null,null,null,"2020-03-01","ELD",192,null,null,null,null,null,null,null,null,null,null,"2019-05-01",3142,1900,48,916,79,676,4404.3989490000004,null,"2019-05-01",38953,{"$f":"SUM(T62:T73)","v":21162},653,10248,943,7703,null,"2019-05-01",3724,1900,48,916,79,697,4442.9177760000002]
[null,null,null,null,"2020-04-01","ELD",262,null,null,null,null,null,null,null,null,null,null,"2019-06-01",2904,1674,48,883,72,581,4466.9445089999999,null,"2019-06-01",38533,{"$f":"SUM(T63:T74)","v":20934},658,10244,911,7610,null,"2019-06-01",3444,1674,48,883,72,593,4511.205328]
[null,null,null,null,"2020-05-01","ELD",164,null,null,null,null,null,null,null,null,null,null,"2019-07-01",3400,1880,46,967,87,670,4403.9587160000001,null,"2019-07-01",38450,{"$f":"SUM(T64:T75)","v":21024},644,10309,922,7635,null,"2019-07-01",4031,1880,46,968,87,692,4416.6319940000003]
[null,null,null,null,"2020-06-01","ELD",162,null,null,null,null,null,null,null,null,null,null,"2019-08-01",2730,1693,62,908,76,622,4287.6730219999999,null,"2019-08-01",37800,{"$f":"SUM(T65:T76)","v":20912},653,10295,908,7647,null,"2019-08-01",3573,1693,62,908,76,643,4298.788646]
[null,null,null,null,"2020-07-01","ELD",199,null,null,null,null,null,null,null,null,null,null,"2019-09-01",2085,1776,42,850,95,617,4290.6919440000001,null,"2019-09-01",36544,{"$f":"SUM(T66:T77)","v":21027},647,10272,938,7660,null,"2019-09-01",3421,1776,42,860,97,635,4307.3684880000001]
[null,null,null,null,"2020-08-01","ELD",119,null,null,null,null,null,null,null,null,null,null,"2019-10-01",2326,1166,36,692,56,627,4344.3331250000001,null,"2019-10-01",35285,{"$f":"SUM(T67:T78)","v":20308},615,9958,916,7649,null,"2019-10-01",4027,1499,55,945,96,710,4367.018]
[null,null,null,null,"2020-09-01","ELD",208,null,null,null,null,null,null,null,null,null,null,"2019-11-01",2155,1137,38,596,55,614,4559.66482,null,"2019-11-01",{"$f":"SUM(S68:S79)","v":33990},{"$f":"SUM(T68:T79)","v":19604},596,9674,898,7594,null,"2019-11-01",3796,1554,52,895,87,703,4512.4282499999999]
[null,null,null,null,"2020-10-01","ELD",188,null,null,null,null,null,null,null,null,null,null,"2019-12-01",1542,1153,39,519,43,446,4251.1831609999999,null,"2019-12-01",33134,{"$f":"SUM(T69:T80)","v":19122},573,9447,868,7518,null,"2019-12-01",2719,1520,59,790,74,542,4269.6721580000003]
[null,null,null,null,"2020-11-01","ELD",153,null,null,null,null,null,null,null,null,null,null,"2020-01-01",2035,1204,39,606,62,511,4403.1225439999998,null,"2020-01-01",31960,{"$f":"SUM(T70:T81)","v":18536},555,9196,837,7336,null,"2020-01-01",3673,1611,54,948,106,616,4432.8075319999998]
[null,null,null,null,"2020-12-01","ELD",139,null,null,null,null,null,null,null,null,null,null,"2020-02-01",1973,874,24,473,45,530,4469.9464900000003,null,"2020-02-01",30795,{"$f":"SUM(T71:T82)","v":18064},516,9011,807,7278,null,"2020-02-01",3658,1148,41,688,75,616,4438.7770119999996]
[null,null,null,null,"2021-01-01","ELD",245,null,null,null,null,null,null,null,null,null,null,"2020-03-01",1798,1230,41,529,49,544,4561.2821869999998,null,"2020-03-01",29298,{"$f":"SUM(T72:T83)","v":17480},508,8744,786,7116,null,"2020-03-01",3424,1662,61,866,90,650,4519.3539689999998]
[null,null,null,null,"2021-02-01","ELD",161,null,null,null,null,null,null,null,null,null,null,"2020-04-01",1215,1095,32,535,50,461,4440.5187850000002,null,"2020-04-01",27305,{"$f":"SUM(T73:T84)","v":16782},495,8474,769,6899,null,"2020-04-01",2207,1490,50,853,83,563,4459.2569439999997]
[null,null,null,null,"2019-12-01","PL",1578,null,null,null,null,null,null,null,null,null,null,"2020-05-01",902,782,20,352,29,356,4845.8782860000001,null,"2020-05-01",25065,{"$f":"SUM(T74:T85)","v":15664},467,7910,719,6579,null,"2020-05-01",1650,1065,39,549,54,448,4698.7195529999999]
[null,null,null,null,"2020-01-01","PL",2754,null,null,null,null,null,null,null,null,null,null,"2020-06-01",1064,654,22,326,33,378,4815.4210050000002,null,"2020-06-01",{"$f":"SUM(S75:S86)","v":23225},14644,441,7353,680,6376,null,"2020-06-01",1976,846,36,524,72,468,4892.8720940000003]
[null,null,null,null,"2020-02-01","PL",2645,null,null,null,null,null,null,null,null,null,null,"2020-07-01",1188,645,30,380,36,324,4834.0034249999999,null,"2020-07-01",{"$f":"SUM(S76:S87)","v":21013},13409,425,6766,629,6030,null,"2020-07-01",2293,819,41,535,57,374,4706.51901]
[null,null,null,null,"2020-03-01","PL",2586,null,null,null,null,null,null,null,null,null,null,"2020-08-01",1094,657,20,311,27,231,4532.2669260000002,null,"2020-08-01",{"$f":"SUM(S77:S88)","v":19377},{"$f":"SUM(T77:T88)","v":12373},{"$f":"SUM(U77:U88)","v":383},{"$f":"SUM(V77:V88)","v":6169},{"$f":"SUM(W77:W88)","v":580},{"$f":"SUM(X77:X88)","v":5639},null,"2020-08-01",1846,798,30,427,44,254,4394.581338]
[null,null,null,null,"2020-04-01","PL",1703,null,null,null,null,null,null,null,null,null,null,"2020-09-01",1423,709,24,365,41,322,5023.8640370000003,null,"2020-09-01",{"$f":"SUM(S78:S89)","v":18715},{"$f":"SUM(T78:T89)","v":11306},365,{"$f":"SUM(V78:V89)","v":5684},526,{"$f":"SUM(X78:X89)","v":5344},null,"2020-09-01",2625,982,33,536,63,401,4991.5419949999996]
[null,null,null,null,"2020-05-01","PL",1378,null,null,null,null,null,null,null,null,null,null,"2020-10-01",1299,854,15,418,20,327,4979.4476750000003,null,"2020-10-01",{"$f":"SUM(S79:S90)","v":17688},10994,344,5410,490,5044,null,"2020-10-01",2670,1134,26,659,40,417,4906.4452030000002]
[null,null,null,null,"2020-06-01","PL",1658,null,null,null,null,null,null,null,null,null,null,"2020-11-01",1138,835,18,420,19,346,4808.8670229999998,null,"2020-11-01",{"$f":"SUM(S80:S91)","v":16671},10692,324,5234,454,4776,null,"2020-11-01",2230,1112,28,638,44,406,4773.7204179999999]
[null,null,null,null,"2020-07-01","PL",1930,null,null,null,null,null,null,null,null,null,null,"2020-12-01",858,729,22,336,18,266,4543.0488720000003,null,"2020-12-01",{"$f":"SUM(S81:S92)","v":15987},10268,307,5051,429,4596,null,"2020-12-01",1977,980,37,531,45,364,4694.4902739999998]
[null,null,null,null,"2020-08-01","PL",1781,null,null,null,null,null,null,null,null,null,null,"2021-01-01",1379,725,18,366,25,307,4663.6033219999999,null,"2021-01-01",{"$f":"SUM(S82:S93)","v":15331},{"$f":"SUM(T82:T93)","v":9789},{"$f":"SUM(U82:U93)","v":286},{"$f":"SUM(V82:V93)","v":4811},{"$f":"SUM(W82:W93)","v":392},{"$f":"SUM(X82:X93)","v":4392},null,"2021-01-01",2223,992,26,584,44,383,4551.4091900000003]
[null,null,null,null,"2020-09-01","PL",2225,null,null,null,null,null,null,null,null,null,null,"2021-02-01",1502,614,23,380,25,343,4719.332332,null,"2021-02-01",{"$f":"SUM(S83:S94)","v":14860},{"$f":"SUM(T83:T94)","v":9529},{"$f":"SUM(U83:U94)","v":285},{"$f":"SUM(V83:V94)","v":4718},{"$f":"SUM(W83:W94)","v":372},{"$f":"SUM(X83:X94)","v":4205}]
[null,null,null,null,"2020-10-01","PL",2132]
[null,null,null,null,"2020-11-01","PL",1747]
[null,null,null,null,"2020-12-01","PL",1463]
[null,null,null,null,"2021-01-01","PL",1075]
[null,null,null,null,"2021-02-01","PL",1671]

{"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":32845},{"$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":47742},{"$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":43545},{"$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":41076},{"$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":38450},{"$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":21013},{"$f":"SUM('Backing Sheet Data'!T76:T87)","v":13409},{"$f":"SUM('Backing Sheet Data'!U76:U87)","v":425},{"$f":"SUM('Backing Sheet Data'!V76:V87)","v":6766},{"$f":"SUM('Backing Sheet Data'!W76:W87)","v":629},{"$f":"SUM('Backing Sheet Data'!X76:X87)","v":6030}]
["2020-21",{"$f":"SUM('Backing Sheet Data'!S88:S99)","v":8693},{"$f":"SUM('Backing Sheet Data'!T88:T99)","v":5123},{"$f":"SUM('Backing Sheet Data'!U88:U99)","v":140},{"$f":"SUM('Backing Sheet Data'!V88:V99)","v":2596},{"$f":"SUM('Backing Sheet Data'!W88:W99)","v":175},{"$f":"SUM('Backing Sheet Data'!X88:X99)","v":2142}]