{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["READ ME","1 INPUT-Checklist","2 INPUT-Data","3 OUTPUT-Graphs","Translate","VERSION CONTROL","Reference"],"not_rendered":{"charts":4,"images":8,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"READ ME","index":0,"n_rows":81,"n_cols":7,"rows_kept":81,"cut":false,"hidden":false,"merged":[[33,3,33,8],[45,5,45,8],[10,3,10,5],[10,6,10,7],[26,3,26,8],[27,3,27,8],[28,3,28,8],[12,3,12,8],[17,3,17,8],[19,3,19,8],[25,3,25,8],[32,3,32,8],[20,3,23,8],[29,3,29,8],[30,3,30,8],[31,3,31,8],[46,3,47,4],[46,5,47,8],[35,3,37,5],[35,6,37,8],[38,3,40,5],[38,6,40,8],[41,3,42,5],[41,6,42,8],[44,3,44,8],[45,3,45,4],[80,3,80,5],[48,3,48,4],[48,5,48,7],[49,3,49,4],[49,5,49,8],[50,3,52,4],[50,5,51,8],[52,5,52,7],[53,3,53,4],[53,5,53,7],[55,3,62,8],[64,3,72,8],[74,3,78,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$18","v":"Select language"},null,null,"English"]
[]
[null,null,null,{"$f":"Translate!$C$19","v":"Read Me Sheet"}]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$20","v":"PROMOTE and INITIATE – Impact Assessment Tool"}]
[]
[null,null,null,{"$f":"Translate!$C$21","v":"Introduction"}]
[null,null,null,{"$f":"Translate!$C$22","v":"This tool provides a guide to the possible impacts of solar-powered irrigation systems on socio-economics and the 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 an 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,{"$f":"Translate!$C$23","v":"Tips & Tricks"}]
[null,null,null,{"$f":"Translate!$C$24","v":"● Make sure that macro is always enabled for the proper functioning of this tool  "}]
[null,null,null,{"$f":"Translate!$C$25","v":"● White cells contain drop down lists or are for free text entry to describe the basis of any decision made"}]
[null,null,null,{"$f":"Translate!$C$26","v":"● For the multilanguage option to work properly, do NOT delete sheets"}]
[null,null,null,{"$f":"Translate!$C$27","v":"● The user of this tool should provide YES or NO or NA answer to each of the questions of the 'Checklist' and weigh according to its importance to the project under assessment."}]
[null,null,null,{"$f":"Translate!$C$28","v":"● Make sure that this file is always saved as \".xlsm\"    \n"}]
[]
[null,null,null,{"$f":"Translate!$C$29","v":"Overview"}]
[null,null,null,{"$f":"Translate!$C$30","v":"This tool comprises the following sheet:"}]
[]
[null,null,null,{"$f":"Translate!$C$8","v":"1 INPUT-Checklist"},null,null,{"$f":"Translate!$C$31","v":"This sheet comprises 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 sheet."}]
[]
[]
[null,null,null,{"$f":"Translate!$C$9","v":"2 INPUT-Data"},null,null,{"$f":"Translate!$C$32","v":"This sheet allows for the entry of data that gives an overview of beneficiaries of the project. The values generate graphs for the OUTPUT sheet."}]
[]
[]
[null,null,null,{"$f":"Translate!$C$10","v":"3 OUTPUT-Graphs"},null,null,{"$f":"Translate!$C$33","v":"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,{"$f":"Translate!$C$34","v":"About"}]
[null,null,null,{"$f":"Translate!$C$35","v":"Published by: "},null,{"$f":"Translate!$C$41","v":"GIZ & FAO"}]
[null,null,null,{"$f":"Translate!$C$36","v":"Responsible:"},null,{"$f":"Translate!$C$42","v":"GIZ project \"Water and Energy for Food (WE4F)\""}]
[]
[null,null,null,{"$f":"Translate!$C$37","v":"Contact:"},null,"Powering.Agriculture@giz.de"]
[null,null,null,{"$f":"Translate!$C$38","v":"Download link:"},null,"https://energypedia.info/wiki/Toolbox_on_SPIS"]
[null,null,null,{"$f":"Translate!$C$39","v":"About:"},null,{"$f":"Translate!$C$43","v":"Water and Energy for Food Grand Challenge at:  "}]
[]
[null,null,null,null,null,"https://poweringag.org"]
[null,null,null,{"$f":"Translate!$C$40","v":"Version:"},null,{"$f":"Translate!$C$44","v":"3.0 (June 2021)"}]
[]
[null,null,null,{"$f":"Translate!$C$45","v":"The Toolbox on Solar Powered Irrigation Systems (SPIS) is a legacy project of 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 Corporation (OPIC) combined resources to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity.\n\nThe Toolbox on SPIS has now been embraced for further development by PAEGC's successor program Water and Energy for Food (WE4F). WE4F is a joint international initiative of the European Union (EU), German Federal Ministry for Economic Cooperation and Development (BMZ), the Ministry of Foreign Affairs of the Kingdom of the Netherlands, Sweden through the Swedish International Development Cooperation Agency (Sida), and the U.S. Agency for International Development (USAID). WE4F aims to increase food production along the value chain through a more sustainable and efficient usage of water and/or energy."}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$46","v":"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."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$47","v":"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,{"$f":"Translate!$C$48","v":"© GIZ and FAO, 2020"}]

{"sheet":"1 INPUT-Checklist","index":1,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":false,"merged":[[59,1,59,2],[91,1,91,2],[88,1,88,2],[89,1,89,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],[75,1,75,2],[86,1,86,2],[87,1,87,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[69,1,69,2],[81,1,81,2],[82,1,82,2],[68,1,68,6],[85,1,85,2],[83,1,83,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[70,1,70,2],[73,1,73,2],[74,1,74,2],[30,1,30,2],[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],[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],[24,1,24,2],[40,1,40,2],[29,1,29,2],[2,0,2,6],[7,4,7,5],[19,1,19,2],[20,1,20,2],[25,1,25,2],[26,1,26,2],[23,1,23,2],[22,5,22,6],[27,1,27,2],[28,1,28,2],[18,1,18,2],[21,1,21,2],[22,2,22,4],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[37,1,37,6],[42,1,42,2],[41,1,41,2],[43,1,43,2]]}
[null,{"$f":"Translate!C50","v":"PROMOTE and INITIATE – Impact Assessment Tool"}]
[{"$f":"Translate!$C$51","v":"SOCIO-ECONOMIC AND ENVIRONMENTAL IMPACTS"}]
[{"$f":"Translate!$C$52","v":"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":"SUMIF($D$16:$D$22,\"<>Reference!$A$16\",$H$16:$H$22)","v":52.5},{"$f":"Translate!$C$61","v":"Project Name:"},null,"sample"]
[null,2,{"$f":"B23","v":"Women's Role"},{"$f":"SUMIF($D$24:$D$37,\"<>Reference!$A$16\",$H$24:$H$37)","v":105},{"$f":"Translate!$C$62","v":"Project Location:"}]
[null,3,{"$f":"B38","v":"Minority and Indigene Groups"},{"$f":"SUMIF($D$39:$D$44,\"<>Reference!$A$16\",$H$39:$H$44)","v":45},{"$f":"Translate!$C$63","v":"User Name:"}]
[null,4,{"$f":"B45","v":"Income and Amenities"},{"$f":"SUMIF($D$46:$D$52,\"<>Reference!$A$16\",$H$46:$H$52)","v":52.5},{"$f":"Translate!$C$64","v":"Date of Impact Assessment:"}]
[null,5,{"$f":"B53","v":"Regional Effects in Country"},{"$f":"SUMIF($D$54:$D$62,\"<>Reference!$A$16\",$H$54:$H$62)","v":67.5},{"$f":"Translate!$C$65","v":"Project Duration (years):"}]
[null,6,{"$f":"B63","v":"User Involvement"},{"$f":"SUMIF($D$64:$D$68,\"<>Reference!$A$16\",$H$64:$H$68)","v":37.5},{"$f":"Translate!$C$66","v":"Asset Lifespan (years):"}]
[null,7,{"$f":"B69","v":"Natural Resources and Environment"},{"$f":"SUMIF($D$70:$D$92,\"<>Reference!$A$16\",$H$70:$H$92)","v":172.5},{"$f":"Translate!$C$67","v":"Notes:"}]
[null,null,{"$f":"Translate!C60","v":"SCORE"},{"$f":"SUM(D4+D7+D5+D6+D10+D8+D9)","v":532.5}]
[]
[]
[{"$f":"Translate!$C$68","v":"Ref #"},{"$f":"Translate!$C$69","v":"Question"},null,{"$f":"Translate!$C$70","v":"Yes, No or N/A "},{"$f":"Translate!$C$71","v":"Weighting \n(how important is this to the project?)"},{"$f":"Translate!$C$72","v":"What is the impact of the project?"},{"$f":"Translate!$C$73","v":"Comments"}]
[1,{"$f":"Translate!$C$53","v":"Population Change and Migration"}]
["1a",{"$f":"Translate!$C$74","v":"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=Reference!$A$16,Reference!$A$16,IF(D16=Reference!$A$14,(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",{"$f":"Translate!$C$75","v":"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=Reference!$A$16,Reference!$A$16,IF(D17=Reference!$A$14,(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",{"$f":"Translate!$C$76","v":"Is the project avoiding the physical and economic displacement of people?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D18=Reference!$A$16,Reference!$A$16,IF(D18=Reference!$A$14,(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",{"$f":"Translate!$C$77","v":"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=Reference!$A$16,Reference!$A$16,IF(D19=Reference!$A$14,(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",{"$f":"Translate!$C$78","v":"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=Reference!$A$16,Reference!$A$16,IF(D20=Reference!$A$14,(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",{"$f":"Translate!$C$79","v":"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=Reference!$A$16,Reference!$A$16,IF(D21=Reference!$A$14,(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",{"$f":"Translate!$C$80","v":"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=Reference!$A$16,Reference!$A$16,IF(D22=Reference!$A$14,(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,{"$f":"Translate!$C$54","v":"Women's Role"},{"$f":"Translate!$C$81","v":"for more in-depth questions and aspects to consider please see:"},null,null,"http://www.fao.org/docrep/017/i3173e/i3173e.pdf"]
["2a",{"$f":"Translate!$C$82","v":"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=Reference!$A$16,Reference!$A$16,IF(D24=Reference!$A$14,(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",{"$f":"Translate!$C$83","v":"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=Reference!$A$16,Reference!$A$16,IF(D25=Reference!$A$14,(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",{"$f":"Translate!$C$84","v":"Does the project change the status and role of women positively in relation to workload?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D26=Reference!$A$16,Reference!$A$16,IF(D26=Reference!$A$14,(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",{"$f":"Translate!$C$85","v":"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=Reference!$A$16,Reference!$A$16,IF(D27=Reference!$A$14,(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",{"$f":"Translate!$C$86","v":"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=Reference!$A$16,Reference!$A$16,IF(D28=Reference!$A$14,(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",{"$f":"Translate!$C$87","v":"Does the project change the status and role of women positively in relation to marital rights?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D29=Reference!$A$16,Reference!$A$16,IF(D29=Reference!$A$14,(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",{"$f":"Translate!$C$88","v":"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=Reference!$A$16,Reference!$A$16,IF(D30=Reference!$A$14,(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",{"$f":"Translate!$C$89","v":"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=Reference!$A$16,Reference!$A$16,IF(D31=Reference!$A$14,(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",{"$f":"Translate!$C$90","v":"Does the project allow for reduced time burden on women and minority groups allowing for the pursuit of other activities such as education and leisure?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D32=Reference!$A$16,Reference!$A$16,IF(D32=Reference!$A$14,(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",{"$f":"Translate!$C$91","v":"Does the project establish dispute resolution mechanisms that are gender-balanced?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D33=Reference!$A$16,Reference!$A$16,IF(D33=Reference!$A$14,(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",{"$f":"Translate!$C$92","v":"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=Reference!$A$16,Reference!$A$16,IF(D34=Reference!$A$14,(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",{"$f":"Translate!$C$93","v":"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=Reference!$A$16,Reference!$A$16,IF(D35=Reference!$A$14,(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",{"$f":"Translate!$C$94","v":"Will the right to the irrigation system and the right to irrigate affect the land register or land ownership status?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D36=Reference!$A$16,Reference!$A$16,IF(D36=Reference!$A$14,(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",{"$f":"Translate!$C$95","v":"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=Reference!$A$16,Reference!$A$16,IF(D37=Reference!$A$14,(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,{"$f":"Translate!$C$55","v":"Minority and Indigene Groups"}]
["3a",{"$f":"Translate!$C$96","v":"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=Reference!$A$16,Reference!$A$16,IF(D39=Reference!$A$14,(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",{"$f":"Translate!$C$97","v":"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=Reference!$A$16,Reference!$A$16,IF(D40=Reference!$A$14,(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",{"$f":"Translate!$C$98","v":"Does the project address equal opportunities for minority groups?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D41=Reference!$A$16,Reference!$A$16,IF(D41=Reference!$A$14,(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",{"$f":"Translate!$C$99","v":"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=Reference!$A$16,Reference!$A$16,IF(D42=Reference!$A$14,(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",{"$f":"Translate!$C$100","v":"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=Reference!$A$16,Reference!$A$16,IF(D43=Reference!$A$14,(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",{"$f":"Translate!$C$101","v":"Is the project designed to be sensitive to cultural heritage issues?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D44=Reference!$A$16,Reference!$A$16,IF(D44=Reference!$A$14,(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,{"$f":"Translate!$C$56","v":"Income and Amenities"}]
["4a",{"$f":"Translate!$C$102","v":"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=Reference!$A$16,Reference!$A$16,IF(D46=Reference!$A$14,(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",{"$f":"Translate!$C$103","v":"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=Reference!$A$16,Reference!$A$16,IF(D47=Reference!$A$14,(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",{"$f":"Translate!$C$104","v":"Does the project impact 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=Reference!$A$16,Reference!$A$16,IF(D48=Reference!$A$14,(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",{"$f":"Translate!$C$105","v":"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=Reference!$A$16,Reference!$A$16,IF(D49=Reference!$A$14,(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",{"$f":"Translate!$C$106","v":"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=Reference!$A$16,Reference!$A$16,IF(D50=Reference!$A$14,(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",{"$f":"Translate!$C$107","v":"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=Reference!$A$16,Reference!$A$16,IF(D51=Reference!$A$14,(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",{"$f":"Translate!$C$108","v":"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=Reference!$A$16,Reference!$A$16,IF(D52=Reference!$A$14,(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,{"$f":"Translate!$C$57","v":"Regional Effects in Country"}]
["5a",{"$f":"Translate!$C$109","v":"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=Reference!$A$16,Reference!$A$16,IF(D54=Reference!$A$14,(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",{"$f":"Translate!$C$110","v":"Have impacts on institutional efficiency at the local and regional leves been considered? (regulatory framework, informal relationships, steering mechanisms)"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D55=Reference!$A$16,Reference!$A$16,IF(D55=Reference!$A$14,(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",{"$f":"Translate!$C$111","v":"Have impacts on the viability of land holdings, land rights, and water rights been considered?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D56=Reference!$A$16,Reference!$A$16,IF(D56=Reference!$A$14,(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",{"$f":"Translate!$C$112","v":"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=Reference!$A$16,Reference!$A$16,IF(D57=Reference!$A$14,(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",{"$f":"Translate!$C$113","v":"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=Reference!$A$16,Reference!$A$16,IF(D58=Reference!$A$14,(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",{"$f":"Translate!$C$114","v":"Is there a positive 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=Reference!$A$16,Reference!$A$16,IF(D59=Reference!$A$14,(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",{"$f":"Translate!$C$115","v":"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=Reference!$A$16,Reference!$A$16,IF(D60=Reference!$A$14,(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",{"$f":"Translate!$C$116","v":"Has an 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=Reference!$A$16,Reference!$A$16,IF(D61=Reference!$A$14,(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",{"$f":"Translate!$C$117","v":"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=Reference!$A$16,Reference!$A$16,IF(D62=Reference!$A$14,(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,{"$f":"Translate!$C$58","v":"User Involvement"}]
["6a",{"$f":"Translate!$C$118","v":"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=Reference!$A$16,Reference!$A$16,IF(D64=Reference!$A$14,(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",{"$f":"Translate!$C$119","v":"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=Reference!$A$16,Reference!$A$16,IF(D65=Reference!$A$14,(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",{"$f":"Translate!$C$120","v":"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=Reference!$A$16,Reference!$A$16,IF(D66=Reference!$A$14,(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",{"$f":"Translate!$C$121","v":"Will training be provided to local populations?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D67=Reference!$A$16,Reference!$A$16,IF(D67=Reference!$A$14,(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",{"$f":"Translate!$C$122","v":"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=Reference!$A$16,Reference!$A$16,IF(D68=Reference!$A$14,(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,{"$f":"Translate!$C$59","v":"Natural Resources and Environment"}]
["7a",{"$f":"Translate!$C$123","v":"Has the impact of increased evapotranspiration been considered?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D70=Reference!$A$16,Reference!$A$16,IF(D70=Reference!$A$14,(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",{"$f":"Translate!$C$124","v":"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=Reference!$A$16,Reference!$A$16,IF(D71=Reference!$A$14,(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",{"$f":"Translate!$C$125","v":"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=Reference!$A$16,Reference!$A$16,IF(D72=Reference!$A$14,(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",{"$f":"Translate!$C$126","v":"Has saline intrusion into groundwater along the coastal regions been considered?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D73=Reference!$A$16,Reference!$A$16,IF(D73=Reference!$A$14,(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",{"$f":"Translate!$C$127","v":"Have reduced base flows on groundwater availability been assessed?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D74=Reference!$A$16,Reference!$A$16,IF(D74=Reference!$A$14,(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",{"$f":"Translate!$C$128","v":"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=Reference!$A$16,Reference!$A$16,IF(D75=Reference!$A$14,(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",{"$f":"Translate!$C$129","v":"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=Reference!$A$16,Reference!$A$16,IF(D76=Reference!$A$14,(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",{"$f":"Translate!$C$130","v":"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=Reference!$A$16,Reference!$A$16,IF(D77=Reference!$A$14,(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",{"$f":"Translate!$C$131","v":"Has the impact on the degradation of the land through salinization been assessed?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D78=Reference!$A$16,Reference!$A$16,IF(D78=Reference!$A$14,(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",{"$f":"Translate!$C$132","v":"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=Reference!$A$16,Reference!$A$16,IF(D79=Reference!$A$14,(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",{"$f":"Translate!$C$133","v":"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=Reference!$A$16,Reference!$A$16,IF(D80=Reference!$A$14,(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",{"$f":"Translate!$C$134","v":"Has the project's 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=Reference!$A$16,Reference!$A$16,IF(D81=Reference!$A$14,(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",{"$f":"Translate!$C$135","v":"Has the project's 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=Reference!$A$16,Reference!$A$16,IF(D82=Reference!$A$14,(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",{"$f":"Translate!$C$136","v":"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=Reference!$A$16,Reference!$A$16,IF(D83=Reference!$A$14,(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",{"$f":"Translate!$C$137","v":"Does the project include the usage of non-conventional sources of water (i.e. wastewater)?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D84=Reference!$A$16,Reference!$A$16,IF(D84=Reference!$A$14,(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",{"$f":"Translate!$C$138","v":"Has the impact of a dam been considered?"},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D85=Reference!$A$16,Reference!$A$16,IF(D85=Reference!$A$14,(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",{"$f":"Translate!$C$139","v":"Has the project's 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=Reference!$A$16,Reference!$A$16,IF(D86=Reference!$A$14,(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",{"$f":"Translate!$C$140","v":"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=Reference!$A$16,Reference!$A$16,IF(D87=Reference!$A$14,(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",{"$f":"Translate!$C$141","v":"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=Reference!$A$16,Reference!$A$16,IF(D88=Reference!$A$14,(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",{"$f":"Translate!$C$142","v":"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=Reference!$A$16,Reference!$A$16,IF(D89=Reference!$A$14,(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",{"$f":"Translate!$C$143","v":"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=Reference!$A$16,Reference!$A$16,IF(D90=Reference!$A$14,(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",{"$f":"Translate!$C$144","v":"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=Reference!$A$16,Reference!$A$16,IF(D91=Reference!$A$14,(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",{"$f":"Translate!$C$145","v":"Is there a collection system in place to collect agricultural plastics (pipes, reservoirs, mulch, tunnels, greenhouse, silage, crates, fittings, nets, drippers...) in the project area? "},null,"Yes","High","Positive impact is very likely",null,{"$f":"IFERROR(IF(D92=Reference!$A$16,Reference!$A$16,IF(D92=Reference!$A$14,(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":"2 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]]}
[{"$f":"Translate!$C$158","v":"PROMOTE and INITIATE – Impact Assessment Tool"}]
[{"$f":"Translate!$C$159","v":"SOCIO-ECONOMIC DATA"}]
[{"$f":"Translate!$C$160","v":"Ref #"},{"$f":"Translate!$C$161","v":"Question"},{"$f":"Translate!$C$162","v":"ABSOLUTE NUMBER"},{"$f":"Translate!$C$163","v":"PERCENTAGE [%]"},{"$f":"Translate!$C$164","v":"USER COMMENTS"},{"$f":"Translate!$C$165","v":"PROJECT REVIEWER COMMENTS"}]
["A1.0",{"$f":"Translate!$C$166","v":"What is the population in the vicinity of the project?\n"}]
["A1.1",{"$f":"Translate!$C$167","v":"How many will be impacted by the project?\n"},null,{"$f":"IFERROR(C5/C4,\"-\")","v":"-"}]
["A1.2",{"$f":"Translate!$C$168","v":"How many farmers will be impacted by the project?\n"},null,{"$f":"IFERROR(C6/C5,\"-\")","v":"-"}]
[null,{"$f":"Translate!$C$169","v":"TOTAL"},{"$f":"SUM(C5:C6)","v":0},{"$f":"C7/C4","v":{"$error":"#DIV/0!"}}]
["A2.0",{"$f":"Translate!$C$170","v":"What is the breakdown of farmers benefitting from the project by gender, socioeconomic delineation, and income?"}]
["A2.1",{"$f":"Translate!$C$171","v":"Male"},null,{"$f":"IFERROR(C9/(C9+C10),\"-\")","v":"-"}]
["A2.2",{"$f":"Translate!$C$172","v":"Female"},null,{"$f":"IFERROR(C10/(C9+C10),\"-\")","v":"-"}]
[null,{"$f":"Translate!$C$169","v":"TOTAL"},{"$f":"SUM(C9:C10)","v":0},{"$f":"C11/C6","v":{"$error":"#DIV/0!"}}]
["A2.3",{"$f":"Translate!$C$173","v":"Group type 1"},null,{"$f":"IFERROR(C12/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
["A2.4",{"$f":"Translate!$C$174","v":"Group type 2"},null,{"$f":"IFERROR(C13/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
["A2.5",{"$f":"Translate!$C$175","v":"Group type 3"},null,{"$f":"IFERROR(C14/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
["A2.6",{"$f":"Translate!$C$176","v":"Group type 4"},null,{"$f":"IFERROR(C15/($C$12+$C$13+$C$14+$C$15),\"-\")","v":"-"}]
[null,{"$f":"Translate!$C$169","v":"TOTAL"},{"$f":"SUM(C12:C15)","v":0},{"$f":"C16/C6","v":{"$error":"#DIV/0!"}}]
["A2.7",{"$f":"Translate!$C$177","v":"Unemployed"},null,{"$f":"IFERROR(C17/(C9+C10),\"-\")","v":"-"}]
["A2.8",{"$f":"Translate!$C$178","v":"Below poverty line"},null,{"$f":"IFERROR(C18/(C9+C10),\"-\")","v":"-"}]
[null,{"$f":"Translate!$C$169","v":"TOTAL"},{"$f":"SUM(C17:C18)","v":0},{"$f":"C19/C11","v":{"$error":"#DIV/0!"}}]
["A3.0",{"$f":"Translate!$C$179","v":"Where are farmers benefitting recruited from?"}]
["A3.1",{"$f":"Translate!$C$180","v":"Local in the village"},null,{"$f":"IFERROR(C21/($C$21+$C$22+$C$23+$C$24),\"-\")","v":"-"}]
["A3.2",{"$f":"Translate!$C$181","v":"Local resettled"},null,{"$f":"IFERROR(C22/($C$21+$C$22+$C$23+$C$24),\"-\")","v":"-"}]
["A3.3",{"$f":"Translate!$C$182","v":"Same sociological background from elsewhere"},null,{"$f":"IFERROR(C23/($C$21+$C$22+$C$23+$C$24),\"-\")","v":"-"}]
["A3.4",{"$f":"Translate!$C$183","v":"Different sociological background"},null,{"$f":"IFERROR(C24/($C$21+$C$22+$C$23+$C$24),\"-\")","v":"-"}]
[null,{"$f":"Translate!$C$169","v":"TOTAL"},{"$f":"SUM(C21:C24)","v":0},{"$f":"C25/C6","v":{"$error":"#DIV/0!"}}]
["A4.0",{"$f":"Translate!$C$184","v":"What are the labour requirements of the project?"}]
["A4.1",{"$f":"Translate!$C$185","v":"Family labour"},null,{"$f":"IFERROR(C27/($C$27+$C$28+$C$29+$C$30),\"-\")","v":"-"}]
["A4.2",{"$f":"Translate!$C$186","v":"Local labour"},null,{"$f":"IFERROR(C28/($C$27+$C$28+$C$29+$C$30),\"-\")","v":"-"}]
["A4.3",{"$f":"Translate!$C$187","v":"Seasonal local labour"},null,{"$f":"IFERROR(C29/($C$27+$C$28+$C$29+$C$30),\"-\")","v":"-"}]
["A4.4",{"$f":"Translate!$C$188","v":"Seasonal labour from afar"},null,{"$f":"IFERROR(C30/($C$27+$C$28+$C$29+$C$30),\"-\")","v":"-"}]
[null,{"$f":"Translate!$C$169","v":"TOTAL"},{"$f":"SUM(C27:C30)","v":0},{"$f":"C31/C6","v":{"$error":"#DIV/0!"}}]
["A5.0",{"$f":"Translate!$C$189","v":"How many people lose traditional means of subsistence (not those in the project)?"},null,{"$f":"Translate!$C$194","v":"per year"}]
[]
["A6.0",{"$f":"Translate!$C$190","v":"How many jobs are created by the project?"},null,{"$f":"Translate!$C$194","v":"per year"}]
["A6.1",{"$f":"Translate!$C$191","v":"How many years are they expected to last?"},null,{"$f":"Translate!$C$195","v":"years"}]
[]
["A7.0",{"$f":"Translate!$C$192","v":"What are the estimated population growth numbers over the life of the assets?"},null,"%"]
["A7.1",{"$f":"Translate!$C$193","v":"What are the estimated migrant proportion due to the project over the life of the assets?"},null,"%"]
[]
["A8.0",{"$f":"Translate!$C$196","v":"What is the tenure breakdown of the farmers?"}]
["A8.1",{"$f":"Translate!$C$197","v":"Landowner"},null,{"$f":"IFERROR(C41/($C$41+$C$42+$C$43+$C$44),\"-\")","v":"-"}]
["A8.2",{"$f":"Translate!$C$198","v":"Tenant farmer"},null,{"$f":"IFERROR(C42/($C$41+$C$42+$C$43+$C$44),\"-\")","v":"-"}]
["A8.3",{"$f":"Translate!$C$199","v":"Tenant farmer on government land"},null,{"$f":"IFERROR(C43/($C$41+$C$42+$C$43+$C$44),\"-\")","v":"-"}]
["A8.4",{"$f":"Translate!$C$200","v":"Worker / Labourer"},null,{"$f":"IFERROR(C44/($C$41+$C$42+$C$43+$C$44),\"-\")","v":"-"}]
[null,{"$f":"Translate!$C$169","v":"TOTAL"},{"$f":"SUM(C41:C44)","v":0},{"$f":"C45/C6","v":{"$error":"#DIV/0!"}}]

{"sheet":"3 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],[3,7,3,11],[4,7,4,11],[5,7,5,11]]}
[null,{"$f":"Translate!$C$202","v":"PROMOTE and INITIATE – Impact Assessment Tool"}]
[]
[]
[{"$f":"'1 INPUT-Checklist'!E4","v":"Project Name:"},{"$f":"'1 INPUT-Checklist'!G4","v":"sample"},null,null,null,null,null,{"$f":"'1 INPUT-Checklist'!E7","v":"Date of Impact Assessment:"},null,null,null,null,{"$f":"'1 INPUT-Checklist'!G7","v":0}]
[{"$f":"'1 INPUT-Checklist'!E5","v":"Project Location:"},{"$f":"'1 INPUT-Checklist'!G5","v":0},null,null,null,null,null,{"$f":"'1 INPUT-Checklist'!E8","v":"Project Duration (years):"},null,null,null,null,{"$f":"'1 INPUT-Checklist'!G8","v":0}]
[{"$f":"'1 INPUT-Checklist'!E6","v":"User Name:"},{"$f":"'1 INPUT-Checklist'!G6","v":0},null,null,null,null,null,{"$f":"'1 INPUT-Checklist'!E9","v":"Asset Lifespan (years):"},null,null,null,null,{"$f":"'1 INPUT-Checklist'!G9","v":0}]
[]
[]
[]
[]
[null,"Lowest score possible","Highest possible score","Actual Score","correction factor","% Reached",null,"<>N/A"]
[{"$f":"'1 INPUT-Checklist'!C4","v":"Population Change and Migration"},{"$f":"H12*-7.5","v":-52.5},{"$f":"H12*7.5","v":52.5},{"$f":"'1 INPUT-Checklist'!D4","v":52.5},{"$f":"120/C12","v":2.2857142857142856},{"$f":"(E12*'1 INPUT-Checklist'!D4)/120","v":1},null,{"$f":"COUNTIF('1 INPUT-Checklist'!$H$16:$H$22,\"<>N/A\")","v":7}]
[{"$f":"'1 INPUT-Checklist'!C5","v":"Women's Role"},{"$f":"H13*-7.5","v":-105},{"$f":"H13*7.5","v":105},{"$f":"'1 INPUT-Checklist'!D5","v":105},{"$f":"120/C13","v":1.1428571428571428},{"$f":"(E13*'1 INPUT-Checklist'!D5)/120","v":1},null,{"$f":"COUNTIF('1 INPUT-Checklist'!$H$24:$H$37,\"<>N/A\")","v":14}]
[{"$f":"'1 INPUT-Checklist'!C6","v":"Minority and Indigene Groups"},-45,{"$f":"H14*7.5","v":45},{"$f":"'1 INPUT-Checklist'!D6","v":45},2.6666666666666665,{"$f":"(E14*'1 INPUT-Checklist'!D6)/120","v":1},null,{"$f":"COUNTIF('1 INPUT-Checklist'!$H$39:$H$44,\"<>N/A\")","v":6}]
[{"$f":"'1 INPUT-Checklist'!C7","v":"Income and Amenities"},-52.5,{"$f":"H15*7.5","v":52.5},{"$f":"'1 INPUT-Checklist'!D7","v":52.5},2.2857142857142856,{"$f":"(E15*'1 INPUT-Checklist'!D7)/120","v":1},null,{"$f":"COUNTIF('1 INPUT-Checklist'!$H$46:$H$52,\"<>N/A\")","v":7}]
[{"$f":"'1 INPUT-Checklist'!C8","v":"Regional Effects in Country"},-67.5,67.5,{"$f":"'1 INPUT-Checklist'!D8","v":67.5},1.7777777777777777,{"$f":"(E16*'1 INPUT-Checklist'!D8)/120","v":1},null,{"$f":"COUNTIF('1 INPUT-Checklist'!$H$54:$H$62,\"<>N/A\")","v":9}]
[{"$f":"'1 INPUT-Checklist'!C9","v":"User Involvement"},-37.5,37.5,{"$f":"'1 INPUT-Checklist'!D9","v":37.5},3.2,{"$f":"(E17*'1 INPUT-Checklist'!D9)/120","v":1},null,{"$f":"COUNTIF('1 INPUT-Checklist'!$H$64:$H$68,\"<>N/A\")","v":5}]
[{"$f":"'1 INPUT-Checklist'!C10","v":"Natural Resources and Environment"},-172.5,172.5,{"$f":"'1 INPUT-Checklist'!D10","v":172.5},{"$f":"120/C18","v":0.69565217391304346},{"$f":"(E18*'1 INPUT-Checklist'!D10)/120","v":1},null,{"$f":"COUNTIF('1 INPUT-Checklist'!$H$70:$H$92,\"<>N/A\")","v":23}]
[]
[]
[]
["Gender and Socioeconomic Spread of Project Beneficiaries"]
[]
[{"$f":"'2 INPUT-Data'!B9","v":"Male"},{"$f":"'2 INPUT-Data'!D9","v":"-"}]
[{"$f":"'2 INPUT-Data'!B10","v":"Female"},{"$f":"'2 INPUT-Data'!D10","v":"-"}]
[{"$f":"'2 INPUT-Data'!B12","v":"Group type 1"},{"$f":"'2 INPUT-Data'!D12","v":"-"}]
[{"$f":"'2 INPUT-Data'!B13","v":"Group type 2"},{"$f":"'2 INPUT-Data'!D13","v":"-"}]
[{"$f":"'2 INPUT-Data'!B14","v":"Group type 3"},{"$f":"'2 INPUT-Data'!D14","v":"-"}]
[{"$f":"'2 INPUT-Data'!B15","v":"Group type 4"},{"$f":"'2 INPUT-Data'!D15","v":"-"}]
[{"$f":"'2 INPUT-Data'!B41","v":"Landowner"},{"$f":"'2 INPUT-Data'!D41","v":"-"}]
[{"$f":"'2 INPUT-Data'!B42","v":"Tenant farmer"},{"$f":"'2 INPUT-Data'!D42","v":"-"}]
[{"$f":"'2 INPUT-Data'!B43","v":"Tenant farmer on government land"},{"$f":"'2 INPUT-Data'!D43","v":"-"}]
[{"$f":"'2 INPUT-Data'!B44","v":"Worker / Labourer"},{"$f":"'2 INPUT-Data'!D44","v":"-"}]

{"sheet":"Translate","index":4,"n_rows":300,"n_cols":7,"rows_kept":300,"cut":false,"hidden":false,"merged":[[1,1,2,2],[4,1,4,8],[6,1,10,1]]}
[]
[null,{"$f":"$C$13","v":"Do not modify this sheet"}]
[]
[]
[null,{"$f":"$C$14","v":"Reference Row"}]
[null,{"$f":"$C$15","v":"Selected Language:"},{"$f":"'READ ME'!$G$11","v":"English"},"English","Français","Español","العربية"]
[null,{"$f":"$C$16","v":"Sheet name"},{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"READ ME"},"READ ME","LISER MOI","LÉEME","اقرأ هذه الصفحة"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"1 INPUT-Checklist"},"1 INPUT-Checklist","1 ENTRÉES-Fiche de controle","1 ENTRADA-Lista de verificación","1 المدخلات - قائمة التحقق"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"2 INPUT-Data"},"2 INPUT-Data","ENTRÉES-Données","2 ENTRADA-Datos","2 المدخلات - البيانات"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"3 OUTPUT-Graphs"},"3 OUTPUT-Graphs","SORTIES-Graphiques","3 SÁLIDA-Gráficos","3 النتائج - الرسوم البيانية"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"Translate"},"Translate","Traduire","Traducción","ترجمة"]
[]
[null,{"$f":"$C$11","v":"Translate"},{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"Do not modify this sheet"},"Do not modify this sheet","Ne modifiez pas cette feuille","No modifique esta hoja","لا تعدل هذه الصفحة"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"Reference Row"},"Reference Row","Ligne de référence","Fila de referencia","صف مرجعي"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"Selected Language:"},"Selected Language:","Langue sélectionnée:","Idioma seleccionado:","اللغة المختارة:"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"Sheet name"},"Sheet name","Nom de la feuille","Nombre de la hoja","اسم الصفحة"]
[]
[null,{"$f":"$C$7","v":"READ ME"},{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"Select language"},"Select language","Sélectionner la langue","Seleccione el idioma","اختار اللغة"]
[null,null,"Read Me Sheet","Read Me Sheet","Feuille Lisez-moi","Léeme","اقرأ هذه الصفحة"]
[null,null,"PROMOTE and INITIATE – Impact Assessment Tool","PROMOTE and INITIATE – Impact Assessment Tool","PROMOTION et INITIATION - Outil d’évaluation d’impact","PROMUEVE – Herramienta de evaluación de impacto","الترويج و المبادرة - أداة تقييم الأثر"]
[null,null,"Introduction","Introduction","Introduction","Introducción","مقدمة"]
[null,null,"This tool provides a guide to the possible impacts of solar-powered irrigation systems on socio-economics and the 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 an 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.","This tool provides a guide to the possible impacts of solar-powered irrigation systems on socio-economics and the 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 an 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.","Cet outil fournit un guide sur les impacts possibles des systèmes d’irrigation à énergie solaire sur les aspects socioéconomiques et environnementaux. Les impacts peuvent être considérés comme positifs, neutres ou négatifs. Les impacts sont regroupés dans les domaines suivants:\n1. Changement de population et migration\n2. Le rôle des femmes\n3. Groupes minoritaires et autochtones\n4. Revenu et commodité\n5. Effets régionaux dans le pays\n6. Participation de l'utilisateur\n7. Ressources naturelles et environnement\nEn utilisant la liste de contrôle, les conseillers SPIS peuvent s'impliquer davantage dans l'évaluation des changements socio-économiques et environnementaux et dans la planification de l'atténuation des impacts négatifs. La liste de contrôle devrait permettre une utilisation plus efficace des compétences spécialisées et favoriserait une coopération plus étroite entre spécialistes et non spécialistes dans le développement de projets durables sur les plans social, économique et environnemental.\n\nLa liste de contrôle peut déjà être utilisée dans la conception d’un système SPIS ainsi qu’après son installation et son utilisation (par exemple 6 mois, 2 ans et 5 ans) pour une surveillance continue. Cet outil est particulièrement utile pour les modules PROMOTION et INITIATION de la boîte à outils SPIS.","Esta herramienta proporciona una guía sobre los posibles impactos de los sistemas de riego con energía solar en los aspectos socioeconómicos y ambientales. Los impactos pueden considerarse positivos, neutrales o negativos. Los impactos se agrupan en las siguientes áreas temáticas:\n1. Cambio de población y migración\n2. Papel de la mujer\n3. Grupos minoritarios e indígenas\n4. Ingresos y amenidad\n5. Efectos regionales en el país\n6. Participación del usuario\n7. Recursos naturales y el medio ambiente\nAl utilizar la lista de verificación, los asesores de SPIS pueden involucrarse más en la evaluación del cambio socioeconómico y ambiental y en la planificación de la mitigación de los impactos adversos. La lista de verificación permite que la experiencia especialista se use con mayor eficacia y promoverá una cooperación más estrecha entre especialistas y no especialistas en el desarrollo de proyectos sociales, económicos y ambientalmente sostenibles.\n\nLa lista de verificación ya se puede utilizar durante el diseño de un sistema SPIS, así como después de que se haya instalado y utilizado el SPIS, asegurando un seguimiento continuo. La herramienta es particularmente relevante para el Módulo PROMUEVE de la caja de herramientas de SPIS.","توفر هذه الأداة دليلًا للتأثيرات المحتملة لأنظمة الري التي تعمل بالطاقة الشمسية (SPIS) على الاقتصاد الاجتماعي والبيئة. يمكن اعتبار التأثيرات إيجابية أو محايدة أو سلبية. التأثيرات مجمعة تحت مجالات الموضوعات التالية:\n1. التغيير السكاني والهجرة\n2. دور المرأة\n3. الأقليات والجماعات الأصلية\n4. الدخل والمرافق\n5. التأثيرات الإقليمية في البلد\n6. مشاركة المستخدم\n7. الموارد الطبيعية والبيئة\nباستخدام القائمة المرجعية ، يمكن لمستشاري SPIS أن يصبحوا أكثر انخراطًا في تقييم التغير الاجتماعي والاقتصادي والبيئي وفي التخطيط للتخفيف من الآثار السلبية. من الممكن أن تتيح قائمة المراجعة استخدام الخبرة المتخصصة بشكل أكثر فعالية وأن تعزز التعاون الوثيق بين المتخصصين وغير المتخصصين في تطوير المشاريع المستدامة اجتماعيا واقتصاديا وبيئيا.\n\nيمكن استخدام القائمة المرجعية بالفعل في تصميم نظام SPIS وكذلك بعد تثبيت واستخدام SPIS (على سبيل المثال 6 أشهر وسنتين و 5 سنوات) للمراقبة المستمرة. الأداة مناسبة بشكل خاص لوحدة الترويج (التشجيع) و المبادرة لترويج الوحدة لصندوق الأدوات لأنظمة الريّ بالطاقة الشمسية."]
[null,null,"Tips & Tricks","Tips & Tricks","Conseils et Astuces","Consejos y trucos","نصائح وحيل"]
[null,null,"● Make sure that macro is always enabled for the proper functioning of this tool  ","● Make sure that macro is always enabled for the proper functioning of this tool  ","● Assurez-vous que les macros sont toujours activées pour le bon fonctionnement de cet outil ","● Asegúrese de que la macro esté siempre habilitada para el correcto funcionamiento de esta herramienta.","● تأكد من تمكين الماكرو دائمًا من أجل حسن سير هذه الأداة"]
[null,null,"● White cells contain drop down lists or are for free text entry to describe the basis of any decision made","● White cells contain drop down lists or are for free text entry to describe the basis of any decision made","● Les cellules blanches contiennent des listes déroulantes ou permettent la saisie de texte libre pour décrire la base de toute décision prise.","● Las celdas blancas contienen listas desplegables o son para introducir texto libre para describir la base de cualquier decisión tomada","● تحتوي الخلايا البيضاء على قوائم منسدلة أو مخصصة لإدخال نصوص  لوصف أسس أي قرار تم اتخاذه"]
[null,null,"● For the multilanguage option to work properly, do NOT delete sheets","● For the multilanguage option to work properly, do NOT delete sheets","● Pour que l'option multilingue fonctionne correctement, ne supprimez PAS les feuilles","● Para que la opción de varios idiomas funcione correctamente, NO elimine las hojas.","● لكي يعمل خيار اللغات المتعددة بشكل صحيح ، لا تحذف الصفحات"]
[null,null,"● The user of this tool should provide YES or NO or NA answer to each of the questions of the 'Checklist' and weigh according to its importance to the project under assessment.","● The user of this tool should provide YES or NO or NA answer to each of the questions of the 'Checklist' and weigh according to its importance to the project under assessment.","● L'utilisateur de cet outil doit fournir une réponse OUI ou NON ou NA à chacune des questions de la «liste de contrôle» et peser en fonction de son importance pour le projet en cours d'évaluation. ","● El usuario de esta herramienta debe responder SÍ o NO o NA a cada una de las preguntas de la \"Lista de verificación\" y ponderarlas según su importancia para el proyecto que se evalúe.","● يجب على مستخدم هذه الأداة تقديم إجابات بنعم أو لا أو لا أجابة لكل سؤال من أسئلة \"قائمة التحقق\" وتقدير أهميتها للمشروع قيد التقييم."]
[null,null,"● Make sure that this file is always saved as \".xlsm\"    \n","● Make sure that this file is always saved as \".xlsm\"    \n","● Assurez-vous que ce fichier est toujours enregistré sous \".xlsm\"    \n","● Asegúrese de que este archivo siempre se guarde como \".xlsm\"","● تأكد من حفظ هذا الملف دائمًا باسم \".xlsm\""]
[null,null,"Overview","Overview","Aperçu","Sinopsis","نظرة عامة"]
[null,null,"This tool comprises the following sheet:","This tool comprises the following sheet:","Cet outil est composé des feuilles suivantes:","Esta herramienta incluye las siguientes hojas:","تتكون هذه الأداة من الصفحات التالية:"]
[null,null,"This sheet comprises 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 sheet.","This sheet comprises 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 sheet.","Cette fiche comprend des questions qui incitent le concepteur du SPIS à évaluer et à peser les aspects socio-économiques et environnementaux du projet. Les réponses génèrent des graphiques pour la feuille OUTPUT. ","Esta hoja incluye preguntas que llevan el diseñador del SPIS a evaluar y ponderar los aspectos socioeconómicos y ambientales del proyecto. Las repuestas generan gráficos que aparecen en la hoja de SALIDA.","تحتوي هذه الورقة على أسئلة تحث مصمم SPIS على تقييم وتقدير الجوانب الاجتماعية والاقتصادية والبيئية للمشروع. تقوم الإجابات بإنشاء رسوم بيانية لورقة النتائج."]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"This sheet allows for the entry of data that gives an overview of beneficiaries of the project. The values generate graphs for the OUTPUT sheet."},"This sheet allows for the entry of data that gives an overview of beneficiaries of the project. The values generate graphs for the OUTPUT sheet.","Cela permet de saisir des données qui donnent une vue d'ensemble des bénéficiaires du projet. Les valeurs génèrent des graphiques pour la feuille OUTPUT.","Esta hoja permite la entrada de datos para dar una visión general los los benificiarios del proyecto. Los valores generan gráficos que aparecen en la hoja SALIDA.","تسمح هذه الورقة بإدخال البيانات التي تعطي لمحة عامة عن المستفيدين من المشروع. تنشئ القيم رسومًا بيانية لورقة النتائج."]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"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."},"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.","Cette fiche contient des graphiques, générés par les fiches INPUT, qui peuvent être utilisés pour l'évaluation et dans des rapports plus larges pour démontrer les impacts socio-économiques et environnementaux du projet.","Esta hoja contiene gráficos, generados por las hojas de ENTRADA. Se pueden usar para la evaluación y en informes más aplios para demostrar los impactos socioeconómicos y ambientales del proyecto.","تحتوي هذه الورقة على رسوم بيانية تم إنشاؤها بواسطة ورقتي المدخلات التي يمكن استخدامها للتقييم وفي تقارير أوسع لإظهار الآثار الاجتماعية والاقتصادية والبيئية للمشروع."]
[null,null,"About","About","En savoir plus","Acerca de","حول"]
[null,null,"Published by: ","Published by: ","Publié par: ","Publicado por: ","نشرت من قبل:"]
[null,null,"Responsible:","Responsible:","Responsables:","Responsable:","مسؤول:"]
[null,null,"Contact:","Contact:","Contact:","Contacto: ","اتصال:"]
[null,null,"Download link:","Download link:","Lien de téléchargement:","Enlace descarga: ","رابط التحميل:"]
[null,null,"About:","About:","À propos de: ","Acerca de:","حول:"]
[null,null,"Version:","Version:","Version:","Versión:","إصدار:"]
[null,null,"GIZ & FAO","GIZ & FAO","GIZ et FAO","GIZ & FAO","الوكالة الألمانية للتعاون الدولي (GIZ) ومنظمة الأغذية والزراعة (FAO)"]
[null,null,"GIZ project \"Water and Energy for Food (WE4F)\"","GIZ project \"Water and Energy for Food (WE4F)\"","Projet de la GIZ « Les innovations dans l’agriculture et la production alimentaire protègent le climat (PEEPA/WE4F) » (Water and Energy for Food)","GIZ project \"Water and Energy for Food (WE4F)\"","مشروع الوكالة الألمانية للتعاون الدولي \"المياه والطاقة من أجل الغذاء Water and Energy for Food (WE4F)\""]
[null,null,"Water and Energy for Food Grand Challenge at:  ","Water and Energy for Food Grand Challenge at:  ","Eau et Energie pour l'Alimentation (PEEPA). Disponible à l’adresse :  ","Water and Energy for Food Grand Challenge at:  ","التحدي الكبير للمياه والطاقة من أجل الغذاء في:"]
[null,null,"3.0 (June 2021)","3.0 (June 2021)","3.0 (Juin 2021)","2.0 (Junio 2021)","3.0 (يونيو 2021)"]
[null,null,"The Toolbox on Solar Powered Irrigation Systems (SPIS) is a legacy project of 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 Corporation (OPIC) combined resources to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity.\n\nThe Toolbox on SPIS has now been embraced for further development by PAEGC's successor program Water and Energy for Food (WE4F). WE4F is a joint international initiative of the European Union (EU), German Federal Ministry for Economic Cooperation and Development (BMZ), the Ministry of Foreign Affairs of the Kingdom of the Netherlands, Sweden through the Swedish International Development Cooperation Agency (Sida), and the U.S. Agency for International Development (USAID). WE4F aims to increase food production along the value chain through a more sustainable and efficient usage of water and/or energy.","The Toolbox on Solar Powered Irrigation Systems (SPIS) is a legacy project of 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 Corporation (OPIC) combined resources to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity.\n\nThe Toolbox on SPIS has now been embraced for further development by PAEGC's successor program Water and Energy for Food (WE4F). WE4F is a joint international initiative of the European Union (EU), German Federal Ministry for Economic Cooperation and Development (BMZ), the Ministry of Foreign Affairs of the Kingdom of the Netherlands, Sweden through the Swedish International Development Cooperation Agency (Sida), and the U.S. Agency for International Development (USAID). WE4F aims to increase food production along the value chain through a more sustainable and efficient usage of water and/or energy.","La boîte à outils pour les systèmes d’irrigation à énergie solaire (Solar Powered Irrigation Systems, SPIS) est un projet hérité de l'initiative mondiale « Propulser l’agriculture : un grand défi énergétique pour le développement » (Powering Agriculture: An Energy Grand Challenge for Development – PAEGC). En 2012, l’Agence des États-Unis pour le développement international (USAID), l’Agence suédoise de coopération internationale au développement (Sida), le ministère fédéral allemand de la Coopération économique et du Développement (BMZ), Duke Energy et l’Overseas Private Investment Cooperation (OPIC) ont mis leurs ressources en commun pour soutenir des approches nouvelles et durables afin d'accélérer le développement et le déploiement des solutions énergétiques propres pour accroître la productivité agricole.\n\nLa boîte à outils sur les SPIS a maintenant été adoptée pour un développement ultérieur par le programme successeur du PAEGC, Eau et Energie pour l'Alimentation (PEEPA) - Water and Energy for Food (WE4F). WE4F/PEEPA est une initiative commune de l'Union européenne, du Ministère fédéral allemand de la coopération économique et du développement (BMZ), du Ministère des affaires étrangères du royaume des Pays-Bas, de l’Agence suédoise de développement (Sida) et de l’Agence de développement des États-Unis (USAID). WE4F/PEEPA vise à accroître la production alimentaire tout au long de la chaîne de valeur grâce à une utilisation plus durable et plus efficace de l'eau et/ou de l'énergie.","La publicación de la Caja de herramientas de sistemas de riego solar ha sido posible gracias al apoyo brindado por la iniciativa mundial Powering Agriculture: An Energy Grand Challenge for Development (PAEGC) (Energización Rural: Un gran desafío energético para el desarrollo). En 2012, la Agencia de los Estados Unidos para el Desarrollo Internacional (USAID), la Agencia Sueca de Cooperación Internacional para el Desarrollo (Sida), el Ministerio Federal de Cooperación Económica y Desarrollo (BMZ) de Alemania, la empresa de energía Duke Energy Corporation y la Corporación de Inversiones Privadas en el Extranjero (OPIC) juntaron recursos para crear la iniciativa PAEGC. El objetivo de PAEGC es fomentar nuevos enfoques sostenibles con el fin de acelerar el desarrollo y asegurar el establecimiento de energías limpias que incrementen la productividad y/o el valor de la agricultura en países en desarrollo y regiones emergentes sin acceso a fuentes de energía confiables, asequibles y limpias.","يعتبر صندوق الأدوات الخاص بأنظمة الري التي تعمل بالطاقة الشمسية (SPIS) مشروعًا هاما للمبادرة العالمية \"دعم الزراعة: تحدي الطاقة الكبير من أجل التنمية\" Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). في عام 2012 ، قامت الوكالة الأمريكية للتنمية الدولية (USAID) ، والوكالة السويدية للتعاون الإنمائي الدولي (ٍSida) ، والوزارة الفيدرالية الألمانية للتعاون الاقتصادي والتنمية (BMZ) ، وشركة Duke Energy ، ومؤسسة الاستثمار الخاص لما وراء البحار (OPIC) بجهود مشتركة لدعم الأساليب الجديدة والمستدامة لتسريع تطوير ونشر حلول الطاقة النظيفة لزيادة الإنتاجية الزراعية.\n\nتم اعتماد صندوق SPIS الآن لمزيد من التطوير من قبل البرنامج اللاحق لـ PAEGC \"الماء والطاقة من اجل الغذاء\" Water and Energy for Food (WE4F). الاخير هو مبادرة دولية مشتركة من الاتحاد الأوروبي (EU) ، والوزارة الاتحادية الألمانية للتعاون الاقتصادي والتنمية (BMZ) ، ووزارة الشؤون الخارجية لمملكة هولندا ، والسويد من خلال الوكالة السويدية للتعاون الإنمائي الدولي (Sida) ، والوكالة الأمريكية للتنمية الدولية (USAID). تهدف WE4F إلى زيادة إنتاج الغذاء على امتداد سلاسل القيمة الغذائية من خلال استخدام المياه و / أو الطاقة بطريقة أكثر استدامة وكفاءة."]
[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.","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.","Les appellations employées dans ce produit d’information et la présentation des documents qui y figurent n’impliquent de la part de la Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, de l’Organisation des Nations unies pour l’alimentation et l’agriculture (FAO) ou de l’un des partenaires fondateurs de l’initiative PAEGC aucune prise de position quant au statut juridique ou au stade de développement des pays, territoires, villes ou zones ou de leurs autorités, ni quant au tracé de leurs frontières ou limites. La mention de sociétés déterminées ou de produits de fabricants, qu’ils soient ou non brevetés, n’entraîne de la part de la GIZ, de la FAO ou de l’un des partenaires fondateurs du PAEGC aucune approbation ou recommandation desdits produits de préférence à d’autres de nature analogue qui ne sont pas cités. Les opinions exprimées dans ce produit d’information sont celles des auteurs et ne reflètent pas nécessairement celles de la GIZ, de la FAO, ou de l’un des partenaires fondateurs du PAEGC.","Las denominaciones empleadas y la presentación del material en este producto informativo no implican juicio alguno por parte de la Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, la Organización de las Naciones Unidas para la Alimentación y la Agricultura (FAO), o los socios fundadores de la iniciativa PAEGC, sobre la condición jurídica o el grado de desarrollo de ninguno de los países, territorios, ciudades o zonas citados o de sus autoridades, ni respecto de la delimitación de sus fronteras o límites. La mención de empresas o productos de fabricantes en particular, estén o no patentados, no implica que la GIZ, la FAO o alguno de los socios fundadores de la iniciativa PAEGC los aprueben o recomienden, dándoles preferencia sobre otros de naturaleza similar que no se mencionan. Las opiniones expresadas en este producto informativo son las de su(s) autor(es) o autora(s), y no reflejan necesariamente los puntos de vista o las políticas de la GIZ, la FAO o ninguno de los socios fundadores de la iniciativa PAEGC.\n","التسميات المستخدمة وطريقة عرض المواد في هذا المنتج المعلوماتي لا تعبر عن أي رأي من جانب Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH أو منظمة الأغذية والزراعة للأمم المتحدة (FAO) أو أي من الشركاء المؤسسين لـ PAEGC فيما يتعلق بالوضع القانوني أو التنموي لأي بلد أو إقليم أو مدينة أو منطقة أو لسلطاتها ، أو فيما يتعلق بترسيم حدودها أو نطاقاتها. إن ذكر شركات أو منتجات معينة من الشركات المصنعة ، سواء تم تسجيل براءات اختراع لها أم لا ، لا يعني أن هذه الشركات أو المنتجات قد تم اعتمادها أو التوصية بها من قبل GIZ أو منظمة الأغذية والزراعة أو أي من الشركاء المؤسسين لـ PAEGC او تفضيلها على الشركات أو المنتجات الاخرى غير مذكورة من نفس الطبيعة. الآراء الواردة في هذا المنتج المعلوماتي هي آراء المؤلف ولا تعكس بالضرورة آراء أو سياسات الوكالة الألمانية للتعاون الدولي أو منظمة الأغذية والزراعة أو أي من الشركاء المؤسسين  لـ PAEGC."]
[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.","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.","La GIZ, la FAO et les partenaires fondateurs du PAEGC encouragent l’utilisation, la reproduction et la diffusion des informations contenues dans ce document. Sauf indication contraire, ces dernières peuvent être copiées, téléchargées et imprimées à des fins privées d’étude, de recherche et d’enseignement, ou pour être utilisées dans des produits ou services non commerciaux, à condition que la GIZ et la FAO soient clairement indiquées en tant que sources des informations et détentrices du droit d’auteur.","La GIZ, la FAO y los socios fundadores de la iniciativa PAEGC fomentan la utilización, la reproducción y la difusión del material presentado en este producto informativo. A menos que se indique lo contrario, el material puede ser copiado, descargado e impreso con fines de estudio privado, enseñanza e investigación científica, o para su utilización en productos o servicios no comerciales, siempre que se otorgue a la GIZ y la FAO el debido reconocimiento como fuentes y como titulares de los derechos de autor.","تشجع الوكالة الألمانية للتعاون الدولي ومنظمة الأغذية والزراعة والشركاء المؤسسين لـ PAEGC على استخدام واستنساخ ونشر المواد في هذا المنتج المعلوماتي. يمكن نسخ المواد وتنزيلها وطباعتها للدراسة الخاصة ، ولأغراض البحث والتعليم ، أو لاستخدامها في المنتجات أو الخدمات غير التجارية ، ما لم يُذكر خلاف ذلك ، شريطة تقديم إقرار مناسب من الوكالة الألمانية للتعاون الدولي ومنظمة الأغذية والزراعة كمصدر وصاحب حقوق التأليف والنشر."]
[null,null,"© GIZ and FAO, 2020","© GIZ and FAO, 2020","© GIZ et FAO, 2020","© GIZ & FAO, 2020","© GIZ و FAO, 2020"]
[]
[null,{"$f":"$C$8","v":"1 INPUT-Checklist"},{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"PROMOTE and INITIATE – Impact Assessment Tool"},"PROMOTE and INITIATE – Impact Assessment Tool","PROMOTION et INITIATION - Outil d’évaluation d’impact","PROMUEVE – Herramienta de evaluación de impacto","الترويج و المبادرة - أداة تقييم الأثر"]
[null,null,"SOCIO-ECONOMIC AND ENVIRONMENTAL IMPACTS","SOCIO-ECONOMIC AND ENVIRONMENTAL IMPACTS","IMPACTS SOCIO-ÉCONOMIQUES ET ENVIRONNEMENTAUX","IMPACTOS SOCIOECONÓMICOS Y AMBIENTALES","الآثار الاجتماعية والاقتصادية والبيئية"]
[null,null,"This checklist is to roughly assess the socio-economic and environmental impacts of solar-powered irrigation systems. ","This checklist is to roughly assess the socio-economic and environmental impacts of solar-powered irrigation systems. ","Cette liste de contrôle a pour but d’évaluer en détail les impacts socio-économiques et environnementaux des systèmes d’irrigation à énergie solaire.","Esta lista de verificación es para evaluar aproximadamente los impactos socioeconómicos y ambientales de los sistemas de riego solar.","تهدف قائمة المراجعة هذه إلى إجراء تقييم تقريبي للآثار الاجتماعية والاقتصادية والبيئية لأنظمة الري التي تعمل بالطاقة الشمسية."]
[null,null,"Population Change and Migration","Population Change and Migration","Changement de population et migration","Cambio de población y migración","التغيير السكاني والهجرة"]
[null,null,"Women's Role","Women's Role","Rôle des femmes","Papel de la mujer","دور المرأة"]
[null,null,"Minority and Indigene Groups","Minority and Indigene Groups","Groupes minoritaires et indigènes","Grupos minoritarios e indígenas","الأقليات والجماعات الأصلية"]
[null,null,"Income and Amenities","Income and Amenities","Revenu et commodités","Ingresos y servicios","الدخل والمرافق"]
[null,null,"Regional Effects in Country","Regional Effects in Country","Effets régionaux dans le pays","Efectos regionales en el país","التأثيرات الإقليمية في البلد"]
[null,null,"User Involvement","User Involvement","Participation de l'utilisateur","Participación del usario","إشراك المستخدمين"]
[null,null,"Natural Resources and Environment","Natural Resources and Environment","Ressources naturelles et environnement","Recursos naturales y medio ambiente","الموارد الطبيعية والبيئة"]
[null,null,"SCORE","SCORE","SCORE","PUNTUACIÓN","النتيجة"]
[null,null,"Project Name:","Project Name:","Nom du projet:","Nombre del proyecto:","اسم المشروع:"]
[null,null,"Project Location:","Project Location:","Lieu du projet:","Ubicación del proyecto:","موقع المشروع:"]
[null,null,"User Name:","User Name:","Nom d'utilisateur:","Nombre del usario:","اسم االمستخدم:"]
[null,null,"Date of Impact Assessment:","Date of Impact Assessment:","Date de l'évaluation d'impact:","Fecha de la evaluación de impacto","تاريخ تقييم الأثر:"]
[null,null,"Project Duration (years):","Project Duration (years):","Durée du projet (années):","Duración del proyecto (años)","مدة المشروع (سنوات):"]
[null,null,"Asset Lifespan (years):","Asset Lifespan (years):","Durée de vie des actifs (années):","Vida útil del activo (años)","عمر الأصول (سنوات):"]
[null,null,"Notes:","Notes:","Remarques:","Notas:","ملاحظات:"]
[null,null,"Ref #","Ref #","Ref #","Ref #","المرجع #"]
[null,null,"Question","Question","Question","Pregunta","سؤال"]
[null,null,"Yes, No or N/A ","Yes, No or N/A ","Oui, Non ou N/A","Sí, No o N/A","نعم ، لا أو غير متاح"]
[null,null,"Weighting \n(how important is this to the project?)","Weighting \n(how important is this to the project?)","Pondération\n(Quelle est l'importance de ce projet?)","Ponderación\n(Importancia para el proyecto)","ترجيح\n(ما مدى أهمية هذا للمشروع؟) "]
[null,null,"What is the impact of the project?","What is the impact of the project?","Quel est l'impact du projet?","¿Cuál es el impacto del proyecto?","ما هو تأثير المشروع؟"]
[null,null,"Comments","Comments","commentaires","Comentarios","تعليقات"]
[null,null,"Have changes to population size/density and demographic/ethnic composition been considered in the planning of the Project? ","Have changes to population size/density and demographic/ethnic composition been considered in the planning of the Project? ","Les changements de la taille / densité de la population et de la composition démographique / ethnique ont-ils été pris en compte dans la planification du projet?","¿Se han considerado los cambios en el tamaño / densidad de la población y la composición demográfica / étnica en la planificación del proyecto?","هل تم أخذ التغييرات في حجم / كثافة السكان والتكوين الديموغرافي / العرقي في الاعتبار عند التخطيط للمشروع؟"]
[null,null,"Is the project causing significant demographic changes in the project area or vicinity which may affect social harmony? ","Is the project causing significant demographic changes in the project area or vicinity which may affect social harmony? ","Le projet provoque-t-il des changements démographiques importants dans la zone du projet ou dans les environs, susceptibles d’affecter l’harmonie sociale?","¿El proyecto está causando cambios demográficos significativos en el área o en proximidad del proyecto que podrían afectar la armonía social?","هل يتسبب المشروع في تغيرات ديموغرافية كبيرة في منطقة المشروع أو جواره مما قد يؤثر على الانسجام الاجتماعي؟"]
[null,null,"Is the project avoiding the physical and economic displacement of people?","Is the project avoiding the physical and economic displacement of people?","Le projet évite-t-il le déplacement physique et économique de personnes?","¿El proyecto está evitando el desplazamiento físico y económico de personas?","هل المشروع يتجنب النزوح المادي والاقتصادي للناس؟"]
[null,null,"Has human migration, away form the Project location (e.g. rural flight) and toward it (e.g. demand for (seasonal) agricultural labour), been considered?","Has human migration, away form the Project location (e.g. rural flight) and toward it (e.g. demand for (seasonal) agricultural labour), been considered?","La migration humaine, loin du lieu du projet (par exemple, une fuite en zone rurale) et vers celle-ci (par exemple, la demande de main-d’œuvre agricole (saisonnière)) a-t-elle été envisagée?","¿Se ha considerado la migración humana desde la ubicación del proyecto (por ejemplo éxodo rural) y hacia ella (por ejemplo, la demanda (estacional) de mano de obra agrícola)?","هل تم النظر في الهجرة البشرية بعيدًا عن موقع المشروع (مثل الهروب من الريف) ونحوه (مثل الطلب على العمالة الزراعية (الموسمية))؟"]
[null,null,"Does the project ensure decent rural employment, promoting more and better employment opportunities and working conditions and avoiding practices that could increase workers’ vulnerability?","Does the project ensure decent rural employment, promoting more and better employment opportunities and working conditions and avoiding practices that could increase workers’ vulnerability?","Le projet garantit-il un emploi rural décent, favorise-t-il des possibilités d’emploi et des conditions de travail plus nombreuses et de meilleure qualité et évite-t-il des pratiques qui pourraient accroître la vulnérabilité des travailleurs?","¿Asegura el proyecto un empleo rural digno, promoviendo más y mejores oportunidades de empleo y condiciones de trabajo, y evitando prácticas, que podrían aumentar la vulnerabilidad de los trabajadores?","هل يضمن المشروع العمالة الريفية اللائقة ، ويعزز فرص عمل وظروف عمل أكثر وأفضل ، ويتجنب الممارسات التي يمكن أن تزيد من ضعف العمال؟"]
[null,null,"Does the project respect the fundamental principles and rights at work and prohibit child labour?","Does the project respect the fundamental principles and rights at work and prohibit child labour?","Le projet respecte-t-il les principes et droits fondamentaux au travail et interdit-il le travail des enfants?","¿El proyecto respeta los principios y derechos fundamentales en el trabajo y prohíbe el trabajo infantil?","هل يحترم المشروع المبادئ والحقوق الأساسية في العمل ويحظر عمالة الأطفال؟"]
[null,null,"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?","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?","Est-ce que des dispositions adéquates ont été prises pour tout afflux temporaire ou migratoire de population afin d'éviter la misère sociale, les difficultés ou les conflits entre les groupes permanents et temporaires?","¿Se han tomado medidas adecuadas para cualquier afluencia de población migratoria o temporal para evitar entre los grupos permanentes y temporales la privación social, las dificultades o los conflictos?","هل تم توفير الترتيبات الكافية لأي تدفق مؤقت أو هجرة للسكان لتجنب الحرمان الاجتماعي أو المشقة أو النزاعات بين المجموعات الدائمة والمؤقتة؟"]
[null,null,"for more in-depth questions and aspects to consider please see:","for more in-depth questions and aspects to consider please see:","pour des questions plus approfondies et des aspects à considérer, veuillez consulter :","para preguntas en más profundidad y aspectos a considerar, consulte:","لمزيد من الأسئلة المعمقة والجوانب التي يجب مراعاتها ، يرجى الاطلاع على:"]
[null,null,"Have the needs, priorities, and constraints of both women and men been taken into consideration during the design of the project?","Have the needs, priorities, and constraints of both women and men been taken into consideration during the design of the project?","Les besoins, priorités et contraintes des femmes et des hommes ont-ils été pris en compte lors de la conception du projet?","¿Se han tenido en cuenta las necesidades, las prioridades y las limitaciones de los dos, mujeres y hombres, durante el diseño del proyecto?","هل تم أخذ احتياجات وأولويات وقيود كل من النساء والرجال في الاعتبار أثناء تصميم المشروع؟"]
[null,null,"Does the project change the status and role of women positively in relation to social standing?","Does the project change the status and role of women positively in relation to social standing?","Le projet modifie-t-il positivement le statut et le rôle des femmes par rapport au statut social?","¿El proyecto cambia positivamente el estado y el papel de las mujeres en relación con la posición social?","هل يغير المشروع مكانة ودور المرأة بشكل إيجابي فيما يتعلق بالمكانة الاجتماعية؟"]
[null,null,"Does the project change the status and role of women positively in relation to workload?","Does the project change the status and role of women positively in relation to workload?","Le projet change-t-il positivement le statut et le rôle des femmes par rapport à la charge de travail?","¿El proyecto cambia positivamente el estado y el papel de las mujeres en relación con la carga de trabajo?","هل يغير المشروع مكانة ودور المرأة بشكل إيجابي فيما يتعلق بعبء العمل؟"]
[null,null,"Does the project change the status and role of women positively in relation to access to markets, income, and finance?","Does the project change the status and role of women positively in relation to access to markets, income, and finance?","Le projet modifie-t-il positivement le statut et le rôle des femmes en ce qui concerne l'accès aux marchés, aux revenus et aux finances?","¿El proyecto cambia positivamente el estado y el papel de las mujeres en relación con el acceso a los mercados, los ingresos y las finanzas?","هل يغير المشروع مكانة ودور المرأة بشكل إيجابي فيما يتعلق بالوصول إلى الأسواق والدخل والتمويل؟"]
[null,null,"Does the project change the status and role of women positively in relation to heritage and inheritance?","Does the project change the status and role of women positively in relation to heritage and inheritance?","Le projet modifie-t-il positivement le statut et le rôle des femmes par rapport au patrimoine et à l'héritage?","¿El proyecto cambia positivamente el estado y el papel de las mujeres en relación con el patrimonio y la herencia?","هل يغير المشروع مكانة ودور المرأة بشكل إيجابي فيما يتعلق بالتراث والميراث؟"]
[null,null,"Does the project change the status and role of women positively in relation to marital rights?","Does the project change the status and role of women positively in relation to marital rights?","Le projet modifie-t-il positivement le statut et le rôle de la femme par rapport aux droits matrimoniaux?","¿El proyecto cambia positivamente el estado y el papel de las mujeres en relación con los derechos matrimoniales?","هل يغير المشروع مكانة ودور المرأة بشكل إيجابي فيما يتعلق بالحقوق الزوجية؟"]
[null,null,"Does the project promote women’s and men’s equitable access to and control over productive resources and services?","Does the project promote women’s and men’s equitable access to and control over productive resources and services?","Le projet favorise-t-il l’accès équitable des femmes et des hommes aux ressources et services productifs et le contrôle de ces ressources?","¿El proyecto promueve a las mujeres y hombres el acceso equitativo a y el control de los recursos y servicios productivos?","هل يعزز المشروع الوصول المتكافئ للنساء والرجال إلى الموارد الإنتاجية والخدمات والتحكم فيها؟"]
[null,null,"Does the project foster the equal participation of men and women in institutions and decision-making processes?","Does the project foster the equal participation of men and women in institutions and decision-making processes?","Le projet encourage-t-il la participation égale des hommes et des femmes aux institutions et aux processus décisionnels?","¿El proyecto fomenta la participación equitativa de hombres y mujeres en las instituciones y en los procesos decisorios?","هل يعزز المشروع المشاركة المتساوية للرجال والنساء في المؤسسات وعمليات صنع القرار؟"]
[null,null,"Does the project allow for reduced time burden on women and minority groups allowing for the pursuit of other activities such as education and leisure?","Does the project allow for reduced time burden on women and minority groups allowing for the pursuit of other activities such as education and leisure?","Le projet permet-il de réduire le fardeau temporel des femmes et des groupes minoritaires tout en permettant la poursuite d'autres activités telles que l'éducation et les loisirs?","¿Permite el proyecto reducir la carga de tiempo para las mujeres y los grupos minoritarios, lo que les permite dedicarse a otras actividades, como la educación y el ocio?","هل يسمح المشروع بتخفيض عبء الوقت على النساء والأقليات مما يسمح بمتابعة أنشطة أخرى مثل التعليم والترفيه؟"]
[null,null,"Does the project establish dispute resolution mechanisms that are gender-balanced?","Does the project establish dispute resolution mechanisms that are gender-balanced?","Le projet établit-il des mécanismes de résolution des litiges équilibrés entre les sexes?","¿El proyecto establece mecanismos de resolución de disputas que tengan un equilibrio de género?","هل يؤسس المشروع آليات لتسوية المنازعات تكون متوازنة بين الجنسين؟"]
[null,null,"Have the consequences of changing the use of a water source been considered?","Have the consequences of changing the use of a water source been considered?","Les conséquences du changement d'utilisation d'une source d'eau ont-elles été prises en compte?","¿Se han considerado las consecuencias de cambiar el uso de una fuente de agua?","هل تم النظر في عواقب تغيير استخدام مصدر المياه؟"]
[null,null,"Will the project have gender-differentiated impacts on farmers downstream or outside of the project boundary? ","Will the project have gender-differentiated impacts on farmers downstream or outside of the project boundary? ","Le projet aura-t-il des impacts différenciés selon le sexe sur les agriculteurs en aval ou en dehors des limites du projet?","¿El proyecto tendrá impactos diferenciados de género por los agricultores río abajo o más allá de los límites del proyecto?","هل سيكون للمشروع تأثيرات متباينة بين الجنسين على المزارعين في نهاية أو خارج حدود المشروع؟"]
[null,null,"Will the right to the irrigation system and the right to irrigate affect the land register or land ownership status?","Will the right to the irrigation system and the right to irrigate affect the land register or land ownership status?","Le droit au système d'irrigation et le droit d'irriguer affecteront-ils le registre foncier ou le statut de propriété foncière?","¿Afectarán el derecho de un sistema de riego y el derecho a regar el registro de la tierra o el estado de la propiedad de la tierra?\n","هل سيؤثر الحق في نظام الري والحق في الري على السجل العقاري أو حالة ملكية الأرض؟"]
[null,null,"Does the project provide equal opportunities for training to men and women?","Does the project provide equal opportunities for training to men and women?","Le projet offre-t-il des chances égales de formation aux hommes et aux femmes?","¿El proyecto ofrece oportunidades iguales para la capacitación de mujeres y hombres?","هل يوفر المشروع فرصا متكافئة للتدريب للرجال والنساء؟"]
[null,null,"Is the project causing positive changes to the lifestyle, livelihoods, or habitation of any social groups (particularly minority groups)?","Is the project causing positive changes to the lifestyle, livelihoods, or habitation of any social groups (particularly minority groups)?","Le projet entraîne-t-il des changements positifs dans le mode de vie, les moyens de subsistance ou l'habitation de certains groupes sociaux (en particulier des groupes minoritaires)?","¿El proyecto está causando cambios positivos en el estilo de vida, los medios de subsistencia o la habitación de cualquier grupo social (especialmente grupos minoritarios)?","هل يُحدث المشروع تغييرات إيجابية في نمط الحياة أو سبل العيش أو السكن لأي مجموعات اجتماعية (خاصة مجموعات الأقليات)؟"]
[null,null,"Is the project leading to positive changes in traditional behaviour, social organisation, or cultural and religious practices (particularly minority groups)?","Is the project leading to positive changes in traditional behaviour, social organisation, or cultural and religious practices (particularly minority groups)?","Le projet entraîne-t-il des changements positifs dans les comportements traditionnels, l'organisation sociale ou les pratiques culturelles et religieuses (en particulier les groupes minoritaires)?","¿El proyecto conduce a cambios positivos en el comportamiento tradicional, la organización social o las prácticas culturales y religiosas (especialmente los grupos minoritarios)?","هل يؤدي المشروع إلى تغييرات إيجابية في السلوك التقليدي أو التنظيم الاجتماعي أو الممارسات الثقافية والدينية (خاصة مجموعات الأقليات)؟"]
[null,null,"Does the project address equal opportunities for minority groups?","Does the project address equal opportunities for minority groups?","Le projet aborde-t-il l'égalité des chances pour les groupes minoritaires?","¿El proyecto aborda oportunidades iguales para grupos minoritarios?","هل يعالج المشروع تكافؤ الفرص لمجموعات الأقليات؟"]
[null,null,"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)? ","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)? ","Les activités du projet sont-elles susceptibles d’avoir des effets défavorables sur les droits des peuples autochtones, leurs terres, leurs ressources naturelles, leurs territoires, leurs moyens de subsistance, leur savoir, leur tissu social, leurs traditions, leurs systèmes de gouvernance et leur culture ou leur patrimoine (matériel et immatériel)?","¿Pueden las actividades tener efectos adversos sobre los derechos de los pueblos indígenas, las tierras, los recursos naturales, los territorios, los medios de subsistencia, el conocimiento, el tejido social, las tradiciones, los sistemas de gobierno y la cultura o el patrimonio (tangible e intangible)?","هل من المحتمل أن يكون لأنشطة المشروع آثار سلبية على حقوق الشعوب الأصلية والأراضي والموارد الطبيعية والأقاليم وسبل العيش والمعرفة والنسيج الاجتماعي والتقاليد وأنظمة الحكم والثقافة أو التراث (المادي وغير المادي)؟"]
[null,null,"Are indigenous communities outside the project area likely to be affected by the project?","Are indigenous communities outside the project area likely to be affected by the project?","Les communautés autochtones en dehors de la zone du projet sont-elles susceptibles d'être affectées par le projet?","¿Es probable que las comunidades indígenas fuera del área del proyecto se vean afectadas por el proyecto?","هل من المحتمل أن تتأثر المجتمعات الأصلية خارج منطقة المشروع بالمشروع؟"]
[null,null,"Is the project designed to be sensitive to cultural heritage issues?","Is the project designed to be sensitive to cultural heritage issues?","Le projet est-il conçu pour être sensible aux questions de patrimoine culturel?","¿El proyecto está diseñado para ser sensible a los problemas del patrimonio cultural?","هل تم تصميم المشروع ليكون حساسًا لقضايا التراث الثقافي؟"]
[null,null,"Is the Project introducing significant economic/political changes which can increase or decrease social harmony and individual wellbeing?","Is the Project introducing significant economic/political changes which can increase or decrease social harmony and individual wellbeing?","Le projet introduit-il des changements économiques / politiques significatifs susceptibles d’augmenter ou de diminuer l’harmonie sociale et le bien-être individuel?","¿El Proyecto está introduciendo cambios económicos / políticos significativos que pueden aumentar o disminuir la armonía social y el bienestar individual?","هل يقدم المشروع تغييرات اقتصادية / سياسية مهمة يمكن أن تزيد أو تقلل من التناغم الاجتماعي ورفاهية الفرد؟"]
[null,null,"Does the project create business opportunities for local communities (e.g. diversification of production, technical service provisions, new markets)?","Does the project create business opportunities for local communities (e.g. diversification of production, technical service provisions, new markets)?","Le projet crée-t-il des opportunités d’affaires pour les communautés locales (par exemple, diversification de la production, fourniture de services techniques, nouveaux marchés)?","¿Crea el proyecto oportunidades comerciales para las comunidades locales (por ejemplo, diversificación de la producción, disposiciones de servicios técnicos, nuevos mercados)?","هل يخلق المشروع فرص عمل للمجتمعات المحلية (مثل تنويع الإنتاج ، وتوفير الخدمات التقنية ، والأسواق الجديدة)؟"]
[null,null,"Does the project impact the creation of a competitive agricultural sector (e.g. improved market access, higher quality products, greater yields)?","Does the project impact the creation of a competitive agricultural sector (e.g. improved market access, higher quality products, greater yields)?","Le projet a-t-il un impact sur la création d'un secteur agricole compétitif (par exemple, un meilleur accès au marché, des produits de meilleure qualité, des rendements plus élevés)?","¿Influye el proyecto en la creación de un sector agrícola competitivo (por ejemplo, mejor acceso al mercado, productos de mayor calidad y mayores rendimientos)?","هل يؤثر المشروع على إنشاء قطاع زراعي تنافسي (مثل تحسين الوصول إلى الأسواق ، والمنتجات عالية الجودة ، وزيادة الانتاج)؟"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"Have there been any improvements in the general levels of employment and income?"},"Have there been any improvements in the general levels of employment and income?","Y a-t-il eu des améliorations dans les niveaux généraux d'emploi et de revenu?","¿Ha habido alguna mejora en el empleo y los ingresos?","هل كان هناك أي تحسن في المستويات العامة للعمالة والدخل؟"]
[null,null,"Does the project impact sustainable job creation and employment relative to the life of the project?","Does the project impact sustainable job creation and employment relative to the life of the project?","Le projet a-t-il un impact sur la création d'emplois durables et l'emploi par rapport à la durée de vie du projet?","¿Conlleva el proyecto a la creación de empleo sostenible y trabajo en relación con el mismo?","هل يؤثر المشروع على خلق فرص العمل المستدامة والتوظيف بالنسبة لحياة المشروع؟"]
[null,null,"Have there been any changes in the provision of local infrastructure and amenities?","Have there been any changes in the provision of local infrastructure and amenities?","Y a-t-il eu des changements dans la fourniture d'infrastructures et d'équipements locaux?","¿Ha habido algún cambio en la provisión de infraestructura y servicios locales?","هل حدثت أي تغييرات في توفير البنية التحتية المحلية ووسائل الراحة؟"]
[null,null,"Have there been any changes in the relative distribution of income, property values, and Project benefits (including access to irrigation water)?","Have there been any changes in the relative distribution of income, property values, and Project benefits (including access to irrigation water)?","La répartition relative du revenu, la valeur des propriétés et les avantages du projet (y compris l'accès à l'eau d'irrigation) ont-ils changé?","¿Ha habido algún cambio en la distribución relativa del ingreso, el valor de la propiedad y los beneficios del proyecto (incluido el acceso al agua de riego)?","هل حدثت أي تغييرات في التوزيع النسبي للدخل ، وقيمة الممتلكات ، ومزايا المشروع (بما في ذلك الوصول إلى مياه الري)؟"]
[null,null,"Will the economic, infrastructural, social, and demographic changes associated with the project impact on regional development?","Will the economic, infrastructural, social, and demographic changes associated with the project impact on regional development?","Les changements économiques, infrastructurels, sociaux et démographiques associés au projet auront-ils un impact sur le développement régional?","¿Los cambios económicos, infraestructurales, sociales y demográficos asociados con el proyecto tendrán un impacto en el desarrollo regional?","هل ستؤثر التغيرات الاقتصادية والبنية التحتية والاجتماعية والديموغرافية المرتبطة بأثر المشروع على التنمية الإقليمية؟"]
[null,null,"Have impacts on institutional efficiency at the local and regional leves been considered? (regulatory framework, informal relationships, steering mechanisms)","Have impacts on institutional efficiency at the local and regional leves been considered? (regulatory framework, informal relationships, steering mechanisms)","Des impacts sur l'efficacité institutionnelle aux niveaux local et régional ont-ils été pris en compte? (cadre réglementaire, relations informelles, mécanismes de pilotage)","¿Se han considerado los impactos en la eficiencia institucional a nivel local y regional? (marco regulatorio, relaciones informales, mecanismos direccionales)","هل تم النظر في التأثيرات على الكفاءة المؤسسية على المستوى المحلي والإقليمي؟ (الإطار التنظيمي ، العلاقات غير الرسمية ، آليات التوجيه)"]
[null,null,"Have impacts on the viability of land holdings, land rights, and water rights been considered?","Have impacts on the viability of land holdings, land rights, and water rights been considered?","Les impacts sur la viabilité des avoirs fonciers, des droits fonciers et des droits à l'eau ont-ils été pris en compte?","¿Se han tenido en cuenta los impactos sobre la viabilidad de las propiedades de la tierra, los derechos de tierra y los derechos de agua?","هل تم النظر في التأثيرات على قابلية حيازة الأراضي وحقوق الأراضي وحقوق المياه؟"]
[null,null,"Does the project deliver a fair standard of living for agricultural and rural communities?","Does the project deliver a fair standard of living for agricultural and rural communities?","Le projet offre-t-il un niveau de vie équitable aux communautés agricoles et rurales?","¿Ofrece el proyecto un nivel de vida razonable para las comunidades agrícolas y rurales?","هل يوفر المشروع مستوى معيشيًا عادلًا للمجتمعات الزراعية والريفية؟"]
[null,null,"Does the project contribute to the viability of rural areas / a balanced pattern of development / the maintenance of vibrant and active rural communities?","Does the project contribute to the viability of rural areas / a balanced pattern of development / the maintenance of vibrant and active rural communities?","Le projet contribue-t-il à la viabilité des zones rurales / à un schéma de développement équilibré / au maintien de communautés rurales dynamiques et actives?","¿Contribuye el proyecto a la viabilidad de las áreas rurales / a un patrón equilibrado de desarrollo / al mantenimiento de comunidades rurales dinámicas y activas?","هل يساهم المشروع في استدامة المناطق الريفية / نمط متوازن للتنمية / الحفاظ على مجتمعات ريفية حيوية ونشطة؟"]
[null,null,"Is there a positive impact on subsistence farmers and farming systems for the project population in the project area?","Is there a positive impact on subsistence farmers and farming systems for the project population in the project area?","Existe-t-il un impact positif sur les agriculteurs de subsistance et les systèmes agricoles de la population du projet dans la zone du projet?","¿Existe un impacto positivo para los agricultores de subsistencia y los sistemas agrícolas en el área del proyecto?","هل هناك تأثير إيجابي على مورد رزق المزارعين والأنظمة الزراعة لسكان المشروع في منطقة المشروع؟"]
[null,null,"Is there a positive impact on subsistence farmers and farming systems for the project population outside of the project area?","Is there a positive impact on subsistence farmers and farming systems for the project population outside of the project area?","Existe-t-il un impact positif sur les agriculteurs de subsistance et les systèmes agricoles pour la population du projet en dehors de la zone du projet?","¿Existe un impacto positivo para los agricultores de subsistencia y los sistemas agrícolas fuera del área del proyecto?","هل هناك تأثير إيجابي على مورد رزق المزارعين والأنظمة الزراعة لسكان المشروع خارج منطقة المشروع؟"]
[null,null,"Has an adequate provision been made for new transport, marketing, and processing needs associated with the project?","Has an adequate provision been made for new transport, marketing, and processing needs associated with the project?","Des dispositions adéquates ont-elles été prises pour les nouveaux besoins de transport, de commercialisation et de transformation associés au projet?","¿Se han previsto adecuadamente las nuevas necesidades de transporte, comercialización y procesamiento asociadas al proyecto?","هل تم توفير مخصصات كافية  للاحتياجات الجديدة  للنقل والتسويق والمعالجة المرتبطة بالمشروع؟"]
[null,null,"Has the impact on access to sites of national historical, cultural, and religious significance been considered?","Has the impact on access to sites of national historical, cultural, and religious significance been considered?","L'impact sur l'accès aux sites d'importance historique, culturelle et religieuse nationale a-t-il été pris en compte?","¿Se ha tenido en cuenta el impacto en el acceso a sitios de importancia nacional histórica, cultural y religiosa?","هل تم النظر في التأثير على الوصول إلى المواقع ذات الأهمية الوطنية التاريخية والثقافية والدينية؟"]
[null,null,"Has there been adequate user participation in project planning, implementation, and operation to ensure project success and reduce future conflicts?","Has there been adequate user participation in project planning, implementation, and operation to ensure project success and reduce future conflicts?","Les utilisateurs ont-ils suffisamment participé à la planification, à la mise en œuvre et au fonctionnement du projet pour en assurer le succès et réduire les conflits futurs?","¿Ha habido una participación adecuada de los usuarios en la planificación, implementación y operación del proyecto para garantizar el éxito del proyecto y reducir futuros conflictos?","هل كانت هناك مشاركة كافية للمستخدم في تخطيط المشروع وتنفيذه وتشغيله لضمان نجاح المشروع وتقليل النزاعات المستقبلية؟"]
[null,null,"Has the provision of new or extended facilities for credit, marketing, agricultural extension, and training been considered?","Has the provision of new or extended facilities for credit, marketing, agricultural extension, and training been considered?","At-on envisagé de fournir de nouvelles facilités ou des facilités supplémentaires pour le crédit, la commercialisation, la vulgarisation agricole et la formation?","¿Se ha considerado la provisión de instalaciones nuevas o ampliadas para crédito, comercialización, extensión agrícola y capacitación?","هل تم النظر في توفير تسهيلات جديدة أو موسعة للائتمان والتسويق والإرشاد الزراعي والتدريب؟"]
[null,null,"Have the views, needs and preferences of users been adequately considered in the design, and set-up of the system?","Have the views, needs and preferences of users been adequately considered in the design, and set-up of the system?","Les points de vue, les besoins et les préférences des utilisateurs ont-ils été dûment pris en compte dans la conception et la configuration du système?","¿Se han tenido en cuenta adecuadamente las opiniones, las necesidades y las preferencias de los usarios en el diseño y la configuración del sistema?","هل تم مراعاة آراء المستخدمين واحتياجاتهم وتفضيلاتهم بشكل مناسب عند تصميم النظام وإعداده؟"]
[null,null,"Will training be provided to local populations?","Will training be provided to local populations?","Une formation sera-t-elle dispensée aux populations locales?","¿Se proporcionará capacitación a la población local?","هل سيتم توفير التدريب للسكان المحليين؟"]
[null,null,"Has the potential for incorporating existing systems of land tenure, traditional irrigation, and existing organisational and sociological structures been considered?","Has the potential for incorporating existing systems of land tenure, traditional irrigation, and existing organisational and sociological structures been considered?","Le potentiel d'intégration des systèmes fonciers existants, de l'irrigation traditionnelle et des structures organisationnelles et sociologiques existantes a-t-il été envisagé?","¿Se ha considerado la posibilidad de incorporar los sistemas existentes de tenencia de tierras, el riego tradicional y las estructuras organizativas y sociológicas existentes?","هل تم النظر في إمكانية دمج الأنظمة الحالية لحيازة الأراضي والري التقليدي والهياكل التنظيمية والاجتماعية القائمة؟"]
[null,null,"Has the impact of increased evapotranspiration been considered?","Has the impact of increased evapotranspiration been considered?","L'impact d'une augmentation de l'évapotranspiration a-t-il été pris en compte?","¿Se ha considerado el impacto de un aumento de la evapotranspiración?","هل تم النظر في تأثير زيادة البخر - نتح؟"]
[null,null,"Does the project establish the use of water within sustainable abstraction limits?","Does the project establish the use of water within sustainable abstraction limits?","Le projet établit-il l'utilisation de l'eau dans des limites de captage durables?","¿Establece el proyecto el uso del agua dentro de los límites de extracción sostenibles?","هل يحدد المشروع استخدام المياه ضمن حدود الاستخراج المياه المستدام؟"]
[null,null,"Has groundwater availability through drying up of drinking and irrigation wells been considered?","Has groundwater availability through drying up of drinking and irrigation wells been considered?","La disponibilité des eaux souterraines résultant de l'assèchement des puits d'eau potable et d'irrigation a-t-elle été prise en compte?","¿Se ha considerado la disponibilidad de agua subterránea mediante el secado de pozos de agua potable y riego?","هل تم مراعاة توافر المياه الجوفية من خلال جفاف آبار مياه الشرب والري؟"]
[null,null,"Has saline intrusion into groundwater along the coastal regions been considered?","Has saline intrusion into groundwater along the coastal regions been considered?","L'intrusion saline dans les eaux souterraines le long des régions côtières a-t-elle été envisagée?","¿Se ha considerado la intrusión salina en las aguas subterráneas a lo largo de las regiones costeras?","هل تم النظر في تسرب المياه المالحة إلى المياه الجوفية على طول المناطق الساحلية؟"]
[null,null,"Have reduced base flows on groundwater availability been assessed?","Have reduced base flows on groundwater availability been assessed?","Des débits de base réduits sur la disponibilité des eaux souterraines ont-ils été évalués?","¿Se han evaluado los flujos base reducidos en la disponibilidad de agua subterránea?","هل تم تقييم انخفاض التصريف الأساسي على توافر المياه الجوفية؟"]
[null,null,"Has the impact on downstream river discharges of the project area been considered?","Has the impact on downstream river discharges of the project area been considered?","L'impact sur les débits fluviaux en aval de la zone du projet a-t-il été pris en compte?","¿Se ha considerado el impacto en las descargas del río, río abajo del área del proyecto?","هل تم النظر في التأثير على تصريف الأنهار في اتجاه مجرى النهر في منطقة المشروع؟"]
[null,null,"Has the impact on water quality through a reduction in irrigation water quality and leaching been considered?","Has the impact on water quality through a reduction in irrigation water quality and leaching been considered?","L'impact sur la qualité de l'eau résultant d'une réduction de la qualité de l'eau d'irrigation et du lessivage a-t-il été pris en compte?","¿Se ha considerado el impacto en la calidad del agua a través de una reducción en la calidad del agua de riego y la lixiviación?","هل تم النظر في التأثير على جودة المياه من خلال تقليل جودة مياه الري و الرشح ؟"]
[null,null,"Has the impact on water quality problems for downstream users by poor irrigation return flow quality been considered?","Has the impact on water quality problems for downstream users by poor irrigation return flow quality been considered?","L'impact sur les problèmes de qualité de l'eau pour les utilisateurs en aval du fait d'une mauvaise qualité du débit de retour d'irrigation a-t-il été pris en compte?","¿Se ha considerado el impacto en los problemas de calidad del agua para los usuarios río abajo por la mala calidad del flujo de retorno de riego?","هل تم النظر في التأثير على مشاكل جودة المياه لمستخدمي المصب بسبب سوء جودة تدفق الري؟"]
[null,null,"Has the impact on the degradation of the land through salinization been assessed?","Has the impact on the degradation of the land through salinization been assessed?","L'impact sur la dégradation des sols par la salinisation a-t-il été évalué?","¿Se ha evaluado el impacto en la degradación de la tierra a través de la salinización?","هل تم تقييم التأثير على تدهور الأرض من خلال التملح؟"]
[null,null,"Has the impact on the degradation of the land through alkalisation been considered?","Has the impact on the degradation of the land through alkalisation been considered?","L'impact sur la dégradation du sol par l'alcalinisation a-t-il été pris en compte?","¿Se ha considerado el impacto sobre la degradación de la tierra mediante alcalinización?","هل تم النظر في التأثير على تدهور الأرض من خلال القلوية؟"]
[null,null,"Has the degradation of the land through increased groundwater recharge, waterlogging, and drainage problems been considered?","Has the degradation of the land through increased groundwater recharge, waterlogging, and drainage problems been considered?","La dégradation des sols liée à l’augmentation des problèmes d’alimentation en nappe phréatique, d’engorgement en eau et de drainage a-t-elle été envisagée?","¿Se ha considerado la degradación de la tierra a través del aumento de la recarga de agua subterránea, el encharcamiento y los problemas de drenaje?","هل تم النظر في تدهور الأرض من خلال زيادة تغذية المياه الجوفية ، والتغدق (الإشباع بالماء) ، ومشاكل الصرف؟"]
[null,null,"Has the project's impact on the degradation of the land through soil acidification been considered?","Has the project's impact on the degradation of the land through soil acidification been considered?","L'impact du projet sur la dégradation des sols par l'acidification des sols a-t-il été pris en compte?","¿Se ha considerado el impacto del proyecto en la degradación de la tierra a través de la acidificación del suelo?","هل تم النظر في تأثير المشروع على تدهور الأرض من خلال تحمض التربة؟"]
[null,null,"Has the project's impact on the degradation of the land through soil compaction been considered?","Has the project's impact on the degradation of the land through soil compaction been considered?","L’impact du projet sur la dégradation des sols par le compactage des sols a-t-il été pris en compte?","¿Se ha considerado el impacto del proyecto en la degradación de la tierra a través de la compactación del suelo?","هل تم النظر في تأثير المشروع على تدهور الأرض من خلال رص التربة؟"]
[null,null,"Has the impact on the degradation of the land through soil erosion been considered?","Has the impact on the degradation of the land through soil erosion been considered?","L'impact sur la dégradation des sols par l'érosion des sols a-t-il été pris en compte?","¿Se ha considerado el impacto sobre la degradación de la tierra a través de la erosión del suelo?","هل تم النظر في التأثير على تدهور الأرض من خلال تآكل التربة؟"]
[null,null,"Does the project include the usage of non-conventional sources of water (i.e. wastewater)?","Does the project include the usage of non-conventional sources of water (i.e. wastewater)?","Le projet comprend-il l’utilisation de sources d’eau non conventionnelles (par exemple, les eaux usées)?","¿Incluye el proyecto el uso de fuentes de agua no convencionales (es decir, aguas residuales)?","هل يشمل المشروع استخدام مصادر المياه غير التقليدية (مثل مياه الصرف الصحي)؟"]
[null,null,"Has the impact of a dam been considered?","Has the impact of a dam been considered?","L'impact d'un barrage a-t-il été pris en compte?","¿Se ha considerado el impacto de una presa?","هل تم النظر في تأثير السد؟"]
[null,null,"Has the project's impact on ecological systems (biodiversity in irrigated and surrounding areas or downstream areas) been considered:","Has the project's impact on ecological systems (biodiversity in irrigated and surrounding areas or downstream areas) been considered:","L'impact du projet sur les systèmes écologiques (biodiversité dans les zones irriguées et avoisinantes ou en aval) a-t-il été pris en compte:","¿Se ha tenido en cuenta el impacto del proyecto en los sistemas ecológicos (biodiversidad en las áreas de regadío y alrededores o en las áreas río abajo)?","هل تم مراعاة تأثير المشروع على النظم البيئية (التنوع البيولوجي في المناطق المروية والمناطق المحيطة أو مناطق المصب):"]
[null,null,"Have impacts on human health through increased incidence of water-related diseases been considered?","Have impacts on human health through increased incidence of water-related diseases been considered?","Des impacts sur la santé humaine résultant d'une incidence accrue de maladies liées à l'eau ont-ils été pris en compte?","¿Se han considerado los impactos en la salud humana a través de una mayor incidencia de enfermedades relacionadas con el agua?","هل تم مراعاة التأثيرات على صحة الإنسان من خلال زيادة الإصابة بالأمراض المرتبطة بالمياه؟"]
[null,null,"Is there a solid waste collection system in place in the project area? ","Is there a solid waste collection system in place in the project area? ","Un système de collecte des déchets solides est-il en place dans la zone du projet?","¿Existe un sistema de recolección de desechos sólidos en el área del proyecto?","هل يوجد نظام لجمع النفايات الصلبة في منطقة المشروع؟"]
[null,null,"Is there a collection system for electrical and electronic waste (solar panels, charge controllers, inverters, cables...) in place in the project area? ","Is there a collection system for electrical and electronic waste (solar panels, charge controllers, inverters, cables...) in place in the project area? ","Existe-t-il un système de collecte des déchets électriques et électroniques (panneaux solaires, contrôleurs de charge, onduleurs, câbles, etc.) en place dans la zone du projet?","¿Existe un sistema de recolección de desechos eléctricos y electrónicos (paneles solares, controladores de carga, inversores, cables ...) en el área del proyecto?","هل يوجد في منطقة المشروع نظام تجميع للنفايات الكهربائية والإلكترونية (الألواح الشمسية ، أجهزة التحكم بالشحن ، العاكسات ، الكابلات ...)؟"]
[null,null,"Is there a collection system in place to collect batteries in the project area? ","Is there a collection system in place to collect batteries in the project area? ","Un système de collecte est-il en place pour collecter les piles dans la zone du projet?","¿Existe un sistema de recolección de baterías en el área del proyecto?","هل يوجد نظام تجميع لتجميع البطاريات في منطقة المشروع؟"]
[null,null,"Has any increased exposure to toxic substances (pesticides, battery liquids, fertilizers, chemicals, etc...) been considered?","Has any increased exposure to toxic substances (pesticides, battery liquids, fertilizers, chemicals, etc...) been considered?","Une exposition accrue à des substances toxiques (pesticides, liquides de batterie, engrais, produits chimiques, etc.) a-t-elle été envisagée?","¿Se ha considerado una mayor exposición a sustancias tóxicas (pesticidas, líquidos de baterías, fertilizantes, productos químicos, etc.)?","هل تم النظر في زيادة التعرض للمواد السامة (مبيدات ، سوائل البطاريات ، الأسمدة ، الكيماويات ، إلخ ...)؟"]
[null,null,"Is there a collection system in place to collect agricultural plastics (pipes, reservoirs, mulch, tunnels, greenhouse, silage, crates, fittings, nets, drippers...) in the project area? ","Is there a collection system in place to collect agricultural plastics (pipes, reservoirs, mulch, tunnels, greenhouse, silage, crates, fittings, nets, drippers...) in the project area? ","Existe-t-il un système de collecte en place pour collecter les plastiques agricoles (tuyaux, réservoirs, paillis, tunnels, serre, ensilage, caisses, accessoires, filets, goutteurs, etc.) dans la zone du projet?","¿Existe un sistema de recolección para recolectar plásticos agrícolas (tuberías, reservorios, mantillo, túneles, invernaderos, ensilajes, cajas, accesorios, redes, goteros ...) en el área del proyecto?","هل يوجد نظام تجميع لتجميع المواد البلاستيكية الزراعية (أنابيب ، خزانات ، غطاء التربة ، أنفاق ، بيوت بلاستيكية ، غطاء علف ، صناديق ، تجهيزات ، شبكات ، منقطات ...) في منطقة المشروع؟"]
[null,null,"Yes","Yes","Oui","sí","نعم"]
[null,null,"No","No","Non","No","لا"]
[null,null,"N/A","N/A","N/A","N/A","غير متاح"]
[null,null,"High","High","Haute","Elevado","عالي"]
[null,null,"Medium","Medium","Moyen","Camino","متوسط"]
[null,null,"Low","Low","Faible","Bajo","منخفض"]
[null,null,"Positive impact is very likely","Positive impact is very likely","Impact positif est très probable","Impacto positivo es muy probable","تأثير إيجابي محتمل جدا"]
[null,null,"Positive impact possible","Positive impact possible","Impact positif possible","Posible impacto positivo","تأثير إيجابي ممكن"]
[null,null,"No impact likely","No impact likely","Pas d'impact probable","Sin impacto probable","لا تأثير محتمل"]
[null,null,"Negative impact possible","Negative impact possible","Impact négatif possible","Posible impacto negativo","تأثير سلبي محتمل"]
[null,null,"Negative impact very likely","Negative impact very likely","Impact négatif très probable","Impacto negativo muy probable","تأثير سلبي محتمل جدا"]
[]
[null,{"$f":"$C$9","v":"2 INPUT-Data"},"PROMOTE and INITIATE – Impact Assessment Tool","PROMOTE and INITIATE – Impact Assessment Tool","PROMOTION et INITIATION - Outil d’évaluation d’impact","PROMUEVE – Herramienta de evaluación de impacto","الترويج و المبادرة - أداة تقييم الأثر"]
[null,null,"SOCIO-ECONOMIC DATA","SOCIO-ECONOMIC DATA","DONNÉES SOCIO-ÉCONOMIQUES","DATOS SOCIOECONÓMICOS","البيانات الاجتماعية والاقتصادية"]
[null,null,"Ref #","Ref #","Ref #","Ref #","المرجع #"]
[null,null,"Question","Question","Question","Pregunta","سؤال"]
[null,null,"ABSOLUTE NUMBER","ABSOLUTE NUMBER","VALEUR ABSOLUE","NÚMERO ABSOLUTO","الرقم المطلق"]
[null,null,"PERCENTAGE [%]","PERCENTAGE [%]","POURCENTAGE [%]","PORCENTAJE [%]","النسبة المئوية [٪]"]
[null,null,"USER COMMENTS","USER COMMENTS","COMMENTAIRES DE L'UTILISATEUR","COMENTARIOS DEL USUARIO","تعليقات المستخدم"]
[null,null,"PROJECT REVIEWER COMMENTS","PROJECT REVIEWER COMMENTS","COMMENTAIRES DE L'EXAMINATEUR DE PROJET","COMENTARIOS DEL REVISOR DEL PROYECTO","تعليقات مراجع المشروع"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":"What is the population in the vicinity of the project?\n"},"What is the population in the vicinity of the project?\n","Quelle est la population dans les environs du projet? \n","¿Cuál es la población en las proximidades del proyecto?","ما هو عدد السكان في محيط المشروع؟"]
[null,null,"How many will be impacted by the project?\n","How many will be impacted by the project?\n","Combien seront touchés par le projet?","¿Cuántas personas serán afectadas por el proyecto?","كم سيتأثر بالمشروع؟"]
[null,null,"How many farmers will be impacted by the project?\n","How many farmers will be impacted by the project?\n","Combien d'agriculteurs seront touchés par le projet?","¿Cuántos agricultores serán afectados por el proyecto?","كم عدد المزارعين الذين سيتأثرون بالمشروع؟"]
[null,null,"TOTAL","TOTAL","TOTAL","TOTAL","المجموع"]
[null,null,"What is the breakdown of farmers benefitting from the project by gender, socioeconomic delineation, and income?","What is the breakdown of farmers benefitting from the project by gender, socioeconomic delineation, and income?","Quelle est la répartition des agriculteurs bénéficiant du projet par sexe, par délimitation socio-économique et par revenu?","¿Cuál es el desglose de la población de agricultores beneficiados por el proyecto en categorías de género, clase socioeconómica e ingresos?","ما هو توزيع المزارعين المستفيدين من المشروع حسب الجنس ، والتحديد الاجتماعي والاقتصادي ، والدخل؟"]
[null,null,"Male","Male","Homme","Hombre","ذكر"]
[null,null,"Female","Female","Femme","Mujer","أنثى"]
[null,null,"Group type 1","Group type 1","Groupe type 1","Grupo tipo 1","نوع المجموعة 1"]
[null,null,"Group type 2","Group type 2","Groupe type 2","Grupo tipo 2","نوع المجموعة 2"]
[null,null,"Group type 3","Group type 3","Groupe type 3","Grupo tipo 3","نوع المجموعة 3"]
[null,null,"Group type 4","Group type 4","Groupe type 4","Grupo tipo 4","نوع المجموعة 4"]
[null,null,"Unemployed","Unemployed","Sans emploi","Desempleados","عاطلين عن العمل"]
[null,null,"Below poverty line","Below poverty line","Sous le seuil de pauvreté","Debajo de la línea de pobreza","تحت خط الفقر"]
[null,null,"Where are farmers benefitting recruited from?","Where are farmers benefitting recruited from?","Où sont recrutés les agriculteurs bénéficiaires?","¿De dónde se han contratado los agricultores beneficiados?","من أين يتم استقدام الفلاحين المستفيدين؟"]
[null,null,"Local in the village","Local in the village","population Locale dans le  village","Local en en pueblo","السكان المحليين في القرية"]
[null,null,"Local resettled","Local resettled","population Locale réinstallée","Local reasentada","السكان المحليين الذين أعيد توطينهم"]
[null,null,"Same sociological background from elsewhere","Same sociological background from elsewhere","Même contexte sociologique d'ailleurs","Fondo sociológico igual de otro lado","نفس السياق الاجتماعي في مكان آخر"]
[null,null,"Different sociological background","Different sociological background","Fond sociologique différent","Fondo sociológico diferente","خلفية اجتماعية مختلفة"]
[null,null,"What are the labour requirements of the project?","What are the labour requirements of the project?","Quels sont les besoins en main-d'œuvre du projet?","¿Cuáles son los requisitos laborales del proyecto?","ما هي متطلبات العمالة للمشروع؟"]
[null,null,"Family labour","Family labour","Dans la  famille","Trabajo familiar","عمالة من العائلة"]
[null,null,"Local labour","Local labour","Main d'œuvre locale","Trabajo local","عمالة محلية"]
[null,null,"Seasonal local labour","Seasonal local labour","Travaillleur local saisonnier","Trabajo estacional","عمالة محلية موسمية"]
[null,null,"Seasonal labour from afar","Seasonal labour from afar","Travaillleur saisonnier venant de loin","Trabajo estacional desde lejos","عمالة موسمية قادمة من بعيد"]
[null,null,"How many people lose traditional means of subsistence (not those in the project)?","How many people lose traditional means of subsistence (not those in the project)?","Combien de personnes perdent leurs moyens de subsistance traditionnels (pas ceux du projet)?","¿Cuántas personas pierden los medios tradicionales de subsistencia (no los que están en el proyecto)?","كم عدد الأشخاص الذين يفقدون وسائل العيش التقليدية (ليست تلك الموجودة في المشروع)؟"]
[null,null,"How many jobs are created by the project?","How many jobs are created by the project?","Combien d'emplois sont créés par le projet?","¿Cuántos empleos son creados por el proyecto?","كم عدد الوظائف التي تم إنشاؤها بواسطة المشروع؟"]
[null,null,"How many years are they expected to last?","How many years are they expected to last?","Combien d'années devraient-ils durer?","¿Cuántos años se espera que duren?","كم سنة من المتوقع أن تستمر؟"]
[null,null,"What are the estimated population growth numbers over the life of the assets?","What are the estimated population growth numbers over the life of the assets?","Quels sont les chiffres de croissance démographique estimés sur la durée de vie des actifs?","¿Cuáles son las cifras estimadas de crecimiento de la población durante la vida de los activos?","ما هي أرقام النمو السكاني المقدرة على مدى عمر الأصول؟"]
[null,null,"What are the estimated migrant proportion due to the project over the life of the assets?","What are the estimated migrant proportion due to the project over the life of the assets?","Quelle est la proportion estimée de migrants due au projet sur la durée de vie des actifs?","¿Cuál es la proporción estimada de migrantes debido al proyecto durante la vida útil de los activos?","ما هي نسبة المهاجرين المقدرة بسبب المشروع على مدى عمر الأصول؟"]
[null,null,"per year","per year","Par an ","al año","كل سنة"]
[null,null,"years","years","Années","años","سنوات"]
[null,null,"What is the tenure breakdown of the farmers?","What is the tenure breakdown of the farmers?","Quelle est la répartition du mandat des agriculteurs?","¿Cuál es el desglose de la tenencia de los agricultores?","ما هو تقسيم حيازة الأراضي على المزارعين؟"]
[null,null,"Landowner","Landowner","Propriétaires","Terrateniente","مالك الأرض"]
[null,null,"Tenant farmer","Tenant farmer","Fermier locataire","Arrendatario agrícola","مزارع مستأجر"]
[null,null,"Tenant farmer on government land","Tenant farmer on government land","Fermier locataire sur les terres du gouvernement","Arrendatario agrícola en tierra de gobierno","مزارع مستأجر على أرض حكومية"]
[null,null,"Worker / Labourer","Worker / Labourer","Ouvrier / ouvrier","Trabajador / Obrero","عامل"]
[]
[null,{"$f":"$C$10","v":"3 OUTPUT-Graphs"},"PROMOTE and INITIATE – Impact Assessment Tool","PROMOTE and INITIATE – Impact Assessment Tool","PROMOTION et INITIATION - Outil d’évaluation d’impact","PROMUEVE – Herramienta de evaluación de impacto","الترويج و المبادرة - أداة تقييم الأثر"]
[null,null,"POSITIVITY SCORE on \nSocio-economic & Environmental Impacts of the Project","POSITIVITY SCORE on \nSocio-economic & Environmental Impacts of the Project","SCORE DE POSITIVITÉ \nsur impacts socio-économiques et environnementaux du projet","PUNTUACIÓN DE POSITIVIDAD en\u000bImpactos socioeconómicos y ambientales del proyecto","النقاط الإيجابية على\nالآثار الاجتماعية والاقتصادية والبيئية للمشروع"]
[null,null,"Socioeconomic Balance of Beneficiaries","Socioeconomic Balance of Beneficiaries","Équilibre socioéconomique des bénéficiaires","Balance Socioeconómico de Beneficiarios","التوازن الاجتماعي والاقتصادي للمستفيدين"]
[null,null,"Land Ownership Breakdown of Project Beneficiaries","Land Ownership Breakdown of Project Beneficiaries","Répartition de la propriété foncière des bénéficiaires du projet","Desglose de la propiedad de la tierra de los beneficiarios del proyecto","توزيع ملكية الأراضي للمستفيدين من المشروع"]
[null,null,"Gender Balance of Impacted Farmers","Gender Balance of Impacted Farmers","Équilibre hommes-femmes des agriculteurs touchés","Balance de género de los agricultores afectados","التوازن بين الجنسين للمزارعين المتأثرين"]
[null,null,0]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$593,ROW()-ROW($B$5),FALSE)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]

{"sheet":"VERSION CONTROL","index":5,"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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":6,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Impact","Score YES","Score NO"]
[{"$f":"Translate!$C$152","v":"Positive impact is very likely"},5,1]
[{"$f":"Translate!$C$153","v":"Positive impact possible"},2,1]
[{"$f":"Translate!$C$154","v":"No impact likely"},1,1]
[{"$f":"Translate!$C$155","v":"Negative impact possible"},-2,4]
[{"$f":"Translate!$C$156","v":"Negative impact very likely"},-5,5,null,null,null,{"$f":"B6*B9*B15","v":7.5}]
[]
["Weighting","Linear Multiplier"]
[{"$f":"Translate!$C$149","v":"High"},1.5]
[{"$f":"Translate!$C$150","v":"Medium"},1]
[{"$f":"Translate!$C$151","v":"Low"},0.5]
[]
["Weighting","Linear Multiplier"]
[{"$f":"Translate!$C$146","v":"Yes"},1]
[{"$f":"Translate!$C$147","v":"No"},-1]
[{"$f":"Translate!$C$148","v":"N/A"},{"$f":"Translate!$C$148","v":"N/A"}]
[]
["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"]