{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Menu","Instructions","Configuration","Glossary","1. Data Strategy & Governance","2. Data Life Cycle Management","3. Data Arch. & Integration","4. Data Collaboration","5. Data Quality","Results"],"not_rendered":{"charts":14,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Menu","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,7],[2,2,2,7],[10,3,11,6]]}
[]
[null,null,"NCHRP 08-92 Data Management Assessment"]
[null,null,"Agency Level"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Self-Assessment Elements"]

{"sheet":"Instructions","index":1,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[36,1,36,18],[37,12,37,13],[1,1,1,18],[3,1,3,18]]}
[]
[null,"Instructions"]
[]
[null,"Overview"]
[null,"This tool allows the agency to self-assess the maturity level of its data management practices based on five elements:"]
[]
[null,"Data Strategy and Governance"]
[null,"Data Life Cycle Management"]
[null,"Data Architecture and Integration"]
[null,"Data Collaboration"]
[null,"Data Quality"]
[]
[null,"Each of these elements is further divided into sub-elements.  For example, Data Quality is divided into the following sub-elements: "]
[]
[null,"Measurement and Reporting"]
[null,"Assurance and Improvement"]
[]
[null,"For each sub-element, there are five possible maturity levels with the following definitions:"]
[]
[null,"1: Initial",null,"Ad-Hoc and event driven, success due to heroic efforts of individuals"]
[null,"2: Developing",null,"Recognized need for improvement, pilot initiatives underway"]
[null,"3: Defined",null,"Defined & documented processes not yet stabilized or widely socialized"]
[null,"4: Functioning",null,"Implemented processes - operating and adding value"]
[null,"5: Sustained",null,"Evaluated & improved processes, sustained over time"]
[]
[null,"The specific criteria for a particular maturity level depends on the sub-element."]
[]
[null,"Based on the provided criteria, the user is asked to rate how well the agency meets the criteria as follows:"]
[]
[null,"Totally Disagree"]
[null,"Somewhat Disagree"]
[null,"Somewhat Agree"]
[null,"Totally Agree"]
[]
[null,"Once the user has finished providing input, an overall maturity level is shown for each element and for the data management program as a whole."]
[]
[null,"Workflow"]
[null,"Throughout this spreadsheet tool, cells that require an input from the user will have the following color:",null,null,null,null,null,null,null,null,null,null,"This is an input"]
[]
[null,"The first tab after the instructions is the Configuration tab, which allows the user to do the following:"]
[]
[null,"Adjust the weights between sub-elements used to calculate the maturity level of an element.  Setting a sub-element weight to 0% excludes it from the analysis."]
[null,"Adjust the weights between elements used to calculate the maturity level of the data management program as a whole.  Setting an element weight to 0% excludes it from the analysis."]
[null,"Adjust the threshold value that the user must provide for a maturity level to be a candidate for ranking."]
[]
[null,"The next tab is the Glossary, where the user can review the meaning of technical terms."]
[]
[null,"Next are the five element tabs, where the user provides input for each criteria."]
[null,"The user must provide input for all criteria, except if an element or sub-element has been excluded from analysis in the configuration tab."]
[null,"However, users do not have to complete the elements in consecutive order and do not have to finish one entirely before moving on to the next one."]
[null,"The color of the element tab will dynamically adjust from orange to dark green based on the user's progress."]
[]
[null,"Once the user is finished, the Results tab shows the overall maturity level for each element and for the data management program as a whole."]

{"sheet":"Configuration","index":2,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[13,5,18,5],[25,1,26,1],[25,4,26,4],[4,1,4,4],[6,3,6,4],[25,5,26,5],[8,1,12,1],[13,1,18,1],[19,1,22,1],[23,1,24,1],[8,4,12,4],[13,4,18,4],[6,1,7,1],[6,2,7,2],[19,4,22,4],[23,4,24,4],[23,5,24,5],[19,5,22,5],[8,5,12,5]]}
[]
[]
[]
[]
[null,"Configuration",null,null,null,null,"Totally Disagree"]
[null,null,null,null,null,null,"Somewhat Disagree"]
[null,"Element","Sub-Element","Weights",null,null,"Somewhat Agree"]
[null,null,null,"Sub-Element","Element",null,"Totally Agree"]
[1.1000000000000001,"Data Strategy and Governance","Strategy and Direction",0.2,0.2,{"$f":"IF(OR(SUM(D9:D13)<0.99, SUM(D9:D13)>1.01),B9&\" sub-element weights must sum to 100%\",\"\")","v":""},null,null,null,null,null,0.2]
[1.2,null,"Roles and Accountability",0.2,null,null,null,null,null,null,null,0.2]
[1.3,null,"Policies and Processes",0.2,null,null,null,null,null,null,null,0.2]
[1.4,null,"Data Asset Inventory and Value",0.2,null,null,null,null,null,null,null,0.2]
[1.6,null,"Data Management Sustainability",0.2,null,null,null,null,null,null,null,0.2]
[2.1,"Data Life Cycle Management","Data Updating",0.16666666666666666,0.2,{"$f":"IF(OR(SUM(D14:D19)<0.99, SUM(D14:D19)>1.01),B14&\" sub-element weights must sum to 100%\",\"\")","v":""},null,null,null,null,null,{"$f":"1/6","v":0.16666666666666666}]
[2.2000000000000002,null,"Data Access Control",0.16666666666666666,null,null,null,null,null,null,null,{"$f":"1/6","v":0.16666666666666666}]
[2.2999999999999998,null,"Data Findability and Documentation",0.16666666666666666,null,null,null,null,null,null,null,0.16666666666666666]
[2.4,null,"Data Backups and Archiving",0.16666666666666666,null,null,null,null,null,null,null,0.16666666666666666]
[2.5,null,"Data Change Management",0.16666666666666666,null,null,null,null,null,null,null,0.16666666666666666]
[2.6,null,"Data Delivery",0.16666666666666666,null,null,null,null,null,null,null,0.16666666666666666]
[3.1,"Data Architecture and Integration","Location Referencing",0.25,0.2,{"$f":"IF(OR(SUM(D20:D23)<0.99, SUM(D20:D23)>1.01),B20&\" sub-element weights must sum to 100%\",\"\")","v":""},null,null,null,null,null,0.25]
[3.2,null,"Geospatial Data Management",0.25,null,null,null,null,null,null,null,0.25]
[3.3,null,"Data Consistency and Integration",0.25,null,null,null,null,null,null,null,0.25]
[3.4,null,"Temporal Data Management",0.25,null,null,null,null,null,null,null,0.25]
[4.0999999999999996,"Data Collaboration","Internal Agency Collaboration",0.5,0.2,{"$f":"IF(OR(SUM(D24:D25)<0.99, SUM(D24:D25)>1.01),B24&\" sub-element weights must sum to 100%\",\"\")","v":""},null,null,null,null,null,0.5]
[4.2,null,"External Collaboration",0.5,null,null,null,null,null,null,null,0.5]
[5.0999999999999996,"Data Quality","Measurement and Reporting",0.5,0.2,{"$f":"IF(OR(SUM(D26:D27)<0.99, SUM(D26:D27)>1.01),B26&\" sub-element weights must sum to 100%\",\"\")","v":""},null,null,null,null,null,0.5]
[5.2,null,"Assurance and Improvement",0.5,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,{"$f":"IF(OR(SUM(E9:E27)<0.99, SUM(E9:E27)>1.01),\"Element weights must sum to 100%\",\"\")","v":""}]
[]
[]
[null,"Threshold","Somewhat Agree"]
[null,"This is the minimum response that the user must provide for a maturity level to be a candidate for ranking."]
[null,null,{"$f":"VLOOKUP(C31,$D$33:$E$36,2,FALSE)","v":3},"Totally Disagree",1]
[null,null,null,"Somewhat Disagree",2]
[null,null,null,"Somewhat Agree",3]
[null,null,null,"Totally Agree",4]

