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

[NAME]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
 |  | C6 - T/S | 2012-10-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MON | 0
 | C9/C14 | C7 - DEMO | 2012-11-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUE | -1
 |  | C9 - INTRO | 2012-12-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WED | -2
 |  | C7 - T/S | 2012-11-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THU | -3
 | C10/C15 | C8 - DEMO | 2012-11-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FRI | -4
 |  | C10 - INTRO | 2013-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAT | -5
 |  | C8 - T/S | 2012-11-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUN | -6
1Q13 | C11/C16 | C9 - DEMO | 2012-12-17 00:00:00
 |  | C11 - INTRO | 2013-01-29 00:00:00
 |  | C9 - T/S | 2012-12-17 00:00:00
 | C12/C17 | C10 - DEMO | 2013-01-10 00:00:00
 |  | C12 - INTRO | 2013-02-15 00:00:00
 |  | C10 - T/S | 2013-01-10 00:00:00
 | C13/C18 | C11 - DEMO | 2013-01-29 00:00:00
 |  | C13 - INTRO | 2013-03-06 00:00:00
 |  | C11 - T/S | 2013-01-29 00:00:00
 | C14/C1 | C12 - DEMO | 2013-02-15 00:00:00
 |  | C14 - INTRO | 2013-03-25 00:00:00
 |  | C12 - T/S | 2013-02-15 00:00:00
 | C15/C2 | C13 - DEMO | 2013-03-06 00:00:00
2Q13 |  | C15 - INTRO | 2013-04-15 00:00:00 |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  | 2013-02-11 00:00:00
 |  | C13 - T/S | 2013-03-06 00:00:00
 | C16/C3 | C14- DEMO | 2013-03-25 00:00:00
 |  | C16 - INTRO | 2013-05-06 00:00:00
 |  | C14 - T/S | 2013-03-25 00:00:00
 | C17/C4 | C15 - DEMO | 2013-04-15 00:00:00 |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  | 2013-02-11 00:00:00
 |  | C17 - INTRO | 2013-05-24 00:00:00
 |  | C15 - T/S | 2013-04-15 00:00:00 |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  | 2013-02-11 00:00:00
 | C18/C5 | C16 - DEMO | 2013-05-06 00:00:00
 |  | C18 - INTRO | 2013-06-12 00:00:00
 |  | C16 - T/S | 2013-05-06 00:00:00
 | C1/C6 | C17 - DEMO | 2013-05-24 00:00:00
 |  | C1 - INTRO | 2013-07-01 00:00:00
 |  | C17 - T/S | 2013-05-24 00:00:00
3Q13 | C2/C7 | C18 - DEMO | 2013-06-12 00:00:00
 |  | C2 - INTRO | 2013-07-18 00:00:00
 |  | C18 - T/S | 2013-06-12 00:00:00
 | C3/C8 | C1 - DEMO | 2013-07-01 00:00:00
 |  | [NAME] | 2013-08-06 00:00:00
 |  | C1 - T/S | 2013-07-01 00:00:00
 | C4/C9 | C2 - DEMO | 2013-07-18 00:00:00
 |  | C4 - INTRO | 2013-08-27 00:00:00
 |  | C2 - T/S | 2013-07-18 00:00:00
 | C5/C10 | [NAME] | 2013-08-06 00:00:00
 |  | C5 - INTRO | 2013-09-13 00:00:00
 |  | [NAME] | 2013-08-06 00:00:00
 | C6/C11 | C4 - DEMO | 2013-08-27 00:00:00
 |  | C6 - INTRO | 2013-10-02 00:00:00
 |  | C4 - T/S | 2013-08-27 00:00:00
 | C7/C12 | C5 - DEMO | 2013-09-13 00:00:00
4Q13 |  | C7 - INTRO | 2013-10-22 00:00:00
 |  | C5 - T/S | 2013-09-13 00:00:00
 | C8/C13 | C6 - DEMO | 2013-10-02 00:00:00
 |  | C8 - INTRO | 2013-11-11 00:00:00
 |  | C6 - T/S | 2013-10-02 00:00:00
 | C9/C14 | C7 - DEMO | 2013-10-22 00:00:00
 |  | C9 - INTRO | 2013-11-28 00:00:00
Goods are to be in 3 wks before needed
2012-10-24 00:00:00 | Due to Chinese New Year we are ruling out ship dates of 18 + 25 Feb