{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Backing Sheet Data","Year Calculations"],"not_rendered":{"charts":4,"images":2,"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":[[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],[13,0,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[10,0,11,12],[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],[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],[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],[6,11,6,12],[6,9,6,10],[6,7,6,8],[4,0,5,12],[2,0,3,1],[6,0,6,6]]}
["Total Sent:",null,{"$f":"'Backing Sheet Data'!S2","v":72175},null,"Left process at stage 1:",null,null,{"$f":"'Backing Sheet Data'!T2","v":29756},null,"Left process at stage 2:",null,null,{"$f":"'Backing Sheet Data'!U2+'Backing Sheet Data'!W2","v":1180},null,"Exited process:",null,null,{"$f":"'Backing Sheet Data'!V2","v":29973},null,"Settled:",null,{"$f":"'Backing Sheet Data'!X2","v":3849},null,"Remaining:",null,{"$f":"C1-H1-M1-R1-V1","v":7417}]
[]
["Δ from last month:",null,{"$f":"VLOOKUP('Backing Sheet Data'!$B$2,tblELDBackingData[],2,FALSE)","v":361},null,"Δ from last month:",null,null,{"$f":"VLOOKUP('Backing Sheet Data'!$B$2,tblELDBackingData[],3,FALSE)","v":166},null,"Δ from last month:",null,null,{"$f":"VLOOKUP('Backing Sheet Data'!$B$2,tblELDBackingData[],4,FALSE)+VLOOKUP('Backing Sheet Data'!$B$2,tblELDBackingData[],6,FALSE)","v":4},null,"Δ from last month:",null,null,{"$f":"VLOOKUP('Backing Sheet Data'!$B$2,tblELDBackingData[],5,FALSE)","v":126},null,"Δ from last month:",null,{"$f":"VLOOKUP('Backing Sheet Data'!$B$2,tblELDBackingData[],7,FALSE)","v":27},null,"Δ from last month:",null,{"$f":"C3-H3-M3-R3-V3","v":38}]
[]
["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,{"$f":"'Backing Sheet Data'!D25","v":24030},null,{"$f":"H8-L8","v":23880},null,{"$f":"'Backing Sheet Data'!E25","v":150}]
["Other",null,null,null,null,null,null,{"$f":"'Backing Sheet Data'!F25","v":5726},null,{"$f":"H9-L9","v":5710},null,{"$f":"'Backing Sheet Data'!G25","v":16}]
["Total",null,null,null,null,null,null,{"$f":"SUM(H8:I9)","v":29756},null,{"$f":"SUM(J8:K9)","v":29590},null,{"$f":"SUM(L8:M9)","v":166}]
["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,{"$f":"'Backing Sheet Data'!H25","v":4},null,{"$f":"H14-L14","v":4},null,{"$f":"'Backing Sheet Data'!I25","v":0}]
["Settlement pack repudiated:",null,null,null,null,null,null,{"$f":"'Backing Sheet Data'!J25","v":501},null,{"$f":"H15-L15","v":497},null,{"$f":"'Backing Sheet Data'!K25","v":4}]
["Settlement pack timeout:",null,null,null,null,null,null,{"$f":"'Backing Sheet Data'!L25","v":420},null,420,null,{"$f":"'Backing Sheet Data'!M25","v":0}]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,{"$f":"'Backing Sheet Data'!N25","v":255},null,255,null,{"$f":"'Backing Sheet Data'!O25","v":0}]
["Total",null,null,null,null,null,null,{"$f":"SUM(H14:I17)","v":1180},null,{"$f":"SUM(J14:K17)","v":1176},null,{"$f":"SUM(L14:M17)","v":4}]

{"sheet":"Backing Sheet Data","index":1,"n_rows":77,"n_cols":28,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
["Reporting date","2019-10-01"]
["Latest month","2019-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72175,29756,925,29973,255,3849,287384.04052200005]
[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-12-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,"2014-01-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,"2014-02-01"]
["2018-10-01",6618,null,"2018-10-01",0,null,"2018-10-01",4481.6093330000003,null,null,null,null,null,null,null,null,null,"2013-11-01",815,284,0,126,0,0,null,null,"2014-03-01"]
["2018-11-01",6363,null,"2018-11-01",1,null,"2018-11-01",4158.0541659999999,null,null,null,null,null,null,null,null,null,"2013-12-01",724,346,2,178,0,3,3309.6666660000001,null,"2014-04-01"]
["2018-12-01",6185,null,"2018-12-01",2,null,"2018-12-01",3616.788888,null,null,null,null,null,null,null,null,null,"2014-01-01",1071,507,1,268,0,5,5208,null,"2014-05-01"]
["2019-01-01",5908,null,"2019-01-01",1,null,"2019-01-01",3734.3850000000002,null,null,null,null,null,null,null,null,null,"2014-02-01",998,377,3,212,0,21,5377.8590469999999,null,"2014-06-01"]
["2019-02-01",5702,null,"2019-02-01",0,null,"2019-02-01",4074.730689,null,null,null,null,null,null,null,null,null,"2014-03-01",1251,478,3,374,3,34,5664.8529410000001,null,"2014-07-01"]
["2019-03-01",5462,null,"2019-03-01",1,null,"2019-03-01",3890.4275859999998,null,null,null,null,null,null,null,null,null,"2014-04-01",1388,446,5,407,2,32,4801.6068750000004,null,"2014-08-01"]
["2019-04-01",5340,null,"2019-04-01",3,null,"2019-04-01",4254.035277,null,null,null,null,null,null,null,null,null,"2014-05-01",1359,545,4,547,4,42,5028.2223800000002,null,"2014-09-01"]
["2019-05-01",5268,null,"2019-05-01",0,null,"2019-05-01",3973.95,null,null,null,null,null,null,null,null,null,"2014-06-01",1351,590,14,589,8,74,4828.9143240000003,null,"2014-10-01"]
["2019-06-01",5126,null,"2019-06-01",2,null,"2019-06-01",4900.1118180000003,null,null,null,null,null,null,null,null,null,"2014-07-01",1727,543,19,651,3,86,4877.246744,null,"2014-11-01",15879]
["2019-07-01",5080,null,"2019-07-01",3,null,"2019-07-01",4078.7903700000002,null,null,null,null,null,null,null,null,null,"2014-08-01",1303,512,12,654,10,58,4740.3146550000001,null,"2014-12-01",16464]
["2019-08-01",5032,null,"2019-08-01",0,null,"2019-08-01",4280.0758329999999,null,null,null,null,null,null,null,null,null,"2014-09-01",1605,559,34,703,10,106,4555.8396220000004,null,"2015-01-01",17204]
["2019-09-01",4963,null,"2019-09-01",0,null,"2019-09-01",4173.6777769999999,null,null,null,null,null,null,null,null,null,"2014-10-01",1584,552,34,727,20,106,4804.3396220000004,null,"2015-02-01",18567]
[null,null,null,"Grand Total",13,null,"Grand Total",49616.636737000001,null,null,null,null,null,null,null,null,null,"2014-11-01",1518,535,31,680,11,83,4192.8449389999996,null,"2015-03-01",19963]
[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,"2015-04-01",20828]
[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-05-01",21318]
[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-06-01",21939]
[null,33009,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-07-01",21991]
["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",2253,860,28,1182,7,74,4358.1350000000002,null,"2015-08-01",22316]
["Claim is too complex for process",161,null,24030,150,5726,16,4,0,501,4,420,0,255,0,null,null,"2015-05-01",1849,781,20,988,5,86,3996.8166270000002,null,"2015-09-01",22574]
["Claim requires further investigation",14268,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-10-01",22883]
["Duplicated claim",2565,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-11-01",22988]
["Incomplete information provided on CNF",5426,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-08-01",1628,655,26,649,3,74,3784.8224319999999,null,"2015-12-01",23074]
["Interim payment for child claimant",12,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,"2016-01-01",22632]
["Interim Payment partial offer not accepted",1,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,"2016-02-01",21491]
["Interim Payment request not answered and/or paid on time",14,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,"2016-03-01",19939]
["Other",9234,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,"2016-04-01",18661]
["Stage 1 costs not paid on time",108,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-05-01",17670]
["Value of claim below ú1,000",28,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-06-01",16448]
["Value of claim exceeds the upper limit",106,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-07-01",15360]
["Withdrawal of claim",990,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-08-01",14582]
["Withdrawal of offer",96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-01",858,447,18,358,3,59,3943.3115250000001,null,"2016-09-01",13566]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-01",750,382,23,417,6,80,3885.6522500000001,null,"2016-10-01",12488]
[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-11-01",11718]
[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-12-01",10937]
[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,"2017-01-01",10411]
[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,"2017-02-01",10046]
[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,"2017-03-01",9893]
[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,"2017-04-01",9618]
[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-05-01",9560]
[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-06-01",9711]
[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-07-01",9738]
[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-08-01",9638]
[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-09-01",9499]
[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-10-01",9440]
[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-11-01",9277]
[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-12-01",9140]
[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,"2018-01-01",9013]
[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,"2018-02-01",8833]
[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,"2018-03-01",8577]
[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,"2018-04-01",8404]
[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-05-01",8095]
[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-06-01",7712]
[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-07-01",7472]
[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-08-01",7138]
[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-09-01",6860]
[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-10-01",6618]
[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-11-01",6363]
[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-12-01",6185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01",430,192,1,150,0,30,4121.1453330000004,null,"2019-01-01",5908]
[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,"2019-02-01",5702]
[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,"2019-03-01",5460]
[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,"2019-04-01",5338]
[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-05-01",5266]
[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-06-01",5121]
[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-07-01",5077]
[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-08-01",5032]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01",419,218,5,144,0,30,3973.95,null,"2019-09-01",4963]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01",434,222,3,130,3,27,4078.7903700000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01",371,206,2,117,0,24,4280.0758329999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01",361,166,4,126,0,27,4173.6777769999999]

{"sheet":"Year Calculations","index":2,"n_rows":7,"n_cols":7,"rows_kept":7,"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",21991,8084,328,10126,109,977]
["2015-16",15360,6758,235,7083,56,1042]
["2016-17",9738,4005,161,4092,26,656]
["2017-18",7472,3609,91,3129,30,485]
["2018-19",5809,2939,59,2048,14,392]