{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["CoE Template Instructions","Deliverable Definitions","CoE Summary","Class 5 Checklist","Class 4 Checklist","Class 3 Checklist","Class 2 Checklist","Class 1 Checklist"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":17,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CoE Template Instructions","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Class of Estimate (CoE) Template Instructions"]
[]
["Reference:  The City has developed a customized Innovationand Technology Industry Class of Estimate (CoE) template."]
["Template:  This template is used to determine the cost class estimate for the Basis of Estimate (BoE) and is a supporting document to the BoE. This template consists of two tools, a Class of Estimate, and five Class of Estimate Checklist(s). \n\n"]
["Tabs:  For the Class of Estimate template\n\n    - CoE Template Instructions - Class of Estimate Template Instructions.  \n    - Deliverable Definitions - Brief definition of both Project Data Deliverables and Technical Design Deliverables.\n    - CoE Summary - Class of Estimate Summary - This sheet helps the CoE author to rationalize the Class of Estimate for the Basis of Estimate by identifying applicable deliverables that define a specific Class of Estimate for the specific industry.\n    - Class 5 Checklist - Deliverables Maturity Assessment Checklist - Class 5. \n    - Class 4 Checklist - Deliverables Maturity Assessment Checklist - Class 4.\n    - Class 3 Checklist - Deliverables Maturity Assessment Checklist - Class 3.\n    - Class 2 Checklist - Deliverables Maturity Assessment Checklist - Class 2.\n    - Class 1 Checklist - Deliverables Maturity Assessment Checklist - Class 1.\n"]
["Features:  Uses excel macros. User must select enable content for the macros to be enabled.\n\n              \n\n"]
["Purpose:  As a project progresses through the various industry work streams from Investment Planning through to Construction, project definition, design deliverables and cost estimates will evolve and become more accurate, advancing Cost Estimates from a Class 5 to a Class 1.\n\nIn order to monitor this progression, the CoE Summary tab is used to track project deliverables against project cost accuracy and percentage of project definition to align with the class of estimate rationale outlined in: \n \n"]
["\nTable 1 – Classification of Estimate (on CoE Summary Tab)"]
["\nTable 2 - Supporting Class of Estimate Rationale (on CoE Summary Tab)"]
[]
["General Instructions \n\nThe Class of Estimate Author is responsible for assessing the class estimate by:\n \nStep 1.  For all capital projects, identify where the investment/project is at in the delivery process outlined below.  \n(Refer to CAMO's website: http://citynet/finance/infrastructure/camp/#10.)  \n\nIdentify which Stage Gate or Control Point the investment/project is going through.  Note the preceding maturity class level.\n           I.e.  If the investment/project is attempting to go through Control Point 2, note the preceding cost estimate class is 3,  \n                  as depicted below.  Thus one would use the Class 3 Checklist for the specific industry to measure each \n                 deliverables maturity level before passing thru the Control Point 2.\n\n\n\n"]
[]
["Step 2.  In the Class of Estimate (CoE) Summary tab, fill in the required header information for the investment/project.\n\na. Enter the title of the Investment/Project.\n\nb. Enter a brief description of the Investment/Project.\n\nc. Enter the Business Case ID.\n\nd. Enter the date of the Deliverable Maturity Assessment for the Investment/project.\n\ne. Enter the name of the Class of Estimate Author (and additional Contributor names, as required).\n\n\n\n\n\n\n\n\n\n\n               Note: The Title, Description, and Business Case ID should be the same as used in the Basis of Estimate template.\n                          The Title, Description, and Business Case ID fields pre-populate subsequent tabs with this information.\n"]
["\nStep 3.  In the CoE Summary tab, select all the applicable deliverables that apply to the investment/project.\n\na. Scroll down midway in the CoE Summary tab till you reach the General Project Data Deliverable section.\n\nb. In the 'Select all Applicable Deliverables' field, [Column A], go though the listing of general project data and technical design deliverables and select the checkbox         to indicate that the deliverable is applicable to the investment/project.  \n               Note: This action will dynamically enable those checked deliverables in the subsequent Class 5, Class 4, Class\n                          3, Class 2,  Class 1 Deliverable Maturity Assessment Checklists tabs.\n\n"]
["Now that the applicable deliverables have been selected for the investment/project, one can begin the deliverables assessment by using the Deliverable Maturity Assessment Checklist Class # Checklist determined in Step 1 above.\n"]
["Step 4.  Based on the information ascertained in Step 1, in that specific Class # Deliverable Maturity Assessment Checklist tab, fill in the required header information.\n\n               Note: The Title, Description, Business Case ID have been pre-populated from the CoE Summary tab.\n\na. Enter the date of the Deliverable Maturity Assessment Checklist was completed for the Investment/project.\n\nb. Enter the name of the Class of Estimate Checklist Author (and additional Contributor names, as required).\n\n\n\n\n\n\n\n\n\n","q"]
["Step 5.  In the Class # - Deliverable Maturity Assessment Checklist tab, assess the applicable deliverables maturity level by filling in the comment field with the assessment, and location of supporting documentation.\n\na. Scroll down to the General Project Data Deliverables section.\n\nAll applicable deliverables will be displayed, as selected in the CoE Summary tab.  For every applicable deliverable, there will be the expected maturity level, and an assessment of what the deliverable should look like, resemble at that maturity level.\n"]
["\nb. Assess the applicable deliverables maturity level by filling in the 'Comments' field [Column F] with the assessment, and identify the location of deliverable information within supporting documentation and/or identify drawing related to the deliverable in order to validate maturity level.\n\n"]
["\n               Note: The highest maturity level  'Comment' field within the checklist tabs, will be brought forward to the \n                          'Comment'  field on the CoE Summary tab, prefixed with a 'C#:', where the # sign corresponds to the \n                          Class # Checklist tab. This will not delete previously entered comments within the other Class # \n                          Checklist tabs.\n\n"]
["Step 6.   In the CoE Summary tab, assess the deliverable maturity level for each applicable deliverable, by shading the maturity level of the deliverable in green. \n\na. For the deliverables that do apply, identify the maturity level of the deliverables in the General Project Data and Design Deliverables sections in Table 2, by filling in the best suited maturity level of the deliverables’ current status in green. Determining the maturity level of deliverable requires the professional judgement of the CoE Author or an assigned Subject Matter Expert after completing the checklist assessment.\n\nb.  When evaluating the class of estimate for a project, all cells must be shaded within the specific class estimate column, to be considered at that level of the cost class estimate. (Refer to example #1 below.)"]
["               Note: As a cost estimate matures and becomes more accurate, cells shall only be shaded up to and including \n                          the level  to which the BoE Author is presenting the required class estimate. (Refer to example #2\n                          below.)\n\n               Note: Even if the CoE Author believes that a deliverable is ’Complete’ and will remain unchanged as the\n                         estimate progresses from Class 3 to Class 1, no ‘Complete’ cells shall be shaded in the Class 2 or Class 1\n                        columns until the project definition continues to progress and the estimate matures into a Class 2 or \n                        Class 1 level.\n                       This helps ensure that, although a particular deliverable may be completed, a verification of that \n                       deliverable is performed  at every  subsequent Class Estimate to confirm alignment with the project\n                       scope. (Refer to example #3 below.)\n\n\n"]
["Step 7.  In the CoE Summary tab, assess the overall class for the cost estimate.\n\nWhen each deliverable item has been analyzed and classified, the green highlighted selections will help to visually determine the Class in which the Basis of Estimate is currently at. \n\nSelect the appropriate Class from the 'Select Overall Cost Class Estimate' cell's drop-down menu."]
["Examples"]
["Cost estimate maturity/progression from Class 4 to Class 3 using three design deliverables, as a representative sample for illustration purposes only."]
[]
["Example 1 – A CoE Author would be determining  this as a Class 3 estimate.  All applicable deliverables must be at a Class 3 maturity in order to be deemed a Class 3 estimate."]
["Example 2 – A CoE Author would be determining  this as a Class 4 estimate.  All applicable deliverables must be at a Class 3 maturity in order to be deemed a Class 3 estimate.\n"]
["Example 3 – If a CoE Author has determined a Class 3 estimate, where the design deliverables for the Room Datasheets are `Complete`, only shade green the first occurrence of that status. Again, this is to ensure that the deliverables are continuously verified and are aligned with project scope as the project continues to progress."]
["Tips:  Helpful tips\n\n∙Always download the latest template from the CAMO website. (http://citynet/finance/infrastructure/camp/#5)\n\n∙To remove content from a selected cell in excel, right click and select 'Clear Contents'. (leaves formatting in place)\n\n∙ To select all the deliverables on CoE Summary tab, press the   \n\n∙ To unselect all the deliverables on CoE Summary tab, press the \n\n∙ To clear a previous assessment (green shading) on CoE Summary tab, press the     \n\n∙ To hide all deliverables with a Maturity level of `Not Required` on Class # Checklist list tabs, press the \n∙ To bring the deliverables back into the Class # Checklist tab, simply leave the tab, and return to the tab.   "]
["Print:  CoE Summary prints portrait on tabloid paper.   Every other tab prints portrait on letter paper.\n\n\n"]
["Support:  For assistance with this tool, please first consult with the Departmental AMO Manager/Lead.  If you require additional support, please email 'City-Asset Management Program' ."]
["mailto:City-AMP@winnipeg.ca\n"]

{"sheet":"Deliverable Definitions","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,2],[22,1,22,2]]}
[" ","GENERAL PROJECT DATA DELIVERABLES:"]
["#","Deliverable","Definition"]
[true,"A. SCOPE:"," "]
[1,"Project Scope of Work ","• A clear and concise scope statement identifying specifically what is included, and what is not included in the scope of work for the project, in order to successfully meet the project’s objectives.\n"]
[true,"B.PROJECT LOCATION:"," "]
[2,"Project Location\n","• Area(s) where the IT assets, materials and equipment, as described in the Scope of Work, are installed or deployed, and the general area where the Work is performed.\n"]
[true,"C.REQUIREMENTS:"," "]
[3,"Privacy Impact Assessment\n","• Privacy Impact Assessment  is a tool by which the City endeavours to meet its legislated obligations under the Freedom of Information and the Protection of Privacy Act (FIPPA) and the Personal Health Information Act (PHIA).\n• Privacy Impact Assessment is required to ensure compliance with legislation and AS-015 Access to Information and Protection of Privacy (http://citynet/cao/administrative_directives/general_administration/pdf/AS015.pdf) . \n• Refer to the City's Access and Privacy Office website for additional information on Privacy Impact Assessment:\nAccess and Privacy Office - City Clerk's Department  (http://citynet/Clerks/privacy/default.stm#guidance)\n"]
[4,"Functional and Non-Functional Requirements\n","• Functional requirements describe the functionalities, capabilities and activities a system must be able to perform.\n• Non-functional requirements describe the operation of a system, e.g. availability, performance, scalability, usability, rather than specific functions the system performs.  \n• Functional and non-functional requirements are typically included in the same documents. \n• Information within is differentiated based on different methodologies:\n   - Waterfall\n   - Agile\n"]
[5,"Workforce Management Technology Requirements\n","• As per Administrative Standard No. HR-020, Workforce Management Technology (WMT) is defined as the City processes (e.g. management, planning and decision-making functions) and assets (e.g. equipment, tools, devices, vehicles, hardware, software and applications) that provide the ability for City Leaders to create, aggregate, store, display, or derive information about employees and their work. \n• Purposes may include but are not limited to the management of City operations, location, scheduling, performance, and compliance.\n"]
[6,"Information Security Requirements\n","• Information Security can be defined as the preservation of the confidentiality, integrity and availability of information and information systems, in addition to authenticity, accountability, reliability and non-repudiation.\n• Information security is governed by the following Administrative Standards:\n   - IT-004 – Individual Responsibility for IT Security \n   - IT-006 – Security of Wireless Computing\n"]
[true,"D.STRATEGY:"," "]
[7,"Contracting/Sourcing\n","• Contract strategy for acquiring goods and services from non-City sources and/or suppliers."]
[8,"Organizational Change Management \n","• Description of the characteristics of the change and impacts on the organization which contains: change characteristics, an organizational assessment (both of these function as a readiness assessment); a proposed team or equivalent (e.g. membership on a steering committee); a sponsorship model; stakeholder assessments; risk assessment; recommendations for tactics for adoption; next steps.  \n• Refer to the City of Winnipeg Project Management Manual Appendix D for information.\n"]
[true,"E.PLANNING:"," "]
[9,"Project Delivery Plan\n","• Project Delivery Plan (PDP) is a comprehensive document that describes how processes will be integrated to execute a specific project management process in the delivery of a project. The PDP is a compendium of subsidiary plans based on the project management processes as defined in the City`s Project Management Manual (PMM) and is used as the basis for executing, monitoring and controlling the project.  \n• It includes scope definition, budget, schedule and Gantt chart, key procurements and methods, project organization structure, communications and stakeholder engagement plan, risk management plan, and project close-out.\n"]
[10,"Project Schedule\n","• The schedule at the outset of the project is the master schedule for the entire delivery chain and encompasses all the project components and high-level deliverables.\n• As the project delivery plan is further refined, it includes deliverables and the Work Breakdown Structure (WBS).\n• The WBS, when complete, presents a hierarchal view of the project comprising the total project as defined in the scope statement. \n• The WBS subdivides the project into smaller packages to the degree required for effective planning, management and execution of the work. It defines what deliverables the project will achieve once completed and also the specific project deliverables that are produced for the project itself.\n• The high-level schedule with milestones is typically a component of the Project Delivery Plan; the final WBS is usually a separate deliverable.\n"]
[11,"Risk Register\n","• A risk register is a \"living\" document used as a risk management tool acting as a repository for all risks identified and includes additional information about each risk such as risk description, probability, impact, mitigation, contingency, responsibility, action items, etc., and is updated through the lifecycle of a project.\n"]
[12,"Stakeholder Consultation/Engagement/Management Plan\n","• Stakeholder consultation involves the development of constructive, productive relationships over the term of a project and results in a relationship of mutual benefit; it enables the City to identify trends and emerging challenges which are currently or will in the future have an impact on stakeholders.  This is a component of the Stakeholder Management Plan.\n• Stakeholder Engagement strategy involves the set of tasks and activities that one needs to conduct, in order to communicate with and engage stakeholders to keep them updated on the progress of the implementation, and to coach them to support change management and project implementation activities. \n• Stakeholder Management Plan is a structured document that outlines the strategy, stakeholder mapping and project activities that will be undertaken to effectively engage stakeholders throughout the lifecycle of the project, based on the analysis of their needs, interests and potential impact on project success. \n• The classes of estimates are a very linear process and public engagement doesn’t fit into a linear process. However, as a general guideline, the project team should consider if public feedback will influence the project (i.e. decide if public engagement is even required) at the Class 5 level, and ensure stakeholders are informed of the design for at the Class 1 level.\n• Sometimes an entire public engagement program is carried out during the Class 5 project initiation. Critical decisions are made at a Class 5 despite the project only being at 1% design. Public engagement can help identify a problem and/or scope a project before design work even begins. e.g. Arlington Bridge and Marion projects. \n• Other times public engagement begins later in the classes of estimates scale once options/alternatives have been developed so they can be shared with the public for feedback. This would occur when public input is not needed to scope the project.\n"]
[13,"Training Plan\n","• Training Plan provides a clear understanding of what must happen to meet the training requirements that have been defined, thus, end-users receive training in the knowledge, skills, and/or abilities required to support the new roles, business processes and/or technology.\n• Training requirements are clear and concise training needs identifying stakeholders and why training is required, in order to successfully meet the project’s objectives.\n"]
[14,"Resource List (Temporary Resources and Staff Augmentation)\n","• Temporary resources for project delivery consist of:\n   - Temporary Resources hired through the City’s HR process  \n   - Staff Augmentation (Contractor) hires  \n• Temporary resources funded by the project.\n• Contractor services to the City under the Staff Augmentation program. (project funded) \n• Contractor services are services provided to the City as defined in FM-002, Appendix 1 and are subject to the Materials Management Policy and may be subject to various trade agreements. (see Appendix 13).\n• Solicitation for Contractor services shall be in accordance with Solicitation of Competitive Offers.\n• If project will use only existing complement of resources to staff the project, indicate deliverable is N/A.\n"]
[15,"Testing Strategy/Plan\n","• Testing Strategy/Plan describes the methods, activities and processes that will be applied to an initiative to ensure the software and/or hardware meets all the solution requirements and functional specifications.  \n• Test Strategy outlines the general approach to testing.\n• Test Plan is a project plan for the testing process, it conveys how testing will be performed for a project.\n• Some departments opt to combine the test plan and test strategy into a single document, whilst other departments keep them as separate documents.   \n"]
[" ","TECHNICAL DESIGN DELIVERABLES:"]
["#","Deliverable","Definition"]
[16,"Solution Design \n","• A solution design describes the configuration and implementation of technological components to support requirements.\n• The solution design may include software, technology, and/or integration considerations to support the overall design for a given technology solution within a project.\n• The conceptual-level design describes higher-level components and themes around the business need and technologies required to deliver and support the solution.\n• The logical design addresses the functional, non-functional, and/or quality of service requirements of the solution.\n"]
[null,"Infrastructure Solution Design\n"]
[17,"Technology List\n","• Technology list has broad scope depending on the project. \n• Technology list may include assets such as software, hardware, or infrastructure.\n• For a program with multiple projects, each project may have its own technology list.\n"]
[18,"Data Migration Plan\n","• Data migration is the process of moving data from one location or platform to another, one format to another, or one application to another. \n• Generally, this is the result of introducing a new system or location for the data. \n• The business driver is usually an application migration or consolidation in which legacy systems are replaced or augmented by new applications that will share the same dataset.\n"]

{"sheet":"CoE Summary","index":2,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[26,1,26,7],[27,1,27,7],[32,1,32,7],[35,1,35,7],[33,1,33,7],[29,1,29,7],[28,1,28,7],[5,2,5,4],[4,2,4,4],[1,5,1,6],[2,5,2,6],[3,0,3,1],[3,2,3,4],[3,5,3,6],[4,0,4,1],[5,0,5,1],[3,7,3,8],[0,0,0,8],[1,2,1,4],[2,0,2,1],[2,2,2,4],[1,0,1,1],[58,2,58,7],[6,0,6,8],[37,2,37,7],[7,1,7,7],[16,1,16,7],[17,1,17,7],[18,1,18,7],[30,1,30,2],[19,1,19,2],[23,1,23,7],[31,1,31,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[24,1,24,7],[25,1,25,7]]}
[" "]
["Title:"]
["Description:",null,null,null,null," "]
[" Business Case ID:",null,null,null,null," ",null," "]
[" Date:"]
[" Class of Estimate Author: \n(and other Contributors, as required)"]
[]
[true,"Table 1 - Classification of Estimate 1"]
[true,null,"Characteristic","Class 5","Class 4","Class 3","Class 2","Class 1"]
[true,1,"Project Definition/Design % Complete ","~1%*","~10%*","~30%*","~60%*","~99%*"]
[true,{"$f":"B10+1","v":2},"End Usage - typical purpose of estimate","Concept","Feasibility ","Budget Authorization"," Detailed  Design*","Tender Documents*"]
[true,{"$f":"B11+1","v":3},"Methodology - typical estimating method","parametric models, judgment, or analogy ","parametric models, assembly driven models ","semi-detailed unit costs with assembly level line items","detailed unit cost with forced detailed \ntake-off","detailed unit cost with forced detailed \ntake-off"]
[true,null,"Buildings and General Construction:","SF or m2 factoring"]
[true,null,"Process:","capacity factored","equipment factored"]
[true,null,"Pipeline, Transportation:","cost/length factors","cost/length factored"]
[true,{"$f":"B12+1","v":4},"Accuracy of Cost Estimate*","High: +100%\nLow: -50%","High: +50%*\nLow: -30%","High: +30%\nLow: -20%","High: +20%\nLow: -15%*","High: +15%*\nLow: -10%*"]
[true,"1  Based on using the AACE International Recommended Practice(s): 17R-97, 18R-97, 56R-08, 97R-18, 98R-18 (2020)\n* City of Winnipeg Customization"]
[true,"Table 2 - Estimate Input Checklist and Maturity Matrix2 "]
[true,"The following table is a checklist of general project data deliverables and design deliverables found in common practice in this specific industry. \nThis table is used to provide the supporting rationale for selecting (fill shading in green) the deliverables status characteristics below. "]
[true,"General Project Data Deliverables Legend:"]
[true," Not Required:  May not be required for all estimates of the specified class, but specific project estimates may require at least preliminary development."]
[null," Preliminary:  Project definition has begun and progressed to at least an intermediate level of completion. Review and approvals for its current status has occurred."]
[null," Defined: Project definition is advanced and reviews have been conducted.  Development may be near completion with the exception of final approvals."]
[true,"Design Deliverables Legend:"]
[true," NR (Not Required): Deliverable may not be required for all estimates of the specified class, but specific project estimates may require at least preliminary\n                               development."]
[null," S (Started): Work on the deliverable has begun. Development is typically limited to sketches, rough outlines, or similar levels of early completion."]
[null," P (Preliminary):  Work on the deliverable is advanced. Interim, cross functional reviews have usually been conducted. Development may be near completion except\n                           for final reviews and approvals."]
[null," S/P (Started/Preliminary): Between started and preliminary status."]
[null," P/C (Preliminary/Complete):  Between preliminary and complete status."]
[null," C (Complete): The deliverable has been reviewed and approved as appropriate."]
[true,"General Legend:"]
[true," Column A: Select all deliverables applicable to the investment/project by clicking on the checkbox."]
[true," Comments: Add relevant details to support the rationale for selecting the deliverable maturity level.  Also indicate the location of specific documents or drawing related to\n                    the deliverable in order to validate maturity level."]
[true,"  *  : City of Winnipeg customization: change in deliverable name or change in deliverable maturity level."]
[null," "]
[true,"2 Model based off of AACE International Recommended Practices. \n              ",null,null,null,null,null,null,"Select Overall Cost Class Estimate"]
[true," "]
["Select all applicable deliverables","#","GENERAL PROJECT DATA DELIVERABLES"]
[null,null,"A. SCOPE:","Class 5","Class 4","Class 3","Class 2","Class 1","Comments:"]
[false,1,"Project Scope of Work \n","Preliminary","Preliminary","Defined","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F12 =\"\",   IF('Class 2 Checklist'!F12 =\"\",   IF('Class 3 Checklist'!F12 =\"\",    IF('Class 4 Checklist'!F12 =\"\",    IF('Class 5 Checklist'!F12 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F12)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F12)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F12)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F12)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F12))","v":""}]
[true,null,"B.PROJECT LOCATION:","Class 5","Class 4","Class 3","Class 2","Class 1","Comments:"]
[false,2,"Project Location\n","Not Required","Not Required","Preliminary","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F14 =\"\",   IF('Class 2 Checklist'!F14 =\"\",   IF('Class 3 Checklist'!F14 =\"\",    IF('Class 4 Checklist'!F14 =\"\",    IF('Class 5 Checklist'!F14 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F14)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F14)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F14)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F14)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F14))","v":""}]
[true,null,"C.REQUIREMENTS:","Class 5","Class 4","Class 3","Class 2","Class 1","Comments:"]
[false,3,"Privacy Impact Assessment\n","Not Required","Preliminary","Defined","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F16 =\"\",   IF('Class 2 Checklist'!F16 =\"\",   IF('Class 3 Checklist'!F16 =\"\",    IF('Class 4 Checklist'!F16 =\"\",    IF('Class 5 Checklist'!F16 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F16)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F16)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F16)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F16)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F16))","v":""}]
[false,4,"Functional and Non-Functional Requirements\n","Not Required","Preliminary","Defined","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F17 =\"\",   IF('Class 2 Checklist'!F17 =\"\",   IF('Class 3 Checklist'!F17 =\"\",    IF('Class 4 Checklist'!F17 =\"\",    IF('Class 5 Checklist'!F17 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F17)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F17)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F17)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F17)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F17))","v":""}]
[false,5,"Workforce Management Technology Requirements\n","Not Required","Preliminary","Defined","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F18 =\"\",   IF('Class 2 Checklist'!F18 =\"\",   IF('Class 3 Checklist'!F18 =\"\",    IF('Class 4 Checklist'!F18 =\"\",    IF('Class 5 Checklist'!F18 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F18)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F18)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F18)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F18)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F18))","v":""}]
[false,6,"Information Security Requirements\n","Not Required","Preliminary","Preliminary","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F19 =\"\",   IF('Class 2 Checklist'!F19 =\"\",   IF('Class 3 Checklist'!F19 =\"\",    IF('Class 4 Checklist'!F19 =\"\",    IF('Class 5 Checklist'!F19 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F19)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F19)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F19)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F19)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F19))","v":""}]
[true,null,"D.STRATEGY:","Class 5","Class 4","Class 3","Class 2","Class 1","Comments:"]
[false,7,"Contracting/Sourcing\n","Not Required","Preliminary","Preliminary","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F21 =\"\",   IF('Class 2 Checklist'!F21 =\"\",   IF('Class 3 Checklist'!F21 =\"\",    IF('Class 4 Checklist'!F21 =\"\",    IF('Class 5 Checklist'!F21 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F21)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F21)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F21)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F21)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F21))","v":""}]
[false,8,"Organizational Change Management \n","Not Required","Preliminary","Defined","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F22 =\"\",   IF('Class 2 Checklist'!F22 =\"\",   IF('Class 3 Checklist'!F22 =\"\",    IF('Class 4 Checklist'!F22 =\"\",    IF('Class 5 Checklist'!F22 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F22)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F22)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F22)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F22)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F22))","v":""}]
[true,null,"E.PLANNING:","Class 5","Class 4","Class 3","Class 2","Class 1","Comments:"]
[false,9,"Project Delivery Plan\n","Not Required","Preliminary","Defined","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F24 =\"\",   IF('Class 2 Checklist'!F24 =\"\",   IF('Class 3 Checklist'!F24 =\"\",    IF('Class 4 Checklist'!F24 =\"\",    IF('Class 5 Checklist'!F24 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F24)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F24)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F24)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F24)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F24))","v":""}]
[false,10,"Project Schedule\n","Not Required","Preliminary","Defined","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F25 =\"\",   IF('Class 2 Checklist'!F25 =\"\",   IF('Class 3 Checklist'!F25 =\"\",    IF('Class 4 Checklist'!F25 =\"\",    IF('Class 5 Checklist'!F25 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F25)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F25)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F25)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F25)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F25))","v":""}]
[false,11,"Risk Register\n","Not Required","Preliminary","Defined","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F26 =\"\",   IF('Class 2 Checklist'!F26 =\"\",   IF('Class 3 Checklist'!F26 =\"\",    IF('Class 4 Checklist'!F26 =\"\",    IF('Class 5 Checklist'!F26 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F26)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F26)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F26)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F26)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F26))","v":""}]
[false,12,"Stakeholder Consultation/Engagement/Management Plan\n","Not Required","Preliminary","Defined","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F27 =\"\",   IF('Class 2 Checklist'!F27 =\"\",   IF('Class 3 Checklist'!F27 =\"\",    IF('Class 4 Checklist'!F27 =\"\",    IF('Class 5 Checklist'!F27 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F27)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F27)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F27)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F27)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F27))","v":""}]
[false,13,"Training Plan\n","Not Required","Not Required","Preliminary","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F28 =\"\",   IF('Class 2 Checklist'!F28 =\"\",   IF('Class 3 Checklist'!F28 =\"\",    IF('Class 4 Checklist'!F28 =\"\",    IF('Class 5 Checklist'!F28 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F28)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F28)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F28)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F28)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F28))","v":""}]
[false,14,"Resource List (Temporary Resources and Staff Augmentation)\n","Not Required","Preliminary","Preliminary","Defined","Defined",{"$f":"IF('Class 1 Checklist'!F29 =\"\",   IF('Class 2 Checklist'!F29 =\"\",   IF('Class 3 Checklist'!F29 =\"\",    IF('Class 4 Checklist'!F29 =\"\",    IF('Class 5 Checklist'!F29 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F29)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F29)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F29)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F29)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F29))","v":""}]
[false,15,"Testing Strategy/Plan\n","Not Required","Not Required","Preliminary","Preliminary","Defined",{"$f":"IF('Class 1 Checklist'!F30 =\"\",   IF('Class 2 Checklist'!F30 =\"\",   IF('Class 3 Checklist'!F30 =\"\",    IF('Class 4 Checklist'!F30 =\"\",    IF('Class 5 Checklist'!F30 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F30)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F30)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F30)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F30)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F30))","v":""}]
["Select all applicable deliverables","#","TECHNICAL DESIGN DELIVERABLES"]
[true,null," ","Class 5","Class 4","Class 3","Class 2","Class 1","Comments:"]
[false,16,"Solution Design\n","NR","S ","S/P","P","C",{"$f":"IF('Class 1 Checklist'!F33 =\"\",   IF('Class 2 Checklist'!F33 =\"\",   IF('Class 3 Checklist'!F33 =\"\",    IF('Class 4 Checklist'!F33 =\"\",    IF('Class 5 Checklist'!F33 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F33)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F33)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F33)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F33)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F33))","v":""}]
[false,17,"Technology List\n","NR","S","P ","P/C","C",{"$f":"IF('Class 1 Checklist'!F34 =\"\",   IF('Class 2 Checklist'!F34 =\"\",   IF('Class 3 Checklist'!F34 =\"\",    IF('Class 4 Checklist'!F34 =\"\",    IF('Class 5 Checklist'!F34 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F34)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F34)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F34)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F34)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F34))","v":""}]
[false,18,"Data Migration Plan\n","NR","NR","S","P","C",{"$f":"IF('Class 1 Checklist'!F35 =\"\",   IF('Class 2 Checklist'!F35 =\"\",   IF('Class 3 Checklist'!F35 =\"\",    IF('Class 4 Checklist'!F35 =\"\",    IF('Class 5 Checklist'!F35 =\"\", \"\", CONCATENATE(\"C5:\",\" \", 'Class 5 Checklist'!F35)),\n CONCATENATE(\"C4:\",\" \", 'Class 4 Checklist'!F35)), CONCATENATE(\"C3:\",\" \", 'Class 3 Checklist'!F35)), CONCATENATE(\"C2:\",\" \", 'Class 2 Checklist'!F35)), CONCATENATE(\"C1:\",\" \", 'Class 1 Checklist'!F35))","v":""}]

