Spreadsheet: 75947d1276544203-calculate-average-withouot-incorporating-sub-average-dummy_calculate_avg
Sheet: Sheet1

WEEK | SALES |  |  | FILL RATE
ENDING |  |  |  | CASES
 | CASES | $ | AVG $ / CS | OUT | %
GOAL |  |  |  |  | 0.997
2010-01-09 00:00:00 | 48604 | 1352075 | 27.82 | 8 | 0.9998
2010-01-16 00:00:00 | 50478 | 1424747 | 28.23 | 0 | 1
2010-01-23 00:00:00 | 51296 | 1433567 | 27.95 | 3 | 0.9999
2010-01-30 00:00:00 | 54978 | 1527994 | 27.79 | 4 | 0.9999
2010-02-06 00:00:00 | 62290 | 1756967 | 28.21 | 1 | 1
1st PRD | 53529.2 | 1499070 | 28 | 3.2 | 0.9999 |  | SUBTOTAL for the period
2010-02-13 00:00:00 | 54892 | 1509321 | 27.5 | 0 | 1
2010-02-20 00:00:00 | 60433 | 1683508 | 27.86 | 0 | 1
2010-02-27 00:00:00 | 65057 | 1811016 | 27.84 | 0 | 1
2010-03-06 00:00:00 | 62208 | 1736486 | 27.91 | 0 | 1
2ND PRD | 60647.5 | 1685082.75 | 27.78 | 0 | 1
2010-03-13 00:00:00 | 63004 | 1759249 | 27.92 | 7 | 0.9999
2010-03-20 00:00:00 | 63452 | 1769425 | 27.89 | 6 | 0.9999
2010-03-27 00:00:00 | 62705 | 1741108 | 27.77 | 25 | 0.9996
2010-04-03 00:00:00 | 60710 | 1673328 | 27.56 | 3 | 1
3RD PRD | 62467.75 | 1735777.5 | 27.79 | 10.25 | 0.9998
2010-04-10 00:00:00 | 58942 | 1601839 | 27.18 | 30 | 0.9995
2010-04-17 00:00:00 | 61497 | 1670696 | 27.17 | 5 | 0.9999
2010-04-24 00:00:00 | 64621 | 1759301 | 27.22 | 8 | 0.9999
2010-05-01 00:00:00 | 63498 | 1727700 | 27.21 | 126 | 0.998
2010-05-08 00:00:00 | 67932 | 1875573 | 27.61 | 207 | 0.997
4TH PRD | 63298 | 1727021.8 | 27.28 | 75.2 | 0.9988
 |  | 0
2010-05-15 00:00:00 | 57681 | 1561002 | 27.06 | 156 | 0.9973
2010-05-22 00:00:00 | 61620 | 1702270 | 27.63 | 16 | 0.9997
2010-05-29 00:00:00 | 71539 | 1988960 | 27.8 | 23 | 0.9997
2010-06-05 00:00:00 | 66071 | 1832147 | 27.73 | 44 | 0.9993
5TH PRD | 64227.75 | 1771094.75 | 27.58 | 59.75 | 0.9991
2010-06-12 00:00:00 |  |  | 0 |  | 0
2010-06-19 00:00:00 |  |  | 0 |  | 0
2010-06-26 00:00:00 |  |  | 0 |  | 0
2010-07-03 00:00:00 |  |  | 0 |  | 0
6TH PRD | 0 | 0 | 0 | 0 | 0
2010-07-10 00:00:00 |  |  | 0 |  | 0
2010-07-17 00:00:00 |  |  | 0 |  | 0
2010-07-24 00:00:00 |  |  | 0 |  | 0
2010-07-31 00:00:00 |  |  | 0 |  | 0
2010-08-07 00:00:00 |  |  | 0 |  | 0
7TH PRD | 0 | 0 | 0 | 0 | 0
2010-08-14 00:00:00 |  |  | 0 |  | 0
2010-08-21 00:00:00 |  |  | 0 |  | 0
2010-08-28 00:00:00 |  |  | 0 |  | 0
2010-09-04 00:00:00 |  |  | 0 |  | 0
8TH PRD | 0 | 0 | 0 | 0 | 0
2010-09-11 00:00:00 |  |  | 0 |  | 0
2010-09-18 00:00:00 |  |  | 0 |  | 0
2010-09-25 00:00:00 |  |  | 0 |  | 0
2010-10-02 00:00:00 |  |  | 0 |  | 0
9TH PRD | 0 | 0 | 0 | 0 | 0
2010-10-09 00:00:00 |  |  | 0 |  | 0
2010-10-16 00:00:00 |  |  | 0 |  | 0
2010-10-23 00:00:00 |  |  | 0 |  | 0
2010-10-30 00:00:00 |  |  | 0 |  | 0
2010-11-06 00:00:00 |  |  | 0 |  | 0
10TH PRD | 0 | 0 | 0 | 0 | 0
2010-11-13 00:00:00 |  |  | 0 |  | 0
2010-11-20 00:00:00 |  |  | 0 |  | 0
2010-11-27 00:00:00 |  |  | 0 |  | 0
2010-12-04 00:00:00 |  |  | 0 |  | 0
11TH PRD | 0 | 0 | 0 | 0 | 0
2010-12-11 00:00:00 |  |  | 0 |  | 0
2010-12-18 00:00:00 |  |  | 0 |  | 0
2010-12-25 00:00:00 |  |  | 0 |  | 0
2011-01-01 00:00:00 |  |  | 0 |  | 0
12TH PRD | 0 | 0 | 0 | 0 | 0
YTD | 60614 | 1677194.5 | 27.67545454545455 | 39.52941176470588 | 0.9995136363636365 |  | Help Calculate year to date