Spreadsheet: 202879d1356783678-using-lookups-and-if-queries-together-scheduling
Sheet: UK SCHEDULE

UK  - 2013
 |  |  |  |  |  |  |  |  |  | YN |  |  | SH  HK  XM  NG  QD |  |  | MN | Port |  |  |  |  | YN |  |  | SH  HK  XM  NG  QD |  |  | MN
 |  |  |  |  |  |  |  |  |  | 4 wk Transit |  |  | 5 wk Tansit |  |  | 6 wk Tansit |  |  |  |  |  | 4 wk Transit |  |  | 5 wk Tansit |  |  | 6 wk Tansit
 |  | CAMPAIGN | START | REQUIRED |  |  | AIR (MON) |  |  | SEA (MON) |  |  | SEA (MON) | SEA (MON) | SEA (MON) | SEA (MON) |  |  |  |  |  | SEA (MON) |  |  | SEA (MON) | SEA (MON) | SEA (MON) | SEA (MON)
 |  | NEED | DATE | IN HOUSE |  |  |  |  |  |  |  |  |  |  |  |  |  | Start day | Monday Start
 |  | C15 - T/S | 2012-09-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  | 2012-08-13 00:00:00 | Wed | 2012-08-08 00:00:00 | 2012-08-06 00:00:00 | Wed | 2012-08-01 00:00:00 | 2012-07-30 00:00:00
4Q12 | C1 | C17 - DEMO | 2012-10-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 2012-09-10 00:00:00 | Thu | 2012-09-06 00:00:00 | 2012-09-03 00:00:00 | Thu | 2012-08-30 00:00:00 | 2012-08-27 00:00:00
 |  | C16 - T/S | 2012-10-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2012-09-03 00:00:00 | Wed | 2012-08-29 00:00:00 | 2012-08-27 00:00:00 | Wed | 2012-08-22 00:00:00 | 2012-08-20 00:00:00
 | C2 | C18 - DEMO | 2012-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2012-10-01 00:00:00 | Thu | 2012-09-27 00:00:00 | 2012-09-24 00:00:00 | Thu | 2012-09-20 00:00:00 | 2012-09-17 00:00:00
 |  | C17 - T/S | 2012-11-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 2012-09-24 00:00:00 | Wed | 2012-09-19 00:00:00 | 2012-09-17 00:00:00 | Wed | 2012-09-12 00:00:00 | 2012-09-10 00:00:00