{"sheet":"Class 5 Checklist","index":3,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[8,2,8,4],[30,2,30,4],[5,2,5,3],[3,2,3,3]]}
[true,null,null,null," "]
[true,null," ","Title:",{"$f":"Title","v":0},"Class 5"]
[true,null," ","Description:",{"$f":"Description","v":0}]
[true,null,"Business Case ID:",null,{"$f":"BC_ID","v":0}]
[true,null," "," Date:"]
[true,null,"Class of Estimate Author: \n(and other Contributors, as required)"]
[true," "]
[true," "," "," ","Key Deliverable and Target Status:       \n CLASS 5 \n\n              1% Project Definition Complete\n              1% Design Complete\n\n","        Legend:\n* City of Winnipeg net new deliverable.      "]
[true," ","GENERAL PROJECT DATA DELIVERABLES:"]
[true,"#","Deliverable","Maturity Level"," Assessment description, characteristics:"," Comments:"]
[true,null,"A. SCOPE:",null," "," "]
[{"$f":"'CoE Summary'!A40","v":false},1,"Project Scope of Work \n","Preliminary","• General description of scope of work (narrative)."]
[{"$f":"'CoE Summary'!A41","v":true},null,"B.PROJECT LOCATION:",null," "," "]
[{"$f":"'CoE Summary'!A42","v":false},2,"Project Location\n","Not Required"]
[{"$f":"'CoE Summary'!A43","v":true},null,"C.REQUIREMENTS:",null," "," "]
[{"$f":"'CoE Summary'!A44","v":false},3,"Privacy Impact Assessment\n","Not Required"]
[{"$f":"'CoE Summary'!A45","v":false},4,"Functional and Non-Functional Requirements\n","Not Required"]
[{"$f":"'CoE Summary'!A46","v":false},5,"Workforce Management Technology Requirements\n\n","Not Required"]
[{"$f":"'CoE Summary'!A47","v":false},6,"Information Security Requirements\n","Not Required"]
[{"$f":"'CoE Summary'!A48","v":true},null,"D.STRATEGY:",null," "," "]
[{"$f":"'CoE Summary'!A49","v":false},7,"Contracting/Sourcing\n","Not Required"]
[{"$f":"'CoE Summary'!A50","v":false},8,"Organizational Change Management \n","Not Required"]
[{"$f":"'CoE Summary'!A51","v":true},null,"E.PLANNING:",null," "," "]
[{"$f":"'CoE Summary'!A52","v":false},9,"Project Delivery Plan\n","Not Required"]
[{"$f":"'CoE Summary'!A53","v":false},10,"Project Schedule\n","Not Required"]
[{"$f":"'CoE Summary'!A54","v":false},11,"Risk Register\n","Not Required"]
[{"$f":"'CoE Summary'!A55","v":false},12,"Stakeholder Consultation/Engagement/Management Plan\n","Not Required"]
[{"$f":"'CoE Summary'!A56","v":false},13,"Training Plan\n","Not Required"]
[{"$f":"'CoE Summary'!A57","v":false},14,"Resource List (Temporary Resources and Staff Augmentation)\n","Not Required"]
[{"$f":"'CoE Summary'!A58","v":false},15,"Testing Strategy/Plan\n","Not Required"]
[{"$f":"'CoE Summary'!A59","v":"Select all applicable deliverables"}," ","TECHNICAL DESIGN DELIVERABLES:",null,null," "]
[{"$f":"'CoE Summary'!A60","v":true},"#","Deliverable","Maturity Level","Assessment description, characteristics:","Comments:"]
[{"$f":"'CoE Summary'!A61","v":false},16,"Solution Design \n","Not Required"]
[{"$f":"'CoE Summary'!A62","v":false},17,"Technology List\n","Not Required"]
[{"$f":"'CoE Summary'!A63","v":false},18,"Data Migration Plan\n","Not Required"]

