{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["1. Data Strategy & Governance","2. Data Life Cycle Management","3. Data Arch. & Integration","4. Data Collaboration","5. Data Quality","Calculations","Assessment Summary","Radar Chart","Improvement Identification","Action Planning","Validation Lists","Individual Summary","Individual Notes"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Radar Chart","index":7,"reason":"not_a_worksheet"}],"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":"1. Data Strategy & Governance","index":0,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[[27,1,27,4],[15,1,15,4],[3,1,3,4],[16,1,17,1],[16,3,17,3],[16,4,17,4],[1,1,1,4],[2,1,2,4],[4,1,5,1],[4,3,5,3],[4,4,5,4],[64,1,65,1],[52,1,53,1],[52,3,53,3],[52,4,53,4],[28,1,29,1],[28,3,29,3],[28,4,29,4],[40,1,41,1],[40,3,41,3],[40,4,41,4],[63,1,63,4],[51,1,51,4],[39,1,39,4],[42,7,46,7],[54,7,58,7],[66,7,70,7],[64,3,65,3],[64,4,65,4],[52,5,53,5],[52,6,53,6],[64,5,65,5],[64,6,65,6],[18,8,22,8],[18,9,22,9],[6,7,10,7],[18,7,22,7],[30,7,34,7],[28,8,29,8],[28,9,29,9],[30,8,34,8],[30,9,34,9],[4,8,5,8],[6,8,10,8],[4,9,5,9],[6,9,10,9],[16,8,17,8],[16,9,17,9],[40,8,41,8],[40,9,41,9],[64,8,65,8],[64,9,65,9],[66,8,70,8],[66,9,70,9],[42,8,46,8],[42,9,46,9],[52,8,53,8],[52,9,53,9],[54,8,58,8],[54,9,58,9],[3,5,3,6],[15,5,15,6],[27,5,27,6],[63,5,63,6],[51,5,51,6],[39,5,39,6],[4,5,5,5],[4,6,5,6],[16,5,17,5],[16,6,17,6],[28,5,29,5],[28,6,29,6],[40,5,41,5],[40,6,41,6]]}
[]
[null,"1. Data Strategy and Governance - Agency Level Evaluation"]
[null,"Leadership and management practices to manage data as a strategic agency asset."]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"1.1.","Strategy and Direction","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Leadership commitment and strategic planning to maximize value of data to meet agency goals. This sub-element looks at the extent to which the agency leadership has demonstrated a commitment to managing data as a strategic asset through establishment of data governance structures, communications, and planning activities to ensure alignment between data investments and business needs."]
[null,"1.1.1","Data collection and management is performed by individual business units with little or no agency-wide direction or coordination. Data improvements are not systematically or regularly identified - they are implemented on a reactive or opportunistic basis.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"1.1.2","Efforts to implement agency-wide data governance or assess agency-wide data needs are being discussed or planned. Data improvement needs are identified and communicated to management in an informal manner.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"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,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"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,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"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,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments:"]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"1.2.","Roles and Accountability","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Clear roles, accountability and decision making authority for data quality, value and appropriate use. This sub-element assesses the extent to which roles and accountability for data stewardship have been agreed-upon, defined, documented and assigned to individuals."]
[null,"1.2.1","The agency has not recognized the need to formalize accountability for the quality, value, and appropriate use of data.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"1.2.2","The agency recognizes the need to establish formal accountability for the quality, value, and appropriate use of data but accountability has not yet been formalized:\n• Leads or point people for major data sets or applications may be designated but specific data stewardship responsibilities have not yet been spelled out.\n• Early efforts to establish data governance bodies may be underway but groups are not yet chartered.   ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"1.2.3","The agency has established clear decision authority and responsibilities for data governance and stewardship – as evidenced by one or more of the following: \n• An agency-wide data governance body is established with an adopted charter \n• Data stewardship role(s) have been designated for priority data programs or data subject categories\n• Decision 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\n• Capabilities and skills for data management are included in staff position descriptions, agency recruiting and staff development efforts",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"1.2.4","Agency-wide data governance bodies and/or staff with data stewardship responsibilities are appropriately resourced and trained to carry out defined responsibilities and are active and achieving results recognized as valuable. \nThe agency is also successfully identifying and resolving situations where individual business unit interests are in conflict with agency-wide interests related to data collection and management.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"1.2.5","The roles and responsibilities of agency data governance bodies and/or staff with data stewardship responsibilities are reviewed periodically and updated based on agency experience and to reflect new or changing data requirements and implementation of new data systems.\nStaff with responsibility for data stewardship and management coordinate with their peers in the agency and with external data partners to deliver best value for resources invested (for example, as incentivized by data management-related metrics included in employee performance reviews).",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments:"]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"1.3.","Policies and Processes","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Adoption of principles, policies and business processes for managing data as a strategic agency asset. This sub-element looks at the extent to which the agency has established clear policies and procedures about how data is to be managed as a corporate asset. "]
[null,"1.3.1","No formal data strategic goals, objectives, principles, policies or procedures have been established.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"1.3.2","Agency leadership has endorsed basic strategic goals, objectives and/or principles for data management.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"1.3.3","Basic data policies and processes are in place, including one or more of the following:\n• Policies defining the scope of agency data governance\n• Processes for approving new data collection or reporting initiatives to ensure coordination and minimize duplication\n• Policies defining requirements for data documentation or quality management\n• Policies establishing data standards",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"1.3.4","A comprehensive set of data management policies have been successfully implemented, monitored, and supported.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"1.3.5","Policies are regularly evaluated and improved.  Policy reviews and update decisions consider factors such as awareness/reach within the agency, effectiveness and cost burden.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments:"]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"1.4.","Data Asset Inventory and Value","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Tracking of agency data assets and their value added.  This sub-element looks at the extent to which the agency or data program manager has documented their data, its uses and its value to the agency."]
[null,"1.4.1","Data sets of agency-wide importance have not been identified or documented (though there may be some business-area specific or data set-level inventories).",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"1.4.2","A basic inventory of data sets of agency-wide importance has been compiled with limited information such as business contact, technical contact, location, and description.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"1.4.3","An inventory of data sets of agency-wide importance is available to agency staff.\nInformation about the value of each data set of agency-wide importance is available, including one or more of the following:\n• Primary users of the data\n• Descriptions of how the data is used\n• References to statutory requirements for the data\n• Data acquisition/collection and  storage/management costs",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"1.4.4","Information about agency data sets is regularly updated as new data sets are added and old data sets are retired. \nThe data inventory information is used to identify duplicative data sets that can be eliminated or consolidated.\nManagers use information about data costs to evaluate opportunities for improved efficiencies.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"1.4.5","There is a good understanding of the value provided by each data set with respect to agency efficiency and effectiveness. Data collection and management methods are regularly evaluated and improved.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments:"]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"1.5.","Relationship with Data Customers (Not Applicable for Agency Level Assessment)","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Connections between data producers and users"]
[null,"1.5.1","There are no proactive outreach activities to understand data user needs:"]
[null,"1.5.2","Informal, limited outreach to other business units has been conducted to identify how they might utilize available data sets."]
[null,"1.5.3","Meetings have been help with current or potential new users for our data to understand their needs. This information has been taken into account in developing plans for improvements:"]
[null,"1.5.4","Input from data customers is routinely solicited, collected and considered through a variety of online and in person forums (e.g. communities of interest):"]
[null,"1.5.5","There are formal, written agreements that document what data will be provided to customers, when and how: \nA process is in place to periodically renegotiate these agreements:"]
[]
[null,"Comments:"]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"1.6.","Data Management Workforce Capabilities","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Attracting, building and sustaining a workforce with the knowledge, skills and abilities to meet changing data management and analysis requirements. This sub-element assesses the extent to which the agency workforce has the right mix of skills for effective data management, and the extent to which the agency is able to sustain needed skill sets through staff transitions."]
[null,"1.6.1","There is limited awareness of needs to build workforce capabilities for data management and analysis.\nThere is limited awareness of risks associated with loss of current data experts due to retirements or job changes. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"1.6.2","Workforce needs and risks associated with data management and analysis are generally recognized and understood but there is no coordinate strategy in place to address them. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"1.6.3","Strategies to address needs and mitigate risks have been identified and are being piloted through one or more of the following activities:\n• Revisions to position descriptions reflecting core data management and analysis competencies\n• Supporting staff development/training to build data literacy and data competencies\n• Targeted recruiting efforts\n• Succession planning and knowledge transfer for critical data-related positions",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"1.6.4","Strategies to address needs and mitigate risks are routinely and widely executed across the agency.\n Managers anticipate and plan for staffing requirements related to data management and analysis and ensure that work commitments are in line with available staff resources. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"1.6.5","Strategies to address needs and mitigate risks are routinely evaluated and improved based on prior experience and changing requirements.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments:"]
[null,"Improvements: "]

{"sheet":"2. Data Life Cycle Management","index":1,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[[64,1,65,1],[64,3,65,3],[64,4,65,4],[28,1,29,1],[28,3,29,3],[40,4,41,4],[52,1,53,1],[52,3,53,3],[52,4,53,4],[64,5,65,5],[64,6,65,6],[28,5,29,5],[28,6,29,6],[40,5,41,5],[40,6,41,6],[52,5,53,5],[52,6,53,6],[63,5,63,6],[51,5,51,6],[39,5,39,6],[3,5,3,6],[15,5,15,6],[27,1,27,4],[15,1,15,4],[3,1,3,4],[4,5,5,5],[4,6,5,6],[16,5,17,5],[16,6,17,6],[16,1,17,1],[4,3,5,3],[4,4,5,4],[16,3,17,3],[16,4,17,4],[4,1,5,1],[27,5,27,6],[1,1,1,4],[2,1,2,4],[63,1,63,4],[51,1,51,4],[39,1,39,4],[28,4,29,4],[40,1,41,1],[40,3,41,3],[66,7,70,7],[6,7,10,7],[18,7,22,7],[30,7,34,7],[42,7,46,7],[54,7,58,7],[4,8,5,8],[4,9,5,9],[6,8,10,8],[6,9,10,9],[16,8,17,8],[16,9,17,9],[18,8,22,8],[18,9,22,9],[28,8,29,8],[28,9,29,9],[30,8,34,8],[30,9,34,9],[40,9,41,9],[42,8,46,8],[42,9,46,9],[52,8,53,8],[52,9,53,9],[40,8,41,8],[54,9,58,9],[64,8,65,8],[64,9,65,9],[66,8,70,8],[66,9,70,9],[54,8,58,8]]}
[]
[null,"2. Data Life Cycle Management - Agency Level Evaluation"]
[null,"Practices for managing data throughout its life cycle from collection to archiving or deletion."]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"2.1.","Data Collection and Updating","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Well-defined and coordinated data update cycles. This sub-element assesses the extent to which update methods and cycles have been defined and documented for key data sets."]
[null,"2.1.1","Data collection and updating cycles and business rules for enterprise data updates have not been established.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"2.1.2","Enterprise data collection and updating cycles have been established but have not been documented.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"2.1.3","Agency expectations for data updating processes have been established and documented, including one or more of the following:\n• Establishment of updating cycles based on data user needs/requirements\n• Documentation of data collection and preparation processes\n• Documentation of updating cycles\n• Periodic review and improvement to data collection/updating methods \n• Definition of business rules for how key data entities are added, updated and deleted",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"2.1.4","Agency expectations for data updating processes are generally understood and consistently followed. followed. \nBusiness rules for data updating are generally embedded in and enforced by applications (where applicable).",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"2.1.5","Agency expectations for data updating are periodically reviewed, updated, and implemented.\nEnterprise data collection and data updating methods and cycles are also periodically reviewed to identify and implement opportunities for improved coordination and efficiencies.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"2.2.","Data Access Control","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Well-defined policies and guidelines for managing access to data sets.  This sub-element assesses the extent to which the agency manages access to data sets in order to protect sensitive information and maintain data integrity."]
[null,"2.2.1","No agency policies or guidelines regarding data sharing or access management are in place beyond external agency requirements (e.g. state-level policy, legislative/regulatory requirements).",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"2.2.2","The agency is beginning to address risks associated with unauthorized access to data and sharing of sensitive data through one or more of the following activities:\n• Discussion of these risks at management and staff meetings\n• Coverage of data risk topics in staff onboarding or IT training\n• Documentation of agency data types and elements that need to be protected\n• Application of state-level data security classifications to agency datasets\n• Establishing a review process for external data requests",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"2.2.3","Standard policy, practices, and guidance have been developed to identify and protect sensitive data, and define how data can be shared externally to the agency. However, these have not yet been fully implemented.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"2.2.4","Standard policy, practice, and guidance are implemented.  Enterprise data sets have been classified for purposes of data protection and access and data owners/providers/stewards are complying with policies and guidelines for data protection and access.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"2.2.5","Data access and protection guidelines and procedures are well established, and are periodically reviewed and updated as part of standard practice.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"2.3.","Data Findability and Documentation","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Availability of data catalogs and dictionaries that enable discovery and understanding of available agency data assets.  This sub-element assesses the extent to which the agency ensures that potential data users can discover what data are available and understand potential applicability of a data set for a given business need."]
[null,"2.3.1","There is little or no recognition of the need or value of a data inventory, catalog or standardized metadata to support data findability. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"2.3.2","Efforts are underway to improve the ability of agency staff to find available data through one or more of the following activities:\n• Creation of web pages with links to commonly requested data\n• Compilation of a data inventory or catalog\n• Review and recommendation of metadata standards for adoption",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"2.3.3","Standards and templates for data documentation are defined and one or more of the following efforts is underway:  \n• Creation of an agency-wide data inventory or data catalog \n• Creation of standard metadata for priority agency data sets\n• Preparation of documentation describing data collection, updating and reporting cycles for priority agency data sets\n• Creation or compilation of standard data dictionary information for priority agency data sets\n• Establishment of data subject categories or other tags to be used for categorization of agency data sets to help users identify and find data of interest. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"2.3.4","Standards and templates for data documentation are actively used and this documentation is kept up-to-date.  \nQuality assurance processes are in place to ensure this documentation is complete and useful. \nProcesses are in place to update catalogs and documentation when data sets are added, modified or discontinued.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"2.3.5","The agency periodically evaluates opportunities to refine its approach to data documentation based on user needs, and feedback, new technologies and research into best practices.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"2.4.","Data Backups and Archiving","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Guidelines and procedures for protection and long term preservation of data assets.  This sub-element assesses the extent to which active data sets are backed up, and inactive data sets are archived for future use as needed. "]
[null,"2.4.1","Data protection policies and procedures have not been specified or consistently implemented, as evidenced by one or more of the following:\n• There are no documented standard policies or procedures related to backing up and archiving agency data. \n• Backups may occur, but business data managers are not made aware of what data is backed up and when.\n• Many (more than 10) data sets of agencywide value (e.g., business-critical, used for external reporting) are managed within desktop applications (rather than in enterprise databases).",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"2.4.2","Selected data protection policies and procedures are into place, as evidenced by one or more of the following:\n• Data managed in enterprise databases and stored on enterprise servers is regularly backed up but backup policies and procedures have not been formalized or documented.\n• Backups are not regularly tested to verify that data can be successfully restored.\n• Business data managers are not engaged in decisions about what backup and archiving strategies would best meet business needs.                                                                                                                                                                                             \n• Several (5-10) data sets of agencywide value are managed within desktop applications (rather than in enterprise databases).\n• Archives of data are created on request, but there are no written procedures on how to create these and how to retrieve them.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"2.4.3","Basic data protection policies and procedures are in place, as evidenced by the following:\n• Data managed in enterprise databases and stored on enterprise servers is regularly backed up and written policies are in place on backup frequency, storage locations, data archival and retrieval\n• Backups are periodically tested to ensure that data can be successfully recovered, but these tests do not generally involve examination of the data by business data owners or stewards\n• Very few (less than 5) datasets of agencywide value are managed within desktop applications (rather than in enterprise applications) ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"2.4.4","Mature data protection policies and procedures are in place, as evidenced by the following:\n• Backup and archiving policies and procedures are consistently followed and well-understood by both technical staff and business data managers/stewards.\n• Backups are periodically tested to ensure that data can be successfully recovered, and business owners or stewards are engaged to verify that the data recovery was successful. \n• No datasets of agencywide value are managed within desktop applications (rather than in enterprise applications) The agency's enterprise data sets are managed within enterprise databases\n• Policies are consistently followed and are tested to meet business needs.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"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,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"2.5.","Data Change Management","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Processes to minimize unanticipated downstream impacts of data changes. This sub-element assesses the extent to which procedures are in place to manage the process of making changes to data structures in one data set or system that may impact other systems or reports."]
[null,"2.5.1","There are no documented agency-wide best practices or guidelines for analyzing how changes to data structures, definitions or unique identifiers in one system may impact reports or other dependent systems.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"2.5.2","The agency recognizes the need for agency-wide data management policy and guidance, and these are under development.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"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,{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"2.5.4","Change management processes are in place and functioning as intended.  These processes are supported by integrated and/or automated analysis and tools, as evidenced by one or more of the following:\n• Use of a meta data repository or other tool to conduct change impact analysis - i.e. identification of which systems and database tables contain a particular data element; or \n• Use of automated processes to manage changes to code lists and propagate these changes to various business systems; or\n• Use of automated processes to manage additions, deletions and changes to master data entities.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"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,{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B53,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"2.6.","Data Delivery","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Delivery of data to users in a variety of convenient, useful and usable forms.  This sub-element assesses the extent to which data are delivered to end users in convenient forms that are suited to best meet business needs."]
[null,"2.6.1","The agency has not pursued creating centralized data access, analysis, and reporting capabilities.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"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, however data reporting is typically accomplished in a decentralized fashion. Ad-hoc query tools may be available but are not widely used. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"2.6.3","The agency has implemented enterprise solutions for data access, reporting, visualization and analysis (e.g., data warehouse, data marts, dashboards) to meet common needs across business units. These may include one or more of the following:\n• An integrated pool of data in a form suitable for reporting and analysis\n• Options to access both “live” data and “frozen” or “snapshot” data to meet different business needs\n• A common map-based interface that allows view and analysis of a variety of information such as pavement condition, bridge condition, crashes, traffic counts, programmed projects, and completed projects.\n• A standard approach to accessing agency data from mobile devices.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"2.6.4","The agency has implemented enterprise data self-service solutions, to allow employees to access, analyze and report data to their meet specific needs.  Example capabilities include that the agency has the expertise and tools to:\n• 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.\n• Combine data sets that are based on different road sections (e.g. 10th mile sections for pavement information and 2 mile sections for AADT).\n• Easily visualize trend information for asset condition, capital and maintenance expenditures, traffic, crash rates, and other important agency performance indicators.\n• Access information about assets, projects, or work orders on mobile devices and from remote field offices.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"2.6.5","Data are made available through a variety of formats and platforms (GIS portal, mobile devices, dashboards, etc.) to meet identified business requirements.\nBusiness needs for access to both \"live\" data and \"frozen\" or \"snapshot\" data have been addressed.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B65,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]

{"sheet":"3. Data Arch. & Integration","index":2,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[39,1,39,4],[27,1,27,4],[15,1,15,4],[1,1,1,4],[2,1,2,4],[4,1,5,1],[4,3,5,3],[4,4,5,4],[3,1,3,4],[42,7,46,7],[30,7,34,7],[18,7,22,7],[6,7,10,7],[28,1,29,1],[28,3,29,3],[28,4,29,4],[40,1,41,1],[40,3,41,3],[40,4,41,4],[16,1,17,1],[16,3,17,3],[16,4,17,4],[40,5,41,5],[40,6,41,6],[16,5,17,5],[4,9,5,9],[6,8,10,8],[6,9,10,9],[16,8,17,8],[16,9,17,9],[40,9,41,9],[42,8,46,8],[42,9,46,9],[18,8,22,8],[18,9,22,9],[28,8,29,8],[28,9,29,9],[30,8,34,8],[30,9,34,9],[3,5,3,6],[15,5,15,6],[27,5,27,6],[39,5,39,6],[40,8,41,8],[4,8,5,8],[4,5,5,5],[4,6,5,6],[16,6,17,6],[28,5,29,5],[28,6,29,6]]}
[]
[null,"3. Data Architecture and Integration - Agency Level Evaluation"]
[null,"Technical standards, processes, tools and coordination mechanisms to maximize data integration and minimize duplication."]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"3.1.","Location Referencing","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Common location referencing methods across agency data sets. This sub-element assesses the extent to which the agency has standardized methods for location referencing, including linear referencing for its road-related data sets."]
[null,"3.1.1","The agency has not pursued creating a standard linear referencing system (LRS) for agency data.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"3.1.2","The agency is working towards establishing a standard LRS.  However most data sets including location elements cannot be easily and accurately integrated with other agency data sets.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"3.1.3","The agency has developed an agency standard LRS and is pursuing one or more of the following implementation steps:\n• Development of LRS quality standards in consultation with a variety of business units;\n• Creation of standard processes for propagating changes in the LRS to various agency data sets; \n• Establishment of requirements for use of the agency LRS in collection of location elements of new datasets.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"3.1.4","The agency has implemented a standard LRS, as evidenced by one or more of the following:\n• The LRS has been implemented in most enterprise data systems and collections that include location, either by direct use of the standard LRS or with defined processes to translate locations to the agency standard LRS.  \n• The quality of the LRS is regularly assessed and reported\n• Standard methods are in place and functioning to propagate LRS changes resulting from road network changes to business data sets\n• Standard methods are in place to translate between coordinate-based location referencing (e.g. latitude/longitude) and linear referencing (e.g. route-milepoint)",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"3.1.5","The agency has an advanced and adaptable location referencing approach, as evidenced by one or more of the following:\n• A standard architecture for linking agency GIS and LRS data to business data systems, resulting in easy, efficient integration of new data or systems with the agency location referencing system\n• Automated methods for propagating changes in location referencing resulting from road network changes.\n• Regular assessment and improvement of the LRS, related tools, and techniques for their application and integration.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"3.2.","Geospatial Data Management","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Standardized approach to collection and management of geospatial data. This sub-element assesses the extent to which the agency has a standard approach to collection, management and integration of spatial data."]
[null,"3.2.1","The agency does not provide enterprise-wide planning and support for management and integration of geospatial data.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"3.2.2","The agency has designated responsibilities for enterprise-wide planning and support for managing geospatial data. The agency manages a collection of spatial data sets and makes them available for internal use.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"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.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"3.2.4","Agency geospatial data policies, standards, and guidance are well-understood and put into practice.  For example, the agency has:\n• Functioning processes for collecting, adding and updating geospatial data sets;\n• Standard approaches to assigning spatial location to key data entities (e.g. construction projects, assets); and\n• Training 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,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"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,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"3.3.","Data Consistency and Integration","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[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.  This sub-element assesses the extent to the agency manages database creation and application development processes in order to minimize duplication and ensure integration."]
[null,"3.3.1","The agency has not pursued planning for data integration/linkage across business applications outside of the context of individual application development projects.\nCommon code lists for use across applications have not been developed.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"3.3.2","The agency has recognized the need to plan for data integration and linkage across business applications (outside of individual, project-level efforts).  Enterprise planning efforts are underway, including one or more of the following activities:\n• Identify key integration points across data sets\n• Identify data duplication and inconsistencies across sources\n• Standardized code lists across applications (e.g. city/county codes, organizational unit codes).",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"3.3.3","The agency has begun to implement practices to ensure linkages across data sets and use of consistent coding, as evidenced by one or more of the following:\n• One or more skilled individuals with responsibility for data architecture and integration across systems.\n• Identification of master data entities (e.g. projects, roadway segments, bridges, employees) that are present in multiple business applications\n• Mapping of which physical systems contain information related to these the identified master data entities.\n• Creation of a list of common link fields (e.g. route ID, project ID) to integrate different data sets to provide answers to business questions of interest.\n• Creation of common code lists \nIdentification of authoritative source systems for key data elements of agency-wide interest. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"3.3.4","The agency has fully implemented practices to ensure linkages across data sets and use of consistent coding, as evidenced by one or more of the following:\n• Routine architectural reviews of application development/enhancement projects\n• Multiple database and application development projects that have leveraged common code lists and adhered to standards for linkage fields;\n• Inclusion of language in requirements for data/system procurements to  ensure adherence to established data standards \n• Use of designated authoritative source systems for reporting and analysis",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"3.3.5","The agency has defined a \"to be\" data and system architecture to guide system addition, replacement, consolidations and updates. Processes and tools for master data management and data standardization are periodically reviewed and refined to reduce data duplication and inconsistencies and maximize  data re-use. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"3.4.","Temporal Data Management","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[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.  This sub-element assess the extent to which requirements for standardizing temporal data elements are considered to ensure that data representing different time periods can be combined as needed to support analysis."]
[null,"3.4.1","There are no standards, guidelines, or strategies in place regarding date and time-related data elements.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"3.4.2","There is a recognition of the need for standards, guidelines, or strategies to define and standardize date and time-related data elements and there are some common approaches and conventions in place.  These may include:\n• Standard naming conventions and usage practices for distinguishing data collection dates, data loading or update dates, and data effective dates\n• Naming conventions and usage practices for distinguishing calendar years, state fiscal years and federal fiscal years, and integrating data sets using these different years",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"3.4.3","There are documented guidelines for ensuring consistency in use of date-and-time-related data elements across data sets and applications.\nThere are established methods for designing data sets to support trend analysis.\nThere are established methods for creating data snapshots representing a specific point in time and for integrating across data sets to create a snapshot-in-time view. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"3.4.4","There is consistent use of date-and-time related data elements across the agency datasets and applications. New use cases or requirements for temporal analysis, snapshots, or integration can be met without major changes to data structures or substantial new development effort.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"3.4.5","Data user requirements for trend analysis, snapshots and other uses of temporal information can be met through largely automated processes.  Agency temporal data requirements and related processes are periodically reassessed to identify opportunities for further improvement.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B41,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]

{"sheet":"4. Data Collaboration","index":3,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[15,1,15,4],[16,1,17,1],[16,3,17,3],[16,4,17,4],[30,7,34,7],[18,7,22,7],[28,1,29,1],[28,3,29,3],[28,4,29,4],[27,1,27,4],[16,5,17,5],[16,6,17,6],[28,5,29,5],[15,5,15,6],[27,5,27,6],[28,6,29,6],[6,7,10,7],[1,1,1,4],[2,1,2,4],[4,1,5,1],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[3,5,3,6],[3,1,3,4],[30,8,34,8],[30,9,34,9],[4,8,5,8],[4,9,5,9],[6,8,10,8],[6,9,10,9],[16,8,17,8],[16,9,17,9],[18,8,22,8],[18,9,22,9],[28,8,29,8],[28,9,29,9]]}
[]
[null,"4. Data Collaboration - Agency Level Evaluation"]
[null,"Internal and external collaboration to maximize data sharing and avoid duplication of effort."]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"4.1.","Internal Agency Collaboration","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Collaboration across agency business units to leverage opportunities for efficiencies in data collection and management.  This sub-element assesses the extent to which there is collaboration and coordination across different organizational units on data collection and management. "]
[null,"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,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"4.1.2","The agency is starting to identify cases of data duplication and discuss opportunities for coordinating data collection and management across business units (e.g., safety and asset management). ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"4.1.3","The agency has taken steps to reduce data duplication and take advantage of opportunities for data collaboration, as evidenced by one or more of the following: \n• A data collection effort involving coordination from more than one business unit has been completed (e.g. use of video imagery from pavement data collection to extract other asset data);\n• Information about existing data sources has been compiled and used to identify areas of duplication and opportunities for consolidation;\n• Guidance is in place for initiating new data collection efforts that encourages assessment of existing data and partnerships across business units to simultaneously address the needs of multiple units.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"4.1.4","Applicable policy and guidelines are being followed across the agency, resulting in routine, effective collaboration across agency business units to generate efficiencies in data collection and management.  For example:\n• Agency business data owners/stewards are encouraged and incentivized to share their data with a broader audience within the agency (where appropriate);\n• Agency business data owners/stewards 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;\n• There are regular initiatives to reduce data duplication.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"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 and the agency monitors progress of related efforts and initiatives.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"4.2.","External Collaboration","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Partnerships with external entities to share data and avoid duplication.  This sub-element assesses the extent to which the agency seeks out externally available data and develops data sharing arrangements and partnerships with external public and private sector entities."]
[null,"4.2.1","The agency is not proactively partnering with external entities for data sharing, though individual business units may be providing data on request to partner agencies and requesting or obtaining data from them to meet specific needs.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"4.2.2","Partnerships with other public and private sector organizations are being explored to share data on an ongoing basis.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"4.2.3","The agency is proactively identifying opportunities for partnering on data collection, data sharing, and data management and has some partnering arrangements in place.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"4.2.4","The agency has sustained partnerships with external entities involving regular update cycles.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"4.2.5","The agency routinely reassess its partnerships for continuous improvement.  This may involve one or more of the following:\n• Periodic review of data collection programs to identify opportunities to leverage externally available data sources\n• Documentation and dissemination of lessons learned to inform future partnering decisions and arrangements\n• Designates staff liaison responsibilities for managing and improving existing external partnerships",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"4.3.","External Data Sharing Policies and Guidance","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Policies and guidance for sharing agency data externally.  "]
[null,"4.3.1","The agency has not pursued establishing policies or guidelines about what data to make available to the public, or how to make it available to the public.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"4.3.2","The agency is in the process of establishing  policies or guidelines about what data to make available to the public, or how to make it available to the public.  ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"4.3.3","External data sharing policies are developed and in place.  Models and/or guidelines for external data sharing have been established.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"4.3.4","External data sharing policies are implemented, understood, and followed when sharing and/or publishing data for public use.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"4.3.5","The agency periodically seeks feedback from agency data producers, data managers, and external data users about its data sharing policies and practices and uses this feedback to guide improvements.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B29,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]

{"sheet":"5. Data Quality","index":4,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,4],[15,1,15,4],[6,7,10,7],[18,7,22,7],[1,1,1,4],[2,1,2,4],[4,1,5,1],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[16,5,17,5],[16,6,17,6],[16,1,17,1],[16,3,17,3],[16,4,17,4],[3,5,3,6],[15,5,15,6],[18,8,22,8],[18,9,22,9],[4,8,5,8],[4,9,5,9],[6,8,10,8],[6,9,10,9],[16,8,17,8],[16,9,17,9]]}
[]
[null,"5. Data Quality - Agency Level Evaluation"]
[null,"Standards and practices to ensure that data are of sufficient quality to meet user needs."]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"5.1.","Data Quality Measurement and Reporting","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Metrics and reporting to ensure user understanding of current data quality.  This sub-element assesses the extent to which data quality metrics have been defined and used to inform users about the level of currency, accuracy, coverage and completeness of a given data set.  (Note that data reliability is considered to be related to accuracy and is not distinguished here as a separate characteristic.  Data integrity, consistency and confidentiality are other important aspects of data quality that are considered as part of Assessment Elements 2 and 3.) "]
[null,"5.1.1","The agency has not pursued establishing  agency-wide policy and/or guidance related to data quality measurement and reporting. ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"5.1.2","The agency is in the process of establishing policy and/or guidance related to data quality measurement and reporting.  Some limited guidance and assistance may be available for specific purposes (e.g. to enable data integration, or to provide location).",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"5.1.3","Standard agency data quality metrics, verification techniques and/or reports have been defined.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"5.1.4","Standard data quality measurement and reporting policies and guidance have been adopted into the routine practices of the business.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"5.1.5","The agency proactively identifies new areas where common data quality metrics and reporting processes across data programs would be beneficial.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B5,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]
[]
[null,"NOTE: Based on what is most representative of current/desired performance, please select only ONE current and ONE desired state maturity level.",null,null,null,"Indiv. Response Summary"]
[null,"5.2.","Data Quality Assurance and Improvement","Consensus Current Level","Consensus Desired Level","Response Count Current Level","Response Count Desired Level",null,"Comments","Improvements"]
[null,null,"Practices for improving quality of existing data and assuring quality of newly acquired data.  This sub-element assesses the extent to which the agency pursues a systematic and proactive approach to data quality assurance and improvement."]
[null,"5.2.1","Data quality is assessed and improved in the context of individual data programs. No agency-wide support is provided.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"1.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"1.5\")","v":0}]
[null,"5.2.2","The agency recognizes the need for agency-wide data quality assurance and improvement policy, guidance, and support.  Limited technical assistance is available for data program managers or business units on fundamental data quality concepts and practices.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"2.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"2.5\")","v":0}]
[null,"5.2.3","The agency has established policy, guidelines, and support for data program managers or business units to apply data quality assurance and improvement practice.  These may include one or more of the following:\n• Policies that set expectations for minimum data quality management requirements\n• A data quality management plan template\n• A template for specifying data validation business rules \n• Guidance on data quality management best practices\n• Data profiling and validation tools ",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"3.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"3.5\")","v":0}]
[null,"5.2.4","Standard data quality assurance and improvement policies, practice, and support are adopted and implemented by the business, as evidenced by one or more of the following:\n• Technical support is provided for preparing data quality management plans or executing data validation and cleaning activities\n• Training is provided on data quality concepts and processes for data collectors, managers and stewards\n• Data validation business rules are routinely defined and provided for new data sets\n• Data collection activities integrate data quality best practices\n• Database and application development processes integrate data quality best practices\n• Integration of data quality best practices within data collection plans\n• Integration of data quality best practices within database and application development processes\n• Standard methods and tools are available for  gathering and tracking response to user feedback on quality issues",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"4.5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4\")+COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"4.5\")","v":0}]
[null,"5.2.5","The agency periodically reviews and refines its data quality assurance and improvement policies, guidelines, support programs and tools.",null,null,{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!D:D,\"5\")","v":0},{"$f":"COUNTIFS('Individual Summary'!A:A,$B17,'Individual Summary'!E:E,\"5\")","v":0}]
[]
[null,"Comments: "]
[null,"Improvements: "]

