Spreadsheet: 730592d1619782205-need-help-merging-info-from-two-tables-report-template-test
Sheet: Project A

 | PROGRAM Info (changes infrequently) |  |  |  | OVERALL STATUS |  |  | MILESTONES |  |  |  |  | ACCOMPLISHMENTS |  |  | RISKS & ISSUES |  |  |  |  |  | NEXT STEPS
 | Project ID | Project Name | Department | Project Manager | Target Completion Date | Status | Percent Complete | Weekly Update Section | Name | Due Date | Status | Health | Weekly Update Section | Name | Due Date | Weekly Update Section | Name | Due Date | Priority (Impact & Probability) | Status | Mitigations | Weekly Update Section | Name | Due Date | Status
 |  |  |  |  |  |  |  | <Milestones> | Text | Date | Status | [NAME] R- OffTrack A - At Risk G - On Track | <Recent Accomplishments> | Text | Date | <Key Issues / Risks> | Text | Date | Low /  Medium / High | Status Dropdown | Text | <Next Steps> | Text | Date | Status Dropdown
 |  |  |  |  |  |  |  | Milestones | Finalize project schedule and milestones | 2020-12-04 00:00:00 | Completed | Green | Recent Accomplishments | Engaged business units to document current state workflows |  | Key Issues / Risks | Alignment of data model requirements with data strategy team |  | (2) Normal | Completed | Engaged business units to document current state workflows | Next Steps | Assimilate new development resource | 2021-02-04 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | Project Artifact sign offs from business sponsor | 2020-07-10 00:00:00 | Completed | Green | Recent Accomplishments | Documented project charter covering scope and business value |  | Key Issues / Risks | Availability of Advisor360 resources to support the project. |  | (2) Normal | Completed | Documented project charter covering scope and business value | Next Steps | [NAME] roadmap and establish updated milestones with engineering and business input | 2021-02-08 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | ARB review and approval | 2020-10-22 00:00:00 | Completed | Green | Recent Accomplishments | Drafted high-level business requirements pertaining to each business unit. |  | Key Issues / Risks | Ownership of Consulting Agreement data |  | (2) Normal | Completed | Drafted high-level business requirements pertaining to each business unit. | Next Steps | Seek confirmation on current problem defined & solution approach with technology leadership | 2021-02-17 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | [NAME] with Stakeholders | 2020-09-29 00:00:00 | Completed | Green | Recent Accomplishments | Completed additional analysis around agreement and payment reconciliation |  | Key Issues / Risks | Potential technology resource constraints due to conflicting priorities |  | (2) Normal | Completed | Completed additional analysis around agreement and payment reconciliation | Next Steps | Set course to deliver first product increment to business | 2021-02-24 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | Allocation of technology resources | 2020-08-24 00:00:00 | Completed | Green | Recent Accomplishments | Reviewed initial set of business requirements with SPOCs and POs |  | Key Issues / Risks | Recommendations from ARB review may impact project timeline. | 2020-10-22 00:00:00 | (2) Normal | Completed | Reviewed initial set of business requirements with SPOCs and POs | Next Steps | Continue development of agreement feature. | 2021-03-09 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | Begin IT development | 2020-10-22 00:00:00 | Completed | Green | Recent Accomplishments | Reviewed project objectives and scope with Application Solutions Review Board and Data Strategy team |  | Key Issues / Risks | Confirmation required from senior leadership on current project direction and budget. | 2021-02-10 00:00:00 | (2) Normal | Completed | Reviewed project objectives and scope with Application Solutions Review Board and Data Strategy team | Next Steps | Define stories for agreement features related to RPC and PPC modules | 2021-03-11 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | MVP Production Deployment - Q2 | 2021-04-22 00:00:00 | Completed | Green | Recent Accomplishments | Solidified framework and BOT process for importing data from spreadsheet to database. | 2021-02-11 00:00:00 | Key Issues / Risks | Potential change in direction around business problem to solve | 2021-02-25 00:00:00 | (2) Normal | Completed | Solidified framework and BOT process for importing data from spreadsheet to database. | Next Steps | Define stories for the payment features for all three modules (WMC, RPC, & PPC) | 2021-03-15 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | Agreements for WMC module - Q1 | 2021-03-12 00:00:00 | Completed | Green | Recent Accomplishments | Finalized the technology approach. | 2021-02-15 00:00:00 | Key Issues / Risks | Compensation support demands has unpredictable draw on resources; requires project sponsor to set prioritization and expectations. | 2021-06-30 00:00:00 | (3) Low | In Progress | Finalized the technology approach. | Next Steps | Define KPIs and success criteria from the business. | 2021-03-22 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | Agreements for RPC & PPC module - Q1 | 2021-03-31 00:00:00 | Completed | Amber | Recent Accomplishments | Finalized product development approach. | 2021-02-22 00:00:00 | Key Issues / Risks | Original milestones are subject to change based on project risks. | 2021-02-04 00:00:00 | (2) Normal | Completed | Finalized product development approach. | Next Steps | Re-validate MVP and finalize any changes needed to reduce scope with increased value. | 2021-03-24 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | Payments for WMC module - Q2 | 2021-04-07 00:00:00 | Completed | Amber | Recent Accomplishments | Finalized feature set and product increments for MVP. | 2021-02-23 00:00:00 | Key Issues / Risks | Potential re-vamp of consulting agreements with DO; aligned with project sponsors for RPCA and WMCA | 2021-04-30 00:00:00 | (3) Low | In Progress | Engaged business units to document current state workflows | Next Steps | Transition & adoption plan to move from excel to new system. | 2021-03-26 00:00:00 | Completed
 |  |  |  |  |  |  |  | Milestones | Payments for RPC & PPC module - Q2 | 2021-04-07 00:00:00 | Completed | Amber | Recent Accomplishments | Completed sprint review demo - 2/23/21 | 2021-02-24 00:00:00 | Key Issues / Risks | Scope creep to include HSA employer solution as part of post MVP; workaround has been established. | 2021-04-23 00:00:00 | (3) Low | In Progress | Documented project charter covering scope and business value | Next Steps | Finalize KPI’s and success criteria from the business for payment feature. | 2021-04-16 00:00:00 | Not Started
 |  |  |  |  |  |  |  | Milestones | [NAME] | 2021-04-19 00:00:00 | Completed | Amber | Recent Accomplishments | Established dev ops processes and resourcing. | 2021-02-26 00:00:00 | Key Issues / Risks | EFT payment feature requires discovery to address the unknowns and upstream business dependencies | 2021-04-26 00:00:00 | (2) Normal | Not Started | Drafted high-level business requirements pertaining to each business unit. | Next Steps | Complete development of payment feature for all three modules. | 2021-04-16 00:00:00 | In Progress
 |  |  |  |  |  |  |  | Milestones | Post MVP hot fixes | 2021-04-30 00:00:00 | In Progress | Amber | Recent Accomplishments | Completed development of Agreement feature for all three modules (WMC, RPC, PPC) | 2021-03-05 00:00:00 |  |  |  |  |  |  | Next Steps | Define transition & adoption plan to move from excel to new system. | 2021-04-23 00:00:00 | Not Started
 |  |  |  |  |  |  |  | Milestones | Post MVP Enhancements | 2021-06-30 00:00:00 | In Progress | Red | Recent Accomplishments | Provided application link and user guide to business for validation and feedback | 2021-03-12 00:00:00 |  |  |  |  |  |  | Next Steps | Continue to absorb latest feedback from upcoming sprint reviews | 2021-04-26 00:00:00 | In Progress
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Established bi-weekly cadence for feedback on sprint review demos. | 2021-03-19 00:00:00 |  |  |  |  |  |  | Next Steps | Log and review user feedback as part of latest sprint review. | 2021-05-07 00:00:00 | In Progress
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Reviewed feedback from business on this month’s sprint reviews. | 2021-03-26 00:00:00 |  |  |  |  |  |  | Next Steps | Finalize requirements and estimations for post-MVP feature set | 2021-05-07 00:00:00 | In Progress
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Defined KPI’s and success criteria from the business for Agreements. | 2021-03-30 00:00:00 |  |  |  |  |  |  | Next Steps | Complete development of next sprint as part of post-MVP (target date: 05/05/21) | 2021-05-05 00:00:00 | In Progress
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Finalized setup of QA & Production environments with Adv. | 2021-04-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Completed development of MVP solution. | 2021-04-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Completed UAT phase for MVP solution | 2021-04-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Launched MVP solution on 4/21 to production | 2021-04-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Prioritized and ranked features for post-MVP; estimations and requirements in process. | 2021-04-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Accomplishments | Transitioned business users from excel to new solution. | 2021-04-22 00:00:00