Spreadsheet: 215668d1361451739-auto-populating-a-calendar-from-data-specific-to-tracking-multiple-ship-dates-on-one-date-sampleshipmentdata
Sheet: Sheet1

Purchase Oder | PO Line | Material | Material Description | Qty | Ship Method | Delivery Date PO | Must Ship BY | Dock Date
450031516 | 10 | 45099491 | ASSY DRIVE | 5 | Ocean | 2013-03-20 00:00:00 | 2013-03-10 00:00:00 | 2013-04-10 00:00:00
450031516 | 10 | 45099491 | ASSY DRIVE | 5 | Ocean | 2013-04-19 00:00:00 | 2013-04-14 00:00:00 | 2013-05-21 00:00:00
450030862 | 20 | 45059074 | ASSY IDLER | 6 | Ocean | 2013-04-10 00:00:00 | 2013-03-10 00:00:00 | 2013-04-10 00:00:00
450028681 | 10 | 45059074 | ASSY IDLER | 4 | Ocean | 2013-12-31 00:00:00 | 2013-04-14 00:00:00 | 2013-06-11 00:00:00
450030895 | 10 | 45113155 | NIP ROLL | 2 | In Transit | 2013-02-20 00:00:00 | In Transit | 2013-02-20 00:00:00
450030895 | 30 | 45113155 | NIP ROLL | 2 | In Transit | 2013-03-04 00:00:00 | In Transit | 2013-03-04 00:00:00
450030895 | 50 | 45113155 | NIP ROLL | 2 | In Transit | 2013-03-08 00:00:00 | In Transit | 2013-03-08 00:00:00
450030895 | 70 | 45113155 | NIP ROLL | 2 | In Transit | 2013-03-08 00:00:00 | In Transit | 2013-03-08 00:00:00
450030895 | 90 | 45113155 | NIP ROLL | 2 | Ocean | 2013-03-20 00:00:00 | 2013-02-17 00:00:00 | 2013-03-21 00:00:00
450030895 | 110 | 45113155 | NIP ROLL | 2 | Ocean | 2013-03-20 00:00:00 | 2013-02-17 00:00:00 | 2013-03-21 00:00:00
450030895 | 10 | 45113155 | NIP ROLL | 2 | Ocean | 2013-04-10 00:00:00 | 2013-02-24 00:00:00 | 2013-03-28 00:00:00
450030895 | 30 | 45113155 | NIP ROLL | 2 | Ocean | 2013-04-10 00:00:00 | 2013-03-10 00:00:00 | 2013-04-11 00:00:00
450030895 | 130 | 45113155 | NIP ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-03-10 00:00:00 | 2013-04-11 00:00:00
450031353 | 10 | 45113155 | NIP ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-03-10 00:00:00 | 2013-04-11 00:00:00
450031353 | 30 | 45113155 | NIP ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-03-10 00:00:00 | 2013-04-11 00:00:00
450031353 | 50 | 45113155 | NIP ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031353 | 70 | 45113155 | NIP ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031805 | 50 | 45113155 | NIP ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031805 | 70 | 45113155 | NIP ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031805 | 90 | 45113155 | NIP ROLL | 2 | Ocean | 2013-05-01 00:00:00 | 2013-04-28 00:00:00 | 2013-05-30 00:00:00
450030895 | 20 | 45113156 | DRIVE ROLL | 2 | In Transit | 2013-02-20 00:00:00 | In Transit | In Transit
450030895 | 40 | 45113156 | DRIVE ROLL | 2 | In Transit | 2013-03-04 00:00:00 | In Transit | In Transit
450030895 | 60 | 45113156 | DRIVE ROLL | 2 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030895 | 80 | 45113156 | DRIVE ROLL | 2 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030895 | 100 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-03-20 00:00:00 | 2013-02-17 00:00:00 | 2013-03-21 00:00:00
450030895 | 120 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-03-20 00:00:00 | 2013-02-17 00:00:00 | 2013-03-21 00:00:00
450031805 | 20 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-04-10 00:00:00 | 2013-02-24 00:00:00 | 2013-03-28 00:00:00
450031805 | 40 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-04-10 00:00:00 | 2013-03-10 00:00:00 | 2013-04-11 00:00:00
450030895 | 140 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-03-10 00:00:00 | 2013-04-11 00:00:00
450031353 | 20 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-03-10 00:00:00 | 2013-04-11 00:00:00
450031353 | 40 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-03-10 00:00:00 | 2013-04-11 00:00:00
450031353 | 60 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031353 | 80 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031805 | 60 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031805 | 80 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-04-19 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031805 | 100 | 45113156 | DRIVE ROLL | 2 | Ocean | 2013-05-01 00:00:00 | 2013-04-28 00:00:00 | 2013-05-30 00:00:00
450030497 | 10 | 45073176 | UNWINDER ASSY | 1 | In Transit | 2013-03-04 00:00:00 | In Transit | In Transit
450030497 | 20 | 45073176 | UNWINDER ASSY | 1 | In Transit | 2013-03-04 00:00:00 | In Transit | In Transit
450030787 | 10 | 45073176 | UNWINDER ASSY | 1 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030787 | 10 | 45073176 | UNWINDER ASSY | 1 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030787 | 10 | 45073176 | UNWINDER ASSY | 1 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030787 | 10 | 45073176 | UNWINDER ASSY | 1 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030787 | 10 | 45073176 | UNWINDER ASSY | 1 | In Transit | 2013-03-15 00:00:00 | In Transit | In Transit
450030787 | 10 | 45073176 | UNWINDER ASSY | 1 | In Transit | 2013-03-15 00:00:00 | In Transit | In Transit
450030787 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-03-20 00:00:00 | 2013-02-24 00:00:00 | 2013-03-28 00:00:00
450030787 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-04-19 00:00:00 | 2013-02-24 00:00:00 | 2013-03-28 00:00:00
450030787 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-04-19 00:00:00 | 2013-03-17 00:00:00 | 2013-04-18 00:00:00
450031470 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-04-19 00:00:00 | 2013-03-17 00:00:00 | 2013-04-18 00:00:00
450031470 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-04-19 00:00:00 | 2013-03-17 00:00:00 | 2013-04-18 00:00:00
450031470 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-04-19 00:00:00 | 2013-03-17 00:00:00 | 2013-04-18 00:00:00
450031470 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-05-10 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031470 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-05-10 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031470 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-05-10 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031470 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-05-31 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031470 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-05-31 00:00:00 | 2013-04-28 00:00:00 | 2013-05-30 00:00:00
450031916 | 10 | 45073176 | UNWINDER ASSY | 12 |  | 2013-06-24 00:00:00 | 2013-05-12 00:00:00 | 2013-06-13 00:00:00
450026778 | 20 | 45073176 | UNWINDER ASSY | 1 |  | 2013-12-31 00:00:00 | 2013-07-26 00:00:00 | 2013-08-27 00:00:00
450027336 | 10 | 45073176 | UNWINDER ASSY | 1 |  | 2013-12-31 00:00:00 | 2013-07-28 00:00:00 | 2013-08-29 00:00:00
450030497 | 10 | 45073177 | REWINDER ASSY | 1 | In Transit | 2013-03-04 00:00:00 | In Transit | In Transit
450030497 | 10 | 45073177 | REWINDER ASSY | 1 | In Transit | 2013-03-04 00:00:00 | In Transit | In Transit
450030788 | 10 | 45073177 | REWINDER ASSY | 1 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030788 | 10 | 45073177 | REWINDER ASSY | 1 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030788 | 10 | 45073177 | REWINDER ASSY | 1 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030788 | 10 | 45073177 | REWINDER ASSY | 1 | In Transit | 2013-03-08 00:00:00 | In Transit | In Transit
450030788 | 10 | 45073177 | REWINDER ASSY | 1 | In Transit | 2013-03-15 00:00:00 | In Transit | In Transit
450030788 | 10 | 45073177 | REWINDER ASSY | 1 | In Transit | 2013-03-15 00:00:00 | In Transit | In Transit
450031470 | 20 | 45073177 | REWINDER ASSY | 1 |  | 2013-03-20 00:00:00 | 2013-02-24 00:00:00 | 2013-03-28 00:00:00
450031470 | 20 | 45073177 | REWINDER ASSY | 1 |  | 2013-03-20 00:00:00 | 2013-02-24 00:00:00 | 2013-03-28 00:00:00
450030788 | 10 | 45073177 | REWINDER ASSY | 1 |  | 2013-04-19 00:00:00 | 2013-03-17 00:00:00 | 2013-04-18 00:00:00
450031470 | 20 | 45073177 | REWINDER ASSY | 1 |  | 2013-04-19 00:00:00 | 2013-03-17 00:00:00 | 2013-04-18 00:00:00
450031470 | 20 | 45073177 | REWINDER ASSY | 1 |  | 2013-04-19 00:00:00 | 2013-03-17 00:00:00 | 2013-04-18 00:00:00
450031470 | 20 | 45073177 | REWINDER ASSY | 1 |  | 2013-04-19 00:00:00 | 2013-03-17 00:00:00 | 2013-04-18 00:00:00
450031470 | 20 | 45073177 | REWINDER ASSY | 1 |  | 2013-05-10 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031470 | 20 | 45073177 | REWINDER ASSY | 1 |  | 2013-05-10 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031470 | 20 | 45073177 | REWINDER ASSY | 1 |  | 2013-05-10 00:00:00 | 2013-04-07 00:00:00 | 2013-05-09 00:00:00
450031916 | 10 | 45073177 | REWINDER ASSY | 12 |  | 2013-06-24 00:00:00 | 2013-05-12 00:00:00 | 2013-06-13 00:00:00
450026068 | 10 | 45073177 | REWINDER ASSY | 1 |  | 2013-05-31 00:00:00 | 2013-04-29 00:00:00 | 2013-05-31 00:00:00
450027571 | 10 | 45073177 | REWINDER ASSY | 1 |  | 2013-05-31 00:00:00 | 2013-05-13 00:00:00 | 2013-06-14 00:00:00
450030833 | 20 | 45111864 | RETROFIT | 1 | In Transit | 2013-02-20 00:00:00 | In Transit | In Transit
450030833 | 20 | 45111864 | RETROFIT | 1 | In Transit | 2013-02-20 00:00:00 | In Transit | In Transit
450030833 | 30 | 45111864 | RETROFIT | 1 | In Transit | 2013-02-20 00:00:00 | In Transit | In Transit
450030833 | 30 | 45111864 | RETROFIT | 1 |  | 2013-02-22 00:00:00 | 2012-09-17 00:00:00 | 2012-10-19 00:00:00
450030833 | 30 | 45111864 | RETROFIT | 1 |  | 2013-02-22 00:00:00 | 2012-09-17 00:00:00 | 2012-10-19 00:00:00
450030833 | 30 | 45111864 | RETROFIT | 1 |  | 2013-02-22 00:00:00 | 2012-09-17 00:00:00 | 2012-10-19 00:00:00
450030833 | 30 | 45111864 | RETROFIT | 1 |  | 2013-02-22 00:00:00 | 2012-09-17 00:00:00 | 2012-10-19 00:00:00
450030833 | 30 | 45111864 | RETROFIT | 1 |  | 2013-02-22 00:00:00 | 2012-09-17 00:00:00 | 2012-10-19 00:00:00
450030833 | 80 | 45111864 | RETROFIT | 1 |  | 2013-02-22 00:00:00 | 2012-09-17 00:00:00 | 2012-10-19 00:00:00
450030862 | 10 | 45111864 | RETROFIT | 1 |  | 2013-03-01 00:00:00 | 2012-09-17 00:00:00 | 2012-10-19 00:00:00
450030862 | 10 | 45111864 | RETROFIT | 1 |  | 2013-03-01 00:00:00 | 2012-09-17 00:00:00 | 2012-10-19 00:00:00
450030862 | 10 | 45111864 | RETROFIT | 1 |  | 2013-03-01 00:00:00 | 2012-09-17 00:00:00 | 2012-10-19 00:00:00
450030862 | 10 | 45111864 | RETROFIT | 1 |  | 2013-03-01 00:00:00 | 2012-09-20 00:00:00 | 2012-10-22 00:00:00
450030862 | 10 | 45111864 | RETROFIT | 1 |  | 2013-03-01 00:00:00 | 2012-09-24 00:00:00 | 2012-10-26 00:00:00
450030862 | 20 | 45111864 | RETROFIT | 1 |  | 2013-03-15 00:00:00 | 2012-09-28 00:00:00 | 2012-10-30 00:00:00
450030862 | 20 | 45111864 | RETROFIT | 1 |  | 2013-03-15 00:00:00 | 2012-09-30 00:00:00 | 2012-11-01 00:00:00
450030862 | 20 | 45111864 | RETROFIT | 1 |  | 2013-03-15 00:00:00 | 2012-09-30 00:00:00 | 2012-11-01 00:00:00
450030862 | 20 | 45111864 | RETROFIT | 1 |  | 2013-03-15 00:00:00 | 2012-09-30 00:00:00 | 2012-11-01 00:00:00
450030862 | 20 | 45111864 | RETROFIT | 1 |  | 2013-03-15 00:00:00 | 2012-09-30 00:00:00 | 2012-11-01 00:00:00
450030862 | 20 | 45111864 | RETROFIT | 1 |  | 2013-03-15 00:00:00 | 2012-09-30 00:00:00 | 2012-11-01 00:00:00
450030862 | 20 | 45111864 | RETROFIT | 1 |  | 2013-03-15 00:00:00 | 2012-09-30 00:00:00 | 2012-11-01 00:00:00
450030862 | 30 | 45111864 | RETROFIT | 1 |  | 2013-03-22 00:00:00 | 2012-09-30 00:00:00 | 2012-11-01 00:00:00
450030862 | 30 | 45111864 | RETROFIT | 1 |  | 2013-03-22 00:00:00 | 2012-10-29 00:00:00 | 2012-11-30 00:00:00
450030862 | 30 | 45111864 | RETROFIT | 1 |  | 2013-03-22 00:00:00 | 2012-11-01 00:00:00 | 2012-12-03 00:00:00
450030862 | 30 | 45111864 | RETROFIT | 1 |  | 2013-03-22 00:00:00 | 2012-11-01 00:00:00 | 2012-12-03 00:00:00
450030862 | 30 | 45111864 | RETROFIT | 1 |  | 2013-03-22 00:00:00 | 2012-11-01 00:00:00 | 2012-12-03 00:00:00
450030862 | 30 | 45111864 | RETROFIT | 1 |  | 2013-03-22 00:00:00 | 2012-11-01 00:00:00 | 2012-12-03 00:00:00
450030862 | 30 | 45111864 | RETROFIT | 1 |  | 2013-03-22 00:00:00 | 2012-11-01 00:00:00 | 2012-12-03 00:00:00
450030862 | 40 | 45111864 | RETROFIT | 1 |  | 2013-03-28 00:00:00 | 2012-11-01 00:00:00 | 2012-12-03 00:00:00
450030862 | 40 | 45111864 | RETROFIT | 1 |  | 2013-03-28 00:00:00 | 2012-11-01 00:00:00 | 2012-12-03 00:00:00
450030862 | 40 | 45111864 | RETROFIT | 1 |  | 2013-03-28 00:00:00 | 2012-12-01 00:00:00 | 2013-01-02 00:00:00
450030862 | 40 | 45111864 | RETROFIT | 1 |  | 2013-03-28 00:00:00 | 2012-12-01 00:00:00 | 2013-01-02 00:00:00
450030862 | 40 | 45111864 | RETROFIT | 1 |  | 2013-03-28 00:00:00 | 2012-12-01 00:00:00 | 2013-01-02 00:00:00
450030862 | 40 | 45111864 | RETROFIT | 1 |  | 2013-03-28 00:00:00 | 2012-12-01 00:00:00 | 2013-01-02 00:00:00
450030862 | 40 | 45111864 | RETROFIT | 1 |  | 2013-03-28 00:00:00 | 2012-12-01 00:00:00 | 2013-01-02 00:00:00
450031178 | 10 | 45111864 | RETROFIT | 7 |  | 2013-04-04 00:00:00 | 2012-12-01 00:00:00 | 2013-01-02 00:00:00
450031178 | 20 | 45111864 | RETROFIT | 7 |  | 2013-04-04 00:00:00 | 2012-12-31 00:00:00 | 2013-02-01 00:00:00
450031848 | 10 | 45111864 | RETROFIT | 1 |  | 2013-06-10 00:00:00 | 2013-01-28 00:00:00 | 2013-03-01 00:00:00
450031848 | 20 | 45111864 | RETROFIT | 7 |  | 2013-06-10 00:00:00 | 2013-01-28 00:00:00 | 2013-03-01 00:00:00
450031848 | 30 | 45111864 | RETROFIT | 7 |  | 2013-06-10 00:00:00 | 2013-02-28 00:00:00 | 2013-04-01 00:00:00
450031848 | 40 | 45111864 | RETROFIT | 7 |  | 2013-06-10 00:00:00 | 2013-03-30 00:00:00 | 2013-05-01 00:00:00
450030862 | 10 | 45112062 | RETROFIT, 2 DRIVE | 2 |  | 2013-02-28 00:00:00 | 2012-08-13 00:00:00 | 2012-09-14 00:00:00
450030862 | 20 | 45112062 | RETROFIT, 2 DRIVE | 1 |  | 2013-02-28 00:00:00
450030833 | 10 | 45112062 | RETROFIT, 2 DRIVE | 1 |  | 2013-03-15 00:00:00