{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["CoverSheet","Assessment Definitions","Instructions","Framework","Survey","Scoring Detail","Scoring Summary","SlidebarMetrics","Set Parameters","Instructions (2)","Debug"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":12,"comments":0,"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":"CoverSheet","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Assessment Definitions","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,2,0,18]]}
[null,null,"Data Management & Data Analytics Assessment Survey Definitions"]
[]
[null,"Terms","Definitions"]
[null,"Business rules","A business rule is an agreement driven from the business process which applies to the fields in a master data object. These business rules are linked to fields in a master data object in the data rule book"]
[null,"Data Architecture","This section evaluates the maturity of the <business unit> Data Governance Data Quality Strategy and Program capabilities as they relate to best practices in Data Governance.  Data Architecture, for this context, defines the technical requirements and architectural framework associated with integrating data into the business processes and downstream systems of the <business unit> organization for data governance."]
[null,"Data Management Methodology","This section evaluates the maturity of the <business unit> Data Governance Data Management Methodology capabilities as they relate to best practices in Data Governance. The Data Management Methodology, for this context, is the systematic and theoretical analysis of how data is managed, organized, linked, and funded within the <business unit> data governance program and embedded into the operational philosophy of the organization. "]
[null,"Data Monitoring and Reporting","This section evaluates the maturity of the <business unit> Data Governance Data Monitoring and Reporting capabilities as they relate to best practices in Data Governance. Data Monitoring and Reporting, for this context, are the <business unit> capabilities to review, evaluate, and modify the addition, deletion, modification and use of governed data.  It enables the governance administration activities to review the overall governance processes and functions performed on the data graphically or through pre-defined reports."]
[null,"Data Quality Management Operations and Support","This section evaluates the maturity of the <business unit> Data Governance Data Quality Management Operations and Support capabilities as they relate to best practices in Data Governance.  Data Quality Management Operations and Support, for this context, refers to the actionable capabilities of the <business unit> data governance program to maintain and ensure the completeness, coverage, conformity, consistency, accuracy, non-duplication and timeliness of data across the organization."]
[null,"Data Quality Strategy and Program","This section evaluates the maturity of the <business unit> Data Governance Data Quality Strategy and Program capabilities as they relate to best practices in Data Governance.  The Data Quality Strategy for this context, pertains to the <business unit> data quality plan or method defining the processes and approaches used to ensure the completeness, coverage, conformity, consistency, accuracy, non-duplication and timeliness of data across the organization."]
[null,"Data Security and Privacy","This section evaluates the maturity of the <business unit> Data Governance Data Security and Privacy capabilities as they relate to best practices in Data Governance. Data Security and Privacy, for this context, refers to protective digital privacy measures applied data, to prevent destructive forces and access to computers, databases, and websites from unauthorized users within the <business unit> data governance environment."]
[null,"Data Standard","Data Standards are documented agreements on representations, formats, and definitions of data. These can be external standards or internally from the company."]
[null,"Data Strategy and Roadmap","This section evaluates the maturity of the <business unit> Data Governance Data Strategy and Roadmap capabilities as they relate to best practices in Data Governance.  The Data Strategy concept, for this context, is a standard definition and describes a documented and approved conceptual approach that  defines an ability of a the <business unit> organization to precisely define and effectively retrieve accurate, consistent and transparent data content for both internal applications and processes and external communication.  Eventually the strategy comes to represent a family of strategies, whose implementation can be scheduled via a series of projects, or a Roadmap. "]
[null,"Derived Data","Data that is the result of a computational step applied to reference of event data. Derived data is the result of either of relating two or more elements of a single transaction (such as an aggregation) or of relating one or more elements of a transaction to an external algorithm or rule\n"]
[null,"KDE","Key Data Elements are data elements of highest important to the agency/department"]
[null,"Master Data","Data that describes the people, places, and things that are involved in an organization’s business. It is the information required to create and maintain an enterprise-wide “system of record” for core business entities in order to capture business transactions and measure results for these entities\n"]
[null,"Master Data Management","This section evaluates the maturity of the <business unit> Data Governance Master Data Management capabilities as they relate to best practices in Data Governance. Master Data Management, for this context, comprises the processes, governance, policies, standards and tools that consistently define and manage the critical data, or master data, of the <business unit> organization to provide a single point of reference."]
[null,"Metadata","Metadata literally means “data about data.” Metadata label, describe, or characterize other data and make it easier to retrieve, interpret, or use information.\n\nTechnical metadata are metadata used to describe technology and data structures. Examples of technical metadata are field names, length, type, lineage, and database table layouts.\n\nBusiness metadata describe the nontechnical aspects of data and their usage.\n"]
[null,"MetaData Management","This section evaluates the maturity of the <business unit> Data Governance MetaData Management capabilities as they relate to best practices in Data Governance.  MetaData Management, for this context, is the oversight of data associated with the <business unit> data assets to ensure that information can be integrated, accessed, shared, linked, analyzed and maintained to best effect across an organization."]
[null,"Operational","Assessment of operational readiness (both in IT and the business) to support, manage, and operate cloud services"]
[null,"Program Management and Change Management","This section evaluates the maturity of the <business unit> Data Governance Program Management and Change Management capabilities as they relate to best practices in Data Governance.  Program Management for this context, applies to the <business unit> process of managing several data governance related projects, with the intention of refining and tuning the governance organization's performance.  Change Management, for this context, is the definition and implementation of processes, policies, documentation, and procedures and/or technologies to deal with changes in the governance environment."]
[null,"Reference Data\n","Data that is sets of values or classification schemas that are referred to by systems, applications, data stores, processes, and reports, as well as by transactional and master records. It is the more static, consistent and uniform set of identifiers and extended attributes that describe the core entities of the enterprise.\n"]
[null,"Standardization & Data Governance Organization","This section evaluates the maturity of the <business unit> Data Governance Standardization & Data Governance Organization capabilities as they relate to best practices in Data Governance.  Standardization, for this context, describes the process of implementing and developing technical standards for data governance.  Data standards specifically, are the rules by which data are described and recorded. In order to share, exchange, and understand data, it must be standardized in format as well as meaning.  Standardization in data governance, can help to maximize compatibility, interoperability, safety, repeatability, or quality. It can also facilitate commoditization of formerly custom processes.   The <business unit> Data Governance Organization is being evaluated for the comprehensive ability to support best practice governance activities and processes. "]
[null,"Transactional Data\n","Data that describes an internal or external event or transaction that takes place as an organization conducts its business. This includes any event involving the exchange (or modification) of products, money and/or data.\n"]
[null,"Unstructured Data\n","Data that is any document, file, image, report, form, etc… that has no defined, standard structure that would enable convenient storage in automated processing devices; it cannot be defined in terms of rows and columns or records, and the data cannot be examined with standard access\n"]

