Spreadsheet: 117829d1313060036-help-with-changing-data-in-measure-cell-according-to-other-data-ronel
Sheet: QC Project Plan

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Plan Template
 | M1 | M2 | M3 | M4
 |  | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month | 2011-08-01 00:00:00 | 5 | Operations | FI | Training | Facilitating Profit Improvement Projects |  | Workshop | Dutch |  | 235 |  |  |  |  | 00:00:00
Wd |  | 5 | Operations | LMC | Training | SSC |  | FG | German |  | 45 |  |  |  |  | 00:00:00
Leave | 0 | 5 | Operations | LMC | Training | TOT |  | Workshop | German |  | 440 |  |  |  |  | 00:00:00
Sick days | 0 | 5 | Operations | AC | Training | Asset Care Strategy |  | Workshop | Dutch |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month | 2011-08-01 00:00:00 | 5 | Operations | TW | TL WS | Interpersonal Skills for Team Leaders |  | Workshop | French |  | 232 |  |  |  |  | 00:00:00
Wd |  | 5 | Operations | TW | TL WS | Coaching Skills for Team Leaders |  | Workshop | French |  | 102 |  |  |  |  | 00:00:00
Leave | 0 | 5 | Operations | 5S | TT WS | Introduction to Ergonomics |  | Workshop | French |  | 91 |  |  |  |  | 00:00:00
Sick days | 0 | 5 | Operations | LMC | TT WS | WCO Induction |  | Workshop | French |  | 126 |  |  |  |  | 00:00:00
 |  | 5 | Operations | TW | TT WS | Interpersonal Skills for Teams |  | Workshop | French |  | 168 |  |  |  |  | 00:00:00
 |  | 5 | Operations | VM | TT WS | Overall Equipment Effectiveness |  | Workshop | French |  | 104 |  |  |  |  | 00:00:00
 |  | 5 | Operations | AM | TT WS | Autonomous Maintenance Steps 0,1 & 2 |  | Workshop | French |  | 77 |  |  |  |  | 00:00:00
 |  | 5 | Operations | AM | TT WS | Autonomous Maintenance Steps 3 & 4 |  | Workshop | French |  | 48 |  |  |  |  | 00:00:00
 |  | 5 | Operations | STR | TT WS | Set-up Time Reduction |  | Workshop | French |  | 82 |  |  |  |  | 00:00:00
 |  | 5 | Operations | QU | TT WS | Quality |  | Workshop | French |  | 50 |  |  |  |  | 00:00:00
 |  | 5 | Operations | QU | TT WS | Introduction to Statistical Process Control |  | Workshop | French |  | 75 |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month | 2011-08-01 00:00:00 | 5 | Operations | LMC | Training | TOT |  | Workshop | Polish |  | 497 |  |  |  |  | 00:00:00
Wd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Leave | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Sick days | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month | 2011-08-01 00:00:00 | 5 | Operations | TW | TL WS | The Role of the Team Leader |  | Workshop | Portuguese |  | 125 |  |  |  |  | 00:00:00
Wd |  | 5 | Operations | TW | TL WS | Leading a Team Meeting with VM |  | Workshop | Portuguese |  | 111 |  |  |  |  | 00:00:00
Leave | 0 | 5 | Operations | TW | TL WS | Interpersonal Skills for Team Leaders |  | Workshop | Portuguese |  | 235 |  |  |  |  | 00:00:00
Sick days | 0 | 5 | Operations | 5S | TL WS | Managing 5S |  | Workshop | Portuguese |  | 70 |  |  |  |  | 00:00:00
 |  | 5 | Operations | FI | TL WS | Facilitating Situational Problem-solving |  | Workshop | Portuguese |  | 86 |  |  |  |  | 00:00:00
 |  | 5 | Operations | TW | TT WS | Introduction to WCO |  | Workshop | Portuguese |  | 68 |  |  |  |  | 00:00:00
 |  | 5 | Operations | TW | TT WS | Teambuilding |  | Workshop | Portuguese |  | 66 |  |  |  |  | 00:00:00
 |  | 5 | Operations | TW | TT WS | Productive Team Meetings |  | Workshop | Portuguese |  | 55 |  |  |  |  | 00:00:00
 |  | 5 | Operations | EHS | TT WS | EHS Awareness |  | Workshop | Portuguese |  | 73 |  |  |  |  | 00:00:00
 |  | 5 | Operations | EHS | TT WS | [NAME] |  | Workshop | Portuguese |  | 46 |  |  |  |  | 00:00:00
 |  | 5 | Operations | 5S | TT WS | 5S |  | Workshop | Portuguese |  | 57 |  |  |  |  | 00:00:00
 |  | 5 | Operations | VM | TT WS | Visual Management |  | Workshop | Portuguese |  | 62 |  |  |  |  | 00:00:00
 |  | 5 | Operations | FI | TT WS | Loss and Waste Awareness |  | Workshop | Portuguese |  | 52 |  |  |  |  | 00:00:00
 |  | 5 | Operations | LMC | Training | TOT |  | Workshop | Portuguese |  | 440 |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month | 2011-08-01 00:00:00 | 5 | Operations | FI | TL WS | Facilitating Situational Problem-solving |  | Workshop | Dutch |  | 86 |  |  |  |  | 00:00:00
