{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Backing Sheet Data","vPLDashboard","Year Calculations"],"not_rendered":{"charts":4,"images":1,"macros":0,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,26,1,27],[2,26,3,27],[4,26,5,27],[4,21,5,22],[0,21,1,22],[2,21,3,22],[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,9,1,10],[2,9,3,10],[4,9,5,10],[0,11,1,14],[2,11,3,14],[4,11,5,14],[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],[16,9,16,10],[16,11,16,12],[19,0,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[17,0,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[18,0,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[15,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],[8,11,8,12],[8,9,8,10],[8,7,8,8],[6,0,7,12],[8,0,8,6]]}
["Sent this month:",null,null,5440,null,"Left process at stage 1:",null,null,null,1415,null,"Left process at stage 2:",null,null,null,83,null,"Exited process:",null,null,null,482,null,"Settled:",null,null,289]
[]
["Δ from last month:",null,null,271,null,"Δ from last month:",null,null,null,221,null,"Δ from last month:",null,null,null,4,null,"Δ from last month:",null,null,null,54,null,"Δ from last month:",null,null,-25]
[]
["Rolling 12 months:",null,null,74330,null,"Rolling 12 months:",null,null,null,21704,null,"Rolling 12 months:",null,null,null,1047,null,"Rolling 12 months:",null,null,null,6882,null,"Rolling 12 months:",null,null,3523]
[]
["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,1086,null,942,null,144]
["Other",null,null,null,null,null,null,323,null,248,null,75]
["Total",null,null,null,null,null,null,1409,null,1190,null,219]
["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,1,null,0,null,1]
["Settlement pack timeout:",null,null,null,null,null,null,39,null,33,null,6]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,43,null,46,null,-3]
["Total",null,null,null,null,null,null,83,null,79,null,4]

{"sheet":"Backing Sheet Data","index":1,"n_rows":84,"n_cols":13,"rows_kept":84,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,3,3,4],[21,3,21,4],[8,7,8,8]]}
["Reporting date","2024-03-01"]
["Previous month","2024-02-01"]
[]
["Rolling 12 CNFs sent",null,null,"Average General Damages chart data",null,null,null,"Left Process Breakdown"]
[]
["Period","Rolling 12 Sent",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"]
["2023-04-01",72917,null,"2023-04-01",5750.8964699999997,null,null,1086,323,0,1,39,43]
["2023-05-01",72689,null,"2023-05-01",5143.6879779999999]
["2023-06-01",73409,null,"2023-06-01",5830.3861530000004,null,null,"CNF Sent Monthly Volumes Chart Data"]
["2023-07-01",73893,null,"2023-07-01",5310.542649]
["2023-08-01",74140,null,"2023-08-01",5289.601514,null,null,"Sum of ClaimCount","Column Labels"]
["2023-09-01",76874,null,"2023-09-01",5914.7955469999997,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total"]
["2023-10-01",76827,null,"2023-10-01",5540.1742629999999,null,null,"2023-04-01",6113,2733,543,2150,11539]
["2023-11-01",76608,null,"2023-11-01",5267.9037500000004,null,null,"2023-05-01",6862,3171,614,2215,12862]
["2023-12-01",76367,null,"2023-12-01",5778.3649800000003,null,null,"2023-06-01",7700,3451,640,2560,14351]
["2024-01-01",76071,null,"2024-01-01",5394.457566,null,null,"2023-07-01",7297,3350,695,2469,13811]
["2024-02-01",75647,null,"2024-02-01",4455.5985659999997,null,null,"2023-08-01",7471,3399,1003,2449,14322]
["2024-03-01",74330,null,"2024-03-01",3685.359031,null,null,"2023-09-01",7021,3144,3522,2368,16055]
[null,null,null,"Grand Total",63361.768466999994,null,null,"2023-10-01",7839,3328,423,2490,14080]
[null,null,null,null,null,null,null,"2023-11-01",7729,3237,468,2526,13960]
[null,null,null,null,null,null,null,"2023-12-01",5709,2263,211,1619,9802]
[null,13671,null,"CNF Sent Monthly Volumes",null,null,null,"2024-01-01",7494,3163,452,2496,13605]
["Exit Process Reason","Total",null,null,null,null,null,"2024-02-01",7275,3037,437,2264,13013]
["Claim requires further investigation",6429,null,"DatePeriod","ClaimType","ClaimCount",null,"2024-03-01",6584,2708,564,2168,12024]
["Other",5144,null,"2023-01-01","EL",504,null,"Grand Total",85094,36984,9572,27774,159424]
["Incomplete information provided on CNF",1081,null,"2023-02-01","EL",2355]
["Duplicated claim",480,null,"2023-03-01","EL",2656]
["Value of claim exceeds the upper limit",169,null,"2023-04-01","EL",2150]
["Stage 1 costs not paid on time",100,null,"2023-05-01","EL",2215]
["Withdrawl of claim",72,null,"2023-06-01","EL",2560]
["Claim is too complex for process",50,null,"2023-07-01","EL",2469]
["Interim Payment request not answered and/or paid on time",46,null,"2023-08-01","EL",2449]
["Failure to acknowledge CNF on time",43,null,"2023-09-01","EL",2368]
["Withdrawal of offer",25,null,"2023-10-01","EL",2490]
["Value of claim below £1,000",24,null,"2023-11-01","EL",2526]
["Failure to provide adequate loss of earnings details",4,null,"2023-12-01","EL",1619]
["Interim payment for child claimant",2,null,"2024-01-01","EL",2496]
["Interim Payment partial offer not accepted",2,null,"2024-02-01","EL",2264]
[null,null,null,"2024-03-01","EL",2168]
[null,null,null,"2023-01-01","ELD",90]
[null,null,null,"2023-02-01","ELD",521]
[null,null,null,"2023-03-01","ELD",533]
[null,null,null,"2023-04-01","ELD",543]
[null,null,null,"2023-05-01","ELD",614]
[null,null,null,"2023-06-01","ELD",640]
[null,null,null,"2023-07-01","ELD",695]
[null,null,null,"2023-08-01","ELD",1003]
[null,null,null,"2023-09-01","ELD",3522]
[null,null,null,"2023-10-01","ELD",423]
[null,null,null,"2023-11-01","ELD",468]
[null,null,null,"2023-12-01","ELD",211]
[null,null,null,"2024-01-01","ELD",452]
[null,null,null,"2024-02-01","ELD",437]
[null,null,null,"2024-03-01","ELD",564]
[null,null,null,"2023-01-01","PL",667]
[null,null,null,"2023-02-01","PL",3297]
[null,null,null,"2023-03-01","PL",3568]
[null,null,null,"2023-04-01","PL",2733]
[null,null,null,"2023-05-01","PL",3171]
[null,null,null,"2023-06-01","PL",3451]
[null,null,null,"2023-07-01","PL",3350]
[null,null,null,"2023-08-01","PL",3399]
[null,null,null,"2023-09-01","PL",3144]
[null,null,null,"2023-10-01","PL",3328]
[null,null,null,"2023-11-01","PL",3237]
[null,null,null,"2023-12-01","PL",2263]
[null,null,null,"2024-01-01","PL",3163]
[null,null,null,"2024-02-01","PL",3037]
[null,null,null,"2024-03-01","PL",2708]
[null,null,null,"2023-01-01","RTA",1493]
[null,null,null,"2023-02-01","RTA",7486]
[null,null,null,"2023-03-01","RTA",7470]
[null,null,null,"2023-04-01","RTA",6113]
[null,null,null,"2023-05-01","RTA",6862]
[null,null,null,"2023-06-01","RTA",7700]
[null,null,null,"2023-07-01","RTA",7297]
[null,null,null,"2023-08-01","RTA",7471]
[null,null,null,"2023-09-01","RTA",7021]
[null,null,null,"2023-10-01","RTA",7839]
[null,null,null,"2023-11-01","RTA",7729]
[null,null,null,"2023-12-01","RTA",5709]
[null,null,null,"2024-01-01","RTA",7494]
[null,null,null,"2024-02-01","RTA",7275]
[null,null,null,"2024-03-01","RTA",6584]

{"sheet":"vPLDashboard","index":2,"n_rows":129,"n_cols":26,"rows_kept":129,"cut":false,"hidden":true,"merged":[]}
[null,292025,70786,1490,23485,2098,10530,366501.04305199999]
["Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages","General Damage Bands",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"]
["2013-09-01",40,0,0,0,0,0,null,null,null,"2013-09-01",null,null,null,null,null,null,null,"2019-01-01",4652,3001,60,818,82,538,4257.2791070000003]
["2013-10-01",58,0,0,0,0,0,null,null,null,"2013-10-01",null,null,null,null,null,null,null,"2019-02-01",4582,2096,55,615,66,546,3956.2582050000001]
["2013-11-01",62,0,0,0,0,0,null,null,null,"2013-11-01",null,null,null,null,null,null,null,"2019-03-01",4831,2831,45,773,82,643,4356.284447]
["2013-12-01",48,0,0,0,0,0,null,null,null,"2013-12-01",null,null,null,null,null,null,null,"2019-04-01",4401,2782,50,729,69,514,4257.751381]
["2014-01-01",63,0,0,0,0,0,null,null,null,"2014-01-01",null,null,null,null,null,null,null,"2019-05-01",4374,2882,45,850,72,545,4283.9964950000003]
["2014-02-01",47,0,0,0,0,0,null,null,null,"2014-02-01",null,null,null,null,null,null,null,"2019-06-01",4188,2614,61,729,79,476,4252.704495]
["2014-03-01",57,0,0,0,0,0,null,null,null,"2014-03-01",null,null,null,null,null,null,null,"2019-07-01",5078,2851,52,889,78,569,4552.9510890000001]
["2014-04-01",63,0,0,0,0,0,null,null,null,"2014-04-01",null,null,null,null,null,null,null,"2019-08-01",4784,2607,44,780,82,472,4406.4034320000001]
["2014-05-01",87,0,0,0,0,0,null,null,null,"2014-05-01",null,null,null,null,null,null,null,"2019-09-01",4514,2850,45,791,59,480,4234.2869369999999]
["2014-06-01",82,0,0,0,0,2,775,"?0-?5k",null,"2014-06-01",null,null,null,null,null,null,null,"2019-10-01",4860,2554,67,851,89,550,4512.5319449999997]
["2014-07-01",92,0,0,0,0,0,null,null,null,"2014-07-01",null,null,null,null,null,null,null,"2019-11-01",4516,2210,40,806,77,511,4165.4439329999996]
["2014-08-01",101,0,0,0,0,0,null,null,null,"2014-08-01",800,0,0,0,0,2,null,"2019-12-01",3415,2110,43,724,58,430,4213.0240460000005]
["2014-09-01",98,0,0,0,0,0,null,null,null,"2014-09-01",858,0,0,0,0,2,null,"2020-01-01",4668,2270,40,806,62,515,4338.7701550000002]
["2014-10-01",119,0,0,0,0,1,1500,"?0-?5k",null,"2014-10-01",919,0,0,0,0,3,null,"2020-02-01",4534,1714,41,689,84,491,4327.5731969999997]
["2014-11-01",91,0,0,0,0,2,1425,"?0-?5k",null,"2014-11-01",948,0,0,0,0,5,null,"2020-03-01",4310,2417,70,878,74,497,4435.1404220000004]
["2014-12-01",66,0,0,0,0,2,2449.65,"?0-?5k",null,"2014-12-01",966,0,0,0,0,7,null,"2020-04-01",2857,2362,49,754,67,463,4444.0043409999998]
["2015-01-01",73,0,0,0,0,0,null,null,null,"2015-01-01",976,0,0,0,0,7,null,"2020-05-01",2284,1801,32,608,72,392,4446.4218870000004]
["2015-02-01",70,0,0,0,0,0,null,null,null,"2015-02-01",999,0,0,0,0,7,null,"2020-06-01",2713,1512,42,513,56,361,4457.8814949999996]
["2015-03-01",78,0,0,0,0,0,null,null,null,"2015-03-01",1020,0,0,0,0,7,null,"2020-07-01",3147,1378,37,488,47,310,4767.5551290000003]
["2015-04-01",82,0,0,0,0,1,8000,"?5-?10k",null,"2015-04-01",1039,0,0,0,0,8,null,"2020-08-01",2544,1217,30,422,35,228,4843.45057]
["2015-05-01",74,0,0,0,0,1,3695.22,"?0-?5k",null,"2015-05-01",1026,0,0,0,0,9,null,"2020-09-01",3548,1629,35,545,51,325,4378.5079999999998]
["2015-06-01",89,0,0,0,0,1,3350,"?0-?5k",null,"2015-06-01",1033,0,0,0,0,8,null,"2020-10-01",3817,1749,41,623,49,328,4633.476463]
["2015-07-01",88,0,0,0,0,1,3010,"?0-?5k",null,"2015-07-01",1029,0,0,0,0,9,null,"2020-11-01",3172,1907,48,624,43,343,4743.3511660000004]
["2015-08-01",80,0,0,0,0,0,null,null,null,"2015-08-01",1008,0,0,0,0,9,null,"2020-12-01",2510,1794,29,576,55,306,4367.7515030000004]
["2015-09-01",113,0,0,0,0,2,3500,"?0-?5k",null,"2015-09-01",1023,0,0,0,0,11,null,"2021-01-01",2953,1521,21,529,43,356,4548.3069660000001]
["2015-10-01",100,0,0,0,0,0,null,null,null,"2015-10-01",1004,0,0,0,0,10,null,"2021-02-01",1671,1046,23,324,34,303,4595.1910230000003]
["2015-11-01",99,0,0,0,0,1,5000,"?0-?5k",null,"2015-11-01",1012,0,0,0,0,9,null,"2021-03-01",3276,1716,44,588,50,408,4982.4639699999998]
["2015-12-01",55,0,0,0,0,0,null,null,null,"2015-12-01",1001,0,0,0,0,7,null,"2021-04-01",2692,1432,32,528,59,338,4664.8669229999996]
["2016-01-01",87,0,0,0,0,1,2500,"?0-?5k",null,"2016-01-01",1015,0,0,0,0,8,null,"2021-05-01",2707,1219,31,474,60,297,5076.2545449999998]
["2016-02-01",84,0,0,0,0,3,3024.016666,"?0-?5k",null,"2016-02-01",1029,0,0,0,0,11,null,"2021-06-01",3066,1555,43,547,61,338,4990.9703550000004]
["2016-03-01",73,0,0,0,0,2,0,"?0-?5k",null,"2016-03-01",1024,0,0,0,0,13,null,"2021-07-01",3155,1538,32,552,56,313,4951.6493609999998]
["2016-04-01",90,0,0,0,0,0,null,null,null,"2016-04-01",1032,0,0,0,0,12,null,"2021-08-01",3244,1660,29,527,45,294,5183.9015980000004]
["2016-05-01",84,0,0,0,0,3,4232.8066660000004,"?0-?5k",null,"2016-05-01",1042,0,0,0,0,14,null,"2021-09-01",3530,1600,35,544,43,293,4979.2150170000004]
["2016-06-01",89,0,0,0,0,0,null,null,null,"2016-06-01",1042,0,0,0,0,13,null,"2021-10-01",3347,1583,34,600,61,315,4870.601936]
["2016-07-01",84,0,0,0,0,2,1855,"?0-?5k",null,"2016-07-01",1038,0,0,0,0,14,null,"2021-11-01",3381,1680,36,618,40,322,4918.6393779999999]
["2016-08-01",99,0,0,0,0,2,2056.15,"?0-?5k",null,"2016-08-01",1057,0,0,0,0,16,null,"2021-12-01",2388,1611,29,545,36,305,5012.3989499999998]
["2016-09-01",124,0,0,0,0,1,3450,"?0-?5k",null,"2016-09-01",1068,0,0,0,0,15,null,"2022-01-01",3017,1515,22,576,49,347,4723.2562529999996]
["2016-10-01",205,0,0,0,0,4,2128.25,"?0-?5k",null,"2016-10-01",1173,0,0,0,0,19,null,"2022-02-01",3075,1158,34,460,48,318,4899.5186469999999]
["2016-11-01",446,0,0,0,0,0,null,null,null,"2016-11-01",1520,0,0,0,0,18,null,"2022-03-01",3300,1795,58,684,55,345,4537.9947240000001]
["2016-12-01",545,0,0,0,0,2,2112.5,"?0-?5k",null,"2016-12-01",2010,0,0,0,0,20,null,"2022-04-01",2624,1425,43,533,58,293,4829.560853]
["2017-01-01",733,0,0,0,0,3,2130.4033330000002,"?0-?5k",null,"2017-01-01",2656,0,0,0,0,22,null,"2022-05-01",3003,1533,47,591,47,366,4777.5615299999999]
["2017-02-01",731,0,0,0,0,1,1700,"?0-?5k",null,"2017-02-01",3303,0,0,0,0,20,null,"2022-06-01",2851,1480,53,511,50,333,4807.4264860000003]
["2017-03-01",732,0,0,0,0,1,4925,"?0-?5k",null,"2017-03-01",3962,0,0,0,0,19,null,"2022-07-01",2981,1525,42,526,54,283,4909.1396809999997]
["2017-04-01",557,0,0,0,0,1,0,"?0-?5k",null,"2017-04-01",4429,0,0,0,0,20,null,"2022-08-01",3364,1640,51,563,45,262,5540.7254190000003]
["2017-05-01",690,0,0,0,0,0,null,null,null,"2017-05-01",5035,0,0,0,0,17,null,"2022-09-01",3260,1644,29,614,49,246,4830.3337389999997]
["2017-06-01",660,0,0,0,0,2,2750,"?0-?5k",null,"2017-06-01",5606,0,0,0,0,19,null,"2022-10-01",3018,1652,35,581,57,272,5091.4652569999998]
["2017-07-01",644,0,0,0,0,4,1563.4875,"?0-?5k",null,"2017-07-01",6166,0,0,0,0,21,null,"2022-11-01",3208,1662,40,578,67,286,4630.6309090000004]
["2017-08-01",699,0,0,0,0,1,1815,"?0-?5k",null,"2017-08-01",6766,0,0,0,0,20,null,"2022-12-01",1855,1631,37,483,45,218,5549.3998620000002]
["2017-09-01",705,0,0,0,0,0,null,null,null,"2017-09-01",7347,0,0,0,0,19,null,"2023-01-01",3153,1506,28,520,55,278,6010.1974099999998]
["2017-10-01",709,0,0,0,0,5,3164,"?0-?5k",null,"2017-10-01",7851,0,0,0,0,20,null,"2023-02-01",3021,1062,37,441,38,284,5535.8254219999999]
["2017-11-01",717,0,0,0,0,0,null,null,null,"2017-11-01",8122,0,0,0,0,20,null,"2023-03-01",2991,1633,32,511,56,295,5284.159525]
["2017-12-01",586,0,0,0,0,1,2400,"?0-?5k",null,"2017-12-01",8163,0,0,0,0,19,null,"2023-04-01",2496,1421,27,482,50,281,5729.2077220000001]
["2018-01-01",822,0,0,0,0,2,3569.6,"?0-?5k",null,"2018-01-01",8252,0,0,0,0,18,null,"2023-05-01",2924,1519,36,488,53,284,5256.8928519999999]
["2018-02-01",746,0,0,0,0,2,2787.5,"?0-?5k",null,"2018-02-01",8267,0,0,0,0,19,null,"2023-06-01",3032,1660,44,518,51,317,5657.0596210000003]
["2018-03-01",716,0,0,0,0,1,0,"?0-?5k",null,"2018-03-01",8251,0,0,0,0,19,null,"2023-07-01",3113,1669,34,565,62,275,5430.433927]
["2018-04-01",752,0,0,0,0,1,1500,"?0-?5k",null,"2018-04-01",8446,0,0,0,0,19,null,"2023-08-01",3155,1666,38,602,48,287,5562.207386]
["2018-05-01",724,0,0,0,0,2,1315,"?0-?5k",null,"2018-05-01",8480,0,0,0,0,21,null,"2023-09-01",2846,1671,37,518,35,211,6225.9125590000003]
["2018-06-01",739,0,0,0,0,0,null,null,null,"2018-06-01",8559,0,0,0,0,19,null,"2023-10-01",3090,1662,42,547,43,334,5562.8584430000001]
["2018-07-01",744,0,0,0,0,3,2249.08,"?0-?5k",null,"2018-07-01",8659,0,0,0,0,18,null,"2023-11-01",3023,1657,41,539,56,346,5342.7597679999999]
["2018-08-01",751,0,0,0,0,0,null,null,null,"2018-08-01",8711,0,0,0,0,17,null,"2023-12-01",2020,1260,36,414,30,277,5552.4769310000001]
["2018-09-01",709,0,0,0,0,0,null,null,null,"2018-09-01",8715,0,0,0,0,17,null,"2024-01-01",5482,1553,43,491,41,307,5562.9094130000003]
["2018-10-01",901,0,0,0,0,2,1205,"?0-?5k",null,"2018-10-01",8907,0,0,0,0,14,null,"2024-02-01",5169,1194,33,428,46,314,5384.2635030000001]
["2018-11-01",819,0,0,0,0,0,null,null,null,"2018-11-01",9009,0,0,0,0,14,null,"2024-03-01",5440,1415,40,482,43,289,3685.359031]
["2018-12-01",637,0,0,0,0,0,null,null,null,"2018-12-01",9060,0,0,0,0,13]
["2019-01-01",925,0,0,0,0,1,3000,"?0-?5k",null,"2019-01-01",9163,0,0,0,0,12]
["2019-02-01",891,0,0,0,0,1,2500,"?0-?5k",null,"2019-02-01",9308,0,0,0,0,11]
["2019-03-01",986,0,0,0,0,4,3459.4,"?0-?5k",null,"2019-03-01",9578,0,0,0,0,14]
["2019-04-01",985,0,0,0,0,2,1550,"?0-?5k",null,"2019-04-01",9811,0,0,0,0,15]
["2019-05-01",997,0,0,0,0,1,0,"?0-?5k",null,"2019-05-01",10084,0,0,0,0,14]
["2019-06-01",924,0,0,0,0,3,2433.333333,"?0-?5k",null,"2019-06-01",10269,0,0,0,0,17]
["2019-07-01",1111,0,0,0,0,2,0,"?0-?5k",null,"2019-07-01",10636,0,0,0,0,16]
["2019-08-01",2102,0,0,0,0,3,2633.333333,"?0-?5k",null,"2019-08-01",11987,0,0,0,0,19]
["2019-09-01",2933,15,0,6,2,5,3448.9920000000002,"?0-?5k",null,"2019-09-01",14211,15,0,6,2,24]
["2019-10-01",3611,833,21,269,31,70,3939.904857,"?0-?5k",null,"2019-10-01",16921,848,21,275,33,92]
["2019-11-01",3427,784,16,256,26,49,3042.0485709999998,"?0-?5k",null,"2019-11-01",19529,1632,37,531,59,141]
["2019-12-01",2464,790,13,258,19,56,3724.4219640000001,"?0-?5k",null,"2019-12-01",21356,2422,50,789,78,197]
["2020-01-01",3495,841,17,287,16,61,4364.8862289999997,"?0-?5k",null,"2020-01-01",23926,3263,67,1076,94,257]
["2020-02-01",3477,618,16,252,28,67,3962.459253,"?0-?5k",null,"2020-02-01",26512,3881,83,1328,122,323]
["2020-03-01",3232,887,27,348,29,74,3453.6939179999999,"?0-?5k",null,"2020-03-01",28758,4768,110,1676,151,393]
["2020-04-01",2056,834,16,282,22,53,3280.9398110000002,"?0-?5k",null,"2020-04-01",29829,5602,126,1958,173,444]
["2020-05-01",1701,629,9,230,25,61,3594.7057370000002,"?0-?5k",null,"2020-05-01",30533,6231,135,2188,198,504]
["2020-06-01",2110,514,17,187,20,57,3606.15,"?0-?5k",null,"2020-06-01",31719,6745,152,2375,218,558]
["2020-07-01",2587,518,15,198,16,56,3304.6121419999999,"?0-?5k",null,"2020-07-01",33195,7263,167,2573,234,612]
["2020-08-01",2287,468,10,180,22,37,3945.9970269999999,"?0-?5k",null,"2020-08-01",33380,7731,177,2753,256,646]
["2020-09-01",2937,590,14,208,24,42,4829.5752380000004,"?0-?5k",null,"2020-09-01",33384,8306,191,2955,278,683]
["2020-10-01",2993,577,15,248,18,55,4390.8594540000004,"?0-?5k",null,"2020-10-01",32766,8050,185,2934,265,668]
["2020-11-01",2775,685,18,250,18,77,3712.2994800000001,"?0-?5k",null,"2020-11-01",32114,7951,187,2928,257,696]
["2020-12-01",2244,593,8,259,26,73,4216.5323280000002,"?0-?5k",null,"2020-12-01",31894,7754,182,2929,264,713]
["2021-01-01",2728,565,6,224,25,74,4317.7889180000002,"?0-?5k",null,"2021-01-01",31127,7478,171,2866,273,726]
["2021-02-01",2726,463,9,171,19,65,5194.0326150000001,"?5-?10k",null,"2021-02-01",30376,7323,164,2785,264,724]
["2021-03-01",3257,616,19,254,24,73,4243.5482190000002,"?0-?5k",null,"2021-03-01",30401,7052,156,2691,259,723]
["2021-04-01",2912,560,9,229,33,70,4578.0628569999999,"?0-?5k",null,"2021-04-01",31257,6778,149,2638,270,740]
["2021-05-01",2812,525,14,218,29,61,4889.7373770000004,"?0-?5k",null,"2021-05-01",32368,6674,154,2626,274,740]
["2021-06-01",3184,602,9,271,32,61,4800.8034420000004,"?0-?5k",null,"2021-06-01",33442,6762,146,2710,286,744]
["2021-07-01",3664,573,9,264,32,67,4360.1808950000004,"?0-?5k",null,"2021-07-01",34519,6817,140,2776,302,755]
["2021-08-01",5544,673,14,272,26,72,5118.7708329999996,"?5-?10k",null,"2021-08-01",37776,7022,144,2868,306,790]
["2021-09-01",6626,1175,27,402,33,181,5329.8606069999996,"?5-?10k",null,"2021-09-01",41465,7607,157,3062,315,929]
["2021-10-01",6456,1914,34,638,61,315,5258.7468879999997,"?5-?10k",null,"2021-10-01",44928,8944,176,3452,358,1189]
["2021-11-01",6619,2063,36,658,40,327,5439.3455350000004,"?5-?10k",null,"2021-11-01",48772,10322,194,3860,380,1439]
["2021-12-01",4803,1943,29,562,36,306,5448.9038879999998,"?5-?10k",null,"2021-12-01",51331,11672,215,4163,390,1672]
["2022-01-01",6163,1792,22,604,49,336,5138.7261900000003,"?5-?10k",null,"2022-01-01",54766,12899,231,4543,414,1934]
["2022-02-01",5949,1363,34,476,48,312,5409.0958010000004,"?5-?10k",null,"2022-02-01",57989,13799,256,4848,443,2181]
["2022-03-01",6755,1974,54,660,51,299,4833.7533439999997,"?0-?5k",null,"2022-03-01",61487,15157,291,5254,470,2407]
["2022-04-01",5347,1735,43,561,58,297,5284.1732650000004,"?5-?10k",null,"2022-04-01",63922,16332,325,5586,495,2634]
["2022-05-01",6229,1863,47,630,47,369,5155.0889969999998,"?5-?10k",null,"2022-05-01",67339,17670,358,5998,513,2942]
["2022-06-01",5931,1716,53,541,50,335,5323.0400589999999,"?5-?10k",null,"2022-06-01",70086,18784,402,6268,531,3216]
["2022-07-01",6030,1769,42,543,53,274,5361.8824080000004,"?5-?10k",null,"2022-07-01",72452,19980,435,6547,552,3423]
["2022-08-01",6602,1936,51,576,45,255,6042.5368619999999,"?5-?10k",null,"2022-08-01",73510,21243,472,6851,571,3606]
["2022-09-01",6305,1906,29,618,49,232,5302.3605600000001,"?5-?10k",null,"2022-09-01",73189,21974,474,7067,587,3657]
["2022-10-01",6288,1970,35,637,57,277,5470.6890970000004,"?5-?10k",null,"2022-10-01",73021,22030,475,7066,583,3619]
["2022-11-01",6449,2008,40,598,67,281,5142.3330239999996,"?5-?10k",null,"2022-11-01",72851,21975,479,7006,610,3573]
["2022-12-01",4312,1921,37,534,45,214,5279.1444849999998,"?5-?10k",null,"2022-12-01",72360,21953,487,6978,619,3481]
["2023-01-01",6416,1788,28,576,55,269,6015.9239029999999,"?5-?10k",null,"2023-01-01",72613,21949,493,6950,625,3414]
["2023-02-01",6173,1300,37,493,41,275,5605.1185809999997,"?5-?10k",null,"2023-02-01",72837,21886,496,6967,618,3377]
["2023-03-01",6757,2193,35,675,60,334,5263.8170950000003,"?5-?10k",null,"2023-03-01",72839,22105,477,6982,627,3412]
["2023-04-01",5426,1675,27,533,50,272,5750.8964699999997,"?5-?10k",null,"2023-04-01",72918,22045,461,6954,619,3387]
["2023-05-01",6000,1807,36,547,53,277,5143.6879779999999,"?5-?10k",null,"2023-05-01",72689,21989,450,6871,625,3295]
["2023-06-01",6651,1970,44,620,54,299,5830.3861530000004,"?5-?10k",null,"2023-06-01",73409,22243,441,6950,629,3259]
["2023-07-01",6514,1960,34,642,62,268,5310.542649,"?5-?10k",null,"2023-07-01",73893,22434,433,7049,638,3253]
["2023-08-01",6851,1929,38,656,48,284,5289.601514,"?5-?10k",null,"2023-08-01",74142,22427,420,7129,641,3282]
["2023-09-01",9034,1973,42,614,54,292,5914.7955469999997,"?5-?10k",null,"2023-09-01",76871,22494,433,7125,646,3342]
["2023-10-01",6241,1969,42,601,43,326,5540.1742629999999,"?5-?10k",null,"2023-10-01",76824,22493,440,7089,632,3391]
["2023-11-01",6231,1998,41,591,56,336,5267.9037500000004,"?5-?10k",null,"2023-11-01",76606,22483,441,7082,621,3446]
["2023-12-01",4093,1599,36,499,31,259,5778.3649800000003,"?5-?10k",null,"2023-12-01",76387,22161,440,7047,607,3491]
["2024-01-01",6111,1885,43,590,49,300,5394.457566,"?5-?10k",null,"2024-01-01",76082,22258,455,7061,601,3522]
["2024-02-01",5738,1524,33,507,48,321,4455.5985659999997,"?0-?5k",null,"2024-02-01",75647,22482,451,7075,608,3568]
["2024-03-01",5440,1415,40,482,43,289,3685.359031,"?0-?5k",null,"2024-03-01",74330,21704,456,6882,591,3523]

{"sheet":"Year Calculations","index":3,"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'!#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!"}}]