Spreadsheet: 472127d1469457449-concatenating-two-numbers-excelhelp_1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Year Code: | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  |  |  |  |  |  |  |  | Month Number | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 12 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 12 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 10 | 11
 |  |  |  |  |  |  |  |  | Month normalisation | 17 | 17 | 18 | 18 | 18 | 18 | 19 | 19 | 19 | 19 | 19 | 20 | 20 | 20 | 20 | 21 | 21 | 21 | 21 | 22 | 22 | 22 | 22 | 22 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 13 | 13 | 13 | 13 | 13 | 14 | 14 | 14 | 14 | 15 | 15 | 15 | 15 | 16 | 16 | 16 | 16 | 16 | 17 | 17 | 17 | 17 | 18 | 18 | 18 | 18 | 19 | 19 | 19 | 19 | 19 | 20 | 20 | 20 | 20 | 21 | 21 | 21 | 21 | 22 | 22 | 22 | 22 | 22 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 13 | 13 | 13 | 13 | 13 | 14 | 14 | 14 | 14 | 15 | 15 | 15 | 15 | 16 | 16 | 16 | 16 | 16 | 17 | 17 | 17 | 17 | 18 | 18 | 18 | 18 | 18 | 19 | 19 | 19 | 19 | 20 | 20 | 20 | 20 | 21 | 21 | 21 | 21 | 21 | 22 | 22 | 22 | 22 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 13 | 13 | 13 | 13 | 13 | 14 | 14 | 14 | 14 | 15 | 15 | 15 | 15 | 15 | 16 | 16 | 16 | 16 | 17 | 17 | 17 | 17 | 18 | 18 | 18 | 18 | 18 | 19 | 19 | 19 | 19 | 20 | 20 | 20 | 20 | 21 | 21 | 21 | 21 | 21 | 22 | 22 | 22 | 22 | 11 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 13 | 13 | 13 | 13 | 14 | 14 | 14 | 14 | 15 | 15 | 15 | 15 | 15 | 16 | 16 | 16 | 16 | 17 | 17 | 17 | 17 | 17 | 18 | 18 | 18 | 18 | 19 | 19 | 19 | 19 | 20 | 20 | 20 | 20 | 20 | 21
 |  |  |  |  |  |  |  |  | Week number | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45
 |  | 5 |  |  |  |  |  |  | Coef
 |  | Start year | End year | Month normalisation |  | Start Coef | End Coef | Amount | Depreciation / week
 |  | 1 | 6 | 11 |  |  |  | 0 | 0
 |  | 1 | 6 | 12 |  |  |  | 0 | 0
 |  | 1 | 6 | 13 |  |  |  | 0 | 0
 |  | 1 | 6 | 14 |  |  |  | 0 | 0
 |  | 1 | 6 | 15 |  |  |  | 0 | 0
 |  | 1 | 6 | 16 |  |  |  | 0 | 0
 |  | 1 | 6 | 17 |  |  |  | 8000 | 30.76923076923077
 |  | 1 | 6 | 18 |  |  |  | 0 | 0
 |  | 1 | 6 | 19 |  |  |  | 16320 | 62.76923076923077
 |  | 1 | 6 | 20 |  |  |  | 8000 | 30.76923076923077
 |  | 1 | 6 | 21 |  |  |  | 16320 | 62.76923076923077
 |  | 1 | 6 | 22 |  |  |  | 8000 | 30.76923076923077
 |  | 2 | 7 | 11 |  |  |  | 15340.8 | 59.00307692307693
 |  | 2 | 7 | 12 |  |  |  | 23011.2 | 88.50461538461539
 |  | 2 | 7 | 13 |  |  |  | 23011.2 | 88.50461538461539
 |  | 2 | 7 | 14 |  |  |  | 23011.2 | 88.50461538461539
 |  | 2 | 7 | 15 |  |  |  | 23011.2 | 88.50461538461539
 |  | 2 | 7 | 16 |  |  |  | 30681.6 | 118.0061538461539
 |  | 2 | 7 | 17 |  |  |  | 15340.8 | 59.00307692307693
 |  | 2 | 7 | 18 |  |  |  | 23011.2 | 88.50461538461539
 |  | 2 | 7 | 19 |  |  |  | 30681.6 | 118.0061538461539
 |  | 2 | 7 | 20 |  |  |  | 30681.6 | 118.0061538461539
 |  | 2 | 7 | 21 |  |  |  | 39480 | 151.8461538461538
 |  | 2 | 7 | 22 |  |  |  | 23011.2 | 88.50461538461539
 |  | 3 | 8 | 11 |  |  |  | 28840.704 | 110.9257846153846
 |  | 3 | 8 | 12 |  |  |  | 28840.704 | 110.9257846153846
 |  | 3 | 8 | 13 |  |  |  | 51955.68 | 199.8295384615385
 |  | 3 | 8 | 14 |  |  |  | 37111.2 | 142.7353846153846
 |  | 3 | 8 | 15 |  |  |  | 44533.44 | 171.2824615384615
 |  | 3 | 8 | 16 |  |  |  | 44533.44 | 171.2824615384615
 |  | 3 | 8 | 17 |  |  |  | 28840.704 | 110.9257846153846
 |  | 3 | 8 | 18 |  |  |  | 37111.2 | 142.7353846153846
 |  | 3 | 8 | 19 |  |  |  | 44533.44 | 171.2824615384615
 |  | 3 | 8 | 20 |  |  |  | 44533.44 | 171.2824615384615
 |  | 3 | 8 | 21 |  |  |  | 59377.92 | 228.3766153846154
 |  | 3 | 8 | 22 |  |  |  | 21630.528 | 83.19433846153845
 |  | 4 | 9 | 11 |  |  |  | 48838.33919999999 | 187.8397661538461
 |  | 4 | 9 | 12 |  |  |  | 48838.33919999999 | 187.8397661538461
 |  | 4 | 9 | 13 |  |  |  | 62792.15039999999 | 241.5082707692307
 |  | 4 | 9 | 14 |  |  |  | 48838.33919999999 | 187.8397661538461
 |  | 4 | 9 | 15 |  |  |  | 62792.15039999999 | 241.5082707692307
 |  | 4 | 9 | 16 |  |  |  | 55815.24479999999 | 214.6740184615384
 |  | 4 | 9 | 17 |  |  |  | 34884.528 | 134.1712615384615
 |  | 4 | 9 | 18 |  |  |  | 41861.4336 | 161.0055138461538
 |  | 4 | 9 | 19 |  |  |  | 55815.24479999999 | 214.6740184615384
 |  | 4 | 9 | 20 |  |  |  | 55815.24479999999 | 214.6740184615384
 |  | 4 | 9 | 21 |  |  |  | 80400.53119999998 | 309.2328123076923
 |  | 4 | 9 | 22 |  |  |  | 27110.26175999999 | 104.2702375384615
 |  | 5 | 10 | 11 |  |  |  | 68705.90847999998 | 264.2534941538461
 |  | 5 | 10 | 12 |  |  |  | 59024.62137599999 | 227.0177745230769
 |  | 5 | 10 | 13 |  |  |  | 52466.33011199999 | 201.7935773538461
 |  | 5 | 10 | 14 |  |  |  | 68705.90847999998 | 264.2534941538461
 |  | 5 | 10 | 15 |  |  |  | 82447.09017599998 | 317.1041929846153
 |  | 5 | 10 | 16 |  |  |  | 68705.90847999998 | 264.2534941538461
 |  | 5 | 10 | 17 |  |  |  | 45908.03884799999 | 176.5693801846153
 |  | 5 | 10 | 18 |  |  |  | 32791.45631999999 | 126.1209858461538
 |  | 5 | 10 | 19 |  |  |  | 75576.49932799999 | 290.6788435692307
 |  | 5 | 10 | 20 |  |  |  | 89317.68102399999 | 343.5295424
 |  | 5 | 10 | 21 |  |  |  | 68705.90847999998 | 264.2534941538461
 |  | 5 | 10 | 22 |  |  |  | 32791.45631999999 | 126.1209858461538