{"sheet":"Calculations","index":5,"n_rows":43,"n_cols":30,"rows_kept":43,"cut":false,"hidden":true,"merged":[[0,13,0,17],[0,25,0,29],[0,19,0,23],[0,7,0,11],[0,1,0,5]]}
[null,"1. Data Strategy and Governance",null,null,null,null,null,"2. Data Life Cycle Management",null,null,null,null,null,"3. Data Architecture and Integration",null,null,null,null,null,"4. Data Collaboration",null,null,null,null,null,"5. Data Quality"]
[null,null,null,"Current",null,"Desired",null,null,null,"Current",null,"Desired",null,null,null,"Current",null,"Desired",null,null,null,"Current",null,"Desired",null,null,null,"Current",null,"Desired"]
[null,"1.1.",{"$f":"AVERAGE(D4:D8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(C3,\"\")","v":""},{"$f":"AVERAGE(F4:F8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(E3,\"\")","v":""},null,"2.1.",{"$f":"AVERAGE(J4:J8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(I3,\"\")","v":""},{"$f":"AVERAGE(L4:L8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(K3,\"\")","v":""},null,"3.1.",{"$f":"AVERAGE(P4:P8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(O3,\"\")","v":""},{"$f":"AVERAGE(R4:R8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(Q3,\"\")","v":""},null,"4.1.",{"$f":"AVERAGE(V4:V8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(U3,\"\")","v":""},{"$f":"AVERAGE(X4:X8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(W3,\"\")","v":""},null,"5.1.",{"$f":"AVERAGE(AB4:AB8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(AA3,\"\")","v":""},{"$f":"AVERAGE(AD4:AD8)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(AC3,\"\")","v":""}]
[1,"1.1.1",false,{"$f":"IF(C4,A4,\"\")","v":""},false,{"$f":"IF(E4,A4,\"\")","v":""},1,"2.1.1",false,{"$f":"IF(I4,G4,\"\")","v":""},false,{"$f":"IF(K4,G4,\"\")","v":""},1,"3.1.1",false,{"$f":"IF(O4,M4,\"\")","v":""},false,{"$f":"IF(Q4,M4,\"\")","v":""},1,"4.1.1",false,{"$f":"IF(U4,S4,\"\")","v":""},false,{"$f":"IF(W4,S4,\"\")","v":""},1,"5.1.1",false,{"$f":"IF(AA4,Y4,\"\")","v":""},false,{"$f":"IF(AC4,Y4,\"\")","v":""}]
[2,"1.1.2",false,{"$f":"IF(C5,A5,\"\")","v":""},false,{"$f":"IF(E5,A5,\"\")","v":""},2,"2.1.2",false,{"$f":"IF(I5,G5,\"\")","v":""},false,{"$f":"IF(K5,G5,\"\")","v":""},2,"3.1.2",false,{"$f":"IF(O5,M5,\"\")","v":""},false,{"$f":"IF(Q5,M5,\"\")","v":""},2,"4.1.2",false,{"$f":"IF(U5,S5,\"\")","v":""},false,{"$f":"IF(W5,S5,\"\")","v":""},2,"1.1.2",false,{"$f":"IF(AA5,Y5,\"\")","v":""},false,{"$f":"IF(AC5,Y5,\"\")","v":""}]
[3,"1.1.3",false,{"$f":"IF(C6,A6,\"\")","v":""},false,{"$f":"IF(E6,A6,\"\")","v":""},3,"2.1.3",false,{"$f":"IF(I6,G6,\"\")","v":""},false,{"$f":"IF(K6,G6,\"\")","v":""},3,"3.1.3",false,{"$f":"IF(O6,M6,\"\")","v":""},false,{"$f":"IF(Q6,M6,\"\")","v":""},3,"4.1.3",false,{"$f":"IF(U6,S6,\"\")","v":""},false,{"$f":"IF(W6,S6,\"\")","v":""},3,"1.1.3",false,{"$f":"IF(AA6,Y6,\"\")","v":""},false,{"$f":"IF(AC6,Y6,\"\")","v":""}]
[4,"1.1.4",false,{"$f":"IF(C7,A7,\"\")","v":""},false,{"$f":"IF(E7,A7,\"\")","v":""},4,"2.1.4",false,{"$f":"IF(I7,G7,\"\")","v":""},false,{"$f":"IF(K7,G7,\"\")","v":""},4,"3.1.4",false,{"$f":"IF(O7,M7,\"\")","v":""},false,{"$f":"IF(Q7,M7,\"\")","v":""},4,"4.1.4",false,{"$f":"IF(U7,S7,\"\")","v":""},false,{"$f":"IF(W7,S7,\"\")","v":""},4,"1.1.4",false,{"$f":"IF(AA7,Y7,\"\")","v":""},false,{"$f":"IF(AC7,Y7,\"\")","v":""}]
[5,"1.1.5",false,{"$f":"IF(C8,A8,\"\")","v":""},false,{"$f":"IF(E8,A8,\"\")","v":""},5,"2.1.5",false,{"$f":"IF(I8,G8,\"\")","v":""},false,{"$f":"IF(K8,G8,\"\")","v":""},5,"3.1.5",false,{"$f":"IF(O8,M8,\"\")","v":""},false,{"$f":"IF(Q8,M8,\"\")","v":""},5,"4.1.5",false,{"$f":"IF(U8,S8,\"\")","v":""},false,{"$f":"IF(W8,S8,\"\")","v":""},5,"1.1.5",false,{"$f":"IF(AA8,Y8,\"\")","v":""},false,{"$f":"IF(AC8,Y8,\"\")","v":""}]
[]
[null,"1.2.",{"$f":"AVERAGE(D11:D15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(C10,\"\")","v":""},{"$f":"AVERAGE(F11:F15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(E10,\"\")","v":""},null,"2.2.",{"$f":"AVERAGE(J11:J15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(I10,\"\")","v":""},{"$f":"AVERAGE(L11:L15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(K10,\"\")","v":""},null,"3.2.",{"$f":"AVERAGE(P11:P15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(O10,\"\")","v":""},{"$f":"AVERAGE(R11:R15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(Q10,\"\")","v":""},null,"4.2.",{"$f":"AVERAGE(V11:V15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(U10,\"\")","v":""},{"$f":"AVERAGE(X11:X15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(W10,\"\")","v":""},null,"5.2.",{"$f":"AVERAGE(AB11:AB15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(AA10,\"\")","v":""},{"$f":"AVERAGE(AD11:AD15)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(AC10,\"\")","v":""}]
[1,"1.2.1",false,{"$f":"IF(C11,A11,\"\")","v":""},false,{"$f":"IF(E11,A11,\"\")","v":""},1,"2.2.1",false,{"$f":"IF(I11,G11,\"\")","v":""},false,{"$f":"IF(K11,G11,\"\")","v":""},1,"3.2.1",false,{"$f":"IF(O11,M11,\"\")","v":""},false,{"$f":"IF(Q11,M11,\"\")","v":""},1,"4.2.1",false,{"$f":"IF(U11,S11,\"\")","v":""},false,{"$f":"IF(W11,S11,\"\")","v":""},1,"5.2.1",false,{"$f":"IF(AA11,Y11,\"\")","v":""},false,{"$f":"IF(AC11,Y11,\"\")","v":""}]
[2,"1.2.2",false,{"$f":"IF(C12,A12,\"\")","v":""},false,{"$f":"IF(E12,A12,\"\")","v":""},2,"2.2.2",false,{"$f":"IF(I12,G12,\"\")","v":""},false,{"$f":"IF(K12,G12,\"\")","v":""},2,"3.2.2",false,{"$f":"IF(O12,M12,\"\")","v":""},false,{"$f":"IF(Q12,M12,\"\")","v":""},2,"4.2.2",false,{"$f":"IF(U12,S12,\"\")","v":""},false,{"$f":"IF(W12,S12,\"\")","v":""},2,"1.2.2",false,{"$f":"IF(AA12,Y12,\"\")","v":""},false,{"$f":"IF(AC12,Y12,\"\")","v":""}]
[3,"1.2.3",false,{"$f":"IF(C13,A13,\"\")","v":""},false,{"$f":"IF(E13,A13,\"\")","v":""},3,"2.2.3",false,{"$f":"IF(I13,G13,\"\")","v":""},false,{"$f":"IF(K13,G13,\"\")","v":""},3,"3.2.3",false,{"$f":"IF(O13,M13,\"\")","v":""},false,{"$f":"IF(Q13,M13,\"\")","v":""},3,"4.2.3",false,{"$f":"IF(U13,S13,\"\")","v":""},false,{"$f":"IF(W13,S13,\"\")","v":""},3,"1.2.3",false,{"$f":"IF(AA13,Y13,\"\")","v":""},false,{"$f":"IF(AC13,Y13,\"\")","v":""}]
[4,"1.2.4",false,{"$f":"IF(C14,A14,\"\")","v":""},false,{"$f":"IF(E14,A14,\"\")","v":""},4,"2.2.4",false,{"$f":"IF(I14,G14,\"\")","v":""},false,{"$f":"IF(K14,G14,\"\")","v":""},4,"3.2.4",false,{"$f":"IF(O14,M14,\"\")","v":""},false,{"$f":"IF(Q14,M14,\"\")","v":""},4,"4.2.4",false,{"$f":"IF(U14,S14,\"\")","v":""},false,{"$f":"IF(W14,S14,\"\")","v":""},4,"1.2.4",false,{"$f":"IF(AA14,Y14,\"\")","v":""},false,{"$f":"IF(AC14,Y14,\"\")","v":""}]
[5,"1.2.5",false,{"$f":"IF(C15,A15,\"\")","v":""},false,{"$f":"IF(E15,A15,\"\")","v":""},5,"2.2.5",false,{"$f":"IF(I15,G15,\"\")","v":""},false,{"$f":"IF(K15,G15,\"\")","v":""},5,"3.2.5",false,{"$f":"IF(O15,M15,\"\")","v":""},false,{"$f":"IF(Q15,M15,\"\")","v":""},5,"4.2.5",false,{"$f":"IF(U15,S15,\"\")","v":""},false,{"$f":"IF(W15,S15,\"\")","v":""},5,"1.2.5",false,{"$f":"IF(AA15,Y15,\"\")","v":""},false,{"$f":"IF(AC15,Y15,\"\")","v":""}]
[]
[null,"1.3.",{"$f":"AVERAGE(D18:D22)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(C17,\"\")","v":""},{"$f":"AVERAGE(F18:F22)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(E17,\"\")","v":""},null,"2.3.",{"$f":"AVERAGE(J18:J22)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(I17,\"\")","v":""},{"$f":"AVERAGE(L18:L22)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(K17,\"\")","v":""},null,"3.3.",{"$f":"AVERAGE(P18:P22)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(O17,\"\")","v":""},{"$f":"AVERAGE(R18:R22)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(Q17,\"\")","v":""},null,"4.3.",{"$f":"AVERAGE(V18:V22)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(U17,\"\")","v":""},{"$f":"AVERAGE(X18:X22)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(W17,\"\")","v":""}]
[1,"1.3.1",false,{"$f":"IF(C18,A18,\"\")","v":""},false,{"$f":"IF(E18,A18,\"\")","v":""},1,"2.3.1",false,{"$f":"IF(I18,G18,\"\")","v":""},false,{"$f":"IF(K18,G18,\"\")","v":""},1,"3.3.1",false,{"$f":"IF(O18,M18,\"\")","v":""},false,{"$f":"IF(Q18,M18,\"\")","v":""},1,"4.3.1",false,{"$f":"IF(U18,S18,\"\")","v":""},false,{"$f":"IF(W18,S18,\"\")","v":""}]
[2,"1.3.2",false,{"$f":"IF(C19,A19,\"\")","v":""},false,{"$f":"IF(E19,A19,\"\")","v":""},2,"2.3.2",false,{"$f":"IF(I19,G19,\"\")","v":""},false,{"$f":"IF(K19,G19,\"\")","v":""},2,"3.3.2",false,{"$f":"IF(O19,M19,\"\")","v":""},false,{"$f":"IF(Q19,M19,\"\")","v":""},2,"4.3.2",false,{"$f":"IF(U19,S19,\"\")","v":""},false,{"$f":"IF(W19,S19,\"\")","v":""}]
[3,"1.3.3",false,{"$f":"IF(C20,A20,\"\")","v":""},false,{"$f":"IF(E20,A20,\"\")","v":""},3,"2.3.3",false,{"$f":"IF(I20,G20,\"\")","v":""},false,{"$f":"IF(K20,G20,\"\")","v":""},3,"3.3.3",false,{"$f":"IF(O20,M20,\"\")","v":""},false,{"$f":"IF(Q20,M20,\"\")","v":""},3,"4.3.3",false,{"$f":"IF(U20,S20,\"\")","v":""},false,{"$f":"IF(W20,S20,\"\")","v":""}]
[4,"1.3.4",false,{"$f":"IF(C21,A21,\"\")","v":""},false,{"$f":"IF(E21,A21,\"\")","v":""},4,"2.3.4",false,{"$f":"IF(I21,G21,\"\")","v":""},false,{"$f":"IF(K21,G21,\"\")","v":""},4,"3.3.4",false,{"$f":"IF(O21,M21,\"\")","v":""},false,{"$f":"IF(Q21,M21,\"\")","v":""},4,"4.3.4",false,{"$f":"IF(U21,S21,\"\")","v":""},false,{"$f":"IF(W21,S21,\"\")","v":""}]
[5,"1.3.5",false,{"$f":"IF(C22,A22,\"\")","v":""},false,{"$f":"IF(E22,A22,\"\")","v":""},5,"2.3.5",false,{"$f":"IF(I22,G22,\"\")","v":""},false,{"$f":"IF(K22,G22,\"\")","v":""},5,"3.3.5",false,{"$f":"IF(O22,M22,\"\")","v":""},false,{"$f":"IF(Q22,M22,\"\")","v":""},5,"4.3.5",false,{"$f":"IF(U22,S22,\"\")","v":""},false,{"$f":"IF(W22,S22,\"\")","v":""}]
[]
[null,"1.4.",{"$f":"AVERAGE(D25:D29)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(C24,\"\")","v":""},{"$f":"AVERAGE(F25:F29)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(E24,\"\")","v":""},null,"2.4.",{"$f":"AVERAGE(J25:J29)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(I24,\"\")","v":""},{"$f":"AVERAGE(L25:L29)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(K24,\"\")","v":""},null,"3.4.",{"$f":"AVERAGE(P25:P29)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(O24,\"\")","v":""},{"$f":"AVERAGE(R25:R29)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(Q24,\"\")","v":""}]
[1,"1.4.1",false,{"$f":"IF(C25,A25,\"\")","v":""},false,{"$f":"IF(E25,A25,\"\")","v":""},1,"2.4.1",false,{"$f":"IF(I25,G25,\"\")","v":""},false,{"$f":"IF(K25,G25,\"\")","v":""},1,"3.4.1",false,{"$f":"IF(O25,M25,\"\")","v":""},false,{"$f":"IF(Q25,M25,\"\")","v":""}]
[2,"1.4.2",false,{"$f":"IF(C26,A26,\"\")","v":""},false,{"$f":"IF(E26,A26,\"\")","v":""},2,"2.4.2",false,{"$f":"IF(I26,G26,\"\")","v":""},false,{"$f":"IF(K26,G26,\"\")","v":""},2,"3.4.2",false,{"$f":"IF(O26,M26,\"\")","v":""},false,{"$f":"IF(Q26,M26,\"\")","v":""}]
[3,"1.4.3",false,{"$f":"IF(C27,A27,\"\")","v":""},false,{"$f":"IF(E27,A27,\"\")","v":""},3,"2.4.3",false,{"$f":"IF(I27,G27,\"\")","v":""},false,{"$f":"IF(K27,G27,\"\")","v":""},3,"3.4.3",false,{"$f":"IF(O27,M27,\"\")","v":""},false,{"$f":"IF(Q27,M27,\"\")","v":""}]
[4,"1.4.4",false,{"$f":"IF(C28,A28,\"\")","v":""},false,{"$f":"IF(E28,A28,\"\")","v":""},4,"2.4.4",false,{"$f":"IF(I28,G28,\"\")","v":""},false,{"$f":"IF(K28,G28,\"\")","v":""},4,"3.4.4",false,{"$f":"IF(O28,M28,\"\")","v":""},false,{"$f":"IF(Q28,M28,\"\")","v":""}]
[5,"1.4.5",false,{"$f":"IF(C29,A29,\"\")","v":""},false,{"$f":"IF(E29,A29,\"\")","v":""},5,"2.4.5",false,{"$f":"IF(I29,G29,\"\")","v":""},false,{"$f":"IF(K29,G29,\"\")","v":""},5,"3.4.5",false,{"$f":"IF(O29,M29,\"\")","v":""},false,{"$f":"IF(Q29,M29,\"\")","v":""}]
[]
[null,"1.5.",{"$f":"AVERAGE(D32:D36)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(C31,\"\")","v":""},{"$f":"AVERAGE(F32:F36)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(E31,\"\")","v":""},null,"2.5.",{"$f":"AVERAGE(J32:J36)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(I31,\"\")","v":""},{"$f":"AVERAGE(L32:L36)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(K31,\"\")","v":""}]
[1,"1.5.1",false,{"$f":"IF(C32,A32,\"\")","v":""},false,{"$f":"IF(E32,A32,\"\")","v":""},1,"2.5.1",false,{"$f":"IF(I32,G32,\"\")","v":""},false,{"$f":"IF(K32,G32,\"\")","v":""}]
[2,"1.5.2",false,{"$f":"IF(C33,A33,\"\")","v":""},false,{"$f":"IF(E33,A33,\"\")","v":""},2,"2.5.2",false,{"$f":"IF(I33,G33,\"\")","v":""},false,{"$f":"IF(K33,G33,\"\")","v":""}]
[3,"1.5.3",false,{"$f":"IF(C34,A34,\"\")","v":""},false,{"$f":"IF(E34,A34,\"\")","v":""},3,"2.5.3",false,{"$f":"IF(I34,G34,\"\")","v":""},false,{"$f":"IF(K34,G34,\"\")","v":""}]
[4,"1.5.4",false,{"$f":"IF(C35,A35,\"\")","v":""},false,{"$f":"IF(E35,A35,\"\")","v":""},4,"2.5.4",false,{"$f":"IF(I35,G35,\"\")","v":""},false,{"$f":"IF(K35,G35,\"\")","v":""}]
[5,"1.5.5",false,{"$f":"IF(C36,A36,\"\")","v":""},false,{"$f":"IF(E36,A36,\"\")","v":""},5,"2.5.5",false,{"$f":"IF(I36,G36,\"\")","v":""},false,{"$f":"IF(K36,G36,\"\")","v":""}]
[]
[null,"1.6.",{"$f":"AVERAGE(D39:D43)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(C38,\"\")","v":""},{"$f":"AVERAGE(F39:F43)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(E38,\"\")","v":""},null,"2.6.",{"$f":"AVERAGE(J39:J43)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(I38,\"\")","v":""},{"$f":"AVERAGE(L39:L43)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(K38,\"\")","v":""}]
[1,"1.6.1",false,{"$f":"IF(C39,A39,\"\")","v":""},false,{"$f":"IF(E39,A39,\"\")","v":""},1,"2.6.1",false,{"$f":"IF(I39,G39,\"\")","v":""},false,{"$f":"IF(K39,G39,\"\")","v":""}]
[2,"1.6.2",false,{"$f":"IF(C40,A40,\"\")","v":""},false,{"$f":"IF(E40,A40,\"\")","v":""},2,"2.6.2",false,{"$f":"IF(I40,G40,\"\")","v":""},false,{"$f":"IF(K40,G40,\"\")","v":""}]
[3,"1.6.3",false,{"$f":"IF(C41,A41,\"\")","v":""},false,{"$f":"IF(E41,A41,\"\")","v":""},3,"2.6.3",false,{"$f":"IF(I41,G41,\"\")","v":""},false,{"$f":"IF(K41,G41,\"\")","v":""}]
[4,"1.6.4",false,{"$f":"IF(C42,A42,\"\")","v":""},false,{"$f":"IF(E42,A42,\"\")","v":""},4,"2.6.4",false,{"$f":"IF(I42,G42,\"\")","v":""},false,{"$f":"IF(K42,G42,\"\")","v":""}]
[5,"1.6.5",false,{"$f":"IF(C43,A43,\"\")","v":""},false,{"$f":"IF(E43,A43,\"\")","v":""},5,"2.6.5",false,{"$f":"IF(I43,G43,\"\")","v":""},false,{"$f":"IF(K43,G43,\"\")","v":""}]

