{"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":[[16,0,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[15,0,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,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],[11,0,11,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],[12,0,13,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[14,0,14,6],[0,26,1,27],[2,26,3,27],[4,26,5,27],[9,0,9,6],[10,0,10,6],[2,21,3,22],[0,21,1,22],[4,21,5,22],[0,23,1,25],[2,23,3,25],[4,23,5,25],[0,0,1,2],[2,0,3,2],[4,0,5,2],[8,11,8,12],[8,9,8,10],[8,7,8,8],[6,0,7,12],[8,0,8,6],[2,5,3,8],[4,5,5,8],[2,11,3,14],[4,11,5,14],[0,5,1,8],[0,11,1,14],[0,3,1,4],[2,3,3,4],[4,3,5,4],[0,9,1,10],[2,9,3,10],[4,9,5,10],[0,15,1,16],[2,15,3,16],[4,15,5,16],[0,17,1,20],[2,17,3,20],[4,17,5,20]]}
["Total Sent:",null,null,161,null,"Left process at stage 1:",null,null,null,81,null,"Left process at stage 2:",null,null,null,1,null,"Exited process:",null,null,null,53,null,"Settled:",null,null,45]
[]
["Δ from last month:",null,null,-149,null,"Δ from last month:",null,null,null,-54,null,"Δ from last month:",null,null,null,-1,null,"Δ from last month:",null,null,null,-43,null,"Δ from last month:",null,null,1]
[]
["Rolling 12 months:",null,null,2192,null,"Rolling 12 months:",null,null,null,950,null,"Rolling 12 months:",null,null,null,23,null,"Rolling 12 months:",null,null,null,811,null,"Rolling 12 months:",null,null,440]
[]
["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,48,null,118,null,-70]
["Other",null,null,null,null,null,null,33,null,17,null,16]
["Total",null,null,null,null,null,null,81,null,135,null,-54]
["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,1,null,-1]
["Settlement pack timeout:",null,null,null,null,null,null,1,null,1,null,0]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,0,null,0,null,0]
["Total",null,null,null,null,null,null,1,null,2,null,-1]

{"sheet":"Backing Sheet Data","index":1,"n_rows":99,"n_cols":42,"rows_kept":99,"cut":false,"hidden":true,"merged":[[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":74093},{"$f":"SUBTOTAL(9,tblRTABackingData[CNFs left at Stage 1])","v":31186},{"$f":"SUBTOTAL(9,tblRTABackingData[Stage 2 Exit])","v":961},{"$f":"SUBTOTAL(9,tblRTABackingData[Exit process])","v":31212},{"$f":"SUBTOTAL(9,tblRTABackingData[Court Pack])","v":264},{"$f":"SUBTOTAL(9,tblRTABackingData[Settled claims])","v":4367},{"$f":"SUBTOTAL(9,tblRTABackingData[General Damages])","v":355458.35515199986}]
[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",167,1,0,17,0,0,null,null,"2013-08-01",null,null,null,null,null,null,null,"2013-08-01",167,1,0,17,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01",334,47,0,34,0,0,null,null,"2013-09-01",null,null,null,null,null,null,null,"2013-09-01",334,47,0,34,0,0]
["Period","Rolling 13 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",620,197,0,92,0,0,null,null,"2013-10-01",null,null,null,null,null,null,null,"2013-10-01",620,197,0,92,0,0]
["2020-03-01",4410,null,null,"2020-03-01",4002.032608,null,null,48,33,0,0,1,0,null,null,null,"2013-11-01",814,284,0,126,0,0,null,null,"2013-11-01",null,null,null,null,null,null,null,"2013-11-01",815,284,0,126,0,0]
["2020-04-01",4385,null,null,"2020-04-01",3777.0928260000001,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01",724,346,2,178,0,3,3309.6666660000001,null,"2013-12-01",null,null,null,null,null,null,null,"2013-12-01",724,346,2,178,0,3,3309.6666660000001]
["2020-05-01",4207,null,null,"2020-05-01",4429.0571419999997,null,null,"CNF Sent Monthly Volumes Chart Data",null,null,null,null,null,null,null,null,"2014-01-01",1071,507,1,268,0,5,5208,null,"2014-01-01",null,null,null,null,null,null,null,"2014-01-01",1071,507,1,268,0,5,5208]
["2020-06-01",4120,null,null,"2020-06-01",4034.436326,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01",998,377,3,212,0,21,5377.8590469999999,null,"2014-02-01",null,null,null,null,null,null,null,"2014-02-01",998,377,3,212,0,21,5377.8590469999999]
["2020-07-01",3987,null,null,"2020-07-01",3732.35,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2014-03-01",1249,478,3,374,3,34,5664.8529410000001,null,"2014-03-01",null,null,null,null,null,null,null,"2014-03-01",1251,478,3,374,3,34,5664.8529410000001]
["2020-08-01",3810,null,null,"2020-08-01",3850.1522719999998,null,null,"Row Labels","RTA","PL","ELD","EL",null,"Grand Total",null,null,"2014-04-01",1387,446,5,407,2,32,4801.6068750000004,null,"2014-04-01",null,null,null,null,null,null,null,"2014-04-01",1388,446,5,407,2,32,4801.6068750000004]
["2020-09-01",3742,null,null,"2020-09-01",4315.7894729999998,null,null,"2020-03-01",49232,2586,192,1798,3460,57268,null,null,"2014-05-01",1356,545,4,547,4,42,5028.2223800000002,null,"2014-05-01",null,null,null,null,null,null,null,"2014-05-01",1359,545,4,547,4,42,5028.2223800000002]
["2020-10-01",3625,null,null,"2020-10-01",3781.241818,null,null,"2020-04-01",24499,1703,262,1215,2241,29920,null,null,"2014-06-01",1351,590,14,589,8,74,4828.9143240000003,null,"2014-06-01",null,null,null,null,null,null,null,"2014-06-01",1351,590,14,589,8,74,4828.9143240000003]
["2020-11-01",3610,null,null,"2020-11-01",3507.036486,null,null,"2020-05-01",22866,1378,164,902,1818,27128,null,null,"2014-07-01",1726,543,19,651,3,86,4877.246744,null,"2014-07-01",{"$f":"SUM(S4:S15)","v":11797},{"$f":"SUM(T4:T15)","v":4361},51,3495,20,297,null,"2014-07-01",1727,543,19,651,3,86,4877.246744]
["2020-12-01",3616,null,null,"2020-12-01",3554.7975000000001,null,null,"2020-06-01",32354,1658,162,1064,2235,37473,null,null,"2014-08-01",1302,512,12,654,10,58,4740.3146550000001,null,"2014-08-01",12932,{"$f":"SUM(T5:T16)","v":4872},63,4132,30,355,null,"2014-08-01",1303,512,12,654,10,58,4740.3146550000001]
["2021-01-01",2259,null,null,"2021-01-01",3431.6757499999999,null,null,"2020-07-01",39916,1930,199,1188,2679,45912,null,null,"2014-09-01",1604,559,34,703,10,106,4555.8396220000004,null,"2014-09-01",14202,{"$f":"SUM(T6:T17)","v":5384},97,4801,40,461,null,"2014-09-01",1605,559,34,703,10,106,4555.8396220000004]
["2021-02-01",{"$f":"VLOOKUP(A18,tblPrevious12[],2,FALSE)","v":2192},null,null,"2021-02-01",3844.6666660000001,null,null,"2020-08-01",37522,1781,119,1094,2425,42941,null,null,"2014-10-01",1575,552,34,727,20,106,4804.3396220000004,null,"2014-10-01",15157,{"$f":"SUM(T7:T18)","v":5739},131,5436,60,567,null,"2014-10-01",1584,552,34,727,20,106,4804.3396220000004]
[null,null,null,null,"Grand Total",46260.328866999997,null,null,"2020-09-01",44540,2225,208,1423,3218,51614,null,null,"2014-11-01",1503,535,31,680,11,83,4192.8449389999996,null,"2014-11-01",15846,{"$f":"SUM(T8:T19)","v":5990},162,5990,71,650,null,"2014-11-01",1518,535,31,680,11,83,4192.8449389999996]
[null,null,null,null,null,null,null,null,"2020-10-01",45389,2132,188,1299,3335,52343,null,null,"2014-12-01",1303,559,34,705,10,74,4345.0778369999998,null,"2014-12-01",16425,{"$f":"SUM(T9:T20)","v":6203},194,6517,81,721,null,"2014-12-01",1309,559,34,705,10,74,4345.0778369999998]
[null,null,null,null,null,null,null,null,"2020-11-01",41998,1747,153,1138,3106,48142,null,null,"2015-01-01",1799,583,31,698,12,64,4383.7940619999999,null,"2015-01-01",17153,{"$f":"SUM(T10:T21)","v":6279},224,6947,93,780,null,"2015-01-01",1811,583,31,698,12,64,4383.7940619999999]
[null,{"$f":"SUBTOTAL(9,B24:B33)","v":34296},null,null,"CNF Sent Monthly Volumes",null,null,null,"2020-12-01",35772,1463,139,858,2306,40538,null,null,"2015-02-01",2335,426,28,769,5,70,4623.1801420000002,null,"2015-02-01",18490,{"$f":"SUM(T11:T22)","v":6328},249,7504,98,829,null,"2015-02-01",2361,426,28,769,5,70,4623.1801420000002]
["Exit Process Reason","Total",null,null,null,null,null,null,"2021-01-01",37685,1075,245,1379,2805,43189,null,null,"2015-03-01",2629,841,21,1143,5,86,4959.1549999999997,null,"2015-03-01",19870,{"$f":"SUM(T12:T23)","v":6691},267,8273,100,881,null,"2015-03-01",2647,841,21,1143,5,86,4959.1549999999997]
["Claim requires further investigation",14777,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2021-02-01",33533,1671,161,1502,1894,38761,null,null,"2015-04-01",2243,860,28,1182,7,74,4358.1350000000002,null,"2015-04-01",20726,{"$f":"SUM(T13:T24)","v":7105},290,9048,105,923,null,"2015-04-01",2254,860,28,1182,7,74,4358.1350000000002]
["Other",9867,null,null,"2019-12-01","RTA",39231,null,"Grand Total",445306,21349,2192,14860,31522,515229,null,null,"2015-05-01",1840,781,20,988,5,86,3996.8166270000002,null,"2015-05-01",21210,{"$f":"SUM(T14:T25)","v":7341},306,9489,106,967,null,"2015-05-01",1849,781,20,988,5,86,3996.8166270000002]
["Incomplete information provided on CNF",5486,null,null,"2020-01-01","RTA",60003,null,null,null,null,null,null,null,null,null,null,"2015-06-01",1962,999,24,998,4,78,4745.8085890000002,null,"2015-06-01",21821,{"$f":"SUM(T15:T26)","v":7750},316,9898,102,971,null,"2015-06-01",1972,999,24,998,4,78,4745.8085890000002]
["Duplicated claim",2721,null,null,"2020-02-01","RTA",55459,null,null,null,null,null,null,null,null,null,null,"2015-07-01",1772,877,31,879,10,92,4072.2803260000001,null,"2015-07-01",21867,{"$f":"SUM(T16:T27)","v":8084},328,10126,109,977,null,"2015-07-01",1779,877,31,879,10,92,4072.2803260000001]
["Withdrawal of claim",1022,null,null,"2020-03-01","RTA",49232,null,null,null,null,null,null,null,null,null,null,"2015-08-01",1619,655,26,649,3,74,3784.8224319999999,null,"2015-08-01",22184,{"$f":"SUM(T17:T28)","v":8227},342,10121,102,993,null,"2015-08-01",1629,655,26,649,3,74,3784.8224319999999]
["Claim is too complex for process",166,null,null,"2020-04-01","RTA",24499,null,null,null,null,null,null,null,null,null,null,"2015-09-01",1850,705,17,750,7,89,3917.2635949999999,null,"2015-09-01",22430,{"$f":"SUM(T18:T29)","v":8373},325,10168,99,976,null,"2015-09-01",1863,705,17,750,7,89,3917.2635949999999]
["Value of claim exceeds the upper limit",115,null,null,"2020-05-01","RTA",22866,null,null,null,null,null,null,null,null,null,null,"2015-10-01",1882,716,22,824,8,96,4040.4050000000002,null,"2015-10-01",22737,{"$f":"SUM(T19:T30)","v":8537},313,10265,87,966,null,"2015-10-01",1893,716,22,824,8,96,4040.4050000000002]
["Withdrawal of offer",101,null,null,"2020-06-01","RTA",32354,null,null,null,null,null,null,null,null,null,null,"2015-11-01",1613,710,22,864,6,119,3995.553613,null,"2015-11-01",22847,{"$f":"SUM(T20:T31)","v":8712},304,10449,82,1002,null,"2015-11-01",1623,710,22,864,6,119,3995.553613]
["Value of claim below ú1,000",29,null,null,"2020-07-01","RTA",39916,null,null,null,null,null,null,null,null,null,null,"2015-12-01",1385,655,24,668,4,99,3986.5814140000002,null,"2015-12-01",22929,{"$f":"SUM(T21:T32)","v":8808},294,10412,76,1027,null,"2015-12-01",1395,655,24,668,4,99,3986.5814140000002]
["Interim payment for child claimant",12,null,null,"2020-08-01","RTA",37522,null,null,null,null,null,null,null,null,null,null,"2016-01-01",1362,607,15,657,7,78,3651.2676919999999,null,"2016-01-01",22492,{"$f":"SUM(T22:T33)","v":8832},278,10371,71,1041,null,"2016-01-01",1369,607,15,657,7,78,3651.2676919999999]
[null,null,null,null,"2020-09-01","RTA",44540,null,null,null,null,null,null,null,null,null,null,"2016-02-01",1215,500,18,563,2,103,3741.542524,null,"2016-02-01",21372,{"$f":"SUM(T23:T34)","v":8906},268,10165,68,1074,null,"2016-02-01",1220,500,18,563,2,103,3741.542524]
[null,null,null,null,"2020-10-01","RTA",45389,null,null,null,null,null,null,null,null,null,null,"2016-03-01",1090,599,19,570,4,89,4073.5834829999999,null,"2016-03-01",19833,{"$f":"SUM(T24:T35)","v":8664},266,9592,67,1077,null,"2016-03-01",1095,599,19,570,4,89,4073.5834829999999]
[null,null,null,null,"2020-11-01","RTA",41998,null,null,null,null,null,null,null,null,null,null,"2016-04-01",967,458,23,463,3,89,3934.2673030000001,null,"2016-04-01",18557,{"$f":"SUM(T25:T36)","v":8262},261,8873,63,1092,null,"2016-04-01",975,458,23,463,3,89,3934.2673030000001]
[null,null,null,null,"2020-12-01","RTA",35772,null,null,null,null,null,null,null,null,null,null,"2016-05-01",850,447,18,358,3,59,3943.3115250000001,null,"2016-05-01",17567,{"$f":"SUM(T26:T37)","v":7928},259,8243,61,1065,null,"2016-05-01",859,447,18,358,3,59,3943.3115250000001]
[null,null,null,null,"2021-01-01","RTA",37685,null,null,null,null,null,null,null,null,null,null,"2016-06-01",741,382,23,417,6,80,3885.6522500000001,null,"2016-06-01",16346,{"$f":"SUM(T27:T38)","v":7311},258,7662,63,1067,null,"2016-06-01",751,382,23,417,6,80,3885.6522500000001]
[null,null,null,null,"2021-02-01","RTA",33533,null,null,null,null,null,null,null,null,null,null,"2016-07-01",683,324,8,300,3,67,3694.5628350000002,null,"2016-07-01",15257,{"$f":"SUM(T28:T39)","v":6758},235,7083,56,1042,null,"2016-07-01",691,324,8,300,3,67,3694.5628350000002]
[null,null,null,null,"2019-12-01","",1975,null,null,null,null,null,null,null,null,null,null,"2016-08-01",844,267,13,245,2,47,3745.8587229999998,null,"2016-08-01",14482,{"$f":"SUM(T29:T40)","v":6370},222,6679,55,1015,null,"2016-08-01",850,267,13,245,2,47,3745.8587229999998]
[null,null,null,null,"2020-01-01","",3643,null,null,null,null,null,null,null,null,null,null,"2016-09-01",834,370,12,372,3,77,3320.1161029999998,null,"2016-09-01",13466,{"$f":"SUM(T30:T41)","v":6035},217,6301,51,1003,null,"2016-09-01",847,370,12,372,3,77,3320.1161029999998]
[null,null,null,null,"2020-02-01","",3690,null,null,null,null,null,null,null,null,null,null,"2016-10-01",800,359,17,319,2,50,3599.0362,null,"2016-10-01",12384,{"$f":"SUM(T31:T42)","v":5678},212,5796,45,957,null,"2016-10-01",815,359,17,319,2,51,3626.5060779999999]
[null,null,null,null,"2020-03-01","",3460,null,null,null,null,null,null,null,null,null,null,"2016-11-01",812,366,24,332,5,63,3561.5420629999999,null,"2016-11-01",11583,{"$f":"SUM(T32:T43)","v":5334},214,5264,44,901,null,"2016-11-01",853,366,24,332,5,64,3529.3304680000001]
[null,null,null,null,"2020-04-01","",2241,null,null,null,null,null,null,null,null,null,null,"2016-12-01",594,310,13,312,2,59,3692.4923720000002,null,"2016-12-01",10792,{"$f":"SUM(T33:T44)","v":4989},203,4908,42,861,null,"2016-12-01",614,310,13,312,2,59,3692.4923720000002]
[null,null,null,null,"2020-05-01","",1818,null,null,null,null,null,null,null,null,null,null,"2017-01-01",813,328,12,326,1,60,3953.8204999999998,null,"2017-01-01",10243,{"$f":"SUM(T34:T45)","v":4710},200,4577,36,843,null,"2017-01-01",843,328,12,326,1,63,3946.4957140000001]
[null,null,null,null,"2020-06-01","",2235,null,null,null,null,null,null,null,null,null,null,"2017-02-01",822,227,18,298,3,58,3840.1215510000002,null,"2017-02-01",9850,{"$f":"SUM(T35:T46)","v":4437},200,4312,37,798,null,"2017-02-01",855,227,18,298,3,60,3846.2841659999999]
[null,null,null,null,"2020-07-01","",2679,null,null,null,null,null,null,null,null,null,null,"2017-03-01",904,429,12,477,3,65,3545.99,null,"2017-03-01",{"$f":"SUM(S36:S47)","v":9664},{"$f":"SUM(T36:T47)","v":4267},193,4219,36,774,null,"2017-03-01",942,429,12,477,3,68,3503.5198519999999]
[null,null,null,null,"2020-08-01","",2425,null,null,null,null,null,null,null,null,null,null,"2017-04-01",684,271,5,325,0,40,3351.4450000000002,null,"2017-04-01",9381,{"$f":"SUM(T37:T48)","v":4080},175,4081,33,725,null,"2017-04-01",700,271,5,325,0,41,3306.2878040000001]
[null,null,null,null,"2020-09-01","",3218,null,null,null,null,null,null,null,null,null,null,"2017-05-01",760,382,11,371,3,42,3137.2033329999999,null,"2017-05-01",9291,{"$f":"SUM(T38:T49)","v":4015},168,4094,33,708,null,"2017-05-01",800,382,11,371,3,44,3207.6713629999999]
[null,null,null,null,"2020-10-01","",3335,null,null,null,null,null,null,null,null,null,null,"2017-06-01",872,348,17,367,1,43,3514.5051159999998,null,"2017-06-01",9422,{"$f":"SUM(T39:T50)","v":3981},162,4044,28,671,null,"2017-06-01",901,348,17,367,1,44,3518.7209090000001]
[null,null,null,null,"2020-11-01","",3106,null,null,null,null,null,null,null,null,null,null,"2017-07-01",688,348,7,348,1,38,4191.3718419999996,null,"2017-07-01",9427,{"$f":"SUM(T40:T51)","v":4005},161,4092,26,642,null,"2017-07-01",718,348,7,348,1,38,4191.3718419999996]
[null,null,null,null,"2020-12-01","",2306,null,null,null,null,null,null,null,null,null,null,"2017-08-01",721,367,5,306,3,44,3521.9175,null,"2017-08-01",9304,{"$f":"SUM(T41:T52)","v":4105},153,4153,27,639,null,"2017-08-01",750,367,5,306,3,45,3454.7637770000001]
[null,null,null,null,"2021-01-01","",2805,null,null,null,null,null,null,null,null,null,null,"2017-09-01",675,322,15,294,2,40,4071.3634999999999,null,"2017-09-01",9145,{"$f":"SUM(T42:T53)","v":4057},156,4075,26,602,null,"2017-09-01",708,322,15,294,2,40,4071.3634999999999]
[null,null,null,null,"2021-02-01","",1894,null,null,null,null,null,null,null,null,null,null,"2017-10-01",729,334,5,304,0,33,3973.5681810000001,null,"2017-10-01",9074,{"$f":"SUM(T43:T54)","v":4032},144,4060,24,585,null,"2017-10-01",756,334,5,304,0,34,3959.639705]
[null,null,null,null,"2019-12-01","EL",1173,null,null,null,null,null,null,null,null,null,null,"2017-11-01",644,341,16,314,3,51,3931.9509800000001,null,"2017-11-01",8906,{"$f":"SUM(T44:T55)","v":4007},136,4042,22,573,null,"2017-11-01",690,341,16,314,3,55,3900]
[null,null,null,null,"2020-01-01","EL",2035,null,null,null,null,null,null,null,null,null,null,"2017-12-01",445,276,8,250,4,31,3882.0596770000002,null,"2017-12-01",8757,{"$f":"SUM(T45:T56)","v":3973},131,3980,24,545,null,"2017-12-01",477,276,8,250,4,35,3988.3957140000002]
[null,null,null,null,"2020-02-01","EL",1973,null,null,null,null,null,null,null,null,null,null,"2018-01-01",673,313,7,254,5,45,4318.0531110000002,null,"2018-01-01",8617,{"$f":"SUM(T46:T57)","v":3958},126,3908,28,530,null,"2018-01-01",716,313,7,254,5,49,4233.6161220000004]
[null,null,null,null,"2020-03-01","EL",1798,null,null,null,null,null,null,null,null,null,null,"2018-02-01",640,231,5,231,5,39,4043.7146149999999,null,"2018-02-01",8435,{"$f":"SUM(T47:T58)","v":3962},113,3841,30,511,null,"2018-02-01",675,231,5,231,5,40,4047.6217499999998]
[null,null,null,null,"2020-04-01","EL",1215,null,null,null,null,null,null,null,null,null,null,"2018-03-01",647,325,3,316,4,41,4137.4580480000004,null,"2018-03-01",8178,{"$f":"SUM(T48:T59)","v":3858},104,3680,31,487,null,"2018-03-01",686,325,3,316,4,44,4166.722272]
[null,null,null,null,"2020-05-01","EL",902,null,null,null,null,null,null,null,null,null,null,"2018-04-01",501,313,3,252,0,29,3670.6262059999999,null,"2018-04-01",7995,{"$f":"SUM(T49:T60)","v":3900},102,3607,31,476,null,"2018-04-01",527,313,3,252,0,31,3611.230967]
[null,null,null,null,"2020-06-01","EL",1064,null,null,null,null,null,null,null,null,null,null,"2018-05-01",467,266,6,223,1,26,3641.29423,null,"2018-05-01",7702,{"$f":"SUM(T50:T61)","v":3784},97,3459,29,460,null,"2018-05-01",491,266,6,223,1,28,3818.7017850000002]
[null,null,null,null,"2020-07-01","EL",1188,null,null,null,null,null,null,null,null,null,null,"2018-06-01",496,257,8,186,3,43,3560.903953,null,"2018-06-01",7326,{"$f":"SUM(T51:T62)","v":3693},88,3278,31,460,null,"2018-06-01",518,257,8,186,3,43,3560.903953]
[null,null,null,null,"2020-08-01","EL",1094,null,null,null,null,null,null,null,null,null,null,"2018-07-01",457,264,10,199,0,41,3875.2941460000002,null,"2018-07-01",7095,{"$f":"SUM(T52:T63)","v":3609},91,3129,30,463,null,"2018-07-01",478,264,10,199,0,41,3875.2941460000002]
[null,null,null,null,"2020-09-01","EL",1423,null,null,null,null,null,null,null,null,null,null,"2018-08-01",390,242,11,172,1,33,4000.5803030000002,null,"2018-08-01",6764,{"$f":"SUM(T53:T64)","v":3484},97,2995,28,452,null,"2018-08-01",416,242,11,172,1,33,4000.5803030000002]
[null,null,null,null,"2020-10-01","EL",1299,null,null,null,null,null,null,null,null,null,null,"2018-09-01",415,192,1,150,0,29,4220.1503439999997,null,"2018-09-01",6504,{"$f":"SUM(T54:T65)","v":3354},83,2851,26,441,null,"2018-09-01",429,192,1,150,0,30,4121.1453330000004]
[null,null,null,null,"2020-11-01","EL",1138,null,null,null,null,null,null,null,null,null,null,"2018-10-01",494,224,7,196,0,29,4412.0096549999998,null,"2018-10-01",6269,{"$f":"SUM(T55:T66)","v":3244},85,2743,26,437,null,"2018-10-01",514,224,7,196,0,30,4481.6093330000003]
[null,null,null,null,"2020-12-01","EL",858,null,null,null,null,null,null,null,null,null,null,"2018-11-01",415,249,6,143,1,24,4158.0541659999999,null,"2018-11-01",6040,{"$f":"SUM(T56:T67)","v":3152},75,2572,24,410,null,"2018-11-01",435,249,6,143,1,24,4158.0541659999999]
[null,null,null,null,"2021-01-01","EL",1379,null,null,null,null,null,null,null,null,null,null,"2018-12-01",283,177,2,135,2,26,3621.280769,null,"2018-12-01",5878,{"$f":"SUM(T57:T68)","v":3053},69,2457,22,405,null,"2018-12-01",299,177,2,135,2,27,3616.788888]
[null,null,null,null,"2021-02-01","EL",1502,null,null,null,null,null,null,null,null,null,null,"2019-01-01",425,207,1,162,1,24,3734.3850000000002,null,"2019-01-01",5630,{"$f":"SUM(T58:T69)","v":2947},63,2365,18,384,null,"2019-01-01",439,207,1,162,1,24,3734.3850000000002]
[null,null,null,null,"2019-12-01","ELD",127,null,null,null,null,null,null,null,null,null,null,"2019-02-01",448,150,4,131,0,29,4074.730689,null,"2019-02-01",5438,{"$f":"SUM(T59:T70)","v":2866},62,2265,13,374,null,"2019-02-01",469,150,4,131,0,29,4074.730689]
[null,null,null,null,"2020-01-01","ELD",218,null,null,null,null,null,null,null,null,null,null,"2019-03-01",421,247,4,154,1,27,3960.0888880000002,null,"2019-03-01",5212,{"$f":"SUM(T60:T71)","v":2788},63,2103,10,360,null,"2019-03-01",444,247,4,154,1,29,3890.4275859999998]
[null,null,null,null,"2020-02-01","ELD",228,null,null,null,null,null,null,null,null,null,null,"2019-04-01",384,225,3,153,3,35,4232.7219999999998,null,"2019-04-01",5095,{"$f":"SUM(T61:T72)","v":2700},63,2004,13,366,null,"2019-04-01",405,225,3,153,3,36,4254.035277]
[null,null,null,null,"2020-03-01","ELD",192,null,null,null,null,null,null,null,null,null,null,"2019-05-01",398,218,5,144,0,29,3990.293103,null,"2019-05-01",5026,{"$f":"SUM(T62:T73)","v":2652},62,1925,12,369,null,"2019-05-01",418,218,5,144,0,30,3973.95]
[null,null,null,null,"2020-04-01","ELD",262,null,null,null,null,null,null,null,null,null,null,"2019-06-01",362,214,6,135,2,20,4906.8230000000003,null,"2019-06-01",4892,{"$f":"SUM(T63:T74)","v":2609},60,1874,11,346,null,"2019-06-01",373,214,6,135,2,22,4900.1118180000003]
[null,null,null,null,"2020-05-01","ELD",164,null,null,null,null,null,null,null,null,null,null,"2019-07-01",401,222,3,130,3,26,4101.0515379999997,null,"2019-07-01",4836,{"$f":"SUM(T64:T75)","v":2567},53,1805,14,331,null,"2019-07-01",431,222,3,130,3,27,4078.7903700000002]
[null,null,null,null,"2020-06-01","ELD",162,null,null,null,null,null,null,null,null,null,null,"2019-08-01",288,206,2,117,0,23,4346.6008689999999,null,"2019-08-01",4734,{"$f":"SUM(T65:T76)","v":2531},44,1750,13,321,null,"2019-08-01",367,206,2,117,0,24,4280.0758329999999]
[null,null,null,null,"2020-07-01","ELD",199,null,null,null,null,null,null,null,null,null,null,"2019-09-01",258,190,5,131,0,26,3973.5038460000001,null,"2019-09-01",4577,{"$f":"SUM(T66:T77)","v":2529},48,1731,13,318,null,"2019-09-01",385,190,5,134,0,28,4135.5749999999998]
[null,null,null,null,"2020-08-01","ELD",119,null,null,null,null,null,null,null,null,null,null,"2019-10-01",274,110,5,115,1,32,4597.5362500000001,null,"2019-10-01",4357,{"$f":"SUM(T67:T78)","v":2415},46,1650,14,321,null,"2019-10-01",432,174,5,152,1,37,4641.1124319999999]
[null,null,null,null,"2020-09-01","ELD",208,null,null,null,null,null,null,null,null,null,null,"2019-11-01",193,110,2,83,1,27,4348.0707400000001,null,"2019-11-01",{"$f":"SUM(S68:S79)","v":4135},{"$f":"SUM(T68:T79)","v":2276},42,1590,14,324,null,"2019-11-01",327,171,6,114,1,30,4546.5969999999998]
[null,null,null,null,"2020-10-01","ELD",188,null,null,null,null,null,null,null,null,null,null,"2019-12-01",163,83,2,63,3,15,3946.0520000000001,null,"2019-12-01",4015,{"$f":"SUM(T69:T80)","v":2182},42,1518,15,313,null,"2019-12-01",254,144,5,95,4,15,3946.0520000000001]
[null,null,null,null,"2020-11-01","ELD",153,null,null,null,null,null,null,null,null,null,null,"2020-01-01",218,79,4,85,2,25,3695.8159999999998,null,"2020-01-01",3808,{"$f":"SUM(T70:T81)","v":2054},45,1441,16,314,null,"2020-01-01",325,132,6,111,2,27,3777.607407]
[null,null,null,null,"2020-12-01","ELD",139,null,null,null,null,null,null,null,null,null,null,"2020-02-01",228,74,1,77,0,27,5273.8011109999998,null,"2020-02-01",3588,{"$f":"SUM(T71:T82)","v":1978},42,1387,16,312,null,"2020-02-01",364,114,1,97,0,29,5334.2286199999999]
[null,null,null,null,"2021-01-01","ELD",245,null,null,null,null,null,null,null,null,null,null,"2020-03-01",192,107,1,77,0,46,4002.032608,null,"2020-03-01",3359,{"$f":"SUM(T72:T83)","v":1838},39,1310,15,331,null,"2020-03-01",335,173,4,104,0,48,4100.90625]
[null,null,null,null,"2021-02-01","ELD",161,null,null,null,null,null,null,null,null,null,null,"2020-04-01",262,85,1,84,1,46,3777.0928260000001,null,"2020-04-01",3237,{"$f":"SUM(T73:T84)","v":1698},37,1241,13,342,null,"2020-04-01",380,141,1,113,2,50,4034.8254000000002]
[null,null,null,null,"2019-12-01","PL",1578,null,null,null,null,null,null,null,null,null,null,"2020-05-01",164,64,3,65,0,35,4429.0571419999997,null,"2020-05-01",3003,{"$f":"SUM(T74:T85)","v":1544},35,1162,13,348,null,"2020-05-01",230,122,7,92,0,38,4309.4368420000001]
[null,null,null,null,"2020-01-01","PL",2754,null,null,null,null,null,null,null,null,null,null,"2020-06-01",162,120,5,77,0,49,4034.436326,null,"2020-06-01",{"$f":"SUM(S75:S86)","v":2803},1450,34,1104,11,377,null,"2020-06-01",265,171,5,102,0,51,4113.3231370000003]
[null,null,null,null,"2020-02-01","PL",2645,null,null,null,null,null,null,null,null,null,null,"2020-07-01",199,69,2,63,1,32,3732.35,null,"2020-07-01",2601,1297,33,1037,9,383,null,"2020-07-01",274,123,2,86,1,33,3784.4]
[null,null,null,null,"2020-03-01","PL",2586,null,null,null,null,null,null,null,null,null,null,"2020-08-01",119,82,1,60,0,22,3850.1522719999998,null,"2020-08-01",{"$f":"SUM(S77:S88)","v":2432},1173,32,980,9,382,null,"2020-08-01",160,104,1,69,0,20,4155.1270000000004]
[null,null,null,null,"2020-04-01","PL",1703,null,null,null,null,null,null,null,null,null,null,"2020-09-01",208,70,2,62,0,19,4315.7894729999998,null,"2020-09-01",{"$f":"SUM(S78:S89)","v":2382},1053,29,911,9,375,null,"2020-09-01",297,113,2,66,0,21,4429.1238089999997]
[null,null,null,null,"2020-05-01","PL",1378,null,null,null,null,null,null,null,null,null,null,"2020-10-01",188,68,2,81,0,33,3781.241818,null,"2020-10-01",{"$f":"SUM(S79:S90)","v":2296},1011,26,877,8,376,null,"2020-10-01",309,100,2,104,0,35,4108.0280000000002]
[null,null,null,null,"2020-06-01","PL",1658,null,null,null,null,null,null,null,null,null,null,"2020-11-01",153,79,1,52,0,37,3507.036486,null,"2020-11-01",{"$f":"SUM(S80:S91)","v":2256},980,25,846,7,386,null,"2020-11-01",286,127,1,66,0,32,3741.734375]
[null,null,null,null,"2020-07-01","PL",1930,null,null,null,null,null,null,null,null,null,null,"2020-12-01",139,64,1,66,0,36,3554.7975000000001,null,"2020-12-01",{"$f":"SUM(S81:S92)","v":2232},961,24,849,4,407,null,"2020-12-01",249,118,3,91,1,38,3454.5450000000001]
[null,null,null,null,"2020-08-01","PL",1781,null,null,null,null,null,null,null,null,null,null,"2021-01-01",245,61,1,71,0,40,3431.6757499999999,null,"2021-01-01",{"$f":"SUM(S82:S93)","v":2259},943,21,835,2,422,null,"2021-01-01",310,135,2,96,0,44,3490.159772]
[null,null,null,null,"2020-09-01","PL",2225,null,null,null,null,null,null,null,null,null,null,"2021-02-01",161,81,1,53,0,45,3844.6666660000001,null,"2021-02-01",{"$f":"SUM(S83:S94)","v":2192},{"$f":"SUM(T83:T94)","v":950},{"$f":"SUM(U83:U94)","v":21},{"$f":"SUM(V83:V94)","v":811},{"$f":"SUM(W83:W94)","v":2},{"$f":"SUM(X83:X94)","v":440}]
[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":11797},{"$f":"SUM('Backing Sheet Data'!T4:T15)","v":4361},{"$f":"SUM('Backing Sheet Data'!U4:U15)","v":51},{"$f":"SUM('Backing Sheet Data'!V4:V15)","v":3495},{"$f":"SUM('Backing Sheet Data'!W4:W15)","v":20},{"$f":"SUM('Backing Sheet Data'!X4:X15)","v":297}]
["2014-15",{"$f":"SUM('Backing Sheet Data'!S16:S27)","v":21867},{"$f":"SUM('Backing Sheet Data'!T16:T27)","v":8084},{"$f":"SUM('Backing Sheet Data'!U16:U27)","v":328},{"$f":"SUM('Backing Sheet Data'!V16:V27)","v":10126},{"$f":"SUM('Backing Sheet Data'!W16:W27)","v":109},{"$f":"SUM('Backing Sheet Data'!X16:X27)","v":977}]
["2015-16",{"$f":"SUM('Backing Sheet Data'!S28:S39)","v":15257},{"$f":"SUM('Backing Sheet Data'!T28:T39)","v":6758},{"$f":"SUM('Backing Sheet Data'!U28:U39)","v":235},{"$f":"SUM('Backing Sheet Data'!V28:V39)","v":7083},{"$f":"SUM('Backing Sheet Data'!W28:W39)","v":56},{"$f":"SUM('Backing Sheet Data'!X28:X39)","v":1042}]
["2016-17",{"$f":"SUM('Backing Sheet Data'!S40:S51)","v":9427},{"$f":"SUM('Backing Sheet Data'!T40:T51)","v":4005},{"$f":"SUM('Backing Sheet Data'!U40:U51)","v":161},{"$f":"SUM('Backing Sheet Data'!V40:V51)","v":4092},{"$f":"SUM('Backing Sheet Data'!W40:W51)","v":26},{"$f":"SUM('Backing Sheet Data'!X40:X51)","v":642}]
["2017-18",{"$f":"SUM('Backing Sheet Data'!S52:S63)","v":7095},{"$f":"SUM('Backing Sheet Data'!T52:T63)","v":3609},{"$f":"SUM('Backing Sheet Data'!U52:U63)","v":91},{"$f":"SUM('Backing Sheet Data'!V52:V63)","v":3129},{"$f":"SUM('Backing Sheet Data'!W52:W63)","v":30},{"$f":"SUM('Backing Sheet Data'!X52:X63)","v":463}]
["2018-19",{"$f":"SUM('Backing Sheet Data'!S64:S75)","v":4836},{"$f":"SUM('Backing Sheet Data'!T64:T75)","v":2567},{"$f":"SUM('Backing Sheet Data'!U64:U75)","v":53},{"$f":"SUM('Backing Sheet Data'!V64:V75)","v":1805},{"$f":"SUM('Backing Sheet Data'!W64:W75)","v":14},{"$f":"SUM('Backing Sheet Data'!X64:X75)","v":331}]
["2019-20",{"$f":"SUM('Backing Sheet Data'!S76:S87)","v":2601},{"$f":"SUM('Backing Sheet Data'!T76:T87)","v":1297},{"$f":"SUM('Backing Sheet Data'!U76:U87)","v":33},{"$f":"SUM('Backing Sheet Data'!V76:V87)","v":1037},{"$f":"SUM('Backing Sheet Data'!W76:W87)","v":9},{"$f":"SUM('Backing Sheet Data'!X76:X87)","v":383}]
["2020-21",{"$f":"SUM('Backing Sheet Data'!S88:S99)","v":1213},{"$f":"SUM('Backing Sheet Data'!T88:T99)","v":505},{"$f":"SUM('Backing Sheet Data'!U88:U99)","v":9},{"$f":"SUM('Backing Sheet Data'!V88:V99)","v":445},{"$f":"SUM('Backing Sheet Data'!W88:W99)","v":0},{"$f":"SUM('Backing Sheet Data'!X88:X99)","v":232}]