{"text_format":"2","workbook":"xls","n_sheets":9,"sheets":["Overview","FinancialData","Procurement","Risk Assesment","Rating","Project Indicators","Lessons Learned","AF Tracking Tool","Units for Indicators"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":2,"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":18,"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]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,null,"Project Performance Report (PPR)"]
[]
[null,null,"Period of Report (Dates)","March 2011 - June 2013"]
[]
[null,null,"Project Title: ","Reduction of Risks and Vulnerability Based on Flooding and Droughts in the Estero Real River Watershed."]
[]
[]
[]
[]
[]
[null,null,"Project Summary: ","The programme is aimed to reduce risks from droughts and flooding generated by climate change and variability in the watershed of the Estero Real River. In Chinandega and León, the Estero Real River Watershed (3.690 km2), and in particular the sub watershed of the Villanueva River (1,550 km2)—also known as Rio Grande or Aquespalapa—is emblematic of the combined impacts of poor development models and strong climate variability.\nThe programme will rely upon a coordinated set of interventions designed to implement new public policies for addressing climate change by introducing agro-ecological practices and participatory watershed management in highly vulnerable rural communities. Through targeted investments in water retention, long-term farm planning, and institutional capacity building in local communities, municipalities and government agencies, the Programme will validate an adaptation scheme as a vehicle for implementation of the national climate change strategy.\n"]
[{"$nulls":9},"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: ","PIMS # 4448",{"$nulls":5},"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",{"$nulls":5},"Albania","MSP","No","Climate Change Adaptation",2,2,"S","BD-SP2-Marine PA","2: Coastal, marine & freshwater ecosystems"]
[null,null,"Type of IE:","Multilateral ",{"$nulls":5},"Algeria","EA",null,"Climate Change Mitigation",3,3,"MU","BD-SP3-PA Networks","3: Forest ecosystems"]
[null,null,"Country(ies): ","Nicaragua",{"$nulls":5},"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,"Watershed of the Estero Real River, sub watershed of Villanueva River.",{"$nulls":5},"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":14},"CC-SP2- Industrial EE","8: Water body based operational program"]
[null,null,"Project Milestones",{"$nulls":11},"CC-SP3-RE,CC-SP4-Biomass","9: Integrated Land and Water multiple focal area"]
[null,null,"Milestone",{"$nulls":6},"Bahamas",{"$nulls":6},"CC-SP5-Transport","10: Contaminants based operational program"]
[null,"AFB Approval Date:",null,"December, 2010"]
[]
[null,"IE-AFB Agreement Signature Date:",null,"March, 2011",{"$nulls":11},"CC-SP6-LULUCF","12: Integrated Ecosystem Management"]
[null,"Start of Project/Programme:",null,"March, 2011",{"$nulls":11},"Cross cutting capacity building","14: Persistent Organic Pollutants"]
[null,"Mid-term Review Date (if planned):",null,"July, 2013"]
[null,null,"Terminal Evaluation Date:","March, 2015"]
[]
[null,null,null,"List documents/ reports/ brochures / articles that have been prepared about the project.",{"$nulls":5},"Cyprus"]
[null,null,null,"Operations Manual for the Project Reduction of Risks and Vulnerability based on flooding and droughts in the watershed of the Estero Real River; \nMethodological Guidelines to Formulate Agroecological Farm Transformation Plans; \nMonthly Follow-up Reports from MARENA and Quarterly Reports from UNPD; \nYearly Management Report: 2011, 2012 and first semester 2013 (Government), News Bulletins in 2013: April, May and June; \nDemarcation Study of Riparian and Water Recharge Zones;\nThree Municipal Climate Change Adaptation Plans;\nStudy of threats based on floods in the urban area of Villanueva and neighboring towns; \n8 Riparian Zone signs, 8 signs for the Salale and Las Mercedes Irrigation Systems, 100 signs for forest protection areas, 500 decals to disseminate information on the rainwater catchment work carried out in the 8 targeted micro watersheds;\nMaps of 8 micro watersheds regarding changes in land use, monitoring of hot spots, risk analysis, irrigation systems, investment system, database on gender situation.\n",{"$nulls":5},"Czech Republic"]
[null,null,"List the Website address (URL) of project.",{"$nulls":6},"Democratic People's Republic of Korea"]
[null,null,null,"http://www.adaptation-fund.org/project/1331-reduction-risks-and-vulnerability-based-flooding-and-droughts-estero-real-river-watersh",{"$nulls":5},"Democratic Republic of the Congo"]
[{"$nulls":9},"Denmark"]
[null,null,"Project contacts:  ",{"$nulls":6},"Djibouti"]
[null,"National Project Manager/Coordinator",{"$nulls":7},"Dominica"]
[null,null,"Name: ","Karla Vanessa Rodriguez Gutierrez",{"$nulls":5},"Dominican Republic"]
[null,null,"Email: ","karlavanessa2005@gmail.com",{"$nulls":5},"Ecuador"]
[null,null,"Date: ","2013-07-11",{"$nulls":5},"Egypt"]
[null,null,"Government DA",{"$nulls":6},"El Salvador"]
[null,null,"Name: ","Denis Fuentes",{"$nulls":5},"Equatoral Guinea"]
[null,null,"Email: ","dfuentes@marena.gob.ni",{"$nulls":5},"Eritrea"]
[null,null,"Date: ","2013-07-11",{"$nulls":5},"Estonia"]
[null,null,"Implementing Entity",{"$nulls":6},"Ethiopia"]
[null,null,"Name: ","Maria Fernanda Sanchez",{"$nulls":5},"Fiji"]
[null,null,"Email: ","fernanda.sanchez@undp.org",{"$nulls":5},"Finland"]
[null,null,"Date: ","2013-07-11",{"$nulls":5},"France"]
[null,null,"Executing Agency",{"$nulls":6},"Gambia"]
[null,null,"Name: ","Ana Marcia Zeledón",{"$nulls":5},"Georgia"]
[null,null,"Email: ","mzeledon@marena.gob.ni",{"$nulls":5},"Germany"]
[null,null,"Date: ","2013-07-11",{"$nulls":5},"Ghana"]
[null,null,"Executing Agency",{"$nulls":6},"Greece"]
[null,null,"Name: ",{"$nulls":6},"Grenada"]
[null,null,"Email: ",{"$nulls":6},"Guatemala"]
[null,null,"Date: ",{"$nulls":6},"Guinea"]
[null,null,"Executing Agency",{"$nulls":6},"Guinea Bissau"]
[null,null,"Name: ",{"$nulls":6},"Guyana"]
[null,null,"Email: ",{"$nulls":6},"Haiti"]
[null,null,"Date: ",{"$nulls":6},"Honduras"]
[{"$nulls":9},"Hungary"]
[{"$nulls":9},"Iceland"]
[{"$nulls":9},"India"]
[{"$nulls":9},"Indonesia"]
[{"$nulls":9},"Iran (Islamic Republic of)"]
[{"$nulls":9},"Iraq"]
[{"$nulls":9},"Ireland"]
[{"$nulls":9},"Israel"]
[{"$nulls":9},"Italy"]
[{"$nulls":9},"Jamaica"]
[{"$nulls":9},"Japan"]
[{"$nulls":9},"Jordan"]
[{"$nulls":9},"Kazakhstan"]
[{"$nulls":9},"Kenya"]
[{"$nulls":9},"Kiribati"]
[{"$nulls":9},"Kuwait"]
[{"$nulls":9},"Kyrgyzstan"]
[{"$nulls":9},"Lao People’s Democratic Republic"]
[{"$nulls":9},"Latvia"]
[{"$nulls":9},"Lebanon"]
[{"$nulls":9},"Lesotho"]
[{"$nulls":9},"Liberia"]
[{"$nulls":9},"Libyan Arab Jamahiriya"]
[{"$nulls":9},"Liechtenstein"]
[{"$nulls":9},"Lithuania"]
[{"$nulls":9},"Luxembourg"]
[{"$nulls":9},"Madagascar"]
[{"$nulls":9},"Malawi"]
[{"$nulls":9},"Malaysia"]
[{"$nulls":9},"Maldives"]
[{"$nulls":9},"Mali"]
[{"$nulls":9},"Malta"]
[{"$nulls":9},"Marshall Islands"]
[{"$nulls":9},"Mauritania"]
[{"$nulls":9},"Mauritius"]
[{"$nulls":9},"Mexico"]
[{"$nulls":9},"Micronesia, Federated States of"]
[{"$nulls":9},"Monaco"]
[{"$nulls":9},"Mongolia"]
[{"$nulls":9},"Montenegro"]
[{"$nulls":9},"Morocco"]
[{"$nulls":9},"Mozambique"]
[{"$nulls":9},"Myanmar"]
[{"$nulls":9},"Namibia"]
[{"$nulls":9},"Nauru"]
[{"$nulls":9},"Nepal"]
[{"$nulls":9},"Netherlands"]
[{"$nulls":9},"New Zealand"]
[{"$nulls":9},"Nicaragua"]
[{"$nulls":9},"Niger"]
[{"$nulls":9},"Nigeria"]
[{"$nulls":9},"Norway"]
[{"$nulls":9},"Oman"]
[{"$nulls":9},"Pakistan"]
[{"$nulls":9},"Palau"]
[{"$nulls":9},"Panama"]
[{"$nulls":9},"Papua New Guinea"]
[{"$nulls":9},"Paraguay"]
[{"$nulls":9},"Peru"]
[{"$nulls":9},"Philippines"]
[{"$nulls":9},"Poland"]
[{"$nulls":9},"Portugal"]
[{"$nulls":9},"Qatar"]
[{"$nulls":9},"Republic of Korea"]
[{"$nulls":9},"Republic of Moldova"]
[{"$nulls":9},"Romania"]
[{"$nulls":9},"Russian Federation"]
[{"$nulls":9},"Rwanda"]
[{"$nulls":9},"Saint Kitts and Nevis"]
[{"$nulls":9},"Saint Lucia"]
[{"$nulls":9},"Saint Vincent and the Grenadines"]
[{"$nulls":9},"Samoa"]
[{"$nulls":9},"San Marino"]
[{"$nulls":9},"Sao Tome and Principe"]
[{"$nulls":9},"Saudi Arabia"]
[{"$nulls":9},"Senegal"]
[{"$nulls":9},"Serbia"]
[{"$nulls":9},"Seychelles"]
[{"$nulls":9},"Sierra Leone"]
[{"$nulls":9},"Singapore"]
[{"$nulls":9},"Slovakia"]
[{"$nulls":9},"Slovenia"]
[{"$nulls":9},"Solomon Islands"]
[{"$nulls":9},"Somalia"]
[{"$nulls":9},"South Africa"]
[{"$nulls":9},"Spain"]
[{"$nulls":9},"Sri Lanka"]
[{"$nulls":9},"Sudan"]
[{"$nulls":9},"Suriname"]
[{"$nulls":9},"Swaziland"]
[{"$nulls":9},"Sweden"]
[{"$nulls":9},"Switzerland"]
[{"$nulls":9},"Syrian Arab Republic"]
[{"$nulls":9},"Tajikistan"]
[{"$nulls":9},"Thailand"]
[{"$nulls":9},"The former Yugoslav Republic of Macedonia"]
[{"$nulls":9},"Timor-Leste"]
[{"$nulls":9},"Togo"]
[{"$nulls":9},"Tonga"]
[{"$nulls":9},"Trinidad and Tobago"]
[{"$nulls":9},"Tunisia"]
[{"$nulls":9},"Turkey"]
[{"$nulls":9},"Turkmenistan"]
[{"$nulls":9},"Tuvalu"]
[{"$nulls":9},"Uganda"]
[{"$nulls":9},"Ukraine"]
[{"$nulls":9},"United Arab Emirates"]
[{"$nulls":9},"United Kingdom of Great Britain and Northern Ireland"]
[{"$nulls":9},"United Republic of Tanzania"]
[{"$nulls":9},"United States of America"]
[{"$nulls":9},"Uruguay"]
[{"$nulls":9},"Uzbekistan"]
[{"$nulls":9},"Vanuatu"]
[{"$nulls":9},"Venezuela, Bolivarian Republic of"]
[{"$nulls":9},"Viet Nam"]
[{"$nulls":9},"Yemen"]
[{"$nulls":9},"Zambia"]
[{"$nulls":9},"Zimbabwe"]

{"sheet":"FinancialData","index":1,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[[42,4,44,4],[45,4,45,5],[50,4,50,5],[54,4,54,5],[20,4,20,5],[21,4,24,4],[25,4,25,5],[26,4,28,4],[29,4,29,5],[38,4,40,4],[46,4,49,4],[51,4,53,4],[41,4,41,5],[2,2,2,6],[62,4,62,6],[4,2,4,6],[3,1,3,6],[12,2,12,3],[6,2,6,3],[8,4,8,6],[9,4,9,6],[7,2,7,6],[11,2,11,3],[64,2,64,6],[8,2,8,3],[9,2,9,3],[36,2,36,3],[37,2,37,3],[62,2,62,3],[61,2,61,3],[13,4,15,4],[17,4,19,4],[16,4,16,5],[76,2,76,3],[75,4,75,6],[76,4,76,6],[72,4,72,6],[71,4,71,6],[71,2,71,3],[72,2,72,3],[65,2,65,3],[66,4,66,6],[65,4,65,6],[75,2,75,3],[74,2,74,3],[68,2,68,3],[69,2,69,3],[69,4,69,6],[66,2,66,3]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Financial information:  cumulative from project start to June 2013"]
[]
[]
[]
[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 JUNE, 2013",null,2142346]
[null,null,"Add any comments on AF Grant Funds. (word limit=200)"]
[]
[null,null,"EXPENDITURE DATA"]
[null,null,"List item / activity / action and corresponding amount spent for the current reporting period",null,"ITEM / ACTIVITY / ACTION/OUTCOME","OUTPUT","AMOUNT"]
[{"$nulls":4},"1. Investments in infrastructure for storing and using rain and surface water in eight micro-watersheds in the upper watershed of the Estero Real River.","1.1 Two communal irrigation systmes supply famliy farms in two micro-watersheds.",357504.33]
[{"$nulls":5},"1.2 At least 880 rainwater collection and storage facilities supply familiy farms in eight micro-watersheds.",415818.72]
[{"$nulls":5},"1.3 At least 1000 farm families organized and trained in management, efficient use and maintenance of their communal and inidvidual irrigation systems and water storage facilities.",29937.21]
[{"$nulls":4},"Total Outcome 1",null,803260.66]
[{"$nulls":4},"2. Introduction of climate resilient agro-ecological practices to make effective use of available water.","2.1 At least 1000 farm families with agro-ecological farme transformation plans and using their own resources and available credito for their ongoing implementation.",97575.32]
[{"$nulls":5},"2.2 At least 140 hectares converted to water-conscious and climate resilient agro-ecological production in each micro-watershed.",458466.65]
[{"$nulls":5},"2.3 At least 50 protected hectares in water system recharge areas and riparian zones in each micro-watershed.",27777.57]
[{"$nulls":4},"Total Outcome 2",null,583819.54]
[{"$nulls":4},"3. Institutional development and capacity building in micro-watersheds, municipalities, and participating national institutions","3.1 Local organiztions in eight micro-watersheds prepare and implement climate resilient management plans to increase water retention, soil conservation and food security.",12571.76]
[{"$nulls":5},"3.2 inter-institutional coordinating bodies in El Sauce, Achuaga and Villanueva coordinate governmental and non-governmental agency work plans in the micro-watershed in the Villanueva River basin.",859.59]
[{"$nulls":5},"3.3 Validated proposal for normative instrumentos to build climate change resilience and for the operation of a Villanueva River sub-watershed committee"]
[{"$nulls":5},"3.4 Nice municipalities in the Estero Real River basin incorporate climate change adaptation measures in their land use, investment and water use plans and related normative instruments."]
[{"$nulls":4},"Total Outcome 3",null,13431.35]
[{"$nulls":4},"4. Ongoing monitoring and analysis of climatic conditions and changes in land use, water flows and soil quality","4.1 A hydrological study of the lower part of the Villanueva River basin, identifying the hydraulic works needed to redulce the flooding caused by sediments from the upper watershed.",37113.55]
[{"$nulls":5},"4.2 Ongoing participatory monitoring of water flows and quality, soil conditions, and land use changes.",9038.86]
[{"$nulls":5},"4.3 Electronic information posts in each targeted micro-watershed present relevant national and global climate information, digitalize local monitoring data, and preprae maps of land use, waer flow and soil quality changes for farm families, local organizations and users of the National Environmental Information System (SINIA).",77721.51]
[{"$nulls":4},"Total Outcome 4",null,123873.92]
[{"$nulls":4},"Project Execution",null,214306.64]
[]
[]
[]
[{"$nulls":4},"TOTAL",null,2489754.1300000004]
[]
[null,null,"PLANNED DISBURSEMENT SCHEDULE"]
[null,null,"List item / activity / action planned and corresponding projected cost for the upcoming reporting period",null,"ITEM / ACTIVITY / ACTION/ OUTCOME","OUTPUT","PROJECTED COST Julio ","Est. Completion Date"]
[{"$nulls":4},"1. Investments in infrastructure for storing and using rain and surface water in eight micro-watersheds in the upper watershed of the Estero Real River.","1.1 Two communal irrigation systmes supply famliy farms in two micro-watersheds.",32450.37]
[{"$nulls":5},"1.2 At least 880 rainwater collection and storage facilities supply familiy farms in eight micro-watersheds.",762494.03]
[{"$nulls":5},"1.3 At least 1000 farm families organized and trained in management, efficient use and maintenance of their communal and inidvidual irrigation systems and water storage facilities.",18904.15]
[{"$nulls":4},"Total Outcome 1",null,813848.55,"2014-06-01"]
[{"$nulls":4},"2. Introduction of climate resilient agro-ecological practices to make effective use of available water.","2.1 At least 1000 farm families with agro-ecological farme transformation plans and using their own resources and available credito for their ongoing implementation.",177365.83]
[{"$nulls":5},"2.2 At least 140 hectares converted to water-conscious and climate resilient agro-ecological production in each micro-watershed.",252841.49]
[{"$nulls":5},"2.3 At least 50 protected hectares in water system recharge areas and riparian zones in each micro-watershed.",132040.01]
[{"$nulls":4},"Total Outcome 2",null,562247.33,"2014-06-01"]
[{"$nulls":4},"3. Institutional development and capacity building in micro-watersheds, municipalities, and participating national institutions","3.1 Local organiztions in eight micro-watersheds prepare and implement climate resilient management plans to increase water retention, soil conservation and food security.",50260.9]
[{"$nulls":5},"3.2 inter-institutional coordinating bodies in El Sauce, Achuaga and Villanueva coordinate governmental and non-governmental agency work plans in the micro-watershed in the Villanueva River basin.",16367.61]
[{"$nulls":5},"3.3 Validated proposal for normative instrumentos to build climate change resilience and for the operation of a Villanueva River sub-watershed committee"]
[{"$nulls":5},"3.4 Nice municipalities in the Estero Real River basin incorporate climate change adaptation measures in their land use, investment and water use plans and related normative instruments."]
[{"$nulls":4},"Total Outcome 3",null,66628.51000000001,"2014-06-01"]
[{"$nulls":4},"4. Ongoing monitoring and analysis of climatic conditions and changes in land use, water flows and soil quality","4.1 A hydrological study of the lower part of the Villanueva River basin, identifying the hydraulic works needed to redulce the flooding caused by sediments from the upper watershed.",62513.99,"2014-06-01"]
[{"$nulls":5},"4.2 Ongoing participatory monitoring of water flows and quality, soil conditions, and land use changes.",55594.54]
[{"$nulls":5},"4.3 Electronic information posts in each targeted micro-watershed present relevant national and global climate information, digitalize local monitoring data, and preprae maps of land use, waer flow and soil quality changes for farm families, local organizations and users of the National Environmental Information System (SINIA).",191789.67]
[{"$nulls":4},"Total Outcome 4",null,309898.2,"2014-06-01"]
[{"$nulls":4},"Project Execution",null,110000,"2014-06-01"]
[]
[]
[]
[{"$nulls":4},"TOTAL",null,2820300.7800000003]
[]
[null,null,"ACTUAL CO-FINANCING "]
[null,null,"How much of the total co-financing as committed in the Project Document has actually been realized?"]
[]
[null,null,"If the MTR or TE have not been undertaken this reporting period, DO NOT report on actual co-financing."]
[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":443,"n_cols":8,"rows_kept":443,"cut":false,"hidden":false,"merged":[[432,2,434,2],[432,5,434,5],[432,6,434,6],[432,7,434,7],[424,2,429,2],[424,5,429,5],[424,6,429,6],[424,7,429,7],[430,2,431,2],[430,7,431,7],[412,2,416,2],[412,5,416,5],[412,6,416,6],[412,7,416,7],[417,2,423,2],[417,7,423,7],[422,5,423,5],[422,6,423,6],[407,2,411,2],[407,7,411,7],[408,5,409,5],[408,6,409,6],[410,5,411,5],[410,6,411,6],[400,2,406,2],[400,5,401,5],[400,6,401,6],[400,7,406,7],[402,5,404,5],[402,6,404,6],[405,5,406,5],[405,6,406,6],[394,2,396,2],[394,5,396,5],[394,6,396,6],[394,7,396,7],[397,2,399,2],[397,5,399,5],[397,6,399,6],[397,7,399,7],[386,2,386,7],[387,2,389,2],[387,5,389,5],[387,6,389,6],[387,7,389,7],[390,2,393,2],[390,5,393,5],[390,6,393,6],[390,7,393,7],[380,2,380,7],[381,2,382,2],[381,5,382,5],[381,6,382,6],[381,7,382,7],[383,2,385,2],[383,5,385,5],[383,6,385,6],[383,7,385,7],[374,2,376,2],[374,5,376,5],[374,6,376,6],[374,7,376,7],[377,2,379,2],[377,5,379,5],[377,6,379,6],[377,7,379,7],[368,2,373,2],[368,5,370,5],[368,6,370,6],[368,7,370,7],[371,5,373,5],[371,6,373,6],[371,7,373,7],[362,2,364,2],[362,5,364,5],[362,6,364,6],[362,7,364,7],[365,2,367,2],[365,5,367,5],[365,6,367,6],[365,7,367,7],[353,2,358,2],[353,5,358,5],[353,6,358,6],[353,7,358,7],[359,2,361,2],[359,5,361,5],[359,6,361,6],[359,7,361,7],[344,2,347,2],[344,5,347,5],[344,6,347,6],[344,7,347,7],[348,2,352,2],[348,5,352,5],[348,6,352,6],[348,7,352,7],[335,7,338,7],[339,2,341,2],[339,5,341,5],[339,6,341,6],[339,7,341,7],[342,2,343,2],[342,5,343,5],[342,6,343,6],[342,7,343,7],[330,5,331,5],[330,6,331,6],[332,5,333,5],[332,6,333,6],[335,2,338,2],[335,5,338,5],[335,6,338,6],[323,2,325,2],[323,5,325,5],[323,6,325,6],[323,7,325,7],[326,2,334,2],[326,5,327,5],[326,6,327,6],[326,7,334,7],[328,5,329,5],[328,6,329,6],[315,2,322,2],[315,5,316,5],[315,6,316,6],[315,7,322,7],[317,5,319,5],[317,6,319,6],[307,2,314,2],[307,5,308,5],[307,6,308,6],[307,7,314,7],[309,5,311,5],[309,6,311,6],[296,7,297,7],[298,7,306,7],[301,5,302,5],[301,6,302,6],[304,5,305,5],[304,6,305,6],[291,2,293,2],[291,5,293,5],[291,6,293,6],[291,7,293,7],[294,2,306,2],[294,5,295,5],[294,6,295,6],[294,7,295,7],[296,5,297,5],[296,6,297,6],[285,2,287,2],[285,5,287,5],[285,6,287,6],[285,7,287,7],[288,2,290,2],[288,5,290,5],[288,6,290,6],[288,7,290,7],[279,2,281,2],[279,5,281,5],[279,6,281,6],[279,7,281,7],[282,2,284,2],[282,5,284,5],[282,6,284,6],[282,7,284,7],[273,2,275,2],[273,5,275,5],[273,6,275,6],[273,7,275,7],[276,2,278,2],[276,5,278,5],[276,6,278,6],[276,7,278,7],[266,2,266,7],[267,2,269,2],[267,5,269,5],[267,6,269,6],[267,7,269,7],[270,2,272,2],[270,5,272,5],[270,6,272,6],[270,7,272,7],[258,2,260,2],[258,5,260,5],[258,6,260,6],[258,7,260,7],[263,2,265,2],[263,5,265,5],[263,6,265,6],[263,7,265,7],[252,2,254,2],[252,5,254,5],[252,6,254,6],[252,7,254,7],[255,2,257,2],[255,5,257,5],[255,6,257,6],[255,7,257,7],[246,2,248,2],[246,5,248,5],[246,6,248,6],[246,7,248,7],[249,2,251,2],[249,5,251,5],[249,6,251,6],[249,7,251,7],[240,2,242,2],[240,5,242,5],[240,6,242,6],[240,7,242,7],[243,2,245,2],[243,5,245,5],[243,6,245,6],[243,7,245,7],[235,5,236,5],[235,6,236,6],[237,2,239,2],[237,5,239,5],[237,6,239,6],[237,7,239,7],[228,2,230,2],[228,5,230,5],[228,6,230,6],[228,7,230,7],[231,2,236,2],[231,5,232,5],[231,6,232,6],[231,7,236,7],[233,5,234,5],[233,6,234,6],[219,2,223,2],[219,5,223,5],[219,6,223,6],[219,7,223,7],[224,2,227,2],[224,5,225,5],[224,6,225,6],[224,7,227,7],[226,5,227,5],[226,6,227,6],[195,2,205,2],[195,5,196,5],[212,2,218,2],[212,5,213,5],[212,6,213,6],[212,7,218,7],[214,5,215,5],[214,6,215,6],[217,5,218,5],[217,6,218,6],[206,2,211,2],[206,5,207,5],[206,6,207,6],[206,7,211,7],[209,5,210,5],[209,6,210,6],[195,6,196,6],[195,7,205,7],[197,5,198,5],[197,6,198,6],[199,5,200,5],[199,6,200,6],[202,5,203,5],[202,6,203,6],[204,5,205,5],[204,6,205,6],[188,2,194,2],[188,5,189,5],[188,6,189,6],[188,7,194,7],[192,5,193,5],[192,6,193,6],[176,5,178,5],[176,6,178,6],[179,2,187,2],[179,5,180,5],[179,6,180,6],[179,7,187,7],[185,5,187,5],[185,6,187,6],[168,2,170,2],[168,5,170,5],[168,6,170,6],[168,7,170,7],[171,2,178,2],[171,5,172,5],[171,6,172,6],[171,7,178,7],[173,5,175,5],[173,6,175,6],[159,6,161,6],[159,7,161,7],[162,5,164,5],[162,6,164,6],[162,7,164,7],[165,2,167,2],[165,5,167,5],[165,6,167,6],[165,7,167,7],[150,6,152,6],[150,7,152,7],[153,5,155,5],[153,6,155,6],[153,7,155,7],[156,2,164,2],[156,5,158,5],[156,6,158,6],[156,7,158,7],[159,5,161,5],[143,2,143,7],[144,2,146,2],[144,5,146,5],[144,6,146,6],[144,7,146,7],[147,2,155,2],[147,5,149,5],[147,6,149,6],[147,7,149,7],[150,5,152,5],[119,3,121,3],[122,3,124,3],[126,3,131,3],[133,3,134,3],[140,2,140,3],[141,2,141,4],[76,3,84,3],[85,3,89,3],[90,3,94,3],[109,3,110,3],[111,3,111,6],[114,3,114,6],[28,3,32,3],[33,3,38,3],[39,3,42,3],[43,3,46,3],[51,3,52,3],[64,3,64,6],[48,3,49,3],[442,2,442,7],[19,3,21,3],[22,3,27,3],[2,2,2,5],[3,1,3,5],[6,2,6,3],[7,2,7,5],[9,3,9,6],[4,2,4,7],[5,2,5,5]],"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,"27 (below)"]
[null,null,"LIST OF CONTRACTS"]
[null,null,"List all contracts related to the project/program with signature dates"]
[null,null,null,"Contract Type","Agency / Contracted party","Signature Date","Amount"]
[null,null,null,"1. Investments in infrastructure for storing and using rain and surface water in eight micro-watersheds in the upper watershed of the Estero Real River."]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2012-11-26",185934.27]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-05-03",2785.65]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-05-03",2785.65]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-05-03",2785.65]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2012-09-04",12000]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-06-12",5532.76]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-05-03",1857.1]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-05-03",1857.1]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-05-03",1857.1]
[null,null,null,"Purchase of supplies for construction of 51 water catchment works in El Sauce",null,"2013-03-11",11613.001658374793]
[{"$nulls":5},"2013-03-11",15874.509565991182]
[{"$nulls":5},"2013-03-11",6205.153096307083]
[null,null,null,"Purchase of supplies for construction of 40 water catchment and storage works in El Cacao micro watershed, Achuapa",null,"2013-03-13",1956.6355215790966]
[{"$nulls":5},"2013-03-13",8281.761922096834]
[{"$nulls":5},"2013-03-13",4159.884722727825]
[{"$nulls":5},"2013-03-13",4043.1986409416336]
[{"$nulls":5},"2013-03-13",1855.1146705496906]
[{"$nulls":5},"2013-03-13",1213.4449702705983]
[null,null,null,"Purchase of supplies for construction of 24 water catchment and storage works in El Coyolar micro watershed, Achuapa",null,"2013-03-13",2782.6558265582657]
[{"$nulls":5},"2013-03-13",21181.136997937145]
[{"$nulls":5},"2013-03-13",1076.5222667152045]
[{"$nulls":5},"2013-03-13",1212.9595922824901]
[{"$nulls":5},"2013-03-13",291.2267928649436]
[null,null,null,"Purchase of supplies for construction of 60 water catchment and storage works in El Coyolar micro watershed, Achuapa",null,"2013-03-13",1638.1507098653076]
[{"$nulls":5},"2013-03-13",2866.292521134167]
[{"$nulls":5},"2013-03-13",6239.827286332565]
[{"$nulls":5},"2013-03-13",12919.54859847106]
[{"$nulls":5},"2013-03-13",4548.5984710593375]
[{"$nulls":5},"2013-03-13",2937.2648950370103]
[null,null,null,"Purchase of supplies for construction of 50 water catchment and storage works in Villanueva",null,"2013-03-11",4628.836710755168]
[{"$nulls":5},"2013-03-11",8596.741900254823]
[{"$nulls":5},"2013-03-11",6650.487400396392]
[{"$nulls":5},"2013-03-11",1427.0112850382236]
[null,null,null,"Purchase of supplies for construction of 30 water catchment and storage works in Villanueva",null,"2013-03-11",3183.3118958055256]
[{"$nulls":5},"2013-03-11",7331.816527120495]
[{"$nulls":5},"2013-03-11",5252.194312987906]
[{"$nulls":5},"2013-03-11",1569.7124135420459]
[null,null,null,"1st purchase of supplies for the construction of 135 water catchment and storage in the micro watersheds of Achuapa, El Sauce and Villanueva.",null,"2012-10-11",104907.67]
[null,null,null,"3rd purchase of supplies for the construction of 162 water catchment and storage works in the micro watersheds of Achuapa, El Sauce and Villanueva.",null,"2012-10-15",2390.74]
[{"$nulls":5},"2012-10-15",24253.96]
[null,null,null,"2nd purchase of supplies for the construction of 162 water catchment and storage works in the micro watersheds of Achuapa, El Sauce and Villanueva.",null,"2012-10-15",63000.07]
[null,null,null,"4th purchase of supplies for the construction of 162 water catchment and storage works in the micro watersheds of Achuapa, El Sauce and Villanueva.",null,"2012-10-30",49245.61]
[{"$nulls":5},"2012-10-30",23067.98]
[null,null,null,"Supplies (plastic tanks and accessories) for pipes of water catchment systems (lagunetas).",null,"2012-11-08",6296.16]
[null,null,null,"Service of 210 hrs (Tractor) for construction of 17 small lakes (lagunetas) in Achuapa.",null,"2012-09-04",19086.85]
[null,null,null,"Service of 240 hours (tractor)for construction of 24 small lakes (lagunetas) in El Sauce and Villanueva.",null,"2012-09-28",25515.74]
[null,null,null,"Design for the construction of the comunal irrigation system of Salale, El Sauce.",null,"2012-06-08",3200]
[null,null,null,"Design and printing of manuals for the proper use and maintenance of irrigation systems and small works of capture and storage of water",null,"2012-11-28",5745.11]
[null,null,null,"Construction of water capture and storage works (mason) ",null,"2012-10-24",13752.39]
[null,null,null,"Construction of water capture and storage works (mason) ",null,"2012-10-24",17719.26]
[null,null,null,"Construction of water capture and storage works (mason) ",null,"2012-10-24",9165.43]
[null,null,null,"Construction of water capture and storage works (mason) ",null,"2012-10-24",19337.3]
[null,null,null,"Construction of water capture and storage works (mason) ",null,"2012-10-24",16629.14]
[null,null,null,"Construction of water capture and storage works (mason) ",null,"2012-11-21",13098.32]
[null,null,null,"2. Introduction of climate resilient agro-ecological practices to make effective use of available water."]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-07-15",8400]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-07-15",8400]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-07-15",8400]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-07-15",8400]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-07-15",8400]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-07-15",8400]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-07-15",8400]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-07-15",8400]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-07-15",8400]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-02-01",9600]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-06-01",27000]
[null,null,null,"Purchase of Seeds from basic grains, legumes, improved grasses and Californian worms ",null,"2013-07-22",3363.23]
[{"$nulls":5},"2013-07-22",9176.7]
[{"$nulls":5},"2013-07-22",529.96]
[{"$nulls":5},"2013-07-22",1834.49]
[{"$nulls":5},"2013-07-22",2282.92]
[{"$nulls":5},"2013-07-22",12460.15]
[{"$nulls":5},"2013-07-22",7506.11]
[{"$nulls":5},"2013-07-22",3595.6]
[{"$nulls":5},"2013-07-22",850.69]
[null,null,null,"1st purchase of native and grafted fruit trees, forest and forage and vegetative material",null,"2013-05-10",18019.657808518383]
[{"$nulls":5},"2013-05-10",4853.779881082393]
[{"$nulls":5},"2013-05-10",12134.449702705982]
[{"$nulls":5},"2013-05-10",6067.224851352991]
[{"$nulls":5},"2013-05-10",3438.0940824333616]
[null,null,null,"2nd purchase of native and grafted fruit trees, forest and forage and vegetative material",null,"2013-05-10",10399.223395219027]
[{"$nulls":5},"2013-05-10",4853.779881082393]
[{"$nulls":5},"2013-05-10",6067.224851352991]
[{"$nulls":5},"2013-05-10",6067.224851352991]
[{"$nulls":5},"2013-05-10",3438.0940824333616]
[null,null,null,"Purchase of 4,345 rolls of barbed wire and 92 QQ of staples for the protection of agroforestry, silvopastoral and forestry production systems, and patios. ",null,"2012-10-10",124123.41]
[null,null,null,"Purchase of basic grains and legumes seeds",null,"2012-08-07",10405.61]
[null,null,null,"Purchase of basic grains and legumes seeds",null,"2012-08-07",9796.12]
[null,null,null,"Purchase of basic grains and legumes seeds",null,"2012-08-07",5523.47]
[null,null,null,"Purchase of basic grains and legumes seeds",null,"2012-08-07",2293.97]
[null,null,null,"Purchase of barbed wire and staples.",null,"2012-08-21",21540.97]
[null,null,null,"Purchase of native and grafted fruit trees, forest and forage and vegetative material",null,"2012-08-16",10936.64]
[null,null,null,"Purchase of native and grafted fruit trees, forest and forage and vegetative material",null,"2012-08-22",14683.07]
[null,null,null,"Purchase of barbed wire and staples.",null,"2012-11-07",39317.93]
[null,null,null,"Supplies for the construction of 250 stoves",null,"2012-11-08",26325.83]
[null,null,null,"Supplies for the construction of 500 chicken coops.",null,"2012-11-08",84206.96]
[null,null,null,"Purchase of barbed wire and staples.",null,"2012-11-13",46701.69]
[null,null,null,"Supplies for the construction of 152 stoves.",null,"2012-11-13",16006.11]
[null,null,null,"Supplies for the construction of 150 chicken coops.",null,"2012-11-13",25262.09]
[null,null,null,"Service of advice for the self construction of 402 stoves.",null,"2012-11-21",1271.78]
[{"$nulls":5},"2012-11-21",1783.82]
[null,null,null,"4. Ongoing monitoring and analysis of climatic conditions and changes in land use, water flows and soil quality"]
[null,null,null,"Limit setting and management plan for prioritized Water Recharge and Riparian Areas.",null,"2012-06-08",30000]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-01-29",13200]
[null,null,null,"Project Execution"]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-06-24",10800]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-06-24",7200]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2013-05-15",15600]
[null,null,null,"Consultancy Contract (Individual Contract)",null,"2012-12-01",80000]
[null,null,null,"Purchase of 3 PCs and software licenses. ",null,"2013-08-08",242.5676495570926]
[{"$nulls":5},"2013-08-08",800.8736803785948]
[{"$nulls":5},"2013-08-08",2379.607652792946]
[null,null,null,"Office Supplies.",null,"2013-01-29",2540.6851919265464]
[{"$nulls":5},"2013-01-29",205.83424341706106]
[{"$nulls":5},"2013-01-29",353.75925251789835]
[null,null,null,"Purchase of 16 tires",null,"2013-01-29",3623.336164704931]
[null,null,null,"Purchase of printers and copiers supplies.",null,"2013-01-29",1223.0817457428307]
[{"$nulls":5},"2013-01-29",96.83290862759374]
[{"$nulls":5},"2013-01-29",571.7574727986085]
[{"$nulls":5},"2013-01-29",678.3290862759375]
[{"$nulls":5},"2013-01-29",444.12894875217415]
[{"$nulls":5},"2013-01-29",461.48444768029776]
[null,null,null,"Vehicles repairs.",null,"2013-02-11",27764.646280791167]
[null,null,null,"Purchase of 1 Pc and 2 laptops. ",null,"2012-07-25",1268.94]
[{"$nulls":5},"2012-07-25",2817.5]
[null,null,null,"Vehicles repairs.",null,"2012-11-27",7504.78]
[null,null,null,"Vehicles repairs.",null,"2012-12-14",5234.657039711191]
[]
[]
[]
[null,null,"BIDS"]
[null,null,"List all bids for each contact signed with date of open call and winning bid"]
[null,null,"CONTRACT","Submitted Bids   ","Amount","Winning Bid    ","Amount","Justification"]
[null,null,"1. Investments in infrastructure for storing and using rain and surface water in eight micro-watersheds in the upper watershed of the Estero Real River."]
[null,null,"Construction of the Irrigation System in the Salale community.",null,185934.27,null,185934.27,"After having obtained the total results of the technical-economic evaluations, the supplier is awarded the contract because his economic offer adjusts to the Budget for contracting this work."]
[{"$nulls":4},275989.2208638957]
[{"$nulls":4},567541.0297473513]
[null,null,"Hiring Warehouse Personnel Services for the Municipalities of El Sauce, Achuapa and Villanueva",null,2785.65,null,2785.65,"Awarded for meeting the requirements established in the terms of reference."]
[{"$nulls":4},2785.65]
[{"$nulls":4},2785.65]
[{"$nulls":4},2785.65,null,2785.65,"Awarded for meeting the requirements established in the terms of reference."]
[{"$nulls":4},2785.65]
[{"$nulls":4},2785.65]
[{"$nulls":4},2785.65,null,2785.65,"Awarded for meeting the requirements established in the terms of reference."]
[{"$nulls":4},2785.65]
[{"$nulls":4},2785.65]
[null,null,"Three security guards, one for each Municipality of El Sauce, Achuapa and Villanueva.",null,1857.1,null,1857.1,"Awarded for having met the requirements established in the Terms of Reference."]
[{"$nulls":4},1857.1]
[{"$nulls":4},1857.1]
[{"$nulls":4},1857.1,null,1857.1,"Awarded for having met the requirements established in the Terms of Reference."]
[{"$nulls":4},1857.1]
[{"$nulls":4},1857.1]
[{"$nulls":4},1857.1,null,1857.1,"Awarded for having met the requirements established in the Terms of Reference."]
[{"$nulls":4},1857.1]
[{"$nulls":4},1857.1]
[null,null,"Technical Assistance for Water Harvesting structures",null,12000,null,12000,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},12000]
[{"$nulls":4},12000]
[null,null,"Construction of complementary structures in Las Mercedes communal Irrigation System",null,5762.067346938776,null,5532.76,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},6083.481224489797]
[{"$nulls":4},5532.76]
[null,null,"Purchase of supplies for construction of 51 water catchment works in El Sauce",null,11613.001658374793,null,11613,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},29253.60918982324]
[{"$nulls":4},15874.509565991182,null,15874.51]
[{"$nulls":4},40279.78805161186]
[{"$nulls":4},14646.285240464345]
[{"$nulls":4},6205.153096307083,null,6205.15]
[{"$nulls":4},6441.977106338228]
[{"$nulls":4},6842.413946527526]
[null,null,"Purchase of supplies for construction of 40 water catchment and storage works in El Cacao micro watershed, Achuapa",null,6522.79254135825,null,1956.6355215790966,"Partial awarding, for the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},19382.113821138213]
[{"$nulls":4},8281.761922096834,null,8281.761922096834]
[{"$nulls":4},6501.719047041217,null,4159.884722727825]
[{"$nulls":4},4043.1986409416336,null,4043.1986409416336]
[{"$nulls":4},1855.1146705496906,null,1855.1146705496906]
[{"$nulls":4},4281.033855114671,null,1213.4449702705983]
[{"$nulls":4},15929.053917404846]
[{"$nulls":4},1213.44]
[null,null,"Purchase of supplies for the construction of 24 water catchment and storage works in micro watershed Varela, Achuapa",null,2782.6558265582657,null,2782.6558265582657,"Partial awarding, for the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},23953.322816810258]
[{"$nulls":4},23050.63948549933,null,21181.136997937145]
[{"$nulls":4},1425.7573919022773,null,1076.5222667152045]
[{"$nulls":4},1212.9595922824901,null,1212.9595922824901]
[{"$nulls":4},1310.5205678922462]
[{"$nulls":4},291.2267928649436,null,291.2267928649436]
[null,null,"Purchase of supplies for construction of 60 water catchment and storage works in El Coyolar micro watershed, Achuapa",null,1638.1507098653076,null,1638.1507098653076,"La adjudicacion se hizo parcial, tomando como criterio de selección el Precio unitario de cada item. For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},28943.050600655264]
[{"$nulls":4},9617.756744731627,null,2866.292521134167]
[{"$nulls":4},26745.394976337826]
[{"$nulls":4},9812.930469603203,null,6239.827286332565]
[{"$nulls":4},30915.6898434656]
[{"$nulls":4},12919.54859847106,null,12919.54859847106]
[{"$nulls":4},4548.5984710593375,null,4548.5984710593375]
[{"$nulls":4},4914.452129595923]
[{"$nulls":4},2937.2648950370103,null,2937.2648950370103]
[{"$nulls":4},2997.209076568378]
[null,null,"Purchase of supplies for construction of 50 water catchment and storage works in Villanueva",null,4628.836710755168,null,4628.836710755168,"La adjudicacion se hizo parcial, tomando como criterio de selección el Precio unitario de cada item. For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},14490.302956760912]
[{"$nulls":4},8596.741900254823,null,8596.741900254823]
[{"$nulls":4},6650.487400396392,null,6650.487400396392]
[{"$nulls":4},1569.7124135420459]
[{"$nulls":4},1427.0112850382236,null,1427.0112850382236]
[null,null,"Purchase of supplies for construction of 30 water catchment and storage works in Villanueva",null,3183.3118958055256,null,3183.3118958055256,"La adjudicacion se hizo parcial, tomando como criterio de selección el Precio unitario de cada item. For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},11638.546697407271]
[{"$nulls":4},3945.867410912915,null,7331.816527120495]
[{"$nulls":4},7331.816527120495]
[{"$nulls":4},5252.194312987906,null,5252.194312987906]
[{"$nulls":4},1641.062977793957,null,1569.7124135420459]
[{"$nulls":4},1569.7124135420459]
[null,null,"1st purchase of supplies for the construction of 135 water catchment and storage in the micro watersheds of Achuapa, El Sauce and Villanueva.",null,148835.940114674,null,104907.67,"Se realizo adjudicacion parcializada de estos materiales por menor precio unitario y calidad, adjudicandose unicamente cierta cantidad d emateriales debido a que las ofertas excedian el monto presupuestado."]
[{"$nulls":4},57189.79273731152]
[{"$nulls":4},174760.30707156507]
[{"$nulls":4},211302.58526226375]
[{"$nulls":4},97766.2752176683]
[null,null,"3rd purchase of supplies for the construction of 162 water catchment and storage works in the micro watersheds of Achuapa, El Sauce and Villanueva.",null,57360.46166914419,null,2390.74,"La adjudicacion se hizo parcial, tomando como criterio de selección el Precio unitario de cada item. For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},12383.815672117222]
[{"$nulls":4},2390.235294117647,null,24253.96]
[{"$nulls":4},26986.261626672327]
[null,null,"2nd purchase of supplies for the construction of 162 water catchment and storage works in the micro watersheds of Achuapa, El Sauce and Villanueva.",null,89572.5207050329,null,63000.07,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},29433.23465703971]
[{"$nulls":4},64216.08876619239]
[null,null,"4th purchase of supplies for the construction of 162 water catchment and storage works in the micro watersheds of Achuapa, El Sauce and Villanueva.",null,111556.2650244213,null,2477.439371416436,"Adjudicacion parcial debido a que los oferentes cumplen con las especificaciones tecnicas solicitadas, presentan oferta economicamente mas favorables tomando como referencia precios unitarios, asi mismo todos incluyen el transporte de los materiales."]
[{"$nulls":4},85254.65703971118]
[{"$nulls":4},8710.195795285623,null,49245.60968358462]
[{"$nulls":4},2355.9333191760456]
[{"$nulls":4},85297.55914206838,null,23067.976640475685]
[{"$nulls":4},20356.742408154598]
[null,null,"Supplies (plastic tanks and accessories) for pipes of water catchment systems (lagunetas).",null,2090.0403482692714,null,6296.156721172223,"Presento oferta completa con todos los items solicitados, cumple con las especificaciones tecnicas solicitadas y oferta economicamente mas favorable."]
[{"$nulls":4},11897.226587385856]
[{"$nulls":4},6407.5931195582925]
[null,null,"Service of 210 hrs (Tractor) for construction of 17 small lakes (lagunetas) in Achuapa.",null,25200,null,19086.854958589935,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},25200]
[{"$nulls":4},19086.854958589935]
[null,null,"Service of 240 hours (tractor)for construction of 24 small lakes (lagunetas) in El Sauce and Villanueva.",null,30375.875982161815,null,25515.735825015927,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},29160.840942875344]
[{"$nulls":4},25515.735825015927]
[null,null,"Design for the construction of the comunal irrigation system of Salale, El Sauce.",null,17500,null,3200,"Por cumplir con la formacion academica, experiencia laboral y el plan de trabajo propuesto de acuerdo a los terminos de referencia para llevar a cabo la consultoria. For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},5500]
[{"$nulls":4},3200]
[null,null,"Design and printing of manuals for the proper use and maintenance of irrigation systems and small works of capture and storage of water",null,6455.723083457209,null,5745.11,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},6031.004459545551]
[{"$nulls":4},5861.12]
[null,null,"Construction of water capture and storage works (mason) ",null,14121.894245062645,null,13752.389042259501,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},14066.68082395413]
[{"$nulls":4},13752.389042259501]
[null,null,"Construction of water capture and storage works (mason) ",null,20743.257591845402,null,17719.260989594393,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},18449.777022722446]
[{"$nulls":4},17719.260989594393]
[null,null,"Construction of water capture and storage works (mason) ",null,9437.247823317051,null,9165.42790401359,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},9692.078997664046]
[{"$nulls":4},9165.42790401359]
[null,null,"Construction of water capture and storage works (mason) ",null,19337.3,null,19337.3,"For the best economic offer and for meeting the technical specifications."]
[null,null,"Construction of water capture and storage works (mason) ",null,16629.14,null,16629.14,"For the best economic offer and for meeting the technical specifications."]
[null,null,"Construction of water capture and storage works (mason) ",null,13098.322361435548,null,13098.322361435548,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},14890.634954342748]
[{"$nulls":4},16527.92524952219]
[null,null,"2. Introduction of climate resilient agro-ecological practices to make effective use of available water."]
[null,null,"Consultancy Contract (Individual Contract)",null,8400,null,8400,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},8400]
[{"$nulls":4},8400]
[null,null,"Consultancy Contract (Individual Contract)",null,8400,null,8400,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},8400,null,8400]
[{"$nulls":4},8400,null,8400]
[null,null,"Consultancy Contract (Individual Contract)",null,8400,null,8400,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},8400,null,8400]
[{"$nulls":4},8400,null,8400]
[null,null,"Consultancy Contract (Individual Contract)",null,8400,null,8400,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},8400,null,8400]
[{"$nulls":4},8400,null,8400]
[null,null,"Consultancy Contract (Individual Contract)",null,8400,null,8400,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},8400,null,8400]
[{"$nulls":4},8400,null,8400]
[null,null,"Consultancy Contract (Individual Contract)",null,8400,null,8400,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},8400,null,8400]
[{"$nulls":4},8400,null,8400]
[null,null,"Consultancy Contract (Individual Contract)",null,8400,null,8400,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},8400,null,8400]
[{"$nulls":4},8400,null,8400]
[null,null,"Consultancy Contract (Individual Contract)",null,8400,null,8400,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},8400]
[{"$nulls":4},8400]
[null,null,"Consultancy Contract (Individual Contract)",null,8400,null,8400,"Awarded for having achieved the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},8400]
[{"$nulls":4},8400]
[null,null,"Purchase of Seeds from basic grains, legumes, improved grasses and Californian worms ",null,3363.228699551569,null,3363.228699551569,"Awarded to , at the moment of notification to , the product was not available."]
[{"$nulls":4},2839.9870565869837]
[{"$nulls":4},9176.697920913168,null,9176.697920913168,"Awarded to , at the moment of notification to , the product was not available."]
[{"$nulls":4},7447.518505035797]
[{"$nulls":4},529.9633102323685,null,529.9633102323685,"The award was partially made, taking in consideration the unit price of each item. In the same line, it was evaluated the availability and immediate delivery of seeds, given the times required and programming for the dry season."]
[{"$nulls":4},1834.4883815735832,null,1834.4883815735832]
[{"$nulls":4},2282.918874847126,null,2282.918874847126]
[{"$nulls":4},19576.912187032318,null,12460.150835711373]
[{"$nulls":4},12460.150835711373]
[{"$nulls":4},7506.114961271912,null,7506.114961271912]
[{"$nulls":4},4965.012336690531,null,3595.5972278842232]
[{"$nulls":4},3595.5972278842232]
[{"$nulls":4},850.69302894415,null,850.69302894415]
[null,null,"1st purchase of native and grafted fruit trees, forest and forage and vegetative material",null,18019.657808518383,null,18019.657808518383,"The award was partially made, taking in consideration the unit price of each item. In the same line, it was evaluated the availability and immediate delivery of seeds, given the times required and programming for the dry season."]
[{"$nulls":4},7511.224365975003]
[{"$nulls":4},4853.779881082393,null,4853.779881082393]
[{"$nulls":4},13170.933948145452]
[{"$nulls":4},28770.780245115886]
[{"$nulls":4},12134.449702705982,null,12134.449702705982]
[{"$nulls":4},6067.224851352991,null,6067.224851352991]
[{"$nulls":4},3438.0940824333616,null,3438.0940824333616]
[null,null,"2nd purchase of native and grafted fruit trees, forest and forage and vegetative material",null,10399.223395219027,null,10399.223395219027,"The award was partially made, taking in consideration the unit price of each item. In the same line, it was evaluated the availability and immediate delivery of seeds, given the times required and programming for the dry season."]
[{"$nulls":4},6241.151963758444]
[{"$nulls":4},4853.779881082393,null,4853.779881082393]
[{"$nulls":4},9327.347004813331]
[{"$nulls":4},19928.811228410792]
[{"$nulls":4},6067.224851352991,null,6067.224851352991]
[{"$nulls":4},6067.224851352991,null,6067.224851352991]
[{"$nulls":4},3438.0940824333616,null,3438.0940824333616]
[null,null,"Purchase of 4,345 rolls of barbed wire and 92 QQ of staples for the protection of agroforestry, silvopastoral and forestry production systems, and patios. ",null,227663.99023147166,null,124123.40879167551,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},152103.67763856443]
[{"$nulls":4},124123.40879167551]
[null,null,"Purchase of basic grains and legumes seeds",null,10405.606285835633,null,10405.606285835633,"Awarded according to economic evaluation, taking as reference unit prices, offered amounts and immediate availability, as well as meeting technical specifications."]
[{"$nulls":4},12656.614992567424]
[{"$nulls":4},12840,null,9796.118071777448]
[{"$nulls":4},14311]
[{"$nulls":4},21131.87513272457,null,5523.465703971119]
[{"$nulls":4},11679.762157570609]
[{"$nulls":4},267.57273306434485,null,191.12338076024633]
[{"$nulls":4},800]
[{"$nulls":4},2293.480569122956,null,2293.480569122956]
[null,null,"Purchase of barbed wire and staples.",null,22091.584200467187,null,21540.970482055636,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},25626.287534508385]
[{"$nulls":4},22495.640263325546]
[{"$nulls":4},21540.970482055636]
[null,null,"Purchase of native and grafted fruit trees, forest and forage and vegetative material",null,15319.28562327458,null,10936.640475684859,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},20716.915693353152]
[{"$nulls":4},10936.640475684859]
[null,null,"Purchase of native and grafted fruit trees, forest and forage and vegetative material",null,25660.86982374177,null,14683.07411339987,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},14683.07411339987]
[null,null,"Purchase of barbed wire and staples.",null,62978.60904650669,null,39317.92524952219,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},73220.42896581015]
[{"$nulls":4},45704.11000212359]
[{"$nulls":4},39202.7993204502]
[null,null,"Supplies for the construction of 250 stoves",null,49515.204926736034,null,26325.832660862176,"Delivered best economic offer, with every requested item.  Meets technical specifications and more favorable economic offer."]
[{"$nulls":4},22243.915905712463]
[{"$nulls":4},25444.89275854746]
[{"$nulls":4},926089.25]
[{"$nulls":4},26791.77659800382]
[null,null,"Supplies for the construction of 500 chicken coops.",null,16014.525376937778,null,84206.96156296453,"Delivered best economic offer, with every requested item.  Meets technical specifications and more favorable economic offer."]
[{"$nulls":4},86368.0870673179]
[{"$nulls":4},100318.32660862178]
[{"$nulls":4},118235.74007220216]
[{"$nulls":4},128523.47759609258]
[{"$nulls":4},85697.35060522404]
[null,null,"Purchase of barbed wire and staples.",null,65410.4208961563,null,46701.68613293692,"Delivered best economic offer, with every requested item.  Meets technical specifications and more favorable economic offer."]
[{"$nulls":4},48469.31832660862]
[{"$nulls":4},46397.47887024845]
[null,null,"Supplies for the construction of 152 stoves",null,26178.473561265662,null,16006.106179655977,"Delivered best economic offer, with every requested item.  Meets technical specifications and more favorable economic offer."]
[{"$nulls":4},5067.742620513909]
[{"$nulls":4},14164.695689105967]
[null,null,"Supplies for the construction of 150 chicken coops.",null,28716.6128689743,null,25262.088341473773,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},23932.747504778083]
[{"$nulls":4},22355.83053726906]
[null,null,"Service of advice for the self construction of 402 stoves.",null,1271.7774474410703,null,1271.7774474410703,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},1530.0063707793586]
[{"$nulls":4},1936.7169250371628]
[{"$nulls":4},1783.8182204289658,null,1783.8182204289658,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},1911.2338076024632]
[{"$nulls":4},2123.5931195582925]
[null,null,"Technical Assistance to formulate, make official and follow-up on collaboration agreements in the framework of Program Components 1, 3 and 4.",null,9600,null,9600,"Awarded for having obtained the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},9600]
[{"$nulls":4},9600]
[null,null,"Specialist in Adaptative, forest, agroforestry and silvopastoral systems.",null,27000,null,27000,"Meets the academic background and the requirement profile of the Terms of Reference."]
[{"$nulls":4},27000]
[{"$nulls":4},27000]
[null,null,"4. Ongoing monitoring and analysis of climatic conditions and changes in land use, water flows and soil quality"]
[null,null,"Limit setting and management plan for prioritized Water Recharge and Riparian Areas.",null,30000,null,30000,"A total of 5 offers were received.  Just 2 were evaluated for their economic offer since obtained best results from technical evaluation."]
[{"$nulls":4},29524]
[null,null,"Technical assistance to formulate, make official and follow-up on collaboration agreements in the framework of program component 2.",null,13200,null,13200,"Awarded for having obtained the highest score, meeting all the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},13200]
[{"$nulls":4},13200]
[null,null,"Project Execution"]
[null,null,"Support to the procurement processes",null,10800,null,10800,"Awarded for having obtained the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},10800]
[{"$nulls":4},10800]
[null,null,"Support to the Financial Administrative process",null,7200,null,7200,"Awarded for having obtained the highest score, meeting the requirements established in the terms of reference for the consultancy."]
[{"$nulls":4},7200]
[{"$nulls":4},7200]
[{"$nulls":4},7200]
[null,null,"Financial Accounting specialist",null,15600,null,15600,"Complies with the academic background and requirement profile in the Terms of Reference."]
[{"$nulls":4},15600]
[{"$nulls":4},15600]
[null,null,"Technical coordinator Estero Real Project",null,80000,null,80000,"Complies with the academic background and requirement profile in the Terms of Reference."]
[{"$nulls":4},80000]
[{"$nulls":4},80000]
[null,null,"Purchase of 3 PCs and software licenses. ",null,3169.5991586781543,null,242.5676495570926,"Partially awarded. For the best economic offer and for meeting the technical specifications.  The amount highlighted in yellow represents the actual total paid to the bidder since the process was partially awarded."]
[{"$nulls":4},4409.646887513652]
[{"$nulls":4},3781.094527363184,null,800.8736803785948]
[{"$nulls":4},1850.6366541277355]
[{"$nulls":4},1670.7814585608544]
[{"$nulls":4},4204.395906645634,null,2379.607652792946]
[{"$nulls":4},3487.1374833151317]
[null,null,"Office Supplies.",null,3138.1709339481454,null,2540.6851919265464,"For the best economic offer and for meeting the technical specifications. The amount highlighted in yellow represents the actual total paid to the bidder since the process was partially awarded."]
[{"$nulls":4},1463.9809084658011,null,205.83424341706106]
[{"$nulls":4},992.6449055535331]
[{"$nulls":4},1615.7586053472476,null,353.75925251789835]
[{"$nulls":4},3397.686364923351]
[null,null,"Purchase of 16 tires",null,3972.3698580269383,null,3623.336164704931,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},2114.3429195485987]
[{"$nulls":4},2507.0096671115966]
[{"$nulls":4},2783.614852566436]
[{"$nulls":4},3623.336164704931]
[null,null,"Purchase of printers and copiers supplies.",null,1732.7860696517414,null,1223.0817457428307,"For the best economic offer and for meeting the technical specifications.  The amount highlighted in yellow represents the actual total paid to the bidder since the process was partially awarded."]
[{"$nulls":4},97.68232010678317,null,96.83290862759374]
[{"$nulls":4},1768.2943008534564,null,571.7574727986085]
[{"$nulls":4},4284.337256805404,null,678.3290862759375]
[{"$nulls":4},1518.2174493386726,null,444.12894875217415]
[{"$nulls":4},2396.273510496299,null,461.48444768029776]
[{"$nulls":4},4570.6734619585]
[null,null,"Vehicles repairs.",null,40066.49678437083,null,27764.646280791167,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},32307.830764874816]
[{"$nulls":4},19266.20960239453]
[{"$nulls":4},18762.749666302636]
[{"$nulls":4},17800.40043684019]
[{"$nulls":4},27764.65]
[null,null,"Purchase of 1 Pc and 2 laptops. ",null,1268.94,null,1268.94,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},2817.5,null,2817.5]
[null,null,"Vehicles repairs.",null,8129.539180293055,null,7504.7780845190055,"For the best economic offer and for meeting the technical specifications."]
[{"$nulls":4},8163.091951582076]
[{"$nulls":4},7504.7780845190055]
[null,null,"Vehicles repairs.",null,5234.657039711191,null,5234.657039711191,"ONLY OFFER"]
[]
[]
[]
[]
[]
[]
[null,null,"*In January 2014 MARENA has formally requested the Steering Committee the no-objection to acquire two new trucks (total estimate USD$60,000). Project had budgeted the acquisition of one truck at the beginning of the project and has used two addition trucks from another GEF project. However, these two had reached their lifespan incurring in high maintenance/repair costs. As stated in a formal letter from MARENA, the new trucks will assure monitoring of community works 2 times a week as well as to transport beneficiaries to showcase their success stories to other departments and fairs.  UNDP is working with MARENA to carry out a due diligence and cost-benefit analysis to verify that the procurement of these trucks is an essential part of achieving the project outcomes. All this information will be provided to the Steering Committee to make a final decision. "]

