Spreadsheet: 271244d1381871167-counting-based-on-3-values-spare-count2
Sheet: Sheet1

Name | Week | Date |  |  |  |  |  |  | Month | Month
[NAME] | 19 | 2013-11-02 00:00:00 |  |  |  |  |  |  | Nov | Dec
[NAME] | 19 | 2013-11-03 00:00:00 |  |  |  |  |  | [NAME]
[NAME] | 19 | 2013-11-04 00:00:00 |  |  |  |  |  | MARK
[NAME] | 19 | 2013-11-05 00:00:00
[NAME] | 19 | 2013-11-06 00:00:00 | Spare
[NAME] | 19 | 2013-11-07 00:00:00
[NAME] | 19 | 2013-11-08 00:00:00
[NAME] | 20 | 2013-11-09 00:00:00 | Spare
[NAME] | 20 | 2013-11-10 00:00:00 |  |  |  |  |  | What the outcome should be:
[NAME] | 20 | 2013-11-11 00:00:00
[NAME] | 20 | 2013-11-12 00:00:00 |  |  |  |  |  |  | Nov | Dec
[NAME] | 20 | 2013-11-13 00:00:00 |  |  |  |  |  | [NAME] | 7 | 4
[NAME] | 20 | 2013-11-14 00:00:00 |  |  |  |  |  | MARK | 6 | 2
[NAME] | 20 | 2013-11-15 00:00:00
[NAME] | 21 | 2013-11-16 00:00:00
[NAME] | 21 | 2013-11-17 00:00:00
[NAME] | 21 | 2013-11-18 00:00:00 | Spare
[NAME] | 21 | 2013-11-19 00:00:00 | Spare
[NAME] | 21 | 2013-11-20 00:00:00 | Spare
[NAME] | 21 | 2013-11-21 00:00:00
[NAME] | 21 | 2013-11-22 00:00:00
[NAME] | 22 | 2013-11-23 00:00:00
[NAME] | 22 | 2013-11-24 00:00:00 | Spare
[NAME] | 22 | 2013-11-25 00:00:00
[NAME] | 22 | 2013-11-26 00:00:00
[NAME] | 22 | 2013-11-27 00:00:00 | Spare
[NAME] | 22 | 2013-11-28 00:00:00
[NAME] | 22 | 2013-11-29 00:00:00
[NAME] | 23 | 2013-11-30 00:00:00
[NAME] | 23 | 2013-12-01 00:00:00
[NAME] | 23 | 2013-12-02 00:00:00
[NAME] | 23 | 2013-12-03 00:00:00
[NAME] | 23 | 2013-12-04 00:00:00 | Spare
[NAME] | 23 | 2013-12-05 00:00:00 | Spare
[NAME] | 23 | 2013-12-06 00:00:00 | Spare
[NAME] | 24 | 2013-12-07 00:00:00
[NAME] | 24 | 2013-12-08 00:00:00
[NAME] | 24 | 2013-12-09 00:00:00
[NAME] | 24 | 2013-12-10 00:00:00
[NAME] | 24 | 2013-12-11 00:00:00
[NAME] | 24 | 2013-12-12 00:00:00
[NAME] | 24 | 2013-12-13 00:00:00 | Spare
MARK | 19 | 2013-11-02 00:00:00
MARK | 19 | 2013-11-03 00:00:00
MARK | 19 | 2013-11-04 00:00:00
MARK | 19 | 2013-11-05 00:00:00
MARK | 19 | 2013-11-06 00:00:00
MARK | 19 | 2013-11-07 00:00:00
MARK | 19 | 2013-11-08 00:00:00
MARK | 20 | 2013-11-09 00:00:00
MARK | 20 | 2013-11-10 00:00:00
MARK | 20 | 2013-11-11 00:00:00
MARK | 20 | 2013-11-12 00:00:00
MARK | 20 | 2013-11-13 00:00:00
MARK | 20 | 2013-11-14 00:00:00 | Spare
MARK | 20 | 2013-11-15 00:00:00 | Spare
MARK | 21 | 2013-11-16 00:00:00
MARK | 21 | 2013-11-17 00:00:00
MARK | 21 | 2013-11-18 00:00:00
MARK | 21 | 2013-11-19 00:00:00 | Spare
MARK | 21 | 2013-11-20 00:00:00
MARK | 21 | 2013-11-21 00:00:00
MARK | 21 | 2013-11-22 00:00:00 | Spare
MARK | 22 | 2013-11-23 00:00:00
MARK | 22 | 2013-11-24 00:00:00
MARK | 22 | 2013-11-25 00:00:00
MARK | 22 | 2013-11-26 00:00:00
MARK | 22 | 2013-11-27 00:00:00
MARK | 22 | 2013-11-28 00:00:00
MARK | 22 | 2013-11-29 00:00:00 | Spare
MARK | 23 | 2013-11-30 00:00:00 | Spare
MARK | 23 | 2013-12-01 00:00:00 | Spare
MARK | 23 | 2013-12-02 00:00:00
MARK | 23 | 2013-12-03 00:00:00
MARK | 23 | 2013-12-04 00:00:00
MARK | 23 | 2013-12-05 00:00:00
MARK | 23 | 2013-12-06 00:00:00
MARK | 24 | 2013-12-07 00:00:00
MARK | 24 | 2013-12-08 00:00:00 | Spare
MARK | 24 | 2013-12-09 00:00:00
MARK | 24 | 2013-12-10 00:00:00
MARK | 24 | 2013-12-11 00:00:00
MARK | 24 | 2013-12-12 00:00:00
MARK | 24 | 2013-12-13 00:00:00