{"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":7,"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,2838,null,"Left process at stage 1:",null,null,null,1525,null,"Left process at stage 2:",null,null,null,84,null,"Exited process:",null,null,null,572,null,"Settled:",null,null,256]
[]
["Δ from last month:",null,null,244,null,"Δ from last month:",null,null,null,221,null,"Δ from last month:",null,null,null,13,null,"Δ from last month:",null,null,null,87,null,"Δ from last month:",null,null,31]
[]
["Rolling 12 months:",null,null,34629,null,"Rolling 12 months:",null,null,null,20446,null,"Rolling 12 months:",null,null,null,995,null,"Rolling 12 months:",null,null,null,6396,null,"Rolling 12 months:",null,null,3160]
[]
["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,1205,null,1078,null,127]
["Other",null,null,null,null,null,null,316,null,224,null,92]
["Total",null,null,null,null,null,null,1521,null,1302,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,0,null,0,null,0]
["Settlement pack timeout:",null,null,null,null,null,null,39,null,36,null,3]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,45,null,35,null,10]
["Total",null,null,null,null,null,null,84,null,71,null,13]

{"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-10-01"]
["Previous month","2024-09-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-11-01",38334,null,"2023-11-01",5550.8857440000002,null,null,1205,316,0,0,39,45]
["2023-12-01",38298,null,"2023-12-01",6038.1488669999999]
["2024-01-01",38089,null,"2024-01-01",5719.2117390000003,null,null,"CNF Sent Monthly Volumes Chart Data"]
["2024-02-01",37848,null,"2024-02-01",5574.1403749999999]
["2024-03-01",37220,null,"2024-03-01",6120.2103770000003,null,null,"Sum of ClaimCount","Column Labels"]
["2024-04-01",37468,null,"2024-04-01",5887.2665459999998,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total"]
["2024-05-01",36982,null,"2024-05-01",6260.8445490000004,null,null,"2023-11-01",7716,3235,468,2525,13944]
["2024-06-01",36178,null,"2024-06-01",6529.5757910000002,null,null,"2023-12-01",5703,2259,211,1618,9791]
["2024-07-01",35842,null,"2024-07-01",6772.5555430000004,null,null,"2024-01-01",7523,3163,451,2497,13634]
["2024-08-01",35217,null,"2024-08-01",6246.9163550000003,null,null,"2024-02-01",7262,3056,438,2272,13028]
["2024-09-01",35113,null,"2024-09-01",6373.1692849999999,null,null,"2024-03-01",6799,2939,570,2291,12599]
["2024-10-01",34629,null,"2024-10-01",6742.001835,null,null,"2024-04-01",7633,2983,502,2283,13401]
[null,null,null,"Grand Total",73814.927006000013,null,null,"2024-05-01",7115,2690,326,2007,12138]
[null,null,null,null,null,null,null,"2024-06-01",6945,2646,296,1936,11823]
[null,null,null,null,null,null,null,"2024-07-01",8161,3024,264,2247,13696]
[null,17260,null,"CNF Sent Monthly Volumes",null,null,null,"2024-08-01",7136,2813,232,2019,12200]
["Exit Process Reason","Total",null,null,null,null,null,"2024-09-01",7366,2983,489,1972,12810]
["Claim requires further investigation",7987,null,"DatePeriod","ClaimType","ClaimCount",null,"2024-10-01",8046,2838,253,1958,13095]
["Other",6526,null,"2023-08-01","EL",2448,null,"Grand Total",87405,34629,4500,25625,152159]
["Incomplete information provided on CNF",1348,null,"2023-09-01","EL",2367]
["Duplicated claim",605,null,"2023-10-01","EL",2492]
["Value of claim exceeds the upper limit",296,null,"2023-11-01","EL",2525]
["Stage 1 costs not paid on time",141,null,"2023-12-01","EL",1618]
["Withdrawl of claim",90,null,"2024-01-01","EL",2497]
["Claim is too complex for process",70,null,"2024-02-01","EL",2272]
["Interim Payment request not answered and/or paid on time",68,null,"2024-03-01","EL",2291]
["Failure to acknowledge CNF on time",64,null,"2024-04-01","EL",2283]
["Value of claim below £1,000",27,null,"2024-05-01","EL",2007]
["Withdrawal of offer",27,null,"2024-06-01","EL",1936]
["Interim Payment partial offer not accepted",5,null,"2024-07-01","EL",2247]
["Failure to provide adequate loss of earnings details",4,null,"2024-08-01","EL",2019]
["Interim payment for child claimant",2,null,"2024-09-01","EL",1972]
[null,null,null,"2024-10-01","EL",1958]
[null,null,null,"2023-08-01","ELD",1002]
[null,null,null,"2023-09-01","ELD",3513]
[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",451]
[null,null,null,"2024-02-01","ELD",438]
[null,null,null,"2024-03-01","ELD",570]
[null,null,null,"2024-04-01","ELD",502]
[null,null,null,"2024-05-01","ELD",326]
[null,null,null,"2024-06-01","ELD",296]
[null,null,null,"2024-07-01","ELD",264]
[null,null,null,"2024-08-01","ELD",232]
[null,null,null,"2024-09-01","ELD",489]
[null,null,null,"2024-10-01","ELD",253]
[null,null,null,"2023-08-01","PL",3398]
[null,null,null,"2023-09-01","PL",3142]
[null,null,null,"2023-10-01","PL",3322]
[null,null,null,"2023-11-01","PL",3235]
[null,null,null,"2023-12-01","PL",2259]
[null,null,null,"2024-01-01","PL",3163]
[null,null,null,"2024-02-01","PL",3056]
[null,null,null,"2024-03-01","PL",2939]
[null,null,null,"2024-04-01","PL",2983]
[null,null,null,"2024-05-01","PL",2690]
[null,null,null,"2024-06-01","PL",2646]
[null,null,null,"2024-07-01","PL",3024]
[null,null,null,"2024-08-01","PL",2813]
[null,null,null,"2024-09-01","PL",2983]
[null,null,null,"2024-10-01","PL",2838]
[null,null,null,"2023-08-01","RTA",7472]
[null,null,null,"2023-09-01","RTA",6993]
[null,null,null,"2023-10-01","RTA",7828]
[null,null,null,"2023-11-01","RTA",7716]
[null,null,null,"2023-12-01","RTA",5703]
[null,null,null,"2024-01-01","RTA",7523]
[null,null,null,"2024-02-01","RTA",7262]
[null,null,null,"2024-03-01","RTA",6799]
[null,null,null,"2024-04-01","RTA",7633]
[null,null,null,"2024-05-01","RTA",7115]
[null,null,null,"2024-06-01","RTA",6945]
[null,null,null,"2024-07-01","RTA",8161]
[null,null,null,"2024-08-01","RTA",7136]
[null,null,null,"2024-09-01","RTA",7366]
[null,null,null,"2024-10-01","RTA",8046]

{"sheet":"vPLDashboard","index":2,"n_rows":72,"n_cols":25,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[null,158046,82811,1759,27212,2404,11984,359052.70782400004,null,null,null,null,null,null,null,null,null,"* Oct 22 to Aug 24 fully refreshed - 18/09/2024"]
["Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages",null,"Period","Rolling 12 CNF Sent","Rolling 12 CNF Left at Stage 1","Rolling 12 Stage 2 Exit","Rolling 12 Exit Process","Rolling 12 Court Pack","Rolling 12 Settled Claims",null,"Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages"]
["2019-01-01",437,0,0,0,0,1,3000,null,"2019-01-01",null,null,null,null,null,null,null,"2019-01-01",4652,3001,60,818,82,538,4257.2791070000003]
["2019-02-01",429,0,0,0,0,1,2500,null,"2019-02-01",null,null,null,null,null,null,null,"2019-02-01",4582,2096,55,615,66,546,3956.2582050000001]
["2019-03-01",482,0,0,0,0,4,3459.4,null,"2019-03-01",null,null,null,null,null,null,null,"2019-03-01",4831,2831,45,773,82,643,4356.284447]
["2019-04-01",469,0,0,0,0,2,1550,null,"2019-04-01",null,null,null,null,null,null,null,"2019-04-01",4401,2782,50,729,69,514,4257.751381]
["2019-06-01",447,0,0,0,0,2,3650,null,"2019-06-01",null,null,null,null,null,null,null,"2019-05-01",4374,2882,45,850,72,545,4283.9964950000003]
["2019-08-01",1227,0,0,0,0,2,3950,null,"2019-08-01",null,null,null,null,null,null,null,"2019-06-01",4188,2614,61,729,79,476,4252.704495]
["2019-09-01",1472,15,0,6,2,5,3448.9920000000002,null,"2019-09-01",null,null,null,null,null,null,null,"2019-07-01",5078,2851,52,889,78,569,4552.9510890000001]
["2019-10-01",1807,833,21,269,31,70,4535.6019999999999,null,"2019-10-01",null,null,null,null,null,null,null,"2019-08-01",4784,2607,44,780,82,472,4406.4034320000001]
["2019-11-01",1737,784,16,256,26,49,4310.3689789999999,null,"2019-11-01",null,null,null,null,null,null,null,"2019-09-01",4514,2850,45,791,59,480,4234.2869369999999]
["2019-12-01",1244,790,13,258,19,56,4710.399821,null,"2019-12-01",null,null,null,null,null,null,null,"2019-10-01",4860,2554,67,851,89,550,4512.5319449999997]
["2020-01-01",1799,841,17,287,16,61,5458.2388520000004,null,"2020-01-01",null,null,null,null,null,null,null,"2019-11-01",4516,2210,40,806,77,511,4165.4439329999996]
["2020-02-01",1724,618,16,252,28,66,5486.1056060000001,null,"2020-02-01",13274,3881,83,1328,122,319,null,"2019-12-01",3415,2110,43,724,58,430,4213.0240460000005]
["2020-03-01",1598,887,27,348,29,72,4699.6293050000004,null,"2020-03-01",14435,4768,110,1676,151,390,null,"2020-01-01",4668,2270,40,806,62,515,4338.7701550000002]
["2020-04-01",1022,834,16,282,22,53,4258.4783010000001,null,"2020-04-01",15028,5602,126,1958,173,442,null,"2020-02-01",4534,1714,41,689,84,491,4327.5731969999997]
["2020-05-01",887,629,9,230,25,61,4877.4454089999999,null,"2020-05-01",15433,6231,135,2188,198,499,null,"2020-03-01",4310,2417,70,878,74,497,4435.1404220000004]
["2020-06-01",1078,514,17,187,20,57,4733.2840349999997,null,"2020-06-01",16042,6745,152,2375,218,554,null,"2020-04-01",2857,2362,49,754,67,463,4444.0043409999998]
["2020-07-01",1328,518,15,198,16,56,4929.1396420000001,null,"2020-07-01",16923,7263,167,2573,234,608,null,"2020-05-01",2284,1801,32,608,72,392,4446.4218870000004]
["2020-08-01",1176,468,10,180,22,37,5154.5883780000004,null,"2020-08-01",16872,7731,177,2753,256,643,null,"2020-06-01",2713,1512,42,513,56,361,4457.8814949999996]
["2020-09-01",1537,590,14,208,24,41,5543.31,null,"2020-09-01",16937,8306,191,2955,278,679,null,"2020-07-01",3147,1378,37,488,47,310,4767.5551290000003]
["2020-10-01",1564,577,15,248,18,53,5127.7267920000004,null,"2020-10-01",16694,8050,185,2934,265,662,null,"2020-08-01",2544,1217,30,422,35,228,4843.45057]
["2020-11-01",1444,685,18,250,18,74,4544.2843240000002,null,"2020-11-01",16401,7951,187,2928,257,687,null,"2020-09-01",3548,1629,35,545,51,325,4378.5079999999998]
["2020-12-01",1078,593,8,259,26,71,5332.6018299999996,null,"2020-12-01",16235,7754,182,2929,264,702,null,"2020-10-01",3817,1749,41,623,49,328,4633.476463]
["2021-01-01",1388,565,6,224,25,70,5071.0244279999997,null,"2021-01-01",15824,7478,171,2866,273,711,null,"2020-11-01",3172,1907,48,624,43,343,4743.3511660000004]
["2021-02-01",1284,463,9,171,19,59,6086.0652540000001,null,"2021-02-01",15384,7323,164,2785,264,704,null,"2020-12-01",2510,1794,29,576,55,306,4367.7515030000004]
["2021-03-01",1558,616,19,254,24,69,4898.7985500000004,null,"2021-03-01",15344,7052,156,2691,259,701,null,"2021-01-01",2953,1521,21,529,43,356,4548.3069660000001]
["2021-04-01",1369,560,9,229,33,69,5772.4582600000003,null,"2021-04-01",15691,6778,149,2638,270,717,null,"2021-02-01",1671,1046,23,324,34,303,4595.1910230000003]
["2021-05-01",1337,525,14,218,29,58,5382.205344,null,"2021-05-01",16141,6674,154,2626,274,714,null,"2021-03-01",3276,1716,44,588,50,408,4982.4639699999998]
["2021-06-01",1621,602,9,271,32,57,6016.210701,null,"2021-06-01",16684,6762,146,2710,286,714,null,"2021-04-01",2692,1432,32,528,59,338,4664.8669229999996]
["2021-07-01",1983,573,9,264,32,64,5514.254062,null,"2021-07-01",17339,6817,140,2776,302,722,null,"2021-05-01",2707,1219,31,474,60,297,5076.2545449999998]
["2021-08-01",3043,673,14,272,26,71,5754.2157740000002,null,"2021-08-01",19206,7022,144,2868,306,756,null,"2021-06-01",3066,1555,43,547,61,338,4990.9703550000004]
["2021-09-01",3593,1175,27,402,33,178,5592.961123,null,"2021-09-01",21262,7607,157,3062,315,893,null,"2021-07-01",3155,1538,32,552,56,313,4951.6493609999998]
["2021-10-01",3512,1914,34,638,61,314,5406.0533429999996,null,"2021-10-01",23210,8944,176,3452,358,1154,null,"2021-08-01",3244,1660,29,527,45,294,5183.9015980000004]
["2021-11-01",3495,2063,36,658,40,324,5606.8653389999999,null,"2021-11-01",25261,10322,194,3860,380,1404,null,"2021-09-01",3530,1600,35,544,43,293,4979.2150170000004]
["2021-12-01",2474,1943,29,562,36,303,5562.3535309999997,null,"2021-12-01",26657,11672,215,4163,390,1636,null,"2021-10-01",3347,1583,34,600,61,315,4870.601936]
["2022-01-01",3232,1792,22,604,49,331,5274.5152260000004,null,"2022-01-01",28501,12899,231,4543,414,1897,null,"2021-11-01",3381,1680,36,618,40,322,4918.6393779999999]
["2022-02-01",3183,1363,34,476,48,310,5462.3933219999999,null,"2022-02-01",30400,13799,256,4848,443,2148,null,"2021-12-01",2388,1611,29,545,36,305,5012.3989499999998]
["2022-03-01",3464,1974,54,660,51,296,4932.0843580000001,null,"2022-03-01",32306,15157,291,5254,470,2375,null,"2022-01-01",3017,1515,22,576,49,347,4723.2562529999996]
["2022-04-01",2780,1735,43,561,58,295,5319.9981690000004,null,"2022-04-01",33717,16332,325,5586,495,2601,null,"2022-02-01",3075,1158,34,460,48,318,4899.5186469999999]
["2022-05-01",3171,1863,47,630,47,366,5326.3016660000003,null,"2022-05-01",35551,17670,358,5998,513,2909,null,"2022-03-01",3300,1795,58,684,55,345,4537.9947240000001]
["2022-06-01",3009,1716,53,541,50,333,5471.5631530000001,null,"2022-06-01",36939,18784,402,6268,531,3185,null,"2022-04-01",2624,1425,43,533,58,293,4829.560853]
["2022-07-01",3209,1769,42,543,53,271,5507.3383389999999,null,"2022-07-01",38165,19980,435,6547,552,3392,null,"2022-05-01",3003,1533,47,591,47,366,4777.5615299999999]
["2022-08-01",3600,1936,51,576,45,254,6116.3995269999996,null,"2022-08-01",38722,21243,472,6851,571,3575,null,"2022-06-01",2851,1480,53,511,50,333,4807.4264860000003]
["2022-09-01",3369,1906,29,618,49,228,5522.0920169999999,null,"2022-09-01",38498,21974,474,7067,587,3625,null,"2022-07-01",2981,1525,42,526,54,283,4909.1396809999997]
["2022-10-01",3332,1970,35,637,57,273,5643.0429670000003,null,"2022-10-01",38318,22030,475,7066,583,3584,null,"2022-08-01",3364,1640,51,563,45,262,5540.7254190000003]
["2022-11-01",3324,2008,40,598,67,281,5226.4136289999997,null,"2022-11-01",38147,21975,479,7006,610,3541,null,"2022-09-01",3260,1644,29,614,49,246,4830.3337389999997]
["2022-12-01",2295,1921,37,534,45,201,5676.6291039999996,null,"2022-12-01",37968,21953,487,6978,619,3439,null,"2022-10-01",3332,1970,35,637,57,273,5643.0429670000003]
["2023-01-01",3373,1788,28,576,55,267,6191.6449810000004,null,"2023-01-01",38109,21949,493,6950,625,3375,null,"2022-11-01",3322,2008,40,598,67,281,5226.4136289999997]
["2023-02-01",3297,1300,37,493,41,274,5775.4877370000004,null,"2023-02-01",38223,21886,496,6967,618,3339,null,"2022-12-01",2295,1921,37,534,45,201,5676.6291039999996]
["2023-03-01",3567,2193,35,675,60,331,5439.9285190000001,null,"2023-03-01",38326,22105,477,6982,627,3374,null,"2023-01-01",3372,1788,28,576,55,267,6191.6449810000004]
["2023-04-01",2733,1675,27,533,50,268,5937.0847759999997,null,"2023-04-01",38279,22045,461,6954,619,3347,null,"2023-02-01",3297,1300,37,493,41,274,5775.4877370000004]
["2023-05-01",3173,1807,36,547,53,272,5417.1234189999996,null,"2023-05-01",38281,21989,450,6871,625,3253,null,"2023-03-01",3568,2193,35,675,60,331,5439.9285190000001]
["2023-06-01",3449,1970,44,620,54,293,6128.1987710000003,null,"2023-06-01",38721,22243,441,6950,629,3213,null,"2023-04-01",2733,1675,27,533,50,268,5937.0847759999997]
["2023-07-01",3352,1960,34,642,62,265,5479.1475840000003,null,"2023-07-01",38864,22434,433,7049,638,3207,null,"2023-05-01",3173,1807,36,547,53,272,5417.1234189999996]
["2023-08-01",3398,1929,38,656,48,281,5596.6673300000002,null,"2023-08-01",38662,22427,420,7129,641,3234,null,"2023-06-01",3448,1970,44,620,54,293,6128.1987710000003]
["2023-09-01",3142,1973,42,614,54,287,6067.6850519999998,null,"2023-09-01",38435,22494,433,7125,646,3293,null,"2023-07-01",3352,1960,34,642,62,265,5479.1475840000003]
["2023-10-01",3322,1969,42,601,43,317,5802.9801889999999,null,"2023-10-01",38425,22493,440,7089,632,3337,null,"2023-08-01",3398,1929,38,656,48,281,5596.6673300000002]
["2023-11-01",3235,1998,41,591,56,329,5550.8857440000002,null,"2023-11-01",38336,22483,441,7082,621,3385,null,"2023-09-01",3142,1973,42,614,54,287,6067.6850519999998]
["2023-12-01",2259,1599,36,499,31,256,6038.1488669999999,null,"2023-12-01",38300,22161,440,7047,607,3440,null,"2023-10-01",3322,1969,42,601,43,317,5802.9801889999999]
["2024-01-01",3163,1885,43,590,49,299,5719.2117390000003,null,"2024-01-01",38090,22258,455,7061,601,3472,null,"2023-11-01",3234,1998,41,591,56,329,5550.8857440000002]
["2024-02-01",3056,1524,33,507,48,320,5574.1403749999999,null,"2024-02-01",37849,22482,451,7075,608,3518,null,"2023-12-01",2259,1599,36,499,31,256,6038.1488669999999]
["2024-03-01",2939,1716,40,528,43,265,6120.2103770000003,null,"2024-03-01",37221,22005,456,6928,591,3452,null,"2024-01-01",3163,1885,43,590,49,299,5719.2117390000003]
["2024-04-01",2983,1751,36,499,50,278,5887.2665459999998,null,"2024-04-01",37471,22081,465,6894,591,3462,null,"2024-02-01",3056,1524,33,507,48,320,5574.1403749999999]
["2024-05-01",2690,1801,32,474,52,222,6260.8445490000004,null,"2024-05-01",36988,22075,461,6821,590,3412,null,"2024-03-01",2940,1716,40,528,43,265,6120.2103770000003]
["2024-06-01",2646,1642,36,513,35,221,6529.5757910000002,null,"2024-06-01",36185,21747,453,6714,571,3340,null,"2024-04-01",2981,1747,36,497,50,278,5887.2665459999998]
["2024-07-01",3024,1814,47,601,45,276,6772.5555430000004,null,"2024-07-01",35857,21601,466,6673,554,3351,null,"2024-05-01",2687,1512,32,433,52,227,6145.9108370000004]
["2024-08-01",2813,1599,43,497,42,214,6246.9163550000003,null,"2024-08-01",35272,21271,471,6514,548,3284,null,"2024-06-01",2644,1353,36,504,35,225,6442.3833329999998]
["2024-09-01",2983,1592,36,525,37,224,6373.1692849999999,null,"2024-09-01",35113,20890,465,6425,531,3221,null,"2024-07-01",3016,1512,47,598,45,285,6727.4583149999999]
["2024-10-01",2838,1525,39,572,45,256,6742.001835,null,"2024-10-01",34629,20446,462,6396,533,3160,null,"2024-08-01",2658,1260,37,479,38,205,6325.6983899999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-09-01",2594,1304,36,485,35,225,6390.8602220000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-01",2838,1525,39,572,45,256,6742.001835]

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