{"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":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,2020,null,"Left process at stage 1:",null,null,null,1260,null,"Left process at stage 2:",null,null,null,66,null,"Exited process:",null,null,null,414,null,"Settled:",null,null,277]
[]
["Δ from last month:",null,null,-1003,null,"Δ from last month:",null,null,null,-397,null,"Δ from last month:",null,null,null,-31,null,"Δ from last month:",null,null,null,-125,null,"Δ from last month:",null,null,-69]
[]
["Rolling 12 months:",null,null,38062,null,"Rolling 12 months:",null,null,null,19464,null,"Rolling 12 months:",null,null,null,1045,null,"Rolling 12 months:",null,null,null,6485,null,"Rolling 12 months:",null,null,3536]
[]
["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,1033,null,1270,null,-237]
["Other",null,null,null,null,null,null,224,null,385,null,-161]
["Total",null,null,null,null,null,null,1257,null,1655,null,-398]
["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,0,null,0,null,0]
["Settlement pack timeout:",null,null,null,null,null,null,36,null,41,null,-5]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,30,null,56,null,-26]
["Total",null,null,null,null,null,null,66,null,97,null,-31]

{"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",38043,null,null,"2023-01-01",6121.4730989999998,null,null,1033,224,0,0,36,30]
["2023-02-01",38155,null,null,"2023-02-01",5689.4435579999999]
["2023-03-01",38263,null,null,"2023-03-01",5407.7655189999996,null,null,"CNF Sent Monthly Volumes Chart Data"]
["2023-04-01",38215,null,null,"2023-04-01",5843.6846349999996]
["2023-05-01",38214,null,null,"2023-05-01",5319.3414069999999,null,null,"Sum of ClaimCount","Column Labels"]
["2023-06-01",38089,null,null,"2023-06-01",5923.4958550000001,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total"]
["2023-07-01",38019,null,null,"2023-07-01",5515.1897760000002,null,null,"2023-01-01",7409,3373,501,2542,13825]
["2023-08-01",37444,null,null,"2023-08-01",5556.8614729999999,null,null,"2023-02-01",7487,3297,521,2355,13660]
["2023-09-01",38416,null,null,"2023-09-01",5929.4370200000003,null,null,"2023-03-01",7465,3568,533,2657,14223]
["2023-10-01",38150,null,null,"2023-10-01",5615.1355149999999,null,null,"2023-04-01",6139,2734,543,2151,11567]
["2023-11-01",38338,null,null,"2023-11-01",5437.043764,null,null,"2023-05-01",6874,3172,615,2215,12876]
["2023-12-01",38062,null,null,"2023-12-01",5552.4769310000001,null,null,"2023-06-01",7707,3452,640,2561,14360]
[null,null,null,null,"Grand Total",67911.348551999996,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,12014,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",5652,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2023-12-01",5624,2020,209,1506,9359]
["Other",4540,null,null,"2022-10-01","EL",1621,null,"Grand Total",86134,38062,9676,28288,162160]
["Incomplete information provided on CNF",951,null,null,"2022-11-01","EL",2627]
["Duplicated claim",427,null,null,"2022-12-01","EL",1666]
["Value of claim exceeds the upper limit",131,null,null,"2023-01-01","EL",2542]
["Stage 1 costs not paid on time",83,null,null,"2023-02-01","EL",2355]
["Withdrawl of claim",62,null,null,"2023-03-01","EL",2657]
["Claim is too complex for process",43,null,null,"2023-04-01","EL",2151]
["Interim Payment request not answered and/or paid on time",40,null,null,"2023-05-01","EL",2215]
["Failure to acknowledge CNF on time",35,null,null,"2023-06-01","EL",2561]
["Value of claim below £1,000",22,null,null,"2023-07-01","EL",2470]
["Withdrawal of offer",21,null,null,"2023-08-01","EL",2447]
["Failure to provide adequate loss of earnings details",4,null,null,"2023-09-01","EL",2369]
["Interim payment for child claimant",2,null,null,"2023-10-01","EL",2491]
["Interim Payment partial offer not accepted",1,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":"vPLDashboard","index":2,"n_rows":62,"n_cols":25,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"SUBTOTAL(9,vPLDashboard[CNFs Sent])","v":129703},{"$f":"SUBTOTAL(9,vPLDashboard[CNFs left at Stage 1])","v":54208},{"$f":"SUBTOTAL(9,vPLDashboard[Stage 2 Exit])","v":1367},{"$f":"SUBTOTAL(9,vPLDashboard[Exit process])","v":20321},{"$f":"SUBTOTAL(9,vPLDashboard[Court Pack])","v":1942},{"$f":"SUBTOTAL(9,vPLDashboard[Settled claims])","v":9704},{"$f":"SUBTOTAL(9,vPLDashboard[General Damages])","v":286631.22610600002}]
["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-05-01",487,0,0,0,0,1,0,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-05-01"},null,null,null,null,null,null,null,"2019-05-01",4374,2882,45,850,72,545,4283.9964950000003]
["2019-06-01",447,0,0,0,0,3,2433.333333,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-06-01"},null,null,null,null,null,null,null,"2019-06-01",4188,2614,61,729,79,476,4252.704495]
["2019-07-01",557,0,0,0,0,2,0,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-07-01"},null,null,null,null,null,null,null,"2019-07-01",5078,2851,52,889,78,569,4552.9510890000001]
["2019-08-01",1226,0,0,0,0,3,2633.333333,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-08-01"},null,null,null,null,null,null,null,"2019-08-01",4784,2607,44,780,82,472,4406.4034320000001]
["2019-09-01",1472,0,0,5,2,5,3448.9920000000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-09-01"},null,null,null,null,null,null,null,"2019-09-01",4514,2850,45,791,59,480,4234.2869369999999]
["2019-10-01",1807,434,20,251,31,75,4484.7729330000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-10-01"},null,null,null,null,null,null,null,"2019-10-01",4860,2554,67,851,89,550,4512.5319449999997]
["2019-11-01",1737,444,16,245,26,54,4228.0200000000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-11-01"},null,null,null,null,null,null,null,"2019-11-01",4516,2210,40,806,77,511,4165.4439329999996]
["2019-12-01",1244,487,13,225,19,62,4673.9756450000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2019-12-01"},{"$f":"SUM(B3:B14)","v":10794},{"$f":"SUM(C3:C14)","v":1365},{"$f":"SUM(D3:D14)","v":49},726,78,213,null,"2019-12-01",3415,2110,43,724,58,430,4213.0240460000005]
["2020-01-01",1799,519,17,265,16,65,5392.5680000000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-01-01"},{"$f":"SUM(B4:B15)","v":12156},1884,{"$f":"SUM(D4:D15)","v":66},{"$f":"SUM(E4:E15)","v":991},{"$f":"SUM(F4:F15)","v":94},{"$f":"SUM(G4:G15)","v":277},null,"2020-01-01",4668,2270,40,806,62,515,4338.7701550000002]
["2020-02-01",1724,361,16,234,28,68,5119.1948519999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-02-01"},{"$f":"SUM(B5:B16)","v":13451},2245,82,1225,122,344,null,"2020-02-01",4534,1714,41,689,84,491,4327.5731969999997]
["2020-03-01",1598,554,27,311,29,80,4576.466375,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-03-01"},{"$f":"SUM(B6:B17)","v":14567},2799,109,1536,151,420,null,"2020-03-01",4310,2417,70,878,74,497,4435.1404220000004]
["2020-04-01",1022,554,16,250,22,61,4130.032295,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-04-01"},{"$f":"SUM(B7:B18)","v":15120},3353,125,1786,173,479,null,"2020-04-01",2857,2362,49,754,67,463,4444.0043409999998]
["2020-05-01",886,427,9,204,25,67,4772.16194,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-05-01"},{"$f":"SUM(B8:B19)","v":15519},3780,134,1990,198,545,null,"2020-05-01",2284,1801,32,608,72,392,4446.4218870000004]
["2020-06-01",1078,322,17,171,20,66,4911.661212,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-06-01"},{"$f":"SUM(B9:B20)","v":16150},4102,151,2161,218,608,null,"2020-06-01",2713,1512,42,513,56,361,4457.8814949999996]
["2020-07-01",1327,311,15,184,16,59,4888.2428810000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-07-01"},{"$f":"SUM(B10:B21)","v":16920},4413,166,2345,234,665,null,"2020-07-01",3147,1378,37,488,47,310,4767.5551290000003]
["2020-08-01",1176,283,10,165,22,41,4949.2626819999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-08-01"},{"$f":"SUM(B11:B22)","v":16870},4696,176,2510,256,703,null,"2020-08-01",2544,1217,30,422,35,228,4843.45057]
["2020-09-01",1536,377,14,189,24,44,5410.3163629999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-09-01"},{"$f":"SUM(B12:B23)","v":16934},5073,190,2694,278,742,null,"2020-09-01",3548,1629,35,545,51,325,4378.5079999999998]
["2020-10-01",1564,351,15,223,18,56,4883.3842850000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-10-01"},{"$f":"SUM(B13:B24)","v":16691},4990,185,2666,265,723,null,"2020-10-01",3817,1749,41,623,49,328,4633.476463]
["2020-11-01",1444,418,18,234,18,78,4326.7898709999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-11-01"},{"$f":"SUM(B14:B25)","v":16398},4964,187,2655,257,747,null,"2020-11-01",3172,1907,48,624,43,343,4743.3511660000004]
["2020-12-01",1078,402,8,238,26,75,5165.5623999999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2020-12-01"},{"$f":"SUM(B15:B26)","v":16232},4879,182,2668,264,760,null,"2020-12-01",2510,1794,29,576,55,306,4367.7515030000004]
["2021-01-01",1388,360,6,213,25,77,4824.9446749999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-01-01"},{"$f":"SUM(B16:B27)","v":15821},4720,171,2616,273,772,null,"2021-01-01",2953,1521,21,529,43,356,4548.3069660000001]
["2021-02-01",1284,291,9,157,19,72,5285.445138,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-02-01"},{"$f":"SUM(B17:B28)","v":15381},4650,164,2539,264,776,null,"2021-02-01",1671,1046,23,324,34,303,4595.1910230000003]
["2021-03-01",1558,390,19,234,24,78,4566.398717,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-03-01"},{"$f":"SUM(B18:B29)","v":15341},4486,156,2462,259,774,null,"2021-03-01",3276,1716,44,588,50,408,4982.4639699999998]
["2021-04-01",1369,342,9,212,33,72,5608.8877769999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-04-01"},{"$f":"SUM(B19:B30)","v":15688},4274,149,2424,270,785,null,"2021-04-01",2692,1432,32,528,59,338,4664.8669229999996]
["2021-05-01",1337,329,14,200,29,63,5074.6385710000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-05-01"},{"$f":"SUM(B20:B31)","v":16139},4176,154,2420,274,781,null,"2021-05-01",2707,1219,31,474,60,297,5076.2545449999998]
["2021-06-01",1621,405,9,253,32,65,5502.4930759999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-06-01"},{"$f":"SUM(B21:B32)","v":16682},4259,146,2502,286,780,null,"2021-06-01",3066,1555,43,547,61,338,4990.9703550000004]
["2021-07-01",1983,382,9,251,32,68,5219.2979409999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-07-01"},{"$f":"SUM(B22:B33)","v":17338},4330,140,2569,302,789,null,"2021-07-01",3155,1538,32,552,56,313,4951.6493609999998]
["2021-08-01",3043,462,14,252,26,73,5656.4975340000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-08-01"},{"$f":"SUM(B23:B34)","v":19205},4509,144,2656,306,821,null,"2021-08-01",3244,1660,29,527,45,294,5183.9015980000004]
["2021-09-01",3593,966,27,382,33,184,5457.0221730000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-09-01"},{"$f":"SUM(B24:B35)","v":21262},5098,157,2849,315,961,null,"2021-09-01",3530,1600,35,544,43,293,4979.2150170000004]
["2021-10-01",3511,1696,34,615,61,316,5389.533829,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-10-01"},{"$f":"SUM(B25:B36)","v":23209},6443,176,3241,358,1221,null,"2021-10-01",3347,1583,34,600,61,315,4870.601936]
["2021-11-01",3495,1818,36,642,40,331,5529.4693950000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-11-01"},{"$f":"SUM(B26:B37)","v":25260},7843,194,3649,380,1474,null,"2021-11-01",3381,1680,36,618,40,322,4918.6393779999999]
["2021-12-01",2473,1729,29,544,36,309,5434.4866659999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2021-12-01"},{"$f":"SUM(B27:B38)","v":26655},9170,215,3955,390,1708,null,"2021-12-01",2388,1611,29,545,36,305,5012.3989499999998]
["2022-01-01",3230,1585,22,581,47,335,5184.9492229999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-01-01"},{"$f":"SUM(B28:B39)","v":28497},10395,231,4323,412,1966,null,"2022-01-01",3017,1515,22,576,49,347,4723.2562529999996]
["2022-02-01",3183,1175,33,455,47,314,5400.8182479999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-02-01"},{"$f":"SUM(B29:B40)","v":30396},11279,255,4621,440,2208,null,"2022-02-01",3075,1158,34,460,48,318,4899.5186469999999]
["2022-03-01",3459,1661,50,594,43,293,4897.1288729999997,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-03-01"},{"$f":"SUM(B30:B41)","v":32297},12550,286,4981,459,2423,null,"2022-03-01",3300,1795,58,684,55,345,4537.9947240000001]
["2022-04-01",2780,1532,43,543,58,300,5260.9982,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-04-01"},{"$f":"SUM(B31:B42)","v":33708},13740,320,5312,484,2651,null,"2022-04-01",2624,1425,43,533,58,293,4829.560853]
["2022-05-01",3171,1654,47,587,47,370,5278.6883779999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-05-01"},{"$f":"SUM(B32:B43)","v":35542},15065,353,5699,502,2958,null,"2022-05-01",3003,1533,47,591,47,366,4777.5615299999999]
["2022-06-01",3008,1556,53,510,50,334,5370.8499700000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-06-01"},{"$f":"SUM(B33:B44)","v":36929},16216,397,5956,520,3227,null,"2022-06-01",2851,1480,53,511,50,333,4807.4264860000003]
["2022-07-01",3209,1564,41,499,53,275,5432.5406899999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-07-01"},{"$f":"SUM(B34:B45)","v":38155},17398,429,6204,541,3434,null,"2022-07-01",2981,1525,42,526,54,283,4909.1396809999997]
["2022-08-01",3599,1730,51,513,44,258,6049.2786040000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-08-01"},{"$f":"SUM(B35:B46)","v":38711},18666,466,6465,559,3619,null,"2022-08-01",3364,1640,51,563,45,262,5540.7254190000003]
["2022-09-01",3367,1670,29,565,48,233,5379.9104719999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-09-01"},{"$f":"SUM(B36:B47)","v":38485},19370,468,6648,574,3668,null,"2022-09-01",3260,1644,29,614,49,246,4830.3337389999997]
["2022-10-01",3334,1758,35,588,57,280,5530.0918920000004,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-10-01"},{"$f":"SUM(B37:B48)","v":38308},{"$f":"SUM(C37:C48)","v":19432},{"$f":"SUM(D37:D48)","v":469},6621,570,3632,null,"2022-10-01",3018,1652,35,581,57,272,5091.4652569999998]
["2022-11-01",3324,1754,40,558,66,280,5164.5793919999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-11-01"},{"$f":"SUM(B38:B49)","v":38137},19368,473,6537,596,3581,null,"2022-11-01",3208,1662,40,578,67,286,4630.6309090000004]
["2022-12-01",2296,1691,37,494,45,215,5283.4577200000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2022-12-01"},37960,19330,{"$f":"SUM(D39:D50)","v":481},6487,605,3487,null,"2022-12-01",1855,1631,37,483,45,218,5549.3998620000002]
["2023-01-01",3373,1582,28,533,55,271,6121.4730989999998,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-01-01"},38103,19327,{"$f":"SUM(D40:D51)","v":487},{"$f":"SUM(E40:E51)","v":6439},613,3423,null,"2023-01-01",3153,1506,28,520,55,278,6010.1974099999998]
["2023-02-01",3297,1142,37,465,41,281,5689.4435579999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-02-01"},{"$f":"SUM(B41:B52)","v":38217},{"$f":"SUM(C41:C52)","v":19294},{"$f":"SUM(D41:D52)","v":491},6449,607,3390,null,"2023-02-01",3021,1062,37,441,38,284,5535.8254219999999]
["2023-03-01",3568,1914,35,607,60,337,5407.7655189999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-03-01"},{"$f":"SUM(B42:B53)","v":38326},{"$f":"SUM(C42:C53)","v":19547},476,6462,624,3434,null,"2023-03-01",2991,1633,32,511,56,295,5284.159525]
["2023-04-01",2734,1487,27,493,50,274,5843.6846349999996,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-04-01"},38280,{"$f":"SUM(C43:C54)","v":19502},460,6412,616,3408,null,"2023-04-01",2496,1421,27,482,50,281,5729.2077220000001]
["2023-05-01",3172,1588,36,509,53,277,5319.3414069999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-05-01"},38281,19436,449,6334,622,3315,null,"2023-05-01",2924,1519,36,488,53,284,5256.8928519999999]
["2023-06-01",3452,1752,44,569,53,304,5923.4958550000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-06-01"},38725,19632,440,6393,625,3285,null,"2023-06-01",3032,1660,44,518,51,317,5657.0596210000003]
["2023-07-01",3351,1753,34,588,62,268,5515.1897760000002,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-07-01"},38867,{"$f":"SUM(C46:C57)","v":19821},{"$f":"SUM(D46:D57)","v":433},{"$f":"SUM(E46:E57)","v":6482},{"$f":"SUM(F46:F57)","v":634},{"$f":"SUM(G46:G57)","v":3278},null,"2023-07-01",3113,1669,34,565,62,275,5430.433927]
["2023-08-01",3398,1734,38,624,48,285,5556.8614729999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-08-01"},38666,{"$f":"SUM(C47:C58)","v":19825},{"$f":"SUM(D47:D58)","v":420},6593,{"$f":"SUM(F47:F58)","v":638},{"$f":"SUM(G47:G58)","v":3305},null,"2023-08-01",3155,1666,38,602,48,287,5562.207386]
["2023-09-01",3141,1755,42,562,54,292,5929.4370200000003,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-09-01"},{"$f":"SUM(B48:B59)","v":38440},{"$f":"SUM(C48:C59)","v":19910},{"$f":"SUM(D48:D59)","v":433},6590,{"$f":"SUM(F48:F59)","v":644},{"$f":"SUM(G48:G59)","v":3364},null,"2023-09-01",2846,1671,37,518,35,211,6225.9125590000003]
["2023-10-01",3328,1758,42,565,43,330,5615.1355149999999,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-10-01"},{"$f":"SUM(B49:B60)","v":38434},{"$f":"SUM(C49:C60)","v":19910},440,6567,{"$f":"SUM(F49:F60)","v":630},3414,null,"2023-10-01",3090,1662,42,547,43,334,5562.8584430000001]
["2023-11-01",3228,1739,41,556,56,340,5437.043764,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-11-01"},{"$f":"SUM(B50:B61)","v":38338},19895,441,6565,620,3474,null,"2023-11-01",3023,1657,41,539,56,346,5342.7597679999999]
["2023-12-01",2020,1260,36,414,30,277,5552.4769310000001,null,{"$f":"vPLDashboard[[#This Row],[Period]]","v":"2023-12-01"},{"$f":"SUM(B51:B62)","v":38062},19464,440,6485,605,3536,null,"2023-12-01",2020,1260,36,414,30,277,5552.4769310000001]

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