{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Backing Sheet Data","Year Calculations"],"not_rendered":{"charts":4,"images":1,"macros":0,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":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":[[8,11,8,12],[8,9,8,10],[8,7,8,8],[6,0,7,12],[8,0,8,6],[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],[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],[0,3,1,4],[2,3,3,4],[4,3,5,4],[16,0,16,6],[16,7,16,8],[15,0,15,6],[15,7,15,8],[9,0,9,6],[10,0,10,6],[11,0,11,6],[0,0,1,2],[2,0,3,2],[4,0,5,2],[0,5,1,8],[2,5,3,8],[4,5,5,8],[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,15,5,16],[4,17,5,20],[0,23,1,25],[2,23,3,25],[4,23,5,25],[0,17,1,20],[2,17,3,20],[0,26,1,27],[2,26,3,27],[4,26,5,27],[4,21,5,22],[0,21,1,22],[2,21,3,22]]}
["Sent this month:",null,null,1671,null,"Left process at stage 1:",null,null,null,1046,null,"Left process at stage 2:",null,null,null,57,null,"Exited process:",null,null,null,324,null,"Settled:",null,null,303]
[]
["Δ from last month:",null,null,-1282,null,"Δ from last month:",null,null,null,-475,null,"Δ from last month:",null,null,null,-7,null,"Δ from last month:",null,null,null,-205,null,"Δ from last month:",null,null,-53]
[]
["Rolling 12 months:",null,null,21349,null,"Rolling 12 months:",null,null,null,17094,null,"Rolling 12 months:",null,null,null,699,null,"Rolling 12 months:",null,null,null,4596,null,"Rolling 12 months:",null,null,3551]
[]
["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,664,null,1083,null,-419]
["Other",null,null,null,null,null,null,382,null,438,null,-56]
["Total",null,null,null,null,null,null,1046,null,1521,null,-475]
["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,2,null,0,null,2]
["Settlement pack timeout:",null,null,null,null,null,null,21,null,21,null,0]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,34,null,43,null,-9]
["Total",null,null,null,null,null,null,57,null,64,null,-7]

{"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":391688},{"$f":"SUBTOTAL(9,tblRTABackingData[CNFs left at Stage 1])","v":246519},{"$f":"SUBTOTAL(9,tblRTABackingData[Stage 2 Exit])","v":4579},{"$f":"SUBTOTAL(9,tblRTABackingData[Exit process])","v":67947},{"$f":"SUBTOTAL(9,tblRTABackingData[Court Pack])","v":4325},{"$f":"SUBTOTAL(9,tblRTABackingData[Settled claims])","v":43097},{"$f":"SUBTOTAL(9,tblRTABackingData[General Damages])","v":347035.81314299995}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages",null,"Period","Rolling 12 CNF Sent","Rolling 12 CNF Left at Stage 1","Rolling 12 Stage 2 Exit","Rolling 12 Exit Process","Rolling 12 Court Pack","Rolling 12 Settled Claims",null,"Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages"]
["Rolling 12 CNFs sent",null,null,null,"Average General Damages chart data",null,null,null,"Left Process Breakdown",null,null,null,null,null,null,null,null,"2013-08-01",370,6,0,27,0,0,null,null,"2013-08-01",null,null,null,null,null,null,null,"2013-08-01",370,6,0,27,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01",1845,208,0,91,0,4,1300,null,"2013-09-01",null,null,null,null,null,null,null,"2013-09-01",1849,208,0,91,0,4,1300]
["Period","Rolling 12 Sent",null,null,"Row Labels","Ave General Damages",null,null,"This Month LDT","This Month Other Liability","This Month Interim Payment Not Agreed","This Month Repudiated","This Month Timeout","This Month Court Proceedings",null,null,null,"2013-10-01",3376,840,1,224,0,8,1281.25,null,"2013-10-01",null,null,null,null,null,null,null,"2013-10-01",3391,840,1,224,0,8,1281.25]
["2020-03-01",53596,null,null,"2020-03-01",4499.4235040000003,null,null,664,382,0,2,21,34,null,null,null,"2013-11-01",3843,1558,0,271,0,39,1977.948717,null,"2013-11-01",null,null,null,null,null,null,null,"2013-11-01",3851,1558,0,271,0,39,1977.948717]
["2020-04-01",52039,null,null,"2020-04-01",4507.7849999999999,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01",3352,1837,6,293,0,50,2105,null,"2013-12-01",null,null,null,null,null,null,null,"2013-12-01",3361,1837,6,293,0,50,2105]
["2020-05-01",50016,null,null,"2020-05-01",4405.3313260000004,null,null,"CNF Sent Monthly Volumes Chart Data",null,null,null,null,null,null,null,null,"2014-01-01",5225,2352,10,479,2,108,2417.3500920000001,null,"2014-01-01",null,null,null,null,null,null,null,"2014-01-01",5241,2352,10,479,2,108,2417.3500920000001]
["2020-06-01",48632,null,null,"2020-06-01",4551.1616160000003,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01",5088,2165,16,443,4,149,2474.980067,null,"2014-02-01",null,null,null,null,null,null,null,"2014-02-01",5112,2165,16,443,4,149,2474.980067]
["2020-07-01",46886,null,null,"2020-07-01",4857.1925090000004,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2014-03-01",5767,3147,29,581,5,208,2764.1224510000002,null,"2014-03-01",null,null,null,null,null,null,null,"2014-03-01",5783,3147,29,581,5,208,2764.1224510000002]
["2020-08-01",45143,null,null,"2020-08-01",4876.1381250000004,null,null,"Row Labels","RTA","PL","ELD","EL",null,"Grand Total",null,null,"2014-04-01",5507,3269,26,675,7,245,2658.4375100000002,null,"2014-04-01",null,null,null,null,null,null,null,"2014-04-01",5531,3269,26,675,7,245,2658.4375100000002]
["2020-09-01",44556,null,null,"2020-09-01",4371.7848050000002,null,null,"2020-03-01",49232,2586,192,1798,3460,57268,null,null,"2014-05-01",5820,3467,34,730,4,269,2944.2115610000001,null,"2014-05-01",null,null,null,null,null,null,null,"2014-05-01",5843,3467,34,730,4,269,2944.2115610000001]
["2020-10-01",43621,null,null,"2020-10-01",4653.5541389999999,null,null,"2020-04-01",24499,1703,262,1215,2241,29920,null,null,"2014-06-01",6194,3535,41,749,22,344,3020.030377,null,"2014-06-01",null,null,null,null,null,null,null,"2014-06-01",6217,3535,41,749,22,344,3020.030377]
["2020-11-01",42531,null,null,"2020-11-01",4810.5994840000003,null,null,"2020-05-01",22866,1378,164,902,1818,27128,null,null,"2014-07-01",7212,3973,53,881,19,446,3146.8208960000002,null,"2014-07-01",{"$f":"SUM(S4:S15)","v":53599},{"$f":"SUM(T4:T15)","v":26357},216,5444,63,1870,null,"2014-07-01",7252,3973,53,881,19,446,3146.8208960000002]
["2020-12-01",41631,null,null,"2020-12-01",4413.989243,null,null,"2020-06-01",32354,1658,162,1064,2235,37473,null,null,"2014-08-01",6132,3643,37,754,13,384,3308.3370570000002,null,"2014-08-01",59361,{"$f":"SUM(T5:T16)","v":29994},253,6171,76,2254,null,"2014-08-01",6165,3643,37,754,13,384,3308.3370570000002]
["2021-01-01",22323,null,null,"2021-01-01",4511.2890550000002,null,null,"2020-07-01",39916,1930,199,1188,2679,45912,null,null,"2014-09-01",7231,4136,62,1008,22,485,3106.994659,null,"2014-09-01",64747,{"$f":"SUM(T6:T17)","v":33922},315,7088,98,2735,null,"2014-09-01",7274,4136,62,1008,22,485,3106.994659]
["2021-02-01",{"$f":"VLOOKUP(A18,tblPrevious12[#All],2,FALSE)","v":21349},null,null,"2021-02-01",4595.1910230000003,null,null,"2020-08-01",37522,1781,119,1094,2425,42941,null,null,"2014-10-01",7631,4310,60,1134,34,616,3176.7030840000002,null,"2014-10-01",69002,{"$f":"SUM(T7:T18)","v":37392},374,7998,132,3343,null,"2014-10-01",7688,4310,60,1134,34,616,3176.7030840000002]
[null,null,null,null,"Grand Total",55053.439829000003,null,null,"2020-09-01",44540,2225,208,1423,3218,51614,null,null,"2014-11-01",6213,4079,62,971,28,563,3329.6076549999998,null,"2014-11-01",71372,{"$f":"SUM(T8:T19)","v":39913},436,8698,160,3867,null,"2014-11-01",6262,4079,62,971,28,563,3329.6076549999998]
[null,null,null,null,null,null,null,null,"2020-10-01",45389,2132,188,1299,3335,52343,null,null,"2014-12-01",5218,4091,62,979,37,579,3291.0112079999999,null,"2014-12-01",73238,{"$f":"SUM(T9:T20)","v":42167},492,9384,197,4396,null,"2014-12-01",5256,4091,62,979,37,579,3291.0112079999999]
[null,null,null,null,null,null,null,null,"2020-11-01",41998,1747,153,1138,3106,48142,null,null,"2015-01-01",6172,3618,55,977,28,633,3313.3723060000002,null,"2015-01-01",74185,{"$f":"SUM(T10:T21)","v":43433},537,9882,223,4921,null,"2015-01-01",6220,3618,55,977,28,633,3313.3723060000002]
[null,{"$f":"SUBTOTAL(9,B24:B33)","v":80100},null,null,"CNF Sent Monthly Volumes",null,null,null,"2020-12-01",35772,1463,139,858,2306,40538,null,null,"2015-02-01",6292,3152,67,833,43,633,3339.5623529999998,null,"2015-02-01",75389,{"$f":"SUM(T11:T22)","v":44420},588,10272,262,5405,null,"2015-02-01",6330,3152,67,833,43,633,3339.5623529999998]
["Exit Process Reason","Total",null,null,null,null,null,null,"2021-01-01",37685,1075,245,1379,2805,43189,null,null,"2015-03-01",6681,4068,65,1072,38,730,3404.7033419999998,null,"2015-03-01",76303,{"$f":"SUM(T12:T23)","v":45341},624,10763,295,5927,null,"2015-03-01",6750,4068,65,1072,38,730,3404.7033419999998]
["Other",35023,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2021-02-01",33533,1671,161,1502,1894,38761,null,null,"2015-04-01",5851,3802,79,953,40,661,3577.5724650000002,null,"2015-04-01",76647,{"$f":"SUM(T13:T24)","v":45874},677,11041,328,6343,null,"2015-04-01",5915,3802,79,953,40,661,3577.5724650000002]
["Claim requires further investigation",26306,null,null,"2019-12-01","RTA",39231,null,"Grand Total",445306,21349,2192,14860,31522,515229,null,null,"2015-05-01",5354,3397,70,949,29,632,3448.4915339999998,null,"2015-05-01",76181,{"$f":"SUM(T14:T25)","v":45804},713,11260,353,6706,null,"2015-05-01",5415,3397,70,949,29,632,3448.4915339999998]
["Duplicated claim",7009,null,null,"2020-01-01","RTA",60003,null,null,null,null,null,null,null,null,null,null,"2015-06-01",6295,3939,59,1006,40,729,3627.6689430000001,null,"2015-06-01",76282,{"$f":"SUM(T15:T26)","v":46208},731,11517,371,7091,null,"2015-06-01",6378,3939,59,1006,40,729,3627.6689430000001]
["Incomplete information provided on CNF",5308,null,null,"2020-02-01","RTA",55459,null,null,null,null,null,null,null,null,null,null,"2015-07-01",6726,3911,75,1063,44,748,3798.3083550000001,null,"2015-07-01",75796,{"$f":"SUM(T16:T27)","v":46146},753,11699,396,7393,null,"2015-07-01",6816,3911,75,1063,44,748,3798.3083550000001]
["Withdrawal of claim",2716,null,null,"2020-03-01","RTA",49232,null,null,null,null,null,null,null,null,null,null,"2015-08-01",5874,3590,60,939,38,626,3750.637843,null,"2015-08-01",75538,{"$f":"SUM(T17:T28)","v":46093},776,11884,421,7635,null,"2015-08-01",5962,3590,60,939,38,626,3750.637843]
["Value of claim exceeds the upper limit",2219,null,null,"2020-04-01","RTA",24499,null,null,null,null,null,null,null,null,null,null,"2015-09-01",6091,3947,79,1028,52,675,3700.0653619999998,null,"2015-09-01",74398,{"$f":"SUM(T18:T29)","v":45904},793,11904,451,7825,null,"2015-09-01",6183,3947,79,1028,52,675,3700.0653619999998]
["Claim is too complex for process",785,null,null,"2020-05-01","RTA",22866,null,null,null,null,null,null,null,null,null,null,"2015-10-01",6046,3769,68,1020,42,722,3454.2663149999998,null,"2015-10-01",72813,{"$f":"SUM(T19:T30)","v":45363},801,11790,459,7931,null,"2015-10-01",6164,3769,68,1020,42,722,3454.2663149999998]
["Value of claim below ú1,000",415,null,null,"2020-06-01","RTA",32354,null,null,null,null,null,null,null,null,null,null,"2015-11-01",5742,3603,85,1008,50,709,3808.7843579999999,null,"2015-11-01",72342,{"$f":"SUM(T20:T31)","v":44887},824,11827,481,8077,null,"2015-11-01",5843,3603,85,1008,50,709,3808.7843579999999]
["Withdrawal of offer",259,null,null,"2020-07-01","RTA",39916,null,null,null,null,null,null,null,null,null,null,"2015-12-01",4505,3447,87,881,45,640,3785.0480309999998,null,"2015-12-01",71629,{"$f":"SUM(T21:T32)","v":44243},849,11729,489,8138,null,"2015-12-01",4584,3447,87,881,45,640,3785.0480309999998]
["Interim payment for child claimant",60,null,null,"2020-08-01","RTA",37522,null,null,null,null,null,null,null,null,null,null,"2016-01-01",5113,3271,60,933,39,620,3964.2704669999998,null,"2016-01-01",70570,{"$f":"SUM(T22:T33)","v":43896},854,11685,500,8125,null,"2016-01-01",5224,3271,60,933,39,620,3964.2704669999998]
[null,null,null,null,"2020-09-01","RTA",44540,null,null,null,null,null,null,null,null,null,null,"2016-02-01",5607,2786,61,859,51,662,3763.3202409999999,null,"2016-02-01",69885,{"$f":"SUM(T23:T34)","v":43530},848,11711,508,8154,null,"2016-02-01",5741,2786,61,859,51,662,3763.3202409999999]
[null,null,null,null,"2020-10-01","RTA",45389,null,null,null,null,null,null,null,null,null,null,"2016-03-01",5600,3433,76,1026,50,676,3927.2018629999998,null,"2016-03-01",68804,{"$f":"SUM(T24:T35)","v":42895},859,11665,520,8100,null,"2016-03-01",5739,3433,76,1026,50,676,3927.2018629999998]
[null,null,null,null,"2020-11-01","RTA",41998,null,null,null,null,null,null,null,null,null,null,"2016-04-01",5302,3395,80,981,45,661,3835.1196060000002,null,"2016-04-01",68255,{"$f":"SUM(T25:T36)","v":42488},860,11693,525,8100,null,"2016-04-01",5467,3395,80,981,45,662,3829.3263740000002]
[null,null,null,null,"2020-12-01","RTA",35772,null,null,null,null,null,null,null,null,null,null,"2016-05-01",4848,3163,71,982,45,568,3940.3162499999999,null,"2016-05-01",67749,{"$f":"SUM(T26:T37)","v":42254},861,11726,541,8036,null,"2016-05-01",5008,3163,71,982,45,568,3940.3162499999999]
[null,null,null,null,"2021-01-01","RTA",37685,null,null,null,null,null,null,null,null,null,null,"2016-06-01",4289,3405,87,973,68,627,3940.8149440000002,null,"2016-06-01",65743,{"$f":"SUM(T27:T38)","v":41720},889,11693,569,7934,null,"2016-06-01",4436,3405,87,973,68,627,3940.8149440000002]
[null,null,null,null,"2021-02-01","RTA",33533,null,null,null,null,null,null,null,null,null,null,"2016-07-01",4666,2698,91,884,54,526,4052.135988,null,"2016-07-01",63683,{"$f":"SUM(T28:T39)","v":40507},905,11514,579,7712,null,"2016-07-01",4825,2698,91,884,54,526,4052.135988]
[null,null,null,null,"2019-12-01","",1975,null,null,null,null,null,null,null,null,null,null,"2016-08-01",5190,2216,38,606,35,560,3937.6303750000002,null,"2016-08-01",62999,{"$f":"SUM(T29:T40)","v":39133},883,11181,576,7646,null,"2016-08-01",5351,2216,38,606,35,561,3945.6738140000002]
[null,null,null,null,"2020-01-01","",3643,null,null,null,null,null,null,null,null,null,null,"2016-09-01",5466,3277,84,954,77,604,3909.7556949999998,null,"2016-09-01",62374,{"$f":"SUM(T30:T41)","v":38463},888,11107,601,7575,null,"2016-09-01",5700,3277,84,954,77,604,3909.7556949999998]
[null,null,null,null,"2020-02-01","",3690,null,null,null,null,null,null,null,null,null,null,"2016-10-01",4893,3203,87,991,53,606,3812.8383330000001,null,"2016-10-01",61221,{"$f":"SUM(T31:T42)","v":37897},907,11078,612,7459,null,"2016-10-01",5182,3203,87,991,53,611,3817.7136329999998]
[null,null,null,null,"2020-03-01","",3460,null,null,null,null,null,null,null,null,null,null,"2016-11-01",4806,3320,86,939,61,600,4029.7997500000001,null,"2016-11-01",60285,{"$f":"SUM(T32:T43)","v":37614},908,11009,623,7350,null,"2016-11-01",5207,3320,86,939,61,602,4037.5911120000001]
[null,null,null,null,"2020-04-01","",2241,null,null,null,null,null,null,null,null,null,null,"2016-12-01",3563,2775,76,784,56,518,4150.8153860000002,null,"2016-12-01",59343,{"$f":"SUM(T33:T44)","v":36942},897,10912,634,7228,null,"2016-12-01",3892,2775,76,784,56,537,4184.4410980000002]
[null,null,null,null,"2020-05-01","",1818,null,null,null,null,null,null,null,null,null,null,"2017-01-01",4635,2833,74,878,85,549,3828.3515480000001,null,"2017-01-01",58865,{"$f":"SUM(T34:T45)","v":36504},911,10857,680,7157,null,"2017-01-01",5119,2833,74,878,85,574,3854.9294249999998]
[null,null,null,null,"2020-06-01","",2235,null,null,null,null,null,null,null,null,null,null,"2017-02-01",4445,2374,56,750,64,580,3937.6632239999999,null,"2017-02-01",57703,{"$f":"SUM(T35:T46)","v":36092},906,10748,693,7075,null,"2017-02-01",4907,2374,56,750,64,599,3942.1031210000001]
[null,null,null,null,"2020-07-01","",2679,null,null,null,null,null,null,null,null,null,null,"2017-03-01",5321,3297,80,944,78,634,4175.6838170000001,null,"2017-03-01",{"$f":"SUM(S36:S47)","v":57424},{"$f":"SUM(T36:T47)","v":35956},910,10666,721,7033,null,"2017-03-01",5804,3297,80,944,78,650,4167.2315230000004]
[null,null,null,null,"2020-08-01","",2425,null,null,null,null,null,null,null,null,null,null,"2017-04-01",3778,2622,66,742,44,555,4283.8405579999999,null,"2017-04-01",55900,{"$f":"SUM(T37:T48)","v":35183},896,10427,720,6927,null,"2017-04-01",4124,2622,66,742,44,568,4270.8655099999996]
[null,null,null,null,"2020-09-01","",3218,null,null,null,null,null,null,null,null,null,null,"2017-05-01",4619,3139,63,873,77,623,3954.526597,null,"2017-05-01",55671,{"$f":"SUM(T38:T49)","v":35159},888,10318,752,6982,null,"2017-05-01",5058,3139,63,873,77,637,4016.5316320000002]
[null,null,null,null,"2020-10-01","",3335,null,null,null,null,null,null,null,null,null,null,"2017-06-01",4564,2962,67,891,72,579,4250.5384620000004,null,"2017-06-01",55946,{"$f":"SUM(T39:T50)","v":34716},868,10236,756,6934,null,"2017-06-01",4984,2962,67,891,72,599,4289.4138059999996]
[null,null,null,null,"2020-11-01","",3106,null,null,null,null,null,null,null,null,null,null,"2017-07-01",4449,2907,64,909,87,557,4291.4689040000003,null,"2017-07-01",55729,{"$f":"SUM(T40:T51)","v":34925},841,10261,789,6965,null,"2017-07-01",4865,2907,64,909,87,570,4294.2862800000003]
[null,null,null,null,"2020-12-01","",2306,null,null,null,null,null,null,null,null,null,null,"2017-08-01",4750,2924,62,901,72,548,4113.923667,null,"2017-08-01",55289,{"$f":"SUM(T41:T52)","v":35633},865,10556,826,6953,null,"2017-08-01",5186,2924,62,901,72,560,4116.7503029999998]
[null,null,null,null,"2021-01-01","",2805,null,null,null,null,null,null,null,null,null,null,"2017-09-01",4459,2888,57,823,65,520,3992.4600190000001,null,"2017-09-01",54282,{"$f":"SUM(T42:T53)","v":35244},838,10425,814,6869,null,"2017-09-01",4906,2888,57,823,65,537,4020.2592359999999]
[null,null,null,null,"2021-02-01","",1894,null,null,null,null,null,null,null,null,null,null,"2017-10-01",4783,3055,64,894,84,542,4054.3269180000002,null,"2017-10-01",54172,{"$f":"SUM(T43:T54)","v":35096},815,10328,845,6805,null,"2017-10-01",5256,3055,64,894,84,560,4083.8753390000002]
[null,null,null,null,"2019-12-01","EL",1173,null,null,null,null,null,null,null,null,null,null,"2017-11-01",4745,3115,52,922,89,562,4275.2169569999996,null,"2017-11-01",54111,{"$f":"SUM(T44:T55)","v":34891},781,10311,873,6767,null,"2017-11-01",5165,3115,52,922,89,575,4293.3424859999996]
[null,null,null,null,"2020-01-01","EL",2035,null,null,null,null,null,null,null,null,null,null,"2017-12-01",3208,2616,58,766,73,436,4181.0074539999996,null,"2017-12-01",53756,{"$f":"SUM(T45:T56)","v":34732},763,10293,890,6685,null,"2017-12-01",3611,2616,58,766,73,447,4242.8048989999998]
[null,null,null,null,"2020-02-01","EL",1973,null,null,null,null,null,null,null,null,null,null,"2018-01-01",4668,2877,47,890,75,505,4094.6545740000001,null,"2018-01-01",53789,{"$f":"SUM(T46:T57)","v":34776},736,10305,880,6641,null,"2018-01-01",5161,2877,47,890,75,521,4110.3657579999999]
[null,null,null,null,"2020-03-01","EL",1798,null,null,null,null,null,null,null,null,null,null,"2018-02-01",4492,2271,52,744,61,542,4224.0598330000003,null,"2018-02-01",53836,{"$f":"SUM(T47:T58)","v":34673},732,10299,877,6603,null,"2018-02-01",4956,2271,52,744,61,554,4213.6596200000004]
[null,null,null,null,"2020-04-01","EL",1215,null,null,null,null,null,null,null,null,null,null,"2018-03-01",4364,2970,73,893,81,565,4118.3931849999999,null,"2018-03-01",52879,{"$f":"SUM(T48:T59)","v":34346},725,10248,880,6534,null,"2018-03-01",4822,2970,73,893,81,576,4151.8092880000004]
[null,null,null,null,"2020-05-01","EL",902,null,null,null,null,null,null,null,null,null,null,"2018-04-01",4209,2772,69,825,55,525,4323.413485,null,"2018-04-01",53310,{"$f":"SUM(T49:T60)","v":34496},728,10331,891,6504,null,"2018-04-01",4664,2772,69,825,55,538,4344.9202230000001]
[null,null,null,null,"2020-06-01","EL",1064,null,null,null,null,null,null,null,null,null,null,"2018-05-01",4279,2887,62,889,73,550,4171.9078719999998,null,"2018-05-01",52970,{"$f":"SUM(T50:T61)","v":34244},727,10347,887,6431,null,"2018-05-01",4739,2887,62,889,73,567,4182.4503169999998]
[null,null,null,null,"2020-07-01","EL",1188,null,null,null,null,null,null,null,null,null,null,"2018-06-01",4265,2818,56,819,78,530,3953.9589810000002,null,"2018-06-01",52671,{"$f":"SUM(T51:T62)","v":34100},716,10275,893,6382,null,"2018-06-01",4741,2818,56,819,78,544,3965.8975359999999]
[null,null,null,null,"2020-08-01","EL",1094,null,null,null,null,null,null,null,null,null,null,"2018-07-01",4385,2817,51,939,69,485,4291.491051,null,"2018-07-01",52607,{"$f":"SUM(T52:T63)","v":34010},703,10305,875,6310,null,"2018-07-01",4848,2817,51,939,69,502,4339.6875689999997]
[null,null,null,null,"2020-09-01","EL",1423,null,null,null,null,null,null,null,null,null,null,"2018-08-01",4418,2911,57,905,76,495,4343.665696,null,"2018-08-01",52275,{"$f":"SUM(T53:T64)","v":33997},698,10309,879,6257,null,"2018-08-01",4892,2911,57,905,76,505,4379.1376630000004]
[null,null,null,null,"2020-10-01","EL",1299,null,null,null,null,null,null,null,null,null,null,"2018-09-01",4270,2565,50,848,60,428,4272.0774760000004,null,"2018-09-01",52086,{"$f":"SUM(T54:T65)","v":33674},691,10334,874,6165,null,"2018-09-01",4735,2565,50,848,60,443,4282.2780130000001]
[null,null,null,null,"2020-11-01","EL",1138,null,null,null,null,null,null,null,null,null,null,"2018-10-01",4802,3010,48,985,70,544,4282.5679769999997,null,"2018-10-01",52105,{"$f":"SUM(T55:T66)","v":33629},675,10425,860,6167,null,"2018-10-01",5369,3010,48,985,70,560,4335.4767499999998]
[null,null,null,null,"2020-12-01","EL",858,null,null,null,null,null,null,null,null,null,null,"2018-11-01",4674,3053,54,979,59,616,4333.2169800000001,null,"2018-11-01",52034,{"$f":"SUM(T56:T67)","v":33567},677,10482,830,6221,null,"2018-11-01",5180,3053,54,979,59,627,4329.4685639999998]
[null,null,null,null,"2021-01-01","EL",1379,null,null,null,null,null,null,null,null,null,null,"2018-12-01",3053,2557,43,742,48,461,3924.0701730000001,null,"2018-12-01",51879,{"$f":"SUM(T57:T68)","v":33508},662,10458,805,6246,null,"2018-12-01",3432,2557,43,742,48,471,3918.6642459999998]
[null,null,null,null,"2021-02-01","EL",1502,null,null,null,null,null,null,null,null,null,null,"2019-01-01",4101,3001,60,818,82,516,4202.5022479999998,null,"2019-01-01",51312,{"$f":"SUM(T58:T69)","v":33632},675,10386,812,6257,null,"2019-01-01",4652,3001,60,818,82,538,4257.2791070000003]
[null,null,null,null,"2019-12-01","ELD",127,null,null,null,null,null,null,null,null,null,null,"2019-02-01",4037,2096,55,615,66,535,3943.7700559999998,null,"2019-02-01",50857,{"$f":"SUM(T59:T70)","v":33457},678,10257,817,6250,null,"2019-02-01",4582,2096,55,615,66,546,3956.2582050000001]
[null,null,null,null,"2020-01-01","ELD",218,null,null,null,null,null,null,null,null,null,null,"2019-03-01",4272,2831,45,773,82,624,4377.1120190000001,null,"2019-03-01",50765,{"$f":"SUM(T60:T71)","v":33318},650,10137,818,6309,null,"2019-03-01",4831,2831,45,773,82,643,4356.284447]
[null,null,null,null,"2020-02-01","ELD",228,null,null,null,null,null,null,null,null,null,null,"2019-04-01",3833,2782,50,729,69,502,4226.2633660000001,null,"2019-04-01",50389,{"$f":"SUM(T61:T72)","v":33328},631,10041,832,6286,null,"2019-04-01",4401,2782,50,729,69,514,4257.751381]
[null,null,null,null,"2020-03-01","ELD",192,null,null,null,null,null,null,null,null,null,null,"2019-05-01",3829,2882,45,850,72,528,4206.9716660000004,null,"2019-05-01",49939,{"$f":"SUM(T62:T73)","v":33323},614,10002,831,6264,null,"2019-05-01",4374,2882,45,850,72,545,4283.9964950000003]
[null,null,null,null,"2020-04-01","ELD",262,null,null,null,null,null,null,null,null,null,null,"2019-06-01",3624,2614,61,729,79,465,4237.3921289999998,null,"2019-06-01",49298,{"$f":"SUM(T63:T74)","v":33119},619,9912,832,6199,null,"2019-06-01",4188,2614,61,729,79,476,4252.704495]
[null,null,null,null,"2020-05-01","ELD",164,null,null,null,null,null,null,null,null,null,null,"2019-07-01",4394,2851,52,889,78,551,4510.4612880000004,null,"2019-07-01",49307,{"$f":"SUM(T64:T75)","v":33153},620,9862,841,6265,null,"2019-07-01",5078,2851,52,889,78,569,4552.9510890000001]
[null,null,null,null,"2020-06-01","ELD",162,null,null,null,null,null,null,null,null,null,null,"2019-08-01",3523,2607,44,780,82,457,4378.5160169999999,null,"2019-08-01",48412,{"$f":"SUM(T65:T76)","v":32849},607,9737,847,6227,null,"2019-08-01",4784,2607,44,780,82,472,4406.4034320000001]
[null,null,null,null,"2020-07-01","ELD",199,null,null,null,null,null,null,null,null,null,null,"2019-09-01",2985,2850,45,785,57,455,4215.2354500000001,null,"2019-09-01",47127,{"$f":"SUM(T66:T77)","v":33134},602,9674,844,6254,null,"2019-09-01",4514,2850,45,791,59,480,4234.2869369999999]
[null,null,null,null,"2020-08-01","ELD",119,null,null,null,null,null,null,null,null,null,null,"2019-10-01",2971,2150,46,611,58,458,4489.3560040000002,null,"2019-10-01",45296,{"$f":"SUM(T67:T78)","v":32274},600,9300,832,6168,null,"2019-10-01",4860,2554,67,851,89,550,4512.5319449999997]
[null,null,null,null,"2020-09-01","ELD",208,null,null,null,null,null,null,null,null,null,null,"2019-11-01",2684,1809,24,589,50,435,4169.8663210000004,null,"2019-11-01",{"$f":"SUM(S68:S79)","v":43306},{"$f":"SUM(T68:T79)","v":31030},570,8910,823,5987,null,"2019-11-01",4516,2210,40,806,77,511,4165.4439329999996]
[null,null,null,null,"2020-10-01","ELD",188,null,null,null,null,null,null,null,null,null,null,"2019-12-01",2056,1690,30,482,40,368,4211.6653260000003,null,"2019-12-01",42309,{"$f":"SUM(T69:T80)","v":30163},557,8650,815,5894,null,"2019-12-01",3415,2110,43,724,58,430,4213.0240460000005]
[null,null,null,null,"2020-11-01","ELD",153,null,null,null,null,null,null,null,null,null,null,"2020-01-01",2754,1815,23,551,46,447,4328.0908939999999,null,"2020-01-01",40962,{"$f":"SUM(T70:T81)","v":28977},520,8383,779,5825,null,"2020-01-01",4668,2270,40,806,62,515,4338.7701550000002]
[null,null,null,null,"2020-12-01","ELD",139,null,null,null,null,null,null,null,null,null,null,"2020-02-01",2645,1406,26,468,53,411,4237.3796830000001,null,"2020-02-01",39570,{"$f":"SUM(T71:T82)","v":28287},491,8236,766,5701,null,"2020-02-01",4534,1714,41,689,84,491,4327.5731969999997]
[null,null,null,null,"2021-01-01","ELD",245,null,null,null,null,null,null,null,null,null,null,"2020-03-01",2586,1937,43,576,46,408,4499.4235040000003,null,"2020-03-01",37884,{"$f":"SUM(T72:T83)","v":27393},489,8039,730,5485,null,"2020-03-01",4310,2417,70,878,74,497,4435.1404220000004]
[null,null,null,null,"2021-02-01","ELD",161,null,null,null,null,null,null,null,null,null,null,"2020-04-01",1703,1879,33,501,47,400,4507.7849999999999,null,"2020-04-01",35754,{"$f":"SUM(T73:T84)","v":26490},472,7811,708,5383,null,"2020-04-01",2857,2362,49,754,67,463,4444.0043409999998]
[null,null,null,null,"2019-12-01","PL",1578,null,null,null,null,null,null,null,null,null,null,"2020-05-01",1378,1422,23,399,47,309,4405.3313260000004,null,"2020-05-01",33303,{"$f":"SUM(T74:T85)","v":25030},450,7360,683,5164,null,"2020-05-01",2284,1801,32,608,72,392,4446.4218870000004]
[null,null,null,null,"2020-01-01","PL",2754,null,null,null,null,null,null,null,null,null,null,"2020-06-01",1658,1299,27,336,37,297,4551.1616160000003,null,"2020-06-01",{"$f":"SUM(S75:S86)","v":31337},23715,416,6967,641,4996,null,"2020-06-01",2713,1512,42,513,56,361,4457.8814949999996]
[null,null,null,null,"2020-02-01","PL",2645,null,null,null,null,null,null,null,null,null,null,"2020-07-01",1930,1164,22,343,31,255,4857.1925090000004,null,"2020-07-01",{"$f":"SUM(S76:S87)","v":28873},22028,386,6421,594,4700,null,"2020-07-01",3147,1378,37,488,47,310,4767.5551290000003]
[null,null,null,null,"2020-03-01","PL",2586,null,null,null,null,null,null,null,null,null,null,"2020-08-01",1781,1126,21,305,21,208,4876.1381250000004,null,"2020-08-01",{"$f":"SUM(S77:S88)","v":27131},{"$f":"SUM(T77:T88)","v":20547},363,5946,533,4451,null,"2020-08-01",2544,1217,30,422,35,228,4843.45057]
[null,null,null,null,"2020-04-01","PL",1703,null,null,null,null,null,null,null,null,null,null,"2020-09-01",2225,1370,20,381,29,283,4371.7848050000002,null,"2020-09-01",{"$f":"SUM(S78:S89)","v":26371},19067,338,5542,505,4279,null,"2020-09-01",3548,1629,35,545,51,325,4378.5079999999998]
[null,null,null,null,"2020-05-01","PL",1378,null,null,null,null,null,null,null,null,null,null,"2020-10-01",2132,1491,26,377,31,273,4653.5541389999999,null,"2020-10-01",{"$f":"SUM(S79:S90)","v":25532},18408,318,5308,478,4094,null,"2020-10-01",3817,1749,41,623,49,328,4633.476463]
[null,null,null,null,"2020-06-01","PL",1658,null,null,null,null,null,null,null,null,null,null,"2020-11-01",1747,1604,30,415,26,291,4810.5994840000003,null,"2020-11-01",{"$f":"SUM(S80:S91)","v":24595},18203,324,5134,454,3950,null,"2020-11-01",3172,1907,48,624,43,343,4743.3511660000004]
[null,null,null,null,"2020-07-01","PL",1930,null,null,null,null,null,null,null,null,null,null,"2020-12-01",1463,1527,22,337,29,238,4413.989243,null,"2020-12-01",{"$f":"SUM(S81:S92)","v":24002},{"$f":"SUM(T81:T92)","v":18040},316,4989,443,3820,null,"2020-12-01",2510,1794,29,576,55,306,4367.7515030000004]
[null,null,null,null,"2020-08-01","PL",1781,null,null,null,null,null,null,null,null,null,null,"2021-01-01",1075,1229,13,302,18,286,4511.2890550000002,null,"2021-01-01",{"$f":"SUM(S82:S93)","v":22323},17454,306,4740,415,3659,null,"2021-01-01",2953,1521,21,529,43,356,4548.3069660000001]
[null,null,null,null,"2020-09-01","PL",2225,null,null,null,null,null,null,null,null,null,null,"2021-02-01",1671,1046,23,324,34,303,4595.1910230000003,null,"2021-02-01",{"$f":"SUM(S83:S94)","v":21349},17094,303,4596,396,3551]
[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":53599},{"$f":"SUM('Backing Sheet Data'!T4:T15)","v":26357},{"$f":"SUM('Backing Sheet Data'!U4:U15)","v":216},{"$f":"SUM('Backing Sheet Data'!V4:V15)","v":5444},{"$f":"SUM('Backing Sheet Data'!W4:W15)","v":63},{"$f":"SUM('Backing Sheet Data'!X4:X15)","v":1870}]
["2014-15",{"$f":"SUM('Backing Sheet Data'!S16:S27)","v":75796},{"$f":"SUM('Backing Sheet Data'!T16:T27)","v":46146},{"$f":"SUM('Backing Sheet Data'!U16:U27)","v":753},{"$f":"SUM('Backing Sheet Data'!V16:V27)","v":11699},{"$f":"SUM('Backing Sheet Data'!W16:W27)","v":396},{"$f":"SUM('Backing Sheet Data'!X16:X27)","v":7393}]
["2015-16",{"$f":"SUM('Backing Sheet Data'!S28:S39)","v":63683},{"$f":"SUM('Backing Sheet Data'!T28:T39)","v":40507},{"$f":"SUM('Backing Sheet Data'!U28:U39)","v":905},{"$f":"SUM('Backing Sheet Data'!V28:V39)","v":11514},{"$f":"SUM('Backing Sheet Data'!W28:W39)","v":579},{"$f":"SUM('Backing Sheet Data'!X28:X39)","v":7712}]
["2016-17",{"$f":"SUM('Backing Sheet Data'!S40:S51)","v":55729},{"$f":"SUM('Backing Sheet Data'!T40:T51)","v":34925},{"$f":"SUM('Backing Sheet Data'!U40:U51)","v":841},{"$f":"SUM('Backing Sheet Data'!V40:V51)","v":10261},{"$f":"SUM('Backing Sheet Data'!W40:W51)","v":789},{"$f":"SUM('Backing Sheet Data'!X40:X51)","v":6965}]
["2017-18",{"$f":"SUM('Backing Sheet Data'!S52:S63)","v":52607},{"$f":"SUM('Backing Sheet Data'!T52:T63)","v":34010},{"$f":"SUM('Backing Sheet Data'!U52:U63)","v":703},{"$f":"SUM('Backing Sheet Data'!V52:V63)","v":10305},{"$f":"SUM('Backing Sheet Data'!W52:W63)","v":875},{"$f":"SUM('Backing Sheet Data'!X52:X63)","v":6310}]
["2018-19",{"$f":"SUM('Backing Sheet Data'!S64:S75)","v":49307},{"$f":"SUM('Backing Sheet Data'!T64:T75)","v":33153},{"$f":"SUM('Backing Sheet Data'!U64:U75)","v":620},{"$f":"SUM('Backing Sheet Data'!V64:V75)","v":9862},{"$f":"SUM('Backing Sheet Data'!W64:W75)","v":841},{"$f":"SUM('Backing Sheet Data'!X64:X75)","v":6265}]
["2019-20",{"$f":"SUM('Backing Sheet Data'!S76:S87)","v":28873},{"$f":"SUM('Backing Sheet Data'!T76:T87)","v":22028},{"$f":"SUM('Backing Sheet Data'!U76:U87)","v":386},{"$f":"SUM('Backing Sheet Data'!V76:V87)","v":6421},{"$f":"SUM('Backing Sheet Data'!W76:W87)","v":594},{"$f":"SUM('Backing Sheet Data'!X76:X87)","v":4700}]
["2020-21",{"$f":"SUM('Backing Sheet Data'!S88:S99)","v":12094},{"$f":"SUM('Backing Sheet Data'!T88:T99)","v":9393},{"$f":"SUM('Backing Sheet Data'!U88:U99)","v":155},{"$f":"SUM('Backing Sheet Data'!V88:V99)","v":2441},{"$f":"SUM('Backing Sheet Data'!W88:W99)","v":188},{"$f":"SUM('Backing Sheet Data'!X88:X99)","v":1882}]