{"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":[[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,243,null,"Left process at stage 1:",null,null,null,372,null,"Left process at stage 2:",null,null,null,6,null,"Exited process:",null,null,null,37,null,"Settled:",null,null,37]
[]
["Δ from last month:",null,null,-181,null,"Δ from last month:",null,null,null,-164,null,"Δ from last month:",null,null,null,-2,null,"Δ from last month:",null,null,null,-6,null,"Δ from last month:",null,null,19]
[]
["Rolling 12 months:",null,null,9079,null,"Rolling 12 months:",null,null,null,6592,null,"Rolling 12 months:",null,null,null,74,null,"Rolling 12 months:",null,null,null,1787,null,"Rolling 12 months:",null,null,605]
[]
["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,367,null,519,null,-152]
["Other",null,null,null,null,null,null,5,null,8,null,-3]
["Total",null,null,null,null,null,null,372,null,527,null,-155]
["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,5,null,5,null,0]
["Settlement pack timeout:",null,null,null,null,null,null,1,null,2,null,-1]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,0,null,1,null,-1]
["Total",null,null,null,null,null,null,6,null,8,null,-2]

{"sheet":"Backing Sheet Data","index":1,"n_rows":88,"n_cols":13,"rows_kept":88,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,3,3,4],[21,3,21,4],[8,7,8,8]]}
["Reporting date","2024-05-01"]
["Previous month","2024-04-01"]
[]
["Rolling 12 CNFs sent",null,null,"Average General Damages chart data",null,null,null,"Left Process Breakdown"]
[]
["Period","Rolling 12 Sent",null,"Row Labels","Ave General Damages",null,null,"This Month LDT","This Month Other Liability","This Month Interim Payment Not Agreed","This Month Repudiated","This Month Timeout","This Month Court Proceedings"]
["2023-06-01",6011,null,"2023-06-01",3379.1122439999999,null,null,367,5,0,5,1,0]
["2023-07-01",6254,null,"2023-07-01",3552.0740000000001]
["2023-08-01",6750,null,"2023-08-01",3686.5510629999999,null,null,"CNF Sent Monthly Volumes Chart Data"]
["2023-09-01",9856,null,"2023-09-01",3420.8219779999999]
["2023-10-01",9832,null,"2023-10-01",3185.3679240000001,null,null,"Sum of ClaimCount","Column Labels"]
["2023-11-01",9805,null,"2023-11-01",3973.5549999999998,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total"]
["2023-12-01",9665,null,"2023-12-01",3188.6715060000001,null,null,"2023-06-01",7692,3447,640,2559,14338]
["2024-01-01",9615,null,"2024-01-01",3724.128181,null,null,"2023-07-01",7290,3348,695,2467,13800]
["2024-02-01",9532,null,"2024-02-01",3292.7536230000001,null,null,"2023-08-01",7456,3395,1001,2444,14296]
["2024-03-01",9569,null,"2024-03-01",4435.1320750000004,null,null,"2023-09-01",7013,3140,3515,2367,16035]
["2024-04-01",9450,null,"2024-04-01",3513.388888,null,null,"2023-10-01",7826,3321,423,2491,14061]
["2024-05-01",9079,null,"2024-05-01",3202,null,null,"2023-11-01",7717,3233,468,2521,13939]
[null,null,null,"Grand Total",42553.556482,null,null,"2023-12-01",5696,2256,211,1618,9781]
[null,null,null,null,null,null,null,"2024-01-01",7490,3160,451,2495,13596]
[null,null,null,null,null,null,null,"2024-02-01",7241,3053,438,2272,13004]
[null,3028,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,"2024-04-01",7617,2787,424,2124,12952]
["Claim requires further investigation",1400,null,"DatePeriod","ClaimType","ClaimCount",null,"2024-05-01",6270,2486,243,1902,10901]
["Other",1078,null,"2023-03-01","EL",600,null,"Grand Total",86178,36557,9079,27547,159361]
["Duplicated claim",290,null,"2023-04-01","EL",2147]
["Withdrawl of claim",126,null,"2023-05-01","EL",2210]
["Incomplete information provided on CNF",102,null,"2023-06-01","EL",2559]
["Value of claim exceeds the upper limit",14,null,"2023-07-01","EL",2467]
["Stage 1 costs not paid on time",6,null,"2023-08-01","EL",2444]
["Withdrawal of offer",5,null,"2023-09-01","EL",2367]
["Claim is too complex for process",3,null,"2023-10-01","EL",2491]
["Failure to provide adequate loss of earnings details",3,null,"2023-11-01","EL",2521]
["Failure to acknowledge CNF on time",1,null,"2023-12-01","EL",1618]
[null,null,null,"2024-01-01","EL",2495]
[null,null,null,"2024-02-01","EL",2272]
[null,null,null,"2024-03-01","EL",2287]
[null,null,null,"2024-04-01","EL",2124]
[null,null,null,"2024-05-01","EL",1902]
[null,null,null,"2024-06-01","EL",124]
[null,null,null,"2023-03-01","ELD",137]
[null,null,null,"2023-04-01","ELD",543]
[null,null,null,"2023-05-01","ELD",614]
[null,null,null,"2023-06-01","ELD",640]
[null,null,null,"2023-07-01","ELD",695]
[null,null,null,"2023-08-01","ELD",1001]
[null,null,null,"2023-09-01","ELD",3515]
[null,null,null,"2023-10-01","ELD",423]
[null,null,null,"2023-11-01","ELD",468]
[null,null,null,"2023-12-01","ELD",211]
[null,null,null,"2024-01-01","ELD",451]
[null,null,null,"2024-02-01","ELD",438]
[null,null,null,"2024-03-01","ELD",570]
[null,null,null,"2024-04-01","ELD",424]
[null,null,null,"2024-05-01","ELD",243]
[null,null,null,"2024-06-01","ELD",11]
[null,null,null,"2023-03-01","PL",847]
[null,null,null,"2023-04-01","PL",2733]
[null,null,null,"2023-05-01","PL",3169]
[null,null,null,"2023-06-01","PL",3447]
[null,null,null,"2023-07-01","PL",3348]
[null,null,null,"2023-08-01","PL",3395]
[null,null,null,"2023-09-01","PL",3140]
[null,null,null,"2023-10-01","PL",3321]
[null,null,null,"2023-11-01","PL",3233]
[null,null,null,"2023-12-01","PL",2256]
[null,null,null,"2024-01-01","PL",3160]
[null,null,null,"2024-02-01","PL",3053]
[null,null,null,"2024-03-01","PL",2931]
[null,null,null,"2024-04-01","PL",2787]
[null,null,null,"2024-05-01","PL",2486]
[null,null,null,"2024-06-01","PL",152]
[null,null,null,"2023-03-01","RTA",1624]
[null,null,null,"2023-04-01","RTA",6109]
[null,null,null,"2023-05-01","RTA",6855]
[null,null,null,"2023-06-01","RTA",7692]
[null,null,null,"2023-07-01","RTA",7290]
[null,null,null,"2023-08-01","RTA",7456]
[null,null,null,"2023-09-01","RTA",7013]
[null,null,null,"2023-10-01","RTA",7826]
[null,null,null,"2023-11-01","RTA",7717]
[null,null,null,"2023-12-01","RTA",5696]
[null,null,null,"2024-01-01","RTA",7490]
[null,null,null,"2024-02-01","RTA",7241]
[null,null,null,"2024-03-01","RTA",6870]
[null,null,null,"2024-04-01","RTA",7617]
[null,null,null,"2024-05-01","RTA",6270]
[null,null,null,"2024-06-01","RTA",273]

{"sheet":"vELDDashboard","index":2,"n_rows":67,"n_cols":25,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"SUBTOTAL(9,vELDDashboard[CNFs Sent])","v":21199},{"$f":"SUBTOTAL(9,vELDDashboard[CNFs left at Stage 1])","v":13100},{"$f":"SUBTOTAL(9,vELDDashboard[Stage 2 Exit])","v":219},{"$f":"SUBTOTAL(9,vELDDashboard[Exit process])","v":4283},{"$f":"SUBTOTAL(9,vELDDashboard[Court Pack])","v":8},{"$f":"SUBTOTAL(9,vELDDashboard[Settled claims])","v":1386},{"$f":"SUBTOTAL(9,vELDDashboard[General Damages])","v":273387.79829899996}]
["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-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(B3: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"},1622,800,12,507,2,24,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(B5:B16)","v":1588},808,8,496,2,25,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(B6:B17)","v":1575},770,8,470,2,26,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(B7:B18)","v":1595},785,10,471,2,27,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(B8:B19)","v":1585},765,7,450,2,26,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(B9:B20)","v":1648},758,8,437,1,27,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(B10:B21)","v":1849},741,6,441,1,26,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(B11:B22)","v":2052},786,14,478,1,43,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(B12:B23)","v":2302},891,18,515,1,88,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(B13:B24)","v":2605},1031,24,599,2,124,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(B14:B25)","v":2754},1194,28,653,2,152,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(B15:B26)","v":2973},1338,33,721,2,212,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(B16:B27)","v":3178},1436,37,730,1,269,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(B17:B28)","v":3507},1589,42,760,1,298,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(B18:B29)","v":3741},1755,45,814,1,303,null,"2021-03-01",290,147,2,99,1,45,3700.4580000000001]
["2022-05-01",503,266,4,83,1,35,3857.4942850000002,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-05-01"},{"$f":"SUM(B19:B30)","v":4057},1952,47,852,2,336,null,"2021-04-01",302,132,4,87,0,29,3493.789655]
["2022-06-01",463,224,7,75,1,19,3958.0142099999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-06-01"},{"$f":"SUM(B20:B31)","v":4383},2117,54,892,3,354,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(B21:B32)","v":4627},2478,61,918,3,378,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(B22:B33)","v":4845},2781,69,944,3,402,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(B23:B34)","v":4918},2925,69,945,4,414,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(B24:B35)","v":5006},3051,68,945,4,404,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(B25:B36)","v":5072},3112,65,922,4,396,null,"2021-10-01",335,162,4,70,0,46,3487.3402169999999]
["2022-12-01",351,263,6,81,0,32,3439.2478120000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-12-01"},{"$f":"SUM(B26:B37)","v":5141},3167,67,910,4,397,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(B27:B38)","v":5261},3281,70,883,4,390,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(B28:B39)","v":5455},3341,69,897,4,353,null,"2022-01-01",360,192,5,92,0,63,3527.6668249999998]
["2023-03-01",533,352,10,120,0,35,3586.4734279999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-03-01"},{"$f":"SUM(B29:B40)","v":5540},3454,74,946,4,356,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(B30:B41)","v":5723},3521,73,945,4,378,null,"2022-03-01",416,223,5,71,0,36,4066.6277770000002]
["2023-05-01",614,226,12,98,0,64,3785.4521869999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-05-01"},{"$f":"SUM(B31:B42)","v":5834},3481,81,960,3,407,null,"2022-04-01",329,186,5,79,0,7,4384.6057140000003]
["2023-06-01",640,456,4,95,0,49,3379.1122439999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-06-01"},{"$f":"SUM(B32:B43)","v":6011},3713,78,980,2,437,null,"2022-05-01",394,246,4,76,1,36,3896.6563879999999]
["2023-07-01",695,425,6,126,0,40,3552.0740000000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-07-01"},{"$f":"SUM(B33:B44)","v":6254},3712,76,1045,2,450,null,"2022-06-01",487,210,7,70,1,19,3997.4878939999999]
["2023-08-01",1001,428,8,198,0,47,3686.5510629999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-08-01"},{"$f":"SUM(B34:B45)","v":6750},3778,{"$f":"SUM(D34:D45)","v":75},1177,2,472,null,"2022-07-01",427,417,9,56,0,28,3584.5535709999999]
["2023-09-01",3515,443,3,405,0,91,3420.8219779999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-09-01"},{"$f":"SUM(B35:B46)","v":9856},3964,70,1508,1,530,null,"2022-08-01",492,332,9,63,0,25,4211.5339999999997]
["2023-10-01",423,1009,3,447,0,53,3185.3679240000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-10-01"},{"$f":"SUM(B36:B47)","v":9832},4675,70,1884,1,547,null,"2022-09-01",392,236,8,73,1,33,4464.692121]
["2023-11-01",468,1726,9,220,0,42,3973.5549999999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-11-01"},{"$f":"SUM(B37:B48)","v":9805},6144,76,2018,0,560,null,"2022-10-01",417,279,3,64,0,37,3634.3567560000001]
["2023-12-01",211,336,3,49,0,73,3188.6715060000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-12-01"},{"$f":"SUM(B38:B49)","v":9665},6217,73,1986,0,601,null,"2022-11-01",427,243,3,84,1,29,4357.8310339999998]
["2024-01-01",451,260,11,45,0,33,3724.128181,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-01-01"},{"$f":"SUM(B39:B50)","v":9615},6160,76,1960,0,579,null,"2022-12-01",289,251,6,69,0,32,3895.4978120000001]
["2024-02-01",438,294,8,74,0,69,3292.7536230000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-02-01"},{"$f":"SUM(B40:B51)","v":9532},6225,81,1958,0,625,null,"2023-01-01",489,294,8,69,0,55,3662.1283629999998]
["2024-03-01",570,307,5,48,0,53,4435.1320750000004,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-03-01"},{"$f":"SUM(B41:B52)","v":9569},6180,76,1886,0,643,null,"2023-02-01",508,198,3,70,0,19,4284.5473679999996]
["2024-04-01",424,536,7,43,1,18,3513.388888,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-04-01"},{"$f":"SUM(B42:B53)","v":9450},{"$f":"SUM(C42:C53)","v":6446},79,1848,1,632,null,"2023-03-01",452,294,9,106,0,34,3586.0755880000002]
["2024-05-01",243,372,6,37,0,37,3202,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2024-05-01"},{"$f":"SUM(B43:B54)","v":9079},6592,73,{"$f":"SUM(E43:E54)","v":1787},1,{"$f":"SUM(G43:G54)","v":605},null,"2023-04-01",534,243,4,75,0,29,3567.6917239999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",605,204,12,90,0,64,3827.930781]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",620,437,4,88,0,48,3391.3125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01",681,407,6,115,0,40,3578.8139999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-01",942,410,8,176,0,47,3724.1510629999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-01",3397,424,3,366,0,50,3667.8904000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-01",414,977,3,398,0,53,3354.6698110000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-01",458,1711,9,197,0,42,4025.8597610000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-01",209,330,3,43,0,73,3342.4386300000001]
[null,null,null,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,null,null,null,"2024-02-01",438,294,8,74,0,69,3292.7536230000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-01",570,307,5,48,0,53,4435.1320750000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-04-01",424,536,7,43,1,18,3513.388888]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-01",243,372,6,37,0,37,3202]

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