{"sheet":"Assessment Summary","index":6,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,4,2,5],[2,1,2,3],[27,1,27,3]]}
[]
[null,null,"Consensus Assessment"]
[null,"Assessment Areas"]
[null,"ID","Element","Sub-Element","Consensus Current Level","Consensus Desired Level"]
[null,"1.1.","Data Strategy and Governance","Strategy and Direction",{"$f":"Calculations!D3","v":""},{"$f":"Calculations!F3","v":""}]
[null,"1.2.","Data Strategy and Governance","Roles and Accountability",{"$f":"Calculations!D10","v":""},{"$f":"Calculations!F10","v":""}]
[null,"1.3.","Data Strategy and Governance","Policies and Processes",{"$f":"Calculations!D17","v":""},{"$f":"Calculations!F17","v":""}]
[null,"1.4.","Data Strategy and Governance","Data Asset Inventory and Value",{"$f":"Calculations!D24","v":""},{"$f":"Calculations!F24","v":""}]
[null,"1.5.","Data Strategy and Governance","Relationships and Data Customers",{"$f":"Calculations!D31","v":""},{"$f":"Calculations!F31","v":""}]
[null,"1.6.","Data Strategy and Governance","Data Man. Sustainability",{"$f":"IF(Calculations!D38=\"\",\"\",Calculations!D38)","v":""},{"$f":"Calculations!F38","v":""}]
[null,"2.1.","Data Life Cycle Management","Data Updating",{"$f":"IF(Calculations!J3=\"\",\"\",Calculations!J3)","v":""},{"$f":"Calculations!L3","v":""}]
[null,"2.2.","Data Life Cycle Management","Access Control",{"$f":"Calculations!J10","v":""},{"$f":"Calculations!L10","v":""}]
[null,"2.3.","Data Life Cycle Management","Data Findability and Doc'n",{"$f":"Calculations!J17","v":""},{"$f":"Calculations!L17","v":""}]
[null,"2.4.","Data Life Cycle Management","Data Backups and Archiving",{"$f":"Calculations!J24","v":""},{"$f":"Calculations!L24","v":""}]
[null,"2.5.","Data Life Cycle Management","Data Change Man.",{"$f":"Calculations!J31","v":""},{"$f":"Calculations!L31","v":""}]
[null,"2.6.","Data Life Cycle Management","Data Delivery",{"$f":"Calculations!J38","v":""},{"$f":"Calculations!L38","v":""}]
[null,"3.1.","Data Architecture and Integration","Loc. Referencing",{"$f":"Calculations!P3","v":""},{"$f":"Calculations!R3","v":""}]
[null,"3.2.","Data Architecture and Integration","Geospatial Data Man.",{"$f":"Calculations!P10","v":""},{"$f":"Calculations!R10","v":""}]
[null,"3.3.","Data Architecture and Integration","Data Consistency and Integration",{"$f":"Calculations!P17","v":""},{"$f":"Calculations!R17","v":""}]
[null,"3.4.","Data Architecture and Integration","Temporal Data Man.",{"$f":"Calculations!P24","v":""},{"$f":"Calculations!R24","v":""}]
[null,"4.1.","Data Collaboration","Int. Agency Collaboration",{"$f":"Calculations!V3","v":""},{"$f":"Calculations!X3","v":""}]
[null,"4.2.","Data Collaboration","Ext. Agency Collaboration",{"$f":"Calculations!V10","v":""},{"$f":"Calculations!X10","v":""}]
[null,"4.3.","Data Collaboration","Ext. Data Sharing Policies and Guidance",{"$f":"Calculations!V17","v":""},{"$f":"Calculations!X17","v":""}]
[null,"5.1.","Data Quality","DQ Measurement and Reporting",{"$f":"Calculations!AB3","v":""},{"$f":"Calculations!AD3","v":""}]
[null,"5.2.","Data Quality","DQ Assurance and Improvement",{"$f":"Calculations!AB10","v":""},{"$f":"Calculations!AD10","v":""}]
[]
[]
[null,"Notes"]
[null,"ID","Consensus Comments","Consensus Improvements"]
[null,"1.1.",{"$f":"IF('1. Data Strategy & Governance'!C13=\"\",\"\",'1. Data Strategy & Governance'!C13)","v":""},{"$f":"IF('1. Data Strategy & Governance'!C14=\"\",\"\",'1. Data Strategy & Governance'!C14)","v":""}]
[null,"1.2.",{"$f":"IF('1. Data Strategy & Governance'!C25=\"\",\"\",'1. Data Strategy & Governance'!C25)","v":""},{"$f":"IF('1. Data Strategy & Governance'!C26=\"\",\"\",'1. Data Strategy & Governance'!C26)","v":""}]
[null,"1.3.",{"$f":"IF('1. Data Strategy & Governance'!C37=\"\",\"\",'1. Data Strategy & Governance'!C37)","v":""},{"$f":"IF('1. Data Strategy & Governance'!C38=\"\",\"\",'1. Data Strategy & Governance'!C38)","v":""}]
[null,"1.4.",{"$f":"IF('1. Data Strategy & Governance'!C49=\"\",\"\",'1. Data Strategy & Governance'!C49)","v":""},{"$f":"IF('1. Data Strategy & Governance'!C50=\"\",\"\",'1. Data Strategy & Governance'!C50)","v":""}]
[null,"1.5.",{"$f":"IF('1. Data Strategy & Governance'!C61=\"\",\"\",'1. Data Strategy & Governance'!C61)","v":""},{"$f":"IF('1. Data Strategy & Governance'!C62=\"\",\"\",'1. Data Strategy & Governance'!C62)","v":""}]
[null,"1.6.",{"$f":"IF('1. Data Strategy & Governance'!C73=\"\",\"\",'1. Data Strategy & Governance'!C73)","v":""},{"$f":"IF('1. Data Strategy & Governance'!C74=\"\",\"\",'1. Data Strategy & Governance'!C74)","v":""}]
[null,"2.1.",{"$f":"IF('2. Data Life Cycle Management'!C13=\"\",\"\",'2. Data Life Cycle Management'!C13)","v":""},{"$f":"IF('2. Data Life Cycle Management'!C14=\"\",\"\",'2. Data Life Cycle Management'!C14)","v":""}]
[null,"2.2.",{"$f":"IF('2. Data Life Cycle Management'!C25=\"\",\"\",'2. Data Life Cycle Management'!C25)","v":""},{"$f":"IF('2. Data Life Cycle Management'!C26=\"\",\"\",'2. Data Life Cycle Management'!C26)","v":""}]
[null,"2.3.",{"$f":"IF('2. Data Life Cycle Management'!C37=\"\",\"\",'2. Data Life Cycle Management'!C37)","v":""},{"$f":"IF('2. Data Life Cycle Management'!C38=\"\",\"\",'2. Data Life Cycle Management'!C38)","v":""}]
[null,"2.4.",{"$f":"IF('2. Data Life Cycle Management'!C49=\"\",\"\",'2. Data Life Cycle Management'!C49)","v":""},{"$f":"IF('2. Data Life Cycle Management'!C50=\"\",\"\",'2. Data Life Cycle Management'!C50)","v":""}]
[null,"2.5.",{"$f":"IF('2. Data Life Cycle Management'!C61=\"\",\"\",'2. Data Life Cycle Management'!C61)","v":""},{"$f":"IF('2. Data Life Cycle Management'!C62=\"\",\"\",'2. Data Life Cycle Management'!C62)","v":""}]
[null,"2.6.",{"$f":"IF('2. Data Life Cycle Management'!C73=\"\",\"\",'2. Data Life Cycle Management'!C73)","v":""},{"$f":"IF('2. Data Life Cycle Management'!C74=\"\",\"\",'2. Data Life Cycle Management'!C74)","v":""}]
[null,"3.1.",{"$f":"IF('3. Data Arch. & Integration'!C13=\"\",\"\",'3. Data Arch. & Integration'!C13)","v":""},{"$f":"IF('3. Data Arch. & Integration'!C14=\"\",\"\",'3. Data Arch. & Integration'!C14)","v":""}]
[null,"3.2.",{"$f":"IF('3. Data Arch. & Integration'!C25=\"\",\"\",'3. Data Arch. & Integration'!C25)","v":""},{"$f":"IF('3. Data Arch. & Integration'!C26=\"\",\"\",'3. Data Arch. & Integration'!C26)","v":""}]
[null,"3.3.",{"$f":"IF('3. Data Arch. & Integration'!C37=\"\",\"\",'3. Data Arch. & Integration'!C37)","v":""},{"$f":"IF('3. Data Arch. & Integration'!C38=\"\",\"\",'3. Data Arch. & Integration'!C38)","v":""}]
[null,"3.4.",{"$f":"IF('3. Data Arch. & Integration'!C49=\"\",\"\",'3. Data Arch. & Integration'!C49)","v":""},{"$f":"IF('3. Data Arch. & Integration'!C50=\"\",\"\",'3. Data Arch. & Integration'!C50)","v":""}]
[null,"4.1.",{"$f":"IF('4. Data Collaboration'!C13=\"\",\"\",'4. Data Collaboration'!C13)","v":""},{"$f":"IF('4. Data Collaboration'!C14=\"\",\"\",'4. Data Collaboration'!C14)","v":""}]
[null,"4.2.",{"$f":"IF('4. Data Collaboration'!C25=\"\",\"\",'4. Data Collaboration'!C25)","v":""},{"$f":"IF('4. Data Collaboration'!C26=\"\",\"\",'4. Data Collaboration'!C26)","v":""}]
[null,"4.3.",{"$f":"IF('4. Data Collaboration'!C37=\"\",\"\",'4. Data Collaboration'!C37)","v":""},{"$f":"IF('4. Data Collaboration'!C38=\"\",\"\",'4. Data Collaboration'!C38)","v":""}]
[null,"5.1.",{"$f":"IF('5. Data Quality'!C13=\"\",\"\",'5. Data Quality'!C13)","v":""},{"$f":"IF('5. Data Quality'!C14=\"\",\"\",'5. Data Quality'!C14)","v":""}]
[null,"5.2.",{"$f":"IF('5. Data Quality'!C25=\"\",\"\",'5. Data Quality'!C25)","v":""},{"$f":"IF('5. Data Quality'!C26=\"\",\"\",'5. Data Quality'!C26)","v":""}]