{"sheet":"Risk Assesment","index":3,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[54,2,54,3],[54,4,54,5],[17,4,17,5],[28,2,28,5],[29,2,29,3],[20,2,20,5],[48,2,48,3],[19,2,19,5],[48,4,48,5],[45,2,45,3],[43,2,43,5],[50,2,50,3],[50,4,50,5],[30,2,30,5],[44,2,44,3],[44,4,44,5],[42,2,42,3],[2,2,2,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[47,2,47,3],[29,4,29,5],[21,4,21,5],[15,4,15,5],[45,4,45,5],[14,4,14,5],[11,4,11,5],[12,4,12,5],[16,4,16,5],[55,2,55,3],[55,4,55,5],[51,2,51,3],[51,4,51,5],[41,2,41,3],[53,2,53,3],[3,1,3,5],[4,2,4,5],[6,2,6,3],[7,2,7,5],[8,4,8,5],[10,4,10,5],[10,2,13,2],[10,3,13,3],[13,4,13,5],[9,4,9,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 (word limit = 200)"]
[null,null,"Identified Risk","Current Status","Steps Taken to Mitigate Risk"]
[null,null,"The farm families do not understand the importance and/or possibility of responding and planning for climate change risks.","Low","To respond to Climate Change risks, the farm families are implementing agroecological transformation plans in their farms, developing a process of change toward a more resilient productive model that responds to extreme events, starting with community organization.  \nThrough the Family, Community and Life Cabinet, a new partnership model is created with the Extended and Production Cabinets, retaking the national plans for their implementation (Action Plan for Drought, Climate Change Strategy and National Sovereignty and Food Security Plan). \nThe project strengthens the capacities of the people living in the Villanueva River sub watershed preparing them to better face and reduce the risks due to climate change.  Fifty six community meetings have been held, 55 training workshops, 2 Municipal Environmental Fairs and 4 days of experience interchange on water catchment works and adaptative productive practices to create awareness in families regarding the threats of climate change, the importance of participating in the project and the need to apply adaptation measures in their farms.  A total of 4,559 people participated in these events, of which 1,377 were women.  The trained families have been very receptive to responding to the effects of climate change."]
[null,null,"Limited access to credit can limit adopting new technologies","Low","To mitigate the effect of the limited access to credit and that this can limit adopting new technologies, the project  has been promoting adaptative productive systems, that allow using ecologically sound productive technologies that increase and diversify production.\nThe adaptative productive systems take into account the comparative advantages of the farms, driving large scale production for internal consumption (national market) while protecting the natural resources.  To achieve this goal, the project facilitates production means, technical assistance and training in order to support the farm families in overcoming their poverty status and restore the productive potential. Additionally, these systems allow to better face climate change and its consequences.\nTo address this risk in the Villanueva River sub watershed during 2012 to 2013, 920 families have benefitted in 29 rural communities of the 8 priority micro watersheds in the municipalities of Achuapa, El Sauce and Villanueva.  The use and management of water has been more effective and adaptative productive systems have been established to face climate change, guaranteeing food security and improving their income and quality of life.\nFor this the following has been done:\n"]
[{"$nulls":4},"1.  Construction of two communal irrigation systems in the communities of Las Mercedes and Salale in the municipality of El Sauce, benefitting 100 families, guaranteeing at least one harvest a year.  In the irrigation system of Las Mercedes we already have 46 farm families getting 3 corn harvests a year in 37 ha, with an average yield of 25qq/ha, thus guaranteeing food security for their families. In 2013, together with INTA and MAGFOR they will receive seeds and technical assistance to plant other more productive crops (vegetables).                                \n\n\n\n\n\n"]
[{"$nulls":4},"2.  The establishment and implementation of 920 Agroecological Farm Transformation Plans have been started. The beneficiaries have received supplies and plants in the municipalities of Achuapa (1,423 rolls of wire, 2,154 lb. of staples and 30,521 forest plants, native fruit plants, grafts and  forage); El Sauce (1,874 rolls of wire, 3,748 lb. staples, and 30,813 plants between forest, native fruits, grafts and forage), and Villanueva (1,808 rolls of wire, 3,616 lb. of staples and 28,805 plants between forest, native fruits, grafts and forage). The plans delivered to the farm families have allowed them to own, use and manage them allowing the farm families to have an integral strategic vision of the management and development of their farm."]
[{"$nulls":4},"3. A total of 402 families have received material for building improved stoves in: Villanueva (152), and Achuapa (250).  Material has been distributed to 204 families to build chicken coops in: Achuapa (172), and Villanueva (32) and materials for pigpens to 72 families in: Achuapa (44) and Villanueva (28). "]
[null,null,"Key national and municipal stakeholders do not agree on a common watershed adaptation strategy","Low","To date the project promotes the process of creating 8 watershed management committees, incorporating the national and local stakeholders by signing institutional agreements to work in the Estero Real River watershed (MARENA-INETER), (MARENA-ANA), (MARENA-UNAN - Leon), (MARENA-MAGFOR) and (MARENA- Municipalities of El Sauce, Achuapa and Villaueva).\nTo form the Micro Watershed Committees, 24 community meetings were held to explain how they should be formed, functions, duties and rights the committees should have, based on Law 620 in Art. 35, chapter IV. These are duly registered in the National Registry of Water Rights (RPNDA), being legally constituted to start their functions regarding the water resource.             \nThe formulation of three (3) Municipal Climate Change Adaptation Plans was accomplished (Achuapa, El Sauce and Villanueva) through 18 workshops with the participation of local stakeholders of different sectors:\n- Producer organizations: National Union of Farmers and Ranchers (UNAG), Union of Agricultural Cooperatives of El Sauce (UCASA), Juan Francisco Paz Silva Producers Cooperative of the Municipality of Achuapa.\n- Government Institutions: Ministry of Health (MINSA), Ministry of Education (MED), National Police, Nicaraguan Institute of Agricultural Technology (INTA), Ministry of Agriculture and Forestry (MAGFOR), Ministry of the Family.\n-Civil Society Organizations: Young Environmentalist Guardabarranco Movement, Cabinets of Citizen Power of Achuapa, El Sauce and Villanueva and the Municipality associations of Chinandega Norte and Leon Norte. \n"]
[null,null,"Key national and municipal stakeholders do not agree on a common watershed adaptation strategy","Low","During the 2012-2013 period there weren't any natural events with negative impact on the execution of activities developed by the project."]
[]
[]
[]
[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,"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)"]
[null,null,"No mitigation measure was required.\n\n"]

{"sheet":"Rating","index":4,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[52,7,52,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[42,4,42,7],[43,4,43,7],[47,3,47,4],[47,5,47,8],[50,7,50,8],[51,7,51,8],[37,3,37,4],[37,5,37,6],[38,3,38,4],[38,5,38,6],[39,3,39,4],[39,5,39,6],[29,3,29,4],[29,5,29,6],[33,4,33,7],[34,4,34,7],[36,3,36,4],[36,5,36,6],[30,3,30,4],[30,5,30,6],[20,3,23,8],[26,3,26,4],[26,5,26,6],[27,3,27,4],[27,5,27,6],[28,3,28,4],[28,5,28,6],[12,5,12,6],[13,3,13,4],[13,5,13,6],[16,4,16,7],[17,4,17,7],[19,2,19,7],[5,5,5,6],[8,5,8,6],[7,5,7,6],[6,3,7,4],[9,3,9,4],[9,5,9,6],[11,3,11,4],[11,5,11,6],[12,3,12,4],[10,3,10,4],[6,5,6,6],[2,2,2,8],[3,2,3,8],[8,3,8,4],[10,5,10,6],[5,3,5,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: ","The construction of 2 communal irrigation systems to supply water to 85 farming families in 2 micro watersheds, which increases the availability of water for small scale domestic and productive use and reduces the risk of water stress and drought.                     ",null,"Construction of the communal irrigation systems completed in Las Mercedes and Salale.\n",null,"Construction of Las Mercedes communal irrigation system was completed in October 2012, benefitting 68 families. Construction of the Salale communal irrigation system will be completed in July 2013 and will benefit 32 families.                                    \nIn Las Mercedes irrigation system we have 46 farm families getting three corn harvests a year in 37 ha, producing an average of 25qq/ha, thus guaranteeing food security for their families.\nFor 2013, work is being done with INTA, MAGFOR, and MEFCA to  offer technical assistance and offer seed for more profitable crops and diversify the farms. \n","Satisfactory (S)"]
[{"$nulls":5},"At least 880 rain water collection and storage structures supply water to family farms in 8 micro-watersheds.",null,"A total of 316 rain water collection and storage structures built in the municipalities of Achuapa, El Sauce and Villanueva, benefitting an equal number of families:\nAchuapa: 17 pools, 72 troughs, 24 cisterns, 38 drinking troughs and 6 dams; in the communities of San Nicolas, Lagartillo, Las Brisas, San Antonio, Varela, El Waylo, Guanacaste, Las Lajas, Rio Arriba, Las Tablas and Rodeito.\nVillanueva: 24 pools; 43 troughs, 47 cisterns, and 21 drinking troughs; in the communities of Los Genízaros, Los Tololos and San Ramón.\nEl Sauce: 24 pools, in the communities of Petaquilla, Campamento and Nacascolo Norte.\nThe use of the structures will be monitored through follow-up visits, certificates of satisfactory delivery and surveys to know their use and benefit, additionally reflecting the amount of water collected.","Satisfactory (S)"]
[null,null,null,"A hydrological study of the lower watershed of the Villanueva River, identifying hydraulic structures required to reduce floods caused by sediment from the high basin.                         ",null,"Completion of the hydrological study in the second semester of 2013.",null,"Study of threats due to floods in the urban area of Villanueva and adjacent towns formulated in 2012.                              This study forms part of the hydrogeological study that is being carried out in the high, middle and low part of the Villanueva Riber sub watershed, which will allow the people of the community to know the status of degradation of the watershed and identify required environmental restoration measures. All this process is taking place by segments, in the framework of the collaboration agreement between the Ministry of the Environment and Natural Resources and the Nicaraguan Institute of Territorial Studies.                                     ","Satisfactory (S)"]
[null,null,null,"At least 1005 farming families have agro-ecological transformation plans in their farms, which will allow introducing climate resilient agro-ecological practices to use the available water effectively, using their own resources and available credit for their implementation.",null,"The preparation of 1005 agro-ecological transformation plans in family farms as an essential instrument to guide investments in productive systems.",null,"A total of 920 agroecological farm transformation plans have been formulated (PTAF), equivalent to 91.54% progress, with 85 plans still pending to be formulated which will be ready by the end of 2013.  \nThe elaborated plans are: \nIn Achuapa: 375 plans\nEl Sauce: 270 plans \nIn Villanueva: 275 plans","Satisfactory (S)"]
[null,null,null,"Identification and prioritization for 400 ha of riparian and recharge zones of drinking water systems in state of degradation.",null,"Identification process and prioritization of riparian and water recharge zones completed in the program's eight targeted micro-watersheds. ",null,"A total of 690ha of riparian areas and 4,107 ha of forest water recharge zones have been identified in the eight targeted micro-watersheds. For their protection, the farm families have been provided with wire, staples and plants to enrich the forest, as well as assistance and training.","Highly Satisfactory (HS)"]
[null,null,null,"Design and development of a campaign to control and prevent forest, agricultural and livestock fires in coordination with Civil Defense.",null,"Develop a fire prevention and control campaign with the participation of local stakeholders of the micro-watersheds in the 3 municipalities.    ",null,"Two awareness campaigns have been carried out for the communities in the three targeted municipalities, through meetings with the participation of students, Municipal Environmental Units, Civil Defense, Nicaraguan Army, MARENA Department Delegates, Local Disaster Management Committees (COMUPRED) and the general population. \nIn 2012, 3000 people in the area targeted by the program in the 3 municipalities benefitted from this campaign; dissemination was carried out through radio commercials and hot spots were monitored                  \nIn 2013, 7 brigades of 10 members each, one per micro-watershed, were trained and certified and hot spots were monitored,\n","Satisfactory (S)"]
[null,null,null,"Support households and farmers in 3 municipalities to cope with climate change impacts by developing 3 tailored municipal climate change adaptation plans in the municipalities of Villanueva, El Sauce and Achuapa.",null,"Municipal Climate Change Adaptation Plans formulated and approved",null,"Three Municipal Climate Change Adaptation Plans formulated for Achuapa, El Sauce and Villanueva, with specific strategic lines for each municipality.\nThe plans were approved by the Honorable Municipal Council of each Municipality through a Certification. These plans are in the process of publication.\n","Satisfactory (S)"]
[null,null,null,"Establish electronic information posts to gather information of each of the 8 micro-watersheds with support from SINIA-MARENA and the governmental institutions.            ",null,"Eight electronic information posts working",null,"There are 8 electronic posts working, one in each micro-watershed, to gather baseline information on the environmental and productive indicators of each of the micro watershed communities. Three newsletters have been elaborated with the information gathered.                              \n","Satisfactory (S)"]
[{"$nulls":7},"Overall Rating","Satisfactory (S)"]
[{"$nulls":4},"Please Provide the Name and Contact information of person(s) responsible for completing the Rating section"]
[null,null,null,"Name: ","Karla Vanessa Rodriguez Gutierrez"]
[null,null,null,"Email: ","karlavanessa2005@gmail.com"]
[]
[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,"MARENA, through two and a half years of Program implementation, has made substantial progress with the construction of the two large communal irrigation systems, benefitting 100 families of the Salale and Las Mercedes micro-watersheds.  These systems have achieved an irrigation capacity of 170 ha during the summer, which has guaranteed food security, improvement in the quality of life of the people who live there and in their family income.                   \nA total of 690 ha of riparian areas and 4,107 ha of forest water recharge zones have been protected and conserved in the eight targeted micro-watersheds.                 \nIn Achuapa, El Sauce and Villanueva, 920 agroecological farm transformation plans have been formulated; this instrument arranges the farms of the families benefitted by the Program.  Likewise, actions aimed at benefitting women are being implemented through investments for patio productive activities (improved stoves, chicken coops and pigpens).                 \nThree Municipal Climate Change Adaptation Plans have been formulated to be implemented in the municipalities of Achuapa, El Sauce and Villanueva.  A Demarcation Study of Riparian and Water Recharge Zones, Study of threats based on floods in the urban area of Villanueva and adjacent towns and three program News Bulletins published in the MARENA website.                \nEight micro-watershed committees have been formed in coordination with ANA, UAM and Municipal Environmental Units of the three Municipalities.  These committees are duly registered in the National Registry of Water Rights (RPNDA), being legally constituted to start their functions regarding the water resource.\nMaps and georeferencing data of the farms with agroecological transformation plans have been generated in the eight micro-watersheds.\nThe Program has made substantial progress in the execution of all its components, achieving this in coordination with the municipal governments, government institutions, Family, Health and Life Cabinets,  ONGs and the active participation of the Program's beneficiaries.                          \n"]
[]
[]
[]
[]
[]
[null,null,null,"Progress on Key Milestones",null,"Expected Progress",null,"Progress to Date","Rating"]
[null,null,"Implementing Agency  ","Component 1:\nInvestments in infrastructure for storing and using rain and surface water in eight micro-watersheds in the upper watershed of the Estero Real River.\n",null,"Structures for the communal irrigation systems completed and rain water collection and storage structures being built to supply water to family farms in 8 micro-watersheds.",null,"The construction of the two communal irrigation systems in Las Mercedes and Salale was completed, benefitting more than 100 farm families.\nLas Mercedes irrigation system was completed in October 2012 and has been working since then, allowing 68 farm families who benefit from this system to already be harvesting corn.\nIn addition, 316 rain water collection and storage structures built in the municipalities of Achuapa, El Sauce and Villanueva, benefitting an equal number of families.\n","S"]
[null,null,null,"Component 2:\nIntroduction of climate resilient agro-ecological practices to make effective use of available water.\n",null,"(a) 1005 agroecological transformation plans completed and at least 50% of them in execution.\n(b)Management plans for riparian and water recharge zones in execution.",null,"(a) A total of 920 Agroecological Farm Transformation Plans have been formulated and delivered to the beneficiaries. Of these, 840 are being implemented, starting with the delivery of supplies and plants.  When the agroecological transformation plan is delivered, the beneficiaries sign a Solidarity Agreement with the Ministry of the Environment, whereby they commit to implement the plan they have formulated together with the AF Project's technicians.  The farms have been georeferenced.                                                     \nThe plans also include investments for special productive activities to be carried out by women, in their patios, such as the construction of chicken coops, pigpens or improved stoves.                                            \n(b) A total of 690 ha of riparian areas have been identified and 4,107 ha of forest water recharge zones in the eight targeted micro-watersheds.  Protection actions for these have been incorporated in the agroecological farm transformation plans and the farm families have received supplies, plants, technical assistance and training to implement concrete forest management actions. \n","S"]
[null,null,null,"Component 3:\nInstitutional development and capacity building in micro-watersheds, municipalities, and participating national institutions",null,"(a) Eight micro-watershed management committees working.\n(b) Municipal adaptation plans for El Sauce, Achaupa and Villanueva formulated, approved and disseminated.",null,"(a) Eight micro-watershed committees formed in Achuapa (2); El Sauce (3) and Villanueva (3). The committees were formed through 24 Community Meetings and they are duly registered in the National Registry of Water Rights (RPNDA), being legally constituted to start their  functions. These activities were carried out in close coordination with the National Water Authority (ANA).\n(b) The municipalities of Achuapa, El Sauce and Villanueva each have their Municipal Climate Change Adaptation Plan. The plans were designed through 18 workshops with the participation of different sectors and have been approved by the respective Municipal Councils. Publication and dissemination of the plans is still pending.\n","S"]
[null,null,null,"Component 4:\nOngoing monitoring and analysis of climatic conditions and changes in land use, water flows and soil quality",null,"(a) Hydrogeological study of the Villanueva River watershed completed.\n(b) The electronic information posts are working and have generated at least 4 news bulletins.",null,"The Ministry of the Environment and Natural Resources (MARENA) together with the Nicaraguan Institute of Territorial Studies (INETER) signed a Collaboration Agreement to carry out a hydrogeological study for the high, middle and low part of the Villanueva River sub watershed that will allow the people in the community to know the status of degradation of the watershed and environmental restoration measures. At the end of 2012, as part of the study, a threat analysis of floods in the urban area of Villanueva and adjacent towns was carried out. The studies continue to be carried out during this period.                                                          ","S"]
[{"$nulls":7},"Overall Rating","S"]
[{"$nulls":4},"Please Provide the Name and Contact information of person(s) responsible for completing the Rating section"]
[null,null,null,"Name: ","Maria Fernanda Sanchez  /   Reis Lopez Rello"]
[null,null,null,"Email: ","fernanda.sanchez@undp.org    /    reis.lopez.rello@undp.org"]
[]
[null,null,null,"Progress on Key Milestones",null,"Expected Progress",null,"Progress to Date","Rating"]
[null,null,"Other"]
[]
[]
[{"$nulls":7},"Overall Rating"]
[{"$nulls":4},"Please Provide the Name and Contact information of person(s) responsible for completing 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,"During its second year of implementation important progress has been made toward achieving the Project's objectives.                         \nMARENA, with AF funds, has completed construction of two communal irrigation systems that will increase water availability for domestic and productive use, benefitting 68 farm families of Las Mercedes micro-watershed and 32 farm families of the Salale micro-watershed.                              \nA total of 1005 families will benefit with agroecological farm transformation plans to introduce silvopastoral systems, of which 920 have already been formulated and delivered to the farm families and 840 are in the implementation process.  \nTo strengthen the population's capacity to prepare for climate change effects, Municipal Climate Change Adaptation Plans have been formulated for the municipalities of Achuapa, El Sauce and Villanueva through a wide participatory process of consultation and consensus with different sectors.                                    \nAdditionally,  8 Micro-watershed Committees were formed, which are duly registered in the National Registry of Water Rights (RPNDA), being legally constituted to start their functions in the management of the water resource.      \nTechnical assistance has been guaranteed for the implementation of the eight electronic information posts, for the purpose of collecting baseline information on the indicators of the selected micro-watersheds. The information nodes' main function is to feed the National Environmental Information System (SINIA) to develop the geo-referenced information that will be used for the local stakeholders as a monitoring tool for the activities carried out by MARENA in El Sauce, Achuapa, and Villanueva. These posts have produced 3 news bulletins.                \nThe total disbursement since the beginning of the project until June 2013 has been USD$2,142,787 (42.3% of the project's total amount ).             \nIt is estimated that by the end of 2013 implementation rate will keep steady and the total cumulative expenditure will represent more than 50% of the project's total budget.\n"]
[]
[{"$nulls":6},"Rating Definitions"]
[{"$nulls":6},"Highly Satisfactory (HS)","Project actions/activities planned for current reporting period are progressing on track or exceeding expectations to achieve all  major objectives/outcomes for given reporting period, without major shortcomings. The project can be presented as “good practice”."]
[{"$nulls":6},"Satisfactory (S)","Project actions/activities planned for current reporting period  are progressing on track to achieve most of its major objectives/outcomes with only minor shortcomings."]
[{"$nulls":6},"Marginally Satisfactory (MS)","Project actions/activities planned for current reporting period  are progressing on track to achieve most   major relevant objectives/outcomes, but with either significant shortcomings or modest overall relevance. "]
[{"$nulls":6},"Marginally Unsatisfactory (MU)","Project actions/activities planned for current reporting period  are not progressing on track to achieve  major objectives/outcomes with major shortcomings or is expected to achieve only some of its major objectives/outcomes."]
[{"$nulls":6},"Unsatisfactory (U)","Project actions/activities planned for current reporting period  are not progressing on track to achieve most of its major objectives/outcomes."]
[{"$nulls":6},"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 objectives/outcomes."]

{"sheet":"Project Indicators","index":5,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[10,9,10,13],[10,3,10,4],[11,3,11,4],[15,3,15,4],[19,9,19,13],[20,3,20,4],[3,2,3,7],[4,2,4,7],[5,2,5,7],[7,3,7,4],[8,3,8,4],[9,3,9,4],[6,2,6,3],[26,3,26,4],[18,3,18,4],[25,3,25,4],[19,3,19,4],[23,3,23,4],[22,3,22,4],[24,3,24,4],[19,14,19,18],[21,9,21,13],[12,3,12,4],[14,3,14,4],[16,3,16,4],[17,3,17,4],[13,3,13,4],[21,3,21,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,"Project Indicator","Number of farm families in the targeted micro-watersheds with at least one annual harvest.",null,400,"A total of 920  farm families have Agroecological Transformation Plans for their farms, which represents 91.54% of the 1005 beneficiary farm families. Of these plans, 840 are already starting the implementation phase.                  ",1005]
[null,null,"Project Indicator","Number of farm families included in Sub-Watershed management proposal.",null,0,"Preparation of the micro-watershed Management Plans has not yet started. To date only the management committees have been formed.                               ",7120]
[null,null,"Outcome Indicator","Percentage of farms in each micro-watershed with access to irrigation by means of hydraulic works built with programme funds.",null,0,"A total of 100 families who benefit from the two communal irrigation systems in the micro-watershed of Las Mercedes (68 families) and the micro-watershed of Salale (32 families) of the municipality of El Sauce have at least one annual harvest guaranteed which represents 137.64% according to the expected goal at the end of the project which was 90%.                               ",0.9]
[null,null,"Outcome Indicator","Surface in hectares to increase low risk",null,"67.55 has","In the micro-watershed of Las Mercedes, 56ha were irrigated without the project, and with the project it has been possible to add 18ha for a total of 74ha under irrigation (with an average of 2 harvests per year in 2013).  As of 2014, the expectation is to cover a total of 130 ha with the new irrigation system.                                      \nIn the case of the Salale micro-watershed, the results will be seen in the summer months of 2013 and 2014; the expectation is to go from irrigating 11ha by the traditional method to 40 ha with the new system.   \n","161.5 has"]
[null,null,"Outcome Indicator","Amount of water (lts/sec) carried through the communal irrigation system infrastructures.",null,"0 lts/seg","The communal irrigation system in the micro-watershed of Las Mercedes is formed by two components: 1) Construction of a water intake structure in Mercedes Centro, which carries 30lt/sec for irrigation by sprinklers, benefitting 35 farm families. A 25mt3 tank is filled from this intake for the cattle area benefitting 17 farm families and the washing zone, benefitting 22 laundresses. 2) The collection system of the Ismael Castillo Cooperative carries 50lt/sec.  This water will be used to irrigate by flooding through channels, benefitting 11 farm families.                                        \nAdditionally, a dam was built for the Salale communal irrigation system with its respective intake which has a capacity to carry 30lt/sec; this system will directly benefit 32 farm families.","50 lts/seg"]
[null,null,"Outcome Indicator","Percentage of farmers in each micro-watershed, the water use of which is rated as satisfactory in relation to the relevant technical guidelines. ",null,0.05,"A total of 36%  of rain water collection structures built in communities of the municipalities of Achuapa, El Sauce and Villanueva.  Evaluation by the program beneficiaries is still pending to determine if the use of water is satisfactory. ",0.9]
[null,null,"Outcome Indicator","Number of water harvesting structures installed and working at the micro-watershed level",null,0,"A total of  316 rain water collection and storage structures built in communities in the municipalities of Achuapa, El Sauce and Villanueva, benefitting an equal number of families.  The structures are distributed as follows:                                                 \nAchuapa: 17 pools, 72 troughs, 24 cisterns, 38 drinking troughs and 6 dams, in the communities of San Nicolás, Lagartillo, Las Brisas, San Antonio, Varela, El Waylo, Guanacaste, Las Lajas, Rio Arriba, Las Tablas and Rodeíto.\nVillanueva: 24 pools, 43 troughs, 47 cisterns and 21 drinking troughs in the communities of Los Genízaros, Los Tololos and San Ramón.\nEl Sauce: 24 pools in the communities of Petaquilla, Campamento and Nacascolo Norte.\n",880]
[null,null,"Outcome Indicator","Percentage of farm families in each micro-watershed implementing agro-ecological farm transformation plans. ",null,0.05," A total of 91.54% of Agroecological Farm Transformation Plans formulated in communities of the municipalities of Achuapa, El Sauce and Villanueva, detailed as follows:                                          \na) 91.46% of the total agroecological farm transformation plans delivered, belonging to 12 communities of the municipality of Achuapa; started implementation in 2012.\nb) 98% of the total agroecological farm transformation plans delivered, belonging to 6 communities of the municipality of Villanueva; started implementation in 2012.\nc) 81.92% of the total agroecological farm transformation plans delivered, belonging to 11 communities of the municipality of El Sauce; started implementation in 2013.\n",0.8]
[null,null,"Outcome Indicator","Number of farming families with agro-ecological farm transformation plans",null,0,"A total of 920 agroecological farm transformation plans (PTAF) have been formulated, equivalent to 91.54% of the total programmed, distributed as follows:  \nIn Achuapa: 375 plans\nEl Sauce: 270 plans \nIn Villanueva: 275 plans\n",1005]
[null,null,"Outcome Indicator","Area (ha) of agro-ecological transformation plans developed in farms",null,0,"The 920 plans formulated to date include the agroecological transformation of 2,059 ha, exceeding the goal expected at the end of the project.                                                             ","1120 has"]
[null,null,"Outcome Indicator","Increase in percentage of land in each micro-watershed with vegetation coverage.  ",null,0.25,"The goal has been surpassed from 100% to 172.5%.",0.5]
[null,null,"Outcome Indicator","Surface in hectares of protected  forest water recharge and riparian zones ",null,0,"A total of 690ha in riparian areas and 4,107ha of forest water recharge zones in the 8 targeted micro-watersheds. In addition to the management of the natural regeneration, there is no burning-off of scrub and they have been fenced with barbed wire protecting them from animals and other intruders. For this, the farm families have been provided with wire, staples, plants for forest enrichment, as well as technical assistance and training.                                            .\n\n\n\n","400 has",null," "]
[null,null,"Outcome Indicator","Number of families that benefit with home and patio investments through the Farm Transformation Plans (PTAF).",null,0,"In the municipality of Achuapa, supplies have been delivered for the construction of 250 improved stoves, 172 chicken coops and 45 pigpens, benefitting a total of 467 families.  To date 15 stoves have been built in the community of Las Tablas, benefitting an equal number of families.                                                           \nIn the municipality of Villanueva, supplies have been delivered for the construction of 152 improved stoves, 32 chicken coops and 28 pigpens, benefitting a total of 212 families.  To date 30 stoves have been built in the communities of San Ramon, Los Genízaros, Los Tololos and El Tule, benefitting an equal number of families.\n","1005 Households",null,"New indicator:\nMARENA, based on its Gender Policy, identified the need to measure gender-related activities and decided to develop a new indicator which is now included in the logframe."]
[null,null,"Outcome Indicator","An experientially-based proposal endorsed by three municipal governments for the operation of a Sub-Watershed Committee for the Villanueva River basin. ",null,0,"Eight  micro-watershed committees formed in Achuapa (2); El Sauce (3) and Villanueva (3). The committees were formed through 24 community meetings and are duly registered in the National Registry for Water Rights (RPNDA), being legally constituted to begin functions. These activities were carried out in close coordination with the National Water Authority (ANA).                                   ",1]
[null,null,"Outcome Indicator","Municipalities in watershed with climate change adaptation measures included with their official plans and related normative instruments. ",null,0,"Based on the official methodology of the Ministry of the Environment and Natural Resources for the formulation of the Municipal Climate Change Plans, 18 workshops were held in the municipalities of Achuapa, El Sauce and Villanueva to collect information that allows the population to know the situation and effects caused by climate change and identify climate change adaptation measures in these municipalities.                                                               \nThese plans were approved by the three Mayor's Offices: El Sauce in 2012, and Achuapa and Villanueva in 2013. These plans were already revised by the MARENA General Planning Division for their reproduction and dissemination.\n",9]
[null,null,"Outcome Indicator","Hydrological study and number of news bulletins to disseminate the participatory monitoring of water quality and amount, soil conditions and use changes.",null,0,"The study of threats due to floods in the urban area of Villanueva and adjacent towns formulated in 2012. This study forms part of the hydrogeological study that will be carried out in the high, middle and low part of the Villanueva River sub watershed, which will allow the community members to know the status of degradation of the sub watershed and identify environmental restoration measures. All this process was made operational in the framework of a collaboration agreement between the Ministry of the Environment and Natural Resources and the Nicaraguan Institute of Territorial Studies.                                                 \n\n",1]
[null,null,"Outcome Indicator","Lessons learnt in eight micro-watersheds and the Villanueva River Sub-Watershed available in SINIA and other web sites and disseminated through exchange workshops.",null,0,"The Project's progress and achievements has been disseminated through several instruments:\n- Nicaragua: Promoting climate resilient Communities. UNDP Climate Change Adaptation News Bulletin, 12th edition (March 2013).\n- Government promotes construction of Eco- friendly stoves. Online Environmental News Bulletin, MARENA, 33d Edition (January 2013).\n- Nicaragua works toward reducing risks and vulnerabilities due to floods and droughts in the Western part of the country. Online Environmental News Bulletin, MARENA, 35th Edition (March 2013).\nThe Project's website is still under construction.\nThe Project has generated regular, periodic progress reports regarding the project's physical and financial execution.","Feed the AF and MARENA website; 4 annual reports and 12 quarterly reports. "]

{"sheet":"Lessons Learned","index":6,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[25,2,25,3],[2,2,2,3],[11,2,11,3],[13,2,13,3],[17,2,17,3],[21,2,21,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,"Describe any implementation issues/lessons affecting progress (positive and negative)","1. The dams allow production of up to 4 harvests in one same area integrating the efforts of all the community members.                         \n2. The agroecological farm transformation plans allow the beneficiary families to direct their efforts and resources to develop their farms with a vision of productive diversification, increasing production and adequate management of natural resources with a gender and generational based approach.                        \n3. The shared responsibility and family, community and life cabinets model has facilitated community organization in the micro-watershed committees.   \n4. The electronic information posts installed in the micro-watersheds allow generating key information used in the community development processes of each micro-watershed.\n5. The news bulletin of watershed 60 has allowed uniting and disseminating the project's progress, disseminating the experiences of each micro-watershed.\n"]
[null,null,"Were there any delays in implementation?  If so, include any causes of delays. What are the measures taken to reduce delays?","The only output that has suffered some delay in this period is the Hydrological Study.  In the framework of a Collaboration Agreement between the Ministry of the Environment and Natural Resources and the Nicaraguan Institute of Territorial Studies (INETER), the first study was formulated in December 2012 on threats based on floods in the urban area of Villanueva and adjacent towns, which was presented to the local municipal governments, government institutions and the Community, Health and Life Cabinet by INETER.  By the end of 2013, the last study on threats is expected to be received in the framework of  Addendum No. 1 (No. 371-13) collaboration agreement between the Ministry of the Environment and Natural Resources (MARENA) and the Nicaraguan Institute of Territorial Studies (INETER), signed May 14, 2013.                     "]
[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 this period two important changes are reported:\nThe first is regarding the project's targeted communities; when the interventions started in the territory, the territorial boundaries were confirmed in the targeted area, identifying that the communities of El Moto and La Concha were outside the boundaries, replacing them with the communities of Los Chupaderos, El Tule and Las Pilas, for a total of 29 communities to be benefitted by this project.                                              \nThe second change is regarding the Project Logical Framework which was revised and an indicator was incorporated related to the Gender theme: Number of families benefitted with home and patio investments through the Farm Transformation Plans (PTAF). This indicator is already reported on the  Project Indicator tab of the present PPR.\n"]
[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?","The  agroecological transformation plans also include investments in special productive activities to be carried out by women, in their patios, such as construction of chicken coops, pigpens and/or improved stoves. \nIn the municipality of Achuapa supplies have been delivered for the construction of 250 improved stoves, 172 chicken coops and 45 pigpens, benefitting a total of 467 families.  To date 15 improved stoves have been built in the community of Las Tablas, benefitting an equal number of families.\nIn the municipality of Villanueva supplies have been delivered for the construction of 152 improved stoves, 32 chicken coops and 28 pigpens, benefitting a total of 212 families.  To date 30 improves stoves have been built in the communities of San Ramón, Los Genízaros, Los Tololos and El Tule, benefitting an equal number of families.\nAdditionally, an gender indicator was incorporated, which is already reported in the project indicator tab."]
[]
[null,null,"Please Complete the following section at mid-term and project completion"]
[null,null,"Lessons for Adaptation","Response"]
[null,null,"Climate Resilient Measures"]
[null,null,"Please Describe the Climate Resilient measures being undertaken by  the project/project."]
[null,null,"Which of these measures has been most effective and why?"]
[null,null,"Which have been least effective and why?"]
[null,null,"Concrete Adaptation Interventions"]
[null,null,"Please describe the concrete adaptation measures being undertaken by the project/projectme"]
[null,null,"What are/were the most difficult aspects of implementing such measures?"]
[null,null,"What are/were the most successful aspects of the implementation of the interventions?"]
[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/project results?"]
[null,null,"What measures are being/could have been put in place to improve project/project results?"]
[null,null,"Knowledge Management "]
[null,null,"Describe what kind and how existing information/data/knowledge has been used to inform the development and the implementation of the project."]
[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 why have they contributed?"]
[null,null,"What have been the major lessons learned that would add to the knowledge base for dissemination within and beyond  the project area?"]

{"sheet":"AF Tracking Tool","index":7,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[31,7,31,8],[30,5,30,12],[31,5,31,6],[37,5,37,12],[35,5,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[36,5,36,6],[36,7,36,8],[36,9,36,10],[32,11,32,12],[34,1,34,12],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[36,11,36,12],[25,5,25,6],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[31,9,31,10],[31,11,31,12],[32,5,32,6],[32,7,32,8],[32,9,32,10],[27,1,27,12],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[29,5,29,6],[22,11,22,12],[29,7,29,8],[29,9,29,10],[29,11,29,12],[20,1,20,12],[23,5,23,12],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[25,7,25,8],[25,9,25,10],[25,11,25,12],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[22,5,22,6],[22,7,22,8],[22,9,22,10],[1,2,1,6],[14,7,14,8],[14,9,14,10],[6,1,7,12],[8,1,8,12],[9,1,9,12],[2,2,2,5],[13,1,13,12],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[11,1,11,3],[14,5,14,6],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[14,11,14,12],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[16,5,16,12]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Tracking Tool 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 CEO Endorsement                    (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",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"]
[]
[null,"Fund Output","Please select  from dropdown menu below","Fund Output Indicator","Please select  from dropdown menu below","Target at CEO Endorsement                    (see Units in next sheet)",null,"Baseline                 (see Units in next sheet)",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                                                                                      1.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)                                                                                                                   6.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                                                                                    7.1. No., type, and sector of policies introduced or adjusted to address climate change risks                                                                                 7.2. No. or targeted development strategies with incorporated climate change priorities enforced"]
[]
[null,"OBJECTIVE 2"]
[null,"Fund Outcome","Please select  from dropdown menu below","Fund Outcome Indicator","Please select  from dropdown menu below","Target at CEO Endorsement ",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"]
[]
[null,"Fund Output","Please select  from dropdown menu below","Fund Output Indicator","Please select  from dropdown menu below","Target at CEO Endorsement ",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                                                                                      1.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)                                                                                                                   6.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                                                                                    7.1. No., type, and sector of policies introduced or adjusted to address climate change risks                                                                                 7.2. No. or targeted development strategies with incorporated climate change priorities enforced"]
[]
[null,"OBJECTIVE 3"]
[null,"Fund Outcome","Please select  from dropdown menu below","Fund Outcome Indicator","Please select  from dropdown menu below","Target at CEO Endorsement ",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"]
[]
[null,"Fund Output","Please select  from dropdown menu below","Fund Output Indicator","Please select  from dropdown menu below","Target at CEO Endorsement ",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                                                                                      1.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)                                                                                                                   6.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                                                                                    7.1. No., type, and sector of policies introduced or adjusted to address climate change risks                                                                                 7.2. No. or targeted development strategies with incorporated climate change priorities enforced"]
[]
[null,"OBJECTIVE 4"]
[null,"Fund Outcome","Please select  from dropdown menu below","Fund Outcome Indicator","Please select  from dropdown menu below","Target at CEO Endorsement ",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"]
[]
[null,"Fund Output","Please select  from dropdown menu below","Fund Output Indicator","Please select  from dropdown menu below","Target at CEO Endorsement ",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                                                                                      1.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)                                                                                                                   6.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                                                                                    7.1. No., type, and sector of policies introduced or adjusted to address climate change risks                                                                                 7.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."]