{"text_format":"2","workbook":"xls","n_sheets":9,"sheets":["Overview","FinancialData","Procurement","Risk Assesment","Rating","Project Indicators","Lessons Learned","Results Tracker","Units for Indicators"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":3,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Overview","index":0,"n_rows":177,"n_cols":16,"rows_kept":177,"cut":false,"hidden":false,"merged":[[22,3,23,3],[15,1,15,2],[26,1,26,2],[35,1,35,2],[25,1,25,2],[18,1,18,2],[22,1,23,2],[24,1,24,2],[31,1,31,2]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,null,"Project Performance Report (PPR)"]
[]
[null,null,"Period of Report (Dates)","February 2014-September 2015"]
[]
[null,null,"Project Title: ","Developing agro-pastoral shade gardens as an adaptation strategy for poor rural communities "]
[]
[]
[]
[]
[]
[null,null,"Project Summary: ","The project aims to help the rural pastoral communities of Djibouti to adapt to climate change by the development of climate resilient shade gardens. The overall objective of the project is to diversify and promote climate resilient agro-pastoral practices in rural Djibouti. The project aims to achieve this objective trough three outcomes: (1) Capacities to mobilize and secure sustainable water resources to agro-pastoral communities developed in the face of climate change; (2)  Sustainable agro-pastoral systems developed, providing greater forage production capacities, diversifying agricultural productions and creating capacities for replication; (3)  Microfinance products developed to facilitate and promote diversified and climate resilient agro-pastoral production systems. \n"]
[{"$nulls":7},"Countries","Project Type:  ",null,"GEF Focal Area: ","GEF 4 Focal Areas","GEF 2 / 3 Operational Programme: ","Overall Rating of the project in the evaluation by the project evaluator: ","GEF-4 Focal Area Strategic Program: ","GEF-3 Focal Area Strategic Program: "]
[null,null,"Database Number: ",4683,null,null,null,"Afghanistan","FP","Yes","Biodiversity",1,1,"U","BD-SP1-PA Financing","1: Arid & semi-arid ecosystems"]
[null,"Implementing Entity (IE) [name]:",null,"United Nations Development Program",null,null,null,"Albania","MSP","No","Climate Change Adaptation",2,2,"S","BD-SP2-Marine PA","2: Coastal, marine & freshwater ecosystems"]
[null,null,"Type of IE:","MIE",null,null,null,"Algeria","EA",null,"Climate Change Mitigation",3,3,"MU","BD-SP3-PA Networks","3: Forest ecosystems"]
[null,null,"Country(ies): ","Djibouti",null,null,null,"Angola",null,null,"International Waters",5,5,"Good","BD-SP5-Markets","13: Conservation and Sustainable Use of Biological Diversity Important to Agriculture"]
[null,"Relevant Geographic Points (i.e. cities, villages, bodies of water):",null,"villages",null,null,null,"Argentina",null,null,"Multiple Focal Area",null,null,null,"BD-SP7-Invasive Alien Species(IAS)","6: Promoting the adoption of renewable energy by removing barriers and reducing implementation costs"]
[{"$nulls":12},"CC-SP2- Industrial EE","8: Waterbody based operational program"]
[null,null,"Project Milestones",{"$nulls":9},"CC-SP3-RE,CC-SP4-Biomass","9: Integrated Land and Water multiple focal area"]
[null,null,"Milestone",{"$nulls":4},"Bahamas",{"$nulls":6},"CC-SP5-Transport","10: Contaminants based operational program"]
[null,"AFB Approval Date:",null,"11 July 2012"]
[]
[null,"IE-AFB Agreement Signature Date:",null,"23 July 2012",{"$nulls":9},"CC-SP6-LULUCF","12: Integrated Ecosystem Management"]
[null,"Start of Project/Programme:",null,"September 2012",{"$nulls":9},"Cross cutting capacity building","14: Persistent Organic Pollutants"]
[null,"Mid-term Review Date (if planned):",null,"2014-09-30"]
[null,null,"Terminal Evaluation Date:","2017-08-31"]
[]
[null,null,null,"List documents/ reports/ brochures / articles that have been prepared about the project.",null,null,null,"Cyprus"]
[null,null,null,"www.projetbara.com. Brochures. Poster. Article in newspaper",null,null,null,"Czech Republic"]
[null,"List the Website address (URL) of project.",{"$nulls":5},"Democratic People's Republic of Korea"]
[null,null,null,"www.projectbara.com",null,null,null,"Democratic Republic of the Congo"]
[{"$nulls":7},"Denmark"]
[null,null,"Project contacts:  ",{"$nulls":4},"Djibouti"]
[null,"National Project Manager/Coordinator",{"$nulls":5},"Dominica"]
[null,null,"Name: ","Houssein Rirache Robleh",null,null,null,"Dominican Republic"]
[null,null,"Email: ","housseinrirach@yahoo.fr",null,null,null,"Ecuador"]
[null,null,"Date: ","2015-09-22",null,null,null,"Egypt"]
[null,null,"Government DA",{"$nulls":4},"El Salvador"]
[null,null,"Name: ","Dini Abdallah Omar",null,null,null,"Equatoral Guinea"]
[null,null,"Email: ","dini_omar@yahoo,fr",null,null,null,"Eritrea"]
[null,null,"Date: ","2015-09-22",null,null,null,"Estonia"]
[null,null,"Implementing Entity",{"$nulls":4},"Ethiopia"]
[null,null,"Name: ","Idriss Ahmed Hared",null,null,null,"Fiji"]
[null,null,"Email: ","idriss.hared@undp.org ",null,null,null,"Finland"]
[null,null,"Date: ","2015-09-22",null,null,null,"France"]
[null,null,"Executing Agency",{"$nulls":4},"Gambia"]
[null,null,"Name: ","Ministry of Habitat, Urbanism and Environment",null,null,null,"Georgia"]
[null,null,"Email: ","housseinrirach@yahoo.fr ",null,null,null,"Germany"]
[null,null,"Date: ",{"$nulls":4},"Ghana"]
[null,null,"Executing Agency",{"$nulls":4},"Greece"]
[null,null,"Name: ",{"$nulls":4},"Grenada"]
[null,null,"Email: ",{"$nulls":4},"Guatemala"]
[null,null,"Date: ",{"$nulls":4},"Guinea"]
[null,null,"Executing Agency",{"$nulls":4},"Guinea Bissau"]
[null,null,"Name: ",{"$nulls":4},"Guyana"]
[null,null,"Email: ",{"$nulls":4},"Haiti"]
[null,null,"Date: ",{"$nulls":4},"Honduras"]
[{"$nulls":7},"Hungary"]
[{"$nulls":7},"Iceland"]
[{"$nulls":7},"India"]
[{"$nulls":7},"Indonesia"]
[{"$nulls":7},"Iran (Islamic Republic of)"]
[{"$nulls":7},"Iraq"]
[{"$nulls":7},"Ireland"]
[{"$nulls":7},"Israel"]
[{"$nulls":7},"Italy"]
[{"$nulls":7},"Jamaica"]
[{"$nulls":7},"Japan"]
[{"$nulls":7},"Jordan"]
[{"$nulls":7},"Kazakhstan"]
[{"$nulls":7},"Kenya"]
[{"$nulls":7},"Kiribati"]
[{"$nulls":7},"Kuwait"]
[{"$nulls":7},"Kyrgyzstan"]
[{"$nulls":7},"Lao People’s Democratic Republic"]
[{"$nulls":7},"Latvia"]
[{"$nulls":7},"Lebanon"]
[{"$nulls":7},"Lesotho"]
[{"$nulls":7},"Liberia"]
[{"$nulls":7},"Libyan Arab Jamahiriya"]
[{"$nulls":7},"Liechtenstein"]
[{"$nulls":7},"Lithuania"]
[{"$nulls":7},"Luxembourg"]
[{"$nulls":7},"Madagascar"]
[{"$nulls":7},"Malawi"]
[{"$nulls":7},"Malaysia"]
[{"$nulls":7},"Maldives"]
[{"$nulls":7},"Mali"]
[{"$nulls":7},"Malta"]
[{"$nulls":7},"Marshall Islands"]
[{"$nulls":7},"Mauritania"]
[{"$nulls":7},"Mauritius"]
[{"$nulls":7},"Mexico"]
[{"$nulls":7},"Micronesia, Federated States of"]
[{"$nulls":7},"Monaco"]
[{"$nulls":7},"Mongolia"]
[{"$nulls":7},"Montenegro"]
[{"$nulls":7},"Morocco"]
[{"$nulls":7},"Mozambique"]
[{"$nulls":7},"Myanmar"]
[{"$nulls":7},"Namibia"]
[{"$nulls":7},"Nauru"]
[{"$nulls":7},"Nepal"]
[{"$nulls":7},"Netherlands"]
[{"$nulls":7},"New Zealand"]
[{"$nulls":7},"Nicaragua"]
[{"$nulls":7},"Niger"]
[{"$nulls":7},"Nigeria"]
[{"$nulls":7},"Norway"]
[{"$nulls":7},"Oman"]
[{"$nulls":7},"Pakistan"]
[{"$nulls":7},"Palau"]
[{"$nulls":7},"Panama"]
[{"$nulls":7},"Papua New Guinea"]
[{"$nulls":7},"Paraguay"]
[{"$nulls":7},"Peru"]
[{"$nulls":7},"Philippines"]
[{"$nulls":7},"Poland"]
[{"$nulls":7},"Portugal"]
[{"$nulls":7},"Qatar"]
[{"$nulls":7},"Republic of Korea"]
[{"$nulls":7},"Republic of Moldova"]
[{"$nulls":7},"Romania"]
[{"$nulls":7},"Russian Federation"]
[{"$nulls":7},"Rwanda"]
[{"$nulls":7},"Saint Kitts and Nevis"]
[{"$nulls":7},"Saint Lucia"]
[{"$nulls":7},"Saint Vincent and the Grenadines"]
[{"$nulls":7},"Samoa"]
[{"$nulls":7},"San Marino"]
[{"$nulls":7},"Sao Tome and Principe"]
[{"$nulls":7},"Saudi Arabia"]
[{"$nulls":7},"Senegal"]
[{"$nulls":7},"Serbia"]
[{"$nulls":7},"Seychelles"]
[{"$nulls":7},"Sierra Leone"]
[{"$nulls":7},"Singapore"]
[{"$nulls":7},"Slovakia"]
[{"$nulls":7},"Slovenia"]
[{"$nulls":7},"Solomon Islands"]
[{"$nulls":7},"Somalia"]
[{"$nulls":7},"South Africa"]
[{"$nulls":7},"Spain"]
[{"$nulls":7},"Sri Lanka"]
[{"$nulls":7},"Sudan"]
[{"$nulls":7},"Suriname"]
[{"$nulls":7},"Swaziland"]
[{"$nulls":7},"Sweden"]
[{"$nulls":7},"Switzerland"]
[{"$nulls":7},"Syrian Arab Republic"]
[{"$nulls":7},"Tajikistan"]
[{"$nulls":7},"Thailand"]
[{"$nulls":7},"The former Yugoslav Republic of Macedonia"]
[{"$nulls":7},"Timor-Leste"]
[{"$nulls":7},"Togo"]
[{"$nulls":7},"Tonga"]
[{"$nulls":7},"Trinidad and Tobago"]
[{"$nulls":7},"Tunisia"]
[{"$nulls":7},"Turkey"]
[{"$nulls":7},"Turkmenistan"]
[{"$nulls":7},"Tuvalu"]
[{"$nulls":7},"Uganda"]
[{"$nulls":7},"Ukraine"]
[{"$nulls":7},"United Arab Emirates"]
[{"$nulls":7},"United Kingdom of Great Britain and Northern Ireland"]
[{"$nulls":7},"United Republic of Tanzania"]
[{"$nulls":7},"United States of America"]
[{"$nulls":7},"Uruguay"]
[{"$nulls":7},"Uzbekistan"]
[{"$nulls":7},"Vanuatu"]
[{"$nulls":7},"Venezuela, Bolivarian Republic of"]
[{"$nulls":7},"Viet Nam"]
[{"$nulls":7},"Yemen"]
[{"$nulls":7},"Zambia"]
[{"$nulls":7},"Zimbabwe"]

{"sheet":"FinancialData","index":1,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[50,2,50,3],[50,4,50,5],[53,2,53,3],[53,4,53,5],[57,2,57,3],[57,4,57,5],[28,2,28,3],[43,2,43,5],[44,2,44,3],[44,4,44,5],[45,2,45,5],[47,2,47,3],[47,4,47,5],[2,2,2,6],[8,2,8,3],[9,2,9,3],[27,2,27,3],[4,2,4,5],[3,1,3,5],[12,2,12,3],[6,2,6,3],[8,4,8,5],[9,4,9,5],[7,2,7,5],[11,2,11,3],[56,2,56,3],[56,4,56,5],[52,4,52,5],[52,2,52,3],[55,2,55,3],[49,2,49,3],[46,2,46,3],[46,4,46,5]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Financial information:  cumulative from project start to [insert date]"]
[]
[]
[]
[null,null,"DISBURSEMENT OF AF GRANT FUNDS "]
[null,null,"How much of the total AF grant as noted in Project Document plus any project preparation grant has been spent to date?"]
[null,null,"Estimated cumulative total disbursement as of 04/09/2014",null,1618179]
[null,null,"Add any comments on AF Grant Funds. (word limit=200)"]
[]
[null,null,"EXPENDITURE DATA"]
[null,null,"List ouput and corresponding amount spent for the current reporting period",null,"ITEM / ACTIVITY / ACTION","AMOUNT"]
[{"$nulls":4},"Output 1.1. Rainfall-runoff and groundwater models developed and institutionalized within the   Study and Research Center of Djibouti (Centre d’Etudes et de la Recherche de Djibouti, CERD ) and the Water Department of the Ministry of Agriculture to project likely climate change impacts on the water availability in the areas of Petit Bara and Grand Bara",0]
[{"$nulls":4},"Output 1.2: Based on model outputs, controlled groundwater extraction, artificial recharge and climate “smart” management plans that take into account seasonal changes in precipitation as well as long term mean amounts, projections, developed, and benefiting  30,000 people",189129]
[{"$nulls":4},"Output 1.3: Community-based surface water harvesting infrastructures, such as earth dams,  percolation basins and subsurface dams  which increase surface supply and groundwater tables in support of shade-garden pilot schemes (see 2.1) introduced and related local management rules and structures established",259324]
[{"$nulls":4},"Output 1.4: Good practice guidelines based on knowledge sharing for integrated groundwater and surface water maintenance and use developed through stakeholder-led and participatory processes including community water management teams, government water regulators, Ministry’s technical staff, and agriculture extension services",9038]
[{"$nulls":4},"Output 2.1: Six sets of 38 pilot community-managed agro-pastoral shade garden plots (1 ha per family) established that includes date palms, multi-purpose fence trees, local and regional varieties of climate resilient forage, vegetables and fruits (henna, dates, jujube, and mango, etc) benefiting 228 agro-pastoral families - approximately 2,800 people",210330]
[{"$nulls":4},"Output 2.2: Improved extension service for shade gardening benefiting 228 agro-pastoral families - approximately 2,800 people (targeted training for extension service personnel and agro-pastoralists designed and delivered on the issues grazing, forage management, cultivation techniques, crop protection, water efficiency, composting methods, etc, in the context of increasing climate change pressures)",13990]
[{"$nulls":4},"Output 2.3. Well-sized feed/forage stocking facilities created in both project locations to allow better management of forage availability over repeated drought periods"]
[{"$nulls":4},"Output 3.1: A three-tiered adaptation-oriented micro-finance scheme that supports climate-resilient shade gardening practices in the Grand and Petit Bara plains developed through partnership with  the Djiboutian Agency for Social Development (Agence Djiboutienne de Developpement Sociale, ADDS ) which generates a total value of US$ 300,000 throughout the project "]
[{"$nulls":4},"Output 3.2: At least 300 agro-pastoralists have been organised to form agro-pastoral cooperatives (including women cooperatives) to facilitate training on climate-resilient agro-pastoral practices and to support the development of financial literacy and the diversification of agricultural activities",16576]
[{"$nulls":4},"Output 3.3:  At least 4 established agro-pastoral cooperatives develop comprehensive climate adaptation plans incorporating lessons learned on best practices for shade gardens to be integrated into the National Programme for Food Security and the National Microfinance Policy in order to facilitate the replication of shade-garden-based adaptation solutions",0]
[{"$nulls":4},"Project Execution cost",106900]
[]
[{"$nulls":4},"TOTAL",805287]
[]
[null,null,"PLANNED EXPENDITURE SCHEDULE"]
[null,null,"List outputs planned and corresponding projected cost for the upcoming reporting period",null,"ITEM / ACTIVITY / ACTION","PROJECTED COST","Est. Completion Date"]
[{"$nulls":4},"Output 1.1. Rainfall-runoff and groundwater models developed and institutionalized within the   Study and Research Center of Djibouti (Centre d’Etudes et de la Recherche de Djibouti, CERD ) and the Water Department of the Ministry of Agriculture to project likely climate change impacts on the water availability in the areas of Petit Bara and Grand Bara",0,"2016-05-31"]
[{"$nulls":4},"Output 1.2: Based on model outputs, controlled groundwater extraction, artificial recharge and climate “smart” management plans that take into account seasonal changes in precipitation as well as long term mean amounts, projections, developed, and benefiting  30,000 people",319160,"2016-05-31"]
[{"$nulls":4},"Output 1.3: Community-based surface water harvesting infrastructures, such as earth dams,  percolation basins and subsurface dams  which increase surface supply and groundwater tables in support of shade-garden pilot schemes (see 2.1) introduced and related local management rules and structures established",235000,"2016-05-31"]
[{"$nulls":4},"Output 1.4: Good practice guidelines based on knowledge sharing for integrated groundwater and surface water maintenance and use developed through stakeholder-led and participatory processes including community water management teams, government water regulators, Ministry’s technical staff, and agriculture extension services",20000,"2016-05-31"]
[{"$nulls":4},"Output 2.1: Six sets of 38 pilot community-managed agro-pastoral shade garden plots (1 ha per family) established that includes date palms, multi-purpose fence trees, local and regional varieties of climate resilient forage, vegetables and fruits (henna, dates, jujube, and mango, etc) benefiting 228 agro-pastoral families - approximately 2,800 people",284000,"2016-05-31"]
[{"$nulls":4},"Output 2.2: Improved extension service for shade gardening benefiting 228 agro-pastoral families - approximately 2,800 people (targeted training for extension service personnel and agro-pastoralists designed and delivered on the issues grazing, forage management, cultivation techniques, crop protection, water efficiency, composting methods, etc, in the context of increasing climate change pressures)",25000,"2016-05-31"]
[{"$nulls":4},"Output 2.3. Well-sized feed/forage stocking facilities created in both project locations to allow better management of forage availability over repeated drought periods",0,"2016-05-31"]
[{"$nulls":4},"Output 3.1: A three-tiered adaptation-oriented micro-finance scheme that supports climate-resilient shade gardening practices in the Grand and Petit Bara plains developed through partnership with  the Djiboutian Agency for Social Development (Agence Djiboutienne de Developpement Sociale, ADDS ) which generates a total value of US$ 300,000 throughout the project ",25000,"2016-05-31"]
[{"$nulls":4},"Output 3.2: At least 300 agro-pastoralists have been organised to form agro-pastoral cooperatives (including women cooperatives) to facilitate training on climate-resilient agro-pastoral practices and to support the development of financial literacy and the diversification of agricultural activities",20000,"2016-05-31"]
[{"$nulls":4},"Output 3.3:  At least 4 established agro-pastoral cooperatives develop comprehensive climate adaptation plans incorporating lessons learned on best practices for shade gardens to be integrated into the National Programme for Food Security and the National Microfinance Policy in order to facilitate the replication of shade-garden-based adaptation solutions",30000,"2016-05-31"]
[{"$nulls":4},"Output :Project Execution cost",59600,"2016-05-31"]
[]
[{"$nulls":4},"Total",1017760]
[]
[null,null,"ACTUAL CO-FINANCING (If the MTR or TE have not been undertaken this reporting period, DO NOT report on actual co-financing.) "]
[null,null,"How much of the total co-financing as committed in the Project Document has actually been realized?"]
[]
[null,null,"Estimated cumulative actual co-financing as verified during Mid-term Review (MTR) or Terminal Evaluation (TE). "]
[null,null,"Add any comments on actual co-financing in particular any issues related to the realization of in-kind, grant, credits, loans, equity, non-grant instruments and other types of co-financing. (word limit=200)"]

{"sheet":"Procurement","index":2,"n_rows":329,"n_cols":8,"rows_kept":329,"cut":false,"hidden":false,"merged":[[108,2,110,2],[130,6,135,6],[162,2,165,2],[166,2,169,2],[127,4,129,4],[136,2,140,2],[136,6,140,6],[136,5,140,5],[123,2,126,2],[111,6,116,6],[141,1,143,1],[147,6,149,6],[150,6,152,6],[158,2,161,2],[153,2,157,2],[158,6,161,6],[141,2,143,2],[91,2,97,2],[92,6,97,6],[98,2,102,2],[141,6,143,6],[98,6,102,6],[117,2,122,2],[117,6,122,6],[124,6,126,6],[127,2,129,2],[111,2,116,2],[2,2,2,7],[3,1,3,7],[4,2,4,7],[7,2,7,3],[8,2,8,7],[5,2,5,5],[79,2,79,3],[80,2,80,4],[85,2,87,2],[82,2,84,2],[83,4,84,4],[108,6,110,6],[88,2,90,2],[88,6,90,6],[103,2,107,2],[103,6,107,6],[130,2,135,2],[127,6,129,6],[174,2,178,2],[179,2,181,2],[170,2,173,2],[182,2,184,2],[182,6,184,6],[185,2,187,2],[185,6,187,6],[188,2,192,2],[188,6,192,6],[193,2,197,2],[193,6,197,6],[198,2,202,2],[198,6,202,6],[203,2,207,2],[203,6,207,6],[208,2,212,2],[208,6,212,6],[213,2,217,2],[213,6,217,6],[218,2,220,2],[218,6,220,6],[221,2,223,2],[221,6,223,6],[224,2,228,2],[224,6,228,6],[229,2,233,2],[229,6,233,6],[234,2,236,2],[234,6,236,6],[237,2,239,2],[237,6,239,6],[240,2,242,2],[240,6,242,6],[243,2,248,2],[243,5,248,5],[243,6,248,6],[249,2,254,2],[249,5,254,5],[249,6,254,6],[255,2,260,2],[255,5,260,5],[255,6,260,6],[261,2,266,2],[261,5,266,5],[261,6,266,6],[267,2,271,2],[267,5,271,5],[267,6,271,6],[272,2,277,2],[272,5,277,5],[272,6,277,6],[278,2,283,2],[278,5,283,5],[278,6,283,6],[284,2,289,2],[284,5,289,5],[284,6,289,6],[290,2,295,2],[290,5,295,5],[290,6,295,6],[296,6,301,6],[302,2,307,2],[302,5,307,5],[302,6,307,6],[308,2,313,2],[308,5,313,5],[308,6,313,6],[296,2,301,2],[296,5,301,5],[325,2,330,2],[325,5,330,5],[325,6,330,6],[314,2,319,2],[314,5,319,5],[314,6,319,6],[320,2,324,2],[320,5,324,5],[320,6,324,6]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"PROCUREMENT DATA"]
[]
[null,null,"Please provide information for all contracts over $2,500 USD"]
[null,null,"Please provide the number of  contracts under $2,500, signed during this reporting period:",null,null,null,6]
[]
[null,null,"LIST OF CONTRACTS"]
[null,null,"List all contracts related to the project/program with signature dates"]
[null,null,"Contract Type","Agency / Contracted party","Contract Value/Amount (USD)","Signature Date","Payment to Date","Remaining Balance"]
[null,null,"Mémorandum d'entente",null,80949,"2015-03-22",32380,48569]
[null,null,"Work Contract (amendment)",null,5085,"2015-02-09",5085,0]
[null,null,"Work Contract (amendment)",null,3601,"2015-01-10",3601,0]
[null,null,"Contractual service",null,13923,"2015-01-01",1160,12763]
[null,null,"Contractual service",null,3000,"2014-12-31",3000,0]
[null,null,"Work Contract",null,3446,"2014-12-07",3446,0]
[null,null,"Work Contract",null,26520,"2014-12-02",26520,0]
[null,null,"Contractual service",null,6275,"2014-12-01",1569,4706]
[null,null,"Work Contract",null,28027,"2014-10-29",28027,0]
[null,null,"Contractual service",null,34854,"2014-11-22",10439,24415]
[null,null,"Work Contract (amendment)",null,3601,"2014-11-08",3601,0]
[null,null,"Work contract",null,28189,"2014-09-27",28189,0]
[null,null,"Work contract",null,84580,"2014-09-24",84580,0]
[null,null,"Work contract",null,4910,"2014-09-06",4910,0]
[null,null,"Work contract",null,4525,"2014-09-06",4525,0]
[null,null,"Work Contract",null,24902,"2014-09-06",24902,0]
[null,null,"Contractual service",null,4000,"2014-09-01",4000,0]
[null,null,"contractual  service ",null,6688,"2014-08-01",5852,836]
[null,null,"contractual  service (amendment)",null,13923,"2014-01-01",13923,0]
[null,null,"Contractual service (amendment)",null,6275,"2013-12-01",6275,0]
[null,null,"Contractual service",null,18000,"2014-05-11",15000,3000]
[null,null,"Contractual service",null,18000,"2014-05-11",15000,3000]
[null,null,"Contractual service",null,3000,"2014-03-01",3000,0]
[null,null,"Contractual service",null,2000,"2014-06-01",2000,0]
[null,null,"Contractual service",null,3320,"2014-06-11",3320,0]
[null,null,"Contractual service",null,9040,"2014-05-29",9040,0]
[null,null,"works contract (amendment)",null,4797,"2014-07-23",4797,0]
[null,null,"works contract (amendment)",null,4350,"2014-07-02",4350,0]
[null,null,"works contract",null,20489,"2014-06-11",20489,0]
[null,null,"works contract",null,23387,"2014-06-11",23387,0]
[null,null,"works contract",null,84580,"2014-06-10",84580,0]
[null,null,"contractual  service",null,12000,"2012-10-01",12000,0]
[null,null,"Contractual service",null,5423,"2012-12-01",5423,0]
[null,null,"repairing building",null,3367,"2013-02-24",3367,0]
[null,null,"Contractual service",null,14486,"2013-03-16",14486,0]
[null,null,"Contractual service",null,9600,"2013-06-13",9600,0]
[null,null,"Contractual service",null,24081,"2013-10-20",24081,0]
[null,null,"Contractual service",null,3800,"2013-10-07",3800,0]
[null,null,"Contractual service",null,2000,"2013-11-01",2000,0]
[null,null,"Contractual service",null,6000,"2013-10-04",6000,0]
[null,null,"Contractual service",null,2500,"2013-10-05",2500,0]
[null,null,"Contractual service",null,830,"2013-09-08",830,0]
[null,null,"Contractual service",null,28120,"2013-06-19",28120,0]
[null,null,"Contractual service",null,22000,"2013-07-08",22000,0]
[null,null,"Contractual service",null,151792,"2013-07-28",106254,45538]
[null,null,"Contractual service",null,25000,"2013-08-19",25000,0]
[null,null,"Contractual service",null,87420,"2013-06-22",26226,61194]
[null,null,"Contractual service",null,3000,"2013-10-01",3000,0]
[null,null,"Contractual service",null,830,"2013-09-07",830,0]
[null,null,"works contract",null,33180,"2013-10-26",33180,0]
[null,null,"works contract",null,27262,"2013-12-21",27262,0]
[null,null,"works contract",null,23050,"2013-12-21",23050,0]
[null,null,"works contract",null,27505,"2013-12-21",27505,0]
[null,null,"works contract",null,25485,"2013-12-21",25485,0]
[null,null,"works contract",null,55892,"2013-11-05",55892,0]
[null,null,"works contract",null,27344,"2013-12-21",27344,0]
[null,null,"works contract",null,28005,"2013-12-21",28005,0]
[null,null,"works contract",null,25706,"2013-12-21",25706,0]
[null,null,"works contract",null,27067,"2013-12-21",27067,0]
[null,null,"works contract",null,22677,"2013-12-21",22677,0]
[null,null,"works contract",null,18559,"2013-12-21",18559,0]
[null,null,"works contract",null,20135,"2013-12-21",20135]
[null,null,"works contract",null,27720,"2013-12-21",27720,0]
[null,null,"works contract",null,12661,"2013-11-14",12661,0]
[null,null,"works contract",null,27672,"2013-12-21",27672,0]
[null,null,"Contractual  service",null,2000,"2013-10-07",2000,0]
[{"$nulls":4},1305847,null,1163158,142689]
[]
[]
[null,null,"BIDS"]
[null,null,"List all bids for each contact signed with date of open call and winning bid"]
[null,null,"CONTRACT & Procurement Method","Submitted Bids","Bid Amount (USD)","Winning Bid Amount (USD)","Selection Justification for the Winner"]
[null,null,"Name of Contract , Procruement Method, Date of Call"]
[{"$nulls":4},10034,null,"Based on the roster list of Ministry Of Environment"]
[]
[null,null,"Name of Contract , Procruement Method, Date of Call",null,13923,null,"Based on the roster list of Ministry Of Environment, extension contract and amendment"]
[]
[]
[null,null,"Name of Contract , Procruement Method, Date of Call",null,6275,null,"Based on the roster list of Ministry Of Environment, extension contract and amendment"]
[]
[]
[null,null,"Name of Contract , Procruement Method, Date of Call",null,18000]
[{"$nulls":6},"Based on the roster list of Ministry Of Environment, and selection criteria"]
[]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, Date of Call",null,18000,null,"Based on the roster list of Ministry Of Environment, and selection criteria"]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,3000,null,"Based on the roster list of Ministry Of Environment, and selection criteria"]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,2000,null,"extension of contract based on performance"]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,3320,null,"selection was based on the ministry of environment Roster list"]
[]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,9039.54,9039.54,"selection was based on best technical offer and lowest financial offer"]
[{"$nulls":4},10579.09]
[{"$nulls":4},10169.49]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call"]
[{"$nulls":4},4797,4797,"amendment of initial contract"]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,4350,4350,"amendment of initial contract"]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call, Lot N°5: Fence construction of 500 ML",null,26268.36,26268.36,"Best technical and financial offer"]
[{"$nulls":4},31807.9]
[{"$nulls":4},43375.7]
[{"$nulls":4},79717.51]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call,Lot N°4: reservoir construction of 150 m3 capacity",null,23387.57,23387.57,"Best technical and financial offer"]
[{"$nulls":4},27254.8]
[{"$nulls":4},27388.75]
[{"$nulls":4},27519.77]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,84580.22,84580.22,"Direct agreement and decision made by the ministry of environment because they are partner  in the implementation of the project"]
[]
[]
[]
[null,null,"Memorandum",null,163477,163477,"Direct agreement and decision made by the ministry of environment because they are partner  in the implementation of the project"]
[]
[null,null,"Memorandum",null,84580.22,84580.22,"Direct agreement and decision made by the ministry of environment because they are partner  in the implementation of the project"]
[]
[]
[null,null,"Memorandum",null,34854,34854,"Direct agreement and decision made by the ministry of environment because they are partner  in the implementation of the project"]
[]
[]
[null,null,"Topography",null,28189,28189,"Best technical and financial offer"]
[{"$nulls":4},"not submitted"]
[{"$nulls":4},15819]
[{"$nulls":4},32110]
[]
[null,null,"Geotecnical study",null,70592,28027,"Best technical and financial offer"]
[{"$nulls":4},"technical offer not fit the offer"]
[]
[]
[null,null,"Work contract",null,32495]
[{"$nulls":4},31311]
[{"$nulls":4},27669,27669,"Best technical and financial offer"]
[]
[null,null,"Field work contract",null,29379]
[{"$nulls":4},28249]
[{"$nulls":4},26520,26520,"Best technical and financial offer"]
[]
[null,null,"Field work contract",null,3446]
[{"$nulls":4},4379,3446,"Best technical and financial offer"]
[{"$nulls":4},4774]
[]
[null,null,"Name of Contract , Procruement Method, Date of Call",null,3367,3367,"Lowest financial offer"]
[{"$nulls":4},3971]
[{"$nulls":4},3728]
[]
[]
[null,null,"Name of Contract , Procruement Method, Date of Call",null,120000,null,"Based on the roster list of Ministry Of Environment"]
[]
[]
[null,null,"Name of Contract , Procruement Method, Date of Call",null,5423,null,"Based on the roster list of the ministry of environment"]
[]
[]
[null,null,"Name of Contract , Procruement Method, Date of Call",null,14486,14486,"selection was based on UNDP Roster"]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,9600,9600,"Best Technical and financial offer"]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,24081,24081,"selection was based on the ministry of environment Roster list"]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,3800,3800,"selection was based on ministry of environment Roster list"]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,6000,6000,"selection was based on ministry of environment Roster list"]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,2500,2500,"Lowest financial offer "]
[{"$nulls":4},3250]
[{"$nulls":4},2700]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,28750,28120,"Best technical and financial offer"]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,22000,22000,"Direct agreement and decision made by the ministry of environment"]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,151791,151791,"Direct agreement based on MOU between CERD and MHUE based on the project document"]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,25000,25000," best technical and financial offer"]
[]
[]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,93000,87420,"Best Technical and financial offer and based on the recommendation of the ministry of environment"]
[{"$nulls":4},108094]
[{"$nulls":4},0]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,5423,5423,"extension of contract"]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,3000,3000,"extension of contract"]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,33180,33180,"involved as part of project implementation based on the project document"]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,27262,27262,"Financial lowest offer"]
[{"$nulls":4},30848]
[{"$nulls":4},30494]
[{"$nulls":4},39590]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,25994,23050,"Financial lowest offer"]
[{"$nulls":4},23050]
[{"$nulls":4},26785]
[{"$nulls":4},34638]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,42180,27505,"Financial lowest offer"]
[{"$nulls":4},27505]
[{"$nulls":4},35248]
[{"$nulls":4},35636]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,34053,25485,"Financial lowest offer"]
[{"$nulls":4},25485]
[{"$nulls":4},30116]
[{"$nulls":4},35636]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,55892,55892,"Financial lowest offer"]
[{"$nulls":4},69423]
[{"$nulls":4},61258]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,27344,27344,"Financial lowest offer"]
[{"$nulls":4},32994]
[{"$nulls":4},30424]
[{"$nulls":4},28944]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,28006,28005,"Financial lowest bid"]
[{"$nulls":4},33263]
[{"$nulls":4},31489]
[{"$nulls":4},37181]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,25706,25706,"Financial lowest offer"]
[{"$nulls":4},30169]
[{"$nulls":4},35367]
[{"$nulls":4},30198]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,27067,27067,"Financial lowest offer"]
[{"$nulls":4},45570]
[{"$nulls":4},30799]
[{"$nulls":4},30039]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,22677,22677,"Financial lowest offer"]
[{"$nulls":4},24017]
[{"$nulls":4},25418]
[{"$nulls":4},30147]
[]
[]
[null,null,"Name of Contract , Procrurement Method, if appicable Date of Call",null,22051,18559,"Financial lowest offer"]
[{"$nulls":4},20480]
[{"$nulls":4},20407]
[{"$nulls":4},18559]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,24170,20136,"Financial lowest offer"]
[{"$nulls":4},22271]
[{"$nulls":4},23023]
[{"$nulls":4},20136]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,27720,27720,"Financial lowest offer"]
[{"$nulls":4},34116]
[{"$nulls":4},45571]
[{"$nulls":4},45571]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,12661,12661,"Financial lowest offer"]
[{"$nulls":4},16050]
[{"$nulls":4},13559]
[]
[]
[null,null,"Name of Contract , Procruement Method, if appicable Date of Call",null,27672,27672,"Financial lowest offer"]
[{"$nulls":4},32489]
[{"$nulls":4},34294]
[{"$nulls":4},30121]

