Spreadsheet: 46455d1245320050-extracting-data-from-table-agents
Sheet: Sheet2

 | 2009-06-18 00:00:00
 |  |  | Agent | Date Started / Date of Last Annual Appraisal | 3 Month | 6 Month | Annual | Date of Next Apprisal | Due this Month | HELPER COLUMN CAN BE HIDDEN
 |  |  | Agent 1 | 2009-04-22 00:00:00 | N/A | N/A | 2010-04-22 00:00:00 | 2010-04-22 00:00:00
 |  |  | Agent 2 | 2009-02-07 00:00:00 | Done | N/A | 2010-02-07 00:00:00 | 2010-02-07 00:00:00
 |  |  | Agent 3 | 2008-12-15 00:00:00 | N/A | N/A | 2009-12-15 00:00:00 | 2009-12-15 00:00:00
 |  |  | Agent 4 | 2009-01-21 00:00:00 | N/A | N/A | 2010-01-21 00:00:00 | 2010-01-21 00:00:00
 |  |  | Agent 5 | 2009-02-04 00:00:00 | Done | N/A | 2010-02-04 00:00:00 | 2010-02-04 00:00:00
 |  |  | Agent 6 | 2009-06-07 00:00:00 | 2009-09-07 00:00:00 | 2009-12-07 00:00:00 | 2010-06-07 00:00:00 | 2009-09-07 00:00:00
 |  |  | Agent 7 | 2008-03-07 00:00:00 | N/A | N/A | 2009-03-07 00:00:00 | 2009-03-07 00:00:00
 |  |  | Agent 8 | 2009-06-12 00:00:00 | 2009-09-12 00:00:00 | 2009-12-12 00:00:00 | 2010-06-12 00:00:00 | 2009-09-12 00:00:00
 |  |  | Agent 9 | 2009-06-01 00:00:00 | 2009-09-01 00:00:00 | 2009-12-01 00:00:00 | 2010-06-01 00:00:00 | 2009-09-01 00:00:00
 |  |  | Agent 10 | 2008-11-01 00:00:00 | Done | Done | 2009-11-01 00:00:00 | 2009-11-01 00:00:00
 |  |  | Agent 11 | 2009-05-04 00:00:00 | Done | N/A | 2010-05-04 00:00:00 | 2010-05-04 00:00:00
 |  |  | Agent 12 | 2009-05-17 00:00:00 | 2009-08-17 00:00:00 | 2009-11-17 00:00:00 | 2010-05-17 00:00:00 | 2009-08-17 00:00:00
 |  |  | Agent 13 | 2009-06-11 00:00:00 | N/A | N/A | 2010-06-11 00:00:00 | 2010-06-11 00:00:00
 |  |  | Agent 14 | 2008-08-24 00:00:00 | N/A | N/A | 2009-08-24 00:00:00 | 2009-08-24 00:00:00
 |  |  | Agent 15 | 2009-02-25 00:00:00 | N/A | N/A | 2010-02-25 00:00:00 | 2010-02-25 00:00:00
 |  |  | Agent 16 | 2008-10-02 00:00:00 | N/A | Done | 2009-10-02 00:00:00 | 2009-10-02 00:00:00
 |  |  | Agent 17 | 2009-06-04 00:00:00 | N/A | Done | 2010-06-04 00:00:00 | 2010-06-04 00:00:00
 |  |  | Agent 18 | 2008-10-18 00:00:00 | N/A | N/A | 2009-10-18 00:00:00 | 2009-10-18 00:00:00
 |  |  | Agent 19 | 2009-05-13 00:00:00 | Done | N/A | 2010-05-13 00:00:00 | 2010-05-13 00:00:00
 |  |  | Agent 20 | 2008-11-19 00:00:00 | N/A | N/A | 2009-11-19 00:00:00 | 2009-11-19 00:00:00
 |  |  | Agent 21 | 2009-04-15 00:00:00 | N/A | N/A | 2010-04-15 00:00:00 | 2010-04-15 00:00:00
 |  |  | Agent 22 | 2008-08-15 00:00:00 | N/A | Done | 2009-08-15 00:00:00 | 2009-08-15 00:00:00
 |  |  | Agent 23 | 2009-02-01 00:00:00 | Done | N/A | 2010-02-01 00:00:00 | 2010-02-01 00:00:00
 |  |  | Agent 24 | 2007-06-17 00:00:00 | Done | Done | 2008-06-17 00:00:00 | 2008-06-17 00:00:00
 |  |  | Agent 25 | 2009-01-10 00:00:00 | N/A | N/A | 2010-01-10 00:00:00 | 2010-01-10 00:00:00
 |  |  | Agent 26 | 2009-05-26 00:00:00 | N/A | N/A | 2010-05-26 00:00:00 | 2010-05-26 00:00:00
 |  |  | Agent 27 | 2008-10-08 00:00:00 | N/A | done | 2009-10-08 00:00:00 | 2009-10-08 00:00:00
 |  |  | Agent 28 | 2009-02-09 00:00:00 | Done | Done | 2010-02-09 00:00:00 | 2010-02-09 00:00:00
 |  |  | Agent 29 | 2009-06-18 00:00:00 | Done | Done | 2010-06-18 00:00:00 | 2010-06-18 00:00:00
 |  |  | Agent 30 | 2008-09-13 00:00:00 | N/A | N/A | 2009-09-13 00:00:00 | 2009-09-13 00:00:00
 |  |  | Agent 31 | 2009-05-20 00:00:00 | 2009-08-20 00:00:00 | 2009-11-20 00:00:00 | 2010-05-20 00:00:00 | 2009-08-20 00:00:00
 |  |  | Agent 32 | 2009-01-09 00:00:00 | 2009-04-09 00:00:00 | 2009-07-09 00:00:00 | 2010-01-09 00:00:00 | 2009-04-09 00:00:00
 |  |  | Agent 33 | 2007-04-14 00:00:00 | N/A | N/A | 2008-04-14 00:00:00 | 2008-04-14 00:00:00
 |  |  | Agent 34 | 2009-04-12 00:00:00 | N/A | Done | 2010-04-12 00:00:00 | 2010-04-12 00:00:00
 |  |  | Agent 35 | 2008-10-02 00:00:00 | N/A | Done | 2009-10-02 00:00:00 | 2009-10-02 00:00:00
 |  |  | Agent 36 | 2008-09-03 00:00:00 | N/A | N/A | 2009-09-03 00:00:00 | 2009-09-03 00:00:00
 |  |  | Agent 37 | 2008-06-28 00:00:00 | Done | Done | 2009-06-28 00:00:00 | 2009-06-28 00:00:00 | DUE | 1
 |  |  | Agent 38 | 2009-02-18 00:00:00 | Done | Done | 2010-02-18 00:00:00 | 2010-02-18 00:00:00
 |  |  | Agent 39 | 2009-01-06 00:00:00 | Done | 2009-07-06 00:00:00 | 2010-01-06 00:00:00 | 2009-07-06 00:00:00
 |  |  | Agent 40 | 2009-03-10 00:00:00 | Done | Done | 2010-03-10 00:00:00 | 2010-03-10 00:00:00
 |  |  | Agent 41 | 2009-05-04 00:00:00 | N/A | N/A | 2010-05-04 00:00:00 | 2010-05-04 00:00:00
 |  |  | Agent 42 | 2008-07-22 00:00:00 | N/A | N/A | 2009-07-22 00:00:00 | 2009-07-22 00:00:00
 |  |  | Agent 43 | 2009-01-10 00:00:00 | N/A | Done | 2010-01-10 00:00:00 | 2010-01-10 00:00:00
 |  |  | Agent 44 | 2007-02-23 00:00:00 | Done | Done | 2008-02-23 00:00:00 | 2008-02-23 00:00:00
 |  |  | Agent 45 | 2008-09-29 00:00:00 | N/A | N/A | [NAME] | 1900-01-01 00:00:00
 |  |  | Agent 46 | 2007-12-10 00:00:00 | N/A | N/A | Sick | 1900-01-01 00:00:00
 |  |  | Agent 47 | 2009-02-02 00:00:00 | Done | 2009-08-02 00:00:00 | 2010-02-02 00:00:00 | 2009-08-02 00:00:00
 |  |  | Agent 48 | 2008-11-09 00:00:00 | N/A | N/A | 2009-11-09 00:00:00 | 2009-11-09 00:00:00
 |  |  | Agent 49 | 2008-07-17 00:00:00 | N/a | done | 2009-07-17 00:00:00 | 2009-07-17 00:00:00
 |  |  | Agent 50 | 2009-05-28 00:00:00 | 2009-08-28 00:00:00 | 2009-11-28 00:00:00 | 2010-05-28 00:00:00 | 2009-08-28 00:00:00
 |  |  | Agent 51 | 2008-10-28 00:00:00 | Done | Done | 2009-10-28 00:00:00 | 2009-10-28 00:00:00
 |  |  | Agent 52 | 2009-01-30 00:00:00 | 2009-04-30 00:00:00 | 2009-07-30 00:00:00 | 2010-01-30 00:00:00 | 2009-04-30 00:00:00
 |  |  | Agent 53 | 2008-10-04 00:00:00 | N/A | 2009-04-04 00:00:00 | 2009-10-04 00:00:00 | 2009-04-04 00:00:00
 |  |  | Agent 54 | 2009-05-29 00:00:00 | N/A | N/A | 2010-05-29 00:00:00 | 2010-05-29 00:00:00
 |  |  | Agent 55 | 2008-10-08 00:00:00 | N/A | N/A | 2009-10-08 00:00:00 | 2009-10-08 00:00:00
 |  |  | Agent 56 | 2008-07-11 00:00:00 | n/a | Done | 2009-07-11 00:00:00 | 2009-07-11 00:00:00
 |  |  | Agent 57 | 2008-07-28 00:00:00 | Done | Done | 2009-07-28 00:00:00 | 2009-07-28 00:00:00
 |  |  | Agent 58 | 2009-02-12 00:00:00 | Done | Done | 2010-02-12 00:00:00 | 2010-02-12 00:00:00
 |  |  | Agent 59 | 2009-04-20 00:00:00 | 2009-07-20 00:00:00 | 2009-10-20 00:00:00 | 2010-04-20 00:00:00 | 2009-07-20 00:00:00
 |  |  | Agent 60 | 2009-04-19 00:00:00 | Done | Done | 2010-04-19 00:00:00 | 2010-04-19 00:00:00
 |  |  | Agent 61 | 2009-11-27 00:00:00 | N/A | 2010-05-27 00:00:00 | 2010-11-27 00:00:00 | 2010-05-27 00:00:00
 |  |  | Agent 62 | 2009-06-04 00:00:00 | 2009-09-04 00:00:00 | 2009-12-04 00:00:00 | 2010-06-04 00:00:00 | 2009-09-04 00:00:00
 |  |  | Agent 63 | 2008-12-15 00:00:00 | Done | Done | 2009-12-15 00:00:00 | 2009-12-15 00:00:00
 |  |  | Agent 64 | 2008-04-23 00:00:00 | N/A | N/A | 2009-04-23 00:00:00 | 2009-04-23 00:00:00
 |  |  | Agent 65 | 2008-01-27 00:00:00 | N/A | Done | 2009-01-27 00:00:00 | 2009-01-27 00:00:00
 |  |  | Agent 66 | 2008-07-24 00:00:00 | N/A | N/A | 2009-07-24 00:00:00 | 2009-07-24 00:00:00
 |  |  | Agent 67 | 2008-09-11 00:00:00 | N/A | Done | 2009-09-11 00:00:00 | 2009-09-11 00:00:00
 |  |  | Agent 68 | 2007-11-30 00:00:00 | N/A | Done | 2008-11-30 00:00:00 | 2008-11-30 00:00:00
 |  |  | Agent 69 | 2009-05-28 00:00:00 | 2009-08-28 00:00:00 | 2009-11-28 00:00:00 | 2010-05-28 00:00:00 | 2009-08-28 00:00:00
 |  |  | Agent 70 | 2007-04-15 00:00:00 | N/A | Done | 2008-04-15 00:00:00 | 2008-04-15 00:00:00
 |  |  | Agent 71 | 2008-09-07 00:00:00 | N/A | Done | 2009-09-07 00:00:00 | 2009-09-07 00:00:00
 |  |  | Agent 72 | 2008-08-25 00:00:00 | Done | Done | 2009-08-25 00:00:00 | 2009-08-25 00:00:00
 |  |  | Agent 73 | 2009-02-16 00:00:00 | N/A | N/A | 2010-02-16 00:00:00 | 2010-02-16 00:00:00
 |  |  | Agent 74 | 2008-12-14 00:00:00 | Done | Done | 2009-12-14 00:00:00 | 2009-12-14 00:00:00
 |  |  | Agent 75 | 2009-04-15 00:00:00 | N/A | N/A | 2010-04-15 00:00:00 | 2010-04-15 00:00:00
 |  |  | Agent 76 | 2009-06-05 00:00:00 | 2009-09-05 00:00:00 | 2009-12-05 00:00:00 | 2010-06-05 00:00:00 | 2009-09-05 00:00:00
 |  |  | Agent 77 | 2008-11-21 00:00:00 | N/A | SICK | 2009-11-21 00:00:00 | 2009-11-21 00:00:00
 |  |  | Agent 78 | 2008-11-27 00:00:00 | N/A | 2009-05-27 00:00:00 | 2009-11-27 00:00:00 | 2009-05-27 00:00:00
 |  |  | Agent 79 | 2008-06-13 00:00:00 | N/A | N/A | 2009-06-13 00:00:00 | 2009-06-13 00:00:00 | DUE | 2
 |  |  | Agent 80 | 2008-01-10 00:00:00 | N/A | N/A | 2009-01-10 00:00:00 | 2009-01-10 00:00:00
 |  |  | Agent 81 | 2009-03-20 00:00:00 | Done | Done | 2010-03-20 00:00:00 | 2010-03-20 00:00:00
 |  |  | Agent 82 | 2008-05-03 00:00:00 | Done | N/A | 2009-05-03 00:00:00 | 2009-05-03 00:00:00
 |  |  | Agent 83 | 2009-03-15 00:00:00 | N/A | N/A | 2010-03-15 00:00:00 | 2010-03-15 00:00:00
 |  |  | Agent 84 | 2008-09-08 00:00:00 | N/A | Done | 2009-09-08 00:00:00 | 2009-09-08 00:00:00
 |  |  | Agent 85 | 2008-08-04 00:00:00 | Done | Done | 2009-08-04 00:00:00 | 2009-08-04 00:00:00
 |  |  | Agent 86 | 2009-03-09 00:00:00 | Done | Done | 2010-03-09 00:00:00 | 2010-03-09 00:00:00
 |  |  | Agent 87 | 2009-03-15 00:00:00 | N/A | N/A | 2010-03-15 00:00:00 | 2010-03-15 00:00:00
 |  |  | Agent 88 | 2009-03-23 00:00:00 | N/A | N/A | 2010-03-23 00:00:00 | 2010-03-23 00:00:00
 |  |  | Agent 89 | 2009-05-09 00:00:00 | 2009-06-23 00:00:00 | 2009-11-09 00:00:00 | 2010-05-09 00:00:00 | 2009-06-23 00:00:00 | DUE | 3
 |  |  | Agent 90 | 2009-06-13 00:00:00 | 2009-09-13 00:00:00 | 2009-12-13 00:00:00 | 2010-06-13 00:00:00 | 2009-09-13 00:00:00
 |  |  | Agent 91 | 2009-02-06 00:00:00 | Done | N/A | 2010-02-06 00:00:00 | 2010-02-06 00:00:00
 |  |  | Agent 92 | 2009-05-01 00:00:00 | N/A | N/A | 2010-05-01 00:00:00 | 2010-05-01 00:00:00
 |  |  | Agent 93 | 2008-11-29 00:00:00 | N/A | N/A | 2009-11-29 00:00:00 | 2009-11-29 00:00:00
 |  |  | Agent 94 | 2008-10-07 00:00:00 | Done | Done | 2009-10-07 00:00:00 | 2009-10-07 00:00:00
 |  |  | Agent 95 | 2008-10-04 00:00:00 | Done | Done | 2009-10-04 00:00:00 | 2009-10-04 00:00:00
 |  |  | Agent 96 | 2008-11-29 00:00:00 | Done | Done | 2009-11-29 00:00:00 | 2009-11-29 00:00:00
 |  |  | Agent 97 | 2008-09-16 00:00:00 | Done | Done | 2009-09-16 00:00:00 | 2009-09-16 00:00:00
 |  |  | Agent 98 | 2008-09-16 00:00:00 | N/A | Done | 2009-09-16 00:00:00 | 2009-09-16 00:00:00
 |  |  | Agent 99 | 2009-02-19 00:00:00 | N/A | Done | 2010-02-19 00:00:00 | 2010-02-19 00:00:00
 |  |  | Agent 100 | 2009-06-04 00:00:00 | 2009-09-04 00:00:00 | 2009-12-04 00:00:00 | 2010-06-04 00:00:00 | 2009-09-04 00:00:00
 |  |  | Agent 101 | 2008-06-13 00:00:00 | Done | Done | 2009-06-13 00:00:00 | 2009-06-13 00:00:00 | DUE | 4
 |  |  | Agent 102 | 2009-01-30 00:00:00 | N/A | N/A | 2010-01-30 00:00:00 | 2010-01-30 00:00:00
 |  |  | Agent 103 | 2009-07-26 00:00:00 | Done | Done | 2010-07-26 00:00:00 | 2010-07-26 00:00:00
 |  |  | Agent 104 | 2008-01-31 00:00:00 | Done | Done | 2009-01-31 00:00:00 | 2009-01-31 00:00:00
 |  |  | Agent 105 | 2007-12-18 00:00:00 | Done | Done | 2008-12-18 00:00:00 | 2008-12-18 00:00:00
 |  |  | Agent 106 | 2008-10-24 00:00:00 | N/A | done | 2009-10-24 00:00:00 | 2009-10-24 00:00:00
 |  |  | Agent 107 | 2009-05-13 00:00:00 | 2009-08-13 00:00:00 | 2009-11-13 00:00:00 | 2010-05-13 00:00:00 | 2009-08-13 00:00:00
 |  |  | Agent 108 | 2008-11-22 00:00:00 | N/A | N/A | 2009-11-22 00:00:00 | 2009-11-22 00:00:00
 |  |  | Agent 109 | 2008-07-15 00:00:00 | Done | Done | 2009-07-15 00:00:00 | 2009-07-15 00:00:00
 |  |  | Agent 110 | 2009-03-05 00:00:00 | N/A | N/A | 2010-03-05 00:00:00 | 2010-03-05 00:00:00
 |  |  | Agent 111 | 2009-06-11 00:00:00 | 2009-09-11 00:00:00 | 2009-12-11 00:00:00 | 2010-06-11 00:00:00 | 2009-09-11 00:00:00
 |  |  | Agent 112 | 2008-09-06 00:00:00 | N/A | 2009-03-06 00:00:00 | 2009-09-06 00:00:00 | 2009-03-06 00:00:00
 |  |  | Agent 113 | 2009-08-30 00:00:00 | N/A | 2010-03-02 00:00:00 | 2010-08-30 00:00:00 | 2010-03-02 00:00:00
 |  |  | Agent 114 | 2007-07-22 00:00:00 | N/A | Done | 2008-07-22 00:00:00 | 2008-07-22 00:00:00
 |  |  | Agent 115 | 2007-10-18 00:00:00 | Done | Done | On [NAME] | 1900-01-01 00:00:00
 |  |  | Agent 116 | 2008-10-19 00:00:00 | N/A | Done | 2009-10-19 00:00:00 | 2009-10-19 00:00:00
 |  |  | Agent 117 | 2009-05-10 00:00:00 | 2009-08-10 00:00:00 | 2009-11-10 00:00:00 | 2010-05-10 00:00:00 | 2009-08-10 00:00:00
 |  |  | Agent 118 | 2008-09-19 00:00:00 | N/A | Done | 2009-09-19 00:00:00 | 2009-09-19 00:00:00
 |  |  | Agent 119 | 2007-02-20 00:00:00 | Done | N/A | 2008-02-20 00:00:00 | 2008-02-20 00:00:00
 |  |  | Agent 120 | 2009-05-22 00:00:00 | N/A | N/A | 2010-05-22 00:00:00 | 2010-05-22 00:00:00
 |  |  |  | Number Outstandning= | 2 | 3 | 16
 |  |  |  |  | Total Outstanding Apprisals = | 21