{"sheet":"Improvement Identification","index":8,"n_rows":85,"n_cols":12,"rows_kept":85,"cut":false,"hidden":false,"merged":[[73,8,76,8],[77,8,80,8],[81,8,84,8],[37,8,40,8],[41,8,44,8],[45,8,48,8],[49,8,52,8],[53,8,56,8],[57,8,60,8],[61,8,64,8],[65,8,68,8],[69,8,72,8],[1,8,4,8],[5,8,8,8],[9,8,12,8],[13,8,16,8],[17,8,20,8],[21,8,24,8],[25,8,28,8],[29,8,32,8],[33,8,36,8],[81,4,84,4],[81,5,84,5],[81,6,84,6],[81,7,84,7],[73,4,76,4],[73,5,76,5],[73,6,76,6],[73,7,76,7],[77,4,80,4],[77,5,80,5],[77,6,80,6],[77,7,80,7],[65,4,68,4],[65,5,68,5],[65,6,68,6],[65,7,68,7],[69,4,72,4],[69,5,72,5],[69,6,72,6],[69,7,72,7],[57,4,60,4],[57,5,60,5],[57,6,60,6],[57,7,60,7],[61,4,64,4],[61,5,64,5],[61,6,64,6],[61,7,64,7],[49,4,52,4],[49,5,52,5],[49,6,52,6],[49,7,52,7],[53,4,56,4],[53,5,56,5],[53,6,56,6],[53,7,56,7],[41,4,44,4],[41,5,44,5],[41,6,44,6],[41,7,44,7],[45,4,48,4],[45,5,48,5],[45,6,48,6],[45,7,48,7],[33,4,36,4],[33,5,36,5],[33,6,36,6],[33,7,36,7],[37,4,40,4],[37,5,40,5],[37,6,40,6],[37,7,40,7],[25,4,28,4],[25,5,28,5],[25,6,28,6],[25,7,28,7],[29,4,32,4],[29,5,32,5],[29,6,32,6],[29,7,32,7],[17,4,20,4],[17,5,20,5],[17,6,20,6],[17,7,20,7],[21,4,24,4],[21,5,24,5],[21,6,24,6],[21,7,24,7],[9,4,12,4],[9,5,12,5],[9,6,12,6],[9,7,12,7],[13,4,16,4],[13,5,16,5],[13,6,16,6],[13,7,16,7],[1,4,4,4],[1,5,4,5],[1,6,4,6],[1,7,4,7],[5,4,8,4],[5,5,8,5],[5,6,8,6],[5,7,8,7],[81,0,84,0],[81,1,84,1],[81,2,84,2],[81,3,84,3],[73,0,76,0],[73,1,76,1],[73,2,76,2],[73,3,76,3],[77,0,80,0],[77,1,80,1],[77,2,80,2],[77,3,80,3],[65,0,68,0],[65,1,68,1],[65,2,68,2],[65,3,68,3],[69,0,72,0],[69,1,72,1],[69,2,72,2],[69,3,72,3],[57,0,60,0],[57,1,60,1],[57,2,60,2],[57,3,60,3],[61,0,64,0],[61,1,64,1],[61,2,64,2],[61,3,64,3],[49,0,52,0],[49,1,52,1],[49,2,52,2],[49,3,52,3],[53,0,56,0],[53,1,56,1],[53,2,56,2],[53,3,56,3],[41,0,44,0],[41,1,44,1],[41,2,44,2],[41,3,44,3],[45,0,48,0],[45,1,48,1],[45,2,48,2],[45,3,48,3],[33,0,36,0],[33,1,36,1],[33,2,36,2],[33,3,36,3],[37,0,40,0],[37,1,40,1],[37,2,40,2],[37,3,40,3],[25,0,28,0],[25,1,28,1],[25,2,28,2],[25,3,28,3],[29,0,32,0],[29,1,32,1],[29,2,32,2],[29,3,32,3],[1,3,4,3],[1,2,4,2],[1,1,4,1],[1,0,4,0],[21,0,24,0],[21,1,24,1],[21,2,24,2],[21,3,24,3],[9,3,12,3],[9,2,12,2],[9,1,12,1],[9,0,12,0],[5,0,8,0],[5,1,8,1],[5,2,8,2],[5,3,8,3],[17,0,20,0],[17,1,20,1],[17,2,20,2],[17,3,20,3],[13,3,16,3],[13,2,16,2],[13,1,16,1],[13,0,16,0]]}
["ID","Sub-Element","Consensus Current Level","Consensus Desired Level","Consensus Comments","Consensus Potential Improvements","Business Impacts of Taking No Action","Possible Improvements","Prioritization","Targeted Improvements","Targeted Improvement Descriptions","Include in Action Plan?\n(TBD / Yes / No)"]
["1.1.","Strategy and Direction",{"$f":"'Assessment Summary'!E5","v":""},{"$f":"'Assessment Summary'!F5","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C30),\"\",'Assessment Summary'!C30)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D30),\"\",'Assessment Summary'!D30)","v":""},"Uncoordinated, decentralized data decisions\n\nUnproductive of lower-value data investments\n\nDuplication of data and efforts","Data Governance Bodies\n\nData Governance and Stewardship Policies\n\nData Business Plans","Medium",null,null,{"$f":"IF(ISBLANK(J2),\"\",\"TBD\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J3),\"\",\"TBD\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J4),\"\",\"TBD\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
["1.2.","Roles and Accountability",{"$f":"'Assessment Summary'!E6","v":""},{"$f":"'Assessment Summary'!F6","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C31),\"\",'Assessment Summary'!C31)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D31),\"\",'Assessment Summary'!D31)","v":""},"Undefined or informal responsibilities\n\nInsufficient training\n\nLess consistent documentation and data quality","Data Governance Bodies\n\nData Governance and Stewardship Policies\n\nData Business Plans\n\nData Management Roles and Responsibilities",null,null,null,{"$f":"IF(ISBLANK(J6),\"\",\"TBD\")","v":""}]
[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,null,""]
["1.3.","Policies and Processes",{"$f":"'Assessment Summary'!E7","v":""},{"$f":"'Assessment Summary'!F7","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C32),\"\",'Assessment Summary'!C32)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D32),\"\",'Assessment Summary'!D32)","v":""},"Lack of standard policies and procedures\n\nLower quality data\n\nLess effective use of the data\n\nVague decision-making processes","Data Governance and Stewardship Policies",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,null,null,null,null,""]
["1.4.","Data Asset Inventory and Value",{"$f":"'Assessment Summary'!E8","v":""},{"$f":"'Assessment Summary'!F8","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C33),\"\",'Assessment Summary'!C33)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D33),\"\",'Assessment Summary'!D33)","v":""},"Inconsistent documentation\n\nLimited understanding of the value added for different types of data and their collection or maintenance costs\n\nDuplication of data and efforts","\nData Catalogs and Dictionaries\n\nData Value Mapping",null,null,null,{"$f":"IF(ISBLANK(J14),\"\",\"TBD\")","v":""}]
[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,null,""]
["1.5.","Relationships and Data Customers",{"$f":"'Assessment Summary'!E9","v":""},{"$f":"'Assessment Summary'!F9","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C34),\"\",'Assessment Summary'!C34)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D34),\"\",'Assessment Summary'!D34)","v":""},"Limited communication & feedback on data quality\n\nWeak relationships between providers and customers\n\nFewer impactful data improvements","\nData Communities of Interest",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,null,null,null,null,""]
["1.6.","Data Management Sustainability",{"$f":"'Assessment Summary'!E10","v":""},{"$f":"'Assessment Summary'!F10","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C35),\"\",'Assessment Summary'!C35)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D35),\"\",'Assessment Summary'!D35)","v":""},"Risk of knowledge loss or disruption\n\nLess effective transition of responsibilities to new staff","Succession Planning and Management\n\nCore Competency Definition",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,null,null,null,null,""]
["2.1.","Data Updating",{"$f":"'Assessment Summary'!E11","v":""},{"$f":"'Assessment Summary'!F11","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C36),\"\",'Assessment Summary'!C36)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D36),\"\",'Assessment Summary'!D36)","v":""},"Infrequent or ungoverned data updates\n\nLower quality data\n\nLess value returned for data investments\n\nReduced clarity for data users and managers","Standard Operating Procedures",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,null,null,null,null,""]
["2.2.","Access Control",{"$f":"'Assessment Summary'!E12","v":""},{"$f":"'Assessment Summary'!F12","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C37),\"\",'Assessment Summary'!C37)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D37),\"\",'Assessment Summary'!D37)","v":""},"Unstandardized process for classifying or defiing access to data\n\nRisk of exposing sensitive or confidential data\n\nRisk of data corruption",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,null,null,null,null,null,""]
["2.3.","Data Findability and Documentation",{"$f":"'Assessment Summary'!E13","v":""},{"$f":"'Assessment Summary'!F13","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C38),\"\",'Assessment Summary'!C38)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D38),\"\",'Assessment Summary'!D38)","v":""},"Difficult to find and access existing data\n\nLow levels of data re-use\n\nDuplication of data collection efforts","Data Catalogs and Dictionaries\n\nData Management Plans\n\nData Curation Profiles",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,null,null,null,null,""]
["2.4.","Data Backups and Archiving",{"$f":"'Assessment Summary'!E14","v":""},{"$f":"'Assessment Summary'!F14","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C39),\"\",'Assessment Summary'!C39)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D39),\"\",'Assessment Summary'!D39)","v":""},"Risk of data loss due to hardware failures or corruption\n\nIneffective use of data storage & higher maintenance costs\n\nLimited consideration for business user needs","Data Governance and Stewardship Policies\n\nData Retention Schedules and Archiving",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,null,null,null,null,""]
["2.5.","Data Change Management",{"$f":"'Assessment Summary'!E15","v":""},{"$f":"'Assessment Summary'!F15","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C40),\"\",'Assessment Summary'!C40)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D40),\"\",'Assessment Summary'!D40)","v":""},"Uncontrolled & uncoordinated changes to the data\n\nBusiness disruptions from broken reports or queries\n\nInconsistencies in data structure","Data Change Management\n\nReference Data Management",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,null,null,null,null,""]
["2.6.","Data Delivery",{"$f":"'Assessment Summary'!E16","v":""},{"$f":"'Assessment Summary'!F16","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C41),\"\",'Assessment Summary'!C41)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D41),\"\",'Assessment Summary'!D41)","v":""},"Lower data use and re-use\n\nMinimal data integration or transformation\n\nLower return on data investment\n\nInefficiencies for data management staff and analysts","Data Delivery Platforms",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,null,null,null,null,""]
["3.1.","Location Referencing",{"$f":"'Assessment Summary'!E17","v":""},{"$f":"'Assessment Summary'!F17","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C42),\"\",'Assessment Summary'!C42)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D42),\"\",'Assessment Summary'!D42)","v":""},"Unreliabe data mapping\n\nInability to integrate data by spatial components\n\nIneffective data integration or visualization\n\nLess business value from data","Common Geospatial Referencing\n\nData Change Management",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,null,null,null,null,""]
["3.2.","Geospatial Data Management",{"$f":"'Assessment Summary'!E18","v":""},{"$f":"'Assessment Summary'!F18","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C43),\"\",'Assessment Summary'!C43)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D43),\"\",'Assessment Summary'!D43)","v":""},"Limited spatial data management and reporting\n\nLoss of business value from spatial data\n\nInefficient use of hardware, software, and expertise","Data Governance and Stewardship Policies\n\nData Delivery Platforms\n\nCommon Geospatial 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,null,null,null,null,null,null,null,""]
["3.3.","Data Consistency and Integration",{"$f":"'Assessment Summary'!E19","v":""},{"$f":"'Assessment Summary'!F19","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C44),\"\",'Assessment Summary'!C44)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D44),\"\",'Assessment Summary'!D44)","v":""},"Inaccurate or inefficient data integration\n\nInefficient data maintenance (unconsolidated data tables)\n\nDuplication of data and efforts","Data Architecture Practices and Roles\n\nReference Data Management\n\nMaster Data Management",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,null,null,null,null,""]
["3.4.","Temporal Data Management",{"$f":"'Assessment Summary'!E20","v":""},{"$f":"'Assessment Summary'!F20","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C45),\"\",'Assessment Summary'!C45)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D45),\"\",'Assessment Summary'!D45)","v":""},"Loss of business value\n\nLimited understanding of cause and effect relationships without strong temporal data\n\nUnable to capture point-in-time conditions","Data Architecture Practices and Roles\n\nStandardized Approach to Temporal Data",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,null,null,null,null,""]
["4.1.","Internal Agency Collaboration",{"$f":"'Assessment Summary'!E21","v":""},{"$f":"'Assessment Summary'!F21","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C46),\"\",'Assessment Summary'!C46)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D46),\"\",'Assessment Summary'!D46)","v":""},"Duplication of data and collection efforts\n\nProliferation of overlapping and inconsistent datasets\n\nLoss of opportunity for mutual beneficial collection","Multi-Purpose Data Collection\n\nData Outsourcing\n\nData Business Plans\n\nData Governance Bodies",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,{"$f":"IF(ISBLANK(J68),\"\",\"TBD\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
["4.2.","External Agency Collaboration",{"$f":"'Assessment Summary'!E22","v":""},{"$f":"'Assessment Summary'!F22","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C47),\"\",'Assessment Summary'!C47)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D47),\"\",'Assessment Summary'!D47)","v":""},"Inconsistent processes for data sharing\n\nRisk of data misuse\n\nLimited awareness of external data sources","Data Clearinghouses/Open Data Platforms\n\nData-Sharing Agreements\n\nData Partnerships",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,null,null,null,null,""]
["4.3.","External Data Sharing Policies and Guidance",{"$f":"'Assessment Summary'!E23","v":""},{"$f":"'Assessment Summary'!F23","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C48),\"\",'Assessment Summary'!C48)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D48),\"\",'Assessment Summary'!D48)","v":""},"Increased time filling individual data requests\n\nLess consistency in externally available agency data","Data-Sharing Agreements\n\nProtocols and Procedures for Data Publishing",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,null,null,null,null,""]
["5.1.","DQ Measurement and Reporting",{"$f":"'Assessment Summary'!E24","v":""},{"$f":"'Assessment Summary'!F24","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C49),\"\",'Assessment Summary'!C49)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D49),\"\",'Assessment Summary'!D49)","v":""},"Lack of user trust in data\n\nLimited awareness of the quality of agency datasets\n\nNo targeted data quality improvement efforts","Data Quality Metrics\n\nData Collection Quality Management Processes",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,null,null,null,null,""]
["5.2.","DQ Assurance and Improvement",{"$f":"'Assessment Summary'!E25","v":""},{"$f":"'Assessment Summary'!F25","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!C50),\"\",'Assessment Summary'!C50)","v":""},{"$f":"IF(ISBLANK('Assessment Summary'!D50),\"\",'Assessment Summary'!D50)","v":""},"Inconsistent data processes\n\nUse of none or manual data cleansing where automated processes are available\n\nLoss of business value","Data Validation Rules\n\nData Cleansing\n\nData Collection Quality Management Processes",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,null,null,null,null,""]

{"sheet":"Action Planning","index":9,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["ID","Action","Sub-Elements","Business Need","Gap","Description","Benefit of Taking Action","Priority\n(High/Med/Low)","Implementation Difficulty\n(High/Med/Low)","Implementation Lead","Status\n(Proposed, Planned, In Progress, Complete)","Target Completion","Dependencies or Blockers","Comments"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"Validation Lists","index":10,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["Action Planning"]
["Description","Implementation Lead","Business Owner","Other Staff Support","Estimated Improvement Time","Resource Requirements","Target Completion Date","Current Status","Status Date","Next Milestone","Next Milestone Date","Business Case Documented","Comments","Prioritization","Include in Action Plan?"]
[null,null,null,null,"<3 months","Existing Project/Initiative",null,null,null,null,null,"Yes",null,"Low","TBD"]
[null,null,null,null,"3-6 months","New (In House Only)",null,null,null,null,null,"No",null,"Medium","Yes"]
[null,null,null,null,"6-12 months","New (External Support)",null,null,null,null,null,"Desired",null,"High","No"]
[null,null,null,null,">12 months",null,null,null,null,null,null,"TBD"]

{"sheet":"Individual Summary","index":11,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ID","Element","Sub-Element","Current Level","Desired Level","Assessed By"]

{"sheet":"Individual Notes","index":12,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ID","Comments","Improvements","Assessed By"]