Spreadsheet: 35077d1232579557-adding-data-with-multiple-conditions-test-v2
Sheet: Data

 | Year | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009
 | Date | 2009-02-16 00:00:00 | 2009-02-23 00:00:00 | 2009-03-02 00:00:00 | 2009-03-09 00:00:00 | 2009-03-16 00:00:00 | 2009-03-23 00:00:00 | 2009-03-30 00:00:00 | 2009-04-06 00:00:00 | 2009-04-13 00:00:00 | 2009-04-20 00:00:00 | 2009-04-27 00:00:00 | 2009-05-04 00:00:00 | 2009-05-11 00:00:00 | 2009-05-18 00:00:00 | 2009-05-25 00:00:00 | 2009-06-01 00:00:00 | 2009-06-08 00:00:00 | 2009-06-15 00:00:00 | 2009-06-22 00:00:00 | 2009-06-29 00:00:00 | 2009-07-06 00:00:00 | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 2009-07-27 00:00:00 | 2009-08-03 00:00:00 | 2009-08-10 00:00:00 | 2009-08-17 00:00:00 | 2009-08-24 00:00:00 | 2009-08-31 00:00:00 | 2009-09-07 00:00:00 | 2009-09-14 00:00:00 | 2009-09-21 00:00:00 | 2009-09-28 00:00:00 | 2009-10-05 00:00:00 | 2009-10-12 00:00:00 | 2009-10-19 00:00:00 | 2009-10-26 00:00:00 | 2009-11-02 00:00:00 | 2009-11-09 00:00:00 | 2009-11-16 00:00:00 | 2009-11-23 00:00:00 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00
ResourceID
1 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
2 |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
3 |  | 5 | 5 | 5 | 5 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
4 |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
5 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
6 |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
7 |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5
3 |  |  |  |  |  |  | 4 | 4 | 4 | 4 | 4
6 |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
3 |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
7 |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5
8 |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
9 |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
10 |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
11 |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
12 |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
13 |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
14 |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
15 |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
16 |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
17 |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
18 |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
19 |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
20 |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
21 |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
22 |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  |  |  |  |  |  | Functional Design