{"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":[[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,1902,null,"Left process at stage 1:",null,null,null,967,null,"Left process at stage 2:",null,null,null,52,null,"Exited process:",null,null,null,426,null,"Settled:",null,null,309]
[]
["Δ from last month:",null,null,-222,null,"Δ from last month:",null,null,null,-141,null,"Δ from last month:",null,null,null,2,null,"Δ from last month:",null,null,null,-51,null,"Δ from last month:",null,null,-11]
[]
["Rolling 12 months:",null,null,27547,null,"Rolling 12 months:",null,null,null,13910,null,"Rolling 12 months:",null,null,null,846,null,"Rolling 12 months:",null,null,null,6432,null,"Rolling 12 months:",null,null,4037]
[]
["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,803,null,803,null,0]
["Other",null,null,null,null,null,null,156,null,166,null,-10]
["Total",null,null,null,null,null,null,959,null,969,null,-10]
["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,1,null,-1]
["Settlement pack repudiated:",null,null,null,null,null,null,0,null,0,null,0]
["Settlement pack timeout:",null,null,null,null,null,null,28,null,17,null,11]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,24,null,32,null,-8]
["Total",null,null,null,null,null,null,52,null,50,null,2]

{"sheet":"Backing Sheet Data","index":1,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2024-05-01"]
["Previous month","2024-04-01"]
[]
["Rolling 12 CNFs sent",null,null,null,"Average General Damages chart data",null,null,null,"Left Process Breakdown"]
[]
["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"]
["2023-06-01",28658,null,null,"2023-06-01",5958.5932249999996,null,null,803,156,0,0,28,24]
["2023-07-01",28756,null,null,"2023-07-01",5851.862478]
["2023-08-01",28705,null,null,"2023-08-01",6023.6783329999998,null,null,"CNF Sent Monthly Volumes Chart Data"]
["2023-09-01",28546,null,null,"2023-09-01",5718.6038769999996]
["2023-10-01",28529,null,null,"2023-10-01",5669.4196739999998,null,null,"Sum of ClaimCount","Column Labels"]
["2023-11-01",28420,null,null,"2023-11-01",5839.1911110000001,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total"]
["2023-12-01",28372,null,null,"2023-12-01",6303.9472820000001,null,null,"2023-06-01",7692,3447,640,2559,14338]
["2024-01-01",28325,null,null,"2024-01-01",5368.4907549999998,null,null,"2023-07-01",7290,3348,695,2467,13800]
["2024-02-01",28245,null,null,"2024-02-01",4278.2727949999999,null,null,"2023-08-01",7456,3395,1001,2444,14296]
["2024-03-01",27878,null,null,"2024-03-01",3010.8526059999999,null,null,"2023-09-01",7013,3140,3515,2367,16035]
["2024-04-01",27855,null,null,"2024-04-01",2998.1325000000002,null,null,"2023-10-01",7826,3321,423,2491,14061]
["2024-05-01",27547,null,null,"2024-05-01",2920.6148859999998,null,null,"2023-11-01",7717,3233,468,2521,13939]
[null,null,null,null,"Grand Total",59941.659522000002,null,null,"2023-12-01",5696,2256,211,1618,9781]
[null,null,null,null,null,null,null,null,"2024-01-01",7490,3160,451,2495,13596]
[null,null,null,null,null,null,null,null,"2024-02-01",7241,3053,438,2272,13004]
[null,14266,null,null,"CNF Sent Monthly Volumes",null,null,null,"2024-03-01",6870,2931,570,2287,12658]
["Exit Process Reason","Total",null,null,null,null,null,null,"2024-04-01",7617,2787,424,2124,12952]
["Claim requires further investigation",7425,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2024-05-01",6270,2486,243,1902,10901]
["Other",5149,null,null,"2023-03-01","RTA",1624,null,"Grand Total",86178,36557,9079,27547,159361]
["Duplicated claim",435,null,null,"2023-04-01","RTA",6109]
["Value of claim exceeds the upper limit",369,null,null,"2023-05-01","RTA",6855]
["Failure to provide adequate loss of earnings details",305,null,null,"2023-06-01","RTA",7692]
["Incomplete information provided on CNF",286,null,null,"2023-07-01","RTA",7290]
["Stage 1 costs not paid on time",108,null,null,"2023-08-01","RTA",7456]
["Claim is too complex for process",54,null,null,"2023-09-01","RTA",7013]
["Withdrawl of claim",48,null,null,"2023-10-01","RTA",7826]
["Interim Payment request not answered and/or paid on time",36,null,null,"2023-11-01","RTA",7717]
["Withdrawal of offer",26,null,null,"2023-12-01","RTA",5696]
["Value of claim below £1,000",16,null,null,"2024-01-01","RTA",7490]
["Failure to acknowledge CNF on time",6,null,null,"2024-02-01","RTA",7241]
["Interim Payment partial offer not accepted",3,null,null,"2024-03-01","RTA",6870]
[null,null,null,null,"2024-04-01","RTA",7617]
[null,null,null,null,"2024-05-01","RTA",6270]
[null,null,null,null,"2024-06-01","RTA",273]
[null,null,null,null,"2023-03-01","EL",600]
[null,null,null,null,"2023-04-01","EL",2147]
[null,null,null,null,"2023-05-01","EL",2210]
[null,null,null,null,"2023-06-01","EL",2559]
[null,null,null,null,"2023-07-01","EL",2467]
[null,null,null,null,"2023-08-01","EL",2444]
[null,null,null,null,"2023-09-01","EL",2367]
[null,null,null,null,"2023-10-01","EL",2491]
[null,null,null,null,"2023-11-01","EL",2521]
[null,null,null,null,"2023-12-01","EL",1618]
[null,null,null,null,"2024-01-01","EL",2495]
[null,null,null,null,"2024-02-01","EL",2272]
[null,null,null,null,"2024-03-01","EL",2287]
[null,null,null,null,"2024-04-01","EL",2124]
[null,null,null,null,"2024-05-01","EL",1902]
[null,null,null,null,"2024-06-01","EL",124]
[null,null,null,null,"2023-03-01","ELD",137]
[null,null,null,null,"2023-04-01","ELD",543]
[null,null,null,null,"2023-05-01","ELD",614]
[null,null,null,null,"2023-06-01","ELD",640]
[null,null,null,null,"2023-07-01","ELD",695]
[null,null,null,null,"2023-08-01","ELD",1001]
[null,null,null,null,"2023-09-01","ELD",3515]
[null,null,null,null,"2023-10-01","ELD",423]
[null,null,null,null,"2023-11-01","ELD",468]
[null,null,null,null,"2023-12-01","ELD",211]
[null,null,null,null,"2024-01-01","ELD",451]
[null,null,null,null,"2024-02-01","ELD",438]
[null,null,null,null,"2024-03-01","ELD",570]
[null,null,null,null,"2024-04-01","ELD",424]
[null,null,null,null,"2024-05-01","ELD",243]
[null,null,null,null,"2024-06-01","ELD",11]
[null,null,null,null,"2023-03-01","PL",847]
[null,null,null,null,"2023-04-01","PL",2733]
[null,null,null,null,"2023-05-01","PL",3169]
[null,null,null,null,"2023-06-01","PL",3447]
[null,null,null,null,"2023-07-01","PL",3348]
[null,null,null,null,"2023-08-01","PL",3395]
[null,null,null,null,"2023-09-01","PL",3140]
[null,null,null,null,"2023-10-01","PL",3321]
[null,null,null,null,"2023-11-01","PL",3233]
[null,null,null,null,"2023-12-01","PL",2256]
[null,null,null,null,"2024-01-01","PL",3160]
[null,null,null,null,"2024-02-01","PL",3053]
[null,null,null,null,"2024-03-01","PL",2931]
[null,null,null,null,"2024-04-01","PL",2787]
[null,null,null,null,"2024-05-01","PL",2486]
[null,null,null,null,"2024-06-01","PL",152]

{"sheet":"vELDashboard","index":2,"n_rows":60,"n_cols":25,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"SUBTOTAL(9,vELDashboard[CNFs Sent])","v":110429},{"$f":"SUBTOTAL(9,vELDashboard[CNFs left at Stage 1])","v":48412},{"$f":"SUBTOTAL(9,vELDashboard[Stage 2 Exit])","v":1500},{"$f":"SUBTOTAL(9,vELDashboard[Exit process])","v":24792},{"$f":"SUBTOTAL(9,vELDashboard[Court Pack])","v":1992},{"$f":"SUBTOTAL(9,vELDashboard[Settled claims])","v":13052},{"$f":"SUBTOTAL(9,vELDashboard[General Damages])","v":276858.62804899999}]
["Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages",null,"Period","Rolling 12 CNF Sent","Rolling 12 CNF Left at Stage 1","Rolling 12 Stage 2 Exit","Rolling 12 Exit Process","Rolling 12 Court Pack","Rolling 12 Settled Claims",null,"Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages"]
["2019-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,2799.7070170000002,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,4178.9265750000004,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,3826.7237930000001,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,3420.7329030000001,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,3148.6848519999999,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",1486,682,21,375,42,84,3763.0748800000001,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,3950.6605810000001,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,3589.6297530000002,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,4804.9246249999997,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,3098.2918639999998,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,3350.3233329999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-08-01"},{"$f":"SUM(B3:B14)","v":14908},5370,183,3140,371,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,4167.3276619999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-09-01"},{"$f":"SUM(B4:B15)","v":14882},{"$f":"SUM(C4:C15)","v":5781},{"$f":"SUM(D4:D15)","v":194},{"$f":"SUM(E4:E15)","v":3336},{"$f":"SUM(F4:F15)","v":394},{"$f":"SUM(G4:G15)","v":905},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,82,4509.7918289999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-10-01"},14549,{"$f":"SUM(C5:C16)","v":5677},186,3312,374,930,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,81,3671.617283,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-11-01"},{"$f":"SUM(B6:B17)","v":14181},{"$f":"SUM(C6:C17)","v":5503},183,3260,370,938,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,97,5395.3718550000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2020-12-01"},14116,{"$f":"SUM(C7:C18)","v":5362},177,3199,366,948,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2020-12-01"},1977,980,37,531,45,364,4694.4902739999998]
["2021-01-01",1220,421,8,240,19,73,3724.561643,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-01-01"},13779,{"$f":"SUM(C8:C19)","v":5211},170,3051,341,928,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,4560.5980719999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-02-01"},13509,{"$f":"SUM(C9:C20)","v":5098},166,2987,328,943,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,108,4420.7618510000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-03-01"},13535,{"$f":"SUM(C10:C21)","v":4925},154,2891,312,967,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,88,4123.1429539999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-04-01"},14042,{"$f":"SUM(C11:C22)","v":4745},156,2808,307,969,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-04-01"},2315,993,45,597,57,414,4846.5958689999998]
["2021-05-01",1337,415,13,266,23,79,4034.8431639999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-05-01"},14650,{"$f":"SUM(C12:C23)","v":4750},148,2856,305,967,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-05-01"},2199,928,26,577,40,347,4774.8293940000003]
["2021-06-01",1425,481,14,283,19,76,5251.054736,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-06-01"},15176,{"$f":"SUM(C13:C24)","v":4922},148,2911,283,963,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,70,4755.9202850000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-07-01"},15498,{"$f":"SUM(C14:C25)","v":5023},150,2970,277,974,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-07-01"},2442,992,37,567,54,378,4960.9055820000003]
["2021-08-01",2213,439,9,275,15,91,4561.312527,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-08-01"},16675,{"$f":"SUM(C15:C26)","v":5138},148,3044,267,1005,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-08-01"},2419,994,31,595,40,359,4906.8961550000004]
["2021-09-01",2696,810,19,453,35,181,5381.4367949999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-09-01"},18097,{"$f":"SUM(C16:C27)","v":5532},156,3288,277,1109,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,371,5077.9933959999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-10-01"},19386,{"$f":"SUM(C17:C28)","v":6280},181,3684,295,1398,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,427,5918.9504209999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-11-01"},20912,{"$f":"SUM(C18:C29)","v":7114},212,4138,312,1744,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,352,5522.130596,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2021-12-01"},21916,{"$f":"SUM(C19:C30)","v":7910},235,4501,319,1999,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2021-12-01"},1952,1039,38,577,35,351,5112.0429620000004]
["2022-01-01",2550,1121,24,549,39,357,5549.0947050000004,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-01-01"},23246,{"$f":"SUM(C20:C31)","v":8610},251,4810,339,2283,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-01-01"},2383,1000,24,539,39,365,4867.4547670000002]
["2022-02-01",2438,899,32,527,43,340,5456.3995580000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-02-01"},24368,{"$f":"SUM(C21:C32)","v":9188},269,5148,365,2540,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-02-01"},2396,801,32,521,43,346,4871.2523119999996]
["2022-03-01",2844,1265,43,684,60,351,5280.3521650000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-03-01"},25700,{"$f":"SUM(C22:C33)","v":9944},303,5553,399,2783,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,340,5746.5783229999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-04-01"},26511,{"$f":"SUM(C23:C34)","v":10657},326,5870,417,3035,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,5619.6429310000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-05-01"},27729,{"$f":"SUM(C24:C35)","v":11442},345,6236,445,3362,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-05-01"},2418,1044,32,604,51,406,5118.0826100000004]
["2022-06-01",2458,1172,53,540,40,382,6031.9410989999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-06-01"},28762,{"$f":"SUM(C25:C36)","v":12133},384,6493,466,3668,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,325,5537.7700610000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-07-01"},29658,{"$f":"SUM(C26:C37)","v":12920},408,6792,488,3923,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-07-01"},2257,1080,37,543,42,334,4974.6811369999996]
["2022-08-01",2495,1244,37,592,53,353,5499.1649850000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-08-01"},29940,{"$f":"SUM(C27:C38)","v":13725},436,7109,526,4185,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-08-01"},2344,1096,37,572,54,366,5004.8880319999998]
["2022-09-01",2526,1231,36,602,43,339,5601.3201760000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-09-01"},29770,{"$f":"SUM(C28:C39)","v":14146},453,7258,534,4343,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,358,5656.5126810000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-10-01"},29693,{"$f":"SUM(C29:C40)","v":14136},461,7195,538,4330,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-10-01"},2351,1030,44,564,42,352,5156.298323]
["2022-11-01",2630,1220,43,644,44,333,5619.4100600000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-11-01"},29628,{"$f":"SUM(C30:C41)","v":14077},461,7105,537,4236,null,{"$f":"tblPrevious12V2[[#This Row],[Period]]","v":"2022-11-01"},2460,1081,43,625,44,339,5018.7872269999998]
["2022-12-01",1666,1126,39,544,34,265,5709.3314330000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2022-12-01"},29246,{"$f":"SUM(C31:C42)","v":13997},462,7049,536,4149,null,"2022-12-01",1406,978,39,482,34,265,6165.9560000000001]
["2023-01-01",2542,1050,29,557,54,306,5628.1555550000003,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-01-01"},29238,{"$f":"SUM(C32:C43)","v":13926},467,7057,551,4098,null,"2023-01-01",2407,922,29,503,54,307,5831.012377]
["2023-02-01",2352,924,38,444,32,330,5458.9217269999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-02-01"},29152,{"$f":"SUM(C33:C44)","v":13951},473,6974,540,4088,null,"2023-02-01",2201,788,38,392,32,324,5625.0179010000002]
["2023-03-01",2654,1336,43,663,37,391,5984.3941679999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-03-01"},28962,{"$f":"SUM(C34:C45)","v":14022},473,6953,517,4128,null,"2023-03-01",2297,1028,41,534,30,335,6065.6919699999999]
["2023-04-01",2147,976,28,430,39,305,6045.1940649999997,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-04-01"},28902,{"$f":"SUM(C35:C46)","v":13894},459,6806,509,4093,null,"2023-04-01",2027,850,28,381,39,311,6064.3481019999999]
["2023-05-01",2210,1178,35,543,47,342,5434.3862570000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-05-01"},28557,{"$f":"SUM(C36:C47)","v":13872},462,6717,505,4029,null,"2023-05-01",2079,1012,35,481,47,347,5604.6977230000002]
["2023-06-01",2559,1245,48,529,52,372,5958.5932249999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-06-01"},28658,{"$f":"SUM(C37:C48)","v":13945},457,6706,517,4019,null,"2023-06-01",2342,1102,48,444,50,381,5824.8952490000001]
["2023-07-01",2467,1161,37,589,55,355,5851.862478,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-07-01"},28756,{"$f":"SUM(C38:C49)","v":13863},457,6738,532,4049,null,"2023-07-01",2325,1021,37,518,55,360,5981.562277]
["2023-08-01",2444,1340,27,632,52,324,6023.6783329999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-08-01"},28705,{"$f":"SUM(C39:C50)","v":13959},447,6778,531,4020,null,"2023-08-01",2288,1183,27,556,52,325,6137.1051070000003]
["2023-09-01",2367,1151,34,625,47,294,5718.6038769999996,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-09-01"},28546,{"$f":"SUM(C40:C51)","v":13879},445,6801,535,3975,null,"2023-09-01",2207,1039,26,543,30,233,6253.1459219999997]
["2023-10-01",2491,1193,50,546,42,338,5669.4196739999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-10-01"},28529,{"$f":"SUM(C41:C52)","v":13900},451,6746,535,3955,null,"2023-10-01",2367,1070,50,472,42,340,5960.6469699999998]
["2023-11-01",2521,1288,35,675,22,369,5839.1911110000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-11-01"},28420,{"$f":"SUM(C42:C53)","v":13968},443,6777,513,3991,null,"2023-11-01",2413,1142,35,602,22,373,6045.7014740000004]
["2023-12-01",1618,1117,32,474,29,287,6303.9472820000001,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2023-12-01"},28372,{"$f":"SUM(C43:C54)","v":13959},436,6707,508,4013,null,"2023-12-01",1506,945,32,380,29,303,6327.3456429999997]
["2024-01-01",2495,1151,26,544,39,344,5368.4907549999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-01-01"},28325,{"$f":"SUM(C44:C55)","v":14060},433,6694,493,4051,null,"2024-01-01",2495,1151,26,544,39,344,5368.4907549999998]
["2024-02-01",2272,1018,26,454,31,372,4278.2727949999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-02-01"},28245,{"$f":"SUM(C45:C56)","v":14154},421,6704,492,4093,null,"2024-02-01",2272,1018,26,454,31,372,4278.2727949999999]
["2024-03-01",2287,1171,33,461,27,353,3010.8526059999999,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-03-01"},27878,{"$f":"SUM(C46:C57)","v":13989},411,6502,482,4055,null,"2024-03-01",2287,1171,33,461,27,353,3010.8526059999999]
["2024-04-01",2124,1108,18,477,32,320,2998.1325000000002,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-04-01"},27855,{"$f":"SUM(C47:C58)","v":14121},401,6549,475,4070,null,"2024-04-01",2124,1108,18,477,32,320,2998.1325000000002]
["2024-05-01",1902,967,28,426,24,309,2920.6148859999998,null,{"$f":"vELDashboard[[#This Row],[Period]]","v":"2024-05-01"},{"$f":"SUM(B48:B59)","v":27547},{"$f":"SUM(C48:C59)","v":13910},{"$f":"SUM(D48:D59)","v":394},6432,452,4037,null,"2024-05-01",1902,967,28,426,24,309,2920.6148859999998]
["2024-06-01",124,56,4,39,4,25,2859.36]

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