1Q13 | [NAME] | C1 - DEMO | 2012-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 2012-10-22 00:00:00 | Thu | 2012-10-18 00:00:00 | 2012-10-15 00:00:00 | Thu | 2012-10-11 00:00:00 | 2012-10-08 00:00:00
 |  | C18 - T/S | 2012-11-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 | 2012-10-15 00:00:00 | Wed | 2012-10-10 00:00:00 | 2012-10-08 00:00:00 | Wed | 2012-10-03 00:00:00 | 2012-10-01 00:00:00
 | C4 | C2 - DEMO | 2012-12-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.2 | 4.2 | 4.2 | 4.2 | 4.2 | 2012-11-05 00:00:00 | Thu | 2012-11-01 00:00:00 | 2012-10-29 00:00:00 | Thu | 2012-10-25 00:00:00 | 2012-10-22 00:00:00
 |  | C1 - T/S | 2012-12-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.1 |  |  |  |  | 2012-10-29 00:00:00 | Wed | 2012-10-24 00:00:00 | 2012-10-22 00:00:00 | Wed | 2012-10-17 00:00:00 | 2012-10-15 00:00:00
 | C5 | [NAME] | 2013-01-10 00:00:00 | 2012-12-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-11-12 00:00:00 | 5.2 |  |  |  |  | 2012-11-19 00:00:00 | Thu | 2012-11-15 00:00:00 | 2012-11-12 00:00:00 | Thu | 2012-11-08 00:00:00 | 2012-11-12 00:00:00
 |  | C2 - T/S | 2013-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.1 |  |  |  |  | 2012-11-19 00:00:00 | Wed | 2012-11-14 00:00:00 | 2012-11-12 00:00:00 | Wed | 2012-11-07 00:00:00 | 2012-11-05 00:00:00
 | C6 | C4 - DEMO | 2013-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.2 |  |  |  |  | 2012-12-10 00:00:00 | Thu | 2012-12-06 00:00:00 | 2012-12-03 00:00:00 | Thu | 2012-11-29 00:00:00 | 2012-11-26 00:00:00
 |  | [NAME] | 2013-01-16 00:00:00 | 2013-01-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-03 00:00:00 | 7.1 |  |  |  |  | 2012-12-10 00:00:00 | Wed | 2012-12-05 00:00:00 | 2012-12-03 00:00:00 | Wed | 2012-11-28 00:00:00 | 2012-12-03 00:00:00
 | C7 | C5 - DEMO | 2013-02-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.2 |  |  |  |  | 2012-12-31 00:00:00 | Thu | 2012-12-27 00:00:00 | 2012-12-24 00:00:00 | Thu | 2012-12-20 00:00:00 | 2012-12-17 00:00:00
 |  | C4 - T/S | 2013-02-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.1 |  |  |  |  | 2012-12-24 00:00:00 | Wed | 2012-12-19 00:00:00 | 2012-12-17 00:00:00 | Wed | 2012-12-12 00:00:00 | 2012-12-10 00:00:00
 | C8 | C6 - DEMO | 2013-03-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.2 |  |  |  |  | 2013-01-21 00:00:00 | Thu | 2013-01-17 00:00:00 | 2013-01-14 00:00:00 | Thu | 2013-01-10 00:00:00 | 2013-01-07 00:00:00
 |  | C5 - T/S | 2013-02-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.1 |  |  |  |  | 2013-01-14 00:00:00 | Wed | 2013-01-09 00:00:00 | 2013-01-07 00:00:00 | Wed | 2013-01-02 00:00:00 | 2012-12-31 00:00:00
 | C9 | C7 - DEMO | 2013-03-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.2 |  |  |  |  | 2013-02-11 00:00:00 | Thu | 2013-02-07 00:00:00 | 2013-02-04 00:00:00 | Thu | 2013-01-31 00:00:00 | 2013-01-28 00:00:00
 |  | C6 - T/S | 2013-03-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.1 |  |  |  |  | 2013-02-04 00:00:00 | Wed | 2013-01-30 00:00:00 | 2013-01-28 00:00:00 | Wed | 2013-01-23 00:00:00 | 2013-01-21 00:00:00
 | C10 | C8 - DEMO | 2013-04-18 00:00:00 |  |  |  |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  |  | 10.2 |  |  |  |  | 2013-03-04 00:00:00 | Thu | 2013-02-28 00:00:00 | 2013-02-11 00:00:00 | Thu | 2013-02-21 00:00:00 | 2013-02-18 00:00:00
 |  | C7  - T/S | 2013-04-10 00:00:00 |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  | 2013-02-11 00:00:00 |  |  |  | 11.1 |  |  |  |  | 2013-02-11 00:00:00 | Wed | 2013-02-20 00:00:00 | 2013-02-11 00:00:00 | Wed | 2013-02-13 00:00:00 | 2013-02-11 00:00:00
 | C11 | C9 - DEMO | 2013-05-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11.2 |  |  |  |  | 2013-03-25 00:00:00 | Thu | 2013-03-21 00:00:00 | 2013-03-18 00:00:00 | Thu | 2013-03-14 00:00:00 | 2013-03-11 00:00:00
 |  | C8 - T/S | 2013-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.1 |  |  |  |  | 2013-03-18 00:00:00 | Wed | 2013-03-13 00:00:00 | 2013-03-11 00:00:00 | Wed | 2013-03-06 00:00:00 | 2013-03-04 00:00:00
 | C12 | C10 - DEMO | 2013-05-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.2 |  |  |  |  | 2013-04-15 00:00:00 | Thu | 2013-04-11 00:00:00 | 2013-04-08 00:00:00 | Thu | 2013-04-04 00:00:00 | 2013-04-01 00:00:00