{"sheet":"Class 4 Checklist","index":4,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[[5,2,5,3],[8,2,8,4],[30,2,30,4],[3,2,3,3]]}
[true,null,null,null," "]
[true,null," ","Title:",{"$f":"Title","v":0},"Class 4  "]
[true,null," ","Description:",{"$f":"Description","v":0}]
[true,null,"Business Case ID:",null,{"$f":"BC_ID","v":0}]
[true,null," "," Date:"]
[true,null,"Class of Estimate Author: \n(and other Contributors, as required)"]
[true," "]
[true," ",null," ","Key Deliverable and Target Status:\n  CLASS 4 \n\n               10% Project Definition Complete\n               10% Design Complete   ","         Legend:\n* City of Winnipeg net new deliverable.     "]
[true," ","GENERAL PROJECT DATA DELIVERABLES:"]
[true,"#","Deliverable","Maturity Level"," Assessment description, characteristics:","Comments:"]
[true,null,"A. SCOPE:",null," "," "]
[{"$f":"'CoE Summary'!A40","v":false},1,"Project Scope of Work ","Preliminary","• Preliminary general scope of work narrative into a Scope Statement to ensure it addresses the project purpose and need. \n"]
[{"$f":"'CoE Summary'!A41","v":true},null,"B.PROJECT LOCATION:"]
[{"$f":"'CoE Summary'!A42","v":false},2,"Project Location\n","Not Required"]
[{"$f":"'CoE Summary'!A43","v":true},null,"C.REQUIREMENTS:",null," "," "]
[{"$f":"'CoE Summary'!A44","v":false},3,"Privacy Impact Assessment\n","Preliminary","• Access and Privacy Guidance reviewed and incorporated into design.\n• The need for Personal information as defined by Freedom of Information and the Protection of Privacy Act (FIPPA) and Personal Health Information Act (PHIA) , to be collected, used, or disclosed for the new project/program to function as intended is identified. \n• Privacy Impact Assessment form started.\n"]
[{"$f":"'CoE Summary'!A45","v":false},4,"Functional and Non-Functional Requirements\n","Preliminary","• For Waterfall methodology:\n   - Brief narrative describing what business functions the initiative will deliver, including the problem and/or opportunity the initiative will address and the business driver(s).  \n\n• For Agile methodology: \n   - Preliminary draft of wireframes and/or storyboards.\n"]
[{"$f":"'CoE Summary'!A46","v":false},5,"Workforce Management Technology Requirements\n","Preliminary","• Workforce Management Technology (WMT) form started."]
[{"$f":"'CoE Summary'!A47","v":false},6,"Information Security Requirements\n","Preliminary","• Consultations conducted with Departmental IT representatives and Information Security subject matter experts, for project team to be made aware of general information security requirements.\n"]
[{"$f":"'CoE Summary'!A48","v":true},null,"D.STRATEGY:",null," "," "]
[{"$f":"'CoE Summary'!A49","v":false},7,"Contracting/Sourcing","Preliminary","• Contracting or sourcing assumed.\n"]
[{"$f":"'CoE Summary'!A50","v":false},8,"Organizational Change Management  \n","Preliminary","• Need for organizational change management for the people impact of the project assumed.   \n• Stakeholders and sponsors identified.\n"]
[{"$f":"'CoE Summary'!A51","v":true},null,"E.PLANNING:",null," "," "]
[{"$f":"'CoE Summary'!A52","v":false},9,"Project Delivery Plan","Preliminary","• Major scope elements identified.\n• Involvement from major business units within the organization (technical, communications, legal, procurement, etc.) and their expected contribution identified.\n"]
[{"$f":"'CoE Summary'!A53","v":false},10,"Project Schedule","Preliminary","• Preliminary project schedule with general timelines and major deliverables outlined.\n"]
[{"$f":"'CoE Summary'!A54","v":false},11,"Risk Register","Preliminary","• High Level (overarching) project risks identified based on the collective experience on similar projects\n• Risk level identified;\n• Mitigation measures identified.\n\n"]
[{"$f":"'CoE Summary'!A55","v":false},12,"Stakeholder Consultation/Engagement/Management Plan","Preliminary","• Major external stakeholders identified.\n"]
[{"$f":"'CoE Summary'!A56","v":false},13,"Training Plan\n","Not Required"]
[{"$f":"'CoE Summary'!A57","v":false},14,"Resource List (Temporary Resources and Staff Augmentation)\n","Preliminary","• Need for Project Staff resources with specific skillsets assumed."]
[{"$f":"'CoE Summary'!A58","v":false},15,"Testing Strategy/Plan\n","Not Required"]
[{"$f":"'CoE Summary'!A59","v":"Select all applicable deliverables"}," ","TECHNICAL DESIGN DELIVERABLES:",null,null," "]
[{"$f":"'CoE Summary'!A60","v":true},"#","Deliverable","Maturity Level","Assessment description, characteristics:","Comments:"]
[{"$f":"'CoE Summary'!A61","v":false},16,"Solution Design \n","Started","• Conceptual-level design of the solution identified."]
[{"$f":"'CoE Summary'!A62","v":false},17,"Technology List\n","Started","• Technology list and general specifications started, based on preliminary consultations with Departmental IT representatives and infrastructure subject matter experts.\n"]
[{"$f":"'CoE Summary'!A63","v":false},18,"Data Migration Plan\n","Not Required"]
[{"$f":"'CoE Summary'!A65","v":0}]
[{"$f":"'CoE Summary'!A66","v":0}]
[{"$f":"'CoE Summary'!A67","v":0}]
[{"$f":"'CoE Summary'!A68","v":0}]
[{"$f":"'CoE Summary'!A69","v":0}]
[{"$f":"'CoE Summary'!A70","v":0}]
[{"$f":"'CoE Summary'!A71","v":0}]
[{"$f":"'CoE Summary'!A72","v":0}]
[{"$f":"'CoE Summary'!A73","v":0}]
[{"$f":"'CoE Summary'!A74","v":0}]
[{"$f":"'CoE Summary'!A75","v":0}]
[{"$f":"'CoE Summary'!A76","v":0}]
[{"$f":"'CoE Summary'!A77","v":0}]
[{"$f":"'CoE Summary'!A78","v":0}]
[{"$f":"'CoE Summary'!A79","v":0}]
[{"$f":"'CoE Summary'!A80","v":0}]
[{"$f":"'CoE Summary'!A81","v":0}]
[{"$f":"'CoE Summary'!A82","v":0}]
[{"$f":"'CoE Summary'!A83","v":0}]
[{"$f":"'CoE Summary'!A84","v":0}]
[{"$f":"'CoE Summary'!A85","v":0}]
[{"$f":"'CoE Summary'!A86","v":0}]
[{"$f":"'CoE Summary'!A87","v":0}]
[{"$f":"'CoE Summary'!A88","v":0}]

