{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","1 - Results framework template","NewElements","2 - Checklist","3 - Results Hierarchy"],"not_rendered":{"charts":0,"images":38,"macros":1,"external_links":0,"defined_names":7,"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":"Instructions","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"                       For  rules and guidance on how to develop a results framework for a programme, please consult the ","Results Guideline"]
[]
[null,"This workbook consists of three additional sheets:"]
[null,"1. Results framework template"]
[null,"2. Checklist"]
[null,"3. Results hierarchy"]
[]
[null,"1. Results framework template"]
[]
[null,"You should use this sheet as a template for the “Programme Objectives and Indicators” section of the Concept Note. You can construct the results framework for your programme by adding and/or deleting outcomes, outputs and indicators – this is done by using the pre-programmed “Add…” and/or “Delete…” buttons."]
[null,"All the blue fields (both dark blue and light blue) are fillable. The fields in grey are NOT fillable. The white fields (Assumptions/risks) are fillable, but do not need to be submitted to the FMO.                                                                                                               "]
[null,"The objective of the programme and each outcome need to be coded with the appropriate Programme Area (PA) number – which can be selected from the drop down menu. Programme area numbers are available in the Blue Book. ","Blue book"]
[null,"The bilateral outcome does not require a PA code.Before submitting the results framework to the FMO, please use sheets 2. Checklist and 3. Results hierarchy."]
[]
[null,"2. Checklist"]
[]
[null,"The checklist helps you (Programme Operator) assess if the results framework is ready to be submitted. If the answer to any of the questions is ‘No’, please go back to the results framework and make the necessary adjustments."]
[]
[null,"3. Results hierarchy"]
[]
[null,"The purpose of this sheet is to help you spot any errors in the intervention logic of the programme and to help you notice any overlapping outcomes/outputs. The sheet requires no action on your part. It will be automatically generated– it will visually display the impact (objective), outcomes and outputs based on what you filled in on sheet 1."]
[null,"If you notice that the intervention logic is not sound, please go back to sheet one (‘Results framework’) and make the appropriate adjustments."]

