{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Backing Sheet Data","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":[[16,0,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[15,0,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,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],[11,0,11,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],[12,0,13,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[14,0,14,6],[0,26,1,27],[2,26,3,27],[4,26,5,27],[9,0,9,6],[10,0,10,6],[2,21,3,22],[0,21,1,22],[4,21,5,22],[0,23,1,25],[2,23,3,25],[4,23,5,25],[0,0,1,2],[2,0,3,2],[4,0,5,2],[8,11,8,12],[8,9,8,10],[8,7,8,8],[6,0,7,12],[8,0,8,6],[2,5,3,8],[4,5,5,8],[2,11,3,14],[4,11,5,14],[0,5,1,8],[0,11,1,14],[0,3,1,4],[2,3,3,4],[4,3,5,4],[0,9,1,10],[2,9,3,10],[4,9,5,10],[0,15,1,16],[2,15,3,16],[4,15,5,16],[0,17,1,20],[2,17,3,20],[4,17,5,20]]}
["Total Sent:",null,null,427,null,"Left process at stage 1:",null,null,null,417,null,"Left process at stage 2:",null,null,null,9,null,"Exited process:",null,null,null,56,null,"Settled:",null,null,28]
[]
["Δ from last month:",null,null,-60,null,"Δ from last month:",null,null,null,207,null,"Δ from last month:",null,null,null,1,null,"Δ from last month:",null,null,null,-14,null,"Δ from last month:",null,null,9]
[]
["Rolling 12 months:",null,null,4586,null,"Rolling 12 months:",null,null,null,2574,null,"Rolling 12 months:",null,null,null,67,null,"Rolling 12 months:",null,null,null,921,null,"Rolling 12 months:",null,null,445]
[]
["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,397,null,205,null,192]
["Other",null,null,null,null,null,null,20,null,5,null,15]
["Total",null,null,null,null,null,null,417,null,210,null,207]
["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,3,null,2]
["Settlement pack timeout:",null,null,null,null,null,null,4,null,4,null,0]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,0,null,1,null,-1]
["Total",null,null,null,null,null,null,9,null,8,null,1]

{"sheet":"Backing Sheet Data","index":1,"n_rows":111,"n_cols":42,"rows_kept":111,"cut":false,"hidden":false,"merged":[[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2022-07-01"]
["Previous month","2022-06-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80900,34623,1043,32563,270,4988,418028.18290699989]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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"]
["Rolling 12 CNFs sent",null,null,null,"Average General Damages chart data",null,null,null,"Left Process Breakdown",null,null,null,null,null,null,null,null,"2013-08-01",167,1,0,17,0,0,null,null,"2013-08-01",null,null,null,null,null,null,null,"2013-08-01",167,1,0,17,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01",334,47,0,34,0,0,null,null,"2013-09-01",null,null,null,null,null,null,null,"2013-09-01",334,47,0,34,0,0]
["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",null,null,null,"2013-10-01",620,197,0,92,0,0,null,null,"2013-10-01",null,null,null,null,null,null,null,"2013-10-01",620,197,0,92,0,0]
["2021-08-01",3743,null,null,"2021-08-01",3008.734782,null,null,397,20,0,5,4,0,null,null,null,"2013-11-01",814,284,0,126,0,0,null,null,"2013-11-01",null,null,null,null,null,null,null,"2013-11-01",815,284,0,126,0,0]
["2021-09-01",3749,null,null,"2021-09-01",3245.8401779999999,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01",724,346,2,178,0,3,3309.6666660000001,null,"2013-12-01",null,null,null,null,null,null,null,"2013-12-01",724,346,2,178,0,3,3309.6666660000001]
["2021-10-01",3606,null,null,"2021-10-01",3487.3402169999999,null,null,"CNF Sent Monthly Volumes Chart Data",null,null,null,null,null,null,null,null,"2014-01-01",1071,507,1,268,0,5,5208,null,"2014-01-01",null,null,null,null,null,null,null,"2014-01-01",1071,507,1,268,0,5,5208]
["2021-11-01",3944,null,null,"2021-11-01",3714.3167560000002,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01",998,377,3,212,0,21,5377.8590469999999,null,"2014-02-01",null,null,null,null,null,null,null,"2014-02-01",998,377,3,212,0,21,5377.8590469999999]
["2021-12-01",3986,null,null,"2021-12-01",3321.5448379999998,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2014-03-01",1249,478,3,374,3,34,5664.8529410000001,null,"2014-03-01",null,null,null,null,null,null,null,"2014-03-01",1251,478,3,374,3,34,5664.8529410000001]
["2022-01-01",4012,null,null,"2022-01-01",3527.6668249999998,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total",null,null,null,"2014-04-01",1387,446,5,407,2,32,4801.6068750000004,null,"2014-04-01",null,null,null,null,null,null,null,"2014-04-01",1388,446,5,407,2,32,4801.6068750000004]
["2022-02-01",4046,null,null,"2022-02-01",3380.2033329999999,null,null,"2021-08-01",11505,3283,318,2481,17587,null,null,null,"2014-05-01",1356,545,4,547,4,42,5028.2223800000002,null,"2014-05-01",null,null,null,null,null,null,null,"2014-05-01",1359,545,4,547,4,42,5028.2223800000002]
["2022-03-01",4130,null,null,"2022-03-01",4066.6277770000002,null,null,"2021-09-01",11300,3623,343,2730,17996,null,null,null,"2014-06-01",1351,590,14,589,8,74,4828.9143240000003,null,"2014-06-01",null,null,null,null,null,null,null,"2014-06-01",1351,590,14,589,8,74,4828.9143240000003]
["2022-04-01",4164,null,null,"2022-04-01",4384.6057140000003,null,null,"2021-10-01",10043,3479,357,2566,16445,null,null,null,"2014-07-01",1726,543,19,651,3,86,4877.246744,null,"2014-07-01",11797,4361,51,3495,20,297,null,"2014-07-01",1727,543,19,651,3,86,4877.246744]
["2022-05-01",4351,null,null,"2022-05-01",3896.6563879999999,null,null,"2021-11-01",9821,3500,427,2681,16429,null,null,null,"2014-08-01",1302,512,12,654,10,58,4740.3146550000001,null,"2014-08-01",12932,4872,63,4132,30,355,null,"2014-08-01",1303,512,12,654,10,58,4740.3146550000001]
["2022-06-01",4581,null,null,"2022-06-01",3997.4878939999999,null,null,"2021-12-01",7687,2480,273,2035,12475,null,null,null,"2014-09-01",1604,559,34,703,10,106,4555.8396220000004,null,"2014-09-01",14202,5384,97,4801,40,461,null,"2014-09-01",1605,559,34,703,10,106,4555.8396220000004]
["2022-07-01",4586,null,null,"2022-07-01",3584.5535709999999,null,null,"2022-01-01",8745,3131,378,2473,14727,null,null,null,"2014-10-01",1575,552,34,727,20,106,4804.3396220000004,null,"2014-10-01",15157,5739,131,5436,60,567,null,"2014-10-01",1584,552,34,727,20,106,4804.3396220000004]
[null,null,null,null,"Grand Total",43615.578272999999,null,null,"2022-02-01",7871,3195,317,2477,13860,null,null,null,"2014-11-01",1503,535,31,680,11,83,4192.8449389999996,null,"2014-11-01",15846,5990,162,5990,71,650,null,"2014-11-01",1518,535,31,680,11,83,4192.8449389999996]
[null,null,null,null,null,null,null,null,"2022-03-01",8218,3465,445,2820,14948,null,null,null,"2014-12-01",1303,559,34,705,10,74,4345.0778369999998,null,"2014-12-01",16425,6203,194,6517,81,721,null,"2014-12-01",1309,559,34,705,10,74,4345.0778369999998]
[null,null,null,null,null,null,null,null,"2022-04-01",7247,2783,357,2201,12588,null,null,null,"2015-01-01",1799,583,31,698,12,64,4383.7940619999999,null,"2015-01-01",17153,6279,224,6947,93,780,null,"2015-01-01",1811,583,31,698,12,64,4383.7940619999999]
[null,35722,null,null,"CNF Sent Monthly Volumes",null,null,null,"2022-05-01",7876,3127,459,2528,13990,null,null,null,"2015-02-01",2335,426,28,769,5,70,4623.1801420000002,null,"2015-02-01",18490,6328,249,7504,98,829,null,"2015-02-01",2361,426,28,769,5,70,4623.1801420000002]
["Exit Process Reason","Total",null,null,null,null,null,null,"2022-06-01",7289,2904,485,2404,13082,null,null,null,"2015-03-01",2629,841,21,1143,5,86,4959.1549999999997,null,"2015-03-01",19870,6691,267,8273,100,881,null,"2015-03-01",2647,841,21,1143,5,86,4959.1549999999997]
["Claim requires further investigation",15456,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2022-07-01",7438,2981,427,2257,13103,null,null,null,"2015-04-01",2243,860,28,1182,7,74,4358.1350000000002,null,"2015-04-01",20726,7105,290,9048,105,923,null,"2015-04-01",2254,860,28,1182,7,74,4358.1350000000002]
["Other",10395,null,null,"2021-05-01","RTA",26904,null,"Grand Total",105040,37951,4586,29653,177230,null,null,null,"2015-05-01",1840,781,20,988,5,86,3996.8166270000002,null,"2015-05-01",21210,7341,306,9489,106,967,null,"2015-05-01",1849,781,20,988,5,86,3996.8166270000002]
["Incomplete information provided on CNF",5525,null,null,"2021-06-01","RTA",26133,null,null,null,null,null,null,null,null,null,null,"2015-06-01",1962,999,24,998,4,78,4745.8085890000002,null,"2015-06-01",21821,7750,316,9898,102,971,null,"2015-06-01",1972,999,24,998,4,78,4745.8085890000002]
["Duplicated claim",2859,null,null,"2021-07-01","RTA",14787,null,null,null,null,null,null,null,null,null,null,"2015-07-01",1772,877,31,879,10,92,4072.2803260000001,null,"2015-07-01",21867,8084,328,10126,109,977,null,"2015-07-01",1779,877,31,879,10,92,4072.2803260000001]
["Withdrawal of claim",1033,null,null,"2021-08-01","RTA",11505,null,null,null,null,null,null,null,null,null,null,"2015-08-01",1619,655,26,649,3,74,3784.8224319999999,null,"2015-08-01",22184,8227,342,10121,102,993,null,"2015-08-01",1629,655,26,649,3,74,3784.8224319999999]
["Claim is too complex for process",172,null,null,"2021-09-01","RTA",11300,null,null,null,null,null,null,null,null,null,null,"2015-09-01",1850,705,17,750,7,89,3917.2635949999999,null,"2015-09-01",22430,8373,325,10168,99,976,null,"2015-09-01",1863,705,17,750,7,89,3917.2635949999999]
["Value of claim exceeds the upper limit",134,null,null,"2021-10-01","RTA",10043,null,null,null,null,null,null,null,null,null,null,"2015-10-01",1882,716,22,824,8,96,4040.4050000000002,null,"2015-10-01",22737,8537,313,10265,87,966,null,"2015-10-01",1893,716,22,824,8,96,4040.4050000000002]
["Withdrawal of offer",107,null,null,"2021-11-01","RTA",9821,null,null,null,null,null,null,null,null,null,null,"2015-11-01",1613,710,22,864,6,119,3995.553613,null,"2015-11-01",22847,8712,304,10449,82,1002,null,"2015-11-01",1623,710,22,864,6,119,3995.553613]
["Value of claim below ú1,000",29,null,null,"2021-12-01","RTA",7687,null,null,null,null,null,null,null,null,null,null,"2015-12-01",1385,655,24,668,4,99,3986.5814140000002,null,"2015-12-01",22929,8808,294,10412,76,1027,null,"2015-12-01",1395,655,24,668,4,99,3986.5814140000002]
["Interim payment for child claimant",12,null,null,"2022-01-01","RTA",8745,null,null,null,null,null,null,null,null,null,null,"2016-01-01",1362,607,15,657,7,78,3651.2676919999999,null,"2016-01-01",22492,8832,278,10371,71,1041,null,"2016-01-01",1369,607,15,657,7,78,3651.2676919999999]
[null,null,null,null,"2022-02-01","RTA",7871,null,null,null,null,null,null,null,null,null,null,"2016-02-01",1215,500,18,563,2,103,3741.542524,null,"2016-02-01",21372,8906,268,10165,68,1074,null,"2016-02-01",1220,500,18,563,2,103,3741.542524]
[null,null,null,null,"2022-03-01","RTA",8218,null,null,null,null,null,null,null,null,null,null,"2016-03-01",1090,599,19,570,4,89,4073.5834829999999,null,"2016-03-01",19833,8664,266,9592,67,1077,null,"2016-03-01",1095,599,19,570,4,89,4073.5834829999999]
[null,null,null,null,"2022-04-01","RTA",7247,null,null,null,null,null,null,null,null,null,null,"2016-04-01",967,458,23,463,3,89,3934.2673030000001,null,"2016-04-01",18557,8262,261,8873,63,1092,null,"2016-04-01",975,458,23,463,3,89,3934.2673030000001]
[null,null,null,null,"2022-05-01","RTA",7876,null,null,null,null,null,null,null,null,null,null,"2016-05-01",850,447,18,358,3,59,3943.3115250000001,null,"2016-05-01",17567,7928,259,8243,61,1065,null,"2016-05-01",859,447,18,358,3,59,3943.3115250000001]
[null,null,null,null,"2022-06-01","RTA",7289,null,null,null,null,null,null,null,null,null,null,"2016-06-01",741,382,23,417,6,80,3885.6522500000001,null,"2016-06-01",16346,7311,258,7662,63,1067,null,"2016-06-01",751,382,23,417,6,80,3885.6522500000001]
[null,null,null,null,"2022-07-01","RTA",7438,null,null,null,null,null,null,null,null,null,null,"2016-07-01",683,324,8,300,3,67,3694.5628350000002,null,"2016-07-01",15257,6758,235,7083,56,1042,null,"2016-07-01",691,324,8,300,3,67,3694.5628350000002]
[null,null,null,null,"2021-05-01","EL",1711,null,null,null,null,null,null,null,null,null,null,"2016-08-01",844,267,13,245,2,47,3745.8587229999998,null,"2016-08-01",14482,6370,222,6679,55,1015,null,"2016-08-01",850,267,13,245,2,47,3745.8587229999998]
[null,null,null,null,"2021-06-01","EL",2442,null,null,null,null,null,null,null,null,null,null,"2016-09-01",834,370,12,372,3,77,3320.1161029999998,null,"2016-09-01",13466,6035,217,6301,51,1003,null,"2016-09-01",847,370,12,372,3,77,3320.1161029999998]
[null,null,null,null,"2021-07-01","EL",2512,null,null,null,null,null,null,null,null,null,null,"2016-10-01",800,359,17,319,2,50,3599.0362,null,"2016-10-01",12384,5678,212,5796,45,957,null,"2016-10-01",815,359,17,319,2,51,3626.5060779999999]
[null,null,null,null,"2021-08-01","EL",2481,null,null,null,null,null,null,null,null,null,null,"2016-11-01",813,366,24,332,5,63,3561.5420629999999,null,"2016-11-01",11584,5334,214,5264,44,901,null,"2016-11-01",853,366,24,332,5,64,3529.3304680000001]
[null,null,null,null,"2021-09-01","EL",2730,null,null,null,null,null,null,null,null,null,null,"2016-12-01",595,310,13,312,2,59,3692.4923720000002,null,"2016-12-01",10794,4989,203,4908,42,861,null,"2016-12-01",614,310,13,312,2,59,3692.4923720000002]
[null,null,null,null,"2021-10-01","EL",2566,null,null,null,null,null,null,null,null,null,null,"2017-01-01",813,328,12,326,1,60,3953.8204999999998,null,"2017-01-01",10245,4710,200,4577,36,843,null,"2017-01-01",843,328,12,326,1,63,3946.4957140000001]
[null,null,null,null,"2021-11-01","EL",2681,null,null,null,null,null,null,null,null,null,null,"2017-02-01",823,227,18,298,3,58,3840.1215510000002,null,"2017-02-01",9853,4437,200,4312,37,798,null,"2017-02-01",855,227,18,298,3,60,3846.2841659999999]
[null,null,null,null,"2021-12-01","EL",2035,null,null,null,null,null,null,null,null,null,null,"2017-03-01",904,429,12,477,3,65,3545.99,null,"2017-03-01",9667,4267,193,4219,36,774,null,"2017-03-01",942,429,12,477,3,68,3503.5198519999999]
[null,null,null,null,"2022-01-01","EL",2473,null,null,null,null,null,null,null,null,null,null,"2017-04-01",684,271,5,325,0,40,3351.4450000000002,null,"2017-04-01",9384,4080,175,4081,33,725,null,"2017-04-01",700,271,5,325,0,41,3306.2878040000001]
[null,null,null,null,"2022-02-01","EL",2477,null,null,null,null,null,null,null,null,null,null,"2017-05-01",761,382,11,371,3,42,3137.2033329999999,null,"2017-05-01",9295,4015,168,4094,33,708,null,"2017-05-01",800,382,11,371,3,44,3207.6713629999999]
[null,null,null,null,"2022-03-01","EL",2820,null,null,null,null,null,null,null,null,null,null,"2017-06-01",872,348,17,367,1,43,3514.5051159999998,null,"2017-06-01",9426,3981,162,4044,28,671,null,"2017-06-01",901,348,17,367,1,44,3518.7209090000001]
[null,null,null,null,"2022-04-01","EL",2201,null,null,null,null,null,null,null,null,null,null,"2017-07-01",689,348,7,348,1,38,4191.3718419999996,null,"2017-07-01",9432,4005,161,4092,26,642,null,"2017-07-01",718,348,7,348,1,38,4191.3718419999996]
[null,null,null,null,"2022-05-01","EL",2528,null,null,null,null,null,null,null,null,null,null,"2017-08-01",723,367,5,306,3,44,3521.9175,null,"2017-08-01",9311,4105,153,4153,27,639,null,"2017-08-01",750,367,5,306,3,45,3454.7637770000001]
[null,null,null,null,"2022-06-01","EL",2404,null,null,null,null,null,null,null,null,null,null,"2017-09-01",677,322,15,294,2,40,4071.3634999999999,null,"2017-09-01",9154,4057,156,4075,26,602,null,"2017-09-01",708,322,15,294,2,40,4071.3634999999999]
[null,null,null,null,"2022-07-01","EL",2257,null,null,null,null,null,null,null,null,null,null,"2017-10-01",732,334,5,304,0,33,3973.5681810000001,null,"2017-10-01",9086,4032,144,4060,24,585,null,"2017-10-01",756,334,5,304,0,34,3959.639705]
[null,null,null,null,"2021-05-01","ELD",174,null,null,null,null,null,null,null,null,null,null,"2017-11-01",645,341,16,314,3,51,3931.9509800000001,null,"2017-11-01",8918,4007,136,4042,22,573,null,"2017-11-01",690,341,16,314,3,55,3900]
[null,null,null,null,"2021-06-01","ELD",280,null,null,null,null,null,null,null,null,null,null,"2017-12-01",448,276,8,250,4,31,3882.0596770000002,null,"2017-12-01",8771,3973,131,3980,24,545,null,"2017-12-01",477,276,8,250,4,35,3988.3957140000002]
[null,null,null,null,"2021-07-01","ELD",422,null,null,null,null,null,null,null,null,null,null,"2018-01-01",674,313,7,254,5,45,4318.0531110000002,null,"2018-01-01",8632,3958,126,3908,28,530,null,"2018-01-01",716,313,7,254,5,49,4233.6161220000004]
[null,null,null,null,"2021-08-01","ELD",318,null,null,null,null,null,null,null,null,null,null,"2018-02-01",641,231,5,231,5,39,4043.7146149999999,null,"2018-02-01",8450,3962,113,3841,30,511,null,"2018-02-01",675,231,5,231,5,40,4047.6217499999998]
[null,null,null,null,"2021-09-01","ELD",343,null,null,null,null,null,null,null,null,null,null,"2018-03-01",648,325,3,316,4,41,4137.4580480000004,null,"2018-03-01",8194,3858,104,3680,31,487,null,"2018-03-01",686,325,3,316,4,44,4166.722272]
[null,null,null,null,"2021-10-01","ELD",357,null,null,null,null,null,null,null,null,null,null,"2018-04-01",503,313,3,252,0,29,3670.6262059999999,null,"2018-04-01",8013,3900,102,3607,31,476,null,"2018-04-01",527,313,3,252,0,31,3611.230967]
[null,null,null,null,"2021-11-01","ELD",427,null,null,null,null,null,null,null,null,null,null,"2018-05-01",467,266,6,223,1,26,3641.29423,null,"2018-05-01",7719,3784,97,3459,29,460,null,"2018-05-01",491,266,6,223,1,28,3818.7017850000002]
[null,null,null,null,"2021-12-01","ELD",273,null,null,null,null,null,null,null,null,null,null,"2018-06-01",496,257,8,186,3,43,3560.903953,null,"2018-06-01",7343,3693,88,3278,31,460,null,"2018-06-01",518,257,8,186,3,43,3560.903953]
[null,null,null,null,"2022-01-01","ELD",378,null,null,null,null,null,null,null,null,null,null,"2018-07-01",457,264,10,199,0,41,3875.2941460000002,null,"2018-07-01",7111,3609,91,3129,30,463,null,"2018-07-01",478,264,10,199,0,41,3875.2941460000002]
[null,null,null,null,"2022-02-01","ELD",317,null,null,null,null,null,null,null,null,null,null,"2018-08-01",392,242,11,172,1,33,4000.5803030000002,null,"2018-08-01",6780,3484,97,2995,28,452,null,"2018-08-01",416,242,11,172,1,33,4000.5803030000002]
[null,null,null,null,"2022-03-01","ELD",445,null,null,null,null,null,null,null,null,null,null,"2018-09-01",420,192,1,150,0,29,4220.1503439999997,null,"2018-09-01",6523,3354,83,2851,26,441,null,"2018-09-01",429,192,1,150,0,30,4121.1453330000004]
[null,null,null,null,"2022-04-01","ELD",357,null,null,null,null,null,null,null,null,null,null,"2018-10-01",496,224,7,196,0,29,4412.0096549999998,null,"2018-10-01",6287,3244,85,2743,26,437,null,"2018-10-01",514,224,7,196,0,30,4481.6093330000003]
[null,null,null,null,"2022-05-01","ELD",459,null,null,null,null,null,null,null,null,null,null,"2018-11-01",420,249,6,143,1,24,4158.0541659999999,null,"2018-11-01",6062,3152,75,2572,24,410,null,"2018-11-01",435,249,6,143,1,24,4158.0541659999999]
[null,null,null,null,"2022-06-01","ELD",485,null,null,null,null,null,null,null,null,null,null,"2018-12-01",283,177,2,135,2,26,3621.280769,null,"2018-12-01",5897,3053,69,2457,22,405,null,"2018-12-01",299,177,2,135,2,27,3616.788888]
[null,null,null,null,"2022-07-01","ELD",427,null,null,null,null,null,null,null,null,null,null,"2019-01-01",428,207,1,162,1,24,3734.3850000000002,null,"2019-01-01",5651,2947,63,2365,18,384,null,"2019-01-01",439,207,1,162,1,24,3734.3850000000002]
[null,null,null,null,"2021-05-01","PL",2038,null,null,null,null,null,null,null,null,null,null,"2019-02-01",449,150,4,131,0,29,4074.730689,null,"2019-02-01",5459,2866,62,2265,13,374,null,"2019-02-01",469,150,4,131,0,29,4074.730689]
[null,null,null,null,"2021-06-01","PL",3252,null,null,null,null,null,null,null,null,null,null,"2019-03-01",423,247,4,154,1,27,3960.0888880000002,null,"2019-03-01",5234,2788,63,2103,10,360,null,"2019-03-01",444,247,4,154,1,29,3890.4275859999998]
[null,null,null,null,"2021-07-01","PL",3274,null,null,null,null,null,null,null,null,null,null,"2019-04-01",389,225,3,153,3,35,4232.7219999999998,null,"2019-04-01",5120,2700,63,2004,13,366,null,"2019-04-01",405,225,3,153,3,36,4254.035277]
[null,null,null,null,"2021-08-01","PL",3283,null,null,null,null,null,null,null,null,null,null,"2019-05-01",400,218,5,144,0,29,3990.293103,null,"2019-05-01",5053,2652,62,1925,12,369,null,"2019-05-01",418,218,5,144,0,30,3973.95]
[null,null,null,null,"2021-09-01","PL",3623,null,null,null,null,null,null,null,null,null,null,"2019-06-01",364,214,6,135,2,20,4906.8230000000003,null,"2019-06-01",4921,2609,60,1874,11,346,null,"2019-06-01",373,214,6,135,2,22,4900.1118180000003]
[null,null,null,null,"2021-10-01","PL",3479,null,null,null,null,null,null,null,null,null,null,"2019-07-01",406,222,3,130,3,26,4101.0515379999997,null,"2019-07-01",4870,2567,53,1805,14,331,null,"2019-07-01",431,222,3,130,3,27,4078.7903700000002]
[null,null,null,null,"2021-11-01","PL",3500,null,null,null,null,null,null,null,null,null,null,"2019-08-01",296,206,2,117,0,23,4346.6008689999999,null,"2019-08-01",4774,2531,44,1750,13,321,null,"2019-08-01",367,206,2,117,0,24,4280.0758329999999]
[null,null,null,null,"2021-12-01","PL",2480,null,null,null,null,null,null,null,null,null,null,"2019-09-01",265,190,5,131,0,26,3973.5038460000001,null,"2019-09-01",4619,2529,48,1731,13,318,null,"2019-09-01",385,190,5,134,0,28,4135.5749999999998]
[null,null,null,null,"2022-01-01","PL",3131,null,null,null,null,null,null,null,null,null,null,"2019-10-01",292,115,5,115,1,33,4537.0048479999996,null,"2019-10-01",4415,2420,46,1650,14,322,null,"2019-10-01",432,174,5,152,1,37,4641.1124319999999]
[null,null,null,null,"2022-02-01","PL",3195,null,null,null,null,null,null,null,null,null,null,"2019-11-01",203,114,2,84,1,27,4348.0707400000001,null,"2019-11-01",4198,2285,42,1591,14,325,null,"2019-11-01",327,171,6,114,1,30,4546.5969999999998]
[null,null,null,null,"2022-03-01","PL",3465,null,null,null,null,null,null,null,null,null,null,"2019-12-01",167,89,2,64,4,15,3946.0520000000001,null,"2019-12-01",4082,2197,42,1520,16,314,null,"2019-12-01",254,144,5,95,4,15,3946.0520000000001]
[null,null,null,null,"2022-04-01","PL",2783,null,null,null,null,null,null,null,null,null,null,"2020-01-01",228,83,4,85,2,25,3695.8159999999998,null,"2020-01-01",3882,2073,45,1443,17,315,null,"2020-01-01",325,132,6,111,2,27,3777.607407]
[null,null,null,null,"2022-05-01","PL",3127,null,null,null,null,null,null,null,null,null,null,"2020-02-01",238,75,1,77,0,27,5273.8011109999998,null,"2020-02-01",3671,1998,42,1389,17,313,null,"2020-02-01",364,114,1,97,0,29,5334.2286199999999]
[null,null,null,null,"2022-06-01","PL",2904,null,null,null,null,null,null,null,null,null,null,"2020-03-01",202,110,1,77,0,46,4002.032608,null,"2020-03-01",3450,1861,39,1312,16,332,null,"2020-03-01",335,173,4,104,0,48,4100.90625]
[null,null,null,null,"2022-07-01","PL",2981,null,null,null,null,null,null,null,null,null,null,"2020-04-01",278,88,1,85,1,46,3777.0928260000001,null,"2020-04-01",3339,1724,37,1244,14,343,null,"2020-04-01",380,141,1,113,2,50,4034.8254000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-01",169,69,5,66,0,35,4429.0571419999997,null,"2020-05-01",3108,1575,37,1166,14,349,null,"2020-05-01",230,122,7,92,0,38,4309.4368420000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-01",183,122,5,78,0,49,4034.436326,null,"2020-06-01",2927,1483,36,1109,12,378,null,"2020-06-01",265,171,5,102,0,51,4113.3231370000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-01",221,72,2,66,1,32,3732.35,null,"2020-07-01",2742,1333,35,1045,10,384,null,"2020-07-01",274,123,2,86,1,33,3784.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-01",134,85,1,62,0,23,3929.012608,null,"2020-08-01",2580,1212,34,990,10,384,null,"2020-08-01",160,104,1,69,0,20,4155.1270000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-09-01",231,75,2,62,0,20,4225.58,null,"2020-09-01",2546,1097,31,921,10,378,null,"2020-09-01",297,113,2,66,0,21,4429.1238089999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-10-01",222,75,2,86,0,34,3905.3229409999999,null,"2020-10-01",2476,1057,28,892,9,379,null,"2020-10-01",309,100,2,104,0,35,4108.0280000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-01",208,86,1,55,0,37,3507.036486,null,"2020-11-01",2481,1029,27,863,8,389,null,"2020-11-01",286,127,1,66,0,32,3741.734375]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-01",184,72,3,69,0,37,3526.2894590000001,null,"2020-12-01",2498,1012,28,868,4,411,null,"2020-12-01",249,118,3,91,1,38,3454.5450000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01",319,79,2,75,0,42,3453.9769040000001,null,"2021-01-01",2589,1008,26,858,2,428,null,"2021-01-01",310,135,2,96,0,44,3490.159772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-01",295,88,4,54,0,45,3844.6666660000001,null,"2021-02-01",2646,1021,29,835,2,446,null,"2021-02-01",161,81,1,53,0,45,3844.6666660000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-01",365,156,2,99,1,45,3700.4580000000001,null,"2021-03-01",2809,1067,30,857,3,445,null,"2021-03-01",290,147,2,99,1,45,3700.4580000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01",319,136,4,87,0,29,3493.789655,null,"2021-04-01",2850,1115,33,859,2,428,null,"2021-04-01",302,132,4,87,0,29,3493.789655]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01",259,134,1,84,0,43,3859.1602320000002,null,"2021-05-01",2940,1180,29,877,2,436,null,"2021-05-01",240,129,1,84,0,44,3907.815681]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-01",280,190,1,69,1,17,4477.4264700000003,null,"2021-06-01",3037,1248,25,868,3,404,null,"2021-06-01",258,190,1,69,1,17,4477.4264700000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01",422,156,2,65,0,35,3377.4214280000001,null,"2021-07-01",3238,1332,25,867,2,407,null,"2021-07-01",411,154,2,65,0,35,3377.4214280000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-01",318,187,2,70,0,23,3008.734782,null,"2021-08-01",3422,1434,26,875,2,407,null,"2021-08-01",310,186,2,70,0,23,3008.734782]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01",343,187,9,88,0,56,3245.8401779999999,null,"2021-09-01",3534,1546,33,901,2,443,null,"2021-09-01",322,187,9,88,0,56,3245.8401779999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-01",357,167,4,70,0,46,3487.3402169999999,null,"2021-10-01",3669,1638,35,885,2,455,null,"2021-10-01",335,162,4,70,0,46,3487.3402169999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01",427,185,6,100,1,37,3714.3167560000002,null,"2021-11-01",3888,1737,40,930,3,455,null,"2021-11-01",408,180,6,100,1,37,3714.3167560000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-01",273,197,4,90,0,31,3321.5448379999998,null,"2021-12-01",3977,1862,41,951,3,449,null,"2021-12-01",252,194,4,90,0,31,3321.5448379999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01",378,193,5,92,0,63,3527.6668249999998,null,"2022-01-01",4036,1976,44,968,3,470,null,"2022-01-01",360,192,5,92,0,63,3527.6668249999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-01",317,163,4,59,0,63,3380.2033329999999,null,"2022-02-01",4058,2051,44,973,3,488,null,"2022-02-01",308,160,4,59,0,63,3380.2033329999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-01",445,228,5,71,0,36,4066.6277770000002,null,"2022-03-01",4138,2123,47,945,2,479,null,"2022-03-01",416,223,5,71,0,36,4066.6277770000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",357,189,5,79,0,7,4384.6057140000003,null,"2022-04-01",4176,2176,48,937,2,457,null,"2022-04-01",329,186,5,79,0,7,4384.6057140000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",459,250,4,76,1,36,3896.6563879999999,null,"2022-05-01",4376,2292,51,929,3,450,null,"2022-05-01",394,246,4,76,1,36,3896.6563879999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01",485,211,7,70,1,19,3997.4878939999999,null,"2022-06-01",4581,2313,57,930,3,452,null,"2022-06-01",487,210,7,70,1,19,3997.4878939999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",427,417,9,56,0,28,3584.5535709999999,null,"2022-07-01",4586,2574,64,921,3,445]

{"sheet":"Year Calculations","index":2,"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'!S4:S15)","v":11797},{"$f":"SUM('Backing Sheet Data'!T4:T15)","v":4361},{"$f":"SUM('Backing Sheet Data'!U4:U15)","v":51},{"$f":"SUM('Backing Sheet Data'!V4:V15)","v":3495},{"$f":"SUM('Backing Sheet Data'!W4:W15)","v":20},{"$f":"SUM('Backing Sheet Data'!X4:X15)","v":297}]
["2014-15",{"$f":"SUM('Backing Sheet Data'!S16:S27)","v":21867},{"$f":"SUM('Backing Sheet Data'!T16:T27)","v":8084},{"$f":"SUM('Backing Sheet Data'!U16:U27)","v":328},{"$f":"SUM('Backing Sheet Data'!V16:V27)","v":10126},{"$f":"SUM('Backing Sheet Data'!W16:W27)","v":109},{"$f":"SUM('Backing Sheet Data'!X16:X27)","v":977}]
["2015-16",{"$f":"SUM('Backing Sheet Data'!S28:S39)","v":15257},{"$f":"SUM('Backing Sheet Data'!T28:T39)","v":6758},{"$f":"SUM('Backing Sheet Data'!U28:U39)","v":235},{"$f":"SUM('Backing Sheet Data'!V28:V39)","v":7083},{"$f":"SUM('Backing Sheet Data'!W28:W39)","v":56},{"$f":"SUM('Backing Sheet Data'!X28:X39)","v":1042}]
["2016-17",{"$f":"SUM('Backing Sheet Data'!S40:S51)","v":9432},{"$f":"SUM('Backing Sheet Data'!T40:T51)","v":4005},{"$f":"SUM('Backing Sheet Data'!U40:U51)","v":161},{"$f":"SUM('Backing Sheet Data'!V40:V51)","v":4092},{"$f":"SUM('Backing Sheet Data'!W40:W51)","v":26},{"$f":"SUM('Backing Sheet Data'!X40:X51)","v":642}]
["2017-18",{"$f":"SUM('Backing Sheet Data'!S52:S63)","v":7111},{"$f":"SUM('Backing Sheet Data'!T52:T63)","v":3609},{"$f":"SUM('Backing Sheet Data'!U52:U63)","v":91},{"$f":"SUM('Backing Sheet Data'!V52:V63)","v":3129},{"$f":"SUM('Backing Sheet Data'!W52:W63)","v":30},{"$f":"SUM('Backing Sheet Data'!X52:X63)","v":463}]
["2018-19",{"$f":"SUM('Backing Sheet Data'!S64:S75)","v":4870},{"$f":"SUM('Backing Sheet Data'!T64:T75)","v":2567},{"$f":"SUM('Backing Sheet Data'!U64:U75)","v":53},{"$f":"SUM('Backing Sheet Data'!V64:V75)","v":1805},{"$f":"SUM('Backing Sheet Data'!W64:W75)","v":14},{"$f":"SUM('Backing Sheet Data'!X64:X75)","v":331}]
["2019-20",{"$f":"SUM('Backing Sheet Data'!S76:S87)","v":2742},{"$f":"SUM('Backing Sheet Data'!T76:T87)","v":1333},{"$f":"SUM('Backing Sheet Data'!U76:U87)","v":35},{"$f":"SUM('Backing Sheet Data'!V76:V87)","v":1045},{"$f":"SUM('Backing Sheet Data'!W76:W87)","v":10},{"$f":"SUM('Backing Sheet Data'!X76:X87)","v":384}]
["2020-21",{"$f":"SUM('Backing Sheet Data'!S88:S116)","v":7824},{"$f":"SUM('Backing Sheet Data'!T88:T116)","v":3906},{"$f":"SUM('Backing Sheet Data'!U88:U116)","v":89},{"$f":"SUM('Backing Sheet Data'!V88:V116)","v":1788},{"$f":"SUM('Backing Sheet Data'!W88:W116)","v":5},{"$f":"SUM('Backing Sheet Data'!X88:X116)","v":852}]