{"sheet":"Instructions","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,1,14,14],[0,4,0,20],[2,1,2,15],[4,1,4,15],[6,1,6,14],[8,1,8,14],[10,1,10,14],[12,1,12,14]]}
[null,null,null,null,"Data Management & Data Analytics Assessment Survey Instructions"]
[]
[null,"The survey you are about to take will be used to measure your organization’s Data Management and Analytics readiness against a maturity model.and scan potential opportunities to leverage Data Management and Analytics capabilities. The survey is organized around multiple dimensions  – each includes a set of key attributes which define the practices and competencies in place within your organization today."]
[]
[null,"For each of these attributes, you will also be asked to define where you want your organization to be in the future.  Note that the most important characteristics are highlighted. The survey takes roughly 60 minutes to complete and our consultants are available to review the results with you.  All results are kept anonymous and used only for overall benchmarking purposes. On the Survey Tab for each question, please enter in the digit 1 to 5 that corresponds to your maturity level. "]
[]
[null,"Instructions"]
[]
[null,"KPMG appreciates your time and input in regards to providing data on your organization's Data Management and Analytic Capabilities"]
[]
[null,"If some of the features in this sheet do not work, please ensure that your MACROS ARE ENABLED.  "]
[]
[]
[]
[null,"If you do not have the most current version of excel, the sliders/graphics may not work.  If this is the case, you will need to manually enter the data in the spaces provided on the Survey tab."]

{"sheet":"Framework","index":3,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
[null,null,"Data Management & Data Analytics Assessment Survey Framework"]

{"sheet":"Survey","index":4,"n_rows":113,"n_cols":19,"rows_kept":113,"cut":false,"hidden":false,"merged":[[98,1,98,2],[14,1,14,2],[0,3,0,18],[86,1,86,2],[46,1,46,2],[66,1,66,2],[56,1,56,2],[76,1,76,2],[24,1,24,2],[36,1,36,2],[4,1,4,2]]}
[null,null,null,"Data Management & Data Analytics  Assessment"]
[]
[null,"Maturity Question",null,null,"Level 1",null,"Level 2",null,"Level 3",null,"Level 4",null,"Level 5",null,"Assessed",null,"Goal",null,"Comments"]
[]
[1,"Data Governance and Standardization (4)"]
[]
[1,"Has a data governance structure been established with dedicated resources to oversee the data environment effectively resolve any potential governance issues ?",null,null,"Little or no awareness of need for data governance/ownership.  No clear organization structure is in place. \nAbsence of data ownership at any level of the organization. ",null,"Multiple master data owners, who manage but aren't responsible for critical data objects across agency systems. No coordination within the broader business unit.\n",null,"Top management concerned about data management practices. Defined roles, responsibilities and areas of accountability for all impacted parties within the governance organization exist for maintaining communication and managing activities to govern business rules",null,"A clear agency wide hierarchical data governance model exists, responsibilities are communicated and endorsed by leadership, and processes in place to allow drill down from global level to function level. Central organization is held accountable to data quality standards set out at a strategic level.",null,"Agency wide data governance with data stewards and owners in place to administer the overall governance and activities needed to maintain efficient master data and insights shared across owners. Data governance organization evolves to address extra-organizational (state-wide) needs",null,1,null,{"$f":"O7+1","v":2}]
[null,null,{"$f":"Survey!B13","v":"Is the agency ready to institutionalize structures and processes to comply with data governance charter?"}]
[2,"Are data governance policies, procedures and standards in place and are they complied with? ",null,null,"No formal policies or procedures in place. Data issues resolution is reactive and undertaken by the broader IT group. ",null,"While still reactive, some data governance processes, policies and controls in place. High dependency on knowledge of a few individuals.",null,"Data governance processes & controls are in place. Data policies & standards are documented. Key capabilities in place to monitor & manage data but underutilized.",null,"Data is managed & monitored according to established policies, controls and standard, all with measurables KPIs. Data routines are largely automated and measured. Policies and procedures widely communicated with good uptake. ",null,"Data Governance treated as a core competency across strategy, people, process, technology, and control. Policies adopted across the organization and monitored.",null,1,null,{"$f":"O9+1","v":2}]
[]
[3,"Are there technology tools to assist in the automation of data governance processes?",null,null,"There are no automated tools that are used to support data governance",null,"Standalone and customized tools such as Excel and Access are used to support data governance processes. Tools are not well documented",null,"There is a centralized database with some custom application support within business units and user manuals exist. Limited number of users are trained in the tool set.",null,"A well defined, well documented data governance tool set exists to support managing and monitoring data governance processes. Users are trained in the tool set.",null,"The toolset is continuously updated to incorporate lessons learned and evolving leading practices. Toolset training is mandatory.",null,1,null,{"$f":"O11+1","v":2}]
[]
[4,"Is the agency ready to institutionalize structures and processes to comply with data governance charter?",null,null,"No processes are in place to signal new requirements and change processes to ensure compliance.",null,"Some business units have standardized processes in place but compliance is ad hoc.",null,"Responsibility is assigned to a single unit for incorporation of new legislation and regulatory requirements, and it is making some progress but has not implemented consistent processes.",null,"The organization is pro-actively monitoring potential changes in legislation and regulatory requirements and anticipating the impact on analytics activities",null,"The organization is involved in discussion with its stakeholders, government and regulators to contribute to the discussion on new legislation and regulatory requirements, i.e. a thought leader in the field",null,1,null,{"$f":"O13+1","v":2}]
[]
[2,"Data Strategy and Roadmap (4)"]
[]
[1,"Is data valued as an asset?",null,null,"Leaders sometimes say data is important but it is not a focus of the organization, there is no data strategy and little investment.",null,"The importance of data is known and emphasized by some but not all leaders - as a result there is little coordination and any activity is primarily focused on obtaining data",null,"Almost all leaders recognize data is important and that adequate management enables the organization to gain efficiencies. In general, leaders acknowledge and follow a coordinated data strategy.",null,"Leaders are focused on all aspects of data and it is called out in the business strategy. The importance of the data strategy is commonly shared within the organization. There is an obvious link between the organization and data strategy.",null,"The organization sees the data strategy as an integral part of the organization strategy. Analytics is seen as a crucial instrument to meet the strategic objectives of the organization.",null,1,null,{"$f":"O17+1","v":2}]
[]
[2,"Do you have a dedicated experienced team in place to understand, design, and execute a data strategy and roadmap?",null,null,"Limited basic knowledge and experience of current data, data needs, and gaps, making development of clear goals around the future uses and opportunities of their data and understanding the extent of current data problems difficult. Data regarded as an IT issue.",null,"Isolated pockets of data knowledge, needs, and gaps in the organization. Reactive response to business data needs versus proactive planning and strategy development. \n",null,"Management understands the value of data as a strategic asset. Each team/function has a basic knowledge of current data, data needs, and gaps and its strategic value but experience is limited to a few individuals in the team.",null,"Management has previous experience with the development and delivery of a data strategy. Teams have a solid number of members with data experience or active recruitment to attract these skills.\n\n",null,"Full executive buy-in and strategic use of data to more effectively run the business understood. Data management group operates across the organization. All teams/functions have data champions who work alongside team. ",null,2,null,{"$f":"O19+1","v":3}]
[]
[3,"Are processes in place to develop a data strategy and execute against the strategy?",null,null,"There is no data strategy, or process to develop a data strategy and/or any data-related projects undertaken are decided ad hoc by departmental units. There is limited visibility to what's availabile\n",null,"Data-related project and program decisions and strategy are made within departments with limited collaboration across department units, senior management and/r centralized analytics team.",null,"There is a degree of coordination amongst departmental units as to what data projects are pursued and how they are executed. Short-medium term view currently pursued (1-2 years).  There is a recognized need to understand current data assets and anticipated needs.",null,"The development of the data strategy is coordinated among departments and is reviewed and approved by senior management. Processes, controls, and KPIs  are in place to measure progress against and conformance to the plan.",null,"The strategic plan is continuously revisited and adjusted as necessary to take advantage of lessons learned and leading practices",null,3,null,{"$f":"O21+1","v":4}]
[]
[4,"Is there technology to support the development of the data strategy and roadmap",null,null,"No specialized data management tools nor data inventory, analysis, or auditing tools used to support current state or gap analysis",null,"Customized queries are constructed in specialized tools to understand current data assets. Isolated stores are used to capture data asset inventories.",null,"There is a recognized need to purchase or develop a toolset  to inventory current data assets and identify gaps or a toolset is being piloted by a few users.",null,"A data management toolkit has been developed or purchased and is actively being used to  to inventory current data assets and identify gaps.",null,"The data management toolkit is continously updated and new users are trained to take advantage of updates in technology",null,4,null,{"$f":"O23+1","v":5}]
[]
[3,"Data Architecture (5)"]
[]
[1,"Is there an organization responsible for the data architecture in the organization?",null,null,"There is no organization responsible",null,"The organization is project driven and disbands after each project",null,"An organization has been defined and has taken reponsibility for ownerhsip of the conceptual, logical, and physical data architecture, data architecture standards, and the oversight of the delivery of data systems",null,"The organization is providing oversight on multiple projects and enforcing data architecture standards",null,"As business needs and technologies evolve the organization is adapting to accommodate the changes.",null,1,null,{"$f":"O27+1","v":2}]
[]
[2,"Is there a consistent toolset available and used across the organization?",null,null,"There is no standard toolset - each business unit decides which tools are appropriate and purchases separately, the tools are not consistent and generally outdated, and it is difficult to get access because of a poor purchasing and IT implementation process.",null,"There is no standard toolset but on the whole people are able to get what they need by following their a process. The process may not be codified but it seems to work.",null,"There is an emerging list of standard tools which are used across the organization and a written process. The tools may be incomplete/outdated and the process not always followed but there is at least a level of consistency.",null,"A fixed set of licensed tools available within the organization that is determined centrally and it covers most of the analytic needs of the organization, but the process is not well defined meaning many people go outside of the process.",null,"A fixed set of tools and a process for accessing exists, and there is also scope for requesting new tools which are selected and provided when needed.",null,2,null,{"$f":"O29+1","v":3}]
[]
[3,"Does technology support the business requirements?",null,null,"Disparate systems the require extensive manual intervention to integrate at the data level. Current technologies are inadequate to meet business requirements in one or more functions\n",null,"Disparate systems with automation technologies utilized to provide much data integration with manual intervention for more complex integration needs. Significant gaps exists in required functionality, responsiveness and user experience\n",null,"Disparate and integrated systems with most integration achieved via automation technologies. Adequate for most major requirements, but some gaps exist in functionality, responsiveness and  user experience\n",null,"Adequate for all major business requirements. Some gaps exist for minor requirements Mostly integrated systems with all integration achieved via automation technologies, including analysis and interpretation of integrated information\n",null,"Enterprise operates on a fully integrated system of on premise and cloud solutions with harmonized data architectures that optimizes adaptability, cost, and performance, including integrated service management capabilities. Fully meets or exceeds business requirements for functionality,  responsiveness and user experience",null,3,null,{"$f":"O31+1","v":4}]
[]
[4,"Is the organization able to modify and scale computing resources/functionality as requirements evolve?",null,null,"The available computing resources are not easily scalable, nor modifiable.  The platform has a static set up, and the organization lacks the resources and expertise to make modifications/upscale computer resources",null,"The available computing resources are modifiable and scalable to a small extent (e.g. at the department level, but not the full organization).  Limited budget and expertise is available to modify and scale computing resources beyond a single unit.",null,"The available computing resources are modifiable and scalable across the organization, but acquisition and implementation have a long lead time due to lack of budget, expertise and other resources.  Modification and scaling of resources is the responsibility of a single unit",null,"The available computing resources are modifiable and scalable across the organization.  Budgets and expertise are available.  Responsibility for modifications and scaling of computer resources is shared between business and analytic units.",null,"The available computing resources are easily modifiable and scalable through enterprise level cooperation; There are specified resources available for this purpose",null,4,null,{"$f":"O33+1","v":5}]
[]
[5,"Is the data architecture based on industry or government standards?",null,null,"It is not based on any standard",null,"It is based on our internal standards and where necessary for interfaces uses 3rd party standards",null,"There is a plan to adopt an accepted standard",null,"A leading industry or government standard has been adopted and is the eventual target model for the data architecture",null,"A leading industry or government standard has been adopted and the current data architecture completely complies with the standard. The architecture is design to adopt to emerging changes in the standard",null,4,null,{"$f":"O35+1","v":5}]
[]
[4,"Master Data Management (MDM) (4)"]
[]
[1,"Have Master Data entiities been defined and characterized?",null,null,"Master data elements have not been defined nor attributes defined. ",null,"Multiple copies of the same master data elements exist and there are multiple potential sources of master data. Master data redundancies are managed on a per project basis \n",null,"Master data and attributes have been defined for 1 major entity.  Business rules have been defined on which sources to use and under what conditions to \"master\" the data\n",null,"There is a physical or logical master data golden record for all major MDM entities. Publish and suscribe rules exist and are being used for all master data entities",null,"Master data has been defined with attributes that may vary to accommondate integration with external agencies.\n",null,4,null,{"$f":"O39+1","v":5}]
[]
[2,"Is there an ownership structure in place for MDM?",null,null,"Absence of master data ownership at any level of the organization. Little/no awareness of need for master data ownership\n",null,"MDM is adopted by a number of units/individual project teams but no coordination within the broader business unit.\n",null,"MDM concentrated and coordinated within business units. Top management involved in approving MDM policies\n",null,"A clear organization wide hierarchical or hybrid MDM model exists,  responsibilities are communicated and endorsed by leadership, and processes in place to allow drill down from global level to function level.",null,"MDM organization adopts to change as business needs evolve or overall organizational structure changes. MDM organization evolves to support inter organizational(statewide) needs.",null,4,null,{"$f":"O41+1","v":5}]
[]
[3,"Are master data management specific processes in place?",null,null,"No MDM processes or minimal management processes in place",null,"Focused on retroactively fixing master data issues as they occur. No view of master data across programs or projects. No view of sharing master data across projects and programs\n",null,"Recognize the need for master data management across projects and programs. Have developed master data strategy or policy for 1 project. Have implemented master data management for one program.",null,"Master data management processes have been established across projects and programs. Have implemented master data management processes across mulltiple programs.",null,"MDM processes continuously evolve based on new master data needs. MDM processes accommodate inter-organizational needs",null,4,null,{"$f":"O43+1","v":5}]
[]
[4,"Are there tools in place to support MDM processes?",null,null,"No specialized MDM tools. Master data duplicated across organization in mulitple locations",null,"Data modeling or database tools used to support master data per project. No ability for tool to master Golden Record",null,"Recognized need for MDM tool to share/manage master data across projects and programs. Piloting of MDM tool for one project or program.\nata management technology providers seen as strategic partners",null,"MDM tools integrated into the Enterprise architecture and used to create, maintain, and publish logical or physical golden record",null,"Enterprise master data management tools standardized and widely used. Additional master data entities incorporated as business needs evolve. Tools use to support integration with external agencies.",null,4,null,{"$f":"O45+1","v":5}]
[]
[5,"MetaData Management (4)"]
[]
[1,"Is there a management structure in place for metadata",null,null,"Absence of  metadata ownership at any level of the organization. Little/no awareness of need for metadata ownership\n",null,"All Metadata definitions allocated to IT. IT chasing the business for metadata business definitions\n",null,"Business Metadata management is allocated to the businesses and technical metadata to IT. No coordination between the various types of metadata.\n",null,"A clear organization wide hierarchical or hybrid Metadata model exists,  responsibilities are communicated and endorsed by leadership, and processes in place to allow to share metadata.",null,"Metadata organization adopts to change as business needs evolve or overall organizational structure changes. Metadata organization evolves to support inter organizational (statewide) needs.",null,3,null,{"$f":"O49+1","v":4}]
[]
[2,"Are metadata management specific processes in place?",null,null,"No metadata processes or minimal management processes in place",null,"Focused on retroactively fixing metadata issues as they occur. No view of metadata across programs or projects. No view of sharing metadata across projects and programs. No ability to track data lineage from source to target\n",null,"Recognize the need for metadata management across projects and programs. Have developed metadata strategy or policy for 1 project. Have implemented metadata management for one program. ",null,"Metadata management processes have been established across projects and programs. Have implemented metadata management processes across mulltiple programs. Demonstrated ability to track data lineage.",null,"Metadata processes continuously evolve based on new metadata needs. Metadata processes accommodate inter-organizational needs",null,3,null,{"$f":"O51+1","v":4}]
[]
[3,"Are metadata management tools in place to support the Metadata processes?",null,null,"No specialized metadata tools in place",null,"Data modeling or database tools used to support metadata per project. No ability for tool to maintain golden record",null,"Recognized need for Metadata tool to share/manage metadata across projects and programs. Piloting of Metadata tool for one project or program. Data management technology providers seen as strategic partners",null,"Metadata tools integrated into the Enterprise architecture and used to create, maintain, and publish logical or physical golden record",null,"Enterprise metadata management tools standardized and widely used. Additional metadata entities incorporated as business needs evolve. Tools use to support integration with external agencies.",null,3,null,{"$f":"O53+1","v":4}]
[]
[4,"Have metadata types and attributes  been defined and characterized?",null,null,"Metadata attributes and types have not been defined.",null,"Technical metadata has been defined and characterized and are being managed",null,"Business and technical metadata have been defined and are integrated",null,"Business, technical, operational, and security metadata have been defined and are integrated",null,"Other metadata (such as usage) have been defined with attributes that may vary to accommodate integration with external agencies or to accomodate evolving business needs. The metadata model accomodates this expansion. Overall data quality is extremely high",null,3,null,{"$f":"O55+1","v":4}]
[]
[6,"Data Quality (4)"]
[]
[1,"Has a data quality strategy been formulated? Are there processes in place for understanding current data quality and fixing issues?",null,null,"No formal data quality processes in place. No data quality strategic plan.",null,"No standardadized data quality processes in place. Issues are addressed as they are identified by users",null,"There is a recognized need for standardized data quality processes. A data quality strategy is formulated and data quality targets are defined",null,"Standardized data quality  processes are in place and executed for measuring, monitoring and reporting data quality performance against data quality targets.",null,"Data quality processes are continuously refined to incorporate lessons learned and new leading practices",null,2,null,{"$f":"O59+1","v":3}]
[]
[2,"Are there processes in place for managing data and data quality  throughout all the layers of the architecture?",null,null,"There are no processes in place",null,"There are processes that are put place on a project basis and/or there are limited architecture components put in place.",null,"There are well defined processes for managing data and data quality throughout the architecture but they have not be widely deployed",null,"There are well defined processes for managing data and data quality throughout the architecture and they have been deployed and tested on multiple projects",null,"Processes are updated to take advantage of lessons learned and industry leading practices in data architecture",null,2,null,{"$f":"O61+1","v":3}]
[]
[3,"Are there technologies in place to measure, monitor, and report data quality",null,null,"There are no data quality specific tools nor recognized need for them.",null,"Ad hoc queries and tools are used to understand data quality issues as they are identified by users",null,"There is a recognized need for standardized data quality tools and technologies. There is a plan to purchase or develop a toolset or a toolset is being piloted by a few users.",null,"Standardized data quality  and data profiling toolkits  are in place and executed for measuring, monitoring and reporting data quality performance against data quality targets. Data quality controls are implemented in the data architecture.",null,"Results of monitoring and reporting are used to continuosly improve data quality and refine embedded quality controls",null,2,null,{"$f":"O63+1","v":3}]
[]
[4,"Have critical or key data elements (KDEs) been defined?\n",null,null,"KDEs have not been defined nor is there a recognized need to define them.",null,"KDEs are limited to the project under development",null,"There is a recognized need to define KDEs and are being defined on a limited basis",null,"KDEs have been defined and are acttively managed for data quality",null,"The list of KDE's continuouly grows as each set reaches its data quality targets",null,2,null,{"$f":"O65+1","v":3}]
[]
[7,"Data Management Methodology (4)"]
[]
[1,"Is there an organizational structure responsible for the methodology to be used for data related projects",null,null,"There is no organization responsible for the methodology",null,"The methodology is  managed on a per project basis",null,"An ogranizational structure has been defined and will be piloted for the next project",null,"An organizational structure is in place and has taken owenership of the methodology. A formal methodology training program is in placec",null,"An enterprise-wide organization is in place and adopts to meet business needs.",null,1,null,{"$f":"O69+1","v":2}]
[]
[2,"Is there a data project specific methodology in place that covers the life-cycle of data projects",null,null,"There is no data program specific methodology",null,"A methodology is selected on a per project basis",null,"A standard methodology has been defined with associated templates but has not been widely rolled out. ",null,"A standard methodology has been rolled out and deployed on multiple projects",null,"The methodology is continuously refined to take advantage of lessons learned and leading practices in data management projects",null,2,null,{"$f":"O71+1","v":3}]
[]
[3,"Are there technology tools in place to monitor/measure adherence to the methodology",null,null,"There are no technology tools in place",null,"Custom tools and templates are developed on a per project basis",null,"Standard tools, checklists, and reports have been defined and piloted on 1 project",null,"Standard tools, checklists, and reports have been widely deployed across the organization",null,"IT, working with the business, updates the tools, templates, and reports based on lessons learned and leading practices",null,3,null,{"$f":"O73+1","v":4}]
[]
[4,"Are there metrics in place to monitor/measure adherence to the methodology",null,null,"There are no metrics in place",null,"There are a few metrics in place but are developed on a per project basis",null,"Standard metrics have been defined but not widely deployed",null,"Standard metrics have been deployed and are being monitored and reported",null,"Metrics are used to update/improve the methdology and supporting tools",null,4,null,{"$f":"O75+1","v":5}]
[]
[8,"Program Management and Change Control (4)"]
[]
[1,"Do you have a management structure in place to oversee projects and manage change?",null,null,"No identification or delegation of defined roles and responsibilities\n",null,"Project leader identified at project start. Manages project with loosely defined project support team",null,"PMO established for larger projects. Roles and responsibilities clearly defined. Individuals identified and roles communicated at project start. Change management acknowledged as an integral part (individual workstream) of project success\n",null,"PMO established for all projects in the organization. Roles and responsibilities clearly defined. Individuals identified and roles communicated at project start. Change management lead identified to manage and monitor change activities and success\n",null,"Enterprise-wide project management office in place to support individual project leaders with project execution. Departments/teams identify change champions to lead change activities in individual teams",null,1,null,{"$f":"O79+1","v":2}]
[]
[2,"Do you have project management processes in place to guide project execution and control changes?",null,null,"No formal project management practices exist in the organizations. Budget, scope and time issues frequently encountered. \n",null,"Establishment of basic project management processes on an individual project basis. Budget, scope and timing issues less frequently encountered. Some PM skills within the team.\n",null,"Standardized project management processes in place. Coordination across 2-3 projects management teams. Budget, scope and timing performance shows improvement. Change management process defined on project basis.\n",null,"Well defined and communicated project management processes with clear metrics. Greater coordination and knowledge sharing among PMO groups. Minor budget, scope and timing issues encountered. Change management process consistent across all projects and programs.\n",null,"Standardized processes become routine and are strictly adhered to. Budget, scope and timing issues rarely encountered. Knowledge sharing across teams/functions allows for continuous improvements to be made and processes to be refined",null,2,null,{"$f":"O81+1","v":3}]
[]
[3,"Do you have the tools available to support successful project and change management?",null,null,"No formal management tools are available\n",null,"Limited number of project management tools adopted on an ad-hoc basis by individuals \n",null,"Range of project management tools made available and utilised to varying degrees by business units\n",null,"Enterprise wide project management tool(s) available with limited uptake across the organization\n",null,"Enterprise wide project management tool(s) deployed and widely adopted",null,3,null,{"$f":"O83+1","v":4}]
[]
[4,"Are metrics in place to measure and track project progress?",null,null,"No awareness of need to measure and track project progress.\n",null,"Awareness of need to track project progress at a high level e.g. financial - actuals against budget. Limited number of high level metrics in place for a small number of larger projects. Reported on retrospectively at project end.\n",null,"Awareness of need for project tracking at a detailed level. A comprehensive set of metrics clearly defined and communicated across all projects in the organization. Reported on at an individual project level on an ad-hoc basis. \n",null,"Commitment to reporting on comprehensive set of organization wide metrics at regular intervals at a project level.\n",null,"Reporting considered a workstream within the broader project. Reporting against metrics at pre-defined regular intervals and communicated at both a project level and function/enterprise wide level. Metrics used to support lessons learned session and encourage process improvement.",null,4,null,{"$f":"O85+1","v":5}]
[]
[9,"Data Security and Privacy (5)"]
[]
[1,"Do you have a data security team in place?",null,null,"No data security team in place. Limited knowledge of security requirements, processes and controls required. \n",null,"Data security team formed and sponsored by management. Basic roles and responsibilities defined. Simple policies are available but not necessarily enforced and monitored. Little documentation available.\n",null,"Data security team with strong skills in place. Governance structure and roles and responsibilities clearly defined and communicated. Documentation of policies and processes is available but not strictly adhered to. \n",null,"Strong, structured and trained/certified security team in place with strong governance framework. Detailed documentation is widely available. Performance metrics identified.\n",null,"Strong, structured and trained/certified security team in place with strong governance framework. Performance metrics tracked and optimized. ",null,1,null,{"$f":"O89+1","v":2}]
[]
[2,"How is access to data provided?",null,null,"There are no mechanisms in place for getting access to data, it is generally available.",null,"Individuals request the data from data owners who decide whether it should be released.",null,"Access is based on centrally administered data access control mechanisms.",null,"Access is assessed by a central group and administered by data owners.",null,"Access is managed centrally and requests are processed relating to internal and external data access requests.",null,2,null,{"$f":"O91+1","v":3}]
[]
[3,"To what extent does the organization have a framework that sets and specifies the rules and principles for the use of sensitive data?",null,null,"There is not a specific framework governing the rules and principles for the access, use, storage and processing of sensitive data.\n",null,"Loose framework in place for safe and controlled access, secure storage and processing of sensitive data. Compliance is the responsibility of individual employees or projects\n",null,"Strong evolving framework in place with a comprehensive list of access, storage and processing principles  A group in place to oversee compliance but the process is manual and not broadly followed. Data classification guidelines in place\n",null,"Strong framework in place that is well communicated and broadly adhered to. Strong data security controls in place. Secuirty audits and tests are conducted to monitor compliance.\n",null,"Framework, technical measures and an automated system are in place to maintain and monitor compliance with the framework of all employees. Framework routinely revisited and refreshed as  business/regulatory needs emerge. ",null,3,null,{"$f":"O93+1","v":4}]
[]
[4,"Is sensitive data classified and access roles clearly defined?",null,null,"Sensitive data is not classified and no access roles defined. ",null,"Awareness of need to classify sensitive data and define access roles. Efforts potentially underway across 2 projects.",null,"Classification of sensitive data in progress across organization. Access roles being shaped, defined and communicated to the organization. \n",null,"Classification of sensitive data and definition of access roles complete across the organization",null,"Sensitive data classification and defintion of access roles broadened to include external agencies. Proactive approach to reviewing and updating sensitive data classfication. ",null,4,null,{"$f":"O95+1","v":5}]
[]
[5,"Are there technology enabled security controls and monitors in place?",null,null,"There are no technology controls or monitoring processes in place",null,"Security controls and monitors are instantiated after a data breach occurs",null,"Technology controils have been defined and piloted on a few projects. Data classification tool needs defined and piloted.",null,"Technology controls and monitors processes instantiated in every part of the data architecture. Data classification tool used to assist in classifying data.",null,"Data security controls and monitoring processes are standard on every project. Controls are actively tested prior to every project going live. Lessons learned and leading practices are incorporated back into the technical controls.",null,5,null,5]
[]
[10,"Data Analytics (D&A) (7)"]
[]
[1,"Is there executive sponsorship and commitment to working with analytics and acting on analytics insights?",null,null,"Leaders around the firm have limited belief or experience in working with analytics.",null,"Some leaders around the organization have experience in working with analytics and are beginning to champion initiatives and take action based on analytics insights.",null,"Most leaders in the organization have experienced working with analytics and are coming together to share insights and build strong analytics capabilities.",null,"The C-Level and all leaders are very comfortable working with analytics and are demanding that action be driven by data and analytics insights.",null,"The C-Level and all leaders are comfortable with data and analytics leading decisions in real-time across the business, and analytics is used to inform every decision around the business.",null,1,null,{"$f":"O101+1","v":2}]
[]
[2,"Are processes in place to develop and execute an analytics strategy and roadmap?",null,null,"Analytics initiatives are selected and executed on an ad hoc basis by mid-level management\n",null,"Analytics initiatives are selected and executed by department heads\n",null,"There is an individual empowered to  select and facilitate the execution of analytics initiatives, but that person is not able to effectively influence the department heads to work together towards common goals.\n",null,"There is centralized team empowered to select and facilitate the execution of analytics initiatives, and that person operates effectively at the department head level and, possibly by convening a committee, is able to effectively influence the department heads to work together to common goals.\n",null,"There is a centralized team empowered to develop analytics initiatives and they have access to or a member of the C-level of the organization. They effectively communicate the effectiveness of the initiatives across the organization (and potentially external organizations) and are able to influence and make changes throughout the year to adjust course and improve effectiveness of execution.",null,2,null,{"$f":"O103+1","v":3}]
[]
[3,"How well does the organization enable data analytics with the right support processes on budget, people, data and technology?",null,null,"There are no support processes in place for budget, people, data and technology",null,"Some processes are in place but they are ad hoc and reliant on individual leaders to execute. Minimal buget available, little investment in tools and resources. ",null,"Each business unit has processes in place to support analytics initiatives with budget, people, data and technology. Business units are beginning to share initiatives and coordinate activity.",null,"Consistent processes are in place to coordinate activity across the entire organization.",null,"A structure is in place to properly divide responsibilities in supporting analytics initiatives across the entire organization, including a central advanced analytics unit responsible for pushing the boundaries, experimentation and providing advanced outcomes to business units.",null,3,null,{"$f":"O105+1","v":4}]
[]
[4,"What level of analytics and skills are currently present in the organization?",null,null,"Most of our resources work on projects which report on standard business metrics (descriptive analytics). This is achieved through manual and unsystematic approach. There are no analytics resources available ore required as reporting is the primary purpose for current data.",null,"There are a limited number of resources work on analytics initiatives which go beyond standard business intelligence and ask questions around why things happened are beginning to be executed (descriptive and diagnostic analytics).",null,"A large number of resources are equipped to work on analytics initiatives which ask both what happened and why it happened. Limited number of resources available to answer what will happen and make proactive forecasts (descriptive, diagnostics and predictive analytics). Resources levels are adequate for current initiatives and organization requirements but may not be entirely effective due to other issues such as disorganized data, lack of coordination or technology, etc.",null,"Many resources able to work across the spectrum of descriptive, diagnostic and predictive analytics. Advanced data science projects are emerging and the adoption of complex modelling methods. There are sufficient resources available to execute current analytics priorities or active recruitment efforts in place to onboard these skills.\n",null,"Our resources work on a broad range of analytics initiatives which ask what happened (descriptive), why it happened (diagnostic), what will happen (predictive), and what can I do to influence a certain outcome (prescriptive) are used across the organization. There are sufficient resources executing this role and opening up new analytics opportunities which were not available previously.",null,4,null,{"$f":"O107+1","v":5}]
[]
[5,"What data sources are available with which analytics can be executed and is the data available sufficient to accommodate planned analytics requirements?",null,null,"The organization has a very limited set of internal data which is stored largely on paper and/or  spreadsheets. Additional data elements required. The data will need to be completely restructured and there are multiple gaps in the data.",null,"The organization only uses a limited set of internal data which is stored in multiple separate source systems as well as spreadsheets. The data will need to be restructured and data gaps filled as needed",null,"The organization only uses internal data but it is beginning to share data between business units. There is a well defined data strategy for structuring and completing the data collection to accomodate the analytics requirements",null,"The organization has a mechanism for sharing data and providing a single view across systems. There few, if any, data gaps and it has been structured to accomodate multiple analytics projects",null,"The organization uses internal and external data commonly with minmal complexity and accuracy problems. The data has been collected and structured to accomodate current and future data analytics project needs",null,5,null,5]
[]
[6,"What tools are available for analytics?",null,null,"There are no specific analytics tools available. Each business unit works with the current tools provided across the organization. Basic usage of Microsoft suite e.g. Access, Excel for simple reporting.\n",null,"There are a limited number of analytics tools available within and utilized by pockets of the organization. There is not a comprehensive toolset covering all key analytics processes required e.g. ETL, data cleansing, statistical software, front-end visualization.   \nAdvanced usage of Microsoft suite to perform analytics requirements ",null,"Data warehouse implemented and a range of Business Intelligence tools available in the organization but they are not centrally administered, use is very ad-hoc and may be incomplete/outdated.limited ",null,"Centrally managed range of task-specific technologies (e.g. data warehousing, data transformation, visualization) to fulfil analytics requirements e.g. SQL, Alteryx, Qlikview. Ad-hoc usage of basic statistical tools e.g. SPSS. Tools cover the majority of analytics processes, yet are unlikely to answer the emerging analytics needs of the organization \n",null,"Adoption of a standard set of tools, including more advanced analytics technology (e.g. SAS, Redshift, Hadoop, D3). Toolset is determined centrally, architecture and governance in place to support access requests for existing and emerging technologies.",null,3,null,{"$f":"O111+1","v":4}]
[]
[7,"How forward thinking is your organization in terms of the opportunities analytics presents?",null,null,"The organization has little or no awareness of analytics opportunities for their businesses and little experience in effectively adopting analytics.",null,"The organization has some understanding of analytics opportunities for their businesses and is beginning to adopt some analytics as part of its operating model, but doesn't have a comprehensive understanding of all  opportunities and is still learning how to incorporate analytics into its processes. Integration is inconsistent and dependent on project managers.",null,"The organization is aware of the opportunities of analytics for their businesses and is willing to adopt proven analytics solutions. There are a range of development techniques (eg. agile, rapid prototyping) considered as the organization standard. ",null,"The organization is sharing opportunities between business units, has a process for refining and generating new ideas, and is experienced at adopting the insights from analytics into its core processes. Agile is the committed strategy of the firm and in the process of total organization adoption",null,"The organization has a complete list of available opportunities, is sharing opportunities and insights internally and externally, while leveraging external collaborators for leading best practices. And is consistently reviewing and updating its operating model in light of new advances. ",null,4,null,{"$f":"O113+1","v":5}]

{"sheet":"Scoring Detail","index":5,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,2,3,2],[0,4,0,17],[2,7,2,10]]}
[]
[]
[null,"Capability","Maturity Question",null,"Assessed","Target",null,"Dimension"]
[null,null,null,null,null,null,null,"People","Process","Technology","Data"]
[1,{"$f":"Survey!B5","v":"Data Governance and Standardization (4)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C5,0)","v":"Has a data governance structure been established with dedicated resources to oversee the data environment effectively resolve any potential governance issues ?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C5,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C5,16)","v":2},null,{"$f":"MATCH(B5,Survey!$B$5:$B$200,0)+2*C5","v":3}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C6,0)","v":"Are data governance policies, procedures and standards in place and are they complied with? "},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C6,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C6,16)","v":2}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C7,0)","v":"Are there technology tools to assist in the automation of data governance processes?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C7,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C7,16)","v":2}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C8,0)","v":"Is the agency ready to institutionalize structures and processes to comply with data governance charter?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C8,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$5,Survey!$B$5:$B$200,0)+2*C8,16)","v":2}]
[2,{"$f":"Survey!B15","v":"Data Strategy and Roadmap (4)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C9,0)","v":"Is data valued as an asset?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C9,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C9,16)","v":2}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C10,0)","v":"Do you have a dedicated experienced team in place to understand, design, and execute a data strategy and roadmap?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C10,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C10,16)","v":3}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C11,0)","v":"Are processes in place to develop a data strategy and execute against the strategy?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C11,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C11,16)","v":4}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C12,0)","v":"Is there technology to support the development of the data strategy and roadmap"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C12,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$9,Survey!$B$5:$B$200,0)+2*C12,16)","v":5}]
[3,{"$f":"Survey!B25","v":"Data Architecture (5)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C13,0)","v":"Is there an organization responsible for the data architecture in the organization?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C13,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C13,16)","v":2}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C14,0)","v":"Is there a consistent toolset available and used across the organization?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C14,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C14,16)","v":3}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C15,0)","v":"Does technology support the business requirements?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C15,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C15,16)","v":4}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C16,0)","v":"Is the organization able to modify and scale computing resources/functionality as requirements evolve?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C16,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C16,16)","v":5}]
[null,null,5,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C17,0)","v":"Is the data architecture based on industry or government standards?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C17,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$13,Survey!$B$5:$B$200,0)+2*C17,16)","v":5}]
[4,{"$f":"Survey!B37","v":"Master Data Management (MDM) (4)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C18,0)","v":"Have Master Data entiities been defined and characterized?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C18,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C18,16)","v":5}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C19,0)","v":"Is there an ownership structure in place for MDM?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C19,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C19,16)","v":5}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C20,0)","v":"Are master data management specific processes in place?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C20,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C20,16)","v":5}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C21,0)","v":"Are there tools in place to support MDM processes?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C21,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$18,Survey!$B$5:$B$200,0)+2*C21,16)","v":5}]
[5,{"$f":"Survey!B47","v":"MetaData Management (4)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C22,0)","v":"Is there a management structure in place for metadata"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C22,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C22,16)","v":4}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C23,0)","v":"Are metadata management specific processes in place?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C23,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C23,16)","v":4}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C24,0)","v":"Are metadata management tools in place to support the Metadata processes?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C24,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C24,16)","v":4}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C25,0)","v":"Have metadata types and attributes  been defined and characterized?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C25,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$22,Survey!$B$5:$B$200,0)+2*C25,16)","v":4}]
[6,{"$f":"Survey!B57","v":"Data Quality (4)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C26,0)","v":"Has a data quality strategy been formulated? Are there processes in place for understanding current data quality and fixing issues?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C26,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C26,16)","v":3}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C27,0)","v":"Are there processes in place for managing data and data quality  throughout all the layers of the architecture?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C27,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C27,16)","v":3}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C28,0)","v":"Are there technologies in place to measure, monitor, and report data quality"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C28,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C28,16)","v":3}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C29,0)","v":"Have critical or key data elements (KDEs) been defined?\n"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C29,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$26,Survey!$B$5:$B$200,0)+2*C29,16)","v":3}]
[7,{"$f":"Survey!B67","v":"Data Management Methodology (4)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C30,0)","v":"Is there an organizational structure responsible for the methodology to be used for data related projects"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C30,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C30,16)","v":2}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C31,0)","v":"Is there a data project specific methodology in place that covers the life-cycle of data projects"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C31,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C31,16)","v":3}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C32,0)","v":"Are there technology tools in place to monitor/measure adherence to the methodology"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C32,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C32,16)","v":4}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C33,0)","v":"Are there metrics in place to monitor/measure adherence to the methodology"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C33,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$30,Survey!$B$5:$B$200,0)+2*C33,16)","v":5}]
[8,{"$f":"Survey!B77","v":"Program Management and Change Control (4)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C34,0)","v":"Do you have a management structure in place to oversee projects and manage change?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C34,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C34,16)","v":2}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C35,0)","v":"Do you have project management processes in place to guide project execution and control changes?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C35,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C35,16)","v":3}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C36,0)","v":"Do you have the tools available to support successful project and change management?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C36,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C36,16)","v":4}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C37,0)","v":"Are metrics in place to measure and track project progress?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C37,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$34,Survey!$B$5:$B$200,0)+2*C37,16)","v":5}]
[9,{"$f":"Survey!B87","v":"Data Security and Privacy (5)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C38,0)","v":"Do you have a data security team in place?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C38,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C38,16)","v":2}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C39,0)","v":"How is access to data provided?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C39,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C39,16)","v":3}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C40,0)","v":"To what extent does the organization have a framework that sets and specifies the rules and principles for the use of sensitive data?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C40,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C40,16)","v":4}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C41,0)","v":"Is sensitive data classified and access roles clearly defined?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C41,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C41,16)","v":5}]
[null,null,5,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C42,0)","v":"Are there technology enabled security controls and monitors in place?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C42,14)","v":5},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$38,Survey!$B$5:$B$200,0)+2*C42,16)","v":5}]
[10,{"$f":"Survey!B99","v":"Data Analytics (D&A) (7)"},1,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C43,0)","v":"Is there executive sponsorship and commitment to working with analytics and acting on analytics insights?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C43,14)","v":1},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C43,16)","v":2}]
[null,null,2,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C44,0)","v":"Are processes in place to develop and execute an analytics strategy and roadmap?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C44,14)","v":2},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C44,16)","v":3}]
[null,null,3,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C45,0)","v":"How well does the organization enable data analytics with the right support processes on budget, people, data and technology?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C45,14)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C45,16)","v":4}]
[null,null,4,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C46,0)","v":"What level of analytics and skills are currently present in the organization?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C46,14)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C46,16)","v":5}]
[null,null,5,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C47,0)","v":"What data sources are available with which analytics can be executed and is the data available sufficient to accommodate planned analytics requirements?"},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C47,14)","v":5},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C47,16)","v":5}]
[null,null,6,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C48,0)","v":"What tools are available for analytics?"},{"$f":"VLOOKUP(D48,Survey!$B$5:$Q$119,14,FALSE)","v":3},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C48,16)","v":4}]
[null,null,7,{"$f":"INDEX(Survey!$B$5:$B$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C49,0)","v":"How forward thinking is your organization in terms of the opportunities analytics presents?"},{"$f":"VLOOKUP(D49,Survey!$B$5:$Q$119,14,FALSE)","v":4},{"$f":"INDEX(Survey!$B$5:$R$200,MATCH(B$43,Survey!$B$5:$B$200,0)+2*C49,16)","v":5}]

