{"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":2,"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":18,"n_cols":26,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,11,6,12],[6,9,6,10],[6,7,6,8],[4,0,5,12],[2,0,3,1],[6,0,6,6],[0,2,1,3],[2,2,3,3],[2,12,3,13],[0,0,1,1],[0,4,1,6],[0,9,1,11],[0,7,1,8],[2,4,3,6],[2,9,3,11],[2,7,3,8],[2,21,3,22],[0,12,1,13],[0,17,1,18],[0,21,1,22],[0,25,1,26],[2,19,3,20],[2,23,3,24],[2,25,3,26],[0,23,1,24],[0,19,1,20],[0,14,1,16],[2,14,3,16],[2,17,3,18],[7,11,7,12],[8,11,8,12],[9,11,9,12],[12,0,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[7,7,7,8],[8,7,8,8],[9,7,9,8],[7,9,7,10],[8,9,8,10],[9,9,9,10],[7,0,7,6],[8,0,8,6],[9,0,9,6],[13,0,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[10,0,11,12],[14,0,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[17,0,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[15,0,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[16,0,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12]]}
["Total Sent:",null,74572,null,"Left process at stage 1:",null,null,30810,null,"Left process at stage 2:",null,null,1219,null,"Exited process:",null,null,30758,null,"Settled:",null,4083,null,"Remaining:",null,7702]
[]
["Δ from last month:",null,343,null,"Δ from last month:",null,null,134,null,"Δ from last month:",null,null,3,null,"Δ from last month:",null,null,104,null,"Δ from last month:",null,47,null,"Δ from last month:",null,55]
[]
["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,24941,null,24812,null,129]
["Other",null,null,null,null,null,null,5869,null,5864,null,5]
["Total",null,null,null,null,null,null,30810,null,30676,null,134]
["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,4,null,4,null,0]
["Settlement pack repudiated:",null,null,null,null,null,null,516,null,515,null,1]
["Settlement pack timeout:",null,null,null,null,null,null,434,null,434,null,0]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,265,null,263,null,2]
["Total",null,null,null,null,null,null,1219,null,1216,null,3]

{"sheet":"Backing Sheet Data","index":1,"n_rows":84,"n_cols":28,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
["Reporting date","2020-05-01"]
["Latest month","2020-04-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74572,30810,954,30758,265,4083,317772.73060200008]
[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","Previous 12 months rolling sum"]
["Rolling 12 CNFs sent",null,null,"Court packs rolling 12",null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,"2013-09-01",334,47,0,34,0,0,null,null,"2013-09-01"]
["Period","Rolling 12 Sent",null,"Row Labels","Total Court Packs",null,"Row Labels","Ave General Damages",null,null,null,null,null,null,null,null,null,"2013-10-01",620,197,0,92,0,0,null,null,"2013-10-01"]
["2019-05-01",5265,null,"2019-05-01",0,null,"2019-05-01",3973.95,null,null,null,null,null,null,null,null,null,"2013-11-01",815,284,0,126,0,0,null,null,"2013-11-01"]
["2019-06-01",5120,null,"2019-06-01",2,null,"2019-06-01",4900.1118180000003,null,null,null,null,null,null,null,null,null,"2013-12-01",724,346,2,178,0,3,3309.6666660000001,null,"2013-12-01"]
["2019-07-01",5073,null,"2019-07-01",3,null,"2019-07-01",4078.7903700000002,null,null,null,null,null,null,null,null,null,"2014-01-01",1071,507,1,268,0,5,5208,null,"2014-01-01"]
["2019-08-01",5024,null,"2019-08-01",0,null,"2019-08-01",4280.0758329999999,null,null,null,null,null,null,null,null,null,"2014-02-01",998,377,3,212,0,21,5377.8590469999999,null,"2014-02-01"]
["2019-09-01",4980,null,"2019-09-01",0,null,"2019-09-01",4135.5749999999998,null,null,null,null,null,null,null,null,null,"2014-03-01",1251,478,3,374,3,34,5664.8529410000001,null,"2014-03-01"]
["2019-10-01",4898,null,"2019-10-01",1,null,"2019-10-01",4641.1124319999999,null,null,null,null,null,null,null,null,null,"2014-04-01",1388,446,5,407,2,32,4801.6068750000004,null,"2014-04-01"]
["2019-11-01",4791,null,"2019-11-01",1,null,"2019-11-01",4546.5969999999998,null,null,null,null,null,null,null,null,null,"2014-05-01",1359,545,4,547,4,42,5028.2223800000002,null,"2014-05-01"]
["2019-12-01",4747,null,"2019-12-01",4,null,"2019-12-01",3946.0520000000001,null,null,null,null,null,null,null,null,null,"2014-06-01",1351,590,14,589,8,74,4828.9143240000003,null,"2014-06-01"]
["2020-01-01",4629,null,"2020-01-01",2,null,"2020-01-01",3777.607407,null,null,null,null,null,null,null,null,null,"2014-07-01",1727,543,19,651,3,86,4877.246744,null,"2014-07-01",11805]
["2020-02-01",4525,null,"2020-02-01",0,null,"2020-02-01",5334.2286199999999,null,null,null,null,null,null,null,null,null,"2014-08-01",1303,512,12,654,10,58,4740.3146550000001,null,"2014-08-01",12941]
["2020-03-01",4414,null,"2020-03-01",0,null,"2020-03-01",4100.90625,null,null,null,null,null,null,null,null,null,"2014-09-01",1605,559,34,703,10,106,4555.8396220000004,null,"2014-09-01",14212]
["2020-04-01",4352,null,"2020-04-01",2,null,"2020-04-01",4080.2891479999998,null,null,null,null,null,null,null,null,null,"2014-10-01",1584,552,34,727,20,106,4804.3396220000004,null,"2014-10-01",15176]
[null,null,null,"Grand Total",15,null,"Grand Total",51795.295878000004,null,null,null,null,null,null,null,null,null,"2014-11-01",1518,535,31,680,11,83,4192.8449389999996,null,"2014-11-01",15879]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-01",1309,559,34,705,10,74,4345.0778369999998,null,"2014-12-01",16464]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-01-01",1811,583,31,698,12,64,4383.7940619999999,null,"2015-01-01",17204]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-01",2361,426,28,769,5,70,4623.1801420000002,null,"2015-02-01",18567]
[null,33759,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-01",2647,841,21,1143,5,86,4959.1549999999997,null,"2015-03-01",19963]
["Exit Process Reason","Total",null,"LDT","This Month LDT","Other Liability","This Month Other Liability","Interim Payment Not Agreed","This Month Interim Payment Not Agreed","Repudiated","This Month Repudiated","Timeout","This Month Timeout","Court Proceedings","This Month Court Proceedings",null,null,"2015-04-01",2254,860,28,1182,7,74,4358.1350000000002,null,"2015-04-01",20829]
["Claim requires further investigation",14700,null,24941,129,5869,5,4,0,516,1,434,0,265,2,null,null,"2015-05-01",1849,781,20,988,5,86,3996.8166270000002,null,"2015-05-01",21319]
["Other",9535,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-01",1972,999,24,998,4,78,4745.8085890000002,null,"2015-06-01",21940]
["Incomplete information provided on CNF",5461,null,null,null,null,null,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]
["Duplicated claim",2640,null,null,null,null,null,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]
["Withdrawal of claim",1011,null,null,null,null,null,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]
["Claim is too complex for process",163,null,null,null,null,null,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]
["Value of claim exceeds the upper limit",111,null,null,null,null,null,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]
["Withdrawal of offer",98,null,null,null,null,null,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]
["Value of claim below ú1,000",28,null,null,null,null,null,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]
["Interim payment for child claimant",12,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01",373,214,6,135,2,22,4900.1118180000003,null,"2019-06-01",5119]
[null,null,null,null,null,null,null,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",5072]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01",367,206,2,117,0,24,4280.0758329999999,null,"2019-08-01",5023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01",385,190,5,134,0,28,4135.5749999999998,null,"2019-09-01",4979]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01",432,172,5,152,1,37,4641.1124319999999,null,"2019-10-01",4897]
[null,null,null,null,null,null,null,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",4789]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01",254,144,5,95,4,15,3946.0520000000001,null,"2019-12-01",4744]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01",325,126,6,111,2,27,3777.607407,null,"2020-01-01",4630]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-01",364,113,1,97,0,29,5334.2286199999999,null,"2020-02-01",4525]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-01",333,170,4,104,0,48,4100.90625,null,"2020-03-01",4414]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-01",343,134,1,104,2,47,4080.2891479999998,null,"2020-04-01",4352]

{"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",5072,2567,53,1805,14,341]
["2019-20",3130,1426,35,1028,10,285]