Spreadsheet: 109170d1306116737-using-conditional-formatting-to-match-month-conditional-formatting-query
Sheet: Sheet1

Month | Name | Date notified | Conf/Potent | Date Effective | End Date | Adjusted Effective date | Adjusted End Date | FTE | FTE Impact | Weighted FTE
2011-04-01 00:00:00 | Agent 1 | 2011-03-22 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 0.33 | -0.1 | -0.02
2011-04-01 00:00:00 | Agent 2 | 2011-03-23 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 0.77 | 0.01 | 0.002
2011-04-01 00:00:00 | Agent 3 | 2011-03-23 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 0.52 | 0 | 0
2011-04-01 00:00:00 | Agent 4 | 2011-03-23 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 0.79 | -0.1 | -0.02
2011-04-01 00:00:00 | Agent 5 | 2011-03-23 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 0.97 | -0.17 | -0.034
2011-04-01 00:00:00 | Agent 6 | 2011-03-21 00:00:00 | Confirmed | 2011-04-04 00:00:00 | n/a | 2011-04-04 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.9
2011-04-01 00:00:00 | Agent 7 | 2011-03-28 00:00:00 | Confirmed | 2011-04-04 00:00:00 | n/a | 2011-04-04 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.9
2011-04-01 00:00:00 | Agent 8 | 2011-04-04 00:00:00 | Confirmed | 2011-04-08 00:00:00 | 2011-04-08 00:00:00 | 2011-04-08 00:00:00 | 2011-04-08 00:00:00 | 1 | -1 | -0.03333333333333333
2011-04-01 00:00:00 | Agent 9 | 2011-04-05 00:00:00 | Confirmed | 2011-04-06 00:00:00 | n/a | 2011-04-06 00:00:00 | 2011-04-30 00:00:00 | 1 | 1 | 0.8333333333333334
2011-04-01 00:00:00 | Agent 10 | 2011-04-05 00:00:00 | Confirmed | 2011-04-27 00:00:00 | n/a | 2011-04-27 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.1333333333333333
2011-04-01 00:00:00 | Agent 11 | 2011-04-05 00:00:00 | Confirmed | 2011-04-07 00:00:00 | n/a | 2011-04-07 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.8
2011-04-01 00:00:00 | Agent 12 | 2011-03-28 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 0.8 | -0.06 | -0.012
2011-04-01 00:00:00 | Agent 13 | 2011-03-28 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 0.8 | -0.07 | -0.014
2011-04-01 00:00:00 | Agent 14 | 2011-04-06 00:00:00 | Confirmed | 2011-04-18 00:00:00 | 2012-01-20 00:00:00 | 2011-04-18 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.4333333333333333
2011-04-01 00:00:00 | Agent 15 | 2011-04-08 00:00:00 | Confirmed | 2011-04-29 00:00:00 | n/a | 2011-04-29 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.06666666666666665
2011-04-01 00:00:00 | Agent 16 | 2011-03-30 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 1 | -0.4 | -0.07999999999999999
2011-04-01 00:00:00 | Agent 17 | 2011-03-30 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 1 | -0.2 | -0.03999999999999999
2011-04-01 00:00:00 | Agent 18 | 2011-03-30 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 1 | -0.2 | -0.03999999999999999
2011-04-01 00:00:00 | Agent 19 | 2011-03-30 00:00:00 | Confirmed | 2011-04-25 00:00:00 |  | 2011-04-25 00:00:00 | 1900-01-01 00:00:00 | 1 | -0.2 | 271.0466666666667
2011-04-01 00:00:00 | Agent 20 | 2011-04-04 00:00:00 | Confirmed | 2011-04-25 00:00:00 | n/a | 2011-04-25 00:00:00 | 2011-04-30 00:00:00 | 0.53 | -0.06 | -0.012
2011-04-01 00:00:00 | Agent 21 | 2011-03-29 00:00:00 | Confirmed | 2011-04-11 00:00:00 | n/a | 2011-04-11 00:00:00 | 2011-04-30 00:00:00 | 0.46 | 0.46 | 0.3066666666666667
2011-04-01 00:00:00 | Agent 22 | 2011-04-14 00:00:00 | Confirmed | 2011-04-14 00:00:00 | n/a | 2011-04-14 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.5666666666666667
2011-04-01 00:00:00 | Agent 23 | 2011-04-15 00:00:00 | Confirmed | 2011-04-12 00:00:00 | 2011-07-10 00:00:00 | 2011-04-12 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.6333333333333333
2011-04-01 00:00:00 | Agent 24 | 2011-04-11 00:00:00 | Confirmed | 2011-04-27 00:00:00 | n/a | 2011-04-27 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.1333333333333333
2011-04-01 00:00:00 | Agent 25 | 2011-04-11 00:00:00 | Confirmed | 2011-04-18 00:00:00 | 2012-02-07 00:00:00 | 2011-04-18 00:00:00 | 2011-04-30 00:00:00 | 0.6 | -0.6 | -0.26
2011-04-01 00:00:00 | Agent 26 | 2011-04-18 00:00:00 | Confirmed | 2011-04-27 00:00:00 | n/a | 2011-04-27 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.1333333333333333
2011-04-01 00:00:00 | Agent 27 | 2011-04-19 00:00:00 | Confirmed | 2011-04-27 00:00:00 | 2011-05-27 00:00:00 | 2011-04-27 00:00:00 | 2011-04-30 00:00:00 | 1 | 0 | 0
2011-04-01 00:00:00 | Agent 28 | 2011-04-14 00:00:00 | Confirmed | 2011-04-18 00:00:00 | 2011-05-27 00:00:00 | 2011-04-18 00:00:00 | 2011-04-30 00:00:00 | 1 | 0 | 0
2011-04-01 00:00:00 | Agent 29 | 2011-04-28 00:00:00 | Confirmed | 2011-04-28 00:00:00 | n/a | 2011-04-28 00:00:00 | 2011-04-30 00:00:00 | 1 | 0.01 | 0.0009999999999999998
2011-04-01 00:00:00 | Agent 30 | 2011-04-08 00:00:00 | Confirmed | 2011-04-08 00:00:00 | n/a | 2011-04-08 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.7666666666666666
2011-04-01 00:00:00 | Agent 31 | 2011-04-21 00:00:00 | Confirmed | 2011-04-30 00:00:00 | n/a | 2011-04-30 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.03333333333333333
2011-04-01 00:00:00 | Agent 32 | 2011-04-20 00:00:00 | Confirmed | 2011-04-20 00:00:00 | n/a | 2011-04-20 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.3666666666666667
2011-04-01 00:00:00 | Agent 33 | 2011-04-29 00:00:00 | Confirmed | 2011-04-29 00:00:00 | n/a | 2011-04-29 00:00:00 | 2011-04-30 00:00:00 | 1 | -1 | -0.06666666666666665
2011-04-01 00:00:00 | Agent 34 |  | Confirmed | 2011-04-30 00:00:00 | n/a | 2011-04-30 00:00:00 | 2011-04-30 00:00:00 | 1 | 0 | 0