Spreadsheet: 87512d1287406820-finding-data-from-mutliple-sheets-oct2010-task-planner
Sheet: Lidl B-C

 | Campaign Planner - Lidl Blackpool/Camden
 | Start Date= | 2010-10-01 00:00:00 |  |  |  |  |  | Today = |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [42]
[42] |  |  |  |  |  |  |  |  |  | First Day of Week (Mon=2): | 2
Elements left to complete
 | Tasks | Task Lead | Start | End | Duration (Days) |  |  | Time Passed | Days Complete | Days Remaining | Task Completed | Completed on time | Actual Completion
 | Client Contact | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Review of confirmed work proposal |  | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 |  |  |  |  |  |  | Y
 | Client introduction |  | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 |  |  |  |  |  |  | Y
 | Discuss key requirments |  | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 |  |  |  |  |  |  | Y
 | [NAME] and times |  | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 |  |  |  |  |  |  | Y
 | Instructions | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Review staffing worklist - Discuss points with staffing mngr - tracking? |  | 2010-10-07 00:00:00 | 2010-10-11 00:00:00 |  |  |  |  |  |  | Y
 | Mapping - Consider staff coverage and numbers |  | 2010-10-07 00:00:00 | 2010-10-11 00:00:00 |  |  |  |  |  |  | Y
 | Send mapping  to client for final sign off - Digital signature recieved |  | 2010-10-07 00:00:00 | 2010-10-11 00:00:00 |  |  |  |  |  |  | Y
 | Create staff instrcutions document (Team Leader if required document) |  | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 |  |  |  |  |  |  | Y
 | Investigate legal requirements |  | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 |  |  |  |  |  |  | Y
 | Email instructions to staff |  | 2010-10-11 00:00:00 | 2010-10-12 00:00:00 |  |  |  |  |  |  | Y
 | Post instructions to staff |  | 2010-10-08 00:00:00 | 2010-10-12 00:00:00 |  |  |  |  |  |  | Y
 | Equipment | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Order uniforms |  | 2010-10-05 00:00:00 | 2010-10-07 00:00:00 |  |  |  |  |  |  | Y
 | Order bags |  | 2010-10-05 00:00:00 | 2010-10-07 00:00:00 |  |  |  |  |  |  | Y
 | Recieve unforms |  | 2010-10-08 00:00:00 | 2010-10-11 00:00:00 |  |  |  |  |  |  | Y
 | Receive bags |  | 2010-10-08 00:00:00 | 2010-10-11 00:00:00 |  |  |  |  |  |  | Y
 | [NAME] |  | 2010-10-05 00:00:00 | 2010-10-11 00:00:00 |  |  |  |  |  |  | Y
 | Coordinate delivery/collection of equipment & Return arrangments |  | 2010-10-08 00:00:00 | 2010-10-11 00:00:00 |  |  |  |  |  |  | Y
 | Send equipment Blackpool |  | 2010-10-11 00:00:00 | 2010-10-12 00:00:00 |  |  |  |  |  |  | Y
 | Send equipment Camden |  | 2010-10-15 00:00:00 | 2010-10-16 00:00:00 |  |  |  |  |  |  | N
 | Pre Campaign Verbal Briefing | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Call all staff to confirm reciept of instructions - deliver briefing |  | 2010-10-12 00:00:00 | 2010-10-13 00:00:00 |  |  |  |  |  |  | Y
 | Call all staff on the morning of the campaign |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 |  |  |  |  |  |  | N
 | [NAME] client pre campaigne - 'Emotional Banking' |  | 2010-10-13 00:00:00 | 2010-10-14 00:00:00 |  |  |  |  |  |  | N
 | Live Campaign | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Campaign 'Go Live' Blackpool |  | 2010-10-14 00:00:00 | 2010-10-20 00:00:00 |  |  |  |  |  |  | N
 | Campaign 'Go Live' Camden |  | 2010-10-19 00:00:00 | 2010-10-21 00:00:00 |  |  |  |  |  |  | N
 | [NAME] new staff Blackpool |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 |  |  |  |  |  |  | N
 | [NAME] new staff Camden |  | 2010-10-19 00:00:00 | 2010-10-20 00:00:00 |  |  |  |  |  |  | N
 | Staff check in - who's on shift and welfare update Blackpool |  | 2010-10-14 00:00:00 | 2010-10-20 00:00:00 |  |  |  |  |  |  | N
 | Staff check in - who's on shift and welfare update Camden |  | 2010-10-19 00:00:00 | 2010-10-21 00:00:00 |  |  |  |  |  |  | N
 | Client update  on running of the event |  | 2010-10-14 00:00:00 | 2010-10-21 00:00:00 |  |  |  |  |  |  | N
 | Campaign final day - Blackpool |  | 2010-10-20 00:00:00 | 2010-10-21 00:00:00 |  |  |  |  |  |  | N
 | Campaign final day - Camden |  | 2010-10-21 00:00:00 | 2010-10-22 00:00:00 |  |  |  |  |  |  | N
 | Close down call to staff - Feedback & photos reminder |  | 2010-10-14 00:00:00 | 2010-10-21 00:00:00 |  |  |  |  |  |  | N
 | Post Campaign | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Review inbound feedback & photos |  | 2010-10-14 00:00:00 | 2010-10-21 00:00:00 |  |  |  |  |  |  | N
 | Chase outstanding feedback & photos |  | 2010-10-14 00:00:00 | 2010-10-21 00:00:00 |  |  |  |  |  |  | N
 | Coordinate return of excess equiment |  | 2010-10-21 00:00:00 | 2010-10-24 00:00:00 |  |  |  |  |  |  | N
 | Write up the report save & file Reports to check |  | 2010-10-21 00:00:00 | 2010-10-26 00:00:00 |  |  |  |  |  |  | N
 | [NAME] account director with confirmation CC JB |  | 2010-10-26 00:00:00 | 2010-10-27 00:00:00 |  |  |  |  |  |  | N