{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Backing Sheet Data","vELDashboard","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,1838,null,"Left process at stage 1:",null,null,null,878,null,"Left process at stage 2:",null,null,null,64,null,"Exited process:",null,null,null,463,null,"Settled:",null,null,265]
[]
["Δ from last month:",null,null,-163,null,"Δ from last month:",null,null,null,-20,null,"Δ from last month:",null,null,null,-6,null,"Δ from last month:",null,null,null,-29,null,"Δ from last month:",null,null,-30]
[]
["Rolling 12 months:",null,null,25866,null,"Rolling 12 months:",null,null,null,12691,null,"Rolling 12 months:",null,null,null,870,null,"Rolling 12 months:",null,null,null,5978,null,"Rolling 12 months:",null,null,3919]
[]
["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,729,null,754,null,-25]
["Other",null,null,null,null,null,null,146,null,138,null,8]
["Total",null,null,null,null,null,null,875,null,892,null,-17]
["Left Process Breakdowns - Stage 2:"]
[]
["Reason",null,null,null,null,null,null,"This Month",null,"Last Month",null,"Δ"]
["Interim payment more than £1,000 not agreed:",null,null,null,null,null,null,0,null,0,null,0]
["Settlement pack repudiated:",null,null,null,null,null,null,1,null,0,null,1]
["Settlement pack timeout:",null,null,null,null,null,null,30,null,26,null,4]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,39,null,24,null,15]
["Total",null,null,null,null,null,null,70,null,50,null,20]

