Spreadsheet: 81735d1281907662-formulas-previously-working-now-resulting-in-0-trimmean-average-formulas-used-excel-help-forum-rev1
Sheet: Pre-Makes

 |  |  |  |  |  | Monday |  |  |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  |  |  | Thursday |  |  |  |  |  |  |  |  | Friday |  |  |  |  |  |  |  |  | Saturday |  |  |  |  |  |  |  |  | Sunday
 |  | Pans |  |  |  | Mids |  |  |  | Thins | Pans |  |  |  | Mids |  |  |  | Thins | Pans |  |  |  | Mids |  |  |  | Thins | Pans |  |  |  | Mids |  |  |  | Thins | Pans |  |  |  | Mids |  |  |  | Thins | Pans |  |  |  | Mids |  |  |  | Thins | Pans |  |  |  | Mids |  |  |  | Thins
Week Ending | Net Sales | MEAT | HAW | PEP | SUP | MEAT | HAW | PEP | SUP | PEP | MEAT | HAW | PEP | SUP | MEAT | HAW | PEP | SUP | PEP | MEAT | HAW | PEP | SUP | MEAT | HAW | PEP | SUP | PEP | MEAT | HAW | PEP | SUP | MEAT | HAW | PEP | SUP | PEP | MEAT | HAW | PEP | SUP | MEAT | HAW | PEP | SUP | PEP | MEAT | HAW | PEP | SUP | MEAT | HAW | PEP | SUP | PEP | MEAT | HAW | PEP | SUP | MEAT | HAW | PEP | SUP | PEP
Make
5 Week Average
2011-03-06 00:00:00 | 0
2011-02-27 00:00:00 | 0
2011-02-20 00:00:00 | 0
2011-02-13 00:00:00 | 0
2011-02-06 00:00:00 | 0
2011-01-30 00:00:00 | 0
2011-01-23 00:00:00 | 0
2011-01-16 00:00:00 | 0
2011-01-09 00:00:00 | 0
2011-01-02 00:00:00 | 0
2010-12-26 00:00:00 | 0
2010-12-19 00:00:00 | 0
2010-12-12 00:00:00 | 0
2010-12-05 00:00:00 | 0
2010-11-28 00:00:00 | 0
2010-11-21 00:00:00 | 0
2010-11-14 00:00:00 | 0
2010-11-07 00:00:00 | 0
2010-10-31 00:00:00 | 0
2010-10-24 00:00:00 | 0
2010-10-17 00:00:00 | 0
2010-10-10 00:00:00 | 0
2010-10-03 00:00:00 | 0
2010-09-26 00:00:00 | 0
2010-09-19 00:00:00 | 0
2010-09-12 00:00:00 | 0
2010-09-05 00:00:00 | 0
2010-08-29 00:00:00 | 0
2010-08-22 00:00:00 | 0
2010-08-15 00:00:00 | 16916.87 | 3 | 2 | 0 | 0 | 10 | 7 | 1 | 6 | 0 | 50 | 39 | 9 | 32 | 57 | 36 | 9 | 45 | 16 | 9 | 8 | 0 | 4 | 17 | 8 | 1 | 6 | 2 | 16 | 7 | 1 | 5 | 13 | 3 | 6 | 11 | 5 | 18 | 10 | 6 | 7 | 32 | 16 | 8 | 19 | 6 | 25 | 13 | 2 | 10 | 24 | 13 | 3 | 20 | 6 | 8 | 4 | 1 | 6 | 27 | 5 | 5 | 20 | 2
2010-08-08 00:00:00 | 16278.25 | 4 | 5 | 0 | 2 | 7 | 5 | 1 | 6 | 1 | 50 | 22 | 5 | 30 | 64 | 38 | 9 | 55 | 10 | 2 | 6 | 0 | 6 | 9 | 5 | 3 | 10 | 3 | 3 | 4 | 2 | 6 | 14 | 4 | 4 | 9 | 4 | 24 | 10 | 4 | 7 | 30 | 16 | 11 | 23 | 8 | 19 | 8 | 3 | 7 | 33 | 16 | 3 | 25 | 3 | 8 | 4 | 1 | 8 | 9 | 7 | 3 | 7 | 4
2010-08-01 00:00:00 | 16363.07 | 6 | 2 | 1 | 5 | 8 | 7 | 3 | 8 | 2 | 37 | 25 | 3 | 33 | 51 | 31 | 10 | 49 | 14 | 11 | 7 | 2 | 7 | 6 | 6 | 2 | 11 | 4 | 8 | 6 | 1 | 6 | 13 | 8 | 4 | 8 | 1 | 18 | 10 | 5 | 11 | 29 | 17 | 10 | 21 | 4 | 24 | 9 | 2 | 5 | 30 | 19 | 5 | 23 | 8 | 9 | 6 | 0 | 4 | 12 | 9 | 3 | 10 | 1
2010-07-25 00:00:00 | 16136.01 | 4 | 1 | 1 | 3 | 9 | 3 | 0 | 3 | 2 | 45 | 28 | 3 | 32 | 58 | 33 | 12 | 58 | 16 | 6 | 4 | 0 | 7 | 10 | 6 | 2 | 8 | 1 | 16 | 6 | 0 | 11 | 12 | 7 | 4 | 8 | 3 | 19 | 7 | 3 | 9 | 31 | 13 | 11 | 25 | 5 | 20 | 9 | 1 | 12 | 36 | 22 | 4 | 17 | 7 | 5 | 3 | 0 | 7 | 16 | 10 | 1 | 8 | 2
2010-07-18 00:00:00 | 16656.02 | 7 | 1 | 0 | 5 | 11 | 5 | 4 | 14 | 7 | 48 | 29 | 9 | 31 | 55 | 27 | 17 | 58 | 11 | 5 | 2 | 0 | 1 | 13 | 7 | 4 | 11 | 2 | 11 | 7 | 0 | 16 | 12 | 18 | 2 | 8 | 2 | 31 | 16 | 9 | 23 | 31 | 12 | 3 | 13 | 4 | 24 | 14 | 3 | 7 | 34 | 16 | 7 | 18 | 8 | 14 | 7 | 0 | 4 | 6 | 7 | 3 | 10 | 4
2010-07-11 00:00:00 | 19018.2 | 8 | 4 | 1 | 5 | 11 | 13 | 2 | 8 | 5 | 49 | 22 | 3 | 26 | 67 | 34 | 16 | 55 | 4 | 15 | 11 | 1 | 9 | 26 | 19 | 6 | 15 | 5 | 17 | 7 | 1 | 5 | 34 | 21 | 13 | 13 | 2 | 22 | 12 | 3 | 8 | 28 | 20 | 10 | 30 | 4 | 19 | 17 | 1 | 6 | 35 | 22 | 12 | 32 | 8 | 10 | 7 | 0 | 7 | 22 | 13 | 5 | 9 | 7
2010-07-04 00:00:00 | 17041.21 | 4 | 3 | 0 | 3 | 7 | 6 | 2 | 8 | 6 | 32 | 21 | 8 | 38 | 56 | 37 | 14 | 14 | 16 | 11 | 4 | 0 | 7 | 15 | 9 | 0 | 18 | 5 | 8 | 9 | 0 | 5 | 20 | 7 | 5 | 16 | 2 | 14 | 11 | 6 | 10 | 25 | 12 | 4 | 18 | 5 | 24 | 10 | 1 | 12 | 33 | 18 | 7 | 34 | 10 | 15 | 12 | 4 | 16 | 11 | 5 | 2 | 8 | 6
2010-06-27 00:00:00 | 16473.98 | 3 | 1 | 0 | 3 | 15 | 5 | 4 | 10 | 5 | 37 | 30 | 4 | 35 | 44 | 26 | 10 | 60 | 16 | 3 | 4 | 0 | 9 | 16 | 10 | 3 | 17 | 3 | 10 | 9 | 3 | 0 | 16 | 3 | 2 | 18 | 2 | 11 | 10 | 3 | 5 | 28 | 17 | 8 | 22 | 3 | 13 | 10 | 4 | 12 | 35 | 20 | 10 | 30 | 5 | 12 | 5 | 0 | 6 | 21 | 7 | 4 | 19 | 3
2010-06-20 00:00:00 | 15973.14 | 10 | 1 | 5 | 8 | 13 | 14 | 3 | 11 | 4 | 41 | 20 | 3 | 24 | 42 | 28 | 7 | 48 | 6 | 10 | 9 | 0 | 7 | 25 | 10 | 2 | 21 | 1 | 9 | 6 | 0 | 4 | 11 | 3 | 7 | 9 | 4 | 17 | 15 | 1 | 14 | 19 | 11 | 3 | 15 | 7 | 14 | 8 | 1 | 11 | 19 | 14 | 5 | 17 | 8 | 8 | 5 | 1 | 7 | 6 | 4 | 3 | 10 | 3
2010-06-13 00:00:00 | 17524.56 | 4 | 2 | 0 | 5 | 4 | 5 | 2 | 9 | 0 | 40 | 24 | 7 | 23 | 55 | 32 | 16 | 60 | 1 | 5 | 3 | 0 | 7 | 12 | 4 | 1 | 8 | 2 | 8 | 5 | 1 | 6 | 16 | 13 | 2 | 11 | 1 | 21 | 13 | 0 | 13 | 39 | 23 | 9 | 24 | 1 | 20 | 8 | 2 | 10 | 26 | 22 | 14 | 22 | 1 | 18 | 7 | 3 | 9 | 32 | 12 | 2 | 19 | 1
2010-06-06 00:00:00 | 15485.79 | 2 | 1 | 1 | 1 | 10 | 4 | 2 | 6 | 1 | 38 | 35 | 5 | 25 | 65 | 25 | 10 | 59 | 2 | 6 | 3 | 1 | 2 | 10 | 4 | 3 | 15 | 3 | 8 | 1 | 1 | 5 | 9 | 8 | 2 | 10 | 2 | 22 | 16 | 2 | 18 | 33 | 15 | 12 | 22 | 2 | 16 | 11 | 5 | 7 | 19 | 11 | 7 | 15 | 2 | 9 | 5 | 1 | 4 | 13 | 9 | 1 | 13 | 2
2010-05-30 00:00:00 | 17188.31 | 8 | 6 | 0 | 3 | 8 | 6 | 4 | 11 | 2 | 34 | 19 | 8 | 36 | 51 | 27 | 10 | 54 | 3 | 15 | 6 | 0 | 4 | 25 | 14 | 7 | 22 | 4 | 5 | 1 | 1 | 3 | 13 | 7 | 5 | 16 | 3 | 16 | 9 | 7 | 7 | 25 | 12 | 6 | 11 | 3 | 21 | 12 | 4 | 6 | 17 | 15 | 6 | 19 | 3 | 8 | 4 | 2 | 9 | 16 | 9 | 1 | 12 | 3
2010-05-23 00:00:00 | 15757.11 | 6 | 5 | 1 | 7 | 6 | 5 | 2 | 6 | 3 | 44 | 26 | 6 | 33 | 48 | 30 | 10 | 50 | 4 | 8 | 5 | 0 | 9 | 8 | 4 | 6 | 11 | 5 | 8 | 7 | 1 | 4 | 10 | 6 | 2 | 7 | 4 | 20 | 12 | 3 | 8 | 17 | 17 | 3 | 15 | 4 | 15 | 10 | 2 | 3 | 24 | 18 | 8 | 31 | 4 | 8 | 1 | 2 | 3 | 25 | 9 | 3 | 18 | 4
2010-05-16 00:00:00 | 15931.78 | 1 | 2 | 0 | 4 | 7 | 8 | 2 | 13 | 4 | 31 | 22 | 10 | 30 | 55 | 34 | 20 | 48 | 5 | 11 | 5 | 1 | 6 | 5 | 2 | 1 | 8 | 6 | 6 | 4 | 0 | 5 | 10 | 6 | 4 | 15 | 5 | 14 | 9 | 4 | 12 | 36 | 23 | 6 | 31 | 5 | 10 | 10 | 1 | 8 | 17 | 10 | 9 | 22 | 5 | 5 | 1 | 1 | 3 | 25 | 17 | 4 | 17 | 5
2010-05-09 00:00:00 | 15568.34 | 7 | 2 | 0 | 2 | 6 | 4 | 1 | 4 | 5 | 41 | 27 | 10 | 45 | 61 | 23 | 18 | 63 | 6 | 6 | 2 | 1 | 7 | 16 | 7 | 5 | 12 | 7 | 3 | 4 | 0 | 3 | 11 | 5 | 3 | 5 | 6 | 22 | 16 | 3 | 8 | 35 | 14 | 9 | 15 | 6 | 17 | 8 | 0 | 7 | 14 | 7 | 3 | 19 | 6 | 16 | 6 | 2 | 9 | 21 | 7 | 3 | 30 | 6
2010-05-02 00:00:00 | 15706.16 | 8 | 2 | 0 | 3 | 10 | 7 | 4 | 10 | 6 | 30 | 26 | 4 | 28 | 48 | 21 | 9 | 37 | 7 | 5 | 3 | 2 | 1 | 5 | 9 | 4 | 7 | 8 | 12 | 3 | 1 | 6 | 13 | 8 | 5 | 15 | 7 | 12 | 11 | 5 | 8 | 37 | 6 | 8 | 10 | 7 | 20 | 14 | 1 | 8 | 18 | 10 | 7 | 11 | 7 | 14 | 2 | 2 | 7 | 12 | 1 | 4 | 9 | 7
2010-04-25 00:00:00 | 17302.31 | 1 | 3 | 0 | 3 | 2 | 4 | 2 | 3 | 7 | 51 | 32 | 6 | 37 | 62 | 36 | 18 | 48 | 8 | 5 | 2 | 1 | 4 | 5 | 10 | 2 | 11 | 9 | 5 | 5 | 1 | 6 | 15 | 5 | 1 | 9 | 8 | 20 | 11 | 2 | 15 | 29 | 20 | 10 | 16 | 8 | 21 | 8 | 5 | 9 | 29 | 17 | 5 | 21 | 8 | 14 | 4 | 2 | 16 | 21 | 12 | 6 | 12 | 8
2010-04-18 00:00:00 | 19112.88 | 11 | 6 | 1 | 7 | 8 | 6 | 4 | 6 | 8 | 60 | 26 | 5 | 33 | 85 | 45 | 20 | 60 | 9 | 14 | 5 | 2 | 4 | 20 | 15 | 3 | 20 | 10 | 15 | 9 | 2 | 15 | 11 | 12 | 6 | 18 | 9 | 27 | 13 | 2 | 23 | 24 | 24 | 4 | 20 | 9 | 17 | 5 | 2 | 14 | 34 | 23 | 9 | 26 | 9 | 5 | 5 | 1 | 7 | 16 | 1 | 1 | 7 | 9
2010-04-11 00:00:00 | 16898.06 | 4 | 7 | 0 | 3 | 15 | 4 | 0 | 12 | 9 | 65 | 27 | 8 | 38 | 45 | 32 | 16 | 54 | 10 | 12 | 4 | 2 | 2 | 14 | 8 | 2 | 12 | 11 | 13 | 10 | 3 | 5 | 17 | 12 | 5 | 12 | 10 | 19 | 10 | 3 | 10 | 31 | 9 | 7 | 15 | 10 | 15 | 9 | 1 | 11 | 31 | 17 | 2 | 16 | 10 | 9 | 5 | 2 | 5 | 22 | 10 | 5 | 18 | 10
2010-04-04 00:00:00 | 17502.42 | 0 | 1 | 0 | 3 | 10 | 7 | 0 | 7 | 10 | 39 | 32 | 3 | 34 | 56 | 26 | 15 | 49 | 11 | 7 | 5 | 0 | 2 | 9 | 5 | 4 | 9 | 12 | 15 | 12 | 2 | 8 | 24 | 17 | 10 | 17 | 11 | 7 | 6 | 3 | 2 | 15 | 5 | 0 | 7 | 11 | 19 | 10 | 4 | 9 | 28 | 13 | 6 | 21 | 11 | 5 | 4 | 0 | 8 | 16 | 12 | 4 | 16 | 11
2010-03-28 00:00:00 | 17280.21 | 5 | 3 | 1 | 2 | 8 | 6 | 4 | 7 | 11 | 45 | 32 | 5 | 35 | 60 | 35 | 13 | 64 | 12 | 5 | 3 | 1 | 8 | 10 | 9 | 3 | 13 | 13 | 13 | 4 | 3 | 5 | 18 | 9 | 6 | 23 | 12 | 21 | 16 | 3 | 17 | 39 | 22 | 3 | 26 | 12 | 23 | 14 | 1 | 13 | 38 | 18 | 10 | 22 | 12 | 9 | 8 | 1 | 4 | 19 | 14 | 10 | 18 | 12
2010-03-21 00:00:00 | 15171.05 | 3 | 2 | 0 | 2 | 9 | 2 | 0 | 6 | 12 | 41 | 24 | 2 | 22 | 48 | 33 | 16 | 60 | 13 | 8 | 9 | 2 | 5 | 11 | 7 | 3 | 10 | 14 | 8 | 4 | 2 | 7 | 17 | 10 | 0 | 15 | 13 | 13 | 13 | 4 | 14 | 29 | 15 | 5 | 22 | 13 | 13 | 11 | 4 | 14 | 21 | 18 | 6 | 17 | 13 | 9 | 4 | 0 | 10 | 17 | 11 | 2 | 11 | 13
2010-03-14 00:00:00 | 16825.74 | 0 | 1 | 1 | 4 | 9 | 11 | 3 | 13 | 13 | 40 | 30 | 4 | 36 | 61 | 28 | 13 | 50 | 14 | 7 | 9 | 1 | 6 | 7 | 6 | 4 | 8 | 15 | 9 | 3 | 0 | 9 | 16 | 6 | 4 | 10 | 14 | 28 | 13 | 3 | 12 | 48 | 20 | 11 | 33 | 14 | 12 | 5 | 3 | 12 | 47 | 12 | 7 | 14 | 14 | 8 | 1 | 1 | 4 | 13 | 10 | 2 | 14 | 14
2010-03-07 00:00:00 | 15580.17 | 1 | 2 | 0 | 4 | 10 | 4 | 0 | 3 | 14 | 42 | 21 | 2 | 35 | 42 | 24 | 15 | 50 | 15 | 11 | 1 | 1 | 9 | 9 | 8 | 2 | 14 | 16 | 12 | 6 | 0 | 4 | 13 | 11 | 2 | 16 | 15 | 22 | 6 | 2 | 9 | 31 | 10 | 6 | 16 | 15 | 15 | 16 | 4 | 11 | 35 | 17 | 3 | 18 | 15 | 8 | 5 | 0 | 5 | 16 | 10 | 5 | 12 | 15
2010-02-28 00:00:00 | 17070.69 | 2 | 1 | 1 | 0 | 7 | 3 | 1 | 10 | 15 | 57 | 33 | 7 | 36 | 56 | 34 | 13 | 52 | 16 | 8 | 5 | 2 | 8 | 11 | 6 | 1 | 10 | 17 | 12 | 1 | 2 | 4 | 17 | 9 | 2 | 15 | 16 | 23 | 16 | 4 | 17 | 36 | 17 | 2 | 25 | 16 | 16 | 9 | 1 | 7 | 36 | 17 | 7 | 23 | 16 | 8 | 5 | 1 | 4 | 17 | 6 | 6 | 23 | 16
2010-02-21 00:00:00 | 16870.98 | 3 | 5 | 0 | 1 | 7 | 2 | 2 | 3 | 16 | 46 | 33 | 5 | 30 | 49 | 32 | 15 | 47 | 17 | 14 | 15 | 4 | 9 | 8 | 4 | 2 | 10 | 18 | 5 | 3 | 0 | 7 | 17 | 7 | 7 | 26 | 17 | 19 | 14 | 3 | 12 | 32 | 26 | 9 | 27 | 17 | 19 | 9 | 8 | 10 | 21 | 12 | 4 | 26 | 17 | 6 | 3 | 1 | 10 | 22 | 5 | 2 | 19 | 17
2010-02-14 00:00:00 | 16372.8364604324 | 4 | 2 | 0 | 5 | 8 | 6 | 3 | 13 | 17 | 50 | 23 | 8 | 27 | 50 | 39 | 13 | 56 | 18 | 8 | 5 | 3 | 4 | 11 | 7 | 3 | 10 | 19 | 5 | 3 | 3 | 4 | 15 | 7 | 1 | 11 | 18 | 22 | 13 | 3 | 13 | 34 | 28 | 4 | 31 | 18 | 11 | 6 | 2 | 5 | 24 | 14 | 7 | 24 | 18 | 8 | 8 | 3 | 7 | 16 | 14 | 5 | 18 | 18
2010-02-07 00:00:00 | 14993.05310186216 | 6 | 4 | 0 | 0 | 10 | 5 | 6 | 11 | 18 | 30 | 30 | 4 | 41 | 33 | 24 | 16 | 52 | 19 | 7 | 6 | 1 | 6 | 11 | 4 | 2 | 9 | 20 | 6 | 6 | 3 | 4 | 15 | 15 | 1 | 11 | 19 | 21 | 10 | 4 | 10 | 41 | 22 | 8 | 28 | 19 | 8 | 7 | 2 | 11 | 24 | 17 | 8 | 17 | 19 | 6 | 4 | 2 | 3 | 15 | 9 | 2 | 5 | 19
2010-01-31 00:00:00 | 15146.41690944096 | 8 | 5 | 0 | 8 | 23 | 10 | 1 | 9 | 19 | 15 | 9 | 0 | 9 | 31 | 25 | 6 | 33 | 20 | 6 | 5 | 2 | 7 | 18 | 11 | 5 | 15 |  | 13 | 4 | 1 | 11 | 13 | 6 | 3 | 16 | 20 | 11 | 11 | 5 | 11 | 29 | 15 | 6 | 25 | 20 | 19 | 11 | 2 | 13 | 26 | 19 | 5 | 16 | 20 | 4 | 8 | 2 | 9 | 15 | 12 | 2 | 11 | 20