Spreadsheet: 87512d1287406820-finding-data-from-mutliple-sheets-oct2010-task-planner
Sheet: Jane Shilton

 | Campaign Planner - ***
 | Start Date= | 2010-10-11 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-13 00:00:00 | 2010-10-14 00:00:00 |  |  |  |  |  |  | Y
 | Client introduction |  | 2010-10-13 00:00:00 | 2010-10-14 00:00:00 |  |  |  |  |  |  | Y
 | Discuss key requirments |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 |  |  |  |  |  |  | N
 | Agree Locations |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 |  |  |  |  |  |  | N
 | Instructions | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Review staffing worklist - Discuss points with staffing mngr - tracking? |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 |  |  |  |  |  |  | N
 | Mapping - Consider staff coverage and numbers |  | 2010-10-14 00:00:00 | 2010-10-16 00:00:00 |  |  |  |  |  |  | N
 | Send mapping  to client for final sign off - Digital signature recieved |  | 2010-10-16 00:00:00 | 2010-10-17 00:00:00 |  |  |  |  |  |  | N
 | Create staff instrcutions document (Team Leader if required document) |  | 2010-10-14 00:00:00 | 2010-10-16 00:00:00 |  |  |  |  |  |  | N
 | Investigate legal requirements |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 |  |  |  |  |  |  | N
 | Email instructions to staff |  | 2010-10-14 00:00:00 | 2010-10-16 00:00:00 |  |  |  |  |  |  | N
 | Post instructions to staff |  | 2010-10-14 00:00:00 | 2010-10-16 00:00:00 |  |  |  |  |  |  | N
 | Equipment | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Order uniforms |  | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 |  |  |  |  |  |  | N
 | Recieve unforms |  | 2010-10-18 00:00:00 | 2010-10-19 00:00:00 |  |  |  |  |  |  | N
 | [NAME] is ready |  | 2010-10-20 00:00:00 | 2010-10-21 00:00:00 |  |  |  |  |  |  | N
 | Coordinate delivery/collection of equipment & Return arrangments |  | 2010-10-18 00:00:00 | 2010-10-19 00:00:00 |  |  |  |  |  |  | N
 | Send equipment |  | 2010-10-18 00:00:00 | 2010-10-19 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-23 00:00:00 | 2010-10-24 00:00:00 |  |  |  |  |  |  | N
 | Call all staff on the morning of the campaign |  | 2010-10-23 00:00:00 | 2010-10-24 00:00:00 |  |  |  |  |  |  | N
 | [NAME] client pre campaigne - 'Emotional Banking' |  | 2010-10-22 00:00:00 | 2010-10-23 00:00:00 |  |  |  |  |  |  | N
 | Live Campaign | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Campaign 'Go Live' |  | 2010-10-23 00:00:00 | 2010-10-24 00:00:00 |  |  |  |  |  |  | N
 | Staff check in - who's on shift and welfare update |  | 2010-10-23 00:00:00 | 2010-10-24 00:00:00 |  |  |  |  |  |  | N
 | Client update  on running of the event |  | 2010-10-28 00:00:00 | 2010-10-29 00:00:00 |  |  |  |  |  |  | N
 | Final day of campaign |  | 2010-10-30 00:00:00 | 2010-10-31 00:00:00 |  |  |  |  |  |  | N
 | Close down call to staff - Feedback & photos reminder |  | 2010-10-30 00:00:00 | 2010-10-31 00:00:00 |  |  |  |  |  |  | N
 | Post Campaign | Initials |  |  |  |  |  |  |  |  | Y or N | Y or N | Date
 | Review inbound feedback & photos |  | 2010-10-23 00:00:00 | 2010-10-31 00:00:00 |  |  |  |  |  |  | N
 | Chase outstanding feedback & photos |  | 2010-10-31 00:00:00 | 2010-11-05 00:00:00 |  |  |  |  |  |  | N
 | Coordinate return of excess equiment |  | 2010-10-31 00:00:00 | 2010-11-05 00:00:00 |  |  |  |  |  |  | N
 | Write up the report save & file Reports to check |  | 2010-10-31 00:00:00 | 2010-11-05 00:00:00 |  |  |  |  |  |  | N
 | [NAME] account director with confirmation CC JB |  | 2010-11-05 00:00:00 | 2010-11-06 00:00:00 |  |  |  |  |  |  | N