{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Configuration","Importance","Availability","Quality","Usability","Improvement Identification","Action Planning"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Configuration","index":0,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"This sheet automatically configures the four consensus sheets and the improvement identification sheet to assist in the next stages of the analysis. Please follow the four steps, then press Apply."]
[]
[null,"Step 1:","Define the business area under consideration"]
[]
[]
[null,"Step 2:","Enter the number of participants (if uncertain, estimate high)"]
[]
[]
[null,"Step 3: ","List up to 20 activities related to this business area below (leave unfilled cells blank)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 4: ","List up to 20 data sources that are most important for this collection of activities (leave unfilled cells blank)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 5:","Press Apply button"]

{"sheet":"Importance","index":1,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,9,1,10],[0,3,0,7],[0,1,0,2],[1,3,1,7]]}
[null,"High-Essential; can't perform this activity without it\nMed-Valuable; could do without it, but would impact value or credibility of results\nLow-Helpful but could do without it"]
[null,null,null,"Respondent",null,null,null,null,null,"Comments Received"]
[null,"Activity \n(Business Use)","Data Sources",null,null,null,"Response Count","Consensus Rating",null,"Respondent","Comments\n- If high quality/useful data was available, how important would the data be to the business activity?"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(COUNTIF(D4:F4,\"Low\"),\" Low\",CHAR(10), COUNTIF(D4:F4,\"Medium\"),\" Medium\",CHAR(10), COUNTIF(D4:F4,\"High\"),\" High\")","v":"0 Low\n0 Medium\n0 High"}]

{"sheet":"Availability","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,8,10,9],[3,6,8,6],[1,8,1,9],[0,2,0,6],[0,0,0,1],[1,2,1,6],[3,1,8,1],[3,2,8,2],[3,3,8,3],[3,4,8,4],[3,5,8,5]]}
["Poor-little or no data available \nFair-limited data available; large gaps \nGood-Basic data available; some gaps \nExcellent-sufficient data available to meet needs; no gaps"]
[null,null,"Respondent",null,null,null,null,null,"Activity Specific Comments Received"]
[null,"Activities",null,null,null,"Response Count","Consensus Rating",null,"Respondent","Comments\n- What data gaps exist?"]
[null,null,null,null,null,{"$f":"CONCATENATE(COUNTIF(C4:E4,\"Poor\"),\" Poor\",CHAR(10), COUNTIF(C4:E4,\"Fair\"),\" Fair\",CHAR(10), COUNTIF(C4:E4,\"Good\"),\" Good\",CHAR(10), COUNTIF(C4:E4,\"Excellent\"),\" Excellent\")","v":"0 Poor\n0 Fair\n0 Good\n0 Excellent"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Other (Broader) Comments Received"]
[null,null,null,null,null,null,null,null,"Respondent","Comment"]

{"sheet":"Quality","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,3,1,7],[0,3,0,7],[1,9,1,10],[7,9,7,10],[3,1,5,1]]}
["Poor-data aren't detailed, current, reliable or complete enough to be useful\nFair-data are useful but lack of currency, reliability or completeness limits value\nGood-data quality is acceptable but should be improved \nExcellent-data quality is sufficient for this activity, no improvements needed "]
[null,null,null,"Respondent",null,null,null,null,null,"Data Source Specific Comments"]
[null,"Data Sources","Quality Dimensions",null,null,null,"Response Count","Consensus Rating",null,"Respondent","Comment\n- Issues with timing / extent to which data reflects current conditions?\n- Issues with data not reflecting condition at time of measurement?\n- Issues with incomplete records / missing data elements?"]
[null,null,"Currency",null,null,null,{"$f":"CONCATENATE(COUNTIF(D4:F4,\"Poor\"),\" Poor\",CHAR(10), COUNTIF(D4:F4,\"Fair\"),\" Fair\",CHAR(10), COUNTIF(D4:F4,\"Good\"),\" Good\",CHAR(10), COUNTIF(D4:F4,\"Excellent\"),\" Excellent\")","v":"0 Poor\n0 Fair\n0 Good\n0 Excellent"}]
[null,null,"Accuracy",null,null,null,{"$f":"CONCATENATE(COUNTIF(D5:F5,\"Poor\"),\" Poor\",CHAR(10), COUNTIF(D5:F5,\"Fair\"),\" Fair\",CHAR(10), COUNTIF(D5:F5,\"Good\"),\" Good\",CHAR(10), COUNTIF(D5:F5,\"Excellent\"),\" Excellent\")","v":"0 Poor\n0 Fair\n0 Good\n0 Excellent"}]
[null,null,"Completeness",null,null,null,{"$f":"CONCATENATE(COUNTIF(D6:F6,\"Poor\"),\" Poor\",CHAR(10), COUNTIF(D6:F6,\"Fair\"),\" Fair\",CHAR(10), COUNTIF(D6:F6,\"Good\"),\" Good\",CHAR(10), COUNTIF(D6:F6,\"Excellent\"),\" Excellent\")","v":"0 Poor\n0 Fair\n0 Good\n0 Excellent"}]
[]
[null,null,null,null,null,null,null,null,null,"Other Comments Received"]
[null,null,null,null,null,null,null,null,null,"Respondent","Comment"]

{"sheet":"Usability","index":4,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,2,0,6],[0,0,0,1],[1,8,1,9],[1,2,1,6],[7,8,7,9],[3,4,5,4],[3,5,5,5],[3,6,5,6],[3,1,5,1],[3,2,5,2],[3,3,5,3]]}
["Poor-data are available but require substantial effort to translate into useable form\nFair-data are available but require moderate effort to translate into usable form\nGood-data are available in a usable form but improvements to reporting capabilities would be helpful\nExcellent-data are available in a usable form; no improvements needed"]
[null,null,"Respondent",null,null,null,null,null,"Data Source Specific Comments"]
[null,"Data Sources",null,null,null,"Response Count","Consensus Rating",null,"Respondent","Comment\n- Barriers to finding appropriate data? (e.g. need catalog, webpage)\n- Undue effort to access data (e.g. need special requests, challenging self-service tools?)\n- Format not useful? (e.g. req. summary, analysis, or integration?)\n- Gaps in understanding data? (e.g. better metadata documents)"]
[null,null,null,null,null,{"$f":"CONCATENATE(COUNTIF(C4:E4,\"Poor\"),\" Poor\",CHAR(10), COUNTIF(C4:E4,\"Fair\"),\" Fair\",CHAR(10), COUNTIF(C4:E4,\"Good\"),\" Good\",CHAR(10), COUNTIF(C4:E4,\"Excellent\"),\" Excellent\")","v":"0 Poor\n0 Fair\n0 Good\n0 Excellent"}]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(COUNTIF(C5:E5,\"Poor\"),\" Poor\",CHAR(10), COUNTIF(C5:E5,\"Fair\"),\" Fair\",CHAR(10), COUNTIF(C5:E5,\"Good\"),\" Good\",CHAR(10), COUNTIF(C5:E5,\"Excellent\"),\" Excellent\")","v":"0 Poor\n0 Fair\n0 Good\n0 Excellent"}]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(COUNTIF(C6:E6,\"Poor\"),\" Poor\",CHAR(10), COUNTIF(C6:E6,\"Fair\"),\" Fair\",CHAR(10), COUNTIF(C6:E6,\"Good\"),\" Good\",CHAR(10), COUNTIF(C6:E6,\"Excellent\"),\" Excellent\")","v":"0 Poor\n0 Fair\n0 Good\n0 Excellent"}]
[]
[null,null,null,null,null,null,null,null,"Comments Received"]
[null,null,null,null,null,null,null,null,"Respondent","Comment"]

{"sheet":"Improvement Identification","index":5,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,6,4,6],[1,0,4,0],[1,1,4,1],[1,2,4,2],[1,3,4,3],[1,4,4,4],[1,5,4,5]]}
["Element","Business Activity","Data Source","Consensus Current Level","Consensus Comments","Consensus Potential Improvements","Improvement Priority","Targeted Improvements","Targeted Improvement Descriptions","Include in Action Plan?\n(TBD / Yes / No)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H2),\"\",\"TBD\")","v":""},null,null,"High","TBD","Low"]
[null,null,null,null,null,null,null,null,null,"",null,null,"Medium","Yes","Medium"]
[null,null,null,null,null,null,null,null,null,"",null,null,"Low","No","High"]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"Poor"]

{"sheet":"Action Planning","index":6,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["ID","Action","Data Source [or] Data Source-Activity","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]