{"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,134,null,"Left process at stage 1:",null,null,null,75,null,"Left process at stage 2:",null,null,null,8,null,"Exited process:",null,null,null,47,null,"Settled:",null,null,33]
[]
["Δ from last month:",null,null,-61,null,"Δ from last month:",null,null,null,-40,null,"Δ from last month:",null,null,null,-12,null,"Δ from last month:",null,null,null,1,null,"Δ from last month:",null,null,-7]
[]
["Rolling 12 months:",null,null,3386,null,"Rolling 12 months:",null,null,null,2864,null,"Rolling 12 months:",null,null,null,140,null,"Rolling 12 months:",null,null,null,718,null,"Rolling 12 months:",null,null,366]
[]
["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,70,null,97,null,-27]
["Other",null,null,null,null,null,null,5,null,17,null,-12]
["Total",null,null,null,null,null,null,75,null,114,null,-39]
["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,8,null,19,null,-11]
["Settlement pack timeout:",null,null,null,null,null,null,0,null,1,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,8,null,20,null,-12]

{"sheet":"Backing Sheet Data","index":1,"n_rows":82,"n_cols":22,"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,null,null,null,null,null,null,null,"* Figures refreshed 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,"Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages"]
["2024-04-01",10066,null,"2024-04-01",4188.2055549999995,null,null,70,5,0,8,0,0,null,"2019-01-01",439,207,1,162,1,24,3734.3850000000002]
["2024-05-01",9849,null,"2024-05-01",3973.1583780000001,null,null,null,null,null,null,null,null,null,"2019-02-01",469,150,4,131,0,29,4074.730689]
["2024-06-01",9532,null,"2024-06-01",3279.3459250000001,null,null,null,null,null,null,null,null,null,"2019-03-01",444,247,4,154,1,29,3890.4275859999998]
["2024-07-01",9156,null,"2024-07-01",4389.1000000000004,null,null,null,null,null,null,null,null,null,"2019-04-01",405,225,3,153,3,36,4254.035277]
["2024-08-01",8693,null,"2024-08-01",4914.230869,null,null,null,null,null,null,null,null,null,"2019-05-01",418,218,5,144,0,30,3973.95]
["2024-09-01",8183,null,"2024-09-01",3764.43,null,null,null,null,null,null,null,null,null,"2019-06-01",373,214,6,135,2,22,4900.1118180000003]
["2024-10-01",4975,null,"2024-10-01",4068.8685180000002,null,null,null,null,null,null,null,null,null,"2019-07-01",431,222,3,130,3,27,4078.7903700000002]
["2024-11-01",4707,null,"2024-11-01",5049.2662499999997,null,null,null,null,null,null,null,null,null,"2019-08-01",367,206,2,117,0,24,4280.0758329999999]
["2024-12-01",4349,null,"2024-12-01",4451.4795450000001,null,null,null,null,null,null,null,null,null,"2019-09-01",385,190,5,134,0,28,4135.5749999999998]
["2025-01-01",4362,null,"2025-01-01",3860.4839999999999,null,null,null,null,null,null,null,null,null,"2019-10-01",432,174,5,152,1,37,4641.1124319999999]
["2025-02-01",4065,null,"2025-02-01",3326.5720000000001,null,null,null,null,null,null,null,null,null,"2019-11-01",327,171,6,114,1,30,4546.5969999999998]
["2025-03-01",3822,null,"2025-03-01",3342.0079999999998,null,null,null,null,null,null,null,null,null,"2019-12-01",254,144,5,95,4,15,3946.0520000000001]
["2025-04-01",3386,null,"2025-04-01",4179.4518179999995,null,null,null,null,null,null,null,null,null,"2020-01-01",325,132,6,111,2,27,3777.607407]
[null,null,null,"Grand Total",52786.600857999998,null,null,null,null,null,null,null,null,null,"2020-02-01",364,114,1,97,0,29,5334.2286199999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-01",335,173,4,104,0,48,4100.90625]
[null,3628,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-01",380,141,1,113,2,50,4034.8254000000002]
["Exit Process Reason","Total",null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-01",230,122,7,92,0,38,4309.4368420000001]
["Claim requires further investigation",1610,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-01",265,171,5,102,0,51,4113.3231370000003]
["Other",1236,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-01",274,123,2,86,1,33,3784.4]
["Duplicated claim",320,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-01",160,104,1,69,0,20,4155.1270000000004]
["Withdrawl of claim",312,null,null,null,null,null,null,null,null,null,null,null,null,"2020-09-01",297,113,2,66,0,21,4429.1238089999997]
["Incomplete information provided on CNF",109,null,null,null,null,null,null,null,null,null,null,null,null,"2020-10-01",309,100,2,104,0,35,4108.0280000000002]
["Value of claim exceeds the upper limit",17,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-01",286,127,1,66,0,32,3741.734375]
["Stage 1 costs not paid on time",7,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-01",249,118,3,91,1,38,3454.5450000000001]
["Withdrawal of offer",6,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01",310,135,2,96,0,44,3490.159772]
["Failure to provide adequate loss of earnings details",5,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-01",161,81,1,53,0,45,3844.6666660000001]
["Claim is too complex for process",4,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-01",290,147,2,99,1,45,3700.4580000000001]
["Value of claim below £1,000",1,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01",302,132,4,87,0,29,3493.789655]
["Failure to acknowledge CNF on time",1,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01",240,129,1,84,0,44,3907.815681]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-01",258,190,1,69,1,17,4477.4264700000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01",411,154,2,65,0,35,3377.4214280000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-01",310,186,2,70,0,23,3008.734782]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01",322,187,9,88,0,56,3245.8401779999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-01",335,162,4,70,0,46,3487.3402169999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01",408,180,6,100,1,37,3714.3167560000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-01",252,194,4,90,0,31,3321.5448379999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01",360,192,5,92,0,63,3527.6668249999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-01",308,160,4,59,0,63,3380.2033329999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-01",416,223,5,71,0,36,4066.6277770000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",329,186,5,79,0,7,4384.6057140000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",394,246,4,76,1,36,3896.6563879999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01",487,210,7,70,1,19,3997.4878939999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",427,417,9,56,0,28,3584.5535709999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-01",492,332,9,63,0,25,4211.5339999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",392,236,8,73,1,33,4464.692121]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",447,298,3,71,0,36,3836.7750000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",495,257,3,86,1,29,5012.0768959999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",351,263,6,81,0,27,4076.1455550000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",501,317,8,71,0,55,3662.1283629999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",520,229,3,76,0,23,4206.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",533,352,10,120,0,34,3691.9579410000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",543,270,4,81,0,29,3567.6917239999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",614,226,12,98,0,64,3827.930781]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",640,456,4,95,0,49,3444.5510199999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01",695,425,6,126,0,40,3578.8139999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-01",1000,428,8,198,0,47,3724.1510629999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-01",3510,443,3,405,0,91,3420.8219779999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-01",423,1009,3,447,0,53,3354.6698110000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-01",468,1726,9,220,0,42,4025.8597610000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-01",211,336,3,49,0,73,3342.4386300000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01",451,260,11,45,0,33,3724.128181]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-02-01",438,294,8,74,0,69,3370.4334779999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-01",570,307,5,48,0,53,4630.9198109999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-04-01",503,536,7,43,1,18,4188.2055549999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-01",326,421,6,41,0,37,3973.1583780000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-06-01",297,258,7,81,0,27,3279.3459250000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-07-01",264,312,7,38,0,22,4389.1000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-08-01",232,157,8,46,0,23,4914.230869]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-09-01",490,165,14,47,0,35,3764.43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-01",302,307,8,38,0,27,4068.8685180000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-01",155,281,15,47,0,32,5049.2662499999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-01",110,103,8,33,0,22,4451.4795450000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01",224,74,12,173,0,25,3860.4839999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-02-01",154,60,19,38,0,25,3326.5720000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-03-01",195,115,20,46,0,40,3342.0079999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-01",134,75,8,47,0,33,4179.4518179999995]

{"sheet":"vELDDashboard","index":2,"n_rows":78,"n_cols":25,"rows_kept":78,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"SUBTOTAL(9,vELDDashboard[CNFs Sent])","v":23912},{"$f":"SUBTOTAL(9,vELDDashboard[CNFs left at Stage 1])","v":15056},{"$f":"SUBTOTAL(9,vELDDashboard[Stage 2 Exit])","v":345},{"$f":"SUBTOTAL(9,vELDDashboard[Exit process])","v":4921},{"$f":"SUBTOTAL(9,vELDDashboard[Court Pack])","v":8},{"$f":"SUBTOTAL(9,vELDDashboard[Settled claims])","v":1691},{"$f":"SUBTOTAL(9,vELDDashboard[General Damages])","v":321329.01313799998},null,null,null,null,null,null,null,null,null,"* Figures refreshed 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-10-01",175,83,2,63,0,7,9071.4285710000004,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2019-10-01"},null,null,null,null,null,null,null,"2019-01-01",439,207,1,162,1,24,3734.3850000000002]
["2019-11-01",153,78,4,52,0,2,9375,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2019-11-01"},null,null,null,null,null,null,null,"2019-02-01",469,150,4,131,0,29,4074.730689]
["2020-01-01",139,75,2,54,0,1,3625,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-01-01"},null,null,null,null,null,null,null,"2019-03-01",444,247,4,154,1,29,3890.4275859999998]
["2020-02-01",167,54,0,44,0,1,10000,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-02-01"},null,null,null,null,null,null,null,"2019-04-01",405,225,3,153,3,36,4254.035277]
["2020-03-01",147,79,3,56,0,2,6875,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-03-01"},null,null,null,null,null,null,null,"2019-05-01",418,218,5,144,0,30,3973.95]
["2020-04-01",145,72,0,48,1,2,6750,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-04-01"},null,null,null,null,null,null,null,"2019-06-01",373,214,6,135,2,22,4900.1118180000003]
["2020-05-01",86,76,3,36,0,2,9250,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-05-01"},null,null,null,null,null,null,null,"2019-07-01",431,222,3,130,3,27,4078.7903700000002]
["2020-06-01",133,68,0,36,0,4,10000,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-06-01"},null,null,null,null,null,null,null,"2019-08-01",367,206,2,117,0,24,4280.0758329999999]
["2020-07-01",109,67,0,34,0,1,3600,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-07-01"},null,null,null,null,null,null,null,"2019-09-01",385,190,5,134,0,28,4135.5749999999998]
["2020-09-01",126,56,0,25,0,1,10000,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-09-01"},null,null,null,null,null,null,null,"2019-10-01",432,174,5,152,1,37,4641.1124319999999]
["2020-10-01",133,45,0,39,0,3,8356.7999999999993,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-10-01"},null,null,null,null,null,null,null,"2019-11-01",327,171,6,114,1,30,4546.5969999999998]
["2020-11-01",162,59,0,30,0,2,6750,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-11-01"},{"$f":"SUM(B2:B14)","v":1675},812,14,517,1,28,null,"2019-12-01",254,144,5,95,4,15,3946.0520000000001]
["2020-12-01",122,71,0,53,1,3,2433.333333,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-12-01"},{"$f":"SUM(B3:B15)","v":1797},883,14,570,2,31,null,"2020-01-01",325,132,6,111,2,27,3777.607407]
["2021-01-01",119,86,0,41,0,3,3310.7333330000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-01-01"},{"$f":"SUM(B4:B16)","v":1741},886,12,548,2,27,null,"2020-02-01",364,114,1,97,0,29,5334.2286199999999]
["2021-02-01",126,37,2,28,0,2,5930,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-02-01"},{"$f":"SUM(B5:B17)","v":1714},845,10,524,2,27,null,"2020-03-01",335,173,4,104,0,48,4100.90625]
["2021-03-01",187,69,2,45,0,2,13795.2,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-03-01"},{"$f":"SUM(B6:B18)","v":1762},839,10,515,2,28,null,"2020-04-01",380,141,1,113,2,50,4034.8254000000002]
["2021-05-01",137,59,0,35,0,1,17013.87,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-05-01"},{"$f":"SUM(B7:B19)","v":1732},844,10,506,2,28,null,"2020-05-01",230,122,7,92,0,38,4309.4368420000001]
["2021-07-01",208,65,1,35,0,3,6416.6666660000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-07-01"},{"$f":"SUM(B8:B20)","v":1793},830,8,485,2,29,null,"2020-06-01",265,171,5,102,0,51,4113.3231370000003]
["2021-08-01",287,59,1,40,0,1,6500,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-08-01"},{"$f":"SUM(B9:B21)","v":1935},817,9,477,1,28,null,"2020-07-01",274,123,2,86,1,33,3784.4]
["2021-09-01",336,113,8,73,0,21,3171.77619,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-09-01"},{"$f":"SUM(B10:B22)","v":2185},854,14,514,1,47,null,"2020-08-01",160,104,1,69,0,20,4155.1270000000004]
["2021-10-01",359,172,4,71,0,46,3425.7836950000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-10-01"},{"$f":"SUM(B11:B23)","v":2411},958,18,549,1,89,null,"2020-09-01",297,113,2,66,0,21,4429.1238089999997]
["2021-11-01",429,196,6,109,1,37,3912.0886479999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-11-01"},{"$f":"SUM(B12:B24)","v":2731},1087,24,624,2,125,null,"2020-10-01",309,100,2,104,0,35,4108.0280000000002]
["2021-12-01",282,208,4,93,0,31,3562.2854830000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-12-01"},{"$f":"SUM(B13:B25)","v":2887},1239,28,692,2,155,null,"2020-11-01",286,127,1,66,0,32,3741.734375]
["2022-01-01",381,203,5,98,0,62,3547.1379029999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-01-01"},{"$f":"SUM(B14:B26)","v":3135},1397,33,751,2,214,null,"2020-12-01",249,118,3,91,1,38,3454.5450000000001]
["2022-02-01",327,169,4,62,0,60,3531.9576659999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-02-01"},{"$f":"SUM(B15:B27)","v":3300},1507,37,783,2,272,null,"2021-01-01",310,135,2,96,0,44,3490.159772]
["2022-03-01",448,239,5,71,0,32,4654.5253119999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-03-01"},{"$f":"SUM(B16:B28)","v":3626},1675,42,801,1,301,null,"2021-02-01",161,81,1,53,0,45,3844.6666660000001]
["2022-04-01",360,203,5,82,0,7,4386.0342849999997,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-04-01"},{"$f":"SUM(B17:B29)","v":3867},1792,47,842,1,305,null,"2021-03-01",290,147,2,99,1,45,3700.4580000000001]
["2022-05-01",503,266,4,83,1,35,3951.7114280000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-05-01"},{"$f":"SUM(B18:B30)","v":4244},2021,49,897,2,338,null,"2021-04-01",302,132,4,87,0,29,3493.789655]
["2022-06-01",463,224,7,75,1,19,4170.3189469999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-06-01"},{"$f":"SUM(B19:B31)","v":4520},2176,54,927,3,355,null,"2021-05-01",240,129,1,84,0,44,3907.815681]
["2022-07-01",452,426,8,61,0,27,3708.0555549999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-07-01"},{"$f":"SUM(B20:B32)","v":4835},2543,62,953,3,381,null,"2021-06-01",258,190,1,69,1,17,4477.4264700000003]
["2022-08-01",505,362,9,66,0,25,4221.5339999999997,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-08-01"},{"$f":"SUM(B21:B33)","v":5132},2840,70,984,3,403,null,"2021-07-01",411,154,2,65,0,35,3377.4214280000001]
["2022-09-01",409,257,8,74,1,33,4747.8772719999997,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-09-01"},{"$f":"SUM(B22:B34)","v":5254},3038,77,1018,4,435,null,"2021-08-01",310,186,2,70,0,23,3008.734782]
["2022-10-01",447,298,3,71,0,36,3836.7750000000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-10-01"},{"$f":"SUM(B23:B35)","v":5365},3223,72,1016,4,450,null,"2021-09-01",322,187,9,88,0,56,3245.8401779999999]
["2022-11-01",495,257,3,86,1,29,5012.0768959999996,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-11-01"},{"$f":"SUM(B24:B36)","v":5501},3308,71,1031,5,433,null,"2021-10-01",335,162,4,70,0,46,3487.3402169999999]
["2022-12-01",351,263,6,81,0,27,4076.1455550000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-12-01"},{"$f":"SUM(B25:B37)","v":5423},3375,71,1003,4,423,null,"2021-11-01",408,180,6,100,1,37,3714.3167560000002]
["2023-01-01",501,317,8,71,0,55,3662.1283629999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-01-01"},{"$f":"SUM(B26:B38)","v":5642},3484,75,981,4,447,null,"2021-12-01",252,194,4,90,0,31,3321.5448379999998]
["2023-02-01",521,229,3,76,0,23,4206.8,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-02-01"},{"$f":"SUM(B27:B39)","v":5782},3510,73,959,4,408,null,"2022-01-01",360,192,5,92,0,63,3527.6668249999998]
["2023-03-01",533,352,10,120,0,34,3691.9579410000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-03-01"},{"$f":"SUM(B28:B40)","v":5988},3693,79,1017,4,382,null,"2022-02-01",308,160,4,59,0,63,3380.2033329999999]
["2023-04-01",543,270,4,81,0,29,3567.6917239999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-04-01"},{"$f":"SUM(B29:B41)","v":6083},3724,78,1027,4,379,null,"2022-03-01",416,223,5,71,0,36,4066.6277770000002]
["2023-05-01",614,226,12,98,0,64,3827.930781,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-05-01"},{"$f":"SUM(B30:B42)","v":6337},3747,85,1043,4,436,null,"2022-04-01",329,186,5,79,0,7,4384.6057140000003]
["2023-06-01",640,456,4,95,0,49,3444.5510199999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-06-01"},{"$f":"SUM(B31:B43)","v":6474},3937,85,1055,3,450,null,"2022-05-01",394,246,4,76,1,36,3896.6563879999999]
["2023-07-01",695,425,6,126,0,40,3578.8139999999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-07-01"},{"$f":"SUM(B32:B44)","v":6706},4138,84,1106,2,471,null,"2022-06-01",487,210,7,70,1,19,3997.4878939999999]
["2023-08-01",1000,428,8,198,0,47,3724.1510629999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-08-01"},{"$f":"SUM(B33:B45)","v":7254},4140,84,1243,2,491,null,"2022-07-01",427,417,9,56,0,28,3584.5535709999999]
["2023-09-01",3510,443,3,405,0,91,3420.8219779999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-09-01"},{"$f":"SUM(B34:B46)","v":10259},4221,78,1582,2,557,null,"2022-08-01",492,332,9,63,0,25,4211.5339999999997]
["2023-10-01",423,1009,3,447,0,53,3354.6698110000002,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-10-01"},{"$f":"SUM(B35:B47)","v":10273},4973,73,1955,1,577,null,"2022-09-01",392,236,8,73,1,33,4464.692121]
["2023-11-01",468,1726,9,220,0,42,4025.8597610000002,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-11-01"},{"$f":"SUM(B36:B48)","v":10294},6401,79,2104,1,583,null,"2022-10-01",447,298,3,71,0,36,3836.7750000000001]
["2023-12-01",211,336,3,49,0,73,3342.4386300000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-12-01"},{"$f":"SUM(B37:B49)","v":10010},6480,79,2067,0,627,null,"2022-11-01",495,257,3,86,1,29,5012.0768959999996]
["2024-01-01",451,260,11,45,0,33,3724.128181,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-01-01"},{"$f":"SUM(B38:B50)","v":10110},6477,84,2031,0,633,null,"2022-12-01",351,263,6,81,0,27,4076.1455550000001]
["2024-02-01",438,294,8,74,0,69,3370.4334779999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-02-01"},{"$f":"SUM(B39:B51)","v":10047},6454,84,2034,0,647,null,"2023-01-01",501,317,8,71,0,55,3662.1283629999998]
["2024-03-01",570,307,5,48,0,53,4630.9198109999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-03-01"},{"$f":"SUM(B40:B52)","v":10096},6532,86,2006,0,677,null,"2023-02-01",520,229,3,76,0,23,4206.8]
["2024-04-01",503,536,7,43,1,18,4188.2055549999995,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-04-01"},{"$f":"SUM(B41:B53)","v":10066},6716,83,1929,1,661,null,"2023-03-01",533,352,10,120,0,34,3691.9579410000001]
["2024-05-01",326,421,6,41,0,37,3973.1583780000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-05-01"},{"$f":"SUM(B42:B54)","v":9849},6867,85,1889,1,669,null,"2023-04-01",543,270,4,81,0,29,3567.6917239999998]
["2024-06-01",297,258,7,81,0,27,3279.3459250000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-06-01"},{"$f":"SUM(B43:B55)","v":9532},6899,80,1872,1,632,null,"2023-05-01",614,226,12,98,0,64,3827.930781]
["2024-07-01",264,312,7,38,0,22,4389.1000000000004,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-07-01"},{"$f":"SUM(B44:B56)","v":9156},6755,83,1815,1,605,null,"2023-06-01",640,456,4,95,0,49,3444.5510199999999]
["2024-08-01",232,157,8,46,0,23,4914.230869,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-08-01"},{"$f":"SUM(B45:B57)","v":8693},6487,85,1735,1,588,null,"2023-07-01",695,425,6,126,0,40,3578.8139999999999]
["2024-09-01",490,165,14,47,0,35,3764.43,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-09-01"},{"$f":"SUM(B46:B58)","v":8183},6224,91,1584,1,576,null,"2023-08-01",1000,428,8,198,0,47,3724.1510629999998]
["2024-10-01",302,307,8,38,0,27,4068.8685180000002,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-10-01"},{"$f":"SUM(B47:B59)","v":4975},6088,96,1217,1,512,null,"2023-09-01",3510,443,3,405,0,91,3420.8219779999999]
["2024-11-01",155,281,15,47,0,32,5049.2662499999997,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-11-01"},{"$f":"SUM(B48:B60)","v":4707},5360,108,817,1,491,null,"2023-10-01",423,1009,3,447,0,53,3354.6698110000002]
["2024-12-01",110,103,8,33,0,22,4451.4795450000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-12-01"},{"$f":"SUM(B49:B61)","v":4349},3737,107,630,1,471,null,"2023-11-01",468,1726,9,220,0,42,4025.8597610000002]
["2025-01-01",224,74,12,173,0,25,3860.4839999999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2025-01-01"},{"$f":"SUM(B50:B62)","v":4362},3475,116,754,1,423,null,"2023-12-01",211,336,3,49,0,73,3342.4386300000001]
["2025-02-01",154,60,19,38,0,25,3326.5720000000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2025-02-01"},{"$f":"SUM(B51:B63)","v":4065},3275,124,747,1,415,null,"2024-01-01",451,260,11,45,0,33,3724.128181]
["2025-03-01",195,115,20,46,0,40,3342.0079999999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2025-03-01"},{"$f":"SUM(B52:B64)","v":3822},3096,136,719,1,386,null,"2024-02-01",438,294,8,74,0,69,3370.4334779999999]
["2025-04-01",134,75,8,47,0,33,4179.4518179999995,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2025-04-01"},{"$f":"SUM(B53:B65)","v":3386},2864,139,718,1,366,null,"2024-03-01",570,307,5,48,0,53,4630.9198109999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-04-01",503,536,7,43,1,18,4188.2055549999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-01",326,421,6,41,0,37,3973.1583780000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-06-01",297,258,7,81,0,27,3279.3459250000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-07-01",264,312,7,38,0,22,4389.1000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-08-01",232,157,8,46,0,23,4914.230869]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-09-01",490,165,14,47,0,35,3764.43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-01",302,307,8,38,0,27,4068.8685180000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-01",155,281,15,47,0,32,5049.2662499999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-01",110,103,8,33,0,22,4451.4795450000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01",224,74,12,173,0,25,3860.4839999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-02-01",154,60,19,38,0,25,3326.5720000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-03-01",195,115,20,46,0,40,3342.0079999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-01",134,75,8,47,0,33,4179.4518179999995]

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