{"sheet":"Class 3 Checklist","index":5,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[[5,2,5,3],[30,2,30,4],[8,2,8,4],[3,2,3,3]]}
[true,null,null,null," "]
[true,null,null,"Title:",{"$f":"Title","v":0}," Class 3"]
[true,null,null,"Description:",{"$f":"Description","v":0}]
[true,null," Business Case ID:",null,{"$f":"BC_ID","v":0}]
[true,null,null," Date:"]
[true,null,"Class of Estimate Author: \n(and other Contributors, as required)"]
[true," "]
[true,null," "," ","Key Deliverable and Target Status \n CLASS 3   \n\n             30% Project Definition Complete\n             30% Design Complete      \n","       Legend:\n* City of Winnipeg net new deliverable.      "]
[true," ","GENERAL PROJECT DATA DELIVERABLES:"]
[true,"#","Deliverable","Maturity Level"," Assessment description, characteristics:","Comments:"]
[true,null,"A. SCOPE:",null," "," "]
[{"$f":"'CoE Summary'!A40","v":false},1,"Project Scope of Work ","Defined","• Preliminary scope statement that describes the project’s problem statement, goals and objectives, and inclusions and exclusions. \n"]
[{"$f":"'CoE Summary'!A41","v":true},null,"B.PROJECT LOCATION:",null," "," "]
[{"$f":"'CoE Summary'!A42","v":false},2,"Project Location\n","Preliminary","• General area(s) of assets, materials and equipment installed or deployed, as described in the Scope of Work, identified, if applicable.\n• General area(s) where the Work is performed identified, if applicable (i.e. virtual, City-owned property, private-owned property, etc.).\n• Areas defined at low resolution, such as a neighborhood or ward, an office building, a treatment plant, virtually over the internet, etc.\n"]
[{"$f":"'CoE Summary'!A43","v":true},null,"C.REQUIREMENTS:",null," "," "]
[{"$f":"'CoE Summary'!A44","v":false},3,"Privacy Impact Assessment\n","Defined","• The need for Personal information as defined by Freedom of Information and the Protection of Privacy Act (FIPPA) and Personal Health Information Act (PHIA) , to be collected, used, or disclosed for the new project/program to function as intended is confirmed. \n• Revised Privacy Impact Assessment form, as required.\n"]
[{"$f":"'CoE Summary'!A45","v":false},4,"Functional and Non-Functional Requirements\n","Defined","• For Waterfall methodology:\n   - List of high-level business needs.  \n   - Typically comprised of 10-20 requirements at a sufficient level of detail for a vendor market scan. \n   - Includes boilerplate non-functional requirements.   \n\n• For Agile methodology:\n   - 30% core set of user stories identified and signed off by stakeholders.\n"]
[{"$f":"'CoE Summary'!A46","v":false},5,"Workforce Management Technology Requirements\n","Defined","• Workforce Management Technology (WMT) form completed.\n• WMT process initiated and acknowledgement received from WMT Committee.\n"]
[{"$f":"'CoE Summary'!A47","v":false},6,"Information Security Requirements\n","Preliminary","• Further consultations conducted with Departmental IT representatives and Information Security subject matter experts, as required.\n• General Information Security requirements identified, as required. \n"]
[{"$f":"'CoE Summary'!A48","v":true},null,"D.STRATEGY:",null," "," "]
[{"$f":"'CoE Summary'!A49","v":false},7,"Contracting/Sourcing","Preliminary","• Contracting or sourcing strategy (e.g. RFI, RFP, Single Sourcing) identified.\n"]
[{"$f":"'CoE Summary'!A50","v":false},8,"Organizational Change Management \n","Defined","• Scope of work for Organizational Change Management effort (change characteristics, readiness assessment, stakeholder assessment, risk assessment) assumed.  \n• Cost for organizational change management resources estimated.\n"]
[{"$f":"'CoE Summary'!A51","v":true},null,"E.PLANNING:",null," "," "]
[{"$f":"'CoE Summary'!A52","v":false},9,"Project Delivery Plan","Defined","• Business Owner agreed to scope/quality, schedule and budget and committed to project.\n• Preliminary project delivery plan components, including scope statement, stakeholders identification and assessment, budget, schedule, milestones, deliverables and phasing of work packages started.\n• Subsidiary plans such as communications and stakeholder engagement plan and risk management, etc., started.\n"]
[{"$f":"'CoE Summary'!A53","v":false},10,"Project Schedule","Defined","• Preliminary major milestones identified.\n• Phasing of work packages identified. \n• Work components that will be completed internally and those that may be resourced externally assumed. \n•  Revised preliminary project schedule.\n"]
[{"$f":"'CoE Summary'!A54","v":false},11,"Risk Register","Defined","• Project risk register started.\n• Preliminary systemic and project-specific risks identified.  \n• Risk-based contingency amounts assumed based on similar past projects, historical data, and parametric analysis, as required.\n"]
[{"$f":"'CoE Summary'!A55","v":false},12,"Stakeholder Consultation/Engagement/Management Plan","Defined","• Preliminary Stakeholder Communication Plan developed.\n• If applicable, preliminary Public Engagement Strategy (using the City`s Office of Public Engagement template) developed. \n"]
[{"$f":"'CoE Summary'!A56","v":false},13,"Training Plan\n","Preliminary","• Impact on stakeholders assumed.\n• Training groups assumed. e.g. Public, 311, System Support, etc. \n• High level number of resources required to conduct training assumed.\n"]
[{"$f":"'CoE Summary'!A57","v":false},14,"Resource List (Temporary Resources and Staff Augmentation)\n"," Preliminary","• Project Staff resource(s) required to perform scope of work  identified. \n• Total number of Project Staff resources required and total hours and costs estimated. \n"]
[{"$f":"'CoE Summary'!A58","v":false},15,"Testing Strategy/Plan\n"," Preliminary","• For Waterfall methodology:\n   - Test Strategy/Plan started and may include: \n      - types of testing that could be performed (e.g. integration testing, end to end testing, etc.);\n      - defect reporting and management process;\n      - process for developing and prioritizing test cases;\n      - test status/results reporting;\n      - test tools/software;\n      - severity definitions;\n      - roles and responsibilities of stakeholders in testing process. \n• For Agile methodology:\n   - 30% core set of test cases identified.\n\n"]
[{"$f":"'CoE Summary'!A59","v":"Select all applicable deliverables"}," ","TECHNICAL DESIGN DELIVERABLES:",null,null," "]
[{"$f":"'CoE Summary'!A60","v":true},"#","Deliverable","Maturity Level","Assessment description, characteristics:","Comments:"]
[{"$f":"'CoE Summary'!A61","v":false},16,"Solution Design \n","Started/ Preliminary","• Conceptual-level design of the solution refined and should identify high-level assumptions that may impact the design.\n• Major functional, non-functional, and/or quality of service requirements identified."]
[{"$f":"'CoE Summary'!A62","v":false},17,"Technology List\n"," Preliminary","• Items on technology list assumed. \n• One or more cost estimates (i.e. MRSP, list price or quotes) obtained for items on technology list with assumed specifications.\n"]
[{"$f":"'CoE Summary'!A63","v":false},18,"Data Migration Plan\n","Started ","• For Waterfall methodology:\n   - Data migration scope assumed.\n      - what portion of data should be migrated;\n      - what portion of data should be left behind;\n      - what portion of data should be migrated manually.\n• For Agile methodology:\n   - 30% of data to be migrated identified.\n"]
[{"$f":"'CoE Summary'!A65","v":0}]
[{"$f":"'CoE Summary'!A66","v":0}]
[{"$f":"'CoE Summary'!A67","v":0}]
[{"$f":"'CoE Summary'!A68","v":0}]
[{"$f":"'CoE Summary'!A69","v":0}]
[{"$f":"'CoE Summary'!A70","v":0}]
[{"$f":"'CoE Summary'!A71","v":0}]
[{"$f":"'CoE Summary'!A72","v":0}]
[{"$f":"'CoE Summary'!A73","v":0}]
[{"$f":"'CoE Summary'!A74","v":0}]
[{"$f":"'CoE Summary'!A75","v":0}]
[{"$f":"'CoE Summary'!A76","v":0}]
[{"$f":"'CoE Summary'!A77","v":0}]
[{"$f":"'CoE Summary'!A78","v":0}]
[{"$f":"'CoE Summary'!A79","v":0}]
[{"$f":"'CoE Summary'!A80","v":0}]
[{"$f":"'CoE Summary'!A81","v":0}]
[{"$f":"'CoE Summary'!A82","v":0}]
[{"$f":"'CoE Summary'!A83","v":0}]
[{"$f":"'CoE Summary'!A84","v":0}]
[{"$f":"'CoE Summary'!A85","v":0}]
[{"$f":"'CoE Summary'!A86","v":0}]
[{"$f":"'CoE Summary'!A87","v":0}]
[" "]

