{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Backing Sheet Data","vELDDashboard","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":[[8,11,8,12],[8,9,8,10],[8,7,8,8],[6,0,7,12],[8,0,8,6],[15,9,15,10],[15,11,15,12],[12,0,13,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[14,0,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[9,7,9,8],[10,7,10,8],[11,7,11,8],[9,9,9,10],[10,9,10,10],[11,9,11,10],[16,9,16,10],[16,11,16,12],[19,0,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[17,0,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[18,0,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[0,3,1,4],[2,3,3,4],[4,3,5,4],[16,0,16,6],[16,7,16,8],[15,0,15,6],[15,7,15,8],[9,0,9,6],[10,0,10,6],[11,0,11,6],[0,0,1,2],[2,0,3,2],[4,0,5,2],[0,5,1,8],[2,5,3,8],[4,5,5,8],[0,9,1,10],[2,9,3,10],[4,9,5,10],[0,11,1,14],[2,11,3,14],[4,11,5,14],[0,15,1,16],[2,15,3,16],[4,15,5,16],[4,17,5,20],[0,23,1,25],[2,23,3,25],[4,23,5,25],[0,17,1,20],[2,17,3,20],[0,26,1,27],[2,26,3,27],[4,26,5,27],[4,21,5,22],[0,21,1,22],[2,21,3,22]]}
["Sent this month:",null,null,5440,null,"Left process at stage 1:",null,null,null,303,null,"Left process at stage 2:",null,null,null,5,null,"Exited process:",null,null,null,45,null,"Settled:",null,null,53]
[]
["Δ from last month:",null,null,271,null,"Δ from last month:",null,null,null,20,null,"Δ from last month:",null,null,null,-3,null,"Δ from last month:",null,null,null,-24,null,"Δ from last month:",null,null,-14]
[]
["Rolling 12 months:",null,null,74330,null,"Rolling 12 months:",null,null,null,6176,null,"Rolling 12 months:",null,null,null,76,null,"Rolling 12 months:",null,null,null,1883,null,"Rolling 12 months:",null,null,643]
[]
["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,296,null,277,null,19]
["Other",null,null,null,null,null,null,7,null,6,null,1]
["Total",null,null,null,null,null,null,303,null,283,null,20]
["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,4,null,6,null,-2]
["Settlement pack timeout:",null,null,null,null,null,null,1,null,2,null,-1]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,0,null,0,null,0]
["Total",null,null,null,null,null,null,5,null,8,null,-3]

{"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",3567.6917239999998,null,null,296,7,0,4,1,0]
["2023-05-01",72689,null,"2023-05-01",3785.4521869999999]
["2023-06-01",73409,null,"2023-06-01",3379.1122439999999,null,null,"CNF Sent Monthly Volumes Chart Data"]
["2023-07-01",73893,null,"2023-07-01",3552.0740000000001]
["2023-08-01",74140,null,"2023-08-01",3686.5510629999999,null,null,"Sum of ClaimCount","Column Labels"]
["2023-09-01",76874,null,"2023-09-01",3420.8219779999999,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total"]
["2023-10-01",76827,null,"2023-10-01",3185.3679240000001,null,null,"2023-04-01",6113,2733,543,2150,11539]
["2023-11-01",76608,null,"2023-11-01",3973.5549999999998,null,null,"2023-05-01",6862,3171,614,2215,12862]
["2023-12-01",76367,null,"2023-12-01",3188.6715060000001,null,null,"2023-06-01",7700,3451,640,2560,14351]
["2024-01-01",76071,null,"2024-01-01",3724.128181,null,null,"2023-07-01",7297,3350,695,2469,13811]
["2024-02-01",75647,null,"2024-02-01",3292.7536230000001,null,null,"2023-08-01",7471,3399,1003,2449,14322]
["2024-03-01",74330,null,"2024-03-01",4435.1320750000004,null,null,"2023-09-01",7021,3144,3522,2368,16055]
[null,null,null,"Grand Total",43191.311504999998,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,2939,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",1353,null,"DatePeriod","ClaimType","ClaimCount",null,"2024-03-01",6584,2708,564,2168,12024]
["Other",1054,null,"2023-01-01","EL",504,null,"Grand Total",85094,36984,9572,27774,159424]
["Duplicated claim",283,null,"2023-02-01","EL",2355]
["Withdrawl of claim",118,null,"2023-03-01","EL",2656]
["Incomplete information provided on CNF",102,null,"2023-04-01","EL",2150]
["Value of claim exceeds the upper limit",13,null,"2023-05-01","EL",2215]
["Withdrawal of offer",5,null,"2023-06-01","EL",2560]
["Stage 1 costs not paid on time",5,null,"2023-07-01","EL",2469]
["Claim is too complex for process",3,null,"2023-08-01","EL",2449]
["Failure to provide adequate loss of earnings details",2,null,"2023-09-01","EL",2368]
["Failure to acknowledge CNF on time",1,null,"2023-10-01","EL",2490]
[null,null,null,"2023-11-01","EL",2526]
[null,null,null,"2023-12-01","EL",1619]
[null,null,null,"2024-01-01","EL",2496]
[null,null,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":"vELDDashboard","index":2,"n_rows":90,"n_cols":26,"rows_kept":90,"cut":false,"hidden":true,"merged":[]}
[null,288385,12463,209,4356,9,1331,266672.40941099997]
["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"]
["2016-12-01",545,0,0,0,0,0,null,null,null,"2016-12-01",null,null,null,null,null,null,null,"2019-01-01",439,207,1,162,1,24,3734.3850000000002]
["2017-01-01",733,0,0,0,0,0,null,null,null,"2017-01-01",null,null,null,null,null,null,null,"2019-02-01",469,150,4,131,0,29,4074.730689]
["2017-02-01",731,0,0,0,0,0,null,null,null,"2017-02-01",null,null,null,null,null,null,null,"2019-03-01",444,247,4,154,1,29,3890.4275859999998]
["2017-03-01",732,0,0,0,0,0,null,null,null,"2017-03-01",null,null,null,null,null,null,null,"2019-04-01",405,225,3,153,3,36,4254.035277]
["2017-04-01",557,0,0,0,0,0,null,null,null,"2017-04-01",null,null,null,null,null,null,null,"2019-05-01",418,218,5,144,0,30,3973.95]
["2017-05-01",690,0,0,0,0,0,null,null,null,"2017-05-01",null,null,null,null,null,null,null,"2019-06-01",373,214,6,135,2,22,4900.1118180000003]
["2017-06-01",660,0,0,0,0,0,null,null,null,"2017-06-01",null,null,null,null,null,null,null,"2019-07-01",431,222,3,130,3,27,4078.7903700000002]
["2017-07-01",644,0,0,0,0,0,null,null,null,"2017-07-01",null,null,null,null,null,null,null,"2019-08-01",367,206,2,117,0,24,4280.0758329999999]
["2017-08-01",699,0,0,0,0,0,null,null,null,"2017-08-01",null,null,null,null,null,null,null,"2019-09-01",385,190,5,134,0,28,4135.5749999999998]
["2017-09-01",705,0,0,0,0,0,null,null,null,"2017-09-01",null,null,null,null,null,null,null,"2019-10-01",432,174,5,152,1,37,4641.1124319999999]
["2017-10-01",709,0,0,0,0,0,null,null,null,"2017-10-01",null,null,null,null,null,null,null,"2019-11-01",327,171,6,114,1,30,4546.5969999999998]
["2017-11-01",717,0,0,0,0,0,null,null,null,"2017-11-01",8122,0,0,0,0,0,null,"2019-12-01",254,144,5,95,4,15,3946.0520000000001]
["2017-12-01",586,0,0,0,0,0,null,null,null,"2017-12-01",8163,0,0,0,0,0,null,"2020-01-01",325,132,6,111,2,27,3777.607407]
["2018-01-01",822,0,0,0,0,0,null,null,null,"2018-01-01",8252,0,0,0,0,0,null,"2020-02-01",364,114,1,97,0,29,5334.2286199999999]
["2018-02-01",746,0,0,0,0,0,null,null,null,"2018-02-01",8267,0,0,0,0,0,null,"2020-03-01",335,173,4,104,0,48,4100.90625]
["2018-03-01",716,0,0,0,0,0,null,null,null,"2018-03-01",8251,0,0,0,0,0,null,"2020-04-01",380,141,1,113,2,50,4034.8254000000002]
["2018-04-01",752,0,0,0,0,0,null,null,null,"2018-04-01",8446,0,0,0,0,0,null,"2020-05-01",230,122,7,92,0,38,4309.4368420000001]
["2018-05-01",724,0,0,0,0,0,null,null,null,"2018-05-01",8480,0,0,0,0,0,null,"2020-06-01",265,171,5,102,0,51,4113.3231370000003]
["2018-06-01",739,0,0,0,0,0,null,null,null,"2018-06-01",8559,0,0,0,0,0,null,"2020-07-01",274,123,2,86,1,33,3784.4]
["2018-07-01",744,0,0,0,0,0,null,null,null,"2018-07-01",8659,0,0,0,0,0,null,"2020-08-01",160,104,1,69,0,20,4155.1270000000004]
["2018-08-01",751,0,0,0,0,0,null,null,null,"2018-08-01",8711,0,0,0,0,0,null,"2020-09-01",297,113,2,66,0,21,4429.1238089999997]
["2018-09-01",709,0,0,0,0,0,null,null,null,"2018-09-01",8715,0,0,0,0,0,null,"2020-10-01",309,100,2,104,0,35,4108.0280000000002]
["2018-10-01",901,0,0,0,0,0,null,null,null,"2018-10-01",8907,0,0,0,0,0,null,"2020-11-01",286,127,1,66,0,32,3741.734375]
["2018-11-01",819,0,0,0,0,0,null,null,null,"2018-11-01",9009,0,0,0,0,0,null,"2020-12-01",249,118,3,91,1,38,3454.5450000000001]
["2018-12-01",637,0,0,0,0,0,null,null,null,"2018-12-01",9060,0,0,0,0,0,null,"2021-01-01",310,135,2,96,0,44,3490.159772]
["2019-01-01",925,0,0,0,0,0,null,null,null,"2019-01-01",9163,0,0,0,0,0,null,"2021-02-01",161,81,1,53,0,45,3844.6666660000001]
["2019-02-01",891,0,0,0,0,0,null,null,null,"2019-02-01",9308,0,0,0,0,0,null,"2021-03-01",290,147,2,99,1,45,3700.4580000000001]
["2019-03-01",986,0,0,0,0,0,null,null,null,"2019-03-01",9578,0,0,0,0,0,null,"2021-04-01",302,132,4,87,0,29,3493.789655]
["2019-04-01",985,0,0,0,0,0,null,null,null,"2019-04-01",9811,0,0,0,0,0,null,"2021-05-01",240,129,1,84,0,44,3907.815681]
["2019-05-01",997,0,0,0,0,0,null,null,null,"2019-05-01",10084,0,0,0,0,0,null,"2021-06-01",258,190,1,69,1,17,4477.4264700000003]
["2019-06-01",924,0,0,0,0,0,null,null,null,"2019-06-01",10269,0,0,0,0,0,null,"2021-07-01",411,154,2,65,0,35,3377.4214280000001]
["2019-07-01",1111,0,0,0,0,0,null,null,null,"2019-07-01",10636,0,0,0,0,0,null,"2021-08-01",310,186,2,70,0,23,3008.734782]
["2019-08-01",2102,0,0,0,0,0,null,null,null,"2019-08-01",11987,0,0,0,0,0,null,"2021-09-01",322,187,9,88,0,56,3245.8401779999999]
["2019-09-01",2933,0,0,3,0,0,null,null,null,"2019-09-01",14211,0,0,3,0,0,null,"2021-10-01",335,162,4,70,0,46,3487.3402169999999]
["2019-10-01",3611,83,2,63,0,7,9071.4285710000004,"?5-?10k",null,"2019-10-01",16921,83,2,66,0,7,null,"2021-11-01",408,180,6,100,1,37,3714.3167560000002]
["2019-11-01",3427,78,4,52,0,2,9375,"?5-?10k",null,"2019-11-01",19529,161,6,118,0,9,null,"2021-12-01",252,194,4,90,0,31,3321.5448379999998]
["2019-12-01",2464,79,3,43,2,0,null,null,null,"2019-12-01",21356,240,9,161,2,9,null,"2022-01-01",360,192,5,92,0,63,3527.6668249999998]
["2020-01-01",3495,75,2,54,0,1,3625,"?0-?5k",null,"2020-01-01",23926,315,11,215,2,10,null,"2022-02-01",308,160,4,59,0,63,3380.2033329999999]
["2020-02-01",3477,54,0,44,0,1,10000,"?5-?10k",null,"2020-02-01",26512,369,11,259,2,11,null,"2022-03-01",416,223,5,71,0,36,4066.6277770000002]
["2020-03-01",3232,79,3,56,0,2,6875,"?5-?10k",null,"2020-03-01",28758,448,14,315,2,13,null,"2022-04-01",329,186,5,79,0,7,4384.6057140000003]
["2020-04-01",2056,72,0,48,1,2,6750,"?5-?10k",null,"2020-04-01",29829,520,14,363,3,15,null,"2022-05-01",394,246,4,76,1,36,3896.6563879999999]
["2020-05-01",1701,76,3,36,0,2,9250,"?5-?10k",null,"2020-05-01",30533,596,17,399,3,17,null,"2022-06-01",487,210,7,70,1,19,3997.4878939999999]
["2020-06-01",2110,68,0,36,0,4,10000,"?5-?10k",null,"2020-06-01",31719,664,17,435,3,21,null,"2022-07-01",427,417,9,56,0,28,3584.5535709999999]
["2020-07-01",2587,67,0,34,0,1,3600,"?0-?5k",null,"2020-07-01",33195,731,17,469,3,22,null,"2022-08-01",492,332,9,63,0,25,4211.5339999999997]
["2020-08-01",2287,53,0,31,0,0,null,null,null,"2020-08-01",33380,784,17,500,3,22,null,"2022-09-01",392,236,8,73,1,33,4464.692121]
["2020-09-01",2937,56,0,25,0,1,10000,"?5-?10k",null,"2020-09-01",33384,840,17,522,3,23,null,"2022-10-01",417,279,3,64,0,37,3634.3567560000001]
["2020-10-01",2993,45,0,39,0,3,8356.7999999999993,"?5-?10k",null,"2020-10-01",32766,802,15,498,3,19,null,"2022-11-01",427,243,3,84,1,29,4357.8310339999998]
["2020-11-01",2775,59,0,30,0,2,6750,"?5-?10k",null,"2020-11-01",32114,783,11,476,3,19,null,"2022-12-01",289,251,6,69,0,32,3895.4978120000001]
["2020-12-01",2244,71,0,53,1,3,2433.333333,"?0-?5k",null,"2020-12-01",31894,775,8,486,2,22,null,"2023-01-01",489,294,8,69,0,55,3662.1283629999998]
["2021-01-01",2728,86,0,41,0,3,3310.7333330000001,"?0-?5k",null,"2021-01-01",31127,786,6,473,2,24,null,"2023-02-01",508,198,3,70,0,19,4284.5473679999996]
["2021-02-01",2726,37,2,28,0,2,5930,"?5-?10k",null,"2021-02-01",30376,769,8,457,2,25,null,"2023-03-01",452,294,9,106,0,34,3586.0755880000002]
["2021-03-01",3257,69,2,45,0,2,13795.2,"?10-?25k",null,"2021-03-01",30401,759,7,446,2,25,null,"2023-04-01",534,243,4,75,0,29,3567.6917239999998]
["2021-04-01",2912,62,0,44,0,0,null,null,null,"2021-04-01",31257,749,7,442,1,23,null,"2023-05-01",605,204,12,90,0,64,3827.930781]
["2021-05-01",2812,59,0,35,0,1,17013.87,"?10-?25k",null,"2021-05-01",32368,732,4,441,1,22,null,"2023-06-01",620,437,4,88,0,48,3391.3125]
["2021-06-01",3184,81,0,35,0,0,null,null,null,"2021-06-01",33442,745,4,440,1,18,null,"2023-07-01",681,407,6,115,0,40,3578.8139999999999]
["2021-07-01",3664,65,1,35,0,3,6416.6666660000001,"?5-?10k",null,"2021-07-01",34519,743,5,441,1,20,null,"2023-08-01",942,410,8,176,0,47,3724.1510629999998]
["2021-08-01",5544,59,1,40,0,1,6500,"?5-?10k",null,"2021-08-01",37776,749,6,450,1,21,null,"2023-09-01",3397,424,3,366,0,50,3667.8904000000002]
["2021-09-01",6626,113,8,73,0,21,3171.77619,"?0-?5k",null,"2021-09-01",41465,806,14,498,1,41,null,"2023-10-01",414,977,3,398,0,53,3354.6698110000002]
["2021-10-01",6456,172,4,71,0,46,3425.7836950000001,"?0-?5k",null,"2021-10-01",44928,933,18,530,1,84,null,"2023-11-01",458,1711,9,197,0,42,4025.8597610000002]
["2021-11-01",6619,196,6,109,1,37,3912.0886479999999,"?0-?5k",null,"2021-11-01",48772,1070,24,609,2,119,null,"2023-12-01",209,330,3,43,0,73,3342.4386300000001]
["2021-12-01",4803,208,4,93,0,31,3562.2854830000001,"?0-?5k",null,"2021-12-01",51331,1207,28,649,1,147,null,"2024-01-01",5482,252,11,39,0,31,3815.9958059999999]
["2022-01-01",6163,203,5,98,0,62,3547.1379029999998,"?0-?5k",null,"2022-01-01",54766,1324,33,706,1,206,null,"2024-02-01",5169,283,8,69,0,67,3336.7150740000002]
["2022-02-01",5949,169,4,62,0,60,3531.9576659999998,"?0-?5k",null,"2022-02-01",57989,1456,35,740,1,264,null,"2024-03-01",5440,303,5,45,0,53,4435.1320750000004]
["2022-03-01",6755,239,5,71,0,32,4654.5253119999998,"?0-?5k",null,"2022-03-01",61487,1626,38,766,1,294]
["2022-04-01",5347,203,5,82,0,7,4386.0342849999997,"?0-?5k",null,"2022-04-01",63922,1767,43,804,1,301]
["2022-05-01",6229,266,4,83,1,35,3857.4942850000002,"?0-?5k",null,"2022-05-01",67339,1974,47,852,2,335]
["2022-06-01",5931,224,7,75,1,19,3958.0142099999998,"?0-?5k",null,"2022-06-01",70086,2117,54,892,3,354]
["2022-07-01",6030,426,8,61,0,27,3708.0555549999999,"?0-?5k",null,"2022-07-01",72452,2478,61,918,3,378]
["2022-08-01",6602,362,9,66,0,25,4221.5339999999997,"?0-?5k",null,"2022-08-01",73510,2781,69,944,3,402]
["2022-09-01",6305,257,8,74,1,33,4747.8772719999997,"?0-?5k",null,"2022-09-01",73189,2925,69,945,4,414]
["2022-10-01",6288,298,3,71,0,36,3836.7750000000001,"?0-?5k",null,"2022-10-01",73021,3051,68,945,4,404]
["2022-11-01",6449,257,3,86,1,29,5012.0768959999996,"?5-?10k",null,"2022-11-01",72851,3112,65,922,4,396]
["2022-12-01",4312,263,6,81,0,32,3439.2478120000001,"?0-?5k",null,"2022-12-01",72360,3167,67,910,4,397]
["2023-01-01",6416,317,8,71,0,55,3662.1283629999998,"?0-?5k",null,"2023-01-01",72613,3281,70,883,4,390]
["2023-02-01",6173,229,3,76,0,23,4206.8,"?0-?5k",null,"2023-02-01",72837,3341,69,897,4,353]
["2023-03-01",6757,352,10,120,0,35,3586.4734279999998,"?0-?5k",null,"2023-03-01",72839,3454,74,946,4,356]
["2023-04-01",5426,270,4,81,0,29,3567.6917239999998,"?0-?5k",null,"2023-04-01",72918,3521,73,945,4,378]
["2023-05-01",6000,226,12,98,0,64,3785.4521869999999,"?0-?5k",null,"2023-05-01",72689,3481,81,960,3,407]
["2023-06-01",6651,456,4,95,0,49,3379.1122439999999,"?0-?5k",null,"2023-06-01",73409,3713,78,980,2,437]
["2023-07-01",6514,425,6,126,0,40,3552.0740000000001,"?0-?5k",null,"2023-07-01",73893,3712,76,1045,2,450]
["2023-08-01",6851,428,8,198,0,47,3686.5510629999999,"?0-?5k",null,"2023-08-01",74142,3778,75,1177,2,472]
["2023-09-01",9034,443,3,405,0,91,3420.8219779999999,"?0-?5k",null,"2023-09-01",76871,3964,70,1508,1,530]
["2023-10-01",6241,1009,3,447,0,53,3185.3679240000001,"?0-?5k",null,"2023-10-01",76824,4675,70,1884,1,547]
["2023-11-01",6231,1726,9,220,0,42,3973.5549999999998,"?0-?5k",null,"2023-11-01",76606,6144,76,2018,0,560]
["2023-12-01",4093,336,3,49,0,73,3188.6715060000001,"?0-?5k",null,"2023-12-01",76387,6217,73,1986,0,601]
["2024-01-01",6111,260,11,45,0,33,3724.128181,"?0-?5k",null,"2024-01-01",76082,6160,76,1960,0,579]
["2024-02-01",5738,294,8,74,0,69,3292.7536230000001,"?0-?5k",null,"2024-02-01",75647,6225,81,1958,0,625]
["2024-03-01",5440,303,5,45,0,53,4435.1320750000004,"?0-?5k",null,"2024-03-01",74330,6176,76,1883,0,643]

{"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!"}}]