{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","SDGs and Targets","Instructions","Selection of indicators","Intervention 1","MRV_Interv1","Monitoring sheet","Data Ranges"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":80,"n_cols":9,"rows_kept":80,"cut":false,"hidden":false,"merged":[[59,3,59,6],[26,1,26,3],[11,1,11,11],[25,1,25,12],[52,4,52,7],[53,4,53,7],[27,1,27,14],[54,4,54,7],[29,1,29,15],[54,1,54,3],[46,2,46,7],[47,2,47,7],[50,1,50,3],[51,1,51,3],[50,4,50,7],[51,4,51,7],[48,2,48,7],[53,1,53,3],[52,1,52,3],[9,1,9,9],[10,1,10,9],[16,1,16,12],[17,1,17,12],[18,1,18,13]]}
[]
[null,null,null," Nationally Appropriate Mitigation Action (NAMA) Sustainable Development Evaluation Tool"]
[null,null,"Date","2015-04-27"]
[null,null,"Version",2]
[]
[]
[]
[null,"Introduction"]
[]
[null,"This tool has been designed for NAMA developers and policy makers."]
[null,"This tool has been designed to evaluate the Sustainable Development performance indicators for NAMAs and to evaluate the Sustainable Development results achieved over the lifetime of the NAMA."]
[null,"The tool should allow policy makers to track and highlight the effects of a NAMA on environmental conservation, economic growth, poverty reduction and public welfare.  "]
[]
[]
[null,"Origin of 4 Domains and indicators"]
[null,"Domains"]
[null,"Different domains are identified for sustainable development.  International organizations broadly use the three famous pillars: environment, social and economic for classification of Sustainable Development benefits. However, couple of indicators always have a dual effect on either of these pillars ( For example women empowerment will have effect both on social and economic domain), therefore, it becomes necessary to classify them into another pillar (pillar is being replaced by Domain in this tool) for easy and consistent reporting. The fourth domain was called \"Development and Growth\" This domain will be used to classify all the overlapping indicators."]
[]
[null,"New break up of Sustainable Development domains are as below:"]
[null,"Environment","This domain would only cater to changes in environment (pollution reduction or quality improvement) due to an intervention"]
[null,"Social","This domain would cater to social aspects of the intervention. Since the social impacts would also have an impact on economic benefits, this domain will only assess the social impacts, which are not linked to any other domains"]
[null,"Growth and Development","This domain will cater to the development aspects of the intervention without linking it to financial benefits."]
[null,"Economic","This domain would calculate the economic (money) related benefits which can be measured directly."]
[]
[null,"Indicators"]
[null,"The tool proposes selecting indicators that reflect how the NAMA interventions support sustainable development. In order to limit the burden on human and financial resources to measure and report data, policy-makers should select a small, core list of indicators that are specific, meaningful, measurable, and cost-effective to collect. They should also be pertinent and easy to understand."]
[null,"At least one indicator per domain needs to be assessed by the NAMA implementer. "]
[null,"Indicators have been selected after a deep analysis of the existing NAMAs papers from the UNEP Risoe and Ecofys databases and also have been sorted according to their relevance to SDGs which are under development.  "]
[]
[null,"This tool has described the relevance of indicators to SDGs, however this may be subject to change as the SDGs are yet not finalized. SDGs are listed below."]
[]
[]
[null,"Contents of the tool /description of the tabs"]
[]
[null,"The tool consists of the following tabs:"]
[null,"SDGs and Targets","SDGs and Targets","Lists the SDGs and relative targets"]
[null,"Instructions","Instructions","Provides instructions for the user and guidance for monitoring"]
[null,"SD Evaluation","NAIs","Provides a summary of the NAIs calculated"]
[null,"Selections of indicators","Selection of indicators","Provides a table for the selection of the indicators"]
[null,"Monitoring","Intervention 1","Evaluates the SD benefits of the intervention 1 "]
[null,null,"MRV Intervention 1","Provides tables for the MRV procedures of intervention 1  "]
[null,null,"Monitoring sheet","Lists the monitoring parameters"]
[]
[]
[null,"NAMA's information"]
[null,null,"  "]
[null,"Name","Adaptation and Mitigation Initiatives in Philippine Rice Cultivation"]
[null,"NAMA implementer","Department of Agriculture, Government of the Philippines"]
[null,"Country","Philippines"]
[]
[null,"Intervention",null,null,"Short description of intervention",null,null,null,"Intervention implementers"]
[null,"Implementation of Alternate Wetting and Drying (AWD) in Rice Cultivation at Irrigated Rice Fields",null,null,"Change in rice cultivation practice from continuous flooding, which is the traditional and prevailing practice in the Philippines, to AWD",null,null,null,"Rice farmers"]
[]
[]
[]
[]
[]
[null,"Determination of NAMA ambition and NAMA success with Nationally Appropriate Improvements (NAIs):"]
[null,"NAIs are calculated for each intervention, the mean value is determined for each domain, and the overall ambition and success of the NAMA calculated as the mean value over all domains. The applied formula are shown as follows:  "]
[null,null,"The more the better","The fewer the better",null,null,null,"Baseline = 0"]
[null,"NAIest ="]
[null,"NAIex-post ="]
[null,"Evaluation of Project ="]
[]
[null,"Whereas:"]
[null,"Vbasic:","Baseline Value"]
[null,"Vest:","Estimated Target-Value"]
[null,"Vex-post:","Monitored Intervention-Value"]
[null,"NAIest:","Estimated NAI (ex ante)"]
[null,"NAIex-post:","Monitored NAI (ex-post)"]
[]
[null,"Sustainable Development Goals (SDGs) ( Currently being finalized and subject to change)"]
[null,"SDGs refer to an agreement of the United Nations Conference on Sustainable Development held in Rio in June 2012 (Rio+20), to develop a set of future international development goals."]
[null,"These goals constitute an integrated, indivisible set of global priorities for sustainable development. Targets are defined as aspirational global targets."]
[null,"This tool makes a link between the indicators chosen for each domain and the corresponding targets. The chosen parameters indicate the positive impact of the intervention to the related target."]
[null,"SDGs have been further elaborated in SDGs and Targets Tab:"]
[null,"SDGs and Targets"]
[]
[]
[null,"Copyright 2014 United Nations Development Programme"]