{"sheet":"Glossary","index":3,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,1,4,4]]}
[]
[]
[]
[]
[null,"Glossary of Terms"]
[]
[null,"Business rule",null,null,null,"A formally stated constraint governing the characteristics or behavior of an object or the relationship between objects (entities). Example: the width of an Interstate lane is 12 feet."]
[null,"Change management",null,null,null,"Processes in place to review, evaluate and coordinate changes to data products, applications and systems before they are implemented to minimize impacts to users and reduce any change –related errors."]
[null,"Data architecture",null,null,null,"A master set of data models and design approaches identifying the strategic data requirements and the components of data management solutions, usually at an enterprise level."]
[null,"Data archiving",null,null,null,"The process of moving data that is no longer actively used to a separate data storage device for long-term retention."]
[null,"Data business plan",null,null,null,"A document that establishes data collection and management strategies that align with business objectives."]
[null,"Data catalog",null,null,null,"A listing of available data resources (e.g. data sets, query tools, maps, reports) including descriptive information on what is included and how to access. compiled for the purpose of facilitating discovery and understanding of available data.   "]
[null,"Data classifications",null,null,null,"A set of categories used to distinguish key characteristics of a given data resource such as level of sensitivity or degree of importance, used to determine appropriate governance policies"]
[null,"Data dictionary",null,null,null,"A place where a limited set of “data about the data” or meta data are stored.  It may include technical meta data including column names and formats and/or business meta data such as data definitions, business rules and code values  "]
[null,"Data entities",null,null,null,"A classification of the types of objects found in the real world --persons, places, things, concepts and events – of interest to the enterprise. "]
[null,"Data governance ",null,null,null,"The processes, practices, policies and decision making authorities in place to plan, monitor, and enforce the management of data assets.  "]
[null,"Data governance body",null,null,null,"A high-level data governance structure in the organization that typically includes senior managers.  Responsibilities may include identifying priorities for data governance policies, projects or system enhancements, and the authorization, implementation and enforcement of data governance policies and standards"]
[null,"Data inventory",null,null,null,"A compilation of information about an agency's data programs or major data categories that may include details on data types, storage locations, collection and update cycles, responsibilities, uses, and other information useful for data program management"]
[null,"Data program",null,null,null,"A business unit whose primary responsibilities include collection, processing, reporting and/or distribution of a particular class of data.  DOT examples include: Traffic Monitoring, Crash Records, HPMS/Road Inventory, Pavement Management. "]
[null,"Data quality",null,null,null,"The degree to which data is accurate, complete, timely and consistent with requirements and business rules and relevant for a given use"]
[null,"Data set",null,null,null,"A collection of data made available for access or download in one or more formats. Examples: a state’s crash records for a single year; a database with roughness measures for pavement segments on the state highway system "]
[null,"Data stewardship",null,null,null,"The formal, specifically assigned and entrusted accountability for business (non-technical) responsibilities ensuring effective control and use of data and information assets."]
[null,"Data visualization",null,null,null,"Techniques for graphical representation of trends, patterns and other information.  "]
[null,"Findability",null,null,null,"The degree to which relevant information is easy to find when needed; findability is improved through application of metadata, taxonomies and other organizing tools, and search technologies. "]
[null,"Geospatial data",null,null,null,"Data that include location, specified with explicit geographic positioning information."]
[null,"Linear Referencing System (LRS)",null,null,null,"A system for maintaining location information for events that occur along a linear network such as a road or rail line.  It includes one or more methods for specifying the location of any point along the network based on distance from a known reference location (e.g. intersection-offset or county-relative milepoint) "]
[null,"Master data",null,null,null,"Master Data.  Shared data about the core entities of an enterprise.  In a private company, examples of core entities are customers, products and vendors; in a DOT, examples of master data entities are routes, projects, funding sources and district offices."]
[null,"Meta data",null,null,null,"Data describing context, content, and structure of documents and records and the management of such documents and records through time. Literally, data about data "]
[null,"Records management",null,null,null,"The systematic and administrative control of records throughout their life cycle to ensure efficiency and economy in their creation, use, handling, control, maintenance, and disposition. Similar to document management, but focused on documents that have been designated as official records with an emphasis on legal, regulatory and risk management concerns. "]
[null,"Quality assurance",null,null,null,"Processes to ensure that data meets specified requirements"]
[null,"Quality control",null,null,null,"Processes to detect defects in collected data and take appropriate action. "]
[null,"Sensitive data",null,null,null,"Data that is confidential, privileged, or proprietary that should be protected from unauthorized disclosure, loss, misuse, or corruption in order to avoid serious consequences to the organization that owns it."]