Wd |  | 5 | Operations | EHS | TT WS | EHS Awareness |  | Workshop | Dutch |  | 73 |  |  |  |  | 00:00:00
Leave | 0 | 5 | Operations | TW | TT WS | Teambuilding |  | Workshop | Dutch |  | 66 |  |  |  |  | 00:00:00
Sick days | 0 | 5 | Operations | EHS | TT WS | [NAME] |  | Workshop | Dutch |  | 46 |  |  |  |  | 00:00:00
 |  | 5 | Operations | FI | TT WS | Loss and Waste Awareness |  | Workshop | Dutch |  | 52 |  |  |  |  | 00:00:00
 |  | 5 | Operations | TW | TT WS | Productive Team Meetings |  | Workshop | Dutch |  | 55 |  |  |  |  | 00:00:00
 |  | 5 | Operations | TW | TL WS | Interpersonal Skills for Team Leaders |  | Workshop | Dutch |  | 232 |  |  |  |  | 00:00:00
 |  | 5 | Operations | TW | TL WS | Coaching Skills for Team Leaders |  | Workshop | Dutch |  | 102 |  |  |  |  | 00:00:00
 |  | 5 | Operations | 5S | TT WS | Introduction to Ergonomics |  | Workshop | Dutch |  | 91 |  |  |  |  | 00:00:00
 |  | 5 | Operations | LMC | TT WS | WCO Induction |  | Workshop | Dutch |  | 126 |  |  |  |  | 00:00:00
 |  | 5 | Operations | TW | TT WS | Interpersonal Skills for Teams |  | Workshop | Dutch |  | 168 |  |  |  |  | 00:00:00
 |  | 5 | Operations | VM | TT WS | Overall Equipment Effectiveness |  | Workshop | Dutch |  | 104 |  |  |  |  | 00:00:00
 |  | 5 | Operations | AM | TT WS | Autonomous Maintenance Steps 0,1 & 2 |  | Workshop | Dutch |  | 77 |  |  |  |  | 00:00:00
 |  | 5 | Operations | AM | TT WS | Autonomous Maintenance Steps 3 & 4 |  | Workshop | Dutch |  | 48 |  |  |  |  | 00:00:00
 |  | 5 | Operations | STR | TT WS | Set-up Time Reduction |  | Workshop | Dutch |  | 82 |  |  |  |  | 00:00:00
 |  | 5 | Operations | QU | TT WS | Quality |  | Workshop | Dutch |  | 50 |  |  |  |  | 00:00:00
 |  | 5 | Operations | QU | TT WS | Introduction to Statistical Process Control |  | Workshop | Dutch |  | 75 |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month | 2011-08-01 00:00:00 | 5 | Operations | TW | TL WS | Interpersonal Skills for Team Leaders |  | Workshop | Italian |  | 232 |  |  |  |  | 00:00:00
Wd |  | 5 | Operations | TW | TL WS | Coaching Skills for Team Leaders |  | Workshop | Italian |  | 102 |  |  |  |  | 00:00:00
Leave | 0 | 5 | Operations | 5S | TT WS | Introduction to Ergonomics |  | Workshop | Italian |  | 91 |  |  |  |  | 00:00:00
Sick days | 0 | 5 | Operations | VM | TT WS | Overall Equipment Effectiveness |  | Workshop | Italian |  | 104 |  |  |  |  | 00:00:00
 |  | 5 | Operations | AM | TT WS | Autonomous Maintenance Steps 0,1 & 2 |  | Workshop | Italian |  | 77 |  |  |  |  | 00:00:00
 |  | 5 | Operations | AM | TT WS | Autonomous Maintenance Steps 3 & 4 |  | Workshop | Italian |  | 48 |  |  |  |  | 00:00:00
 |  | 5 | Operations | STR | TT WS | Set-up Time Reduction |  | Workshop | Italian |  | 82 |  |  |  |  | 00:00:00
 |  | 5 | Operations | QU | TT WS | Quality |  | Workshop | Italian |  | 50 |  |  |  |  | 00:00:00
 |  | 5 | Operations | QU | TT WS | Introduction to Statistical Process Control |  | Workshop | Italian |  | 75 |  |  |  |  | 00:00:00
 |  | 5 | Operations | FI | TT WS | Loss and Waste Awareness |  | Workshop | Italian |  | 52 |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Wd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Leave | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Sick days | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Wd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Leave | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Sick days | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Wd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Leave | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Sick days | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
 |  | Resource | Version # | Suite | TRACC | Product | Title | Jab | Component | Languages | Measure | Initial Layout | Layout C1 | Layout C2 | Layout C3 | Total errors | Start | End | Start | End | % Complete | Days | Overlap | Total days | On Time
Month | 2011-08-01 00:00:00 | Juanita |  |  |  |  |  |  | Manual ST3 | Russian |  |  |  |  |  |  | 00:00:00
Wd |  | Toni |  |  |  |  |  |  | Manual ST4 | Dutch |  |  |  |  |  |  | 00:00:00
Leave | 0 | Ronel |  |  |  |  |  |  | Manual ST3 |  |  |  |  |  |  |  | 00:00:00
Sick days | 0 | [NAME] |  |  |  |  |  |  | Support Docs |  |  |  |  |  |  |  | 00:00:00
[NAME] new project line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00