{"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,2278,null,"Left process at stage 1:",null,null,null,1338,null,"Left process at stage 2:",null,null,null,82,null,"Exited process:",null,null,null,510,null,"Settled:",null,null,238]
[]
["Δ from last month:",null,null,-421,null,"Δ from last month:",null,null,null,29,null,"Δ from last month:",null,null,null,13,null,"Δ from last month:",null,null,null,-8,null,"Δ from last month:",null,null,-53]
[]
["Rolling 12 months:",null,null,35444,null,"Rolling 12 months:",null,null,null,19878,null,"Rolling 12 months:",null,null,null,1032,null,"Rolling 12 months:",null,null,null,6704,null,"Rolling 12 months:",null,null,3209]
[]
["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,1077,null,1001,null,76]
["Other",null,null,null,null,null,null,257,null,299,null,-42]
["Total",null,null,null,null,null,null,1334,null,1300,null,34]
["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,2,null,-1]
["Settlement pack repudiated:",null,null,null,null,null,null,1,null,0,null,1]
["Settlement pack timeout:",null,null,null,null,null,null,29,null,23,null,6]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,51,null,44,null,7]
["Total",null,null,null,null,null,null,82,null,69,null,13]

{"sheet":"Backing Sheet Data","index":1,"n_rows":82,"n_cols":23,"rows_kept":82,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,3,3,4],[21,3,21,4],[8,7,8,8]]}
["Reporting date","2025-04-01"]
["Previous month","2025-03-01"]
[]
["Rolling 13 CNFs sent",null,null,"Average General Damages chart data",null,null,null,"Left Process Breakdown",null,null,null,null,null,null,null,"*Use this for In Month table on Dashboard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Figures refreshed from May 23 - Apr 25"]
["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",null,null,"Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages"]
["2024-04-01",40199,null,"2024-04-01",5887.2665459999998,null,null,1077,257,1,1,29,51,null,null,"2019-01-01",4652,3001,60,818,82,538,4257.2791070000003]
["2024-05-01",40156,null,"2024-05-01",6260.8445490000004,null,null,null,null,null,null,null,null,null,null,"2019-02-01",4582,2096,55,615,66,546,3956.2582050000001]
["2024-06-01",39631,null,"2024-06-01",6529.5757910000002,null,null,null,null,null,null,null,null,null,null,"2019-03-01",4831,2831,45,773,82,643,4356.284447]
["2024-07-01",39208,null,"2024-07-01",6786.71029,null,null,null,null,null,null,null,null,null,null,"2019-04-01",4401,2782,50,729,69,514,4257.751381]
["2024-08-01",38673,null,"2024-08-01",6246.9163550000003,null,null,null,null,null,null,null,null,null,null,"2019-05-01",4374,2882,45,850,72,545,4283.9964950000003]
["2024-09-01",38266,null,"2024-09-01",6373.1692849999999,null,null,null,null,null,null,null,null,null,null,"2019-06-01",4188,2614,61,729,79,476,4252.704495]
["2024-10-01",38272,null,"2024-10-01",6704.6259920000002,null,null,null,null,null,null,null,null,null,null,"2019-07-01",5078,2851,52,889,78,569,4552.9510890000001]
["2024-11-01",37681,null,"2024-11-01",6677.562293,null,null,null,null,null,null,null,null,null,null,"2019-08-01",4784,2607,44,780,82,472,4406.4034320000001]
["2024-12-01",36469,null,"2024-12-01",6591.129758,null,null,null,null,null,null,null,null,null,null,"2019-09-01",4514,2850,45,791,59,480,4234.2869369999999]
["2025-01-01",36965,null,"2025-01-01",6155.8921449999998,null,null,null,null,null,null,null,null,null,null,"2019-10-01",4860,2554,67,851,89,550,4512.5319449999997]
["2025-02-01",36461,null,"2025-02-01",8229.9276269999991,null,null,null,null,null,null,null,null,null,null,"2019-11-01",4516,2210,40,806,77,511,4165.4439329999996]
["2025-03-01",36105,null,"2025-03-01",6560.8502060000001,null,null,null,null,null,null,null,null,null,null,"2019-12-01",3415,2110,43,724,58,430,4213.0240460000005]
["2025-04-01",35444,null,"2025-04-01",6604.0404200000003,null,null,null,null,null,null,null,null,null,null,"2020-01-01",4668,2270,40,806,62,515,4338.7701550000002]
[null,null,null,"Grand Total",85608.51125700002,null,null,null,null,null,null,null,null,null,null,"2020-02-01",4534,1714,41,689,84,491,4327.5731969999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-01",4310,2417,70,878,74,497,4435.1404220000004]
[null,20146,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-01",2857,2362,49,754,67,463,4444.0043409999998]
["Exit Process Reason","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-01",2284,1801,32,608,72,392,4446.4218870000004]
["Incomplete information provided on CNF",1586,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-01",2713,1512,42,513,56,361,4457.8814949999996]
["Value of claim below £1,000",31,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-01",3147,1378,37,488,47,310,4767.5551290000003]
["Value of claim exceeds the upper limit",425,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-01",2544,1217,30,422,35,228,4843.45057]
["Claim is too complex for process",93,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-09-01",3548,1629,35,545,51,325,4378.5079999999998]
["Withdrawl of claim",102,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-10-01",3817,1749,41,623,49,328,4633.476463]
["Duplicated claim",715,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-01",3172,1907,48,624,43,343,4743.3511660000004]
["Withdrawal of offer",33,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-01",2510,1794,29,576,55,306,4367.7515030000004]
["Interim payment for child claimant",2,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01",2953,1521,21,529,43,356,4548.3069660000001]
["Claim requires further investigation",9148,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-01",1671,1046,23,324,34,303,4595.1910230000003]
["Other",7682,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-01",3276,1716,44,588,50,408,4982.4639699999998]
["Stage 1 costs not paid on time",160,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01",2692,1432,32,528,59,338,4664.8669229999996]
["Interim Payment partial offer not accepted",6,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01",2707,1219,31,474,60,297,5076.2545449999998]
["Interim Payment request not answered and/or paid on time",86,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-01",3066,1555,43,547,61,338,4990.9703550000004]
["Failure to provide adequate loss of earnings details",4,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01",3155,1538,32,552,56,313,4951.6493609999998]
["Failure to acknowledge CNF on time",73,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-01",3244,1660,29,527,45,294,5183.9015980000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01",3530,1600,35,544,43,293,4979.2150170000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-01",3347,1583,34,600,61,315,4870.601936]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01",3381,1680,36,618,40,322,4918.6393779999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-01",2388,1611,29,545,36,305,5012.3989499999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01",3017,1515,22,576,49,347,4723.2562529999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-01",3075,1158,34,460,48,318,4899.5186469999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-01",3300,1795,58,684,55,345,4537.9947240000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",2624,1425,43,533,58,293,4829.560853]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",3003,1533,47,591,47,366,4777.5615299999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01",2851,1480,53,511,50,333,4807.4264860000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",2981,1525,42,526,54,283,4909.1396809999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-01",3364,1640,51,563,45,262,5540.7254190000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",3260,1644,29,614,49,246,4830.3337389999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",3332,1970,35,637,57,273,5643.0429670000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",3322,2008,40,598,67,281,5226.4136289999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",2295,1921,37,534,45,201,5676.6291039999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",3372,1788,28,576,55,267,6191.6449810000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",3297,1300,37,493,41,274,5775.4877370000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",3568,2193,35,675,60,331,5439.9285190000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",2733,1675,27,533,50,268,5937.0847759999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",3172,1807,36,547,53,272,5417.1234189999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",3448,1970,44,620,54,293,6128.1987710000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01",3351,1960,34,642,62,265,5479.1475840000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-01",3397,1929,38,656,48,281,5596.6673300000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-01",3142,1973,42,614,54,287,6067.6850519999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-01",3323,1969,42,601,43,317,5802.9801889999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-01",3233,1998,41,591,56,329,5550.8857440000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-01",2259,1599,36,499,31,256,6038.1488669999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01",3163,1885,43,590,49,299,5719.2117390000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-02-01",3055,1524,33,507,48,320,5574.1403749999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-01",2939,1716,40,528,43,265,6120.2103770000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-04-01",2984,1758,36,499,50,278,5887.2665459999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-01",2690,1801,32,474,52,222,6260.8445490000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-06-01",2647,1642,36,513,35,221,6529.5757910000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-07-01",3025,1814,47,601,45,275,6786.71029]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-08-01",2816,1599,43,497,42,214,6246.9163550000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-09-01",2990,1593,36,525,37,224,6373.1692849999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-01",3148,1662,39,604,47,262,6704.6259920000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-01",2732,1560,21,548,52,266,6677.562293]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-01",2021,1373,30,445,51,207,6591.129758]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01",2755,1408,37,495,45,275,6155.8921449999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-02-01",2659,1021,29,475,39,236,8229.9276269999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-03-01",2699,1309,25,518,44,291,6560.8502060000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-01",2278,1338,31,510,51,238,6604.0404200000003]

{"sheet":"vPLDashboard","index":2,"n_rows":78,"n_cols":25,"rows_kept":78,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"SUBTOTAL(9,vPLDashboard[CNFs Sent])","v":173513},{"$f":"SUBTOTAL(9,vPLDashboard[CNFs left at Stage 1])","v":90965},{"$f":"SUBTOTAL(9,vPLDashboard[Stage 2 Exit])","v":1932},{"$f":"SUBTOTAL(9,vPLDashboard[Exit process])","v":30235},{"$f":"SUBTOTAL(9,vPLDashboard[Court Pack])","v":2688},{"$f":"SUBTOTAL(9,vPLDashboard[Settled claims])","v":13502},{"$f":"SUBTOTAL(9,vPLDashboard[General Damages])","v":399848.88917700003},null,null,null,null,null,null,null,null,null,"* Figures refreshed from May 23 - Apr 25"]
["Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages",null,"Period","Rolling 13 CNF Sent","Rolling 13 CNF Left at Stage 1","Rolling 13 Stage 2 Exit","Rolling 13 Exit Process","Rolling 13 Court Pack","Rolling 13 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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-04-01"},null,null,null,null,null,null,null,"2019-04-01",4401,2782,50,729,69,514,4257.751381]
["2019-06-01",448,0,0,0,0,2,3650,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-02-01"},{"$f":"SUM(B2:B14)","v":13275},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,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-03-01"},{"$f":"SUM(B3:B15)","v":14873},4768,110,1676,151,391,null,"2020-01-01",4668,2270,40,806,62,515,4338.7701550000002]
["2020-04-01",1022,834,16,282,22,53,4258.4783010000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-04-01"},{"$f":"SUM(B4:B16)","v":15458},5602,126,1958,173,443,null,"2020-02-01",4534,1714,41,689,84,491,4327.5731969999997]
["2020-05-01",887,629,9,230,25,61,4877.4454089999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-05-01"},{"$f":"SUM(B5:B17)","v":15916},6231,135,2188,198,503,null,"2020-03-01",4310,2417,70,878,74,497,4435.1404220000004]
["2020-06-01",1078,514,17,187,20,57,4733.2840349999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-06-01"},{"$f":"SUM(B6:B18)","v":16512},6745,152,2375,218,556,null,"2020-04-01",2857,2362,49,754,67,463,4444.0043409999998]
["2020-07-01",1329,518,15,198,16,56,4929.1396420000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-07-01"},{"$f":"SUM(B7:B19)","v":17372},7263,167,2573,234,610,null,"2020-05-01",2284,1801,32,608,72,392,4446.4218870000004]
["2020-08-01",1176,468,10,180,22,37,5154.5883780000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-08-01"},{"$f":"SUM(B8:B20)","v":18100},7731,177,2753,256,645,null,"2020-06-01",2713,1512,42,513,56,361,4457.8814949999996]
["2020-09-01",1537,590,14,208,24,41,5543.31,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-09-01"},{"$f":"SUM(B9:B21)","v":18410},8321,191,2961,280,684,null,"2020-07-01",3147,1378,37,488,47,310,4767.5551290000003]
["2020-10-01",1564,577,15,248,18,53,5127.7267920000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-10-01"},{"$f":"SUM(B10:B22)","v":18502},8883,206,3203,296,732,null,"2020-08-01",2544,1217,30,422,35,228,4843.45057]
["2020-11-01",1444,685,18,250,18,74,4544.2843240000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-11-01"},{"$f":"SUM(B11:B23)","v":18139},8735,203,3184,283,736,null,"2020-09-01",3548,1629,35,545,51,325,4378.5079999999998]
["2020-12-01",1078,593,8,259,26,71,5332.6018299999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-12-01"},{"$f":"SUM(B12:B24)","v":17480},8544,195,3187,283,758,null,"2020-10-01",3817,1749,41,623,49,328,4633.476463]
["2021-01-01",1388,565,6,224,25,70,5071.0244279999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-01-01"},{"$f":"SUM(B13:B25)","v":17624},8319,188,3153,289,772,null,"2020-11-01",3172,1907,48,624,43,343,4743.3511660000004]
["2021-02-01",1284,463,9,171,19,59,6086.0652540000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-02-01"},{"$f":"SUM(B14:B26)","v":17109},7941,180,3037,292,770,null,"2020-12-01",2510,1794,29,576,55,306,4367.7515030000004]
["2021-03-01",1558,616,19,254,24,69,4898.7985500000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-03-01"},{"$f":"SUM(B15:B27)","v":16943},7939,183,3039,288,773,null,"2021-01-01",2953,1521,21,529,43,356,4548.3069660000001]
["2021-04-01",1369,560,9,229,33,69,5772.4582600000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-04-01"},{"$f":"SUM(B16:B28)","v":16714},7612,165,2920,292,770,null,"2021-02-01",1671,1046,23,324,34,303,4595.1910230000003]
["2021-05-01",1337,525,14,218,29,58,5382.205344,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-05-01"},{"$f":"SUM(B17:B29)","v":17029},7303,163,2856,299,775,null,"2021-03-01",3276,1716,44,588,50,408,4982.4639699999998]
["2021-06-01",1621,602,9,271,32,57,6016.210701,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-06-01"},{"$f":"SUM(B18:B30)","v":17763},7276,163,2897,306,771,null,"2021-04-01",2692,1432,32,528,59,338,4664.8669229999996]
["2021-07-01",1983,573,9,264,32,64,5514.254062,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-07-01"},{"$f":"SUM(B19:B31)","v":18668},7335,155,2974,318,778,null,"2021-05-01",2707,1219,31,474,60,297,5076.2545449999998]
["2021-08-01",3043,673,14,272,26,71,5754.2157740000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-08-01"},{"$f":"SUM(B20:B32)","v":20382},7490,154,3048,328,793,null,"2021-06-01",3066,1555,43,547,61,338,4990.9703550000004]
["2021-09-01",3593,1175,27,402,33,178,5592.961123,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-09-01"},{"$f":"SUM(B21:B33)","v":22799},8197,171,3270,339,934,null,"2021-07-01",3155,1538,32,552,56,313,4951.6493609999998]
["2021-10-01",3512,1914,34,638,61,314,5406.0533429999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-10-01"},{"$f":"SUM(B22:B34)","v":24774},9521,191,3700,376,1207,null,"2021-08-01",3244,1660,29,527,45,294,5183.9015980000004]
["2021-11-01",3495,2063,36,658,40,324,5606.8653389999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-11-01"},{"$f":"SUM(B23:B35)","v":26705},11007,212,4110,398,1478,null,"2021-09-01",3530,1600,35,544,43,293,4979.2150170000004]
["2021-12-01",2474,1943,29,562,36,303,5562.3535309999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-12-01"},{"$f":"SUM(B24:B36)","v":27735},12265,223,4422,416,1707,null,"2021-10-01",3347,1583,34,600,61,315,4870.601936]
["2022-01-01",3232,1792,22,604,49,331,5274.5152260000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-01-01"},{"$f":"SUM(B25:B37)","v":29889},13464,237,4767,439,1967,null,"2021-11-01",3381,1680,36,618,40,322,4918.6393779999999]
["2022-02-01",3183,1363,34,476,48,310,5462.3933219999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-02-01"},{"$f":"SUM(B26:B38)","v":31684},14262,265,5019,462,2207,null,"2021-12-01",2388,1611,29,545,36,305,5012.3989499999998]
["2022-03-01",3464,1974,54,660,51,296,4932.0843580000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-03-01"},{"$f":"SUM(B27:B39)","v":33864},15773,310,5508,494,2444,null,"2022-01-01",3017,1515,22,576,49,347,4723.2562529999996]
["2022-04-01",2780,1735,43,561,58,295,5319.9981690000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-04-01"},{"$f":"SUM(B28:B40)","v":35086},16892,334,5815,528,2670,null,"2022-02-01",3075,1158,34,460,48,318,4899.5186469999999]
["2022-05-01",3172,1863,47,630,47,366,5326.3016660000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-05-01"},{"$f":"SUM(B29:B41)","v":36889},18195,372,6216,542,2967,null,"2022-03-01",3300,1795,58,684,55,345,4537.9947240000001]
["2022-06-01",3009,1716,53,541,50,333,5471.5631530000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-06-01"},{"$f":"SUM(B30:B42)","v":38561},19386,411,6539,563,3242,null,"2022-04-01",2624,1425,43,533,58,293,4829.560853]
["2022-07-01",3209,1769,42,543,53,271,5507.3383389999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-07-01"},{"$f":"SUM(B31:B43)","v":40149},20553,444,6811,584,3456,null,"2022-05-01",3003,1533,47,591,47,366,4777.5615299999999]
["2022-08-01",3601,1936,51,576,45,254,6116.3995269999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-08-01"},{"$f":"SUM(B32:B44)","v":41767},21916,486,7123,597,3646,null,"2022-06-01",2851,1480,53,511,50,333,4807.4264860000003]
["2022-09-01",3369,1906,29,618,49,228,5522.0920169999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-09-01"},{"$f":"SUM(B33:B45)","v":42093},23149,501,7469,620,3803,null,"2022-07-01",2981,1525,42,526,54,283,4909.1396809999997]
["2022-10-01",3332,1970,35,637,57,273,5643.0429670000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-10-01"},{"$f":"SUM(B34:B46)","v":41832},23944,509,7704,644,3898,null,"2022-08-01",3364,1640,51,563,45,262,5540.7254190000003]
["2022-11-01",3325,2008,40,598,67,281,5226.4136289999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-11-01"},{"$f":"SUM(B35:B47)","v":41645},24038,515,7664,650,3865,null,"2022-09-01",3260,1644,29,614,49,246,4830.3337389999997]
["2022-12-01",2295,1921,37,534,45,201,5676.6291039999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-12-01"},{"$f":"SUM(B36:B48)","v":40445},23896,516,7540,655,3742,null,"2022-10-01",3332,1970,35,637,57,273,5643.0429670000003]
["2023-01-01",3373,1788,28,576,55,267,6191.6449810000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-01-01"},{"$f":"SUM(B37:B49)","v":41344},23741,515,7554,674,3706,null,"2022-11-01",3322,2008,40,598,67,281,5226.4136289999997]
["2023-02-01",3298,1300,37,493,41,274,5775.4877370000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-02-01"},{"$f":"SUM(B38:B50)","v":41410},23249,530,7443,666,3649,null,"2022-12-01",2295,1921,37,534,45,201,5676.6291039999996]
["2023-03-01",3567,2193,35,675,60,331,5439.9285190000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-03-01"},{"$f":"SUM(B39:B51)","v":41794},24079,531,7642,678,3670,null,"2023-01-01",3372,1788,28,576,55,267,6191.6449810000004]
["2023-04-01",2733,1675,27,533,50,268,5937.0847759999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-04-01"},{"$f":"SUM(B40:B52)","v":41063},23780,504,7515,677,3642,null,"2023-02-01",3297,1300,37,493,41,274,5775.4877370000004]
["2023-05-01",3172,1807,36,547,53,272,5417.1234189999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-05-01"},{"$f":"SUM(B41:B53)","v":41455},23852,497,7501,672,3619,null,"2023-03-01",3568,2193,35,675,60,331,5439.9285190000001]
["2023-06-01",3448,1970,44,620,54,293,6128.1987710000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-06-01"},{"$f":"SUM(B42:B54)","v":41731},23959,494,7491,679,3546,null,"2023-04-01",2733,1675,27,533,50,268,5937.0847759999997]
["2023-07-01",3351,1960,34,642,62,265,5479.1475840000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-07-01"},{"$f":"SUM(B43:B55)","v":42073},24203,475,7592,691,3478,null,"2023-05-01",3172,1807,36,547,53,272,5417.1234189999996]
["2023-08-01",3397,1929,38,656,48,281,5596.6673300000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-08-01"},{"$f":"SUM(B44:B56)","v":42261},24363,471,7705,686,3488,null,"2023-06-01",3448,1970,44,620,54,293,6128.1987710000003]
["2023-09-01",3142,1973,42,614,54,287,6067.6850519999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-09-01"},{"$f":"SUM(B45:B57)","v":41802},24400,462,7743,695,3521,null,"2023-07-01",3351,1960,34,642,62,265,5479.1475840000003]
["2023-10-01",3323,1969,42,601,43,317,5802.9801889999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-10-01"},{"$f":"SUM(B46:B58)","v":41756},24463,475,7726,689,3610,null,"2023-08-01",3397,1929,38,656,48,281,5596.6673300000002]
["2023-11-01",3233,1998,41,591,56,329,5550.8857440000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-11-01"},{"$f":"SUM(B47:B59)","v":41657},24491,481,7680,688,3666,null,"2023-09-01",3142,1973,42,614,54,287,6067.6850519999998]
["2023-12-01",2259,1599,36,499,31,256,6038.1488669999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-12-01"},{"$f":"SUM(B48:B60)","v":40591},24082,477,7581,652,3641,null,"2023-10-01",3323,1969,42,601,43,317,5802.9801889999999]
["2024-01-01",3163,1885,43,590,49,299,5719.2117390000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-01-01"},{"$f":"SUM(B49:B61)","v":41459},24046,483,7637,656,3739,null,"2023-11-01",3233,1998,41,591,56,329,5550.8857440000002]
["2024-02-01",3055,1524,33,507,48,320,5574.1403749999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-02-01"},{"$f":"SUM(B50:B62)","v":41141},23782,488,7568,649,3792,null,"2023-12-01",2259,1599,36,499,31,256,6038.1488669999999]
["2024-03-01",2939,1716,40,528,43,265,6120.2103770000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-03-01"},{"$f":"SUM(B51:B63)","v":40782},24198,491,7603,651,3783,null,"2024-01-01",3163,1885,43,590,49,299,5719.2117390000003]
["2024-04-01",2984,1758,36,499,50,278,5887.2665459999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-04-01"},{"$f":"SUM(B52:B64)","v":40199},23763,492,7427,641,3730,null,"2024-02-01",3055,1524,33,507,48,320,5574.1403749999999]
["2024-05-01",2690,1801,32,474,52,222,6260.8445490000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-05-01"},{"$f":"SUM(B53:B65)","v":40156},23889,497,7368,643,3684,null,"2024-03-01",2939,1716,40,528,43,265,6120.2103770000003]
["2024-06-01",2647,1642,36,513,35,221,6529.5757910000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-06-01"},{"$f":"SUM(B54:B66)","v":39631},23724,497,7334,625,3633,null,"2024-04-01",2984,1758,36,499,50,278,5887.2665459999998]
["2024-07-01",3025,1814,47,601,45,275,6786.71029,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-07-01"},{"$f":"SUM(B55:B67)","v":39208},23568,500,7315,616,3615,null,"2024-05-01",2690,1801,32,474,52,222,6260.8445490000004]
["2024-08-01",2816,1599,43,497,42,214,6246.9163550000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-08-01"},{"$f":"SUM(B56:B68)","v":38673},23207,509,7170,596,3564,null,"2024-06-01",2647,1642,36,513,35,221,6529.5757910000002]
["2024-09-01",2990,1593,36,525,37,224,6373.1692849999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-09-01"},{"$f":"SUM(B57:B69)","v":38266},22871,507,7039,585,3507,null,"2024-07-01",3025,1814,47,601,45,275,6786.71029]
["2024-10-01",3148,1662,39,604,47,262,6704.6259920000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-10-01"},{"$f":"SUM(B58:B70)","v":38272},22560,504,7029,578,3482,null,"2024-08-01",2816,1599,43,497,42,214,6246.9163550000003]
["2024-11-01",2732,1560,21,548,52,266,6677.562293,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-11-01"},{"$f":"SUM(B59:B71)","v":37681},22151,483,6976,587,3431,null,"2024-09-01",2990,1593,36,525,37,224,6373.1692849999999]
["2024-12-01",2021,1373,30,445,51,207,6591.129758,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-12-01"},{"$f":"SUM(B60:B72)","v":36469},21526,472,6830,582,3309,null,"2024-10-01",3148,1662,39,604,47,262,6704.6259920000002]
["2025-01-01",2755,1408,37,495,45,275,6155.8921449999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2025-01-01"},{"$f":"SUM(B61:B73)","v":36965},21335,473,6826,596,3328,null,"2024-11-01",2732,1560,21,548,52,266,6677.562293]
["2025-02-01",2659,1021,29,475,39,236,8229.9276269999991,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2025-02-01"},{"$f":"SUM(B62:B74)","v":36461},20471,459,6711,586,3265,null,"2024-12-01",2021,1373,30,445,51,207,6591.129758]
["2025-03-01",2699,1309,25,518,44,291,6560.8502060000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2025-03-01"},{"$f":"SUM(B63:B75)","v":36105},20256,451,6722,582,3236,null,"2025-01-01",2755,1408,37,495,45,275,6155.8921449999998]
["2025-04-01",2278,1338,31,510,51,238,6604.0404200000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2025-04-01"},{"$f":"SUM(B64:B76)","v":35444},19878,442,6704,590,3209,null,"2025-02-01",2659,1021,29,475,39,236,8229.9276269999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-03-01",2699,1309,25,518,44,291,6560.8502060000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-01",2278,1338,31,510,51,238,6604.0404200000003]

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