{"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":[[0,15,1,16],[2,15,3,16],[4,15,5,16],[0,17,1,20],[2,17,3,20],[4,17,5,20],[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],[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,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],[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],[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],[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]]}
["Total Sent:",null,null,297,null,"Left process at stage 1:",null,null,null,113,null,"Left process at stage 2:",null,null,null,2,null,"Exited process:",null,null,null,66,null,"Settled:",null,null,21]
[]
["Δ from last month:",null,null,137,null,"Δ from last month:",null,null,null,9,null,"Δ from last month:",null,null,null,1,null,"Δ from last month:",null,null,null,-3,null,"Δ from last month:",null,null,1]
[]
["Rolling 12 months:",null,null,3723,null,"Rolling 12 months:",null,null,null,1713,null,"Rolling 12 months:",null,null,null,56,null,"Rolling 12 months:",null,null,null,1211,null,"Rolling 12 months:",null,null,404]
[]
["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,108,null,98,null,10]
["Other",null,null,null,null,null,null,5,null,6,null,-1]
["Total",null,null,null,null,null,null,113,null,104,null,9]
["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,1,null,-1]
["Settlement pack timeout:",null,null,null,null,null,null,2,null,0,null,2]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,0,null,0,null,0]
["Total",null,null,null,null,null,null,2,null,1,null,1]

{"sheet":"Backing Sheet Data","index":1,"n_rows":89,"n_cols":42,"rows_kept":89,"cut":false,"hidden":false,"merged":[[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2020-09-01"]
["Previous month","2020-08-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75914,31493,971,31192,266,4254,338204.88325000007]
[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 13 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]
["2019-09-01",4976,null,null,"2019-10-01",4641.1124319999999,null,null,108,5,0,0,2,0,null,null,null,"2013-11-01",815,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]
["2019-10-01",4894,null,null,"2019-11-01",4546.5969999999998,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]
["2019-11-01",4786,null,null,"2019-12-01",3946.0520000000001,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]
["2019-12-01",4739,null,null,"2020-01-01",3777.607407,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]
["2020-01-01",4625,null,null,"2020-02-01",5334.2286199999999,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2014-03-01",1251,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]
["2020-02-01",4520,null,null,"2020-03-01",4100.90625,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total",null,null,null,"2014-04-01",1388,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]
["2020-03-01",4411,null,null,"2020-04-01",4034.8254000000002,null,null,"2019-09-01",56721,4512,384,3419,65036,null,null,null,"2014-05-01",1359,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]
["2020-04-01",4386,null,null,"2020-05-01",4309.4368420000001,null,null,"2019-10-01",62510,4856,432,4021,71819,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]
["2020-05-01",4208,null,null,"2020-06-01",4113.3231370000003,null,null,"2019-11-01",59540,4511,327,3793,68171,null,null,null,"2014-07-01",1727,543,19,651,3,86,4877.246744,null,"2014-07-01",11805,4361,51,3495,20,297,null,"2014-07-01",1727,543,19,651,3,86,4877.246744]
["2020-06-01",4121,null,null,"2020-07-01",3696.72,null,null,"2019-12-01",50766,3410,252,2718,57146,null,null,null,"2014-08-01",1303,512,12,654,10,58,4740.3146550000001,null,"2014-08-01",12941,4872,63,4132,30,355,null,"2014-08-01",1303,512,12,654,10,58,4740.3146550000001]
["2020-07-01",3987,null,null,"2020-08-01",3929.012608,null,null,"2020-01-01",60020,4662,325,3668,68675,null,null,null,"2014-09-01",1605,559,34,703,10,106,4555.8396220000004,null,"2014-09-01",14212,5384,97,4801,40,461,null,"2014-09-01",1605,559,34,703,10,106,4555.8396220000004]
["2020-08-01",3810,null,null,"2020-09-01",4429.1238089999997,null,null,"2020-02-01",55486,4531,364,3655,64036,null,null,null,"2014-10-01",1584,552,34,727,20,106,4804.3396220000004,null,"2014-10-01",15176,5739,131,5436,60,567,null,"2014-10-01",1584,552,34,727,20,106,4804.3396220000004]
["2020-09-01",3723,null,null,"Grand Total",50858.945504999996,null,null,"2020-03-01",49272,4300,335,3418,57325,null,null,null,"2014-11-01",1518,535,31,680,11,83,4192.8449389999996,null,"2014-11-01",15879,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,"2020-04-01",24534,2843,380,2204,29961,null,null,null,"2014-12-01",1309,559,34,705,10,74,4345.0778369999998,null,"2014-12-01",16464,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,"2020-05-01",22901,2349,240,1682,27172,null,null,null,"2015-01-01",1811,583,31,698,12,64,4383.7940619999999,null,"2015-01-01",17204,6279,224,6947,93,780,null,"2015-01-01",1811,583,31,698,12,64,4383.7940619999999]
[null,null,null,null,"CNF Sent Monthly Volumes",null,null,null,"2020-06-01",32416,2805,285,2034,37540,null,null,null,"2015-02-01",2361,426,28,769,5,70,4623.1801420000002,null,"2015-02-01",18567,6328,249,7504,98,829,null,"2015-02-01",2361,426,28,769,5,70,4623.1801420000002]
[null,34231,null,null,null,null,null,null,"2020-07-01",40038,3331,297,2368,46034,null,null,null,"2015-03-01",2647,841,21,1143,5,86,4959.1549999999997,null,"2015-03-01",19963,6691,267,8273,100,881,null,"2015-03-01",2647,841,21,1143,5,86,4959.1549999999997]
["Exit Process Reason","Total",null,null,"DatePeriod","ClaimType","ClaimCount",null,"2020-08-01",37707,2917,189,2145,42958,null,null,null,"2015-04-01",2254,860,28,1182,7,74,4358.1350000000002,null,"2015-04-01",20829,7105,290,9048,105,923,null,"2015-04-01",2254,860,28,1182,7,74,4358.1350000000002]
["Claim requires further investigation",14956,null,null,"2019-07-01","RTA",48000,null,"2020-09-01",43018,3548,297,2625,49488,null,null,null,"2015-05-01",1849,781,20,988,5,86,3996.8166270000002,null,"2015-05-01",21319,7341,306,9489,106,967,null,"2015-05-01",1849,781,20,988,5,86,3996.8166270000002]
["Other",9684,null,null,"2019-08-01","RTA",54870,null,"Grand Total",594929,48575,4107,37750,685361,null,null,null,"2015-06-01",1972,999,24,998,4,78,4745.8085890000002,null,"2015-06-01",21940,7750,316,9898,102,971,null,"2015-06-01",1972,999,24,998,4,78,4745.8085890000002]
["Incomplete information provided on CNF",5473,null,null,"2019-09-01","RTA",56721,null,null,null,null,null,null,null,null,null,null,"2015-07-01",1779,877,31,879,10,92,4072.2803260000001,null,"2015-07-01",21992,8084,328,10126,109,977,null,"2015-07-01",1779,877,31,879,10,92,4072.2803260000001]
["Duplicated claim",2687,null,null,"2019-10-01","RTA",62510,null,null,null,null,null,null,null,null,null,null,"2015-08-01",1629,655,26,649,3,74,3784.8224319999999,null,"2015-08-01",22318,8227,342,10121,102,993,null,"2015-08-01",1629,655,26,649,3,74,3784.8224319999999]
["Withdrawal of claim",1015,null,null,"2019-11-01","RTA",59540,null,null,null,null,null,null,null,null,null,null,"2015-09-01",1863,705,17,750,7,89,3917.2635949999999,null,"2015-09-01",22576,8373,325,10168,99,976,null,"2015-09-01",1863,705,17,750,7,89,3917.2635949999999]
["Claim is too complex for process",164,null,null,"2019-12-01","RTA",50766,null,null,null,null,null,null,null,null,null,null,"2015-10-01",1893,716,22,824,8,96,4040.4050000000002,null,"2015-10-01",22885,8537,313,10265,87,966,null,"2015-10-01",1893,716,22,824,8,96,4040.4050000000002]
["Value of claim exceeds the upper limit",111,null,null,"2020-01-01","RTA",60020,null,null,null,null,null,null,null,null,null,null,"2015-11-01",1623,710,22,864,6,119,3995.553613,null,"2015-11-01",22990,8712,304,10449,82,1002,null,"2015-11-01",1623,710,22,864,6,119,3995.553613]
["Withdrawal of offer",100,null,null,"2020-02-01","RTA",55486,null,null,null,null,null,null,null,null,null,null,"2015-12-01",1395,655,24,668,4,99,3986.5814140000002,null,"2015-12-01",23076,8808,294,10412,76,1027,null,"2015-12-01",1395,655,24,668,4,99,3986.5814140000002]
["Value of claim below ú1,000",29,null,null,"2020-03-01","RTA",49272,null,null,null,null,null,null,null,null,null,null,"2016-01-01",1369,607,15,657,7,78,3651.2676919999999,null,"2016-01-01",22634,8832,278,10371,71,1041,null,"2016-01-01",1369,607,15,657,7,78,3651.2676919999999]
["Interim payment for child claimant",12,null,null,"2020-04-01","RTA",24534,null,null,null,null,null,null,null,null,null,null,"2016-02-01",1220,500,18,563,2,103,3741.542524,null,"2016-02-01",21493,8906,268,10165,68,1074,null,"2016-02-01",1220,500,18,563,2,103,3741.542524]
[null,null,null,null,"2020-05-01","RTA",22901,null,null,null,null,null,null,null,null,null,null,"2016-03-01",1095,599,19,570,4,89,4073.5834829999999,null,"2016-03-01",19941,8664,266,9592,67,1077,null,"2016-03-01",1095,599,19,570,4,89,4073.5834829999999]
[null,null,null,null,"2020-06-01","RTA",32416,null,null,null,null,null,null,null,null,null,null,"2016-04-01",975,458,23,463,3,89,3934.2673030000001,null,"2016-04-01",18662,8262,261,8873,63,1092,null,"2016-04-01",975,458,23,463,3,89,3934.2673030000001]
[null,null,null,null,"2020-07-01","RTA",40038,null,null,null,null,null,null,null,null,null,null,"2016-05-01",859,447,18,358,3,59,3943.3115250000001,null,"2016-05-01",17672,7928,259,8243,61,1065,null,"2016-05-01",859,447,18,358,3,59,3943.3115250000001]
[null,null,null,null,"2020-08-01","RTA",37707,null,null,null,null,null,null,null,null,null,null,"2016-06-01",751,382,23,417,6,80,3885.6522500000001,null,"2016-06-01",16451,7311,258,7662,63,1067,null,"2016-06-01",751,382,23,417,6,80,3885.6522500000001]
[null,null,null,null,"2020-09-01","RTA",43018,null,null,null,null,null,null,null,null,null,null,"2016-07-01",691,324,8,300,3,67,3694.5628350000002,null,"2016-07-01",15363,6758,235,7083,56,1042,null,"2016-07-01",691,324,8,300,3,67,3694.5628350000002]
[null,null,null,null,"2019-07-01","EL",3249,null,null,null,null,null,null,null,null,null,null,"2016-08-01",850,267,13,245,2,47,3745.8587229999998,null,"2016-08-01",14584,6370,222,6679,55,1015,null,"2016-08-01",850,267,13,245,2,47,3745.8587229999998]
[null,null,null,null,"2019-08-01","EL",3573,null,null,null,null,null,null,null,null,null,null,"2016-09-01",847,370,12,372,3,77,3320.1161029999998,null,"2016-09-01",13568,6035,217,6301,51,1003,null,"2016-09-01",847,370,12,372,3,77,3320.1161029999998]
[null,null,null,null,"2019-09-01","EL",3419,null,null,null,null,null,null,null,null,null,null,"2016-10-01",815,359,17,319,2,51,3626.5060779999999,null,"2016-10-01",12490,5678,212,5796,45,958,null,"2016-10-01",815,359,17,319,2,51,3626.5060779999999]
[null,null,null,null,"2019-10-01","EL",4021,null,null,null,null,null,null,null,null,null,null,"2016-11-01",853,366,24,332,5,64,3529.3304680000001,null,"2016-11-01",11720,5334,214,5264,44,903,null,"2016-11-01",853,366,24,332,5,64,3529.3304680000001]
[null,null,null,null,"2019-11-01","EL",3793,null,null,null,null,null,null,null,null,null,null,"2016-12-01",614,310,13,312,2,59,3692.4923720000002,null,"2016-12-01",10939,4989,203,4908,42,863,null,"2016-12-01",614,310,13,312,2,59,3692.4923720000002]
[null,null,null,null,"2019-12-01","EL",2718,null,null,null,null,null,null,null,null,null,null,"2017-01-01",843,328,12,326,1,63,3946.4957140000001,null,"2017-01-01",10413,4710,200,4577,36,848,null,"2017-01-01",843,328,12,326,1,63,3946.4957140000001]
[null,null,null,null,"2020-01-01","EL",3668,null,null,null,null,null,null,null,null,null,null,"2017-02-01",855,227,18,298,3,60,3846.2841659999999,null,"2017-02-01",10048,4437,200,4312,37,805,null,"2017-02-01",855,227,18,298,3,60,3846.2841659999999]
[null,null,null,null,"2020-02-01","EL",3655,null,null,null,null,null,null,null,null,null,null,"2017-03-01",942,429,12,477,3,68,3503.5198519999999,null,"2017-03-01",9895,4267,193,4219,36,784,null,"2017-03-01",942,429,12,477,3,68,3503.5198519999999]
[null,null,null,null,"2020-03-01","EL",3418,null,null,null,null,null,null,null,null,null,null,"2017-04-01",700,271,5,325,0,41,3306.2878040000001,null,"2017-04-01",9620,4080,175,4081,33,736,null,"2017-04-01",700,271,5,325,0,41,3306.2878040000001]
[null,null,null,null,"2020-04-01","EL",2204,null,null,null,null,null,null,null,null,null,null,"2017-05-01",800,382,11,371,3,44,3207.6713629999999,null,"2017-05-01",9561,4015,168,4094,33,721,null,"2017-05-01",800,382,11,371,3,44,3207.6713629999999]
[null,null,null,null,"2020-05-01","EL",1682,null,null,null,null,null,null,null,null,null,null,"2017-06-01",901,348,17,367,1,44,3518.7209090000001,null,"2017-06-01",9711,3981,162,4044,28,685,null,"2017-06-01",901,348,17,367,1,44,3518.7209090000001]
[null,null,null,null,"2020-06-01","EL",2034,null,null,null,null,null,null,null,null,null,null,"2017-07-01",718,348,7,348,1,38,4191.3718419999996,null,"2017-07-01",9738,4005,161,4092,26,656,null,"2017-07-01",718,348,7,348,1,38,4191.3718419999996]
[null,null,null,null,"2020-07-01","EL",2368,null,null,null,null,null,null,null,null,null,null,"2017-08-01",750,367,5,306,3,45,3454.7637770000001,null,"2017-08-01",9638,4105,153,4153,27,654,null,"2017-08-01",750,367,5,306,3,45,3454.7637770000001]
[null,null,null,null,"2020-08-01","EL",2145,null,null,null,null,null,null,null,null,null,null,"2017-09-01",708,322,15,294,2,40,4071.3634999999999,null,"2017-09-01",9499,4057,156,4075,26,617,null,"2017-09-01",708,322,15,294,2,40,4071.3634999999999]
[null,null,null,null,"2020-09-01","EL",2625,null,null,null,null,null,null,null,null,null,null,"2017-10-01",756,334,5,304,0,34,3959.639705,null,"2017-10-01",9440,4032,144,4060,24,600,null,"2017-10-01",756,334,5,304,0,34,3959.639705]
[null,null,null,null,"2019-07-01","ELD",348,null,null,null,null,null,null,null,null,null,null,"2017-11-01",690,341,16,314,3,55,3900,null,"2017-11-01",9277,4007,136,4042,22,591,null,"2017-11-01",690,341,16,314,3,55,3900]
[null,null,null,null,"2019-08-01","ELD",366,null,null,null,null,null,null,null,null,null,null,"2017-12-01",477,276,8,250,4,35,3988.3957140000002,null,"2017-12-01",9140,3973,131,3980,24,567,null,"2017-12-01",477,276,8,250,4,35,3988.3957140000002]
[null,null,null,null,"2019-09-01","ELD",384,null,null,null,null,null,null,null,null,null,null,"2018-01-01",716,313,7,254,5,49,4233.6161220000004,null,"2018-01-01",9013,3958,126,3908,28,553,null,"2018-01-01",716,313,7,254,5,49,4233.6161220000004]
[null,null,null,null,"2019-10-01","ELD",432,null,null,null,null,null,null,null,null,null,null,"2018-02-01",675,231,5,231,5,40,4047.6217499999998,null,"2018-02-01",8833,3962,113,3841,30,533,null,"2018-02-01",675,231,5,231,5,40,4047.6217499999998]
[null,null,null,null,"2019-11-01","ELD",327,null,null,null,null,null,null,null,null,null,null,"2018-03-01",686,325,3,316,4,44,4166.722272,null,"2018-03-01",8577,3858,104,3680,31,509,null,"2018-03-01",686,325,3,316,4,44,4166.722272]
[null,null,null,null,"2019-12-01","ELD",252,null,null,null,null,null,null,null,null,null,null,"2018-04-01",527,313,3,252,0,31,3611.230967,null,"2018-04-01",8404,3900,102,3607,31,499,null,"2018-04-01",527,313,3,252,0,31,3611.230967]
[null,null,null,null,"2020-01-01","ELD",325,null,null,null,null,null,null,null,null,null,null,"2018-05-01",491,266,6,223,1,28,3818.7017850000002,null,"2018-05-01",8095,3784,97,3459,29,483,null,"2018-05-01",491,266,6,223,1,28,3818.7017850000002]
[null,null,null,null,"2020-02-01","ELD",364,null,null,null,null,null,null,null,null,null,null,"2018-06-01",518,257,8,186,3,43,3560.903953,null,"2018-06-01",7712,3693,88,3278,31,482,null,"2018-06-01",518,257,8,186,3,43,3560.903953]
[null,null,null,null,"2020-03-01","ELD",335,null,null,null,null,null,null,null,null,null,null,"2018-07-01",478,264,10,199,0,41,3875.2941460000002,null,"2018-07-01",7472,3609,91,3129,30,485,null,"2018-07-01",478,264,10,199,0,41,3875.2941460000002]
[null,null,null,null,"2020-04-01","ELD",380,null,null,null,null,null,null,null,null,null,null,"2018-08-01",416,242,11,172,1,33,4000.5803030000002,null,"2018-08-01",7138,3484,97,2995,28,473,null,"2018-08-01",416,242,11,172,1,33,4000.5803030000002]
[null,null,null,null,"2020-05-01","ELD",240,null,null,null,null,null,null,null,null,null,null,"2018-09-01",429,192,1,150,0,30,4121.1453330000004,null,"2018-09-01",6859,3354,83,2851,26,463,null,"2018-09-01",429,192,1,150,0,30,4121.1453330000004]
[null,null,null,null,"2020-06-01","ELD",285,null,null,null,null,null,null,null,null,null,null,"2018-10-01",514,224,7,196,0,30,4481.6093330000003,null,"2018-10-01",6617,3244,85,2743,26,459,null,"2018-10-01",514,224,7,196,0,30,4481.6093330000003]
[null,null,null,null,"2020-07-01","ELD",297,null,null,null,null,null,null,null,null,null,null,"2018-11-01",435,249,6,143,1,24,4158.0541659999999,null,"2018-11-01",6362,3152,75,2572,24,428,null,"2018-11-01",435,249,6,143,1,24,4158.0541659999999]
[null,null,null,null,"2020-08-01","ELD",189,null,null,null,null,null,null,null,null,null,null,"2018-12-01",299,177,2,135,2,27,3616.788888,null,"2018-12-01",6184,3053,69,2457,22,420,null,"2018-12-01",299,177,2,135,2,27,3616.788888]
[null,null,null,null,"2020-09-01","ELD",297,null,null,null,null,null,null,null,null,null,null,"2019-01-01",439,207,1,162,1,24,3734.3850000000002,null,"2019-01-01",5907,2947,63,2365,18,395,null,"2019-01-01",439,207,1,162,1,24,3734.3850000000002]
[null,null,null,null,"2019-07-01","PL",4024,null,null,null,null,null,null,null,null,null,null,"2019-02-01",469,150,4,131,0,29,4074.730689,null,"2019-02-01",5701,2866,62,2265,13,384,null,"2019-02-01",469,150,4,131,0,29,4074.730689]
[null,null,null,null,"2019-08-01","PL",4781,null,null,null,null,null,null,null,null,null,null,"2019-03-01",444,247,4,154,1,29,3890.4275859999998,null,"2019-03-01",5459,2788,63,2103,10,369,null,"2019-03-01",444,247,4,154,1,29,3890.4275859999998]
[null,null,null,null,"2019-09-01","PL",4512,null,null,null,null,null,null,null,null,null,null,"2019-04-01",405,225,3,153,3,36,4254.035277,null,"2019-04-01",5337,2700,63,2004,13,374,null,"2019-04-01",405,225,3,153,3,36,4254.035277]
[null,null,null,null,"2019-10-01","PL",4856,null,null,null,null,null,null,null,null,null,null,"2019-05-01",418,218,5,144,0,30,3973.95,null,"2019-05-01",5264,2652,62,1925,12,376,null,"2019-05-01",418,218,5,144,0,30,3973.95]
[null,null,null,null,"2019-11-01","PL",4511,null,null,null,null,null,null,null,null,null,null,"2019-06-01",372,214,6,135,2,22,4900.1118180000003,null,"2019-06-01",5118,2609,60,1874,11,355,null,"2019-06-01",373,214,6,135,2,22,4900.1118180000003]
[null,null,null,null,"2019-12-01","PL",3410,null,null,null,null,null,null,null,null,null,null,"2019-07-01",431,222,3,130,3,27,4078.7903700000002,null,"2019-07-01",5071,2567,53,1805,14,341,null,"2019-07-01",431,222,3,130,3,27,4078.7903700000002]
[null,null,null,null,"2020-01-01","PL",4662,null,null,null,null,null,null,null,null,null,null,"2019-08-01",366,206,2,117,0,24,4280.0758329999999,null,"2019-08-01",5021,2531,44,1750,13,332,null,"2019-08-01",367,206,2,117,0,24,4280.0758329999999]
[null,null,null,null,"2020-02-01","PL",4531,null,null,null,null,null,null,null,null,null,null,"2019-09-01",384,190,5,134,0,28,4135.5749999999998,null,"2019-09-01",4976,2529,48,1734,13,330,null,"2019-09-01",385,190,5,134,0,28,4135.5749999999998]
[null,null,null,null,"2020-03-01","PL",4300,null,null,null,null,null,null,null,null,null,null,"2019-10-01",432,173,5,152,1,37,4641.1124319999999,null,"2019-10-01",4894,2478,46,1690,14,337,null,"2019-10-01",432,174,5,152,1,37,4641.1124319999999]
[null,null,null,null,"2020-04-01","PL",2843,null,null,null,null,null,null,null,null,null,null,"2019-11-01",327,171,6,114,1,30,4546.5969999999998,null,"2019-11-01",4786,2400,46,1661,14,343,null,"2019-11-01",327,171,6,114,1,30,4546.5969999999998]
[null,null,null,null,"2020-05-01","PL",2349,null,null,null,null,null,null,null,null,null,null,"2019-12-01",252,144,5,95,4,15,3946.0520000000001,null,"2019-12-01",4739,2367,49,1621,16,331,null,"2019-12-01",254,144,5,95,4,15,3946.0520000000001]
[null,null,null,null,"2020-06-01","PL",2805,null,null,null,null,null,null,null,null,null,null,"2020-01-01",325,134,6,111,2,27,3777.607407,null,"2020-01-01",4625,2294,54,1570,17,334,null,"2020-01-01",325,132,6,111,2,27,3777.607407]
[null,null,null,null,"2020-07-01","PL",3331,null,null,null,null,null,null,null,null,null,null,"2020-02-01",364,116,1,97,0,29,5334.2286199999999,null,"2020-02-01",4520,2260,51,1536,17,334,null,"2020-02-01",364,114,1,97,0,29,5334.2286199999999]
[null,null,null,null,"2020-08-01","PL",2917,null,null,null,null,null,null,null,null,null,null,"2020-03-01",335,174,4,104,0,48,4100.90625,null,"2020-03-01",4411,2187,51,1486,16,353,null,"2020-03-01",335,173,4,104,0,48,4100.90625]
[null,null,null,null,"2020-09-01","PL",3548,null,null,null,null,null,null,null,null,null,null,"2020-04-01",380,142,1,113,2,50,4034.8254000000002,null,"2020-04-01",4386,2104,49,1446,15,367,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",240,125,7,92,0,38,4309.4368420000001,null,"2020-05-01",4208,2011,51,1394,15,375,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",285,175,5,102,0,51,4113.3231370000003,null,"2020-06-01",4121,1972,50,1361,13,404,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",297,124,2,86,1,35,3696.72,null,"2020-07-01",3987,1874,49,1317,11,412,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",189,122,1,79,0,23,3929.012608,null,"2020-08-01",3810,1790,48,1279,11,411,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",297,113,2,66,0,21,4429.1238089999997,null,"2020-09-01",3723,1713,45,1211,11,404]

{"sheet":"Year Calculations","index":2,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Period","CNFs sent","CNFs left at stage 1","Stage 2 exit","Exit process","Court pack","Settled claims"]
["2013-14",11805,4361,51,3495,20,297]
["2014-15",21992,8084,328,10126,109,977]
["2015-16",15363,6758,235,7083,56,1042]
["2016-17",9738,4005,161,4092,26,656]
["2017-18",7472,3609,91,3129,30,485]
["2018-19",5071,2567,53,1805,14,341]
["2019-20",4473,2109,52,1462,11,456]