Spreadsheet: 150216d1334334140-return-max-of-sum-of-4-weeks-data-in-a-row-max-of-sum
Sheet: Sheet1

 | WEEK 1 |  |  |  |  |  |  | WEEK 2 |  |  |  |  |  |  | WEEK 3 |  |  |  |  |  |  | WEEK 4 |  |  |  |  |  |  | WEEK 5 |  |  |  |  |  |  | WEEK 6 |  |  |  |  |  |  | WEEK 7 |  |  |  |  |  |  | WEEK 8 |  |  |  |  |  |  | WEEK 9 |  |  |  |  |  |  | WEEK 10 |  |  |  |  |  |  | WEEK 11 |  |  |  |  |  |  | WEEK 12 |  |  |  |  |  |  | WEEK 13 |  |  |  |  |  |  | WEEK 14
 | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | 2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 2012-02-03 00:00:00 | 2012-02-04 00:00:00 | 2012-02-05 00:00:00 | 2012-02-06 00:00:00 | 2012-02-07 00:00:00 | 2012-02-08 00:00:00 | 2012-02-09 00:00:00 | 2012-02-10 00:00:00 | 2012-02-11 00:00:00 | 2012-02-12 00:00:00 | 2012-02-13 00:00:00 | 2012-02-14 00:00:00 | 2012-02-15 00:00:00 | 2012-02-16 00:00:00 | 2012-02-17 00:00:00 | 2012-02-18 00:00:00 | 2012-02-19 00:00:00 | 2012-02-20 00:00:00 | 2012-02-21 00:00:00 | 2012-02-22 00:00:00 | 2012-02-23 00:00:00 | 2012-02-24 00:00:00 | 2012-02-25 00:00:00 | 2012-02-26 00:00:00 | 2012-02-27 00:00:00 | 2012-02-28 00:00:00 | 2012-02-29 00:00:00 | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-03 00:00:00 | 2012-03-04 00:00:00 | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-10 00:00:00 | 2012-03-11 00:00:00 | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-17 00:00:00 | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00
