Spreadsheet: 294463d1391395784-extracting-data-from-large-spreadsheet-mock-spreadsheet-and-data-needs-for-gloria
Sheet: Mock Spreadsheet

Completed | Protocol | Product/Project Code | Ship Facility | PI | Cooperator LName | Cooperator FName | Title #1 | Company | Shipping Contact | Shipping Address Line 1 | Shipping Address Line 2 | City | State | Zip | Phone Number | Cell Number/ Fax | E-Mail | Product 1 | Quantity 1 | Container Size 1 | Product 2 | Quantity 2 | Container [NAME] | Product 3 | Quantity 3 | Container Size 3 | Product 4 | Quantity 4 | Container [NAME] | Product 5 | Quantity 5 | Container Size 5 | Product 6 | Quantity 6 | Container [NAME] 6 | Product 7 | Quantity 7 | Container Size 7 | Product 8 | Quantity 8 | Container [NAME] 8 | Product 9 | Quantity 9 | Container [NAME] 9 | Date Requested | Delivery Deadline | Tracking Number 1 | Date Shipped 1 | Tracking Number | Date Received 2 | Date Received | Payment Amount | Payment Deadline | Funding Source | Date Requested | Payment Issued | Check  Number | Payment Received | Payee | Check Attention | Payment Address Line 1 | Payment Address Line 2 | Payment Address Line 2 | City | State | Zip Code | Instructions
√ | None | SMP | GRTOWN | HJ | Flame | [NAME] |  | Happy Farms | [NAME] | Hwy 49 South |  | Madrid | GA | 20136 | 909-2295-2429 |  |  | Apple Juice | 6 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) | Apple Juice | 6 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) | Cream Cheese | 12 | cases (10 x 6 oz/case) | Half n Half | 6 | case (12 x .5 gal/case) | Eggs | 6 | case (12 x 1 doz/case) | Yogurt | 4 | case (6 x 36 oz/case0 | Pudding Cups | 12 | cases (12 x 3 oz/case) | 2013-01-08 00:00:00 | 2013-01-14 00:00:00 | 1Z9824628506 | 2013-01-09 00:00:00 |  |  | 10-January-2013 / 10:18 AM | 12500 | 2013-06-01 00:00:00 | SAC | 2013-05-15 00:00:00 | NA | NA | NA | Happy Farms | [NAME] | Hwy 49 South | [NAME] 14 |  | Madrid | GA | 20136 | NA
√ | None | SMP | GRTOWN | HJ | [NAME] | [NAME] | Mr. | Salem Field | [NAME] | 21 LINCOLN DRIVE | P.O. BOX 10 | HAMPTON | GA | 48997 | [PHONE] | [PHONE] | [NAME] | DEODORANT | 2 | cases (24 x 1.5 oz) | DEODORANT | 2 | cases (24 x 1.5 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | Shaving Cream | 10 | cases (6 x 10 oz/case) | [NAME] | 12 | case (12 x 4 box/case) |  |  |  |  |  |  | 2013-01-12 00:00:00 | 2013-01-15 00:00:00 | 1Z1214899400251 | 2013-01-16 00:00:00 |  |  | 08-February-2013 / 3:06 PM | 20529 | 2013-07-01 00:00:00 | SAC | 2013-05-18 00:00:00 | NA | NA | NA | Salem Field | Accounting | Salem Field | P.O. Box 10 |  | HAMPTON | GA | 48997 | 30 days net
√ | None | TRC | GRTOWN | LD | Creeky | Will | DR. | Hope University | [NAME] | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | [PHONE] |  | [EMAIL] | [NAME] | 4 | cases (12 x 4 pk.) | DEODORANT | 2 | cases (24 x 1.5 oz) | DEODORANT | 2 | cases (24 x 1.5 oz) | BABY WIPES | 4 | cases ( 4 x 12 pk) | DEODORANT | 2 | cases (24 x 1.5 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | [NAME] | 3 | cases (12 x 4 pk) | HAIR NETS | 12 | cases (4 x 12 pk) | [NAME] | 12 | case (12 x 4 box/case) | 2013-02-04 00:00:00 | 2013-02-11 00:00:00 | 1Z1214899400251 | 2013-02-05 00:00:00 |  |  |  | 15000 | 2013-07-01 00:00:00 | SAC | 2013-05-18 00:00:00 | NA | NA | NA | Hope University | [NAME] | Hope University | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | 30 days net
√ | Testing | TRC | GRTOWN | CT | [NAME] | Grace |  | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | [PHONE] | [PHONE] |  | DEODORANT | 2 | cases (24 x 1.5 oz) | BABY WIPES | 4 | cases ( 4 x 12 pk) | [NAME] | 3 | cases (12 x 4 pk) | HAIR NETS | 12 | cases (4 x 12 pk) | Knee High Hose | 6 | cases (24 x 12 pk/case) | Shaving Cream | 5 | cases (6 x 10 oz/case) | [NAME] | 12 | cases (12 x 16 oz/case) |  |  |  |  |  |  | 2013-01-23 00:00:00 | ASAP | 1Z1214899400251 | 2013-01-30 00:00:00 |  |  |  | 18920 | 2013-10-01 00:00:00 | CNI | 2013-05-18 00:00:00 | NA | NA | NA | [NAME] | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | 30 days net
√ | Testing | TRC | GRTOWN | CT | Turner | Wally | Dr. | Funding House | [NAME] | 2394 Hwy 130 |  | Mayfair | WA | 10884 | [PHONE] | [PHONE] | [EMAIL] | [NAME] | 4 | cases (12 x 4 pk.) | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | RAZORS | 4 | cases (12 x 4 pk.) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | Shaving Cream | 10 | cases (6 x 10 oz/case) | BABY WIPES | 4 | cases ( 4 x 12 pk) |  |  |  |  |  |  | 2013-01-23 00:00:00 | ASAP | 1Z3150367981776 | 2013-01-30 00:00:00 |  |  | 05-February-2013 / 9:30 AM | 15750 | 2013-07-01 00:00:00 | CNI | 2013-05-01 00:00:00 | NA | NA | NA | Funding House | [NAME] | Funding House | 2394 Hwy 130 |  | Mayfair | WA | 10884 | 30 days net
√ | field work | TRC | GRTOWN | LD | Duke | [NAME] |  | Material Lady | [NAME] | 2051 Pine Street | Suite 12 | Columbia | RI | 21045 | [PHONE] |  | [EMAIL] | Skim Milk 1% | 10 | cases (4 x 4 gal/case) | Eggs | 6 | case (12 x 1 doz/case) | Sour Cream | 10 | cases (10 x 3 oz/case) | Cream Cheese | 12 | cases (10 x 6 oz/case) | Half n Half | 6 | case (12 x .5 gal/case) | Apple Juice | 6 | cases (4 x 1 gal/case) | Yogurt | 4 | cases (6 x 36 oz/case) | Apple Juice | 6 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) | 2013-01-23 00:00:00 | ASAP | 1Z31950367038563 | 2013-01-30 00:00:00 |  |  | 05-February-2013 / 12:56 PM | 10500 | 2013-06-01 00:00:00 | SAC | 2013-04-30 00:00:00 | NA | NA | NA | Material Lady | [NAME] | Material Lady | 2051 Pine Street | Suite 12 | Columbia | RI | 21045 | 30 days net
Cancelled | Testing | SMP | GRTOWN | WT | [NAME] | [NAME] |  | Random House | [NAME] | 2289 Hwy 25 East | P.O. Box 1120 | [NAME] | PA | 19526 | [PHONE] |  | [EMAIL] | [NAME] | 2 | cases (12 x 16 oz/case) | BABY WIPES | 4 | cases (4 x 12 pk/case) | [NAME] | 4 | cases (12 x 4 pk.) | Paper Towels | 2 | case (12 x 6 rolls/case) | [NAME] | 12 | case (12 x 4 box/case) | Cold Cream | 2 | case (10 x 40 oz/case) | Q-Tips | 2 | cases (12 x 4 boxes/case) | Shaving Cream | 4 | cases (12 x 4 pk.) |  |  |  | 2013-02-08 00:00:00 | 2013-02-13 00:00:00 | 1Z31026857583012 | 2013-02-11 00:00:00 |  |  | 13-February-2013 / 12:39 PM | 12750 | 2013-07-01 00:00:00 | SAC | 2013-04-30 00:00:00 | NA | NA | NA | Random House | [NAME] | 2289 Hwy 25 East | P.O. Box 1120 |  | [NAME] | PA | 19526 | 30 days net
√ | field work | SMP | GRTOWN | HJ | [NAME] | [NAME] | Mr. | Salem Field | [NAME] | 21 LINCOLN DRIVE | P.O. BOX 10 | HAMPTON | GA | 48997 | [PHONE] | [PHONE] | [NAME] | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | [NAME] | 4 | cases (12 x 4 pk.) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | [NAME] | 12 | case (12 x 4 box/case) | Cotton swabs | 6 | cases (8 x 12 pk) |  |  |  |  |  |  |  |  |  | 2013-02-08 00:00:00 | 2013-02-15 00:00:00 | 1Z1214899400251 | 2013-02-08 00:00:00 |  |  |  | 16870 | 2013-07-01 00:00:00 | SAC | 2013-05-18 00:00:00 | NA | NA | NA | Salem Field | Accounting | Salem Field | P.O. Box 10 |  | HAMPTON | GA | 48997 | 30 days net
√ | Testing | SMP | GRTOWN | HJ | [NAME] | [NAME] | Mr. | Salem Field | [NAME] | 21 LINCOLN DRIVE | P.O. BOX 10 | HAMPTON | GA | 48997 | [PHONE] | [PHONE] | [NAME] | DEODORANT | 2 | cases (24 x 1.5 oz) | BABY WIPES | 4 | cases ( 4 x 12 pk) | [NAME] | 3 | cases (12 x 4 pk) | HAIR NETS | 12 | cases (4 x 12 pk) | [NAME] | 12 | cases (12 x 16 oz/case) | [NAME] | 12 | case (12 x 4 box/case) |  |  |  |  |  |  |  |  |  | 2013-02-11 00:00:00 | 2013-02-18 00:00:00 | 1Z1214899400251 | 2013-02-12 00:00:00 |  |  |  | 16870 | 2013-10-01 00:00:00 | SAC | 2013-03-10 00:00:00 | NA | NA | NA | Salem Field | Accounting | Salem Field | P.O. Box 10 |  | HAMPTON | GA | 48997 | 30 days net
√ | None | SMP | GRTOWN | CT | [NAME] | Grace |  | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | [PHONE] | [PHONE] |  | [NAME] | 4 | cases (12 x 4 pk.) | DEODORANT | 2 | cases (24 x 1.5 oz) | DEODORANT | 2 | cases (24 x 1.5 oz) | BABY WIPES | 4 | cases ( 4 x 12 pk) | DEODORANT | 2 | cases (24 x 1.5 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | [NAME] | 3 | cases (12 x 4 pk) | HAIR NETS | 12 | cases (4 x 12 pk) | [NAME] | 12 | case (12 x 4 box/case) | 2013-02-11 00:00:00 | 2013-02-18 00:00:00 | 1Z1214899400251 | 2013-02-12 00:00:00 |  |  |  | 12750 | 2013-05-01 00:00:00 | CNI | 2013-03-10 00:00:00 |  |  |  | [NAME] | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | 30 days net
√ | None | PPR | GRTOWN | CT | [NAME] | Grace | Dr. | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | [PHONE] | [PHONE] |  | DEODORANT | 2 | cases (24 x 1.5 oz) | DEODORANT | 2 | cases (24 x 1.5 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | [NAME] | 12 | cases (12 x 16 oz/case) | Shaving Cream | 10 | cases (6 x 10 oz/case) |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-12 00:00:00 | via ground | 1Z1214899400251 | 2013-02-13 00:00:00 |  |  |  | 19200 | 2013-06-15 00:00:00 | CNI | 2013-03-10 00:00:00 | NA | NA | NA | [NAME] | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | 30 days net
√ | Testing | PPR | GRTOWN | CT | [NAME] | Grace |  | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | [PHONE] | [PHONE] |  | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | [NAME] | 4 | cases (12 x 4 pk.) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | [NAME] | 12 | case (12 x 4 box/case) | BABY WIPES | 4 | cases ( 4 x 12 pk) |  |  |  |  |  |  |  |  |  | 2013-02-13 00:00:00 | 2013-02-20 00:00:00 | 1Z1214899400251 | 2013-02-13 00:00:00 |  |  |  | 16870 | 2013-05-01 00:00:00 | CNI | 2013-03-10 00:00:00 |  |  |  | [NAME] | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | 30 days net
√ | None | TRC | GRTOWN | CT | [NAME] | Grace |  | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | [PHONE] | [PHONE] |  | DEODORANT | 2 | cases (24 x 1.5 oz) | BABY WIPES | 4 | cases ( 4 x 12 pk) | [NAME] | 3 | cases (12 x 4 pk) | HAIR NETS | 12 | cases (4 x 12 pk) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-13 00:00:00 | 2013-02-20 00:00:00 | 1Z1214899400251 | 2013-02-13 00:00:00 |  |  |  | 8200 | 2013-10-01 00:00:00 | SAC | 2013-03-10 00:00:00 |  |  |  | [NAME] | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | 30 days net
√ | None | PPR | GRTOWN | HJ | [NAME] | [NAME] | Mr. | Salem Field | [NAME] | 21 LINCOLN DRIVE | P.O. BOX 10 | HAMPTON | GA | 48997 | [PHONE] | [PHONE] | [NAME] | [NAME] | 4 | cases (12 x 4 pk.) | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | RAZORS | 4 | cases (12 x 4 pk.) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | Shaving Cream | 10 | cases (6 x 10 oz/case) | BABY WIPES | 4 | cases ( 4 x 12 pk) |  |  |  |  |  |  | 2013-03-09 00:00:00 | 2013-03-12 00:00:00 | 1Z1214899400251 | 2013-03-10 00:00:00 |  |  |  | 16870 | 2013-07-01 00:00:00 | CNI | 2013-05-18 00:00:00 | NA | NA | NA | Salem Field | Accounting | Salem Field | P.O. Box 10 |  | HAMPTON | GA | 48997 | 30 days net
√ | Testing | PPR | GRTOWN | CT | [NAME] | Grace |  | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | [PHONE] | [PHONE] |  | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | [NAME] | 4 | cases (12 x 4 pk.) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | BABY WIPES | 4 | cases ( 4 x 12 pk) | [NAME] | 12 | cases (12 x 16 oz/case) |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-13 00:00:00 | 2013-02-20 00:00:00 | 1Z1214899400251 | 2013-02-13 00:00:00 |  |  | 20-February-2013 / 9:00 AM | 8200 | 2013-07-01 00:00:00 | SAC | 2013-05-18 00:00:00 |  |  |  | [NAME] | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | 60-day
√ | field work | PPR | GRTOWN | CT | [NAME] | Grace |  | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | [PHONE] | [PHONE] |  | DEODORANT | 2 | cases (24 x 1.5 oz) | BABY WIPES | 4 | cases ( 4 x 12 pk) | [NAME] | 3 | cases (12 x 4 pk) | HAIR NETS | 12 | cases (4 x 12 pk) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-13 00:00:00 | 2013-02-20 00:00:00 | 1Z1214899400251 | 2013-02-13 00:00:00 |  |  | 21-February-2013 / 5:08 PM | 16400 | 2013-05-01 00:00:00 | CNI | 2013-03-10 00:00:00 |  |  |  | [NAME] | [NAME] | [NAME] | 24 [NAME] So. |  | Hercules | MT | 76704 | 60-day
√ | Testing | PPR | GRTOWN | LD | Creeky | Will | DR. | Hope University | [NAME] | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | [PHONE] |  | [EMAIL] | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | [NAME] | 4 | cases (12 x 4 pk.) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | [NAME] | 12 | case (12 x 4 box/case) | Cotton swabs | 6 | cases (8 x 12 pk) |  |  |  |  |  |  |  |  |  | 2013-02-13 00:00:00 | 2013-02-20 00:00:00 | 1Z31950369610350 | 2013-02-13 00:00:00 |  |  | 21-February-2013 / 5:08 PM | 18000 | 2013-05-01 00:00:00 | CNI | 2013-03-10 00:00:00 |  |  |  | Hope University | [NAME] | Hope University | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | 30 days net
√ | Testing | SMP | GRTOWN | LD | Creeky | Will | DR. | Hope University | [NAME] | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | [PHONE] |  | [EMAIL] | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | [NAME] | 4 | cases (12 x 4 pk.) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | [NAME] | 12 | case (12 x 4 box/case) | BABY WIPES | 4 | cases ( 4 x 12 pk) |  |  |  |  |  |  |  |  |  | 2013-02-13 00:00:00 | 2013-02-22 00:00:00 | 1Z31950367513978 | 2013-02-13 00:00:00 |  |  | 19-February-2013 / 10:07 AM | 12500 | 2013-05-01 00:00:00 | CNI | 2013-03-10 00:00:00 | NA | NA | NA | Hope University | [NAME] | Hope University | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | 30 days net
√ | field work | SMP | GRTOWN | LD | Creeky | Will | DR. | Hope University | [NAME] | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | [PHONE] |  | [EMAIL] | [NAME] | 4 | cases (12 x 4 pk.) | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | RAZORS | 4 | cases (12 x 4 pk./case) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | Shaving Cream | 10 | cases (6 x 10 oz/case) | BABY WIPES | 4 | cases ( 4 x 12 pk) |  |  |  |  |  |  | 2013-02-13 00:00:00 | via ground | 1Z31950369572026 | 2013-02-14 00:00:00 |  |  | 15-February-2013 / 10:20 AM | 5400 | 2013-03-15 00:00:00 | CNI | 2013-02-26 00:00:00 |  |  |  | Hope University | [NAME] | Hope University | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | 30 days net
√ | Testing | SMP | GRTOWN | LD | Creeky | Will | DR. | Hope University | [NAME] | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | [PHONE] |  | [EMAIL] | Cold Cream | 2 | cases (24 x 1.5 oz) | DEODORANT | 2 | cases (24 x 1.5 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | Shaving Cream | 10 | cases (6 x 10 oz/case) | [NAME] | 12 | case (12 x 4 box/case) | HAIR PINS | 5 | cases (24 x pk. 100) |  |  |  | 2013-02-14 00:00:00 | 2013-02-25 00:00:00 | 1Z31950369338137 | 2013-02-19 00:00:00 |  |  | 25-February-2013 / 9:15 AM | 12100 | 2013-03-15 00:00:00 | CNI | 2013-02-26 00:00:00 |  |  |  | Hope University | [NAME] | Hope University | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | 30 days net
Cancelled | Testing | PPR | GRTOWN | LD | Creeky | Will | DR. | Hope University | [NAME] | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | [PHONE] |  | [EMAIL] | BABY WIPES | 4 | cases (4 x 12 pk/case) | [NAME] | 3 | cases (12 x 4 pk) | HAIR NETS | 12 | cases (4 x 12 pk/case) | Nailpolish Remover | 2 | cases (10 x 8 oz/case) | Q-Tips | 2 | cases (12 x 4 boxes/case) | HAIR PINS | 5 | cases (24 x pk. 100) |  |  |  |  |  |  |  |  |  | 2013-02-14 00:00:00 | 2013-02-25 00:00:00 | 1Z31950369338187 | 2013-02-15 00:00:00 |  |  | NA | 13500 | 2013-03-15 00:00:00 | SAC | 2013-02-26 00:00:00 |  |  |  | Hope University | [NAME] | Hope University | Fountain Hall | 223 [NAME] | Crain | MI | 77036 | 30 days net
NA | Store Sales | PPR | GRTOWN | LD | Franklin | [NAME] |  | Chelsea Farms | [NAME] | 110 Avenue D |  | Charleston | LA | 11896 | [PHONE] |  |  | Skim Milk 1% | 10 | cases (4 x 4 gal/case) | Eggs | 6 | case (12 x 1 doz/case) | Sour Cream | 10 | cases (10 x 3 oz/case) | Cream Cheese | 12 | cases (10 x 6 oz/case) | Half n Half | 6 | case (12 x .5 gal/case) | Apple Juice | 6 | cases (4 x 1 gal/case) | Yogurt | 4 | cases (6 x 36 oz/case) | Apple Juice | 6 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) | 2013-04-18 00:00:00 | 2013-04-25 00:00:00 | 1Z4622985206 | 2013-04-19 00:00:00 |  |  | NA | 24000 | 2013-06-15 00:00:00 | SAC | 2013-04-30 00:00:00 |  |  |  | Chelsea Farms | Accounting | Chelsea Farms | P.O. Box 1589 |  | Charleston | LA | 11896-1589 | 60-day
√ | None | PPR | GRTOWN | WT | Frankly | Scarlet | Dr. | University of Theater | [NAME] | Drama Department | [NAME] | Trenton | NJ | 61695 | 350-57-5047 |  |  | Mascara | 2 | cases (4 x 12 pk/case) | [NAME] | 3 | cases (12 x 26 pcs/case) | Lip Pencil | 10 | cases (10 x 12 pcs/case) | HAIR PINS | 5 | cases (24 x pk. 100) | [NAME] | 12 | case (12 x 4 box/case) | Cotton swabs | 6 | cases (8 x 12 pk) | Q-Tips | 2 | cases (12 x 4 boxes/case) |  |  |  |  |  |  | 2013-02-14 00:00:00 | Overnight - 2/19/13 | 1Z31501670004546 | 2013-02-18 00:00:00 |  |  | 19-February-2013 / 10:26 AM | 6900 | 2013-06-01 00:00:00 | SAC | 2013-03-10 00:00:00 |  |  |  | University of Theater | [NAME] | University of Theater | Drama Department | [NAME] | Trenton | NJ | 61695 | 60 days net
√ | Testing | SMP | GRTOWN | WT | Frankly | Scarlet | Dr. | University of Theater | [NAME] | Drama Department | [NAME] | Trenton | NJ | 61695 | 350-57-5047 |  |  | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | [NAME] | 5 | cases (12 x 16 oz/case) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | RAZORS | 4 | cases (12 x 4 pk./case) | BABY WIPES | 4 | cases ( 4 x 12 pk) | Cold Cream | 2 | case (10 x 40 oz/case) |  |  |  |  |  |  |  |  |  | 2013-01-08 00:00:00 | 2013-01-14 00:00:00 | 1Z31950367038563 | 2013-01-07 00:00:00 |  |  | NA | 12500 | 2013-06-01 00:00:00 | SAC | 2013-03-10 00:00:00 |  |  |  | University of Theater | [NAME] | University of Theater | Drama Department | [NAME] | Trenton | NJ | 61695 | 61 days net
√ | Testing | SMP | GRTOWN | WT | Frankly | Scarlet | Dr. | University of Theater | [NAME] | Drama Department | [NAME] | Trenton | NJ | 61695 | 350-57-5047 |  |  | Cold Cream | 2 | cases (24 x 1.5 oz) | DEODORANT | 2 | cases (24 x 1.5 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | Shaving Cream | 10 | cases (6 x 10 oz/case) | [NAME] | 12 | case (12 x 4 box/case) |  |  |  |  |  |  | 2013-01-08 00:00:00 | 2013-01-14 00:00:00 | 1Z31026857583029 | 2013-01-07 00:00:00 |  |  | NA | 5400 | 2013-06-01 00:00:00 | SAC | 2013-03-10 00:00:00 |  |  |  | University of Theater | [NAME] | University of Theater | Drama Department | [NAME] | Trenton | NJ | 61695 | 61 days net
√ | Testing | SMP | GRTOWN | WT | Frankly | Scarlet | Dr. | University of Theater | [NAME] | Drama Department | [NAME] | Trenton | NJ | 61695 | 350-57-5047 |  |  | Hair Color | 3 | cases (12 x 32 oz/case) | [NAME] | 3 | case (12 x 1 doz/case) | Nail Polish | 1 | case (14 x 1 pc/case) | [NAME] | 1 | case (10 x 3.0 oz/case) | [NAME] | 12 | case (12 x 4 box/case) | RAZORS | 4 | cases (12 x 4 pk.) | HAIR PINS | 5 | cases (24 x pk. 100) |  |  |  |  |  |  | 2013-04-11 00:00:00 | 2013-04-15 00:00:00 | 1Z31026857583029 | 2013-04-10 00:00:00 |  |  | NA | 12100 | 2013-10-01 00:00:00 | SAC | 2013-07-01 00:00:00 |  |  |  | University of Theater | [NAME] | University of Theater | Drama Department | [NAME] | Trenton | NJ | 61695 | 30 days net
√ | None | MDM | GRTOWN | WT | Frankly | Scarlet | Dr. | University of Theater | [NAME] | Drama Department | [NAME] | Trenton | NJ | 61695 | 350-57-5047 |  |  | Mascara | 2 | cases (4 x 12 pk/case) | [NAME] | 3 | cases (12 x 26 pcs/case) | Lip Pencil | 10 | cases (10 x 12 pcs/case) | HAIR PINS | 5 | cases (24 x pk. 100) | [NAME] | 12 | case (12 x 4 box/case) | Cotton swabs | 6 | cases (8 x 12 pk) |  |  |  |  |  |  |  |  |  | 2013-04-11 00:00:00 | 2013-04-15 00:00:00 | 1Z31026857583029 | 2013-04-10 00:00:00 |  |  | NA | 15950 | 2013-10-01 00:00:00 | CNI | 2013-07-01 00:00:00 |  |  |  | University of Theater | [NAME] | University of Theater | Drama Department | [NAME] | Trenton | NJ | 61695 | 30 days net
√ | None | MDM | GRTOWN | CT | Potter | [NAME] | Mr. | Tender Game | [NAME] | 1856 Downtown Plaza |  | Phoenix | AZ | 68571 | [PHONE] |  | [EMAIL] | [NAME] | 4 | cases (12 x 4 pk.) | DEODORANT | 2 | cases (24 x 1.5 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | Shaving Cream | 10 | cases (6 x 10 oz/case) | [NAME] | 12 | case (12 x 4 box/case) |  |  |  |  |  |  | 2013-02-14 00:00:00 | 2013-02-25 00:00:00 | 1Z31503675981285 | 2013-02-19 00:00:00 |  |  | 25-February-2013 / 9:15 AM | 4500 | 2013-07-01 00:00:00 | CNI | 2013-05-30 00:00:00 |  |  |  | Tender Game | [NAME] | Tender Game | 1856 Downtown Plaza |  | Phoenix | AZ | 68571 | 30 days net
NA | None | MDM | GRTOWN | CT | Potter | [NAME] | Mr. | Tender Game | [NAME] | 1856 Downtown Plaza |  | Phoenix | AZ | 68571 | [PHONE] |  | [EMAIL] | Hair Color | 3 | cases (12 x 32 oz/case) | [NAME] | 3 | cases (12 x 26 pcs/case) | [NAME] | 3 | case (12 x 1 doz/case) | HAIR PINS | 5 | cases (24 x pk. 100) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | Q-Tips | 2 | cases (12 x 4 boxes/case) |  |  |  |  |  |  |  |  |  | 2013-01-08 00:00:00 | ASAP | 1Z31503675981324 | 2013-02-19 00:00:00 |  |  |  | 6250 | 2013-07-01 00:00:00 | SAC | 2013-05-30 00:00:00 |  |  |  | Tender Game | [NAME] | Tender Game | 1856 Downtown Plaza |  | Phoenix | AZ | 68571 | 61 days net
√ | Testing | MDM | GRTOWN | CT | Potter | [NAME] | Mr. | Tender Game | [NAME] | 1856 Downtown Plaza |  | Phoenix | AZ | 68571 | [PHONE] |  | [EMAIL] | BABY WIPES | 4 | cases (4 x 12 pk/case) | [NAME] | 3 | cases (12 x 4 pk) | HAIR NETS | 12 | cases (4 x 12 pk/case) | [NAME] | 12 | case (12 x 4 box/case) | [NAME] | 2 | cases (12 x 16 oz/case) | Nailpolish Remover | 2 | cases (10 x 8 oz/case) | Ribbons | 4 | cases (8 x 12 rolls/case) |  |  |  |  |  |  | 2013-02-14 00:00:00 | 2013-02-25 00:00:00 | 1Z31503679817768 | 2013-02-13 00:00:00 |  |  |  | 6250 | 2013-07-01 00:00:00 | CNI | 2013-05-30 00:00:00 |  |  |  | Tender Game | [NAME] | Tender Game | 1856 Downtown Plaza |  | Phoenix | AZ | 68571 | 61 days net
√ | Random | TTM | GRTOWN | CT | Potter | [NAME] | Mr. | Tender Game | [NAME] | 1856 Downtown Plaza |  | Phoenix | AZ | 68571 | [PHONE] |  | [EMAIL] | Hair Color | 3 | cases (12 x 32 oz/case) | [NAME] | 3 | case (12 x 1 doz/case) | Nail Polish | 1 | case (14 x 1 pc/case) | [NAME] | 1 | case (10 x 3.0 oz/case) | [NAME] | 12 | case (12 x 4 box/case) | HAIR PINS | 5 | cases (24 x pk. 100) |  |  |  |  |  |  |  |  |  | 2013-02-14 00:00:00 | 2013-02-25 00:00:00 | 1Z31RW950367598 | 2013-02-19 00:00:00 |  |  | 25-February-2013 / 9:15 AM | 5500 | 2013-07-01 00:00:00 | CNI | 2013-05-30 00:00:00 |  |  |  | Tender Game | [NAME] | Tender Game | 1856 Downtown Plaza |  | Phoenix | AZ | 68571 | 61 days net
√ | Field Trial | DPR | GRTOWN | LD | Franklin | [NAME] |  | Chelsea Farms | [NAME] | 110 Avenue D |  | Charleston | LA | 11896 | [PHONE] |  |  | Eggs | 18 | case (12 x 1 doz/case) | Skim Milk 1% | 15 | cases (4 x 4 gal/case) | Cream Cheese | 12 | cases (10 x 6 oz/case) | Half n Half | 10 | case (12 x .5 gal/case) | Orange Juice | 5 | cases (4 x 1 gal/case) | Apple Juice | 12 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) | Sour Cream | 10 | cases (6 x 16 oz/case) |  |  |  | 2013-01-14 00:00:00 | 2013-01-20 00:00:00 | 1Z349689334311 | 2013-01-15 00:00:00 |  |  |  | 30000 | 2013-08-01 00:00:00 | CNI | 2013-07-01 00:00:00 |  |  |  | Chelsea Farms | Accounting | Chelsea Farms | P.O. Box 1589 |  | Charleston | LA | 11896-1589 | 60-day
√ | Lab Work | DPR | GRTOWN | LD | Franklin | [NAME] |  | Chelsea Farms | [NAME] | 110 Avenue D |  | Charleston | LA | 11896 | [PHONE] |  |  | Skim Milk 1% | 10 | case (4 x 4 gal/case) | Cream Cheese | 12 | cases (10 x 6 oz/case) | Sour Cream | 10 | cases (10 x 3 oz/case) | Cheddar Cheese | 12 | case (6 x 8 oz) | Orange Juice | 2 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) |  |  |  |  |  |  |  |  |  | 2013-04-18 00:00:00 | 2013-04-28 00:00:00 | 7321214819 | 2013-04-19 00:00:00 |  |  |  | 15000 | 2013-10-01 00:00:00 | CNI | 2013-07-01 00:00:00 |  |  |  | Chelsea Farms | Accounting | Chelsea Farms | P.O. Box 1589 |  | Charleston | LA | 11896-1589 | 60-day
√ | Store Sales | PPR | GRTOWN | LD | Franklin | [NAME] |  | Chelsea Farms | [NAME] | 110 Avenue D |  | Charleston | LA | 11896 | [PHONE] |  |  | Apple Juice | 6 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) | Apple Juice | 6 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) | Cream Cheese | 12 | cases (10 x 6 oz/case) | Half n Half | 6 | case (12 x .5 gal/case) | Eggs | 6 | case (12 x 1 doz/case) | Yogurt | 4 | case (6 x 36 oz/case0 | Pudding Cups | 12 | cases (12 x 3 oz/case) | 2013-01-14 00:00:00 | 2013-01-20 00:00:00 | 1Z349689334311 | 2013-01-15 00:00:00 |  |  |  | 10670 | 2013-06-01 00:00:00 | SAC | 2013-05-01 00:00:00 |  |  |  | Chelsea Farms | Accounting | Chelsea Farms | P.O. Box 1589 |  | Charleston | LA | 11896-1589 | 60-day
√ | None | SMP | GRTOWN | HJ | Flame | [NAME] |  | Happy Farms | [NAME] | Hwy 49 South |  | Madrid | GA | 20136 | [PHONE] |  |  | Eggs | 18 | case (12 x 1 doz/case) | Skim Milk 1% | 15 | cases (4 x 4 gal/case) | Cream Cheese | 12 | cases (10 x 6 oz/case) | Half n Half | 10 | case (12 x .5 gal/case) | Orange Juice | 5 | cases (4 x 1 gal/case) | Apple Juice | 12 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) | Sour Cream | 10 | cases (6 x 16 oz/case) |  |  |  | 2013-01-08 00:00:00 | 2013-01-14 00:00:00 | 1Z31950368467633 | 2013-01-08 00:00:00 |  |  | 10-January-2013 / 10:18 AM | 16780 | 2013-08-01 00:00:00 | SAC | 2013-07-01 00:00:00 | NA | NA | NA | Happy Farms | [NAME] | Hwy 49 South | [NAME] 14 |  | Madrid | GA | 20136 | 30 days net
√ | None | SMP | GRTOWN | HJ | Flame | [NAME] |  | Happy Farms | [NAME] | Hwy 49 South |  | Madrid | GA | 20136 | [PHONE] |  |  | Skim Milk 1% | 10 | cases (4 x 4 gal/case) | Eggs | 6 | case (12 x 1 doz/case) | Sour Cream | 10 | cases (10 x 3 oz/case) | Cream Cheese | 12 | cases (10 x 6 oz/case) | Half n Half | 6 | case (12 x .5 gal/case) | Apple Juice | 6 | cases (4 x 1 gal/case) | Yogurt | 4 | cases (6 x 36 oz/case) | Apple Juice | 6 | cases (4 x 1 gal/case) | Cottage Cheese | 4 | cases (6 x 16 oz/case) | 2013-01-08 00:00:00 | 2013-01-14 00:00:00 | 1Z31503684676336 | 2013-01-08 00:00:00 |  |  | 10-January-2013 / 10:18 AM | 15500 | 2013-07-01 00:00:00 | CNI | 2013-06-01 00:00:00 | NA | NA | NA | Happy Farms | [NAME] | Hwy 49 South | [NAME] 14 |  | Madrid | GA | 20136 | 30 days net
√ | Testing | TRC | GRTOWN | CT | Turner | Wally | Dr. | Funding House | [NAME] | 2394 Hwy 130 |  | Mayfair | WA | 10884 | [PHONE] | [PHONE] | [EMAIL] | [NAME] | 4 | cases (12 x 4 pk.) | DEODORANT | 2 | cases (24 x 1.5 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | [NAME] | 12 | cases (12 x 16 oz/case) | Shaving Cream | 10 | cases (6 x 10 oz/case) | [NAME] | 12 | case (12 x 4 box/case) |  |  |  |  |  |  | 2013-02-15 00:00:00 | 2013-02-20 00:00:00 | 1Z31503679817321 | 2013-02-16 00:00:00 |  |  |  | 12500 | 2013-10-01 00:00:00 | CNI | 2013-07-01 00:00:00 | NA | NA | NA | Funding House | [NAME] | Funding House | 2394 Hwy 130 | Mayfair | Mayfair | WA | 10884 | 30 days net
√ | Testing | TRC | GRTOWN | CT | Turner | Wally | Dr. | Funding House | [NAME] | 2394 Hwy 130 |  | Mayfair | WA | 10884 | [PHONE] | [PHONE] | [EMAIL] | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | [NAME] | 4 | cases (12 x 4 pk.) | COTTON BALLS | 6 | cases (24 x 3.0 oz) | HAIR PINS | 5 | cases (24 x pk. 100) | [NAME] | 12 | case (12 x 4 box/case) | Cotton swabs | 6 | cases (8 x 12 pk) |  |  |  |  |  |  |  |  |  | 2013-04-11 00:00:00 | 2013-04-15 00:00:00 | 1Z31503679817765 | 2013-04-12 00:00:00 |  |  |  | 10250 | 2013-08-15 00:00:00 | SAC | 2013-07-01 00:00:00 | NA | NA | NA | Funding House | [NAME] | Funding House | 2394 Hwy 130 | Mayfair | Mayfair | WA | 10884 | 30 days net
Completed | Protocol | Product/Project Code | Ship Facility | PI | Cooperator LName | Cooperator FName | Title #1 | Company | Shipping Contact | Shipping Address Line 1 | Shipping Address Line 2 | City | State | Zip | Phone Number | Cell Number/ Fax | E-Mail | Product # | Product | Quantity | [NAME] | Date Requested | Delivery Deadline | Tracking Number 1 | Date Shipped 1 | Tracking Number | Date Received 2 | Date Received | Payment Amount | Payment Deadline | Funding Source | Date Requested | Payment Issued | Check  Number | Payment Received | Payee | Check Attention | Payment Address Line 1 | Payment Address Line 2 | Payment Address Line 2 | City | State | Zip Code | Instructions
√ | Testing | TRC | GRTOWN | CT | Turner | Wally | Dr. | Funding House | [NAME] | 2394 Hwy 130 |  | Mayfair | WA | 10884 | [PHONE] | [PHONE] | [EMAIL] | Product 1 | SHAVING CREAM | 1 | cases (2 x 2.5 gal/case) | 2013-04-11 00:00:00 | 2013-04-15 00:00:00 | 1Z31503679817765 | 2013-04-12 00:00:00 |  |  |  | 10250 | 2013-08-15 00:00:00 | SAC | 2013-07-01 00:00:00 | NA | NA | NA | Funding House | [NAME] | Funding House | 2394 Hwy 130 | Mayfair | Mayfair | WA | 10884 | 30 days net
√ | Testing | TRC | GRTOWN | CT | Turner | Wally | Dr. | Funding House | [NAME] | 2394 Hwy 130 |  | Mayfair | WA | 10884 | [PHONE] | [PHONE] | [EMAIL] | Product 2 | [NAME] | 4 | cases (12 x 4 pk.) | 2013-04-11 00:00:00 | 2013-04-15 00:00:00 | 1Z31503679817765 | 2013-04-12 00:00:00 |  |  |  | 10250 | 2013-08-15 00:00:00 | SAC | 2013-07-01 00:00:00 | NA | NA | NA | Funding House | [NAME] | Funding House | 2394 Hwy 130 | Mayfair | Mayfair | WA | 10884 | 30 days net
√ | Testing | TRC | GRTOWN | CT | Turner | Wally | Dr. | Funding House | [NAME] | 2394 Hwy 130 |  | Mayfair | WA | 10884 | [PHONE] | [PHONE] | [EMAIL] | Product 3 | COTTON BALLS | 6 | cases (24 x 3.0 oz) | 2013-04-11 00:00:00 | 2013-04-15 00:00:00 | 1Z31503679817765 | 2013-04-12 00:00:00 |  |  |  | 10250 | 2013-08-15 00:00:00 | SAC | 2013-07-01 00:00:00 | NA | NA | NA | Funding House | [NAME] | Funding House | 2394 Hwy 130 | Mayfair | Mayfair | WA | 10884 | 30 days net
√ | Testing | TRC | GRTOWN | CT | Turner | Wally | Dr. | Funding House | [NAME] | 2394 Hwy 130 |  | Mayfair | WA | 10884 | [PHONE] | [PHONE] | [EMAIL] | Product 4 | HAIR PINS | 5 | cases (24 x pk. 100) | 2013-04-11 00:00:00 | 2013-04-15 00:00:00 | 1Z31503679817765 | 2013-04-12 00:00:00 |  |  |  | 10250 | 2013-08-15 00:00:00 | SAC | 2013-07-01 00:00:00 | NA | NA | NA | Funding House | [NAME] | Funding House | 2394 Hwy 130 | Mayfair | Mayfair | WA | 10884 | 30 days net
√ | Testing | TRC | GRTOWN | CT | Turner | Wally | Dr. | Funding House | [NAME] | 2394 Hwy 130 |  | Mayfair | WA | 10884 | [PHONE] | [PHONE] | [EMAIL] | Product 5 | [NAME] | 12 | case (12 x 4 box/case) | 2013-04-11 00:00:00 | 2013-04-15 00:00:00 | 1Z31503679817765 | 2013-04-12 00:00:00 |  |  |  | 10250 | 2013-08-15 00:00:00 | SAC | 2013-07-01 00:00:00 | NA | NA | NA | Funding House | [NAME] | Funding House | 2394 Hwy 130 | Mayfair | Mayfair | WA | 10884 | 30 days net
√ | Testing | TRC | GRTOWN | CT | Turner | Wally | Dr. | Funding House | [NAME] | 2394 Hwy 130 |  | Mayfair | WA | 10884 | [PHONE] | [PHONE] | [EMAIL] | Product 6 | Cotton swabs | 6 | cases (8 x 12 pk) | 2013-04-11 00:00:00 | 2013-04-15 00:00:00 | 1Z31503679817765 | 2013-04-12 00:00:00 |  |  |  | 10250 | 2013-08-15 00:00:00 | SAC | 2013-07-01 00:00:00 | NA | NA | NA | Funding House | [NAME] | Funding House | 2394 Hwy 130 | Mayfair | Mayfair | WA | 10884 | 30 days net