{"sheet":"SDGs and Targets","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,5],[19,6,19,7],[16,1,16,5],[16,6,16,7],[17,1,17,5],[17,6,17,7],[18,1,18,5],[18,6,18,7],[13,1,13,5],[13,6,13,7],[14,1,14,5],[14,6,14,7],[15,1,15,5],[15,6,15,7],[10,1,10,5],[10,6,10,7],[11,1,11,5],[11,6,11,7],[12,1,12,5],[12,6,12,7],[7,1,7,5],[7,6,7,7],[8,1,8,5],[8,6,8,7],[9,1,9,5],[9,6,9,7],[4,1,4,5],[4,6,4,7],[5,1,5,5],[5,6,5,7],[6,1,6,5],[6,6,6,7],[0,1,0,7],[2,1,2,5],[2,6,2,7],[3,1,3,5],[3,6,3,7]]}
[null,"SDGs and Targets"]
[]
["Goal Number","Goal Aim",null,null,null,null,"Goal Targets"]
["Goal 1","End poverty in all its forms everywhere",null,null,null,null,"1.1 by 2030, eradicate extreme poverty for all people everywhere, currently measured as people living on less than $1.25 a day\n\n1.2 by 2030, reduce at least by half the proportion of men, women and children of all ages living in poverty in all its dimensions according to national definitions\n\n1.3 implement nationally appropriate social protection systems and measures for all, including floors, and by 2030 achieve substantial coverage of the poor and the vulnerable\n\n1.4 by 2030 ensure that all men and women, particularly the poor and the vulnerable, have equal rights to economic resources, as well as access to basic services, ownership, and control over land and other forms of property, inheritance, natural resources, appropriate new technology, and financial services including microfinance\n\n1.5 by 2030 build the resilience of the poor and those in vulnerable situations, and reduce their exposure and vulnerability to climate-related extreme events and other economic, social and environmental shocks and disasters\n\n1.a. ensure significant mobilization of resources from a variety of sources, including through enhanced development cooperation to provide adequate and predictable means for developing countries, in particular LDCs, to implement programmes and policies to end poverty in all its dimensions\n\n1.b create sound policy frameworks, at national, regional and international levels, based on pro-poor and gender-sensitive development strategies to support accelerated investments in poverty eradication actions"]
["Goal 2","End Hunger, achieve food security and adequate nutrition for all and promote sustainable agriculture",null,null,null,null,"2.1 by 2030 end hunger and ensure access by all people, in particular the poor and people in vulnerable situations including infants, to safe, nutritious and sufficient food all year round\n\n2.2 by 2030 end all forms of malnutrition, including achieving by 2025 the internationally agreed targets on stunting and wasting in children under five years of age, and address the nutritional needs of adolescent girls, pregnant and lactating women, and older persons\n\n2.3 by 2030 double the agricultural productivity and the incomes of small-scale food producers, particularly women, indigenous peoples, family farmers, pastoralists and fishers, including through secure and equal access to land, other productive resources and inputs, knowledge, financial services, markets, and opportunities for value addition and non-farm employment\n\n2.4 by 2030 ensure sustainable food production systems and implement resilient agricultural practices that increase productivity and production, that help maintain ecosystems, that strengthen capacity for adaptation to climate change, extreme weather, drought, flooding and other disasters, and that progressively improve land and soil quality\n\n2.5 by 2020 maintain genetic diversity of seeds, cultivated plants, farmed and domesticated animals and their related wild species, including through soundly managed and diversified seed and plant banks at national, regional and international levels, and ensure access to and fair and equitable sharing of benefits arising from the utilization of genetic resources and associated traditional knowledge as internationally agreed\n\n2.a increase investment, including through enhanced international cooperation, in rural infrastructure, agricultural research and extension services, technology development, and plant and livestock gene banks to enhance agricultural productive capacity in developing countries, in particular in least developed countries\n\n2.b. correct and prevent trade restrictions and distortions in world agricultural markets including by the parallel elimination of all forms of agricultural export subsidies and all export measures with equivalent effect, in accordance with the mandate of the Doha Development Round\n\n2.c. adopt measures to ensure the proper functioning of food commodity markets and their derivatives, and facilitate timely access to market information, including on food reserves, in order to help limit extreme food price volatility"]
["Goal 3","Attain healthy life for all at all ages",null,null,null,null,"3.1 by 2030 reduce the global maternal mortality ratio to less than 70 per 100,000 live births\n\n3.2 by 2030 end preventable deaths of newborns and under-five children\n\n3.3 by 2030 end the epidemics of AIDS, tuberculosis, malaria, and neglected tropical diseases and combat hepatitis, water-borne diseases, and other communicable diseases\n\n3.4 by 2030 reduce by one-third pre-mature mortality from non-communicable diseases (NCDs) through prevention and treatment, and promote mental health and wellbeing\n\n3.5 strengthen prevention and treatment of substance abuse, including narcotic drug abuse and harmful use of alcohol\n\n3.6 by 2020 halve global deaths and injuries from road traffic accidents\n\n3.7 by 2030 ensure universal access to sexual and reproductive health care services, including for family planning, information and education, and the integration of reproductive health into national strategies and programmes\n\n3.8 achieve universal health coverage (UHC), including financial risk protection, access to quality essential health care services, and access to safe, effective, quality, and affordable essential medicines and vaccines for all\n\n3.9 by 2030 substantially reduce the number of deaths and illnesses from hazardous chemicals and air, water, and soil pollution and contamination\n\n3.a strengthen implementation of the Framework Convention on Tobacco Control in all countries as appropriate\n\n3.b support research and development of vaccines and medicines for the communicable and non-communicable diseases that primarily affect developing countries, provide access to affordable essential medicines and vaccines, in accordance with the Doha Declaration which affirms the right of developing countries to use to the full the provisions in the TRIPS agreement regarding flexibilities to protect public health and, in particular, provide access to medicines for all\n\n3.c increase substantially health financing and the recruitment, development and training and retention of the health workforce in developing countries, especially in LDCs and SIDS\n\n3.d strengthen the capacity of all countries, particularly developing countries, for early warning, risk reduction, and management of national and global health risks"]
["Goal 4","Provide equitable and inclusive quality education and life long learning opportunities for all",null,null,null,null,"4.1 by 2030, ensure that all girls and boys complete free, equitable and quality primary and secondary education leading to relevant and effective learning outcomes\n\n4.2 by 2030 ensure that all girls and boys have access to quality early childhood development, care and pre-primary education so that they are ready for primary education\n\n4.3 by 2030 ensure equal access for all women and men to affordable quality technical, vocational and tertiary education, including university\n\n4.4 by 2030, increase by x% the number of youth and adults who have relevant skills, including technical and vocational skills, for employment, decent jobs and entrepreneurship\n\n4.5 by 2030, eliminate gender disparities in education and ensure equal access to all levels of education and vocational training for the vulnerable, including persons with disabilities, indigenous peoples, and children in vulnerable situations\n\n4.6 by 2030 ensure that all youth and at least x% of adults, both men and women, achieve literacy and numeracy\n\n4.7 by 2030 ensure all learners acquire knowledge and skills needed to promote sustainable development, including among others through education for sustainable development and sustainable lifestyles, human rights, gender equality, promotion of a culture of peace and non-violence, global citizenship, and appreciation of cultural diversity and of culture’s contribution to sustainable development\n\n4.a build and upgrade education facilities that are child, disability and gender sensitive and provide safe, non-violent, inclusive and effective learning environments for all\n\n4.b by 2020 expand by x% globally the number of scholarships for developing countries in particular LDCs, SIDS and African countries to enrol in higher education, including vocational training, ICT, technical, engineering and scientific programmes in developed countries and other developing countries\n\n4.c by 2030 increase by x% the supply of qualified teachers, including through international cooperation for teacher training in developing countries, especially LDCs and SIDS"]
["Goal 5","Attain Gender equality, empower women and girls everywhere",null,null,null,null,"5.1 end all forms of discrimination against all women and girls everywhere\n\n5.2 eliminate all forms of violence against all women and girls in public and private spheres, including trafficking and sexual and other types of exploitation\n\n5.3 eliminate all harmful practices, such as child, early and forced marriage and female genital mutilations\n\n5.4 recognize and value unpaid care and domestic work through the provision of public services, infrastructure and social protection policies, and the promotion of shared responsibility within the household and the family as nationally appropriate\n\n5.5 ensure women’s full and effective participation and equal opportunities for leadership at all levels of decision-making in political, economic, and public life\n\n5.6 ensure universal access to sexual and reproductive health and reproductive rights as agreed in accordance with the Programme of Action of the ICPD and the Beijing Platform for Action and the outcome documents of their review conferences\n\n5.a undertake reforms to give women equal rights to economic resources, as well as access to ownership and control over land and other forms of property, financial services, inheritance, and natural resources in accordance with national laws\n\n5.b enhance the use of enabling technologies, in particular ICT, to promote women’s empowerment\n\n5.c adopt and strengthen sound policies and enforceable legislation for the promotion of gender equality and the empowerment of all women and girls at all levels"]
["Goal 6","Secure water and sanitation for a sustainable world",null,null,null,null,"6.1 by 2030, achieve universal and equitable access to safe and affordable drinking water for all\n\n6.2 by 2030, achieve access to adequate and equitable sanitation and hygiene for all, and end open defecation, paying special attention to the needs of women and girls and those in vulnerable situations\n\n6.3 by 2030, improve water quality by reducing pollution, eliminating dumping and minimizing release of hazardous chemicals and materials, halving the proportion of untreated wastewater, and increasing recycling and safe reuse by x% globally\n\n6.4 by 2030, substantially increase water-use efficiency across all sectors and ensure sustainable withdrawals and supply of freshwater to address water scarcity, and substantially reduce the number of people suffering from water scarcity\n\n6.5 by 2030 implement integrated water resources management at all levels, including through transboundary cooperation as appropriate\n\n6.6 by 2020 protect and restore water-related ecosystems, including mountains, forests, wetlands, rivers, aquifers and lakes\n\n6.a by 2030, expand international cooperation and capacity-building support to developing countries in water and sanitation related activities and programmes, including water harvesting, desalination, water efficiency, wastewater treatment, recycling and reuse technologies\n\n6.b support and strengthen the participation of local communities for improving water and sanitation management"]
["Goal 7","Ensure access to affordable, sustainable and reliable modern energy services for all",null,null,null,null,"7.1 by 2030 ensure universal access to affordable, reliable, and modern energy services\n\n7.2 increase substantially the share of renewable energy in the global energy mix by 2030\n\n7.3 double the global rate of improvement in energy efficiency by 2030\n\n7.a by 2030 enhance international cooperation to facilitate access to clean energy research and technologies, including renewable energy, energy efficiency, and advanced and cleaner fossil fuel technologies, and promote investment in energy infrastructure and clean energy technologies\n\n7.b by 2030 expand infrastructure and upgrade technology for supplying modern and sustainable energy services for all in developing countries, particularly LDCs and SIDS"]
["Goal 8","Promote strong, inclusive and sustainable economic growth and decent work for all",null,null,null,null,"8.1 sustain per capita economic growth in accordance with national circumstances, and in particular at least 7% per annum GDP growth in the least-developed countries\n\n8.2 achieve higher levels of productivity of economies through diversification, technological upgrading and innovation, including through a focus on high value added and labour-intensive sectors\n\n8.3 promote development-oriented policies that support productive activities, decent job creation, entrepreneurship, creativity and innovation, and encourage formalization and growth of micro-, small- and medium-sized enterprises including through access to financial services\n\n8.4 improve progressively through 2030 global resource efficiency in consumption and production, and endeavour to decouple economic growth from environmental degradation in accordance with the 10-year framework of programmes on sustainable consumption and production with developed countries taking the lead\n\n8.5 by 2030 achieve full and productive employment and decent work for all women and men, including for young people and persons with disabilities, and equal pay for work of equal value\n\n8.6 by 2020 substantially reduce the proportion of youth not in employment, education or training\n\n8.7 take immediate and effective measures to secure the prohibition and elimination of the worst forms of child labour, eradicate forced labour, and by 2025 end child labour in all its forms including recruitment and use of child soldiers\n\n8.8 protect labour rights and promote safe and secure working environments of all workers, including migrant workers, particularly women migrants, and those in precarious employment\n\n8.9 by 2030 devise and implement policies to promote sustainable tourism which creates jobs, promotes local culture and products\n\n8.10 strengthen the capacity of domestic financial institutions to encourage and to expand access to banking, insurance and financial services for all\n\n8.a increase Aid for Trade support for developing countries, particularly LDCs, including through the Enhanced Integrated Framework for LDCs\n\n8.b by 2020 develop and operationalize a global strategy for youth employment and implement the ILO Global Jobs Pact"]
["Goal 9","Promote sustainable industrialization",null,null,null,null,"9.1 develop quality, reliable, sustainable and resilient infrastructure, including regional and trans-border infrastructure, to support economic development and human well-being, with a focus on affordable and equitable access for all\n\n9.2 promote inclusive and sustainable industrialization, and by 2030 raise significantly industry’s share of employment and GDP in line with national circumstances, and double its share in LDCs\n\n9.3 increase the access of small-scale industrial and other enterprises, particularly in developing countries, to financial services including affordable credit and their integration into value chains and markets\n\n9.4 by 2030 upgrade infrastructure and retrofit industries to make them sustainable, with increased resource use efficiency and greater adoption of clean and environmentally sound technologies and industrial processes, all countries taking action in accordance with their respective capabilities\n\n9.5 enhance scientific research, upgrade the technological capabilities of industrial sectors in all countries, particularly developing countries, including by 2030 encouraging innovation and increasing the number of R&D workers per one million people by x% and public and private R&D spending\n\n9.a facilitate sustainable and resilient infrastructure development in developing countries through enhanced financial, technological and technical support to African countries, LDCs, LLDCs and SIDS\n\n9.b support domestic technology development, research and innovation in developing countries including by ensuring a conducive policy environment for inter alia industrial diversification and value addition to commodities\n\n9.c significantly increase access to ICT and strive to provide universal and affordable access to internet in LDCs by 2020\n\n\n"]
["Goal 10","Reduce inequality within and among countries",null,null,null,null,"10.1 by 2030 progressively achieve and sustain income growth of the bottom 40% of the population at a rate higher than the national average\n\n10.2 by 2030 empower and promote the social, economic and political inclusion of all irrespective of age, sex, disability, race, ethnicity, origin, religion or economic or other status\n\n10.3 ensure equal opportunity and reduce inequalities of outcome, including through eliminating discriminatory laws, policies and practices and promoting appropriate legislation, policies and actions in this regard\n\n10.4 adopt policies especially fiscal, wage, and social protection policies and progressively achieve greater equality\n\n10.5 improve regulation and monitoring of global financial markets and institutions and strengthen implementation of such regulations\n\n10.6 ensure enhanced representation and voice of developing countries in decision making in global international economic and financial institutions in order to deliver more effective, credible, accountable and legitimate institutions\n\n10.7 facilitate orderly, safe, regular and responsible migration and mobility of people, including through implementation of planned and well-managed migration policies\n\n10.a implement the principle of special and differential treatment for developing countries, in particular least developed countries, in accordance with WTO agreements\n\n10.b encourage ODA and financial flows, including foreign direct investment, to states where the need is greatest, in particular LDCs, African countries, SIDS, and LLDCs, in accordance with their national plans and programmes\n\n10.c by 2030, reduce to less than 3% the transaction costs of migrant remittances and eliminate remittance corridors with costs higher than 5%"]
["Goal 11","Build inclusive, safe and sustainable cities and human settlements",null,null,null,null,"11.1 by 2030, ensure access for all to adequate, safe and affordable housing and basic services, and upgrade slums\n\n11.2 by 2030, provide access to safe, affordable, accessible and sustainable transport systems for all, improving road safety, notably by expanding public transport, with special attention to the needs of those in vulnerable situations, women, children, persons with disabilities and older persons\n\n11.3 by 2030 enhance inclusive and sustainable urbanization and capacities for participatory, integrated and sustainable human settlement planning and management in all countries\n\n11.4 strengthen efforts to protect and safeguard the world’s cultural and natural heritage\n\n11.5 by 2030 significantly reduce the number of deaths and the number of affected people and decrease by y% the economic losses relative to GDP caused by disasters, including water-related disasters, with the focus on protecting the poor and people in vulnerable situations\n\n11.6 by 2030, reduce the adverse per capita environmental impact of cities, including by paying special attention to air quality, municipal and other waste management\n\n11.7 by 2030, provide universal access to safe, inclusive and accessible, green and public spaces, particularly for women and children, older persons and persons with disabilities\n\n11.a support positive economic, social and environmental links between urban, peri-urban and rural areas by strengthening national and regional development planning\n\n11.b by 2020, increase by x% the number of cities and human settlements adopting and implementing integrated policies and plans towards inclusion, resource efficiency, mitigation and adaptation to climate change, resilience to disasters, develop and implement in line with the forthcoming Hyogo Framework holistic disaster risk management at all levels\n\n11.c support least developed countries, including through financial and technical assistance, for sustainable and resilient buildings utilizing local materials"]
["Goal 12","Promote sustainable consumption and production patterns",null,null,null,null,"12.1 implement the 10-Year Framework of Programmes on sustainable consumption and production (10YFP), all countries taking action, with developed countries taking the lead, taking into account the development and capabilities of developing countries\n\n12.2 by 2030 achieve sustainable management and efficient use of natural resources\n\n12.3 by 2030 halve per capita global food waste at the retail and consumer level, and reduce food losses along production and supply chains including post-harvest losses\n\n12.4 by 2020 achieve environmentally sound management of chemicals and all wastes throughout their life cycle in accordance with agreed international frameworks and significantly reduce their release to air, water and soil to minimize their adverse impacts on human health and the environment\n\n12.5 by 2030, substantially reduce waste generation through prevention, reduction, recycling, and reuse\n\n12.6 encourage companies, especially large and trans-national companies, to adopt sustainable practices and to integrate sustainability information into their reporting cycle\n\n12.7 promote public procurement practices that are sustainable in accordance with national policies and priorities\n\n12.8 by 2030 ensure that people everywhere have the relevant information and awareness for sustainable development and lifestyles in harmony with nature\n\n12.a support developing countries to strengthen their scientific and technological capacities to move towards more sustainable patterns of consumption and production\n\n12.b develop and implement tools to monitor sustainable development impacts for sustainable tourism which creates jobs, promotes local culture and products\n\n12.c rationalize inefficient fossil fuel subsidies that encourage wasteful consumption by removing market distortions, in accordance with national circumstances, including by restructuring taxation and phasing out those harmful subsidies, where they exist, to reflect their environmental impacts, taking fully into account the specific needs and conditions of developing countries and minimizing the possible adverse impacts on their development in a manner that protects the poor and the affected communities"]
["Goal 13","Promote actions at all levels to address climate change/build climate change goal based on COP 21 of the UNFCCC",null,null,null,null,"13.1 strengthen resilience and adaptive capacity to climate related hazards and natural disasters in all countries\n\n13.2 integrate climate change measures into national policies, strategies, and planning\n\n13.3 improve education, awareness raising and human and institutional capacity on climate change mitigation, adaptation, impact reduction, and early warning\n\n13.a implement the commitment undertaken by developed country Parties to the UNFCCC to a goal of mobilizing jointly USD100 billion annually by 2020 from all sources to address the needs of developing countries in the context of meaningful mitigation actions and transparency on implementation and fully operationalize the Green Climate Fund through its capitalization as soon as possible\n\n13.b Promote mechanisms for raising capacities for effective climate change related planning and management, in LDCs, including focusing on women, youth, local and marginalized communities"]
["Goal 14","Attain conservation and sustainable use of marine resources and seas",null,null,null,null,"14.1 by 2025, prevent and significantly reduce marine pollution of all kinds, particularly from land-based activities, including marine debris and nutrient pollution\n\n14.2 by 2020, sustainably manage and protect marine and coastal ecosystems to avoid significant adverse impacts, including by strengthening their resilience, and take action for their restoration, to achieve healthy and productive oceans\n\n14.3 minimize and address the impacts of ocean acidification, including through enhanced scientific cooperation at all levels\n\n14.4 by 2020, effectively regulate harvesting, and end overfishing, illegal, unreported and unregulated (IUU) fishing and destructive fishing practices and implement science-based management plans, to restore fish stocks in the shortest time feasible at least to levels that can produce maximum sustainable yield as determined by their biological characteristics\n\n14.5 by 2020, conserve at least 10 per cent of coastal and marine areas, consistent with national and international law and based on best available scientific information\n\n14.6 by 2020, prohibit certain forms of fisheries subsidies which contribute to overcapacity and overfishing, and eliminate subsidies that contribute to IUU fishing, and refrain from introducing new such subsidies, recognizing that appropriate and effective special and differential treatment for developing and least developed countries should be an integral part of the WTO fisheries subsidies negotiation *\n\n14.7 by 2030 increase the economic benefits to SIDS and LDCs from the sustainable use of marine resources, including through sustainable management of fisheries, aquaculture and tourism\n\n14.a increase scientific knowledge, develop research capacities and transfer marine technology taking into account the Intergovernmental Oceanographic Commission Criteria and Guidelines on the Transfer of Marine Technology, in order to improve ocean health and to enhance the contribution of marine biodiversity to the development of developing countries, in particular SIDS and LDCs\n\n14.b provide access of small-scale artisanal fishers to marine resources and markets\n\n14.c ensure the full implementation of international law, as reflected in UNCLOS for states parties to it, including, where applicable, existing regional and international regimes for the conservation and sustainable use of oceans and their resources by their parties"]
["Goal 15","Protect and restore terrestrial ecosystems and halt all biodiversity loss",null,null,null,null,"15.1 by 2020 ensure conservation, restoration and sustainable use of terrestrial and inland freshwater ecosystems and their services, in particular forests, wetlands, mountains and drylands, in line with obligations under international agreements\n\n15.2 by 2020, promote the implementation of sustainable management of all types of forests, halt deforestation, restore degraded forests, and increase afforestation and reforestation by x% globally\n\n15.3 by 2020, combat desertification, and restore degraded land and soil, including land affected by desertification, drought and floods, and strive to achieve a land-degradation neutral world\n\n15.4 by 2030 ensure the conservation of mountain ecosystems, including their biodiversity, to enhance their capacity to provide benefits which are essential for sustainable development\n\n15.5 take urgent and significant action to reduce degradation of natural habitat, halt the loss of biodiversity, and by 2020 protect and prevent the extinction of threatened species\n\n15.6 ensure fair and equitable sharing of the benefits arising from the utilization of genetic resources, and promote appropriate access to genetic resources\n\n15.7 take urgent action to end poaching and trafficking of protected species of flora and fauna, and address both demand and supply of illegal wildlife products\n\n15.8 by 2020 introduce measures to prevent the introduction and significantly reduce the impact of invasive alien species on land and water ecosystems, and control or eradicate the priority species\n\n15.9 by 2020, integrate ecosystems and biodiversity values into national and local planning, development processes and poverty reduction strategies, and accounts\n\n15.a mobilize and significantly increase from all sources financial resources to conserve and sustainably use biodiversity and ecosystems\n\n15.b mobilize significantly resources from all sources and at all levels to finance sustainable forest management, and provide adequate incentives to developing countries to advance sustainable forest management, including for conservation and reforestation\n\n15.c enhance global support to efforts to combat poaching and trafficking of protected species, including by increasing the capacity of local communities to pursue sustainable livelihood opportunities"]
["Goal 16","Achieve peaceful and inclusive societies, rue of law, effective and capable institutions",null,null,null,null,"16.1 significantly reduce all forms of violence and related death rates everywhere\n\n16.2 end abuse, exploitation, trafficking and all forms of violence and torture against children\n\n16.3 promote the rule of law at the national and international levels, and ensure equal access to justice for all\n\n16.4 by 2030 significantly reduce illicit financial and arms flows, strengthen recovery and return of stolen assets, and combat all forms of organized crime\n\n16.5 substantially reduce corruption and bribery in all its forms\n\n16.6 develop effective, accountable and transparent institutions at all levels\n\n16.7 ensure responsive, inclusive, participatory and representative decision-making at all levels\n\n16.8 broaden and strengthen the participation of developing countries in the institutions of global governance\n\n16.9 by 2030 provide legal identity for all including birth registration\n\n16.10 ensure public access to information and protect fundamental freedoms, in accordance with national legislation and international agreements\n\n16.a strengthen relevant national institutions, including through international cooperation, for building capacities at all levels, in particular in developing countries, for preventing violence and combating terrorism and crime\n\n16.b promote and enforce non-discriminatory laws and policies for sustainable development\n\n"]
["Goal 17","Strengthen and enhance the means of implementation and global partnerships for sustainable development",null,null,null,null,"Finance\n\n17.1 strengthen domestic resource mobilization, including through international support to developing countries to improve domestic capacity for tax and other revenue collection\n\n17.2 developed countries to implement fully their ODA commitments, including to provide 0.7% of GNI in ODA to developing countries of which 0.15-0.20% to least-developed countries\n\n17.3 mobilize additional financial resources for developing countries from multiple sources\n\n17.4 assist developing countries in attaining long-term debt sustainability through coordinated policies aimed at fostering debt financing, debt relief and debt restructuring, as appropriate, and address the external debt of highly indebted poor countries (HIPC) to reduce debt distress\n\n17.5 adopt and implement investment promotion regimes for LDCs\n\nTechnology\n\n17.6 enhance North-South, South-South and triangular regional and international cooperation on and access to science, technology and innovation, and enhance knowledge sharing on mutually agreed terms, including through improved coordination among existing mechanisms, particularly at UN level, and through a global technology facilitation mechanism when agreed\n\n17.7 promote development, transfer, dissemination and diffusion of environmentally sound technologies to developing countries on favourable terms, including on concessional and preferential terms, as mutually agreed\n\n17.8 fully operationalize the Technology Bank and STI (Science, Technology and Innovation) capacity building mechanism for LDCs by 2017, and enhance the use of enabling technologies in particular ICT\n\nCapacity building\n\n17.9 enhance international support for implementing effective and targeted capacity building in developing countries to support national plans to implement all sustainable development goals, including through North-South, South-South, and triangular cooperation\n\nTrade\n\n17.10 promote a universal, rules-based, open, non-discriminatory and equitable multilateral trading system under the WTO including through the conclusion of negotiations within its Doha Development Agenda\n\n17.11 increase significantly the exports of developing countries, in particular with a view to doubling the LDC share of global exports by 2020\n\n17.12 realize timely implementation of duty-free, quota-free market access on a lasting basis for all least developed countries consistent with WTO decisions, including through ensuring that preferential rules of origin applicable to imports from LDCs are transparent and simple, and contribute to facilitating market access\n\nSystemic issues\n\nPolicy and institutional coherence\n\n17.13 enhance global macroeconomic stability including through policy coordination and policy coherence\n\n17.14 enhance policy coherence for sustainable development\n\n17.15 respect each country’s policy space and leadership to establish and implement policies for poverty eradication and sustainable development\n\nMulti-stakeholder partnerships\n\n17.16 enhance the global partnership for sustainable development complemented by multi-stakeholder partnerships that mobilize and share knowledge, expertise, technologies and financial resources to support the achievement of sustainable development goals in all countries, particularly developing countries\n\n17.17 encourage and promote effective public, public-private, and civil society partnerships, building on the experience and resourcing strategies of partnerships\n\nData, monitoring and accountability\n\n17.18 by 2020, enhance capacity building support to developing countries, including for LDCs and SIDS, to increase significantly the availability of high-quality, timely and reliable data disaggregated by income, gender, age, race, ethnicity, migratory status, disability, geographic location and other characteristics relevant in national contexts\n\n17.19 by 2030, build on existing initiatives to develop measurements of progress on sustainable development that complement GDP, and support statistical capacity building in developing countries\n\n"]

{"sheet":"Instructions","index":2,"n_rows":65,"n_cols":2,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions"]
[]
[null,"Step wise instruction for users to fill the subsequent Tabs"]
[]
[null,"Important information to note: the steps below are for each intervention, NAMA implementor needs to collate the information from  each intervention"]
[]
[null,"Tab: Selection of indicators"]
[null,"Step 1: Identify all the positive and negative impacts of the intervention/NAMA and place all the identified impacts against the respective domains and indicator list. Mark the Column \"Selected\" as yes or no if the indicator is relevant to the intervention or not. You can identify the indicator also based on Relevance to SDG goals."]
[null,"Step 2: After placing the identified impacts against the respective indicators, provide justification for the each indicator and state whether this indicator will be selected or not. Select at least one indicator per domain and mark the last column as yes or no against the selected indicator (This is done to cross check the intervention tab)"]
[null,"Step 3: After step 3, follow the drop down list in column F \"Effect on indicator\" and classify the effect as Positive, Negative or Both. It is important for all Intervention Implementers to list the effects to the best possible way. Also, note: Negative impacts need to be mitigated and monitored (unless a strong argument is given for non monitoring)"]
[null,"Replicate the above steps if the NAMA has more than 1 intervention"]
[]
[null,"Tab: Intervention"]
[null,"Step 1: Based on Indicator selection in the pervious tab, select the number of parameters, the parameter type and effect from the drop down list for each indicator being monitored. Put NA (Not Applicable) for indicators which are not being monitored in column number of parameters selected. Also note that if the Nama implementor does not find a suitable parameter from the drop down list, they may add the relevant parameter in the column \"other parameters\"."]
[null,"Step 2: For the parameter identified, please indicate the measurement value  in column H ( for example whether it will be measured via  a literature value or through a survey, etc etc). Intervention Implementer can define the best possible way of measurement."]
[null,"Step 3: Indicate in column I if the indicated measurement way is a direct or an indirect way via the drop down list. Implementers may note that the way defined in this column will be observed during both the baseline and project. In case there is a change in the project measurement type, Implementers should specify that by adding a column next to project values and indicate the reason for this change."]
[null,"Step 5: Each implementor needs to  put the target value to be achieved for each parameter/indicator in column K. Target value will be defined by the NAMA developer"]
[null,"Step 6: Indicate the unit of measurement of each parameter being monitored in column M"]
[null,"Step 7: Calculation of NAI's - Once the implementor fills in baseline, target values, column N automatically calculates the NAIs estimated. Ex-post, once the implementer fills in the intervention value monitored, column O will automatically calculate the NAIs monitored. NAIs estimated and NAIs monitored show the success of the NAMA. "]
[null,"Replicate the above steps and add more sheets; if the NAMA has more than 1 intervention"]
[]
[null,"Tab: MRV"]
[null,"Step 1: Replicate the MRV box for each parameter being monitored."]
[null,"Step 2: Define in details the way of monitoring, who will be monitoring (it can be the Intervention implemeter) and how it will be monitored. In case of indirect measurement, please indicate the formula being used for calculations."]
[null,"Step3: Define in details the QC procedures to be followed for each parameter."]
[null,"Step 4: Link the baseline values and project values to the monitoring sheet."]
[null,"Replicate the above steps and add more sheets; if the NAMA has more than 1 intervention"]
[]
[null,"Tab: Monitoring"]
[null,"Step 1: Classify all the information needed for one intervention type such as households in intervention, number of women per households etc."]
[null,"Step 2: In case of any formulas being used, please put the formulae's into the respective cell and define the values in another column"]
[null,"Replicate the above steps and add more sheets; if the NAMA has more than 1 intervention"]
[]
[]
[null,"Guidance on monitoring"]
[]
[]
[null,"Important points to be noted:"]
[null,"Monitoring needs to be done at each intervention level. It will be intervention implementers' responsibility to assign the duties for monitoring and reporting in the MRV structure."]
[]
[null,"Surveys can be both indirect and direct way of monitoring, and Implementation agency will define how the survey will be used. Implementation agency will also draft the household survey form for each intervention. In case the implementation agency uses the census, they need the define the parameters which are taken from census and  justify the frequency defined for monitoring."]
[]
[null,"Monitoring frequency: fixed at 3 years for all the parameters."]
[]
[null,"QA/QC procedures"]
[null,"The NAMA's implementer shall establish a QA/QC system to ensure the good quality of data. The quality control (QC) procedures is used for compiling, developing and maintaining the required datasets and the quality assurance (QA) procedures for ensuring the overall quality of the datasets by assessing the conformity and the effectiveness of the QC system, based on data quality objectives and general provisions"]
[null,"For the QA/QC process, the following data quality objectives should be taken into account:"]
[null,"Relevance: collect data and information required for the establishment of baseline and mainly activity data and information applicable for the assessment of impacts"]
[null,"Completeness: include all relevant activity data and information to produce \"true and fair\" representative data"]
[null,"Consistency: present the same data in the same definition/scope/format and make the datasets compatible with other related data"]
[null,"Credibility: identify and utilize authoritative data sources. Collected data/information should always reference their sources (examples of sources: data providers, NAMA's implementer, government authorities, peer-reviewed international statistics documents, research institutes, individual academic research work institutions, technology supplier)"]
[null,"Correctness: utilize the most recent data available in a sector in order to reflect the current economic and technological practices (one to 3 years before the submission of the NAMA)."]
[null,"Accuracy: reduce errors and uncertainties as far as it is practical and cost-effective"]
[null,"Objectivity: avoid biased, prejudiced and partial information."]
[null,"Conservativeness: ensure to use a conservative approach in case of missing or incomplete data"]
[null,"Transparency: disclose sufficient and appropriate data and processes to allow monitoring of the quality of the compiled datasets"]
[null,"Traceability: document all data sources"]
[]
[null,"Sampling guidance for surveys"]
[null,"For monitoring parameters which are determined using a survey, the following guidance should be used:"]
[null,"The survey should be conducted following simple random sampling approach and the minimum sample size should be determined as per the guidelines below:"]
[null,"Project target population < 300: Minimum sampling size 30 or population size (which ever is the smallest)"]
[null,"Project target population 300 to 1000: Minimum sample size 10% of groupe size"]
[null,"Project target population > 1000: Minimum sample size 100"]

{"sheet":"Selection of indicators","index":3,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[30,1,33,1],[0,1,0,8],[2,2,2,8],[6,1,11,1],[12,1,21,1],[22,1,29,1]]}
[null,"Selection of indicators"]
[]
[null,"Intervention Name",{"$f":"Introduction!B52","v":"Implementation of Alternate Wetting and Drying (AWD) in Rice Cultivation at Irrigated Rice Fields"}]
[]
[]
[null,"Domain","Indicator","Relevance to SDGs and Targets","Selected (Yes/No)","Identified Impacts","Explanation of Chosen Indicator","Effect on Indicator","Monitoring done (Yes/No)"]
[null,"Environment","Air pollution/quality","Goal 11, Target 11.6",null,null,null,"Positive","Yes"]
[null,null,"Water pollution/quality","Goal 6, Target 6.6\nGoal 11, Target 11.6\nGoal 12, Target 12.4","Yes","Increased water savings","AWD leads to sognificant water savings as a result of improved irrigation ","Positive","No"]
[null,null,"Soil pollution/quality","Goal 2, Target 2.4\nGoal 11, Target 11.6\nGoal 12, Target 12.4","Yes","Improved soil quality","AWD involves periodic aeration of the soil which results in higher zinc availability, as well as increased plant root anchorage and lodging resistance.","Positive","No"]
[null,null,"Others (Noise/visibility)","Goal 11, Target 11.6"]
[null,null,"Biodiversity and ecosystem balance","Goal 14, All Targets\nGoal 15, All Targets"]
[]
[null,"Social","Health ","Goal 3, All Targets"]
[null,null,"Livelihood of poor, poverty alleviation, peace","Goal 1, All Targets\nGoal 2, Target 2.1\nGoal 16, Target 16.1","Yes","Provide livelihood for poor/poverty alleviation.\nDecrease conflicts among farmers","Water savings from the implementation of AWD results in increased total irrigated land area. As a result, more farmers and farm helpers are required, providing additional livelihood for the poor farming communities;\nBecause of the availability of more irrigation water for downstream farmers due to AWD, irrigation conflicts between upstream-downstream farming communities are decreased.","Positive","No"]
[null,null,"Affordability of electricity","Goal 7, Targets 7.1"]
[null,null,"Access to sanitation and clean drinking water","Goal 6,  Tagets 6.1, 6.2, 6.4, 6.5"]
[null,null,"Food security (Access to land and sustainable agriculture)","Goal 2, All Targets\nGoal 12, Target 12.3","Yes","Increase in rice production.\nIncrease in irrigated land","Water savings from the implementation of AWD results in increased total irrigated land area. Proportionately, increase in total number of rice fields results in the increase in rice yield.","Positive","Yes"]
[null,null,"Quality of employment","Goal 8, Targets 8.2, 8.3, 8.5, 8.6, 8.7, 8.8"]
[null,null,"Time savings/time availability due to project","Goal 1"]
[null,null,"No child labour","Goal 8, Target 8.6"]
[null,null,"Provides vulnerable groups access to local resources and services","Goal 6, Targets 6.4, 6.5, 6.6, 6.a, 6.b","Yes","Increase access to water resources","AWD is a water management practice in rice cultivation promoting the efficient use of water resources. This provides vulnerable groups access to water resources and services which were not previously available to them, resulting in increased total irrigated land area.","Positive","Yes"]
[]
[null,"Growth and Development","Access to clean and sustainable energy","Goal 7, Targets 7.1, 7.2, 7.3\n"]
[null,null,"Education","Goal 4, All Targets",null,"Increased capacity for growing alternative crops","The AMIA will allow a large number of farmers to gain the necessary skills for growing alternative crops and practice alternative cropping.","Positive","Yes"]
[null,null,"Empowerment of women","Goal 4, Targets 4.3, 4.6\nGoal 5, All Targets "]
[null,null,"Access to sustainable technology","Goal 4, Target 4.3\nGoal 7, Targets 7a, 7b\nGoal 9, Target 9b","Yes","Access to sustainable technology","The AMIA implementer will be providing the required capacity-building for the implementation of the AWD nationwide through direct interaction with the farmers and IAs. Being the country's authority on rice research, participating farmers and IAs will have the opprotunity to access other available sustainable technologies from PhilRice, such as variety development, pest and nutrient management, devising decision support tools, water harvesting and conservation, diversified/integrated farming, area mapping, and vulnerability studies.","Positive","Yes"]
[null,null,"Energy security","Goal 7, Target 7.1, 7.2, 7.3"]
[null,null,"Capacity-building","Goal 4, Target 4.3, 4.5\nGoal 6, Target 6.a","Yes","Knowhow transfer","The AMIA implementer will provide proper training and knowhow transfer of AWD implementation to the irrigation officers, irrigators associations and individual farmers.","Positive","Yes"]
[null,null,"Equality (quality of jobs given, job conditions for men/women)","Goal 4, Targets 4.1, 4.2, 4.3, 4.7\nGoal 5, All Targets\nGoal 10, Target 10.4"]
[]
[null,"Economic","Income generation/expenditure reduction/Balance of payments","Goal 8, Targets 8.1, 8.2, 8.3, 8.4 \nGoal 10, Target 10.1","Yes","Increased income for farmers.\nIncreased collection of ISF","Increased income for the farmers as a result of the lower rice production cost (ISF);\nIncreased income for the NIA and IAs as a result of increased collection rate of the ISF. It is expected that more farmers would be willing to pay the ISF because of better satisfaction with irrigation services.","Positive","Yes"]
[null,null,"Asset accumulation and investments","Goal 7, Targets 7a, 7b\nGoal 9, All Targets\nGoal 17"]
[null,null,"Job Creation (number of men and women employed)","Goal 8, All Targets","Yes","New jobs created","Water savings from the implementation of AWD results in increased total irrigated land area. As a result, more farmers and farm helpers are required, providing more jobs.","Positive","No"]
[null,null,null,null,null,null,"\"\"","\"\""]

{"sheet":"Intervention 1","index":4,"n_rows":67,"n_cols":16,"rows_kept":67,"cut":false,"hidden":false,"merged":[[17,1,33,1],[25,3,26,3],[29,2,30,2],[27,2,28,2],[25,2,26,2],[23,2,24,2],[17,3,18,3],[19,3,20,3],[17,2,18,2],[21,2,22,2],[29,3,30,3],[19,2,20,2],[1,3,1,7],[4,1,5,1],[4,2,5,2],[4,7,5,7],[4,3,4,6],[6,1,16,1],[6,2,7,2],[8,2,9,2],[10,2,11,2],[12,2,13,2],[34,1,48,1],[49,1,55,1],[36,2,37,2],[38,2,39,2],[40,2,41,2],[49,2,50,2],[51,2,52,2],[44,2,45,2],[34,2,35,2],[46,2,47,2],[42,2,43,2],[4,8,5,8],[4,19,5,19],[4,20,5,20],[44,3,45,3],[27,3,28,3],[36,3,37,3],[38,3,39,3],[40,3,41,3],[10,3,11,3],[12,3,13,3],[6,3,7,3],[8,3,9,3],[42,3,43,3],[21,3,22,3],[34,3,35,3],[23,3,24,3],[4,21,5,21],[4,9,5,9],[4,13,5,13],[4,11,5,11],[4,12,5,12],[4,18,5,18],[4,14,5,14],[4,15,5,15],[55,11,55,12],[48,11,48,12],[14,2,15,2],[14,3,15,3],[31,2,32,2],[31,3,32,3],[49,3,50,3],[51,3,52,3],[33,11,33,12],[46,3,47,3],[53,2,54,2],[53,3,54,3]]}
[]
[null,null,"Intervention Name",{"$f":"Introduction!B52","v":"Implementation of Alternate Wetting and Drying (AWD) in Rice Cultivation at Irrigated Rice Fields"}]
[]
[]
[null,"Domain","Indicator","Parameter Selection",null,null,null,"Measurement value","Measurement type","Baseline Value",null,"Intervention Value monitored (ex-post)","Unit","NAIs estimated      (ex-ante) ","NAIs monitored          (ex-post)","Evaluation of     Project Success"]
[null,null,null,"Number of parameters selected per indicator","Parameter name","Other Parameters","Effect",null,null,null,"Target value estimated (ex-ante) "]
[" ","Environment","Air pollution/quality",null,null,null,"+"]
[]
[null,null,"Water pollution/quality",null,null,null,"+"]
[]
[null,null,"Soil pollution/quality",null,null,null,"+"]
[]
[null,null,"Others (noise/visibility)"]
[]
[null,null,"Biodiversity and Ecosystem balance"]
[]
[]
[null,"Social","Health "]
[]
[null,null,"Livelihood of poor, poverty alleviation, peace"]
[]
[null,null,"Affordability of electricity"]
[]
[null,null,"Access to Sanitation and clean drinking water"]
[]
[null,null,"Food security (Access to land and sustainable agriculture)",2,"Rice Production",null,"+","National values","Indirect",18032525,{"$f":"J26+(13396483*0.05)","v":18702349.149999999},{"$f":"J26+(13396483*0.05)","v":18702349.149999999},"tons",{"$f":"IF(J26=0,((K26-J26)/K26),IF(G26=\"+\",(K26-J26)/J26,(J26-K26)/J26))","v":3.7145333224271063E-2},{"$f":"IF(J26=0,(((L26-J26)/L26)+(L26-K26)/K26),IF(G26=\"+\",(L26-J26)/J26,(J26-L26)/J26))","v":3.7145333224271063E-2},{"$f":"O26/N26","v":1}]
[null,null,null,null,"Harvested Land Area",null,"+","National values","Indirect",4690061,{"$f":"J27+(750000*0.3)","v":4915061},{"$f":"J27+(750000*0.3)","v":4915061},"ha/yr",{"$f":"IF(J27=0,((K27-J27)/K27),IF(G27=\"+\",(K27-J27)/J27,(J27-K27)/J27))","v":4.7973789679921004E-2},{"$f":"IF(J27=0,(((L27-J27)/L27)+(L27-K27)/K27),IF(G27=\"+\",(L27-J27)/J27,(J27-L27)/J27))","v":4.7973789679921004E-2},{"$f":"O27/N27","v":1}]
[null,null,"Quality of employment"]
[]
[null,null,"Time savings/time availability due to project"]
[]
[null,null,"Provides vulnerable groups access to local resources and services",1,"Harvested Land Area",null,"+","National values","Indirect",4690061,{"$f":"J32+(750000*0.3)","v":4915061},{"$f":"J32+(750000*0.3)","v":4915061},"ha/yr",{"$f":"IF(J32=0,((K32-J32)/K32),IF(G32=\"+\",(K32-J32)/J32,(J32-K32)/J32))","v":4.7973789679921004E-2},{"$f":"IF(J32=0,(((L32-J32)/L32)+(L32-K32)/K32),IF(G32=\"+\",(L32-J32)/J32,(J32-L32)/J32))","v":4.7973789679921004E-2},{"$f":"O32/N32","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Domain Average",null,{"$f":"AVERAGE(N18:N33)","v":4.4364304194704357E-2},{"$f":"AVERAGE(O18:O33)","v":4.4364304194704357E-2},{"$f":"AVERAGE(P18:P33)","v":1}]
[null,"Growth and Development","Access to clean and sustainable energy"]
[]
[null,null,"Education",1,"Farmers who have Received Training on Alternative Cropping and Practice it",null,"+","Area over which alternative cropping is practiced","Direct",0,750000,750000,"ha",{"$f":"IF(J37=0,((K37-J37)/K37),IF(G37=\"+\",(K37-J37)/J37,(J37-K37)/J37))","v":1},{"$f":"IF(J37=0,(((L37-J37)/L37)+(L37-K37)/K37),IF(G37=\"+\",(L37-J37)/J37,(J37-L37)/J37))","v":1},{"$f":"O37/N37","v":1}]
[]
[null,null,"Empowerment of women"]
[]
[null,null,"Access to sustainable technology, Capacity development",1,"Additional Services",null,"+","Area over which AWD is practiced","Direct",0,750000,750000,"ha",{"$f":"IF(J41=0,((K41-J41)/K41),IF(G41=\"+\",(K41-J41)/J41,(J41-K41)/J41))","v":1},{"$f":"IF(J41=0,(((L41-J41)/L41)+(L41-K41)/K41),IF(G41=\"+\",(L41-J41)/J41,(J41-L41)/J41))","v":1},{"$f":"O41/N41","v":1}]
[]
[null,null,"Energy security"]
[]
[null,null,"Capacity building",1,"Trainings",null,"+","Number of irrigation officers who have been trained","Direct",0,150,150,"Persons",{"$f":"IF(J45=0,((K45-J45)/K45),IF(G45=\"+\",(K45-J45)/J45,(J45-K45)/J45))","v":1},{"$f":"IF(J45=0,(((L45-J45)/L45)+(L45-K45)/K45),IF(G45=\"+\",(L45-J45)/J45,(J45-L45)/J45))","v":1},{"$f":"O45/N45","v":1}]
[]
[null,null,"Equality (quality of jobs given, job condition for men/women)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Domain Average",null,{"$f":"AVERAGE(N35:N48)","v":1},{"$f":"AVERAGE(O35:O48)","v":1},{"$f":"AVERAGE(P35:P48)","v":1}]
[null,"Economic","Income generation/expenditure reduction/Balance of payments",1,"ISF",null,null,"ISF per ha","Direct",4250,3400,3400,"₧/ha/season",{"$f":"IF(J50=0,((K50-J50)/K50),IF(G50=\"+\",(K50-J50)/J50,(J50-K50)/J50))","v":0.2},{"$f":"IF(J50=0,(((L50-J50)/L50)+(L50-K50)/K50),IF(G50=\"+\",(L50-J50)/J50,(J50-L50)/J50))","v":0.2},{"$f":"O50/N50","v":1}]
[null,null,null,null,"ISF collection percentage",null,"+","Percentage of ISF collection","Direct",70,100,100,"Percentage",{"$f":"IF(J51=0,((K51-J51)/K51),IF(G51=\"+\",(K51-J51)/J51,(J51-K51)/J51))","v":0.42857142857142855},{"$f":"IF(J51=0,(((L51-J51)/L51)+(L51-K51)/K51),IF(G51=\"+\",(L51-J51)/J51,(J51-L51)/J51))","v":0.42857142857142855},{"$f":"O51/N51","v":1}]
[null,null,"Asset accumulation and investments"]
[]
[null,null,"Job Creation (number of men and women employed)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Domain Average",null,{"$f":"AVERAGE(N50:N55)","v":0.31428571428571428},{"$f":"AVERAGE(O50:O55)","v":0.31428571428571428},{"$f":"AVERAGE(P50:P55)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL AVERAGE",{"$f":"AVERAGE(N34,N49,N56)","v":0.45288333949347287},{"$f":"AVERAGE(O34,O49,O56)","v":0.45288333949347287},1]
[]
[]
[]
[]
[null,null,"NAI","positive","negative"]
[null,null,"Environment",{"$f":"SUMIF(G7:G17,\"+\",N7:N17)","v":0},{"$f":"SUMIF(G7:G17,\"-\",N7:N17)","v":0}]
[null,null,"Social",{"$f":"SUMIF(G18:G31,\"+\",N18:N31)","v":8.5119122904192074E-2},{"$f":"SUMIF(G18:G25,\"-\",N18:N30)","v":0}]
[null,null,"Growth and Development",{"$f":"SUMIF(G35:G49,\"+\",N35:N49)","v":3},{"$f":"SUMIF(G35:G49,\"-\",N35:N49)","v":0}]
[null,null,"Economic",{"$f":"SUMIF(G50:G56,\"+\",N50:N56)","v":0.42857142857142855},{"$f":"SUMIF(G50:G56,\"-\",N50:N56)","v":0}]
[null,null,"Total",{"$f":"SUM(D63:D66)","v":3.5136905514756203},{"$f":"SUM(E63:E66)","v":0}]

{"sheet":"MRV_Interv1","index":5,"n_rows":131,"n_cols":4,"rows_kept":131,"cut":false,"hidden":false,"merged":[[1,3,1,4],[33,2,33,3],[34,2,34,3],[35,2,35,3],[40,2,40,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[25,2,25,3],[32,2,32,3],[62,2,62,3],[4,2,4,3],[6,2,6,3],[11,2,11,3],[7,2,7,3],[5,2,5,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[55,2,55,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[85,2,85,3],[105,2,105,3],[91,2,91,3],[92,2,92,3],[93,2,93,3],[94,2,94,3],[99,2,99,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[70,2,70,3],[77,2,77,3],[107,2,107,3],[106,2,106,3],[128,2,128,3],[108,2,108,3],[113,2,113,3],[120,2,120,3],[121,2,121,3],[122,2,122,3],[123,2,123,3]]}
[]
[null,null,"Intervention Name",{"$f":"Introduction!B52","v":"Implementation of Alternate Wetting and Drying (AWD) in Rice Cultivation at Irrigated Rice Fields"}]
[]
[null,"Serial number",1]
[null,"Indicator Name",{"$f":"'Selection of indicators'!C7","v":"Air pollution/quality"}]
[null,"Domain","Environment"]
[null,"Parameter Name",{"$f":"'Intervention 1'!E7","v":0}]
[null,"Baseline Value",{"$f":"'Intervention 1'!J7","v":0}]
[null,"Way of monitoring","How","Calculated using national values for the total irrigated land area (hectares) and emission factors from \"Standardized Baseline - Methane emissions from rice cultivation in the Republic of the Philippines\""]
[null,null,"Frequency","3 years"]
[null,null,"By whom","NAMA Implementer"]
[null,"Project Value",{"$f":"'Intervention 1'!L7","v":0}]
[null,"QA/QC procedures"]
[null,null,"QC check done","NAMA Implementer"]
[]
[]
[null,"Serial number",1]
[null,"Indicator Name",{"$f":"'Selection of indicators'!C17","v":"Food security (Access to land and sustainable agriculture)"}]
[null,"Domain","Social"]
[null,"Parameter Name",{"$f":"'Intervention 1'!E26","v":"Rice Production"}]
[null,"Baseline Value",{"$f":"'Intervention 1'!J26","v":18032525}]
[null,"Unit",{"$f":"'Intervention 1'!M26","v":"tons"}]
[null,"Way of monitoring","How","Obtained from national rice statistics values"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","AMIA Implementer"]
[null,"Project Value",{"$f":"'Intervention 1'!K26","v":18702349.149999999}]
[null,"QA/QC procedures"]
[null,null,"QC check done","AMIA Implementer"]
[]
[]
[]
[null,"Serial number",2]
[null,"Indicator Name",{"$f":"'Selection of indicators'!C17","v":"Food security (Access to land and sustainable agriculture)"}]
[null,"Domain","Social"]
[null,"Parameter Name",{"$f":"'Intervention 1'!E27","v":"Harvested Land Area"}]
[null,"Baseline Value",{"$f":"'Intervention 1'!J27","v":4690061}]
[null,"Unit",{"$f":"'Intervention 1'!M27","v":"ha/yr"}]
[null,"Way of monitoring","How","Obtained from national rice statistics values"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","AMIA Implementer"]
[null,"Project Value",{"$f":"'Intervention 1'!K27","v":4915061}]
[null,"QA/QC procedures"]
[null,null,"QC check done","AMIA Implementer"]
[]
[]
[]
[null,"Serial number",3]
[null,"Indicator Name",{"$f":"'Selection of indicators'!C21","v":"Provides vulnerable groups access to local resources and services"}]
[null,"Domain","Social"]
[null,"Parameter Name",{"$f":"'Intervention 1'!E32","v":"Harvested Land Area"}]
[null,"Baseline Value",{"$f":"'Intervention 1'!J32","v":4690061}]
[null,"Unit ",{"$f":"'Intervention 1'!M32","v":"ha/yr"}]
[null,"Way of monitoring","How","Obtained from national rice statistics values"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","AMIA Implementer"]
[null,"Project Value",{"$f":"'Intervention 1'!K32","v":4915061}]
[null,"QA/QC procedures"]
[null,null,"QC check done","AMIA Implementer"]
[]
[]
[]
[null,"Serial number",4]
[null,"Indicator Name",{"$f":"'Selection of indicators'!C26","v":"Access to sustainable technology"}]
[null,"Domain","Growth and Development"]
[null,"Parameter Name",{"$f":"'Intervention 1'!E41","v":"Additional Services"}]
[null,"Baseline Value",{"$f":"'Intervention 1'!J41","v":0}]
[null,"Unit","Persons"]
[null,"Way of monitoring","How","Obtained from national rice statistics values"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","AMIA Implementer"]
[null,"Project Value",{"$f":"'Intervention 1'!L41","v":750000}]
[null,"QA/QC procedures"]
[null,null,"QC check done","AMIA Implementer"]
[]
[]
[]
[null,"Serial number",5]
[null,"Indicator Name",{"$f":"'Selection of indicators'!C28","v":"Capacity-building"}]
[null,"Domain","Growth and Development"]
[null,"Parameter Name",{"$f":"'Intervention 1'!H45","v":"Number of irrigation officers who have been trained"}]
[null,"Baseline Value",{"$f":"'Intervention 1'!J45","v":0}]
[null,"Unit",{"$f":"'Intervention 1'!M45","v":"Persons"}]
[null,"Way of monitoring","How","AMIA Implementer"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","AMIA Implementer"]
[null,"Project Value",{"$f":"'Intervention 1'!L45","v":150}]
[null,"QA/QC procedures"]
[null,null,"QC check done","AMIA Implementer"]
[]
[]
[null,"Serial number",6]
[null,"Indicator Name",{"$f":"'Intervention 1'!C37","v":"Education"}]
[null,"Domain",{"$f":"'Intervention 1'!B35","v":"Growth and Development"}]
[null,"Parameter Name",{"$f":"'Intervention 1'!E37","v":"Farmers who have Received Training on Alternative Cropping and Practice it"}]
[null,"Baseline Value",{"$f":"'Intervention 1'!J37","v":0}]
[null,"Unit","Persons"]
[null,"Way of monitoring","How","AMIA Implementer"]
[null,null,"Frequency","Annual"]
[null,null,"By whom","AMIA Implementer"]
[null,"Project Value",{"$f":"'Intervention 1'!K37","v":750000}]
[null,"QA/QC procedures"]
[null,null,"QC check done","AMIA Implementer"]
[]
[]
[null,"Serial number",7]
[null,"Indicator Name",{"$f":"'Selection of indicators'!C31","v":"Income generation/expenditure reduction/Balance of payments"}]
[null,"Domain","Economic"]
[null,"Parameter Name",{"$f":"'Intervention 1'!H50","v":"ISF per ha"}]
[null,"Baseline Value",{"$f":"'Intervention 1'!J50","v":4250}]
[null,"Unit",{"$f":"'Intervention 1'!M50","v":"₧/ha/season"}]
[null,"Way of monitoring","How","NIA ISF approved/published values"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","AMIA Implementer"]
[null,"Project Value",{"$f":"'Intervention 1'!K50","v":3400}]
[null,"QA/QC procedures"]
[null,null,"QC check done","AMIA Implementer"]
[]
[]
[]
[null,"Serial number",8]
[null,"Indicator Name",{"$f":"'Selection of indicators'!C31","v":"Income generation/expenditure reduction/Balance of payments"}]
[null,"Domain","Economic"]
[null,"Parameter Name",{"$f":"'Intervention 1'!H51","v":"Percentage of ISF collection"}]
[null,"Baseline Value",{"$f":"'Intervention 1'!J51","v":70}]
[null,"Unit",{"$f":"'Intervention 1'!M51","v":"Percentage"}]
[null,"Way of monitoring","How","NIA Statistics"]
[null,null,"Frequency","3 years"]
[null,null,"By whom","NIA"]
[null,"Project Value",{"$f":"'Intervention 1'!L51","v":100}]
[null,"QA/QC procedures"]
[null,null,"QC check done","NAMA Implementer"]

{"sheet":"Monitoring sheet","index":6,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,15],[3,2,3,6],[10,4,10,8]]}
[null,"Calculations & Monitoring"]
[]
[]
[null,"Intervention Name",{"$f":"Introduction!B52","v":"Implementation of Alternate Wetting and Drying (AWD) in Rice Cultivation at Irrigated Rice Fields"}]
[]
[]
[null,"Villages per intervention"]
[null,"Number of households per intervention"]
[null,"Number of women users"]
[]
[null,"Parameter","Unit","Pre-Project","Project"]
[null,null,null,"Baseline value","Year1","Intervention value monitored","Year2","Intervention value monitored","Year3"]
[1,{"$f":"'Intervention 1'!E26","v":"Rice Production"},{"$f":"'Intervention 1'!M26","v":"tons"},{"$f":"'Intervention 1'!J26","v":18032525}]
[2,{"$f":"'Intervention 1'!E27","v":"Harvested Land Area"},{"$f":"'Intervention 1'!M27","v":"ha/yr"},{"$f":"'Intervention 1'!J27","v":4690061}]
[3,{"$f":"'Intervention 1'!E37","v":"Farmers who have Received Training on Alternative Cropping and Practice it"},"Persons",{"$f":"'Intervention 1'!J41","v":0}]
[4,{"$f":"'Intervention 1'!E45","v":"Trainings"},{"$f":"'Intervention 1'!M45","v":"Persons"},{"$f":"'Intervention 1'!J45","v":0}]
[5,{"$f":"'Intervention 1'!E50","v":"ISF"},{"$f":"'Intervention 1'!M50","v":"₧/ha/season"},{"$f":"'Intervention 1'!J50","v":4250}]
[6,{"$f":"'Intervention 1'!E51","v":"ISF collection percentage"},{"$f":"'Intervention 1'!M51","v":"Percentage"},{"$f":"'Intervention 1'!J51","v":70}]
[7,{"$f":"'Intervention 1'!H41","v":"Area over which AWD is practiced"},"ha",{"$f":"'Intervention 1'!J37","v":0}]
[8]
[9]
[10]
[11]
[12]
[13]
[14]

{"sheet":"Data Ranges","index":7,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Effect on indicator","Number of parameters chosen","Effect","Air Quality",null,"Water Quality","Soil Quality","Other pollutants","Biodiversity and ecosystem balance"]
["Positive","NA","+","SOx (Sulphur oxide)",null,"BOD","Levels of Lead","Reduction in noise levels","Number of threatened species/habitat"]
["Negative",1,"-","NOx (nitrous oxide)",null,"COD","Mercury","Reduction in waste discharges","Addition of new gene pool"]
["Both",2,null,"Ozone",null,"Coliforms ","Cadmium","Increased visibility due to low SPM","Types of crops/species"]
[null,3,null,"Lead",null,"Improved wastewater management system","Soil erosion","Other (Please specify)","Other (Please specify)"]
[null,"More than 3",null,"SPM (Suspended Particulate Matter)",null,"Water Savings","Indirect-wood consumption"]
[null,null,null,"CFC's",null,"New safe and reliable water ditribution","Production and use of compost"]
[null,null,null,"VOC (volatile organic compound)",null,"Purification/sterilization and cleaning of water","Manure nutrient"]
[null,null,null,"Fly Ash",null,"Mercury","Other (Please specify)"]
[null,null,null,"Odour",null,"Lead"]
[null,null,null,"Dust",null,"Other (Please specify)"]
[null,null,null,"PM 10, 25"]
[null,null,null,"Number or share (%) of households burning waste"]
[null,null,null,"Other (Please specify)"]
[]
[]
[]
[]
[]
["Health condition","Affordability of electricity","Livelihood of poor","Access to sanitation","Food security","Quality of employment","Time","Access to clean energy","Education","Empowerment of women","Access to sustainable technology","Energy security","Capacity building"]
["Decrease in disease prevelance","cost per unit of energy","% of people having access to modern energy and facility (including electricity, water, transport, modern resources etc)\n","% of people having access to clean drinking water and proper toilets\n","Number of people having proper nutrition value","number of employees with access to benefits","Time savings due to improved technolgies (biogas, ICS, efficient transport etc)"," Improvement of the access, availability and quality (coverage and reliability) \n","Number of people graduating per year","Number of women employed","Access to new transport system","imported fuels","Number and type of knowledge assets produced"]
["Decrease in accidents","share of household income spent on fuel and electricity","Number of people living below poverty line","Other (Please specify)","Decreased number of PEM cases","per capita or household income","Time availability due to projects","Share of people having access to sustainable electricity","Disemmination of information","Number of women in leadership positions","Innovation of new equipment and process","share of imported oil (attributed to sector)"]
["Health detection and surveillance",null,"Re-settlement plan (in case of any displacement is required for project activity)",null,"Number of new crops grown","safe worker environment (proportion of laborers with access to safety equipment)","Other (Please specify)","Heating/cooling services","Research and increased awareness","Number of women receiving vocational training/education","Number of new technologies added","share of total energy supply from renewables"]
["DALY's averted",null,"Other (Please specify)",null,"Export/import mapping","skill level (number of training sessions)",null,"Number of RE plants","Construction of school","Number of women in entrepreneurial roles","Access to waste management services"]
["Life years gained",null,null,null,"Other (Please specify)",null,null,"Elelctricity consumption per capita","Number of children enrolling for primary education","Other (Please specify)","Number of training conducted"]
["Number of hospitals/health care facilities",null,null,null,null,null,null,"Other (Please specify)","Running of education programmes",null,"Other (Please specify)"]
["Reduction of health damaging air pollutants and indoor smoke",null,null,null,null,null,null,null,"Site visits and tours"]
["Avoided gas explosions or fire burns ",null,null,null,null,null,null,null,"Vocational trainings conducted"]
["Children immunized against deadly diseases",null,null,null,null,null,null,null,"Other (Please specify)"]
["Maternal mortality rate"]
["Other (Please specify)"]
[]
[]
["Equality","Income generation","Asset","Job creation",null,"Measurement Unit"]
["Number of people having access to jobs (women and men)","Fuel Savings per capita","Investment into new capacities","Per capita income",null,"Number","Direct"]
["Training sessions","Reduction in public expenditure by country","Establishment and maintenance of infrastructure","Number of jobs ( men and women; permanent Vs temporary)",null,"%","Indirect"]
["Working conditions (good or bad)","Export Import Mapping","Enhancing productivity","Migration for jobs",null,"Specific unit"]
["Working hours for Men Vs Women","Reduction in use of foreign exchange","Reduction of production costs","Other (Please specify)",null,"Other (Please specify)"]
["No Child labour involved","Reduction in import of fossil fuels","Setting an example for other industries"]
["Other (Please specify)","Per capita income generation","Creation of business opportunities"]
[null,"Other (Please specify)","Other (Please specify)"]