{"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":[[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,282195,null,"Left process at stage 1:",null,null,130519,null,"Left process at stage 2:",null,null,7428,null,"Exited process:",null,null,56913,null,"Settled:",null,42227,null,"Remaining:",null,45108]
[]
["Δ from last month:",null,3138,null,"Δ from last month:",null,null,1502,null,"Δ from last month:",null,null,134,null,"Δ from last month:",null,null,817,null,"Δ from last month:",null,600,null,"Δ from last month:",null,85]
[]
["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,72905,null,71722,null,1183]
["Other",null,null,null,null,null,null,57614,null,57295,null,319]
["Total",null,null,null,null,null,null,130519,null,129017,null,1502]
["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,71,null,70,null,1]
["Settlement pack repudiated:",null,null,null,null,null,null,48,null,47,null,1]
["Settlement pack timeout:",null,null,null,null,null,null,3782,null,3742,null,40]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,3527,null,3435,null,92]
["Total",null,null,null,null,null,null,7428,null,7294,null,134]

{"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,282195,130519,3901,56913,3527,42227,275477.20203799999]
[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",207,5,0,13,0,1,1500,null,"2013-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01",922,53,0,54,0,2,2051,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",1876,321,0,134,0,16,1721.875,null,"2013-10-01"]
["2018-10-01",46267,null,"2018-10-01",78,null,"2018-10-01",4338.2498480000004,null,null,null,null,null,null,null,null,null,"2013-11-01",2258,633,1,159,0,29,2277.0844820000002,null,"2013-11-01"]
["2018-11-01",46070,null,"2018-11-01",73,null,"2018-11-01",4075.4228800000001,null,null,null,null,null,null,null,null,null,"2013-12-01",1997,822,6,166,0,47,2127.1344680000002,null,"2013-12-01"]
["2018-12-01",46095,null,"2018-12-01",73,null,"2018-12-01",4212.3785470000003,null,null,null,null,null,null,null,null,null,"2014-01-01",3201,1113,5,264,0,110,2256.937727,null,"2014-01-01"]
["2019-01-01",45645,null,"2019-01-01",93,null,"2019-01-01",4196.3482830000003,null,null,null,null,null,null,null,null,null,"2014-02-01",3185,1061,10,304,2,145,2444.0285509999999,null,"2014-02-01"]
["2019-02-01",45411,null,"2019-02-01",75,null,"2019-02-01",4302.873157,null,null,null,null,null,null,null,null,null,"2014-03-01",3588,1491,16,336,1,178,2542.0238760000002,null,"2014-03-01"]
["2019-03-01",45373,null,"2019-03-01",70,null,"2019-03-01",4496.9377329999998,null,null,null,null,null,null,null,null,null,"2014-04-01",3555,1598,23,434,8,213,2705.4804220000001,null,"2014-04-01"]
["2019-04-01",45229,null,"2019-04-01",67,null,"2019-04-01",4509.3262750000004,null,null,null,null,null,null,null,null,null,"2014-05-01",3660,1642,27,440,5,291,2969.232027,null,"2014-05-01"]
["2019-05-01",45091,null,"2019-05-01",79,null,"2019-05-01",4442.9177760000002,null,null,null,null,null,null,null,null,null,"2014-06-01",3953,1838,36,532,5,380,2919.2788679999999,null,"2014-06-01"]
["2019-06-01",44770,null,"2019-06-01",72,null,"2019-06-01",4511.205328,null,null,null,null,null,null,null,null,null,"2014-07-01",4655,2008,39,645,10,440,3054.5619999999999,null,"2014-07-01",33057]
["2019-07-01",44841,null,"2019-07-01",87,null,"2019-07-01",4416.6319940000003,null,null,null,null,null,null,null,null,null,"2014-08-01",4045,1903,35,619,9,407,3105.700147,null,"2014-08-01",36895]
["2019-08-01",44574,null,"2019-08-01",76,null,"2019-08-01",4298.788646,null,null,null,null,null,null,null,null,null,"2014-09-01",4584,2145,54,705,9,481,3220.6174839999999,null,"2014-09-01",40557]
["2019-09-01",43926,null,"2019-09-01",92,null,"2019-09-01",4335.1566499999999,null,null,null,null,null,null,null,null,null,"2014-10-01",5108,2268,60,804,15,548,3327.2815139999998,null,"2014-10-01",43789]
[null,null,null,"Grand Total",935,null,"Grand Total",52136.237116999997,null,null,null,null,null,null,null,null,null,"2014-11-01",4333,2101,44,730,22,566,3242.3573139999999,null,"2014-11-01",45864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-01",3714,2202,62,806,10,565,3324.7293450000002,null,"2014-12-01",47581]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-01-01",4526,2034,48,778,22,606,3382.2266989999998,null,"2015-01-01",48906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-01",4741,1712,41,793,20,670,3301.2692229999998,null,"2015-02-01",50462]
[null,64730,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-01",5059,2420,56,920,25,792,3425.002739,null,"2015-03-01",51933]
["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",4283,2089,52,881,22,704,3453.6639060000002,null,"2015-04-01",52661]
["Claim is too complex for process",599,null,72905,1183,57614,319,71,1,48,1,3782,40,3527,92,null,null,"2015-05-01",4222,2031,58,809,25,614,3457.9096570000002,null,"2015-05-01",53223]
["Claim requires further investigation",23197,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-01",4697,2297,72,982,43,781,3544.529884,null,"2015-06-01",53967]
["Duplicated claim",5315,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-01",5041,2396,61,961,37,770,3533.7322199999999,null,"2015-07-01",54353]
["Incomplete information provided on CNF",1413,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-08-01",4287,2113,65,938,30,720,3599.9857499999998,null,"2015-08-01",54595]
["Interim payment for child claimant",30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-09-01",4607,2356,65,964,22,718,3670.9074230000001,null,"2015-09-01",54618]
["Interim Payment partial offer not accepted",32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-10-01",4507,2220,66,859,27,714,3798.0564420000001,null,"2015-10-01",54017]
["Interim Payment request not answered and/or paid on time",426,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-11-01",4373,2175,73,936,34,782,3849.7272889999999,null,"2015-11-01",54057]
["Other",27255,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-12-01",3436,2128,80,912,48,715,3735.6251600000001,null,"2015-12-01",53779]
["Stage 1 costs not paid on time",1685,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01",4001,1969,76,892,34,632,3785.1946670000002,null,"2016-01-01",53254]
["Value of claim below ú1,000",283,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-02-01",4285,1715,70,819,37,697,3956.9560110000002,null,"2016-02-01",52798]
["Value of claim exceeds the upper limit",2824,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-03-01",4445,2180,74,900,35,775,3939.0959870000002,null,"2016-03-01",52184]
["Withdrawal of claim",1506,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-04-01",4292,2093,93,998,39,778,3994.2077370000002,null,"2016-04-01",52193]
["Withdrawal of offer",165,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-01",4113,2022,70,868,36,706,3829.4240930000001,null,"2016-05-01",52084]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-01",3492,2071,104,1019,57,700,4012.5146,null,"2016-06-01",50879]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-01",3412,1663,86,805,51,661,3978.0093339999999,null,"2016-07-01",49250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-08-01",4289,1290,54,595,28,525,4361.6228380000002,null,"2016-08-01",49252]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-01",4403,2104,98,1002,64,641,4287.550733,null,"2016-09-01",49048]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-10-01",4014,1984,56,973,57,652,3817.9603219999999,null,"2016-10-01",48555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-01",4247,2112,75,936,72,675,4087.7506960000001,null,"2016-11-01",48429]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-12-01",3176,1858,71,784,61,574,3893.9097029999998,null,"2016-12-01",48169]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-01-01",3993,1800,64,915,57,666,4096.5334380000004,null,"2017-01-01",48161]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-01",4102,1537,72,760,63,659,4069.9781330000001,null,"2017-02-01",47978]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-03-01",4546,2134,48,1057,69,763,4015.2108119999998,null,"2017-03-01",48079]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-01",3367,1640,60,723,54,617,4083.9455910000001,null,"2017-04-01",47154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-05-01",4078,1903,57,921,63,627,4107.9435080000003,null,"2017-05-01",47119]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-06-01",3973,1934,63,950,90,628,4217.261082,null,"2017-06-01",47600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-07-01",3518,1813,52,818,47,618,4173.3238339999998,null,"2017-07-01",47706]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-01",3963,1707,60,870,79,661,4001.1070800000002,null,"2017-08-01",47380]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-01",3646,1662,57,842,95,591,4158.863824,null,"2017-09-01",46623]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-01",4163,1787,71,949,81,691,4116.1026330000004,null,"2017-10-01",46772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-01",4149,1907,63,919,81,674,4381.1367060000002,null,"2017-11-01",46674]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-01",2747,1680,48,749,70,475,4322.5657259999998,null,"2017-12-01",46245]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-01",4234,1872,38,817,86,641,4332.0016530000003,null,"2018-01-01",46486]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-01",3938,1484,34,732,79,548,4215.5804010000002,null,"2018-02-01",46322]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-01",3929,1918,54,888,80,630,4155.2111420000001,null,"2018-03-01",45705]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01",3924,1769,66,818,77,621,4176.2120450000002,null,"2018-04-01",46262]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-01",3859,1825,61,892,64,650,4069.7289839999999,null,"2018-05-01",46043]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-01",3761,1902,43,887,104,692,4359.973395,null,"2018-06-01",45831]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-01",3952,1790,60,902,76,661,4312.5024960000001,null,"2018-07-01",46265]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-01",3852,1805,53,922,90,623,4206.6214120000004,null,"2018-08-01",46154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01",3786,1661,48,873,65,625,4283.004688,null,"2018-09-01",46294]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-01",4134,1885,68,1006,78,660,4338.2498480000004,null,"2018-10-01",46265]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-01",3949,1841,57,880,73,684,4075.4228800000001,null,"2018-11-01",46065]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-01",2771,1635,62,746,73,537,4212.3785470000003,null,"2018-12-01",46089]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01",3783,1790,57,857,93,705,4196.3482830000003,null,"2019-01-01",45638]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01",3700,1346,63,658,75,608,4302.873157,null,"2019-02-01",45400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",3889,1814,49,796,70,728,4496.9377329999998,null,"2019-03-01",45360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01",3776,1793,45,805,67,698,4509.3262750000004,null,"2019-04-01",45212]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01",3726,1900,48,916,79,697,4442.9177760000002,null,"2019-05-01",45079]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01",3447,1674,48,883,72,593,4511.205328,null,"2019-06-01",44765]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01",4036,1880,46,968,87,692,4416.6319940000003,null,"2019-07-01",44849]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01",3577,1693,62,908,76,643,4298.788646,null,"2019-08-01",44574]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01",3138,1502,42,817,92,600,4335.1566499999999,null,"2019-09-01",43926]

{"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",33057,12585,163,3481,31,1852]
["2014-15",54353,25598,643,9788,259,7504]
["2015-16",49250,24705,922,10910,450,8598]
["2016-17",47706,22109,770,10434,725,7645]
["2017-18",46265,21303,655,10265,972,7535]
["2018-19",51564,24219,748,12035,1090,9093]