Spreadsheet: 136713d1326802894-extracting-data-from-master-sheet-into-sub-sheets-and-automatic-updating-sample-data
Sheet: NPGLDT

Agent | [NAME] | Site Name | Start Date | [NAME] | Secondary Status | Objection Count | Return Reason | Fuel | Input Date | Term | Signed Date | Return Comments | Return Date | Re-Sub Date | Agent Name | [NAME] D0055 | COT? | Rejection Date | [NAME] | Objection Date
AR | 3982783701 | Fam Pizza | 2011-12-22 00:00:00 | Guaranteed | Live | 0 |  | G | 2011-11-22 00:00:00 | 36 | 2011-11-22 00:00:00
AR | 2000011121710 | Fam Pizza | 2012-01-15 00:00:00 | Objection In Progress | Objection Received | 3 |  | P | 2011-11-22 00:00:00 | 36 | 2011-11-22 00:00:00 |  |  |  | Mo | 2012-01-03 16:13:20 | F |  | 2012-01-05 00:39:28 | 2012-01-06 00:40:43
AR | 4008344005 | The Grill |  | Processing | Extracted But Not Loaded |  |  | G | 2012-01-06 00:00:00 | 36 | 2012-01-06 00:00:00
AR | 1012412684856 | Supper Market |  | [NAME] | [NAME] |  | VR -  Referral Fail | P | 2012-01-06 00:00:00 | 12 | 2012-01-06 00:00:00 | confirmed not on | 2012-01-10 00:00:00
AR | 1012458517876 | Original LTD | 2012-02-06 00:00:00 | Requested | Requested | 0 |  | P | 2012-01-06 00:00:00 | 36 | 2012-01-06 00:00:00 |  |  |  | Mo | 2012-01-10 16:07:54 | F
BJ | 1460001426013 | Meats Ltd | 2011-08-03 00:00:00 | Guaranteed | Live | 3 |  | P | 2011-05-06 00:00:00 | 12 | 2011-05-06 00:00:00 |  |  |  | Mo | 2011-07-27 09:58:51 | F |  | 2011-07-27 22:23:12
DF | 2241572701 | Tandoori Master | 2011-09-13 00:00:00 | Guaranteed | Live | 1 |  | G | 2011-07-13 00:00:00 | 36 | 2011-07-13 00:00:00 |  | 2011-07-14 00:00:00
DF | 3368119800 | Ghalibs |  | Return (Closed) | Return |  | DR - Duplicate Introducer | G | 2011-07-13 00:00:00 | 36 | 2011-07-13 00:00:00 |  | 2011-07-18 00:00:00
DF | 4014904609 | Passage | 2011-12-14 00:00:00 | Objection Closed | Unsuccessful | 1 |  | G | 2011-07-13 00:00:00 | 36 | 2011-07-13 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-23 00:00:00
EU | 3307955110 | [NAME] |  | Return (Closed) | (Failed Load Validation) |  | DR -  diff [NAME] | G | 2011-07-13 00:00:00 | 36 | 2011-07-13 00:00:00 |  | 2011-07-13 00:00:00
GMS | 2550245304 | Bakers | 2011-07-20 00:00:00 | Guaranteed | Live | 0 |  | G | 2011-06-21 00:00:00 | 36 | 2011-06-21 00:00:00
GT | 9112379800 | of lahore |  | Return (Closed) | Return |  | Unit [NAME] | G | 2011-01-06 00:00:00 | 24 | 2011-01-06 00:00:00 | advise | 2011-01-07 00:00:00
GT | 9158367601 | Southern | 2011-04-12 00:00:00 | Objection Closed | Registration Unsuccessful | 5 |  | G | 2011-01-06 00:00:00 | 24 | 2011-01-06 00:00:00 |  |  |  |  |  |  |  |  | 2011-03-23 00:00:00
GT | 1012957975986 | Anjuman |  | Failed | [NAME] |  | VR - Referral Fail;VR - Failed CC Referral Fail | P | 2011-02-28 00:00:00 | 24 | 2011-02-28 00:00:00 |  | 2011-03-02 00:00:00
EU | 3307955110 | [NAME] |  | Return (Closed) | Return (Failed Load Validation) |  | DR -  diff [NAME] | G | 2011-07-13 00:00:00 | 36 | 2011-07-13 00:00:00 |  | 2011-07-13 00:00:00
GMS | 2550245304 | [NAME] | 2011-07-20 00:00:00 | Guaranteed | Live | 0 |  | G | 2011-06-21 00:00:00 | 36 | 2011-06-21 00:00:00
GT | 2000013021993 | Wycombe Mission | 2012-01-15 00:00:00 | In Progress | Objection Upheld | 1 |  | P | 2011-12-15 00:00:00 | 36 | 2011-12-15 00:00:00 |  |  |  | Mo | 2011-12-19 10:37:46 | F |  | 2011-12-20 00:41:06 | 2011-12-21 00:46:43
GT | 2000013126924 | Wycombe  Mission | 2012-01-15 00:00:00 | Guaranteed | Live - Awaiting | 0 |  | P | 2011-12-15 00:00:00 | 36 | 2011-12-15 00:00:00 |  |  |  | Mo | 2011-12-20 11:03:25 | F |  | 2011-12-21 00:47:55
GT | 2000013188559 | Wycombe Mission Ltd | 2012-01-15 00:00:00 | In Progress | Objection Upheld | 1 |  | P | 2011-12-15 00:00:00 | 36 | 2011-12-15 00:00:00 |  |  |  | Mo | 2011-12-19 10:37:47 | F |  | 2011-12-20 00:41:07 | 2011-12-22 00:38:42
GT | 2000013188577 | Wycomb Mission Ltd | 2012-01-15 00:00:00 | Guaranteed | Live - | 0 |  | P | 2011-12-15 00:00:00 | 36 | 2011-12-15 00:00:00 |  |  |  | Mo | 2011-12-19 10:37:47 | F |  | 2011-12-20 00:41:08
K&K | 2000002155875 | Chicken Ranch | 2011-03-31 00:00:00 | Closed | Objection - Previous | 4 |  | P | 2011-01-04 00:00:00 | 12 | 2011-01-04 00:00:00 |  |  |  | Mo
K&K | 2000027602261 | Chicken Ranch | 2011-03-28 00:00:00 | Guaranteed | Live | 2 |  | P | 2011-01-04 00:00:00 | 12 | 2011-01-04 00:00:00 |  |  |  | Mo | 2011-03-09 16:11:14 | F |  | 2011-03-11 00:49:48
K&K | 1200023698491 | Aryubi Express |  | Return | Return |  | VR - DD  Incorrect | P | 2011-01-11 00:00:00 | 24 | 2011-01-11 00:00:00 | not variable | 2011-01-12 00:00:00
K&K | 2000001834656 | Angel  Shopping Centre | 2011-04-07 00:00:00 | Objection | Objection - Previous | 4 |  | P | 2011-01-11 00:00:00 | 24 | 2011-01-11 00:00:00 |  |  |  | Mo
K&K | 1012458113306 | [NAME] | 2011-06-19 00:00:00 | Registration Guaranteed | Live (Set up In Beryl) | 0 |  | Power | 2011-05-18 00:00:00 | 36 | 2011-05-18 00:00:00 |  |  |  | [NAME] | 2011-05-22 16:07:52 | F |  | 2011-05-24 02:43:30
K&K | 3290978303 | Samsel Enterprises Ltd |  | Failed Credit Check | [NAME] |  | VR - Failed Credit Check Outright Fail;VR - Failed Credit Check Outright Fail;VR - Failed Credit Check Outright Fail | Gas | 2011-05-20 00:00:00 | 36 | 2011-05-20 00:00:00 |  | 2011-05-24 00:00:00
K&K | 1012398350100 | Pizza Inn | 2011-06-21 00:00:00 | Registration Guaranteed | Live (Set up In Beryl) | 0 |  | Power | 2011-05-20 00:00:00 | 36 | 2011-05-20 00:00:00 |  |  |  | [NAME] | 2011-05-24 16:10:13 | F |  | 2011-05-25 23:20:55