{"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":4,"comments":1,"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,267741,null,"Left process at stage 1:",null,null,123412,null,"Left process at stage 2:",null,null,6916,null,"Exited process:",null,null,53297,null,"Settled:",null,39668,null,"Remaining:",null,44448]
[]
["Δ from last month:",null,3454,null,"Δ from last month:",null,null,1540,null,"Δ from last month:",null,null,120,null,"Δ from last month:",null,null,876,null,"Δ from last month:",null,662,null,"Δ from last month:",null,256]
[]
["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,68415,null,67242,null,1173]
["Other",null,null,null,null,null,null,55018,null,54651,null,367]
["Total",null,null,null,null,null,null,123433,null,121893,null,1540]
["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,65,null,62,null,3]
["Settlement pack repudiated:",null,null,null,null,null,null,45,null,44,null,1]
["Settlement pack timeout:",null,null,null,null,null,null,3594,null,3550,null,44]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,3214,null,3142,null,72]
["Total",null,null,null,null,null,null,6918,null,6798,null,120]

{"sheet":"Backing Sheet Data","index":1,"n_rows":73,"n_cols":28,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["Reporting date","2019-06-01"]
["Latest month","2019-05-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,267741,123412,3704,53297,3212,39668,257938.40544200008]
[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",923,53,0,54,1,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-05-01",46044,null,"2018-05-01",104,null,"2018-05-01",4359.973395,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-06-01",45832,null,"2018-06-01",76,null,"2018-06-01",4312.5024960000001,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-07-01",46267,null,"2018-07-01",90,null,"2018-07-01",4206.6214120000004,null,null,null,null,null,null,null,null,null,"2014-01-01",3206,1113,5,264,4,110,2256.937727,null,"2014-01-01"]
["2018-08-01",46155,null,"2018-08-01",65,null,"2018-08-01",4283.004688,null,null,null,null,null,null,null,null,null,"2014-02-01",3185,1061,10,304,2,145,2444.0285509999999,null,"2014-02-01"]
["2018-09-01",46296,null,"2018-09-01",78,null,"2018-09-01",4338.2498480000004,null,null,null,null,null,null,null,null,null,"2014-03-01",3588,1491,16,336,1,178,2542.0238760000002,null,"2014-03-01"]
["2018-10-01",46267,null,"2018-10-01",73,null,"2018-10-01",4075.4228800000001,null,null,null,null,null,null,null,null,null,"2014-04-01",3555,1598,23,434,8,213,2705.4804220000001,null,"2014-04-01"]
["2018-11-01",46070,null,"2018-11-01",73,null,"2018-11-01",4212.3785470000003,null,null,null,null,null,null,null,null,null,"2014-05-01",3660,1642,27,440,5,291,2969.232027,null,"2014-05-01"]
["2018-12-01",46095,null,"2018-12-01",93,null,"2018-12-01",4196.3482830000003,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-01-01",45645,null,"2019-01-01",75,null,"2019-01-01",4302.873157,null,null,null,null,null,null,null,null,null,"2014-07-01",4654,2008,39,645,10,440,3054.5619999999999,null,"2014-07-01",33062]
["2019-02-01",45413,null,"2019-02-01",70,null,"2019-02-01",4504.7552400000004,null,null,null,null,null,null,null,null,null,"2014-08-01",4045,1903,35,619,9,407,3105.700147,null,"2014-08-01",36900]
["2019-03-01",45377,null,"2019-03-01",67,null,"2019-03-01",4509.3262750000004,null,null,null,null,null,null,null,null,null,"2014-09-01",4587,2145,54,705,11,481,3220.6174839999999,null,"2014-09-01",40564]
["2019-04-01",45220,null,"2019-04-01",72,null,"2019-04-01",4469.8091990000003,null,null,null,null,null,null,null,null,null,"2014-10-01",5108,2268,61,804,15,548,3327.2815139999998,null,"2014-10-01",43796]
[null,null,null,"Grand Total",936,null,"Grand Total",51771.265420000003,null,null,null,null,null,null,null,null,null,"2014-11-01",4332,2102,44,730,22,566,3242.3573139999999,null,"2014-11-01",45870]
[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",47587]
[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",48907]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-01",4743,1712,41,793,20,670,3301.2692229999998,null,"2015-02-01",50465]
[null,60923,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-01",5059,2421,56,920,25,792,3425.002739,null,"2015-03-01",51936]
["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",52664]
["Claim is too complex for process",568,null,68415,1173,55018,367,65,3,45,1,3594,44,3214,72,null,null,"2015-05-01",4222,2031,58,809,25,614,3457.9096570000002,null,"2015-05-01",53226]
["Claim requires further investigation",21459,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",53970]
["Duplicated claim",5131,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",54357]
["Incomplete information provided on CNF",1346,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-08-01",4286,2113,65,938,30,720,3599.9857499999998,null,"2015-08-01",54598]
["Interim payment for child claimant",29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-09-01",4606,2356,65,964,22,718,3670.9074230000001,null,"2015-09-01",54617]
["Interim Payment partial offer not accepted",29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-10-01",4505,2220,66,859,27,714,3798.0564420000001,null,"2015-10-01",54014]
["Interim Payment request not answered and/or paid on time",398,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-11-01",4379,2175,73,936,41,782,3849.7272889999999,null,"2015-11-01",54061]
["Other",25805,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",53783]
["Stage 1 costs not paid on time",1615,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01",4004,1969,76,892,37,632,3785.1946670000002,null,"2016-01-01",53261]
["Value of claim below ú1,000",273,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",52803]
["Value of claim exceeds the upper limit",2645,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-03-01",4444,2180,74,900,35,775,3939.0959870000002,null,"2016-03-01",52188]
["Withdrawal of claim",1466,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-04-01",4290,2093,93,998,39,778,3994.2077370000002,null,"2016-04-01",52195]
["Withdrawal of offer",159,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-01",4109,2022,70,868,36,706,3829.4240930000001,null,"2016-05-01",52082]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-01",3491,2071,104,1019,57,700,4012.5146,null,"2016-06-01",50876]
[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",49247]
[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",49250]
[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",49047]
[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",48556]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-01",4248,2112,75,936,74,676,4082.6090530000001,null,"2016-11-01",48425]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-12-01",3175,1858,71,784,61,574,3893.9097029999998,null,"2016-12-01",48164]
[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",48153]
[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",47970]
[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",48072]
[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",47149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-05-01",4079,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",47601]
[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",47707]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-01",3964,1707,60,870,79,661,4001.1070800000002,null,"2017-08-01",47382]
[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",46625]
[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",46774]
[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,675,4377.7424289999999,null,"2017-11-01",46675]
[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",46247]
[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",46488]
[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",46324]
[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",45707]
[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",46264]
[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,651,4066.5419959999999,null,"2018-05-01",46044]
[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",45832]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-01",3953,1790,60,902,76,661,4312.5024960000001,null,"2018-07-01",46267]
[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",46155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01",3787,1661,48,873,65,625,4283.004688,null,"2018-09-01",46296]
[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",46267]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-01",3952,1841,57,880,73,684,4075.4228800000001,null,"2018-11-01",46070]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-01",2772,1635,62,746,73,537,4212.3785470000003,null,"2018-12-01",46095]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01",3784,1790,57,857,93,705,4196.3482830000003,null,"2019-01-01",45645]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01",3706,1346,63,658,75,608,4302.873157,null,"2019-02-01",45413]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",3893,1814,49,796,70,729,4504.7552400000004,null,"2019-03-01",45377]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01",3767,1793,45,805,67,698,4509.3262750000004,null,"2019-04-01",45220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01",3454,1540,48,876,72,662,4469.8091990000003,null,"2019-05-01",44815]

{"sheet":"Year Calculations","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Period","CNFs sent","CNFs left at stage 1","Stage 2 exit","Exit process","Court pack","Settled claims"]
["2013-14",33062,12585,163,3481,36,1852]
["2014-15",54357,25600,644,9788,261,7504]
["2015-16",49247,24705,922,10910,460,8598]
["2016-17",47707,22109,770,10434,727,7646]
["2017-18",46267,21303,655,10265,972,7537]
["2018-19",37101,17110,550,8419,756,6531]
[]
[]
["Update last period monthly!"]