Spreadsheet: 856682d1705893032-conditional-formattining-for-dates-and-project-planning-deliverable-tracker-excel-for-excelforum
Sheet: Project Plan

 | Project Plan
 | Phase | Team | Applicable Deliverable | Task | Start Date | End Date | Status | Owner(s) | Comments/Notes | Start Date | Duration | Column3
 | [NAME] | Joint | 00. Status Reports | Draft status report template | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | Complete | [NAME], [NAME]
 | [NAME] | Joint | 00. Status Reports | SMD+ review draft template | 2024-01-09 00:00:00 | 2024-01-17 00:00:00 | Complete | [NAME], [NAME]
 | [NAME] | Joint | 00. Status Reports | Determine status sync timings & update project plan | 2024-01-17 00:00:00 | 2024-01-17 00:00:00 | Complete | [NAME], [NAME]
 | 0 | Joint | 01. Kick-off materials | Discuss kick off agenda with [NAME] and [NAME] | 2024-01-11 00:00:00 | 2024-01-11 00:00:00 | Complete | [NAME], [NAME], [NAME], [NAME]
 | 0 | Joint | 01. Kick-off materials | [NAME] off deck based on [NAME] and [NAME] conversation | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | Complete | [NAME], [NAME]
 | 0 | Joint | 01. Kick-off materials | Share kick off deck with SMD+ for review | 2024-01-12 00:00:00 | 2024-01-12 00:00:00 | Complete | [NAME], [NAME]
 | 0 | Joint | 01. Kick-off materials | Review kick off deck | 2024-01-12 00:00:00 | 2024-01-16 00:00:00 | Complete | [NAME], [NAME], [NAME], [NAME]
 | 0 | Joint | 01. Kick-off materials | Review IRL and update kick off deck slides | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | Complete | [NAME], [NAME]
 | 0 | Joint | 01. Kick-off materials | Update as required | 2024-01-16 00:00:00 | 2024-01-16 00:00:00 | Complete | [NAME], [NAME]
 | 0 | Joint | 01. Kick-off materials | Practice walkthrough of kick off deck | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | Complete | [NAME], [NAME], [NAME], [NAME]
 | 0 | Joint | 01. Kick-off materials | Deliver final kick off deck to client | 2024-01-18 00:00:00 | 2024-01-18 00:00:00 | Complete | [NAME], [NAME]
 | 1 | Tech | 02. Refinement of strategic intent | Review strategic documents from DRL | 2024-01-09 00:00:00 | 2024-01-18 00:00:00 | In Progress | [NAME], [NAME]
 | 1 | Tech | 02. Refinement of strategic intent | Research IT strategy and IT initiative | 2024-01-22 00:00:00 | 2024-01-26 00:00:00 | Open | [NAME], [NAME]
 | 1 | Tech | 02. Refinement of strategic intent | Draft addendum to core deliverable | 2024-01-23 00:00:00 | 2024-01-26 00:00:00 | Open | [NAME], [NAME]
 | 1 | Tech | 02. Refinement of strategic intent | Review with SMD+ | 2024-01-29 00:00:00 | 2024-01-31 00:00:00 | Open | [NAME], [NAME], [NAME]
 | 1 | Tech | 02. Refinement of strategic intent | Share insights with client in tandem with the Growth team's deliverable | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 | Open | [NAME], [NAME]
 | 1 | Joint | 03. Current state capability map | Receive sample capability maps from Chad / Roger | 2024-01-08 00:00:00 | 2024-01-12 00:00:00 | Complete | [NAME], [NAME]
 | 1 | Tech | 03. Current state capability map | Review existing typical banking capability maps | 2024-01-09 00:00:00 | 2024-01-18 00:00:00 | In Progress | [NAME], [NAME]
 | 1 | Tech | 03. Current state capability map | Explore technology capabilities to align with optimal business capability model | 2024-01-12 00:00:00 | 2024-01-18 00:00:00 | Open | [NAME], [NAME]
 | 1 | Joint | 03. Current state capability map | Draft interview questions for inside-out interviews | 2024-01-16 00:00:00 | 2024-01-22 00:00:00 | In Progress | [NAME], [NAME], [NAME]
 | 1 | Joint | 03. Current state capability map | Draft interview schedule | 2024-01-16 00:00:00 | 2024-01-19 00:00:00 | In Progress | [NAME], [NAME]
 | 1 | Joint | 03. Current state capability map | Review interview questions with SMD+ | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | Open | [NAME], [NAME]
 | 1 | Joint | 03. Current state capability map | Create interview guides specific to interview schedule | 2024-01-22 00:00:00 | 2024-01-26 00:00:00 | Open | [NAME], [NAME], [NAME]
 | 1 | Tech | 03. Current state capability map | Build current state technology capability map | 2024-01-22 00:00:00 | 2024-01-26 00:00:00 | Open | [NAME], [NAME]
 | 1 | Joint | 03. Current state capability map | Validate capability map with SMDs+ | 2024-01-29 00:00:00 | 2024-01-31 00:00:00 | Open | Tech & Growth
 | 1 | Joint | 03. Current state capability map | Share and validate with client | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 | Open | [NAME], [NAME]
 | 1 | Tech | 07. Business model archetypes | Identify common IT operations models in retail banking | 2024-01-29 00:00:00 | 2024-02-05 00:00:00 | Open | [NAME], [NAME]
 | 2 | Joint | 08. Scenario to capability mapping | Define list of business and technology capabilities to support business scenarios | 2024-02-05 00:00:00 | 2024-02-16 00:00:00 | Open | Tech & Growth
 | 2 | Joint | 08. Scenario to capability mapping | Validate/refine list of business/technology capabilities with SMDs | 2024-02-23 00:00:00 | 2024-02-27 00:00:00 | Open | Tech & Growth
 | 2 | Joint | 08. Scenario to capability mapping | Share and gain acceptance from client | 2024-03-07 00:00:00 | 2024-03-07 00:00:00 | Open | [NAME], [NAME]
 | 2 | Joint | 09. Current capability summary and maturity | Assess existing business and technology capabilities against list of capabilities required (08) | 2024-02-05 00:00:00 | 2024-02-19 00:00:00 | Open | Tech & Growth
 | 2 | Joint | 09. Current capability summary and maturity | Validate assessment results with SMDs | 2024-02-20 00:00:00 | 2024-02-23 00:00:00 | Open | Tech & Growth
 | 2 | Joint | 09. Current capability summary and maturity | Share and gain acceptance from client | 2024-03-07 00:00:00 | 2024-03-07 00:00:00 | Open | [NAME], [NAME]
 | 2 | Tech | 10. Technology / application rationalization gap analysis | Assess current technologies and technology gaps to provide net new capabilities | 2024-02-14 00:00:00 | 2024-02-23 00:00:00 | Open | [NAME], [NAME]
 | 2 | Tech | 10. Technology / application rationalization gap analysis | Assess current state applications (retire, retain, replace, enhance), [NAME] net new applications where required | 2024-02-14 00:00:00 | 2024-02-23 00:00:00 | Open | [NAME], [NAME]
 | 2 | Tech | 10. Technology / application rationalization gap analysis | Organize a technology roadmap with high level findings from analysis | 2024-02-22 00:00:00 | 2024-02-28 00:00:00 | Open | [NAME], [NAME]
 | 2 | Tech | 10. Technology / application rationalization gap analysis | Validate assessment results with SMDs | 2024-02-29 00:00:00 | 2024-03-04 00:00:00 | Open | [NAME], [NAME], [NAME]
 | 2 | Tech | 10. Technology / application rationalization gap analysis | Share and validate gap analysis with client | 2024-03-07 00:00:00 | 2024-03-07 00:00:00 | Open | [NAME]
 | 2 | Tech | 11. Current to future capability gap assessment and prioritization | Combine analysis of prioritized capabilities (08) and gap analysis (10) to define initiative prioritization | 2024-02-26 00:00:00 | 2024-03-01 00:00:00 | Open | [NAME], [NAME]