{"sheet":"1 - Results framework template","index":1,"n_rows":20,"n_cols":31,"rows_kept":20,"cut":false,"hidden":false,"merged":[[18,1,19,1],[18,2,19,2],[18,3,19,5],[19,16,19,17],[18,18,19,18],[19,6,19,10],[19,12,19,14],[18,6,18,10],[18,12,18,14],[18,16,18,17],[12,1,15,1],[12,2,15,2],[12,3,15,5],[12,18,15,18],[8,18,9,18],[8,1,9,1],[8,2,9,2],[8,3,9,5],[15,16,15,17],[12,16,12,17],[14,12,14,14],[11,16,11,17],[15,6,15,10],[12,6,12,10],[11,6,11,10],[11,12,11,14],[12,12,12,14],[10,6,10,10],[10,12,10,14],[9,6,9,10],[8,6,8,10],[9,12,9,14],[9,16,9,17],[8,12,8,14],[8,16,8,17],[7,12,7,14],[5,12,5,14],[6,12,6,14],[5,16,5,17],[6,16,6,17],[0,2,0,5],[1,3,2,5],[3,16,3,17],[3,12,3,14],[3,1,3,5],[3,6,3,10],[0,6,0,8],[0,9,0,18],[1,2,2,2],[1,6,2,18],[16,18,17,18],[16,1,17,1],[16,2,17,2],[16,3,17,5],[13,16,13,17],[15,12,15,14],[14,16,14,17],[13,12,13,14],[14,6,14,10],[13,6,13,10],[16,6,16,10],[17,6,17,10],[17,16,17,17],[17,12,17,14],[16,12,16,14],[16,16,16,17],[4,18,7,18],[4,1,7,1],[4,2,7,2],[4,3,7,5],[5,6,5,10],[7,6,7,10],[4,6,4,10],[7,16,7,17],[6,6,6,10],[4,16,4,17],[4,12,4,14],[10,1,11,1],[10,2,11,2],[10,3,11,5],[10,18,11,18],[10,16,10,17]]}
[null,"Beneficiary state >>>>>",null,null,null,null,"Programme name >>>>>"]
[null,null,"Programme Objective",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Objective","NA",null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Objective","NA",null,"No"]
[null,"\n",null,null,null,null,"Indicators",null,null,null,null,"Units of measurement","Baseline values for indicators",null,null,"Baseline year","Target values for indicators",null,"Assumptions/Risks",null,null,null,null,null,null,null,"Delete","Type","Number","Number2","Top"]
[null,"\r\n","Outcome 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Outcome",1,0,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Outcome",1,0,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Outcome",1,0,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Outcome",1,0,"No"]
[null,null,"Output 1.1",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Output",1,1,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Output",1,1,"No"]
[null,null,"Output 1.2",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Output",1,2,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Output",1,2,"No"]
[null,null,"Bilateral Outcome ","Enhanced collaboration between beneficiary and donor state entities involved in the programme. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Bilateral Outcome",1,0,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Bilateral Outcome",1,0,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Bilateral Outcome",1,0,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Bilateral Outcome",1,0,"No"]
[null,null,"Bilateral Output 1",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Bilateral Output",1,1,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Bilateral Output",1,1,"No"]
[null,null,"Bilateral Output 2",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Bilateral Output",1,2,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Bilateral Output",1,2,"No"]

{"sheet":"NewElements","index":2,"n_rows":92,"n_cols":31,"rows_kept":92,"cut":false,"hidden":true,"merged":[[4,1,7,1],[4,2,7,2],[4,3,7,5],[4,6,4,10],[4,12,4,14],[6,12,6,14],[4,18,7,18],[5,6,5,10],[5,12,5,14],[5,16,5,17],[7,6,7,10],[7,12,7,14],[7,16,7,17],[6,6,6,10],[6,16,6,17],[4,16,4,17],[11,16,11,17],[8,1,9,1],[8,2,9,2],[9,12,9,14],[9,16,9,17],[10,1,11,1],[10,2,11,2],[10,3,11,5],[10,6,10,10],[10,12,10,14],[10,16,10,17],[8,3,9,5],[8,6,8,10],[8,12,8,14],[8,16,8,17],[45,0,45,1],[1,18,2,18],[2,6,2,10],[2,12,2,14],[2,16,2,17],[1,1,2,1],[1,2,2,2],[1,3,2,5],[1,6,1,10],[1,12,1,14],[1,16,1,17],[8,18,9,18],[9,6,9,10],[10,18,11,18],[11,6,11,10],[11,12,11,14],[91,6,91,10],[91,12,91,14],[91,16,91,17],[91,3,91,5],[13,12,13,14],[13,16,13,17],[13,3,13,5],[89,3,89,5],[89,6,89,10],[89,12,89,14],[89,16,89,17],[13,6,13,10]]}
[]
[null,null,"Bilateral Output 2",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Bilateral Output",1,2,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Bilateral Output",1,2,"No"]
[]
[null,null,"Outcome 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Outcome",1,0,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Outcome",1,0,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Outcome",1,0,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Outcome",1,0,"No"]
[null,null,"Output 1.1",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Output",1,1,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Output",1,1,"No"]
[null,null,"Output 1.2",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Output",1,2,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Output",1,2,"No"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Output",1,2,"No"]
[null,"PA01","1 - Business Development, Innovation and SMEs",null,null,null,null,"Increased value creation and sustainable growth"]
[null,"PA02","2 - Research",null,null,null,null,"Enhanced research-based knowledge development"]
[null,"PA03","3 - Education, Scholarships, Apprenticeships and Youth Entrepreneurship",null,null,null,null,"Enhanced human capital and knowledge base"]
[null,"PA04","4 - Work-life Balance",null,null,null,null,"Work-life balance improved"]
[null,"PA05","5 - Social Dialogue – Decent Work",null,null,null,null,"Strengthened tripartite cooperation between employer organisations, trade unions and public authorities and the promotion of decent work"]
[null,"PA06","6 - European Public Health Challenges",null,null,null,null,"Improved prevention and reduced inequalities in health"]
[null,"PA07","7 - Roma Inclusion and Empowerment",null,null,null,null,"Enhanced inclusion and empowerment of Roma"]
[null,"PA08","8 - Children and Youth at Risk",null,null,null,null,"Promote the rights and well-being of children and young people"]
[null,"PA09","9 - Youth Participation in the Labour Market",null,null,null,null,"Increased number of young people aged 15-30 in employment"]
[null,"PA10","10 - Local Development and Poverty Reduction",null,null,null,null,"Strengthened social and economic cohesion"]
[null,"PA11","11 - Environment and Ecosystems",null,null,null,null,"Improved environmental status in ecosystems and reduced adverse effects of pollution and other human activities"]
[null,"PA12","12 - Renewable Energy, Energy Efficiency, Energy Security",null,null,null,null,"Less carbon intensive energy and increased security of supply"]
[null,"PA13","13 - Climate Change Mitigation and Adaptation",null,null,null,null,"Climate change mitigated and vulnerability to climate change reduced"]
[null,"PA14","14 - Cultural Entrepreneurship, Cultural Heritage and Cultural Cooperation",null,null,null,null,"Social and economic development strengthened through cultural cooperation, cultural entrepreneurship and cultural heritage management"]
[null,"PA15","15 - Civil Society",null,null,null,null,"Civil society and active citizenship strengthened and vulnerable groups empowered"]
[null,"PA16","16 - Good Governance, Accountable Institutions, Transparency",null,null,null,null,"Integrity and accountability of public administration improved"]
[null,"PA17","17 - Human Rights – National Implementation",null,null,null,null,"Human rights situation improved and discrimination and extremism combatted at national level"]
[null,"PA18","18 - Asylum and Migration",null,null,null,null,"Functioning national asylum and migration management systems ensured and the right to seek asylum safeguarded"]
[null,"PA19","19 - Correctional Services and Pre-trial Detention",null,null,null,null,"Improved correctional system"]
[null,"PA20","20 - International Police Cooperation and Combating Crime",null,null,null,null,"Improved crime prevention and investigation"]
[null,"PA21","21 - Effectiveness and Efficiency of the Judicial System, Strengthening Rule of Law",null,null,null,null,"Strengthened rule of law"]
[null,"PA22","22 - Domestic and Gender-based Violence",null,null,null,null,"Domestic and gender-based violence prevented and victims protected and assisted"]
[null,"PA23","23 - Disaster Prevention and Preparedness",null,null,null,null,"Improved disaster resilience"]
[]
[]
[]
[null,"lastBilateralOutputRow","default 19",19]
[null,"lastBilateralOutput ","default 2",2]
[null,"lastOutcomeRow","default 11",11]
[null,"lastOutcome","default 1",1]
[]
["Relationship outcome column",null,null,"Relationship outcome/output row"]
[null,1,"D",0,8,"E"]
[null,2,"F",1,13,"G"]
[null,3,"H",2,18,"I"]
[null,4,"J",3,23,"K"]
[null,5,"L",4,28,"M"]
[null,6,"N",5,33,"O"]
[null,7,"P",6,38,"Q"]
[null,8,"R",7,43,"S"]
[null,9,"T",8,48,"U"]
[null,10,"V",9,53,"W"]
[null,11,"X",10,58,"Y"]
[null,12,"Z",11,63,"AA"]
[null,13,"AB",12,68,"AC"]
[null,14,"AD",13,73,"AE"]
[null,15,"AF",14,78,"AG"]
[null,16,"AH",15,83,"AI"]
[null,17,"AJ",16,88,"AK"]
[null,18,"AL",17,93,"AM"]
[null,19,"AN",18,98,"AO"]
[null,20,"AP",19,103,"AQ"]
[null,null,null,20,108]
[]
[]
["Cells to copy for arrows on the right",null,"t71"]
[]
["Beneficiary countries",null," - Select the beneficiary state"]
[null,null,"Bulgaria"]
[null,null,"Croatia"]
[null,null,"Cyprus"]
[null,null,"Czech Republic"]
[null,null,"Estonia"]
[null,null,"Greece"]
[null,null,"Hungary"]
[null,null,"Latvia"]
[null,null,"Lithuania"]
[null,null,"Malta"]
[null,null,"Poland"]
[null,null,"Portugal"]
[null,null,"Romania"]
[null,null,"Slovakia"]
[null,null,"Slovenia"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"Bilateral Output",1,2,"No"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Outcome",1,0,"No"]

{"sheet":"2 - Checklist","index":3,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,2,1,3],[6,2,6,3],[12,2,12,3],[16,2,16,3]]}
[null,null,"Yes","No"]
[null,"A. Intervention logic"]
[null,"Does the programme have a clear and coherent intervention logic?"]
[null,"Is the means/ends relationship between outputs, outcomes and the objective plausible?  "]
[null,"Are the key assumptions underlying the intervention logic clear?"]
[null,"Are the key risks to the programme clear? "]
[null,"B. Outcomes"]
[null,"Is each outcome phrased as a single clear, concise statement that does not include the means of achieving the outcome?"]
[null,"Is each outcome phrased as an end situation (as opposed to a process)?"]
[null,"Is each outcome a change statement describing institutional/sector capacity or performance change, or benefits for direct beneficiaries (if service delivery)?"]
[null,"Is the common bilateral outcome included? (except in exceptional cases)"]
[null,"Does each outcome have a causal link to the programme area objective?"]
[null,"C. Outputs"]
[null,"Does each output describe what goods, services will be produced/delivered/procured directly by the programme?"]
[null,"Is each output is distinctly different from other outputs (not overlapping)?"]
[null,"Does each output have a clear, plausible, causal link to a particular outcome under which it belong?"]
[null,"D. Indicators"]
[null,"Is each indicator directly relevant to the outcome or output which it is trying to measure?  "]
[null,"Is the unit of measurement for each indicator clear?"]
[null,"Does each indicator have a baseline value assigned to it? For output indicators, the baseline is zero. For outcome indicators, the baseline will not be zero. If the baseline is not available, there should be a credible plan developed for how to define the baseline. "]
[null,"Does each target have a target value assigned to it – in the same unit of measurement as the indicator?"]
[null,"Have the relevant Core Indicators been used?"]
[null,"Have the relevant bilateral outcome indicators been used?"]

{"sheet":"3 - Results Hierarchy","index":4,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,3,4,5],[18,5,20,5],[8,3,10,3],[13,3,15,3],[8,5,10,5],[13,5,15,5],[18,3,20,3]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Outcome 1",null,"Bilateral Outcome "]
[null,null,null,null,null,"Enhanced collaboration between beneficiary and donor state entities involved in the programme. "]
[]
[]
[]
[null,null,null,"Output 1.1",null,"Bilateral Output 1"]
[]
[]
[]
[]
[null,null,null,"Output 1.2",null,"Bilateral Output 2"]