{"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":2,"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":[[81,3,81,5],[51,3,51,4],[51,5,51,7],[52,3,52,4],[52,5,52,8],[53,3,55,4],[53,5,54,8],[55,5,55,7],[56,3,56,4],[56,5,56,7],[58,3,65,8],[66,3,74,8],[75,3,79,8],[49,3,50,4],[49,5,50,8],[34,3,36,5],[34,6,36,8],[37,3,39,5],[37,6,39,8],[40,3,41,5],[40,6,41,8],[44,3,45,5],[44,6,45,8],[42,3,43,5],[42,6,43,8],[47,3,47,8],[48,3,48,4],[48,5,48,6],[10,3,10,8],[15,3,15,8],[17,3,17,8],[23,3,23,8],[31,3,31,8],[18,3,21,8]]}
{"$rows_empty":10}
[null,null,null,"Read Me Sheet"]
[]
[]
[]
[]
[null,null,null,"PROMOTE and INITIATE – Impact Assessment Tool"]
[]
[null,null,null,"Introduction"]
[null,null,null,"This tool provides a guide to the possible impacts of solar-powered irrigation systems on socio-economics and environment. Impacts may be regarded as positive, neutral or negative.  The impacts are grouped under the following topic areas:\n1. Population Change and Migration\n2. Women's Role\n3. Minority and Indigene Groups\n4. Income and Amenity \n5. Regional Effects in Country\n6. User Involvement\n7. natural Resources and Environment\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 PROMOTE and INITIATE 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.2 (July 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":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":false,"merged":[[49,1,49,2],[50,1,50,2],[51,1,51,2],[22,5,22,6],[27,1,27,2],[28,1,28,2],[37,1,37,6],[52,1,52,6],[44,1,44,6],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[38,1,38,2],[39,1,39,2],[45,1,45,2],[46,1,46,2],[48,1,48,2],[30,1,30,2],[22,2,22,4],[19,1,19,2],[20,1,20,2],[25,1,25,2],[26,1,26,2],[23,1,23,2],[18,1,18,2],[21,1,21,2],[24,1,24,2],[29,1,29,2],[2,0,2,6],[7,4,7,5],[1,0,1,6],[0,1,0,6],[47,1,47,2],[16,1,16,2],[8,4,8,5],[9,4,9,5],[5,4,5,5],[6,4,6,5],[3,4,3,5],[4,4,4,5],[31,1,31,2],[14,1,14,6],[15,1,15,2],[17,1,17,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[81,1,81,2],[82,1,82,2],[85,1,85,2],[83,1,83,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[63,1,63,2],[62,1,62,6],[76,1,76,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[80,1,80,2],[71,1,71,2],[72,1,72,2],[73,1,73,2],[74,1,74,2],[75,1,75,2],[91,1,91,2],[40,1,40,2],[42,1,42,2],[41,1,41,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[89,1,89,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[69,1,69,2],[68,1,68,6],[58,1,58,2],[70,1,70,2]]}
[null,"PROMOTE and INITIATE - 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. "]
[null,1,{"$f":"B15","v":"Population Change and Migration"},{"$f":"SUM(H16:H22)","v":52.5},"Project Name:",null,"sample"]
[null,2,{"$f":"B23","v":"Women's Role"},{"$f":"SUM(H24:H37)","v":105},"Project Location:"]
[null,3,{"$f":"B38","v":"Minority and Indigene Groups"},{"$f":"SUM(H39:H44)","v":45},"User Name:"]
[null,4,{"$f":"B45","v":"Income and Amenities"},{"$f":"SUM(H46:H52)","v":52.5},"Date of Impact Assessment:"]
[null,5,{"$f":"B53","v":"Regional Effects in Country"},{"$f":"SUM(H54:H62)","v":67.5},"Project Duration (years):"]
[null,6,{"$f":"B63","v":"User Involvement"},{"$f":"SUM(H64:H68)","v":37.5},"Asset Lifespan (years):"]
[null,7,{"$f":"B69","v":"Natural Resources and Environment"},{"$f":"SUM(H70:H92)","v":172.5},"Notes:"]
[null,null,"SCORE",{"$f":"SUM(D4+D7+D5+D6+D10+D8+D9)","v":532.5}]
[]
[]
["Ref #","Question",null,"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 and Migration"]
["1a","Have changes to population size/density and demographic/ethnic composition been considered in the planning of the Project? ",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D16=\"Yes\",(VLOOKUP(E16,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F16,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D16,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E16,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F16,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D16,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["1b","Is the project causing significant demographic changes in the project area or vicinity which may affect social harmony? ",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D17=\"Yes\",(VLOOKUP(E17,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F17,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D17,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E17,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F17,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D17,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["1c","Is the project avoiding the physical and economic displacement of people?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D18=\"Yes\",(VLOOKUP(E18,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F18,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D18,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E18,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F18,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D18,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["1d","Has human migration, away form the Project location (e.g. rural flight) and toward it (e.g. demand for (seasonal) agricultural labour), been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D19=\"Yes\",(VLOOKUP(E19,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F19,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D19,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E19,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F19,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D19,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["1e","Does the project ensure decent rural employment, promoting more and better employment opportunities and working conditions and avoiding practices that could increase workers’ vulnerability?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D20=\"Yes\",(VLOOKUP(E20,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F20,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D20,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E20,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F20,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D20,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["1f","Does the project respect the fundamental principles and rights at work and prohibit child labour?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D21=\"Yes\",(VLOOKUP(E21,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F21,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D21,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E21,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F21,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D21,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["1g","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?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D22=\"Yes\",(VLOOKUP(E22,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F22,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D22,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E22,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F22,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D22,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
[2,"Women's Role","for more indepth questions and aspects to consider please see:",null,null,"http://www.fao.org/docrep/017/i3173e/i3173e.pdf"]
["2a","Have the needs, priorities and constraints of both women and men been taken into consideration during the design of the project?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D24=\"Yes\",(VLOOKUP(E24,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F24,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D24,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E24,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F24,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D24,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2b","Does the project change the status and role of women positively in relation to social standing?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D25=\"Yes\",(VLOOKUP(E25,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F25,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D25,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E25,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F25,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D25,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2c","Does the project change the status and role of women positively in relation to work load?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D26=\"Yes\",(VLOOKUP(E26,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F26,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D26,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E26,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F26,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D26,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2d","Does the project change the status and role of women positively in relation to access to markets, income, and finance?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D27=\"Yes\",(VLOOKUP(E27,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F27,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D27,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E27,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F27,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D27,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2e","Does the project change the status and role of women positively in relation to heritage and inheritance?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D28=\"Yes\",(VLOOKUP(E28,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F28,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D28,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E28,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F28,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D28,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2f","Does the project change the status and role of women positivelyin relation to marital rights?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D29=\"Yes\",(VLOOKUP(E29,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F29,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D29,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E29,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F29,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D29,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2g","Does the project promote women’s and men’s equitable access to and control over productive resources and services?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D30=\"Yes\",(VLOOKUP(E30,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F30,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D30,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E30,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F30,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D30,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2h","Does the project foster the equal participation of men and women in institutions and decision-making processes?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D31=\"Yes\",(VLOOKUP(E31,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F31,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D31,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E31,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F31,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D31,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2i","Does the project allow for reduced time burden on women and minority groups allowing for pursuit of other activites such as education and leisure?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D32=\"Yes\",(VLOOKUP(E32,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F32,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D32,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E32,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F32,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D32,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2j","Does the project establish dispute resolution mechanisms that are gender balanced?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D33=\"Yes\",(VLOOKUP(E33,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F33,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D33,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E33,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F33,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D33,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2k","Have the consequences of changing the use of a water source been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D34=\"Yes\",(VLOOKUP(E34,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F34,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D34,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E34,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F34,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D34,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2l","Will the project have gender differentiated impacts on farmers downstream or outside of the project boundary? ",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D35=\"Yes\",(VLOOKUP(E35,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F35,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D35,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E35,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F35,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D35,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2m","Will the right to the irrigation system and right to irrigate affect the land register or land ownership status?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D36=\"Yes\",(VLOOKUP(E36,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F36,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D36,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E36,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F36,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D36,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["2n","Does the project provide equal opportunities for training to men and women?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D37=\"Yes\",(VLOOKUP(E37,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F37,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D37,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E37,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F37,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D37,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
[3,"Minority and Indigene Groups"]
["3a","Is the project causing positive changes to the lifestyle, livelihoods or habitation of any social groups (particularly minority groups)?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D39=\"Yes\",(VLOOKUP(E39,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F39,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D39,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E39,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F39,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D39,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["3b","Is the project leading to positive changes in traditional behaviour, social organisation or cultural and religious practices (particularly minority groups)?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D40=\"Yes\",(VLOOKUP(E40,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F40,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D40,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E40,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F40,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D40,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["3c","Does the project address equal opportunities for minority groups?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D41=\"Yes\",(VLOOKUP(E41,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F41,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D41,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E41,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F41,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D41,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["3a","Are project activities likely to have adverse effects on indigenous peoples’ rights, lands, natural resources, territories, livelihoods, knowledge, social fabric, traditions, governance systems, and culture or heritage (tangible and intangible)? ",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D42=\"Yes\",(VLOOKUP(E42,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F42,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D42,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E42,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F42,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D42,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["3b","Are indigenous communities outside the project area likely to be affected by the project?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D43=\"Yes\",(VLOOKUP(E43,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F43,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D43,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E43,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F43,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D43,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["3c","Is the project designed to be sensitive to cultural heritage issues?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D44=\"Yes\",(VLOOKUP(E44,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F44,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D44,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E44,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F44,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D44,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
[4,"Income and Amenities"]
["4a","Is the Project introducing significant economic/political changes which can increase or decrease social harmony and individual wellbeing?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D46=\"Yes\",(VLOOKUP(E46,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F46,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D46,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E46,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F46,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D46,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["4b","Does the project create business opportunities for local communities (e.g. diversification of production, technical service provisions, new markets)?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D47=\"Yes\",(VLOOKUP(E47,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F47,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D47,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E47,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F47,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D47,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["4c","Does the project impact on the creation of a competitive agricultural sector (e.g. improved market access, higher quality products, greater yields)?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D48=\"Yes\",(VLOOKUP(E48,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F48,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D48,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E48,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F48,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D48,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["4d","Have there been any improvements in the general levels of employment and income?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D49=\"Yes\",(VLOOKUP(E49,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F49,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D49,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E49,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F49,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D49,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["4e","Does the project impact sustainable job creation and employment relative to the life of the project?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D50=\"Yes\",(VLOOKUP(E50,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F50,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D50,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E50,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F50,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D50,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["4f","Have there been any changes in the provision of local infrastructure and amenities?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D51=\"Yes\",(VLOOKUP(E51,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F51,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D51,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E51,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F51,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D51,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["4g","Have there been any changes in the relative distribution of income, property values and Project benefits (including access to irrigation water)?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D52=\"Yes\",(VLOOKUP(E52,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F52,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D52,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E52,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F52,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D52,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
[5,"Regional Effects in Country"]
["5a","Will the economic, infrastructural, social and demographic changes associated with the project impact on regional development?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D54=\"Yes\",(VLOOKUP(E54,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F54,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D54,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E54,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F54,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D54,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["5b","Have impacts on institutional efficiency at the local and regional level been considered? (regulatory framework, informal relationships, steering mechanisms)",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D55=\"Yes\",(VLOOKUP(E55,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F55,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D55,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E55,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F55,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D55,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["5c","Have impacts on viability of land holdings, land rights, and water rights been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D56=\"Yes\",(VLOOKUP(E56,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F56,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D56,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E56,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F56,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D56,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["5d","Does the project deliver a fair standard of living for agricultural and rural communities?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D57=\"Yes\",(VLOOKUP(E57,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F57,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D57,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E57,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F57,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D57,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["5e","Does the project contribute to the viability of rural areas / a balanced pattern of development / the maintenance of vibrant and active rural communities?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D58=\"Yes\",(VLOOKUP(E58,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F58,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D58,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E58,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F58,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D58,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["5f","Is there a postive impact on subsistence farmers and farming systems for the project population in the project area?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D59=\"Yes\",(VLOOKUP(E59,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F59,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D59,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E59,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F59,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D59,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["5g","Is there a positive impact on subsistence farmers and farming systems for the project population outside of  the project area?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D60=\"Yes\",(VLOOKUP(E60,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F60,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D60,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E60,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F60,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D60,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["5h","Has adequate provision been made for new transport, marketing, and processing needs associated with the project?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D61=\"Yes\",(VLOOKUP(E61,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F61,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D61,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E61,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F61,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D61,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["5i","Has the impact on access to sites of national historical, cultural and religious significance been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D62=\"Yes\",(VLOOKUP(E62,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F62,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D62,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E62,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F62,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D62,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
[6,"User Involvement"]
["6a","Has there been adequate user participation in project planning, implementation, and operation to ensure project success and reduce future conflicts?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D64=\"Yes\",(VLOOKUP(E64,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F64,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D64,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E64,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F64,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D64,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["6b","Has the provision of new or extended facilities for credit, marketing, agricultural extension and training been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D65=\"Yes\",(VLOOKUP(E65,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F65,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D65,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E65,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F65,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D65,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["6c","Have the views, needs and preferences of users been adequately considered in the design and set-up of the system?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D66=\"Yes\",(VLOOKUP(E66,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F66,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D66,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E66,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F66,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D66,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["6d","Will training be provided to local populations?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D67=\"Yes\",(VLOOKUP(E67,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F67,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D67,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E67,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F67,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D67,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["6e","Has the potential for incorporating existing systems of land tenure, traditional irrigation and existing organisational and sociological structures been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D68=\"Yes\",(VLOOKUP(E68,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F68,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D68,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E68,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F68,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D68,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
[7,"Natural Resources and Environment"]
["7a","Has the impact of increased evapotranspiration been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D70=\"Yes\",(VLOOKUP(E70,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F70,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D70,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E70,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F70,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D70,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7b","Does the project establish the use of water within sustainable abstraction limits?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D71=\"Yes\",(VLOOKUP(E71,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F71,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D71,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E71,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F71,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D71,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7c","Has groundwater availability through drying up of drinking and irrigation wells been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D72=\"Yes\",(VLOOKUP(E72,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F72,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D72,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E72,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F72,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D72,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7d","Has saline intrusion into groundwater along the coastal regions been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D73=\"Yes\",(VLOOKUP(E73,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F73,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D73,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E73,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F73,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D73,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7e","Have reduced base flows on groundwater availability been assessed?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D74=\"Yes\",(VLOOKUP(E74,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F74,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D74,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E74,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F74,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D74,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7f","Has the impact on downstream river discharges of the project area been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D75=\"Yes\",(VLOOKUP(E75,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F75,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D75,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E75,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F75,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D75,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7g","Has the impact on water quality through a reduction in irrigation water quality and leaching been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D76=\"Yes\",(VLOOKUP(E76,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F76,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D76,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E76,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F76,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D76,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7h","Has the impact on water quality problems for downstream users by poor irrigation return flow quality been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D77=\"Yes\",(VLOOKUP(E77,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F77,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D77,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E77,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F77,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D77,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7i","Has impact on the degradation of the land through salinization been assessed?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D78=\"Yes\",(VLOOKUP(E78,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F78,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D78,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E78,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F78,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D78,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7j","Has the impact on the degradation of the land through alkalisation been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D79=\"Yes\",(VLOOKUP(E79,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F79,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D79,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E79,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F79,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D79,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7k","Has the degradation of the land through increased groundwater recharge, waterlogging and drainage problems been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D80=\"Yes\",(VLOOKUP(E80,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F80,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D80,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E80,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F80,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D80,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7l","Has the project impact on the degradation of the land through soil acidification been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D81=\"Yes\",(VLOOKUP(E81,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F81,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D81,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E81,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F81,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D81,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7m","Has the project impact on the degradation of the land through soil compaction been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D82=\"Yes\",(VLOOKUP(E82,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F82,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D82,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E82,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F82,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D82,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7n","Has the impact on the degradation of the land through soil erosion been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D83=\"Yes\",(VLOOKUP(E83,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F83,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D83,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E83,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F83,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D83,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7o","Does the project include usage of non-conventional sources of water (i.e. wastewater)?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D84=\"Yes\",(VLOOKUP(E84,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F84,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D84,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E84,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F84,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D84,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7p","Has the impact of a dam been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D85=\"Yes\",(VLOOKUP(E85,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F85,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D85,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E85,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F85,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D85,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7q","Has the project impact on ecological systems (biodiversity in irrigated and surrounding areas or downstream areas) been considered:",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D86=\"Yes\",(VLOOKUP(E86,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F86,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D86,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E86,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F86,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D86,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7r","Have impacts on human health through increased incidence of water-related diseases been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D87=\"Yes\",(VLOOKUP(E87,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F87,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D87,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E87,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F87,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D87,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7s","Is there a solid waste collection system in place in the project area? ",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D88=\"Yes\",(VLOOKUP(E88,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F88,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D88,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E88,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F88,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D88,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7t","Is there a collection system for electrical and electronic waste (solar panels, charge controllers, inverters, cables...) in place in the project area? ",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D89=\"Yes\",(VLOOKUP(E89,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F89,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D89,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E89,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F89,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D89,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7u","Is there a collection system in place to collect batteries in the project area? ",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D90=\"Yes\",(VLOOKUP(E90,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F90,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D90,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E90,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F90,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D90,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7v","Has any increased exposure to toxic substances (pesticides, battery liquids, fertilizers, chemicals etc...) been considered?",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D91=\"Yes\",(VLOOKUP(E91,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F91,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D91,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E91,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F91,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D91,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]
["7w","Is there a collection system in place to collect agricultural plastics (pipes, reservoirs, mulch, tunnels, greenhouse, silage, crates, fittings, nets, dripers...) in the project area? ",null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D92=\"Yes\",(VLOOKUP(E92,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F92,Reference!$A$2:$B$7,2,FALSE)*VLOOKUP(D92,Reference!$A$14:$B$15,2,FALSE)),(VLOOKUP(E92,Reference!$A$9:$B$11,2,FALSE)*VLOOKUP(F92,Reference!$A$2:$C$7,3,FALSE)*VLOOKUP(D92,Reference!$A$14:$B$15,2,FALSE))),\" \")","v":7.5}]

{"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]]}
["PROMOTE and INITIATE - 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","Group type 1",null,{"$f":"IFERROR(C12/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
["A2.4","Group type 2",null,{"$f":"IFERROR(C13/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
["A2.5","Group type 3",null,{"$f":"IFERROR(C14/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
["A2.6","Group type 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":[[0,1,0,12],[4,12,4,16],[5,12,5,16],[3,1,3,5],[4,1,4,5],[5,1,5,5],[3,12,3,16]]}
[null,"PROMOTE and INITIATE - Impact Assessment Tool"]
[]
[]
["Project Name:",{"$f":"'INPUT-Checklist'!G4","v":"sample"},{"$nulls":5},"Date of Impact Assessment:",{"$nulls":4},{"$f":"'INPUT-Checklist'!G7","v":0}]
["Project Location:",{"$f":"'INPUT-Checklist'!G5","v":0},{"$nulls":5},"Project Duration (years):",{"$nulls":4},{"$f":"'INPUT-Checklist'!G8","v":0}]
["User Name:",{"$f":"'INPUT-Checklist'!G6","v":0},{"$nulls":5},"Asset Lifespan (years):",{"$nulls":4},{"$f":"'INPUT-Checklist'!G9","v":0}]
[]
[]
[]
[]
[null,"Lowest score possible","Highest possible score","Actual Score","correction factor","% Reached"]
[{"$f":"'INPUT-Checklist'!C4","v":"Population Change and Migration"},{"$f":"0-C12","v":-52.5},{"$f":"COUNTA('INPUT-Checklist'!A16:A22)*7.5","v":52.5},{"$f":"'INPUT-Checklist'!D4","v":52.5},{"$f":"120/C12","v":2.2857142857142856},{"$f":"(E12*'INPUT-Checklist'!D4)/120","v":1}]
[{"$f":"'INPUT-Checklist'!C5","v":"Women's Role"},{"$f":"0-C13","v":-105},{"$f":"COUNTA('INPUT-Checklist'!A24:A37)*7.5","v":105},{"$f":"'INPUT-Checklist'!D5","v":105},{"$f":"120/C13","v":1.1428571428571428},{"$f":"(E13*'INPUT-Checklist'!D5)/120","v":1}]
[{"$f":"'INPUT-Checklist'!C6","v":"Minority and Indigene Groups"},-45,{"$f":"COUNTA('INPUT-Checklist'!A39:A44)*7.5","v":45},{"$f":"'INPUT-Checklist'!D6","v":45},2.6666666666666665,{"$f":"(E14*'INPUT-Checklist'!D6)/120","v":1}]
[{"$f":"'INPUT-Checklist'!C7","v":"Income and Amenities"},-52.5,{"$f":"COUNTA('INPUT-Checklist'!A46:A52)*7.5","v":52.5},{"$f":"'INPUT-Checklist'!D7","v":52.5},2.2857142857142856,{"$f":"(E15*'INPUT-Checklist'!D7)/120","v":1}]
[{"$f":"'INPUT-Checklist'!C8","v":"Regional Effects in Country"},-67.5,{"$f":"COUNTA('INPUT-Checklist'!A54:A62)*7.5","v":67.5},{"$f":"'INPUT-Checklist'!D8","v":67.5},1.7777777777777777,{"$f":"(E16*'INPUT-Checklist'!D8)/120","v":1}]
[{"$f":"'INPUT-Checklist'!C9","v":"User Involvement"},-37.5,{"$f":"COUNTA('INPUT-Checklist'!A64:A68)*7.5","v":37.5},{"$f":"'INPUT-Checklist'!D9","v":37.5},3.2,{"$f":"(E17*'INPUT-Checklist'!D9)/120","v":1}]
[{"$f":"'INPUT-Checklist'!C10","v":"Natural Resources and Environment"},-172.5,{"$f":"COUNTA('INPUT-Checklist'!A70:A92)*7.5","v":172.5},{"$f":"'INPUT-Checklist'!D10","v":172.5},{"$f":"120/C18","v":0.69565217391304346},{"$f":"(E18*'INPUT-Checklist'!D10)/120","v":1}]
[]
[]
[]
["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":"Group type 1"},{"$f":"'INPUT-Data'!D12","v":"-"}]
[{"$f":"'INPUT-Data'!B13","v":"Group type 2"},{"$f":"'INPUT-Data'!D13","v":"-"}]
[{"$f":"'INPUT-Data'!B14","v":"Group type 3"},{"$f":"'INPUT-Data'!D14","v":"-"}]
[{"$f":"'INPUT-Data'!B15","v":"Group type 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":[[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],[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]]}
{"$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":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Impact","Score YES","Score NO"]
["Positive impact is very likely",5,1]
["Positive impact possible",2,1]
["No impact likely",1,1]
["Negative impact possible",-2,4]
["Negative impact very likely",-5,5]
[]
["Weighting","Linear Multiplier"]
["High",1.5]
["Medium",1]
["Low",0.5]
[]
["Weighting","Linear Multiplier"]
["Yes",1]
["No",-1]
[]
["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"]