{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","Output ","dropdown"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Input","index":0,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,1,5],[4,0,4,5],[9,8,9,12],[9,3,9,7],[7,0,7,5],[6,0,6,5],[5,0,5,5]]}
["Objective"]
["This tool was designed to map stakeholders to each of the five different roles in 7-1-7 implementation: coordination, data collection, performance improvement, national planning, and communication and advocacy"]
[]
["Complete the table below by completing the following steps"]
["1. List the names of each 7-1-7 stakeholder in Column B"]
["2. List each stakeholder's current interest is supporting 7-1-7 implementation in Column C (High or Low)"]
["3. List each stakeholder's influence in each of five components of 7-1-7 implementation in Columns D-H: coordination, data collection, performance improvement, national planning, and communication and advocacy"]
["4. After entering all data, click on the \"Refresh Outputs\" button to the right to populate the tables on the Output tab of this spreadsheet. Macros must be enabled for this Excel file for this step to work."]
[]
[null,null,null,"INFLUENCE",null,null,null,null,"STAKEHOLDER CATEGORY"]
["Column1","STAKEHOLDER","INTEREST IN 7-1-7","Coordination","Data Collection","Performance Improvement","National Planning","Communication and Advocacy","Coordination2","Data Collection3","Performance Improvement4","National Planning5","Communication and Advocacy6"]
["Example","Stakeholder name","Low","High","Low","High","Low","High",{"$f":"IF(AND(D12=\"High\",$C12=\"High\"),\"Driver: manage closely\",IF(AND(D12=\"Low\",$C12=\"High\"),\"Supporter: keep motivated and informed\",IF(AND(D12=\"High\",$C12=\"Low\"),\"Potential blocker: understand resistance/keep satisfied\",IF(AND(D12=\"Low\",$C12=\"Low\"),\"Bystander: monitor and keep informed\",\"\"))))","v":"Potential blocker: understand resistance/keep satisfied"},{"$f":"IF(AND(E12=\"High\",$C12=\"High\"),\"Driver: manage closely\",IF(AND(E12=\"Low\",$C12=\"High\"),\"Supporter: keep motivated and informed\",IF(AND(E12=\"High\",$C12=\"Low\"),\"Potential blocker: understand resistance/keep satisfied\",IF(AND(E12=\"Low\",$C12=\"Low\"),\"Bystander: monitor and keep informed\",\"\"))))","v":"Bystander: monitor and keep informed"},{"$f":"IF(AND(F12=\"High\",$C12=\"High\"),\"Driver: manage closely\",IF(AND(F12=\"Low\",$C12=\"High\"),\"Supporter: keep motivated and informed\",IF(AND(F12=\"High\",$C12=\"Low\"),\"Potential blocker: understand resistance/keep satisfied\",IF(AND(F12=\"Low\",$C12=\"Low\"),\"Bystander: monitor and keep informed\",\"\"))))","v":"Potential blocker: understand resistance/keep satisfied"},{"$f":"IF(AND(G12=\"High\",$C12=\"High\"),\"Driver: manage closely\",IF(AND(G12=\"Low\",$C12=\"High\"),\"Supporter: keep motivated and informed\",IF(AND(G12=\"High\",$C12=\"Low\"),\"Potential blocker: understand resistance/keep satisfied\",IF(AND(G12=\"Low\",$C12=\"Low\"),\"Bystander: monitor and keep informed\",\"\"))))","v":"Bystander: monitor and keep informed"},{"$f":"IF(AND(H12=\"High\",$C12=\"High\"),\"Driver: manage closely\",IF(AND(H12=\"Low\",$C12=\"High\"),\"Supporter: keep motivated and informed\",IF(AND(H12=\"High\",$C12=\"Low\"),\"Potential blocker: understand resistance/keep satisfied\",IF(AND(H12=\"Low\",$C12=\"Low\"),\"Bystander: monitor and keep informed\",\"\"))))","v":"Potential blocker: understand resistance/keep satisfied"}]
[1,"Stakeholder 1",null,null,null,null,null,null,"","","","",""]
[2,"Stakeholder 2",null,null,null,null,null,null,"","","","",""]
[3,"Stakeholder 3",null,null,null,null,null,null,"","","","",""]
[4,"Stakeholder 4",null,null,null,null,null,null,"","","","",""]
[5,"Stakeholder 5",null,null,null,null,null,null,"","","","",""]
[6,"Stakeholder 6",null,null,null,null,null,null,"","","","",""]
[7,"Stakeholder 7",null,null,null,null,null,null,"","","","",""]
[8,"Stakeholder 8",null,null,null,null,null,null,"","","","",""]
[9,"Stakeholder 9",null,null,null,null,null,null,"","","","",""]
[10,"Stakeholder 10",null,null,null,null,null,null,"","","","",""]
[11,"Stakeholder 11",null,null,null,null,null,null,{"$f":"IF(AND(D23=\"High\",$C23=\"High\"),\"Driver\",IF(AND(D23=\"Low\",$C23=\"High\"),\"Supporter\",IF(AND(D23=\"High\",$C23=\"Low\"),\"Potential blocker\",IF(AND(D23=\"Low\",$C23=\"Low\"),\"Bystander\",\"\"))))","v":""},{"$f":"IF(AND(E23=\"High\",$C23=\"High\"),\"Driver\",IF(AND(E23=\"Low\",$C23=\"High\"),\"Supporter\",IF(AND(E23=\"High\",$C23=\"Low\"),\"Potential blocker\",IF(AND(E23=\"Low\",$C23=\"Low\"),\"Bystander\",\"\"))))","v":""},{"$f":"IF(AND(F23=\"High\",$C23=\"High\"),\"Driver\",IF(AND(F23=\"Low\",$C23=\"High\"),\"Supporter\",IF(AND(F23=\"High\",$C23=\"Low\"),\"Potential blocker\",IF(AND(F23=\"Low\",$C23=\"Low\"),\"Bystander\",\"\"))))","v":""},{"$f":"IF(AND(G23=\"High\",$C23=\"High\"),\"Driver\",IF(AND(G23=\"Low\",$C23=\"High\"),\"Supporter\",IF(AND(G23=\"High\",$C23=\"Low\"),\"Potential blocker\",IF(AND(G23=\"Low\",$C23=\"Low\"),\"Bystander\",\"\"))))","v":""},{"$f":"IF(AND(H23=\"High\",$C23=\"High\"),\"Driver\",IF(AND(H23=\"Low\",$C23=\"High\"),\"Supporter\",IF(AND(H23=\"High\",$C23=\"Low\"),\"Potential blocker\",IF(AND(H23=\"Low\",$C23=\"Low\"),\"Bystander\",\"\"))))","v":""}]
[12,"Stakeholder 12",null,null,null,null,null,null,"","","","",""]
[13,"Stakeholder 13",null,null,null,null,null,null,"","","","",""]
[14,"Stakeholder 14",null,null,null,null,null,null,"","","","",""]
[15,"Stakeholder 15",null,null,null,null,null,null,"","","","",""]
[16,"Stakeholder 16",null,null,null,null,null,null,"","","","",""]
[17,"Stakeholder 17",null,null,null,null,null,null,"","","","",""]
[18,"Stakeholder 18",null,null,null,null,null,null,"","","","",""]
[19,"Stakeholder 19",null,null,null,null,null,null,"","","","",""]
[20,"Stakeholder 20",null,null,null,null,null,null,"","","","",""]

{"sheet":"Output ","index":1,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,3,4,4],[4,6,4,7],[4,9,4,10],[4,12,4,13]]}
["The output below shows stakeholders with High Influence in each of the five key components of 7-1-7 implementation"]
["If interest In 7-1-7 is High: consider the stakeholder a Driver who should be managed closely and engaged at key junctures"]
["If interest in 7-1-7 is Low: consider the stakeholder a Potential Blocker, so understand resistance and work to keep them satisfied"]
[]
["Stakeholders with high influence in Coordination",null,null,"Stakeholders with high influence in Data Collection",null,null,"Stakeholders with high influence in Performance Improvement",null,null,"Stakeholders with high influence in National Planning",null,null,"Stakeholders with high influence in Communication & Advocacy"]
[]
["STAKEHOLDER","INTEREST IN 7-1-7",null,"STAKEHOLDER","INTEREST IN 7-1-7",null,"STAKEHOLDER","INTEREST IN 7-1-7",null,"STAKEHOLDER","INTEREST IN 7-1-7",null,"STAKEHOLDER","INTEREST IN 7-1-7"]

{"sheet":"dropdown","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["High"]
["Low"]