{"sheet":"1. Data Strategy & Governance","index":4,"n_rows":73,"n_cols":34,"rows_kept":73,"cut":false,"hidden":false,"merged":[[66,1,67,19],[64,2,64,18],[48,2,48,18],[49,2,49,18],[60,2,60,18],[61,2,61,18],[62,2,62,18],[63,2,63,18],[51,1,52,19],[47,2,47,18],[22,2,22,18],[23,2,23,18],[24,2,24,18],[25,2,25,18],[33,2,33,18],[34,2,34,18],[35,2,35,18],[36,2,36,18],[37,2,37,18],[45,2,45,18],[46,2,46,18],[27,1,28,19],[39,1,40,19],[21,2,21,18],[9,2,9,18],[10,2,10,18],[11,2,11,18],[12,2,12,18],[13,2,13,18],[15,1,16,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearCol"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",0]
[1,"1. Data Strategy and Governance - Agency Level Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Disagree",1]
[null,"Leadership and management practices to manage data as a strategic agency asset.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Disagree",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Agree",3]
[1.1000000000000001,"1.1","Strategy and Direction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Agree",4]
[null,null,"Leadership commitment and strategic planning to maximize value of data to meet agency goals.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"answerVal","includeCheck","responseCheck"]
[1,"1.1.1","Data collection and management is performed by individual business units with little or no agency-wide direction or coordination:\nData improvements are not systematically or regularly identified - they are implemented on a reactive or opportunistic basis:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T10,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W10=0,\"N/A\",T10)","v":"Answer"}]
[2,"1.1.2","Efforts to implement agency-wide data governance or assess agency-wide data needs are being discussed or planned:\nData improvement needs are identified and communicated to management in an informal manner:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T11,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W11=0,\"N/A\",T11)","v":"Answer"}]
[3,"1.1.3","Executive leadership has communicated their expectation that business units and information technology functions should collaborate on identifying and implementing data improvements that are of agency-wide benefit:\nData business plans or equivalent planning tools have been prepared to identify short and longer term data collection and management strategies that align with business objectives:\nData improvement needs have been systematically reviewed, assessed and documented:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W12=0,\"N/A\",T12)","v":"Answer"}]
[4,"1.1.4","Agency leadership regularly communicates and demonstrates active support for data improvements that will lead to improved agency effectiveness and efficiency:\nAgency leadership actively works to facilitate collaboration across business units on data improvements and maintain strong partnerships between IT and business unit managers:\nData business plans or equivalent planning tools are regularly updated:\nA regular process of data needs assessment is in place, and is used to drive budgeting decisions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W13=0,\"N/A\",T13)","v":"Answer"}]
[5,"1.1.5","Data governance and planning activities are continually refined to focus on key risks and opportunities - and eliminate activities without demonstrated payoff:\nData governance and planning activities would have a high probability of continuing through changes in executive leadership:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W14=0,\"N/A\",T14)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V10:V14>=Threshold)*A10:A14))=0, 1, SUMPRODUCT(MAX((V10:V14>=Threshold)*A10:A14)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[1.2,"1.2.","Roles and Accountability"]
[null,null,"Clear roles, accountability and decision making authority for data quality, value and appropriate use."]
[1,"1.2.1","Accountability for the quality, value, and appropriate use of data has not been clearly established:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T22,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W22=0,\"N/A\",T22)","v":"Answer"}]
[2,"1.2.2","One or more individuals have been identify to lead agency-wide data governance activities:\nA business lead or point person has been  designated for each major data set or application  but the responsibilities of their role haven't been spelled out:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T23,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W23=0,\"N/A\",T23)","v":"Answer"}]
[3,"1.2.3","An agency-wide data governance body has been established with representation from information technology and business functions, and has defined its charter:\nObjectives and performance metrics for data governance and stewardship have been defined and documented:\nRole(s) have been designated to identify points of accountability for data quality, value and appropriate use - for priority data programs or data subject categories:\nDecision making authority has been defined for collection/acquisition of new data, discontinuation of current data collection, and significant changes to the content of existing data:\nCapabilities and skills for data management are included in staff position descriptions, agency recruiting and staff development efforts:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W24=0,\"N/A\",T24)","v":"Answer"}]
[4,"1.2.4","An agency-wide data governance body is active and achieving results recognized as valuable:\nThe agency is successfully identifying and resolving situations where individual business unit interests are in conflict with agency-wide interests related to data collection and management:\nStaff with responsibility for data stewardship and management have sufficient time and training to carry out these responsibilities:\nStaff with responsibility for data stewardship and management play an active role in defining data improvements and periodically produce reports of progress to their managers:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W25=0,\"N/A\",T25)","v":"Answer"}]
[5,"1.2.5","A charter for agency-wide data governance body is reviewed periodically and updated based on experience:\nStewardship roles are periodically reviewed and refined to reflect new or changing data requirements and implementation of new data systems:\nStaff with responsibility for data stewardship and management are coordinating with their peers in the agency and with external data partners to deliver best value for resources invested:\nData management-related metrics are routinely considered in employee performance reviews:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W26=0,\"N/A\",T26)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V22:V26>=Threshold)*A22:A26))=0, 1, SUMPRODUCT(MAX((V22:V26>=Threshold)*A22:A26)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[1.3,"1.3.","Policies and Processes"]
[null,null,"Adoption of principles, policies and business processes for managing data as a strategic agency asset."]
[1,"1.3.1","No formal policies and procedures have been defined:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T34,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W34=0,\"N/A\",T34)","v":"Answer"}]
[2,"1.3.2","Executive leadership has endorsed basic data principles:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T35,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W35=0,\"N/A\",T35)","v":"Answer"}]
[3,"1.3.3","The scope of agency-wide data governance has been established:\nData classifications have been defined based on agency-wide importance or need for cross-business unit integration:\nA limited set of data management policies have been adopted for priority data categories:\nThe agency has a documented procedure and decision making process for requesting and evaluating new data collection or acquisition requests:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W36=0,\"N/A\",T36)","v":"Answer"}]
[4,"1.3.4","A comprehensive set of data management policies have been adopted based on collaboration across the agency including IT, business units, and records management:\nProcesses are in place to monitor and enforce compliance with policies:\nThe agency has a documented and implemented procedure for requesting and evaluating new data collection or acquisition requests (i.e. the documented procedure is routinely followed):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W37=0,\"N/A\",T37)","v":"Answer"}]
[5,"1.3.5","Policies are regularly reviewed and updated  based on factors such as awareness/reach within the agency, effectiveness and cost burden:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W38=0,\"N/A\",T38)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V34:V38>=Threshold)*A34:A38))=0, 1, SUMPRODUCT(MAX((V34:V38>=Threshold)*A34:A38)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[1.4,"1.4.","Data Asset Inventory and Value"]
[null,null,"Tracking of agency data assets and their value added."]
[1,"1.4.1","There are no inventories of available data sets:\nThere is limited awareness of how  data sets are used and what value is being provided:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T46,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W46=0,\"N/A\",T46)","v":"Answer"}]
[2,"1.4.2","Some business units maintain lists of available data sets but there is no consistent, agency-wide data inventory:\nThere is general awareness of how  different data sets are used and what value is being provided, but no records are kept on this:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T47,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W47=0,\"N/A\",T47)","v":"Answer"}]
[3,"1.4.3","Data sets of agency-wide importance have been identified and documented with basic elements including: business contact, technical contact, location, and description:\nPrimary users and uses of each data set have been identified and documented:\nData collection or acquisition costs are tracked:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W48=0,\"N/A\",T48)","v":"Answer"}]
[4,"1.4.4","A consistent agency-wide inventory of data sets is maintained and kept up to date as new data sets come on line:\nData inventory information is used to identify duplicative data sets that can be eliminated or consolidated:\nManagers use information about data storage and management costs to evaluate opportunities for improved efficiencies:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W49=0,\"N/A\",T49)","v":"Answer"}]
[5,"1.4.5","There is a good understanding of the value provided by each data set with respect to agency efficiency and effectiveness:\nData collection and management methods are regularly evaluated and improved:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W50=0,\"N/A\",T50)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V46:V50>=Threshold)*A46:A50))=0, 1, SUMPRODUCT(MAX((V46:V50>=Threshold)*A46:A50)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[null,"1.5. Relationship with Data Customers (Program-Specific Element Only)"]
[]
[]
[1.6,"1.6.","Data Management Sustainability"]
[null,null,"Continuity of data management knowledge and expertise through staff transitions."]
[1,"1.6.1","Risks and needs associated with data management knowledge and core competencies are not well understood:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T61,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$59,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W61=0,\"N/A\",T61)","v":"Answer"}]
[2,"1.6.2","There is some understanding of risks associated with retirement of key individuals with specialized knowledge of data systems - but these risks have not been systematically identified:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T62,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$59,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W62=0,\"N/A\",T62)","v":"Answer"}]
[3,"1.6.3","Risks associated with potential loss of key individuals with specialized knowledge of data systems have been systematically identified.  Strategies have been developed to mitigate these risks:\nCore competencies for data management are included in staff position descriptions, agency recruiting and staff development efforts:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$59,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W63=0,\"N/A\",T63)","v":"Answer"}]
[4,"1.6.4","There is a standard process in place to ensure continuity in data management practices through staff transitions:\nStaffing requirements for data management activities are understood and planned-for:\nProcesses are in place to ensure that work commitments are in line with  available staff resources:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$59,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W64=0,\"N/A\",T64)","v":"Answer"}]
[5,"1.6.5","People with specialized knowledge about agency data sets have been identified and there are succession plans and mentoring strategies in place to pass on this knowledge to others:\nThere is a functioning process in place to bring on new skills and capabilities as needed to meet changing technologies and data management methods:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$59,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W65=0,\"N/A\",T65)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V61:V65>=Threshold)*A61:A65))=0, 1, SUMPRODUCT(MAX((V61:V65>=Threshold)*A61:A65)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress:",{"$f":"SUMPRODUCT((W10:W65)*(T10:T65<>\"Answer\"))/COUNTIF(W10:W65, 1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score:",{"$f":"IF(COUNTIF(X10:X65,\"Answer\")>0,\"N/A\",VLOOKUP($A$8,Configuration!$A$7:$D$27,4,FALSE)*T15+VLOOKUP($A$20,Configuration!$A$7:$D$27,4,FALSE)*T27+VLOOKUP($A$32,Configuration!$A$7:$D$27,4,FALSE)*T39+VLOOKUP($A$44,Configuration!$A$7:$D$27,4,FALSE)*T51+VLOOKUP($A$59,Configuration!$A$7:$D$27,4,FALSE)*T66)","v":"N/A"}]

{"sheet":"2. Data Life Cycle Management","index":5,"n_rows":82,"n_cols":33,"rows_kept":82,"cut":false,"hidden":false,"merged":[[75,1,76,18],[73,2,73,17],[48,2,48,17],[49,2,49,17],[57,2,57,17],[58,2,58,17],[59,2,59,17],[60,2,60,17],[61,2,61,17],[69,2,69,17],[70,2,70,17],[71,2,71,17],[72,2,72,17],[51,1,52,18],[63,1,64,18],[47,2,47,17],[22,2,22,17],[23,2,23,17],[24,2,24,17],[25,2,25,17],[33,2,33,17],[34,2,34,17],[35,2,35,17],[36,2,36,17],[37,2,37,17],[45,2,45,17],[46,2,46,17],[27,1,28,18],[39,1,40,18],[21,2,21,17],[9,2,9,17],[10,2,10,17],[11,2,11,17],[12,2,12,17],[13,2,13,17],[15,1,16,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearCol"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",0]
[2,"2. Data Life Cycle Management - Agency Level Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Disagree",1]
[null,"Practices for managing data throughout its life cycle from collection to archiving or deletion.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Disagree",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Agree",3]
[2.1,"2.1.","Data Updating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Agree",4]
[null,null,"Well-defined and coordinated data update cycles.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"answerVal","includeCheck","responseCheck"]
[1,"2.1.1","Data updating cycles and business rules for data updates have not been defined:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S10,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V10=0,\"N/A\",S10)","v":"Answer"}]
[2,"2.1.2","Updating cycles have been established but have not been documented:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S11,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V11=0,\"N/A\",S11)","v":"Answer"}]
[3,"2.1.3","Updating cycles have been documented:\nBusiness rules have been defined for how key data entities are added, updated and deleted:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V12=0,\"N/A\",S12)","v":"Answer"}]
[4,"2.1.4","Updating cycles are being consistently followed:\nBusiness rules for data updating are embedded in and enforced by applications (where applicable):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V13=0,\"N/A\",S13)","v":"Answer"}]
[5,"2.1.5","Data updating methods are periodically reviewed to identify opportunities for improved efficiencies:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V14=0,\"N/A\",S14)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((U10:U14>=Threshold)*A10:A14))=0, 1, SUMPRODUCT(MAX((U10:U14>=Threshold)*A10:A14)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[2.2000000000000002,"2.2.","Data Access Control"]
[null,null,"Well-defined policies and guidelines for managing access to data sets."]
[1,"2.2.1","There are no established policies for determining if access to data sets should be limited:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S22,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V22=0,\"N/A\",S22)","v":"Answer"}]
[2,"2.2.2","A process of defining what data is sensitive and needs to be protected is underway:\nA process of defining what data can be shared outside the agency is underway:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S23,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V23=0,\"N/A\",S23)","v":"Answer"}]
[3,"2.2.3","Standard guidelines are available for identifying and protecting sensitive data:\nCriteria and processes have been defined for making data available to the public:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V24=0,\"N/A\",S24)","v":"Answer"}]
[4,"2.2.4","All core data sets have been classified based on guidelines for data protection and access:\nData owners/providers are complying with guidelines for data protection and access:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V25=0,\"N/A\",S25)","v":"Answer"}]
[5,"2.2.5","Data access guidelines and procedures are well established, and are periodically reviewed and updated:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V26=0,\"N/A\",S26)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((U22:U26>=Threshold)*A22:A26))=0, 1, SUMPRODUCT(MAX((U22:U26>=Threshold)*A22:A26)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[2.2999999999999998,"2.3.","Data Findability and Documentation"]
[null,null,"Availability of data catalogs and dictionaries that enable discovery and understanding of available agency data assets."]
[1,"2.3.1","Users rely on \"word of mouth\" to discover what data are available:\nThere are variations across data sets in terms of the level and type of available documentation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S34,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V34=0,\"N/A\",S34)","v":"Answer"}]
[2,"2.3.2","Efforts are underway to improve data findability and documentation through adoption of common metadata standards, development of data set catalogs, or creation of web pages with links to commonly requested data sets:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S35,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V35=0,\"N/A\",S35)","v":"Answer"}]
[3,"2.3.3","An agency-wide data catalog or metadata repository has been established to improve data findability for business users, and is in the process of being populated:\nStandards and policies have been defined to ensure that there is a data dictionary available for each data set:\nTemplates for describing data collection, updating and reporting processes have been developed and are starting to be utilized:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V36=0,\"N/A\",S36)","v":"Answer"}]
[4,"2.3.4","Business users can access a listing of available agency data sets to discover data of potential value to meet their needs:\nConsistent documentation is available describing data collection, updating and reporting cycles for most of the agency's core data sets:\nData dictionary information is available and up-to-date:\nQuality assurance processes are in place to ensure that data dictionary information is complete and useful:\nProcesses are in place to keep the  data set listing (or catalog) up to date when data sets are added or discontinued:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V37=0,\"N/A\",S37)","v":"Answer"}]
[5,"2.3.5","Business users can search for availability of agency data on a particular subject or entity type:\nThe agency periodically evaluates opportunities to refine its approach to data documentation based on user needs and new technologies:\nDocumentation of data sets is periodically improved based on feedback from users and research into best practices:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V38=0,\"N/A\",S38)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((U34:U38>=Threshold)*A34:A38))=0, 1, SUMPRODUCT(MAX((U34:U38>=Threshold)*A34:A38)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[2.4,"2.4.","Data Backups and Archiving"]
[null,null,"Guidelines and procedures for protection and long term preservation of data assets."]
[1,"2.4.1","There may be important data sets that are managed using desktop applications within individual business units, but these have not been systematically identified:\nIt is up to the discretion of each business unit to ensure that its data sets are backed up and periodically archived to enable future retrieval and use:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S46,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V46=0,\"N/A\",S46)","v":"Answer"}]
[2,"2.4.2","Several of the agency's important data sets are managed using desktop applications (e.g. spreadsheets) but plans are in process to bring these into enterprise databases:\nData owners receive informal (unwritten) guidance regarding frequency and storage locations for backups and archive copies:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S47,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V47=0,\"N/A\",S47)","v":"Answer"}]
[3,"2.4.3","Most of the agency's important data sets are managed within enterprise databases (e.g. Oracle, SQL Server) and regular backups are made:\nThere are written procedures available on backup frequency and storage locations:\nThere are written procedures available on data archiving and retrieval:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V48=0,\"N/A\",S48)","v":"Answer"}]
[4,"2.4.4","All of the agency's important data sets are managed within enterprise databases (e.g. Oracle, SQL Server) and regular backups are made:\nBackup procedures are consistently followed:\nArchiving procedures are consistently followed:\nBackup procedures have been fully tested:\nArchiving procedures have been fully tested:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V49=0,\"N/A\",S49)","v":"Answer"}]
[5,"2.4.5","Data managers and stewards periodically review existing data backup  and archiving procedures and update them as appropriate to reflect user feedback or changing needs:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V50=0,\"N/A\",S50)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((U46:U50>=Threshold)*A46:A50))=0, 1, SUMPRODUCT(MAX((U46:U50>=Threshold)*A46:A50)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[2.5,"2.5.","Data Change Management"]
[null,null,"Processes to minimize unanticipated downstream impacts of data changes."]
[1,"2.5.1","There are no defined processes for analyzing how changes to data structures, definitions or unique identifiers  in one system may impact reports or other dependent systems:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S58,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$56,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V58=0,\"N/A\",S58)","v":"Answer"}]
[2,"2.5.2","A standard data change management process is being developed:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S59,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$56,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V59=0,\"N/A\",S59)","v":"Answer"}]
[3,"2.5.3","A standard change management process has been defined for changes to data elements that may impact multiple systems.  This involves consultation and communication with affected data owners and users, and propagation of the changes across databases as needed.  Change analysis and propagation processes are mostly manual:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$56,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V60=0,\"N/A\",S60)","v":"Answer"}]
[4,"2.5.4","A metadata repository or other tool is available to conduct change impact analysis - i.e. identification of which systems and database tables contain a particular data element:\nAutomated processes are in place to manage changes to code lists and propagate these changes to various business systems:\nAutomated processes are in place to manage additions, deletions and changes to master data entities:\nA change management process is in place and functioning as intended:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$56,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V61=0,\"N/A\",S61)","v":"Answer"}]
[5,"2.5.5","A periodic review is conducted of the nature and extent of data changes to improve future data architecture and change management practices:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$56,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V62=0,\"N/A\",S62)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((U58:U62>=Threshold)*A58:A62))=0, 1, SUMPRODUCT(MAX((U58:U62>=Threshold)*A58:A62)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[2.6,"2.6.","Data Delivery"]
[null,null,"Delivery of data to users in a variety of convenient, useful and usable forms."]
[1,"2.6.1","Data reporting is accomplished in a decentralized fashion - individual data or application owners separately plan and implement reporting capabilities:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S70,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$68,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V70=0,\"N/A\",S70)","v":"Answer"}]
[2,"2.6.2","The agency is exploring agency-wide needs and opportunities for improving access to integrated agency data in usable forms. Pilot initiatives may be underway:\nAd-hoc query tools are available but are geared to a few individuals who have specialized training.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(S71,$AF$4:$AG$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$68,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V71=0,\"N/A\",S71)","v":"Answer"}]
[3,"2.6.3","The agency has implemented enterprise solutions for data access, reporting, visualization and analysis (e.g. data warehouse, data marts, dashboards):\nAgency employees have access to a common map-based interface that allows them to view and analyze a  variety of information such as pavement condition, bridge condition, crashes, traffic counts, programmed projects, and  completed projects:\nThe agency provides access to both \"live\" data and \"frozen\" or \"snapshot\" data, depending on an assessment of business needs:\nThe agency has developed a standard approach to accessing agency data from mobile devices:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$68,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V72=0,\"N/A\",S72)","v":"Answer"}]
[4,"2.6.4","The agency has the expertise and tools in-house to develop data marts that allow employees to \"slice and dice\" data sets, perform ad-hoc queries and produce reports at the desired level of summarization:\nThe agency has the expertise and tools in-house to combine data sets that are based on different road sections (e.g. 10th mile sections for pavement information and 2 mile sections for AADT):\nAgency employees have the ability to easily visualize trend information for asset condition, capital and maintenance expenditures, traffic, crash rates, and other important agency performance indicators:\nAgency field staff can access information about assets, projects, or work orders on mobile devices:\nThe agency has sufficient network connectivity and bandwidth to enable remote data access from field offices:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$68,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V73=0,\"N/A\",S73)","v":"Answer"}]
[5,"2.6.5","The agency has implemented a flexible architecture for reporting and mapping that enables them to easily add new data sources and enhance analysis capabilities in response to newly identified requirements:\nThe agency routinely improves data access and usability based on feedback from users and monitoring of the latest technology developments:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$68,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(V74=0,\"N/A\",S74)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((U70:U74>=Threshold)*A70:A74))=0, 1, SUMPRODUCT(MAX((U70:U74>=Threshold)*A70:A74)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress:",{"$f":"SUMPRODUCT((V10:V74)*(S10:S74<>\"Answer\"))/COUNTIF(V10:V74, 1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score:",{"$f":"IF(COUNTIF(W10:W74,\"Answer\")>0,\"N/A\",VLOOKUP($A$8,Configuration!$A$7:$D$27,4,FALSE)*S15+VLOOKUP($A$20,Configuration!$A$7:$D$27,4,FALSE)*S27+VLOOKUP($A$32,Configuration!$A$7:$D$27,4,FALSE)*S39+VLOOKUP($A$44,Configuration!$A$7:$D$27,4,FALSE)*S51+VLOOKUP($A$56,Configuration!$A$7:$D$27,4,FALSE)*S63+VLOOKUP($A$68,Configuration!$A$7:$D$27,4,FALSE)*S75)","v":"N/A"}]

{"sheet":"3. Data Arch. & Integration","index":6,"n_rows":58,"n_cols":34,"rows_kept":58,"cut":false,"hidden":false,"merged":[[51,1,52,19],[48,2,48,18],[49,2,49,18],[35,2,35,18],[36,2,36,18],[37,2,37,18],[45,2,45,18],[46,2,46,18],[47,2,47,18],[39,1,40,19],[34,2,34,18],[9,2,9,18],[10,2,10,18],[11,2,11,18],[12,2,12,18],[13,2,13,18],[21,2,21,18],[22,2,22,18],[23,2,23,18],[24,2,24,18],[25,2,25,18],[33,2,33,18],[15,1,16,19],[27,1,28,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearCol"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",0]
[3,"3. Data Architecture and Integration - Agency Level Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Disagree",1]
[null,"Technical standards, processes, tools and coordination mechanisms to maximize data integration and minimize duplication.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Disagree",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Agree",3]
[3.1,"3.1.","Location Referencing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Agree",4]
[null,null,"Common location referencing methods across agency data sets.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"answerVal","includeCheck","responseCheck"]
[1,"3.1.1","The agency does not have a single common LRS:\nData sets including location elements cannot be spatially integrated with other agency data sets:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T10,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W10=0,\"N/A\",T10)","v":"Answer"}]
[2,"3.1.2","The agency is working towards establishing a single common LRS:\nRepresentation of location information is in the process of being standardized:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T11,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W11=0,\"N/A\",T11)","v":"Answer"}]
[3,"3.1.3","The agency has developed a single common LRS:\nQuality standards for the LRS have been established with input from a variety of business units:\nThe agency has defined a process for propagating changes in the LRS to various agency data sets:\nNew data sets that include location elements are collected using the agency's LRS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W12=0,\"N/A\",T12)","v":"Answer"}]
[4,"3.1.4","The agency's LRS is used for all agency data sets that include location:\nThe agency's LRS meets established quality standards:\nMethods are in place and functioning to propagate changes in location referencing resulting from road network changes to business data sets:\nMethods are in place and functioning to translate between coordinate-based location referencing (e.g. latitude/longitude) and linear referencing (e.g. route-milepoint):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W13=0,\"N/A\",T13)","v":"Answer"}]
[5,"3.1.5","The agency has a standard architecture for linking agency GIS and LRS data to business data systems:\nMethods for propagating changes in location referencing resulting from road network changes are automated:\nData owners/managers closely with agency GIS staff and proactively work to improve their data sets' consistency with agency-wide standards:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W14=0,\"N/A\",T14)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V10:V14>=Threshold)*A10:A14))=0, 1, SUMPRODUCT(MAX((V10:V14>=Threshold)*A10:A14)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[3.2,"3.2.","Geospatial Data Management"]
[null,null,"Standardized approach to collection, management and integration of geospatial data."]
[1,"3.2.1","The agency does not provide enterprise-wide planning and support for management and integration of geospatial data  \nManagement of geospatial data is not integrated with other agency data management and information technology functions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T22,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W22=0,\"N/A\",T22)","v":"Answer"}]
[2,"3.2.2","The agency has designated responsibilities for enterprise-wide planning and support for managing geospatial data\nThe agency manages a collection of spatial data sets and makes them available for internal use",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T23,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W23=0,\"N/A\",T23)","v":"Answer"}]
[3,"3.2.3","The agency has written policies and standards that define how geospatial data are to be collected, stored, managed, shared and integrated with non-spatial data attributes:\nThe agency includes consideration of spatial data in their information technology strategic plan (or equivalent) that identifies investment needs and priorities for hardware, software and data:\nThe agency has identified data entities that should have standard location referencing:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W24=0,\"N/A\",T24)","v":"Answer"}]
[4,"3.2.4","The agency has a well-understood and functioning process for collecting, adding and updating geospatial data sets:\nThe agency has a standard approach to assigning spatial location to key data entities (e.g. construction projects, assets.):\nTraining and support is provided to ensure adherence to adopted policies and standards for geospatial data collection and management, and to build skills in spatial data analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W25=0,\"N/A\",T25)","v":"Answer"}]
[5,"3.2.5","Spatial data collection, management and visualization requirements are fully integrated within the agency's information technology and data management planning and operational functions \nThe agency periodically reevaluates and updates its approach to geospatial data management to reflect changes in technology, data availability and cost, and user requirements:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W26=0,\"N/A\",T26)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V22:V26>=Threshold)*A22:A26))=0, 1, SUMPRODUCT(MAX((V22:V26>=Threshold)*A22:A26)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[3.3,"3.3.","Data Consistency and Integration"]
[null,null,"Standards and practices to ensure use of consistent coding and common linkages so that different data sets can be combined to meet business information needs."]
[1,"3.3.1","There have been no formal efforts to plan for data integration/linkage across business applications outside of the context of individual application development projects:\nLists of values for coded fields are defined for each application and there are no policies requiring consistency of code lists across applications:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T34,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W34=0,\"N/A\",T34)","v":"Answer"}]
[2,"3.3.2","Efforts are underway to identify key integration points across data sets:\nEffort are underway to identify data duplication and inconsistencies across sources:\nSome code lists are standardized across applications (e.g. city/county codes, organizational unit codes):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T35,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W35=0,\"N/A\",T35)","v":"Answer"}]
[3,"3.3.3","The agency has identified and defined  fundamental  master data entities (e.g. projects, roadway segments, bridges, employees) that are present in multiple business applications and has mapped which physical systems contain information related to these data entities:\nThe agency has established a list of key link fields (e.g. route ID, project ID) and have standardized these across systems in order to integrate different data sets to provide answers to business questions of interest:\nThe agency has identified single authoritative source systems for key data elements of agency-wide interest:\nThe agency has identified common code lists and maintains these lists in a central location:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W36=0,\"N/A\",T36)","v":"Answer"}]
[4,"3.3.4","The agency has procedures in place to ensure that externally procured data sets and applications adhere to established data standards and can be linked to existing data:\nThe agency has one or more skilled individuals with responsibility for data architecture and integration across systems:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W37=0,\"N/A\",T37)","v":"Answer"}]
[5,"3.3.5","The agency has a process in place to assess opportunities for reuse of existing data sources as new applications come online or new data acquisition efforts are considered:\nThe agency maintains an agency-wide data model and uses this model to minimize data duplication and inconsistencies as new data and systems come on line:\nThe agency has developed a \"to be\" data and system architecture and uses this architecture to guide system addition, replacement, consolidations and updates:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$32,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W38=0,\"N/A\",T38)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V34:V38>=Threshold)*A34:A38))=0, 1, SUMPRODUCT(MAX((V34:V38>=Threshold)*A34:A38)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[3.4,"3.4.","Temporal Data Management"]
[null,null,"Standardization of date-time data elements to enable trend analysis and integration across data sets that are collected and updated on varying cycles."]
[1,"3.4.1","There are no standards or guidelines in place regarding date and time-related data elements -for example, naming of fiscal versus calendar year; distinguishing data collection dates,  data loading or update dates, and  data effective dates:\nThere is no defined strategy for integrating data sets in order to provide a consistent \"point in time\" view of integrated information:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T46,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W46=0,\"N/A\",T46)","v":"Answer"}]
[2,"3.4.2","There are naming conventions and common practices in use regarding date-and-time-related data elements, but no written guidelines exist:\nThere is some understanding of user needs for trend analysis and creating snapshot views of data for analysis and reporting, but these needs have not been explored systematically or comprehensively:\nThere is experience with integrating data to create a snapshot in time view, but no repeatable procedures for this have been defined:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T47,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W47=0,\"N/A\",T47)","v":"Answer"}]
[3,"3.4.3","There are documented guidelines for ensuring consistency in use of date-and-time-related data elements across data sets and applications:\nData user requirements for trend analysis, snapshots and other uses of temporal information have been documented:\nThere are documented procedures or models for integrating across data sets to create a snapshot-in-time view:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W48=0,\"N/A\",T48)","v":"Answer"}]
[4,"3.4.4","There is consistency across the agency's major data sets in use of date-and-time-related data elements across data sets and applications:\nData user requirements for trend analysis, snapshots and other uses of temporal information can be met without major changes to data structures or substantial new development effort:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W49=0,\"N/A\",T49)","v":"Answer"}]
[5,"3.4.5","Data user requirements for trend analysis, snapshots and other uses of temporal information can be met through largely automated processes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$44,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W50=0,\"N/A\",T50)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V46:V50>=Threshold)*A46:A50))=0, 1, SUMPRODUCT(MAX((V46:V50>=Threshold)*A46:A50)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress:",{"$f":"SUMPRODUCT((W10:W50)*(T10:T50<>\"Answer\"))/COUNTIF(W10:W50, 1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score:",{"$f":"IF(COUNTIF(X10:X50,\"Answer\")>0,\"N/A\",VLOOKUP($A$8,Configuration!$A$7:$D$27,4,FALSE)*T15+VLOOKUP($A$20,Configuration!$A$7:$D$27,4,FALSE)*T27+VLOOKUP($A$32,Configuration!$A$7:$D$27,4,FALSE)*T39+VLOOKUP($A$44,Configuration!$A$7:$D$27,4,FALSE)*T51)","v":"N/A"}]

{"sheet":"4. Data Collaboration","index":7,"n_rows":33,"n_cols":34,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,1,16,19],[27,1,28,19],[25,2,25,18],[21,2,21,18],[22,2,22,18],[23,2,23,18],[24,2,24,18],[9,2,9,18],[10,2,10,18],[11,2,11,18],[12,2,12,18],[13,2,13,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearCol"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",0]
[4,"4. Data Collaboration - Agency Level Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Disagree",1]
[null,"Internal and external collaboration to maximize data sharing and avoid duplication of effort.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Disagree",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Agree",3]
[4.0999999999999996,"4.1.","Internal Agency Collaboration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Agree",4]
[null,null,"Collaboration across agency business units to leverage opportunities for efficiencies in data collection and management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"answerVal","includeCheck","responseCheck"]
[1,"4.1.1","Most data collection efforts in the agency are independent - there have been little or no efforts to coordinate across business units:\nThe agency does not have information about the extent to which data are duplicated:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T10,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W10=0,\"N/A\",T10)","v":"Answer"}]
[2,"4.1.2","The agency has done an assessment of the extent to which there is duplication across data sets within the agency:\nOpportunities for coordinating data collection and management across business units (e.g. safety and asset management) are periodically discussed, but limited progress has been made:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T11,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W11=0,\"N/A\",T11)","v":"Answer"}]
[3,"4.1.3","The agency has implemented a data collection effort involving coordination from more than one business unit (e.g. use of video imagery from pavement data collection to extract data on other assets):\nThe agency has defined metrics to track improvements in data collection and storage efficiency:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W12=0,\"N/A\",T12)","v":"Answer"}]
[4,"4.1.4","Agency business data owners are encouraged and incentivized to share their data with a broader audience within the agency (where appropriate):\nAgency business data owners are encouraged and incentivized to plan new data collection initiatives in partnerships with other business units where information needs of multiple units can be simultaneously addressed:\nThe agency monitors progress of efforts to reduce data duplication:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W13=0,\"N/A\",T13)","v":"Answer"}]
[5,"4.1.5","The agency periodically reviews its data collection programs to identify opportunities to leverage new technologies and externally available data sources:\nThe agency regularly seeks opportunities to minimize or reduce redundancy in data collection, storage and processing:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W14=0,\"N/A\",T14)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V10:V14>=Threshold)*A10:A14))=0, 1, SUMPRODUCT(MAX((V10:V14>=Threshold)*A10:A14)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[4.2,"4.2.","External Collaboration"]
[null,null,"Partnerships with external entities to share data and avoid duplication"]
[1,"4.2.1","Individual business units obtain and use publicly available data from external entities as needs and opportunities arise:\nThe agency has acquired single \"point in time\" data sets from external entities:\nExternal data requests are handled on a piecemeal basis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T22,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W22=0,\"N/A\",T22)","v":"Answer"}]
[2,"4.2.2","The agency is currently exploring partnerships with other public and private sector organizations to share data on an ongoing basis:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(T23,$AG$4:$AH$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W23=0,\"N/A\",T23)","v":"Answer"}]
[3,"4.2.3","The agency has data sharing agreements with external entities:\nThe agency provides \"self-serve\" access to data sets that are of value to external users:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W24=0,\"N/A\",T24)","v":"Answer"}]
[4,"4.2.4","The agency has sustained partnerships with external entities involving regular update cycles:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W25=0,\"N/A\",T25)","v":"Answer"}]
[5,"4.2.5","The agency routinely seeks new opportunities for data partnerships with external entities. They have designated staff liaison responsibilities for managing these external partnerships:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(W26=0,\"N/A\",T26)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((V22:V26>=Threshold)*A22:A26))=0, 1, SUMPRODUCT(MAX((V22:V26>=Threshold)*A22:A26)))","v":1}]
[null,"Comments:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress:",{"$f":"SUMPRODUCT((W10:W26)*(T10:T26<>\"Answer\"))/COUNTIF(W10:W26, 1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score:",{"$f":"IF(COUNTIF(X10:X26, \"Answer\")>0, \"N/A\", VLOOKUP($A$8,Configuration!$A$7:$D$27,4,FALSE)*T15+VLOOKUP($A$20,Configuration!$A$7:$D$27,4,FALSE)*T27)","v":"N/A"}]

{"sheet":"5. Data Quality","index":8,"n_rows":34,"n_cols":30,"rows_kept":34,"cut":false,"hidden":false,"merged":[[27,1,28,15],[23,2,23,14],[24,2,24,14],[9,2,9,14],[10,2,10,14],[11,2,11,14],[12,2,12,14],[13,2,13,14],[15,1,16,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"clearCol"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",0]
[5,"5. Data Quality - Agency Level Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Disagree",1]
[null,"Standards and practices to ensure that data are of sufficient quality to meet user needs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Disagree",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somewhat Agree",3]
[5.0999999999999996,"5.1.","Data Quality Measurement and Reporting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totally Agree",4]
[null,null,"Metrics and reporting to ensure user understanding of current data quality",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"answerVal","includeCheck","responseCheck"]
[1,"5.1.1","There are no agency-wide activities related to data quality measurement and reporting:",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(P10,$AC$4:$AD$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S10=0,\"N/A\",P10)","v":"Answer"}]
[2,"5.1.2","The agency is exploring establishment of common data quality metrics for shared data elements:",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(P11,$AC$4:$AD$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S11=0,\"N/A\",P11)","v":"Answer"}]
[3,"5.1.3","The agency has defined common data quality metrics across data programs in order to integrate data (e.g. locational accuracy):",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S12=0,\"N/A\",P12)","v":"Answer"}]
[4,"5.1.4","The agency has implemented data quality standards, verification techniques, and reports for common data elements:",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S13=0,\"N/A\",P13)","v":"Answer"}]
[5,"5.1.5","The agency proactively identifies new areas where common data quality metrics across data programs would be beneficial:",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$8,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S14=0,\"N/A\",P14)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((R10:R14>=Threshold)*A10:A14))=0, 1, SUMPRODUCT(MAX((R10:R14>=Threshold)*A10:A14)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[5.2,"5.2.","Data Quality Assurance and Improvement"]
[null,null,"Practices for improving quality of existing data and assuring quality of newly acquired data"]
[1,"5.2.1","Data quality is assessed and improved in the context of individual data programs. No agency-wide support is provided:",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(P22,$AC$4:$AD$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S22=0,\"N/A\",P22)","v":"Answer"}]
[2,"5.2.2","Limited technical assistance is available for data program managers or business units on fundamental data quality concepts and practices:",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",{"$f":"VLOOKUP(P23,$AC$4:$AD$8,2,FALSE)","v":0},{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S23=0,\"N/A\",P23)","v":"Answer"}]
[3,"5.2.3","The agency has established guidelines for determining spatial accuracy requirements and appropriate collection methods for new data collection efforts:\nThe agency incorporates practices supporting data quality within the standard software development process, including definition and documentation of business rules for data validation, and use of standard lists of values:",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S24=0,\"N/A\",P24)","v":"Answer"}]
[4,"5.2.4","The agency provides standard tools for gathering and tracking response to user feedback on data quality issues:\nThe agency has deployed data profiling and cleansing tools and makes use of these tools to proactively identify (and, where possible) correct data quality issues:",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S25=0,\"N/A\",P25)","v":"Answer"}]
[5,"5.2.5","The agency provides tools for specification, maintenance and management of business rules:",null,null,null,null,null,null,null,null,null,null,null,null,"Answer","clearRow",0,{"$f":"IF(VLOOKUP($A$20,Configuration!$A$9:$E$27,4, FALSE)=0, 0, 1)","v":1},{"$f":"IF(S26=0,\"N/A\",P26)","v":"Answer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(MAX((R22:R26>=Threshold)*A22:A26))=0, 1, SUMPRODUCT(MAX((R22:R26>=Threshold)*A22:A26)))","v":1}]
[null,"Comments:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Progress:",{"$f":"SUMPRODUCT((S10:S26)*(P10:P26<>\"Answer\"))/COUNTIF(S10:S26, 1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score:",{"$f":"IF(COUNTIF(T10:T26, \"Answer\")>0, \"N/A\", VLOOKUP($A$8,Configuration!$A$7:$D$27,4,FALSE)*P15+VLOOKUP($A$20,Configuration!$A$7:$D$27,4,FALSE)*P27)","v":"N/A"}]

{"sheet":"Results","index":9,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,13,25,13],[18,10,25,10],[18,11,25,11],[18,12,25,12],[17,10,17,14],[18,14,25,14],[4,1,4,14],[8,10,11,10],[6,10,6,14],[8,12,11,12],[8,11,11,11],[8,13,11,13],[8,14,11,14]]}
[]
[]
[]
[]
[null,"Results"]
[]
[null,null,null,"Overall Maturity Level",null,null,null,null,null,null,"Maturity Level Definitions"]
[null,null,null,{"$f":"IF(COUNTIF(C12:C16, \"<1\")>0, \"You have not completed every element\", F12)","v":"You have not completed every element"},null,null,null,null,null,null,"1-Initial","2-Developing","3-Defined","4-Functioning","5-Sustained"]
[null,null,null,null,null,null,null,null,null,null,"Ad-Hoc and event driven, success due to heroic efforts of individuals","Recognized need for improvement, pilot initiatives underway","Defined & documented processes not yet stabilized or widely socialized","Implemented processes - operating and adding value","Evaluated & improved processes, sustained over time"]
[]
[null,null,"Progress","Results","Weight","Overall Result"]
[null,"Data Strategy and Governance",{"$f":"'1. Data Strategy & Governance'!T71","v":0},{"$f":"IF('1. Data Strategy & Governance'!T73=\"N/A\",0,'1. Data Strategy & Governance'!T73)","v":0},{"$f":"Configuration!E9","v":0.2},{"$f":"ROUND(SUMPRODUCT(D12:D16,E12:E16),1)","v":0}]
[null,"Data Life Cycle Management",{"$f":"'2. Data Life Cycle Management'!S80","v":0},{"$f":"IF('2. Data Life Cycle Management'!S82=\"N/A\",0,'2. Data Life Cycle Management'!S82)","v":0},{"$f":"Configuration!E14","v":0.2}]
[null,"Data Architecture and Integration",{"$f":"'3. Data Arch. & Integration'!T56","v":0},{"$f":"IF('3. Data Arch. & Integration'!T58=\"N/A\",0,'3. Data Arch. & Integration'!T58)","v":0},{"$f":"Configuration!E20","v":0.2}]
[null,"Data Collaboration",{"$f":"'4. Data Collaboration'!T31","v":0},{"$f":"IF('4. Data Collaboration'!T33=\"N/A\",0,'4. Data Collaboration'!T33)","v":0},{"$f":"Configuration!E24","v":0.2}]
[null,"Data Quality",{"$f":"'5. Data Quality'!P32","v":0},{"$f":"IF('5. Data Quality'!P34=\"N/A\",0,'5. Data Quality'!P34)","v":0},{"$f":"Configuration!E26","v":0.2}]
[]
[null,null,null,null,null,null,null,null,null,null,"Activities to Advance to the Next Level"]
[null,null,null,null,null,null,null,null,null,null,"Build awareness - assess risks, understand peer activities, identify priorities, select first set of initiatives","Develop action plans and roadmaps, establish metrics and milestones, test and document new processes","Strengthen governance. Improve change management. Spread awareness of successes throughout organization. Strengthen processes via new tools and techniques like data and process mapping.","Formalize evaluation and improvement processes. Build succession plans. Formalize responsibilities within position descriptions. Build external expectations."]