{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Cover Page","Instructions","Participant Info","1.0","2.0","3.0","4.0","5.0","6.0","7.0","8.0","9.0","10.0","11.0","12.0","Dashboards","Overall Dashboards","Action Plan","Data"],"not_rendered":{"charts":128,"images":3,"macros":1,"external_links":0,"defined_names":14,"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":"Cover Page","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[10,1,11,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Assessment of the capacity of organizations  to identify and respond to M&E information needs at national and subnational levels"]
[]
[]
[]
[null,"Type of assessment "]
[]
[null,"Capacity Area 1: Organizational"]
[null,"Capacity Area 2: Human Capacity for M&E"]
[null,"Capacity Area 3: Partnerships and Governance"]
[null,"Capacity Area 4: Organization M&E Plan"]
[null,"Capacity Area 5: Annual Costed M&E Work plan"]
[null,"Capacity Area 6: Advocacy, Communication, and Cultural Behavior"]
[null,"Capacity Area 7: Routine Monitoring"]
[null,"Capacity Area 8: Surveys and Surveillance"]
[null,"Capacity Area 9: National and Subnational Databases"]
[null,"Capacity Area 10: Supervision and Auditing"]
[null,"Capacity Area 11: Evaluation and Research"]
[null,"Capacity Area 12: Data Demand and Use"]
[null,"Dashboards"]
[null,"Overall Dashboards"]
[null,"Action Plan"]

{"sheet":"Instructions","index":1,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,0,4,19],[17,0,17,19],[18,0,18,19],[22,0,22,19],[0,0,0,18],[2,0,2,19],[7,0,7,19],[9,0,9,19]]}
["INSTRUCTIONS FOR USING THE TOOL"]
[]
["1. What is the purpose of these instructions?"]
[]
["The instructions provide clarification about the questions in the MECAT group assessment tool. They are intended to be used by the facilitator(s) of this capacity assessment. The aim is to standardize the approach used in the scoring during the assessment. Data generated from this assessment will be used to develop capacity-building plans to strengthen the ability of the division to perform its M&E functions. "]
[]
[]
["2. How does the assessment tool function?"]
[]
["The assessment comprises questions focusing on four dimensions (status, quality, technical assistance, and financial system) for each of the 12 capacity areas. When requested, be sure to \"Enable Content\" to enable the macros in this workbook to ensure its full functionality."]
[]
["The 12 functional areas of the M&E capacity organizational assessment are scored using a series of statements based on four response scales: "]
["a)    a 2-point scale (Yes, No)"]
["b)    a 3-point scale (Yes mostly, Yes partly, Not at all), (Yes approved, Yes draft, Not at all), (Yes completely, Yes partly, Not at all), (Yes reviewed, Yes under review, Not at all)"]
["c)    a 4-point scale (Strongly Agree, Agree, Disagree, Strongly Disagree), (Less than 1 year, 1-2 years,  2-3 years,  Greater than 3 years), (Monthly, Quarterly, Biannually, Annually)"]
["d)    a 5-point scale (Weekly, Monthly, Quarterly, Biannually, Annually) "]
[]
["For example, in scoring the statement, “The organization has a mission statement or stated objectives,” if the mission statement and objectives have been adopted and approved by the relevant decision-making authority, the response is “Yes, approved.”  If the mission statement and objectives are available and not yet approved, the response is “Yes, in draft.” If the mission statement and objectives are not available, the response is “Not at all.” The score for each question will be arrived at through group consensus facilitated by the moderator of the sessions. If any of the \"status\" questions for an element have a rank of \"0,\" the tool will automatically assign a rank of \"0\" to the quality, technical autonomy, and financial autonomy questions in that element. The facilitator should skip the rest of the questions in the element."]
["Any textual data to qualify the response should be included in the comment box provided. This will provide important information to consider in discussing the necessary actions to take. If possible, any comments that help to identify and plan for strategic interventions should also be recorded in the comment box. "]
[]
["The electronic version of the tool is set up to facilitate selecting the response and summarizing the assessment results at the end of the assessment. "]
[]
["The appropriate response can be selected from a drop-down menu in the ANSWER column and will appear as follows: “Yes, mostly” in green, “Yes, partly” in orange, and “Not at all” in red.  This visualization in color will help with summarizing the assessment results and prioritizing actions. Similar color schemes also exist for the 4- and 5-point scales. Summary dashboards on the \"Dashboards\" and \"Overall Dashboards\" tabs will automatically be generated showing the distribution of the overall scores and for each of the 12 functional areas by dimension (Status, Quality, Technical Autonomy, and Financial Autonomy). This provides a visual representation of the gaps in the M&E capacity of the division. "]
["  "]

