{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dashboard","Backing Sheet Data","vRTADashboard","RTA vExitReasonCounts","Year Calculations"],"not_rendered":{"charts":4,"images":1,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":3},"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":[[10,0,10,6],[4,3,5,4],[8,11,8,12],[8,9,8,10],[2,21,3,22],[2,11,3,14],[4,11,5,14],[2,9,3,10],[4,9,5,10],[0,0,1,2],[8,7,8,8],[6,0,7,12],[8,0,8,6],[4,21,5,22],[0,21,1,22],[0,17,1,20],[2,17,3,20],[4,17,5,20],[2,0,3,2],[4,0,5,2],[0,15,1,16],[2,15,3,16],[4,15,5,16],[0,9,1,10],[0,11,1,14],[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],[14,7,14,8],[14,9,14,10],[11,0,11,6],[9,0,9,6],[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],[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],[0,26,1,27],[2,26,3,27],[4,26,5,27],[0,23,1,25],[2,23,3,25],[4,23,5,25],[0,5,1,8],[2,5,3,8],[4,5,5,8],[0,3,1,4],[2,3,3,4]]}
["Sent this month",null,null,6897,null,"Left process at stage 1:",null,null,null,1865,null,"Left process at stage 2:",null,null,null,1176,null,"Exited process:",null,null,null,2055,null,"Settled:",null,null,963]
[]
["Δ from last month:",null,null,1015,null,"Δ from last month:",null,null,null,162,null,"Δ from last month:",null,null,null,210,null,"Δ from last month:",null,null,null,412,null,"Δ from last month:",null,null,215]
[]
["Rolling 12 months:",null,null,85887,null,"Rolling 12 months:",null,null,null,20373,null,"Rolling 12 months:",null,null,null,14798,null,"Rolling 12 months:",null,null,null,23918,null,"Rolling 12 months:",null,null,12392]
[]
["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,1501,null,1328,null,173]
["Other",null,null,null,null,null,null,364,null,376,null,-12]
["Total",null,null,null,null,null,null,1865,null,1704,null,161]
["Left Process Breakdowns - Stage 2:"]
[]
["Reason",null,null,null,null,null,null,"This Month",null,"Last Month",null,"Δ"]
["Interim payment more than £1,000 not agreed:",null,null,null,null,null,null,1,null,4,null,-3]
["Settlement pack repudiated:",null,null,null,null,null,null,3,null,2,null,1]
["Settlement pack timeout:",null,null,null,null,null,null,342,null,338,null,4]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,830,null,795,null,35]
["Total",null,null,null,null,null,null,1176,null,1139,null,37]

