{"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":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,363841,null,"Left process at stage 1:",null,null,211719,null,"Left process at stage 2:",null,null,7451,null,"Exited process:",null,null,58169,null,"Settled:",null,36445,null,"Remaining:",null,50057]
[]
["Δ from last month:",null,4052,null,"Δ from last month:",null,null,2092,null,"Δ from last month:",null,null,140,null,"Δ from last month:",null,null,729,null,"Δ from last month:",null,477,null,"Δ from last month:",null,614]
[]
["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,89201,null,87834,null,1367]
["Other",null,null,null,null,null,null,122654,null,121929,null,725]
["Total",null,null,null,null,null,null,211855,null,209763,null,2092]
["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,53,null,53,null,0]
["Settlement pack repudiated:",null,null,null,null,null,null,147,null,146,null,1]
["Settlement pack timeout:",null,null,null,null,null,null,3789,null,3729,null,60]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,3465,null,3386,null,79]
["Total",null,null,null,null,null,null,7454,null,7314,null,140]

{"sheet":"Backing Sheet Data","index":1,"n_rows":73,"n_cols":28,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["Reporting date","2019-07-01"]
["Latest month","2019-06-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,363841,211719,3986,58169,3465,36445,258126.77877900007]
[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-09-01",1849,208,0,91,0,4,1300,null,"2013-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-01",3391,840,1,224,0,8,1281.25,null,"2013-10-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-11-01",3851,1558,0,271,0,39,1977.948717,null,"2013-11-01"]
["2018-07-01",58064,null,"2018-07-01",69,null,"2018-07-01",4341.497335,null,null,null,null,null,null,null,null,null,"2013-12-01",3361,1837,6,293,0,50,2105,null,"2013-12-01"]
["2018-08-01",57770,null,"2018-08-01",76,null,"2018-08-01",4379.1376630000004,null,null,null,null,null,null,null,null,null,"2014-01-01",5241,2352,10,479,2,108,2417.3500920000001,null,"2014-01-01"]
["2018-09-01",57601,null,"2018-09-01",60,null,"2018-09-01",4282.2780130000001,null,null,null,null,null,null,null,null,null,"2014-02-01",5112,2165,16,443,4,149,2474.980067,null,"2014-02-01"]
["2018-10-01",57714,null,"2018-10-01",70,null,"2018-10-01",4335.4767499999998,null,null,null,null,null,null,null,null,null,"2014-03-01",5783,3147,29,581,5,208,2764.1224510000002,null,"2014-03-01"]
["2018-11-01",57732,null,"2018-11-01",59,null,"2018-11-01",4326.5553980000004,null,null,null,null,null,null,null,null,null,"2014-04-01",5531,3269,26,675,7,245,2658.4375100000002,null,"2014-04-01"]
["2018-12-01",57558,null,"2018-12-01",48,null,"2018-12-01",3920.2566019999999,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-01-01",57053,null,"2019-01-01",82,null,"2019-01-01",4257.2791070000003,null,null,null,null,null,null,null,null,null,"2014-06-01",6217,3535,41,749,22,344,3020.030377,null,"2014-06-01"]
["2019-02-01",56688,null,"2019-02-01",66,null,"2019-02-01",3967.3070929999999,null,null,null,null,null,null,null,null,null,"2014-07-01",7252,3973,53,881,19,446,3146.8208960000002,null,"2014-07-01"]
["2019-03-01",56705,null,"2019-03-01",82,null,"2019-03-01",4356.284447,null,null,null,null,null,null,null,null,null,"2014-08-01",6163,3643,37,754,13,384,3308.3370570000002,null,"2014-08-01",59594]
["2019-04-01",56424,null,"2019-04-01",69,null,"2019-04-01",4257.751381,null,null,null,null,null,null,null,null,null,"2014-09-01",7273,4136,62,1008,22,485,3106.994659,null,"2014-09-01",65018]
["2019-05-01",56073,null,"2019-05-01",72,null,"2019-05-01",4283.9964950000003,null,null,null,null,null,null,null,null,null,"2014-10-01",7688,4310,60,1134,34,616,3176.7030840000002,null,"2014-10-01",69315]
["2019-06-01",55382,null,"2019-06-01",79,null,"2019-06-01",4246.933626,null,null,null,null,null,null,null,null,null,"2014-11-01",6260,4079,62,971,28,563,3329.6076549999998,null,"2014-11-01",71724]
[null,null,null,"Grand Total",832,null,"Grand Total",50954.753909999999,null,null,null,null,null,null,null,null,null,"2014-12-01",5255,4091,62,979,37,579,3291.0112079999999,null,"2014-12-01",73618]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-01-01",6218,3618,55,977,28,633,3313.3723060000002,null,"2015-01-01",74595]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-01",6329,3152,67,833,43,633,3339.5623529999998,null,"2015-02-01",75812]
[null,null,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",76779]
[null,71015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-01",5915,3802,79,953,40,661,3577.5724650000002,null,"2015-04-01",77163]
["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-05-01",5414,3397,70,949,29,632,3448.4915339999998,null,"2015-05-01",76734]
["Claim is too complex for process",615,null,89201,1367,122654,725,53,0,147,1,3789,60,3465,79,null,null,"2015-06-01",6378,3939,59,1006,40,729,3627.6689430000001,null,"2015-06-01",76895]
["Claim requires further investigation",22783,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-01",6815,3911,75,1063,44,748,3798.3083550000001,null,"2015-07-01",76458]
["Duplicated claim",6047,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",76257]
["Incomplete information provided on CNF",4700,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",75167]
["Interim payment for child claimant",43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-10-01",6162,3769,68,1020,42,722,3454.2663149999998,null,"2015-10-01",73641]
["Interim Payment partial offer not accepted",23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-11-01",5841,3603,85,1008,50,709,3808.7843579999999,null,"2015-11-01",73222]
["Interim Payment request not answered and/or paid on time",310,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",72551]
["Other",30103,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01",5222,3271,60,933,39,620,3964.2704669999998,null,"2016-01-01",71555]
["Stage 1 costs not paid on time",1715,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-02-01",5739,2786,61,859,51,662,3763.3202409999999,null,"2016-02-01",70965]
["Value of claim below ú1,000",349,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-03-01",5738,3433,76,1026,50,676,3927.2018629999998,null,"2016-03-01",69953]
["Value of claim exceeds the upper limit",1695,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-04-01",5465,3395,80,981,45,662,3829.3263740000002,null,"2016-04-01",69503]
["Withdrawal of claim",2421,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-01",5006,3163,71,982,45,568,3940.3162499999999,null,"2016-05-01",69095]
["Withdrawal of offer",211,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",67153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-01",4824,2698,91,884,54,526,4052.135988,null,"2016-07-01",65162]
[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",64551]
[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",64068]
[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",63088]
[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",62454]
[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",61762]
[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",61659]
[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",60827]
[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",60893]
[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",59552]
[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",59604]
[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",60152]
[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",5187,2924,62,901,72,562,4111.9753909999999,null,"2017-08-01",60029]
[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",59235]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-01",5257,3055,64,894,84,560,4083.8753390000002,null,"2017-10-01",59310]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-01",5166,3115,52,922,89,575,4293.3424859999996,null,"2017-11-01",59269]
[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",58988]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-01",5162,2877,47,890,75,521,4110.3657579999999,null,"2018-01-01",59031]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-01",4957,2271,52,744,61,554,4213.6596200000004,null,"2018-02-01",59081]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-01",4823,2970,73,893,81,577,4146.7801550000004,null,"2018-03-01",58100]
[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",58640]
[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",58321]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-01",4743,2818,56,819,78,545,3962.3821280000002,null,"2018-06-01",58080]
[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,503,4341.497335,null,"2018-07-01",58063]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-01",4893,2911,57,905,76,505,4379.1376630000004,null,"2018-08-01",57769]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01",4736,2565,50,848,60,443,4282.2780130000001,null,"2018-09-01",57599]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-01",5370,3010,48,985,70,560,4335.4767499999998,null,"2018-10-01",57712]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-01",5183,3053,54,979,59,628,4326.5553980000004,null,"2018-11-01",57729]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-01",3436,2557,43,742,48,471,3920.2566019999999,null,"2018-12-01",57554]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01",4655,3001,60,818,82,538,4257.2791070000003,null,"2019-01-01",57047]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01",4590,2096,55,615,66,547,3967.3070929999999,null,"2019-02-01",56680]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01",4837,2831,45,773,82,643,4356.284447,null,"2019-03-01",56694]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01",4418,2782,50,729,69,514,4257.751381,null,"2019-04-01",56448]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01",4364,2882,45,850,72,545,4283.9964950000003,null,"2019-05-01",56073]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01",4052,2092,61,729,79,477,4246.933626,null,"2019-06-01",55382]

{"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",59594,29994,253,6171,76,2254]
["2014-15",76257,46093,776,11884,421,7635]
["2015-16",64551,39133,883,11181,576,7648]
["2016-17",60029,35633,865,10556,826,7113]
["2017-18",57769,33997,698,10309,879,6429]
["2018-19",45641,26869,511,8068,687,5366]
[]
[]
["Update last period monthly!"]