{"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":3,"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":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,11,8,12],[8,9,8,10],[8,7,8,8],[6,0,7,12],[8,0,8,6],[15,9,15,10],[15,11,15,12],[12,0,13,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[14,0,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[9,7,9,8],[10,7,10,8],[11,7,11,8],[9,9,9,10],[10,9,10,10],[11,9,11,10],[16,9,16,10],[16,11,16,12],[19,0,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[17,0,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[18,0,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[0,3,1,4],[2,3,3,4],[4,3,5,4],[16,0,16,6],[16,7,16,8],[15,0,15,6],[15,7,15,8],[9,0,9,6],[10,0,10,6],[11,0,11,6],[0,0,1,2],[2,0,3,2],[4,0,5,2],[0,5,1,8],[2,5,3,8],[4,5,5,8],[0,9,1,10],[2,9,3,10],[4,9,5,10],[0,11,1,14],[2,11,3,14],[4,11,5,14],[0,15,1,16],[2,15,3,16],[4,15,5,16],[4,17,5,20],[0,23,1,25],[2,23,3,25],[4,23,5,25],[0,17,1,20],[2,17,3,20],[0,26,1,27],[2,26,3,27],[4,26,5,27],[4,21,5,22],[0,21,1,22],[2,21,3,22]]}
["Sent this month:",null,null,2388,null,"Left process at stage 1:",null,null,null,1611,null,"Left process at stage 2:",null,null,null,65,null,"Exited process:",null,null,null,545,null,"Settled:",null,null,305]
[]
["Δ from last month:",null,null,-993,null,"Δ from last month:",null,null,null,-69,null,"Δ from last month:",null,null,null,-11,null,"Δ from last month:",null,null,null,-73,null,"Δ from last month:",null,null,-17]
[]
["Rolling 12 months:",null,null,37469,null,"Rolling 12 months:",null,null,null,19120,null,"Rolling 12 months:",null,null,null,991,null,"Rolling 12 months:",null,null,null,6469,null,"Rolling 12 months:",null,null,3904]
[]
["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,1233,null,1220,null,13]
["Other",null,null,null,null,null,null,378,null,460,null,-82]
["Total",null,null,null,null,null,null,1611,null,1680,null,-69]
["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,0,null,0,null,0]
["Settlement pack repudiated:",null,null,null,null,null,null,0,null,1,null,-1]
["Settlement pack timeout:",null,null,null,null,null,null,29,null,35,null,-6]
["No agreement; Court Proceedings pack:",null,null,null,null,null,null,36,null,40,null,-4]
["Total",null,null,null,null,null,null,65,null,76,null,-11]

{"sheet":"Backing Sheet Data","index":1,"n_rows":105,"n_cols":42,"rows_kept":105,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,4,3,5],[21,4,21,5],[8,8,8,9]]}
["Reporting date","2021-12-01"]
["Previous month","2021-11-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,470592,269522,5170,77180,5214,47983,402211.05474300002]
[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","Rolling 12 CNF Sent","Rolling 12 CNF Left at Stage 1","Rolling 12 Stage 2 Exit","Rolling 12 Exit Process","Rolling 12 Court Pack","Rolling 12 Settled Claims",null,"Period","CNFs Sent","CNFs left at Stage 1","Stage 2 Exit","Exit process","Court Pack","Settled claims","General Damages"]
["Rolling 12 CNFs sent",null,null,null,"Average General Damages chart data",null,null,null,"Left Process Breakdown",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,"2013-08-01",370,6,0,27,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01",1848,208,0,91,0,4,1300,null,"2013-09-01",null,null,null,null,null,null,null,"2013-09-01",1849,208,0,91,0,4,1300]
["Period","Rolling 12 Sent",null,null,"Row Labels","Ave General Damages",null,null,"This Month LDT","This Month Other Liability","This Month Interim Payment Not Agreed","This Month Repudiated","This Month Timeout","This Month Court Proceedings",null,null,null,"2013-10-01",3391,840,1,224,0,8,1281.25,null,"2013-10-01",null,null,null,null,null,null,null,"2013-10-01",3391,840,1,224,0,8,1281.25]
["2021-01-01",22323,null,null,"2021-01-01",4521.6824779999997,null,null,1233,378,0,0,29,36,null,null,null,"2013-11-01",3853,1558,0,271,0,39,1977.948717,null,"2013-11-01",null,null,null,null,null,null,null,"2013-11-01",3851,1558,0,271,0,39,1977.948717]
["2021-02-01",37162,null,null,"2021-02-01",4687.9090029999998,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01",3362,1837,6,293,0,50,2105,null,"2013-12-01",null,null,null,null,null,null,null,"2013-12-01",3361,1837,6,293,0,50,2105]
["2021-03-01",37331,null,null,"2021-03-01",4982.4639699999998,null,null,"CNF Sent Monthly Volumes Chart Data",null,null,null,null,null,null,null,null,"2014-01-01",5243,2352,10,479,2,108,2417.3500920000001,null,"2014-01-01",null,null,null,null,null,null,null,"2014-01-01",5241,2352,10,479,2,108,2417.3500920000001]
["2021-04-01",37182,null,null,"2021-04-01",4674.7768450000003,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01",5114,2165,16,443,4,149,2474.980067,null,"2014-02-01",null,null,null,null,null,null,null,"2014-02-01",5112,2165,16,443,4,149,2474.980067]
["2021-05-01",36990,null,null,"2021-05-01",5076.2545449999998,null,null,"Sum of ClaimCount","Column Labels",null,null,null,null,null,null,null,"2014-03-01",5785,3147,29,581,5,208,2764.1224510000002,null,"2014-03-01",null,null,null,null,null,null,null,"2014-03-01",5783,3147,29,581,5,208,2764.1224510000002]
["2021-06-01",38146,null,null,"2021-06-01",4955.3352519999999,null,null,"Row Labels","RTA","PL","ELD","EL","Grand Total",null,null,null,"2014-04-01",5532,3269,26,675,7,245,2658.4375100000002,null,"2014-04-01",null,null,null,null,null,null,null,"2014-04-01",5531,3269,26,675,7,245,2658.4375100000002]
["2021-07-01",37958,null,null,"2021-07-01",4951.6493609999998,null,null,"2021-01-01",37472,3035,326,2270,43103,null,null,null,"2014-05-01",5844,3467,34,730,4,269,2944.2115610000001,null,"2014-05-01",null,null,null,null,null,null,null,"2014-05-01",5843,3467,34,730,4,269,2944.2115610000001]
["2021-08-01",38002,null,null,"2021-08-01",5164.0514329999996,null,null,"2021-02-01",33141,2915,296,2466,38818,null,null,null,"2014-06-01",6217,3535,41,749,22,344,3020.030377,null,"2014-06-01",null,null,null,null,null,null,null,"2014-06-01",6217,3535,41,749,22,344,3020.030377]
["2021-09-01",37618,null,null,"2021-09-01",4987.7054790000002,null,null,"2021-03-01",39318,3342,365,2832,45857,null,null,null,"2014-07-01",7252,3973,53,881,19,446,3146.8208960000002,null,"2014-07-01",53811,26357,216,5444,63,1870,null,"2014-07-01",7252,3973,53,881,19,446,3146.8208960000002]
["2021-10-01",35044,null,null,"2021-10-01",4870.601936,null,null,"2021-04-01",36749,2755,318,2371,42193,null,null,null,"2014-08-01",6165,3643,37,754,13,384,3308.3370570000002,null,"2014-08-01",59606,29994,253,6171,76,2254,null,"2014-08-01",6165,3643,37,754,13,384,3308.3370570000002]
["2021-11-01",37581,null,null,"2021-11-01",4918.6393779999999,null,null,"2021-05-01",37806,2798,259,2284,43147,null,null,null,"2014-09-01",7274,4136,62,1008,22,485,3106.994659,null,"2014-09-01",65032,33922,315,7088,98,2735,null,"2014-09-01",7274,4136,62,1008,22,485,3106.994659]
["2021-12-01",37469,null,null,"2021-12-01",5012.3989499999998,null,null,"2021-06-01",26129,3251,280,2440,32100,null,null,null,"2014-10-01",7689,4310,60,1134,34,616,3176.7030840000002,null,"2014-10-01",69330,37392,374,7998,132,3343,null,"2014-10-01",7688,4310,60,1134,34,616,3176.7030840000002]
[null,null,null,null,"Grand Total",58803.468630000003,null,null,"2021-07-01",14785,3273,420,2511,20989,null,null,null,"2014-11-01",6262,4079,62,971,28,563,3329.6076549999998,null,"2014-11-01",71739,39913,436,8698,160,3867,null,"2014-11-01",6262,4079,62,971,28,563,3329.6076549999998]
[null,null,null,null,null,null,null,null,"2021-08-01",11522,3286,318,2481,17607,null,null,null,"2014-12-01",5256,4091,62,979,37,579,3291.0112079999999,null,"2014-12-01",73633,42167,492,9384,197,4396,null,"2014-12-01",5256,4091,62,979,37,579,3291.0112079999999]
[null,null,null,null,null,null,null,null,"2021-09-01",11324,3626,343,2735,18028,null,null,null,"2015-01-01",6222,3618,55,977,28,633,3313.3723060000002,null,"2015-01-01",74612,43433,537,9882,223,4921,null,"2015-01-01",6220,3618,55,977,28,633,3313.3723060000002]
[null,86060,null,null,"CNF Sent Monthly Volumes",null,null,null,"2021-10-01",10094,3488,351,2568,16501,null,null,null,"2015-02-01",6331,3152,67,833,43,633,3339.5623529999998,null,"2015-02-01",75829,44420,588,10272,262,5405,null,"2015-02-01",6330,3152,67,833,43,633,3339.5623529999998]
["Exit Process Reason","Total",null,null,null,null,null,null,"2021-11-01",9850,3312,409,2560,16131,null,null,null,"2015-03-01",6750,4068,65,1072,38,730,3404.7033419999998,null,"2015-03-01",76794,45341,624,10763,295,5927,null,"2015-03-01",6750,4068,65,1072,38,730,3404.7033419999998]
["Other",37540,null,null,"DatePeriod","ClaimType","ClaimCount",null,"2021-12-01",7548,2388,252,1952,12140,null,null,null,"2015-04-01",5915,3802,79,953,40,661,3577.5724650000002,null,"2015-04-01",77177,45874,677,11041,328,6343,null,"2015-04-01",5915,3802,79,953,40,661,3577.5724650000002]
["Claim requires further investigation",28643,null,null,"2020-10-01","RTA",34719,null,"Grand Total",275738,37469,3937,29470,346614,null,null,null,"2015-05-01",5415,3397,70,949,29,632,3448.4915339999998,null,"2015-05-01",76748,45804,713,11260,353,6706,null,"2015-05-01",5415,3397,70,949,29,632,3448.4915339999998]
["Duplicated claim",7222,null,null,"2020-11-01","RTA",41926,null,null,null,null,null,null,null,null,null,null,"2015-06-01",6379,3939,59,1006,40,729,3627.6689430000001,null,"2015-06-01",76910,46208,731,11517,371,7091,null,"2015-06-01",6378,3939,59,1006,40,729,3627.6689430000001]
["Incomplete information provided on CNF",5785,null,null,"2020-12-01","RTA",35650,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",76474,46146,753,11699,396,7393,null,"2015-07-01",6816,3911,75,1063,44,748,3798.3083550000001]
["Withdrawal of claim",2785,null,null,"2021-01-01","RTA",37472,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",76271,46093,776,11884,421,7635,null,"2015-08-01",5962,3590,60,939,38,626,3750.637843]
["Value of claim exceeds the upper limit",2462,null,null,"2021-02-01","RTA",33141,null,null,null,null,null,null,null,null,null,null,"2015-09-01",6184,3947,79,1028,52,675,3700.0653619999998,null,"2015-09-01",75181,45904,793,11904,451,7825,null,"2015-09-01",6183,3947,79,1028,52,675,3700.0653619999998]
["Claim is too complex for process",844,null,null,"2021-03-01","RTA",39318,null,null,null,null,null,null,null,null,null,null,"2015-10-01",6164,3769,68,1020,42,722,3454.2663149999998,null,"2015-10-01",73656,45363,801,11790,459,7931,null,"2015-10-01",6164,3769,68,1020,42,722,3454.2663149999998]
["Value of claim below ú1,000",443,null,null,"2021-04-01","RTA",36749,null,null,null,null,null,null,null,null,null,null,"2015-11-01",5844,3603,85,1008,50,709,3808.7843579999999,null,"2015-11-01",73238,44887,824,11827,481,8077,null,"2015-11-01",5843,3603,85,1008,50,709,3808.7843579999999]
["Withdrawal of offer",275,null,null,"2021-05-01","RTA",37806,null,null,null,null,null,null,null,null,null,null,"2015-12-01",4585,3447,87,881,45,640,3785.0480309999998,null,"2015-12-01",72567,44243,849,11729,489,8138,null,"2015-12-01",4584,3447,87,881,45,640,3785.0480309999998]
["Interim payment for child claimant",61,null,null,"2021-06-01","RTA",26129,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",71569,43896,854,11685,500,8125,null,"2016-01-01",5224,3271,60,933,39,620,3964.2704669999998]
[null,null,null,null,"2021-07-01","RTA",14785,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",70979,43530,848,11711,508,8154,null,"2016-02-01",5741,2786,61,859,51,662,3763.3202409999999]
[null,null,null,null,"2021-08-01","RTA",11522,null,null,null,null,null,null,null,null,null,null,"2016-03-01",5742,3433,76,1026,50,676,3927.2018629999998,null,"2016-03-01",69971,42895,859,11665,520,8100,null,"2016-03-01",5739,3433,76,1026,50,676,3927.2018629999998]
[null,null,null,null,"2021-09-01","RTA",11324,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",69523,42488,860,11693,525,8101,null,"2016-04-01",5467,3395,80,981,45,662,3829.3263740000002]
[null,null,null,null,"2021-10-01","RTA",10094,null,null,null,null,null,null,null,null,null,null,"2016-05-01",5009,3163,71,982,45,568,3940.3162499999999,null,"2016-05-01",69117,42254,861,11726,541,8037,null,"2016-05-01",5008,3163,71,982,45,568,3940.3162499999999]
[null,null,null,null,"2021-11-01","RTA",9850,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",67174,41720,889,11693,569,7935,null,"2016-06-01",4436,3405,87,973,68,627,3940.8149440000002]
[null,null,null,null,"2021-12-01","RTA",7548,null,null,null,null,null,null,null,null,null,null,"2016-07-01",4826,2698,91,884,54,526,4052.135988,null,"2016-07-01",65184,40507,905,11514,579,7713,null,"2016-07-01",4825,2698,91,884,54,526,4052.135988]
[null,null,null,null,"2022-01-01","RTA",354,null,null,null,null,null,null,null,null,null,null,"2019-01-01",4648,3001,60,818,82,538,4257.2791070000003,null,"2016-08-01",63870,39918,905,11393,623,7625,null,"2016-08-01",5351,2216,38,606,35,561,3945.6738140000002]
[null,null,null,null,"2020-10-01","EL",2102,null,null,null,null,null,null,null,null,null,null,"2018-12-01",3432,2557,43,742,48,471,3918.6642459999998,null,"2016-09-01",61118,38528,869,11107,619,7421,null,"2016-09-01",5700,3277,84,954,77,604,3909.7556949999998]
[null,null,null,null,"2020-11-01","EL",2423,null,null,null,null,null,null,null,null,null,null,"2018-11-01",5180,3053,54,979,59,627,4329.4685639999998,null,"2016-10-01",60134,37812,855,11066,636,7326,null,"2016-10-01",5182,3203,87,991,53,611,3817.7136329999998]
[null,null,null,null,"2020-12-01","EL",2024,null,null,null,null,null,null,null,null,null,null,"2018-10-01",5368,3010,48,985,70,560,4335.4767499999998,null,"2016-11-01",59658,37219,818,11043,656,7177,null,"2016-11-01",5207,3320,86,939,61,602,4037.5911120000001]
[null,null,null,null,"2021-01-01","EL",2270,null,null,null,null,null,null,null,null,null,null,"2018-09-01",4734,2565,50,848,60,443,4282.2780130000001,null,"2016-12-01",59807,36337,781,11010,671,6980,null,"2016-12-01",3892,2775,76,784,56,537,4184.4410980000002]
[null,null,null,null,"2021-02-01","EL",2466,null,null,null,null,null,null,null,null,null,null,"2018-08-01",4892,2911,57,905,76,505,4379.1376630000004,null,"2017-01-01",59475,35977,778,10982,708,6865,null,"2017-01-01",5119,2833,74,878,85,574,3854.9294249999998]
[null,null,null,null,"2021-03-01","EL",2832,null,null,null,null,null,null,null,null,null,null,"2016-08-01",5351,2216,38,606,35,561,3945.6738140000002,null,"2017-02-01",59085,35407,755,10729,692,6764,null,"2017-02-01",4907,2374,56,750,64,599,3942.1031210000001]
[null,null,null,null,"2021-04-01","EL",2371,null,null,null,null,null,null,null,null,null,null,"2016-09-01",5700,3277,84,954,77,604,3909.7556949999998,null,"2017-03-01",59043,35251,763,10657,719,6692,null,"2017-03-01",5804,3297,80,944,78,650,4167.2315230000004]
[null,null,null,null,"2021-05-01","EL",2284,null,null,null,null,null,null,null,null,null,null,"2016-10-01",5182,3203,87,991,53,611,3817.7136329999998,null,"2017-04-01",58758,35059,770,10667,727,6641,null,"2017-04-01",4124,2622,66,742,44,568,4270.8655099999996]
[null,null,null,null,"2021-06-01","EL",2440,null,null,null,null,null,null,null,null,null,null,"2016-11-01",5208,3320,86,939,61,602,4037.5911120000001,null,"2017-05-01",58957,35216,785,10624,743,6675,null,"2017-05-01",5058,3139,63,873,77,637,4016.5316320000002]
[null,null,null,null,"2021-07-01","EL",2511,null,null,null,null,null,null,null,null,null,null,"2016-12-01",3892,2775,76,784,56,537,4184.4410980000002,null,"2017-06-01",58413,34586,774,10435,731,6585,null,"2017-06-01",4984,2962,67,891,72,599,4289.4138059999996]
[null,null,null,null,"2021-08-01","EL",2481,null,null,null,null,null,null,null,null,null,null,"2017-01-01",5119,2833,74,878,85,574,3854.9294249999998,null,"2017-07-01",58706,34721,757,10429,762,6633,null,"2017-07-01",4865,2907,64,909,87,570,4294.2862800000003]
[null,null,null,null,"2021-09-01","EL",2735,null,null,null,null,null,null,null,null,null,null,"2017-02-01",4907,2374,56,750,64,599,3942.1031210000001,null,"2017-08-01",58965,34094,753,10361,744,6694,null,"2017-08-01",5186,2924,62,901,72,560,4116.7503029999998]
[null,null,null,null,"2021-10-01","EL",2568,null,null,null,null,null,null,null,null,null,null,"2017-03-01",5804,3297,80,944,78,650,4167.2315230000004,null,"2017-09-01",61337,34834,790,10563,774,6873,null,"2017-09-01",4906,2888,57,823,65,537,4020.2592359999999]
[null,null,null,null,"2021-11-01","EL",2560,null,null,null,null,null,null,null,null,null,null,"2017-04-01",4124,2622,66,742,44,568,4270.8655099999996,null,"2017-10-01",60281,34403,802,10326,759,6814,null,"2017-10-01",5256,3055,64,894,84,560,4083.8753390000002]
[null,null,null,null,"2021-12-01","EL",1952,null,null,null,null,null,null,null,null,null,null,"2017-05-01",5056,3139,63,873,77,637,4016.5316320000002,null,"2017-11-01",59969,34532,817,10214,766,6891,null,"2017-11-01",5165,3115,52,922,89,575,4293.3424859999996]
[null,null,null,null,"2022-01-01","EL",50,null,null,null,null,null,null,null,null,null,null,"2017-06-01",4984,2962,67,891,72,599,4289.4138059999996,null,"2017-12-01",60219,34929,834,10257,778,7047,null,"2017-12-01",3611,2616,58,766,73,447,4242.8048989999998]
[null,null,null,null,"2020-10-01","ELD",235,null,null,null,null,null,null,null,null,null,null,"2017-07-01",4865,2907,64,909,87,570,4294.2862800000003,null,"2018-01-01",60192,34925,841,10261,789,7112,null,"2018-01-01",5161,2877,47,890,75,521,4110.3657579999999]
[null,null,null,null,"2020-11-01","ELD",310,null,null,null,null,null,null,null,null,null,null,"2017-08-01",5185,2924,62,901,72,560,4116.7503029999998,null,"2018-02-01",60026,35633,865,10556,826,7111,null,"2018-02-01",4956,2271,52,744,61,554,4213.6596200000004]
[null,null,null,null,"2020-12-01","ELD",259,null,null,null,null,null,null,null,null,null,null,"2017-09-01",4905,2888,57,823,65,537,4020.2592359999999,null,"2018-03-01",59231,35244,838,10425,814,7044,null,"2018-03-01",4822,2970,73,893,81,576,4151.8092880000004]
[null,null,null,null,"2021-01-01","ELD",326,null,null,null,null,null,null,null,null,null,null,"2017-10-01",5256,3055,64,894,84,560,4083.8753390000002,null,"2018-04-01",59305,35096,815,10328,845,6993,null,"2018-04-01",4664,2772,69,825,55,538,4344.9202230000001]
[null,null,null,null,"2021-02-01","ELD",296,null,null,null,null,null,null,null,null,null,null,"2017-11-01",5164,3115,52,922,89,575,4293.3424859999996,null,"2018-05-01",59261,34891,781,10311,873,6966,null,"2018-05-01",4739,2887,62,889,73,567,4182.4503169999998]
[null,null,null,null,"2021-03-01","ELD",365,null,null,null,null,null,null,null,null,null,null,"2017-12-01",3611,2616,58,766,73,447,4242.8048989999998,null,"2018-06-01",58980,34732,763,10293,890,6876,null,"2018-06-01",4741,2818,56,819,78,544,3965.8975359999999]
[null,null,null,null,"2021-04-01","ELD",318,null,null,null,null,null,null,null,null,null,null,"2018-01-01",5161,2877,47,890,75,521,4110.3657579999999,null,"2018-07-01",59022,34776,736,10305,880,6823,null,"2018-07-01",4848,2817,51,939,69,502,4339.6875689999997]
[null,null,null,null,"2021-05-01","ELD",259,null,null,null,null,null,null,null,null,null,null,"2018-02-01",4953,2271,52,744,61,554,4213.6596200000004,null,"2018-08-01",59068,34673,732,10299,877,6778,null,"2018-08-01",4892,2911,57,905,76,505,4379.1376630000004]
[null,null,null,null,"2021-06-01","ELD",280,null,null,null,null,null,null,null,null,null,null,"2018-03-01",4822,2970,73,893,81,576,4151.8092880000004,null,"2018-09-01",58086,34346,725,10248,880,6704,null,"2018-09-01",4735,2565,50,848,60,443,4282.2780130000001]
[null,null,null,null,"2021-07-01","ELD",420,null,null,null,null,null,null,null,null,null,null,"2018-04-01",4664,2772,69,825,55,538,4344.9202230000001,null,"2018-10-01",58626,34496,728,10331,891,6674,null,"2018-10-01",5369,3010,48,985,70,560,4335.4767499999998]
[null,null,null,null,"2021-08-01","ELD",318,null,null,null,null,null,null,null,null,null,null,"2018-05-01",4738,2887,62,889,73,567,4182.4503169999998,null,"2018-11-01",58308,34244,727,10347,887,6604,null,"2018-11-01",5180,3053,54,979,59,627,4329.4685639999998]
[null,null,null,null,"2021-09-01","ELD",343,null,null,null,null,null,null,null,null,null,null,"2018-06-01",4741,2818,56,819,78,544,3965.8975359999999,null,"2018-12-01",58065,34100,716,10275,893,6549,null,"2018-12-01",3432,2557,43,742,48,471,3918.6642459999998]
[null,null,null,null,"2021-10-01","ELD",351,null,null,null,null,null,null,null,null,null,null,"2018-07-01",4846,2817,51,939,69,502,4339.6875689999997,null,"2019-01-01",58046,34010,703,10305,875,6481,null,"2019-01-01",4652,3001,60,818,82,538,4257.2791070000003]
[null,null,null,null,"2021-11-01","ELD",409,null,null,null,null,null,null,null,null,null,null,"2019-02-01",4581,2096,55,615,66,546,3956.2582050000001,null,"2019-02-01",57442,33182,696,10019,869,6467,null,"2019-02-01",4582,2096,55,615,66,546,3956.2582050000001]
[null,null,null,null,"2021-12-01","ELD",252,null,null,null,null,null,null,null,null,null,null,"2019-03-01",4828,2831,45,773,82,643,4356.284447,null,"2019-03-01",57365,33125,684,9969,886,6573,null,"2019-03-01",4831,2831,45,773,82,643,4356.284447]
[null,null,null,null,"2022-01-01","ELD",28,null,null,null,null,null,null,null,null,null,null,"2019-04-01",4400,2782,50,729,69,514,4257.751381,null,"2019-04-01",56509,32852,670,9804,871,6527,null,"2019-04-01",4401,2782,50,729,69,514,4257.751381]
[null,null,null,null,"2020-10-01","PL",2969,null,null,null,null,null,null,null,null,null,null,"2019-05-01",4370,2882,45,850,72,545,4283.9964950000003,null,"2019-05-01",55715,32619,663,9732,854,6497,null,"2019-05-01",4374,2882,45,850,72,545,4283.9964950000003]
[null,null,null,null,"2020-11-01","PL",3407,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",56292,32617,666,9695,860,6526,null,"2019-06-01",4188,2614,61,729,79,476,4252.704495]
[null,null,null,null,"2020-12-01","PL",2500,null,null,null,null,null,null,null,null,null,null,"2019-07-01",5077,2851,52,889,78,568,4546.0196649999998,null,"2019-07-01",56208,32591,671,9694,863,6573,null,"2019-07-01",5078,2851,52,889,78,569,4552.9510890000001]
[null,null,null,null,"2021-01-01","PL",3035,null,null,null,null,null,null,null,null,null,null,"2019-08-01",4781,2607,44,780,82,472,4406.4034320000001,null,"2019-08-01",56036,32927,663,9730,884,6491,null,"2019-08-01",4784,2607,44,780,82,472,4406.4034320000001]
[null,null,null,null,"2021-02-01","PL",2915,null,null,null,null,null,null,null,null,null,null,"2019-09-01",4508,2851,45,791,59,480,4234.2869369999999,null,"2019-09-01",55722,32808,635,9628,862,6395,null,"2019-09-01",4514,2850,45,791,59,480,4234.2869369999999]
[null,null,null,null,"2021-03-01","PL",3342,null,null,null,null,null,null,null,null,null,null,"2019-10-01",4855,2577,67,851,89,550,4512.5319449999997,null,"2019-10-01",55913,32613,633,9654,896,6407,null,"2019-10-01",4860,2554,67,851,89,550,4512.5319449999997]
[null,null,null,null,"2021-04-01","PL",2755,null,null,null,null,null,null,null,null,null,null,"2019-11-01",4511,2226,40,806,77,510,4161.8467639999999,null,"2019-11-01",55686,31952,611,9571,900,6350,null,"2019-11-01",4516,2210,40,806,77,511,4165.4439329999996]
[null,null,null,null,"2021-05-01","PL",2798,null,null,null,null,null,null,null,null,null,null,"2019-12-01",3408,2136,43,724,58,430,4213.0240460000005,null,"2019-12-01",54353,31270,598,9476,880,6236,null,"2019-12-01",3415,2110,43,724,58,430,4213.0240460000005]
[null,null,null,null,"2021-06-01","PL",3251,null,null,null,null,null,null,null,null,null,null,"2020-01-01",4658,2310,40,805,62,515,4338.7701550000002,null,"2020-01-01",54165,30763,587,9342,873,6249,null,"2020-01-01",4668,2270,40,806,62,515,4338.7701550000002]
[null,null,null,null,"2021-07-01","PL",3273,null,null,null,null,null,null,null,null,null,null,"2020-02-01",4526,1742,41,689,84,491,4327.5731969999997,null,"2020-02-01",54110,30409,573,9416,891,6194,null,"2020-02-01",4534,1714,41,689,84,491,4327.5731969999997]
[null,null,null,null,"2021-08-01","PL",3286,null,null,null,null,null,null,null,null,null,null,"2020-03-01",4295,2467,70,878,74,496,4441.0580440000003,null,"2020-03-01",53577,30045,598,9521,883,6047,null,"2020-03-01",4310,2417,70,878,74,497,4435.1404220000004]
[null,null,null,null,"2021-09-01","PL",3626,null,null,null,null,null,null,null,null,null,null,"2020-04-01",2842,2400,49,754,67,463,4444.0043409999998,null,"2020-04-01",52019,29663,597,9546,881,5996,null,"2020-04-01",2857,2362,49,754,67,463,4444.0043409999998]
[null,null,null,null,"2021-10-01","PL",3488,null,null,null,null,null,null,null,null,null,null,"2020-05-01",2345,1847,32,605,72,389,4432.1912080000002,null,"2020-05-01",49994,28628,584,9301,881,5840,null,"2020-05-01",2284,1801,32,608,72,392,4446.4218870000004]
[null,null,null,null,"2021-11-01","PL",3312,null,null,null,null,null,null,null,null,null,null,"2020-06-01",2802,1612,42,512,56,358,4474.9866480000001,null,"2020-06-01",48608,27626,565,9084,858,5722,null,"2020-06-01",2713,1512,42,513,56,361,4457.8814949999996]
[null,null,null,null,"2021-12-01","PL",2388,null,null,null,null,null,null,null,null,null,null,"2020-07-01",3339,1471,37,509,48,314,4758.0958280000004,null,"2020-07-01",46870,26246,550,8704,828,5468,null,"2020-07-01",3147,1378,37,488,47,310,4767.5551290000003]
[null,null,null,null,"2022-01-01","PL",71,null,null,null,null,null,null,null,null,null,null,"2020-08-01",3044,1394,31,461,41,252,4841.6140070000001,null,"2020-08-01",45133,25033,537,8385,787,5248,null,"2020-08-01",2544,1217,30,422,35,228,4843.45057]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-09-01",3916,1739,35,573,53,341,4412.5222869999998,null,"2020-09-01",44541,23921,527,8167,781,5109,null,"2020-09-01",3548,1629,35,545,51,325,4378.5079999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-10-01",3910,1838,41,622,49,326,4637.3628220000001,null,"2020-10-01",43596,23182,501,7938,741,4885,null,"2020-10-01",3817,1749,41,623,49,328,4633.476463]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-01",3407,2029,48,655,44,364,4721.5918949999996,null,"2020-11-01",42492,22985,509,7787,708,4739,null,"2020-11-01",3172,1907,48,624,43,343,4743.3511660000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-01",2500,1926,29,586,58,305,4360.7605240000003,null,"2020-12-01",41584,22775,495,7649,708,4614,null,"2020-12-01",2510,1794,29,576,55,306,4367.7515030000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01",3035,1608,21,524,43,355,4521.6824779999997,null,"2021-01-01",39961,22073,476,7368,689,4454,null,"2021-01-01",2953,1521,21,529,43,356,4548.3069660000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-01",2915,1297,28,422,43,331,4687.9090029999998,null,"2021-02-01",38350,21628,463,7101,648,4294,null,"2021-02-01",1671,1046,23,324,34,303,4595.1910230000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-01",3342,1742,44,588,50,408,4982.4639699999998,null,"2021-03-01",37397,20903,437,6811,624,4206,null,"2021-03-01",3276,1716,44,588,50,408,4982.4639699999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01",2755,1532,32,528,59,336,4674.7768450000003,null,"2021-04-01",37310,20035,420,6585,616,4079,null,"2021-04-01",2692,1432,32,528,59,338,4664.8669229999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01",2798,1314,31,474,60,297,5076.2545449999998,null,"2021-05-01",37763,19502,419,6454,604,3987,null,"2021-05-01",2707,1219,31,474,60,297,5076.2545449999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-01",3251,1596,43,547,61,337,4955.3352519999999,null,"2021-06-01",38212,19486,420,6489,609,3966,null,"2021-06-01",3066,1555,43,547,61,338,4990.9703550000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01",3273,1615,32,552,56,313,4951.6493609999998,null,"2021-07-01",38146,19630,415,6532,617,3965,null,"2021-07-01",3155,1538,32,552,56,313,4951.6493609999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-01",3286,1740,29,527,45,293,5164.0514329999996,null,"2021-08-01",38388,19976,413,6598,621,4006,null,"2021-08-01",3244,1660,29,527,45,294,5183.9015980000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01",3626,1679,35,544,43,292,4987.7054790000002,null,"2021-09-01",38098,19916,413,6569,611,3957,null,"2021-09-01",3530,1600,35,544,43,293,4979.2150170000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-01",3488,1644,34,600,61,315,4870.601936,null,"2021-10-01",37676,19722,406,6547,623,3946,null,"2021-10-01",3347,1583,34,600,61,315,4870.601936]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01",3312,1742,36,618,40,322,4918.6393779999999,null,"2021-11-01",37581,19435,394,6510,619,3904,null,"2021-11-01",3381,1680,36,618,40,322,4918.6393779999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-01",2388,1611,29,545,36,305,5012.3989499999998,null,"2021-12-01",37469,19120,394,6469,597,3904]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01",71,132,4,25,1,18,5008.6111110000002]

{"sheet":"Year Calculations","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Period","CNFs sent","CNFs left at stage 1","Stage 2 exit","Exit process","Court pack","Settled claims"]
["2013-14",{"$f":"SUM('Backing Sheet Data'!S4:S15)","v":53811},{"$f":"SUM('Backing Sheet Data'!T4:T15)","v":26357},{"$f":"SUM('Backing Sheet Data'!U4:U15)","v":216},{"$f":"SUM('Backing Sheet Data'!V4:V15)","v":5444},{"$f":"SUM('Backing Sheet Data'!W4:W15)","v":63},{"$f":"SUM('Backing Sheet Data'!X4:X15)","v":1870}]
["2014-15",{"$f":"SUM('Backing Sheet Data'!S16:S27)","v":76474},{"$f":"SUM('Backing Sheet Data'!T16:T27)","v":46146},{"$f":"SUM('Backing Sheet Data'!U16:U27)","v":753},{"$f":"SUM('Backing Sheet Data'!V16:V27)","v":11699},{"$f":"SUM('Backing Sheet Data'!W16:W27)","v":396},{"$f":"SUM('Backing Sheet Data'!X16:X27)","v":7393}]
["2015-16",{"$f":"SUM('Backing Sheet Data'!S28:S39)","v":65184},{"$f":"SUM('Backing Sheet Data'!T28:T39)","v":40507},{"$f":"SUM('Backing Sheet Data'!U28:U39)","v":905},{"$f":"SUM('Backing Sheet Data'!V28:V39)","v":11514},{"$f":"SUM('Backing Sheet Data'!W28:W39)","v":579},{"$f":"SUM('Backing Sheet Data'!X28:X39)","v":7713}]
["2016-17",{"$f":"SUM('Backing Sheet Data'!S40:S51)","v":58706},{"$f":"SUM('Backing Sheet Data'!T40:T51)","v":34721},{"$f":"SUM('Backing Sheet Data'!U40:U51)","v":757},{"$f":"SUM('Backing Sheet Data'!V40:V51)","v":10429},{"$f":"SUM('Backing Sheet Data'!W40:W51)","v":762},{"$f":"SUM('Backing Sheet Data'!X40:X51)","v":6633}]
["2017-18",{"$f":"SUM('Backing Sheet Data'!S52:S63)","v":59022},{"$f":"SUM('Backing Sheet Data'!T52:T63)","v":34776},{"$f":"SUM('Backing Sheet Data'!U52:U63)","v":736},{"$f":"SUM('Backing Sheet Data'!V52:V63)","v":10305},{"$f":"SUM('Backing Sheet Data'!W52:W63)","v":880},{"$f":"SUM('Backing Sheet Data'!X52:X63)","v":6823}]
["2018-19",{"$f":"SUM('Backing Sheet Data'!S64:S75)","v":56208},{"$f":"SUM('Backing Sheet Data'!T64:T75)","v":32591},{"$f":"SUM('Backing Sheet Data'!U64:U75)","v":671},{"$f":"SUM('Backing Sheet Data'!V64:V75)","v":9694},{"$f":"SUM('Backing Sheet Data'!W64:W75)","v":863},{"$f":"SUM('Backing Sheet Data'!X64:X75)","v":6573}]
["2019-20",{"$f":"SUM('Backing Sheet Data'!S76:S87)","v":46870},{"$f":"SUM('Backing Sheet Data'!T76:T87)","v":26246},{"$f":"SUM('Backing Sheet Data'!U76:U87)","v":550},{"$f":"SUM('Backing Sheet Data'!V76:V87)","v":8704},{"$f":"SUM('Backing Sheet Data'!W76:W87)","v":828},{"$f":"SUM('Backing Sheet Data'!X76:X87)","v":5468}]
["2020-21",{"$f":"SUM('Backing Sheet Data'!S88:S112)","v":54317},{"$f":"SUM('Backing Sheet Data'!T88:T112)","v":28178},{"$f":"SUM('Backing Sheet Data'!U88:U112)","v":582},{"$f":"SUM('Backing Sheet Data'!V88:V112)","v":9391},{"$f":"SUM('Backing Sheet Data'!W88:W112)","v":843},{"$f":"SUM('Backing Sheet Data'!X88:X112)","v":5510}]