{"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":[[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,407635,null,"Left process at stage 1:",null,null,235985,null,"Left process at stage 2:",null,null,8668,null,"Exited process:",null,null,66123,null,"Settled:",null,41402,null,"Remaining:",null,55457]
[]
["Δ from last month:",null,2629,null,"Δ from last month:",null,null,2253,null,"Δ from last month:",null,null,112,null,"Δ from last month:",null,null,713,null,"Δ from last month:",null,449,null,"Δ from last month:",null,-898]
[]
["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,103796,null,102167,null,1629]
["Other",null,null,null,null,null,null,132189,null,131565,null,624]
["Total",null,null,null,null,null,null,235985,null,233732,null,2253]
["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,63,null,58,null,5]
["Settlement pack repudiated:",null,null,null,null,null,null,159,null,158,null,1]
["Settlement pack timeout:",null,null,null,null,null,null,4254,null,4212,null,42]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,4192,null,4128,null,64]
["Total",null,null,null,null,null,null,8668,null,8556,null,112]

{"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,407635,235985,4476,66123,4192,41402,301722.97319000005]
[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",370,6,0,27,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",1849,208,0,91,0,4,1300,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",3391,840,1,224,0,8,1281.25,null,"2013-10-01"]
["2019-05-01",56041,null,"2019-05-01",72,null,"2019-05-01",4283.9964950000003,null,null,null,null,null,null,null,null,null,"2013-11-01",3851,1558,0,271,0,39,1977.948717,null,"2013-11-01"]
["2019-06-01",55488,null,"2019-06-01",79,null,"2019-06-01",4252.704495,null,null,null,null,null,null,null,null,null,"2013-12-01",3361,1837,6,293,0,50,2105,null,"2013-12-01"]
["2019-07-01",55719,null,"2019-07-01",78,null,"2019-07-01",4552.9510890000001,null,null,null,null,null,null,null,null,null,"2014-01-01",5241,2352,10,479,2,108,2417.3500920000001,null,"2014-01-01"]
["2019-08-01",55611,null,"2019-08-01",82,null,"2019-08-01",4406.4034320000001,null,null,null,null,null,null,null,null,null,"2014-02-01",5112,2165,16,443,4,149,2474.980067,null,"2014-02-01"]
["2019-09-01",55390,null,"2019-09-01",59,null,"2019-09-01",4234.2869369999999,null,null,null,null,null,null,null,null,null,"2014-03-01",5783,3147,29,581,5,208,2764.1224510000002,null,"2014-03-01"]
["2019-10-01",54883,null,"2019-10-01",89,null,"2019-10-01",4512.5319449999997,null,null,null,null,null,null,null,null,null,"2014-04-01",5531,3269,26,675,7,245,2658.4375100000002,null,"2014-04-01"]
["2019-11-01",54226,null,"2019-11-01",77,null,"2019-11-01",4165.4439329999996,null,null,null,null,null,null,null,null,null,"2014-05-01",5843,3467,34,730,4,269,2944.2115610000001,null,"2014-05-01"]
["2019-12-01",54221,null,"2019-12-01",58,null,"2019-12-01",4213.0240460000005,null,null,null,null,null,null,null,null,null,"2014-06-01",6217,3535,41,749,22,344,3020.030377,null,"2014-06-01"]
["2020-01-01",54217,null,"2020-01-01",62,null,"2020-01-01",4338.7701550000002,null,null,null,null,null,null,null,null,null,"2014-07-01",7252,3973,53,881,19,446,3146.8208960000002,null,"2014-07-01",53801]
["2020-02-01",54186,null,"2020-02-01",84,null,"2020-02-01",4327.5731969999997,null,null,null,null,null,null,null,null,null,"2014-08-01",6164,3643,37,754,13,384,3308.3370570000002,null,"2014-08-01",59595]
["2020-03-01",53641,null,"2020-03-01",74,null,"2020-03-01",4435.1404220000004,null,null,null,null,null,null,null,null,null,"2014-09-01",7274,4136,62,1008,22,485,3106.994659,null,"2014-09-01",65020]
["2020-04-01",51869,null,"2020-04-01",64,null,"2020-04-01",4405.3986850000001,null,null,null,null,null,null,null,null,null,"2014-10-01",7688,4310,60,1134,34,616,3176.7030840000002,null,"2014-10-01",69317]
[null,null,null,"Grand Total",878,null,"Grand Total",52128.224830999992,null,null,null,null,null,null,null,null,null,"2014-11-01",6262,4079,62,971,28,563,3329.6076549999998,null,"2014-11-01",71728]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-01",5256,4091,62,979,37,579,3291.0112079999999,null,"2014-12-01",73623]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-01-01",6220,3618,55,977,28,633,3313.3723060000002,null,"2015-01-01",74602]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-01",6330,3152,67,833,43,633,3339.5623529999998,null,"2015-02-01",75820]
[null,77636,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-01",6750,4068,65,1072,38,730,3404.7033419999998,null,"2015-03-01",76787]
["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",5915,3802,79,953,40,661,3577.5724650000002,null,"2015-04-01",77171]
["Other",33876,null,103796,1629,132189,624,63,5,159,1,4254,42,4192,64,null,null,"2015-05-01",5415,3397,70,949,29,632,3448.4915339999998,null,"2015-05-01",76743]
["Claim requires further investigation",25974,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-01",6378,3939,59,1006,40,729,3627.6689430000001,null,"2015-06-01",76904]
["Duplicated claim",6591,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-01",6816,3911,75,1063,44,748,3798.3083550000001,null,"2015-07-01",76468]
["Incomplete information provided on CNF",5235,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-08-01",5962,3590,60,939,38,626,3750.637843,null,"2015-08-01",76266]
["Withdrawal of claim",2570,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-09-01",6183,3947,79,1028,52,675,3700.0653619999998,null,"2015-09-01",75175]
["Value of claim exceeds the upper limit",2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-10-01",6163,3769,68,1020,42,722,3454.2663149999998,null,"2015-10-01",73650]
["Claim is too complex for process",707,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-11-01",5843,3603,85,1008,50,709,3808.7843579999999,null,"2015-11-01",73231]
["Value of claim below ú1,000",391,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-12-01",4584,3447,87,881,45,640,3785.0480309999998,null,"2015-12-01",72559]
["Withdrawal of offer",237,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01",5224,3271,60,933,39,620,3964.2704669999998,null,"2016-01-01",71563]
["Interim payment for child claimant",55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-02-01",5741,2786,61,859,51,662,3763.3202409999999,null,"2016-02-01",70974]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-03-01",5739,3433,76,1026,50,676,3927.2018629999998,null,"2016-03-01",69963]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-04-01",5467,3395,80,981,45,662,3829.3263740000002,null,"2016-04-01",69515]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-01",5008,3163,71,982,45,568,3940.3162499999999,null,"2016-05-01",69108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-01",4436,3405,87,973,68,627,3940.8149440000002,null,"2016-06-01",67166]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-01",4825,2698,91,884,54,526,4052.135988,null,"2016-07-01",65175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-08-01",5351,2216,38,606,35,561,3945.6738140000002,null,"2016-08-01",64564]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-01",5700,3277,84,954,77,604,3909.7556949999998,null,"2016-09-01",64081]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-10-01",5182,3203,87,991,53,611,3817.7136329999998,null,"2016-10-01",63100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-01",5207,3320,86,939,61,602,4037.5911120000001,null,"2016-11-01",62464]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-12-01",3892,2775,76,784,56,537,4184.4410980000002,null,"2016-12-01",61772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-01-01",5119,2833,74,878,85,574,3854.9294249999998,null,"2017-01-01",61667]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-01",4907,2374,56,750,64,599,3942.1031210000001,null,"2017-02-01",60833]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-03-01",5804,3297,80,944,78,650,4167.2315230000004,null,"2017-03-01",60898]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-01",4124,2622,66,742,44,568,4270.8655099999996,null,"2017-04-01",59555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-05-01",5058,3139,63,873,77,637,4016.5316320000002,null,"2017-05-01",59605]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-06-01",4984,2962,67,891,72,599,4289.4138059999996,null,"2017-06-01",60153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-07-01",4865,2907,64,909,87,570,4294.2862800000003,null,"2017-07-01",60193]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-01",5186,2924,62,901,72,561,4113.8683950000004,null,"2017-08-01",60028]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-01",4906,2888,57,823,65,537,4020.2592359999999,null,"2017-09-01",59234]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-01",5256,3055,64,894,84,560,4083.8753390000002,null,"2017-10-01",59308]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-01",5165,3115,52,922,89,575,4293.3424859999996,null,"2017-11-01",59266]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-01",3611,2616,58,766,73,447,4242.8048989999998,null,"2017-12-01",58985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-01",5161,2877,47,890,75,521,4110.3657579999999,null,"2018-01-01",59027]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-01",4956,2271,52,744,61,554,4213.6596200000004,null,"2018-02-01",59076]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-01",4822,2970,73,893,81,576,4151.8092880000004,null,"2018-03-01",58094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01",4664,2772,69,825,55,538,4344.9202230000001,null,"2018-04-01",58634]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-01",4739,2887,62,889,73,567,4182.4503169999998,null,"2018-05-01",58315]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-01",4741,2818,56,819,78,544,3965.8975359999999,null,"2018-06-01",58072]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-01",4848,2817,51,939,69,502,4339.6875689999997,null,"2018-07-01",58055]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-01",4892,2911,57,905,76,505,4379.1376630000004,null,"2018-08-01",57761]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01",4735,2565,50,848,60,443,4282.2780130000001,null,"2018-09-01",57590]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-01",5369,3010,48,985,70,560,4335.4767499999998,null,"2018-10-01",57703]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-01",5180,3053,54,979,59,627,4329.4685639999998,null,"2018-11-01",57718]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-01",3432,2557,43,742,48,471,3918.6642459999998,null,"2018-12-01",57539]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01",4652,3001,60,818,82,538,4257.2791070000003,null,"2019-01-01",57030]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01",4582,2096,55,615,66,546,3956.2582050000001,null,"2019-02-01",56656]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",4831,2831,45,773,82,643,4356.284447,null,"2019-03-01",56665]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01",4401,2782,50,729,69,514,4257.751381,null,"2019-04-01",56402]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01",4375,2882,45,850,72,545,4283.9964950000003,null,"2019-05-01",56038]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01",4188,2614,61,729,79,476,4252.704495,null,"2019-06-01",55485]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01",5079,2851,52,889,78,569,4552.9510890000001,null,"2019-07-01",55716]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01",4785,2607,44,780,82,472,4406.4034320000001,null,"2019-08-01",55609]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01",4514,2848,45,791,59,480,4234.2869369999999,null,"2019-09-01",55388]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01",4861,2515,67,851,89,550,4512.5319449999997,null,"2019-10-01",54880]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-01",4518,2201,40,806,77,511,4165.4439329999996,null,"2019-11-01",54218]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01",3420,2105,43,724,58,430,4213.0240460000005,null,"2019-12-01",54206]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01",4670,2265,40,806,62,515,4338.7701550000002,null,"2020-01-01",54224]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-01",4544,1703,41,689,84,491,4327.5731969999997,null,"2020-02-01",54186]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-01",4286,2390,70,878,74,497,4435.1404220000004,null,"2020-03-01",53641]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-01",2629,2253,48,713,64,449,4405.3986850000001,null,"2020-04-01",51869]

{"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",53801,26357,216,5444,63,1870]
["2014-15",76468,46146,753,11699,396,7393]
["2015-16",65175,40507,905,11514,579,7713]
["2016-17",60193,34925,841,10261,789,7112]
["2017-18",58055,34010,703,10305,875,6482]
["2018-19",55716,33153,620,9862,841,6437]
["2019-20",38227,20887,438,7038,649,4395]