Spreadsheet: 329579d1404342215-conditional-sumproduct-conditional-sumproduct
Sheet: DATA

Date | Number of Tests | Absentee Rate | Daily Socre | # Tests | Absentee Rate | Daily Test Score | MONTH
2014-02-01 00:00:00 | 4 | 0 | 1
2014-05-01 00:00:00 | 6 | 0 | 0.8333
2014-06-01 00:00:00 | 6 | 0.1667 | 0.4
2014-07-01 00:00:00 | 3 | 0 | 0.3333
2014-08-01 00:00:00 | 3 | 0.3333 | 0.3333 |  |  |  |  |  |  | Month | Weighted Monthly Test Result
2014-09-01 00:00:00 | 4 | 0 | 0.5 |  |  |  |  |  |  | 1
2014-12-01 00:00:00 | 4 | 0 | 0.5 |  |  |  |  |  |  | 2
01/13/2014 | 3 | 0 | 1 |  |  |  |  |  |  | 3
01/14/2014 | 1 | 0 | 1 |  |  |  |  |  |  | 4
01/15/2014 | 8 | 0 | 0.75 |  |  |  |  |  |  | 5
01/16/2014 | 5 | 0 | 1 |  |  |  |  |  |  | 6
01/19/2014 | 3 | 0 | 1
01/20/2014 | 5 | 0.2 | 0.6
01/21/2014 | 3 | 0 | 1
01/22/2014 | 9 | 0.1111 | 0.6667 |  |  |  |  |  |  | Month | Weighted Monthly Test Result
01/23/2014 | 3 | 0 | 0.6667 |  |  |  |  |  |  | 1
01/27/2014 | 6 | 0 | 1 |  |  |  |  |  |  | 2
[NAME] | 8 | 0 | 0.875 |  |  |  |  |  |  | 3
01/29/2014 | 5 | 0 | 0.4 |  |  |  |  |  |  | 4
01/30/2014 | 5 | 0 | 1 |  |  |  |  |  |  | 5
2014-02-02 00:00:00 | 13 | 0.0769 | 0.8462 |  |  |  |  |  |  | 6
2014-03-02 00:00:00 | 7 | 0.2857 | 0.5
2014-04-02 00:00:00 | 4 | 0 | 1
2014-05-02 00:00:00 | 3 | 0.3333 | 0.6667
2014-06-02 00:00:00 | 4 | 0 | 1
2014-09-02 00:00:00 | 10 | 0 | 1
2014-10-02 00:00:00 | 5 | 0.2 | 1
2014-11-02 00:00:00 | 1 | 0 | 1
2014-12-02 00:00:00 | 7 | 0 | 0.8571
02/13/2014 | 4 | 0 | 1
02/16/2014 | 5 | 0.2 | 1
02/17/2014 | 5 | 0 | 0.8
02/18/2014 | 7 | 0 | 0.7143
02/19/2014 | 6 | 0.1667 | 1
[NAME] | 5 | 0 | 0.75
02/23/2014 | 6 | 0 | 1
02/24/2014 | 9 | 0 | 0.875
02/25/2014 | 8 | 0 | 0.75
[NAME] | 14 | 0 | 0.7692
02/27/2014 | 10 | 0 | 1
2014-02-03 00:00:00 | 1 | 0 | 1
2014-03-03 00:00:00 | 10 | 0.1 | 1
2014-04-03 00:00:00 | 7 | 0.1429 | 0.7143
2014-05-03 00:00:00 | 9 | 0 | 0.7778
2014-06-03 00:00:00 | 8 | 0 | 0.75
2014-09-03 00:00:00 | 8 | 0 | 0.75
2014-10-03 00:00:00 | 11 | 0.0909 | 0.6667
2014-11-03 00:00:00 | 5 | 0 | 0.6
2014-12-03 00:00:00 | 6 | 0 | 0.8333
03/13/2014 | 4 | 0 | 1
03/16/2014 | 8 | 0.125 | 0.75
03/17/2014 | 7 | 0 | 1
03/18/2014 | 6 | 0.1667 | 1
03/19/2014 | 4 | 0 | 1
03/20/2014 | 4 | 0 | 0.75
03/23/2014 | 8 | 0 | 1
03/24/2014 | 8 | 0 | 0.75
03/25/2014 | 7 | 0 | 0.8333
03/26/2014 | 5 | 0 | 0.8
03/30/2014 | 11 | 0.1818 | 0.8889
03/31/2014 | 6 | 0.3333 | 0.6
2014-01-04 00:00:00 | 8 | 0 | 1
2014-02-04 00:00:00 | 3 | 0 | 0.6667
2014-03-04 00:00:00 | 6 | 0 | 0.6
2014-06-04 00:00:00 | 7 | 0 | 0.8571
2014-07-04 00:00:00 | 9 | 0 | 0.7143
2014-08-04 00:00:00 | 2 | 0 | 1
2014-09-04 00:00:00 | 10 | 0 | 0.7
2014-10-04 00:00:00 | 13 | 0 | 0.4615
2014-11-04 00:00:00 | 2 | 0 | 1
04/13/2014 | 9 | 0 | 0.8889
04/14/2014 | 10 | 0 | 0.8
04/15/2014 | 4 | 0 | 0.75
04/16/2014 | 7 | 0 | 0.8571
04/17/2014 | - | 0 | 0
04/21/2014 | 3 | 0 | 0.6667
04/22/2014 | 3 | 0.3333 | 0.6667
[NAME] | 6 | 0 | 1
04/24/2014 | 2 | 0 | 0.5
04/27/2014 | 7 | 0 | 0.7143
04/28/2014 | 7 | 0.1429 | 0.8571
04/29/2014 | 9 | 0 | 0.8889
04/30/2014 | 8 | 0 | 0.8571
2014-01-05 00:00:00 | 3 | 0 | 0.6667
2014-04-05 00:00:00 | 6 | 0.1667 | 0.8333
2014-05-05 00:00:00 | 6 | 0.1667 | 0.3333
2014-06-05 00:00:00 | 9 | 0 | 0.5556
2014-07-05 00:00:00 | 9 | 0 | 0.75
2014-08-05 00:00:00 | 7 | 0.1429 | 0.5714
2014-11-05 00:00:00 | 6 | 0 | 1
2014-12-05 00:00:00 | 8 | 0 | 0.875
05/13/2014 | 9 | 0 | 1
05/14/2014 | 9 | 0.3333 | 0.3333
05/15/2014 | 5 | 0.2 | 0.6
05/16/2014 | 1 | 0 | 1
05/18/2014 | 5 | 0 | 0.8
05/19/2014 | 1 | 0 | 1
05/20/2014 | 4 | 0 | 1
05/21/2014 | 9 | 0 | 0.875
05/22/2014 | 13 | 0.2308 | 0.5
05/23/2014 | 2 | 0 | 1
05/25/2014 | 11 | 0 | 0.8182
05/26/2014 | 8 | 0 | 0.8571
05/27/2014 | 7 | 0.2857 | 0.7143
05/28/2014 | 7 | 0 | 1
05/29/2014 | 6 | 0.1667 | 0.6667
05/30/2014 | 1 | 0 | 1
2014-02-06 00:00:00 | 2 | 0 | 0
2014-03-06 00:00:00 | 7 | 0.1429 | 0.8
2014-04-06 00:00:00 | 3 | 0 | 1
2014-05-06 00:00:00 | 10 | 0 | 0.7778
2014-08-06 00:00:00 | 2 | 0 | 1
2014-09-06 00:00:00 | 3 | 0 | 1
2014-10-06 00:00:00 | 6 | 0.1667 | 0.8
2014-11-06 00:00:00 | 5 | 0 | 1
2014-12-06 00:00:00 | 10 | 0 | 0.625
06/15/2014 | 6 | 0 | 0.8333
06/16/2014 | 10 | 0.1111 | 0.8571
06/17/2014 | 6 | 0 | 0.8333
06/18/2014 | 6 | 0 | 1
06/19/2014 | 2 | 0 | 0.5
06/22/2014 | 8 | 0.375 | 0.5714
06/23/2014 | 7 | 0 | 0.8333
06/24/2014 | 3 | 0 | 1
06/25/2014 | 7 | 0.25 | 0.75
06/26/2014 | 6 | 0 | 0.8
06/29/2014 | 2 | 0 | 0.5
06/30/2014 | 2 | 0 | 0.5
 | 770 | 0.0558 | 0.7889
 | 770 | 0.0558 | 0.7889