{"sheet":"Class 2 Checklist","index":6,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[[8,2,8,4],[30,2,30,4],[5,2,5,3],[3,2,3,3]]}
[true,null,null,null," "]
[true,null,null,"Title:",{"$f":"Title","v":0},"Class 2"]
[true,null,null,"Description:",{"$f":"Description","v":0}]
[true,null," Business Case ID:",null,{"$f":"BC_ID","v":0}]
[true,null,null," Date:"]
[true,null,"Class of Estimate Author: \n(and other Contributors, as required)"]
[true," "]
[true," "," "," ","Key Deliverable and Target Status \n CLASS 2   \n \n              60% Project Definition Complete\n              60% Design Complete\n ","          Legend:\n* City of Winnipeg net new deliverable.              "]
[true," ","GENERAL PROJECT DATA DELIVERABLES:"]
[true,"#","Deliverable","Maturity Level"," Assessment description, characteristics:","Comments:"]
[true,null,"A. SCOPE:",null," "," "]
[{"$f":"'CoE Summary'!A40","v":false},1,"Project Scope of Work \n","Defined","• Revised scope statement with assumptions and constraints (performance, time, resources, etc.) stated.\n"]
[{"$f":"'CoE Summary'!A41","v":true},null,"B.PROJECT LOCATION:",null," "," "]
[{"$f":"'CoE Summary'!A42","v":false},2,"Project Location\n","Defined","• Revised area(s) of assets, materials and equipment installed or deployed, as described in the Scope of Work, as applicable, based on project changes and detailed design progression, as required.\n• Revised area(s) where the Work is performed, as applicable, based on project changes and detailed design progression, as required.\n• Areas defined at higher resolution, such as physical street addresses, GPS coordinates, virtually using a specific tool such as MS Teams, Zoom, WebEx, etc. \n"]
[{"$f":"'CoE Summary'!A43","v":true},null,"C.REQUIREMENTS:",null," "]
[{"$f":"'CoE Summary'!A44","v":false},3,"Privacy Impact Assessment\n","Defined","• Privacy Impact Assessment form completed and submitted to the City`s Access and Privacy Office.\n• Receipt of submission acknowledged by City’s Access and Privacy Office and may provide comments and/or conditions.\n"]
[{"$f":"'CoE Summary'!A45","v":false},4,"Functional and Non-Functional Requirements\n","Defined","• For Waterfall methodology: \n   - Business Requirements Document (BRD) complete and signed off by stakeholders. BRD includes:\n   - System agnostic narrative functional requirements describing what business users need to do and why.  \n   - Non-functional requirements specifying users’ expectations of system capabilities, e.g. availability, performance, scalability, usability.\n\n• For Agile methodology:\n   - 75% core set of user stories defined, signed off by stakeholders and in an actionable state for development.\n\n• For Commercial-off-the-shelf (COTS):\n   - Requirements (both functional and non-functional) for RFP.\n"]
[{"$f":"'CoE Summary'!A46","v":false},5,"Workforce Management Technology Requirements\n","Defined","• WMT submission results received with conditional approval to proceed.\n• Conditions may include a new/revised WMT submission once a solution option is chosen and the solution is better defined.  \n• If Workforce Management Technology (WMT) conditions existed, conditions are actioned and tracked.  \n"]
[{"$f":"'CoE Summary'!A47","v":false},6,"Information Security Requirements\n","Defined","• Further consultations conducted with Departmental IT representatives and Information Security subject matter experts, as required.\n• Revised Information Security requirements based on project changes and detailed design progression, as required. \n"]
[{"$f":"'CoE Summary'!A48","v":true},null,"D.STRATEGY:",null," "," "]
[{"$f":"'CoE Summary'!A49","v":false},7,"Contracting/Sourcing\n","Defined","• Major sourcing documents (e.g. RFP document) started, as required. \n"]
[{"$f":"'CoE Summary'!A50","v":false},8,"Organizational Change Management \n","Defined","• Scope of work for Organizational Change Management effort identified with inputs from key stakeholders.\n• Cost for organizational change management resources refined.\n"]
[{"$f":"'CoE Summary'!A51","v":true},null,"E.PLANNING:",null," "," "]
[{"$f":"'CoE Summary'!A52","v":false},9,"Project Delivery Plan\n","Defined","• Revised Project Delivery Plan, based on project changes and detailed design progression, as required.\n"]
[{"$f":"'CoE Summary'!A53","v":false},10,"Project Schedule\n","Defined","• Critical paths identified.\n• Major milestones finalized.\n• Project deliverables decomposed into further detail.\n• Preliminary activities under work packages with general timelines and potential resource assignments identified.\n• Revised Project Schedule based on project changes and detailed design progression, as required.\n"]
[{"$f":"'CoE Summary'!A54","v":false},11,"Risk Register\n","Defined","• Risk register reviewed and revised based on project changes and detailed design progression, as required. \n"]
[{"$f":"'CoE Summary'!A55","v":false},12,"Stakeholder Consultation/Engagement/Management Plan\n","Defined","• Stakeholder Communication Plan further developed outlining objectives & key messages, methods & mediums, timing, schedule & frequency, and feedback mechanisms.\n• If applicable, Public Engagement Strategy methodology (frequency and methods of engagement) defined.\n"]
[{"$f":"'CoE Summary'!A56","v":false},13,"Training Plan\n","Defined","• Impact on stakeholders defined.\n• Training groups identified.\n• Training outcome measures identified.\n• High level number of resources required to conduct training defined.\n "]
[{"$f":"'CoE Summary'!A57","v":false},14,"Resource List (Temporary Resources and Staff Augmentation)\n","Defined","• Project Staff resource(s) required to perform scope of work  refined. \n• Total number of Project Staff resources required and total hours and costs refined.\n"]
[{"$f":"'CoE Summary'!A58","v":false},15,"Testing Strategy/Plan\n","Preliminary","• For Waterfall methodology:\n   -Test Strategy/Plan started and may include:\n      - types of testing that could be performed (e.g. integration testing, end to end testing, etc.);\n      - defect reporting and management process;\n      - process for developing and prioritizing test cases;\n      - test status/results reporting;\n      - test tools/software;\n      - severity definitions;\n      - roles and responsibilities of stakeholders in testing process. \n• For Agile methodology:\n   - 30% core set of test cases identified.\n"]
[{"$f":"'CoE Summary'!A59","v":"Select all applicable deliverables"}," ","TECHNICAL DESIGN DELIVERABLES:",null,null," "]
[{"$f":"'CoE Summary'!A60","v":true},"#","Deliverable","Maturity Level","Assessment description, characteristics:","Comments:"]
[{"$f":"'CoE Summary'!A61","v":false},16,"Solution Design\n","Preliminary","• Conceptual-level design of the solution complete.\n• Logical solution design started and is based on the conceptual-level design of the solution.\n"]
[{"$f":"'CoE Summary'!A62","v":false},17,"Technology List\n","Preliminary/ Complete","• Refined requirement description (technology specifications) and general features. \n• Refined technology list, based on project changes and detailed design progression, as required.\n"]
[{"$f":"'CoE Summary'!A63","v":false},18,"Data Migration Plan\n"," Preliminary","• For Waterfall methodology:\n   - Current state data model documented.\n   - Current state data record counts identified. \n• For Agile methodology:\n   - 60% of data to be migrated identified.\n"]
[{"$f":"'CoE Summary'!A65","v":0}]
[{"$f":"'CoE Summary'!A66","v":0}]
[{"$f":"'CoE Summary'!A67","v":0}]
[{"$f":"'CoE Summary'!A68","v":0}]
[{"$f":"'CoE Summary'!A69","v":0}]
[{"$f":"'CoE Summary'!A70","v":0}]
[{"$f":"'CoE Summary'!A71","v":0}]
[{"$f":"'CoE Summary'!A72","v":0}]
[{"$f":"'CoE Summary'!A73","v":0}]
[{"$f":"'CoE Summary'!A74","v":0}]
[{"$f":"'CoE Summary'!A75","v":0}]
[{"$f":"'CoE Summary'!A76","v":0}]
[{"$f":"'CoE Summary'!A77","v":0}]
[{"$f":"'CoE Summary'!A78","v":0}]
[{"$f":"'CoE Summary'!A79","v":0}]
[{"$f":"'CoE Summary'!A80","v":0}]
[{"$f":"'CoE Summary'!A81","v":0}]
[{"$f":"'CoE Summary'!A82","v":0}]
[{"$f":"'CoE Summary'!A83","v":0}]
[{"$f":"'CoE Summary'!A84","v":0}]
[{"$f":"'CoE Summary'!A85","v":0}]
[{"$f":"'CoE Summary'!A86","v":0}]
[{"$f":"'CoE Summary'!A87","v":0}]
[" "]

