Spreadsheet: 202879d1356783678-using-lookups-and-if-queries-together-scheduling
Sheet: TU Schedule

Turkey  - 2013
 |  |  |  |  |  |  |  |  |  | YN |  |  | SH  HK  XM  NG  QD |  |  | MN
 |  |  |  |  |  |  |  |  |  | 4 wk Transit |  |  | 5 wk Tansit |  |  | 6 wk Tansit
 |  | CAMPAIGN | START | REQUIRED |  |  | AIR (MON) |  |  | SEA (MON) |  |  | SEA (MON) | SEA (MON) | SEA (MON) | SEA (MON)
 |  | NEED | DATE | IN HOUSE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start day | Monday Start
1Q13 |  | C13 - Rep Samples | 2012-11-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MON | 0
 | C1 | C14 - DEMO | 2012-12-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUE | -1
 |  | C1 - INTRO | 2012-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WED | -2
 |  | C14 - Rep Samples | 2012-12-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THU | -3
 | C2 | C1 - DEMO | 2012-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FRI | -4
 |  | C2 - INTRO | 2013-01-28 00:00:00 |  |  |  |  |  |  |  |  |  | 2012-12-03 00:00:00 |  |  | 2012-12-03 00:00:00 |  |  |  |  | SAT | -5
 |  | C1 - Rep Samples | 2012-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUN | -6
 | [NAME] | C2 - DEMO | 2013-01-28 00:00:00 |  |  |  |  |  |  |  |  |  | 2012-12-03 00:00:00 |  |  | 2012-12-03 00:00:00
 |  | [NAME] | 2013-02-25 00:00:00
2Q13 |  | C2 - Rep Samples | 2013-01-28 00:00:00 |  |  |  |  |  |  |  |  |  | 2012-12-03 00:00:00 |  |  | 2012-12-03 00:00:00
 | C4 | [NAME] | 2013-02-25 00:00:00
 |  | C4 - INTRO | 2013-03-25 00:00:00
 |  | C3 - Rep Samples | 2013-02-25 00:00:00
 | C5 | C4 - DEMO | 2013-03-25 00:00:00
 |  | C5 - INTRO | 2013-04-22 00:00:00 |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  | 2013-02-11 00:00:00
 |  | C4 - Rep Samples | 2013-03-25 00:00:00
 | C6 | C5 - DEMO | 2013-04-22 00:00:00 |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  | 2013-02-11 00:00:00
 |  | C6 - INTRO | 2013-05-20 00:00:00
3Q13 |  | C5 - Rep Samples | 2013-04-22 00:00:00 |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  | 2013-02-11 00:00:00
 | C7 | C6 - DEMO | 2013-05-20 00:00:00
 |  | C7 - INTRO | 2013-06-17 00:00:00
 |  | C6 - Rep Samples | 2013-05-20 00:00:00
 | C8 | C7 - DEMO | 2013-06-17 00:00:00
 |  | C8 - INTRO | 2013-07-15 00:00:00
 |  | C7 - Rep Samples | 2013-06-17 00:00:00
 | C9 | C8 - DEMO | 2013-07-15 00:00:00
 |  | C9 - INTRO | 2013-08-12 00:00:00
 |  | C8 - Rep Samples | 2013-07-15 00:00:00
 | C10 | C9 - DEMO | 2013-08-12 00:00:00
 |  | C10 - INTRO | 2013-09-09 00:00:00
4Q13 |  | C9 - Rep Samples | 2013-08-12 00:00:00
 | C11 | C10 - DEMO | 2013-09-09 00:00:00
 |  | C11 - INTRO | 2013-09-30 00:00:00
 |  | C10 - Rep Samples | 2013-09-09 00:00:00
 | C12 | C11 - DEMO | 2013-09-30 00:00:00
 |  | C12 - INTRO | 2013-10-28 00:00:00
 |  | C11 - Rep Samples | 2013-09-30 00:00:00
 | C13 | C12 - DEMO | 2013-10-28 00:00:00
 |  | C13 - INTRO | 2013-11-18 00:00:00
 |  | C12 - Rep Samples | 2013-10-28 00:00:00
 | C14 | C13 - DEMO | 2013-11-18 00:00:00
 |  | C14 - INTRO | 2013-12-09 00:00:00
Goods are to be in 4 wks before needed
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