{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["READ ME","INPUT-Checklist","INPUT-Data","OUTPUT Graphs","VERSION CONTROL","Reference"],"not_rendered":{"charts":4,"images":8,"macros":0,"external_links":0,"defined_names":1,"comments":1,"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"}

{"sheet":"READ ME","index":0,"n_rows":82,"n_cols":7,"rows_kept":82,"cut":false,"hidden":false,"merged":[[10,3,10,9],[15,3,15,9],[17,3,17,9],[23,3,23,9],[31,3,31,9],[18,3,21,9],[49,3,50,4],[49,5,50,9],[34,3,36,5],[34,6,36,9],[37,3,39,5],[37,6,39,9],[40,3,41,5],[40,6,41,9],[44,3,45,5],[44,6,45,9],[42,3,43,5],[42,6,43,9],[47,3,47,9],[48,3,48,4],[48,5,48,6],[81,3,81,5],[51,3,51,4],[51,5,51,7],[52,3,52,4],[52,5,52,9],[53,3,55,4],[53,5,54,9],[55,5,55,7],[56,3,56,4],[56,5,56,7],[58,3,65,9],[66,3,74,9],[75,3,79,9]]}
{"$rows_empty":10}
[null,null,null,"Read Me Sheet"]
[]
[]
[]
[]
[null,null,null,"IRRIGATE – Impact Assessment Tool"]
[]
[null,null,null,"Introduction"]
[null,null,null,"This tool provides a comprehensive and practical guide to the possible impacts of solar-powered irrigation systems on socio-economics and on the environment. The impacts are grouped under the following topic areas:\n1. Population Change\n2. Human Migration\n3. Women's Role\n4. Minority Groups\n5. Income and Amenity \n6. Regional Effects\n7. User involvement\n8. Environment\n\nBy using the checklist, SPIS advisors can become more involved in assessing socio-economic and environmental change and in planning the mitigation of adverse impacts. The checklist should enable specialist expertise to be used more effectively and will promote closer co-operation between specialists and non-specialists in the development of socially, economically and environmentally sustainable projects. \n\nThe checklist can already be used in the design of a SPIS system as well as after the SPIS has been installed and used (e.g. 6 months, 2 years and 5 years) for continuous monitoring. The tool is particularly relevant for the module IRRIGATE of the SPIS Toolbox."]
[]
[]
[]
[]
[null,null,null,"Tips & Tricks"]
{"$rows_empty":7}
[null,null,null,"Overview"]
[null,null,null,"This tool comprises the following sheets:"]
[]
[null,null,null,"INPUT-Checklist",null,null,"This sheet comprises of questions that prompt the designer of the SPIS to assess and weigh the socio-economic and environmental aspects of the project. The answers generate graphs for the OUTPUT Graphs sheet. "]
[]
[]
[null,null,null,"INPUT-Data",null,null,"This allows for the entry of data that gives an overview of beneficiaries of the project. The values generate graphs for the OUTPUT Graphs sheet."]
[]
[]
[null,null,null,"OUTPUT Graphs",null,null,"This sheet contains graphs, generated by the INPUT sheets that can be used for assesment and in wider reports to demonstrate the socioeconomic and environmental impacts of the project"]
[]
[null,null,null,"Version Control",null,null,"Hidden. This sheet details the versions and changes made to each revision of this tool"]
[]
[null,null,null,"Reference",null,null,"Hidden. Reference scores and references for questions  contained in this INPUT sheets"]
[]
[]
[null,null,null,"About"]
[null,null,null,"Published by: ",null,"GIZ & FAO"]
[null,null,null,"Responsible:",null,"GIZ project Sustainable Energy for Food - Powering Agriculture"]
[]
[null,null,null,"Contact: ",null,"Powering.Agriculture@giz.de"]
[null,null,null,"Download link: ",null,"https://energypedia.info/wiki/Toolbox_on_SPIS"]
[null,null,null,"About: ",null,"Powering Agriculture: An Energy Grand Challenge for Development. Available at:  "]
[]
[{"$nulls":5},"https://poweringag.org"]
[null,null,null,"Version:",null,"1.0 (March 2018)"]
[]
[null,null,null,"The Toolbox on Solar Powered Irrigation Systems is made possible through the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Cooperation (OPIC) combined resources to create the PAEGC initiative. The objective of PAEGC is to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity and/or value for farmers and agribusinesses in developing countries and emerging regions that lack access to reliable, affordable clean energy."]
{"$rows_empty":7}
[null,null,null,"The designations employed and the presentation of material in this information product do not imply the expression of any opinion whatsoever on the part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Food and Agriculture Organization of the United Nations (FAO) or any of the PAEGC Founding Partners concerning the legal or development status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. The mention of specific companies or products of manufacturers, whether or not these have been patented, does not imply that these have been endorsed or recommended by GIZ, FAO, or any of the PAEGC Founding Partners in preference to others of a similar nature that are not mentioned. The views expressed in this information product are those of the author and do not necessarily reflect the views or policies of GIZ, FAO, or any of the PAEGC Founding Partners."]
{"$rows_empty":8}
[null,null,null,"GIZ, FAO and the PAEGC Founding Partners encourage the use, reproduction and dissemination of material in this information product. Except where otherwise indicated, material may be copied, downloaded and printed for private study, research and teaching purposes, or for use in non-commercial products or services, provided that appropriate acknowledgement of GIZ and FAO as the source and copyright holder is given."]
[]
[]
[]
[]
[]
[null,null,null,"© GIZ and FAO, 2018"]

{"sheet":"INPUT-Checklist","index":1,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,3,3,4],[4,3,4,4],[2,0,2,5],[7,3,7,4],[1,0,1,5],[8,3,8,4],[9,3,9,4],[5,3,5,4],[6,3,6,4],[54,1,54,5],[14,1,14,5],[60,1,60,5],[32,1,32,5],[44,1,44,5],[17,1,17,5],[20,1,20,5],[36,1,36,5]]}
["IRRIGATE - Impact Assessment Tool"]
["SOCIO-ECONOMIC AND ENVIRONMENTAL IMPACTS"]
["This checklist is to roughly assess the socio-economic and environmental impacts of solar-powered irrigation systems. The systems may vary in scale, so that not all questions are applicable."]
[1,"Population change",{"$f":"SUM(G16:G17)","v":0},"Project Name:"]
[2,"Human Migration",{"$f":"SUM(G19:G20)","v":0},"Project Location:"]
[3,"Women's Role",{"$f":"SUM(G22:G32)","v":0},"User Name:"]
[4,"Minority Groups",{"$f":"SUM(G34:G36)","v":0},"Date of Impact Assessment:"]
[5,"Income & Amenity",{"$f":"SUM(G38:G44)","v":0},"Project Duration (years):"]
[6,"Regional Effects",{"$f":"SUM(G46:G54)","v":0},"Asset Lifespan (years):"]
[7,"User Involvement",{"$f":"SUM(G56:G60)","v":0},"Notes:"]
[8,"Environment",{"$f":"SUM(G62:G77)","v":0}]
[null,"SCORE",{"$f":"SUM(C4+C8+C5+C6+C7+C11+C9+C10)","v":0}]
[]
["Ref #","Question","Yes, No or N/A ","Weighting \n(how important is this to the project?)","What is the impact of the project?","Comments"]
[1,"Population change"]
["1a","Have changes to population size/density and demographic/ethnic composition been considered in the planning of the Project? ",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D16,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E16,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["1b","Is the project causing significant demographic changes in the project area or vicinity which may affect social harmony? ",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D17,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E17,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
[2,"Human Migration"]
["2a","Has human migration, away form the Project location (e.g. rural flight) and toward it (e.g. demand for (seasonal) agricultural labour), been considered?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D19,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E19,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["2b","Has adequate provision been made for any temporary or migratory population influx to avoid social deprivation, hardship, or conflicts between the permanenet and temporary groups?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D20,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E20,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
[3,"Women's Role\nFor more indepth questions and aspects to consider please see http://www.fao.org/docrep/017/i3173e/i3173e.pdf "]
["3a","Does the project change the status and role of women (positively or negatively) in relation to social standing?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D22,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E22,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3b","Does the project change the status and role of women (positively or negatively) in relation to work load?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D23,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E23,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3c","Does the project change the status and role of women (positively or negatively) in relation to access to markets, income, and finance?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D24,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E24,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3d","Does the project change the status and role of women (positively or negatively) in relation to heritage and inheritance?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D25,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E25,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3e","Does the project change the status and role of women (positively or negatively) in relation to marital rights?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D26,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E26,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3f","Does the project allow for reduced time burden on women and minority groups allowing for pursuit of other activites such as education and leisure?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D27,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E27,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3g","Does the project establish dispute resolution mechanisms that are gender balanced?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D28,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E28,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3h","Have the consequences of changing the use of a water source been considered? Who will be affected?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D29,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E29,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3i","Will the project have gender differentiated impacts on farmers downstream or outside of the project boundary? ",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D30,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E30,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3j","Is the right to the irrigation system and right to irrigate connected to the land register or land ownership status? \n         If yes, has the impact of this on women been considered? \n         If no, how will the right to irrigate be established in a gender balanced way?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D31,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E31,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["3k","Does the project provide equal opportunities for training to men and women?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D32,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E32,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
[4,"Minority Groups"]
["4a","Is the project causing changes to the lifestyle, livelihoods or habitation of any social groups (particularly minority groups)?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D34,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E34,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["4b","Is the project leading to changes in traditional behaviour, social organisation or cultural and religious practices (particularly minority groups)?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D35,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E35,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["4c","Does the project address equal opportunities for minority groups?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D36,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E36,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
[5,"Income & Amenity"]
["5a","Is the Project introducing significant economic/political changes which can increase or decrease social harmony and individual wellbeing?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D38,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E38,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["5b","Does the project create business opportunities for local communities (e.g. diversification of production, technical service provisions, new markets)?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D39,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E39,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["5c","Does the project impact on the creation of a competitive agricultural sector (e.g. improved market access, higher quality products, greater yields)?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D40,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E40,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["5d","Have there been any changes in the general levels of employment and income?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D41,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E41,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["5e","Does the project impact sustainable job creation and employment relative to the life of the project?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D42,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E42,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["5f","Have there been any changes in the provision of local infrastructure and amenities?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D43,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E43,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["5g","Have there been any changes in the relative distribution of income, property values and Project benefits (including access to irrigation water)?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D44,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E44,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
[6,"Regional Effects"]
["6a","Will the economic, infrastructural, social and demographic changes associated with the project impact on regional development?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D46,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E46,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["6b","Is there an impact on institutional efficiency at the local and regional level? (regulatory framework, informal relationships, steering mechanisms)",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D47,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E47,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["6c","Are there impacts on viability of land holdings, land rights, and water rights?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D48,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E48,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["6d","Does the project deliver a fair standard of living for agricultural and rural communities?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D49,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E49,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["6e","Does the project contribute to the viability of rural areas / a balanced pattern of development / the maintenance of vibrant and active rural communities?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D50,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E50,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["6f","Is there an impact on subsistence farmers and farming systems for the project population in the project area?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D51,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E51,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["6g","Is there an impact on subsistence farmers and farming systems for the project population outside of  the project area?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D52,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E52,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["6h","Has adequate provision been made for new transport, marketing, and processing needs associated with the project?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D53,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E53,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["6i","Is access improved or hampered to sites of historical, cultural and religious significance?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D54,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E54,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
[7,"User Involvement"]
["7a","Has there been adequate user participation in project planning, implementation, and operation to ensure project success and reduce future conflicts?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D56,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E56,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["7b","Has the provision of new or extended facilities for credit, marketing, agricultural extension and training been considered?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D57,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E57,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["7c","Have the views, needs and preferences of users been adequately considered in the design and set-up of the system?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D58,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E58,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["7d","Will training be provided to local populations?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D59,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E59,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["7e","Has the potential for incorporating existing systems of land tenure, traditional irrigation and existing organisational and sociological structures been considered?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D60,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E60,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
[8,"Environment"]
["8a","Has the impact of increased evapotranspiration been considered?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D62,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E62,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8b","Does the project establish the use of water within sustainable abstraction limits?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D63,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E63,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8c","Does the project impact on groundwater availability through drying up of drinking and irrigation wells?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D64,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E64,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8d","Does the project impact on groundwater availability through saline intrusion along the coastal regions?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D65,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E65,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8e","Does the project impact on groundwater availability through reducing the base flows?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D66,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E66,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8f","Does the project impact on downstream river discharges of the project area?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D67,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E67,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8g","Does the project impact on water quality through a reduction in irrigation water quality and leaching?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D68,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E68,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8h","Does the project create water quality problems for downstream users by poor irrigation return flow quality?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D69,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E69,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8i","Does the project impact on the degradation of the land through salinization?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D70,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E70,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8j","Does the project impact on the degradation of the land through alkalisation?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D71,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E71,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8k","Does the project impact on the degradation of the land through increased groundwater recharge, waterlogging and drainage problems?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D72,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E72,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8l","Does the project impact on the degradation of the land through soil acidification?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D73,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E73,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8m","Does the project impact on the degradation of the land through soil compaction?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D74,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E74,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8n","Does the project impact on the degradation of the land through soil erosion?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D75,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E75,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8o","Does the project impact on ecological systems through:\n• Reduced biodiversity in the irrigated and surrounding area,\n• Damage to downstream ecosystems due to reduced water quantity and quality",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D76,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E76,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]
["8p","Does the project impact on human health through increased incidence of water-related diseases?",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(D77,Reference!$A$11:$B$13,2,FALSE)*VLOOKUP(E77,Reference!$A$2:$B$7,2,FALSE),\" \")","v":" "}]

{"sheet":"INPUT-Data","index":2,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[39,1,39,5],[0,0,0,5],[1,0,1,5],[7,1,7,5],[19,1,19,5],[25,1,25,5]]}
["IRRIGATE - Impact Assessment Tool"]
["SOCIO-ECONOMIC DATA"]
["Ref #","Question","ABSOLUTE NUMBER","PERCENTAGE [%]","USER COMMENTS","PROJECT REVIEWER COMMENTS"]
["A1.0","What is the population in the vicinity of the project?\n"]
["A1.1","How many will be impacted by the project?\n",null,{"$f":"IFERROR(C5/C4,\"-\")","v":"-"}]
["A1.2","How many farmers will be impacted by the project?\n",null,{"$f":"IFERROR(C6/C5,\"-\")","v":"-"}]
[null,"TOTAL",{"$f":"SUM(C5:C6)","v":0},{"$f":"C7/C4","v":{"$error":"#DIV/0!"}}]
["A2.0","What is the breakdown of farmers benefitting from the project by gender, by socioeconomic deliniation, and by income?"]
["A2.1","Male",null,{"$f":"IFERROR(C9/(C9+C10),\"-\")","v":"-"}]
["A2.2","Female",null,{"$f":"IFERROR(C10/(C9+C10),\"-\")","v":"-"}]
[null,"TOTAL",{"$f":"SUM(C9:C10)","v":0},{"$f":"C11/C6","v":{"$error":"#DIV/0!"}}]
["A2.3","Strata 1: _____",null,{"$f":"IFERROR(C12/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
["A2.4","Strata 2:_____",null,{"$f":"IFERROR(C13/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
["A2.5","Strata 3:_____",null,{"$f":"IFERROR(C14/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
["A2.6","Strata 4:_____",null,{"$f":"IFERROR(C15/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
[null,"TOTAL",{"$f":"SUM(C12:C15)","v":0},{"$f":"C16/C6","v":{"$error":"#DIV/0!"}}]
["A2.7","Unemployed",null,{"$f":"IFERROR(C17/(C9+C10),\"-\")","v":"-"}]
["A2.8","Below poverty line",null,{"$f":"IFERROR(C18/(C9+C10),\"-\")","v":"-"}]
[null,"TOTAL",{"$f":"SUM(C17:C18)","v":0},{"$f":"C19/C11","v":{"$error":"#DIV/0!"}}]
["A3.0","Where are farmers benefitting recruited from?"]
["A3.1","Local in the village",null,{"$f":"IFERROR(C21/($C$21+$C$22+$C$23+$C$24),\"-\")","v":"-"}]
["A3.2","Local resettled",null,{"$f":"IFERROR(C22/($C$21+$C$22+$C$23+$C$24),\"-\")","v":"-"}]
["A3.3","Same sociological background from elsewhere",null,{"$f":"IFERROR(C23/($C$21+$C$22+$C$23+$C$24),\"-\")","v":"-"}]
["A3.4","Different sociological background",null,{"$f":"IFERROR(C24/($C$21+$C$22+$C$23+$C$24),\"-\")","v":"-"}]
[null,"TOTAL",{"$f":"SUM(C21:C24)","v":0},{"$f":"C25/C6","v":{"$error":"#DIV/0!"}}]
["A4.0","What are the labour requirements of the project?"]
["A4.1","Family labour",null,{"$f":"IFERROR(C27/($C$27+$C$28+$C$29+$C$30),\"-\")","v":"-"}]
["A4.2","Local labour",null,{"$f":"IFERROR(C28/($C$27+$C$28+$C$29+$C$30),\"-\")","v":"-"}]
["A4.3","Seasonal local labour",null,{"$f":"IFERROR(C29/($C$27+$C$28+$C$29+$C$30),\"-\")","v":"-"}]
["A4.4","Seasonal labour from afar",null,{"$f":"IFERROR(C30/($C$27+$C$28+$C$29+$C$30),\"-\")","v":"-"}]
[null,"TOTAL",{"$f":"SUM(C27:C30)","v":0},{"$f":"C31/C6","v":{"$error":"#DIV/0!"}}]
["A5.0","How many people lose traditional means of subsistence (not those in the project)?",null,"per year"]
[]
["A6.0","How many jobs are created by the project?",null,"per year"]
["A6.1","How many years are they expected to last for?",null,"years"]
[]
["A7.0","What are the estimated population growth numbers over the life of the assets?",null,"%"]
["A7.1","What are the estimated migrant proportion due to the project over the life of the assets?",null,"%"]
[]
["A8.0","What is the tenure breakdown of the farmers?"]
["A8.1","Landowner",null,{"$f":"IFERROR(C41/($C$41+$C$42+$C$43+$C$44),\"-\")","v":"-"}]
["A8.2","Tenant farmer",null,{"$f":"IFERROR(C42/($C$41+$C$42+$C$43+$C$44),\"-\")","v":"-"}]
["A8.3","Tenant farmer on government land",null,{"$f":"IFERROR(C43/($C$41+$C$42+$C$43+$C$44),\"-\")","v":"-"}]
["A8.4","Worker / Labourer",null,{"$f":"IFERROR(C44/($C$41+$C$42+$C$43+$C$44),\"-\")","v":"-"}]
[null,"TOTAL",{"$f":"SUM(C41:C44)","v":0},{"$f":"C45/C6","v":{"$error":"#DIV/0!"}}]

{"sheet":"OUTPUT Graphs","index":3,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,12,3,16],[4,12,4,16],[0,0,0,18],[2,1,2,5],[3,1,3,5],[4,1,4,5],[2,12,2,16]]}
["IRRIGATE - Impact Assessment Tool"]
[]
["Project Name:",{"$f":"'INPUT-Checklist'!F4","v":0},{"$nulls":5},"Date of Impact Assessment:",{"$nulls":4},{"$f":"'INPUT-Checklist'!F7","v":0}]
["Project Location:",{"$f":"'INPUT-Checklist'!F5","v":0},{"$nulls":5},"Project Duration (years):",{"$nulls":4},{"$f":"'INPUT-Checklist'!F8","v":0}]
["User Name:",{"$f":"'INPUT-Checklist'!F6","v":0},{"$nulls":5},"Asset Lifespan (years):",{"$nulls":4},{"$f":"'INPUT-Checklist'!F9","v":0}]
[]
[]
[]
[]
[null,"Lowest score possible","Highest possible score","Actual Score"]
["Population change",{"$f":"0-C11","v":-15},{"$f":"COUNTA('INPUT-Checklist'!A16:A17)*7.5","v":15},{"$f":"'INPUT-Checklist'!C4","v":0}]
["Human Migration",{"$f":"0-C12","v":-15},{"$f":"COUNTA('INPUT-Checklist'!A19:A20)*7.5","v":15},{"$f":"'INPUT-Checklist'!C5","v":0}]
["Women's Role",-82.5,{"$f":"COUNTA('INPUT-Checklist'!A22:A32)*7.5","v":82.5},{"$f":"'INPUT-Checklist'!C6","v":0}]
["Minority Groups",-22.5,{"$f":"COUNTA('INPUT-Checklist'!A34:A36)*7.5","v":22.5},{"$f":"'INPUT-Checklist'!C7","v":0}]
["Income & Amenity",-52.5,{"$f":"COUNTA('INPUT-Checklist'!A38:A44)*7.5","v":52.5},{"$f":"'INPUT-Checklist'!C8","v":0}]
["Regional Effects",-67.5,{"$f":"COUNTA('INPUT-Checklist'!A46:A54)*7.5","v":67.5},{"$f":"'INPUT-Checklist'!C9","v":0}]
["User Involvement",-37.5,{"$f":"COUNTA('INPUT-Checklist'!A56:A60)*7.5","v":37.5},{"$f":"'INPUT-Checklist'!C10","v":0}]
["Environmental",-120,{"$f":"COUNTA('INPUT-Checklist'!A62:A77)*7.5","v":120},{"$f":"'INPUT-Checklist'!C11","v":0}]
[]
[]
[]
["Gender and Socioeconomic Spread of Project Beneficiaries"]
[]
[{"$f":"'INPUT-Data'!B9","v":"Male"},{"$f":"'INPUT-Data'!D9","v":"-"}]
[{"$f":"'INPUT-Data'!B10","v":"Female"},{"$f":"'INPUT-Data'!D10","v":"-"}]
[{"$f":"'INPUT-Data'!B12","v":"Strata 1: _____"},{"$f":"'INPUT-Data'!D12","v":"-"}]
[{"$f":"'INPUT-Data'!B13","v":"Strata 2:_____"},{"$f":"'INPUT-Data'!D13","v":"-"}]
[{"$f":"'INPUT-Data'!B14","v":"Strata 3:_____"},{"$f":"'INPUT-Data'!D14","v":"-"}]
[{"$f":"'INPUT-Data'!B15","v":"Strata 4:_____"},{"$f":"'INPUT-Data'!D15","v":"-"}]
[{"$f":"'INPUT-Data'!B41","v":"Landowner"},{"$f":"'INPUT-Data'!D41","v":"-"}]
[{"$f":"'INPUT-Data'!B42","v":"Tenant farmer"},{"$f":"'INPUT-Data'!D42","v":"-"}]
[{"$f":"'INPUT-Data'!B43","v":"Tenant farmer on government land"},{"$f":"'INPUT-Data'!D43","v":"-"}]
[{"$f":"'INPUT-Data'!B44","v":"Worker / Labourer"},{"$f":"'INPUT-Data'!D44","v":"-"}]

{"sheet":"VERSION CONTROL","index":4,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":true,"merged":[[8,4,8,7],[8,2,8,3],[20,3,20,7],[9,3,11,7],[13,2,13,3],[13,4,13,6],[14,2,14,3],[14,4,14,6],[15,2,15,3],[15,4,15,6],[17,3,17,7],[18,3,18,7],[19,3,19,7],[27,3,27,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[26,3,26,7]]}
{"$rows_empty":9}
[null,null,null,"Tranlsation of ICID Checklist for Socioeconomic perspectives for SPIS projects"]
[]
[]
[]
[null,null,"Created By",null,"Alqayam Meghji"]
[null,null,"Checked By",null,"Lucie Pluschke"]
[null,null,"Reviewed By"]
[]
[null,"Date","Rev:","Comments"]
[null,"19/03/18",0.1,"Draft for review"]
[null,"23/03/18",0.2,"Inclusion of equity and efficieny"]
[null,"28/03/18",0.3,"Inclusion of environmental considerations and conditional formatting"]
[null,"29/03/18",0.4,"Changes made after review with Lucie Plushke"]

{"sheet":"Reference","index":5,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Impact","Score"]
["Positive impact is very likely",5]
["Positive impact possible",2]
["No impact likely",1]
["Negative impact possible",-2]
["Negative impact very likely",-5]
["No judgment possible at present",0]
[]
[]
["Weighting","Linear Multiplier"]
["High",1.5]
["Medium",1]
["Low",0.5]
[]
[]
[]
[]
[]
["Questions"]
["https://ec.europa.eu/agriculture/publi/reports/sustain/index_en.pdf  "]
[]
[]
[]
[]
[]
[]
["Agroecology","http://www.fao.org/agroecology/knowledge/10-elements/en/"]
[]
["Questions not included:"]
["Optimum utilisation of the factors of production, in particular labour, increase of agricultural productivity"]
["Assurance of the availability of supplies"]