Spreadsheet: 135060d1325793088-determining-if-occurrences-exist-within-past-30-days-sample
Sheet: Sheet1

Auditor | Agent | Manager | Location | Date | Month | ID | Company | Product | Activity Flag | Description | Within Past 30 Days?
[NAME] | Agent C | [NAME] | In Office | 2011-03-09 00:00:00 | Mar-11 | 1 | Company 10 | Product 1 | 2 | Phone Number Compliance
[NAME] | Agent C | [NAME] | In Office | 2011-01-06 00:00:00 | Jan-11 | 2 | Company 10 | Product 1 | 1 | Binding Compliance
[NAME] | Agent W | [NAME] | In Office | 2011-02-18 00:00:00 | Feb-11 | 3 | Company 10 | Product 2 | 1 | Disclosure Compliance
[NAME] | Agent X | [NAME] | In Office | 2011-02-23 00:00:00 | Feb-11 | 4 | Company 11 | Product 2 | 1 | Rating Compliance
[NAME] | Agent W | [NAME] | In Office | 2011-02-21 00:00:00 | Feb-11 | 5 | Company 10 | Product 2 | 1 | Rating Compliance
[NAME] | Agent W | [NAME] | In Office | 2011-02-22 00:00:00 | Feb-11 | 5 | Company 1 | Product 1 | 1 | Third Party Compliance
[NAME] | Agent R | [NAME] | In Office | 2011-02-10 00:00:00 | Feb-11 | 6 | Company 1 | Product 1 | 2 | Coverage Compliance
[NAME] | Agent R | [NAME] | In Office | 2011-02-11 00:00:00 | Feb-11 | 6 | Company 1 | Product 1 | 2 | Date Compliance
[NAME] | Agent H | [NAME] | In Office | 2011-01-17 00:00:00 | Jan-11 | 7 | Company 1 | Product 1 | 1 | Rating Compliance
[NAME] | Agent I | [NAME] | In Office | 2011-01-18 00:00:00 | Jan-11 | 7 | Company 10 | Product 3 | 2 | Coverage Compliance
[NAME] | Agent D | [NAME] | In Office | 2011-01-10 00:00:00 | Jan-11 | 8 | Company 11 | Product 2 | 2 | Exception Compliance
[NAME] | Agent D | [NAME] | In Office | 2011-01-11 00:00:00 | Jan-11 | 8 | Company 11 | Product 2 | 2 | Exception Compliance
[NAME] | Agent E | [NAME] | In Office | 2011-01-12 00:00:00 | Jan-11 | 8 | Company 11 | Product 2 | 2 | LOB Compliance
[NAME] | Agent F | [NAME] | In Office | 2011-01-13 00:00:00 | Jan-11 | 8 | Company 10 | Product 2 | 1 | Rating Compliance
[NAME] | Agent L | [NAME] | In Office | 2011-01-26 00:00:00 | Jan-11 | 9 | Company 10 | Product 1 | 1 | Binding Compliance
[NAME] | Agent C | [NAME] | In Office | 2011-01-07 00:00:00 | Jan-11 | 10 | Company 10 | Product 2 | 1 | Rating Compliance
[NAME] | Agent N | [NAME] | In Office | 2011-02-03 00:00:00 | Feb-11 | 11 | Company 10 | Product 2 | 1 | Binding Compliance
[NAME] | Agent O | [NAME] | In Office | 2011-02-07 00:00:00 | Feb-11 | 12 | Company 10 | Product 2 | 3 | File Information Compliance
[NAME] | Agent J | [NAME] | In Office | 2011-01-21 00:00:00 | Jan-11 | 13 | Company 12 | Product 1 | 2 | Date Compliance
[NAME] | Agent B | [NAME] | In Office | 2011-03-04 00:00:00 | Mar-11 | 14 | Company 12 | Product 1 | 2 | Date Compliance
[NAME] | Agent S | [NAME] | In Office | 2011-02-14 00:00:00 | Feb-11 | 15 | Company 12 | Product 1 | 2 | Coverage Compliance
[NAME] | Agent T | [NAME] | In Office | 2011-02-15 00:00:00 | Feb-11 | 15 | Company 10 | Product 1 | 2 | Claims Compliance
[NAME] | Agent U | [NAME] | In Office | 2011-02-16 00:00:00 | Feb-11 | 15 | Company 8 | Product 1 | 1 | Rating Compliance
[NAME] | Agent V | [NAME] | In Office | 2011-02-17 00:00:00 | Feb-11 | 15 | Company 6 | Product 2 | 1 | Binding Compliance
[NAME] | Agent D | [NAME] | In Office | 2011-03-10 00:00:00 | Mar-11 | 16 | Company 2 | Product 1 | 1 | Rating Compliance
[NAME] | Agent E | [NAME] | In Office | 2011-03-11 00:00:00 | Mar-11 | 16 | Company 11 | Product 2 | 2 | Date Compliance
[NAME] | Agent A | [NAME] | In Office | 2011-01-03 00:00:00 | Jan-11 | 17 | Company 9 | Product 1 | 1 | Binding Compliance
[NAME] | Agent A | [NAME] | In Office | 2011-01-04 00:00:00 | Jan-11 | 17 | Company 11 | Product 2 | 1 | Script Compliance
[NAME] | Agent C | [NAME] | In Office | 2011-03-07 00:00:00 | Mar-11 | 18 | Company 8 | Product 1 | 1 | Binding Compliance
[NAME] | Agent C | [NAME] | In Office | 2011-03-08 00:00:00 | Mar-11 | 18 | Company 8 | Product 1 | 1 | Rating Compliance
[NAME] | Agent O | [NAME] | In Office | 2011-02-04 00:00:00 | Feb-11 | 19 | Company 3 | Product 1 | 1 | Rating Compliance
[NAME] | Agent M | [NAME] | In Office | 2011-02-01 00:00:00 | Feb-11 | 20 | Company 3 | Product 1 | 2 | Phone Number Compliance
[NAME] | Agent L | [NAME] | In Office | 2011-01-27 00:00:00 | Jan-11 | 21 | Company 3 | Product 1 | 1 | Rating Compliance
[NAME] | Agent M | [NAME] | In Office | 2011-01-28 00:00:00 | Jan-11 | 21 | Company 3 | Product 1 | 1 | Rating Compliance
[NAME] | Agent M | [NAME] | In Office | 2011-01-31 00:00:00 | Jan-11 | 21 | Company 10 | Product 1 | 1 | Script Compliance
[NAME] | Agent M | [NAME] | In Office | 2011-02-02 00:00:00 | Feb-11 | 22 | Company 7 | Product 1 | 3 | File Information Compliance
[NAME] | Agent X | [NAME] | In Office | 2011-02-24 00:00:00 | Feb-11 | 23 | Company 7 | Product 1 | 2 | Exception Compliance
[NAME] | Agent Y | [NAME] | In Office | 2011-02-25 00:00:00 | Feb-11 | 23 | Company 9 | Product 1 | 1 | Binding Compliance
[NAME] | Agent Z | [NAME] | In Office | 2011-02-28 00:00:00 | Feb-11 | 23 | Company 4 | Product 1 | 1 | Rating Compliance
[NAME] | Agent Z | [NAME] | In Office | 2011-03-01 00:00:00 | Mar-11 | 23 | Company 4 | Product 1 | 2 | Exception Compliance
[NAME] | Agent J | [NAME] | In Office | 2011-01-19 00:00:00 | Jan-11 | 24 | Company 4 | Product 1 | 1 | Binding Compliance
[NAME] | Agent G | [NAME] | In Office | 2011-01-14 00:00:00 | Jan-11 | 25 | Company 4 | Product 1 | 2 | LOB Compliance
[NAME] | Agent A | [NAME] | In Office | 2011-03-02 00:00:00 | Mar-11 | 26 | Company 6 | Product 4 | 1 | Binding Compliance
[NAME] | Agent A | [NAME] | In Office | 2011-03-03 00:00:00 | Mar-11 | 26 | Company 6 | Product 4 | 1 | Rating Compliance
[NAME] | Agent Q | [NAME] | In Office | 2011-02-09 00:00:00 | Feb-11 | 27 | Company 5 | Product 1 | 1 | Payment Compliance
[NAME] | Agent B | [NAME] | In Office | 2011-01-05 00:00:00 | Jan-11 | 28 | Company 4 | Product 1 | 1 | Error Compliance
[NAME] | Agent P | [NAME] | In Office | 2011-02-08 00:00:00 | Feb-11 | 29 | Company 4 | Product 1 | 2 | Date Compliance
[NAME] | Agent J | [NAME] | In Office | 2011-01-20 00:00:00 | Jan-11 | 30 | Company 11 | Product 2 | 1 | Rating Compliance
[NAME] | Agent J | [NAME] | In Office | 2011-01-24 00:00:00 | Jan-11 | 31 | Company 8 | Product 1 | 2 | Script Compliance
[NAME] | Agent K | [NAME] | In Office | 2011-01-25 00:00:00 | Jan-11 | 31 | Company 8 | Product 1 | 1 | Qualification Compliance