{"sheet":"Class 1 Checklist","index":7,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,2,30,4],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[8,2,8,4]]}
[true,null,null,null," "]
[true,null,"Title:",null,{"$f":"Title","v":0},"Class 1"]
[true,null,"Description:",null,{"$f":"Description","v":0}]
[true,null," Business Case ID:",null,{"$f":"BC_ID","v":0}]
[true,null," Date:"]
[true,null,"Class of Estimate Author: \n(and other Contributors, as required)"]
[true," "]
[true," "," "," ","Key Deliverable and Target Status \n CLASS 1   \n\n              99% Project Definition Complete\n              99% Design Complete\n ","          Legend:\n* City of Winnipeg net new deliverable.     "]
[true," ","GENERAL PROJECT DATA DELIVERABLES:"]
[true,"#","Deliverable","Maturity Level"," Assessment description, characteristics:","Comments:"]
[true,null,"A. SCOPE:",null," "," "]
[{"$f":"'CoE Summary'!A40","v":false},1,"Project Scope of Work \n","Defined","• Revised project scope of work based on project changes, and detailed design progression, as required.\n• Final Project Scope of Work complete.\n"]
[{"$f":"'CoE Summary'!A41","v":true},null,"B.PROJECT LOCATION:",null," "," "]
[{"$f":"'CoE Summary'!A42","v":false},2,"Project Location\n","Defined","• Revised area(s) of assets, materials and equipment installed or deployed, as described in the Scope of Work, as applicable, based on project changes and detailed design progression, as required.\n• Revised area(s) where the Work is performed, as applicable, based on project changes and detailed design progression, as required.\n• Areas defined at the highest resolution, such as specific physical spaces within a building including descriptors of mounting locations such as walls, ceilings, floor, crawlspaces; descriptors where work activities are conducted such as seating layouts for workspaces, etc.; and virtually with tools identified and details of how to use chosen tools such as app installation instructions, VPN requirements, link details, meeting keys and passwords, groups and breakout rooms, etc.\n• Final Project Location complete.\n"]
[{"$f":"'CoE Summary'!A43","v":true},null,"C.REQUIREMENTS:",null," "," "]
[{"$f":"'CoE Summary'!A44","v":false},3,"Privacy Impact Assessment\n","Defined","• If comments and/or condition(s) are provided by City’s Access and Privacy Office, the comments and/or conditions must be addressed, actioned and tracked and resubmitted to the City`s Access and Privacy Office, as required.\n• If required, receipt of re-submission acknowledged by City’s Access and Privacy Office.\n• Privacy Impact Assessment process complete, as indicated by correspondence from the City’s Access and Privacy Office."]
[{"$f":"'CoE Summary'!A45","v":false},4,"Functional and Non-Functional Requirements\n","Defined","• For Waterfall methodology: \n   - Functional Specifications Document complete.  \n      - System-specific requirements defined, describing exactly how the system works and detailing all the interactions between the system and the users. \n      - May include use cases, user interface mockups, messages, business rules, user roles and access rules, and system interface specifications.\n\n• For Agile methodology: \n   - 100% core set of user stories defined, signed off by stakeholders and in an actionable state for development. \n\n• For Commercial-off-the-shelf (COTS): \n   - Where possible as determined by selected vendor, Fit Gap Assessment complete and required customizations identified.\n"]
[{"$f":"'CoE Summary'!A46","v":false},5,"Workforce Management Technology Requirements\n","Defined","• If Workforce Management Technology (WMT) conditions existed, WMT form resubmitted. \n• WMT submission results received with unconditional approval to proceed or with effective permanent workarounds implemented to address remaining conditions.  \n"]
[{"$f":"'CoE Summary'!A47","v":false},6,"Information Security Requirements\n","Defined","• Further consultations conducted with Departmental IT representatives and Information Security subject matter experts, as required.\n• Revised Information Security requirements based on project changes and detailed design progression, as required. \n• Final Information Security requirements complete.\n"]
[{"$f":"'CoE Summary'!A48","v":true},null,"D.STRATEGY:",null," "," "]
[{"$f":"'CoE Summary'!A49","v":false},7,"Contracting/Sourcing\n","Defined","• Major sourcing documents complete, as required.\n"]
[{"$f":"'CoE Summary'!A50","v":false},8,"Organizational Change Management \n","Defined","• Organizational Change Management and communication plan complete.\n• Cost for organizational change management resources defined.\n"]
[{"$f":"'CoE Summary'!A51","v":true},null,"E.PLANNING:",null," "," "]
[{"$f":"'CoE Summary'!A52","v":false},9,"Project Delivery Plan\n","Defined","• Revised Project Delivery Plan, based on project changes and detailed design progression, as required.\n• Final Project Delivery Plan complete.\n"]
[{"$f":"'CoE Summary'!A53","v":false},10,"Project Schedule\n","Defined","• All deliverables finalized.\n• Critical paths finalized.\n• WBS finalized, which includes all work packages, activities, timelines, resource assignments and associated costs\n• Resources and time commitment for each activity identified.\n• Revised Project Schedule based on project changes and detailed design progression, as required.\n• Final Project Schedule complete.\n"]
[{"$f":"'CoE Summary'!A54","v":false},11,"Risk Register\n","Defined","• Risk register reviewed and revised based on project changes and detailed design progression, as required. \n"]
[{"$f":"'CoE Summary'!A55","v":false},12,"Stakeholder Consultation/Engagement/Management Plan\n","Defined","• Revised Stakeholder Communication Plan based on project changes and detail design progression, as required. \n• Stakeholder Communication Plan finalized.\n• If applicable, revised Public Engagement Strategy based on project changes and detailed design progression, as required.\n• If applicable, Public Engagement Strategy finalized.\n"]
[{"$f":"'CoE Summary'!A56","v":false},13,"Training Plan\n","Defined","• Training outcome measures defined.\n• High-level training needs assessment complete.\n• Training groups finalized. \n• Training plan developed and complete.\n"]
[{"$f":"'CoE Summary'!A57","v":false},14,"Resource List (Temporary Resources and Staff Augmentation)\n","Defined","• Final list of Project Staff resource(s) required to perform scope of work complete. \n• Final tabulation of total number of Project Staff resources required and total hours and costs complete.\n"]
[{"$f":"'CoE Summary'!A58","v":false},15,"Testing Strategy/Plan\n","Defined","• For Waterfall methodology: \n   - Test Strategy/Plan complete.\n   - Test cases written and may include:\n      - input data, as appropriate; \n      - detailed test scripts, as appropriate.\n   - Test schedule finalized.\n• For Agile methodology:\n   - 95% core set of test cases identified.\n"]
[{"$f":"'CoE Summary'!A59","v":"Select all applicable deliverables"}," ","TECHNICAL DESIGN DELIVERABLES:",null,null," "]
[{"$f":"'CoE Summary'!A60","v":true},"#","Deliverable","Maturity Level","Assessment description, characteristics:","Comments:"]
[{"$f":"'CoE Summary'!A61","v":false},16,"Solution Desgin\n","Complete","• Logical solution design complete."]
[{"$f":"'CoE Summary'!A62","v":false},17,"Technology List\n","Complete","• Refined requirement description (technology specifications) and general features, based on project changes and detailed design progression, as required.\n• Refined technology list, based on project changes and detailed design progression, as required.\n• Final technology list complete.\n"]
[{"$f":"'CoE Summary'!A63","v":false},18,"Data Migration Plan\n","Complete","• For Waterfall methodology:\n   - Data migration scope defined:\n      - what portion of data should be migrated;\n      - what portion of data should be left behind;\n      - what portion of data should be migrated manually.\n   - Migration Plan complete and includes:\n      - future state data model;\n      - source to target data mapping;\n      - migration approach, goals, roles of team members, team members responsibility assumptions, constraints and gaps;\n      - data migration process diagram;\n      - development tools.\n• For Agile methodology:\n   - 95% of data to be migrated identified.\n"]
[]
[" "]