{"sheet":"Risk Assesment","index":3,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[57,2,57,3],[57,4,57,5],[53,2,53,3],[53,4,53,5],[43,2,43,3],[44,2,44,3],[47,4,47,5],[49,2,49,3],[45,2,45,5],[46,2,46,3],[2,2,2,5],[55,2,55,3],[56,2,56,3],[56,4,56,5],[50,2,50,3],[50,4,50,5],[52,2,52,3],[52,4,52,5],[32,2,32,5],[31,2,31,3],[46,4,46,5],[47,2,47,3],[17,4,17,5],[18,4,18,5],[19,4,19,5],[31,4,31,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[3,1,3,5],[4,2,4,5],[6,2,6,3],[7,2,7,5],[8,4,8,5],[14,4,14,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[30,2,30,5],[21,2,21,5],[22,2,22,5],[15,4,15,5],[16,4,16,5],[27,4,27,5]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"RISK ASSESMENT"]
[]
[]
[]
[null,null,"IDENTIFIED RISKS"]
[null,null,"List all Risks identified in project preparation phase and what  steps are being taken to mitigate them"]
[null,null,"Identified Risk","Current Status","Steps Taken to Mitigate Risk"]
[null,null,"Reluctance of farmers or pastoralists to engage in agro-pastoralist practices of shade gardens","Decreasing","The project management unit has met several times the communities and presented the objectives of the project for a sensitization purpose. The communities have expressed their interest in the shade gardening. Only 2 new farmers were not able to continue. "]
[null,null,"Repeated drought","Decreasing ","After the protracted drought period (2007-2011), the rain situation is better in the country. To better manage the available quantity of water even in the event of repeated droughts, the project management unit has undertaken a work on collecting the best practices in irrigation in Djibouti.  The use of PVC pipes in place of traditional open air concrete channels was decided in order to eliminate the loss by evapo-transpiration of the water in the channels. The promotion of drip irrigation whenever it is cost effective has also been decided by the PMU. In 2015, the rainfall in Grand and Petit Bara is better that previous years. The surface water ponds are full of water."]
[null,null,"Initial studies reveal insufficient water availability and quality","Increasing","Comprehensive and detailed scientific exploration combining hydrogeology, hydrology, geology, and geophysics techniques was undertaken for the sitting of the wells. Chemistry of the existing water sources of the Grand Bara and Petit Bara (either surface or groundwater) has been studied. Areas that may reveal salinity of the underground water have been eliminated already from the drilling program. Areas with high probability of tapping water resources were selected and included in the drilling program as priority areas in 2014. Hydrology studies revealed that more than two millions cubic meter of water can be harvesed in the rainy season. Earth dams to collect this high volume of water will be constructed and decrease furthermore this identified risk. In 2015, results of the drilling of the boreholes have shown that the quantity of water in the boreholes is lesser than the planned quantity. The project is seeking and started to adop new stategies in order to decrease this risk to an acceptable level. This include the drilling of shallow wells in wadis in Grand and Petit Bara. This stratety is applied now to Hamboucto area near in Grand Bara and is successfull. Some new hydrogeological studies may be needed. "]
[null,null,"Low level of cooperation between executing institutions","Decreasing","A technical committee was established as a discussion platform among the involved institutions, The committee meets once every month to discuss issues that may delay the implementation of the project. This risk is not anymore important in the project, The tehcnical committee has solved the problem of cooperation between the government agencies."]
[null,null,"Delays in project implementation due to simultaneous construction works for complementary projects","Decreasing","The PMU is maintaining a regular contact with the tehcnical departments of the Ministry of Agriculture that will be involved in the construction of the water infrastructures. The planning of the contruction of water infrastructures (boreholes, dams) is already determined with these line departments. Construction of infrastructue completed in 2014 at Kourtimalei et Rakoubyel. This risk is minimal for the project. The project is mixing different options of execution of  infrastructures including the use of government technical agencies as well as private companies. "]
[null,null,"Insufficient interest and social cohesiveness amongst sedentary pastoral communities to adhere to the alternative production models proposed by the project  ","Decreasing","The project management unit has met several times the communities and presented the objectives of the project for a sensitization purpose. The communities have expressed their interest in the shade gardening. "]
[null,null,"Theft of solar panels, pump parts or fencing materials in any of the shade garden zones","No change. Reporting against this risk will be done once the panels will installed after the drilling of the boreholes. In 2015 no change for this risk which not materialized. "]
[]
[]
[]
[]
[]
[null,null,"Critical Risks Affecting Progress (Not identified at project design)"]
[null,null,"Identify Risks with a 50% or > likelihood of affecting progress of project"]
[null,null,"Identified Risk","Current Status","Steps Taken to Mitigate Risk"]
[null,null,"Unwelcome livestock (livestock from surrounding pastoralists) invading the agro-pastoral plots which can provoke disputes between the farmers and pastoralists","low","Secure metal and stone fencing will be constructed around each agro-pastoral site to deter all unwelcome animals. This will prevent the risk of invading livestock and potential disputes between the pastoralists and agro pastoralists."]
[null,null,"Pollution from petrol spills when trucks overturn on highways","low","This will be prevented by placing the pilot sites at least 100 meters from the roadside or the required distance identified by the Environmental Impact Assessment"]
[null,null,"Risk of people becoming dependent on food aid in the beginning years of the project before fruit and vegetables can be cultivated","medium","Early contact have been established with the local office of the World Food Program to see the possibility if WFP providing food aid in the beginning year of the project. Discussions are ongoing. It is well established that a productive 1 hectare or even quarter of hectare can be sufficient to sustain the livelihoods of a rural families. Meanwhile it is important to support the communities either financially or trough the food for work during the starting years."]
[null,null,"Limited capacity of local populations to perform maintenance on boreholes and solar-powered well pumps","medium","Water management groups already exist in surrounding regions. It is typical practice in the hierarchy of the village to assign roles, such as to maintain the wells. This project includes activities to form and train the water management groups so that they can do by themselves the basic maintenance."]
[]
[]
[null,null,"Risk Measures: Were there any risk mitigation measures employed during the current reporting period?  If so, were risks reduced?  If not, why were these risks not reduced?"]
[null,null,"Add any comments relevant to risk mitigation (word limit = 500)"]

{"sheet":"Rating","index":4,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[40,3,40,4],[40,5,40,8],[22,3,22,4],[22,5,22,6],[28,4,28,7],[29,4,29,7],[31,3,31,4],[34,3,34,4],[34,5,34,6],[17,3,20,8],[23,3,23,4],[24,3,24,4],[25,3,25,4],[23,5,23,6],[24,5,24,6],[25,5,25,6],[48,6,48,8],[33,5,33,6],[43,6,43,8],[44,6,44,8],[45,6,45,8],[46,6,46,8],[47,6,47,8],[2,2,2,8],[3,2,3,8],[16,2,16,7],[7,3,7,4],[8,3,8,4],[9,3,9,4],[6,3,6,4],[6,5,6,6],[9,5,9,6],[8,5,8,6],[7,5,7,6],[13,4,13,7],[14,4,14,7],[12,3,12,8],[37,4,37,7],[38,4,38,7],[31,5,31,6],[32,3,32,4],[32,5,32,6],[33,3,33,4]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"RATING ON IMPLEMENTATION PROGRESS "]
[null,null,"For rating definitions please see bottom of page."]
[]
[]
[null,null,null,"Progress on Key Milestones",null,"Expected Progress",null,"Progress to Date","Rating"]
[null,null,"Project Manager/Coordinator: ","construction of water infrastructures for the harvest of underground water or surface water ",null,"At the year 3 of the project, 6 boreholes will be developped as well as 6 earth dams and 8 subsurface dams. Creation of community water management committee",null,"Slow progress towards the achievement of this outcome. Environmental risk affected the delivery of boreholes and this affecting the overall project progress. The two boreholes developped are delivering only 7 cubic meter per hour while the expected delivery was at least 30 cubic meter of water per hour. ","MS"]
[null,null,null,"Development of the climate resilient shade gardens",null,"From the year 2 to year 4 of the project 6 sets of 38 hectares each will be developped. ",null,"Slow progress towards the achievement of the outcomes. To this date 35 families are benefitting from the agropastoral farming.  This is achieved by using the water the earth dam developped by the project and the use of one existing borehole in the Grand Bara.","MS"]
[null,null,null,"Rural beneficiaries are organized into agricultural anf financial cooperatives, have access to microfinance and develop climta resilient agro-pastoral enterprises",null,"Targeted rural microfinance products developped, capacity building for the microfinance institutions, technical guides developped, financial cooperatives  ",null,"Slow progress towards the achievement of the outcome. MOU prepared between the project and the State Secretariat of Solidarity. ","MS"]
[{"$nulls":7},"Overall Rating","MS"]
[]
[null,null,null,"Please Provide the Name and Contact information of person(s) reponsible for completeling the Rating section"]
[null,null,null,"Name: ","Houssein Rirache Robleh"]
[null,null,null,"Email: ","housseinrirach@yahoo.fr"]
[]
[null,null,"Please justify your rating.  Outline the positive and negative progress made by the project since it started.  Provide specific recommendations for next steps. . (word limit=500)"]
[null,null,null,"Overall, the project is progressing well towards the achievement of its outcomes. Water insfrastructures have been developped and important of water is mobilized now for the agropastoral shade gardening. One major risk that has affected the project is an environmental risk. Indeed because of the aridity of the climate and hydrogeological conditions in the Grand an Petit Bara, the project is not able to mobilize the planned quantity of water. This is affecting the number of beneficiaries that is less than the plan at this stage of the project. Around 35 beneficiaries have been targeted until now and are pursuing their learning in agriculture.  "]
[]
[]
[]
[]
[null,null,null,"Progress on Key Milestones",null,"Expected Progress",null,"Progress to Date","Rating"]
[null,null,"Implementing Agency  ","Construction of water infrastructures for the harvest of underground water or surface water ",null,"At the year 3 of the project, 6 boreholes will be developped as well as 6 earth dams and 8 subsurface dams. Creation of community water management committee",null,"2 boreholes are developped, 1 earth dam and 1 check dam playing the role of subsurface dam. The quantity of water mobilized by the project is less than what was expected and planned in the project document because of unexpected low delivery of the boreholes constructed by the project. Although sophisticated geophysical and hydrogeolical studies have been performed for the sitting of the wells, the final results was below the expected results, Community management committees established in two sites.","MS"]
[null,null,null,"Development of the shade gardens",null,"From the year 2 to year 4 of the project 6 sets of 38 hectares each will be developped. ",null,"While the quantity of water made available is less than the initial projections, the project is nevertheless making marginally good progress towards this outcome. In order to reach the initial number of targeted families (228 families), the project has reduced the area of the land given to one family from the one hectare initially planned to quarter of hectare. So far 35 families have been reached.  ","MS"]
[null,null,null,"Rural beneficiaries are organized into agricultural anf financial cooperatives, have access to microfinance and develop climate resilient agro-pastoral enterprises",null,"Targeted rural microfinance products developped, capacity building for the microfinance institutions, technical guides developped, financial cooperatives  ",null,"Rural microfinance developped products, technical guides in development. ","MS"]
[{"$nulls":7},"Overall Rating","MS"]
[null,null,null,"Please Provide the Name and Contact information of person(s) reponsible for completeling the Rating section"]
[null,null,null,"Name: ","Idriss Ahmed Hared, climate change policy specialist"]
[null,null,null,"Email: ","idriss.hared@undp.org   "]
[]
[null,null,null,"Progress on Key Milestones",null,"Expected Progress",null,"Progress to Date","Rating"]
[null,null,"Other"]
[]
[]
[{"$nulls":7},"Overall Rating"]
[null,null,null,"Please Provide the Name and Contact information of person(s) reponsible for completeling the Rating section"]
[null,null,null,"Name: "]
[null,null,null,"Email: "]
[]
[null,null,null,"Please justify your rating and address the following points:\n1. Indicate trends, both positive and negative, in achievement of outcomes as per the project indicators.  \n2.  Detail critical risks that have affected progress.  \n3.  Outline response to MTR undertaken this reporting period.  \n4.  Outline action plan to address projects with a rating of HU, U or MU. Please keep your input to 1200 words",null,"The project is progressing slowly towards the achievement of the resuts. We are observing positive trends and considerable efforts are deployed for the success of the project both at the government level and UNDP level. However the project is facing some environmental risks coming from the aridity of Djibouti and translating in a lesser capacity of flowrates of the boreholes. This is constraining the achievement of  the outcome 1 and hence outcome 2 and 3 as the three components of the project are interlinked. The project team  has decided to conduct additional geophysical studies and identify new sites for boreholes drilling in order to maximise the probablity of good flowrate. While developping the new boreholes, the 2 already developped boreholes will be equiped with pumping systems and supply water to drip irrigation farm producing mainly vegetables and fruits. This is to be developped early 2016. "]
[]
[{"$nulls":6},"Rating Definitions"]
[{"$nulls":5},"Highly Satisfactory (HS)","Project actions/activities planned for current reporting period are progressing on track or exceeding expectations to acheive all  major outcomes/outputs for given reporting period, without major shortcomings. The project can be presented as “good practice”."]
[{"$nulls":5},"Satisfactory (S)","Project actions/activities planned for current reporting period  are progressing on track to achieve most of its major outcomes/outputs with only minor shortcomings."]
[{"$nulls":5},"Marginally Satisfactory (MS)","Project actions/activities planned for current reporting period  are progressing on track to achieve most   major relevant outcomes/outputs, but with either significant shortcomings or modest overall relevance. "]
[{"$nulls":5},"Marginally Unsatisfactory (MU)","Project actions/activities planned for current reporting period  are not progressing on track to achieve  major outcomes/outputs with major shortcomings or is expected to achieve only some of its major outcomes/outputs."]
[{"$nulls":5},"Unsatisfactory (U)","Project actions/activities planned for current reporting period  are not progressing on track to achieve most of its major outcomes/outputs."]
[{"$nulls":5},"Highly Unsatisfactory (U)","Project actions/activities planned for current reporting period  are not on track and shows that it is failing to achieve, and is not expected to achieve, any of its outcomes/outputs."]

{"sheet":"Project Indicators","index":5,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,2,30,2],[10,2,11,2],[12,2,13,2],[16,2,17,2],[18,2,19,2],[22,2,24,2],[27,2,28,2],[2,2,2,7],[3,2,3,7],[4,2,4,7],[6,3,6,4],[7,3,7,4],[5,2,5,3],[8,3,8,4],[9,3,9,4],[30,3,30,4],[24,3,24,4],[18,3,18,4],[12,3,12,4],[29,3,29,4],[22,3,22,4],[23,3,23,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[15,3,15,4],[20,3,20,4],[21,3,21,4],[19,3,19,4],[10,3,10,4],[11,3,11,4],[13,3,13,4],[14,3,14,4],[16,3,16,4],[17,3,17,4]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"PROJECT Indicators"]
[null,null,"Please provide all indicators being tracked for the project as outlined in the project document"]
[]
[null,null,"Type of Indicator (indicators towards Objectives, Outcomes, etc…)"]
[null,null,"Type of Indicator","Indicator",null,"Baseline","Progress since inception","Target for Project End"]
[null,null,"outcome 1","indicator 1,1, Number of planned boreholes, dams and water storage basins with associated solar pumping equipment in place and operational",null,"Existing water infrastrucres in the project areas: 2 borehole, 1 earth dam with a capacity of 500,000 cubic meter. Weak liability of installed solar pumping systems.","Exploration of undergroung water finalized. Additional geophysics may be needed in order to confirm or find new areas within the Grand Bara and Petit Bara that could have more water. ","6 boreholes, 6 earth dams, 8 subsurface dams, 6 reservoirs, 6 solar pumping equipment"]
[null,null,null,"indicator 1,2, Water resource secured for shade garden irrigation to cover 228 ha and serve 30 000 people",null,"In the project zones, only 10 hectares are cultivated with the existing water infrastructures","exploration of undergroung water finalized, drilling program ready. surface water harvesting program on the final design stage, topography and geotechnical studies completed","228 ha and at least 30,000 people are served with secure water infrastructure"]
[null,null,"output 1.1","indicator 1.1.1: approved detailed EIA and submission ,,,,",null,"The Grand Bara and Petit Bara regions (project sites) are experiencing important land degradation. But there are not existing detailed studies describing the land degradation, biodiversity in the areas  ","EIE completed and finalized. There is not any displacement of population according to the EIE. All agropastoral shaded gardens are located within a distance of less than 3 km from the house of the communities. EIE validated and accepted by the Direction of Environment ","Completion of  EIA and pedological, hydrological, and hydro-geological "]
[null,null,"Output 1.2","indicator 1.2.1: percentage of total hectares of agro-pastoralists land which is irrigated by boreholes",null,"31 hectares are irrigated by the boreholes at this time","development of 12 ha in Rakoubiyeel and 1 ha in Omar Djagac representing 5,26% of the total target. Additional 12 hectares are in development in Hamboucto supported by 11 shallow wells and surface check dam. In the Yabeh area, additional 5 hectares are in development and that will be irrigated by a borehole delivering 50 cubic meter of water per day, In Omar Jagac, a borehole delivering 20 cubic meter of water per day will irrigate 2 hectares by drip irrigation.","228 ha "]
[null,null,null,"indicator 1.2.2 Amount of time spent in search of water from boreholes",null,"according to the WFP annual food security assessment report 2013, the time spent in search of water is 30 minutes for Arta and Ali Sabieh populations","2 Boreholes completed that are able to provide 70 cubic meter of water per day","less than 30 minutes"]
[null,null,"Output 1,3, ","indicator:1.3.1.Percentage of total hectares of agropastoralists land which is irrigated by surface water sources",null,"Only 7 hectares are irrigated by the surface water at this time","development of 7 ha in Kourtimalei fully functionnal irrigated by an earth dam of 500,000 cubic meter rehabilated and upgraded by the project","228 ha"]
[null,null,null,"indicator:1.3.2.amount of time in search of water from surface water sources",null,"according to the WFP annual food security assessment report 2013, the time spent in search of water is 30 minutes for Arta and Ali Sabieh populations","The project has increased the amount of water available for communities and thus reducing the time to search water, ","less than 30 minutes"]
[null,null,"output 1.4","indicator: 1.4.1:Number of maintenance efforts on water systems and percentage of successful local maintance efforts",null,"none","not yet","10 maintenances  "]
[null,null,null,"indicator: 1.4.2:  management plans and good practice guidelines emphasized and enforced by the water infrastructure management committee",null,"none","not yet","1 climate smart management plan for surface water and 1climate smart management plan for groundwater resources"]
[null,null,"outcome 2","indicator 2.1: Number of shade gardens developed including irrigation reservoirs, distribution networks, and fencing",null,"zero","7 shade gardens systems developped or in final stage of development totalizing 36 ha, including 17 irrigation reservoirs totalizing around 1 000 cubic meters of storage capacity, 4300 linear meter of robust fencing and the adequate distribution network irrigation completed or under final stage of completion","six sets of 38 pilot"]
[null,null,null,"indicator:2.2: % of population who has developed shade gardens resilient to climate change",null,"zero","Around 35 families engaged in agropastoral shade gardening at this stage","2800 people"]
[null,null,"output 2.2: ","indicator 2.2.1: number of project beneficiaries disaggregated according to gender who that have been trained on cultivation techniques, crop rotation, livestock hygiene etc by specialists",null,"zero","10 women over 35 beneficiaries s","228  families"]
[null,null,null,"indicator 2.2.2: percentage change in beneficiaries capacities to cultivate their own land and raise livestock autonomouly",null,"zero","Most of the beneficiaries are changing their behavior and cultivating their land. On the 35 beneficiairy targeted at this stage, 2 were not able to continue to practice agriculture.",1]
[null,null,"output 2.3:","indicator 2.3.1: number of constructed storage facilities per agropastoral zone",null,"zero","two  storages construction completed: Kourtimalei and Rakoubyeel","6 constructed storages"]
[null,null,null,"indicator 2.3.2: percentage of beneficiaries that utilize storage facilities",null,"zero","27 agropastoral families of existing shade gardens  using new storage facilities representing 12% of total targeted families",1]
[null,null,"outcome 3","indicator 3.1: Number of MF products deployed to agro-pastoralists which provide loans ear-marked for adaptation to climate-change",null,"zero","Progress in advocating for the provision of a government micro-credit line earmarked for adaptation activities. ","7 different types of products to be deployed by the end of the projects: 1) water equipment and resource (drip irrigation, pumping equipment, water harvesting), 2) livestock product;3)agricultural inputs (4) loans for creating small climate change agro-pastoral enterprises"]
[null,null,null,"indicator:3.2: % of total population using microcredit products",null,"zero","not yet",1]
[null,null,null,"indicator :3.3: community- driven adaptation plans are integrated into National Programme for Food Security and the National MF policy",null,"zero","not yet","4 adaptation plans"]
[null,null,"output 3.1.","indicator:3.1.1: percentage of beneficiaries trained in microcredit principles",null,"zero","not yet",1]
[null,null,null,"indicator:3.1.2: number of technical guides prepared detailing how MF can be used for adaptation oriented activities ",null,"zero","technical guides not yet prepared but steps have been taken: study on adaptation oriented agropastoral product has been delivered, technical guides will be available in 2014","1 comprehensive technical guide"]
[null,null,"ouput 3.2","indicator 3.2.1: number of loans and percentage of payback on loans",null,"zero","not yet","228 loans at least  and expected 100% paybacks"]
[null,null,null,"indicator 3.2.2: percentage of population in each tier of 3-tiered microfinance programme (safety net, nao, and microfinance)",null,"zero","not yet","to be determined"]
[null,null,"output 3.3","indicator: 3.3.1: percentage of population which has been organized into adaptation plan cooperatives",null,"zero","not yet",1]
[null,null,null,"indicator : 3.2.2: Attendance and participation at bi-annual workshops used to document community recommended measures to improve the adaptation oriented microfinance products",null,"zero","not yet","6 bi-annual workshop expected to be conducted with the attendance and participation of approximately 300 persons"]

{"sheet":"Lessons Learned","index":6,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,2,23,3],[2,2,2,3],[11,2,11,3],[13,2,13,3],[16,2,16,3],[19,2,19,3]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"QUALITATIVE MEASURES and LESSONS LEARNED"]
[]
[null,null,"Please complete the following section every reporting period"]
[null,null,"Implementation and Adaptive Management","Response"]
[null,null,"What implementation issues/lessons, either positive or negative, affected progress?","Coordination among involved institutions was difficult to operate at the starting of the project and is still a challenge for the project. Howver the coordination has improved very well as the project is progressing in the implementation."]
[null,null,"Were there any delays in implementation?  If so, include any causes of delays. What measures have been taken to reduce delays?","Yes there were delays in the implementation of the project, in particular the development of the drilling of the boreholes and construction of rainwater harvesting infrastructures. The reason is that the engagement of the involved technical institutions and the delivery of the outcomes of the scientific studies undertaken by these institutions were been delayed. As such we are experiencing currently several months of delay. To reduce the delays, the project management unit has discussed with the technical committee of the project and the steering committee of the project to find solutions. Three measures have been proposed by these committees in order to reduce the delays: (i) call for the acceleration of the scientific studies to the national institutions (ii) strategic decision to anticipate the construction  of the agricultural infrastructures for 12 hectares and strenghtening of existing 6 hectares in the project zones(iii) the contractual companies were convened and ordered to speed up the construction of infrastructures, Measures taken has improved the execution of the project and 2 boreholes were developped, However 4 boreholes are still remaining to be developped."]
[null,null,"Describe any changes undertaken to improve results on the ground or any changes made to project outputs (i.e. changes to project design)","In the project document it was expected to issue 1 hectare per family, According to thoses involved projects in the zone, it is expected to start with 0,5 hectares per family. The project has decided further to give 0,25 hectares per family in order to benefit to a maximum of persons."]
[null,null,"How have gender considerations been taken into consideration during the reporting period? What have been the lessons learned as a consequence of inclusion of such considerations on project performance or impacts?","It is planned in the project to construct several plant nurseries managed by women. The project management unit has identified already the group of women as well as the villages in which the nurseries will be sitted. The Omar Jagac and Rakoubyeel villages have been identified to host the nurseries because of the already existing water wells and because these sites are close to already identified  agro-pastoral areas. "]
[]
[null,null,"Please complete the following section at mid-term and project completion"]
[null,null,"Lessons for Adaptation","Response"]
[null,null,"Climate Resilience Measures"]
[null,null,"What have been the lessons learned, both positive and negative, in implementing climate adaptation measures that would be relevant to the design and implementation of future projects/programmes for enhanced resilience to climate change?","According that producers are at the beginning, the physical strength is a limiting factor as result implemented in the project zone by other partner, So 1 hectare for each family will be cut down to 0,5 hectare per family. The figure of 0,5 hectare could be donwsized to 0,25 hectares as the quantity of water mobilized is less than what the project was expecting."]
[null,null,"What is the potential for the climate resilience measures undertaken by the project/programme to be replicated and scaled up both within and outside the project area?","The project held the positive experiences of other projects to identify and select plants resistant to drought and salt tolerant, and practice of efficient irrigation equipment."]
[null,null,"Concrete Adaptation Interventions"]
[null,null,"What have been the lessons learned, both positive and negative, in implementing concrete adaptation interventions that would be relevant to the design and implementation of future projects/programmes implementing concrete adaptation interventions?"]
[null,null,"What is the potential for the concrete adaptation interventions undertaken by the project/programme to be replicated and scaled up both within and outside the project area?"]
[null,null,"Community/National Impact"]
[null,null,"What would you consider to be the most successful aspects for the target communities?"]
[null,null,"What measures are/have been put in place to ensure sustainability of the project/program results?"]
[null,null,"What measures are being/could have been put in place to improve project/program results?"]
[null,null,"Knowledge Management "]
[null,null,"How has existing information/data/knowledge been used to inform project development and implementation? What kinds of information/data/knowledge were used?"]
[null,null,"If learning objectives have been established, have they been met? Please describe."]
[null,null,"Describe any difficulties there have been in  accessing or retrieving existing information (data or knowledge) that is relevant to the project. Please provide suggestions for improving access to the relevant data."]
[null,null,"Has the identification of learning objectives contributed to the outcomes of the project? In what ways have they contributed?"]

{"sheet":"Results Tracker","index":7,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[29,5,29,12],[30,5,30,6],[36,5,36,12],[34,5,34,6],[34,7,34,8],[34,9,34,10],[30,7,30,8],[33,1,33,12],[35,9,35,10],[35,11,35,12],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[31,7,31,8],[31,9,31,10],[31,11,31,12],[34,11,34,12],[35,5,35,6],[35,7,35,8],[26,1,26,12],[27,5,27,6],[27,7,27,8],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[30,9,30,10],[30,11,30,12],[31,5,31,6],[19,1,19,12],[22,5,22,12],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[27,9,27,10],[27,11,27,12],[28,5,28,6],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[28,7,28,8],[28,9,28,10],[28,11,28,12],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[10,1,10,3],[13,5,13,6],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[1,2,1,6],[13,7,13,8],[13,9,13,10],[5,1,6,12],[7,1,7,12],[8,1,8,12],[2,2,2,5],[12,1,12,12],[13,11,13,12],[15,5,15,12],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Results Tracker for Adaptation Fund (AF)  Projects    "]
[]
[]
[null,"Goal: Assist developing-country Parties to the Kyoto Protocol that are particularly vulnerable to the adverse effects of climate change in meeting the costs of concrete adaptation projects and programmes in order to implement climate-resilient measures. Impact: Increased resiliency at the community, national, and regional levels to climate variability and change. "]
[]
[null,"Important: Please read the following Results Framework and Baseline Guidance (also posted on the Adaptation Fund website) before entering your data "]
[null,"Link: http://www.adaptation-fund.org/sites/default/files/Results%20Framework%20and%20Baseline%20Guidance%20final.pdf"]
[]
[null,"Please select the relevant Fund level Outcome and Output indicators that allign with the project objectives and outcomes"]
[]
[null,"OBJECTIVE 1"]
[null,"Fund Outcome","Please select  from dropdown menu below","Fund Outcome Indicator","Please select  from dropdown menu below","Target at project/programme approval     (see Units in next sheet)",null,"Baseline                 (see Units in next sheet)",null,"Mid-term Results",null,"Terminal Results"]
[null,"Outcome 1: Reduced exposure at national level to climate-related hazards and threats\nOutcome 2: Strengthened institutional capacity to reduce risks associated with climate-induced socioeconomic and environmental losses\nOutcome 3: Strengthened awareness and ownership of adaptation and climate risk reduction processes at local level\nOutcome 4: Increased adaptive capacity within relevant development and natural resource sectors\nOutcome 5: Increased ecosystem resilience in response to climate change and variability-induced stress\nOutcome 6: Diversified and strengthened livelihoods and sources of income for vulnerable people in targeted areas                                                                                                 Outcome 7: Improved policies and regulations that promote and enforce resilience measures",4,"1. Relevant threat and hazard information generated and disseminated to stakeholders on a timely basis\n2.1. No. and type of targeted institutions with increased capacity to minimize exposure to climate\nvariability risks\n2.2. Number of people with reduced risk to extreme weather events\n3.1. Percentage of targeted population aware of predicted adverse impacts of climate change, and of\nappropriate responses\n3.2. Modification in behavior of targeted population\n4.1. Development sectors' services responsive to evolving needs from changing and variable climate                                                                                            \n4.2. Physical infrastructure improved to withstand climate change and variability-induced stress                                                                                 \n5. Ecosystem services and natural assets maintained or improved under climate change and\nvariability-induced stress                                                                                                                                                          6.1. Percentage of households and communities having more secure (increased) access to livelihood\nassets                                                                                                                                                                                                6.2. Percentage of targeted population with sustained climate-resilient livelihoods                                                                                           7. Climate change priorities are integrated into national development strategy","4.2","4.2 Fully improved By project completion, targeted rural communities of Grand Bara and Petit Bara will have secured and sustainable quantities of water for both agricultural, pastoral and drinking purposes and cost recovery mechanisms will be put in place as well as capacity of the ministry of water reinforced ",null,"Currently, water availaibility even for drinking purposes is not secured in Grand Bara and Petit Bara. For the existing water points, there is not water use permit in place.",null,"The project has increased the amount of water available for both farmers and livestock herders in the project areas. The project has still 6 infratsructures to build including 4 boreholes and 2 earth dams. Some shallow wells will be also added."]
[]
[null,"Fund Output","Please select  from dropdown menu below","Fund Output Indicator","Please select  from dropdown menu below","Target at project/programme approval     ",null,"Baseline                ",null,"Mid-term Results",null,"Terminal Results"]
[null,"Output 1: Risk and vulnerability assessments conducted and updated at a national level\nOutput 2.1: Strengthened capacity of national and regional centres and networks to respond rapidly to extreme weather events\nOutput 2.2: Targeted population groups covered by adequate risk reduction systems\nOutput 3: Targeted population groups participating in\nadaptation and risk reduction awareness activities\nOutput 4: Vulnerable physical, natural, and social assets strengthened in response to climate change impacts, including variability\nOutput 5: Vulnerable physical, natural, and social assets strengthened in response to climate change impacts, including variability                                                                                             Output 6: Targeted individual and community livelihood strategies strengthened in relation to climate change impacts, including variability                                                                            Output 7: Improved integration of climate-resilience strategies into country development plans",null,"1.1. No. and type of projects that conduct and update risk and vulnerability assessments                                                                                      \n1.2. Development of early warning systems\n2.1.1. No. of staff trained to respond to, and mitigate impacts of, climate-related events\n2.1.2. Capacity of staff to respond to, and mitigate impacts of, climate-related events from targeted\ninstitutions increased\n2.2.1. Percentage of population covered by adequate risk-reduction systems\n2.2.2. No. of people affected by climate variability                                                                                                          3.1 No. and type of risk reduction actions or strategies introduced at local level                                                                                                     3.2 No. of news outlets in the local press and media that have covered the topic                                                                                                    4.1. No. and type of health or social infrastructure developed or modified to respond to new conditions\nresulting from climate variability and change (by type)                                                                                                                                                            4. 2. No. of physical assets strengthened or constructed to withstand conditions resulting from climate variability and change (by asset types)                                                                                                                                   5. No. and type of natural resource assets created, maintained or improved to withstand conditions resulting from climate variability and change (by type of assets)                                                                                                                   \n6.1. No. and type of adaptation assets (physical as well as knowledge) created in support of individualor\ncommunity-livelihood strategies                                                                                                                                                   6.2. Type of income sources for households generated under climate change scenario                                                                                    \n7.1. No., type, and sector of policies introduced or adjusted to address climate change risks                                                                                 \n7.2. No. or targeted development strategies with incorporated climate change priorities enforced","4.2","By project completion, six water extraction boreholes, one injection well for artifical recharge, six earth dams with a minimal volumetric capacity of 300,000 cubic meter, eight subsurface dam will be constructed.  Water tariff permit will be established. At least 10 staff of the department of water will be trained on surface water harvesting, artificial recharge and sustainable water resources management.",null,"Altough the Grand Bara and Petit Bara host thousand of rural communities, the quantity of water availaible for agricultural purposes is small, There are only three boreholes and 4 earth dams mainly used for drinking water. Except one earth dam, all the three others have only small volumetric capacitites (twenty thousand cubic meter). There is not especific cost recovery for the access to this water currently.",null,"The project has increased the amount of water available for both farmers and livestock herders in the project areas. The project has still 6 infratsructures to build including 4 boreholes and 2 earth dams. Some shallow wells will be also added."]
[]
[null,"OBJECTIVE 2"]
[null,"Fund Outcome","Please select  from dropdown menu below","Fund Outcome Indicator","Please select  from dropdown menu below","Target at project/programme approval      (see Units in next sheet)",null,"Baseline",null,"Mid-term Results",null,"Terminal Results"]
[null,"Outcome 1: Reduced exposure at national level to climate-related hazards and threats\nOutcome 2: Strengthened institutional capacity to reduce risks associated with climate-induced socioeconomic and environmental losses\nOutcome 3: Strengthened awareness and ownership of adaptation and climate risk reduction processes at local level\nOutcome 4: Increased adaptive capacity within relevant development and natural resource sectors\nOutcome 5: Increased ecosystem resilience in response to climate change and variability-induced stress\nOutcome 6: Diversified and strengthened livelihoods and sources of income for vulnerable people in targeted areas                                                                                                 Outcome 7: Improved policies and regulations that promote and enforce resilience measures",null,"1. Relevant threat and hazard information generated and disseminated to stakeholders on a timely basis\n2.1. No. and type of targeted institutions with increased capacity to minimize exposure to climate\nvariability risks\n2.2. Number of people with reduced risk to extreme weather events\n3.1. Percentage of targeted population aware of predicted adverse impacts of climate change, and of\nappropriate responses\n3.2. Modification in behavior of targeted population\n4.1. Development sectors' services responsive to evolving needs from changing and variable climate                                                                                            4.2. Physical infrastructure improved to withstand climate change and variability-induced stress                                                                                 5. Ecosystem services and natural assets maintained or improved under climate change and\nvariability-induced stress                                                                                                                                                          6.1. Percentage of households and communities having more secure (increased) access to livelihood\nassets                                                                                                                                                                                                6.2. Percentage of targeted population with sustained climate-resilient livelihoods                                                                                           7. Climate change priorities are integrated into national development strategy","6.1","6.1 High improvement                    228  rural households are engaged in shade gardening activities  and have more secured livelihoods   ",null,"35,000 people leaving in rural areas of Ali-Sabieh and Arta regions in which are located Grand and Petit Bara.  Around 20,000 people are classified as food insecure people; average livestock asset is 10 goats per family; average daily income per person estimated 0,75 US dollar; There are only few families practigin agriculture in the targeted regions because of the water scarcity.",null,"The daily income of the communities engaged with the project has greatly improved to 4 US per day. Calculation is based on average sells of  2014. "]
[]
[null,"Fund Output","Please select  from dropdown menu below","Fund Output Indicator","Please select  from dropdown menu below","Target at project/programme approval     ",null,"Baseline",null,"Mid-term Results",null,"Terminal Results"]
[null,"Output 1: Risk and vulnerability assessments conducted and updated at a national level\nOutput 2.1: Strengthened capacity of national and regional centres and networks to respond rapidly to extreme weather events\nOutput 2.2: Targeted population groups covered by adequate risk reduction systems\nOutput 3: Targeted population groups participating in\nadaptation and risk reduction awareness activities\nOutput 4: Vulnerable physical, natural, and social assets strengthened in response to climate change impacts, including variability\nOutput 5: Vulnerable physical, natural, and social assets strengthened in response to climate change impacts, including variability                                                                                             Output 6: Targeted individual and community livelihood strategies strengthened in relation to climate change impacts, including variability                                                                            Output 7: Improved integration of climate-resilience strategies into country development plans",null,"1.1. No. and type of projects that conduct and update risk and vulnerability assessments                                                                                      \n1.2. Development of early warning systems\n2.1.1. No. of staff trained to respond to, and mitigate impacts of, climate-related events\n2.1.2. Capacity of staff to respond to, and mitigate impacts of, climate-related events from targeted institutions increased\n2.2.1. Percentage of population covered by adequate risk-reduction systems\n2.2.2. No. of people affected by climate variability                                                                                                          3.1 No. and type of risk reduction actions or strategies introduced at local level                                                                                                     \n3.2 No. of news outlets in the local press and media that have covered the topic                                                                                                    \n4.1. No. and type of health or social infrastructure developed or modified to respond to new conditions\nresulting from climate variability and change (by type)                                                                                                                                                            4. 2. No. of physical assets strengthened or constructed to withstand conditions resulting from climate variability and change (by asset types)                                                                                                                                   5. No. and type of natural resource assets created, maintained or improved to withstand conditions resulting from climate variability and change (by type of assets)                                                                                                                   \n6.1. No. and type of adaptation assets (physical as well as knowledge) created in support of individualor community-livelihood strategies                                                                                                                                                   6.2. Type of income sources for households generated under climate change scenario                                                                                    \n7.1. No., type, and sector of policies introduced or adjusted to address climate change risks                                                                                 \n7.2. No. or targeted development strategies with incorporated climate change priorities enforced","6.1","228 hectares of agricultural plots with robust enclosure and irrigationn network developped/ At least 6 tree nurseries managed by women created/ t Training on agricultural techniques provided to 228 new farmers",null,"Only few families are practicing the agriculture in the Petit Bara and Grand Bara areas",null,"Additional 35 families are practicing agriculture in 2015. "]
[]
[null,"OBJECTIVE 3"]
[null,"Fund Outcome","Please select  from dropdown menu below","Fund Outcome Indicator","Please select  from dropdown menu below","Target at project/programme approval     ",null,"Baseline",null,"Mid-term Results",null,"Terminal Results"]
[null,"Outcome 1: Reduced exposure at national level to climate-related hazards and threats\nOutcome 2: Strengthened institutional capacity to reduce risks associated with climate-induced socioeconomic and environmental losses\nOutcome 3: Strengthened awareness and ownership of adaptation and climate risk reduction processes at local level\nOutcome 4: Increased adaptive capacity within relevant development and natural resource sectors\nOutcome 5: Increased ecosystem resilience in response to climate change and variability-induced stress\nOutcome 6: Diversified and strengthened livelihoods and sources of income for vulnerable people in targeted areas                                                                                                 Outcome 7: Improved policies and regulations that promote and enforce resilience measures",null,"1. Relevant threat and hazard information generated and disseminated to stakeholders on a timely basis\n2.1. No. and type of targeted institutions with increased capacity to minimize exposure to climate variability risks\n2.2. Number of people with reduced risk to extreme weather events\n3.1. Percentage of targeted population aware of predicted adverse impacts of climate change, and of appropriate responses\n3.2. Modification in behavior of targeted population\n4.1. Development sectors' services responsive to evolving needs from changing and variable climate                                                                                            4.2. Physical infrastructure improved to withstand climate change and variability-induced stress                                                                                 \n5. Ecosystem services and natural assets maintained or improved under climate change and variability-induced stress                                                                                                                                                          6.1. Percentage of households and communities having more secure (increased) access to livelihood assets                                                                                                                                                                                                6.2. Percentage of targeted population with sustained climate-resilient livelihoods                                                                                           \n7. Climate change priorities are integrated into national development strategy","6.2","A three-tiered adaptation-oriented micro-finance scheme that supports climate-resilient shade\ngardening practices in the Grand and Petit Bara plains developed through partnership with ADDS which\ngenerates a total value of US$ 300,000 throughout the project for 228 families. Daily food consumption is not included in this income.",null,"According to 2012 WFP assessment in rural areas, the daily income of these families is 0,75 $ US per person and they have to use this income for all their needs including the food (when the WFP food aid is not availaible). ",null,"The daily income of the communities engaged with the project has greatly improved to 4 US per day. Calculation is based on average sells of the 2014. "]
[]
[null,"Fund Output","Please select  from dropdown menu below","Fund Output Indicator","Please select  from dropdown menu below","Target at project/programme approval     ",null,"Baseline",null,"Mid-term Results",null,"Terminal Results"]
[null,"Output 1: Risk and vulnerability assessments conducted and updated at a national level\nOutput 2.1: Strengthened capacity of national and regional centres and networks to respond rapidly to extreme weather events\nOutput 2.2: Targeted population groups covered by adequate risk reduction systems\nOutput 3: Targeted population groups participating in\nadaptation and risk reduction awareness activities\nOutput 4: Vulnerable physical, natural, and social assets strengthened in response to climate change impacts, including variability\nOutput 5: Vulnerable physical, natural, and social assets strengthened in response to climate change impacts, including variability                                                                                             Output 6: Targeted individual and community livelihood strategies strengthened in relation to climate change impacts, including variability                                                                            Output 7: Improved integration of climate-resilience strategies into country development plans",null,"1.1. No. and type of projects that conduct and update risk and vulnerability assessments                                                                                      \n1.2. Development of early warning systems\n2.1.1. No. of staff trained to respond to, and mitigate impacts of, climate-related events\n2.1.2. Capacity of staff to respond to, and mitigate impacts of, climate-related events from targeted\ninstitutions increased\n2.2.1. Percentage of population covered by adequate risk-reduction systems\n2.2.2. No. of people affected by climate variability                                                                                                          3.1 No. and type of risk reduction actions or strategies introduced at local level                                                                                                     \n3.2 No. of news outlets in the local press and media that have covered the topic                                                                                                    \n4.1. No. and type of health or social infrastructure developed or modified to respond to new conditions resulting from climate variability and change (by type)                                                                                                                                                            4. 2. No. of physical assets strengthened or constructed to withstand conditions resulting from climate variability and change (by asset types)                                                                                                                                   5. No. and type of natural resource assets created, maintained or improved to withstand conditions resulting from climate variability and change (by type of assets)                                                                                                                   \n6.1. No. and type of adaptation assets (physical as well as knowledge) created in support of individualor\ncommunity-livelihood strategies                                                                                                                                                   6.2. Type of income sources for households generated under climate change scenario                                                                                    \n7.1. No., type, and sector of policies introduced or adjusted to address climate change risks                                                                                 \n7.2. No. or targeted development strategies with incorporated climate change priorities enforced","6.2","By the completion of the project, the 228 targted beneficiary families will have diversified income from the sell of agricultural products (vegetables, fruits, forage) and pastoral products (goats, goats and cows milk) ",null,"Currently the income of 228 targeted rural families is mainly based on the sell of animals (one to two animals per year generating a maximum of 100 USD), charcoal (increasing the depletion of scarce wood resources) and  remittance from their families leaving in cities.",null,"Engaged communities in the project have diversified their income sources. The sells of agricultural products is a new income resource for them. This include the sells of vegetables, fruits and milk.  "]
[]
[null,"OBJECTIVE 4"]
[null,"Fund Outcome","Please select  from dropdown menu below","Fund Outcome Indicator","Please select  from dropdown menu below","Target at project/programme approval     ",null,"Baseline",null,"Mid-term Results",null,"Terminal Results"]
[null,"Outcome 1: Reduced exposure at national level to climate-related hazards and threats\nOutcome 2: Strengthened institutional capacity to reduce risks associated with climate-induced socioeconomic and environmental losses\nOutcome 3: Strengthened awareness and ownership of adaptation and climate risk reduction processes at local level\nOutcome 4: Increased adaptive capacity within relevant development and natural resource sectors\nOutcome 5: Increased ecosystem resilience in response to climate change and variability-induced stress\nOutcome 6: Diversified and strengthened livelihoods and sources of income for vulnerable people in targeted areas                                                                                                 Outcome 7: Improved policies and regulations that promote and enforce resilience measures",null,"1. Relevant threat and hazard information generated and disseminated to stakeholders on a timely basis\n2.1. No. and type of targeted institutions with increased capacity to minimize exposure to climate variability risks\n2.2. Number of people with reduced risk to extreme weather events\n3.1. Percentage of targeted population aware of predicted adverse impacts of climate change, and of appropriate responses\n3.2. Modification in behavior of targeted population\n4.1. Development sectors' services responsive to evolving needs from changing and variable climate                                                                                            4.2. Physical infrastructure improved to withstand climate change and variability-induced stress                                                                                 5. Ecosystem services and natural assets maintained or improved under climate change and variability-induced stress                                                                                                                                                          6.1. Percentage of households and communities having more secure (increased) access to livelihood assets                                                                                                                                                                                                6.2. Percentage of targeted population with sustained climate-resilient livelihoods                                                                                           7. Climate change priorities are integrated into national development strategy"]
[]
[null,"Fund Output","Please select  from dropdown menu below","Fund Output Indicator","Please select  from dropdown menu below","Target at project/programme approval     ",null,"Baseline",null,"Mid-term Results",null,"Terminal Results"]
[null,"Output 1: Risk and vulnerability assessments conducted and updated at a national level\nOutput 2.1: Strengthened capacity of national and regional centres and networks to respond rapidly to extreme weather events\nOutput 2.2: Targeted population groups covered by adequate risk reduction systems\nOutput 3: Targeted population groups participating in\nadaptation and risk reduction awareness activities\nOutput 4: Vulnerable physical, natural, and social assets strengthened in response to climate change impacts, including variability\nOutput 5: Vulnerable physical, natural, and social assets strengthened in response to climate change impacts, including variability                                                                                             Output 6: Targeted individual and community livelihood strategies strengthened in relation to climate change impacts, including variability                                                                            Output 7: Improved integration of climate-resilience strategies into country development plans",null,"1.1. No. and type of projects that conduct and update risk and vulnerability assessments                                                                                      \n1.2. Development of early warning systems\n2.1.1. No. of staff trained to respond to, and mitigate impacts of, climate-related events\n2.1.2. Capacity of staff to respond to, and mitigate impacts of, climate-related events from targeted institutions increased\n2.2.1. Percentage of population covered by adequate risk-reduction systems\n2.2.2. No. of people affected by climate variability                                                                                                          3.1 No. and type of risk reduction actions or strategies introduced at local level                                                                                                     \n3.2 No. of news outlets in the local press and media that have covered the topic                                                                                                    \n4.1. No. and type of health or social infrastructure developed or modified to respond to new conditions resulting from climate variability and change (by type)                                                                                                                                                            4. 2. No. of physical assets strengthened or constructed to withstand conditions resulting from climate variability and change (by asset types)                                                                                                                                   5. No. and type of natural resource assets created, maintained or improved to withstand conditions resulting from climate variability and change (by type of assets)                                                                                                                   \n6.1. No. and type of adaptation assets (physical as well as knowledge) created in support of individualor community-livelihood strategies                                                                                                                                                   6.2. Type of income sources for households generated under climate change scenario                                                                                    \n7.1. No., type, and sector of policies introduced or adjusted to address climate change risks                                                                                 \n7.2. No. or targeted development strategies with incorporated climate change priorities enforced"]

{"sheet":"Units for Indicators","index":8,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null," Fund Outcome Indicator Units"]
[null,"1. Generation of relevant data, Stakeholders, and Timeliness \n2.1. Include both qualitative and quantitative measures of capacity level within targeted institutions\n2.2. Number (men and women and other vulnerable groups)\n3.1. Use scale from 1 to 5: 5: Fully aware 4: Mostly aware 3: Partially aware 2: Partially not aware 1: Aware of neither predicted adverse impacts of climate change nor of appropriate responses\n3.2. Use scale from 1 to 5:  5: All 4: Almost all 3: Half 2: Some 1: None\n4.1. Summarize in an overall scale (1-5): 5: Highly responsive (All defined elements ) 4: Mostly responsive (Most defined elements) 3: Moderately responsive (Some defined elements) 2: Partially responsive (Lacks most elements) 1: Non responsive (Lacks all elements )                                                                                                                                                                                                                    4.2.  Summarize in an overall scale (1-5):  5: Fully improved 4: Mostly Improved 3: Moderately improved 2: Somewhat improved\n1: Not improved                                                                                                                                                                                                                           5.  Depends on the targeted natural asset: \nBiological (species): measure through changes in population numbers (dynamics, structure, etc.)\nLand: measure changes in hectares. Baseline data will be necessary to estimate the change. Supporting indicators baseline and target (as well as contextual information) are needed such as the following: Farmers adopting recommended technologies, Ha. of land improved, Average deforestation rate Etc.\nUse scale from 1 to 5.  5: Very effective (All elements are present) 4: Effective (Most elements are present) 3: Moderately effective (Some elements are present) 2: Partially effective (Most elements are not present) 1: Ineffective (No elements are present)\n6.1.  Summarize in an overall scale (1-5):  5: Very high improvement 4: High improvement 3: Moderate improvement 2: Limited improvement 1: No improvement                                                                                                                                                                                                                                                         6.2.  Household income by source of livelihood in project area (USD) prior and post project intervention                                                                                                                                                                                                                                                      7. Summarize in an overall scale (1-5).  5: All (Fully integrated) 4: Most 3: Some 2: Most not integrated 1: None"]
[null,"Fund Output Indicator Units"]
[null,"1.1.  Number, sector(s) and level(s) of projects or interventions in separate fields of monitoring plan                                                                                  1.2. Number\n2.1.1. Number of staff (male/female) of targeted institutions: a. Obtain baseline information: total number of staff from targeted institutions b. Define target\n2.1.2. Number of staff (male/female) of targeted institutions: a. Obtain baseline information: total number of staff from targeted institutions b. Define target: needs to be defined by project proponents\n2.2.1. Quantitative: Percentage (includes women – and other vulnerable groups – and men).\nQualitative: Adequacy: include direct analysis of major areas; adequacy/effectiveness of systems or analysis of perceptions of populations and institutions.\n2.2.2. Number (broken down by gender and, if possible, by vulnerable groups defined in the area of intervention) of people                                                                                                        3.1. Number and type (in separate columns) at local level.                                                                                                                                    3.2. Number                                                                                                                                                                                                                                     4.1. Number and type                                                                                                                                                                                                               4. 2.  Number and type (entered in separate columns)                                                                                                                                                     5.  Number of interventions by type of natural asset and intervention                                                                                                                    6.1.  Number and type (in separate columns of monitoring plan)                                                                                                                                                                                                                                                    6.2. Income sources per household; description of income source and number of households.                                                                                                                                                                                                                                                     7.1.  Number/Sector                                                                                                                                                                                                                                                   7.2. Number; Effectiveness (see previous indicator) through enforcement level."]