3Q13 |  | C9 - T/S | 2013-05-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.1 |  |  |  |  | 2013-04-08 00:00:00 | Wed | 2013-04-03 00:00:00 | 2013-04-01 00:00:00 | Wed | 2013-03-27 00:00:00 | 2013-03-25 00:00:00
 | C13 | C11 - DEMO | 2013-06-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.2 |  |  |  |  | 2013-05-06 00:00:00 | Thu | 2013-05-02 00:00:00 | 2013-04-29 00:00:00 | Thu | 2013-04-25 00:00:00 | 2013-04-22 00:00:00
 |  | C10 - T/S | 2013-06-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.1 |  |  |  |  | 2013-04-29 00:00:00 | Wed | 2013-04-24 00:00:00 | 2013-04-22 00:00:00 | Wed | 2013-04-17 00:00:00 | 2013-04-15 00:00:00
 | C14 | C12 - DEMO | 2013-07-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.2 |  |  |  |  | 2013-05-27 00:00:00 | Thu | 2013-05-23 00:00:00 | 2013-05-20 00:00:00 | Thu | 2013-05-16 00:00:00 | 2013-05-13 00:00:00
 |  | C11 - T/S | 2013-07-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.1 |  |  |  |  | 2013-05-20 00:00:00 | Wed | 2013-05-15 00:00:00 | 2013-05-13 00:00:00 | Wed | 2013-05-08 00:00:00 | 2013-05-06 00:00:00
 | C15 | C13 - DEMO | 2013-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.2 |  |  |  |  | 2013-06-17 00:00:00 | Thu | 2013-06-13 00:00:00 | 2013-06-10 00:00:00 | Thu | 2013-06-06 00:00:00 | 2013-06-03 00:00:00
 |  | C12 - T/S | 2013-07-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.1 |  |  |  |  | 2013-06-10 00:00:00 | Wed | 2013-06-05 00:00:00 | 2013-06-03 00:00:00 | Wed | 2013-05-29 00:00:00 | 2013-05-27 00:00:00
 | C16 | C14 - DEMO | 2013-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.2 |  |  |  |  | 2013-07-08 00:00:00 | Thu | 2013-07-04 00:00:00 | 2013-07-01 00:00:00 | Thu | 2013-06-27 00:00:00 | 2013-06-24 00:00:00
 |  | C13 - T/S | 2013-08-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.1 |  |  |  |  | 2013-07-01 00:00:00 | Wed | 2013-06-26 00:00:00 | 2013-06-24 00:00:00 | Wed | 2013-06-19 00:00:00 | 2013-06-17 00:00:00
4Q13 | C17 | C15 - DEMO | 2013-09-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.2 |  |  |  |  | 2013-07-29 00:00:00 | Thu | 2013-07-25 00:00:00 | 2013-07-22 00:00:00 | Thu | 2013-07-18 00:00:00 | 2013-07-15 00:00:00
 |  | C14 - T/S | 2013-09-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18.1 |  |  |  |  | 2013-07-22 00:00:00 | Wed | 2013-07-17 00:00:00 | 2013-07-15 00:00:00 | Wed | 2013-07-10 00:00:00 | 2013-07-08 00:00:00
 | C18 | C16 - DEMO | 2013-10-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18.2 |  |  |  |  | 2013-08-19 00:00:00 | Thu | 2013-08-15 00:00:00 | 2013-08-12 00:00:00 | Thu | 2013-08-08 00:00:00 | 2013-08-05 00:00:00
 |  | C15 - T/S | 2013-09-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.11 |  |  |  |  | 2013-08-12 00:00:00 | Wed | 2013-08-07 00:00:00 | 2013-08-05 00:00:00 | Wed | 2013-07-31 00:00:00 | 2013-07-29 00:00:00
 | C1 | C17 - DEMO | 2013-10-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.22 |  |  |  |  | 2013-09-09 00:00:00 | Thu | 2013-09-05 00:00:00 | 2013-09-02 00:00:00 | Thu | 2013-08-29 00:00:00 | 2013-08-26 00:00:00
Goods are to be in 2 wks before needed
10/8/2012 - FLL buys for C5 to be split 50/50.   First 50% as scheduled for intro + 50% to be ex 14 Jan
20/8/2012 - schedules re-issued based on confirmation that HUB xmas is 20 Dec - 2 Jan
2012-10-24 00:00:00 | Due to Chinese New Year we are ruling out ship dates of 18 + 25 Feb