{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Backing Sheet Data","vPLDashboard","Year Calculations"],"not_rendered":{"charts":4,"images":1,"macros":0,"external_links":1,"defined_names":3,"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,1832,null,"Left process at stage 1:",null,null,null,1286,null,"Left process at stage 2:",null,null,null,82,null,"Exited process:",null,null,null,429,null,"Settled:",null,null,208]
[]
["Δ from last month:",null,null,-742,null,"Δ from last month:",null,null,null,-233,null,"Δ from last month:",null,null,null,9,null,"Δ from last month:",null,null,null,-119,null,"Δ from last month:",null,null,-64]
[]
["Rolling 12 months:",null,null,34023,null,"Rolling 12 months:",null,null,null,19810,null,"Rolling 12 months:",null,null,null,988,null,"Rolling 12 months:",null,null,null,6315,null,"Rolling 12 months:",null,null,3060]
[]
["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,1034,null,1227,null,-193]
["Other",null,null,null,null,null,null,251,null,287,null,-36]
["Total",null,null,null,null,null,null,1285,null,1514,null,-229]
["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,1,null,0,null,1]
["Settlement pack repudiated:",null,null,null,null,null,null,2,null,0,null,2]
["Settlement pack timeout:",null,null,null,null,null,null,28,null,21,null,7]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,51,null,52,null,-1]
["Total",null,null,null,null,null,null,82,null,73,null,9]

{"sheet":"Backing Sheet Data","index":1,"n_rows":84,"n_cols":13,"rows_kept":84,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,3,3,4],[21,3,21,4],[8,7,8,8]]}
["Reporting date","2024-12-01"]
["Previous month","2024-11-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"]
["2024-01-01",38089,null,"2024-01-01",5719.2117390000003,null,null,1034,251,1,2,28,51]
["2024-02-01",37848,null,"2024-02-01",5574.1403749999999]
["2024-03-01",37220,null,"2024-03-01",6120.2103770000003,null,null,"CNF Sent Monthly Volumes Chart Data"]
["2024-04-01",37468,null,"2024-04-01",5887.2665459999998]
["2024-05-01",36982,null,"2024-05-01",6260.8445490000004,null,null,"Sum of ClaimCount","Column Labels"]
["2024-06-01",36178,null,"2024-06-01",6529.5757910000002,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total"]
["2024-07-01",35842,null,"2024-07-01",6772.5555430000004,null,null,"2024-01-01",7523,3163,451,2497,13634]
["2024-08-01",35217,null,"2024-08-01",6246.9163550000003,null,null,"2024-02-01",7263,3056,438,2272,13029]
["2024-09-01",35113,null,"2024-09-01",6373.1692849999999,null,null,"2024-03-01",6804,2939,570,2290,12603]
["2024-10-01",34946,null,"2024-10-01",6704.6259920000002,null,null,"2024-04-01",7633,2983,503,2284,13403]
["2024-11-01",34450,null,"2024-11-01",6611.7032099999997,null,null,"2024-05-01",7112,2690,326,2007,12135]
["2024-12-01",34023,null,"2024-12-01",6586.1024029999999,null,null,"2024-06-01",6946,2647,296,1935,11824]
[null,null,null,"Grand Total",75386.32216499999,null,null,"2024-07-01",8157,3025,264,2249,13695]
[null,null,null,null,null,null,null,"2024-08-01",7125,2816,232,2021,12194]
[null,null,null,null,null,null,null,"2024-09-01",7359,2995,490,1973,12817]
[null,18248,null,"CNF Sent Monthly Volumes",null,null,null,"2024-10-01",8239,3152,302,2122,13815]
["Exit Process Reason","Total",null,null,null,null,null,"2024-11-01",6974,2725,155,1879,11733]
["Interim Payment request not answered and/or paid on time",75,null,"DatePeriod","ClaimType","ClaimCount",null,"2024-12-01",5969,1832,102,1397,9300]
["Failure to acknowledge CNF on time",68,null,"2024-09-01","EL",1973,null,"Grand Total",87104,34023,4129,24926,150182]
["Incomplete information provided on CNF",1423,null,"2024-02-01","EL",2272]
["Stage 1 costs not paid on time",149,null,"2024-04-01","EL",2284]
["Value of claim exceeds the upper limit",335,null,"2024-10-01","EL",2122]
["Claim is too complex for process",76,null,"2023-10-01","EL",1698]
["Withdrawl of claim",92,null,"2023-11-01","EL",2525]
["Claim requires further investigation",8395,null,"2024-06-01","EL",1935]
["Interim Payment partial offer not accepted",5,null,"2024-01-01","EL",2497]
["Value of claim below £1,000",29,null,"2024-07-01","EL",2249]
["Interim payment for child claimant",2,null,"2024-03-01","EL",2290]
["Duplicated claim",647,null,"2024-08-01","EL",2021]
["Failure to provide adequate loss of earnings details",4,null,"2024-12-01","EL",1397]
["Other",6920,null,"2024-11-01","EL",1879]
["Withdrawal of offer",28,null,"2023-12-01","EL",1618]
[null,null,null,"2024-05-01","EL",2007]
[null,null,null,"2024-08-01","ELD",232]
[null,null,null,"2024-12-01","ELD",102]
[null,null,null,"2024-01-01","ELD",451]
[null,null,null,"2024-03-01","ELD",570]
[null,null,null,"2024-10-01","ELD",302]
[null,null,null,"2023-11-01","ELD",468]
[null,null,null,"2024-07-01","ELD",264]
[null,null,null,"2024-05-01","ELD",326]
[null,null,null,"2024-04-01","ELD",503]
[null,null,null,"2023-10-01","ELD",286]
[null,null,null,"2024-06-01","ELD",296]
[null,null,null,"2024-02-01","ELD",438]
[null,null,null,"2023-12-01","ELD",211]
[null,null,null,"2024-09-01","ELD",490]
[null,null,null,"2024-11-01","ELD",155]
[null,null,null,"2023-10-01","PL",2202]
[null,null,null,"2023-11-01","PL",3235]
[null,null,null,"2024-11-01","PL",2725]
[null,null,null,"2024-03-01","PL",2939]
[null,null,null,"2024-05-01","PL",2690]
[null,null,null,"2024-01-01","PL",3163]
[null,null,null,"2024-08-01","PL",2816]
[null,null,null,"2024-12-01","PL",1832]
[null,null,null,"2024-09-01","PL",2995]
[null,null,null,"2024-02-01","PL",3056]
[null,null,null,"2024-06-01","PL",2647]
[null,null,null,"2024-04-01","PL",2983]
[null,null,null,"2024-10-01","PL",3152]
[null,null,null,"2024-07-01","PL",3025]
[null,null,null,"2023-12-01","PL",2259]
[null,null,null,"2024-06-01","RTA",6946]
[null,null,null,"2023-12-01","RTA",5702]
[null,null,null,"2024-03-01","RTA",6804]
[null,null,null,"2024-09-01","RTA",7359]
[null,null,null,"2023-10-01","RTA",5421]
[null,null,null,"2024-10-01","RTA",8239]
[null,null,null,"2024-01-01","RTA",7523]
[null,null,null,"2023-11-01","RTA",7718]
[null,null,null,"2024-04-01","RTA",7633]
[null,null,null,"2024-05-01","RTA",7112]
[null,null,null,"2024-12-01","RTA",5969]
[null,null,null,"2024-11-01","RTA",6974]
[null,null,null,"2024-08-01","RTA",7125]
[null,null,null,"2024-02-01","RTA",7263]
[null,null,null,"2024-07-01","RTA",8157]

{"sheet":"vPLDashboard","index":2,"n_rows":74,"n_cols":25,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"SUBTOTAL(9,vPLDashboard[CNFs Sent])","v":162931},{"$f":"SUBTOTAL(9,vPLDashboard[CNFs left at Stage 1])","v":85772},{"$f":"SUBTOTAL(9,vPLDashboard[Stage 2 Exit])","v":1811},{"$f":"SUBTOTAL(9,vPLDashboard[Exit process])","v":28221},{"$f":"SUBTOTAL(9,vPLDashboard[Court Pack])","v":2509},{"$f":"SUBTOTAL(9,vPLDashboard[Settled claims])","v":12469},{"$f":"SUBTOTAL(9,vPLDashboard[General Damages])","v":372213.13759400003},null,null,null,null,null,null,null,null,null,"* Oct 22 to Aug 24 fully refreshed - 18/09/2024"]
["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-01-01",437,0,0,0,0,1,3000,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-01-01"},null,null,null,null,null,null,null,"2019-01-01",4652,3001,60,818,82,538,4257.2791070000003]
["2019-02-01",429,0,0,0,0,1,2500,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-02-01"},null,null,null,null,null,null,null,"2019-02-01",4582,2096,55,615,66,546,3956.2582050000001]
["2019-03-01",482,0,0,0,0,4,3459.4,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-03-01"},null,null,null,null,null,null,null,"2019-03-01",4831,2831,45,773,82,643,4356.284447]
["2019-04-01",469,0,0,0,0,2,1550,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-04-01"},null,null,null,null,null,null,null,"2019-04-01",4401,2782,50,729,69,514,4257.751381]
["2019-06-01",447,0,0,0,0,2,3650,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-06-01"},null,null,null,null,null,null,null,"2019-05-01",4374,2882,45,850,72,545,4283.9964950000003]
["2019-08-01",1227,0,0,0,0,2,3950,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-08-01"},null,null,null,null,null,null,null,"2019-06-01",4188,2614,61,729,79,476,4252.704495]
["2019-09-01",1472,15,0,6,2,5,3448.9920000000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-09-01"},null,null,null,null,null,null,null,"2019-07-01",5078,2851,52,889,78,569,4552.9510890000001]
["2019-10-01",1807,833,21,269,31,70,4535.6019999999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-10-01"},null,null,null,null,null,null,null,"2019-08-01",4784,2607,44,780,82,472,4406.4034320000001]
["2019-11-01",1737,784,16,256,26,49,4310.3689789999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-11-01"},null,null,null,null,null,null,null,"2019-09-01",4514,2850,45,791,59,480,4234.2869369999999]
["2019-12-01",1244,790,13,258,19,56,4710.399821,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-12-01"},null,null,null,null,null,null,null,"2019-10-01",4860,2554,67,851,89,550,4512.5319449999997]
["2020-01-01",1799,841,17,287,16,61,5458.2388520000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-01-01"},null,null,null,null,null,null,null,"2019-11-01",4516,2210,40,806,77,511,4165.4439329999996]
["2020-02-01",1724,618,16,252,28,66,5486.1056060000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-02-01"},{"$f":"SUM(B3:B14)","v":13274},{"$f":"SUM(C3:C14)","v":3881},{"$f":"SUM(D3:D14)","v":83},1328,122,319,null,"2019-12-01",3415,2110,43,724,58,430,4213.0240460000005]
["2020-03-01",1598,887,27,348,29,72,4699.6293050000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-03-01"},{"$f":"SUM(B4:B15)","v":14435},{"$f":"SUM(C4:C15)","v":4768},{"$f":"SUM(D4:D15)","v":110},{"$f":"SUM(E4:E15)","v":1676},{"$f":"SUM(F4:F15)","v":151},{"$f":"SUM(G4:G15)","v":390},null,"2020-01-01",4668,2270,40,806,62,515,4338.7701550000002]
["2020-04-01",1022,834,16,282,22,53,4258.4783010000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-04-01"},{"$f":"SUM(B5:B16)","v":15028},{"$f":"SUM(C5:C16)","v":5602},126,1958,173,442,null,"2020-02-01",4534,1714,41,689,84,491,4327.5731969999997]
["2020-05-01",887,629,9,230,25,61,4877.4454089999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-05-01"},{"$f":"SUM(B6:B17)","v":15433},6231,135,2188,198,499,null,"2020-03-01",4310,2417,70,878,74,497,4435.1404220000004]
["2020-06-01",1078,514,17,187,20,57,4733.2840349999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-06-01"},16042,6745,{"$f":"SUM(D7:D18)","v":152},{"$f":"SUM(E7:E18)","v":2375},{"$f":"SUM(F7:F18)","v":218},{"$f":"SUM(G7:G18)","v":554},null,"2020-04-01",2857,2362,49,754,67,463,4444.0043409999998]
["2020-07-01",1328,518,15,198,16,56,4929.1396420000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-07-01"},16923,{"$f":"SUM(C8:C19)","v":7263},167,2573,234,608,null,"2020-05-01",2284,1801,32,608,72,392,4446.4218870000004]
["2020-08-01",1176,468,10,180,22,37,5154.5883780000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-08-01"},16872,7731,177,2753,256,643,null,"2020-06-01",2713,1512,42,513,56,361,4457.8814949999996]
["2020-09-01",1537,590,14,208,24,41,5543.31,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-09-01"},16937,8306,191,2955,278,679,null,"2020-07-01",3147,1378,37,488,47,310,4767.5551290000003]
["2020-10-01",1564,577,15,248,18,53,5127.7267920000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-10-01"},16694,8050,185,2934,265,662,null,"2020-08-01",2544,1217,30,422,35,228,4843.45057]
["2020-11-01",1444,685,18,250,18,74,4544.2843240000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-11-01"},16401,7951,187,2928,257,687,null,"2020-09-01",3548,1629,35,545,51,325,4378.5079999999998]
["2020-12-01",1078,593,8,259,26,71,5332.6018299999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-12-01"},16235,7754,182,2929,264,702,null,"2020-10-01",3817,1749,41,623,49,328,4633.476463]
["2021-01-01",1388,565,6,224,25,70,5071.0244279999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-01-01"},15824,7478,171,2866,273,711,null,"2020-11-01",3172,1907,48,624,43,343,4743.3511660000004]
["2021-02-01",1284,463,9,171,19,59,6086.0652540000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-02-01"},15384,7323,164,2785,264,704,null,"2020-12-01",2510,1794,29,576,55,306,4367.7515030000004]
["2021-03-01",1558,616,19,254,24,69,4898.7985500000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-03-01"},15344,7052,156,2691,259,701,null,"2021-01-01",2953,1521,21,529,43,356,4548.3069660000001]
["2021-04-01",1369,560,9,229,33,69,5772.4582600000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-04-01"},15691,6778,149,2638,270,717,null,"2021-02-01",1671,1046,23,324,34,303,4595.1910230000003]
["2021-05-01",1337,525,14,218,29,58,5382.205344,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-05-01"},16141,6674,154,2626,274,714,null,"2021-03-01",3276,1716,44,588,50,408,4982.4639699999998]
["2021-06-01",1621,602,9,271,32,57,6016.210701,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-06-01"},16684,6762,146,2710,286,714,null,"2021-04-01",2692,1432,32,528,59,338,4664.8669229999996]
["2021-07-01",1983,573,9,264,32,64,5514.254062,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-07-01"},17339,6817,140,2776,302,722,null,"2021-05-01",2707,1219,31,474,60,297,5076.2545449999998]
["2021-08-01",3043,673,14,272,26,71,5754.2157740000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-08-01"},19206,7022,144,2868,306,756,null,"2021-06-01",3066,1555,43,547,61,338,4990.9703550000004]
["2021-09-01",3593,1175,27,402,33,178,5592.961123,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-09-01"},21262,7607,157,3062,315,893,null,"2021-07-01",3155,1538,32,552,56,313,4951.6493609999998]
["2021-10-01",3512,1914,34,638,61,314,5406.0533429999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-10-01"},23210,8944,176,3452,358,1154,null,"2021-08-01",3244,1660,29,527,45,294,5183.9015980000004]
["2021-11-01",3495,2063,36,658,40,324,5606.8653389999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-11-01"},25261,10322,194,3860,380,1404,null,"2021-09-01",3530,1600,35,544,43,293,4979.2150170000004]
["2021-12-01",2474,1943,29,562,36,303,5562.3535309999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-12-01"},26657,11672,215,4163,390,1636,null,"2021-10-01",3347,1583,34,600,61,315,4870.601936]
["2022-01-01",3232,1792,22,604,49,331,5274.5152260000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-01-01"},28501,12899,231,4543,414,1897,null,"2021-11-01",3381,1680,36,618,40,322,4918.6393779999999]
["2022-02-01",3183,1363,34,476,48,310,5462.3933219999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-02-01"},30400,13799,256,4848,443,2148,null,"2021-12-01",2388,1611,29,545,36,305,5012.3989499999998]
["2022-03-01",3464,1974,54,660,51,296,4932.0843580000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-03-01"},32306,15157,291,5254,470,2375,null,"2022-01-01",3017,1515,22,576,49,347,4723.2562529999996]
["2022-04-01",2780,1735,43,561,58,295,5319.9981690000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-04-01"},33717,16332,325,5586,495,2601,null,"2022-02-01",3075,1158,34,460,48,318,4899.5186469999999]
["2022-05-01",3171,1863,47,630,47,366,5326.3016660000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-05-01"},35551,17670,358,5998,513,2909,null,"2022-03-01",3300,1795,58,684,55,345,4537.9947240000001]
["2022-06-01",3009,1716,53,541,50,333,5471.5631530000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-06-01"},36939,18784,402,6268,531,3185,null,"2022-04-01",2624,1425,43,533,58,293,4829.560853]
["2022-07-01",3209,1769,42,543,53,271,5507.3383389999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-07-01"},38165,19980,435,6547,552,3392,null,"2022-05-01",3003,1533,47,591,47,366,4777.5615299999999]
["2022-08-01",3600,1936,51,576,45,254,6116.3995269999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-08-01"},38722,21243,472,6851,571,3575,null,"2022-06-01",2851,1480,53,511,50,333,4807.4264860000003]
["2022-09-01",3369,1906,29,618,49,228,5522.0920169999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-09-01"},38498,21974,474,7067,587,3625,null,"2022-07-01",2981,1525,42,526,54,283,4909.1396809999997]
["2022-10-01",3332,1970,35,637,57,273,5643.0429670000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-10-01"},38318,22030,475,7066,583,3584,null,"2022-08-01",3364,1640,51,563,45,262,5540.7254190000003]
["2022-11-01",3324,2008,40,598,67,281,5226.4136289999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-11-01"},38147,21975,479,7006,610,3541,null,"2022-09-01",3260,1644,29,614,49,246,4830.3337389999997]
["2022-12-01",2295,1921,37,534,45,201,5676.6291039999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-12-01"},37968,21953,487,6978,619,3439,null,"2022-10-01",3332,1970,35,637,57,273,5643.0429670000003]
["2023-01-01",3373,1788,28,576,55,267,6191.6449810000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-01-01"},38109,21949,493,6950,625,3375,null,"2022-11-01",3322,2008,40,598,67,281,5226.4136289999997]
["2023-02-01",3297,1300,37,493,41,274,5775.4877370000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-02-01"},38223,21886,496,6967,618,3339,null,"2022-12-01",2295,1921,37,534,45,201,5676.6291039999996]
["2023-03-01",3567,2193,35,675,60,331,5439.9285190000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-03-01"},38326,22105,477,6982,627,3374,null,"2023-01-01",3372,1788,28,576,55,267,6191.6449810000004]
["2023-04-01",2733,1675,27,533,50,268,5937.0847759999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-04-01"},38279,22045,461,6954,619,3347,null,"2023-02-01",3297,1300,37,493,41,274,5775.4877370000004]
["2023-05-01",3172,1807,36,547,53,272,5417.1234189999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-05-01"},38280,21989,450,6871,625,3253,null,"2023-03-01",3568,2193,35,675,60,331,5439.9285190000001]
["2023-06-01",3447,1970,44,620,54,293,6128.1987710000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-06-01"},38718,22243,441,6950,629,3213,null,"2023-04-01",2733,1675,27,533,50,268,5937.0847759999997]
["2023-07-01",3352,1960,34,642,62,265,5479.1475840000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-07-01"},38861,22434,433,7049,638,3207,null,"2023-05-01",3173,1807,36,547,53,272,5417.1234189999996]
["2023-08-01",3398,1929,38,656,48,281,5596.6673300000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-08-01"},38659,22427,420,7129,641,3234,null,"2023-06-01",3448,1970,44,620,54,293,6128.1987710000003]
["2023-09-01",3142,1973,42,614,54,287,6067.6850519999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-09-01"},38432,22494,433,7125,646,3293,null,"2023-07-01",3352,1960,34,642,62,265,5479.1475840000003]
["2023-10-01",3322,1969,42,601,43,317,5802.9801889999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-10-01"},38422,22493,440,7089,632,3337,null,"2023-08-01",3398,1929,38,656,48,281,5596.6673300000002]
["2023-11-01",3235,1998,41,591,56,329,5550.8857440000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-11-01"},38333,22483,441,7082,621,3385,null,"2023-09-01",3142,1973,42,614,54,287,6067.6850519999998]
["2023-12-01",2259,1599,36,499,31,256,6038.1488669999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-12-01"},38297,22161,440,7047,607,3440,null,"2023-10-01",3322,1969,42,601,43,317,5802.9801889999999]
["2024-01-01",3163,1885,43,590,49,299,5719.2117390000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-01-01"},38087,22258,455,7061,601,3472,null,"2023-11-01",3234,1998,41,591,56,329,5550.8857440000002]
["2024-02-01",3056,1524,33,507,48,320,5574.1403749999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-02-01"},37846,22482,451,7075,608,3518,null,"2023-12-01",2259,1599,36,499,31,256,6038.1488669999999]
["2024-03-01",2939,1716,40,528,43,265,6120.2103770000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-03-01"},37218,22005,456,6928,591,3452,null,"2024-01-01",3163,1885,43,590,49,299,5719.2117390000003]
["2024-04-01",2983,1754,36,499,50,278,5887.2665459999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-04-01"},37468,22084,465,6894,591,3462,null,"2024-02-01",3056,1524,33,507,48,320,5574.1403749999999]
["2024-05-01",2690,1801,32,474,52,222,6260.8445490000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-05-01"},36986,22078,461,6821,590,3412,null,"2024-03-01",2940,1716,40,528,43,265,6120.2103770000003]
["2024-06-01",2647,1642,36,513,35,221,6529.5757910000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-06-01"},{"$f":"SUM(B55:B66)","v":36186},21750,453,6714,571,3340,null,"2024-04-01",2981,1747,36,497,50,278,5887.2665459999998]
["2024-07-01",3025,1814,47,601,45,276,6772.5555430000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-07-01"},{"$f":"SUM(B56:B67)","v":35859},{"$f":"SUM(C56:C67)","v":21604},{"$f":"SUM(D56:D67)","v":466},{"$f":"SUM(E56:E67)","v":6673},{"$f":"SUM(F56:F67)","v":554},{"$f":"SUM(G56:G67)","v":3351},null,"2024-05-01",2687,1512,32,433,52,227,6145.9108370000004]
["2024-08-01",2816,1599,43,497,42,214,6246.9163550000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-08-01"},{"$f":"SUM(B57:B68)","v":35277},21274,471,6514,548,3284,null,"2024-06-01",2644,1353,36,504,35,225,6442.3833329999998]
["2024-09-01",2995,1593,36,525,37,224,6373.1692849999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-09-01"},{"$f":"SUM(B58:B69)","v":35130},{"$f":"SUM(C58:C69)","v":20894},{"$f":"SUM(D58:D69)","v":465},{"$f":"SUM(E58:E69)","v":6425},{"$f":"SUM(F58:F69)","v":531},{"$f":"SUM(G58:G69)","v":3221},null,"2024-07-01",3016,1512,47,598,45,285,6727.4583149999999]
["2024-10-01",3152,1649,39,604,47,262,6704.6259920000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-10-01"},34960,20574,462,6428,535,3166,null,"2024-08-01",2658,1260,37,479,38,205,6325.6983899999996]
["2024-11-01",2725,1547,21,548,52,271,6611.7032099999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-11-01"},{"$f":"SUM(B60:B71)","v":34450},{"$f":"SUM(C60:C71)","v":20123},{"$f":"SUM(D60:D71)","v":442},{"$f":"SUM(E60:E71)","v":6385},{"$f":"SUM(F60:F71)","v":531},{"$f":"SUM(G60:G71)","v":3108},null,"2024-09-01",2594,1304,36,485,35,225,6390.8602220000002]
["2024-12-01",1832,1286,31,429,51,208,6586.1024029999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2024-12-01"},34023,19810,437,6315,551,3060,null,"2024-10-01",2838,1525,39,572,45,256,6742.001835]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-01",2574,1519,21,548,52,272,6602.1013599999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-01",1832,1286,31,429,51,208,6586.1024029999999]

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