{"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,209,null,"Left process at stage 1:",null,null,null,330,null,"Left process at stage 2:",null,null,null,3,null,"Exited process:",null,null,null,43,null,"Settled:",null,null,73]
[]
["Δ from last month:",null,null,-249,null,"Δ from last month:",null,null,null,-1381,null,"Δ from last month:",null,null,null,-6,null,"Δ from last month:",null,null,null,-154,null,"Δ from last month:",null,null,31]
[]
["Rolling 12 months:",null,null,9676,null,"Rolling 12 months:",null,null,null,6077,null,"Rolling 12 months:",null,null,null,73,null,"Rolling 12 months:",null,null,null,1854,null,"Rolling 12 months:",null,null,601]
[]
["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,325,null,1688,null,-1363]
["Other",null,null,null,null,null,null,5,null,23,null,-18]
["Total",null,null,null,null,null,null,330,null,1711,null,-1381]
["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,2,null,7,null,-5]
["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,0,null,0]
["Total",null,null,null,null,null,null,3,null,9,null,-6]

{"sheet":"Backing Sheet Data","index":1,"n_rows":84,"n_cols":14,"rows_kept":84,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2023-12-01"]
["Previous month","2023-11-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-01-01",5254,null,null,"2023-01-01",3662.1283629999998,null,null,325,5,0,2,1,0]
["2023-02-01",5447,null,null,"2023-02-01",4206.8]
["2023-03-01",5533,null,null,"2023-03-01",3586.4734279999998,null,null,"CNF Sent Monthly Volumes Chart Data"]
["2023-04-01",5716,null,null,"2023-04-01",3567.6917239999998]
["2023-05-01",5829,null,null,"2023-05-01",3827.930781,null,null,"Sum of ClaimCount","Column Labels"]
["2023-06-01",5877,null,null,"2023-06-01",3444.5510199999999,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total"]
["2023-07-01",6072,null,null,"2023-07-01",3578.8139999999999,null,null,"2023-01-01",7409,3373,501,2542,13825]
["2023-08-01",6519,null,null,"2023-08-01",3724.1510629999998,null,null,"2023-02-01",7487,3297,521,2355,13660]
["2023-09-01",8798,null,null,"2023-09-01",3420.8219779999999,null,null,"2023-03-01",7465,3568,533,2657,14223]
["2023-10-01",9762,null,null,"2023-10-01",3354.6698110000002,null,null,"2023-04-01",6139,2734,543,2151,11567]
["2023-11-01",9818,null,null,"2023-11-01",4025.8597610000002,null,null,"2023-05-01",6874,3172,615,2215,12876]
["2023-12-01",9676,null,null,"2023-12-01",3342.4386300000001,null,null,"2023-06-01",7707,3452,640,2561,14360]
[null,null,null,null,"Grand Total",43742.330558999995,null,null,"2023-07-01",7302,3351,695,2470,13818]
[null,null,null,null,null,null,null,null,"2023-08-01",7477,3398,1003,2447,14325]
[null,null,null,null,null,null,null,null,"2023-09-01",7027,3141,3524,2369,16061]
[null,2758,null,null,"CNF Sent Monthly Volumes",null,null,null,"2023-10-01",7854,3328,423,2491,14096]
["Exit Process Reason","Total",null,null,null,null,null,null,"2023-11-01",7769,3228,469,2524,13990]
["Claim requires further investigation",1281,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2023-12-01",5624,2020,209,1506,9359]
["Other",990,null,null,"2022-10-01","EL",1621,null,"Grand Total",86134,38062,9676,28288,162160]
["Duplicated claim",275,null,null,"2022-11-01","EL",2627]
["Incomplete information provided on CNF",96,null,null,"2022-12-01","EL",1666]
["Withdrawl of claim",93,null,null,"2023-01-01","EL",2542]
["Value of claim exceeds the upper limit",11,null,null,"2023-02-01","EL",2355]
["Withdrawal of offer",4,null,null,"2023-03-01","EL",2657]
["Stage 1 costs not paid on time",4,null,null,"2023-04-01","EL",2151]
["Claim is too complex for process",2,null,null,"2023-05-01","EL",2215]
["Failure to provide adequate loss of earnings details",1,null,null,"2023-06-01","EL",2561]
["Failure to acknowledge CNF on time",1,null,null,"2023-07-01","EL",2470]
[null,null,null,null,"2023-08-01","EL",2447]
[null,null,null,null,"2023-09-01","EL",2369]
[null,null,null,null,"2023-10-01","EL",2491]
[null,null,null,null,"2023-11-01","EL",2524]
[null,null,null,null,"2023-12-01","EL",1506]
[null,null,null,null,"2022-10-01","ELD",292]
[null,null,null,null,"2022-11-01","ELD",495]
[null,null,null,null,"2022-12-01","ELD",351]
[null,null,null,null,"2023-01-01","ELD",501]
[null,null,null,null,"2023-02-01","ELD",521]
[null,null,null,null,"2023-03-01","ELD",533]
[null,null,null,null,"2023-04-01","ELD",543]
[null,null,null,null,"2023-05-01","ELD",615]
[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",1003]
[null,null,null,null,"2023-09-01","ELD",3524]
[null,null,null,null,"2023-10-01","ELD",423]
[null,null,null,null,"2023-11-01","ELD",469]
[null,null,null,null,"2023-12-01","ELD",209]
[null,null,null,null,"2022-10-01","PL",2213]
[null,null,null,null,"2022-11-01","PL",3324]
[null,null,null,null,"2022-12-01","PL",2296]
[null,null,null,null,"2023-01-01","PL",3373]
[null,null,null,null,"2023-02-01","PL",3297]
[null,null,null,null,"2023-03-01","PL",3568]
[null,null,null,null,"2023-04-01","PL",2734]
[null,null,null,null,"2023-05-01","PL",3172]
[null,null,null,null,"2023-06-01","PL",3452]
[null,null,null,null,"2023-07-01","PL",3351]
[null,null,null,null,"2023-08-01","PL",3398]
[null,null,null,null,"2023-09-01","PL",3141]
[null,null,null,null,"2023-10-01","PL",3328]
[null,null,null,null,"2023-11-01","PL",3228]
[null,null,null,null,"2023-12-01","PL",2020]
[null,null,null,null,"2022-10-01","RTA",5049]
[null,null,null,null,"2022-11-01","RTA",8336]
[null,null,null,null,"2022-12-01","RTA",6137]
[null,null,null,null,"2023-01-01","RTA",7409]
[null,null,null,null,"2023-02-01","RTA",7487]
[null,null,null,null,"2023-03-01","RTA",7465]
[null,null,null,null,"2023-04-01","RTA",6139]
[null,null,null,null,"2023-05-01","RTA",6874]
[null,null,null,null,"2023-06-01","RTA",7707]
[null,null,null,null,"2023-07-01","RTA",7302]
[null,null,null,null,"2023-08-01","RTA",7477]
[null,null,null,null,"2023-09-01","RTA",7027]
[null,null,null,null,"2023-10-01","RTA",7854]
[null,null,null,null,"2023-11-01","RTA",7769]
[null,null,null,null,"2023-12-01","RTA",5624]

{"sheet":"vELDDashboard","index":2,"n_rows":62,"n_cols":25,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"SUBTOTAL(9,vELDDashboard[CNFs Sent])","v":19082},{"$f":"SUBTOTAL(9,vELDDashboard[CNFs left at Stage 1])","v":10789},{"$f":"SUBTOTAL(9,vELDDashboard[Stage 2 Exit])","v":182},{"$f":"SUBTOTAL(9,vELDDashboard[Exit process])","v":3777},{"$f":"SUBTOTAL(9,vELDDashboard[Court Pack])","v":7},{"$f":"SUBTOTAL(9,vELDDashboard[Settled claims])","v":1175},{"$f":"SUBTOTAL(9,vELDDashboard[General Damages])","v":255916.66971900003}]
["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,64,2,61,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,63,4,50,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,57,2,52,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,43,0,39,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,69,3,51,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,61,0,45,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,65,3,30,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,59,0,35,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,54,0,31,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,47,0,22,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,33,0,36,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,50,0,25,0,2,6750,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-11-01"},{"$f":"SUM(B3:B49)","v":19082},10789,182,3777,7,1175,null,"2019-12-01",254,144,5,95,4,15,3946.0520000000001]
["2020-12-01",122,64,0,50,1,3,2433.333333,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2020-12-01"},{"$f":"SUM(B4:B15)","v":1622},665,12,466,2,24,null,"2020-01-01",325,132,6,111,2,27,3777.607407]
["2021-01-01",119,73,0,38,0,3,3310.7333330000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-01-01"},{"$f":"SUM(B5:B16)","v":1588},{"$f":"SUM(C5:C16)","v":675},8,454,2,25,null,"2020-02-01",364,114,1,97,0,29,5334.2286199999999]
["2021-02-01",126,32,2,24,0,2,5930,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-02-01"},{"$f":"SUM(B6:B17)","v":1575},{"$f":"SUM(C6:C17)","v":650},{"$f":"SUM(D6:D17)","v":8},{"$f":"SUM(E6:E17)","v":426},{"$f":"SUM(F6:F17)","v":2},{"$f":"SUM(G6:G17)","v":26},null,"2020-03-01",335,173,4,104,0,48,4100.90625]
["2021-03-01",187,56,2,42,0,2,13795.2,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-03-01"},{"$f":"SUM(B7:B18)","v":1595},663,10,429,2,27,null,"2020-04-01",380,141,1,113,2,50,4034.8254000000002]
["2021-05-01",137,49,0,32,0,1,17013.87,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-05-01"},1585,{"$f":"SUM(C8:C19)","v":643},{"$f":"SUM(D8:D19)","v":7},{"$f":"SUM(E8:E19)","v":410},{"$f":"SUM(F8:F19)","v":2},{"$f":"SUM(G8:G19)","v":26},null,"2020-05-01",230,122,7,92,0,38,4309.4368420000001]
["2021-07-01",208,55,1,34,0,3,6416.6666660000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-07-01"},1648,637,8,399,1,27,null,"2020-06-01",265,171,5,102,0,51,4113.3231370000003]
["2021-08-01",287,53,1,39,0,1,6500,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-08-01"},1849,625,6,408,1,26,null,"2020-07-01",274,123,2,86,1,33,3784.4]
["2021-09-01",336,98,8,70,0,21,3171.77619,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-09-01"},2052,664,14,443,1,43,null,"2020-08-01",160,104,1,69,0,20,4155.1270000000004]
["2021-10-01",359,167,4,68,0,46,3425.7836950000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-10-01"},2302,777,18,480,1,88,null,"2020-09-01",297,113,2,66,0,21,4429.1238089999997]
["2021-11-01",429,187,6,108,1,37,3912.0886479999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-11-01"},2605,917,24,566,2,124,null,"2020-10-01",309,100,2,104,0,35,4108.0280000000002]
["2021-12-01",282,197,4,93,0,31,3562.2854830000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2021-12-01"},2754,1081,28,623,2,152,null,"2020-11-01",286,127,1,66,0,32,3741.734375]
["2022-01-01",381,192,5,93,0,62,3547.1379029999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-01-01"},2973,1223,33,691,2,212,null,"2020-12-01",249,118,3,91,1,38,3454.5450000000001]
["2022-02-01",326,161,4,59,0,60,3531.9576659999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-02-01"},3177,1320,37,700,1,269,null,"2021-01-01",310,135,2,96,0,44,3490.159772]
["2022-03-01",447,216,5,67,0,32,4654.5253119999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-03-01"},3505,1463,42,729,1,298,null,"2021-02-01",161,81,1,53,0,45,3844.6666660000001]
["2022-04-01",360,193,5,80,0,7,4386.0342849999997,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-04-01"},3739,1624,45,785,1,303,null,"2021-03-01",290,147,2,99,1,45,3700.4580000000001]
["2022-05-01",503,252,4,77,1,35,3951.7114280000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-05-01"},4055,1820,47,820,2,336,null,"2021-04-01",302,132,4,87,0,29,3493.789655]
["2022-06-01",463,215,7,67,1,19,4170.3189469999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-06-01"},4381,1986,54,855,3,354,null,"2021-05-01",240,129,1,84,0,44,3907.815681]
["2022-07-01",452,418,8,56,0,27,3708.0555549999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-07-01"},4625,2349,61,877,3,378,null,"2021-06-01",258,190,1,69,1,17,4477.4264700000003]
["2022-08-01",505,337,9,63,0,25,4221.5339999999997,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-08-01"},4843,2633,69,901,3,402,null,"2021-07-01",411,154,2,65,0,35,3377.4214280000001]
["2022-09-01",409,239,8,66,1,32,4589.9984370000002,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-09-01"},4916,2774,69,897,4,413,null,"2021-08-01",310,186,2,70,0,23,3008.734782]
["2022-10-01",447,285,3,70,0,36,3836.7750000000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-10-01"},5004,2892,68,899,4,403,null,"2021-09-01",322,187,9,88,0,56,3245.8401779999999]
["2022-11-01",495,252,3,79,1,29,5012.0768959999996,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-11-01"},5070,2957,65,870,4,395,null,"2021-10-01",335,162,4,70,0,46,3487.3402169999999]
["2022-12-01",351,256,6,71,0,32,3439.2478120000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2022-12-01"},5139,3016,67,848,4,396,null,"2021-11-01",408,180,6,100,1,37,3714.3167560000002]
["2023-01-01",501,306,8,69,0,55,3662.1283629999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-01-01"},{"$f":"SUM(B27:B38)","v":5259},3130,70,824,4,389,null,"2021-12-01",252,194,4,90,0,31,3321.5448379999998]
["2023-02-01",521,217,3,72,0,23,4206.8,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-02-01"},5454,3186,69,837,4,352,null,"2022-01-01",360,192,5,92,0,63,3527.6668249999998]
["2023-03-01",533,339,10,114,0,35,3586.4734279999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-03-01"},{"$f":"SUM(B29:B40)","v":5540},{"$f":"SUM(C29:C40)","v":3309},{"$f":"SUM(D29:D40)","v":74},{"$f":"SUM(E29:E40)","v":884},{"$f":"SUM(F29:F40)","v":4},{"$f":"SUM(G29:G40)","v":355},null,"2022-02-01",308,160,4,59,0,63,3380.2033329999999]
["2023-04-01",543,260,4,75,0,29,3567.6917239999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-04-01"},5723,3376,73,879,4,377,null,"2022-03-01",416,223,5,71,0,36,4066.6277770000002]
["2023-05-01",615,214,12,95,0,64,3827.930781,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-05-01"},5835,{"$f":"SUM(C31:C42)","v":3338},81,897,3,406,null,"2022-04-01",329,186,5,79,0,7,4384.6057140000003]
["2023-06-01",640,449,4,91,0,49,3444.5510199999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-06-01"},6012,{"$f":"SUM(C32:C43)","v":3572},78,{"$f":"SUM(E32:E43)","v":921},{"$f":"SUM(F32:F43)","v":2},436,null,"2022-05-01",394,246,4,76,1,36,3896.6563879999999]
["2023-07-01",695,413,6,116,0,40,3578.8139999999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-07-01"},6255,{"$f":"SUM(C33:C44)","v":3567},{"$f":"SUM(D33:D44)","v":76},{"$f":"SUM(E33:E44)","v":981},{"$f":"SUM(F33:F44)","v":2},{"$f":"SUM(G33:G44)","v":449},null,"2022-06-01",487,210,7,70,1,19,3997.4878939999999]
["2023-08-01",1003,418,8,186,0,47,3724.1510629999998,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-08-01"},{"$f":"SUM(B34:B45)","v":6753},3648,75,{"$f":"SUM(E34:E45)","v":1104},{"$f":"SUM(F34:F45)","v":2},471,null,"2022-07-01",427,417,9,56,0,28,3584.5535709999999]
["2023-09-01",3524,432,3,383,0,91,3420.8219779999999,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-09-01"},9868,3841,70,{"$f":"SUM(E35:E46)","v":1421},1,530,null,"2022-08-01",492,332,9,63,0,25,4211.5339999999997]
["2023-10-01",423,988,3,413,0,53,3354.6698110000002,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-10-01"},{"$f":"SUM(B36:B47)","v":9844},{"$f":"SUM(C36:C47)","v":4544},{"$f":"SUM(D36:D47)","v":70},{"$f":"SUM(E36:E47)","v":1764},1,547,null,"2022-09-01",392,236,8,73,1,33,4464.692121]
["2023-11-01",469,1711,9,197,0,42,4025.8597610000002,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-11-01"},{"$f":"SUM(B37:B48)","v":9818},{"$f":"SUM(C37:C48)","v":6003},{"$f":"SUM(D37:D48)","v":76},{"$f":"SUM(E37:E48)","v":1882},{"$f":"SUM(F37:F48)","v":0},{"$f":"SUM(G37:G48)","v":560},null,"2022-10-01",417,279,3,64,0,37,3634.3567560000001]
["2023-12-01",209,330,3,43,0,73,3342.4386300000001,null,{"$f":"vELDDashboard[[#This Row],[Period]]","v":"2023-12-01"},{"$f":"SUM(B38:B49)","v":9676},{"$f":"SUM(C38:C49)","v":6077},{"$f":"SUM(D38:D49)","v":73},{"$f":"SUM(E38:E49)","v":1854},{"$f":"SUM(F38:F49)","v":0},{"$f":"SUM(G38:G49)","v":601},null,"2022-11-01",427,243,3,84,1,29,4357.8310339999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",289,251,6,69,0,32,3895.4978120000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",489,294,8,69,0,55,3662.1283629999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",508,198,3,70,0,19,4284.5473679999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",452,294,9,106,0,34,3586.0755880000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]

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