{"sheet":"Scoring Summary","index":6,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Data Management & Data Analytics Assessment Survey Scorecard"]
[]
[null,"Capability Category","Assess","Target"]
[1,{"$f":"TRIM(LEFT(I4,LEN(I4)-3))","v":"Data Governance and Standardization"},{"$f":"getScoreAssess(A4)","v":1},{"$f":"getTargetAssess(A4)","v":2},null,null,null,null,{"$f":"VLOOKUP(A4,'Scoring Detail'!$A$1:$B$49,2,FALSE)","v":"Data Governance and Standardization (4)"}]
[2,{"$f":"TRIM(LEFT(I5,LEN(I5)-3))","v":"Data Strategy and Roadmap"},{"$f":"getScoreAssess(A5)","v":2.5},{"$f":"getTargetAssess(A5)","v":3.5},null,null,null,null,{"$f":"VLOOKUP(A5,'Scoring Detail'!$A$5:$B$49,2,FALSE)","v":"Data Strategy and Roadmap (4)"}]
[3,"Data Architecture",{"$f":"getScoreAssess(A6)","v":2.8},{"$f":"getTargetAssess(A6)","v":3.8},null,null,null,null,{"$f":"VLOOKUP(A6,'Scoring Detail'!$A$5:$B$49,2,FALSE)","v":"Data Architecture (5)"}]
[4,"Master Data Management (MDM)",4,5,null,null,null,null,{"$f":"VLOOKUP(A7,'Scoring Detail'!$A$5:$B$49,2,FALSE)","v":"Master Data Management (MDM) (4)"}]
[5,"MetaData Management",3,4,null,null,null,null,{"$f":"VLOOKUP(A8,'Scoring Detail'!$A$5:$B$49,2,FALSE)","v":"MetaData Management (4)"}]
[6,"Data Quality",2,3,null,null,null,null,{"$f":"VLOOKUP(A9,'Scoring Detail'!$A$5:$B$49,2,FALSE)","v":"Data Quality (4)"}]
[7,"Data Management Methodology",2.5,3.5,null,null,null,null,{"$f":"VLOOKUP(A10,'Scoring Detail'!$A$5:$B$49,2,FALSE)","v":"Data Management Methodology (4)"}]
[8,"Program Management and Change Control",2.5,3.5,null,null,null,null,{"$f":"VLOOKUP(A11,'Scoring Detail'!$A$5:$B$49,2,FALSE)","v":"Program Management and Change Control (4)"}]
[9,"Data Security and Privacy",3,3.8,null,null,null,null,{"$f":"VLOOKUP(A12,'Scoring Detail'!$A$5:$B$49,2,FALSE)","v":"Data Security and Privacy (5)"}]
[10,"Data Analytics (D&A)",3.1428571428571428,4,null,null,null,null,{"$f":"VLOOKUP(A13,'Scoring Detail'!$A$5:$B$49,2,FALSE)","v":"Data Analytics (D&A) (7)"}]

{"sheet":"SlidebarMetrics","index":7,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Average Overall  Score"]
[null,{"$f":"ROUND(SUMPRODUCT(B4:B12,D4:D12)/SUM(D3:D12),1)","v":2.6},{"$f":"ROUND(SUMPRODUCT(C4:C12,D4:D12)/SUM(D3:D12),1)","v":3.6}]
["graphNum","rawAssScore","rawTrgScore","weight","Capability Category","Category Score"]
[1,{"$f":"'Scoring Summary'!C4","v":1},{"$f":"'Scoring Summary'!D4","v":2},1,{"$f":"'Scoring Summary'!B4","v":"Data Governance and Standardization"}]
[{"$f":"A4+1","v":2},{"$f":"'Scoring Summary'!C5","v":2.5},{"$f":"'Scoring Summary'!D5","v":3.5},1,{"$f":"'Scoring Summary'!B5","v":"Data Strategy and Roadmap"}]
[{"$f":"A5+1","v":3},{"$f":"'Scoring Summary'!C6","v":2.8},{"$f":"'Scoring Summary'!D6","v":3.8},1,{"$f":"'Scoring Summary'!B6","v":"Data Architecture"}]
[4,{"$f":"'Scoring Summary'!C7","v":4},{"$f":"'Scoring Summary'!D7","v":5},1,{"$f":"'Scoring Summary'!B7","v":"Master Data Management (MDM)"}]
[5,{"$f":"'Scoring Summary'!C8","v":3},{"$f":"'Scoring Summary'!D8","v":4},1,{"$f":"'Scoring Summary'!B8","v":"MetaData Management"}]
[6,{"$f":"'Scoring Summary'!C9","v":2},{"$f":"'Scoring Summary'!D9","v":3},1,{"$f":"'Scoring Summary'!B9","v":"Data Quality"}]
[7,{"$f":"'Scoring Summary'!C10","v":2.5},{"$f":"'Scoring Summary'!D10","v":3.5},1,{"$f":"'Scoring Summary'!B10","v":"Data Management Methodology"}]
[8,{"$f":"'Scoring Summary'!C11","v":2.5},{"$f":"'Scoring Summary'!D11","v":3.5},1,{"$f":"'Scoring Summary'!B11","v":"Program Management and Change Control"}]
[9,{"$f":"'Scoring Summary'!C12","v":3},{"$f":"'Scoring Summary'!D12","v":3.8},1,{"$f":"'Scoring Summary'!B12","v":"Data Security and Privacy"}]
[10,{"$f":"'Scoring Summary'!C13","v":3.1428571428571428},{"$f":"'Scoring Summary'!D13","v":4},1,{"$f":"'Scoring Summary'!B13","v":"Data Analytics (D&A)"}]

{"sheet":"Set Parameters","index":8,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Set Parameters"]
[]
["SourceGraph"]
[]
[]
[null,null,null,"Low","High"]
["TargetSheet","SlidebarMetrics",null,{"$f":"ROUND(E7-0.8,1)","v":1},{"$f":"D8-0.001","v":1.7990000000000002}]
["NumberSlideGraphs",10,null,{"$f":"ROUND(E8-0.8,1)","v":1.8},{"$f":"D9-0.001","v":2.5990000000000002}]
[null,null,null,2.6,3.399]
["StartGraph","F4",null,3.4,4.1989999999999998]
["TotalScoreLocation","F2",null,{"$f":"E11-0.8","v":4.2},5]
[]
["DebugCell","H2"]

{"sheet":"Instructions (2)","index":9,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[1,"On the Set Parameters sheet, configure:",null,null,null,null,"If want to change ranges or colors"]
[null,"a","Option: Change the range of colors for range of scores"]
[null,"b","Option: Change range of scores for range of colors"]
[null,"c","Set the number of slidebar graphs you want to generate"]
[null,"d","Click the Update Graphs buttion"]
[null,"e","Click OK when program done updating"]
[]
[2,"On the SidebarMetrics sheet, score",null,null,null,null,"If want to update graphs to reflect new scores"]
[null,"a","attach scores to each component"]
[null,"b","attach weights to each component"]
[null,"c","Click on Update Score button"]
[null,"d","Click OK when program done updating"]

{"sheet":"Debug","index":10,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Shape Name","TOP","Left","Width","Cell_Left"]
["buttonUpdateGraphs",3.75,535.5,81]
["SliderbarM",107.62496185302734,63,288]