PRODUCT 1 | 99 | 9 | 46 | 88 | 85 | 53 | 22 | 60 | 96 | 82 | 29 | 2 | 28 | 35 | 18 | 75 | 57 | 65 | 4 | 98 | 34 | 16 | 64 | 50 | 55 | 20 | 10 | 35 | 3 | 10 | 92 | 3 | 78 | 41 | 34 | 83 | 75 | 7 | 27 | 15 | 66 | 13 | 98 | 15 | 29 | 41 | 47 | 55 | 6 | 11 | 8 | 30 | 21 | 83 | 44 | 74 | 20 | 12 | 15 | 91 | 26 | 55 | 37 | 56 | 83 | 75 | 5 | 97 | 73 | 18 | 8 | 78 | 53 | 52 | 84 | 86 | 58 | 44 | 81 | 93 | 93 | 48 | 26 | 5 | 86 | 29 | 72 | 95 | 34 | 19 | 32 | 56 | 46 | 70 | 52 | 75 | 77 | 14
PRODUCT 2 | 34 | 29 | 49 | 67 | 94 | 89 | 66 | 55 | 34 | 7 | 11 | 30 | 60 | 71 | 5 | 75 | 33 | 79 | 24 | 64 | 43 | 77 | 84 | 76 | 1 | 48 | 22 | 41 | 67 | 14 | 20 | 81 | 86 | 47 | 54 | 61 | 45 | 19 | 41 | 16 | 59 | 27 | 6 | 61 | 6 | 33 | 18 | 31 | 23 | 56 | 77 | 51 | 45 | 91 | 33 | 19 | 60 | 9 | 53 | 49 | 55 | 84 | 85 | 99 | 78 | 19 | 4 | 27 | 54 | 69 | 27 | 22 | 73 | 40 | 24 | 13 | 47 | 37 | 96 | 60 | 41 | 31 | 76 | 17 | 54 | 5 | 51 | 36 | 53 | 36 | 94 | 65 | 24 | 98 | 5 | 88 | 25 | 91
PRODUCT 3 | 26 | 22 | 3 | 18 | 27 | 19 | 35 | 16 | 4 | 9 | 97 | 43 | 98 | 62 | 37 | 20 | 27 | 93 | 75 | 10 | 41 | 23 | 79 | 86 | 23 | 44 | 81 | 33 | 13 | 51 | 7 | 30 | 51 | 100 | 23 | 85 | 39 | 53 | 53 | 59 | 91 | 56 | 58 | 11 | 6 | 56 | 38 | 41 | 2 | 1 | 13 | 23 | 67 | 87 | 49 | 85 | 66 | 8 | 73 | 72 | 21 | 46 | 86 | 74 | 96 | 58 | 50 | 49 | 22 | 46 | 27 | 86 | 7 | 2 | 25 | 4 | 59 | 33 | 97 | 22 | 86 | 57 | 40 | 41 | 14 | 21 | 42 | 10 | 23 | 89 | 49 | 53 | 75 | 54 | 68 | 54 | 1 | 11
PRODUCT 4 | 85 | 81 | 13 | 80 | 78 | 78 | 80 | 89 | 2 | 62 | 14 | 88 | 10 | 100 | 32 | 28 | 74 | 80 | 11 | 70 | 48 | 34 | 65 | 85 | 22 | 23 | 83 | 67 | 68 | 30 | 38 | 14 | 20 | 70 | 83 | 36 | 63 | 13 | 31 | 86 | 46 | 21 | 69 | 76 | 88 | 93 | 53 | 23 | 77 | 41 | 65 | 96 | 84 | 18 | 56 | 87 | 6 | 72 | 93 | 11 | 99 | 19 | 6 | 39 | 70 | 26 | 38 | 43 | 5 | 21 | 100 | 79 | 92 | 40 | 13 | 44 | 3 | 76 | 21 | 9 | 11 | 40 | 82 | 48 | 57 | 96 | 72 | 28 | 64 | 47 | 33 | 81 | 64 | 57 | 20 | 31 | 54 | 20
PRODUCT 5 | 17 | 44 | 66 | 28 | 80 | 11 | 23 | 4 | 99 | 32 | 86 | 78 | 70 | 13 | 67 | 39 | 56 | 72 | 47 | 14 | 48 | 61 | 26 | 26 | 11 | 97 | 82 | 87 | 13 | 94 | 31 | 18 | 96 | 91 | 15 | 66 | 17 | 5 | 43 | 7 | 56 | 96 | 100 | 59 | 17 | 94 | 20 | 19 | 32 | 78 | 44 | 64 | 85 | 16 | 39 | 74 | 79 | 18 | 82 | 24 | 89 | 59 | 1 | 8 | 37 | 11 | 2 | 76 | 67 | 60 | 12 | 63 | 88 | 40 | 92 | 53 | 80 | 63 | 48 | 34 | 72 | 49 | 90 | 34 | 84 | 59 | 100 | 9 | 100 | 38 | 13 | 54 | 72 | 76 | 97 | 61 | 51 | 36
PRODUCT 6 | 42 | 21 | 2 | 3 | 9 | 68 | 74 | 33 | 64 | 38 | 54 | 18 | 62 | 34 | 49 | 41 | 31 | 29 | 61 | 64 | 36 | 90 | 30 | 99 | 31 | 80 | 4 | 28 | 61 | 41 | 89 | 7 | 88 | 68 | 24 | 62 | 86 | 15 | 23 | 33 | 92 | 56 | 67 | 97 | 87 | 52 | 23 | 62 | 49 | 34 | 11 | 84 | 90 | 14 | 14 | 58 | 38 | 88 | 23 | 74 | 34 | 87 | 36 | 13 | 51 | 61 | 74 | 41 | 13 | 41 | 10 | 53 | 61 | 24 | 60 | 68 | 54 | 14 | 23 | 95 | 15 | 6 | 88 | 47 | 100 | 83 | 76 | 32 | 57 | 74 | 53 | 21 | 92 | 80 | 94 | 30 | 73 | 16
PRODUCT 7 | 47 | 77 | 43 | 26 | 97 | 98 | 32 | 68 | 69 | 27 | 45 | 5 | 75 | 18 | 16 | 37 | 8 | 84 | 80 | 26 | 34 | 50 | 26 | 92 | 8 | 98 | 62 | 76 | 50 | 87 | 51 | 71 | 98 | 59 | 67 | 46 | 43 | 42 | 46 | 29 | 4 | 17 | 53 | 14 | 13 | 56 | 93 | 98 | 91 | 9 | 66 | 39 | 29 | 100 | 93 | 52 | 12 | 84 | 53 | 87 | 39 | 40 | 50 | 83 | 11 | 8 | 54 | 76 | 64 | 61 | 71 | 86 | 72 | 2 | 29 | 43 | 39 | 15 | 37 | 52 | 81 | 53 | 35 | 54 | 72 | 25 | 70 | 9 | 79 | 5 | 86 | 57 | 1 | 51 | 7 | 14 | 41 | 56
PRODUCT 8 | 23 | 72 | 79 | 9 | 30 | 64 | 97 | 85 | 79 | 60 | 20 | 61 | 90 | 12 | 63 | 21 | 14 | 49 | 16 | 66 | 59 | 68 | 27 | 43 | 81 | 86 | 42 | 1 | 37 | 76 | 92 | 50 | 64 | 77 | 98 | 27 | 72 | 31 | 97 | 78 | 97 | 90 | 16 | 38 | 89 | 65 | 19 | 85 | 90 | 91 | 64 | 65 | 62 | 56 | 29 | 90 | 48 | 10 | 93 | 53 | 29 | 39 | 20 | 52 | 98 | 79 | 43 | 14 | 23 | 28 | 25 | 2 | 12 | 62 | 34 | 92 | 89 | 58 | 62 | 49 | 23 | 9 | 32 | 74 | 24 | 83 | 24 | 50 | 82 | 47 | 4 | 24 | 44 | 98 | 30 | 22 | 56 | 28
PRODUCT 9 | 1 | 17 | 62 | 12 | 5 | 87 | 3 | 12 | 24 | 47 | 92 | 32 | 63 | 95 | 92 | 83 | 10 | 59 | 87 | 18 | 28 | 95 | 50 | 23 | 57 | 34 | 83 | 64 | 21 | 10 | 26 | 45 | 40 | 25 | 64 | 40 | 62 | 100 | 9 | 81 | 76 | 75 | 66 | 47 | 68 | 23 | 46 | 100 | 12 | 40 | 77 | 63 | 25 | 8 | 49 | 41 | 84 | 35 | 19 | 30 | 56 | 26 | 55 | 86 | 39 | 23 | 44 | 3 | 53 | 12 | 48 | 66 | 7 | 95 | 86 | 92 | 73 | 90 | 41 | 17 | 88 | 17 | 62 | 49 | 20 | 42 | 18 | 64 | 70 | 57 | 100 | 50 | 7 | 27 | 77 | 28 | 78 | 5
PRODUCT 10 | 56 | 10 | 37 | 8 | 95 | 49 | 43 | 16 | 61 | 66 | 56 | 85 | 55 | 88 | 22 | 16 | 76 | 57 | 89 | 85 | 66 | 94 | 26 | 45 | 89 | 50 | 28 | 50 | 65 | 55 | 35 | 88 | 65 | 2 | 63 | 96 | 70 | 20 | 57 | 30 | 37 | 70 | 76 | 49 | 53 | 97 | 13 | 85 | 70 | 54 | 21 | 95 | 99 | 91 | 91 | 83 | 2 | 89 | 31 | 73 | 40 | 71 | 17 | 52 | 94 | 42 | 40 | 36 | 48 | 79 | 55 | 45 | 86 | 79 | 70 | 53 | 11 | 91 | 98 | 28 | 80 | 46 | 30 | 36 | 92 | 31 | 85 | 76 | 69 | 36 | 95 | 38 | 2 | 50 | 8 | 97 | 61 | 74
 | RESULTS (MAX OF SUM FOUR WEEKS IN A ROW)
PRODUCT 1 | ?
PRODUCT 2 | ?
PRODUCT 3 | ?
PRODUCT 4 | ?
PRODUCT 5 | ?
PRODUCT 6 | ?
PRODUCT 7 | ?
PRODUCT 8 | ?
PRODUCT 9 | ?
PRODUCT 10 | ?