{"sheet":"Backing Sheet Data","index":1,"n_rows":165,"n_cols":25,"rows_kept":165,"cut":false,"hidden":false,"merged":[[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2023-10-01"]
["Previous month",{"$f":"EDATE(B1,-1)","v":"2023-09-01"}]
[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"]
["Rolling 12 CNFs sent",null,null,null,"Average General Damages chart data",null,null,null,null,null,null,null,null,null,null,null,null,"2010-05-01",10467,494,0,0,0,3,1216.6666660000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-06-01",38405,8565,10,0,0,325,1029.243076]
["Period","Rolling 12 Sent",null,null,"Row Labels","Ave General Damages",null,null,null,null,null,null,null,null,null,null,null,"2010-07-01",47904,17692,147,0,0,1156,1266.971444]
["2022-11-01",93791,null,null,"2022-11-01",5397.441887,null,null,null,null,null,null,null,null,null,null,null,"2010-08-01",49580,20078,637,0,9,3109,1488.6101510000001]
["2022-12-01",92173,null,null,"2022-12-01",5001.3427229999998,null,null,null,null,null,null,null,null,null,null,null,"2010-09-01",56926,23485,1249,0,335,5579,1598.7942049999999]
["2023-01-01",90793,null,null,"2023-01-01",5476.3537889999998,null,null,"CNF Sent Monthly Volumes Chart Data",null,null,null,null,null,null,null,null,"2010-10-01",57967,25210,1628,0,1708,7175,1734.3691940000001]
["2023-02-01",90346,null,null,"2023-02-01",5327.1697329999997,null,null,null,null,null,null,null,null,null,null,null,"2010-11-01",65286,28094,2227,0,2083,10021,1748.9229720000001]
["2023-03-01",89721,null,null,"2023-03-01",5411.1850039999999,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2010-12-01",51771,27567,2539,0,268,10687,1730.4392130000001]
["2023-04-01",88550,null,null,"2023-04-01",5525.8001999999997,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total",null,null,null,"2011-01-01",66395,23279,2020,0,448,13583,1747.046681]
["2023-05-01",87498,null,null,"2023-05-01",5472.9942810000002,null,null,"2022-11-01",8303,3319,495,2619,14736,null,null,null,"2011-02-01",63216,29094,2043,0,450,15646,1785.8937020000001]
["2023-06-01",87886,null,null,"2023-06-01",5444.3361100000002,null,null,"2022-12-01",6118,2292,350,1664,10424,null,null,null,"2011-03-01",67667,31396,2433,26,750,20140,1801.133454]
["2023-07-01",87649,null,null,"2023-07-01",5721.9985550000001,null,null,"2023-01-01",7394,3368,500,2536,13798,null,null,null,"2011-04-01",54185,22478,1885,2206,594,16306,1839.733078]
["2023-08-01",{"$f":"VLOOKUP(Table7[[#This Row],[Period]],tblPrevious12v2[],2,FALSE)","v":87133},null,null,"2023-08-01",5623.5326290000003,null,null,"2023-02-01",7454,3288,520,2347,13609,null,null,null,"2011-05-01",64722,23751,2030,4614,710,18560,1871.7378880000001]
["2023-09-01",{"$f":"VLOOKUP(Table7[[#This Row],[Period]],tblPrevious12v2[],2,FALSE)","v":86591},null,null,"2023-09-01",5234.6036059999997,null,null,"2023-03-01",7434,3557,527,2651,14169,null,null,null,"2011-06-01",66783,26464,2250,5641,801,20923,1867.249937]
["2023-10-01",{"$f":"VLOOKUP(Table7[[#This Row],[Period]],tblPrevious12v2[],2,FALSE)","v":85887},null,null,"2023-10-01",5291.2558349999999,null,null,"2023-04-01",6103,2726,541,2146,11516,null,null,null,"2011-07-01",64567,24356,2052,5406,934,20450,1896.707958]
[null,null,null,null,"Grand Total",64928.014351999998,null,null,"2023-05-01",6839,3167,612,2207,12825,null,null,null,"2011-08-01",64326,25819,1902,6289,873,20891,1909.3571890000001]
[null,null,null,null,null,null,null,null,"2023-06-01",7658,3445,638,2554,14295,null,null,null,"2011-09-01",65785,24177,1658,5963,867,21695,1928.945236]
[null,null,null,null,null,null,null,null,"2023-07-01",7267,3347,694,2469,13777,null,null,null,"2011-10-01",68190,24463,1471,6639,842,21088,1953.4418820000001]
[null,{"$f":"SUBTOTAL(9,B24:B37)","v":40599},null,null,"CNF Sent Monthly Volumes",null,null,null,"2023-08-01",7440,3391,1000,2446,14277,null,null,null,"2011-11-01",71093,26428,1536,7470,845,23022,1950.8189339999999]
["Exit Process Reason","Total",null,null,null,null,null,null,"2023-09-01",6980,2610,2474,1975,14039,null,null,null,"2011-12-01",57326,22991,1630,6373,670,18466,1932.1202639999999]
["Claim requires further investigation",17801,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2023-10-01",6897,3090,414,2367,12768,null,null,null,"2012-01-01",72724,22770,1339,7711,857,22313,1967.239018]
["Other",15024,null,null,"2022-08-01","EL",1546,null,"Grand Total",85887,37600,8765,27981,160233,null,null,null,"2012-02-01",69809,25242,1739,8982,751,23015,1956.7099800000001]
["Wrong Portal",4515,null,null,"2022-09-01","EL",2517,null,null,null,null,null,null,null,null,null,null,"2012-03-01",69037,25697,1779,9379,856,25724,1983.518959]
["Duplicated claim",1376,null,null,"2022-10-01","EL",2502,null,"Left Process Breakdown",null,null,null,null,null,null,null,null,"2012-04-01",62450,21314,1589,8158,763,21884,1988.4946809999999]
["Value of claim exceeds the upper limit",435,null,null,"2022-11-01","EL",2619,null,null,null,null,null,null,null,null,null,null,"2012-05-01",71005,25541,1678,9858,866,25577,1989.0412329999999]
["Incomplete information provided on CNF",373,null,null,"2022-12-01","EL",1664,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,"2012-06-01",62501,22180,1594,8645,746,20352,1982.574425]
["Stage 1 costs not paid on time",355,null,null,"2023-01-01","EL",2536,null,1501,364,1,3,342,830,null,null,null,"2012-07-01",70976,26065,1674,10933,864,23296,2007.2008109999999]
["Claim is too complex for process",232,null,null,"2023-02-01","EL",2347,null,null,null,null,null,null,null,null,null,null,"2012-08-01",67753,25025,1777,10848,867,22097,1992.3525979999999]
["Withdrawal of offer",200,null,null,"2023-03-01","EL",2651,null,null,null,null,null,null,null,null,null,null,"2012-09-01",67342,22271,1666,10583,3482,20228,1992.967576]
["Withdrawl of claim",161,null,null,"2023-04-01","EL",2146,null,null,null,null,null,null,null,null,null,null,"2012-10-01",81060,28025,1967,12507,932,23908,1994.9611689999999]
["Interim Payment request not answered and/or paid on time",90,null,null,"2023-05-01","EL",2207,null,null,null,null,null,null,null,null,null,null,"2012-11-01",77992,26162,1396,12674,903,24170,2016.7092009999999]
["Interim Payment partial offer not accepted",15,null,null,"2023-06-01","EL",2554,null,null,null,null,null,null,null,null,null,null,"2012-12-01",60190,23165,1165,10270,833,17586,2035.591698]
["Value of claim below £1,000",14,null,null,"2023-07-01","EL",2469,null,null,null,null,null,null,null,null,null,null,"2013-01-01",81349,24795,1148,12569,939,23449,2055.160441]
["Interim payment for child claimant",8,null,null,"2023-08-01","EL",2446,null,null,null,null,null,null,null,null,null,null,"2013-02-01",72820,24810,1086,12599,879,21402,2083.04]
[null,null,null,null,"2023-09-01","EL",1975,null,null,null,null,null,null,null,null,null,null,"2013-03-01",90924,23706,1157,13113,985,21950,2100.9677059999999]
[null,null,null,null,"2023-10-01","EL",2367,null,null,null,null,null,null,null,null,null,null,"2013-04-01",78812,29710,1141,15792,1109,22528,2099.223125]
[null,null,null,null,"2023-11-01","EL",486,null,null,null,null,null,null,null,null,null,null,"2013-05-01",54076,22715,1315,12290,1231,22072,2136.0243919999998]
[null,null,null,null,"2022-08-01","ELD",305,null,null,null,null,null,null,null,null,null,null,"2013-06-01",58746,15847,1051,10657,1210,20109,2206.315955]
[null,null,null,null,"2022-09-01","ELD",409,null,null,null,null,null,null,null,null,null,null,"2013-07-01",72312,18884,1178,12827,1493,22263,2234.7432749999998]
[null,null,null,null,"2022-10-01","ELD",447,null,null,null,null,null,null,null,null,null,null,"2013-08-01",57287,18093,881,11755,1651,18989,2293.4750939999999]
[null,null,null,null,"2022-11-01","ELD",495,null,null,null,null,null,null,null,null,null,null,"2013-09-01",62232,16494,958,11238,1530,19131,2309.0266489999999]
[null,null,null,null,"2022-12-01","ELD",350,null,null,null,null,null,null,null,null,null,null,"2013-10-01",68731,18794,1043,12043,1654,21136,2332.5924439999999]
[null,null,null,null,"2023-01-01","ELD",500,null,null,null,null,null,null,null,null,null,null,"2013-11-01",66498,17041,844,11525,1642,20238,2390.605935]
[null,null,null,null,"2023-02-01","ELD",520,null,null,null,null,null,null,null,null,null,null,"2013-12-01",56200,16790,1046,10894,1545,16293,2404.8565629999998]
[null,null,null,null,"2023-03-01","ELD",527,null,null,null,null,null,null,null,null,null,null,"2014-01-01",73685,16582,1001,12441,1865,20266,2423.0495860000001]
[null,null,null,null,"2023-04-01","ELD",541,null,null,null,null,null,null,null,null,null,null,"2014-02-01",66834,17588,1080,12395,1803,18398,2461.4248750000002]
[null,null,null,null,"2023-05-01","ELD",612,null,null,null,null,null,null,null,null,null,null,"2014-03-01",70411,18066,994,16856,2011,19780,2506.5087509999998]
[null,null,null,null,"2023-06-01","ELD",638,null,null,null,null,null,null,null,null,null,null,"2014-04-01",63822,17524,1047,11508,1959,18920,2568.2356159999999]
[null,null,null,null,"2023-07-01","ELD",694,null,null,null,null,null,null,null,null,null,null,"2014-05-01",66045,17512,1065,12127,2290,18710,2566.4736160000002]
[null,null,null,null,"2023-08-01","ELD",1000,null,null,null,null,null,null,null,null,null,null,"2014-06-01",66521,19235,1171,12515,2408,19345,2551.1678940000002]
[null,null,null,null,"2023-09-01","ELD",2474,null,null,null,null,null,null,null,null,null,null,"2014-07-01",73384,19877,1261,13916,3044,21497,2578.1644299999998]
[null,null,null,null,"2023-10-01","ELD",414,null,null,null,null,null,null,null,null,null,null,"2014-08-01",65303,17956,943,11129,2562,17610,2583.0287269999999]
[null,null,null,null,"2023-11-01","ELD",97,null,null,null,null,null,null,null,null,null,null,"2014-09-01",73636,20030,1121,14188,3069,18363,2576.4020230000001]
[null,null,null,null,"2022-08-01","PL",2267,null,null,null,null,null,null,null,null,null,null,"2014-10-01",79518,21428,1207,15580,3289,19161,2589.8617140000001]
[null,null,null,null,"2022-09-01","PL",3364,null,null,null,null,null,null,null,null,null,null,"2014-11-01",70993,19049,1000,13162,3222,17385,2600.9430910000001]
[null,null,null,null,"2022-10-01","PL",3330,null,null,null,null,null,null,null,null,null,null,"2014-12-01",63786,19218,1334,12458,3211,16127,2602.1762239999998]
[null,null,null,null,"2022-11-01","PL",3319,null,null,null,null,null,null,null,null,null,null,"2015-01-01",77212,16556,999,12491,3446,17250,2606.9667020000002]
[null,null,null,null,"2022-12-01","PL",2292,null,null,null,null,null,null,null,null,null,null,"2015-02-01",73611,18889,1009,13694,3618,16828,2581.7349439999998]
[null,null,null,null,"2023-01-01","PL",3368,null,null,null,null,null,null,null,null,null,null,"2015-03-01",80760,20783,1135,15307,4199,19308,2606.2815529999998]
[null,null,null,null,"2023-02-01","PL",3288,null,null,null,null,null,null,null,null,null,null,"2015-04-01",72131,19807,1039,14602,4147,18062,2605.603912]
[null,null,null,null,"2023-03-01","PL",3557,null,null,null,null,null,null,null,null,null,null,"2015-05-01",68358,16848,882,12705,4038,17453,2587.5024640000001]
[null,null,null,null,"2023-04-01","PL",2726,null,null,null,null,null,null,null,null,null,null,"2015-06-01",70176,18770,1096,14254,5174,19745,2576.67956]
[null,null,null,null,"2023-05-01","PL",3167,null,null,null,null,null,null,null,null,null,null,"2015-07-01",80276,20368,1034,15874,5289,19705,2599.7386630000001]
[null,null,null,null,"2023-06-01","PL",3445,null,null,null,null,null,null,null,null,null,null,"2015-08-01",67512,17217,922,13968,4628,16670,2570.3496909999999]
[null,null,null,null,"2023-07-01","PL",3347,null,null,null,null,null,null,null,null,null,null,"2015-09-01",72534,18397,1054,14929,4965,17064,2578.3913670000002]
[null,null,null,null,"2023-08-01","PL",3391,null,null,null,null,null,null,null,null,null,null,"2015-10-01",74685,18162,1457,15147,5291,17302,2703.682213]
[null,null,null,null,"2023-09-01","PL",2610,null,null,null,null,null,null,null,null,null,null,"2015-11-01",72511,18096,1121,15377,4928,17071,2577.986938]
[null,null,null,null,"2023-10-01","PL",3090,null,null,null,null,null,null,null,null,null,null,"2015-12-01",61982,18031,1071,13981,4874,16206,2578.5157359999998]
[null,null,null,null,"2023-11-01","PL",622,null,null,null,null,null,null,null,null,null,null,"2016-01-01",69529,15017,869,12810,4982,16061,2613.6529329999998]
[null,null,null,null,"2022-08-01","RTA",5141,null,null,null,null,null,null,null,null,null,null,"2016-02-01",71297,17856,1113,15310,5386,16648,2598.8336829999998]
[null,null,null,null,"2022-09-01","RTA",7522,null,null,null,null,null,null,null,null,null,null,"2016-03-01",69664,17356,1182,16802,5630,17930,2626.0171180000002]
[null,null,null,null,"2022-10-01","RTA",7601,null,null,null,null,null,null,null,null,null,null,"2016-04-01",70328,17108,1210,13996,5454,17828,2657.7851369999998]
[null,null,null,null,"2022-11-01","RTA",8303,null,null,null,null,null,null,null,null,null,null,"2016-05-01",64625,17045,1135,13568,5453,17185,2651.016157]
[null,null,null,null,"2022-12-01","RTA",6118,null,null,null,null,null,null,null,null,null,null,"2016-06-01",68898,17982,1337,14632,6180,18248,2678.5616559999999]
[null,null,null,null,"2023-01-01","RTA",7394,null,null,null,null,null,null,null,null,null,null,"2016-07-01",56478,14762,1053,11929,5173,16102,2689.5320780000002]
[null,null,null,null,"2023-02-01","RTA",7454,null,null,null,null,null,null,null,null,null,null,"2016-08-01",67061,12447,718,10517,4463,14663,2691.1935589999998]
[null,null,null,null,"2023-03-01","RTA",7434,null,null,null,null,null,null,null,null,null,null,"2016-09-01",66198,16545,1161,14064,6189,16274,2718.3006089999999]
[null,null,null,null,"2023-04-01","RTA",6103,null,null,null,null,null,null,null,null,null,null,"2016-10-01",67121,15788,1075,13713,6026,16012,2866.469693]
[null,null,null,null,"2023-05-01","RTA",6839,null,null,null,null,null,null,null,null,null,null,"2016-11-01",69748,17288,1191,15104,6191,16750,2736.7415150000002]
[null,null,null,null,"2023-06-01","RTA",7658,null,null,null,null,null,null,null,null,null,null,"2016-12-01",57123,15636,1001,12727,5278,14043,2739.757932]
[null,null,null,null,"2023-07-01","RTA",7267,null,null,null,null,null,null,null,null,null,null,"2017-01-01",65085,14979,950,12307,5943,15501,2756.3056929999998]
[null,null,null,null,"2023-08-01","RTA",7440,null,null,null,null,null,null,null,null,null,null,"2017-02-01",61420,15146,1276,13038,5725,14681,2775.2976800000001]
[null,null,null,null,"2023-09-01","RTA",6980,null,null,null,null,null,null,null,null,null,null,"2017-03-01",67677,16901,1237,17751,6677,17634,2781.6510750000002]
[null,null,null,null,"2023-10-01","RTA",6897,null,null,null,null,null,null,null,null,null,null,"2017-04-01",51890,12534,986,12380,5908,13451,2804.941433]
[null,null,null,null,"2023-11-01","RTA",1233,null,null,null,null,null,null,null,null,null,null,"2017-05-01",59933,14513,1036,13501,6371,15949,2802.762874]
["Note:The figure for claims exiting the Portal in January is 54% lower than for December 2020.  The reason for this is that during December a claimant law firm were running the exit process on approximately 12,000 claims on their case management system which, in error, had not been exited from the Portal when settled.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-06-01",60258,14273,1127,14280,6540,16020,2780.1689860000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-07-01",58486,13459,980,13315,6208,14883,2816.968797]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-01",58922,14398,963,14004,6428,14877,2802.7161649999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-01",56910,12920,933,12504,6197,14023,2789.7734449999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-01",61785,13796,956,14047,6130,14784,2795.8229959999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-01",61460,13122,932,13879,6447,14701,2794.4005929999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-01",48898,11623,1026,11329,5170,11229,2817.5956550000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-01",64293,12863,991,13327,6362,14246,2816.7610380000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-01",57340,12337,958,12799,5933,13236,2809.7034359999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-01",58497,12683,1111,13136,6066,14200,2823.95084]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01",54654,11912,1153,12751,5971,13564,2826.7349100000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-01",59388,12448,1112,12987,6217,14703,3081.4278439999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-01",54618,13928,1249,12895,5926,13687,2842.867002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-01",60276,12678,1141,13714,6829,14065,2844.582817]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-01",58321,12535,1070,14239,5999,13486,2854.045599]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01",54918,10917,884,12123,5765,12989,2834.5816719999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-01",65721,12981,1088,15184,6383,14896,2866.7593069999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-01",62328,12214,1072,14361,6309,15047,2864.3334880000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-01",47165,10736,1025,12146,4868,11451,2874.1370609999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01",62424,10965,887,14451,6201,14832,2851.3325279999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01",56832,10923,1068,13607,5324,12913,2832.512205]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",58032,11620,1040,13401,6083,14403,2826.1710330000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01",54723,10602,933,13313,5648,14194,2811.171194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01",57900,11198,972,13947,5936,14568,2816.6656229999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01",53653,10733,986,13127,5605,13731,2830.216218]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01",61054,12359,1151,15534,6697,15284,2818.0248449999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01",54874,11525,1107,14288,5663,13283,2824.7727620000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01",56733,11272,1112,13840,5703,13407,2845.4076879999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01",62524,11917,1301,15721,5699,14561,2820.7011969999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-01",59559,10749,1051,14884,5362,13522,2831.3890000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01",50791,10850,1145,13349,4741,11731,2818.5600239999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01",60062,10912,998,13480,5166,14051,2810.5993039999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-01",55548,10457,1125,14044,4681,12910,2818.5306860000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-01",49387,10953,1124,14964,5469,14999,2824.3724900000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-01",24628,7799,1044,8652,4689,13301,2851.398494]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-01",23081,4854,799,6744,4641,10814,2903.0515420000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-01",31196,5736,789,8447,5114,10486,2896.16723]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-01",39333,6891,796,10467,4887,10387,2911.730959]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-01",33922,6560,534,8512,3679,7651,2860.6581470000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-09-01",43018,7707,690,10521,4383,8584,2915.7207819999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-10-01",45723,8593,744,12512,3926,9043,2901.8816849999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-01",40610,8015,621,11071,3744,8775,2897.1472050000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-01",35480,7200,632,23441,3331,7963,2916.7117309999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01",37948,5980,514,10974,3658,8620,2897.29747]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-01",33533,5957,586,12365,3722,8526,2887.3594560000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-01",31614,6574,661,11707,4738,10158,2925.8765840000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01",36996,5830,654,10343,4094,7919,2923.1728990000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01",38009,5755,617,10188,3820,7652,2952.9120539999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-01",22650,6955,647,9834,4198,8170,2979.7564950000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01",14981,3835,742,6072,3876,7172,3031.3688590000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-01",11388,2445,695,4664,3588,6571,3044.8420799999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01",10692,2376,568,4177,3474,6090,3144.4790600000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-01",10160,2214,467,3966,3261,4965,3195.4544080000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01",9900,2021,447,3901,3046,4635,3427.8109359999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-01",7548,1809,405,2980,2162,3267,3573.4686470000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01",8827,1409,232,2666,1969,2931,3682.6437729999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-01",7747,1714,344,2829,1575,2541,3852.3370439999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-01",8287,1646,376,3008,1649,2556,3982.0434070000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",7332,1380,324,2338,1228,1900,4077.4852470000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",7916,1614,312,2646,1209,1879,4166.9296590000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01",7309,1495,303,2271,1052,1740,4309.2124480000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",7438,1642,328,2300,1083,1461,4624.2114369999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-01",8099,1748,355,2435,1250,1483,4307.001773]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",7636,1760,409,2317,1035,1316,4533.9122260000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",7622,1611,332,2200,1119,1301,4603.5783240000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",8327,1755,317,2511,1201,1311,4794.9559419999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",6163,1586,319,1863,853,1070,5137.7185509999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",6597,1346,311,1933,1014,1184,5133.2387920000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",6427,1576,381,1871,836,1033,5079.4991769999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",6748,1677,369,1896,913,1217,4787.5755950000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",5305,1283,229,1832,792,963,5191.174849]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",5919,1610,326,1750,952,1028,5281.335943]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",7550,1825,355,1844,841,1224,4541.2543379999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01",6405,1747,295,2280,866,1018,5534.7114730000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-01",6345,1934,365,2036,793,1013,5494.6000089999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-01",5882,1703,313,1643,653,748,5203.2341310000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-01",6897,1865,346,2055,830,963,5291.2558349999999]

{"sheet":"vRTADashboard","index":2,"n_rows":121,"n_cols":16,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
[null,934132,85677,15418,133916,68941,69364,318819.57600100001]
["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"]
["2014-01-01",1864,0,0,0,0,5,936,null,"2014-01-01"]
["2014-02-01",1618,0,0,0,0,5,1510,null,"2014-02-01"]
["2014-03-01",1828,0,0,0,0,2,1562.5,null,"2014-03-01"]
["2014-04-01",1605,0,0,0,0,6,1835.833333,null,"2014-04-01"]
["2014-05-01",1709,0,0,0,0,8,1262.3499999999999,null,"2014-05-01"]
["2014-06-01",1758,0,0,0,0,7,1041.5642849999999,null,"2014-06-01"]
["2014-07-01",1967,0,0,0,0,4,1282.5,null,"2014-07-01"]
["2014-08-01",1913,0,0,0,0,5,2005.896,null,"2014-08-01"]
["2014-09-01",2124,0,0,0,0,7,1625.714285,null,"2014-09-01"]
["2014-10-01",2440,0,0,0,0,10,1710.5,null,"2014-10-01"]
["2014-11-01",2056,0,0,0,0,7,2266.9814280000001,null,"2014-11-01"]
["2014-12-01",1620,0,0,0,0,6,1947.5,null,"2014-12-01",22502,0,0,0,0,72]
["2015-01-01",2023,0,0,0,0,16,1637.50125,null,"2015-01-01",22661,0,0,0,0,83]
["2015-02-01",2017,0,0,0,0,13,1558.461538,null,"2015-02-01",23060,0,0,0,0,91]
["2015-03-01",2198,0,0,0,0,15,1676.6666660000001,null,"2015-03-01",23430,0,0,0,0,104]
["2015-04-01",2139,0,0,0,0,16,1487.496875,null,"2015-04-01",23964,0,0,0,0,114]
["2015-05-01",2017,0,0,0,0,9,1701.6666660000001,null,"2015-05-01",24272,0,0,0,0,115]
["2015-06-01",2061,0,0,0,0,22,1471.418181,null,"2015-06-01",24575,0,0,0,0,130]
["2015-07-01",2356,0,0,0,0,14,1860.714285,null,"2015-07-01",24964,0,0,0,0,140]
["2015-08-01",2243,0,0,0,0,21,1497.6190469999999,null,"2015-08-01",25294,0,0,0,0,156]
["2015-09-01",2384,0,0,0,0,12,1804.2550000000001,null,"2015-09-01",25554,0,0,0,0,161]
["2015-10-01",2222,0,0,0,0,9,1525.123333,null,"2015-10-01",25336,0,0,0,0,160]
["2015-11-01",2070,0,0,0,0,15,2243.6666660000001,null,"2015-11-01",25350,0,0,0,0,168]
["2015-12-01",1612,0,0,0,0,9,1821.501111,null,"2015-12-01",25342,0,0,0,0,171]
["2016-01-01",1989,0,0,0,0,17,1553.8529410000001,null,"2016-01-01",25308,0,0,0,0,172]
["2016-02-01",2045,0,0,0,0,13,1579.107692,null,"2016-02-01",25336,0,0,0,0,172]
["2016-03-01",2064,0,0,0,0,17,1718.6623520000001,null,"2016-03-01",25202,0,0,0,0,174]
["2016-04-01",2192,0,0,0,0,18,1950.2222220000001,null,"2016-04-01",25255,0,0,0,0,176]
["2016-05-01",2084,0,0,0,0,19,1207.894736,null,"2016-05-01",25322,0,0,0,0,186]
["2016-06-01",2111,0,0,0,0,24,1380.083333,null,"2016-06-01",25372,0,0,0,0,188]
["2016-07-01",1963,0,0,0,0,26,2360.0384610000001,null,"2016-07-01",24979,0,0,0,0,200]
["2016-08-01",2071,0,0,0,0,23,1338.4834780000001,null,"2016-08-01",24807,0,0,0,0,202]
["2016-09-01",2119,0,0,0,0,27,1443.777777,null,"2016-09-01",24542,0,0,0,0,217]
["2016-10-01",2844,0,0,0,0,15,1594,null,"2016-10-01",25164,0,0,0,0,223]
["2016-11-01",5587,0,0,0,0,26,1356.461538,null,"2016-11-01",28681,0,0,0,0,234]
["2016-12-01",6603,0,0,0,0,16,1941.4937500000001,null,"2016-12-01",33672,0,0,0,0,241]
["2017-01-01",7667,0,0,0,0,14,1983.730714,null,"2017-01-01",39350,0,0,0,0,238]
["2017-02-01",7255,0,0,0,0,13,984.61538399999995,null,"2017-02-01",44560,0,0,0,0,238]
["2017-03-01",8228,0,0,0,0,23,1099.4182599999999,null,"2017-03-01",50724,0,0,0,0,244]
["2017-04-01",6363,0,0,0,0,17,2015.7135290000001,null,"2017-04-01",54895,0,0,0,0,243]
["2017-05-01",7033,0,0,0,0,14,2220.3571419999998,null,"2017-05-01",59844,0,0,0,0,238]
["2017-06-01",7213,0,0,0,0,25,1654.6,null,"2017-06-01",64946,0,0,0,0,239]
["2017-07-01",6662,0,0,0,0,22,1200,null,"2017-07-01",69645,0,0,0,0,235]
["2017-08-01",6990,0,0,0,0,14,1082.142857,null,"2017-08-01",74564,0,0,0,0,226]
["2017-09-01",6665,0,0,0,0,23,1084.782608,null,"2017-09-01",79110,0,0,0,0,222]
["2017-10-01",7477,0,0,0,0,23,2194.1304340000002,null,"2017-10-01",83743,0,0,0,0,230]
["2017-11-01",7577,0,0,0,0,26,1325.9546150000001,null,"2017-11-01",85733,0,0,0,0,230]
["2017-12-01",5677,0,0,0,0,13,1600.961538,null,"2017-12-01",84807,0,0,0,0,227]
["2018-01-01",7909,0,0,0,0,19,1992.413157,null,"2018-01-01",85049,0,0,0,0,232]
["2018-02-01",7319,0,0,0,0,25,1782.3208,null,"2018-02-01",85113,0,0,0,0,244]
["2018-03-01",7076,0,0,0,0,12,1658.333333,null,"2018-03-01",83961,0,0,0,0,233]
["2018-04-01",6970,0,0,0,0,24,1452.5,null,"2018-04-01",84568,0,0,0,0,240]
["2018-05-01",7539,0,0,0,0,23,1375,null,"2018-05-01",85074,0,0,0,0,249]
["2018-06-01",7098,0,0,0,0,19,1304.473684,null,"2018-06-01",84959,0,0,0,0,243]
["2018-07-01",7973,0,0,0,0,27,1515.1629620000001,null,"2018-07-01",86270,0,0,0,0,248]
["2018-08-01",7859,0,0,0,0,21,2083.669523,null,"2018-08-01",87139,0,0,0,0,255]
["2018-09-01",7708,0,0,0,0,12,2067.5,null,"2018-09-01",88182,0,0,0,0,244]
["2018-10-01",8844,0,0,0,0,39,1782.134358,null,"2018-10-01",89549,0,0,0,0,260]
["2018-11-01",9077,0,0,0,0,27,1979.357407,null,"2018-11-01",91049,0,0,0,0,261]
["2018-12-01",6802,0,0,0,0,21,2063.0952379999999,null,"2018-12-01",92174,0,0,0,0,269]
["2019-01-01",9516,0,0,0,0,28,2196.1428569999998,null,"2019-01-01",93781,0,0,0,0,278]
["2019-02-01",9051,0,0,0,0,20,1646.75,null,"2019-02-01",95513,0,0,0,0,273]
["2019-03-01",9868,0,0,0,0,39,2069.2307689999998,null,"2019-03-01",98305,0,0,0,0,300]
["2019-04-01",9713,0,0,0,0,25,2334.3312000000001,null,"2019-04-01",101048,0,0,0,0,301]
["2019-05-01",10700,0,0,0,0,19,1710.2631570000001,null,"2019-05-01",104209,0,0,0,0,297]
["2019-06-01",10436,0,0,0,0,23,2332.6756519999999,null,"2019-06-01",107547,0,0,0,0,301]
["2019-07-01",12271,0,0,1,0,30,1648.0333330000001,null,"2019-07-01",111845,0,0,1,0,304]
["2019-08-01",11110,0,0,0,0,21,2311.124761,null,"2019-08-01",115096,0,0,1,0,304]
["2019-09-01",16185,1,0,136,56,65,2905.2446150000001,null,"2019-09-01",123573,1,0,137,56,357]
["2019-10-01",21183,2602,362,4115,1677,929,2904.8487399999999,null,"2019-10-01",135912,2603,362,4252,1733,1247]
["2019-11-01",20252,2530,300,4233,1615,921,2880.3712810000002,null,"2019-11-01",147087,5133,662,8485,3348,2141]
["2019-12-01",16967,2546,348,3551,1589,886,2936.1543219999999,null,"2019-12-01",157252,7679,1010,12036,4937,3006]
["2020-01-01",21072,2280,316,3478,1590,1137,2971.7835,null,"2020-01-01",168808,9959,1326,15514,6527,4115]
["2020-02-01",20600,2447,384,4010,1517,1123,2885.6697410000002,null,"2020-02-01",180357,12406,1710,19524,8044,5218]
["2020-03-01",18645,2711,368,4125,1818,1186,2912.262436,null,"2020-03-01",189134,15117,2078,23649,9862,6365]
["2020-04-01",9325,1874,335,2340,1556,1208,2965.3720440000002,null,"2020-04-01",188746,16991,2413,25989,11418,7548]
["2020-05-01",8939,1261,273,1866,1419,915,2988.545486,null,"2020-05-01",186985,18252,2686,27855,12837,8444]
["2020-06-01",12866,1595,243,2586,1739,878,3095.3674249999999,null,"2020-06-01",189415,19847,2929,30441,14576,9299]
["2020-07-01",15817,1766,297,3238,1736,827,3158.2109310000001,null,"2020-07-01",192961,21613,3226,33678,16312,10096]
["2020-08-01",15531,1727,201,2595,1435,640,2916.9154060000001,null,"2020-08-01",197382,23340,3427,36273,17747,10715]
["2020-09-01",18575,1932,233,3159,1517,817,2995.1145769999998,null,"2020-09-01",199772,25271,3660,39296,19208,11467]
["2020-10-01",18901,2123,234,3443,1285,834,2988.7755870000001,null,"2020-10-01",197490,24792,3532,38624,18816,11372]
["2020-11-01",17661,1837,253,3111,1217,978,3072.035214,null,"2020-11-01",194899,24099,3485,37502,18418,11429]
["2020-12-01",15404,1612,258,6531,1125,837,3021.3565939999999,null,"2020-12-01",193336,23165,3395,40482,17954,11380]
["2021-01-01",16870,1340,211,3055,1239,844,3009.03872,null,"2021-01-01",189134,22225,3290,40059,17603,11087]
["2021-02-01",15010,1317,232,3366,1302,990,3132.1044539999998,null,"2021-02-01",183544,21095,3138,39415,17388,10954]
["2021-03-01",18934,1606,273,3140,1802,1047,3156.846074,null,"2021-03-01",183833,19990,3043,38430,17372,10815]
["2021-04-01",19130,1591,232,2771,1556,842,3197.5556759999999,null,"2021-04-01",193638,19707,2940,38861,17372,10449]
["2021-05-01",21097,1345,235,2689,1460,807,3024.3409409999999,null,"2021-05-01",205796,19791,2902,39684,17413,10341]
["2021-06-01",14973,1761,268,2788,1603,912,3209.9141439999999,null,"2021-06-01",207903,19957,2927,39886,17277,10375]
["2021-07-01",8929,997,306,1906,1483,732,3445.6259009999999,null,"2021-07-01",201015,19188,2936,38554,17024,10280]
["2021-08-01",7149,689,287,1414,1430,674,3539.3744649999999,null,"2021-08-01",192633,18150,3022,37373,17019,10314]
["2021-09-01",10340,1180,301,2137,2050,2221,3688.7942410000001,null,"2021-09-01",184398,17398,3090,36351,17552,11718]
["2021-10-01",10108,2272,470,3924,3272,5037,3581.6373669999998,null,"2021-10-01",175605,17547,3326,36832,19539,15921]
["2021-11-01",9881,2088,449,3863,3059,4732,3889.7603760000002,null,"2021-11-01",167825,17798,3522,37584,21381,19675]
["2021-12-01",7736,1870,410,2969,2132,3333,4047.8902699999999,null,"2021-12-01",160157,18056,3674,34022,22388,22171]
["2022-01-01",8774,1417,233,2592,1922,2934,4130.8697270000002,null,"2022-01-01",152061,18133,3696,33559,23071,24261]
["2022-02-01",7892,1694,339,2742,1524,2611,4189.7712019999999,null,"2022-02-01",144943,18510,3803,32935,23293,25882]
["2022-03-01",8052,1429,318,2505,1389,2184,4412.7547430000004,null,"2022-03-01",134061,18333,3848,32300,22880,27019]
["2022-04-01",7268,1420,328,2339,1232,1960,4651.6401679999999,null,"2022-04-01",122199,18162,3944,31868,22556,28137]
["2022-05-01",7900,1649,315,2380,1222,1927,4740.3486290000001,null,"2022-05-01",109002,18466,4024,31559,22318,29257]
["2022-06-01",7279,1561,309,2100,1059,1791,4810.6052760000002,null,"2022-06-01",101308,18266,4065,30871,21774,30136]
["2022-07-01",7367,1666,327,2056,1055,1507,5210.9377699999995,null,"2022-07-01",99746,18935,4086,31021,21346,30911]
["2022-08-01",8115,1756,347,2197,1211,1518,4829.8831680000003,null,"2022-08-01",100712,20002,4146,31804,21127,31755]
["2022-09-01",7522,1702,390,2033,949,1293,5136.3539899999996,null,"2022-09-01",97894,20524,4235,31700,20026,30827]
["2022-10-01",7601,1653,333,2080,1124,1341,5298.7300590000004,null,"2022-10-01",95387,19905,4098,29856,17878,27131]
["2022-11-01",8303,1784,320,2283,1168,1335,5397.441887,null,"2022-11-01",93809,19601,3969,28276,15987,23734]
["2022-12-01",6118,1616,323,1876,809,1061,5001.3427229999998,null,"2022-12-01",92191,19347,3882,27183,14664,21462]
["2023-01-01",7394,1369,311,1956,1014,1103,5476.3537889999998,null,"2023-01-01",90811,19299,3960,26547,13756,19631]
["2023-02-01",7454,1645,394,1950,858,1012,5327.1697329999997,null,"2023-02-01",90373,19250,4015,25755,13090,18032]
["2023-03-01",7434,1865,399,2182,1057,1223,5411.1850039999999,null,"2023-03-01",89755,19686,4096,25432,12758,17071]
["2023-04-01",6103,1303,229,1855,792,899,5525.8001999999997,null,"2023-04-01",88590,19569,3997,24948,12318,16010]
["2023-05-01",6839,1639,326,1771,952,988,5472.9942810000002,null,"2023-05-01",87529,19559,4008,24339,12048,15071]
["2023-06-01",7658,1869,355,1917,856,1036,5444.3361100000002,null,"2023-06-01",87908,19867,4054,24156,11845,14316]
["2023-07-01",7267,1754,296,2298,866,983,5721.9985550000001,null,"2023-07-01",87808,19955,4023,24398,11656,13792]
["2023-08-01",7440,1946,365,2053,793,985,5623.5326290000003,null,"2023-08-01",87133,20145,4041,24254,11238,13259]
["2023-09-01",6980,1718,344,1722,795,804,5234.6036059999997,null,"2023-09-01",86591,20161,3995,23943,11084,12770]
["2023-10-01",6897,1865,346,2055,830,963,5291.2558349999999,null,"2023-10-01",85887,20373,4008,23918,10790,12392]
["2023-11-01",1233,457,92,434,185,369,3510.328888]

{"sheet":"RTA vExitReasonCounts","index":3,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Exit Process Reason","Ttal"]
["Claim is too complex for process",232]
["Claim requires further investigation",17801]
["Duplicated claim",1376]
["Incomplete information provided on CNF",373]
["Interim payment for child claimant",8]
["Interim Payment partial offer not accepted",15]
["Interim Payment request not answered and/or paid on time",90]
["Other",15024]
["Stage 1 costs not paid on time",355]
["Value of claim below £1,000",14]
["Value of claim exceeds the upper limit",435]
["Withdrawal of offer",200]
["Withdrawl of claim",161]
["Wrong Portal",4515]
["Grand Total",40599]

{"sheet":"Year Calculations","index":4,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Period","CNFs sent","CNFs left at stage 1","Stage 2 exit","Exit process","Court pack","Settled claims"]
["2010-11",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2011-12",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2012-13",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2013-14",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2014-15",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2015-16",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2016-17",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2017-18",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2018-19",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2019-20",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]
["2020-21",{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('Backing Sheet Data'!#REF!)","v":{"$error":"#REF!"}}]