{"sheet":"Participant Info","index":2,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,2,15],[3,0,3,6],[7,7,7,15],[10,1,10,5],[10,6,10,10],[10,11,10,15],[3,7,3,15],[5,7,5,15],[11,1,11,5],[11,6,11,10],[11,11,11,15],[12,1,12,5],[12,6,12,10],[12,11,12,15],[20,1,20,5],[20,6,20,10],[20,11,20,15],[21,1,21,5],[21,6,21,10],[21,11,21,15],[22,1,22,5],[22,6,22,10],[22,11,22,15],[23,1,23,5],[23,6,23,10],[23,11,23,15],[35,1,35,15],[36,1,36,15],[37,1,37,15],[24,1,24,5],[24,6,24,10],[24,11,24,15],[27,1,27,5],[27,6,27,10],[27,11,27,15],[34,1,34,15],[33,1,33,15],[25,1,25,5],[25,6,25,10],[25,11,25,15],[26,1,26,5],[26,6,26,10],[17,6,17,10],[18,6,18,10],[19,6,19,10],[13,1,13,5],[14,1,14,5],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[13,6,13,10],[14,6,14,10],[15,6,15,10],[16,6,16,10],[26,11,26,15],[29,1,29,15],[30,1,30,15],[32,1,32,15],[5,0,5,6],[7,0,7,6],[9,0,9,15],[19,11,19,15],[31,1,31,15],[13,11,13,15],[14,11,14,15],[15,11,15,15],[16,11,16,15],[17,11,17,15],[18,11,18,15],[19,1,19,5]]}
["PARTICIPANTS' INFORMATION "]
[]
[]
["Organization"]
[]
["Name of Workshop Moderator"]
[]
["Workshop Date"]
[]
["Participant List"]
["#","Name",null,null,null,null,"Title",null,null,null,null,"Email Address"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[]
[null,"Supporting Documents"]

{"sheet":"1.0","index":3,"n_rows":91,"n_cols":25,"rows_kept":91,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,7,0],[2,1,7,1],[2,2,7,2],[0,3,0,10],[20,0,25,0],[20,1,25,1],[20,2,25,2],[8,0,13,0],[8,1,13,1],[8,2,13,2],[14,2,19,2],[14,0,19,0],[15,1,18,1]]}
["1.0 Organizational",null,null,"     • Leadership: Effective leadership for M&E in the organization\n     • Human Resources: Job descriptions for M&E staff, adequate number of skilled M&E staff, defined career path in M&E\n     • Organizational Culture: Organizational commitment to ensure M&E system performance\n     • Organizational Roles and Functions: Well-defined organization structure, including a organization M&E unit; M&E units or M&E focal points in other public, private, and civil society organizations; written mandates for planning, coordinating, and managing the M&E system; well-defined M&E roles and responsibilities for key individuals and organizations at all levels\n     • Organizational Mechanisms: Routine mechanisms for M&E planning and management, for stakeholder coordination and consensus building, and for monitoring the performance of the M&E system; incentives for M&E system performance\n     • Organizational Performance: Key organizations achieve their annual work plan objectives for M&E"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Mission statement or stated objectives","Yes","Status","The organization has a mission statement or stated objectives for health",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,N$68:O$71,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,N$68:O$71,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The organization's M&E activities are aligned with the mission and objectives of the health sector",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","Staff are able to state the mission statement and objectives",null,{"$f":"IF(G3=0,0,ROUND(IF(F5<>\"\",VLOOKUP(F5,H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H5<>\"\",VLOOKUP(H5,H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The mission statement was developed with external technical assistance",null,{"$f":"IF(G3=0,0,ROUND(IF(F7<>\"\",VLOOKUP(F7,Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H7<>\"\",VLOOKUP(H7,Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[2,"Values and ethics statements","Yes","Status","Values and ethics statements are available",null,{"$f":"ROUND(IF(F9<>\"\",VLOOKUP(F9,N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H9<>\"\",VLOOKUP(H9,N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Staff are able to summarize the organization's health sector  values and ethics statements",null,{"$f":"IF(G9=0,0,ROUND(IF(F10<>\"\",VLOOKUP(F10,H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H10<>\"\",VLOOKUP(H10,H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","Staff in the organization know and apply these values and ethics",null,{"$f":"IF(G9=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","The organization's health sector values include attention to gender equity",null,{"$f":"IF(G9=0,0,ROUND(IF(F12<>\"\",VLOOKUP(F12,E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H12<>\"\",VLOOKUP(H12,E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Technical autonomy","The values and ethics statements were developed with external technical assistance",null,{"$f":"IF(G9=0,0,ROUND(IF(F13<>\"\",VLOOKUP(F13,Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H13<>\"\",VLOOKUP(H13,Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[3,null,"No","Status","The organization has an M&E unit/directorate",null,{"$f":"ROUND(IF(F15<>\"\",VLOOKUP(F15,E$68:F$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H15<>\"\",VLOOKUP(H15,E$68:F$70,2),0)*3.3333,2)","v":0}]
[null,"M&E unit/directorate",null,"Quality 1","The entity has the written mandate to execute its M&E functions",null,{"$f":"IF(G15=0,0,ROUND(IF(F16<>\"\",VLOOKUP(F16,H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I15=0,0, ROUND(IF(H16<>\"\",VLOOKUP(H16,H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","The M&E responsibilities are clearly defined in job descriptions",null,{"$f":"IF(G15=0,0,ROUND(IF(F17<>\"\",VLOOKUP(F17,H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I15=0, 0,ROUND(IF(H17<>\"\",VLOOKUP(H17,H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","The number of casual, contract, secondment, and permanent M&E posts  at the unit/directorate is adequate",null,{"$f":"IF(G15=0,0,ROUND(IF(F18<>\"\",VLOOKUP(F18,H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H18<>\"\",VLOOKUP(H18,H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Technical autonomy","The organization relies on external M&E on an ongoing basis to fulfill routine M&E tasks ",null,{"$f":"IF(G15=0,0, ROUND(IF(F19<>\"\",VLOOKUP(F19,Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H19<>\"\",VLOOKUP(H19,Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[4,"Regular M&E unit meetings","Yes","Status","M&E unit meets regularly to assess progress, plan, and coordinate",null,{"$f":"ROUND(IF(F21<>\"\",VLOOKUP(F21,E$68:F$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H21<>\"\",VLOOKUP(H21,E$68:F$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Meeting minutes are circulated to the unit members",null,{"$f":"IF(G21=0,0,ROUND(IF(F22<>\"\",VLOOKUP(F22,H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I21=0,0,ROUND(IF(H22<>\"\",VLOOKUP(H22,H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","How often do you hold the M&E unit/directorate meetings",null,{"$f":"IF(G21=0,0,ROUND(IF(F23<>\"\",VLOOKUP(F23,K$68:L$72,2),0)*2,2))","v":0},null,{"$f":"IF(I21=0,0,ROUND(IF(H23<>\"\",VLOOKUP(H23,K$68:L$72,2),0)*2,2))","v":0}]
[null,null,null,"Quality 3","There are routine mechanisms for M&E planning and management, for monitoring the performance of the M&E system, and for incentives for M&E system performance",null,{"$f":"IF(G21=0,0,ROUND(IF(F24<>\"\",VLOOKUP(F24,H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I21=0,0,ROUND(IF(H24<>\"\",VLOOKUP(H24,H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Technical autonomy","M&E unit meetings require technical assistance from external stakeholders",null,{"$f":"IF(G21=0,0,ROUND(IF(F25<>\"\",VLOOKUP(F25,Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I21=0,0,ROUND(IF(H25<>\"\",VLOOKUP(H25,Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","M&E unit meetings are facilitated mainly through the support from the government of [insert country name].",null,{"$f":"IF(G21=0,0,ROUND(IF(F26<>\"\",VLOOKUP(F26,E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I21=0,0,ROUND(IF(H26<>\"\",VLOOKUP(H26,E$68:F$70,2),0)*3.3333,2))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Not at all",0,null,"Agree",3,null,"Annually",1,null,"Not at all",0,null,"Not at all",0,null,"None",0,"None",0,"1-2 years",3]
[null,null,null,null,"Yes mostly",3,null,"Disagree",2,null,"Biannually",2,null,"Yes approved",3,null,"Yes completely",3,null,"Yes full-time",3,"Yes ad hoc",1.5,"2-3 years",2]
[null,null,null,null,"Yes partly",1.5,null,"Strongly agree",4,null,"Monthly",4,null,"Yes draft",1.5,null,"Yes partly",1.5,null,"Yes part-time",1.5,"Yes formal",3,"Greater than 3 years",1]
[null,null,null,null,null,null,null,"Strongly disagree",1,null,"Quarterly",3,null,null,null,null,null,null,null,null,null,null,null,"Less than 1 year",4]
[null,null,null,null,null,null,null,null,null,null,"Weekly",5,null,null,null,null,"Leave This one as is - used for Technical Areas"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not at all",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes completely",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes partly",1.5]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not at all",0]
[null,null,null,null,null,null,null,null,null,null,"Annually",3,null,"Annually",1,null,"Not at all",0,null,"No",0,null,null,"Yes",3]
[null,null,null,null,"Annually",2,null,"Not at all",0,null,"Bi-annually",1.5,null,"Bi-Annually",2,null,"Yes reviewed",3,null,"Yes",2,"No",0,"Yes as a draft",1.5]
[null,null,null,null,"Biannually",3,null,"Yes completely",4,null,"Not at all",0,null,"Monthly",4,null,"Yes under review",1.5,null,null,null,"Yes",2]
[null,null,null,null,"Never",0,null,"Yes incomplete",2,null,null,null,null,"Quarterly",3]
[null,null,null,null,"Quarterly",4]
[]
[]
[]
[]
[null,null,null,null,"Annually",3,null,"Not at all",0]
[null,null,null,null,"Every two years",1.5,null,"Yes reviewed and updated",3]
[null,null,null,null,"Not at all",0,null,"Yes under review",1.5]

{"sheet":"2.0","index":4,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[35,0,42,0],[35,1,42,1],[35,2,42,2],[11,0,18,0],[11,1,18,1],[11,2,18,2],[19,0,26,0],[19,1,26,1],[19,2,26,2],[0,3,0,10],[2,2,10,2],[27,0,34,0],[27,1,34,1],[27,2,34,2],[0,0,0,2],[2,0,10,0],[2,1,10,1]]}
["2.0 Human Capacity for M&E",null,null,"     • Defined skill set for individuals and organizations at subnational and service-delivery levels\n     • Work force development plan, including career paths for M&E\n     • Costed human capacity-building plan\n     • Standard curricula for organizational and technical capacity building\n     • Local or regional training capacity, including links to training institutions\n     • Supervision, in-service training, and mentoring"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Staff M&E skills and competencies","No","Status","M&E unit has staff to fulfill its mandate",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Staff at the M&E unit have qualifications that are  specific to M&E",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","Staff are able to package the data to support decision making",null,{"$f":"IF(G3=0,0,ROUND(IF(F5<>\"\",VLOOKUP(F5,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H5<>\"\",VLOOKUP(H5,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","Staff are able to collate, process, and analyze data",null,{"$f":"IF(G3=0,0,ROUND(IF(F6<>\"\",VLOOKUP(F6,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H6<>\"\",VLOOKUP(H6,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 4","Staff are able to collect, process, and analyze sex-disaggregated data and gender-sensitive data to analyze potential gender differences in health access/use/quality",null,{"$f":"IF(G3=0,0,ROUND(IF(F7<>\"\",VLOOKUP(F7,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H7<>\"\",VLOOKUP(H7,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 5","M&E staff can use GIS and/or other applications to produce simple graphics/map products",null,{"$f":"IF(G3=0,0,ROUND(IF(F8<>\"\",VLOOKUP(F8,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H8<>\"\",VLOOKUP(H8,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 6","Staff are appropriately trained to carry out tasks relating to assessment of data quality\n(completeness, timeliness, accuracy, reliability)",null,{"$f":"IF(G3=0,0,ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Technical autonomy","M&E staff rely on external M&E technical support on an ongoing basis to accomplish any of their routine M&E tasks",null,{"$f":"IF(G3=0,0,ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The government of [insert country name] supports training on issues regarding M&E",null,{"$f":"IF(G3=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[2,"Costed human capacity-building plan","No","Status","The human capacity building plan is costed",null,{"$f":"ROUND(IF(F12<>\"\",VLOOKUP(F12,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H12<>\"\",VLOOKUP(H12,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The identified gaps in M&E-related skills and competencies are incorporated into the human capacity-building plan",null,{"$f":"IF(G12=0,0,ROUND(IF(F13<>\"\",VLOOKUP(F13,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I12=0,0,ROUND(IF(H13<>\"\",VLOOKUP(H13,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","There is a mechanism to coordinate M&E human capacity building to avoid duplication",null,{"$f":"IF(G12=0,0,ROUND(IF(F14<>\"\",VLOOKUP(F14,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I12=0,0,ROUND(IF(H14<>\"\",VLOOKUP(H14,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Quality 4","N/A",null,0,null,0]
[null,null,null,"Quality 5","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[3,"Costed human capacity-building plan for organizational development (OD)","No","Status","The capacity-building plan for OD is costed",null,{"$f":"ROUND(IF(F20<>\"\",VLOOKUP(F20,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H20<>\"\",VLOOKUP(H20,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The identified gaps in OD-related skills and competencies are incorporated into the capacity-building plan",null,{"$f":"IF(G20=0,0,ROUND(IF(F21<>\"\",VLOOKUP(F21,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I20=0,0,ROUND(IF(H21<>\"\",VLOOKUP(H21,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","There is a mechanism to coordinate the OD capacity-building plan and activities  to avoid duplication",null,{"$f":"IF(G20=0,0,ROUND(IF(F22<>\"\",VLOOKUP(F22,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I20=0,0,ROUND(IF(H22<>\"\",VLOOKUP(H22,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Quality 4","N/A",null,0,null,0]
[null,null,null,"Quality 5","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[4,"Costed human capacity-building plan for data demand and information use (DDIU)","No","Status","The DDIU capacity-building plan is costed",null,{"$f":"ROUND(IF(F28<>\"\",VLOOKUP(F28,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H28<>\"\",VLOOKUP(H28,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The identified gaps in DDIU-related skills and competencies are incorporated into the capacity-building plan",null,{"$f":"IF(G28=0,0,ROUND(IF(F29<>\"\",VLOOKUP(F29,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I28=0,0,ROUND(IF(H29<>\"\",VLOOKUP(H29,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","There is a mechanism to coordinate the DDIU capacity-building plan and activities to avoid duplication",null,{"$f":"IF(G28=0,0,ROUND(IF(F30<>\"\",VLOOKUP(F30,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I28=0,0,ROUND(IF(H30<>\"\",VLOOKUP(H30,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Quality 4","N/A",null,0,null,0]
[null,null,null,"Quality 5","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[5,"Validated M&E training curriculum ","Yes","Status","M&E training curriculum is available",null,{"$f":"ROUND(IF(F36<>\"\",VLOOKUP(F36,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H36<>\"\",VLOOKUP(H36,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","M&E training curriculum is mostly implemented through linkages with colleges, universities, and technical schools",null,{"$f":"IF(G36=0,0,ROUND(IF(F37<>\"\",VLOOKUP(F37,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I36=0,0,ROUND(IF(H37<>\"\",VLOOKUP(H37,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","Printed copies of the M&E training curriculum are readily available",null,{"$f":"IF(G36=0,0,ROUND(IF(F38<>\"\",VLOOKUP(F38,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I36=0,0,ROUND(IF(H38<>\"\",VLOOKUP(H38,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","The M&E training curriculum includes a session or sub-session on gender in M&E","Yes mostly",{"$f":"IF(G36=0,0,ROUND(IF(F39<>\"\",VLOOKUP(F39,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I36=0,0,ROUND(IF(H39<>\"\",VLOOKUP(H39,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 4","N/A",null,0,null,0]
[null,null,null,"Quality 5","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The development and adoption of the M&E training curriculum relies on external technical support",null,{"$f":"IF(G36=0,0,ROUND(IF(F42<>\"\",VLOOKUP(F42,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I36=0,0,ROUND(IF(H42<>\"\",VLOOKUP(H42,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The development and adoption of the M&E training curriculum was supported with government of [insert country name] funds",null,{"$f":"IF(G36=0,0,ROUND(IF(F43<>\"\",VLOOKUP(F43,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I36=0,0,ROUND(IF(H43<>\"\",VLOOKUP(H43,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]

{"sheet":"3.0","index":5,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,3,0,10],[38,0,44,0],[38,1,44,1],[38,2,44,2],[45,0,46,0],[45,1,46,1],[45,2,46,2],[24,0,30,0],[24,1,30,1],[24,2,30,2],[31,0,37,0],[31,1,37,1],[31,2,37,2],[9,0,15,0],[9,1,15,1],[9,2,15,2],[16,0,23,0],[16,1,23,1],[16,2,23,2],[0,0,0,2],[2,0,8,0],[2,1,8,1],[2,2,8,2]]}
["3.0 Partnerships and Governance",null,null,"     • M&E technical working group\n     • Mechanism to coordinate all stakeholders\n     • Local leadership and capacity for stakeholder coordination\n     • Routine communication channel to facilitate exchange of information among stakeholders"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Strategy or policy to acknowledge and support M&E performance","Yes","Status","The organization has a strategy or policy in place to acknowledge and support good M&E performance and to help correct weak or incorrect M&E performance",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","When was the current strategy or policy reviewed?",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!X$68:Y$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!X$68:Y$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","N/A",null,0,null,0]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Quality 4","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The current strategy was reviewed with external technical support",null,{"$f":"IF(G3=0,0,ROUND(IF(F8<>\"\",VLOOKUP(F8,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H8<>\"\",VLOOKUP(H8,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The review of the strategy or policy was undertaken with financial support from the government of [insert country name]",null,{"$f":"IF(G3=0,0,ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[2,"Standard operating procedures that define roles and responsibilities related to M&E functions and activities","Yes","Status","Copies of standard operating procedures defining the roles and responsibilities exist",null,{"$f":"ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Standard operating procedures that define roles and responsibilities related to M&E functions and activities are known by staff ",null,{"$f":"IF(G10=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","Standard operating procedures  that define roles and responsibilities related to M&E functions and activities are adhered to",null,{"$f":"IF(G10=0,0,ROUND(IF(F12<>\"\",VLOOKUP(F12,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H12<>\"\",VLOOKUP(H12,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Quality 4","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","Standard operating procedures  that define roles and responsibilities related to M&E functions and activities were developed with external technical support",null,{"$f":"IF(G10=0,0,ROUND(IF(F15<>\"\",VLOOKUP(F15,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H15<>\"\",VLOOKUP(H15,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","Standard operating procedures that define roles and responsibilities related to M&E functions and activities were developed with financial assistance from the government of [insert country name]",null,{"$f":"IF(G10=0,0,ROUND(IF(F16<>\"\",VLOOKUP(F16,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H16<>\"\",VLOOKUP(H16,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[3,"M&E technical working  group (TWG)","Yes","Status","There is a TWG that meets to discuss the organization’s M&E issues",null,{"$f":"ROUND(IF(F17<>\"\",VLOOKUP(F17,'1.0'!V$68:W$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H17<>\"\",VLOOKUP(H17,'1.0'!V$68:W$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The TWG is composed  of relevant stakeholders ",null,{"$f":"IF(G17=0,0,ROUND(IF(F18<>\"\",VLOOKUP(F18,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I17=0,0,ROUND(IF(H18<>\"\",VLOOKUP(H18,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","How often does the organization's M&E TWG meet",null,{"$f":"IF(G17=0,0,ROUND(IF(F19<>\"\",VLOOKUP(F19,'1.0'!E$81:F$84,2),0)*2.5,2))","v":0},null,{"$f":"IF(I17=0,0,ROUND(IF(H19<>\"\",VLOOKUP(H19,'1.0'!E$81:F$84,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","Majority of members attend the TWG meetings ",null,{"$f":"IF(G17=0,0,ROUND(IF(F20<>\"\",VLOOKUP(F20,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I17=0,0,ROUND(IF(H20<>\"\",VLOOKUP(H20,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 4","There are terms of reference for the M&E TWG coordinated by the organization clarifying the TWG's role in approving documents, providing technical leadership, and coordinating the M&E system",null,{"$f":"IF(G17=0,0,ROUND(IF(F21<>\"\",VLOOKUP(F21,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I17=0,0,ROUND(IF(H21<>\"\",VLOOKUP(H21,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 5","Minutes from TWGs, including action points, are circulated to the members regularly",null,{"$f":"IF(G17=0,0,ROUND(IF(F22<>\"\",VLOOKUP(F22,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I17=0,0,ROUND(IF(H22<>\"\",VLOOKUP(H22,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Technical autonomy","The TWG meetings are coordinated with external technical support",null,{"$f":"IF(G17=0,0,ROUND(IF(F23<>\"\",VLOOKUP(F23,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I17=0,0,ROUND(IF(H23<>\"\",VLOOKUP(H23,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The TWG meetings are financially supported by the government of [insert country name]",null,{"$f":"IF(G17=0,0,ROUND(IF(F24<>\"\",VLOOKUP(F24,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I17=0,0,ROUND(IF(H24<>\"\",VLOOKUP(H24,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[4,"Commitment from stakeholders in the organization’s M&E activities and performance ",null,"Status","Key stakeholders participate in the TWG meetings",null,{"$f":"ROUND(IF(F25<>\"\",VLOOKUP(F25,'1.0'!H$68:I$71,2),0)*2.5,2)","v":0},null,{"$f":"ROUND(IF(H25<>\"\",VLOOKUP(H25,'1.0'!H$68:I$71,2),0)*2.5,2)","v":0}]
[null,null,null,"Quality 1","M&E is discussed as a standing agenda item in other program areas",null,{"$f":"IF(G25=0,0,ROUND(IF(F26<>\"\",VLOOKUP(F26,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I25=0,0,ROUND(IF(H26<>\"\",VLOOKUP(H26,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","N/A",null,0,null,0]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Quality 4","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[5,"Updated inventory of M&E stakeholders for the organization","Yes","Status","An inventory of M&E stakeholders for the organization is available",null,{"$f":"ROUND(IF(F32<>\"\",VLOOKUP(F32,'1.0'!X$79:Y$81,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H32<>\"\",VLOOKUP(H32,'1.0'!X$79:Y$81,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The structured database of stakeholders is complete (organization profile, physical, telephone, email contact, contact person)",null,{"$f":"IF(G32=0,0,ROUND(IF(F33<>\"\",VLOOKUP(F33,'1.0'!H$81:I$84,2),0)*2.5,2))","v":0},null,{"$f":"IF(I32=0,0,ROUND(IF(H33<>\"\",VLOOKUP(H33,'1.0'!H$81:I$84,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","The  inventory of M&E stakeholders for the organization is periodically updated",null,{"$f":"IF(G32=0,0,ROUND(IF(F34<>\"\",VLOOKUP(F34,'1.0'!E$89:F$91,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I32=0,0,ROUND(IF(H34<>\"\",VLOOKUP(H34,'1.0'!E$89:F$91,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Quality 4","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The inventory of stakeholders (database) was developed with external technical support",null,{"$f":"IF(G32=0,0,ROUND(IF(F37<>\"\",VLOOKUP(F37,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I32=0,0,ROUND(IF(H37<>\"\",VLOOKUP(H37,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The inventory of stakeholders (database) was prepared with financial support from the government of [insert country name]",null,{"$f":"IF(G32=0,0,ROUND(IF(F38<>\"\",VLOOKUP(F38,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I32=0,0,ROUND(IF(H38<>\"\",VLOOKUP(H38,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[6,"Clear mechanisms (e.g., feedback reports, newsletters) to communicate M&E activities and decisions","Yes","Status","Clear mechanisms (e.g., feedback reports, newsletters) to communicate about M&E activities and decisions exist",null,{"$f":"ROUND(IF(F39<>\"\",VLOOKUP(F39,'1.0'!H$68:I$71,2),0)*2.5,2)","v":0},null,{"$f":"ROUND(IF(H39<>\"\",VLOOKUP(H39,'1.0'!H$68:I$71,2),0)*2.5,2)","v":0}]
[null,null,null,"Quality 1","There are regular M&E-related meetings for the  stakeholders  ",null,{"$f":"IF(G39=0,0,ROUND(IF(F40<>\"\",VLOOKUP(F40,'1.0'!N$80:O$83,2),0)*2.5,2))","v":0},null,{"$f":"IF(I39=0,0,ROUND(IF(H40<>\"\",VLOOKUP(H40,'1.0'!N$80:O$83,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","The meeting to communicate M&E activities and decisions involves relevant staff stakeholders",null,{"$f":"IF(G39=0,0,ROUND(IF(F41<>\"\",VLOOKUP(F41,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I39=0,0,ROUND(IF(H41<>\"\",VLOOKUP(H41,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","The organization, in partnership with stakeholders, has structures, mechanisms, procedures, and a timeframe for transmitting, entering, extracting, merging, and transferring data between databases used by the organization and other existing Ministry of Health databases",null,{"$f":"IF(G39=0,0,ROUND(IF(F42<>\"\",VLOOKUP(F42,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I39=0,0,ROUND(IF(H42<>\"\",VLOOKUP(H42,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 4","M&E-related communication products (newsletters, bulletin) and decisions are shared in a timely manner with relevant stakeholders ",null,{"$f":"IF(G39=0,0,ROUND(IF(F43<>\"\",VLOOKUP(F43,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I39=0,0,ROUND(IF(H43<>\"\",VLOOKUP(H43,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Technical Autonomy","The communication systems and mechanisms are implemented with external technical support",null,{"$f":"IF(G39=0,0,ROUND(IF(F44<>\"\",VLOOKUP(F44,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I39=0,0,ROUND(IF(H44<>\"\",VLOOKUP(H44,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial Autonomy","The communication systems and mechanisms are implemented with financial support by the government of [insert country name]",null,{"$f":"IF(G39=0,0,ROUND(IF(F45<>\"\",VLOOKUP(F45,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I39=0,0,ROUND(IF(H45<>\"\",VLOOKUP(H45,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[7,"M&E unit supports other program functional areas",null,"Status","M&E unit supports other program functional areas",null,{"$f":"ROUND(IF(F46<>\"\",VLOOKUP(F46,'1.0'!H$68:I$71,2),0)*2.5,2)","v":0},null,{"$f":"ROUND(IF(H46<>\"\",VLOOKUP(H46,'1.0'!H$68:I$71,2),0)*2.5,2)","v":0}]
[null,null,null,"Financial Autonomy","N/A","N/A",0]

{"sheet":"4.0","index":6,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[28,0,33,0],[28,1,33,1],[28,2,33,2],[10,0,15,0],[10,1,15,1],[10,2,15,2],[16,0,21,0],[16,1,21,1],[16,2,21,2],[0,3,0,10],[2,2,9,2],[22,0,27,0],[22,1,27,1],[22,2,27,2],[0,0,0,2],[2,0,9,0],[2,1,9,1]]}
["4.0  Organization M&E Plan",null,null,"     • Broad-based participation in developing the organizational M&E plan\n     • Explicitly linked to the Health Sector or Multi-Sector Strategic Plan at the subnational/national levels, if applicable\n     • The M&E plan adheres to national technical standards \n     • An M&E system assessment has been completed and recommendations for system strengthening have been addressed in a revised M&E plan"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Ability of the organization to prepare accurate annual work plans, budgets, and schedules","No","Status","The current annual work plan is available",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The current annual work plan is reviewed and in line with government planning cycles",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","The current annual work plan includes a monitoring and evaluation framework with results and activities",null,{"$f":"IF(G3=0,0,ROUND(IF(F5<>\"\",VLOOKUP(F5,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H5<>\"\",VLOOKUP(H5,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","The current annual work plan feeds into the organization's M&E plan and strategic plan",null,{"$f":"IF(G3=0,0,ROUND(IF(F6<>\"\",VLOOKUP(F6,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H6<>\"\",VLOOKUP(H6,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 4","The budget monitoring process includes request date, responses, date, and percentage of requested funding received, etc.",null,{"$f":"IF(G3=0,0,ROUND(IF(F7<>\"\",VLOOKUP(F7,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H7<>\"\",VLOOKUP(H7,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 5","The total budget cost for last year’s M&E planned activities was achieved",null,{"$f":"IF(G3=0,0,ROUND(IF(F8<>\"\",VLOOKUP(F8,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H8<>\"\",VLOOKUP(H8,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Technical autonomy","The current project annual work plan was developed with external technical assistance",null,{"$f":"IF(G3=0,0,ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The current  project annual work plan was developed with financial support from the government of [insert country name]",null,{"$f":"IF(G3=0,0,ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[2,"Clear guidelines with dates specifying when information or reports need to be both received and distributed by the organization","Yes","Status","Clear  guidelines specifying when information or reports need to be  received and distributed exist",null,{"$f":"ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The M&E staff are aware of guidelines  specifying when information or reports need to be both received and distributed",null,{"$f":"IF(G11=0,0,ROUND(IF(F12<>\"\",VLOOKUP(F12,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I11=0,0,ROUND(IF(H12<>\"\",VLOOKUP(H12,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","Information and data are received as per the stipulated guidelines",null,{"$f":"IF(G11=0,0,ROUND(IF(F13<>\"\",VLOOKUP(F13,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I11=0,0,ROUND(IF(H13<>\"\",VLOOKUP(H13,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3"," Relevant staff at the M&E unit have skills to carry out the tasks relating to compilation and processing of information needs of the organization",null,{"$f":"IF(G11=0,0,ROUND(IF(F14<>\"\",VLOOKUP(F14,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I11=0,0,ROUND(IF(H14<>\"\",VLOOKUP(H14,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[3,"National multi-sectoral M&E plan","Yes","Status","There is a national multi-sectoral M&E plan",null,{"$f":"ROUND(IF(F17<>\"\",VLOOKUP(F17,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H17<>\"\",VLOOKUP(H17,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Unit-specific M&E plans are linked to the multi-sectoral  M&E plan",null,{"$f":"IF(G17=0,0,ROUND(IF(F18<>\"\",VLOOKUP(F18,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I17=0,0,ROUND(IF(H18<>\"\",VLOOKUP(H18,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","M&E unit actively participated in the development of the current national multi-sectoral M&E plan",null,{"$f":"IF(G17=0,0,ROUND(IF(F19<>\"\",VLOOKUP(F19,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I17=0,0,ROUND(IF(H19<>\"\",VLOOKUP(H19,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[4,"M&E plan for the organization","Yes","Status","There is a reviewed and updated M&E plan for the organization",null,{"$f":"ROUND(IF(F23<>\"\",VLOOKUP(F23,'1.0'!H$89:I$91,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H23<>\"\",VLOOKUP(H23,'1.0'!H$89:I$91,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The set of indicators in the M&E plan were assessed during the development of the M&E plan before finalization (against national indicator standards)",null,{"$f":"IF(G23=0,0,ROUND(IF(F24<>\"\",VLOOKUP(F24,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I23=0,0,ROUND(IF(H24<>\"\",VLOOKUP(H24,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","N/A",null,0,null,0]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The M&E plan was developed with external technical assistance",null,{"$f":"IF(G23=0,0,ROUND(IF(F27<>\"\",VLOOKUP(F27,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I23=0,0,ROUND(IF(H27<>\"\",VLOOKUP(H27,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The M&E plan was developed with financial support from the government of [insert country name]",null,{"$f":"IF(G23=0,0,ROUND(IF(F28<>\"\",VLOOKUP(F28,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I23=0,0,ROUND(IF(H28<>\"\",VLOOKUP(H28,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[5," M&E system assessment (gap analysis, mid-term reviews)","Yes","Status","The current M&E system has been assessed",null,{"$f":"ROUND(IF(F29<>\"\",VLOOKUP(F29,'1.0'!Q$80:R$82,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H29<>\"\",VLOOKUP(H29,'1.0'!Q$80:R$82,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Findings from the system assessment have been included in the M&E plan",null,{"$f":"IF(G29=0,0,ROUND(IF(F30<>\"\",VLOOKUP(F30,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I29=0,0,ROUND(IF(H30<>\"\",VLOOKUP(H30,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","N/A",null,0,null,0]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The M&E system assessment was done with external technical support",null,{"$f":"IF(G29=0,0,ROUND(IF(F33<>\"\",VLOOKUP(F33,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I29=0,0,ROUND(IF(H33<>\"\",VLOOKUP(H33,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The M&E system assessment  was supported financially by the government of [insert country name]",null,{"$f":"IF(G29=0,0,ROUND(IF(F34<>\"\",VLOOKUP(F34,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I29=0,0,ROUND(IF(H34<>\"\",VLOOKUP(H34,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]

{"sheet":"5.0","index":7,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,0,11,0],[8,1,11,1],[8,2,11,2],[12,0,17,0],[12,1,17,1],[12,2,17,2],[0,0,0,2],[2,0,7,0],[2,1,7,1],[2,2,7,2],[0,3,0,10]]}
["5.0 Annual Costed Health Sector M&E Work Plan",null,null,"     • The M&E work plan contains activities, responsible implementers, timeframe, activity costs, and identified funding.\n     • The M&E work plan explicitly links to the annual work plans and government Medium-Term Expenditure Framework budgets.\n     • Resources (human, physical, financial) are committed to implement the M&E work plan.\n     • All relevant stakeholders endorsed the M&E work plan.\n     •The M&E work plan is updated annually based on performance monitoring."]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Costed M&E activities with identified sources of funding in the annual work plan","Yes","Status","The current M&E work plan and activities are costed",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!T$80:U$81,2),0)*5,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!T$80:U$81,2),0)*5,2)","v":0}]
[null,null,null,"Quality 1","The M&E plan clearly identifies activities, responsible implementers, timeframe, activity costs, and sources of funding",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","N/A",null,0,null,0]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[2,"M&E work plan is linked to the Medium-Term Expenditure Framework  ","Yes","Status","The current M&E work plan is linked to the Medium-Term Expenditure Framework budgets ",null,{"$f":"ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!T$80:U$81,2),0)*5,2)","v":0},null,{"$f":"ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!T$80:U$81,2),0)*5,2)","v":0}]
[null,null,null,"Quality 1","Activities in the M&E work plan are allocated and have specific time frames for implementation",null,{"$f":"IF(G9=0,0,ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!T$80:U$81,2),0)*5,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!T$80:U$81,2),0)*5,2))","v":0}]
[null,null,null,"Quality 2","The current M&E work plan has been updated based on performance monitoring ",null,{"$f":"IF(G9=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!T$80:U$81,2),0)*5,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!T$80:U$81,2),0)*5,2))","v":0}]
[null,null,null,"Quality 3","The current M&E work plan has been endorsed by relevant stakeholders",null,{"$f":"IF(G9=0,0,ROUND(IF(F12<>\"\",VLOOKUP(F12,'1.0'!T$80:U$81,2),0)*5,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H12<>\"\",VLOOKUP(H12,'1.0'!T$80:U$81,2),0)*5,2))","v":0}]
[3,"Committed resources to implement the M&E work plan","No","Status","Specific resources (human, financial, and physical) have been committed to implement the M&E work plan",null,{"$f":"ROUND(IF(F13<>\"\",VLOOKUP(F13,'1.0'!T$80:U$81,2),0)*5,2)","v":0},null,{"$f":"ROUND(IF(H13<>\"\",VLOOKUP(H13,'1.0'!T$80:U$81,2),0)*5,2)","v":0}]
[null,null,null,"Quality 1","The committed resources are adequate to implement the M&E work plan",null,{"$f":"IF(G13=0,0,ROUND(IF(F14<>\"\",VLOOKUP(F14,'1.0'!T$80:U$81,2),0)*5,2))","v":0},null,{"$f":"IF(I13=0,0,ROUND(IF(H14<>\"\",VLOOKUP(H14,'1.0'!T$80:U$81,2),0)*5,2))","v":0}]
[null,null,null,"Quality 2","N/A",null,0,null,0]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","The committed resources to implement the M&E work plan are financed by the government of [insert country name]",null,{"$f":"IF(G13=0,0,ROUND(IF(F18<>\"\",VLOOKUP(F18,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I13=0,0,ROUND(IF(H18<>\"\",VLOOKUP(H18,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]

{"sheet":"6.0","index":8,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,0,13,0],[8,1,13,1],[8,2,13,2],[14,0,19,0],[14,1,19,1],[14,2,19,2],[0,0,0,2],[2,0,7,0],[2,1,7,1],[2,2,7,2],[0,3,0,10]]}
["6.0 Advocacy, Communication, and Cultural Behavior",null,null,"     • The communication strategy includes a specific M&E communication and advocacy plan.\n     • M&E is explicitly referenced in the integrated development plans or multi-sector development plans.\n     • M&E champions among the organization's officials are identified and are actively endorsing M&E actions.\n     • M&E advocacy activities are implemented according to the M&E advocacy plan."]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"M&E champions ","No","Status","There are people who strongly advocate for and support M&E for the organization",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The organizational leadership supports  the M&E activities",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","There is an M&E champion who can advocate for attention to gender in analysis, reporting, and use of sex-disaggregated and gender-sensitive data",null,{"$f":"IF(G3=0,0,ROUND(IF(F5<>\"\",VLOOKUP(F5,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H5<>\"\",VLOOKUP(H5,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[2,"Communication strategy","Yes","Status","The organization has a specific communication strategy",null,{"$f":"ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The communication strategy addresses all aspects of the organization's activities",null,{"$f":"IF(G9=0,0,ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","There is a focal person or team in charge of advocacy, communication, and social mobilization ",null,{"$f":"IF(G9=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","The focal person or team has terms of reference that outline how communication should be conducted",null,{"$f":"IF(G9=0,0,ROUND(IF(F12<>\"\",VLOOKUP(F12,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H12<>\"\",VLOOKUP(H12,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Technical autonomy","The organization's communication strategy was developed with external technical support",null,{"$f":"IF(G9=0,0,ROUND(IF(F13<>\"\",VLOOKUP(F13,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H13<>\"\",VLOOKUP(H13,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The organization's communication strategy was implemented with financial support from the government of [insert country name]",null,{"$f":"IF(G9=0,0,ROUND(IF(F14<>\"\",VLOOKUP(F14,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H14<>\"\",VLOOKUP(H14,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[3,"M&E strategies and products are included in the [national or subnational] strategic plan","Yes","Status","The M&E strategies and products are included in the [national or subnational] strategic plan",null,{"$f":"ROUND(IF(F15<>\"\",VLOOKUP(F15,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H15<>\"\",VLOOKUP(H15,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1",null,"N/A",0]
[null,null,null,"Quality 2",null,"N/A",0]
[null,null,null,"Quality 3","N/A","N/A",0]
[null,null,null,"Technical Autonomy","N/A","N/A",0]
[null,null,null,"Financial Autonomy","N/A","N/A",0]

{"sheet":"7.0","index":9,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,3,0,10],[2,2,8,2],[0,0,0,2],[9,0,16,0],[9,1,16,1],[9,2,16,2],[2,0,8,0],[2,1,8,1]]}
["7.0 Routine Monitoring",null,null,"     • Data collection strategy explicitly linked to data use\n     • Clearly defined data collection, transfer, and reporting mechanisms, including collaboration and coordination among stakeholders\n     • Essential tools and equipment for data management (e.g., collection, transfer, storage, analysis)\n     • Routine procedures for data transfer from different reporting levels"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Essential tools and equipment for data management (e.g., collection, transfer, storage, analysis)","Yes","Status","Essential tools and equipment for data management are available",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","All tiers use standardized data collection forms",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","The tools capture essential indicators  for routine performance monitoring",null,{"$f":"IF(G3=0,0,ROUND(IF(F5<>\"\",VLOOKUP(F5,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H5<>\"\",VLOOKUP(H5,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","The organization has identified gaps in the existing tools that need to be updated",null,{"$f":"IF(G3=0,0,ROUND(IF(F6<>\"\",VLOOKUP(F6,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H6<>\"\",VLOOKUP(H6,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 4","The identified gaps have been resolved in the DHIS 2 or unified national database for health data",null,{"$f":"IF(G3=0,0,ROUND(IF(F7<>\"\",VLOOKUP(F7,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H7<>\"\",VLOOKUP(H7,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Technical autonomy","Essential tools  were developed with  external technical assistance ",null,{"$f":"IF(G3=0,0,ROUND(IF(F8<>\"\",VLOOKUP(F8,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H8<>\"\",VLOOKUP(H8,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","Essential tools  were developed with financial support from the government of [insert country name]",null,{"$f":"IF(G3=0,0,ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[2,"M&E guidelines to document procedures for collecting, recording, collating, and reporting routine program data ","Yes","Status","There are M&E guidelines to document the procedures for recording, collecting, collating, and reporting  routine data from the health information system",null,{"$f":"ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The organization conforms to the national best practices on collecting, recording, collating, and reporting routine program data",null,{"$f":"IF(G10=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2",null,null,{"$f":"IF(G10=0,0,ROUND(IF(F12<>\"\",VLOOKUP(F12,'1.0'!X$68:Y$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(G10=0,0,ROUND(IF(F12<>\"\",VLOOKUP(F12,'1.0'!X$68:Y$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 2","The organization's  M&E plan includes activities for gender-based analysis",null,{"$f":"IF(G10=0,0,ROUND(IF(F13<>\"\",VLOOKUP(F13,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H13<>\"\",VLOOKUP(H13,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","When was the current M&E guideline customized or adapted?",null,{"$f":"IF(G10=0,0,ROUND(IF(F14<>\"\",VLOOKUP(F14,'1.0'!X$68:Y$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H14<>\"\",VLOOKUP(H14,'1.0'!X$68:Y$71,2),0)*2.5,2))","v":0}]
[null,null,null,"Technical autonomy","The guidelines were customized or adapted for the organization with external technical assistance",null,{"$f":"IF(G10=0,0,ROUND(IF(F15<>\"\",VLOOKUP(F15,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H15<>\"\",VLOOKUP(H15,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The guidelines were customized or adapted with financial support from the  government of [insert country name]",null,{"$f":"IF(G10=0,0,ROUND(IF(F16<>\"\",VLOOKUP(F16,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H16<>\"\",VLOOKUP(H16,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial Autonomy","The national guidelines were county adpated with financial support of GoK",null,{"$f":"IF(G10=0,0,ROUND(IF(F17<>\"\",VLOOKUP(F17,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]

{"sheet":"8.0","index":10,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,0,13,0],[8,1,13,1],[8,2,13,2],[14,0,19,0],[14,1,19,1],[14,2,19,2],[0,0,0,2],[2,0,7,0],[2,1,7,1],[2,2,7,2],[0,3,0,10]]}
["8.0 Surveys and Surveillance",null,null,"     • Protocols for all surveys and surveillance based on international standards\n     • Specified schedule for data collection linked to stakeholders’ needs, including identification of resources for implementation\n     • Inventory of surveys conducted\n     • Well-functioning surveillance system"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Survey and surveillance inventory","Yes","Status","An inventory of surveys and surveillance activities for the organization is available",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The current inventory of surveys and surveillance activities conducted or planned in the organization is up to date ",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","The inventory is used to track surveys and surveillance activities in the organization",null,{"$f":"IF(G3=0,0,ROUND(IF(F5<>\"\",VLOOKUP(F5,'1.0'!H$68:I$71,2),0)*2.5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H5<>\"\",VLOOKUP(H5,'1.0'!Q$68:R$70,2),0)*2.5,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The current inventory of surveys and surveillance activities was developed with external technical assistance",null,{"$f":"IF(G3=0,0,ROUND(IF(F7<>\"\",VLOOKUP(F7,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H7<>\"\",VLOOKUP(H7,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The current inventory of surveys and surveillance activities was developed with financial support from the government of [insert country name]",null,{"$f":"IF(G3=0,0,ROUND(IF(F8<>\"\",VLOOKUP(F8,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H8<>\"\",VLOOKUP(H8,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[2,"Protocols for surveys and surveillance ","Yes","Status","Protocols for surveys and surveillance activities undertaken in the organization in the past year are available",null,{"$f":"ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Protocols for surveys and surveillance undertaken in the organization are approved by accredited bodies",null,{"$f":"IF(G9=0,0,ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","Surveys and surveillance activities involve relevant stakeholders in the M&E technical working group or relevant technical bodies",null,{"$f":"IF(G9=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[3,"Functioning surveillance system ","Yes","Status","There is a functioning surveillance system",null,{"$f":"ROUND(IF(F15<>\"\",VLOOKUP(F15,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H15<>\"\",VLOOKUP(H15,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The surveillance system helps the organization undertake functions related to detection and notification, reporting,\nand feedback\n",null,{"$f":"IF(G15=0,0,ROUND(IF(F16<>\"\",VLOOKUP(F16,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H16<>\"\",VLOOKUP(H16,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","N/A",null,0,null,0]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The surveillance system was developed with external technical assistance",null,{"$f":"IF(G15=0,0,ROUND(IF(F19<>\"\",VLOOKUP(F19,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H19<>\"\",VLOOKUP(H19,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The surveillance system was developed with financial support from the government of [insert country name]",null,{"$f":"IF(G15=0,0,ROUND(IF(F20<>\"\",VLOOKUP(F20,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H20<>\"\",VLOOKUP(H20,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]

{"sheet":"9.0","index":11,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,3,0,10],[9,0,15,0],[9,1,15,1],[9,2,15,2],[0,0,0,2],[2,0,8,0],[2,1,8,1],[2,2,8,2]]}
["9.0 National and Subnational Databases",null,null,"     • Databases designed to respond to the decision-making and reporting needs of different stakeholders\n     • Linkages between different relevant databases to ensure data consistency and avoid duplication of effort\n     • Well-defined and managed database to capture, verify, analyze, and present data from all levels and sectors"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Databases for electronically capturing and storing data generated for and by the M&E system ","No","Status","There is a well-defined and managed integrated database for electronically capturing and storing data generated for/by the national M&E system","N/A",0]
[null,null,null,"Quality 1","The database for capturing and storing data is up to date",null,{"$f":"ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 2","The database captures all data elements required by the organization's M&E system",null,{"$f":"ROUND(IF(F5<>\"\",VLOOKUP(F5,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H5<>\"\",VLOOKUP(H5,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 3","IT equipment and supplies are available for linking to databases",null,{"$f":"ROUND(IF(F6<>\"\",VLOOKUP(F6,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H6<>\"\",VLOOKUP(H6,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 4","Structures, mechanisms, procedures, and timeframe for transmitting, entering, extracting, merging, and transferring data between databases that support the organization's health information system are available",null,{"$f":"ROUND(IF(F7<>\"\",VLOOKUP(F7,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H7<>\"\",VLOOKUP(H7,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[2,"Databases are linked","No","Status","Linkages exist between databases",null,{"$f":"ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!Q$68:R$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Design of databases  is informed by demands of the users",null,{"$f":"IF(G10=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","The organization is able to generate routine monitoring reports using the linked databases ",null,{"$f":"IF(G10=0,0,ROUND(IF(F12<>\"\",VLOOKUP(F12,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H12<>\"\",VLOOKUP(H12,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Quality 4","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","Design of the databases was supported with external technical assistance",null,{"$f":"IF(G10=0,0,ROUND(IF(F15<>\"\",VLOOKUP(F15,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H15<>\"\",VLOOKUP(H15,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","Design of the databases was financially supported by the government of [insert country name]",null,{"$f":"IF(G10=0,0,ROUND(IF(F16<>\"\",VLOOKUP(F16,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I10=0,0,ROUND(IF(H16<>\"\",VLOOKUP(H16,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]

{"sheet":"10.0","index":12,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,3,0,10],[8,0,13,0],[8,1,13,1],[8,2,13,2],[0,0,0,2],[2,0,7,0],[2,1,7,1],[2,2,7,2]]}
["10.0 Supervision and Auditing",null,null,"     • Guidelines for supervising routine data collection at facility- and community-based levels\n     • Routine supervision visits, including data assessments and feedback to local staff\n     • Periodic data quality audits\n     • Supervision reports and audit reports"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Guidelines and tools for supportive supervision","Yes","Status","Guidelines and tools for supportive supervision are available",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The supportive supervision guidelines and tools include a planning tool, a supervision checklist, a scoring mechanism, and a structured report and feedback and action plan",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","The last supportive supervision was conducted in accordance with the current guidelines",null,{"$f":"IF(G3=0,0,ROUND(IF(F5<>\"\",VLOOKUP(F5,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H5<>\"\",VLOOKUP(H5,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The supportive supervision guidelines and tools were developed with external technical support",null,{"$f":"IF(G3=0,0,ROUND(IF(F7<>\"\",VLOOKUP(F7,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H7<>\"\",VLOOKUP(H7,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The supportive supervision guidelines and tools were developed with financial support from the government of [insert country name]",null,{"$f":"IF(G3=0,0,ROUND(IF(F8<>\"\",VLOOKUP(F8,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H8<>\"\",VLOOKUP(H8,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[2,"Data quality audit","Yes","Status","Policy, procedures, and tools for data quality audits are available",null,{"$f":"ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Data quality audits are conducted as per the stipulated policy and procedures ",null,{"$f":"IF(G9=0,0,ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","The findings from the data quality audit are shared with stakeholders",null,{"$f":"IF(G9=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The last data quality audit was conducted with external technical support",null,{"$f":"IF(G9=0,0,ROUND(IF(F13<>\"\",VLOOKUP(F13,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H13<>\"\",VLOOKUP(H13,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The last data quality audit was conducted with financial support from the government of [insert country name]",null,{"$f":"IF(G9=0,0,ROUND(IF(F14<>\"\",VLOOKUP(F14,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H14<>\"\",VLOOKUP(H14,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]

{"sheet":"11.0","index":13,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,0,13,0],[8,1,13,1],[8,2,13,2],[14,0,19,0],[14,1,19,1],[14,2,19,2],[0,0,0,2],[2,0,7,0],[2,1,7,1],[2,2,7,2],[0,3,0,10]]}
["11.0 Evaluation and Research",null,null,"     • Inventory of completed and ongoing organization-specific evaluation and research studies\n     • Inventory of local evaluation and research capacity, including major research institutions and their focus of work\n     • Evaluation and research agenda\n     • Guidance on evaluation and research standards and appropriate methods\n     • Forums for dissemination and discussion of research and evaluation findings"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"An inventory/register/database of institutions undertaking research and evaluation ","Yes","Status","There is an inventory/register/database  relevant to the organization to undertake research and evaluation",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!X$79:Y$81,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!X$79:Y$81,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","There is an  inventory/register/database that is complete (organization profile, physical address, telephone, email contact, contact person)",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","The inventory/register/database includes research activities conducted or planned",null,{"$f":"IF(G3=0,0,ROUND(IF(F5<>\"\",VLOOKUP(F5,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H5<>\"\",VLOOKUP(H5,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","There is a mechanism for including new  institutions  or entrants undertaking research and evaluation ",null,{"$f":"IF(G3=0,0,ROUND(IF(F6<>\"\",VLOOKUP(F6,'1.0'!V$81:W$82,2),0)*5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H6<>\"\",VLOOKUP(H6,'1.0'!V$81:W$82,2),0)*5,2))","v":0}]
[null,null,null,"Technical autonomy","The inventory/register/ database of  research and evaluation was developed with external technical support",null,{"$f":"IF(G3=0,0,ROUND(IF(F7<>\"\",VLOOKUP(F7,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H7<>\"\",VLOOKUP(H7,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The inventory/register/ database of research and evaluation was prepared with financial support from the government of [insert country name]",null,{"$f":"IF(G3=0,0,ROUND(IF(F8<>\"\",VLOOKUP(F8,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H8<>\"\",VLOOKUP(H8,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[2,"Organization-specific research agenda ","Yes","Status","Organization-specific research agenda exists",null,{"$f":"ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The research agenda is relevant to the needs of the organization",null,{"$f":"IF(G9=0,0,ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","The research agenda is approved by M&E technical working group stakeholders",null,{"$f":"IF(G9=0,0,ROUND(IF(F11<>\"\",VLOOKUP(F11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H11<>\"\",VLOOKUP(H11,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical Autonomy","N/A",null,0,null,0]
[null,null,null,"Financial Autonomy","N/A",null,0,null,0]
[3,"Forums for dissemination and discussion of research findings","No","Status","There are organizational forums for dissemination and discussion of research findings",null,{"$f":"ROUND(IF(F15<>\"\",VLOOKUP(F15,'1.0'!T$80:U$81,2),0)*5,2)","v":0},null,{"$f":"ROUND(IF(H15<>\"\",VLOOKUP(H15,'1.0'!T$80:U$81,2),0)*5,2)","v":0}]
[null,null,null,"Quality 1","The forums bring in key stakeholders in M&E",null,{"$f":"IF(G15=0,0,ROUND(IF(F16<>\"\",VLOOKUP(F16,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H16<>\"\",VLOOKUP(H16,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","The agendas of the forums are guided by the needs of the organization",null,{"$f":"IF(G15=0,0,ROUND(IF(F17<>\"\",VLOOKUP(F17,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H17<>\"\",VLOOKUP(H17,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","The deliberations from the forums identify clear action plans for the organization",null,{"$f":"IF(G15=0,0,ROUND(IF(F18<>\"\",VLOOKUP(F18,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H18<>\"\",VLOOKUP(H18,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Technical autonomy","The forums are organized with external technical assistance",null,{"$f":"IF(G15=0,0,ROUND(IF(F19<>\"\",VLOOKUP(F19,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H19<>\"\",VLOOKUP(H19,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The forums are funded by the government of [insert country name]",null,{"$f":"IF(G15=0,0,ROUND(IF(F20<>\"\",VLOOKUP(F20,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H20<>\"\",VLOOKUP(H20,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]

{"sheet":"12.0","index":14,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,0,13,0],[8,1,13,1],[8,2,13,2],[14,0,19,0],[14,1,19,1],[14,2,19,2],[0,0,0,2],[2,0,7,0],[2,1,7,1],[2,2,7,2],[0,3,0,10]]}
["12.0 Data Demand and Use",null,null,"     • The organization's strategic plan and the M&E plan include a data use plan \n     • Analysis of organizational data needs and data users\n     • A data use plan to guide evidence-based decision-making processes\n     • Evidence of information use (e.g., data referenced in funding proposals and planning documents)  \n     • Interventions that increase local demand for information and facilitate its use\n     • M&E materials are available that target different audiences and support data sharing and use"]
["#","Element","Supporting documentation required","Question type","Question","Baseline score","Baseline rank","End line score","End line rank","Baseline comments","End line comments"]
[1,"Organization data use plan","Yes","Status","An organization data use plan exists",null,{"$f":"ROUND(IF(F3<>\"\",VLOOKUP(F3,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H3<>\"\",VLOOKUP(H3,'1.0'!N$68:O$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","The data use plan is embedded in the organization strategic plan and M&E plan",null,{"$f":"IF(G3=0,0,ROUND(IF(F4<>\"\",VLOOKUP(F4,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H4<>\"\",VLOOKUP(H4,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","The data use plan conforms to best practices on collecting, recording, collating, analysis, and reporting",null,{"$f":"IF(G3=0,0,ROUND(IF(F5<>\"\",VLOOKUP(F5,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H5<>\"\",VLOOKUP(H5,'1.0'!Q$68:R$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","The data use plan is informed by an assessment of user needs",null,{"$f":"IF(G3=0,0,ROUND(IF(F6<>\"\",VLOOKUP(F6,'1.0'!T$80:U$81,2),0)*5,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H6<>\"\",VLOOKUP(H6,'1.0'!T$80:U$81,2),0)*5,2))","v":0}]
[null,null,null,"Technical autonomy","The data use plan was developed with external technical assistance",null,{"$f":"IF(G3=0,0,ROUND(IF(F7<>\"\",VLOOKUP(F7,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H7<>\"\",VLOOKUP(H7,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The data use plan was developed with support from the government of [insert country name]",null,{"$f":"IF(G3=0,0,ROUND(IF(F8<>\"\",VLOOKUP(F8,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I3=0,0,ROUND(IF(H8<>\"\",VLOOKUP(H8,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[2,"Dissemination of information products","No","Status","The organization disseminates information products to stakeholders, Ministry of Health data users, and producers",null,{"$f":"ROUND(IF(F9<>\"\",VLOOKUP(F9,'1.0'!E$68:F$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H9<>\"\",VLOOKUP(H9,'1.0'!E$68:F$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Information products have contributed to influence policy and practice\n(generated from routine data, surveys, surveillance, and research activities)",null,{"$f":"IF(G9=0,0,ROUND(IF(F10<>\"\",VLOOKUP(F10,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H10<>\"\",VLOOKUP(H10,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2",null,null,0,null,0]
[null,null,null,"Quality 3","N/A",null,0,null,0]
[null,null,null,"Technical autonomy","The information products are disseminated with external technical assistance",null,{"$f":"IF(G9=0,0,ROUND(IF(F13<>\"\",VLOOKUP(F13,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H13<>\"\",VLOOKUP(H13,'1.0'!Q$74:R$76,2),0)*3.3333,2))","v":0}]
[null,null,null,"Financial autonomy","The information products are disseminated with support from the government of [insert country name]",null,{"$f":"IF(G9=0,0,ROUND(IF(F14<>\"\",VLOOKUP(F14,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I9=0,0,ROUND(IF(H14<>\"\",VLOOKUP(H14,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[3,"Data analysis and presentation guidelines","Yes","Status","Data analysis and presentation guidelines exist",null,{"$f":"ROUND(IF(F15<>\"\",VLOOKUP(F15,'1.0'!E$68:F$70,2),0)*3.3333,2)","v":0},null,{"$f":"ROUND(IF(H15<>\"\",VLOOKUP(H15,'1.0'!E$68:F$70,2),0)*3.3333,2)","v":0}]
[null,null,null,"Quality 1","Staff know and apply these guidelines",null,{"$f":"IF(G15=0,0,ROUND(IF(F16<>\"\",VLOOKUP(F16,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H16<>\"\",VLOOKUP(H16,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 2","Gender analysis and reporting is included as an element of the data analysis and presentation guidelines",null,{"$f":"IF(G15=0,0,ROUND(IF(F17<>\"\",VLOOKUP(F17,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0},null,{"$f":"IF(I15=0,0,ROUND(IF(H17<>\"\",VLOOKUP(H17,'1.0'!E$68:F$70,2),0)*3.3333,2))","v":0}]
[null,null,null,"Quality 3","N/A","N/A",0]
[null,null,null,"Technical Autonomy","N/A","N/A",0]
[null,null,null,"Financial Autonomy","N/A","N/A",0]

{"sheet":"Dashboards","index":15,"n_rows":306,"n_cols":34,"rows_kept":306,"cut":false,"hidden":false,"merged":[[13,9,13,12],[13,14,13,17],[13,28,13,31],[13,33,13,36],[23,9,23,17],[23,28,23,36],[0,19,0,37],[1,1,2,17],[1,20,2,36],[3,1,3,7],[3,9,3,12],[3,14,3,17],[3,20,3,26],[3,28,3,31],[3,33,3,36],[0,0,0,18],[28,1,28,17],[28,20,28,36],[29,1,29,7],[29,9,29,12],[29,14,29,17],[29,20,29,26],[29,28,29,31],[29,33,29,36],[24,9,24,17],[24,28,24,36],[25,9,25,17],[25,28,25,36],[26,9,26,17],[26,28,26,36],[50,9,50,17],[50,28,50,36],[51,9,51,17],[51,28,51,36],[52,9,52,17],[52,28,52,36],[39,9,39,12],[39,14,39,17],[39,28,39,31],[39,33,39,36],[49,9,49,17],[49,28,49,36],[53,9,53,17],[53,28,53,36],[55,1,55,17],[55,20,55,36],[56,1,56,7],[56,9,56,12],[56,14,56,17],[56,20,56,26],[56,28,56,31],[56,33,56,36],[77,9,77,18],[77,28,77,37],[78,9,78,18],[78,28,78,37],[79,9,79,18],[79,28,79,37],[66,9,66,12],[66,14,66,17],[66,28,66,31],[66,33,66,36],[76,9,76,18],[76,28,76,37],[84,1,84,7],[84,9,84,12],[84,14,84,17],[84,20,84,26],[84,28,84,31],[84,33,84,36],[80,9,80,18],[80,28,80,37],[81,9,81,18],[81,28,81,37],[83,1,83,17],[83,20,83,36],[105,9,105,18],[105,28,105,37],[106,9,106,18],[106,28,106,37],[107,9,107,18],[107,28,107,37],[94,9,94,12],[94,14,94,17],[94,28,94,31],[94,33,94,36],[104,9,104,18],[104,28,104,37],[121,9,121,12],[121,14,121,17],[121,28,121,31],[121,33,121,36],[131,9,131,18],[131,28,131,37],[108,9,108,18],[108,28,108,37],[110,1,110,17],[110,20,110,36],[111,1,111,7],[111,9,111,12],[111,14,111,17],[111,20,111,26],[111,28,111,31],[111,33,111,36],[136,1,136,7],[136,9,136,12],[136,14,136,17],[136,20,136,26],[136,28,136,31],[136,33,136,36],[132,9,132,18],[132,28,132,37],[133,9,133,18],[133,28,133,37],[135,1,135,17],[135,20,135,36],[157,9,157,18],[157,28,157,37],[158,9,158,18],[158,28,158,37],[160,1,160,17],[160,20,160,36],[146,9,146,12],[146,14,146,17],[146,28,146,31],[146,33,146,36],[156,9,156,18],[156,28,156,37],[171,9,171,12],[171,14,171,17],[171,28,171,31],[171,33,171,36],[181,9,181,18],[181,28,181,37],[161,1,161,7],[161,9,161,12],[161,14,161,17],[161,20,161,26],[161,28,161,31],[161,33,161,36],[182,9,182,18],[182,28,182,37],[184,1,184,17],[184,20,184,36],[185,1,185,7],[185,9,185,12],[185,14,185,17],[185,20,185,26],[185,28,185,31],[185,33,185,36],[206,9,206,18],[206,28,206,37],[207,9,207,18],[207,28,207,37],[209,1,209,17],[209,20,209,36],[195,9,195,12],[195,14,195,17],[195,28,195,31],[195,33,195,36],[205,9,205,18],[205,28,205,37],[220,9,220,12],[220,14,220,17],[220,28,220,31],[220,33,220,36],[230,9,230,18],[230,28,230,37],[210,1,210,7],[210,9,210,12],[210,14,210,17],[210,20,210,26],[210,28,210,31],[210,33,210,36],[244,9,244,12],[244,14,244,17],[244,28,244,31],[244,33,244,36],[254,9,254,18],[254,28,254,37],[231,9,231,18],[231,28,231,37],[233,1,233,17],[233,20,233,36],[234,1,234,7],[234,9,234,12],[234,14,234,17],[234,20,234,26],[234,28,234,31],[234,33,234,36],[268,9,268,12],[268,14,268,17],[268,28,268,31],[268,33,268,36],[278,9,278,18],[278,28,278,37],[255,9,255,18],[255,28,255,37],[257,1,257,17],[257,20,257,36],[258,1,258,7],[258,9,258,12],[258,14,258,17],[258,20,258,26],[258,28,258,31],[258,33,258,36],[283,1,283,7],[283,9,283,12],[283,14,283,17],[283,20,283,26],[283,28,283,31],[283,33,283,36],[279,9,279,18],[279,28,279,37],[280,9,280,18],[280,28,280,37],[282,1,282,17],[282,20,282,36],[304,9,304,18],[304,28,304,37],[305,9,305,18],[305,28,305,37],[293,9,293,12],[293,14,293,17],[293,28,293,31],[293,33,293,36],[303,9,303,18],[303,28,303,37]]}
["Baseline",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End line"]
[null,"1.0 Organizational",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.0 Organizational"]
[]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'1.0'!B3","v":"E1 = Mission statement or stated objectives"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'1.0'!B3","v":"E1 = Mission statement or stated objectives"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'1.0'!B9","v":"E2 = Values and ethics statements"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'1.0'!B9","v":"E2 = Values and ethics statements"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'1.0'!B16","v":"E3 = M&E unit/directorate"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'1.0'!B16","v":"E3 = M&E unit/directorate"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E4 = \"&'1.0'!B21","v":"E4 = Regular M&E unit meetings"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E4 = \"&'1.0'!B21","v":"E4 = Regular M&E unit meetings"}]
[]
[null,"2.0 Human Capacity for M&E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.0 Human Capacity for M&E"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'2.0'!B3","v":"E1 = Staff M&E skills and competencies"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'2.0'!B3","v":"E1 = Staff M&E skills and competencies"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'2.0'!B12","v":"E2 = Costed human capacity-building plan"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'2.0'!B12","v":"E2 = Costed human capacity-building plan"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'2.0'!B20","v":"E3 = Costed human capacity-building plan for organizational development (OD)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'2.0'!B20","v":"E3 = Costed human capacity-building plan for organizational development (OD)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E4 = \"&'2.0'!B28","v":"E4 = Costed human capacity-building plan for data demand and information use (DDIU)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E4 = \"&'2.0'!B28","v":"E4 = Costed human capacity-building plan for data demand and information use (DDIU)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E5 = \"&'2.0'!B36","v":"E5 = Validated M&E training curriculum "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E5 = \"&'2.0'!B36","v":"E5 = Validated M&E training curriculum "}]
[]
[null,"3.0 Partnerships and Governance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.0 Partnerships and Governance"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'3.0'!B3","v":"E1 = Strategy or policy to acknowledge and support M&E performance"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'3.0'!B3","v":"E1 = Strategy or policy to acknowledge and support M&E performance"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'3.0'!B10","v":"E2 = Standard operating procedures that define roles and responsibilities related to M&E functions and activities"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'3.0'!B10","v":"E2 = Standard operating procedures that define roles and responsibilities related to M&E functions and activities"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'3.0'!B17","v":"E3 = M&E technical working  group (TWG)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'3.0'!B17","v":"E3 = M&E technical working  group (TWG)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E4 = \"&'3.0'!B25","v":"E4 = Commitment from stakeholders in the organization’s M&E activities and performance "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E4 = \"&'3.0'!B25","v":"E4 = Commitment from stakeholders in the organization’s M&E activities and performance "}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E5 = \"&'3.0'!B32","v":"E5 = Updated inventory of M&E stakeholders for the organization"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E5 = \"&'3.0'!B32","v":"E5 = Updated inventory of M&E stakeholders for the organization"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E6 = \"&'3.0'!B39","v":"E6 = Clear mechanisms (e.g., feedback reports, newsletters) to communicate M&E activities and decisions"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E6 = \"&'3.0'!B39","v":"E6 = Clear mechanisms (e.g., feedback reports, newsletters) to communicate M&E activities and decisions"}]
[]
[null,"4.0 Organization M&E Plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.0 Organization M&E Plan"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'4.0'!B3","v":"E1 = Ability of the organization to prepare accurate annual work plans, budgets, and schedules"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'4.0'!B3","v":"E1 = Ability of the organization to prepare accurate annual work plans, budgets, and schedules"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'4.0'!B11","v":"E2 = Clear guidelines with dates specifying when information or reports need to be both received and distributed by the organization"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'4.0'!B11","v":"E2 = Clear guidelines with dates specifying when information or reports need to be both received and distributed by the organization"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'4.0'!B17","v":"E3 = National multi-sectoral M&E plan"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'4.0'!B17","v":"E3 = National multi-sectoral M&E plan"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E4 = \"&'4.0'!B23","v":"E4 = M&E plan for the organization"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E4 = \"&'4.0'!B23","v":"E4 = M&E plan for the organization"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E5 = \"&'4.0'!B29","v":"E5 =  M&E system assessment (gap analysis, mid-term reviews)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E5 = \"&'4.0'!B29","v":"E5 =  M&E system assessment (gap analysis, mid-term reviews)"}]
[]
[null,"5.0 Annual Costed M&E Work plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.0 Annual Costed M&E Work plan"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'5.0'!B3","v":"E1 = Costed M&E activities with identified sources of funding in the annual work plan"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'5.0'!B3","v":"E1 = Costed M&E activities with identified sources of funding in the annual work plan"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'5.0'!B9","v":"E2 = M&E work plan is linked to the Medium-Term Expenditure Framework  "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'5.0'!B9","v":"E2 = M&E work plan is linked to the Medium-Term Expenditure Framework  "}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'5.0'!B13","v":"E3 = Committed resources to implement the M&E work plan"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'5.0'!B13","v":"E3 = Committed resources to implement the M&E work plan"}]
[]
[null,"6.0 Advocacy, Communication, and Cultural Behavior",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.0 Advocacy, Communication, and Cultural Behavior"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'6.0'!B3","v":"E1 = M&E champions "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'6.0'!B3","v":"E1 = M&E champions "}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'6.0'!B9","v":"E2 = Communication strategy"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'6.0'!B9","v":"E2 = Communication strategy"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'6.0'!B15","v":"E3 = M&E strategies and products are included in the [national or subnational] strategic plan"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'6.0'!B15","v":"E3 = M&E strategies and products are included in the [national or subnational] strategic plan"}]
[]
[null,"7.0 Routine Monitoring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7.0 Routine Monitoring"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'7.0'!B3","v":"E1 = Essential tools and equipment for data management (e.g., collection, transfer, storage, analysis)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'7.0'!B3","v":"E1 = Essential tools and equipment for data management (e.g., collection, transfer, storage, analysis)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'7.0'!B10","v":"E2 = M&E guidelines to document procedures for collecting, recording, collating, and reporting routine program data "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'7.0'!B10","v":"E2 = M&E guidelines to document procedures for collecting, recording, collating, and reporting routine program data "}]
[]
[null,"8.0 Surveys and Surveillance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8.0 Surveys and Surveillance"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'8.0'!B3","v":"E1 = Survey and surveillance inventory"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'8.0'!B3","v":"E1 = Survey and surveillance inventory"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'8.0'!B9","v":"E2 = Protocols for surveys and surveillance "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'8.0'!B9","v":"E2 = Protocols for surveys and surveillance "}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'8.0'!B15","v":"E3 = Functioning surveillance system "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'8.0'!B15","v":"E3 = Functioning surveillance system "}]
[]
[null,"9.0 National and Subnational Databases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.0 National and Subnational Databases"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'9.0'!B3","v":"E1 = Databases for electronically capturing and storing data generated for and by the M&E system "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'9.0'!B3","v":"E1 = Databases for electronically capturing and storing data generated for and by the M&E system "}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'9.0'!B10","v":"E2 = Databases are linked"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'9.0'!B10","v":"E2 = Databases are linked"}]
[]
[null,"10.0 Supervision and Auditing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10.0 Supervision and Auditing"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'10.0'!B3","v":"E1 = Guidelines and tools for supportive supervision"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'10.0'!B3","v":"E1 = Guidelines and tools for supportive supervision"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'10.0'!B9","v":"E2 = Data quality audit"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'10.0'!B9","v":"E2 = Data quality audit"}]
[]
[null,"11.0 Evaluation and Research",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.0 Evaluation and Research"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'11.0'!B3","v":"E1 = An inventory/register/database of institutions undertaking research and evaluation "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'11.0'!B3","v":"E1 = An inventory/register/database of institutions undertaking research and evaluation "}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'11.0'!B9","v":"E2 = Organization-specific research agenda "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'11.0'!B9","v":"E2 = Organization-specific research agenda "}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'11.0'!B15","v":"E3 = Forums for dissemination and discussion of research findings"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'11.0'!B15","v":"E3 = Forums for dissemination and discussion of research findings"}]
[]
[null,"12.0 Data Demand and Use",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12.0 Data Demand and Use"]
[null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy",null,null,null,null,null,"Overall Rating",null,null,null,null,null,null,null,"Status",null,null,null,null,"Technical Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,null,null,null,"Financial Autonomy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'12.0'!B3","v":"E1 = Organization data use plan"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E1 = \"&'12.0'!B3","v":"E1 = Organization data use plan"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'12.0'!B9","v":"E2 = Dissemination of information products"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E2 = \"&'12.0'!B9","v":"E2 = Dissemination of information products"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'12.0'!B15","v":"E3 = Data analysis and presentation guidelines"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E3 = \"&'12.0'!B15","v":"E3 = Data analysis and presentation guidelines"}]

{"sheet":"Overall Dashboards","index":16,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[59,1,59,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[58,1,58,3],[66,1,66,4],[67,1,67,3],[68,1,68,3],[69,1,69,3],[60,1,60,3],[61,1,61,3],[62,1,62,3],[63,1,63,4],[64,1,64,3],[65,1,65,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Status",null,"Quality",null,"Technical",null,"Financial"]
[null,null,null,null,null,"Baseline","End line","Baseline","End line","Baseline","End line","Baseline","End line"]
[null,{"$f":"'1.0'!$A$1","v":"1.0 Organizational"},null,null,null,{"$f":"Data!D2","v":0},{"$f":"Data!L2","v":0},{"$f":"Data!D3","v":0},{"$f":"Data!L3","v":0},{"$f":"Data!D4","v":0},{"$f":"Data!L4","v":0},{"$f":"Data!D5","v":0},{"$f":"Data!L5","v":0}]
[null,{"$f":"'2.0'!$A$1","v":"2.0 Human Capacity for M&E"},null,null,null,{"$f":"Data!D16","v":0},{"$f":"Data!L16","v":0},{"$f":"Data!D17","v":0},{"$f":"Data!L17","v":0},{"$f":"Data!D18","v":0},{"$f":"Data!L18","v":0},{"$f":"Data!D19","v":0},{"$f":"Data!L19","v":0}]
[null,{"$f":"'3.0'!$A$1","v":"3.0 Partnerships and Governance"},null,null,null,{"$f":"Data!D27","v":0},{"$f":"Data!L27","v":0},{"$f":"Data!D28","v":0},{"$f":"Data!L28","v":0},{"$f":"Data!D29","v":0},{"$f":"Data!L29","v":0},{"$f":"Data!D30","v":0},{"$f":"Data!L30","v":0}]
[null,{"$f":"'4.0'!$A$1","v":"4.0  Organization M&E Plan"},null,null,null,{"$f":"Data!D38","v":0},{"$f":"Data!L38","v":0},{"$f":"Data!D39","v":0},{"$f":"Data!L39","v":0},{"$f":"Data!D40","v":0},{"$f":"Data!L40","v":0},{"$f":"Data!D41","v":0},{"$f":"Data!L41","v":0}]
[null,{"$f":"'5.0'!$A$1","v":"5.0 Annual Costed Health Sector M&E Work Plan"},null,null,null,{"$f":"Data!D48","v":0},{"$f":"Data!L48","v":0},{"$f":"Data!D49","v":0},{"$f":"Data!L49","v":0},{"$f":"Data!D50","v":0},{"$f":"Data!L50","v":0},{"$f":"Data!D51","v":0},{"$f":"Data!L51","v":0}]
[null,{"$f":"'6.0'!$A$1","v":"6.0 Advocacy, Communication, and Cultural Behavior"},null,null,null,{"$f":"Data!D56","v":0},{"$f":"Data!L56","v":0},{"$f":"Data!D57","v":0},{"$f":"Data!L57","v":0},{"$f":"Data!D58","v":0},{"$f":"Data!L58","v":0},{"$f":"Data!D59","v":0},{"$f":"Data!L59","v":0}]
[null,{"$f":"'7.0'!$A$1","v":"7.0 Routine Monitoring"},null,null,null,{"$f":"Data!D64","v":0},{"$f":"Data!L64","v":0},{"$f":"Data!D65","v":0},{"$f":"Data!L65","v":0},{"$f":"Data!D66","v":0},{"$f":"Data!L66","v":0},{"$f":"Data!D67","v":0},{"$f":"Data!L67","v":0}]
[null,{"$f":"'8.0'!$A$1","v":"8.0 Surveys and Surveillance"},null,null,null,{"$f":"Data!D72","v":0},{"$f":"Data!L72","v":0},{"$f":"Data!D73","v":0},{"$f":"Data!L73","v":0},{"$f":"Data!D74","v":0},{"$f":"Data!L74","v":0},{"$f":"Data!D75","v":0},{"$f":"Data!L75","v":0}]
[null,{"$f":"'9.0'!$A$1","v":"9.0 National and Subnational Databases"},null,null,null,{"$f":"Data!D81","v":0},{"$f":"Data!L81","v":0},{"$f":"Data!D82","v":0},{"$f":"Data!L82","v":0},{"$f":"Data!D83","v":0},{"$f":"Data!L83","v":0},{"$f":"Data!D84","v":0},{"$f":"Data!L84","v":0}]
[null,{"$f":"'10.0'!$A$1","v":"10.0 Supervision and Auditing"},null,null,null,{"$f":"Data!D89","v":0},{"$f":"Data!L89","v":0},{"$f":"Data!D90","v":0},{"$f":"Data!L90","v":0},{"$f":"Data!D91","v":0},{"$f":"Data!L91","v":0},{"$f":"Data!D92","v":0},{"$f":"Data!L92","v":0}]
[null,{"$f":"'11.0'!$A$1","v":"11.0 Evaluation and Research"},null,null,null,{"$f":"Data!D98","v":0},{"$f":"Data!L98","v":0},{"$f":"Data!D99","v":0},{"$f":"Data!L99","v":0},{"$f":"Data!D100","v":0},{"$f":"Data!L100","v":0},{"$f":"Data!D101","v":0},{"$f":"Data!L101","v":0}]
[null,{"$f":"'12.0'!$A$1","v":"12.0 Data Demand and Use"},null,null,null,{"$f":"Data!D108","v":0},{"$f":"Data!L108","v":0},{"$f":"Data!D109","v":0},{"$f":"Data!L109","v":0},{"$f":"Data!D110","v":0},{"$f":"Data!L110","v":0},{"$f":"Data!D111","v":0},{"$f":"Data!L111","v":0}]

{"sheet":"Action Plan","index":17,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8]]}
[null,"Baseline",null,null,null,"End line"]
["Capacity area","Identified weaknesses or gaps","Action to be taken","Timelines","Responsibility","Identified weaknesses or gaps","Action to be taken","Timelines","Responsibility"]

{"sheet":"Data","index":18,"n_rows":114,"n_cols":14,"rows_kept":114,"cut":false,"hidden":true,"merged":[[69,9,69,15],[78,9,78,15],[24,9,24,15],[53,2,53,8],[61,2,61,8],[69,2,69,8],[78,2,78,8],[35,9,35,15],[45,9,45,15],[53,9,53,15],[24,2,24,8],[35,2,35,8],[45,2,45,8],[14,9,14,15],[14,2,14,8],[0,9,0,15],[95,1,104,1],[105,1,113,1],[86,9,86,15],[95,9,95,15],[105,9,105,15],[95,2,95,8],[105,2,105,8],[86,1,94,1],[86,2,86,8],[61,1,68,1],[69,1,77,1],[78,1,85,1],[61,9,61,15],[24,1,34,1],[35,1,44,1],[45,1,52,1],[53,1,60,1],[0,2,0,8],[0,1,13,1],[14,1,23,1]]}
[null,"1.0 Organizational","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,"Status",{"$f":"('1.0'!$G$3+'1.0'!$G$9+'1.0'!$G$15+'1.0'!$G$21)/4","v":0},null,null,null,null,null,null,"Status",{"$f":"('1.0'!$I$3+'1.0'!$I$9+'1.0'!$I$15+'1.0'!$I$21)/4","v":0}]
[null,null,"Quality",{"$f":"SUM($G$5:$G$8)/4","v":0},null,null,null,null,null,null,"Quality",{"$f":"SUM($N$5:$N$8)/4","v":0}]
[null,null,"Technical",{"$f":"(IF('1.0'!$G$7=\"NA\", 0,'1.0'!$G$7)+IF('1.0'!$G$13=\"NA\",0,'1.0'!$G$13)+IF('1.0'!$G$19=\"NA\",0,'1.0'!$G$19)+IF('1.0'!$G$25=\"NA\",0,'1.0'!$G$25 ))/4","v":0},null,"Element","Quality(Rank)",null,null,null,"Technical",{"$f":"(IF('1.0'!$I$7=\"NA\", 0,'1.0'!$I$7)+IF('1.0'!$I$13=\"NA\",0,'1.0'!$I$13)+IF('1.0'!$I$19=\"NA\",0,'1.0'!$I$19)+IF('1.0'!$I$25=\"NA\",0,'1.0'!$I$25 ))/4","v":0},"Element","Quality (Rank)"]
[null,null,"Financial",{"$f":"IF('1.0'!$G$26=\"NA\",0,'1.0'!$G$26)","v":0},null,"Mission statement",{"$f":"(SUMIF('1.0'!$G$4:$G$5,\"<>NA\"))/2","v":0},null,null,null,"Financial",{"$f":"IF('1.0'!$I$26=\"NA\",0,'1.0'!$I$26)","v":0},"Mission statement",{"$f":"(SUMIF('1.0'!$I$4:$I$5,\"<>NA\"))/2","v":0}]
[null,null,null,null,null,{"$f":"'1.0'!$B$9","v":"Values and ethics statements"},{"$f":"(SUMIF('1.0'!$G$10:$G$12,\"<>NA\"))/3","v":0},null,null,null,null,null,{"$f":"'1.0'!$B$9","v":"Values and ethics statements"},{"$f":"(SUMIF('1.0'!$I$10:$I$12,\"<>NA\"))/3","v":0}]
[null,null,null,null,null,"M&E unit ",{"$f":"(SUMIF('1.0'!$G$16:$G$18, \"<>NA\"))/3","v":0},null,null,null,null,null,"M&E unit ",{"$f":"(SUMIF('1.0'!$I$16:$I$18, \"<>NA\"))/3","v":0}]
[null,null,null,null,null,"M&E unit meetings",{"$f":"(SUMIF('1.0'!$G$22:$G$24,\"<>NA\"))/3","v":0},null,null,null,null,null,"M&E unit meetings",{"$f":"(SUMIF('1.0'!$I$22:$I$24,\"<>NA\"))/3","v":0}]
[null,null,null,null,null,"Organizational",{"$f":"(SUM($G$5:$G$8))/4","v":0},null,null,null,null,null,"Organizational",{"$f":"(SUM($N$5:$N$8))/4","v":0}]
[]
[]
[]
[]
[]
[null,"2.0 Human Capacity for M&E","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,"Status",{"$f":"('2.0'!$G$3+'2.0'!$G$12+'2.0'!$G$20+'2.0'!$G$28+'2.0'!$G$36)/5","v":0},null,"Element","Rank(Quality)",null,null,null,"Status",{"$f":"('2.0'!$I$3+'2.0'!$I$12+'2.0'!$I$20+'2.0'!$I$28+'2.0'!$I$36)/5","v":0},"Element","Rank (Quality)"]
[null,null,"Quality",{"$f":"IF($G$23=\"NA\", 0,$G$23)/5","v":0},null,{"$f":"'2.0'!$B$3","v":"Staff M&E skills and competencies"},{"$f":"('2.0'!$G$4+'2.0'!$G$5+'2.0'!$G$6+'2.0'!$G$7+'2.0'!$G$8+'2.0'!$G$9)/6","v":0},null,null,null,"Quality",{"$f":"IF($N$23=\"NA\", 0,$N$23)/5","v":0},{"$f":"'2.0'!$B$3","v":"Staff M&E skills and competencies"},{"$f":"('2.0'!$I$4+'2.0'!$I$5+'2.0'!$I$6+'2.0'!$I$7+'2.0'!$I$8+'2.0'!$I$9)/6","v":0}]
[null,null,"Technical",{"$f":"(IF('2.0'!$G$10=\"NA\", 0,'2.0'!$G$10)+IF('2.0'!$G$42=\"NA\",0,'2.0'!$G$42))/2","v":0},null,{"$f":"'2.0'!$B$12","v":"Costed human capacity-building plan"},{"$f":"(SUMIF('2.0'!$G$13:$G$14,\"<>NA\"))/2","v":0},null,null,null,"Technical",{"$f":"(IF('2.0'!$I$10=\"NA\", 0,'2.0'!$I$10)+IF('2.0'!$I$42=\"NA\",0,'2.0'!$I$42))/2","v":0},{"$f":"'2.0'!$B$12","v":"Costed human capacity-building plan"},{"$f":"(SUMIF('2.0'!$I$13:$I$14,\"<>NA\"))/2","v":0}]
[null,null,"Financial",{"$f":"(IF('2.0'!$G$11=\"NA\", 0,'2.0'!$G$11) +IF('2.0'!$G$43=\"NA\", 0,'2.0'!$G$43))/2","v":0},null,{"$f":"'2.0'!$B$20","v":"Costed human capacity-building plan for organizational development (OD)"},{"$f":"(SUMIF('2.0'!$G$21:$G$22,\"<>NA\"))/2","v":0},null,null,null,"Financial",{"$f":"(IF('2.0'!$I$11=\"NA\", 0,'2.0'!$I$11) +IF('2.0'!$I$43=\"NA\", 0,'2.0'!$I$43))/2","v":0},{"$f":"'2.0'!$B$20","v":"Costed human capacity-building plan for organizational development (OD)"},{"$f":"(SUMIF('2.0'!$I$21:$I$22,\"<>NA\"))/2","v":0}]
[null,null,null,null,null,{"$f":"'2.0'!$B$28","v":"Costed human capacity-building plan for data demand and information use (DDIU)"},{"$f":"(SUMIF('2.0'!$G$29:$G$30,\"<>NA\"))/2","v":0},null,null,null,null,null,{"$f":"'2.0'!$B$28","v":"Costed human capacity-building plan for data demand and information use (DDIU)"},{"$f":"(SUMIF('2.0'!$I$29:$I$30,\"<>NA\"))/2","v":0}]
[null,null,null,null,null,{"$f":"'2.0'!$B$36","v":"Validated M&E training curriculum "},{"$f":"(SUMIF('2.0'!$G$37:$G$39, \"<>NA\"))/3","v":0},null,null,null,null,null,{"$f":"'2.0'!$B$36","v":"Validated M&E training curriculum "},{"$f":"(SUMIF('2.0'!$I$37:$I$39, \"<>NA\"))/3","v":0}]
[]
[null,null,null,null,null,null,{"$f":"SUM($G$17:$G$22)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$17:$N$22)","v":0}]
[]
[null,"3.0 Partnerships and Governance","Baseline",null,null,null,null,null,null,"Endline"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"('3.0'!$G$3+'3.0'!$G$10+'3.0'!$G$17+'3.0'!$G$25+'3.0'!$G$32+'3.0'!$G$39+'3.0'!$G$46)/7","v":0},null,{"$f":"'3.0'!$B$3","v":"Strategy or policy to acknowledge and support M&E performance"},{"$f":"IF('3.0'!$G$4=\"NA\",0,'3.0'!$G$4)","v":0},null,null,null,"Status",{"$f":"('3.0'!$I$3+'3.0'!$I$10+'3.0'!$I$17+'3.0'!$I$25+'3.0'!$I$32+'3.0'!$I$39+'3.0'!$I$46)/7","v":0},{"$f":"'3.0'!$B$3","v":"Strategy or policy to acknowledge and support M&E performance"},{"$f":"IF('3.0'!$I$4=\"NA\",0,'3.0'!$I$4)","v":0}]
[null,null,"Quality",{"$f":"$G$34/6","v":0},null,{"$f":"'3.0'!$B$10","v":"Standard operating procedures that define roles and responsibilities related to M&E functions and activities"},{"$f":"(SUMIF('3.0'!$G$11:$G$12,\"<>NA\"))/2","v":0},null,null,null,"Quality",{"$f":"$N$34/6","v":0},{"$f":"'3.0'!$B$10","v":"Standard operating procedures that define roles and responsibilities related to M&E functions and activities"},{"$f":"(SUMIF('3.0'!$I$11:$I$12,\"<>NA\"))/2","v":0}]
[null,null,"Technical",{"$f":"(IF('3.0'!$G$8=\"NA\", 0,'3.0'!$G$8) +IF('3.0'!$G$15=\"NA\",0,'3.0'!$G$15)+IF('3.0'!$G$23=\"NA\",0,'3.0'!$G$23)+IF('3.0'!$G$37=\"NA\",0,'3.0'!$G$37)+IF('3.0'!$G$44=\"NA\",0,'3.0'!$G$44))/5","v":0},null,{"$f":"'3.0'!$B$17","v":"M&E technical working  group (TWG)"},{"$f":"(IF('3.0'!$G$18=\"NA\", 0,'3.0'!$G$18)+IF('3.0'!$G$19=\"NA\",0,'3.0'!$G$19)+IF('3.0'!$G$20=\"NA\",0,'3.0'!$G$20)+IF('3.0'!$G$21=\"NA\",0,'3.0'!$G$21)+IF('3.0'!$G$22=\"NA\",0,'3.0'!$G$22))/5","v":0},null,null,null,"Technical",{"$f":"(IF('3.0'!$I$8=\"NA\", 0,'3.0'!$G$8) +IF('3.0'!$I$15=\"NA\",0,'3.0'!$I$15)+IF('3.0'!$I$23=\"NA\",0,'3.0'!$I$23)+IF('3.0'!$I$37=\"NA\",0,'3.0'!$I$37)+IF('3.0'!$I$44=\"NA\",0,'3.0'!$I$44))/5","v":0},{"$f":"'3.0'!$B$17","v":"M&E technical working  group (TWG)"},{"$f":"(IF('3.0'!$I$18=\"NA\", 0,'3.0'!$I$18)+IF('3.0'!$I$19=\"NA\",0,'3.0'!$I$19)+IF('3.0'!$I$20=\"NA\",0,'3.0'!$I$20)+IF('3.0'!$I$21=\"NA\",0,'3.0'!$I$21)+IF('3.0'!$I$22=\"NA\",0,'3.0'!$I$22))/5","v":0}]
[null,null,"Financial",{"$f":"(IF('3.0'!$G$9=\"NA\",0,'3.0'!$G$9)+IF('3.0'!$G$16=\"NA\",0,'3.0'!$G$16)+IF('3.0'!$G$24=\"NA\",0,'3.0'!$G$24)+IF('3.0'!$G$38=\"NA\", 0,'3.0'!$G$38) +IF('3.0'!$G$45=\"NA\", 0,'3.0'!$G$45))/5","v":0},null,{"$f":"'3.0'!$B$25","v":"Commitment from stakeholders in the organization’s M&E activities and performance "},{"$f":"IF('3.0'!$G$26=\"NA\", 0,'3.0'!$G$26)","v":0},null,null,null,"Financial",{"$f":"(IF('3.0'!$I$9=\"NA\",0,'3.0'!$I$9)+IF('3.0'!$I$16=\"NA\",0,'3.0'!$I$16)+IF('3.0'!$I$24=\"NA\",0,'3.0'!$I$24)+IF('3.0'!$I$38=\"NA\", 0,'3.0'!$I$38) +IF('3.0'!$I$45=\"NA\", 0,'3.0'!$I$45))/5","v":0},{"$f":"'3.0'!$B$25","v":"Commitment from stakeholders in the organization’s M&E activities and performance "},{"$f":"IF('3.0'!$I$26=\"NA\", 0,'3.0'!$I$26)","v":0}]
[null,null,null,null,null,{"$f":"'3.0'!$B$32","v":"Updated inventory of M&E stakeholders for the organization"},{"$f":"(SUMIF('3.0'!$G$33:$G$34,\"<>NA\"))/2","v":0},null,null,null,null,null,{"$f":"'3.0'!$B$32","v":"Updated inventory of M&E stakeholders for the organization"},{"$f":"(SUMIF('3.0'!$I$33:$I$34,\"<>NA\"))/2","v":0}]
[null,null,null,null,null,{"$f":"'3.0'!$B$39","v":"Clear mechanisms (e.g., feedback reports, newsletters) to communicate M&E activities and decisions"},{"$f":"(IF('3.0'!$G$40=\"NA\",0,'3.0'!$G$40)+IF('3.0'!$G$41=\"NA\", 0,'3.0'!$G$41)+IF('3.0'!$G$42=\"NA\",0,'3.0'!$G$42)+IF('3.0'!$G$43=\"NA\",0,'3.0'!$G$43))/4","v":0},null,null,null,null,null,{"$f":"'3.0'!$B$39","v":"Clear mechanisms (e.g., feedback reports, newsletters) to communicate M&E activities and decisions"},{"$f":"(IF('3.0'!$I$40=\"NA\",0,'3.0'!$I$40)+IF('3.0'!$I$41=\"NA\", 0,'3.0'!$I$41)+IF('3.0'!$I$42=\"NA\",0,'3.0'!$I$42)+IF('3.0'!$I$43=\"NA\",0,'3.0'!$I$43))/4","v":0}]
[]
[null,null,null,null,null,null,{"$f":"SUM($G$27:$G$33)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$27:$N$33)","v":0}]
[]
[null,"4.0  Organization M&E Plan","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"('4.0'!$G$3+'4.0'!$G$11+'4.0'!$G$17+'4.0'!$G$23+'4.0'!$G$29)/5","v":0},null,{"$f":"'4.0'!$B$3","v":"Ability of the organization to prepare accurate annual work plans, budgets, and schedules"},{"$f":"(SUMIF('4.0'!$G$4:$G$8,\"<>NA\"))/5","v":0},null,null,null,"Status",{"$f":"('4.0'!$I$3+'4.0'!$I$11+'4.0'!$I$17+'4.0'!$I$23+'4.0'!$I$29)/5","v":0},{"$f":"'4.0'!$B$3","v":"Ability of the organization to prepare accurate annual work plans, budgets, and schedules"},{"$f":"(SUMIF('4.0'!$I$4:$I$8,\"<>NA\"))/5","v":0}]
[null,null,"Quality",{"$f":"$G$44/5","v":0},null,{"$f":"'4.0'!$B$11","v":"Clear guidelines with dates specifying when information or reports need to be both received and distributed by the organization"},{"$f":"(SUMIF('4.0'!$G$12:$G$14,\"<>NA\"))/3","v":0},null,null,null,"Quality",{"$f":"$N$44/5","v":0},{"$f":"'4.0'!$B$11","v":"Clear guidelines with dates specifying when information or reports need to be both received and distributed by the organization"},{"$f":"(SUMIF('4.0'!$I$12:$I$14,\"<>NA\"))/3","v":0}]
[null,null,"Technical",{"$f":"(IF('4.0'!$G$9=\"NA\",0,'4.0'!$G$9)+IF('4.0'!$G$27=\"NA\",0,'4.0'!$G$27)+IF('4.0'!$G$33=\"NA\", 0,'4.0'!$G$33) )/3","v":0},null,{"$f":"'4.0'!$B$17","v":"National multi-sectoral M&E plan"},{"$f":"(SUMIF('4.0'!$G$18:$G$19, \"<>NA\"))/2","v":0},null,null,null,"Technical",{"$f":"(IF('4.0'!$I$9=\"NA\",0,'4.0'!$G$9)+IF('4.0'!$I$27=\"NA\",0,'4.0'!$I$27)+IF('4.0'!$I$33=\"NA\", 0,'4.0'!$I$33) )/3","v":0},{"$f":"'4.0'!$B$17","v":"National multi-sectoral M&E plan"},{"$f":"(SUMIF('4.0'!$I$18:$I$19, \"<>NA\"))/2","v":0}]
[null,null,"Financial",{"$f":"(IF('4.0'!$G$10=\"NA\", 0,'4.0'!$G$10) +IF('4.0'!$G$28=\"NA\",0,'4.0'!$G$28)+IF('4.0'!$G$34=\"NA\",0,'4.0'!$G$34))/3","v":0},null,{"$f":"'4.0'!$B$23","v":"M&E plan for the organization"},{"$f":"IF('4.0'!$G$24=\"NA\", 0, '4.0'!$G$24)","v":0},null,null,null,"Financial",{"$f":"(IF('4.0'!$I$10=\"NA\", 0,'4.0'!$I$10) +IF('4.0'!$I$28=\"NA\",0,'4.0'!$I$28)+IF('4.0'!$I$34=\"NA\",0,'4.0'!$I$34))/3","v":0},{"$f":"'4.0'!$B$23","v":"M&E plan for the organization"},{"$f":"IF('4.0'!$I$24=\"NA\", 0, '4.0'!$I$24)","v":0}]
[null,null,null,null,null,{"$f":"'4.0'!$B$29","v":" M&E system assessment (gap analysis, mid-term reviews)"},{"$f":"IF('4.0'!$G$30=\"NA\", 0, '4.0'!$G$30)","v":0},null,null,null,null,null,{"$f":"'4.0'!$B$29","v":" M&E system assessment (gap analysis, mid-term reviews)"},{"$f":"IF('4.0'!$I$30=\"NA\", 0, '4.0'!$I$30)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"SUM($G$38:$G$43)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$38:$N$43)","v":0}]
[]
[null,"5.0 Annual Costed Health Sector M&E Workplan","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"('5.0'!$G$3+'5.0'!$G$9+'5.0'!$G$13)/3","v":0},null,{"$f":"+'5.0'!$B$3","v":"Costed M&E activities with identified sources of funding in the annual work plan"},{"$f":"IF('5.0'!$G$4=\"NA\",0,'5.0'!$G$4)","v":0},null,null,null,"Status",{"$f":"('5.0'!$I$3+'5.0'!$I$9+'5.0'!$I$13)/3","v":0},{"$f":"+'5.0'!$B$3","v":"Costed M&E activities with identified sources of funding in the annual work plan"},{"$f":"IF('5.0'!$I$4=\"NA\",0,'5.0'!$I$4)","v":0}]
[null,null,"Quality",{"$f":"$G$52/3","v":0},null,{"$f":"+'5.0'!$B$9","v":"M&E work plan is linked to the Medium-Term Expenditure Framework  "},{"$f":"(SUMIF('5.0'!$G$10:$G$12,\"<>NA\"))/3","v":0},null,null,null,"Quality",{"$f":"$N$52/3","v":0},{"$f":"+'5.0'!$B$9","v":"M&E work plan is linked to the Medium-Term Expenditure Framework  "},{"$f":"(SUMIF('5.0'!$I$10:$I$12,\"<>NA\"))/3","v":0}]
[null,null,"Technical",0,null,{"$f":"+'5.0'!$B$13","v":"Committed resources to implement the M&E work plan"},{"$f":"IF('5.0'!$G$14=\"NA\",0,'5.0'!$G$14)","v":0},null,null,null,"Technical",0,{"$f":"+'5.0'!$B$13","v":"Committed resources to implement the M&E work plan"},{"$f":"IF('5.0'!$I$14=\"NA\",0,'5.0'!$I$14)","v":0}]
[null,null,"Financial",{"$f":"IF('5.0'!$G$18=\"NA\",0,'5.0'!$G$18)","v":0},null,null,null,null,null,null,"Financial",{"$f":"IF('5.0'!$I$18=\"NA\",0,'5.0'!$I$18)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM($G$48:$G$51)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$48:$N$51)","v":0}]
[]
[null,"6.0 Advocacy, Communication, and Cultural Behavior","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"('6.0'!$G$3+'6.0'!$G$9+'6.0'!$G$15)/3","v":0},null,{"$f":"+'6.0'!$B$3","v":"M&E champions "},{"$f":"(SUMIF('6.0'!$G$4:$G$5,\"<>NA\"))/2","v":0},null,null,null,"Status",{"$f":"('6.0'!$I$3+'6.0'!$I$9+'6.0'!$I$15)/3","v":0},{"$f":"+'6.0'!$B$3","v":"M&E champions "},{"$f":"(SUMIF('6.0'!$I$4:$I$5,\"<>NA\"))/2","v":0}]
[null,null,"Quality",{"$f":"$G$60/2","v":0},null,{"$f":"+'6.0'!$B$9","v":"Communication strategy"},{"$f":"(SUMIF('6.0'!$G$10:$G$12,\"<>NA\"))/3","v":0},null,null,null,"Quality",{"$f":"$N$60/2","v":0},{"$f":"+'6.0'!$B$9","v":"Communication strategy"},{"$f":"(SUMIF('6.0'!$I$10:$I$12,\"<>NA\"))/3","v":0}]
[null,null,"Technical",{"$f":"IF('6.0'!$G$13=\"NA\", 0, '6.0'!$G$13)","v":0},null,null,null,null,null,null,"Technical",{"$f":"IF('6.0'!$I$13=\"NA\", 0, '6.0'!$I$13)","v":0}]
[null,null,"Financial",{"$f":"IF('6.0'!$G$14=\"NA\",0,'6.0'!$G$14)","v":0},null,null,null,null,null,null,"Financial",{"$f":"IF('6.0'!$I$14=\"NA\",0,'6.0'!$I$14)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM($G$56:$G$59)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$56:$N$59)","v":0}]
[]
[null,"7.0 Routine Monitoring","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"('7.0'!$G$3+'7.0'!$G$10)/2","v":0},null,{"$f":"+'7.0'!$B$3","v":"Essential tools and equipment for data management (e.g., collection, transfer, storage, analysis)"},{"$f":"(SUMIF('7.0'!$G$4:$G$7,\"<>NA\"))/4","v":0},null,null,null,"Status",{"$f":"('7.0'!$I$3+'7.0'!$I$10)/2","v":0},{"$f":"+'7.0'!$B$3","v":"Essential tools and equipment for data management (e.g., collection, transfer, storage, analysis)"},{"$f":"(SUMIF('7.0'!$I$4:$I$7,\"<>NA\"))/4","v":0}]
[null,null,"Quality",{"$f":"$G$68/2","v":0},null,{"$f":"+'7.0'!$B$10","v":"M&E guidelines to document procedures for collecting, recording, collating, and reporting routine program data "},{"$f":"(SUMIF('7.0'!$G$11:$G$14,\"<>NA\"))/3","v":0},null,null,null,"Quality",{"$f":"$N$68/2","v":0},{"$f":"+'7.0'!$B$10","v":"M&E guidelines to document procedures for collecting, recording, collating, and reporting routine program data "},{"$f":"(SUMIF('7.0'!$I$11:$I$14,\"<>NA\"))/3","v":0}]
[null,null,"Technical",{"$f":"(IF('7.0'!$G$8=\"NA\", 0,'7.0'!$G$8) + IF('7.0'!$G$15=\"NA\",0,'7.0'!$G$15))/2","v":0},null,null,null,null,null,null,"Technical",{"$f":"(IF('7.0'!$I$8=\"NA\", 0,'7.0'!$I$8) + IF('7.0'!$I$15=\"NA\",0,'7.0'!$I$15))/2","v":0}]
[null,null,"Financial",{"$f":"(IF('7.0'!$G$9=\"NA\", 0,'7.0'!$G$9)+IF('7.0'!$G$16=\"NA\",0,'7.0'!$G$16))/2","v":0},null,null,null,null,null,null,"Financial",{"$f":"(IF('7.0'!$I$9=\"NA\", 0,'7.0'!$I$9)+IF('7.0'!$I$16=\"NA\",0,'7.0'!$I$16))/2","v":0}]
[null,null,null,null,null,null,{"$f":"SUM($G$64:$G$67)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$64:$N$67)","v":0}]
[]
[null,"8.0 Surveys and Surveillance","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"('8.0'!$G$3+'8.0'!$G$9+'8.0'!$G$15)/3","v":0},null,{"$f":"+'8.0'!$B$3","v":"Survey and surveillance inventory"},{"$f":"(SUMIF('8.0'!$G$4:$G$5,\"<>NA\"))/2","v":0},null,null,null,"Status",{"$f":"('8.0'!$I$3+'8.0'!$I$9+'8.0'!$I$15)/3","v":0},{"$f":"+'8.0'!$B$3","v":"Survey and surveillance inventory"},{"$f":"(SUMIF('8.0'!$I$4:$I$5,\"<>NA\"))/2","v":0}]
[null,null,"Quality",{"$f":"$G$77/3","v":0},null,{"$f":"+'8.0'!$B$9","v":"Protocols for surveys and surveillance "},{"$f":"(SUMIF('8.0'!$G$10:$G$11,\"<>NA\"))/2","v":0},null,null,null,"Quality",{"$f":"$N$77/3","v":0},{"$f":"+'8.0'!$B$9","v":"Protocols for surveys and surveillance "},{"$f":"(SUMIF('8.0'!$I$10:$I$11,\"<>NA\"))/2","v":0}]
[null,null,"Technical",{"$f":"(IF('8.0'!$G$7=\"NA\",0,'8.0'!$G$7)+IF('8.0'!$G$19=\"NA\",0,'8.0'!$G$19))/2","v":0},null,{"$f":"+'8.0'!$B$15","v":"Functioning surveillance system "},{"$f":"IF('8.0'!$G$16=\"NA\",0,'8.0'!$G$16)","v":0},null,null,null,"Technical",{"$f":"(IF('8.0'!$I$7=\"NA\",0,'8.0'!$I$7)+IF('8.0'!$I$19=\"NA\",0,'8.0'!$I$19))/2","v":0},{"$f":"+'8.0'!$B$15","v":"Functioning surveillance system "},{"$f":"IF('8.0'!$I$16=\"NA\",0,'8.0'!$I$16)","v":0}]
[null,null,"Financial",{"$f":"(IF('8.0'!$G$8=\"NA\",0,'8.0'!$G$8)+IF('8.0'!$G$20=\"NA\",0,'8.0'!$G$20))/2","v":0},null,null,null,null,null,null,"Financial",{"$f":"(IF('8.0'!$I$8=\"NA\",0,'8.0'!$I$8)+IF('8.0'!$I$20=\"NA\",0,'8.0'!$I$20))/2","v":0}]
[]
[null,null,null,null,null,null,{"$f":"SUM($G$72:$G$76)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$72:$N$76)","v":0}]
[]
[null,"9.0 National and County Databases","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"'9.0'!$G$10","v":0},null,{"$f":"+'9.0'!$B$3","v":"Databases for electronically capturing and storing data generated for and by the M&E system "},{"$f":"(SUMIF('9.0'!$G$4:$G$7,\"<>NA\"))/4","v":0},null,null,null,"Status",{"$f":"'9.0'!$I$10","v":0},{"$f":"+'9.0'!$B$3","v":"Databases for electronically capturing and storing data generated for and by the M&E system "},{"$f":"(SUMIF('9.0'!$I$4:$I$7,\"<>NA\"))/4","v":0}]
[null,null,"Quality",{"$f":"$G$85/2","v":0},null,{"$f":"+'9.0'!$B$10","v":"Databases are linked"},{"$f":"(SUMIF('9.0'!$G$11:$G$12,\"<>NA\"))/2","v":0},null,null,null,"Quality",{"$f":"$N$85/2","v":0},{"$f":"+'9.0'!$B$10","v":"Databases are linked"},{"$f":"(SUMIF('9.0'!$I$11:$I$12,\"<>NA\"))/2","v":0}]
[null,null,"Technical",{"$f":"IF('9.0'!$G$15=\"NA\",0,'9.0'!$G$15)","v":0},null,null,null,null,null,null,"Technical",{"$f":"IF('9.0'!$I$15=\"NA\",0,'9.0'!$I$15)","v":0}]
[null,null,"Financial",{"$f":"IF('9.0'!$G$16=\"NA\",0,'9.0'!$G$16)","v":0},null,null,null,null,null,null,"Financial",{"$f":"IF('9.0'!$I$16=\"NA\",0,'9.0'!$I$16)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM($G$81:$G$84)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$81:$N$84)","v":0}]
[]
[null,"10.0 Supervision and Auditing","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"('10.0'!$G$3+'10.0'!$G$9)/2","v":0},null,{"$f":"+'10.0'!$B$3","v":"Guidelines and tools for supportive supervision"},{"$f":"(SUMIF('10.0'!$G$4:$G$5,\"<>NA\"))/2","v":0},null,null,null,"Status",{"$f":"('10.0'!$I$3+'10.0'!$I$9)/2","v":0},{"$f":"+'10.0'!$B$3","v":"Guidelines and tools for supportive supervision"},{"$f":"(SUMIF('10.0'!$I$4:$I$5,\"<>NA\"))/2","v":0}]
[null,null,"Quality",{"$f":"$G$94/2","v":0},null,{"$f":"+'10.0'!$B$9","v":"Data quality audit"},{"$f":"(SUMIF('10.0'!$G$10:$G$11,\"<>NA\"))/2","v":0},null,null,null,"Quality",{"$f":"$N$94/2","v":0},{"$f":"+'10.0'!$B$9","v":"Data quality audit"},{"$f":"(SUMIF('10.0'!$I$10:$I$11,\"<>NA\"))/2","v":0}]
[null,null,"Technical",{"$f":"(IF('10.0'!$G$7=\"NA\",0,'10.0'!$G$7)+IF('10.0'!$G$13=\"NA\",0,'10.0'!$G$13))/2","v":0},null,null,null,null,null,null,"Technical",{"$f":"(IF('10.0'!$I$7=\"NA\",0,'10.0'!$I$7)+IF('10.0'!$I$13=\"NA\",0,'10.0'!$I$13))/2","v":0}]
[null,null,"Financial",{"$f":"(IF('10.0'!$G$8=\"NA\",0,'10.0'!$G$8)+IF('10.0'!$G$14=\"NA\",0,'10.0'!$G$14))/2","v":0},null,null,null,null,null,null,"Financial",{"$f":"(IF('10.0'!$I$8=\"NA\",0,'10.0'!$I$8)+IF('10.0'!$I$14=\"NA\",0,'10.0'!$I$14))/2","v":0}]
[]
[null,null,null,null,null,null,{"$f":"SUM($G$89:$G$93)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$89:$N$93)","v":0}]
[]
[null,"11.0 Evaluation and Research","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"('11.0'!$G$3+'11.0'!$G$9+'11.0'!$G$15)/3","v":0},null,{"$f":"+'11.0'!$B$3","v":"An inventory/register/database of institutions undertaking research and evaluation "},{"$f":"(SUMIF('11.0'!$G$4:$G$6,\"<>NA\"))/3","v":0},null,null,null,"Status",{"$f":"('11.0'!$I$3+'11.0'!$I$9+'11.0'!$I$15)/3","v":0},{"$f":"+'11.0'!$B$3","v":"An inventory/register/database of institutions undertaking research and evaluation "},{"$f":"(SUMIF('11.0'!$I$4:$I$6,\"<>NA\"))/3","v":0}]
[null,null,"Quality",{"$f":"$G$104/3","v":0},null,{"$f":"+'11.0'!$B$9","v":"Organization-specific research agenda "},{"$f":"(SUMIF('11.0'!$G$10:$G$11,\"<>NA\"))/2","v":0},null,null,null,"Quality",{"$f":"$N$104/3","v":0},{"$f":"+'11.0'!$B$9","v":"Organization-specific research agenda "},{"$f":"(SUMIF('11.0'!$I$10:$I$11,\"<>NA\"))/2","v":0}]
[null,null,"Technical",{"$f":"(IF('11.0'!$G$7=\"NA\",0,'11.0'!$G$7)+IF('11.0'!$G$19=\"NA\",0,'11.0'!$G$19))/2","v":0},null,{"$f":"+'11.0'!$B$15","v":"Forums for dissemination and discussion of research findings"},{"$f":"(SUMIF('11.0'!$G$16:$G$18,\"<>NA\"))/3","v":0},null,null,null,"Technical",{"$f":"(IF('11.0'!$I$7=\"NA\",0,'11.0'!$I$7)+IF('11.0'!$I$19=\"NA\",0,'11.0'!$I$19))/2","v":0},{"$f":"+'11.0'!$B$15","v":"Forums for dissemination and discussion of research findings"},{"$f":"(SUMIF('11.0'!$I$16:$I$18,\"<>NA\"))/3","v":0}]
[null,null,"Financial",{"$f":"(IF('11.0'!$G$8=\"NA\",0,'11.0'!$G$8)+IF('11.0'!$G$20=\"NA\",0,'11.0'!$G$20))/2","v":0},null,null,null,null,null,null,"Financial",{"$f":"(IF('11.0'!$I$8=\"NA\",0,'11.0'!$I$8)+IF('11.0'!$I$20=\"NA\",0,'11.0'!$I$20))/2","v":0}]
[]
[]
[null,null,null,null,null,"`",{"$f":"SUM($G$98:$G$103)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$98:$N$103)","v":0}]
[]
[null,"12.0 Data Demand and Use","Baseline",null,null,null,null,null,null,"End Line"]
[null,null,null,null,null,"Element","Rank(Quality)",null,null,null,null,null,"Element","Rank (Quality)"]
[null,null,"Status",{"$f":"('12.0'!$G$3+'12.0'!$G$9+'12.0'!$G$15)/3","v":0},null,{"$f":"+'12.0'!$B$3","v":"Organization data use plan"},{"$f":"(SUMIF('12.0'!$G$4:$G$6,\"<>NA\"))/3","v":0},null,null,null,"Status",{"$f":"('12.0'!$I$3+'12.0'!$I$9+'12.0'!$I$15)/3","v":0},{"$f":"+'12.0'!$B$3","v":"Organization data use plan"},{"$f":"(SUMIF('12.0'!$I$4:$I$6,\"<>NA\"))/3","v":0}]
[null,null,"Quality",{"$f":"$G$114/3","v":0},null,{"$f":"+'12.0'!$B$9","v":"Dissemination of information products"},{"$f":"IF('12.0'!$G$10=\"NA\",0,'12.0'!$G$10)","v":0},null,null,null,"Quality",{"$f":"$N$114/3","v":0},{"$f":"+'12.0'!$B$9","v":"Dissemination of information products"},{"$f":"IF('12.0'!$I$10=\"NA\",0,'12.0'!$I$10)","v":0}]
[null,null,"Technical",{"$f":"(IF('12.0'!$G$7=\"NA\",0,'12.0'!$G$7)+IF('12.0'!$G$13=\"NA\",0,'12.0'!$G$13))/2","v":0},null,{"$f":"+'12.0'!$B$15","v":"Data analysis and presentation guidelines"},{"$f":"(SUMIF('12.0'!$G$16:$G$17,\"<>NA\"))/2","v":0},null,null,null,"Technical",{"$f":"(IF('12.0'!$I$7=\"NA\",0,'12.0'!$I$7)+IF('12.0'!$I$13=\"NA\",0,'12.0'!$I$13))/2","v":0},{"$f":"+'12.0'!$B$15","v":"Data analysis and presentation guidelines"},{"$f":"(SUMIF('12.0'!$I$16:$I$17,\"<>NA\"))/2","v":0}]
[null,null,"Financial",{"$f":"(IF('12.0'!$G$8=\"NA\",0,'12.0'!$G$8)+IF('12.0'!$G$14=\"NA\",0,'12.0'!$G$14))/2","v":0},null,null,null,null,null,null,"Financial",{"$f":"(IF('12.0'!$I$8=\"NA\",0,'12.0'!$I$8)+IF('12.0'!$I$14=\"NA\",0,'12.0'!$I$14))/2","v":0}]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM($G$108:$G$110)","v":0},null,null,null,null,null,null,{"$f":"SUM($N$108:$N$110)","v":0}]