{"sheet":"Backing Sheet Data","index":1,"n_rows":74,"n_cols":24,"rows_kept":74,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2025-04-01"]
["Previous month","2025-03-01"]
[]
["Rolling 13 CNFs sent",null,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,null,null,"* Oct 22 to Aug 24 fully refreshed - 19/09/2024"]
["Period","Rolling 12 Sent",null,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",30184,null,null,"2024-04-01",6309.8623820000003,null,null,729,146,1,1,20,42,null,null,"2020-01-01",3421,1776,42,860,97,635,4307.3684880000001]
["2024-05-01",30040,null,null,"2024-05-01",6785.6025239999999,null,null,null,null,null,null,null,null,null,null,"2020-02-01",4027,1499,55,945,96,710,4367.018]
["2024-06-01",29760,null,null,"2024-06-01",6452.0281150000001,null,null,null,null,null,null,null,null,null,null,"2020-03-01",3796,1554,52,895,87,703,4512.4282499999999]
["2024-07-01",29450,null,null,"2024-07-01",6551.4416899999997,null,null,null,null,null,null,null,null,null,null,"2020-04-01",2719,1520,59,790,74,542,4269.6721580000003]
["2024-08-01",29001,null,null,"2024-08-01",6180.3925650000001,null,null,null,null,null,null,null,null,null,null,"2020-05-01",3673,1611,54,948,106,616,4432.8075319999998]
["2024-09-01",28528,null,null,"2024-09-01",7052.7278230000002,null,null,null,null,null,null,null,null,null,null,"2020-06-01",3658,1148,41,688,75,616,4438.7770119999996]
["2024-10-01",28284,null,null,"2024-10-01",6795.4435110000004,null,null,null,null,null,null,null,null,null,null,"2020-07-01",3424,1662,61,866,90,650,4519.3539689999998]
["2024-11-01",27665,null,null,"2024-11-01",7163.4208470000003,null,null,null,null,null,null,null,null,null,null,"2020-08-01",2207,1490,50,853,83,563,4459.2569439999997]
["2024-12-01",26609,null,null,"2024-12-01",7259.5780999999997,null,null,null,null,null,null,null,null,null,null,"2020-09-01",1650,1065,39,549,54,448,4698.7195529999999]
["2025-01-01",27083,null,null,"2025-01-01",6798.9540630000001,null,null,null,null,null,null,null,null,null,null,"2020-10-01",1976,846,36,524,72,468,4892.8720940000003]
["2025-02-01",26589,null,null,"2025-02-01",6751.6031590000002,null,null,null,null,null,null,null,null,null,null,"2020-11-01",2293,819,41,535,57,374,4706.51901]
["2025-03-01",26318,null,null,"2025-03-01",7203.2738300000001,null,null,null,null,null,null,null,null,null,null,"2020-12-01",1846,798,30,427,44,254,4394.581338]
["2025-04-01",25866,null,null,"2025-04-01",6889.6614330000002,null,null,null,null,null,null,null,null,null,null,"2021-01-01",2625,982,33,536,63,401,4991.5419949999996]
[null,null,null,null,"Grand Total",88193.990042000019,null,null,null,null,null,null,null,null,null,null,"2021-02-01",2670,1134,26,659,40,417,4906.4452030000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-01",2230,1112,28,638,44,406,4773.7204179999999]
[null,19138,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01",1977,980,37,531,45,364,4694.4902739999998]
["Exit Process Reason","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01",2223,992,26,584,44,383,4551.4091900000003]
["Claim requires further investigation",9769,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-01",1502,614,23,380,25,343,4719.332332]
["Other",6754,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01",2276,1164,37,637,63,451,4852.8321059999998]
["Value of claim exceeds the upper limit",694,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-01",2315,993,45,597,57,414,4846.5958689999998]
["Duplicated claim",618,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01",2199,928,26,577,40,347,4774.8293940000003]
["Failure to provide adequate loss of earnings details",447,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-01",2288,1016,35,561,46,384,4795.169218]
["Incomplete information provided on CNF",412,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01",2442,992,37,567,54,378,4960.9055820000003]
["Stage 1 costs not paid on time",168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-01",2419,994,31,595,40,359,4906.8961550000004]
["Claim is too complex for process",85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01",2617,1055,35,629,39,361,4801.2036280000002]
["Interim Payment request not answered and/or paid on time",63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-01",2456,1019,36,640,38,371,4718.2532879999999]
["Withdrawl of claim",57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-01",2609,1126,43,713,45,426,5028.1605630000004]
["Withdrawal of offer",28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",1952,1039,38,577,35,351,5112.0429620000004]
["Value of claim below £1,000",21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",2383,1000,24,539,39,365,4867.4547670000002]
["Failure to acknowledge CNF on time",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01",2396,801,32,521,43,346,4871.2523119999996]
["Interim Payment partial offer not accepted",9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",2699,1208,45,717,60,412,4734.9004850000001]
["Interim payment for child claimant",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-01",2101,948,42,561,47,336,4962.1931539999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",2418,1044,32,604,51,406,5118.0826100000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",2337,1012,53,508,40,383,5258.2505739999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",2257,1080,37,543,42,334,4974.6811369999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",2344,1096,37,572,54,366,5004.8880319999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",2374,1100,36,599,44,360,4797.1745270000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",2508,1172,44,601,42,352,6018.6199139999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",2631,1220,43,644,44,331,5926.2720239999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",1665,1126,39,544,34,259,6090.6437059999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",2542,1050,29,557,54,300,5993.902666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",2355,924,38,444,32,329,5616.0563220000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",2656,1336,43,663,37,391,6164.7616619999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",2150,976,28,430,39,304,6227.3018419999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",2214,1178,35,543,47,342,5656.8131869999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",2559,1245,48,529,52,370,6100.508135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01",2469,1161,37,589,55,349,6158.3314039999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-01",2448,1340,27,632,52,320,6244.5804369999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-01",2367,1151,34,625,47,292,6106.2393490000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-01",2492,1193,50,546,42,337,5998.7167650000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-01",2525,1288,35,675,22,367,6175.6552579999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-01",1617,1117,32,474,29,286,6782.117937]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01",2497,1151,26,544,39,343,5727.4956849999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-02-01",2272,1018,26,454,31,370,6175.213135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-01",2290,1171,33,461,27,353,6227.1839369999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-04-01",2284,1112,18,481,32,319,6309.8623820000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-01",2006,1180,31,479,24,309,6785.6025239999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-06-01",1934,1119,43,429,37,313,6452.0281150000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-07-01",2249,1169,45,495,35,343,6551.4416899999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-08-01",2020,1015,30,443,36,269,6180.3925650000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-09-01",1975,984,38,502,30,294,7052.7278230000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-01",2123,1030,30,459,47,356,6795.4435110000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-01",1873,903,39,488,45,295,7163.4208470000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-01",1469,835,38,406,28,258,7259.5780999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01",2091,899,18,455,42,315,6798.9540630000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-02-01",2003,669,26,386,24,288,6751.6031590000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-03-01",2001,898,31,492,39,295,7203.2738300000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-01",1838,878,22,463,42,265,6889.6614330000002]

{"sheet":"vELDashboard","index":2,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"SUBTOTAL(9,vELDashboard[CNFs Sent])","v":132190},{"$f":"SUBTOTAL(9,vELDashboard[CNFs left at Stage 1])","v":58972},{"$f":"SUBTOTAL(9,vELDashboard[Stage 2 Exit])","v":1859},{"$f":"SUBTOTAL(9,vELDashboard[Exit process])","v":29828},{"$f":"SUBTOTAL(9,vELDashboard[Court Pack])","v":2393},{"$f":"SUBTOTAL(9,vELDashboard[Settled claims])","v":16221},{"$f":"SUBTOTAL(9,vELDashboard[General Damages])","v":397297.46984899999},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-09-01",1300,5,0,13,2,3,3190.5433330000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2019-09-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2019-09-01"},3421,1776,42,860,97,635,4307.3684880000001]
["2019-10-01",1629,538,19,292,40,57,4776.9019289999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2019-10-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2019-10-01"},4027,1499,55,945,96,710,4367.018]
["2019-11-01",1537,619,15,332,32,73,5369.233698,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2019-11-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2019-11-01"},3796,1554,52,895,87,703,4512.4282499999999]
["2019-12-01",1109,551,21,298,32,87,5126.8812639999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2019-12-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2019-12-01"},2719,1520,59,790,74,542,4269.6721580000003]
["2020-01-01",1557,572,15,388,44,93,4997.6190319999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-01-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-01-01"},3673,1611,54,948,106,616,4432.8075319999998]
["2020-02-01",1586,434,18,253,30,68,4884.762941,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-02-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-02-01"},3658,1148,41,688,75,616,4438.7770119999996]
["2020-03-01",1487,682,21,375,42,84,5241.1844039999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-03-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-03-01"},3424,1662,61,866,90,650,4519.3539689999998]
["2020-04-01",889,571,17,343,34,86,5054.3882549999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-04-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-04-01"},2207,1490,50,853,83,563,4459.2569439999997]
["2020-05-01",729,410,21,218,25,81,4704.5046910000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-05-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-05-01"},1650,1065,39,549,54,448,4698.7195529999999]
["2020-06-01",899,309,14,228,41,80,6191.9965000000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-06-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-06-01"},1976,846,36,524,72,468,4892.8720940000003]
["2020-07-01",1151,355,11,199,24,59,4966.8201689999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-07-01"},null,null,null,null,null,null,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-07-01"},2293,819,41,535,57,374,4706.51901]
["2020-08-01",1036,324,11,201,25,60,4618.4790000000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-08-01"},{"$f":"SUM(B2:B14)","v":14909},5370,183,3140,371,{"$f":"SUM(G2:G14)","v":831},null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-08-01"},1846,798,30,427,44,254,4394.581338]
["2020-09-01",1274,416,11,209,25,77,5428.2861030000004,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-09-01"},{"$f":"SUM(B3:B15)","v":16183},5786,194,3349,396,908,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-09-01"},2625,982,33,536,63,401,4991.5419949999996]
["2020-10-01",1296,434,11,268,20,81,5398.4419749999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-10-01"},{"$f":"SUM(B4:B16)","v":16179},6215,205,3604,414,986,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-10-01"},2670,1134,26,659,40,417,4906.4452030000002]
["2020-11-01",1169,445,12,280,28,80,5099.4750000000004,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-11-01"},{"$f":"SUM(B5:B17)","v":15719},6122,198,3592,402,1009,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-11-01"},2230,1112,28,638,44,406,4773.7204179999999]
["2020-12-01",1044,410,15,237,28,95,6195.7948420000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-12-01"},{"$f":"SUM(B6:B18)","v":15226},5913,198,3497,398,1031,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-12-01"},1977,980,37,531,45,364,4694.4902739999998]
["2021-01-01",1221,421,8,240,19,69,4869.9821730000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-01-01"},{"$f":"SUM(B7:B19)","v":15338},5783,185,3439,385,1013,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-01-01"},2223,992,26,584,44,383,4551.4091900000003]
["2021-02-01",1316,321,14,189,17,83,5544.0773490000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-02-01"},{"$f":"SUM(B8:B20)","v":15097},5532,184,3240,358,1003,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-02-01"},1502,614,23,380,25,343,4719.332332]
["2021-03-01",1512,509,9,279,26,104,5215.2191339999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-03-01"},{"$f":"SUM(B9:B21)","v":15023},5607,175,3266,354,1039,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-03-01"},2276,1164,37,637,63,451,4852.8321059999998]
["2021-04-01",1396,391,19,260,29,83,5573.9045779999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-04-01"},{"$f":"SUM(B10:B22)","v":14932},5316,173,3151,341,1038,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-04-01"},2315,993,45,597,57,414,4846.5958689999998]
["2021-05-01",1338,415,13,266,23,76,5065.9223679999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-05-01"},{"$f":"SUM(B11:B23)","v":15381},5160,169,3074,330,1028,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-05-01"},2199,928,26,577,40,347,4774.8293940000003]
["2021-06-01",1426,481,14,283,19,72,5751.5479160000004,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-06-01"},{"$f":"SUM(B12:B24)","v":16078},5231,162,3139,324,1019,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-06-01"},2288,1016,35,561,46,384,4795.169218]
["2021-07-01",1473,456,13,258,18,68,5529.2,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-07-01"},{"$f":"SUM(B13:B25)","v":16652},5378,161,3169,301,1007,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-07-01"},2442,992,37,567,54,378,4960.9055820000003]
["2021-08-01",2214,439,9,275,15,90,5745.5044440000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-08-01"},{"$f":"SUM(B14:B26)","v":17715},5462,159,3245,292,1038,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-08-01"},2419,994,31,595,40,359,4906.8961550000004]
["2021-09-01",2698,810,19,453,35,181,5531.3746959999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-09-01"},{"$f":"SUM(B15:B27)","v":19377},5948,167,3497,302,1159,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-09-01"},2617,1055,35,629,39,361,4801.2036280000002]
["2021-10-01",2585,1182,36,664,38,370,5405.343108,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-10-01"},{"$f":"SUM(B16:B28)","v":20688},6714,192,3952,315,1452,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-10-01"},2456,1019,36,640,38,371,4718.2532879999999]
["2021-11-01",2695,1279,43,734,45,425,5992.2169880000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-11-01"},{"$f":"SUM(B17:B29)","v":22087},7559,224,4418,340,1796,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-11-01"},2609,1126,43,713,45,426,5028.1605630000004]
["2021-12-01",2048,1206,38,600,35,349,5779.9341539999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-12-01"},{"$f":"SUM(B18:B30)","v":22966},8320,250,4738,347,2065,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-12-01"},1952,1039,38,577,35,351,5112.0429620000004]
["2022-01-01",2551,1121,24,549,39,354,5752.7405639999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-01-01"},{"$f":"SUM(B19:B31)","v":24473},9031,259,5050,358,2324,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-01-01"},2383,1000,24,539,39,365,4867.4547670000002]
["2022-02-01",2440,899,32,527,43,339,5757.1570199999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-02-01"},{"$f":"SUM(B20:B32)","v":25692},9509,283,5337,382,2594,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-02-01"},2396,801,32,521,43,346,4871.2523119999996]
["2022-03-01",2845,1265,43,684,60,349,5552.4851280000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-03-01"},{"$f":"SUM(B21:B33)","v":27221},10453,312,5832,425,2860,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-03-01"},2699,1208,45,717,60,412,4734.9004850000001]
["2022-04-01",2207,1104,42,577,47,337,6008.58997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-04-01"},{"$f":"SUM(B22:B34)","v":27916},11048,345,6130,446,3093,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-04-01"},2101,948,42,561,47,336,4962.1931539999996]
["2022-05-01",2555,1200,32,632,51,406,5887.3834969999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-05-01"},{"$f":"SUM(B23:B35)","v":29075},11857,358,6502,468,3416,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-05-01"},2418,1044,32,604,51,406,5118.0826100000004]
["2022-06-01",2459,1172,53,540,40,382,6153.5853660000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-06-01"},{"$f":"SUM(B24:B36)","v":30196},12614,398,6776,485,3722,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-06-01"},2337,1012,53,508,40,383,5258.2505739999997]
["2022-07-01",2369,1243,37,557,40,320,5775.7481870000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-07-01"},{"$f":"SUM(B25:B37)","v":31139},13376,421,7050,506,3970,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-07-01"},2257,1080,37,543,42,334,4974.6811369999996]
["2022-08-01",2499,1244,37,592,53,351,5794.456666,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-08-01"},{"$f":"SUM(B26:B38)","v":32165},14164,445,7384,541,4253,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-08-01"},2344,1096,37,572,54,366,5004.8880319999998]
["2022-09-01",2527,1231,36,602,43,335,5781.38,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-09-01"},{"$f":"SUM(B27:B39)","v":32478},14956,472,7711,569,4498,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-09-01"},2374,1100,36,599,44,360,4797.1745270000001]
["2022-10-01",2508,1172,44,601,42,352,6018.6199139999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-10-01"},{"$f":"SUM(B28:B40)","v":32288},15318,497,7859,576,4669,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-10-01"},2508,1172,44,601,42,352,6018.6199139999999]
["2022-11-01",2631,1220,43,644,44,331,5926.2720239999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-11-01"},{"$f":"SUM(B29:B41)","v":32334},15356,504,7839,582,4630,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-11-01"},2631,1220,43,644,44,331,5926.2720239999999]
["2022-12-01",1666,1126,39,544,34,259,6090.6437059999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-12-01"},{"$f":"SUM(B30:B42)","v":31305},15203,500,7649,571,4464,null,"2022-12-01",1665,1126,39,544,34,259,6090.6437059999998]
["2023-01-01",2542,1050,29,557,54,300,5993.902666,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-01-01"},{"$f":"SUM(B31:B43)","v":31799},15047,491,7606,590,4415,null,"2023-01-01",2542,1050,29,557,54,300,5993.902666]
["2023-02-01",2355,924,38,444,32,329,5616.0563220000004,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-02-01"},{"$f":"SUM(B32:B44)","v":31603},14850,505,7501,583,4390,null,"2023-02-01",2355,924,38,444,32,329,5616.0563220000004]
["2023-03-01",2656,1336,43,663,37,391,6164.7616619999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-03-01"},{"$f":"SUM(B33:B45)","v":31819},15287,516,7637,577,4442,null,"2023-03-01",2656,1336,43,663,37,391,6164.7616619999999]
["2023-04-01",2150,976,28,430,39,304,6227.3018419999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-04-01"},{"$f":"SUM(B34:B46)","v":31124},14998,501,7383,556,4397,null,"2023-04-01",2150,976,28,430,39,304,6227.3018419999999]
["2023-05-01",2214,1178,35,543,47,342,5656.8131869999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-05-01"},{"$f":"SUM(B35:B47)","v":31131},15072,494,7349,556,4402,null,"2023-05-01",2214,1178,35,543,47,342,5656.8131869999997]
["2023-06-01",2559,1245,48,529,52,370,6100.508135,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-06-01"},{"$f":"SUM(B36:B48)","v":31135},15117,510,7246,557,4366,null,"2023-06-01",2559,1245,48,529,52,370,6100.508135]
["2023-07-01",2469,1161,37,589,55,349,6158.3314039999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-07-01"},{"$f":"SUM(B37:B49)","v":31145},15106,494,7295,572,4333,null,"2023-07-01",2469,1161,37,589,55,349,6158.3314039999996]
["2023-08-01",2448,1340,27,632,52,320,6244.5804369999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-08-01"},{"$f":"SUM(B38:B50)","v":31224},15203,484,7370,584,4333,null,"2023-08-01",2448,1340,27,632,52,320,6244.5804369999996]
["2023-09-01",2367,1151,34,625,47,292,6106.2393490000004,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-09-01"},{"$f":"SUM(B39:B51)","v":31092},15110,481,7403,578,4274,null,"2023-09-01",2367,1151,34,625,47,292,6106.2393490000004]
["2023-10-01",2492,1193,50,546,42,337,5998.7167650000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-10-01"},{"$f":"SUM(B40:B52)","v":31057},15072,495,7347,577,4276,null,"2023-10-01",2492,1193,50,546,42,337,5998.7167650000001]
["2023-11-01",2525,1288,35,675,22,367,6175.6552579999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-11-01"},{"$f":"SUM(B41:B53)","v":31074},15188,486,7421,557,4291,null,"2023-11-01",2525,1288,35,675,22,367,6175.6552579999998]
["2023-12-01",1617,1117,32,474,29,286,6782.117937,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-12-01"},{"$f":"SUM(B42:B54)","v":30060},15085,475,7251,542,4246,null,"2023-12-01",1617,1117,32,474,29,286,6782.117937]
["2024-01-01",2497,1151,26,544,39,343,5727.4956849999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-01-01"},{"$f":"SUM(B43:B55)","v":30891},15110,462,7251,547,4330,null,"2024-01-01",2497,1151,26,544,39,343,5727.4956849999999]
["2024-02-01",2272,1018,26,454,31,370,6175.213135,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-02-01"},{"$f":"SUM(B44:B56)","v":30621},15078,459,7148,524,4400,null,"2024-02-01",2272,1018,26,454,31,370,6175.213135]
["2024-03-01",2290,1171,33,461,27,353,6227.1839369999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-03-01"},{"$f":"SUM(B45:B57)","v":30556},15325,454,7165,519,4424,null,"2024-03-01",2290,1171,33,461,27,353,6227.1839369999998]
["2024-04-01",2284,1112,18,481,32,319,6309.8623820000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-04-01"},{"$f":"SUM(B46:B58)","v":30184},15101,429,6983,514,4352,null,"2024-04-01",2284,1112,18,481,32,319,6309.8623820000003]
["2024-05-01",2006,1180,31,479,24,309,6785.6025239999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-05-01"},{"$f":"SUM(B47:B59)","v":30040},15305,432,7032,499,4357,null,"2024-05-01",2006,1180,31,479,24,309,6785.6025239999999]
["2024-06-01",1934,1119,43,429,37,313,6452.0281150000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-06-01"},{"$f":"SUM(B48:B60)","v":29760},15246,440,6918,489,4328,null,"2024-06-01",1934,1119,43,429,37,313,6452.0281150000001]
["2024-07-01",2249,1169,45,495,35,343,6551.4416899999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-07-01"},{"$f":"SUM(B49:B61)","v":29450},15170,437,6884,472,4301,null,"2024-07-01",2249,1169,45,495,35,343,6551.4416899999997]
["2024-08-01",2020,1015,30,443,36,269,6180.3925650000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-08-01"},{"$f":"SUM(B50:B62)","v":29001},15024,430,6738,453,4221,null,"2024-08-01",2020,1015,30,443,36,269,6180.3925650000001]
["2024-09-01",1975,984,38,502,30,294,7052.7278230000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-09-01"},{"$f":"SUM(B51:B63)","v":28528},14668,441,6608,431,4195,null,"2024-09-01",1975,984,38,502,30,294,7052.7278230000002]
["2024-10-01",2123,1030,30,459,47,356,6795.4435110000004,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-10-01"},{"$f":"SUM(B52:B64)","v":28284},14547,437,6442,431,4259,null,"2024-10-01",2123,1030,30,459,47,356,6795.4435110000004]
["2024-11-01",1873,903,39,488,45,295,7163.4208470000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-11-01"},{"$f":"SUM(B53:B65)","v":27665},14257,426,6384,434,4217,null,"2024-11-01",1873,903,39,488,45,295,7163.4208470000003]
["2024-12-01",1469,835,38,406,28,258,7259.5780999999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-12-01"},{"$f":"SUM(B54:B66)","v":26609},13804,429,6115,440,4108,null,"2024-12-01",1469,835,38,406,28,258,7259.5780999999997]
["2025-01-01",2091,899,18,455,42,315,6798.9540630000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2025-01-01"},{"$f":"SUM(B55:B67)","v":27083},13586,415,6096,453,4137,null,"2025-01-01",2091,899,18,455,42,315,6798.9540630000001]
["2025-02-01",2003,669,26,386,24,288,6751.6031590000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2025-02-01"},{"$f":"SUM(B56:B68)","v":26589},13104,415,5938,438,4082,null,"2025-02-01",2003,669,26,386,24,288,6751.6031590000002]
["2025-03-01",2001,898,31,492,39,295,7203.2738300000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2025-03-01"},{"$f":"SUM(B57:B69)","v":26318},12984,420,5976,446,4007,null,"2025-03-01",2001,898,31,492,39,295,7203.2738300000001]
["2025-04-01",1838,878,22,463,42,265,6889.6614330000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2025-04-01"},{"$f":"SUM(B58:B70)","v":25866},12691,409,5978,461,3919,null,"2025-04-01",1838,878,22,463,42,265,6889.6614330000002]

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